Contractors on Final Inspection for Projects
Field Name |
Caption |
Mask |
Description |
Field Type |
ZT_COMMENT1 |
Long Note |
|
Long Note |
Memo |
ZT_CONT_CD |
Contractor |
10x |
Contractor |
Text |
ZT_CONT_TY |
Contractor Text |
60x |
Contractor Text |
Text |
ZT_CRT_BY |
Created By |
25x |
Created By |
Text |
ZT_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
DateTime |
ZT_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
ZT_ID |
FInal Inspection Projects Rec # |
nnnnnnnn |
FInal Inspection Projects Rec # AutoID |
Long Integer |
ZT_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
ZT_MOD_DT |
Last Modified Date |
mm/dd/yyyy hh:mm am |
Last Modified Date |
DateTime |
ZT_MOD_TM |
Modified Time |
mm/dd/yyyy hh:mm am |
Modified Time |
DateTime |
ZT_PDAY |
Permit Day |
nnn |
Permit Day |
Integer |
ZT_PDAYS |
Total Permitted Days |
nnn |
Total Permitted Days |
Integer |
ZT_POTHER |
Other Permit |
|
Other Permit |
Boolean |
ZT_PSEWER |
Sewer Permit |
|
Sewer Permit |
Boolean |
ZT_PSTORM |
Stormwater Permit |
|
Stormwater Permit |
Boolean |
ZT_PTRANS |
Transportation Permit |
|
Transportation Permit |
Boolean |
ZT_PWATER |
Water Permit |
|
Water Permit |
Boolean |
ZT_ROWVER |
Rowversion for optimistic locking |
|
Rowversion for optimistic locking |
TimeStamp |
ZT_SUP_CELL |
Super Cell Phone |
25x |
Super Cell Phone |
Text |
ZT_SUPER |
Superintendant Name |
50x |
Superintendant Name |
Text |
ZT_WK_PHN |
Contractor Work Phone |
25x |
Contractor Work Phone |
Text |
ZT_ZU_ID |
Final Inspection Rec # - Link to WKPROJFI table |
nnnnnnnn |
Final Inspection Rec # - Link to WKPROJFI table |
Long Integer |