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 Descriptions
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
SQL060903235240120 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

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