ORDADJTXEX

Each row of this table indicates that an OrderAdjustment is exempt from taxation of a particular TaxCategory. For example, an "after tax rebate" can be represented as a negative OrderAdjustment that is exempt from taxation of all TaxCategories.

Column Descriptions:

NameTypeDescription
ORDADJUST_IDBIGINT NOT NULLThe OrderAdjustment.
TAXCGRY_IDINTEGER NOT NULLThe TaxCategory.
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>ORDADJUST_ID+TAXCGRY_IDPrimary Key
I0000633TAXCGRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_488ORDADJUST_IDORDADJUSTORDADJUST_IDCascade
F_489TAXCGRY_IDTAXCGRYTAXCGRY_IDCascade