Navigation: Schema: Invoices > Tables

InvoiceLineInvoices

Fetches all invoices

Catalog: Simplicate

Schema: Invoices

This is a read-only table function. The Simplicate API may not support changing the data or the Invantive SQL driver for Simplicate does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Simplicate API.

Select Simplicate API URL: /invoices/invoice

Insert Simplicate API URL: /invoices/invoice

Update Simplicate API URL: /invoices/invoice

Delete Simplicate API URL: /invoices/invoice

Field Selection Method: NotRequired

Base Path: data[*].invoice_lines[*]

Select Simplicate API Operation: get /invoices/invoice

Table Function Columns

The columns of the table function InvoiceLineInvoices are shown below. Each column has an SQL data type.

Name	Data Type	Label	Required
amount	float	Amount	☐
comments	string	Comments	☐
composition_type	string	Composition Type	☐
contact_id	string	Contact ID	☐
created_1	string		☐
created_at_1	string		☐
created_at	string	Created at	☐
created	string	Created	☐
date_1	string		☐
date	string	Date	☐
default_service_id	string	Default Service ID	☐
description	string	Description	☐
id_1	string		☐
id	string	ID	☐
invoice_number	string	Invoice Number	☐
is_advance_deposit	boolean		☐
my_organization_profile_id_1	string		☐
my_organization_profile_id	string	My Organization Profile ID	☐
my_organization_profile_organization_id	string		☐
my_organization_profile_organization_name	string		☐
organization_id_1	string		☐
organization_id	string	Organization ID	☐
organization_name	string	Organization Name	☐
payment_term_days	int64	Payment Term Days	☐
payment_term_id	string	Payment Term ID	☐
payment_term_method	string	Payment Term Method	☐
payment_term_name	string	Payment Term Name	☐
person_full_name	string	Person Full Name	☐
person_id_1	string		☐
person_id	string	Person ID	☐
price	float	Price	☐
project_id_1	string		☐
project_id	string	Project ID	☐
project_name	string	Project Name	☐
project_organization_id	string	Project Organization ID	☐
project_organization_name	string	Project Organization Name	☐
project_person_full_name	string	Project Person Full Name	☐
project_person_id	string	Project Person ID	☐
project_project_manager_amount	float	Project Manager Amount	☐
project_project_manager_declarable	string	Project Manager Declarable	☐
project_project_manager_employee_id	string	Project Manager Employee ID	☐
project_project_manager_id	string	Project Manager ID	☐
project_project_manager_name	string	Project Manager Name	☐
project_project_manager_person_id	string	Project Manager Person ID	☐
project_project_manager_tariff	float	Project Manager Tariff	☐
project_project_number	string	Project Number	☐
project_separate_invoice_recipient_is_separate_invoice_recipient	boolean	Project Separate Invoice Recipient	☐
reference	string	Reference	☐
reminder_next_action	string		☐
reminder_paused	boolean		☐
reminder_set_disabled	boolean		☐
reminder_set_id	string		☐
reminder_set_label	string		☐
revenue_group_id	string	Revenue Group ID	☐
revenue_group_label	string	Revenue Group Label	☐
sending_method	string	Sending Method	☐
service_id	string	Service ID	☐
simplicate_url	string	Simplicate URL	☐
status	string	Status	☐
subject	string	Subject	☐
subscription_cycle_end_date	string		☐
subscription_cycle_is_invoiced	boolean		☐
subscription_cycle_start_date	string		☐
timeline_email_address	string	Timeline Email Address	☐
total_excluding_vat	float	Total excluding VAT	☐
total_including_vat	float	Total including VAT	☐
total_outstanding	float	Total Outstanding	☐
total_vat_1	float		☐
total_vat	float	Total VAT	☐
updated_at_1	string		☐
updated_at	string	Updated at	☐
vat_class_code	string	VAT Class Code	☐
vat_class_id	string	VAT Class ID	☐
vat_class_label	string	VAT Class Label	☐
vat_class_name	string	VAT Class Name	☐
vat_class_percentage	float	VAT Class Percentage	☐

15-06-2022 20:27 Version 22.0.232-PROD+3445

Please enable JavaScript to view this site.

Simplicate API Data Model Simplicate Forums

InvoiceLineInvoices

Table Function Columns