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_ |
varchar2 |
Tlr Project Customer ID | project_ |
||
PROJECT_ |
varchar2 |
Tlr Project Reference | project_ |
||
PROJECT_ |
varchar2 |
Tlr Project Status | project_ |
||
PROJECT_ |
varchar2 |
Tlr Project Title | project_ |
||
billing_ |
varchar2 |
Billing Info Invoice ID | filters on the platform, writable | ||
company_ |
varchar2 |
Tlr Company Name | filters on the platform, writable, company_ |
||
company_ |
varchar2 |
Tlr Company Status | filters on the platform, writable, company_ |
||
contact_ |
varchar2 |
Tlr Contact First Name | filters on the platform, writable, contact_ |
||
contact_ |
varchar2 |
Tlr Contact ID | filters on the platform, writable, contact_ |
||
contact_ |
varchar2 |
Tlr Contact Last Name | filters on the platform, writable, contact_ |
||
contact_ |
varchar2 |
Tlr Contact Status | filters on the platform, writable, contact_ |
||
description |
varchar2 |
Description | filters on the platform, writable | ||
duration |
int64 |
Duration | filters on the platform, writable | Duration in seconds. | |
ended_ |
datetime |
Ended at | filters on the platform, writable | ||
event_ |
datetime |
Tlr Event Ends At | filters on the platform, writable, event_ |
||
event_ |
datetime |
Tlr Event Starts At | filters on the platform, writable, event_ |
||
event_ |
varchar2 |
Tlr Event Title | filters on the platform, writable, event_ |
||
hourly_ |
decimal |
Hourly Rate Amount | filters on the platform, writable | ||
hourly_ |
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_ |
varchar2 |
Tlr Milestone ID | filters on the platform, writable, milestone_ |
||
milestone_ |
varchar2 |
Tlr Milestone Name | filters on the platform, writable, milestone_ |
||
milestone_ |
varchar2 |
Tlr Milestone Project ID | filters on the platform, writable, milestone_ |
||
milestone_ |
varchar2 |
Tlr Milestone Status | filters on the platform, writable, milestone_ |
||
project_ |
varchar2 |
Tlr Project Direct Customer ID | filters on the platform, writable, project_ |
||
project_ |
varchar2 |
Tlr Project Direct ID | filters on the platform, writable, project_ |
||
project_ |
varchar2 |
Tlr Project Direct Reference | filters on the platform, writable, project_ |
||
project_ |
varchar2 |
Tlr Project Direct Status | filters on the platform, writable, project_ |
||
project_ |
varchar2 |
Tlr Project Direct Title | filters on the platform, writable, project_ |
||
started_ |
datetime |
Started at | filters on the platform, writable | ||
started_ |
datetime |
Started on | filters on the platform, writable | ||
subject_ |
varchar2 |
Subject ID | filters on the platform, writable | ||
subject_ |
varchar2 |
Subject Type | filters on the platform, writable | ||
task_ |
char |
Tlr Task Completed | filters on the platform, writable, task_ |
||
task_ |
varchar2 |
Tlr Task ID | filters on the platform, writable, task_ |
||
task_ |
varchar2 |
Tlr Task Title | filters on the platform, writable, task_ |
||
user_ |
varchar2 |
User ID | filters on the platform, writable | ||
user_ |
varchar2 |
User Type | filters on the platform, writable | ||
work_ |
varchar2 |
Work Type ID | filters on the platform, writable | ||
work_ |
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: