| 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/ |
updateSourceEntity Common Id Model | |
| Asset Identifiers Model | EagleML/accountingTransaction/tradedCashActivity/ |
| Extended Asset Properties Model (extract only) | EagleML/accountingTransaction/tradedCashActivity/ |
Entity | Extended CA Properties Model (extract only) | EagleML/accountingTransaction/tradedCashActivity/ |
Asset Identifiers Model |
| effectiveDate | Optional | date | 1109 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | EFFECTIVE_DT | DATE | EagleML/accountingTransaction/tradedCashActivity/ |
Extended Asset Properties Model (extract only| effectiveDate |
| instance | Optional | integer | 9388 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INSTANCE | NUMBER(38) | EagleML/accountingTransaction/tradedCashActivity/ |
Extended CA Properties Model (extract only| instance |
| localCurrency | Optional | CurrencyCode | 63 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LOCAL_CURR | VARCHAR2(3) | EagleML/accountingTransaction/tradedCashActivity/localCurrency |
| effectiveDatebaseCurrency | Optional | dateCurrencyCode | 110986 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | EFFECTIVEBASE_DTDATECURR | VARCHAR2(3) | EagleML/accountingTransaction/tradedCashActivity/effectiveDatebaseCurrency |
| instanceaccountingBasis | Optional | integerstring | 938821 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INSTANCEACCT_BASIS | NUMBERVARCHAR2(385) | EagleML/accountingTransaction/tradedCashActivity/instanceaccountingBasis |
| localCurrencylongShortC | Optional | CurrencyCodestring | 6315 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LOCALLNG_SHT_CURRC | VARCHAR2CHAR(31) | EagleML/accountingTransaction/tradedCashActivity/localCurrencylongShortC |
| baseCurrencybackupSrcSysC | Optional | CurrencyCodestring | 86 |
| ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BASE_CURR | VARCHAR2(3BKUP_SRC_SYS_C | CHAR(1) | EagleML/accountingTransaction/tradedCashActivity/baseCurrencybackupSrcSysC |
| accountingBasisstarPositionId | Optional | stringinteger | 21830 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | ACCT_BASIS | VARCHAR2(5POSN_ID | NUMBER(28) | EagleML/accountingTransaction/tradedCashActivity/starPositionId |
| settleAsset | Optional | Asset Identifiers Model - (see extra table) | EagleML/accountingTransaction/tradedCashActivity/accountingBasissettleAsset/ |
| longShortCshareClass | Optional | string | 1534 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYLNG | SHARE_SHT_CCLASS | CHARVARCHAR2(110) | EagleML/accountingTransaction/tradedCashActivity/longShortCshareClass |
| backupSrcSysCeventId | Optional | stringTransactionId | 25 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BKUP_SRC_SYS_C | CHAR(1EVENT_ID | VARCHAR2(55) | EagleML/accountingTransaction/tradedCashActivity/backupSrcSysCeventId |
| starPositionIdstarEventType | Optional | integerstring | 8302362 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | POSN_ID | NUMBER(28) | EagleML/accountingTransaction/tradedCashActivity/starPositionId | settleAsset | Optional | Asset Identifiers Model - (see extra table | EVENT_TYPE | VARCHAR2(25) | EagleML/accountingTransaction/tradedCashActivity/settleAsset/starEventType |
| shareClasseventType | Optional | string | 3453 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SHARECASH_EVT_CLASSTYP | VARCHAR2(10) | EagleML/accountingTransaction/tradedCashActivity/shareClasseventType |
| eventIdeventSequence | Optional | TransactionIdinteger | 25126 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | EVENT_IDSEQUENCE | VARCHAR2NUMBER(5528) | EagleML/accountingTransaction/tradedCashActivity/eventIdeventSequence |
| starEventTypeprocessDate | Optional | stringdate | 236230 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | EVENTPROCESS_TYPEVARCHAR2(25)DT | DATE | EagleML/accountingTransaction/tradedCashActivity/starEventTypeprocessDate |
| eventTypeaccountingDate | Optional | stringdate | 5336 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYCASH | _EVTACCOUNT_TYPVARCHAR2(10)DT | DATE | EagleML/accountingTransaction/tradedCashActivity/eventTypeaccountingDate |
| eventSequencemonthEndAccountingDate | Optional | integerdate | 1264733 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | EVENT_SEQUENCE | NUMBER(28)MONTH_END_ACCT_DT | DATE | EagleML/accountingTransaction/tradedCashActivity/eventSequencemonthEndAccountingDate |
| processDateunits | Optional | datedecimal | 3040 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PROCESS_DT | DATEUNITS | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/processDateunits |
| accountingDateamount | Optional | datedecimal | 3650 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | ACCOUNT_DT | DATEAMOUNT | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/accountingDateamount |
| monthEndAccountingDateprincipal | Optional | datedecimal | 4733165 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | MONTH_END_ACCT_DT | DATEPRINCIPAL | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/monthEndAccountingDateprincipal |
| unitsincome | Optional | decimal | 401985 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | UNITSINCOME | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/unitsincome |
| amountnavId | Optional | decimalinteger | 503196 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | AMOUNTNAV_ID | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/amountnavId |
| principalcashStatus | Optional | decimalstring | 16554 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PRINCIPALCASH_STATUS | NUMBERVARCHAR2(38,620) | EagleML/accountingTransaction/tradedCashActivity/principalcashStatus |
| incomecashCategory | Optional | decimalstring | 198562 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INCOMECASH_CATEGORY | NUMBERVARCHAR2(38,650) | EagleML/accountingTransaction/tradedCashActivity/incomecashCategory |
| navIdbankAlias | Optional | integerstring | 319616 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | NAVBANK_IDNUMBERALIAS | VARCHAR2(25) | EagleML/accountingTransaction/tradedCashActivity/navIdbankAlias |
| cashStatusautoSettleIndicator | Optional | stringYesNoOptionEnum | 5458 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYCASH | AUTO_SETTLE_STATUSINDICATOR | VARCHAR2(202) | EagleML/accountingTransaction/tradedCashActivity/cashStatusautoSettleIndicator |
| cashCategorycorpActionId | Optional | stringinteger | 6260 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYCASH | CORP_ACTION_CATEGORYID | VARCHAR2NUMBER(5022) | EagleML/accountingTransaction/tradedCashActivity/cashCategorycorpActionId |
| bankAliasledgerBalanceEntitlement | Optional | string | 163970 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BANKLDGR_BAL_ALIASENTITLEMENT | VARCHAR2(251) | EagleML/accountingTransaction/tradedCashActivity/bankAliasledgerBalanceEntitlement |
| autoSettleIndicatoraccountingPlan | Optional | YesNoOptionEnuminteger | 58999 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYAUTO | ACCTG_SETTLE_INDICATORVARCHAR2(2)PLAN | NUMBER | EagleML/accountingTransaction/tradedCashActivity/autoSettleIndicatoraccountingPlan |
| corpActionIdpositingPlan | Optional | integer | 60913 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYCORP | POSTING_ACTION_IDPLAN | NUMBER(22) | EagleML/accountingTransaction/tradedCashActivity/corpActionIdpositingPlan |
| ledgerBalanceEntitlementrecPayPlan | Optional | string | 39701831 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LDGRREC_BALPAY_ENTITLEMENTPLAN | VARCHAR2(115) | EagleML/accountingTransaction/tradedCashActivity/ledgerBalanceEntitlementrecPayPlan |
| accountingPlanwithholdingLocal | Optional | integerdecimal | 999853 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | ACCTGWITHHOLDING_PLANL | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/accountingPlanwithholdingLocal |
| positingPlanreclaimLocal | Optional | integerdecimal | 913852 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | POSTINGRECLAIM_PLANL | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/positingPlanreclaimLocal |
| recPayPlanreclaimMethod | Optional | string | 18313912 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYREC | RECLAIM_PAY_PLANMETHOD | VARCHAR2CHAR(152) | EagleML/accountingTransaction/tradedCashActivity/recPayPlanreclaimMethod |
| withholdingLocalbatchEventId | Optional | decimalTransactionId | 853701 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | WITHHOLDINGBATCH_EVENT_LID | NUMBERVARCHAR2(38,655) | EagleML/accountingTransaction/tradedCashActivity/withholdingLocalbatchEventId |
| reclaimLocalcontSettleDate | Optional | decimaldate | 8529968 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | RECLAIMCONT_SETTLE_LNUMBER(38,6)DT | DATE | EagleML/accountingTransaction/tradedCashActivity/reclaimLocalcontSettleDate |
| reclaimMethodlinkEventId | Optional | stringTransactionId | 391228 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | RECLAIMLINK_EVENT_METHODID | CHARVARCHAR2(255) | EagleML/accountingTransaction/tradedCashActivity/reclaimMethodlinkEventId |
| batchEventIdtargetEventId | Optional | TransactionIdstring | 70136 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BATCHTARGET_EVENTEVT_ID | VARCHAR2(55) | EagleML/accountingTransaction/tradedCashActivity/batchEventIdtargetEventId |
| contSettleDateeventReason | Optional | datestring | 996856 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYCONT | EVENT_SETTLE_DTDATEREASON | VARCHAR2(55) | EagleML/accountingTransaction/tradedCashActivity/contSettleDateeventReason |
| linkEventIdcancelEventId | Optional | TransactionId | 28501 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LINKCANCEL_EVENTEVT_ID | VARCHAR2(55) | EagleML/accountingTransaction/tradedCashActivity/linkEventIdcancelEventId |
| targetEventIdcancelSequence | Optional | stringinteger | 36226 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYTARGET | CANCEL_EVT_IDSEQUENCE | VARCHAR2NUMBER(5528) | EagleML/accountingTransaction/tradedCashActivity/targetEventIdcancelSequence |
| eventReasonrecPayAccount2 | Optional | string | 561826 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | EVENTREC_PAY_REASONACCT2 | VARCHAR2(5510) | EagleML/accountingTransaction/tradedCashActivity/eventReasonrecPayAccount2 |
| cancelEventIdprincipalBreakageUnder | Optional | TransactionIddecimal | 50110134 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CANCELPRINCIPAL_EVTBREAKAGE_IDUNDER | VARCHAR2NUMBER(5538,6) | EagleML/accountingTransaction/tradedCashActivity/cancelEventIdprincipalBreakageUnder |
| cancelSequenceprincipalBreakageOver | Optional | integerdecimal | 22610135 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CANCELPRINCIPAL_BREAKAGE_SEQUENCEOVER | NUMBER(2838,6) | EagleML/accountingTransaction/tradedCashActivity/cancelSequenceprincipalBreakageOver |
| recPayAccount2incomeBreakageUnder | Optional | stringdecimal | 182610136 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | RECINCOME_PAYBREAKAGE_ACCT2UNDER | VARCHAR2NUMBER(1038,6) | EagleML/accountingTransaction/tradedCashActivity/recPayAccount2incomeBreakageUnder |
| principalBreakageUnderincomeBreakageOver | Optional | decimal | 1013410137 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PRINCIPALINCOME_BREAKAGE_UNDEROVER | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/principalBreakageUnderincomeBreakageOver |
| principalBreakageOverotherFeeLocal | Optional | decimal | 101353752 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PRINCIPALOTHER_BREAKAGEFEE_OVERLOCAL | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/principalBreakageOverotherFeeLocal |
| incomeBreakageUnderstampDutyTaxLocal | Optional | decimal | 1013651 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INCOMESTAMP_DUTY_BREAKAGETAX_UNDERL | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/incomeBreakageUnderstampDutyTaxLocal |
| incomeBreakageOvercommAmountLocal | Optional | decimal | 1013747 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INCOMECOMM_BREAKAGEAMT_OVERL | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/incomeBreakageOvercommAmountLocal |
| otherFeeLocaltaxAmountLocal | Optional | decimal | 375246 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | OTHERTAX_FEEAMT_LOCALL | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/otherFeeLocaltaxAmountLocal |
| stampDutyTaxLocalsecFee | Optional | decimal | 5148 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYSTAMP_DUTY_TAX_L | SEC_FEE | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/stampDutyTaxLocalsecFee |
| commAmountLocalbackupPrice | Optional | decimal | 47 |
| ESTAR | ESTAR_TRADED_CASH_ACTIVITYCOMM | BKUP_AMT_LPRICE | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/commAmountLocalbackupPrice |
| taxAmountLocalsettleAmountLocal | Optional | decimal | 465363 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAXSETTLE_AMTAMOUNT_LLOCAL | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/taxAmountLocalsettleAmountLocal |
| secFeebrokerCode | Optional | decimalstring | 4888 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SECBROKER_FEECODE | NUMBERCHAR(38,620) | EagleML/accountingTransaction/tradedCashActivity/secFeebrokerCode |
| backupPricedividendRate | Optional | decimal | 368 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BKUPDIVIDEND_PRICERATE | NUMBER(3828,612) | EagleML/accountingTransaction/tradedCashActivity/backupPricedividendRate |
| settleAmountLocalcurrencyGain | Optional | decimal | 5363198 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYSETTLE | GAIN_AMOUNT_LOCALCURRENCY | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/settleAmountLocalcurrencyGain |
| brokerCodecurrencyLoss | Optional | stringdecimal | 88199 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BROKERLOSS_CODECURRENCY | CHARNUMBER(2038,6) | EagleML/accountingTransaction/tradedCashActivity/brokerCodecurrencyLoss |
| dividendRatelocalAssetCurrency | Optional | decimalCurrencyCode | 3689061 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | DIVIDENDLOCAL_ASSET_RATECURRENCY | NUMBERVARCHAR2(28,123) | EagleML/accountingTransaction/tradedCashActivity/dividendRatelocalAssetCurrency |
| currencyGainmasterTicketNumber | Optional | decimalstring | 198761 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | GAINMASTER_TICKET_CURRENCYNUMBER | NUMBERVARCHAR2(38,655) | EagleML/accountingTransaction/tradedCashActivity/currencyGainmasterTicketNumber |
| currencyLosstradeDateFxRate | Optional | decimal | 19987 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYLOSS | _CURRENCYTRADE_DT_FX_RATE | NUMBER(38,612) | EagleML/accountingTransaction/tradedCashActivity/currencyLosstradeDateFxRate |
| localAssetCurrencycorpActInstance | Optional | CurrencyCodeinteger | 90614268 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LOCALCORP_ASSETACT_CURRENCYVARCHAR2(3)INSTANCE | NUMBER | EagleML/accountingTransaction/tradedCashActivity/localAssetCurrencycorpActInstance |
| masterTicketNumbernetAmountBase | Optional | stringdecimal | 761478 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | MASTERNET_TICKETAMOUNT_BASE | NUMBERVARCHAR2(5538,6) | EagleML/accountingTransaction/tradedCashActivity/masterTicketNumbernetAmountBase |
| tradeDateFxRateprincipalAmountBase | Optional | decimal | 87169 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYTRADE | PRINCIPAL_DTAMOUNT_FX_RATEBASE | NUMBER(38,126) | EagleML/accountingTransaction/tradedCashActivity/tradeDateFxRateprincipalAmountBase |
| corpActInstanceincomeAmountBase | Optional | integerdecimal | 42681986 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CORPINCOME_ACTAMOUNT_INSTANCEBASE | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/corpActInstanceincomeAmountBase |
| netAmountBaserecPayAccount | Optional | decimalstring | 4781825 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | NETREC_AMOUNTPAY_BASEACCT | NUMBERVARCHAR2(38,610) | EagleML/accountingTransaction/tradedCashActivity/netAmountBaserecPayAccount |
| principalAmountBaserecPayAccountDesc | Optional | decimalstring | 1691651 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PRINCIPALREC_PAY_AMOUNTACCT_BASEDESC | NUMBERVARCHAR2(38,6100) | EagleML/accountingTransaction/tradedCashActivity/principalAmountBaserecPayAccountDesc |
| incomeAmountBasereclaimAmountBase | Optional | decimal | 1986851 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INCOMERECLAIM_AMOUNT_BASE | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/incomeAmountBasereclaimAmountBase |
| recPayAccounttaxExpenseBase | Optional | stringdecimal | 1825854 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | RECTAX_PAYEXPENSE_ACCTBASE | VARCHAR2NUMBER(1038,6) | EagleML/accountingTransaction/tradedCashActivity/recPayAccounttaxExpenseBase |
| recPayAccountDescbreakageAmountUnderBase | Optional | stringdecimal | 16511995 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | RECBREAKAGE_PAYAMT_ACCTUNDER_DESCB | VARCHAR2NUMBER(10038,6) | EagleML/accountingTransaction/tradedCashActivity/recPayAccountDescbreakageAmountUnderBase |
| reclaimAmountBasebreakageAmountOverBase | Optional | decimal | 8511997 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | RECLAIMBREAKAGE_AMT_AMOUNTOVER_BASEB | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/reclaimAmountBasebreakageAmountOverBase |
| taxExpenseBaserecPayAmountLocal | Optional | decimal | 85411781 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAXREC_PAY_EXPENSEAMT_BASEL | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/taxExpenseBaserecPayAmountLocal |
| breakageAmountUnderBaserecPayAmountBase | Optional | decimal | 199511782 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BREAKAGEREC_PAY_AMT_UNDER_B | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/breakageAmountUnderBaserecPayAmountBase |
| breakageAmountOverBaseclearingBroker | Optional | decimalstring | 19971236 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BREAKAGE_AMT_OVER_B | NUMBER(38,6CLEARING_BROKER | VARCHAR2(50) | EagleML/accountingTransaction/tradedCashActivity/breakageAmountOverBaseclearingBroker |
| recPayAmountLocaltaxReclaimRate | Optional | decimal | 117811296 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYREC | TAX_PAYRECLAIM_AMT_LRATE | NUMBER(38,612) | EagleML/accountingTransaction/tradedCashActivity/recPayAmountLocaltaxReclaimRate |
| recPayAmountBasetaxWithholdingRate | Optional | decimal | 117821295 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYREC | TAX_PAYWITHHOLDING_AMT_BRATE | NUMBER(38,612) | EagleML/accountingTransaction/tradedCashActivity/recPayAmountBasetaxWithholdingRate |
| clearingBrokerspecialReclaimRate | Optional | stringdecimal | 12361298 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CLEARINGSPECIAL_RECLAIM_BROKERRATE | VARCHAR2NUMBER(5038,12) | EagleML/accountingTransaction/tradedCashActivity/clearingBrokerspecialReclaimRate |
| taxReclaimRatespecialWithholdingRate | Optional | decimal | 12961297 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAXSPECIAL_RECLAIMWITHHOLDING_RATE | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/taxReclaimRatespecialWithholdingRate |
| taxWithholdingRatesourceEventId | Optional | decimal | 1295TransactionId |
| ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAXSOURCE_WITHHOLDINGEVENT_RATEID | NUMBERVARCHAR2(38,1255) | EagleML/accountingTransaction/tradedCashActivity/taxWithholdingRatesourceEventId |
| specialReclaimRatetargetAccountDate | Optional | decimaldate | 1298119 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SPECIALTARGET_RECLAIMACCT_RATENUMBER(38,12)DATE | DATE | EagleML/accountingTransaction/tradedCashActivity/specialReclaimRatetargetAccountDate |
| specialWithholdingRategainSwapLocal | Optional | decimal | 129711819 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SPECIALGAIN_WITHHOLDINGSWAP_RATEL | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/specialWithholdingRategainSwapLocal |
| sourceEventIdlossSwapLocal | Optional | decimalTransactionId | 11821 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SOURCELOSS_EVENTSWAP_IDL | VARCHAR2NUMBER(5538,12) | EagleML/accountingTransaction/tradedCashActivity/sourceEventIdlossSwapLocal |
| targetAccountDategainSwapBase | Optional | datedecimal | 11911820 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TARGETGAIN_ACCTSWAP_DATEDATEB | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/targetAccountDategainSwapBase |
| gainSwapLocallossSwapBase | Optional | decimal | 1181911822 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | GAINLOSS_SWAP_LB | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/gainSwapLocallossSwapBase |
| lossSwapLocaltermLoanFeeIncLocal | Optional | decimal | 11821844 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LOSS_SWAPTERM_LOAN_FEE_INC_L | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/lossSwapLocaltermLoanFeeIncLocal |
| gainSwapBasetermLoanFeeIncBase | Optional | decimal | 11820845 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | GAIN_SWAPTERM_LOAN_FEE_INC_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/gainSwapBasetermLoanFeeIncBase |
| lossSwapBasetermLoanFeeExpLocal | Optional | decimal | 11822846 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYLOSS_SWAP | _BTERM_LOAN_FEE_EXP_L | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/lossSwapBasetermLoanFeeExpLocal |
| termLoanFeeIncLocaltermLoanFeeExpBase | Optional | decimal | 844847 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TERM_LOAN_FEE_INCEXP_LB | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/termLoanFeeIncLocaltermLoanFeeExpBase |
| termLoanFeeIncBasecommAmountBase | Optional | decimal | 845498 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TERMCOMM_LOANAMT_FEE_INC_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/termLoanFeeIncBasecommAmountBase |
| termLoanFeeExpLocalotherFeeBase | Optional | decimal | 8465708 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TERM_LOANOTHER_FEE_EXP_LB | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/termLoanFeeExpLocalotherFeeBase |
| termLoanFeeExpBasesecFeeBase | Optional | decimal | 84710122 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TERM_LOANSEC_FEE_EXP_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/termLoanFeeExpBasesecFeeBase |
| commAmountBasestampDutyTaxBase | Optional | decimal | 49810121 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | COMMSTAMP_DUTY_AMTTAX_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/commAmountBasestampDutyTaxBase |
| otherFeeBasefedTaxWithholdingBase | Optional | decimal | 57088078 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | OTHERFED_TAX_FEEWITHHOLD_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/otherFeeBasefedTaxWithholdingBase |
| secFeeBasestTaxWithholdingBase | Optional | decimal | 101228079 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SECST_TAX_FEEWITHHOLD_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/secFeeBasestTaxWithholdingBase |
| stampDutyTaxBasestreamSecAlias | Optional | decimalinteger | 10121 |
| ESTAR | ESTAR_TRADED_CASH_ACTIVITYSTAMP | STREAM_DUTYSEC_TAX_BALIAS | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/stampDutyTaxBasestreamSecAlias |
| fedTaxWithholdingBasetaxAmountBase | Optional | decimal | 807810759 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | FED_TAX_WITHHOLDAMT_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/fedTaxWithholdingBasetaxAmountBase |
| stTaxWithholdingBasebuWithholdingLocal | Optional | decimal | 80792712 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYST | BU_TAXWTHHLD_WITHHOLD_BL | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/stTaxWithholdingBasebuWithholdingLocal |
| streamSecAliasbuWithholdingBase | Optional | decimalinteger | 2713 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | STREAMBU_SECWTHHLD_ALIASB | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/streamSecAliasbuWithholdingBase |
| taxAmountBasebuWithholdingRate | Optional | decimal | 107592762 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAXBU_AMTWTHHLD_BRATE | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/taxAmountBasebuWithholdingRate |
| buWithholdingLocalprice | Optional | decimal | 271245 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYBU_WTHHLD_L | PRICE | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/buWithholdingLocalprice |
| buWithholdingBasecancelType | Optional | decimalstring | 27132981 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYBU | CANCEL_WTHHLD_BTYPE | NUMBERVARCHAR2(38,121) | EagleML/accountingTransaction/tradedCashActivity/buWithholdingBasecancelType |
| buWithholdingRatecancelFlag | Optional | decimalstring | 276210045 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYBU | CANCEL_WTHHLD_RATEFLAG | NUMBERVARCHAR2(38,121) | EagleML/accountingTransaction/tradedCashActivity/buWithholdingRatecancelFlag |
| pricecouponDate | Optional | decimaldate | 453460 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PRICE | NUMBER(38,12)COUPON_DATE | DATE | EagleML/accountingTransaction/tradedCashActivity/pricecouponDate |
| cancelTypecashEventSpawned | Optional | string | 2981751 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CANCELCASH_EVENT_TYPESPAWNED | VARCHAR2(1) | EagleML/accountingTransaction/tradedCashActivity/cancelTypecashEventSpawned |
| cancelFlagbackupCouponEndDate | Optional | stringdate | 10045 |
| ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CANCEL_FLAG | VARCHAR2(1)BKUP_COUPON_END_DATE | DATE | EagleML/accountingTransaction/tradedCashActivity/cancelFlagbackupCouponEndDate |
| couponDateorigContSettleDate | Optional | date | 3460 |
| ESTAR | ESTAR_TRADED_CASH_ACTIVITYCOUPON | _DATEORIG_CONT_SETTLE_DT | DATE | EagleML/accountingTransaction/tradedCashActivity/couponDateorigContSettleDate |
| cashEventSpawnedperiodicDistType | Optional | string | 7511737 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CASHPERIODIC_EVENTDIST_SPAWNEDTYPE | VARCHAR2(12) | EagleML/accountingTransaction/tradedCashActivity/cashEventSpawnedperiodicDistType |
| backupCouponEndDatecostLotOpenEventId | Optional | dateTransactionId |
| ESTAR | ESTAR_TRADED_CASH_ACTIVITYBKUP | COST_LOT_COUPONOPEN_ENDEVT_DATEDATEID | VARCHAR2(55) | EagleML/accountingTransaction/tradedCashActivity/backupCouponEndDatecostLotOpenEventId |
| origContSettleDatecostLotCloseEventId | Optional | dateTransactionId |
| ESTAR | ESTAR_TRADED_CASH_ACTIVITYORIG | COST_LOT_CONTCLOSE_SETTLEEVT_DTDATEID | VARCHAR2(55) | EagleML/accountingTransaction/tradedCashActivity/origContSettleDatecostLotCloseEventId |
| periodicDistTypecorpActionType | Optional | string | 1737 |
| ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PERIODICCORP_DISTACTION_TYPE | VARCHAR2(250) | EagleML/accountingTransaction/tradedCashActivity/periodicDistTypecorpActionType |
| costLotOpenEventIdcashAccountName | Optional | TransactionIdstring | 11696 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYCOST | CASH_LOT_OPEN_EVT_IDACCT_NAME | VARCHAR2(5550) | EagleML/accountingTransaction/tradedCashActivity/costLotOpenEventIdcashAccountName |
| costLotCloseEventIdcashAccount | Optional | stringTransactionId | 11697 | ESTAR | ESTAR_TRADED_CASH_ACTIVITYCOST_LOT_CLOSE_EVT_ID | CASH_ACCT | VARCHAR2(5520) | EagleML/accountingTransaction/tradedCashActivity/costLotCloseEventIdcashAccount |
| corpActionTypecashAccountAlias | Optional | integerstring | 11698 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CORPCASH_ACTIONACCT_TYPEALIAS | VARCHAR2NUMBER(5038) | EagleML/accountingTransaction/tradedCashActivity/corpActionTypecashAccountAlias | cashAccountName
| srcSysC | Optional | string |
11696| 98 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY |
CASH| SRC_ |
ACCT| SYS_ |
NAME| C | VARCHAR2( |
50| 25) | EagleML/accountingTransaction/tradedCashActivity/ |
cashAccountNamecashAccount| 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. |
VARCHAR2(20)| calcTransactionId | Optional | string |
11697 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CASH_ACCT | | 2983 |
|
|
|
| EagleML/accountingTransaction/tradedCashActivity/calcTransactionId |
| calcMasterTransactionId | Optional | string | 2984 |
|
|
|
| EagleML/accountingTransaction/tradedCashActivity/ |
cashAccount| calcMasterTransactionId |
cashAccountAliasNUMBER(38)| calcCancelTransactionId | Optional |
integer | 11698 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CASH_ACCT_ALIAS | | string | 2985 |
|
|
|
| EagleML/accountingTransaction/tradedCashActivity/calcCancelTransactionId |
| To add the element below, please set IncludeAssetToBaseFxRate=Y in the RTR. |
| assetToBaseFxRate | Optional | decimal | not stored in DB | EagleML/accountingTransaction/tradedCashActivity/ |
cashAccountAlias| assetToBaseFxRate | srcSysC
| custodyBankAccountNumber | Optional | string | 98 |
| ESTARRULESDBOESTAR | ENTITY_TRADEDCUSTODY_CASH_ACTIVITYSRC_SYS_CRELATIONSHIP | CUSTODY_BANK_ACCT_NUM | VARCHAR2(2530) | EagleML/accountingTransaction/tradedCashActivity/ | 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| custodyBankAccountNumber |
| custodyBankCode | Optional | string | 2983 | EagleML/accountingTransaction/tradedCashActivity/calcTransactionId | calcMasterTransactionId | Optional | string | 2984
| RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_CODE | CHAR(20) | EagleML/accountingTransaction/tradedCashActivity/ | calcMasterTransactionIdcustodyBankCode |
calcCancelTransactionId| custodyBankDesc | Optional | string | 2985 | EagleML/accountingTransaction/tradedCashActivity/calcCancelTransactionId |
| To add the element below, please set IncludeAssetToBaseFxRate=Y in the RTR. |
| assetToBaseFxRate | Optional | decimal | not stored in DB | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_DESC | CHAR(50) | EagleML/accountingTransaction/tradedCashActivity/ | assetToBaseFxRatecustodyBankDesc |
