Please enable JavaScript to view this site.

Navigation: Schema: V2Flat > Tables

ProjectItems

Catalog: Teamleader

Schema: V2Flat

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

View Columns

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

Name

Data Type

Label

Required

Documentation

activity_type_id

string

 

 

activity_type_type

string

 

 

added_at

datetime

 

 

billable_price_per_unit_amount

decimal

 

 

billable_price_per_unit_currency

string

 

 

description

string

 

 

id

string

 

 

internal_cost_per_unit

decimal

 

 

milestone_id

string

 

 

milestone_type

string

 

 

occurred_at

datetime

 

 

participant_id

string

 

 

participant_type

string

 

 

product_id

string

 

 

product_type

string

 

 

project_id

string

 

 

project_type

string

 

 

quantity

decimal

 

 

total_billable_price_amount

decimal

 

 

total_billable_price_currency

string

 

 

total_internal_cost

decimal

 

 

tracked_time

string

 

 

unit

string

 

 

updated_at

datetime

 

 

worktype_id

string

 

 

worktype_type

string

 

 

 

29-05-2022 01:08 Version 22.0.196-PROD+3400