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 Descriptions:
| Name | Type | Description |
| STOREENT_ID | INTEGER NOT NULL | The StoreEntity this formatting rule is part
of. |
| SETCCURR | CHAR (3) NOT NULL | The currency. This is a currency code as per ISO
4217 standards. |
| 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. |
| NUMBRUSG_ID | INTEGER NOT NULL DEFAULT -1 | This currency formatting rule should be used when
formatting monetary amounts for this usage. |
| ROUNDINGMETHOD | CHAR (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. |
| DECIMALPLACES | INTEGER NOT NULL DEFAULT 2 | The number of decimal places in a rounded or
truncated monetary amount. |
| MINAPPROVEAMOUNT | DECIMAL (20,5) | 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. |
| OPTCOUNTER | SMALLINT | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | STOREENT_ID+SETCCURR+NUMBRUSG_ID | Primary Key |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_292 | NUMBRUSG_ID | NUMBRUSG | NUMBRUSG_ID | Cascade |
| F_293 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
| F_294 | SETCCURR | SETCURR | SETCCURR | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_291 | STOREENT_ID+SETCCURR+NUMBRUSG_ID | CURFMTDESC | STOREENT_ID+SETCCURR+NUMBRUSG_ID | Cascade |