Please enable JavaScript to view this site.

Navigation: Schema: Invoices > Tables

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