Traded Cash Activity Data Map Table
- Natalie Gesin (Deactivated)
- Vitali Kostyrenko
- Dmitry Donosiyan (Unlicensed)
- Nancy Cohn (Deactivated)
Owned by Natalie Gesin (Deactivated)
Note
To extract calcTransactionId, calcMasterTransactionId, calcCancelTransactionId please set the IncludeExtendedDetails task parameter to Y or ALL in your RTR. For more information, see Use Calculated IDs for Transactions.
| 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/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 | 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 | ACCOUNT_DT | DATE | EagleML/accountingTransaction/tradedCashActivity/accountingDate |
| monthEndAccountingDate | Optional | date | 4733 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | MONTH_END_ACCT_DT | DATE | EagleML/accountingTransaction/tradedCashActivity/monthEndAccountingDate |
| units | Optional | decimal | 40 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | UNITS | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/units |
| amount | Optional | decimal | 50 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | AMOUNT | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/amount |
| principal | Optional | decimal | 165 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PRINCIPAL | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/principal |
| income | Optional | decimal | 1985 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INCOME | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/income |
| navId | Optional | integer | 3196 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | NAV_ID | NUMBER | EagleML/accountingTransaction/tradedCashActivity/navId |
| cashStatus | Optional | string | 54 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CASH_STATUS | VARCHAR2(20) | EagleML/accountingTransaction/tradedCashActivity/cashStatus |
| cashCategory | Optional | string | 62 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CASH_CATEGORY | VARCHAR2(50) | EagleML/accountingTransaction/tradedCashActivity/cashCategory |
| bankAlias | Optional | string | 16 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BANK_ALIAS | VARCHAR2(25) | EagleML/accountingTransaction/tradedCashActivity/bankAlias |
| autoSettleIndicator | Optional | YesNoOptionEnum | 58 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | AUTO_SETTLE_INDICATOR | VARCHAR2(2) | EagleML/accountingTransaction/tradedCashActivity/autoSettleIndicator |
| corpActionId | Optional | integer | 60 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CORP_ACTION_ID | NUMBER(22) | EagleML/accountingTransaction/tradedCashActivity/corpActionId |
| ledgerBalanceEntitlement | Optional | string | 3970 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LDGR_BAL_ENTITLEMENT | VARCHAR2(1) | EagleML/accountingTransaction/tradedCashActivity/ledgerBalanceEntitlement |
| accountingPlan | Optional | integer | 999 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | ACCTG_PLAN | NUMBER | EagleML/accountingTransaction/tradedCashActivity/accountingPlan |
| positingPlan | Optional | integer | 913 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | POSTING_PLAN | NUMBER | EagleML/accountingTransaction/tradedCashActivity/positingPlan |
| recPayPlan | Optional | string | 1831 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | REC_PAY_PLAN | VARCHAR2(15) | EagleML/accountingTransaction/tradedCashActivity/recPayPlan |
| withholdingLocal | Optional | decimal | 853 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | WITHHOLDING_L | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/withholdingLocal |
| reclaimLocal | Optional | decimal | 852 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | RECLAIM_L | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/reclaimLocal |
| reclaimMethod | Optional | string | 3912 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | RECLAIM_METHOD | CHAR(2) | EagleML/accountingTransaction/tradedCashActivity/reclaimMethod |
| batchEventId | Optional | TransactionId | 701 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BATCH_EVENT_ID | VARCHAR2(55) | EagleML/accountingTransaction/tradedCashActivity/batchEventId |
| contSettleDate | Optional | date | 9968 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CONT_SETTLE_DT | DATE | EagleML/accountingTransaction/tradedCashActivity/contSettleDate |
| linkEventId | Optional | TransactionId | 28 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LINK_EVENT_ID | VARCHAR2(55) | EagleML/accountingTransaction/tradedCashActivity/linkEventId |
| targetEventId | Optional | string | 36 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TARGET_EVT_ID | VARCHAR2(55) | EagleML/accountingTransaction/tradedCashActivity/targetEventId |
| eventReason | Optional | string | 56 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | EVENT_REASON | VARCHAR2(55) | EagleML/accountingTransaction/tradedCashActivity/eventReason |
| cancelEventId | Optional | TransactionId | 501 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CANCEL_EVT_ID | VARCHAR2(55) | EagleML/accountingTransaction/tradedCashActivity/cancelEventId |
| cancelSequence | Optional | integer | 226 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CANCEL_SEQUENCE | NUMBER(28) | EagleML/accountingTransaction/tradedCashActivity/cancelSequence |
| recPayAccount2 | Optional | string | 1826 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | REC_PAY_ACCT2 | VARCHAR2(10) | EagleML/accountingTransaction/tradedCashActivity/recPayAccount2 |
| principalBreakageUnder | Optional | decimal | 10134 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PRINCIPAL_BREAKAGE_UNDER | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/principalBreakageUnder |
| principalBreakageOver | Optional | decimal | 10135 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PRINCIPAL_BREAKAGE_OVER | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/principalBreakageOver |
| incomeBreakageUnder | Optional | decimal | 10136 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INCOME_BREAKAGE_UNDER | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/incomeBreakageUnder |
| incomeBreakageOver | Optional | decimal | 10137 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INCOME_BREAKAGE_OVER | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/incomeBreakageOver |
| otherFeeLocal | Optional | decimal | 3752 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | OTHER_FEE_LOCAL | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/otherFeeLocal |
| stampDutyTaxLocal | Optional | decimal | 51 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | STAMP_DUTY_TAX_L | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/stampDutyTaxLocal |
| commAmountLocal | Optional | decimal | 47 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | COMM_AMT_L | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/commAmountLocal |
| taxAmountLocal | Optional | decimal | 46 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAX_AMT_L | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/taxAmountLocal |
| secFee | Optional | decimal | 48 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SEC_FEE | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/secFee |
| backupPrice | Optional | decimal | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BKUP_PRICE | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/backupPrice | |
| settleAmountLocal | Optional | decimal | 5363 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SETTLE_AMOUNT_LOCAL | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/settleAmountLocal |
| brokerCode | Optional | string | 88 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BROKER_CODE | CHAR(20) | EagleML/accountingTransaction/tradedCashActivity/brokerCode |
| dividendRate | Optional | decimal | 368 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | DIVIDEND_RATE | NUMBER(28,12) | EagleML/accountingTransaction/tradedCashActivity/dividendRate |
| currencyGain | Optional | decimal | 198 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | GAIN_CURRENCY | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/currencyGain |
| currencyLoss | Optional | decimal | 199 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LOSS_CURRENCY | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/currencyLoss |
| localAssetCurrency | Optional | CurrencyCode | 9061 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LOCAL_ASSET_CURRENCY | VARCHAR2(3) | EagleML/accountingTransaction/tradedCashActivity/localAssetCurrency |
| masterTicketNumber | Optional | string | 761 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | MASTER_TICKET_NUMBER | VARCHAR2(55) | EagleML/accountingTransaction/tradedCashActivity/masterTicketNumber |
| tradeDateFxRate | Optional | decimal | 87 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TRADE_DT_FX_RATE | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/tradeDateFxRate |
| corpActInstance | Optional | integer | 4268 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CORP_ACT_INSTANCE | NUMBER | EagleML/accountingTransaction/tradedCashActivity/corpActInstance |
| netAmountBase | Optional | decimal | 478 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | NET_AMOUNT_BASE | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/netAmountBase |
| principalAmountBase | Optional | decimal | 169 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PRINCIPAL_AMOUNT_BASE | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/principalAmountBase |
| incomeAmountBase | Optional | decimal | 1986 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INCOME_AMOUNT_BASE | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/incomeAmountBase |
| recPayAccount | Optional | string | 1825 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | REC_PAY_ACCT | VARCHAR2(10) | EagleML/accountingTransaction/tradedCashActivity/recPayAccount |
| recPayAccountDesc | Optional | string | 1651 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | REC_PAY_ACCT_DESC | VARCHAR2(100) | EagleML/accountingTransaction/tradedCashActivity/recPayAccountDesc |
| reclaimAmountBase | Optional | decimal | 851 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | RECLAIM_AMOUNT_BASE | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/reclaimAmountBase |
| taxExpenseBase | Optional | decimal | 854 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAX_EXPENSE_BASE | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/taxExpenseBase |
| breakageAmountUnderBase | Optional | decimal | 1995 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BREAKAGE_AMT_UNDER_B | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/breakageAmountUnderBase |
| breakageAmountOverBase | Optional | decimal | 1997 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BREAKAGE_AMT_OVER_B | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/breakageAmountOverBase |
| recPayAmountLocal | Optional | decimal | 11781 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | REC_PAY_AMT_L | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/recPayAmountLocal |
| recPayAmountBase | Optional | decimal | 11782 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | REC_PAY_AMT_B | NUMBER(38,6) | EagleML/accountingTransaction/tradedCashActivity/recPayAmountBase |
| clearingBroker | Optional | string | 1236 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CLEARING_BROKER | VARCHAR2(50) | EagleML/accountingTransaction/tradedCashActivity/clearingBroker |
| taxReclaimRate | Optional | decimal | 1296 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAX_RECLAIM_RATE | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/taxReclaimRate |
| taxWithholdingRate | Optional | decimal | 1295 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAX_WITHHOLDING_RATE | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/taxWithholdingRate |
| specialReclaimRate | Optional | decimal | 1298 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SPECIAL_RECLAIM_RATE | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/specialReclaimRate |
| specialWithholdingRate | Optional | decimal | 1297 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SPECIAL_WITHHOLDING_RATE | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/specialWithholdingRate |
| sourceEventId | Optional | TransactionId | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SOURCE_EVENT_ID | VARCHAR2(55) | EagleML/accountingTransaction/tradedCashActivity/sourceEventId | |
| targetAccountDate | Optional | date | 119 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TARGET_ACCT_DATE | DATE | EagleML/accountingTransaction/tradedCashActivity/targetAccountDate |
| gainSwapLocal | Optional | decimal | 11819 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | GAIN_SWAP_L | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/gainSwapLocal |
| lossSwapLocal | Optional | decimal | 11821 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LOSS_SWAP_L | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/lossSwapLocal |
| gainSwapBase | Optional | decimal | 11820 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | GAIN_SWAP_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/gainSwapBase |
| lossSwapBase | Optional | decimal | 11822 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LOSS_SWAP_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/lossSwapBase |
| termLoanFeeIncLocal | Optional | decimal | 844 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TERM_LOAN_FEE_INC_L | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/termLoanFeeIncLocal |
| termLoanFeeIncBase | Optional | decimal | 845 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TERM_LOAN_FEE_INC_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/termLoanFeeIncBase |
| termLoanFeeExpLocal | Optional | decimal | 846 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TERM_LOAN_FEE_EXP_L | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/termLoanFeeExpLocal |
| termLoanFeeExpBase | Optional | decimal | 847 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TERM_LOAN_FEE_EXP_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/termLoanFeeExpBase |
| commAmountBase | Optional | decimal | 498 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | COMM_AMT_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/commAmountBase |
| otherFeeBase | Optional | decimal | 5708 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | OTHER_FEE_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/otherFeeBase |
| secFeeBase | Optional | decimal | 10122 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SEC_FEE_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/secFeeBase |
| stampDutyTaxBase | Optional | decimal | 10121 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | STAMP_DUTY_TAX_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/stampDutyTaxBase |
| fedTaxWithholdingBase | Optional | decimal | 8078 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | FED_TAX_WITHHOLD_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/fedTaxWithholdingBase |
| stTaxWithholdingBase | Optional | decimal | 8079 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | ST_TAX_WITHHOLD_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/stTaxWithholdingBase |
| streamSecAlias | Optional | integer | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | STREAM_SEC_ALIAS | NUMBER(38) | EagleML/accountingTransaction/tradedCashActivity/streamSecAlias | |
| taxAmountBase | Optional | decimal | 10759 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAX_AMT_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/taxAmountBase |
| buWithholdingLocal | Optional | decimal | 2712 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BU_WTHHLD_L | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/buWithholdingLocal |
| buWithholdingBase | Optional | decimal | 2713 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BU_WTHHLD_B | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/buWithholdingBase |
| buWithholdingRate | Optional | decimal | 2762 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BU_WTHHLD_RATE | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/buWithholdingRate |
| price | Optional | decimal | 45 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PRICE | NUMBER(38,12) | EagleML/accountingTransaction/tradedCashActivity/price |
| cancelType | Optional | string | 2981 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CANCEL_TYPE | VARCHAR2(1) | EagleML/accountingTransaction/tradedCashActivity/cancelType |
| cancelFlag | Optional | string | 10045 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CANCEL_FLAG | VARCHAR2(1) | EagleML/accountingTransaction/tradedCashActivity/cancelFlag |
| couponDate | Optional | date | 3460 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | COUPON_DATE | DATE | EagleML/accountingTransaction/tradedCashActivity/couponDate |
| cashEventSpawned | Optional | string | 751 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CASH_EVENT_SPAWNED | VARCHAR2(1) | EagleML/accountingTransaction/tradedCashActivity/cashEventSpawned |
| backupCouponEndDate | Optional | date | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BKUP_COUPON_END_DATE | DATE | EagleML/accountingTransaction/tradedCashActivity/backupCouponEndDate | |
| origContSettleDate | Optional | date | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | ORIG_CONT_SETTLE_DT | DATE | EagleML/accountingTransaction/tradedCashActivity/origContSettleDate | |
| periodicDistType | Optional | string | 1737 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PERIODIC_DIST_TYPE | VARCHAR2(2) | EagleML/accountingTransaction/tradedCashActivity/periodicDistType |
| costLotOpenEventId | Optional | TransactionId | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | COST_LOT_OPEN_EVT_ID | VARCHAR2(55) | EagleML/accountingTransaction/tradedCashActivity/costLotOpenEventId | |
| costLotCloseEventId | Optional | TransactionId | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | COST_LOT_CLOSE_EVT_ID | VARCHAR2(55) | EagleML/accountingTransaction/tradedCashActivity/costLotCloseEventId | |
| corpActionType | Optional | string | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CORP_ACTION_TYPE | VARCHAR2(50) | EagleML/accountingTransaction/tradedCashActivity/corpActionType | |
| cashAccountName | Optional | string | 11696 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CASH_ACCT_NAME | VARCHAR2(50) | EagleML/accountingTransaction/tradedCashActivity/cashAccountName |
| cashAccount | Optional | string | 11697 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CASH_ACCT | VARCHAR2(20) | EagleML/accountingTransaction/tradedCashActivity/cashAccount |
| cashAccountAlias | Optional | integer | 11698 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CASH_ACCT_ALIAS | NUMBER(38) | EagleML/accountingTransaction/tradedCashActivity/cashAccountAlias |
| srcSysC | Optional | string | 98 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SRC_SYS_C | VARCHAR2(25) | EagleML/accountingTransaction/tradedCashActivity/srcSysC |
| To add the elements below, please set IncludeExtendedDetails=ALL or IncludeExtendedDetails=Y in the RTR. For more information, see Use Calculated IDs for Transactions. | ||||||||
| calcTransactionId | Optional | string | 2983 | EagleML/accountingTransaction/tradedCashActivity/calcTransactionId | ||||
| calcMasterTransactionId | Optional | string | 2984 | EagleML/accountingTransaction/tradedCashActivity/calcMasterTransactionId | ||||
| calcCancelTransactionId | Optional | string | 2985 | EagleML/accountingTransaction/tradedCashActivity/calcCancelTransactionId | ||||
| To add the element below, please set IncludeAssetToBaseFxRate=Y in the RTR. | ||||||||
| assetToBaseFxRate | Optional | decimal | not stored in DB | EagleML/accountingTransaction/tradedCashActivity/assetToBaseFxRate | ||||
| custodyBankAccountNumber | Optional | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_ACCT_NUM | VARCHAR2(30) | EagleML/accountingTransaction/tradedCashActivity/custodyBankAccountNumber | |
| custodyBankCode | Optional | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_CODE | CHAR(20) | EagleML/accountingTransaction/tradedCashActivity/custodyBankCode | |
| custodyBankDesc | Optional | string | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_DESC | CHAR(50) | EagleML/accountingTransaction/tradedCashActivity/custodyBankDesc | |