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 Name | Column Type | Column Description |
---|---|---|
ORDERITEMS_ID | BIGINT NOT NULL |
The OrderItem. |
TAXAMOUNT | DECIMAL (20,5) NOT NULL |
The tax amount, in the currency of the OrderItem (ORDERITEMS.CURRENCY). |
TAXCGRY_ID | INTEGER NOT NULL |
The TaxCategory. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035020760 | ORDERITEMS_ID, TAXCGRY_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_528 | ORDERITEMS_ID | ORDERITEMS | ORDERITEMS_ID | Cascade |
F_529 | TAXCGRY_ID | TAXCGRY | TAXCGRY_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|