Reference > Database > WebSphere Commerce database tables > T

WebSphere Commerce database table: TRDTYPE

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... 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
SQL100520030443720	TRDTYPE_ID	Primary Key

Referenced By

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

• Order trading agreement data model

• Contract data model

_vcc_freeselect_bottom_

+

Search Tips   |   Advanced Search