ALEX_UNIT_OF_MEASURE (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 |
| UOM_COD | VARCHAR (255) | Yes* | Yes | ALCO_UNIT_OF_MEASURE.UOM_CODE | Unit of measure code |
| DESCRIPTION | VARCHAR (255) | Yes* | Yes | ALCO_UNIT_OF_MEASURE.DESCRIPTION | Description of the unit of measure |
| ACTIVE_STATUS | SMALLINT | Yes* | Yes | ALCO_UNIT_OF_MEASURE.ACTIVE_STATUS | Determines whether unit of measure is active
|
*System required field
** Value must be unique