...
Table of Contents |
---|
Anchor | ||||
---|---|---|---|---|
|
Info |
---|
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 |
payLeg
jounalizingFlag |
SmfLegModel
Repeated Group (see extra table below)
EagleML/referenceTransaction/multilegSMF/contractLeg/
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/ | |||||||||||||||
| |||||||||||||||||
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 |