Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info
titleNote
Please note that price and rate are being loaded into the same DB field via the same tag. price has a higher priority than rate (if price is empty or missing, rate value is used).


Element
Optional/Required
CommentsValue TypeStar TagSP ParameterEagle DBDB TableDB FieldDB Field TypeXpath
objectType
Optional

ObjectTypeEnum

not stored in DB
EagleML/referenceTransaction/schedule/objectType
objectId
Optional

ObjectId

not stored in DB
EagleML/referenceTransaction/schedule/objectId
objectDescription
Optional

FeedTypeEnum

not stored in DB
EagleML/referenceTransaction/schedule/objectDescription
updateTimestamp

Optional


dateTime

not stored in DBDATEEagleML/referenceTransaction/schedule/updateTimestamp
customElementsNot recommendedCustomElements - Complex type

reserved for customizations
EagleML/referenceTransaction/schedule/customElements
sourceName
Optional
Requiredstring - needed for resolution logics1102in_short_descPACE_MASTERDBOINTERFACESSHORT_DESCCHAR(15)EagleML/referenceTransaction/schedule/sourceName
updateSource
Optional

string944in_update_sourceSECURITYDBOSCHEDULEUPDATE_SOURCEVARCHAR2(255)EagleML/referenceTransaction/schedule/updateSource
effectiveDate
Optional
Requireddate1109in_effective_dateSECURITYDBOSCHEDULEEFFECTIVE_DATEDATEEagleML/referenceTransaction/schedule/effectiveDate
languageId

Optional


integer

not stored in DB
EagleML/referenceTransaction/schedule/languageId
tagNochangecase

Optional


string4637
not stored in DB
EagleML/referenceTransaction/schedule/tagNochangecase
preserveNull

Optional


string5284
not stored in DB
EagleML/referenceTransaction/schedule/preserveNull
noLoadValidationFlag
Optional

YesNoOptionEnum

not stored in DB, used in load logics
EagleML/referenceTransaction/schedule/noLoadValidationFlag
accountingValidationFlag
YesNoOptionEnum

not stored in DB, used in load logics
EagleML/referenceTransaction/schedule/accountingValidationFlag
Optional
skipIfExistFlag
YesNoOptionEnum

not stored in DB, used in load logics
EagleML/referenceTransaction/schedule/
accountingValidationFlag
skipIfExistFlag
Asset Identifiers ModelEagleML/referenceTransaction/schedule/
setEligibleFlag
Optional

YesNoOptionEnum

not stored in DB
EagleML/referenceTransaction/schedule/setEligibleFlag
securityMasterSource
Optional

string

PACE_MASTERDBOINTERFACESSHORT_DESC
EagleML/referenceTransaction/schedule/securityMasterSource
scheduleId
Optional

string
3664
3251in_schedule_char1SECURITYDBOSCHEDULESCHEDULE_CHAR1VARCHAR2(30)EagleML/referenceTransaction/schedule/scheduleId
scheduleType

Optional


ScheduleTypeEnum1250in_schedule_sub_typeSECURITYDBOSCHEDULESCHEDULE_SUB_TYPECHAR(8)EagleML/referenceTransaction/schedule/scheduleType
scheduleSubTypeRequiredstring3678in_schedule_typeSECURITYDBOSCHEDULESCHEDULE_TYPECHAR(4)EagleML/referenceTransaction/schedule/scheduleSubType
scheduleStatus
Optional

ScheduleStatusEnum1670in_schedule_statusSECURITYDBOSCHEDULESCHEDULE_STATUSVARCHAR2(12)EagleML/referenceTransaction/schedule/scheduleStatus

price

Optional

decimal

1249

in_schedule_price

SECURITYDBO

SCHEDULE

SCHEDULE_PRICE

NUMBER(28,12)

EagleML/referenceTransaction/schedule/price

rate

Optional

decimal

1249

in_schedule_price

SECURITYDBO

SCHEDULE

SCHEDULE_PRICE

NUMBER(28,12)

EagleML/referenceTransaction/schedule/rate

scheduleAmount
Optional

decimal1669in_schedule_amountSECURITYDBOSCHEDULESCHEDULE_AMOUNTNUMBER(28,12)EagleML/referenceTransaction/schedule/scheduleAmount
scheduleFloat1
Optional

decimal5534in_schedule_float1SECURITYDBOSCHEDULESCHEDULE_FLOAT1NUMBER(28,12)EagleML/referenceTransaction/schedule/scheduleFloat1
endDate
Optional

date73in_end_dateSECURITYDBOSCHEDULEEND_DATEDATEEagleML/referenceTransaction/schedule/endDate
accrualDateCust
Optional

date8504in_accrual_date_custSECURITYDBOSCHEDULEACCRUAL_DATE_CUSTDATEEagleML/referenceTransaction/schedule/accrualDateCust
determDate1
Optional

date

not stored in DB
EagleML/referenceTransaction/schedule/determDate1
determDate2
Optional

date

not stored in DB
EagleML/referenceTransaction/schedule/determDate2
nextAccrualDate

Optional


date8502in_next_accrual_dateSECURITYDBOSCHEDULENEXT_ACCRUAL_DATEDATEEagleML/referenceTransaction/schedule/nextAccrualDate
payDate
Optional

date8503in_pay_dateSECURITYDBOSCHEDULEPAY_DATEDATEEagleML/referenceTransaction/schedule/payDate
nextCallDate
Optional

date1241in_next_call_dateSECURITYDBOSCHEDULENEXT_CALL_DATEDATEEagleML/referenceTransaction/schedule/nextCallDate
nextCallPrice

Optional


decimal1242in_next_call_priceSECURITYDBOSCHEDULENEXT_CALL_PRICENUMBER(28,12)EagleML/referenceTransaction/schedule/nextCallPrice
nextPutDate

Optional


date1243in_next_put_dateSECURITYDBOSCHEDULENEXT_PUT_DATEDATEEagleML/referenceTransaction/schedule/nextPutDate
nextPutPrice

Optional


decimal1244in_next_put_priceSECURITYDBOSCHEDULENEXT_PUT_PRICENUMBER(28,12)EagleML/referenceTransaction/schedule/nextPutPrice
parCallDate

Optional


date1245in_par_call_dateSECURITYDBOSCHEDULEPAR_CALL_DATEDATEEagleML/referenceTransaction/schedule/parCallDate
parPutDate
Optional

date1246in_par_put_dateSECURITYDBOSCHEDULEPAR_PUT_DATEDATEEagleML/referenceTransaction/schedule/parPutDate
scheduleChar1
string3664in_schedule_char1SECURITYDBOSCHEDULESCHEDULE_CHAR1VARCHAR2(30)EagleML/referenceTransaction/schedule/scheduleChar1
scheduleChar2
string3665in_schedule_char2SECURITYDBOSCHEDULESCHEDULE_CHAR2VARCHAR2(30)EagleML/referenceTransaction/schedule/scheduleChar2
scheduleChar3
string3666in_schedule_char3SECURITYDBOSCHEDULESCHEDULE_CHAR3VARCHAR2(30)EagleML/referenceTransaction/schedule/scheduleChar3
scheduleChar4
string3667in_schedule_char4SECURITYDBOSCHEDULESCHEDULE_CHAR4VARCHAR2(30)EagleML/referenceTransaction/schedule/scheduleChar4
scheduleChar5
string3668in_schedule_char5SECURITYDBOSCHEDULESCHEDULE_CHAR5VARCHAR2(30)EagleML/referenceTransaction/schedule/scheduleChar5
scheduleDate1
date3669in_schedule_date1SECURITYDBOSCHEDULESCHEDULE_DATE1DATEEagleML/referenceTransaction/schedule/scheduleDate1
scheduleDate2
date3670in_schedule_date2SECURITYDBOSCHEDULESCHEDULE_DATE2DATEEagleML/referenceTransaction/schedule/scheduleDate2
scheduleDate3
date3671in_schedule_date3SECURITYDBOSCHEDULESCHEDULE_DATE3DATEEagleML/referenceTransaction/schedule/scheduleDate3
scheduleDate4
date3672in_schedule_date4SECURITYDBOSCHEDULESCHEDULE_DATE4DATEEagleML/referenceTransaction/schedule/scheduleDate4
scheduleDate5
date3673in_schedule_date5SECURITYDBOSCHEDULESCHEDULE_DATE5DATEEagleML/referenceTransaction/schedule/scheduleDate5
scheduleDate6
date8279in_schedule_date6SECURITYDBOSCHEDULESCHEDULE_DATE6DATEEagleML/referenceTransaction/schedule/scheduleDate6
scheduleDate7
date8280in_schedule_date7SECURITYDBOSCHEDULESCHEDULE_DATE7DATEEagleML/referenceTransaction/schedule/scheduleDate7
scheduleDate8
date8281in_schedule_date8SECURITYDBOSCHEDULESCHEDULE_DATE8DATEEagleML/referenceTransaction/schedule/scheduleDate8
scheduleDate9
date8282in_schedule_date9SECURITYDBOSCHEDULESCHEDULE_DATE9DATEEagleML/referenceTransaction/schedule/scheduleDate9
scheduleDate10
date8283in_schedule_date10SECURITYDBOSCHEDULESCHEDULE_DATE10DATEEagleML/referenceTransaction/schedule/scheduleDate10
scheduleFloat2
decimal5235in_schedule_float2SECURITYDBOSCHEDULESCHEDULE_FLOAT2NUMBER(28,12)EagleML/referenceTransaction/schedule/scheduleFloat2
scheduleFloat3
decimal5236in_schedule_float3SECURITYDBOSCHEDULESCHEDULE_FLOAT3NUMBER(28,12)EagleML/referenceTransaction/schedule/scheduleFloat3
scheduleFloat4
decimal8284in_schedule_float4SECURITYDBOSCHEDULESCHEDULE_FLOAT4NUMBER(28,12)EagleML/referenceTransaction/schedule/scheduleFloat4
scheduleFloat5
decimal8285in_schedule_float5SECURITYDBOSCHEDULESCHEDULE_FLOAT5NUMBER(28,12)EagleML/referenceTransaction/schedule/scheduleFloat5
preRefundedDate
date1247in_pre_refunded_dateSECURITYDBOSCHEDULEPRE_REFUNDED_DATEDATEEagleML/referenceTransaction/schedule/preRefundedDate
preRefundedPrice
decimal1248in_pre_refunded_priceSECURITYDBOSCHEDULEPRE_REFUNDED_PRICENUMBER(28,12)EagleML/referenceTransaction/schedule/preRefundedPrice
series
string1251in_seriesSECURITYDBOSCHEDULESERIESCHAR(12)EagleML/referenceTransaction/schedule/series
stepUpCoupon
decimal1252in_step_up_couponSECURITYDBOSCHEDULESTEP_UP_COUPONNUMBER(28,12)EagleML/referenceTransaction/schedule/stepUpCoupon
stepUpDate
date1253in_step_up_dateSECURITYDBOSCHEDULESTEP_UP_DATEDATEEagleML/referenceTransaction/schedule/stepUpDate
workoutDate
date1254in_workout_dateSECURITYDBOSCHEDULEWORKOUT_DATEDATEEagleML/referenceTransaction/schedule/workoutDate
workoutPrice
decimal1255in_workout_priceSECURITYDBOSCHEDULEWORKOUT_PRICENUMBER(28,12)EagleML/referenceTransaction/schedule/workoutPrice
discrete
string3663in_discreteSECURITYDBOSCHEDULEDISCRETECHAR(4)EagleML/referenceTransaction/schedule/discrete
exerciseDate
date3659in_exercise_dateSECURITYDBOSCHEDULEEXERCISE_DATEDATEEagleML/referenceTransaction/schedule/exerciseDate
exercisePrice
decimal3661in_exercise_priceSECURITYDBOSCHEDULEEXERCISE_PRICENUMBER(28,12)EagleML/referenceTransaction/schedule/exercisePrice
localCurrencySchedule
CurrencyCode3677in_local_curr_schSECURITYDBOSCHEDULELOCAL_CURR_SCHCHAR(3)EagleML/referenceTransaction/schedule/localCurrencySchedule
scheduleFrequency
string3662in_schedule_frequencySECURITYDBOSCHEDULESCHEDULE_FREQUENCYCHAR(12)EagleML/referenceTransaction/schedule/scheduleFrequency
scheduleLocalCurrency
CurrencyCode3674in_sch_local_currencySECURITYDBOSCHEDULESCH_LOCAL_CURRENCYVARCHAR2(3)EagleML/referenceTransaction/schedule/scheduleLocalCurrency
scheduleBaseCurrency
CurrencyCode3675in_sch_base_currencySECURITYDBOSCHEDULESCH_BASE_CURRENCYVARCHAR2(3)EagleML/referenceTransaction/schedule/scheduleBaseCurrency
shares
decimal3660in_sharesSECURITYDBOSCHEDULESHARESNUMBER(28,12)EagleML/referenceTransaction/schedule/shares
valuationDate
date16409in_valuation_dateSECURITYDBOSCHEDULEVALUATION_DATEDATEEagleML/referenceTransaction/schedule/valuationDate
bypassSinkCheckSwitch
YesNoOptionEnum17479in_bypass_sink_checkSECURITYDBOSCHEDULEBYPASS_SINK_CHECKVARCHAR2(1)EagleML/referenceTransaction/schedule/bypassSinkCheckSwitch
fixingDate
date16410in_fixing_dateSECURITYDBOSCHEDULEFIXING_DATEDATEEagleML/referenceTransaction/schedule/fixingDate
cashPaymentDate
date16411in_cash_payment_dateSECURITYDBOSCHEDULECASH_PAYMENT_DATEDATEEagleML/referenceTransaction/schedule/cashPaymentDate
resetDate
date16408in_reset_dateSECURITYDBOSCHEDULERESET_DATEDATEEagleML/referenceTransaction/schedule/resetDate