invoice_sum table

invoice_sum Table (266)

This table is used temporarily when listing invoice statistics. It is used because we need to sort balances from both customers and companies.

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
login_id	The id of the user using the table.	FK login	No
name	The name of the entry.	String(255)	Yes
customer_id	The reference of the customer entry this entry is connected to. NULL or -1 if not connected.	FK person	No
company_id	The reference of the company entry this entry is connected to. NULL or -1 if not connected.	FK contact	No
balance	The balance for the given customer or company.	Int	Yes

Table	Description
contact	Companies and Organizations.
login	This table contains entries for the user sessions.
person	Persons