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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000066 | STORE_ID, CATGROUP_ID, CALCODE_ID, TRADING_ID | Unique Index |
SQL030416034902620 | CATGPCALCD_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|