General guidelines

For table sharing, some general guidelines apply. This section lists these guidelines in detail.

  • In a logistic company, no financial tables must be set up, and in a financial company, no logistic tables must be set up, so there is also no need to share logistic tables to a financial company and vice versa.
  • If table sharing is used to prevent (explosive) data growth, ensure that Dynamic Company Switch is enabled for all users.
  • Transactional data, such as sales and purchase orders, cannot be shared between two companies.
  • Tables that are not included in the maximum table sets cannot be shared.
  • If a table is shared, all referenced tables must be shared too, unless:
    • The reference mode is Mandatory Unless Empty or Non-Mandatory. In this case, you can leave the field empty, and you must leave this field empty if the referenced table is not shared. For example, Departments (tcmcs065) is an attribute of Employees (tccom001) and the reference mode is mandatory unless empty. Therefore, if the employees are shared and the departments are not shared, the department field on the employee must be left empty on all employees. This affects functionality: as a result, all functionality on employees that requires the department of the employee, for example back flushing, will not be supported.
    • The referenced table is kept synchronized in a way other than by means of replication or manual procedures.

In general, sharing implies that the data can be entered, maintained, and used in all companies that share this table. However, this situation is not always available:

  • In some cases, the use is restricted to a particular company. For example, sales orders for a particular sales office can only be created and maintained in the operational company of that sales office.
  • In other cases, the creation of data is restricted, for example to a financial company or a logistic company or depending on a parameter in a specific company. Tax codes of type investment charge in a particular country for example, can only be entered in a company of type Financial or Both if the corresponding parameter in the ACP parameters is switched on. This tax code can also only be used in Financials.