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').

...

entityIdentityNameprimaryAssetIdInstrumentId14primaryAssetIdprimaryAssetType altAssetIdAndType/VARCHAR2(255issueNameVARCHAR2(255issueDescriptionCHAR(100tickerNUMBERsecurityAliasassetCurrencyCHAR(4)investmentTypeEagleMLprocessingSecurityTypesecurityType82CHAR(15securityTypeCHAR(30issueCountryCodeCHAR(8couponTypeCodesecuritySubType1464SECURITYDBOSECURITYTYPECHAR15securitySubTypeESTARVARCHAR2(55)ESTAR_2362processDateaccountingDatedatemonthEndAccountingDateamountCalculated Value - Tag 50 = ESTAR.AMOUNT + .BREAKAGE_AMT_UNDER_B + ESTAR_SETTLED.BREAKAGEAMTOVER_BCalculated Value - Tag 50 = SUM(TRADED_CASH_ACTIVITY.NET_AMOUNT_BASE)\SUM(.NET_AMOUNT_BASE)165 cashCategorystringVARCHAR2(50cashCategoryreclaimLocalCONTSETTLE_DT28eventReason56EVENTREASONeventReasonrecPayAccount2commAmountLocaltaxAmountLocalsecFee48secFeesettleAmountLocalHardcode Value - 0settleAmountLocalESTARCalculated Value - Tag 198 = SUM(SETTLED_CASH_DISP_LOTS.CURRENCY_LOSScurrencyLosstradeDateFxRateTRADEDT_FX_RATENUMBER(38,12)TRADED\ESTARSETTLEDCASH_ACTIVITYnetAmountBaseSUM(.NETAMOUNT_BASE)\SUM(.NET_AMOUNT_BASE)169recPayAccountstring1825RECPAY_ACCT recPayAccountbreakageAmountUnderBasebreakageAmountOverBaserecPayAmountLocal11781RECPAYAMTL recPayAmountLocalrecPayAmountBase11782RECPAY_ recPayAmountBasegainSwapLocaltermLoanFeeExpLocaltermLoanFeeExpBasecommAmountBasesecFeeBasestampDutyTaxBasefedTaxWithholdingBasestTaxWithholdingBasetaxAmountBasebuWithholdingLocalbuWithholdingBasebuWithholdingRatepricecashEventSpawned

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	entityId	string	5	RULESDBO	ENTITY	ENTITY_ID	CHAR(8)
Entity Common Id Model							EagleML/accountingTransaction/accountingCashJournal/
Asset Identifiers Model							EagleML/accountingTransaction/accountingCashJournal/
entityName	string	1159	RULESDBO	ENTITY	ENTITY_NAME	CHAR(30)	Asset Properties Model							EagleML/accountingTransaction/accountingCashJournal/
maturityDate	date	38	SECURITYDBO	SECURITY_MASTER	PRIMARYMAT_ASSET_IDCHAR(100)DATE	DATE	EagleML/accountingTransaction/accountingCashJournal/	maturityDate	primaryAssetType	InstrumentId	1432	SECURITYDBO	SECURITY_MASTER	PRIMARY_ASSET_ID_TYPE	CHAR(30)
effectiveDate	date						EagleML/accountingTransaction/accountingCashJournal/	altAssetIdAndType Model		1795, 5501	effectiveDate
instance	integer	9388	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	INSTANCE		EagleML/accountingTransaction/accountingCashJournal/	issueName	string	961	SECURITYDBO	SECURITY_MASTER	ISSUE_NAME	instance
instance	integer	9388	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	INSTANCE		EagleML/accountingTransaction/accountingCashJournal/							instance
localCurrency	CurrencyCode	85	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	LOCAL_CURR	VARCHAR2(3)	EagleML/accountingTransaction/accountingCashJournal/	issueDescription	Description	962	SECURITYDBO	SECURITY_MASTER	ISSUE_DESCRIPTION	localCurrency
localCurrency	CurrencyCode	85	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	LOCAL_CURR	VARCHAR2(3)	EagleML/accountingTransaction/accountingCashJournal/							localCurrency
baseCurrency	CurrencyCode	86	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	BASE_CURR	VARCHAR2(3)	EagleML/accountingTransaction/accountingCashJournal/	ticker	InstrumentId	13	SECURITYDBO	SECURITY_MASTER	TICKER	baseCurrency
baseCurrency	CurrencyCode	86	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	BASE_CURR	VARCHAR2(3)	EagleML/accountingTransaction/accountingCashJournal/							baseCurrency
accountingBasis	string	21	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	ACCT_BASIS	VARCHAR2(5)	EagleML/accountingTransaction/accountingCashJournal/	securityAlias	integer	10	SECURITYDBO	SECURITY_MASTER	SECURITY_ALIAS	accountingBasis
accountingBasis	string	21	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	ACCT_BASIS	VARCHAR2(5)	EagleML/accountingTransaction/accountingCashJournal/							accountingBasis
longShortC	string	15	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	LNG_SHT_C	CHAR(1)	EagleML/accountingTransaction/accountingCashJournal/	assetCurrency	CurrencyCode	85	SECURITYDBO	SECURITY_MASTER	CURRENCY_CODE	CHAR(30)	longShortC
longShortC	string	15	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	LNG_SHT_C	CHAR(1)	EagleML/accountingTransaction/accountingCashJournal/								longShortC
backupSrcSysC	string		ESTAR	ESTAR_TRADED_CASH_ACTIVITY	BKUP_SRC_SYS_C		EagleML/accountingTransaction/accountingCashJournal/	investmentType	StringWithCodeScheme	11	SECURITYDBO	SECURITY_MASTER	INVESTMENT_TYPE	backupSrcSysC
backupSrcSysC	string		ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	BKUP_SRC_SYS_C		EagleML/accountingTransaction/accountingCashJournal/							backupSrcSysC
starPositionId	integer	830	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	POSN_ID		EagleML/accountingTransaction/accountingCashJournal/	processingSecurityType	StringWithCodeScheme	3931	SECURITYDBO	SECURITY_MASTER	PROCESS_SEC_TYPE	VARCHAR2(15)	starPositionId
starPositionId	integer	830	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	POSN_ID		EagleML/accountingTransaction/accountingCashJournal/								starPositionId
settleAsset	Asset Identifiers Model - see extra table			ESTAR_TRADED_CASH_ACTIVITY			EagleML/accountingTransaction/accountingCashJournal/	settleAsset/
settleAsset	Asset Identifiers Model - see extra table			ESTAR_SETTLED_CASH_ACTIVITY			EagleML/accountingTransaction/accountingCashJournal/	settleAsset/
shareClass	string	34	SECURITYDBO	SECURITY_MASTER	SECURITY_TYPE	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	SHARE_CLASS	VARCHAR2(10)	EagleML/accountingTransaction/accountingCashJournal/	issueCountryCode	CountryCode	1418	SECURITYDBO	SECURITY_MASTER	NRA_TAX_COUNTRY	shareClass
shareClass	string	34	ESTAR_SETTLED_CASH_ACTIVITY			ESTAR		SHARE_CLASS	VARCHAR2(10)	EagleML/accountingTransaction/accountingCashJournal/							shareClass
eventId	TransactionId	25	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	EVENT_ID	VARCHAR2(55)	EagleML/accountingTransaction/accountingCashJournal/	couponTypeCode	StringWithCodeScheme	97	SECURITYDBO	SECURITY_MASTER	COUPON_TYPE_CODE	eventId
eventId	TransactionId	25	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	EVENT_ID	VARCHAR2(55)	EagleML/accountingTransaction/accountingCashJournal/							eventId
starEventType	string	2362	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	EVENT_TYPE	VARCHAR2(25)	EagleML/accountingTransaction/accountingCashJournal/	starEventType
starEventType	string	2362	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	EVENT_TYPE	VARCHAR2(25)	EagleML/accountingTransaction/accountingCashJournal/	starEventType
eventType	string	53	ESTAR	SECURITYESTAR_TRADED_MASTERCASH_DETAILACTIVITYALT	CASH_	EVT_	TYP	VARCHAR2(	10)	EagleML/accountingTransaction/accountingCashJournal/
eventType	string	53	ESTAR	maturityDate	CASH_	EVT_	TYP	VARCHAR2(	10)	EagleML/accountingTransaction/accountingCashJournal/	date	38	SECURITYDBO	SECURITY_MASTER	MAT_DATE	DATE	EagleML/accountingTransaction/accountingCashJournal/maturityDate
localCurrency	CurrencyCode	85	eventType
localCurrency	CurrencyCode	85	eventType	ESTAR_SETTLED_CASH_ACTIVITY
eventSequence	integer	126	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	LOCAL_CURR	VARCHAR2(3)EVENT_SEQUENCE		EagleML/accountingTransaction/accountingCashJournal/localCurrency
eventSequence	integer	126	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	LOCAL_CURR	VARCHAR2(3)EVENT_SEQUENCE
baseCurrencyprocessDate	CurrencyCodedate	8630	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	BASEPROCESS_CURRVARCHAR2(3)DT	DATE	EagleML/accountingTransaction/accountingCashJournal/baseCurrencyprocessDate
baseCurrencyprocessDate	CurrencyCodedate	8630	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	BASEPROCESS_CURRVARCHAR2(3)DT	DATE
accountingBasisaccountingDate	stringdate	2136	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	ACCTACCOUNT_BASISVARCHAR2(5)DT	DATE	EagleML/accountingTransaction/accountingCashJournal/accountingBasisaccountingDate
accountingBasisaccountingDate	stringdate	2136	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	ACCTACCOUNT_BASISVARCHAR2(5)DT	DATE
longShortCmonthEndAccountingDate	stringdate	154733	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	LNGMONTH_END_SHTACCT_CCHAR(1)DT	DATE	EagleML/accountingTransaction/accountingCashJournal/longShortCmonthEndAccountingDate
longShortCmonthEndAccountingDate	stringdate	154733	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	LNGMONTH_END_SHTACCT_CCHAR(1)DT	DATE
shareClassunits	stringdecimal	3440	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	SHARE_CLASSUNITS	VARCHAR2NUMBER(1038,6)	EagleML/accountingTransaction/accountingCashJournal/shareClassunits
shareClassunits	stringdecimal	3440	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	SHARE_CLASSUNITS	VARCHAR2NUMBER(1038,6)
eventIdamount	TransactionIddecimal	25	ESTAR	50	Calculated Value - Tag 50 = ESTAR_TRADED_CASH_ACTIVITY				EVENT_ID	.AMOUNT + ESTAR_SETTLED_CASH_ACTIVITY.BREAKAGE_AMT_UNDER_B + ESTAR_SETTLED_CASH_ACTIVITY.BREAKAGE_AMT_OVER_B				EagleML/accountingTransaction/accountingCashJournal/eventId	amount
eventIdamount	TransactionIddecimal	25	ESTAR	50	Calculated Value - Tag 50 = SUM(ESTAR_TRADED_CASH_ACTIVITY.NET_AMOUNT_BASE)\SUM(ESTAR_SETTLED_CASH_ACTIVITY				EVENT_ID	starEventType	string	.NET_AMOUNT_BASE)
principal* (supported in 2017R1)	decimal	165	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	EVENT_TYPE	VARCHAR2(25)		PRINCIPAL		starEventType	string	EagleML/accountingTransaction/accountingCashJournal/starEventTypeprincipal		EagleML/accountingTransaction/accountingCashJournal/eventId	amount
principal* (supported in 2017R1)	decimal	165	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	EVENT_TYPE	VARCHAR2(25)		PRINCIPAL
eventTypeincome	stringdecimal	531985	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	CASH_EVT_TYP	VARCHAR2(10INCOME	NUMBER(38,6)	EagleML/accountingTransaction/accountingCashJournal/eventTypeincome
eventTypeincome	stringdecimal	531985	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	CASH_EVT_TYP	VARCHAR2(10INCOME	NUMBER(38,6)
navId	dateinteger	303196	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	PROCESSNAV_DTID	DATE		EagleML/accountingTransaction/accountingCashJournal/processDatenavId
navId	dateinteger	303196	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	PROCESSNAV_DTID	DATE
cashStatus	string	36	ESTAR	ESTAR_TRADED_54	Hardcode Value - TRADED for payables and receivables, SETTLED - for disbursements and receipts				EagleML/accountingTransaction/accountingCashJournal/cashStatus
cashCategory	string	36	ESTAR	62	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	ACCOUNTCASH_DTDATECATEGORY	VARCHAR2(50)	EagleML/accountingTransaction/accountingCashJournal/accountingDatecashCategory
cashCategory	string	ESTAR_SETTLED_CASH_ACTIVITY		62	ESTAR		ACCOUNTCASH_DTDATECATEGORY	VARCHAR2(50)
bankAlias	datestring	473316	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	MONTH_END_ACCT_DT	DATE	BANK_ALIAS		EagleML/accountingTransaction/accountingCashJournal/monthEndAccountingDatebankAlias
bankAlias	datestring	473316	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	MONTH_END_ACCT_DT	DATE	BANK_ALIAS
unitsautoSettleIndicator	decimalYesNoOptionEnum	4058	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	UNITS	NUMBER(38,6AUTO_SETTLE_INDICATOR	VARCHAR2(2)	EagleML/accountingTransaction/accountingCashJournal/unitsautoSettleIndicator
unitsautoSettleIndicator	decimalYesNoOptionEnum	4058	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	UNITS	NUMBER(38,6AUTO_SETTLE_INDICATOR	VARCHAR2(2)
corpActionId	integer	decimal60	50	ESTAR	ESTAR_TRADED_CASH_ACTIVITY		CORP_ACTION_ID		EagleML/accountingTransaction/accountingCashJournal/corpActionId
corpActionId	integer	decimal60	50	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY		CORP_ACTION_ID
ledgerBalanceEntitlement	string	3970	ESTAR	ESTAR_TRADED_CASH_ACTIVITY		LDGR_	BAL_	ENTITLEMENT		EagleML/accountingTransaction/accountingCashJournal/amount	ledgerBalanceEntitlement
ledgerBalanceEntitlement	string	3970	ESTAR	ESTAR_	SETTLED_CASH_ACTIVITY	LDGR_	BAL_	ENTITLEMENT		EagleML/accountingTransaction/accountingCashJournal/amount	ledgerBalanceEntitlement
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/settleAmountLocal
settleAmountLocal	decimal	5363	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	principal* (supported in 2017R1)	decimal			AMOUNT	NUMBER(38,6)
brokerCode	string	88	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	principal* (supported in 2017R1)	decimal	PRINCIPAL	BROKER_CODE	CHAR(20)	EagleML/accountingTransaction/accountingCashJournal/principalbrokerCode
brokerCode	string	88	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY			PRINCIPAL	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 Calculated Value - ""Tag 198 = SUM(SETTLED_CASH_DISP_LOTS.CURRENCY_GAIN)				EagleML/accountingTransaction/accountingCashJournal/cashStatuscurrencyGain
currencyLoss	decimal	62	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	CASH_CATEGORY	199	Calculated Value - Tag 198 = SUM(SETTLED_CASH_DISP_LOTS.CURRENCY_LOSS)				EagleML/accountingTransaction/accountingCashJournal/
ESTAR_SETTLED_CASH_ACTIVITY		62	ESTAR		CASH_CATEGORY
autoSettleIndicator	YesNoOptionEnum	58	currencyLoss
autoSettleIndicator	YesNoOptionEnum	58	localAssetCurrency	CurrencyCode	9061	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	AUTOLOCAL_SETTLEASSET_INDICATORCURRENCY	VARCHAR2(23)	EagleML/accountingTransaction/accountingCashJournal/autoSettleIndicatorlocalAssetCurrency
ESTAR_SETTLED_CASH_ACTIVITY			localAssetCurrency	CurrencyCode	9061	ESTAR		AUTOLOCAL_SETTLEASSET_INDICATORCURRENCY	VARCHAR2(23)
recPayPlanmasterTicketNumber	string	1831761	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	RECMASTER_PAYTICKET_PLANNUMBER	VARCHAR2(1555)	EagleML/accountingTransaction/accountingCashJournal/recPayPlanmasterTicketNumber
recPayPlanmasterTicketNumber	string	1831761	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	RECMASTER_PAYTICKET_PLANNUMBER	VARCHAR2(1555)
withholdingLocaltradeDateFxRate	decimal	85387	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	WITHHOLDING_LTRADE_DT_FX_RATE	NUMBER(38,612)	EagleML/accountingTransaction/accountingCashJournal/withholdingLocaltradeDateFxRate
withholdingLocaltradeDateFxRate	decimal	85387	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	WITHHOLDING_LTRADE_DT_FX_RATE	NUMBER(38,612)
corpActInstance	decimalinteger	8524268	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	RECLAIMCORP_ACT_L	NUMBER(38,6)	INSTANCE		EagleML/accountingTransaction/accountingCashJournal/reclaimLocalcorpActInstance
corpActInstance	decimalinteger	8524268	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	RECLAIMCORP_ACT_L	NUMBER(38,6)	INSTANCE
reclaimMethodnetAmountBase	stringdecimal	3912	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	RECLAIM_METHOD	CHAR(2)478	Calculated Value - Tag 478 = amount(Tag 50)/Current Fx Rate				EagleML/accountingTransaction/accountingCashJournal/reclaimMethod
reclaimMethodnetAmountBase	stringdecimal	3912	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	RECLAIM_METHOD	CHAR(2)478
contSettleDate	date	9968	ESTAR	netAmountBase
contSettleDate	date	9968	ESTAR	netAmountBase	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_ACCT_ACCT2DESC			EagleML/accountingTransaction/accountingCashJournal/recPayAccount2recPayAccountDesc
recPayAccountDesc	string	18261651	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	REC_PAY_ACCT_ACCT2DESC
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	NUMBER(38,6)	11781	ESTAR
SEC_FEE	NUMBER(38,6)	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)	brokerCode	clearingBroker	string	881236	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	CLEARING_BROKER_CODE	CHARVARCHAR2(2050)	EagleML/accountingTransaction/accountingCashJournal/brokerCodeclearingBroker
ESTAR_SETTLED_CASH_ACTIVITY		brokerCode	clearingBroker	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	198	Calculated Value - Tag 198 = SUM(SETTLED_CASH_DISP_LOTS.CURRENCY_GAIN)				EagleML/accountingTransaction/accountingCashJournal/currencyGain	currencyLoss	decimal	199	1295	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	TAX_WITHHOLDING_RATE	NUMBER(38,12)	EagleML/accountingTransaction/accountingCashJournal/	localAssetCurrency	CurrencyCode	9061taxWithholdingRate
taxWithholdingRate	decimal	ESTAR_SETTLED_CASH_ACTIVITY									1295	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_NUMBERVARCHAR2(55RATE	NUMBER(38,12)	EagleML/accountingTransaction/accountingCashJournal/masterTicketNumberspecialWithholdingRate
masterTicketNumberspecialWithholdingRate	stringdecimal	7611297	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	MASTERSPECIAL_TICKETWITHHOLDING_NUMBERVARCHAR2(55RATE	NUMBER(38,12)
sourceEventId	decimalTransactionId	87		ESTAR	ESTAR_TRADED_CASH_ACTIVITY	SOURCE_	EVENT_ID		EagleML/accountingTransaction/accountingCashJournal/tradeDateFxRatesourceEventId
sourceEventId	decimalTransactionId	87		ESTAR	ESTAR_	SETTLED_CASH_ACTIVITY		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	principalAmountBase* (supported in 2017R1)	decimal			119	ESTAR			TARGET_	ACCT_DATE
gainSwapLocal	decimal	11819	ESTAR	principalAmountBase* (supported in 2017R1)	decimal	ESTAR_TRADED_CASH_ACTIVITY	PRINCIPALGAIN_AMOUNTSWAP_BASEL	NUMBER(38,612)	EagleML/accountingTransaction/accountingCashJournal/principalAmountBasegainSwapLocal
gainSwapLocal	decimal	11819	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_	ESTAR
SWAP_B	GAIN_	NUMBER(38,12)	EagleML/accountingTransaction/accountingCashJournal/
SWAP_B	gainSwapBase	NUMBER(38,12)	EagleML/accountingTransaction/accountingCashJournal/
ESTAR_SETTLED_CASH_ACTIVITY	gainSwapBase
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_	FEE_
EXP_	B	NUMBER(38,12)	EagleML/accountingTransaction/accountingCashJournal/
termLoanFeeExpBase	B	NUMBER(38,12)	EagleML/accountingTransaction/accountingCashJournal/
termLoanFeeExpBase	ESTAR_SETTLED_CASH_ACTIVITY
commAmountBase	decimal
commAmountBase	decimal	498	ESTAR	ESTAR_TRADED_CASH_ACTIVITY
COMM_		498	ESTAR
COMM_	AMT_B
NUMBER(38,12)	AMT_B	EagleML/accountingTransaction/accountingCashJournal/
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_SWAPSEC_L	NUMBER(38,12)	ALIAS		EagleML/accountingTransaction/accountingCashJournal/gainSwapLocalstreamSecAlias
streamSecAlias	decimal	11819integer		ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	GAINSTREAM_SWAPSEC_L	NUMBER(38,12)	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	COMMCOUPON_AMT_B	NUMBER(38,12)	DATE		EagleML/accountingTransaction/accountingCashJournal/commAmountBasecouponDate
couponDate	decimaldate	4983460	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	COMMCOUPON_AMT_B	NUMBER(38,12)	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)
backupCouponEndDate	decimaldate	10122		ESTAR	ESTAR_TRADED_CASH_ACTIVITY	SEC_FEE_B	NUMBER(38,12)		BKUP_COUPON_END_DATE		EagleML/accountingTransaction/accountingCashJournal/secFeeBasebackupCouponEndDate
backupCouponEndDate	decimaldate	10122		ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	SEC_FEE_B	NUMBER(38,12)		BKUP_COUPON_END_DATE
origContSettleDate	decimaldate	10121		ESTAR	ESTAR_TRADED_CASH_ACTIVITY	STAMPORIG_DUTYCONT_TAXSETTLE_B	NUMBER(38,12)	DT		EagleML/accountingTransaction/accountingCashJournal/stampDutyTaxBaseorigContSettleDate
origContSettleDate	decimaldate	10121		ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	STAMPORIG_DUTYCONT_TAXSETTLE_B	NUMBER(38,12)	DT
periodicDistType	decimalstring	80781737	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	FEDPERIODIC_TAXDIST_WITHHOLD_B	NUMBER(38,12)	TYPE		EagleML/accountingTransaction/accountingCashJournal/fedTaxWithholdingBaseperiodicDistType
periodicDistType	decimalstring	80781737	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	FEDPERIODIC_TAXDIST_WITHHOLD_B	NUMBER(38,12)	TYPE
costLotOpenEventId	decimal	8079TransactionId		ESTAR	ESTAR_TRADED_CASH_ACTIVITY	STCOST_LOT_TAXOPEN_WITHHOLD_BNUMBER(38,12)EVT_ID		EagleML/accountingTransaction/accountingCashJournal/stTaxWithholdingBasecostLotOpenEventId
costLotOpenEventId	decimal	8079TransactionId		ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	STCOST_LOT_TAXOPEN_WITHHOLD_BNUMBER(38,12)EVT_ID
costLotCloseEventId	decimal	10759TransactionId		ESTAR	ESTAR_TRADED_CASH_ACTIVITY	TAX_AMT_B	NUMBER(38,12)	COST_LOT_CLOSE_EVT_ID		EagleML/accountingTransaction/accountingCashJournal/taxAmountBasecostLotCloseEventId
costLotCloseEventId	decimal	10759TransactionId		ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	TAX_AMT_B	NUMBER(38,12)	COST_LOT_CLOSE_EVT_ID
corpActionType	decimal	2712string		ESTAR	ESTAR_TRADED_CASH_ACTIVITY	BUCORP_WTHHLDACTION_L	NUMBER(38,12)	TYPE		EagleML/accountingTransaction/accountingCashJournal/buWithholdingLocalcorpActionType
corpActionType	decimal	2712string		ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	BUCORP_WTHHLDACTION_L	NUMBER(38,12)	TYPE
cashAccountName	decimalstring	271311696	ESTAR	ESTAR_TRADED_CASH_ACTIVITY	BUCASH_WTHHLD_BNUMBER(38,12)ACCT_NAME		EagleML/accountingTransaction/accountingCashJournal/buWithholdingBasecashAccountName
cashAccountName	decimalstring	271311696	ESTAR	ESTAR_SETTLED_CASH_ACTIVITY	BUCASH_WTHHLD_BNUMBER(38,12)ACCT_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 7

New Version Current

Key