Enterprise 6 is supplied with one data file, entitled Tutorial.data, and several Business Templates for importing into a new data file. These are provided to help you when creating your live data file. Tutorial.data is intended for use in combination with the Tutorial manual and contains the appropriate data to facilitate this. Once you have created a blank data file and imported a Business Template, it will, apart from the variations introduced by the Template, be identical to Tutorial.data in the Data Manager set-up. Each Data Manager file contains a suggested set up which can be used or discarded as required. To discard the supplied set ups, select the appropriate function in the Data Manager. This will list all the records in the file. Use the key combination <Command-A> (Macintosh) or (Windows) to select all the records in the list and click the [Delete] button.
This appendix lists the information supplied and contains further information to aid the effective setting up of a clean data file.
Areas
The following Royal Mail postal areas are included: Area Code Area Name GB-A Scotland GB-B Northern Ireland GB-C North West & North Wales GB-D North West Conurbations GB-E North East GB-F Yorkshire GB-G East Midlands GB-H West Midlands GB-I East Anglia GB-J South East Midlands GB-K London GB-L South East GB-M South Coast GB-N Thames Valley GB-O South West & South Wales GB-P South West Coast IN-AF International - Africa IN-AN International - North America IN-AS International - South America IN-EE International - Eastern Europe IN-EW International - Western Europe IN-PA International - Pacific Rim
Countries
The Countries of the world are supplied. The attached Address Formats are approximate. Enterprise 6 Group would welcome notice of any inaccuracies. Country Address Format Afghanistan Z1EU Albania NEEU Algeria Z1EU American Samoa Z2EU Andorra ECEU Angola Z1EU Anguilla Z1EU Antigua and Barbuda Z1EU Argentina Z1US Armenia NEEU Aruba Z1EU Ascension Island Z1EU Australia Z2OZ Austria ECEU Azerbaijan NEEU Azores ECUK Bahamas Z1EU Bahrain Z1EU Balearic Islands ECUK Bangladesh Z1EU Barbados Z1UK Belarus NEEU Belau Z2EU Belgium ECEU Belize Z1EU Benin Z1EU Bermuda Z1EU Bhutan Z1EU Bolivia Z1EU Bosnia-Herzogovina NEEU Botswana Z1EU Brazil Z1EU British Indian Ocean Z1EU British Virgin Isles Z1EU Brunei Z1EU Bulgaria NEEU Burkina Faso Z1EU Burma Z1EU Burundi Z1EU Cambodia Z1EU Cameroon Z1EU Canada Z1US Canary Islands ECUK Cape Verde NEEU Cayman Islands Z1EU Central African Rep. Z1EU Ceuta Charafinas Z1EU Chad Z1EU Channel Islands UKUK Chile Z1EU China Z2EU Christmas Island Z1EU Cocos Keeling Islands Z1EU Colombia Z1EU Comoros Z1EU Congo Z1EU Cook Island Z2OZ Corsica ECEU Costa Rica Z1EU Croatia NEEU Cuba Z1EU Curação Z1EU Cyprus NEEU Czech Republic NEEU Denmark ECEU Djibouti Z1EU Dominica Z1EU Dominican Republic Z1EU East Timor Z1EU Ecuador Z1EU Egypt Z1EU Eire ECOZ El Salvador Z1EU England UKUK Equatorial Guinea Z1EU Eritrea Z1EU Estonia NEEU Ethiopia Z1EU Falkland Islands Z1EU Faroe Islands NEEU Fiji Z2EU Finland ECEU France ECEU French Antarctica Z2EU French Guiana Z1EU French Polynesia Z2EU French West Indies Z1EU Gabon Z1EU Gambia Z1EU Gaza and Khan Yunis Z1EU Georgia NEEU Germany ECEU Ghana Z1EU Gibraltar ECEU Greece ECEU Greenland NEEU Grenada Z1EU Grenadines Z1EU Guadeloupe Z1EU Guam Z2EU Guatemala Z1EU Guinea Z1EU Guinea - Bissau Z1EU Guyana Z1EU Haiti Z1EU Holland ECEU Honduras Z1EU Hong Kong Z1EU Hungary NEEU Iceland NEEU India Z1EU Indonesia Z1EU Iran Z1EU Iraq Z1EU Ireland ECOZ Israel Z1US Italy ECUK Ivory Coast Z1EU Jadu Z1EU Jamaica Z1EU Jan Mayen NEEU Japan Z2EU Jordan Z1EU Kazakhstan NEEU Kenya Z1EU Kiribati Z2EU Kuwait Z1EU Kyrgyzstan NEEU Laos Z1EU Latvia NEEU Lebanon Z1EU Lesotho Z1EU Liberia Z1EU Libya Z1EU Liechtenstein NEEU Lithuania NEEU Luxembourg ECEU Macau Z1EU Macedonia NEEU Madagascar Z1EU Madeira ECUK Malawi Z1EU Malaysia Z1EU Maldives Z1EU Mali Z1EU Malta NEEU Marshall Islands Z1EU Martinique Z1EU Mauritania Z1EU Mauritius Z1EU Mayotte Z1EU Melilla Z1EU Mexico Z1EU Micronesia Z2EU Moldova NEEU Monaco ECUK Mongolia Z2EU Montenegro NEUK Montserrat Z1EU Morocco Z1EU Mozambique Z1EU Myanmar Z1EU Namibia Z1EU Nauru Z2EU Nepal Z1EU Netherlands ECEU Netherlands Antilles Z1EU New Caledonia Z2EU New Zealand Z2OZ New Zealand Islands Z2EU Nicaragua Z1EU Niger Z1EU Nigeria Z1EU Niue Z2OZ Norfolk Island Z2EU North Korea Z2EU Northern Ireland UKUK Northern Mariana Is. Z2EU Norway NEEU Oman Z1OZ Pakistan Z1EU Panama Z1EU Papua New Guinea Z2EU Paraguay Z1EU Peru Z1EU Philippines Z2EU Pitcairn Island Z2EU Poland NEUK Portugal ECEU Puerto Rico Z1EU Qatar Z1EU Réunion Z1EU Romania NEUK Russia NEUK Rwanda Z1EU San Marino ECUK São Tomé & Príncipe Z1EU Saudi Arabia Z1EU Scotland UKUK Senegal Z1EU Serbia NEUK Seychelles Z1EU Sierra Leone Z1EU Singapore Z1EU Slovak Republic NEUK Slovenia NEEU Solomon Islands Z2EU Somalia Z1EU South Africa Z1OZ South Georgia Z1UK South Korea Z2EU South Sandwich Isles Z1UK Spain ECEU Spitzbergen NEUK Sri Lanka Z1EU St Helena Z1EU St Kitts and Nevis Z1EU St Lucia Z1EU St Pierre & Miquelon Z1EU St Vincent Z1EU Sudan Z1EU Suriname Z1EU Svalbard NEEU Swaziland Z1EU Sweden ECUK Switzerland NEUK Syria Z1EU Taiwan Z2EU Tajikistan NEUK Tanzania Z1EU Thailand Z1UK Tibet Z1EU Togo Z1EU Tokelau Z2OZ Tonga Z2EU Trinidad and Tobago Z1EU Tristan Da Cunha Z1EU Tunisia Z1EU Turkey NEUK Turkmenistan NEUK Turks & Caicos Isles Z1EU Tuvalu Z2EU Uganda Z1EU UK UKUK Ukraine NEUK United Arab Emirates Z1EU United Kingdom UKUK United States Z1US Uruguay Z1EU USA Z1US Uzbekistan NEUK Vanuatu Z2EU Vatican City State ECUK Venezuela Z1US Vietnam Z1EU Virgin Islands of USA Z1EU Wake Island Z2EU Wales UKUK Wallis and Futuna Is. Z2EU Western Samoa Z2EU Yemen Z1EU Zaire Z1EU Zambia Z1EU Zimbabwe Z1EU
Address formats
The Address Formats supplied also reflect the Royal Mail’s international zones. The Formats are samples only. Further information would be welcomed by Enterprise 6 Group.
Format Code
Format Name
ECEU Europe
Format EC
ECOZ Australian
Format EC
ECUK UK
Format EC
ECUS US
Format EC
NEEU Europe
Format Non-EC
NEOZ Australian
Format Non-EC
NEUK UK
Format Europe Non-EC
NEUS US
Format Non-EC
UKUK United Kingdom - Code Enforced & After County
Z1EU Europe
Format Zone 1
Z1OZ Australian
Format Zone 1
Z1UK UK
Format Zone 1
Z1US US
Format Zone 1
Z2EU Europe
Format Zone 2
Z2OZ Australian
Format Zone 2
Z2UK UK
Format Zone 2
Z2US US
Format Zone 2
Business types
The Business Types included are based on the Standard Industry Classification (SIC): 0100 Agriculture and Horticulture 1115 Solid Fuel Manufacturers 1300 Mineral Oil/Natural Gas Extraction 1401 Mineral Oil Refining 1610 Public Electricity Supply 1620 Public Gas Supply 1700 Water Supply Industry 2310 Quarrying and Mining 2420 Cement, Lime and Plaster 2436 Ready Mixed Concrete 2437 Other Concrete and Building Products 2440 Asbestos Goods 2450 Stone, Gravel and Slate Products 2551 Paints, Varnishes and Fillings 2570 Pharmaceutical Products 2582 Perfumes, Cosmetics and Toilet Preparations 2591 Photographic Materials and Chemicals 2599 Chemical Products (Other) 3169 Metal Smallware 3254 Groundwork Construction Equipment 3289 Precision Engineering Parts 3301 Office Machinery 3302 Electronic Data Processing Equipment 3433 Alarms and Signalling Equipment 3435 Electrical Equipment For Industry 3443 Radio/Electronic Goods 3480 Electrical Equipment Installation 3620 Railway Stock and Repair 3710 Measuring and Checking Instruments 4239 General Food and Beverages 4270 Brewing Products 4531 Weatherproof Outerwear 4532 Mens’ and Boys’ Tailored Outerwear 4536 Fancy and Infantwear 4539 Miscellaneous Dresswear 4630 Build Carpentry/Joinery 4671 Furniture and Bedding 4724 Paper Packaging Products 4751 Newspaper Printers and Publishers 4751A Newspaper Distributors 4751B National Newspapers 4751C Regional Newspapers 4752 Periodical Printers and Publishers 4753 Book Printers and Publishers 4754 Other Printing and Publishing 4754A Publishers 4754B Print/Graphic Designers 4835 Plastics Packaging Products 4836 Other Plastic Products 4930 Photographic Processing Laboratories 5000 General Construction and Demolition 5010 Building Construction and Repair 5020 Civil Engineering 5030 Installation of Fixtures and Fittings 5040 Building Completion Work 6120 Wholesalers - Fuels/Industrial Materials 6130 Wholesalers - Timber/Building Materials 6148 Wholesalers - Cars/Parts/Accessories 6150 Wholesalers - Hardware/Ironmongery 6170 Wholesalers - Food/Drink 6190 Wholesalers - General 6190A Wholesalers - Stationery 6410 Retailers - Food 6420 Retailers - Newsagents and Allied 6450 Retailers - Clothing 6470 Retailers - Furnishings/Textiles 6480 Retailers - Hardware/Ironmongery 6510 Retailers - Motor Vehicles 6530 Retailers - Stationery 6540 Retailers - Other Specific 6560 Mixed Retail Businesses 6611 Restaurants and Cafés 6620 Public Houses and Bars 6630 Night/Licensed Clubs 6640 Other Catering 7210/2 Bus and Coach Services 7230 Road Haulage 7400 Off-Shore Transport 7630 Supply Services/Sea Transport 7700 Travel Industry 7700A Consolidators 7700B Travel Agents 7700C Tour Operators 7700D Passport and Visa Companies 7700E Leisure Companies 7901 Postal Services 7902 Telecommunications 8140 Banking 8150 Credit/Investment Institutions 8150A Building Societies 8150B Financial Advisers/Consultants 8200 Insurance Institutions 8310 Banking/Finance Auxiliary 8310A Stock Brokers 8320 Insurance/Acturarial Auxiliary 8320A Insurance Consultants/Brokers 8320B Acturaries 8340A House and Estate Agents 8340B Property Management Agents 8350 Legal Services 8350A Solicitors 8350B Barristers 8350C Law Costs Draftsmen 8350D Bailiffs/Sheriffs Offices 8350E Licensed Conveyancers 8350F Patent Agents 8360 Accountants and Auditors 8370 Architects/Surveyors/Technical Services 8380 Advertising 8394 Computer Services 8395 General Business Services 8395/1 Management Consultants 8395A Investigation Companies 8395B Media Companies 8395C Media Reps 8395D Public Relations Companies 8395E Recruitment/Head Hunters 8395F Mailing Houses 8396 Head and Central Offices 8420 Hiring Construction Machinery/Equipment 8430 Hiring Office Machinery/Equipment 8460 Hiring Consumer Goods 8500 Owning/Dealing Real Estate 9111 Other National Government Services 9111A Inland Revenue 9112 Other Local Government Services 9120 Justice 9120A Courts or Sheriffs Offices 9120B Crown Prosecution Service 9130 Police 9140 Fire Services 9211 Refuse Disposal/Street Cleaning 9230 Cleaning Services 9310 Higher Education 9320 School Education 9330 Other Education 9400 Research and Development 9510 Hospitals/Nursing Homes 9530 Medical Practices 9550 Agency Medical Staff 9560 Veterinary Practices 9611 Social Services 9631A Professional/Business Organisations 9660 Religious Organisations 9690 Community Services 9741 Arts and Media 9770 Libraries/Museums/Galleries 9791 Leisure Activities 9890 Miscellaneous Personal Services
Roles
The following basic roles are included for use with Contacts: Role Code Role Name A Authority I Influencer M Money N Need P Principal
Stock types
Shown below are the Stock Types supplied. Code Type Name Ignore Include in Re- Has an Minus Order Item Locations Ordering Asset Value Warning Allocated TotalP Physical False True True True True O On Order True True False False False R In For Repair False False False True False C Customer True False False False False S Supplier True False False False False L On Loan True False False True False A Assembly False False False False False
Movement types
Code Type Name Stock Stock Number Plus Minus Name AL Adjustment/Opening - Loan Stock L ALO Allocation of Stock P P Allocation AO Adjustment/Opening - On Order Stock O AP Adjustment/Opening - Physical Stock P AR Adjustment/Opening - Repair Stock R ILC Goods In - Returned From Loan to Client P L Loan Receipt No IRC Goods In - For Repair From Client R C Repair No ISA In Stock Assembled P P Assembly No ISC Goods In - Return to Stock From Client P C Return No ISO Goods In - to Stock As Ordered P O Receipt No ISS Goods In - to Stock Not Ordered P S Receipt No LP Location Change - Physical Stock P P Loc Change OLC Goods Out - On Loan to Client L P Loan No ORC Goods Out - Return Repair to Client C R Repair Del No ORS Goods Out - Return Repair to Supplier S R Your RMA OSC Goods Out - From Stock to Client C P Delivery No OSS Goods Out - Return Stock to Supplier S P Your RMA PO Purchase Order O S Purch Ord No RA Returns Authorisation RMA No UNAL Unallocation of Stock P P Unallocation
Credit stages
Four sample Credit Stages are supplied. None have any controls switched on which may prevent the raising of Delivery Notes or Invoices. Stage Code Stage Name Letter Days Next Stage A First Stage - 30 Days after invoice 30 B B Second Stage - 60 Days after invoice 60 C C Third Stage - 90 Days after invoice 90 H H On Hold
Accounts
Shown below is the skeleton accounts structure supplied with Enterprise 6. The table shows for each Account the Report and Group Heading, whether it is a Profit & Loss or Balance Sheet item and the VAT status. The Report and Group Headings are used for formatting the reports - please refer to the Accounts Headings section for more information. The Accounts dealing with Sales (in the range 40000 - 48900) and Purchases (in the range 50000 - 58900) are set up so that they cannot be used directly in the General Ledger. Control Accounts also have this setting. They can only be used in Sales and Purchase Invoices and posted in to the General Ledger from there.
Code
Account Name
ReportHeading
Group Heading
P&L/BS
I/O/N
00100
Goodwill
B1
GB2
B
N
01000
Land/Buildings at Cost
B1A
GB2
B
N
01005
less Land/Buildings Accm Depreciation
B1A
GB2
B
N
01100
Leasehold Premises at Cost
B1B
GB2
B
N
01105
less Leasehold Premises Accm Depreciation
B1B
GB2
B
N
01200
Leasehold Improvements at Cost
B1C
GB2
B
N
01205
less Leasehold Improvements Accm Depre’n
B1C
GB2
B
N
04000
Fixtures & Fittings at Cost
B1E
GB2
B
N
04005
less Fixtures & Fittings Accm Depreciation
B1E
GB2
B
N
05000
Computer Equipment at Cost
B1F
GB2
B
N
05005
less Computer Equipment Accm Depreciation
B1F
GB2
B
N
06000
Office Equipment at Cost
B1G
GB2
B
N
06005
less Office Equipment Accm Depreciation
B1G
GB2
B
N
08000
Commercial Vehicles at Cost
B1H
GB2
B
N
08005
less Commercial Vehicles Accm Depreciation
B1H
GB2
B
N
09100
Cars at Cost
B1I
GB2
B
N
09105
less Cars Accm Depreciation
B1I
GB2
B
N
09500
Sundry Assets at Cost
B1J
GB2
B
N
09505
less Sundry Assets Accm Depreciation
B1J
GB2
B
N
10300
Stocks, Shares and Investments
B1
GB2
B
N
10400
Loans to Related Companies
B1
GB2
B
N
10900
Loans Issued
B1
GB2
B
N
11000
Stock - Type A
B2
GB1
B
N
11001
Stock - Type B
B2
GB1
B
N
11002
Stock - Type C
B2
GB1
B
N
11003
Stock - Other
B2
GB1
B
N
11600
WIP Control Account - Time
B2
GB1
B
N
11700
WIP Control Account - Cost Items
B2
GB1
B
N
12000
Trade Debtors
B2
GB1
B
N
12300
Sundry Debtors
B2
GB1
B
N
12400
Exch Control Difference on period translation
B2
GB1
B
N
12500
Deposits Holding Account
B2
GB1
B
N
13000
Doubtful Debts Provision
B2
GB1
B
N
14500
Loans to Directors
B2
GB1
B
N
14700
Loans to Employees
B2
GB1
B
N
15100
Loans to Third Parties
B2
GB1
B
N
15500
Suspense Account - Sales Ledger
B2
GB1
B
N
15700
Corporation Tax Refunds
B2
GB1
B
N
15800
Other Current Assets
B2
GB1
B
N
15900
Called Up Share Capital Not Paid
B2
GB1
B
N
16000
Prepayments
B2
GB1
B
N
16200
Accrued Income
B2
GB1
B
N
16500
Shares In Related Companies
B2
GB1
B
N
17000
Bank - Current No 1
B2
GB1
B
N
17200
Bank - Current No 2
B2
GB1
B
N
18000
Bank - Foreign Account
B2
GB1
B
N
18500
Bank - Deposit/Reserve
B2
GB1
B
N
19100
Building Society - Deposit
B2
GB1
B
N
19600
Petty Cash
B2
GB1
B
N
19900
Cash Float
B2
GB1
B
N
20000
Debenture Loans - Short Term
B3
GB1
B
N
20100
Bank - Overdraft
B3
GB1
B
N
20500
Other Loans - Short Term
B3
GB1
B
N
20800
Hire Purchase - Short Term
B3
GB1
B
N
20900
Deferred HP Interest - Short Term
B3
GB1
B
N
21000
Loans Due - Short Term
B3
GB1
B
N
21500
Payments Received on Account
B3
GB1
B
N
22000
Trade Creditors
B3
GB1
B
N
22300
Sundry Creditors
B3
GB1
B
N
22400
Exch Control Difference on period translation
B3
GB1
B
N
22500
Purchase Deposits Holding Account
B3
GB1
B
N
23400
Taxes b/fwd - Corporation
B3
GB1
B
N
23500
Taxes b/fwd - ACT
B3
GB1
B
N
23600
Taxes b/fwd - Income
B3
GB1
B
N
23700
Taxes Provision - Corporation
B3
GB1
B
N
23800
Taxes Provision - ACT
B3
GB1
B
N
23900
Taxes Provision - Income
B3
GB1
B
N
24000
Taxes Paid - Corporation
B3
GB1
B
N
24100
Taxes Paid - ACT
B3
GB1
B
N
24200
Taxes Paid - Income
B3
GB1
B
N
24450
Other Profit Related Taxes
B3
GB1
B
N
24500
PAYE Control
B3
GB1
B
N
24600
NIC Control
B3
GB1
B
N
24800
Sub-Contractors Tax
B3
GB1
B
N
25000
VAT Return - Current Liabilities
B3
GB1
B
N
25025
Cash VAT Suspense Account
B3
GB1
B
N
25050
VAT Payments Due - Previous Quarters
B3
GB1
B
N
25100
EC VAT Purchases Creditors
B3
GB1
B
N
25200
Other Taxes
B3
GB1
B
N
26000
Loans from Directors - Short Term
B3
GB1
B
N
26100
Loans from Employees - Short Term
B3
GB1
B
N
26400
Loans from Third Parties - Short Term
B3
GB1
B
N
27000
Payroll Control
B3
GB1
B
N
27700
Credit Card Control
B3
GB1
B
N
28000
Expenses Control
B3
GB1
B
N
28600
Suspense Account - Purchase Ledger
B3
GB1
B
N
29000
Accruals
B3
GB1
B
N
29300
Deferred Income
B3
GB1
B
N
29500
Proposed Dividends
B3
GB1
B
N
30000
Debenture Loans - Long Term
B4
GB2
B
N
30100
Bank Loan - Long Term
B4
GB2
B
N
30200
Other Loans - Long Term
B4
GB2
B
N
30500
Hire Purchase - Long Term
B4
GB2
B
N
30600
Deferred HP Interest - Long Term
B4
GB2
B
N
30700
Loans Due - Long Term
B4
GB2
B
N
34000
Loans from Directors - Long Term
B4
GB2
B
N
34300
Loans from Employees - Long Term
B4
GB2
B
N
34500
Loans from Third Parties - Long Term
B4
GB2
B
N
34860
Pension Liabilities
B4
GB2
B
N
34900
Deferred Taxation
B4
GB2
B
N
34950
Other Provisions
B4
GB2
B
N
37000
Ordinary Shares
B5
GB3
B
N
37100
Preference Shares
B5
GB3
B
N
37300
Other Classes of Shares
B5
GB3
B
N
37400
Loan Capital
B5
GB3
B
N
38500
Share Premium
B5
GB3
B
N
38600
Revaluation Reserve
B5
GB3
B
N
38950
Other Reserves
B5
GB3
B
N
39000
Profit & Loss Brought Forward
B5
GB3
B
N
39500
Profit & Loss Year-To-Date
B5
GB3
B
N
39800
Adjustments Re Prior Years
B5
GB3
B
N
40000
Sales - Type A
P1A
GP1
P
O
40001
Sales - Type A
P1A
GP1
P
O
40002
Sales - Type A
P1A
GP1
P
O
41000
Sales - Type B
P1B
GP1
P
O
41001
Sales - Type B
P1B
GP1
P
O
41002
Sales - Type B
P1B
GP1
P
O
42000
Sales - Type C
P1C
GP1
P
O
42001
P1C
GP1
P
O
42002
Sales - Type C
#VALUE!
P1C
GP1
P
O
47000
Income - Other
P1D
GP1
P
O
48000
Sales Carriage
P1D
GP1
P
O
48100
Sales Post & Packaging
P1D
GP1
P
O
48900
Discount Given
P1D
GP1
P
O
50000
Purchases - Type A
P2A
GP1
P
I
50001
Purchases - Type A
#VALUE!
P2A
GP1
P
I
50002
Purchases - Type A
#VALUE!
P2A
GP1
P
I
51000
Purchases - Type B
P2B
GP1
P
I
51001
Purchases - Type B
P2B
GP1
P
I
51002
Purchases - Type B
P2B
GP1
P
I
52000
Purchases - Type C
P2C
GP1
P
I
52001
Purchases - Type C
P2C
GP1
P
I
52002
Purchases - Type C
P2C
GP1
P
I
57000
Other Purchases
P2D
GP1
P
I
58000
Purchases Carriage
P2D
GP1
P
I
58100
Purchases Post & Packaging
P2D
GP1
P
I
58900
Discount Received
P2D
GP1
P
I
59000
Stock Movement Account
P2
GP1
P
N
59250
Stock Write Offs
P2
GP1
P
N
59450
Stocktake Adjustments
P2
GP1
P
N
59500
WIP Movements - Time
P2
GP1
P
N
59600
WIP Movements - Cost Items
P2
GP1
P
N
59700
WIP Write Offs - Time
P2
GP1
P
N
59800
WIP Write Offs - Cost Items
P2
GP1
P
N
70200
Commission/Promotion Costs
P3
GP2
P
N
73000
Telephone (Sales & Marketing)
P3
GP2
P
I
73300
Fax (Sales & Marketing)
P3
GP2
P
I
73600
Mobiles (Sales & Marketing)
P3
GP2
P
I
73900
Couriers/Post (Sales & Marketing)
P3
GP2
P
I
74000
Equipment Leasing (Sales & Marketing)
P3
GP2
P
I
74300
Advertising - Space
P3
GP2
P
I
74500
Advertising - Printing & Artwork
P3
GP2
P
I
74700
Publicity Materials
P3
GP2
P
I
74900
Promotional Items
P3
GP2
P
I
75000
PR & Consultancy
P3
GP2
P
I
75500
Exhibition Costs
P3
GP2
P
I
76500
Other Marketing costs
P3
GP2
P
I
78000
Rent
P4
GP2
P
I
78100
Rates
P4
GP2
P
I
78200
Services
P4
GP2
P
I
78300
Light & Heat
P4
GP2
P
I
78400
Property Insurance
P4
GP2
P
N
78500
Security Costs
P4
GP2
P
I
78600
Repairs & Renewals To Property
P4
GP2
P
I
78700
Other Establishment Costs
P4
GP2
P
I
79000
Depreciation
P4
GP2
P
N
79100
Disposal Proceeds
P4
GP2
P
N
79200
Profit/Loss On Disposal
P4
GP2
P
N
80000
Salaries
P4
GP2
P
N
80300
Salaries
P4
GP2
P
N
80600
Salaries Overtime P5
P5
GP2
P
N
80900
Salaries Employers NIC
P5
GP2
P
N
81000
Directors Remuneration P5
P5
GP2
P
N
81300
Directors Fees P5
P5
GP2
P
N
81900
Directors Employers NIC
P5
GP2
P
N
82000
Temporary Staff P5
P5
GP2
P
I
82400
Redundancy Costs P5
P5
GP2
P
N
82500
Ex-Gratia Payments P5
P5
GP2
P
N
82600
Pension Costs P5
P5
GP2
P
N
82700
Life Assurance Premiums P5
P5
GP2
P
N
82800
Health Insurance P5
P5
GP2
P
N
83000
Training P5
P5
GP2
P
I
83200
Recruitment P5
P5
GP2
P
I
83500
Canteen P5
P5
GP2
P
I
83600
Staff Welfare P5
P5
GP2
P
I
83700
Staff Social Functions P5
P5
GP2
P
I
83800
Gratuities P5
P5
GP2
P
N
84000
Travelling P5
P5
GP2
P
N
84200
Entertaining P5
P5
GP2
P
N
84400
Accommodation & Subsistence P5
P5
GP2
P
I
84500
Motor Leasing P5
P5
GP2
P
I
84600
Motor Expenses - Petrol P5
P5
GP2
P
I
84800
Motor Expenses - Insurance P5
P5
GP2
P
N
84900
Motor Expenses - Other P5
P5
GP2
P
I
85000
Telephone P5
P5
GP2
P
I
85200
Fax P5
P5
GP2
P
I
85500
Mobiles P5
P5
GP2
P
I
85600
Couriers P5
P5
GP2
P
I
85700
Postage P5
P5
GP2
P
N
86000
General Insurance P5
P5
GP2
P
N
86500
Repairs & Maintenance P5
P5
GP2
P
I
86700
Equipment Leasing Costs P5
P5
GP2
P
I
86800
Equipment Consumables P5
P5
GP2
P
I
87000
Computer Maintenance & Consultancy P5
P5
GP2
P
I
87200
Computer Consumables P5
P5
GP2
P
I
87300
Computer Software P5
P5
GP2
P
I
87700
Books & Journals P5
P5
GP2
P
N
87800
Printing P5
P5
GP2
P
I
87900
Stationery P5
P5
GP2
P
I
88000
Subscriptions P5
P5
GP2
P
I
88100
Cleaning P5
P5
GP2
P
I
88150
Charitable Donations P5
#VALUE!
P5
GP2
P
N
88200
Audit Fees P5
P5
GP2
P
I
88300
Accountancy Fees P5
P5
GP2
P
I
88400
Bookkeeping P5
P5
GP2
P
I
88500
Legal Fees P5
P5
GP2
P
I
88600
Consultancy Professional P5
P5
GP2
P
I
88900
Miscellaneous Costs P5
P5
GP2
P
I
88950
Other Administrative Costs P5
#VALUE!
P5
GP2
P
I
89000
Depreciation P5
P5
GP2
P
N
89100
Disposal Proceeds P5
P5
GP2
P
N
89200
Profit/Loss On Disposal P5
P5
GP2
P
N
90000
Rent & Rates Receivable P6
P6
GP2
P
O
90500
Investment Income P6
P6
GP2
P
N
90700
Interest Receivable P6
P6
GP2
P
N
91000
Miscellaneous Income P6
P6
GP2
P
N
91800
Other Receipts P6
P6
GP2
P
N
92000
Bank Overdraft Interest P7
P7
GP2
P
N
92500
Bank Loan Interest P7
P7
GP2
P
N
93000
Other Loan Interest P7
P7
GP2
P
N
93500
HP/Finance Lease Interest P7
P7
GP2
P
N
93700
Other Interest P7
P7
GP2
P
N
94000
Inland Revenue Interest/Penalties P7
P7
GP2
P
N
94200
VAT Interest/Penalties P7
P7
GP2
P
N
95000
Bank Charges & Facility Fees P7
P7
GP2
P
I
95300
Bank & Foreign Exchange Fees P7
P7
GP2
P
N
96000
Credit Card Charges P7
P7
GP2
P
N
97000
Foreign Exchange Differences P7
P7
GP2
P
N
99000
Corporation Tax Current P8
P8
GP2
P
N
99200
Corporation Tax Under/Overprovision P8
P8
GP2
P
N
99300
Transfer To/From Deferred Tax P8
P8
GP2
P
N
99400
Deferred Tax P8
P8
GP2
P
N
99500
Dividends P9
P9
GP2
P
N
Enterprise 6 is supplied with several alternative accounts structures. These are intended for use in specialised businesses for which the basic structure shown above would not be sufficient. They are supplied as separate files and should be imported to Enterprise 6 if required.
Accounts headings
A basic set of Account Headings is supplied with Enterprise 6. These are used for structuring accounts reports. Basic headings for levels below level 1 have been supplied but these should be modified to be specific to your business. For example, sub-headings to P1 Sales (P1A to P1D are supplied) would represent the different types of products sold. Code Heading Name Report Level-1 Group Level Code Code B1 Fixed Assets 1 GB2 B2 Current Assets 1 GB1 B3 Current Liabilities 1 GB1 B4 Long Term Liabilities 1 GB2 B5 Capital 1 GB3 GB1 Net Current Assets 1 GB2 Net Assets 1 GB3 Shareholders Funds 1 GP1 Gross Profit 1 GP2 Net Costs 1 P1 Sales 1 GP1 P2 Cost of Sales 1 GP1 P3 Sales & Marketing 1 GP2 P4 Establishment 1 GP2 P5 Administration 1 GP2 P6 Other Income 1 GP2 P7 Financial 1 GP2 P8 Taxes on Profits 1 GP2 P9 Distributions & Exceptional Items 1 GP2 B1A Land/Buidings/Property 2 B1 GB2 B1B Leasehold Premises 2 B1 GB2 B1C Leasehold Improvements 2 B1 GB2 B1D Plant/Machinery 2 B1 GB2 B1E Fixtures & Fittings 2 B1 GB2 B1F Computer Equipment 2 B1 GB2 B1G Office Equipment 2 B1 GB2 B1H Commercial Vehicles 2 B1 GB2 B1I Cars 2 B1 GB2 B1J Sundry Assets 2 B1 GB2 P1A Sales - Group 1 2 P1 GP1 P1B Sales - Group 2 2 P1 GP1 P1C Sales - Group 3 2 P1 GP1 P1D Sales - Other 2 P1 GP1 P2A Purchases - Group A 2 P2 GP1 P2B Purchases - Group B 2 P2 GP1 P2C Purchases - Other 2 P2 GP1 Periods Enterprise 6 is supplied with monthly accounting Periods between April 1994 and December1999. When Enterprise 6 is first used, the Period containing the current date will be opened automatically. Transaction types All Transaction Types have an Analysis Code of ‘A’, a Layer Code of ‘A’ and a Currency of £. Eight Transaction Types (PINV, PP, PPRE, PPRR, RDEP, RDER, RINV and RIP) are set up so that they cannot be used directly in the General Ledger. They are the Transaction Types representing Sales and Purchase Invoices and their Receipts and Payments and should only be used in their respective Ledgers and posted in to the General Ledger from there. Code Transaction Name Debit Acc Credit Acc Tax Code J Adhoc Journals N JTRV Transfer VAT 25000 25050 N P Adhoc Payments 17000 N PCAS Petty Cash Withdrawal 19600 17000 N PINV Purchase Invoice 57000 22000 S PP Purchases Payment 22000 17000 N PPRE Purchases Pre-Payment 22500 17000 N PPRR Pre-Payments Reconciliation 22000 22500 N PSAL Salaries Payments Posting 27000 17000 N R Adhoc Receipts 17000 N RDEP Deposit Receipt 17000 12500 N RDER Deposit Reconciliation 12500 12000 N RINV Sales Invoice 12000 47000 S RIP Receipt Invoice Payment 17000 12000 N STIN Stock In 11000 50000 N STOU Stock Out 50000 11000 N WCIP WIP Cost Items Posting 11700 59600 N WCIW WIP Cost Items Write Offs 59800 11700 N WTRP WIP Time Recording Posting 11600 59500 N WTRW WIP Time Recording Write Offs 59700 11600 N
Analyses
Two sample, generic Analyses are supplied. If you need to account for different branches or departments, they should be modified to your requirements.
VAT codes
The four standard GB VAT Codes are supplied. Code Tax Name Tax Rate (%) S Standard VAT 17.5 Z Zero VAT 0 E Exempt VAT 0 F Fuel VAT 8
Currencies
Users of the Multi-currency volume have access to the currencies of the world, listed below. Currency Code Currency Name $A Australian Dollar $NZ New Zealand Dollar $T Tuvalu Dollar Af Afghani B (Panamanian) Balboa Ba$ Bahamian Dollar Baht Thai Baht BD Bahrain Dinar BDS$ Barbados Dollar BF Belgian Franc Br Ethiopia Birr Br$ Brunei Dollar Bs Boliviano BZ$ Belize Dollar C$ (Nicaraguan) Córdoba Oro Can$ Canadian Dollar CF Comorian Franc CFAF CFA Franc CFPF Franc of the Comptoirs Français Du Pacifique Ch$ (Chilean) Peso Col$ (Columbian) Peso Cr$ (Brazilian) Cruzeiro CR¢ Costa Rican Colón CUP Cuban Peso CVEsc (Cape Verde) Escudo C£ Cyprus Pound D (Vietnamese) Dong DA Algerian Dinar Db (São Tomé and Príncipe) Dobra Denar (Macedonian) Denar DF Djibouti Franc DH Moroccan Dirham Din New Yugoslav Dinar Dinar (Tunisian) Dinar Dkr (Danish) Krone DM Deutsche Mark Dr (Greek) Drachma E (Swaziland) Lilangeni EC$ East Caribbean Dollar EEK (Estonian) Kroon Esc (Portuguese) Escudo ES¢ (El Salvador) Colón F Franc F$ Fiji Dollar f. Netherlands Guilder FBu Burundi Franc FMG Malagasy Franc Fmk (Finnish) Markka Ft (Hungarian) Forint G (Haitian) Gourde G D (Gambian) Dalasi G$ Guyana Dollar GF Guinean Franc HK$ HK Dollar HrD Croatian Dinar ID Iraqi Dinar ISK (Icelandic) Króna J$ Jamaican Dollar JD Jordan Dinar K Myanmar Kyat K Sh Kenya Shilling Kcs (Czech) Koruna KD Kuwaiti Dinar KN (Laotian) Kip L Honduran Lempira L Lit (Lithuanian) Lit L$ Liberian Dollar LD Libyan Dinar LE Egyptian Pound Lek (Albanian) Lek Leu Romanian Leu Lev (Bulgarian) Lev Lit (Italian) Lira LL Lebanese Pound Lm Maltese Lira LR Latvian Ruble LS Syrian Pound LSd Sudanese Pound LT Turkish Lira Lux F Luxembourg Franc M (Lesotho) Loti M$ Ringgit (Malaysian Dollar) Manat (Azerbaijan) Manat Mau R Mauritian Rupee Mex$ (Mexican) Peso MK Malawi Kwacha Mt (Mozambique) Metical N Nigerian Naira NA f. Netherlands Antillean Guilder Nam$ Namibian Dollar NIS New Israeli Sheqel NKr Norweigian Krone NKz (Angolan) New Kwanza NRs Nepalese Rupee NT$ New Taiwan Dollar Nu (Bhutan) Ngultrum NUr$ Uruguayan New Peso P (Botswana) Pula P G Paraguayan Guaraní Pa (Macau) Pataca PG Guinea-Bissau Peso PNG K Papua New Guinea Kina PP Philippine Peso PRs Pakistan Rupee Ps (Argentine) Peso Pta (Spanish) Peseta Q Guatemalan Quetzal QR (Qatar) Riyal R (South African) Rand RD$ Dominican Peso Re Indian Rupee Rf Maldivian Rufiyaa Riel (Cambodian) Riel Rls (Iranian) Rial RO Rial Omani Rp Indonesian Rupiah Ruble Ruble Rw F Rwanda Franc S (Austrian) Schilling S$ Singapore Dollar S/. (Ecuadorian) Sucre Sf Suriname Guilder SI$ Solomon Islands Dollar SKr Swedish Krona SL Rs Sri Lanka Rupee SLe (Sierra Leone) Leone So.Sh Somali Shilling Sol (Peruvian) Nuevo Sol SR Seychelles Rupee SRIs Saudi Riyal Sw F Swiss Franc T (Mongolian) Tugrik T Sh Tanzanian Shilling T$ (Tongan) Pa’anga Tk Bangladesh Taka Tolar (Slovenian) Tolar TT$ Trinidad and Tobago Dollar U Sh Uganda Shilling UAEDh UAE Dirham UM Mauritanian Ouguiya US$ US Dollar V B (Venezuelan) Bolívar VT (Vanuatu) Vatu W (South Korean) Won Won (North Korean) Won WS$ (Western Samoan) Tala Y (Chinese) Renminbi (Yuan) YRls Yemen Rial Z Zaïre Z$ Zimbabwe Dollar ZK Zambian Kwacha Zl (Polish) Zloty ¢ (Ghanaian) Cedi £ Pound Sterling £Ir Irish Pound ¥ (Japanese) Yen Where the nationality is placed in parentheses, it is not officially part of the currency name. There is some duplication in the official abbreviations of some of the world’s currencies. To avoid confusion in Enterprise 6, it has been necessary to alter these abbreviations for some currencies. These alterations are listed below.
E6 code
Currency
Correct Code
Ba$
Bahamian Dollar
B$
Baht
Thai Baht
B
Br$
Brunei Dollar
B$
Dinar
(Tunisian) Dinar
D
G D
(Gambian) Dalasi
D
L Lit
(Lithuanian)
Lit L or Lit
Mau R
Mauritian Rupee
Mau Re
Pa
(Macau) Pataca
no recognised abbreviation
PNG K
Papua New Guinea Kina
K
PP
Philippine Peso
P
Rw F
Rwanda Franc
RF
Sol
(Peruvian) Nuevo Sol
no recognised abbreviation
SLe
(Sierra Leone)
Leone Le
T
(Mongolian)
Tugrik no recognised abbreviation
UAEDh
UAE Dirham
Dh
V B
(Venezuelan) Bolìvar
B
ZK
Zambian Kwacha
K
Actions
The following Actions are supplied for use in the Diary. Action Code Action Name Priority AC Admin Call AV Admin Visit FC Finance Call (Credit Control) ML Mail Letter 1 MQ Mail Quotation 1 PC Purchasing Call 2 PE Promotion - Exhibition 1 PS Promotion - Seminar 2 PV Purchasing Visit 3 SC Sales Call 1 SE Sales Enquiry 1 ST Sales Time (Chargeable) 1 SV Sales Visit 1 TC Technical Call TT Technical Time (Chargeable) TV Technical Visit VS Sales Visit 1
Documents
In the Word Processing volume, Enterprise 6 is supplied with two templates and three sample documents. The templates are usable only with 4D Write, but the sample documents are supplied in both 4D Write and non-4D Write versions. The sample Documents supplied are three debt-chasing letters, with the Document Codes of DEBT1, DEBT2 and DEBT3. The two templates supplied are entitled ‘Letter Template’ and ‘Quote Template’. They are separate files and must be stored in the same desktop folder as the Enterprise 6 structure file. The ‘Letter Template’ is used by the ‘Enter Letters’ and ‘Enter Documents’ functions, while the ‘Quote Template’ is used by ‘Enter Quotations’. Both templates feature Enterprise 6 variables and text placeholders. The Enterprise 6 variables can be moved or deleted, but if alternative variables are to be inserted, this must be done using the ‘Insert 4D Expression…’ function on the Word Processor’s Database menu. The text placeholders are used to indicate where text should be typed in the documents and can simply be overwritten. The Word Processing Reference chapter contains details of many of the Enterprise 6 variables that can be included in letters. Below are listed some further variables, mainly taking their information from the Preferences screen, which will be useful, especially in the basic design of the letterhead. The ◊ character is obtained using the key combination on the Macintosh. On Windows machines, the 2/3 symbol is used in place of ◊ and can be obtained by holding down the <Alt> key while typing “0190”. Note that in these manuals, ◊ has been used in all interprocess variables for reasons of clarity. If you are a Windows user, remember to substitute the 2/3 character where appropriate.
The following Enterprise 6 variables refer to fields on the User Details page of Preferences.
«◊UserName» Contains the User’s Name. «◊UserDetail» Contains the User’s address, with each line separated by carriage returns. «◊UserTel» Contains the User’s Telephone Number. «◊VATNo» Contains the User’s VAT Number. «◊VatPref» Contains the User’s VAT Prefix. «◊OfficeCode» Contains the User’s Office Code.
The following Enterprise 6 variables refer to fields on the Sales Orders and Ledger page of Preferences.
«◊AD1» Contains the first aging period(number of days). «◊AD2» Contains the second aging period(number of days). «◊AD3» Contains the third aging period(number of days).
The following Enterprise 6 variables refer to fields on the Form Settings 1 page of Preferences.
«◊TitAdd» Contains the Address, Tel, Fax. «◊TitReg» Contains the VAT Reg No, Registered Office etc.«◊TitDepCo» Contains the Sales Dept, Company.«◊TitDepCoP» Contains the Purchase Dept, Company.«◊TitDepCoS» Contains the Service Dept, Company.«◊TitPay» Contains the Payment Terms.«◊TitPayB» Contains the T & C, E & OE etc.«◊TitAuth» Contains the Authorisation.
SuperReport forms
Enterprise 6 is supplied with the following SuperReport Pro forms: File File Number Report Code Sales Invoices 39 SR Invoice SR Invoice DT (ie an Invoice with a separate delivery address) Sales Orders 24 SR Order Quote SR Order Auth SR Order Ack SR Delivery Purchase Invoices 37 SR Remittance SR Cheque Stock Movements 40 SR Movement Purchase Orders 57 SR Purch Order Service Contracts 17 SR Contract Service Calls 20 SR Call Sheet The forms supplied are very much templates and should be altered to your requirements using the [Edit Templates] button on the Forms Settings 2 page of Preferences. If you wish to create your own versions of these forms, it is recommended that you use the supplied forms as models, as they contain the necessary Start Script and Array names. If you have indicated on that page that you wish to print using SuperReport forms, the forms will be used whenever printing from a relevant function. You can print using the standard Enterprise 6 forms if you select the print function while holding down the
Replacing built-in reports with SuperReport reports
All Enterprise 6 reports can use SuperReport equivalents. As with SuperReport forms described above, SuperReport reports will be used if you have switched on the ‘SuperReport Editable Forms’ radio button on the Forms Settings 2 page of Preferences. You can print using the standard Enterprise 6 forms if you accept the selection list while holding down the