Please enable JavaScript to view this site.

Teamleader API Data Model

Navigation: Schema: V2Flat > Tables

ProjectCustomFieldValues

Contents Previous Home Next More

Catalog: Teamleader

Schema: V2Flat

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 ProjectCustomFieldValues are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

cfd_group

string

Group

 

cfd_label

string

Label

 

cfd_required

boolean

Required

 

cfd_type

string

Type

 

pfe_definition_id

string

 

 

pfe_definition_type

string

 

 

pfe_project_id

string

Project ID

 

pfe_value_as_array

string

 

 

pfe_value_as_boolean

boolean

 

 

pfe_value_as_number

decimal

 

 

pfe_value_as_string

string

 

 

pfe_value_object_id

string

 

 

pfe_value_object_type

string

 

 

pjt_actuals_billable_amount_amount

decimal

 

 

pjt_actuals_billable_amount_currency

string

 

 

pjt_actuals_costs_amount

string

 

 

pjt_actuals_costs_currency

string

 

 

pjt_actuals_profit_percentage

string

 

 

pjt_actuals_result_amount

string

 

 

pjt_actuals_result_currency

string

 

 

pjt_budget_allocated_amount

decimal

 

 

pjt_budget_allocated_currency

string

 

 

pjt_budget_forecasted_amount

decimal

 

 

pjt_budget_forecasted_currency

string

 

 

pjt_budget_provided_amount

decimal

 

 

pjt_budget_provided_currency

string

 

 

pjt_budget_remaining_amount

decimal

 

 

pjt_budget_remaining_currency

string

 

 

pjt_budget_spent_materials_amount

decimal

 

 

pjt_budget_spent_materials_currency

string

 

 

pjt_budget_spent_time_amount

decimal

 

 

pjt_budget_spent_time_currency

string

 

 

pjt_budget_spent_total_amount

decimal

 

 

pjt_budget_spent_total_currency

string

 

 

pjt_customer_id

string

Customer ID

 

pjt_customer_type

string

Customer Type

 

pjt_description

string

Description

 

pjt_due_on

datetime

Due on

 

pjt_id

string

ID

 

pjt_reference

string

Reference

 

pjt_source_id

string

Source ID

 

pjt_source_type

string

Source Type

 

pjt_starts_on

datetime

Starts on

 

pjt_status

string

Status

 

pjt_title

string

Title

 

 

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