invantive documentation
Invantive Support ForumsLog In / Sign Up

OrderLinesAll: Teamleader Focus Order Lines

read only

  • Catalog: Teamleader
  • Schema: V2Flat
  • Label: Order Lines

Can only retrieve data.

Performance Characteristics

Characteristic Value
Average access latency (ms) 39

The result can be cached on the client.

Table Columns

The columns of the table OrderLinesAll 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_value decimal Discount Value filters on the platform, writable
extended_description varchar2 Extended Description filters on the platform, writable
order_id varchar2 Order ID filters on the platform, writable
order_name varchar2 Order Name filters on the platform, writable
order_status varchar2 Order Status filters on the platform, writable
order_web_url varchar2 Order Web URL filters on the platform, writable
product_category_id varchar2 Product Category ID filters on the platform, writable
product_category_type varchar2 Product Category Type filters on the platform, writable
product_id varchar2 Product ID filters on the platform, writable
product_type varchar2 Product Type filters on the platform, writable
quantity decimal Quantity filters on the platform, writable
section_title varchar2 Section Title filters on the platform, writable
tax_id varchar2 Tax ID filters on the platform, writable
tax_type varchar2 Tax Type filters on the platform, writable
total_tax_exclusive_amount decimal Total Amount excluding Taxes filters on the platform, writable
total_tax_exclusive_before_discount_amount decimal Total Tax Exclusive before Discount Amount filters on the platform, writable
total_tax_exclusive_before_discount_currency varchar2 Total Tax Exclusive before Discount Currency filters on the platform, writable
total_tax_exclusive_currency varchar2 Currency of Total Amount excluding Taxes filters on the platform, writable
total_tax_inclusive_amount decimal Total Amount including Taxes filters on the platform, writable
total_tax_inclusive_before_discount_amount decimal Total Tax Inclusive before Discount Amount filters on the platform, writable
total_tax_inclusive_before_discount_currency varchar2 Total Tax Inclusive before Discount Currency filters on the platform, writable
total_tax_inclusive_currency varchar2 Currency of Total Amount including Taxes filters on the platform, writable
unit_currency varchar2 Unit Currency filters on the platform, writable
unit_id varchar2 Unit ID filters on the platform, writable
unit_price_amount decimal Unit Price Amount filters on the platform, writable
unit_tax varchar2 Unit Tax filters on the platform, writable
unit_type varchar2 Unit Type filters on the platform, writable
withheld_tax_id varchar2 Withheld Tax ID filters on the platform, writable
withheld_tax_type varchar2 Withheld Tax Type filters on the platform, writable

Release Notes

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