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
- Calculation scale data model
- Messaging extension data model
- Quantity unit data model
- Quantity unit - references data model
- Order release data model
- Offers data model
- Catalog entry data model
_vcc_freeselect_bottom_