Trial Balance Data Map Table

objectType

Optional

ObjectTypeEnum

not stored in DB

EagleML/accountingTransaction/trialBalance/objectType

objectId

Optional

ObjectId

not stored in DB

EagleML/accountingTransaction/trialBalance/objectId

objectDescription

Optional

FeedTypeEnum

not stored in DB

EagleML/accountingTransaction/trialBalance/objectDescription

updateTimestamp

Optional

dateTime

calculated value

EagleML/accountingTransaction/trialBalance/updateTimestamp

customElements

Not recommended

CustomElements -  ComplexType

EagleML/accountingTransaction/trialBalance/customElements

updateSource

Required

string

944

calculated value

EagleML/accountingTransaction/trialBalance/updateSource

Entity Common Id Model

EagleML/accountingTransaction/trialBalance/

Asset Identifiers Model

EagleML/accountingTransaction/trialBalance/

Asset Properties Model

EagleML/accountingTransaction/trialBalance/

maturityDate

Optional

date

38

calculated value

EagleML/accountingTransaction/trialBalance/maturityDate

baseCurrency

Optional

CurrencyCode

86

calculated value

EagleML/accountingTransaction/trialBalance/baseCurrency

accountingBasis

Optional

string

21

calculated value

EagleML/accountingTransaction/trialBalance/accountingBasis

startDate

Optional

date

920

calculated value

EagleML/accountingTransaction/trialBalance/startDate

endDate

Optional

date

921

calculated value

EagleML/accountingTransaction/trialBalance/endDate

effectiveDate

Optional

date

1109

calculated value

EagleML/accountingTransaction/trialBalance/effectiveDate

transType

Optional

string

1257

calculated value

EagleML/accountingTransaction/trialBalance/transType

reportType

Optional

string

4734

calculated value

EagleML/accountingTransaction/trialBalance/reportType

openEventId

Optional

TransactionId

151

calculated value

EagleML/accountingTransaction/trialBalance/openEventId

closeEventId

Optional

TransactionId

182

calculated value

EagleML/accountingTransaction/trialBalance/closeEventId

shareClass

Optional

normalizedString

34

calculated value

EagleML/accountingTransaction/trialBalance/shareClass

valuationDate

Optional

date

3192

calculated value

EagleML/accountingTransaction/trialBalance/valuationDate

navSequence

Optional

integer

3196

calculated value

EagleML/accountingTransaction/trialBalance/navSequence

netAssetAmount

Optional

decimal

3193

calculated value

EagleML/accountingTransaction/trialBalance/netAssetAmount

navAmountPerShare

Optional

decimal

3195

calculated value

EagleML/accountingTransaction/trialBalance/navAmountPerShare

sharesOutstanding

Optional

decimal

3209

calculated value

EagleML/accountingTransaction/trialBalance/sharesOutstanding

sharesSettled

Optional

decimal

758

calculated value

EagleML/accountingTransaction/trialBalance/sharesSettled

status

Optional

string

3190

calculated value

EagleML/accountingTransaction/trialBalance/status

activeFlag

Optional

decimal

not stored in DB

EagleML/accountingTransaction/trialBalance/activeFlag

millRateAdjustmentAmount

Optional

decimal

4282

calculated value

EagleML/accountingTransaction/trialBalance/millRateAdjustmentAmount

millRateDaysInYear

Optional

integer

4283

calculated value

EagleML/accountingTransaction/trialBalance/millRateDaysInYear

millRateDaysInMonth

Optional

integer

4284

calculated value

EagleML/accountingTransaction/trialBalance/millRateDaysInMonth

millRateWeeksInYear

Optional

decimal

4285

calculated value

EagleML/accountingTransaction/trialBalance/millRateWeeksInYear

millRateDailyYield

Optional

decimal

4286

calculated value

EagleML/accountingTransaction/trialBalance/millRateDailyYield

millRate7dayEffectiveYield

Optional

decimal

4287

calculated value

EagleML/accountingTransaction/trialBalance/millRate7dayEffectiveYield

millRate7dayAverageYield

Optional

decimal

4288

calculated value

EagleML/accountingTransaction/trialBalance/millRate7dayAverageYield

millRate30dayEffectiveYield

Optional

decimal

4289

calculated value

EagleML/accountingTransaction/trialBalance/millRate30dayEffectiveYield

millRate30dayAverageYield

Optional

decimal

4290

calculated value

EagleML/accountingTransaction/trialBalance/millRate30dayAverageYield

incomeDistribution

Optional

decimal

4229

calculated value

EagleML/accountingTransaction/trialBalance/incomeDistribution

shortTermCapGainDist

Optional

decimal

4230

calculated value

EagleML/accountingTransaction/trialBalance/shortTermCapGainDist

longTermCapGainDist

Optional

decimal

4231

calculated value

EagleML/accountingTransaction/trialBalance/longTermCapGainDist

netActivity

Optional

decimal

478

calculated value

EagleML/accountingTransaction/trialBalance/netActivity

distributionReinvestAmount

Optional

decimal

not stored in DB

EagleML/accountingTransaction/trialBalance/distributionReinvestAmount

fixedDistributionAmount

Optional

decimal

4484

calculated value

EagleML/accountingTransaction/trialBalance/fixedDistributionAmount

millRate

Optional

decimal

4564

calculated value

EagleML/accountingTransaction/trialBalance/millRate

allocRatio

Optional

decimal

756

calculated value

EagleML/accountingTransaction/trialBalance/allocRatio

periodicDistributionAmount

Optional

decimal

4759

calculated value

EagleML/accountingTransaction/trialBalance/periodicDistributionAmount

otherCapGainDist

Optional

decimal

not stored in DB

EagleML/accountingTransaction/trialBalance/otherCapGainDist

stockDividendRate

Optional

decimal

not stored in DB

EagleML/accountingTransaction/trialBalance/stockDividendRate

marketPrice

Optional

decimal

not stored in DB

EagleML/accountingTransaction/trialBalance/marketPrice

averageMaturityDays

Optional

decimal

not stored in DB

EagleML/accountingTransaction/trialBalance/averageMaturityDays

daysInMillRate

Optional

integer

10722

calculated value

EagleML/accountingTransaction/trialBalance/daysInMillRate

nasdaqSymbol

Optional

string

3947

calculated value

EagleML/accountingTransaction/trialBalance/nasdaqSymbol

incomeNetAssets

Optional

decimal

2787

calculated value

EagleML/accountingTransaction/trialBalance/incomeNetAssets

incomeNav

Optional

decimal

2788

calculated value

EagleML/accountingTransaction/trialBalance/incomeNav

capitalNav

Optional

decimal

2789

calculated value

EagleML/accountingTransaction/trialBalance/capitalNav

cashDividend

Optional

decimal

4802

calculated value

EagleML/accountingTransaction/trialBalance/cashDividend

weightedAverageMaturity

Optional

decimal

8623

calculated value

EagleML/accountingTransaction/trialBalance/weightedAverageMaturity

weightedAverageLife

Optional

decimal

8624

calculated value

EagleML/accountingTransaction/trialBalance/weightedAverageLife

navRoundIndctr

Optional

normalizedString

10064

calculated value

EagleML/accountingTransaction/trialBalance/navRoundIndctr

reportingNavChange

Optional

decimal

10150

calculated value

EagleML/accountingTransaction/trialBalance/reportingNavChange

reportingNavPrior

Optional

decimal

10151

calculated value

EagleML/accountingTransaction/trialBalance/reportingNavPrior

incomeAdjustmentAmount

Optional

decimal

4482

calculated value

EagleML/accountingTransaction/trialBalance/incomeAdjustmentAmount

estimateVersion

Optional

integer

not stored in DB

EagleML/accountingTransaction/trialBalance/estimateVersion

securitiesPriced

Optional

integer

3968

calculated value

EagleML/accountingTransaction/trialBalance/securitiesPriced

securitiesTotal

Optional

integer

3969

calculated value

EagleML/accountingTransaction/trialBalance/securitiesTotal

estimateQuality

Optional

EstimateQualityEnum

3194

calculated value

EagleML/accountingTransaction/trialBalance/estimateQuality

millRatePaymentFrequency

Optional

string

4291

calculated value

EagleML/accountingTransaction/trialBalance/millRatePaymentFrequency

navChange

Optional

decimal

4225

calculated value

EagleML/accountingTransaction/trialBalance/navChange

navVariance

Optional

decimal

4226

calculated value

EagleML/accountingTransaction/trialBalance/navVariance

publicOffering

Optional

decimal

4227

calculated value

EagleML/accountingTransaction/trialBalance/publicOffering

publicOfferingChange

Optional

decimal

4228

calculated value

EagleML/accountingTransaction/trialBalance/publicOfferingChange

navCalcCount

Optional

integer

4251

calculated value

EagleML/accountingTransaction/trialBalance/navCalcCount

preferredNetAssets

Optional

decimal

4630

calculated value

EagleML/accountingTransaction/trialBalance/preferredNetAssets

outstandingSubs

Optional

decimal

11717

calculated value

EagleML/accountingTransaction/trialBalance/outstandingSubs

outstandingExchSubs

Optional

decimal

11718

calculated value

EagleML/accountingTransaction/trialBalance/outstandingExchSubs

outstandingReds

Optional

decimal

11719

calculated value

EagleML/accountingTransaction/trialBalance/outstandingReds

outstandingExchReds

Optional

decimal

11720

calculated value

EagleML/accountingTransaction/trialBalance/outstandingExchReds

outstandingReinvest

Optional

decimal

11721

calculated value

EagleML/accountingTransaction/trialBalance/outstandingReinvest

settledSubs

Optional

decimal

11722

calculated value

EagleML/accountingTransaction/trialBalance/settledSubs

settledExchSubs

Optional

decimal

11723

calculated value

EagleML/accountingTransaction/trialBalance/settledExchSubs

settledReds

Optional

decimal

11724

calculated value

EagleML/accountingTransaction/trialBalance/settledReds

settledExchangeReds

Optional

decimal

11725

calculated value

EagleML/accountingTransaction/trialBalance/settledExchangeReds

settledReinv

Optional

decimal

11726

calculated value

EagleML/accountingTransaction/trialBalance/settledReinv

dilutionAmt

Optional

decimal

12015

calculated value

EagleML/accountingTransaction/trialBalance/dilutionAmt

allocatedDilutionAmt

Optional

decimal

12016

calculated value

EagleML/accountingTransaction/trialBalance/allocatedDilutionAmt

dilutionAdj

Optional

decimal

12017

calculated value

EagleML/accountingTransaction/trialBalance/dilutionAdj

adjNAVForDilution

Optional

decimal

12018

calculated value

EagleML/accountingTransaction/trialBalance/adjNAVForDilution

calculatedExpAmt

Optional

decimal

12019

calculated value

EagleML/accountingTransaction/trialBalance/calculatedExpAmt

calculatedExpRatio

Optional

decimal

12020

calculated value

EagleML/accountingTransaction/trialBalance/calculatedExpRatio

manualDivergenceAdj

Optional

decimal

2911

calculated value

EagleML/accountingTransaction/trialBalance/manualDivergenceAdj

equateNAV

Optional

decimal

2910

calculated value

EagleML/accountingTransaction/trialBalance/equateNAV

navCalcDateTime

Optional

date

5522

calculated value

EagleML/accountingTransaction/trialBalance/navCalcDateTime

navVerificationAmount

Optional

decimal

5521

calculated value

EagleML/accountingTransaction/trialBalance/navVerificationAmount

reportingNav

Optional

decimal

10149

calculated value

EagleML/accountingTransaction/trialBalance/reportingNav

valuationTime

Optional

string

3191

calculated value

EagleML/accountingTransaction/trialBalance/valuationTime

navSentCount

Optional

integer

4253

calculated value

EagleML/accountingTransaction/trialBalance/navSentCount

navNotSentCount

Optional

integer

4252

calculated value

EagleML/accountingTransaction/trialBalance/navNotSentCount

navTotalCount

Optional

integer

4254

calculated value

EagleML/accountingTransaction/trialBalance/navTotalCount

customAccount

Optional

string

1623

calculated value

EagleML/accountingTransaction/trialBalance/customAccount

customAccountDescription

Optional

string

1624

calculated value

EagleML/accountingTransaction/trialBalance/customAccountDescription

gLSubAccount

Optional

string

1289

calculated value

EagleML/accountingTransaction/trialBalance/gLSubAccount

ledgerAccount

Optional

string

1288

calculated value

EagleML/accountingTransaction/trialBalance/ledgerAccount

ledgerAccountDescription

Optional

string

1290

calculated value

EagleML/accountingTransaction/trialBalance/ledgerAccountDescription

regulatoryCategory

Optional

string

12387

calculated value

EagleML/accountingTransaction/trialBalance/regulatoryCategory

regulatoryCategoryChanged

Optional

string

891

calculated value

EagleML/accountingTransaction/trialBalance/regulatoryCategoryChanged

coupon

Optional

decimal

70

calculated value

EagleML/accountingTransaction/trialBalance/coupon

uSFederalTaxIndicator

Optional

YesNoOptionEnum

1545

calculated value

EagleML/accountingTransaction/trialBalance/uSFederalTaxIndicator

ledgerAcct

Optional

string

901

calculated value

EagleML/accountingTransaction/trialBalance/ledgerAcct

closeoutLedgerAccountOffset

Optional

string

946

calculated value

EagleML/accountingTransaction/trialBalance/closeoutLedgerAccountOffset

accountId

Optional

integer

1983

calculated value

EagleML/accountingTransaction/trialBalance/accountId

allocationId

Optional

integer

64003

calculated value

EagleML/accountingTransaction/trialBalance/allocationId

numberOfNavDigits

Optional

integer

10065

calculated value

EagleML/accountingTransaction/trialBalance/numberOfNavDigits

estimatedReinvestPct

Optional

decimal

741

calculated value

EagleML/accountingTransaction/trialBalance/estimatedReinvestPct

coaName

Optional

string

1641

calculated value

EagleML/accountingTransaction/trialBalance/coaName

taCode

Optional

string

3628

calculated value

EagleML/accountingTransaction/trialBalance/taCode

userGroup3

Optional

string

1741

calculated value

EagleML/accountingTransaction/trialBalance/userGroup3

userGroup4

Optional

string

1742

calculated value

EagleML/accountingTransaction/trialBalance/userGroup4

shareClassId

Optional

string

2421

calculated value

EagleML/accountingTransaction/trialBalance/shareClassId

userDefinedFloat1

Optional

decimal

1890

calculated value

EagleML/accountingTransaction/trialBalance/userDefinedFloat1

parentBroker

Optional

string

4426

calculated value

EagleML/accountingTransaction/trialBalance/parentBroker

marketSectorDescription

Optional

string

10173

calculated value

EagleML/accountingTransaction/trialBalance/marketSectorDescription

sectorNumber

Optional

string

5

calculated value

EagleML/accountingTransaction/trialBalance/sectorNumber

sectorName

Optional

string

1159

calculated value

EagleML/accountingTransaction/trialBalance/sectorName

lpBalanceAmount

Optional

decimal

922

calculated value

EagleML/accountingTransaction/trialBalance/lpBalanceAmount

lpCumulativeDr

Optional

decimal

924

calculated value

EagleML/accountingTransaction/trialBalance/lpCumulativeDr

lpCumulativeCr

Optional

decimal

925

calculated value

EagleML/accountingTransaction/trialBalance/lpCumulativeCr

lpTodayCumulativeDate

Optional

date

928

calculated value

EagleML/accountingTransaction/trialBalance/lpTodayCumulativeDate

ledgerGrouping

Optional

string

1825

calculated value

EagleML/accountingTransaction/trialBalance/ledgerGrouping

ruleId

Optional

string

3197

calculated value

EagleML/accountingTransaction/trialBalance/ruleId

acctPriorChg

Optional

decimal

5376

calculated value

EagleML/accountingTransaction/trialBalance/acctPriorChg

documentSection

Optional

string

1744

calculated value

EagleML/accountingTransaction/trialBalance/documentSection

page

Optional

integer

941

calculated value

EagleML/accountingTransaction/trialBalance/page

line

Optional

decimal

942

calculated value

EagleML/accountingTransaction/trialBalance/line

ordr

Optional

integer

943

calculated value

EagleML/accountingTransaction/trialBalance/ordr

accountDescriptionCoreCoa

Optional

string

1086

calculated value

EagleML/accountingTransaction/trialBalance/accountDescriptionCoreCoa

unsettledRedemptions

Optional

decimal

7953

calculated value

EagleML/accountingTransaction/trialBalance/unsettledRedemptions

unsettledSubscriptions

Optional

decimal

7952

calculated value

EagleML/accountingTransaction/trialBalance/unsettledSubscriptions

accountName

Optional

string

1617

calculated value

EagleML/accountingTransaction/trialBalance/accountName

sysEndDate

Optional

date

73

calculated value

EagleML/accountingTransaction/trialBalance/sysEndDate

credit

Optional

decimal

64001

calculated value

EagleML/accountingTransaction/trialBalance/credit

debit

Optional

decimal

64002

calculated value

EagleML/accountingTransaction/trialBalance/debit

sourceId

Optional

string

64004

calculated value

EagleML/accountingTransaction/trialBalance/sourceId

itemNumber

Optional

integer

1887

calculated value

EagleML/accountingTransaction/trialBalance/itemNumber

beginningBalanceBase

Optional

decimal

1620

calculated value

EagleML/accountingTransaction/trialBalance/beginningBalanceBase

baseOrNonBaseBreakout

Optional

string

7038

calculated value

EagleML/accountingTransaction/trialBalance/baseOrNonBaseBreakout

assigningDateTime

Optional

dateTime

745

calculated value

EagleML/accountingTransaction/trialBalance/assigningDateTime

reserved1433

Optional

string

1433

calculated value

EagleML/accountingTransaction/trialBalance/reserved1433

groupType

Optional

string

4266

calculated value

EagleML/accountingTransaction/trialBalance/groupType

taMilRate

Optional

decimal

4994

calculated value

EagleML/accountingTransaction/trialBalance/taMilRate

shareClassUserChar1

Optional

string

5630

calculated value

EagleML/accountingTransaction/trialBalance/shareClassUserChar1

shareClassUserChar2

Optional

string

5631

calculated value

EagleML/accountingTransaction/trialBalance/shareClassUserChar2

custLedgerSource

Optional

string

16420

calculated value

EagleML/accountingTransaction/trialBalance/custLedgerSource