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

NameTypeDescription
SUBORDER_IDBIGINT NOT NULLThe SubOrder.
TAXCGRY_IDINTEGER NOT NULLThe TaxCategory.
TAXAMOUNTDECIMAL (20,5) NOT NULLThe tax amount in the Currency of the SubOrder (see SUBORDERS.CURRENCY for details).
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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>SUBORDER_ID+TAXCGRY_IDPrimary Key
I0000802TAXCGRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_814SUBORDER_IDSUBORDERSSUBORDER_IDCascade
F_815TAXCGRY_IDTAXCGRYTAXCGRY_IDCascade