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