Inspection for Contracts
Field Name |
Caption |
Mask |
Description |
Field Type |
XO_COMMENT1 |
Long Note |
|
Long Note |
Memo |
XO_CONT_CD |
Contractor |
10x |
Contractor |
String |
XO_CONT_TY |
Contractor Text |
60x |
Contractor Text |
String |
XO_CRT_BY |
Created By |
25x |
Created By |
String |
XO_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
DateTime |
XO_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
XO_ID |
DI Contractors Rec # |
nnnnnnnn |
DI Contractors AutoID |
Long Integer |
XO_MOD_BY |
Last Modified By |
25x |
Last Modified By |
String |
XO_MOD_DT |
Last Modified Date |
mm/dd/yyyy hh:mm am |
Last Modified Date |
DateTime |
XO_MOD_TM |
Modified Time |
mm/dd/yyyy hh:mm am |
Modified Time |
DateTime |
XO_PDAY |
Permit Day |
nnn |
Permit Day |
integer |
XO_PDAYS |
Total Permitted Days |
nnn |
Total Permitted Days |
integer |
XO_POTHER |
Other Permit |
|
Other Permit |
Boolean |
XO_PSEWER |
Sewer Permit |
|
Sewer Permit |
Boolean |
XO_PSTORM |
Stormwater Permit |
|
Stormwater Permit |
Boolean |
XO_PTRANS |
Transportation Permit |
|
Transportation Permit |
Boolean |
XO_PWATER |
Water Permit |
|
Water Permit |
Boolean |
XO_ROWVER |
Rowversion for optimistic locking |
|
Rowversion for optimistic locking |
TimeStamp |
XO_SUP_CELL |
Super Cell Phone |
25x |
Super Cell Phone |
String |
XO_SUPER |
Superintendant Name |
50x |
Superintendant Name |
String |
XO_WK_PHN |
Contractor Work Phone |
25x |
Contractor Work Phone |
String |
XO_XN_ID |
Daily Inspection Rec # - Link to WKPROJCI table |
nnnnnnnn |
Long Integer |