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. |
Before using this import, the following must be set up:
suppliers
countries