...
| Element | Value Type | Star Tag | Eagle DB | DB Table | DB Field | Data Type | Xpath | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| objectType | ObjectTypeEnum | Hardcoded Value = AccountingCashJournal | EagleML/accountingTransaction/accountingCashJournal/objectType | ||||||||||
| objectId | ObjectId | Hardcoded Value = AccountingCashJournal | EagleML/accountingTransaction/accountingCashJournal/objectId | ||||||||||
| objectDescription | FeedTypeEnum | Hardcoded Value = ACCOUNTING | EagleML/accountingTransaction/accountingCashJournal/objectDescription | ||||||||||
| updateTimestamp | dateTime | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SYSTEM_DATE | DATE | EagleML/accountingTransaction/accountingCashJournal/updateTimestamp | |||||||
| updateSource | string | 944 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | UPDATE_SOURCE | VARCHAR2(32) | EagleML/accountingTransaction/accountingCashJournal/updateSource | ||||||
| Entity Common Id Model | EagleML/accountingTransaction/accountingCashJournal/ | ||||||||||||
| Asset Identifiers Model | EagleML/accountingTransaction/accountingCashJournal/ | ||||||||||||
| Asset Properties Model | EagleML/accountingTransaction/accountingCashJournal/ | ||||||||||||
| maturityDate | date | 38 | SECURITYDBO | SECURITY_MASTER | MAT_DATE | DATE | EagleML/accountingTransaction/accountingCashJournal/maturityDate | ||||||
| effectiveDate | date | EagleML/accountingTransaction/accountingCashJournal/effectiveDate | |||||||||||
| instance | integer | 9388 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INSTANCE | EagleML/accountingTransaction/accountingCashJournal/instance | |||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| localCurrency | CurrencyCode | 85 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LOCAL_CURR | VARCHAR2(3) | EagleML/accountingTransaction/accountingCashJournal/localCurrency | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| baseCurrency | CurrencyCode | 86 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BASE_CURR | VARCHAR2(3) | EagleML/accountingTransaction/accountingCashJournal/baseCurrency | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| accountingBasis | string | 21 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | ACCT_BASIS | VARCHAR2(5) | EagleML/accountingTransaction/accountingCashJournal/accountingBasis | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| longShortC | string | 15 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LNG_SHT_C | CHAR(1) | EagleML/accountingTransaction/accountingCashJournal/longShortC | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | shareClass|||||||||||||
| backupSrcSysC | string | 34 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SHARE_CLASS | VARCHAR2(10) | BKUP_SRC_SYS_C | EagleML/accountingTransaction/accountingCashJournal/shareClassbackupSrcSysC | |||||
| ESTAR_SETTLED_CASH_ACTIVITY | eventId|||||||||||||
| starPositionId | TransactionIdinteger | 25830 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | EVENTPOSN_ID | VARCHAR2(55) | EagleML/accountingTransaction/accountingCashJournal/eventIdstarPositionId | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| starEventType | string | 2362 | ESTAR | ESTARsettleAsset | Asset Identifiers Model - see extra table | ESTAR_TRADED_CASH_ACTIVITY | EVENT_TYPE | VARCHAR2(25) | EagleML/accountingTransaction/accountingCashJournal/settleAsset/starEventType | ||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| eventTypeshareClass | string | 5334 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CASHSHARE_EVT_TYPCLASS | VARCHAR2(10) | EagleML/accountingTransaction/accountingCashJournal/eventTypeshareClass | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| processDateeventId | dateTransactionId | 3025 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PROCESSEVENT_DTDATEID | VARCHAR2(55) | EagleML/accountingTransaction/accountingCashJournal/processDateeventId | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| accountingDatestarEventType | datestring | 362362 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | ACCOUNTEVENT_DTDATETYPE | VARCHAR2(25) | EagleML/accountingTransaction/accountingCashJournal/accountingDatestarEventType | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| monthEndAccountingDateeventType | datestring | 473353 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | MONTHCASH_ENDEVT_ACCT_DTDATETYP | VARCHAR2(10) | EagleML/accountingTransaction/accountingCashJournal/monthEndAccountingDateeventType | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | units|||||||||||||
| eventSequence | decimalinteger | 40126 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | UNITS | NUMBER(38,6)EVENT_SEQUENCE | EagleML/accountingTransaction/accountingCashJournal/units | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| processDateamount | date | decimal30 | 50 | Calculated Value - Tag 50 =ESTAR | ESTAR_TRADED_CASH_ACTIVITY | .AMOUNT +PROCESS_DT | DATE | EagleML/accountingTransaction/accountingCashJournal/processDate | |||||
| ESTAR_SETTLED_CASH_ACTIVITY | .BREAKAGE_AMT_UNDER_B + ESTAR_SETTLED|||||||||||||
| accountingDate | date | 36 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | .BREAKAGE_AMT_OVER_BACCOUNT_DT | DATE | EagleML/accountingTransaction/accountingCashJournal/amount | Calculated Value - Tag 50 = SUM(accountingDate | |||||
| ESTAR_ | TRADEDSETTLED_CASH_ACTIVITY | .NET_AMOUNT_BASE)\SUM(||||||||||||
| monthEndAccountingDate | date | 4733 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | MONTH_END_ACCT_DT | DATE | EagleML/accountingTransaction/accountingCashJournal/monthEndAccountingDate | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| units | decimal | 40 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | UNITS | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/units | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| amount | decimal | 50 | Calculated Value - Tag 50 = ESTAR_TRADED_CASH_ACTIVITY.AMOUNT + ESTAR_SETTLED_CASH_ACTIVITY.BREAKAGE_AMT_UNDER_B + ESTAR_SETTLED_CASH_ACTIVITY.BREAKAGE_AMT_OVER_B | EagleML/accountingTransaction/accountingCashJournal/amount | |||||||||
| Calculated Value - Tag 50 = SUM(ESTAR_TRADED_CASH_ACTIVITY.NET_AMOUNT_BASE)\SUM(ESTAR_SETTLED_CASH_ACTIVITY.NET_AMOUNT_BASE) | |||||||||||||
| principal* (supported in 2017R1) | decimal | 165 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PRINCIPAL | EagleML/accountingTransaction/accountingCashJournal/principal | |||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| income | decimal | 1985 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INCOME | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/income | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| navId | integer | 3196 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | NAV_ID | EagleML/accountingTransaction/accountingCashJournal/navId | |||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| cashStatus | string | 54 | Hardcode Value - TRADED for payables and receivables, SETTLED - for disbursements and receipts | EagleML/accountingTransaction/accountingCashJournal/cashStatus | |||||||||
| cashCategory | string | 62 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CASH_CATEGORY | VARCHAR2(50) | EagleML/accountingTransaction/accountingCashJournal/cashCategory | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| bankAlias | string | 16 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BANK_ALIAS | EagleML/accountingTransaction/accountingCashJournal/bankAlias | |||||||
| ESTAR_SETTLED_CASH_ACTIVITY | .NET_AMOUNT_BASE)principal* (supported in 2017R1) | decimal | 165|||||||||||
| autoSettleIndicator | YesNoOptionEnum | 58 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PRINCIPALAUTO_SETTLE_INDICATOR | VARCHAR2(2) | EagleML/accountingTransaction/accountingCashJournal/principalautoSettleIndicator | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | income|||||||||||||
| corpActionId | decimalinteger | 198560 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INCOME | NUMBER(38,6) | CORP_ACTION_ID | EagleML/accountingTransaction/accountingCashJournal/incomecorpActionId | |||||
| ESTAR_SETTLED_CASH_ACTIVITY | cashStatus|||||||||||||
| ledgerBalanceEntitlement | string | 54 | Hardcode Value - ""3970 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LDGR_BAL_ENTITLEMENT | EagleML/accountingTransaction/accountingCashJournal/ | cashStatuscashCategory | string | 62ledgerBalanceEntitlement | |||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| accountingPlan | integer | 999 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CASHACCTG_CATEGORYPLAN | VARCHAR2(50) | EagleML/accountingTransaction/accountingCashJournal/cashCategoryaccountingPlan | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | autoSettleIndicator|||||||||||||
| positingPlan | YesNoOptionEnuminteger | 58913 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | AUTO_SETTLE_INDICATOR | VARCHAR2(2)POSTING_PLAN | EagleML/accountingTransaction/accountingCashJournal/autoSettleIndicatorpositingPlan | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| recPayPlan | string | 1831 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | REC_PAY_PLAN | VARCHAR2(15) | EagleML/accountingTransaction/accountingCashJournal/recPayPlan | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| withholdingLocal | decimal | 853 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | WITHHOLDING_L | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/withholdingLocal | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| reclaimLocal | decimal | 852 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | RECLAIM_L | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/reclaimLocal | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| reclaimMethod | string | 3912 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | RECLAIM_METHOD | CHAR(2) | EagleML/accountingTransaction/accountingCashJournal/reclaimMethod | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| contSettleDate | date | 9968 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CONT_SETTLE_DT | DATE | EagleML/accountingTransaction/accountingCashJournal/contSettleDate | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| linkEventId | TransactionId | 28 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LINK_EVENT_ID | VARCHAR2(55) | EagleML/accountingTransaction/accountingCashJournal/linkEventId | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| targetEventId | string | 26 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TARGET_EVT_ID | VARCHAR2(55) | EagleML/accountingTransaction/accountingCashJournal/targetEventId | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| eventReason | string | 56 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | EVENT_REASON | VARCHAR2(55) | EagleML/accountingTransaction/accountingCashJournal/eventReason | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| recPayAccount2 | string | 1826 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | REC_PAY_ACCT2 | EagleML/accountingTransaction/accountingCashJournal/recPayAccount2 | |||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| otherFeeLocal | decimal | 3752 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | OTHER_FEE_LOCAL | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/otherFeeLocal | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| stampDutyTaxLocal | decimal | 51 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | STAMP_DUTY_TAX_L | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/stampDutyTaxLocal | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| commAmountLocal | decimal | 47 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | COMM_AMT_L | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/commAmountLocal | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| taxAmountLocal | decimal | 46 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAX_AMT_L | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/taxAmountLocal | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| secFee | decimal | 48 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SEC_FEE | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/secFee | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| settleAmountLocal | decimal | 5363 | Hardcode Value - 0 | EagleML/accountingTransaction/accountingCashJournal/settleAmountLocal | |||||||||
| ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | AMOUNT | NUMBER(38,6) | ||||||||||
| brokerCode | string | 88 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BROKER_CODE | CHAR(20) | EagleML/accountingTransaction/accountingCashJournal/brokerCode | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| dividendRate | decimal | 5897 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | DIVIDEND_RATE | NUMBER(28,12) | EagleML/accountingTransaction/accountingCashJournal/dividendRate | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| currencyGain | decimal | 198 | Calculated Value - Tag 198 = SUM(SETTLED_CASH_DISP_LOTS.CURRENCY_GAIN) | EagleML/accountingTransaction/accountingCashJournal/currencyGain | |||||||||
| currencyLoss | decimal | 199 | Calculated Value - Tag 198 = SUM(SETTLED_CASH_DISP_LOTS.CURRENCY_LOSS) | EagleML/accountingTransaction/accountingCashJournal/currencyLoss | |||||||||
| localAssetCurrency | CurrencyCode | 9061 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LOCAL_ASSET_CURRENCY | VARCHAR2(3) | EagleML/accountingTransaction/accountingCashJournal/localAssetCurrency | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| masterTicketNumber | string | 761 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | MASTER_TICKET_NUMBER | VARCHAR2(55) | EagleML/accountingTransaction/accountingCashJournal/masterTicketNumber | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| tradeDateFxRate | decimal | 87 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TRADE_DT_FX_RATE | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/tradeDateFxRate | ||||||
| ESTAR_TRADED_CASH_ACTIVITY\ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| netAmountBase | decimal | 478 | Calculated Value - Tag 478 = amount(Tag 50)/Current Fx Rate | EagleML/accountingTransaction/accountingCashJournal/netAmountBase | |||||||||
| SUM(ESTAR_TRADED_CASH_ACTIVITY.NET_AMOUNT_BASE)\SUM(ESTAR_SETTLED_CASH_ACTIVITY.NET_AMOUNT_BASE) | |||||||||||||
| principalAmountBase* (supported in 2017R1) | decimal | 169 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PRINCIPAL_AMOUNT_BASE | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/principalAmountBase | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| incomeAmountBase | decimal | 1986 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | INCOME_AMOUNT_BASE | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/incomeAmountBase | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| recPayAccount | string | 1825 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | REC_PAY_ACCT | EagleML/accountingTransaction/accountingCashJournal/recPayAccount | |||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| reclaimAmountBase | decimal | 851 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | RECLAIM_AMOUNT_BASE | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/reclaimAmountBase | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| taxExpenseBase | decimal | 854 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAX_EXPENSE_BASE | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/taxExpenseBase | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| breakageAmountUnderBase | decimal | 1995 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BREAKAGE_AMT_UNDER_B | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/breakageAmountUnderBase | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| breakageAmountOverBase | decimal | 1997 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BREAKAGE_AMT_OVER_B | NUMBER(38,6) | EagleML/accountingTransaction/accountingCashJournal/breakageAmountOverBase | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| recPayAmountLocal | decimal | 11781 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | REC_PAY_AMT_L | EagleML/accountingTransaction/accountingCashJournal/recPayAmountLocal | |||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| recPayAmountBase | decimal | 11782 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | REC_PAY_AMT_B | EagleML/accountingTransaction/accountingCashJournal/recPayAmountBase | |||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| clearingBroker | string | 1236 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CLEARING_BROKER | VARCHAR2(50) | EagleML/accountingTransaction/accountingCashJournal/clearingBroker | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| taxReclaimRate | decimal | 1296 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAX_RECLAIM_RATE | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/taxReclaimRate | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| taxWithholdingRate | decimal | 1295 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAX_WITHHOLDING_RATE | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/taxWithholdingRate | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| specialReclaimRate | decimal | 1298 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SPECIAL_RECLAIM_RATE | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/specialReclaimRate | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| specialWithholdingRate | decimal | 1297 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SPECIAL_WITHHOLDING_RATE | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/specialWithholdingRate | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| gainSwapLocal | decimal | 11819 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | GAIN_SWAP_L | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/gainSwapLocal | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| lossSwapLocal | decimal | 11821 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LOSS_SWAP_L | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/lossSwapLocal | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| gainSwapBase | decimal | 11820 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | GAIN_SWAP_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/gainSwapBase | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| lossSwapBase | decimal | 11822 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | LOSS_SWAP_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/lossSwapBase | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| termLoanFeeIncLocal | decimal | 844 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TERM_LOAN_FEE_INC_L | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/termLoanFeeIncLocal | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| termLoanFeeIncBase | decimal | 845 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TERM_LOAN_FEE_INC_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/termLoanFeeIncBase | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| termLoanFeeExpLocal | decimal | 846 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TERM_LOAN_FEE_EXP_L | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/termLoanFeeExpLocal | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| termLoanFeeExpBase | decimal | 847 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TERM_LOAN_FEE_EXP_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/termLoanFeeExpBase | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| commAmountBase | decimal | 498 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | COMM_AMT_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/commAmountBase | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| otherFeeBase | decimal | 5708 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | OTHER_FEE_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/otherFeeBase | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| secFeeBase | decimal | 10122 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SEC_FEE_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/secFeeBase | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| stampDutyTaxBase | decimal | 10121 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | STAMP_DUTY_TAX_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/stampDutyTaxBase | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| fedTaxWithholdingBase | decimal | 8078 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | FED_TAX_WITHHOLD_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/fedTaxWithholdingBase | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| stTaxWithholdingBase | decimal | 8079 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | ST_TAX_WITHHOLD_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/stTaxWithholdingBase | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| taxAmountBase | decimal | 10759 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | TAX_AMT_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/taxAmountBase | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| buWithholdingLocal | decimal | 2712 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BU_WTHHLD_L | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/buWithholdingLocal | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| buWithholdingBase | decimal | 2713 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BU_WTHHLD_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/buWithholdingBase | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| buWithholdingRate | decimal | 2762 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | BU_WTHHLD_RATE | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/buWithholdingRate | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| price | decimal | 45 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | PRICE | NUMBER(38,12) | EagleML/accountingTransaction/accountingCashJournal/price | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| cashEventSpawned | string | 751 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | CASH_EVENT_SPAWNED | VARCHAR2(1) | EagleML/accountingTransaction/accountingCashJournal/cashEventSpawned | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| detailIndicator | string | 8468 | Hardcode Value - "TRADED ACTIVITY" | EagleML/accountingTransaction/accountingCashJournal/detailIndicator | |||||||||
| Hardcode Value - "SETTLED ACTIVITY" | |||||||||||||
| settlementDate | date | 37 | Hardcode Value - "" | EagleML/accountingTransaction/accountingCashJournal/settlementDate | |||||||||
| ESTAR | ESTAR_SETTLED_CASH_ACTIVITY | EFFECTIVE_DT | DATE | ||||||||||
| tradedDate | date | 35 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | EFFECTIVE_DT | DATE | EagleML/accountingTransaction/accountingCashJournal/tradedDate | ||||||
| ESTAR_TRADED_CASH_ACTIVITY\ESTAR_SETTLED_CASH_ACTIVITY | |||||||||||||
| breakageUnderLocal | decimal | 1994 | Calculated Value - Tag 1994 = ESTAR_TRADED_CASH_ACTIVITY.PRINCIPAL_BREAKAGE_UNDER + ESTAR_TRADED_CASH_ACTIVITY.INCOME_BREAKAGE_UNDER | EagleML/accountingTransaction/accountingCashJournal/breakageUnderLocal | |||||||||
| ESTAR_SETTLED_CASH_ACTIVITY | BREAKAGE_AMT_UNDER_L | NUMBER(38,12) | |||||||||||
| breakageOverLocal | decimal | 1996 | Calculated Value - Tag 1996 = ESTAR_TRADED_CASH_ACTIVITY.PRINCIPAL_BREAKAGE_OVER + ESTAR_TRADED_CASH_ACTIVITY.INCOME_BREAKAGE_OVER | EagleML/accountingTransaction/accountingCashJournal/breakageOverLocal | |||||||||
| ESTAR_SETTLED_CASH_ACTIVITY | BREAKAGE_AMT_OVER_L | NUMBER(38,12) | |||||||||||
| recPayCategory | string | 1827 | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | REC_PAY_ACCT_DESC | VARCHAR2(100) | EagleML/accountingTransaction/accountingCashJournal/recPayCategory | ||||||
| ESTAR_SETTLED_CASH_ACTIVITY | REC_PAY_ACCT_DESC | VARCHAR2(100) | |||||||||||
| currentFxRate | decimal | 96 | Calculated Value(Default SP - get_spot_rate) - Current Fx Rate | EagleML/accountingTransaction/accountingCashJournal/currentFxRate | |||||||||
| fxRate | decimal | 484 | Calculated Value - Tag 484 = Fx Rate for Date (ESTAR_TRADED_CASH_ACTIVITY.EFFECTIVE_DT) | EagleML/accountingTransaction/accountingCashJournal/fxRate | |||||||||
| ESTAR_SETTLED_CASH_ACTIVITY | TRADE_DT_FX_RATE | NUMBER(38,12) | |||||||||||
| totalRealizedGainLossBase | decimal | 5507 | Calculated Value - Tag 5507 = SETTLED_CASH_DISP_LOTS.CURRENCY_GAIN - SETTLED_CASH_DISP_LOTS.CURRENCY_LOSS | EagleML/accountingTransaction/accountingCashJournal/totalRealizedGainLossBase | |||||||||
| totalGainLossId | decimal | 178 | Calculated Value - Tag 178 = ESTAR_SETTLED_CASH_ACTIVITY.GAIN_CURRENCY - ESTAR_SETTLED_CASH_ACTIVITY.LOSS_CURRENCY | EagleML/accountingTransaction/accountingCashJournal/totalGainLossId | |||||||||
| settledUrglTotalBase | decimal | 11053 | Hardcode Value - 0 | EagleML/accountingTransaction/accountingCashJournal/settledUrglTotalBase | |||||||||
| settleAmountBase | decimal | 479 | Hardcode Value - 0 | EagleML/accountingTransaction/accountingCashJournal/settleAmountBase | |||||||||
| Calculated Value - Tag 479 = amount(Tag 5363)/Current Fx Rate | |||||||||||||
| tradedNetAmountLocal | decimal | 11779 | Calculated Value - Tag 11779 = amount + Tag 1997 - Tag 1995 | EagleML/accountingTransaction/accountingCashJournal/tradedNetAmountLocal | |||||||||
| Hardcode Value - 0 | |||||||||||||
| tradedNetAmountBase | decimal | 11780 | Calculated Value - Tag 11780 = Tag 11779/Current Fx Rate | EagleML/accountingTransaction/accountingCashJournal/tradedNetAmountBase | |||||||||
| Hardcode Value - 0 | |||||||||||||
| netAmountBaseNew | decimal | 4309 | Calculated Value - Tag 4309 = Tag 478 + Tag 5507 + Tag 178(for unsettled) + Tag 50/(End date Fx Rate)(for settled) | EagleML/accountingTransaction/accountingCashJournal/netAmountBaseNew | |||||||||
| Calculated Value - Tag 4309 = Tag 479 + Tag 5507 | |||||||||||||
| notionalResetType | decimal | 4409 | SECURITYDBO | SWAPS | NOTIONAL_RESET_TYPE | EagleML/accountingTransaction/accountingCashJournal/notionalResetType | |||||||
| reportType | decimal | 1257 | Calculated Value - ACCTGDT = Accounting Date; MONTHDT = Month End Date; POSTDT = Post Date; SETTLEDT = Settlement Date; TRADEDT = Trade Date; | EagleML/accountingTransaction/accountingCashJournal/reportType | |||||||||
| regulatoryCategory | decimal | 12387 | RULESDBO | ENTITY_ACCT_BASIS_HIST | REGULATORY_CATEGORY | VARCHAR2(30) | EagleML/accountingTransaction/accountingCashJournal/regulatoryCategory | ||||||
| regulatoryCategoryChanged | string | 891 | EagleML/accountingTransaction/accountingCashJournal/regulatoryCategoryChanged | ||||||||||
| coupon | decimal | 70 | SECURITYDBO | SECURITY_MASTER | COUPON | EagleML/accountingTransaction/accountingCashJournal/coupon | |||||||
| quantityScale | decimal | 19 | SECURITYDBO | SECURITY_MASTER | TRADING_UNIT | EagleML/accountingTransaction/accountingCashJournal/quantityScale | |||||||
| quantityType | StringWithCodeScheme | 12 | SECURITYDBO | SECURITY_MASTER | QUANTITY_TYPE | EagleML/accountingTransaction/accountingCashJournal/quantityType | |||||||
| priceMultiplier | decimal | 18 | SECURITYDBO | SECURITY_MASTER | PRICE_MULTIPLIER | EagleML/accountingTransaction/accountingCashJournal/priceMultiplier | |||||||
| dayCountBasis | DayCountFraction | 471 | SECURITYDBO | SECURITY_MASTER | DAY_CNT | EagleML/accountingTransaction/accountingCashJournal/dayCountBasis | |||||||
| paymentFrequencyCode | StringWithCodeScheme | 472 | SECURITYDBO | SECURITY_MASTER | COUPON_FREQ_CODE | EagleML/accountingTransaction/accountingCashJournal/paymentFrequencyCode | |||||||
| varRateFreqCode | string | 1788 | SECURITYDBO | FIXED_INCOME | VAR_RATE_FREQ_CODE | EagleML/accountingTransaction/accountingCashJournal/varRateFreqCode | |||||||
| payRecIndicator | string | 4590 | SECURITYDBO | SWAPS | PAY_RECEIVE_IND | EagleML/accountingTransaction/accountingCashJournal/payRecIndicator | |||||||
| optiondescr | string | 1364 | EagleML/accountingTransaction/accountingCashJournal/optiondescr | ||||||||||
| interestPaymentTiming | StringWithCodeScheme | 1523 | SECURITYDBO | FIXED_INCOME | ACCRUAL_METHOD | EagleML/accountingTransaction/accountingCashJournal/interestPaymentTiming | |||||||
| businessDayConvention | BusinessDayConventionEnum | 1536 | SECURITYDBO | FIXED_INCOME | INTEREST_METHOD_CODE | EagleML/accountingTransaction/accountingCashJournal/businessDayConvention | |||||||
| businessCalendarName | string | 1480 | EagleML/accountingTransaction/accountingCashJournal/businessCalendarName | ||||||||||
| premiumType | string | 3302 | SECURITYDBO | DERIVATIVES | PREMIUM_TYPE | EagleML/accountingTransaction/accountingCashJournal/premiumType | |||||||
| sectorName | string | 1156 | EagleML/accountingTransaction/accountingCashJournal/sectorName | ||||||||||
| reportView | string | 7009 | resolved by panel | EagleML/accountingTransaction/accountingCashJournal/reportView | |||||||||
| startDate | date | 220 | resolved by panel | EagleML/accountingTransaction/accountingCashJournal/startDate | |||||||||
| endDate | date | 221 | resolved by panel | EagleML/accountingTransaction/accountingCashJournal/endDate | |||||||||