Sewer IPT Inspection Test List Detail Setup
Field Name |
Caption |
Mask |
Description |
Field Type |
ID_CRT_BY |
Created By |
25x |
Created By |
Text |
ID_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
ID_ID |
IPT Test Detail Rec # |
nnnnnnnn |
Autonumber ID |
Long Integer |
ID_IL_ID |
Test List Record No |
nnnnnnnn |
Long Integer |
|
ID_ITEM |
Item |
30x |
Checklist Items |
Text |
ID_MAVE |
Monthly Average |
nnnnnnnn.nn |
Monthly Average |
Double |
ID_ML |
Minimum Limit |
nnnnnnnn.nn |
Minimum Limit |
Double |
ID_MOD_BY |
Last Mod By |
25x |
Last Modified By |
Text |
ID_MOD_DT |
Last Mod Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
ID_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
ID_MSL |
Max Surcharge Limit |
nnnnnnnn.nn |
Maximum Surcharge Limit |
Double |
ID_NUMBER |
Line Number |
nnnn |
Line Number |
Integer |
ID_PL |
Permit Limit |
nnnnnnnn.nn |
Permit Limit |
Double |
ID_QAVE |
Quarterly Average |
nnnnnnnn.nn |
Quarterly Average |
Double |
ID_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
ID_SL |
Surcharge Limit |
nnnnnnnn.nn |
Surcharge Limit |
Double |
ID_UOM_CD |
UOM |
10x |
UOM |
Text |
ID_UOM_TY |
UOM Text |
60x |
UOM Text |
Text |
ID_WAVE |
Weekly Average |
nnnnnnnn.nn |
Weekly Average |
Double |