invantive documentation
Invantive Support ForumsLog In / Sign Up

OrderLinesByOrderId: Teamleader Focus Order Lines by Order ID

read only REST

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

Can only retrieve data.

API Source

  • Endpoint: orders.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 OrderLinesByOrderId 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
description varchar2 Description filters on the platform, writable
discount_type varchar2 Discount Type filters on the platform, writable, discount.type
discount_value decimal Discount Value filters on the platform, writable, discount.value
extended_description varchar2 Extended Description filters on the platform, writable
order_id varchar2 Order ID filters on the platform, writable, ::ancestor.::ancestor.id
order_name varchar2 Order Name filters on the platform, writable, ::ancestor.::ancestor.name
order_status varchar2 Order Status filters on the platform, writable, ::ancestor.::ancestor.status
order_web_url varchar2 Order Web URL filters on the platform, writable, ::ancestor.::ancestor.web_url
product_category_id varchar2 Product Category ID filters on the platform, writable, product_category.id
product_category_type varchar2 Product Category Type filters on the platform, writable, product_category.type
product_id varchar2 Product ID filters on the platform, writable, product.id
product_type varchar2 Product Type filters on the platform, writable, product.type
quantity decimal Quantity filters on the platform, writable
section_title varchar2 Section Title filters on the platform, writable, ::ancestor.section.title
tax_id varchar2 Tax ID filters on the platform, writable, tax.id
tax_type varchar2 Tax Type filters on the platform, writable, tax.type
total_tax_exclusive_amount decimal Total Amount excluding Taxes filters on the platform, writable, total.tax_exclusive.amount
total_tax_exclusive_before_discount_amount decimal Total Tax Exclusive before Discount Amount filters on the platform, writable, total.tax_exclusive_before_discount.amount
total_tax_exclusive_before_discount_currency varchar2 Total Tax Exclusive before Discount Currency filters on the platform, writable, total.tax_exclusive_before_discount.currency
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_before_discount_amount decimal Total Tax Inclusive before Discount Amount filters on the platform, writable, total.tax_inclusive_before_discount.amount
total_tax_inclusive_before_discount_currency varchar2 Total Tax Inclusive before Discount Currency filters on the platform, writable, total.tax_inclusive_before_discount.currency
total_tax_inclusive_currency varchar2 Currency of Total Amount including Taxes filters on the platform, writable, total.tax_inclusive.currency
unit_currency varchar2 Unit Currency filters on the platform, writable, unit_price.currency
unit_id varchar2 Unit ID filters on the platform, writable, unit.id
unit_price_amount decimal Unit Price Amount filters on the platform, writable, unit_price.amount
unit_tax varchar2 Unit Tax filters on the platform, writable, unit_price.tax
unit_type varchar2 Unit Type filters on the platform, writable, unit.type
withheld_tax_id varchar2 Withheld Tax ID filters on the platform, writable, withheld_tax.id
withheld_tax_type varchar2 Withheld Tax Type filters on the platform, writable, withheld_tax.type

Release Notes

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