PurchaseEntryLines: Exact Online Purchase Entry Lines
insert update delete per partition webhook REST
- Katalog:
ExactOnlineREST - Schema:
PurchaseEntry - Primärschlüssel:
ID - Label: Purchase 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 PurchaseEntries am EntryID übermittelt.
API-Quelle
- Endpunkt:
/api/v1/{division}/purchaseentry/PurchaseEntryLines - Metadaten:
/api/v1/{division}/purchaseentry/$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 PurchaseEntryLines 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. | |
Amount |
double |
Summe Fremdwährung | filters on the platform, writable | Amount in the currency of the transaction. | |
Asset |
guid |
Asset | filters on the platform, writable | Reference to asset. | |
Asset |
varchar2 |
Anlage Beschreibung | filters on the platform, writable | Asset description. | |
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. | |
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 | Reference to header of the purchase entry. | |
Expense |
guid |
Expense | Filter auf der Plattform | ||
Expense |
varchar2 |
Ausgaben Beschreibung | Filter auf der Plattform | ||
From |
datetime |
From | writable | From date for deferred revenue. | |
GL |
guid |
Hauptbuchkonto | filters on the platform, writable | General ledger account. | |
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 | Line number. | |
Net |
double |
Nettobetrag, Abteilung, Währung | writable | Net amount in division currency of purchase entry line. | |
Net |
double |
Nettobetrag in Währung | writable | Net amount in foreign currency of purchase entry line. | |
Notes |
varchar2 |
Notes | filters on the platform, writable | Extra remarks. | |
Private |
double |
itgen_eol_privateusepercentage | filters on the platform, writable | Percentage of re-invoice part of a cost to the GlobalState of the company. | |
Project |
guid |
Project | filters on the platform, writable | Reference to project. | |
Project |
varchar2 |
Projektbeschreibung | filters on the platform, writable | Description of Project. | |
Quantity |
double |
Quantity | filters on the platform, writable | Quantity. | |
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 | Reference to subscription. | |
Subscription |
varchar2 |
Abonnement Beschreibung | filters on the platform, writable | Description of Subscription. | |
To |
datetime |
To | filters on the platform, writable | To date for deferred revenue. | |
Tracking |
guid |
Verfolgungsnummer | filters on the platform, writable | Reference to tracking number. | |
Tracking |
varchar2 |
Suchnummer Beschreibung | filters on the platform, writable | Description of TrackingNumber. | |
Type |
int32 |
Type | filters on the platform, writable | Type: 30 = Purchase entry, 31 = Purchase 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. | |
VAT |
double |
Umsatzsteuer-Bemessungsgrundlage Währung | filters on the platform, writable | VAT base amount in the default currency of the company. | |
VAT |
double |
Umsatzsteuer-Bemessungsgrundlage in Währung | filters on the platform, writable | VAT base amount in the currency of the transaction. | |
VAT |
varchar2 |
Umsatzsteuer-IDNr. | filters on the platform, writable | VAT code. | |
VAT |
varchar2 |
USt. Code Beschreibung | filters on the platform, writable | Description of VAT code. | |
VAT |
double |
itgen_eol_vatnondeductiblepercentage | filters on the platform, writable | If not the full amount of the VAT is deductible, you can indicate a percentage for the non decuctible part.This is used during the entry of purchase invoices. | |
VAT |
double |
Umsatzsteuer Prozentsatz | filters on the platform, writable | VAT percentage. | |
Withholding |
double |
Quellensteuerbetrag, Währung der Aufteilung | filters on the platform, writable | Withholding tax amount for spanish legislation. | |
Withholding |
varchar2 |
Quellensteuer | filters on the platform, writable | Withholding tax key for spanish legislation. |
Tasten
| Key | Column | Bezieht sich auf | Kind | Description |
|---|---|---|---|---|
Purchase |
Asset |
Assets.ID |
Key | |
Purchase |
Cost |
Costcenters.Code |
Key | |
Purchase |
Cost |
Costunits.Code |
Key | |
Purchase |
GL |
GLAccounts.ID |
Key | |
Purchase |
Project |
Projects.ID |
Key | |
Purchase |
Subscription |
Subscriptions. |
Key | |
Purchase |
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: