Contractors on Final Inspection for Contracts
Field Name |
Caption |
Mask |
Description |
Field Type |
XV_COMMENT1 |
Long Note |
|
Long Note |
Memo |
XV_CONT_CD |
Contractor |
10x |
Contractor |
String |
XV_CONT_TY |
Contractor Text |
60x |
Contractor Text |
String |
XV_CRT_BY |
Created By |
25x |
Created By |
String |
XV_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
DateTime |
XV_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
XV_ID |
FInal Inspection Contractors Rec # |
nnnnnnnn |
FInal Inspection Contractors AutoID |
Long Integer |
XV_MOD_BY |
Last Modified By |
25x |
Last Modified By |
String |
XV_MOD_DT |
Last Modified Date |
mm/dd/yyyy hh:mm am |
Last Modified Date |
DateTime |
XV_MOD_TM |
Modified Time |
mm/dd/yyyy hh:mm am |
Modified Time |
DateTime |
XV_PDAY |
Permit Day |
nnn |
Permit Day |
integer |
XV_PDAYS |
Total Permitted Days |
nnn |
Total Permitted Days |
integer |
XV_POTHER |
Other Permit |
|
Other Permit |
Boolean |
XV_PSEWER |
Sewer Permit |
|
Sewer Permit |
Boolean |
XV_PSTORM |
Stormwater Permit |
|
Stormwater Permit |
Boolean |
XV_PTRANS |
Transportation Permit |
|
Transportation Permit |
Boolean |
XV_PWATER |
Water Permit |
|
Water Permit |
Boolean |
XV_ROWVER |
Rowversion for optimistic locking |
|
Rowversion for optimistic locking |
TimeStamp |
XV_SUP_CELL |
Super Cell Phone |
25x |
Super Cell Phone |
String |
XV_SUPER |
Superintendant Name |
50x |
Superintendant Name |
String |
XV_WK_PHN |
Contractor Work Phone |
25x |
Contractor Work Phone |
String |
XV_XP_ID |
Final Inspection Rec # - Link to WKPROJCF table |
nnnnnnnn |
Long Integer |