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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000344 | SEQUENCE, TXCDSCHEME_ID, TAXTYPE_ID | Non-Unique Index |
SQL030416035126260 | TAXTYPE_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_817 | TAXTYPE_ID | TAXCGRY | TAXTYPE_ID | Cascade |