If the TradeDate Field in the FIX message is an option instrument, data in the FIX message maps into an Option Trade RDS message, and is stored in the OPTION_TRADE table.
OPTION_TRADE conditions
|
FIX message field
|
Table column
|
|
SecurityID/Symbol
|
INSTRUMENT_ID
|
|
TradeDate
|
TRADE_DATE
|
|
AdvID
|
TRADE_SEQ_NBR
|
|
There is no OPEN_INTEREST in Advertisement
|
OPEN_INTEREST
|
|
TransactTime
|
TRADE_TIME
|
|
Price
|
TRADE_PRICE
|
|
Quantity
|
TRADE_SIZE
|