...
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 | 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 | dateTime | 5433 | in_sec_ext_change_dt | S | sm_extension.inc | SECURITYDBO | SECURITY_MASTER_EXT | CHANGE_DT | DATE | EagleML/referenceTransaction/genericSMF/SMExtension/changeDate | |||||||||||
erisaFlag | string | 10523 | in_erisa_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ERISA_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/erisaFlag | |||||||||||
fixedIncomeIndustry | 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 | string | 1421 | in_prvt_place | S | sm_extension.inc | SECURITYDBO | SECURITY_MASTER | PRVT_PLACE | CHAR(2) | EagleML/referenceTransaction/genericSMF/SMExtension/prvtPlace | |||||||||||
modifiedBy | 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 | 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 | 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 | |||||||||||
wiFlag | string | 5440 | in_sec_ext_wi_flag | S | sm_extension.inc | SECURITYDBO | SECURITY_MASTER_EXT | WI_FLAG | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/SMExtension/wiFlag | |||||||||||
smSecurityType | string | 10175 | in_smde_security_type | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | SECURITY_TYPE | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/smSecurityType | |||||||||||
naicCode | string | 10194 | in_naic_code | S | sm_extension.inc | SECURITYDBO | FIXED_INCOME | NAIC_CODE | CHAR(8) | EagleML/referenceTransaction/genericSMF/SMExtension/naicCode | |||||||||||
naicDate | date | 5890 | in_naic_date | S | sm_extension.inc | SECURITYDBO | NAIC | naic_date | DATE | EagleML/referenceTransaction/genericSMF/SMExtension/naicDate | |||||||||||
naicSymbol | string | 5891 | in_naic_symbol | S | sm_extension.inc | SECURITYDBO | NAIC | naic_symbol | CHAR(15) | EagleML/referenceTransaction/genericSMF/SMExtension/naicSymbol | |||||||||||
naicSymbol2 | string | 5892 | in_naic_symbol2 | S | sm_extension.inc | SECURITYDBO | NAIC | naic_symbol2 | CHAR(15) | EagleML/referenceTransaction/genericSMF/SMExtension/naicSymbol2 | |||||||||||
naicSymbol3 | string | 5893 | in_naic_symbol3 | S | sm_extension.inc | SECURITYDBO | NAIC | naic_symbol3 | CHAR(15) | EagleML/referenceTransaction/genericSMF/SMExtension/naicSymbol3 | |||||||||||
naicMarketCode | string | 5856 | in_naic_market_code | S | sm_extension.inc | SECURITYDBO | NAIC | naic_market_code | CHAR(40) | EagleML/referenceTransaction/genericSMF/SMExtension/naicMarketCode | |||||||||||
naicRate | decimal | 5894 | in_naic_rate | N | sm_extension.inc | SECURITYDBO | NAIC | naic_rate | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/SMExtension/naicRate | |||||||||||
liquidity | string | 5434 | in_sec_ext_liquidity | S | sm_extension.inc | SECURITYDBO | SECURITY_MASTER_EXT | liquidity | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/SMExtension/liquidity | |||||||||||
pricingCusip | string | 5436 | in_sec_ext_pricing_cusip | S | sm_extension.inc | SECURITYDBO | SECURITY_MASTER_EXT | pricing_cusip | VARCHAR2(9) | EagleML/referenceTransaction/genericSMF/SMExtension/pricingCusip | |||||||||||
remicEligibleInd | 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 | 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 | |||||||||||
roundFlag | 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 | 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 | 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 | string | 5858 | in_group_code | S | sm_extension.inc | SECURITYDBO | NAIC | group_code | CHAR(4) | EagleML/referenceTransaction/genericSMF/SMExtension/groupCodeblpYellowKey | |||||||||||
| finalRateRoundingPrecision | stringinteger | 1019512402 | in_ | blp_yellow_keySsec_ext_final_rate_rnd_pr | N | sm_extension.inc | SECURITYDBO | SECMASTERSECURITY_ | DETAILMASTER_EXT | BLPFINAL_RATE_ | YELLOWROUND_ | KEYPREC | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/ | blpYellowKeyfinalRateRoundingPrecision | ||||||
| finalRateRoundingDirection | string | 1017912403 | in_sec_ | corpext_final_ | issuerrate_ | equityrnd_ | tickerdir | S | sm_extension.inc | SECURITYDBO | SECMASTERSECURITY_ | DETAILMASTER_EXT | CORPORATEFINAL_ | ISSUERRATE_ | EQUITYROUND_ | TICKERDIR | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/ | corpIssuerEquityTickerfinalRateRoundingDirection | ||
countryOfIssueblpYellowKey | string | 1019310195 | in_countryblp_ofyellow_issuekey | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | COUNTRYBLP_OFYELLOW_ISSUEKEY | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/countryOfIssueblpYellowKey | |||||||||||
desNotescorpIssuerEquityTicker | 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 | |||||||||||
dividendRightscountryOfIssue | 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 | string | 1009210105 | in_dtcdes_registerednotes | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | DTCDES_REGISTEREDNOTES | VARCHAR2(60100) | EagleML/referenceTransaction/genericSMF/SMExtension/dtcRegistereddesNotes | |||||||||||
industryGroupdividendRights | string | 1009910090 | in_industrydividend_grouprights | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INDUSTRYDIVIDEND_GROUPRIGHTS | VARCHAR2(6030) | EagleML/referenceTransaction/genericSMF/SMExtension/industryGroupdividendRights | |||||||||||
industrySectordtcRegistered | string | 1010010092 | in_industrydtc_sectorregistered | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INDUSTRYDTC_SECTORREGISTERED | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/industrySectordtcRegistered | |||||||||||
industrySubgroupindustryGroup | string | 1010110099 | in_industry_subgroupgroup | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INDUSTRY_SUBGROUPGROUP | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/industrySubgroupindustryGroup | |||||||||||
industrySubgroupNumberindustrySector | 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 | string | 1017810101 | in_issuerindustry_industrysubgroup | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ISSUERINDUSTRY_INDUSTRYSUBGROUP | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/issuerIndustryindustrySubgroup | |||||||||||
marketSectorDescriptionindustrySubgroupNumber | 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 | string | 1019410178 | in_smdeissuer_naic_codeindustry | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | NAICISSUER_CODEINDUSTRY | CHARVARCHAR2(860) | EagleML/referenceTransaction/genericSMF/SMExtension/smdeNaicCodeissuerIndustry | |||||||||||
parentCompanymarketSectorDescription | string | 1017610173 | in_parentmarket_sector_companydescription | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | PARENTMARKET_SECTOR_COMPANYDESCRIPTION | VARCHAR2(608) | EagleML/referenceTransaction/genericSMF/SMExtension/parentCompanymarketSectorDescription | |||||||||||
priceTypesmdeNaicCode | string | 1009610194 | in_pricesmde_naic_typecode | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | PRICENAIC_TYPECODE | VARCHAR2CHAR(608) | EagleML/referenceTransaction/genericSMF/SMExtension/priceTypesmdeNaicCode | |||||||||||
redenominationDateparentCompany | datestring | 1018010176 | in_redenominationparent_datecompany | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | REDENOMINATIONPARENT_DATEDATECOMPANY | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/redenominationDateparentCompany | |||||||||||
redenominationMethodpriceType | string | 1018910096 | in_redenominationprice_methodtype | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | REDENOMINATIONPRICE_METHODTYPE | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/redenominationMethodpriceType | |||||||||||
redenominationPriceredenominationDate | decimaldate | 1019110180 | in_redenomination_pricedate | NS | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | REDENOMINATION_PRICENUMBER(28,12)DATE | DATE | EagleML/referenceTransaction/genericSMF/SMExtension/redenominationPriceredenominationDate | |||||||||||
redenominationRoundMethodredenominationMethod | 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 | stringdecimal | 1020010191 | in_rmredenomination_industryprice | SN | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | RMREDENOMINATION_INDUSTRYPRICE | VARCHAR2NUMBER(6028,12) | EagleML/referenceTransaction/genericSMF/SMExtension/rmIndustryredenominationPrice | |||||||||||
shortNameredenominationRoundMethod | string | 1017710190 | in_redenomination_shortround_namemethod | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | SHORTREDENOMINATION_ROUND_NAMEMETHOD | VARCHAR2(3060) | EagleML/referenceTransaction/genericSMF/SMExtension/shortNameredenominationRoundMethod | |||||||||||
topixIndustryrmIndustry | string | 1020110200 | in_topixrm_industry | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | TOPIXRM_INDUSTRY | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/topixIndustryrmIndustry | |||||||||||
tradingStatusshortName | string | 1019210177 | in_tradingshort_statusname | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | TRADINGSHORT_STATUSNAME | VARCHAR2(6030) | EagleML/referenceTransaction/genericSMF/SMExtension/tradingStatusshortName | |||||||||||
warrantCurrencytopixIndustry | string | 1009410201 | in_warranttopix_currencyindustry | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | WARRANTTOPIX_CURRENCYINDUSTRY | VARCHAR2(3060) | EagleML/referenceTransaction/genericSMF/SMExtension/warrantCurrencytopixIndustry | |||||||||||
warrantNametradingStatus | string | 1009810192 | in_warranttrading_namestatus | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | WARRANTTRADING_NAMESTATUS | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/warrantNametradingStatus | |||||||||||
warrantTickerwarrantCurrency | string | 1009710094 | in_warrant_tickercurrency | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | WARRANT_TICKERCURRENCY | VARCHAR2(6030) | EagleML/referenceTransaction/genericSMF/SMExtension/warrantTickerwarrantCurrency | |||||||||||
warrantUnderlyingCurrencywarrantName | 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 | 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 | 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 | 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 | string | 1052410526 | in_fifeccash_equiv_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | FIFECCASH_EQUIV_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/fifecFlagcashEquivFlag | |||||||||||
fundAdminFlagcommercialPaperFlag | 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 | 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 | 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 | 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 | string | 1052710532 | in_suprainternal_manage_nationalflag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | SUPRAINTERNAL_MANAGE_NATIONALFLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/supraNationalinternalManageFlag | |||||||||||
tia1961FlagnewIssueFlag | string | 1053510533 | in_tianew_1961issue_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | TIANEW_1961ISSUE_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/tia1961FlagnewIssueFlag | |||||||||||
ucitsFlagsupraNational | string | 1052910527 | in_ucitssupra_flagnational | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | UCITSSUPRA_FLAGNATIONAL | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/ucitsFlagsupraNational | |||||||||||
unsecuredFlagtia1961Flag | 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 | integerstring | 1236410529 | in_industryucits_subgroup_numflag | NS | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXTINDUSTRY | UCITS_SUBGROUP_NUMFLAG | NUMBERVARCHAR2(383) | EagleML/referenceTransaction/genericSMF/SMExtension/industrySubgroupNumucitsFlag | |||||||||||
sedol1CountryIsounsecuredFlag | 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 | stringinteger | 1236612364 | in_sedol2industry_countrysubgroup_isonum | SN | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | SEDOL2INDUSTRY_COUNTRYSUBGROUP_ISONUM | VARCHAR2NUMBER(3038) | EagleML/referenceTransaction/genericSMF/SMExtension/sedol2CountryIsoindustrySubgroupNum | |||||||||||
preRedenomCrncysedol1CountryIso | 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 | decimalstring | 1236812366 | 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 | |||||||||||
postRedenomCrncypreRedenomCrncy | 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 | 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 | |||||||||||
lseSectorpostRedenomCrncy | string | 1237112369 | in_lsepost_redenom_sectorcrncy | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | LSEPOST_REDENOM_SECTORCRNCY | VARCHAR2(180) | EagleML/referenceTransaction/genericSMF/SMExtension/lseSectorpostRedenomCrncy | |||||||||||
lseSegmentpostEuroParAmt | stringdecimal | 1237212370 | 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 | string | 1237312371 | in_icblse_sector_name | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ICBLSE_SECTOR_NAME | VARCHAR2(180) | EagleML/referenceTransaction/genericSMF/SMExtension/icbSectorNamelseSector | |||||||||||
icbSectorlseSegment | string | 1237412372 | in_icblse_sectorsegment | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ICBLSE_SECTORSEGMENT | VARCHAR2(20180) | EagleML/referenceTransaction/genericSMF/SMExtension/icbSectorlseSegment | |||||||||||
icbSubsectorNameicbSectorName | 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 | string | 1237612374 | in_icb_subsectorsector | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ICB_SUBSECTORSECTOR | VARCHAR2(20) | EagleML/referenceTransaction/genericSMF/SMExtension/icbSubsectoricbSector | |||||||||||
icbSupersectorNameicbSubsectorName | 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 | string | 1237812376 | in_icb_supersectorsubsector | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ICB_SUPERSECTORSUBSECTOR | VARCHAR2(20) | EagleML/referenceTransaction/genericSMF/SMExtension/icbSupersectoricbSubsector | |||||||||||
icbIndustryNameicbSupersectorName | 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 | string | 1238012378 | in_icb_industrysupersector | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ICB_INDUSTRYSUPERSECTOR | VARCHAR2(20) | EagleML/referenceTransaction/genericSMF/SMExtension/icbIndustryicbSupersector | |||||||||||
idBbConnecticbIndustryName | integerstring | 1238112379 | in_idicb_bbindustry_connectname | NS | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | IDICB_BBINDUSTRY_CONNECTNAME | NUMBERVARCHAR2(38180) | EagleML/referenceTransaction/genericSMF/SMExtension/idBbConnecticbIndustryName | |||||||||||
parentCompTickericbIndustry | 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 | stringinteger | 250412381 | in_aggid_bondbb_l1connect | SN | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | aggID_bondBB_l1CONNECT | VARCHAR2NUMBER(6038) | EagleML/referenceTransaction/genericSMF/SMExtension/aggBondL1idBbConnect | |||||||||||
aggBondL2parentCompTicker | string | 250512382 | in_aggparent_bondcomp_l2ticker | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | aggPARENT_bondCOMP_l2TICKER | VARCHAR2(60180) | EagleML/referenceTransaction/genericSMF/SMExtension/aggBondL2parentCompTicker | |||||||||||
aggBondL3aggBondL1 | 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 | string | 25072505 | in_agg_bond_l4l2 | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | agg_bond_l4l2 | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/aggBondL4aggBondL2 | |||||||||||
redCodeaggBondL3 | string | 25172506 | in_agg_redbond_codel3 | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | redagg_bond_codel3 | VARCHAR2(2560) | EagleML/referenceTransaction/genericSMF/SMExtension/redCodeaggBondL3 | |||||||||||
contingentConvertibleaggBondL4 | string16835 | 2507 | in_agg_bond_l4 | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | CONTINGENTagg_bond_CONVERTIBLEl4 | VARCHAR2(160) | EagleML/referenceTransaction/genericSMF/SMExtension/contingentConvertibleaggBondL4 | |||||||||||
redCode | 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 | 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 | 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 | integer | 16971 | Nstring | 16969 | in_associated_variable_cusip | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INDUSTRYASSOCIATED_SECTOR_NUMVARIABLE_CUSIP | VARCHAR2(50) | EagleML/referenceTransaction/genericSMF/SMExtension/industrySectorNumberassociatedVariableCusip | |||||||||
| isSubordinatedbloombergSectorCode | 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 | integer | 1697316971 | in_industry_sector_num | N | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | LIQUIDITYINDUSTRY_PROVIDER_IDSECTOR_NUM | NUMBER(38,0) | EagleML/referenceTransaction/genericSMF/SMExtension/liquidityProviderIdindustrySectorNumber | |||||||||||
| adrSponsorTypeisSubordinated | string | 16972 | in_is_subordinated | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXTADR | IS_SPONSOR_TYPESUBORDINATED | VARCHAR2(4) | EagleML/referenceTransaction/genericSMF/SMExtension/adrSponsorType | fundDistributor | string | SisSubordinated | ||||||||
| liquidityProviderId | integer | 16973 | in_liquidity_provider_id | N | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | FUNDLIQUIDITY_PROVIDER_DISTRIBUTORID | VARCHAR2NUMBER(3038,0) | EagleML/referenceTransaction/genericSMF/SMExtension/fundDistributorliquidityProviderId | |||||||||||
| indexFrequencyadrSponsorType | string | 17414 | in_adr_sponsor_type | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INDEXADR_SPONSOR_FREQUENCYTYPE | VARCHAR2(84) | EagleML/referenceTransaction/genericSMF/SMExtension/indexFrequencyadrSponsorType | |||||||||||
| fundGeoFocusfundDistributor | string | 1622517415 | in_fund_geo_focus | S | in_fund_mgmt_styledistributor | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_DISTRIBUTOR | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/fundDistributor | |||||||||
| indexFrequency | string | 17416 | in_index_frequency | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INDEX_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_EXTFUND_GEO_FOCUS | CAP_CONT_TRIG_LEVEL | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/SMExtension/fundGeoFocusccontingentCapitalTriggerLevel | |||||||||||
| fundManagementStylecontingentCapitalPriceLevelType | stringnormalizedString | 1622518308 | in_cap_fundcont_mgmtprice_stylelevel | Sin | _fund_mgmt_stylesm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXTFUND | CAP_CONT_MGMT_STYLEPRICE_LEVEL | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/fundManagementStyle | aifmdFlag | stringcontingentCapitalPriceLevelType | |||||||||
| contingentCapitalFloorLevelType | normalizedString | 18309 | in_cap_cont_floor_level | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXTAIFMD_ | FLAGCAP_CONT_FLOOR_LEVEL | VARCHAR2(30255) | EagleML/referenceTransaction/genericSMF/SMExtension/aifmdFlag | exchangeCode | stringcontingentCapitalFloorLevelType | |||||||||
| guarantorType | normalizedString | 18312 | in_guarantor_type | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | EXCHGUARANTOR_CODETYPE | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/exchangeCode | exchangeMarketStatus | stringguarantorType | |||||||||
| tier1CapitalIndicator | YesNoOptionEnum | 18315 | in_tier1_capital | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXTEXCHANGE | TIER1_MARKET_STATUSCAPITAL | VARCHAR2(20255) | EagleML/referenceTransaction/genericSMF/SMExtension/exchangeMarketStatus | fundRedemptionFrequency | stringtier1CapitalIndicator | |||||||||
| tier2CapitalIndicator | YesNoOptionEnum | 18316 | in_tier1_capital | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXTFUND | TIER2_REDEMPTION_FREQCAPITAL | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/fundRedemptionFrequency | fundType | stringtier2CapitalIndicator | |||||||||
| fundShareClass | normalizedString | 18318 | in_fund_share_class | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_TYPESHARE_CLASS | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/fundType | inflationLinkedFlag | stringfundShareClass | |||||||||
| privateFundIndicator | YesNoOptionEnum | 18373 | in_private_fund | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXTINFLATION | PRIVATE_LINKED_FLAGFUND | VARCHAR2(30255) | EagleML/referenceTransaction/genericSMF/SMExtension/inflationLinkedFlag | msciCountryCode | stringprivateFundIndicator | |||||||||
| ukTaxableFlag | YesNoOptionEnum | 18499 | in_uk_taxable_flag | S | sm_extension.inc | SECURITYDBO | SECMASTERSECURITY_DETAILMASTER_EXT | MSCIUK_COUNTRYTAXABLE_CODEFLAG | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/msciCountryCodeukTaxableFlag | |||||||||||
| quoteUnitstypeOfBond | string | 18565 | in_type_of_bond | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | QUOTETYPE_OF_UNITSBOND | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/quoteUnitstypeOfBond |