Database Table: 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 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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035020760 ORDERITEMS_ID, TAXCGRY_ID Primary Key
Constraints:
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable