Using Reports > Data Dictionary Reports

Data Dictionary Reports

To obtain the most recent version of the database structure, run the Data Dictionary reports.

To Run Data Dictionary Reports

Select Reports > System > Data Dictionary Reports.
To print a list of database files, click the Files List radio button. To print a list of all the fields within each database file, click the Fields List radio button. To print a list of the Index Keys, click the Index Keys List radio button.
Select the products you want to appear on the report by checking the appropriate check boxes.
Click Preview to preview the report. When you are finished previewing, click the Close button to close the preview window.
Click Print to print the report.
Click the Close button to close the Data Dictionary Reports dialog box.

Using Functions in Reports

All field names beginning with an underscore are functions, and you might prefer to use them rather than the standard field names when creating custom reports.

You can use the special functions when creating reports by simply selecting a field name beginning with an underscore. For example, if you insert the field name _SEX, your report will display the field description of Male, Female or Unknown. for an employee’s gender. If you insert the field name P_SEX, your report will display the code M, F or U. Some of the functions (field names beginning with an underscore) do more than display a description rather than its code. The function _NAME1, for example, displays the employee’s name as: Last, First Middle.

Note: When you set up your organization levels, you provide a title for each level (Level1 = Division) and then define the Organization Code tables (codes and descriptions) for each level. If you want the description for an organization in a level (Accounting) to appear on your report rather than the code (ACCTG), select the related field name that begins with an underscore (_LEVEL1).