Virtual company setup

Here is the concept of virtual company in AX

 

A AX database can contain information for one or more companies. Multiple companies can share the database while using the same application logic. Each company has a set of data that is only for that company and cannont be accessed by another company. Conversely, some tables might contain data that can be shared by multiple companies.

The company desing in AX includes

–          Companies – based on one or more virtual companies. When adding data to a table that is not in a virtual compay, the data is stored directly in the company.

–          Virtual Companies – Contains data from multiple companies that is shared by all the companies. The virtual company uses a list of one or more table colections to define which tables it contains. The end user can’t access tables directly through a virtual company. They can only access the tables through a company. The virtual company is transparent to end users.

–          Table collections – Specifies a list of table names. Table collections define a set of tables that have no foreign key relationships with tables outside the table colloection. Each table in the system occurs only once in any one table collection, but tables can be added to more than one table collection. There is no table data stored in a table collection – only companies and virtual companies store data

 

In SANDBOX instance, you will see “PURC” virtual company which contains “CHL” and “FTS” as its company accounts and only “VENDOR TABLES” table collection has selected.

This means Vendor and Vendor group tables that belong to “vendor tables” table collection are shared  among “CHL” and “FTS”

 

You can use DataArea for list of companies and  VirtualDataAreaList for company-virtual company mapping information.

 

Figure 1) virtual company setup

    <photo1> <photo2> <photo3>

 

Figure 2) Table collection.  AOT > Data Dictionary > Table Collections

    <photo4>