<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/archiving/tt/Attaad4120m000" xml:lang="en">
   <Header>
      <Title>Share tables between operational and archive companies
		(ttaad4120m000)</Title>
   </Header>
   <GeneralSection>
      <Paragraph>You need to share tccom000, tttxt004, and tttxt005 tables
		between your operational companies and archive companies.</Paragraph>
      <Paragraph>
         <GUIRef href="" role="manual">Path: // Tools / Database Management / Database Definitions and Directories</GUIRef>
      </Paragraph>
      <GeneralSection>
         <SectionTitle>Instruction (in operational or 000 company)</SectionTitle>
         <ProcedureList>
            <ListItem>To share the (tccom000) table between the operational company
			 and archive company, use the <GUIRef href="/baanerp/tt/aad/ttaad4120m000" role="session">Logical Tables (ttaad4120m000)</GUIRef> session. In this session, the operational company is
			 the physical company and the archive company is the logical company.</ListItem>
            <ListItem>Share the Text Windows tttxt004 and Text Groups tttxt005
			 tables in the same way.</ListItem>
         </ProcedureList>
         <Note>
            <SectionTitle>Note</SectionTitle>
            <List>
               <ListItem>The changes will only take effect after you convert to
				runtime and restart the LN application (the bshell).</ListItem>
               <ListItem>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: <List>
                     <ListItem>tccom.dll0026.archive.table</ListItem>
                     <ListItem>tccom.dll0025.archive.table</ListItem>
                  </List>
               </ListItem>
               <ListItem>The function tccom.dll0026.archive.table also calls a
				function empty.ref.fields, which clears one or more reference fields for the
				specified table.</ListItem>
            </List>
         </Note>
         <Paragraph>As mentioned previously, tables tccom000, tttxt004, and
		  tttxt005 must always be linked, as shown in the following figure.</Paragraph>
         <Paragraph>For all related multisite companies and archive companies,
		  table tccom000, tttxt004, and tttxt005 must be linked to the same operational
		  company:</Paragraph>
      </GeneralSection>
   </GeneralSection>
</ManualTopic>