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

Optional

CashProjection Item - Complex type (see extra table below)

EagleML/accountingTransaction/cashProjections/cashProjection/

Anchor
CashProjection

_Item

CashProjection

_Item

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/accountingBasisOptionalstring

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

_Item

CashProjectionDetail

_Item

CashProjectionDetail 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/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/

primaryAssetTypealtAssetIdAndTypeOptionalAssetIdAndAssetIdType - Complex type (see extra table below

countryOfRiskCode
region		string	SECURITYDBO	SECURITY_MASTER_DETAIL	REGION	VARCHAR2(50)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

altAssetIdAndType/issueNameOptional

region
riskClassificationType		string

ESTAR

SECURITYDBO

ESTAR

SECURITY_

CASH

MASTER_

PROJECTION_DETAILSISSUE_NAME961VARCHAR2(255)

DETAIL

RISK_CLASSIFICATION_TYPE

CHAR

EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

issueNameunicodeIssueNameOptionalstringnot stored in DB

riskClassificationType
userGroupChar1		string	SECURITYDBO	SECURITY_MASTER_DETAIL	USER_GROUP_CHAR1	VARCHAR2(60)	EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

unicodeIssueName

userGroupChar1

issueDescription

notionalResetType

Optional

string

Description

SECURITYDBO

ESTAR

SWAPS

ESTAR

NOTIONAL_

CASH_PROJECTION_DETAILSISSUE_DESCRIPTION

RESET_TYPE

VARCHAR2(

255

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

cusipPay

smDefaultIndicator

Optional

string

InstrumentId

SECURITYDBO

XREFERENCE

XREF_

SECURITY_

ID

MASTER

DEFAULT_FLAG

CHAR(

100

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

cusipPay

smDefaultIndicator

cusipReceiveInstrumentId

smPoolNumber

Optional

string

SECURITYDBO

XREFERENCE

XREF_

SECURITY_

ID

MASTER

POOL_NUMBER

CHAR(

100

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

cusipReceive

smPoolNumber

isinInstrumentId

fwdBrokerCode

Optional

string

SECURITYDBO

XREFERENCEXREF_SECURITY_ID7055CHAR(100)

SECURITY_MASTER_DETAIL

FWD_BROKER_CODE

EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

isin

fwdBrokerCode

sedolInstrumentId

issueDate

Optional

date	SECURITYDBO

XREFERENCEXREF_SECURITY_ID7058CHAR(100)

FIXED_INCOME

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/

reuters

firstIncomeDate

bloombergIdInstrumentId

lastIncomeDate

Optional

date	SECURITYDBO

XREFERENCE

FIXED_INCOME

XREF

LAST_

SECURITY

INCOME_

ID7064CHAR(100)

DATE

EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

bloombergIdOptional

lastIncomeDate

sicovmId

smDefaultDate

InstrumentId

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

XREFERENCEXREF_SECURITY_ID7073CHAR(100)

DERIVATIVES

CLEARED_SECURITY

EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

cedel

clearedSecurity

internalIdInstrumentId

countryOfIssue

Optional

string

SECURITYDBO

XREFERENCEXREF_SECURITY_ID7076CHAR(100)

SECMASTER_DETAIL_EXT

COUNTRY_OF_ISSUE

EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

internalId

countryOfIssue

cinsIdInstrumentId

incomeCurrency

Optional

CurrencyCode

SECURITYDBO

XREFERENCE

XREF_

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

MUNI

SECURITY_MASTEREXCHANGE17CHAR(8)

MUNI_LONG_INDUSTRY_TYP

EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

primaryExchangeCode

muniIndustryClassification

securityAlias

muniIssueSize

Optional

decimal

SECURITYDBO

ESTAR

MUNI

ESTAR

MUNI_

CASH_PROJECTION_DETAILSASSET_ID10NUMBER(28)

ISSUE_SIZE

EagleML/accountingTransaction/cashProjections/cashProjection/cashProjectionDetail/

securityAlias

muniIssueSize

assetCurrencyCurrencyCode

pricingCusip

Optional

string

SECURITYDBO

SECURITY_MASTER_EXT

CURRENCY

PRICING_

CODE85CHAR(30)

CUSIP

EagleML/accountingTransaction/cashProjections/cashProjection

/cashProjectionDetail/assetCurrencyassetResolutionOptionOptionalAssetResolutionEnumnot stored in DB

/cashProjectionDetail/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 Current

Key

Anchor
CashProjection

CashProjection

CashProjection Item Data Map Table

Anchor
CashProjectionDetail

CashProjectionDetail

CashProjectionDetail Item Data Map Table

Page Comparison

Versions Compared

Old Version 4

New Version Current

Key

AnchorCashProjection

CashProjection

CashProjection Item Data Map Table

AnchorCashProjectionDetail

CashProjectionDetail

CashProjectionDetail Item Data Map Table

Anchor
CashProjection

Anchor
CashProjectionDetail