Statement Columns (tffst1105m000)
Use this session to define and maintain statement columns.
Field Information
- General
-
- General
-
- Financial Statement
- Statement Column
-
The column number.
- Column Details
-
- Column Description (row 1)
-
The first line of descriptive column text.
- Column Description (row 2)
-
The second line of descriptive column text.
- Column Description (row 3)
-
The third line of descriptive column text.
- Column Type
-
The type of column.
Allowed values
- Amount/Quantity
- Amount/Quantity (Cum)
- Percentage over Accounts
- Percentage over Columns
- Rounding Differences
- Period Type
-
- Fiscal
- Reporting
- Tax
- Value Status to Select
-
- Finalized
-
LN will select the values defined in the sessions started from Transactions (tfgld1101m000), according to the selected transaction type. Finalized values are those that are limited to a tranasaction type for which the Global Selection of Batches for Finalization (tfgld1210m000) session has been run.
- Finalized and Not Finalized
-
LN will also select values defined in the sessions started from Transactions (tfgld1101m000), that is, both finalized and non-finalized values. Non-finalized values result from transactions for transaction types that have either the Batch Processing or the End of Session update method, and for which the Global Selection of Batches for Finalization (tfgld1210m000) session has not yet been run.
- Variable
-
This option, which is only available in the Statement Columns (tffst1105m000) session, allows you to set the Value Status to Select field in the Process Financial Statement Values (tffst1249m000) session to Finalized or Finalized and Not Finalized.
- Not Applicable
- Formula
- Column 1 for Percentage Calculation
-
The number of the column used for percentage calculation.
- 100 Percent Column for Perc. Calc.
-
The number of the column that contains the denominator used for percentage calculation.
- Rounding
-
- Rounding
-
- Rounding
-
Indicates how the calculated value must be rounded off.
- Decimals
-
Indicates how the value calculated for the selected statement column must be rounded off..
Note: This field does not have any effect on the values printed on the annexure. The annexure contains the exact values without any rounding or reproduction. - Reproduction
-
Indicates how the amounts, calculated according to the data defined for the selected column, must be displayed in the financial statement.
Allowed values
- Normal
- Thousands
- Millions
Example
The example below shows how a value will be displayed in the selected statement column, based on the following data.
Rounding Decimals Reproduction Result Normal 2 digits after dec sign Normal 5756.98 Up 2 digits after dec sign Normal 5756.99 Normal On Unit Normal 5757 Down 3 digits before dec sign Normal 5000 Down 3 digits before dec sign Thousands 5 Up 3 digits before dec sign Normal 6000 Normal 3 digits before dec sign Thousands 6 Normal 6 digits before dec sign Millions 0 - Rounding Difference Column
-
Select the appropriate column from the Statement Columns (tffst1105m000) session.
- Value Selection before Rounding
-
- Value Selection before Rounding
-
If this check box is selected, you can specify one or two conditions.
- Operator
-
Select the appropriate operator.
Allowed values
- Lower Than
- Lower or Equal
- Equal To
- Greater Than
- Greater or Equal
- Not Applicable
- Value
-
Enter a numerical value.
- Condition
-
Select the appropriate condition.
Allowed values
- And
- Or
- Operator
-
Select the appropriate operator.
Allowed values
- Lower Than
- Lower or Equal
- Equal To
- Greater Than
- Greater or Equal
- Value
-
Enter a numerical value.
- Value Selection after Rounding
-
- Value Selection after Rounding
-
If this check box is selected, you can specify one or two conditions.
- Operator
-
Select the appropriate operator.
Allowed values
- Lower Than
- Lower or Equal
- Equal To
- Greater Than
- Greater or Equal
- Value
-
Enter a numerical value.
- Condition
-
Select the appropriate condition.
Allowed values
- And
- Or
- Operator
-
Select the appropriate operator.
Allowed values
- Lower Than
- Lower or Equal
- Equal To
- Greater Than
- Greater or Equal
- Value
-
Enter a numerical value.
- Balancing Column
-
- Balancing Column
-
If this check box is selected, you can specify a balancing account.
- Balancing Account
-
Select the appropriate account from the Statement Accounts (tffst1520m000) session.