---
title: "SalesQuoteById (Simplicate)"
description: "Sales Quote by ID"
language: nl
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/nl/datamodels/simplicate/Simplicate.Sales.SalesQuoteById
original: https://documentation.invantive.eu/en/datamodels/simplicate/Simplicate.Sales.SalesQuoteById
updated: 2026-11-18T23:54:17Z
license: https://documentation.invantive.eu/nl/
---

# SalesQuoteById: Simplicate Verkoopofferte op ID

`read only` `REST`

- Catalogus: `Simplicate`
- Schema: `Sales`
- Label: Verkoopofferte op ID

Haalt één offertesjabloon voor verkoop op aan de hand van zijn id

Kan alleen gegevens ophalen.

## API-bron

- Eindpunt: `/sales/quote/{id}`
- Operatie: `get /sales/quote/{id}`

## Parameters

| Name | Datatype | Required | Default | Documentation |
|---|---|:---:|---|---|
| `id` | `` | [x] |  | De id van de sjabloon |

## Tabelkolommen

De kolommen van de tabel `SalesQuoteById` worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `created_at` | `varchar2` | Aangemaakt op | [ ] |  |  |
| `created_by` | `varchar2` | Gemaakt door | [ ] |  |  |
| `customer_reference` | `varchar2` | Referentie Klant | [ ] |  |  |
| `download_url` | `varchar2` | Download URL | [ ] |  |  |
| `grand_totals` | `varchar2` | itgen_spe_grand_totals | [ ] |  |  |
| `id` | `varchar2` | ID | [ ] |  |  |
| `is_blocked` | `int64` | Blocked | [ ] |  |  |
| `is_outdated` | `int64` | Is Verouderd | [ ] |  |  |
| `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` | Offertedatum | [ ] |  |  |
| `quote_number` | `varchar2` | Quote Nummer | [ ] |  |  |
| `quote_subject` | `varchar2` | Onderwerp Offerte | [ ] |  |  |
| `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` | Verkoop ID | [ ] |  |  |
| `send_type` | `varchar2` | Verzendsoort | [ ] |  |  |
| `sent_at` | `varchar2` | Verzonden op | [ ] |  |  |
| `total_excl` | `varchar2` | Totaal excl | [ ] |  |  |
| `total_incl` | `varchar2` | Totaal incl | [ ] |  |  |
| `total_vat` | `varchar2` | Totaal BTW | [ ] |  |  |
| `updated_at` | `varchar2` | Bijgewerkt op | [ ] |  |  |
| `valid_days` | `int64` | Geldige dagen | [ ] |  |  |
| `vat` | `varchar2` | itgen_spe_vat | [ ] |  |  |


## Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver:

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