...
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).
| Info | ||
|---|---|---|
| ||
Before loading Warehouse Broker Trade Quote you should have a Warehouse Trade record with corresponding identifiers already loaded in DB. |
Stream Logic
| Anchor | ||||
|---|---|---|---|---|
|
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
| Info | title | 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. |
| Expand | ||||||
|---|---|---|---|---|---|---|
| ||||||
|
Refer to the data map table for Warehouse Broker Trade Quote object.
...