Statement Columns (tffst1105m000)

Use this session to define and maintain statement columns.

Field Information

General
General
Financial Statement

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

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.