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 Descriptions
| 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 |
| SQL060903235221880
| 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