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. |
Before using this import, the following must be set up:
locations
This import creates records in the oe-shipper-zones table.
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.