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