Warehouse Cash Activity Data Map Table
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Olga Galis (Deactivated)
Element | Optional/Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | XPATH |
|---|---|---|---|---|---|---|---|---|---|---|
objectType | Â | ObjectTypeEnum | Â | Â | Â | not stored in DBÂ | Â | EagleML/warehouseTransaction/warehouseCashActivity/objectType | ||
objectId | Â | ObjectId | Â | Â | Â | not stored in DBÂ | Â | EagleML/warehouseTransaction/warehouseCashActivity/objectId | ||
objectDescription | Â | FeedTypeEnum | Â | Â | Â | not stored in DBÂ | Â | EagleML/warehouseTransaction/warehouseCashActivity/objectDescription | ||
updateTimestamp | Â | dateTime | Â | Â | Â | CASHDBO | CASH_ACTIVITY | UPDATE_DATE | DATE | EagleML/warehouseTransaction/warehouseCashActivity/updateTimestamp |
customElements | Not recommended | CustomElements - ComplexType | reserved for customizations |  |  |  |  |  |  | EagleML/warehouseTransaction/warehouseCashActivity/customElements |
sourceName | Â | string - needed for resolution logics | 1102 | in_source | S | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/warehouseTransaction/warehouseCashActivity/sourceName |
updateSource | Â | string | 944 | in_update_source | S | CASHDBO | CASH_ACTIVITY | UPDATE_SOURCE | VARCHAR2(30) | EagleML/warehouseTransaction/warehouseCashActivity/updateSource |
batchCollectErrorsFlag | Â | YesNoOptionEnum | Â | Â | Â | not stored in DBÂ | Â | EagleML/warehouseTransaction/warehouseCashActivity/batchCollectErrorsFlag | ||
singleRowCommitFlag | Â | YesNoOptionEnum | Â | Â | Â | not stored in DBÂ | Â | EagleML/warehouseTransaction/warehouseCashActivity/singleRowCommitFlag | ||
linkEventId | Â | TransactionId | 28 | in_linked_event_id | S | CASHDBO | CASH_ACTIVITY | LINKED_EVENT_ID | VARCHAR2(255) | EagleML/warehouseTransaction/warehouseCashActivity/linkEventId |
batchIdentifier | Â | YesNoOptionEnum | 701 | in_batch_event_id | S | not stored in DBÂ | Â | EagleML/warehouseTransaction/warehouseCashActivity/batchIdentifier | ||
localCurrency | Â | CurrencyCode | 85 | in_local_currency | S | CASHDBO | CASH_ACTIVITY | LOCAL_CURRENCY | CHAR(3) | EagleML/warehouseTransaction/warehouseCashActivity/localCurrency |
effectiveDate | Â | date | 221 | in_effective_date | S | CASHDBO | CASH_ACTIVITY | EFFECTIVE_DATE | DATE | EagleML/warehouseTransaction/warehouseCashActivity/effectiveDate |
maturityDate | Â | date | Â | Â | Â | not stored in DBÂ | Â | EagleML/warehouseTransaction/warehouseCashActivity/maturityDate | ||
longShortIndicator | Â | LongShortIndicatorEnum | 15 | in_long_short_indicator | S | CASHDBO | CASH_ACTIVITY | LONG_SHORT_INDICATOR | CHAR(2) | EagleML/warehouseTransaction/warehouseCashActivity/longShortIndicator |
EagleML/warehouseTransaction/warehouseCashActivity/ | ||||||||||
EagleML/warehouseTransaction/warehouseCashActivity/ | ||||||||||
accountingBasis | Â | string - needed for resolution logics | 21 | in_account | S | CASHDBO | CASH_ACTIVITY | ACCOUNT | CHAR(25) | EagleML/warehouseTransaction/warehouseCashActivity/accountingBasis |
entityIDLookupSwitch | Â | LookupSwitchEnum | 989 | Â | Â | not stored in DBÂ | Â | EagleML/warehouseTransaction/warehouseCashActivity/entityIDLookupSwitch | ||
entityNameLookupSwitch | Â | LookupSwitchEnum | 990 | Â | Â | not stored in DBÂ | Â | EagleML/warehouseTransaction/warehouseCashActivity/entityNameLookupSwitch | ||
securityQueryFlag | Â | YesNoOptionEnum | 1256 | Â | Â | not stored in DBÂ | Â | EagleML/warehouseTransaction/warehouseCashActivity/securityQueryFlag | ||
sourceLookupSwitch | Â | LookupSwitchEnum | Â | Â | Â | not stored in DBÂ | Â | EagleML/warehouseTransaction/warehouseCashActivity/sourceLookupSwitch | ||
procedureMode | Â | ProcedureFlagTypeEnum | 1076 | in_update_switch | S | not stored in DBÂ | Â | EagleML/warehouseTransaction/warehouseCashActivity/procedureMode | ||
procedureFlag | Â | ProcedureFlagTypeEnum | 1078 | Â | Â | not stored in DBÂ | Â | EagleML/warehouseTransaction/warehouseCashActivity/procedureFlag | ||
EagleML/warehouseTransaction/warehouseCashActivity/ | ||||||||||
EagleML/warehouseTransaction/warehouseCashActivity/ | ||||||||||
baseCurrency | Â | CurrencyCode | 86 | in_base_currency | S | CASHDBO | CASH_ACTIVITY | BASE_CURRENCY | CHAR(3) | EagleML/warehouseTransaction/warehouseCashActivity/baseCurrency |
srcIntfcInst | Â | decimal - needed for resolution logics | 1168 | in_src_intfc_inst | S | not stored in DBÂ | Â | EagleML/warehouseTransaction/warehouseCashActivity/srcIntfcInst | ||
transactionType | Â | string | 2283 | in_trans_type | S | Â CASHDBO | CASH_ACTIVITY | TRANS_TYPE | CHAR(55) | EagleML/warehouseTransaction/warehouseCashActivity/transactionType |
account | Â | string | Â | Â | Â | not stored in DBÂ | Â | EagleML/warehouseTransaction/warehouseCashActivity/account | ||
activitySource | Â | string | 11415 | in_activity_source | S | CASHDBO | CASH_ACTIVITY | ACTIVITY_SOURCE | VARCHAR2(5) | EagleML/warehouseTransaction/warehouseCashActivity/activitySource |
bankCode | Â | string | 1240 | in_bank_code | S | CASHDBO | CASH_ACTIVITY | BANK_CODE | CHAR(8) | EagleML/warehouseTransaction/warehouseCashActivity/bankCode |
basePrincipalFlow | Â | decimal | 169 | in_base_principal_flow | F | CASHDBO | CASH_ACTIVITY | BASE_PRINCIPAL_FLOW | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/basePrincipalFlow |
baseTotalFlow | Â | decimal | 10718 | in_base_total_flow | F | CASHDBO | CASH_ACTIVITY | BASE_TOTAL_FLOW | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/baseTotalFlow |
cancelAccountingDt | Â | date | 505 | in_cancel_acctg_date | S | CASHDBO | CASH_ACTIVITY | CANCEL_ACCTG_DATE | DATE | EagleML/warehouseTransaction/warehouseCashActivity/cancelAccountingDt |
cancelFlag | Â | YesNoOptionEnum | 10045 | in_cancel_flag | S | CASHDBO | CASH_ACTIVITY | CANCEL_FLAG | CHAR(2) | EagleML/warehouseTransaction/warehouseCashActivity/cancelFlag |
cancelStatus | Â | string | 10046 | in_cancel_status | S | CASHDBO | CASH_ACTIVITY | CANCEL_STATUS | CHAR(2) | EagleML/warehouseTransaction/warehouseCashActivity/cancelStatus |
cancelMeAcctgDate | Â | date | 8378 | in_cancel_me_acctg_date | S | CASHDBO | CASH_ACTIVITY | CANCEL_ME_ACCTG_DATE | DATE | EagleML/warehouseTransaction/warehouseCashActivity/cancelMeAcctgDate |
calculateReflexiveFlowsSwitch | Â | string - needed for resolution logics | 1077 | in_calc_reflexive_flow_switch | S | not stored in DB | Â | EagleML/warehouseTransaction/warehouseCashActivity/calculateReflexiveFlowsSwitch | ||
custodyBankSubAccount | Â | string | 1661 | in_sub_account | S | CASHDBO | CASH_ACTIVITY | SUB_ACCOUNT | CHAR(25) | EagleML/warehouseTransaction/warehouseCashActivity/custodyBankSubAccount |
currFxRate | Â | decimal | 79 | in_curr_fx_rate | S | CASHDBO | CASH_ACTIVITY | CURR_FX_RATE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/currFxRate |
dividendRate | Â | decimal | 368 | in_dividend_rate | F | CASHDBO | CASH_ACTIVITY | DIVIDEND_RATE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/dividendRate |
gainSwapB | Â | decimal | 11820 | in_gain_swap_b | F | CASHDBO | CASH_ACTIVITY | GAIN_SWAP_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseCashActivity/gainSwapB |
gainSwapL | Â | decimal | 11819 | in_gain_swap_l | F | CASHDBO | CASH_ACTIVITY | GAIN_SWAP_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseCashActivity/gainSwapL |
gainLoss | Â | decimal | 1870 | in_gain_loss | F | CASHDBO | CASH_ACTIVITY | GAIN_LOSS | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/gainLoss |
grossAmtL | Â | decimal | 325 | in_gross_amount_local | F | CASHDBO | CASH_ACTIVITY | GROSS_AMOUNT_LOCAL | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseCashActivity/grossAmtL |
grossAmtB | Â | decimal | 330 | in_gross_amount | F | CASHDBO | CASH_ACTIVITY | GROSS_AMOUNT | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseCashActivity/grossAmtB |
lossSwapB | Â | decimal | 11822 | in_loss_swap_b | F | CASHDBO | CASH_ACTIVITY | LOSS_SWAP_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseCashActivity/lossSwapB |
lossSwapL | Â | decimal | 11821 | in_loss_swap_l | F | CASHDBO | CASH_ACTIVITY | LOSS_SWAP_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseCashActivity/lossSwapL |
localIncomeFlow | Â | decimal | 10717 | in_local_income_flow | F | CASHDBO | CASH_ACTIVITY | LOCAL_INCOME_FLOW | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/localIncomeFlow |
localPrincipalFlow | Â | decimal | 10716 | in_local_principal_flow | F | CASHDBO | CASH_ACTIVITY | LOCAL_PRINCIPAL_FLOW | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/localPrincipalFlow |
localTotalFlow | Â | decimal | 5363 | in_local_total_flow | F | CASHDBO | CASH_ACTIVITY | LOCAL_TOTAL_FLOW | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/localTotalFlow |
masterTransactionNum | Â | string | 457 | in_mast_trans_num | S | CASHDBO | CASH_ACTIVITY | MASTER_TRANS_NUM | VARCHAR2(255) | EagleML/warehouseTransaction/warehouseCashActivity/masterTransactionNum |
netAmountLocal | Â | decimal | 50 | in_local_amount | F | CASHDBO | CASH_ACTIVITY | LOCAL_AMOUNT | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/netAmountLocal |
openHldPerDate | Â | date | 164 | in_holding_period_date | S | CASHDBO | CASH_ACTIVITY | HOLDING_PERIOD_DATE | DATE | EagleML/warehouseTransaction/warehouseCashActivity/openHldPerDate |
originalAcquisitionCostBase | Â | decimal | 3746 | in_orig_acq_cost_base | F | CASHDBO | CASH_ACTIVITY | ORIG_ACQ_COST_BASE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/originalAcquisitionCostBase |
originalAcquisitionCostLocal | Â | decimal | 3747 | in_orig_acq_cost_local | F | CASHDBO | CASH_ACTIVITY | ORIG_ACQ_COST_LOCAL | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/originalAcquisitionCostLocal |
originalTransactionNumber | Â | string | 9418 | in_orig_trans_num | S | CASHDBO | CASH_ACTIVITY | ORIG_TRANS_NUM | VARCHAR2(255) | EagleML/warehouseTransaction/warehouseCashActivity/originalTransactionNumber |
performanceFlow | Â | string | 472 | in_performance_flow | S | CASHDBO | CASH_ACTIVITY | PERFORMANCE_FLOW | CHAR(20) | EagleML/warehouseTransaction/warehouseCashActivity/performanceFlow |
performancePrice | Â | decimal | 4598 | in_performance_price | F | CASHDBO | CASH_ACTIVITY | PERFORMANCE_PRICE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/performancePrice |
performanceCode | Â | string | 4599 | in_performance_code | S | CASHDBO | CASH_ACTIVITY | PERFORMANCE_CODE | CHAR(2) | EagleML/warehouseTransaction/warehouseCashActivity/performanceCode |
performanceFlowDesc | Â | string | 10170 | in_performance_flow_descr | S | CASHDBO | CASH_ACTIVITY | PERFORMANCE_FLOW_DESCR | VARCHAR2(30) | EagleML/warehouseTransaction/warehouseCashActivity/performanceFlowDesc |
reflexiveFlows | Â | string | 5398 | in_reflexive_flow | S | CASHDBO | CASH_ACTIVITY | REFLEXIVE_FLOW | CHAR(2) | EagleML/warehouseTransaction/warehouseCashActivity/reflexiveFlows |
reclaimAmountBase | Â | decimal | 851 | in_reclaim | F | CASHDBO | CASH_ACTIVITY | RECLAIM | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/reclaimAmountBase |
reclaimAmountLocal | Â | decimal | 852 | in_reclaim_local | F | CASHDBO | CASH_ACTIVITY | RECLAIM_LOCAL | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/reclaimAmountLocal |
reportingReplayInd | Â | string | 10674 | in_replay_ind | S | CASHDBO | CASH_ACTIVITY | REPLAY_IND | VARCHAR2(1) | EagleML/warehouseTransaction/warehouseCashActivity/reportingReplayInd |
settlementCurrency | Â | string | 63 | in_settlement_currency | S | CASHDBO | CASH_ACTIVITY | SETTLEMENT_CURRENCY | CHAR(3) | EagleML/warehouseTransaction/warehouseCashActivity/settlementCurrency |
sourceLongShortInd | Â | string | 11416 | in_source_long_short_ind | S | CASHDBO | CASH_ACTIVITY | SOURCE_LONG_SHORT_IND | CHAR(2) | EagleML/warehouseTransaction/warehouseCashActivity/sourceLongShortInd |
sourceSecurityAlias | Â | integer | 11417 | in_source_security_alias | S | CASHDBO | CASH_ACTIVITY | SOURCE_SECURITY_ALIAS | INTEGER | EagleML/warehouseTransaction/warehouseCashActivity/sourceSecurityAlias |
systemControl | Required, and should be equal to cashdbo.cash_activity.SPD_PERF_FLOW_RULE | string | 1148 | in_sys_control | S | not stored in DB |  | EagleML/warehouseTransaction/warehouseCashActivity/systemControl | ||
systemCurrencyTotalFlow | Â | decimal | 11738 | in_sys_total_flow | F | CASHDBO | CASH_ACTIVITY | SYS_TOTAL_FLOW | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseCashActivity/systemCurrencyTotalFlow |
systemCurrencyPrincipalFlow | Â | decimal | 11739 | in_sys_principal_flow | F | CASHDBO | CASH_ACTIVITY | SYS_PRINCIPAL_FLOW | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseCashActivity/systemCurrencyPrincipalFlow |
systemCurrencyIncomeFlow | Â | decimal | 11740 | in_sys_income_flow | F | CASHDBO | CASH_ACTIVITY | SYS_INCOME_FLOW | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseCashActivity/systemCurrencyIncomeFlow |
systemCurrency | Â | CurrencyCode | 11728 | in_sys_currency | S | CASHDBO | CASH_ACTIVITY | SYS_CURRENCY | CHAR(3) | EagleML/warehouseTransaction/warehouseCashActivity/systemCurrency |
systemCurrExchangeRate | Â | decimal | 11729 | in_sys_curr_fx_rate | F | CASHDBO | CASH_ACTIVITY | SYS_CURR_FX_RATE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseCashActivity/systemCurrExchangeRate |
systemCurrExchangeRateDate | Â | date | 11730 | in_sys_curr_fx_rate_date | S | CASHDBO | CASH_ACTIVITY | SYS_CURR_FX_RATE_DATE | DATE | EagleML/warehouseTransaction/warehouseCashActivity/systemCurrExchangeRateDate |
transactionQuantity | Â | decimal | 159 | in_trans_quantity | F | CASHDBO | CASH_ACTIVITY | TRANS_QUANTITY | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/transactionQuantity |
transactionNum | Â | string | 362 | in_trans_num | S | CASHDBO | CASH_ACTIVITY | TRANS_NUM | VARCHAR2(255) | EagleML/warehouseTransaction/warehouseCashActivity/transactionNum |
withholdingLocal | Â | decimal | 853 | in_withholding_local | F | CASHDBO | CASH_ACTIVITY | WITHHOLDING_LOCAL | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/withholdingLocal |
withholdingBase | Â | decimal | 854 | in_withholding | F | CASHDBO | CASH_ACTIVITY | WITHHOLDING | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/withholdingBase |
price | Â | decimal | 45 | in_price | F | CASHDBO | CASH_ACTIVITY | PRICE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/price |
smInactiveFlag | Â | YesNoOptionEnum | 11043 | in_sm_inactive_flag | S | not stored in DBÂ | Â | EagleML/warehouseTransaction/warehouseCashActivity/smInactiveFlag | ||
bookCost | Â | decimal | 122 | in_book_cost | F | CASHDBO | CASH_ACTIVITY | BOOK_COST | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/bookCost |
cashEventType | Â | string | 53 | in_cash_event_type | S | CASHDBO | CASH_ACTIVITY | CASH_EVENT_TYPE | CHAR(8) | EagleML/warehouseTransaction/warehouseCashActivity/cashEventType |
cashCategory | Â | string | 62 | in_cash_category | S | CASHDBO | CASH_ACTIVITY | CASH_CATEGORY | VARCHAR2(30) | EagleML/warehouseTransaction/warehouseCashActivity/cashCategory |
corporateActionInstance | Â | integer | 4268 | in_corporate_action_inst | S | CASHDBO | CASH_ACTIVITY | CORPORATE_ACTION_INST | NUMBER | EagleML/warehouseTransaction/warehouseCashActivity/corporateActionInstance |
cancelType | Â | string | 398 | in_cancel_type | S | CASHDBO | CASH_ACTIVITY | CANCEL_TYPE | VARCHAR2(1) | EagleML/warehouseTransaction/warehouseCashActivity/cancelType |
exchangeFeeBase | Â | decimal | 161 | in_exchange_fee_base | F | CASHDBO | CASH_ACTIVITY | EXCHANGE_FEE_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseCashActivity/exchangeFeeBase |
eventId | Â | TransactionId | 25 | in_star_tag25 | S | CASHDBO | CASH_ACTIVITY | STAR_TAG25 | VARCHAR2(255) | EagleML/warehouseTransaction/warehouseCashActivity/eventId |
federalTaxWithholdBase | Â | decimal | 163 | in_federal_tax_withhold_base | F | CASHDBO | CASH_ACTIVITY | FEDERAL_TAX_WITHHOLD_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseCashActivity/federalTaxWithholdBase |
mttype | Â | string | 3822 | in_mttype | S | CASHDBO | CASH_ACTIVITY | MTTYPE | VARCHAR2(25) | EagleML/warehouseTransaction/warehouseCashActivity/mttype |
netCash | Â | decimal | 228 | in_net_cash | F | CASHDBO | CASH_ACTIVITY | NET_CASH | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/netCash |
netAmountBase | Â | decimal | 478 | in_base_amount | F | CASHDBO | CASH_ACTIVITY | BASE_AMOUNT | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/netAmountBase |
origAcqDate | Â | date | 216 | in_orig_acq_date | S | CASHDBO | CASH_ACTIVITY | ORIG_ACQ_DATE | DATE | EagleML/warehouseTransaction/warehouseCashActivity/origAcqDate |
postDate | Â | date | 30 | in_post_date | S | CASHDBO | CASH_ACTIVITY | POST_DATE | DATE | EagleML/warehouseTransaction/warehouseCashActivity/postDate |
positionId | Â | integer | 9201 | in_position_id | S | CASHDBO | CASH_ACTIVITY | POSITION_ID | NUMBER(38) | EagleML/warehouseTransaction/warehouseCashActivity/positionId |
scrubType | Â | string | 364 | in_scrub_type | S | CASHDBO | CASH_ACTIVITY | SCRUB_TYPE | CHAR(2) | EagleML/warehouseTransaction/warehouseCashActivity/scrubType |
scrubId | Â | integer | 237 | in_scrub_id | F | CASHDBO | CASH_ACTIVITY | SCRUB_ID | NUMBER | EagleML/warehouseTransaction/warehouseCashActivity/scrubId |
status | Â | string | 54 | in_transaction_status | S | CASHDBO | CASH_ACTIVITY | TRANSACTION_STATUS | CHAR(30) | EagleML/warehouseTransaction/warehouseCashActivity/status |
secFeesBase | Â | decimal | 239 | in_sec_fees_base | F | CASHDBO | CASH_ACTIVITY | SEC_FEES_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseCashActivity/secFeesBase |
termLoanFeeExpB | Â | decimal | 276 | in_term_loan_fee_exp_b | F | CASHDBO | CASH_ACTIVITY | TERM_LOAN_FEE_EXP_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseCashActivity/termLoanFeeExpB |
termLoanFeeExpL | Â | decimal | 292 | in_term_loan_fee_exp_l | F | CASHDBO | CASH_ACTIVITY | TERM_LOAN_FEE_EXP_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseCashActivity/termLoanFeeExpL |
termLoanFeeIncB | Â | decimal | 296 | in_term_loan_fee_inc_b | F | CASHDBO | CASH_ACTIVITY | TERM_LOAN_FEE_INC_B | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseCashActivity/termLoanFeeIncB |
termLoanFeeIncL | Â | decimal | 306 | in_term_loan_fee_inc_l | F | CASHDBO | CASH_ACTIVITY | TERM_LOAN_FEE_INC_L | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseCashActivity/termLoanFeeIncL |
targetEventId | Â | TransactionId | 26 | in_star_tag26 | S | CASHDBO | CASH_ACTIVITY | STAR_TAG26 | VARCHAR2(255) | EagleML/warehouseTransaction/warehouseCashActivity/targetEventId |
updateUserId | Â | string | 382 | in_update_user_id | S | CASHDBO | CASH_ACTIVITY | UPDATE_USER_ID | VARCHAR2(255) | EagleML/warehouseTransaction/warehouseCashActivity/updateUserId |
updateSwitch | Â | string - needed for resolution logics | 1076 | in_update_switch | S | not stored in DB | Â | EagleML/warehouseTransaction/warehouseCashActivity/updateSwitch | ||
xrateLocalBase | Â | decimal | 87 | in_local_fx_rate | F | CASHDBO | CASH_ACTIVITY | LOCAL_FX_RATE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/xrateLocalBase |
accountingDate | Â | date | 36 | in_accounting_date | S | CASHDBO | CASH_ACTIVITY | ACCOUNTING_DATE | DATE | EagleML/warehouseTransaction/warehouseCashActivity/accountingDate |
accruedIndicator | Â | string | 395 | in_accrued_indicator | S | CASHDBO | CASH_ACTIVITY | ACCRUED_INDICATOR | CHAR(4) | EagleML/warehouseTransaction/warehouseCashActivity/accruedIndicator |
allocationId | Â | integer | 110 | in_allocation_id | F | CASHDBO | CASH_ACTIVITY | ALLOCATION_ID | NUMBER(38) | EagleML/warehouseTransaction/warehouseCashActivity/allocationId |
baseCommission | Â | decimal | 111 | in_base_commission | F | CASHDBO | CASH_ACTIVITY | BASE_COMMISSION | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseCashActivity/baseCommission |
baseStampDutyTax | Â | decimal | 112 | in_base_stamp_duty_tax | F | CASHDBO | CASH_ACTIVITY | BASE_STAMP_DUTY_TAX | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseCashActivity/baseStampDutyTax |
baseIncomeFlow | Â | decimal | 1986 | in_base_income_flow | F | CASHDBO | CASH_ACTIVITY | BASE_INCOME_FLOW | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/baseIncomeFlow |
cashBalInst | Â | integer | 126 | in_cash_bal_inst | S | CASHDBO | CASH_ACTIVITY | CASH_BAL_INST | NUMBER | EagleML/warehouseTransaction/warehouseCashActivity/cashBalInst |
creditAmount | Â | decimal | 124 | in_credit_amount | F | CASHDBO | CASH_ACTIVITY | CREDIT_AMOUNT | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/creditAmount |
cashBalance | Â | string | 415 | in_activity_source | S | CASHDBO | CASH_ACTIVITY | CASH_BALANCE | CHAR(15) | EagleML/warehouseTransaction/warehouseCashActivity/cashBalance |
debitAmount | Â | decimal | 125 | in_debit_amount | F | CASHDBO | CASH_ACTIVITY | DEBIT_AMOUNT | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/debitAmount |
drCrIndicator | Â | string | 385 | in_dr_cr_indicator | S | CASHDBO | CASH_ACTIVITY | DR_CR_INDICATOR | CHAR(4) | EagleML/warehouseTransaction/warehouseCashActivity/drCrIndicator |
effExpFlowBase | Â | decimal | 141 | in_eff_exp_flow_base | F | CASHDBO | CASH_ACTIVITY | EFF_EXP_FLOW_BASE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/effExpFlowBase |
effExpFlowLocal | Â | decimal | 142 | in_eff_exp_flow_local | F | CASHDBO | CASH_ACTIVITY | EFF_EXP_FLOW_LOCAL | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/effExpFlowLocal |
effExpFlowReporting | Â | decimal | 470 | in_eff_exp_flow_reporting | F | CASHDBO | CASH_ACTIVITY | EFF_EXP_FLOW_REPORTING | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/effExpFlowReporting |
estarPosnId | Â | integer | 160 | in_estar_posn_id | F | CASHDBO | CASH_ACTIVITY | ESTAR_POSN_ID | NUMBER(38) | EagleML/warehouseTransaction/warehouseCashActivity/estarPosnId |
feedResultsInst | Â | integer | 189 | in_feed_results_inst | F | CASHDBO | CASH_ACTIVITY | FEED_RESULTS_INST | NUMBER(38) | EagleML/warehouseTransaction/warehouseCashActivity/feedResultsInst |
glAccount | Â | string | 1827 | in_gl_account | S | CASHDBO | CASH_ACTIVITY | GL_ACCOUNT | CHAR(50) | EagleML/warehouseTransaction/warehouseCashActivity/glAccount |
intPurSold | Â | decimal | 475 | in_int_pur_sold | F | CASHDBO | CASH_ACTIVITY | INT_PUR_SOLD | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/intPurSold |
localIntPurSold | Â | decimal | 49 | in_local_int_pur_sold | F | CASHDBO | CASH_ACTIVITY | LOCAL_INT_PUR_SOLD | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/localIntPurSold |
localStampDutyTax | Â | decimal | 51 | in_local_stamp_duty_tax | F | CASHDBO | CASH_ACTIVITY | LOCAL_STAMP_DUTY_TAX | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseCashActivity/localStampDutyTax |
localPrice | Â | decimal | 200 | in_local_price | F | CASHDBO | CASH_ACTIVITY | LOCAL_PRICE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/localPrice |
localTaxesFees | Â | decimal | 215 | in_local_taxes_fees | F | CASHDBO | CASH_ACTIVITY | LOCAL_TAXES_FEES | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/localTaxesFees |
settleToAssetFxRate | Â | decimal | 10721 | in_fx_rate_settle_to_asset | F | CASHDBO | CASH_ACTIVITY | FX_RATE_SETTLE_TO_ASSET | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/settleToAssetFxRate |
securityCurrencyLoss | Â | decimal | 199 | in_security_currency_loss | F | CASHDBO | CASH_ACTIVITY | SECURITY_CURRENCY_LOSS | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/securityCurrencyLoss |
securityCurrencyGain | Â | decimal | 198 | in_security_currency_gain | F | CASHDBO | CASH_ACTIVITY | SECURITY_CURRENCY_GAIN | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/securityCurrencyGain |
strategyId | Â | string | 365 | in_strategy_id | S | CASHDBO | CASH_ACTIVITY | STRATEGY_ID | VARCHAR2(20) | EagleML/warehouseTransaction/warehouseCashActivity/strategyId |
streamSecAlias | Â | integer | 275 | in_stream_sec_alias | F | CASHDBO | CASH_ACTIVITY | STREAM_SEC_ALIAS | NUMBER(38) | EagleML/warehouseTransaction/warehouseCashActivity/streamSecAlias |
stTaxWithholdBase | Â | decimal | 267 | in_st_tax_withhold_base | F | CASHDBO | CASH_ACTIVITY | ST_TAX_WITHHOLD_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseCashActivity/stTaxWithholdBase |
sysControlDate | Â | date | 10843 | in_sys_control_date | S | CASHDBO | CASH_ACTIVITY | SYS_CONTROL_DATE | DATE | EagleML/warehouseTransaction/warehouseCashActivity/sysControlDate |
sourceEventId | Â | string | 151 | in_source_event_id | S | CASHDBO | CASH_ACTIVITY | SOURCE_EVENT_ID | VARCHAR2(255) | EagleML/warehouseTransaction/warehouseCashActivity/sourceEventId |
spdIncomeRecbl | Â | decimal | 10967 | in_spd_income_recbl | S | not stored in DB | Â | EagleML/warehouseTransaction/warehouseCashActivity/spdIncomeRecbl | ||
notUsed | Â | YesNoOptionEnum | 358 | in_not_used | S | CASHDBO | CASH_ACTIVITY | NOT_USED | CHAR(12) | EagleML/warehouseTransaction/warehouseCashActivity/notUsed |
opFlag | Â | string | 359 | in_op_flag | S | CASHDBO | CASH_ACTIVITY | OP_FLAG | CHAR(3) | EagleML/warehouseTransaction/warehouseCashActivity/opFlag |
origContSettleDt | Â | date | 10858 | in_orig_cont_settle_dt | S | CASHDBO | CASH_ACTIVITY | ORIG_CONT_SETTLE_DT | DATE | EagleML/warehouseTransaction/warehouseCashActivity/origContSettleDt |
perfOnly | Â | string | 361 | in_perf_only | S | CASHDBO | CASH_ACTIVITY | PERF_ONLY | CHAR(2) | EagleML/warehouseTransaction/warehouseCashActivity/perfOnly |
periodId | Â | integer | 229 | in_period_id | F | CASHDBO | CASH_ACTIVITY | PERIOD_ID | NUMBER(38) | EagleML/warehouseTransaction/warehouseCashActivity/periodId |
performanceFlowValue | Â | decimal | 4597 | in_performance_flow_value | F | CASHDBO | CASH_ACTIVITY | PERFORMANCE_FLOW_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/performanceFlowValue |
postCorpActionPrice | Â | decimal | 232 | in_post_corp_action_price | F | CASHDBO | CASH_ACTIVITY | POST_CORP_ACTION_PRICE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseCashActivity/postCorpActionPrice |
preCorpActionPrice | Â | decimal | 233 | in_pre_corp_action_price | F | CASHDBO | CASH_ACTIVITY | PRE_CORP_ACTION_PRICE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseCashActivity/preCorpActionPrice |
reviseDate | Â | date | 10859 | in_revise_date | S | CASHDBO | CASH_ACTIVITY | REVISE_DATE | DATE | EagleML/warehouseTransaction/warehouseCashActivity/reviseDate |
switch3 | Â | LookupSwitchEnum | 991 | in_spd_conversion_switch | S | not stored in DB | Â | EagleML/warehouseTransaction/warehouseCashActivity/switch3 | ||
targetAcctDate | Â | date | 10904 | in_target_acct_date | S | not stored in DB | Â | EagleML/warehouseTransaction/warehouseCashActivity/targetAcctDate | ||
tradeFee | Â | decimal | 48 | in_trade_fee | F | CASHDBO | CASH_ACTIVITY | TRADE_FEE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/tradeFee |
tradeTaxes | Â | decimal | 46 | in_trade_taxes | F | CASHDBO | CASH_ACTIVITY | TRADE_TAXES | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/tradeTaxes |
tbaFlag | Â | YesNoOptionEnum | 379 | in_tba_flag | S | CASHDBO | CASH_ACTIVITY | TBA_FLAG | CHAR(3) | EagleML/warehouseTransaction/warehouseCashActivity/tbaFlag |
tradeStatus | Â | string | 381 | in_trade_status | S | CASHDBO | CASH_ACTIVITY | TRADE_STATUS | CHAR(8) | EagleML/warehouseTransaction/warehouseCashActivity/tradeStatus |
tradeTaxesBase | Â | decimal | 307 | in_trade_taxes_base | F | CASHDBO | CASH_ACTIVITY | TRADE_TAXES_BASE | NUMBER(38,12) | EagleML/warehouseTransaction/warehouseCashActivity/tradeTaxesBase |
txBaseLongTermGl | Â | decimal | 316 | in_tx_base_long_term_gl | F | CASHDBO | CASH_ACTIVITY | TX_BASE_LONG_TERM_GL | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/txBaseLongTermGl |
txBaseMktValue | Â | decimal | 318 | in_tx_base_mkt_value | F | CASHDBO | CASH_ACTIVITY | TX_BASE_MKT_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/txBaseMktValue |
txBaseShortTermGl | Â | decimal | 319 | in_tx_base_short_term_gl | F | CASHDBO | CASH_ACTIVITY | TX_BASE_SHORT_TERM_GL | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/txBaseShortTermGl |
txLocalLongTermGl | Â | decimal | 322 | in_tx_local_long_term_gl | F | CASHDBO | CASH_ACTIVITY | TX_LOCAL_LONG_TERM_GL | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/txLocalLongTermGl |
txLocalMktValue | Â | decimal | 326 | in_tx_local_mkt_value | F | CASHDBO | CASH_ACTIVITY | TX_LOCAL_MKT_VALUE | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/txLocalMktValue |
txLocalShortTermGl | Â | decimal | 339 | in_tx_local_short_term_gl | F | CASHDBO | CASH_ACTIVITY | TX_LOCAL_SHORT_TERM_GL | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/txLocalShortTermGl |
userGroup1 | Â | string | 383 | in_user_group1 | S | CASHDBO | CASH_ACTIVITY | USER_GROUP1 | CHAR(8) | EagleML/warehouseTransaction/warehouseCashActivity/userGroup1 |
userGroup2 | Â | string | 384 | in_user_group2 | S | CASHDBO | CASH_ACTIVITY | USER_GROUP2 | CHAR(8) | EagleML/warehouseTransaction/warehouseCashActivity/userGroup2 |
userChar1 | Â | string | 1017 | in_user_char1 | S | CASHDBO | CASH_ACTIVITY | USER_CHAR1 | VARCHAR2(50) | EagleML/warehouseTransaction/warehouseCashActivity/userChar1 |
userChar2 | Â | string | 1018 | in_user_char2 | S | CASHDBO | CASH_ACTIVITY | USER_CHAR2 | VARCHAR2(50) | EagleML/warehouseTransaction/warehouseCashActivity/userChar2 |
userChar3 | Â | string | 1019 | in_user_char3 | S | CASHDBO | CASH_ACTIVITY | USER_CHAR3 | VARCHAR2(50) | EagleML/warehouseTransaction/warehouseCashActivity/userChar3 |
userChar4 | Â | string | 1020 | in_user_char4 | S | CASHDBO | CASH_ACTIVITY | USER_CHAR4 | VARCHAR2(30) | EagleML/warehouseTransaction/warehouseCashActivity/userChar4 |
userChar5 | Â | string | 1021 | in_user_char5 | S | CASHDBO | CASH_ACTIVITY | USER_CHAR5 | VARCHAR2(30) | EagleML/warehouseTransaction/warehouseCashActivity/userChar5 |
userChar6 | Â | string | 1022 | in_user_char6 | S | CASHDBO | CASH_ACTIVITY | USER_CHAR6 | VARCHAR2(30) | EagleML/warehouseTransaction/warehouseCashActivity/userChar6 |
userFloat1 | Â | decimal | 1326 | in_user_float1 | F | CASHDBO | CASH_ACTIVITY | USER_FLOAT1 | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/userFloat1 |
userFloat2 | Â | decimal | 1327 | in_user_float2 | F | CASHDBO | CASH_ACTIVITY | USER_FLOAT2 | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/userFloat2 |
userFloat3 | Â | decimal | 1328 | in_user_float3 | F | CASHDBO | CASH_ACTIVITY | USER_FLOAT3 | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/userFloat3 |
userFloat4 | Â | decimal | 1329 | in_user_float4 | F | CASHDBO | CASH_ACTIVITY | USER_FLOAT4 | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/userFloat4 |
userFloat5 | Â | decimal | 1330 | in_user_float5 | F | CASHDBO | CASH_ACTIVITY | USER_FLOAT5 | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/userFloat5 |
userFloat6 | Â | decimal | 1331 | in_user_float6 | F | CASHDBO | CASH_ACTIVITY | USER_FLOAT6 | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/userFloat6 |
comments1 | Â | string | 56 | in_comments1 | S | CASHDBO | CASH_ACTIVITY | COMMENTS1 | VARCHAR2(100) | EagleML/warehouseTransaction/warehouseCashActivity/comments1 |
comments2 | Â | string | 416 | in_comments2 | S | CASHDBO | CASH_ACTIVITY | COMMENTS2 | VARCHAR2(100) | EagleML/warehouseTransaction/warehouseCashActivity/comments2 |
comments3 | Â | string | 440 | in_comments3 | S | CASHDBO | CASH_ACTIVITY | COMMENTS3 | VARCHAR2(100) | EagleML/warehouseTransaction/warehouseCashActivity/comments3 |
comments4 | Â | string | 1728 | in_comments4 | S | CASHDBO | CASH_ACTIVITY | COMMENTS4 | VARCHAR2(100) | EagleML/warehouseTransaction/warehouseCashActivity/comments4 |
comments5 | Â | string | 441 | in_comments5 | S | CASHDBO | CASH_ACTIVITY | COMMENTS5 | VARCHAR2(100) | EagleML/warehouseTransaction/warehouseCashActivity/comments5 |
comments6 | Â | string | 442 | in_comments6 | S | CASHDBO | CASH_ACTIVITY | COMMENTS6 | VARCHAR2(100) | EagleML/warehouseTransaction/warehouseCashActivity/comments6 |
comments7 | Â | string | 444 | in_comments7 | S | CASHDBO | CASH_ACTIVITY | COMMENTS7 | VARCHAR2(100) | EagleML/warehouseTransaction/warehouseCashActivity/comments7 |
comments8 | Â | string | 447 | in_comments8 | S | CASHDBO | CASH_ACTIVITY | COMMENTS8 | VARCHAR2(100) | EagleML/warehouseTransaction/warehouseCashActivity/comments8 |
bankAlias | Â | integer | 1864 | in_bank_alias | S | CASHDBO | CASH_ACTIVITY | BANK_ALIAS | NUMBER | EagleML/warehouseTransaction/warehouseCashActivity/bankAlias |
batchEventId | Â | string | 701 | in_batch_event_id | S | CASHDBO | CASH_ACTIVITY | BATCH_EVENT_ID | VARCHAR2(55) | EagleML/warehouseTransaction/warehouseCashActivity/batchEventId |
brokerCode | Â | string | 88 | in_broker_code | S | CASHDBO | CASH_ACTIVITY | BROKER_CODE | CHAR(12) | EagleML/warehouseTransaction/warehouseCashActivity/brokerCode |
clearingBrokerCode | Â | string | 1236 | in_clearing_broker_code | S | CASHDBO | CASH_ACTIVITY | CLEARING_BROKER_CODE | CHAR(50) | EagleML/warehouseTransaction/warehouseCashActivity/clearingBrokerCode |
commissionAmount | Â | decimal | 47 | in_local_commission | F | CASHDBO | CASH_ACTIVITY | LOCAL_COMMISSION | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/commissionAmount |
lotNumber | Â | string | 860 | in_lot_number | S | CASHDBO | CASH_ACTIVITY | LOT_NUMBER | CHAR(8) | EagleML/warehouseTransaction/warehouseCashActivity/lotNumber |
masterTicketNumber | Â | string | 761 | in_master_ticket_number | S | CASHDBO | CASH_ACTIVITY | MASTER_TICKET_NUMBER | VARCHAR2(255) | EagleML/warehouseTransaction/warehouseCashActivity/masterTicketNumber |
monthEndAccountingDate | Â | date | 4733 | in_month_end_acct_date | S | CASHDBO | CASH_ACTIVITY | MONTH_END_ACCT_DATE | DATE | EagleML/warehouseTransaction/warehouseCashActivity/monthEndAccountingDate |
secFee | Â | decimal | 3752 | in_sec_fees | F | CASHDBO | CASH_ACTIVITY | SEC_FEES | NUMBER(28,12) | EagleML/warehouseTransaction/warehouseCashActivity/secFee |
settlementDate | Â | date | 37 | in_settlement_date | S | CASHDBO | CASH_ACTIVITY | SETTLEMENT_DATE | DATE | EagleML/warehouseTransaction/warehouseCashActivity/settlementDate |
tradeDate | Â | date | 35 | in_trade_date | S | CASHDBO | CASH_ACTIVITY | TRADE_DATE | DATE | EagleML/warehouseTransaction/warehouseCashActivity/tradeDate |
transactionCode | Â | string | 2283 | in_trans_type | S | CASHDBO | CASH_ACTIVITY | TRANS_TYPE | CHAR(55) | EagleML/warehouseTransaction/warehouseCashActivity/transactionCode |
reasonCode | Â | string | 56 | Â | Â | not stored in DB | Â | EagleML/warehouseTransaction/warehouseCashActivity/reasonCode | ||
entitlementTradeDate | Â | date | 9970 | Â | Â | CASHDBO | CASH_ACTIVITY | ENTITLEMENT_TRADE_DATE | DATE | EagleML/warehouseTransaction/warehouseCashActivity/entitlementTradeDate |
Â