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:
| Name | 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. HCL 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 NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | NUMBRUSG_ID+STOREENT_ID+SETCCURR+LANGUAGE_ID | Primary Key |
| I0001254 | STOREENT_ID+SETCCURR+NUMBRUSG_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_290 | LANGUAGE_ID | LANGUAGE | LANGUAGE_ID | Cascade |
| F_291 | STOREENT_ID+SETCCURR+NUMBRUSG_ID | CURFORMAT | STOREENT_ID+SETCCURR+NUMBRUSG_ID | Cascade |