Data Selection Using Queries

Data selection for the OVFS functionality enables you to specify the value or range of values that the system uses to retrieve data from the Account Master (F0901) and Business Unit Master (F0006) tables. The system uses column definitions, row definitions, and the statement version, including their associated data selection, to determine the data to retrieve for the financial statement. When you generate a financial statement, the system analyzes all of the data selection to determine the data to provide in the financial statement.

In the OVFS functionality, you use the Query Manager feature that is available in most JD Edwards EnterpriseOne programs to define data selection. However, some of the options available to you are different when you use Query Manager in the OVFS functionality than when you use it in other parts of the JD Edwards EnterpriseOne system. For example, the system names the queries for you. You can associate one query with each row definition, column definition, and statement version.

See Understanding Data Selection for One View Financial Statements.