Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Corrected links that should have been relative instead of absolute.

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