If the TradeDate Field in the FIX message is a stock instrument, the data in the FIX message maps into a Stock Trade RDS message.
If the condition is met, the data in the FIX message maps into a Stock Trade RDS message. This data maps into the STOCK_TRADE table. The columns for this table are defined below.
STOCK_TRADE conditions
|
FIX Message Field
|
Table Column
|
|
SecurityID/Symbol
|
INSTRUMENT_ID
|
|
TradeDate
|
TRADE_DATE
|
|
AdvID
|
TRADE_SEQ_NBR
|
|
SecurityID/Symbol
|
TRADING_SYMBOL
|
|
TransactTime
|
TRADE_TIME
|
|
Price
|
TRADE_PRICE
|
|
Quantity
|
TRADE_SIZE
|