ProjectAssignmentById: Simplicate Project Assignment by ID
read only REST
- Catalog:
Simplicate - Schema:
Projects - Label: Project Assignment by ID
Fetches all a single assignment by its id
Can only retrieve data.
API Source
- Endpoint:
/projects/assignment/{id} - Operation:
get /projects/assignment/{id}
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
id |
`` | The template's id |
Table Columns
The columns of the table ProjectAssignmentById are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
created_ |
varchar2 |
Created at | |||
description |
varchar2 |
Description | |||
end_ |
varchar2 |
End Date | |||
hours |
double |
Hours | |||
hours_ |
double |
Hours Total | |||
hours_ |
varchar2 |
Hours Type | |||
id |
varchar2 |
ID | |||
is_ |
char |
Is Planned | |||
name |
varchar2 |
Name | |||
project_ |
char |
itgen_spe_project_has_register_mileage_enabled | |||
project_ |
varchar2 |
Project ID | |||
project_ |
varchar2 |
Project Name | |||
project_ |
varchar2 |
Project Organisation ID | |||
project_ |
varchar2 |
Project Organisation Name | |||
project_ |
varchar2 |
itgen_spe_project_organization_relation_number | |||
project_ |
varchar2 |
Project Person Full Name | |||
project_ |
varchar2 |
Project Person ID | |||
project_ |
varchar2 |
itgen_spe_project_person_relation_number | |||
project_ |
double |
Project Manager Amount | |||
project_ |
varchar2 |
Project Manager Declarable | |||
project_ |
varchar2 |
Project Manager Employee ID | |||
project_ |
varchar2 |
Project Manager ID | |||
project_ |
varchar2 |
Project Manager Name | |||
project_ |
varchar2 |
Project Manager Person ID | Added in order to comply with the original sales/sales responsible_employee response | ||
project_ |
double |
Project Manager Tariff | |||
project_ |
varchar2 |
Project Number | |||
projecthourstype_ |
char |
itgen_spe_projecthourstype_billable | |||
projecthourstype_ |
double |
itgen_spe_projecthourstype_budgeted_amount | |||
projecthourstype_ |
varchar2 |
itgen_spe_projecthourstype_color | |||
projecthourstype_ |
double |
itgen_spe_projecthourstype_hourstype_billable | |||
projecthourstype_ |
char |
itgen_spe_projecthourstype_hourstype_blocked | |||
projecthourstype_ |
varchar2 |
itgen_spe_projecthourstype_hourstype_color | |||
projecthourstype_ |
varchar2 |
itgen_spe_projecthourstype_hourstype_id | |||
projecthourstype_ |
varchar2 |
itgen_spe_projecthourstype_hourstype_label | |||
projecthourstype_ |
double |
itgen_spe_projecthourstype_hourstype_tariff | |||
projecthourstype_ |
varchar2 |
itgen_spe_projecthourstype_hourstype_type | |||
projecthourstype_ |
varchar2 |
itgen_spe_projecthourstype_hourstype_vatclass_code | |||
projecthourstype_ |
varchar2 |
itgen_spe_projecthourstype_hourstype_vatclass_id | |||
projecthourstype_ |
varchar2 |
itgen_spe_projecthourstype_hourstype_vatclass_label | |||
projecthourstype_ |
varchar2 |
itgen_spe_projecthourstype_hourstype_vatclass_name | |||
projecthourstype_ |
double |
itgen_spe_projecthourstype_hourstype_vatclass_percentage | |||
projecthourstype_ |
varchar2 |
itgen_spe_projecthourstype_id | |||
projecthourstype_ |
double |
itgen_spe_projecthourstype_tariff | |||
projectservice_ |
varchar2 |
itgen_spe_projectservice_default_service_id | |||
projectservice_ |
varchar2 |
Project Service ID | |||
projectservice_ |
varchar2 |
Project Service Name | |||
projectservice_ |
varchar2 |
itgen_spe_projectservice_revenue_group_id | |||
projectservice_ |
char |
itgen_spe_projectservice_use_in_resource_planner | |||
spent_ |
varchar2 |
Spent Amount | |||
spread |
varchar2 |
itgen_spe_spread | |||
start_ |
varchar2 |
Start Date | |||
status_ |
varchar2 |
Status Colour | |||
status_ |
varchar2 |
Status Created at | |||
status_ |
varchar2 |
Status ID | |||
status_ |
char |
Status is Blocked | |||
status_ |
char |
Status is Done | |||
status_ |
varchar2 |
Status Name | |||
status_ |
int64 |
Status Order | |||
status_ |
varchar2 |
Status Updated at | |||
updated_ |
varchar2 |
Updated at | |||
use_ |
char |
Use Spread |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: