api_invoices

⚠️ Important: Some fields in this table will be deprecated on Wednesday, January 7th, 2025. Please review the Deprecated Fields section below and migrate to the recommended alternatives.

This table provides invoice header data from Simplicate.

Description

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

Fields

Field Name	Type	Description
invoice_id	Integer	Unique identifier for the invoice
relation_id	Integer	Identifier of the relation (customer) for this invoice
invoice_number	String	Human-readable invoice number
invoice_date	Date	Date when the invoice was issued

Deprecated Fields

⚠️ Deprecation Notice: The following fields will be deprecated on Wednesday, January 7th, 2025. Please migrate to the recommended alternatives.

Deprecated Field	Type	Recommended Alternative
key_invoice_id	Integer	invoice_id

Related Tables

• 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