SalesInvoiceLines: Exact Online Sales Invoice Lines
insert update delete per partition webhook REST
- Katalog:
ExactOnlineREST - Schema:
SalesInvoice - Primärschlüssel:
ID - Label: Sales Invoice 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 SalesInvoices am InvoiceID übermittelt.
API-Quelle
- Endpunkt:
/api/v1/{division}/salesinvoice/SalesInvoiceLines - Metadaten:
/api/v1/{division}/salesinvoice/$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 SalesInvoiceLines 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 | 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 | writable | For normal lines it's the amount excluding VAT. | |
Cost |
varchar2 |
Kostenstelle | filters on the platform, writable | Reference to Cost center. | |
Cost |
varchar2 |
Kostenstelle Beschreibung | writable | Description of CostCenter. | |
Cost |
varchar2 |
Kostenträger | filters on the platform, writable | Reference to Cost unit. | |
Cost |
varchar2 |
Kostenträgerbeschreibung | writable | Description of CostUnit. | |
Custom |
varchar2 |
Benutzerdefiniertes Feld | writable | ||
Customer |
varchar2 |
Kundenartikelcode | Code the customer uses for this item. | ||
Delivery |
datetime |
Liefertermin | writable | Delivery date of an item in a sales invoice.This is used for VAT on prepayments, only if sales order is not used in the license. | |
Description |
varchar2 |
Description | filters on the platform, writable | Description.Can be different for header and lines. | |
Discount |
double |
Discount | writable | Discount given on the default price.Discount = (DefaultPrice of Item - PriceItem in line) / DefaultPrice of Item. | |
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. | |
Employee |
guid |
Employee | filters on the platform, writable | Link to Employee originating from time and cost transactions. | |
Employee |
varchar2 |
Vollständiger Name des Mitarbeiters | writable | Name of employee. | |
End |
datetime |
Endzeit | writable | EndTime is used to store the last date of a period.EndTime is used in combination with StartTime. | |
Extra |
double |
Zuschlagsbetrag in Währung | 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 (%) | writable | Extra duty percentage. | |
GL |
guid |
Hauptbuchkonto | filters on the platform, writable | The GL Account of the sales invoice line.This field is mandatory.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 |
GL-Kontobeschreibung | writable | Description of the G/L account. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Invoice |
guid |
Rechnungs-ID | filters on the platform, writable | The InvoiceID identifies the sales invoice.All the lines of a sales invoice have the same InvoiceID. | |
Item |
guid |
Item | filters on the platform, writable | Reference to the item that is sold in this sales invoice line. | |
Item |
varchar2 |
Item Code | writable | Item code. | |
Item |
varchar2 |
Artikelbeschreibung | writable | Description of Item. | |
Line |
int32 |
Zeilen Nummer | filters on the platform, writable | Indicates the sequence of the lines within one invoice. | |
Net |
double |
Nettobetrag, Abteilung, Währung | writable | Net amount in division currency of sales invoice line. | |
Net |
double |
Nettobetrag in Währung | writable | Net amount in foreign currency of sales invoice line. | |
Net |
double |
Nettopreis | writable | Net price of the sales invoice line. | |
Notes |
varchar2 |
Notes | writable | Extra notes. | |
Pricelist |
guid |
Preisliste | filters on the platform, writable | Price list. | |
Pricelist |
varchar2 |
Preisliste Beschreibung | writable | Description of Pricelist. | |
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 | writable | Description of Project. | |
Project |
guid |
Projekt-WBS | writable | WBS linked to the sales invoice. | |
Project |
varchar2 |
Beschreibung der Projektstrukturplanung (WBS) | writable | Description of WBS. | |
Quantity |
double |
Quantity | writable | The number of items sold in default units.The quantity shown in the entry screen is Quantity * UnitFactor. | |
Sales |
guid |
Kundenauftrag | filters on the platform, writable | Identifies the sales order this invoice line is based on. | |
Sales |
guid |
Auftragsposition | filters on the platform, writable | Identifies the sales order line this sales invoice line is based on. | |
Sales |
int32 |
Nummer der Kundenauftragsposition | writable | Then line number of the sales order line on which this invoice line is based on. | |
Sales |
int32 |
Auftragsnummer | writable | The order number of the sales order on which this invoice line is based on. | |
Start |
datetime |
Startzeit | writable | StartTime is used to store the first date of a period.StartTime is used in combination with EndTime. | |
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 | writable | Description of subscription line. | |
Tax |
guid |
Steuerübersicht | filters on the platform, writable | Obsolete. | |
Tax |
varchar2 |
Steuer-Tarifcode | writable | Obsolete. | |
Tax |
varchar2 |
Beschreibung der Steuertabelle | writable | Obsolete. | |
Unit |
varchar2 |
Einheit Code | writable | Code of Unit. | |
Unit |
varchar2 |
Maßeinheit Beschreibung | writable | Description of Unit. | |
Unit |
double |
Einheit Preis | writable | Price per unit. | |
VAT |
double |
Umsatzsteuerbetrag Währung | writable | VAT amount in the default currency of the company. | |
VAT |
double |
USt. Summe Fremdwährung | writable | VAT amount in the currency of the transaction. | |
VAT |
varchar2 |
Umsatzsteuer-IDNr. | filters on the platform, writable | The VAT code that is used when the invoice is registered. | |
VAT |
varchar2 |
USt. Code Beschreibung | writable | Description of VAT code. | |
VAT |
double |
Umsatzsteuer Prozentsatz | writable | The vat percentage of the VAT code.This is the percentage at the moment the invoice is created.It's also used for the default calculation of VAT amounts and VAT base amounts. |
Tasten
| Key | Column | Bezieht sich auf | Kind | Description |
|---|---|---|---|---|
Sales |
Cost |
Costcenters.Code |
Key | |
Sales |
Cost |
Costunits.Code |
Key | |
Sales |
Employee |
Employees.ID |
Key | |
Sales |
GL |
GLAccounts.ID |
Key | |
Sales |
Invoice |
SalesInvoices. |
Key | |
Sales |
Item |
Items.ID |
Key | |
Sales |
Pricelist |
SalesPriceLists.ID |
Key | |
Sales |
Project |
ProjectWBS.ID |
Key | |
Sales |
Project |
Projects.ID |
Key | |
Sales |
Sales |
SalesOrderLines.ID |
Key | |
Sales |
Sales |
SalesOrders. |
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: