WebSphere Commerce database table: TRDTYPE
This table stores information about the type of trading for a TradingAgreement.
Column Descriptions
| Column Name
| Column Type
| Description |
| TRDTYPE_ID
| INTEGER NOT NULL
| Trading type ID. Valid values are as follows:
0 = Account
1 = Contract
2 = RFQReq
3 = RFQResp
4 = RFQResult
5 = Exchange
6 = Auction
7 = ReverseAuction
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|
Indexes
| Index Name
| Indexed Column Names
| Index Type |
| SQL060903235304340
| TRDTYPE_ID
| Primary Key
|
| Constraint Name
| Referenced Column Name
| Foreign Table Name
| Foreign Column Names
| Constraint Type |
| F_866
| TRDTYPE_ID
| TRADING
| TRDTYPE_ID
| Cascade
|
| F_884
| TRDTYPE_ID
| TRDTYPEDSC
| TRDTYPE_ID
| Cascade
|
Related reference