Technical Overview – Masterfiles
Branches (branches.dbf)
The branches table stores details of all branches and divisions under each branch.
Section: 
Branch Details
Unique Key Fixed scope (“B”) + unique 3-digit branch code Links one-to-many into divisions in same table
Section: Division Details
Unique Key Fixed scope (“D”) + owner branch c ode + unique 3-digit division code
Links many-to-one into branches in same table
Contacts (contacts.dbf)
The contacts table stores details of all external entities that do business with each branch of the company.
Section: 
Suppliers
Unique Key Fixed scope (“S”) + branch code + unique max 10-digit supplier code (user definable code picture string)
Links one-to-many into supplier currencies
Section 
Client Debtors
Unique Key Fixed scope (“D”) + branch code + unique max 10-digit debtor code (user definable code picture string)
Links one-to-many into client credit cards
one-to-one into notepad for standard voucher instructions for this client
Section 
Client Leisures
Unique Key Fixed scope (“L”) + branch code + unique max 10-digit leisure code (user definable code picture string)
Links one-to-many into client credit cards
one-to-one into notepad for standard voucher instructions for this client
General Masterfiles (genmast.dbf)
The general masterfile table stores details of various system, global and branch related setups. Unique identifying keys are made up of the section scope, branch code (blank if global or system) and a unique key.
| Scope | Description | Default Values | Section | Max Key Length |
| # | Remote printers | System | 3 | |
| A | Action Authorities | Auto (full) | System | 20 |
| C | Consultants | Branch | 3 | |
| E | Credit Card Companies | Auto (full) | Global | 3 |
| F | Foreign Currencies | Global | 3 | |
| G | Debtor Groups | Global | 3 | |
| L | Client Savings reasons | Global | 3 | |
| P | Voucher settlement (Payment methods) | Auto (basic) | Global | 1 |
| R | Supplier Groups | Global | 3 | |
| S | Service Types | Auto (basic) | Global | 3 |
| V | Vat types | Auto (full) | Global | 3 |
| Y | Countries | Global | 3 | |
| Z | Continents | Global | 3 |
Default values contained in the genmast.def will be imported into the general masterfiles table if the file is found in the application folder on first startup, if the application version number has changed or if the exehist.dbf does not exist. After import, the file is renamed to genmast.csv