A row in this table indicates that a CalculationCode is attached to a CatalogEntry and its PRODUCT_ITEM children (or all CatalogEntries) for the specified Store and TradingAgreement (or all TradingAgreements).
Column Name | Column Type | Column Description |
---|---|---|
CALCODE_ID | INTEGER NOT NULL |
The CalculationCode. |
CATENCALCD_ID | BIGINT NOT NULL |
Generated unique key. |
CATENTRY_ID | BIGINT NULL |
The CatalogEntry. NULL implies all CatalogEntries. If the CatalogEntry has 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. |
TRADING_ID | BIGINT NULL |
The TradingAgreement. NULL implies all TradingAgreements. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000062 | STORE_ID, CATENTRY_ID, CALCODE_ID, TRADING_ID | Unique Index |
SQL030416034858330 | CATENCALCD_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_190 | TRADING_ID | TRADING | TRADING_ID | Cascade |
F_191 | STORE_ID | STORE | STORE_ID | Cascade |
F_192 | CATENTRY_ID | CATENTRY | CATENTRY_ID | Cascade |
F_193 | CALCODE_ID | CALCODE | CALCODE_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|