| Statement Columns (tffst1105m000) |  |
| Use this session to define and maintain statement columns. Related topics Create statement layouts
Fields | Description
General
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.
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 | Period Type
Value Status to Select | Value Status
Formula | Indicates how the values of the statement column must be calculated. The formula contains variables that are linked to statement account values. Example
    a + b - c
Where:
a | = | Opening balance
b | = | Debit amount
c | = | Credit amount
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. Related topics Rounding Method
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.
Commands | Description
Statement Column References | Starts the Statement Column References (tffst1111m000) session.
Renumber | Renumbers the values of all Statement Column fields.
Consolidated Account Factors by Column | Starts the Consolidated Statement Account Factors by Column (tffst1126m000) session.