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