invantive documentation
Invantive Support ForumsLog In / Sign Up

SalesQuotes: Simplicate Sales Quotes

insert update delete REST

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

Fetches all available quote templates for sales

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

API Source

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

Table Columns

The columns of the table SalesQuotes 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
created_at varchar2 Created at
created_by varchar2 Created by
customer_reference varchar2 Customer Reference
download_url varchar2 Download URL
grand_totals varchar2 itgen_spe_grand_totals
id varchar2 ID
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
payment_term varchar2 itgen_spe_payment_term
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
send_type varchar2 Send Type
sent_at varchar2 Sent at
total_excl varchar2 Total excl
total_incl varchar2 Total incl
total_vat varchar2 Total VAT
updated_at varchar2 Updated at
valid_days int64 Valid Days
vat varchar2 itgen_spe_vat

Release Notes

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