Equipment on Daily Inspection for Projects
Field Name |
Caption |
Mask |
Description |
Field Type |
ZX_COMMENT1 |
Long Note |
|
Long Note |
Memo |
ZX_CRT_BY |
Created By |
25x |
Created By |
Text |
ZX_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
DateTime |
ZX_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
ZX_ECNT |
Equipment Count |
nnn |
Equipment Count |
Integer |
ZX_EQP_CD |
Equipment |
nnn |
Equipment |
Integer |
ZX_EQP_TY |
Equipment Text |
100x |
Equipment Text |
Text |
ZX_ID |
DI Equipment Rec # |
nnnnnnnn |
DI Equipment Rec # AutoID |
Long Integer |
ZX_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
ZX_MOD_DT |
Last Modified Date |
mm/dd/yyyy hh:mm am |
Last Modified Date |
DateTime |
ZX_MOD_TM |
Modified Time |
mm/dd/yyyy hh:mm am |
Modified Time |
DateTime |
ZX_ROWVER |
Rowversion for optimistic locking |
|
Rowversion for optimistic locking |
TimeStamp |
ZX_STAT_CD |
Equipment Status |
nnn |
Equipment Status |
Integer |
ZX_STAT_TY |
Equipment Status Text |
100x |
Equipment Status Text |
Text |
ZX_ZZ_ID |
Daily Inspection Rec # - Link to WKPROJDI table |
nnnnnnnn |
Daily Inspection Rec # - Link to WKPROJDI.ZZ_ID |
Long Integer |