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