WebSphere Commerce database table: TRDTYPE

This table stores information about the type of trading for a TradingAgreement.


Column Description(s):
Column NameColumn TypeDescription
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(es):
Index NameIndexed Column NamesIndex Type
SQL050212031324070 TRDTYPE_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_866 TRDTYPE_ID TRADING TRDTYPE_ID Cascade
F_884 TRDTYPE_ID TRDTYPEDSC TRDTYPE_ID Cascade

Feedback