This table stores information about the type of trading for a TradingAgreement.
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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031324070 | TRDTYPE_ID | Primary Key |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_866 | TRDTYPE_ID | TRADING | TRDTYPE_ID | Cascade |
F_884 | TRDTYPE_ID | TRDTYPEDSC | TRDTYPE_ID | Cascade |