invantive documentation
Invantive Support ForumsLog In / Sign Up

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_amount double Budgeted Amount
created_at varchar2 Created at
default_service_id varchar2 Default Service ID
explanation varchar2 Explanation
hourstype_billable double itgen_spe_hourstype_billable
hourstype_blocked char itgen_spe_hourstype_blocked
hourstype_color varchar2 itgen_spe_hourstype_color
hourstype_id varchar2 itgen_spe_hourstype_id
hourstype_label varchar2 itgen_spe_hourstype_label
hourstype_tariff double itgen_spe_hourstype_tariff
hourstype_type varchar2 itgen_spe_hourstype_type
hourstype_vatclass_code varchar2 itgen_spe_hourstype_vatclass_code
hourstype_vatclass_id varchar2 itgen_spe_hourstype_vatclass_id
hourstype_vatclass_label varchar2 itgen_spe_hourstype_vatclass_label
hourstype_vatclass_name varchar2 itgen_spe_hourstype_vatclass_name
hourstype_vatclass_percentage double itgen_spe_hourstype_vatclass_percentage
id varchar2 ID
id_2 varchar2 itgen_spe_id_2
invoice_date varchar2 Invoice Date
invoice_method varchar2 Invoice Method
name varchar2 Name
position int64 Position
price double Price
sales_id varchar2 Sales ID
show_itemtype int64 Show Item Type
subscription_cycle varchar2 Subscription Cycle
tariff double Tariff
total varchar2 Total
track_cost char Track Cost
track_hours char Track Hours
updated_at varchar2 Updated at
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
vat_code varchar2 VAT Code
vat_description varchar2 VAT Description

Release Notes

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