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.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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