ALEX_COMPANY (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 |
| COMPANY_CODE | VARCHAR (60) | Yes* | Yes | ALCO_COMPANY.COMPANY_CODE | Company code |
| COMPANY_NAME | VARCHAR (255) | Yes* | Yes | ALCO_COMPANY.COMPANY_NAME | Name of company |
| ACTIVE_STATUS | SMALLINT | Yes* | Yes | ALCO_COMPANY.ACTIVE_STATUS | Determines whether company is active.
|
*System required field
** Value must be unique