A row in this table associates a TradingPositionContainer with a MemberGroup.
Task commands can use this relationship to restrict use of the TradingPositionContainer to members of certain MemberGroups. (See also the STOREMBRGP table.)
This table is deprecated and is provided for backward compatibility only. Use TermAndCondition objects and Participant objects to limit the use of TradingPositionContainers to certain customers. See the TRADING, TERMCOND, and PARTICIPNT tables for current information.
Column Description(s):
Column Name | Column Type | Description |
MBRGRP_ID |
BIGINT NOT NULL |
The MemberGroup. Task commands that find prices for customers should use the MemberGroup as well as TRADEPOSCN.FLAGS and the STOREMBRGP relationship table to determine which customers can use the TradingPositionContainer. |
TRADEPOSCN_ID |
BIGINT NOT NULL |
The TradingPositionContainer. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
SQL050212031240230 |
TRADEPOSCN_ID+MBRGRP_ID |
Primary Key |
I0000620 |
MBRGRP_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_461 |
MBRGRP_ID |
MBRGRP |
MBRGRP_ID |
Cascade |
F_460 |
TRADEPOSCN_ID |
TRADEPOSCN |
TRADEPOSCN_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.