SalesEntryLines: Exact Online Sales Entry Lines
insert update delete per partition webhook REST
- Catalogus:
ExactOnlineREST - Schema:
SalesEntry - Primaire sleutels:
ID - Label: Sales Entry 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 SalesEntries op EntryID.
API-bron
- Eindpunt:
/api/v1/{division}/salesentry/SalesEntryLines - Metagegevens:
/api/v1/{division}/salesentry/$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 SalesEntryLines 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.For almost all lines this can be calculated like: AmountDC = AmountFC * RateFC. | |
Amount |
double |
Bedrag Vreemde Valuta | filters on the platform, writable | For normal lines it's the amount excluding VAT. | |
Asset |
guid |
Asset | filters on the platform, writable | Reference to Asset. | |
Asset |
varchar2 |
Activa Omschrijving | filters on the platform, writable | Description of Asset. | |
Cost |
varchar2 |
Kostenplaats | filters on the platform, writable | Reference to Cost center. | |
Cost |
varchar2 |
Kostenplaats Omschrijving | filters on the platform, writable | Description of CostCenter. | |
Cost |
varchar2 |
Kostendrager | filters on the platform, writable | Reference to Cost unit. | |
Cost |
varchar2 |
Kostendrager Omschrijving | filters on the platform, writable | Description of CostUnit. | |
Custom |
varchar2 |
Aangepast Veld | writable | ||
Description |
varchar2 |
Description | filters on the platform, writable | Description.Can be different for header and lines. | |
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. | |
Entry |
guid |
Boeking ID | filters on the platform, writable | The unique ID of the entry.Via this ID all transaction lines of a single entry can be retrieved. | |
Extra |
double |
Extra Belasting Bedrag Vreemde Valuta | filters on the platform, writable | Extra duty amount in the currency of the transaction.Both extra duty amount and VAT amount need to be specified in order to differ this property from automatically calculated. | |
Extra |
double |
Extra Belasting (%) | filters on the platform, writable | Extra duty percentage for the item. | |
From |
datetime |
From | writable | From date for deferred revenue. | |
GL |
guid |
Grootboekrekening | filters on the platform, writable | The GL Account of the invoice line.This field is generated based on the revenue account of the item (or the related item group).G/L Account is also used to determine whether the costcenter / costunit is mandatory. | |
GL |
varchar2 |
Grootboekrekening Code | filters on the platform, writable | Code of the G/L account. | |
GL |
varchar2 |
Grootboekrekening Omschrijving | filters on the platform, writable | Description of the G/L account. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Intra |
varchar2 |
Intrastat Gebied | filters on the platform, writable | IntraStat area. | |
Intra |
varchar2 |
Intrastat Land | filters on the platform, writable | IntraStatCountry. | |
Intra |
varchar2 |
Intrastat Afleverconditie | filters on the platform, writable | IntraStat delivery term. | |
Intra |
varchar2 |
Intrastat Transactie A | filters on the platform, writable | IntraStat transaction a. | |
Intra |
varchar2 |
Intrastat Transactie B | filters op het platform | ||
Intra |
varchar2 |
Intrastat Transportmethode | filters on the platform, writable | IntraStat transport method. | |
Line |
int32 |
Regelnummer | filters on the platform, writable | Indicates the sequence of the lines within one entry. | |
Net |
double |
Nettobedrag Administratie Valuta | writable | Net amount in division currency of sales entry line. | |
Net |
double |
Netto Bedrag Vreemde Valuta | writable | Net amount in foreign currency of sales entry line. | |
Notes |
varchar2 |
Notes | filters on the platform, writable | Extra notes. | |
Project |
guid |
Project | filters on the platform, writable | The project to which the sales transaction line is linked.The project can be different per line.Sometimes also the project in the header is filled although this is not really used. | |
Project |
varchar2 |
Projectomschrijving | filters on the platform, writable | Description of Project. | |
Project |
guid |
Project WBS | writable | Project WBS ID. | |
Project |
varchar2 |
Project WBS Omschrijving | writable | Project WBS description. | |
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. | |
Serial |
varchar2 |
Serienummer | filters on the platform, writable | Serial number. | |
Statistical |
double |
Statistisch Nettogewicht | filters on the platform, writable | Statistical NetWeight. | |
Statistical |
varchar2 |
Statistisch Aantal | filters on the platform, writable | Statistical Number (also known as 'Goederencode'). | |
Statistical |
double |
Statistische Hoeveelheid | filters on the platform, writable | Statistical Quantity. | |
Statistical |
double |
Statistische Waarde | filters on the platform, writable | Statistical Value. | |
Subscription |
guid |
Subscription | filters on the platform, writable | When generating invoices from subscriptions, this field records the link between invoice lines and subscription lines. | |
Subscription |
varchar2 |
Abonnementsomschrijving | filters on the platform, writable | Description of Subscription. | |
Tax |
guid |
Belastingplan | filters on the platform, writable | Obsolete. | |
To |
datetime |
To | filters on the platform, writable | To date for deferred revenue. | |
Tracking |
guid |
Tracking Nummer | filters on the platform, writable | Reference to TrackingNumber. | |
Tracking |
varchar2 |
Tracking Nummer Omschrijving | filters on the platform, writable | Description of TrackingNumber. | |
Type |
int32 |
Type | filters on the platform, writable | Type: 20 = Sales entry, 21 = Sales credit note. | |
VAT |
double |
BTW Bedrag Administratie Valuta | writable | VAT amount in the default currency of the company. | |
VAT |
double |
BTW-bedrag Vreemde Valuta | filters on the platform, writable | VAT amount in the currency of the transaction.Use this property to specify a VAT amount that differs from the VAT amount that is automatically calculated.However if the transaction uses extra duty, extra duty amount also needs to be specified. | |
VAT |
double |
BTW-basisbedrag Administratievaluta | filters on the platform, writable | The VAT base amount in the default currency of the company.This is calculated based on the VATBaseAmountFC. | |
VAT |
double |
BTW-basisbedrag Vreemde Valuta | filters on the platform, writable | The VAT base amount in invoice currency.This is calculated with the use of VAT codes.It's an internal value. | |
VAT |
varchar2 |
BTW-code | filters on the platform, writable | The VAT code used when the invoice was registered. | |
VAT |
varchar2 |
BTW Code Omschrijving | filters on the platform, writable | Description of VAT code. | |
VAT |
double |
BTW-percentage | filters on the platform, writable | The VAT percentage of the VAT code.This is the percentage at the moment the invoice is created.It's also used by the default calculation of VAT amounts and VAT base amounts. |
Toetsen
| Key | Column | Verwijst naar | Kind | Description |
|---|---|---|---|---|
Sales |
Asset |
Assets.ID |
Key | |
Sales |
Cost |
Costcenters.Code |
Key | |
Sales |
Cost |
Costunits.Code |
Key | |
Sales |
GL |
GLAccounts.ID |
Key | |
Sales |
Project |
ProjectWBS.ID |
Key | |
Sales |
Project |
Projects.ID |
Key | |
Sales |
Subscription |
Subscriptions. |
Key | |
Sales |
VAT |
VATCodes.Code |
Key |
Release Notes
Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver: