invantive documentation
Invantive Support ForumsLog In / Sign Up

SalesServiceQuotes: Simplicate Sales Service Quotes

read only REST

  • Catalog: Simplicate
  • Schema: Sales
  • Label: Sales Service Quotes

Fetches all available quote templates for sales

Can only retrieve data.

API Source

  • Endpoint: /sales/quote
  • Operation: get /sales/quote

Table Columns

The columns of the table SalesServiceQuotes 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
created_by varchar2 Created by
customer_reference varchar2 Customer Reference
default_service_id varchar2 Default Service ID
download_url varchar2 Download URL
explanation varchar2 Explanation
grand_totals varchar2 itgen_spe_grand_totals
id varchar2 ID
invoice_method varchar2 Invoice Method
is_blocked int64 Blocked
is_outdated int64 Is Outdated
is_sepa_authorization int64 itgen_spe_is_sepa_authorization
json varchar2 JSON
last_updated_approval_status varchar2 itgen_spe_last_updated_approval_status
name varchar2 Name
payment_term varchar2 itgen_spe_payment_term
position int64 Position
price double Price
quote_date varchar2 Quote Date
quote_number varchar2 Quote Number
quote_subject varchar2 Quote Subject
quotestatus_color varchar2 itgen_spe_quotestatus_color
quotestatus_id varchar2 itgen_spe_quotestatus_id
quotestatus_label varchar2 itgen_spe_quotestatus_label
quotetemplate_created_at varchar2 itgen_spe_quotetemplate_created_at
quotetemplate_description varchar2 itgen_spe_quotetemplate_description
quotetemplate_html varchar2 itgen_spe_quotetemplate_html
quotetemplate_id varchar2 itgen_spe_quotetemplate_id
quotetemplate_is_blocked char itgen_spe_quotetemplate_is_blocked
quotetemplate_json varchar2 itgen_spe_quotetemplate_json
quotetemplate_name varchar2 itgen_spe_quotetemplate_name
quotetemplate_type varchar2 itgen_spe_quotetemplate_type
quotetemplate_updated_at varchar2 itgen_spe_quotetemplate_updated_at
receivers varchar2 itgen_spe_receivers
sales_id varchar2 Sales ID
sales_id_2 varchar2 itgen_spe_sales_id_2
send_type varchar2 Send Type
sent_at varchar2 Sent at
show_itemtype int64 Show Item Type
subscription_cycle varchar2 Subscription Cycle
total varchar2 Total
total_excl varchar2 Total excl
total_incl varchar2 Total incl
total_vat varchar2 Total VAT
track_cost char Track Cost
track_hours char Track Hours
updated_at varchar2 Updated at
valid_days int64 Valid Days
vat varchar2 itgen_spe_vat
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: