<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/da/xch/daxch0131s000" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table Relations (Export) (daxch0131s000)</Title>
	</Header>
	<HelpTopic xml:lang="en"><AimSection><Paragraph class="Default">
                                 Use this session to create table relations between <Link href="/baanerp/da/glossary/glossary#000006" role="glossary" Update="No">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">Define in the <Link href="/baanerp/da/glossary/glossary#000032" role="glossary">table relation</Link> the ERP LN table that contains the data that must be transferred to the <Link href="/baanerp/da/glossary/glossary#000006" role="glossary">logical ASCII</Link> files, and assign a name to the <Link href="/baanerp/da/glossary/glossary#000011" role="glossary">physical ASCII file</Link>.</Paragraph>
			<ProcedureList><ListIntro>To create a table relation, do as follows:</ListIntro>
				<ListItem>Enter the sequence number, <Link href="/baanerp/da/glossary/glossary#000006" role="glossary">logical ASCII file</Link> code, ERP LN table, and the <Link href="/baanerp/da/glossary/glossary#000011" role="glossary">physical ASCII file</Link> name.</ListItem>
				<ListItem>Select the <GUIRef href="/baanerp/da/xch/daxch0131s000#daxch031.bdbp" role="manual">Use bdbpre</GUIRef> check box if you want to use the standard bdbpre program.</ListItem>
				<ListItem>Enter the number of the <Link href="/baanerp/da/glossary/glossary#000012" role="glossary">index</Link> you want to use to export data from the ERP LN table. The <Link href="/baanerp/da/glossary/glossary#000001" role="glossary">ASCII file</Link> field is based on <Link href="/baanerp/da/glossary/glossary#000013" role="glossary">increment</Link>.</ListItem>
				<ListItem>Select the <GUIRef href="/baanerp/da/xch/daxch0131s000#daxch031.ract" role="manual">Range Active</GUIRef> check box if the table relation should use the range for the ERP LN table, as specified in the <GUIRef href="/baanerp/da/xch/daxch0122s000" role="session">Field Relations (Import) (daxch0122s000)</GUIRef> session.</ListItem>
				<ListItem>If necessary, select the <GUIRef href="/baanerp/da/xch/daxch0131s000#daxch031.actv" role="manual">Active</GUIRef> check box to make the relation active and define an execute <Link href="/baanerp/da/glossary/glossary#000009" role="glossary">condition</Link>.</ListItem>
			</ProcedureList>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">The relations on field level are created in the <GUIRef href="/baanerp/da/xch/daxch0532m000" role="session">Field Relations (Export) (daxch0532m000)</GUIRef> session.</Paragraph>
			</Note>
		</GeneralSection>
		<RelatedTopics><SectionTitle>
                                 Related topics
                              </SectionTitle>
			<RelTopic><Link href="/baanerp/da/onlinemanual/000003" role="manual">Introduction to the import module</Link>
			</RelTopic>
			<RelTopic><Link href="/baanerp/da/onlinemanual/000009" role="manual">To use conditions in the exchange module</Link>
			</RelTopic>
			<RelTopic><Link href="/baanerp/da/onlinemanual/000012" role="manual">To use multilevel exchange schemes</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="daxch031.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>
			<SimpleSection><Paragraph class="Default">The exchange scheme is created in the <GUIRef href="/baanerp/da/xch/daxch0501m000" role="session">Exchange Schemes (daxch0501m000)</GUIRef> session.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="daxch031.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="daxch031.batl"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table Rel. (Exp.)</Title>
			</Header>
			<FuncDesc>The identification 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 number is increased automatically: when you define a new table relation, ERP LN enters a number of value ten greater than the table relation with the highest value.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="daxch031.ttbl"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table</Title>
			</Header>
			<FuncDesc>Enter the code of the table in ERP LN that contains the data that will be exported into an <Link href="/baanerp/da/glossary/glossary#000001" role="glossary">ASCII file</Link> during an <Link href="/baanerp/da/glossary/glossary#000016" role="glossary">export procedure</Link>.</FuncDesc>
			<SimpleSection><Paragraph class="Default">Use multiple table relations to write data from one ERP LN table to more than one <Link href="/baanerp/da/glossary/glossary#000011" role="glossary">physical ASCII file</Link>.</Paragraph>
				<Paragraph class="Default">The ERP LN table is defined by the package code, a module code and a table number. For example, tiitm001.</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="daxch031.casf"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">ASCII File</Title>
			</Header>
			<FuncDesc>Enter the code of the <Link href="/baanerp/da/glossary/glossary#000001" role="glossary">ASCII file</Link> that contains data from the ERP LN table during an <Link href="/baanerp/da/glossary/glossary#000016" role="glossary">export procedure</Link>.</FuncDesc>
			<SimpleSection><Paragraph class="Default">To copy fields of an ASCII file table automatically the code of the ASCII file must be 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 ASCII file.</Paragraph>
			</SimpleSection>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">The ASCII file code represents the <Link href="/baanerp/da/glossary/glossary#000006" role="glossary">logical ASCII file</Link> 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/000001" role="manual">Introduction to the Exchange module</Link>
				</RelTopic>
			</RelatedTopics>
		</FieldHelp>
		<FieldHelp ID="daxch031.nasf"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">ASCII File Name</Title>
			</Header>
			<FuncDesc>Enter the name of the <Link href="/baanerp/da/glossary/glossary#000011" role="glossary">physical ASCII file</Link>.</FuncDesc>
			<SimpleSection><Paragraph class="Default">The file name is an extension on the default <Link href="/baanerp/da/glossary/glossary#000018" role="glossary">relative path</Link>. 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="daxch031.actv"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Active</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, the <Link href="/baanerp/da/glossary/glossary#000032" role="glossary">table relation</Link> is active and it can be used for data processing in an export process.</FuncDesc>
			<SimpleSection><Paragraph class="Default">
                                    If this check box is cleared, the table relation are kept for reference purposes. They are not used during the export process.</Paragraph>
				<Paragraph class="Default">This check box can also be selected if you want to test the <Link href="/baanerp/da/glossary/glossary#000003" role="glossary">exchange scheme</Link>, a single table relation, or only a few table relations.</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="daxch031.bdbp"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Use bdbpre</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, the layout of the <Link href="/baanerp/da/glossary/glossary#000001" role="glossary">ASCII file</Link> is ignored and the ASCII file is created by the standard bdbpre program.</FuncDesc>
			<SimpleSection><Paragraph class="Default">The range, sort index and the ASCII file fields are not considered.</Paragraph>
				<Paragraph class="Default">
                                    If this check box is cleared, the sequential ASCII file is created using the ASCII file fields that are created in the <GUIRef href="/baanerp/da/xch/daxch0103s000" role="session">ASCII File Fields (daxch0103s000)</GUIRef> session.</Paragraph>
			</SimpleSection>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<List><ListItem>You have to generate the exchange program again if this field is changed.</ListItem>
					<ListItem>This option is not applicable for an exchange based on audit.</ListItem>
				</List>
			</Note>
			<RelatedTopics><SectionTitle>
                                    Related topics
                                 </SectionTitle>
				<RelTopic><Link href="/baanerp/da/onlinemanual/000010" role="manual">To use audits in the exchange module</Link>
				</RelTopic>
			</RelatedTopics>
		</FieldHelp>
		<FieldHelp ID="daxch031.ccon"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Condition</Title>
			</Header>
			<FuncDesc>Enter a <Link href="/baanerp/da/glossary/glossary#000009" role="glossary">condition</Link> code. The condition must be of the type <GUIRef href="/baanerp/da/domains/xch.type#bool" role="option">Boolean</GUIRef>.</FuncDesc>
			<SimpleSection><Paragraph class="Default">The export of data depends on the return value of this condition. If the return value of the condition is true, the data of the ERP LN table is written to the <Link href="/baanerp/da/glossary/glossary#000001" role="glossary">ASCII file</Link>.</Paragraph>
			</SimpleSection>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">Conditions are also used during an exchange based on audit.</Paragraph>
			</Note>
			<RelatedTopics><SectionTitle>
                                    Related topics
                                 </SectionTitle>
				<RelTopic><Link href="/baanerp/da/onlinemanual/000009" role="manual">To use conditions in the exchange module</Link>
				</RelTopic>
				<RelTopic><Link href="/baanerp/da/onlinemanual/000010" role="manual">To use audits in the exchange module</Link>
				</RelTopic>
			</RelatedTopics>
		</FieldHelp>
		<FieldHelp ID="daxch031.ract"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Range Active</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, the table relation is processed with the limitations that are defined in the <GUIRef href="/baanerp/da/xch/daxch0112m000" role="session">Ranges (daxch0112m000)</GUIRef> session. If this check box is cleared, the range specified for the ERP LN table is not used in this <Link href="/baanerp/da/glossary/glossary#000032" role="glossary">table relation</Link>.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">The range is not active if the export is part of an <Link href="/baanerp/da/glossary/glossary#000008" role="glossary">audit procedure</Link> or if the <GUIRef href="/baanerp/da/xch/daxch0131s000#daxch031.bdbp" role="manual">Use bdbpre</GUIRef> check box is selected.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="daxch031.indx"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Sort on Index</Title>
			</Header>
			<FuncDesc>Enter the <Link href="/baanerp/da/glossary/glossary#000012" role="glossary">index</Link> number of the <Link href="/baanerp/da/glossary/glossary#000001" role="glossary">ASCII file</Link> that will contain data from the ERP LN table.</FuncDesc>
			<SimpleSection><Paragraph class="Default">This index will be used if the table is read and the ASCII file is sorted according to this index.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="text.available"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table Relations Text</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, additional information is added to the table relation. The text is maintained in the text editor.</FuncDesc>
			<SimpleSection><Paragraph class="Default">Click Text to start the text editor.</Paragraph>
			</SimpleSection>
		</FieldHelp>
	</Fields>
</Session>
