Assets: Exact Online Assets
insert update delete per partition REST
- Catálogo:
ExactOnlineREST - Esquema:
Assets - Llaves Primarias:
ID - Label: Assets
Los datos de esta tabla están divididos por el valor de la columna Division.
Permite recuperar y modificar datos utilizando insert, update y delete.
Fuente de la API
- Punto final:
/api/v1/{division}/assets/Assets - Metadatos:
/api/v1/{division}/assets/$metadata
Características de rendimiento
| Characteristic | Value |
|---|---|
| Latencia media de acceso (ms) | 5 |
| Número de filas escaneadas por minuto | 7,200 |
| Número de filas de queries puntuales por minuto | 300 |
| Escribir filas por minuto | 300 |
El resultado se puede almacenar en la Caché del cliente.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla Assets. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
Already |
int16 |
Ya depreciado | filters on the platform, writable | Indicates if an asset was already depreciated before registering it in Exact Online. | |
Asset |
guid |
Activo procedente de | 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 |
Activo: Descripción | filters on the platform, writable | Description of AssetFrom. | |
Asset |
guid |
Grupo de Activos | filters on the platform, writable | Asset group identifies GLAccounts to be used for Asset transactions. | |
Asset |
varchar2 |
Código del Grupo de Activos | filters on the platform, writable | Code of the asset group. | |
Asset |
varchar2 |
Descripción del Grupo de Activos | filters on the platform, writable | Description of the asset group. | |
Catalogue |
double |
Valor de catálogo | 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 de Costo | filters on the platform, writable | Assets can be linked to a cost center. | |
Costcenter |
varchar2 |
Descripción del Centro de Costo | filters on the platform, writable | Description of Costcenter. | |
Costunit |
varchar2 |
Unidad de Costo | filters on the platform, writable | Assets can be linked to a cost unit. | |
Costunit |
varchar2 |
Descripción de la Unidad de Costo | filters on the platform, writable | Description of Costunit. | |
Created |
datetime |
Created | filters on the platform, writable | Creation date. | |
Created |
datetime |
Creado | writable | Creation date in UTC. | |
Creator |
guid |
Creator | filters on the platform, writable | User ID of creator. | |
Creator |
varchar2 |
Nombre Completo del Creador | filters on the platform, writable | Name of creator. | |
Custom |
varchar2 |
Campo personalizado | writable | ||
Deduction |
double |
Porcentaje de deducción | filters on the platform, writable | Used for Belgium legislation.Used to produce the official 'Investment deduction' report. | |
Depreciated |
double |
Cantidad Depreciada | 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 |
Períodos Depreciados | 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 |
Fecha de inicio de la amortización | 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 |
Número de la Cámara de Comercio de la División | writable | Chamber of commerce number of the Exact Online division. | |
Division |
varchar2 |
Número IBAN de la división | writable | IBAN number of the Exact Online division. | |
Division |
varchar2 |
División: Nombre de la empresa | writable | Company name of the Exact Online division. | |
Division |
varchar2 |
Número de la división RSIN | writable | RSIN number of the Exact Online division. | |
Division |
varchar2 |
Número de IVA de la división | writable | VAT number of the Exact Online division. | |
Division |
varchar2 |
Número de identificación fiscal de la división en materia de impuestos sobre los salarios | writable | Wage tax number of the Exact Online division. | |
Division |
varchar2 |
Etiqueta de división | writable | Label of the Exact Online division. | |
Division |
varchar2 |
Nombre de la Adminisración | writable | Name of the Exact Online division. | |
Division |
varchar2 |
Nombre del titular de la suscripción | writable | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
varchar2 |
Número de titular de la suscripción | writable | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | |
Division |
int64 |
Nombre abreviado de la división | writable | Short name of the Exact Online division. | |
End |
datetime |
Fecha Final | filters on the platform, writable | Asset EndDate is filled when asset is Sold or Inactive. | |
Engine |
int16 |
Emisiones del motor | filters on the platform, writable | Engine emission of the asset, needed to calculate the co² report. | |
Engine |
int16 |
Tipo de motor | filters on the platform, writable | Engine type of the asset, Needed to generate a co² report. | |
GL |
guid |
Línea de transacciones GL | filters on the platform, writable | Links to the gltransactions.id.GL transaction line based on which the asset is created. | |
GL |
varchar2 |
Descripción de la línea de transacción GL | filters on the platform, writable | Description of GLTransactionLine. | |
ID |
guid |
ID | filters on the platform, writable | Primary key. | |
Investment |
guid |
Cuenta de inversión | filters on the platform, writable | Supplier of the asset. | |
Investment |
varchar2 |
Código de la cuenta de inversión | filters on the platform, writable | Code of InvestmentAccount. | |
Investment |
varchar2 |
Nombre de la cuenta de inversión | filters on the platform, writable | Name of InvestmentAccount. | |
Investment |
double |
Importe de la inversión, división, Moneda | filters on the platform, writable | Investment amount in the default currency of the company. | |
Investment |
double |
Importe de la inversión en moneda extranjera | 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 |
Importe de la inversión Código de moneda | filters on the platform, writable | Indicates the currency of the investment amount. | |
Investment |
varchar2 |
Importe de la inversión Moneda Descripción | filters on the platform, writable | Description of InvestmentCurrency. | |
Investment |
datetime |
Fecha de Inversión | filters on the platform, writable | Refers to the original date when the asset was bought. | |
Investment |
int16 |
Deducción por inversión | 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 |
Modificado (UTC) | writable | Last modified date in UTC. | |
Modifier |
guid |
Modifier | filters on the platform, writable | User ID of modifier. | |
Modifier |
varchar2 |
Nombre completo modificado | 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 |
Código primario | filters on the platform, writable | Code of Parent. | |
Parent |
varchar2 |
Descripción primaria | filters on the platform, writable | Description of Parent. | |
Picture |
blob |
Picture | writable | Image for an asset. | |
Picture |
varchar2 |
Nombre del archivo de imagen | filters on the platform, writable | Filename of the image. | |
Primary |
guid |
Método Primario | filters on the platform, writable | First method of depreciation.Currently, it is the only one used. | |
Primary |
varchar2 |
Código de Método Primario | filters on the platform, writable | Code of PrimaryMethod. | |
Primary |
varchar2 |
Descripción de Método Primario | filters on the platform, writable | Description of PrimaryMethod. | |
Residual |
double |
Valor Residual | filters on the platform, writable | Indicates the residual value of the asset at the end of the depreciation. | |
Start |
datetime |
Fecha Inicial | 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 de registro de la transacción | filters on the platform, writable | Reference to the transaction lines that make up the financial entry. | |
Transaction |
int32 |
Número de registro de la transacción | filters on the platform, writable | Entry number of transaction. | |
Type |
varchar2 |
Type | filters on the platform, writable |
Teclas
| Key | Column | Se refiere 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 |
Referenciado por
- 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)
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: