Home › Forums › The XBRL API › Glossary for col names in US_GAAP_Taxonomy_2020
- This topic has 2 replies, 2 voices, and was last updated 5 years, 6 months ago by Tim Bui.
-
AuthorPosts
-
-
Thursday, May 21, 2020 at 12:17 PM #180625Tim BuiParticipant
Hi David,
Do you know where I can find the definitions of the names of the worksheets (Elements, Presentation, Calculation,….) and the names of the columns within these worksheets? Some of the names are self-explanatory but some are a little harder to understand. I found some on the back of the “XBRL Taxonomy Development Handbook” but the list there does not include all items. By the way, the more I look at the structure of XBRL, the more I am impressed with the thought process and work that had been done. My hat is off to the people who created this system.
Thanks, David
-
Monday, June 1, 2020 at 12:38 PM #181706David TaurielloKeymaster
Hi Tim – apologies for the delay; I’m not 100% familiar with the excel, so I wanted to get some details from FASB before responding. The first 5 tabs should be self explanatory; these are the elements and linkbases for the taxonomy. After that –
TIN Ref – Taxonomy implementation notes
CN Ref – Change notes is a list of changes for labels, definitions, depreciations and additions to the taxonomy
Extensible Lists – An element type for associating additional information with a fact that is not disaggregating an item into its components.
DTS – Comprehensive system-related details for the taxonomy’s discoverable taxonomy set
Parts – A list of the parts along with their type (format) in the reference linkbase for References
Other Element Decls – a list of typed dimensions. The current US GAAP Financial Reporting Taxonomy has one typed dimension.
Linkbase Summary –
Other Global Definitions – a list of the data types used in the Taxonomy.
-
Monday, June 1, 2020 at 1:54 PM #181715Tim BuiParticipant
Thank you so much for taking the time researching this to help me, David!
As always, I am grateful
Tim
-
-
AuthorPosts
- You must be logged in to reply to this topic.
Search Forums
Recent Topics
- Income Statement data for a company by David Tauriello
- Normalized data presentation by David Tauriello
- Extract Director RSUs/Options Form 14A by Priyanka Goonetilleke
- Using the offset parameter by David Tauriello
- Spreadsheet Commands: Query Worksheet and Query Workbook Query Workbook by Liam Noailles
Recent Replies
-
Income Statement data for a company 5 months, 3 weeks ago
-
Income Statement data for a company 5 months, 4 weeks ago
-
Using the offset parameter 10 months ago
-
Using the offset parameter 10 months ago
-
Using the offset parameter 10 months ago
Documentation & Discussion
- Get started with Google Sheets OR
- Get started with Microsoft Excel OR
- Get access to as-filed data from us for other tools or your own app
- XBRL API Interactive Documentation
- Ten Tips & Techniques
- The XBRL API
- XBRL Data Community
- 2024 US GAAP Taxonomy Viewer
- Live support - Monday, 3:30 - 4:30 PM ET
Who's using this free data?
API Use 2024 || API Use 2023 || API Use 2022 || API Use 2021 || API Use 2020 || API Use 2019 || API Use 2018
Join XBRL US
- Individual Options - Basic, Power User & Sole Practitioner
- For Your Team - Startup, Non-Profit, Academic & Corporate options
- Member Benefits Comparison Table
Using the XBRL API with the Public Filings Database
Unless otherwise agreed to in writing, any and all use of the XBRL API to authenticate and retrieve data from the XBRL US Database of Public Filings implies user consent and agreement with the XBRL US API Agreement. If you are unable to agree to these terms, do not use the XBRL API.
To use the XBRL API outside of Google Sheets, your account needs to be provisioned for OAuth2 access.





