Warehouse Broker Trade Quote Data Map Table
Element | Optional/Required | Value Type | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | XPATH |
---|---|---|---|---|---|---|---|---|
objectType | Required | ObjectTypeEnum | Â | not stored in DB | EagleML\warehouseTransaction\warehouseBrokerTradeQuote\objectType | |||
objectId | Â | ObjectId | Â | not stored in DB | EagleML\warehouseTransaction\warehouseBrokerTradeQuote\objectId | |||
objectDescription | Â | FeedTypeEnum | Â | not stored in DB | EagleML\warehouseTransaction\warehouseBrokerTradeQuote\objectDescription | |||
updateTimestamp | Â | dateTime | Â | TRADESDBO | TRADE_QUOTES | UPDATE_DATE | DATE | EagleML\warehouseTransaction\warehouseBrokerTradeQuote\updateTimestamp |
customElements | Not recommended | Custom Elements |  | custom elements - reserved for customization | EagleML\warehouseTransaction\warehouseBrokerTradeQuote\customElements | |||
sourceName | Â | string - used in resolution logics | in_short_desc | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML\warehouseTransaction\warehouseBrokerTradeQuote\sourceName |
updateSource | Â | string | in_update_source | TRADESDBO | TRADE | UPDATE_SOURCE | CHAR(8) | EagleML\warehouseTransaction\warehouseBrokerTradeQuote\updateSource |
batchCollectErrorsFlag | Â | YesNoOptionEnum | Â | not stored in DB | EagleML\warehouseTransaction\warehouseBrokerTradeQuote\batchCollectErrorsFlag | |||
singleRowCommitFlag | Â | YesNoOptionEnum | Â | not stored in DB | EagleML\warehouseTransaction\warehouseBrokerTradeQuote\singleRowCommitFlag | |||
masterTicketNumber | Required | string | in_fund_inv_num | TRADESDBO | TRADE | MASTER_TICKET_NUMBER | VARCHAR2(255) | EagleML\warehouseTransaction\warehouseBrokerTradeQuote\masterTicketNumber |
bid | Â | decimal | in_bid | TRADESDBO | TRADE_QUOTES | BID | NUMBER(38,12) | EagleML\warehouseTransaction\warehouseBrokerTradeQuote\bid |
bidRate | Â | decimal | in_bid_rate | TRADESDBO | TRADE_QUOTES | BID_RATE | NUMBER(38,12) | EagleML\warehouseTransaction\warehouseBrokerTradeQuote\bidRate |
bidSpread | Â | decimal | in_bid_spread | TRADESDBO | TRADE_QUOTES | BID_SPREAD | NUMBER(38,12) | EagleML\warehouseTransaction\warehouseBrokerTradeQuote\bidSpread |
ask | Â | decimal | in_ask | TRADESDBO | TRADE_QUOTES | ASK | NUMBER(38,12) | EagleML\warehouseTransaction\warehouseBrokerTradeQuote\ask |
askRate | Â | decimal | in_ask_rate | TRADESDBO | TRADE_QUOTES | ASK_RATE | NUMBER(38,12) | EagleML\warehouseTransaction\warehouseBrokerTradeQuote\askRate |
askSpread | Â | decimal | in_ask_spread | TRADESDBO | TRADE_QUOTES | ASK_SPREAD | NUMBER(38,12) | EagleML\warehouseTransaction\warehouseBrokerTradeQuote\askSpread |
quoteType | Â | string | in_quote_type | TRADESDBO | TRADE_QUOTES | QUOTE_TYPE | VARCHAR2(255) | EagleML\warehouseTransaction\warehouseBrokerTradeQuote\quoteType |
brokerCode | Â | string | in_broker | TRADESDBO | TRADE_QUOTES | BROKER | VARCHAR2(255) | EagleML\warehouseTransaction\warehouseBrokerTradeQuote\brokerCode |
tradeId | Extract only | string | Â | TRADESDBO | TRADE_QUOTES | TRADE_ID | NUMBER(38) | EagleML\warehouseTransaction\warehouseBrokerTradeQuote\tradeId |
Â