Reference > Database > WebSphere Commerce database tables > T
WebSphere Commerce database table: TRADEPOSCN
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 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 Trading Position Container type:
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
E = external price list imported from an external system E = external price list which specifies the list of products and their customized prices. The difference between external price list and custom price list is that the former allows the user interface to only pass any updates to the server, and does not need to send the entire price list definition. When creating a price list in WebSphere Commerce Accelerator Catalog Filter, by default external price list is created; if customer would like to create custom price list, they need to edit the properties file StoreCreationWizardRB.properties and uncomment the line "priceListType=C".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.
Indexes Index Name Indexed Column Names Index Type I0000255 MEMBER_ID+NAME Unique Index SQL100520030442200 TRADEPOSCN_ID Primary Key I0000814 PRODUCTSET_ID Non-Unique Index I442156 TRADEPOSCN_ID+TYPE Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_865 MEMBER_ID MEMBER MEMBER_ID Cascade F_864 PRODUCTSET_ID PRODUCTSET PRODUCTSET_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_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
Related reference
_vcc_freeselect_bottom_