Customer Shipping Rule Import Format

A

1

All Locations

3

Yes/No

Yes

Enter Yes if the customer shipping rule is for all locations.

B

2

Ship-From Location

3

Character

No

If you enter No for the All Locations field, enter a valid location prefix for the customer shipping rule. For information on setting up locations, see Location Maintenance.

If you enter Yes for the All Locations field, leave this field blank.

C

3

All Customers

3

Yes/No

Yes

Enter Yes if the customer shipping rule is for all customers.

D

4

Customer Code

12

Character

No

If you enter No for the All Customers field, enter a valid customer code for the customer shipping rule. For information on setting up customers, see Customer Maintenance.

If you enter Yes for the All Customers field, leave this field blank.

E

5

All Ship-To Addresses

3

Yes/No

Yes

Enter Yes if the customer shipping rule is for all ship-to addresses.

F

6

Ship-To Address ID

4

Character

No

If you enter No for the All Ship-To Addresses field, enter a valid customer ship-to address ID for the customer shipping rule. For information on setting up customer ship-to address ID's, see Customer Maintenance.

If you enter Yes for the All Ship-To Addresses field, leave this field blank.

G

7

All ZIP Codes

3

Yes/No

Yes

Enter Yes if the customer shipping rule is for all ZIP codes.

H

8

Begin ZIP Code

10

Character

No

If you enter No for the All ZIP Codes field, enter the first ZIP code in a range of ZIP codes for the customer shipping rule.

If you enter Yes for the All ZIP Codes field, leave this field blank.

I

9

End ZIP Code

10

Character

No

If you enter No for the All ZIP Codes field, enter the last ZIP code in a range of ZIP codes for the customer shipping rule.

If you enter Yes for the All ZIP Codes field, leave this field blank.

J

10

Store Number

20

Character

No

Enter a valid customer store number for the customer shipping rule.

K

11

Preferred LTL Shipper

12

Character

Yes

Enter the preferred less than load (LTL) shipper for the customer shipping rule.

L

12

Preferred SPC Shipper

12

Character

Yes

Enter the preferred small package carrier (SPC) shipper for the customer shipping rule.

M

13

Weight Limit

10

>>>,>>9.99

Yes, only if you enter W or WC in the Use Weight/Carton field

Enter the small package carrier maximum weight for the customer shipping rule.

N

14

Weight Unit of Measure

8

Character

Yes, only if you enter W or WC in the Use Weight/Carton field

Enter the weight unit of measure code for the customer shipping rule.

O

15

Maximum Cartons

7

Integer

Yes, only if you enter C or WC in the Use Weight/Carton field

Enter the maximum number of cartons for the small package carrier for the customer shipping rule.

P

16

Use Weight/Carton

2

Character

Yes

Enter one of the following to specify weight and/or carton limits for the preferred SPC shipper for the customer shipping rule:

• W - Use weight limits only.

• C - Use carton limits only.

• WC - Use carton and weight limits.

Q

17

SPC Freight Terms

25

Character

Yes

Enter the freight collection terms code for SPC for the customer shipping rule. For information on setting up freight collection terms codes, see Freight Collection Terms Maintenance.

R

18

LTL Freight Terms

25

Character

Yes

Enter the freight collection terms code for LTL for the customer shipping rule. For information on setting up freight collection terms codes, see Freight Collection Terms Maintenance.

S

19

Freight Free Amount

9

>>,>>9.99

No

Enter the freight free order amount for the customer shipping rule.

T

20

Shipping Method

6

Character

No

Enter one of the following shipping methods for the shipping rule:

• Air

• Ground