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 scaling factor defined in the input or report template options.

For example, if the defined scaling factor is 1000, Header(/ %USERSCALINGFACTOR%) generates the value 'Header(/ 1000)'.

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.

The user ID of the current user account.

Example of use in an SQL statement in a custom sheet:

<sql id="SaveFINYRS"><sqlstatement>UPDATE FMFINYRSET FINYR_POSITION =:position:,[FINYR_UPDATENAME] =CURRENT_USER,[FINYR_UPDATEDATE] =%USER CODE %WHERE FINYR_UDID=:udid: ;END.....

The name of the current user account (user's last name + first name).

Example of use in an SQL statement in a custom sheet:

<sql id="SaveFINYRS"><sqlstatement>UPDATE FMFINYRSET FINYR_POSITION =:position:,[FINYR_UPDATENAME] =CURRENT_USER,[FINYR_UPDATEDATE] =%USER NAME %WHERE FINYR_UDID=:udid: ;END.....

The user ID of the current user account.