<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/tt/adv/ttadv4122s000" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table Fields (ttadv4122s000)</Title>
	</Header>
	<HelpTopic xml:lang="en"><AimSection><Paragraph class="Default">
                                 Use this session to maintain fields that belong to the table definition.</Paragraph>
		</AimSection>
		<GeneralSection><List><ListIntro>On the first form you can:</ListIntro>
				<ListItem>Enter the field name and field number of the table field. The field name must be unique in the current table.</ListItem>
				<ListItem>Specify whether the field is combined. For example, is there a combination of two or more fields of the same table?</ListItem>
				<ListItem>You must specify a domain that specifies the data type, legal values, validation check, display format and so on.</ListItem>
				<ListItem>Specify the label data for the field, the initial value, the mandatory input, and whether it is a repeating field.</ListItem>
			</List>
			<Paragraph class="Default">On the next form you can specify a relation to another table, insert check, delete, and update mode. Finally, you can specify whether the field is active.</Paragraph>
		</GeneralSection>
	</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 package 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 <Link href="/baanerp/tt/glossary/glossary#table.tt" role="glossary">table's</Link> identification code.</FuncDesc>
			<SimpleSection><Paragraph class="Default">A table is uniquely identified by the combination of package code, module code, and table identification code.</Paragraph>
			</SimpleSection>
		</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 package 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 <Link href="/baanerp/tt/glossary/glossary#000000000000008" role="glossary">package</Link> for which the table is defined.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">The customer extension is only relevant in case of customized software.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="ttadv422.fdnm"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Field Name</Title>
			</Header>
			<FuncDesc>The name of the field that can be used in forms, reports, and in scripts in the following way: &lt;table name&gt;.&lt;field name&gt;</FuncDesc>
			<SimpleSection><Paragraph class="Default">The field name must be unique in the table.</Paragraph>
				<Paragraph class="Default"> 
                                    Example table : pksls040 (package - module - table number) field name: orno</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttadv422.fdno"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Sequence Number</Title>
			</Header>
			<FuncDesc>The field number that determines the sequence of the fields in the table definition.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">An <Link href="/baanerp/tt/glossary/glossary#index.tt" role="glossary">index</Link> can be optimized by some database drivers (ISAM) if the parts of the index are adjacent (as index parts and table fields) and have the string, byte, or enumerate data type. An optimized index speeds up searching.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="ttadv422.comb"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Combined Field</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.</FuncDesc>
			<SimpleSection><List><ListItem>A combined field can be used for references and indices.</ListItem>
					<ListItem>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.</ListItem>
				</List>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttadv422.mand"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Mandatory Input</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, input in this field by the user is mandatory.</FuncDesc>
			<SimpleSection><Paragraph class="Default">If the field has the byte, integer, long, float or double data type, mandatory input means that the value of the field must be unequal to 0. In fact, mandatory input is an addition to the domain definition of the field and has precedence over what is defined as the range of the domain. If the user tries to make a field empty while input is mandatory <GUIRef href="/baanerp/tt" role="package">Tools</GUIRef> gives range message of the domain.</Paragraph>
				<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><TBODY><TR><TD colspan="3" rowspan="1">Example</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">Field:</TD>
							<TD rowspan="1" colspan="1">Employee number</TD>
							<TD rowspan="1" colspan="1">(datatype long)</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">Range</TD>
							<TD rowspan="1" colspan="1">Mandatory input</TD>
							<TD rowspan="1" colspan="1">Allowed range on the field</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">$$ IN [0, 999999]</TD>
							<TD rowspan="1" colspan="1">no</TD>
							<TD rowspan="1" colspan="1">0 - 999999</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">$$ IN [0, 999999]</TD>
							<TD rowspan="1" colspan="1">yes</TD>
							<TD rowspan="1" colspan="1">1 - 999999</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">$$ IN [1, 999999]</TD>
							<TD rowspan="1" colspan="1">no</TD>
							<TD rowspan="1" colspan="1">0 - 999999 (0=empty)</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">$$ IN [1, 999999]</TD>
							<TD rowspan="1" colspan="1">yes</TD>
							<TD rowspan="1" colspan="1">1 - 999999</TD>
						</TR>
					</TBODY>
				</TABLE>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttadv422.repf"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Repeating Field</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, the table field is repeating.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">A repeating field appears a number of times in the table with the same name and characteristics.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="ttadv422.dept"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">No. of elements</Title>
			</Header>
			<FuncDesc>The depth of the field that is indicated as a repeating field.</FuncDesc>
			<SimpleSection><Paragraph class="Default"> 
                                    Example table : <GUIRef href="/baanerp/tt/adv/ttadv4122s000#ttadv422.dept" role="manual">No. of elements</GUIRef> fields: Help Topic Code (1) Topic Title (1) Topic Keywords (4)</Paragraph>
			</SimpleSection>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">Topic Keywords is a repeating field of 4 levels. In the No. of Elements table you can define no more than four key words for each No. of Elements table.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="ttadv422.pacd"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Domain</Title>
			</Header>
			<FuncDesc>The <Link href="/baanerp/tt/glossary/glossary#domain.tt" role="glossary">domain</Link> of the table field's <Link href="/baanerp/tt/glossary/glossary#000000000000008" role="glossary">package</Link> code.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv422.cdom"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Domain</Title>
			</Header>
			<FuncDesc>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/Length</Title>
			</Header>
			<FuncDesc>The internal representation of data.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv400.leng"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Data Type/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 is the length in characters. If the data type is multibyte string, it specifies the number of positions on which the characters can be placed.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv422.iniv"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Initial Value</Title>
			</Header>
			<FuncDesc>If a user enters a new record to the table this is the initial value .</FuncDesc>
			<DefaultValue><SectionTitle>
                                    Default value
                                 </SectionTitle>
				<Paragraph class="Default">Empty or zero (depending on the data type).</Paragraph>
			</DefaultValue>
		</FieldHelp>
		<FieldHelp ID="labl.desc"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Label Description</Title>
			</Header>
			<FuncDesc>The description of the table field which is used for a label with the same name as the table field. If a label in a form, report or menu has the same name as the table field, this description will replace the label.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">A percentage symbol % in the label description forces a line break in the label in the form, report, or menu.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="labl.leng"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Label Length</Title>
			</Header>
			<FuncDesc>The length of the <Link href="/baanerp/tt/glossary/glossary#label.tt" role="glossary">label</Link> that is used in forms, reports and menus.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv422.clab"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Related Label</Title>
			</Header>
			<FuncDesc>The code of the <Link href="/baanerp/tt/glossary/glossary#label.tt" role="glossary">label</Link> that 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 field Label Description is empty.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="ttadv422.rfpa"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Reference Table</Title>
			</Header>
			<FuncDesc>The package of the reference table to which this field refers.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv422.rfmo"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Reference Table</Title>
			</Header>
			<FuncDesc>The <Link href="/baanerp/tt/glossary/glossary#100004" role="glossary">module</Link> of the reference table to which this field refers.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv422.rffn"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Reference Table</Title>
			</Header>
			<FuncDesc>The table number of the reference <Link href="/baanerp/tt/glossary/glossary#table.tt" role="glossary">table</Link> to which this field refers.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="period"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Reference Table</Title>
			</Header>
			<FuncDesc>This field displays a period.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv422.rffd"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Reference Table</Title>
			</Header>
			<FuncDesc>The field name of the reference table to which is referred.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv422.refm"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Reference Mode</Title>
			</Header>
			<FuncDesc></FuncDesc>
			<SimpleSection><List><ListIntro>You can choose the following options:</ListIntro>
					<ListItemHead>Mandatory</ListItemHead>
					<ListItem>The foreign key value (the reference record) must exist in the reference table.</ListItem>
					<ListItemHead>Mandatory unless empty</ListItemHead>
					<ListItem>Same as Mandatory, but it allowed that the foreign key value is empty.</ListItem>
					<ListItemHead>Not mandatory</ListItemHead>
					<ListItem>The foreign key value will not be checked against the reference table.</ListItem>
				</List>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttadv422.rfmp"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Reference Message</Title>
			</Header>
			<FuncDesc>The <Link href="/baanerp/tt/glossary/glossary#000000000000008" role="glossary">package</Link> code of the message which is given when a given value does not correspond to a record in the reference table.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv422.rfmc"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Reference Message</Title>
			</Header>
			<FuncDesc>The message code which <GUIRef href="/baanerp/tt" role="package">Tools</GUIRef> gives, if you enter a value in an input field in the form, where no related record in the reference table is present.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">The reference message is only relevant if the reference mode is mandatory, or mandatory unless empty.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="ttadv422.rfin"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Check by DBMS</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, the referential integrity of the reference field must be checked by the <Link href="/baanerp/tt/glossary/glossary#000000000000019" role="glossary">database</Link> server.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv422.rfde"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Delete Mode</Title>
			</Header>
			<FuncDesc>Select the action to be taken by <GUIRef href="/baanerp/tt" role="package">Tools</GUIRef>, if an occurrence in the table referred to (= parent or reference table), is deleted.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv422.rfup"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Update Mode</Title>
			</Header>
			<FuncDesc>Select the action to be taken by <GUIRef href="/baanerp/tt" role="package">Tools</GUIRef>, if the primary key of a record in the table to which is referred (= parent), is changed.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="docu"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Tech.Documentation</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, documentation for the table field is present.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="reln"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Release Notes</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, release notes for the table field are available.</FuncDesc>
		</FieldHelp>
	</Fields>
</Session>
