Settled Cash Activity Data Map Table

objectType

Optional

ObjectTypeEnum

not stored in DB

EagleML/accountingTransaction/settledCashActivity/objectType

objectId

Optional

ObjectId

not stored in DB

EagleML/accountingTransaction/settledCashActivity/objectId

objectDescription

Optional

FeedTypeEnum

not stored in DB

EagleML/accountingTransaction/settledCashActivity/objectDescription

updateTimestamp

Optional

dateTime

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

SYSTEM_DATE

DATE

EagleML/accountingTransaction/settledCashActivity/updateTimestamp

customElements

Optional

CustomElements -  ComplexType

EagleML/accountingTransaction/settledCashActivity/customElements

updateSource

Required

string

944

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

UPDATE_SOURCE

VARCHAR2(32)

EagleML/accountingTransaction/settledCashActivity/updateSource

Entity Common Id Model

EagleML/accountingTransaction/settledCashActivity/

Entity Properties Model (extract only)

EagleML/accountingTransaction/settledCashActivity/

Asset Identifiers Model

EagleML/accountingTransaction/settledCashActivity/

Extended Asset Properties Model (extract only)

EagleML/accountingTransaction/settledCashActivity/

Extended CA Properties Model (extract only)

EagleML/accountingTransaction/settledCashActivity/

effectiveDate

Optional

date

1109

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

EFFECTIVE_DT

DATE

EagleML/accountingTransaction/settledCashActivity/effectiveDate

instance

Optional

integer

9388

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

INSTANCE

NUMBER(38)

EagleML/accountingTransaction/settledCashActivity/instance

localCurrency

Optional

CurrencyCode

63

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

LOCAL_CURR

VARCHAR2(3)

EagleML/accountingTransaction/settledCashActivity/localCurrency

baseCurrency

Optional

CurrencyCode

86

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

BASE_CURR

VARCHAR2(3)

EagleML/accountingTransaction/settledCashActivity/baseCurrency

accountingBasis

Optional

string

21

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

ACCT_BASIS

VARCHAR2(5)

EagleML/accountingTransaction/settledCashActivity/accountingBasis

longShortC

Optional

string

15

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

LNG_SHT_C

CHAR(1)

EagleML/accountingTransaction/settledCashActivity/longShortC

backupSrcSysC

Optional

string

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

BKUP_SRC_SYS_C

CHAR(1)

EagleML/accountingTransaction/settledCashActivity/backupSrcSysC

starPositionId

Optional

integer

830

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

POSN_ID

NUMBER(28)

EagleML/accountingTransaction/settledCashActivity/starPositionId

settleAsset

Optional

Asset Identifiers Model - (see extra table)

EagleML/accountingTransaction/settledCashActivity/settleAsset/

shareClass

Optional

string

34

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

SHARE_CLASS

VARCHAR2(10)

EagleML/accountingTransaction/settledCashActivity/shareClass

eventId

Optional

TransactionId

25

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

EVENT_ID

VARCHAR2(55)

EagleML/accountingTransaction/settledCashActivity/eventId

starEventType

Optional

string

2362

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

EVENT_TYPE

VARCHAR2(25)

EagleML/accountingTransaction/settledCashActivity/starEventType

eventType

Optional

string

53

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

CASH_EVT_TYP

VARCHAR2(10)

EagleML/accountingTransaction/settledCashActivity/eventType

eventSequence

Optional

integer

126

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

EVENT_SEQUENCE

NUMBER(28)

EagleML/accountingTransaction/settledCashActivity/eventSequence

processDate

Optional

date

30

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

PROCESS_DT

DATE

EagleML/accountingTransaction/settledCashActivity/processDate

accountingDate

Optional

date

36

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

ACCOUNT_DT

DATE

EagleML/accountingTransaction/settledCashActivity/accountingDate

monthEndAccountingDate

Optional

date

4733

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

MONTH_END_ACCT_DT

DATE

EagleML/accountingTransaction/settledCashActivity/monthEndAccountingDate

units

Optional

decimal

40

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

UNITS

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/units

amount

Optional

decimal

50

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

AMOUNT

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/amount

principal

Optional

decimal

165

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

PRINCIPAL

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/principal

income

Optional

decimal

1985

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

INCOME

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/income

navId

Optional

integer

3196

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

NAV_ID

NUMBER

EagleML/accountingTransaction/settledCashActivity/navId

cashStatus

Optional

string

54

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

CASH_STATUS

VARCHAR2(20)

EagleML/accountingTransaction/settledCashActivity/cashStatus

cashCategory

Optional

string

62

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

CASH_CATEGORY

VARCHAR2(50)

EagleML/accountingTransaction/settledCashActivity/cashCategory

bankAlias

Optional

string

16

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

BANK_ALIAS

VARCHAR2(25)

EagleML/accountingTransaction/settledCashActivity/bankAlias

autoSettleIndicator

Optional

YesNoOptionEnum

58

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

AUTO_SETTLE_INDICATOR

VARCHAR2(2)

EagleML/accountingTransaction/settledCashActivity/autoSettleIndicator

corpActionId

Optional

integer

60

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

CORP_ACTION_ID

NUMBER(22)

EagleML/accountingTransaction/settledCashActivity/corpActionId

ledgerBalanceEntitlement

Optional

string

3970

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

LDGR_BAL_ENTITLEMENT

VARCHAR2(1)

EagleML/accountingTransaction/settledCashActivity/ledgerBalanceEntitlement

accountingPlan

Optional

integer

999

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

ACCTG_PLAN

NUMBER

EagleML/accountingTransaction/settledCashActivity/accountingPlan

positingPlan

Optional

integer

913

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

POSTING_PLAN

NUMBER

EagleML/accountingTransaction/settledCashActivity/positingPlan

recPayPlan

Optional

string

1831

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

REC_PAY_PLAN

VARCHAR2(15)

EagleML/accountingTransaction/settledCashActivity/recPayPlan

withholdingLocal

Optional

decimal

853

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

WITHHOLDING_L

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/withholdingLocal

reclaimLocal

Optional

decimal

852

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

RECLAIM_L

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/reclaimLocal

reclaimMethod

Optional

string

3912

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

RECLAIM_METHOD

CHAR(2)

EagleML/accountingTransaction/settledCashActivity/reclaimMethod

batchEventId

Optional

TransactionId

701

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

BATCH_EVENT_ID

VARCHAR2(55)

EagleML/accountingTransaction/settledCashActivity/batchEventId

contSettleDate

Optional

date

9968

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

CONT_SETTLE_DT

DATE

EagleML/accountingTransaction/settledCashActivity/contSettleDate

linkEventId

Optional

TransactionId

28

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

LINK_EVENT_ID

VARCHAR2(55)

EagleML/accountingTransaction/settledCashActivity/linkEventId

targetEventId

Optional

string

36

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

TARGET_EVT_ID

VARCHAR2(55)

EagleML/accountingTransaction/settledCashActivity/targetEventId

eventReason

Optional

string

56

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

EVENT_REASON

VARCHAR2(55)

EagleML/accountingTransaction/settledCashActivity/eventReason

cancelEventId

Optional

TransactionId

501

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

CANCEL_EVT_ID

VARCHAR2(55)

EagleML/accountingTransaction/settledCashActivity/cancelEventId

cancelSequence

Optional

integer

226

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

CANCEL_SEQUENCE

NUMBER(28)

EagleML/accountingTransaction/settledCashActivity/cancelSequence

recPayAccount2

Optional

string

1826

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

REC_PAY_ACCT2

VARCHAR2(10)

EagleML/accountingTransaction/settledCashActivity/recPayAccount2

principalBreakageUnder

Optional

decimal

10134

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

PRINCIPAL_BREAKAGE_UNDER

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/principalBreakageUnder

principalBreakageOver

Optional

decimal

10135

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

PRINCIPAL_BREAKAGE_OVER

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/principalBreakageOver

incomeBreakageUnder

Optional

decimal

10136

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

INCOME_BREAKAGE_UNDER

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/incomeBreakageUnder

incomeBreakageOver

Optional

decimal

10137

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

INCOME_BREAKAGE_OVER

NUMBER(38,6)