Please enable JavaScript to view this site.

Navigation: Schema: V2Flat > Tables

InvoiceLinesAll

Catalog: Teamleader

Schema: V2Flat

This is a read-only view. The Teamleader Focus API may not support changing the data or the Invantive SQL driver for Teamleader Focus does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Teamleader Focus API.

View Columns

The columns of the view InvoiceLinesAll are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

description

string

 

 

discount_type

string

 

 

discount_value

decimal

 

 

extended_description

string

 

 

group_section_title

string

 

 

invoice_created_at

datetime

 

 

invoice_currency_exchange_rate_from

string

 

 

invoice_currency_exchange_rate_rate

decimal

 

 

invoice_currency_exchange_rate_to

string

 

 

invoice_date

datetime

 

 

invoice_deal_id

string

 

 

invoice_deal_type

string

 

 

invoice_department_id

string

 

 

invoice_department_type

string

 

 

invoice_due_on

datetime

 

 

invoice_due_on1

datetime

 

 

invoice_file_id

string

 

 

invoice_file_type

string

 

 

invoice_id

string

 

 

invoice_id1

string

 

 

invoice_invoice_date

datetime

 

 

invoice_invoice_number

string

 

 

invoice_invoicee_customer_id

string

 

 

invoice_invoicee_customer_type

string

 

 

invoice_invoicee_for_attention_of_contact_id

string

 

 

invoice_invoicee_for_attention_of_contact_type

string

 

 

invoice_invoicee_for_attention_of_name

string

 

 

invoice_invoicee_name

string

 

 

invoice_invoicee_vat_number

string

 

 

invoice_number

string

 

 

invoice_paid_at

datetime

 

 

invoice_paid_at1

datetime

 

 

invoice_paid

boolean

 

 

invoice_paid1

boolean

 

 

invoice_payment_reference

string

 

 

invoice_payment_reference1

string

 

 

invoice_project_id

string

 

 

invoice_purchase_order_number

string

 

 

invoice_purchase_order_number1

string

 

 

invoice_sent

boolean

 

 

invoice_sent1

boolean

 

 

invoice_status

string

 

 

invoice_status1

string

 

 

invoice_total_due_amount

decimal

 

 

invoice_total_due_currency

string

 

 

invoice_total_payable_amount

decimal

 

 

invoice_total_payable_currency

string

 

 

invoice_total_tax_exclusive_amount

decimal

 

 

invoice_total_tax_exclusive_currency

string

 

 

invoice_total_tax_inclusive_amount

decimal

 

 

invoice_total_tax_inclusive_currency

string

 

 

invoice_updated_at

datetime

 

 

on_hold_since

datetime

 

 

product_category_id

string

 

 

product_category_type

string

 

 

product_id

string

 

 

product_type

string

 

 

quantity

decimal

 

 

tax_id

string

 

 

tax_type

string

 

 

total_tax_exclusive_amount

decimal

 

 

total_tax_exclusive_before_discount_amount

decimal

 

 

total_tax_exclusive_before_discount_currency

string

 

 

total_tax_exclusive_currency

string

 

 

total_tax_inclusive_amount

decimal

 

 

total_tax_inclusive_before_discount_amount

decimal

 

 

total_tax_inclusive_before_discount_currency

string

 

 

total_tax_inclusive_currency

string

 

 

unit_currency

string

 

 

unit_price_amount

decimal

 

 

unit_tax

string

 

 

 

29-05-2022 01:08 Version 22.0.196-PROD+3400