WebSphere Commerce 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 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.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235149740 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_294 SETCCURR SETCURR SETCCURR Cascade
F_293 STOREENT_ID STOREENT STOREENT_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_291 STOREENT_ID SETCCURR NUMBRUSG_ID CURFMTDESC STOREENT_ID Cascade