Reference > Database > WebSphere Commerce database tables > C
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 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. If null, this row is changed to a configuration record for indirect attachments in storepath instead of an indirect attachment to catalog entry.
OPTCOUNTER SMALLINT Reserved for IBM internal use. CALFLAGS SMALLINT Contains the following bit values: 0 (default) or null - union - The attachments defined by this row are in addition to attachments defined in other stores on the storepath.
1 - cancel - Instead of defining attachments, this row cancels attachments defined in stores later in the storepath, of the specified calculation code to the specified catalog entries for the specified trading agreements.
Indexes Index Name Indexed Column Names Index Type I0000062 STORE_ID+CATENTRY_ID+CALCODE_ID+TRADING_ID Unique Index SQL100520030310350 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
_vcc_freeselect_bottom_