Sewer FOG Hauler Contacts
Field Name |
Caption |
Mask |
Description |
Field Type |
HC_COMMENT |
Short Comment |
254x |
Short Comment |
Text |
HC_CONT_CD |
Contact Type |
nnn |
Contact Type |
Integer |
HC_CONT_TY |
Contact Type Text |
30x |
Contact Type Text |
Text |
HC_CRT_BY |
Created By |
25x |
Created By |
Text |
HC_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
HC_DOC_FLG |
Document Available |
|
Document Flag |
Boolean |
HC_EMAIL |
150x |
Text |
||
HC_EPHONE |
Emergency Phone |
25x |
Emergency Phone |
Text |
HC_FAX |
Fax Phone |
25x |
Fax |
Text |
HC_HA_ID |
Hauler Record No |
nnnnnnnn |
Long Integer |
|
HC_ID |
Hauler Contact Rec # |
nnnnnnnn |
Hauler Contact Record Number |
Long Integer |
HC_MOBILE |
Cell Phone |
25x |
Mobile/Cell Phone |
Text |
HC_MOD_BY |
Last Mod By |
25x |
Last Modified By |
Text |
HC_MOD_DT |
Last Mod Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
HC_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
HC_NAME |
Name |
50x |
Name |
Text |
HC_PHONE |
Phone |
25x |
Phone |
Text |
HC_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
HC_TITL_CD |
Title |
nnn |
Title |
Integer |
HC_TITL_TY |
Title Text |
30x |
Title Text |
Text |