Additional Systems

When you create companies using the Company Profiles command in the System Manager, you can assign a company code of 0-9 or A-Z, which provides up to 36 separate company databases. If you require more company databases than this, you can create separate systems of companies using the Additional Systems command. Each system is identified by its own number, along with a description.

The number of additional systems available will depend on the licence you have. The default system is known as the Main System, and is always available in all activations. Also, the number of users you can use across all systems depends on your Opera licence. If you have a 10-user licence, you can use up to 10 users across all systems.

When you create an additional system, you can choose certain items to copy from the main system.

Make sure you select the options you need because you cannot copy any more details from the main system after the new system has been created.

After the additional system has been created, the Opera Logon form includes a drop-down list box called System, from which you can select the system you want to use.

Technical Information

After an additional system has been created, its related files are saved in a new folder in the Opera Server Dynamic Data installation network share location. The new folder is called 'Systemx' where x is the number assigned to the additional system. For example, a system allocated the number 9 uses a folder called System9.

Important: After upgrading to a new version of Opera, the Update Data Structures command must be separately run for all companies in each additional system.

The new folder contains these files after the system is created (typically each file includes three separate files with .DBF, .CDX and .FPT file extensions):

Tables	Description
SEQCO	Retains details of the companies in the additional system, including the options and link settings for the company. For example, whether the Cashbook is used or whether the Nominal Ledger is linked to the Purchase Ledger.
SEQUSER	Retains details of the users in the additional system, including each user's security permissions.
SEQPEOPL	Retains details of the individuals who may be associated with records within the system, who may also be users of the system but could also be people who are involved in the business but do not use Opera.
SEQREPM	Retains details of the reports in the Reporter application in the additional system.
SEQEFLD	Retains details of the email profiles in the additional system. These are default messages for documents sent by e-mail to customers in the Sales Ledger and Sales Order Processing applications, or remittance advices and purchase orders sent by email to suppliers.
BACSBANK BACSFORMAT BACSSTYLE	Retain different bank's payment file formats for BACS payments.
SEARCH	Retains the fields that are used for searching in each application. For example, the default search fields for the SNAME (customer) table, includes the customer's name, account number and the first two lines of the address.
SEQFAV	Retains each user's favourite shortcuts to different commands.
NEXTID	This table retains the next unique identifier for records that are added to system tables.

1. Whenever a user is added to Opera, a new file is also created in the SystemX folder. The name of the file is the same as the user's login code. For example, a file called FRED.DBF will be created for a new user of that name.

2. Files that are prefixed with 'ADD', which are used to append new records to the system files, are not created or copied in the SystemX folder. These files are only in the main System folder.