PanatrackerGP SQL databases

There are generally two tables for each transaction in the PanatrackerGP database.  Those are typically the tables are clients want to report on. 
 
Adjustments (Add and Remove Inventory) are in the TrxAdjustment and TrxAdjustmentUnit tables.  The base table (TrxAdjustment) has one row for each transaction performed.  The line items are in the “Unit” table.  
 
To obtain a “flat view” of each transaction, the units can be joined to the base table in this manner:
select h.*, u.*

from TrxAdjustment h

join TrxAdjustmentUnit u

on u.TrxAdjustmentOid = h.oid

If you aren’t sure of your table name, just poke around and compare the results and match up the data to what’s in the portal.  PO Receipts are in TrxReceiving/TrxReceivingUnit.  Fulfill Order is in TrxFulfillOrder/TrxFulfillOrderUnit.  

Item Bin Moves and Put Aways are all in TrxMoveInvUnit (no header).  

We can create a report for you if you’d like (or just SQL for a View).  Then you would have a template.  It would require Professional Services, email support@panatrack.com to request a statement of work.