This table represents a TradingPositionContainer. It can contain TradingPositions and can be made available to all customers, or only to customers in certain groups through the trading agreements or contracts.
Column Descriptions
| Column Name
| Column Type
| Description
|
| TRADEPOSCN_ID
| BIGINT NOT NULL
| Generated unique key.
|
| MEMBER_ID
| BIGINT NOT NULL
| The owner of the TradingPositionContainer.
|
| PRODUCTSET_ID
| INTEGER
| The ProductSet the specifies the list of products contained in the TradingPositionContainer.
|
| DESCRIPTION
| VARCHAR(254)
| A brief description of the TradingPositionContainer, suitable for display to an administrator managing TradingPositionContainers.
|
| NAME
| VARCHAR(254) NOT NULL
| A mnemonic name for the TradingPositionContainer, unique for a particular owner.
|
| PRECEDENCE
| DOUBLE NOT NULL DEFAULT 0
| When more than one Trading Position Containers are qualified at a particular time, the one with the highest precedence is used.
|
| MARKFORDELETE
| INTEGER NOT NULL DEFAULT 0
| Indicates if this TradingPositionContainer is marked for deletion:
0 = No.
1 = Yes, the TradingPositionContainer has been marked for deletion and should not be used.
|
| TYPE
| CHAR(1) DEFAULT 'S'
| The kind of the Trading Position Container as follows:
S = standard price list which contains the base prices for the products in the store catalog
C = custom price list which specifies the list of products and their customized prices
|
| FLAGS
| INTEGER NOT NULL DEFAULT 0
| This column contains the following bit flag indicating special processing to be performed by task commands that find prices for customers: 1 = restricted. To use TradingPositions in this TradingPositionContainer, the customer must be in one of the associated MemberGroups. The associated MemberGroups are recognized by the Store as customer groups (see MGPTRDPSCN and STOREMBRGP). Use the TermAndCondition and Participant objects to limit the use of TradingPositionContainers to certain customers. See the TRADING, TERMCOND, and PARTICIPNT tables for current information. No other bit flags can be stored in this column.
This table is deprecated and is provided for backward compatibility only.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|