Database Table: 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 Name Column Type Column Description
CATALOG_ID BIGINT
NOT NULL
The reference number of the catalog.
CATGROUP_ID BIGINT
NOT NULL, DEFAULT 0
Reserved for IBM internal use.
STORE_ID INTEGER
NOT NULL, DEFAULT 0
The reference number of the store that this trading position container relationship refers.
TRADEPOSCN_ID BIGINT
NOT NULL
The reference number of the trading position container.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034905340 CATALOG_ID, CATGROUP_ID, TRADEPOSCN_ID, STORE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_227 TRADEPOSCN_ID TRADEPOSCN TRADEPOSCN_ID Cascade
F_228 CATALOG_ID CATALOG CATALOG_ID Cascade
F_229 CATGROUP_ID CATGROUP CATGROUP_ID Cascade
F_945 STORE_ID STORE STORE_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable