Support Codetables
RoadBASE® stores simple code/description type entries in the file VMRS.dbf
To identify the specific nature of each record, a RECORDTYPE field is used.
This holds a single character, usually a letter, to indicate the individual record types.
| VMRS.dbf | RBSCREEN.dbf | ||
|---|---|---|---|
| Recordtype | Description | A | Accidents |
| A | Vehicle types/renewals | B | Defects |
| B | Costing codes/Transaction codes | C | Contract Manager Products |
| C | Locations | D | Drivers |
| D | Reason for repair | E | Rentals |
| E | Work done codes | F | Fitters |
| F | Fuel types | G | Driving Styles |
| G | Departments | H | Trips and Loads |
| H | Stock adjustments codes | I | Sales Invoice Headers |
| I | Tyre transactions | J | Job Cards |
| J | Pump/Fuel types | L | Suppliers |
| K | Fuel type/Cost codes | M | Driver Trips |
| L | Licence Types\RoadTax codes | N | Tyre Headers |
| M | Status codes | O | Vehicle Orders |
| N | Vehicle makes | P | Part Sales |
| O | Risk Analysis | Q | Fuel Cards |
| P | Payroll codes (MFT) | R | Models/Vehicle Profiles |
| Q | Inspections | S | Stock |
| R | Rental Groups | T | Costcentres |
| S | Service kit items | U | Stock Purchases |
| T | Timesheet activities | V | Vehicles |
| U | Not used (was Currency) | W | |
| V | VMRS codes | X | |
| W | Accident Reason Codes | Y | Supplier Invoices |
| X | Fitter Skills | Z | |
| Y | User definable module | 0-9 | User Defined |
| Z | User definable module | ||
| ! | INI Style configuration | ||
| $ | Driver contribution types | ||
| 0-9 | User definable lists | ||
| 0 | Body types | ||
| 8 (Inv.) | Stock discount categories | ||
| 9 (Inv.) | Invoice advertisement text | ||
| 9 (Exp) | Sema account code tables | ||
