Versions Compared

Old Version 4

changes.mady.by.user Dmitry Donosiyan (Unlicensed)

Saved on

compared with

New Version 5

changes.mady.by.user Dmitry Donosiyan (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


 

Element

Optional/Required

Value Type

SP ParameterSP Type

Eagle DB

DB Table

DB Field

DB Field TypeDB Required

XPATH

objectTypeRequiredObjectTypeEnum  
not stored in DBEagleML\warehouseTransaction\warehouseBrokerTradeQuote\objectType
objectIdOptional
ObjectId  
not stored in DBEagleML\warehouseTransaction\warehouseBrokerTradeQuote\objectId
objectDescriptionOptional
FeedTypeEnum  
not stored in DBEagleML\warehouseTransaction\warehouseBrokerTradeQuote\objectDescription
updateTimestampOptional
dateTime  
TRADESDBOTRADE_QUOTESUPDATE_DATEDATENEagleML\warehouseTransaction\warehouseBrokerTradeQuote\updateTimestamp
customElementsNot recommendedCustom Elements
custom elements - reserved for customizationEagleML\warehouseTransaction\warehouseBrokerTradeQuote\customElements
sourceNameOptional
string - used in resolution logicsin_short_desc PACE_MASTERDBOINTERFACESSHORT_DESCCHAR(15)NEagleML\warehouseTransaction\warehouseBrokerTradeQuote\sourceName
updateSourceOptional
stringin_update_source TRADESDBOTRADEUPDATE_SOURCECHAR(8)NEagleML\warehouseTransaction\warehouseBrokerTradeQuote\updateSource
batchCollectErrorsFlagOptional
YesNoOptionEnum  
not stored in DBEagleML\warehouseTransaction\warehouseBrokerTradeQuote\batchCollectErrorsFlag
singleRowCommitFlagOptional
YesNoOptionEnum  
not stored in DBEagleML\warehouseTransaction\warehouseBrokerTradeQuote\singleRowCommitFlag
masterTicketNumberRequiredstringin_fund_inv_num TRADESDBOTRADEMASTER_TICKET_NUMBERVARCHAR2(255)NEagleML\warehouseTransaction\warehouseBrokerTradeQuote\masterTicketNumber
bidOptional
decimalin_bid TRADESDBOTRADE_QUOTESBIDNUMBER(38,12)NEagleML\warehouseTransaction\warehouseBrokerTradeQuote\bid
bidRateOptional
decimalin_bid_rate TRADESDBOTRADE_QUOTESBID_RATENUMBER(38,12)NEagleML\warehouseTransaction\warehouseBrokerTradeQuote\bidRate
bidSpreadOptional
decimalin_bid_spread TRADESDBOTRADE_QUOTESBID_SPREADNUMBER(38,12)NEagleML\warehouseTransaction\warehouseBrokerTradeQuote\bidSpread
askOptional
decimalin_ask TRADESDBOTRADE_QUOTESASKNUMBER(38,12)NEagleML\warehouseTransaction\warehouseBrokerTradeQuote\ask
askRateOptional
decimalin_ask_rate TRADESDBOTRADE_QUOTESASK_RATENUMBER(38,12)NEagleML\warehouseTransaction\warehouseBrokerTradeQuote\askRate
askSpreadOptional
decimalin_ask_spread TRADESDBOTRADE_QUOTESASK_SPREADNUMBER(38,12)NEagleML\warehouseTransaction\warehouseBrokerTradeQuote\askSpread
quoteTypeOptional
stringin_quote_type TRADESDBOTRADE_QUOTESQUOTE_TYPEVARCHAR2(255)NEagleML\warehouseTransaction\warehouseBrokerTradeQuote\quoteType
brokerCodeOptional
stringin_broker TRADESDBOTRADE_QUOTESBROKERVARCHAR2(255)NEagleML\warehouseTransaction\warehouseBrokerTradeQuote\brokerCode
tradeIdOptionalExtract onlystring  
TRADESDBOTRADE_QUOTESTRADE_IDNUMBER(38)NEagleML\warehouseTransaction\warehouseBrokerTradeQuote\tradeId

...