03333 445950
 |
 |
 |
Making I.T. Happen
Accounting and Information Technology, Assistance and Support
Project Transactions V2010 and Above
The field order is specified below, for users using a spreadsheet to prepare data we have also included column letters.
| Field | Header Name | Notes | |
| 1 | A | Type | A two character integer defining whether the transaction is a costing credit or debit. 20 Debit 19 Credit |
| 2 | B | Project Reference | The project reference, to which the transaction is related, using up to twelve characters. |
| 3 | C | Cost Code Reference | The project reference cost code assigned to the transaction. (8 char max no spaces) |
| 4 | D | Date | The date when the transaction was recorded, expressed in DD/MM/YYYY format. |
| 5 | E | Reference | The transaction reference entry, using up to thirty characters. (Time, Expenses, Purchase) |
| 6 | F | Details | Detailed description of the transaction, using up to sixty characters |
| 7 | G | Resource Reference | The resource reference, using up to eight characters. |
| 8 | H | Quantity | The amount or quantity used in the transaction. |
| 9 | I | Rate | The rate at which this transaction is charged. |
Refer to our field information table for the limitations of data values for these fields
Our Custom integration and import solution will allow you to have fields in any order and extract them from formats other than CSV eg: mailing labels printed to disk you can also import all the other fields associated with customers such as price lists.
