ORDITAX

Each row of this table contains a tax amount of a particular TaxCategory, for an OrderItem. By default, WebSphere Commerce does not save any data in this table. However tax amounts are aggregated by TaxCategory in the SUBORDTAX and ORDTAX tables.

Column Descriptions:

NameTypeDescription
ORDERITEMS_IDBIGINT NOT NULLThe OrderItem.
TAXCGRY_IDINTEGER NOT NULLThe TaxCategory.
TAXAMOUNTDECIMAL (20,5) NOT NULLThe tax amount, in the currency of the OrderItem (ORDERITEMS.CURRENCY).
TAXCGRY_DSCVARCHAR (255)A brief description of the TaxCategory.
OPTCOUNTERSMALLINTThe 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>ORDERITEMS_ID+TAXCGRY_IDPrimary Key
I0000662TAXCGRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_528ORDERITEMS_IDORDERITEMSORDERITEMS_IDCascade
F_529TAXCGRY_IDTAXCGRYTAXCGRY_IDCascade