...
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 | Asset Identifiers Model | 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 | ||||||
...