Reference > Database > WebSphere Commerce database tables > Q
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 Name Column Type Description 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.
Indexes Index Name Indexed Column Names Index Type I0000199 QTYUNIT_ID+UOMSTANDARD Unique Index SQL100520030419920 UOMSTANDARD+UOMCODE Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_649 QTYUNIT_ID QTYUNIT QTYUNIT_ID Cascade
Related reference
_vcc_freeselect_bottom_