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 Description(s):
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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031302340 |
STOREENT_ID+QTYUNIT_ID+NUMBRUSG_ID |
Primary Key |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | 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 |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_643 |
STOREENT_ID QTYUNIT_ID NUMBRUSG_ID |
QTYFMTDESC |
STOREENT_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.