PurchaseOrders: Exact Online Purchase Orders
insert update delete per partition webhook REST
- Katalog:
ExactOnlineREST - Schema:
PurchaseOrder - Primärschlüssel:
PurchaseOrderID - Label: Purchase 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 PurchaseOrders übermittelt.
API-Quelle
- Endpunkt:
/api/v1/{division}/purchaseorder/PurchaseOrders - 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 PurchaseOrders 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 | Total amount in the default currency of the company. | |
Amount |
double |
Betrag Rabatt | filters on the platform, writable | ||
Amount |
double |
Amount Discount excluding VAT | Filter auf der Plattform | ||
Amount |
double |
Summe Fremdwährung | filters on the platform, writable | Total amount in the currency of the transaction. | |
Amount |
double |
Betrag in Währung ohne Mehrwertsteuer | Filter auf der Plattform | ||
Approval |
int16 |
Genehmigungsstatus | Filter auf der Plattform | ||
Approval |
varchar2 |
Genehmigungsstatus Beschreibung | Filter auf der Plattform | ||
Approved |
datetime |
Approved | Filter auf der Plattform | ||
Approver |
guid |
Approver | Filter auf der Plattform | ||
Approver |
varchar2 |
Vollständigen Namen bestätigen | Filter auf der Plattform | ||
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. | |
Currency |
varchar2 |
Currency | filters on the platform, writable | Currency code. | |
Delivery |
guid |
Lieferkonto | filters on the platform, writable | Reference to account for delivery. | |
Delivery |
varchar2 |
Lieferkontocode | filters on the platform, writable | Delivery account code. | |
Delivery |
varchar2 |
Name des Lieferkontos | filters on the platform, writable | Name of account. | |
Delivery |
guid |
Lieferadresse | filters on the platform, writable | Reference to shipping address. | |
Delivery |
guid |
Ansprechpartner für die Lieferung | filters on the platform, writable | Reference to contact for delivery. | |
Delivery |
varchar2 |
Ansprechpartner für die Lieferung – Vollständiger Name | filters on the platform, writable | Name of the contact person of the customer who will receive delivered goods. | |
Description |
varchar2 |
Description | filters on the platform, writable | Description of the purchase order. | |
Discount |
double |
Discount | filters on the platform, writable | ||
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 purchase order. | |
Document |
varchar2 |
Dokument Betreff | filters on the platform, writable | Subject of the document. | |
Drop |
char |
Direktlieferung | filters on the platform, writable | Shows if it is a drop shipment purchase order. | |
Exchange |
double |
Wechselkurs | filters on the platform, writable | Allows you to set the currency for the invoice.You can only do this if you have checked the Variable: Currency and Variable: Exchange rate fields in the sales journal settings.Once a line has been created in the invoice, the currency can no longer be changed. | |
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 |
int32 |
Rechnungsstatus | filters on the platform, writable | Invoice status of purchase order: 10-Open, 20-Partial, 30-Complete, 40-Canceled. | |
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. | |
Order |
datetime |
Orderdatum | filters on the platform, writable | Order date. | |
Order |
int32 |
Bestellnummer | filters on the platform, writable | Human readable id of the purchase order. | |
Order |
int32 |
Bestellstatus | filters on the platform, writable | Purchase order status: 10-Open, 20-Partial, 30-Complete, 40-Canceled. | |
Payment |
varchar2 |
Zahlungsbedingung | filters on the platform, writable | The payment condition code used for due date and discount calculation. | |
Payment |
varchar2 |
Zahlungsbedingung Beschreibung | filters on the platform, writable | Description of payment condition. | |
Purchase |
guid |
Einkaufsbeauftragter | filters on the platform, writable | Purchase agent. | |
Purchase |
varchar2 |
Vollständiger Name des Einkäufers | filters on the platform, writable | Name of purchase agent. | |
Purchase |
guid |
Bestellnummer | filters on the platform, writable | Primary key. | |
Purchase |
int32 |
itgen_eol_purchaseorderlinecount | Filter auf der Plattform | ||
Receipt |
datetime |
Eingangsdatum | filters on the platform, writable | This field shows the date the goods are expected to be received. | |
Receipt |
int32 |
Empfangsstatus | filters on the platform, writable | Receipt status of purchase order: 10-Open, 20-Partial, 30-Complete, 40-Canceled. | |
Remarks |
varchar2 |
Remarks | filters on the platform, writable | Include any relevant remarks regarding the purchase order. | |
Sales |
guid |
Kundenauftrag | filters on the platform, writable | Reference to sales order when purchase order generated via back to back sales order. | |
Sales |
int32 |
Auftragsnummer | filters on the platform, writable | Number of the sales order. | |
Selection |
guid |
Auswahlcode | Filter auf der Plattform | ID of selection code. | |
Selection |
varchar2 |
Auswahlcode | Filter auf der Plattform | Code of selection code. | |
Selection |
varchar2 |
itgen_eol_selectioncodedescription | Filter auf der Plattform | Description of selection code. | |
Shipping |
guid |
Versandart | filters on the platform, writable | ShippingMethod. | |
Shipping |
varchar2 |
Versandart-Code | Filter auf der Plattform | ||
Shipping |
varchar2 |
Beschreibung der Versandart | filters on the platform, writable | Description of ShippingMethod. | |
Source |
int16 |
Source | filters on the platform, writable | This shows how the purchase order was created: 1-Manual entry, 2-Import, 3-Other, 4-Purchase order, 5-Sales order, 6-Supplier's items, 7-Subcontract, 8-Purchase order advice, 9-Shop order, 10-MRP calculation. | |
Supplier |
guid |
Supplier | filters on the platform, writable | Reference to supplier account. | |
Supplier |
varchar2 |
Lieferantencode | filters on the platform, writable | Code of supplier. | |
Supplier |
guid |
Ansprechpartner beim Lieferanten | filters on the platform, writable | Contact of supplier. | |
Supplier |
varchar2 |
Vollständiger Name des Ansprechpartners beim Lieferanten | filters on the platform, writable | Contact person full name of supplier. | |
Supplier |
varchar2 |
Name des Anbieters | filters on the platform, writable | Name of supplier. | |
VAT |
double |
Umsatzsteuer-Betrag | filters on the platform, writable | Total VAT amount in the currency of the transaction. | |
Warehouse |
guid |
Warehouse | filters on the platform, writable | Warehouse. | |
Warehouse |
varchar2 |
Lager Code | filters on the platform, writable | Code of Warehouse. | |
Warehouse |
varchar2 |
Lager Beschreibung | filters on the platform, writable | Description of Warehouse. | |
Your |
varchar2 |
Ihre Referenz | filters on the platform, writable | Shows the reference number associated with the purchase order.Enter a description and reference to make the purchase order easier to identify. |
Tasten
| Key | Column | Bezieht sich auf | Kind | Description |
|---|---|---|---|---|
Purchase |
Creator |
Users. |
Key | |
Purchase |
Currency |
Currencies.Code |
Key | |
Purchase |
Delivery |
Accounts.ID |
Key | |
Purchase |
Delivery |
Addresses.ID |
Key | |
Purchase |
Delivery |
Contacts.ID |
Key | |
Purchase |
Document |
Documents.ID |
Key | |
Purchase |
Modifier |
Users. |
Key | |
Purchase |
Purchase |
Users. |
Key | |
Purchase |
Sales |
SalesOrders. |
Key | |
Purchase |
Selection |
SelectionCodes.ID |
Key | |
Purchase |
Shipping |
ShippingMethods.ID |
Key | |
Purchase |
Supplier |
Contacts.ID |
Key | |
Purchase |
Supplier |
Accounts.ID |
Key | |
Purchase |
Warehouse |
Warehouses.ID |
Key |
Verwiesen von
- GoodsReceiptLines
PurchaseOrderID(Key) - PurchaseOrderLines
PurchaseOrderID(Key) - SalesOrderLines
PurchaseOrder(Key) - SalesOrderLinesBulk
PurchaseOrder(Key)
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: