...
| Element | Optional/Required | Value Type | Eagle DB | DB Table | DB Field | Star Tag | DB Field Type | XPath | ||
| objectType | objectType | not stored in DB | EagleML/accountingTransaction/cashProjections/objectType | |||||||
| objectId | objectId | not stored in DB | EagleML/accountingTransaction/cashProjections/objectId | |||||||
| objectDescription | objectDescription | not stored in DB | EagleML/accountingTransaction/cashProjections/objectDescription | |||||||
| updateTimestamp | dateTime | EagleML/accountingTransaction/cashProjections/updateTimestamp | ||||||||
| customElements | CustomElements | reserved for customizations | EagleML/accountingTransaction/cashProjections/customElements | |||||||
| updateSource | string | ESTAR | ESTAR_CASH_PROJECTION | UPDUSER | 944 | VARCHAR2(255) | EagleML/accountingTransaction/cashProjections/updateSource | |||
| cashProjection | CashProjection Item - Complex type (see extra table below) | EagleML/accountingTransaction/cashProjections/cashProjection/ | ||||||||
| CashProjection Item Data Map Table | ||||||||||
| Element | Optional/Required | Value Type | Eagle DB | DB Table | DB Field | Star Tag | DB Field Type | XPath | ||
| cashProjectionInstance | integer | ESTAR | ESTAR_CASH_PROJECTION | CP_INSTANCE | NUMBER(10) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionInstance | ||||
| cashProjectionType | integer | ESTAR | ESTAR_CASH_PROJECTION | CP_TYPE | NUMBER(1) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionType | ||||
| Entity Common Id Model | EagleML/accountingTransaction/cashProjections/cashProjection/ | |||||||||
| accountingBasis | string | ESTAR | ESTAR_CASH_PROJECTION | ACCOUNTING_BASIS21 | VARCHAR2(10) | EagleML/accountingTransaction/cashProjections/cashProjection/accountingBasis | ||||
| status | integer | ESTAR | ESTAR_CASH_PROJECTION | STATUS54 | NUMBER(1) | EagleML/accountingTransaction/cashProjections/cashProjection/status | ||||
| startDate | date | ESTAR | ESTAR_CASH_PROJECTION | START_DATE | VARCHAR2(8) | EagleML/accountingTransaction/cashProjections/cashProjection/startDate | ||||
| endDate | date | ESTAR | ESTAR_CASH_PROJECTION | END_DATE | 73 | VARCHAR2(8) | EagleML/accountingTransaction/cashProjections/cashProjection/endDate | |||
| balanceCount | integer | ESTAR | ESTAR_CASH_PROJECTION | BALANCE_COUNT | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/balanceCount | ||||
| currency | normalizedString | ESTAR | ESTAR_CASH_PROJECTION | CUR | CHAR(3) | EagleML/accountingTransaction/cashProjections/cashProjection/currency | ||||
| internalCounter | integer | ESTAR | ESTAR_CASH_PROJECTION | INTERNAL_COUNTER | NUMBER(38) | EagleML/accountingTransaction/cashProjections/cashProjection/internalCounter | ||||
| positionSwitch | normalizedString | ESTAR | ESTAR_CASH_PROJECTION | POSITION_SWITCH | VARCHAR2(5) | EagleML/accountingTransaction/cashProjections/cashProjection/positionSwitch | ||||
| rejectedCount | integer | ESTAR | ESTAR_CASH_PROJECTION | REJECTED_COUNT | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/rejectedCount | ||||
| reportName | string | ESTAR | ESTAR_CASH_PROJECTION | REPORT_NAME | VARCHAR2(255) | EagleML/accountingTransaction/cashProjections/cashProjection/reportName | ||||
| reportType | string | ESTAR | ESTAR_CASH_PROJECTION | REPORT_TYPE | 444 | VARCHAR2(25) | EagleML/accountingTransaction/cashProjections/cashProjection/reportType | |||
| zeroSwitch | string | ESTAR | ESTAR_CASH_PROJECTION | ZERO_SWITCH | CHAR(10) | EagleML/accountingTransaction/cashProjections/cashProjection/zeroSwitch | ||||
| Entity Properties Model | EagleML/accountingTransaction/cashProjections/cashProjection/ | |||||||||
| cashProjectionDetail | CashProjectionDetail Item - Complex type (see extra table below) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail | ||||||||
| CashProjectionDetail Item Data Map Table | ||||||||||
| Element | Optional/Required | Value Type | Eagle DB | DB Table | DB Field | Star Tag | DB Field Type | XPath | ||
| entityName | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | ENTITY_NAME1164 | CHAR(30) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/entityName | ||||
| entityType | normalizedString | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | ENTITY_TYPE | 1105 | CHAR(4) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/entityType | |||
| accountingBasis | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | ACCOUNTING_BASIS | 21 | VARCHAR2(10) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/accountingBasis | |||
| baseCurrency | normalizedString | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | BASE_CURRENCY | CHAR(3) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/baseCurrency | ||||
| primaryAssetId | InstrumentId | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | PRIMARY_ASSET_ID | 14 | CHAR(100) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/primaryAssetId | |||
| Asset Identifiers Model | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/ | |||||||||
| To add the elements highlighted below, please set IncludeExtendedDetails=Y in the 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_CODE88 | CHAR(20) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/brokerCode | ||||
| brokerDesc | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | BROKER_DESC | CHAR(50) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/brokerDesc | ||||
| cashReciepts | decimal | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | CASH_RECIEPTS | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cashReciepts | ||||
| costMethod | normalizedString | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | COST_METHOD | 22 | VARCHAR2(2) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/costMethod | |||
| coupon | decimal | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | COUPON | 70 | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/coupon | |||
| couponFrequencyCode | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | COUPON_FREQ_CODE | CHAR(30) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/couponFrequencyCode | ||||
| couponTypeCode | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | COUPON_TYPE_CODE97 | CHAR(8) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/couponTypeCode | ||||
| currency | normalizedString | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | CURRENCY | CHAR(3) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/currency | ||||
| eventId | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | EVENT_ID25 | VARCHAR2(100) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/eventId | ||||
| issuerId | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | ISSUER_ID1144 | CHAR(20) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/issuerId | ||||
| matDate | date | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | MAT_DATE | DATE | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/matDate | ||||
| nraTaxCountry | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | NRA_TAX_COUNTRY | CHAR(30) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/nraTaxCountry | ||||
| positionFlag | integer | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | POSITION_FLAG | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/positionFlag | ||||
| priceMultiplier | decimal | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | PRICE_MULTIPLIER18 | NUMBER(28,12) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/priceMultiplier | ||||
| quantity | decimal | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | QTY | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/quantity | ||||
| stateCode | normalizedString | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | STATE_CODE1343 | CHAR(2) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/stateCode | ||||
| tradeDate | date | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | TRADE_DATE | DATE | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/tradeDate | ||||
| tradingUnit | decimal | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | TRADING_UNIT | NUMBER(28,12) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/tradingUnit | ||||
| xRateLocalBase | decimal | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | XRATE_LOC_BASE | NUMBER(38,8) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/xRateLocalBase | ||||
| userGroupChar4 | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | USER_GROUP_CHAR4 | VARCHAR2(60) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/userGroupChar4 | ||||
| userGroupChar5 | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | USER_GROUP_CHAR5 | VARCHAR2(60) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/userGroupChar5 | ||||
| userGroupChar6 | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | USER_GROUP_CHAR6 | VARCHAR2(60) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/userGroupChar6 | ||||
| userIndex | integer | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | USER_INDEX | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/userIndex | ||||
| sumCashDisbursements | decimal | ESTAR | TEMP_CPD | SUM_CASH_DISBURSEMENTS | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/sumCashDisbursements | ||||
| sumCashReciepts | decimal | ESTAR | TEMP_CPD | SUM_CASH_RECIEPTS | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/sumCashReciepts | ||||
| countM | integer | ESTAR | TEMP_CPD | COUNT_M | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/countM | ||||
| maxUserIndex | integer | ESTAR | TEMP_CPD | MAX_USER_INDEX | NUMBER | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/maxUserIndex | ||||
| maxCashBalance | decimal | Generated by QUERY_CP_RECORD_DETAILS procedure | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/maxCashBalance | |||||||
| sumQty | decimal | Generated by QUERY_CP_RECORD_DETAILS procedure | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/sumQty | |||||||
...