1. One View Financial Statements
  2. Understanding Row Definitions

Understanding Row Definitions

Row definitions are one of the building blocks that you use to create financial statements. Row definitions enable you to:

  • Define how the account balances are summarized when you use a data row definition type.

  • Subtotal a range of sections on the financial statement when you use a subtotal row definition type.

  • Include numeric values for calculations in the statement when you use a numeric value row definition type.

  • Provide text strings to use as titles, notes, headers, or footers when you use a text value row definition type.

The type of row definition that you set up determines whether the system retrieves account balances from database tables and summarizes the accounts, or the system uses a numeric or text value that you enter in the setup program.

When you set up a data row definition to designate how to summarize account balances by grouping elements, you can select from a limited set of grouping elements from the Account Master (F0901), Account Balances (F0902), and Business Unit Master (F0006) tables to summarize the accounts. For each row definition, you can select up to 10 grouping elements to use for balance summarization. The system summarizes the accounts balances for each unique combination of the selected grouping elements. You can also set up a data row definition without grouping elements to return a single line to the financial statement.

You can set up a subtotal row definition to use in a statement definition to provide subtotals of sections on the financial statement. When you set up a subtotal row definition, you provide a title. Then, when you use the subtotal row definition in a statement definition, you can specify which sections in the statement definition to include in the subtotal.

When you set up a numeric value type row definition, you specify a value to use in calculations. When you set up a text value type row definition, you specify a text string to use in the statement.

You can set up data selection for data row definitions to identify which account balances to summarize. You use the Query Manager tool to set up data selection. The Query Manager tool available in the One View Financial Statements (OVFS) functionality is slightly different from the Query Manager tool used throughout the rest of the JD Edwards EnterpriseOne system.

See Understanding Data Selection for Row Definitions and Understanding Data Selection for One View Financial Statements.