...
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 | |
erisaFlag | Optional | string | 10523 | in_erisa_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ERISA_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/erisaFlag | |
fixedIncomeIndustryOptional | string | 10202 | in_fixed_income_industry | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | FIXED_INCOME_INDUSTRY | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/fixedIncomeIndustry | ||
prvtPlaceOptional | 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 | |
naicDate | Optional | 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 | ||
naicSymbol2Optional | 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 | |
liquidityOptional | 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 | ||
remicEligibleInd | Optional | 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 | ||
assetBenchmarkOptional | 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/groupCode | |
blpYellowKey | Optional | string | 10195 | in_blp_yellow_key | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | BLP_YELLOW_KEY | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/blpYellowKey | |
corpIssuerEquityTickerOptional | string | 10179 | in_corp_issuer_equity_ticker | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | CORPORATE_ISSUER_EQUITY_TICKER | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/corpIssuerEquityTicker | ||
countryOfIssueOptional | string | 10193 | in_country_of_issue | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | COUNTRY_OF_ISSUE | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/countryOfIssue | ||
desNotes | Optional | string | 10105 | in_des_notes | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | DES_NOTES | VARCHAR2(100) | EagleML/referenceTransaction/genericSMF/SMExtension/desNotes | |
dividendRights | Optional | string | 10090 | in_dividend_rights | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | DIVIDEND_RIGHTS | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/dividendRights | |
dtcRegisteredOptional | string | 10092 | in_dtc_registered | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | DTC_REGISTERED | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/dtcRegistered | ||
industryGroupOptional | string | 10099 | in_industry_group | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INDUSTRY_GROUP | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/industryGroup | ||
industrySector | Optional | string | 10100 | in_industry_sector | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INDUSTRY_SECTOR | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/industrySector | |
industrySubgroup | Optional | string | 10101 | in_industry_subgroup | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INDUSTRY_SUBGROUP | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/industrySubgroup | |
industrySubgroupNumber | Optional | string | 10102 | in_industry_subgroup_number | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INDUSTRY_SUBGROUP_NUMBER | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/industrySubgroupNumber | |
issuerIndustryOptional | string | 10178 | in_issuer_industry | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ISSUER_INDUSTRY | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/issuerIndustry | ||
marketSectorDescription | Optional | string | 10173 | in_market_sector_description | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | MARKET_SECTOR_DESCRIPTION | VARCHAR2(8) | EagleML/referenceTransaction/genericSMF/SMExtension/marketSectorDescription | |
smdeNaicCode | Optional | string | 10194 | in_smde_naic_code | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | NAIC_CODE | CHAR(8) | EagleML/referenceTransaction/genericSMF/SMExtension/smdeNaicCode | |
parentCompany | Optional | string | 10176 | in_parent_company | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | PARENT_COMPANY | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/parentCompany | |
priceTypeOptional | string | 10096 | in_price_type | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | PRICE_TYPE | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/priceType | ||
redenominationDateOptional | date | 10180 | in_redenomination_date | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | REDENOMINATION_DATE | DATE | EagleML/referenceTransaction/genericSMF/SMExtension/redenominationDate | ||
redenominationMethod | Optional | string | 10189 | in_redenomination_method | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | REDENOMINATION_METHOD | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/redenominationMethod | |
redenominationPrice | Optional | decimal | 10191 | in_redenomination_price | N | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | REDENOMINATION_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/genericSMF/SMExtension/redenominationPrice | |
redenominationRoundMethod | Optional | string | 10190 | in_redenomination_round_method | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | REDENOMINATION_ROUND_METHOD | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/redenominationRoundMethod | |
rmIndustryOptional | string | 10200 | in_rm_industry | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | RM_INDUSTRY | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/rmIndustry | ||
shortNameOptional | string | 10177 | in_short_name | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | SHORT_NAME | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/shortName | ||
topixIndustry | Optional | string | 10201 | in_topix_industry | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | TOPIX_INDUSTRY | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/topixIndustry | |
tradingStatus | Optional | string | 10192 | in_trading_status | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | TRADING_STATUS | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/tradingStatus | |
warrantCurrencyOptional | string | 10094 | in_warrant_currency | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | WARRANT_CURRENCY | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/warrantCurrency | ||
warrantNameOptional | string | 10098 | in_warrant_name | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | WARRANT_NAME | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/warrantName | ||
warrantTicker | Optional | string | 10097 | in_warrant_ticker | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | WARRANT_TICKER | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/warrantTicker | |
warrantUnderlyingCurrency | Optional | string | 10095 | in_warrant_underlying_currency | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | WARRANT_UNDERLYING_CURRENCY | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/warrantUnderlyingCurrency | |
warrantUnderlyingCusip | Optional | string | 10093 | in_warrant_underlying_cusip | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | WARRANT_UNDERLYING_CUSIP | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/warrantUnderlyingCusip | |
cashEquivFlagOptional | string | 10526 | in_cash_equiv_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | CASH_EQUIV_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/cashEquivFlag | ||
commercialPaperFlagOptional | string | 10525 | in_commercial_paper_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | COMMERCIAL_PAPER_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/commercialPaperFlag | ||
fifecFlag | Optional | string | 10524 | in_fifec_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | FIFEC_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/fifecFlag | |
fundAdminFlag | Optional | string | 10534 | in_fund_admin_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_ADMIN_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/fundAdminFlag | |
initialChrgRebateFlagOptional | string | 10531 | in_initial_chrg_rebate_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INITIAL_CHRG_REBATE_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/initialChrgRebateFlag | ||
internalManageFlagOptional | string | 10532 | in_internal_manage_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INTERNAL_MANAGE_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/internalManageFlag | ||
newIssueFlag | Optional | string | 10533 | in_new_issue_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | NEW_ISSUE_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/newIssueFlag | |
supraNational | Optional | string | 10527 | in_supra_national | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | SUPRA_NATIONAL | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/supraNational | |
tia1961Flag | Optional | string | 10535 | in_tia_1961_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | TIA_1961_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/tia1961Flag | |
ucitsFlagOptional | string | 10529 | in_ucits_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | UCITS_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/ucitsFlag | ||
unsecuredFlagOptional | string | 10530 | in_unsecured_flag | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | UNSECURED_FLAG | VARCHAR2(3) | EagleML/referenceTransaction/genericSMF/SMExtension/unsecuredFlag | ||
industrySubgroupNum | Optional | integer | 12364 | in_industry_subgroup_num | N | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INDUSTRY_SUBGROUP_NUM | NUMBER(38) | EagleML/referenceTransaction/genericSMF/SMExtension/industrySubgroupNum | |
sedol1CountryIso | Optional | string | 12365 | in_sedol1_country_iso | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | SEDOL1_COUNTRY_ISO | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/sedol1CountryIso | |
sedol2CountryIsoOptional | string | 12366 | in_sedol2_country_iso | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | SEDOL2_COUNTRY_ISO | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/sedol2CountryIso | ||
preRedenomCrncyOptional | string | 12367 | in_pre_redenom_crncy | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | PRE_REDENOM_CRNCY | VARCHAR2(180) | EagleML/referenceTransaction/genericSMF/SMExtension/preRedenomCrncy | ||
preEuroParAmt | Optional | decimal | 12368 | in_pre_euro_par_amt | N | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | PRE_EURO_PAR_AMT | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/SMExtension/preEuroParAmt | |
postRedenomCrncy | Optional | string | 12369 | in_post_redenom_crncy | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | POST_REDENOM_CRNCY | VARCHAR2(180) | EagleML/referenceTransaction/genericSMF/SMExtension/postRedenomCrncy | |
postEuroParAmt | Optional | decimal | 12370 | in_post_euro_par_amt | N | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | POST_EURO_PAR_AMT | NUMBER(38,12) | EagleML/referenceTransaction/genericSMF/SMExtension/postEuroParAmt | |
lseSectorOptional | string | 12371 | in_lse_sector | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | LSE_SECTOR | VARCHAR2(180) | EagleML/referenceTransaction/genericSMF/SMExtension/lseSector | ||
lseSegmentOptional | string | 12372 | in_lse_segment | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | LSE_SEGMENT | VARCHAR2(180) | EagleML/referenceTransaction/genericSMF/SMExtension/lseSegment | ||
icbSectorName | Optional | string | 12373 | in_icb_sector_name | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ICB_SECTOR_NAME | VARCHAR2(180) | EagleML/referenceTransaction/genericSMF/SMExtension/icbSectorName | |
icbSector | Optional | string | 12374 | in_icb_sector | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ICB_SECTOR | VARCHAR2(20) | EagleML/referenceTransaction/genericSMF/SMExtension/icbSector | |
icbSubsectorNameOptional | string | 12375 | in_icb_subsector_name | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ICB_SUBSECTOR_NAME | VARCHAR2(180) | EagleML/referenceTransaction/genericSMF/SMExtension/icbSubsectorName | ||
icbSubsectorOptional | string | 12376 | in_icb_subsector | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ICB_SUBSECTOR | VARCHAR2(20) | EagleML/referenceTransaction/genericSMF/SMExtension/icbSubsector | ||
icbSupersectorName | Optional | string | 12377 | in_icb_supersector_name | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ICB_SUPERSECTOR_NAME | VARCHAR2(180) | EagleML/referenceTransaction/genericSMF/SMExtension/icbSupersectorName | |
icbSupersector | Optional | string | 12378 | in_icb_supersector | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ICB_SUPERSECTOR | VARCHAR2(20) | EagleML/referenceTransaction/genericSMF/SMExtension/icbSupersector | |
icbIndustryName | Optional | string | 12379 | in_icb_industry_name | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ICB_INDUSTRY_NAME | VARCHAR2(180) | EagleML/referenceTransaction/genericSMF/SMExtension/icbIndustryName | |
icbIndustryOptional | string | 12380 | in_icb_industry | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ICB_INDUSTRY | VARCHAR2(20) | EagleML/referenceTransaction/genericSMF/SMExtension/icbIndustry | ||
idBbConnectOptional | integer | 12381 | in_id_bb_connect | N | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ID_BB_CONNECT | NUMBER(38) | EagleML/referenceTransaction/genericSMF/SMExtension/idBbConnect | ||
parentCompTicker | Optional | string | 12382 | in_parent_comp_ticker | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | PARENT_COMP_TICKER | VARCHAR2(180) | EagleML/referenceTransaction/genericSMF/SMExtension/parentCompTicker | |
aggBondL1 | Optional | string | 2504 | in_agg_bond_l1 | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | agg_bond_l1 | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/aggBondL1 | |
aggBondL2Optional | string | 2505 | in_agg_bond_l2 | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | agg_bond_l2 | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/aggBondL2 | ||
aggBondL3Optional | string | 2506 | in_agg_bond_l3 | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | agg_bond_l3 | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/aggBondL3 | ||
aggBondL4 | Optional | string | 2507 | in_agg_bond_l4 | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | agg_bond_l4 | VARCHAR2(60) | EagleML/referenceTransaction/genericSMF/SMExtension/aggBondL4 | |
redCode | Optional | string | 2517 | in_red_code | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | red_code | VARCHAR2(25) | EagleML/referenceTransaction/genericSMF/SMExtension/redCode | |
contingentConvertible | Optional | string | 16835 | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | CONTINGENT_CONVERTIBLE | VARCHAR2(1) | EagleML/referenceTransaction/genericSMF/SMExtension/contingentConvertible | ||
arsAuctionStatusOptional | string | 16968 | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ARS_AUCTION_STATUS | EagleML/referenceTransaction/genericSMF/SMExtension/arsAuctionStatus | ||||
associatedVariableCusipOptional | string | 16969 | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ASSOCIATED_VARIABLE_CUSIP | EagleML/referenceTransaction/genericSMF/SMExtension/associatedVariableCusip | ||||
bloombergSectorCode | Optional | string | 16970 | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | BLOOMBERG_SECTOR_CODE | EagleML/referenceTransaction/genericSMF/SMExtension/bloombergSectorCode | |||
industrySectorNumber | Optional | integer | 16971 | N | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INDUSTRY_SECTOR_NUM | EagleML/referenceTransaction/genericSMF/SMExtension/industrySectorNumber | |||
isSubordinatedOptional | string | 16972 | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | IS_SUBORDINATED | EagleML/referenceTransaction/genericSMF/SMExtension/isSubordinated | ||||
liquidityProviderIdOptional | integer | 16973 | N | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | LIQUIDITY_PROVIDER_ID | EagleML/referenceTransaction/genericSMF/SMExtension/liquidityProviderId | ||||
adrSponsorType | Optional | string | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | ADR_SPONSOR_TYPE | VARCHAR2(4) | EagleML/referenceTransaction/genericSMF/SMExtension/adrSponsorType | |||
fundDistributor | Optional | string | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_DISTRIBUTOR | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/fundDistributor | |||
indexFrequency | Optional | string | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INDEX_FREQUENCY | VARCHAR2(8) | EagleML/referenceTransaction/genericSMF/SMExtension/indexFrequency | |||
fundGeoFocusOptional | string | 16225 | in_fund_geo_focus | S | in_fund_mgmt_style | SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_GEO_FOCUS | EagleML/referenceTransaction/genericSMF/SMExtension/fundGeoFocusc | |||
fundManagementStyleOptional | string | 16225 | in_fund_mgmt_style | S | in_fund_mgmt_style | SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_MGMT_STYLE | EagleML/referenceTransaction/genericSMF/SMExtension/fundManagementStyle | |||
aifmdFlag | Optional | string | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | AIFMD_FLAG | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/aifmdFlag | |||
exchangeCode | Optional | string | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | EXCH_CODE | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/exchangeCode | |||
exchangeMarketStatusOptional | string | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | EXCHANGE_MARKET_STATUS | VARCHAR2(20) | EagleML/referenceTransaction/genericSMF/SMExtension/exchangeMarketStatus | ||||
fundRedemptionFrequencyOptional | string | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_REDEMPTION_FREQ | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/fundRedemptionFrequency | ||||
fundType | Optional | string | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | FUND_TYPE | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/fundType | |||
inflationLinkedFlag | Optional | string | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | INFLATION_LINKED_FLAG | VARCHAR2(30) | EagleML/referenceTransaction/genericSMF/SMExtension/inflationLinkedFlag | |||
msciCountryCode | Optional | string | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | MSCI_COUNTRY_CODE | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/msciCountryCode | |||
quoteUnitsOptional | string | S | sm_extension.inc | SECURITYDBO | SECMASTER_DETAIL_EXT | QUOTE_UNITS | VARCHAR2(255) | EagleML/referenceTransaction/genericSMF/SMExtension/quoteUnits |
...