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 Descriptions:
Name | 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 | 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 | Primary Key |
I0000164 | CODE | Unique Index |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | 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 |