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
| Column Name
| Column 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
| Reserved for IBM internal use.
|