Working Trial Balance Data Map Table

objectType

ObjectTypeEnum

not stored in DB

EagleML/accountingTransaction/workingTrialBalance/objectType

objectId

ObjectId

not stored in DB

EagleML/accountingTransaction/workingTrialBalance/objectId

objectDescription

FeedTypeEnum

not stored in DB

EagleML/accountingTransaction/workingTrialBalance/objectDescription

updateTimestamp

dateTime

calculated value

EagleML/accountingTransaction/workingTrialBalance/updateTimestamp

updateSource

string

944

calculated value

EagleML/accountingTransaction/workingTrialBalance/updateSource

Entity Common Id Model

EagleML/accountingTransaction/workingTrialBalance/

Asset Identifiers Model

EagleML/accountingTransaction/workingTrialBalance/

Asset Properties Model

EagleML/accountingTransaction/workingTrialBalance/

maturityDate

date

38

calculated value

EagleML/accountingTransaction/workingTrialBalance/maturityDate

baseCurrency

CurrencyCode

86

calculated value

EagleML/accountingTransaction/workingTrialBalance/baseCurrency

accountingBasis

string

21

calculated value

EagleML/accountingTransaction/workingTrialBalance/accountingBasis

startDate

date

920

calculated value

EagleML/accountingTransaction/workingTrialBalance/startDate

endDate

date

921

calculated value

EagleML/accountingTransaction/workingTrialBalance/endDate

effectiveDate

date

1109

calculated value

EagleML/accountingTransaction/workingTrialBalance/effectiveDate

transType

string

1257

calculated value

EagleML/accountingTransaction/workingTrialBalance/transType

reportType

string

4734

calculated value

EagleML/accountingTransaction/workingTrialBalance/reportType

openEventId

TransactionId

151

calculated value

EagleML/accountingTransaction/workingTrialBalance/openEventId

closeEventId

TransactionId

182

calculated value

EagleML/accountingTransaction/workingTrialBalance/closeEventId

shareClass

normalizedString

34

calculated value

EagleML/accountingTransaction/workingTrialBalance/shareClass

valuationDate

date

3192

calculated value

EagleML/accountingTransaction/workingTrialBalance/valuationDate

valuationTime

string

3191

calculated value

EagleML/accountingTransaction/workingTrialBalance/valuationTime

navSentCount

integer

4253

calculated value

EagleML/accountingTransaction/workingTrialBalance/navSentCount

navNotSentCount

integer

4252

calculated value

EagleML/accountingTransaction/workingTrialBalance/navNotSentCount

navTotalCount

integer

4254

calculated value

EagleML/accountingTransaction/workingTrialBalance/navTotalCount

customAccount

string

1623

calculated value

EagleML/accountingTransaction/workingTrialBalance/customAccount

customAccountDescription

string

1624

calculated value

EagleML/accountingTransaction/workingTrialBalance/customAccountDescription

gLSubAccount

string

1289

calculated value

EagleML/accountingTransaction/workingTrialBalance/gLSubAccount

ledgerAccount

string

1288

calculated value

EagleML/accountingTransaction/workingTrialBalance/ledgerAccount

ledgerAccountDescription

string

1290

calculated value

EagleML/accountingTransaction/workingTrialBalance/ledgerAccountDescription

regulatoryCategory

string

12387

calculated value

EagleML/accountingTransaction/workingTrialBalance/regulatoryCategory

regulatoryCategoryChanged

string

891

calculated value

EagleML/accountingTransaction/workingTrialBalance/regulatoryCategoryChanged

coupon

decimal

70

calculated value

EagleML/accountingTransaction/workingTrialBalance/coupon

uSFederalTaxIndicator

YesNoOptionEnum

1545

calculated value

EagleML/accountingTransaction/workingTrialBalance/uSFederalTaxIndicator

ledgerAcct

string

901

calculated value

EagleML/accountingTransaction/workingTrialBalance/ledgerAcct

closeoutLedgerAccountOffset

string

946

calculated value

EagleML/accountingTransaction/workingTrialBalance/closeoutLedgerAccountOffset

accountId

integer

1983

calculated value

EagleML/accountingTransaction/workingTrialBalance/accountId

allocationId

integer

64003

calculated value

EagleML/accountingTransaction/workingTrialBalance/allocationId

estimatedReinvestPct

decimal

741

calculated value

EagleML/accountingTransaction/workingTrialBalance/estimatedReinvestPct

coaName

string

1641

calculated value

EagleML/accountingTransaction/workingTrialBalance/coaName

userGroup3

string

1741

calculated value

EagleML/accountingTransaction/workingTrialBalance/userGroup3

userGroup4

string

1742

calculated value

EagleML/accountingTransaction/workingTrialBalance/userGroup4

marketSectorDescription

string

10173

calculated value

EagleML/accountingTransaction/workingTrialBalance/marketSectorDescription

sectorNumber

string

5

calculated value

EagleML/accountingTransaction/workingTrialBalance/sectorNumber

sectorName

string

1159

calculated value

EagleML/accountingTransaction/workingTrialBalance/sectorName

lpBalanceAmount

decimal

922

calculated value

EagleML/accountingTransaction/workingTrialBalance/lpBalanceAmount

lpCumulativeDr

decimal

924

calculated value

EagleML/accountingTransaction/workingTrialBalance/lpCumulativeDr

lpCumulativeCr

decimal

925

calculated value

EagleML/accountingTransaction/workingTrialBalance/lpCumulativeCr

lpTodayCumulativeDate

date

928

calculated value

EagleML/accountingTransaction/workingTrialBalance/lpTodayCumulativeDate

ledgerGrouping

string

1825

calculated value

EagleML/accountingTransaction/workingTrialBalance/ledgerGrouping

ruleId

string

3197

calculated value

EagleML/accountingTransaction/workingTrialBalance/ruleId

acctPriorChg

decimal

5376

calculated value

EagleML/accountingTransaction/workingTrialBalance/acctPriorChg

documentSection

string

1744

calculated value

EagleML/accountingTransaction/workingTrialBalance/documentSection

page

integer

941

calculated value

EagleML/accountingTransaction/workingTrialBalance/page

line

decimal

942

calculated value

EagleML/accountingTransaction/workingTrialBalance/line

ordr

integer

943

calculated value

EagleML/accountingTransaction/workingTrialBalance/ordr

accountDescriptionCoreCoa

string

1086

calculated value

EagleML/accountingTransaction/workingTrialBalance/accountDescriptionCoreCoa

sourceId

string

64004

calculated value

EagleML/accountingTransaction/workingTrialBalance/sourceId

itemNumber

integer

1887

calculated value

EagleML/accountingTransaction/workingTrialBalance/itemNumber

beginningBalanceBase

decimal

1620

calculated value

EagleML/accountingTransaction/workingTrialBalance/beginningBalanceBase

baseOrNonBaseBreakout

string

7038

calculated value

EagleML/accountingTransaction/workingTrialBalance/baseOrNonBaseBreakout

assigningDateTime

dateTime

745

calculated value

EagleML/accountingTransaction/workingTrialBalance/assigningDateTime

reserved1433

string

1433

calculated value

EagleML/accountingTransaction/workingTrialBalance/reserved1433

groupType

string

4266

calculated value

EagleML/accountingTransaction/workingTrialBalance/groupType

custLedgerSource

string

16420

calculated value

EagleML/accountingTransaction/workingTrialBalance/custLedgerSource

beginBalance

decimal

64005

calculated value

EagleML/accountingTransaction/workingTrialBalance/beginBalance

activity

decimal

64006

calculated value

EagleML/accountingTransaction/workingTrialBalance/activity

periodActivity

decimal

64007

calculated value

EagleML/accountingTransaction/workingTrialBalance/periodActivity

endingLedgerBalanceAmount

decimal

64008

calculated value

EagleML/accountingTransaction/workingTrialBalance/endingLedgerBalanceAmount

netPostingDebitCredit

decimal

64009

calculated value

EagleML/accountingTransaction/workingTrialBalance/netPostingDebitCredit