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/issueFxPcRate/objectType | |||||||||
objectId | Optional | ObjectId |
|
|
| not stored in DB | EagleML/referenceTransaction/issueFxPcRate/objectId | |||||||||
objectDescription | Optional | FeedTypeEnum |
|
| not stored in DB | EagleML/referenceTransaction/issueFxPcRate/objectDescription | ||||||||||
updateTimestamp | Optional | dateTime |
|
|
| SECURITYDBO | FX_RATES_ORIG | UPDATE_DATE | DATE | EagleML/referenceTransaction/issueFxPcRate/updateTimestamp | ||||||
customElements | Not recommended | CustomElements |
|
|
| CustomElements reserved for customizations | EagleML/referenceTransaction/issueFxPcRate/customElements | |||||||||
sourceName | Optional | string | 1102 | in_short_desc | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR (15) | EagleML/referenceTransaction/issueFxPcRate/sourceName | |||||||
updateSource | Optional | string | 944 | in_update_source | S | SECURITYDBO | FX_RATES_ORIG | UPDATE_SOURCE | VARCHAR2(30) | EagleML/referenceTransaction/issueFxPcRate/updateSource
| ||||||
in_update_source | S | RULESDBO | FX_STATUS | UPDATE_SOURCE | VARCHAR2(50) | |||||||||||
effectiveDate | Optional | date | 1109 | in_effective_date | S | SECURITYDBO | FX_RATES_ORIG | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/issueFxPcRate/effectiveDate | ||||||
in_effective_date | S | RULESDBO | FX_STATUS | EFFECTIVE_DATE | DATE | |||||||||||
in_effective_date | S | RULESDBO | FX_STATUS | LAST_CHANGE_DATE | DATE | |||||||||||
languageId | Optional | integer |
|
|
| not stored in DB |
| EagleML/referenceTransaction/issueFxPcRate/languageId | ||||||||
tagNochangecase | Optional | string |
|
|
| not stored in DB | EagleML/referenceTransaction/issueFxPcRate/tagNochangecase | |||||||||
preserveNull | Optional | string |
|
|
| not stored in DB |
| EagleML/referenceTransaction/issueFxPcRate/preserveNull | ||||||||
noLoadValidationFlag | Optional | YesNoOptionEnum |
|
| not stored in DB |
| EagleML/referenceTransaction/issueFxPcRate/noLoadValidationFlag | |||||||||
accountingValidationFlag | Optional | YesNoOptionEnum |
|
| not stored in DB | EagleML/referenceTransaction/issueFxPcRate/journalizingFlag | ||||||||||
fromCurrency | Required | AssetIdentifiersDataModel | 363 |
| EagleML/referenceTransaction/issueFxPcRate/fromCurrency/ | |||||||||||
in_from_secalias | I | SECURITYDBO | FX_RATES_ORIG | FROM_SECALIAS | NUMBER | |||||||||||
in_from_secalias | I | RULESDBO | FX_STATUS | FROM_SECALIAS | NUMBER (38) | |||||||||||
toCurrency | Required
| AssetIdentifiersDataModel | 313 |
| EagleML/referenceTransaction/issueFxPcRate/toCurrency/ | |||||||||||
in_security_alias | I | SECURITYDBO | FX_RATES_ORIG | SECURITY_ALIAS | NUMBER | |||||||||||
in_security_alias | I | RULESDBO | FX_STATUS | SECURITY_ALIAS | NUMBER (38) | |||||||||||
period | Required | integer | 8568 | in_period | I | SECURITYDBO | FX_RATES_ORIG | PERIOD | NUMBER | EagleML/referenceTransaction/issueFxPcRate/period | ||||||
in_period | I | RULESDBO | FX_STATUS | PERIOD | NUMBER (38) | |||||||||||
bid | Optional | decimal | 8901 | in_bid | F | SECURITYDBO | FX_RATES_ORIG | BID | NUMBER(28,12) | EagleML/referenceTransaction/issueFxPcRate/bid | ||||||
in_current_value | N | RULESDBO | FX_STATUS | CURRENT VALUE | NUMBER (28,12) | |||||||||||
ask | Optional | decimal | 8902 | in_ask | F | SECURITYDBO | FX_RATES_ORIG | ASK | NUMBER(28,12) | EagleML/referenceTransaction/issueFxPcRate/ask | ||||||
in_current_value | N | RULESDBO | FX_STATUS | CURRENT VALUE | NUMBER (28,12) | |||||||||||
mid | Optional | decimal | 8903 | in_mid | F | SECURITYDBO | FX_RATES_ORIG | MID | NUMBER(28,12) | EagleML/referenceTransaction/issueFxPcRate/mid | ||||||
in_current_value | N | RULESDBO | FX_STATUS | CURRENT VALUE | NUMBER (28,12) | |||||||||||
bidCondition | Optional | string | 8576 | in_bid_condition | S | SECURITYDBO | FX_RATES_ORIG | BID_CONDITION | VARCHAR2(20) | EagleML/referenceTransaction/issueFxPcRate/bidCondition | ||||||
in_rate_condition | S | RULESDBO | FX_STATUS | RATE_CONDITION | VARCHAR2(20) | |||||||||||
askCondition | Optional | string | 8577 | in_ask_condition | S | SECURITYDBO | FX_RATES_ORIG | ASK_CONDITION | VARCHAR2(20) | EagleML/referenceTransaction/issueFxPcRate/askCondition |
|
| ||||
in_rate_condition | S | RULESDBO | FX_STATUS | RATE_CONDITION | VARCHAR2(20) | |||||||||||
midCondition
| Optional
| string
| 8578 | in_mid_condition | S | SECURITYDBO | FX_RATES_ORIG | MID_CONDITION | VARCHAR2(20) | EagleML/referenceTransaction/issueFxPcRate/midCondition | ||||||
in_rate_condition | S | RULESDBO | FX_STATUS | RATE_CONDITION | VARCHAR2(20) | |||||||||||
bestRateStatus | Optional | integer |
|
|
| SECURITYDBO | FX_RATES_ORIG | BEST_RATE_STATUS | NUMBER | EagleML/referenceTransaction/issueFxPcRate/bestRateStatus | ||||||
autoFlag | Optional | string | 4856 | in_auto_flag | S | SECURITYDBO | FX_RATES_ORIG | AUTO_FLAG | VARCHAR2(2) | EagleML/referenceTransaction/issueFxPcRate/autoFlag | ||||||
vendorDate | Optional | date | 9454 | in_vendor_date | S | SECURITYDBO | FX_RATES_ORIG | VENDOR_DATE | DATE | EagleML/referenceTransaction/issueFxPcRate/vendorDate | ||||||
vendorTime | Optional | string | 9455 | in_vendor_time | S | SECURITYDBO | FX_RATES_ORIG | VENDOR_TIME | CHAR(8) | EagleML/referenceTransaction/issueFxPcRate/vendorTime | ||||||
| useRdcFX | Optional | string | Not stored in DB. Toggles RDC load mode if set to Y. When global variable :W_USE_RDC_FX: is set to Y or useRdcFx is set to Y, then the RDC_FX_UPLOAD is applied else the FX_UPLOAD process is used. | EagleML/referenceTransaction/issueFxPcRate/useRdcFx | ||||||||||||