TRDPSCNXML

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

Column Descriptions:

NameTypeDescription
TRADEPOSCN_IDBIGINT NOT NULLPrimary key. Trading position container ID.
SEQUENCEINTEGER NOT NULLPrimary key. Sequence number.
XMLDEFINITIONCLOB (1048576)XML document.
FIELD1INTEGERCustomizable.
FIELD2INTEGERCustomizable.
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.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>TRADEPOSCN_ID+SEQUENCEPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_913TRADEPOSCN_IDTRADEPOSCNTRADEPOSCN_IDCascade