Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

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).

Important Note

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

Note

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.
 Click to expand an example of incoming EagleML message

You should use your masterTicketNumber value in the batchKey field for Warehouse Broker Trade Quote .

<EagleML
eaglemlVersion="2-0"
eaglemlType="WarehouseTransactionMessage"
xsi:schemaLocation="http://www.eagleinvsys.com/2011/EagleML-2-0 eagleml-main-2-0.xsd"
xsi:type="WarehouseTransactionMessage"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://www.eagleinvsys.com/2011/EagleML-2-0">
<warehouseTransaction>
    <header>
        <batchKey>MTN_20160202_101_101</batchKey>
        <objectType>WarehouseBrokerTradeQuote</objectType>
    </header>
    <warehouseBrokerTradeQuote>
        <objectType>WarehouseBrokerTradeQuote</objectType>
        <objectId>WarehouseBrokerTradeQuote</objectId>
        <sourceName>EAGLE PACE</sourceName>
        <updateSource>MCADMIN</updateSource>
        <masterTicketNumber>1200303M</masterTicketNumber>
        <bid>1</bid>
        <bidRate>2</bidRate>
        <bidSpread>3</bidSpread>
        <ask>4</ask>
        <askRate>5</askRate>
        <askSpread>6</askSpread>
        <quoteType>TRD_QUERY</quoteType>
        <brokerCode>STAR_EAGLE</brokerCode>
        <tradeId>1000029</tradeId>
    </warehouseBrokerTradeQuote>
</warehouseTransaction>
</EagleML>

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

  • No labels