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_ |
varchar2 |
Created at | |||
created_ |
varchar2 |
Created by | |||
customer_ |
varchar2 |
Customer Reference | |||
download_ |
varchar2 |
Download URL | |||
grand_ |
varchar2 |
itgen_spe_grand_totals | |||
id |
varchar2 |
ID | |||
is_ |
int64 |
Blocked | |||
is_ |
int64 |
Is Outdated | |||
is_ |
int64 |
itgen_spe_is_sepa_authorization | |||
json |
varchar2 |
JSON | |||
last_ |
varchar2 |
itgen_spe_last_updated_approval_status | |||
payment_ |
varchar2 |
itgen_spe_payment_term | |||
quote_ |
varchar2 |
Quote Date | |||
quote_ |
varchar2 |
Quote Number | |||
quote_ |
varchar2 |
Quote Subject | |||
quotestatus_ |
varchar2 |
itgen_spe_quotestatus_color | |||
quotestatus_ |
varchar2 |
itgen_spe_quotestatus_id | |||
quotestatus_ |
varchar2 |
itgen_spe_quotestatus_label | |||
quotetemplate_ |
varchar2 |
itgen_spe_quotetemplate_created_at | |||
quotetemplate_ |
varchar2 |
itgen_spe_quotetemplate_description | |||
quotetemplate_ |
varchar2 |
itgen_spe_quotetemplate_html | |||
quotetemplate_ |
varchar2 |
itgen_spe_quotetemplate_id | |||
quotetemplate_ |
char |
itgen_spe_quotetemplate_is_blocked | |||
quotetemplate_ |
varchar2 |
itgen_spe_quotetemplate_json | |||
quotetemplate_ |
varchar2 |
itgen_spe_quotetemplate_name | |||
quotetemplate_ |
varchar2 |
itgen_spe_quotetemplate_type | |||
quotetemplate_ |
varchar2 |
itgen_spe_quotetemplate_updated_at | |||
receivers |
varchar2 |
itgen_spe_receivers | |||
sales_ |
varchar2 |
Sales ID | |||
send_ |
varchar2 |
Send Type | |||
sent_ |
varchar2 |
Sent at | |||
total_ |
varchar2 |
Total excl | |||
total_ |
varchar2 |
Total incl | |||
total_ |
varchar2 |
Total VAT | |||
updated_ |
varchar2 |
Updated at | |||
valid_ |
int64 |
Valid Days | |||
vat |
varchar2 |
itgen_spe_vat |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: