| Element | Optional/Required | Value Type | 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 | SECURITYDBO | BROKER_RATES | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/brokerRate/effectiveDate |
| entityId | Required | string | SECURITYDBO | BROKER_RATES | ENTITY_ID | CHAR(8) | EagleML/referenceTransaction/brokerRate/entityId |
| entryType | Required | string | SECURITYDBO | BROKER_RATES | ENTRY_TYPE | CHAR(4) | EagleML/referenceTransaction/brokerRate/entryType |
| assetCurrency | Required | string | SECURITYDBO | BROKER_RATES | FROM_SEC_ALIAS | NUMBER | EagleML/referenceTransaction/brokerRate/fromCurrency/assetCurrency |
| assetCurrency | Required | string | SECURITYDBO | BROKER_RATES | TO_SEC_ALIAS | NUMBER | EagleML/referenceTransaction/brokerRate/toCurrency/assetCurrency |
| brokerCode | Required | string | SECURITYDBO | BROKER_RATES | BROKER_CODE | VARCHAR2(20) | EagleML/referenceTransaction/brokerRate/brokerCode |
| spotRate | Required | decimal | SECURITYDBO | BROKER_RATES | SPOT_RATE | NUMBER(28,12) | EagleML/referenceTransaction/brokerRate/spotRate |
General
Content
Integrations