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.
This table is deprecated and is provided for backward
compatibility only. |
| OPTCOUNTER | SMALLINT | 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 |