Go to documentation repository
Page History
...
Each query type has its own set of parameters which is displayed when the query type is selected.
| Info | ||
|---|---|---|
| ||
| Some queries, for example, the List of all queries, have no parameters. |
...
Name of query | Parameters | Purpose of query |
|---|---|---|
| №01 List of all receipts | - | Getting the list of all receipts recorded to the database for the specified period. The cashier number is displayed for each receipt. |
| №02 All receipts list with a cashier's name | - | Getting the list of all receipts recorded to the database for the specified period. The cashier number is displayed for each receipt. |
| №03 List of all good's returns (1) | - | Getting the list of all good's returns for the specified period. Return is defined by non-zero value of the return parameter in the database. |
| №03 List of all good's returns (2) | - | Getting the list of good's returns with negative number of goods for the specified period. |
| №04 Search by receipt number | Receipt number | Search for receipt with the specified number for the specified period. |
| №05 Search by return number | Return number | Search for receipts containing the specified return number. Value of this parameter is specified on the parser. |
| №06 Search by cashier number | Cashier number | Search for receipts containing the specified cashier number for the specified period. |
| №07 Search by marking of good | Marking of goods | Search for receipts containing the specified marking of goods for the specified period. |
| №09 Goods report | Goods | Getting the number of sold goods with specified name and realized sum for the specified period |
| №10 Archive depth | - | Getting the information about the earliest receipt date in the database and the latest receipt date and the number of receipts between these dates. |
| №11 Search by goods amount in receipt | Minimal goods amount Maximal goods amount | Getting the list of receipts for the specified period in which the amount of goods is in the specified range. |
| №12 Query by receipt's total | Minimal total Maximal total | Getting the list of receipts, sum (total) of which is in the specified range. |
| №13 List of all receipts by goods (and) | Goods No.1 Goods No.2 | Getting the list of receipts containing both of specified goods for the specified period. |
| №14 List of receipts by goods (or) | Goods No.1 Goods No.2 Minimal price Maximal price | Getting the list of receipts for the specified period containing at least one of the specified goods and in which the price is in the specified range. |
| №15 Search of receipts by goods | Goods | Getting the list of receipts containing the specified goods. |
| №16 List of all receipts of cashier | Cashier name | Search for receipts containing the specified cashier name for the specified period. |
| №17 List of receipt's cancellation (negative sum) | - | Getting the list of receipts for the specified period sum of which is negative. |
| №18 Query by goods weight | Goods maximal weight | Search for receipts for the specified period containing the catchweight goods weight of which less than the specified weight. |
| №19 Query by discount value | Minimal discount Maximal discount | Search for receipts discount of which is in the specified range for the specified period. |
| №20 List of all receipts of waiter | Waiter's name | Getting the list of receipts containing the waiter's name for the specified period. |
| №21 List of receipt's cancellations (receipt's numbers) | - | Getting the list of cancelled receipts for the specified period. |
| №22 Selling for a period | - | Total sum of gain for the specified period. |
| №23 Receipts with cancelled positions (negative sum) | - | Search for receipts containing positions with negative sum for the specified period. |
| №24 Goods rating by selling sum | Goods quantity to list Name | Getting the specified amount of goods of specified name with the most total sum by all receipts for the specified period. |
| №25 Goods rating by quantity | Goods quantity to list Name | Getting the specified amount of goods of specified name with the most total amount by all receipts for the specified period. |
| №26 List of receipts with multyple same goods | Goods Min. goods amount Max. goods amount | Getting the list of receipts containing the specified goods in the amount is within the specified range for the specified period. |
| №27 Cash point's gain report for every 30 minutes | - | Getting information about gain by all cash points for every 30 minutes for the specified period. |
Overview
Content Tools