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