You use this program to print a list of all the columns available within a data dictionary table.
This list enables you to see the available columns for each table and therefore the columns from which you can extract data to create reports.
Standard columns are created when importing the data dictionary using the Data Dictionary Import program. User defined columns can be created using the Browse on Data Dictionary Columns program.
| Field | Description |
|---|---|
| Sequence | This enables you to define the order in which you want to print the data dictionary column information. |
| Column | Select this to print the report in column name sequence. |
| Description | Select this to print the report in column description sequence. |
| Sequence number |
Select this to print the report in column sequence number. Printing a list by Sequence number is useful, especially if you are familiar with the record layouts, since the columns are presented in the sequence in which they are defined in each line. |
| From table | Indicate the first table in a range of tables for which you want to print the column definitions. |
| To table | Indicate the last table in a range of tables for which you want to print the column definitions. |
| Options | |
| User columns only |
Select this to only include user defined columns in the report. The data dictionary column definitions are held in the Report Writer Data Dictionary Columns (RepColumn) table. Within this table, the Standard SYSPRO Column indicates whether the column is user defined or is a standard SYSPRO column. If a column is user defined, an N is stored in this column and Yes is displayed in the User column of the report. If a column is a standard SYSPRO column, a Y is stored in this column and the User column on the report is left blank. |
| Select this to generate the report according to your selections. | |
| Close | Select this to exit the report without generating the report. |