Invoice lines
- Joss Herrmann
- Paolo Lencioni
- Ben van Klinken
Owned by Joss Herrmann
| Field | Type | Length | Unique | Required | Format | Description |
|---|---|---|---|---|---|---|
| identifier | varchar | 80 | yes | yes | Invoice line ID - the unique identifier of the invoice line. This is required for incremental updates. | |
invoice_id | varchar | 80 | no | yes | table: invoices, field:identifier | Invoice ID the invoice line belongs to - joins to the unique identifier of invoices |
| quantity | float | 8 | no | yes | Quantity of products. Discounts and credits should be negative | |
| line_amount | float | 8 | no | yes | Price including sales tax. 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 cost price of product inclusive of sales tax(optional if system records cost prices of items) | |
| 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/product name | |
| staff_code | varchar | 80 | no | yes | Name/Code of the staff member who is responsible for invoicing the item | |
| patient_id | varchar | 255 | no | yes | table: patients, field: identifier | ID of the patient (veterinary systems only) |
| product_id | varchar | 20 | no | yes | table: products, field:identifier | ID of the product - joins to the unique identifier of Products |
Example CSV-File: invoice_lines.csv