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 |
|
|
|
|
| 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 | 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 | ||||||||||||||||||||
...