TAXTYPE

This table represents a TaxType. For example, sales tax and shipping tax are two types of taxes.

Column Descriptions:

NameTypeDescription
TAXTYPE_IDINTEGER NOT NULLUnique identifier.
TXCDSCHEME_IDINTEGERThe TaxScheme, if any, this TaxType is part of.
SEQUENCEDOUBLE NOT NULL DEFAULT 0This column is deprecated and is provided for backward compatibility only. See the SEQUENCE column of the STENCALUSG table for current information.
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>TAXTYPE_IDPrimary Key
I0000344SEQUENCE+TXCDSCHEME_ID+TAXTYPE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_823TAXTYPE_IDCALUSAGECALUSAGE_IDCascade
F_824TXCDSCHEME_IDTXCDSCHEMETXCDSCHEME_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_817TAXTYPE_IDTAXCGRYTAXTYPE_IDCascade