Monthly Portfolio Valuation Data Map Table
- Natalie Gesin (Deactivated)
- Dmitry Donosiyan (Unlicensed)
Owned by Natalie Gesin (Deactivated)
| Element | Optional/Required | Value Type | Star Tag | Eagle DB | DBÂ Table | DB Field | Data Type | XPath |
|---|---|---|---|---|---|---|---|---|
| objectType | Optional | ObjectTypeEnum | Â | not stored in DB | EagleML/accountingTransaction/monthlyPortfolioValuation/objectType | |||
| objectId | Optional | ObjectId | Â | not stored in DB | EagleML/accountingTransaction/monthlyPortfolioValuation/objectId | |||
| objectDescription | Optional | FeedTypeEnum | Â | not stored in DB | EagleML/accountingTransaction/monthlyPortfolioValuation/objectDescription | |||
| updateTimestamp | Optional | dateTime | 1106 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | UPDATE_DATE | DATE | EagleML/accountingTransaction/monthlyPortfolioValuation/updateTimestamp |
| customElements | Optional | CustomElements | Â | reserved for customizations | EagleML/accountingTransaction/monthlyPortfolioValuation/customElements | |||
| updateSource | Optional | string | 944 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | UPDATE_SOURCE | VARCHAR2(32) | EagleML/accountingTransaction/monthlyPortfolioValuation/updateSource |
| Entity Common Id Model | EagleML/accountingTransaction/monthlyPortfolioValuation/ | |||||||
| Entity Properties Model (extract only) | EagleML/accountingTransaction/monthlyPortfolioValuation/ | |||||||
| Asset Identifiers Model | EagleML/accountingTransaction/monthlyPortfolioValuation/ | |||||||
| Extended Asset Properties Model (extract only) | EagleML/accountingTransaction/monthlyPortfolioValuation/ | |||||||
| targetSourceName | Â | Â | Â | Â | Â | Â | Â | EagleML/accountingTransaction/monthlyPortfolioValuation/targetSourceName |
| targetSourceInstance | Optional | integer | 3789 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | TARGET_SOURCE_INST | NUMBERÂ | EagleML/accountingTransaction/monthlyPortfolioValuation/targetSourceInstance |
| fxSourceName | Optional | string | Â | Â | Â | Â | Â | EagleML/accountingTransaction/monthlyPortfolioValuation/fxSourceName |
| fxSourceInstance | Optional | integer | 4507 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | FX_SOURCE_ID | NUMBERÂ | EagleML/accountingTransaction/monthlyPortfolioValuation/fxSourceInstance |
| currentPrice | Optional | decimal | 1110 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | CURRENT_PRICE | NUMBER(28,12) | EagleML/accountingTransaction/monthlyPortfolioValuation/currentPrice |
| currentFxRate | Optional | decimal | 96 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | CURRENT_XRATE | NUMBER(38,12) | EagleML/accountingTransaction/monthlyPortfolioValuation/currentFxRate |
| priorPrice | Optional | decimal | 1763 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | PRIOR_PRICE | NUMBER(28,12) | EagleML/accountingTransaction/monthlyPortfolioValuation/priorPrice |
| priorExchangeRate | Optional | decimal | 484 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | PRIOR_XRATE | NUMBER(38,12) | EagleML/accountingTransaction/monthlyPortfolioValuation/priorExchangeRate |
| securityGlLocal | Optional | decimal | 4745 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | SECURITY_GL_LOCAL | NUMBER(38,6) | EagleML/accountingTransaction/monthlyPortfolioValuation/securityGlLocal |
| securityGlBase | Optional | decimal | 4746 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | SECURITY_GL_BASE | NUMBER(38,6) | EagleML/accountingTransaction/monthlyPortfolioValuation/securityGlBase |
| totalUrglBase | Optional | decimal | 4619 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | TOT_URGL_B | NUMBER(38,6) | EagleML/accountingTransaction/monthlyPortfolioValuation/totalUrglBase |
| urglCurrencyBase | Optional | decimal | Â | ESTAR | MONTHLY_PORTFOLIO_VALUATION | URGL_CURRENCY_B | NUMBER(38,6) | EagleML/accountingTransaction/monthlyPortfolioValuation/urglCurrencyBase |
| wipInstance | Optional | integer | 4881 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | WIP_INSTANCE | NUMBERÂ | EagleML/accountingTransaction/monthlyPortfolioValuation/wipInstance |
| prsInstance | Optional | integer | 4882 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | PRS_INSTANCE | NUMBERÂ | EagleML/accountingTransaction/monthlyPortfolioValuation/prsInstance |
| navCurrentShares | Optional | decimal | 3209 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | NAV_CURRENT_SHARES | NUMBER(38,12) | EagleML/accountingTransaction/monthlyPortfolioValuation/navCurrentShares |
| navImpactPerShare | Optional | decimal | 5375 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | NAV_IMPACT_PER_SHARE | NUMBER(38,12) | EagleML/accountingTransaction/monthlyPortfolioValuation/navImpactPerShare |
| navImpactPercentChange | Optional | decimal | Â | ESTAR | MONTHLY_PORTFOLIO_VALUATION | NAV_IMPACT_PCT_CHG | NUMBER(28,12) | EagleML/accountingTransaction/monthlyPortfolioValuation/navImpactPercentChange |
| navBasisPointImpact | Optional | decimal | 5384 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | NAV_BASIS_POINT_IMPACT | NUMBER(38,12) | EagleML/accountingTransaction/monthlyPortfolioValuation/navBasisPointImpact |
| amortizedCostLocal | Optional | decimal | 4601 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | AMORT_COST_BASE | NUMBER(38,6) | EagleML/accountingTransaction/monthlyPortfolioValuation/amortizedCostLocal |
| amortizedCostBase | Optional | decimal | 4602 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | AMORT_COST_LOCAL | NUMBER(38,6) | EagleML/accountingTransaction/monthlyPortfolioValuation/amortizedCostBase |
| exchangeRateDate | Optional | date | 485 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | XRATE_DATE | DATE | EagleML/accountingTransaction/monthlyPortfolioValuation/exchangeRateDate |
| priceCode | Optional | integer | 1843 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | PRICE_TYPE | NUMBERÂ | EagleML/accountingTransaction/monthlyPortfolioValuation/priceCode |
| priceCondition | Optional | string | 4849 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | PRICE_CONDITION | VARCHAR2(20) | EagleML/accountingTransaction/monthlyPortfolioValuation/priceCondition |
| priceLevel | Optional | integer | 12007 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | PRICE_LEVEL | NUMBER(38,0) | EagleML/accountingTransaction/monthlyPortfolioValuation/priceLevel |
| priceDate | Optional | date | 482 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | PRICE_DATE | DATE | EagleML/accountingTransaction/monthlyPortfolioValuation/priceDate |
| priceOverride | Optional | YesNoOptionStrictEnum | Â | ESTAR | MONTHLY_PORTFOLIO_VALUATION | PRICE_OVERRIDE | VARCHAR2(1) | EagleML/accountingTransaction/monthlyPortfolioValuation/priceOverride |
| staleRateFlag | Optional | YesNoOptionStrictEnum | 9121 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | STALE_RATE_FLAG | CHAR(1) | EagleML/accountingTransaction/monthlyPortfolioValuation/staleRateFlag |
| pcToleranceBrk | Optional | YesNoOptionStrictEnum | 8603 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | PC_TOL_BRK | VARCHAR2(1) | EagleML/accountingTransaction/monthlyPortfolioValuation/pcToleranceBrk |
| psToleranceBrk | Optional | YesNoOptionStrictEnum | 8605,84 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | PS_TOL_BRK | VARCHAR2(1) | EagleML/accountingTransaction/monthlyPortfolioValuation/psToleranceBrk |
| bsToleranceBrk | Optional | YesNoOptionStrictEnum | 8606,84 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | BS_TOL_BRK | VARCHAR2(1) | EagleML/accountingTransaction/monthlyPortfolioValuation/bsToleranceBrk |
| priorQuantityPriced | Optional | decimal | Â | ESTAR | MONTHLY_PORTFOLIO_VALUATION | QTY_PRICED_PRIOR | NUMBER(38,12) | EagleML/accountingTransaction/monthlyPortfolioValuation/priorQuantityPriced |
| priorAmortizedCostLocal | Optional | decimal | 9180 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | PRIOR_AMORT_COST_LOCAL | NUMBER(38,12) | EagleML/accountingTransaction/monthlyPortfolioValuation/priorAmortizedCostLocal |
| priorAmortizedCostBase | Optional | decimal | 9181 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | PRIOR_AMORT_COST_BASE | NUMBER(38,12) | EagleML/accountingTransaction/monthlyPortfolioValuation/priorAmortizedCostBase |
| priorEffectiveDate | Optional | date | 1764 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | PREV_EFFECTIVE_DATE | DATE | EagleML/accountingTransaction/monthlyPortfolioValuation/priorEffectiveDate |
| originalSourcePriceType | Optional | integer | Â | ESTAR | MONTHLY_PORTFOLIO_VALUATION | ORIG_SRC_PRICE_TYPE | NUMBER(38,0) | EagleML/accountingTransaction/monthlyPortfolioValuation/originalSourcePriceType |
| daysCopied | Optional | integer | 8399 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | DAYS_COPIED | NUMBER(38,0) | EagleML/accountingTransaction/monthlyPortfolioValuation/daysCopied |
| daysPriceUnchanged | Optional | integer | 8398 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | DAYS_UNCHANGED | NUMBER(38,0) | EagleML/accountingTransaction/monthlyPortfolioValuation/daysPriceUnchanged |
| lastChangeDate | Optional | date | 8400 | ESTAR | MONTHLY_PORTFOLIO_VALUATION | LAST_CHANGE_DATE | DATE | EagleML/accountingTransaction/monthlyPortfolioValuation/lastChangeDate |
| portfolioValuationType | Optional | string | Â | ESTAR | MONTHLY_PORTFOLIO_VALUATION | PORTFOLIO_VALUATION_TYPE | VARCHAR2(30) | EagleML/accountingTransaction/monthlyPortfolioValuation/portfolioValuationType |
| instance | Optional | integer | Â | ESTAR | MONTHLY_PORTFOLIO_VALUATION | MON_PORT_VAL_INST | NUMBER | EagleML/accountingTransaction/monthlyPortfolioValuation/instance |