<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/tt/adv/ttadv4120s000" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Table Definitions (ttadv4120s000)</Title>
	</Header>
	<HelpTopic xml:lang="en"><AimSection><Paragraph class="Default">
                                 Use this session to maintain tables in a package VRC. A table is used to store data in the database. The fields of a table identify which data is stored.</Paragraph>
		</AimSection>
	</HelpTopic>
	<Fields><FieldHelp ID="ttadv420.cpac"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Package</Title>
			</Header>
			<FuncDesc>The table's <Link href="/baanerp/tt/glossary/glossary#000000000000008" role="glossary">package</Link> code.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv420.vers"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">VRC</Title>
			</Header>
			<FuncDesc>The package <Link href="/baanerp/tt/glossary/glossary#000000000000009" role="glossary">version</Link> code for which the table is defined.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv420.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="ttadv420.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">The customer extension is only relevant for customized software.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="ttadv420.cmod"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Module</Title>
			</Header>
			<FuncDesc>The <Link href="/baanerp/tt/glossary/glossary#100004" role="glossary">module</Link> code to which the table belongs.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv420.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</Link> identification code.</FuncDesc>
			<SimpleSection><Paragraph class="Default">A table is uniquely identified by the combination of package code, module code, and table code.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttadv420.date"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Date</Title>
			</Header>
			<FuncDesc>The date.</FuncDesc>
			<RelatedTopics><SectionTitle>
                                    Related topics
                                 </SectionTitle>
				<RelTopic><Link href="/baanerp/basictasks/000008" role="manual">To enter a date</Link>
				</RelTopic>
			</RelatedTopics>
		</FieldHelp>
		<FieldHelp ID="ttadv420.desi"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">User</Title>
			</Header>
			<FuncDesc>The name or initials of the designer who created the table definitions.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttaad200.name"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">User</Title>
			</Header>
			<FuncDesc>The name of the <GUIRef href="/baanerp/tt" role="package">Tools</GUIRef> user.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv420.rfmu"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Update Ref. Message</Title>
			</Header>
			<FuncDesc>Select the message code, which appears if a user tries to change the primary key to which another table refers. For example Table: pkitm001 Item table Reference message update: pkitmt0001 Item code cannot be changed, item is in use. Table pksls041 (Sales order line) refers to the item table by its item code. If a user tries to change the item code in the item table, which is used in a sales order line, <GUIRef href="/baanerp/tt" role="package">Tools</GUIRef> gives the defined reference message.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv420.rfmd"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Delete Ref. Message</Title>
			</Header>
			<FuncDesc>The message code, which appears if a user tries to delete the primary key referred to by another table. For example Table: pkitm001 Item table Reference message delete: pkitmt0001 Item code cannot be deleted, item is in use. Table pksls041 (Sales order line) refers to the item table by its item code. If a user tries to delete the item code in the item table, which is used in a sales order line, <GUIRef href="/baanerp/tt" role="package">Tools</GUIRef> displays the defined reference message.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv420.rela"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Relation Type</Title>
			</Header>
			<FuncDesc>The relation type for the fields in this table.</FuncDesc>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">This indication is important for delayed lock facilities in the bshell. If you use a delayed lock, two users can change one record at the same time. Notice that they cannot change the same fields or the fields that are related to each other.</Paragraph>
			</Note>
		</FieldHelp>
		<FieldHelp ID="ttadv420.expi"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Expired</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, the <Link href="/baanerp/tt/glossary/glossary#table.tt" role="glossary">table</Link> has expired for this <Link href="/baanerp/tt/glossary/glossary#000000000000013" role="glossary">package VRC</Link> and its derivatives.</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 is available for the table.</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, <Link href="/baanerp/tt/glossary/glossary#000000000000010" role="glossary">release</Link> notes are available for the table.</FuncDesc>
		</FieldHelp>
	</Fields>
</Session>
