JDBC Driver for EdgarOnline

Build 20.0.7655

CoreFinancials_ANN_PrimaryFinancials

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
periodenddate Date
fiscalperiod Int
numperiods Int
ModifiedSince Date
ReceivedDate Date
CrossCalculated Bool
Audited String
FiscalQuarter Int
DCN String
Restated Bool
FiscalYear Int
CurrencyCode String
FiledDate Datetime
PeriodLengthCode String
Amended Bool
FormType String
Preliminary Bool
USDConversionRate Float
PeriodLength Int
Original Bool
LongTermDebttoLongTermCapital Float
PretaxMargin Float
NetWorkingCapital Float
NetIncomeperEmployee Float
QuickRatio Float
TotalCapital Float
LongTermCapital Float
TaxRate Float
LongTermDebttoTotalCapital Float
FreeCashFlowMargin Float
NetDebt Float
OtherDebtNet Float
ChangeinLongtermDebtNet Float
CashPaidforInterestExpense Float
CashandCashEquivalentsBeginningofYear Float
SaleofInvestments Float
OtherEquityTransactionsNet Float
ChangeinShorttermBorrowingsNet Float
IssuanceofEquity Float
LongtermDebtPayments Float
OtherInvestmentChangesNet Float
CashandCashEquivalentsEndofYear Float
CFNetIncome Float
LongtermDebtProceeds Float
RepurchaseofEquity Float
TotalNoncashAdjustments Float
CashPaidforIncomeTaxes Float
PurchaseofInvestments Float
OperatingExpenses Float
OperatingRevenue Float
DilutedEPSNetIncomefromContinuingOperations Float
RevenueTTM Float
AdjustedEBIT Float
DilutedWeightedAverageShares Float
BasicEPSNetIncomefromContinuingOperations Float
BasicWeightedAverageShares Float
GeneralAdministrativeExpense Float
LaborExpense Float
EBITDA Float
OtherSellingGeneralAdministrativeExpenses Float
InterestIncomeExpenseNet Float
AmortizationExpense Float
AdjustedNetIncome Float
CostOperatingExpenses Float
NetIncomefromContinuingOperationsApplicabletoCommon Float
TotalOperatingExpenses Float
OtherRevenue Float
PreferredDividends Float
OtherInterestIncomeExpenseNet Float
NetOperatingProfitafterTax Float
DepreciationExpense Float
NonoperatingGainsLosses Float
AdjustedEBITDA Float
OtherGeneralAdministrativeExpense Float
GrossMargin Float
AftertaxMargin Float
RevenueFY Float
NoncontrollingInterest Float
TotalNonoperatingIncomeExpense Float
SalesMarketingExpense Float
RevenueFQ Float
OperatingMargin Float
IncomeAfterTaxes 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
ChangeinCurrentLiabilities Float
ChangeinInventories Float
DividendsPaid Float
DeferredIncomeTaxes Float
AdjustmentforMinorityInterest Float
ChangeinAccountsReceivable Float
CapitalExpenditures Float
ChangeinPrepaidExpenses Float
InvestmentChangesNet Float
CashfromFinancingActivities Float
NetChangeinCash Float
StockOptionTaxBenefits Float
ChangeinIncomeTaxesPayable Float
ChangeinOtherAssets Float
OtherInvestingActivities Float
ChangeinEquityNet Float
ChangeinOtherCurrentLiabilities Float
ChangeinAccountsPayableAccruedExpenses Float
CFDepreciationAmortization Float
AdjustmentforSpecialCharges Float
CashfromOperatingActivities Float
ChangeinDebtNet Float
EmployeeCompensation Float
CashfromInvestingActivities Float
CashfromDiscontinuedOperations Float
ChangeinOtherLiabilities Float
OtherFinancingActivitiesNet Float
OtherAssetLiabilityChangesNet Float
OtherAdjustments Float
EffectofExchangeRateonCash Float
AdjustmentforEquityEarnings Float
ChangeinCurrentAssets Float
ChangeinOtherCurrentAssets Float
ChangeinOperatingAssetsLiabilities Float
ChangeinDeferredRevenue Float
RealizedGainsLosses Float
AcquisitionSaleofBusinessNet Float
TotalAdjustments Float
SaleofPropertyPlantEquipment Float
OperatingProfit Float
IncomeTaxes Float
IncomeBeforeTaxes Float
DilutedEPSNetIncome Float
DepreciationAmortizationExpense Float
EquityEarnings Float
MinorityInterestEquityEarnings Float
CostofRevenue Float
AccountingChange Float
InterestExpense Float
IncomebeforeExtraordinaryItems Float
GrossProfit Float
DiscontinuedOperations Float
ExtraordinaryItems Float
SellingGeneralAdministrativeExpenses Float
RestructuringRemediationImpairmentProvisions Float
NetIncomeApplicabletoCommon Float
BasicEPSNetIncome Float
InterestIncome Float
OtherOperatingExpenses Float
EBIT Float
TotalRevenue Float
NetIncome Float
OtherNonoperatingIncomeExpense Float
ResearchDevelopmentExpense 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
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