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_ |
varchar2 |
Budget Financial (hrs) | |||
created_ |
varchar2 |
Created at | |||
default_ |
varchar2 |
Default Service ID | |||
end_ |
varchar2 |
End Date | |||
expected_ |
varchar2 |
Expected Invoice Date | |||
expiration_ |
varchar2 |
Expiration Date | |||
explanation |
varchar2 |
Explanation | |||
id |
varchar2 |
ID | |||
invoice_ |
varchar2 |
Invoice Date | |||
invoice_ |
varchar2 |
Invoice ID | |||
invoice_ |
char |
Invoice in Installments | |||
invoice_ |
varchar2 |
Invoice line ID | |||
invoice_ |
varchar2 |
Invoice Method | |||
invoiced_ |
varchar2 |
Invoiced Date | |||
name |
varchar2 |
Name | |||
name_2 |
varchar2 |
itgen_spe_name_2 | |||
order |
int64 |
Order | |||
percentage |
double |
Percentage | |||
price |
double |
Price | |||
price_ |
double |
itgen_spe_price_2 | |||
project_ |
varchar2 |
Project ID | |||
related_ |
varchar2 |
Related Service ID | |||
revenue_ |
varchar2 |
Revenue Group ID | |||
revenue_ |
varchar2 |
Revenue Group Label | |||
service_ |
varchar2 |
Service Number | |||
start_ |
varchar2 |
Start Date | |||
status |
varchar2 |
Status | |||
status_ |
varchar2 |
itgen_spe_status_2 | |||
subscription_ |
varchar2 |
Subscription Cycle | |||
track_ |
char |
Track Cost | |||
track_ |
char |
Track Hours | |||
updated_ |
varchar2 |
Updated at | |||
use_ |
char |
Use in Resource Planner | |||
vat_ |
varchar2 |
VAT Class Code | |||
vat_ |
varchar2 |
VAT Class ID | |||
vat_ |
varchar2 |
VAT Class Label | |||
vat_ |
varchar2 |
VAT Class Name | |||
vat_ |
double |
VAT Class Percentage | |||
write_ |
varchar2 |
Write Hours End Date | |||
write_ |
varchar2 |
Write Hours Start Date |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: