General ledger> Setup> Financial reports generator> Queries
Use the query directory to configure and edit queries to retrieve values from database tables for electronic reporting. You can retrieve values from any database table, including the E-Document Register, which stores information about a created document, such as the sender, document date, and number. Configured queries are used to create values for fixed requisites.
Task that
uses this form
Navigating
the form
The following tables provide descriptions for the controls in this form.
Tabs
|
Tab |
Description |
|---|---|
|
Overview |
View the query identification code and name, and the table that it refers to. |
|
General |
Modify the query name if required, and view the query and table details. |
|
Query |
View the query as an SQL statement. |
Buttons
|
Button |
Description |
|---|---|
|
Query |
Open the Inquiryform to create a complex query for several tables, and enter the selection criteria. |
|
Reset |
Reset the query. |
|
Fixed requisites |
Open the Fixed requisitesform, and view the requisites with values that were created based on the queries. |
Fields
|
Field |
Description |
|---|---|
|
Query |
The identification code for the query. |
|
Name |
View or modify the query name. |
|
Table |
The name of the main query table. |
|
Query type |
The query type as Simpleor VAT declaration second section. |
|
Name of table |
The unique table name. |
|
SQL statement |
The textual representation of the query as an SQL statement. |
