SalesEntryLines: Exact Online Sales Entry Lines
insert update delete per partition webhook REST
- Catalogo:
ExactOnlineREST - Schema:
SalesEntry - Chiavi primarie:
ID - Label: Sales Entry 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 SalesEntries su EntryID.
Codice sorgente dell'API
- Punto finale:
/api/v1/{division}/salesentry/SalesEntryLines - Metadati:
/api/v1/{division}/salesentry/$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 SalesEntryLines. 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.For almost all lines this can be calculated like: AmountDC = AmountFC * RateFC. | |
Amount |
double |
Importo in valuta estera | filters on the platform, writable | For normal lines it's the amount excluding VAT. | |
Asset |
guid |
Asset | filters on the platform, writable | Reference to Asset. | |
Asset |
varchar2 |
Descrizione della risorsa | filters on the platform, writable | Description of Asset. | |
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. | |
Custom |
varchar2 |
Campo personalizzato | writable | ||
Description |
varchar2 |
Description | filters on the platform, writable | Description.Can be different for header and lines. | |
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. | |
Entry |
guid |
ID di ingresso | filters on the platform, writable | The unique ID of the entry.Via this ID all transaction lines of a single entry can be retrieved. | |
Extra |
double |
Importo supplementare in Valuta estera | filters on the platform, 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 (%) | filters on the platform, writable | Extra duty percentage for the item. | |
From |
datetime |
From | writable | From date for deferred revenue. | |
GL |
guid |
Conto di contabilità generale | filters on the platform, writable | The GL Account of the invoice line.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 |
Codice conto GL | filters on the platform, writable | Code of the G/L account. | |
GL |
varchar2 |
Descrizione del conto GL | filters on the platform, writable | Description of the G/L account. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Intra |
varchar2 |
Area Intrastat | filters on the platform, writable | IntraStat area. | |
Intra |
varchar2 |
Paese Intrastat | filters on the platform, writable | IntraStatCountry. | |
Intra |
varchar2 |
Termine di consegna Intrastat | filters on the platform, writable | IntraStat delivery term. | |
Intra |
varchar2 |
Transazione Intrastat A | filters on the platform, writable | IntraStat transaction a. | |
Intra |
varchar2 |
Operazione Intrastat B | filtri sulla piattaforma | ||
Intra |
varchar2 |
Metodo di trasporto Intrastat | filters on the platform, writable | IntraStat transport method. | |
Line |
int32 |
Numero della linea | filters on the platform, writable | Indicates the sequence of the lines within one entry. | |
Net |
double |
Importo netto Divisione Valuta | writable | Net amount in division currency of sales entry line. | |
Net |
double |
Importo netto in valuta estera | writable | Net amount in foreign currency of sales entry line. | |
Notes |
varchar2 |
Notes | filters on the platform, writable | Extra notes. | |
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 | filters on the platform, writable | Description of Project. | |
Project |
guid |
Struttura di suddivisione del lavoro (WBS) del progetto | writable | Project WBS ID. | |
Project |
varchar2 |
Descrizione della struttura di suddivisione del lavoro (WBS) del progetto | writable | Project WBS description. | |
Quantity |
double |
Quantity | filters on the platform, writable | The number of items sold in default units.The quantity shown in the entry screen is Quantity * UnitFactor. | |
Serial |
varchar2 |
Numero di serie | filters on the platform, writable | Serial number. | |
Statistical |
double |
Peso netto statistico | filters on the platform, writable | Statistical NetWeight. | |
Statistical |
varchar2 |
Dato statistico | filters on the platform, writable | Statistical Number (also known as 'Goederencode'). | |
Statistical |
double |
Grandezza statistica | filters on the platform, writable | Statistical Quantity. | |
Statistical |
double |
Valore statistico | filters on the platform, writable | Statistical Value. | |
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 | filters on the platform, writable | Description of Subscription. | |
Tax |
guid |
Calendario fiscale | filters on the platform, writable | Obsolete. | |
To |
datetime |
To | filters on the platform, writable | To date for deferred revenue. | |
Tracking |
guid |
Numero di tracciamento | filters on the platform, writable | Reference to TrackingNumber. | |
Tracking |
varchar2 |
Descrizione del numero di tracciamento | filters on the platform, writable | Description of TrackingNumber. | |
Type |
int32 |
Type | filters on the platform, writable | Type: 20 = Sales entry, 21 = Sales credit note. | |
VAT |
double |
Importo IVA Divisione Valuta | writable | VAT amount in the default currency of the company. | |
VAT |
double |
Importo IVA in valuta estera | filters on the platform, writable | VAT amount in the currency of the transaction.Use this property to specify a VAT amount that differs from the VAT amount that is automatically calculated.However if the transaction uses extra duty, extra duty amount also needs to be specified. | |
VAT |
double |
Imposta IVA, importo base, divisione, Valuta | filters on the platform, writable | The VAT base amount in the default currency of the company.This is calculated based on the VATBaseAmountFC. | |
VAT |
double |
Importo base IVA in Valuta estera | filters on the platform, writable | The VAT base amount in invoice currency.This is calculated with the use of VAT codes.It's an internal value. | |
VAT |
varchar2 |
Codice IVA | filters on the platform, writable | The VAT code used when the invoice was registered. | |
VAT |
varchar2 |
Descrizione del codice IVA | filters on the platform, writable | Description of 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 |
|---|---|---|---|---|
Sales |
Asset |
Assets.ID |
Key | |
Sales |
Cost |
Costcenters.Code |
Key | |
Sales |
Cost |
Costunits.Code |
Key | |
Sales |
GL |
GLAccounts.ID |
Key | |
Sales |
Project |
ProjectWBS.ID |
Key | |
Sales |
Project |
Projects.ID |
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: