Report Writer > Reports > Data Dictionary Table Listing

Data Dictionary Table Listing

You use this program to print a list of all the all the imported tables within the data dictionary.

This list enables you to see the tables from which you can extract data to create reports.

The Data Dictionary Import program is used to import the standard SYSPRO tables into the Report Writer Data Dictionary. User defined tables can be created using the Browse on Data Dictionary Tables program.

Report Options

Field Description
Sequence Indicate the order in which to print the data dictionary column information.
OptionDescription
TablePrint the report in table name sequence.
DescriptionPrint the report in table description sequence.
From table Indicate the first table in a range of tables to include in the report.
To table Indicate the last table in a range of tables to include in the report.
Options  
User tables only

Select this to only list user defined tables in the report.

Print Generate the report according to your selections.
Close Exit the program without generating the report.

Report details

The data dictionary table definitions are held in the Report Writer Data Dictionary Tables (RepTable) table. Within this table, the Standard SYSPRO Tables column indicates whether the table is user defined or is a standard SYSPRO table. If a table is user defined, then an N is stored in this column and Yes is displayed in the User column of the report. If a table is a standard SYSPRO table, a Y is stored in this column and the User column on the report is left blank.