Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Data Element

Naming Convention

Naming Convention Example

Comment

Facility

FAC

DC1

Facility ID must match EXACTLY what is configured in ProTrack Warehouse and being sent in the WMS extraction file.

Floor

FAC-FLR

DC1-FLR1

 

Aisle Path

FAC-FLR-AISLE

DC1-FLR1-04A

When two or more Aisle Paths are needed for a single rack (i.e. due to a non-passable barriers such as a security cage fence), append lowercase letters to the AISLE element.

Segment

FAC-FLR-AISLE-1

DC1-FLR1-04A-1

The '-1' suffix increments ('-2', '-3', etc.) with additional Segments on a single Aisle Path.

Location

FAC-LOC

DC1-032457

Must match the 'To Location' field EXACTLY being sent in the WMS extraction file.

Travel Path

FAC-FLR1-FLR2-1

DC1-FLR1-FLR2-1

 

Table 3537. Naming Conventions


Anchor
FLR
FLR

...

Floor ID

Floor Name

Description

Start X

Start Y

End X

End Y

Width

Facility ID

1-FLR1

1-FLR1

Chicago - First floor

4000

2500

8000

5000

4000

1

2-FLR1

2-FLR1

Joliet - First floor

2000

2000

6600

5000

4600

2

Table 3638. Floor Example

Info
titleInfo
  • Commas ( , ) are not allowed in description fields for any .csv import file, as ProTrack Warehouse will treat the comma as a field separator and the file will error out.

...

Field

Description

Floor Name

Name of the floor.

Start X

X value of the start co-ordinate of the floor.

Start Y

Y value of the start co-ordinate of the floor.

End X

X value of the end co-ordinate of the floor. This value should be equal to start X.

End Y

Y value of the end co-ordinate of the floor.

Height

This is for future development, and thus not currently available in this version of ProTrack Warehouse.

Width

Width of the floor.

Description

Description of the floor.

Table 3739. Floor Field Descriptions

...

Aisle ID

Aisle Name

Start X

Start Y

End X

End Y

Floor ID

Numbering Direction

Numbering Scheme

Travel Rule

path_access_rule

1-FLR1-100

1-FLR1-100

4200

2800

4300

2800

1-FLR1

ALT_LR_ES

DUB_INC

DIRECT

BD

1-FLR1-101

1-FLR1-101

4200

3000

4300

3000

1-FLR1

ALT_LR_ES

DUB_INC

DIRECT

BD

1-FLR1-102

1-FLR1-102

4200

2800

4200

3000

1-FLR1

ALT_LR_ES

DUB_INC

DIRECT

BD

1-FLR1-103

1-FLR1-103

4250

2800

4250

3000

1-FLR1

ALT_LR_ES

DUB_INC

DIRECT

BD

1-FLR1-104

1-FLR1-104

4300

2800

4300

2900

1-FLR1

ALT_LR_ES

DUB_INC

DIRECT

BD

1-FLR1-104a

1-FLR1-104a

4300

2910

4300

3000

1-FLR1

ALT_LR_ES

DUB_INC

DIRECT

BD

Table 3840. Aisle Path Examples

Field

Description

Path ID

ID of the aisle path.

Path Name

Name of the aisle path.

Start X

X value of the start co-ordinate of the aisle path.

Start Y

Y value of the start co-ordinate of the aisle path.

End X

X value of the end co-ordinate of the aisle path.

End Y

Y value of the end co-ordinate of the aisle path.

Numbering Direction

This is for future development, and thus not currently available in this version of ProTrack Warehouse. This is a mandatory field, so populate with the default value from the table above.

Numbering Scheme

This is for future development, and thus not currently available in this version of ProTrack Warehouse. This is a mandatory field, so populate with the default value from the table above.

Travel Rule

This is for future development, and thus not currently available in this version of ProTrack Warehouse. This is a mandatory field, so populate with the default value from the table above.

path_access_rule

This is for future development, and thus not currently available in this version of ProTrack Warehouse. This is a mandatory field, so populate with the default value from the table above.

Table 3941. Aisle Path Field Descriptions

...

travel_id

travel_name

description

start_X

start_Y

end_X

end_Y

end_ floor_id

begin_floor_id

barrier

path_access_rule

width

DC1-1-2-A

DC1-1-2-A

south stairs

1005

2050

1006

2050

FLR2

FLR1

N

BD

0

DC1-1-2-B

DC1-1-2-B

east stairs

1500

1910

1500

1911

FLR2

FLR1

N

BD

0

DC1-2-3-A

DC1-2-3-A

service elev

1005

2050

1006

2050

FLR3

FLR2

N

BD

0

Table 4042. Travel Path Examples

Field

Description

Travel Path ID

ID of the Travel Path.

Travel Path Name

Name of the Travel Path.

Description

Description of the Travel Path.

Start X

X value of the start coordinate of the Travel Path.

Start Y

Y value of the start co-ordinate of the Travel Path.

End X

X value of the end co-ordinate of the Travel Path.

End Y

Y value of the end co-ordinate of the Travel Path.

End Floor Id

Floor ID corresponding to the node at the X,Y coordinate specified in the End X and End Y fields.

Begin Floor Id

Floor ID corresponding to the node at the X,Y coordinate specified in the Start X and Start Y fields.

Barrier

This is for future development, and thus not currently available in this version of ProTrack Warehouse. This is a mandatory field, so populate with the default value from the table above.

Path Access Rule

This is for future development, and thus not currently available in this version of ProTrack Warehouse. This is a mandatory field, so populate with the default value from the table above.

Width

This is for future development, and thus not currently available in this version of ProTrack Warehouse.This is a mandatory field, so populate with the default value from the table above.

Table 4143. Travel Path Field Descriptions

...

Segment ID

Segment Name

Inset

Offset

Length

Width

Orientation

Bay_Count

Number_Scheme

Number_Direction

Aisle_ID

Floor_ID

1-FLR1-100-A

1-FLR1-100-A

1

-2

98

4

Left

0

DUB_INC

ALT_LR_ES

1-FLR1-100

FLR1

1-FLR1-104-A

1-FLR1-104-A

1

-2

98

4

Left

0

DUB_INC

ALT_LR_ES

1-FLR1-104

FLR1

1-FLR1-104a-A

1-FLR1-104a-A

111

-2

88

4

Left

0

DUB_INC

ALT_LR_ES

1-FLR1-104a

FLR1

Table 4244. Segment Examples

Field

Description

Segment ID

ID of the segment.

Segment Name

Name of the segment.

Aisle Name

Name of the aisle path to which the segment is associated.

Inset

Distance from the aisle starting point to the segment.

Offset

Distance from aisle axis to the segment.

Width

Width of the segment.

Length

Length of the segment.

Numbering Scheme

This is for future development, and thus not currently available in this version of ProTrack Warehouse. This is a mandatory field, so populate with the default value from the table above.

Numbering Direction

This is for future development, and thus not currently available in this version of ProTrack Warehouse. This is a mandatory field, so populate with the default value in from the table above.

Start Bay Number

This is for future development, and thus not currently available in this version of ProTrack Warehouse. This is a mandatory field, so populate with the default value from the table above.

Number of Bays

This is for future development, and thus not currently available in this version of ProTrack Warehouse. This is a mandatory field, so populate with the default value from the table above.

Orientation

Orientation of the Segment as it relates to the Aisle Path.

Description

Description of the segment.

Table 4345. Segment Field Descriptions

...

Location ID

Location Name

X

Y

Floor ID

Segment ID

Level Specifier

Level Height

1-loc1

1-loc1

4205

2800

FLR1

1-FLR1-100-A

1-loc2

1-loc2

4220

2800

FLR1

1-FLR1-104-A

1-loc3

1-loc3

4200

2900

FLR1

1-FLR1-104a-A

Table 4446. Location Examples

Field

Description

Name & ID

Must match.

X

X co-ordinate of the location.

Y

Y co-ordinate of the location.

Floor ID

Must match the Floor ID that is configured in ProTrack Warehouse.

Level Specifier

This is the To Location Level ID. Must match exactly what is being sent in the WMS extraction file. Each Level Specifier is separated by the pipe symbol .

Level Height

This is the distance from the floor in inches for vertical travel. Must match exactly what is being sent in the WMS extraction file. Each Level Height is separated by the pipe symbol .

Table 4547. Location Field Descriptions

...