Transactions

The data from /api/transactions is coming from the History table in MSSQL, and is available in the history list in PowerPick.

This data is PowerPick's internal record of transactions, which you can view in the History List (in PowerPick). This generates records of every Pick, Put, Count and other types of transactions, broken down by order, order line, lot, serial, and other breakdowns. It's a raw listing of all that's happening at the storage level.

Attributes

• id uuid

  A unique ID for this transaction.

• batchName string

  Name of the batch this order is a part of, if any.

• binName string

  The bin where this transaction occurred. Bins are usually named by size (08×04 or Medium) or by the materials they store.

• carrierName string

  The carrier where this transaction occurred.

• creationDate datetime

  Date and time the transaction record was created.

• directionType integer

  The type of order.

  Possible values:

  1 = Put
  2 = Pick
  3 = Return
  4 = Transport
  5 = Count
  7 = Production

• expiryDate datetime

  Used by a material property to track material expiry.

• exportStateType integer

  Used by external systems (including Data Push) to flag whether the transaction record has been exported.

  Possible values:

  0 = NotSet
  1 = Cannot yet be exported
  2 = Ready to export
  3 = Currently exporting or export canceled
  4 = Successfully exported
  5 = Export failed
  6 = Not to be exported

• handlingUnit string

  The transport tote/container/cart used when processing the order or batch. Deprecated.

• locationName string

  The location where this transaction occurred.

• lot string

  The lot number of this transaction, if applicable.

• materialName

  Usually the name of the material, but can be a material code, kit, or handling unit name.

• motiveType integer

  Reason order was not fully completed.

  Possible values:

  0 = NotSet
  1 = StockUnavailable
  2 = Shortage
  3 = SpaceUnavailable
  4 = SpaceFull
  5 = Deleted
  6 = Canceled
  7 = RoundUpOverstock
  8 = ResolveMissingQty
  9 = Trim
  10 = CancelError

• number integer

  The internal number of this transaction record.

• orderId uuid

  The ID of the order this transaction belongs to.

• orderLineId uuid

  The ID of the order line this transaction belongs to.

• orderName

  The name of the order this transaction belongs to.

• productionDate datetime

  Used by a material property to track material production date.

• qualification integer

  Used by a material property for tracking materials.

• quantityConfirmed float

  Actual quantity of units processed, confirmed by the user.

• quantityDeviated float

  The difference between the quantity of units requested and units actually processed, recorded by the user.

• quantityRequested float

  Original quantity requested for the order.

• quantityTotal float

  The total quantity that was in stock when this transaction was completed.

• reasonCode integer

  Code to explain the reason for the motive type of the record.

• releaseDate datetime

  Used by a material property to track material release date.

• serialNumber integer

  The serial number of this transaction, if applicable.

• shelfName string

  The shelf where this transaction occurred.

• storageUnitName string

  Name of the storage unit.

• taskNumber integer

  The task number of this transaction, if applicable.

• type integer

  Type of transaction.

  Possible values:

  0 = NotSet
  1 = ManualPut
  2 = ManualPick
  3 = OrderPut
  4 = OrderPick
  5 = Transfer
  6 = OrderCount
  7 = ContextCount
  8 = MaterialRename
  9 = ManualCorrection
  10 = ContextCorrection
  11 = CancelRequest
  12 = Purge
  13 = Production
  15 = KitRename

• uploadDate datetime

  Date record was uploaded (not created) from external source.

• userName string

  The user who created this transaction.

• warehouseName string

  The warehouse where this transaction occurred.

• xStep integer

  Bin position on the tray on the x-axis.

• yStep integer

  Bin position on the tray on the y-axis.

• [dynamicField] string

  Any of the dynamic order fields from PowerPick. Requires ItemPath's Custom Fields app.