PurchaseInvoiceLines: Exact Online Purchase Invoice Lines
insert update delete per partition REST
- Catalogo:
ExactOnlineREST - Schema:
Purchase - Chiavi primarie:
ID - Label: Purchase Invoice Lines
I dati in questa tabella sono partizionati per valore della colonna Division.
È possibile recuperare e modificare i dati utilizzando insert, update e delete.
Codice sorgente dell'API
- Punto finale:
/api/v1/{division}/purchase/PurchaseInvoiceLines - Metadati:
/api/v1/{division}/purchase/$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 PurchaseInvoiceLines. 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 |
Amount | writable | Amount in foreign currency.In a select the line amount is always returned excluding VAT.In an update request the line amount has to be submitted either including or excluding the VAT amount.This depends on the type (including or excluding) of the VAT code. | |
Amount |
double |
Valuta della divisione degli importi | filters on the platform, writable | ||
Cost |
varchar2 |
Centro di costo | filters on the platform, writable | The code of the cost center that is linked to this invoice line. | |
Cost |
varchar2 |
Unità del costo | filters on the platform, writable | The code of the cost unit that is linked to this invoice line. | |
Currency |
varchar2 |
Currency | writable | The currency of the line amount.The total invoice amount and all individual line amounts are in the same currency. | |
Custom |
varchar2 |
Campo personalizzato | writable | ||
Description |
varchar2 |
Description | writable | Description of the invoice line. | |
Discount |
double |
Discount | writable | The discount given on the default price.A value of 0.1 translates to 10% discount. | |
Division |
int32 |
ID dell'azienda | Unique number of the Exact Online division. | ||
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 | writable | Expense related to the Work Breakdown Structure of the selected project.Only available with a professional service license. | |
Expense |
varchar2 |
Descrizione delle spese | writable | Description of expense.Only available with a professional service license. | |
ID |
guid |
ID | filters on the platform, writable | A guid that uniqely identifies the invoice line. | |
Invoice |
guid |
ID fattura | filters on the platform, writable | The unique identifier of the purchase invoice this line belongs to. | |
Invoice |
int16 |
Tipo di fattura | writable | ||
Item |
guid |
Item | filters on the platform, writable | Guid that identifies the purchase item.In a POST request either the Item or the PurchaseOrderLine has to be supplied. | |
Item |
varchar2 |
Unità dell'articolo | writable | The default unit of the purchased item. | |
Line |
int32 |
Numero della linea | filters on the platform, writable | The sequence number of the line. | |
Modified |
datetime |
Modified | filters on the platform, writable | Last modified date. | |
Modified |
datetime |
Modificato (UTC) | writable | Last modified date in UTC. | |
Net |
double |
Prezzo netto | writable | The net price that has to be paid per unit.NetPrice = UnitPrice * (1.0 - Discount).Depending on the type of the VAT code the net price is including or excluding VAT. | |
Notes |
varchar2 |
Notes | writable | The user can enter notes related to the invoice line here. | |
Project |
guid |
Project | writable | The project linked to the purchase invoice line.This field is only applicable for Manufacturing and Professional Services. | |
Purchase |
guid |
Linea dell'ordine di acquisto | writable | Guid that identifies the purchase order line that is being invoiced.When doing a POST either the Item or the PurchaseOrderLine has to be supplied.The values of the purchase order line such as Quantity, Item and Amount will be copied to the purchase invoice line. | |
Quantity |
double |
Quantity | writable | The number of purchased items in purchase units.The purchase unit is defined on the item card and it can also be found using the logistics/SupplierItem api endpoint.For divisible items the quantity can be a fractional number, otherwise it is an integer. | |
Quantity |
double |
Quantità nelle unità predefinite | filters on the platform, writable | The number of purchased items in default units.An item has both a default unit and a purchase unit, for example piece and box with a box containing 12 pieces.The multiplication factor (12 in this example) between the default unit and purchase unit is maintained on the item card.When you GET a purchase invoice line for 1 box of items the field Quantity = 1 and QuantityInDefaultUnits = 12. | |
Rebill |
char |
Rebill | writable | Indicates whether the purchase invoice line needs to be rebilled.Only available with a professional service license. | |
Unit |
varchar2 |
Unit | writable | The code of the unit in which the item is purchased.For example piece, box or kg.The value is taken from the purchase unit in the item card. | |
Unit |
double |
Prezzo unitario | writable | The default purchase price per unit.Depending on the type of the VAT code the unit price is including or excluding VAT. | |
VAT |
double |
Importo IVA | writable | The VAT amount of the invoice line. | |
VAT |
varchar2 |
Codice IVA | filters on the platform, writable | The VAT code used for the invoice line. | |
VAT |
double |
Percentuale IVA | writable | The VAT percentage. |
Chiavi
| Key | Column | Si riferisce a | Kind | Description |
|---|---|---|---|---|
Purchase |
Cost |
Costcenters.Code |
Key | |
Purchase |
Cost |
Costunits.Code |
Key | |
Purchase |
Currency |
Currencies.Code |
Key | |
Purchase |
Invoice |
PurchaseInvoices.ID |
Key | |
Purchase |
Item |
Units.Code |
Key | |
Purchase |
Item |
Items.ID |
Key | |
Purchase |
Project |
Projects.ID |
Key | |
Purchase |
Purchase |
PurchaseOrderLines.ID |
Key | |
Purchase |
Unit |
Units.Code |
Key | |
Purchase |
VAT |
VATCodes.Code |
Key |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: