WebSphere Commerce 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 Description(s):
Column NameColumn TypeDescription
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 NameIndexed Column NamesIndex Type
SQL050212031246260 ORDERITEMS_ID+TAXCGRY_ID Primary Key
I0000662 TAXCGRY_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_528 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade
F_529 TAXCGRY_ID TAXCGRY TAXCGRY_ID Cascade

Feedback