Understanding Column Definitions

Column definitions are one of the building blocks that you use to create financial statements. Column definitions are used in financial statements to identify the account balance types, time frame, and ledger type from which to retrieve data for your financial statement. For example, you could set up a column to retrieve account balances for the current period from the AA (actual amount) ledger, a column for the previous period for the AA ledger, and a column for the current period for the BA (budgeted amount) ledger.

In the JD Edwards EnterpriseOne One View Financial Statements (OVFS) functionality, column definitions can also represent a set of ledgers; a subset of accounts, business units, or a categorization of the account or business unit. You can set up data selection for column definitions using the Query Manager tool. The Query Manager tool available in the OVFS functionality is slightly different from the Query Manager tool that you use for other queries in the JD Edwards EnterpriseOne system.

See Adding Data Selection to Column Definitions (Optional).