Capital asset class

This table contains one row for each capital asset class, for example Machinery or Vehicles with parameters that are common to the capital assets in the class.

PropertyValueDescription
DatabaseCompanyThis table is in the company databases.
SQL namePropClThe table name in the database.
API identifiercapitalAssetClassThe API identifier used in GraphQL.
Table no.169The table number in the data model.

The following fields exist in this table:

Accum. add. acc. no.

Additional depreciations are debited to the General ledger account entered in this field.

Note:
If the field is left blank, additional depreciations are debited to the account entered in the Cap. asset account field, see the description of the Cap. asset account field.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL nameAddAccWOAcThe database field name.
API identifieraccumulatedAddAccountNoThe API identifier used in GraphQL.
Number16185 
Table 1. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountAccumulatedAdditionAccount
  • Accum. add. acc. no.

Accum. deprec. account no.

Accumulated depreciation is credited to the General ledger account entered in this field.

Note:
If the field is left blank, accumulated depreciation is credited to the account entered in the Accum. deprec. account no. field, see the description of the Accum. deprec. account no. field.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL nameAccWOAcThe database field name.
API identifieraccumulatedDepreciationAccountNoThe API identifier used in GraphQL.
Number5684 
Table 2. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountAccumulatedDepreciationAccount
  • Accum. deprec. account no.

Accum. deval. acc. no.

Accumulated Write off of Write down is debited to the General ledger account entered in this field.

Note:
If the field is left blank, accumulated depreciations are debited to the account entered in the Accum. deprec. account no. field, see the description of the Accum. deprec. account no. field.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL nameWdAccWOAcThe database field name.
API identifieraccumulatedDevaluationAccountNoThe API identifier used in GraphQL.
Number16179 
Table 3. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountAccumulatedDevaluationAccount
  • Accum. deval. acc. no.

Accum. reval. acc. no.

Accumulated Write off of Write up is credited to the General ledger account entered in this field.

Note:
If the field is left blank, accumulated depreciations are credited to the account entered in the Accum. deprec. account no. field. See the description of the Cap. asset account field.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL nameWuAccWOAcThe database field name.
API identifieraccumulatedRevaluationAccountNoThe API identifier used in GraphQL.
Number16182 
Table 4. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountAccumulatedRevaluationAccount
  • Accum. reval. acc. no.

Add. acc. no.

Additional transactions are accumulated in the General ledger account (the asset account) that you enter in this field.

This account can be overridden for particular additional number ranges in the Account no. series table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL nameAddAcThe database field name.
API identifieraddAccountNoThe API identifier used in GraphQL.
Number16183 
Table 5. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountAdditionAccount
  • Add. acc. no.

Cap. asset account

Enter the General ledger account (the asset account) where Capital asset transaction regarding acquisitions are accumulated.

This account can be overridden for particular capital asset number ranges in the Account no. series table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL namePropAcThe database field name.
API identifiercapitalAssetAccountNoThe API identifier used in GraphQL.
Number5682 
Table 6. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountCapitalAssetAccount
  • Cap. asset account

Cap. asset class no.

A unique number identifying the Capital asset class.

Note:
If you press + in this field, the next available number is suggested. Gaps in the number series resulting from any deleted rows are not suggested. If you enter an existing number you will receive an error message. The number cannot be changed once it is entered.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainCap. asset class no.Integer
Primary keyYesCap. asset class no.
SQL namePropClNoThe database field name.
API identifiercapitalAssetClassNoThe API identifier used in GraphQL.
Number5679 

Cap. asset gr. no.

Enter the Cap. asset gr. no. to which the Capital asset class belongs.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainCap. asset gr. no.Integer
SQL nameBalGrNoThe database field name.
API identifiercapitalAssetGroupNoThe API identifier used in GraphQL.
Number5685 
Table 7. Table relations
To tablePurposeFrom columnsTo columnsComments
Capital asset groupCapitalAssetGroup
  • Cap. asset gr. no.

Capital asset options

A look-up opens the dialog box where you can see the following check boxes and options:
Suspended
The voucher lines will not be posted directly to the capital asset. You will see the message "Capital asset xxxxxxx is suspended from direct posting" in the status bar if trying to enter it manually as debit or credit account on a voucher line.
Deduct scrap value from depreciation basis
The Scrap Value specified for the capital asset is not processed as a residual entry at the end of the capital asset's life span, but the value will be deducted from the basis for depreciation of the original acquisition each time depreciation is performed.
Update purchase date from voucher date
If you select this field, and a voucher with Capital asset proc. = 1 - Acquisition is updated for the capital asset, the capital asset's acquisition date becomes equal to the voucher date instead of the value date.
Note:

If you select this field, and the voucher date is in a different accounting period to the value date it may be necessary to manually adjust the end dates of the capital asset.

Move end date if "No deprec. < 1/2 month"
When a voucher with Capital asset proc. = 1 - Acquisition is updated for the capital asset, the end date is calculated with + 1 period if the acquisition date is equal to or higher than the 16th day of the month, and you have selected the No deprec. < 1/2 month field under Accounting processing in the Company information table.
Suspended from processing
You can only run the Create document processings from the Capital asset table. The other processings are locked if you select this field.

When you update the voucher for capital asset with Capital asset proc. = 5 - Sale or 6 - Discarded, the Suspended from processing and Suspended field will be selected automatically.

Update purch. date and end date at each acquisition
When selected, the Purch. date and the End date investment will be updated each time a new voucher with Capital asset proc. = 1 - Acquisition is updated for the capital asset. The option is mainly used for construction industry, where the Depreciation might start from the beginning of the construction, but where the Purch. date and End date investment shall be determined from the completion of the construction.
Exempt capital asset from depreciation
The capital asset will be exempt from depreciation. The fields Exempt addition from depreciation, Exempt revaluation from depreciation and Exempt devaluation from depreciation will be selected automatically when this option is selected.
Exempt addition from depreciation
Additions will be exempt from depreciation.
Exempt revaluation from depreciation
Revaluations will be exempt from depreciation.
Exempt devaluation from depreciation
Devaluation will be exempt from depreciation.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainCapital asset optionsInteger
SQL namePropPrefThe database field name.
API identifiercapitalAssetPreferencesThe API identifier used in GraphQL.
Number15281 

Cost at sales

Enter the General ledger account to which any loss from the sale of the Capital asset is to be posted.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL nameCstAcNoThe database field name.
API identifiercostAtSalesAccountNoThe API identifier used in GraphQL.
Number14526 
Table 8. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountCostAtSaleAccount
  • Cost at sales

Deprec. acc.

Depreciation is debited to the cost General ledger account entered in this field.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL nameWOCstAcThe database field name.
API identifierdepreciationAccountNoThe API identifier used in GraphQL.
Number5683 
Table 9. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountDepreciationAccount
  • Deprec. acc.

Deprec. add. acc. no.

Accumulated Write off add. is credited to the General ledger account entered in this field.

Note:
If this field is left blank, accumulated Write off add. is credited to the General ledger account entered in the Accum. deprec. account no. field, see the description of the Accum. deprec. account no. field.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL nameAddWOCstAcThe database field name.
API identifierdepreciatedAddAccountNoThe API identifier used in GraphQL.
Number16184 
Table 10. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountDepreciatedAdditionAccount
  • Deprec. add. acc. no.

Deprec. deval. acc. no.

Depreciations of devaluations are credited to the cost account entered in this field.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL nameWdWOCstAcThe database field name.
API identifierdepreciatedDevaluationAccountNoThe API identifier used in GraphQL.
Number16178 
Table 11. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountDepreciatedDevaluationAccount
  • Deprec. deval. acc. no.

Deprec. reval. acc. no.

Accumulated depreciations are debited to the General ledger account entered in this field.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL nameWuWOCstAcThe database field name.
API identifierdepreciatedRevaluationAccountNoThe API identifier used in GraphQL.
Number16181 
Table 12. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountDepreciatedRevaluationAccount
  • Deprec. reval. acc. no.

Depreciation rate

Enter the Depreciation rate as a percentage per year. You can override the rate for individual capital assets.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainPercentDecimal
SQL nameWORtThe database field name.
API identifierdepreciationRateThe API identifier used in GraphQL.
Number5681 

Depreciations per year

Enter the number of write-offs per calendar year.

Note:
If the field is left blank, 1 - Annually is used.

A look-up in this field gives you the following list of possible values:
1 - Annually
2 - Biannually
3 - Every four months
4 - Quarterly
6 - Bimonthly
12 - Monthly
13 - Every 4 weeks
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainDepreciations per yearInteger
SQL nameWOYrThe database field name.
API identifierdepreciationsPerYearThe API identifier used in GraphQL.
Number5757 

Description

The description of the Capital asset class.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainNameText (80)
SQL nameDescrThe database field name.
API identifierdescriptionThe API identifier used in GraphQL.
Number5680 

Deval. acc. no.

Accumulated depreciations are credited to the General ledger account entered in this field.

Note:
If the field is left blank, accumulated depreciations are credited to the General ledger account entered in the Cap. asset account field, see the description of the Cap. asset account field.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL nameWdAcThe database field name.
API identifierdevaluationAccountNoThe API identifier used in GraphQL.
Number16177 
Table 13. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountDevaluationAccount
  • Deval. acc. no.

Income account

Enter the General ledger account to which the value of the Capital asset is to be posted when sold.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL nameLiqAcNoThe database field name.
API identifierincomeAccountNoThe API identifier used in GraphQL.
Number14528 
Table 14. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountCapitalAssetLiquidAccount
  • Income account

Income at sales

Enter the General ledger account to which any surplus from the sale of the Capital asset is to be posted.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL nameIncAcNoThe database field name.
API identifierincomeAtSalesAccountNoThe API identifier used in GraphQL.
Number14525 
Table 15. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountIncomeAtSaleAccount
  • Income at sales

Loss at scrap

Enter the General ledger account to which any loss from the scrapping of the Capital asset is to be posted.

The system takes into account the value in this field when you run the Depreciation processing.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL nameLossAcNoThe database field name.
API identifierlossAtScrapAccountNoThe API identifier used in GraphQL.
Number14527 
Table 16. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountLossAtScrapAccount
  • Loss at scrap

Reval. acc. no.

Depreciations will be debited to the General ledger account entered in this field.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAccount no.Integer
SQL nameWuAcThe database field name.
API identifierrevaluationAccountNoThe API identifier used in GraphQL.
Number16180 
Table 17. Table relations
To tablePurposeFrom columnsTo columnsComments
General ledger accountRevaluationAccount
  • Reval. acc. no.

Scrap Value

Specify the amount you cannot write off.

The default is the residual value. You can select the Deduct scrap value from depreciation basis option under the Capital asset options field if you want to divide out the amount that you specified in the Scrap Value field for each month.

Example

If you specify a value of 1 (one kroner) in this field, and the investment is 60,000 and the life span is 5 years, the depreciation for each month will be 1,000 kroner in the month, but the last depreciation will not be 1,000 but 999 kroner.

Example

The option Deduct scrap value from depreciation basis in Capital asset options is selected, the Scrap Value is 20.000, the investment is 60.000 and the life span is 5 years.

In this case the depreciation basis will be 40.000, and the depreciation per month will be 666,67 instead of 1.0000.

Note:
If you buy a property, and you do get to not write off the site, you can register the site amount in the Scrap Value field and at the same time Deduct scrap value from depreciation basis

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
SQL nameScrapVThe database field name.
API identifierscrapValueThe API identifier used in GraphQL.
Number12179 

Control columns

Control columns include information about who has changed the record last and when, and which process that is currently editing the record.

Changed by provenance

The provenance for the record change.

A look-up in this field gives you the following list of possible values:

0 - None

1 - UI

10 - External API

20 - GAiA

21 - AI Connect

100 - Internal service

101 - Task automation

102 - AutoInvoice download

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProvenanceInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChPvnThe database field name.
API identifierchangedByProvenanceThe API identifier used in GraphQL.
NumberA unique column number. 

Changed by user

The name of the user that changed the record.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainUser nameText (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChUsrThe database field name.
API identifierchangedByUserThe API identifier used in GraphQL.
NumberA unique column number. 

Changed date

The date when the record was changed.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChDtThe database field name.
API identifierchangedDateThe API identifier used in GraphQL.
NumberA unique column number. 

Changed time

The time when the record was changed.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTimeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChTmThe database field name.
API identifierchangedTimeThe API identifier used in GraphQL.
NumberA unique column number. 

Changed time stamp

The date and time when the record was changed.

The field is updated with the UTC time.

This value can be used by external systems to replicate changed data. The column is indexed. 

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDate/timeDateTime
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChTsThe database field name.
API identifierchangedTimestampThe API identifier used in GraphQL.
NumberA unique column number. 

Created by provenance

The provenance for the record creation.

A look-up in this field gives you the following list of possible values:

0 - None

1 - UI

10 - External API

20 - GAiA

21 - AI Connect

100 - Internal service

101 - Task automation

102 - AutoInvoice download

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProvenanceInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCrePvnThe database field name.
API identifiercreatedByProvenanceThe API identifier used in GraphQL.
NumberA unique column number. 

Created by user

The name of the user that created the record.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainUser nameText (24)
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreUsrThe database field name.
API identifiercreatedByUserThe API identifier used in GraphQL.
NumberA unique column number. 

Created date

The date when the record was created.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreDtThe database field name.
API identifiercreatedDateThe API identifier used in GraphQL.
NumberA unique column number. 

Created time

The time when the record was created.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTimeInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreTmThe database field name.
API identifiercreatedTimeThe API identifier used in GraphQL.
NumberA unique column number. 

Created time stamp

The date and time when the record was created.

The field is updated with the UTC time.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDate/timeDateTime
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameCreTsThe database field name.
API identifiercreatedTimestampThe API identifier used in GraphQL.
NumberA unique column number. 

Edit status

The current status of the record.

A look-up in this field gives you the following list of possible values:

0 - Unchanged: The record is read, but not changed.

1 - Inserted: The record is new.

2 - Changed: The record is changed.

3 - Deleted: The record is deleted.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEdit statusInteger
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameLckStThe database field name.
API identifiereditStatusThe API identifier used in GraphQL.
NumberA unique column number. 

Process no

The Process no. from the Active company process table which is currently using or has control of this record.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProcess no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameChPrcThe database field name.
API identifierlockedByProcessNoThe API identifier used in GraphQL.
NumberA unique column number. 
Table 18. Table relations
To table Purpose From columns To columns Comments
Active company process CompanyProcess Process no. Process no.