Database Table: CURFORMAT

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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034920440 STOREENT_ID, SETCCURR, NUMBRUSG_ID Primary Key
Constraints:
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

Referenced By:
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