---
title: "SalesServiceQuotes (Simplicate)"
description: "Sales Service Quotes"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Sales.SalesServiceQuotes
original: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Sales.SalesServiceQuotes
updated: 2024-10-18T06:48:11Z
license: https://documentation.invantive.eu/en/
---

# 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:

- [Simplicate](/en/release-notes/drivers?driver=simplicate)

