<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/da/xch/daxch0112m000" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Ranges (daxch0112m000)</Title>
	</Header>
	<HelpTopic xml:lang="en"><AimSection><Paragraph class="Default">
                                 Use this session to limit the <Link href="/baanerp/da/glossary/glossary#000016" role="glossary">export procedure</Link> to a range of records. You can, for example, define ranges to export only Items belonging to a particular item group, or employees belonging to a specific department.</Paragraph>
		</AimSection>
		<GeneralSection><Paragraph class="Default">This session allows you to use relational and logical operators to create range-limitation logic expressions that control the export process. Only active records that match the condition are exported. This enables you to transfer a smaller file between systems.</Paragraph>
			<Paragraph class="Default">The range is made active in the <GUIRef href="/baanerp/da/xch/daxch0531m000" role="session">Table Relations (Export) (daxch0531m000)</GUIRef> or <GUIRef href="/baanerp/da/xch/daxch0131s000" role="session">Table Relations (Export) (daxch0131s000)</GUIRef> session.</Paragraph>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">If you have started this session by zooming, you can only find and select a record.</Paragraph>
			</Note>
			<GeneralSection><SectionTitle>Restrictions per data type of the ERP LN table field</SectionTitle>
				<List><ListIntro>Data type <Emphasis>date</Emphasis>
					</ListIntro>
					<ListItem>The entered date field must be of the Default Date Format</ListItem>
					<ListItem>The plus or minus signs can be used to change the current date. For example, +2 adds two days to the current date.</ListItem>
					<ListItem>The character # can be used for the current date.</ListItem>
				</List>
				<List><ListIntro>Data type <Emphasis>string/multibyte</Emphasis>
					</ListIntro>
					<ListItem>The domain of the ERP LN table field determines if a field is justified to the left, right or center or converted to upper or lower case.</ListItem>
				</List>
				<List><ListIntro>Data type <Emphasis>numeric</Emphasis>
					</ListIntro>
					<ListItem>Only numeric values can be entered</ListItem>
				</List>
			</GeneralSection>
			<GeneralSection><List><ListIntro>For the <Link href="/baanerp/da/glossary/glossary#000020" role="glossary">operators</Link> <Emphasis>In</Emphasis> or <Emphasis>Not In</Emphasis>, the value must be entered as follows:</ListIntro>
					<ListItem>The set of values must be placed between parentheses.</ListItem>
					<ListItem>For data type <Emphasis>string</Emphasis>, each item in the set of values must be placed between double quotes.</ListItem>
				</List>
				<ExampleSection><SectionTitle>
                                       Example
                                    </SectionTitle>
					<Paragraph class="Default">For a numeric field (1,2,5,7). For a string or multibyte string, then double quotes should be added ("a","b").</Paragraph>
				</ExampleSection>
			</GeneralSection>
		</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/000035" role="manual">To maintain records in an overview session</Link>
			</RelTopic>
		</RelatedTopics>
	</HelpTopic>
	<Fields><FieldHelp ID="daxch012.cxch"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Exchange Scheme</Title>
			</Header>
			<FuncDesc>Specifies the <Link href="/baanerp/da/glossary/glossary#000003" role="glossary">exchange scheme</Link> code.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="daxch012.cbat"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Batch</Title>
			</Header>
			<FuncDesc>Specifies the <Link href="/baanerp/da/glossary/glossary#000002" role="glossary">batch</Link> code.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="daxch012.ttbl"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table</Title>
			</Header>
			<FuncDesc>Specifies the code ERP LN table 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>
		</FieldHelp>
		<FieldHelp ID="daxch012.srno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Ser. No.</Title>
			</Header>
			<FuncDesc>The serial number that makes the range unique in the table relation. The serial number is only used as an identifier and it forces the correct sorting sequence.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">Use an interval so that ranges can be added later.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="daxch012.tfld"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table Field</Title>
			</Header>
			<FuncDesc>The code of the ERP LN table field on which the range-limitation logic expression is based.</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="daxch012.oper"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Operator</Title>
			</Header>
			<FuncDesc>Specifies the relational <Link href="/baanerp/da/glossary/glossary#000020" role="glossary">operator</Link> that is used for creating an expression.</FuncDesc>
			<AllowedValues><SectionTitle>
                                    Allowed values
                                 </SectionTitle>
				<Paragraph class="Default">See <Link href="/baanerp/da/domains/xch.oper" role="domain">Possible values</Link>
				</Paragraph>
			</AllowedValues>
		</FieldHelp>
		<FieldHelp ID="range.frm"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Value (From)</Title>
			</Header>
			<FuncDesc>Enter the value the <Link href="/baanerp/da/glossary/glossary#000020" role="glossary">operator</Link> will apply to.</FuncDesc>
			<SimpleSection><Paragraph class="Default">Only if the operator type is <GUIRef href="/baanerp/da/domains/xch.oper#between" role="option">Between</GUIRef> or <GUIRef href="/baanerp/da/domains/xch.oper#not.between" role="option">Not Between</GUIRef>, the entered value is the start value of a range.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="range.to"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Value (To)</Title>
			</Header>
			<FuncDesc>Enter the end value of the range.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">This field can only be entered if the operator is <GUIRef href="/baanerp/da/domains/xch.oper#between" role="option">Between</GUIRef> or <GUIRef href="/baanerp/da/domains/xch.oper#not.between" role="option">Not Between</GUIRef>.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="daxch012.anor"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">And/or/end</Title>
			</Header>
			<FuncDesc>Enter the <Link href="/baanerp/da/glossary/glossary#000020" role="glossary">operator</Link> that is used to combine several relational expressions into one range condition.</FuncDesc>
			<SimpleSection><Paragraph class="Default">If the range rules need more than one line to be expressed properly, enter an <GUIRef href="" role="manual">and</GUIRef> or an <GUIRef href="" role="manual">or</GUIRef> to join the multiple lines.</Paragraph>
				<Paragraph class="Default">The last line in an expression must end with <GUIRef href="" role="manual">end of expression</GUIRef>.</Paragraph>
				<Paragraph class="Default">When a range expression goes over one line, the sequence number is the only determination of which line is to be read next.</Paragraph>
			</SimpleSection>
			<AllowedValues><SectionTitle>
                                    Allowed values
                                 </SectionTitle>
				<Paragraph class="Default">See <Link href="/baanerp/da/domains/xch.andor" role="domain">Possible values</Link>
				</Paragraph>
			</AllowedValues>
		</FieldHelp>
	</Fields>
</Session>
