Table Directory Inquiry - Field Descriptions
Use the table below for reference when completing the fields on this screen.
Fields/Buttons | Descriptions |
---|---|
Module | Enter the two-character module abbreviation (for example, ET for Equipment Tracking), press Enter to see all modules, or use the drop-down list to view all available module descriptions. |
Search table name | Enter a table or view name (or partial name) or press Enter to display all object names. |
Code, Name and Module | The list box displays a list of table and view names, the object type, and the two-character module abbreviation (for example, ET for Equipment Tracking) associated with each object. |
Type | Select to filter the object type display. Objects may be tables or views, or both. |
Details | Select to display the Search Table Columns window. Use this window to view detailed table column information including Column name, Column Type, Size, and Description. The Description column tells you what the column is used for in the application. |
Listing | Select to open the Table Directory Listing screen. |