Understanding Data Selection for Column Definitions

The data selection that you associate with a column definition applies to only the associated column definition. You can set up data selection for column definitions to specify a range of ledger types, or other values or ranges of values that are specific to the Account Balances (F0902) table. You can also select values from the Account Master (F0901) table and the Business Unit Master (F0006) table. The system associates the data selection to the column definition and saves the column definition and data selection as one unit. You can set up one set of data selection only for each column definition.

You can specify a ledger type for the column definition in two ways. You can enter the ledger type in the column definition, or you can leave the Ledger Type field on the Revise Column Definitions form blank and specify the ledger type in data selection. Oracle recommends that you specify the ledger type in the data selection only when you need to specify a range of ledger types. If you leave the Ledger Type field in the Revise Column Definition form blank, then you must associate data selection that includes a ledger type or a range of ledger types to the column definition.

See Creating a Column Definition.

When you select Data Selection on the Revise Column Definition form, the program opens the Query Manager tab. You use this form to select data, and then save your data selection. You also use the Query Manager form to modify or delete data selection for the column definition.

After you associate data selection with a column definition, the system selects the Data Selection check box on the Revise Column Definition and Work with Column Definitions forms so that you can easily determine whether a column definition has associated data selection. You cannot manually select or clear the check box. If you delete the data selection on the Query Manager tab, then the system clears the check box.