Versions Compared

Key

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

Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

Star Tag

SP Parameter

SP Type

Eagle DB

DB Table

DB Field

DB Type

Xpath

objectType

ObjectTypeEnum

not stored in DB

EagleML/referenceTransaction/earningsTimePeriod/objectType

objectId

ObjectId

not stored in DB

EagleML/referenceTransaction/earningsTimePeriod/objectId

objectDescription

FeedTypeEnum

EagleML/referenceTransaction/earningsTimePeriod/objectDescription

updateTimestamp

dateTime

SECURITYDBO

SMF_EARNINGS_TIME_PERIOD

UPDATE_DATE

DATE

EagleML/referenceTransaction/earningsTimePeriod/updateTimestamp

customElements

Not recommended

CustomElements - Complex Type

EagleML/referenceTransaction/earningsTimePeriod/customElements/

sourceName

string

not stored in DB

EagleML/referenceTransaction/earningsTimePeriod/sourceName

updateSource

string

EagleML/referenceTransaction/earningsTimePeriod/updateSource

effectiveDate

date

not stored in DB

EagleML/referenceTransaction/earningsTimePeriod/effectiveDate

languageId

integer

not stored in DB

EagleML/referenceTransaction/earningsTimePeriod/languageId

tagNochangecase

string

not stored in DB

EagleML/referenceTransaction/earningsTimePeriod/tagNochangecase

preserveNull

string

not stored in DB

EagleML/referenceTransaction/earningsTimePeriod/preserveNull

noLoadValidationFlag

YesNoOptionEnum

not stored in DB

EagleML/referenceTransaction/earningsTimePeriod/noLoadValidationFlag

accountingValidationFlag

YesNoOptionEnum

not stored in DB

EagleML/referenceTransaction/earningsTimePeriod/accountingValidationFlag

skipIfExistFlag

YesNoOptionEnum

not stored in DB

EagleML/referenceTransaction/earningsTimePeriod/skipIfExistFlag

Asset Identifiers Model (see extra table)

EagleML/referenceTransaction/earningsTimePeriod/

beginDate

Required

date

220

in_begin_date

SECURITYDBO

SMF_EARNINGS_TIME_PERIOD

BEGIN_DATE

DATE

EagleML/referenceTransaction/earningsTimePeriod/beginDate

endDate

date

221

in_end_date

SECURITYDBO

SMF_EARNINGS_TIME_PERIOD

END_DATE

DATE

EagleML/referenceTransaction/earningsTimePeriod/endDate

couponTypeCode

CouponTypeCodeEnum

97

in_coupon_type_code

SECURITYDBO

SMF_EARNINGS_TIME_PERIOD

COUPON_TYPE_CODE

CHAR(8)

EagleML/referenceTransaction/earningsTimePeriod/couponTypeCode

dayCountBasis

DayCountFraction

471

in_day_cnt

SECURITYDBO

SMF_EARNINGS_TIME_PERIOD

DAY_CNT

CHAR(20)

EagleML/referenceTransaction/earningsTimePeriod/dayCountBasis

indexOffset

decimal

215

in_offset

SECURITYDBO

SMF_EARNINGS_TIME_PERIOD

OFFSET

NUMBER(38,12)

EagleML/referenceTransaction/earningsTimePeriod/indexOffset

coupon

decimal

70

in_coupon

SECURITYDBO

SMF_EARNINGS_TIME_PERIOD

COUPON

NUMBER(38,12)

EagleML/referenceTransaction/earningsTimePeriod/coupon

underlyingSecAlias

integer

1347

in_underlying_sec_alias

SECURITYDBO

SMF_EARNINGS_TIME_PERIOD

UNDERLYING_SEC_ALIAS

NUMBER

EagleML/referenceTransaction/earningsTimePeriod/underlyingSecAlias

paymentFrequencyCode

StringWithCodeScheme

472

in_coupon_freq_code

SECURITYDBO

SMF_EARNINGS_TIME_PERIOD

COUPON_FREQ_CODE

CHAR(8)

EagleML/referenceTransaction/earningsTimePeriod/paymentFrequencyCode