WebSphere Commerce database table: QTYFMTDESC

QTYFMTDESC

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 QuantityUnitNumberFormat object 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 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+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

Related reference
Quantity unit data model

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 QuantityUnitNumberFormat object 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 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.

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

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