invantive documentation
Invantive Support ForumsLog In / Sign Up

Expenses: Teamleader Focus Expenses

read only REST

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

Can only retrieve data.

API Source

  • Endpoint: expenses.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
term `` Search case-insensitive for term in document number and supplier name.

Table Columns

The columns of the table Expenses 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
bookkeeping_status varchar2 itgen_teamleader_bookkeeping_status filters on the platform, writable
company_entity_id varchar2 Company Entity ID filters on the platform, writable, company_entity.id
company_entity_type varchar2 Company Entity Type filters on the platform, writable, company_entity.type
currency_code varchar2 itgen_teamleader_currency_code filters on the platform, writable, currency.code
document_date datetime itgen_teamleader_document_date filters on the platform, writable
document_number varchar2 itgen_teamleader_document_number filters on the platform, writable
due_date datetime Due Date 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
iban_number varchar2 IBAN Number filters on the platform, writable
origin_id varchar2 itgen_teamleader_origin_id filters on the platform, writable, origin.id
origin_type varchar2 itgen_teamleader_origin_type filters on the platform, writable, origin.type
paid_amount decimal itgen_teamleader_paid_amount 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_status varchar2 itgen_teamleader_payment_status filters on the platform, writable
review_status varchar2 itgen_teamleader_review_status filters on the platform, writable
source_id varchar2 Source ID filters on the platform, writable, source.id
source_type varchar2 Source Type filters on the platform, writable, source.type
supplier_id varchar2 Supplier ID filters on the platform, writable, supplier.id
supplier_type varchar2 Supplier Type filters on the platform, writable, supplier.type
title varchar2 Title filters on the platform, writable
total_tax_exclusive_amount decimal Total Amount excluding Taxes filters on the platform, writable, total.tax_exclusive.amount
total_tax_inclusive_amount decimal Total Amount including Taxes filters on the platform, writable, total.tax_inclusive.amount

Keys

Key Column Refers to Kind Description
Expenses_company_entity_id_fk company_entity_id Departments.id Key
Expenses_supplier_id_Companies_txt supplier_id Companies.id Textual The id of a row of Companies, when supplier_type is 'company'.
Expenses_supplier_id_Contacts_txt supplier_id Contacts.id Textual The id of a row of Contacts, when supplier_type is 'contact'.

Release Notes

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