Shipper Zone Import Format

NOTE For general information on using imports, see Imports FAQ.

The following table lists the format for importing a record in Shipper Zone Import.

Column

Position

Field

Maximum Length

Format

Required

Description

A

1

Location Prefix

3

Character

Yes

Enter a valid location prefix of the warehouse shipping location for the shipper zone. For information on setting up valid location prefixes, see Location Maintenance.

B

2

Shipper ID

12

Character

Yes, only if Shipper is entered for the Record Type field

If the shipper zone is for a specific shipper, enter a valid shipper ID for the shipper zone. For information on setting up valid shipper ID's, see Shipper Maintenance.

C

3

Beginning ZIP Code

10

Character

Yes

Enter the first ZIP code in a range of ZIP codes for the shipper zone. This field should be unformatted if you are using ZIP code masks. You must enter a ZIP code that is less than the ZIP code entered for the Ending ZIP Code field.

D

4

Ending ZIP Code

10

Character

Yes

Enter the last ZIP code in a range of ZIP codes for the shipper zone. This field should be unformatted if you are using ZIP code masks. You must enter a ZIP code that is greater than the ZIP code entered for the Beginning ZIP Code field.

E

5

Shipper Zone

20

Character

Yes

Enter the name for the shipper zone.

F

6

Shipping Method

6

Character

Yes, only if Shipping Method is entered for the Record Type field

If the shipper zone is for a specific shipping method, enter the shipping method. You must use one of the following values: Air or Ground.

G

7

Record Type

16

Character

No

Enter a value to specify if the shipper zone is for a specific shipper or shipping method. You must enter one of the following values: Shipper or Shipping Method.

If this field is blank, it defaults to Shipper.

Prerequisites

Before using this import, the following must be set up:

Import Format Notes

Note The ZIP code range for a shipper zone cannot overlap the range for any existing zones for the specified location prefix / shipper ID. Zone names cannot be duplicated for a specific location prefix / shipper ID.