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

# SalesOrdersExploded: Exact Online Sales Orders (Exploded Structure)

`read only` `per partition` `REST`

- Katalog: `ExactOnlineREST`
- Schema: `SalesOrder`
- Primärschlüssel: `SolID`
- Label: Sales Orders (Exploded Structure)

Die Daten in dieser Tabelle sind nach dem Wert der Spalte `Division` aufgeteilt.

Es können nur Daten abgerufen werden.

## API-Quelle

- Endpunkt: `/api/v1/{division}/salesorder/SalesOrders?$expand=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 `SalesOrdersExploded` 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 | [ ] | filters on the platform, writable, `::ancestor.::ancestor.AmountDC` |  |
| `AmountFC` | `double` | Summe Fremdwährung | [ ] | filters on the platform, writable, `::ancestor.::ancestor.AmountFC` |  |
| `ApprovalStatus` | `int16` | Genehmigungsstatus | [ ] | filters on the platform, writable, `::ancestor.::ancestor.ApprovalStatus` |  |
| `ApprovalStatusDescription` | `varchar2` | Genehmigungsstatus Beschreibung | [ ] | filters on the platform, writable, `::ancestor.::ancestor.ApprovalStatusDescription` |  |
| `Approved` | `datetime` | Approved | [ ] | filters on the platform, writable, `::ancestor.::ancestor.Approved` |  |
| `Approver` | `guid` | Approver | [ ] | filters on the platform, writable, `::ancestor.::ancestor.Approver` |  |
| `ApproverFullName` | `varchar2` | Vollständigen Namen bestätigen | [ ] | filters on the platform, writable, `::ancestor.::ancestor.ApproverFullName` |  |
| `Created` | `datetime` | Created | [ ] | filters on the platform, writable, `::ancestor.::ancestor.Created` |  |
| `Creator` | `guid` | Creator | [ ] | filters on the platform, writable, `::ancestor.::ancestor.Creator` |  |
| `CreatorFullName` | `varchar2` | Ersteller vollständiger Name | [ ] | filters on the platform, writable, `::ancestor.::ancestor.CreatorFullName` |  |
| `Currency` | `varchar2` | Currency | [ ] | filters on the platform, writable, `::ancestor.::ancestor.Currency` |  |
| `DeliverTo` | `guid` | Liefern an | [ ] | filters on the platform, writable, `::ancestor.::ancestor.DeliverTo` |  |
| `DeliverToContactPerson` | `guid` | An den Ansprechpartner liefern | [ ] | filters on the platform, writable, `::ancestor.::ancestor.DeliverToContactPerson` |  |
| `DeliverToContactPersonFullName` | `varchar2` | Lieferung an Ansprechpartner – Vollständiger Name | [ ] | filters on the platform, writable, `::ancestor.::ancestor.DeliverToContactPersonFullName` |  |
| `DeliverToName` | `varchar2` | An Namen liefern | [ ] | filters on the platform, writable, `::ancestor.::ancestor.DeliverToName` |  |
| `DeliveryAddress` | `guid` | Lieferadresse | [ ] | filters on the platform, writable, `::ancestor.::ancestor.DeliveryAddress` |  |
| `DeliveryDate` | `datetime` | Liefertermin | [ ] | filters on the platform, writable, `::ancestor.::ancestor.DeliveryDate` |  |
| `DeliveryStatus` | `int16` | Lieferstatus | [ ] | filters on the platform, writable, `::ancestor.::ancestor.DeliveryStatus` |  |
| `DeliveryStatusDescription` | `varchar2` | Beschreibung des Lieferstatus | [ ] | writable, `::ancestor.::ancestor.DeliveryStatusDescription` |  |
| `Description` | `varchar2` | Description | [ ] | filters on the platform, writable, `::ancestor.::ancestor.Description` |  |
| `Division` | `int32` | Division | [ ] | filters on the platform, writable, `::ancestor.::ancestor.Division` |  |
| `Document` | `guid` | Document | [ ] | filters on the platform, writable, `::ancestor.::ancestor.Document` |  |
| `DocumentNumber` | `int32` | Dokumentnummer | [ ] | filters on the platform, writable, `::ancestor.::ancestor.DocumentNumber` |  |
| `DocumentSubject` | `varchar2` | Dokument Betreff | [ ] | filters on the platform, writable, `::ancestor.::ancestor.DocumentSubject` |  |
| `InvoiceStatus` | `int16` | Rechnungsstatus | [ ] | filters on the platform, writable, `::ancestor.::ancestor.InvoiceStatus` |  |
| `InvoiceStatusDescription` | `varchar2` | Rechnungsstatus – Beschreibung | [ ] | writable, `::ancestor.::ancestor.InvoiceStatusDescription` |  |
| `InvoiceTo` | `guid` | Rechnung an | [ ] | filters on the platform, writable, `::ancestor.::ancestor.InvoiceTo` |  |
| `InvoiceToContactPerson` | `guid` | Rechnung an Ansprechpartner | [ ] | filters on the platform, writable, `::ancestor.::ancestor.InvoiceToContactPerson` |  |
| `InvoiceToContactPersonFullName` | `varchar2` | Rechnungsempfänger: Vollständiger Name des Ansprechpartners | [ ] | filters on the platform, writable, `::ancestor.::ancestor.InvoiceToContactPersonFullName` |  |
| `InvoiceToName` | `varchar2` | Rechnungsempfänger | [ ] | filters on the platform, writable, `::ancestor.::ancestor.InvoiceToName` |  |
| `Modified` | `datetime` | Modified | [ ] | filters on the platform, writable, `::ancestor.::ancestor.Modified` |  |
| `Modifier` | `guid` | Modifier | [ ] | filters on the platform, writable, `::ancestor.::ancestor.Modifier` |  |
| `ModifierFullName` | `varchar2` | Geänderter vollständiger Name | [ ] | filters on the platform, writable, `::ancestor.::ancestor.ModifierFullName` |  |
| `OrderDate` | `datetime` | Orderdatum | [ ] | filters on the platform, writable, `::ancestor.::ancestor.OrderDate` |  |
| `OrderID` | `guid` | Bestellung ID | [x] | filters on the platform, writable, `::ancestor.::ancestor.OrderID` |  |
| `OrderNumber` | `int32` | Bestellnummer | [ ] | filters on the platform, writable, `::ancestor.::ancestor.OrderNumber` |  |
| `OrderedBy` | `guid` | Bestellt von | [ ] | filters on the platform, writable, `::ancestor.::ancestor.OrderedBy` |  |
| `OrderedByContactPerson` | `guid` | Sortiert nach Ansprechpartner | [ ] | filters on the platform, writable, `::ancestor.::ancestor.OrderedByContactPerson` |  |
| `OrderedByContactPersonFullName` | `varchar2` | Sortiert nach vollständigem Namen des Ansprechpartners | [ ] | filters on the platform, writable, `::ancestor.::ancestor.OrderedByContactPersonFullName` |  |
| `OrderedByName` | `varchar2` | Nach Namen sortiert | [ ] | filters on the platform, writable, `::ancestor.::ancestor.OrderedByName` |  |
| `PaymentCondition` | `varchar2` | Zahlungsbedingung | [ ] | filters on the platform, writable, `::ancestor.::ancestor.PaymentCondition` |  |
| `PaymentConditionDescription` | `varchar2` | Zahlungsbedingung Beschreibung | [ ] | filters on the platform, writable, `::ancestor.::ancestor.PaymentConditionDescription` |  |
| `PaymentReference` | `varchar2` | Zahlungsreferenz | [ ] | filters on the platform, writable, `::ancestor.::ancestor.PaymentReference` |  |
| `Remarks` | `varchar2` | Remarks | [ ] | filters on the platform, writable, `::ancestor.::ancestor.Remarks` |  |
| `Salesperson` | `guid` | Verkaufer | [ ] | filters on the platform, writable, `::ancestor.::ancestor.Salesperson` |  |
| `SalespersonFullName` | `varchar2` | Vertriebsmitarbeiter vollständiger Name | [ ] | filters on the platform, writable, `::ancestor.::ancestor.SalespersonFullName` |  |
| `ShippingMethod` | `guid` | Versandart | [ ] | filters on the platform, writable, `::ancestor.::ancestor.ShippingMethod` |  |
| `ShippingMethodDescription` | `varchar2` | Beschreibung der Versandart | [ ] | filters on the platform, writable, `::ancestor.::ancestor.ShippingMethodDescription` |  |
| `SolAmountDC` | `double` | Betrag der Auftragsposition – Währung der Division | [ ] | writable, `AmountDC` |  |
| `SolAmountFC` | `double` | Betrag der Kundenauftragsposition in der Währung | [ ] | writable, `AmountFC` |  |
| `SolCostCenter` | `varchar2` | Kostenstelle für Kundenauftragspositionen | [ ] | writable, `CostCenter` |  |
| `SolCostCenterDescription` | `varchar2` | itgen_eol_solcostcenterdescription | [ ] | writable, `CostCenterDescription` |  |
| `SolCostPriceFC` | `double` | Kostpreis der Kundenauftragsposition in Fremdwährung | [ ] | writable, `CostPriceFC` |  |
| `SolCostUnit` | `varchar2` | Kostenträger der Kundenauftragsposition | [ ] | writable, `CostUnit` |  |
| `SolCostUnitDescription` | `varchar2` | itgen_eol_solcostunitdescription | [ ] | writable, `CostUnitDescription` |  |
| `SolDeliveryDate` | `datetime` | Liefertermin der Kundenauftragsposition | [ ] | writable, `DeliveryDate` |  |
| `SolDescription` | `varchar2` | Beschreibung der Kundenauftragsposition | [ ] | writable, `Description` |  |
| `SolDiscount` | `double` | Rabatt auf eine Auftragsposition | [ ] | writable, `Discount` |  |
| `SolDivision` | `int32` | Auftragszeilen-Aufteilung | [ ] | writable, `Division` |  |
| `SolID` | `guid` | ID der Kundenauftragszeile | [x] | writable, `ID` |  |
| `SolItem` | `guid` | Auftragsposition | [ ] | writable, `Item` |  |
| `SolItemCode` | `varchar2` | Code für Kundenauftragsposition | [ ] | writable, `ItemCode` |  |
| `SolItemDescription` | `varchar2` | Beschreibung der Kundenauftragsposition | [ ] | writable, `ItemDescription` |  |
| `SolItemVersion` | `guid` | Version der Kundenauftragsposition | [ ] | writable, `ItemVersion` |  |
| `SolItemVersionDescription` | `varchar2` | itgen_eol_solitemversiondescription | [ ] | writable, `ItemVersionDescription` |  |
| `SolLineNumber` | `int32` | Nummer der Kundenauftragsposition | [ ] | writable, `LineNumber` |  |
| `SolMargin` | `double` | Marge pro Auftragsposition | [ ] | writable, `Margin` |  |
| `SolNetAmountFC` | `double` | Nettobetrag der Kundenauftragsposition in Fremdwährung | [ ] | writable |  |
| `SolNetPrice` | `double` | Nettopreis der Kundenauftragsposition | [ ] | writable, `NetPrice` |  |
| `SolNotes` | `varchar2` | Anmerkungen zu Auftragspositionen | [ ] | writable, `Notes` |  |
| `SolOrderNumber` | `int32` | Auftragsnummer | [ ] | writable, `OrderNumber` |  |
| `SolPricelist` | `guid` | Preisliste für Kundenauftragspositionen | [ ] | writable, `Pricelist` |  |
| `SolPricelistDescription` | `varchar2` | itgen_eol_solpricelistdescription | [ ] | writable, `PricelistDescription` |  |
| `SolProject` | `guid` | Projekt „Kundenauftragsposition“ | [ ] | writable, `Project` |  |
| `SolProjectDescription` | `varchar2` | itgen_eol_solprojectdescription | [ ] | writable, `ProjectDescription` |  |
| `SolQuantity` | `double` | Menge pro Kundenauftragsposition | [ ] | writable, `Quantity` |  |
| `SolQuantityDelivered` | `double` | itgen_eol_solquantitydelivered | [ ] | writable, `QuantityDelivered` |  |
| `SolQuantityInvoiced` | `double` | Rechnungsmenge der Kundenauftragsposition | [ ] | writable, `QuantityInvoiced` |  |
| `SolShopOrder` | `guid` | Kundenauftragsposition, Fertigungsauftrag | [ ] | writable, `ShopOrder` |  |
| `SolTaxSchedule` | `guid` | Steuerplan für Kundenauftragszeilen | [ ] | writable, `TaxSchedule` |  |
| `SolTaxScheduleCode` | `varchar2` | Steuerplan-Code für Kundenauftragspositionen | [ ] | writable, `TaxScheduleCode` |  |
| `SolTaxScheduleDescription` | `varchar2` | itgen_eol_soltaxscheduledescription | [ ] | writable, `TaxScheduleDescription` |  |
| `SolUnitCode` | `varchar2` | Stückzahlcode der Kundenauftragsposition | [ ] | writable, `UnitCode` |  |
| `SolUnitDescription` | `varchar2` | Stückbeschreibung in der Kundenauftragszeile | [ ] | writable, `UnitDescription` |  |
| `SolUnitPrice` | `double` | Stückpreis der Kundenauftragsposition | [ ] | writable, `UnitPrice` |  |
| `SolUseDropShipment` | `int16` | Verwendung von Direktversand in Kundenauftragszeilen | [x] | writable, `UseDropShipment` |  |
| `SolVATAmountFC` | `double` | Umsatzsteuerbetrag der Auftragsposition in der Währung | [ ] | writable, `VATAmount` |  |
| `SolVATCode` | `varchar2` | USt.-Kennzeichen der Kundenauftragsposition | [ ] | writable, `VATCode` |  |
| `SolVATCodeDescription` | `varchar2` | itgen_eol_solvatcodedescription | [ ] | writable, `VATCodeDescription` |  |
| `SolVATPercentage` | `double` | Mehrwertsteuersatz für Kundenauftragspositionen | [ ] | writable, `VATPercentage` |  |
| `Status` | `int16` | Status | [ ] | filters on the platform, writable, `::ancestor.::ancestor.Status` |  |
| `StatusDescription` | `varchar2` | Status-Beschreibung | [ ] | writable, `::ancestor.::ancestor.StatusDescription` |  |
| `TaxSchedule` | `guid` | Steuerübersicht | [ ] | filters on the platform, writable, `::ancestor.::ancestor.TaxSchedule` |  |
| `TaxScheduleCode` | `varchar2` | Steuer-Tarifcode | [ ] | filters on the platform, writable, `::ancestor.::ancestor.TaxScheduleCode` |  |
| `TaxScheduleDescription` | `varchar2` | Beschreibung der Steuertabelle | [ ] | filters on the platform, writable, `::ancestor.::ancestor.TaxScheduleDescription` |  |
| `WarehouseCode` | `varchar2` | Lager Code | [ ] | filters on the platform, writable, `::ancestor.::ancestor.WarehouseCode` |  |
| `WarehouseDescription` | `varchar2` | Lager Beschreibung | [ ] | filters on the platform, writable, `::ancestor.::ancestor.WarehouseDescription` |  |
| `WarehouseID` | `guid` | Lager ID | [ ] | filters on the platform, writable, `::ancestor.::ancestor.WarehouseID` |  |
| `YourRef` | `varchar2(60)` | Ihre Referenz | [ ] | filters on the platform, writable, `::ancestor.::ancestor.YourRef` |  |


## 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)
