Broker Rate Data Map Table
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 |