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