invantive documentation
Invantive Support ForumsLog In / Sign Up

TimeTrackingAll: Teamleader Focus Time Tracking

read only

  • Catalog: Teamleader
  • Schema: V2Flat
  • Label: Time Tracking

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 TimeTrackingAll 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
PROJECT_CUSTOMER_ID varchar2 Tlr Project Customer ID project_customer_id
PROJECT_REFERENCE varchar2 Tlr Project Reference project_reference
PROJECT_STATUS varchar2 Tlr Project Status project_status
PROJECT_TITLE varchar2 Tlr Project Title project_title
billing_info_invoice_id varchar2 Billing Info Invoice ID filters on the platform, writable
company_name varchar2 Tlr Company Name filters on the platform, writable, company_name
company_status varchar2 Tlr Company Status filters on the platform, writable, company_status
contact_first_name varchar2 Tlr Contact First Name filters on the platform, writable, contact_first_name
contact_id varchar2 Tlr Contact ID filters on the platform, writable, contact_id
contact_last_name varchar2 Tlr Contact Last Name filters on the platform, writable, contact_last_name
contact_status varchar2 Tlr Contact Status filters on the platform, writable, contact_status
description varchar2 Description filters on the platform, writable
duration int64 Duration filters on the platform, writable Duration in seconds.
ended_at datetime Ended at filters on the platform, writable
event_ends_at datetime Tlr Event Ends At filters on the platform, writable, event_ends_at
event_starts_at datetime Tlr Event Starts At filters on the platform, writable, event_starts_at
event_title varchar2 Tlr Event Title filters on the platform, writable, event_title
hourly_rate_amount decimal Hourly Rate Amount filters on the platform, writable
hourly_rate_currency varchar2 Hourly Rate Currency filters on the platform, writable
id varchar2 ID filters on the platform, writable
invoiceable char Invoiceable filters on the platform, writable
milestone_id varchar2 Tlr Milestone ID filters on the platform, writable, milestone_id
milestone_name varchar2 Tlr Milestone Name filters on the platform, writable, milestone_name
milestone_project_id varchar2 Tlr Milestone Project ID filters on the platform, writable, milestone_project_id
milestone_status varchar2 Tlr Milestone Status filters on the platform, writable, milestone_status
project_direct_customer_id varchar2 Tlr Project Direct Customer ID filters on the platform, writable, project_direct_customer_id
project_direct_id varchar2 Tlr Project Direct ID filters on the platform, writable, project_direct_id
project_direct_reference varchar2 Tlr Project Direct Reference filters on the platform, writable, project_direct_reference
project_direct_status varchar2 Tlr Project Direct Status filters on the platform, writable, project_direct_status
project_direct_title varchar2 Tlr Project Direct Title filters on the platform, writable, project_direct_title
started_at datetime Started at filters on the platform, writable
started_on datetime Started on filters on the platform, writable
subject_id varchar2 Subject ID filters on the platform, writable
subject_type varchar2 Subject Type filters on the platform, writable
task_completed char Tlr Task Completed filters on the platform, writable, task_completed
task_id varchar2 Tlr Task ID filters on the platform, writable, task_id
task_title varchar2 Tlr Task Title filters on the platform, writable, task_title
user_id varchar2 User ID filters on the platform, writable
user_type varchar2 User Type filters on the platform, writable
work_type_id varchar2 Work Type ID filters on the platform, writable
work_type_type varchar2 Work Type Type filters on the platform, writable

Release Notes

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