PurchaseOrderLines: Exact Online Purchase Order Lines
insert update delete per partition webhook REST
- Catalogo:
ExactOnlineREST - Schema:
PurchaseOrder - Chiavi primarie:
ID - Label: Purchase Order Lines
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 su PurchaseOrderID.
Codice sorgente dell'API
- Punto finale:
/api/v1/{division}/purchaseorder/PurchaseOrderLines - 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 PurchaseOrderLines. 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 | Amount in the default currency of the company. | |
Amount |
double |
Importo in valuta estera | filters on the platform, writable | Amount in the currency of the transaction. | |
Cost |
varchar2 |
Centro di costo | filters on the platform, writable | Reference to Cost center. | |
Cost |
varchar2 |
Descrizione del centro di costo | filters on the platform, writable | Description of CostCenter. | |
Cost |
varchar2 |
Unità del costo | filters on the platform, writable | Reference to Cost unit. | |
Cost |
varchar2 |
Unità del costo Descrizione | filters on the platform, writable | Description of CostUnit. | |
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. | |
Custom |
varchar2 |
Campo personalizzato | 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 |
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. | |
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 |
Descrizione delle spese | 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 |
Disponibile | 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 |
Quantità fatturata | writable | Quantity of item that has been invoiced. | |
Is |
int16 |
È un articolo con numero di lotto | filtri sulla piattaforma | ||
Is |
int16 |
È un articolo con numero di serie | filtri sulla piattaforma | ||
Item |
guid |
Item | filters on the platform, writable | Reference to the item for purchase order. | |
Item |
varchar2 |
Codice a barre dell'articolo | filtri sulla piattaforma | ||
Item |
varchar2 |
itgen_eol_itembarcodeadditional | filters on the platform, writable | ||
Item |
varchar2 |
Codice articolo | filters on the platform, writable | Item code. | |
Item |
varchar2 |
Descrizione dell'articolo | filters on the platform, writable | Description of item. | |
Item |
char |
Articolo divisibile | filters on the platform, writable | Indicates if fractional quantities of the item can be used, for example quantity = 0.4. | |
Line |
int32 |
Numero della linea | filters on the platform, writable | Line number. | |
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. | |
Net |
double |
Prezzo netto | 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 |
Codice del progetto | filters on the platform, writable | Project code.Only available with a professional service license. | |
Project |
varchar2 |
Descrizione del progetto | filters on the platform, writable | Description of the project.Only available with a professional service license. | |
Projected |
double |
Scorte previste | writable | The current stock level + the planned quantity to be received - the planned quantity to deliver shown in stock unit. | |
Purchase |
guid |
Numero dell'ordine di acquisto | 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 |
Quantità in unità di acquisto | 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 |
Data Ricezione | filters on the platform, writable | Date the goods are expected to be received. | |
Received |
double |
Quantità ricevuta | writable | Quantity of goods received. | |
Sales |
guid |
Ordine di vendita | filters on the platform, writable | Sales order that is linked to a back to back sales order in purchase order. | |
Sales |
guid |
Linea dell'ordine di vendita | 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 |
Numero della riga dell'ordine di vendita | filters on the platform, writable | Number of the sales order line. | |
Sales |
int32 |
Numero dell'ordine di vendita | filters on the platform, writable | Number of the sales order. | |
Shop |
guid |
Ordine del negozio | filters on the platform, writable | ||
Shop |
guid |
itgen_eol_shopordermaterialplan | filters on the platform, writable | ||
Shop |
int32 |
itgen_eol_shopordermaterialplanlinenumber | filtri sulla piattaforma | ||
Shop |
int32 |
Numero dell'ordine del negozio | filtri sulla piattaforma | ||
Shop |
guid |
itgen_eol_shoporderroutingstepplan | filters on the platform, writable | ||
Shop |
int32 |
itgen_eol_shoporderroutingstepplanlinenumber | filtri sulla piattaforma | ||
Supplier |
varchar2 |
Codice articolo del fornitore | 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 |
Descrizione dell'unità | filters on the platform, writable | Description of unit. | |
Unit |
double |
Prezzo unitario | writable | Item price per purchase unit. | |
VAT |
double |
Importo IVA | filters on the platform, writable | Amount of VAT charges calculated from total amount and vat percentage. | |
VAT |
varchar2 |
Codice IVA | filters on the platform, writable | The VAT code used when the invoice was registered. | |
VAT |
varchar2 |
Descrizione IVA | filters on the platform, writable | Description of the VAT code. | |
VAT |
double |
Percentuale IVA | 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. |
Chiavi
| Key | Column | Si riferisce a | 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 |
Riferito da
- PurchaseInvoiceLines
PurchaseOrderLine(Key) - GoodsReceiptLines
PurchaseOrderLineID(Key) - SalesOrderLines
PurchaseOrderLine(Key) - SalesOrderLinesBulk
PurchaseOrderLine(Key)
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: