Shipper Rate Import Format

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

The following table lists the format for importing a record in Shipper Rate 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 rate. For information on setting up 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 rate is for a specific shipper, enter a valid shipper ID for the shipper rate. For information on setting up shipper ID's, see Shipper Maintenance.

C

3

Shipper Zone

20

Character

Yes

Enter a valid shipper zone for the shipper rate. For information on setting up shipper zones, see Shipper Zone Maintenance.

D

4

Upper Weight or Volume Limit

12

>>>,>>9.9999

Yes, only if Weight or Volume is entered for the Limit Type field.

If the shipper rate has an upper weight or volume limit, enter the upper weight or volume limit.

Note This is the maximum weight or volume that the selected shipper/shipping method accepts for shipments from the selected location to the selected shipper zone.

E

5

Shipping Charge

14

>>>,>>>,>>9.99

Yes

Enter a shipping charge for the shipper rate. This is the charge associated with each upper weight/volume/amount limit set for the selected shipper ID, shipping zone, and location. This charge uses the calculation method formula defined for each existing shipper ID in Shipper Maintenance. For more information on calculation methods, see Freight Maintenance Overview. The currency for the shipping charge defaults from the location's default currency.

F

6

Limit Type

6

Character

No

Enter a value to specify whether the shipper rate limit is by weight, volume, or monetary amount. You must use one of the following values: Weight, Volume, or Amount.

If this field is blank, it defaults to Weight.

G

7

Start Date

10

99/99/9999

Yes

Enter the first date in a range of effective dates for the shipper rate.

H

8

End Date

10

99/99/9999

Yes

Enter the last date in a range of effective dates for the shipper rate.

I

9

Shipping Method

6

Character

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

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

J

10

Record Type

15

Character

No

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

If this field is blank, it defaults to Shipper.

K

11

Upper Amount Limit

12

>>>,>>9.9999

Yes, only if Amount is entered for the Limit Type field.

If the shipper rate has an upper monetary amount limit, enter the upper monetary amount limit.

L

12

Charge Type

12

Character

Yes

Enter a valid freight charge type for the shipper rate. For information on setting up charge types, see Order Entry Additional Charge Maintenance.

M

13

Amount Includes VAT

3

Yes/No

No

Enter Yes or Y if the amount entered for the Upper Amount Limit field includes VAT. If this field is blank, it defaults to No and indicates the amount entered for the Upper Amount Limit field does not include VAT.

N

14

Charge Includes VAT

3

Yes/No

No

Enter Yes or Y if the shipping charge amount entered in the Shipping Charge field includes VAT. If this field is blank, it defaults to No and indicates the amount for the Shipping Charge field does not include VAT.

O

15

Shipping Charge Currency

8

Character

No

Enter a valid currency for the shipping charge entered in the Shipping Charge field (position 5). If this field is blank, it defaults to the location currency. For information on creating currencies, see Currency Maintenance.

Prerequisites

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

Import Format Notes