Please enable JavaScript to view this site.

Navigation: Schema: Projects > Tables

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