<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/da/xch/daxch0522m000" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Field Relations (Import) (daxch0522m000)</Title>
	</Header>
	<HelpTopic xml:lang="en"><AimSection><Paragraph class="Default">
                                 Use this session to list the available relations between <Link href="/baanerp/da/glossary/glossary#000006" role="glossary">logical ASCII file</Link> fields and ERP LN table fields 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">Create the table field relations in the details session.</Paragraph>
			<Paragraph class="Default">Use the <GUIRef href="/baanerp/da/xch/daxch0522m000#exec.user.0" role="command">Create Default Import Field Relations</GUIRef> command on the application menu to create the field relations automatically. Use this option if the <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> is not available.</Paragraph>
			<GeneralSection><SectionTitle>Tip</SectionTitle>
				<Paragraph class="Default">If you want to create the field relations automatically, make sure that the code of the <Link href="/baanerp/da/glossary/glossary#000001" role="glossary">ASCII file</Link> is identical to the ERP LN table code.</Paragraph>
			</GeneralSection>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">The relation on table level is created in the <GUIRef href="/baanerp/da/xch/daxch0521m000" role="session">Table Relations (Import) (daxch0521m000)</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/000013" role="manual">Relation between logical ASCII files and physical ASCII files</Link>
			</RelTopic>
			<RelTopic><Link href="/baanerp/da/onlinemanual/000009" role="manual">To use conditions in the exchange module</Link>
			</RelTopic>
		</RelatedTopics>
	</HelpTopic>
	<Fields><FieldHelp ID="daxch022.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="daxch022.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="daxch022.batl"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table Relation (Import)</Title>
			</Header>
			<FuncDesc>A sequential number that identifies the table relation. It makes the table relation unique in the <Link href="/baanerp/da/glossary/glossary#000002" role="glossary">batch</Link>.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="daxch021.ttbl"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table</Title>
			</Header>
			<FuncDesc>The code of the ERP LN table that contains data from the <Link href="/baanerp/da/glossary/glossary#000001" role="glossary">ASCII file</Link> during an import.</FuncDesc>
		</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 import.</FuncDesc>
			<SimpleSection><Paragraph class="Default">To generate the field relations automatically, it is necessary that the code of the ASCII file 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 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="daxch022.srno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Ser. No.</Title>
			</Header>
			<FuncDesc>The serial number that makes the field relation unique in the table relation. The serial number is only used as an identifier and does not have to be sequential.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">Use an interval so that table fields can be added later.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="daxch022.tfld"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table Field</Title>
			</Header>
			<FuncDesc>The code of the field in the ERP LN table, that is filled with data from a field in 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>
		</FieldHelp>
		<FieldHelp ID="daxch022.elmt"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Arr. Ele.</Title>
			</Header>
			<FuncDesc>The element number of an <Link href="/baanerp/da/glossary/glossary#000014" role="glossary">array</Link> field. This field is only applicable if the ERP LN field is defined as an <Link href="/baanerp/da/glossary/glossary#000014" role="glossary">array</Link> field in the data dictionary.</FuncDesc>
			<SimpleSection><Paragraph class="Default">The elements in an <Link href="/baanerp/da/glossary/glossary#000014" role="glossary">array</Link> can be filled individually.</Paragraph>
			</SimpleSection>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">The element number cannot exceed the <Link href="/baanerp/da/glossary/glossary#000014" role="glossary">array</Link> depth.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="based.on"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Based on</Title>
			</Header>
			<FuncDesc>This field indicates how the data is transferred from <Link href="/baanerp/da/glossary/glossary#000001" role="glossary">ASCII file</Link> fields to ERP LN fields. Use the <GUIRef href="" role="manual">Based on</GUIRef> groupbox on the <GUIRef href="" role="manual">General</GUIRef> tab in the details session to define the method of the data transfer.</FuncDesc>
			<SimpleSection><ProcedureList><ListIntro>
                                       ERP LN fields can be filled based on:</ListIntro>
					<ListItem>Field value</ListItem>
					<ListItem>Condition</ListItem>
					<ListItem>Constant</ListItem>
					<ListItem>Increment</ListItem>
					<ListItem>Default</ListItem>
				</ProcedureList>
			</SimpleSection>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">For more information, refer to the field help in the details session.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="daxch022.fdnm"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">ASCII Field</Title>
			</Header>
			<FuncDesc>The code of the <Link href="/baanerp/da/glossary/glossary#000001" role="glossary">ASCII file</Link> field that contains data that is written to a field in the ERP LN table during an <Link href="/baanerp/da/glossary/glossary#000015" role="glossary">import procedure</Link>.</FuncDesc>
			<SimpleSection><Paragraph class="Default">If the import is done based on <Link href="/baanerp/da/glossary/glossary#000013" role="glossary">increment</Link>, and if the field is part of an index.</Paragraph>
			</SimpleSection>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<List><ListItem>The ASCII file code represents the <Link href="/baanerp/da/glossary/glossary#000006" role="glossary">logical ASCII file</Link>. It is created in the <GUIRef href="/baanerp/da/xch/daxch0102m000" role="session">ASCII Files (daxch0102m000)</GUIRef> session.</ListItem>
					<ListItem>The index is specified in the sort on index field in the <GUIRef href="/baanerp/da/xch/daxch0121s000" role="session">Table Relations (Import) (daxch0121s000)</GUIRef> session.</ListItem>
					<ListItem>The import is based on increment if the <GUIRef href="/baanerp/da/xch/daxch0122s000#s.increment" role="manual">Increment</GUIRef> check box in the <GUIRef href="/baanerp/da/xch/daxch0122s000" role="session">Field Relations (Import) (daxch0122s000)</GUIRef> session is selected.</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="daxch022.ccon"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Cond.</Title>
			</Header>
			<FuncDesc>The condition that is used in the transfer of data from the <Link href="/baanerp/da/glossary/glossary#000001" role="glossary">ASCII file</Link> field to the ERP LN table field.</FuncDesc>
			<SimpleSection><Paragraph class="Default">Use this field only if the data transfer to the ERP LN table field is based on conditions.</Paragraph>
			</SimpleSection>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">Conditions are defined in the <GUIRef href="/baanerp/da/xch/daxch0114m000" role="session">Conditions (daxch0114m000)</GUIRef> session.</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>
			</RelatedTopics>
		</FieldHelp>
		<FieldHelp ID="daxch022.stvl"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Start Value</Title>
			</Header>
			<FuncDesc>This field defines the initial serial value of the table field relation. The start value is filled by <GUIRef href="/baanerp/da/xch" role="module">Exchange</GUIRef> if one of the higher-level fields in the <Link href="/baanerp/da/glossary/glossary#000012" role="glossary">index</Link> changes.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">This field is only filled if the field relation is based on increment.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="fixed.value"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Constant</Title>
			</Header>
			<FuncDesc>You can specify a fixed value in this field if the <GUIRef href="/baanerp/da/xch/daxch0522m000#based.on" role="manual">Based on</GUIRef> field has one of the values <GUIRef href="/baanerp/da/domains/xch.base#constant" role="option">Fixed value</GUIRef>, <GUIRef href="/baanerp/da/domains/xch.base#increment" role="option">Increment</GUIRef>, or <GUIRef href="/baanerp/da/domains/xch.base#rel.code" role="option">Conv. table</GUIRef>.</FuncDesc>
			<SimpleSection><Paragraph class="Default">You can specify a fixed value in this field .</Paragraph>
				<Paragraph class="Default">You can use the character # to represent the current date if the ERP LN table field is of type date.</Paragraph>
			</SimpleSection>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">You cannot use this field if a field condition is used or if the field <GUIRef href="/baanerp/da/xch/daxch0522m000#based.on" role="manual">Based on</GUIRef> is filled with Rel.table and the field name is filled.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="daxch022.crel"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Conversion</Title>
			</Header>
			<FuncDesc>The conversion code to modify data before it is transferred to the ERP LN table field.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">Conversions are defined in the <GUIRef href="/baanerp/da/xch/daxch0105m000" role="session">Conversion Tables (daxch0105m000)</GUIRef> session.</Paragraph>
			</Note>
		</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 field relation. The text is maintained in the text editor.</FuncDesc>
		</FieldHelp>
	</Fields>
</Session>
