Importing WMS

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	Y N	1
Child Assignment	Flag to signify if the assignment will be part of a parent/child assignment.	No	Y N	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	Y N	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	Y N	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

Child pages

Importing WMS