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 |
|