PurchaseOrders: Exact Online Purchase Orders
insert update delete per partition webhook REST
- Catalogo:
ExactOnlineREST - Schema:
PurchaseOrder - Chiavi primarie:
PurchaseOrderID - Label: Purchase Orders
I dati in questa tabella sono partizionati per valore della colonna Division.
È possibile recuperare e modificare i dati utilizzando insert, update e delete.
Le modifiche vengono inviate tramite il topic del webhook PurchaseOrders.
Codice sorgente dell'API
- Punto finale:
/api/v1/{division}/purchaseorder/PurchaseOrders - Metadati:
/api/v1/{division}/purchaseorder/$metadata
Caratteristiche prestazionali
| Characteristic | Value |
|---|---|
| Latenza media di accesso (ms) | 5 |
| Righe di scansione completa al minuto | 7,200 |
| Numero di righe di Query al minuto | 300 |
| Scrittura di righe al minuto | 300 |
Il risultato può essere memorizzato nella memoria cache sul client.
Colonne della tabella
Di seguito sono riportate le colonne della tabella PurchaseOrders. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Amount |
double |
Valuta della divisione degli importi | filters on the platform, writable | Total amount in the default currency of the company. | |
Amount |
double |
Importo Sconto | filters on the platform, writable | ||
Amount |
double |
Importo Sconto IVA esclusa | filtri sulla piattaforma | ||
Amount |
double |
Importo in valuta estera | filters on the platform, writable | Total amount in the currency of the transaction. | |
Amount |
double |
Importo in valuta estera, IVA esclusa | filtri sulla piattaforma | ||
Approval |
int16 |
Stato di approvazione | filtri sulla piattaforma | ||
Approval |
varchar2 |
Descrizione dello stato di approvazione | filtri sulla piattaforma | ||
Approved |
datetime |
Approved | filtri sulla piattaforma | ||
Approver |
guid |
Approver | filtri sulla piattaforma | ||
Approver |
varchar2 |
Nome completo dell'approvatore | filtri sulla piattaforma | ||
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Creato | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Nome completo del creatore | filters on the platform, writable | Name of creator. | |
Currency |
varchar2 |
Currency | filters on the platform, writable | Currency code. | |
Delivery |
guid |
Account di consegna | filters on the platform, writable | Reference to account for delivery. | |
Delivery |
varchar2 |
Codice conto di consegna | filters on the platform, writable | Delivery account code. | |
Delivery |
varchar2 |
Nome dell'account di consegna | filters on the platform, writable | Name of account. | |
Delivery |
guid |
Indirizzo di consegna | filters on the platform, writable | Reference to shipping address. | |
Delivery |
guid |
Referente per le consegne | filters on the platform, writable | Reference to contact for delivery. | |
Delivery |
varchar2 |
Nome e cognome della persona di riferimento per la consegna | 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 |
Numero di iscrizione alla Camera di Commercio della Divisione | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Codice IBAN della divisione | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
Divisione - Nome dell'azienda | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Numero di divisione RSIN | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Partita IVA della divisione | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Codice fiscale salariale della divisione | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Etichetta della divisione | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Nome dell'amministrazione | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Nome del titolare dell'abbonamento | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Numero di abbonato | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Nome abbreviato della divisione | 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 |
Oggetto del documento | filters on the platform, writable | Subject of the document. | |
Drop |
char |
Spedizione diretta | filters on the platform, writable | Shows if it is a drop shipment purchase order. | |
Exchange |
double |
Tasso di cambio | 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 |
Indirizzo Incoterm | filters on the platform, writable | ||
Incoterm |
varchar2 |
Codice Incoterm | filters on the platform, writable | ||
Incoterm |
int16 |
Versione dell'Incoterm | filters on the platform, writable | ||
Invoice |
int32 |
Stato della fattura | 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 |
Modificato (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Nome completo modificato | filters on the platform, writable | Name of modifier. | |
Order |
datetime |
Data dell'ordine | filters on the platform, writable | Order date. | |
Order |
int32 |
Numero dell'ordine | filters on the platform, writable | Human readable id of the purchase order. | |
Order |
int32 |
Stato dell'ordine | filters on the platform, writable | Purchase order status: 10-Open, 20-Partial, 30-Complete, 40-Canceled. | |
Payment |
varchar2 |
Condizione di pagamento | filters on the platform, writable | The payment condition code used for due date and discount calculation. | |
Payment |
varchar2 |
Descrizione delle condizioni di pagamento | filters on the platform, writable | Description of payment condition. | |
Purchase |
guid |
Agente di acquisto | filters on the platform, writable | Purchase agent. | |
Purchase |
varchar2 |
Nome e cognome dell'agente di acquisto | filters on the platform, writable | Name of purchase agent. | |
Purchase |
guid |
Numero dell'ordine di acquisto | filters on the platform, writable | Primary key. | |
Purchase |
int32 |
itgen_eol_purchaseorderlinecount | filtri sulla piattaforma | ||
Receipt |
datetime |
Data Ricezione | filters on the platform, writable | This field shows the date the goods are expected to be received. | |
Receipt |
int32 |
Stato della ricevuta | 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 |
Ordine di vendita | filters on the platform, writable | Reference to sales order when purchase order generated via back to back sales order. | |
Sales |
int32 |
Numero dell'ordine di vendita | filters on the platform, writable | Number of the sales order. | |
Selection |
guid |
Codice di selezione | filtri sulla piattaforma | ID of selection code. | |
Selection |
varchar2 |
Codice di selezione | filtri sulla piattaforma | Code of selection code. | |
Selection |
varchar2 |
itgen_eol_selectioncodedescription | filtri sulla piattaforma | Description of selection code. | |
Shipping |
guid |
Metodo di spedizione | filters on the platform, writable | ShippingMethod. | |
Shipping |
varchar2 |
Codice del metodo di spedizione | filtri sulla piattaforma | ||
Shipping |
varchar2 |
Descrizione del metodo di spedizione | 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 |
Codice fornitore | filters on the platform, writable | Code of supplier. | |
Supplier |
guid |
Referente del fornitore | filters on the platform, writable | Contact of supplier. | |
Supplier |
varchar2 |
Nome e cognome della persona di riferimento del fornitore | filters on the platform, writable | Contact person full name of supplier. | |
Supplier |
varchar2 |
Nome del fornitore | filters on the platform, writable | Name of supplier. | |
VAT |
double |
Importo IVA | 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 |
Codice del magazzino | filters on the platform, writable | Code of Warehouse. | |
Warehouse |
varchar2 |
Descrizione del magazzino | filters on the platform, writable | Description of Warehouse. | |
Your |
varchar2 |
Il tuo Riferimento | 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. |
Chiavi
| Key | Column | Si riferisce a | 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 |
Riferito da
- GoodsReceiptLines
PurchaseOrderID(Key) - PurchaseOrderLines
PurchaseOrderID(Key) - SalesOrderLines
PurchaseOrder(Key) - SalesOrderLinesBulk
PurchaseOrder(Key)
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: