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:

NameTypeDescription
STOREENT_IDINTEGER NOT NULLThe StoreEntity this formatting rule is part of.
NUMBRUSG_IDINTEGER NOT NULL DEFAULT -1This currency formatting rule should be used when formatting monetary amounts for this usage.
SETCCURRCHAR (3) NOT NULLThe currency. This is a currency code as per ISO 4217 standards.
LANGUAGE_IDINTEGER NOT NULLThe language. For a list of language components, see the LANGUAGE table.
CURRENCYSYMBOLVARCHAR (254)The currency symbol.
CUSTOMIZEDCURRSTRVARCHAR (254)An alternate currency code. HCL Commerce does not use this value. You may supply a value and write your JSP macros to use it.
CURRENCYPREFIXPOSVARCHAR (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.
CURRENCYSUFFIXPOSVARCHAR (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.
DISPLAYLOCALECHAR (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.
CURRENCYPREFIXNEGVARCHAR (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.
CURRENCYSUFFIXNEGVARCHAR (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.
RADIXPOINTCHAR (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.
GROUPINGCHARCHAR (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.
NUMBERPATTERNVARCHAR (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.
DESCRIPTIONVARCHAR (254)A description of the currency, suitable for display to customers in a currency selection list.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>NUMBRUSG_ID+STOREENT_ID+SETCCURR+LANGUAGE_IDPrimary Key
I0001254STOREENT_ID+SETCCURR+NUMBRUSG_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_290LANGUAGE_IDLANGUAGELANGUAGE_IDCascade
F_291STOREENT_ID+SETCCURR+NUMBRUSG_IDCURFORMATSTOREENT_ID+SETCCURR+NUMBRUSG_IDCascade