The Panatracker solution includes tables that integrate with Starship to provide information about sales order shipments.
Information for shipping containers is captured in one of two Panatracker transactions: Fulfill Order and Verify Order. Either transaction can call our “PopulateShipPack” stored procedure. This stored procedure will populate three tables in the GP company database:
- ShipPackHeader
- ShipPackContainer
- ShipPackSOPLine
The Header table contains the User Name, Device Name, and time of the pick. The Container table provides the Container IDs for the shipment. The SOPLine table provides the line item information for each GP Item picked, including the quantity, the lot number/serial number, and Unit of Measure and associate that with the Container ID.
An optional feature of the Ship Pack tables is a “Container Type”, identified by the prefix on the Container ID. The Container Type allows you to assign a specific name, dimension, and weight for the container.
Some Panatrack clients have integrated this data with shipping solutions other than Starship.