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/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 |
EagleML/accountingTransaction/portfolioValuation/ | ||||||||
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 |