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_ |
varchar2 |
Created at | |||
created_ |
varchar2 |
Created by | |||
customer_ |
varchar2 |
Customer Reference | |||
default_ |
varchar2 |
Default Service ID | |||
download_ |
varchar2 |
Download URL | |||
explanation |
varchar2 |
Explanation | |||
grand_ |
varchar2 |
itgen_spe_grand_totals | |||
id |
varchar2 |
ID | |||
invoice_ |
varchar2 |
Invoice Method | |||
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 | |||
name |
varchar2 |
Name | |||
payment_ |
varchar2 |
itgen_spe_payment_term | |||
position |
int64 |
Position | |||
price |
double |
Price | |||
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 | |||
sales_ |
varchar2 |
itgen_spe_sales_id_2 | |||
send_ |
varchar2 |
Send Type | |||
sent_ |
varchar2 |
Sent at | |||
show_ |
int64 |
Show Item Type | |||
subscription_ |
varchar2 |
Subscription Cycle | |||
total |
varchar2 |
Total | |||
total_ |
varchar2 |
Total excl | |||
total_ |
varchar2 |
Total incl | |||
total_ |
varchar2 |
Total VAT | |||
track_ |
char |
Track Cost | |||
track_ |
char |
Track Hours | |||
updated_ |
varchar2 |
Updated at | |||
valid_ |
int64 |
Valid Days | |||
vat |
varchar2 |
itgen_spe_vat | |||
vat_ |
varchar2 |
VAT Code | |||
vat_ |
varchar2 |
VAT Description |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: