...
| Field | Type | Length | Unique | Required | Format | Description |
|---|---|---|---|---|---|---|
| identifier | varchar | 80 | yes | yes | Invoice line ID | |
invoice_id | varchar | 80 | yesno | yes | table: invoices, field:identifier | Invoice ID the invoice line belongs to |
| quantity | float | 8 | no | yes | Quantity of products. Discounts and credits should be negative | |
| line_amount | float | 8 | no | yes | Price invoiced. Discounts and credits should be negative | |
| is_line_amount_inc_tax | boolean | no | yes | true/false | Is Tax included in price. This should always be true | |
| unit_price | float | 8 | no | no | Unit price of product | |
| is_unit_price_inc_tax | boolean | no | no | true/false | Is Tax included in unit price. This should always be true | |
| notes | varchar | 255 | no | no | invoice line description/product description | |
| staff_code | varchar | 80 | no | yes | Name/Code of the vet | |
| patient_id | varchar | 255 | no | yes | table: patients, field: identifier | ID of the patient |
| product_id | varchar | 20 | no | yes | table: products, field:identifier | ID of the invoice product |
...