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:
Name | Type | Description |
CATALOG_ID | BIGINT NOT NULL | The reference number of the catalog. |
CATGROUP_ID | BIGINT NOT NULL DEFAULT 0 | The reference number of the catalog group. |
TRADEPOSCN_ID | BIGINT NOT NULL | The reference number of the trading position
container. |
STORE_ID | INTEGER NOT NULL DEFAULT 0 | The reference number of the store to which this
trading position container relationship refers. |
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> | CATALOG_ID+CATGROUP_ID+TRADEPOSCN_ID+STORE_ID | Primary Key |
I0000529 | TRADEPOSCN_ID | Non-Unique Index |
I0000530 | STORE_ID | Non-Unique Index |
I0000531 | CATGROUP_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | 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 |