JDBC Driver for EdgarOnline

Build 20.0.7655

TaxonomyFieldProperties

Query the properties of each field included in the taxonomy.

Select

The driver will use the EdgarOnline API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the driver.

  • TaxonomyId supports the following operator: =.
For example, the following query is processed server side:
SELECT * FROM TaxonomyFieldProperties WHERE TaxonomyId=18

Columns

Name Type Description
Id [KEY] Int Field ID.
TaxonomyId Int The taxonomy id.
Name String Name of the field.
RowNum Int The field's row number.
DataTypeId Int The field's row number.
DataTypeDescription String Name of the field's data type.
IsNumeric Bool Indicates whether the field is numeric or not numeric.
IsMoney Bool Indicates whether the field is contains a monetary value or does not contain a monetary value.
CanHoldValue Bool Indicates whether the field can hold a value or cannot hold a value.
IsSection Bool Indicates whether the field is a section or is not a section.
PeriodTypeId Int Period type ID.
PeriodTypeDescription String Period type description (Instant or Duration).
BalanceTypeId Int Balance type ID.
BalanceTypeDescription String Balance type description (Credit or Debit).

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7655