Accounting Accrued Income Data Map Table
- Natalie Gesin (Deactivated)
- 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/accountingAccruedIncome/objectType | ||
objectId | Optional | ObjectId | Â | not stored in DB | Â | EagleML/accountingTransaction/accountingAccruedIncome/objectId | ||
objectDescription | Optional | FeedTypeEnum | Â | not stored in DB | Â | EagleML/accountingTransaction/accountingAccruedIncome/objectDescription | ||
updateTimestamp | Optional | dateTime | Â | ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | SYSTEM_DATE | DATE | EagleML/accountingTransaction/accountingAccruedIncome/updateTimestamp |
customElements | Not recommended | CustomElements -Â ComplexType | Â | Â | Â | Â | Â | EagleML/accountingTransaction/accountingAccruedIncome/customElements/ |
updateSource | Required | string | 944 | ESTAR | ESTAR_DAILY_YIELD_MILL_RATE | UPDATE_SOURCE | VARCHAR2(32) | EagleML/accountingTransaction/accountingAccruedIncome/updateSource |
 |  |  |  |  |  |  | EagleML/accountingTransaction/accountingAccruedIncome/ | |
 |  |  |  |  |  |  | EagleML/accountingTransaction/accountingAccruedIncome/ | |
investmentType | Optional | StringWithCodeScheme | 11 | SECURITYDBO | SECURITY_MASTER | INVESTMENT_TYPE | Â | EagleML/accountingTransaction/accountingAccruedIncome/investmentType |
postDate | Optional | date | 30 | ESTAR | ESTAR_INCOME_ACTIVITY | POST_DT | DATE | EagleML/accountingTransaction/accountingAccruedIncome/postDate |
tradeDate | Optional | date | 35 | ESTAR | ESTAR_INCOME_ACTIVITY | TRADE_DT | DATE | EagleML/accountingTransaction/accountingAccruedIncome/tradeDate |
accountingDate | Optional | date | 36 | ESTAR | ESTAR_INCOME_ACTIVITY | ACCT_DT | DATE | EagleML/accountingTransaction/accountingAccruedIncome/accountingDate |
units | Optional | decimal | 40 | ESTAR | ESTAR_INCOME_ACTIVITY | UNITS | NUMBER(38,6) | EagleML/accountingTransaction/accountingAccruedIncome/units |
clsEventId | Optional | string | 182 | ESTAR | ESTAR_INCOME_ACTIVITY | CLS_EVENT_ID | VARCHAR2(55) | EagleML/accountingTransaction/accountingAccruedIncome/clsEventId |
earnedThruDate | Optional | date | 461 | ESTAR | ESTAR_INCOME_ACTIVITY | EARNED_THRU_DATE | DATE | EagleML/accountingTransaction/accountingAccruedIncome/earnedThruDate |
mnthlyAcctPerDate | Optional | date | 4733 | ESTAR | ESTAR_INCOME_ACTIVITY | MNTHLY_ACCT_PER_DATE | DATE | EagleML/accountingTransaction/accountingAccruedIncome/mnthlyAcctPerDate |
openEventId | Optional | string | 151 | ESTAR | ESTAR_INCOME_ACTIVITY | OPEN_EVENT_ID | VARCHAR2(55) | EagleML/accountingTransaction/accountingAccruedIncome/openEventId |
incomeInstance | Optional | integer | 11882 | ESTAR | ESTAR_INCOME_ACTIVITY | INSTANCE | NUMBER(38) | EagleML/accountingTransaction/accountingAccruedIncome/incomeInstance |
amortAtDispDeltaL | Optional | decimal | 11938 | ESTAR | ESTAR_INCOME_ACTIVITY | AMORT_AT_DISP_DELTA_L | NUMBER(38,12) | EagleML/accountingTransaction/accountingAccruedIncome/amortAtDispDeltaL |
amortAtDispDeltaB | Optional | decimal | 11939 | ESTAR | ESTAR_INCOME_ACTIVITY | AMORT_AT_DISP_DELTA_B | NUMBER(38,12) | EagleML/accountingTransaction/accountingAccruedIncome/amortAtDispDeltaB |
costAmortizedIdLocal | Optional | decimal | 128 | ESTAR | ESTAR_INCOME_ACTIVITY | COST_AMORTIZED_ID_LOCAL | NUMBER(38,12) | EagleML/accountingTransaction/accountingAccruedIncome/costAmortizedIdLocal |
costAmortizedIdBase | Optional | decimal | 129 | ESTAR | ESTAR_INCOME_ACTIVITY | COST_AMORTIZED_ID_BASE | NUMBER(38,12) | EagleML/accountingTransaction/accountingAccruedIncome/costAmortizedIdBase |
costAmortizedAvgLocal | Optional | decimal | 130 | ESTAR | ESTAR_INCOME_ACTIVITY | COST_AMORTIZED_AVG_LOCAL | NUMBER(38,12) | EagleML/accountingTransaction/accountingAccruedIncome/costAmortizedAvgLocal |
costAmortizedAvgBase | Optional | decimal | 170 | ESTAR | ESTAR_INCOME_ACTIVITY | COST_AMORTIZED_AVG_BASE | NUMBER(38,12) | EagleML/accountingTransaction/accountingAccruedIncome/costAmortizedAvgBase |
daysInterestEarned | Optional | integer | 469 | ESTAR | ESTAR_INCOME_ACTIVITY | DAYS_INTEREST_EARNED | NUMBER(38) | EagleML/accountingTransaction/accountingAccruedIncome/daysInterestEarned |
accrDeltaLocal | Optional | decimal | 466 | ESTAR | ESTAR_INCOME_ACTIVITY | ACCR_DELTA_LOCAL | NUMBER(38,12) | EagleML/accountingTransaction/accountingAccruedIncome/accrDeltaLocal |
oidDeltaLocal | Optional | decimal | 579 | ESTAR | ESTAR_INCOME_ACTIVITY | OID_DELTA_LOCAL | NUMBER(38,12) | EagleML/accountingTransaction/accountingAccruedIncome/oidDeltaLocal |
amortDeltaLocal | Optional | decimal | 584 | ESTAR | ESTAR_INCOME_ACTIVITY | AMORT_DELTA_LOCAL | NUMBER(38,12) | EagleML/accountingTransaction/accountingAccruedIncome/amortDeltaLocal |
incomeTaxExpenseDeltaLocal | Optional | decimal | 857 | ESTAR | ESTAR_INCOME_ACTIVITY | INCOME_TAX_EXPENSE_DELTA_L | NUMBER(38,12) | EagleML/accountingTransaction/accountingAccruedIncome/incomeTaxExpenseDeltaLocal |
deferredIncomeDeltaLocal | Optional | decimal | 5357 | ESTAR | ESTAR_INCOME_ACTIVITY | DEFERRED_INCOME_DELTA_L | NUMBER(38,12) | EagleML/accountingTransaction/accountingAccruedIncome/deferredIncomeDeltaLocal |
cancelFlag | Optional | string | 10045 | not stored in DB | Â | EagleML/accountingTransaction/accountingAccruedIncome/cancelFlag |