NOTE For general information on using imports, see Imports FAQ.
The following table lists the format for importing a record in Postal Code Import.
Column |
Position |
Field |
Maximum Length |
Format |
Required |
Description |
A |
1 |
Country |
10 |
Character |
Yes |
Enter a valid country code for the postal code. For information on setting up country codes, see Country Maintenance. |
B |
2 |
Postal Code |
11 |
Character |
Yes |
Enter the postal code. The format of the postal code is set up for the country in Country Maintenance, and can optionally be set up to be validated. For information on setting up postal codes, see Postal Code Maintenance. |
C |
3 |
City |
40 |
Character |
Yes |
Enter the city associated with the postal code. |
D |
4 |
County |
36 |
Character |
No |
Enter the county associated with the postal code. |
E |
5 |
State/Province |
3 |
Character |
Yes |
Enter a valid state or province code for the postal code. For information on setting up state and province codes, see State and Province Maintenance. |
F |
6 |
Free Field 1 |
20 |
Character |
No |
Enter any data that you want to associate with the postal code. This is an optional free field that can be used to store data in the postal code record for later retrieval. |
G |
7 |
Free Field 2 |
20 |
Character |
No |
Enter any data that you want to associate with the postal code. This is an optional free field that can be used to store data in the postal code record for later retrieval. |
H |
8 |
Free Field 3 |
20 |
Character |
No |
Enter any data that you want to associate with the postal code. This is an optional free field that can be used to store data in the postal code record for later retrieval. |
I |
9 |
Free Field 4 |
20 |
Character |
No |
Enter any data that you want to associate with the postal code. This is an optional free field that can be used to store data in the postal code record for later retrieval. |
J |
10 |
Free Field 5 |
20 |
Character |
No |
Enter any data that you want to associate with the postal code. This is an optional free field that can be used to store data in the postal code record for later retrieval. |
K |
11 |
Free Field 6 |
20 |
Character |
No |
Enter any data that you want to associate with the postal code. This is an optional free field that can be used to store data in the postal code record for later retrieval. |
Before using this import, the following must be set up:
countries
states\provinces
This import creates records in the postal-code table.