Warehouse Broker Trade Quote Inbound Interface
Overview
Warehouse Broker Trade Quotes inbound interface is an instrument to load and update data in the following database tables:
TRADESDBO.TRADE_QUOTES
TRADESDBO.TRADE
Relationship between DB tables TRADESDBO.TRADE and TRADESDBO.TRADE_QUOTES (1:N):
TRADESDBO.TRADE.TRADE_ID = TRADESDBO.TRADE_QUOTES.TRADE_ID
The format of the incoming message is EagleML (WarehouseBrokerTradeQuote complex type).
Before loading Warehouse Broker Trade Quote you should have a Warehouse Trade record with corresponding identifiers already loaded in DB.Â
Stream Logic
EagleML Processing Sequence
Loading Warehouse Broker Trade Quote into DB is performed via eagle_ml-2-0_default_in_xml_warehouse_preproc in two steps:
XSLT transformation. XSLT rule 'eagle_default/in/xml/xslt/wrh_egl_gen_interface3.xsl' is used.
Loading data into the database. The 'eagle_default/in/xml/xml-wh_brokertradequote_v2.xml' rule is used.
​This process involves the TRADESDBO.TRADE_QUOTE_UPLOAD.TRADE_QUOTE_INSUPD bind (in case you use ORA DB) from bind_trade_quote.xml
Trade Id is not specified in incoming message. To define the relationship between Broker Trade Quote and Trade DB table, you should specify the Master Ticket Number. Trade Id will be resolved by the Master Ticket Number in Trade table.
Refer to the data map table for Warehouse Broker Trade Quote object.
The following elements are required in the EagleML message: Master Ticket Number, Trade Quote.
Trade Id is an outbound only element.
Master Ticket Number: warehouseTransaction/warehouseBrokerTradeQuote/masterTicketNumber – mapped to TRADESDBO.TRADE.MASTER_TICKET_NUMBER. This element resolves the Trade Id.
Quote Type: warehouseTransaction/quoteType – resolves the Broker Trade Quote record with Trade Id.
Modes of Data LoadingÂ
Warehouse Broker Trade Quote inbound interface can load data into the DB table in two modes: