Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

 

tradingFlat element is required, when accountingValidationFlag ='Y' and processingSecurityType = 'DBFLTP' OR 'DBIBFD' OR 'DBIBMU' OR 'DBIBPK' OR 'DBIVIV' OR 'DBMFDD' OR 'DBAMTL' OR 'DBIBTL' and FixedIncomeModel/fiDetChar25 = 'NONE'


Element

Required Inbound Acct Validation

Required Inbound Data Mgt

Value Type

Star Tag

SP Parameter

SP Type

Eagle DB

DB Table

DB Field

DB Field Type

Xpath

objectType

Required


ObjectTypeEnum

-



not stored in DB


EagleML/referenceTransaction/multilegSMF/objectType

objectId



ObjectId

-



not stored in DB 


EagleML/referenceTransaction/multilegSMF/objectId

objectDescription



FeedTypeEnum

-



not stored in DB


EagleML/referenceTransaction/multilegSMF/objectDescription

updateTimestamp



dateTime

-



not stored in DB


EagleML/referenceTransaction/multilegSMF/updateTimestamp

customElements

Not recommended


CustomElements

CustomElements – reserved for customizations

EagleML/referenceTransaction/multilegSMF/customElements

sourceName

Required


string

1102

in_short_desc

S

PACE_MASTERDBO

INTERFACES

SHORT_DESC

CHAR(15)

EagleML/referenceTransaction/multilegSMF/sourceName

updateSource

Required


string

944

in_update_source

S

SECURITYDBO

SECURITY_MASTER

UPDATE_SOURCE

CHAR(255)

EagleML/referenceTransaction/multilegSMF/updateSource

effectiveDate

Required


date








EagleML/referenceTransaction/multilegSMF/effectiveDate

languageId



integer

-



not stored in DB


EagleML/referenceTransaction/multilegSMF/languageId

tagNochangecase



string

4637







EagleML/referenceTransaction/multilegSMF/tagNochangecase

preserveNull



string

5284







EagleML/referenceTransaction/multilegSMF/preserveNull

noLoadValidationFlag



YesNoOptionEnum




not stored in DB, used to manage the download logic


EagleML/referenceTransaction/multilegSMF/noLoadValidationFlag

accountingValidationFlag

Required


YesNoOptionEnum




not stored in DB, used to manage the download logic


EagleML/referenceTransaction/multilegSMF/accountingValidationFlag

contractLeg



SmfLegModel

Repeated Group (see extra table below) 

EagleML/referenceTransaction/multilegSMF/contractLeg/

payLeg



SmfLegModel

Repeated Group (see extra table below) 

EagleML/referenceTransaction/multilegSMF/payLeg/

receiveLeg



SmfLegModel

Repeated Group (see extra table below) 

EagleML/referenceTransaction/multilegSMF/receiveLeg/

NoteModel

NoteModelNote ModelEagleML/referenceTransaction/multilegSMF/NoteModel/
issuer

issuerModelIssuer ModelEagleML/referenceTransaction/multilegSMF/issuer/

Repeated Group (contractLeg, payLeg, receiveLeg) 

investmentType

Required


StringWithCodeScheme

11

in_investment_type

S

SECURITYDBO

SECURITY_MASTER

INVESTMENT_TYPE

CHAR(4)

.../investmentType

processingSecurityType

Required


StringWithCodeScheme

3931

in_process_sec_type

S

SECURITYDBO

SECURITY_MASTER

PROCESS_SEC_TYPE

VARCHAR2(15)

.../processingSecurityType

securityType



string

82

in_security_type

S

SECURITYDBO

SECURITY_MASTER

SECURITY_TYPE

CHAR(15)

.../securityType

securitySubType



string

1464

in_alt_security_type

S

SECURITYDBO

SECURITY_MASTER_DETAIL

ALT_SECURITY_TYPE

CHAR(15)

.../securitySubType

settlementCurrency

Required - Defaulted to "Asset Currency" by panel


CurrencyCode

63

in_settlement_currency

S

SECURITYDBO

SECURITY_MASTER

SETTLEMENT_CURRENCY

CHAR(3)

.../settlementCurrency

incomeCurrency

Required - Defaulted to "Asset Currency" by panel


CurrencyCode

1186

in_sm_income_currency

S

SECURITYDBO

SECURITY_MASTER

INCOME_CURRENCY

CHAR(3)

.../incomeCurrency

quantityType

Required - Defaulted to "PAR" by Panel


StringWithCodeScheme

12

in_quantity_type

S

SECURITYDBO

SECURITY_MASTER

QUANTITY_TYPE

CHAR(12)

.../quantityType

priceMultiplier

Required - Defaulted to "0.01" by Panel


decimal

18

in_price_multiplier

F

SECURITYDBO

SECURITY_MASTER

PRICE_MULTIPLIER

NUMBER(28,12)

.../priceMultiplier

quantityScale

Required - Defaulted to "1" by Panel


decimal

19

in_sm_trading_unit

F

SECURITYDBO

SECURITY_MASTER

TRADING_UNIT

NUMBER(28,12)

.../quantityScale

issueCountry



string

2290


S

not stored in DB [used for issueCountryCode calculation]


.../issueCountry

issueCountryCode

Required


CountryCode

1418

in_nra_tax_country

S

SECURITYDBO

SECURITY_MASTER

NRA_TAX_COUNTRY

CHAR(30)

.../issueCountryCode

countryOfRisk



string

2288



not stored in DB [used for countryOfRiskCode calculation] 


.../countryOfRisk

countryOfRiskCode



CountryCode

10536

in_country_of_risk

S

SECURITYDBO

SECURITY_MASTER_DETAIL

COUNTRY_OF_RISK

VARCHAR2(20)

.../countryOfRiskCode

issueTaxType



string

668

in_issue_tax_type

S

SECURITYDBO

SECURITY_MASTER_DETAIL

ISSUE_TAX_TYPE

VARCHAR2(30)

.../issueTaxType

region



string

5423

in_region

S

SECURITYDBO

SECURITY_MASTER_DETAIL

REGION

VARCHAR2(50)

.../region

lookThroughIndicator



StringWithCodeScheme

1776

in_look_thru_ind

S

SECURITYDBO

SECURITY_MASTER_DETAIL

LOOK_THRU_IND

CHAR(3)

.../lookThroughIndicator

lookThroughValue



string

1808

in_look_thru_value

S

SECURITYDBO

SECURITY_MASTER_DETAIL

LOOK_THRU_VALUE

VARCHAR2(15)

.../lookThroughValue

payLegCompoundingIndicator



string

11875

in_compounding_indicator

S

SECURITYDBO

FIXED_INCOME

COMPOUNDING_INDICATOR

VARCHAR2(1)

.../payLegCompoundingIndicator

tradingFlat

Required - Defaulted to "No" by panel See the note


YesNoOptionEnum

3949

in_trading_flat

S

SECURITYDBO

SECURITY_MASTER_DETAIL

TRADING_FLAT

VARCHAR2(10)

.../tradingFlat

offset



decimal

215

in_offset

N

SECURITYDBO

DERIVATIVES

OFFSET

NUMBER

.../offset

rCouponType



string

1366

in_r_coupon_type

S

SECURITYDBO

DERIVATIVES

R_COUPON_TYPE

VARCHAR2(30)

.../rCouponType

swapMaturity



date

1369

in_swap_maturity

S

SECURITYDBO

DERIVATIVES

SWAP_MATURITY

DATE

.../swapMaturity

underlyingCusip



string

1348

in_underlying_cusip

S

SECURITYDBO

DERIVATIVES

UNDERLYING_CUSIP

CHAR(100)

.../underlyingCusip

underlyingSecurity

Required


string

1141

in_underlying_security

S

SECURITYDBO

DERIVATIVES

UNDERLYING_SECURITY

VARCHAR2(255)

.../underlyingSecurity

underlyingSecAlias



integer

1347

in_underlying_sec_alias

N

SECURITYDBO

DERIVATIVES

UNDERLYING_SEC_ALIAS

NUMBER

.../underlyingSecAlias

derivChar1



string

3317

in_derv_char1


SECURITYDBO

DERIVATIVES

DERV_CHAR1

VARCHAR2(30)

.../derivChar1

derivChar2



string

3318

in_derv_char2


SECURITYDBO

DERIVATIVES

DERV_CHAR2

VARCHAR2(30)

.../derivChar2

derivChar3



string

3622

in_derv_char3


SECURITYDBO

DERIVATIVES

DERV_CHAR3

VARCHAR2(30)

.../derivChar3

derivChar4



string

3319

in_derv_char4


SECURITYDBO

DERIVATIVES

DERV_CHAR4

VARCHAR2(30)

.../derivChar4

derivChar5



string

3320

in_derv_char5


SECURITYDBO

DERIVATIVES

DERV_CHAR5

VARCHAR2(30)

.../derivChar5

derivChar6



string

3605

in_derv_char6


SECURITYDBO

DERIVATIVES

DERV_CHAR6

VARCHAR2(30)

.../derivChar6

derivChar7



string

3606

in_derv_char7


SECURITYDBO

DERIVATIVES

DERV_CHAR7

VARCHAR2(30)

.../derivChar7

derivChar8



string

3607

in_derv_char8


SECURITYDBO

DERIVATIVES

DERV_CHAR8

VARCHAR2(30)

.../derivChar8

derivChar9



string

3608

in_derv_char9


SECURITYDBO

DERIVATIVES

DERV_CHAR9

VARCHAR2(30)

.../derivChar9

derivChar10



string

3609

in_derv_char10


SECURITYDBO

DERIVATIVES

DERV_CHAR10

VARCHAR2(30)

.../derivChar10

derivDate1



date

3321

in_derv_date1


SECURITYDBO

DERIVATIVES

DERV_DATE1

DATE

.../derivDate1

pRollConvention



string

3309

in_p_roll_convention


SECURITYDBO

DERIVATIVES

P_ROLL_CONVENTION

CHAR(2)

.../pRollConvention

rRollConvention



string

3310

in_r_roll_convention


SECURITYDBO

DERIVATIVES

R_ROLL_CONVENTION

CHAR(2)

.../rRollConvention

rCalcMethod



string

3314

in_r_calc_method

S

SECURITYDBO

DERIVATIVES

R_CALC_METHOD

CHAR(2)

.../rCalcMethod

clearedSecurity



string

5027

in_cleared_security

S

SECURITYDBO

DERIVATIVES

CLEARED_SECURITY

VARCHAR2(1)

.../clearedSecurity

finalExchangeOfPrincipal



string

8555

in_final_exchg_prin

S

SECURITYDBO

SWAPS

FINAL_EXCHG_PRIN

VARCHAR2(1)

.../finalExchangeOfPrincipal

initialExchangeOfPrincipal

Required


string

8554

in_init_exchg_prin

S

SECURITYDBO

SWAPS

INIT_EXCHG_PRIN

VARCHAR2(1)

.../initialExchangeOfPrincipal

legMultiplier



decimal

4586

in_leg_multiplier

N

SECURITYDBO

SWAPS

LEG_MULTIPLIER

NUMBER(32,12)

.../legMultiplier

notionalResetType



string

4409

in_notional_reset_type

S

SECURITYDBO

SWAPS

NOTIONAL_RESET_TYPE

VARCHAR2(10)

.../notionalResetType

rollConvention



string

4584

in_roll_convention


SECURITYDBO

SWAPS

ROLL_CONVENTION

VARCHAR2(10)

.../rollConvention

maturityDate

Required


date

38

in_mat_date

S

SECURITYDBO

SECURITY_MASTER

MAT_DATE

DATE

.../maturityDate

riskClassificationType



string

11584

in_risk_classification_type

S

SECURITYDBO

SECURITY_MASTER_DETAIL

RISK_CLASSIFICATION_TYPE

VARCHAR2(15)

.../riskClassificationType

delayDaysType



string

5074

in_sm_delay_days_type

S

SECURITYDBO

SECURITY_MASTER

DELAY_DAYS_TYPE

VARCHAR2(1)

.../delayDaysType

EquityModel



EquityModel

Equity Model 

.../EquityModel/

FixedIncomeModel



FixedIncomeModel

Fixed Income Model

.../FixedIncomeModel/

FixedIncomeExtension



FixedIncomeExtensionModel

Fixed Income Extension Model

.../FixedIncomeExtension/

SMExtension



SMExtensionModel

SM Extension Model

.../SMExtension/

UnderlyingModel



UnderlyingModel

Underlying Model

.../UnderlyingModel/

MultipleLegSwapModel



MultipleLegSwapModel

Multiple Leg Swap Model

.../MultipleLegSwapModel/

CapsAndFloorsModel

CapsAndFloorsModelCaps And Floors Model.../CapsAndFloorsModel
IndexModel

IndexModelIndex Model.../IndexModel
ScheduleModel

ScheduleModelSchedule Model.../ScheduleModel
IssueVariableRateModel

IssueVariableRateModelIssue Variable Rate Model.../IssueVariableRateModel
EarningsTimePeriodModel

EarningsTimePeriodModelEarnings Time Period Model.../EarningsTimePeriodModel
FloaterModel

FloaterModelFloater Model.../FloaterModel
  • No labels