Using ESEF_taxonomy_YYYY_LL_ERT.xlsx
This Excel sheet is created from ESEF Taxonomy for year YYYY. The language preference of this workbook is LL. Language preference could be for example FI-sv-en which means that Finnish is the primary language and Swedish and English are included as a reference. The actual name for the workbook could be for example "ESEF_taxonomy_2021_FI-sv-en_ERT.xlsx" when it is made for ESEF Taxonomy 2021 and the primary language is Finnish.
You can copy and paste rows from this spreadsheet into the Extension sheet on your ESEF workbook. The ElementName column has indentation, which follows the presentation hierarchy of the elements in the ESEF taxonomy.
The columns of each sheet in the taxonomy workbook have extensive guidance comments on the first row. You may read these by placing cursor on top of the cells on row one.
Types of sheets in taxonomy workbook
List of formatting rules for the Extension sheet
Sheet(s) |
Definition |
Color |
|---|---|---|
Linkroles |
Lists all linkroles in ESEF taxonomy. Some of the linkroles are grouped hidden as they are sublinkroles to the always visible ones. The sublinkroles define mostly more calculation relationships of XBRL tables. Each linkrole with a green color is a hyperlink to the core sheets. |
Black |
Elements |
An alphabetically ordered list of all the elements in the taxonomy. Especially the columns ElementName to ItemType can be used as a source or validation reference for ESEF elements listed on ESEF workbook Extension sheet. |
Violet |
Core sheets |
Core sheets list the actual element hierarchies of the taxonomy linkroles. The rows with a light blue background are a part of an XBRL table. |
Blue |
Mapping |
Lists the new technical literals which must be changed on the ESEF workbook when taking the this taxonomy to use. Literals /**Label and /**Generic which define languages not used on ESEF workbook (Extension Lang=xx columns) should not be copied. |
Green |