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:

Name	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.
CALFLAGS	SMALLINT	0 - union The attachments defined by this row are in addition to the attachments that are defined in other stores on the store path. 1 - cancel Instead of defining attachments, this row cancels attachments that are defined for stores later in the store path of the specified calculation code to the specified catalog entries for the specified trading agreements. The default value is 0.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	CATENCALCD_ID	Primary Key
I0000062	STORE_ID+CATENTRY_ID+CALCODE_ID+TRADING_ID	Unique Index
I0000514	CALCODE_ID	Non-Unique Index
I0000515	CATENTRY_ID	Non-Unique Index
I0000516	TRADING_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	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