AX 2012: Virtual Company Account Technicalities

Purpose:

The purpose of this document is to describe how Dynamics AX technically stores the data of virtual company accounts in database tables. Specifically, what are the tables involved in storing the relationships between a virtual company account and its company accounts and table collections?

Assumptions:

Reader has the functional knowledge of how virtual company accounts work in Dynamics AX.

Description:

Virtual company accounts are maintained at System administration > Setup > Virtual company accounts.

Schema:

The following system tables are used to store the mappings of virtual company account, company accounts and its table collections. Note you can’t find them in the AOT. As they are system tables.

Where,

DataArea:
The DataArea table contains a list of companies that have been created in the database.

VirtualDataAreaList:
The VirtualDataAreaList table stores the mapping between real companies and virtual companies.

TableCollectionList:
The TableCollectionList table stores the mapping between table collections and virtual companies.

UtilElements:
The UtilElements table contains the application that is shown in the AOT.