Broker Rate Data Map Table

Element

Optional/Required

Value Type

STAR Tag

Eagle DB

DB Table

DB Field

Data Type

XPath

Element

Optional/Required

Value Type

STAR Tag

Eagle DB

DB Table

DB Field

Data Type

XPath

objectType

Required

ObjectTypeEnum

-

not stored in DB

 

 

 

EagleML/referenceTransaction/brokerRate/objectType

objectId

 

ObjectId

-

not stored in DB

 

 

 

EagleML/referenceTransaction/brokerRate/objectId

objectDescription

 

FeedTypeEnum

-

not stored in DB

 

 

 

EagleML/referenceTransaction/brokerRate/objectDescription

effectiveDate

Required

date

1109

SECURITYDBO

BROKER_RATES

EFFECTIVE_DATE

DATE

EagleML/referenceTransaction/brokerRate/effectiveDate

entityId

Required

string

1163

SECURITYDBO

BROKER_RATES

ENTITY_ID

CHAR(8)

EagleML/referenceTransaction/brokerRate/entityId

entryType

Required

string

1882

SECURITYDBO

BROKER_RATES

ENTRY_TYPE

CHAR(4)

EagleML/referenceTransaction/brokerRate/entryType

assetCurrency

Required

string

363

SECURITYDBO

BROKER_RATES

FROM_SEC_ALIAS

NUMBER

EagleML/referenceTransaction/brokerRate/fromCurrency/assetCurrency

assetCurrency

Required

string

313

SECURITYDBO

BROKER_RATES

TO_SEC_ALIAS

NUMBER

EagleML/referenceTransaction/brokerRate/toCurrency/assetCurrency

brokerCode

Required

string

1237

SECURITYDBO

BROKER_RATES

BROKER_CODE

VARCHAR2(20)

EagleML/referenceTransaction/brokerRate/brokerCode

spotRate

Required

decimal

96

SECURITYDBO

BROKER_RATES

SPOT_RATE

NUMBER(28,12)

EagleML/referenceTransaction/brokerRate/spotRate