Sewer IPT Monitoring Point Billing Test Performance
Field Name |
Caption |
Mask |
Description |
Field Type |
HT_BH_ID |
MP Billing History Rec # |
nnnnnnnn |
Long Integer |
|
HT_CRT_BY |
Created By |
25x |
Created By |
Text |
HT_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
HT_FEE |
Inspection Fee |
nnnnnnnn.nn |
Inspection Fee |
Double |
HT_ID |
MP Billing Test Perf Rec |
nnnnnnnn |
MP Billing Test Perfermance Rec # |
Long Integer |
HT_MOD_BY |
Last Mod By |
25x |
Last Modified By |
Text |
HT_MOD_DT |
Last Mod Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
HT_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
HT_PARA_CD |
Parameter |
5x |
Parameter |
Text |
HT_PARA_TY |
Parameter Text |
60x |
Parameter Text |
Text |
HT_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |