Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Simplicate API Data Model

Navigation: Schema: Invoices > Tables

Invoices: Simplicate Invoices

 Contents Previous Home Next More

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

 

☐

 

composition_type

string

 

☐

 

contact_id

string

 

☐

 

created_at

string

Created at

☐

 

created

string

Created

☐

 

date

string

 

☐

 

id

string

ID

☐

 

invoice_number

string

 

☐

 

my_organization_profile_id_1

string

 

☐

 

my_organization_profile_id

string

 

☐

 

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_id

string

 

☐

 

payment_term_method

string

 

☐

 

payment_term_name

string

 

☐

 

person_full_name

string

 

☐

 

person_id_1

string

 

☐

 

person_id

string

Person ID

☐

 

project_id_1

string

 

☐

 

project_id

string

Project ID

☐

 

project_name

string

 

☐

 

project_organization_id

string

 

☐

 

project_organization_name

string

 

☐

 

project_person_full_name

string

 

☐

 

project_person_id

string

 

☐

 

project_project_manager_amount

float

 

☐

 

project_project_manager_declarable

string

 

☐

 

project_project_manager_employee_id

string

 

☐

 

project_project_manager_id

string

 

☐

 

project_project_manager_name

string

 

☐

 

project_project_manager_person_id

string

 

☐

 

project_project_manager_tariff

float

 

☐

 

project_project_number

string

 

☐

 

project_separate_invoice_recipient_contact_id

string

 

☐

See 'linked_persons_contact' in /crm/organization, or 'linked_as_contact_to_organization' in /crm/person, or /crm/contactperson

project_separate_invoice_recipient_is_separate_invoice_recipient

boolean

 

☐

 

project_separate_invoice_recipient_organization_id

string

 

☐

See /crm/organization

project_separate_invoice_recipient_person_id

string

 

☐

See /crm/person

reference

string

 

☐

 

reminder_next_action

string

 

☐

 

reminder_paused

boolean

 

☐

 

reminder_set_disabled

boolean

 

☐

 

reminder_set_id

string

 

☐

 

reminder_set_label

string

 

☐

 

sending_method

string

 

☐

 

simplicate_url

string

Simplicate URL

☐

 

status_color

string

 

☐

 

status_id

string

 

☐

 

status_name

string

 

☐

 

subject

string

 

☐

 

subscription_cycle_end_date

string

 

☐

 

subscription_cycle_is_invoiced

boolean

 

☐

 

subscription_cycle_start_date

string

 

☐

 

timeline_email_address

string

 

☐

 

total_excluding_vat

float

 

☐

 

total_including_vat

float

 

☐

 

total_outstanding

float

 

☐

 

total_vat

float

 

☐

 

updated_at

string

Updated at

☐

 

 

06-04-2021 14:59 Version 20.1.393-BETA+3152