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.

Required Elements

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:

Batch Mode