|
Table collections
Standard table collections
Two table collections have been created in the standard application, which must be updated by any solution changing or adding new tables to the application.
Using these two collections, the most common shared data/virtual company situations can be set up at the installation.
Global
Add tables to the Global collection, that have a global nature; any company can and may use data in these tables, this data is not company specific.
Examples are (see the implemented standard collection)
Country,
State,
Unit.
Shared Company
Add tables to the SharedCompany collection, that can be shared between companies, that don't mind - and can - share data.
Examples are (see the implemented standard collection)
CustTable,
LedgerTable,
EmplTable.
No references allowed from virtual to non-virtual companies
There must not be a foreign key in a table in a virtual company, where the key is in the (non-virtual) company.
Note!
This is checked by the automated Best Practices Checks
Adjust the data model to adapt to the standard table collections
To gain most use of the standard table collections, it can be necessary to adjust the data model, for example to split tables that would be one table, if all data was stored under one company.
|