Please enable JavaScript to view this site.

Navigation: Schema: Invoices > Tables

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