invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectInstallmentServices: Simplicate Project Installment Services

read only REST

  • Catalog: Simplicate
  • Schema: Projects
  • Label: Project Installment Services

Fetches all services

Can only retrieve data.

API Source

  • Endpoint: /projects/service
  • Operation: get /projects/service

Table Columns

The columns of the table ProjectInstallmentServices 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
amount double Amount
budget double Budget
budget_financial_hours varchar2 Budget Financial (hrs)
created_at varchar2 Created at
default_service_id varchar2 Default Service ID
end_date varchar2 End Date
expected_invoice_date varchar2 Expected Invoice Date
expiration_date varchar2 Expiration Date
explanation varchar2 Explanation
id varchar2 ID
invoice_date varchar2 Invoice Date
invoice_id varchar2 Invoice ID
invoice_in_installments char Invoice in Installments
invoice_line_id varchar2 Invoice line ID
invoice_method varchar2 Invoice Method
invoiced_date varchar2 Invoiced Date
name varchar2 Name
name_2 varchar2 itgen_spe_name_2
order int64 Order
percentage double Percentage
price double Price
price_2 double itgen_spe_price_2
project_id varchar2 Project ID
related_service_id varchar2 Related Service ID
revenue_group_id varchar2 Revenue Group ID
revenue_group_label varchar2 Revenue Group Label
service_number varchar2 Service Number
start_date varchar2 Start Date
status varchar2 Status
status_2 varchar2 itgen_spe_status_2
subscription_cycle varchar2 Subscription Cycle
track_cost char Track Cost
track_hours char Track Hours
updated_at varchar2 Updated at
use_in_resource_planner char Use in Resource Planner
vat_class_code varchar2 VAT Class Code
vat_class_id varchar2 VAT Class ID
vat_class_label varchar2 VAT Class Label
vat_class_name varchar2 VAT Class Name
vat_class_percentage double VAT Class Percentage
write_hours_end_date varchar2 Write Hours End Date
write_hours_start_date varchar2 Write Hours Start Date

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: