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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000199 | QTYUNIT_ID, UOMSTANDARD | Unique Index |
SQL030416035046040 | UOMSTANDARD, UOMCODE | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_649 | QTYUNIT_ID | QTYUNIT | QTYUNIT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|