|
Quantum VS Help: System Administration |
Quantum VS makes use of numerous table files to populate menus used in the application. Below is a list of table files used in Quantum VS which you (i.e. a user with System Administrator status) may be required to edit or set up values for:
Note: To list, find and open a table file see Finding Table Files. To add, edit and delete table file values see Adding, Editing And Deleting Table File Values.
|
Code |
Name |
Used For Defining... |
Used In...
|
|
AGE
|
Age |
Accounting periods (e.g. Next Month, Current, 30 Day, 60 Day, 90 Day etc.).
|
|
|
AGG |
Aggregate Codes |
Products that are part of an Aggregation Group.
|
Aggregation Product Maintenance; Product Maintenance
|
|
AREA |
Area Codes |
Areas (usually geographical; e.g. North; Wales; South Yorkshire) in order to specify the location of a customer.
|
|
|
ATYP |
Account Type |
Customer account types/codes (e.g. 1 = Trade/Credit Account customers, 2 = Cash customers etc.).
|
|
|
B |
Branch |
Your company branches. |
Customer Maintenance; Branch Maintenance
|
|
BAYL
|
Bay Locations |
Bay locations for product stocking (e.g. 0001 = household goods; 0002 = toiletries etc.).
|
Stock Maintenance; warehouse management / batch traceability
|
|
BAYN
|
Bay Numbers |
Bay numbers for product stocking (e.g. 0001 = HG01; 0002 = HG02).
|
Stock Maintenance; warehouse management / batch traceability
|
|
BCON
|
Branch Control Headings
|
User defined headings for the Branch Control Report. Each table file value will correspond to a record type on the Daily Sales File (available as an Optional Enhancement); e.g. 0001 = Credit Sale Delivered; 0002 = Credit Sale Collected.
|
|
|
BHLD
|
Batch Inspection Codes
|
Holds reasons for marking a received batch for inspection when Allocating Batch/Bin/Serial Number Details At Goods Receipt.
See also: Product Batch Traceability Maintenance
|
Allocating Batch/Bin/Serial Number Details At Goods Receipt
|
|
CB1 |
Cash Book Record Types |
Payment and Receipt methods (e.g. BGC = BACS/Bank Transfer; D/D = Direct Debit Payment).
|
Cash Book
|
|
CB2 |
Cash Book Manual Postings |
Payment and Receipt methods (e.g. CGS = Bank Charges; INT = Interest Received).
|
Cash Book (manual postings)
|
|
CB3 |
Cash Book Auto Cleared |
Payment and Receipt methods (e.g. CGS = Bank Charges; INT = Interest Received).
|
Cash Book (auto cleared items)
|
|
CFMT
|
Customer Reference Format
|
Formats for customer codes (e.g. A = AA/99999/AA). |
|
|
CLA |
Customer Class |
Customer Classes - i.e. different classes of customer (e.g. 0001 = Timber Importers; 0002 = Fencing Manufacturers; 0003 = Local Authorities).
|
Customer Maintenance; Branch Maintenance; Discount Matrix Maintenance
|
|
CO |
Company Names |
The name for your own company account.
|
|
|
CONT |
Credit Controller Names |
The individuals within your company who are authorised credit controllers (e.g. 0001 = Default Credit Controller; 0002 = John Smith).
|
Customer Maintenance; Credit Control And Reviews
|
|
COUN |
Country Codes |
Countries used in your system (e.g. 0001 = United Kingdom; 0002 = united States).
|
|
|
CREV
|
Credit Review Types |
Customer credit review types. |
Customer Maintenance; Credit Control And Reviews
|
|
CURR |
Currency Codes |
The currencies you will be working with (e.g. EUR = Euro; GBP = Pounds Sterling). This table file is supplied as standard with a complete set of three-character ISO 4217 currency codes and should not require editing.
|
|
|
DEP
|
Departments
|
A one-digit Department code from 1 to 9, enabling sales to be linked to a department within your company (e.g. 1 = Showroom; 2 = Yard).
|
Entering header details to Sales Orders and other sales documents. To use this feature the Optional Enhancement - Price Book 191 (Departmental Analysis) must be switched on. When a Sales Order is created a four-digit Staff Code is entered in the header (corresponding to entries on the STAF table file - see below). The first digit of the Staff Code must correspond to entries in the DEP table file.
|
|
DOC |
Document Types |
The document types you will be working with (e.g. Sales Header, Sales Trailer). Further document types may be added.
|
System-wide. Texts for these document types are set up in Terms and Conditions Maintenance
|
|
EUC
|
European Country Codes
|
Two-character European country codes (e.g. BE = Belgium; DK = Denmark).
|
If the Intrastat Report field is checked within the Sales Ledger - General Record and the Export field is checked within the Customer record, the code entered into the VAT Prefix field of the Customer record must exist as a value in the EUC table file.
|
|
FLDS |
Additional Fields
|
Data fields held against Customer and Supplier records (e.g. 0020 = Web Site Address; 0030 = Main Buyer Contact Name).
|
|
|
GDOC
|
GUI Document Types
|
Document types used in Quantum VS (e.g. 0001 = Acknowledgement; 0002 = Picking Note; 0003 = Despatch Note).
|
System-wide |
|
IBT |
IBT 'Live' Branches |
Branches which may be involved in Inter Branch Transfers (e.g. 0001 = Warrington; 0002 = Sheffield).
|
Branch Maintenance; Inter Branch Transfers
|
|
IBTe |
IBT Enquiry Status
|
Terms which indicate the current position of an Inter Branch Transfer (e.g. Request has been allocated etc.).
|
|
|
IBTs |
IBT Status Codes
|
IBT Status Codes (e.g. C = Confirmed; U = Unconfirmed; X = Cancelled).
|
|
|
IBTt |
IBT Record Types |
IBT Record Types (e.g. A = Stock Request; I = Stock Issue; R = Stock Receipt).
|
|
|
INTR
|
Introduction Codes
|
Options used in the 'Where did you hear about us?' field (e.g. 0001 = Newspaper Advertisement; 0002 = Radio Advertisement).
|
|
|
MAJP |
Major Product Groups
|
Major product categories (e.g. 0001 = Electrical; 0002 = Gardening and Landscaping; 0003 = Bathroom).
|
|
|
MBNK
|
Multiple Bank Accounts
|
An alternative nominal code to use when Cash invoices are posted. Each table file entry should be a number from 0001 to 0009, with the Description corresponding to a nominal code obtained using the Currency Code held against the customer. When a Cash invoice is posted, this nominal code is used in place of the nominal code entered in the Bank row (line 2) of the Sales Nominal Control record.
|
Sales Ledger/Nominal Control |
|
MOP |
Method of Order Placing |
Methods of placing an order (e.g. 0001 = Post; 0002 = Telephone; 0003 = Fax etc.).
|
|
|
OUTR
|
Buying Descriptions
|
Options in the Purchase Pack Qty (alternatively referred to as Outer Box Code) field within the Stock Tab of the Product record. This field is used to define the packaging quantity method that the Supplier uses when supplying the item (e.g. 0001 = Crate; 0002 = Pallet; 0003 = Box).
|
Product Maintenance - Stock Tab
|
|
OUTS
|
Outer Selling
|
Options in the Selling Pack Qty (alternatively referred to as Outer Box Code Selling) field within the Stock Tab of the Product record. This field is used to define the packaging quantity method used when selling the item (e.g. 0001 = Crate; 0002 = Pallet; 0003 = Box).
|
Product Maintenance - Stock Tab
|
|
P |
Product Groups |
Product groups, to which products may be allocated, enabling classification of products by type (e.g. 0001 = Tiles; 0002 = Plasterboards).
|
|
|
PAYM |
Payment Methods |
Payment methods available to customers (e.g. 0001 = Cash; 0002 = Cheque; 0003 = VISA).
|
Sales Order processing
|
|
PCUR |
Purchasing Currencies |
Buying currencies; i.e. currencies used by you and your suppliers (e.g. EUR = Euro; GBP = Pounds Sterling).
Note: To add new currency values and/or edit a currency's exchange rate see Defining 'Currency' Table Files For Multi-Currency Use. |
Multi-Currency Buying |
|
PICK |
Picking Descriptions |
Descriptions used in the picking procedure (e.g. 0001 = box; 0002 = pair; 0003 = pallet).
|
|
|
PIR |
Invoice Registrations |
Codes defining the Type of Purchase Invoice (i.e. 0001 = Stock; 0002 = Directs; 0003 = Expenses; 0004 = Haulage; 0005 = Credits).
|
|
|
PLIS |
Invoice Registration Status
|
Statuses used in Purchase Invoice Registration (e.g. 0001 = Held - Refer Invoice). Also known as Purchase Ledger Invoice Status.
|
Defining statuses used in Purchase Invoice Registration (e.g. Held - Refer Invoice) |
|
PRI |
Price Group Description
|
Price Groups - used as a way of classifying products (e.g. 0001 = Retail; 0002 = Trade A; 0003 = Trade B).
|
Price Maintenance; Product Maintenance; Discount Matrix Maintenance
|
|
PRN |
Print Destinations |
Output devices and locations for files and printing (e.g. Trash Can, Mailbox, Disk, Fax, System Printer etc.).
|
System-wide / Printing Maintenance |
|
PSTA
|
Product Status Description
|
Product status descriptions, which may be displayed to the right of the margin column when the product is added to sales documents (e.g. 0001 = Not stocked - buy in only; 0002 = No more to be ordered; 0003 = Price increase due).
|
Sales documents. Entries on the PSTA table file populate the menu for the Stock Status Code field in the Branch Stock record for a product. Optional Enhancement - Price Book 29 (Product Status Information) must be switched on to use this feature.
|
|
QCVR
|
Quote Conversion Reason
|
Reasons for why the Quote has not been converted to a Sales Order. |
Converting a Quote to a Sales Order
|
|
QDOC |
Q Docs
|
Document types used in Quantum Financials. Essentially a cross reference table for document types in Quantum VS and document types in Quantum Financials (e.g. 0001 = Purchase Invoice; 0002 = Purchase Credit Note; 1001 = Credit Sales Invoice).
|
Sales Invoicing and Purchase Invoicing - for posting documents to Quantum Financials
|
|
QTY |
Serial Line |
Printer values which reference the Application ID of the printer. The code used for each entry within this table file should correspond with the Application ID used for each printer record in Printer Maintenance.
|
|
|
RANK
|
Stock Rankings |
Stocking rankings (e.g. A = Stock Rank A; B = Stock Rank B).
|
|
|
RCR |
Reason Codes - Credit Notes |
Reasons for the return of goods and issuing a Credit Note.
Reason Codes under 1000 are used when goods are not being returned into stock (e.g. 0001 = Credit due to overcharge; 0002 = Allowance due to damaged goods). Codes over 1000 are used when goods are being collected/returned into stock (e.g. 1001 = Goods collected due to damage; 1004 = Goods collected - order error).
|
Issuing a Credit Note - in the Reason field of the Credit Note header
|
|
REA |
Reason Codes |
Reasons for stock adjustment/return of goods (e.g. 9001 - Damaged in transport; 9999 - Initial data input incorrect).
|
Stock Maintenance; Picking; Despatch
|
|
RECT
|
Receipt Identification Text
|
Descriptions to be printed on the till receipt when the Till Analysis Report is run. Note: only expects entries 0001 and 0002 to exist.
|
|
|
REG |
Region Codes |
Regions which your company branches may be assigned to (e.g. 0001 = Default Region Code; 0002 = East Midlands; 0003 = West Midlands).
|
|
|
REP |
Sales Representatives |
Your company sales representatives (e.g. 0001 = Office Accounts; 0002 = Richard Parker; 0003 = Dave Wilson).
|
Customer Maintenance. When setting up customer accounts each customer is assigned a sales rep. Sales reps are shown when creating Sales Orders, Quotes etc.
|
|
SCUR |
Sales Currency |
Selling currencies; i.e. currencies used by you and your customers (e.g. EUR = Euro; GBP = Pounds Sterling).
Note: To add new currency values and/or edit a currency's exchange rate see Defining 'Currency' Table Files For Multi-Currency Use. |
|
|
SOAC |
Order Analysis
|
Ways in which an order may have been placed (e.g. 0001 = Post; 0002 = Email).
|
Used at Sales Order entry, providing the Order Entry field is checked in Customer Maintenance
|
|
STAF |
Staff Numbers and Names |
The names and staff numbers of Quantum VS users (e.g. 0001 = Bill Parry; 0002 = Jack Parry).
|
User Maintenance; Sales Order header entry
|
|
STOK
|
Stock Takes In Progress
|
A list of active Stock Counts.
|
Stock Maintenance. Used to provide a list of active Stock Counts for selection when running a Stock Variance Report and when Performing A Stock Take. This feature is linked to the Optional Enhancement - Price Book 346 (Stock Take: Report Sequencing & Variance Checking).
|
|
TILL |
Till Numbers |
Till numbers/codes. A number of IO Lines/GUI Users (defined in the User record) can potentially be attributed to the same till number. Then, when the Extended Till Analysis report is run, it can be performed across a range of IO Lines/Users or specific tills (with collated users).
For example, a table file entry with the ID 0001 might have 'Till Code 1' in the first Description field and '222555666' in the second Description field. If you then run an Extended Till Analysis for Till 1, it automatically provides an analysis of cash taken by users 222, 555 and 666, where these are the Application IDs associated with a user.
|
Extended Till Analysis Report; User Maintenance
|
|
TITL
|
Sales Order Titles
|
Titles to be used on Sales Orders (e.g. 0001 = Mr; 0002 = Mrs; 0003 = Ms; 0004 = Miss; 0005 = Dr; 0006 = rev; 0098 = Key in manually; 0099 = leave blank).
|
Sales |
|
TLLS |
Long Length Surcharge Table |
Long Length Surcharge categories for timber products (e.g. 0001 = Softwood Surcharges; 0002 = Bill Surcharges).
|
Product Maintenance (for timber products). May be edited via Long Length Surcharges Maintenance
|
|
TMSK |
Timber Treatment Masks
|
Timber Treatment Mask categories for timber products (e.g. 0001 = Standard Metric; 0002 = Fencing; 0003 = MDF).
|
Length Mask Maintenance (for timber products)
|
|
TMTH |
Credit Terms - Months |
Credit terms, by month (e.g. 0001 = 1 month old; 0002 = 2 months old etc.).
|
|
|
TSHA
|
Timber Stock Holding Area |
Timber stock holding areas (e.g. C = Cardiff; F = Felixstowe).
|
Product Maintenance - for timber products; Stock Maintenance; Branch Maintenance
|
|
TSTA |
Timber Statistics Update |
Timber units of measure (e.g. 0001 = Volume; 0002 = Length; 0003 = Pieces; 0004 = Standards).
|
Product Maintenance - for timber products
|
|
TTLI |
Timber Treatment Lines |
Timber treatment lines (e.g. 0003 = Tanatone Brown; 0004 = Vac-Vac Treated).
|
Creating Timber, Sheet and Pack Products. May be edited via Treatments Maintenance
|
|
TTRE |
Timber Treatment Codes |
Timber treatment codes (e.g. 0003 = Carcassing; 0004 = Joinery Redwood; 0005 = Hardwood).
|
Creating Timber, Sheet and Pack Products
|
|
TWWS |
Timber Wide Widths |
Timber wide width codes.
|
Creating Timber, Sheet and Pack Products
|
|
TYPE
|
Market Type |
The market type a customer belongs to. This will typically relate to the credit/pricing terms the customer will be offered (e.g. 0001 = None; 0002 = 30 days; 0003 = 60 days). It may also be used as a classification for what type of customer the customer is (e.g. 0001 = Plumbing; 0002 = Joinery; 0003 = Heating and Electrical).
|
|
|
VEH
|
Vehicle Registration Codes
|
Vehicle/driver numbers.
|
|
|
WSTE
|
Product Waste
|
Product waste weight descriptions (e.g. 0001 = Cardboard Waste; 0002 = Paper Waste; 0003 = Polybag Waste).
|
Creating Product Waste Weight records in the Waste Weights tab of the Product Record
|
Note: There are additional table files available in Quantum VS which are not listed above because they are used only in extremely bespoke circumstances/installations.
Note: Do not edit any table file unless you understand clearly what you are doing and why. If necessary, contact Quantum VS Professional Services on 01342 333807 or psg@edp.co.uk for further guidance.