PTPARTHC

Part Hazard Codes

Field Name

Caption

Mask

Description

Field Type

HC_CRT_BY

Created By

25x

Created By

Text

HC_CRT_DTTM

Creation Date Time

mm/dd/yyyy hh:mm am

Creation Date Time

Date/Time

HC_DOC_FLG

Document Available

 

Document Available

Boolean

HC_HC_CD

Hazard Code

5x

Hazard Code

Text

HC_HC_TY

Hazard Code Text

50x

Hazard Code Text

Text

HC_ID

Hazard Code Rec #

nnnnnnnn

Hazard Code Rec ID

Long Integer

HC_MOD_BY

Last Modified By

25x

Last Modified By

Text

HC_MOD_DT

Last Modified Date

mm/dd/yyyy

Last Modified Date

Date/Time

HC_MOD_TM

Last Modified Time

hh:mm am

Modified Time

Date/Time

HC_PA_ID

Parts Rec #

nnnnnnnn

Link to PTPARTS.PA_ID

Long Integer

HC_ROWVER

 

 

Rowversion for optimistic locking

TimeStamp