JDBC Driver for EdgarOnline

Build 20.0.7655

CoreFinancials_QTR_Metadata

Query from the CoreFinancials-QTR resource.

Columns

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