Monthly Portfolio Valuation Data Map Table
- Natalie Gesin (Deactivated)
- Kinga Huszno
- Dmitry Donosiyan (Unlicensed)
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 |
EagleML/accountingTransaction/monthlyPortfolioValuation/ | ||||||||
EagleML/accountingTransaction/monthlyPortfolioValuation/ | ||||||||
EagleML/accountingTransaction/monthlyPortfolioValuation/ | ||||||||
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 |