---
title: "SalesOrderLines (Exact Online)"
description: "Sales Order Lines"
language: de
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/de/datamodels/exactonline/ExactOnlineREST.SalesOrder.SalesOrderLines
original: https://documentation.invantive.eu/en/datamodels/exactonline/ExactOnlineREST.SalesOrder.SalesOrderLines
updated: 2026-11-16T20:57:33Z
license: https://documentation.invantive.eu/de/
---

# SalesOrderLines: Exact Online Sales Order Lines

`insert` `update` `delete` `per partition` `webhook` `REST`

- Katalog: `ExactOnlineREST`
- Schema: `SalesOrder`
- Primärschlüssel: `ID`
- Label: Sales Order 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 `SalesOrders` am `OrderID` übermittelt.

## API-Quelle

- Endpunkt: `/api/v1/{division}/salesorder/SalesOrderLines`
- Metadaten: `/api/v1/{division}/salesorder/$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 `SalesOrderLines` 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 |
|---|---|---|:---:|---|---|
| `AmountDC` | `double` | Betrag Sparte Währung | [x] | writable | Amount in the default currency of the company. |
| `AmountFC` | `double` | Summe Fremdwährung | [x] | writable | Amount in the currency of the transaction. |
| `CostCenter` | `varchar2(8)` | Kostenstelle | [ ] | filters on the platform, writable | Reference to Cost Center. |
| `CostCenterDescription` | `varchar2(60)` | Kostenstelle Beschreibung | [ ] | writable | Description of cost center. |
| `CostPriceFC` | `double` | Einkaufspreis in Währung | [ ] | writable | Item cost price. |
| `CostUnit` | `varchar2(8)` | Kostenträger | [ ] | filters on the platform, writable | Reference to Cost Unit. |
| `CostUnitDescription` | `varchar2(60)` | Kostenträgerbeschreibung | [ ] | writable | Description of cost unit. |
| `CustomField` | `varchar2` | Benutzerdefiniertes Feld | [ ] | Filter auf der Plattform |  |
| `CustomerItemCode` | `varchar2` | Kundenartikelcode | [ ] |  | Code the customer uses for this item. |
| `DeliveryDate` | `datetime` | Liefertermin | [ ] | filters on the platform, writable | Delivery date of this line. |
| `DeliveryStatus` | `int16` | Lieferstatus | [ ] | filters on the platform, writable | Shipping status of the sales order line.12=Open, 20=Partial, 21=Complete, 45=Cancelled. |
| `Description` | `varchar2` | Description | [ ] | filters on the platform, writable | Description. |
| `Discount` | `double` | Discount | [ ] | writable | Discount given on the default price.Discount = (DefaultPrice of Item - PriceItem in line) / DefaultPrice of Item. |
| `Division` | `int32` | Division | [x] |  | Division code. |
| `DivisionCompanyCoCNumber` | `varchar2(60)` | Nummer der Handelskammer des Bezirks | [ ] | writable | Chamber of commerce number of the Exact Online division. |
| `DivisionCompanyIBANNumber` | `varchar2(50)` | Abteilung IBAN-Nummer | [ ] | writable | IBAN number of the Exact Online division. |
| `DivisionCompanyName` | `varchar2(50)` | Geschäftsbereich Firmenname | [x] | writable | Company name of the Exact Online division. |
| `DivisionCompanyRSINNumber` | `varchar2(9)` | Abteilung RSIN-Nummer | [ ] | writable | RSIN number of the Exact Online division. |
| `DivisionCompanyVATNumber` | `varchar2(35)` | Umsatzsteuer-Identifikationsnummer der Abteilung | [ ] | writable | VAT number of the Exact Online division. |
| `DivisionCompanyWageTaxNumber` | `varchar2(60)` | Nummer der Lohnsteuerabteilung | [ ] | writable | Wage tax number of the Exact Online division. |
| `DivisionLabel` | `varchar2(128)` | Abteilungsbezeichnung | [x] | writable | Label of the Exact Online division. |
| `DivisionName` | `varchar2(50)` | Verwaltung Name | [x] | writable | Name of the Exact Online division. |
| `DivisionOwnerCompanyName` | `varchar2(50)` | Name des Abonnenten | [x] | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
| `DivisionOwnerCompanyNumber` | `varchar2(18)` | Abonnentennummer | [x] | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. |
| `DivisionShortName` | `int64` | Kurzbezeichnung der Abteilung | [x] | writable | Short name of the Exact Online division. |
| `ID` | `guid` | ID | [x] | filters on the platform, writable | Primary key. |
| `InvoiceStatus` | `int16` | Rechnungsstatus | [ ] | filters on the platform, writable | Invoice status of the sales order line.12=Open, 20=Partial, 21=Complete, 45=Cancelled. |
| `Item` | `guid` | Item | [ ] | filters on the platform, writable | Reference to the Item that is sold in this sales order line. |
| `ItemCode` | `varchar2(30)` | Item Code | [ ] | writable | Code of the item. |
| `ItemDescription` | `varchar2(255)` | Artikelbeschreibung | [ ] | writable | Description of Item. |
| `ItemVersion` | `guid` | Artikelversion | [ ] | filters on the platform, writable | Version of item. |
| `ItemVersionDescription` | `varchar2` | Artikel Version Beschreibung | [ ] | writable | Description of Item Version. |
| `LineNumber` | `int32` | Zeilen Nummer | [x] | filters on the platform, writable | Line number. |
| `Margin` | `double` | Margin | [ ] | writable | Sales margin of the sales order line. |
| `NetPrice` | `double` | Nettopreis | [ ] | writable | Net price of the sales order line. |
| `Notes` | `varchar2` | Notes | [ ] | writable | Extra notes. |
| `OrderID` | `guid` | Bestellung ID | [x] | filters on the platform, writable | Reference to Sales Order.All the lines of a sales order have the same OrderID. |
| `OrderNumber` | `int32` | Bestellnummer | [x] | filters on the platform, writable | Number of sales order. |
| `OrderStatus` | `int16` | Bestellstatus | [ ] | filters on the platform, writable | The status of the sales order line.12=Open, 20=Partial, 21=Complete, 45=Cancelled. |
| `Pricelist` | `guid` | Preisliste | [ ] | filters on the platform, writable | Reference to Price List. |
| `PricelistDescription` | `varchar2` | Preisliste Beschreibung | [ ] | writable | Description of Price List. |
| `Project` | `guid` | Project | [ ] | filters on the platform, writable | Reference to Project.The project can be different per line.Sometimes also the project in the header is filled although this is not really used. |
| `ProjectDescription` | `varchar2(60)` | Projektbeschreibung | [ ] | writable | Description of Project. |
| `PurchaseOrder` | `guid` | Auftrag | [ ] | writable | Reference to Purchase Order. |
| `PurchaseOrderLine` | `guid` | Bestellposition | [ ] | writable | Reference to Purchase Order Line. |
| `PurchaseOrderLineNumber` | `int32` | Bestellpositionsnummer | [ ] | writable | Line number of referenced Purchase Order Line. |
| `PurchaseOrderNumber` | `int32` | Einkauf Ordernummer | [ ] | writable | Number of referenced Purchase Order. |
| `Quantity` | `double` | Quantity | [ ] | writable | Number of items sold in default units.The quantity shown in the entry screen is Quantity * UnitFactor. |
| `QuantityDelivered` | `double` | Gelieferte Menge | [ ] | writable | The number of items delivered. |
| `QuantityInvoiced` | `double` | Rechnungsmenge | [ ] | writable | The number of items invoiced. |
| `ShopOrder` | `guid` | Shop Bestellung | [ ] | filters on the platform, writable | Reference to Shop Order. |
| `TaxSchedule` | `guid` | Steuerübersicht | [ ] | writable | Obsolete. |
| `TaxScheduleCode` | `varchar2` | Steuer-Tarifcode | [ ] | writable | Obsolete. |
| `TaxScheduleDescription` | `varchar2` | Beschreibung der Steuertabelle | [ ] | writable | Obsolete. |
| `UnitCode` | `varchar2(8)` | Einheit Code | [ ] | writable | Code of item unit. |
| `UnitDescription` | `varchar2(60)` | Maßeinheit Beschreibung | [ ] | writable | Description of Item Unit. |
| `UnitPrice` | `double` | Einheit Preis | [ ] | writable | Price per unit in the currency of the transaction. |
| `UseDropShipment` | `int16` | Direktlieferung verwenden | [x] | filters on the platform, writable | Indicates if drop shipment is used (delivery directly to customer, invoice to wholesaler). |
| `VATAmount` | `double` | Umsatzsteuer-Betrag | [ ] | writable | VAT amount in the currency of the transaction. |
| `VATCode` | `varchar2(3)` | Umsatzsteuer-IDNr. | [ ] | filters on the platform, writable | VAT code. |
| `VATCodeDescription` | `varchar2(60)` | USt. Code Beschreibung | [ ] | writable | Description of VAT code. |
| `VATPercentage` | `double` | Umsatzsteuer Prozentsatz | [ ] | writable | The VAT percentage of the VAT code.This is the percentage at the moment the sales order 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 |
|---|---|---|---|---|
| `SalesOrderLines_CostCenter_Costcenters_fk` | `CostCenter` | [Costcenters](ExactOnlineREST.HRM.Costcenters)`.Code` | Key |  |
| `SalesOrderLines_CostUnit_Costunits_fk` | `CostUnit` | [Costunits](ExactOnlineREST.HRM.Costunits)`.Code` | Key |  |
| `SalesOrderLines_ItemVersion_ItemVersions_fk` | `ItemVersion` | [ItemVersions](ExactOnlineREST.Logistics.ItemVersions)`.ID` | Key |  |
| `SalesOrderLines_Item_Items_fk` | `Item` | [Items](ExactOnlineREST.Logistics.Items)`.ID` | Key |  |
| `SalesOrderLines_OrderID_SalesOrders_fk` | `OrderID` | [SalesOrders](ExactOnlineREST.SalesOrder.SalesOrders)`.OrderID` | Key |  |
| `SalesOrderLines_Pricelist_SalesPriceLists_fk` | `Pricelist` | [SalesPriceLists](ExactOnlineREST.Sales.SalesPriceLists)`.ID` | Key |  |
| `SalesOrderLines_Project_Projects_fk` | `Project` | [Projects](ExactOnlineREST.Project.Projects)`.ID` | Key |  |
| `SalesOrderLines_PurchaseOrderLine_PurchaseOrderLines_fk` | `PurchaseOrderLine` | [PurchaseOrderLines](ExactOnlineREST.PurchaseOrder.PurchaseOrderLines)`.ID` | Key |  |
| `SalesOrderLines_PurchaseOrder_PurchaseOrders_fk` | `PurchaseOrder` | [PurchaseOrders](ExactOnlineREST.PurchaseOrder.PurchaseOrders)`.PurchaseOrderID` | Key |  |
| `SalesOrderLines_ShopOrder_ShopOrders_fk` | `ShopOrder` | [ShopOrders](ExactOnlineREST.Manufacturing.ShopOrders)`.ID` | Key |  |
| `SalesOrderLines_VATCode_VATCodes_fk` | `VATCode` | [VATCodes](ExactOnlineREST.VAT.VATCodes)`.Code` | Key |  |

## Verwiesen von

- [PurchaseOrderLines](ExactOnlineREST.PurchaseOrder.PurchaseOrderLines) `SalesOrderLine` (Key)
- [SalesInvoiceLines](ExactOnlineREST.SalesInvoice.SalesInvoiceLines) `SalesOrderLine` (Key)
- [SalesInvoiceLinesBulk](ExactOnlineREST.SalesInvoice.SalesInvoiceLinesBulk) `SalesOrderLine` (Key)
- [DigitalOrderPickingLines](ExactOnlineREST.SalesOrder.DigitalOrderPickingLines) `SalesOrderLineID` (Key)
- [GoodsDeliveryLines](ExactOnlineREST.SalesOrder.GoodsDeliveryLines) `SalesOrderLineID` (Key)
- [GoodsDeliveryLinesBulk](ExactOnlineREST.SalesOrder.GoodsDeliveryLinesBulk) `SalesOrderLineID` (Key)
- [PlannedSalesReturnLines](ExactOnlineREST.SalesOrder.PlannedSalesReturnLines) `SalesOrderLineID` (Key)


## Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert:

- [Exact Online](/de/release-notes/drivers?driver=exact-online)
