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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000164 | CODE | Unique Index |
SQL050212031241140 | NUMBRUSG_ID | Primary Key |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign 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 |