WebSphere Commerce database table: CURFORMAT

Reference > Database > WebSphere Commerce database tables > C

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 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
SQL100520030323270 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

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 Cascade

Related reference

Currency data model

_vcc_freeselect_bottom_

+
Search Tips | Advanced Search

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.

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