JDBC Driver for EdgarOnline

Build 20.0.7655

CoreFinancials_QTR_PrimaryFinancials

Query from the CoreFinancials-QTR resource.

Columns

Name Type Description
OtherSellingGeneralAdministrativeExpenses Float
OperatingExpenses Float
NonoperatingGainsLosses Float
OperatingMargin Float
DilutedWeightedAverageShares Float
NetIncomefromContinuingOperationsApplicabletoCommon Float
NoncontrollingInterest Float
NetOperatingProfitafterTax Float
AdjustedEBIT Float
AftertaxMargin Float
GrossMargin Float
OtherInterestIncomeExpenseNet Float
GeneralAdministrativeExpense Float
TotalOperatingExpenses Float
PreferredDividends Float
LaborExpense Float
SalesMarketingExpense Float
AmortizationExpense Float
InterestIncomeExpenseNet Float
AdjustedNetIncome Float
OperatingRevenue Float
TotalNonoperatingIncomeExpense Float
BasicWeightedAverageShares Float
IncomeAfterTaxes Float
OtherRevenue Float
RevenueFY Float
EBITDA Float
DepreciationExpense Float
AdjustedEBITDA Float
BasicEPSNetIncomefromContinuingOperations Float
DilutedEPSNetIncomefromContinuingOperations Float
RevenueTTM Float
CostOperatingExpenses Float
RevenueFQ Float
OtherGeneralAdministrativeExpense Float
SaleofInvestments Float
OtherDebtNet Float
PurchaseofInvestments Float
OtherEquityTransactionsNet Float
CFNetIncome Float
ChangeinLongtermDebtNet Float
LongtermDebtPayments Float
LongtermDebtProceeds Float
IssuanceofEquity Float
TotalNoncashAdjustments Float
ChangeinShorttermBorrowingsNet Float
CashPaidforInterestExpense Float
CashandCashEquivalentsBeginningofYear Float
OtherInvestmentChangesNet Float
CashandCashEquivalentsEndofYear Float
CashPaidforIncomeTaxes Float
RepurchaseofEquity Float
IncomeTaxesPayable Float
AccumulatedDepreciation Float
AccruedExpenses Float
LiabilitiesStockholdersEquity Float
TotalDebt Float
CurrentPortionofLongtermDebt Float
OtherAccountsPayableandAccruedExpenses Float
GoodwillIntangibleAssetsNet Float
TotalLongtermAssets Float
AccountsNotesReceivableNet Float
PropertyandEquipmentGross Float
TotalSharesOutstanding Float
OtherAccountsNotesReceivable Float
NotesPayable Float
OperatingLeases Float
AccountsPayable Float
TotalLongtermLiabilities Float
TotalAssetsFY Float
DeferredLiabilityCharges Float
AmountsDuetoRelatedPartiesShortterm Float
ShorttermInvestments Float
DeferredIncomeTaxLiabilitiesShortterm Float
LongtermDebt Float
TotalAssetsFQ Float
AccountsReceivableTradeNet Float
ShorttermBorrowings Float
OtherBorrowings Float
OtherReceivables Float
PretaxMargin Float
NetIncomeperEmployee Float
QuickRatio Float
LongTermDebttoLongTermCapital Float
NetDebt Float
LongTermDebttoTotalCapital Float
TotalCapital Float
NetWorkingCapital Float
TaxRate Float
LongTermCapital Float
FreeCashFlowMargin Float
periodenddate Date
fiscalperiod Int
numperiods Int
ModifiedSince Date
ReceivedDate Date
Audited String
CurrencyCode String
Amended Bool
FiscalQuarter Int
Original Bool
Preliminary Bool
DCN String
Restated Bool
CrossCalculated Bool
FormType String
PeriodLength Int
FiledDate Datetime
PeriodLengthCode String
USDConversionRate Float
FiscalYear Int
EBIT Float
EquityEarnings Float
DiscontinuedOperations Float
IncomeTaxes Float
GrossProfit Float
ResearchDevelopmentExpense Float
OtherNonoperatingIncomeExpense Float
IncomebeforeExtraordinaryItems Float
InterestExpense Float
TotalRevenue Float
CostofRevenue Float
DilutedEPSNetIncome Float
NetIncomeApplicabletoCommon Float
AccountingChange Float
BasicEPSNetIncome Float
InterestIncome Float
OperatingProfit Float
DepreciationAmortizationExpense Float
SellingGeneralAdministrativeExpenses Float
IncomeBeforeTaxes Float
NetIncome Float
MinorityInterestEquityEarnings Float
RestructuringRemediationImpairmentProvisions Float
OtherOperatingExpenses Float
ExtraordinaryItems Float
OtherAdjustments Float
ChangeinAccountsPayableAccruedExpenses Float
InvestmentChangesNet Float
ChangeinEquityNet Float
DividendsPaid Float
ChangeinOtherCurrentAssets Float
AdjustmentforSpecialCharges Float
AdjustmentforEquityEarnings Float
AdjustmentforMinorityInterest Float
ChangeinOtherAssets Float
ChangeinInventories Float
EmployeeCompensation Float
CashfromOperatingActivities Float
ChangeinOtherCurrentLiabilities Float
ChangeinPrepaidExpenses Float
StockOptionTaxBenefits Float
EffectofExchangeRateonCash Float
ChangeinOperatingAssetsLiabilities Float
OtherAssetLiabilityChangesNet Float
ChangeinIncomeTaxesPayable Float
CashfromInvestingActivities Float
ChangeinCurrentAssets Float
ChangeinDebtNet Float
TotalAdjustments Float
ChangeinCurrentLiabilities Float
RealizedGainsLosses Float
SaleofPropertyPlantEquipment Float
ChangeinAccountsReceivable Float
CapitalExpenditures Float
OtherFinancingActivitiesNet Float
CashfromDiscontinuedOperations Float
AcquisitionSaleofBusinessNet Float
OtherInvestingActivities Float
ChangeinDeferredRevenue Float
DeferredIncomeTaxes Float
CashfromFinancingActivities Float
CFDepreciationAmortization Float
NetChangeinCash Float
ChangeinOtherLiabilities Float
PensionPostretirementObligation Float
DeferredCharges Float
OtherInvestments Float
TotalLongtermDebt Float
PartnersCapital Float
OtherCurrentLiabilities Float
AccruedInterest Float
OtherCurrentAssets Float
PrepaidExpenses Float
LongtermDeferredLiabilityCharges Float
RetainedEarnings Float
TotalLiabilities Float
IntangibleAssets Float
TreasuryStock Float
CommonStock Float
DeferredIncomeTaxesLongterm Float
OtherEquity Float
RestrictedCash Float
OtherAccumulatedComprehensiveIncome Float
Goodwill Float
AdditionalPaidinCapital Float
PreferredStock Float
MinorityInterest Float
TotalCurrentAssets Float
OtherAssets Float
TotalStockholdersEquity Float
LongtermInvestments Float
LongtermDeferredIncomeTaxLiabilities Float
TotalReceivablesNet Float
OtherLiabilities Float
DeferredIncomeTaxesCurrent Float
TotalAssets Float
CommitmentsContingencies Float
AccountsPayableandAccruedExpenses Float
CashandCashEquivalents Float
TotalShorttermDebt Float
CashCashEquivalentsandShorttermInvestments Float
TemporaryEquity Float
InventoriesNet Float
TotalCurrentLiabilities Float
AdditionalPaidinCapitalPreferredStock Float
PropertyPlantEquipmentNet 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