Business Date Rule Data Map Table
- Dmitry Donosiyan (Unlicensed)
- Kinga Huszno
Element | Required Inbound Acct Validation | Value Type | Eagle DB | DB Table | DB Field | Data_Type | Xpath |
|---|---|---|---|---|---|---|---|
objectType | Required | Â | not stored in DB | Â | EagleML/referenceTransaction/businessDateRule/objectType | ||
objectId | Â | Â | not stored in DB | Â | EagleML/referenceTransaction/businessDateRule/objectId | ||
objectDescription | Â | Â | not stored in DBÂ | Â | EagleML/referenceTransaction/businessDateRule/objectDescription | ||
updateTimestamp | Â | Â | RULESDBO | DATERANGES | UPDATE_DATE | DATE | EagleML/referenceTransaction/businessDateRule/updateTimestamp |
updateSource | Required | string | RULESDBO | DATERANGES | UPDATE_USER | CHAR(100) | EagleML/referenceTransaction/businessDateRule/updateSource |
dateRuleId | Required | integer | RULESDBO | DATERANGES | ID | NUMBER | EagleML/referenceTransaction/businessDateRule/dateRuleId |
dateRuleName | Required | string | RULESDBO | DATERANGES | NAME | CHAR(50) | EagleML/referenceTransaction/businessDateRule/dateRuleName |
businessCalendarName | Â | string | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/referenceTransaction/businessDateRule/businessCalendarName |
businessStartDate | BusinessDayAdjustmentsModel - Complex type (see extra table) | EagleML/referenceTransaction/businessDateRule/businessStartDate/ | |||||
businessEndDate | BusinessDayAdjustmentsModel - Complex type (see extra table) | EagleML/referenceTransaction/businessDateRule/businessEndDate/ | |||||
comments | Â | string | RULESDBO | DATERANGES | COMMENTS | VARCHAR2(255) | EagleML/referenceTransaction/businessDateRule/comments |
inceptFiscalField | Â | integer | RULESDBO | DATERANGES | INCEPT_FISCAL_FIELD | NUMBER | EagleML/referenceTransaction/businessDateRule/inceptFiscalField |
monthEndFlag | Â | YesNoOptionEnum | RULESDBO | DATERANGES | ONLY_MONTHENDS_FLAG | NUMBER | EagleML/referenceTransaction/businessDateRule/monthEndFlag |
scope | Â | integer | RULESDBO | DATERANGES | SCOPE | NUMBER | EagleML/referenceTransaction/businessDateRule/scope |
singlePeriod | Â | SinglePeriodEnum | RULESDBO | DATERANGES | SINGLE_PERIOD | CHAR(2) | EagleML/referenceTransaction/businessDateRule/singlePeriod |
timeZoneCode | Â | ISOTimeZoneOffset | RULESDBO | DATERANGES | TIME_ZONE_ID | NUMBER | EagleML/referenceTransaction/businessDateRule/timeZoneCode |
timeZoneName | Â | string | PACE_MASTERDBO | TIME_ZONES | STANDARD_NAME | VARCHAR2(255) | EagleML/referenceTransaction/businessDateRule/timeZoneName |
BusinessDayAdjustments Model | |||||||
unadjustedDate | Required if dateTypeCode = 'FIXED' | date | RULESDBO | DATERANGES | START_DATE | DATE | ../unadjustedDate |
END_DATE | DATE | ||||||
dateTypeCode | Â | DateTypeCodeEnum | RULESDBO | DATERANGES | START_CODE | CHAR(10) | ../dateTypeCode |
END_CODE | CHAR(10) | ||||||
dayAdjustments | ../dayAdjustments/ | ||||||
DayAdjustments Model | |||||||
offsetCode | Â | OffsetCodeEnum | RULESDBO | DATERANGES | START_OFF_CODE | NUMBER | ../offsetCode |
END_OFF_CODE | NUMBER | ||||||
offsetQuantity | Â | integer | RULESDBO | DATERANGES | START_OFF_QUAN | NUMBER | ../offsetQuantity |
END_E_OFF_QUAN | NUMBER | ||||||
offsetCalendarFlag | Â | YesNoOptionEnum | RULESDBO | DATERANGES | BUSINESS_CAL_FLAG | NUMBER | ../offsetCalendarFlag |
adjustmentCode | Â | AdjustmentCodeEnum | RULESDBO | DATERANGES | START_ADJ_CODE | CHAR(5) | ../adjustmentCode |
END_ADJ_CODE | CHAR(5) | ||||||
adjustmentCalendarFlag | Â | YesNoOptionEnum | RULESDBO | DATERANGES | BUSINESS_CAL_FLAG | NUMBER | ../adjustmentCalendarFlag |
additionalOffsetCode | Â | OffsetCodeEnum | RULESDBO | DATERANGES | START_E_OFF_CODE | CHAR(5) | ../additionalOffsetCode |
END_E_OFF_CODE | CHAR(5) | ||||||
additionalOffsetQuantity | Â | integer | RULESDBO | DATERANGES | START_E_OFF_QUAN | NUMBER | ../additionalOffsetQuantity |
END_E_OFF_QUAN | NUMBER | ||||||
additionalCalendarFlag | Â | YesNoOptionEnum | RULESDBO | DATERANGES | BUSINESS_CAL_FLAG | NUMBER | ../additionalCalendarFlag |
Â