Use this form to create or modify queries that allow you to retrieve values from database tables. You can retrieve values from any database table, including the E-Document Register, which stores information about electronic documents, such as the sender, document date, and number. You can also create a query to retrieve information from the VAT Declaration Section 2 table, which contains details about Value Added Tax (VAT) transactions.

Open the form

  1. Click General ledger> Setup> Financial reports generator> Queriesto open the Queriesform.

  2. Press CTRL+N to open the Create queryform.

Task that uses this form

Navigating the form

The following tables provide descriptions for the control in this form.

Tabs

Tab

Description

Parameters

Set up the query and table details.

Query

View the query.

Buttons

Button

Description

Query

Open the Inquiryform to create a complex query for several tables and enter the selection criteria.

Note Note

This button is activated only when a main query table is selected in the Tablefield.

Reset

Reset the query.

Note Note

This button is activated only when a main query table is selected in the Tablefield.

Fields

Field

Description

Query

Enter an identification code for the query.

Name

Enter the name of the query.

Query type

Select the query type from the following options:

  • Simple– A query type that allows you to retrieve data from database tables.

  • VAT Declaration second section– A predefined, customizable query type that uses the VAT Declaration Section 2 table indicators. VAT transactions are stored in this table.

Create requisites

Select this check box to create requisites in the directory when you create the query.

Note Note

This check box is activated only if you select VAT Declaration second sectionas the Query type.

Table

Select the identification code of the main table to be queried.

Name of table

Select the unique name of the table.

Note Note

The Tableand Name of tablefields are activated only if you select Simpleas the Query type.

SQL statement

The textual representation of the query as an SQL statement.

See Also