Database Table: CATENCALCD

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000062 STORE_ID, CATENTRY_ID, CALCODE_ID, TRADING_ID Unique Index
SQL030416034858330 CATENCALCD_ID Primary Key
Constraints:
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

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