| Warning |
|---|
Please note, that Schedule Model is separated by the smf_mi stream and loaded as a Schedule EagleML object - so you should use SCHEDULEEXTRACT feedtype to extract it |
Element | Optional/ Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | XPath | |
|---|---|---|---|---|---|---|---|---|---|---|---|
scheduleId | Optional | integer | 3664 | in_schedule_char1 | S | SECURITYDBO | SCHEDULE | SCHEDULE_CHAR1 | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleId | |
scheduleType | Optional | ScheduleTypeEnum | 3678 | in_schedule_type | S | SECURITYDBO | SCHEDULE | SCHEDULE_TYPE | CHAR(4) | EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleType | |
scheduleSubType | Required | string | 1250 | in_schedule_sub_type | S | SECURITYDBO | SCHEDULE | SCHEDULE_SUB_TYPE | CHAR(8) | EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleSubType | |
scheduleStatus | Optional | ScheduleStatusEnum | 1670 | in_schedule_status | S | SECURITYDBO | SCHEDULE | SCHEDULE_STATUS | VARCHAR2(12) | EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleStatus | |
price | Optional | decimal | 1249 | in_schedule_price | F | SECURITYDBO | SCHEDULE | SCHEDULE_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/ScheduleModel/price | |
rate | Optional | decimal | 1249 | in_schedule_price | F | SECURITYDBO | SCHEDULE | SCHEDULE_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/ScheduleModel/rate | |
scheduleAmount | Optional | decimal | 1669 | in_schedule_amount | F | SECURITYDBO | SCHEDULE | SCHEDULE_AMOUNT | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleAmount | |
scheduleFloat1 | Optional | decimal | 5534 | in_schedule_float1 | I | SECURITYDBO | SCHEDULE | SCHEDULE_FLOAT1 | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/ScheduleModel/scheduleFloat1 | |
endDate | Optional | date | 73 | in_end_date | S | SECURITYDBO | SCHEDULE | END_DATE | DATE | EagleML/referenceTransaction/genericSMF/ScheduleModel/endDate | |
accrualDateCust | Optional | date | 7157 | in_accrual_date_cust | S | SECURITYDBO | SCHEDULE | ACCRUAL_DATE_CUST | DATE | EagleML/referenceTransaction/genericSMF/ScheduleModel/accrualDateCust | |
determDate1 | Optional | date | 7113 | not stored in DB | EagleML/referenceTransaction/genericSMF/ScheduleModel/determDate1 | ||||||
determDate2 | Optional | date | 7114 | not stored in DB | EagleML/referenceTransaction/genericSMF/ScheduleModel/determDate2 | ||||||
nextAccrualDate | Optional | date | 7163 | in_next_accrual_date | S | SECURITYDBO | SCHEDULE | NEXT_ACCRUAL_DATE | DATE | EagleML/referenceTransaction/genericSMF/ScheduleModel/nextAccrualDate | |
payDate | Optional | date | 7164 | in_pay_date | S | SECURITYDBO | SCHEDULE | PAY_DATE | DATE | EagleML/referenceTransaction/genericSMF/ScheduleModel/payDate | |
effectiveDate | Required | date | 1109 | in_effective_date | S | SECURITYDBO | SCHEDULE | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/genericSMF/ScheduleModel/effectiveDate | |
...