Navigation: » No topics above this level «

Invoices: Invoices

https://online-sql-editor.com/teamleader/eu/stable/Sql?appendSqlQuery=select+*%0D%0Afrom+++Teamleader.V2.Invoices%0D%0Alimit++1000

Name: Invoices

Catalog: Teamleader

Schema: V2

Primary Keys: id

Label: Invoices

Partition-specific: false

Select: true

Insert: false

Update: false

Delete: false

Select Service URL (OData-specific): invoices.list

Insert Service URL (OData-specific): invoices.list

Update Service URL (OData-specific): invoices.list

Delete Service URL (OData-specific): invoices.list

Field Selection Method (OData-specific): NotRequired

Table Columns

Name	Data Type	Label	Required
created_at	datetime		☑
department_id	string	Department ID	☐
department_type	string	Department Type	☐
due_on	datetime	Due on	☐
id	string	ID	☑
invoice_date	datetime	Invoice Date	☐
invoice_number	string	Invoice Number	☐
invoicee_customer_id	string	Invoicee Customer ID	☑
invoicee_customer_type	string	Invoicee Customer Type	☑
invoicee_for_attention_of_contact_id	string	Invoice for Attention of Contact ID	☐
invoicee_for_attention_of_contact_type	string	Invoice for Attention of Contact Type	☐
invoicee_for_attention_of_name	string	Invoice for Attention of Name	☐
invoicee_name	string	Invoicee Name	☑
invoicee_vat_number	string	Invoicee VAT Number	☐
paid	boolean	Paid	☑
paid_at	datetime	Paid at	☐
payment_reference	string		☐
purchase_order_number	string		☐
sent	boolean		☑
status	string	Status	☑
total_due_amount	decimal	Total Due Amount	☐
total_due_currency	string	Currency of Total Due Amount	☐
total_payable_amount	decimal	Total Payable Amount	☐
total_payable_currency	string	Currency of Total Payable Amount	☐
total_tax_exclusive_amount	decimal	Total Amount excluding Taxes	☐
total_tax_exclusive_currency	string	Currency of Total Amount excluding Taxes	☐
total_tax_inclusive_amount	decimal	Total Amount including Taxes	☐
total_tax_inclusive_currency	string	Currency of Total Amount including Taxes	☐
updated_at	datetime	Updated At	☑

10-09-2020 00:0920.1.206-BETA+2915