Database Table: TAXTYPE

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

Column Name Column Type Column Description
SEQUENCE DOUBLE
NOT NULL, DEFAULT 0
This column is deprecated and is provided for backward compatibility only. See the SEQUENCE column of the STENCALUSG table for current information.
TAXTYPE_ID INTEGER
NOT NULL
Unique identifier.
TXCDSCHEME_ID INTEGER
NULL
The TaxScheme, if any, this TaxType is part of.
Indexes:
Index Name Indexed Column Names Index Type
I0000344 SEQUENCE, TXCDSCHEME_ID, TAXTYPE_ID Non-Unique Index
SQL030416035126260 TAXTYPE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_823 TAXTYPE_ID CALUSAGE CALUSAGE_ID Cascade
F_824 TXCDSCHEME_ID TXCDSCHEME TXCDSCHEME_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_817 TAXTYPE_ID TAXCGRY TAXTYPE_ID Cascade