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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416035123620 | SUBORDER_ID, TAXCGRY_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|