Please enable JavaScript to view this site.

Navigation: Schema: Invoices > Tables

InvoiceProjects: Simplicate Invoice Projects

Fetches all invoices

Catalog: Simplicate

Schema: Invoices

Label: Invoice Projects

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[*].projects[*]

Select Simplicate API Operation: get /invoices/invoice

Table Function Columns

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

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_1

string

 

 

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

 

 

name

string

Name

 

organization_id_1

string

 

 

organization_id_2

string

 

 

organization_id

string

Organization ID

 

organization_name_1

string

 

 

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_1

string

 

 

person_full_name

string

Person Full Name

 

person_id_1

string

 

 

person_id_2

string

 

 

person_id

string

Person ID

 

project_id_1

string

 

 

project_id

string

Project ID

 

project_manager_amount

float

 

 

project_manager_declarable

string

 

 

project_manager_employee_id

string

 

 

project_manager_id

string

 

 

project_manager_name

string

 

 

project_manager_person_id

string

 

 

project_manager_tariff

float

 

 

project_name

string

Project Name

 

project_number

string

Project Number

 

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

 

separate_invoice_recipient_is_separate_invoice_recipient

boolean

 

 

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