Multiple Leg Accounting Trade Data Map Table

objectType

ObjectTypeEnum

EagleML/accountingTransaction/multipleLegAccountingTrade/objectType

objectId

objectId

EagleML/accountingTransaction/multipleLegAccountingTrade/objectId

objectDescription

FeedTypeEnum

EagleML/accountingTransaction/multipleLegAccountingTrade/objectDescription

updateTimestamp

dateTime

1106

EagleML/accountingTransaction/multipleLegAccountingTrade/updateTimestamp

updateSource

string

944

EagleML/accountingTransaction/multipleLegAccountingTrade/updateSource

tagNochangecase

string

4637

EagleML/accountingTransaction/multipleLegAccountingTrade/tagNochangecase

reportType

string

EagleML/accountingTransaction/multipleLegAccountingTrade/reportType

Entity Common Id Model

EagleML/accountingTransaction/multipleLegAccountingTrade/

Asset Identifiers Model

EagleML/accountingTransaction/multipleLegAccountingTrade/

postDate

date

30

EagleML/accountingTransaction/multipleLegAccountingTrade/postDate

tradeDate

date

35

EagleML/accountingTransaction/multipleLegAccountingTrade/tradeDate

settlementDate

date

37

EagleML/accountingTransaction/multipleLegAccountingTrade/settlementDate

effectiveDate

date

2857

EagleML/accountingTransaction/multipleLegAccountingTrade/effectiveDate

autoSettleIndicator

YesNoOptionEnum

58

EagleML/accountingTransaction/multipleLegAccountingTrade/autoSettleIndicator

custodianBankCode

string

1240

EagleML/accountingTransaction/multipleLegAccountingTrade/custodianBankCode

custodianBankName

string

1146

EagleML/accountingTransaction/multipleLegAccountingTrade/custodianBankName

custodyBankAccount

string

1660

EagleML/accountingTransaction/multipleLegAccountingTrade/custodyBankAccount

custodyBankSubaccount

string

1661

EagleML/accountingTransaction/multipleLegAccountingTrade/custodyBankSubaccount

cashAccountName

string

11696

EagleML/accountingTransaction/multipleLegAccountingTrade/cashAccountName

cashAccountNumber

string

11697

EagleML/accountingTransaction/multipleLegAccountingTrade/cashAccountNumber

batchIdentifier

string

701

EagleML/accountingTransaction/multipleLegAccountingTrade/batchIdentifier

exchangeCode

string

17

EagleML/accountingTransaction/multipleLegAccountingTrade/exchangeCode

brokerCode

string

88

EagleML/accountingTransaction/multipleLegAccountingTrade/brokerCode

brokerName

string

1235

EagleML/accountingTransaction/multipleLegAccountingTrade/brokerName

clearingBrokerCode

string

1237

EagleML/accountingTransaction/multipleLegAccountingTrade/clearingBrokerCode

clearingBrokerName

string

1236

EagleML/accountingTransaction/multipleLegAccountingTrade/clearingBrokerName

settleLocation

string

43

EagleML/accountingTransaction/multipleLegAccountingTrade/settleLocation

settleInstructions1

string

1897

EagleML/accountingTransaction/multipleLegAccountingTrade/settleInstructions1

settleInstructions2

string

1898

EagleML/accountingTransaction/multipleLegAccountingTrade/settleInstructions2

settleInstructions3

string

1899

EagleML/accountingTransaction/multipleLegAccountingTrade/settleInstructions3

settleInstructions4

string

1900

EagleML/accountingTransaction/multipleLegAccountingTrade/settleInstructions4

openTBATradeId

string

10503

EagleML/accountingTransaction/multipleLegAccountingTrade/openTBATradeId

userChar1

string

1887

EagleML/accountingTransaction/multipleLegAccountingTrade/userChar1

userChar2

string

1888

EagleML/accountingTransaction/multipleLegAccountingTrade/userChar2

userChar3

string

1889

EagleML/accountingTransaction/multipleLegAccountingTrade/userChar3

userFloat1

decimal

1890

EagleML/accountingTransaction/multipleLegAccountingTrade/userFloat1

userFloat2

decimal

1891

EagleML/accountingTransaction/multipleLegAccountingTrade/userFloat2

userFloat3

decimal

1892

EagleML/accountingTransaction/multipleLegAccountingTrade/userFloat3

transactionNotes

string

56

EagleML/accountingTransaction/multipleLegAccountingTrade/transactionNotes

originalTradeTicketNumber

decimal

761

EagleML/accountingTransaction/multipleLegAccountingTrade/originalTradeTicketNumber

payRecAccount

string

1826

EagleML/accountingTransaction/multipleLegAccountingTrade/payRecAccount

offsettoCostAccount

string

1825

EagleML/accountingTransaction/multipleLegAccountingTrade/offsettoCostAccount

manager

string

3718

EagleML/accountingTransaction/multipleLegAccountingTrade/manager

strategy

string

3722

EagleML/accountingTransaction/multipleLegAccountingTrade/strategy

clientSpecificOriginalTransactionId

string

457

EagleML/accountingTransaction/multipleLegAccountingTrade/clientSpecificOriginalTransactionId

targetTradeTicketNumber

decimal

762

EagleML/accountingTransaction/multipleLegAccountingTrade/targetTradeTicketNumber

orderNumber

decimal

1092

EagleML/accountingTransaction/multipleLegAccountingTrade/orderNumber

counterPartyId

string

1144

EagleML/accountingTransaction/multipleLegAccountingTrade/counterPartyId

counterpartyName

string

1173

EagleML/accountingTransaction/multipleLegAccountingTrade/counterpartyName

targetTransactionId

string

26

EagleML/accountingTransaction/multipleLegAccountingTrade/targetTransactionId

brokerCurrencyWorkVariable

string

2294

EagleML/accountingTransaction/multipleLegAccountingTrade/brokerCurrencyWorkVariable

costBasisCoveredLotFlag

YesNoOptionEnum

2819

EagleML/accountingTransaction/multipleLegAccountingTrade/costBasisCoveredLotFlag

coveredLotOverrideFlag

YesNoOptionEnum

2820

EagleML/accountingTransaction/multipleLegAccountingTrade/coveredLotOverrideFlag

userDefinedPriority

integer

2862

EagleML/accountingTransaction/multipleLegAccountingTrade/userDefinedPriority

pendingTradeFlag

YesNoOptionEnum

3695

EagleML/accountingTransaction/multipleLegAccountingTrade/pendingTradeFlag

fas115Code

string

3728

EagleML/accountingTransaction/multipleLegAccountingTrade/fas115Code

targetOriginalEventId

string

5032

EagleML/accountingTransaction/multipleLegAccountingTrade/targetOriginalEventId

regulatoryIntent

RegulatoryIntentEnum

8915

EagleML/accountingTransaction/multipleLegAccountingTrade/regulatoryIntent

holdingTerm

HoldingTermEnum

9091

EagleML/accountingTransaction/multipleLegAccountingTrade/holdingTerm

retroIndicator

string

11018

EagleML/accountingTransaction/multipleLegAccountingTrade/retroIndicator

originalSettlementDate

string

154

EagleML/accountingTransaction/multipleLegAccountingTrade/originalSettlementDate

holdingPeriodDate

string

164

EagleML/accountingTransaction/multipleLegAccountingTrade/holdingPeriodDate

originalAcquisitionDate

string

216

EagleML/accountingTransaction/multipleLegAccountingTrade/originalAcquisitionDate

contractToBaseFXRate

decimal

9

EagleML/accountingTransaction/multipleLegAccountingTrade/contractToBaseFXRate

payingLegForwardUnits

string

8317

EagleML/accountingTransaction/multipleLegAccountingTrade/payingLegForwardUnits

receivingLegForwardUnits

string

8318

EagleML/accountingTransaction/multipleLegAccountingTrade/receivingLegForwardUnits

calculateLocalAmountsFlag

YesNoOptionEnum

5013

EagleML/accountingTransaction/multipleLegAccountingTrade/calculateLocalAmountsFlag

calculateBaseAmountsFlag

YesNoOptionEnum

5014

EagleML/accountingTransaction/multipleLegAccountingTrade/calculateBaseAmountsFlag

calculateValuesBySTARIndicator

CalculateValuesBySTARIndicatorEnum

7000

EagleML/accountingTransaction/multipleLegAccountingTrade/calculateValuesBySTARIndicator

futureExpenseCapitalizeIndicator

FutureExpenseCapitalizeEnum

10705

EagleML/accountingTransaction/multipleLegAccountingTrade/futureExpenseCapitalizeIndicator

securityXrefLookupSwitch

normalizedString

991

EagleML/accountingTransaction/multipleLegAccountingTrade/securityXrefLookupSwitch

codeValueLookupSwitch

normalizedString

9152

EagleML/accountingTransaction/multipleLegAccountingTrade/codeValueLookupSwitch

cancelAccountingDateSwitch

string

2283

EagleML/accountingTransaction/multipleLegAccountingTrade/cancelAccountingDateSwitch

longShortIndicator

LongShortIndicatorEnum

15

EagleML/accountingTransaction/multipleLegAccountingTrade/longShortIndicator

cancelTradeByIndicator

CancelTradeByIndicatorEnum

7001

EagleML/accountingTransaction/multipleLegAccountingTrade/cancelTradeByIndicator

notionalResetIndicator

notionalResetIndicatorEnum

3599

EagleML/accountingTransaction/multipleLegAccountingTrade/notionalResetIndicator

manualCallFlag

YesNoOptionEnum

7020

EagleML/accountingTransaction/multipleLegAccountingTrade/manualCallFlag

schedulePaymentIndicator

SchedulePaymentIndicatorEnum

16008

EagleML/accountingTransaction/multipleLegAccountingTrade/schedulePaymentIndicator

allowAutoRebookFlag

YesNoOptionEnum

EagleML/accountingTransaction/multipleLegAccountingTrade/allowAutoRebookFlag

overridePostingCutOffDateFlag

YesNoOptionEnum

9154

EagleML/accountingTransaction/multipleLegAccountingTrade/overridePostingCutOffDateFlag

overrideEditChecksFlag

YesNoOptionEnum

2285

EagleML/accountingTransaction/multipleLegAccountingTrade/overrideEditChecksFlag

calculateNetAmountsFlag

YesNoOptionEnum

2286

EagleML/accountingTransaction/multipleLegAccountingTrade/calculateNetAmountsFlag

methodOfConvertingLTDAmortization

YesNoOptionEnum

7001

EagleML/accountingTransaction/multipleLegAccountingTrade/methodOfConvertingLTDAmortization

chooseMethodOfConvertingInterest

YesNoOptionEnum

7002

EagleML/accountingTransaction/multipleLegAccountingTrade/chooseMethodOfConvertingInterest

beginAccrualDate

date

2857

EagleML/accountingTransaction/multipleLegAccountingTrade/beginAccrualDate

endAccrualDate

date

4412

EagleML/accountingTransaction/multipleLegAccountingTrade/endAccrualDate

notionalExchangeSwitch

YesNoOptionEnum

16736

contractTradeLeg - complex type (see the table below)

Required

TradeLeg

EagleML/accountingTransaction/multipleLegAccountingTrade/contractTradeLeg/

payTradeLeg - complex type (see the table below)

Required

TradeLeg

EagleML/accountingTransaction/multipleLegAccountingTrade/payTradeLeg/

receiveTradeLeg - complex type (see the table below)

Required

TradeLeg

EagleML/accountingTransaction/multipleLegAccountingTrade/receiveTradeLeg/

Repeated Model (contractTradeLeg, payTradeLeg, receiveTradeLeg)

firstPeriodCouponRate

string

1360

…/firstPeriodCouponRate

lotLevelDatedDate

date

4411

…/lotLevelDatedDate

lotSelectionMethod

LotSelectionCodeMethodEnum

27

…/lotSelectionMethod

oidYield

string

39

…/oidYield

sharesParQuantity

decimal

40

…/sharesParQuantity

originalFace

decimal

41

…/originalFace

price

decimal

45

…/price

taxAmount

decimal

46

…/taxAmount

impliedCommissionIndicator

YesNoOptionEnum

78

…/impliedCommissionIndicator

commission

decimal

47

…/commission

secFee

decimal

48

…/secFee

tradedInterest

decimal

49

…/tradedInterest

localNetAmount

decimal

50

…/localNetAmount

stampDutyTax

decimal

51

…/stampDutyTax

settlementCurrency

CurrencyCode

63

…/settlementCurrency

settlementNetAmount

decimal

64

…/settlementNetAmount

amortYield

decimal

75

…/amortYield

buytoBaseFXRate

decimal

9

…/buytoBaseFXRate

localToBaseFXRate

decimal

87

…/localToBaseFXRate

currentFactor

decimal

91

…/currentFactor

discountRate

decimal

1314

…/discountRate

principal

decimal

165

…/principal

tradedInterestBase

decimal

475

…/tradedInterestBase

baseNetAmount

decimal

478

…/baseNetAmount

termLoanFeeIncome

decimal

844

…/termLoanFeeIncome

termLoanFeeExpense

decimal

846

…/termLoanFeeExpense

targetPurchaseDate

string

914

…/targetPurchaseDate

targetPurchasePrice

decimal

915

…/targetPurchasePrice

currentILBQuantity

decimal

965

…/currentILBQuantity

commissionPerContractLocal

decimal

971

…/commissionPerContractLocal

accrualMethod

string

1184

…/accrualMethod

accrualConventionOffsetOverride

string

1604

…/accrualConventionOffsetOverride

backupWithholdingLocal

decimal

2712

…/backupWithholdingLocal

accruedInterestType

string

3715

…/accruedInterestType

originalCostBaseNoAmortization

decimal

3746

…/originalCostBaseNoAmortization

originalCostLocalNoAmortization

decimal

3747

…/originalCostLocalNoAmortization

otherFee

decimal

3752

…/otherFee

totalSettlementAmountLocal

decimal

4404

…/totalSettlementAmountLocal

ilbIndexRatio

decimal

4483

…/ilbIndexRatio

payableReceivableIndicator

string

4590

…/payableReceivableIndicator

pairoffAllocatnleIndicator

string

5671

…/pairoffAllocatnleIndicator

conversionPremium

decimal

5727

…/conversionPremium

totalTradedInterestLocal

decimal

7351

…/totalTradedInterestLocal

notionalAmountLocal

decimal

7429

…/notionalAmountLocal

notionalAmountBase

decimal

7509

…/notionalAmountBase

swapFeeLocal

decimal

7510

…/swapFeeLocal

federalTaxWithholdingBase

decimal

8078

…/federalTaxWithholdingBase

stateTaxWithholdingBase

decimal

8079

…/stateTaxWithholdingBase

createTBACashflow

YesNoOptionEnum

9406

…/createTBACashflow

dataEntryMethod

DataEntryMethodEnum

10485

…/dataEntryMethod

prorataCreditNoncreditLossIndicator

YesNoOptionEnum

16157

…/prorataCreditNoncreditLossIndicator

payingLegInitialCashAmount

decimal

316

…/payingLegInitialCashAmount

receivingLegInitialCashAmount

decimal

366

…/receivingLegInitialCashAmount

otherFeeSettlementDate

string

9357

…/otherFeeSettlementDate

commissionSettlementDate

string

11579

…/commissionSettlementDate

userDefinedPriority

integer

2862

…/userDefinedPriority

holdingTerm

HoldingTermEnum

9091

…/holdingTerm

commissionAndFeesSettleSeparately

YesNoOptionEnum

12860

…/commissionAndFeesSettleSeparately

legNotional

decimal

7782

…/legNotional

legShares

decimal

7785

…/legShares

comimissionSettlementAmount

commAmtS

decimal

17989

…/comimissionSettlementAmount

otherFeeSettlementAmount

otherFeeS

decimal

17988

…/otherFeeSettlementAmount

swapSettlementAmount

totalSettlementAmountSettle

decimal

18397

…/swapSettlementAmount

settlementExhangeRate

XrateLocalSettle

decimal

66

…/settlementExhangeRate