Database Table: SUBORDTAX

Each row of this table specifies the tax amount of a particular TaxCategory for all the OrderItems with the same shipping address as the SubOrder.

Column Name Column Type Column Description
SUBORDER_ID BIGINT
NOT NULL
The SubOrder.
TAXAMOUNT DECIMAL (20,5)
NOT NULL
The tax amount in the Currency of the SubOrder (see SUBORDERS.CURRENCY for details).
TAXCGRY_ID INTEGER
NOT NULL
The TaxCategory.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035123620 SUBORDER_ID, TAXCGRY_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_814 SUBORDER_ID SUBORDERS SUBORDER_ID Cascade
F_815 TAXCGRY_ID TAXCGRY TAXCGRY_ID Cascade

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