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/portfolioValuation/objectType | |||
| objectId | Optional | ObjectId | Â | not stored in DB | EagleML/accountingTransaction/portfolioValuation/objectId | |||
| objectDescription | Optional | FeedTypeEnum | Â | not stored in DB | EagleML/accountingTransaction/portfolioValuation/objectDescription | |||
| updateTimestamp | Optional | dateTime | 1106 | ESTAR | ESTAR_PORTFOLIO_VALUATION | UPDATE_DATE | DATE | EagleML/accountingTransaction/portfolioValuation/updateTimestamp |
| customElements | Optional | CustomElements | Â | reserved for customizations | EagleML/accountingTransaction/portfolioValuation/customElements | |||
| updateSource | Optional | string | 944 | ESTAR | ESTAR_PORTFOLIO_VALUATION | UPDATE_SOURCE | VARCHAR2(32) | EagleML/accountingTransaction/portfolioValuation/updateSource |
| Entity Common Id Model | EagleML/accountingTransaction/portfolioValuation/ | |||||||
| Asset Identifiers Model | EagleML/accountingTransaction/portfolioValuation/ | |||||||
| targetSourceName | Â | Â | Â | Â | Â | Â | Â | EagleML/accountingTransaction/portfolioValuation/targetSourceName |
| targetSourceInstance | Optional | integer | 3789 | ESTAR | ESTAR_PORTFOLIO_VALUATION | TARGET_SOURCE_INST | NUMBERÂ | EagleML/accountingTransaction/portfolioValuation/targetSourceInstance |
| fxSourceName | Optional | string | Â | Â | Â | Â | Â | EagleML/accountingTransaction/portfolioValuation/fxSourceName |
| fxSourceInstance | Optional | integer | 4507 | ESTAR | ESTAR_PORTFOLIO_VALUATION | FX_SOURCE_ID | NUMBERÂ | EagleML/accountingTransaction/portfolioValuation/fxSourceInstance |
| currentPrice | Optional | decimal | 1110 | ESTAR | ESTAR_PORTFOLIO_VALUATION | CURRENT_PRICE | NUMBER(28,12) | EagleML/accountingTransaction/portfolioValuation/currentPrice |
| currentFxRate | Optional | decimal | 96 | ESTAR | ESTAR_PORTFOLIO_VALUATION | CURRENT_XRATE | NUMBER(38,12) | EagleML/accountingTransaction/portfolioValuation/currentFxRate |
| priorPrice | Optional | decimal | 1763 | ESTAR | ESTAR_PORTFOLIO_VALUATION | PRIOR_PRICE | NUMBER(28,12) | EagleML/accountingTransaction/portfolioValuation/priorPrice |
| priorExchangeRate | Optional | decimal | 484 | ESTAR | ESTAR_PORTFOLIO_VALUATION | PRIOR_XRATE | NUMBER(38,12) | EagleML/accountingTransaction/portfolioValuation/priorExchangeRate |
| securityGlLocal | Optional | decimal | 4745 | ESTAR | ESTAR_PORTFOLIO_VALUATION | SECURITY_GL_LOCAL | NUMBER(38,6) | EagleML/accountingTransaction/portfolioValuation/securityGlLocal |
| securityGlBase | Optional | decimal | 4746 | ESTAR | ESTAR_PORTFOLIO_VALUATION | SECURITY_GL_BASE | NUMBER(38,6) | EagleML/accountingTransaction/portfolioValuation/securityGlBase |
| totalUrglBase | Optional | decimal | 4619 | ESTAR | ESTAR_PORTFOLIO_VALUATION | TOT_URGL_B | NUMBER(38,6) | EagleML/accountingTransaction/portfolioValuation/totalUrglBase |
| urglCurrencyBase | Optional | decimal | Â | ESTAR | ESTAR_PORTFOLIO_VALUATION | URGL_CURRENCY_B | NUMBER(38,6) | EagleML/accountingTransaction/portfolioValuation/urglCurrencyBase |
| wipInstance | Optional | integer | 4881 | ESTAR | ESTAR_PORTFOLIO_VALUATION | WIP_INSTANCE | NUMBERÂ | EagleML/accountingTransaction/portfolioValuation/wipInstance |
| prsInstance | Optional | integer | 4882 | ESTAR | ESTAR_PORTFOLIO_VALUATION | PRS_INSTANCE | NUMBERÂ | EagleML/accountingTransaction/portfolioValuation/prsInstance |
| navCurrentShares | Optional | decimal | 3209 | ESTAR | ESTAR_PORTFOLIO_VALUATION | NAV_CURRENT_SHARES | NUMBER(38,12) | EagleML/accountingTransaction/portfolioValuation/navCurrentShares |
| navImpactPerShare | Optional | decimal | 5375 | ESTAR | ESTAR_PORTFOLIO_VALUATION | NAV_IMPACT_PER_SHARE | NUMBER(38,12) | EagleML/accountingTransaction/portfolioValuation/navImpactPerShare |
| navImpactPercentChange | Optional | decimal | Â | ESTAR | ESTAR_PORTFOLIO_VALUATION | NAV_IMPACT_PCT_CHG | NUMBER(28,12) | EagleML/accountingTransaction/portfolioValuation/navImpactPercentChange |
| navBasisPointImpact | Optional | decimal | 5384 | ESTAR | ESTAR_PORTFOLIO_VALUATION | NAV_BASIS_POINT_IMPACT | NUMBER(38,12) | EagleML/accountingTransaction/portfolioValuation/navBasisPointImpact |
| amortizedCostLocal | Optional | decimal | 4601 | ESTAR | ESTAR_PORTFOLIO_VALUATION | AMORT_COST_BASE | NUMBER(38,6) | EagleML/accountingTransaction/portfolioValuation/amortizedCostLocal |
| amortizedCostBase | Optional | decimal | 4602 | ESTAR | ESTAR_PORTFOLIO_VALUATION | AMORT_COST_LOCAL | NUMBER(38,6) | EagleML/accountingTransaction/portfolioValuation/amortizedCostBase |
| exchangeRateDate | Optional | date | 485 | ESTAR | ESTAR_PORTFOLIO_VALUATION | XRATE_DATE | DATE | EagleML/accountingTransaction/portfolioValuation/exchangeRateDate |
| priceCode | Optional | integer | 1843 | ESTAR | ESTAR_PORTFOLIO_VALUATION | PRICE_TYPE | NUMBERÂ | EagleML/accountingTransaction/portfolioValuation/priceCode |
| priceCondition | Optional | string | 4849 | ESTAR | ESTAR_PORTFOLIO_VALUATION | PRICE_CONDITION | VARCHAR2(20) | EagleML/accountingTransaction/portfolioValuation/priceCondition |
| priceLevel | Optional | integer | 12007 | ESTAR | ESTAR_PORTFOLIO_VALUATION | PRICE_LEVEL | NUMBER(38,0) | EagleML/accountingTransaction/portfolioValuation/priceLevel |
| priceDate | Optional | date | 482 | ESTAR | ESTAR_PORTFOLIO_VALUATION | PRICE_DATE | DATE | EagleML/accountingTransaction/portfolioValuation/priceDate |
| priceOverride | Optional | YesNoOptionStrictEnum | Â | ESTAR | ESTAR_PORTFOLIO_VALUATION | PRICE_OVERRIDE | VARCHAR2(1) | EagleML/accountingTransaction/portfolioValuation/priceOverride |
| staleRateFlag | Optional | YesNoOptionStrictEnum | 9121 | ESTAR | ESTAR_PORTFOLIO_VALUATION | STALE_RATE_FLAG | CHAR(1) | EagleML/accountingTransaction/portfolioValuation/staleRateFlag |
| pcToleranceBrk | Optional | YesNoOptionStrictEnum | 8603 | ESTAR | ESTAR_PORTFOLIO_VALUATION | PC_TOL_BRK | VARCHAR2(1) | EagleML/accountingTransaction/portfolioValuation/pcToleranceBrk |
| psToleranceBrk | Optional | YesNoOptionStrictEnum | 8605,84 | ESTAR | ESTAR_PORTFOLIO_VALUATION | PS_TOL_BRK | VARCHAR2(1) | EagleML/accountingTransaction/portfolioValuation/psToleranceBrk |
| bsToleranceBrk | Optional | YesNoOptionStrictEnum | 8606,84 | ESTAR | ESTAR_PORTFOLIO_VALUATION | BS_TOL_BRK | VARCHAR2(1) | EagleML/accountingTransaction/portfolioValuation/bsToleranceBrk |
| priorQuantityPriced | Optional | decimal | Â | ESTAR | ESTAR_PORTFOLIO_VALUATION | QTY_PRICED_PRIOR | NUMBER(38,12) | EagleML/accountingTransaction/portfolioValuation/priorQuantityPriced |
| priorAmortizedCostLocal | Optional | decimal | 9180 | ESTAR | ESTAR_PORTFOLIO_VALUATION | PRIOR_AMORT_COST_LOCAL | NUMBER(38,12) | EagleML/accountingTransaction/portfolioValuation/priorAmortizedCostLocal |
| priorAmortizedCostBase | Optional | decimal | 9181 | ESTAR | ESTAR_PORTFOLIO_VALUATION | PRIOR_AMORT_COST_BASE | NUMBER(38,12) | EagleML/accountingTransaction/portfolioValuation/priorAmortizedCostBase |
| priorEffectiveDate | Optional | date | 1764 | ESTAR | ESTAR_PORTFOLIO_VALUATION | PREV_EFFECTIVE_DATE | DATE | EagleML/accountingTransaction/portfolioValuation/priorEffectiveDate |
| originalSourcePriceType | Optional | integer | Â | ESTAR | ESTAR_PORTFOLIO_VALUATION | ORIG_SRC_PRICE_TYPE | NUMBER(38,0) | EagleML/accountingTransaction/portfolioValuation/originalSourcePriceType |
| daysCopied | Optional | integer | 8399 | ESTAR | ESTAR_PORTFOLIO_VALUATION | DAYS_COPIED | NUMBER(38,0) | EagleML/accountingTransaction/portfolioValuation/daysCopied |
| daysPriceUnchanged | Optional | integer | 8398 | ESTAR | ESTAR_PORTFOLIO_VALUATION | DAYS_UNCHANGED | NUMBER(38,0) | EagleML/accountingTransaction/portfolioValuation/daysPriceUnchanged |
| lastChangeDate | Optional | date | 8400 | ESTAR | ESTAR_PORTFOLIO_VALUATION | LAST_CHANGE_DATE | DATE | EagleML/accountingTransaction/portfolioValuation/lastChangeDate |
| portfolioValuationType | Optional | string | Â | ESTAR | ESTAR_PORTFOLIO_VALUATION | PORTFOLIO_VALUATION_TYPE | VARCHAR2(30) | EagleML/accountingTransaction/portfolioValuation/portfolioValuationType |
| instance | Optional | integer | Â | ESTAR | ESTAR_PORTFOLIO_VALUATION | PORTFOLIO_VALUATION_INST | NUMBER | EagleML/accountingTransaction/portfolioValuation/instance |
| urglLedgerRuleUpdateDate | Optional | date | 2411 | ESTAR | ESTAR_PORTFOLIO_VALUATION | URGL_LEDGER_RULE_UPDATE_DATE | DATE | EagleML/accountingTransaction/portfolioValuation/urglLedgerRuleUpdateDate |
| urglLedgerRuleInstance | Optional | integer | 2412 | ESTAR | ESTAR_PORTFOLIO_VALUATION | URGL_LEDGER_RULE_INSTANCE | NUMBER(38,0) | EagleML/accountingTransaction/portfolioValuation/urglLedgerRuleInstance |
| updateCount | Optional | integer | Â | ESTAR | ESTAR_PORTFOLIO_VALUATION | UPDATE_COUNT | NUMBER(38,0) | EagleML/accountingTransaction/portfolioValuation/updateCount |
| ecpUpdateDate | Optional | date | 10564 | ESTAR | ESTAR_PORTFOLIO_VALUATION | ECP_UPD_DATE | DATE | EagleML/accountingTransaction/portfolioValuation/ecpUpdateDate |
| srcSysC | Optional | string | Â | ESTAR | ESTAR_TRADED_CASH_ACTIVITY | SRC_SYS_C | VARCHAR2(25) | EagleML/accountingTransaction/portfolioValuation/srcSysC |