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 onlyeffectiveDate |
instance | Optional | integer | 9388 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INSTANCE | NUMBER(38) | EagleML/accountingTransaction/tradedCashActivity/ |
Extended CA Properties Model (extract onlyinstance |
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 |
1169698 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY |
CASHSRC_ |
ACCTSYS_ |
NAMEC | VARCHAR2( |
5025) | EagleML/accountingTransaction/tradedCashActivity/ |
cashAccountNamecashAccountsrcSysC |
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/ |
cashAccountcalcMasterTransactionId |
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/ |
cashAccountAliasassetToBaseFxRate | 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. |
calcTransactionIdcustodyBankAccountNumber |
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 |
calcCancelTransactionIdcustodyBankDesc | 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 |