invantive documentation
Invantive Support ForumsLog In / Sign Up

Orders: Teamleader Focus Orders

read only REST

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

Can only retrieve data.

API Source

  • Endpoint: orders.list

Performance Characteristics

Characteristic Value
Average access latency (ms) 39

The result can be cached on the client.

Table Columns

The columns of the table Orders 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
assignee_id varchar2 Assignee ID filters on the platform, writable, assignee.id
assignee_type varchar2 Assignee Type filters on the platform, writable, assignee.type
deal_id varchar2 Deal ID filters on the platform, writable, deal.id
deal_type varchar2 Deal Type filters on the platform, writable, deal.type
delivery_date datetime Delivery Date filters on the platform, writable
department_id varchar2 Department ID filters on the platform, writable, department.id
department_type varchar2 Department Type filters on the platform, writable, department.type
id varchar2 ID filters on the platform, writable
name varchar2 Name filters on the platform, writable
order_date datetime Order Date filters on the platform, writable
payment_term_days int64 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
project_type varchar2 Project Type filters on the platform, writable, project.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
total_purchase_price_tax_exclusive_amount decimal Total Purchase Price Tax Exclusive Amount filters on the platform, writable, total.purchase_price_tax_exclusive.amount
total_purchase_price_tax_exclusive_currency varchar2 Total Purchase Price Tax Exclusive Currency filters on the platform, writable, total.purchase_price_tax_exclusive.currency
total_purchase_price_tax_inclusive_amount decimal Total Purchase Price Tax Inclusive Amount filters on the platform, writable, total.purchase_price_tax_inclusive.amount
total_purchase_price_tax_inclusive_currency varchar2 Total Purchase Price Tax Inclusive Currency filters on the platform, writable, total.purchase_price_tax_inclusive.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
web_url varchar2 Web (URL) filters on the platform, writable

Keys

Key Column Refers to Kind Description
Orders_assignee_id_Users_txt assignee_id Users.id Textual The id of a row of Users, when assignee_type is 'user'.
Orders_deal_id_fk deal_id Deals.id Key
Orders_department_id_fk department_id Departments.id Key

Release Notes

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