WebSphere Commerce database table: TRADEPOSCN

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:

Name 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. 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".
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.

OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name Column Names Type
<SYSTEM-GENERATED> TRADEPOSCN_ID Primary Key
I0000255 MEMBER_ID+NAME Unique Index
I0000814 PRODUCTSET_ID Non-Unique Index
I442156 TRADEPOSCN_ID+TYPE Non-Unique Index

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_864 PRODUCTSET_ID PRODUCTSET PRODUCTSET_ID Cascade
F_865 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By Child Tables:

Constraint Columns Child Table Child Columns Type
F_1150 TRADEPOSCN_ID DKOFFER TRADEPOSCN_ID Cascade
F_227 TRADEPOSCN_ID CATGRPTPC TRADEPOSCN_ID Cascade
F_3643 TRADEPOSCN_ID STORETPC TRADEPOSCN_ID Cascade
F_3693 TRADEPOSCN_ID DKOFFERADJMNT 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
Contract data model
Offers data model
Product set data model

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

Name	Column Names	Type
<SYSTEM-GENERATED>	TRADEPOSCN_ID	Primary Key
I0000255	MEMBER_ID+NAME	Unique Index
I0000814	PRODUCTSET_ID	Non-Unique Index
I442156	TRADEPOSCN_ID+TYPE	Non-Unique Index

Constraint	Columns	Parent Table	Parent Columns	Type
F_864	PRODUCTSET_ID	PRODUCTSET	PRODUCTSET_ID	Cascade
F_865	MEMBER_ID	MEMBER	MEMBER_ID	Cascade

Constraint	Columns	Child Table	Child Columns	Type
F_1150	TRADEPOSCN_ID	DKOFFER	TRADEPOSCN_ID	Cascade
F_227	TRADEPOSCN_ID	CATGRPTPC	TRADEPOSCN_ID	Cascade
F_3643	TRADEPOSCN_ID	STORETPC	TRADEPOSCN_ID	Cascade
F_3693	TRADEPOSCN_ID	DKOFFERADJMNT	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