Mapping Different ItemTypes
The ItemType of the line item can be found for a mapped fact by searching its ElementName on the Extension sheet. Only line item elements are used in the ElementName column. The elements with item type Abstract may never be mapped. The dimensional ItemTypes Axis and Member are used only in columns Axis and AxisMember if the line item belongs to an XBRL table.
See restrictions of entry sheet cell content for different line item types in Line item types.
Mapping line item ItemTypes
ItemType |
UnitRef Description |
UnitRef |
Decimals |
Scale |
|---|---|---|---|---|
Monetary |
An ISO 4217 currency code is defined in UnitRef column. E.g. "iso4217:EUR". |
iso4217:CODE |
Often -2 or -5 |
Typically 3 or 6 |
PerShare |
An ISO 4217 currency code is defined in UnitRef column divided by shares. E.g. "iso4217:EUR/xbrli:shares". |
iso4217:CODE/xbrli:shares |
Typically 2 |
Typically 0 |
Shares |
|
xbrli:shares |
Typically 0 |
Typically 0 |
Percent |
|
xbrli:pure |
More than 0, typically 2 or 3 |
Always -2 |
Pure |
|
xbrli:pure |
||
Area |
When Unit Type Registry* units are used ("utr" prefix), define literal "/**Namespace" in the beginning of Mapping sheet with the following content: utr="http://www.xbrl.org/2009/utr" |
utr:sqkm or other Unit Type Registry* unit |
||
Text |
|
<empty> |
<empty> |
<empty> |
TextBlock |
|
<empty> |
<empty> |
<empty> |
Date |
Defines the date transformation which always begins with "date-". Can be left empty so that the application automatically detects the transformation. See caption "Date ItemType" below. |
One of 84 valid transformations in Transformation Registry 4 |
<empty> |
<empty> |
Duration |
See caption "Duration ItemType" below |
<empty> |
<empty> |
<empty> |
* The Unit Type Registry units are found in: https://www.xbrl.org/utr/2012-11-30/utr.html. These units are practically only used with the element type Area present in Notes.
Date ItemType
There are 84 supported date transformations from Transformation Registry 4 in ESEF Reporting Tool. Easiest way to use them is to simply tag a Date type fact and leave UnitRef empty. After pressing Report Package, all the possible transformations for this fact will get listed in the UnitRef column on Mapping sheet. If there are more than one possibility, you should remove all other transformation but the most specific one.
For example date "31. joulukuuta 2020" will make an empty UnitRef turn "date-day-monthname-year-fi OR date-month-year". The more specific transformation must be chosen, so after checking the fact, the UnitRef should state only "date-day-monthname-year-fi".
Using the transformation which does not contain a full date is not encouraged.
There are three transformations of total 87 (Transformation Registry 4) not supported for dates: date-ind-day-monthname-year-hi, date-jpn-era-year-month, date-jpn-era-year-month-day
When looking at the table below, consider the "xx" in the transformation code as being the language abbreviation, e.g. a valid transformation to put to the UnitRef column could be for example "date-day-monthname-year-fi".
Date transformations
Transformation code |
Is full date |
Language of month |
Example on entry sheet |
|---|---|---|---|
date-day-monthname-year-xx |
Yes |
bg, cs, da, de, el, en, es, et, fi, fr, hi, hr, it, nl, no, pl, pt, ro, sk, sl, sv |
(fi) 31. joulukuuta 2021 |
date-monthname-day-year-xx |
Yes |
en |
(en) December 31st, 2021 |
date-year-monthname-day-xx |
Yes |
hu, lt |
(hu) 2021. december 31 |
date-year-day-monthname-xx |
Yes |
lv |
(lv) 2021. gada 31. decembrī |
date-day-monthroman-year |
Yes |
|
31. XII. 2021 |
date-day-month-year |
Yes |
|
31.12.2021 |
date-month-day-year |
Yes |
|
12/31/2021 |
date-year-month-day |
Yes |
|
2021-12-31 |
date-day-monthname-xx |
No |
bg, cs, da, de, el, en, es, et, fi, fr, hr, it, lv, nl, no, pl, pt, ro, sk, sl, sv |
(sv) 31 december |
date-monthname-day-xx |
No |
en, hu, lt |
(lt) gruodzio 31 d. |
date-day-monthroman |
No |
|
31. XII |
date-day-month |
No |
|
31.12 |
date-month-day |
No |
|
12/31 |
date-monthname-year-xx |
No |
bg, cs, da, de, el, en, es, et, fi, fr, hi, hr, it, nl, no, pl, pt, ro, sk, sl, sv |
(el) Δεκ 2021 |
date-year-monthname-xx |
No |
en, hu, lt, lv |
(hu) 2021. december |
date-monthroman-year |
No |
|
XII. 2021 |
date-month-year |
No |
|
12/2021 |
date-year-month |
No |
|
2021-12 |
Duration ItemType
The duration item type accepts durations according to the ISO 8601 standard. The format is PnYnMnDTnHnMnS, where n represents the number of units. In this format Y stands for year, M for month, D for day, H for hour, second M for minutes and S for seconds. For example, 3 years and 5 months would be written out as P3Y5M. In other words, T can be omitted if no hours, minutes and seconds are defined.