<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/tt/adv/ttadv4121s000" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table Indices (ttadv4121s000)</Title>
	</Header>
	<HelpTopic xml:lang="en"><AimSection><Paragraph class="Default">
                                 Use this session to define indices for the table from which the session is started.</Paragraph>
		</AimSection>
		<GeneralSection><Paragraph class="Default">An index is used to sort and search records.</Paragraph>
			<Paragraph class="Default">Each table must have at least one index. The first index is always the primary key. The primary key field(s) form the unique identification for each record in the table. You can add indices to the table when application demands make this necessary.</Paragraph>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<List><ListIntro><GUIRef href="/baanerp/tt" role="package">Tools</GUIRef> displays the table for which the indices and the VRC code are defined.</ListIntro>
					<ListItem>Enter the number of the index and the description.</ListItem>
					<ListItem>Specify the index parts, which are the names of existing table fields.</ListItem>
					<ListItem>Specify whether duplicates are accepted, and whether the index is active.</ListItem>
				</List>
			</Note>
		</GeneralSection>
	</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 package, for which the <Link href="/baanerp/tt/glossary/glossary#table.tt" role="glossary">table</Link> 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#100016" role="glossary">VRC</Link> is the version of the package for which <GUIRef href="/baanerp/tt" role="package">Tools</GUIRef> defines the table.</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 package 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 package 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. The primary key always has index number one.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv421.part"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">1</Title>
			</Header>
			<FuncDesc>An index part is the name of a table field defined in the <GUIRef href="/baanerp/tt/adv/ttadv4122s000" role="session">Table Fields (ttadv4122s000)</GUIRef> session.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">An index can consist of up to 24 logical parts. The maximum number of physical parts is eight. Adjacent index parts of the type string, enumerate, or byte can be optimized into one physical part if they are also adjacent in the table definitions. (Only for ISAM database organizations).</Paragraph>
				<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><TBODY><TR><TH colspan="2" rowspan="1">For example</TH>
						</TR>
						<TR><TD rowspan="1" colspan="1">logp =</TD>
							<TD rowspan="1" colspan="1">logical part</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">physp =</TD>
							<TD rowspan="1" colspan="1">physical part</TD>
						</TR>
					</TBODY>
				</TABLE>
				<Paragraph class="Default">Logical part = Table field (part of index) Physical part= Adjacent table fields (parts of an index)</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="ttadv421.dupl"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Duplicates</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, different records can have the same values in the index parts. These are called duplicate records.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv421.acti"><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/tt/glossary/glossary#index.tt" role="glossary">index</Link> is active. The primary index (index number 1) is always active.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">This information is not used in the data dictionary or the database layer.</Paragraph>
			</Note>
		</FieldHelp>
	</Fields>
</Session>
