Warehouse Broker Trade Quote Data Map Table

Element

Optional/Required

Value Type

SP Parameter

Eagle DB

DB Table

DB Field

DB Field Type

XPATH

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

Â