Vendor Cash Flow 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/vendorCashFlow/objectType |
| ||
objectId | Optional | ObjectId |
|
|
| not stored in DB |
| EagleML/referenceTransaction/vendorCashFlow/objectId |
| ||
objectDescription | Optional | FeedTypeEnum |
|
|
| not stored in DB |
| EagleML/referenceTransaction/vendorCashFlow/objectDescription |
| ||
updateTimestamp | Optional | dateTime |
|
|
| not stored in DB |
| EagleML/referenceTransaction/vendorCashFlow/updateTimestamp |
| ||
customElements | Not recommended | CustomElements |
|
|
| CustomElements - reserved for customizations | EagleML/referenceTransaction/vendorCashFlow/customElements |
| |||
sourceName | Optional | string | 1102 | in_short_desc | S | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/referenceTransaction/vendorCashFlow/sourceName |
|
updateSource | Optional | string | 944 | in_ird_update_source | S | SECURITYDBO | VENDOR_CASH_FLOW | UPDATE_SOURCE | VARCHAR2(255) | EagleML/referenceTransaction/vendorCashFlow/updateSource |
|
effectiveDate | Optional | date | 1109 | in_effective_date | S | SECURITYDBO | VENDOR_CASH_FLOW | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/vendorCashFlow/effectiveDate |
|
languageId | Optional | integer |
|
|
| not stored in DB |
| EagleML/referenceTransaction/vendorCashFlow/languageId |
| ||
tagNochangecase | Optional | string | 4637 |
|
| not stored in DB |
| EagleML/referenceTransaction/vendorCashFlow/tagNochangecase |
| ||
preserveNull | Optional | string | 5284 |
|
| not stored in DB |
| EagleML/referenceTransaction/vendorCashFlow/preserveNull |
| ||
noLoadValidationFlag | Optional | YesNoOptionEnum |
|
|
| not stored in DB, used to manage the download logic |
| EagleML/referenceTransaction/vendorCashFlow/noLoadValidationFlag |
| ||
accountingValidationFlag | Optional | YesNoOptionEnum |
|
|
| not stored in DB, used to manage the download logic |
| EagleML/referenceTransaction/vendorCashFlow/accountingValidationFlag |
| ||
| EagleML/referenceTransaction/vendorCashFlow/ |
| |||||||||
updateType | Optional | string | 1767 | in_update_type | S | not stored in DB |
| EagleML/referenceTransaction/vendorCashFlow/updateType |
| ||
fieldCompareFlag | Optional | YesNoOptionEnum | 989 | in_989_flag | S | not stored in DB |
| EagleML/referenceTransaction/vendorCashFlow/fieldCompareFlag |
| ||
journalizingFlag | Optional | JournalizingFlagEnum | 1293 | in_journal_flag | S | not stored in DB |
| EagleML/referenceTransaction/vendorCashFlow/journalizingFlag |
| ||
originalBalance | Optional | decimal | 11757 | in_original_balance | N | SECURITYDBO | VENDOR_CASH_FLOW | ORIGINAL_BALANCE | number(38,12) | EagleML/referenceTransaction/vendorCashFlow/originalBalance |
|
currentBalance | Optional | decimal | 11758 | in_current_balance | N | SECURITYDBO | VENDOR_CASH_FLOW | CURRENT_BALANCE | number(38,12) | EagleML/referenceTransaction/vendorCashFlow/currentBalance |
|
effectiveCoupon | Optional | decimal | 11759 | in_effective_coupon | N | SECURITYDBO | VENDOR_CASH_FLOW | EFFECTIVE_COUPON | number(38,12) | EagleML/referenceTransaction/vendorCashFlow/effectiveCoupon |
|
cashFlowType | Optional | string | 11760 | in_cash_flow_type | S | SECURITYDBO | VENDOR_CASH_FLOW | CASH_FLOW_TYPE | varchar2(12) | EagleML/referenceTransaction/vendorCashFlow/cashFlowType |
|
speedType | Optional | string | 11761 | in_speed_type | S | SECURITYDBO | VENDOR_CASH_FLOW | SPEED_TYPE | varchar2(12) | EagleML/referenceTransaction/vendorCashFlow/speedType |
|
speedValue | Optional | decimal | 11762 | in_speed_value | N | SECURITYDBO | VENDOR_CASH_FLOW | SPEED_VALUE | number(28,12) | EagleML/referenceTransaction/vendorCashFlow/speedValue |
|
flowDate | Optional | date | 11763 | in_flow_date | S | SECURITYDBO | VENDOR_CASH_FLOW | FLOW_DATE | date | EagleML/referenceTransaction/vendorCashFlow/flowDate |
|
principalFlow | Optional | decimal | 11764 | in_principal_flow | N | SECURITYDBO | VENDOR_CASH_FLOW | PRINCIPAL_FLOW | number(38,12) | EagleML/referenceTransaction/vendorCashFlow/principalFlow |
|
interestFlow | Optional | decimal | 11765 | in_interest_flow | N | SECURITYDBO | VENDOR_CASH_FLOW | INTEREST_FLOW | number(38,12) | EagleML/referenceTransaction/vendorCashFlow/interestFlow |
|
totalPrincipalInterest | Optional | decimal | 11766 | in_total_principal_interest | N | SECURITYDBO | VENDOR_CASH_FLOW | TOTAL_PRINCIPAL_INTEREST | number(28,12) | EagleML/referenceTransaction/vendorCashFlow/totalPrincipalInterest |
|
remainingBalance | Optional | decimal | 11767 | in_remaining_balance | N | SECURITYDBO | VENDOR_CASH_FLOW | REMAINING_BALANCE | number(28,12) | EagleML/referenceTransaction/vendorCashFlow/remainingBalance |
|
pvCashFlow | Optional | decimal | 9098 | in_pv_cash_flow | N | SECURITYDBO | VENDOR_CASH_FLOW | PV_CASH_FLOW | number(38,12) | EagleML/referenceTransaction/vendorCashFlow/pvCashFlow |
|
pvPrincipalFlow | Optional | decimal | 9099 | in_pv_principal_flow | N | SECURITYDBO | VENDOR_CASH_FLOW | PV_PRINCIPAL_FLOW | number(38,12) | EagleML/referenceTransaction/vendorCashFlow/pvPrincipalFlow |
|
pvInterestFlow | Optional | decimal | 9100 | in_pv_interest_flow | N | SECURITYDBO | VENDOR_CASH_FLOW | PV_INTEREST_FLOW | number(38,12) | EagleML/referenceTransaction/vendorCashFlow/pvInterestFlow |
|
discountFactor | Optional | decimal | 9101 | in_discount_factor | N | SECURITYDBO | VENDOR_CASH_FLOW | DISCOUNT_FACTOR | number(38,12) | EagleML/referenceTransaction/vendorCashFlow/discountFactor |
|
accruedInterest | Optional | decimal | 9102 | in_accrued_interest | N | SECURITYDBO | VENDOR_CASH_FLOW | ACCRUED_INTEREST | number(38,12) | EagleML/referenceTransaction/vendorCashFlow/accruedInterest |
|
cashFlowReleaseStatus | Optional | cashFlowReleaseStatusEnum | 11795 | in_release_status | S | SECURITYDBO | VENDOR_CASH_FLOW | RELEASE_STATUS | varchar2(1) | EagleML/referenceTransaction/vendorCashFlow/cashFlowReleaseStatus |
|
writeDowns | Optional | decimal | 16138 | in_write_downs | N | SECURITYDBO | VENDOR_CASH_FLOW | WRITE_DOWNS | number(38,12) | EagleML/referenceTransaction/vendorCashFlow/writeDowns |
|