timetracking_entry: Time Tracking Entry |
https://online-sql-editor.com/teamleader/eu/stable/Sql?appendSqlQuery=select+*%0D%0Afrom+++Teamleader.V1.timetracking_entry%0D%0Alimit++1000
Name: timetracking_entry
Catalog: Teamleader
Schema: V1
Primary Keys: id
Label: Time Tracking Entry
Partition-specific: false
Select: true
Insert: false
Update: false
Delete: false
Select Service URL (OData-specific): getTimetrackingEntry.php
Insert Service URL (OData-specific): getTimetrackingEntry.php
Update Service URL (OData-specific): getTimetrackingEntry.php
Delete Service URL (OData-specific): getTimetrackingEntry.php
Field Selection Method (OData-specific): NotRequired
Table Columns
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
company_id |
int32 |
Company ID |
☐ |
|
contact_id |
int32 |
Contact ID |
☐ |
|
date |
datetime |
Date |
☐ |
|
date_formatted |
string(20) |
Date (Formatted) |
☐ |
|
description |
string |
Description |
☐ |
|
duration |
int32 |
Duration |
☐ |
|
employee_name |
string |
Employee Name |
☐ |
|
id |
int32 |
ID |
☑ |
|
is_invoiceable |
boolean |
Is Invoiceable? |
☑ |
|
milestone_id |
int32 |
Milestone ID |
☐ |
|
milestone_title |
string |
Milestone Title |
☐ |
|
project_id |
int32 |
Project ID |
☐ |
|
project_title |
string |
Project Title |
☐ |
|
related_to_id |
int32 |
Related to ID |
☐ |
|
related_to_type |
string |
Related to Type |
☐ |
|
ticket_id |
int32 |
Ticket ID |
☐ |
|
user_id |
int32 |
User ID |
☐ |
|
10-09-2020 00:0920.1.206-BETA+2915