ProjectSpreadAssignments: Simplicate Project Spread Assignments |
Fetches all available assignments for projects
Catalog: Simplicate
Schema: Projects
Label: Project Spread Assignments
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/assignment
Insert Simplicate API URL: /projects/assignment
Update Simplicate API URL: /projects/assignment
Delete Simplicate API URL: /projects/assignment
Field Selection Method: NotRequired
Base Path: data[*].spread[*]
Select Simplicate API Operation: get /projects/assignment
Table Function Columns
The columns of the table function ProjectSpreadAssignments are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
description |
string |
Description |
☐ |
|
end_date |
string |
End Date |
☐ |
|
hours_total |
float |
Hours Total |
☐ |
|
hours_type |
string |
Hours Type |
☐ |
|
hours |
float |
Hours |
☐ |
|
id |
string |
ID |
☐ |
|
is_planned |
boolean |
Is Planned |
☐ |
|
name |
string |
Name |
☐ |
|
project_id |
string |
Project ID |
☐ |
|
project_name |
string |
Project Name |
☐ |
|
project_organization_id |
string |
Project Organization ID |
☐ |
|
project_organization_name |
string |
Project Organization Name |
☐ |
|
project_person_full_name |
string |
Project Person Full Name |
☐ |
|
project_person_id |
string |
Project Person ID |
☐ |
|
project_project_manager_amount |
float |
Project Manager Amount |
☐ |
|
project_project_manager_declarable |
string |
Project Manager Declarable |
☐ |
|
project_project_manager_employee_id |
string |
Project Manager Employee ID |
☐ |
|
project_project_manager_id |
string |
Project Manager ID |
☐ |
|
project_project_manager_name |
string |
Project Manager Name |
☐ |
|
project_project_manager_person_id |
string |
Project Manager Person ID |
☐ |
|
project_project_manager_tariff |
float |
Project Manager Tariff |
☐ |
|
project_project_number |
string |
Project Number |
☐ |
|
project_separate_invoice_recipient_is_separate_invoice_recipient |
boolean |
Project Separate Invoice Recipient |
☐ |
|
projecthourstype_billable |
boolean |
|
☐ |
|
projecthourstype_budgeted_amount |
float |
|
☐ |
|
projecthourstype_color |
string |
|
☐ |
|
projecthourstype_hourstype_billable |
float |
|
☐ |
|
projecthourstype_hourstype_blocked |
boolean |
|
☐ |
|
projecthourstype_hourstype_color |
string |
|
☐ |
|
projecthourstype_hourstype_id |
string |
|
☐ |
|
projecthourstype_hourstype_label |
string |
|
☐ |
|
projecthourstype_hourstype_tariff |
float |
|
☐ |
|
projecthourstype_hourstype_type |
string |
|
☐ |
|
projecthourstype_hourstype_vatclass_code |
string |
|
☐ |
|
projecthourstype_hourstype_vatclass_id |
string |
|
☐ |
|
projecthourstype_hourstype_vatclass_label |
string |
|
☐ |
|
projecthourstype_hourstype_vatclass_name |
string |
|
☐ |
|
projecthourstype_hourstype_vatclass_percentage |
float |
|
☐ |
|
projecthourstype_id |
string |
|
☐ |
|
projecthourstype_tariff |
float |
|
☐ |
|
projectservice_default_service_id |
string |
|
☐ |
|
projectservice_id |
string |
Project Service ID |
☐ |
|
projectservice_name |
string |
Project Service Name |
☐ |
|
projectservice_revenue_group_id |
string |
|
☐ |
|
projectservice_use_in_resource_planner |
boolean |
|
☐ |
|
spent_amount |
string |
Spent Amount |
☐ |
|
start_date |
string |
Start Date |
☐ |
|
status_color |
string |
Status Color |
☐ |
|
status_created_at |
string |
Status Created at |
☐ |
|
status_id |
string |
Status ID |
☐ |
|
status_is_blocked |
boolean |
Status is Blocked |
☐ |
|
status_is_done |
boolean |
Status is Done |
☐ |
|
status_name |
string |
Status Name |
☐ |
|
status_order |
int64 |
Status Order |
☐ |
|
status_updated_at |
string |
Status Updated at |
☐ |
|
TEXT |
int64 |
|
☐ |
|
use_spread |
boolean |
Use Spread |
☐ |
|
15-06-2022 20:27 Version 22.0.232-PROD+3445