...
title | Note |
---|
...
Info | ||||||
---|---|---|---|---|---|---|
|
Element | Optional/RequiredComments | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | Xpath | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||
updateTimestampOptional | dateTime |
|
| not stored in DBDATE | EagleML/referenceTransaction/schedule/updateTimestamp | ||||||||||
customElements | Not recommended | CustomElements - Complex type |
|
| reserved for customizations |
| EagleML/referenceTransaction/schedule/customElements | ||||||||
sourceName | OptionalRequired | string - needed for resolution logics | 1102 | in_short_desc | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/referenceTransaction/schedule/sourceName | ||||||
updateSource | Optional | string | 944 | in_update_source | SECURITYDBO | SCHEDULE | UPDATE_SOURCE | VARCHAR2(255) | EagleML/referenceTransaction/schedule/updateSource | ||||||
effectiveDate | OptionalRequired | date | 1109 | in_effective_date | SECURITYDBO | SCHEDULE | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/schedule/effectiveDate | ||||||
languageId | Optional | integer |
| not stored in DB | EagleML/referenceTransaction/schedule/languageId | ||||||||||
tagNochangecase | Optional | string | 4637 |
| not stored in DB |
| EagleML/referenceTransaction/schedule/tagNochangecase | ||||||||
preserveNull | Optional | string | 5284 |
| not stored in DB | EagleML/referenceTransaction/schedule/preserveNull | |||||||||
noLoadValidationFlagOptional | YesNoOptionEnum |
|
| not stored in DB, used in load logics | EagleML/referenceTransaction/schedule/noLoadValidationFlag | ||||||||||
accountingValidationFlag | Optional | YesNoOptionEnum |
| YesNoOptionEnum | not stored in DB, used in load logics | EagleML/referenceTransaction/schedule/accountingValidationFlag | |||||||||
skipIfExistFlag | YesNoOptionEnum | not stored in DB, used in load logics | EagleML/referenceTransaction/schedule/accountingValidationFlagskipIfExistFlag | ||||||||||||
Asset Identifiers Model | EagleML/referenceTransaction/schedule/ | ||||||||||||||
setEligibleFlagOptional | YesNoOptionEnum |
| not stored in DB | EagleML/referenceTransaction/schedule/setEligibleFlag | |||||||||||
securityMasterSource | Optional | string |
|
| PACE_MASTERDBO | INTERFACES | SHORT_DESC | EagleML/referenceTransaction/schedule/securityMasterSource | |||||||
scheduleId | Optional | string | 36643251 | in_schedule_char1 | SECURITYDBO | SCHEDULE | SCHEDULE_CHAR1 | VARCHAR2(30) | EagleML/referenceTransaction/schedule/scheduleId | ||||||
scheduleTypeOptional | see the note above about reversed mapping | ScheduleTypeEnum | 1250 | in_schedule_sub_type | SECURITYDBO | SCHEDULE | SCHEDULE_SUB_TYPE | CHAR(48) | EagleML/referenceTransaction/schedule/scheduleType | ||||||
scheduleSubType | Required | string | 3678 | in_schedule_type | SECURITYDBO | SCHEDULE | SCHEDULE_SUB_TYPE | CHAR(84) | EagleML/referenceTransaction/schedule/scheduleSubType | ||||||
scheduleStatusOptional | ScheduleStatusEnum | 1670 | in_schedule_status | SECURITYDBO | SCHEDULE | SCHEDULE_STATUS | VARCHAR2(12) | EagleML/referenceTransaction/schedule/scheduleStatusPrice 1] | |||||||
price | Optional | decimal | 1249 | in_schedule_price | SECURITYDBO | SCHEDULE | SCHEDULE_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/schedule/price | Rate 1] | Optional|||||
rate | decimal | 1249 | in_schedule_price | SECURITYDBO | SCHEDULE | SCHEDULE_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/schedule/rate | |||||||
scheduleAmount | Optional | decimal | 1669 | in_schedule_amount | SECURITYDBO | SCHEDULE | SCHEDULE_AMOUNT | NUMBER(28,12) | EagleML/referenceTransaction/schedule/scheduleAmount | ||||||
scheduleFloat1 | Optional | decimal | 5534 | in_schedule_float1 | SECURITYDBO | SCHEDULE | SCHEDULE_FLOAT1 | NUMBER(28,12) | EagleML/referenceTransaction/schedule/scheduleFloat1 | ||||||
endDate | Optional | date | 73 | in_end_date | SECURITYDBO | SCHEDULE | END_DATE | DATE | EagleML/referenceTransaction/schedule/endDate | ||||||
accrualDateCustOptional | date | 8504 | in_accrual_date_cust | SECURITYDBO | SCHEDULE | ACCRUAL_DATE_CUST | DATE | EagleML/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 | date | 8502 | in_next_accrual_date | SECURITYDBO | SCHEDULE | NEXT_ACCRUAL_DATE | DATE | EagleML/referenceTransaction/schedule/nextAccrualDate | ||||||
payDate | Optional | date | 8503 | in_pay_date | SECURITYDBO | SCHEDULE | PAY_DATE | DATE | EagleML/referenceTransaction/schedule/payDate | ||||||
nextCallDateOptional | date | 1241 | in_next_call_date | SECURITYDBO | SCHEDULE | NEXT_CALL_DATE | DATE | EagleML/referenceTransaction/schedule/nextCallDate | |||||||
nextCallPriceOptional | decimal | 1242 | in_next_call_price | SECURITYDBO | SCHEDULE | NEXT_CALL_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/schedule/nextCallPrice | |||||||
nextPutDate | Optional | date | 1243 | in_next_put_date | SECURITYDBO | SCHEDULE | NEXT_PUT_DATE | DATE | EagleML/referenceTransaction/schedule/nextPutDate | ||||||
nextPutPriceOptional | decimal | 1244 | in_next_put_price | SECURITYDBO | SCHEDULE | NEXT_PUT_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/schedule/nextPutPrice | |||||||
parCallDate | Optional | date | 1245 | in_par_call_date | SECURITYDBO | SCHEDULE | PAR_CALL_DATE | DATE | EagleML/referenceTransaction/schedule/parCallDate | ||||||
parPutDateOptional | date | 1246 | in_par_put_date | SECURITYDBO | SCHEDULE | PAR_PUT_DATE | DATE | EagleML/referenceTransaction/schedule/parPutDate | |||||||
scheduleChar1 | string | 3664 | in_schedule_char1 | SECURITYDBO | SCHEDULE | SCHEDULE_CHAR1 | VARCHAR2(30) | EagleML/referenceTransaction/schedule/scheduleChar1 | |||||||
scheduleChar2 | string | 3665 | in_schedule_char2 | SECURITYDBO | SCHEDULE | SCHEDULE_CHAR2 | VARCHAR2(30) | EagleML/referenceTransaction/schedule/scheduleChar2 | |||||||
scheduleChar3 | string | 3666 | in_schedule_char3 | SECURITYDBO | SCHEDULE | SCHEDULE_CHAR3 | VARCHAR2(30) | EagleML/referenceTransaction/schedule/scheduleChar3 | |||||||
scheduleChar4 | string | 3667 | in_schedule_char4 | SECURITYDBO | SCHEDULE | SCHEDULE_CHAR4 | VARCHAR2(30) | EagleML/referenceTransaction/schedule/scheduleChar4 | |||||||
scheduleChar5 | string | 3668 | in_schedule_char5 | SECURITYDBO | SCHEDULE | SCHEDULE_CHAR5 | VARCHAR2(30) | EagleML/referenceTransaction/schedule/scheduleChar5 | |||||||
scheduleDate1 | date | 3669 | in_schedule_date1 | SECURITYDBO | SCHEDULE | SCHEDULE_DATE1 | DATE | EagleML/referenceTransaction/schedule/scheduleDate1 | |||||||
scheduleDate2 | date | 3670 | in_schedule_date2 | SECURITYDBO | SCHEDULE | SCHEDULE_DATE2 | DATE | EagleML/referenceTransaction/schedule/scheduleDate2 | |||||||
scheduleDate3 | date | 3671 | in_schedule_date3 | SECURITYDBO | SCHEDULE | SCHEDULE_DATE3 | DATE | EagleML/referenceTransaction/schedule/scheduleDate3 | |||||||
scheduleDate4 | date | 3672 | in_schedule_date4 | SECURITYDBO | SCHEDULE | SCHEDULE_DATE4 | DATE | EagleML/referenceTransaction/schedule/scheduleDate4 | |||||||
scheduleDate5 | date | 3673 | in_schedule_date5 | SECURITYDBO | SCHEDULE | SCHEDULE_DATE5 | DATE | EagleML/referenceTransaction/schedule/scheduleDate5 | |||||||
scheduleDate6 | date | 8279 | in_schedule_date6 | SECURITYDBO | SCHEDULE | SCHEDULE_DATE6 | DATE | EagleML/referenceTransaction/schedule/scheduleDate6 | |||||||
scheduleDate7 | date | 8280 | in_schedule_date7 | SECURITYDBO | SCHEDULE | SCHEDULE_DATE7 | DATE | EagleML/referenceTransaction/schedule/scheduleDate7 | |||||||
scheduleDate8 | date | 8281 | in_schedule_date8 | SECURITYDBO | SCHEDULE | SCHEDULE_DATE8 | DATE | EagleML/referenceTransaction/schedule/scheduleDate8 | |||||||
scheduleDate9 | date | 8282 | in_schedule_date9 | SECURITYDBO | SCHEDULE | SCHEDULE_DATE9 | DATE | EagleML/referenceTransaction/schedule/scheduleDate9 | |||||||
scheduleDate10 | date | 8283 | in_schedule_date10 | SECURITYDBO | SCHEDULE | SCHEDULE_DATE10 | DATE | EagleML/referenceTransaction/schedule/scheduleDate10 | |||||||
scheduleFloat2 | decimal | 5235 | in_schedule_float2 | SECURITYDBO | SCHEDULE | SCHEDULE_FLOAT2 | NUMBER(28,12) | EagleML/referenceTransaction/schedule/scheduleFloat2 | |||||||
scheduleFloat3 | decimal | 5236 | in_schedule_float3 | SECURITYDBO | SCHEDULE | SCHEDULE_FLOAT3 | NUMBER(28,12) | EagleML/referenceTransaction/schedule/scheduleFloat3 | |||||||
scheduleFloat4 | decimal | 8284 | in_schedule_float4 | SECURITYDBO | SCHEDULE | SCHEDULE_FLOAT4 | NUMBER(28,12) | EagleML/referenceTransaction/schedule/scheduleFloat4 | |||||||
scheduleFloat5 | decimal | 8285 | in_schedule_float5 | SECURITYDBO | SCHEDULE | SCHEDULE_FLOAT5 | NUMBER(28,12) | EagleML/referenceTransaction/schedule/scheduleFloat5 | |||||||
preRefundedDate | date | 1247 | in_pre_refunded_date | SECURITYDBO | SCHEDULE | PRE_REFUNDED_DATE | DATE | EagleML/referenceTransaction/schedule/preRefundedDate | |||||||
preRefundedPrice | decimal | 1248 | in_pre_refunded_price | SECURITYDBO | SCHEDULE | PRE_REFUNDED_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/schedule/preRefundedPrice | |||||||
series | string | 1251 | in_series | SECURITYDBO | SCHEDULE | SERIES | CHAR(12) | EagleML/referenceTransaction/schedule/series | |||||||
stepUpCoupon | decimal | 1252 | in_step_up_coupon | SECURITYDBO | SCHEDULE | STEP_UP_COUPON | NUMBER(28,12) | EagleML/referenceTransaction/schedule/stepUpCoupon | |||||||
stepUpDate | date | 1253 | in_step_up_date | SECURITYDBO | SCHEDULE | STEP_UP_DATE | DATE | EagleML/referenceTransaction/schedule/stepUpDate | |||||||
workoutDate | date | 1254 | in_workout_date | SECURITYDBO | SCHEDULE | WORKOUT_DATE | DATE | EagleML/referenceTransaction/schedule/workoutDate | |||||||
workoutPrice | decimal | 1255 | in_workout_price | SECURITYDBO | SCHEDULE | WORKOUT_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/schedule/workoutPrice | |||||||
discrete | string | 3663 | in_discrete | SECURITYDBO | SCHEDULE | DISCRETE | CHAR(4) | EagleML/referenceTransaction/schedule/discrete | |||||||
exerciseDate | date | 3659 | in_exercise_date | SECURITYDBO | SCHEDULE | EXERCISE_DATE | DATE | EagleML/referenceTransaction/schedule/exerciseDate | |||||||
exercisePrice | decimal | 3661 | in_exercise_price | SECURITYDBO | SCHEDULE | EXERCISE_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/schedule/exercisePrice | |||||||
localCurrencySchedule | CurrencyCode | 3677 | in_local_curr_sch | SECURITYDBO | SCHEDULE | LOCAL_CURR_SCH | CHAR(3) | EagleML/referenceTransaction/schedule/localCurrencySchedule | |||||||
scheduleFrequency | string | 3662 | in_schedule_frequency | SECURITYDBO | SCHEDULE | SCHEDULE_FREQUENCY | CHAR(12) | EagleML/referenceTransaction/schedule/scheduleFrequency | |||||||
scheduleLocalCurrency | CurrencyCode | 3674 | in_sch_local_currency | SECURITYDBO | SCHEDULE | SCH_LOCAL_CURRENCY | VARCHAR2(3) | EagleML/referenceTransaction/schedule/scheduleLocalCurrency | |||||||
scheduleBaseCurrency | CurrencyCode | 3675 | in_sch_base_currency | SECURITYDBO | SCHEDULE | SCH_BASE_CURRENCY | VARCHAR2(3) | EagleML/referenceTransaction/schedule/scheduleBaseCurrency | |||||||
shares | decimal | 3660 | in_shares | SECURITYDBO | SCHEDULE | SHARES | NUMBER(28,12) | EagleML/referenceTransaction/schedule/shares | |||||||
bypassSinkCheckSwitch | YesNoOptionEnum | 17479 | in_bypass_sink_check | SECURITYDBO | SCHEDULE | BYPASS_SINK_CHECK | VARCHAR2(1) | EagleML/referenceTransaction/schedule/bypassSinkCheckSwitch | |||||||
resetDate | date | 16408 | in_reset_date | SECURITYDBO | SCHEDULE | RESET_DATE | DATE | EagleML/referenceTransaction/schedule/resetDate | |||||||
valuationDate | date | 16409 | in_valuation_date | SECURITYDBO | SCHEDULE | VALUATION_DATE | DATE | EagleML/referenceTransaction/schedule/valuationDate | |||||||
fixingDate | date | 16410 | in_fixing_date | SECURITYDBO | SCHEDULE | FIXING_DATE | DATE | EagleML/referenceTransaction/schedule/fixingDate | |||||||
cashPaymentDate | date | 16411 | in_cash_payment_date | SECURITYDBO | SCHEDULE | CASH_PAYMENT_DATE | DATE | EagleML/referenceTransaction/schedule/cashPaymentDate | |||||||
putNotificationMaxDays | integer | 1657 | in_put_notification_max_days | SECURITYDBO | SCHEDULE | PUT_NOTIFICATION_MAX_DAYS | NUMBER | EagleML/referenceTransaction/schedule/putNotificationMaxDays | |||||||
putNotificationMinDays | integer | 1658 | in_put_notification_min_days | SECURITYDBO | SCHEDULE | PUT_NOTIFICATION_MIN_DAYS | NUMBER | EagleML/referenceTransaction/schedule/putNotificationMinDays | |||||||
baseCurrSch | string | 3676 | in_base_curr_sch | SECURITYDBO | SCHEDULE | BASE_CURR_SCH | CHAR(3) | EagleML/referenceTransaction/schedule/baseCurrSch | |||||||
journalizingFlag | JournalizingFlagEnum | 1293 | in_journal_flag | not stored in DB | EagleML/referenceTransaction/schedule/journalizingFlag |