Linking field to use on (table name)
Indicates the field that connects the two documents and makes it possible to aggregate them.
Additional table where the rows will be collected
The additional table of the documents that assembles the rows; the name is always table_rows.
Quantity management field in the collection table
The field that manages quantity in the table that assembles the rows.
Comparing table containing the linking field
The table from which you want to aggregate.
Linking field in the comparing tab
The field that links the two documents in the comparison table.
Table which to retrieve rows
The additional table of the comparison table from which to retrieve the rows.
Possible additional SQL filter for row retrieval
It can be set to further filter the data.
Quantity management field in the aggregation table
The field that manages quantity in the table that assembles the rows in the comparison table.
Field of the assembled table for description on grouping rows
It is the description field of the assembled table.
Links for grouping rows
Links must be set for grouping the rows of the documents. Fields from comparison table_rows: the fields of the comparison table that must be linked. Fields named table_rows: the fields of the table that must receive the link. Sum: tick if the fields are to be added together. No Different: tick if the fields are not to be added together.
The links to be retrieved from the table.
Table for choosing the archive for confirmation
You can archive documents after aggregating them. The table for choosing the archive to confirm the archiving.
Archive to be used upon confirmation of the document
It is the archive where documents are to be kept after having aggregated them.