Documentation for ProTrackWarehouse 2017.1.
Below are the listed details that can be imported to ProTrack Warehouse. Each detail has a description, if the detail is mandatory for import or not, accepted field values, and maximum acceptable character length.
WMS Detail Descriptions
Detail | Description | Mandatory | Field Values | Max. Character Length |
|---|---|---|---|---|
Assignment ID | IDs must be unique for assignments worked by the same employee on the same date. | Yes | Alphanumeric | 100 |
Activity ID | Activity ID of the assignment. Must match an existing activity ID. | Yes | Alphanumeric | 20 |
Facility ID | Facility ID where the assignment took place. Must match an existing facility ID. | Yes | Alphanumeric | 20 |
Adjustment | Updates KVI counts to assignments with matching assignment IDs. | No |
| 1 |
Child Assignment | Flag to signify if the assignment will be part of a parent/child assignment. | No |
| 1 |
Consignee | Currently not used, will be implemented in future developments. | No | Alphanumeric | 40 |
Container ID | ID of the container the assignment will belong to. | No | Alphanumeric | 20 |
Container Type | Type of container units will be placed in. | No | Alphanumeric | 40 |
Customer | Name of customer that ordered the units. | No | Alphanumeric | 40 |
Drop Location | Location that will be used when re-trip is triggered. Must match an existing location. | No | Alphanumeric | 40 |
Employee ID | ID of the employee that worked the assignment. Only required for post downloaded assignments. Must match an existing employee ID. | No | Alphanumeric | 20 |
End Time | Time when the assignment was ended. | No | Datetime | HHmmss |
End Date | Date when the assignment was ended. | No | Datetime | MMddyyyy |
End Location | Last location the employee visited in an assignment. Must match an existing location. | No | Alphanumeric | 40 |
Equipment ID | ID of the equipment the employee used while working assignments. This will override the default equipment assigned to the standard. | No | Alphanumeric | 20 |
From Location | Previous location the employee visited. Must match an existing location. | No | Alphanumeric | 40 |
Inner Pack | Unit of measurement used for configuring standards. | No | Numeric | Integer |
Master Pack | Unit of measurement used for configuring standards. | No | Numeric | Integer |
Microzone ID | Microzone ID where the assignment was worked. Must match an existing microzone ID. | No | Alphanumeric | 20 |
Number of Cases | Number of cases worked each task line. | No | Numeric | Integer |
Number of Pallets | Number of pallets worked each task line. | No | Numeric | Integer |
| Number of Kits | Number of kits worked in a manufacturing work order. | No | Numeric | Integer |
| Number of Totes | Number of totes worked in a manufacturing work order. | No | Numeric | Integer |
| Number of Components | Number of components worked in a manufacturing work order. | No | Numeric | Integer |
Pallet Retrip | Flag to signify if a re-trip is required in an assignment. | No |
| 1 |
Planned Time | Time when the assignment was planned to be worked. | No | Datetime | HHmmss |
Planned Date | Date when the assignment was planned to be worked. | No | Datetime | MMddyyyy |
Quantity | Number of units worked each task line. | No | Numeric | Integer |
Reverse Pick Flag | Currently not used, will be implemented in future developments. | No |
| 1 |
Reverse Pick Quantity | Currently not used, will be implemented in future developments. | No | Numeric | Integer |
SKU | SKU number of unit picked. | No | Alphanumeric | 20 |
Source Level ID | Previous level ID the employee visited at a location. Must match an existing level ID of a location. | No | Alphanumeric | 20 |
Start Location | First location the employee visited in an assignment. Must match an existing location. | No | Alphanumeric | 40 |
Start Date | Date when the assignment was started. | No | Datetime | MMddyyyy |
Start Time | Time when the assignment was started. | No | Datetime | HHmmss |
Stop | Specify which stop sequence in the shipping route the assignment belongs to. | No | Numeric | Integer |
Task Line Number | Number of each task line worked within the same assignment ID. Must begin with task line number 1. | No | Numeric | Integer |
To Location | Next location the employee visited. Must match an existing location. | No | Alphanumeric | 40 |
To Level ID | Next level ID the employee visited at a location. Must match an existing level ID of a location. | No | Alphanumeric | 20 |
Unit Cube | Cube of unit(s) picked at each task line. Value can be up to 15 numbers to the left of the decimal followed by four numbers to the right of the decimal. | No | Numeric | i.e. 100000000000000.0001 |
Unit Weight | Weight of unit(s) picked at each task line. Value can be up to 15 numbers to the left of the decimal followed by four numbers to the right of the decimal. | No | Numeric | i.e. 100000000000000.0001 |
UOM | Specify the unit of measurement each task line. | No | * | |
User Defined Alphanumeric1 | User defined field 1. | No | Alphanumeric | 20 |
User Defined Alphanumeric2 | User defined field 2. | No | Alphanumeric | 20 |
User Defined Alphanumeric3 | User defined field 3. | No | Alphanumeric | 20 |
User Defined Alphanumeric4 | User defined field 4. | No | Alphanumeric | 20 |
User Defined Alphanumeric5 | User defined field 5. | No | Alphanumeric | 20 |
User Defined Alphanumeric6 | User defined field 6. | No | Alphanumeric | 20 |
User Defined Alphanumeric7 | User defined field 7. | No | Alphanumeric | 20 |
User Defined Alphanumeric8 | User defined field 8. | No | Alphanumeric | 20 |
User Defined Alphanumeric9 | User defined field 9. | No | Alphanumeric | 20 |
User Defined Alphanumeric10 | User defined field 10. | No | Alphanumeric | 20 |
User Defined Alphanumeric11 | User defined field 11. | No | Alphanumeric | 20 |
User Defined Alphanumeric12 | User defined field 12. | No | Alphanumeric | 20 |
User Defined Alphanumeric13 | User defined field 13. | No | Alphanumeric | 20 |
User Defined Alphanumeric14 | User defined field 14. | No | Alphanumeric | 20 |
User Defined Alphanumeric15 | User defined field 15. | No | Alphanumeric | 20 |
User Defined Alphanumeric16 | User defined field 16. | No | Alphanumeric | 20 |
User Defined Alphanumeric17 | User defined field 17. | No | Alphanumeric | 20 |
User Defined Alphanumeric18 | User defined field 18. | No | Alphanumeric | 20 |
User Defined Alphanumeric19 | User defined field 19. | No | Alphanumeric | 20 |
User Defined Alphanumeric20 | User defined field 20. | No | Alphanumeric | 20 |
| User Defined Alphanumeric21 | User defined field 21. | No | Alphanumeric | 20 |
| User Defined Alphanumeric22 | User defined field 22. | No | Alphanumeric | 20 |
| User Defined Alphanumeric23 | User defined field 23. | No | Alphanumeric | 20 |
| User Defined Alphanumeric24 | User defined field 24. | No | Alphanumeric | 20 |
| User Defined Alphanumeric25 | User defined field 25. | No | Alphanumeric | 20 |
| User Defined Alphanumeric26 | User defined field 26. | No | Alphanumeric | 20 |
| User Defined Alphanumeric27 | User defined field 27. | No | Alphanumeric | 20 |
| User Defined Alphanumeric28 | User defined field 28. | No | Alphanumeric | 20 |
| User Defined Alphanumeric29 | User defined field 29. | No | Alphanumeric | 20 |
| User Defined Alphanumeric30 | User defined field 30. | No | Alphanumeric | 20 |
| User Defined Alphanumeric31 | User defined field 31. | No | Alphanumeric | 20 |
| User Defined Alphanumeric32 | User defined field 32. | No | Alphanumeric | 20 |
| User Defined Alphanumeric33 | User defined field 33. | No | Alphanumeric | 20 |
| User Defined Alphanumeric34 | User defined field 34. | No | Alphanumeric | 20 |
| User Defined Alphanumeric35 | User defined field 35. | No | Alphanumeric | 20 |
| User Defined Alphanumeric36 | User defined field 36. | No | Alphanumeric | 20 |
| User Defined Alphanumeric37 | User defined field 37. | No | Alphanumeric | 20 |
| User Defined Alphanumeric38 | User defined field 38. | No | Alphanumeric | 20 |
| User Defined Alphanumeric39 | User defined field 39. | No | Alphanumeric | 20 |
| User Defined Alphanumeric40 | User defined field 40. | No | Alphanumeric | 20 |
| User Defined Alphanumeric41 | User defined field 41. | No | Alphanumeric | 20 |
| User Defined Alphanumeric42 | User defined field 42. | No | Alphanumeric | 20 |
| User Defined Alphanumeric43 | User defined field 43. | No | Alphanumeric | 20 |
| User Defined Alphanumeric44 | User defined field 44. | No | Alphanumeric | 20 |
| User Defined Alphanumeric45 | User defined field 45. | No | Alphanumeric | 20 |
| User Defined Alphanumeric46 | User defined field 46. | No | Alphanumeric | 20 |
| User Defined Alphanumeric47 | User defined field 47. | No | Alphanumeric | 20 |
| User Defined Alphanumeric48 | User defined field 48. | No | Alphanumeric | 20 |
| User Defined Alphanumeric49 | User defined field 49. | No | Alphanumeric | 20 |
| User Defined Alphanumeric50 | User defined field 50. | No | Alphanumeric | 20 |
User Defined Numeric1 | User defined field 1. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
User Defined Numeric2 | User defined field 2. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
User Defined Numeric3 | User defined field 3. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
User Defined Numeric4 | User defined field 4. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
User Defined Numeric5 | User defined field 5. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
User Defined Numeric6 | User defined field 6. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
User Defined Numeric7 | User defined field 7. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
User Defined Numeric8 | User defined field 8. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
User Defined Numeric9 | User defined field 9. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
User Defined Numeric10 | User defined field 10. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
User Defined Numeric11 | User defined field 11. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
User Defined Numeric12 | User defined field 12. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
User Defined Numeric13 | User defined field 13. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
User Defined Numeric14 | User defined field 14. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
User Defined Numeric15 | User defined field 15. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
User Defined Numeric16 | User defined field 16. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
User Defined Numeric17 | User defined field 17. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
User Defined Numeric18 | User defined field 18. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
User Defined Numeric19 | User defined field 19. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
User Defined Numeric20 | User defined field 20. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric21 | User defined field 21. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric22 | User defined field 22. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric23 | User defined field 23. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric24 | User defined field 24. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric25 | User defined field 25. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric26 | User defined field 26. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric27 | User defined field 27. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric28 | User defined field 28. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric29 | User defined field 29. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric30 | User defined field 30. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric31 | User defined field 31. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric32 | User defined field 32. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric33 | User defined field 33. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric34 | User defined field 34. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric35 | User defined field 35. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric36 | User defined field 36. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric37 | User defined field 37. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric38 | User defined field 38. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric39 | User defined field 39. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric40 | User defined field 40. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric41 | User defined field 41. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric42 | User defined field 42. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric43 | User defined field 43. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric44 | User defined field 44. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric45 | User defined field 45. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric46 | User defined field 46. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric47 | User defined field 47. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric48 | User defined field 48. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric49 | User defined field 49. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| User Defined Numeric50 | User defined field 50. Value can be up to ten numbers to the left of the decimal followed by two numbers to the right of the decimal. | No | Numeric | i.e. 1000000000.01 |
| Family User Defined Field1 | User defined field 1. Values tied to this field can be used for manufacturing reporting purposes. | No | Alphanumeric | 40 |
| Family User Defined Field2 | User defined field 2. Values tied to this field can be used for manufacturing reporting purposes. | No | Alphanumeric | 50 |
| Family User Defined Field3 | User defined field 3. Values tied to this field can be used for manufacturing reporting purposes. | No | Alphanumeric | 50 |
| Family User Defined Field4 | User defined field 4. Values tied to this field can be used for manufacturing reporting purposes. | No | Alphanumeric | 50 |
| Family User Defined Field5 | User defined field 5. Values tied to this field can be used for manufacturing reporting purposes. | No | Alphanumeric | 50 |
| Family User Defined Field6 | User defined field 6. Values tied to this field can be used for manufacturing reporting purposes. | No | Alphanumeric | 50 |
| Family User Defined Field7 | User defined field 7. Values tied to this field can be used for manufacturing reporting purposes. | No | Alphanumeric | 50 |
| Family User Defined Field8 | User defined field 8. Values tied to this field can be used for manufacturing reporting purposes. | No | Alphanumeric | 50 |
| Family User Defined Field9 | User defined field 9. Values tied to this field can be used for manufacturing reporting purposes. | No | Alphanumeric | 50 |
| Family User Defined Field10 | User defined field 10. Values tied to this field can be used for manufacturing reporting purposes. | No | Alphanumeric | 50 |
Wave Number | Specify which wave the assignment belongs to. | No | Numeric | Integer |
Zone ID | Zone ID where the assignment was worked. Must match an existing zone ID. | No | Alphanumeric | 20 |
Overview
Content Tools
Copyright © 2015 - present. TZA Confidential. All rights reserved.