ALEX_ADDRESS (Staging table)

Column name Data type Required Default updateable Data target Comments
EXTERNAL_KEY** VARCHAR (255) Yes* No ALCO_EXTERNAL_KEY.EXTERNAL_KEY External key – primary key
ADDRESS_NAME** VARCHAR (255) Yes* Yes ALCO_ADDRESS.ADDRESS_NAME Address name
LOCATION_NAME VARCHAR (255) No Yes ALCO_ADDRESS.LOCATION_NAME Location name
ADDR_LINE_1 VARCHAR (255) No Yes ALCO_ADDRESS_ADDR_LINE_1 Address line 1
ADDR_LINE_2 VARCHAR (255) No Yes ALCO_ADDRESS.ADDR_LINE2 Address line 2
CITY_NAME VARCHAR (255) No Yes ALCO_ADDRESS.CITY_NAME City name
STATE_EKEY VARCHAR (255) No Yes ALCO_ADDRESS.STATE_ID State external key
ZIP_CODE VARCHAR (20) No Yes ALCO_ADDRESS.ZIP_CODE Zip or postal code
COUNTRY_EKEY VARCHAR (255) No Yes ALCO_ADDRESS.COUNTRY_ID Country external key
PHONE_NBR VARCHAR (255) No Yes ALCO_ADDRESS.PHONE_NBR Phone number
URL VARCHAR (255) No Yes ALCO_ADDRESS.URL URL
ACTIVE_STATUS SMALLINT Yes* Yes ALCO_ADDRESS.ACTIVE_STATUS Determines whether address is active.
  • 1 = Active
  • 0 = Inactive
COMPANY_EKEY VARCHAR (255) No Yes ALCO_ADDRESS.PARENT_ID Company external key
CONTACT_NAME VARCHAR (255) No Yes ALCO_ADDRESS.CONTACT_NAME Contact name
CONTACT_ EMAIL_ADDRESS VARCHAR (255) No Yes ALCO_ADDRESS.CONTACT_EMAIL_ADDRESS Contact e-mail address
CONTACT_ PHONE_NUMBER VARCHAR (255) No Yes ALCO_ADDRESS.CONTACT_PHONE_NUMBER Contact phone number
EXTERNAL_SYS_ID VARCHAR (255) No Yes ALCO_ADDRESS.EXTERNAL_SYS_ID Corresponding address ID in external system
SUGGEST_IN_MAP VARCHAR(255) No Yes ALCO_ADDRESS.SUGGEST_IN_MAP This column stores the flag value(whether to display the address or not in Mileage expense type).

*System required field

** Value must be unique