QuotationLines: Exact Online Quotation Lines
insert update delete per partition webhook REST
- Catalogus:
ExactOnlineREST - Schema:
CRM - Primaire sleutels:
ID - Label: Quotation Lines
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 binnengekomen via het webhook-onderwerp Quotations op QuotationID.
API-bron
- Eindpunt:
/api/v1/{division}/crm/QuotationLines - 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 QuotationLines 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 |
Bedrag Vreemde Valuta | filters on the platform, writable | Amount in the currency of the transaction. | |
Cost |
varchar2 |
Kostenplaats | filters on the platform, writable | ||
Cost |
varchar2 |
Kostenplaats Omschrijving | filters op het platform | ||
Cost |
varchar2 |
Kostendrager | filters on the platform, writable | ||
Cost |
varchar2 |
Kostendrager Omschrijving | filters op het platform | ||
Custom |
varchar2 |
Aangepast Veld | writable | ||
Customer |
varchar2 |
Klant Artikelcode | filters op het platform | Code the customer uses for this item. | |
Description |
varchar2 |
Description | filters on the platform, writable | By default this contains the item description. | |
Discount |
double |
Discount | filters on the platform, writable | Discount given on the default price.This is stored as a fraction. ie 5.5% is stored as .055. | |
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. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Item |
guid |
Item | filters on the platform, writable | Reference to the item that is sold in this quotation line. | |
Item |
varchar2 |
Artikelomschrijving | filters on the platform, writable | Description of the item. | |
Line |
int32 |
Regelnummer | filters on the platform, writable | Indicates the sequence of the lines within one quotation. | |
Net |
double |
Netto Prijs | filters on the platform, writable | Net price of the quotation line. | |
Notes |
varchar2 |
Notes | filters on the platform, writable | Extra notes. | |
Optional |
char |
itgen_eol_optional | filters on the platform, writable | ||
Quantity |
double |
Quantity | filters on the platform, writable | The number of items sold in default units.The quantity shown in the entry screen is Quantity * UnitFactor. | |
Quotation |
guid |
Offerte ID | filters on the platform, writable | Identifies the quotation.All the lines of a quotation have the same QuotationID. | |
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. | |
Unit |
varchar2 |
Unit Code | filters on the platform, writable | Code of the item unit. | |
Unit |
varchar2 |
Omschrijving Unit | filters on the platform, writable | Description of the item unit. | |
Unit |
double |
Prijs per Eenheid | filters on the platform, writable | Price per item unit. | |
VAT |
double |
BTW-bedrag Vreemde Valuta | filters on the platform, writable | VAT amount of the line in the currency of the transaction. | |
VAT |
varchar2 |
BTW-code | filters on the platform, writable | The VAT code that is used when the quotation is invoiced. | |
VAT |
varchar2 |
BTW Omschrijving | filters on the platform, writable | Description of the VAT code. | |
VAT |
double |
BTW-percentage | filters on the platform, writable | The VAT percentage of the VAT code. | |
Version |
int32 |
Versienummer | filters on the platform, writable | Number indicating the different reviews which are made for the quotation. |
Toetsen
| Key | Column | Verwijst naar | Kind | Description |
|---|---|---|---|---|
Quotation |
Item |
Items.ID |
Key | |
Quotation |
Quotation |
Quotations. |
Key | |
Quotation |
VAT |
VATCodes.Code |
Key |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: