Service Lateral Addresses
Field Name |
Caption |
Mask |
Description |
Field Type |
SA_ADD_NO |
Address No |
nn |
Address Count |
Integer |
SA_ADDID |
Address Rec # |
nnnnnnnn |
Long Integer |
|
SA_ADR_APT |
Apartment No |
25x |
Apartment Number |
Text |
SA_ADR_B2 |
Street Post Bldg No |
8x |
Street Post Building No |
Text |
SA_ADR_BDG |
Address |
nnnnnn |
Address : Building Number |
Long Integer |
SA_ADR_BDG |
Address |
nnnnnn |
Address : Building Number |
Long Integer |
SA_ADR_DIR |
Street Direction |
2x |
Address - Direction |
Text |
SA_ADR_PT |
Street Prefix Type |
5x |
Street Prefix Type |
Text |
SA_ADR_SFX |
Street Suffix |
5x |
Address - Suffix |
Text |
SA_ADR_STR |
Street Name |
50x |
Address - Street Name |
Text |
SA_ADR_STR |
Street Name |
50x |
Address - Street Name |
Text |
SA_ADR_TY |
Street Type |
5x |
Address - Street Type |
Text |
SA_CRT_BY |
Created By |
25x |
Created By |
Text |
SA_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
SA_DOC_FLG |
Document Available |
|
Document Available |
Boolean |
SA_ID |
Serv Address Rec # |
nnnnnnnn |
Unique ID |
Long Integer |
SA_LOCATIO |
Gen Location |
100x |
General Location |
Text |
SA_LOT |
Lot Number |
20x |
Lot Number |
Text |
SA_MOD_BY |
Modified By |
25x |
Modified By |
Text |
SA_MOD_DT |
Modified Date |
mm/dd/yyyy |
Modified Date |
Date/Time |
SA_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
SA_PROPTAG |
Property ID Tag |
52x |
Property ID Tag |
Text |
SA_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
SA_SUBD_CD |
Subdivision |
10x |
Subdivision |
Text |
SA_SUBD_TY |
Subdivision Text |
60x |
Subdivision Text |
Text |
SA_SV_ID |
Serv Lateral Rec # |
nnnnnnnn |
Long Integer |