Invoices - Datasource
| Field | Type | Length | Unique | Required | Format | Description |
|---|---|---|---|---|---|---|
| identifier | varchar | 80 | yes | yes | Invoice ID. This should preferably be the invoice number of the invoice as displayed on a printed invoice that is produced for tax purposes. | |
| invoice_type_code | varchar | 255 | no | no | Invoice type e.g. invoice, discount, credit... | |
| issue_date_time | timestamp | no | yes | YYYY-MM-DD hh:mm:ss | date/time the invoice was issued. This should be the date that is produced on a printed invoice for tax purposes. | |
| total | float | 8 | no | yes | Total of amount invoiced including sales tax. Discounts and credits should be negative | |
| tax_total | float | 8 | no | yes | Total amount of tax. Discounts and credits should be negative | |
| client | varchar | 255 | no | yes | table: clients, field: identifier | Client ID of the client the invoice is issued to. This should be the unique identifier of the client/customer |
| status | varchar | 20 | no | no | e.g. paid/partly_paid. If partly paid invoices are included in the supplied data then all invoices must be flagged as paid/partly paid. As an alternative it is acceptable to supply only fully paid or finalised invoices | |
| branch | varchar | 255 | no | yes | Name/Code/ID of the branch/location/job/department the invoice was issued if the system supports different locations, branches, jobs or departments. | |
| updated_after/date_modified | timestamp | no | optional if data is to be collected incrementally | YYYY-MM-DD hh:mm:ss | If data is to be collected incrementally, and updates or edits to either invoice header and invoice line needs to be flagged with a timestamp indicating the most recent 'last modified' date |
Example CSV-File: invoices.csv