...
| Field | Type | Length | Unique | Required | Format | Description |
|---|---|---|---|---|---|---|
| identifier | varchar | 80 | yes | yes | Invoice ID | |
| 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 | |
| total | float | 8 | no | yes | Total of amount invoiced. 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 |
| status | varchar | 20 | no | no | e.g. paid/partly_paid | |
| branch | varchar | 255 | no | yes | Name/Code of the branch the invoice was issued | |
| updated_after | 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 |
Example CSV-File: invoices.csv