Invoices: Simplicate Invoices |
Fetches all invoices
Catalog: Simplicate
Schema: Invoices
Label: Invoices
Can retrieve data and change data using insert, update and delete.
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[*]
Select Simplicate API Operation: get /invoices/invoice
Insert Simplicate API Operation: post /invoices/invoice
Update Simplicate API Operation: put /invoices/invoice/{id}
Delete Simplicate API Operation: delete /invoices/invoice/{id}
Table Function Columns
The columns of the table function Invoices are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert or update.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
comments |
string |
Comments |
☐ |
|
composition_type |
string |
Composition Type |
☐ |
|
contact_id |
string |
Contact ID |
☐ |
|
created_at |
string |
Created at |
☐ |
|
created |
string |
Created |
☐ |
|
date |
string |
Date |
☐ |
|
id |
string |
ID |
☐ |
|
invoice_number |
string |
Invoice Number |
☐ |
|
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 |
☐ |
|
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 |
|
☐ |
|
sending_method |
string |
Sending Method |
☐ |
|
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 |
float |
Total VAT |
☐ |
|
updated_at |
string |
Updated at |
☐ |
|
15-06-2022 20:27 Version 22.0.232-PROD+3445