Synthetic Cash SMF Data Map Table

Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

Star Tag

SP Parameter

SP TYPE

Include filename

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

 

Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

Star Tag

SP Parameter

SP TYPE

Include filename

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

 

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

 

languageId

 

 

integer

-

 

 

 

not stored in DB

 

EagleML/referenceTransaction/genericSMF/languageId

 

tagNochangecase

 

 

string

4637

 

 

referenceobject.inc

 

 

 

 

EagleML/referenceTransaction/genericSMF/tagNochangecase

 

preserveNull

 

 

string

5284

 

 

referenceobject.inc

 

 

 

 

EagleML/referenceTransaction/genericSMF/preserveNull

 

noLoadValidationFlag

 

 

YesNoOptionEnum

 

 

 

 

not stored in DB, used to manage the download logic

 

EagleML/referenceTransaction/genericSMF/noLoadValidationFlag

 

accountingValidationFlag

Required

 

YesNoOptionEnum

 

 

 

 

not stored in DB, used to manage the download logic

 

EagleML/referenceTransaction/genericSMF/accountingValidationFlag

 

Asset Identifiers Model

EagleML/referenceTransaction/genericSMF/

 

processingSecurityType

Required

Required

StringWithCodeScheme

3931

in_process_sec_type

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER

PROCESS_SEC_TYPE

VARCHAR2(15)

EagleML/referenceTransaction/genericSMF/processingSecurityType

 

securityType

 

 

string

82

in_security_type

S

generic_smf_base_model.inc

SECURITYDBO

SECURITY_MASTER

SECURITY_TYPE

CHAR(15)

EagleML/referenceTransaction/genericSMF/securityType

 

securitySubType

 

 

string

1464

in_alt_security_type

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER_DETAIL

ALT_SECURITY_TYPE

CHAR(15)

EagleML/referenceTransaction/genericSMF/securitySubType

 

settlementCurrency

Required

 

CurrencyCode

63

in_settlement_currency

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER

SETTLEMENT_CURRENCY

CHAR(3)

EagleML/referenceTransaction/genericSMF/settlementCurrency

 

incomeCurrency

Required

 

CurrencyCode

1186

in_sm_income_currency

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER

INCOME_CURRENCY

CHAR(3)

EagleML/referenceTransaction/genericSMF/incomeCurrency

 

quantityType

Required - Defaulted to "CASH" by panel

 

StringWithCodeScheme

12

in_quantity_type

S

generic_smf_base_model.inc

SECURITYDBO

SECURITY_MASTER

QUANTITY_TYPE

CHAR(12)

EagleML/referenceTransaction/genericSMF/quantityType

 

priceMultiplier

Required - Defaulted to "1" by panel

 

decimal

18

in_price_multiplier

F

smfobject.inc

SECURITYDBO

SECURITY_MASTER

PRICE_MULTIPLIER

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/priceMultiplier

 

quantityScale

Required - Defaulted to "1" by panel

 

decimal

19

in_sm_trading_unit

F

smfobject.inc

SECURITYDBO

SECURITY_MASTER

TRADING_UNIT

NUMBER(28,12)

EagleML/referenceTransaction/genericSMF/quantityScale

 

issueCountryCode

Required

 

CountryCode

1418

in_nra_tax_country

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER

NRA_TAX_COUNTRY

CHAR(30)

EagleML/referenceTransaction/genericSMF/issueCountryCode

 

issueTaxType

 

 

string

668

in_issue_tax_type

S

smfobject.inc

SECURITYDBO

SECURITY_MASTER_DETAIL

ISSUE_TAX_TYPE

VARCHAR2(30)

EagleML/referenceTransaction/genericSMF/issueTaxType

 

putCallFlag

 

 

string

1350

in_put_call_flag

S

generic_smf_base_model.inc

SECURITYDBO

DERIVATIVES

PUT_CALL_FLAG

CHAR(4)

EagleML/referenceTransaction/genericSMF/putCallFlag

 

Â