Reference > Database > WebSphere Commerce database tables > T

WebSphere Commerce database table: TAXTYPE

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

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
SQL100520030437640	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

Referenced By

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

Related reference

• Calculation usage data model

• Tax type and category data model

_vcc_freeselect_bottom_

+

Search Tips   |   Advanced Search