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 | EagleML/referenceTransaction/multilegSMF/contractLeg/ | |||||||||
payLeg | SmfLegModel | EagleML/referenceTransaction/multilegSMF/payLeg/ | |||||||||
receiveLeg | SmfLegModel | EagleML/referenceTransaction/multilegSMF/receiveLeg/ | |||||||||
NoteModel | NoteModel | Note Model | EagleML/referenceTransaction/multilegSMF/NoteModel/ | ||||||||
issuer | issuerModel | Issuer Model | EagleML/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 | .../EquityModel/ | |||||||||
FixedIncomeModel | FixedIncomeModel | .../FixedIncomeModel/ | |||||||||
FixedIncomeExtension | FixedIncomeExtensionModel | .../FixedIncomeExtension/ | |||||||||
SMExtension | SMExtensionModel | .../SMExtension/ | |||||||||
UnderlyingModel | UnderlyingModel | .../UnderlyingModel/ | |||||||||
MultipleLegSwapModel | MultipleLegSwapModel | .../MultipleLegSwapModel/ | |||||||||
CapsAndFloorsModel | CapsAndFloorsModel | Caps And Floors Model | .../CapsAndFloorsModel | ||||||||
IndexModel | IndexModel | Index Model | .../IndexModel | ||||||||
ScheduleModel | ScheduleModel | Schedule Model | .../ScheduleModel | ||||||||
IssueVariableRateModel | IssueVariableRateModel | Issue Variable Rate Model | .../IssueVariableRateModel | ||||||||
EarningsTimePeriodModel | EarningsTimePeriodModel | Earnings Time Period Model | .../EarningsTimePeriodModel | ||||||||
FloaterModel | FloaterModel | Floater Model | .../FloaterModel |