...
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 |