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.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | PropCl | The table name in the database. |
| API identifier | capitalAssetClass | The API identifier used in GraphQL. |
| Table no. | 169 | The 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | AddAccWOAc | The database field name. |
| API identifier | accumulatedAddAccountNo | The API identifier used in GraphQL. |
| Number | 16185 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | AccumulatedAdditionAccount |
|
Accum. deprec. account no.
Accumulated depreciation is credited to the General ledger account entered in this field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | AccWOAc | The database field name. |
| API identifier | accumulatedDepreciationAccountNo | The API identifier used in GraphQL. |
| Number | 5684 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | AccumulatedDepreciationAccount |
|
Accum. deval. acc. no.
Accumulated Write off of Write down is debited to the General ledger account entered in this field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | WdAccWOAc | The database field name. |
| API identifier | accumulatedDevaluationAccountNo | The API identifier used in GraphQL. |
| Number | 16179 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | AccumulatedDevaluationAccount |
|
Accum. reval. acc. no.
Accumulated Write off of Write up is credited to the General ledger account entered in this field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | WuAccWOAc | The database field name. |
| API identifier | accumulatedRevaluationAccountNo | The API identifier used in GraphQL. |
| Number | 16182 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | AccumulatedRevaluationAccount |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | AddAc | The database field name. |
| API identifier | addAccountNo | The API identifier used in GraphQL. |
| Number | 16183 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | AdditionAccount |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | PropAc | The database field name. |
| API identifier | capitalAssetAccountNo | The API identifier used in GraphQL. |
| Number | 5682 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | CapitalAssetAccount |
|
Cap. asset class no.
A unique number identifying the Capital asset class.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Cap. asset class no. | Integer |
| Primary key | Yes | Cap. asset class no. |
| SQL name | PropClNo | The database field name. |
| API identifier | capitalAssetClassNo | The API identifier used in GraphQL. |
| Number | 5679 |
Cap. asset gr. no.
Enter the Cap. asset gr. no. to which the Capital asset class belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Cap. asset gr. no. | Integer |
| SQL name | BalGrNo | The database field name. |
| API identifier | capitalAssetGroupNo | The API identifier used in GraphQL. |
| Number | 5685 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Capital asset group | CapitalAssetGroup |
|
Capital asset 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Capital asset options | Integer |
| SQL name | PropPref | The database field name. |
| API identifier | capitalAssetPreferences | The API identifier used in GraphQL. |
| Number | 15281 |
Cost at sales
Enter the General ledger account to which any loss from the sale of the Capital asset is to be posted.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | CstAcNo | The database field name. |
| API identifier | costAtSalesAccountNo | The API identifier used in GraphQL. |
| Number | 14526 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | CostAtSaleAccount |
|
Deprec. acc.
Depreciation is debited to the cost General ledger account entered in this field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | WOCstAc | The database field name. |
| API identifier | depreciationAccountNo | The API identifier used in GraphQL. |
| Number | 5683 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | DepreciationAccount |
|
Deprec. add. acc. no.
Accumulated Write off add. is credited to the General ledger account entered in this field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | AddWOCstAc | The database field name. |
| API identifier | depreciatedAddAccountNo | The API identifier used in GraphQL. |
| Number | 16184 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | DepreciatedAdditionAccount |
|
Deprec. deval. acc. no.
Depreciations of devaluations are credited to the cost account entered in this field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | WdWOCstAc | The database field name. |
| API identifier | depreciatedDevaluationAccountNo | The API identifier used in GraphQL. |
| Number | 16178 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | DepreciatedDevaluationAccount |
|
Deprec. reval. acc. no.
Accumulated depreciations are debited to the General ledger account entered in this field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | WuWOCstAc | The database field name. |
| API identifier | depreciatedRevaluationAccountNo | The API identifier used in GraphQL. |
| Number | 16181 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | DepreciatedRevaluationAccount |
|
Depreciation rate
Enter the Depreciation rate as a percentage per year. You can override the rate for individual capital assets.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Percent | Decimal |
| SQL name | WORt | The database field name. |
| API identifier | depreciationRate | The API identifier used in GraphQL. |
| Number | 5681 |
Depreciations per year
Enter the number of write-offs per calendar year.
- 1 - Annually
- 2 - Biannually
- 3 - Every four months
- 4 - Quarterly
- 6 - Bimonthly
- 12 - Monthly
- 13 - Every 4 weeks
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Depreciations per year | Integer |
| SQL name | WOYr | The database field name. |
| API identifier | depreciationsPerYear | The API identifier used in GraphQL. |
| Number | 5757 |
Description
The description of the Capital asset class.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Name | Text (80) |
| SQL name | Descr | The database field name. |
| API identifier | description | The API identifier used in GraphQL. |
| Number | 5680 |
Deval. acc. no.
Accumulated depreciations are credited to the General ledger account entered in this field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | WdAc | The database field name. |
| API identifier | devaluationAccountNo | The API identifier used in GraphQL. |
| Number | 16177 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | DevaluationAccount |
|
Income account
Enter the General ledger account to which the value of the Capital asset is to be posted when sold.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | LiqAcNo | The database field name. |
| API identifier | incomeAccountNo | The API identifier used in GraphQL. |
| Number | 14528 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | CapitalAssetLiquidAccount |
|
Income at sales
Enter the General ledger account to which any surplus from the sale of the Capital asset is to be posted.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | IncAcNo | The database field name. |
| API identifier | incomeAtSalesAccountNo | The API identifier used in GraphQL. |
| Number | 14525 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | IncomeAtSaleAccount |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | LossAcNo | The database field name. |
| API identifier | lossAtScrapAccountNo | The API identifier used in GraphQL. |
| Number | 14527 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | LossAtScrapAccount |
|
Reval. acc. no.
Depreciations will be debited to the General ledger account entered in this field.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | WuAc | The database field name. |
| API identifier | revaluationAccountNo | The API identifier used in GraphQL. |
| Number | 16180 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | RevaluationAccount |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | ScrapV | The database field name. |
| API identifier | scrapValue | The API identifier used in GraphQL. |
| Number | 12179 |
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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPvn | The database field name. |
| API identifier | changedByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed by user
The name of the user that changed the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChUsr | The database field name. |
| API identifier | changedByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed date
The date when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChDt | The database field name. |
| API identifier | changedDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Changed time
The time when the record was changed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTm | The database field name. |
| API identifier | changedTime | The API identifier used in GraphQL. |
| Number | A 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChTs | The database field name. |
| API identifier | changedTimestamp | The API identifier used in GraphQL. |
| Number | A 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
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Provenance | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CrePvn | The database field name. |
| API identifier | createdByProvenance | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created by user
The name of the user that created the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | User name | Text (24) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreUsr | The database field name. |
| API identifier | createdByUser | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created date
The date when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreDt | The database field name. |
| API identifier | createdDate | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time
The time when the record was created.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Time | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTm | The database field name. |
| API identifier | createdTime | The API identifier used in GraphQL. |
| Number | A unique column number. |
Created time stamp
The date and time when the record was created.
The field is updated with the UTC time.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date/time | DateTime |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CreTs | The database field name. |
| API identifier | createdTimestamp | The API identifier used in GraphQL. |
| Number | A 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Edit status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LckSt | The database field name. |
| API identifier | editStatus | The API identifier used in GraphQL. |
| Number | A unique column number. |
Process no
The Process no. from the Active company process table which is currently using or has control of this record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Process no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ChPrc | The database field name. |
| API identifier | lockedByProcessNo | The API identifier used in GraphQL. |
| Number | A unique column number. |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Active company process | CompanyProcess | Process no. | Process no. |