WebSphere Commerce database table: CATGPCALCD

Reference > Database > WebSphere Commerce database tables > C

WebSphere Commerce database table: CATGPCALCD

A row in this table indicates that a CalculationCode is attached to all CatalogEntries (and their PRODUCT_ITEM children) in a CatalogGroup for the specified Store and TradingAgreement (or all TradingAgreements).

Column Name Column Type Description
STORE_ID INTEGER NOT NULL The store associated with the catalog entry.
CATGPCALCD_ID BIGINT NOT NULL Generated unique key.
TRADING_ID BIGINT The Trading Agreement for the catalog entry. NULL implies all Trading Agreements.
CATGROUP_ID BIGINT NOT NULL The CatalogGroup for the catalog entry. If any of the CatalogEntries in the CatalogGroup have children in the CATENTREL table with a CATRELTYPE_ID of "PRODUCT_ITEM", then the CalculationCode is also attached to those children.
CALCODE_ID INTEGER The Calculation Code for the catalog group.
If null, this row is changed to a configuration record for indirect attachments in storepath instead of an indirect attachment to catalog group.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
CALFLAGS SMALLINT Contains the following bit values:
0 (default) or null - union - The attachments defined by this row are in addition to attachments defined in other stores on the storepath.
1 - cancel- Instead of defining attachments, this row cancels attachments defined in stores later in the storepath, of the specified calculation code to the specified catalog groups for the specified trading agreements.

Indexes
Index Name Indexed Column Names Index Type
I0000066 STORE_ID+CATGROUP_ID+CALCODE_ID+TRADING_ID Unique Index
SQL100520030311690 CATGPCALCD_ID Primary Key
I0000520 CALCODE_ID Non-Unique Index
I0000521 CATGROUP_ID Non-Unique Index
I0000522 TRADING_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_212 CALCODE_ID CALCODE CALCODE_ID Cascade
F_210 CATGROUP_ID CATGROUP CATGROUP_ID Cascade
F_211 STORE_ID STORE STORE_ID Cascade
F_209 TRADING_ID TRADING TRADING_ID Cascade

Related reference

Calculation code - indirect attachment data model

_vcc_freeselect_bottom_

+
Search Tips | Advanced Search

Column Name	Column Type	Description
STORE_ID	INTEGER NOT NULL	The store associated with the catalog entry.
CATGPCALCD_ID	BIGINT NOT NULL	Generated unique key.
TRADING_ID	BIGINT	The Trading Agreement for the catalog entry. NULL implies all Trading Agreements.
CATGROUP_ID	BIGINT NOT NULL	The CatalogGroup for the catalog entry. If any of the CatalogEntries in the CatalogGroup have children in the CATENTREL table with a CATRELTYPE_ID of "PRODUCT_ITEM", then the CalculationCode is also attached to those children.
CALCODE_ID	INTEGER	The Calculation Code for the catalog group. If null, this row is changed to a configuration record for indirect attachments in storepath instead of an indirect attachment to catalog group.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.
CALFLAGS	SMALLINT	Contains the following bit values: 0 (default) or null - union - The attachments defined by this row are in addition to attachments defined in other stores on the storepath. 1 - cancel- Instead of defining attachments, this row cancels attachments defined in stores later in the storepath, of the specified calculation code to the specified catalog groups for the specified trading agreements.

Index Name	Indexed Column Names	Index Type
I0000066	STORE_ID+CATGROUP_ID+CALCODE_ID+TRADING_ID	Unique Index
SQL100520030311690	CATGPCALCD_ID	Primary Key
I0000520	CALCODE_ID	Non-Unique Index
I0000521	CATGROUP_ID	Non-Unique Index
I0000522	TRADING_ID	Non-Unique Index

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_212	CALCODE_ID	CALCODE	CALCODE_ID	Cascade
F_210	CATGROUP_ID	CATGROUP	CATGROUP_ID	Cascade
F_211	STORE_ID	STORE	STORE_ID	Cascade
F_209	TRADING_ID	TRADING	TRADING_ID	Cascade