api_invoicelines

⚠️ 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 line data from Simplicate.

Description

The api_invoicelines table exposes individual invoice line items, including pricing and links to projects, services, and revenue groups.

Fields

Field Name	Type	Description
invoice_line_id	Integer	Unique identifier for the invoice line
invoice_id	Integer	Identifier of the parent invoice
relation_id	Integer	Identifier of the relation (customer)
project_relation_id	Integer	Identifier of the project's relation
project_id	Integer	Identifier of the project this line relates to
project_service_id	Integer	Identifier of the project service
default_service_id	Integer	Identifier of the default service template
administration_id	Integer	Identifier of the administration
revenue_group_id	Integer	Identifier of the revenue group for categorization
linked_to_project	Integer	Flag indicating if the invoice line is linked to a project (1=yes, 0=no)
invoice_number	String	Human-readable invoice number
invoice_type	String	Type of invoice (e.g., standard, credit)
type	String	Type of invoice line item
default_service	String	Name of the default service template
revenue_group	String	Name of the revenue group for categorization
invoice_date	Date	Date when the invoice was issued
total_price	Numeric	Total price of the invoice line including any applicable taxes
last_updated_at	DateTime	Timestamp of the last update to this record

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_line_id	Integer	invoice_line_id
key_invoice_id	Integer	invoice_id
key_relation_id	Integer	relation_id
key_project_relation_id	Integer	project_relation_id
key_project_id	Integer	project_id
key_project_service_id	Integer	project_service_id
key_default_service_id	Integer	default_service_id
key_administration_id	Integer	administration_id
key_revenue_group_id	Integer	revenue_group_id
default_service_name	String	default_service
revenue_group_name	String	revenue_group

Related Tables

• api_invoices - Invoice headers via invoice_id
• api_projects - Project details via project_id
• api_project_services - Project service details via project_service_id
• api_relations - Relation details via relation_id
• api_administrations - Administration details via administration_id
• api_revenuegroups - Revenue group details via revenue_group_id