Reference > Database > WebSphere Commerce database tables > Q
WebSphere Commerce database table: QTYFORMAT
Each row of this table represents the Language-independent part of a QuantityUnit formatting rule. If a Store has no formatting rule for a particular QuantityUnit, it uses the formatting rule of its StoreGroup.
Column Name Column Type Description STOREENT_ID INTEGER NOT NULL The StoreEntity of which this formatting rule is a part. QTYUNIT_ID CHAR(16) NOT NULL The QuantityUnit. ROUNDINGMULTIPLE INTEGER NOT NULL Rounding multiple. For example, specify 5 to round centimeters the nearest multiple of five centimeters. The default value is 1. NUMBRUSG_ID INTEGER NOT NULL DEFAULT -1 This QuantityUnit formatting rule should be used when formatting quantity amounts for this usage. ROUNDINGMETHOD CHAR(1) NOT NULL How to round to a multiple of ROUNDINGMULTIPLE. Valid values:
R = Round normally; that is, up or down, to the nearest multiple.
T = Truncate; that is, round down for positive amounts, round up for negative amounts.DECIMALPLACES INTEGER NOT NULL The number of decimal places in a rounded or truncated quantity amount. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030419430 STOREENT_ID+QTYUNIT_ID+NUMBRUSG_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_644 NUMBRUSG_ID NUMBRUSG NUMBRUSG_ID Cascade F_646 QTYUNIT_ID QTYUNIT QTYUNIT_ID Cascade F_645 STOREENT_ID STOREENT STOREENT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_643 STOREENT_ID QTYUNIT_ID NUMBRUSG_ID QTYFMTDESC STOREENT_ID Cascade
Related reference
_vcc_freeselect_bottom_