This variable outputs the date of today in format YYYY-MM-DD. An example output could be “2020-06-09”. This parameter is used in XBRL reporting. |
The type of data (cumulative or periodic) in the selected input or report template. The actual names of the options are defined in the language files. In the definition file of a drill-down sheet, this variable inherits its value from the cell (from the column definitions) that the user has drilled down from. For example, if the user drills down from a column whose column definition is periodical, the value of the variable in the definition file of the drill-down sheet is always periodical regardless of what the user has selected in the input or report template options. |
The identifier of the financial period selected in the input or report template options. In the definition file of a drill-down sheet, this variable inherits its value from the cell (from the column definitions) that the user has drilled down from. For example, if the user drills down from a column whose column definition is '5', the value of the variable in the definition file of the drill-down sheet is always '5' regardless of what the user has selected in the input or report template options. Calculated values can also be used. For example: •%PERIOD CODE + 7%: The calculation is based on the selected period. For example, if the use has selected period 02, the value of the variable is '09'. "Rolling" is possible in the years and periods. If the year and period variables are in brackets, the year will be changed if the number of periods in the year is exceeded. For example: •If the year is 2005, there are 12 periods in the year, and the value of the period is 08, the value of [%YEAR CODE% / %PERIOD CODE + 9%] will be '2006 / 05'. •If the year is 2005, there are 12 periods in the year, and the value of the period is 08, the value of %YEAR CODE% / %PERIOD CODE + 9% (without brackets) will be'2005 / 05'. |
The name of financial period (in the active language) selected in the input or report template options. This variable can be used only in a column header. In the definition file of a drill-down sheet, this variable inherits its value from the cell (from the column definitions) that the user has drilled down from. For example, if the user drills down from a column whose column definition is '5', the value of the variable in the definition file of the drill-down sheet is always the name of the period '5' regardless of what the user has selected in the input or report template options. Calculated values can also be used. For example: •%PERIOD NAME + 7%: The calculation is based on the selected period. For example, if the user has selected period 02 (February), the value of the variable is 'September'. "Rolling" is possible in the years and periods. If the year and period variables are in brackets, the year will be changed if the number of periods in the year is exceeded. For example: •If the year is 2005, there are 12 periods in the year, and the value of the period is 08, the value of [%YEAR CODE% / %PERIOD NAME + 9%] will be '2006 / May'. •If the year is 2005, there are 12 periods in the year, and the value of the period is 08, the value of %YEAR CODE% / %PERIOD NAME + 9% (without brackets) will be '2005 / May'. |
The identifier of the financial period selected in the input or report template options. In the definition file of a drill-down sheet, this variable inherits its value from the cell (from the column definitions) that the user has drilled down from. For example, if the user drills down from a column whose column definition is '5', the value of the variable in the definition file of the drill-down sheet is always '5' regardless of what the user has selected in the input or report template options. |
The identifier of the financial year selected in the input or report template options. In the definition file of a drill-down sheet, this variable inherits its value from the cell (from the column definitions) that the user has drilled down from. For example, if the user drills down from a column whose column definition is '2006', the value of the variable in the definition file of the drill-down sheet is always ’2006’ regardless of what the user has selected in the input or report template options. |
The identifier of the financial year selected in the input or report template options. In the definition file of a drill-down sheet, this variable inherits its value from the cell (from the column definitions) that the user has drilled down from. For example, if the user drills down from a column whose column definition is '2006', the value of the variable in the definition file of the drill-down sheet is always '2006' regardless of what the user has selected in the input or report template options. Calculated values can also be used. For example: •%YEAR CODE+ 7%: The calculation is based on the selected year. For example, if the user has selected year 2007, the value of the variable is '2014'. "Rolling" is possible in the years and periods. If the year and period variables are in brackets, the year will be changed if the number of periods in the year is exceeded. For example: •If the year is 2005, there are 12 periods in the year, and the value of the period is 08, the value of [%YEAR CODE% / %PERIOD CODE + 9%] will be '2006 / 05'. •If the year is 2005, there are 12 periods in the year, and the value of the period is 08, the value of %YEAR CODE% / %PERIOD CODE + 9% (without brackets) will be '2005 / 05'. Note! Do not use %YEAR CODE+n% or %YEAR CODE-n% as a comment in the XML definition file. This will cause an error when opening the input or report template. |
This variable outputs the end date of the last normal period of the selected year in format YYYY-MM-DD. Used in same way as %YEAR START DATE%. This parameter is used in XBRL reporting. |
This variable outputs the start date of the first normal period of the selected year in format YYYYMM-DD. The date can only be used if start date has been saved for the first normal period of the referred year (or end date of last normal period in case of %YEAR END DATE%). The dates of the periods can be edited with template P_CUSTOM_04 “Period start and end dates”. The variable can be used to refer to the preceding or following years by adding “+1” or “-1” identifiers in the end of it. For example, the variable %YEAR START DATE+1% would output 2021-01-01 when the year selected for the report is 2020 and the entity reports financial periods which are calendar years. This parameter is used in XBRL reporting. |
The name of the financial year selected in the input or report template options. This variable can be used only in a column header. In the definition file of a drill-down sheet, this variable inherits its value from the cell (from the column definitions) that the user has drilled down from. For example, if the user drills down from a column whose column definition is 2006, the value of the variable in the definition file of the drill-down sheet is always the name of the year 2006 regardless of what the user has selected in the input or report template options. Calculated values can also be used. For example: •%YEAR NAME + 7%: The calculation is based on the selected the year. For example, if user has selected year 2007, the value of the variable is 'Year 2014'. "Rolling" is possible in the years and periods. If the year and period variables are in brackets, the year will be changed if the number of periods in the year is exceeded. For example: •If the year is 2005 (and its' name is 'Year 2005'), there are 12 periods in the year, and the value of period is 08, the value of [%YEAR NAME% / %PERIOD CODE + 9%] will be 'Year 2006 / 05'. •If the year is 2005 (and its' name is 'Year 2005'), there are 12 periods in the year, and the value of period is 08, the value of %YEAR NAME% / %PERIOD CODE + 9% (without brackets) will be 'Year 2005 / 05'. |