invoice-entry.md

uid	title	description	so.generated	keywords	so.topic	so.envir
table-invoice_entry	invoice_entry table	This table contain all invoices, connected to a message	true	database table invoice_entry	reference	onsite, online

invoice_entry Table (360)

This table contain all invoices, connected to a message

Fields

Name	Description	Type	Null
id	Primary key	PK
message_id	The message.id this invoice entry is connected to.	FK ej_message
description	A description of the invoice entry	String(255)	●
type	The type of this invoice entry	FK invoice_type
quantity	Number of units	Double
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
discount	Discount for this invoice entry	Int
date_invoiced	The date for the invoice entry	DateTime
discount_money	Discount for this invoice entry in money	Int
ie_sum	The sum of the invoice entry	Int

[!includedetails]

Indexes

Fields	Types	Description
id	PK	Clustered, Unique
message_id	FK	Index
type	FK	Index
date_invoiced	DateTime	Index

Relationships

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

Replication Flags

• None

Security Flags

• No access control via user's Role.