Info | ||
---|---|---|
| ||
Roll Up in Single Row mode is only available in environments 13.x or higher. Roll Up in Batch mode is fully supported. If you are using EagleML July release or earlier, please add <procedureFlag>PD</procedureFlag> node before the <primaryAssetId> node in order to have the Roll Up work properly in Batch Mode. |
...
Fields of of POSITION_DETAIL DB table | Fields of LOT_LEVEL_POSITION DB table are summed | EagleML elements are summed | Comments |
---|---|---|---|
ORIG_FACE | ORIG_FACE | originalFace | |
INTEREST_PURCHASED | INT_PURCHASED | intPurchased | |
SHARE_PAR_VALUE | PAR_OR_SHARES | parOrShares | |
SETTLE_QUANTITY | SETTLE_QUANTITY | settledQuantity | |
ACCRUED_INCOME_LOCAL | ACCRUED_INCOME_LOCAL | accruedIncomeLocal | |
INTEREST_EARNED | INTEREST_EARNED | interestEarned | |
SECURITY_INCOME | INT_RECEIVED | intReceived | |
MKT_EXCHANGE_RATE | CURR_FX_RATE | currFxRate | For MKTFor CURR_EXCHANGEFX_RATE an average value is resolved instead of a sum. |
LOCAL_MARKET_VALUE | LOCAL_MARKET_VALUE | marketValueLocal | |
MARKET_VALUE | MARKET_VALUE | marketValueBase | |
LOCAL_UNREALIZED_GL | LOCAL_UNREALIZED_GL | totalUnrealizedGainLossLocal | |
UNREALIZED_SEC_GL | UNREALIZED_SEC_GL | urglSecurityBase | |
BASE_UNREALIZED_GL | BASE_UNREALIZED_GL | totalUnrealizedGainLossBase | |
UNREALIZED_CURR_GL | UNREALIZED_CURR_GL | urglCurrencyBase | |
ACCRUED_INCOME | ACCRUED_INCOME | accruedIncome | |
TIP_LTD_INCOME_LOCAL | TIP_LTD_INCOME_LOCAL | closeTipsIncomeLtdLocal | |
TIP_LTD_INCOME | TIP_LTD_INCOME | closeTipsIncomeLtdBase | |
INDX_WEIGHT | INDX_WEIGHT | closeIndexWeight | |
BOOK_VALUE_LOCAL | BOOK_VALUE_LOCAL | bookValueLocal | |
BOOK_VALUE | BOOK_VALUE | bookValue | |
MARKET_VALUE_INCOME | MARKET_VALUE_INCOME | marketValueIncome | |
MARKET_VALUE_INCOME_LOCAL | MARKET_VALUE_INCOME_LOCAL | marketValueIncomeLocal | |
NOTIONAL_MARKET_VALUE_LOCAL | NOTIONAL_MARKET_VALUE_LOCAL | notionalMarketValueLocal | |
NOTIONAL_MARKET_VALUE | NOTIONAL_MARKET_VALUE | notionalMarketValueBase | |
The following fields are supported for environments 2017 R2.x or higher | |||
ORIGINAL_COST_AMOUNT | ORIGINAL_COST_AMOUNT | originalCostAmount | |
PROCESSING_ILB_LTD_L | PROCESSING_ILB_LTD_L | processingIlbLtdLocal | |
PROCESSING_ILB_LTD_B | PROCESSING_ILB_LTD_B | processingIlbLtdBase | |
PRICE (average value) | PRICE | price |
Position DB Table
The following fields of HOLDINGDBO.POSITION DB table are defined by the sum of DB fields from Open Lot tables with the same key (Entity Id + Effective Date + Source Name):
...