Zynk Workflow Documentation

Query settings are used to export additional data from Sage that is not included in the standard Zynk exports. It is also used to set criteria to filter the data exported. All the settings below are SQL based.

Settings

Columns

Optional
Used to enter the column names to export from the Sage database. Be sure to include the table name eg. SLCustomerAccount].[CustomerAccountNumber]

Joins

Optional
Allows data to be exported from other tables in the Sage database. Required when exporting data from tables not included in the standard export.

Where Clauses

Optional
Allows filters to be set to limit the data that is exported.

Articles

See theĀ Sage 200 Custom Exports tutorial for examples of how to use the query settings.


Back | Edit on Github