WebSphere Commerce database table: QTYUNITMAP

Each row of this table maps a QuantityUnit (defined in the QTYUNIT table) to a unit of measurement code defined in an external standard.


Column Description(s):
Column NameColumn TypeDescription
UOMSTANDARD VARCHAR(32) NOT NULL The external standard.
UOMCODE VARCHAR(16) NOT NULL The unit of measurement code for the external standard.
QTYUNIT_ID CHAR(16) NOT NULL The QuantityUnit.
FIELD1 VARCHAR(254) Customizable.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000199 QTYUNIT_ID+UOMSTANDARD Unique Index
SQL050212031302850 UOMSTANDARD+UOMCODE Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_649 QTYUNIT_ID QTYUNIT QTYUNIT_ID Cascade

Feedback