ALEX_CLIENTS (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 |
| CLIENT_CODE | VARCHAR (40) | Yes* | Yes | ALCO_CLIENTS.CLIENT_CODE | Client code |
| CLIENT _NAME | VARCHAR (200) | Yes | Yes | ALCO_CLIENTS.CLIENT_NAME | Name of client |
| ACTIVE_STATUS | SMALLINT | Yes* | Yes | ALCO_CLIENTS.CLIENT_ACTIVE_STATUS | Determines whether this client is active or non-active.
|
*System required field
** Value must be unique