<?xml version="1.0" encoding="utf-8"?>
<ManualTopic ID="/baanerp/tf/integrations/400024" xml:lang="en">
   <Header>
      <Title>Table sharing for financial integration mapping</Title>
      <Keyword type="header" order="d1e1916932">
         <Level1>Integration transactions</Level1>
         <Level2>table sharing</Level2>
      </Keyword>
   </Header>
   <GeneralSection ID="integration.user.group">
      <Paragraph>Specific rules apply to sharing of the mapping scheme and
		reconciliation tables in a multicompany structure.</Paragraph>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>General rules</SectionTitle>
      <Paragraph>In ERP Enterprise,
		the mapping scheme must always be centralized in such a way that all financial
		companies that share the Companies (tcemm170) table must share the mapping
		scheme.</Paragraph>
      <Paragraph>If a specific financial company needs to use a different mapping
		for specific transactions, to set up the mapping for that company, you must
		enter the financial company number in, for example, the <GUIRef href="/baanerp/tf/gld/tfgld4569m000" role="session">Ledger Mapping (tfgld4569m000)</GUIRef> session rather than leave the <GUIRef href="/baanerp/tf/acp/tfacp1120m000#tfgld102.tcom" role="manual">Financial Company</GUIRef> field blank.</Paragraph>
      <List>
         <ListIntro>In a multicompany structure, the financial companies must
		  share many of the financial tables while other tables must not be shared. The
		  following general rules apply:</ListIntro>
         <ListItemHead>Financial integration tables</ListItemHead>
         <ListItem>All the companies must share all the tables of the <GUIRef href="/baanerp/tc/fin" role="module">Finance/Logistics</GUIRef> module.</ListItem>
         <ListItemHead>Integration ledger accounts</ListItemHead>
         <ListItem>The companies of a multicompany structure must use the same
		  integration ledger accounts. To achieve this, you can share the Chart of
		  Accounts (tfgld008) table or define exactly the same integration ledger
		  accounts in the individual companies. In addition, the companies must either
		  share the Dimensions (tfgld010) table or define the same dimensions in every
		  company to use the same dimensions.</ListItem>
         <ListItemHead>Transaction types and series</ListItemHead>
         <ListItem>The companies of a multicompany structure must also use the
		  same transaction types and series. To achieve this, you can either define
		  exactly the same transaction types in every company or share the Transaction
		  Types (tfgld011) table. The Series (tfgld017) table must not be shared.
		  However, the series used in the Mapping Scheme (tfgld477) table must be defined
		  in each financial company.</ListItem>
         <ListItemHead>Exceptions</ListItemHead>
         <ListItem>Exceptions to these rules are permitted. In the financial
		  company in which a common integration account or a dimension does not exist,
		  you must map the elements to another ledger account or dimensions specifically
		  for that company, in the <GUIRef href="/baanerp/tf/gld/tfgld4569m000" role="session">Ledger Mapping (tfgld4569m000)</GUIRef> session or the <GUIRef href="/baanerp/tf/gld/tfgld4571m000" role="session">Dimension Mapping (tfgld4571m000)</GUIRef> session. If a common transaction type does not exist,
		  you must define a specific transaction type for the integration document types
		  for the financial company, on the <GUIRef href="" role="manual">Document Numbering and Compression</GUIRef> tab of the <GUIRef href="/baanerp/tf/gld/tfgld4573m000" role="session">Mapping Scheme (tfgld4573m000)</GUIRef> session.</ListItem>
         <ListItemHead>Transactions table</ListItemHead>
         <ListItem>Sharing the Integration Transaction (tfgld482) table and the
		  Reconciliation Transactions (tfgld495) table is not compulsory. Due to the
		  large amount of data that each company stores in the Reconciliation Data
		  (tfgld482) table, ERP Enterprise does not recommend that you share this table. However, the decision of whether
		  or not to share this table also depends on the specific system and database
		  features, as well as the reconciliation needs.</ListItem>
      </List>
   </GeneralSection>
   <GeneralSection>
      <SectionTitle>Table Sharing Modeler</SectionTitle>
      <Paragraph>You can use the Table Sharing Modeler to set up the required
		table sharing structure. All financial companies that share the Companies
		(tcemm170) table must share the tables of the Central Integration Mapping
		(R10100) table set.</Paragraph>
   </GeneralSection>
   <RelatedTopics>
      <SectionTitle>Related topics</SectionTitle>
      <RelTopic>
         <Link href="/baanerp/tf/integrations/400002" role="manual">To set up an integration mapping scheme</Link>
      </RelTopic>
   </RelatedTopics>
</ManualTopic>