Custom procedures execute pre-set SQL scripts to compile information or to execute a command. Custom procedures can be used for exports, manifests, reports, settlements, shipping labels, and can modify dispatch board data.
...
| Field | Description | |||||
|---|---|---|---|---|---|---|
| Procedure ID | Unique numerical ID for the custom procedure.
| |||||
| Description | Description of the custom procedure. | |||||
| Procedure Type | Type of custom procedure.
| |||||
| These SQL parameters should be included in your custom procedure | Required criteria to for the SQL to run. | |||||
| SQL | SQL stored procedure to be used for the custom procedure. | |||||
| Report Format | Selected report format to use in the custom procedure. Click Add New to add a new custom report format or click Edit to edit the selected report format. | |||||
| Filename | The default filename when saving export procedure type custom procedures. Visible when Output Specification is set to "use literal name". | |||||
| Data Field | The declared field name from the SQL of the value to use as the default filename when saving export procedure type custom procedures. Visible when Output Specification is set to "use data field". | |||||
| Output Specification | The selected method of how the default filename will be populated for export procedure type custom procedures.
|
...