SalesHourTypeServices: Simplicate Sales Hour Type Services
read only REST
- Catalog:
Simplicate - Schema:
Sales - Label: Sales Hour Type Services
Fetches all services
Can only retrieve data.
API Source
- Endpoint:
/sales/service - Operation:
get /sales/service
Table Columns
The columns of the table SalesHourTypeServices 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 | |||
billable |
char |
Billable | |||
budgeted_ |
double |
Budgeted Amount | |||
created_ |
varchar2 |
Created at | |||
default_ |
varchar2 |
Default Service ID | |||
explanation |
varchar2 |
Explanation | |||
hourstype_ |
double |
itgen_spe_hourstype_billable | |||
hourstype_ |
char |
itgen_spe_hourstype_blocked | |||
hourstype_ |
varchar2 |
itgen_spe_hourstype_color | |||
hourstype_ |
varchar2 |
itgen_spe_hourstype_id | |||
hourstype_ |
varchar2 |
itgen_spe_hourstype_label | |||
hourstype_ |
double |
itgen_spe_hourstype_tariff | |||
hourstype_ |
varchar2 |
itgen_spe_hourstype_type | |||
hourstype_ |
varchar2 |
itgen_spe_hourstype_vatclass_code | |||
hourstype_ |
varchar2 |
itgen_spe_hourstype_vatclass_id | |||
hourstype_ |
varchar2 |
itgen_spe_hourstype_vatclass_label | |||
hourstype_ |
varchar2 |
itgen_spe_hourstype_vatclass_name | |||
hourstype_ |
double |
itgen_spe_hourstype_vatclass_percentage | |||
id |
varchar2 |
ID | |||
id_2 |
varchar2 |
itgen_spe_id_2 | |||
invoice_ |
varchar2 |
Invoice Date | |||
invoice_ |
varchar2 |
Invoice Method | |||
name |
varchar2 |
Name | |||
position |
int64 |
Position | |||
price |
double |
Price | |||
sales_ |
varchar2 |
Sales ID | |||
show_ |
int64 |
Show Item Type | |||
subscription_ |
varchar2 |
Subscription Cycle | |||
tariff |
double |
Tariff | |||
total |
varchar2 |
Total | |||
track_ |
char |
Track Cost | |||
track_ |
char |
Track Hours | |||
updated_ |
varchar2 |
Updated at | |||
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 | |||
vat_ |
varchar2 |
VAT Code | |||
vat_ |
varchar2 |
VAT Description |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: