invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

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
AlreadyDepreciated int16 Ya depreciado filters on the platform, writable Indicates if an asset was already depreciated before registering it in Exact Online.
AssetFrom 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.
AssetFromDescription varchar2(60) Activo: Descripción filters on the platform, writable Description of AssetFrom.
AssetGroup guid Grupo de Activos filters on the platform, writable Asset group identifies GLAccounts to be used for Asset transactions.
AssetGroupCode varchar2 Código del Grupo de Activos filters on the platform, writable Code of the asset group.
AssetGroupDescription varchar2 Descripción del Grupo de Activos filters on the platform, writable Description of the asset group.
CatalogueValue double Valor de catálogo filters on the platform, writable The catalogue value of the asset.
Code varchar2(30) Code filters on the platform, writable Code of the asset.
Costcenter varchar2(8) Centro de Costo filters on the platform, writable Assets can be linked to a cost center.
CostcenterDescription varchar2(60) Descripción del Centro de Costo filters on the platform, writable Description of Costcenter.
Costunit varchar2(8) Unidad de Costo filters on the platform, writable Assets can be linked to a cost unit.
CostunitDescription varchar2(60) 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.
CreatedUtc datetime Creado writable Creation date in UTC.
Creator guid Creator filters on the platform, writable User ID of creator.
CreatorFullName varchar2(240) Nombre Completo del Creador filters on the platform, writable Name of creator.
CustomField varchar2 Campo personalizado writable
DeductionPercentage double Porcentaje de deducción filters on the platform, writable Used for Belgium legislation.Used to produce the official 'Investment deduction' report.
DepreciatedAmount 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.
DepreciatedPeriods 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.
DepreciatedStartDate 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(60) Description filters on the platform, writable This is the description of the Asset.
Division int32 Division Division code.
DivisionCompanyCoCNumber varchar2(60) Número de la Cámara de Comercio de la División writable Chamber of commerce number of the Exact Online division.
DivisionCompanyIBANNumber varchar2(50) Número IBAN de la división writable IBAN number of the Exact Online division.
DivisionCompanyName varchar2(50) División: Nombre de la empresa writable Company name of the Exact Online division.
DivisionCompanyRSINNumber varchar2(9) Número de la división RSIN writable RSIN number of the Exact Online division.
DivisionCompanyVATNumber varchar2(35) Número de IVA de la división writable VAT number of the Exact Online division.
DivisionCompanyWageTaxNumber varchar2(60) 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.
DivisionLabel varchar2(128) Etiqueta de división writable Label of the Exact Online division.
DivisionName varchar2(50) Nombre de la Adminisración writable Name of the Exact Online division.
DivisionOwnerCompanyName varchar2(50) 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.
DivisionOwnerCompanyNumber varchar2(18) 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.
DivisionShortName int64 Nombre abreviado de la división writable Short name of the Exact Online division.
EndDate datetime Fecha Final filters on the platform, writable Asset EndDate is filled when asset is Sold or Inactive.
EngineEmission int16 Emisiones del motor filters on the platform, writable Engine emission of the asset, needed to calculate the co² report.
EngineType int16 Tipo de motor filters on the platform, writable Engine type of the asset, Needed to generate a co² report.
GLTransactionLine 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.
GLTransactionLineDescription varchar2(60) 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.
InvestmentAccount guid Cuenta de inversión filters on the platform, writable Supplier of the asset.
InvestmentAccountCode varchar2 Código de la cuenta de inversión filters on the platform, writable Code of InvestmentAccount.
InvestmentAccountName varchar2(50) Nombre de la cuenta de inversión filters on the platform, writable Name of InvestmentAccount.
InvestmentAmountDC double Importe de la inversión, división, Moneda filters on the platform, writable Investment amount in the default currency of the company.
InvestmentAmountFC 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.
InvestmentCurrency varchar2(30) Importe de la inversión Código de moneda filters on the platform, writable Indicates the currency of the investment amount.
InvestmentCurrencyDescription varchar2(60) Importe de la inversión Moneda Descripción filters on the platform, writable Description of InvestmentCurrency.
InvestmentDate datetime Fecha de Inversión filters on the platform, writable Refers to the original date when the asset was bought.
InvestmentDeduction 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.
ModifiedUtc datetime Modificado (UTC) writable Last modified date in UTC.
Modifier guid Modifier filters on the platform, writable User ID of modifier.
ModifierFullName varchar2(240) 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.
ParentCode varchar2(30) Código primario filters on the platform, writable Code of Parent.
ParentDescription varchar2 Descripción primaria filters on the platform, writable Description of Parent.
Picture blob Picture writable Image for an asset.
PictureFileName varchar2 Nombre del archivo de imagen filters on the platform, writable Filename of the image.
PrimaryMethod guid Método Primario filters on the platform, writable First method of depreciation.Currently, it is the only one used.
PrimaryMethodCode varchar2 Código de Método Primario filters on the platform, writable Code of PrimaryMethod.
PrimaryMethodDescription varchar2 Descripción de Método Primario filters on the platform, writable Description of PrimaryMethod.
ResidualValue double Valor Residual filters on the platform, writable Indicates the residual value of the asset at the end of the depreciation.
StartDate 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).
TransactionEntryID guid ID de registro de la transacción filters on the platform, writable Reference to the transaction lines that make up the financial entry.
TransactionEntryNo 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_AssetFrom_Assets_fk AssetFrom Assets.ID Key
Assets_AssetGroup_AssetGroups_fk AssetGroup AssetGroups.ID Key
Assets_Costcenter_Costcenters_fk Costcenter Costcenters.Code Key
Assets_Costunit_Costunits_fk Costunit Costunits.Code Key
Assets_Creator_Users_fk Creator Users.UserID Key
Assets_InvestmentAccount_Accounts_fk InvestmentAccount Accounts.ID Key
Assets_Modifier_Users_fk Modifier Users.UserID Key
Assets_Parent_Assets_fk Parent Assets.ID Key
Assets_PrimaryMethod_DepreciationMethods_fk PrimaryMethod DepreciationMethods.ID Key

Referenciado por

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: