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 Description(s):
Column Name | Column Type | Description |
QTYUNIT_ID |
CHAR(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. |
FIELD1 |
VARCHAR(254) |
Customizable. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031302510 |
QTYUNIT_ID |
Primary Key |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_1018 |
QTYUNIT_ID |
ATTRIBUTE |
QTYUNIT_ID |
Cascade |
F_1017 |
QTYUNIT_ID |
ATTRVALUE |
QTYUNIT_ID |
Cascade |
F_107 |
QUANTITYMEASURE |
BASEITEM |
QTYUNIT_ID |
Cascade |
F_178 |
QTYUNIT_ID |
CALSCALE |
QTYUNIT_ID |
Cascade |
F_206 |
QUANTITYMEASURE |
CATENTSHIP |
QTYUNIT_ID |
Cascade |
F_207 |
SIZEMEASURE |
CATENTSHIP |
QTYUNIT_ID |
Cascade |
F_208 |
WEIGHTMEASURE |
CATENTSHIP |
QTYUNIT_ID |
Cascade |
F_1183 |
QTYUNIT_ID |
DKPDCCOMPLIST |
QTYUNIT_ID |
Cascade |
F_394 |
QUANTITYMEASURE |
INVENTORY |
QTYUNIT_ID |
Cascade |
F_425 |
WEIGHTMEASURE |
MANIFEST |
QTYUNIT_ID |
Cascade |
F_469 |
QTYUNIT_ID |
OFFER |
QTYUNIT_ID |
Cascade |
F_572 |
QTYUNIT_ID |
PATTRVALUE |
QTYUNIT_ID |
Cascade |
F_640 |
QTYUNIT_ID_FROM |
QTYCONVERT |
QTYUNIT_ID |
Cascade |
F_641 |
QTYUNIT_ID_TO |
QTYCONVERT |
QTYUNIT_ID |
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 |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.