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. |
...
The following fields of HOLDINGDBO.POSITION_DETAIL DB table are defined by the sum of DB fields from Open Lot tables with the same key (Entity Id + Effective Date + Source Name):
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 CURR_FX_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):
...