PurchaseOrderLines: Exact Online Purchase Order Lines
insert update delete per partition webhook REST
- Katalog:
ExactOnlineREST - Schema:
PurchaseOrder - Primärschlüssel:
ID - Label: Purchase 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 PurchaseOrders am PurchaseOrderID übermittelt.
API-Quelle
- Endpunkt:
/api/v1/{division}/purchaseorder/PurchaseOrderLines - Metadaten:
/api/v1/{division}/purchaseorder/$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 PurchaseOrderLines 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 | filters on the platform, writable | Amount in the default currency of the company. | |
Amount |
double |
Summe Fremdwährung | filters on the platform, writable | Amount in the currency of the transaction. | |
Cost |
varchar2 |
Kostenstelle | filters on the platform, writable | Reference to Cost center. | |
Cost |
varchar2 |
Kostenstelle Beschreibung | filters on the platform, writable | Description of CostCenter. | |
Cost |
varchar2 |
Kostenträger | filters on the platform, writable | Reference to Cost unit. | |
Cost |
varchar2 |
Kostenträgerbeschreibung | filters on the platform, writable | Description of CostUnit. | |
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. | |
Custom |
varchar2 |
Benutzerdefiniertes Feld | writable | ||
Description |
varchar2 |
Description | filters on the platform, writable | Description of the purchase order line. | |
Discount |
double |
Discount | filters on the platform, writable | Discount in percentage for 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. | |
Expense |
guid |
Expense | filters on the platform, writable | Expense related to the Work Breakdown Structure of the selected project.Only available with a professional service license. | |
Expense |
varchar2 |
Ausgaben Beschreibung | filters on the platform, writable | Description of expense.Only available with a professional service license. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
In |
double |
Vorrätig | writable | The current stock level of items shown in stock unit.The information is displayed only for items with the stock property selected. | |
Invoiced |
double |
Rechnungsmenge | writable | Quantity of item that has been invoiced. | |
Is |
int16 |
Ist die Chargennummer vorhanden? | Filter auf der Plattform | ||
Is |
int16 |
Ist die Seriennummer vorhanden? | Filter auf der Plattform | ||
Item |
guid |
Item | filters on the platform, writable | Reference to the item for purchase order. | |
Item |
varchar2 |
Artikel-Barcode | Filter auf der Plattform | ||
Item |
varchar2 |
itgen_eol_itembarcodeadditional | filters on the platform, writable | ||
Item |
varchar2 |
Item Code | filters on the platform, writable | Item code. | |
Item |
varchar2 |
Artikelbeschreibung | filters on the platform, writable | Description of item. | |
Item |
char |
Artikel teilbar | filters on the platform, writable | Indicates if fractional quantities of the item can be used, for example quantity = 0.4. | |
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. | |
Net |
double |
Nettopreis | filters on the platform, writable | The net price is the unit price (VAT code taken into account) with any discount applied. | |
Notes |
varchar2 |
Notes | filters on the platform, writable | Notes. | |
Project |
guid |
Project | filters on the platform, writable | Reference to project.Only available with a professional service license. | |
Project |
varchar2 |
Projekt | filters on the platform, writable | Project code.Only available with a professional service license. | |
Project |
varchar2 |
Projektbeschreibung | filters on the platform, writable | Description of the project.Only available with a professional service license. | |
Projected |
double |
Prognostizierter Lagerbestand | writable | The current stock level + the planned quantity to be received - the planned quantity to deliver shown in stock unit. | |
Purchase |
guid |
Bestellnummer | filters on the platform, writable | Identifies the purchase order.All the lines of a purchase order have the same PurchaseOrderID. | |
Quantity |
double |
Quantity | filters on the platform, writable | Quantity in item units. | |
Quantity |
double |
Menge in Kauf-Einheiten | writable | Quantity in purchase units.Use this field when creating a purchase order. | |
Rebill |
char |
Rebill | filters on the platform, writable | Indicates whether the purchase order line needs to be rebilled.Only available with a professional service license. | |
Receipt |
datetime |
Eingangsdatum | filters on the platform, writable | Date the goods are expected to be received. | |
Received |
double |
Erhaltene Menge | writable | Quantity of goods received. | |
Sales |
guid |
Kundenauftrag | filters on the platform, writable | Sales order that is linked to a back to back sales order in purchase order. | |
Sales |
guid |
Auftragsposition | filters on the platform, writable | Sales order line of the sales order that is linked to a back to back sales order in purchase order. | |
Sales |
int32 |
Nummer der Kundenauftragsposition | filters on the platform, writable | Number of the sales order line. | |
Sales |
int32 |
Auftragsnummer | filters on the platform, writable | Number of the sales order. | |
Shop |
guid |
Shop Bestellung | filters on the platform, writable | ||
Shop |
guid |
itgen_eol_shopordermaterialplan | filters on the platform, writable | ||
Shop |
int32 |
itgen_eol_shopordermaterialplanlinenumber | Filter auf der Plattform | ||
Shop |
int32 |
Shop Bestellnummer | Filter auf der Plattform | ||
Shop |
guid |
itgen_eol_shoporderroutingstepplan | filters on the platform, writable | ||
Shop |
int32 |
itgen_eol_shoporderroutingstepplanlinenumber | Filter auf der Plattform | ||
Supplier |
varchar2 |
Lieferant Artikel Code | writable | Code the supplier uses for this item. | |
Supplier |
int16 |
itgen_eol_supplieritemcopyremarks | writable | Indicate if the notes content should be copied from SupplierItem's remarks.The default follows the CopyRemarks value from SupplierItem.Values: 0 = Do not copy remark, 1 = Copy remark. | |
Unit |
varchar2 |
Unit | filters on the platform, writable | Code of item unit. | |
Unit |
varchar2 |
Maßeinheit Beschreibung | filters on the platform, writable | Description of unit. | |
Unit |
double |
Einheit Preis | writable | Item price per purchase unit. | |
VAT |
double |
Umsatzsteuer-Betrag | filters on the platform, writable | Amount of VAT charges calculated from total amount and vat percentage. | |
VAT |
varchar2 |
Umsatzsteuer-IDNr. | filters on the platform, writable | The VAT code used when the invoice was registered. | |
VAT |
varchar2 |
USt. Beschreibung | filters on the platform, writable | Description of the VAT code. | |
VAT |
double |
Umsatzsteuer Prozentsatz | filters on the platform, writable | The VAT percentage of the VAT code.This is the percentage at the moment the invoice is created.It's also used by the default calculation of VAT amounts and VAT base amounts. |
Tasten
| Key | Column | Bezieht sich auf | Kind | Description |
|---|---|---|---|---|
Purchase |
Cost |
Costcenters.Code |
Key | |
Purchase |
Cost |
Costunits.Code |
Key | |
Purchase |
Creator |
Users. |
Key | |
Purchase |
Item |
Items.ID |
Key | |
Purchase |
Modifier |
Users. |
Key | |
Purchase |
Project |
Projects.ID |
Key | |
Purchase |
Purchase |
PurchaseOrders. |
Key | |
Purchase |
Sales |
SalesOrderLines.ID |
Key | |
Purchase |
Sales |
SalesOrders. |
Key | |
Purchase |
Unit |
Units.Code |
Key | |
Purchase |
VAT |
VATCodes.Code |
Key |
Verwiesen von
- PurchaseInvoiceLines
PurchaseOrderLine(Key) - GoodsReceiptLines
PurchaseOrderLineID(Key) - SalesOrderLines
PurchaseOrderLine(Key) - SalesOrderLinesBulk
PurchaseOrderLine(Key)
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: