Realized Gain Loss Data Map Table

Please note, that some fields * are supported for extract only starting from DB version >= v17R2.27.

Element

Optional/Required

Value Type

Star Tag

Xpath

Element

Optional/Required

Value Type

Star Tag

Xpath

objectType

 

ObjectTypeEnum

 

EagleML/accountingTransaction/realizedGainLoss/objectType

objectId

 

ObjectId

 

EagleML/accountingTransaction/realizedGainLoss/objectId

objectDescription

 

FeedTypeEnum

 

EagleML/accountingTransaction/realizedGainLoss/objectDescription

updateTimestamp

 

dateTime

 

EagleML/accountingTransaction/realizedGainLoss/updateTimestamp

customElements

 

CustomElements

 

EagleML/accountingTransaction/realizedGainLoss/customElements

updateSource

 

string

 

EagleML/accountingTransaction/realizedGainLoss/updateSource

tagNochangecase

 

string

 

EagleML/accountingTransaction/realizedGainLoss/tagNochangecase

Entity Common Id Model

EagleML/accountingTransaction/realizedGainLoss/

Entity Properties Model

EagleML/accountingTransaction/realizedGainLoss/

accountingBasis

 

string

 

EagleML/accountingTransaction/realizedGainLoss/accountingBasis

regulatoryCategory

 

string

12387

EagleML/accountingTransaction/realizedGainLoss/regulatoryCategory

regulatoryCategoryChanged

 

string

891

EagleML/accountingTransaction/realizedGainLoss/regulatoryCategoryChanged

startDate

 

date

 

EagleML/accountingTransaction/realizedGainLoss/startDate

endDate

 

date

 

EagleML/accountingTransaction/realizedGainLoss/endDate

weight

 

decimal

4232

EagleML/accountingTransaction/realizedGainLoss/weight

sourceName

 

string

1102

EagleML/accountingTransaction/realizedGainLoss/sourceName

startComments

 

string

12075

EagleML/accountingTransaction/realizedGainLoss/startComments

endComments

 

string

2520

EagleML/accountingTransaction/realizedGainLoss/endComments

entityDetailId

 

string

5

EagleML/accountingTransaction/realizedGainLoss/entityDetailId

Asset Identifiers Model

EagleML/accountingTransaction/realizedGainLoss/

Asset Properties Model

EagleML/accountingTransaction/realizedGainLoss/

userGroup19

 

string

10000

EagleML/accountingTransaction/realizedGainLoss/userGroup19

quantityScale

 

decimal

19

EagleML/accountingTransaction/realizedGainLoss/quantityScale

maturityDate

 

date

38

EagleML/accountingTransaction/realizedGainLoss/maturityDate

effectiveDate

 

date

1109

EagleML/accountingTransaction/realizedGainLoss/effectiveDate

updateSwitch

 

string

1076

EagleML/accountingTransaction/realizedGainLoss/updateSwitch

closeOpenEventId

 

TransactionId

181

EagleML/accountingTransaction/realizedGainLoss/closeOpenEventId

closeEventId

 

TransactionId

182

EagleML/accountingTransaction/realizedGainLoss/closeEventId

longShortIndicator

 

LongShortIndicatorEnum

15

EagleML/accountingTransaction/realizedGainLoss/longShortIndicator

lotSelectionMethod

 

string

27

EagleML/accountingTransaction/realizedGainLoss/lotSelectionMethod

xrefExchange

 

ExchangeCode

1981

EagleML/accountingTransaction/realizedGainLoss/xrefExchange

smInactiveFlag

 

YesNoOptionEnum

11043

EagleML/accountingTransaction/realizedGainLoss/smInactiveFlag

localCurrency

 

CurrencyCode

 

EagleML/accountingTransaction/realizedGainLoss/localCurrency

tradeDate

 

date

35

EagleML/accountingTransaction/realizedGainLoss/tradeDate

ledgerEffectiveDate

 

date

36

EagleML/accountingTransaction/realizedGainLoss/ledgerEffectiveDate

settlementDate

 

date

 

EagleML/accountingTransaction/realizedGainLoss/settlementDate

transactionCode

 

string

2283

EagleML/accountingTransaction/realizedGainLoss/transactionCode

masterTicketNumber

 

string

761

EagleML/accountingTransaction/realizedGainLoss/masterTicketNumber

numberofLots

 

integer

192

EagleML/accountingTransaction/realizedGainLoss/numberofLots

exchangeCode

 

in_exchange_code

17

EagleML/accountingTransaction/realizedGainLoss/exchangeCode

postType

 

string

24

EagleML/accountingTransaction/realizedGainLoss/postType

targetEventId

 

TransactionId

26

EagleML/accountingTransaction/realizedGainLoss/targetEventId

linkEventId

 

TransactionId

28

EagleML/accountingTransaction/realizedGainLoss/linkEventId

postDate

 

date

30

EagleML/accountingTransaction/realizedGainLoss/postDate

originalFaceValue

 

decimal

41

EagleML/accountingTransaction/realizedGainLoss/originalFaceValue

settlementLocation

 

string

43

EagleML/accountingTransaction/realizedGainLoss/settlementLocation

taxes

 

decimal

46

EagleML/accountingTransaction/realizedGainLoss/taxes

localCommissionAmount

 

decimal

47

EagleML/accountingTransaction/realizedGainLoss/localCommissionAmount

exchangeFee

 

decimal

48

EagleML/accountingTransaction/realizedGainLoss/exchangeFee

accruedInterest

 

decimal

49

EagleML/accountingTransaction/realizedGainLoss/accruedInterest

netCash

 

decimal

50

EagleML/accountingTransaction/realizedGainLoss/netCash

otherFee

 

decimal

51

EagleML/accountingTransaction/realizedGainLoss/otherFee

tradeStatus

 

string

54

EagleML/accountingTransaction/realizedGainLoss/tradeStatus

trade_memo2

 

string

56

EagleML/accountingTransaction/realizedGainLoss/trade_memo2

settlementCurrency

 

CurrencyCode

63

EagleML/accountingTransaction/realizedGainLoss/settlementCurrency

settlementAmount

 

decimal

64

EagleML/accountingTransaction/realizedGainLoss/settlementAmount

settlement_exchange_rate

 

decimal

79

EagleML/accountingTransaction/realizedGainLoss/settlement_exchange_rate

fxRateOpen

 

decimal

84

EagleML/accountingTransaction/realizedGainLoss/fxRateOpen

fxRate

 

decimal

87

EagleML/accountingTransaction/realizedGainLoss/fxRate

brokerCode

 

BrokerCode

88

EagleML/accountingTransaction/realizedGainLoss/brokerCode

unitCostBase

 

decimal

4643

EagleML/accountingTransaction/realizedGainLoss/unitCostBase

costLocal

 

decimal

162

EagleML/accountingTransaction/realizedGainLoss/costLocal

costBase

 

decimal

166

EagleML/accountingTransaction/realizedGainLoss/costBase

unitOpenPrice

 

decimal

160

EagleML/accountingTransaction/realizedGainLoss/unitOpenPrice

unitCostLocal

 

decimal

4642

EagleML/accountingTransaction/realizedGainLoss/unitCostLocal

price

 

decimal

45

EagleML/accountingTransaction/realizedGainLoss/price

tradeAmount

 

decimal

190

EagleML/accountingTransaction/realizedGainLoss/tradeAmount

settleAmount0

 

decimal

191

EagleML/accountingTransaction/realizedGainLoss/settleAmount0

closeHoldingPeriodDate

 

date

192

EagleML/accountingTransaction/realizedGainLoss/closeHoldingPeriodDate

parOrShares

 

decimal

 

EagleML/accountingTransaction/realizedGainLoss/parOrShares

premiumAllocatedLocal

 

decimal

203

EagleML/accountingTransaction/realizedGainLoss/premiumAllocatedLocal

premiumAllocated

 

decimal

 

EagleML/accountingTransaction/realizedGainLoss/premiumAllocated

origAcqDate

 

date

216

EagleML/accountingTransaction/realizedGainLoss/origAcqDate

gainLossTerm

 

string

238

EagleML/accountingTransaction/realizedGainLoss/gainLossTerm

openCostBasisType

 

string

281

EagleML/accountingTransaction/realizedGainLoss/openCostBasisType

closeCostBasisType

 

string

282

EagleML/accountingTransaction/realizedGainLoss/closeCostBasisType

tradeBaseAmount

 

decimal

478

EagleML/accountingTransaction/realizedGainLoss/tradeBaseAmount

amortLocal

 

decimal

521

EagleML/accountingTransaction/realizedGainLoss/amortLocal

amortBase

 

decimal

522

EagleML/accountingTransaction/realizedGainLoss/amortBase

clientId

 

string

1632

EagleML/accountingTransaction/realizedGainLoss/clientId

feeAmt

 

decimal

3752

EagleML/accountingTransaction/realizedGainLoss/feeAmt

principalFactor

 

decimal

4483

EagleML/accountingTransaction/realizedGainLoss/principalFactor

tipIncomeLtdLocal

 

decimal

4538

EagleML/accountingTransaction/realizedGainLoss/tipIncomeLtdLocal

tipIncomeLtdBase

 

decimal

4539

EagleML/accountingTransaction/realizedGainLoss/tipIncomeLtdBase

bookValueLocal

 

decimal

4601

EagleML/accountingTransaction/realizedGainLoss/bookValueLocal

bookValue

 

decimal

3767

EagleML/accountingTransaction/realizedGainLoss/bookValue

monthEndDate

 

date

4733

EagleML/accountingTransaction/realizedGainLoss/monthEndDate

oidLocal

 

decimal

5502

EagleML/accountingTransaction/realizedGainLoss/oidLocal

oidBase

 

decimal

5503

EagleML/accountingTransaction/realizedGainLoss/oidBase

totalAmortLocal

 

decimal

5685

EagleML/accountingTransaction/realizedGainLoss/totalAmortLocal

totalAmortBase

 

decimal

5686

EagleML/accountingTransaction/realizedGainLoss/totalAmortBase

gainCurrency988

 

decimal

5819

EagleML/accountingTransaction/realizedGainLoss/gainCurrency988

lossCurrency988

 

decimal

5820

EagleML/accountingTransaction/realizedGainLoss/lossCurrency988

originalSourceCode

 

string

9143

EagleML/accountingTransaction/realizedGainLoss/originalSourceCode

currencyGainInt

 

decimal

9736

EagleML/accountingTransaction/realizedGainLoss/currencyGainInt

currencyLossInt

 

decimal

9738

EagleML/accountingTransaction/realizedGainLoss/currencyLossInt

gainCurrency

 

decimal

10049

EagleML/accountingTransaction/realizedGainLoss/gainCurrency

gainSecurityLocal

 

decimal

10050

EagleML/accountingTransaction/realizedGainLoss/gainSecurityLocal

gainSecurity

 

decimal

10051

EagleML/accountingTransaction/realizedGainLoss/gainSecurity

lossCurrency

 

decimal

10052

EagleML/accountingTransaction/realizedGainLoss/lossCurrency

lossSecurityLocal

 

decimal

10053

EagleML/accountingTransaction/realizedGainLoss/lossSecurityLocal

lossSecurity

 

decimal

10054

EagleML/accountingTransaction/realizedGainLoss/lossSecurity

openCostLocal

 

decimal

10056

EagleML/accountingTransaction/realizedGainLoss/openCostLocal

openCostBase

 

decimal

10055

EagleML/accountingTransaction/realizedGainLoss/openCostBase

totalGain

 

decimal

10057

EagleML/accountingTransaction/realizedGainLoss/totalGain

totalLoss

 

decimal

10058

EagleML/accountingTransaction/realizedGainLoss/totalLoss

currBuiltinGlSec

 

decimal

9761

EagleML/accountingTransaction/realizedGainLoss/currBuiltinGlSec

currBuiltinGlCurrency

 

decimal

10917

EagleML/accountingTransaction/realizedGainLoss/currBuiltinGlCurrency

currBuiltinGlDeferred

 

decimal

10918

EagleML/accountingTransaction/realizedGainLoss/currBuiltinGlDeferred

currBuiltinGlOid

 

decimal

10919

EagleML/accountingTransaction/realizedGainLoss/currBuiltinGlOid

currBuiltinGlMktDisc

 

decimal

10920

EagleML/accountingTransaction/realizedGainLoss/currBuiltinGlMktDisc

acquisitionType

 

string

2425,7001

EagleML/accountingTransaction/realizedGainLoss/acquisitionType

allocProceedsBase

 

decimal

7660

EagleML/accountingTransaction/realizedGainLoss/allocProceedsBase

allocProceedsLocal

 

decimal

7661

EagleML/accountingTransaction/realizedGainLoss/allocProceedsLocal

allUpRate

 

decimal

7662

EagleML/accountingTransaction/realizedGainLoss/allUpRate

amortizationBase

 

decimal

7663

EagleML/accountingTransaction/realizedGainLoss/amortizationBase

amortizationLocal

 

decimal

7664

EagleML/accountingTransaction/realizedGainLoss/amortizationLocal

balance

 

decimal

7665

EagleML/accountingTransaction/realizedGainLoss/balance

baseCommissionAmount

 

decimal

7666

EagleML/accountingTransaction/realizedGainLoss/baseCommissionAmount

baseCostLot

 

decimal

7667

EagleML/accountingTransaction/realizedGainLoss/baseCostLot

baseRealizedGlCurr

 

decimal

7668

EagleML/accountingTransaction/realizedGainLoss/baseRealizedGlCurr

baseRealizedGlMkt

 

decimal

7669

EagleML/accountingTransaction/realizedGainLoss/baseRealizedGlMkt

baseInterestAdj

 

decimal

7670

EagleML/accountingTransaction/realizedGainLoss/baseInterestAdj

bnchYld1

 

decimal

7671

EagleML/accountingTransaction/realizedGainLoss/bnchYld1

bnchYld2

 

decimal

7672

EagleML/accountingTransaction/realizedGainLoss/bnchYld2

buyLotNbr

 

string

7002

EagleML/accountingTransaction/realizedGainLoss/buyLotNbr

cancelDueToCorrection

 

string

7003

EagleML/accountingTransaction/realizedGainLoss/cancelDueToCorrection

closeOutPl0

 

decimal

7673

EagleML/accountingTransaction/realizedGainLoss/closeOutPl0

closeoutpl1

 

decimal

7674

EagleML/accountingTransaction/realizedGainLoss/closeoutpl1

clsOpenCumExInd

 

string

7004

EagleML/accountingTransaction/realizedGainLoss/clsOpenCumExInd

compared

 

string

7005

EagleML/accountingTransaction/realizedGainLoss/compared

covFlag

 

string

2819

EagleML/accountingTransaction/realizedGainLoss/covFlag

creditLossB

 

decimal

2705

EagleML/accountingTransaction/realizedGainLoss/creditLossB

creditLossL

 

decimal

2704

EagleML/accountingTransaction/realizedGainLoss/creditLossL

disallowGainB

 

decimal

2434

EagleML/accountingTransaction/realizedGainLoss/disallowGainB

disallowGainL

 

decimal

2433

EagleML/accountingTransaction/realizedGainLoss/disallowGainL

disallowLossB

 

decimal

2431

EagleML/accountingTransaction/realizedGainLoss/disallowLossB

disallowLossL

 

decimal

2430

EagleML/accountingTransaction/realizedGainLoss/disallowLossL

discountRate

 

decimal

1314,7681

EagleML/accountingTransaction/realizedGainLoss/discountRate

dispBookValueGaap

 

decimal

7682

EagleML/accountingTransaction/realizedGainLoss/dispBookValueGaap

dispBookValueStat

 

decimal

7683

EagleML/accountingTransaction/realizedGainLoss/dispBookValueStat

eventSubPriority

 

integer

2862,7684

EagleML/accountingTransaction/realizedGainLoss/eventSubPriority

exchangeFeeBase

 

decimal

7685

EagleML/accountingTransaction/realizedGainLoss/exchangeFeeBase

fairMarketValueBase

 

decimal

2429,7686

EagleML/accountingTransaction/realizedGainLoss/fairMarketValueBase

fairMarketValueFlag

 

string

2427,7007

EagleML/accountingTransaction/realizedGainLoss/fairMarketValueFlag

fairMarketValueLocal

 

decimal

2428,7687

EagleML/accountingTransaction/realizedGainLoss/fairMarketValueLocal

fairMarketValuePrice

 

decimal

2452,7688

EagleML/accountingTransaction/realizedGainLoss/fairMarketValuePrice

federalTaxWithholdBase

 

decimal

7689

EagleML/accountingTransaction/realizedGainLoss/federalTaxWithholdBase

feeamtBase

 

decimal

7690

EagleML/accountingTransaction/realizedGainLoss/feeamtBase

gaapCostValue

 

decimal

7691

EagleML/accountingTransaction/realizedGainLoss/gaapCostValue

gaapSecType

 

string

7008

EagleML/accountingTransaction/realizedGainLoss/gaapSecType

gaapUnitCost

 

decimal

7692

EagleML/accountingTransaction/realizedGainLoss/gaapUnitCost

gainCurrencyAvg

 

decimal

7693

EagleML/accountingTransaction/realizedGainLoss/gainCurrencyAvg

gainCurrencyId

 

decimal

7694

EagleML/accountingTransaction/realizedGainLoss/gainCurrencyId

gainSecurityAvg

 

decimal

7695

EagleML/accountingTransaction/realizedGainLoss/gainSecurityAvg

gainSecurityAvgLocal

 

decimal

7696

EagleML/accountingTransaction/realizedGainLoss/gainSecurityAvgLocal

gainSecurityId

 

decimal

7697

EagleML/accountingTransaction/realizedGainLoss/gainSecurityId

gainSecurityIdLocal

 

decimal

7698

EagleML/accountingTransaction/realizedGainLoss/gainSecurityIdLocal

interestSold

 

decimal

 

EagleML/accountingTransaction/realizedGainLoss/interestSold

invertFlag

 

string

7009

EagleML/accountingTransaction/realizedGainLoss/invertFlag

letterConfirm

 

string

7010

EagleML/accountingTransaction/realizedGainLoss/letterConfirm

lettered

 

string

7011

EagleML/accountingTransaction/realizedGainLoss/lettered

localCostLot

 

decimal

7700

EagleML/accountingTransaction/realizedGainLoss/localCostLot

localGaapCostValue

 

decimal

7701

EagleML/accountingTransaction/realizedGainLoss/localGaapCostValue

localGaapUnitCost

 

decimal

7702

EagleML/accountingTransaction/realizedGainLoss/localGaapUnitCost

localRealizedGl

 

decimal

7703

EagleML/accountingTransaction/realizedGainLoss/localRealizedGl

lossCurrencyAvg

 

decimal

7704

EagleML/accountingTransaction/realizedGainLoss/lossCurrencyAvg

lossCurrencyId

 

decimal

7705

EagleML/accountingTransaction/realizedGainLoss/lossCurrencyId

lossSecurityAvg

 

decimal

7706

EagleML/accountingTransaction/realizedGainLoss/lossSecurityAvg

lossSecurityAvgLocal

 

decimal

7707

EagleML/accountingTransaction/realizedGainLoss/lossSecurityAvgLocal

lossSecurityId

 

decimal

7708

EagleML/accountingTransaction/realizedGainLoss/lossSecurityId

lossSecurityIdLocal

 

decimal

7709

EagleML/accountingTransaction/realizedGainLoss/lossSecurityIdLocal

margin

 

decimal

1483,7710

EagleML/accountingTransaction/realizedGainLoss/margin

marginPoints

 

decimal

7711

EagleML/accountingTransaction/realizedGainLoss/marginPoints

monthlyAccountingDate

 

date

7560

EagleML/accountingTransaction/realizedGainLoss/monthlyAccountingDate

mtType

 

string

7012

EagleML/accountingTransaction/realizedGainLoss/mtType

nonCreditLossB

 

decimal

7712

EagleML/accountingTransaction/realizedGainLoss/nonCreditLossB

nonCreditLossL

 

decimal

7713

EagleML/accountingTransaction/realizedGainLoss/nonCreditLossL

notionalAmt

 

decimal

7714

EagleML/accountingTransaction/realizedGainLoss/notionalAmt

openAcctDate

 

date

7561

EagleML/accountingTransaction/realizedGainLoss/openAcctDate

openEventId

 

TransactionId

7013

EagleML/accountingTransaction/realizedGainLoss/openEventId

openMonthlyAcctDate

 

date

7562

EagleML/accountingTransaction/realizedGainLoss/openMonthlyAcctDate

originalAcctDate

 

date

7563

EagleML/accountingTransaction/realizedGainLoss/originalAcctDate

originalEventId

 

TransactionId

7249

EagleML/accountingTransaction/realizedGainLoss/originalEventId

originalmonthlyAcctDate

 

date

7564

EagleML/accountingTransaction/realizedGainLoss/originalmonthlyAcctDate

otherFeeBase

 

decimal

7715

EagleML/accountingTransaction/realizedGainLoss/otherFeeBase

ownershipTransferDate

 

data

7565

EagleML/accountingTransaction/realizedGainLoss/ownershipTransferDate

paceTradeEventId

 

TransactionId

7014

EagleML/accountingTransaction/realizedGainLoss/paceTradeEventId

poolNumber

 

string

107,7015

EagleML/accountingTransaction/realizedGainLoss/poolNumber

positionId

 

integer

7716

EagleML/accountingTransaction/realizedGainLoss/positionId

priceCurrency

 

string

7016

EagleML/accountingTransaction/realizedGainLoss/priceCurrency

qtyWashSaleEligible

 

decimal

7717

EagleML/accountingTransaction/realizedGainLoss/qtyWashSaleEligible

quantity

 

decimal

163

EagleML/accountingTransaction/realizedGainLoss/quantity

realizedGlBase

 

decimal

7719

EagleML/accountingTransaction/realizedGainLoss/realizedGlBase

realizedGlCrB

 

decimal

7720

EagleML/accountingTransaction/realizedGainLoss/realizedGlCrB

realizedGlCrL

 

decimal

7721

EagleML/accountingTransaction/realizedGainLoss/realizedGlCrL

realizedGlLocal

 

decimal

7722

EagleML/accountingTransaction/realizedGainLoss/realizedGlLocal

realizedGlNcrB

 

decimal

7723

EagleML/accountingTransaction/realizedGainLoss/realizedGlNcrB

realizedGlNcrL

 

decimal

7724

EagleML/accountingTransaction/realizedGainLoss/realizedGlNcrL

recordType

 

string

9800,7017

EagleML/accountingTransaction/realizedGainLoss/recordType

settleAmt1

 

decimal

7725

EagleML/accountingTransaction/realizedGainLoss/settleAmt1

shortTermId

 

integer

7726

EagleML/accountingTransaction/realizedGainLoss/shortTermId

stateTaxWithholdBase

 

decimal

7727

EagleML/accountingTransaction/realizedGainLoss/stateTaxWithholdBase

targetPurchaseDate

 

date

914,7566

EagleML/accountingTransaction/realizedGainLoss/targetPurchaseDate

targetPurchasePrice

 

decimal

915,7728

EagleML/accountingTransaction/realizedGainLoss/targetPurchasePrice

taxesBase

 

decimal

7729

EagleML/accountingTransaction/realizedGainLoss/taxesBase

termLength

 

string

7018

EagleML/accountingTransaction/realizedGainLoss/termLength

totalCurrentLoss

 

decimal

7730

EagleML/accountingTransaction/realizedGainLoss/totalCurrentLoss

totalGainAvg

 

decimal

7731

EagleML/accountingTransaction/realizedGainLoss/totalGainAvg

totalGainId

 

decimal

7732

EagleML/accountingTransaction/realizedGainLoss/totalGainId

totalLossAvg

 

decimal

7733

EagleML/accountingTransaction/realizedGainLoss/totalLossAvg

totalLossId

 

decimal

7734

EagleML/accountingTransaction/realizedGainLoss/totalLossId

tradeFlat

 

string

7019

EagleML/accountingTransaction/realizedGainLoss/tradeFlat

tradersLogin

 

string

7020

EagleML/accountingTransaction/realizedGainLoss/tradersLogin

unitPriceOpen

 

decimal

7735

EagleML/accountingTransaction/realizedGainLoss/unitPriceOpen

updateUserId

 

string

7021

EagleML/accountingTransaction/realizedGainLoss/updateUserId

userDate1

 

date

7567

EagleML/accountingTransaction/realizedGainLoss/userDate1

userFloat1

 

decimal

7736

EagleML/accountingTransaction/realizedGainLoss/userFloat1

userFloat10

 

decimal

7737

EagleML/accountingTransaction/realizedGainLoss/userFloat10

userFloat11

 

decimal

7738

EagleML/accountingTransaction/realizedGainLoss/userFloat11

userFloat12

 

decimal

7739

EagleML/accountingTransaction/realizedGainLoss/userFloat12

userFloat13

 

decimal

7740

EagleML/accountingTransaction/realizedGainLoss/userFloat13

userFloat14

 

decimal

7741

EagleML/accountingTransaction/realizedGainLoss/userFloat14

userFloat15

 

decimal

7742

EagleML/accountingTransaction/realizedGainLoss/userFloat15

userFloat2

 

decimal

7743

EagleML/accountingTransaction/realizedGainLoss/userFloat2

userFloat3

 

decimal

7744

EagleML/accountingTransaction/realizedGainLoss/userFloat3

userFloat4

 

decimal

7745

EagleML/accountingTransaction/realizedGainLoss/userFloat4

userFloat5

 

decimal

7746

EagleML/accountingTransaction/realizedGainLoss/userFloat5

userFloat6

 

decimal

7747

EagleML/accountingTransaction/realizedGainLoss/userFloat6

userFloat7

 

decimal

7748

EagleML/accountingTransaction/realizedGainLoss/userFloat7

userFloat8

 

decimal

7749

EagleML/accountingTransaction/realizedGainLoss/userFloat8

userFloat9

 

decimal

7750

EagleML/accountingTransaction/realizedGainLoss/userFloat9

tradeId

 

integer

8353

EagleML/accountingTransaction/realizedGainLoss/tradeId

commissionCurrency

 

CurrencyCode

 

EagleML/accountingTransaction/realizedGainLoss/commissionCurrency

closeLotId

 

integer

14065

EagleML/accountingTransaction/realizedGainLoss/closeLotId

targetOriginalEventId

 

string

5032

EagleML/accountingTransaction/realizedGainLoss/targetOriginalEventId

tradeCurrency

 

CurrencyCode

85

EagleML/accountingTransaction/realizedGainLoss/tradeCurrency

closeOpenOrderNumber

 

string

4529

EagleML/accountingTransaction/realizedGainLoss/closeOpenOrderNumber

orderNumber

 

string

1092

EagleML/accountingTransaction/realizedGainLoss/orderNumber

calcMasterTransactionId

 

string

2984

EagleML/accountingTransaction/realizedGainLoss/calcMasterTransactionId

calcMasterCloseTransactionId

 

string

2985

EagleML/accountingTransaction/realizedGainLoss/calcMasterCloseTransactionId

gainSwapB

 

decimal

11820

EagleML/accountingTransaction/realizedGainLoss/gainSwapB

gainSwapL

 

decimal

11819

EagleML/accountingTransaction/realizedGainLoss/gainSwapL

gainLoss

 

decimal

1870,9152

EagleML/accountingTransaction/realizedGainLoss/gainLoss

lossSwapB

 

decimal

11822

EagleML/accountingTransaction/realizedGainLoss/lossSwapB

lossSwapL

 

decimal

11821

EagleML/accountingTransaction/realizedGainLoss/lossSwapL

baseCurrency

 

CurrencyCode

86

EagleML/accountingTransaction/realizedGainLoss/baseCurrency

srcIntfcInst

 

decimal

1168

EagleML/accountingTransaction/realizedGainLoss/srcIntfcInst

transactionType

 

normalizedString

2283

EagleML/accountingTransaction/realizedGainLoss/transactionType

ioIssuerAlias

 

string

1147

EagleML/accountingTransaction/realizedGainLoss/ioIssuerAlias

ioIssuerId

 

string

1144

EagleML/accountingTransaction/realizedGainLoss/ioIssuerId

lmtGlElg

 

string

2487

EagleML/accountingTransaction/realizedGainLoss/lmtGlElg

lmtGlInd

 

string

8553

EagleML/accountingTransaction/realizedGainLoss/lmtGlInd

impairmentLtdBase

 

decimal

2700

EagleML/accountingTransaction/realizedGainLoss/impairmentLtdBase

impairmentLtdLocal

 

decimal

2701

EagleML/accountingTransaction/realizedGainLoss/impairmentLtdLocal

impairmentGainBase*

 

decimal

2701

EagleML/accountingTransaction/realizedGainLoss/impairmentGainBase

impairmentGainLocal*

 

decimal

2700

EagleML/accountingTransaction/realizedGainLoss/impairmentGainLocal

impairmentLossBase*

 

decimal

9679

EagleML/accountingTransaction/realizedGainLoss/impairmentLossBase

impairmentLossLocal*

 

decimal

9678

EagleML/accountingTransaction/realizedGainLoss/impairmentLossLocal

amortizedCostPrevBase

 

decimal

2695

EagleML/accountingTransaction/realizedGainLoss/amortizedCostPrevBase

amortizedCostPrevLocal

 

decimal

2694

EagleML/accountingTransaction/realizedGainLoss/amortizedCostPrevLocal

granularityCategory

 

string

11476

EagleML/accountingTransaction/realizedGainLoss/granularityCategory

impairmentAmortOffsetB

 

decimal

2711

EagleML/accountingTransaction/realizedGainLoss/impairmentAmortOffsetB

impairmentAmortOffsetL

 

decimal

2710

EagleML/accountingTransaction/realizedGainLoss/impairmentAmortOffsetL

impairmentCostOffsetB

 

decimal

2707

EagleML/accountingTransaction/realizedGainLoss/impairmentCostOffsetB

impairmentCostOffsetL

 

decimal

2706

EagleML/accountingTransaction/realizedGainLoss/impairmentCostOffsetL

impairmentCostPrevB

 

decimal

2699

EagleML/accountingTransaction/realizedGainLoss/impairmentCostPrevB

impairmentCostPrevL

 

decimal

2698

EagleML/accountingTransaction/realizedGainLoss/impairmentCostPrevL

totalGainLocal

 

decimal

10050

EagleML/accountingTransaction/realizedGainLoss/totalGainLocal

totalLossLocal

 

decimal

10053

EagleML/accountingTransaction/realizedGainLoss/totalLossLocal

costMethod

 

string

22

EagleML/accountingTransaction/realizedGainLoss/costMethod

splitRatio

 

decimal

128

EagleML/accountingTransaction/realizedGainLoss/splitRatio

divAmt

 

decimal

190

EagleML/accountingTransaction/realizedGainLoss/divAmt

cpAddedAmt

 

decimal

189

EagleML/accountingTransaction/realizedGainLoss/cpAddedAmt

cpAmt

 

decimal

1686

EagleML/accountingTransaction/realizedGainLoss/cpAmt

cpCallAmt

 

decimal

4642

EagleML/accountingTransaction/realizedGainLoss/cpCallAmt

cpCallPx

 

decimal

191

EagleML/accountingTransaction/realizedGainLoss/cpCallPx

cpCash

 

decimal

129

EagleML/accountingTransaction/realizedGainLoss/cpCash

cpMsinkAmt

 

decimal

84

EagleML/accountingTransaction/realizedGainLoss/cpMsinkAmt

cpNewCpnRt

 

decimal

196

EagleML/accountingTransaction/realizedGainLoss/cpNewCpnRt

cpNname

 

string

1728

EagleML/accountingTransaction/realizedGainLoss/cpNname

cpNxtResetDt

 

date

505

EagleML/accountingTransaction/realizedGainLoss/cpNxtResetDt

cpPrevMdt

 

date

503

EagleML/accountingTransaction/realizedGainLoss/cpPrevMdt

cpSettleDt

 

date

37

EagleML/accountingTransaction/realizedGainLoss/cpSettleDt

userGroup2

 

string

182

EagleML/accountingTransaction/realizedGainLoss/userGroup2

fromFmvPrice

 

decimal

194

EagleML/accountingTransaction/realizedGainLoss/fromFmvPrice

toFmvPrice

 

decimal

195

EagleML/accountingTransaction/realizedGainLoss/toFmvPrice

cpAdjDt

 

date

216

EagleML/accountingTransaction/realizedGainLoss/cpAdjDt

batchEventId

 

string

2362

EagleML/accountingTransaction/realizedGainLoss/batchEventId

costAmtMethod

 

string

2425

EagleML/accountingTransaction/realizedGainLoss/costAmtMethod

consentRt

 

date

7708

EagleML/accountingTransaction/realizedGainLoss/consentRt

consentDt

 

date

8011

EagleML/accountingTransaction/realizedGainLoss/consentDt

cpCrncy1

 

string

63

EagleML/accountingTransaction/realizedGainLoss/cpCrncy1

limitGlIndicator

 

string

2427

EagleML/accountingTransaction/realizedGainLoss/limitGlIndicator

CxlMonthEndDate

 

date

8378

EagleML/accountingTransaction/realizedGainLoss/CxlMonthEndDate

cxlActFlag

 

string

985

EagleML/accountingTransaction/realizedGainLoss/cxlActFlag

reportType

 

string

1257

EagleML/accountingTransaction/realizedGainLoss/reportType

accountBasis

 

string

21

EagleML/accountingTransaction/realizedGainLoss/accountBasis

regCategoryChanged

 

string

891

EagleML/accountingTransaction/realizedGainLoss/regCategoryChanged

creditLossLocal

 

decimal

2783

EagleML/accountingTransaction/realizedGainLoss/creditLossLocal

creditLossBase

 

decimal

2784

EagleML/accountingTransaction/realizedGainLoss/creditLossBase

pydnGlAccnt

 

string

4519

EagleML/accountingTransaction/realizedGainLoss/pydnGlAccnt

priceMultiplier

 

decimal

18

EagleML/accountingTransaction/realizedGainLoss/priceMultiplier

coupon

 

decimal

70

EagleML/accountingTransaction/realizedGainLoss/coupon

subSecurityType

 

string

1464

EagleML/accountingTransaction/realizedGainLoss/subSecurityType

country

 

string

1418

EagleML/accountingTransaction/realizedGainLoss/country

riskClassificationType

 

string

11584

EagleML/accountingTransaction/realizedGainLoss/riskClassificationType

topEntityName

 

string

1159

EagleML/accountingTransaction/realizedGainLoss/topEntityName

bookValueBase

 

decimal

5839

EagleML/accountingTransaction/realizedGainLoss/bookValueBase

gainLossLocal

 

decimal

171

EagleML/accountingTransaction/realizedGainLoss/gainLossLocal

gainLossBase

 

decimal

175

EagleML/accountingTransaction/realizedGainLoss/gainLossBase

currGainLoss

 

decimal

5506

EagleML/accountingTransaction/realizedGainLoss/currGainLoss

currGainLossInt

 

decimal

429

EagleML/accountingTransaction/realizedGainLoss/currGainLossInt

currGainLoss988

 

decimal

5817

EagleML/accountingTransaction/realizedGainLoss/currGainLoss988

sectorName

 

string

1156

EagleML/accountingTransaction/realizedGainLoss/sectorName

settledFlag

 

string

7120

EagleML/accountingTransaction/realizedGainLoss/settledFlag

fxImpairment

 

decimal

16231

EagleML/accountingTransaction/realizedGainLoss/fxImpairment

longTermGainBase

 

decimal

3290

EagleML/accountingTransaction/realizedGainLoss/longTermGainBase

longTermGainLocal

 

decimal

3291

EagleML/accountingTransaction/realizedGainLoss/longTermGainLocal

longTermLossBase

 

decimal

3292

EagleML/accountingTransaction/realizedGainLoss/longTermLossBase

longTermLossLocal

 

decimal

3293

EagleML/accountingTransaction/realizedGainLoss/longTermLossLocal

shortTermGainBase

 

decimal

3279

EagleML/accountingTransaction/realizedGainLoss/shortTermGainBase

shortTermGainLocal

 

decimal

3280

EagleML/accountingTransaction/realizedGainLoss/shortTermGainLocal

shortTermLossBase

 

decimal

3288

EagleML/accountingTransaction/realizedGainLoss/shortTermLossBase

shortTermLossLocal

 

decimal

3289

EagleML/accountingTransaction/realizedGainLoss/shortTermLossLocal

currencyGainBase

 

decimal

3296

EagleML/accountingTransaction/realizedGainLoss/currencyGainBase

currencyGainLocal

 

decimal

3297

EagleML/accountingTransaction/realizedGainLoss/currencyGainLocal

currencyLossBase

 

decimal

3298

EagleML/accountingTransaction/realizedGainLoss/currencyLossBase

currencyLossLocal

 

decimal

3299

EagleML/accountingTransaction/realizedGainLoss/currencyLossLocal

amortizedPrice

 

decimal

9483

EagleML/accountingTransaction/realizedGainLoss/amortizedPrice

netGainLossBase

 

decimal

3294

EagleML/accountingTransaction/realizedGainLoss/netGainLossBase

netGainLossLocal

 

decimal

3295

EagleML/accountingTransaction/realizedGainLoss/netGainLossLocal

nonCreditLossLocal

 

decimal

2704

EagleML/accountingTransaction/realizedGainLoss/nonCreditLossLocal

nonCreditLossBase

 

decimal

2705

EagleML/accountingTransaction/realizedGainLoss/nonCreditLossBase

reportAmount

 

decimal

10054

EagleML/accountingTransaction/realizedGainLoss/reportAmount

reportAmount2

 

decimal

178

EagleML/accountingTransaction/realizedGainLoss/reportAmount2

reportAmount3

 

decimal

4602

EagleML/accountingTransaction/realizedGainLoss/reportAmount3

reportAmount4

 

decimal

8852

EagleML/accountingTransaction/realizedGainLoss/reportAmount4

reportUpdateSource

 

string

5525

EagleML/accountingTransaction/realizedGainLoss/reportUpdateSource

reportIssueName

 

string

25

EagleML/accountingTransaction/realizedGainLoss/reportIssueName

newMonthDate

 

date

4733

EagleML/accountingTransaction/realizedGainLoss/newMonthDate

naicMarketCode

 

string

5856

EagleML/accountingTransaction/realizedGainLoss/naicMarketCode

groupCode

 

string

5858

EagleML/accountingTransaction/realizedGainLoss/groupCode

Â