Warehouse Broker Trade Quote Data Map Table
- Natalie Gesin (Deactivated)
- Dmitry Donosiyan (Unlicensed)
Owned by Natalie Gesin (Deactivated)
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 | |