Trial Balance Data Map Table
- Natalie Gesin (Deactivated)
- Dmitry Donosiyan (Unlicensed)
Owned by Natalie Gesin (Deactivated)
| Element | Optional/Required | Value Type | Star Tag | Eagle DB | DB Table | DB Field | XPath |
|---|---|---|---|---|---|---|---|
| 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 | ||