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 Description(s):
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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031220220 |
STOREENT_ID+SETCCURR+NUMBRUSG_ID |
Primary Key |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_292 |
NUMBRUSG_ID |
NUMBRUSG |
NUMBRUSG_ID |
Cascade |
F_294 |
SETCCURR |
SETCURR |
SETCCURR |
Cascade |
F_293 |
STOREENT_ID |
STOREENT |
STOREENT_ID |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_291 |
STOREENT_ID SETCCURR NUMBRUSG_ID |
CURFMTDESC |
STOREENT_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.