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 |