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:

Name	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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	STOREENT_ID+QTYUNIT_ID+NUMBRUSG_ID	Primary Key

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	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 Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_643	STOREENT_ID+QTYUNIT_ID+NUMBRUSG_ID	QTYFMTDESC	STOREENT_ID+QTYUNIT_ID+NUMBRUSG_ID	Cascade

Related reference
Quantity unit data model