History
Report Columns
-
Access Point / Block Reason
Reason for blocking the access point from warehouse operations.
-
Access Point / ID
Unique identifier for the access point.
-
Access Point / Is Blocked
Whether the access point is accessible.
Values:
0 = False
1 = True -
Access Point / Name
The name of the access point.
-
Batch Name
Name of the batch.
-
Bin Name
Name of the bin. Bins are usually named by size (08×04 or Medium) or by the materials they store.
-
Carrier Name
Name of the carrier.
-
Confirmed Quantity
Actual quantity of units processed, confirmed by the user.
-
Confirmed Quantity
(from
Order Line table)
Actual quantity of units processed, confirmed by the user.
-
Confirmed Value
Calculated value of actual quantity of units processed, confirmed by the user.
-
Cost Center
Name of the cost center.
-
Creation Date
Date and time the transaction record was created.
-
Creation Date
(from
Cost Center table)
Date and time cost center was created.
-
Deadline
(from
Order table)
Date by which the order must be completed.
-
Description
(from
Cost Center table)
Description of the cost center. This should indicate if it is recording where the picked orders are being used, or the accounting code being charged to.
-
Description
(from
Material Property table)
Description of the material family the material was assigned to, from a dropdown list or tree structure.
-
Deviated Quantity
The difference between the quantity of units requested and units actually processed, recorded by the user.
-
Deviated Quantity
(from
Order Line table)
The difference between the quantity of units requested and units actually processed, recorded by the user.
-
Deviated Value
Calculated value of the difference between the quantity of units requested and units actually processed, recorded by the user.
-
Direction Type
(from
Order table)
The type of order.
Values:
1 = Put
2 = Pick
3 = Return
4 = Transport
5 = Count
7 = Production -
Expiry Date
Used by a material property to track material expiry.
-
Export State
If the history record can be or has been exported.
Values:
0 = Not set
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 -
Handling Unit
The transport tote/container/cart used when processing the order or batch.
-
Handling Unit
(from
Order table)
The transport tote/container/cart used when processing the order or batch.
-
Host Identification
(from
Order Line table)
The identification sent from host system, specially by SAP. Will be written to history table to report it back to the host.
-
ID
Unique identifier of the history record.
-
ID
(from
Order table)
Unique identifier of the order.
-
ID
(from
Order Line table)
Unique identifier of the order line.
-
Info1
(from
Material table)
Information field 1 of the material.
-
Info1
(from
Order table)
Information field 1 of the order.
-
Info1
(from
Order Line table)
Information field 1 of the order line.
-
Info2
(from
Material table)
Information field 2 of the material.
-
Info2
(from
Order table)
Information field 2 of the order.
-
Info2
(from
Order Line table)
Information field 2 of the order line.
-
Info3
(from
Material table)
Information field 3 of the material.
-
Info3
(from
Order table)
Information field 3 of the order.
-
Info3
(from
Order Line table)
Information field 3 of the order line.
-
Info4
(from
Material table)
Information field 4 of the material.
-
Info4
(from
Order table)
Information field 4 of the order.
-
Info4
(from
Order Line table)
Information field 4 of the order line.
-
Info5
(from
Material table)
Information field 5 of the material.
-
Info5
(from
Order table)
Information field 5 of the order.
-
Info5
(from
Order Line table)
Information field 5 of the order line.
-
Job Number
Number of the job.
-
Line Number
The unique line number. If not provided, the system automatically generates a unique number for the order line.
-
Location Name
Name of the location.
-
Lot
Lot number used by a material property for tracking materials.
-
Lot
(from
Order Line table)
Lot number used by a material property for tracking materials.
-
Material Reference
Usually the name of the material, but can be a material code, kit, or handling unit name.
-
Motive Type
Reason order line was not fully completed.
Values:
0 = NotSet
1 = StockUnavailable
2 = Shortage
3 = SpaceUnavailable
4 = SpaceFull
5 = Deleted
6 = Canceled
7 = RoundUpOverstock
8 = ResolveMissingQty
9 = Trim
10 = CancelError -
Name
(from
Cost Center table)
Name of the cost center.
-
Name
(from
Material table)
Name of the material.
-
Name
(from
Order table)
Name of the order.
-
Name
(from
Order Line table)
Number of the order line.
-
Name
Number of the order line.
-
Order Name
Name of the order.
-
Owner
(from
Order Line table)
Used in a transfer order. The owner will be replaced by the given recipient, which will be assigned as the new owner of the material during the put.
-
Power Pick User
Username of the user who performed the task.
-
Priority
(from
Order table)
Order priority level. Default is 2.
Values:
1 = Low
2 = Medium
3 = High
4 = Hot -
Production Date
Used by a material property to track material production date.
-
Qualification
Used by a material property for tracking materials.
-
Qualification
(from
Order Line table)
Used by a material property for tracking materials.
-
Quantity
(from
Order Line table)
Quantity of the material in the order line.
-
Quantity Requested
Original quantity requested for the order.
-
Rank
Rank number of the order inside a batch. Must not be used for continuous batching.
-
Reason Code
Code to explain the reason for the motive type of the record.
-
Release Date
Used by a material property to track material release date.
-
Requested Quantity
(from
Order Line table)
Original quantity requested for the order.
-
Serial Number
Unique serial number, recorded at the item level when a material is add or retrieved.
-
Serial Number
(from
Order Line table)
Unique serial number, recorded at the item level when a material is add or retrieved.
-
Shelf Name
Name of the shelf.
-
Station
Name of the station.
-
Storage Unit Name
Name of the storage unit.
-
Task Number
Serialized number assigned to the task, when begun.
-
Total Quantity
Total quantity of materials in the order.
-
Type
Type of transaction.
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 -
Type
(from
Order table)
Order creation/origin type. Automatically determined.
Values:
0 = NotSet
1 = External
2 = ExtManaged
3 = Internal
4 = Manual
5 = Auto -
Type
(from
Cost Center table)
Cost center types are set in PPG's System Configuration. They can be optional or mandatory, and tracking info can be entered manually or selected from a drop-down list.
-
Upload Date
Date record was uploaded (not created) from external source.
-
Warehouse Name
Name of the warehouse.
-
X Step
Bin position on the tray on the x-axis.
-
Y Step
Bin position on the tray on the y-axis.
-
Zone Name
Name of the zone.