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

Include File Name

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

objectType

Required

ObjectTypeEnum

-

not stored in DB

EagleML/referenceTransaction/genericSMF/objectType

objectId

ObjectId

-

not stored in DB

EagleML/referenceTransaction/genericSMF/objectId

objectDescription

FeedTypeEnum

-

not stored in DB

EagleML/referenceTransaction/genericSMF/objectDescription

updateTimestamp

dateTime

-

not stored in DB

EagleML/referenceTransaction/genericSMF/updateTimestamp

sourceName

Required

Required

string

1102

in_short_desc

S

referenceobject.inc

PACE_MASTERDBO

INTERFACES

SHORT_DESC

CHAR(15)

EagleML/referenceTransaction/genericSMF/sourceName

updateSource

Required

Required

string

944

in_update_source

S

referenceobject.inc

SECURITYDBO

SECURITY_MASTER

UPDATE_SOURCE

CHAR(255)

EagleML/referenceTransaction/genericSMF/updateSource

effectiveDate

Required

Required

date

1109

in_effective_date

S

referenceobject.inc

SECURITYDBO

All history (_HIST) tables

EFFECTIVE_DATE

DATE

EagleML/referenceTransaction/genericSMF/effectiveDate

accountingValidationFlag

Required

YesNoOptionEnum

not stored in DB, used to manage the download logic

EagleML/referenceTransaction/genericSMF/accountingValidationFlag

Asset Identifiers Model

EagleML/referenceTransaction/genericSMF/

investmentType

Required

Required

StringWithCodeScheme

11

in_investment_type

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER

INVESTMENT_TYPE

CHAR(4)

EagleML/referenceTransaction/genericSMF/investmentType

processingSecurityType

Required

Required

StringWithCodeScheme

3931

in_process_sec_type

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER

PROCESS_SEC_TYPE

VARCHAR2(15)

EagleML/referenceTransaction/genericSMF/processingSecurityType

settlementCurrency

Required - Defaulted to "Asset Currency" by panel

CurrencyCode

63

in_settlement_currency

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER

SETTLEMENT_CURRENCY

CHAR(3)

EagleML/referenceTransaction/genericSMF/settlementCurrency

incomeCurrency

Required - Defaulted to "Asset Currency" by panel

CurrencyCode

1186

in_sm_income_currency

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER

INCOME_CURRENCY

CHAR(3)

EagleML/referenceTransaction/genericSMF/incomeCurrency

issueCountryCode

Required

CountryCode

1418

in_nra_tax_country

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER

NRA_TAX_COUNTRY

CHAR(30)

EagleML/referenceTransaction/genericSMF/issueCountryCode

strikeRate

Required

decimal

11850

in_strike_rate

N

generic_smf_base_model.inc

SECURITYDBO

DERIVATIVES

STRIKE_RATE

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/strikeRate

maturityDate

Required

date

38

in_mat_date

S

fixedincomesmf_model.inc

SECURITYDBO

SECURITY_MASTER

MAT_DATE

DATE

EagleML/referenceTransaction/genericSMF/maturityDate

FixedIncomeModel

FixedIncomeModel

Fixed Income Model

EagleML/referenceTransaction/genericSMF/FixedIncomeModel