QTYUNITMAP

Each row of this table maps a QuantityUnit (defined in the QTYUNIT table) to a unit of measurement code defined in an external standard.

Column Descriptions:

NameTypeDescription
UOMSTANDARDVARCHAR (32) NOT NULLThe external standard.
UOMCODEVARCHAR (16) NOT NULLThe unit of measurement code for the external standard.
QTYUNIT_IDCHAR (16) NOT NULLThe QuantityUnit.
FIELD1VARCHAR (254)Customizable.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>UOMSTANDARD+UOMCODEPrimary Key
I0000199QTYUNIT_ID+UOMSTANDARDUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_649QTYUNIT_IDQTYUNITQTYUNIT_IDCascade