Each row of this table represents the Language-dependent part of a QuantityUnit formatting rule. It describes how to format (for display purposes) a quantity amount in a particular QuantityUnit, in a particular Language.
Column Name | Column Type | Column Description |
---|---|---|
CUSTOMIZEDQTYSTR | VARCHAR (254) NULL |
An alternate QuantityUnit code. WebSphere Commerce does not use this value. You may supply a value and write your JSP macros to use it. |
DESCRIPTION | VARCHAR (254) NULL |
A description of the QuantityUnit, suitable for display to customers in a QuantityUnit selection list. |
DISPLAYLOCALE | CHARACTER (16) NULL |
The Java locale used to create a QuantityUnit 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. |
GROUPINGCHAR | CHARACTER (1) NULL |
The grouping character used by the NumberFormat object. For example, when formatting gallons for the U.S. English Language this would be the thousands separator. If this is null, then the grouping separator of the NumberFormat, associated with the DisplayLocale, will be used. |
LANGUAGE_ID | INTEGER NOT NULL |
The Language. For a list of language components, see the LANGUAGE table. |
NUMBERPATTERN | VARCHAR (254) NULL |
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. |
NUMBRUSG_ID | INTEGER NOT NULL, DEFAULT -1 |
This QuantityUnit formatting rule should be used when formatting quantity amounts for this usage. |
QTYUNIT_ID | CHARACTER (16) NOT NULL |
The QuantityUnit. |
RADIXPOINT | CHARACTER (1) NULL |
The radix point for the NumberFormat object. For example, when formatting gallons for the U.S. English Language, this would be the decimal point character. If this is null, then the decimal separator of the NumberFormat, associated with the DisplayLocale, will be used. |
STOREENT_ID | INTEGER NOT NULL |
The StoreEntity this formatting rule is part of. |
UNITPREFIXNEG | VARCHAR (254) NULL |
The prefix to use when the quantity amount is negative. If this field and UNITSUFFIXNEG are null then the negativePrefix of the NumberFormat will be used. |
UNITPREFIXPOS | VARCHAR (254) NULL |
The prefix to use when the quantity amount is positive. If this field and UNITSUFFIXPOS are null then the positivePrefix of the NumberFormat will be used. |
UNITSUFFIXNEG | VARCHAR (254) NULL |
The suffix to use when the quantity amount is negative. If this field and UNITPREFIXNEG are null then the negativeSuffix of the NumberFormat will be used. |
UNITSUFFIXPOS | VARCHAR (254) NULL |
The suffix to use when the quantity amount is positive. If this field and UNITPREFIXPOS are null then the positiveSuffix of the NumberFormat will be used. |
UNITSYMBOL | VARCHAR (254) NULL |
The QuantityUnit symbol. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035044610 | NUMBRUSG_ID, STOREENT_ID, QTYUNIT_ID, LANGUAGE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_642 | LANGUAGE_ID | LANGUAGE | LANGUAGE_ID | Cascade |
F_643 | STOREENT_ID, QTYUNIT_ID, NUMBRUSG_ID | QTYFORMAT | STOREENT_ID, QTYUNIT_ID, NUMBRUSG_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|