<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/da/xch/daxch0509m000" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Log Table (Batch Line Level) (daxch0509m000)</Title>
	</Header>
	<HelpTopic xml:lang="en"><AimSection><Paragraph class="Default">
                                 Use this session to view the log table that contains the results of the exchange process on table relation level.</Paragraph>
		</AimSection>
		<GeneralSection></GeneralSection>
		<RelatedTopics><SectionTitle>
                                 Related topics
                              </SectionTitle>
			<RelTopic><Link href="/baanerp/da/onlinemanual/000007" role="manual">Introduction to the miscellaneous business object</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/000014" role="manual">To store exchange programs and files in BAAN</Link>
			</RelTopic>
		</RelatedTopics>
	</HelpTopic>
	<Fields><FieldHelp ID="daxch009.txch"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Type of Exchange</Title>
			</Header>
			<FuncDesc>The type of <Link href="/baanerp/da/glossary/glossary#000003" role="glossary">exchange scheme</Link>.</FuncDesc>
			<AllowedValues><SectionTitle>
                                    Allowed values
                                 </SectionTitle>
				<Paragraph class="Default">See <Link href="/baanerp/da/domains/xch.txch" role="domain">Possible values</Link>
				</Paragraph>
			</AllowedValues>
		</FieldHelp>
		<FieldHelp ID="daxch009.cxch"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Exchange Scheme</Title>
			</Header>
			<FuncDesc>The code of the <Link href="/baanerp/da/glossary/glossary#000003" role="glossary">exchange scheme</Link>.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="daxch009.runn"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Run Number</Title>
			</Header>
			<FuncDesc>A consecutive number linked to an export or import run. The run number is unique for each combination of an exchange batch and an exchange type. Each exchange run is written to the log table by using the run number. The log table is then used to determine the run number of the next export or import run.</FuncDesc>
			<SimpleSection><Paragraph class="Default">In regular export or import, the run number is used to avoid importing the same ASCII file twice or overwriting existing ASCII files.</Paragraph>
				<Paragraph class="Default">In multisite control, the run number is also used to ensure that data is replicated in the correct sequence.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="daxch009.tryn"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Try Number</Title>
			</Header>
			<FuncDesc>A consecutive number that is unique within an exchange run. Each run starts with try number 1. When the same run is continued, reprocessed or restarted, the run number remains the same and the try number is incremented by 1.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="daxch009.cbat"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Batch</Title>
			</Header>
			<FuncDesc>The code of the <Link href="/baanerp/da/glossary/glossary#000002" role="glossary">batch</Link>.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="daxch008.sdat"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Batch Start Date</Title>
			</Header>
			<FuncDesc>The date the <Link href="/baanerp/da/glossary/glossary#000002" role="glossary">batch</Link> of an exchange process is started.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="daxch009.batl"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table Rel.</Title>
			</Header>
			<FuncDesc>A sequential number that identifies the table relation and its processing order. It makes the table relation unique in the <Link href="/baanerp/da/glossary/glossary#000002" role="glossary">batch</Link>.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="daxch009.seqn"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Seq. No.</Title>
			</Header>
			<FuncDesc>The sequence number of the table relation in the <Link href="/baanerp/da/glossary/glossary#000002" role="glossary">batch</Link> during an import process.</FuncDesc>
			<SimpleSection><Paragraph class="Default">The sequence number of the table relation does not have to be unique. If two relations have the same sequence number, the relation with the lowest sequence number is processed first.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttbl"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table</Title>
			</Header>
			<FuncDesc>The code of the ERP LN table from which data was exported, or in which the data is imported. The ERP LN table is defined by the package code, a module code and a table number. For example, tiitm001.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="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#000006" role="glossary">logical ASCII file</Link> from which data was read during an import, or to which data was written during an export.</FuncDesc>
			<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="daxch009.read"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Records Read</Title>
			</Header>
			<FuncDesc>The number of records read from the <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> or from the ERP LN table during an <Link href="/baanerp/da/glossary/glossary#000016" role="glossary">export procedure</Link>.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">The number of records read is the same as the number of processed records, plus the number of error rejected messages, plus the number of condition rejected records, plus the number of skipped records.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="daxch009.prcd"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Records Proc.</Title>
			</Header>
			<FuncDesc>The number of records processed successfully to the ERP LN table during an <Link href="/baanerp/da/glossary/glossary#000015" role="glossary">import procedure</Link> or to the <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>
		</FieldHelp>
		<FieldHelp ID="daxch009.nerr"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Error Rej.</Title>
			</Header>
			<FuncDesc>The number of rejected records due to errors. These records are written to the log file.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="daxch009.ncnd"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Cond. Rej.</Title>
			</Header>
			<FuncDesc>The number of records rejected due to an add, update, overwrite, or delete <Link href="/baanerp/da/glossary/glossary#000009" role="glossary">condition</Link> with the return value, false.</FuncDesc>
			<SimpleSection><Paragraph class="Default">These records are written to the log file.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="daxch009.skip"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Records Skipped</Title>
			</Header>
			<FuncDesc>The number of skipped records.</FuncDesc>
			<SimpleSection><ProcedureList><ListIntro>A record can be skipped during an import for the following reasons:</ListIntro>
					<ListItem>The <Link href="/baanerp/da/glossary/glossary#000032" role="glossary">table relation</Link> is not active.</ListItem>
					<ListItem>The record was already imported during a previous try.</ListItem>
					<ListItem>The options add, overwrite, update, or delete were not selected in the <GUIRef href="/baanerp/da/xch/daxch0121s000" role="session">Table Relations (Import) (daxch0121s000)</GUIRef> session.</ListItem>
				</ProcedureList>
				<Paragraph class="Default">A record can be skipped during an export if the function "do.not.export.record()" is used in a <Link href="/baanerp/da/glossary/glossary#000009" role="glossary">condition</Link>.</Paragraph>
			</SimpleSection>
			<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="daxch009.edat"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Batch Line End Date and Time</Title>
			</Header>
			<FuncDesc>The date and time, according to Coordinated Universal Time, that the table relation in a <Link href="/baanerp/da/glossary/glossary#000002" role="glossary">batch</Link> of an exchange process was ended.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="daxch009.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) was used for the current batch line. 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="daxch009.dalc"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">DAL Checks</Title>
			</Header>
			<FuncDesc>This check box indicates whether the Data Access Layer (DAL) property checks were used for the current batch line. Using property checks is safer, but you can turn them off to boost performance.</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>
	</Fields>
</Session>
