WebSphere Commerce database table: TAXTYPE
This table represents a TaxType. For example, sales tax and shipping tax are two types of taxes.
Column Descriptions
| Column Name
| Column Type
| Description |
| TAXTYPE_ID
| INTEGER NOT NULL
| Unique identifier.
|
| TXCDSCHEME_ID
| INTEGER
| The TaxScheme, if any, this TaxType is part of.
|
| 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.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|
Indexes
| Index Name
| Indexed Column Names
| Index Type |
| SQL060903235258470
| TAXTYPE_ID
| Primary Key
|
| I0000344
| SEQUENCE+TXCDSCHEME_ID+TAXTYPE_ID
| Non-Unique Index
|
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
|
| Constraint Name
| Referenced Column Name
| Foreign Table Name
| Foreign Column Names
| Constraint Type |
| F_817
| TAXTYPE_ID
| TAXCGRY
| TAXTYPE_ID
| Cascade
|
Related reference