Page Comparison

...

Info

title	Note

Please note that elements in the data map table below can be populated from different database tables depending on the <reportView> the <reportView> element set in the control message (either 'TRADED' or 'SETTLED').

...

shareClasseventIdESTAREVENT_TYPEunitsCalculated Value - Tag 50 = .AMOUNT + ESTAR_SETTLED_CASH_ACTIVITY.BREAKAGE_AMT_UNDER_B + ESTAR_SETTLED_CASH_ACTIVITY.BREAKAGE_AMT_OVER_BCalculated Value - Tag 50 = SUM(ESTAR_TRADED_CASH_ACTIVITY.NET_AMOUNT_BASE)\SUM(.NET_AMOUNT_BASE)165PRINCIPALVARCHAR2(50/cashCategoryVARCHAR2(2autoSettleIndicatorreclaimMethodCONTSETTLE_DT28eventReason56EVENTREASONeventReasonrecPayAccount2commAmountLocaltaxAmountLocalsecFee48NUMBER(38,6)secFeesettleAmountLocalHardcode Value - 0settleAmountLocalESTARCalculated Value - Tag 198 = SUM(SETTLED_CASH_DISP_LOTS.CURRENCY_LOSScurrencyLossTRADEDTFX_RATETRADED\ESTARSETTLEDCASH_ACTIVITYnetAmountBaseSUM(.NET_AMOUNT_BASE)\SUM(.NET_AMOUNT_BASE)principalAmountBase*
(supported in 2017R1)recPayAccountstring1825REC_PAY_ACCTrecPayAccountbreakageAmountUnderBasebreakageAmountOverBaserecPayAmountLocal11781RECPAYAMT_LrecPayAmountLocalrecPayAmountBase11782REC_PAYrecPayAmountBasegainSwapLocaltermLoanFeeExpLocaltermLoanFeeExpBasecommAmountBasesecFeeBasestampDutyTaxBasefedTaxWithholdingBasestTaxWithholdingBasetaxAmountBasebuWithholdingLocalbuWithholdingBasebuWithholdingRatepricecashEventSpawned

Element	Value Type	Star Tag	Eagle DB	DB Table	DB Field	Data Type	Xpath
objectType	ObjectTypeEnum		Hardcoded Value = AccountingCashJournal				EagleML/accountingTransaction/accountingCashJournal/objectType
objectId	ObjectId		Hardcoded Value = AccountingCashJournal				EagleML/accountingTransaction/accountingCashJournal/objectId
objectDescription	FeedTypeEnum		Hardcoded Value = ACCOUNTING				EagleML/accountingTransaction/accountingCashJournal/objectDescription
updateTimestamp	dateTime		ESTAR	ESTAR_TRADED_CASH_ACTIVITY	SYSTEM_DATE	DATE	EagleML/accountingTransaction/accountingCashJournal/updateTimestamp
updateSource	string	944	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	UPDATE_SOURCE	VARCHAR2(32)	EagleML/accountingTransaction/accountingCashJournal/updateSource
Entity Common Id Model							EagleML/accountingTransaction/accountingCashJournal/
Asset Identifiers Model							EagleML/accountingTransaction/accountingCashJournal/
Asset Properties Model							EagleML/accountingTransaction/accountingCashJournal/
maturityDate	date	38	SECURITYDBO	SECURITY_MASTER	MAT_DATE	DATE	EagleML/accountingTransaction/accountingCashJournal/maturityDate
effectiveDate	date						EagleML/accountingTransaction/accountingCashJournal/effectiveDate
instance	integer	9388	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	INSTANCE		EagleML/accountingTransaction/accountingCashJournal/instance
instance	integer	9388	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	INSTANCE
localCurrency	CurrencyCode	85	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	LOCAL_CURR	VARCHAR2(3)	EagleML/accountingTransaction/accountingCashJournal/localCurrency
localCurrency	CurrencyCode	85	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	LOCAL_CURR	VARCHAR2(3)
baseCurrency	CurrencyCode	86	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	BASE_CURR	VARCHAR2(3)	EagleML/accountingTransaction/accountingCashJournal/baseCurrency
baseCurrency	CurrencyCode	86	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	BASE_CURR	VARCHAR2(3)
accountingBasis	string	21	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	ACCT_BASIS	VARCHAR2(5)	EagleML/accountingTransaction/accountingCashJournal/accountingBasis
accountingBasis	string	21	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	ACCT_BASIS	VARCHAR2(5)
longShortC	string	15	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	LNG_SHT_C	CHAR(1)	EagleML/accountingTransaction/accountingCashJournal/longShortC
longShortC	string	15	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	LNG_SHT_C	CHAR(1)
backupSrcSysC	string	34		ESTAR	ESTAR_TRADED_CASH_ACTIVITY	SHARE_CLASS	VARCHAR2(10)BKUP_SRC_SYS_C		EagleML/accountingTransaction/accountingCashJournal/shareClassbackupSrcSysC
backupSrcSysC	string	34		ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	SHARE_CLASS	VARCHAR2(10)BKUP_SRC_SYS_C
starPositionId	TransactionIdinteger	25830	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	EVENTPOSN_IDVARCHAR2(55)		EagleML/accountingTransaction/accountingCashJournal/eventIdstarPositionId
starPositionId	TransactionIdinteger	25830	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	EVENTPOSN_IDVARCHAR2(55)
starEventType	string	2362	ESTAR	settleAsset	Asset Identifiers Model - see extra table			ESTAR_TRADED_CASH_ACTIVITY		VARCHAR2(25)			EagleML/accountingTransaction/accountingCashJournal/starEventTypesettleAsset/
starEventType	string	2362	ESTAR	settleAsset	Asset Identifiers Model - see extra table			ESTAR_SETTLED_CASH_ACTIVITY		VARCHAR2(25)
eventTypeshareClass	string	5334	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	CASHSHARE_EVT_TYPCLASS	VARCHAR2(10)	EagleML/accountingTransaction/accountingCashJournal/eventTypeshareClass
eventTypeshareClass	string	5334	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	CASHSHARE_EVT_TYPCLASS	VARCHAR2(10)
processDateeventId	dateTransactionId	3025	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	PROCESSEVENT_DTDATEID	VARCHAR2(55)	EagleML/accountingTransaction/accountingCashJournal/processDateeventId
processDateeventId	dateTransactionId	3025	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	PROCESSEVENT_DTDATEID	VARCHAR2(55)
accountingDatestarEventType	datestring	362362	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	ACCOUNTEVENT_DTDATETYPE	VARCHAR2(25)	EagleML/accountingTransaction/accountingCashJournal/accountingDatestarEventType
accountingDatestarEventType	datestring	362362	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	ACCOUNTEVENT_DTDATETYPE	VARCHAR2(25)
monthEndAccountingDateeventType	datestring	473353	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	MONTHCASH_ENDEVT_ACCT_DTDATETYP	VARCHAR2(10)	EagleML/accountingTransaction/accountingCashJournal/monthEndAccountingDateeventType
monthEndAccountingDateeventType	datestring	473353	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	MONTHCASH_ENDEVT_ACCT_DTDATETYP	VARCHAR2(10)
eventSequence	decimalinteger	40126	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	UNITS	NUMBER(38,6)EVENT_SEQUENCE		EagleML/accountingTransaction/accountingCashJournal/units
eventSequence	decimalinteger	40126	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	UNITS	NUMBER(38,6)EVENT_SEQUENCE		EagleML/accountingTransaction/accountingCashJournal/units
amountprocessDate	date	decimal30	50	ESTAR	ESTAR_TRADED_CASH_ACTIVITY		PROCESS_DT	DATE	EagleML/accountingTransaction/accountingCashJournal/processDate
amountprocessDate	date	decimal30	50	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY		PROCESS_DT	DATE
accountingDate	date	36	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	ACCOUNT_DT	DATE	EagleML/accountingTransaction/accountingCashJournal/accountingDate
accountingDate	date	36	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	ACCOUNT_DT	DATE
monthEndAccountingDate	date	4733	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	MONTH_END_ACCT_DT	DATE	EagleML/accountingTransaction/accountingCashJournal/monthEndAccountingDate
monthEndAccountingDate	date	4733	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	MONTH_END_ACCT_DT	DATE
units	decimal	40	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	UNITS	NUMBER(38,6)	EagleML/accountingTransaction/accountingCashJournal/units
units	decimal	40	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	UNITS	NUMBER(38,6)	EagleML/accountingTransaction/accountingCashJournal/units
amount	decimal	50	Calculated Value - Tag 50 = ESTAR_TRADED_CASH_ACTIVITY.AMOUNT + ESTAR_SETTLED_CASH_ACTIVITY.BREAKAGE_AMT_UNDER_B + ESTAR_SETTLED_CASH_ACTIVITY.BREAKAGE_AMT_OVER_B				EagleML/accountingTransaction/accountingCashJournal/amount
amount	decimal	50	Calculated Value - Tag 50 = SUM(ESTAR_TRADED_CASH_ACTIVITY.NET_AMOUNT_BASE)\SUM(ESTAR_SETTLED_CASH_ACTIVITY.NET_AMOUNT_BASE)				EagleML/accountingTransaction/accountingCashJournal/amount
principal* (supported in 2017R1)	decimal	165	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	PRINCIPAL		EagleML/accountingTransaction/accountingCashJournal/principal
principal* (supported in 2017R1)	decimal	165	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	PRINCIPAL
income	decimal	1985	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	INCOME	NUMBER(38,6)	EagleML/accountingTransaction/accountingCashJournal/income
income	decimal	1985	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	INCOME	NUMBER(38,6)	EagleML/accountingTransaction/accountingCashJournal/income
navId	integer	3196	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	NAV_ID		EagleML/accountingTransaction/accountingCashJournal/navId
navId	integer	3196	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	NAV_ID		EagleML/accountingTransaction/accountingCashJournal/navId
cashStatus	string	54	Hardcode Value - TRADED for payables and receivables, SETTLED - for disbursements and receipts				EagleML/accountingTransaction/accountingCashJournal/cashStatus
cashCategory	string	62	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	CASH_CATEGORY	VARCHAR2(50)	EagleML/accountingTransaction/accountingCashJournal/cashCategory
cashCategory	string	62	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	CASH_CATEGORY	VARCHAR2(50)
bankAlias	string	16	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	BANK_ALIAS		EagleML/accountingTransaction/accountingCashJournal/bankAlias
bankAlias	string	16	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	BANK_ALIAS
autoSettleIndicator	YesNoOptionEnum	58	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	AUTO_SETTLE_INDICATOR	VARCHAR2(2)	EagleML/accountingTransaction/accountingCashJournal/autoSettleIndicator
autoSettleIndicator	YesNoOptionEnum	58	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	AUTO_SETTLE_INDICATOR	VARCHAR2(2)
corpActionId	integer	60	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	CORP_ACTION_ID		EagleML/accountingTransaction/accountingCashJournal/corpActionId
corpActionId	integer	60	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	CORP_ACTION_ID
ledgerBalanceEntitlement	string	3970	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	LDGR_BAL_ENTITLEMENT		EagleML/accountingTransaction/accountingCashJournal/ledgerBalanceEntitlement
ledgerBalanceEntitlement	string	3970	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	LDGR_BAL_ENTITLEMENT
accountingPlan	integer	999	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	ACCTG_PLAN		EagleML/accountingTransaction/accountingCashJournal/accountingPlan
accountingPlan	integer	999	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	ACCTG_PLAN
positingPlan	integer	913	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	POSTING_PLAN		EagleML/accountingTransaction/accountingCashJournal/positingPlan
positingPlan	integer	913	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	POSTING_PLAN
recPayPlan	string	1831	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	REC_PAY_PLAN	VARCHAR2(15)	EagleML/accountingTransaction/accountingCashJournal/recPayPlan
recPayPlan	string	1831	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	REC_PAY_PLAN	VARCHAR2(15)
withholdingLocal	decimal	853	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	WITHHOLDING_L	NUMBER(38,6)	EagleML/accountingTransaction/accountingCashJournal/withholdingLocal
withholdingLocal	decimal	853	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	WITHHOLDING_L	NUMBER(38,6)
reclaimLocal	decimal	852	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	RECLAIM_L	NUMBER(38,6)	EagleML/accountingTransaction/accountingCashJournal/reclaimLocal
reclaimLocal	decimal	852	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	RECLAIM_L	NUMBER(38,6)
reclaimMethod	string	3912	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	RECLAIM_METHOD	CHAR(2)	EagleML/accountingTransaction/accountingCashJournal/reclaimMethod
reclaimMethod	string	3912	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	RECLAIM_METHOD	CHAR(2)
batchEventId	string	701	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	BATCH_EVENT_ID		EagleML/accountingTransaction/accountingCashJournal/batchEventId
batchEventId	string	701	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	BATCH_EVENT_ID
contSettleDate	date	9968	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	CONT_SETTLE_DT	DATE	EagleML/accountingTransaction/accountingCashJournal/contSettleDate
contSettleDate	date	9968	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	CONT_SETTLE_DT	DATE
linkEventId	TransactionId	28	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	LINK_EVENT_ID	VARCHAR2(55)	EagleML/accountingTransaction/accountingCashJournal/linkEventId
linkEventId	TransactionId	28	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	LINK_EVENT_ID	VARCHAR2(55)
targetEventId	string	26	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	TARGET_EVT_ID	VARCHAR2(55)	EagleML/accountingTransaction/accountingCashJournal/targetEventId
targetEventId	string	26	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	TARGET_EVT_ID	VARCHAR2(55)
eventReason	string	56	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	EVENT_REASON	VARCHAR2(55)	EagleML/accountingTransaction/accountingCashJournal/eventReason
eventReason	string	56	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	EVENT_REASON	VARCHAR2(55)
cancelEventId	TransactionId	501	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	CANCEL_EVT_ID		EagleML/accountingTransaction/accountingCashJournal/cancelEventId
cancelEventId	TransactionId	501	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	CANCEL_EVT_ID
cancelSequence	integer	226	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	CANCEL_SEQUENCE		EagleML/accountingTransaction/accountingCashJournal/cancelSequence
cancelSequence	integer	226	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	CANCEL_SEQUENCE
recPayAccount2	string	1826	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	REC_PAY_ACCT2		EagleML/accountingTransaction/accountingCashJournal/recPayAccount2
recPayAccount2	string	1826	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	REC_PAY_ACCT2
principalBreakageUnder	decimal	10134	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	PRINCIPAL_BREAKAGE_UNDER		EagleML/accountingTransaction/accountingCashJournal/principalBreakageUnder
principalBreakageUnder	decimal	10134	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	PRINCIPAL_BREAKAGE_UNDER
principalBreakageOver	decimal	10135	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	PRINCIPAL_BREAKAGE_OVER		EagleML/accountingTransaction/accountingCashJournal/principalBreakageOver
principalBreakageOver	decimal	10135	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	PRINCIPAL_BREAKAGE_OVER
incomeBreakageUnder	decimal	10136	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	INCOME_BREAKAGE_UNDER		EagleML/accountingTransaction/accountingCashJournal/incomeBreakageUnder
incomeBreakageUnder	decimal	10136	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	INCOME_BREAKAGE_UNDER
incomeBreakageOver	decimal	10137	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	INCOME_BREAKAGE_OVER		EagleML/accountingTransaction/accountingCashJournal/incomeBreakageOver
incomeBreakageOver	decimal	10137	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	INCOME_BREAKAGE_OVER
otherFeeLocal	decimal	3752	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	OTHER_FEE_LOCAL	NUMBER(38,6)	EagleML/accountingTransaction/accountingCashJournal/otherFeeLocal
otherFeeLocal	decimal	3752	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	OTHER_FEE_LOCAL	NUMBER(38,6)
stampDutyTaxLocal	decimal	51	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	STAMP_DUTY_TAX_L	NUMBER(38,6)	EagleML/accountingTransaction/accountingCashJournal/stampDutyTaxLocal
stampDutyTaxLocal	decimal	51	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	STAMP_DUTY_TAX_L	NUMBER(38,6)
commAmountLocal	decimal	47	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	COMM_AMT_L	NUMBER(38,6)	EagleML/accountingTransaction/accountingCashJournal/commAmountLocal
commAmountLocal	decimal	47	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	COMM_AMT_L	NUMBER(38,6)
taxAmountLocal	decimal	46	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	TAX_AMT_L	NUMBER(38,6)	EagleML/accountingTransaction/accountingCashJournal/taxAmountLocal
taxAmountLocal	decimal	46	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	TAX_AMT_L	NUMBER(38,6)
secFee	decimal	48	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	SEC_FEE	NUMBER(38,6)	EagleML/accountingTransaction/accountingCashJournal/secFee
secFee	decimal	48	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	SEC_FEE	NUMBER(38,6)	EagleML/accountingTransaction/accountingCashJournal/secFee
backupPrice	decimal		ESTAR	ESTAR_TRADED_CASH_ACTIVITY	BKUP_PRICE		EagleML/accountingTransaction/accountingCashJournal/backupPrice
backupPrice	decimal		ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	BKUP_PRICE
settleAmountLocal	decimal	5363	Hardcode Value - 0				EagleML/accountingTransaction/accountingCashJournal/amount	settleAmountLocal
settleAmountLocal	decimal	5363	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	principal* (supported in 2017R1)	decimal	EagleML/accountingTransaction/accountingCashJournal/amount	settleAmountLocal		AMOUNT	NUMBER(38,6)
brokerCode	string	88	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	principal* (supported in 2017R1)	decimal		BROKER_CODE	CHAR(20)	EagleML/accountingTransaction/accountingCashJournal/principalbrokerCode
brokerCode	string	88	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY				BROKER_CODE	CHAR(20)
incomedividendRate	decimal	19855897	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	INCOMEDIVIDEND_RATE	NUMBER(3828,612)	EagleML/accountingTransaction/accountingCashJournal/incomedividendRate
incomedividendRate	decimal	19855897	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	INCOMEDIVIDEND_RATE	NUMBER(3828,612)
cashStatuscurrencyGain	stringdecimal	54198	Hardcode Value - ""				EagleML/accountingTransaction/accountingCashJournal/cashStatus	cashCategory	string	62	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	CASH_CATEGORY	Calculated Value - Tag 198 = SUM(SETTLED_CASH_DISP_LOTS.CURRENCY_GAIN)				EagleML/accountingTransaction/accountingCashJournal
ESTAR_SETTLED_CASH_ACTIVITY								cashCategory	string	62	ESTAR		CASH_CATEGORY
autoSettleIndicator	YesNoOptionEnum	58	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	AUTO_SETTLE_INDICATOR	/currencyGain
autoSettleIndicator	YesNoOptionEnum	58	ESTAR	currencyLoss	AUTO_SETTLE_INDICATOR	decimal	199	Calculated Value - Tag 198 = SUM(SETTLED_CASH_DISP_LOTS.CURRENCY_LOSS)				EagleML/accountingTransaction/accountingCashJournal/
ESTAR_SETTLED_CASH_ACTIVITY
recPayPlan	string	1831	currencyLoss
recPayPlan	string	1831	localAssetCurrency	CurrencyCode	9061	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	RECLOCAL_PAYASSET_PLANCURRENCY	VARCHAR2(153)	EagleML/accountingTransaction/accountingCashJournal/recPayPlanlocalAssetCurrency
ESTAR_SETTLED_CASH_ACTIVITY			localAssetCurrency	CurrencyCode	9061	ESTAR		RECLOCAL_PAYASSET_PLANCURRENCY	VARCHAR2(153)
withholdingLocalmasterTicketNumber	decimalstring	853761	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	WITHHOLDINGMASTER_TICKET_LNUMBER	NUMBERVARCHAR2(38,655)	EagleML/accountingTransaction/accountingCashJournal/withholdingLocalmasterTicketNumber
withholdingLocalmasterTicketNumber	decimalstring	853761	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	WITHHOLDINGMASTER_TICKET_LNUMBER	NUMBERVARCHAR2(38,655)
reclaimLocaltradeDateFxRate	decimal	85287	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	RECLAIM_LTRADE_DT_FX_RATE	NUMBER(38,612)	EagleML/accountingTransaction/accountingCashJournal/reclaimLocaltradeDateFxRate
reclaimLocaltradeDateFxRate	decimal	85287	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	RECLAIM_LTRADE_DT_FX_RATE	NUMBER(38,612)
corpActInstance	stringinteger	39124268	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	RECLAIMCORP_ACT_METHODINSTANCE	CHAR(2)		EagleML/accountingTransaction/accountingCashJournal/reclaimMethodcorpActInstance
corpActInstance	stringinteger	39124268	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	RECLAIMCORP_ACT_METHODINSTANCE	CHAR(2)
netAmountBase	decimal	contSettleDate	date	9968	ESTAR	478	Calculated Value - Tag 478 = amount(Tag 50)/Current Fx Rate				EagleML/accountingTransaction/accountingCashJournal/netAmountBase
netAmountBase	decimal	contSettleDate	date	9968	ESTAR	478	SUM(ESTAR_TRADED_CASH_ACTIVITY					.NET_				DATE	EagleML/accountingTransaction/accountingCashJournal/contSettleDate	AMOUNT_BASE)\SUM(ESTAR_SETTLED_CASH_ACTIVITY		linkEventId	TransactionId	.NET_AMOUNT_BASE)
principalAmountBase* (supported in 2017R1)	decimal	169	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	LINKPRINCIPAL_EVENTAMOUNT_IDBASE	VARCHAR2NUMBER(5538,6)	EagleML/accountingTransaction/accountingCashJournal/linkEventIdprincipalAmountBase									DATE				linkEventId	TransactionId
principalAmountBase* (supported in 2017R1)	decimal	169	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	LINKPRINCIPAL_EVENTAMOUNT_IDBASE	VARCHAR2NUMBER(5538,6)
targetEventIdincomeAmountBase	stringdecimal	261986	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	TARGETINCOME_EVTAMOUNT_IDBASE	VARCHAR2NUMBER(5538,6)	EagleML/accountingTransaction/accountingCashJournal/targetEventIdincomeAmountBase
targetEventIdincomeAmountBase	stringdecimal	261986	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	TARGETINCOME_EVTAMOUNT_IDBASE	VARCHAR2NUMBER(5538,6)
recPayAccount	string
recPayAccount	string	1825	ESTAR	ESTAR_TRADED_CASH_ACTIVITY
REC_PAY_		1825	ESTAR
REC_PAY_	ACCT
VARCHAR2(55)	ACCT
VARCHAR2(55)		EagleML/accountingTransaction/accountingCashJournal/
recPayAccount		EagleML/accountingTransaction/accountingCashJournal/
recPayAccount	ESTAR_SETTLED_CASH_ACTIVITY
recPayAccountDesc	string	18261651	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	REC_PAY_ACCT2ACCT_DESC		EagleML/accountingTransaction/accountingCashJournal/recPayAccount2recPayAccountDesc
recPayAccountDesc	string	18261651	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	REC_PAY_ACCT2ACCT_DESC
otherFeeLocalreclaimAmountBase	decimal	3752851	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	OTHERRECLAIM_FEEAMOUNT_LOCALBASE	NUMBER(38,6)	EagleML/accountingTransaction/accountingCashJournal/otherFeeLocalreclaimAmountBase
otherFeeLocalreclaimAmountBase	decimal	3752851	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	OTHERRECLAIM_FEEAMOUNT_LOCALBASE	NUMBER(38,6)
stampDutyTaxLocaltaxExpenseBase	decimal	51854	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	STAMPTAX_DUTYEXPENSE_TAX_LBASE	NUMBER(38,6)	EagleML/accountingTransaction/accountingCashJournal/stampDutyTaxLocaltaxExpenseBase
stampDutyTaxLocaltaxExpenseBase	decimal	51854	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	STAMPTAX_DUTYEXPENSE_TAX_LBASE	NUMBER(38,6)
breakageAmountUnderBase	decimal	471995	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	COMMBREAKAGE_AMT_LUNDER_B	NUMBER(38,6)	EagleML/accountingTransaction/accountingCashJournal/commAmountLocalbreakageAmountUnderBase
breakageAmountUnderBase	decimal	471995	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	COMMBREAKAGE_AMT_LUNDER_B	NUMBER(38,6)
breakageAmountOverBase	decimal	461997	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	TAXBREAKAGE_AMT_LOVER_B	NUMBER(38,6)	EagleML/accountingTransaction/accountingCashJournal/taxAmountLocalbreakageAmountOverBase
breakageAmountOverBase	decimal	461997	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	TAXBREAKAGE_AMT_LOVER_B	NUMBER(38,6)
recPayAmountLocal	decimal
recPayAmountLocal	decimal	11781	ESTAR	ESTAR_TRADED_CASH_ACTIVITY
SEC_FEE		11781	ESTAR
SEC_FEE	REC_PAY_AMT_L		EagleML/accountingTransaction/accountingCashJournal/
recPayAmountLocal	REC_PAY_AMT_L		EagleML/accountingTransaction/accountingCashJournal/
recPayAmountLocal	ESTAR_SETTLED_CASH_ACTIVITY
recPayAmountBase	decimal
recPayAmountBase	decimal	5363
11782	ESTAR	5363	ESTAR_TRADED_CASH_ACTIVITY	REC_PAY_AMT_B		EagleML/accountingTransaction/accountingCashJournal/
11782	ESTAR	recPayAmountBase		REC_PAY_AMT_B		EagleML/accountingTransaction/accountingCashJournal/
ESTAR_SETTLED_CASH_ACTIVITY		recPayAmountBase
AMOUNT	NUMBER(38,6)	brokerCodeclearingBroker	string	881236	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	CLEARING_BROKER_CODE	CHARVARCHAR2(2050)	EagleML/accountingTransaction/accountingCashJournal/brokerCodeclearingBroker
ESTAR_SETTLED_CASH_ACTIVITY		brokerCodeclearingBroker	string	881236	ESTAR		CLEARING_BROKER_CODE	CHARVARCHAR2(2050)
dividendRatetaxReclaimRate	decimal	58971296	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	DIVIDENDTAX_RECLAIM_RATE	NUMBER(2838,12)	EagleML/accountingTransaction/accountingCashJournal/dividendRatetaxReclaimRate
dividendRatetaxReclaimRate	decimal	58971296	ESTAR	ESTAR_SETTLED_CASH_ACTIVITYcurrencyGain	DIVIDENDTAX_RECLAIM_RATE	NUMBER(2838,12)
taxWithholdingRate	decimal	1295	198	Calculated Value - Tag 198 = SUM(SETTLED_CASH_DISP_LOTS.CURRENCY_GAIN)				EagleML/accountingTransaction/accountingCashJournal/currencyGain	currencyLoss	decimal	199	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	TAX_WITHHOLDING_RATE	NUMBER(38,12)	EagleML/accountingTransaction/accountingCashJournal/	localAssetCurrency	CurrencyCode	9061taxWithholdingRate
taxWithholdingRate	decimal	1295	ESTAR_SETTLED_CASH_ACTIVITY									ESTAR		TAX_WITHHOLDING_RATE	NUMBER(38,12)	EagleML/accountingTransaction/accountingCashJournal/	localAssetCurrency	CurrencyCode	9061taxWithholdingRate
specialReclaimRate	decimal	1298	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	LOCALSPECIAL_ASSETRECLAIM_CURRENCYRATE	VARCHAR2NUMBER(338,12)	EagleML/accountingTransaction/accountingCashJournal/localAssetCurrencyspecialReclaimRate
specialReclaimRate	decimal	1298	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	LOCALSPECIAL_ASSETRECLAIM_CURRENCYRATE	VARCHAR2NUMBER(338,12)
masterTicketNumberspecialWithholdingRate	stringdecimal	7611297	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	MASTERSPECIAL_TICKETWITHHOLDING_RATE	NUMBERVARCHAR2(5538,12)	EagleML/accountingTransaction/accountingCashJournal/masterTicketNumberspecialWithholdingRate
masterTicketNumberspecialWithholdingRate	stringdecimal	7611297	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	MASTERSPECIAL_TICKETWITHHOLDING_RATE	NUMBERVARCHAR2(5538,12)
tradeDateFxRate	decimalsourceEventId	87TransactionId		ESTAR	ESTAR_TRADED_CASH_ACTIVITY	SOURCE_	EVENT_	NUMBER(38,12)	ID		EagleML/accountingTransaction/accountingCashJournal/tradeDateFxRatesourceEventId
tradeDateFxRate	decimalsourceEventId	87TransactionId		ESTAR	ESTAR_	SETTLED_CASH_ACTIVITY		NUMBER(38,12)	SOURCE_	REFERENCE_		ID
targetAccountDate	decimaldate	478	Calculated Value - Tag 478 = amount(Tag 50)/Current Fx Rate				EagleML/accountingTransaction/accountingCashJournal/netAmountBase	119	ESTAR	ESTAR_TRADED_CASH_ACTIVITY		TARGET_ACCT_DATE		EagleML/accountingTransaction/accountingCashJournal/targetAccountDate
targetAccountDate	decimaldate	478	ESTAR_SETTLED_CASH_ACTIVITY					119	ESTAR			TARGET_ACCT_DATE
gainSwapLocal	decimal	16911819	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	PRINCIPALGAIN_AMOUNTSWAP_BASEL	NUMBER(38,612)	EagleML/accountingTransaction/accountingCashJournal/principalAmountBasegainSwapLocal
gainSwapLocal	decimal	16911819	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	PRINCIPALGAIN_AMOUNTSWAP_BASEL	NUMBER(38,612)
incomeAmountBaselossSwapLocal	decimal	198611821	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	INCOMELOSS_AMOUNTSWAP_BASEL	NUMBER(38,612)	EagleML/accountingTransaction/accountingCashJournal/incomeAmountBaselossSwapLocal
incomeAmountBaselossSwapLocal	decimal	198611821	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	INCOMELOSS_AMOUNTSWAP_BASEL	NUMBER(38,612)
gainSwapBase
gainSwapBase	decimal
11820	decimal	ESTAR	ESTAR_TRADED_CASH_ACTIVITY
11820	GAIN_SWAP_B	ESTAR	NUMBER(38,12)	EagleML/accountingTransaction/accountingCashJournal/
gainSwapBase	GAIN_SWAP_B		NUMBER(38,12)	EagleML/accountingTransaction/accountingCashJournal/
gainSwapBase	ESTAR_SETTLED_CASH_ACTIVITY
reclaimAmountBaselossSwapBase	decimal	85111822	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	RECLAIMLOSS_AMOUNTSWAP_BASEB	NUMBER(38,612)	EagleML/accountingTransaction/accountingCashJournal/reclaimAmountBaselossSwapBase
reclaimAmountBaselossSwapBase	decimal	85111822	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	RECLAIMLOSS_AMOUNTSWAP_BASEB	NUMBER(38,612)
taxExpenseBasetermLoanFeeIncLocal	decimal	854844	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	TAX_EXPENSE_BASETERM_LOAN_FEE_INC_L	NUMBER(38,612)	EagleML/accountingTransaction/accountingCashJournal/taxExpenseBasetermLoanFeeIncLocal
taxExpenseBasetermLoanFeeIncLocal	decimal	854844	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	TAX_EXPENSE_BASETERM_LOAN_FEE_INC_L	NUMBER(38,612)
termLoanFeeIncBase	decimal	1995845	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	BREAKAGETERM_LOAN_AMTFEE_UNDERINC_B	NUMBER(38,612)	EagleML/accountingTransaction/accountingCashJournal/breakageAmountUnderBasetermLoanFeeIncBase
termLoanFeeIncBase	decimal	1995845	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	BREAKAGETERM_LOAN_AMTFEE_UNDERINC_B	NUMBER(38,612)
termLoanFeeExpLocal	decimal	1997846	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	BREAKAGETERM_LOAN_AMTFEE_OVEREXP_BL	NUMBER(38,612)	EagleML/accountingTransaction/accountingCashJournal/breakageAmountOverBasetermLoanFeeExpLocal
termLoanFeeExpLocal	decimal	1997846	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	BREAKAGETERM_LOAN_AMTFEE_OVEREXP_BL	NUMBER(38,612)
termLoanFeeExpBase	decimal
termLoanFeeExpBase	decimal	847	ESTAR	ESTAR_TRADED_CASH_ACTIVITY
TERM_LOAN_		847	ESTAR
TERM_LOAN_	FEE_
EXP_B	FEE_	NUMBER(38,12)	EagleML/accountingTransaction/accountingCashJournal/
EXP_B	termLoanFeeExpBase	NUMBER(38,12)	EagleML/accountingTransaction/accountingCashJournal/
ESTAR_SETTLED_CASH_ACTIVITY	termLoanFeeExpBase
commAmountBase	decimal
commAmountBase	decimal	498	ESTAR	ESTAR_TRADED_CASH_ACTIVITY
COMM_AMT_B	NUMBER(38,12)	498	ESTAR	EagleML/accountingTransaction/accountingCashJournal/
COMM_AMT_B	NUMBER(38,12)	commAmountBase		EagleML/accountingTransaction/accountingCashJournal/
ESTAR_SETTLED_CASH_ACTIVITY		commAmountBase
clearingBrokerotherFeeBase	stringdecimal	12365708	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	CLEARINGOTHER_FEE_BROKERB	VARCHAR2NUMBER(5038,12)	EagleML/accountingTransaction/accountingCashJournal/clearingBrokerotherFeeBase
clearingBrokerotherFeeBase	stringdecimal	12365708	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	CLEARINGOTHER_FEE_BROKERB	VARCHAR2NUMBER(5038,12)
taxReclaimRatesecFeeBase	decimal	129610122	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	TAXSEC_RECLAIMFEE_RATEB	NUMBER(38,12)	EagleML/accountingTransaction/accountingCashJournal/taxReclaimRatesecFeeBase
taxReclaimRatesecFeeBase	decimal	129610122	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	TAXSEC_RECLAIMFEE_RATEB	NUMBER(38,12)
taxWithholdingRatestampDutyTaxBase	decimal	129510121	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	STAMP_DUTY_TAX_WITHHOLDING_RATEB	NUMBER(38,12)	EagleML/accountingTransaction/accountingCashJournal/taxWithholdingRatestampDutyTaxBase
taxWithholdingRatestampDutyTaxBase	decimal	129510121	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	STAMP_DUTY_TAX_WITHHOLDING_RATEB	NUMBER(38,12)
specialReclaimRatefedTaxWithholdingBase	decimal	12988078	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	SPECIALFED_TAX_RECLAIMWITHHOLD_RATEB	NUMBER(38,12)	EagleML/accountingTransaction/accountingCashJournal/specialReclaimRatefedTaxWithholdingBase
specialReclaimRatefedTaxWithholdingBase	decimal	12988078	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	SPECIALFED_TAX_RECLAIMWITHHOLD_RATEB	NUMBER(38,12)
specialWithholdingRatestTaxWithholdingBase	decimal	12978079	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	SPECIALST_TAX_WITHHOLDINGWITHHOLD_RATEB	NUMBER(38,12)	EagleML/accountingTransaction/accountingCashJournal/specialWithholdingRatestTaxWithholdingBase
specialWithholdingRatestTaxWithholdingBase	decimal	12978079	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	SPECIALST_TAX_WITHHOLDINGWITHHOLD_RATEB	NUMBER(38,12)
streamSecAlias	decimal	11819integer		ESTAR	ESTAR_TRADED_CASH_ACTIVITY	GAINSTREAM_SWAP_LNUMBER(38,12)SEC_ALIAS		EagleML/accountingTransaction/accountingCashJournal/gainSwapLocalstreamSecAlias
streamSecAlias	decimal	11819integer		ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	GAINSTREAM_SWAP_LNUMBER(38,12)SEC_ALIAS
lossSwapLocaltaxAmountBase	decimal	1182110759	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	LOSSTAX_SWAPAMT_LB	NUMBER(38,12)	EagleML/accountingTransaction/accountingCashJournal/lossSwapLocaltaxAmountBase
lossSwapLocaltaxAmountBase	decimal	1182110759	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	LOSSTAX_SWAPAMT_LB	NUMBER(38,12)
gainSwapBasebuWithholdingLocal	decimal	118202712	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	GAINBU_SWAPWTHHLD_BL	NUMBER(38,12)	EagleML/accountingTransaction/accountingCashJournal/gainSwapBasebuWithholdingLocal
gainSwapBasebuWithholdingLocal	decimal	118202712	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	GAINBU_SWAPWTHHLD_BL	NUMBER(38,12)
lossSwapBasebuWithholdingBase	decimal	118222713	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	LOSSBU_SWAPWTHHLD_B	NUMBER(38,12)	EagleML/accountingTransaction/accountingCashJournal/lossSwapBasebuWithholdingBase
lossSwapBasebuWithholdingBase	decimal	118222713	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	LOSSBU_SWAPWTHHLD_B	NUMBER(38,12)
termLoanFeeIncLocalbuWithholdingRate	decimal	8442762	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	TERMBU_LOAN_FEE_INC_LWTHHLD_RATE	NUMBER(38,12)	EagleML/accountingTransaction/accountingCashJournal/termLoanFeeIncLocalbuWithholdingRate
termLoanFeeIncLocalbuWithholdingRate	decimal	8442762	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	TERMBU_LOAN_FEE_INC_LWTHHLD_RATE	NUMBER(38,12)
termLoanFeeIncBaseprice	decimal	84545	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	TERM_LOAN_FEE_INC_BPRICE	NUMBER(38,12)	EagleML/accountingTransaction/accountingCashJournal/termLoanFeeIncBaseprice
termLoanFeeIncBaseprice	decimal	84545	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	TERM_LOAN_FEE_INC_BPRICE	NUMBER(38,12)
cancelType	decimalstring	8462981	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	TERM_LOAN_FEE_EXP_L	NUMBER(38,12)CANCEL_TYPE		EagleML/accountingTransaction/accountingCashJournal/termLoanFeeExpLocalcancelType
cancelType	decimalstring	8462981	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	TERM_LOAN_FEE_EXP_L	NUMBER(38,12)CANCEL_TYPE
cancelFlag	decimalYesNoOptionEnum	84710045	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	TERM_LOAN_FEE_EXP_B	NUMBER(38,12)CANCEL_FLAG		EagleML/accountingTransaction/accountingCashJournal/termLoanFeeExpBasecancelFlag
cancelFlag	decimalYesNoOptionEnum	84710045	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	TERM_LOAN_FEE_EXP_B	NUMBER(38,12)CANCEL_FLAG
couponDate	decimaldate	4983460	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	COMM_AMT_B	NUMBER(38,12)COUPON_DATE		EagleML/accountingTransaction/accountingCashJournal/commAmountBasecouponDate
couponDate	decimaldate	4983460	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	COMM_AMT_B	NUMBER(38,12)COUPON_DATE
otherFeeBasecashEventSpawned	decimalstring	5708751	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	OTHERCASH_FEEEVENT_BSPAWNED	NUMBERVARCHAR2(38,121)	EagleML/accountingTransaction/accountingCashJournal/otherFeeBasecashEventSpawned
otherFeeBasecashEventSpawned	decimalstring	5708751	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	OTHERCASH_FEEEVENT_BSPAWNED	NUMBERVARCHAR2(38,121)
decimalbackupCouponEndDate	10122date		ESTAR	ESTAR_TRADED_CASH_ACTIVITY	SECBKUP_COUPON_FEEEND_B	NUMBER(38,12)	DATE		EagleML/accountingTransaction/accountingCashJournal/secFeeBasebackupCouponEndDate
decimalbackupCouponEndDate	10122date		ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	SECBKUP_COUPON_FEEEND_B	NUMBER(38,12)	DATE
origContSettleDate	decimal	10121date		ESTAR	ESTAR_TRADED_CASH_ACTIVITY	STAMPORIG_DUTYCONT_TAXSETTLE_B	NUMBER(38,12)	DT		EagleML/accountingTransaction/accountingCashJournal/stampDutyTaxBaseorigContSettleDate
origContSettleDate	decimal	10121date		ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	STAMPORIG_DUTYCONT_TAXSETTLE_B	NUMBER(38,12)	DT
periodicDistType	decimalstring	80781737	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	FEDPERIODIC_TAX_WITHHOLD_BNUMBER(38,12)DIST_TYPE		EagleML/accountingTransaction/accountingCashJournal/fedTaxWithholdingBaseperiodicDistType
periodicDistType	decimalstring	80781737	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	FEDPERIODIC_TAX_WITHHOLD_BNUMBER(38,12)DIST_TYPE
costLotOpenEventId	decimal	8079TransactionId		ESTAR	ESTAR_TRADED_CASH_ACTIVITY	STCOST_LOT_TAXOPEN_WITHHOLDEVT_B	NUMBER(38,12)	ID		EagleML/accountingTransaction/accountingCashJournal/stTaxWithholdingBasecostLotOpenEventId
costLotOpenEventId	decimal	8079TransactionId		ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	STCOST_LOT_TAXOPEN_WITHHOLDEVT_B	NUMBER(38,12)	ID
costLotCloseEventId	decimalTransactionId	10759		ESTAR	ESTAR_TRADED_CASH_ACTIVITY	TAX_AMT_B	NUMBER(38,12)	COST_LOT_CLOSE_EVT_ID		EagleML/accountingTransaction/accountingCashJournal/taxAmountBasecostLotCloseEventId
costLotCloseEventId	decimalTransactionId	10759		ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	TAX_AMT_B	NUMBER(38,12)	COST_LOT_CLOSE_EVT_ID
corpActionType	decimalstring	2712		ESTAR	ESTAR_TRADED_CASH_ACTIVITY	BUCORP_WTHHLDACTION_L	NUMBER(38,12)	TYPE		EagleML/accountingTransaction/accountingCashJournal/buWithholdingLocalcorpActionType
corpActionType	decimalstring	2712		ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	BUCORP_WTHHLDACTION_L	NUMBER(38,12)	TYPE
cashAccountName	decimalstring	271311696	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	BUCASH_WTHHLDACCT_B	NUMBER(38,12)	NAME		EagleML/accountingTransaction/accountingCashJournal/buWithholdingBasecashAccountName
cashAccountName	decimalstring	271311696	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	BUCASH_WTHHLDACCT_B	NUMBER(38,12)	NAME
cashAccount	decimalstring	276211697	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	BU_WTHHLD_RATE	NUMBER(38,12)CASH_ACCT		EagleML/accountingTransaction/accountingCashJournal/buWithholdingRatecashAccount
cashAccount	decimalstring	276211697	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	BU_WTHHLD_RATE	NUMBER(38,12)CASH_ACCT
cashAccountAlias	decimalinteger	4511698	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	PRICE	NUMBER(38,12)	CASH_ACCT_ALIAS		EagleML/accountingTransaction/accountingCashJournal/pricecashAccountAlias
cashAccountAlias	decimalinteger	4511698	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	PRICE	NUMBER(38,12)	CASH_ACCT_ALIAS
srcSysC	string	75198	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	CASHSRC_EVENTSYS_SPAWNEDC	VARCHAR2(1)		EagleML/accountingTransaction/accountingCashJournal/cashEventSpawnedsrcSysC
srcSysC	string	75198	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	CASHSRC_EVENTSYS_SPAWNEDC	VARCHAR2(1)
detailIndicator	string	8468	Hardcode Value - "TRADED ACTIVITY"				EagleML/accountingTransaction/accountingCashJournal/detailIndicator
detailIndicator	string	8468	Hardcode Value - "SETTLED ACTIVITY"
settlementDate	date	37	Hardcode Value - ""				EagleML/accountingTransaction/accountingCashJournal/settlementDate
settlementDate	date	37	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	EFFECTIVE_DT	DATE
tradedDate	date	35	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	EFFECTIVE_DT	DATE	EagleML/accountingTransaction/accountingCashJournal/tradedDate
tradedDate	date	35	ESTAR	ESTAR_TRADED_CASH_ACTIVITY\ ESTAR_SETTLED_CASH_ACTIVITY	EFFECTIVE_DT	DATE
breakageUnderLocal	decimal	1994	Calculated Value - Tag 1994 = ESTAR_TRADED_CASH_ACTIVITY.PRINCIPAL_BREAKAGE_UNDER + ESTAR_TRADED_CASH_ACTIVITY.INCOME_BREAKAGE_UNDER				EagleML/accountingTransaction/accountingCashJournal/breakageUnderLocal
breakageUnderLocal	decimal	1994	ESTAR_SETTLED_CASH_ACTIVITY	BREAKAGE_AMT_UNDER_L	NUMBER(38,12)
breakageOverLocal	decimal	1996	Calculated Value - Tag 1996 = ESTAR_TRADED_CASH_ACTIVITY.PRINCIPAL_BREAKAGE_OVER + ESTAR_TRADED_CASH_ACTIVITY.INCOME_BREAKAGE_OVER				EagleML/accountingTransaction/accountingCashJournal/breakageOverLocal
breakageOverLocal	decimal	1996	ESTAR_SETTLED_CASH_ACTIVITY	BREAKAGE_AMT_OVER_L	NUMBER(38,12)
recPayCategory	string	1827	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	REC_PAY_ACCT_DESC	VARCHAR2(100)	EagleML/accountingTransaction/accountingCashJournal/recPayCategory
recPayCategory	string	1827	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	REC_PAY_ACCT_DESC	VARCHAR2(100)
currentFxRate	decimal	96	Calculated Value(Default SP - get_spot_rate) - Current Fx Rate				EagleML/accountingTransaction/accountingCashJournal/currentFxRate
fxRate	decimal	484	Calculated Value - Tag 484 = Fx Rate for Date (ESTAR_TRADED_CASH_ACTIVITY.EFFECTIVE_DT)				EagleML/accountingTransaction/accountingCashJournal/fxRate
fxRate	decimal	484	ESTAR_SETTLED_CASH_ACTIVITY	TRADE_DT_FX_RATE	NUMBER(38,12)		EagleML/accountingTransaction/accountingCashJournal/fxRate
totalRealizedGainLossBase	decimal	5507	Calculated Value - Tag 5507 = SETTLED_CASH_DISP_LOTS.CURRENCY_GAIN - SETTLED_CASH_DISP_LOTS.CURRENCY_LOSS				EagleML/accountingTransaction/accountingCashJournal/totalRealizedGainLossBase
totalGainLossId	decimal	178	Calculated Value - Tag 178 = ESTAR_SETTLED_CASH_ACTIVITY.GAIN_CURRENCY - ESTAR_SETTLED_CASH_ACTIVITY.LOSS_CURRENCY				EagleML/accountingTransaction/accountingCashJournal/totalGainLossId
settledUrglTotalBase	decimal	11053	Hardcode Value - 0				EagleML/accountingTransaction/accountingCashJournal/settledUrglTotalBase
settleAmountBase	decimal	479	Hardcode Value - 0				EagleML/accountingTransaction/accountingCashJournal/settleAmountBase
settleAmountBase	decimal	479	Calculated Value - Tag 479 = amount(Tag 5363)/Current Fx Rate
tradedNetAmountLocal	decimal	11779	Calculated Value - Tag 11779 = amount + Tag 1997 - Tag 1995				EagleML/accountingTransaction/accountingCashJournal/tradedNetAmountLocal
tradedNetAmountLocal	decimal	11779	Hardcode Value - 0
tradedNetAmountBase	decimal	11780	Calculated Value - Tag 11780 = Tag 11779/Current Fx Rate				EagleML/accountingTransaction/accountingCashJournal/tradedNetAmountBase
tradedNetAmountBase	decimal	11780	Hardcode Value - 0
netAmountBaseNew	decimal	4309	Calculated Value - Tag 4309 = Tag 478 + Tag 5507 + Tag 178(for unsettled) + Tag 50/(End date Fx Rate)(for settled)				EagleML/accountingTransaction/accountingCashJournal/netAmountBaseNew
netAmountBaseNew	decimal	4309	Calculated Value - Tag 4309 = Tag 479 + Tag 5507
notionalResetType	decimal	4409	SECURITYDBO	SWAPS	NOTIONAL_RESET_TYPE		EagleML/accountingTransaction/accountingCashJournal/notionalResetType
reportType	decimal	1257	Calculated Value - ACCTGDT = Accounting Date; MONTHDT = Month End Date; POSTDT = Post Date; SETTLEDT = Settlement Date; TRADEDT = Trade Date;				EagleML/accountingTransaction/accountingCashJournal/reportType
regulatoryCategory	decimal	12387	RULESDBO	ENTITY_ACCT_BASIS_HIST	REGULATORY_CATEGORY	VARCHAR2(30)	EagleML/accountingTransaction/accountingCashJournal/regulatoryCategory
regulatoryCategoryChanged	string	891					EagleML/accountingTransaction/accountingCashJournal/regulatoryCategoryChanged
coupon	decimal	70	SECURITYDBO	SECURITY_MASTER	COUPON		EagleML/accountingTransaction/accountingCashJournal/coupon
quantityScale	decimal	19	SECURITYDBO	SECURITY_MASTER	TRADING_UNIT		EagleML/accountingTransaction/accountingCashJournal/quantityScale
quantityType	StringWithCodeScheme	12	SECURITYDBO	SECURITY_MASTER	QUANTITY_TYPE		EagleML/accountingTransaction/accountingCashJournal/quantityType
priceMultiplier	decimal	18	SECURITYDBO	SECURITY_MASTER	PRICE_MULTIPLIER		EagleML/accountingTransaction/accountingCashJournal/priceMultiplier
dayCountBasis	DayCountFraction	471	SECURITYDBO	SECURITY_MASTER	DAY_CNT		EagleML/accountingTransaction/accountingCashJournal/dayCountBasis
paymentFrequencyCode	StringWithCodeScheme	472	SECURITYDBO	SECURITY_MASTER	COUPON_FREQ_CODE		EagleML/accountingTransaction/accountingCashJournal/paymentFrequencyCode
varRateFreqCode	string	1788	SECURITYDBO	FIXED_INCOME	VAR_RATE_FREQ_CODE		EagleML/accountingTransaction/accountingCashJournal/varRateFreqCode
payRecIndicator	string	4590	SECURITYDBO	SWAPS	PAY_RECEIVE_IND		EagleML/accountingTransaction/accountingCashJournal/payRecIndicator
optiondescr	string	1364					EagleML/accountingTransaction/accountingCashJournal/optiondescr
interestPaymentTiming	StringWithCodeScheme	1523	SECURITYDBO	FIXED_INCOME	ACCRUAL_METHOD		EagleML/accountingTransaction/accountingCashJournal/interestPaymentTiming
businessDayConvention	BusinessDayConventionEnum	1536	SECURITYDBO	FIXED_INCOME	INTEREST_METHOD_CODE		EagleML/accountingTransaction/accountingCashJournal/businessDayConvention
businessCalendarName	string	1480					EagleML/accountingTransaction/accountingCashJournal/businessCalendarName
premiumType	string	3302	SECURITYDBO	DERIVATIVES	PREMIUM_TYPE		EagleML/accountingTransaction/accountingCashJournal/premiumType
sectorName	string	1156					EagleML/accountingTransaction/accountingCashJournal/sectorName
reportView	string	7009	resolved by panel				EagleML/accountingTransaction/accountingCashJournal/reportView
startDate	date	220	resolved by panel				EagleML/accountingTransaction/accountingCashJournal/startDate
endDate	date	221	resolved by panel				EagleML/accountingTransaction/accountingCashJournal/endDate

Versions Compared

Old Version 8

New Version Current

Key