WebSphere Commerce 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 Description(s):
Column NameColumn TypeDescription
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 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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000255 MEMBER_ID+NAME Unique Index
SQL050212031322780 TRADEPOSCN_ID Primary Key
I0000814 PRODUCTSET_ID Non-Unique Index
I442156 TRADEPOSCN_ID+TYPE Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_865 MEMBER_ID MEMBER MEMBER_ID Cascade
F_864 PRODUCTSET_ID PRODUCTSET PRODUCTSET_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_227 TRADEPOSCN_ID CATGRPTPC TRADEPOSCN_ID Cascade
F_1150 TRADEPOSCN_ID DKOFFER 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

Feedback