Reference tables

Overview

This module updates most of the system's reference tables.

Reference tables are static lists of valid codes and what they mean. Reference table specify what codes are allowed in different places in the data base.

In other words, reference tables are used to validate values entered in the employee data windows. When you enter a value in a table-controlled field, the system presents you with a choice of pre-defined values in a drop-down list. This list comes from the reference table.

For example, when you enter an employee address in the Pers window, the province field is validated against the PROVINCE table.

Some reference tables are edited in the specialized windows; notably the department table (ENTITY), the JOB table, the RATE table and the stock schedules SCHED.
In a table-controlled field, you can right-click and select the Open table option to open the related table. Here is an example:

Operation

Input screen

To access the reference tables window:

Data | Tables... main menu
Administration | Tables navigation pane
Pop-up menu (right-click) in a control field To update table entries:

Select the table to be modified.
Add, delete or modify the records. The fields under the second tab will vary according to the table in question.

See these subtopics for a brief description of the various tables available to you, and how they are used.