...
Element | Optional/ Required | Value Type | Star Tag | SP Parameter | SP Type | Include File Name | Eagle DB | DB Table | DB Field | DB Field Type | Xpath | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
assetStatus | Optional | string | 5400 | in_sec_ext_asset_status | S | sm_extension.inc | SECURITYDBO | SECURITY_MASTER_EXT | ASSET_STATUS | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/assetStatus | ||||||||||
changeDate | Optional | dateTime | 5433 | in_sec_ext_change_dt | S | sm_extension.inc | SECURITYDBO | SECURITY_MASTER_EXT | CHANGE_DT | DATE | EagleML/referenceTransaction/genericSMF/SMExtension/changeDate | ||||||||||
erisaFlagOptional | string | 10523 | in_erisa_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ERISA_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/erisaFlag | |||||||||||
fixedIncomeIndustry | Optional | string | 10202 | in_fixed_income_industry | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | FIXED_INCOME_INDUSTRY | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/fixedIncomeIndustry | ||||||||||
prvtPlace | Optional | string | 1421 | in_prvt_place | S | sm_extension.inc | SECURITYDBO | SECURITY_MASTER | PRVT_PLACE | CHAR(2) | EagleML/referenceTransaction/genericSMF/SMExtension/prvtPlace | ||||||||||
modifiedBy | Optional | string | 5435 | in_sec_ext_modified_by | S | sm_extension.inc | SECURITYDBO | SECURITY_MASTER_EXT | MODIFIED_BY | VARCHAR2(32) | EagleML/referenceTransaction/genericSMF/SMExtension/modifiedBy | ||||||||||
reviewedBy | Optional | string | 5437 | in_sec_ext_reviewed_by | S | sm_extension.inc | SECURITYDBO | SECURITY_MASTER_EXT | REVIEWED_BY | VARCHAR2(32) | EagleML/referenceTransaction/genericSMF/SMExtension/reviewedBy | ||||||||||
smSecType | Optional | string | 5439 | in_sec_ext_sm_sec_type | S | sm_extension.inc | SECURITYDBO | SECURITY_MASTER_EXT | SM_SEC_TYPE | VARCHAR2(16) | EagleML/referenceTransaction/genericSMF/SMExtension/smSecType | ||||||||||
wiFlagOptional | string | 5440 | in_sec_ext_wi_flag | S | sm_extension.inc | SECURITYDBO | SECURITY_MASTER_EXT | WI_FLAG | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/SMExtension/wiFlag | |||||||||||
smSecurityTypeOptional | string | 10175 | in_smde_security_type | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | SECURITY_TYPE | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/smSecurityType | |||||||||||
naicCode | Optional | string | 10194 | in_naic_code | S | sm_extension.inc | SECURITYDBO | FIXED_INCOME | NAIC_CODE | CHAR(8) | EagleML/referenceTransaction/genericSMF/SMExtension/naicCode | ||||||||||
naicDateOptional | date | 5890 | in_naic_date | S | sm_extension.inc | SECURITYDBO | NAIC | naic_date | DATE | EagleML/referenceTransaction/genericSMF/SMExtension/naicDate | |||||||||||
naicSymbolOptional | string | 5891 | in_naic_symbol | S | sm_extension.inc | SECURITYDBO | NAIC | naic_symbol | CHAR(15) | EagleML/referenceTransaction/genericSMF/SMExtension/naicSymbol | |||||||||||
naicSymbol2 | Optional | string | 5892 | in_naic_symbol2 | S | sm_extension.inc | SECURITYDBO | NAIC | naic_symbol2 | CHAR(15) | EagleML/referenceTransaction/genericSMF/SMExtension/naicSymbol2 | ||||||||||
naicSymbol3 | Optional | string | 5893 | in_naic_symbol3 | S | sm_extension.inc | SECURITYDBO | NAIC | naic_symbol3 | CHAR(15) | EagleML/referenceTransaction/genericSMF/SMExtension/naicSymbol3 | ||||||||||
naicMarketCode | Optional | string | 5856 | in_naic_market_code | S | sm_extension.inc | SECURITYDBO | NAIC | naic_market_code | CHAR(40) | EagleML/referenceTransaction/genericSMF/SMExtension/naicMarketCode | ||||||||||
naicRate | Optional | decimal | 5894 | in_naic_rate | N | sm_extension.inc | SECURITYDBO | NAIC | naic_rate | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/SMExtension/naicRate | ||||||||||
liquidity | Optional | string | 5434 | in_sec_ext_liquidity | S | sm_extension.inc | SECURITYDBO | SECURITY_MASTER_EXT | liquidity | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/SMExtension/liquidity | ||||||||||
pricingCusipOptional | string | 5436 | in_sec_ext_pricing_cusip | S | sm_extension.inc | SECURITYDBO | SECURITY_MASTER_EXT | pricing_cusip | VARCHAR2(9) | EagleML/referenceTransaction/genericSMF/SMExtension/pricingCusip | |||||||||||
remicEligibleIndOptional | string | 5441 | in_sec_ext_remic_eligible_ind | S | fixedincome_extension.inc | SECURITYDBO | SECURITY_MASTER_EXT | remic_eligible_ind | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/SMExtension/remicEligibleInd | |||||||||||
cdInstmtType | Optional | string | 5432 | in_sec_ext_cd_instmt_type | S | sm_extension.inc | SECURITYDBO | SECURITY_MASTER_EXT | cd_instmt_type | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/cdInstmtType | ||||||||||
roundFlagOptional | string | 5438 | in_sec_ext_round_flag | S | sm_extension.inc | SECURITYDBO | SECURITY_MASTER_EXT | round_flag | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/SMExtension/roundFlag | |||||||||||
assetBenchmark | Optional | string | 5399 | in_sec_ext_asset_benchmark | S | sm_extension.inc | SECURITYDBO | SECURITY_MASTER_EXT | asset_benchmark | VARCHAR2(9) | EagleML/referenceTransaction/genericSMF/SMExtension/assetBenchmark | ||||||||||
granularityCategory | Optional | string | 11476 | in_sec_ext_granularity_cat | S | sm_extension.inc | SECURITYDBO | SECURITY_MASTER_EXT | GRANULARITY_CATEGORY | CHAR(20) | EagleML/referenceTransaction/genericSMF/SMExtension/granularityCategory | ||||||||||
groupCode | Optional | string | 5858 | in_group_code | S | sm_extension.inc | SECURITYDBO | NAIC | group_code | CHAR(4) | EagleML/referenceTransaction/genericSMF/SMExtension/groupCodeblpYellowKey | ||||||||||
| finalRateRoundingPrecision | Optionalinteger | string | 1019512402 | in | _blp_yellow_keyS_sec_ext_final_rate_rnd_pr | N | sm_extension.inc | SECURITYDBO | SECMASTERSECURITY_ | DETAILMASTER_EXT | BLPFINAL_RATE_ | YELLOWROUND_ | KEYPREC | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/ | blpYellowKeyfinalRateRoundingPrecision | corpIssuerEquityTicker | Optional||||
| finalRateRoundingDirection | string | 1017912403 | in_sec_ext_ | corpfinal_ | issuerrate_ | equityrnd_ | tickerdir | S | sm_extension.inc | SECURITYDBO | SECMASTERSECURITY_ | DETAILMASTER_EXT | CORPORATEFINAL_ | ISSUERRATE_ | EQUITYROUND_ | TICKERDIR | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/ | corpIssuerEquityTickerfinalRateRoundingDirection | ||
countryOfIssue | OptionalblpYellowKey | string | 1019310195 | in_countryblp_ofyellow_issuekey | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | COUNTRYBLP_OFYELLOW_ISSUEKEY | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/countryOfIssueblpYellowKey | ||||||||||
desNotes | OptionalcorpIssuerEquityTicker | string | 1010510179 | in_corp_issuer_desequity_notesticker | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXTDES_ | NOTESCORPORATE_ISSUER_EQUITY_TICKER | VARCHAR2(10060) | EagleML/referenceTransaction/genericSMF/SMExtension/desNotescorpIssuerEquityTicker | ||||||||||
dividendRights | OptionalcountryOfIssue | string | 1009010193 | in_dividendcountry_of_rightsissue | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | DIVIDENDCOUNTRY_OF_RIGHTSISSUE | VARCHAR2(3060) | EagleML/referenceTransaction/genericSMF/SMExtension/dividendRightscountryOfIssue | ||||||||||
dtcRegistereddesNotes | Optional | string | 1009210105 | in_dtcdes_registerednotes | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | DTCDES_REGISTEREDNOTES | VARCHAR2(60100) | EagleML/referenceTransaction/genericSMF/SMExtension/dtcRegistereddesNotes | ||||||||||
industryGroupdividendRights | Optional | string | 1009910090 | in_industrydividend_grouprights | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INDUSTRYDIVIDEND_GROUPRIGHTS | VARCHAR2(6030) | EagleML/referenceTransaction/genericSMF/SMExtension/industryGroupdividendRights | ||||||||||
industrySectordtcRegistered | Optional | string | 1010010092 | in_industrydtc_sectorregistered | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INDUSTRYDTC_SECTORREGISTERED | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/industrySectordtcRegistered | ||||||||||
industrySubgroup | OptionalindustryGroup | string | 1010110099 | in_industry_subgroupgroup | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INDUSTRY_SUBGROUPGROUP | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/industrySubgroupindustryGroup | ||||||||||
industrySubgroupNumberindustrySector | Optional | string | 1010210100 | in_industry_subgroup_numbersector | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INDUSTRY_SUBGROUP_NUMBERSECTOR | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/industrySubgroupNumberindustrySector | ||||||||||
issuerIndustryindustrySubgroup | Optional | string | 1017810101 | in_issuerindustry_industrysubgroup | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ISSUERINDUSTRY_INDUSTRYSUBGROUP | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/issuerIndustryindustrySubgroup | ||||||||||
marketSectorDescriptionindustrySubgroupNumber | Optional | string | 1017310102 | in_marketindustry_sectorsubgroup_descriptionnumber | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | MARKETINDUSTRY_SECTORSUBGROUP_DESCRIPTIONNUMBER | VARCHAR2(860) | EagleML/referenceTransaction/genericSMF/SMExtension/marketSectorDescriptionindustrySubgroupNumber | ||||||||||
smdeNaicCodeissuerIndustry | Optional | string | 1019410178 | in_smdeissuer_naic_codeindustry | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | NAICISSUER_CODEINDUSTRY | CHARVARCHAR2(860) | EagleML/referenceTransaction/genericSMF/SMExtension/smdeNaicCodeissuerIndustry | ||||||||||
parentCompanymarketSectorDescription | Optional | string | 1017610173 | in_market_parentsector_companydescription | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | PARENTMARKET_SECTOR_COMPANYDESCRIPTION | VARCHAR2(608) | EagleML/referenceTransaction/genericSMF/SMExtension/parentCompanymarketSectorDescription | ||||||||||
priceType | OptionalsmdeNaicCode | string | 1009610194 | in_smde_pricenaic_typecode | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | PRICENAIC_TYPECODE | VARCHAR2CHAR(608) | EagleML/referenceTransaction/genericSMF/SMExtension/priceTypesmdeNaicCode | ||||||||||
redenominationDateparentCompany | Optionalstring | date10176 | 10180 | in_redenominationparent_datecompany | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | REDENOMINATIONPARENT_DATEDATECOMPANY | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/redenominationDateparentCompany | ||||||||||
redenominationMethodpriceType | Optional | string | 1018910096 | in_redenominationprice_methodtype | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | REDENOMINATIONPRICE_METHODTYPE | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/redenominationMethodpriceType | ||||||||||
redenominationPriceredenominationDate | Optionaldate | decimal10180 | 10191 | in_redenomination_pricedate | NS | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | REDENOMINATION_PRICENUMBER(28,12)DATE | DATE | EagleML/referenceTransaction/genericSMF/SMExtension/redenominationPriceredenominationDate | ||||||||||
redenominationRoundMethodredenominationMethod | Optional | string | 1019010189 | in_redenomination_round_method | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | REDENOMINATION_ROUND_METHOD | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/redenominationRoundMethodredenominationMethod | ||||||||||
rmIndustryredenominationPrice | Optionaldecimal | string | 1020010191 | in_rmredenomination_industryprice | SN | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | RMREDENOMINATION_INDUSTRYPRICE | VARCHAR2NUMBER(6028,12) | EagleML/referenceTransaction/genericSMF/SMExtension/rmIndustryredenominationPrice | ||||||||||
shortNameredenominationRoundMethod | Optional | string | 1017710190 | in_shortredenomination_round_namemethod | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | SHORTREDENOMINATION_ROUND_NAMEMETHOD | VARCHAR2(3060) | EagleML/referenceTransaction/genericSMF/SMExtension/shortNameredenominationRoundMethod | ||||||||||
topixIndustryrmIndustry | Optional | string | 1020110200 | in_topixrm_industry | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | TOPIXRM_INDUSTRY | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/topixIndustryrmIndustry | ||||||||||
tradingStatus | OptionalshortName | string | 1019210177 | in_tradingshort_statusname | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | TRADINGSHORT_STATUSNAME | VARCHAR2(6030) | EagleML/referenceTransaction/genericSMF/SMExtension/tradingStatusshortName | ||||||||||
warrantCurrencytopixIndustry | Optional | string | 1009410201 | in_warranttopix_currencyindustry | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | WARRANTTOPIX_CURRENCYINDUSTRY | VARCHAR2(3060) | EagleML/referenceTransaction/genericSMF/SMExtension/warrantCurrencytopixIndustry | ||||||||||
warrantNametradingStatus | Optional | string | 1009810192 | in_warranttrading_namestatus | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | WARRANTTRADING_NAMESTATUS | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/warrantNametradingStatus | ||||||||||
warrantTicker | OptionalwarrantCurrency | string | 1009710094 | in_warrant_tickercurrency | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | WARRANT_TICKERCURRENCY | VARCHAR2(6030) | EagleML/referenceTransaction/genericSMF/SMExtension/warrantTickerwarrantCurrency | ||||||||||
warrantUnderlyingCurrencywarrantName | Optional | string | 1009510098 | in_warrant_underlying_currencyname | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | WARRANT_UNDERLYING_CURRENCYNAME | VARCHAR2(3060) | EagleML/referenceTransaction/genericSMF/SMExtension/warrantUnderlyingCurrencywarrantName | ||||||||||
warrantUnderlyingCusipwarrantTicker | Optional | string | 1009310097 | in_warrant_underlying_cusipticker | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | WARRANT_UNDERLYING_CUSIPTICKER | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/warrantUnderlyingCusipwarrantTicker | ||||||||||
cashEquivFlagwarrantUnderlyingCurrency | Optional | string | 1052610095 | in_cashwarrant_equivunderlying_flagcurrency | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | CASHWARRANT_EQUIVUNDERLYING_FLAGCURRENCY | VARCHAR2(330) | EagleML/referenceTransaction/genericSMF/SMExtension/cashEquivFlagwarrantUnderlyingCurrency | ||||||||||
commercialPaperFlagwarrantUnderlyingCusip | Optional | string | 1052510093 | in_commercialwarrant_paperunderlying_flagcusip | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | COMMERCIALWARRANT_PAPERUNDERLYING_FLAGCUSIP | VARCHAR2(360) | EagleML/referenceTransaction/genericSMF/SMExtension/commercialPaperFlagwarrantUnderlyingCusip | ||||||||||
fifecFlagcashEquivFlag | Optional | string | 1052410526 | in_cash_fifecequiv_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | FIFECCASH_EQUIV_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/fifecFlagcashEquivFlag | ||||||||||
fundAdminFlagcommercialPaperFlag | Optional | string | 1053410525 | in_fundcommercial_adminpaper_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | FUNDCOMMERCIAL_ADMINPAPER_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/fundAdminFlagcommercialPaperFlag | ||||||||||
initialChrgRebateFlagfifecFlag | Optional | string | 1053110524 | in_initialfifec_chrg_rebate_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INITIAL_CHRG_REBATEFIFEC_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/initialChrgRebateFlagfifecFlag | ||||||||||
internalManageFlagfundAdminFlag | Optional | string | 1053210534 | in_internalfund_manageadmin_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INTERNALFUND_MANAGEADMIN_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/internalManageFlagfundAdminFlag | ||||||||||
newIssueFlaginitialChrgRebateFlag | Optional | string | 1053310531 | in_newinitial_chrg_issuerebate_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | NEWINITIAL_CHRG_ISSUEREBATE_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/newIssueFlaginitialChrgRebateFlag | ||||||||||
supraNationalinternalManageFlag | Optional | string | 1052710532 | in_suprainternal_manage_nationalflag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | SUPRAINTERNAL_NATIONALMANAGE_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/supraNationalinternalManageFlag | ||||||||||
tia1961FlagnewIssueFlag | Optional | string | 1053510533 | in_tianew_1961issue_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | TIANEW_1961ISSUE_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/tia1961FlagnewIssueFlag | ||||||||||
ucitsFlag | OptionalsupraNational | string | 1052910527 | in_ucitssupra_flagnational | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | UCITSSUPRA_FLAGNATIONAL | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/ucitsFlagsupraNational | ||||||||||
unsecuredFlagtia1961Flag | Optional | string | 1053010535 | in_unsecuredtia_1961_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | UNSECUREDTIA_1961_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/unsecuredFlagtia1961Flag | ||||||||||
industrySubgroupNumucitsFlag | Optionalstring | integer | 1236410529 | in_industryucits_subgroup_numflag | NS | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXTINDUSTRY | UCITS_SUBGROUP_NUMFLAG | NUMBERVARCHAR2(383) | EagleML/referenceTransaction/genericSMF/SMExtension/industrySubgroupNumucitsFlag | ||||||||||
sedol1CountryIsounsecuredFlag | Optional | string | 1236510530 | in_sedol1unsecured_country_isoflag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXTSEDOL1 | UNSECURED_COUNTRY_ISOFLAG | VARCHAR2(303) | EagleML/referenceTransaction/genericSMF/SMExtension/sedol1CountryIsounsecuredFlag | ||||||||||
sedol2CountryIsoindustrySubgroupNum | Optionalinteger | string12364 | 12366 | in_sedol2industry_countrysubgroup_isonum | SN | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | SEDOL2INDUSTRY_COUNTRYSUBGROUP_ISONUM | VARCHAR2NUMBER(3038) | EagleML/referenceTransaction/genericSMF/SMExtension/sedol2CountryIsoindustrySubgroupNum | ||||||||||
preRedenomCrncysedol1CountryIso | Optional | string | 1236712365 | in_presedol1_redenomcountry_crncyiso | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | PRESEDOL1_REDENOMCOUNTRY_CRNCYISO | VARCHAR2(18030) | EagleML/referenceTransaction/genericSMF/SMExtension/preRedenomCrncysedol1CountryIso | ||||||||||
preEuroParAmtsedol2CountryIso | Optionalstring | decimal12366 | 12368 | in_presedol2_eurocountry_par_amtiso | NS | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | PRESEDOL2_EUROCOUNTRY_PAR_AMTISO | NUMBERVARCHAR2(38,1230) | EagleML/referenceTransaction/genericSMF/SMExtension/preEuroParAmtsedol2CountryIso | ||||||||||
postRedenomCrncy | OptionalpreRedenomCrncy | string | 1236912367 | in_postpre_redenom_crncy | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | POSTPRE_REDENOM_CRNCY | VARCHAR2(180) | EagleML/referenceTransaction/genericSMF/SMExtension/postRedenomCrncypreRedenomCrncy | ||||||||||
postEuroParAmtpreEuroParAmt | Optional | decimal | 1237012368 | in_postpre_euro_par_amt | N | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | POSTPRE_EURO_PAR_AMT | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/SMExtension/postEuroParAmtpreEuroParAmt | ||||||||||
lseSector | OptionalpostRedenomCrncy | string | 1237112369 | in_lsepost_redenom_sectorcrncy | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | LSEPOST_SECTORREDENOM_CRNCY | VARCHAR2(180) | EagleML/referenceTransaction/genericSMF/SMExtension/lseSectorpostRedenomCrncy | ||||||||||
lseSegmentpostEuroParAmt | Optionaldecimal | string12370 | 12372 | in_lse_segmentSpost_euro_par_amt | N | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | LSE_SEGMENT | VARCHAR2(180POST_EURO_PAR_AMT | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/SMExtension/lseSegmentpostEuroParAmt | |||||||||
icbSectorNamelseSector | Optional | string | 1237312371 | in_icblse_sector_name | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ICBLSE_SECTOR_NAME | VARCHAR2(180) | EagleML/referenceTransaction/genericSMF/SMExtension/icbSectorNamelseSector | icbSector | |||||||||
OptionallseSegment | string | 1237412372 | in_icblse_sectorsegment | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ICBLSE_SECTORSEGMENT | VARCHAR2(20180) | EagleML/referenceTransaction/genericSMF/SMExtension/icbSectorlseSegment | |||||||||||
icbSubsectorName | OptionalicbSectorName | string | 1237512373 | in_icb_subsectorsector_name | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ICB_SUBSECTORSECTOR_NAME | VARCHAR2(180) | EagleML/referenceTransaction/genericSMF/SMExtension/icbSubsectorNameicbSectorName | ||||||||||
icbSubsectoricbSector | Optional | string | 1237612374 | in_icb_subsectorsector | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ICB_SUBSECTORSECTOR | VARCHAR2(20) | EagleML/referenceTransaction/genericSMF/SMExtension/icbSubsectoricbSector | ||||||||||
icbSupersectorName | OptionalicbSubsectorName | string | 1237712375 | in_icb_supersectorsubsector_name | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ICB_SUPERSECTORSUBSECTOR_NAME | VARCHAR2(180) | EagleML/referenceTransaction/genericSMF/SMExtension/icbSupersectorNameicbSubsectorName | ||||||||||
icbSupersectoricbSubsector | Optional | string | 1237812376 | in_icb_supersectorsubsector | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ICB_SUPERSECTORSUBSECTOR | VARCHAR2(20) | EagleML/referenceTransaction/genericSMF/SMExtension/icbSupersectoricbSubsector | ||||||||||
icbIndustryNameicbSupersectorName | Optional | string | 1237912377 | in_icb_industrysupersector_name | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ICB_INDUSTRYSUPERSECTOR_NAME | VARCHAR2(180) | EagleML/referenceTransaction/genericSMF/SMExtension/icbIndustryNameicbSupersectorName | ||||||||||
icbIndustryicbSupersector | Optional | string | 1238012378 | in_icb_industrysupersector | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ICB_INDUSTRYSUPERSECTOR | VARCHAR2(20) | EagleML/referenceTransaction/genericSMF/SMExtension/icbIndustryicbSupersector | ||||||||||
idBbConnecticbIndustryName | Optionalstring | integer | 1238112379 | in_idicb_bbindustry_connectname | NS | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | IDICB_BBINDUSTRY_CONNECTNAME | NUMBERVARCHAR2(38180) | EagleML/referenceTransaction/genericSMF/SMExtension/idBbConnecticbIndustryName | ||||||||||
parentCompTicker | OptionalicbIndustry | string | 1238212380 | in_parenticb_comp_tickerindustry | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXTPARENT | ICB_COMP_TICKERINDUSTRY | VARCHAR2(18020) | EagleML/referenceTransaction/genericSMF/SMExtension/parentCompTickericbIndustry | ||||||||||
aggBondL1idBbConnect | Optionalinteger | string12381 | 2504 | in_aggid_bondbb_l1connect | SN | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | aggID_bondBB_l1CONNECT | VARCHAR2NUMBER(6038) | EagleML/referenceTransaction/genericSMF/SMExtension/aggBondL1idBbConnect | ||||||||||
aggBondL2parentCompTicker | Optional | string | 250512382 | in_aggparent_bondcomp_l2ticker | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | aggPARENT_bondCOMP_l2TICKER | VARCHAR2(60180) | EagleML/referenceTransaction/genericSMF/SMExtension/aggBondL2parentCompTicker | ||||||||||
aggBondL3 | OptionalaggBondL1 | string | 25062504 | in_agg_bond_l3l1 | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | agg_bond_l3l1 | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/aggBondL3aggBondL1 | ||||||||||
aggBondL4aggBondL2 | Optional | string | 25072505 | in_agg_bond_l4l2 | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | agg_bond_l4l2 | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/aggBondL4aggBondL2 | ||||||||||
redCode | OptionalaggBondL3 | string | 25172506 | in_redagg_bond_codel3 | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | redagg_bond_codel3 | VARCHAR2(2560) | EagleML/referenceTransaction/genericSMF/SMExtension/redCodeaggBondL3 | ||||||||||
contingentConvertibleaggBondL4 | Optionalstring | string | 168352507 | in_agg_bond_l4 | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | CONTINGENTagg_bond_CONVERTIBLEl4 | VARCHAR2(160) | EagleML/referenceTransaction/genericSMF/SMExtension/contingentConvertibleaggBondL4 | ||||||||||
redCode | Optionalstring | string | 169682517 | in_red_code | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ARS_AUCTION_STATUSred_code | VARCHAR2(25) | EagleML/referenceTransaction/genericSMF/SMExtension/ | arsAuctionStatusredCode | |||||||||
contingentConvertible | Optionalstring | string | 1696916835 | in_contingent_convertible | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ASSOCIATED_VARIABLE_CUSIPCONTINGENT_CONVERTIBLE | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/SMExtension/ | associatedVariableCusipcontingentConvertible | |||||||||
| bloombergSectorCodearsAuctionStatus | Optionalstring | string | 1697016968 | in_ars_auction_status | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | BLOOMBERGARS_SECTOR_CODEAUCTION_STATUS | VARCHAR2(50) | EagleML/referenceTransaction/genericSMF/SMExtension/bloombergSectorCodearsAuctionStatus | ||||||||||
| industrySectorNumberassociatedVariableCusip | Optionalstring | integer | 16971 | N16969 | in_associated_variable_cusip | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INDUSTRYASSOCIATED_SECTOR_NUMVARIABLE_CUSIP | VARCHAR2(50) | EagleML/referenceTransaction/genericSMF/SMExtension/industrySectorNumberassociatedVariableCusip | |||||||||
| isSubordinatedbloombergSectorCode | Optionalstring | string | 1697216970 | in_bloomberg_sector_code | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXTIS | _SUBORDINATEDBLOOMBERG_SECTOR_CODE | VARCHAR2(50) | EagleML/referenceTransaction/genericSMF/SMExtension/isSubordinatedbloombergSectorCode | ||||||||||
| liquidityProviderIdindustrySectorNumber | Optional | integer | 16973 | N16971 | in_industry_sector_num | N | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | LIQUIDITYINDUSTRY_PROVIDER_IDSECTOR_NUM | NUMBER(38,0) | EagleML/referenceTransaction/genericSMF/SMExtension/liquidityProviderIdindustrySectorNumber | |||||||||
| isSubordinated | adrSponsorTypestring | Optional | string16972 | in_is_subordinated | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXTADR | IS_SPONSOR_TYPESUBORDINATED | VARCHAR2(4) | EagleML/referenceTransaction/genericSMF/SMExtension/adrSponsorTypeisSubordinated | ||||||||||
| liquidityProviderId | fundDistributorinteger | Optional | string | S16973 | in_liquidity_provider_id | N | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | FUNDLIQUIDITY_PROVIDER_DISTRIBUTORID | VARCHAR2NUMBER(3038,0) | EagleML/referenceTransaction/genericSMF/SMExtension/fundDistributorliquidityProviderId | |||||||||
| indexFrequency | OptionaladrSponsorType | string | 17414 | in_adr_sponsor_type | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INDEXADR_SPONSOR_FREQUENCYTYPE | VARCHAR2(84) | EagleML/referenceTransaction/genericSMF/SMExtension/indexFrequencyadrSponsorType | ||||||||||
| fundGeoFocus | OptionalfundDistributor | string | 1622517415 | in_fund_geo_focusdistributor | Sin | _fund_mgmt_stylesm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_GEO_FOCUSDISTRIBUTOR | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/fundGeoFocuscfundDistributor | ||||||||||
| fundManagementStyleindexFrequency | Optional | string | 1622517416 | in_fundindex_mgmt_stylefrequency | Sin | _fund_mgmt_stylesm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXTFUND_MGMT_ | STYLEINDEX_FREQUENCY | VARCHAR2(8) | EagleML/referenceTransaction/genericSMF/SMExtension/indexFrequency | ||||||||||
| fundGeoFocus | string | 16226 | in_fund_geo_focus | S | in_fund_mgmt_style | SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_GEO_FOCUS | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/fundGeoFocusc | |||||||||||
| fundManagementStyle | string | 16225 | in_fund_mgmt_style | S | in_fund_mgmt_style | SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_MGMT_STYLE | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/fundManagementStyle | |||||||||||
| fundRtgClassFocus | string | 16222 | in_fund_rtg_class_focus | S | SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_RTG_CLASS_FOCUS | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/fundRtgClassFocus | ||||||||||||
| fundMarketCapFocus | string | 16223 | in_fund_mkt_cap_focus | S | SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_MKT_CAP_FOCUS | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/fundMarketCapFocus | ||||||||||||
| fundIndustryFocus | string | 16224 | in_fund_industry_focus | S | SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_INDUSTRY_FOCUS | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/fundIndustryFocus | ||||||||||||
| fundMaturityBandFocus | string | 16227 | in_fund_maturity_band_focus | S | SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_MATURITY_BAND_FOCUS | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/fundMaturityBandFocus | ||||||||||||
| aifmdFlag | string | 17439 | in_aifmd_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | AIFMD_FLAG | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/aifmdFlag | |||||||||||
| exchangeCode | string | 17441 | in_exch_code | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | EXCH_CODE | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/exchangeCode | |||||||||||
| exchangeMarketStatus | string | 17444 | in_exchange_market_status | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | EXCHANGE_MARKET_STATUS | VARCHAR2(20) | EagleML/referenceTransaction/genericSMF/SMExtension/exchangeMarketStatus | |||||||||||
| fundRedemptionFrequency | string | 17445 | in_fund_redemption_freq | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_REDEMPTION_FREQ | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/fundRedemptionFrequency | |||||||||||
| fundType | string | 17442 | in_fund_type | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_TYPE | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/fundType | |||||||||||
| inflationLinkedFlag | string | 17443 | in_inflation_linked_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INFLATION_LINKED_FLAG | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/inflationLinkedFlag | |||||||||||
| msciCountryCode | string | 17446 | in_msci_country_code | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | MSCI_COUNTRY_CODE | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/msciCountryCode | |||||||||||
| quoteUnits | string | 17440 | in_quote_units | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | QUOTE_UNITS | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/quoteUnits | |||||||||||
| baselIII | BaselIIIEnum | 18304 | in_basel_iii | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | BASEL_III | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/baselIII | |||||||||||
| contingentCapitalIndicator | YesNoOptionEnum | 18305 | in_cap_contingent | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | CAP_CONTINGENT | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/contingentCapitalIndicator | |||||||||||
| contingentCapitalType | ContingentCapitalTypeEnum | 18306 | in_cap_contingent_type | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | CAP_CONTINGENT_TYPE | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/contingentCapitalType | |||||||||||
| contingentCapitalTriggerLevel | decimal | 18307 | in_cap_cont_trig_level | F | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | CAP_CONT_TRIG_LEVEL | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/SMExtension/contingentCapitalTriggerLevel | |||||||||||
| contingentCapitalPriceLevelType | normalizedString | 18308 | in_cap_cont_price_level | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | CAP_CONT_PRICE_LEVEL | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/fundManagementStylecontingentCapitalPriceLevelType | |||||||||||
| contingentCapitalFloorLevelType | aifmdFlagnormalizedString | Optional | string18309 | in_cap_cont_floor_level | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXTAIFMD_ | FLAGCAP_CONT_FLOOR_LEVEL | VARCHAR2(30255) | EagleML/referenceTransaction/genericSMF/SMExtension/aifmdFlagcontingentCapitalFloorLevelType | ||||||||||
| guarantorType | exchangeCodenormalizedString | Optional | string18312 | in_guarantor_type | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | EXCHGUARANTOR_CODETYPE | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/exchangeCodeguarantorType | ||||||||||
| tier1CapitalIndicator | exchangeMarketStatusYesNoOptionEnum | Optional | string18315 | in_tier1_capital | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXTEXCHANGE | TIER1_MARKET_STATUSCAPITAL | VARCHAR2(20255) | EagleML/referenceTransaction/genericSMF/SMExtension/exchangeMarketStatustier1CapitalIndicator | ||||||||||
| tier2CapitalIndicator | fundRedemptionFrequencyYesNoOptionEnum | Optional | string18316 | in_tier1_capital | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXTFUND | TIER2_REDEMPTION_FREQCAPITAL | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/fundRedemptionFrequencytier2CapitalIndicator | ||||||||||
| fundShareClass | fundTypenormalizedString | Optional | string18318 | in_fund_share_class | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_SHARE_TYPECLASS | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/fundTypefundShareClass | ||||||||||
| privateFundIndicator | inflationLinkedFlagYesNoOptionEnum | Optional | string18373 | in_private_fund | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXTINFLATION | PRIVATE_LINKED_FLAGFUND | VARCHAR2(30255) | EagleML/referenceTransaction/genericSMF/SMExtension/inflationLinkedFlagprivateFundIndicator | ||||||||||
| ukTaxableFlag | msciCountryCodeYesNoOptionEnum | Optional | string18499 | in_uk_taxable_flag | S | sm_extension.inc | SECURITYDBO | SECMASTERSECURITY_DETAILMASTER_EXT | MSCIUK_COUNTRYTAXABLE_CODEFLAG | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/msciCountryCodeukTaxableFlag | ||||||||||
| typeOfBond | quoteUnitsstring | Optional | string18565 | in_type_of_bond | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | QUOTETYPE_OF_UNITSBOND | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/quoteUnitstypeOfBond |