Invoice lines

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

ProfitDiagnostix Public knowledge base