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
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 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
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