IssueFxPcRate Data Map Table
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Larry Ackerman
- 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/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 | ||