Warehouse Cash Activity Data Map Table
- Natalie Gesin (Deactivated)
- Alexey Chunikhin
- 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 | |||