Warehouse Position Data Map Table
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Pamela Totas (Deactivated)
In your extract you can force populating the value for baseCurrency from HOLDINGDBO.POSITION_DETAIL.BASE_CURRENCY instead of HOLDINGDBO.POSITION.BASE_CURRENCY field. To do that, set W_TAKE_BASE_CURRENCY_FROM_WRHS_POS_DET in the config file or use an RTR task parameter TakeBaseCurrencyFromWRHSPosDet with the value 'Y'.
Element | Optional/Required | Value Type | Star Tag | SP Parameter | SP Type | Eagle DB | DB Table | DB Field | DB Field Type | DB Required | XPATH |
|---|---|---|---|---|---|---|---|---|---|---|---|
objectType |
| ObjectTypeEnum |
|
|
| not stored in DB |
|
| EagleML/warehouseTransaction/warehousePosition/objectType | ||
objectId |
| ObjectId |
|
|
| not stored in DB |
|
| EagleML/warehouseTransaction/warehousePosition/objectId | ||
objectDescription |
| FeedTypeEnum |
|
|
| not stored in DB |
|
| EagleML/warehouseTransaction/warehousePosition/objectDescription | ||
updateTimestamp |
| dateTime |
|
|
| HOLDINGDBO | POSITION_DETAIL | UPDATE_DATE | DATE | N | EagleML/warehouseTransaction/warehousePosition/updateTimestamp |
customElements | Not recommended | CustomElements | CustomElements – reserved for customizations | N | EagleML/warehouseTransaction/warehousePosition/customElements | ||||||
sourceName |
| string | 1102 | in_short_desc | S | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | Y | EagleML/warehouseTransaction/warehousePosition/sourceName |
updateSource |
| string | 944 | in_update_source | S | HOLDINGDBO | POSITION_DETAIL | UPDATE_SOURCE | CHAR(8) | N | EagleML/warehouseTransaction/warehousePosition/updateSource |
batchCollectErrorsFlag |
| YesNoOptionEnum |
|
|
| not stored in DB |
| N | EagleML/warehouseTransaction/warehousePosition/batchCollectErrorsFlag | ||
singleRowCommitFlag |
| YesNoOptionEnum |
|
|
| not stored in DB |
|
| EagleML/warehouseTransaction/warehousePosition/singleRowCommitFlag | ||
reportType |
| ReportTypeEnum |
| in_report_type |
|
|
|
|
|
| EagleML/warehouseTransaction/warehousePosition/reportType |
linkEventId |
| TransactionId |
|
|
| not stored in DB - used in resolution logics |
|
| EagleML/warehouseTransaction/warehousePosition/linkEventId | ||
localCurrency |
| CurrencyCode | 85 | in_local_currency | S | HOLDINGDBO | POSITION_DETAIL | LOCAL_CURRENCY | CHAR(3) | N | EagleML/warehouseTransaction/warehousePosition/localCurrency |
effectiveDate |
| date | 221 | in_effective_date | S | HOLDINGDBO | POSITION | EFFECTIVE_DATE | DATE | Y | EagleML/warehouseTransaction/warehousePosition/effectiveDate |
maturityDate |
| date |
|
|
| not stored in DB |
|
|
|
| EagleML/warehouseTransaction/warehousePosition/maturityDate |
longShortIndicator |
| LongShortIndicatorEnum | 15 | in_long_short_ind | S | HOLDINGDBO | POSITION_DETAIL | LONG_SHORT_IND | CHAR(4) | N | EagleML/warehouseTransaction/warehousePosition/longShortIndicator |
EagleML/warehouseTransaction/warehousePosition/ | |||||||||||
EagleML/warehouseTransaction/warehousePosition/ | |||||||||||
accountingBasis |
| string | 21 | in_acct_basis | S | HOLDINGDBO | POSITION | ACCT_BASIS | VARCHAR2(5) | N | EagleML/warehouseTransaction/warehousePosition/accountingBasis |
entityIDLookupSwitch |
| LookupSwitchEnum |
|
|
| not stored in DB |
|
|
|
| EagleML/warehouseTransaction/warehousePosition/entityIDLookupSwitch |
entityNameLookupSwitch |
| LookupSwitchEnum |
|
|
| not stored in DB |
|
|
|
| EagleML/warehouseTransaction/warehousePosition/entityNameLookupSwitch |
securityQueryFlag |
| YesNoOptionEnum |
|
|
| not stored in DB |
|
|
|
| EagleML/warehouseTransaction/warehousePosition/securityQueryFlag |
sourceLookupSwitch |
| LookupSwitchEnum |
|
|
| not stored in DB |
|
|
|
| EagleML/warehouseTransaction/warehousePosition/sourceLookupSwitch |
procedureMode |
| ProcedureFlagTypeEnum |
|
|
| not stored in DB |
|
|
|
| EagleML/warehouseTransaction/warehousePosition/procedureMode |
procedureFlag |
| ProcedureFlagTypeEnum |
|
|
| not stored in DB |
|
|
|
| EagleML/warehouseTransaction/warehousePosition/procedureFlag |
EagleML/referenceTransaction/warehousePosition/ | |||||||||||
EagleML/referenceTransaction/warehousePosition/ | |||||||||||
baseCurrency |
| CurrencyCode | 86 | in_base_currency | S | HOLDINGDBO | POSITION (or POSITION_DETAIL) | BASE_CURRENCY | VARCHAR2(3) | N | EagleML/warehouseTransaction/warehousePosition/baseCurrency |
srcIntfcInst |
| decimal |
|
|
| not stored in DB |
|
|
|
| EagleML/warehouseTransaction/warehousePosition/srcIntfcInst |
transactionType |
| string |
|
|
| not stored in DB |
|
|
|
| EagleML/warehouseTransaction/warehousePosition/transactionType |
rollupFlag |
| YesNoOptionEnum |
|
|
| not stored in DB |
|
|
|
| EagleML/warehouseTransaction/warehousePosition/rollupFlag |
urglSecurityBase |
| decimal | 491 | in_unrealized_sec_gl | F | HOLDINGDBO | POSITION_DETAIL | UNREALIZED_SEC_GL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/urglSecurityBase |
urglCurrencyBase |
| decimal | 493 | in_unrealized_curr_gl | F | HOLDINGDBO | POSITION_DETAIL | UNREALIZED_CURR_GL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/urglCurrencyBase |
updateDate |
| date | 1106 | in_update_date | S | not stored in DB |
|
|
|
| EagleML/warehouseTransaction/warehousePosition/updateDate |
amortizedLtdBase |
| decimal | 595 | in_amort_ltd_base | F | HOLDINGDBO | POSITION_COST_DETAIL | AMORT_LTD_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/amortizedLtdBase |
amortizedLtdLocal |
| decimal | 580 | in_amort_ltd_local | F | HOLDINGDBO | POSITION_COST_DETAIL | AMORT_LTD_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/amortizedLtdLocal |
amortizedPtdBase |
| decimal | 598 | in_amort_ptd_base | F | HOLDINGDBO | POSITION_COST_DETAIL | AMORT_PTD_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/amortizedPtdBase |
amortizedPtdLocal |
| decimal | 583 | in_amort_ptd_local | F | HOLDINGDBO | POSITION_COST_DETAIL | AMORT_PTD_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/amortizedPtdLocal |
closeAmortizedLocal |
| decimal | 521 | in_cls_amort_local | F | HOLDINGDBO | POSITION_COST_DETAIL | CLS_AMORT_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/closeAmortizedLocal |
closeAmortizedBase |
| decimal | 522 | in_cls_amort_base | F | HOLDINGDBO | POSITION_COST_DETAIL | CLS_AMORT_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/closeAmortizedBase |
amortDeltaBase |
| decimal | 599 | in_amort_delta_base | F | HOLDINGDBO | POSITION_COST_DETAIL | AMORT_DELTA_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/amortDeltaBase |
amortDeltaLocal |
| decimal | 584 | in_amort_delta_local | F | HOLDINGDBO | POSITION_COST_DETAIL | AMORT_DELTA_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/amortDeltaLocal |
amortMethod |
| string | 113 | in_amort_method | S | HOLDINGDBO | POSITION_COST_DETAIL | AMORT_METHOD | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehousePosition/amortMethod |
accruedIncomeLocal |
| decimal | 718 | in_accrued_income_local | F | HOLDINGDBO | POSITION_DETAIL | ACCRUED_INCOME_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/accruedIncomeLocal |
accruedLtdBase |
| decimal | 585 | in_accr_ltd_base | F | HOLDINGDBO | POSITION_COST_DETAIL | ACCR_LTD_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/accruedLtdBase |
accruedLtdLocal |
| decimal | 462 | in_accr_ltd_local | F | HOLDINGDBO | POSITION_COST_DETAIL | ACCR_LTD_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/accruedLtdLocal |
accrDeltaBase |
| decimal | 589 | in_accr_delta_base | F | HOLDINGDBO | POSITION_COST_DETAIL | ACCR_DELTA_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/accrDeltaBase |
accrDeltaLocal |
| decimal | 466 | in_accr_delta_local | F | HOLDINGDBO | POSITION_COST_DETAIL | ACCR_DELTA_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/accrDeltaLocal |
accruedDisc |
| decimal | 10655 | in_accrued_disc | F | HOLDINGDBO | POSITION | ACCRUED_DISC | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/accruedDisc |
accruedPerm |
| decimal | 10654 | in_accrued_perm | F | HOLDINGDBO | POSITION | ACCRUED_PERM | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/accruedPerm |
accruedIncome |
| decimal | 726 | in_accrued_income | F | HOLDINGDBO | POSITION_DETAIL | ACCRUED_INCOME | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/accruedIncome |
averageCost |
| decimal | 170 | in_average_cost | F | HOLDINGDBO | POSITION_DETAIL | AVERAGE_COST | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/averageCost |
averageCostLocal |
| decimal | 130 | in_average_cost_local | F | HOLDINGDBO | POSITION_DETAIL | AVERAGE_COST_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/averageCostLocal |
bifCostFlag |
| YesNoOptionEnum | 2839 | in_bif_cost_flag | S | HOLDINGDBO | POSITION_COST_DETAIL | BIF_COST_FLAG | VARCHAR2(1) | N | EagleML/warehouseTransaction/warehousePosition/bifCostFlag |
closeIndexWeight |
| decimal | 4483 | in_indx_weight | F | HOLDINGDBO | POSITION_DETAIL | INDX_WEIGHT | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/closeIndexWeight |
closeFinalEarnThruDt |
| date | 1982 | in_close_final_earn_thru_dt | S | HOLDINGDBO | POSITION_COST_DETAIL | CLOSE_FINAL_EARN_THRU_DT | DATE | N | EagleML/warehouseTransaction/warehousePosition/closeFinalEarnThruDt |
covUnitCostAvgL |
| decimal | 2824 | in_cov_unit_cost_avg_l | F | HOLDINGDBO | POSITION_COST_DETAIL | COV_UNIT_COST_AVG_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/covUnitCostAvgL |
covUnitCostAvgB |
| decimal | 2825 | in_cov_unit_cost_avg_b | F | HOLDINGDBO | POSITION_COST_DETAIL | COV_UNIT_COST_AVG_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/covUnitCostAvgB |
covCurCostAvgL |
| decimal | 2828 | in_cov_cur_cost_avg_l | F | HOLDINGDBO | POSITION_COST_DETAIL | COV_CUR_COST_AVG_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/covCurCostAvgL |
covCurCostAvgB |
| decimal | 2829 | in_cov_cur_cost_avg_b | F | HOLDINGDBO | POSITION_COST_DETAIL | COV_CUR_COST_AVG_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/covCurCostAvgB |
covPosQty |
| decimal | 2831 | in_cov_pos_qty | F | HOLDINGDBO | POSITION_COST_DETAIL | COV_POS_QTY | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/covPosQty |
coupon |
| decimal | 70 | in_coupon | F | HOLDINGDBO | POSITION_COST_DETAIL | COUPON | NUMBER(38,6) | N | EagleML/warehouseTransaction/warehousePosition/coupon |
couponReceivableLocal |
| decimal | 9500 | in_coupon_receivable_local | F | HOLDINGDBO | POSITION_DETAIL | COUPON_RECEIVABLE_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/couponReceivableLocal |
couponReceivableBase |
| decimal | 9501 | in_coupon_receivable | F | HOLDINGDBO | POSITION_DETAIL | COUPON_RECEIVABLE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/couponReceivableBase |
couponEndDate |
| date | 993 | in_coupon_end_date | S | HOLDINGDBO | POSITION_COST_DETAIL | COUPON_END_DATE | DATE | N | EagleML/warehouseTransaction/warehousePosition/couponEndDate |
couponBeginDate |
| date | 992 | in_coupon_begin_date | S | HOLDINGDBO | POSITION_COST_DETAIL | COUPON_BEGIN_DATE | DATE | N | EagleML/warehouseTransaction/warehousePosition/couponBeginDate |
costMethod |
| string | 22 | in_cost_method | S | HOLDINGDBO | POSITION_DETAIL | COST_METHOD | VARCHAR2(2) | N | EagleML/warehouseTransaction/warehousePosition/costMethod |
currentExCumIndicator |
| string | 4305 | in_current_ex_cum_indicator | S | HOLDINGDBO | POSITION_COST_DETAIL | CURRENT_EX_CUM_INDICATOR | VARCHAR2(3) | N | EagleML/warehouseTransaction/warehousePosition/currentExCumIndicator |
currencyReturn |
| decimal | 2684 | in_currency_return | F | HOLDINGDBO | POSITION_DETAIL | CURRENCY_RETURN | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/currencyReturn |
currFxRate |
| decimal | 96 | in_curr_fx_rate | F | HOLDINGDBO | POSITION_DETAIL | CURR_FX_RATE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/currFxRate |
classCode |
| string | 34 | in_class_code | S | HOLDINGDBO | POSITION | CLASS_CODE | VARCHAR2(8) | N | EagleML/warehouseTransaction/warehousePosition/classCode |
cumulativeAvgCost |
| decimal | 3209 | in_cumulative_avg_cost | F | HOLDINGDBO | POSITION_DETAIL | CUMULATIVE_AVG_COST | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/cumulativeAvgCost |
daysInterestEarned |
| integer | 469 | in_days_interest_earned | F | HOLDINGDBO | POSITION_DETAIL | DAYS_INTEREST_EARNED | NUMBER(38) | N | EagleML/warehouseTransaction/warehousePosition/daysInterestEarned |
defaultDate |
| date | 1535 | in_default_date | S | HOLDINGDBO | POSITION_COST_DETAIL | DEFAULT_DATE | DATE | N | EagleML/warehouseTransaction/warehousePosition/defaultDate |
defaultIndicator |
| string | 1551 | in_default_indicator | S | HOLDINGDBO | POSITION_COST_DETAIL | DEFAULT_INDICATOR | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehousePosition/defaultIndicator |
deferredIncomeDelta |
| decimal | 5358 | in_deferred_income_delta | F | HOLDINGDBO | POSITION_COST_DETAIL | DEFERRED_INCOME_DELTA | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/deferredIncomeDelta |
deferredIncomeDeltaLocal |
| decimal | 5357 | in_deferred_income_delta_local | F | HOLDINGDBO | POSITION_COST_DETAIL | DEFERRED_INCOME_DELTA_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/deferredIncomeDeltaLocal |
dividendReceivableLocal |
| decimal | 9498 | in_dividend_receivable_local | F | HOLDINGDBO | POSITION_DETAIL | DIVIDEND_RECEIVABLE_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/dividendReceivableLocal |
dividendReceivableBase |
| decimal | 9499 | in_dividend_receivable | F | HOLDINGDBO | POSITION_DETAIL | DIVIDEND_RECEIVABLE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/dividendReceivableBase |
earnedThruDtPrevious |
| date | 454 | in_earned_thru_dt_previous | S | HOLDINGDBO | POSITION_COST_DETAIL | EARNED_THRU_DT_PREVIOUS | DATE | N | EagleML/warehouseTransaction/warehousePosition/earnedThruDtPrevious |
earnedThruDate |
| date | 461 | in_earned_thru_date | S | HOLDINGDBO | POSITION_COST_DETAIL | EARNED_THRU_DATE | DATE | N | EagleML/warehouseTransaction/warehousePosition/earnedThruDate |
effExpValueBase |
| decimal | 13301 | in_eff_exp_value_base | S | HOLDINGDBO | POSITION_DETAIL | EFF_EXP_VALUE_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/effExpValueBase |
effExpValueLocal |
| decimal | 13302 | in_eff_exp_value_local | S | HOLDINGDBO | POSITION_DETAIL | EFF_EXP_VALUE_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/effExpValueLocal |
effExpValueReporting |
| decimal | 13303 | in_eff_exp_value_reporting | S | HOLDINGDBO | POSITION_DETAIL | EFF_EXP_VALUE_REPORTING | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/effExpValueReporting |
exchangeRateDate
|
| date
| 485
| in_exchange_rate_date
| S
| HOLDINGDBO | POSITION_COST_DETAIL | EXCHANGE_RATE_DATE | DATE
| N
| EagleML/warehouseTransaction/warehousePosition/exchangeRateDate
|
HOLDINGDBO | POSITION_DETAIL | EXCHANGE_RATE_DATE | |||||||||
entityFlagType |
| string | 3929 | in_entity_flag_type | S | HOLDINGDBO | POSITION | ENTITY_FLAG_TYPE | CHAR(4) | N | EagleML/warehouseTransaction/warehousePosition/entityFlagType |
entityAlias |
| decimal | 1333 | in_entity_alias | S | HOLDINGDBO | POSITION | ENTITY_ALIAS | NUMBER | N | EagleML/warehouseTransaction/warehousePosition/entityAlias |
eligibleCashManagFlag |
| YesNoOptionEnum | 1446 | in_eligible_cash_management_flag | S | HOLDINGDBO | POSITION_DETAIL | ELIGIBLE_CASH_MANAGEMENT_FLAG | CHAR(8) | N | EagleML/warehouseTransaction/warehousePosition/eligibleCashManagFlag |
fundAccountId |
| string | 1801 | in_fund_account_id | S | HOLDINGDBO | POSITION_DETAIL | FUND_ACCOUNT_ID | VARCHAR2(30) | N | EagleML/warehouseTransaction/warehousePosition/fundAccountId |
fwdCurrSettlementDate |
| date | 1222 | in_fwd_curr_settlement_date | S | HOLDINGDBO | POSITION_DETAIL | FWD_CURR_SETTLEMENT_DATE | DATE | N | EagleML/warehouseTransaction/warehousePosition/fwdCurrSettlementDate |
gaapCostAvgValue |
| decimal | 9313 | in_gaap_cost_avg_value | F | HOLDINGDBO | POSITION_COST_DETAIL | GAAP_COST_AVG_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/gaapCostAvgValue |
localGaapCostAvgValue |
| decimal | 9319 | in_local_gaap_cost_avg_value | F | HOLDINGDBO | POSITION_COST_DETAIL | LOCAL_GAAP_COST_AVG_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/localGaapCostAvgValue |
incomeBalanceLocal |
| decimal | 4760 | in_income_balance_local | F | HOLDINGDBO | POSITION_DETAIL | INCOME_BALANCE_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/incomeBalanceLocal |
incomeBalance |
| decimal | 4761 | in_income_balance | F | HOLDINGDBO | POSITION_DETAIL | INCOME_BALANCE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/incomeBalance |
incomeTaxExpenseDeltaB |
| decimal | 858 | in_income_tax_expense_delta_b | F | HOLDINGDBO | POSITION_COST_DETAIL | INCOME_TAX_EXPENSE_DELTA_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/incomeTaxExpenseDeltaB |
incomeTaxExpenseDeltaL |
| decimal | 857 | in_income_tax_expense_delta_l | F | HOLDINGDBO | POSITION_COST_DETAIL | INCOME_TAX_EXPENSE_DELTA_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/incomeTaxExpenseDeltaL |
incomeReturn |
| decimal | 9867 | in_income_return | F | HOLDINGDBO | POSITION_DETAIL | INCOME_RETURN | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/incomeReturn |
interestPurchased |
| decimal | 49 | in_interest_purchased | F | HOLDINGDBO | POSITION_DETAIL | INTEREST_PURCHASED | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/interestPurchased |
interestEarnedBase |
| decimal | 588 | in_interest_earned_base | F | HOLDINGDBO | POSITION_DETAIL | INTEREST_EARNED_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/interestEarnedBase |
impairmentPtdLocal |
| decimal | 2777 | in_impairment_ptd_local | F | HOLDINGDBO | POSITION_COST_DETAIL | IMPAIRMENT_PTD_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/impairmentPtdLocal |
impairmentPtdBase |
| decimal | 2778 | in_impairment_ptd_base | F | HOLDINGDBO | POSITION_COST_DETAIL | IMPAIRMENT_PTD_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/impairmentPtdBase |
lastOpenDate
|
| date
| 136
| in_last_open_date
| S
| HOLDINGDBO | POSITION_COST_DETAIL | LAST_OPEN_DATE | DATE
| N
| EagleML/warehouseTransaction/warehousePosition/lastOpenDate
|
HOLDINGDBO | POSITION_DETAIL | LAST_OPEN_DATE | |||||||||
lastCloseDate
|
| date
| 135
| in_last_close_date
| S
| HOLDINGDBO | POSITION_COST_DETAIL | LAST_CLOSE_DATE | DATE
| N
| EagleML/warehouseTransaction/warehousePosition/lastCloseDate
|
HOLDINGDBO | POSITION_DETAIL | LAST_CLOSE_DATE | |||||||||
lastLossDate
|
| date
| 138
| in_last_loss_date
| S
| HOLDINGDBO | POSITION_COST_DETAIL | LAST_LOSS_DATE | DATE
| N
| EagleML/warehouseTransaction/warehousePosition/lastLossDate
|
HOLDINGDBO | POSITION_DETAIL | LAST_LOSS_DATE | |||||||||
liabilities |
| decimal | 12055 | in_liabilities | F | HOLDINGDBO | POSITION | LIABILITIES | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/liabilities |
marketValueLocal |
| decimal | 487 | in_local_market_value | F | HOLDINGDBO | POSITION_DETAIL | LOCAL_MARKET_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/marketValueLocal |
marketValueBase |
| decimal | 488 | in_market_value | F | HOLDINGDBO | POSITION_DETAIL | MARKET_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/marketValueBase |
marketValueIncomeLocal |
| decimal | 9424 | in_market_value_income_local | F | HOLDINGDBO | POSITION_DETAIL | MARKET_VALUE_INCOME_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/marketValueIncomeLocal |
marketValueIncomeBase |
| decimal | 9426 | in_market_value_income | F | HOLDINGDBO | POSITION_DETAIL | MARKET_VALUE_INCOME | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/marketValueIncomeBase |
marketExchangeRate |
| decimal | 484 | in_mkt_exchange_rate | F | HOLDINGDBO | POSITION_DETAIL | MKT_EXCHANGE_RATE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/marketExchangeRate |
miscIncReceivableLocal |
| decimal | 10767 | in_misc_inc_receivable_local | F | HOLDINGDBO | POSITION_DETAIL | MISC_INC_RECEIVABLE_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/miscIncReceivableLocal |
miscIncReceivableBase |
| decimal | 10768 | in_misc_inc_receivable | F | HOLDINGDBO | POSITION_DETAIL | MISC_INC_RECEIVABLE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/miscIncReceivableBase |
notionalMarketValueBase |
| decimal | 10794 | in_notional_market_value | F | HOLDINGDBO | POSITION_DETAIL | NOTIONAL_MARKET_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/notionalMarketValueBase |
notionalUnrealizedGlBase |
| decimal | 10796 | in_notional_unrealized_gl | F | HOLDINGDBO | POSITION_DETAIL | NOTIONAL_UNREALIZED_GL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/notionalUnrealizedGlBase |
notionalCostLocal |
| decimal | 10791 | in_notional_cost_local | F | HOLDINGDBO | POSITION_DETAIL | NOTIONAL_COST_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/notionalCostLocal |
notionalCostBase |
| decimal | 10792 | in_notional_cost | F | HOLDINGDBO | POSITION_DETAIL | NOTIONAL_COST | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/notionalCostBase |
notionalMarketValueLocal |
| decimal | 10793 | in_notional_market_value_local | F | HOLDINGDBO | POSITION_DETAIL | NOTIONAL_MARKET_VALUE_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/notionalMarketValueLocal |
notionalUnrealizedGlLocal |
| decimal | 10795 | in_notional_local_unrealized_gl | F | HOLDINGDBO | POSITION_DETAIL | NOTIONAL_LOCAL_UNREALIZED_GL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/notionalUnrealizedGlLocal |
notionalUnrealizedCurrGl |
| decimal | 10797 | in_notional_unrealized_curr_gl | F | HOLDINGDBO | POSITION_DETAIL | NOTIONAL_UNREALIZED_CURR_GL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/notionalUnrealizedCurrGl |
notionalUnrealizedSecGl |
| decimal | 10798 | in_notional_unrealized_sec_gl | F | HOLDINGDBO | POSITION_DETAIL | NOTIONAL_UNREALIZED_SEC_GL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/notionalUnrealizedSecGl |
originalDividendReceivable |
| decimal | 869 | in_orig_dividend_receivable | F | HOLDINGDBO | POSITION_DETAIL | ORIG_DIVIDEND_RECEIVABLE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/originalDividendReceivable |
originalCouponReceivable |
| decimal | 875 | in_orig_coupon_receivable | F | HOLDINGDBO | POSITION_DETAIL | ORIG_COUPON_RECEIVABLE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/originalCouponReceivable |
originalFace |
| decimal | 41 | in_orig_face | F | HOLDINGDBO | POSITION_DETAIL | ORIG_FACE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/originalFace |
originalReclaimReceivable |
| decimal | 876 | in_orig_reclaim_receivable | F | HOLDINGDBO | POSITION_DETAIL | ORIG_RECLAIM_RECEIVABLE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/originalReclaimReceivable |
originalMiscIncReceivable |
| decimal | 877 | in_orig_misc_inc_receivable | F | HOLDINGDBO | POSITION_DETAIL | ORIG_MISC_INC_RECEIVABLE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/originalMiscIncReceivable |
performanceFlag |
| YesNoOptionEnum | 9985 | in_perform_flag | S | HOLDINGDBO | POSITION | PERFORM_FLAG | CHAR(2) | N | EagleML/warehouseTransaction/warehousePosition/performanceFlag |
priceDate |
| date | 482 | in_price_date | S | HOLDINGDBO | POSITION_COST_DETAIL | PRICE_DATE | DATE | N | EagleML/warehouseTransaction/warehousePosition/priceDate |
POSITION_DETAIL | |||||||||||
reclaimReceivableLocal |
| decimal | 9502 | in_reclaim_receivable_local | F | HOLDINGDBO | POSITION_DETAIL | RECLAIM_RECEIVABLE_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/reclaimReceivableLocal |
reclaimReceivableBase |
| decimal | 9503 | in_reclaim_receivable | F | HOLDINGDBO | POSITION_DETAIL | RECLAIM_RECEIVABLE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/reclaimReceivableBase |
settleDatePositionBase |
| decimal | 10043 | in_settlement_date_position | F | HOLDINGDBO | POSITION_DETAIL | SETTLEMENT_DATE_POSITION | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/settleDatePositionBase |
settlDatePositionLocal |
| decimal | 10044 | in_settlement_date_position_local | F | HOLDINGDBO | POSITION_DETAIL | SETTLEMENT_DATE_POSITION_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/settlDatePositionLocal |
settledUnitCostBase |
| decimal | 11045 | in_settled_gaap_unit_cost | F | HOLDINGDBO | POSITION_COST_DETAIL | SETTLED_GAAP_UNIT_COST | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/settledUnitCostBase |
settledCostBase |
| decimal | 11047 | in_settled_gaap_cost_value | F | HOLDINGDBO | POSITION_COST_DETAIL | SETTLED_GAAP_COST_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/settledCostBase |
settledMarketValueLocal |
| decimal | 11048 | in_settled_local_market_value | F | HOLDINGDBO | POSITION_DETAIL | SETTLED_LOCAL_MARKET_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/settledMarketValueLocal |
settledMarketValueBase |
| decimal | 11049 | in_settled_market_value | F | HOLDINGDBO | POSITION_DETAIL | SETTLED_MARKET_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/settledMarketValueBase |
settledUrglSecLocal |
| decimal | 11050 | in_settled_local_sec_urgl | F | HOLDINGDBO | POSITION_DETAIL | SETTLED_LOCAL_SEC_URGL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/settledUrglSecLocal |
settledUrglSecBase |
| decimal | 11051 | in_settled_base_sec_urgl | F | HOLDINGDBO | POSITION_DETAIL | SETTLED_BASE_SEC_URGL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/settledUrglSecBase |
settledUrglCurrencyBase |
| decimal | 11052 | in_settled_base_currency_urgl | F | HOLDINGDBO | POSITION_DETAIL | SETTLED_BASE_CURRENCY_URGL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/settledUrglCurrencyBase |
settledUrglTotalBase |
| decimal | 11053 | in_settled_base_total_urgl | F | HOLDINGDBO | POSITION_DETAIL | SETTLED_BASE_TOTAL_URGL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/settledUrglTotalBase |
settledQuantity |
| decimal | 274 | in_settle_quantity | F | HOLDINGDBO | POSITION_DETAIL | SETTLE_QUANTITY | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/settledQuantity |
systemCurrAccruedIncome |
| decimal | 11731 | in_accrued_income_sys | F | HOLDINGDBO | POSITION_DETAIL | ACCRUED_INCOME_SYS | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/systemCurrAccruedIncome |
systemCurrMarketValue |
| decimal | 11732 | in_market_value_sys | F | HOLDINGDBO | POSITION_DETAIL | MARKET_VALUE_SYS | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/systemCurrMarketValue |
systemCurrDividendReceivable |
| decimal | 11733 | in_dividend_receivable_sys | F | HOLDINGDBO | POSITION_DETAIL | DIVIDEND_RECEIVABLE_SYS | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/systemCurrDividendReceivable |
systemCurrCouponReceivable |
| decimal | 11734 | in_coupon_receivable_sys | F | HOLDINGDBO | POSITION_DETAIL | COUPON_RECEIVABLE_SYS | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/systemCurrCouponReceivable |
systemCurrReclaimReceivable |
| decimal | 11735 | in_reclaim_receivable_sys | F | HOLDINGDBO | POSITION_DETAIL | RECLAIM_RECEIVABLE_SYS | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/systemCurrReclaimReceivable |
systemCurrMiscIncReceivable |
| decimal | 11736 | in_misc_inc_receivable_sys | F | HOLDINGDBO | POSITION_DETAIL | MISC_INC_RECEIVABLE_SYS | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/systemCurrMiscIncReceivable |
systemCurrMarketValueIncome |
| decimal | 11737 | in_market_value_income_sys | F | HOLDINGDBO | POSITION_DETAIL | MARKET_VALUE_INCOME_SYS | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/systemCurrMarketValueIncome |
systemCurrency |
| CurrencyCode | 11728 | in_sys_currency | S | HOLDINGDBO | POSITION_DETAIL | SYS_CURRENCY | CHAR(3) | N | EagleML/warehouseTransaction/warehousePosition/systemCurrency |
systemCurrExchangeRate |
| decimal | 11729 | in_sys_curr_fx_rate | F | HOLDINGDBO | POSITION_DETAIL | SYS_CURR_FX_RATE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/systemCurrExchangeRate |
systemCurrExchangeRateDate |
| date | 11730 | in_sys_curr_fx_rate_date | S | HOLDINGDBO | POSITION_DETAIL | SYS_CURR_FX_RATE_DATE | DATE | N | EagleML/warehouseTransaction/warehousePosition/systemCurrExchangeRateDate |
totalReturn
|
| decimal
| 2683
| in_total_return
| F
| HOLDINGDBO | POSITION | TOTAL_RETURN | NUMBER(38,12)
| N
| EagleML/warehouseTransaction/warehousePosition/totalReturn
|
HOLDINGDBO | POSITION_DETAIL | TOTAL_RETURN | |||||||||
tipsLtdLocal |
| decimal | 4440 | in_tip_ltd_income_local | F | HOLDINGDBO | POSITION_DETAIL | TIP_LTD_INCOME_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/tipsLtdLocal |
tipLtdIncome |
| decimal | 4445 | in_tip_ltd_income | F | HOLDINGDBO | POSITION_DETAIL | TIP_LTD_INCOME | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/tipLtdIncome |
transactionNumber |
| string | 2362 | in_transaction_number | S | HOLDINGDBO | POSITION_DETAIL | TRANSACTION_NUMBER | CHAR(15) | N | EagleML/warehouseTransaction/warehousePosition/transactionNumber |
totalAccruedIncome |
| decimal | 3765 | in_total_accrued_income | F | HOLDINGDBO | POSITION | TOTAL_ACCRUED_INCOME | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/totalAccruedIncome |
totalAccruedIncomeLocal |
| decimal | 3744 | in_total_accrued_income_local | F | HOLDINGDBO | POSITION | TOTAL_ACCRUED_INCOME_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/totalAccruedIncomeLocal |
totalAssets |
| decimal | 2542 | in_total_assets | F | HOLDINGDBO | POSITION | TOTAL_ASSETS | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/totalAssets |
totalAverageLife |
| decimal | 1206 | in_total_average_life | F | HOLDINGDBO | POSITION | TOTAL_AVERAGE_LIFE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/totalAverageLife |
totalAverageMaturity |
| decimal | 647 | in_total_average_maturity | S | HOLDINGDBO | POSITION | TOTAL_AVERAGE_MATURITY | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/totalAverageMaturity |
totalAveragePrice |
| decimal | 5848 | in_total_average_price | F | HOLDINGDBO | POSITION | TOTAL_AVERAGE_PRICE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/totalAveragePrice |
totalAverageQuality |
| decimal | 9390 | in_total_average_quality | F | HOLDINGDBO | POSITION | TOTAL_AVERAGE_QUALITY | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/totalAverageQuality |
totalBookValue |
| decimal | 8852 | in_total_book_value | F | HOLDINGDBO | POSITION | TOTAL_BOOK_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/totalBookValue |
totalLocalMarketValue |
| decimal | 5840 | in_total_local_market_value | F | HOLDINGDBO | POSITION | TOTAL_LOCAL_MARKET_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/totalLocalMarketValue |
totalManagedMarketValue |
| decimal | 9174 | in_total_managed_market_value | F | HOLDINGDBO | POSITION | TOTAL_MANAGED_MARKET_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/totalManagedMarketValue |
totalMarketValue |
| decimal | 5853 | in_total_market_value | F | HOLDINGDBO | POSITION | TOTAL_MARKET_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/totalMarketValue |
totalMarketValueIncome |
| decimal | 8616 | in_total_market_value_income | F | HOLDINGDBO | POSITION | TOTAL_MARKET_VALUE_INCOME | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/totalMarketValueIncome |
totalParValue |
| decimal | 9670 | in_total_par_value | F | HOLDINGDBO | POSITION | TOTAL_PAR_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/totalParValue |
totalUnrealizedGL |
| decimal | 5430 | in_total_unrealized_g_l | F | HOLDINGDBO | POSITION | TOTAL_UNREALIZED_G_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/totalUnrealizedGL |
totAverageCoupon |
| decimal | 11759 | in_tot_average_coupon | F | HOLDINGDBO | POSITION | TOT_AVERAGE_COUPON | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/totAverageCoupon |
tradedUnearnedInt |
| decimal | 5171 | in_traded_unearned_int | F | HOLDINGDBO | POSITION_COST_DETAIL | TRADED_UNEARNED_INT | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/tradedUnearnedInt |
lotCount |
| decimal | 5868 | in_lot_count | S | HOLDINGDBO | POSITION_DETAIL | LOT_COUNT | NUMBER | N | EagleML/warehouseTransaction/warehousePosition/lotCount |
mgtFeeAccrDaily |
| decimal | 3752 | in_mgt_fee_accr_daily | F | HOLDINGDBO | POSITION_DETAIL | MGT_FEE_ACCR_DAILY | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/mgtFeeAccrDaily |
mgtFeeAccrMtd |
| decimal | 3206 | in_mgt_fee_accr_mtd | F | HOLDINGDBO | POSITION_DETAIL | MGT_FEE_ACCR_MTD | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/mgtFeeAccrMtd |
mgtFeeAccrTotal |
| decimal | 2241 | in_mgt_fee_accr_total | F | HOLDINGDBO | POSITION_DETAIL | MGT_FEE_ACCR_TOTAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/mgtFeeAccrTotal |
netAssets |
| decimal | 2787 | in_net_assets | F | HOLDINGDBO | POSITION | NET_ASSETS | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/netAssets |
notionalAmt |
| decimal | 3779 | in_notional_amt | F | HOLDINGDBO | POSITION_DETAIL | NOTIONAL_AMT | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/notionalAmt |
numberOfIssues |
| decimal | 690 | in_number_of_issues | F | HOLDINGDBO | POSITION | NUMBER_OF_ISSUES | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/numberOfIssues |
oidDeltaBase |
| decimal | 594 | in_oid_delta_base | F | HOLDINGDBO | POSITION_COST_DETAIL | OID_DELTA_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/oidDeltaBase |
oidDeltaLocal |
| decimal | 579 | in_oid_delta_local | F | HOLDINGDBO | POSITION_COST_DETAIL | OID_DELTA_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/oidDeltaLocal |
origAccruedIncomePtd |
| decimal | 1986 | in_orig_accrued_income_ptd | F | HOLDINGDBO | POSITION_COST_DETAIL | ORIG_ACCRUED_INCOME_PTD | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/origAccruedIncomePtd |
origIntReceived |
| decimal | 894 | in_orig_int_received | F | HOLDINGDBO | POSITION_DETAIL | ORIG_INT_RECEIVED | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/origIntReceived |
origPriceSrcInst |
| integer | 1214 | in_orig_price_src_inst | F | HOLDINGDBO | POSITION_DETAIL | ORIG_PRICE_SRC_INST | NUMBER(38) | N | EagleML/warehouseTransaction/warehousePosition/origPriceSrcInst |
origTaxExpenseBase |
| decimal | 854 | in_orig_tax_expense_base | F | HOLDINGDBO | POSITION_COST_DETAIL | ORIG_TAX_EXPENSE_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/origTaxExpenseBase |
posdetailType |
| string | 89 | in_posdetail_type | S | HOLDINGDBO | POSITION_DETAIL | POSDETAIL_TYPE | CHAR(8) | N | EagleML/warehouseTransaction/warehousePosition/posdetailType |
posneg |
| string | 8545 | in_posneg | S | HOLDINGDBO | POSITION_COST_DETAIL | POSNEG | VARCHAR2(1) | N | EagleML/warehouseTransaction/warehousePosition/posneg |
premiumProportionateInd |
| string | 9917 | in_premium_proportionate_ind | S | HOLDINGDBO | POSITION_COST_DETAIL | PREMIUM_PROPORTIONATE_IND | VARCHAR2(1) | N | EagleML/warehouseTransaction/warehousePosition/premiumProportionateInd |
priceCondition |
| string | 4849 | in_price_condition | S | HOLDINGDBO | POSITION_DETAIL | PRICE_CONDITION | VARCHAR2(20) | N | EagleML/warehouseTransaction/warehousePosition/priceCondition |
priceCode |
| string | 1843 | in_price_code | S | HOLDINGDBO | POSITION_DETAIL | PRICE_CODE | CHAR(3) | N | EagleML/warehouseTransaction/warehousePosition/priceCode |
priceLevel |
| integer | 12007 | in_price_level | S | HOLDINGDBO | POSITION_DETAIL | PRICE_LEVEL | NUMBER(38) | N | EagleML/warehouseTransaction/warehousePosition/priceLevel |
priceReturn |
| decimal | 9868 | in_price_return | F | HOLDINGDBO | POSITION_DETAIL | PRICE_RETURN | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/priceReturn |
primPriceDlyVal |
| decimal | 2902 | in_prim_price_dly_val | F | HOLDINGDBO | POSITION | PRIM_PRICE_DLY_VAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/primPriceDlyVal |
primTotDlyVal |
| decimal | 2903 | in_prim_tot_dly_val | F | HOLDINGDBO | POSITION | PRIM_TOT_DLY_VAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/primTotDlyVal |
principalBalance |
| decimal | 165 | in_principal_balance | F | HOLDINGDBO | POSITION_DETAIL | PRINCIPAL_BALANCE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/principalBalance |
principalBalanceLocal |
| decimal | 9629 | in_principal_balance_local | F | HOLDINGDBO | POSITION_DETAIL | PRINCIPAL_BALANCE_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/principalBalanceLocal |
principalReturn |
| decimal | 9869 | in_principal_return | F | HOLDINGDBO | POSITION_DETAIL | PRINCIPAL_RETURN | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/principalReturn |
purYield |
| decimal | 75 | in_pur_yield | F | HOLDINGDBO | POSITION_DETAIL | PUR_YIELD | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/purYield |
realizedPl |
| decimal | 2685 | in_realized_pl | S | HOLDINGDBO | POSITION_DETAIL | REALIZED_PL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/realizedPl |
reclaimAmtLtdBase |
| decimal | 9236 | in_reclaim_amt_ltd_base | F | HOLDINGDBO | POSITION_COST_DETAIL | RECLAIM_AMT_LTD_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/reclaimAmtLtdBase |
reclaimAmtLtdLocal |
| decimal | 9237 | in_reclaim_amt_ltd_local | F | HOLDINGDBO | POSITION_COST_DETAIL | RECLAIM_AMT_LTD_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/reclaimAmtLtdLocal |
reclaimAmtPtdBase |
| decimal | 851 | in_reclaim_amt_ptd_base | F | HOLDINGDBO | POSITION_COST_DETAIL | RECLAIM_AMT_PTD_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/reclaimAmtPtdBase |
reclaimAmtPtdLocal |
| decimal | 852 | in_reclaim_amt_ptd_local | F | HOLDINGDBO | POSITION_COST_DETAIL | RECLAIM_AMT_PTD_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/reclaimAmtPtdLocal |
reclaimTaxReceivDeltaB |
| decimal | 856 | in_reclaim_tax_receiv_delta_b | F | HOLDINGDBO | POSITION_COST_DETAIL | RECLAIM_TAX_RECEIV_DELTA_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/reclaimTaxReceivDeltaB |
reclaimTaxReceivDeltaL |
| decimal | 855 | in_reclaim_tax_receiv_delta_l | F | HOLDINGDBO | POSITION_COST_DETAIL | RECLAIM_TAX_RECEIV_DELTA_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/reclaimTaxReceivDeltaL |
recognizeCalls |
| string | 3939 | in_recognize_calls | S | HOLDINGDBO | POSITION_COST_DETAIL | RECOGNIZE_CALLS | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehousePosition/recognizeCalls |
recognizePuts |
| string | 3937 | in_recognize_puts | S | HOLDINGDBO | POSITION_COST_DETAIL | RECOGNIZE_PUTS | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehousePosition/recognizePuts |
recShareParValue |
| decimal | 122 | in_rec_share_par_value | F | HOLDINGDBO | POSITION_DETAIL | REC_SHARE_PAR_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/recShareParValue |
securityExpenses |
| decimal | 5806 | in_security_expenses | S | HOLDINGDBO | POSITION_DETAIL | SECURITY_EXPENSES | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/securityExpenses |
strategyId |
| string | 2514 | in_strategy_id | S | HOLDINGDBO | POSITION_DETAIL | STRATEGY_ID | VARCHAR2(20) | N | EagleML/warehouseTransaction/warehousePosition/strategyId |
shareParValue |
| decimal | 163 | in_share_par_value | F | HOLDINGDBO | POSITION_DETAIL | SHARE_PAR_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/shareParValue |
securityIncome |
| decimal | 475 | in_security_income | F | HOLDINGDBO | POSITION_DETAIL | SECURITY_INCOME | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/securityIncome |
settleDatePositionCost |
| decimal | 479 | in_settlement_date_position_cost | F | HOLDINGDBO | POSITION_DETAIL | SETTLEMENT_DATE_POSITION_COST | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/settleDatePositionCost |
settledLocGaapCostValue |
| decimal | 11046 | in_settled_local_gaap_cost_value | F | HOLDINGDBO | POSITION_COST_DETAIL | SETTLED_LOCAL_GAAP_COST_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/settledLocGaapCostValue |
settledLocGaapUnitCost |
| decimal | 11044 | in_settled_local_gaap_unit_cost | F | HOLDINGDBO | POSITION_COST_DETAIL | SETTLED_LOCAL_GAAP_UNIT_COST | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/settledLocGaapUnitCost |
starDataFilter |
| integer | 10559 | in_star_data_filter | S | HOLDINGDBO | POSITION | STAR_DATA_FILTER | NUMBER(38) | N | EagleML/warehouseTransaction/warehousePosition/starDataFilter |
starMarketValue |
| decimal | 10789 | in_star_market_value | F | HOLDINGDBO | POSITION_DETAIL | STAR_MARKET_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/starMarketValue |
starMarketValueLocal |
| decimal | 10787 | in_star_market_value_local | F | HOLDINGDBO | POSITION_DETAIL | STAR_MARKET_VALUE_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/starMarketValueLocal |
starQuantity |
| decimal | 10788 | in_star_quantity | F | HOLDINGDBO | POSITION_DETAIL | STAR_QUANTITY | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/starQuantity |
subportStatus |
| string | 1640 | in_subport_status | S | HOLDINGDBO | POSITION | SUBPORT_STATUS | CHAR(4) | N | EagleML/warehouseTransaction/warehousePosition/subportStatus |
taxAccountingMethod |
| string | 3912 | in_tax_accounting_method | S | HOLDINGDBO | POSITION_COST_DETAIL | TAX_ACCOUNTING_METHOD | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehousePosition/taxAccountingMethod |
taxExpenseLocal |
| decimal | 853 | in_tax_expense_local | F | HOLDINGDBO | POSITION_COST_DETAIL | TAX_EXPENSE_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/taxExpenseLocal |
taxExpenseLtd |
| decimal | 9238 | in_tax_expense_ltd | F | HOLDINGDBO | POSITION_COST_DETAIL | TAX_EXPENSE_LTD | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/taxExpenseLtd |
taxExpenseLtdLocal |
| decimal | 9239 | in_tax_expense_ltd_local | F | HOLDINGDBO | POSITION_COST_DETAIL | TAX_EXPENSE_LTD_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/taxExpenseLtdLocal |
taxReclaimRate |
| decimal | 1296 | in_tax_reclaim_rate | F | HOLDINGDBO | POSITION_COST_DETAIL | TAX_RECLAIM_RATE | NUMBER(38,6) | N | EagleML/warehouseTransaction/warehousePosition/taxReclaimRate |
taxWithholdingRate |
| decimal | 1295 | in_tax_withholding_rate | F | HOLDINGDBO | POSITION_COST_DETAIL | TAX_WITHHOLDING_RATE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/taxWithholdingRate |
tipsDeltaBase |
| decimal | 4449 | in_tips_delta_base | F | HOLDINGDBO | POSITION_COST_DETAIL | TIPS_DELTA_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/tipsDeltaBase |
tipsDeltaLocal |
| decimal | 4444 | in_tips_delta_local | F | HOLDINGDBO | POSITION_COST_DETAIL | TIPS_DELTA_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/tipsDeltaLocal |
tipsIndexRatio |
| decimal | 10080 | in_tips_index_ratio | F | HOLDINGDBO | POSITION_COST_DETAIL | TIPS_INDEX_RATIO | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/tipsIndexRatio |
uncCurCostAvgB |
| decimal | 2827 | in_unc_cur_cost_avg_b | F | HOLDINGDBO | POSITION_COST_DETAIL | UNC_CUR_COST_AVG_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/uncCurCostAvgB |
uncCurCostAvgL |
| decimal | 2826 | in_unc_cur_cost_avg_l | F | HOLDINGDBO | POSITION_COST_DETAIL | UNC_CUR_COST_AVG_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/uncCurCostAvgL |
uncPosQty |
| decimal | 2890 | in_unc_pos_qty | F | HOLDINGDBO | POSITION_COST_DETAIL | UNC_POS_QTY | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/uncPosQty |
uncUnitCostAvgB |
| decimal | 2823 | in_unc_unit_cost_avg_b | F | HOLDINGDBO | POSITION_COST_DETAIL | UNC_UNIT_COST_AVG_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/uncUnitCostAvgB |
uncUnitCostAvgL |
| decimal | 2822 | in_unc_unit_cost_avg_l | F | HOLDINGDBO | POSITION_COST_DETAIL | UNC_UNIT_COST_AVG_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/uncUnitCostAvgL |
unrealizedGL |
| decimal | 524 | in_unrealized_g_l | F | HOLDINGDBO | POSITION_DETAIL | UNREALIZED_G_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/unrealizedGL |
userGroup1 |
| string | 11668 | in_user_group1 | S | HOLDINGDBO | POSITION_DETAIL | USER_GROUP1 | CHAR(8) | N | EagleML/warehouseTransaction/warehousePosition/userGroup1 |
userGroup2 |
| string | 11669 | in_user_group2 | S | HOLDINGDBO | POSITION_DETAIL | USER_GROUP2 | CHAR(8) | N | EagleML/warehouseTransaction/warehousePosition/userGroup2 |
userGroup3 |
| string | 1461 | in_user_group3 | S | HOLDINGDBO | POSITION_DETAIL | USER_GROUP3 | CHAR(8) | N | EagleML/warehouseTransaction/warehousePosition/userGroup3 |
userGroup4 |
| string | 1472 | in_user_group4 | S | HOLDINGDBO | POSITION_DETAIL | USER_GROUP4 | CHAR(35) | N | EagleML/warehouseTransaction/warehousePosition/userGroup4 |
userDate1 |
| date | 1320 | in_user_date1 | S | HOLDINGDBO | POSITION_DETAIL | USER_DATE1 | DATE | N | EagleML/warehouseTransaction/warehousePosition/userDate1 |
userDate2 |
| date | 1321 | in_user_date2 | S | HOLDINGDBO | POSITION_DETAIL | USER_DATE2 | DATE | N | EagleML/warehouseTransaction/warehousePosition/userDate2 |
userFloat21 |
| decimal | 9828 | in_user_float21 | F | HOLDINGDBO | POSITION_DETAIL | USER_FLOAT21 | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/userFloat21 |
userFloat22 |
| decimal | 9829 | in_user_float22 | F | HOLDINGDBO | POSITION_DETAIL | USER_FLOAT22 | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/userFloat22 |
wgtAvgMatDate |
| date | 38 | in_wgt_avg_mat_date | S | HOLDINGDBO | POSITION_DETAIL | WGT_AVG_MAT_DATE | DATE | N | EagleML/warehouseTransaction/warehousePosition/wgtAvgMatDate |
yieldType |
| string | 1113 | in_yield_type | S | HOLDINGDBO | POSITION_COST_DETAIL | YIELD_TYPE | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehousePosition/yieldType |
price |
| decimal | 481 | in_price | F | HOLDINGDBO | POSITION_DETAIL | PRICE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/price |
smInactiveFlag |
| YesNoOptionEnum | 11043 | in_sm_inactive_flag | S | SECURITYDBO | SECURITY_MASTER | INACTIVE_FLAG | VARCHAR2(3) | N | EagleML/warehouseTransaction/warehousePosition/smInactiveFlag |
aiaNetB |
| decimal | 11275 | in_aia_net_b | F | HOLDINGDBO | POSITION_COST_DETAIL | AIA_NET_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/aiaNetB |
aiaNetL |
| decimal | 11149 | in_aia_net_l | F | HOLDINGDBO | POSITION_COST_DETAIL | AIA_NET_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/aiaNetL |
buySellFlag |
| normalizedString | 3702 | in_buy_sell_flag | S | HOLDINGDBO | POSITION_DETAIL | BUY_SELL_FLAG | VARCHAR2(4) | N | EagleML/warehouseTransaction/warehousePosition/buySellFlag |
bookValue |
| decimal | 4602 | in_book_value | F | HOLDINGDBO | POSITION_DETAIL | BOOK_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/bookValue |
bookValueLocal |
| decimal | 4601 | in_book_value_local | F | HOLDINGDBO | POSITION_DETAIL | BOOK_VALUE_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/bookValueLocal |
cpNetB |
| decimal | 11245 | in_cp_net_b | F | HOLDINGDBO | POSITION_COST_DETAIL | CP_NET_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/cpNetB |
cpNetL |
| decimal | 11119 | in_cp_net_l | F | HOLDINGDBO | POSITION_COST_DETAIL | CP_NET_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/cpNetL |
creditLossB |
| decimal | 2784 | in_credit_loss_b | F | HOLDINGDBO | POSITION_COST_DETAIL | CREDIT_LOSS_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/creditLossB |
creditLossL |
| decimal | 2783 | in_credit_loss_l | F | HOLDINGDBO | POSITION_COST_DETAIL | CREDIT_LOSS_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/creditLossL |
costBasisType |
| string | 24 | in_cost_basis_type | S | HOLDINGDBO | POSITION_COST_DETAIL | COST_BASIS_TYPE | VARCHAR2(2) | N | EagleML/warehouseTransaction/warehousePosition/costBasisType |
futureFeeNetB |
| decimal | 11366 | in_future_fee_net_b | F | HOLDINGDBO | POSITION_COST_DETAIL | FUTURE_FEE_NET_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/futureFeeNetB |
futureFeeNetL |
| decimal | 11365 | in_future_fee_net_l | F | HOLDINGDBO | POSITION_COST_DETAIL | FUTURE_FEE_NET_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/futureFeeNetL |
impairmentLtdBase |
| decimal | 2701 | in_impairment_ltd_base | F | HOLDINGDBO | POSITION_COST_DETAIL | IMPAIRMENT_LTD_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/impairmentLtdBase |
impairmentLtdLocal |
| decimal | 2700 | in_impairment_ltd_local | F | HOLDINGDBO | POSITION_COST_DETAIL | IMPAIRMENT_LTD_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/impairmentLtdLocal |
mbaNetB |
| decimal | 11251 | in_mba_net_b | F | HOLDINGDBO | POSITION_COST_DETAIL | MBA_NET_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/mbaNetB |
mbaNetL |
| decimal | 11125 | in_mba_net_l | F | HOLDINGDBO | POSITION_COST_DETAIL | MBA_NET_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/mbaNetL |
naiaNetB |
| decimal | 11343 | in_naia_net_b | F | HOLDINGDBO | POSITION_COST_DETAIL | NAIA_NET_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/naiaNetB |
naiaNetL |
| decimal | 11342 | in_naia_net_l | F | HOLDINGDBO | POSITION_COST_DETAIL | NAIA_NET_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/naiaNetL |
nonCreditLossB |
| decimal | 2705 | in_non_credit_loss_b | F | HOLDINGDBO | POSITION_COST_DETAIL | NON_CREDIT_LOSS_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/nonCreditLossB |
nonCreditLossL |
| decimal | 2704 | in_non_credit_loss_l | F | HOLDINGDBO | POSITION_COST_DETAIL | NON_CREDIT_LOSS_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/nonCreditLossL |
fxImpairmentRate |
| decimal | 15708 | in_fx_impairment | F | HOLDINGDBO | POSITION_COST_DETAIL | FX_IMPAIRMENT | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/fxImpairmentRate |
amortizedAtDisposalLtdLocal |
| decimal | 15711 | in_amort_at_disp_ltd_l | F | HOLDINGDBO | POSITION_COST_DETAIL | AMORT_AT_DISP_LTD_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/amortizedAtDisposalLtdLocal |
amortizedAtDisposalLtdBase |
| decimal | 15710 | in_amort_at_disp_ltd_b | F | HOLDINGDBO | POSITION_COST_DETAIL | AMORT_AT_DISP_LTD_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/amortizedAtDisposalLtdBase |
exUnearnedInterestBase |
| decimal | 15712 | in_ex_unearned_int_b | F | HOLDINGDBO | POSITION_COST_DETAIL | EX_UNEARNED_INT_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/exUnearnedInterestBase |
exUnearnedReclaimBase |
| decimal | 15713 | in_ex_unearned_reclaim_b | F | HOLDINGDBO | POSITION_COST_DETAIL | EX_UNEARNED_RECLAIM_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/exUnearnedReclaimBase |
exUnearnedWithholdingBase |
| decimal | 15714 | in_ex_unearned_withholding_b | F | HOLDINGDBO | POSITION_COST_DETAIL | EX_UNEARNED_WITHHOLDING_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/exUnearnedWithholdingBase |
exUnearnedInterestPtdLocal |
| decimal | 15715 | in_ex_unearned_int_ptd_l | F | HOLDINGDBO | POSITION_COST_DETAIL | EX_UNEARNED_INT_PTD_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/exUnearnedInterestPtdLocal |
originalExUnearnedInterestPtdBase |
| decimal | 15716 | in_orig_ex_unearned_int_ptd_b | F | HOLDINGDBO | POSITION_COST_DETAIL | ORIG_EX_UNEARNED_INT_PTD_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/originalExUnearnedInterestPtdBase |
unaccruedReclaimLocal |
| decimal | 15717 | in_unaccrued_reclaim_l | F | HOLDINGDBO | POSITION_COST_DETAIL | UNACCRUED_RECLAIM_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/unaccruedReclaimLocal |
originalUnaccruedReclaimBase |
| decimal | 15718 | in_orig_unaccrued_reclaim_b | F | HOLDINGDBO | POSITION_COST_DETAIL | ORIG_UNACCRUED_RECLAIM_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/originalUnaccruedReclaimBase |
unaccruedWithholdingLocal |
| decimal | 15719 | in_unaccrued_withholding_l | F | HOLDINGDBO | POSITION_COST_DETAIL | UNACCRUED_WITHHOLDING_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/unaccruedWithholdingLocal |
originalUnaccruedWithholdingBase |
| decimal | 15720 | in_orig_unaccrued_wh_b | F | HOLDINGDBO | POSITION_COST_DETAIL | ORIG_UNACCRUED_WITHHOLDING_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/originalUnaccruedWithholdingBase |
undistributedInvestmentIncomeLocal |
| decimal | 15721 | in_undist_inv_inc_l | F | HOLDINGDBO | POSITION_COST_DETAIL | UNDIST_INV_INC_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/undistributedInvestmentIncomeLocal |
undistributedInvestmentIncomeBase |
| decimal | 15722 | in_undist_inv_inc_b | F | HOLDINGDBO | POSITION_COST_DETAIL | UNDIST_INV_INC_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/undistributedInvestmentIncomeBase |
distributedInvestmentIncomeLocal |
| decimal | 15723 | in_dist_inv_inc_l | F | HOLDINGDBO | POSITION_COST_DETAIL | DIST_INV_INC_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/distributedInvestmentIncomeLocal |
distributedInvestmentIncomeBase |
| decimal | 15724 | in_dist_inv_inc_b | F | HOLDINGDBO | POSITION_COST_DETAIL | DIST_INV_INC_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/distributedInvestmentIncomeBase |
equityMethodAcctTreatmentMethod |
| string | 16313 | in_ema_treatment | S | HOLDINGDBO | POSITION_COST_DETAIL | EMA_TREATMENT | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehousePosition/equityMethodAcctTreatmentMethod |
ownershipPercentage |
| decimal | 15727 | in_ownership_percentage | F | HOLDINGDBO | POSITION_COST_DETAIL | OWNERSHIP_PERCENTAGE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/ownershipPercentage |
commitmentAmount |
| decimal | 15729 | in_commitment | F | HOLDINGDBO | POSITION_COST_DETAIL | COMMITMENT | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/commitmentAmount |
equityMethodAcctCostIndicator |
| string | 16312 | in_ema_cost_flag | F | HOLDINGDBO | POSITION_COST_DETAIL | EMA_COST_FLAG | VARCHAR2(5) | N | EagleML/warehouseTransaction/warehousePosition/equityMethodAcctCostIndicator |
expectedCreditLossAmountLocal |
| decimal | 15728 | in_ecl_local | F | HOLDINGDBO | POSITION_COST_DETAIL | ECL_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/expectedCreditLossAmountLocal |
expectedCreditLossAmountBase |
| decimal | 15730 | in_ecl_base | F | HOLDINGDBO | POSITION_COST_DETAIL | ECL_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/expectedCreditLossAmountBase |
expectedCreditLossFxUrgl |
| decimal | 15733 | in_ecl_fx_urgl | F | HOLDINGDBO | POSITION_COST_DETAIL | ECL_FX_URGL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/expectedCreditLossFxUrgl |
expectedCreditLossPreviousAmountLocal |
| decimal | 15734 | in_ecl_prev_local | F | HOLDINGDBO | POSITION_COST_DETAIL | ECL_PREV_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/expectedCreditLossPreviousAmountLocal |
expectedCreditLossPreviousAmountBase |
| decimal | 15735 | in_ecl_prev_base | F | HOLDINGDBO | POSITION_COST_DETAIL | ECL_PREV_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/expectedCreditLossPreviousAmountBase |
expectedCreditLossStageAmount |
| decimal | 15736 | in_ecl_stage | F | HOLDINGDBO | POSITION_COST_DETAIL | ECL_STAGE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/expectedCreditLossStageAmount |
expectedCreditLossPreviousStageAmount |
| decimal | 15737 | in_ecl_prev_stage | F | HOLDINGDBO | POSITION_COST_DETAIL | ECL_PREV_STAGE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/ |
totalReturnResetReceivableLocal |
| decimal | 18328 | in_trrreset_rcvbl_l | F | HOLDINGDBO | POSITION_COST_DETAIL | TRRRESET_RCVBL_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/totalReturnResetReceivableLocal |
totalReturnResetReceivableBase |
| decimal | 18329 | in_trrreset_rcvbl_b | F | HOLDINGDBO | POSITION_COST_DETAIL | TRRRESET_RCVBL_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/totalReturnResetReceivableBase |
totalReturnResetReceivableSys |
| decimal | 18330 | in_trrreset_rcvbl_s | F | HOLDINGDBO | POSITION_COST_DETAIL | TRRRESET_RCVBL_S | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/totalReturnResetReceivableSys |
originalAccruedIncomeBase |
| decimal | 18342 | in_orig_accrued_income_base |
| HOLDINGDBO | POSITION_COST_DETAIL | ORIG_ACCRUED_INCOME_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/originalAccruedIncomeBase |
taxPayableLocal |
| decimal | 18343 | in_tax_payable_local |
| HOLDINGDBO | POSITION_COST_DETAIL | TAX_PAYABLE_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/taxPayableLocal |
taxPayableBase |
| decimal | 18344 | in_tax_payable_base |
| HOLDINGDBO | POSITION_COST_DETAIL | TAX_PAYABLE_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/taxPayableBase |
taxPayableSys |
| decimal | 18345 | in_tax_payable_sys |
| HOLDINGDBO | POSITION_COST_DETAIL | TAX_PAYABLE_SYS | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/taxPayableSys |
originalTaxPayable |
| decimal | 18346 | in_orig_tax_payable |
| HOLDINGDBO | POSITION_COST_DETAIL | ORIG_TAX_PAYABLE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/originalTaxPayable |
adjustedShares |
| decimal | 4972 | in_adjusted_shares | F | HOLDINGDBO | POSITION_DETAIL | ADJUSTED_SHARES | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/adjustedShares |
baseGaapMarketValue |
| decimal | 9281 | in_base_gaap_market_value | F | HOLDINGDBO | POSITION_COST_DETAIL | BASE_GAAP_MARKET_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/baseGaapMarketValue |
baseStatMarketValue |
| decimal | 9290 | in_base_stat_market_value | F | HOLDINGDBO | POSITION_COST_DETAIL | BASE_STAT_MARKET_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/baseStatMarketValue |
cashEquivalents |
| decimal | 64 | in_cash_equivalents | F | HOLDINGDBO | POSITION_DETAIL | CASH_EQUIVALENTS | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/cashEquivalents |
cirBrkFees |
| decimal | 255 | in_cir_brk_fees | F | HOLDINGDBO | POSITION_DETAIL | CIR_BRK_FEES | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/cirBrkFees |
closeOidIncome |
| decimal | 5686 | in_cls_oid_income | F | HOLDINGDBO | POSITION_COST_DETAIL | CLS_OID_INCOME | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/closeOidIncome |
closeOidIncomeLocal |
| decimal | 5685 | in_cls_oid_income_local | F | HOLDINGDBO | POSITION_COST_DETAIL | CLS_OID_INCOME_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/closeOidIncomeLocal |
closeTipsIncomeLocal |
| decimal | 4538 | in_cls_tips_income_local | F | HOLDINGDBO | POSITION_DETAIL | CLS_TIPS_INCOME_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/closeTipsIncomeLocal |
closeTipsIncome |
| decimal | 4539 | in_cls_tips_income | F | HOLDINGDBO | POSITION_DETAIL | CLS_TIPS_INCOME | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/closeTipsIncome |
deferredIncomeTotalPtdB |
| decimal | 7980 | in_deferred_income_total_ptd_b | F | HOLDINGDBO | POSITION_COST_DETAIL | DEFERRED_INCOME_TOTAL_PTD_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/deferredIncomeTotalPtdB |
deferredIncomeTotalPtdL |
| decimal | 7979 | in_deferred_income_total_ptd_l | F | HOLDINGDBO | POSITION_COST_DETAIL | DEFERRED_INCOME_TOTAL_PTD_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/deferredIncomeTotalPtdL |
deltaAdjQty |
| decimal | 4987 | in_delta_adj_qty | F | HOLDINGDBO | POSITION_COST_DETAIL | DELTA_ADJ_QTY | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/deltaAdjQty |
dlta |
| decimal | 1090 | in_dlta | F | HOLDINGDBO | POSITION_COST_DETAIL | DLTA | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/dlta |
expoPrice |
| decimal | 9164 | in_expo_price | F | HOLDINGDBO | POSITION_COST_DETAIL | EXPO_PRICE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/expoPrice |
earnThruDate
|
| date
| 4763
| in_earn_thru_date
| S
| HOLDINGDBO | POSITION_COST_DETAIL | EARN_THRU_DATE | DATE
| N
| EagleML/warehouseTransaction/warehousePosition/earnThruDate
|
HOLDINGDBO | POSITION_DETAIL | EARN_THRU_DATE | |||||||||
execBrkFees |
| decimal | 266 | in_exec_brk_fees | F | HOLDINGDBO | POSITION_DETAIL | EXEC_BRK_FEES | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/execBrkFees |
fedTaxCostValue |
| decimal | 3878 | in_fed_tax_cost_value | F | HOLDINGDBO | POSITION_DETAIL | FED_TAX_COST_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/fedTaxCostValue |
gaapUnitBookValue |
| decimal | 3130 | in_gaap_unit_book_value | F | HOLDINGDBO | POSITION_COST_DETAIL | GAAP_UNIT_BOOK_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/gaapUnitBookValue |
gaapUnitCost |
| decimal | 125 | in_gaap_unit_cost | F | HOLDINGDBO | POSITION_COST_DETAIL | GAAP_UNIT_COST | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/gaapUnitCost |
gaapBookValue |
| decimal | 9279 | in_gaap_book_value | F | HOLDINGDBO | POSITION_COST_DETAIL | GAAP_BOOK_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/gaapBookValue |
gaapCostValue |
| decimal | 9277 | in_gaap_cost_value | F | HOLDINGDBO | POSITION_COST_DETAIL | GAAP_COST_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/gaapCostValue |
hedgedCusip |
| string | 606 | in_hedge_cusip | S | HOLDINGDBO | POSITION_DETAIL | HEDGE_CUSIP | VARCHAR2(12) | N | EagleML/warehouseTransaction/warehousePosition/hedgedCusip |
hedgeTrading |
| string | 656 | in_hedge_trading | S | HOLDINGDBO | POSITION_DETAIL | HEDGE_TRADING | VARCHAR2(10) | N | EagleML/warehouseTransaction/warehousePosition/hedgeTrading |
interestEarned |
| decimal | 465 | in_interest_earned | F | HOLDINGDBO | POSITION_DETAIL | INTEREST_EARNED | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/interestEarned |
lastSettlementDate |
| date | 1223 | in_last_settlement_date | S | HOLDINGDBO | POSITION_DETAIL | LAST_SETTLEMENT_DATE | DATE | N | EagleML/warehouseTransaction/warehousePosition/lastSettlementDate |
localGaapCostValue |
| decimal | 9278 | in_local_gaap_cost_value | F | HOLDINGDBO | POSITION_COST_DETAIL | LOCAL_GAAP_COST_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/localGaapCostValue |
localGaapUnitCost |
| decimal | 124 | in_local_gaap_unit_cost | F | HOLDINGDBO | POSITION_COST_DETAIL | LOCAL_GAAP_UNIT_COST | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/localGaapUnitCost |
localGaapBookValue |
| decimal | 9280 | in_local_gaap_book_value | F | HOLDINGDBO | POSITION_COST_DETAIL | LOCAL_GAAP_BOOK_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/localGaapBookValue |
localGaapUnitBookValue |
| decimal | 9309 | in_local_gaap_unit_book_value | F | HOLDINGDBO | POSITION_COST_DETAIL | LOCAL_GAAP_UNIT_BOOK_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/localGaapUnitBookValue |
localGaapMarketValue |
| decimal | 9314 | in_local_gaap_market_value | F | HOLDINGDBO | POSITION_COST_DETAIL | LOCAL_GAAP_MARKET_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/localGaapMarketValue |
localTaxUnitBookValue |
| decimal | 2745 | in_local_tax_unit_book_value | F | HOLDINGDBO | POSITION_COST_DETAIL | LOCAL_TAX_UNIT_BOOK_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/localTaxUnitBookValue |
localStatUnitCost |
| decimal | 9642 | in_local_stat_unit_cost | F | HOLDINGDBO | POSITION_COST_DETAIL | LOCAL_STAT_UNIT_COST | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/localStatUnitCost |
localStatBookValue |
| decimal | 9292 | in_local_stat_book_value | F | HOLDINGDBO | POSITION_COST_DETAIL | LOCAL_STAT_BOOK_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/localStatBookValue |
localStatCostValue |
| decimal | 9641 | in_local_stat_cost_value | F | HOLDINGDBO | POSITION_COST_DETAIL | LOCAL_STAT_COST_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/localStatCostValue |
localStatMarketValue |
| decimal | 9318 | in_local_stat_market_value | F | HOLDINGDBO | POSITION_COST_DETAIL | LOCAL_STAT_MARKET_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/localStatMarketValue |
localStatUnitBookValue |
| decimal | 9293 | in_local_stat_unit_book_value | F | HOLDINGDBO | POSITION_COST_DETAIL | LOCAL_STAT_UNIT_BOOK_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/localStatUnitBookValue |
localTaxBookValue |
| decimal | 2744 | in_local_tax_book_value | F | HOLDINGDBO | POSITION_COST_DETAIL | LOCAL_TAX_BOOK_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/localTaxBookValue |
localTaxCostValue
|
| decimal
| 3879
| in_local_tax_cost_value
| F
| HOLDINGDBO | POSITION_COST_DETAIL | LOCAL_TAX_COST_VALUE | NUMBER(38,12)
| N
| EagleML/warehouseTransaction/warehousePosition/localTaxCostValue
|
HOLDINGDBO | POSITION_DETAIL | LOCAL_TAX_COST_VALUE | |||||||||
localTaxUnitCost |
| decimal | 3874 | in_local_tax_unit_cost | F | HOLDINGDBO | POSITION_COST_DETAIL | LOCAL_TAX_UNIT_COST | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/localTaxUnitCost |
nonCreditLossAmortLtdB |
| decimal | 2835 | in_non_credit_loss_amort_ltd_b | F | HOLDINGDBO | POSITION_COST_DETAIL | NON_CREDIT_LOSS_AMORT_LTD_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/nonCreditLossAmortLtdB |
nonCreditLossAmortLtdL |
| decimal | 2834 | in_non_credit_loss_amort_ltd_l | F | HOLDINGDBO | POSITION_COST_DETAIL | NON_CREDIT_LOSS_AMORT_LTD_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/nonCreditLossAmortLtdL |
oidPtdBase |
| decimal | 593 | in_oid_ptd_base | F | HOLDINGDBO | POSITION_COST_DETAIL | OID_PTD_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/oidPtdBase |
oidPtdLocal |
| decimal | 578 | in_oid_ptd_local | F | HOLDINGDBO | POSITION_COST_DETAIL | OID_PTD_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/oidPtdLocal |
oidLtdIncomeLocal |
| decimal | 575 | in_oid_ltd_income_local | F | HOLDINGDBO | POSITION_COST_DETAIL | OID_LTD_INCOME_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/oidLtdIncomeLocal |
oidLtdIncomeBase |
| decimal | 590 | in_oid_ltd_income | F | HOLDINGDBO | POSITION_COST_DETAIL | OID_LTD_INCOME | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/oidLtdIncomeBase |
openMktPrice |
| decimal | 160 | in_open_mkt_price | F | HOLDINGDBO | POSITION_COST_DETAIL | OPEN_MKT_PRICE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/openMktPrice |
origAccrPtdBase |
| decimal | 9630 | in_orig_accr_ptd_base | F | HOLDINGDBO | POSITION_COST_DETAIL | ORIG_ACCR_PTD_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/origAccrPtdBase |
origSoldInterestBase |
| decimal | 9631 | in_orig_sold_interest_base | F | HOLDINGDBO | POSITION_COST_DETAIL | ORIG_SOLD_INTEREST_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/origSoldInterestBase |
origTradedInterestBase |
| decimal | 9632 | in_orig_traded_interest_base | F | HOLDINGDBO | POSITION_COST_DETAIL | ORIG_TRADED_INTEREST_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/origTradedInterestBase |
originalCostAmount |
| decimal | 162 | in_original_cost_amount | F | HOLDINGDBO | POSITION_DETAIL | ORIGINAL_COST_AMOUNT | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/originalCostAmount |
payEpAccrued |
| decimal | 2881 | in_pay_ep_accrued | F | HOLDINGDBO | POSITION_DETAIL | PAY_EP_ACCRUED | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/payEpAccrued |
payRecInd |
| string | 4590 | in_pay_rec_ind | S | HOLDINGDBO | POSITION_DETAIL | PAY_REC_IND | VARCHAR2(1) | N | EagleML/warehouseTransaction/warehousePosition/payRecInd |
posnFullyEarned |
| string | 8383 | in_posn_fully_earned | S | HOLDINGDBO | POSITION_COST_DETAIL | POSN_FULLY_EARNED | VARCHAR2(1) | N | EagleML/warehouseTransaction/warehousePosition/posnFullyEarned |
purchasePrincipalBase |
| decimal | 256 | in_purchase_principal_base | F | HOLDINGDBO | POSITION_DETAIL | PURCHASE_PRINCIPAL_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/purchasePrincipalBase |
purchasePrincipalLocal |
| decimal | 254 | in_purchase_principal_local | F | HOLDINGDBO | POSITION_DETAIL | PURCHASE_PRINCIPAL_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/purchasePrincipalLocal |
pv01total |
| decimal | 5839 | in_pv01total | F | HOLDINGDBO | POSITION_DETAIL | PV01TOTAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/pv01total |
preTaxAdjYld |
| decimal | 5767 | in_pre_tax_adj_yld | F | HOLDINGDBO | POSITION_DETAIL | PRE_TAX_ADJ_YLD | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/preTaxAdjYld |
recEpAccrued |
| decimal | 2880 | in_rec_ep_accrued | F | HOLDINGDBO | POSITION_DETAIL | REC_EP_ACCRUED | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/recEpAccrued |
statCostValue |
| decimal | 11985 |
|
| HOLDINGDBO | POSITION_COST_DETAIL | STAT_COST_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/statCostValue |
soldInterestBase |
| decimal | 8953 | in_interest_sold_base | F | HOLDINGDBO | POSITION_DETAIL | INTEREST_SOLD_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/soldInterestBase |
scrubFlag |
| YesNoOptionEnum | 4569 | in_scrub_flag | S | HOLDINGDBO | POSITION_DETAIL | SCRUB_FLAG | CHAR(2) | N | EagleML/warehouseTransaction/warehousePosition/scrubFlag |
sourceInternalAssetId |
| string | 10829 | in_source_internal_asset_id | S | HOLDINGDBO | POSITION_DETAIL | SOURCE_INTERNAL_ASSET_ID | VARCHAR2(30) | N | EagleML/warehouseTransaction/warehousePosition/sourceInternalAssetId |
statBookValue |
| decimal | 9289 | in_stat_book_value | F | HOLDINGDBO | POSITION_COST_DETAIL | STAT_BOOK_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/statBookValue |
statUnitBookValue |
| decimal | 9308 | in_stat_unit_book_value | F | HOLDINGDBO | POSITION_COST_DETAIL | STAT_UNIT_BOOK_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/statUnitBookValue |
soldInterestLocal |
| decimal | 8952 | in_interest_sold | F | HOLDINGDBO | POSITION_DETAIL | INTEREST_SOLD | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/soldInterestLocal |
statUnitCost |
| decimal | 9291 | in_stat_unit_cost | F | HOLDINGDBO | POSITION_COST_DETAIL | STAT_UNIT_COST | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/statUnitCost |
stateCostValue |
| decimal | 9288 | in_state_cost_value | F | HOLDINGDBO | POSITION_DETAIL | STATE_COST_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/stateCostValue |
swapAccrMethod |
| string | 1184 | in_swap_accr_method | S | HOLDINGDBO | POSITION_DETAIL | SWAP_ACCR_METHOD | VARCHAR2(1) | N | EagleML/warehouseTransaction/warehousePosition/swapAccrMethod |
totalUnrealizedGainLossLocal |
| decimal | 489 | in_local_unrealized_gl | F | HOLDINGDBO | POSITION_DETAIL | LOCAL_UNREALIZED_GL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/totalUnrealizedGainLossLocal |
totalUnrealizedGainLossBase |
| decimal | 492 | in_base_unrealized_gl | F | HOLDINGDBO | POSITION_DETAIL | BASE_UNREALIZED_GL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/totalUnrealizedGainLossBase |
tipsPtdBase |
| decimal | 4447 | in_tips_ptd_base | F | HOLDINGDBO | POSITION_COST_DETAIL | TIPS_PTD_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/tipsPtdBase |
tipsPtdLocal |
| decimal | 4442 | in_tips_ptd_local | F | HOLDINGDBO | POSITION_COST_DETAIL | TIPS_PTD_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/tipsPtdLocal |
taxBookValue |
| decimal | 3881 | in_tax_book_value | F | HOLDINGDBO | POSITION_COST_DETAIL | TAX_BOOK_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/taxBookValue |
taxCostValue |
| decimal | 2726 | in_tax_cost_value | F | HOLDINGDBO | POSITION_COST_DETAIL | TAX_COST_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/taxCostValue |
taxUnitBookValue |
| decimal | 2727 | in_tax_unit_book_value | F | HOLDINGDBO | POSITION_COST_DETAIL | TAX_UNIT_BOOK_VALUE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/taxUnitBookValue |
taxUnitCost |
| decimal | 9311 | in_tax_unit_cost | F | HOLDINGDBO | POSITION_COST_DETAIL | TAX_UNIT_COST | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/taxUnitCost |
tradeFxRate |
| decimal | 87 | in_trade_fx_rate | F | HOLDINGDBO | POSITION_DETAIL | TRADE_FX_RATE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/tradeFxRate |
undPrice |
| decimal | 9163 | in_und_price | F | HOLDINGDBO | POSITION_COST_DETAIL | UND_PRICE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/undPrice |
uniqueAssetFlag |
| YesNoOptionEnum | 4950 | in_unique_asset_flag | S | HOLDINGDBO | POSITION_DETAIL | UNIQUE_ASSET_FLAG | CHAR(8) | N | EagleML/warehouseTransaction/warehousePosition/uniqueAssetFlag |
positionId |
| integer |
|
|
| HOLDINGDBO | POSITION | POSITION_ID | NUMBER | Y | EagleML/warehouseTransaction/warehousePosition/positionId |
positionDetailId |
| integer |
|
|
| HOLDINGDBO | POSITION_DETAIL | POSITION_DETAIL_ID | NUMBER | Y | EagleML/warehouseTransaction/warehousePosition/positionDetailId |
adjustedPrice |
| decimal | 10814 | in_adjusted_price |
| HOLDINGDBO | POSITION_DETAIL | ADJUSTED_PRICE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/adjustedPrice |
processingIlbLtdBase |
| decimal | 1379 | in_processing_ilb_ltd_b |
| HOLDINGDBO | POSITION_DETAIL | PROCESSING_ILB_LTD_B | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/processingIlbLtdBase |
processingIlbLtdLocal |
| decimal | 1380 | in_processing_ilb_ltd_l |
| HOLDINGDBO | POSITION_DETAIL | PROCESSING_ILB_LTD_L | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/processingIlbLtdLocal |
spdDeltaInst |
| integer | 8650 | in_spd_delta_inst |
| HOLDINGDBO | POSITION_DETAIL | SPD_DELTA_INST | NUMBER(38) | N | EagleML/warehouseTransaction/warehousePosition/spdDeltaInst |
urglVariationMargin |
| decimal | 4947 | in_urgl_var_mgn |
| HOLDINGDBO | POSITION_DETAIL | URGL_VAR_MGN | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/urglVariationMargin |
urglVariationMarginLocal |
| decimal | 5457 | in_urgl_var_mgn_local |
| HOLDINGDBO | POSITION_DETAIL | URGL_VAR_MGN_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/urglVariationMarginLocal |
variationMargin |
| decimal | 5470 | in_var_mgn |
| HOLDINGDBO | POSITION_DETAIL | VAR_MGN | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/variationMargin |
variationMarginLocal |
| decimal | 5477 | in_var_mgn_local |
| HOLDINGDBO | POSITION_DETAIL | VAR_MGN_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/variationMarginLocal |
assetTotalReturn |
| decimal |
| in_pd_total_return |
| HOLDINGDBO | POSITION_DETAIL | TOTAL_RETURN |
| N | EagleML/warehouseTransaction/warehousePosition/assetTotalReturn |
openLotDeleteSwitch |
| YesNoOptionEnum |
|
|
|
|
|
|
| N | EagleML/warehouseTransaction/warehousePosition/openLotDeleteSwitch |
posDetAnlSwitch |
| string |
| in_pos_det_anl_switch |
|
|
|
|
| N | EagleML/warehouseTransaction/warehousePosition/posDetAnlSwitch |
currentBenchmark |
| string |
|
|
| HOLDINGDBO | POSITION_PLEDGE_DETAIL | CURRENT_BENCHMARK |
| N | EagleML/warehouseTransaction/warehousePosition/currentBenchmark |
currPledgeBaseValue |
| decimal |
|
|
| HOLDINGDBO | POSITION_PLEDGE_DETAIL | CURR_PLEDGE_BASE_VALUE |
| N | EagleML/warehouseTransaction/warehousePosition/currPledgeBaseValue |
custodyBank |
| string |
|
|
| HOLDINGDBO | POSITION_PLEDGE_DETAIL | CUSTODY_BANK |
| N | EagleML/warehouseTransaction/warehousePosition/custodyBank |
custodyStatus |
| string |
|
|
| HOLDINGDBO | POSITION_PLEDGE_DETAIL | CUSTODY_STATUS |
| N | EagleML/warehouseTransaction/warehousePosition/custodyStatus |
origPledgeBaseValue |
| decimal |
|
|
| HOLDINGDBO | POSITION_PLEDGE_DETAIL | ORIG_PLEDGE_BASE_VALUE |
| N | EagleML/warehouseTransaction/warehousePosition/origPledgeBaseValue |
outstandingUnits |
| decimal |
|
|
| HOLDINGDBO | POSITION_PLEDGE_DETAIL | OUTSTANDING_UNITS |
| N | EagleML/warehouseTransaction/warehousePosition/outstandingUnits |
pledgeMaster |
| decimal |
|
|
| HOLDINGDBO | POSITION_PLEDGE_DETAIL | PLEDGE_MASTER |
| N | EagleML/warehouseTransaction/warehousePosition/pledgeMaster |
bookCostLocal |
| decimal | 17039 | in_book_cost_l |
| HOLDINGDBO | POSITION_COST_DETAIL | BOOK_COST_L |
| N | EagleML/warehouseTransaction/warehousePosition/bookCostLocal |
bookCostBase |
| decimal | 17038 | in_book_cost_b |
| HOLDINGDBO | POSITION_COST_DETAIL | BOOK_COST_B |
| N | EagleML/warehouseTransaction/warehousePosition/bookCostBase |
bookPriceLocal | Extract only | decimal | 17478 |
|
| HOLDINGDBO | POSITION_DETAIL | BOOK_PRICE_LOCAL |
| N | EagleML/warehouseTransaction/warehousePosition/bookPriceLocal |
bookPriceBase | Extract only | decimal | 17477 |
|
| HOLDINGDBO | POSITION_DETAIL | BOOK_PRICE |
| N | EagleML/warehouseTransaction/warehousePosition/bookPriceBase |
originalAcquisitionCostBase | Extract only | decimal |
|
|
| HOLDONGDBO | POSITION_COST_DETAIL | ORIG_ACQ_COST_BASE |
| N | EagleML/warehouseTransaction/warehousePosition/originalAcquisitionCostBase |
originalAcquisitionCostLocal | Extract only | decimal |
|
|
| HOLDONGDBO | POSITION_COST_DETAIL | ORIG_ACQ_COST_LOCAL |
| N | EagleML/warehouseTransaction/warehousePosition/originalAcquisitionCostLocal |
originalAcquisitionNotionalCostBase | Extract only | decimal |
| in_orig_acq_cost_notional_base |
| HOLDINGDBO | POSITION_COST_DETAIL | ORIG_ACQ_NOTIONAL_COST_B |
| N | EagleML/warehouseTransaction/warehousePosition/originalAcquisitionNotionalCostBase |
originalAcquisitionNotionalCostLocal | Extract only | decimal |
| in_orig_acq_cost_notional_local |
| HOLDINGDBO | POSITION_COST_DETAIL | ORIG_ACQ_NOTIONAL_COST_L |
| N | EagleML/warehouseTransaction/warehousePosition/originalAcquisitionNotionalCostLocal |
settledOriginalFace | Extract only | decimal | 11310 |
|
| HOLDINGDBO | POSITION_DETAIL | SETTLE_ORIG_FACE |
| N | EagleML/warehouseTransaction/warehousePosition/settledOriginalFace |
hedgeLink |
| string | 18301 | in_hedge_link | S | HOLDINGDBO | POSITION_DETAIL | HEDGE_LINK | VARCHAR2(60) | N | EagleML/warehouseTransaction/warehousePosition/hedgeLink |
taxExpenseBase |
| decimal | 15709 | in_tax_expense_base | F | HOLDINGDBO | POSITION_COST_DETAIL | TAX_EXPENSE_BASE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/taxExpenseBase |
recallableCapitalLocal |
| decimal | 18390 | in_recallable_capital_l |
| HOLDINGDBO | POSITION_COST_DETAIL | RECALLABLE_CAPITAL_L |
| N | EagleML/warehouseTransaction/warehousePosition/recallableCapitalLocal |
recallableCapitalBase |
| decimal | 18391 | in_recallable_capital_b |
| HOLDINGDBO | POSITION_COST_DETAIL | RECALLABLE_CAPITAL_B |
| N | EagleML/warehouseTransaction/warehousePosition/recallableCapitalBase |
commitmentAmountBase |
| decimal | 18392 | in_commitment_b |
| HOLDINGDBO | POSITION_COST_DETAIL | COMMITMENT_B |
| N | EagleML/warehouseTransaction/warehousePosition/commitmentAmountBase |
fundedCommitmentLocal |
| decimal | 18386 | in_funded_capital_l |
| HOLDINGDBO | POSITION_COST_DETAIL | FUNDED_CAPITAL_L |
| N | EagleML/warehouseTransaction/warehousePosition/fundedCommitmentLocal |
fundedCommitmentBase |
| decimal | 18387 | in_funded_capital_b |
| HOLDINGDBO | POSITION_COST_DETAIL | FUNDED_CAPITAL_B |
| N | EagleML/warehouseTransaction/warehousePosition/fundedCommitmentBase |
unfundedCommitmentLocal |
| decimal | 18388 | in_unfunded_commitment_l |
| HOLDINGDBO | POSITION_COST_DETAIL | UNFUNDED_COMMITMENT_L |
| N | EagleML/warehouseTransaction/warehousePosition/unfundedCommitmentLocal |
unfundedCommitmentBase |
| decimal | 18389 | in_unfunded_commitment_b |
| HOLDINGDBO | POSITION_COST_DETAIL | UNFUNDED_COMMITMENT_B |
| N | EagleML/warehouseTransaction/warehousePosition/unfundedCommitmentBase |
capitalCallsLocal |
| decimal | 18450 | in_capital_calls_l |
| HOLDINGDBO | POSITION_COST_DETAIL | CAPITAL_CALLS_L |
| N | EagleML/warehouseTransaction/warehousePosition/capitalCallsLocal |
capitalCallsBase |
| decimal | 18449 | in_capital_calls_b |
| HOLDINGDBO | POSITION_COST_DETAIL | CAPITAL_CALLS_B |
| N | EagleML/warehouseTransaction/warehousePosition/capitalCallsBase |
custodyBankAccountNumber | Extract only | string | 1660 |
|
| RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_ACCT_NUM |
| N | EagleML/warehouseTransaction/warehousePosition/custodyBankAccountNumber |
custodyBankCode | Extract only | string | 1176 |
|
| RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_CODE |
| N | EagleML/warehouseTransaction/warehousePosition/custodyBankCode |
custodyBankDesc | Extract only | string | 1177 |
|
| RULESDBO | ENTITY_CUSTODY_RELATIONSHIP | CUSTODY_BANK_DESC |
| N | EagleML/warehouseTransaction/warehousePosition/custodyBankDesc |
custodianPrincipalBalanceBase | Extract only | decimal | 18578 |
|
| HOLDINGDBO | POSITION_DETAIL | CUST_PRINCIPAL_BALANCE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/custodianPrincipalBalanceBase |
custodianPrincipalBalanceLocal | Extract only | decimal | 18579 |
|
| HOLDINGDBO | POSITION_DETAIL | CUST_PRINCIPAL_BALANCE_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/custodianPrincipalBalanceLocal |
custodianIncomeBalanceBase | Extract only | decimal | 18580 |
|
| HOLDINGDBO | POSITION_DETAIL | CUST_INCOME_BALANCE | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/custodianIncomeBalanceBase |
custodianIncomeBalanceLocal | Extract only | decimal | 18581 |
|
| HOLDINGDBO | POSITION_DETAIL | CUST_INCOME_BALANCE_LOCAL | NUMBER(38,12) | N | EagleML/warehouseTransaction/warehousePosition/custodianIncomeBalanceLocal |
srcSysC | Extract only | string | 98 |
|
| HOLDINGDBO | POSITION_DETAIL | SRC_SYS_C | VARCHAR2(25) | N | EagleML/warehouseTransaction/warehousePosition/srcSysC |
analytics | Position Analytics Model - see extra data map table | EagleML/warehouseTransaction/warehousePosition/analytics | |||||||||
realEstateUDF | Real Estate UDF Model - see extra data map table | EagleML/warehouseTransaction/warehousePosition/realEstateUDF/ | |||||||||
extendedRatingsModel | Extended Ratings Model - see extra data map table | EagleML/warehouseTransaction/warehousePosition/extendedRatingsModel/ | |||||||||
extendedPortValuationModel | Extended Port Valuation Model - see extra data map table | EagleML/warehouseTransaction/warehousePosition/extendedPortValuationModel/ | |||||||||
liquidity | Liquidity Model - see extra data map table | EagleML/warehouseTransaction/warehousePosition/liquidity/ | |||||||||
income | Income Model - see extra data map table (please note that this table is available only if you use EDS interface/Ontology) | EagleML/warehouseTransaction/warehousePosition/income/ | |||||||||
costUDF | Cost UDF Model - see extra data map table (please note that this table is available only if you use EDS interface/Ontology) | EagleML/warehouseTransaction/warehousePosition/costUDF/ | |||||||||