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


Related reference
Calculation code - indirect attachment data model