MultiLeg SMF - Data Map Table
The 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 | ||
jounalizingFlag | Ā | Ā | JournalizingFlagEnum | 1293 | in_journal_flag | Ā | not stored in DB, used to manage the download logic | Ā | EagleML/referenceTransaction/multilegSMF/jounalizingFlag | ||
asOfEffectiveDate | Ā | Ā | date | 4212 | Ā | Ā | not stored in DB, used for time sensitive securities load logic | Ā | EagleML/referenceTransaction/multilegSMF/asOfEffectiveDate | ||
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 | Ā | Ā | NoteModel | EagleML/referenceTransaction/multilegSMF/NoteModel/ | |||||||
issuer | Ā | Ā | issuerModel | EagleML/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 | Ā | Ā | string | 8259 | in_derv_char11 | Ā | SECURITYDBO | DERIVATIVES | DERV_CHAR11 | VARCHAR2(30) | .../derivChar11 |
derivChar12 | Ā | Ā | string | 8260 | in_derv_char12 | Ā | SECURITYDBO | DERIVATIVES | DERV_CHAR12 | VARCHAR2(30) | .../derivChar12 |
derivChar13 | Ā | Ā | string | 8261 | in_derv_char13 | Ā | SECURITYDBO | DERIVATIVES | DERV_CHAR13 | VARCHAR2(30) | .../derivChar13 |
derivChar14 | Ā | Ā | string | 8262 | in_derv_char14 | Ā | SECURITYDBO | DERIVATIVES | DERV_CHAR14 | VARCHAR2(30) | .../derivChar14 |
derivChar15 | Ā | Ā | string | 8263 | in_derv_char15 | Ā | SECURITYDBO | DERIVATIVES | DERV_CHAR15 | VARCHAR2(30) | .../derivChar15 |
derivChar16 | Ā | Ā | string | 8264 | in_derv_char16 | Ā | SECURITYDBO | DERIVATIVES | DERV_CHAR16 | VARCHAR2(30) | .../derivChar16 |
derivChar17 | Ā | Ā | string | 8265 | in_derv_char17 | Ā | SECURITYDBO | DERIVATIVES | DERV_CHAR17 | VARCHAR2(30) | .../derivChar17 |
derivChar18 | Ā | Ā | string | 8566 | in_derv_char18 | Ā | SECURITYDBO | DERIVATIVES | DERV_CHAR18 | VARCHAR2(30) | .../derivChar18 |
derivChar19 | Ā | Ā | string | 8567 | in_derv_char19 | Ā | SECURITYDBO | DERIVATIVES | DERV_CHAR19 | VARCHAR2(30) | .../derivChar19 |
derivChar20 | Ā | Ā | string | 8568 | in_derv_char20 | Ā | SECURITYDBO | DERIVATIVES | DERV_CHAR20 | VARCHAR2(30) | .../derivChar20 |
derivChar21 | Ā | Ā | string | 8774 | in_derv_char21 | Ā | SECURITYDBO | DERIVATIVES | DERV_CHAR21 | VARCHAR2(30) | .../derivChar21 |
derivChar22 | Ā | Ā | string | 8775 | in_derv_char22 | Ā | SECURITYDBO | DERIVATIVES | DERV_CHAR22 | VARCHAR2(30) | .../derivChar22 |
derivChar23 | Ā | Ā | string | 8776 | in_derv_char23 | Ā | SECURITYDBO | DERIVATIVES | DERV_CHAR23 | VARCHAR2(30) | .../derivChar23 |
derivChar24 | Ā | Ā | string | 8777 | in_derv_char24 | Ā | SECURITYDBO | DERIVATIVES | DERV_CHAR24 | VARCHAR2(30) | .../derivChar24 |
derivChar25 | Ā | Ā | string | 8778 | in_derv_char25 | Ā | SECURITYDBO | DERIVATIVES | DERV_CHAR25 | VARCHAR2(30) | .../derivChar25 |
derivChar26 | Ā | Ā | string | 16660 | in_derv_char26 | Ā | SECURITYDBO | DERIVATIVES | DERV_CHAR26 | VARCHAR2(30) | .../derivChar26 |
derivFloat1 | Ā | Ā | decimal | 3326 | in_derv_float1 | Ā | SECURITYDBO | DERIVATIVES | DERV_FLOAT1 | Ā | .../derivFloat1 |
derivFloat2 | Ā | Ā | decimal | 3327 | in_derv_float2 | Ā | SECURITYDBO | DERIVATIVES | DERV_FLOAT2 | Ā | .../derivFloat2 |
derivFloat3 | Ā | Ā | decimal | 3328 | in_derv_float3 | Ā | SECURITYDBO | DERIVATIVES | DERV_FLOAT3 | Ā | .../derivFloat3 |
derivFloat4 | Ā | Ā | decimal | 3329 | in_derv_float4 | Ā | SECURITYDBO | DERIVATIVES | DERV_FLOAT4 | Ā | .../derivFloat4 |
derivFloat5 | Ā | Ā | decimal | 3330 | in_derv_float5 | Ā | SECURITYDBO | DERIVATIVES | DERV_FLOAT5 | Ā | .../derivFloat5 |
derivFloat6 | Ā | Ā | decimal | 8254 | in_derv_float6 | Ā | SECURITYDBO | DERIVATIVES | DERV_FLOAT6 | Ā | .../derivFloat6 |
derivFloat7 | Ā | Ā | decimal | 8255 | in_derv_float7 | Ā | SECURITYDBO | DERIVATIVES | DERV_FLOAT7 | Ā | .../derivFloat7 |
derivFloat8 | Ā | Ā | decimal | 8256 | in_derv_float8 | Ā | SECURITYDBO | DERIVATIVES | DERV_FLOAT8 | Ā | .../derivFloat8 |
derivFloat9 | Ā | Ā | decimal | 8257 | in_derv_float9 | Ā | SECURITYDBO | DERIVATIVES | DERV_FLOAT9 | Ā | .../derivFloat9 |
derivFloat10 | Ā | Ā | decimal | 8258 | in_derv_float10 | Ā | SECURITYDBO | DERIVATIVES | DERV_FLOAT10 | Ā | .../derivFloat10 |
derivFloat11 | Ā | Ā | decimal | 8769 | in_derv_float11 | Ā | SECURITYDBO | DERIVATIVES | DERV_FLOAT11 | Ā | .../derivFloat11 |
derivFloat12 | Ā | Ā | decimal | 8770 | in_derv_float12 | Ā | SECURITYDBO | DERIVATIVES | DERV_FLOAT12 | Ā | .../derivFloat12 |
derivFloat13 | Ā | Ā | decimal | 8771 | in_derv_float13 | Ā | SECURITYDBO | DERIVATIVES | DERV_FLOAT13 | Ā | .../derivFloat13 |
derivFloat14 | Ā | Ā | decimal | 8772 | in_derv_float14 | Ā | SECURITYDBO | DERIVATIVES | DERV_FLOAT14 | Ā | .../derivFloat14 |
derivFloat15 | Ā | Ā | decimal | 8773 | in_derv_float15 | Ā | SECURITYDBO | DERIVATIVES | DERV_FLOAT15 | Ā | .../derivFloat15 |
derivDate1 | Ā | Ā | date | 3321 | in_derv_date1 | Ā | SECURITYDBO | DERIVATIVES | DERV_DATE1 | DATE | .../derivDate1 |
derivDate2 | Ā | Ā | date | 3322 | in_derv_date2 | Ā | SECURITYDBO | DERIVATIVES | DERV_DATE2 | DATE | .../derivDate2 |
derivDate3 | Ā | Ā | date | 3323 | in_derv_date3 | Ā | SECURITYDBO | DERIVATIVES | DERV_DATE3 | DATE | .../derivDate3 |
derivDate4 | Ā | Ā | date | 3324 | in_derv_date4 | Ā | SECURITYDBO | DERIVATIVES | DERV_DATE4 | DATE | .../derivDate4 |
derivDate5 | Ā | Ā | date | 3325 | in_derv_date5 | Ā | SECURITYDBO | DERIVATIVES | DERV_DATE5 | DATE | .../derivDate5 |
pmtAtIndicator | Ā | Ā | string | 3604 | in_pmt_at_indicator | Ā | SECURITYDBO | DERIVATIVES | PMT_AT_INDICATOR | Ā | .../pmtAtIndicator |
pArrearsFlag | Ā | Ā | string | 3602 | in_p_arrears_flag | Ā | SECURITYDBO | DERIVATIVES | P_ARREARS_FLAG | Ā | .../pArrearsFlag |
pCalcMethod | Ā | Ā | string | 3313 | in_p_calc_method | Ā | SECURITYDBO | DERIVATIVES | P_CALC_METHOD | Ā | .../pCalcMethod |
pCompoundingInd | Ā | Ā | string | 3311 | in_p_compounding_ind | Ā | SECURITYDBO | DERIVATIVES | P_COMPOUNDING_IND | Ā | .../pCompoundingInd |
pDivdCarryFlag | Ā | Ā | string | 3305 | in_p_divd_carry_flag | Ā | SECURITYDBO | DERIVATIVES | P_DIVD_CARRY_FLAG | Ā | .../pDivdCarryFlag |
pDivdReinvFlag | Ā | Ā | string | 3303 | in_p_divd_reinv_flag | Ā | SECURITYDBO | DERIVATIVES | P_DIVD_REINV_FLAG | Ā | .../pDivdReinvFlag |
pLegType | Ā | Ā | string | 3307 | in_p_leg_type | Ā | SECURITYDBO | DERIVATIVES | P_LEG_TYPE | Ā | .../pLegType |
pMultiplier | Ā | Ā | string | 3600 | in_p_multiplier | Ā | SECURITYDBO | DERIVATIVES | P_MULTIPLIER | Ā | .../pMultiplier |
premiumType | Ā | Ā | string | 3302 | in_premium_type | Ā | SECURITYDBO | DERIVATIVES | PREMIUM_TYPE | Ā | .../premiumType |
pRollConvention | Ā | Ā | string | 3309 | in_p_roll_convention | Ā | SECURITYDBO | DERIVATIVES | P_ROLL_CONVENTION | CHAR(2) | .../pRollConvention |
pSpreadAmt | Ā | Ā | decimal | 3315 | in_p_spread_amt | Ā | SECURITYDBO | DERIVATIVES | P_SPREAD_AMT | Ā | .../pSpreadAmt |
returnType | Ā | Ā | string | 3598 | in_return_type | Ā | SECURITYDBO | DERIVATIVES | RETURN_TYPE | Ā | .../returnType |
rDivdCarryFlag | Ā | Ā | string | 3306 | in_r_divd_carry_flag | Ā | SECURITYDBO | DERIVATIVES | R_DIVD_CARRY_FLAG | Ā | .../rDivdCarryFlag |
rDivdReinvFlag | Ā | Ā | string | 3304 | in_r_divd_reinv_flag | Ā | SECURITYDBO | DERIVATIVES | R_DIVD_REINV_FLAG | Ā | .../rDivdReinvFlag |
rLegType | Ā | Ā | string | 3308 | in_r_leg_type | Ā | SECURITYDBO | DERIVATIVES | R_LEG_TYPE | Ā | .../rLegType |
rMultiplier | Ā | Ā | decimal | 3601 | in_r_multiplier | Ā | SECURITYDBO | DERIVATIVES | R_MULTIPLIER | Ā | .../rMultiplier |
rRollConvention | Ā | Ā | string | 3310 | in_r_roll_convention | Ā | SECURITYDBO | DERIVATIVES | R_ROLL_CONVENTION | CHAR(2) | .../rRollConvention |
rSpreadAmt | Ā | Ā | decimal | 3316 | in_r_spread_amt | Ā | SECURITYDBO | DERIVATIVES | R_SPREAD_AMT | Ā | .../rSpreadAmt |
rArrearsFlag | Ā | Ā | string | 3603 | in_r_arrears_flag | Ā | SECURITYDBO | DERIVATIVES | R_ARREARS_FLAG | Ā | .../rArrearsFlag |
rCalcMethod | Ā | Ā | string | 3314 | in_r_calc_method | S | SECURITYDBO | DERIVATIVES | R_CALC_METHOD | CHAR(2) | .../rCalcMethod |
rCompoundingInd | Ā | Ā | string | 3312 | in_r_compounding_ind | Ā | SECURITYDBO | DERIVATIVES | R_COMPOUNDING_IND | Ā | .../rCompoundingInd |
underlyingCmpid | Ā | Ā | string | 12385 | in_underlying_cmpid | Ā | SECURITYDBO | DERIVATIVES | UNDERLYING_CMPID | Ā | .../underlyingCmpid |
underlyingSecid | Ā | Ā | string | 12386 | in_underlying_secid | Ā | SECURITYDBO | DERIVATIVES | UNDERLYING_SECID | Ā | .../underlyingSecid |
clearedSecurity | Ā | Ā | string | 5027 | in_cleared_security | S | SECURITYDBO | DERIVATIVES | CLEARED_SECURITY | VARCHAR2(1) | .../clearedSecurity |
calcMethod | Ā | Ā | string | 4589 | in_calc_method | Ā | SECURITYDBO | SWAPS | CALC_METHOD | Ā | .../calcMethod |
compoundAccrMethod | Ā | Ā | string | 4590 | in_compound_accr_method | Ā | SECURITYDBO | SWAPS | COMPOUND_ACCR_METHOD | Ā | .../compoundAccrMethod |
compoundIndicator | Ā | Ā | string | 1364 | in_compound_flag | Ā | SECURITYDBO | SWAPS | COMPOUND_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 | Ā | Ā | string | 4590,1364 | in_pay_receive_ind | Ā | SECURITYDBO | SWAP | PAY_RECEIVE_IND | Ā | .../swapType |
payRecIndicator | Ā | Ā | string | 4590 | in_pay_receive_ind | Ā | SECURITYDBO | SWAPS | PAY_RECEIVE_IND | Ā | .../payRecIndicator |
basisOffset | Ā | Ā | decimal | 4585 | in_basis_offset | Ā | SECURITYDBO | SWAPS | BASIS_OFFSET | Ā | .../basisOffset |
financeLegSide | Ā | Ā | string | 4583 | in_finance_leg_side | Ā | SECURITYDBO | SWAPS | FINANCE_LEG_SIDE | Ā | .../financeLegSide |
initialFeeCurrency | Ā | Ā | string | 4580 | in_initial_fee_currency | Ā | SECURITYDBO | SWAPS | INITIAL_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 |
rateConversionRule | Ā | Ā | string | 12849 | in_rate_conversion_rule | S | SECURITYDBO | DERIVATIVES | RATE_CONVERSION_RULE | VARCHAR2(20) | .../rateConversionRule |
convertInterestRate | Ā | Ā | YesNoOptionEnum | 9154 | Ā | Ā | not stored in DB, used to set rateConversionRule only for processingSecurityType = 'SWLEAC' | .../convertInterestRate | |||
generateSwapResetScheduleSwitch | Ā | Ā | YesNoOptionEnum | 2299 | Ā | Ā | not stored in DB, used to generate the Swap Reset Schedule during SMF creation | .../generateSwapResetScheduleSwitch | |||
armInitFixedPeriodMonths | Ā | Ā | integer | 18566 | in_arm_ini_fixed_period_months | S | SECURITYDBO | MBS_DETAIL_EXT | ARM_INIT_FIXED_PERIOD_MONTHS | NUMBER(38,0) | .../MBSExtension/armInitFixedPeriodMonths |
overrideSecurityMasterDates | Ā | Ā | YesNoOptionEnum | 7171 | Ā | Ā | not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../overrideSecurityMasterDates | |||
schedulePaymentFrequency | Ā | Ā | string | 7164 | Ā | Ā | not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../schedulePaymentFrequency | |||
schedulePaymentFrequencyCode | Ā | Ā | string | 7165 | Ā | Ā | not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../schedulePaymentFrequencyCode | |||
scheduleFirstValuationDate | Ā | Ā | date | 7562 | Ā | Ā | not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../scheduleFirstValuationDate | |||
scheduleLastValuationDate | Ā | Ā | date | 7561 | Ā | Ā | not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../scheduleLastValuationDate | |||
scheduleBusinessDayConvention | Ā | Ā | string | 7166 | Ā | Ā | not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../scheduleBusinessDayConvention | |||
scheduleCouponDayOfMonth | Ā | Ā | decimal | 7320 | Ā | Ā | not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../scheduleCouponDayOfMonth | |||
scheduleBusinessCalendarName | Ā | Ā | string | 7167 | Ā | Ā | not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../scheduleBusinessCalendarName | |||
scheduleDayOfMonthOverride | Ā | Ā | string | 7168 | Ā | Ā | not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../scheduleDayOfMonthOverride | |||
scheduleCouponDelayDays | Ā | Ā | decimal | 7321 | Ā | Ā | not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../scheduleCouponDelayDays | |||
scheduleCouponDelayDaysType | Ā | Ā | string | 7169 | Ā | Ā | not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../scheduleCouponDelayDaysType | |||
scheduleDelayDays | Ā | Ā | decimal | 7322 | Ā | Ā | not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../scheduleDelayDays | |||
scheduleDelayDaysType | Ā | Ā | string | 7170 | Ā | Ā | not stored in DB, used only when processingSecurityType = 'SWLEDB' | .../scheduleDelayDaysType | |||
EquityModel | Ā | Ā | EquityModel | .../EquityModel/ | |||||||
FixedIncomeModel | Ā | Ā | FixedIncomeModel | .../FixedIncomeModel/ | |||||||
FixedIncomeExtension | Ā | Ā | FixedIncomeExtensionModel | .../FixedIncomeExtension/ | |||||||
SMExtension | Ā | Ā | SMExtensionModel | .../SMExtension/ | |||||||
UnderlyingModel | Ā | Ā | UnderlyingModel | .../UnderlyingModel/ | |||||||
MultipleLegSwapModel | Ā | Ā | MultipleLegSwapModel | .../MultipleLegSwapModel/ | |||||||
CapsAndFloorsModel | Ā | Ā | CapsAndFloorsModel | .../CapsAndFloorsModel | |||||||
IndexModel | Ā | Ā | IndexModel | .../IndexModel | |||||||
ScheduleModel | Ā | Ā | ScheduleModel | .../ScheduleModel | |||||||
IssueVariableRateModel | Ā | Ā | IssueVariableRateModel | .../IssueVariableRateModel | |||||||
EarningsTimePeriodModel | Ā | Ā | EarningsTimePeriodModel | .../EarningsTimePeriodModel | |||||||
FloaterModel | Ā | Ā | FloaterModel | .../FloaterModel |
Ā