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:

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 HCL 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 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.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.


NameColumn NamesType
I0000255MEMBER_ID+NAMEUnique Index
I0000814PRODUCTSET_IDNon-Unique Index
I442156TRADEPOSCN_ID+TYPENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType