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.
|
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