You use this program to view information relating to the properties of a selected table.
The program is accessed from the -> option of the Data Dictionary Viewer program.
| Column | Description |
|---|---|
| Table name |
This indicates the SQL table name of the table. The standard SYSPRO table base names are preceded by an abbreviation of the SYSPRO module. For example: For the General Ledger Master table, GenMaster is the table name and GL Master is the table description. |
| Description | This indicates the description for the table/file. |
| ISAM file code | This indicates the equivalent ISAM file code for the table. |
| ISAM record length | This indicates the number of characters for each record within the ISAM file. |
| ISAM primary key length | This indicates the number of characters occupied by the key field within the ISAM record. |
| ISAM file name | This indicates the equivalent ISAM file name for the table. |
| Column | Description |
|---|---|
| Primary key | This indicates the primary key for the table. It uniquely identifies a table row. |
| Column | Description |
|---|---|
| Column | This indicates the columns within the table. |
| Description | This indicates the description for the column. |
| Datatype | This indicates the type of data that can be contained in the column. |
| Table | This indicates the table in which the column resides. |
| Seq |
This indicates the sequence number of the column within the table. The sequence number is a three digit numeric number in the data dictionary that is used to maintain a list of all the columns by sequence number for each table. The standard data dictionary generates a sequence number from 1 upwards, reflecting the position within the table. You can therefore, list the fields in the same sequence that they are defined in the record layouts. |
| Position | This indicates the start position of the column within the table. |