Reference > Database > WebSphere Commerce database tables > T
WebSphere Commerce database table: TRDPSCNXML
This table is used to store the XML document for a given trading position container.
Column Name Column Type Description 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.
Indexes Index Name Indexed Column Names Index Type SQL100520030443240 TRADEPOSCN_ID+SEQUENCE Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_913 TRADEPOSCN_ID TRADEPOSCN TRADEPOSCN_ID Cascade _vcc_freeselect_bottom_