Quotations: Exact Online Quotations
insert update delete per partition webhook REST
- Catalogus:
ExactOnlineREST - Schema:
CRM - Primaire sleutels:
QuotationID - Label: Quotations
De gegevens in deze tabel zijn gepartitioneerd per waarde van de kolom Division.
Je kunt gegevens ophalen en wijzigen met insert, update en delete.
Wijzigingen worden doorgegeven via het webhook-onderwerp Quotations.
API-bron
- Eindpunt:
/api/v1/{division}/crm/Quotations - Metagegevens:
/api/v1/{division}/crm/$metadata
Prestatiekenmerken
| Characteristic | Value |
|---|---|
| Gemiddelde toegangsvertraging (ms) | 5 |
| Aantal rijen per minuut bij volledige scan | 7,200 |
| Aantal rijen per minuut in een Query | 300 |
| Aantal rijen per minuut schrijven | 300 |
Het resultaat kan op de client in de Cache worden opgeslagen.
Tabelkolommen
De kolommen van de tabel Quotations 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 |
|---|---|---|---|---|---|
Amount |
double |
Bedrag Administratie Munteenheid | filters on the platform, writable | Amount in the default currency of the company. | |
Amount |
double |
Kortingsbedrag | filters on the platform, writable | ||
Amount |
double |
Kortingsbedrag exclusief BTW | filters on the platform, writable | ||
Amount |
double |
Bedrag Vreemde Valuta | filters on the platform, writable | Amount in the currency of the transaction. | |
Close |
datetime |
Datum Gesloten | filters on the platform, writable | Date on which the customer accepted or rejected the quotation version. | |
Closing |
datetime |
Afsluitdatum | filters on the platform, writable | Date on which you expect to close/win the deal. | |
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Aangemaakt (UTC) | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Aanmaker Volledige Naam | filters on the platform, writable | Name of creator. | |
Currency |
varchar2 |
Currency | filters on the platform, writable | The currency of the quotation. | |
Delivery |
guid |
Levering Account | filters on the platform, writable | The account where the items should delivered. | |
Delivery |
varchar2 |
Afleverrelatie Code | filters on the platform, writable | The code of the delivery account. | |
Delivery |
guid |
Afleverrelatie Contactpersoon | filters on the platform, writable | The contact person of the delivery account. | |
Delivery |
varchar2 |
Afleverrelatie Contactpersoon Volledige Naam | filters on the platform, writable | Full name of the delivery account contact person. | |
Delivery |
varchar2 |
Afleverrelatie Naam | filters on the platform, writable | The name of the delivery account. | |
Delivery |
guid |
Afleveradres | filters on the platform, writable | The id of the delivery address. | |
Delivery |
datetime |
Leveringsdatum | filters on the platform, writable | ||
Description |
varchar2 |
Description | filters on the platform, writable | The description of the quotation. | |
Division |
int32 |
Division | Division code. | ||
Division |
varchar2 |
Divisie Kamer van Koophandel Nummer | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Divisie IBAN Nummer | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Divisie Bedrijfsnaam | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Divisie RSIN Nummer | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Divisie BTW Nummer | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Divisie Loonbelastingnummer | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Divisie Label | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Administratie Naam | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Naam Abonnementhouder | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Abonnementhoudernummer | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Divisie Korte Naam | writable | Short name of the Exact Online division. | |
Document |
guid |
Document | filters on the platform, writable | Document linked to the quotation. | |
Document |
varchar2 |
Document Onderwerp | filters on the platform, writable | The subject of the document. | |
Due |
datetime |
Vervaldag | filters on the platform, writable | Date after which the quotation is no longer valid. | |
Incoterm |
varchar2 |
Incoterm-adres | filters on the platform, writable | ||
Incoterm |
varchar2 |
Incoterm-code | filters on the platform, writable | ||
Incoterm |
int16 |
Incoterm-versie | filters on the platform, writable | ||
Invoice |
guid |
Factuurrekening | filters on the platform, writable | The account to which the invoice is sent. | |
Invoice |
varchar2 |
Factuur Account Code | filters on the platform, writable | The code of the invoice account. | |
Invoice |
guid |
Factuurrelatie Contactpersoon | filters on the platform, writable | The contact person of the invoice account. | |
Invoice |
varchar2 |
Factuuraccount Volledige Naam Contactpersoon | filters on the platform, writable | Full name of the invoice account contact person. | |
Invoice |
varchar2 |
Factuur Accountnaam | filters on the platform, writable | The name of the invoice account. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Gewijzigd (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Gewijzigd Volledige Naam | filters on the platform, writable | Name of modifier. | |
Opportunity |
guid |
Opportunity | filters on the platform, writable | Opportunity linked to the quotation. | |
Opportunity |
varchar2 |
Verkoopkans Naam | filters on the platform, writable | The name of the opportunity. | |
Order |
guid |
Verkooporder Klant | filters on the platform, writable | The account that requested the quotation. | |
Order |
varchar2 |
Bestelklant Code | filters on the platform, writable | The code of the order account. | |
Order |
guid |
Verkooporder Relatiecontactpersoon | filters on the platform, writable | The contact person of the order account. | |
Order |
varchar2 |
itgen_eol_orderaccountcontactfullname | filters on the platform, writable | Full name of the order account contact person. | |
Order |
varchar2 |
Bestelling Relatienaam | filters on the platform, writable | The name of the order account. | |
Payment |
varchar2 |
Betalingsvoorwaarde | filters on the platform, writable | ||
Payment |
varchar2 |
Betalingsconditie Omschrijving | filters op het platform | ||
Project |
guid |
Project | filters on the platform, writable | The project linked to the quotation. | |
Project |
varchar2 |
Projectcode | filters on the platform, writable | The code of the project. | |
Project |
varchar2 |
Projectomschrijving | filters on the platform, writable | The description of the project. | |
Quotation |
datetime |
Offertedatum | filters on the platform, writable | Date on which the quotation version is entered or printed.Both during entering and printing this date can be adjusted. | |
Quotation |
guid |
Offerte ID | filters on the platform, writable | Identifier of the quotation. | |
Quotation |
int32 |
Offertenummer | filters on the platform, writable | Unique number to indentify the quotation.By default this number is based on the setting for first available number. | |
Remarks |
varchar2 |
Remarks | filters on the platform, writable | Extra text that can be added to the quotation. | |
Sales |
guid |
Verkoopkanaal | filters op het platform | ||
Sales |
varchar2 |
Verkoopkanaalcode | filters op het platform | ||
Sales |
varchar2 |
Verkoopkanaalomschrijving | filters op het platform | ||
Sales |
guid |
Verkoper | filters on the platform, writable | The user that is responsible for the quotation version. | |
Sales |
varchar2 |
Verkoper Volledige Naam | filters on the platform, writable | Full name of the sales person. | |
Selection |
guid |
Selectiecode | filters on the platform, writable | ID of selection code.Only supported by the Advanced and Premium editions for Wholesale & Distribution and Manufacturing. | |
Selection |
varchar2 |
Selectiecode | filters on the platform, writable | Code of selection code. | |
Selection |
varchar2 |
itgen_eol_selectioncodedescription | filters op het platform | Description of selection code. | |
Shipping |
guid |
Verzendwijze | filters on the platform, writable | ||
Shipping |
varchar2 |
Verzendmethode Omschrijving | filters op het platform | ||
Status |
int16 |
Status | filters on the platform, writable | The status of the quotation version.5 = Rejected, 6 = Reviewed and closed, 10 = Recovery, 20 = Draft, 25 = Open, 35 = Processing... , 40 = Printed, 50 = Accepted. | |
Status |
varchar2 |
Statusomschrijving | writable | The description of the status. | |
VAT |
double |
BTW-bedrag Vreemde Valuta | filters on the platform, writable | Total VAT amount in the currency of the transaction. | |
Version |
int32 |
Versienummer | filters on the platform, writable | Number indicating the different reviews which are made for the quotation. | |
Warehouse |
varchar2 |
Magazijncode | filters op het platform | ||
Warehouse |
varchar2 |
Magazijnomschrijving | filters op het platform | ||
Warehouse |
guid |
Magazijn ID | filters on the platform, writable | ||
Your |
varchar2 |
Uw Referentie | filters on the platform, writable | The number by which this quotation is identified by the order account. |
Toetsen
| Key | Column | Verwijst naar | Kind | Description |
|---|---|---|---|---|
Quotations_ |
Creator |
Users. |
Key | |
Quotations_ |
Currency |
Currencies.Code |
Key | |
Quotations_ |
Delivery |
Contacts.ID |
Key | |
Quotations_ |
Delivery |
Accounts.ID |
Key | |
Quotations_ |
Delivery |
Addresses.ID |
Key | |
Quotations_ |
Document |
Documents.ID |
Key | |
Quotations_ |
Invoice |
Contacts.ID |
Key | |
Quotations_ |
Invoice |
Accounts.ID |
Key | |
Quotations_ |
Modifier |
Users. |
Key | |
Quotations_ |
Opportunity |
Opportunities.ID |
Key | |
Quotations_ |
Order |
Contacts.ID |
Key | |
Quotations_ |
Order |
Accounts.ID |
Key | |
Quotations_ |
Project |
Projects.ID |
Key | |
Quotations_ |
Sales |
Users. |
Key | |
Quotations_ |
Selection |
SelectionCodes.ID |
Key |
Geciteerd door
- QuotationLines
QuotationID(Key) - QuotationLinesBulk
QuotationID(Key) - Projects
SourceQuotation(Key)
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: