Skip to main content

api_invoices

Description

The api_invoices table exposes invoice header information from Simplicate's invoicing module.

Fields

Field NameTypeDescription
invoice_idIntegerUnique identifier for the invoice
relation_idIntegerIdentifier of the relation (customer) for this invoice
invoice_numberStringHuman-readable invoice number
invoice_dateDateDate when the invoice was issued
  • api_invoicelines - Invoice line details via invoice_id
  • api_relations - Relation details via relation_id
  • api_time_registrations - Time registrations via invoice_id
  • api_project_service_costs - Costs via invoice_id