Reference > Database > WebSphere Commerce database tables > N

WebSphere Commerce database table: NUMBRUSG

Each row defines a NumberUsage object. Numbers such as quantities and monetary amounts can be rounded and formatted differently depending on their associated NumberUsage objects. The CurrencyManager and QuantityManager cache this information.

Column Name	Column Type	Description
NUMBRUSG_ID	INTEGER NOT NULL	Generated unique key. Negative values are reserved for IBM. WebSphere Commerce defines and uses the following values: -1 = com.ibm.commerce.default -2 = com.ibm.commerce.unitPrice -3 = com.ibm.commerce.listPrice -4 = com.ibm.commerce.text -5 = com.ibm.commerce.textUnitPrice
CODE	CHAR(60)	Applications can specify this value to identify their application specific NumberUsages. It is suggested that Java package naming conventions be used to facilitate application integration. Values starting with "com.ibm." are reserved for IBM.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
I0000164	CODE	Unique Index
SQL100520030357490	NUMBRUSG_ID	Primary Key

Referenced By

Constraint Name	Referenced Column Name	Foreign Table Name	Foreign Column Names	Constraint Type
F_292	NUMBRUSG_ID	CURFORMAT	NUMBRUSG_ID	Cascade
F_466	NUMBRUSG_ID	NUMBRUSGDS	NUMBRUSG_ID	Cascade
F_644	NUMBRUSG_ID	QTYFORMAT	NUMBRUSG_ID	Cascade

Related reference

• Quantity unit data model

• Currency data model

_vcc_freeselect_bottom_

+

Search Tips   |   Advanced Search