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 Name Column Type Column Description
LASTUPDATE TIMESTAMP
NULL
The time this information was most recently updated.
ORDERS_ID BIGINT
NOT NULL
The Order.
TAXAMOUNT DECIMAL (20,5)
NOT NULL
The tax amount, in the currency of the Order (ORDERS.CURRENCY).
TAXCGRY_ID INTEGER
NOT NULL
The TaxCategory.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035024790 ORDERS_ID, TAXCGRY_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_551 ORDERS_ID ORDERS ORDERS_ID Cascade
F_552 TAXCGRY_ID TAXCGRY TAXCGRY_ID Cascade

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