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 Column Description
DECIMALPLACES INTEGER
NOT NULL
The number of decimal places in a rounded or truncated quantity amount.
NUMBRUSG_ID INTEGER
NOT NULL, DEFAULT -1
This QuantityUnit formatting rule should be used when formatting quantity amounts for this usage.
QTYUNIT_ID CHARACTER (16)
NOT NULL
The QuantityUnit.
ROUNDINGMETHOD CHARACTER (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.
ROUNDINGMULTIPLE INTEGER
NOT NULL
Rounding multiple. For example, specify 5 to round centimeters the nearest multiple of five centimeters. The default value is 1.
STOREENT_ID INTEGER
NOT NULL
The StoreEntity of which this formatting rule is a part.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035044940 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_645 STOREENT_ID STOREENT STOREENT_ID Cascade
F_646 QTYUNIT_ID QTYUNIT QTYUNIT_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+QTYUNIT_ID+NUMBRUSG_ID Cascade