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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034905340 | CATALOG_ID, CATGROUP_ID, TRADEPOSCN_ID, STORE_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|