invantive documentation
Invantive Support ForumsLog In / Sign Up

SalesServices: Simplicate Sales Services

insert update delete REST

  • Catalog: Simplicate
  • Schema: Sales
  • Primary Keys: id
  • Label: Sales Services

Fetches all services

Can retrieve data and change data using insert, update and delete.

API Source

  • Endpoint: /sales/service
  • Operation: get /sales/service

Table Columns

The columns of the table SalesServices 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
created_at varchar2 Created at
default_service_id varchar2 Default Service ID
explanation varchar2 Explanation
id varchar2 ID
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
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: