Table sharingIn an LN installation with multiple companies, you can require two or more companies to share tables to meet a particular business requirement. For example, if several of your companies purchase items from the same suppliers, these companies can share the business-partner table. Purpose Table sharing has the following advantages:
Table sharing can have the following disadvantages:
Methods You can apply one of the following two methods of table sharing:
Two types of data replication exist.
You can also organize your work process to copy the data modifications in one company manually to the other companies. That is suitable for slowly-changing, static data, such as language codes and country codes. Table references The table-sharing configuration must take the table references into account. Otherwise, the referential integrity can be damaged. The consequences of a table reference depend on the table reference's Reference Mode.
Beispiel The Items - General table has a Country of Origin field, that has a reference to the Countries table with the Reference Mode set to Mandatory unless empty. Suppose the Items - General table is shared between company 100 and 200, and the Countries table is not shared. If you insert a new country code in company 100, and you insert that country code in the Country of Origin field for an item, you will get a reference error if you look at the same item in company 200. If you view the item in company 200, the item's country of origin displays as "*****". If you use the item, a fatal error occurs. To prevent this, the Countries table must also be shared or the Country of Origin field must always be kept empty.
| |||