...
| Element | Optional/Required | Value Type | Star Tag | Eagle DB | DB Table | DB Field | Data Type | XPATH | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectType | Optional | ObjectTypeEnum | not stored in DB | EagleML/accountingTransaction/settledCashActivity/objectType | |||||||||||||||
| objectId | Optional | ObjectId | not stored in DB | EagleML/accountingTransaction/settledCashActivity/objectId | |||||||||||||||
| objectDescription | Optional | FeedTypeEnum | not stored in DB | EagleML/accountingTransaction/settledCashActivity/objectDescription | |||||||||||||||
| updateTimestamp | Optional | dateTime | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | SYSTEM_DATE | DATE | EagleML/accountingTransaction/settledCashActivity/updateTimestamp | ||||||||||||
| customElements | Optional | CustomElements - ComplexType | EagleML/accountingTransaction/settledCashActivity/customElements | ||||||||||||||||
| updateSource | Required | string | 944 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | UPDATE_SOURCE | VARCHAR2(32) | EagleML/accountingTransaction/settledCashActivity/updateSource | |||||||||||
| Entity Common Id Model | EagleML/accountingTransaction/settledCashActivity/objectType | objectId | Optional | ObjectId | not stored in DB|||||||||||||||
| Entity Properties Model (extract only) | EagleML/accountingTransaction/settledCashActivity/ | ||||||||||||||||||
| Asset Identifiers Model | EagleML/accountingTransaction/settledCashActivity/objectId | objectDescription | Optional | FeedTypeEnum | not stored in DB | ||||||||||||||
| Extended Asset Properties Model (extract only) | EagleML/accountingTransaction/settledCashActivity/ | ||||||||||||||||||
| Extended CA Properties Model (extract only) | EagleML/accountingTransaction/settledCashActivity/ | ||||||||||||||||||
| updateTimestampeffectiveDate | Optional | datedateTime | 1109 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | SYSTEMEFFECTIVE_DATEDT | DATE | EagleML/accountingTransaction/settledCashActivity/updateTimestampeffectiveDate | |||||||||||
| customElementsinstance | Optional | CustomElements - ComplexType | EagleML/accountingTransaction/settledCashActivity/customElements | updateSource | Required | string | 944 | integer | 9388 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | UPDATE_SOURCEINSTANCE | VARCHAR2NUMBER(3238) | EagleML/accountingTransaction/settledCashActivity/updateSource | |||||
| Entity Common Id Model | EagleML/accountingTransaction/settledCashActivity/ | ||||||||||||||||||
| instance | |||||||||||||||||||
| localCurrency | Optional | CurrencyCode | 63 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | LOCAL_CURR | VARCHAR2(3) | EagleML/accountingTransaction/settledCashActivity/ | |||||||||||
| Asset Identifiers Model | EagleML/accountingTransaction/settledCashActivity/ | ||||||||||||||||||
| Extended Asset Properties Model (extract only) | EagleML/accountingTransaction/settledCashActivity/ | ||||||||||||||||||
| localCurrency | |||||||||||||||||||
| baseCurrency | Optional | CurrencyCode | 86 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | BASE_CURR | VARCHAR2(3) | EagleML/accountingTransaction/settledCashActivity/baseCurrency | |||||||||||
| effectiveDateaccountingBasis | Optional | datestring | 110921 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | EFFECTIVEACCT_DTDATEBASIS | VARCHAR2(5) | EagleML/accountingTransaction/settledCashActivity/effectiveDateaccountingBasis | |||||||||||
| instancelongShortC | Optional | integerstring | 938815 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | INSTANCE | NUMBER(38LNG_SHT_C | CHAR(1) | EagleML/accountingTransaction/settledCashActivity/instancelongShortC | ||||||||||
| localCurrencybackupSrcSysC | Optional | CurrencyCode | 63string | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | LOCAL_CURR | VARCHAR2(3BKUP_SRC_SYS_C | CHAR(1) | EagleML/accountingTransaction/settledCashActivity/localCurrencybackupSrcSysC | ||||||||||
| baseCurrencystarPositionId | Optional | CurrencyCodeinteger | 86830 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | BASEPOSN_CURRID | VARCHAR2NUMBER(328) | EagleML/accountingTransaction/settledCashActivity/baseCurrency | accountingBasis | Optional | string | 21 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | ACCT_BASIS | VARCHAR2(5/starPositionId | |||
| settleAsset | Optional | Asset Identifiers Model - (see extra table) | EagleML/accountingTransaction/settledCashActivity/accountingBasissettleAsset/ | ||||||||||||||||
| longShortCshareClass | Optional | string | 1534 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYLNG | SHARE_SHT_CCLASS | CHARVARCHAR2(110) | EagleML/accountingTransaction/settledCashActivity/longShortCshareClass | |||||||||||
| backupSrcSysCeventId | Optional | TransactionIdstring | 25 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | BKUP_SRC_SYS_C | CHAR(1EVENT_ID | VARCHAR2(55) | EagleML/accountingTransaction/settledCashActivity/backupSrcSysCeventId | ||||||||||
| starPositionIdstarEventType | Optional | integerstring | 8302362 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | POSNEVENT_IDTYPE | NUMBERVARCHAR2(2825) | EagleML/accountingTransaction/settledCashActivity/starPositionIdstarEventType | |||||||||||
| settleAsseteventType | Optional | Asset Identifiers Model - (see extra table) | EagleML/accountingTransaction/settledCashActivity/settleAsset/ | shareClass | Optional | string | 3453 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | SHARECASH_EVT_CLASSTYP | VARCHAR2(10) | EagleML/accountingTransaction/settledCashActivity/shareClasseventType | |||||||
| eventIdeventSequence | Optional | TransactionIdinteger | 25126 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | EVENT_IDSEQUENCE | VARCHAR2NUMBER(5528) | EagleML/accountingTransaction/settledCashActivity/eventIdeventSequence | |||||||||||
| starEventTypeprocessDate | Optional | stringdate | 236230 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | EVENTPROCESS_TYPEVARCHAR2(25)DT | DATE | EagleML/accountingTransaction/settledCashActivity/starEventTypeprocessDate | |||||||||||
| eventTypeaccountingDate | Optional | stringdate | 5336 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYCASH | ACCOUNT_EVT_TYPVARCHAR2(10)DT | DATE | EagleML/accountingTransaction/settledCashActivity/eventTypeaccountingDate | |||||||||||
| eventSequencemonthEndAccountingDate | Optional | integerdate | 1264733 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | EVENT_SEQUENCE | NUMBER(28)MONTH_END_ACCT_DT | DATE | EagleML/accountingTransaction/settledCashActivity/eventSequencemonthEndAccountingDate | ||||||||||
| processDateunits | Optional | datedecimal | 3040 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | PROCESS_DT | DATEUNITS | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/processDateunits | ||||||||||
| accountingDateamount | Optional | datedecimal | 3650 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | ACCOUNT_DT | DATEAMOUNT | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/accountingDateamount | ||||||||||
| monthEndAccountingDateprincipal | Optional | datedecimal | 4733165 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | MONTH_END_ACCT_DT | DATEPRINCIPAL | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/monthEndAccountingDateprincipal | ||||||||||
| unitsincome | Optional | decimal | 401985 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | UNITSINCOME | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/unitsincome | |||||||||||
| amountnavId | Optional | decimalinteger | 503196 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | AMOUNTNAV_ID | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/amountnavId | |||||||||||
| principalcashStatus | Optional | decimalstring | 16554 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | PRINCIPALCASH_STATUS | NUMBERVARCHAR2(38,620) | EagleML/accountingTransaction/settledCashActivity/principalcashStatus | |||||||||||
| incomecashCategory | Optional | decimalstring | 198562 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | INCOMECASH_CATEGORY | NUMBERVARCHAR2(38,650) | EagleML/accountingTransaction/settledCashActivity/incomecashCategory | |||||||||||
| navIdbankAlias | Optional | integerstring | 319616 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | NAVBANK_IDNUMBERALIAS | VARCHAR2(25) | EagleML/accountingTransaction/settledCashActivity/navIdbankAlias | |||||||||||
| cashStatusautoSettleIndicator | Optional | stringYesNoOptionEnum | 5458 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYCASH | AUTO_SETTLE_STATUSINDICATOR | VARCHAR2(202) | EagleML/accountingTransaction/settledCashActivity/cashStatusautoSettleIndicator | |||||||||||
| cashCategorycorpActionId | Optional | stringinteger | 6260 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYCASH | CORP_ACTION_CATEGORYID | VARCHAR2NUMBER(5022) | EagleML/accountingTransaction/settledCashActivity/cashCategorycorpActionId | |||||||||||
| bankAliasledgerBalanceEntitlement | Optional | string | 163970 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | BANKLDGR_BAL_ALIASENTITLEMENT | VARCHAR2(251) | EagleML/accountingTransaction/settledCashActivity/bankAliasledgerBalanceEntitlement | |||||||||||
| autoSettleIndicatoraccountingPlan | Optional | YesNoOptionEnuminteger | 58999 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYAUTO | ACCTG_SETTLE_INDICATORVARCHAR2(2)PLAN | NUMBER | EagleML/accountingTransaction/settledCashActivity/autoSettleIndicatoraccountingPlan | |||||||||||
| corpActionIdpositingPlan | Optional | integer | 60913 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYCORP | POSTING_ACTION_IDPLAN | NUMBER(22) | EagleML/accountingTransaction/settledCashActivity/corpActionIdpositingPlan | |||||||||||
| ledgerBalanceEntitlementrecPayPlan | Optional | string | 39701831 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | LDGRREC_BALPAY_ENTITLEMENTPLAN | VARCHAR2(115) | EagleML/accountingTransaction/settledCashActivity/ledgerBalanceEntitlementrecPayPlan | |||||||||||
| accountingPlanwithholdingLocal | Optional | integerdecimal | 999853 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | ACCTGWITHHOLDING_PLANL | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/accountingPlanwithholdingLocal | |||||||||||
| positingPlanreclaimLocal | Optional | integerdecimal | 913852 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | POSTINGRECLAIM_PLANL | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/positingPlanreclaimLocal | |||||||||||
| recPayPlanreclaimMethod | Optional | string | 18313912 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYREC | RECLAIM_PAY_PLANMETHOD | VARCHAR2CHAR(152) | EagleML/accountingTransaction/settledCashActivity/recPayPlanreclaimMethod | |||||||||||
| withholdingLocalbatchEventId | Optional | decimalTransactionId | 853701 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | WITHHOLDINGBATCH_EVENT_LID | NUMBERVARCHAR2(38,655) | EagleML/accountingTransaction/settledCashActivity/withholdingLocalbatchEventId | |||||||||||
| reclaimLocalcontSettleDate | Optional | decimaldate | 8529968 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | RECLAIMCONT_SETTLE_LNUMBER(38,6)DT | DATE | EagleML/accountingTransaction/settledCashActivity/reclaimLocalcontSettleDate | |||||||||||
| reclaimMethodlinkEventId | Optional | stringTransactionId | 391228 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | RECLAIMLINK_EVENT_METHODID | CHARVARCHAR2(255) | EagleML/accountingTransaction/settledCashActivity/reclaimMethodlinkEventId | |||||||||||
| batchEventIdtargetEventId | Optional | TransactionIdstring | 70136 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | BATCHTARGET_EVENTEVT_ID | VARCHAR2(55) | EagleML/accountingTransaction/settledCashActivity/batchEventIdtargetEventId | |||||||||||
| contSettleDateeventReason | Optional | datestring | 996856 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYCONT | _SETTLEEVENT_DTDATEREASON | VARCHAR2(55) | EagleML/accountingTransaction/settledCashActivity/contSettleDateeventReason | |||||||||||
| linkEventIdcancelEventId | Optional | TransactionId | 28501 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | LINKCANCEL_EVENTEVT_ID | VARCHAR2(55) | EagleML/accountingTransaction/settledCashActivity/linkEventIdcancelEventId | |||||||||||
| targetEventIdcancelSequence | Optional | stringinteger | 36226 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYTARGET | CANCEL_EVT_IDSEQUENCE | VARCHAR2NUMBER(5528) | EagleML/accountingTransaction/settledCashActivity/targetEventIdcancelSequence | |||||||||||
| eventReasonrecPayAccount2 | Optional | string | 561826 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | EVENTREC_PAY_REASONACCT2 | VARCHAR2(5510) | EagleML/accountingTransaction/settledCashActivity/eventReasonrecPayAccount2 | |||||||||||
| cancelEventIdprincipalBreakageUnder | Optional | TransactionIddecimal | 50110134 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CANCELPRINCIPAL_EVTBREAKAGE_IDUNDER | VARCHAR2NUMBER(5538,6) | EagleML/accountingTransaction/settledCashActivity/cancelEventIdprincipalBreakageUnder | |||||||||||
| cancelSequenceprincipalBreakageOver | Optional | integerdecimal | 22610135 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CANCELPRINCIPAL_BREAKAGE_SEQUENCEOVER | NUMBER(2838,6) | EagleML/accountingTransaction/settledCashActivity/cancelSequenceprincipalBreakageOver | |||||||||||
| recPayAccount2incomeBreakageUnder | Optional | stringdecimal | 182610136 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | RECINCOME_PAYBREAKAGE_ACCT2UNDER | VARCHAR2NUMBER(1038,6) | EagleML/accountingTransaction/settledCashActivity/recPayAccount2incomeBreakageUnder | |||||||||||
| principalBreakageUnderincomeBreakageOver | Optional | decimal | 1013410137 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | PRINCIPALINCOME_BREAKAGE_UNDEROVER | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/principalBreakageUnderincomeBreakageOver | |||||||||||
| principalBreakageOverotherFeeLocal | Optional | decimal | 101353752 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | PRINCIPALOTHER_BREAKAGEFEE_OVERLOCAL | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/principalBreakageOverotherFeeLocal | |||||||||||
| incomeBreakageUnderstampDutyTaxLocal | Optional | decimal | 1013651 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | INCOMESTAMP_DUTY_BREAKAGETAX_UNDERL | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/incomeBreakageUnderstampDutyTaxLocal | |||||||||||
| incomeBreakageOvercommAmountLocal | Optional | decimal | 1013747 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | INCOMECOMM_BREAKAGEAMT_OVERL | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/incomeBreakageOvercommAmountLocal | |||||||||||
| otherFeeLocaltaxAmountLocal | Optional | decimal | 375246 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | OTHERTAX_FEEAMT_LOCALL | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/otherFeeLocaltaxAmountLocal | |||||||||||
| stampDutyTaxLocalsecFee | Optional | decimal | 5148 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYSTAMP_DUTY_TAX_L | SEC_FEE | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/stampDutyTaxLocalsecFee | |||||||||||
| commAmountLocalbackupPrice | Optional | decimal | 47ESTAR | ESTAR_SETTLED_CASH_ACTIVITYCOMM | BKUP_AMT_LPRICE | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/commAmountLocalbackupPrice | ||||||||||||
| taxAmountLocalsettleAmountLocal | Optional | decimal | 465363 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | TAXSETTLE_AMTAMOUNT_LLOCAL | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/taxAmountLocalsettleAmountLocal | |||||||||||
| secFeebrokerCode | Optional | decimalstring | 4888 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | SECBROKER_FEECODE | NUMBERCHAR(38,620) | EagleML/accountingTransaction/settledCashActivity/secFeebrokerCode | |||||||||||
| backupPricedividendRate | Optional | decimal | 368 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | BKUPDIVIDEND_PRICERATE | NUMBER(3828,612) | EagleML/accountingTransaction/settledCashActivity/backupPricedividendRate | |||||||||||
| settleAmountLocalcurrencyGain | Optional | decimal | 5363198 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYSETTLE | GAIN_AMOUNT_LOCALCURRENCY | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/settleAmountLocalcurrencyGain | |||||||||||
| brokerCodecurrencyLoss | Optional | stringdecimal | 88199 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | BROKERLOSS_CODECURRENCY | CHARNUMBER(2038,6) | EagleML/accountingTransaction/settledCashActivity/brokerCodecurrencyLoss | |||||||||||
| dividendRatelocalAssetCurrency | Optional | decimalCurrencyCode | 3689061 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | DIVIDENDLOCAL_ASSET_RATECURRENCY | NUMBERVARCHAR2(28,123) | EagleML/accountingTransaction/settledCashActivity/dividendRatelocalAssetCurrency | |||||||||||
| currencyGainmasterTicketNumber | Optional | decimalstring | 198761 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | GAINMASTER_TICKET_CURRENCYNUMBER | NUMBERVARCHAR2(38,655) | EagleML/accountingTransaction/settledCashActivity/currencyGainmasterTicketNumber | |||||||||||
| currencyLosstradeDateFxRate | Optional | decimal | 19987 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYLOSS | _CURRENCYTRADE_DT_FX_RATE | NUMBER(38,612) | EagleML/accountingTransaction/settledCashActivity/currencyLosstradeDateFxRate | |||||||||||
| localAssetCurrencycorpActInstance | Optional | CurrencyCodeinteger | 90614268 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | LOCALCORP_ASSETACT_CURRENCYVARCHAR2(3)INSTANCE | NUMBER | EagleML/accountingTransaction/settledCashActivity/localAssetCurrencycorpActInstance | |||||||||||
| masterTicketNumbernetAmountBase | Optional | stringdecimal | 761478 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | MASTERNET_TICKETAMOUNT_BASE | NUMBERVARCHAR2(5538,6) | EagleML/accountingTransaction/settledCashActivity/masterTicketNumbernetAmountBase | |||||||||||
| tradeDateFxRateprincipalAmountBase | Optional | decimal | 87169 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYTRADE | PRINCIPAL_DTAMOUNT_FX_RATEBASE | NUMBER(38,126) | EagleML/accountingTransaction/settledCashActivity/tradeDateFxRateprincipalAmountBase | |||||||||||
| corpActInstanceincomeAmountBase | Optional | integerdecimal | 42681986 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CORPINCOME_ACTAMOUNT_INSTANCEBASE | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/corpActInstanceincomeAmountBase | |||||||||||
| netAmountBaserecPayAccount | Optional | decimalstring | 4781825 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | NETREC_AMOUNTPAY_BASEACCT | NUMBERVARCHAR2(38,610) | EagleML/accountingTransaction/settledCashActivity/netAmountBaserecPayAccount | |||||||||||
| principalAmountBaserecPayAccountDesc | Optional | decimalstring | 1691651 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | PRINCIPALREC_PAY_AMOUNTACCT_BASEDESC | NUMBERVARCHAR2(38,6100) | EagleML/accountingTransaction/settledCashActivity/principalAmountBaserecPayAccountDesc | |||||||||||
| incomeAmountBasereclaimAmountBase | Optional | decimal | 1986851 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | INCOMERECLAIM_AMOUNT_BASE | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/incomeAmountBasereclaimAmountBase | |||||||||||
| recPayAccounttaxExpenseBase | Optional | stringdecimal | 1825854 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | RECTAX_PAYEXPENSE_ACCTBASE | VARCHAR2NUMBER(1038,6) | EagleML/accountingTransaction/settledCashActivity/recPayAccounttaxExpenseBase | |||||||||||
| recPayAccountDescbreakageAmountUnderBase | Optional | stringdecimal | 16511995 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | RECBREAKAGE_PAYAMT_ACCTUNDER_DESCB | VARCHAR2NUMBER(10038,6) | EagleML/accountingTransaction/settledCashActivity/recPayAccountDescbreakageAmountUnderBase | |||||||||||
| reclaimAmountBasebreakageAmountOverBase | Optional | decimal | 8511997 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | RECLAIMBREAKAGE_AMT_AMOUNTOVER_BASEB | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/reclaimAmountBasebreakageAmountOverBase | |||||||||||
| taxExpenseBaserecPayAmountLocal | Optional | decimal | 85411781 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | TAXREC_PAY_EXPENSEAMT_BASEL | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/taxExpenseBaserecPayAmountLocal | |||||||||||
| breakageAmountUnderBaserecPayAmountBase | Optional | decimal | 199511782 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | BREAKAGEREC_PAY_AMT_UNDER_B | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/breakageAmountUnderBaserecPayAmountBase | |||||||||||
| breakageAmountOverBaseclearingBroker | Optional | decimalstring | 19971236 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | BREAKAGE_AMT_OVER_B | NUMBER(38,6CLEARING_BROKER | VARCHAR2(50) | EagleML/accountingTransaction/settledCashActivity/breakageAmountOverBaseclearingBroker | ||||||||||
| recPayAmountLocaltaxReclaimRate | Optional | decimal | 117811296 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYREC | TAX_PAYRECLAIM_AMT_LRATE | NUMBER(38,612) | EagleML/accountingTransaction/settledCashActivity/recPayAmountLocaltaxReclaimRate | |||||||||||
| recPayAmountBasetaxWithholdingRate | Optional | decimal | 117821295 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYREC | TAX_PAYWITHHOLDING_AMT_BRATE | NUMBER(38,612) | EagleML/accountingTransaction/settledCashActivity/recPayAmountBasetaxWithholdingRate | |||||||||||
| clearingBrokerspecialReclaimRate | Optional | stringdecimal | 12361298 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CLEARINGSPECIAL_RECLAIM_BROKERRATE | VARCHAR2NUMBER(5038,12) | EagleML/accountingTransaction/settledCashActivity/clearingBrokerspecialReclaimRate | |||||||||||
| taxReclaimRatespecialWithholdingRate | Optional | decimal | 12961297 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | TAXSPECIAL_RECLAIMWITHHOLDING_RATE | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/taxReclaimRatespecialWithholdingRate | |||||||||||
| taxWithholdingRatesourceEventId | Optional | decimal | 1295TransactionId | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | TAXSOURCE_WITHHOLDINGREFERENCE_RATEID | NUMBERVARCHAR2(38,1255) | EagleML/accountingTransaction/settledCashActivity/taxWithholdingRatesourceEventId | |||||||||||
| specialReclaimRatetargetAccountDate | Optional | decimaldate | 1298119 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | SPECIALTARGET_RECLAIMACCT_RATENUMBER(38,12)DATE | DATE | EagleML/accountingTransaction/settledCashActivity/specialReclaimRatetargetAccountDate | |||||||||||
| specialWithholdingRategainSwapLocal | Optional | decimal | 129711819 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | SPECIALGAIN_WITHHOLDINGSWAP_RATEL | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/specialWithholdingRategainSwapLocal | |||||||||||
| sourceEventIdlossSwapLocal | Optional | decimalTransactionId | 11821 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | SOURCELOSS_REFERENCESWAP_IDL | VARCHAR2NUMBER(5538,12) | EagleML/accountingTransaction/settledCashActivity/sourceEventIdlossSwapLocal | |||||||||||
| targetAccountDategainSwapBase | Optional | datedecimal | 11911820 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | TARGETGAIN_ACCTSWAP_DATEDATEB | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/targetAccountDategainSwapBase | |||||||||||
| gainSwapLocallossSwapBase | Optional | decimal | 1181911822 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | GAINLOSS_SWAP_LB | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/gainSwapLocallossSwapBase | |||||||||||
| lossSwapLocaltermLoanFeeIncLocal | Optional | decimal | 11821844 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | LOSS_SWAPTERM_LOAN_FEE_INC_L | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/lossSwapLocaltermLoanFeeIncLocal | |||||||||||
| gainSwapBasetermLoanFeeIncBase | Optional | decimal | 11820845 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | GAIN_SWAPTERM_LOAN_FEE_INC_B | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/gainSwapBasetermLoanFeeIncBase | |||||||||||
| lossSwapBasetermLoanFeeExpLocal | Optional | decimal | 11822846 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYLOSS_SWAP | _BTERM_LOAN_FEE_EXP_L | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/lossSwapBasetermLoanFeeExpLocal | |||||||||||
| termLoanFeeIncLocaltermLoanFeeExpBase | Optional | decimal | 844847 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | TERM_LOAN_FEE_INCEXP_LB | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/termLoanFeeIncLocaltermLoanFeeExpBase | |||||||||||
| termLoanFeeIncBasecommAmountBase | Optional | decimal | 845498 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | TERMCOMM_LOANAMT_FEE_INC_B | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/termLoanFeeIncBasecommAmountBase | |||||||||||
| termLoanFeeExpLocalotherFeeBase | Optional | decimal | 8465708 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | TERMOTHER_LOAN_FEE_EXP_LB | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/termLoanFeeExpLocalotherFeeBase | |||||||||||
| termLoanFeeExpBasesecFeeBase | Optional | decimal | 84710122 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | TERM_LOANSEC_FEE_EXP_B | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/termLoanFeeExpBasesecFeeBase | |||||||||||
| commAmountBasestampDutyTaxBase | Optional | decimal | 49810121 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | COMMSTAMP_DUTY_AMTTAX_B | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/commAmountBasestampDutyTaxBase | |||||||||||
| otherFeeBasefedTaxWithholdingBase | Optional | decimal | 57088078 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | OTHERFED_TAX_FEEWITHHOLD_B | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/otherFeeBasefedTaxWithholdingBase | |||||||||||
| secFeeBasestTaxWithholdingBase | Optional | decimal | 101228079 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | SECST_TAX_FEEWITHHOLD_B | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/secFeeBasestTaxWithholdingBase | |||||||||||
| stampDutyTaxBasestreamSecAlias | Optional | decimalinteger | 10121 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYSTAMP | STREAM_DUTYSEC_TAX_BALIAS | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/stampDutyTaxBasestreamSecAlias | |||||||||||
| fedTaxWithholdingBasetaxAmountBase | Optional | decimal | 807810759 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | FED_TAX_WITHHOLDAMT_B | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/fedTaxWithholdingBasetaxAmountBase | |||||||||||
| stTaxWithholdingBasebuWithholdingLocal | Optional | decimal | 80792712 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYST | BU_TAXWTHHLD_WITHHOLD_BL | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/stTaxWithholdingBasebuWithholdingLocal | |||||||||||
| streamSecAliasbuWithholdingBase | Optional | decimalinteger | 2713 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | STREAMBU_SECWTHHLD_ALIASB | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/streamSecAliasbuWithholdingBase | |||||||||||
| taxAmountBasebuWithholdingRate | Optional | decimal | 107592762 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | TAXBU_AMTWTHHLD_BRATE | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/taxAmountBasebuWithholdingRate | |||||||||||
| buWithholdingLocalprice | Optional | decimal | 271245 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYBU_WTHHLD_L | PRICE | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/buWithholdingLocalprice | |||||||||||
| buWithholdingBasecancelType | Optional | decimalstring | 27132981 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYBU | CANCEL_WTHHLD_BTYPE | NUMBERVARCHAR2(38,121) | EagleML/accountingTransaction/settledCashActivity/buWithholdingBasecancelType | |||||||||||
| buWithholdingRatecancelFlag | Optional | decimalstring | 276210045 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYBU | CANCEL_WTHHLD_RATEFLAG | NUMBERVARCHAR2(38,121) | EagleML/accountingTransaction/settledCashActivity/buWithholdingRatecancelFlag | |||||||||||
| pricecouponDate | Optional | decimaldate | 453460 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | PRICE | NUMBER(38,12)COUPON_DATE | DATE | EagleML/accountingTransaction/settledCashActivity/pricecouponDate | ||||||||||
| cancelTypecashEventSpawned | Optional | string | 2981751 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CANCELCASH_EVENT_TYPESPAWNED | VARCHAR2(1) | EagleML/accountingTransaction/settledCashActivity/cancelTypecashEventSpawned | |||||||||||
| cancelFlagbackupCouponEndDate | Optional | string | 10045date | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CANCEL_FLAG | VARCHAR2(1)BKUP_COUPON_END_DATE | DATE | EagleML/accountingTransaction/settledCashActivity/cancelFlagbackupCouponEndDate | ||||||||||
| couponDateorigContSettleDate | Optional | date | 3460 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYCOUPON | _DATEORIG_CONT_SETTLE_DT | DATE | EagleML/accountingTransaction/settledCashActivity/couponDateorigContSettleDate | |||||||||||
| cashEventSpawnedperiodicDistType | Optional | string | 7511737 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CASHPERIODIC_EVENTDIST_SPAWNEDTYPE | VARCHAR2(12) | EagleML/accountingTransaction/settledCashActivity/cashEventSpawnedperiodicDistType | |||||||||||
| backupCouponEndDatecostLotOpenEventId | Optional | dateTransactionId | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYBKUP | COST_LOT_COUPONOPEN_ENDEVT_DATEDATEID | VARCHAR2(55) | EagleML/accountingTransaction/settledCashActivity/backupCouponEndDatecostLotOpenEventId | ||||||||||||
| origContSettleDatecostLotCloseEventId | Optional | dateTransactionId | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYORIG | COST_LOT_CONTCLOSE_SETTLEEVT_DTDATEID | VARCHAR2(55) | EagleML/accountingTransaction/settledCashActivity/origContSettleDatecostLotCloseEventId | ||||||||||||
| periodicDistTypecorpActionType | Optional | string | 1737 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | PERIODICCORP_DISTACTION_TYPE | VARCHAR2(250) | EagleML/accountingTransaction/settledCashActivity/periodicDistTypecorpActionType | |||||||||||
| costLotOpenEventIdcashAccountName | Optional | TransactionIdstring | 11696 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYCOST | CASH_LOT_OPEN_EVT_IDACCT_NAME | VARCHAR2(5550) | EagleML/accountingTransaction/settledCashActivity/costLotOpenEventIdcashAccountName | |||||||||||
| costLotCloseEventIdcashAccount | Optional | stringTransactionId | 11697 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYCOST_LOT_CLOSE_EVT_ID | CASH_ACCT | VARCHAR2(5520) | EagleML/accountingTransaction/settledCashActivity/costLotCloseEventIdcashAccount | |||||||||||
| corpActionTypecashAccountAlias | Optional | stringinteger | 11698 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CORPCASH_ACTIONACCT_TYPEALIAS | VARCHAR2NUMBER(5038) | EagleML/accountingTransaction/settledCashActivity/corpActionTypecashAccountAlias | |||||||||||
| cashAccountNamesrcSysC | Optional | string | 1169698 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CASHSRC_ACCTSYS_NAMEC | VARCHAR2(5025) | EagleML/accountingTransaction/settledCashActivity/cashAccountNamesrcSysC | |||||||||||
| cashAccountsettleCashDivUgl | Optional | string | 11697decimal | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | STL_CASH_ACCTDIV_UGL | VARCHAR2NUMBER(2038,12) | EagleML/accountingTransaction/settledCashActivity/cashAccountsettleCashDivUgl | |||||||||||
| cashAccountAliasbreakageUnderLocal | Optional | integerdecimal | 116981994 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CASHBREAKAGE_AMT_ACCTUNDER_ALIASL | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/cashAccountAliasbreakageUnderLocal | |||||||||||
| srcSysCbreakageOverLocal | Optional | stringdecimal | 981996 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | SRCBREAKAGE_AMT_SYSOVER_CL | VARCHAR2NUMBER(2538,12) | EagleML/accountingTransaction/settledCashActivity/srcSysCbreakageOverLocal | |||||||||||
| settleCashDivUgltradedDate | Optional | datedecimal | 35 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | STL_CASH_DIV_UGL | NUMBER(38,12)TRADE_DATE | DATE | EagleML/accountingTransaction/settledCashActivity/settleCashDivUgltradedDate | breakageUnderLocal||||||||||
| cashMatchInstance | Optional | ||||||||||||||||||
| integer | 1994 | ||||||||||||||||||
| ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | ||||||||||||||||||
| CASH_ | |||||||||||||||||||
| MATCH_ | |||||||||||||||||||
| INSTANCE | NUMBER(38 | ||||||||||||||||||
| ) | EagleML/accountingTransaction/settledCashActivity/ | breakageOverLocal | Optional | decimal | 1996 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | BREAKAGE_AMT_OVER_L | NUMBER(38,12) | ||||||||||
| cashMatchInstance | |||||||||||||||||||
| 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 | string | 2983 | EagleML/accountingTransaction/settledCashActivity/ | |||||||||||||||
| calcTransactionId | |||||||||||||||||||
| calcMasterTransactionId | Optional | date | 35 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | TRADE_DATE | |||||||||||||
| string | 2984 | EagleML/accountingTransaction/settledCashActivity/ | |||||||||||||||||
| calcMasterTransactionId | cashMatchInstance | Optional | integer | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CASH_MATCH_INSTANCE | |||||||||||||
| calcCancelTransactionId | Optional | string | 2985 | EagleML/accountingTransaction/settledCashActivity/cashMatchInstancecalcCancelTransactionId | |||||||||||||||
| To add the | |||||||||||||||||||
| element below, please set | |||||||||||||||||||
| IncludeAssetToBaseFxRate= | |||||||||||||||||||
| Y in the RTR. | |||||||||||||||||||
| assetToBaseFxRate | Optional | string | 2983decimal | not stored in DB | EagleML/accountingTransaction/settledCashActivity/calcTransactionIdassetToBaseFxRate | calcMasterTransactionId||||||||||||||
| custodyBankAccountNumber | Optional | string | 2984RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_ACCT_NUM | VARCHAR2(30) | EagleML/accountingTransaction/settledCashActivity/ | calcMasterTransactionIdcustodyBankAccountNumber | |||||||||||
| custodyBankCode | Optional | string | 2985RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_CODE | CHAR(20) | EagleML/accountingTransaction/settledCashActivity/ | calcCancelTransactionId||||||||||||
| To add the element below, please set IncludeAssetToBaseFxRate=Y in the RTR. | |||||||||||||||||||
| assetToBaseFxRate | Optional | decimal | not stored in DBcustodyBankCode | ||||||||||||||||
| custodyBankDesc | Optional | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_DESC | CHAR(50) | EagleML/accountingTransaction/settledCashActivity/ | assetToBaseFxRatecustodyBankDesc | |||||||||||