Stores Asset Limit List for Work Asset
Field Name |
Default Caption |
Mask |
Description |
Field Type |
ADR_CRT_BY |
Created By |
25x |
Created By |
Text |
ADR_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
ADR_DIR |
Street Dir |
2x |
Address - Direction |
Text |
ADR_IA |
Street Index |
255x |
Index Address |
Text |
ADR_ID |
Street Rec # |
nnnnnnnn |
Unique ID |
Long Integer |
ADR_MAPPAGE |
Map Page |
15x |
Map Page |
Text |
ADR_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
ADR_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
ADR_MOD_TM |
Last Modified Time |
hh:mm am |
Last Modified Time |
Date/Time |
ADR_PT |
Prefix Type |
5x |
Address Street Direction |
Text |
ADR_ROWVER |
|
mm/dd/yyyy hh:mm am |
Rowversion for optimistic locking |
TimeStamp |
ADR_SFX |
Street Suffix |
5x |
Address - Suffix |
Text |
ADR_STR |
Street Name |
50x |
Address - Street Name |
Text |
ADR_TY |
Street Type |
4x |
Address - Street Type |
Text |
OID |
|
|
Visual CE Linking Field |
Long Integer |