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.
|