ProjectServices: Simplicate Project Services |
Fetches all services
Catalog: Simplicate
Schema: Projects
Label: Project Services
Can retrieve data and change data using insert, update and delete.
Select Simplicate API URL: /projects/service
Insert Simplicate API URL: /projects/service
Update Simplicate API URL: /projects/service
Delete Simplicate API URL: /projects/service
Field Selection Method: NotRequired
Base Path: data[*]
Select Simplicate API Operation: get /projects/service
Insert Simplicate API Operation: post /projects/service
Update Simplicate API Operation: put /projects/service/{id}
Delete Simplicate API Operation: delete /projects/service/{id}
Table Function Columns
The columns of the table function ProjectServices 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 or update.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
amount |
float |
Amount |
☐ |
|
budget_financial_hours |
string |
Budget Financial (hrs) |
☐ |
|
budget |
float |
Budget |
☐ |
|
created_at |
string |
Created at |
☐ |
|
default_service_id |
string |
Default Service ID |
☐ |
|
end_date |
string |
End Date |
☐ |
|
expected_invoice_date |
string |
Expected Invoice Date |
☐ |
|
explanation |
string |
Explanation |
☐ |
|
id |
string |
ID |
☐ |
|
invoice_date |
string |
Invoice Date |
☐ |
|
invoice_in_installments |
boolean |
Invoice in Installments |
☐ |
|
invoice_method |
string |
Invoice Method |
☐ |
|
name |
string |
Name |
☐ |
|
price |
float |
Price |
☐ |
|
project_id |
string |
Project ID |
☐ |
|
related_service_id |
string |
Related Service ID |
☐ |
|
revenue_group_id |
string |
Revenue Group ID |
☐ |
|
revenue_group_label |
string |
Revenue Group Label |
☐ |
|
service_number |
string |
Service Number |
☐ |
|
start_date |
string |
Start Date |
☐ |
|
status |
string |
Status |
☐ |
|
subscription_cycle |
string |
Subscription Cycle |
☐ |
|
track_cost |
boolean |
Track Cost |
☐ |
|
track_hours |
boolean |
Track Hours |
☐ |
|
updated_at |
string |
Updated at |
☐ |
|
use_in_resource_planner |
boolean |
Use in Resource Planner |
☐ |
|
vat_class_code |
string |
VAT Class Code |
☐ |
|
vat_class_id |
string |
VAT Class ID |
☐ |
|
vat_class_label |
string |
VAT Class Label |
☐ |
|
vat_class_name |
string |
VAT Class Name |
☐ |
|
vat_class_percentage |
float |
VAT Class Percentage |
☐ |
|
write_hours_end_date |
string |
Write Hours End Date |
☐ |
|
write_hours_start_date |
string |
Write Hours Start Date |
☐ |
|
15-06-2022 20:27 Version 22.0.232-PROD+3445