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:

NameTypeDescription
STORE_IDINTEGER NOT NULLThe Store.
CATENCALCD_IDBIGINT NOT NULLGenerated unique key.
TRADING_IDBIGINTThe Trading Agreement. NULL implies all Trading Agreements.
CATENTRY_IDBIGINTThe 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_IDINTEGERThe Calculation Code.
CALFLAGSSMALLINT
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.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CATENCALCD_IDPrimary Key
I0000062STORE_ID+CATENTRY_ID+CALCODE_ID+TRADING_IDUnique Index
I0000514CALCODE_IDNon-Unique Index
I0000515CATENTRY_IDNon-Unique Index
I0000516TRADING_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_190TRADING_IDTRADINGTRADING_IDCascade
F_191STORE_IDSTORESTORE_IDCascade
F_192CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_193CALCODE_IDCALCODECALCODE_IDCascade