IssueFxRate Data Map Table
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Dmitry Donosiyan (Unlicensed)
Element | Optional /Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
|---|---|---|---|---|---|---|---|---|---|---|
objectType | Optional | ObjectTypeEnum |
|
|
| not stored in DB |
| EagleML/referenceTransaction/issueFxRate/objectType | ||
objectId | Optional | ObjectId |
|
|
| not stored in DB |
| EagleML/referenceTransaction/issueFxRate/objectId | ||
objectDescription | Optional | FeedTypeEnum |
|
|
| not stored in DB |
| EagleML/referenceTransaction/issueFxRate/objectDescription | ||
updateTimestamp | Optional | dateTime |
|
|
| SECURITYDBO | FX_RATES | UPDATE_DATE | DATE | EagleML/referenceTransaction/issueFxRate/updateTimestamp |
customElements | Not recommended | CustomElements |
|
|
| CustomElements - reserved for customizations | EagleML/referenceTransaction/issueFxRate/customElements | |||
sourceName | Optional | string | 1102 | in_short_desc | S | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR (15) | EagleML/referenceTransaction/issueFxRate/sourceName |
updateSource | Optional | string | 944 | in_update_source | S | SECURITYDBO | FX_RATES | UPDATE_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issueFxRate/updateSource |
effectiveDate | Optional | date | 1109 | in_effective_date | S | SECURITYDBO | FX_RATES | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/issueFxRate/effectiveDate |
languageId | Optional | integer |
|
|
| not stored in DB |
|
|
| EagleML/referenceTransaction/issueFxRate/languageId |
tagNochangecase | Optional | string |
|
|
| not stored in DB |
|
|
| EagleML/referenceTransaction/issueFxRate/tagNochangecase |
preserveNull | Optional | string |
|
|
| not stored in DB |
|
|
| EagleML/referenceTransaction/issueFxRate/preserveNull |
noLoadValidationFlag | Optional | YesNoOptionEnum |
|
|
| not stored in DB |
|
|
| EagleML/referenceTransaction/issueFxRate/noLoadValidationFlag |
accountingValidationFlag | Optional | YesNoOptionEnum |
|
|
| not stored in DB |
|
|
| EagleML/referenceTransaction/issueFxRate/accountingValidationFlag |
journalizingFlag | Optional | JournalizingFlagEnum |
|
|
| not stored in DB |
|
|
| EagleML/referenceTransaction/issueFxRate/journalizingFlag |
exceptionProcessingSwitch | Optional | YesNoBothOptionEnum |
|
|
| not stored in DB |
|
|
| EagleML/referenceTransaction/issueFxRate/exceptionProcessingSwitch |
fromCurrency | Required | AssetIdentifiersDataModel | 363 | EagleML/referenceTransaction/issueFxRate/fromCurrency/ | ||||||
toCurrency | Required | AssetIdentifiersDataModel | 313 | EagleML/referenceTransaction/issueFxRate/toCurrency/ | ||||||
exchangeRate | Optional | decimal | 96 | in_spot_rate | F | SECURITYDBO | FX_RATES | SPOT_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/exchangeRate |
offerrate | Optional | decimal | 947 | in_offerrate | F | SECURITYDBO | FX_RATES | OFFERRATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/offerrate |
originalSource | Optional | string | 4003 | in_original_source | S | SECURITYDBO | FX_RATES | ORIGINAL_SOURCE | VARCHAR2(20) | EagleML/referenceTransaction/issueFxRate/originalSource |
for1MnthRate | Optional | decimal | 4473 | in_for_1mnth_rate | F | SECURITYDBO | FX_RATES | FOR_1MNTH_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for1MnthRate |
for2MnthRate | Optional | decimal | 4474 | in_for_2mnth_rate | F | SECURITYDBO | FX_RATES | FOR_2MNTH_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for2MnthRate |
for3MnthRate | Optional | decimal | 4475 | in_for_3mnth_rate | F | SECURITYDBO | FX_RATES | FOR_3MNTH_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for3MnthRate |
for4MnthRate | Optional | decimal | 10432 | in_for_4mnth_rate | F | SECURITYDBO | FX_RATES | FOR_4MNTH_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for4MnthRate |
for5MnthRate | Optional | decimal | 10433 | in_for_5mnth_rate | F | SECURITYDBO | FX_RATES | FOR_5MNTH_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for5MnthRate |
for6MnthRate | Optional | decimal | 4476 | in_for_6mnth_rate | F | SECURITYDBO | FX_RATES | FOR_6MNTH_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for6MnthRate |
for7MnthRate | Optional | decimal | 10434 | in_for_7mnth_rate | F | SECURITYDBO | FX_RATES | FOR_7MNTH_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for7MnthRate |
for8MnthRate | Optional | decimal | 10435 | in_for_8mnth_rate | F | SECURITYDBO | FX_RATES | FOR_8MNTH_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for8MnthRate |
for9MnthRate | Optional | decimal | 10436 | in_for_9mnth_rate | F | SECURITYDBO | FX_RATES | FOR_9MNTH_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for9MnthRate |
for10MnthRate | Optional | decimal | 10437 | in_for_10mnth_rate | F | SECURITYDBO | FX_RATES | FOR_10MNTH_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for10MnthRate |
for11MnthRate | Optional | decimal | 10438 | in_for_11mnth_rate | F | SECURITYDBO | FX_RATES | FOR_11MNTH_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for11MnthRate |
for12MnthRate | Optional | decimal | 4354 | in_for_12mnth_rat | F | SECURITYDBO | FX_RATES | FOR_12MNTH_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for12MnthRate |
for13MnthRate | Optional | decimal | 10439 | in_for_13mnth_rate | F | SECURITYDBO | FX_RATES | FOR_13MNTH_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for13MnthRate |
for14MnthRate | Optional | decimal | 10440 | in_for_14mnth_rate | F | SECURITYDBO | FX_RATES | FOR_14MNTH_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for14MnthRate |
for15MnthRate | Optional | decimal | 10441 | in_for_15mnth_rate | F | SECURITYDBO | FX_RATES | FOR_15MNTH_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for15MnthRate |
for16MnthRate | Optional | decimal | 10442 | in_for_16mnth_rate | F | SECURITYDBO | FX_RATES | FOR_16MNTH_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for16MnthRate |
for17MnthRate | Optional | decimal | 10443 | in_for_17mnth_rate | F | SECURITYDBO | FX_RATES | FOR_17MNTH_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for17MnthRate |
for18MnthRate | Optional | decimal | 10444 | in_for_18mnth_rate | F | SECURITYDBO | FX_RATES | FOR_18MNTH_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for18MnthRate |
for19MnthRate | Optional | decimal | 10445 | in_for_19mnth_rate | F | SECURITYDBO | FX_RATES | FOR_19MNTH_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for19MnthRate |
for20MnthRate | Optional | decimal | 10446 | in_for_20mnth_rate | F | SECURITYDBO | FX_RATES | FOR_20MNTH_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for20MnthRate |
for21MnthRate | Optional | decimal | 10447 | in_for_21mnth_rate | F | SECURITYDBO | FX_RATES | FOR_21MNTH_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for21MnthRate |
for22MnthRate | Optional | decimal | 10448 | in_for_22mnth_rate | F | SECURITYDBO | FX_RATES | FOR_22MNTH_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for22MnthRate |
for23MnthRate | Optional | decimal | 10449 | in_for_23mnth_rate | F | SECURITYDBO | FX_RATES | FOR_23MNTH_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for23MnthRate |
for24MnthRate | Optional | decimal | 10450 | in_for_24mnth_rate | F | SECURITYDBO | FX_RATES | FOR_24MNTH_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for24MnthRate |
bidRate | Optional | decimal | 4477 | in_bidrate | F | SECURITYDBO | FX_RATES | BIDRATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/bidRate |
fxRatesFactors | Optional | string | 4414 | in_factor | S | SECURITYDBO | FX_RATES | FACTOR | VARCHAR2(10) | EagleML/referenceTransaction/issueFxRate/fxRatesFactors |
for7dayRate | Optional | decimal | 10431 | in_for_7day_rate | F | SECURITYDBO | FX_RATES | FOR_7DAY_RATE | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/for7dayRate |
UDF1 | Optional | decimal | 11828 | in_user_group_float1 | F | SECURITYDBO | FX_RATES | USER_GROUP_FLOAT1 | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/UDF1 |
UDF2 | Optional | decimal | 11829 | in_user_group_float2 | F | SECURITYDBO | FX_RATES | USER_GROUP_FLOAT2 | NUMBER(28,12) | EagleML/referenceTransaction/issueFxRate/UDF2 |
onDepositRate | Optional | decimal | 11830 | in_on_deposit_rate | F | SECURITYDBO | FX_RATES | ON_DEPOSIT_RATE | NUMBER(38,12) | EagleML/referenceTransaction/issueFxRate/onDepositRate |
tnDepositRate | Optional | decimal | 11831 | in_tn_deposit_rate | F | SECURITYDBO | FX_RATES | TN_DEPOSIT_RATE | NUMBER(38,12) | EagleML/referenceTransaction/issueFxRate/tnDepositRate |