A QAD database contains three types of data:
• Control data
• Transaction data
• Static data
When you implement a module, you enter data that the system uses later to control how the system interacts with users and with the database. This data is stored in control tables.
Control tables enable you to adapt the system to your environment. The data and settings in these tables determine how certain programs are displayed, the numbers assigned to transactions, the GL accounts for particular transactions, and so on. When you can manage a typical manufacturing function in more than one way, control settings let you establish a preference.
Most data in the database is transaction data. Every day, sales orders come in, purchase orders go out, and work orders make demands on and create material for inventory. These events result in transactions, which are stored in transaction tables. In contrast to control programs, transaction tables are constantly updated by users of the system.
Static data contains information about the basic building blocks and relationships of a company—the ways it does business, and the entities it does business with. Static data is used to create transaction records. However, static data is changed infrequently. Examples of static data are records for customers, suppliers, items, inventory sites and locations, and GL accounts.