Subscribe Redeem 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/subscribeRedeem/objectType | |||
objectId | Optional | ObjectId | Â | not stored in DB | EagleML/accountingTransaction/subscribeRedeem/objectId | |||
objectDescription | Optional | FeedTypeEnum | Â | not stored in DB | EagleML/accountingTransaction/subscribeRedeem/objectDescription | |||
updateTimestamp | Optional | dateTime | 1106 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | UPDATE_DATE | DATE | EagleML/accountingTransaction/subscribeRedeem/updateTimestamp |
customElements | Optional | CustomElements | Â | reserved for customizations | EagleML/accountingTransaction/subscribeRedeem/customElements | |||
updateSource | Optional | string | 944 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | UPDATE_SOURCE | VARCHAR2(32) | EagleML/accountingTransaction/subscribeRedeem/updateSource |
EagleML/accountingTransaction/subscribeRedeem/ | ||||||||
EagleML/accountingTransaction/subscribeRedeem/ | ||||||||
postDate | Optional | date | 30 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | POST_DATE | DATE | EagleML/accountingTransaction/subscribeRedeem/postDate |
tradeDate | Optional | date | 35 | not stored in DB | EagleML/accountingTransaction/subscribeRedeem/tradeDate | |||
settlementDate | Optional | date | 37 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | CONTRACT_SETTLE_DT | DATE | EagleML/accountingTransaction/subscribeRedeem/settlementDate |
effectiveDate | Optional | date | 1109 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | EFFECTIVE_DATE | DATE | EagleML/accountingTransaction/subscribeRedeem/effectiveDate |
accountingDate | Optional | date | 36 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | ACCOUNTING_DATE | DATE | EagleML/accountingTransaction/subscribeRedeem/accountingDate |
navSequence | Optional | integer | Â | ESTAR | ESTAR_SUBSCRIBE_REDEEM | NAV_SEQUENCE | INTEGER | EagleML/accountingTransaction/subscribeRedeem/navSequence |
shareClass | Optional | string | 34 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | SHARE_CLASS | VARCHAR2(10) | EagleML/accountingTransaction/subscribeRedeem/shareClass |
clientInstance | Optional | string | 1632 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | CLIENT_INSTANCE | CHAR(12) | EagleML/accountingTransaction/subscribeRedeem/clientInstance |
globalShareRef | Optional | integer | 3202 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | GLOBAL_SHARE_REF | INTEGER | EagleML/accountingTransaction/subscribeRedeem/globalShareRef |
navEstQuality | Optional | string | 3194 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | NAV_EST_QUALITY | VARCHAR2(5) | EagleML/accountingTransaction/subscribeRedeem/navEstQuality |
navPerShare | Optional | decimal | 3195 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | NAV_PER_SHARE | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/navPerShare |
cashPikFlag | Optional | CashPikIndicatorEnum | 3204 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | CASH_PIK_FLAG | CHAR(1) | EagleML/accountingTransaction/subscribeRedeem/cashPikFlag |
pikAsset | Optional | EagleML/accountingTransaction/subscribeRedeem/pikAsset/ | ||||||
ruleInstance | Optional | integer | Â | ESTAR | ESTAR_SUBSCRIBE_REDEEM | APPLIED_RULE_ID | INTEGER | EagleML/accountingTransaction/subscribeRedeem/ruleInstance |
feeAmount | Optional | decimal | 3206 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | FEE_AMOUNT | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/feeAmount |
subRedIndicator | Optional | SubRedIndicatorEnum | 3198 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | SUB_RED_INDICATOR | CHAR(1) | EagleML/accountingTransaction/subscribeRedeem/subRedIndicator |
grossAmount | Optional | decimal | 3207 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | GROSS_AMOUNT | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/grossAmount |
netAmount | Optional | decimal | 50 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | NET_AMOUNT | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/netAmount |
grossShareIndicator | Optional | GrossShareIndicatorEnum | 3235 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | GROSS_SHARE_INDICATOR | CHAR(1) | EagleML/accountingTransaction/subscribeRedeem/grossShareIndicator |
sharesInTransaction | Optional | decimal | Â | ESTAR | ESTAR_SUBSCRIBE_REDEEM | SHARES_IN_TRANSACTION | NUMBER(38,8) | EagleML/accountingTransaction/subscribeRedeem/sharesInTransaction |
cumulativeShareBal | Optional | decimal | Â | ESTAR | ESTAR_SUBSCRIBE_REDEEM | CUMULATIVE_SHARE_BAL | NUMBER(38,8) | EagleML/accountingTransaction/subscribeRedeem/cumulativeShareBal |
activeFlag | Optional | YesNoOptionEnum | 1283 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | ACTIVE_FLAG | CHAR(1) | EagleML/accountingTransaction/subscribeRedeem/activeFlag |
eventId | Optional | TransactionId | 25 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | EVENT_ID | VARCHAR2(55) | EagleML/accountingTransaction/subscribeRedeem/eventId |
cancelEventId | Optional | TransactionId | 26 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | CANCEL_EVENT_ID | VARCHAR2(55) | EagleML/accountingTransaction/subscribeRedeem/cancelEventId |
settledShares | Optional | decimal | 758 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | SETTLED_SHARES | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/settledShares |
tradedShares | Optional | decimal | 430 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | TRADED_SHARES | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/tradedShares |
transType | Optional | string | 1257 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | TRANS_TYPE | VARCHAR2(10) | EagleML/accountingTransaction/subscribeRedeem/transType |
entranceFee | Optional | decimal | 52 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | ENTRANCE_FEE | NUMBER | EagleML/accountingTransaction/subscribeRedeem/entranceFee |
fxRate | Optional | decimal | 87 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | FX_RATE | NUMBER(38,9) | EagleML/accountingTransaction/subscribeRedeem/fxRate |
paidInCapLocal | Optional | decimal | 773 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | PAID_IN_CAP_L | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/paidInCapLocal |
paidInCapBase | Optional | decimal | 774 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | PAID_IN_CAP_B | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/paidInCapBase |
dilution | Optional | decimal | 4611 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | DILUTION | NUMBER(38,9) | EagleML/accountingTransaction/subscribeRedeem/dilution |
dilutionPerShare | Optional | decimal | 4612 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | DILUTION_PER_SHARE | NUMBER(38,9) | EagleML/accountingTransaction/subscribeRedeem/dilutionPerShare |
notes | Optional | string | 5310 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | NOTES | VARCHAR2(4000) | EagleML/accountingTransaction/subscribeRedeem/notes |
postingAmtA | Optional | decimal | Â | ESTAR | ESTAR_SUBSCRIBE_REDEEM | POSTING_AMT_A | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/postingAmtA |
postingAmtB | Optional | decimal | Â | ESTAR | ESTAR_SUBSCRIBE_REDEEM | POSTING_AMT_B | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/postingAmtB |
postingAmtC | Optional | decimal | Â | ESTAR | ESTAR_SUBSCRIBE_REDEEM | POSTING_AMT_C | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/postingAmtC |
postingAmtD | Optional | decimal | Â | ESTAR | ESTAR_SUBSCRIBE_REDEEM | POSTING_AMT_D | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/postingAmtD |
postingAmtE | Optional | decimal | Â | ESTAR | ESTAR_SUBSCRIBE_REDEEM | POSTING_AMT_E | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/postingAmtE |
postingAmtF | Optional | decimal | Â | ESTAR | ESTAR_SUBSCRIBE_REDEEM | POSTING_AMT_F | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/postingAmtF |
postingAmtG | Optional | decimal | Â | ESTAR | ESTAR_SUBSCRIBE_REDEEM | POSTING_AMT_G | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/postingAmtG |
postingAmtH | Optional | decimal | Â | ESTAR | ESTAR_SUBSCRIBE_REDEEM | POSTING_AMT_H | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/postingAmtH |
monthEndDate | Optional | date | 4733 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | MONTH_END_DATE | DATE | EagleML/accountingTransaction/subscribeRedeem/monthEndDate |
recPayAccount | Optional | string | 1825 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | REC_PAY_ACCT1 | VARCHAR2(10) | EagleML/accountingTransaction/subscribeRedeem/recPayAccount |
recPayAccount2 | Optional | string | 1826 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | REC_PAY_ACCT2 | VARCHAR2(10) | EagleML/accountingTransaction/subscribeRedeem/recPayAccount2 |
eventType | Optional | string | 2362 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | EVENT_TYPE | VARCHAR2(32) | EagleML/accountingTransaction/subscribeRedeem/eventType |
settledSharesActivity | Optional | decimal | 11714 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | SETTLED_SHARES_ACTIVITY | NUMBER(38,6) | EagleML/accountingTransaction/subscribeRedeem/settledSharesActivity |
settlementMethod | Optional | string | 629 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | SETTLEMENT_METHOD | VARCHAR2(1) | EagleML/accountingTransaction/subscribeRedeem/settlementMethod |
cancelTransType | Optional | string | Â | ESTAR | ESTAR_SUBSCRIBE_REDEEM | CANCEL_TRANS_TYPE | VARCHAR2(10) | EagleML/accountingTransaction/subscribeRedeem/cancelTransType |
deemedIncome | Optional | decimal | 2790 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | DEEMED_INCOME | NUMBER(38,12) | EagleML/accountingTransaction/subscribeRedeem/deemedIncome |
deemedIncomeLocal | Optional | decimal | 2832 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | DEEMED_INCOME_LOCAL | NUMBER(38,12) | EagleML/accountingTransaction/subscribeRedeem/deemedIncomeLocal |
cancelFlag | Optional | YesNoOptionEnum | 10045 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | CANCEL_FLAG | VARCHAR2(1) | EagleML/accountingTransaction/subscribeRedeem/cancelFlag |
cancelType | Optional | string | 2981 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | CANCEL_TYPE | VARCHAR2(1) | EagleML/accountingTransaction/subscribeRedeem/cancelType |
instance | Optional | integer | 1306 | ESTAR | ESTAR_SUBSCRIBE_REDEEM | TRANSACTION_ID | INTEGER | EagleML/accountingTransaction/subscribeRedeem/instance |
Entity Share Class Model (extract-only, see extra data map table) | EagleML/accountingTransaction/subscribeRedeem/ | |||||||
EagleML/accountingTransaction/subscribeRedeem/ | ||||||||
SubscribeRedeemCalcFields Model (extract-only)This is an extract-only model, added to the extract by IncludeSubscribeReedemCalcFields=Y RTR parameter | ||||||||
Element | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | DB Field Type | Xpath |
grossAmountBase | decimal | Â | Â | Â | Â | Â | Â | EagleML/accountingTransaction/subscribeRedeem/grossAmountBase |
grossAmountLocal | decimal | Â | Â | Â | Â | Â | Â | EagleML/accountingTransaction/subscribeRedeem/grossAmountLocal |
netAmountBase | decimal | Â | Â | Â | Â | Â | Â | EagleML/accountingTransaction/subscribeRedeem/netAmountBase |
netAmountLocal | decimal | Â | Â | Â | Â | Â | Â | EagleML/accountingTransaction/subscribeRedeem/netAmountLocal |
parValue | decimal | Â | Â | ESTAR | ESTAR_SUBSCRIBE_REDEEM | POSTING_AMT_G | Â | EagleML/accountingTransaction/subscribeRedeem/parValue |
paidInSurplusBase | decimal | Â | Â | ESTAR | ESTAR_SUBSCRIBE_REDEEM | PAID_IN_CAP_B | Â | EagleML/accountingTransaction/subscribeRedeem/paidInSurplusBase |
paidInSurplusLocal | decimal | Â | Â | ESTAR | ESTAR_SUBSCRIBE_REDEEM | PAID_IN_CAP_L | Â | EagleML/accountingTransaction/subscribeRedeem/paidInSurplusLocal |
navImpactPerShare | string | Â | Â | ESTAR | ESTAR_SUBSCRIBE_REDEEM | DILUTION | Â | EagleML/accountingTransaction/subscribeRedeem/navImpactPerShare |
Â