QAD 2017 Enterprise Edition > Technical References > Entity Diagrams > Diagram Conventions > How to Use the Diagrams > Operational Tables
  
Operational Tables
QAD table names and table name description are closely related. The table name consists of a prefix and type, separated by an underscore (_). Common table types are listed in Database Table Types.

Database Table Types
 
Table Type
Meaning
Description
ctrl
Control
Parameters and logical fields that control other functions.
mstr
Master Table
Used for data storage.
det
Detail Table
Detail related to another record. There are typically many detail records associated with one master record.
hist
History Table
Contains records created by activity within the database.
plan
Planning Table
Data for planning functions.
wkfl
Work Table
Used to support other functions.
In the typical case, the table prefix consists of two or three significant letters of the table name description.
Example: The table name for sales order master is so_mstr, and po_mstr is the table name for purchase order master.
In most cases, the first letter of the table name is the first letter of the description; the few exceptions involve tables such as line changeover master, which is chg_mstr.
Detail tables related to master data typically have the same prefix with the addition of the letter d.
Example: The detail table associated with so_mstr is sod_det.
Within a table, all the data elements use the same prefix.
Example: The repetitive production schedule (rps_mstr) table includes fields named rps_part and rps_record.