Database Table: TRADEPOSCN

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
Indexes:
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
Constraints:
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

Referenced By:
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