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
  • 1 = Active
  • 0 = Inactive

*System required field

** Value must be unique