| Data element |
Definition |
LN_KEY
Indexed - yes
Format - number
May be null? yes |
Unique system-assigned key that identifies a location name record. |
LOC_CODE
Indexed - yes
Format - char(5)
May be null? yes |
Code associated with the location in Concur. |
LOC_CODE_IS_DELETED
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether the location code record has been deleted from Concur. |
LOC_CODE_LAST_MODIFIED
Indexed - no
Format - date
May be null? yes |
Date on which the location code record was last modified. |
LOC_CTRY_CODE
Indexed - yes
Format - char(2)
May be null? yes |
Unique 2-character ISO code-that identifies the location’s country. |
LOC_CTRY_SUB_CODE
Indexed - yes
Format - varchar2(6)
May be null? yes |
Unique code identifying the location’s country subdivision (e.g., State, Province, Region). |
LOC_KEY
Indexed - yes
Format - number
May be null? no |
Unique system-assigned key that identifies a location record within Concur. |
LOC_NAME_IS_DELETED
Indexed - no
Format - char(1)
May be null? yes |
Indicates whether the location name record has been deleted from Concur. |
LOC_NAME_LAST_MODIFIED
Indexed - no
Format - date
May be null? yes |
Date on which the location name record was last modified. |
LOCATION_NAME
Indexed - no
Format - varchar2(64)
May be null? yes |
Name of the location. |
