invoice table - SuperOffice

invoice Table (265)

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

Fields

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

Indexes

Fields	Types	Description
customer_id	FK	Index
company_id	FK	Index

Relationships

Table	Description
contact	Companies and Organizations.
person	Persons

Replication Flags

None

Security Flags

No access control via user’s Role.

Related topics

invoice_entry table invoice_sum table invoice_type table InvoiceEntry login table contact table

⌘I