Each row of this table represents the Language-independent part of a currency formatting rule. If a Store has no formatting rule for a particular currency, it uses the formatting rule of its StoreGroup.
Column Name | Column Type | Column Description |
---|---|---|
DECIMALPLACES | INTEGER NOT NULL, DEFAULT 2 |
The number of decimal places in a rounded or truncated monetary amount. |
MINAPPROVEAMOUNT | DECIMAL (20,5) NULL |
A small amount to be authorized when a backorder is initially submitted, to check that a successful authorization can be obtained. The full amount of the Order will not be authorized until sufficient inventory is allocated to release the backorder. |
NUMBRUSG_ID | INTEGER NOT NULL, DEFAULT -1 |
This currency formatting rule should be used when formatting monetary amounts for this usage. |
ROUNDINGMETHOD | CHARACTER (1) NOT NULL, DEFAULT 'R' |
How to round to a multiple of ROUNDINGMULTIPLE: R = round normally - up or down - to the nearest multiple T = truncate - round down for positive amounts, round up for negative amounts. |
ROUNDINGMULTIPLE | INTEGER NOT NULL, DEFAULT 1 |
Rounding multiple according to national law or practice. For example, specify 5 to round dollars to the nearest five cent piece. The default value is 1. |
SETCCURR | CHARACTER (3) NOT NULL |
The currency. This is a currency code as per ISO 4217 standards. |
STOREENT_ID | INTEGER NOT NULL |
The StoreEntity this formatting rule is part of. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034920440 | STOREENT_ID, SETCCURR, NUMBRUSG_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_292 | NUMBRUSG_ID | NUMBRUSG | NUMBRUSG_ID | Cascade |
F_293 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
F_294 | SETCCURR | SETCURR | SETCCURR | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_291 | STOREENT_ID+SETCCURR+NUMBRUSG_ID | CURFMTDESC | STOREENT_ID+SETCCURR+NUMBRUSG_ID | Cascade |