Database Table: CATGPCALCD

A row in this table indicates 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 Column Description
CALCODE_ID INTEGER
NOT NULL
The CalculationCode for the catalog entry.
CATGPCALCD_ID BIGINT
NOT NULL
Generated unique key.
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.
STORE_ID INTEGER
NOT NULL
The store associated with the catalog entry.
TRADING_ID BIGINT
NULL
The TradingAgreement for the catalog entry. NULL implies all TradingAgreements.
Indexes:
Index Name Indexed Column Names Index Type
I0000066 STORE_ID, CATGROUP_ID, CALCODE_ID, TRADING_ID Unique Index
SQL030416034902620 CATGPCALCD_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint 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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable