WebSphere Commerce database table: 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 Description(s):
Column NameColumn TypeDescription
ORDERITEMS_ID BIGINT NOT NULL The OrderItem.
TRADING_ID BIGINT NOT NULL The TradingAgreement.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031246830 ORDERITEMS_ID+TRADING_ID Primary Key
I0000663 TRADING_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_531 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade
F_530 TRADING_ID TRADING TRADING_ID Cascade

Feedback