SalesInvoiceLines: Exact Online Sales Invoice Lines
insert update delete per partition webhook REST
- Catalogo:
ExactOnlineREST - Schema:
SalesInvoice - Chiavi primarie:
ID - Label: Sales 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.
Le modifiche vengono inviate tramite il topic del webhook SalesInvoices su InvoiceID.
Codice sorgente dell'API
- Punto finale:
/api/v1/{division}/salesinvoice/SalesInvoiceLines - Metadati:
/api/v1/{division}/salesinvoice/$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 SalesInvoiceLines. 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 | writable | Amount in the default currency of the company.For almost all lines this can be calculated like: AmountDC = AmountFC * RateFC. | |
Amount |
double |
Importo in valuta estera | writable | For normal lines it's the amount excluding VAT. | |
Cost |
varchar2 |
Centro di costo | filters on the platform, writable | Reference to Cost center. | |
Cost |
varchar2 |
Descrizione del centro di costo | writable | Description of CostCenter. | |
Cost |
varchar2 |
Unità del costo | filters on the platform, writable | Reference to Cost unit. | |
Cost |
varchar2 |
Unità del costo Descrizione | writable | Description of CostUnit. | |
Custom |
varchar2 |
Campo personalizzato | writable | ||
Customer |
varchar2 |
Codice articolo cliente | Code the customer uses for this item. | ||
Delivery |
datetime |
Data di consegna | writable | Delivery date of an item in a sales invoice.This is used for VAT on prepayments, only if sales order is not used in the license. | |
Description |
varchar2 |
Description | filters on the platform, writable | Description.Can be different for header and lines. | |
Discount |
double |
Discount | writable | Discount given on the default price.Discount = (DefaultPrice of Item - PriceItem in line) / DefaultPrice of 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. | |
Employee |
guid |
Employee | filters on the platform, writable | Link to Employee originating from time and cost transactions. | |
Employee |
varchar2 |
Nome completo del dipendente | writable | Name of employee. | |
End |
datetime |
Ora di fine | writable | EndTime is used to store the last date of a period.EndTime is used in combination with StartTime. | |
Extra |
double |
Importo supplementare in Valuta estera | writable | Extra duty amount in the currency of the transaction.Both extra duty amount and VAT amount need to be specified in order to differ this property from automatically calculated. | |
Extra |
double |
Maggiorazione (%) | writable | Extra duty percentage. | |
GL |
guid |
Conto di contabilità generale | filters on the platform, writable | The GL Account of the sales invoice line.This field is mandatory.This field is generated based on the revenue account of the item (or the related item group).G/L Account is also used to determine whether the costcenter / costunit is mandatory. | |
GL |
varchar2 |
Descrizione del conto GL | writable | Description of the G/L account. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Invoice |
guid |
ID fattura | filters on the platform, writable | The InvoiceID identifies the sales invoice.All the lines of a sales invoice have the same InvoiceID. | |
Item |
guid |
Item | filters on the platform, writable | Reference to the item that is sold in this sales invoice line. | |
Item |
varchar2 |
Codice articolo | writable | Item code. | |
Item |
varchar2 |
Descrizione dell'articolo | writable | Description of Item. | |
Line |
int32 |
Numero della linea | filters on the platform, writable | Indicates the sequence of the lines within one invoice. | |
Net |
double |
Importo netto Divisione Valuta | writable | Net amount in division currency of sales invoice line. | |
Net |
double |
Importo netto in valuta estera | writable | Net amount in foreign currency of sales invoice line. | |
Net |
double |
Prezzo netto | writable | Net price of the sales invoice line. | |
Notes |
varchar2 |
Notes | writable | Extra notes. | |
Pricelist |
guid |
Listino prezzi | filters on the platform, writable | Price list. | |
Pricelist |
varchar2 |
Descrizione del listino prezzi | writable | Description of Pricelist. | |
Project |
guid |
Project | filters on the platform, writable | The project to which the sales transaction line is linked.The project can be different per line.Sometimes also the project in the header is filled although this is not really used. | |
Project |
varchar2 |
Descrizione del progetto | writable | Description of Project. | |
Project |
guid |
Struttura di suddivisione del lavoro (WBS) del progetto | writable | WBS linked to the sales invoice. | |
Project |
varchar2 |
Descrizione della struttura di suddivisione del lavoro (WBS) del progetto | writable | Description of WBS. | |
Quantity |
double |
Quantity | writable | The number of items sold in default units.The quantity shown in the entry screen is Quantity * UnitFactor. | |
Sales |
guid |
Ordine di vendita | filters on the platform, writable | Identifies the sales order this invoice line is based on. | |
Sales |
guid |
Linea dell'ordine di vendita | filters on the platform, writable | Identifies the sales order line this sales invoice line is based on. | |
Sales |
int32 |
Numero della riga dell'ordine di vendita | writable | Then line number of the sales order line on which this invoice line is based on. | |
Sales |
int32 |
Numero dell'ordine di vendita | writable | The order number of the sales order on which this invoice line is based on. | |
Start |
datetime |
Ora di inizio | writable | StartTime is used to store the first date of a period.StartTime is used in combination with EndTime. | |
Subscription |
guid |
Subscription | filters on the platform, writable | When generating invoices from subscriptions, this field records the link between invoice lines and subscription lines. | |
Subscription |
varchar2 |
Descrizione dell'abbonamento | writable | Description of subscription line. | |
Tax |
guid |
Calendario fiscale | filters on the platform, writable | Obsolete. | |
Tax |
varchar2 |
Codice della tabella fiscale | writable | Obsolete. | |
Tax |
varchar2 |
Descrizione delle fasce fiscali | writable | Obsolete. | |
Unit |
varchar2 |
Codice dell'unità | writable | Code of Unit. | |
Unit |
varchar2 |
Descrizione dell'unità | writable | Description of Unit. | |
Unit |
double |
Prezzo unitario | writable | Price per unit. | |
VAT |
double |
Importo IVA Divisione Valuta | writable | VAT amount in the default currency of the company. | |
VAT |
double |
Importo IVA in valuta estera | writable | VAT amount in the currency of the transaction. | |
VAT |
varchar2 |
Codice IVA | filters on the platform, writable | The VAT code that is used when the invoice is registered. | |
VAT |
varchar2 |
Descrizione del codice IVA | writable | Description of VAT code. | |
VAT |
double |
Percentuale IVA | writable | The vat percentage of the VAT code.This is the percentage at the moment the invoice is created.It's also used for the default calculation of VAT amounts and VAT base amounts. |
Chiavi
| Key | Column | Si riferisce a | Kind | Description |
|---|---|---|---|---|
Sales |
Cost |
Costcenters.Code |
Key | |
Sales |
Cost |
Costunits.Code |
Key | |
Sales |
Employee |
Employees.ID |
Key | |
Sales |
GL |
GLAccounts.ID |
Key | |
Sales |
Invoice |
SalesInvoices. |
Key | |
Sales |
Item |
Items.ID |
Key | |
Sales |
Pricelist |
SalesPriceLists.ID |
Key | |
Sales |
Project |
ProjectWBS.ID |
Key | |
Sales |
Project |
Projects.ID |
Key | |
Sales |
Sales |
SalesOrderLines.ID |
Key | |
Sales |
Sales |
SalesOrders. |
Key | |
Sales |
Subscription |
Subscriptions. |
Key | |
Sales |
VAT |
VATCodes.Code |
Key |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: