WebSphere Commerce database table: CATENCALCD

A row in this table indicates that a CalculationCode is attached to a CatalogEntry. And it is also attached to the CatalogEntry's PRODUCT_ITEM children (or all CatalogEntries) for the specified Store. And also it is attached to TradingAgreement (or all TradingAgreements).

Column Descriptions
Column Name Column Type Description
STORE_ID INTEGER NOT NULL The Store.
CATENCALCD_ID BIGINT NOT NULL Generated unique key.
TRADING_ID BIGINT The Trading Agreement. NULL implies all Trading Agreements.
CATENTRY_ID BIGINT The Catalog Entry. NULL implies all Catalog Entries. If the Catalog Entry has children in the CATENTREL table with a CATRELTYPE_ID of "PRODUCT_ITEM", then the Calculation Code is also attached to those children.
CALCODE_ID INTEGER The Calculation Code.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
CALFLAGS SMALLINT Contains the following bit values:

Indexes
Index Name Indexed Column Names Index Type
I0000062 STORE_ID+CATENTRY_ID+CALCODE_ID+TRADING_ID Unique Index
SQL060903235137430 CATENCALCD_ID Primary Key
I0000514 CALCODE_ID Non-Unique Index
I0000515 CATENTRY_ID Non-Unique Index
I0000516 TRADING_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_193 CALCODE_ID CALCODE CALCODE_ID Cascade
F_192 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_191 STORE_ID STORE STORE_ID Cascade
F_190 TRADING_ID TRADING TRADING_ID Cascade
Related reference