invantive documentation
Invantive Support ForumsLog In / Sign Up

InvoiceLinesById: Teamleader Focus Invoice Lines by ID

read only REST

  • Catalog: Teamleader
  • Schema: V2
  • Primary Keys: id
  • Label: Invoice Lines 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 InvoiceLinesById 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
group_section_title varchar2 Group Section Title filters on the platform, writable, ::ancestor.section.title
invoice_currency varchar2 Invoice Currency filters on the platform, writable, ::ancestor.currency
invoice_date datetime Invoice Date filters on the platform, writable, ::ancestor.::ancestor.invoice_date
invoice_due_on datetime Invoice Due on filters on the platform, writable, ::ancestor.::ancestor.due_on
invoice_id varchar2 Invoice ID filters on the platform, writable, ::ancestor.::ancestor.id
invoice_number varchar2 Invoice Number filters on the platform, writable, ::ancestor.::ancestor.invoice_number
invoice_on_hold_since datetime Invoice On Hold Since filters on the platform, writable, ::ancestor.::ancestor.on_hold_since
invoice_paid char Invoice is Paid filters on the platform, writable, ::ancestor.::ancestor.paid
invoice_paid_at datetime Invoice is Paid at filters on the platform, writable, ::ancestor.::ancestor.paid_at
invoice_payment_reference varchar2 Invoice Payment Reference filters on the platform, writable, ::ancestor.::ancestor.payment_reference
invoice_purchase_order_number varchar2 Invoice Purchase Order Number filters on the platform, writable, ::ancestor.::ancestor.purchase_order_number
invoice_sent char Invoice Sent filters on the platform, writable, ::ancestor.::ancestor.sent
invoice_status varchar2 Invoice Status filters on the platform, writable, ::ancestor.::ancestor.status
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
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

Release Notes

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