Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 10 Current »


Note

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


ElementValue Type Star TagEagle DBDB TableDB FieldData TypeXpath
objectTypeObjectTypeEnum
Hardcoded Value = AccountingCashJournal
EagleML/accountingTransaction/accountingCashJournal/objectType
objectIdObjectId
Hardcoded Value = AccountingCashJournal
EagleML/accountingTransaction/accountingCashJournal/objectId
objectDescriptionFeedTypeEnum
Hardcoded Value = ACCOUNTING
EagleML/accountingTransaction/accountingCashJournal/objectDescription
updateTimestampdateTime
ESTARESTAR_TRADED_CASH_ACTIVITYSYSTEM_DATEDATEEagleML/accountingTransaction/accountingCashJournal/updateTimestamp
updateSourcestring944ESTARESTAR_TRADED_CASH_ACTIVITYUPDATE_SOURCEVARCHAR2(32)EagleML/accountingTransaction/accountingCashJournal/updateSource
Entity Common Id ModelEagleML/accountingTransaction/accountingCashJournal/
Asset Identifiers ModelEagleML/accountingTransaction/accountingCashJournal/
Asset Properties ModelEagleML/accountingTransaction/accountingCashJournal/
maturityDatedate38SECURITYDBOSECURITY_MASTERMAT_DATEDATEEagleML/accountingTransaction/accountingCashJournal/maturityDate
effectiveDatedate




EagleML/accountingTransaction/accountingCashJournal/effectiveDate
instanceinteger9388ESTARESTAR_TRADED_CASH_ACTIVITYINSTANCE
EagleML/accountingTransaction/accountingCashJournal/instance
ESTAR_SETTLED_CASH_ACTIVITY
localCurrencyCurrencyCode85ESTARESTAR_TRADED_CASH_ACTIVITYLOCAL_CURRVARCHAR2(3)EagleML/accountingTransaction/accountingCashJournal/localCurrency
ESTAR_SETTLED_CASH_ACTIVITY
baseCurrencyCurrencyCode86ESTARESTAR_TRADED_CASH_ACTIVITYBASE_CURRVARCHAR2(3)EagleML/accountingTransaction/accountingCashJournal/baseCurrency
ESTAR_SETTLED_CASH_ACTIVITY
accountingBasisstring21ESTARESTAR_TRADED_CASH_ACTIVITYACCT_BASISVARCHAR2(5)EagleML/accountingTransaction/accountingCashJournal/accountingBasis
ESTAR_SETTLED_CASH_ACTIVITY
longShortCstring15ESTARESTAR_TRADED_CASH_ACTIVITYLNG_SHT_CCHAR(1)EagleML/accountingTransaction/accountingCashJournal/longShortC
ESTAR_SETTLED_CASH_ACTIVITY
backupSrcSysCstring
ESTARESTAR_TRADED_CASH_ACTIVITYBKUP_SRC_SYS_C
EagleML/accountingTransaction/accountingCashJournal/backupSrcSysC
ESTAR_SETTLED_CASH_ACTIVITY
starPositionIdinteger830ESTARESTAR_TRADED_CASH_ACTIVITYPOSN_ID
EagleML/accountingTransaction/accountingCashJournal/starPositionId
ESTAR_SETTLED_CASH_ACTIVITY
settleAssetAsset Identifiers Model - see extra tableESTAR_TRADED_CASH_ACTIVITY

EagleML/accountingTransaction/accountingCashJournal/settleAsset/
ESTAR_SETTLED_CASH_ACTIVITY
shareClassstring34ESTARESTAR_TRADED_CASH_ACTIVITYSHARE_CLASSVARCHAR2(10)EagleML/accountingTransaction/accountingCashJournal/shareClass
ESTAR_SETTLED_CASH_ACTIVITY
eventIdTransactionId25ESTARESTAR_TRADED_CASH_ACTIVITYEVENT_IDVARCHAR2(55)EagleML/accountingTransaction/accountingCashJournal/eventId
ESTAR_SETTLED_CASH_ACTIVITY
starEventTypestring2362ESTARESTAR_TRADED_CASH_ACTIVITYEVENT_TYPEVARCHAR2(25)EagleML/accountingTransaction/accountingCashJournal/starEventType
ESTAR_SETTLED_CASH_ACTIVITY
eventTypestring53ESTARESTAR_TRADED_CASH_ACTIVITYCASH_EVT_TYPVARCHAR2(10)EagleML/accountingTransaction/accountingCashJournal/eventType
ESTAR_SETTLED_CASH_ACTIVITY
eventSequenceinteger126ESTARESTAR_TRADED_CASH_ACTIVITYEVENT_SEQUENCE
EagleML/accountingTransaction/accountingCashJournal/
ESTAR_SETTLED_CASH_ACTIVITY
processDatedate30ESTARESTAR_TRADED_CASH_ACTIVITYPROCESS_DTDATEEagleML/accountingTransaction/accountingCashJournal/processDate
ESTAR_SETTLED_CASH_ACTIVITY
accountingDatedate36ESTARESTAR_TRADED_CASH_ACTIVITYACCOUNT_DTDATEEagleML/accountingTransaction/accountingCashJournal/accountingDate
ESTAR_SETTLED_CASH_ACTIVITY
monthEndAccountingDatedate4733ESTARESTAR_TRADED_CASH_ACTIVITYMONTH_END_ACCT_DTDATEEagleML/accountingTransaction/accountingCashJournal/monthEndAccountingDate
ESTAR_SETTLED_CASH_ACTIVITY
unitsdecimal40ESTARESTAR_TRADED_CASH_ACTIVITYUNITSNUMBER(38,6)EagleML/accountingTransaction/accountingCashJournal/units
ESTAR_SETTLED_CASH_ACTIVITY
amountdecimal50Calculated Value - Tag 50 = ESTAR_TRADED_CASH_ACTIVITY.AMOUNT + ESTAR_SETTLED_CASH_ACTIVITY.BREAKAGE_AMT_UNDER_B + ESTAR_SETTLED_CASH_ACTIVITY.BREAKAGE_AMT_OVER_BEagleML/accountingTransaction/accountingCashJournal/amount
Calculated Value - Tag 50 = SUM(ESTAR_TRADED_CASH_ACTIVITY.NET_AMOUNT_BASE)\SUM(ESTAR_SETTLED_CASH_ACTIVITY.NET_AMOUNT_BASE)
principal*
(supported in  2017R1)		decimal165ESTARESTAR_TRADED_CASH_ACTIVITYPRINCIPAL
EagleML/accountingTransaction/accountingCashJournal/principal
ESTAR_SETTLED_CASH_ACTIVITY
incomedecimal1985ESTARESTAR_TRADED_CASH_ACTIVITYINCOMENUMBER(38,6)EagleML/accountingTransaction/accountingCashJournal/income
ESTAR_SETTLED_CASH_ACTIVITY
navIdinteger3196ESTARESTAR_TRADED_CASH_ACTIVITYNAV_ID
EagleML/accountingTransaction/accountingCashJournal/navId
ESTAR_SETTLED_CASH_ACTIVITY
cashStatusstring54Hardcode Value - TRADED for payables and receivables, SETTLED - for disbursements and receiptsEagleML/accountingTransaction/accountingCashJournal/cashStatus
cashCategorystring62ESTARESTAR_TRADED_CASH_ACTIVITYCASH_CATEGORYVARCHAR2(50)EagleML/accountingTransaction/accountingCashJournal/cashCategory
ESTAR_SETTLED_CASH_ACTIVITY
bankAliasstring16ESTARESTAR_TRADED_CASH_ACTIVITYBANK_ALIAS
EagleML/accountingTransaction/accountingCashJournal/bankAlias
ESTAR_SETTLED_CASH_ACTIVITY
autoSettleIndicatorYesNoOptionEnum58ESTARESTAR_TRADED_CASH_ACTIVITYAUTO_SETTLE_INDICATORVARCHAR2(2)EagleML/accountingTransaction/accountingCashJournal/autoSettleIndicator
ESTAR_SETTLED_CASH_ACTIVITY
corpActionIdinteger60ESTARESTAR_TRADED_CASH_ACTIVITYCORP_ACTION_ID
EagleML/accountingTransaction/accountingCashJournal/corpActionId
ESTAR_SETTLED_CASH_ACTIVITY
ledgerBalanceEntitlementstring3970ESTARESTAR_TRADED_CASH_ACTIVITYLDGR_BAL_ENTITLEMENT
EagleML/accountingTransaction/accountingCashJournal/ledgerBalanceEntitlement
ESTAR_SETTLED_CASH_ACTIVITY
accountingPlaninteger999ESTARESTAR_TRADED_CASH_ACTIVITYACCTG_PLAN
EagleML/accountingTransaction/accountingCashJournal/accountingPlan
ESTAR_SETTLED_CASH_ACTIVITY
positingPlaninteger913ESTARESTAR_TRADED_CASH_ACTIVITYPOSTING_PLAN
EagleML/accountingTransaction/accountingCashJournal/positingPlan
ESTAR_SETTLED_CASH_ACTIVITY
recPayPlanstring1831ESTARESTAR_TRADED_CASH_ACTIVITYREC_PAY_PLANVARCHAR2(15)EagleML/accountingTransaction/accountingCashJournal/recPayPlan
ESTAR_SETTLED_CASH_ACTIVITY
withholdingLocaldecimal853ESTARESTAR_TRADED_CASH_ACTIVITYWITHHOLDING_LNUMBER(38,6)EagleML/accountingTransaction/accountingCashJournal/withholdingLocal
ESTAR_SETTLED_CASH_ACTIVITY
reclaimLocaldecimal852ESTARESTAR_TRADED_CASH_ACTIVITYRECLAIM_LNUMBER(38,6)EagleML/accountingTransaction/accountingCashJournal/reclaimLocal
ESTAR_SETTLED_CASH_ACTIVITY
reclaimMethodstring3912ESTARESTAR_TRADED_CASH_ACTIVITYRECLAIM_METHODCHAR(2)EagleML/accountingTransaction/accountingCashJournal/reclaimMethod
ESTAR_SETTLED_CASH_ACTIVITY
batchEventIdstring701ESTARESTAR_TRADED_CASH_ACTIVITYBATCH_EVENT_ID
EagleML/accountingTransaction/accountingCashJournal/batchEventId
ESTAR_SETTLED_CASH_ACTIVITY
contSettleDatedate9968ESTARESTAR_TRADED_CASH_ACTIVITYCONT_SETTLE_DTDATEEagleML/accountingTransaction/accountingCashJournal/contSettleDate
ESTAR_SETTLED_CASH_ACTIVITY
linkEventIdTransactionId28ESTARESTAR_TRADED_CASH_ACTIVITYLINK_EVENT_IDVARCHAR2(55)EagleML/accountingTransaction/accountingCashJournal/linkEventId
ESTAR_SETTLED_CASH_ACTIVITY
targetEventIdstring26ESTARESTAR_TRADED_CASH_ACTIVITYTARGET_EVT_IDVARCHAR2(55)EagleML/accountingTransaction/accountingCashJournal/targetEventId
ESTAR_SETTLED_CASH_ACTIVITY
eventReasonstring56ESTARESTAR_TRADED_CASH_ACTIVITYEVENT_REASONVARCHAR2(55)EagleML/accountingTransaction/accountingCashJournal/eventReason
ESTAR_SETTLED_CASH_ACTIVITY
cancelEventIdTransactionId501ESTARESTAR_TRADED_CASH_ACTIVITYCANCEL_EVT_ID
EagleML/accountingTransaction/accountingCashJournal/cancelEventId
ESTAR_SETTLED_CASH_ACTIVITY
cancelSequenceinteger226ESTARESTAR_TRADED_CASH_ACTIVITYCANCEL_SEQUENCE
EagleML/accountingTransaction/accountingCashJournal/cancelSequence
ESTAR_SETTLED_CASH_ACTIVITY
recPayAccount2string1826ESTARESTAR_TRADED_CASH_ACTIVITYREC_PAY_ACCT2
EagleML/accountingTransaction/accountingCashJournal/recPayAccount2
ESTAR_SETTLED_CASH_ACTIVITY
principalBreakageUnderdecimal10134ESTARESTAR_TRADED_CASH_ACTIVITYPRINCIPAL_BREAKAGE_UNDER
EagleML/accountingTransaction/accountingCashJournal/principalBreakageUnder
ESTAR_SETTLED_CASH_ACTIVITY
principalBreakageOverdecimal10135ESTARESTAR_TRADED_CASH_ACTIVITYPRINCIPAL_BREAKAGE_OVER
EagleML/accountingTransaction/accountingCashJournal/principalBreakageOver
ESTAR_SETTLED_CASH_ACTIVITY
incomeBreakageUnderdecimal10136ESTARESTAR_TRADED_CASH_ACTIVITYINCOME_BREAKAGE_UNDER
EagleML/accountingTransaction/accountingCashJournal/incomeBreakageUnder
ESTAR_SETTLED_CASH_ACTIVITY
incomeBreakageOverdecimal10137ESTARESTAR_TRADED_CASH_ACTIVITYINCOME_BREAKAGE_OVER
EagleML/accountingTransaction/accountingCashJournal/incomeBreakageOver
ESTAR_SETTLED_CASH_ACTIVITY
otherFeeLocaldecimal3752ESTARESTAR_TRADED_CASH_ACTIVITYOTHER_FEE_LOCALNUMBER(38,6)EagleML/accountingTransaction/accountingCashJournal/otherFeeLocal
ESTAR_SETTLED_CASH_ACTIVITY
stampDutyTaxLocaldecimal51ESTARESTAR_TRADED_CASH_ACTIVITYSTAMP_DUTY_TAX_LNUMBER(38,6)EagleML/accountingTransaction/accountingCashJournal/stampDutyTaxLocal
ESTAR_SETTLED_CASH_ACTIVITY
commAmountLocaldecimal47ESTARESTAR_TRADED_CASH_ACTIVITYCOMM_AMT_LNUMBER(38,6)EagleML/accountingTransaction/accountingCashJournal/commAmountLocal
ESTAR_SETTLED_CASH_ACTIVITY
taxAmountLocaldecimal46ESTARESTAR_TRADED_CASH_ACTIVITYTAX_AMT_LNUMBER(38,6)EagleML/accountingTransaction/accountingCashJournal/taxAmountLocal
ESTAR_SETTLED_CASH_ACTIVITY
secFeedecimal48ESTARESTAR_TRADED_CASH_ACTIVITYSEC_FEENUMBER(38,6)EagleML/accountingTransaction/accountingCashJournal/secFee
ESTAR_SETTLED_CASH_ACTIVITY
backupPricedecimal
ESTARESTAR_TRADED_CASH_ACTIVITYBKUP_PRICE
EagleML/accountingTransaction/accountingCashJournal/backupPrice
ESTAR_SETTLED_CASH_ACTIVITY
settleAmountLocaldecimal5363Hardcode Value - 0EagleML/accountingTransaction/accountingCashJournal/settleAmountLocal
ESTARESTAR_SETTLED_CASH_ACTIVITYAMOUNTNUMBER(38,6)
brokerCodestring88ESTARESTAR_TRADED_CASH_ACTIVITYBROKER_CODECHAR(20)EagleML/accountingTransaction/accountingCashJournal/brokerCode
ESTAR_SETTLED_CASH_ACTIVITY
dividendRatedecimal5897ESTARESTAR_TRADED_CASH_ACTIVITYDIVIDEND_RATENUMBER(28,12)EagleML/accountingTransaction/accountingCashJournal/dividendRate
ESTAR_SETTLED_CASH_ACTIVITY
currencyGaindecimal198Calculated Value - Tag 198 = SUM(SETTLED_CASH_DISP_LOTS.CURRENCY_GAIN)EagleML/accountingTransaction/accountingCashJournal/currencyGain
currencyLossdecimal199Calculated Value - Tag 198 = SUM(SETTLED_CASH_DISP_LOTS.CURRENCY_LOSS)EagleML/accountingTransaction/accountingCashJournal/currencyLoss
localAssetCurrencyCurrencyCode9061ESTARESTAR_TRADED_CASH_ACTIVITYLOCAL_ASSET_CURRENCYVARCHAR2(3)EagleML/accountingTransaction/accountingCashJournal/localAssetCurrency
ESTAR_SETTLED_CASH_ACTIVITY
masterTicketNumberstring761ESTARESTAR_TRADED_CASH_ACTIVITYMASTER_TICKET_NUMBERVARCHAR2(55)EagleML/accountingTransaction/accountingCashJournal/masterTicketNumber
ESTAR_SETTLED_CASH_ACTIVITY
tradeDateFxRatedecimal87ESTARESTAR_TRADED_CASH_ACTIVITYTRADE_DT_FX_RATENUMBER(38,12)EagleML/accountingTransaction/accountingCashJournal/tradeDateFxRate
ESTAR_TRADED_CASH_ACTIVITY\ESTAR_SETTLED_CASH_ACTIVITY
corpActInstanceinteger4268ESTARESTAR_TRADED_CASH_ACTIVITYCORP_ACT_INSTANCE
EagleML/accountingTransaction/accountingCashJournal/corpActInstance
ESTAR_SETTLED_CASH_ACTIVITY
netAmountBasedecimal478Calculated Value - Tag 478 = amount(Tag 50)/Current Fx RateEagleML/accountingTransaction/accountingCashJournal/netAmountBase
SUM(ESTAR_TRADED_CASH_ACTIVITY.NET_AMOUNT_BASE)\SUM(ESTAR_SETTLED_CASH_ACTIVITY.NET_AMOUNT_BASE)
principalAmountBase*
(supported in  2017R1)		decimal169ESTARESTAR_TRADED_CASH_ACTIVITYPRINCIPAL_AMOUNT_BASENUMBER(38,6)EagleML/accountingTransaction/accountingCashJournal/principalAmountBase
ESTAR_SETTLED_CASH_ACTIVITY
incomeAmountBasedecimal1986ESTARESTAR_TRADED_CASH_ACTIVITYINCOME_AMOUNT_BASENUMBER(38,6)EagleML/accountingTransaction/accountingCashJournal/incomeAmountBase
ESTAR_SETTLED_CASH_ACTIVITY
recPayAccountstring1825ESTARESTAR_TRADED_CASH_ACTIVITYREC_PAY_ACCT
EagleML/accountingTransaction/accountingCashJournal/recPayAccount
ESTAR_SETTLED_CASH_ACTIVITY
recPayAccountDescstring1651ESTARESTAR_TRADED_CASH_ACTIVITYREC_PAY_ACCT_DESC
EagleML/accountingTransaction/accountingCashJournal/recPayAccountDesc
ESTAR_SETTLED_CASH_ACTIVITY
reclaimAmountBasedecimal851ESTARESTAR_TRADED_CASH_ACTIVITYRECLAIM_AMOUNT_BASENUMBER(38,6)EagleML/accountingTransaction/accountingCashJournal/reclaimAmountBase
ESTAR_SETTLED_CASH_ACTIVITY
taxExpenseBasedecimal854ESTARESTAR_TRADED_CASH_ACTIVITYTAX_EXPENSE_BASENUMBER(38,6)EagleML/accountingTransaction/accountingCashJournal/taxExpenseBase
ESTAR_SETTLED_CASH_ACTIVITY
breakageAmountUnderBasedecimal1995ESTARESTAR_TRADED_CASH_ACTIVITYBREAKAGE_AMT_UNDER_BNUMBER(38,6)EagleML/accountingTransaction/accountingCashJournal/breakageAmountUnderBase
ESTAR_SETTLED_CASH_ACTIVITY
breakageAmountOverBasedecimal1997ESTARESTAR_TRADED_CASH_ACTIVITYBREAKAGE_AMT_OVER_BNUMBER(38,6)EagleML/accountingTransaction/accountingCashJournal/breakageAmountOverBase
ESTAR_SETTLED_CASH_ACTIVITY
recPayAmountLocaldecimal11781ESTARESTAR_TRADED_CASH_ACTIVITYREC_PAY_AMT_L
EagleML/accountingTransaction/accountingCashJournal/recPayAmountLocal
ESTAR_SETTLED_CASH_ACTIVITY
recPayAmountBasedecimal11782ESTARESTAR_TRADED_CASH_ACTIVITYREC_PAY_AMT_B
EagleML/accountingTransaction/accountingCashJournal/recPayAmountBase
ESTAR_SETTLED_CASH_ACTIVITY
clearingBrokerstring1236ESTARESTAR_TRADED_CASH_ACTIVITYCLEARING_BROKERVARCHAR2(50)EagleML/accountingTransaction/accountingCashJournal/clearingBroker
ESTAR_SETTLED_CASH_ACTIVITY
taxReclaimRatedecimal1296ESTARESTAR_TRADED_CASH_ACTIVITYTAX_RECLAIM_RATENUMBER(38,12)EagleML/accountingTransaction/accountingCashJournal/taxReclaimRate
ESTAR_SETTLED_CASH_ACTIVITY
taxWithholdingRatedecimal1295ESTARESTAR_TRADED_CASH_ACTIVITYTAX_WITHHOLDING_RATENUMBER(38,12)EagleML/accountingTransaction/accountingCashJournal/taxWithholdingRate
ESTAR_SETTLED_CASH_ACTIVITY
specialReclaimRatedecimal1298ESTARESTAR_TRADED_CASH_ACTIVITYSPECIAL_RECLAIM_RATENUMBER(38,12)EagleML/accountingTransaction/accountingCashJournal/specialReclaimRate
ESTAR_SETTLED_CASH_ACTIVITY
specialWithholdingRatedecimal1297ESTARESTAR_TRADED_CASH_ACTIVITYSPECIAL_WITHHOLDING_RATENUMBER(38,12)EagleML/accountingTransaction/accountingCashJournal/specialWithholdingRate
ESTAR_SETTLED_CASH_ACTIVITY
sourceEventIdTransactionId
ESTARESTAR_TRADED_CASH_ACTIVITYSOURCE_EVENT_ID
EagleML/accountingTransaction/accountingCashJournal/sourceEventId
ESTAR_SETTLED_CASH_ACTIVITYSOURCE_REFERENCE_ID
targetAccountDatedate119ESTARESTAR_TRADED_CASH_ACTIVITYTARGET_ACCT_DATE
EagleML/accountingTransaction/accountingCashJournal/targetAccountDate
ESTAR_SETTLED_CASH_ACTIVITY
gainSwapLocaldecimal11819ESTARESTAR_TRADED_CASH_ACTIVITYGAIN_SWAP_LNUMBER(38,12)EagleML/accountingTransaction/accountingCashJournal/gainSwapLocal
ESTAR_SETTLED_CASH_ACTIVITY
lossSwapLocaldecimal11821ESTARESTAR_TRADED_CASH_ACTIVITYLOSS_SWAP_LNUMBER(38,12)EagleML/accountingTransaction/accountingCashJournal/lossSwapLocal
ESTAR_SETTLED_CASH_ACTIVITY
gainSwapBasedecimal11820ESTARESTAR_TRADED_CASH_ACTIVITYGAIN_SWAP_BNUMBER(38,12)EagleML/accountingTransaction/accountingCashJournal/gainSwapBase
ESTAR_SETTLED_CASH_ACTIVITY
lossSwapBasedecimal11822ESTARESTAR_TRADED_CASH_ACTIVITYLOSS_SWAP_BNUMBER(38,12)EagleML/accountingTransaction/accountingCashJournal/lossSwapBase
ESTAR_SETTLED_CASH_ACTIVITY
termLoanFeeIncLocaldecimal844ESTARESTAR_TRADED_CASH_ACTIVITYTERM_LOAN_FEE_INC_LNUMBER(38,12)EagleML/accountingTransaction/accountingCashJournal/termLoanFeeIncLocal
ESTAR_SETTLED_CASH_ACTIVITY
termLoanFeeIncBasedecimal845ESTARESTAR_TRADED_CASH_ACTIVITYTERM_LOAN_FEE_INC_BNUMBER(38,12)EagleML/accountingTransaction/accountingCashJournal/termLoanFeeIncBase
ESTAR_SETTLED_CASH_ACTIVITY
termLoanFeeExpLocaldecimal846ESTARESTAR_TRADED_CASH_ACTIVITYTERM_LOAN_FEE_EXP_LNUMBER(38,12)EagleML/accountingTransaction/accountingCashJournal/termLoanFeeExpLocal
ESTAR_SETTLED_CASH_ACTIVITY
termLoanFeeExpBasedecimal847ESTARESTAR_TRADED_CASH_ACTIVITYTERM_LOAN_FEE_EXP_BNUMBER(38,12)EagleML/accountingTransaction/accountingCashJournal/termLoanFeeExpBase
ESTAR_SETTLED_CASH_ACTIVITY
commAmountBasedecimal498ESTARESTAR_TRADED_CASH_ACTIVITYCOMM_AMT_BNUMBER(38,12)EagleML/accountingTransaction/accountingCashJournal/commAmountBase
ESTAR_SETTLED_CASH_ACTIVITY
otherFeeBasedecimal5708ESTARESTAR_TRADED_CASH_ACTIVITYOTHER_FEE_BNUMBER(38,12)EagleML/accountingTransaction/accountingCashJournal/otherFeeBase
ESTAR_SETTLED_CASH_ACTIVITY
secFeeBasedecimal10122ESTARESTAR_TRADED_CASH_ACTIVITYSEC_FEE_BNUMBER(38,12)EagleML/accountingTransaction/accountingCashJournal/secFeeBase
ESTAR_SETTLED_CASH_ACTIVITY
stampDutyTaxBasedecimal10121ESTARESTAR_TRADED_CASH_ACTIVITYSTAMP_DUTY_TAX_BNUMBER(38,12)EagleML/accountingTransaction/accountingCashJournal/stampDutyTaxBase
ESTAR_SETTLED_CASH_ACTIVITY
fedTaxWithholdingBasedecimal8078ESTARESTAR_TRADED_CASH_ACTIVITYFED_TAX_WITHHOLD_BNUMBER(38,12)EagleML/accountingTransaction/accountingCashJournal/fedTaxWithholdingBase
ESTAR_SETTLED_CASH_ACTIVITY
stTaxWithholdingBasedecimal8079ESTARESTAR_TRADED_CASH_ACTIVITYST_TAX_WITHHOLD_BNUMBER(38,12)EagleML/accountingTransaction/accountingCashJournal/stTaxWithholdingBase
ESTAR_SETTLED_CASH_ACTIVITY
streamSecAliasinteger
ESTARESTAR_TRADED_CASH_ACTIVITYSTREAM_SEC_ALIAS
EagleML/accountingTransaction/accountingCashJournal/streamSecAlias
ESTAR_SETTLED_CASH_ACTIVITY
taxAmountBasedecimal10759ESTARESTAR_TRADED_CASH_ACTIVITYTAX_AMT_BNUMBER(38,12)EagleML/accountingTransaction/accountingCashJournal/taxAmountBase
ESTAR_SETTLED_CASH_ACTIVITY
buWithholdingLocaldecimal2712ESTARESTAR_TRADED_CASH_ACTIVITYBU_WTHHLD_LNUMBER(38,12)EagleML/accountingTransaction/accountingCashJournal/buWithholdingLocal
ESTAR_SETTLED_CASH_ACTIVITY
buWithholdingBasedecimal2713ESTARESTAR_TRADED_CASH_ACTIVITYBU_WTHHLD_BNUMBER(38,12)EagleML/accountingTransaction/accountingCashJournal/buWithholdingBase
ESTAR_SETTLED_CASH_ACTIVITY
buWithholdingRatedecimal2762ESTARESTAR_TRADED_CASH_ACTIVITYBU_WTHHLD_RATENUMBER(38,12)EagleML/accountingTransaction/accountingCashJournal/buWithholdingRate
ESTAR_SETTLED_CASH_ACTIVITY
pricedecimal45ESTARESTAR_TRADED_CASH_ACTIVITYPRICENUMBER(38,12)EagleML/accountingTransaction/accountingCashJournal/price
ESTAR_SETTLED_CASH_ACTIVITY
cancelTypestring2981ESTARESTAR_TRADED_CASH_ACTIVITYCANCEL_TYPE
EagleML/accountingTransaction/accountingCashJournal/cancelType
ESTAR_SETTLED_CASH_ACTIVITY
cancelFlagYesNoOptionEnum10045ESTARESTAR_TRADED_CASH_ACTIVITYCANCEL_FLAG
EagleML/accountingTransaction/accountingCashJournal/cancelFlag
ESTAR_SETTLED_CASH_ACTIVITY
couponDatedate3460ESTARESTAR_TRADED_CASH_ACTIVITYCOUPON_DATE
EagleML/accountingTransaction/accountingCashJournal/couponDate
ESTAR_SETTLED_CASH_ACTIVITY
cashEventSpawnedstring751ESTARESTAR_TRADED_CASH_ACTIVITYCASH_EVENT_SPAWNEDVARCHAR2(1)EagleML/accountingTransaction/accountingCashJournal/cashEventSpawned
ESTAR_SETTLED_CASH_ACTIVITY
backupCouponEndDatedate
ESTARESTAR_TRADED_CASH_ACTIVITYBKUP_COUPON_END_DATE
EagleML/accountingTransaction/accountingCashJournal/backupCouponEndDate
ESTAR_SETTLED_CASH_ACTIVITY
origContSettleDatedate
ESTARESTAR_TRADED_CASH_ACTIVITYORIG_CONT_SETTLE_DT
EagleML/accountingTransaction/accountingCashJournal/origContSettleDate
ESTAR_SETTLED_CASH_ACTIVITY
periodicDistTypestring1737ESTARESTAR_TRADED_CASH_ACTIVITYPERIODIC_DIST_TYPE
EagleML/accountingTransaction/accountingCashJournal/periodicDistType
ESTAR_SETTLED_CASH_ACTIVITY
costLotOpenEventIdTransactionId
ESTARESTAR_TRADED_CASH_ACTIVITYCOST_LOT_OPEN_EVT_ID
EagleML/accountingTransaction/accountingCashJournal/costLotOpenEventId
ESTAR_SETTLED_CASH_ACTIVITY
costLotCloseEventIdTransactionId
ESTARESTAR_TRADED_CASH_ACTIVITYCOST_LOT_CLOSE_EVT_ID
EagleML/accountingTransaction/accountingCashJournal/costLotCloseEventId
ESTAR_SETTLED_CASH_ACTIVITY
corpActionTypestring
ESTARESTAR_TRADED_CASH_ACTIVITYCORP_ACTION_TYPE
EagleML/accountingTransaction/accountingCashJournal/corpActionType
ESTAR_SETTLED_CASH_ACTIVITY
cashAccountNamestring11696ESTARESTAR_TRADED_CASH_ACTIVITYCASH_ACCT_NAME
EagleML/accountingTransaction/accountingCashJournal/cashAccountName
ESTAR_SETTLED_CASH_ACTIVITY
cashAccountstring11697ESTARESTAR_TRADED_CASH_ACTIVITYCASH_ACCT
EagleML/accountingTransaction/accountingCashJournal/cashAccount
ESTAR_SETTLED_CASH_ACTIVITY
cashAccountAliasinteger11698ESTARESTAR_TRADED_CASH_ACTIVITYCASH_ACCT_ALIAS
EagleML/accountingTransaction/accountingCashJournal/cashAccountAlias
ESTAR_SETTLED_CASH_ACTIVITY
srcSysCstring98ESTARESTAR_TRADED_CASH_ACTIVITYSRC_SYS_C
EagleML/accountingTransaction/accountingCashJournal/srcSysC
ESTAR_SETTLED_CASH_ACTIVITY
detailIndicatorstring8468Hardcode Value - "TRADED ACTIVITY"EagleML/accountingTransaction/accountingCashJournal/detailIndicator
Hardcode Value - "SETTLED ACTIVITY"
settlementDatedate37Hardcode Value - ""EagleML/accountingTransaction/accountingCashJournal/settlementDate
ESTARESTAR_SETTLED_CASH_ACTIVITYEFFECTIVE_DTDATE
tradedDatedate35ESTARESTAR_TRADED_CASH_ACTIVITYEFFECTIVE_DTDATEEagleML/accountingTransaction/accountingCashJournal/tradedDate
ESTAR_TRADED_CASH_ACTIVITY\ESTAR_SETTLED_CASH_ACTIVITY
breakageUnderLocaldecimal1994Calculated Value - Tag 1994 = ESTAR_TRADED_CASH_ACTIVITY.PRINCIPAL_BREAKAGE_UNDER + ESTAR_TRADED_CASH_ACTIVITY.INCOME_BREAKAGE_UNDER
EagleML/accountingTransaction/accountingCashJournal/breakageUnderLocal
ESTAR_SETTLED_CASH_ACTIVITYBREAKAGE_AMT_UNDER_LNUMBER(38,12)
breakageOverLocaldecimal1996Calculated Value - Tag 1996 = ESTAR_TRADED_CASH_ACTIVITY.PRINCIPAL_BREAKAGE_OVER + ESTAR_TRADED_CASH_ACTIVITY.INCOME_BREAKAGE_OVER
EagleML/accountingTransaction/accountingCashJournal/breakageOverLocal
ESTAR_SETTLED_CASH_ACTIVITYBREAKAGE_AMT_OVER_LNUMBER(38,12)
recPayCategorystring1827ESTARESTAR_TRADED_CASH_ACTIVITYREC_PAY_ACCT_DESCVARCHAR2(100)EagleML/accountingTransaction/accountingCashJournal/recPayCategory
ESTAR_SETTLED_CASH_ACTIVITYREC_PAY_ACCT_DESCVARCHAR2(100)
currentFxRatedecimal96Calculated Value(Default SP - get_spot_rate) - Current Fx RateEagleML/accountingTransaction/accountingCashJournal/currentFxRate
fxRatedecimal484Calculated Value - Tag 484 = Fx Rate for Date (ESTAR_TRADED_CASH_ACTIVITY.EFFECTIVE_DT)EagleML/accountingTransaction/accountingCashJournal/fxRate
ESTAR_SETTLED_CASH_ACTIVITYTRADE_DT_FX_RATENUMBER(38,12)
totalRealizedGainLossBasedecimal5507Calculated Value - Tag 5507 = SETTLED_CASH_DISP_LOTS.CURRENCY_GAIN - SETTLED_CASH_DISP_LOTS.CURRENCY_LOSSEagleML/accountingTransaction/accountingCashJournal/totalRealizedGainLossBase
totalGainLossIddecimal178Calculated Value - Tag 178 = ESTAR_SETTLED_CASH_ACTIVITY.GAIN_CURRENCY - ESTAR_SETTLED_CASH_ACTIVITY.LOSS_CURRENCYEagleML/accountingTransaction/accountingCashJournal/totalGainLossId
settledUrglTotalBasedecimal11053Hardcode Value - 0EagleML/accountingTransaction/accountingCashJournal/settledUrglTotalBase
settleAmountBasedecimal479Hardcode Value - 0EagleML/accountingTransaction/accountingCashJournal/settleAmountBase
Calculated Value - Tag 479 = amount(Tag 5363)/Current Fx Rate
tradedNetAmountLocaldecimal11779Calculated Value - Tag 11779 = amount + Tag 1997 - Tag 1995EagleML/accountingTransaction/accountingCashJournal/tradedNetAmountLocal
Hardcode Value - 0
tradedNetAmountBasedecimal11780Calculated Value - Tag 11780 = Tag 11779/Current Fx RateEagleML/accountingTransaction/accountingCashJournal/tradedNetAmountBase
Hardcode Value - 0
netAmountBaseNewdecimal4309Calculated Value - Tag 4309 = Tag 478 + Tag 5507 + Tag 178(for unsettled) + Tag 50/(End date Fx Rate)(for settled)EagleML/accountingTransaction/accountingCashJournal/netAmountBaseNew
Calculated Value - Tag 4309 = Tag 479 + Tag 5507
notionalResetTypedecimal4409SECURITYDBOSWAPSNOTIONAL_RESET_TYPE
EagleML/accountingTransaction/accountingCashJournal/notionalResetType
reportTypedecimal1257Calculated Value - ACCTGDT = Accounting Date; MONTHDT = Month End Date; POSTDT = Post Date; SETTLEDT = Settlement Date; TRADEDT = Trade Date;EagleML/accountingTransaction/accountingCashJournal/reportType
regulatoryCategorydecimal12387RULESDBOENTITY_ACCT_BASIS_HISTREGULATORY_CATEGORYVARCHAR2(30)EagleML/accountingTransaction/accountingCashJournal/regulatoryCategory
regulatoryCategoryChangedstring891



EagleML/accountingTransaction/accountingCashJournal/regulatoryCategoryChanged
coupondecimal70SECURITYDBOSECURITY_MASTERCOUPON
EagleML/accountingTransaction/accountingCashJournal/coupon
quantityScaledecimal19SECURITYDBOSECURITY_MASTERTRADING_UNIT
EagleML/accountingTransaction/accountingCashJournal/quantityScale
quantityTypeStringWithCodeScheme12SECURITYDBOSECURITY_MASTERQUANTITY_TYPE
EagleML/accountingTransaction/accountingCashJournal/quantityType
priceMultiplierdecimal18SECURITYDBOSECURITY_MASTERPRICE_MULTIPLIER
EagleML/accountingTransaction/accountingCashJournal/priceMultiplier
dayCountBasisDayCountFraction471SECURITYDBOSECURITY_MASTERDAY_CNT
EagleML/accountingTransaction/accountingCashJournal/dayCountBasis
paymentFrequencyCodeStringWithCodeScheme472SECURITYDBOSECURITY_MASTERCOUPON_FREQ_CODE
EagleML/accountingTransaction/accountingCashJournal/paymentFrequencyCode
varRateFreqCodestring1788SECURITYDBOFIXED_INCOMEVAR_RATE_FREQ_CODE
EagleML/accountingTransaction/accountingCashJournal/varRateFreqCode
payRecIndicatorstring4590SECURITYDBOSWAPSPAY_RECEIVE_IND
EagleML/accountingTransaction/accountingCashJournal/payRecIndicator
optiondescrstring1364



EagleML/accountingTransaction/accountingCashJournal/optiondescr
interestPaymentTimingStringWithCodeScheme1523SECURITYDBOFIXED_INCOMEACCRUAL_METHOD
EagleML/accountingTransaction/accountingCashJournal/interestPaymentTiming
businessDayConventionBusinessDayConventionEnum1536SECURITYDBOFIXED_INCOMEINTEREST_METHOD_CODE
EagleML/accountingTransaction/accountingCashJournal/businessDayConvention
businessCalendarNamestring1480



EagleML/accountingTransaction/accountingCashJournal/businessCalendarName
premiumTypestring3302SECURITYDBODERIVATIVESPREMIUM_TYPE
EagleML/accountingTransaction/accountingCashJournal/premiumType
sectorNamestring1156



EagleML/accountingTransaction/accountingCashJournal/sectorName
reportViewstring7009resolved by panel


EagleML/accountingTransaction/accountingCashJournal/reportView
startDatedate220resolved by panel


EagleML/accountingTransaction/accountingCashJournal/startDate
endDatedate221resolved by panel


EagleML/accountingTransaction/accountingCashJournal/endDate
  • No labels