Requirements for download requests and marking records
When creating a database table to be used in a download request that requires records to be marked to indicate use at the device, fields must also be assigned to hold the record status, device name, and call ID (applicable to SQL Server databases) specific to the environment.
The system uses the following fields as the default fields: Status, Device, and Call ID.
Any field can be used as long as the information it will contain is specified: status, device name, or call ID.
Use the following guidelines when defining the fields.
-
Status: type = character; length = 1
-
Device: type = character; length = 10
-
Call ID: type = character; length = 14
The database table can be accessed through a download request, an output, or a SQL statement.If there are multiple environments, the apps created must be assigned to a specific enterprise environment, and all references made within an app to database tables must correspond only to those tables registered to the assigned environment.
Example: An app can be created for a paperless pick that instructs the picker on the items, how many items to pick, and where to pull the items from. The app carries out the instructions through a download request. The download request contains the database table name and selection parameters for selecting the appropriate records and downloading them to the device.
Loading...
There was a problem loading this topic