invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectCostTypeServices: Simplicate Project Cost Type Services

read only REST

  • Catalog: Simplicate
  • Schema: Projects
  • Label: Project Cost Type Services

Fetches all services

Can only retrieve data.

API Source

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

Table Columns

The columns of the table ProjectCostTypeServices 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)
budgeted_amount double Budgeted Amount
costtype_blocked char itgen_spe_costtype_blocked
costtype_id varchar2 Cost Type ID
costtype_is_attachment_allowed char itgen_spe_costtype_is_attachment_allowed
costtype_is_unit_tariff char itgen_spe_costtype_is_unit_tariff
costtype_label varchar2 Cost Type Label
costtype_tariff double Cost Type Tariff
costtype_unit_name varchar2 itgen_spe_costtype_unit_name
created_at varchar2 Created at
default_service_id varchar2 Default Service ID
end_date varchar2 End Date
expected_invoice_date varchar2 Expected Invoice Date
explanation varchar2 Explanation
id varchar2 ID
id_2 varchar2 itgen_spe_id_2
invoice_date varchar2 Invoice Date
invoice_in_installments char Invoice in Installments
invoice_method varchar2 Invoice Method
label varchar2 Label
name varchar2 Name
price double Price
project_id varchar2 Project ID
purchase_margin double Purchase Margin
purchase_tariff double Purchase Tariff
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
subscription_cycle varchar2 Subscription Cycle
tariff double Tariff
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: