invantive documentation
Invantive Support ForumsLog In / Sign Up

Invoices: Teamleader Focus Invoices

popular read only REST

  • Catalog: Teamleader
  • Schema: V2
  • Primary Keys: id
  • Label: Invoices

Can only retrieve data.

API Source

  • Endpoint: invoices.list

Performance Characteristics

Characteristic Value
Average access latency (ms) 39

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
deal_id `` The ID of the related deal you wish to filter on.
department_id `` Filters on a department (company entity).
invoice_date_after date This date is inclusive.
invoice_date_before date This date is exclusive.
invoice_number ``
payment_reference ``
project_id `` The ID of the related project you wish to filter on.
purchase_order_number ``
term `` Search for term in invoice number, purchase order number, payment reference and invoicee.
updated_since date

Table Columns

The columns of the table 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 and update.

Name Data Type Label Required Marks Documentation
c_ookpernotaris char itgen_teamleader_c_ookpernotaris filters on the platform, writable
created_at datetime Created at filters on the platform, writable
currency_exchange_rate_from varchar2 Currency Exchange Rate From filters on the platform, writable, currency_exchange_rate.from
currency_exchange_rate_rate decimal Currency Exchange Rate filters on the platform, writable, currency_exchange_rate.rate
currency_exchange_rate_to varchar2 Currency Exchange Rate To filters on the platform, writable, currency_exchange_rate.to
deal_id varchar2 Deal ID filters on the platform, writable, deal.id
deal_type varchar2 Deal Type filters on the platform, writable, deal.type
department_id varchar2 Department ID filters on the platform, writable, department.id
department_type varchar2 Department Type filters on the platform, writable, department.type
due_on datetime Due on filters on the platform, writable
file_id varchar2 File ID filters on the platform, writable, file.id
file_type varchar2 File Type filters on the platform, writable, file.type
id varchar2 ID filters on the platform, writable
invoice_date datetime Invoice Date filters on the platform, writable
invoice_number varchar2 Invoice Number filters on the platform, writable
invoicee_customer_id varchar2 Invoicee Customer ID filters on the platform, writable, invoicee.customer.id
invoicee_customer_type varchar2 Invoicee Customer Type filters on the platform, writable, invoicee.customer.type
invoicee_for_attention_of_contact_id varchar2 Invoice for Attention of Contact ID filters on the platform, writable, invoicee.for_attention_of.contact.id
invoicee_for_attention_of_contact_type varchar2 Invoice for Attention of Contact Type filters on the platform, writable, invoicee.for_attention_of.contact.type
invoicee_for_attention_of_name varchar2 Invoice for Attention of Name filters on the platform, writable, invoicee.for_attention_of.name
invoicee_name varchar2 Invoicee Name filters on the platform, writable, invoicee.name
invoicee_vat_number varchar2 Invoicee VAT Number filters on the platform, writable, invoicee.vat_number
paid char Paid filters on the platform, writable
paid_at datetime Paid at filters on the platform, writable
payment_reference varchar2 Payment Reference filters on the platform, writable
project_id varchar2 Project ID filters on the platform, writable, project.id
purchase_order_number varchar2 Purchase Order Number filters on the platform, writable
sent char Sent filters on the platform, writable
status varchar2 Status filters on the platform, writable
total_due_amount decimal Total Due Amount filters on the platform, writable, total.due.amount
total_due_currency varchar2 Currency of Total Due Amount filters on the platform, writable, total.due.currency
total_payable_amount decimal Total Payable Amount filters on the platform, writable, total.payable.amount
total_payable_currency varchar2 Currency of Total Payable Amount filters on the platform, writable, total.payable.currency
total_tax_exclusive_amount decimal Total Amount excluding Taxes filters on the platform, writable, total.tax_exclusive.amount
total_tax_exclusive_currency varchar2 Currency of Total Amount excluding Taxes filters on the platform, writable, total.tax_exclusive.currency
total_tax_inclusive_amount decimal Total Amount including Taxes filters on the platform, writable, total.tax_inclusive.amount
total_tax_inclusive_currency varchar2 Currency of Total Amount including Taxes filters on the platform, writable, total.tax_inclusive.currency
updated_at datetime Updated At filters on the platform, writable
web_url varchar2 Web (URL) filters on the platform, writable

Keys

Key Column Refers to Kind Description
Invoices_deal_id_fk deal_id Deals.id Key
Invoices_department_id_fk department_id Departments.id Key
Invoices_invoicee_customer_id_Companies_txt invoicee_customer_id Companies.id Textual The id of a row of Companies, when invoicee_customer_type is 'company'.
Invoices_invoicee_customer_id_Contacts_txt invoicee_customer_id Contacts.id Textual The id of a row of Contacts, when invoicee_customer_type is 'contact'.

Referenced By

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: