JDBC Driver for EdgarOnline

Build 20.0.7655

CoreFinancials_TTM_PrimaryFinancials

Query from the CoreFinancials-TTM resource.

Columns

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