Sewer FOG Hauler Vehicles
Field Name |
Caption |
Mask |
Description |
Field Type |
HV_ACTIVE |
Active |
|
Active Vehicle |
Boolean |
HV_COMMENT |
Short Comment |
254x |
Short Comment |
Text |
HV_CRT_BY |
Created By |
25x |
Created By |
Text |
HV_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
HV_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
HV_DOT |
DOT # |
30x |
DOT # |
Text |
HV_EXP_DT |
Permit Expiration Date |
mm/dd/yyyy |
Permit Expiration Date |
Date/Time |
HV_HA_ID |
Hauler Record No |
nnnnnnnn |
Long Integer |
|
HV_ID |
Vehicle Record No |
nnnnnnnn |
Vehicle Record Number |
Long Integer |
HV_LICENSE |
License Number |
30x |
License Number |
Text |
HV_MAN_CD |
Manuf |
10x |
Manufacturer |
Text |
HV_MAN_TY |
Manuf Name |
60x |
Manufacturer Text |
Text |
HV_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
HV_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
HV_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
HV_MODEL |
Model |
30x |
Model Number |
Text |
HV_NUMBER |
Vehicle Number |
20x |
Vehicle Number |
Text |
HV_OVID |
O.V.I.D |
30x |
O.V.I.D |
Text |
HV_PERMIT |
Permitted |
|
Permitted |
Boolean |
HV_RET_DT |
Retired Date |
mm/dd/yyyy |
Retired Date |
Date/Time |
HV_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
HV_TSIZE |
Tank Size |
nnnnn |
Tank Size |
Integer |
HV_TYPE_CD |
Vehicle Type |
nnn |
Vehicle Type |
Integer |
HV_TYPE_TY |
Vehicle Type Text |
30x |
Vehicle Type Text |
Text |
HV_VIN |
VIN |
50x |
Vehicle Identification Number |
Text |
HV_YEAR |
Year |
30x |
Year |
Text |