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