The data file to import Contracts must consist of thirty-nine (39) comma separated columns. The columns must be in the following order:
Column |
Field |
Required/Optional |
Description |
1 |
Contract ID |
Required |
The contract ID must not exist in Pinnacle yet. |
2 |
Contract Title |
Required |
|
3 |
Contract Type |
Required |
The contract type must already exist. |
4 |
Supplier Short Name |
Required |
The supplier short name must already exist in the Suppliers table. |
5 |
Supervised By |
Required |
If a value is supplied, the staff member must already exist in the Staff/Non-suppliers table. |
6 |
Apportioning Type |
Required |
The value for this field must be 'P' for Percentage, 'V' for Value, or 'S' for Square Metres. |
7 |
Time Zone |
Required |
The value for this field must be: 'Australia/Adelaide', 'Australia/Brisbane', 'Australia/Darwin', 'Australia/Hobart', 'Australia/Melbourne', 'Australia/Perth', 'Australia/Sydney', 'NZ' |
8 |
Date Let |
Optional |
|
9 |
Contract Expiry Date |
Required |
|
10 |
Warranty Period |
Optional |
|
11 |
Annual Estimated |
Optional |
|
12 |
Annual GST |
Optional |
|
13 |
Contract Total Estimated |
Optional |
|
14 |
Contract Total GST |
Optional |
|
15 |
Phone No B/H |
Optional |
If you enter a value in this field, it will override the default value for the field from the supplier information. |
16 |
Phone No B/H Preferred |
Optional |
If you enter a value in this field, it will override the default value for the field from the supplier information. |
17 |
Phone No A/H |
Optional |
If you enter a value in this field, it will override the default value for the field from the supplier information. |
18 |
Phone No A/H Preferred |
Optional |
If you enter a value in this field, it will override the default value for the field from the supplier information. |
19 |
Fax No |
Optional |
If you enter a value in this field, it will override the default value for the field from the supplier information. |
20 |
Fax No B/H Preferred |
Optional |
If you enter a value in this field, it will override the default value for the field from the supplier information. |
21 |
E-mail Address |
Optional |
If you enter a value in this field, it will override the default value for the field from the supplier information. |
22 |
E-mail Address B/H Preferred |
Optional |
If you enter a value in this field, it will override the default value for the field from the supplier information. |
23 |
SMS No |
Optional |
If you enter a value in this field, it will override the default value for the field from the supplier information. |
24 |
SMS No B/H Preferred |
Optional |
If you enter a value in this field, it will override the default value for the field from the supplier information. |
25 |
Sunday Open |
Optional |
If you enter a value in this field, it will override the default value for the field from the supplier information. |
26 |
Sunday Close |
Optional |
If you enter a value in this field, it will override the default value for the field from the supplier information. |
27 |
Monday Open |
Optional |
If you enter a value in this field, it will override the default value for the field from the supplier information. |
28 |
Monday Close |
Optional |
If you enter a value in this field, it will override the default value for the field from the supplier information. |
29 |
Tuesday Open |
Optional |
If you enter a value in this field, it will override the default value for the field from the supplier information. |
30 |
Tuesday Close |
Optional |
If you enter a value in this field, it will override the default value for the field from the supplier information. |
31 |
Wednesday Open |
Optional |
If you enter a value in this field, it will override the default value for the field from the supplier information. |
32 |
Wednesday Close |
Optional |
If you enter a value in this field, it will override the default value for the field from the supplier information. |
33 |
Thursday Open |
Optional |
If you enter a value in this field, it will override the default value for the field from the supplier information. |
34 |
Thursday Close |
Optional |
If you enter a value in this field, it will override the default value for the field from the supplier information. |
35 |
Friday Open |
Optional |
If you enter a value in this field, it will override the default value for the field from the supplier information. |
36 |
Friday Close |
Optional |
If you enter a value in this field, it will override the default value for the field from the supplier information. |
37 |
Saturday Open |
Optional |
If you enter a value in this field, it will override the default value for the field from the supplier information. |
38 |
Saturday Close |
Optional |
If you enter a value in this field, it will override the default value for the field from the supplier information. |
39 |
Comments |
Optional |
|