Supplier Address Import Format

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

The following table lists the format for importing a record in Supplier Address Import.

Column

Position

Field

Maximum Length

Format

Required

Description

A

1

Supplier Code

15

Character

Yes

Enter a valid supplier code for the address. For information on setting up supplier codes, see Supplier Maintenance.

B

2

Address Type

9

Character

Yes

Enter Remit-To or Ship-From as the address type.

C

3

Address Name

30

Character

Yes, only if importing a ship-from address, or if remit-to address name changes are allowed

Enter a name for the supplier's address.

D

4

Address Line 1

60

Character

Yes

Enter the first line of the supplier's address.

E

5

Address Line 2

60

Character

No

Enter the second line of the supplier's address.

F

6

Address Line 3

60

Character

No

Enter the third line of the supplier's address.

G

7

City

40

Character

Yes

Enter the city of the supplier's address.

H

8

State/Province

3

Character

Yes, only if a state or province is required for the country of the address

Enter a valid state or province of the supplier's address.

I

9

Postal Code

11

Character

Yes, only if a postal code is required for the country of the address

Enter the postal code of the supplier's address. 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.

J

10

Country

10

Character

Yes

Enter a valid country code for the supplier's address. For information on setting up countries, see Country Maintenance.

K

11

Phone Number

16

Character

No

Enter the phone number of the supplier's address. The format of the telephone number is set up in Country Maintenance.

L

12

Primary Address

3

Yes/No

No

Enter Yes if the address is the primary remit-to or ship-from address for the supplier.

Enter No if the address is not the primary remit-to or ship-from address for the supplier.

If this field is blank, it defaults to No.

M

13

VAT ID

30

Character

No

Enter a VAT identification number for the supplier's ship-from address.

Note Leave this field blank if you are importing a remit-to address.

N

14

VAT Supplier Code

15

Character

No

Enter a VAT supplier code for the supplier's ship-from address.

Note Leave this field blank if you are importing a remit-to address.

O

15

Excise ID

30

Character

No

Enter the excise tax ID for the supplier's ship-from address if the address is a tax warehouse.

P

16

Consent Provided

3

Yes/No

No

Enter Yes if the data subjects have provided consents to use their personal data.

Q

17

Consent Attached

3

Yes/No

No

Enter Yes if the data subjects' consents to use their personal data are attached using the standard attachment function in Supplier Maintenance.

R

18

Consent Date

10

99/99/9999

No

Enter the date on which the data subjects, that is, the suppliers, provided the consents to use their personal data.

Prerequisites

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