# Assets: Exact Online Assets - Catalog: `ExactOnlineREST` - Schema: `Assets` - Primary Keys: `ID` - Label: Assets The data in this table is partitioned per value of the `Division` column. Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Assets` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AlreadyDepreciated` | `int16` | Already Depreciated | ☑ | Indicates if an asset was already depreciated before registering it in Exact Online. | | `AssetFrom` | `guid` | Asset From | ☐ | 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) | Asset From Description | ☐ | Description of AssetFrom. | | `AssetGroup` | `guid` | Asset Group | ☐ | Asset group identifies GLAccounts to be used for Asset transactions. | | `AssetGroupCode` | `varchar2` | Asset Group Code | ☐ | Code of the asset group. | | `AssetGroupDescription` | `varchar2` | Asset Group Description | ☐ | Description of the asset group. | | `CatalogueValue` | `double` | Catalogue Value | ☐ | The catalogue value of the asset. | | `Code` | `varchar2`(30) | Code | ☑ | Code of the asset. | | `Costcenter` | `varchar2`(8) | Cost Centre | ☐ | Assets can be linked to a cost center. | | `CostcenterDescription` | `varchar2`(60) | Cost Centre Description | ☐ | Description of Costcenter. | | `Costunit` | `varchar2`(8) | Cost Unit | ☐ | Assets can be linked to a cost unit. | | `CostunitDescription` | `varchar2`(60) | Cost Unit Description | ☐ | Description of Costunit. | | `Created` | `datetime` | Created | ☐ | Creation date. | | `CreatedUtc` | `datetime` | Created (UTC) | ☐ | Creation date in UTC. | | `Creator` | `guid` | Creator | ☐ | User ID of creator. | | `CreatorFullName` | `varchar2`(240) | Creator Full Name | ☐ | Name of creator. | | `CustomField` | `varchar2` | Custom Field | ☐ | | | `DeductionPercentage` | `double` | Deduction Percentage | ☐ | Used for Belgium legislation. Used to produce the official 'Investment deduction' report. | | `DepreciatedAmount` | `double` | Depreciated Amount | ☐ | Amount that is already depreciated when adding an existing asset. Can only be filled when 'Alreadydepreciated' is on. | | `DepreciatedPeriods` | `int32` | Depreciated Periods | ☐ | Number of periods that already have been depreciated for the asset. Can only be filled when 'Alreadydepreciated' is on. | | `DepreciatedStartDate` | `datetime` | Depreciated Start Date | ☐ | StartDate of depreciating. Can only be filled when 'Alreadydepreciated' is on. | | `Description` | `varchar2`(60) | Description | ☐ | This is the description of the Asset. | | `Division` | `int32` | Division | ☐ | Division code. | | `DivisionCompanyCoCNumber` | `varchar2`(60) | Division Chamber of Commerce Number | ☐ | Chamber of commerce number of the Exact Online division. | | `DivisionCompanyIBANNumber` | `varchar2`(50) | Division IBAN Number | ☐ | IBAN number of the Exact Online division. | | `DivisionCompanyName` | `varchar2`(50) | Division Company Name | ☑ | Company name of the Exact Online division. | | `DivisionCompanyRSINNumber` | `varchar2`(9) | Division RSIN Number | ☐ | RSIN number of the Exact Online division. | | `DivisionCompanyVATNumber` | `varchar2`(35) | Division VAT Number | ☐ | VAT number of the Exact Online division. | | `DivisionCompanyWageTaxNumber` | `varchar2`(60) | Division Wage Tax Number | ☐ | Wage tax number of the Exact Online division. | | `DivisionLabel` | `varchar2`(128) | Division Label | ☑ | Label of the Exact Online division. | | `DivisionName` | `varchar2`(50) | Administration Name | ☑ | Name of the Exact Online division. | | `DivisionOwnerCompanyName` | `varchar2`(50) | Subscription Holder Name | ☑ | Name of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | | `DivisionOwnerCompanyNumber` | `varchar2`(18) | Subscription Holder Number | ☑ | Number of the customer account in division 1 owning the Exact Online subscription to which this division belongs. | | `DivisionShortName` | `int64` | Division Short Name | ☑ | Short name of the Exact Online division. | | `EndDate` | `datetime` | End Date | ☐ | Asset EndDate is filled when asset is Sold or Inactive. | | `EngineEmission` | `int16` | Engine Emission | ☐ | Engine emission of the asset, needed to calculate the co² report. | | `EngineType` | `int16` | Engine Type | ☐ | Engine type of the asset, Needed to generate a co² report. | | `GLTransactionLine` | `guid` | GL Transaction Line | ☐ | Links to the gltransactions.id. GL transaction line based on which the asset is created. | | `GLTransactionLineDescription` | `varchar2`(60) | GL Transaction Line Description | ☐ | Description of GLTransactionLine. | | `ID` | `guid` | ID | ☑ | Primary key. | | `InvestmentAccount` | `guid` | Investment Account | ☐ | Supplier of the asset. | | `InvestmentAccountCode` | `varchar2` | Investment Account Code | ☐ | Code of InvestmentAccount. | | `InvestmentAccountName` | `varchar2`(50) | Investment Account Name | ☐ | Name of InvestmentAccount. | | `InvestmentAmountDC` | `double` | Investment Amount Division Currency | ☐ | Investment amount in the default currency of the company. | | `InvestmentAmountFC` | `double` | Investment Amount Foreign Currency | ☐ | 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) | Investment Amount Currency Code | ☐ | Indicates the currency of the investment amount. | | `InvestmentCurrencyDescription` | `varchar2`(60) | Investment Amount Currency Description | ☐ | Description of InvestmentCurrency. | | `InvestmentDate` | `datetime` | Investment Date | ☐ | Refers to the original date when the asset was bought. | | `InvestmentDeduction` | `int16` | Investment Deduction | ☐ | Belgian functionality, to determine how a local legal report regarding investment deduction must be created. | | `Modified` | `datetime` | Modified | ☐ | Last modified date. | | `ModifiedUtc` | `datetime` | Modified (UTC) | ☐ | Last modified date in UTC. | | `Modifier` | `guid` | Modifier | ☐ | User ID of modifier. | | `ModifierFullName` | `varchar2`(240) | Modified Full Name | ☐ | Name of modifier. | | `Notes` | `varchar2` | Notes | ☐ | Extra remarks for the asset. | | `Parent` | `guid` | Parent | ☐ | Parent asset. | | `ParentCode` | `varchar2`(30) | Parent Code | ☐ | Code of Parent. | | `ParentDescription` | `varchar2` | Parent Description | ☐ | Description of Parent. | | `Picture` | `blob` | Picture | ☐ | Image for an asset. | | `PictureFileName` | `varchar2` | Picture File Name | ☐ | Filename of the image. | | `PrimaryMethod` | `guid` | Primary Method | ☐ | First method of depreciation. Currently, it is the only one used. | | `PrimaryMethodCode` | `varchar2` | Primary Method Code | ☐ | Code of PrimaryMethod. | | `PrimaryMethodDescription` | `varchar2` | Primary Method Description | ☐ | Description of PrimaryMethod. | | `ResidualValue` | `double` | Residual Value | ☐ | Indicates the residual value of the asset at the end of the depreciation. | | `StartDate` | `datetime` | Start Date | ☐ | Asset Depreciation StartDate. | | `Status` | `int16` | Status | ☐ | Identifies the status of the Asset. (see AssetStatus table to see the possibilities). | | `TransactionEntryID` | `guid` | Transaction Entry ID | ☐ | Reference to the transaction lines that make up the financial entry. | | `TransactionEntryNo` | `int32` | Transaction Entry Number | ☐ | Entry number of transaction. | | `Type` | `varchar2` | Type | ☐ | |