Accounting Accrued Income Data Map Table

Owned by Natalie Gesin (Deactivated)
Last updated: Oct 25, 2024 by Kinga Huszno
1 min read

Element

Optional/Required

Value Type 

Star Tag

Eagle DB

DB Table

DB Field

Data Type

Xpath

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

Entity Common Id Model

 

 

 

 

 

 

 

EagleML/accountingTransaction/accountingAccruedIncome/

Asset Identifiers Model

 

 

 

 

 

 

 

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

Â