Creating additional companies

To create additional companies and their corresponding database tables:

1. Create the remaining companies of the multicompany structure in the Companies (ttaad1100m000) session. For each company, you must define:

   • The company number: This number must contain four digits. The company number uniquely identifies the company and all company data stored in the database. You can choose the company numbers.
   • The first day of the week used by the company: All companies of a multicompany structure must use the same day as the first weekday, for example, Sunday or Monday.
   • The new company's default currency: You can choose from the currencies in the Generic Units (ttaad1106m000) session. If the required currency is not yet defined, you can define the currency.
   • The company's package combination: Specify the package VRC that you have installed. For more information, refer to the "Version and Release Management" chapter in the Infor Enterprise Server Administrator`s Guide (U8854 US).

   From the appropriate menu, select Convert to Runtime to store the data in the runtime data dictionary before you close the session.

2. If you set up a system with multiple database servers, you must use these sessions:

   • Database Definitions (ttaad4510m000) session: Use this session to define the databases for all locations that contain data. For more information about multidatabase server systems, refer to the "Server configurations" section in the "Multicompany Technical Issues" chapter of the User’s Guide for Multicompany Structures (U9504 US).
   • Tables by Database (ttaad4111m000): Use this session to determine which mandatory tables are stored in which databases. In this session, you can also define for which mandatory tables you want to activate LN's audit tool. The audit tool logs all parameter changes in the mandatory tables.

   You can run these sessions for:

   • Each company
   • Each database type for all companies that use the same database type

   If you set up companies with various package combinations, you must run the sessions for each package combination/company/database type.

   In both sessions, from the appropriate menu, select Convert to Runtime to store the data in the runtime data dictionary before you close the session.

3. Specify logical tables in the Logical Tables (ttaad4120m000) session. The companies of a multicompany structure must share some tables while the companies can optionally share other tables. You can use this session to share tables between the companies by mapping the tables of one company onto the physical tables of another company. For details, refer to User's Guide for Multicompany Table Sharing (U9505 US).

   • From the appropriate menu, select Convert to Runtime to store the data in the run-time data dictionary before you close the session.
4. Log off from LN and then log on again as user bsp. In this way, the virtual machine (the Bshell) reads the new information from the run-time data dictionary. This information includes the information about which tables are logically linked.

5. Create each company's database tables in the Create Tables (ttaad4230m000) session. You must create tables for all LN packages that the company uses. LN does not create the tables that you have logically linked to the tables of another company in the previous step.

   • If you click Create, the Select Device (ttstpsplopen) session starts. Select a device for the report that LN generates during table creation. If you do not want a printed report, enter D to display the report on your screen.
   • Click Continue in the Select Device (ttstpsplopen) session to start to create the tables.
   Note: LN creates more than 2000 tables. This process can take some time. After LN finishes creating the tables, a message is displayed.
6. For each additional company, run the Initialize Parameters (tcmcs0295m000) session to set the initial default values of the parameters for all packages.