<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/da/xch/daxch0521m000" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table Relations (Import) (daxch0521m000)</Title>
	</Header>
	<HelpTopic xml:lang="en"><AimSection><Paragraph class="Default">
                                 Use this session to list the available table relations between <Link href="/baanerp/da/glossary/glossary#000006" role="glossary">logical ASCII files</Link> and ERP LN tables per <Link href="/baanerp/da/glossary/glossary#000002" role="glossary">batch</Link> in an <Link href="/baanerp/da/glossary/glossary#000003" role="glossary">exchange scheme</Link>.</Paragraph>
		</AimSection>
		<GeneralSection><Paragraph class="Default">Each table relation is identified by a sequential number.</Paragraph>
			<Tip><SectionTitle>
                                    Tip
                                 </SectionTitle>
				<Paragraph class="Default">Use multiple table relations to link one ASCII file to more than one ERP LN table or to link one ERP LN table to more than one ASCII file.</Paragraph>
			</Tip>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">If you have started this session by zooming, you can only find and select a record. The relation on field level is created in the <GUIRef href="/baanerp/da/xch/daxch0522m000" role="session">Field Relations (Import) (daxch0522m000)</GUIRef> session.</Paragraph>
			</Note>
		</GeneralSection>
		<RelatedTopics><SectionTitle>
                                 Related topics
                              </SectionTitle>
			<RelTopic><Link href="/baanerp/basictasks/000001" role="manual">To use an overview session</Link>
			</RelTopic>
			<RelTopic><Link href="/baanerp/basictasks/000036" role="manual">To maintain records in an overview/maintain session</Link>
			</RelTopic>
			<RelTopic><Link href="/baanerp/da/onlinemanual/000001" role="manual">Introduction to the Exchange module</Link>
			</RelTopic>
			<RelTopic><Link href="/baanerp/da/onlinemanual/000002" role="manual">Introduction to the master data business object</Link>
			</RelTopic>
			<RelTopic><Link href="/baanerp/da/onlinemanual/000003" role="manual">Introduction to the import module</Link>
			</RelTopic>
			<RelTopic><Link href="/baanerp/da/onlinemanual/000013" role="manual">Relation between logical ASCII files and physical ASCII files</Link>
			</RelTopic>
		</RelatedTopics>
	</HelpTopic>
	<Fields><FieldHelp ID="daxch021.cxch"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Exchange Scheme</Title>
			</Header>
			<FuncDesc>The <Link href="/baanerp/da/glossary/glossary#000003" role="glossary">exchange-scheme</Link> code.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">The <Link href="/baanerp/da/glossary/glossary#000003" role="glossary">exchange scheme</Link> is created in the <GUIRef href="/baanerp/da/xch/daxch0501m000" role="session">Exchange Schemes (daxch0501m000)</GUIRef> session.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="daxch021.cbat"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Batch</Title>
			</Header>
			<FuncDesc>The <Link href="/baanerp/da/glossary/glossary#000002" role="glossary">batch</Link> code in an <Link href="/baanerp/da/glossary/glossary#000003" role="glossary">exchange scheme</Link>.</FuncDesc>
			<SimpleSection><Paragraph class="Default">A batch is created in the <GUIRef href="/baanerp/da/xch/daxch0104m000" role="session">Batches (daxch0104m000)</GUIRef> session.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="daxch021.batl"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table Rel.</Title>
			</Header>
			<FuncDesc>A sequential number that identifies the <Link href="/baanerp/da/glossary/glossary#000032" role="glossary">table relation</Link>. It makes the <Link href="/baanerp/da/glossary/glossary#000032" role="glossary">table relation</Link> unique in the <Link href="/baanerp/da/glossary/glossary#000002" role="glossary">batch</Link>.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="daxch021.seqn"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Seq. No.</Title>
			</Header>
			<FuncDesc>The sequence number of the <Link href="/baanerp/da/glossary/glossary#000032" role="glossary">table relation</Link> in the <Link href="/baanerp/da/glossary/glossary#000002" role="glossary">batch</Link> during an exchange process.</FuncDesc>
			<SimpleSection><Paragraph class="Default">The sequence number of the <Link href="/baanerp/da/glossary/glossary#000032" role="glossary">table relation</Link> does not have to be unique. If two relations have the same sequence number, the relation with the lowest <Link href="/baanerp/da/glossary/glossary#000032" role="glossary">table relation</Link> number is processed first.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="daxch021.ttbl"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table</Title>
			</Header>
			<FuncDesc>The code of the table in ERP LN that is filled with data from an <Link href="/baanerp/da/glossary/glossary#000001" role="glossary">ASCII file</Link> during an <Link href="/baanerp/da/glossary/glossary#000015" role="glossary">import procedure</Link>.</FuncDesc>
			<SimpleSection><Paragraph class="Default">Use multiple table relations to write data from more than one <Link href="/baanerp/da/glossary/glossary#000011" role="glossary">physical ASCII file</Link> to one ERP LN table.</Paragraph>
				<Paragraph class="Default">The ERP LN table name is defined by the package code, a module code and a table number. For example, tcibd001.</Paragraph>
			</SimpleSection>
			<RelatedTopics><SectionTitle>
                                    Related topics
                                 </SectionTitle>
				<RelTopic><Link href="/baanerp/da/onlinemanual/000013" role="manual">Relation between logical ASCII files and physical ASCII files</Link>
				</RelTopic>
			</RelatedTopics>
		</FieldHelp>
		<FieldHelp ID="daxch021.casf"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">ASCII File</Title>
			</Header>
			<FuncDesc>The code of the <Link href="/baanerp/da/glossary/glossary#000001" role="glossary">ASCII file</Link> that contains data that is transferred to a ERP LN table in an <Link href="/baanerp/da/glossary/glossary#000015" role="glossary">import procedure</Link>.</FuncDesc>
			<SimpleSection><Paragraph class="Default">To copy fields of an <Link href="/baanerp/da/glossary/glossary#000001" role="glossary">ASCII file</Link> table automatically it is necessary that the code of the <Link href="/baanerp/da/glossary/glossary#000001" role="glossary">ASCII file</Link> is the same as the code of the ERP LN table. This is an option if you do not have a data <Link href="/baanerp/da/glossary/glossary#000007" role="glossary">definition file</Link> of the <Link href="/baanerp/da/glossary/glossary#000001" role="glossary">ASCII file</Link>.</Paragraph>
			</SimpleSection>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">The <Link href="/baanerp/da/glossary/glossary#000001" role="glossary">ASCII file</Link> code represents the <Link href="/baanerp/da/glossary/glossary#000006" role="glossary">logical ASCII</Link> file and it is created in the <GUIRef href="/baanerp/da/xch/daxch0102m000" role="session">ASCII Files (daxch0102m000)</GUIRef> session.</Paragraph>
			</Note>
			<RelatedTopics><SectionTitle>
                                    Related topics
                                 </SectionTitle>
				<RelTopic><Link href="/baanerp/da/onlinemanual/000013" role="manual">Relation between logical ASCII files and physical ASCII files</Link>
				</RelTopic>
			</RelatedTopics>
		</FieldHelp>
		<FieldHelp ID="daxch021.nasf"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">ASCII File Name</Title>
			</Header>
			<FuncDesc>The name of the <Link href="/baanerp/da/glossary/glossary#000011" role="glossary">physical ASCII file</Link>.</FuncDesc>
			<SimpleSection><Paragraph class="Default">The entered file name is an extension on the default <Link href="/baanerp/da/glossary/glossary#000018" role="glossary">relative</Link> path. The default <Link href="/baanerp/da/glossary/glossary#000018" role="glossary">relative path</Link> is defined in the <GUIRef href="/baanerp/da/xch/daxch0101s000#daxch001.spth" role="manual">ASCII Files</GUIRef> field under Paths on the <GUIRef href="" role="manual">General</GUIRef> tab in the <GUIRef href="/baanerp/da/xch/daxch0101s000" role="session">Exchange Schemes (daxch0101s000)</GUIRef> session.</Paragraph>
			</SimpleSection>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<List><ListItem>This path can also be an <Link href="/baanerp/da/glossary/glossary#000017" role="glossary">absolute path</Link>.</ListItem>
					<ListItem>The maximum length of the file name is 11 characters.</ListItem>
					<ListItem>You do not have to generate the exchange program again if this field is changed.</ListItem>
				</List>
			</Note>
			<RelatedTopics><SectionTitle>
                                    Related topics
                                 </SectionTitle>
				<RelTopic><Link href="/baanerp/da/onlinemanual/000013" role="manual">Relation between logical ASCII files and physical ASCII files</Link>
				</RelTopic>
			</RelatedTopics>
		</FieldHelp>
		<FieldHelp ID="daxch021.actv"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Active</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, the table relation is active and it can be used for data processing in a regular exchange process.</FuncDesc>
			<SimpleSection><Paragraph class="Default">
                                    If this check box is cleared, the table relations are kept for reference purposes but they are not used during a regular exchange process.</Paragraph>
				<Paragraph class="Default">This check box does not have to be selected for all table relations in a test run of the exchange process. One table relation is enough.</Paragraph>
			</SimpleSection>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">You do not have to generate the exchange program again if this field is changed.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="daxch021.dalu"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Use DAL</Title>
			</Header>
			<FuncDesc>This check box indicates whether the Data Access Layer (DAL) is used for the current table. By using the DAL, an import carries out all the constraint checks, integrity checks and side effects, such as updates on other tables, that are programmed into the DAL. This guarantees database integrity, saves programming time, and avoids the errors that can occur in condition scripts.</FuncDesc>
			<SimpleSection><Paragraph class="Default">Refer to <Link href="/baanerp/da/onlinemanual/000150" role="manual">Import using the Data Access Layer (DAL)</Link> for details.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="text.available"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Text</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, additional information is added to the table relation. The text is generated in the text editor.</FuncDesc>
		</FieldHelp>
	</Fields>
	<FormCommands><CommandHelp ID="exec.user.0"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Field Relations (Import)</Title>
			</Header>
			<FuncDesc>Creates or changes table field relations for an import.</FuncDesc>
		</CommandHelp>
		<CommandHelp ID="exec.user.1"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">(De)activate Table Relations</Title>
			</Header>
			<FuncDesc>Activates or deactivates a range of import table relations per batch.</FuncDesc>
		</CommandHelp>
	</FormCommands>
</Session>
