Accounting Cash Projections Data Map Table
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Dmitry Donosiyan (Unlicensed)
Element | Optional/Required | Value Type | Eagle DB | DB Table | DB Field | 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 | VARCHAR2(255) | EagleML/accountingTransaction/cashProjections/updateSource |
cashProjection | Â | Â | Â | EagleML/accountingTransaction/cashProjections/cashProjection/ | |||
CashProjection Item Data Map Table | |||||||
Element | Optional/Required | Value Type | Eagle DB | DB Table | DB Field | 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 |
EagleML/accountingTransaction/cashProjections/cashProjection/ | |||||||
accountingBasis | Â | string | ESTAR | ESTAR_CASH_PROJECTION | ACCOUNTING_BASIS | VARCHAR2(10) | EagleML/accountingTransaction/cashProjections/cashProjection/accountingBasis |
status | Â | integer | ESTAR | ESTAR_CASH_PROJECTION | STATUS | 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 | 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 | VARCHAR2(25) | EagleML/accountingTransaction/cashProjections/cashProjection/reportType |
zeroSwitch | Â | string | ESTAR | ESTAR_CASH_PROJECTION | ZERO_SWITCH | CHAR(10) | EagleML/accountingTransaction/cashProjections/cashProjection/zeroSwitch |
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 | DB Field Type | XPath |
entityName | Â | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | ENTITY_NAME | CHAR(30) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/entityName |
entityType | Â | normalizedString | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | ENTITY_TYPE | CHAR(4) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/entityType |
accountingBasis | Â | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | ACCOUNTING_BASIS | 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 | CHAR(100) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/primaryAssetId |
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_CODE | 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 | VARCHAR2(2) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/costMethod |
coupon | Â | decimal | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | COUPON | 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_CODE | 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_ID | VARCHAR2(100) | EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/eventId |
issuerId | Â | string | ESTAR | ESTAR_CASH_PROJECTION_DETAILS | ISSUER_ID | 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_MULTIPLIER | 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_CODE | 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 | |||
Â