Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Teamleader API Data Model

Navigation: Schema: V1Flat > Tables

TimeTracking54Weeks

Contents Previous Home Next More

Catalog: Teamleader

Schema: V1Flat

This is a read-only view. The Teamleader API may not support changing the data or the Invantive SQL driver for Teamleader does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Teamleader API.

View Columns

The columns of the view TimeTracking54Weeks are shown below. Each column has an SQL data type.

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

 

 

12-12-2020 19:52 Version 20.1.301-BETA+3023