GoodsDeliveryLines: Exact Online Goods Delivery Lines
insert update delete per partition webhook REST
- Katalog:
ExactOnlineREST - Schema:
SalesOrder - Primärschlüssel:
ID - Label: Goods Delivery 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 GoodsDeliveries am EntryID übermittelt.
API-Quelle
- Endpunkt:
/api/v1/{division}/salesorder/GoodsDeliveryLines - 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 GoodsDeliveryLines 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 |
|---|---|---|---|---|---|
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Angelegt | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Ersteller vollständiger Name | filters on the platform, writable | Name of creator. | |
Customer |
varchar2 |
Kundenartikelcode | Filter auf der Plattform | Code the customer uses for this item. | |
Delivery |
datetime |
Liefertermin | filters on the platform, writable | Date of goods delivery. | |
Description |
varchar2 |
Description | filters on the platform, writable | Description of sales order delivery. | |
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 | The EntryID identifies the goods delivery.All the lines of a goods delivery have the same EntryID. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Item |
guid |
Item | filters on the platform, writable | Reference to item. | |
Item |
varchar2 |
Item Code | filters on the platform, writable | Item code. | |
Item |
varchar2 |
Artikelbeschreibung | filters on the platform, writable | Description of item. | |
Line |
int32 |
Zeilen Nummer | filters on the platform, writable | Line number. | |
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 | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Geänderter vollständiger Name | filters on the platform, writable | Name of modifier. | |
Notes |
varchar2 |
Notes | filters on the platform, writable | Notes. | |
Quantity |
double |
Gelieferte Menge | writable | Quantity delivered. | |
Quantity |
double |
Bestellte Menge | writable | Quantity ordered. | |
Sales |
guid |
ID der Kundenauftragszeile | filters on the platform, writable | Reference to sales order. | |
Sales |
int32 |
Nummer der Kundenauftragsposition | filters on the platform, writable | Sales order line number. | |
Sales |
int32 |
Auftragsnummer | filters on the platform, writable | Sales order number. | |
Storage |
guid |
Speicherort | filters on the platform, writable | Reference to storage location. | |
Storage |
varchar2 |
Lagerstandortcode | filters on the platform, writable | Storage location code. | |
Storage |
varchar2 |
Lagerort – Beschreibung | filters on the platform, writable | Storage location description. | |
Tracking |
varchar2 |
Verfolgungsnummer | filters on the platform, writable | Reference to tracking number. | |
Unitcode |
varchar2 |
Einheit Code | filters on the platform, writable | Code of item unit. |
Tasten
| Key | Column | Bezieht sich auf | Kind | Description |
|---|---|---|---|---|
Goods |
Creator |
Users. |
Key | |
Goods |
Entry |
GoodsDeliveries. |
Key | |
Goods |
Item |
Items.ID |
Key | |
Goods |
Modifier |
Users. |
Key | |
Goods |
Sales |
SalesOrderLines.ID |
Key | |
Goods |
Storage |
StorageLocations.ID |
Key |
Verwiesen von
- PlannedSalesReturnLines
GoodDeliveryLineID(Key)
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: