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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035044940 | STOREENT_ID, QTYUNIT_ID, NUMBRUSG_ID | Primary Key |
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 |
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 |