Understanding Row Definition Setup

You use the Row Definitions program (P09310) to set up row definitions. The system saves the records to the OVFS Row Definition Setup table (F09310).

When you set up a row definition that includes grouping elements, you can group together financial data to provide a summarization of accounts for each unique combination of the grouping elements. You can also set up a data row definition without grouping elements. A data row definition without grouping elements can be used to return a total of the account balances for the accounts that you specify for the financial statement. If you do not use grouping elements for a data row definition, then the row includes a title that you specify and a total of the account balances for the accounts that are included in the data selection for the statement. For both grouped and non-grouped data row definitions, the system retrieves values for the data based on the data selection specified in the rows and columns on the statement, and on the data selection for the statement version that you run.

When you set up the row definition to include a numeric or text value, you enter the value for the number or text that you want to include in the row. Rows that you set up with a text or numeric value do not retrieve values from the F0901, F0902, or F0006 tables.

When you begin to design your row definitions, the system assigns a definition status of Work in Progress. This value is for informational purposes. The system does not perform any validations based on the definition status. You can continue to work in and use the definitions no matter the status unless the security administrator set up access to the definitions based on the status.

In addition to the Work in Progress status, you can set the definition status to Active or Inactive.