JDBC Driver for EdgarOnline

Build 20.0.7655

CoreFinancials_TTM_Metadata

Query from the CoreFinancials-TTM resource.

Columns

Name Type Description
InvRelationsEmail String
State String
LastAnnualEPS Float
Formername String
Sector String
CoverSheetTSO Float
PhoneAreaCode String
City String
ZipCode String
TaxID String
StreetAddress1 String
BusinessDescription String
PhoneNumber String
PhoneCountryCode String
PublicFloat Float
AuditorCode String
LastAnnualNetIncome Float
WebSiteURL String
AuditorOpinion String
Industry String
TotalSharesOutstandingDate Datetime
PublicFloatDate Datetime
Country String
InventoryPolicy String
StreetAddress2 String
StateofIncorporation String
LastAnnualTotalAssets Float
NumberofShareholders Float
NumberofEmployees Float
CoverSheetTSODate Datetime
TaxonomyId Int
LastAnnualRevenue Float
EntityId Int
Primarysymbol String
PrimaryExchange String
MarketOperator String
MarketTier String
Companyname String
SICCode String
CIK String
duration String
SICDescription String

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