SalesOrders: Exact Online Sales Orders
insert update delete per partition webhook REST
- Katalog:
ExactOnlineREST - Schema:
SalesOrder - Primärschlüssel:
OrderID - Label: Sales Orders
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 übermittelt.
API-Quelle
- Endpunkt:
/api/v1/{division}/salesorder/SalesOrders - 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 SalesOrders 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. | |
Amount |
double |
Betrag Rabatt | writable | Discount amount in the default currency of the company. | |
Amount |
double |
Amount Discount excluding VAT | writable | Discount amount exclude VAT in the default currency of the company. | |
Amount |
double |
Summe Fremdwährung | writable | Amount in the currency of the transaction. | |
Amount |
double |
Betrag in Währung ohne Mehrwertsteuer | writable | Amount exclude VAT in the currency of the transaction. | |
Approval |
int16 |
Genehmigungsstatus | filters on the platform, writable | Shows if this sales order is approved. | |
Approval |
varchar2 |
Genehmigungsstatus Beschreibung | writable | Description of ApprovalStatus. | |
Approved |
datetime |
Approved | writable | Approval datetime. | |
Approver |
guid |
Approver | filters on the platform, writable | User who approved the sales order. | |
Approver |
varchar2 |
Vollständigen Namen bestätigen | writable | Name of approver. | |
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Angelegt | writable | Creation date in UTC. | |
Creator |
guid |
Creator | writable | User ID of creator. | |
Creator |
varchar2 |
Ersteller vollständiger Name | writable | Name of creator. | |
Currency |
varchar2 |
Currency | writable | Currency code. | |
Deliver |
guid |
Liefern an | filters on the platform, writable | Reference to delivery customer. | |
Deliver |
guid |
An den Ansprechpartner liefern | filters on the platform, writable | Reference to contact person of delivery customer. | |
Deliver |
varchar2 |
Lieferung an Ansprechpartner – Vollständiger Name | writable | Name of contact person of delivery customer. | |
Deliver |
varchar2 |
An Namen liefern | writable | Name of delivery customer. | |
Delivery |
guid |
Lieferadresse | filters on the platform, writable | Delivery address. | |
Delivery |
datetime |
Liefertermin | filters on the platform, writable | Delivery date. | |
Delivery |
int16 |
Lieferstatus | filters on the platform, writable | Delivery status; 12=Open, 20=Partial, 21=Complete, 45=Canceled. | |
Delivery |
varchar2 |
Beschreibung des Lieferstatus | writable | Description of DeliveryStatus. | |
Description |
varchar2 |
Description | filters on the platform, writable | Description. | |
Discount |
double |
Discount | writable | Discount percentage. | |
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. | |
Document |
guid |
Document | filters on the platform, writable | Document that is manually linked to the sales order. | |
Document |
int32 |
Dokumentnummer | writable | Number of the document. | |
Document |
varchar2 |
Dokument Betreff | writable | Subject of the document. | |
Incoterm |
varchar2 |
Incoterm-Adresse | filters on the platform, writable | ||
Incoterm |
varchar2 |
Incoterm-Code | filters on the platform, writable | ||
Incoterm |
int16 |
Incoterm-Version | filters on the platform, writable | ||
Invoice |
int16 |
Rechnungsstatus | filters on the platform, writable | Invoice status; 10=draft, 20=open, 50=processed. | |
Invoice |
varchar2 |
Rechnungsstatus – Beschreibung | writable | Description of InvoiceStatus. | |
Invoice |
guid |
Rechnung an | filters on the platform, writable | Reference to the Customer who will receive the invoice. | |
Invoice |
guid |
Rechnung an Ansprechpartner | filters on the platform, writable | Reference to the Contact person of the customer who will receive the invoice. | |
Invoice |
varchar2 |
Rechnungsempfänger: Vollständiger Name des Ansprechpartners | writable | Name of the contact person of the customer who will receive the invoice. | |
Invoice |
varchar2 |
Rechnungsempfänger | writable | Name of the customer who will receive the invoice. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Geändert (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | writable | User ID of modifier. | |
Modifier |
varchar2 |
Geänderter vollständiger Name | writable | Name of modifier. | |
Order |
datetime |
Orderdatum | filters on the platform, writable | Order date. | |
Order |
guid |
Bestellung ID | filters on the platform, writable | Primary key. | |
Order |
int32 |
Bestellnummer | filters on the platform, writable | Number of sales order. | |
Ordered |
guid |
Bestellt von | filters on the platform, writable | Customer who ordered the sales order. | |
Ordered |
guid |
Sortiert nach Ansprechpartner | filters on the platform, writable | Contact person of the customer who ordered the sales order. | |
Ordered |
varchar2 |
Sortiert nach vollständigem Namen des Ansprechpartners | writable | Name of contact person of the customer who ordered the sales order. | |
Ordered |
varchar2 |
Nach Namen sortiert | writable | Name of the customer who ordered the sales order. | |
Payment |
varchar2 |
Zahlungsbedingung | writable | The payment condition used for due date and discount calculation. | |
Payment |
varchar2 |
Zahlungsbedingung Beschreibung | writable | Description of PaymentCondition. | |
Payment |
varchar2 |
Zahlungsreferenz | filters on the platform, writable | Payment reference for sales order. | |
Remarks |
varchar2 |
Remarks | writable | Extra remarks. | |
Sales |
guid |
Verkaufskanal | Filter auf der Plattform | ||
Sales |
varchar2 |
Vertriebskanal-Code | Filter auf der Plattform | ||
Sales |
varchar2 |
Beschreibung des Vertriebskanals | Filter auf der Plattform | ||
Salesperson |
guid |
Verkaufer | filters on the platform, writable | Sales representative. | |
Salesperson |
varchar2 |
Vertriebsmitarbeiter vollständiger Name | writable | Name of sales representative. | |
Selection |
guid |
Auswahlcode | Filter auf der Plattform | ID of selection code. | |
Selection |
varchar2 |
Auswahlcode | Code of selection code. | ||
Selection |
varchar2 |
itgen_eol_selectioncodedescription | Description of selection code. | ||
Shipping |
guid |
Versandart | filters on the platform, writable | ShippingMethod. | |
Shipping |
varchar2 |
Beschreibung der Versandart | writable | Description of ShippingMethod. | |
Status |
int16 |
Status | filters on the platform, writable | The status of the sales order.12 = Open, 20 = Partial, 21 = Complete, 45 = Cancelled. | |
Status |
varchar2 |
Status-Beschreibung | writable | Description of Status. | |
Tax |
guid |
Steuerübersicht | filters on the platform, writable | Obsolete. | |
Tax |
varchar2 |
Steuer-Tarifcode | writable | Obsolete. | |
Tax |
varchar2 |
Beschreibung der Steuertabelle | writable | Obsolete. | |
Warehouse |
varchar2 |
Lager Code | writable | Code of Warehouse. | |
Warehouse |
varchar2 |
Lager Beschreibung | writable | Description of Warehouse. | |
Warehouse |
guid |
Lager ID | filters on the platform, writable | Warehouse. | |
Your |
varchar2 |
Ihre Referenz | filters on the platform, writable | The reference number of the customer. |
Tasten
| Key | Column | Bezieht sich auf | Kind | Description |
|---|---|---|---|---|
Sales |
Approver |
Users. |
Key | |
Sales |
Creator |
Users. |
Key | |
Sales |
Currency |
Currencies.Code |
Key | |
Sales |
Deliver |
Contacts.ID |
Key | |
Sales |
Deliver |
Accounts.ID |
Key | |
Sales |
Delivery |
Addresses.ID |
Key | |
Sales |
Document |
Documents.ID |
Key | |
Sales |
Invoice |
Contacts.ID |
Key | |
Sales |
Invoice |
Accounts.ID |
Key | |
Sales |
Modifier |
Users. |
Key | |
Sales |
Ordered |
Contacts.ID |
Key | |
Sales |
Ordered |
Accounts.ID |
Key | |
Sales |
Salesperson |
Users. |
Key | |
Sales |
Selection |
SelectionCodes.ID |
Key | |
Sales |
Shipping |
ShippingMethods.ID |
Key | |
Sales |
Warehouse |
Warehouses.ID |
Key |
Verwiesen von
- PurchaseOrderLines
SalesOrder(Key) - PurchaseOrders
SalesOrder(Key) - SalesInvoiceLines
SalesOrder(Key) - SalesInvoiceLinesBulk
SalesOrder(Key) - SalesOrderLines
OrderID(Key) - SalesOrderLinesBulk
OrderID(Key)
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: