<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/tt/adv/ttadv4521m000" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Indices (ttadv4521m000)</Title>
	</Header>
	<HelpTopic xml:lang="en"><AimSection><Paragraph class="Default">
                                 Use this session to list, find or maintain the <Link href="/baanerp/tt/glossary/glossary#index.tt" role="glossary">indices</Link> which are defined in a <Link href="/baanerp/tt/glossary/glossary#table.tt" role="glossary">table</Link>.</Paragraph>
		</AimSection>
		<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="ttadv421.cpac"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table</Title>
			</Header>
			<FuncDesc>The code of the <Link href="/baanerp/tt/glossary/glossary#000000000000008" role="glossary">package</Link> for which the table is defined.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv421.cmod"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table</Title>
			</Header>
			<FuncDesc>The <Link href="/baanerp/tt/glossary/glossary#100004" role="glossary">module</Link> code of the table.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv421.flno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table</Title>
			</Header>
			<FuncDesc>The identification code of the <Link href="/baanerp/tt/glossary/glossary#table.tt" role="glossary">table</Link>, for which the index has been defined.</FuncDesc>
			<SimpleSection><Paragraph class="Default">A table is uniquely identified by this code in combination with the package and module codes.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttadv421.vers"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">VRC</Title>
			</Header>
			<FuncDesc>The <Link href="/baanerp/tt/glossary/glossary#000000000000009" role="glossary">version</Link> of the <Link href="/baanerp/tt/glossary/glossary#000000000000008" role="glossary">package</Link> for which the table is defined.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv421.rele"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">VRC</Title>
			</Header>
			<FuncDesc>The <Link href="/baanerp/tt/glossary/glossary#000000000000010" role="glossary">release</Link> of the <Link href="/baanerp/tt/glossary/glossary#000000000000008" role="glossary">package</Link> for which the table is defined.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv421.cust"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">VRC</Title>
			</Header>
			<FuncDesc>The <Link href="/baanerp/tt/glossary/glossary#000000000000011" role="glossary">customer</Link> extension of the <Link href="/baanerp/tt/glossary/glossary#000000000000008" role="glossary">package</Link> for which the table is defined.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv421.indn"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Index Number</Title>
			</Header>
			<FuncDesc>The number of the index, which is a unique number within the table.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">The primary key always has index number 1.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="ttadv421.dupl"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Dupl</Title>
			</Header>
			<FuncDesc>Yes Different records can have the same values in the index parts. These are called duplicate records.</FuncDesc>
			<SimpleSection><Paragraph class="Default">No Duplicate records are not allowed.</Paragraph>
				<Paragraph class="Default">The primary index (index number 1) may not have duplicates.</Paragraph>
				<Paragraph class="Default">For example : An item table has two indices :</Paragraph>
				<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><TBODY><TR><TD rowspan="1" colspan="1">Index no.</TD>
							<TD rowspan="1" colspan="1">Part(s)</TD>
							<TD rowspan="1" colspan="1">Duplicates</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">1</TD>
							<TD rowspan="1" colspan="1">Item code</TD>
							<TD rowspan="1" colspan="1">no</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">2</TD>
							<TD rowspan="1" colspan="1">Item group</TD>
							<TD rowspan="1" colspan="1">yes</TD>
						</TR>
					</TBODY>
				</TABLE>
				<Paragraph class="Default">Each record in the item table must have a unique item code. The combination of item group and description is not unique, so it is possible that two items in the item table have the same item group and description.</Paragraph>
				<Paragraph class="Default">Note: Indices allowing duplicate values can slow down delete actions on the table they refer to. You must make an index unique by adding the primary key at the end.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttadv421.acti"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Acti</Title>
			</Header>
			<FuncDesc>This field indicates whether the index is active or not.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<List><ListItem>The primary index (index number 1) is always active.</ListItem>
					<ListItem>This information is not used in the data dictionary or the database layer.</ListItem>
				</List>
			</Note>
		</FieldHelp>
	</Fields>
</Session>
