| # Share tables between operational and archive companies (ttaad4120m000) You need to share tccom000, tttxt004, and tttxt005 tables between your operational companies and archive companies. Path: // Tools / Database Management / Database Definitions and Directories Instruction (in operational or 000 company) To share the (tccom000) table between the operational company and archive company, use the Logical Tables (ttaad4120m000) session. In this session, the operational company is the physical company and the archive company is the logical company. Share the Text Windows tttxt004 and Text Groups tttxt005 tables in the same way. Note The changes will only take effect after you convert to runtime and restart the ERP LN application (the bshell). If there are additional tables to be linked, one or more reference fields in the operational and archive companies are cleared. Typically, when you start an archiving session, one of the initial steps is to copy the general data. In some archiving sessions, this step is optional, however, in several other archiving sessions, this step is mandatory. During this copying process, some of these general data tables are copied twice from the operational company to the archive company. In the first copy process, specific reference fields in the archive company are cleared. When you copy the table the second time, all data is copied from the operational company to the archive company. This special copying process is required to prevent reference errors during the copying process. This process can technically be read in the script tcmcsdll0008 where, for some tables, the following two functions are listed to perform the copy process: tccom.dll0026.archive.table tccom.dll0025.archive.table The function tccom.dll0026.archive.table also calls a function empty.ref.fields, which clears one or more reference fields for the specified table. As mentioned previously, tables tccom000, tttxt004, and tttxt005 must always be linked, as shown in the following figure. For all related multisite companies and archive companies, table tccom000, tttxt004, and tttxt005 must be linked to the same operational company: |