CATGRPTPC

This table relates master catalogs with trading position containers. Each catalog entry belonging to the indicated master catalog must have a standard price offer supplied for the specified trading position container.

Column Descriptions:

NameTypeDescription
CATALOG_IDBIGINT NOT NULLThe reference number of the catalog.
CATGROUP_IDBIGINT NOT NULL DEFAULT 0The reference number of the catalog group.
TRADEPOSCN_IDBIGINT NOT NULLThe reference number of the trading position container.
STORE_IDINTEGER NOT NULL DEFAULT 0The reference number of the store to which this trading position container relationship refers.
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>CATALOG_ID+CATGROUP_ID+TRADEPOSCN_ID+STORE_IDPrimary Key
I0000529TRADEPOSCN_IDNon-Unique Index
I0000530STORE_IDNon-Unique Index
I0000531CATGROUP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_227TRADEPOSCN_IDTRADEPOSCNTRADEPOSCN_IDCascade
F_228CATALOG_IDCATALOGCATALOG_IDCascade
F_229CATGROUP_IDCATGROUPCATGROUP_IDCascade
F_945STORE_IDSTORESTORE_IDCascade