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 Descriptions
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.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
CALFLAGS SMALLINT Contains the following bit values:

Indexes
Index Name Indexed Column Names Index Type
I0000066 STORE_ID+CATGROUP_ID+CALCODE_ID+TRADING_ID Unique Index
SQL060903235138460 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