Accounting Cash Journal Data Map Table

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

Please note that elements in the data map table below can be populated from different database tables depending on the <reportView> element set in the control message (either 'TRADED' or 'SETTLED').

Element

Value Type 

Star Tag

Eagle DB

DB Table

DB Field

Data Type

Xpath

Element

Value Type 

Star Tag

Eagle DB

DB Table

DB Field

Data Type

Xpath

objectType

ObjectTypeEnum

 

Hardcoded Value = AccountingCashJournal

 

EagleML/accountingTransaction/accountingCashJournal/objectType

objectId

ObjectId

 

Hardcoded Value = AccountingCashJournal

 

EagleML/accountingTransaction/accountingCashJournal/objectId

objectDescription

FeedTypeEnum

 

Hardcoded Value = ACCOUNTING

 

EagleML/accountingTransaction/accountingCashJournal/objectDescription

updateTimestamp

dateTime

 

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

SYSTEM_DATE

DATE

EagleML/accountingTransaction/accountingCashJournal/updateTimestamp

updateSource

string

944

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

UPDATE_SOURCE

VARCHAR2(32)

EagleML/accountingTransaction/accountingCashJournal/updateSource

Entity Common Id Model

EagleML/accountingTransaction/accountingCashJournal/

Asset Identifiers Model

EagleML/accountingTransaction/accountingCashJournal/

Asset Properties Model

EagleML/accountingTransaction/accountingCashJournal/

maturityDate

date

38

SECURITYDBO

SECURITY_MASTER

MAT_DATE

DATE

EagleML/accountingTransaction/accountingCashJournal/maturityDate

effectiveDate

date

 

 

 

 

 

EagleML/accountingTransaction/accountingCashJournal/effectiveDate

instance

integer

9388

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

INSTANCE

 

EagleML/accountingTransaction/accountingCashJournal/instance

ESTAR_SETTLED_CASH_ACTIVITY

localCurrency

CurrencyCode

85

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

LOCAL_CURR

VARCHAR2(3)

EagleML/accountingTransaction/accountingCashJournal/localCurrency

ESTAR_SETTLED_CASH_ACTIVITY

baseCurrency

CurrencyCode

86

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

BASE_CURR

VARCHAR2(3)

EagleML/accountingTransaction/accountingCashJournal/baseCurrency

ESTAR_SETTLED_CASH_ACTIVITY

accountingBasis

string

21

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

ACCT_BASIS

VARCHAR2(5)

EagleML/accountingTransaction/accountingCashJournal/accountingBasis

ESTAR_SETTLED_CASH_ACTIVITY

longShortC

string

15

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

LNG_SHT_C

CHAR(1)

EagleML/accountingTransaction/accountingCashJournal/longShortC

ESTAR_SETTLED_CASH_ACTIVITY

backupSrcSysC

string

 

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

BKUP_SRC_SYS_C

 

EagleML/accountingTransaction/accountingCashJournal/backupSrcSysC

ESTAR_SETTLED_CASH_ACTIVITY

starPositionId

integer

830

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

POSN_ID

 

EagleML/accountingTransaction/accountingCashJournal/starPositionId

ESTAR_SETTLED_CASH_ACTIVITY

settleAsset

Asset Identifiers Model - see extra table

ESTAR_TRADED_CASH_ACTIVITY

 

 

EagleML/accountingTransaction/accountingCashJournal/settleAsset/

ESTAR_SETTLED_CASH_ACTIVITY

shareClass

string

34

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

SHARE_CLASS

VARCHAR2(10)

EagleML/accountingTransaction/accountingCashJournal/shareClass

ESTAR_SETTLED_CASH_ACTIVITY

eventId

TransactionId

25

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

EVENT_ID

VARCHAR2(55)

EagleML/accountingTransaction/accountingCashJournal/eventId

ESTAR_SETTLED_CASH_ACTIVITY

starEventType

string

2362

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

EVENT_TYPE

VARCHAR2(25)

EagleML/accountingTransaction/accountingCashJournal/starEventType

ESTAR_SETTLED_CASH_ACTIVITY

eventType

string

53

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

CASH_EVT_TYP

VARCHAR2(10)

EagleML/accountingTransaction/accountingCashJournal/eventType

ESTAR_SETTLED_CASH_ACTIVITY

eventSequence

integer

126

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

EVENT_SEQUENCE

 

EagleML/accountingTransaction/accountingCashJournal/

ESTAR_SETTLED_CASH_ACTIVITY

processDate

date

30

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

PROCESS_DT

DATE

EagleML/accountingTransaction/accountingCashJournal/processDate

ESTAR_SETTLED_CASH_ACTIVITY

accountingDate

date

36

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

ACCOUNT_DT

DATE

EagleML/accountingTransaction/accountingCashJournal/accountingDate

ESTAR_SETTLED_CASH_ACTIVITY

monthEndAccountingDate

date

4733

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

MONTH_END_ACCT_DT

DATE

EagleML/accountingTransaction/accountingCashJournal/monthEndAccountingDate

ESTAR_SETTLED_CASH_ACTIVITY

units

decimal

40

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

UNITS

NUMBER(38,6)

EagleML/accountingTransaction/accountingCashJournal/units

ESTAR_SETTLED_CASH_ACTIVITY

amount

decimal

50

Calculated Value - Tag 50 = ESTAR_TRADED_CASH_ACTIVITY.AMOUNT + ESTAR_SETTLED_CASH_ACTIVITY.BREAKAGE_AMT_UNDER_B + ESTAR_SETTLED_CASH_ACTIVITY.BREAKAGE_AMT_OVER_B

EagleML/accountingTransaction/accountingCashJournal/amount

Calculated Value - Tag 50 = SUM(ESTAR_TRADED_CASH_ACTIVITY.NET_AMOUNT_BASE)\SUM(ESTAR_SETTLED_CASH_ACTIVITY.NET_AMOUNT_BASE)

principal*
(supported in  2017R1)

decimal

165

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

PRINCIPAL

 

EagleML/accountingTransaction/accountingCashJournal/principal

ESTAR_SETTLED_CASH_ACTIVITY

 

income

decimal

1985

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

INCOME

NUMBER(38,6)

EagleML/accountingTransaction/accountingCashJournal/income

ESTAR_SETTLED_CASH_ACTIVITY

navId

integer

3196

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

NAV_ID

 

EagleML/accountingTransaction/accountingCashJournal/navId

ESTAR_SETTLED_CASH_ACTIVITY

cashStatus

string

54

Hardcode Value - TRADED for payables and receivables, SETTLED - for disbursements and receipts

EagleML/accountingTransaction/accountingCashJournal/cashStatus

cashCategory

string

62

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

CASH_CATEGORY

VARCHAR2(50)

EagleML/accountingTransaction/accountingCashJournal/cashCategory

ESTAR_SETTLED_CASH_ACTIVITY

bankAlias

string

16

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

BANK_ALIAS

 

EagleML/accountingTransaction/accountingCashJournal/bankAlias

ESTAR_SETTLED_CASH_ACTIVITY

autoSettleIndicator

YesNoOptionEnum

58

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

AUTO_SETTLE_INDICATOR

VARCHAR2(2)

EagleML/accountingTransaction/accountingCashJournal/autoSettleIndicator

ESTAR_SETTLED_CASH_ACTIVITY

corpActionId

integer

60

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

CORP_ACTION_ID

 

EagleML/accountingTransaction/accountingCashJournal/corpActionId

ESTAR_SETTLED_CASH_ACTIVITY

ledgerBalanceEntitlement

string

3970

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

LDGR_BAL_ENTITLEMENT

 

EagleML/accountingTransaction/accountingCashJournal/ledgerBalanceEntitlement

ESTAR_SETTLED_CASH_ACTIVITY

accountingPlan

integer

999

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

ACCTG_PLAN

 

EagleML/accountingTransaction/accountingCashJournal/accountingPlan

ESTAR_SETTLED_CASH_ACTIVITY

positingPlan

integer

913

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

POSTING_PLAN

 

EagleML/accountingTransaction/accountingCashJournal/positingPlan

ESTAR_SETTLED_CASH_ACTIVITY

recPayPlan

string

1831

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

REC_PAY_PLAN

VARCHAR2(15)

EagleML/accountingTransaction/accountingCashJournal/recPayPlan

ESTAR_SETTLED_CASH_ACTIVITY

withholdingLocal

decimal

853

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

WITHHOLDING_L

NUMBER(38,6)

EagleML/accountingTransaction/accountingCashJournal/withholdingLocal

ESTAR_SETTLED_CASH_ACTIVITY

reclaimLocal

decimal

852

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

RECLAIM_L

NUMBER(38,6)

EagleML/accountingTransaction/accountingCashJournal/reclaimLocal

ESTAR_SETTLED_CASH_ACTIVITY

reclaimMethod

string

3912

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

RECLAIM_METHOD

CHAR(2)

EagleML/accountingTransaction/accountingCashJournal/reclaimMethod

ESTAR_SETTLED_CASH_ACTIVITY

batchEventId

string

701

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

BATCH_EVENT_ID

 

EagleML/accountingTransaction/accountingCashJournal/batchEventId

ESTAR_SETTLED_CASH_ACTIVITY

contSettleDate

date

9968

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

CONT_SETTLE_DT

DATE

EagleML/accountingTransaction/accountingCashJournal/contSettleDate

ESTAR_SETTLED_CASH_ACTIVITY

linkEventId

TransactionId

28

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

LINK_EVENT_ID

VARCHAR2(55)

EagleML/accountingTransaction/accountingCashJournal/linkEventId

ESTAR_SETTLED_CASH_ACTIVITY

targetEventId

string

26

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

TARGET_EVT_ID

VARCHAR2(55)

EagleML/accountingTransaction/accountingCashJournal/targetEventId

ESTAR_SETTLED_CASH_ACTIVITY

eventReason

string

56

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

EVENT_REASON

VARCHAR2(55)

EagleML/accountingTransaction/accountingCashJournal/eventReason

ESTAR_SETTLED_CASH_ACTIVITY

cancelEventId

TransactionId

501

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

CANCEL_EVT_ID

 

EagleML/accountingTransaction/accountingCashJournal/cancelEventId

ESTAR_SETTLED_CASH_ACTIVITY

cancelSequence

integer

226

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

CANCEL_SEQUENCE

 

EagleML/accountingTransaction/accountingCashJournal/cancelSequence

ESTAR_SETTLED_CASH_ACTIVITY

recPayAccount2

string

1826

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

REC_PAY_ACCT2

 

EagleML/accountingTransaction/accountingCashJournal/recPayAccount2

ESTAR_SETTLED_CASH_ACTIVITY

principalBreakageUnder

decimal

10134

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

PRINCIPAL_BREAKAGE_UNDER

 

EagleML/accountingTransaction/accountingCashJournal/principalBreakageUnder

ESTAR_SETTLED_CASH_ACTIVITY

principalBreakageOver

decimal

10135

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

PRINCIPAL_BREAKAGE_OVER

 

EagleML/accountingTransaction/accountingCashJournal/principalBreakageOver

ESTAR_SETTLED_CASH_ACTIVITY

incomeBreakageUnder

decimal

10136

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

INCOME_BREAKAGE_UNDER

 

EagleML/accountingTransaction/accountingCashJournal/incomeBreakageUnder

ESTAR_SETTLED_CASH_ACTIVITY

incomeBreakageOver

decimal

10137

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

INCOME_BREAKAGE_OVER

 

EagleML/accountingTransaction/accountingCashJournal/incomeBreakageOver

ESTAR_SETTLED_CASH_ACTIVITY

otherFeeLocal

decimal

3752

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

OTHER_FEE_LOCAL

NUMBER(38,6)

EagleML/accountingTransaction/accountingCashJournal/otherFeeLocal

ESTAR_SETTLED_CASH_ACTIVITY

stampDutyTaxLocal

decimal

51

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

STAMP_DUTY_TAX_L

NUMBER(38,6)

EagleML/accountingTransaction/accountingCashJournal/stampDutyTaxLocal

ESTAR_SETTLED_CASH_ACTIVITY

commAmountLocal

decimal

47

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

COMM_AMT_L

NUMBER(38,6)

EagleML/accountingTransaction/accountingCashJournal/commAmountLocal

ESTAR_SETTLED_CASH_ACTIVITY

taxAmountLocal

decimal

46

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

TAX_AMT_L

NUMBER(38,6)

EagleML/accountingTransaction/accountingCashJournal/taxAmountLocal

ESTAR_SETTLED_CASH_ACTIVITY

secFee

decimal

48

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

SEC_FEE

NUMBER(38,6)

EagleML/accountingTransaction/accountingCashJournal/secFee

ESTAR_SETTLED_CASH_ACTIVITY

backupPrice

decimal

 

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

BKUP_PRICE

 

EagleML/accountingTransaction/accountingCashJournal/backupPrice

ESTAR_SETTLED_CASH_ACTIVITY

settleAmountLocal

decimal

5363

Hardcode Value - 0

EagleML/accountingTransaction/accountingCashJournal/settleAmountLocal

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

AMOUNT

NUMBER(38,6)

brokerCode

string

88

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

BROKER_CODE

CHAR(20)

EagleML/accountingTransaction/accountingCashJournal/brokerCode

ESTAR_SETTLED_CASH_ACTIVITY

dividendRate

decimal

5897

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

DIVIDEND_RATE

NUMBER(28,12)

EagleML/accountingTransaction/accountingCashJournal/dividendRate

ESTAR_SETTLED_CASH_ACTIVITY

currencyGain

decimal

198

Calculated Value - Tag 198 = SUM(SETTLED_CASH_DISP_LOTS.CURRENCY_GAIN)

EagleML/accountingTransaction/accountingCashJournal/currencyGain

currencyLoss

decimal

199

Calculated Value - Tag 198 = SUM(SETTLED_CASH_DISP_LOTS.CURRENCY_LOSS)

EagleML/accountingTransaction/accountingCashJournal/currencyLoss

localAssetCurrency

CurrencyCode

9061

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

LOCAL_ASSET_CURRENCY

VARCHAR2(3)

EagleML/accountingTransaction/accountingCashJournal/localAssetCurrency

ESTAR_SETTLED_CASH_ACTIVITY

masterTicketNumber

string

761

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

MASTER_TICKET_NUMBER

VARCHAR2(55)

EagleML/accountingTransaction/accountingCashJournal/masterTicketNumber

ESTAR_SETTLED_CASH_ACTIVITY

tradeDateFxRate

decimal

87

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

TRADE_DT_FX_RATE

NUMBER(38,12)

EagleML/accountingTransaction/accountingCashJournal/tradeDateFxRate

ESTAR_SETTLED_CASH_ACTIVITY

corpActInstance

integer

4268

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

CORP_ACT_INSTANCE

 

EagleML/accountingTransaction/accountingCashJournal/corpActInstance

ESTAR_SETTLED_CASH_ACTIVITY

netAmountBase

decimal

478

Calculated Value - Tag 478 = amount(Tag 50)/Current Fx Rate

EagleML/accountingTransaction/accountingCashJournal/netAmountBase

SUM(ESTAR_TRADED_CASH_ACTIVITY.NET_AMOUNT_BASE)\SUM(ESTAR_SETTLED_CASH_ACTIVITY.NET_AMOUNT_BASE)

principalAmountBase*
(supported in  2017R1)

decimal

169

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

PRINCIPAL_AMOUNT_BASE

NUMBER(38,6)

EagleML/accountingTransaction/accountingCashJournal/principalAmountBase

ESTAR_SETTLED_CASH_ACTIVITY

incomeAmountBase

decimal

1986

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

INCOME_AMOUNT_BASE

NUMBER(38,6)

EagleML/accountingTransaction/accountingCashJournal/incomeAmountBase

ESTAR_SETTLED_CASH_ACTIVITY

recPayAccount

string

1825

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

REC_PAY_ACCT

 

EagleML/accountingTransaction/accountingCashJournal/recPayAccount

ESTAR_SETTLED_CASH_ACTIVITY

recPayAccountDesc

string

1651

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

REC_PAY_ACCT_DESC

 

EagleML/accountingTransaction/accountingCashJournal/recPayAccountDesc

ESTAR_SETTLED_CASH_ACTIVITY

reclaimAmountBase

decimal

851

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

RECLAIM_AMOUNT_BASE

NUMBER(38,6)

EagleML/accountingTransaction/accountingCashJournal/reclaimAmountBase

ESTAR_SETTLED_CASH_ACTIVITY

taxExpenseBase

decimal

854

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

TAX_EXPENSE_BASE

NUMBER(38,6)

EagleML/accountingTransaction/accountingCashJournal/taxExpenseBase

ESTAR_SETTLED_CASH_ACTIVITY

breakageAmountUnderBase

decimal

1995

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

BREAKAGE_AMT_UNDER_B

NUMBER(38,6)

EagleML/accountingTransaction/accountingCashJournal/breakageAmountUnderBase

ESTAR_SETTLED_CASH_ACTIVITY

breakageAmountOverBase

decimal

1997

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

BREAKAGE_AMT_OVER_B

NUMBER(38,6)

EagleML/accountingTransaction/accountingCashJournal/breakageAmountOverBase

ESTAR_SETTLED_CASH_ACTIVITY

recPayAmountLocal

decimal

11781

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

REC_PAY_AMT_L

 

EagleML/accountingTransaction/accountingCashJournal/recPayAmountLocal

ESTAR_SETTLED_CASH_ACTIVITY

recPayAmountBase

decimal

11782

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

REC_PAY_AMT_B

 

EagleML/accountingTransaction/accountingCashJournal/recPayAmountBase

ESTAR_SETTLED_CASH_ACTIVITY

clearingBroker

string

1236

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

CLEARING_BROKER

VARCHAR2(50)

EagleML/accountingTransaction/accountingCashJournal/clearingBroker

ESTAR_SETTLED_CASH_ACTIVITY

taxReclaimRate

decimal

1296

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

TAX_RECLAIM_RATE

NUMBER(38,12)

EagleML/accountingTransaction/accountingCashJournal/taxReclaimRate

ESTAR_SETTLED_CASH_ACTIVITY

taxWithholdingRate

decimal

1295

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

TAX_WITHHOLDING_RATE

NUMBER(38,12)

EagleML/accountingTransaction/accountingCashJournal/taxWithholdingRate

ESTAR_SETTLED_CASH_ACTIVITY

specialReclaimRate

decimal

1298

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

SPECIAL_RECLAIM_RATE

NUMBER(38,12)

EagleML/accountingTransaction/accountingCashJournal/specialReclaimRate

ESTAR_SETTLED_CASH_ACTIVITY

specialWithholdingRate

decimal

1297

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

SPECIAL_WITHHOLDING_RATE

NUMBER(38,12)

EagleML/accountingTransaction/accountingCashJournal/specialWithholdingRate

ESTAR_SETTLED_CASH_ACTIVITY

sourceEventId

TransactionId

 

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

SOURCE_EVENT_ID

 

EagleML/accountingTransaction/accountingCashJournal/sourceEventId

ESTAR_SETTLED_CASH_ACTIVITY

SOURCE_REFERENCE_ID

 

targetAccountDate

date

119

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

TARGET_ACCT_DATE

 

EagleML/accountingTransaction/accountingCashJournal/targetAccountDate

ESTAR_SETTLED_CASH_ACTIVITY

gainSwapLocal

decimal

11819

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

GAIN_SWAP_L

NUMBER(38,12)

EagleML/accountingTransaction/accountingCashJournal/gainSwapLocal

ESTAR_SETTLED_CASH_ACTIVITY

lossSwapLocal

decimal

11821

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

LOSS_SWAP_L

NUMBER(38,12)

EagleML/accountingTransaction/accountingCashJournal/lossSwapLocal

ESTAR_SETTLED_CASH_ACTIVITY

gainSwapBase

decimal

11820

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

GAIN_SWAP_B

NUMBER(38,12)

EagleML/accountingTransaction/accountingCashJournal/gainSwapBase

ESTAR_SETTLED_CASH_ACTIVITY

lossSwapBase

decimal

11822

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

LOSS_SWAP_B

NUMBER(38,12)

EagleML/accountingTransaction/accountingCashJournal/lossSwapBase

ESTAR_SETTLED_CASH_ACTIVITY

termLoanFeeIncLocal

decimal

844

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

TERM_LOAN_FEE_INC_L

NUMBER(38,12)

EagleML/accountingTransaction/accountingCashJournal/termLoanFeeIncLocal

ESTAR_SETTLED_CASH_ACTIVITY

termLoanFeeIncBase

decimal

845

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

TERM_LOAN_FEE_INC_B

NUMBER(38,12)

EagleML/accountingTransaction/accountingCashJournal/termLoanFeeIncBase

ESTAR_SETTLED_CASH_ACTIVITY

termLoanFeeExpLocal

decimal

846

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

TERM_LOAN_FEE_EXP_L

NUMBER(38,12)

EagleML/accountingTransaction/accountingCashJournal/termLoanFeeExpLocal

ESTAR_SETTLED_CASH_ACTIVITY

termLoanFeeExpBase

decimal

847

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

TERM_LOAN_FEE_EXP_B

NUMBER(38,12)

EagleML/accountingTransaction/accountingCashJournal/termLoanFeeExpBase

ESTAR_SETTLED_CASH_ACTIVITY

commAmountBase

decimal

498

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

COMM_AMT_B

NUMBER(38,12)

EagleML/accountingTransaction/accountingCashJournal/commAmountBase

ESTAR_SETTLED_CASH_ACTIVITY

otherFeeBase

decimal

5708

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

OTHER_FEE_B

NUMBER(38,12)

EagleML/accountingTransaction/accountingCashJournal/otherFeeBase

ESTAR_SETTLED_CASH_ACTIVITY

secFeeBase

decimal

10122

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

SEC_FEE_B

NUMBER(38,12)

EagleML/accountingTransaction/accountingCashJournal/secFeeBase

ESTAR_SETTLED_CASH_ACTIVITY

stampDutyTaxBase

decimal

10121

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

STAMP_DUTY_TAX_B

NUMBER(38,12)

EagleML/accountingTransaction/accountingCashJournal/stampDutyTaxBase

ESTAR_SETTLED_CASH_ACTIVITY

fedTaxWithholdingBase

decimal

8078

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

FED_TAX_WITHHOLD_B

NUMBER(38,12)

EagleML/accountingTransaction/accountingCashJournal/fedTaxWithholdingBase

ESTAR_SETTLED_CASH_ACTIVITY

stTaxWithholdingBase

decimal

8079

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

ST_TAX_WITHHOLD_B

NUMBER(38,12)

EagleML/accountingTransaction/accountingCashJournal/stTaxWithholdingBase

ESTAR_SETTLED_CASH_ACTIVITY

streamSecAlias

integer

 

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

STREAM_SEC_ALIAS

 

EagleML/accountingTransaction/accountingCashJournal/streamSecAlias

ESTAR_SETTLED_CASH_ACTIVITY

taxAmountBase

decimal

10759

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

TAX_AMT_B

NUMBER(38,12)

EagleML/accountingTransaction/accountingCashJournal/taxAmountBase

ESTAR_SETTLED_CASH_ACTIVITY

buWithholdingLocal

decimal

2712

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

BU_WTHHLD_L

NUMBER(38,12)

EagleML/accountingTransaction/accountingCashJournal/buWithholdingLocal

ESTAR_SETTLED_CASH_ACTIVITY

buWithholdingBase

decimal

2713

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

BU_WTHHLD_B

NUMBER(38,12)

EagleML/accountingTransaction/accountingCashJournal/buWithholdingBase

ESTAR_SETTLED_CASH_ACTIVITY

buWithholdingRate

decimal

2762

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

BU_WTHHLD_RATE

NUMBER(38,12)

EagleML/accountingTransaction/accountingCashJournal/buWithholdingRate

ESTAR_SETTLED_CASH_ACTIVITY

price

decimal

45

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

PRICE

NUMBER(38,12)

EagleML/accountingTransaction/accountingCashJournal/price

ESTAR_SETTLED_CASH_ACTIVITY

cancelType

string

2981

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

CANCEL_TYPE

 

EagleML/accountingTransaction/accountingCashJournal/cancelType

ESTAR_SETTLED_CASH_ACTIVITY

cancelFlag

YesNoOptionEnum

10045

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

CANCEL_FLAG

 

EagleML/accountingTransaction/accountingCashJournal/cancelFlag

ESTAR_SETTLED_CASH_ACTIVITY

couponDate

date

3460

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

COUPON_DATE

 

EagleML/accountingTransaction/accountingCashJournal/couponDate

ESTAR_SETTLED_CASH_ACTIVITY

cashEventSpawned

string

751

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

CASH_EVENT_SPAWNED

VARCHAR2(1)

EagleML/accountingTransaction/accountingCashJournal/cashEventSpawned

ESTAR_SETTLED_CASH_ACTIVITY

backupCouponEndDate

date

 

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

BKUP_COUPON_END_DATE

 

EagleML/accountingTransaction/accountingCashJournal/backupCouponEndDate

ESTAR_SETTLED_CASH_ACTIVITY

origContSettleDate

date

 

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

ORIG_CONT_SETTLE_DT

 

EagleML/accountingTransaction/accountingCashJournal/origContSettleDate

ESTAR_SETTLED_CASH_ACTIVITY

periodicDistType

string

1737

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

PERIODIC_DIST_TYPE

 

EagleML/accountingTransaction/accountingCashJournal/periodicDistType

ESTAR_SETTLED_CASH_ACTIVITY

costLotOpenEventId

TransactionId

 

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

COST_LOT_OPEN_EVT_ID

 

EagleML/accountingTransaction/accountingCashJournal/costLotOpenEventId

ESTAR_SETTLED_CASH_ACTIVITY

costLotCloseEventId

TransactionId

 

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

COST_LOT_CLOSE_EVT_ID

 

EagleML/accountingTransaction/accountingCashJournal/costLotCloseEventId

ESTAR_SETTLED_CASH_ACTIVITY

corpActionType

string

 

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

CORP_ACTION_TYPE

 

EagleML/accountingTransaction/accountingCashJournal/corpActionType

ESTAR_SETTLED_CASH_ACTIVITY

cashAccountName

string

11696

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

CASH_ACCT_NAME

 

EagleML/accountingTransaction/accountingCashJournal/cashAccountName

ESTAR_SETTLED_CASH_ACTIVITY

cashAccount

string

11697

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

CASH_ACCT

 

EagleML/accountingTransaction/accountingCashJournal/cashAccount

ESTAR_SETTLED_CASH_ACTIVITY

cashAccountAlias

integer

11698

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

CASH_ACCT_ALIAS

 

EagleML/accountingTransaction/accountingCashJournal/cashAccountAlias

ESTAR_SETTLED_CASH_ACTIVITY

srcSysC

string

98

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

SRC_SYS_C

 

EagleML/accountingTransaction/accountingCashJournal/srcSysC

ESTAR_SETTLED_CASH_ACTIVITY

detailIndicator

string

8468

Hardcode Value - "TRADED ACTIVITY"

EagleML/accountingTransaction/accountingCashJournal/detailIndicator

Hardcode Value - "SETTLED ACTIVITY"

settlementDate

date

37

Hardcode Value - ""

EagleML/accountingTransaction/accountingCashJournal/settlementDate

ESTAR

ESTAR_SETTLED_CASH_ACTIVITY

EFFECTIVE_DT

DATE

tradedDate

date

35

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

EFFECTIVE_DT

DATE

EagleML/accountingTransaction/accountingCashJournal/tradedDate

ESTAR_TRADED_CASH_ACTIVITY\
ESTAR_SETTLED_CASH_ACTIVITY

breakageUnderLocal

decimal

1994

Calculated Value - Tag 1994 = ESTAR_TRADED_CASH_ACTIVITY.PRINCIPAL_BREAKAGE_UNDER + ESTAR_TRADED_CASH_ACTIVITY.INCOME_BREAKAGE_UNDER

 

EagleML/accountingTransaction/accountingCashJournal/breakageUnderLocal

ESTAR_SETTLED_CASH_ACTIVITY

BREAKAGE_AMT_UNDER_L

NUMBER(38,12)

 

breakageOverLocal

decimal

1996

Calculated Value - Tag 1996 = ESTAR_TRADED_CASH_ACTIVITY.PRINCIPAL_BREAKAGE_OVER + ESTAR_TRADED_CASH_ACTIVITY.INCOME_BREAKAGE_OVER

 

EagleML/accountingTransaction/accountingCashJournal/breakageOverLocal

ESTAR_SETTLED_CASH_ACTIVITY

BREAKAGE_AMT_OVER_L

NUMBER(38,12)

 

recPayCategory

string

1827

ESTAR

ESTAR_TRADED_CASH_ACTIVITY

REC_PAY_ACCT_DESC

VARCHAR2(100)

EagleML/accountingTransaction/accountingCashJournal/recPayCategory

ESTAR_SETTLED_CASH_ACTIVITY

REC_PAY_ACCT_DESC

VARCHAR2(100)

currentFxRate

decimal

96

Calculated Value(Default SP - get_spot_rate) - Current Fx Rate

EagleML/accountingTransaction/accountingCashJournal/currentFxRate

fxRate

decimal

484

Calculated Value - Tag 484 = Fx Rate for Date (ESTAR_TRADED_CASH_ACTIVITY.EFFECTIVE_DT)

EagleML/accountingTransaction/accountingCashJournal/fxRate

ESTAR_SETTLED_CASH_ACTIVITY

TRADE_DT_FX_RATE

NUMBER(38,12)

 

totalRealizedGainLossBase

decimal

5507

Calculated Value - Tag 5507 = SETTLED_CASH_DISP_LOTS.CURRENCY_GAIN - SETTLED_CASH_DISP_LOTS.CURRENCY_LOSS

EagleML/accountingTransaction/accountingCashJournal/totalRealizedGainLossBase

totalGainLossId

decimal

178

Calculated Value - Tag 178 = ESTAR_SETTLED_CASH_ACTIVITY.GAIN_CURRENCY - ESTAR_SETTLED_CASH_ACTIVITY.LOSS_CURRENCY

EagleML/accountingTransaction/accountingCashJournal/totalGainLossId

settledUrglTotalBase

decimal

11053

Hardcode Value - 0

EagleML/accountingTransaction/accountingCashJournal/settledUrglTotalBase

settleAmountBase

decimal

479

Hardcode Value - 0

EagleML/accountingTransaction/accountingCashJournal/settleAmountBase

Calculated Value - Tag 479 = amount(Tag 5363)/Current Fx Rate

tradedNetAmountLocal

decimal

11779

Calculated Value - Tag 11779 = amount + Tag 1997 - Tag 1995

EagleML/accountingTransaction/accountingCashJournal/tradedNetAmountLocal

Hardcode Value - 0

tradedNetAmountBase

decimal

11780

Calculated Value - Tag 11780 = Tag 11779/Current Fx Rate

EagleML/accountingTransaction/accountingCashJournal/tradedNetAmountBase

Hardcode Value - 0

netAmountBaseNew

decimal

4309

Calculated Value - Tag 4309 = Tag 478 + Tag 5507 + Tag 178(for unsettled) + Tag 50/(End date Fx Rate)(for settled)

EagleML/accountingTransaction/accountingCashJournal/netAmountBaseNew

Calculated Value - Tag 4309 = Tag 479 + Tag 5507

notionalResetType

decimal

4409

SECURITYDBO

SWAPS

NOTIONAL_RESET_TYPE

 

EagleML/accountingTransaction/accountingCashJournal/notionalResetType

reportType

decimal

1257

Calculated Value - ACCTGDT = Accounting Date; MONTHDT = Month End Date; POSTDT = Post Date; SETTLEDT = Settlement Date; TRADEDT = Trade Date;

EagleML/accountingTransaction/accountingCashJournal/reportType

regulatoryCategory

decimal

12387

RULESDBO

ENTITY_ACCT_BASIS_HIST

REGULATORY_CATEGORY

VARCHAR2(30)

EagleML/accountingTransaction/accountingCashJournal/regulatoryCategory

regulatoryCategoryChanged

string

891

 

 

 

 

EagleML/accountingTransaction/accountingCashJournal/regulatoryCategoryChanged

coupon

decimal

70

SECURITYDBO

SECURITY_MASTER

COUPON

 

EagleML/accountingTransaction/accountingCashJournal/coupon

quantityScale

decimal

19

SECURITYDBO

SECURITY_MASTER

TRADING_UNIT

 

EagleML/accountingTransaction/accountingCashJournal/quantityScale

quantityType

StringWithCodeScheme

12

SECURITYDBO

SECURITY_MASTER

QUANTITY_TYPE

 

EagleML/accountingTransaction/accountingCashJournal/quantityType

priceMultiplier

decimal

18

SECURITYDBO

SECURITY_MASTER

PRICE_MULTIPLIER

 

EagleML/accountingTransaction/accountingCashJournal/priceMultiplier

dayCountBasis

DayCountFraction

471

SECURITYDBO

SECURITY_MASTER

DAY_CNT

 

EagleML/accountingTransaction/accountingCashJournal/dayCountBasis

paymentFrequencyCode

StringWithCodeScheme

472

SECURITYDBO

SECURITY_MASTER

COUPON_FREQ_CODE

 

EagleML/accountingTransaction/accountingCashJournal/paymentFrequencyCode

varRateFreqCode

string

1788

SECURITYDBO

FIXED_INCOME

VAR_RATE_FREQ_CODE

 

EagleML/accountingTransaction/accountingCashJournal/varRateFreqCode

payRecIndicator

string

4590

SECURITYDBO

SWAPS

PAY_RECEIVE_IND

 

EagleML/accountingTransaction/accountingCashJournal/payRecIndicator

optiondescr

string

1364

 

 

 

 

EagleML/accountingTransaction/accountingCashJournal/optiondescr

interestPaymentTiming

StringWithCodeScheme

1523

SECURITYDBO

FIXED_INCOME

ACCRUAL_METHOD

 

EagleML/accountingTransaction/accountingCashJournal/interestPaymentTiming

businessDayConvention

BusinessDayConventionEnum

1536

SECURITYDBO

FIXED_INCOME

INTEREST_METHOD_CODE

 

EagleML/accountingTransaction/accountingCashJournal/businessDayConvention

businessCalendarName

string

1480

 

 

 

 

EagleML/accountingTransaction/accountingCashJournal/businessCalendarName

premiumType

string

3302

SECURITYDBO

DERIVATIVES

PREMIUM_TYPE

 

EagleML/accountingTransaction/accountingCashJournal/premiumType

sectorName

string

1156

 

 

 

 

EagleML/accountingTransaction/accountingCashJournal/sectorName

reportView

string

7009

resolved by panel

 

 

 

EagleML/accountingTransaction/accountingCashJournal/reportView

startDate

date

220

resolved by panel

 

 

 

EagleML/accountingTransaction/accountingCashJournal/startDate

endDate

date

221

resolved by panel

 

 

 

EagleML/accountingTransaction/accountingCashJournal/endDate