The data file to import Suppliers must consist of thirty-six (36) comma separated columns. The columns must be in the following order:
Column |
Field |
Required/Optional |
Description |
1 |
Supplier Name |
Required |
The supplier name must not exist in Pinnacle yet. |
2 |
SAP Vendor Number |
Required |
The SAP Vendor Number must not exist in Pinnacle yet. |
3 |
Address |
Optional |
|
4 |
Post Code |
Optional |
|
5 |
Phone Number B/H |
Optional |
|
6 |
Phone Number B/H Preferred |
Optional |
|
7 |
Phone No A/H |
Optional |
|
8 |
Phone No A/H Preferred |
Optional |
|
9 |
Fax Number |
Optional |
|
10 |
Fax Number B/H Preferred |
Optional |
|
11 |
E-mail Address |
Optional |
|
12 |
E-mail Address B/H Preferred |
Optional |
|
13 |
SMS No |
Optional |
|
14 |
SMS No B/H Preferred |
Optional |
|
15 |
Comments |
Optional |
|
16 |
Tax Registered |
Optional |
The value for this field must be 'Y' for Yes, or 'N' for No. This will default to 'N' if no value is supplied. |
17 |
A.C.N. |
Optional |
|
18 |
A.B.N. |
Optional |
If the Tax Registered column is set to 'Y', this field must not be blank. |
19 |
Contact |
Optional |
|
20 |
Payee Name |
Optional |
|
21 |
Payee Address |
Optional |
|
22 |
Payee Post Code |
Optional |
|
23 |
Sunday Open |
Required |
|
24 |
Sunday Close |
Required |
|
25 |
Monday Open |
Required |
|
26 |
Monday Close |
Required |
|
27 |
Tuesday Open |
Required |
|
28 |
Tuesday Close |
Required |
|
29 |
Wednesday Open |
Required |
|
30 |
Wednesday Close |
Required |
|
31 |
Thursday Open |
Required |
|
32 |
Thursday Close |
Required |
|
33 |
Friday Open |
Required |
|
34 |
Friday Close |
Required |
|
35 |
Saturday Open |
Required |
|
36 |
Saturday Close |
Required |
|