---
title: "Teamleader Focus Data Model"
description: "Teamleader Focus is a cloud solution for customer management. Teamleader includes CRM as well as project and tickets. Teamleader can be extended by defining custom fields on several core concepts."
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/teamleader
original: https://documentation.invantive.eu/en/datamodels/teamleader
updated: 2026-11-01T17:45:29Z
license: https://documentation.invantive.eu/en/
---

# Teamleader Focus Data Model

Teamleader Focus is a cloud solution for customer management. Teamleader includes CRM as well as project and tickets. Teamleader can be extended by defining custom fields on several core concepts.

Alternative Name
Teamleader Focus is also popular by the former name Teamleader.
Authentication
Authentication for the Teamleader Focus API can be done using one of the following two alternatives:
1. Using the user log on code and password also used on the Teamleader website.
2. Using an API group and API secret.
Authentication using user log on code and password is recommended for general use of the API through the Invantive tables. The user must have access to all functionality since by default all so-called 'scopes' of the API are requested. The API scopes can be manually entered to be able to log in with a restricted accounts. Please provide a space-separated list chosen from companies contacts deals departments events invoices products projects quotations subscriptions tickets todos users.
The API group and secret can be found on https://app.teamleader.eu/apiwebhooks.php?show_key.

Usage Limits
Invantive SQL executes API calls to retrieve and upload data from the Teamleader Focus API in JSON format. The V2 API allows 200 calls per minute. Invantive SQL ensures that within your session the number of calls allowed per timewindow is not exceeded.
To get an impression of how Invantive SQL translates into API calls, please query the data dictionary view 'sessionios', such as with 'select * from sessionios@datadictionary'.

Custom Fields
Custom fields for which one value can be entered on an object are added to the table representing the object. For instance, a custom field 'needsaudit' on 'project', will be added as a column 'c_needsaudit' on the 'project' table. The name of the additional column directly derives from the custom field name. Almost all changes, including adding numbers or reading characters, will result in the data model being changed.
Custom fields which can have no, one or multiple values ('set' custom fields) are reflected in the data model by tables with a name constructed of the object name, an underscore plus the name of the custom field. For example, a custom field named 'Multiple Selection' on 'Task' will add a table 'task_multipleselection' to the data model.
Custom fields are unique to each Teamleader Focus environment. When the existence of specific custom field is not guaranteed, please use generic solutions like the tables 'CustomFieldDefinitions', 'custom_fields', 'custom_field_options', 'custom_field', 'Custom_Fields_All', 'Custom_Field_Types' and their object-specific custom field value tables like 'ticket_custom_field_values_by_id'.

Set up this platform in Invantive Cloud: https://cloud.invantive.com/teamleader

Text comparisons on this platform are case sensitive.

## Platform

- Used from: Invantive Cloud and the Invantive products on your own computer or server.
- Kind: an application reached over its API.
- The data is partitioned, such as per company or administration.
- Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
- Status of the platform: [https://status.teamleader.eu/](https://status.teamleader.eu/).
- Language of its user community: Dutch.

## Figures

| Figure | Count |
|---|---:|
| Tables | 220 |
| Columns | 4,352 |
| Tables with insert | 1 |
| Tables with update | 0 |
| Tables with delete | 0 |
| Tables documented | 4 |

## Tables

### Teamleader.CodeValues

- [Custom_Field_Types](Teamleader.CodeValues.Custom_Field_Types): Domain Custom_Field_Types

### Teamleader.Native

- [NATIVEPLATFORMSCALARREQUESTS](Teamleader.Native.NATIVEPLATFORMSCALARREQUESTS): Native Platform Scalar Requests

### Teamleader.V2

- [ActivityTypes](Teamleader.V2.ActivityTypes): Activity Types
- [BookkeepingSubmissionsBySubject](Teamleader.V2.BookkeepingSubmissionsBySubject): Bookkeeping Submissions by Subject
- [BusinessTypes](Teamleader.V2.BusinessTypes): Business Types
- [CallById](Teamleader.V2.CallById): Call By ID
- [CallOutcomes](Teamleader.V2.CallOutcomes): Call Outcomes
- [Calls](Teamleader.V2.Calls): Calls
- [ClosingDays](Teamleader.V2.ClosingDays): Closing Days
- [CloudPlatformUrlByTypeAndId](Teamleader.V2.CloudPlatformUrlByTypeAndId): Cloud Platform URL by Type And ID
- [CommercialDiscounts](Teamleader.V2.CommercialDiscounts): Commercial Discounts
- [Companies](Teamleader.V2.Companies): Companies
- [CompanyAddressesByCompanyId](Teamleader.V2.CompanyAddressesByCompanyId): Company Addresses by Company ID
- [CompanyById](Teamleader.V2.CompanyById): Company by ID
- [CompanyEmailAddresses](Teamleader.V2.CompanyEmailAddresses): Company Email Addresses
- [CompanyTags](Teamleader.V2.CompanyTags): Company Tags
- [CompanyTelephones](Teamleader.V2.CompanyTelephones): Company Telephones
- [ContactAddressesByContactId](Teamleader.V2.ContactAddressesByContactId): Contact Addresses by Contact ID
- [ContactById](Teamleader.V2.ContactById): Contact by ID
- [ContactCompaniesByContactId](Teamleader.V2.ContactCompaniesByContactId): Contact Companies by Contact ID
- [ContactEmailAddresses](Teamleader.V2.ContactEmailAddresses): Contact Email Addresses
- [ContactTags](Teamleader.V2.ContactTags): Contact Tags
- [ContactTelephones](Teamleader.V2.ContactTelephones): Contact Telephones
- [Contacts](Teamleader.V2.Contacts): Contacts
- [CreditNoteGroupedLinesByCreditNoteId](Teamleader.V2.CreditNoteGroupedLinesByCreditNoteId): Credit Note Grouped Lines by ID
- [CreditNoteLinesByCreditNoteId](Teamleader.V2.CreditNoteLinesByCreditNoteId): Credit Note Lines by ID
- [CreditNoteTaxes](Teamleader.V2.CreditNoteTaxes): Credit Note Taxes
- [CreditNotes](Teamleader.V2.CreditNotes): Credit Notes
- [CreditNotesById](Teamleader.V2.CreditNotesById): Credit Note by ID
- [CurrencyExchangeRates](Teamleader.V2.CurrencyExchangeRates): Currency Exchange Rates
- [CurrentTimer](Teamleader.V2.CurrentTimer): Current Timer
- [CustomFieldDefinitions](Teamleader.V2.CustomFieldDefinitions): Custom Field Definitions
- [CustomFieldsByCompanyId](Teamleader.V2.CustomFieldsByCompanyId): Custom Fields by Company ID
- [CustomFieldsByContactId](Teamleader.V2.CustomFieldsByContactId): Custom Fields by Contact ID
- [CustomFieldsByDealId](Teamleader.V2.CustomFieldsByDealId): Custom Fields by Deal ID
- [CustomFieldsByInvoiceId](Teamleader.V2.CustomFieldsByInvoiceId): Custom Fields by Invoice ID
- [CustomFieldsByMilestoneId](Teamleader.V2.CustomFieldsByMilestoneId): Custom Fields by Milestone ID
- [CustomFieldsByProductId](Teamleader.V2.CustomFieldsByProductId): Custom Fields by Product ID
- [CustomFieldsByProjectId](Teamleader.V2.CustomFieldsByProjectId): Custom Fields by Project ID
- [CustomFieldsBySubscriptionId](Teamleader.V2.CustomFieldsBySubscriptionId): Custom Fields by Subscription ID
- [CustomFieldsByTaskId](Teamleader.V2.CustomFieldsByTaskId): Custom Fields by Task ID
- [DayOffTypes](Teamleader.V2.DayOffTypes): Day-off Types
- [DealById](Teamleader.V2.DealById): Deal by ID
- [DealPhaseHistoryByDealId](Teamleader.V2.DealPhaseHistoryByDealId): Deal Phase History by Deal ID
- [DealPhases](Teamleader.V2.DealPhases): Deal Phases
- [DealPipelines](Teamleader.V2.DealPipelines): Deal Pipelines
- [DealSources](Teamleader.V2.DealSources): Deal Sources
- [Deals](Teamleader.V2.Deals): Deals
- [DepartmentById](Teamleader.V2.DepartmentById): Department by ID
- [Departments](Teamleader.V2.Departments): Departments
- [DocumentTemplates](Teamleader.V2.DocumentTemplates): Document Templates
- [EmailTrackingAttachmentsByTypeAndId](Teamleader.V2.EmailTrackingAttachmentsByTypeAndId): Email Tracking Attachments
- [EmailTrackingsByTypeAndId](Teamleader.V2.EmailTrackingsByTypeAndId): Email Trackings
- [EventAttendees](Teamleader.V2.EventAttendees): Event Attendees
- [EventLinks](Teamleader.V2.EventLinks): Event Links
- [Events](Teamleader.V2.Events): Events
- [Expenses](Teamleader.V2.Expenses): Expenses
- [FileById](Teamleader.V2.FileById): File by ID
- [FilesByTypeAndId](Teamleader.V2.FilesByTypeAndId): Files by Type And ID
- [IncomingCreditNoteById](Teamleader.V2.IncomingCreditNoteById): Incoming Credit Note by ID
- [IncomingInvoiceById](Teamleader.V2.IncomingInvoiceById): Incoming Invoice by ID
- [InvoiceById](Teamleader.V2.InvoiceById): Invoice by ID
- [InvoiceGroupedLinesById](Teamleader.V2.InvoiceGroupedLinesById): Invoice Grouped Lines by ID
- [InvoiceLinesById](Teamleader.V2.InvoiceLinesById): Invoice Lines by ID
- [InvoiceTaxes](Teamleader.V2.InvoiceTaxes): Invoice Taxes
- [Invoices](Teamleader.V2.Invoices): Invoices
- [LevelTwoAreasByCountry](Teamleader.V2.LevelTwoAreasByCountry): Level 2 Areas by Country
- [LostReasons](Teamleader.V2.LostReasons): Lost Reasons
- [MailTemplates](Teamleader.V2.MailTemplates): Mail Templates
- [MaterialByIdV2](Teamleader.V2.MaterialByIdV2): Material by ID
- [MaterialsV2](Teamleader.V2.MaterialsV2): Materials
- [Me](Teamleader.V2.Me): Me
- [MeetingAttendees](Teamleader.V2.MeetingAttendees): Meeting Attendees
- [MeetingById](Teamleader.V2.MeetingById): Meeting by ID
- [Meetings](Teamleader.V2.Meetings): Meetings
- [MilestoneById](Teamleader.V2.MilestoneById): Milestone by ID
- [Milestones](Teamleader.V2.Milestones): Milestones
- [MyTelephones](Teamleader.V2.MyTelephones): My Telephones
- [NotesById](Teamleader.V2.NotesById): Notes
- [OrderById](Teamleader.V2.OrderById): Order by ID
- [OrderGroupedLinesByOrderId](Teamleader.V2.OrderGroupedLinesByOrderId): Order Grouped Lines by Order ID
- [OrderLinesByOrderId](Teamleader.V2.OrderLinesByOrderId): Order Lines by Order ID
- [Orders](Teamleader.V2.Orders): Orders
- [PaymentMethods](Teamleader.V2.PaymentMethods): Payment Methods
- [PaymentTerms](Teamleader.V2.PaymentTerms): Payment Terms
- [PriceLists](Teamleader.V2.PriceLists): Price Lists
- [ProductById](Teamleader.V2.ProductById): Product by ID
- [ProductCategories](Teamleader.V2.ProductCategories): Product Categories
- [ProductCategoryLedgers](Teamleader.V2.ProductCategoryLedgers): Product Category Ledgers
- [Products](Teamleader.V2.Products): Products
- [ProjectAssigneesByProjectIdV2](Teamleader.V2.ProjectAssigneesByProjectIdV2): Project Assignees by ID
- [ProjectAssigneesV2](Teamleader.V2.ProjectAssigneesV2): Projects
- [ProjectById](Teamleader.V2.ProjectById): Project by ID
- [ProjectByIdV2](Teamleader.V2.ProjectByIdV2): Project by ID
- [ProjectCustomersV2](Teamleader.V2.ProjectCustomersV2): Project Customers
- [ProjectDealsV2](Teamleader.V2.ProjectDealsV2): Project Deals
- [ProjectGroupsV2](Teamleader.V2.ProjectGroupsV2): Project Groups
- [ProjectItemsByProjectId](Teamleader.V2.ProjectItemsByProjectId): Project Items
- [ProjectLinesByProjectIdV2](Teamleader.V2.ProjectLinesByProjectIdV2): Project Lines
- [ProjectMilestonesByProjectId](Teamleader.V2.ProjectMilestonesByProjectId): Project Milestones by Project ID
- [ProjectOwnersV2](Teamleader.V2.ProjectOwnersV2): Projects
- [ProjectParticipantsByProjectId](Teamleader.V2.ProjectParticipantsByProjectId): Project Participants by Project ID
- [ProjectQuotationsV2](Teamleader.V2.ProjectQuotationsV2): Projects
- [Projects](Teamleader.V2.Projects): Projects
- [ProjectsV2](Teamleader.V2.ProjectsV2): Projects
- [ProjectsV2Status](Teamleader.V2.ProjectsV2Status): Projects Status (V2)
- [QuotationById](Teamleader.V2.QuotationById): Quotation by ID
- [QuotationGroupedLinesById](Teamleader.V2.QuotationGroupedLinesById): Quotation Grouped Lines by ID
- [QuotationLinesById](Teamleader.V2.QuotationLinesById): Quotation Lines by ID
- [Quotations](Teamleader.V2.Quotations): Quotations
- [ReceiptById](Teamleader.V2.ReceiptById): Receipt by ID
- [SubscriptionById](Teamleader.V2.SubscriptionById): Subscription By ID
- [SubscriptionGroupedLinesBySubscriptionId](Teamleader.V2.SubscriptionGroupedLinesBySubscriptionId): Subscription Grouped Lines by Subscription ID
- [SubscriptionLinesBySubscriptionId](Teamleader.V2.SubscriptionLinesBySubscriptionId): Subscription Lines by Subscription ID
- [Subscriptions](Teamleader.V2.Subscriptions): Subscriptions
- [Tags](Teamleader.V2.Tags): Tags
- [TaskAssigneesByTaskIdV2](Teamleader.V2.TaskAssigneesByTaskIdV2): Task Assignees by ID
- [TaskById](Teamleader.V2.TaskById): Task by ID
- [TaskByIdV2](Teamleader.V2.TaskByIdV2): Task by ID
- [Tasks](Teamleader.V2.Tasks): Tasks
- [TasksV2](Teamleader.V2.TasksV2): Projects
- [TaxRates](Teamleader.V2.TaxRates): Tax Rates
- [TeamMembers](Teamleader.V2.TeamMembers): Team Members
- [Teams](Teamleader.V2.Teams): Teams
- [TicketById](Teamleader.V2.TicketById): Ticket by ID
- [TicketMessagesByTicketId](Teamleader.V2.TicketMessagesByTicketId): Ticket Messages
- [TicketStatuses](Teamleader.V2.TicketStatuses): Ticket Statuses
- [Tickets](Teamleader.V2.Tickets): Tickets
- [TimeTracking](Teamleader.V2.TimeTracking): Time Tracking
- [TimeTrackingById](Teamleader.V2.TimeTrackingById): Time Tracking by ID
- [TimeTrackingMaterials](Teamleader.V2.TimeTrackingMaterials): Time Tracking Materials
- [TimeTrackingMaterialsByTimeTrackingId](Teamleader.V2.TimeTrackingMaterialsByTimeTrackingId): Time Tracking Materials By Time Tracking ID
- [UnitsOfMeasure](Teamleader.V2.UnitsOfMeasure): Units Of Measure
- [UserDaysOffByUserId](Teamleader.V2.UserDaysOffByUserId): Days-off by User ID
- [UserTeams](Teamleader.V2.UserTeams): User Teams
- [UserTelephones](Teamleader.V2.UserTelephones): User Telephones
- [UserWeekScheduleByUserId](Teamleader.V2.UserWeekScheduleByUserId): User Week Schedule by User ID
- [Users](Teamleader.V2.Users): Users
- [WebhookTypes](Teamleader.V2.WebhookTypes): Webhook Types
- [Webhooks](Teamleader.V2.Webhooks): Webhooks
- [WithholdingTaxRates](Teamleader.V2.WithholdingTaxRates): With-holding Tax Rates
- [WorkTypes](Teamleader.V2.WorkTypes): Work Types

### Teamleader.V2Flat

- [CallsAll](Teamleader.V2Flat.CallsAll): Calls
- [CompaniesAll](Teamleader.V2Flat.CompaniesAll): Companies
- [CompanyAddresses](Teamleader.V2Flat.CompanyAddresses): Company Addresses
- [CompanyCustomFieldValues](Teamleader.V2Flat.CompanyCustomFieldValues): Company Custom Field Values
- [CompanyEmailTrackingAttachmentsAll](Teamleader.V2Flat.CompanyEmailTrackingAttachmentsAll): Company Email Tracking Attachments
- [CompanyEmailTrackingsAll](Teamleader.V2Flat.CompanyEmailTrackingsAll): Company Email Trackings
- [CompanyFilesAll](Teamleader.V2Flat.CompanyFilesAll): Company Files
- [CompanyNotesAll](Teamleader.V2Flat.CompanyNotesAll): Company Notes
- [ContactAddresses](Teamleader.V2Flat.ContactAddresses): Contact Addresses
- [ContactCompanies](Teamleader.V2Flat.ContactCompanies): Calls
- [ContactCustomFieldValues](Teamleader.V2Flat.ContactCustomFieldValues): Contact Custom Field Values
- [ContactEmailTrackingAttachmentsAll](Teamleader.V2Flat.ContactEmailTrackingAttachmentsAll): Contact Email Tracking Attachments
- [ContactEmailTrackingsAll](Teamleader.V2Flat.ContactEmailTrackingsAll): Contact Email Trackings
- [ContactFilesAll](Teamleader.V2Flat.ContactFilesAll): Contact Files
- [ContactNotesAll](Teamleader.V2Flat.ContactNotesAll): Contact Notes
- [ContactsAll](Teamleader.V2Flat.ContactsAll): Contacts
- [CreditNoteEmailTrackingAttachmentsAll](Teamleader.V2Flat.CreditNoteEmailTrackingAttachmentsAll): Credit Note Email Tracking Attachments
- [CreditNoteEmailTrackingsAll](Teamleader.V2Flat.CreditNoteEmailTrackingsAll): Credit Note Email Trackings
- [CreditNoteFilesAll](Teamleader.V2Flat.CreditNoteFilesAll): Creditnote File
- [CreditNoteGroupedLines](Teamleader.V2Flat.CreditNoteGroupedLines): Credit Note Grouped Lines
- [CreditNoteLines](Teamleader.V2Flat.CreditNoteLines): Credit Note Lines
- [CreditNoteNotesAll](Teamleader.V2Flat.CreditNoteNotesAll): Credit Note Notes
- [CreditNotes](Teamleader.V2Flat.CreditNotes): Credit Notes
- [DealCustomFieldValues](Teamleader.V2Flat.DealCustomFieldValues): Deal Custom Field Values
- [DealEmailTrackingAttachmentsAll](Teamleader.V2Flat.DealEmailTrackingAttachmentsAll): Deal Email Tracking Attachments
- [DealEmailTrackingsAll](Teamleader.V2Flat.DealEmailTrackingsAll): Deal Email Trackings
- [DealFilesAll](Teamleader.V2Flat.DealFilesAll): Deal Files
- [DealNotesAll](Teamleader.V2Flat.DealNotesAll): Deal Notes
- [DealPhaseHistories](Teamleader.V2Flat.DealPhaseHistories): Deal Phase Histories
- [DealsAll](Teamleader.V2Flat.DealsAll): Deals
- [DepartmentsAll](Teamleader.V2Flat.DepartmentsAll): Departments
- [InvoiceCustomFieldValues](Teamleader.V2Flat.InvoiceCustomFieldValues): Invoice Custom Field Values
- [InvoiceEmailTrackingAttachmentsAll](Teamleader.V2Flat.InvoiceEmailTrackingAttachmentsAll): Invoice Email Tracking Attachments
- [InvoiceEmailTrackingsAll](Teamleader.V2Flat.InvoiceEmailTrackingsAll): Invoice Email Trackings
- [InvoiceFilesAll](Teamleader.V2Flat.InvoiceFilesAll): Invoice Files
- [InvoiceLinesAll](Teamleader.V2Flat.InvoiceLinesAll): Invoice Lines
- [InvoiceNotesAll](Teamleader.V2Flat.InvoiceNotesAll): Invoice Notes
- [MeetingsAll](Teamleader.V2Flat.MeetingsAll): Meetings
- [MilestoneCustomFieldValues](Teamleader.V2Flat.MilestoneCustomFieldValues): Milestone Custom Field Values
- [OrderGroupedLinesAll](Teamleader.V2Flat.OrderGroupedLinesAll): Order Grouped Lines
- [OrderLinesAll](Teamleader.V2Flat.OrderLinesAll): Order Lines
- [ProductCustomFieldValues](Teamleader.V2Flat.ProductCustomFieldValues): Product Custom Field Values
- [ProductEmailTrackingAttachmentsAll](Teamleader.V2Flat.ProductEmailTrackingAttachmentsAll): Product Email Tracking Attachments
- [ProductEmailTrackingsAll](Teamleader.V2Flat.ProductEmailTrackingsAll): Product Email Trackings
- [ProductNotesAll](Teamleader.V2Flat.ProductNotesAll): Product Notes
- [ProductsAll](Teamleader.V2Flat.ProductsAll): Products
- [ProjectAssigneesV2All](Teamleader.V2Flat.ProjectAssigneesV2All): Project Assignees
- [ProjectCustomFieldValues](Teamleader.V2Flat.ProjectCustomFieldValues): Project Custom Field Values
- [ProjectFilesV2All](Teamleader.V2Flat.ProjectFilesV2All): Project Files
- [ProjectItems](Teamleader.V2Flat.ProjectItems): Project Items
- [ProjectLinesV2All](Teamleader.V2Flat.ProjectLinesV2All): Project Lines
- [ProjectMilestones](Teamleader.V2Flat.ProjectMilestones): Project Milestones
- [ProjectNotesV2All](Teamleader.V2Flat.ProjectNotesV2All): Project Notes
- [ProjectParticipants](Teamleader.V2Flat.ProjectParticipants): Project Participants
- [ProjectV2EmailTrackingAttachmentsAll](Teamleader.V2Flat.ProjectV2EmailTrackingAttachmentsAll): Project Email Tracking Attachments
- [ProjectV2EmailTrackingsAll](Teamleader.V2Flat.ProjectV2EmailTrackingsAll): Project Email Trackings
- [ProjectsAll](Teamleader.V2Flat.ProjectsAll): Projects
- [QuotationEmailTrackingAttachmentsAll](Teamleader.V2Flat.QuotationEmailTrackingAttachmentsAll): Quotation Email Tracking Attachments
- [QuotationEmailTrackingsAll](Teamleader.V2Flat.QuotationEmailTrackingsAll): Quotation Email Trackings
- [QuotationLinesAll](Teamleader.V2Flat.QuotationLinesAll): Quotation Lines
- [QuotationNotesAll](Teamleader.V2Flat.QuotationNotesAll): Quotation Notes
- [SubscriptionCustomFieldValues](Teamleader.V2Flat.SubscriptionCustomFieldValues): Subscription Custom Field Values
- [SubscriptionEmailTrackingAttachmentsAll](Teamleader.V2Flat.SubscriptionEmailTrackingAttachmentsAll): Subscription Email Tracking Attachments
- [SubscriptionEmailTrackingsAll](Teamleader.V2Flat.SubscriptionEmailTrackingsAll): Subscription Email Trackings
- [SubscriptionGroupedLinesAll](Teamleader.V2Flat.SubscriptionGroupedLinesAll): Subscription Grouped Lines
- [SubscriptionLinesAll](Teamleader.V2Flat.SubscriptionLinesAll): Subscription Lines
- [SubscriptionNotesAll](Teamleader.V2Flat.SubscriptionNotesAll): Subscription Notes
- [TaskAssigneesV2All](Teamleader.V2Flat.TaskAssigneesV2All): Task Assignees
- [TaskCustomFieldValues](Teamleader.V2Flat.TaskCustomFieldValues): Task Custom Field Values
- [TasksAll](Teamleader.V2Flat.TasksAll): Tasks
- [TicketFilesAll](Teamleader.V2Flat.TicketFilesAll): Ticket Files
- [TicketMessagesAll](Teamleader.V2Flat.TicketMessagesAll): Ticket Messages
- [TicketsAll](Teamleader.V2Flat.TicketsAll): Tickets
- [TimeTrackingAll](Teamleader.V2Flat.TimeTrackingAll): Time Tracking
- [TimeTrackingMaterials](Teamleader.V2Flat.TimeTrackingMaterials): Time Tracking Materials
- [UserDaysOffAll](Teamleader.V2Flat.UserDaysOffAll): User Days-off
- [UserEvents](Teamleader.V2Flat.UserEvents): User Events
- [UserWeekSchedulesAll](Teamleader.V2Flat.UserWeekSchedulesAll): User Week Schedules

## Sample Queries

```sql
--
-- List of companies with all detail and custom fields. Very slow, with solely 1 row per second over prolonged periods of time.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/teamleader-data-model/webhelp/teamleader-focus-connector-v2flat-companiesall.html
--
-- Related forum post: https://forums.invantive.eu/t/what-are-table-functions-and-table-function-parameters/1868
--
select *
from   Teamleader.V2Flat.CompaniesAll@tlr
limit  100
```

```sql
--
-- List of projects. Fast, but excludes custom fields value and some detail columns.
--
-- Table documentation: https://documentation.invantive.eu/2017R2/teamleader-data-model/webhelp/invantive-teamleader-provider-teamleader-v2-projects.html
--
-- Related forum post: https://forums.invantive.eu/t/most-popular-teamleader-focus-tables-for-2022/2569
--
select *
from   Teamleader.V2.Projects@tlr
limit  100
```

## Attributes

The attributes of this platform are on the page [Attributes](attributes).



## Release Notes

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

- [Teamleader Focus](/en/release-notes/drivers?driver=teamleader-focus)

