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/ | |||||||||||||
Entity Properties Model (extract only) | EagleML/accountingTransaction/settledCashActivity/ | |||||||||||||
Asset Identifiers Model | EagleML/accountingTransaction/settledCashActivity/ | |||||||||||||
Extended Asset Properties Model (extract only) | EagleML/accountingTransaction/settledCashActivity/ | |||||||||||||
Extended CA Properties Model (extract only) | EagleML/accountingTransaction/settledCashActivity/ | |||||||||||||
effectiveDate | Optional | date | 1109 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | EFFECTIVE_DT | DATE | EagleML/accountingTransaction/settledCashActivity/effectiveDate | ||||||
instance | Optional | integer | 9388 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | INSTANCE | NUMBER(38) | EagleML/accountingTransaction/settledCashActivity/instance | ||||||
localCurrency | Optional | CurrencyCode | 63 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | LOCAL_CURR | VARCHAR2(3) | EagleML/accountingTransaction/settledCashActivity/localCurrency | ||||||
baseCurrency | Optional | CurrencyCode | 86 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | BASE_CURR | VARCHAR2(3) | EagleML/accountingTransaction/settledCashActivity/baseCurrency | ||||||
accountingBasis | Optional | string | 21 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | ACCT_BASIS | VARCHAR2(5) | EagleML/accountingTransaction/settledCashActivity/accountingBasis | ||||||
longShortC | Optional | string | 15 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | LNG_SHT_C | CHAR(1) | EagleML/accountingTransaction/settledCashActivity/longShortC | ||||||
backupSrcSysC | Optional | string | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | BKUP_SRC_SYS_C | CHAR(1) | EagleML/accountingTransaction/settledCashActivity/backupSrcSysC | |||||||
starPositionId | Optional | integer | 830 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | POSN_ID | NUMBER(28) | EagleML/accountingTransaction/settledCashActivity/starPositionId | ||||||
settleAsset | Optional | Asset Identifiers Model - (see extra table) | EagleML/accountingTransaction/settledCashActivity/settleAsset/ | |||||||||||
shareClass | Optional | string | 34 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | SHARE_CLASS | VARCHAR2(10) | EagleML/accountingTransaction/settledCashActivity/shareClass | ||||||
eventId | Optional | TransactionId | 25 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | EVENT_ID | VARCHAR2(55) | EagleML/accountingTransaction/settledCashActivity/eventId | ||||||
starEventType | Optional | string | 2362 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | EVENT_TYPE | VARCHAR2(25) | EagleML/accountingTransaction/settledCashActivity/starEventType | ||||||
eventType | Optional | string | 53 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CASH_EVT_TYP | VARCHAR2(10) | EagleML/accountingTransaction/settledCashActivity/eventType | ||||||
eventSequence | Optional | integer | 126 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | EVENT_SEQUENCE | NUMBER(28) | EagleML/accountingTransaction/settledCashActivity/eventSequence | ||||||
processDate | Optional | date | 30 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | PROCESS_DT | DATE | EagleML/accountingTransaction/settledCashActivity/processDate | ||||||
accountingDate | Optional | date | 36 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | ACCOUNT_DT | DATE | EagleML/accountingTransaction/settledCashActivity/accountingDate | ||||||
monthEndAccountingDate | Optional | date | 4733 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | MONTH_END_ACCT_DT | DATE | EagleML/accountingTransaction/settledCashActivity/monthEndAccountingDate | ||||||
units | Optional | decimal | 40 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | UNITS | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/units | ||||||
amount | Optional | decimal | 50 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | AMOUNT | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/amount | ||||||
principal | Optional | decimal | 165 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | PRINCIPAL | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/principal | ||||||
income | Optional | decimal | 1985 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | INCOME | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/income | ||||||
navId | Optional | integer | 3196 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | NAV_ID | NUMBER | EagleML/accountingTransaction/settledCashActivity/navId | ||||||
cashStatus | Optional | string | 54 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CASH_STATUS | VARCHAR2(20) | EagleML/accountingTransaction/settledCashActivity/cashStatus | ||||||
cashCategory | Optional | string | 62 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CASH_CATEGORY | VARCHAR2(50) | EagleML/accountingTransaction/settledCashActivity/cashCategory | ||||||
bankAlias | Optional | string | 16 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | BANK_ALIAS | VARCHAR2(25) | EagleML/accountingTransaction/settledCashActivity/bankAlias | ||||||
autoSettleIndicator | Optional | YesNoOptionEnum | 58 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | AUTO_SETTLE_INDICATOR | VARCHAR2(2) | EagleML/accountingTransaction/settledCashActivity/autoSettleIndicator | ||||||
corpActionId | Optional | integer | 60 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CORP_ACTION_ID | NUMBER(22) | EagleML/accountingTransaction/settledCashActivity/corpActionId | ||||||
ledgerBalanceEntitlement | Optional | string | 3970 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | LDGR_BAL_ENTITLEMENT | VARCHAR2(1) | EagleML/accountingTransaction/settledCashActivity/ledgerBalanceEntitlement | ||||||
accountingPlan | Optional | integer | 999 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | ACCTG_PLAN | NUMBER | EagleML/accountingTransaction/settledCashActivity/accountingPlan | ||||||
positingPlan | Optional | integer | 913 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | POSTING_PLAN | NUMBER | EagleML/accountingTransaction/settledCashActivity/positingPlan | ||||||
recPayPlan | Optional | string | 1831 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | REC_PAY_PLAN | VARCHAR2(15) | EagleML/accountingTransaction/settledCashActivity/recPayPlan | ||||||
withholdingLocal | Optional | decimal | 853 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | WITHHOLDING_L | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/withholdingLocal | ||||||
reclaimLocal | Optional | decimal | 852 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | RECLAIM_L | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/reclaimLocal | ||||||
reclaimMethod | Optional | string | 3912 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | RECLAIM_METHOD | CHAR(2) | EagleML/accountingTransaction/settledCashActivity/reclaimMethod | ||||||
batchEventId | Optional | TransactionId | 701 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | BATCH_EVENT_ID | VARCHAR2(55) | EagleML/accountingTransaction/settledCashActivity/batchEventId | ||||||
contSettleDate | Optional | date | 9968 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CONT_SETTLE_DT | DATE | EagleML/accountingTransaction/settledCashActivity/contSettleDate | ||||||
linkEventId | Optional | TransactionId | 28 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | LINK_EVENT_ID | VARCHAR2(55) | EagleML/accountingTransaction/settledCashActivity/linkEventId | ||||||
targetEventId | Optional | string | 36 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | TARGET_EVT_ID | VARCHAR2(55) | EagleML/accountingTransaction/settledCashActivity/targetEventId | ||||||
eventReason | Optional | string | 56 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | EVENT_REASON | VARCHAR2(55) | EagleML/accountingTransaction/settledCashActivity/eventReason | ||||||
cancelEventId | Optional | TransactionId | 501 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CANCEL_EVT_ID | VARCHAR2(55) | EagleML/accountingTransaction/settledCashActivity/cancelEventId | ||||||
cancelSequence | Optional | integer | 226 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CANCEL_SEQUENCE | NUMBER(28) | EagleML/accountingTransaction/settledCashActivity/cancelSequence | ||||||
recPayAccount2 | Optional | string | 1826 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | REC_PAY_ACCT2 | VARCHAR2(10) | EagleML/accountingTransaction/settledCashActivity/recPayAccount2 | ||||||
principalBreakageUnder | Optional | decimal | 10134 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | PRINCIPAL_BREAKAGE_UNDER | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/principalBreakageUnder | ||||||
principalBreakageOver | Optional | decimal | 10135 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | PRINCIPAL_BREAKAGE_OVER | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/principalBreakageOver | ||||||
incomeBreakageUnder | Optional | decimal | 10136 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | INCOME_BREAKAGE_UNDER | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/incomeBreakageUnder | ||||||
incomeBreakageOver | Optional | decimal | 10137 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | INCOME_BREAKAGE_OVER | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/incomeBreakageOver | ||||||
otherFeeLocal | Optional | decimal | 3752 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | OTHER_FEE_LOCAL | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/otherFeeLocal | ||||||
stampDutyTaxLocal | Optional | decimal | 51 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | STAMP_DUTY_TAX_L | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/stampDutyTaxLocal | ||||||
commAmountLocal | Optional | decimal | 47 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | COMM_AMT_L | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/commAmountLocal | ||||||
taxAmountLocal | Optional | decimal | 46 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | TAX_AMT_L | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/taxAmountLocal | ||||||
secFee | Optional | decimal | 48 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | SEC_FEE | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/secFee | ||||||
backupPrice | Optional | decimal | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | BKUP_PRICE | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/backupPrice | |||||||
settleAmountLocal | Optional | decimal | 5363 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | SETTLE_AMOUNT_LOCAL | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/settleAmountLocal | ||||||
brokerCode | Optional | string | 88 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | BROKER_CODE | CHAR(20) | EagleML/accountingTransaction/settledCashActivity/brokerCode | ||||||
dividendRate | Optional | decimal | 368 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | DIVIDEND_RATE | NUMBER(28,12) | EagleML/accountingTransaction/settledCashActivity/dividendRate | ||||||
currencyGain | Optional | decimal | 198 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | GAIN_CURRENCY | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/currencyGain | ||||||
currencyLoss | Optional | decimal | 199 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | LOSS_CURRENCY | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/currencyLoss | ||||||
localAssetCurrency | Optional | CurrencyCode | 9061 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | LOCAL_ASSET_CURRENCY | VARCHAR2(3) | EagleML/accountingTransaction/settledCashActivity/localAssetCurrency | ||||||
masterTicketNumber | Optional | string | 761 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | MASTER_TICKET_NUMBER | VARCHAR2(55) | EagleML/accountingTransaction/settledCashActivity/masterTicketNumber | ||||||
tradeDateFxRate | Optional | decimal | 87 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | TRADE_DT_FX_RATE | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/tradeDateFxRate | ||||||
corpActInstance | Optional | integer | 4268 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CORP_ACT_INSTANCE | NUMBER | EagleML/accountingTransaction/settledCashActivity/corpActInstance | ||||||
netAmountBase | Optional | decimal | 478 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | NET_AMOUNT_BASE | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/netAmountBase | ||||||
principalAmountBase | Optional | decimal | 169 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | PRINCIPAL_AMOUNT_BASE | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/principalAmountBase | ||||||
incomeAmountBase | Optional | decimal | 1986 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | INCOME_AMOUNT_BASE | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/incomeAmountBase | ||||||
recPayAccount | Optional | string | 1825 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | REC_PAY_ACCT | VARCHAR2(10) | EagleML/accountingTransaction/settledCashActivity/recPayAccount | ||||||
recPayAccountDesc | Optional | string | 1651 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | REC_PAY_ACCT_DESC | VARCHAR2(100) | EagleML/accountingTransaction/settledCashActivity/recPayAccountDesc | ||||||
reclaimAmountBase | Optional | decimal | 851 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | RECLAIM_AMOUNT_BASE | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/reclaimAmountBase | ||||||
taxExpenseBase | Optional | decimal | 854 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | TAX_EXPENSE_BASE | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/taxExpenseBase | ||||||
breakageAmountUnderBase | Optional | decimal | 1995 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | BREAKAGE_AMT_UNDER_B | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/breakageAmountUnderBase | ||||||
breakageAmountOverBase | Optional | decimal | 1997 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | BREAKAGE_AMT_OVER_B | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/breakageAmountOverBase | ||||||
recPayAmountLocal | Optional | decimal | 11781 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | REC_PAY_AMT_L | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/recPayAmountLocal | ||||||
recPayAmountBase | Optional | decimal | 11782 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | REC_PAY_AMT_B | NUMBER(38,6) | EagleML/accountingTransaction/settledCashActivity/recPayAmountBase | ||||||
clearingBroker | Optional | string | 1236 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CLEARING_BROKER | VARCHAR2(50) | EagleML/accountingTransaction/settledCashActivity/clearingBroker | ||||||
taxReclaimRate | Optional | decimal | 1296 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | TAX_RECLAIM_RATE | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/taxReclaimRate | ||||||
taxWithholdingRate | Optional | decimal | 1295 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | TAX_WITHHOLDING_RATE | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/taxWithholdingRate | ||||||
specialReclaimRate | Optional | decimal | 1298 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | SPECIAL_RECLAIM_RATE | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/specialReclaimRate | ||||||
specialWithholdingRate | Optional | decimal | 1297 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | SPECIAL_WITHHOLDING_RATE | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/specialWithholdingRate | ||||||
sourceEventId | Optional | TransactionId | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | SOURCE_REFERENCE_ID | VARCHAR2(55) | EagleML/accountingTransaction/settledCashActivity/sourceEventId | |||||||
targetAccountDate | Optional | date | 119 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | TARGET_ACCT_DATE | DATE | EagleML/accountingTransaction/settledCashActivity/targetAccountDate | ||||||
gainSwapLocal | Optional | decimal | 11819 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | GAIN_SWAP_L | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/gainSwapLocal | ||||||
lossSwapLocal | Optional | decimal | 11821 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | LOSS_SWAP_L | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/lossSwapLocal | ||||||
gainSwapBase | Optional | decimal | 11820 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | GAIN_SWAP_B | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/gainSwapBase | ||||||
lossSwapBase | Optional | decimal | 11822 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | LOSS_SWAP_B | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/lossSwapBase | ||||||
termLoanFeeIncLocal | Optional | decimal | 844 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | TERM_LOAN_FEE_INC_L | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/termLoanFeeIncLocal | ||||||
termLoanFeeIncBase | Optional | decimal | 845 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | TERM_LOAN_FEE_INC_B | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/termLoanFeeIncBase | ||||||
termLoanFeeExpLocal | Optional | decimal | 846 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | TERM_LOAN_FEE_EXP_L | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/termLoanFeeExpLocal | ||||||
termLoanFeeExpBase | Optional | decimal | 847 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | TERM_LOAN_FEE_EXP_B | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/termLoanFeeExpBase | ||||||
commAmountBase | Optional | decimal | 498 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | COMM_AMT_B | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/commAmountBase | ||||||
otherFeeBase | Optional | decimal | 5708 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | OTHER_FEE_B | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/otherFeeBase | ||||||
secFeeBase | Optional | decimal | 10122 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | SEC_FEE_B | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/secFeeBase | ||||||
stampDutyTaxBase | Optional | decimal | 10121 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | STAMP_DUTY_TAX_B | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/stampDutyTaxBase | ||||||
fedTaxWithholdingBase | Optional | decimal | 8078 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | FED_TAX_WITHHOLD_B | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/fedTaxWithholdingBase | ||||||
stTaxWithholdingBase | Optional | decimal | 8079 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | ST_TAX_WITHHOLD_B | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/stTaxWithholdingBase | ||||||
streamSecAlias | Optional | integer | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | STREAM_SEC_ALIAS | NUMBER(38) | EagleML/accountingTransaction/settledCashActivity/streamSecAlias | |||||||
taxAmountBase | Optional | decimal | 10759 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | TAX_AMT_B | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/taxAmountBase | ||||||
buWithholdingLocal | Optional | decimal | 2712 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | BU_WTHHLD_L | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/buWithholdingLocal | ||||||
buWithholdingBase | Optional | decimal | 2713 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | BU_WTHHLD_B | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/buWithholdingBase | ||||||
buWithholdingRate | Optional | decimal | 2762 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | BU_WTHHLD_RATE | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/buWithholdingRate | ||||||
price | Optional | decimal | 45 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | PRICE | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/price | ||||||
cancelType | Optional | string | 2981 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CANCEL_TYPE | VARCHAR2(1) | EagleML/accountingTransaction/settledCashActivity/cancelType | cancelFlag||||||
cancelFlag | Optional | string | 10045 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CANCEL_FLAG | VARCHAR2(1) | EagleML/accountingTransaction/settledCashActivity/cancelFlag | ||||||
couponDate | Optional | date | 3460 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | COUPON_DATE | DATE | EagleML/accountingTransaction/settledCashActivity/couponDate | ||||||
cashEventSpawned | Optional | string | 10045751 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CANCELCASH_EVENT_FLAGSPAWNED | VARCHAR2(1) | EagleML/accountingTransaction/settledCashActivity/cancelFlagcashEventSpawned | ||||||
couponDatebackupCouponEndDate | Optional | date | 3460 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | BKUP_COUPON_END_DATE | DATE | EagleML/accountingTransaction/settledCashActivity/couponDatebackupCouponEndDate | ||||||
cashEventSpawnedorigContSettleDate | Optional | stringdate | 751 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CASHORIG_CONT_EVENTSETTLE_SPAWNEDVARCHAR2(1)DT | DATE | EagleML/accountingTransaction/settledCashActivity/cashEventSpawnedorigContSettleDate | ||||||
backupCouponEndDateperiodicDistType | Optional | datestring | 1737 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYBKUP | PERIODIC_COUPONDIST_END_DATEDATETYPE | VARCHAR2(2) | EagleML/accountingTransaction/settledCashActivity/backupCouponEndDateperiodicDistType | ||||||
origContSettleDatecostLotOpenEventId | Optional | date | TransactionId | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYORIG | COST_LOT_CONTOPEN_SETTLEEVT_DTDATEID | VARCHAR2(55) | EagleML/accountingTransaction/settledCashActivity/origContSettleDatecostLotOpenEventId | ||||||
periodicDistTypecostLotCloseEventId | Optional | stringTransactionId | 1737 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYPERIODIC_DIST | _TYPECOST_LOT_CLOSE_EVT_ID | VARCHAR2(255) | EagleML/accountingTransaction/settledCashActivity/periodicDistTypecostLotCloseEventId | ||||||
costLotOpenEventIdcorpActionType | Optional | TransactionId | string | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYCOST | CORP_LOT_OPEN_EVT_IDACTION_TYPE | VARCHAR2(5550) | EagleML/accountingTransaction/settledCashActivity/costLotOpenEventIdcorpActionType | ||||||
costLotCloseEventIdcashAccountName | Optional | TransactionIdstring | 11696 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYCOST_LOT_CLOSE_EVT_ID_ACTIVITY | CASH_ACCT_NAME | VARCHAR2(5550) | EagleML/accountingTransaction/settledCashActivity/costLotCloseEventIdcashAccountName | ||||||
corpActionTypecashAccount | Optional | string | 11697 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYCORP | CASH_ACTION_TYPEACCT | VARCHAR2(5020) | EagleML/accountingTransaction/settledCashActivity/corpActionTypecashAccount | ||||||
cashAccountNamecashAccountAlias | Optional | stringinteger | 1169611698 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CASH_ACCT_NAMEALIAS | VARCHAR2NUMBER(5038) | EagleML/accountingTransaction/settledCashActivity/cashAccountNamecashAccountAlias | ||||||
cashAccountsrcSysC | Optional | string | 1169798 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITYCASH | SRC_SYS_ACCTC | VARCHAR2(2025) | EagleML/accountingTransaction/settledCashActivity/cashAccountsrcSysC | ||||||
cashAccountAliassettleCashDivUgl | Optional | integer | 11698decimal | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | STL_CASH_ACCTDIV_ALIASUGL | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/cashAccountAliassettleCashDivUgl | ||||||
srcSysCbreakageUnderLocal | Optional | stringdecimal | 981994 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | SRCBREAKAGE_AMT_SYSUNDER_CL | VARCHAR2NUMBER(2538,12) | EagleML/accountingTransaction/settledCashActivity/srcSysCbreakageUnderLocal | ||||||
settleCashDivUglbreakageOverLocal | Optional | decimal | 1996 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | STLBREAKAGE_CASHAMT_DIVOVER_UGLL | NUMBER(38,12) | EagleML/accountingTransaction/settledCashActivity/settleCashDivUglbreakageOverLocal | ||||||
breakageUnderLocaltradedDate | Optional | decimaldate | 199435 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | BREAKAGE_AMT_UNDER_L | NUMBER(38,12)TRADE_DATE | DATE | EagleML/accountingTransaction/settledCashActivity/breakageUnderLocaltradedDate | breakageOverLocal|||||
cashMatchInstance | Optional | decimal | ||||||||||||
integer | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | ||||||||||||
CASH_ | ||||||||||||||
MATCH_ | ||||||||||||||
INSTANCE | NUMBER(38 | |||||||||||||
) | EagleML/accountingTransaction/settledCashActivity/ | |||||||||||||
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 | date | 35 | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | TRADE_DATE | ||||||||
string | 2983 | EagleML/accountingTransaction/settledCashActivity/calcTransactionId | ||||||||||||
calcMasterTransactionId | Optional | string | 2984 | EagleML/accountingTransaction/settledCashActivity/ | ||||||||||
calcMasterTransactionId | ||||||||||||||
cashMatchInstancecalcCancelTransactionId | Optional | integerstring | ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | CASH_MATCH_INSTANCE | NUMBER(38) | 2985 | EagleML/accountingTransaction/settledCashActivity/cashMatchInstancecalcCancelTransactionId | ||||||
To add the | ||||||||||||||
element below, please set | ||||||||||||||
IncludeAssetToBaseFxRate= | ||||||||||||||
Y in the RTR | ||||||||||||||
. | ||||||||||||||
assetToBaseFxRate | Optional | decimal | not stored in DB | EagleML/accountingTransaction/settledCashActivity/assetToBaseFxRate | ||||||||||
custodyBankAccountNumber | Optional | string | 2983 | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_ACCT_NUM | VARCHAR2(30) | EagleML/accountingTransaction/settledCashActivity/ | calcTransactionIdcustodyBankAccountNumber | |||||
custodyBankCode | Optional | string | 2984 | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_CODE | CHAR(20) | EagleML/accountingTransaction/settledCashActivity/ | calcMasterTransactionIdcustodyBankCode | |||||
custodyBankDesc | Optional | string | 2985 | RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_DESC | CHAR(50) | EagleML/accountingTransaction/settledCashActivity/ | calcCancelTransactionIdcustodyBankDesc |