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:

Name	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.
CALFLAGS	SMALLINT	Contains the following bit values: 0 (default) or null - union The attachments defined by this row are in addition to the attachments that are defined in other stores on the store path. 1 - cancel Instead of defining attachments, this row cancels attachments that are defined for stores later in the store path of the specified calculation code to the specified catalog groups for the specified trading agreements.
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>	CATGPCALCD_ID	Primary Key
I0000066	STORE_ID+CATGROUP_ID+CALCODE_ID+TRADING_ID	Unique Index
I0000520	CALCODE_ID	Non-Unique Index
I0000521	CATGROUP_ID	Non-Unique Index
I0000522	TRADING_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_209	TRADING_ID	TRADING	TRADING_ID	Cascade
F_210	CATGROUP_ID	CATGROUP	CATGROUP_ID	Cascade
F_211	STORE_ID	STORE	STORE_ID	Cascade
F_212	CALCODE_ID	CALCODE	CALCODE_ID	Cascade