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 Description(s):
Column Name | Column Type | Description |
ORDERITEMS_ID |
BIGINT NOT NULL |
The OrderItem. |
TAXCGRY_ID |
INTEGER NOT NULL |
The TaxCategory. |
TAXAMOUNT |
DECIMAL (20,5) NOT NULL |
The tax amount, in the currency of the OrderItem (ORDERITEMS.CURRENCY). |
TAXCGRY_DSC |
VARCHAR(255) |
Description of the Order Item Trax Category. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031246260 |
ORDERITEMS_ID+TAXCGRY_ID |
Primary Key |
I0000662 |
TAXCGRY_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_528 |
ORDERITEMS_ID |
ORDERITEMS |
ORDERITEMS_ID |
Cascade |
F_529 |
TAXCGRY_ID |
TAXCGRY |
TAXCGRY_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.