| objectType | Optional | ObjectTypeEnum |
| not stored in DB |
| EagleML/accountingTransaction/tradedCashActivity/objectType |
| objectId | Optional | ObjectId |
| not stored in DB |
| EagleML/accountingTransaction/tradedCashActivity/objectId |
| objectDescription | Optional | FeedTypeEnum |
| not stored in DB |
| EagleML/accountingTransaction/tradedCashActivity/objectDescription |
| updateTimestamp | Optional | dateTime |
| ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SYSTEM_DATE | DATE | EagleML/accountingTransaction/tradedCashActivity/updateTimestamp |
| customElements | Optional | CustomElements - ComplexType | EagleML/accountingTransaction/tradedCashActivity/customElements |
| updateSource | Required | string | 944 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | UPDATE_SOURCE | VARCHAR2(32) | EagleML/accountingTransaction/tradedCashActivity/updateSource |
| Entity Common Id Model | EagleML/accountingTransaction/tradedCashActivity/ |
| Entity Properties Model (extract only) | EagleML/accountingTransaction/tradedCashActivity/ |
| Asset Identifiers Model | EagleML/accountingTransaction/tradedCashActivity/ |
| Extended Asset Properties Model (extract only) | EagleML/accountingTransaction/tradedCashActivity/ |
| Extended CA Properties Model (extract only) | EagleML/accountingTransaction/tradedCashActivity/ |
| effectiveDate | Optional | date | 1109 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | EFFECTIVE_DT | DATE | EagleML/accountingTransaction/tradedCashActivity/effectiveDate |
| instance | Optional | integer | 9388 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INSTANCE | NUMBER(38) | EagleML/accountingTransaction/tradedCashActivity/instance |
| localCurrency | Optional | CurrencyCode | 63 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LOCAL_CURR | VARCHAR2(3) | EagleML/accountingTransaction/tradedCashActivity/localCurrency |
| baseCurrency | Optional | CurrencyCode | 86 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BASE_CURR | VARCHAR2(3) | EagleML/accountingTransaction/tradedCashActivity/baseCurrency |
| accountingBasis | Optional | string | 21 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | ACCT_BASIS | VARCHAR2(5) | EagleML/accountingTransaction/tradedCashActivity/accountingBasis |
| longShortC | Optional | string | 15 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LNG_SHT_C | CHAR(1) | EagleML/accountingTransaction/tradedCashActivity/longShortC |
| backupSrcSysC | Optional | string |
| ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BKUP_SRC_SYS_C | CHAR(1) | EagleML/accountingTransaction/tradedCashActivity/backupSrcSysC |
| starPositionId | Optional | integer | 830 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | POSN_ID | NUMBER(28) | EagleML/accountingTransaction/tradedCashActivity/starPositionId |
| settleAsset | Optional | Asset Identifiers Model - (see extra table) | EagleML/accountingTransaction/tradedCashActivity/settleAsset/ |
| shareClass | Optional | string | 34 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SHARE_CLASS | VARCHAR2(10) | EagleML/accountingTransaction/tradedCashActivity/shareClass |
| eventId | Optional | TransactionId | 25 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | EVENT_ID | VARCHAR2(55) | EagleML/accountingTransaction/tradedCashActivity/eventId |
| starEventType | Optional | string | 2362 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | EVENT_TYPE | VARCHAR2(25) | EagleML/accountingTransaction/tradedCashActivity/starEventType |
| eventType | Optional | string | 53 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CASH_EVT_TYP | VARCHAR2(10) | EagleML/accountingTransaction/tradedCashActivity/eventType | eventSequence |
| eventSequence | Optional | integer | 126 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | EVENT_SEQUENCE | NUMBER(28) | EagleML/accountingTransaction/tradedCashActivity/eventSequence |
| processDate | Optional | date | 30 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PROCESS_DT | DATE | EagleML/accountingTransaction/tradedCashActivity/processDate |
| accountingDate | Optional | integerdate | 12636 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | EVENTACCOUNT_SEQUENCENUMBER(28)DT | DATE | EagleML/accountingTransaction/tradedCashActivity/eventSequenceaccountingDate |
| processDatemonthEndAccountingDate | Optional | date | 304733 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PROCESSMONTH_END_ACCT_DT | DATE | EagleML/accountingTransaction/tradedCashActivity/processDatemonthEndAccountingDate |
| accountingDateunits | Optional | datedecimal | 3640 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | ACCOUNT_DT | DATEUNITS | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/accountingDateunits |
| monthEndAccountingDateamount | Optional | datedecimal | 473350 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | MONTH_END_ACCT_DT | DATEAMOUNT | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/monthEndAccountingDateamount |
| unitsprincipal | Optional | decimal | 40165 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | UNITSPRINCIPAL | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/unitsprincipal |
| amountincome | Optional | decimal | 501985 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | AMOUNTINCOME | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/amountincome |
| principalnavId | Optional | decimalinteger | 1653196 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PRINCIPALNAV_ID | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/principalnavId |
| incomecashStatus | Optional | decimalstring | 198554 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INCOMECASH_STATUS | NUMBERVARCHAR2(38,620) | EagleML/accountingTransaction/tradedCashActivity/incomecashStatus |
| navIdcashCategory | Optional | integerstring | 319662 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | NAVCASH_IDNUMBERCATEGORY | VARCHAR2(50) | EagleML/accountingTransaction/tradedCashActivity/navIdcashCategory |
| cashStatusbankAlias | Optional | string | 5416 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYCASH | BANK_STATUSALIAS | VARCHAR2(2025) | EagleML/accountingTransaction/tradedCashActivity/cashStatusbankAlias |
| cashCategoryautoSettleIndicator | Optional | stringYesNoOptionEnum | 6258 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYCASH | AUTO_SETTLE_CATEGORYINDICATOR | VARCHAR2(502) | EagleML/accountingTransaction/tradedCashActivity/cashCategoryautoSettleIndicator |
| bankAliascorpActionId | Optional | stringinteger | 1660 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BANKCORP_ACTION_ALIASID | VARCHAR2NUMBER(2522) | EagleML/accountingTransaction/tradedCashActivity/bankAliascorpActionId |
| autoSettleIndicatorledgerBalanceEntitlement | Optional | YesNoOptionEnumstring | 583970 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | AUTOLDGR_SETTLEBAL_INDICATORENTITLEMENT | VARCHAR2(21) | EagleML/accountingTransaction/tradedCashActivity/autoSettleIndicatorledgerBalanceEntitlement |
| corpActionIdaccountingPlan | Optional | integer | 60999 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYCORP | ACCTG_ACTION_IDPLAN | NUMBER(22) | EagleML/accountingTransaction/tradedCashActivity/corpActionIdaccountingPlan |
| ledgerBalanceEntitlementpositingPlan | Optional | stringinteger | 3970913 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYLDGR | POSTING_BAL_ENTITLEMENTVARCHAR2(1)PLAN | NUMBER | EagleML/accountingTransaction/tradedCashActivity/ledgerBalanceEntitlementpositingPlan |
| accountingPlanrecPayPlan | Optional | integerstring | 9991831 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | ACCTGREC_PAY_PLAN | NUMBERVARCHAR2(15) | EagleML/accountingTransaction/tradedCashActivity/accountingPlanrecPayPlan |
| positingPlanwithholdingLocal | Optional | integerdecimal | 913853 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | POSTINGWITHHOLDING_PLANL | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/positingPlanwithholdingLocal |
| recPayPlanreclaimLocal | Optional | stringdecimal | 1831852 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYREC | RECLAIM_PAY_PLANL | VARCHAR2NUMBER(1538,6) | EagleML/accountingTransaction/tradedCashActivity/recPayPlanreclaimLocal |
| withholdingLocalreclaimMethod | Optional | decimalstring | 8533912 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | WITHHOLDINGRECLAIM_LMETHOD | NUMBERCHAR(38,62) | EagleML/accountingTransaction/tradedCashActivity/withholdingLocalreclaimMethod |
| reclaimLocalbatchEventId | Optional | decimalTransactionId | 852701 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | RECLAIMBATCH_EVENT_LID | NUMBERVARCHAR2(38,655) | EagleML/accountingTransaction/tradedCashActivity/reclaimLocalbatchEventId |
| reclaimMethodcontSettleDate | Optional | stringdate | 39129968 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | RECLAIMCONT_SETTLE_METHODCHAR(2)DT | DATE | EagleML/accountingTransaction/tradedCashActivity/reclaimMethodcontSettleDate |
| batchEventIdlinkEventId | Optional | TransactionId | 70128 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BATCHLINK_EVENT_ID | VARCHAR2(55) | EagleML/accountingTransaction/tradedCashActivity/batchEventIdlinkEventId |
| contSettleDatetargetEventId | Optional | datestring | 996836 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CONTTARGET_SETTLEEVT_DTDATEID | VARCHAR2(55) | EagleML/accountingTransaction/tradedCashActivity/contSettleDatetargetEventId |
| linkEventIdeventReason | Optional | TransactionIdstring | 2856 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LINK_EVENT_IDREASON | VARCHAR2(55) | EagleML/accountingTransaction/tradedCashActivity/linkEventIdeventReason |
| targetEventIdcancelEventId | Optional | stringTransactionId | 36501 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TARGETCANCEL_EVT_ID | VARCHAR2(55) | EagleML/accountingTransaction/tradedCashActivity/targetEventIdcancelEventId |
| eventReasoncancelSequence | Optional | stringinteger | 56226 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | EVENTCANCEL_REASONSEQUENCE | VARCHAR2NUMBER(5528) | EagleML/accountingTransaction/tradedCashActivity/eventReasoncancelSequence |
| cancelEventIdrecPayAccount2 | Optional | TransactionIdstring | 5011826 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CANCELREC_EVTPAY_IDACCT2 | VARCHAR2(5510) | EagleML/accountingTransaction/tradedCashActivity/cancelEventIdrecPayAccount2 |
| cancelSequenceprincipalBreakageUnder | Optional | integerdecimal | 22610134 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CANCELPRINCIPAL_BREAKAGE_SEQUENCEUNDER | NUMBER(2838,6) | EagleML/accountingTransaction/tradedCashActivity/cancelSequenceprincipalBreakageUnder |
| recPayAccount2principalBreakageOver | Optional | stringdecimal | 182610135 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | RECPRINCIPAL_PAYBREAKAGE_ACCT2OVER | VARCHAR2NUMBER(1038,6) | EagleML/accountingTransaction/tradedCashActivity/recPayAccount2principalBreakageOver |
| principalBreakageUnderincomeBreakageUnder | Optional | decimal | 1013410136 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PRINCIPALINCOME_BREAKAGE_UNDER | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/principalBreakageUnderincomeBreakageUnder |
| principalBreakageOverincomeBreakageOver | Optional | decimal | 1013510137 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PRINCIPALINCOME_BREAKAGE_OVER | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/principalBreakageOverincomeBreakageOver |
| incomeBreakageUnderotherFeeLocal | Optional | decimal | 101363752 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INCOMEOTHER_BREAKAGEFEE_UNDERLOCAL | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/incomeBreakageUnderotherFeeLocal |
| incomeBreakageOverstampDutyTaxLocal | Optional | decimal | 1013751 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INCOMESTAMP_DUTY_BREAKAGETAX_OVERL | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/incomeBreakageOverstampDutyTaxLocal |
| otherFeeLocalcommAmountLocal | Optional | decimal | 375247 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | OTHERCOMM_FEEAMT_LOCALL | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/otherFeeLocalcommAmountLocal |
| stampDutyTaxLocaltaxAmountLocal | Optional | decimal | 5146 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | STAMPTAX_DUTY_TAXAMT_L | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/stampDutyTaxLocaltaxAmountLocal |
| commAmountLocalsecFee | Optional | decimal | 4748 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYCOMM | SEC_AMT_LFEE | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/commAmountLocalsecFee |
| taxAmountLocalbackupPrice | Optional | decimal | 46 |
| ESTAR | ESTAR_TRADED_CASH_ACTIVITYTAX | BKUP_AMT_LPRICE | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/taxAmountLocalbackupPrice |
| secFeesettleAmountLocal | Optional | decimal | 485363 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SECSETTLE_AMOUNT_FEELOCAL | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/secFeesettleAmountLocal |
| backupPricebrokerCode | Optional | stringdecimal | 88 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BKUPBROKER_PRICECODE | NUMBERCHAR(38,620) | EagleML/accountingTransaction/tradedCashActivity/backupPricebrokerCode |
| settleAmountLocaldividendRate | Optional | decimal | 5363368 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYSETTLE | DIVIDEND_AMOUNT_LOCALRATE | NUMBER(3828,612) | EagleML/accountingTransaction/tradedCashActivity/settleAmountLocaldividendRate |
| brokerCodecurrencyGain | Optional | stringdecimal | 88198 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BROKERGAIN_CODECURRENCY | CHARNUMBER(2038,6) | EagleML/accountingTransaction/tradedCashActivity/brokerCodecurrencyGain |
| dividendRatecurrencyLoss | Optional | decimal | 368199 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | DIVIDENDLOSS_RATECURRENCY | NUMBER(2838,126) | EagleML/accountingTransaction/tradedCashActivity/dividendRatecurrencyLoss |
| currencyGainlocalAssetCurrency | Optional | decimalCurrencyCode | 1989061 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | GAINLOCAL_ASSET_CURRENCY | NUMBERVARCHAR2(38,63) | EagleML/accountingTransaction/tradedCashActivity/currencyGainlocalAssetCurrency |
| currencyLossmasterTicketNumber | Optional | decimalstring | 199761 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LOSSMASTER_TICKET_CURRENCYNUMBER | NUMBERVARCHAR2(38,655) | EagleML/accountingTransaction/tradedCashActivity/currencyLossmasterTicketNumber |
| localAssetCurrencytradeDateFxRate | Optional | CurrencyCodedecimal | 906187 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LOCALTRADE_DT_ASSETFX_CURRENCYRATE | VARCHAR2NUMBER(338,12) | EagleML/accountingTransaction/tradedCashActivity/localAssetCurrencytradeDateFxRate |
| masterTicketNumbercorpActInstance | Optional | stringinteger | 7614268 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | MASTERCORP_TICKETACT_INSTANCE | NUMBER | VARCHAR2(55) | EagleML/accountingTransaction/tradedCashActivity/masterTicketNumbercorpActInstance |
| tradeDateFxRatenetAmountBase | Optional | decimal | 87478 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYTRADE | NET_DTAMOUNT_FX_RATEBASE | NUMBER(38,126) | EagleML/accountingTransaction/tradedCashActivity/tradeDateFxRatenetAmountBase |
| corpActInstanceprincipalAmountBase | Optional | integerdecimal | 4268169 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CORPPRINCIPAL_ACTAMOUNT_INSTANCEBASE | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/corpActInstanceprincipalAmountBase |
| netAmountBaseincomeAmountBase | Optional | decimal | 4781986 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | NETINCOME_AMOUNT_BASE | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/netAmountBaseincomeAmountBase |
| principalAmountBaserecPayAccount | Optional | decimalstring | 1691825 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PRINCIPALREC_AMOUNTPAY_BASEACCT | NUMBERVARCHAR2(38,610) | EagleML/accountingTransaction/tradedCashActivity/principalAmountBaserecPayAccount |
| incomeAmountBaserecPayAccountDesc | Optional | decimalstring | 19861651 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INCOMEREC_PAY_AMOUNTACCT_BASEDESC | NUMBERVARCHAR2(38,6100) | EagleML/accountingTransaction/tradedCashActivity/incomeAmountBaserecPayAccountDesc |
| recPayAccountreclaimAmountBase | Optional | stringdecimal | 1825851 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | RECRECLAIM_PAYAMOUNT_ACCTBASE | VARCHAR2NUMBER(1038,6) | EagleML/accountingTransaction/tradedCashActivity/recPayAccountreclaimAmountBase |
| recPayAccountDesctaxExpenseBase | Optional | stringdecimal | 1651854 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYREC | TAX_PAYEXPENSE_ACCT_DESCBASE | VARCHAR2NUMBER(10038,6) | EagleML/accountingTransaction/tradedCashActivity/recPayAccountDesctaxExpenseBase |
| reclaimAmountBasebreakageAmountUnderBase | Optional | decimal | 8511995 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | RECLAIMBREAKAGE_AMT_AMOUNTUNDER_BASEB | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/reclaimAmountBasebreakageAmountUnderBase |
| taxExpenseBasebreakageAmountOverBase | Optional | decimal | 8541997 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAXBREAKAGE_AMT_EXPENSEOVER_BASEB | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/taxExpenseBasebreakageAmountOverBase |
| breakageAmountUnderBaserecPayAmountLocal | Optional | decimal | 199511781 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BREAKAGEREC_PAY_AMT_UNDER_BL | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/breakageAmountUnderBaserecPayAmountLocal |
| breakageAmountOverBaserecPayAmountBase | Optional | decimal | 199711782 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BREAKAGEREC_PAY_AMT_OVER_B | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/breakageAmountOverBaserecPayAmountBase |
| recPayAmountLocalclearingBroker | Optional | decimalstring | 117811236 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | REC_PAY_AMT_L | NUMBER(38,6CLEARING_BROKER | VARCHAR2(50) | EagleML/accountingTransaction/tradedCashActivity/recPayAmountLocalclearingBroker |
| recPayAmountBasetaxReclaimRate | Optional | decimal | 117821296 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYREC | TAX_PAYRECLAIM_AMT_BRATE | NUMBER(38,612) | EagleML/accountingTransaction/tradedCashActivity/recPayAmountBasetaxReclaimRate |
| clearingBrokertaxWithholdingRate | Optional | stringdecimal | 12361295 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CLEARINGTAX_WITHHOLDING_BROKERRATE | VARCHAR2NUMBER(5038,12) | EagleML/accountingTransaction/tradedCashActivity/clearingBrokertaxWithholdingRate |
| taxReclaimRatespecialReclaimRate | Optional | decimal | 12961298 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAXSPECIAL_RECLAIM_RATE | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/taxReclaimRatespecialReclaimRate |
| taxWithholdingRatespecialWithholdingRate | Optional | decimal | 12951297 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAXSPECIAL_WITHHOLDING_RATE | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/taxWithholdingRatespecialWithholdingRate |
| specialReclaimRatesourceEventId | Optional | decimalTransactionId | 1298 |
| ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SPECIALSOURCE_RECLAIMEVENT_RATEID | NUMBERVARCHAR2(38,1255) | EagleML/accountingTransaction/tradedCashActivity/specialReclaimRatesourceEventId |
| specialWithholdingRatetargetAccountDate | Optional | decimaldate | 1297119 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SPECIALTARGET_WITHHOLDINGACCT_RATENUMBER(38,12)DATE | DATE | EagleML/accountingTransaction/tradedCashActivity/specialWithholdingRatetargetAccountDate |
| sourceEventIdgainSwapLocal | Optional | decimalTransactionId | 11819 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SOURCEGAIN_EVENTSWAP_IDL | VARCHAR2NUMBER(5538,12) | EagleML/accountingTransaction/tradedCashActivity/sourceEventIdgainSwapLocal |
| targetAccountDatelossSwapLocal | Optional | datedecimal | 11911821 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TARGETLOSS_ACCTSWAP_DATEDATEL | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/targetAccountDatelossSwapLocal |
| gainSwapLocalgainSwapBase | Optional | decimal | 1181911820 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | GAIN_SWAP_LB | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/gainSwapLocalgainSwapBase |
| lossSwapLocallossSwapBase | Optional | decimal | 1182111822 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LOSS_SWAP_LB | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/lossSwapLocallossSwapBase |
| gainSwapBasetermLoanFeeIncLocal | Optional | decimal | 11820844 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYGAIN_SWAP | _BTERM_LOAN_FEE_INC_L | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/gainSwapBasetermLoanFeeIncLocal |
| lossSwapBasetermLoanFeeIncBase | Optional | decimal | 11822845 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LOSS_SWAPTERM_LOAN_FEE_INC_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/lossSwapBasetermLoanFeeIncBase |
| termLoanFeeIncLocaltermLoanFeeExpLocal | Optional | decimal | 844846 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TERM_LOAN_FEE_INCEXP_L | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/termLoanFeeIncLocaltermLoanFeeExpLocal |
| termLoanFeeIncBasetermLoanFeeExpBase | Optional | decimal | 845847 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TERM_LOAN_FEE_INCEXP_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/termLoanFeeIncBasetermLoanFeeExpBase |
| termLoanFeeExpLocalcommAmountBase | Optional | decimal | 846498 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYTERM | COMM_LOAN_FEE_EXP_LAMT_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/termLoanFeeExpLocalcommAmountBase |
| termLoanFeeExpBaseotherFeeBase | Optional | decimal | 8475708 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TERM_LOANOTHER_FEE_EXP_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/termLoanFeeExpBaseotherFeeBase |
| commAmountBasesecFeeBase | Optional | decimal | 49810122 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | COMMSEC_AMTFEE_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/commAmountBasesecFeeBase |
| otherFeeBasestampDutyTaxBase | Optional | decimal | 570810121 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | OTHERSTAMP_DUTY_FEETAX_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/otherFeeBasestampDutyTaxBase |
| secFeeBasefedTaxWithholdingBase | Optional | decimal | 101228078 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SECFED_TAX_FEEWITHHOLD_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/secFeeBasefedTaxWithholdingBase |
| stampDutyTaxBasestTaxWithholdingBase | Optional | decimal | 101218079 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | STAMPST_DUTYTAX_TAXWITHHOLD_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/stampDutyTaxBasestTaxWithholdingBase |
| fedTaxWithholdingBasestreamSecAlias | Optional | decimal | 8078integer |
| ESTAR | ESTAR_TRADED_CASH_ACTIVITYFED | STREAM_TAXSEC_WITHHOLD_BALIAS | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/fedTaxWithholdingBasestreamSecAlias |
| stTaxWithholdingBasetaxAmountBase | Optional | decimal | 807910759 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | ST_TAX_WITHHOLDAMT_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/stTaxWithholdingBasetaxAmountBase |
| streamSecAliasbuWithholdingLocal | Optional | decimalinteger | 2712 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | STREAMBU_SECWTHHLD_ALIASL | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/streamSecAliasbuWithholdingLocal |
| taxAmountBasebuWithholdingBase | Optional | decimal | 107592713 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAXBU_AMTWTHHLD_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/taxAmountBasebuWithholdingBase |
| buWithholdingLocalbuWithholdingRate | Optional | decimal | 27122762 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BU_WTHHLD_LRATE | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/buWithholdingLocalbuWithholdingRate |
| buWithholdingBaseprice | Optional | decimal | 271345 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYBU_WTHHLD_B | PRICE | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/buWithholdingBaseprice |
| buWithholdingRatecancelType | Optional | decimalstring | 27622981 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYBU | CANCEL_WTHHLD_RATETYPE | NUMBERVARCHAR2(38,121) | EagleML/accountingTransaction/tradedCashActivity/buWithholdingRatecancelType |
| pricecancelFlag | Optional | decimalstring | 4510045 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PRICECANCEL_FLAG | NUMBERVARCHAR2(38,121) | EagleML/accountingTransaction/tradedCashActivity/pricecancelFlag |
| cancelTypecouponDate | Optional | stringdate | 29813460 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CANCELCOUPON_TYPEVARCHAR2(1)DATE | DATE | EagleML/accountingTransaction/tradedCashActivity/cancelTypecouponDate |
| cancelFlagcashEventSpawned | Optional | string | 10045751 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CANCELCASH_EVENT_FLAGSPAWNED | VARCHAR2(1) | EagleML/accountingTransaction/tradedCashActivity/cancelFlagcashEventSpawned |
| couponDatebackupCouponEndDate | Optional | date | 3460 |
| ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BKUP_COUPON_END_DATE | DATE | EagleML/accountingTransaction/tradedCashActivity/couponDatebackupCouponEndDate |
| cashEventSpawnedorigContSettleDate | Optional | string | 751date |
| ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CASHORIG_CONT_EVENTSETTLE_SPAWNEDVARCHAR2(1)DT | DATE | EagleML/accountingTransaction/tradedCashActivity/cashEventSpawnedorigContSettleDate |
| backupCouponEndDateperiodicDistType | Optional | stringdate | 1737 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYBKUP | PERIODIC_COUPONDIST_END_DATEDATETYPE | VARCHAR2(2) | EagleML/accountingTransaction/tradedCashActivity/backupCouponEndDateperiodicDistType |
| origContSettleDatecostLotOpenEventId | Optional | dateTransactionId |
| ESTAR | ESTAR_TRADED_CASH_ACTIVITYORIG | COST_LOT_CONTOPEN_SETTLEEVT_DTDATEID | VARCHAR2(55) | EagleML/accountingTransaction/tradedCashActivity/origContSettleDatecostLotOpenEventId |
| periodicDistTypecostLotCloseEventId | Optional | stringTransactionId | 1737 |
| ESTAR | ESTAR_TRADED_CASH_ACTIVITYPERIODIC_DIST | _TYPECOST_LOT_CLOSE_EVT_ID | VARCHAR2(255) | EagleML/accountingTransaction/tradedCashActivity/periodicDistTypecostLotCloseEventId |
| costLotOpenEventIdcorpActionType | Optional | TransactionIdstring |
| ESTAR | ESTAR_TRADED_CASH_ACTIVITYCOST_LOT_OPEN_EVT_ID_ACTIVITY | CORP_ACTION_TYPE | VARCHAR2(5550) | EagleML/accountingTransaction/tradedCashActivity/costLotOpenEventIdcorpActionType |
| costLotCloseEventIdcashAccountName | Optional | stringTransactionId | 11696 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYCOST | CASH_LOT_CLOSE_EVT_IDACCT_NAME | VARCHAR2(5550) | EagleML/accountingTransaction/tradedCashActivity/costLotCloseEventIdcashAccountName |
| corpActionTypecashAccount | Optional | string | 11697 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYCORP | CASH_ACTION_TYPEACCT | VARCHAR2(5020) | EagleML/accountingTransaction/tradedCashActivity/corpActionTypecashAccount |
| cashAccountNamecashAccountAlias | Optional | stringinteger | 1169611698 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CASH_ACCT_NAMEALIAS | VARCHAR2NUMBER(5038) | EagleML/accountingTransaction/tradedCashActivity/cashAccountNamecashAccountAlias | cashAccount
| srcSysC | Optional | string |
11697| 98 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY |
CASH| SRC_SYS_ |
ACCT| C | VARCHAR2( |
20| 25) | EagleML/accountingTransaction/tradedCashActivity/ |
cashAccountcashAccountAlias| srcSysC |
| To add the elements below, please set IncludeExtendedDetails=ALL or IncludeExtendedDetails=Y in the RTR. For more information, see Use Calculated IDs for Transactions. |
| calcTransactionId | Optional |
integerNUMBER(38)| string |
11698 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CASH_ACCT_ALIAS | | 2983 |
|
|
|
| EagleML/accountingTransaction/tradedCashActivity/calcTransactionId |
| calcMasterTransactionId | Optional | string | 2984 |
|
|
|
| EagleML/accountingTransaction/tradedCashActivity/ |
cashAccountAlias| calcMasterTransactionId |
| srcSysCcalcCancelTransactionId | Optional | string | 98 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SRC_SYS_C | VARCHAR2(25) | 2985 |
|
|
|
| EagleML/accountingTransaction/tradedCashActivity/srcSysCcalcCancelTransactionId |
| To add the |
elements | element below, please set |
IncludeExtendedDetails| IncludeAssetToBaseFxRate= |
ALL or IncludeExtendedDetails=| Y in the RTR |
| calcTransactionId | Optional | string | 2983. |
| assetToBaseFxRate | Optional | decimal | not stored in DB | EagleML/accountingTransaction/tradedCashActivity/assetToBaseFxRate |
| custodyBankAccountNumber | Optional | string |
| RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_ACCT_NUM | VARCHAR2(30) | EagleML/accountingTransaction/tradedCashActivity/ | calcTransactionIdcustodyBankAccountNumber |
calcMasterTransactionId| custodyBankCode | Optional | string | 2984 |
| RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_CODE | CHAR(20) | EagleML/accountingTransaction/tradedCashActivity/ | calcMasterTransactionIdcustodyBankCode |
calcCancelTransactionId| custodyBankDesc | Optional | string | 2985 |
| RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_DESC | CHAR(50) | EagleML/accountingTransaction/tradedCashActivity/ | calcCancelTransactionIdcustodyBankDesc |
