Reference > Database > WebSphere Commerce database tables > Q


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 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
SQL100520030419610 QTYUNIT_ID Primary Key

Referenced By
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_3559 QTYUNIT_ID ATTRDESC QTYUNIT_ID Cascade
F_1018 QTYUNIT_ID ATTRIBUTE QTYUNIT_ID Cascade
F_3563 QTYUNIT_ID ATTRVALDESC 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_3584 QUANTITYMEASURE INVAVL QTYUNIT_ID Cascade
F_3585 QUANTITYMEASURE INVCNF 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

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search