<?xml version="1.0" encoding="utf-8"?>
<Session ID="/baanerp/tt/adv/ttadv3180s000" xml:lang="en">
	<Header>
		<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Query Data (ttadv3180s000)</Title>
	</Header>
	<HelpTopic xml:lang="en"><AimSection><Paragraph class="Default">
                                 Use this session to define and maintain <Link href="/baanerp/tt/glossary/glossary#100052" role="glossary">query</Link> data details.</Paragraph>
		</AimSection>
		<GeneralSection><Paragraph class="Default">To view query data details, double click a record in the <Link href="/baanerp/tt/adv/ttadv3580m000" role="session">Query Data (ttadv3580m000)</Link> session.</Paragraph>
			<Note><SectionTitle>
                                    Note
                                 </SectionTitle>
				<Paragraph class="Default">You can click Text to add Help and/or technical documentation to the query.</Paragraph>
			</Note>
		</GeneralSection>
		<RelatedTopics><SectionTitle>
                                 Related topics
                              </SectionTitle>
			<RelTopic><Link href="/baanerp/tt/onlinemanual/100023" role="manual">To define a query</Link>
			</RelTopic>
			<RelTopic><Link href="/baanerp/tt/onlinemanual/100021" role="manual">To run a query</Link>
			</RelTopic>
		</RelatedTopics>
	</HelpTopic>
	<Fields><FieldHelp ID="ttadv380.cqur"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Query</Title>
			</Header>
			<FuncDesc>The <Link href="/baanerp/tt/glossary/glossary#100052" role="glossary">query</Link> code.</FuncDesc>
			<SimpleSection><Paragraph class="Default">Use a code that clearly identifies the query. The code can only contain alphanumeric characters and the underscore or period.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttadv380.logn"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Owner</Title>
			</Header>
			<FuncDesc>The owner of the <Link href="/baanerp/tt/glossary/glossary#100052" role="glossary">query</Link>.</FuncDesc>
			<SimpleSection><Paragraph class="Default">If you do not define an owner, any user can modify the query. It is then a general query. You can also enter your own user name, as recorded in the <GUIRef href="ttaad200.user" role="tablefield">User</GUIRef> field in the <Link href="/baanerp/tt/ams/ttams1100s000" role="session">User Data (ttams1100s000)</Link> session. You are now the only person permitted to maintain the query. All users can run or copy the query.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttadv380.desc"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Description</Title>
			</Header>
			<FuncDesc>A description of the <Link href="/baanerp/tt/glossary/glossary#100052" role="glossary">query</Link>.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv380.desi"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Created by</Title>
			</Header>
			<FuncDesc>The name of the user who created the query.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv380.date"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Date</Title>
			</Header>
			<FuncDesc>The date on which the query was created. If you create a query, the current date is offered as default value.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv380.outp"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Output Type</Title>
			</Header>
			<FuncDesc>Select the <Link href="/baanerp/tt/glossary/glossary#100052" role="glossary">query</Link> output type.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv380.repo"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Report</Title>
			</Header>
			<FuncDesc>The name of the report that is generated if you click Generate Query Report on the <GUIRef href="" role="menu">Specific</GUIRef> menu in the <GUIRef href="/baanerp/tt/adv/ttadv3580m000" role="session">Query Data (ttadv3580m000)</GUIRef> session. If a report exists, <GUIRef href="/baanerp/tt" role="package">Tools</GUIRef> displays the name of this report. Each report generated receives the (current) package code, the module code sql, and followed by default, the query code.</FuncDesc>
			<SimpleSection><SectionTitle>
                                    Example
                                 </SectionTitle>
				<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><TBODY><TR><TD rowspan="1" colspan="1">Current Package:</TD>
							<TD rowspan="1" colspan="1">tt</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">Query Code</TD>
							<TD rowspan="1" colspan="1">test</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">Report</TD>
							<TD rowspan="1" colspan="1">ttsqltest</TD>
						</TR>
					</TBODY>
				</TABLE>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttadv380.prop"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Print Options</Title>
			</Header>
			<FuncDesc>Select the size of the report to be generated. Report sizes are recorded in the <Link href="/baanerp/tt/adv/ttadv3540m000" role="session">Default Sizes (ttadv3540m000)</Link> session.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv380.colu"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Columns label</Title>
			</Header>
			<FuncDesc>The width of a label. This includes spaces, and is expressed as the number of columns.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv380.rows"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Rows label</Title>
			</Header>
			<FuncDesc>The height of the label. This includes spaces, and is expressed as the number of lines.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="ttadv380.nrlb"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Labels horizontal</Title>
			</Header>
			<FuncDesc>Labels can be printed side by side. In this field, you can specify the number of labels to be printed in this way. You must remain within the measures, as selected in the <GUIRef href="/baanerp/tt/adv/ttadv3180s000#ttadv380.prop" role="manual">Print Options</GUIRef> field.</FuncDesc>
		</FieldHelp>
		<FieldHelp ID="help"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Help Information</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, Help information is available in this session.</FuncDesc>
			<SimpleSection><Paragraph class="Default">Click text to add Help to the <Link href="/baanerp/tt/glossary/glossary#100052" role="glossary">query</Link>.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="docu"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Tech.Document.</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, technical documentation is available in this session.</FuncDesc>
			<SimpleSection><Paragraph class="Default">Click text to add technical documentation to the <Link href="/baanerp/tt/glossary/glossary#100052" role="glossary">query</Link>.</Paragraph>
			</SimpleSection>
		</FieldHelp>
		<FieldHelp ID="ttadv380.lblb"><Header>
				<Title xmlns:HTML="http://www.w3.org/TR/REC-html40">Also descriptions</Title>
			</Header>
			<FuncDesc>
                                 If this check box is selected, field descriptions are printed before the data.</FuncDesc>
			<SimpleSection><SectionTitle>
                                    Example
                                 </SectionTitle>
				<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><TBODY><TR><TD rowspan="1" colspan="1">Name :</TD>
							<TD rowspan="1" colspan="1">Johnson</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">Street :</TD>
							<TD rowspan="1" colspan="1">First Avenue</TD>
						</TR>
					</TBODY>
				</TABLE>
				<Paragraph class="Default">
                                    If this check box is cleared, only the data is printed.</Paragraph>
			</SimpleSection>
			<SimpleSection><SectionTitle>
                                    Example
                                 </SectionTitle>
				<TABLE border="1" borderstyle="default" space-and-orientation="indented-estimated"><TBODY><TR><TD rowspan="1" colspan="1">Name :</TD>
							<TD rowspan="1" colspan="1">Johnson</TD>
						</TR>
						<TR><TD rowspan="1" colspan="1">Street :</TD>
							<TD rowspan="1" colspan="1">First Avenue</TD>
						</TR>
					</TBODY>
				</TABLE>
			</SimpleSection>
		</FieldHelp>
	</Fields>
</Session>
