Column Type Field, Column Layout Table
Specifies the column type for the account schedule column. The type determines how the amounts in the column are calculated.
The following table describes how amounts are calculated for the period defined in the Date Filter field on the report or window depending on your selection in the Column Type field.
| Option | Description |
|---|---|
Formula |
The column will display amounts calculated from amounts in other columns in the account schedule. You enter the formula in the Formula field. |
Net Change |
The column will display the net change in the account balances during the period. |
Balance |
The column will display the account balances at the end of the period. |
Beginning Balance |
The column will display the account balances at the beginning of the period. |
Year to Date |
The column will display the net change in the account balances from the start of the fiscal year to the end of the period. |
Rest of Fiscal Year |
The column will display the net change in the account balances from the end of the period to the end of the fiscal year in which the period ends. |
Entire Fiscal Year |
The column will display the net change in the account balances for the fiscal year in which the period ends. |
Tip
For more information on how to work with fields and columns, see Work with Data. For assistance in finding specific pages, see Search.
Parent Tables
| Table | Location |
|---|---|
| Column Layout Table | General Ledger |
| Column Layout Table | General Ledger |