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