Assets: Exact Online Assets
insert update delete per partition REST
- Catalogo:
ExactOnlineREST - Schema:
Assets - Chiavi primarie:
ID - Label: Assets
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}/assets/Assets - Metadati:
/api/v1/{division}/assets/$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 Assets. 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 |
|---|---|---|---|---|---|
Already |
int16 |
Già ammortizzato | filters on the platform, writable | Indicates if an asset was already depreciated before registering it in Exact Online. | |
Asset |
guid |
Origine del bene | filters on the platform, writable | In case of a transfer or a split, the original asset ID is saved in this field.This is done to provide tracability of the Asset. | |
Asset |
varchar2 |
Descrizione della risorsa | filters on the platform, writable | Description of AssetFrom. | |
Asset |
guid |
Gruppo di risorse | filters on the platform, writable | Asset group identifies GLAccounts to be used for Asset transactions. | |
Asset |
varchar2 |
Codice gruppo di attività | filters on the platform, writable | Code of the asset group. | |
Asset |
varchar2 |
Descrizione del gruppo di risorse | filters on the platform, writable | Description of the asset group. | |
Catalogue |
double |
Valore da catalogo | filters on the platform, writable | The catalogue value of the asset. | |
Code |
varchar2 |
Code | filters on the platform, writable | Code of the asset. | |
Costcenter |
varchar2 |
Centro di costo | filters on the platform, writable | Assets can be linked to a cost center. | |
Costcenter |
varchar2 |
Descrizione del centro di costo | filters on the platform, writable | Description of Costcenter. | |
Costunit |
varchar2 |
Unità del costo | filters on the platform, writable | Assets can be linked to a cost unit. | |
Costunit |
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 | ||
Deduction |
double |
Percentuale di detrazione | filters on the platform, writable | Used for Belgium legislation.Used to produce the official 'Investment deduction' report. | |
Depreciated |
double |
Importo ammortizzato | filters on the platform, writable | Amount that is already depreciated when adding an existing asset.Can only be filled when 'Alreadydepreciated' is on. | |
Depreciated |
int32 |
Periodi ammortizzati | filters on the platform, writable | Number of periods that already have been depreciated for the asset.Can only be filled when 'Alreadydepreciated' is on. | |
Depreciated |
datetime |
Data di inizio ammortizzata | filters on the platform, writable | StartDate of depreciating.Can only be filled when 'Alreadydepreciated' is on. | |
Description |
varchar2 |
Description | filters on the platform, writable | This is the description of the Asset. | |
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. | |
End |
datetime |
Data di fine | filters on the platform, writable | Asset EndDate is filled when asset is Sold or Inactive. | |
Engine |
int16 |
Emissioni del motore | filters on the platform, writable | Engine emission of the asset, needed to calculate the co² report. | |
Engine |
int16 |
Tipo di motore | filters on the platform, writable | Engine type of the asset, Needed to generate a co² report. | |
GL |
guid |
Linea transazioni GL | filters on the platform, writable | Links to the gltransactions.id.GL transaction line based on which the asset is created. | |
GL |
varchar2 |
Descrizione della linea di transazione GL | filters on the platform, writable | Description of GLTransactionLine. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Investment |
guid |
Conto di investimento | filters on the platform, writable | Supplier of the asset. | |
Investment |
varchar2 |
Codice conto di investimento | filters on the platform, writable | Code of InvestmentAccount. | |
Investment |
varchar2 |
Nome del conto di investimento | filters on the platform, writable | Name of InvestmentAccount. | |
Investment |
double |
Importo dell'investimento Divisione Valuta | filters on the platform, writable | Investment amount in the default currency of the company. | |
Investment |
double |
Importo dell'investimento Valuta estera | filters on the platform, writable | Investment value of the asset.Currently the field is filled with the PurchasePriceLocal.Can be status 'Not used' after sources have been cleaned. | |
Investment |
varchar2 |
Importo dell'investimento Codice Valuta | filters on the platform, writable | Indicates the currency of the investment amount. | |
Investment |
varchar2 |
Importo dell'investimento Valuta Descrizione | filters on the platform, writable | Description of InvestmentCurrency. | |
Investment |
datetime |
Data dell'investimento | filters on the platform, writable | Refers to the original date when the asset was bought. | |
Investment |
int16 |
Detrazione per investimenti | filters on the platform, writable | Belgian functionality, to determine how a local legal report regarding investment deduction must be created. | |
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. | |
Notes |
varchar2 |
Notes | filters on the platform, writable | Extra remarks for the asset. | |
Parent |
guid |
Parent | filters on the platform, writable | Parent asset. | |
Parent |
varchar2 |
Codice genitore | filters on the platform, writable | Code of Parent. | |
Parent |
varchar2 |
Descrizione del genitore | filters on the platform, writable | Description of Parent. | |
Picture |
blob |
Picture | writable | Image for an asset. | |
Picture |
varchar2 |
Nome del file immagine | filters on the platform, writable | Filename of the image. | |
Primary |
guid |
Metodo primario | filters on the platform, writable | First method of depreciation.Currently, it is the only one used. | |
Primary |
varchar2 |
Codice del metodo primario | filters on the platform, writable | Code of PrimaryMethod. | |
Primary |
varchar2 |
Descrizione del metodo principale | filters on the platform, writable | Description of PrimaryMethod. | |
Residual |
double |
Valore residuo | filters on the platform, writable | Indicates the residual value of the asset at the end of the depreciation. | |
Start |
datetime |
Data di inizio | filters on the platform, writable | Asset Depreciation StartDate. | |
Status |
int16 |
Status | filters on the platform, writable | Identifies the status of the Asset.(see AssetStatus table to see the possibilities). | |
Transaction |
guid |
ID registrazione transazione | filters on the platform, writable | Reference to the transaction lines that make up the financial entry. | |
Transaction |
int32 |
Numero di registrazione della transazione | filters on the platform, writable | Entry number of transaction. | |
Type |
varchar2 |
Type | filters on the platform, writable |
Chiavi
| Key | Column | Si riferisce a | Kind | Description |
|---|---|---|---|---|
Assets_ |
Asset |
Assets.ID |
Key | |
Assets_ |
Asset |
AssetGroups.ID |
Key | |
Assets_ |
Costcenter |
Costcenters.Code |
Key | |
Assets_ |
Costunit |
Costunits.Code |
Key | |
Assets_ |
Creator |
Users. |
Key | |
Assets_ |
Investment |
Accounts.ID |
Key | |
Assets_ |
Modifier |
Users. |
Key | |
Assets_ |
Parent |
Assets.ID |
Key | |
Assets_ |
Primary |
DepreciationMethods.ID |
Key |
Riferito da
- Assets
AssetFrom(Key) - Assets
Parent(Key) - BankEntryLines
Asset(Key) - CashEntryLines
Asset(Key) - TransactionLines
Asset(Key) - TransactionLinesBulk
Asset(Key) - GeneralJournalEntryLines
Asset(Key) - CompanyCars
Asset(Key) - PurchaseEntryLines
Asset(Key) - SalesEntryLines
Asset(Key)
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: