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