Contractors on Daily Inspection for Projects
Field Name |
Caption |
Mask |
Description |
Field Type |
ZY_COMMENT1 |
Long Note |
|
Long Note |
Memo |
ZY_CONT_CD |
Contractor |
10x |
Contractor |
Text |
ZY_CONT_TY |
Contractor Text |
60x |
Contractor Text |
Text |
ZY_CRT_BY |
Created By |
25x |
Created By |
Text |
ZY_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
DateTime |
ZY_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
ZY_ID |
DI Contractors Rec # |
nnnnnnnn |
DI Contractors Rec # AutoID |
Long Integer |
ZY_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
ZY_MOD_DT |
Last Modified Date |
mm/dd/yyyy hh:mm am |
Last Modified Date |
DateTime |
ZY_MOD_TM |
Modified Time |
mm/dd/yyyy hh:mm am |
Modified Time |
DateTime |
ZY_PDAY |
Permit Day |
nnn |
Permit Day |
Integer |
ZY_PDAYS |
Total Permitted Days |
nnn |
Total Permitted Days |
Integer |
ZY_POTHER |
Other Permit |
|
Other Permit |
Boolean |
ZY_PSEWER |
Sewer Permit |
|
Sewer Permit |
Boolean |
ZY_PSTORM |
Stormwater Permit |
|
Stormwater Permit |
Boolean |
ZY_PTRANS |
Transportation Permit |
|
Transportation Permit |
Boolean |
ZY_PWATER |
Water Permit |
|
Water Permit |
Boolean |
ZY_ROWVER |
Rowversion for optimistic locking |
|
Rowversion for optimistic locking |
TimeStamp |
ZY_SUP_CELL |
Super Cell Phone |
25x |
Super Cell Phone |
Text |
ZY_SUPER |
Superintendant Name |
50x |
Superintendant Name |
Text |
ZY_WK_PHN |
Contractor Work Phone |
25x |
Contractor Work Phone |
Text |
ZY_ZZ_ID |
Daily Inspection Rec # - Link to WKPROJDI table |
nnnnnnnn |
Daily Inspection Rec # - Link to WKPROJDI |
Long Integer |