uid

title

description

so.generated

keywords

so.date

so.topic

so.envir

table-invoice

invoice table

This table contains invoice entries, normally created when an invoice is sent to a customer, and we want to update the balance.

true

database

invoice

11.04.2021

reference

onsite

online

invoice Table (265)

Fields

Name	Description	Type	Null
id	The primary key (auto-incremented)	PK
time_charged	The amount of time (minutes) charged. From version 2.8 this field is no longer in use	Int	●
price_charged	The amount (money) charged.	Double	●
customer_id	The reference to the customer entry this entry is connected to. NULL or -1 if not connected.	FK person
company_id	The reference to the company entry this entry is connected to. NULL or -1 if not connected.	FK contact
created_at	When the invoice entry was created.	DateTime	●
description	A string describing the invoice entry.	String(255)	●

[!includedetails]