Warehouse Cash Flow Projection Data Map Table
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Dmitry Donosiyan (Unlicensed)
Element | Optional/Required | Value Type | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | DB Required | Xpath |
|---|---|---|---|---|---|---|---|---|---|---|
objectType | Optional | ObjectTypeEnum | not stored in DB | Â | Â | Â | Â | Â | Â | EagleML\warehouseTransaction\warehouseCashFlowProjection\objectType |
objectId | Optional | ObjectId | not stored in DB | Â | Â | Â | Â | Â | Â | EagleML\warehouseTransaction\warehouseCashFlowProjection\objectId |
objectDescription | Optional | FeedTypeEnum | not stored in DB | Â | Â | Â | Â | Â | Â | EagleML\warehouseTransaction\warehouseCashFlowProjection\objectDescription |
updateTimestamp | Optional | dateTime | Â | Â | Â | Â | Â | Â | Â | EagleML\warehouseTransaction\warehouseCashFlowProjection\updateTimestamp |
customElements | Not recommended | CustomElements | reserved for customization |  |  |  |  |  |  | EagleML\warehouseTransaction\warehouseCashFlowProjection\customElements |
sourceName | Optional | string | in_short_desc | S | Â | Â | Â | Â | Â | EagleML\warehouseTransaction\warehouseCashFlowProjection\sourceName |
updateSource | Optional | string | in_update_source | S | CASHDBO | CASH_FLOW_PROJECTION | UPDATE_SOURCE | CHAR(8) | Y | EagleML\warehouseTransaction\warehouseCashFlowProjection\updateSource |
batchCollectErrorsFlag | Optional | YesNoOptionEnum | not stored in DB | Â | Â | Â | Â | Â | Â | EagleML\warehouseTransaction\warehouseCashFlowProjection\batchCollectErrorsFlag |
singleRowCommitFlag | Optional | YesNoOptionEnum | not stored in DB |  |  |  |  |  |  | EagleML\warehouseTransaction\warehouseCashFlowProjection\singleRowCommitFlag |
linkEventId | Optional | TransactionId | in_link_event_id | Â | Â | Â | Â | Â | Â | EagleML\warehouseTransaction\warehouseCashFlowProjection\linkEventId |
localCurrency | Optional | CurrencyCode | in_local_currency | S | CASHDBO | CASH_FLOW_PROJECTION | LOCAL_CURRENCY | CHAR(3) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\localCurrency |
effectiveDate | Optional | date | in_effective_date | S | CASHDBO | CASH_FLOW_PROJECTION | EFFECTIVE_DATE | DATE | Y | EagleML\warehouseTransaction\warehouseCashFlowProjection\effectiveDate |
maturityDate | Optional | date | Â | Â | Â | Â | Â | Â | Â | EagleML\warehouseTransaction\warehouseCashFlowProjection\maturityDate |
longShortIndicator | Optional | LongShortIndicatorEnum | in_long_short_ind | S | CASHDBO | CASH_FLOW_PROJECTION | LONG_SHORT_IND | VARCHAR2(4) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\longShortIndicator |
EagleML\warehouseTransaction\warehouseCashFlowProjection| | ||||||||||
EagleML\warehouseTransaction\warehouseCashFlowProjection| | ||||||||||
accountingBasis | Optional | string | Â | Â | Â | Â | Â | Â | Â | EagleML\warehouseTransaction\warehouseCashFlowProjection\accountingBasis |
entityIDLookupSwitch | Optional | LookupSwitchEnum | in_989_flag | Â | not stored in DB | Â | Â | EagleML\warehouseTransaction\warehouseCashFlowProjection\entityIDLookupSwitch | ||
entityNameLookupSwitch | Optional | LookupSwitchEnum | in_primary_asset_id_flag | Â | not stored in DB | Â | Â | EagleML\warehouseTransaction\warehouseCashFlowProjection\entityNameLookupSwitch | ||
securityQueryFlag | Optional | YesNoOptionEnum | in_switch | Â | not stored in DB | Â | Â | EagleML\warehouseTransaction\warehouseCashFlowProjection\securityQueryFlag | ||
sourceLookupSwitch | Optional | LookupSwitchEnum | Â | Â | not stored in DBÂ | Â | Â | EagleML\warehouseTransaction\warehouseCashFlowProjection\sourceLookupSwitch | ||
procedureMode | Optional | ProcedureModeTypeEnum | in_procedure_mode | Â | not stored in DB | Â | Â | EagleML\warehouseTransaction\warehouseCashFlowProjection\procedureMode | ||
procedureFlag | Optional | ProcedureModeTypeEnum | in_mode_flag | Â | not stored in DB | Â | Â | EagleML\warehouseTransaction\warehouseCashFlowProjection\procedureFlag | ||
EagleML\warehouseTransaction\warehouseCashFlowProjection| | ||||||||||
EagleML\warehouseTransaction\warehouseCashFlowProjection| | ||||||||||
baseCurrency | Optional | CurrencyCode | in_base_currency | S | CASHDBO | CASH_FLOW_PROJECTION | BASE_CURRENCY | CHAR(3) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\baseCurrency |
srcIntfcInst | Optional | decimal | in_src_intfc_inst | I | not stored in DB | Â | Â | Â | Â | EagleML\warehouseTransaction\warehouseCashFlowProjection\srcIntfcInst |
transactionType | Optional | string | in_trans_type | S | CASHDBO | CASH_FLOW_PROJECTION | TRANS_TYPE | VARCHAR2(55) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\transactionType |
projEffectiveDate | Optional | date | in_proj_effective_date | S | CASHDBO | CASH_FLOW_PROJECTION | PROJ_EFFECTIVE_DATE | DATE | Y | EagleML\warehouseTransaction\warehouseCashFlowProjection\projEffectiveDate |
transactionNumber | Optional | string | in_trans_num | S | CASHDBO | CASH_FLOW_PROJECTION | TRANS_NUM | VARCHAR2(255) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\transactionNumber |
originalTransactionNumber | Optional | string | in_orig_trans_num | S | CASHDBO | CASH_FLOW_PROJECTION | ORIG_TRANS_NUM | VARCHAR2(255) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\originalTransactionNumber |
baseAmount | Optional | decimal | in_base_amount | F | CASHDBO | CASH_FLOW_PROJECTION | BASE_AMOUNT | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\baseAmount |
baseInterest | Optional | decimal | in_base_interest | F | CASHDBO | CASH_FLOW_PROJECTION | BASE_INTEREST | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\baseInterest |
localAmount | Optional | decimal | in_local_amount | F | CASHDBO | CASH_FLOW_PROJECTION | LOCAL_AMOUNT | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\localAmount |
localInterest | Optional | decimal | in_local_interest | F | CASHDBO | CASH_FLOW_PROJECTION | LOCAL_INTEREST | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\localInterest |
currFxRate | Optional | decimal | in_curr_fx_rate | F | CASHDBO | CASH_FLOW_PROJECTION | CURR_FX_RATE | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\currFxRate |
comments1 | Optional | string | in_comments1 | S | CASHDBO | CASH_FLOW_PROJECTION | COMMENTS1 | VARCHAR2(100) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\comments1 |
comments2 | Optional | string | in_comments2 | S | CASHDBO | CASH_FLOW_PROJECTION | COMMENTS2 | VARCHAR2(100) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\comments2 |
bankCode | Optional | string | in_bank_code | S | CASHDBO | CASH_FLOW_PROJECTION | BANK_CODE | CHAR(8) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\bankCode |
tradeDate | Optional | date | in_trade_date | S | CASHDBO | CASH_FLOW_PROJECTION | TRADE_DATE | DATE | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\tradeDate |
settlementCurrency | Optional | string | in_settlement_currency | F | CASHDBO | CASH_FLOW_PROJECTION | SETTLEMENT_CURRENCY | CHAR(3) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\settlementCurrency |
settlementDate | Optional | date | in_settlement_date | S | CASHDBO | CASH_FLOW_PROJECTION | SETTLEMENT_DATE | DATE | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\settlementDate |
prinAmount | Optional | decimal | in_prin_amt | F | CASHDBO | CASH_FLOW_PROJECTION | PRIN_AMT | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\prinAmount |
quantity | Optional | decimal | in_quantity | F | CASHDBO | CASH_FLOW_PROJECTION | QUANTITY | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\quantity |
currency3 | Optional | string | in_curr3 | S | CASHDBO | CASH_FLOW_PROJECTION | CURR3 | CHAR(3) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\currency3 |
projFloat1 | Optional | decimal | in_proj_float1 | F | CASHDBO | CASH_FLOW_PROJECTION | PROJ_FLOAT1 | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\projFloat1 |
projFloat2 | Optional | decimal | in_proj_float2 | F | CASHDBO | CASH_FLOW_PROJECTION | PROJ_FLOAT2 | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\projFloat2 |
projFloat3 | Optional | decimal | in_proj_float3 | F | CASHDBO | CASH_FLOW_PROJECTION | PROJ_FLOAT3 | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\projFloat3 |
projFloat4 | Optional | decimal | in_proj_float4 | F | CASHDBO | CASH_FLOW_PROJECTION | PROJ_FLOAT4 | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\projFloat4 |
cfUserFloat1 | Optional | decimal | in_cf_user_float1 | F | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_FLOAT1 | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserFloat1 |
cfUserFloat2 | Optional | decimal | in_cf_user_float2 | F | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_FLOAT2 | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserFloat2 |
cfUserFloat3 | Optional | decimal | in_cf_user_float3 | F | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_FLOAT3 | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserFloat3 |
cfUserFloat4 | Optional | decimal | in_cf_user_float4 | F | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_FLOAT4 | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserFloat4 |
cfUserFloat5 | Optional | decimal | in_cf_user_float5 | F | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_FLOAT5 | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserFloat5 |
cfUserFloat6 | Optional | decimal | in_cf_user_float6 | F | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_FLOAT6 | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserFloat6 |
cfUserFloat7 | Optional | decimal | in_cf_user_float7 | F | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_FLOAT7 | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserFloat7 |
cfUserFloat8 | Optional | decimal | in_cf_user_float8 | F | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_FLOAT8 | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserFloat8 |
cfUserFloat9 | Optional | decimal | in_cf_user_float9 | F | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_FLOAT9 | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserFloat9 |
cfUserFloat10 | Optional | decimal | in_cf_user_float10 | F | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_FLOAT10 | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserFloat10 |
cfUserFloat11 | Optional | decimal | in_cf_user_float11 | F | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_FLOAT11 | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserFloat11 |
cfUserFloat18 | Optional | decimal | in_cf_user_float18 | F | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_FLOAT18 | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserFloat18 |
cfUserFloat19 | Optional | decimal | in_cf_user_float19 | F | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_FLOAT19 | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserFloat19 |
cfUserFloat20 | Optional | decimal | in_cf_user_float20 | F | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_FLOAT20 | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserFloat20 |
cfUserFloat21 | Optional | decimal | in_cf_user_float21 | F | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_FLOAT21 | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserFloat21 |
originalAmount | Optional | decimal | in_orig_amount | F | CASHDBO | CASH_FLOW_PROJECTION | ORIG_AMOUNT | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\originalAmount |
statYtd | Optional | decimal | in_stat_ytd | F | CASHDBO | CASH_FLOW_PROJECTION | STAT_YTD | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\statYtd |
gaapYlt | Optional | decimal | in_gaap_ylt | F | CASHDBO | CASH_FLOW_PROJECTION | GAAP_YLT | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\gaapYlt |
mgmtYtd | Optional | decimal | in_mgmt_ytd | S | CASHDBO | CASH_FLOW_PROJECTION | MGMT_YTD | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\mgmtYtd |
currentPrinDue | Optional | decimal | in_current_prin_due | F | CASHDBO | CASH_FLOW_PROJECTION | CURRENT_PRIN_DUE | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\currentPrinDue |
currentIntDue | Optional | decimal | in_current_int_due | F | CASHDBO | CASH_FLOW_PROJECTION | CURRENT_INT_DUE | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\currentIntDue |
escrTaxDue | Optional | decimal | in_escr_tax_due | F | CASHDBO | CASH_FLOW_PROJECTION | ESCR_TAX_DUE | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\escrTaxDue |
escrInsDue | Optional | decimal | in_escr_ins_due | F | CASHDBO | CASH_FLOW_PROJECTION | ESCR_INS_DUE | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\escrInsDue |
escrMipDue | Optional | decimal | in_escr_mip_due | F | CASHDBO | CASH_FLOW_PROJECTION | ESCR_MIP_DUE | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\escrMipDue |
escrOtherDue | Optional | decimal | in_escr_other_due | F | CASHDBO | CASH_FLOW_PROJECTION | ESCR_OTHER_DUE | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\escrOtherDue |
lateChargeDue | Optional | decimal | in_late_charge_due | F | CASHDBO | CASH_FLOW_PROJECTION | LATE_CHARGE_DUE | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\lateChargeDue |
lateChargeStat | Optional | decimal | in_late_charge_stat | F | CASHDBO | CASH_FLOW_PROJECTION | LATE_CHARGE_STAT | NUMBER(28,12) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\lateChargeStat |
cfUserChar1 | Optional | string | in_cf_user_char1 | S | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_CHAR1 | CHAR(3) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserChar1 |
cfUserChar2 | Optional | string | in_cf_user_char2 | S | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_CHAR2 | CHAR(2) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserChar2 |
cfUserChar3 | Optional | string | in_cf_user_char3 | S | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_CHAR3 | CHAR(2) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserChar3 |
cfUserChar4 | Optional | string | in_cf_user_char4 | S | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_CHAR4 | VARCHAR2(100) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserChar4 |
cfUserChar5 | Optional | string | in_cf_user_char5 | S | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_CHAR5 | VARCHAR2(100) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserChar5 |
cfUserChar6 | Optional | string | in_cf_user_char6 | S | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_CHAR6 | VARCHAR2(25) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserChar6 |
cfUserChar7 | Optional | string | in_cf_user_char7 | S | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_CHAR7 | VARCHAR2(15) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserChar7 |
cfUserChar8 | Optional | string | in_cf_user_char8 | S | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_CHAR8 | VARCHAR2(15) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserChar8 |
cfUserChar9 | Optional | string | in_cf_user_char9 | S | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_CHAR9 | VARCHAR2(10) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserChar9 |
cfUserChar10 | Optional | string | in_cf_user_char10 | S | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_CHAR10 | VARCHAR2(10) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserChar10 |
cfUserDate13 | Optional | string | in_cf_user_date13 | S | CASHDBO | CASH_FLOW_PROJECTION | CF_USER_DATE13 | DATE | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cfUserDate13 |
cashCategory | Optional | string | in_cash_category | S | CASHDBO | CASH_FLOW_PROJECTION | CASH_CATEGORY | CHAR(20) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cashCategory |
cashEventType | Optional | string | in_cash_event_type | S | CASHDBO | CASH_FLOW_PROJECTION | CASH_EVENT_TYPE | CHAR(8) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\cashEventType |
userGroup1 | Optional | string | in_user_group1 | S | CASHDBO | CASH_FLOW_PROJECTION | USER_GROUP1 | VARCHAR2(8) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\userGroup1 |
userGroup2 | Optional | string | in_user_group2 | S | CASHDBO | CASH_FLOW_PROJECTION | USER_GROUP2 | VARCHAR2(8) | N | EagleML\warehouseTransaction\warehouseCashFlowProjection\userGroup2 |
Â