Database Table: 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 Name Column Type Column Description
FIELD1 VARCHAR (254)
NULL
Customizable.
QTYUNIT_ID CHARACTER (16)
NOT NULL
The QuantityUnit.
UOMCODE VARCHAR (16)
NOT NULL
The unit of measurement code for the external standard.
UOMSTANDARD VARCHAR (32)
NOT NULL
The external standard.
Indexes:
Index Name Indexed Column Names Index Type
I0000199 QTYUNIT_ID, UOMSTANDARD Unique Index
SQL030416035046040 UOMSTANDARD, UOMCODE Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_649 QTYUNIT_ID QTYUNIT QTYUNIT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable