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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000164 CODE Unique Index
SQL050212031241140 NUMBRUSG_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)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

Feedback