WebSphere Commerce database table: ORDTAX

Each row of this table represents the total of the tax amounts of a particular TaxCategory for all the OrderItems in an Order.


Column Description(s):
Column NameColumn TypeDescription
ORDERS_ID BIGINT NOT NULL The Order.
TAXCGRY_ID INTEGER NOT NULL The TaxCategory.
TAXAMOUNT DECIMAL (20,5) NOT NULL The tax amount, in the currency of the Order (ORDERS.CURRENCY).
LASTUPDATE TIMESTAMP The time this information was most recently updated.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031250900 ORDERS_ID+TAXCGRY_ID Primary Key
I0000676 TAXCGRY_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_551 ORDERS_ID ORDERS ORDERS_ID Cascade
F_552 TAXCGRY_ID TAXCGRY TAXCGRY_ID Cascade

Feedback