CALCODTXEX

Each row of this table indicates that monetary amounts calculated using a particular CalculationCode are exempt from taxation of a particular TaxCategory.

Column Descriptions:

NameTypeDescription
CALCODE_IDINTEGER NOT NULLThe CalculationCode whose calculated monetary amounts are tax exempt.
TAXCGRY_IDINTEGER NOT NULLThe TaxCategory from which calculated amounts are tax exempt.
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>CALCODE_ID+TAXCGRY_IDPrimary Key
I0000500TAXCGRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_161CALCODE_IDCALCODECALCODE_IDCascade
F_162TAXCGRY_IDTAXCGRYTAXCGRY_IDCascade