WebSphere Commerce database table: CURFMTDESC

WebSphere Commerce database table: CURFMTDESC

Each row of this table represents the Language-dependent part of a currency formatting rule. It describes how to format (for display purposes) a monetary amount in a particular currency, in a particular Language.
Column Descriptions
Column Name Column Type Description
STOREENT_ID INTEGER NOT NULL The StoreEntity this formatting rule is part of.
NUMBRUSG_ID INTEGER NOT NULL DEFAULT -1 This currency formatting rule should be used when formatting monetary amounts for this usage.
SETCCURR CHAR(3) NOT NULL The currency. This is a currency code as per ISO 4217 standards.
LANGUAGE_ID INTEGER NOT NULL The language. For a list of language components, see the LANGUAGE table.
CURRENCYSYMBOL VARCHAR(254) The currency symbol.
CUSTOMIZEDCURRSTR VARCHAR(254) An alternate currency code. WebSphere Commerce does not use this value. You may supply a value and write your JSP macros to use it.
CURRENCYPREFIXPOS VARCHAR(254) The prefix to use when the monetary amount is positive. If this field and CURRENCYSUFFIXPOS are null then the positivePrefix of the NumberFormat will be used.
CURRENCYSUFFIXPOS VARCHAR(254) The suffix to use when the monetary amount is positive. If this field and CURRENCYPREFIXPOS are null then the positiveSuffix of the NumberFormat will be used.
DISPLAYLOCALE CHAR(16) The Java locale used to create a currency NumberFormat object that is used to do the formatting. If this is NULL then the locale associated with the LANGUAGE_ID (see the LANGUAGE table) is used.
CURRENCYPREFIXNEG VARCHAR(254) The prefix to use when the monetary amount is negative. If this field and CURRENCYSUFFIXNEG are null then the negativePrefix of the NumberFormat will be used.
CURRENCYSUFFIXNEG VARCHAR(254) The suffix to use when the monetary amount is negative. If this field and CURRENCYPREFIXNEG are null then the negativeSuffix of the NumberFormat will be used.
RADIXPOINT CHAR(1) The radix point for the NumberFormat object. For example, when formatting dollars for the U.S. English Language, this would be the decimal point character. If this is null, then the decimal separator of the currency NumberFormat, associated with the DisplayLocale, will be used.
GROUPINGCHAR CHAR(1) The grouping character used by the NumberFormat object. For example, when formatting dollars for the U.S. English Language this would be the thousands separator. If this is null, then the grouping separator of the currency NumberFormat, associated with the DisplayLocale, will be used.
NUMBERPATTERN VARCHAR(254) The number pattern to be applied to the NumberFormat object. The number pattern is described in the JDK documentation for the class java.text.DecimalFormat. If this is NULL then the default number pattern of the NumberFormat object is used.
DESCRIPTION VARCHAR(254) A description of the currency, suitable for display to customers in a currency selection list.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235149550 NUMBRUSG_ID+STOREENT_ID+SETCCURR+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_291 STOREENT_ID SETCCURR NUMBRUSG_ID CURFORMAT STOREENT_ID Cascade
F_290 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Related reference

Currency data model

Column Name	Column Type	Description
STOREENT_ID	INTEGER NOT NULL	The StoreEntity this formatting rule is part of.
NUMBRUSG_ID	INTEGER NOT NULL DEFAULT -1	This currency formatting rule should be used when formatting monetary amounts for this usage.
SETCCURR	CHAR(3) NOT NULL	The currency. This is a currency code as per ISO 4217 standards.
LANGUAGE_ID	INTEGER NOT NULL	The language. For a list of language components, see the LANGUAGE table.
CURRENCYSYMBOL	VARCHAR(254)	The currency symbol.
CUSTOMIZEDCURRSTR	VARCHAR(254)	An alternate currency code. WebSphere Commerce does not use this value. You may supply a value and write your JSP macros to use it.
CURRENCYPREFIXPOS	VARCHAR(254)	The prefix to use when the monetary amount is positive. If this field and CURRENCYSUFFIXPOS are null then the positivePrefix of the NumberFormat will be used.
CURRENCYSUFFIXPOS	VARCHAR(254)	The suffix to use when the monetary amount is positive. If this field and CURRENCYPREFIXPOS are null then the positiveSuffix of the NumberFormat will be used.
DISPLAYLOCALE	CHAR(16)	The Java locale used to create a currency NumberFormat object that is used to do the formatting. If this is NULL then the locale associated with the LANGUAGE_ID (see the LANGUAGE table) is used.
CURRENCYPREFIXNEG	VARCHAR(254)	The prefix to use when the monetary amount is negative. If this field and CURRENCYSUFFIXNEG are null then the negativePrefix of the NumberFormat will be used.
CURRENCYSUFFIXNEG	VARCHAR(254)	The suffix to use when the monetary amount is negative. If this field and CURRENCYPREFIXNEG are null then the negativeSuffix of the NumberFormat will be used.
RADIXPOINT	CHAR(1)	The radix point for the NumberFormat object. For example, when formatting dollars for the U.S. English Language, this would be the decimal point character. If this is null, then the decimal separator of the currency NumberFormat, associated with the DisplayLocale, will be used.
GROUPINGCHAR	CHAR(1)	The grouping character used by the NumberFormat object. For example, when formatting dollars for the U.S. English Language this would be the thousands separator. If this is null, then the grouping separator of the currency NumberFormat, associated with the DisplayLocale, will be used.
NUMBERPATTERN	VARCHAR(254)	The number pattern to be applied to the NumberFormat object. The number pattern is described in the JDK documentation for the class java.text.DecimalFormat. If this is NULL then the default number pattern of the NumberFormat object is used.
DESCRIPTION	VARCHAR(254)	A description of the currency, suitable for display to customers in a currency selection list.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_291	STOREENT_ID SETCCURR NUMBRUSG_ID	CURFORMAT	STOREENT_ID	Cascade
F_290	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade