invantive documentation
Invantive Support ForumsLog In / Sign Up

InvoiceLinesAll: Teamleader Focus Invoice Lines

popular read only

  • Catalog: Teamleader
  • Schema: V2Flat
  • Label: Invoice 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 InvoiceLinesAll 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
group_section_title varchar2 Group Section Title filters on the platform, writable
invoice_c_ookpernotaris char itgen_teamleader_c_ookpernotaris filters on the platform, writable
invoice_created_at datetime Created at filters on the platform, writable
invoice_currency varchar2 Invoice Currency filters on the platform, writable
invoice_currency_exchange_rate_from varchar2 Currency Exchange Rate From filters on the platform, writable
invoice_currency_exchange_rate_rate decimal Currency Exchange Rate filters on the platform, writable
invoice_currency_exchange_rate_to varchar2 Currency Exchange Rate To filters on the platform, writable
invoice_date datetime Invoice Date filters on the platform, writable
invoice_deal_id varchar2 Deal ID filters on the platform, writable
invoice_deal_type varchar2 Deal Type filters on the platform, writable
invoice_department_id varchar2 Department ID filters on the platform, writable
invoice_department_type varchar2 Department Type filters on the platform, writable
invoice_due_on datetime Invoice Due on filters on the platform, writable
invoice_due_on2 datetime Due on filters on the platform, writable
invoice_file_id varchar2 File ID filters on the platform, writable
invoice_file_type varchar2 File Type filters on the platform, writable
invoice_id varchar2 Invoice ID filters on the platform, writable
invoice_id2 varchar2 ID filters on the platform, writable
invoice_invoice_date datetime Invoice Date filters on the platform, writable
invoice_invoice_number varchar2 Invoice Number filters on the platform, writable
invoice_invoicee_customer_id varchar2 Invoicee Customer ID filters on the platform, writable
invoice_invoicee_customer_type varchar2 Invoicee Customer Type filters on the platform, writable
invoice_invoicee_for_attention_of_contact_id varchar2 Invoice for Attention of Contact ID filters on the platform, writable
invoice_invoicee_for_attention_of_contact_type varchar2 Invoice for Attention of Contact Type filters on the platform, writable
invoice_invoicee_for_attention_of_name varchar2 Invoice for Attention of Name filters on the platform, writable
invoice_invoicee_name varchar2 Invoicee Name filters on the platform, writable
invoice_invoicee_vat_number varchar2 Invoicee VAT Number filters on the platform, writable
invoice_number varchar2 Invoice Number filters on the platform, writable
invoice_on_hold_since datetime Invoice On Hold Since filters on the platform, writable
invoice_paid char Invoice is Paid filters on the platform, writable
invoice_paid2 char Paid filters on the platform, writable
invoice_paid_at datetime Invoice is Paid at filters on the platform, writable
invoice_paid_at2 datetime Paid at filters on the platform, writable
invoice_payment_reference varchar2 Invoice Payment Reference filters on the platform, writable
invoice_payment_reference2 varchar2 Payment Reference filters on the platform, writable
invoice_project_id varchar2 Project ID filters on the platform, writable
invoice_purchase_order_number varchar2 Invoice Purchase Order Number filters on the platform, writable
invoice_purchase_order_number2 varchar2 Purchase Order Number filters on the platform, writable
invoice_sent char Invoice Sent filters on the platform, writable
invoice_sent2 char Sent filters on the platform, writable
invoice_status varchar2 Invoice Status filters on the platform, writable
invoice_status2 varchar2 Status filters on the platform, writable
invoice_total_due_amount decimal Total Due Amount filters on the platform, writable
invoice_total_due_currency varchar2 Currency of Total Due Amount filters on the platform, writable
invoice_total_payable_amount decimal Total Payable Amount filters on the platform, writable
invoice_total_payable_currency varchar2 Currency of Total Payable Amount filters on the platform, writable
invoice_total_tax_exclusive_amount decimal Total Amount excluding Taxes filters on the platform, writable
invoice_total_tax_exclusive_currency varchar2 Currency of Total Amount excluding Taxes filters on the platform, writable
invoice_total_tax_inclusive_amount decimal Total Amount including Taxes filters on the platform, writable
invoice_total_tax_inclusive_currency varchar2 Currency of Total Amount including Taxes filters on the platform, writable
invoice_updated_at datetime Updated At filters on the platform, writable
invoice_web_url varchar2 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
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

Release Notes

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