Each row of this table represents a QuantityUnit. A QuantityUnit is
a unit of measurement, such as kilogram, meter, liter, pound, foot, quart, and
so on.
Note: Do not remove the row for the default QTYUNIT_ID C62 (the unitless
unit).
Column Name |
Column Type |
Column Description |
FIELD1 |
VARCHAR (254)
NULL |
Customizable. |
QTYUNIT_ID |
CHARACTER (16)
NOT NULL |
A uniquely assigned identifier. Several identifiers are defined, as
specified in the UN/CEFACT Working Party on Facilitation of International Trade
Procedures (WP.4), Recommendation No. 20, Codes for Units of Measure Used in
International Trade. |
Indexes:
Index Name |
Indexed Column Names |
Index Type |
SQL030416035045340 |
QTYUNIT_ID |
Primary Key |
Constraints:
Constraint Name |
Column Names |
Foreign Table Name |
Foreign Column Names |
Constraint Type |
Not Applicable |
Referenced By:
Constraint Name |
Referenced Column Name |
Foreign Table Name |
Foreign Column Names |
Constraint Type |
F_1017 |
QTYUNIT_ID |
ATTRVALUE |
QTYUNIT_ID |
Cascade |
F_1018 |
QTYUNIT_ID |
ATTRIBUTE |
QTYUNIT_ID |
Cascade |
F_107 |
QTYUNIT_ID |
BASEITEM |
QUANTITYMEASURE |
Cascade |
F_178 |
QTYUNIT_ID |
CALSCALE |
QTYUNIT_ID |
Cascade |
F_206 |
QTYUNIT_ID |
CATENTSHIP |
QUANTITYMEASURE |
Cascade |
F_207 |
QTYUNIT_ID |
CATENTSHIP |
SIZEMEASURE |
Cascade |
F_208 |
QTYUNIT_ID |
CATENTSHIP |
WEIGHTMEASURE |
Cascade |
F_394 |
QTYUNIT_ID |
INVENTORY |
QUANTITYMEASURE |
Cascade |
F_425 |
QTYUNIT_ID |
MANIFEST |
WEIGHTMEASURE |
Cascade |
F_469 |
QTYUNIT_ID |
OFFER |
QTYUNIT_ID |
Cascade |
F_572 |
QTYUNIT_ID |
PATTRVALUE |
QTYUNIT_ID |
Cascade |
F_640 |
QTYUNIT_ID |
QTYCONVERT |
QTYUNIT_ID_FROM |
Cascade |
F_641 |
QTYUNIT_ID |
QTYCONVERT |
QTYUNIT_ID_TO |
Cascade |
F_646 |
QTYUNIT_ID |
QTYFORMAT |
QTYUNIT_ID |
Cascade |
F_648 |
QTYUNIT_ID |
QTYUNITDSC |
QTYUNIT_ID |
Cascade |
F_649 |
QTYUNIT_ID |
QTYUNITMAP |
QTYUNIT_ID |
Cascade |
F_679 |
QTYUNIT_ID |
RFQPROD |
QTYUNIT_ID |
Cascade |
F_688 |
QTYUNIT_ID |
RFQRSPPROD |
QTYUNIT_ID |
Cascade |
