Vendor Cash Flow Data Map Table

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