If the TradeDate Field in the FIX message is a stock instrument, data in the FIX message maps into a Stock Trade RDS message, which is stored in the STOCK_TRADE table.
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
|