invoice_entry table

invoice_entry Table (360)

This table contain all invoices, connected to a message

Name	Description	Type	Nullable
id	Primary key	PK	No
message_id	The message.id this invoice entry is connected to.	FK ej_message	No
description	A description of the invoice entry	String(255)	Yes
type	The type of this invoice entry	FK invoice_type	No
quantity	Number of units	Double	No
price_pr_unit	Price per unit. This is copied from the invoice_type when created so that changes to the price in the future does not affect this one.	Int	No
discount	Discount for this invoice entry	Int	No
date_invoiced	The date for the invoice entry	DateTime	No
discount_money	Discount for this invoice entry in money	Int	No
ie_sum	The sum of the invoice entry	Int	No

Table	Description
ej_message	This table contains the messages listed under tickets.
invoice_type	A invoiceable item category (a product or service) that provides default invoice line values