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 7 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) Data Map Table

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

derivChar11

string8259in_derv_char11
SECURITYDBODERIVATIVESDERV_CHAR11VARCHAR2(30).../derivChar11
derivChar12

string8260in_derv_char12
SECURITYDBODERIVATIVESDERV_CHAR12VARCHAR2(30).../derivChar12
derivChar13

string8261in_derv_char13
SECURITYDBODERIVATIVESDERV_CHAR13VARCHAR2(30).../derivChar13
derivChar14

string8262in_derv_char14
SECURITYDBODERIVATIVESDERV_CHAR14VARCHAR2(30).../derivChar14
derivChar15

string8263in_derv_char15
SECURITYDBODERIVATIVESDERV_CHAR15VARCHAR2(30).../derivChar15
derivChar16

string8264in_derv_char16
SECURITYDBODERIVATIVESDERV_CHAR16VARCHAR2(30).../derivChar16
derivChar17

string8265in_derv_char17
SECURITYDBODERIVATIVESDERV_CHAR17VARCHAR2(30).../derivChar17
derivChar18

string8566in_derv_char18
SECURITYDBODERIVATIVESDERV_CHAR18VARCHAR2(30).../derivChar18
derivChar19

string8567in_derv_char19
SECURITYDBODERIVATIVESDERV_CHAR19VARCHAR2(30).../derivChar19
derivChar20

string8568in_derv_char20
SECURITYDBODERIVATIVESDERV_CHAR20VARCHAR2(30).../derivChar20
derivChar21

string8774in_derv_char21
SECURITYDBODERIVATIVESDERV_CHAR21VARCHAR2(30).../derivChar21
derivChar22

string8775in_derv_char22
SECURITYDBODERIVATIVESDERV_CHAR22VARCHAR2(30).../derivChar22
derivChar23

string8776in_derv_char23
SECURITYDBODERIVATIVESDERV_CHAR23VARCHAR2(30).../derivChar23
derivChar24

string8777in_derv_char24
SECURITYDBODERIVATIVESDERV_CHAR24VARCHAR2(30).../derivChar24
derivChar25

string8778in_derv_char25
SECURITYDBODERIVATIVESDERV_CHAR25VARCHAR2(30).../derivChar25
derivChar26

string16660in_derv_char26
SECURITYDBODERIVATIVESDERV_CHAR26VARCHAR2(30).../derivChar26
derivFloat1

decimal3326in_derv_float1
SECURITYDBODERIVATIVESDERV_FLOAT1
.../derivFloat1
derivFloat2

decimal3327in_derv_float2
SECURITYDBODERIVATIVESDERV_FLOAT2
.../derivFloat2
derivFloat3

decimal3328in_derv_float3
SECURITYDBODERIVATIVESDERV_FLOAT3
.../derivFloat3
derivFloat4

decimal3329in_derv_float4
SECURITYDBODERIVATIVESDERV_FLOAT4
.../derivFloat4
derivFloat5

decimal3330in_derv_float5
SECURITYDBODERIVATIVESDERV_FLOAT5
.../derivFloat5
derivFloat6

decimal8254in_derv_float6
SECURITYDBODERIVATIVESDERV_FLOAT6
.../derivFloat6
derivFloat7

decimal8255in_derv_float7
SECURITYDBODERIVATIVESDERV_FLOAT7
.../derivFloat7
derivFloat8

decimal8256in_derv_float8
SECURITYDBODERIVATIVESDERV_FLOAT8
.../derivFloat8
derivFloat9

decimal8257in_derv_float9
SECURITYDBODERIVATIVESDERV_FLOAT9
.../derivFloat9
derivFloat10

decimal8258in_derv_float10
SECURITYDBODERIVATIVESDERV_FLOAT10
.../derivFloat10
derivFloat11

decimal8769in_derv_float11
SECURITYDBODERIVATIVESDERV_FLOAT11
.../derivFloat11
derivFloat12

decimal8770in_derv_float12
SECURITYDBODERIVATIVESDERV_FLOAT12
.../derivFloat12
derivFloat13

decimal8771in_derv_float13
SECURITYDBODERIVATIVESDERV_FLOAT13
.../derivFloat13
derivFloat14

decimal8772in_derv_float14
SECURITYDBODERIVATIVESDERV_FLOAT14
.../derivFloat14
derivFloat15

decimal8773in_derv_float15
SECURITYDBODERIVATIVESDERV_FLOAT15
.../derivFloat15

derivDate1



date

3321

in_derv_date1


SECURITYDBO

DERIVATIVES

DERV_DATE1

DATE

.../derivDate1

derivDate2

date3322in_derv_date2
SECURITYDBODERIVATIVESDERV_DATE2DATE.../derivDate2
derivDate3

date3323in_derv_date3
SECURITYDBODERIVATIVESDERV_DATE3DATE.../derivDate3
derivDate4

date3324in_derv_date4
SECURITYDBODERIVATIVESDERV_DATE4DATE.../derivDate4
derivDate5

date3325in_derv_date5
SECURITYDBODERIVATIVESDERV_DATE5DATE.../derivDate5
pmtAtIndicator

string3604in_pmt_at_indicator
SECURITYDBODERIVATIVESPMT_AT_INDICATOR
.../pmtAtIndicator
pArrearsFlag

string3602in_p_arrears_flag
SECURITYDBODERIVATIVESP_ARREARS_FLAG
.../pArrearsFlag
pCalcMethod

string3313in_p_calc_method
SECURITYDBODERIVATIVESP_CALC_METHOD
.../pCalcMethod
pCompoundingInd

string3311in_p_compounding_ind
SECURITYDBODERIVATIVESP_COMPOUNDING_IND
.../pCompoundingInd
pDivdCarryFlag

string3305in_p_divd_carry_flag
SECURITYDBODERIVATIVESP_DIVD_CARRY_FLAG
.../pDivdCarryFlag
pDivdReinvFlag

string3303in_p_divd_reinv_flag
SECURITYDBODERIVATIVESP_DIVD_REINV_FLAG
.../pDivdReinvFlag
pLegType

string3307in_p_leg_type
SECURITYDBODERIVATIVESP_LEG_TYPE
.../pLegType
pMultiplier

string3600in_p_multiplier
SECURITYDBODERIVATIVESP_MULTIPLIER
.../pMultiplier
premiumType

string3302in_premium_type
SECURITYDBODERIVATIVESPREMIUM_TYPE
.../premiumType

pRollConvention



string

3309

in_p_roll_convention


SECURITYDBO

DERIVATIVES

P_ROLL_CONVENTION

CHAR(2)

.../pRollConvention

pSpreadAmt

decimal3315in_p_spread_amt
SECURITYDBODERIVATIVESP_SPREAD_AMT
.../pSpreadAmt
returnType

string3598in_return_type
SECURITYDBODERIVATIVESRETURN_TYPE
.../returnType
rDivdCarryFlag

string3306in_r_divd_carry_flag
SECURITYDBODERIVATIVESR_DIVD_CARRY_FLAG
.../rDivdCarryFlag
rDivdReinvFlag

string3304in_r_divd_reinv_flag
SECURITYDBODERIVATIVESR_DIVD_REINV_FLAG
.../rDivdReinvFlag
rLegType

string3308in_r_leg_type
SECURITYDBODERIVATIVESR_LEG_TYPE
.../rLegType
rMultiplier

decimal3601in_r_multiplier
SECURITYDBODERIVATIVESR_MULTIPLIER
.../rMultiplier

rRollConvention



string

3310

in_r_roll_convention


SECURITYDBO

DERIVATIVES

R_ROLL_CONVENTION

CHAR(2)

.../rRollConvention

rSpreadAmt

decimal3316in_r_spread_amt
SECURITYDBODERIVATIVESR_SPREAD_AMT
.../rSpreadAmt
rArrearsFlag

string3603in_r_arrears_flag
SECURITYDBODERIVATIVESR_ARREARS_FLAG
.../rArrearsFlag

rCalcMethod



string

3314

in_r_calc_method

S

SECURITYDBO

DERIVATIVES

R_CALC_METHOD

CHAR(2)

.../rCalcMethod

rCompoundingInd

string3312in_r_compounding_ind
SECURITYDBODERIVATIVESR_COMPOUNDING_IND
.../rCompoundingInd
underlyingCmpid

string12385in_underlying_cmpid
SECURITYDBODERIVATIVESUNDERLYING_CMPID
.../underlyingCmpid
underlyingSecid

string12386in_underlying_secid
SECURITYDBODERIVATIVESUNDERLYING_SECID
.../underlyingSecid

clearedSecurity



string

5027

in_cleared_security

S

SECURITYDBO

DERIVATIVES

CLEARED_SECURITY

VARCHAR2(1)

.../clearedSecurity

calcMethod

string4589in_calc_method
SECURITYDBOSWAPSCALC_METHOD
.../calcMethod
compoundAccrMethod

string4590in_compound_accr_method
SECURITYDBOSWAPSCOMPOUND_ACCR_METHOD
.../compoundAccrMethod
compoundIndicator

string1364in_compound_flag
SECURITYDBOSWAPSCOMPOUND_FLAG
.../compoundIndicator

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

swapType

string4590,1364in_pay_receive_ind
in_optiondescr
SECURITYDBOSWAPPAY_RECEIVE_IND
.../swapType
payRecIndicator

string4590in_pay_receive_ind
SECURITYDBOSWAPSPAY_RECEIVE_IND
.../payRecIndicator
basisOffset

decimal4585in_basis_offset
SECURITYDBOSWAPSBASIS_OFFSET
.../basisOffset
financeLegSide

string4583in_finance_leg_side
SECURITYDBOSWAPSFINANCE_LEG_SIDE
.../financeLegSide
initialFeeCurrency

string4580in_initial_fee_currency
SECURITYDBOSWAPSINITIAL_FEE_CURRENCY
.../initialFeeCurrency

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

generateSwapResetScheduleSwitch

YesNoOptionEnum2299

not stored in DB, used to generate the Swap Reset Schedule during SMF creation.../generateSwapResetScheduleSwitch

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