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. Note: Do not remove the row for the default QTYUNIT_ID C62 (the unitless unit).


Column Description(s):
Column NameColumn TypeDescription
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 NameIndexed Column NamesIndex Type
SQL050212031302510 QTYUNIT_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign 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

Feedback