Postal Code Import Format

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.

Prerequisites

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

Import Format Notes