This table represents a TradingPositionContainer, which 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 Name | Column Type | Column Description |
---|---|---|
DESCRIPTION | VARCHAR (254) NULL |
A brief description of the TradingPositionContainer, suitable for display to an administrator managing TradingPositionContainers. |
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 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 column is deprecated and is provided for backward compatibility only. |
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. |
MEMBER_ID | BIGINT NOT NULL |
The owner of the TradingPositionContainer. |
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. |
PRODUCTSET_ID | INTEGER NULL |
The ProductSet the specifies the list of products contained in the TradingPositionContainer. |
TRADEPOSCN_ID | BIGINT NOT NULL |
Generated unique key. |
TYPE | CHARACTER (1) NULL, 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 |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000255 | MEMBER_ID, NAME | Unique Index |
I442156 | TRADEPOSCN_ID, TYPE | Non-Unique Index |
SQL030416035135940 | TRADEPOSCN_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_864 | PRODUCTSET_ID | PRODUCTSET | PRODUCTSET_ID | Cascade |
F_865 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_227 | TRADEPOSCN_ID | CATGRPTPC | TRADEPOSCN_ID | Cascade |
F_460 | TRADEPOSCN_ID | MGPTRDPSCN | TRADEPOSCN_ID | Cascade |
F_467 | TRADEPOSCN_ID | OFFER | TRADEPOSCN_ID | Cascade |
F_631 | TRADEPOSCN_ID | PURCHASELT | TRADEPOSCN_ID | Cascade |
F_832 | TRADEPOSCN_ID | TDPSCNCNTR | TRADEPOSCN_ID | Cascade |
F_913 | TRADEPOSCN_ID | TRDPSCNXML | TRADEPOSCN_ID | Cascade |