<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/tt/adv/ttadv4522m000" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table Fields (ttadv4522m000)</Title>
	</Header>
	<HelpTopic xml:lang="en"><AimSection><Paragraph class="Default">
                                 Use this session to maintain the input fields which belong to the table definition.</Paragraph>
		</AimSection>
		<GeneralSection><List><ListIntro>Use the <GUIRef href="" role="menu">Specific</GUIRef> menu to:</ListIntro>
				<ListItem>Renumber the fields of the table.</ListItem>
				<ListItem>Maintain labels in the <GUIRef href="/baanerp/tt/adv/ttadv1140m000" role="session">Labels (ttadv1140m000)</GUIRef> session, starting at the code of the current table field.</ListItem>
				<ListItem>Insert a field before the marked table field.</ListItem>
			</List>
		</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="ttadv422.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="ttadv422.cmod"><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#100004" role="glossary">module</Link> for which the table is defined.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv422.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>.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">A table is uniquely identified by the combination of package code, module code and table identification code.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="ttadv422.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> code of the package for which the table is defined.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv422.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> code of the <Link href="/baanerp/tt/glossary/glossary#000000000000008" role="glossary">package</Link> for which the table is defined.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv422.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>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">It is only relevant in case of customized software.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="ttadv422.fdno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">No.</Title>
			</Header>
			<FuncDesc>The field number determines the sequence of the fields in the table definition.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">An index can be optimized by some database drivers (ISAM) if the parts of the index are adjacent (as index parts and table fields) and have data type string, byte or enumerate. An optimized index will speed up searching.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="ttadv422.fdnm"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Field</Title>
			</Header>
			<FuncDesc>Specifies the name of the field which can be used in forms, reports and in scripts in the following way: &lt;table name&gt;.&lt;field name&gt; The field name must be unique within the table.</FuncDesc>
			<SimpleSection><SectionTitle>
                                    Example
                                 </SectionTitle>
				<Paragraph class="Default">table : pksls040 (package - module - table number) field name: orno The field can be referred to by using pksls040.orno.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttadv422.comb"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Comb.</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, the field is combined. A combined field consists of two or more normal (not combined) fields. The child fields of a combined field can be maintained by the <GUIRef href="/baanerp/tt/adv/ttadv4523m000" role="session">Child Fields by Combined Field (ttadv4523m000)</GUIRef> session.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">A combined field can be used for references and indices.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="ttadv422.pacd"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Domain</Title>
			</Header>
			<FuncDesc>Specifies the <Link href="/baanerp/tt/glossary/glossary#000000000000008" role="glossary">package</Link> code of the domain of the table field.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv422.cdom"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Domain</Title>
			</Header>
			<FuncDesc>Specifies the <Link href="/baanerp/tt/glossary/glossary#domain.tt" role="glossary">domain</Link> of the table field that defines the data type and several characteristics of the field.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">If the table field is a combined field, no domain can be given.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="ttadv400.type"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Data Type</Title>
			</Header>
			<FuncDesc>Specifies the internal representation of data.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv400.leng"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Length</Title>
			</Header>
			<FuncDesc>If the data type of the <Link href="/baanerp/tt/glossary/glossary#domain.tt" role="glossary">domain</Link> is string, this field specifies the length in characters. If the data type is multi-byte string, this field specifies the number of positions on which the characters can be placed.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv422.clab"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Related Label/Description</Title>
			</Header>
			<FuncDesc>The code of the <Link href="/baanerp/tt/glossary/glossary#label.tt" role="glossary">label</Link> which is used as a description of the table field.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">This field can only be accessed if the Label Description field is empty.</Paragraph>
			</Note>
		</FieldHelp>
	</Fields>
</Session>
