Please enable JavaScript to view this site.

Navigation: Schema: Projects > Tables

ProjectEmployeeProjects: Simplicate Project Employee Projects

Fetches all projects

Catalog: Simplicate

Schema: Projects

Label: Project Employee 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 Address

 

abnormal_contact_id

string

Abnormal Contact ID

 

abnormal_organization_id

string

Abnormal Organization ID

 

abnormal_person_id

string

Abnormal Person ID

 

amount

float

Amount

 

billable

boolean

Billable

 

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

Can Register Mileage

 

contact_id_1

string

 

 

contact_id

string

Contact ID

 

contact_organization_id

string

Contact Organization ID

 

contact_organization_name

string

Contact Organization Name

 

contact_person_full_name

string

Contact Person Full Name

 

contact_person_id

string

Contact Person ID

 

created_at

string

Created at

 

created

string

Created

 

declarable

string

Declarable

 

divergent_payment_term_days

int64

Divergent Payment Term (days)

 

divergent_payment_term_id

string

Divergent Payment Term ID

 

divergent_payment_term_method

string

Divergent Payment Term Method

 

divergent_payment_term_name

string

Divergent Payment Term Name

 

employee_id

string

Employee ID

 

end_date

string

End Date

 

hours_rate_type

string

Hours Rate Type

 

id_1

string

 

 

id

string

ID

 

invoice_reference

string

Invoice Reference

 

is_invoice_approval

boolean

Is Invoice Approval

 

is_reverse_billing

boolean

Is Reverse Billing

 

modified

string

Modified

 

my_organization_profile_id_1

string

 

 

my_organization_profile_id

string

My Organization Profile ID

 

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 Full Name

 

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 Number

 

project_status_color

string

Project Status Color

 

project_status_id

string

Project Status ID

 

project_status_label

string

Project Status Label

 

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

Tariff

 

timeline_email_address

string

Timeline Email Address

 

updated_at

string

Updated at

 

 

15-06-2022 20:27 Version 22.0.232-PROD+3445