Please enable JavaScript to view this site.

Navigation: Schema: Projects > Tables

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