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 Descriptions:

Name	Type	Description
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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	ORDERS_ID+TAXCGRY_ID	Primary Key
I0000676	TAXCGRY_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_551	ORDERS_ID	ORDERS	ORDERS_ID	Cascade
F_552	TAXCGRY_ID	TAXCGRY	TAXCGRY_ID	Cascade