Please enable JavaScript to view this site.

Error itgendoc001X

xMsg javascript has not been loaded.

Simplicate API Data Model

Navigation: Schema: Projects > Tables

ProjectEmployeeProjects

Contents Previous Home Next More

Fetches all projects

Catalog: Simplicate

Schema: Projects

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

Select Simplicate API URL: /projects/project

Insert Simplicate API URL: /projects/project

Update Simplicate API URL: /projects/project

Delete Simplicate API URL: /projects/project

Field Selection Method: NotRequired

Base Path: data[*].employees[*]

Select Simplicate API Operation: get /projects/project

Table Function Columns

The columns of the table function ProjectEmployeeProjects are shown below. Each column has an SQL data type.

Name

Data Type

Label

Required

Documentation

abnormal_address

boolean

 

 

abnormal_contact_id

string

 

 

abnormal_organization_id

string

 

 

abnormal_person_id

string

 

 

amount

float

 

 

billable

boolean

 

 

budget_costs_value_budget

float

 

 

budget_costs_value_spent

float

 

 

budget_hours_amount_budget

float

 

 

budget_hours_amount_spent

float

 

 

budget_hours_value_budget

float

 

 

budget_hours_value_spent

float

 

 

budget_total_value_budget

float

 

 

budget_total_value_invoiced

float

 

 

budget_total_value_spent

float

 

 

can_register_mileage

boolean

 

 

contact_id_1

string

 

 

contact_id

string

 

 

contact_organization_id

string

 

 

contact_organization_name

string

 

 

contact_person_full_name

string

 

 

contact_person_id

string

 

 

created_at

string

Created at

 

created

string

Created

 

declarable

string

 

 

divergent_payment_term_days

int64

 

 

divergent_payment_term_id

string

 

 

divergent_payment_term_method

string

 

 

divergent_payment_term_name

string

 

 

employee_id

string

Employee ID

 

end_date

string

End Date

 

hours_rate_type

string

 

 

id_1

string

 

 

id

string

ID

 

invoice_reference

string

 

 

is_invoice_approval

boolean

 

 

is_reverse_billing

boolean

 

 

modified

string

Modified

 

my_organization_profile_id_1

string

 

 

my_organization_profile_id

string

 

 

my_organization_profile_organization_id

string

 

 

my_organization_profile_organization_name

string

 

 

name_1

string

 

 

name

string

Name

 

note

string

Note

 

organization_id_1

string

 

 

organization_id

string

Organization ID

 

organization_name

string

Organization Name

 

person_full_name

string

 

 

person_id_1

string

 

 

person_id_2

string

 

 

person_id

string

Person ID

 

project_manager_amount

float

 

 

project_manager_declarable

string

 

 

project_manager_employee_id

string

 

 

project_manager_id

string

 

 

project_manager_name

string

 

 

project_manager_person_id

string

 

 

project_manager_tariff

float

 

 

project_number

string

 

 

project_status_color

string

 

 

project_status_id

string

 

 

project_status_label

string

 

 

separate_invoice_recipient_contact_id

string

 

 

separate_invoice_recipient_contact_organization_id

string

 

 

separate_invoice_recipient_contact_organization_name

string

 

 

separate_invoice_recipient_contact_person_full_name

string

 

 

separate_invoice_recipient_contact_person_id

string

 

 

separate_invoice_recipient_is_separate_invoice_recipient

boolean

 

 

separate_invoice_recipient_organization_id

string

 

 

separate_invoice_recipient_organization_name

string

 

 

separate_invoice_recipient_person_full_name

string

 

 

separate_invoice_recipient_person_id

string

 

 

simplicate_url

string

Simplicate URL

 

start_date

string

Start Date

 

tariff

float

 

 

timeline_email_address

string

 

 

updated_at

string

Updated at

 

 

06-04-2021 14:59 Version 20.1.393-BETA+3152