Database Table: QTYUNIT

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