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)

EagleML/accountingTransaction/settledCashActivity/incomeBreakageOver

otherFeeLocal

Optional

decimal

3752

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

OTHER_FEE_LOCAL

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/otherFeeLocal

stampDutyTaxLocal

Optional

decimal

51

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

STAMP_DUTY_TAX_L

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/stampDutyTaxLocal

commAmountLocal

Optional

decimal

47

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

COMM_AMT_L

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/commAmountLocal

taxAmountLocal

Optional

decimal

46

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

TAX_AMT_L

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/taxAmountLocal

secFee

Optional

decimal

48

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

SEC_FEE

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/secFee

backupPrice

Optional

decimal

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

BKUP_PRICE

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/backupPrice

settleAmountLocal

Optional

decimal

5363

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

SETTLE_AMOUNT_LOCAL

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/settleAmountLocal

brokerCode

Optional

string

88

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

BROKER_CODE

CHAR(20)

EagleML/accountingTransaction/settledCashActivity/brokerCode

dividendRate

Optional

decimal

368

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

DIVIDEND_RATE

NUMBER(28,12)

EagleML/accountingTransaction/settledCashActivity/dividendRate

currencyGain

Optional

decimal

198

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

GAIN_CURRENCY

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/currencyGain

currencyLoss

Optional

decimal

199

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

LOSS_CURRENCY

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/currencyLoss

localAssetCurrency

Optional

CurrencyCode

9061

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

LOCAL_ASSET_CURRENCY

VARCHAR2(3)

EagleML/accountingTransaction/settledCashActivity/localAssetCurrency

masterTicketNumber

Optional

string

761

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

MASTER_TICKET_NUMBER

VARCHAR2(55)

EagleML/accountingTransaction/settledCashActivity/masterTicketNumber

tradeDateFxRate

Optional

decimal

87

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

TRADE_DT_FX_RATE

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/tradeDateFxRate

corpActInstance

Optional

integer

4268

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

CORP_ACT_INSTANCE

NUMBER

EagleML/accountingTransaction/settledCashActivity/corpActInstance

netAmountBase

Optional

decimal

478

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

NET_AMOUNT_BASE

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/netAmountBase

principalAmountBase

Optional

decimal

169

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

PRINCIPAL_AMOUNT_BASE

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/principalAmountBase

incomeAmountBase

Optional

decimal

1986

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

INCOME_AMOUNT_BASE

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/incomeAmountBase

recPayAccount

Optional

string

1825

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

REC_PAY_ACCT

VARCHAR2(10)

EagleML/accountingTransaction/settledCashActivity/recPayAccount

recPayAccountDesc

Optional

string

1651

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

REC_PAY_ACCT_DESC

VARCHAR2(100)

EagleML/accountingTransaction/settledCashActivity/recPayAccountDesc

reclaimAmountBase

Optional

decimal

851

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

RECLAIM_AMOUNT_BASE

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/reclaimAmountBase

taxExpenseBase

Optional

decimal

854

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

TAX_EXPENSE_BASE

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/taxExpenseBase

breakageAmountUnderBase

Optional

decimal

1995

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

BREAKAGE_AMT_UNDER_B

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/breakageAmountUnderBase

breakageAmountOverBase

Optional

decimal

1997

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

BREAKAGE_AMT_OVER_B

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/breakageAmountOverBase

recPayAmountLocal

Optional

decimal

11781

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

REC_PAY_AMT_L

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/recPayAmountLocal

recPayAmountBase

Optional

decimal

11782

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

REC_PAY_AMT_B

NUMBER(38,6)

EagleML/accountingTransaction/settledCashActivity/recPayAmountBase

clearingBroker

Optional

string

1236

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

CLEARING_BROKER

VARCHAR2(50)

EagleML/accountingTransaction/settledCashActivity/clearingBroker

taxReclaimRate

Optional

decimal

1296

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

TAX_RECLAIM_RATE

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/taxReclaimRate

taxWithholdingRate

Optional

decimal

1295

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

TAX_WITHHOLDING_RATE

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/taxWithholdingRate

specialReclaimRate

Optional

decimal

1298

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

SPECIAL_RECLAIM_RATE

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/specialReclaimRate

specialWithholdingRate

Optional

decimal

1297

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

SPECIAL_WITHHOLDING_RATE

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/specialWithholdingRate

sourceEventId

Optional

TransactionId

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

SOURCE_REFERENCE_ID

VARCHAR2(55)

EagleML/accountingTransaction/settledCashActivity/sourceEventId

targetAccountDate

Optional

date

119

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

TARGET_ACCT_DATE

DATE

EagleML/accountingTransaction/settledCashActivity/targetAccountDate

gainSwapLocal

Optional

decimal

11819

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

GAIN_SWAP_L

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/gainSwapLocal

lossSwapLocal

Optional

decimal

11821

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

LOSS_SWAP_L

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/lossSwapLocal

gainSwapBase

Optional

decimal

11820

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

GAIN_SWAP_B

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/gainSwapBase

lossSwapBase

Optional

decimal

11822

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

LOSS_SWAP_B

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/lossSwapBase

termLoanFeeIncLocal

Optional

decimal

844

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

TERM_LOAN_FEE_INC_L

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/termLoanFeeIncLocal

termLoanFeeIncBase

Optional

decimal

845

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

TERM_LOAN_FEE_INC_B

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/termLoanFeeIncBase

termLoanFeeExpLocal

Optional

decimal

846

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

TERM_LOAN_FEE_EXP_L

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/termLoanFeeExpLocal

termLoanFeeExpBase

Optional

decimal

847

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

TERM_LOAN_FEE_EXP_B

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/termLoanFeeExpBase

commAmountBase

Optional

decimal

498

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

COMM_AMT_B

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/commAmountBase

otherFeeBase

Optional

decimal

5708

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

OTHER_FEE_B

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/otherFeeBase

secFeeBase

Optional

decimal

10122

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

SEC_FEE_B

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/secFeeBase

stampDutyTaxBase

Optional

decimal

10121

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

STAMP_DUTY_TAX_B

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/stampDutyTaxBase

fedTaxWithholdingBase

Optional

decimal

8078

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

FED_TAX_WITHHOLD_B

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/fedTaxWithholdingBase

stTaxWithholdingBase

Optional

decimal

8079

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

ST_TAX_WITHHOLD_B

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/stTaxWithholdingBase

streamSecAlias

Optional

integer

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

STREAM_SEC_ALIAS

NUMBER(38)

EagleML/accountingTransaction/settledCashActivity/streamSecAlias

taxAmountBase

Optional

decimal

10759

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

TAX_AMT_B

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/taxAmountBase

buWithholdingLocal

Optional

decimal

2712

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

BU_WTHHLD_L

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/buWithholdingLocal

buWithholdingBase

Optional

decimal

2713

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

BU_WTHHLD_B

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/buWithholdingBase

buWithholdingRate

Optional

decimal

2762

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

BU_WTHHLD_RATE

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/buWithholdingRate

price

Optional

decimal

45

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

PRICE

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/price

cancelType

Optional

string

2981

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

CANCEL_TYPE

VARCHAR2(1)

EagleML/accountingTransaction/settledCashActivity/cancelType

cancelFlag

Optional

string

10045

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

CANCEL_FLAG

VARCHAR2(1)

EagleML/accountingTransaction/settledCashActivity/cancelFlag

couponDate

Optional

date

3460

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

COUPON_DATE

DATE

EagleML/accountingTransaction/settledCashActivity/couponDate

cashEventSpawned

Optional

string

751

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

CASH_EVENT_SPAWNED

VARCHAR2(1)

EagleML/accountingTransaction/settledCashActivity/cashEventSpawned

backupCouponEndDate

Optional

date

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

BKUP_COUPON_END_DATE

DATE

EagleML/accountingTransaction/settledCashActivity/backupCouponEndDate

origContSettleDate

Optional

date

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

ORIG_CONT_SETTLE_DT

DATE

EagleML/accountingTransaction/settledCashActivity/origContSettleDate

periodicDistType

Optional

string

1737

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

PERIODIC_DIST_TYPE

VARCHAR2(2)

EagleML/accountingTransaction/settledCashActivity/periodicDistType

costLotOpenEventId

Optional

TransactionId

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

COST_LOT_OPEN_EVT_ID

VARCHAR2(55)

EagleML/accountingTransaction/settledCashActivity/costLotOpenEventId

costLotCloseEventId

Optional

TransactionId

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

COST_LOT_CLOSE_EVT_ID

VARCHAR2(55)

EagleML/accountingTransaction/settledCashActivity/costLotCloseEventId

corpActionType

Optional

string

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

CORP_ACTION_TYPE

VARCHAR2(50)

EagleML/accountingTransaction/settledCashActivity/corpActionType

cashAccountName

Optional

string

11696

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

CASH_ACCT_NAME

VARCHAR2(50)

EagleML/accountingTransaction/settledCashActivity/cashAccountName

cashAccount

Optional

string

11697

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

CASH_ACCT

VARCHAR2(20)

EagleML/accountingTransaction/settledCashActivity/cashAccount

cashAccountAlias

Optional

integer

11698

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

CASH_ACCT_ALIAS

NUMBER(38)

EagleML/accountingTransaction/settledCashActivity/cashAccountAlias

srcSysC

Optional

string

98

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

SRC_SYS_C

VARCHAR2(25)

EagleML/accountingTransaction/settledCashActivity/srcSysC

settleCashDivUgl

Optional

decimal

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

STL_CASH_DIV_UGL

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/settleCashDivUgl

breakageUnderLocal

Optional

decimal

1994

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

BREAKAGE_AMT_UNDER_L

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/breakageUnderLocal

breakageOverLocal

Optional

decimal

1996

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

BREAKAGE_AMT_OVER_L

NUMBER(38,12)

EagleML/accountingTransaction/settledCashActivity/breakageOverLocal

tradedDate

Optional

date

35

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

TRADE_DATE

DATE

EagleML/accountingTransaction/settledCashActivity/tradedDate

cashMatchInstance

Optional

integer

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

CASH_MATCH_INSTANCE

NUMBER(38)

EagleML/accountingTransaction/settledCashActivity/cashMatchInstance

calcTransactionId

Optional

string

2983

EagleML/accountingTransaction/settledCashActivity/calcTransactionId

calcMasterTransactionId

Optional

string

2984

EagleML/accountingTransaction/settledCashActivity/calcMasterTransactionId

calcCancelTransactionId

Optional

string

2985

EagleML/accountingTransaction/settledCashActivity/calcCancelTransactionId

assetToBaseFxRate

Optional

decimal

not stored in DB

EagleML/accountingTransaction/settledCashActivity/assetToBaseFxRate

custodyBankAccountNumber

Optional

string

RULESDBO

ENTITY_CUSTODY_RELATIONSHIP

CUSTODY_BANK_ACCT_NUM

VARCHAR2(30)

EagleML/accountingTransaction/settledCashActivity/custodyBankAccountNumber

custodyBankCode

Optional

string

RULESDBO

ENTITY_CUSTODY_RELATIONSHIP

CUSTODY_BANK_CODE

CHAR(20)

EagleML/accountingTransaction/settledCashActivity/custodyBankCode

custodyBankDesc

Optional

string

RULESDBO

ENTITY_CUSTODY_RELATIONSHIP

CUSTODY_BANK_DESC

CHAR(50)

EagleML/accountingTransaction/settledCashActivity/custodyBankDesc