Panatrack Ship Pack tables

Panatrack Ship Pack tables

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.

    • Related Articles

    • Shipping Support

      Configure PanatrackerGP's shipping support features to track shipping details and integrate with third-party shipping solutions. While PanatrackerGP does not have its own shipping module, it provides data tracking for Ship IDs, tracking numbers, and ...

    • Panatrack ParseData Function

      This is the source for the [Panatrack_ParseData]. /****** Object: UserDefinedFunction [dbo].[Panatrack_ParseData] Script Date: 8/8/2022 1:51:50 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE FUNCTION [dbo].[Panatrack_ParseData] ( ...

    • Implementing Panatrack - Overview

      This guide outlines the PanatrackerGP implementation process from planning through go-live. Planning Successful implementation starts with thorough planning: Project Setup — Panatrack creates a project and assigns a project lead, importing standard ...

    • Panatrack Support Policy

      Support Hours Panatrack offers phone and email support during regular business hours: Days — Monday through Friday Hours — 8:00 AM to 5:00 PM Central Time Holidays — Closed on United States holidays After-Hours — Planned installations, upgrades, or ...

    • Binary Stream Tables Not Installed Completely

      Error Messages Old message: The setting EnableBSMEM is on, but the table B3900400 does not exist for this company which is required to run Binary Stream integration. Updated message: Unable to access the tables required for Binary Stream (e.g., ...