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:

NameTypeDescription
STOREENT_IDINTEGER NOT NULLThe StoreEntity of which this formatting rule is a part.
QTYUNIT_IDCHAR (16) NOT NULLThe QuantityUnit.
ROUNDINGMULTIPLEINTEGER NOT NULLRounding multiple. For example, specify 5 to round centimeters the nearest multiple of five centimeters. The default value is 1.
NUMBRUSG_IDINTEGER NOT NULL DEFAULT -1This QuantityUnit formatting rule should be used when formatting quantity amounts for this usage.
ROUNDINGMETHODCHAR (1) NOT NULLHow 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.
DECIMALPLACESINTEGER NOT NULLThe number of decimal places in a rounded or truncated quantity amount.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>STOREENT_ID+QTYUNIT_ID+NUMBRUSG_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_644NUMBRUSG_IDNUMBRUSGNUMBRUSG_IDCascade
F_645STOREENT_IDSTOREENTSTOREENT_IDCascade
F_646QTYUNIT_IDQTYUNITQTYUNIT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_643STOREENT_ID+QTYUNIT_ID+NUMBRUSG_IDQTYFMTDESCSTOREENT_ID+QTYUNIT_ID+NUMBRUSG_IDCascade