ORDITRD

Each row of this table indicates a TradingAgreement that was searched to obtain the price for an OrderItem. These rows are created by the OrderItemAdd and OrderItemUpdate commands.

Column Descriptions:

NameTypeDescription
ORDERITEMS_IDBIGINT NOT NULLThe OrderItem.
TRADING_IDBIGINT NOT NULLThe TradingAgreement.
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>ORDERITEMS_ID+TRADING_IDPrimary Key
I0000663TRADING_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_530TRADING_IDTRADINGTRADING_IDCascade
F_531ORDERITEMS_IDORDERITEMSORDERITEMS_IDCascade