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:

NameTypeDescription
ORDERS_IDBIGINT NOT NULLThe Order.
TAXCGRY_IDINTEGER NOT NULLThe TaxCategory.
TAXAMOUNTDECIMAL (20,5) NOT NULLThe tax amount, in the currency of the Order (ORDERS.CURRENCY).
LASTUPDATETIMESTAMPThe time this information was most recently updated.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ORDERS_ID+TAXCGRY_IDPrimary Key
I0000676TAXCGRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_551ORDERS_IDORDERSORDERS_IDCascade
F_552TAXCGRY_IDTAXCGRYTAXCGRY_IDCascade