invantive documentation
Invantive Support ForumsLog In / Sign Up

InvoiceById: Teamleader Focus Invoice by ID

read only REST

  • Catalog: Teamleader
  • Schema: V2
  • Primary Keys: id
  • Label: Invoice by ID

Can only retrieve data.

API Source

  • Endpoint: invoices.info

Performance Characteristics

Characteristic Value
Average access latency (ms) 39

The result can be cached on the client.

Parameters

Name Data Type Required Default Documentation
id ``

Table Columns

The columns of the table InvoiceById 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 varchar2 Currency filters on the platform, writable
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
expected_payment_method varchar2 Expected Payment Method 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 Unique number of the invoice, including year.
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
note varchar2 Note filters on the platform, writable
on_hold_since datetime On Hold Since filters on the platform, writable
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
payment_term_days decimal Payment Term (days) filters on the platform, writable, payment_term.days
payment_term_type varchar2 Payment Term Type filters on the platform, writable, payment_term.type
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

Release Notes

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