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 Descriptions:

NameTypeDescription
TRADEPOSCN_IDBIGINT NOT NULLGenerated unique key.
MEMBER_IDBIGINT NOT NULLThe owner of the TradingPositionContainer.
PRODUCTSET_IDINTEGERThe ProductSet the specifies the list of products contained in the TradingPositionContainer.
DESCRIPTIONVARCHAR (254)A brief description of the TradingPositionContainer, suitable for display to an administrator managing TradingPositionContainers.
NAMEVARCHAR (254) NOT NULLA mnemonic name for the TradingPositionContainer, unique for a particular owner.
PRECEDENCEDOUBLE NOT NULL DEFAULT 0When more than one Trading Position Containers are qualified at a particular time, the one with the highest precedence is used.
MARKFORDELETEINTEGER NOT NULL DEFAULT 0Indicates if this TradingPositionContainer is marked for deletion: 0 = No. 1 = Yes, the TradingPositionContainer has been marked for deletion and should not be used.
TYPECHAR (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. The external price list 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".
FLAGSINTEGER NOT NULL DEFAULT 0This 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.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>TRADEPOSCN_IDPrimary Key
I0000255MEMBER_ID+NAMEUnique Index
I0000814PRODUCTSET_IDNon-Unique Index
I442156TRADEPOSCN_ID+TYPENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_864PRODUCTSET_IDPRODUCTSETPRODUCTSET_IDCascade
F_865MEMBER_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1150TRADEPOSCN_IDDKOFFERTRADEPOSCN_IDCascade
F_227TRADEPOSCN_IDCATGRPTPCTRADEPOSCN_IDCascade
F_3643TRADEPOSCN_IDSTORETPCTRADEPOSCN_IDCascade
F_3693TRADEPOSCN_IDDKOFFERADJMNTTRADEPOSCN_IDCascade
F_460TRADEPOSCN_IDMGPTRDPSCNTRADEPOSCN_IDCascade
F_467TRADEPOSCN_IDOFFERTRADEPOSCN_IDCascade
F_631TRADEPOSCN_IDPURCHASELTTRADEPOSCN_IDCascade
F_832TRADEPOSCN_IDTDPSCNCNTRTRADEPOSCN_IDCascade
F_913TRADEPOSCN_IDTRDPSCNXMLTRADEPOSCN_IDCascade