| Statement Column References (tffst1111m000) |  |
| Use this session to maintain column references. Related topics Create statement layouts
Fields | Description
General
Financial Statement | An account structure that can consist of child statement accounts and parent statement accounts. At the child level, the statement accounts are linked to ledger accounts and dimensions. With a financial statement, you can collect the desired financial values from the General Ledger and Budgeting modules, and use this data for internal and external financial reporting and analysis.
Statement Column | The column number.
Variable | The elements included in the formula used to calculate the column value. Note The variable must be included in the formula defined for the selected statement column in the Formula field of the Statement Columns (tffst1105m000) session. Otherwise, this variable is not available. Each variable can take up a maximum of ten positions.
Sequence Number | The sequence number allows you to define a number of data for one variable. Example
Formula: |
    (a-b)/c
The following data is defined for the variables:
Variable | a | a | b | c
Sequence Number | 1 | 2 | 1 | 1
Value | 100 | 250 | 200 | 50
The column value is calculated as follows:
    ((100 + 250) - 200) / 50) = 3
Variable "a" is calculated by adding the values 100 and 250 The default value is: last sequence number + 1. However, you can overwrite this value, if you want to.
Details
Column Reference | The data linked to a financial statement column that allows to calculate the column values. Select the amount or quantity based on which the column amount or quantity must be calculated.
Variable or Fixed Year/Period Range | Variable or Fixed
Other Column | The number of the column whose data you want to link to the selected variable/sequence number combination. Note This field is only available if you selected Other Column in the Column Reference field. ERP LN will assign the total column value to the selected combination, by aggregating the values of all variables linked to this column.
Period Details
Period From | The first year of which you want to use the data to calculate the variables. Note This field is only available if you selected Fixed in the Variable or Fixed Year/Period Range field.
Period From | The first period of which you want to use the data to calculate the variables. Note This field is only available if you selected Fixed in the Variable or Fixed Year/Period Range field.
Period From - Period Shift Correction | Enter the number of periods to deviate from the start period, which is determined by the Fiscal Period and Reporting Period fields in the Process Financial Statement Values (tffst1249m000) session. When this session is run, ERP LN will take into account the number of periods entered here. To count backwards a number of periods, type "-" before the number. Note This field is only available if you selected Variable in the Variable or Fixed Year/Period Range field. Example The following amounts refer to periods 1 to 6:
Period | Amount
1 | 10,000
2 | 8,000
3 | 15,000
4 | 22,000
5 | 25,000
6 | 13,000
In the Process Financial Statement Values (tffst1249m000), the following period selection is defined:
From period: | 2
To period: | 4
However, for a specific statment you want to select the values of periods 1 to 6, whereas for the other statements you only want to include values of periods 2 to 4. In that case, you enter the following data:
|  | Deviation
--- | --- | ---
From period: | 2 | -1
To period: | 4 | +2
ERP LN will select values of periods 1 to 6.
Period To | The last year of which you want to use the data to calculate the variables. Note This field is only available if you selected Fixed in the Variable or Fixed Year/Period Range field.
Period To | The last period of which you want to use the data to calculate the variables. Note This field is only available if you selected Fixed in the Variable or Fixed Year/Period Range field.
Period To - Period Shift Correction | Enter the number of periods to deviate from the end period, which is determined by the Fiscal Period and Reporting Period fields in the Process Financial Statement Values (tffst1249m000) session. When this session is run, ERP LN will take into account the number of periods entered here. To count backwards a number of periods, type "-" before the number. Note This field is only available if you selected Variable in the Variable or Fixed Year/Period Range field. Example The following amounts refer to periods 1 to 6:
Period | Amount
1 | 10,000
2 | 8,000
3 | 15,000
4 | 22,000
5 | 25,000
6 | 13,000
In the Process Financial Statement Values (tffst1249m000), the following period selection is defined:
From period: | 2
To period: | 4
However, for a specific statment you want to select the values of periods 1 to 6, whereas for the other statements you only want to include values of periods 2 to 4. In that case, you enter the following data:
|  | Deviation
--- | --- | ---
From period: | 2 | -1
To period: | 4 | +2
ERP LN will select values of periods 1 to 6.
Year for Starting Balance | Enter the year from which you want to select the amounts/quantities in the Process Financial Statement Values (tffst1249m000) session. Note This field is only available if your selections include: In the Column Reference field, one of the following options: Opening Balance Amount Opening Balance Qty 1 Opening Balance Qty 2 Fixed in the Variable or Fixed Year/Period Range field.
Year for Starting Balance | Enter the number of years to deviate from the year entered in the Year for Starting Balance field in the Process Financial Statement Values (tffst1249m000) session. Note This field is only available if your selections include: In the Column Reference field, one of the following options: Opening Balance Amount Opening Balance Qty 1 Opening Balance Qty 2 Variable in the Variable or Fixed Year/Period Range field.
Budget Details
Variable or Fixed Budget | You can choose between a fixed and a variable budget. Note This field is only available if, in the Column Reference field, you selected one of the following options: Budget Amount Budget Quantity 1 Budget Quantity 2 Related topics Variable or Fixed
Budget | Enter a budget code.
Commands | Description
Increase Sequence Number | Increases the value of the Sequence Number field by one.
Decrease Sequence Number | Decreases the value of the Sequence Number field by one.
Renumber Sequence Numbers | Renumbers the values of all Sequence Number fields.