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 |
Documentation |
---|---|---|---|---|
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