Reference > Database > WebSphere Commerce database tables > O
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 Name Column Type Description ORDERITEMS_ID BIGINT NOT NULL The OrderItem. TRADING_ID BIGINT NOT NULL The TradingAgreement. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030403370 ORDERITEMS_ID+TRADING_ID Primary Key I0000663 TRADING_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_531 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade F_530 TRADING_ID TRADING TRADING_ID Cascade
Related reference
_vcc_freeselect_bottom_