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 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
QuantityUnit formatting rule should be used when
formatting quantity amounts for this usage. |
LANGUAGE_ID | INTEGER NOT NULL | The Language. For a list of language components,
see the LANGUAGE table. |
QTYUNIT_ID | CHAR (16) NOT NULL | The
QuantityUnit . |
UNITSYMBOL | VARCHAR (254) | The
QuantityUnit symbol. |
UNITPREFIXPOS | VARCHAR (254) | 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. |
UNITSUFFIXPOS | VARCHAR (254) | 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. |
DISPLAYLOCALE | CHAR (16) | 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. |
CUSTOMIZEDQTYSTR | VARCHAR (254) | An alternate
QuantityUnit code. WebSphere Commerce does not use
this value. You may supply a value and write your JSP macros to use
it. |
UNITPREFIXNEG | VARCHAR (254) | 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. |
UNITSUFFIXNEG | VARCHAR (254) | 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. |
RADIXPOINT | CHAR (1) | 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. |
GROUPINGCHAR | CHAR (1) | 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. |
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
QuantityUnit , suitable for display to customers in a
QuantityUnit selection list. |
OPTCOUNTER | SMALLINT | 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+QTYUNIT_ID+LANGUAGE_ID | Primary Key |
I0001274 | STOREENT_ID+QTYUNIT_ID+NUMBRUSG_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | 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 |