Output Tab

Description: The output tab defines what columns appear in the result set.

Modules Found In:  Accounts Receivable, Project Administration, Accounts Payable, Human Resources

Table - InFocus table name. See data dictionary for more information.

Column - Column name to use in the result set. If left blank, InFocus column name is used.

Display Name - Column name that should be used in result set. If left blank InFocus column name will be used.

Show - When checked column will appear in result set.

Column Order - Numerical order (from left to right) where the column appears in the result set.

Sort Order - Numerical sort precedent for sorting result set. For example, to sort by state then city, put a 1 on the state row, and a 2 on the city row.

Ascending - When checked, data is sorted in ascending order if a sort order ID is specified; otherwise, descending order is used.