JDBC Driver for EdgarOnline

Build 20.0.7655

CoreFinancials_ANN_BalanceSheetFull

Query from the CoreFinancials-ANN resource.

Columns

Name Type Description
CurrentPortionofLongtermDebt Float
OtherBorrowings Float
DeferredIncomeTaxLiabilitiesShortterm Float
GoodwillIntangibleAssetsNet Float
TotalAssetsFY Float
TotalAssetsFQ Float
AccruedExpenses Float
ShorttermInvestments Float
LongtermDebt Float
TotalLongtermLiabilities Float
OtherReceivables Float
IncomeTaxesPayable Float
OperatingLeases Float
PropertyandEquipmentGross Float
AccountsNotesReceivableNet Float
TotalSharesOutstanding Float
AccumulatedDepreciation Float
AccountsReceivableTradeNet Float
DeferredLiabilityCharges Float
AmountsDuetoRelatedPartiesShortterm Float
ShorttermBorrowings Float
NotesPayable Float
OtherAccountsNotesReceivable Float
TotalDebt Float
LiabilitiesStockholdersEquity Float
OtherAccountsPayableandAccruedExpenses Float
AccountsPayable Float
TotalLongtermAssets Float
AccountsPayableandAccruedExpenses Float
CommitmentsContingencies Float
TotalShorttermDebt Float
LongtermDeferredLiabilityCharges Float
TotalReceivablesNet Float
TemporaryEquity Float
TotalCurrentAssets Float
OtherCurrentLiabilities Float
PrepaidExpenses Float
TotalLongtermDebt Float
CashCashEquivalentsandShorttermInvestments Float
TotalStockholdersEquity Float
OtherInvestments Float
DeferredIncomeTaxesCurrent Float
AdditionalPaidinCapital Float
Goodwill Float
CommonStock Float
TotalLiabilities Float
DeferredCharges Float
PropertyPlantEquipmentNet Float
MinorityInterest Float
PensionPostretirementObligation Float
CashandCashEquivalents Float
OtherLiabilities Float
IntangibleAssets Float
PreferredStock Float
LongtermInvestments Float
RetainedEarnings Float
LongtermDeferredIncomeTaxLiabilities Float
OtherCurrentAssets Float
RestrictedCash Float
TotalAssets Float
OtherAccumulatedComprehensiveIncome Float
PartnersCapital Float
InventoriesNet Float
AdditionalPaidinCapitalPreferredStock Float
OtherAssets Float
DeferredIncomeTaxesLongterm Float
TotalCurrentLiabilities Float
TreasuryStock Float
OtherEquity Float
AccruedInterest Float

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
filter String parameter to filter the result set
primarysymbols String parameter to filter the result set by PrimarySymbol
primaryexchanges String parameter to filter the result set by PrimaryExchange
entityids String parameter to filter the result set by entityId
activecompanies String parameter to filter the result set by activecompany
periodenddate String parameter to filter the result set by PeriodEndDate
fiscalperiod String parameter to filter the result set by FiscalPeriod
numperiods String parameter to filter the result set by numperiods
periodoffset String parameter to filter the result set by periodoffset
deleted String parameter to filter the result set by IsDeleted
modifiedsince String parameter to filter the result set by modifiedSince
companynames String parameter to filter the result set by companyname
marketoperators String parameter to filter the result set by MarketOperator
markettiers String parameter to filter the result set by MarketTier

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7655