WebSphere Commerce 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.

Do not remove the row for the default QTYUNIT_ID C62 (the unitless unit).

Column Descriptions
Column Name Column Type Description
QTYUNIT_ID CHAR(16) NOT NULL A uniquely assigned identifier. Several identifiers are defined. They are specified in the UN/CEFACT Working Party. Which is 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.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235240260 QTYUNIT_ID Primary Key

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names 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