WebSphere Commerce database table: TRDPSCNXML

This table is used to store the XML document for a given trading position container.


Column Description(s):
Column NameColumn TypeDescription
TRADEPOSCN_ID BIGINT NOT NULL Primary key. Trading position container ID.
SEQUENCE INTEGER NOT NULL Primary key. Sequence number.
XMLDEFINITION CLOB XML document.
FIELD1 INTEGER Customizable.
FIELD2 INTEGER Customizable.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031323610 TRADEPOSCN_ID+SEQUENCE Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_913 TRADEPOSCN_ID TRADEPOSCN TRADEPOSCN_ID Cascade

Feedback