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:
Name | 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) | A brief description of the TaxCategory. |
OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | 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> | ORDERITEMS_ID+TAXCGRY_ID | Primary Key |
I0000662 | TAXCGRY_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_528 | ORDERITEMS_ID | ORDERITEMS | ORDERITEMS_ID | Cascade |
F_529 | TAXCGRY_ID | TAXCGRY | TAXCGRY_ID | Cascade |