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 Descriptions:

NameTypeDescription
NUMBRUSG_IDINTEGER NOT NULLGenerated unique key. Negative values are reserved for IBM. HCL 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
CODECHAR (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.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>NUMBRUSG_IDPrimary Key
I0000164CODEUnique Index

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_292NUMBRUSG_IDCURFORMATNUMBRUSG_IDCascade
F_466NUMBRUSG_IDNUMBRUSGDSNUMBRUSG_IDCascade
F_644NUMBRUSG_IDQTYFORMATNUMBRUSG_IDCascade