Drill Down Levels

The following table describes the levels that are supported by Drill Down:

Level 1: Balances
Heading: These headings are determined by the Report Body columns and Items by Page items selected on the Report Setup>Content tab, as well as any options chosen on the Options tab. Detail: These are the columns and Items by Page items. This level controls the grouping (see below).

Level 1: Balances

Heading: These headings are determined by the Report Body columns and Items by Page items selected on the Report Setup>Content tab, as well as any options chosen on the Options tab.

Detail: These are the columns and Items by Page items.

This level controls the grouping (see below).

Level 2: General Ledger
The system displays headings for GL Code/Title along with columns selected on the Content tab. This level only appears if: GL Code is not included in Level 1. —AND/OR— Print Detail is not selected (on the Reports>Financial Statements>Create Statement Formats>Assign Accounts tab) for the GL Account Code of the Section Title. —AND/OR— "Segment selected at report time" is selected as the "Print Balances For" option on the Assign Accounts tab, and "Segment to Substitute for GL Segment" is selected on the Options tab of the current report. —AND/OR— If pseudo close is active and you are in the Fund Balance section of the report.

Level 3: Numeric Columns
Period and Amount always display as the two column headings in this level. The numeric column headings (which were selected on the Content tab and displayed as column headings in Level 1) appear as the rows in this level. For example, if Current Period Actual and Current Year Actual were selected as columns on the Content tab, these two columns display as column headings in Level 1 and rows in Level 3.

Level 3: Numeric Columns

Period and Amount always display as the two column headings in this level. The numeric column headings (which were selected on the Content tab and displayed as column headings in Level 1) appear as the rows in this level.

For example, if Current Period Actual and Current Year Actual were selected as columns on the Content tab, these two columns display as column headings in Level 1 and rows in Level 3.

Level 4: Document Detail
The following session and document fields display as the columns headings in this level: Transaction Source, Session ID, Document Number, Document Date, Document Description, Document Amount, Source/ID, Effective Date, and Applied Amount.

Level 5: Transaction Detail
The following transaction fields always display as the columns in this level: {Segment Name}, Debit, Credit, Applied Amount, Entry Type, Effective Date, and Transaction Description.