SalesEntryLines: Exact Online Sales Entry Lines
insert update delete per partition webhook REST
- Katalog:
ExactOnlineREST - Schema:
SalesEntry - Primärschlüssel:
ID - Label: Sales Entry Lines
Die Daten in dieser Tabelle sind nach dem Wert der Spalte Division aufgeteilt.
Mit insert, update und delete können Daten abgerufen und geändert werden.
Änderungen werden über das Webhook-Thema SalesEntries am EntryID übermittelt.
API-Quelle
- Endpunkt:
/api/v1/{division}/salesentry/SalesEntryLines - Metadaten:
/api/v1/{division}/salesentry/$metadata
Leistungsmerkmale
| Characteristic | Value |
|---|---|
| Durchschnittliche Zugriffsverzögerung (ms) | 5 |
| Anzahl der Vollscan-Zeilen pro Minute | 7,200 |
| Anzahl der Query-Zeilen pro Minute | 300 |
| Zeilen pro Minute schreiben | 300 |
Das Ergebnis kann auf dem Client im Cache zwischengespeichert werden.
Tabellenspalten
Die Spalten der Tabelle SalesEntryLines sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Amount |
double |
Betrag Sparte Währung | 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 |
Summe Fremdwährung | 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 |
Anlage Beschreibung | filters on the platform, writable | Description of Asset. | |
Cost |
varchar2 |
Kostenstelle | filters on the platform, writable | Reference to Cost center. | |
Cost |
varchar2 |
Kostenstelle Beschreibung | filters on the platform, writable | Description of CostCenter. | |
Cost |
varchar2 |
Kostenträger | filters on the platform, writable | Reference to Cost unit. | |
Cost |
varchar2 |
Kostenträgerbeschreibung | filters on the platform, writable | Description of CostUnit. | |
Custom |
varchar2 |
Benutzerdefiniertes Feld | writable | ||
Description |
varchar2 |
Description | filters on the platform, writable | Description.Can be different for header and lines. | |
Division |
int32 |
Division | Division code. | ||
Division |
varchar2 |
Nummer der Handelskammer des Bezirks | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Abteilung IBAN-Nummer | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Geschäftsbereich Firmenname | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Abteilung RSIN-Nummer | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Umsatzsteuer-Identifikationsnummer der Abteilung | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Nummer der Lohnsteuerabteilung | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Abteilungsbezeichnung | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Verwaltung Name | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Name des Abonnenten | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Abonnentennummer | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Kurzbezeichnung der Abteilung | writable | Short name of the Exact Online division. | |
Entry |
guid |
Eingabe 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 |
Zuschlagsbetrag in Währung | 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 |
Zuschlag (%) | filters on the platform, writable | Extra duty percentage for the item. | |
From |
datetime |
From | writable | From date for deferred revenue. | |
GL |
guid |
Hauptbuchkonto | 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 |
Hauptbuchkonto Code | filters on the platform, writable | Code of the G/L account. | |
GL |
varchar2 |
GL-Kontobeschreibung | filters on the platform, writable | Description of the G/L account. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Intra |
varchar2 |
Intrastat-Bereich | filters on the platform, writable | IntraStat area. | |
Intra |
varchar2 |
Intrastat-Land | filters on the platform, writable | IntraStatCountry. | |
Intra |
varchar2 |
Intrastat Lieferbedingung | filters on the platform, writable | IntraStat delivery term. | |
Intra |
varchar2 |
Intrastat Transaktion A | filters on the platform, writable | IntraStat transaction a. | |
Intra |
varchar2 |
Intrastat Transaktion B | Filter auf der Plattform | ||
Intra |
varchar2 |
Intrastat-Transportmethode | filters on the platform, writable | IntraStat transport method. | |
Line |
int32 |
Zeilen Nummer | filters on the platform, writable | Indicates the sequence of the lines within one entry. | |
Net |
double |
Nettobetrag, Abteilung, Währung | writable | Net amount in division currency of sales entry line. | |
Net |
double |
Nettobetrag in Währung | 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 |
Projektbeschreibung | filters on the platform, writable | Description of Project. | |
Project |
guid |
Projekt-WBS | writable | Project WBS ID. | |
Project |
varchar2 |
Beschreibung der Projektstrukturplanung (WBS) | 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 |
Seriennummer | filters on the platform, writable | Serial number. | |
Statistical |
double |
Statistisches Nettogewicht | filters on the platform, writable | Statistical NetWeight. | |
Statistical |
varchar2 |
Statistische Zahl | filters on the platform, writable | Statistical Number (also known as 'Goederencode'). | |
Statistical |
double |
Statistische Größe | filters on the platform, writable | Statistical Quantity. | |
Statistical |
double |
Statistischer Wert | 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 |
Abonnement Beschreibung | filters on the platform, writable | Description of Subscription. | |
Tax |
guid |
Steuerübersicht | filters on the platform, writable | Obsolete. | |
To |
datetime |
To | filters on the platform, writable | To date for deferred revenue. | |
Tracking |
guid |
Verfolgungsnummer | filters on the platform, writable | Reference to TrackingNumber. | |
Tracking |
varchar2 |
Suchnummer Beschreibung | 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 |
Umsatzsteuerbetrag Währung | writable | VAT amount in the default currency of the company. | |
VAT |
double |
USt. Summe Fremdwährung | 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 |
Umsatzsteuer-Bemessungsgrundlage Währung | 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 |
Umsatzsteuer-Bemessungsgrundlage in Währung | 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 |
Umsatzsteuer-IDNr. | filters on the platform, writable | The VAT code used when the invoice was registered. | |
VAT |
varchar2 |
USt. Code Beschreibung | filters on the platform, writable | Description of VAT code. | |
VAT |
double |
Umsatzsteuer Prozentsatz | 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. |
Tasten
| Key | Column | Bezieht sich auf | 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 |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: