RTR |
investmentType |
| StringWithCodeScheme | SECURITYDBO | SECURITY_MASTER | INVESTMENT_TYPE | CHAR(4) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/investmentType |
processingSecurityType |
| StringWithCodeScheme | SECURITYDBO | SECURITY_MASTER | PROCESS_SEC_TYPE | VARCHAR2(15) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/processingSecurityType |
securityType |
| string | SECURITYDBO | SECURITY_MASTER | SECURITY_TYPE | CHAR(15) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/securityType |
releaseStatus |
| string | SECURITYDBO | SECURITY_MASTER | RELEASE_STATUS | CHAR(1) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/releaseStatus |
issueCountryCode |
| CountryCode | SECURITYDBO | SECURITY_MASTER | NRA_TAX_COUNTRY | CHAR(30) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/issueCountryCode |
smSettlementCurrency |
| CurrencyCode | SECURITYDBO | SECURITY_MASTER | SETTLEMENT_CURRENCY | CHAR(3) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/smSettlementCurrency |
smSecurityType |
| string | SECURITYDBO | SECMASTER_DETAIL_EXT | SECURITY_TYPE | VARCHAR2(60) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/smSecurityType |
securityType2 |
| string | SECURITYDBO | SECMASTER_DETAIL_EXT | SECURITY_TYPE2 | VARCHAR2(30) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/securityType2 |
securitySubType |
| string | SECURITYDBO | SECURITY_MASTER_DETAIL | ALT_SECURITY_TYPE | CHAR(15) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/securitySubType |
quantityScale |
| decimal | SECURITYDBO | SECURITY_MASTER | TRADING_UNIT | NUMBER(28,12) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/quantityScale |
redemptionCurrency |
| string | SECURITYDBO | SECURITY_MASTER | REDEMPTION_CURRENCY | CHAR(3) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/redemptionCurrency |
contractSize |
| decimal | SECURITYDBO | SECURITY_MASTER_DETAIL | CONTRACTSIZE | NUMBER(28,12) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/contractSize |
strikePrice |
| decimal | SECURITYDBO | DERIVATIVES | STRIKE_PRICE | NUMBER(28,12) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/strikePrice |
underlyingSecurity |
| string | SECURITYDBO | DERIVATIVES | UNDERLYING_SECURITY | VARCHAR2(255) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/underlyingSecurity |
underlyingSecAlias |
| integer | SECURITYDBO | DERIVATIVES | UNDERLYING_SEC_ALIAS | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/underlyingSecAlias |
underlyingType |
| string | SECURITYDBO | UNDERLYING_SECURITY | UNDERLYING_TYPE | VARCHAR2(100) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/underlyingType |
nextCouponDate |
| date | SECURITYDBO | FIXED_INCOME | NEXT_COUPON_DATE | DATE | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/nextCouponDate |
paymentFrequency |
| string | SECURITYDBO | FIXED_INCOME | PAYMENT_FREQ | CHAR(6) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/paymentFrequency |
investmentDescription |
| Description | SECURITYDBO | SECMASTER_DETAIL_EXT | SECURITY_DESCRIPTION | VARCHAR2(60) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/investmentDescription |
issuePrice |
| decimal | SECURITYDBO | FIXED_INCOME | ISSUE_PRICE | NUMBER(28,12) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/issuePrice |
issueCountry |
| string | SECURITYDBO | EQUITY | ISSUE_COUNTRY | CHAR(3) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/issueCountry |
To add the elements highlighted below, please set IncludeExtendedDetails=ALL in the RTR |
offset |
| decimal | SECURITYDBO | DERIVATIVES | OFFSET | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/offset |
optiondescr |
| string | SECURITYDBO | DERIVATIVES | OPTIONDESCR | VARCHAR2(10) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/optiondescr |
premiumType |
| string | SECURITYDBO | DERIVATIVES | PREMIUM_TYPE | CHAR(2) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/premiumType |
putCallFlag |
| string | SECURITYDBO | DERIVATIVES | PUT_CALL_FLAG | CHAR(4) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/putCallFlag |
indicatedAnnualDividend |
| decimal | SECURITYDBO | EQUITY | ANNUAL_DIVIDEND | NUMBER(28,12) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/indicatedAnnualDividend |
drdFlag |
| string | SECURITYDBO | EQUITY | DRD_FLAG | VARCHAR2 (1) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/drdFlag |
qdiEligibleFlag |
| string | SECURITYDBO | EQUITY | QDI_ELIGIBLE_FLAG | VARCHAR2 (1) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/qdiEligibleFlag |
sharesOutstanding |
| decimal | SECURITYDBO | EQUITY | SHARES_OUTSTANDING | NUMBER(28,12) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/sharesOutstanding |
sicCode |
| string | SECURITYDBO | EQUITY_DETAIL | SIC_NAME | VARCHAR2(60) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/sicCode |
interestPaymentTiming |
| string | SECURITYDBO | FIXED_INCOME | ACCRUAL_METHOD | CHAR(4) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/interestPaymentTiming |
callIndicator |
| string | SECURITYDBO | FIXED_INCOME | CALLABLE | CHAR(2) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/callIndicator |
putIndicator |
| string | SECURITYDBO | FIXED_INCOME | PUTTABLE | CHAR(2) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/putIndicator |
datedDate |
| date | SECURITYDBO | FIXED_INCOME | DATED_DATE | DATE | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/datedDate |
demandFeature |
| string | SECURITYDBO | FIXED_INCOME | DEMAND_FEATURE | VARCHAR2(3) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/demandFeature |
uSFederalTaxIndicator |
| string | SECURITYDBO | FIXED_INCOME | FEDERAL_TAX_INDICATOR | CHAR(2) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/uSFederalTaxIndicator |
businessDayConvention |
| string | SECURITYDBO | FIXED_INCOME | INTEREST_METHOD_CODE | CHAR(10) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/businessDayConvention |
minimumPiece |
| decimal | SECURITYDBO | FIXED_INCOME | MINIMUM_PIECE | NUMBER(28,12) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/minimumPiece |
sinkFundIndicator |
| string | SECURITYDBO | FIXED_INCOME | SINK_FUND | CHAR(2) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/sinkFundIndicator |
varRateFreqCode |
| string | SECURITYDBO | FIXED_INCOME | VAR_RATE_FREQ_CODE | CHAR(4) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/varRateFreqCode |
marketIssue |
| string | SECURITYDBO | FIXED_INCOME_DETAIL_EXT | MARKET_ISSUE | VARCHAR2(30) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/marketIssue |
gicsSector |
| string | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_SECTOR | VARCHAR2(60) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/gicsSector |
gicsSectorName |
| string | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_SECTOR_NAME |
| EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/gicsSectorName |
gicsIndustryGroup |
| string | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_INDUSTRY_GROUP | VARCHAR2(60) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/gicsIndustryGroup |
gicsIndustryGroupName |
| string | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_INDUSTRY_GROUP_NAME | VARCHAR2(60) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/gicsIndustryGroupName |
gicsIndustry |
| string | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_INDUSTRY | VARCHAR2(60) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/gicsIndustry |
gicsIndustryName |
| string | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_INDUSTRY_NAME | VARCHAR2(60) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/gicsIndustryName |
gicsSubIndustry |
| string | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_SUB_INDUSTRY | VARCHAR2(60) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/gicsSubIndustry |
gicsSubIndustryName |
| string | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_SUB_INDUSTRY_NAME | VARCHAR2(60) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/gicsSubIndustryName |
gicsOverrideIndustry |
| string | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_OVERRIDE_INDUSTRY | VARCHAR2(60) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/gicsOverrideIndustry |
gicsOverrideIndustryGrp |
| string | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_OVERRIDE_INDUSTRY_GROUP | VARCHAR2(60) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/gicsOverrideIndustryGrp |
gicsOverrideSector |
| string | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_OVERRIDE_SECTOR | VARCHAR2(60) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/gicsOverrideSector |
gicsOverrideSubIndustry |
| string | SECURITYDBO | SECMASTER_DETAIL_EXT | GICS_OVERRIDE_SUB_INDUSTRY | VARCHAR2 (60) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/gicsOverrideSubIndustry |
marketSectorDescription |
| string | SECURITYDBO | SECMASTER_DETAIL_EXT | MARKET_SECTOR_DESCRIPTION | VARCHAR2(8) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/marketSectorDescription |
couponDayOfMonth |
| decimal | SECURITYDBO | SECURITY_MASTER | COUPON_DAY_OF_MONTH | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/couponDayOfMonth |
paymentFrequencyCode |
| string | SECURITYDBO | SECURITY_MASTER | COUPON_FREQ_CODE | CHAR(8) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/paymentFrequencyCode |
dayCountBasis |
| string | SECURITYDBO | SECURITY_MASTER | DAY_CNT | CHAR(20) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/dayCountBasis |
restrictedIndicator |
| string | SECURITYDBO | SECURITY_MASTER | LIQUID_FLAG | CHAR(2) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/restrictedIndicator |
oIDIndicator |
| string | SECURITYDBO | SECURITY_MASTER | OID_BOND | CHAR(2) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/oIDIndicator |
quantityType |
| string | SECURITYDBO | SECURITY_MASTER | QUANTITY_TYPE | CHAR(12) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/quantityType |
_144AEligibleIndicator |
| string | SECURITYDBO | SECURITY_MASTER | SEC_144A_FLAG | CHAR(2) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/_144AEligibleIndicator |
securityMinorType |
| string | SECURITYDBO | SECURITY_MASTER | SECURITY_MINOR_TYPE | CHAR(4) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/securityMinorType |
businessCalendarName |
| string | SECURITYDBO | SECURITY_MASTER_DETAIL | BUSINESSDAY | VARCHAR2(10) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/businessCalendarName |
countryOfRiskCode |
| string | SECURITYDBO | SECURITY_MASTER_DETAIL | COUNTRY_OF_RISK | VARCHAR2(20) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/countryOfRiskCode |
region |
| string | SECURITYDBO | SECURITY_MASTER_DETAIL | REGION | VARCHAR2(50) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/region |
riskClassificationType |
| string | SECURITYDBO | SECURITY_MASTER_DETAIL | RISK_CLASSIFICATION_TYPE | CHAR | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/riskClassificationType |
userGroupChar1 |
| string | SECURITYDBO | SECURITY_MASTER_DETAIL | USER_GROUP_CHAR1 | VARCHAR2(60) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/userGroupChar1 |
notionalResetType |
| string | SECURITYDBO | SWAPS | NOTIONAL_RESET_TYPE | VARCHAR2(10) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/notionalResetType |
payRecIndicator |
| string | SECURITYDBO | SWAPS | PAY_RECEIVE_IND | VARCHAR2(10) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/payRecIndicator |
smStateCode |
| string | SECURITYDBO | FIXED_INCOME | STATE_CODE | CHAR(2) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/smStateCode |
smDefaultIndicator |
| string | SECURITYDBO | SECURITY_MASTER | DEFAULT_FLAG | CHAR(2) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/smDefaultIndicator |
smPoolNumber |
| string | SECURITYDBO | SECURITY_MASTER | POOL_NUMBER | CHAR(12) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/smPoolNumber |
fwdBrokerCode |
| string | SECURITYDBO | SECURITY_MASTER_DETAIL | FWD_BROKER_CODE |
| EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/fwdBrokerCode |
issueDate |
| date | SECURITYDBO | FIXED_INCOME | ISSUE_DATE |
| EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/issueDate |
firstIncomeDate |
| date | SECURITYDBO | FIXED_INCOME | FIRST_INCOME_DATE |
| EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/firstIncomeDate |
lastIncomeDate |
| date | SECURITYDBO | FIXED_INCOME | LAST_INCOME_DATE |
| EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/lastIncomeDate |
smDefaultDate |
| date | SECURITYDBO | FIXED_INCOME | DEFAULT_DATE |
| EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/smDefaultDate |
prvtPlace |
| string | SECURITYDBO | SECURITY_MASTER | PRVT_PLACE |
| EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/prvtPlace |
clearedSecurity |
| string | SECURITYDBO | DERIVATIVES | CLEARED_SECURITY |
| EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/clearedSecurity |
countryOfIssue |
| string | SECURITYDBO | SECMASTER_DETAIL_EXT | COUNTRY_OF_ISSUE |
| EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/countryOfIssue |
incomeCurrency |
| CurrencyCode | SECURITYDBO | SECURITY_MASTER | INCOME_CURRENCY |
| EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/incomeCurrency |
smMinorInd |
| string | SECURITYDBO | SECURITY_MASTER | MINOR_IND |
| EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/smMinorInd |
muniIssuerDes2ndLine |
| string | SECURITYDBO | MUNI | MUNI_ISSUER_DES_2ND_LINE |
| EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/muniIssuerDes2ndLine |
muniIndustryClassification |
| string | SECURITYDBO | MUNI | MUNI_LONG_INDUSTRY_TYP |
| EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/muniIndustryClassification |
muniIssueSize |
| decimal | SECURITYDBO | MUNI | MUNI_ISSUE_SIZE |
| EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/muniIssueSize |
pricingCusip |
| string | SECURITYDBO | SECURITY_MASTER_EXT | PRICING_CUSIP |
| EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/pricingCusip |
buysell |
| string | SECURITYDBO | DERIVATIVES | BUYSELL | VARCHAR2(4) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/buysell |
amortizationParValue |
| decimal | SECURITYDBO | FIXED_INCOME | AMORTIZATION_PAR_VALUE | NUMBER(28,12) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/amortizationParValue |
balanceType |
| string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | BALANCE_TYPE | VARCHAR2(30) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/balanceType |
cashBalance |
| decimal | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | CASH_BALANCE | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cashBalance |
cashDisbursements |
| decimal | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | CASH_DISBURSEMENTS | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cashDisbursements |
cashProjectionInstance |
| integer | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | CP_INSTANCE | NUMBER(10) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cashProjectionInstance |
projectionDate |
| date | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | PROJECTION_DATE | DATE | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/projectionDate |
transType |
| string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | TRANS_TYPE | VARCHAR2(255) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/transType |
activityInstance |
| integer | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | ACTIVITY_INSTANCE | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/activityInstance |
brokerCode |
| string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | BROKER_CODE |