Page Comparison

Element	Optional/Required	Value Type	Eagle DB	DB Table	DB Field	Star Tag	DB Field Type	XPath
objectType

Optional

		objectType	not stored in DB					EagleML/accountingTransaction/cashProjections/objectType
objectId

Optional

		objectId	not stored in DB					EagleML/accountingTransaction/cashProjections/objectId
objectDescription

Optional

		objectDescription	not stored in DB					EagleML/accountingTransaction/cashProjections/objectDescription
updateTimestamp

Optional

dateTime

						EagleML/accountingTransaction/cashProjections/updateTimestamp
customElements

Optional

		CustomElements	reserved for customizations					EagleML/accountingTransaction/cashProjections/customElements
updateSource

Optional

		string	ESTAR	ESTAR_CASH_PROJECTION	UPDUSER	944	VARCHAR2(255)	EagleML/accountingTransaction/cashProjections/updateSource
cashProjection

OptionalCashProjection_ItemCashProjection_Item

CashProjection Item - Complex type (see extra table below)

EagleML/accountingTransaction/cashProjections/cashProjection/

Anchor

CashProjection Item Data Map Table
Element	Optional/Required	Value Type	Eagle DB	DB Table	DB Field	Star Tag	DB Field Type	XPath
cashProjectionInstance

Optional

integer

ESTAR

ESTAR_CASH_PROJECTION

CP_INSTANCE

		NUMBER(10)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionInstance
cashProjectionType

Optional

integer

ESTAR

ESTAR_CASH_PROJECTION

CP_TYPE

	NUMBER(1)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionType
Entity Common Id Model								EagleML/accountingTransaction/cashProjections/cashProjection/

Entity Properties ModelEagleML/accountingTransaction/cashProjections/cashProjection/accountingBasisOptional

accountingBasis		string	ESTAR	ESTAR_CASH_PROJECTION	ACCOUNTING_BASIS	21	VARCHAR2(10)	EagleML/accountingTransaction/cashProjections/cashProjection/accountingBasis
status

Optional

		integer	ESTAR	ESTAR_CASH_PROJECTION	STATUS	54	NUMBER(1)	EagleML/accountingTransaction/cashProjections/cashProjection/status
startDate

Optional

date

ESTAR

ESTAR_CASH_PROJECTION

START_DATE

		VARCHAR2(8)	EagleML/accountingTransaction/cashProjections/cashProjection/startDate
endDate

Optional

		date	ESTAR	ESTAR_CASH_PROJECTION	END_DATE	73	VARCHAR2(8)	EagleML/accountingTransaction/cashProjections/cashProjection/endDate
balanceCount

Optional

integer

ESTAR

ESTAR_CASH_PROJECTION

BALANCE_COUNT

		NUMBER	EagleML/accountingTransaction/cashProjections/cashProjection/balanceCount
currency

Optional

normalizedString

ESTAR

ESTAR_CASH_PROJECTION

CUR

		CHAR(3)	EagleML/accountingTransaction/cashProjections/cashProjection/currency
internalCounter

Optional

integer

ESTAR

ESTAR_CASH_PROJECTION

INTERNAL_COUNTER

		NUMBER(38)	EagleML/accountingTransaction/cashProjections/cashProjection/internalCounter
positionSwitch

Optional

normalizedString

ESTAR

ESTAR_CASH_PROJECTION

POSITION_SWITCH

		VARCHAR2(5)	EagleML/accountingTransaction/cashProjections/cashProjection/positionSwitch
rejectedCount

Optional

integer

ESTAR

ESTAR_CASH_PROJECTION

REJECTED_COUNT

		NUMBER	EagleML/accountingTransaction/cashProjections/cashProjection/rejectedCount
reportName

Optional

string

ESTAR

ESTAR_CASH_PROJECTION

REPORT_NAME

		VARCHAR2(255)	EagleML/accountingTransaction/cashProjections/cashProjection/reportName
reportType

Optional

	string	ESTAR	ESTAR_CASH_PROJECTION	REPORT_TYPE	444	VARCHAR2(25)	EagleML/accountingTransaction/cashProjections/cashProjection/reportType
zeroSwitch

Optional

string

ESTAR

ESTAR_CASH_PROJECTION

ZERO_SWITCH

CHAR(10)

EagleML/accountingTransaction/cashProjections/cashProjection/zeroSwitch

cashProjectionDetailOptionalCashProjectionDetail Item

Entity Properties Model								EagleML/accountingTransaction/cashProjections/cashProjection/
cashProjectionDetail		CashProjectionDetail Item - Complex type (see extra table below)						EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail

anchor


CashProjectionDetail

_ItemCashProjectionDetail_ItemCashProjectionDetail

Item Data Map Table
Element	Optional/Required	Value Type	Eagle DB	DB Table	DB Field	Star Tag	DB Field Type	XPath
entityName

Optional

		string	ESTAR	ESTAR_CASH_PROJECTION_DETAILS	ENTITY_NAME	1164	CHAR(30)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/entityName
entityType

Optional

		normalizedString	ESTAR	ESTAR_CASH_PROJECTION_DETAILS	ENTITY_TYPE	1105	CHAR(4)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/entityType
accountingBasis

Optional

		string	ESTAR	ESTAR_CASH_PROJECTION_DETAILS	ACCOUNTING_BASIS	21	VARCHAR2(10)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/accountingBasis
baseCurrency

Optional

normalizedString

ESTAR

ESTAR_CASH_PROJECTION_DETAILS

BASE_CURRENCY

		CHAR(3)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/baseCurrency
primaryAssetId

Optional

InstrumentId

ESTAR

ESTAR_CASH_PROJECTION_DETAILS

PRIMARY_ASSET_ID

14

CHAR(100)

EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/primaryAssetId

primaryAssetTypeOptionalInstrumentIdTypeESTARESTAR_CASH_PROJECTION_DETAILSPRIMARY_ASSET_ID_TYPE1432CHAR(30

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/

primaryAssetTypealtAssetIdAndTypeOptionalAssetIdAndAssetIdType - Complex type (see extra table below)

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/

altAssetIdAndType/issueNameOptional

riskClassificationType
userGroupChar1		string

ESTAR

SECURITYDBO

ESTAR

SECURITY_

CASH

MASTER_

PROJECTION_DETAILSISSUE_NAME961

DETAIL

USER_GROUP_CHAR1

VARCHAR2(

255

60)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

issueNameOptional

userGroupChar1

unicodeIssueName

notionalResetType

string

not stored in DBEagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/unicodeIssueNameissueDescriptionOptionalDescriptionESTARESTAR_CASH_PROJECTION_DETAILSISSUE_DESCRIPTION VARCHAR2(255

SECURITYDBO

SWAPS

NOTIONAL_RESET_TYPE

VARCHAR2(10)

EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

issueDescription

notionalResetType

ticker

payRecIndicator

Optional

string

InstrumentId

SECURITYDBO

ESTAR

SWAPS

ESTAR

PAY_

CASH

RECEIVE_

PROJECTION_DETAILSTICKER CHAR(100

IND

VARCHAR2(10)

EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

ticker

payRecIndicator

cusipInstrumentId

smStateCode

Optional

string

SECURITYDBO

XREFERENCE

FIXED_INCOME

XREF_SECURITY_ID7052

STATE_CODE

CHAR(

100

2)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

cusip

smStateCode

cusipPayInstrumentId

smDefaultIndicator

Optional

string

SECURITYDBO

XREFERENCE

XREF_

SECURITY_

ID

MASTER

DEFAULT_FLAG

CHAR(

100

2)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

cusipPay

smDefaultIndicator

cusipReceiveInstrumentId

smPoolNumber

Optional

string

SECURITYDBO

XREFERENCEXREF_

SECURITY_

ID

MASTER

POOL_NUMBER

CHAR(

100

12)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

cusipReceive

smPoolNumber

isinInstrumentId

fwdBrokerCode

Optional

string

SECURITYDBO

XREFERENCEXREF

SECURITY_

SECURITY

MASTER_

ID7055CHAR(100)

DETAIL

FWD_BROKER_CODE

EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

isin

fwdBrokerCode

sedolInstrumentId

issueDate

Optional

date	SECURITYDBO

XREFERENCE

FIXED_INCOME

XREF_SECURITY_ID7058CHAR(100)

ISSUE_DATE

EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

sedol

issueDate

reutersInstrumentId

firstIncomeDate

Optional

date	SECURITYDBO

XREFERENCE

FIXED_INCOME

XREF

FIRST_

SECURITY

INCOME_

ID7061CHAR(100)

DATE

EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

reutersOptional

firstIncomeDate

bloombergId

lastIncomeDate

InstrumentId

date

SECURITYDBO

XREFERENCE

FIXED_INCOME

XREF

LAST_

SECURITY_ID7064CHAR(100)

INCOME_DATE

EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

bloombergId

lastIncomeDate

sicovmIdInstrumentId

smDefaultDate

Optional

date	SECURITYDBO

XREFERENCE

FIXED_INCOME

XREF_SECURITY_ID7067CHAR(100)

DEFAULT_DATE

EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

sicovmId

smDefaultDate

valorenIdInstrumentId

prvtPlace

Optional

string

SECURITYDBO

XREFERENCE

XREF_

SECURITY_

ID7070CHAR(100)

MASTER

PRVT_PLACE

EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

valorenId

prvtPlace

cedelInstrumentId

clearedSecurity

Optional

string

SECURITYDBO

XREFERENCE

DERIVATIVES

XREF

CLEARED_SECURITY

_ID7073CHAR(100)

EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

cedel

clearedSecurity

internalId

countryOfIssue

Optional

string

InstrumentId

SECURITYDBO

XREFERENCEXREF_SECURITY_ID7076CHAR(100)

SECMASTER_DETAIL_EXT

COUNTRY_OF_ISSUE

EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

internalId

countryOfIssue

cinsIdInstrumentId

incomeCurrency

Optional

CurrencyCode

SECURITYDBO

XREFERENCEXREF_

SECURITY_

ID7079CHAR(100)

MASTER

INCOME_CURRENCY

EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

cinsIdxrefIdentifiersOptionalXrefIdentifiers - Complex type (see extra table)

incomeCurrency
smMinorInd		string	SECURITYDBO	SECURITY_MASTER	MINOR_IND			EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

xrefIdentifiers/primaryExchangeOptional

smMinorInd
muniIssuerDes2ndLine		string	SECURITYDBO

EQUITY_DETAILPRIMARY_EXCHANGE VARCHAR2(30)

MUNI

MUNI_ISSUER_DES_2ND_LINE

EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

primaryExchange

muniIssuerDes2ndLine

primaryExchangeCode

muniIndustryClassification

Optional

string

ExchangeCode

SECURITYDBO

SECURITYDBOSECURITY_MASTEREXCHANGE17CHAR(8)

MUNI

MUNI_LONG_INDUSTRY_TYP

EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

primaryExchangeCode

muniIndustryClassification

securityAlias

muniIssueSize

Optional

decimal

SECURITYDBO

ESTAR

MUNI

ESTAR

MUNI_

CASH

ISSUE_

PROJECTION_DETAILSASSET_ID10NUMBER(28)

SIZE

EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

securityAliasOptional

muniIssueSize

assetCurrency

pricingCusip

CurrencyCode

string

SECURITYDBO

SECURITY_MASTER_EXT

CURRENCY_CODE85CHAR(30)

PRICING_CUSIP

EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

assetCurrencyassetResolutionOptionOptionalAssetResolutionEnumnot stored in DB

pricingCusip
buysell		string	SECURITYDBO	DERIVATIVES	BUYSELL		VARCHAR2(4)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

assetResolutionOptionbattingOrderOptionalstringnot stored in DB

buysell
amortizationParValue		decimal	SECURITYDBO	FIXED_INCOME	AMORTIZATION_PAR_VALUE		NUMBER(28,12)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

battingOrder

amortizationParValue

balanceType

Optional

string

ESTAR

ESTAR_CASH_PROJECTION_DETAILS

BALANCE_TYPE

		VARCHAR2(30)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/balanceType
cashBalance

Optional

decimal

ESTAR

ESTAR_CASH_PROJECTION_DETAILS

CASH_BALANCE

		NUMBER	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cashBalance
cashDisbursements

Optional

decimal

ESTAR

ESTAR_CASH_PROJECTION_DETAILS

CASH_DISBURSEMENTS

		NUMBER	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cashDisbursements
cashProjectionInstance

Optional

integer

ESTAR

ESTAR_CASH_PROJECTION_DETAILS

CP_INSTANCE

		NUMBER(10)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cashProjectionInstance
projectionDate

Optional

date

ESTAR

ESTAR_CASH_PROJECTION_DETAILS

PROJECTION_DATE

		DATE	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/projectionDate
transType

Optional

string

ESTAR

ESTAR_CASH_PROJECTION_DETAILS

TRANS_TYPE

		VARCHAR2(255)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/transType
activityInstance

Optional

integer

ESTAR

ESTAR_CASH_PROJECTION_DETAILS

ACTIVITY_INSTANCE

		NUMBER	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/activityInstance
brokerCode

Optional

		string	ESTAR	ESTAR_CASH_PROJECTION_DETAILS	BROKER_CODE	88	CHAR(20)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/brokerCode
brokerDesc

Optional

string

ESTAR

ESTAR_CASH_PROJECTION_DETAILS

BROKER_DESC

		CHAR(50)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/brokerDesc
cashReciepts

Optional

decimal

ESTAR

ESTAR_CASH_PROJECTION_DETAILS

CASH_RECIEPTS

		NUMBER	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/cashReciepts
costMethod

Optional

		normalizedString	ESTAR	ESTAR_CASH_PROJECTION_DETAILS	COST_METHOD	22	VARCHAR2(2)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/costMethod
coupon

Optional

		decimal	ESTAR	ESTAR_CASH_PROJECTION_DETAILS	COUPON	70	NUMBER	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/coupon
couponFrequencyCode

Optional

string

ESTAR

ESTAR_CASH_PROJECTION_DETAILS

COUPON_FREQ_CODE

		CHAR(30)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/couponFrequencyCode
couponTypeCode

Optional

	string	ESTAR	ESTAR_CASH_PROJECTION_DETAILS	COUPON_TYPE_CODE	97	CHAR(8)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/couponTypeCode
currency

Optional

normalizedString

ESTAR

ESTAR_CASH_PROJECTION_DETAILS

CURRENCY

		CHAR(3)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/currency
eventId

Optional

		string	ESTAR	ESTAR_CASH_PROJECTION_DETAILS	EVENT_ID	25	VARCHAR2(100)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/eventId
issuerId

Optional

	string	ESTAR	ESTAR_CASH_PROJECTION_DETAILS	ISSUER_ID	1144	CHAR(20)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/issuerId
matDate

Optional

date

ESTAR

ESTAR_CASH_PROJECTION_DETAILS

MAT_DATE

	DATE	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/matDate
nraTaxCountry

Optional

string

ESTAR

ESTAR_CASH_PROJECTION_DETAILS

NRA_TAX_COUNTRY

		CHAR(30)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/nraTaxCountry
positionFlag

Optional

integer

ESTAR

ESTAR_CASH_PROJECTION_DETAILS

POSITION_FLAG

		NUMBER	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/positionFlag
priceMultiplier

Optional

		decimal	ESTAR	ESTAR_CASH_PROJECTION_DETAILS	PRICE_MULTIPLIER	18	NUMBER(28,12)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/priceMultiplier
quantity

Optional

decimal

ESTAR

ESTAR_CASH_PROJECTION_DETAILS

QTY

		NUMBER	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/quantity
stateCode

Optional

		normalizedString	ESTAR	ESTAR_CASH_PROJECTION_DETAILS	STATE_CODE	1343	CHAR(2)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/stateCode
tradeDate

Optional

date

ESTAR

ESTAR_CASH_PROJECTION_DETAILS

TRADE_DATE

		DATE	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/tradeDate
tradingUnit

Optional

decimal

ESTAR

ESTAR_CASH_PROJECTION_DETAILS

TRADING_UNIT

		NUMBER(28,12)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/tradingUnit
xRateLocalBase

Optional

decimal

ESTAR

ESTAR_CASH_PROJECTION_DETAILS

XRATE_LOC_BASE

		NUMBER(38,8)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/xRateLocalBase
userGroupChar4

Optional

string

ESTAR

ESTAR_CASH_PROJECTION_DETAILS

USER_GROUP_CHAR4

		VARCHAR2(60)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/userGroupChar4
userGroupChar5

Optional

string

ESTAR

ESTAR_CASH_PROJECTION_DETAILS

USER_GROUP_CHAR5

		VARCHAR2(60)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/userGroupChar5
userGroupChar6

Optional

string

ESTAR

ESTAR_CASH_PROJECTION_DETAILS

USER_GROUP_CHAR6

		VARCHAR2(60)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/userGroupChar6
userIndex

Optional

integer

ESTAR

ESTAR_CASH_PROJECTION_DETAILS

USER_INDEX

		NUMBER	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/userIndex
sumCashDisbursements

Optional

decimal

ESTAR

TEMP_CPD

SUM_CASH_DISBURSEMENTS

		NUMBER	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/sumCashDisbursements
sumCashReciepts

Optional

decimal

ESTAR

TEMP_CPD

SUM_CASH_RECIEPTS

		NUMBER	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/sumCashReciepts
countM

Optional

integer

ESTAR

TEMP_CPD

COUNT_M

		NUMBER	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/countM
maxUserIndex

Optional

integer

ESTAR

TEMP_CPD

MAX_USER_INDEX

		NUMBER	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/maxUserIndex
maxCashBalance

Optional

	decimal	Generated by QUERY_CP_RECORD_DETAILS procedure					EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/maxCashBalance
sumQty

Optional

decimal

Generated by QUERY_CP_RECORD_DETAILS procedure

EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/sumQty

Versions Compared

Old Version 4

New Version 5

Key