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 | Optional | integer | 126 | 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 | date | 36 | 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 | _ACTIONACCTG_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 | _PAYRECLAIM_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 | _AMTBKUP_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 | decimalstring | 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 | decimal | 1298TransactionId |
| 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 | TransactionIddecimal | 11819 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SOURCEGAIN_EVENTSWAP_IDVARCHAR2(55L | NUMBER(38,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 | TERMOTHER_LOAN_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 | integerdecimal | 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 | datestring | 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 | TransactionId | string |
| ESTAR | ESTAR_TRADED_CASH_ACTIVITYCOST_LOT_OPEN_EVT_ | IDCORP_ACTION_TYPE | VARCHAR2(5550) | EagleML/accountingTransaction/tradedCashActivity/costLotOpenEventIdcorpActionType |
costLotCloseEventIdcashAccountName | Optional | TransactionIdstring | 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 |
1169798 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY |
CASHSRC_SYS_ |
ACCTC | VARCHAR2( |
2025) | EagleML/accountingTransaction/tradedCashActivity/ |
cashAccountcashAccountAliassrcSysC |
To add the elements below, please set IncludeExtendedDetails=ALL or IncludeExtendedDetails=Y in the RTR. For more information, see Use Calculated IDs for Transactions. |
NUMBER(38)calcTransactionId | Optional |
integer | 11698 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CASH_ACCT_ALIAS | string | 2983 |
|
|
|
| EagleML/accountingTransaction/tradedCashActivity/calcTransactionId |
calcMasterTransactionId | Optional | string | 2984 |
|
|
|
| EagleML/accountingTransaction/tradedCashActivity/ |
cashAccountAliascalcMasterTransactionId |
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 |
IncludeExtendedDetailsIncludeAssetToBaseFxRate= |
ALL or IncludeExtendedDetails=Y in the RTR |
calcTransactionId. |
assetToBaseFxRate | Optional | decimal | not stored in DB | EagleML/accountingTransaction/tradedCashActivity/assetToBaseFxRate |
custodyBankAccountNumber | Optional | string | 2983 | | | |
| RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_ACCT_NUM | VARCHAR2(30) | EagleML/accountingTransaction/tradedCashActivity/ | calcTransactionIdcustodyBankAccountNumber |
calcMasterTransactionIdcustodyBankCode | Optional | string | 2984 | | | | |
| RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_CODE | CHAR(20) | EagleML/accountingTransaction/tradedCashActivity/ | calcMasterTransactionIdcustodyBankCode |
calcCancelTransactionIdcustodyBankDesc | Optional | string | 2985 | | | |
| RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_DESC | CHAR(50) | EagleML/accountingTransaction/tradedCashActivity/ | calcCancelTransactionIdcustodyBankDesc |