Assets: Exact Online Activa

AlreadyDepreciated

int16

Al Afgeschreven

☑

Indicates if an asset was already depreciated before registering it in Exact Online.

AssetFrom

guid

Activum van

☐

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

string(60)

Activum uit Omschrijving

☐

Description of AssetFrom.

AssetGroup

guid

Activagroep

☐

Asset group identifies GLAccounts to be used for Asset transactions.

AssetGroupCode

string

Activagroep Code

☐

Code of the asset group.

AssetGroupDescription

string

Activagroep Omschrijving

☐

Description of the asset group.

CatalogueValue

double

Cataloguswaarde

☐

The catalogue value of the asset.

Code

string(30)

Code

☑

Code of the asset.

Costcenter

string(8)

Kostenplaats

☐

Assets can be linked to a cost center.

CostcenterDescription

string(60)

Kostenplaats Omschrijving

☐

Description of Costcenter.

Costunit

string(8)

Kostendrager

☐

Assets can be linked to a cost unit.

CostunitDescription

string(60)

Kostendrager Omschrijving

☐

Description of Costunit.

Created

datetime

Gemaakt

☐

Creation date.

CreatedUtc

datetime

Aangemaakt (UTC)

☐

Creation date in UTC.

Creator

guid

Aanmaker

☐

User ID of creator.

CreatorFullName

string(240)

Aanmaker Volledige Naam

☐

Name of creator.

CustomField

string

{res:itgen_eol_customfield}

☐

DeductionPercentage

double

Aftrek Percentage

☐

Used for Belgium legislation. Used to produce the official 'Investment deduction' report.

DepreciatedAmount

double

Afgeschreven Bedrag

☐

Amount that is already depreciated when adding an existing asset. Can only be filled when 'Alreadydepreciated' is on.

DepreciatedPeriods

int32

Afgeschreven Periodes

☐

Number of periods that already have been depreciated for the asset. Can only be filled when 'Alreadydepreciated' is on.

DepreciatedStartDate

datetime

Afgeschreven Startdatum

☐

StartDate of depreciating. Can only be filled when 'Alreadydepreciated' is on.

Description

string(60)

Omschrijving

☐

This is the description of the Asset.

Division

int32

Divisie

☐

Division code.

DivisionCompanyCoCNumber

string(60)

Divisie Kamer van Koophandel Nummer

☐

Chamber of commerce number of the Exact Online division.

DivisionCompanyIBANNumber

string(50)

Divisie IBAN Nummer

☐

IBAN number of the Exact Online division.

DivisionCompanyName

string(50)

Divisie Bedrijfsnaam

☑

Company name of the Exact Online division.

DivisionCompanyRSINNumber

string(9)

Divisie RSIN Nummer

☐

RSIN number of the Exact Online division.

DivisionCompanyVATNumber

string(35)

Divisie BTW Nummer

☐

VAT number of the Exact Online division.

DivisionCompanyWageTaxNumber

string(60)

Divisie Loonbelastingnummer

☐

Wage tax number of the Exact Online division.

DivisionLabel

string(128)

Divisie Label

☑

Label of the Exact Online division.

DivisionName

string(50)

Administratie Naam

☑

Name of the Exact Online division.

DivisionOwnerCompanyName

string(50)

Naam Abonnementhouder

☑

Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs.

DivisionOwnerCompanyNumber

string(18)

Abonnementhoudernummer

☑

Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs.

DivisionShortName

int64

Divisie Korte Naam

☑

Short name of the Exact Online division.

EndDate

datetime

Einddatum

☐

Asset EndDate is filled when asset is Sold or Inactive.

EngineEmission

int16

Motoremissie

☐

Engine emission of the asset, needed to calculate the co² report.

EngineType

int16

Motorsoort

☐

Engine type of the asset, Needed to generate a co² report.

GLTransactionLine

guid

Grootboektransactieregel

☐

Links to the gltransactions.id. GL transaction line based on which the asset is created.

GLTransactionLineDescription

string(60)

Grootboekrekening Mutatieregel Omschrijving

☐

Description of GLTransactionLine.

ID

guid

ID

☑

Primary key.

InvestmentAccount

guid

Beleggingsrekening

☐

Supplier of the asset.

InvestmentAccountCode

string

Investeringen Account Code

☐

Code of InvestmentAccount.

InvestmentAccountName

string(50)

Investeringen Account Naam

☐

Name of InvestmentAccount.

InvestmentAmountDC

double

Investeringen Bedrag Divisie Valuta

☐

Investment amount in the default currency of the company.

InvestmentAmountFC

double

Investeringen Bedrag Vreemde Valuta

☐

Investment value of the asset. Currently the field is filled with the PurchasePriceLocal. Can be status 'Not used' after sources have been cleaned.

InvestmentCurrency

string(30)

Investeringen Bedrag Valuta Code

☐

Indicates the currency of the investment amount.

InvestmentCurrencyDescription

string(60)

Investeringen Bedrag Valuta Omschrijving

☐

Description of InvestmentCurrency.

InvestmentDate

datetime

Investeringsdatum

☐

Refers to the original date when the asset was bought.

InvestmentDeduction

int16

Investeringsaftrek

☐

Belgian functionality, to determine how a local legal report regarding investment deduction must be created.

Modified

datetime

Gewijzigd

☐

Last modified date.

ModifiedUtc

datetime

Gewijzigd (UTC)

☐

Last modified date in UTC.

Modifier

guid

Wijziger

☐

User ID of modifier.

ModifierFullName

string(240)

Gewijzigd Volledige Naam

☐

Name of modifier.

Notes

string

Notities

☐

Extra remarks for the asset.

Parent

guid

Moeder

☐

Parent asset.

ParentCode

string(30)

Oudercode

☐

Code of Parent.

ParentDescription

string

Ouderomschrijving

☐

Description of Parent.

Picture

byte[]

Afbeelding

☐

Image for an asset.

PictureFileName

string

Afbeeldingsbestandsnaam

☐

Filename of the image.

PrimaryMethod

guid

Primaire Methode

☐

First method of depreciation. Currently, it is the only one used.

PrimaryMethodCode

string

Primaire Methode Code

☐

Code of PrimaryMethod.

PrimaryMethodDescription

string

Primaire Methode Omschrijving

☐

Description of PrimaryMethod.

ResidualValue

double

Restwaarde

☐

Indicates the residual value of the asset at the end of the depreciation.

StartDate

datetime

Startdatum

☐

Asset Depreciation StartDate.

Status

int16

Status

☐

Identifies the status of the Asset. (see AssetStatus table to see the possibilities).

TransactionEntryID

guid

Mutatie Invoer-ID

☐

Reference to the transaction lines that make up the financial entry.

TransactionEntryNo

int32

Mutatie Invoernummer

☐

Entry number of transaction.

Type

string

Soort

☐