WebSphere Commerce database table: TAXCGRYDS

TAXCGRYDS

This table contains language-dependent information about a TaxCategory.

Column Descriptions:

Name Type Description
LANGUAGE_ID INTEGER NOT NULL The Language of the description. For a list of language components, see the LANGUAGE table.
TAXCGRY_ID INTEGER NOT NULL The TaxCategory.
DESCRIPTION VARCHAR (254) A brief description of the TaxCategory, suitable for display to customers.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name Column Names Type
<SYSTEM-GENERATED> LANGUAGE_ID+TAXCGRY_ID Primary Key
I0000804 TAXCGRY_ID Non-Unique Index

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_818 TAXCGRY_ID TAXCGRY TAXCGRY_ID Cascade
F_819 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

Related reference
Tax type and category data model

Name	Type	Description
LANGUAGE_ID	INTEGER NOT NULL	The Language of the description. For a list of language components, see the LANGUAGE table.
TAXCGRY_ID	INTEGER NOT NULL	The TaxCategory.
DESCRIPTION	VARCHAR (254)	A brief description of the TaxCategory, suitable for display to customers.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Name	Column Names	Type
<SYSTEM-GENERATED>	LANGUAGE_ID+TAXCGRY_ID	Primary Key
I0000804	TAXCGRY_ID	Non-Unique Index

Constraint	Columns	Parent Table	Parent Columns	Type
F_818	TAXCGRY_ID	TAXCGRY	TAXCGRY_ID	Cascade
F_819	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade