Capital asset
This table contains one row for each capital asset.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | Prop | The table name in the database. |
| API identifier | capitalAsset | The API identifier used in GraphQL. |
| Table no. | 170 | The table number in the data model. |
The following fields exist in this table:
Accr. depr. amount
The Accr. depr. amount of a capital asset that is transferred in connection with a change from a different system.
Shall only be used in connection with an amount in Hist. purchase amount. The amount will be entered as on vouchers created from the Initialize capital asset processing. This voucher will contain the Cap. asset no. in credit and the Capital asset proc.=9 - Depreciation on investment.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | AccWOAm | The database field name. |
| API identifier | accumulatedDepreciationAmount | The API identifier used in GraphQL. |
| Number | 14531 |
Barcode
If barcode is used for identifying the capital asset, it can be entered in this field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Barcode | Text (52) |
| SQL name | SCd | The database field name. |
| API identifier | barcode | The API identifier used in GraphQL. |
| Number | 5758 |
Buyer
To register who has purchased the capital asset.
The Empl. no. is a unique number identifying one specific Employee.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Empl. no. | Integer |
| SQL name | Buyer | The database field name. |
| API identifier | buyer | The API identifier used in GraphQL. |
| Number | 5701 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Buyer |
|
Cap. asset class no.
Enter the Capital asset class to which the capital asset belongs.
The Capital asset class contains the General ledger accounts that are used for postings related to capital asset transactions. Specifying Capital asset class is mandatory in order to be able to run the processings Depreciation, Initialize capital asset, and Sell or scrap and update vouchers for the capital asset.
If updating a voucher containing a Debit account or a Credit account with a Capital asset no that is not related to a Capital asset class, the General ledger postings will end up at the Posting errors account.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Cap. asset class no. | Integer |
| SQL name | PropClNo | The database field name. |
| API identifier | capitalAssetClassNo | The API identifier used in GraphQL. |
| Number | 5695 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Capital asset class | CapitalAssetClass |
|
Cap. asset no.
A unique number identifying the capital asset.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Cap. asset no. | Integer |
| Primary key | Yes | Cap. asset no. |
| SQL name | PropNo | The database field name. |
| API identifier | capitalAssetNo | The API identifier used in GraphQL. |
| Number | 5693 |
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 | No | This field is not 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 | 15282 |
Capital assets template
Use the capital assets template to create a new capital asset with the same setting/values to which you refer.
To create a new capital asset with the same properties as one you know from before, you enter the new capital asset, the capital asset name and then the value of the one you want to use as a template. All the values from this capital asset will then be entered, apart from the fields that you filled in yourself. This method replaces the use of entry rules and makes it simpler and safer to create a new capital asset.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Cap. asset no. | Integer |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | capitalAssetsTemplate | The API identifier used in GraphQL. |
| Number | 8756 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Capital asset | CapitalAssetsTemplate |
|
Currency no.
If not manually entered when the capital asset is registered, it will be updated when you update the capital asset's purchase voucher.
It is possible to keep the accounting for the capital asset in a foreign currency, however the depreciations will always be calculated in the standard currency and the depreciation in currency will be calculated to the Exchange rate used on the acquisition transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Currency no. | Integer |
| SQL name | Cur | The database field name. |
| API identifier | currencyNo | The API identifier used in GraphQL. |
| Number | 14223 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | Currency |
|
Currency no. 2
If not manually entered when the capital asset is registered, it will be updated when you update the capital asset's purchase voucher.
It is possible to keep the accounting for the capital asset in currency 2, however the depreciations will always be calculated in the standard currency and the depreciation in currency 2 will be calculated to the Exchange rate used on the acquisition transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Currency no. | Integer |
| SQL name | Cur2 | The database field name. |
| API identifier | currencyNo2 | The API identifier used in GraphQL. |
| Number | 14319 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | Currency2 |
|
Date last depreciation
The date on which the capital asset was last depreciated.
The value date is entered in the field when depreciation vouchers with a Capital asset no and a Capital asset proc. = 9 - Depreciation on investment, 10 - Depreciation on addition, 11 - Depreciation on revaluation, 12 - Depreciation on devaluation are updated. The field can also be filled in manually, for example, in order to exclude automatic depreciation up to a given date. This field is used during the production of depreciation vouchers. For depreciations the program only calculates depreciation for periods after this date. The date acts as a type of "locking date" when using the depreciation function.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | LstWODt | The database field name. |
| API identifier | lastDepreciationDate | The API identifier used in GraphQL. |
| Number | 5779 |
Depreciation rate
Informs about the annual percentage depreciation rate.
This field is filled in when you enter a value in the Life span field for the capital asset.
| 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 | 5698 |
Description
Enter a description of the capital asset.
| 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 | 5694 |
Distribution key
Enter a distribution key. The distribution key is copied into manually entered and automatically generated vouchers where the capital asset number is specified.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Distribution key | Integer |
| SQL name | DstGr | The database field name. |
| API identifier | distributionKeyNo | The API identifier used in GraphQL. |
| Number | 13811 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Distribution key | DistributionKey |
|
End date addition
In this field you enter the end date for addition.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | EndDtAdd | The database field name. |
| API identifier | endDateAddition | The API identifier used in GraphQL. |
| Number | 14462 |
End date devaluation
In this field you enter the end date for devaluation.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | EndDtWd | The database field name. |
| API identifier | endDateDevaluation | The API identifier used in GraphQL. |
| Number | 16186 |
End date investment
In this field you enter the end date for acquisition.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | EndDtInv | The database field name. |
| API identifier | endDateInvestment | The API identifier used in GraphQL. |
| Number | 14461 |
End date write up
In this field you enter the end date for write-up.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | EndDtWrU | The database field name. |
| API identifier | endDateWriteUp | The API identifier used in GraphQL. |
| Number | 14463 |
Exchange rate
Use this field to post currency to the capital asset.
When you enter currency and exchange rate in the capital asset's purchase voucher, the corresponding fields are updated in the Capital asset table. These are then used on depreciation, write up and devaluation vouchers. The corresponding fields are also updated in the Capital asset transaction and Capital asset balance tables. You can perform a currency adjustment for capital asset transactions in the same way as for general ledger, customer and supplier transactions.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Exchange rate | Decimal |
| SQL name | ExRt | The database field name. |
| API identifier | exchangeRate | The API identifier used in GraphQL. |
| Number | 14298 |
Exchange rate 2
Use this field to post currency 2 to the capital asset.
When you enter currency 2 and exchange rate 2, the corresponding fields in the Capital asset transaction and Capital asset balance tables are updated. You can also perform a currency adjustment for capital asset transactions in the same way as for general ledger, customer and supplier transactions.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Exchange rate | Decimal |
| SQL name | ExRt2 | The database field name. |
| API identifier | exchangeRate2 | The API identifier used in GraphQL. |
| Number | 15253 |
Gr. 1
A group to which the capital asset belongs.
You can use these group fields, for example, to group or make selections on capital assets according to which group they are defined in. You can define the codes you require yourself, as well as what they stand for.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Capital asset grouping 1 | Integer |
| SQL name | Gr | The database field name. |
| API identifier | group1 | The API identifier used in GraphQL. |
| Number | 5395 |
Gr. 2
A group to which the capital asset belongs.
You can use these group fields, for example, to group or make selections on capital assets according to which group they are defined in. You can define the codes you require yourself, as well as what they stand for.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Capital asset grouping 2 | Integer |
| SQL name | Gr2 | The database field name. |
| API identifier | group2 | The API identifier used in GraphQL. |
| Number | 5396 |
Gr. 3
A group to which the capital asset belongs.
You can use these group fields, for example, to group or make selections on capital assets according to which group they are defined in. You can define the codes you require yourself, as well as what they stand for.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Capital asset grouping 3 | Integer |
| SQL name | Gr3 | The database field name. |
| API identifier | group3 | The API identifier used in GraphQL. |
| Number | 5397 |
Gr. 4
A group to which the capital asset belongs.
You can use these group fields, for example, to group or make selections on capital assets according to which group they are defined in. You can define the codes you require yourself, as well as what they stand for.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Capital asset grouping 4 | Integer |
| SQL name | Gr4 | The database field name. |
| API identifier | group4 | The API identifier used in GraphQL. |
| Number | 5398 |
Gr. 5
A group to which the capital asset belongs.
You can use these group fields, for example, to group or make selections on capital assets according to which group they are defined in. You can define the codes you require yourself, as well as what they stand for.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Capital asset grouping 5 | Integer |
| SQL name | Gr5 | The database field name. |
| API identifier | group5 | The API identifier used in GraphQL. |
| Number | 5399 |
Gr. 6
A group to which the capital asset belongs.
You can use these group fields, for example, to group or make selections on capital assets according to which group they are defined in. You can define the codes you require yourself, as well as what they stand for.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Capital asset grouping 6 | Integer |
| SQL name | Gr6 | The database field name. |
| API identifier | group6 | The API identifier used in GraphQL. |
| Number | 5401 |
Gr. 7
A group to which the capital asset belongs.
You can use these group fields, for example, to group or make selections on capital assets according to which group they are defined in. You can define the codes you require yourself, as well as what they stand for.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Capital asset grouping 7 | Integer |
| SQL name | Gr7 | The database field name. |
| API identifier | group7 | The API identifier used in GraphQL. |
| Number | 6055 |
Gr. 8
A group to which the capital asset belongs.
You can use these group fields, for example, to group or make selections on capital assets according to which group they are defined in. You can define the codes you require yourself, as well as what they stand for.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Capital asset grouping 8 | Integer |
| SQL name | Gr8 | The database field name. |
| API identifier | group8 | The API identifier used in GraphQL. |
| Number | 6056 |
Gr. 9
A group to which the capital asset belongs.
You can use these group fields, for example, to group or make selections on capital assets according to which group they are defined in. You can define the codes you require yourself, as well as what they stand for.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Capital asset grouping 9 | Integer |
| SQL name | Gr9 | The database field name. |
| API identifier | group9 | The API identifier used in GraphQL. |
| Number | 6057 |
Gr. 10
A group to which the capital asset belongs.
You can use these group fields, for example, to group or make selections on capital assets according to which group they are defined in. You can define the codes you require yourself, as well as what they stand for.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Capital asset grouping 10 | Integer |
| SQL name | Gr10 | The database field name. |
| API identifier | group10 | The API identifier used in GraphQL. |
| Number | 6058 |
Gr. 11
A group to which the capital asset belongs.
You can use these group fields, for example, to group or make selections on capital assets according to which group they are defined in. You can define the codes you require yourself, as well as what they stand for.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Capital asset grouping 11 | Integer |
| SQL name | Gr11 | The database field name. |
| API identifier | group11 | The API identifier used in GraphQL. |
| Number | 6059 |
Gr. 12
A group to which the capital asset belongs.
You can use these group fields, for example, to group or make selections on capital assets according to which group they are defined in. You can define the codes you require yourself, as well as what they stand for.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Capital asset grouping 12 | Integer |
| SQL name | Gr12 | The database field name. |
| API identifier | group12 | The API identifier used in GraphQL. |
| Number | 6060 |
Guarantee expires
Enter the date on which the guarantee for the capital asset expires.
The field is used for information only.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | WarToDt | The database field name. |
| API identifier | guaranteeExpireDate | The API identifier used in GraphQL. |
| Number | 5760 |
Hist. purchase amount
When transferring capital asset data from a different system, you can enter the Hist. purchase amount directly in this field.
The amount will be used for an initialization voucher with Capital asset proc. = 1 - Acquisition when the processing Initialize capital asset is run.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | PurcAm | The database field name. |
| API identifier | historicalPurchaseAmount | The API identifier used in GraphQL. |
| Number | 14530 |
Income amount
If the capital asset has been sold for a fee, you can specify the Income amount in this field.
The amount will be used for an income voucher with Capital asset proc. = 5 - Sale, that can be created if the processing Sell or scrap is run.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | IncAm | The database field name. |
| API identifier | incomeAmount | The API identifier used in GraphQL. |
| Number | 14529 |
Inf. 1
Additional capital asset information.
Use up to eight information fields. These fields can contain temporary information. This means that you can enter totally different types of information about the various capital assets. The information can be printed in lists and reports. You can also sort and select the fields.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf | The database field name. |
| API identifier | information1 | The API identifier used in GraphQL. |
| Number | 5402 |
Inf. 2
Additional capital asset information.
Use up to eight information fields. These fields can contain temporary information. This means that you can enter totally different types of information about the various capital assets. The information can be printed in lists and reports. You can also sort and select the fields.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf2 | The database field name. |
| API identifier | information2 | The API identifier used in GraphQL. |
| Number | 5403 |
Inf. 3
Additional capital asset information.
Use up to eight information fields. These fields can contain temporary information. This means that you can enter totally different types of information about the various capital assets. The information can be printed in lists and reports. You can also sort and select the fields.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf3 | The database field name. |
| API identifier | information3 | The API identifier used in GraphQL. |
| Number | 5404 |
Inf. 4
Additional capital asset information.
Use up to eight information fields. These fields can contain temporary information. This means that you can enter totally different types of information about the various capital assets. The information can be printed in lists and reports. You can also sort and select the fields.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf4 | The database field name. |
| API identifier | information4 | The API identifier used in GraphQL. |
| Number | 5405 |
Inf. 5
Additional capital asset information.
Use up to eight information fields. These fields can contain temporary information. This means that you can enter totally different types of information about the various capital assets. The information can be printed in lists and reports. You can also sort and select the fields.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf5 | The database field name. |
| API identifier | information5 | The API identifier used in GraphQL. |
| Number | 5406 |
Inf. 6
Additional capital asset information.
Use up to eight information fields. These fields can contain temporary information. This means that you can enter totally different types of information about the various capital assets. The information can be printed in lists and reports. You can also sort and select the fields.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf6 | The database field name. |
| API identifier | information6 | The API identifier used in GraphQL. |
| Number | 5407 |
Inf. 7
Additional capital asset information.
Use up to eight information fields. These fields can contain temporary information. This means that you can enter totally different types of information about the various capital assets. The information can be printed in lists and reports. You can also sort and select the fields.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf7 | The database field name. |
| API identifier | information7 | The API identifier used in GraphQL. |
| Number | 6091 |
Inf. 8
Additional capital asset information.
Use up to eight information fields. These fields can contain temporary information. This means that you can enter totally different types of information about the various capital assets. The information can be printed in lists and reports. You can also sort and select the fields.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Inf. @ | Text (40) |
| SQL name | Inf8 | The database field name. |
| API identifier | information8 | The API identifier used in GraphQL. |
| Number | 6092 |
Insurance value
Enter the insurance value of the capital asset.
The field is only used as information. It does not serve as basis for any processings or calculations.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | InsurVal | The database field name. |
| API identifier | insuranceValue | The API identifier used in GraphQL. |
| Number | 5765 |
Life span
In this field you can enter the capital asset's life span.
The value in this field is the basis for calculating End date investment ,End date addition, End date devaluation and End date write up when purchasing vouchers are updated. The system simultaneously calculates the depreciation rate (formula: 100 divided by the life span) and enters this value in the Depreciation rate field. Changing the life span will not have any impact on the End date investment, End date addition, End date devaluation and End date write up since these dates can have been manually overridden and differ from each other.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | LifeTm | The database field name. |
| API identifier | lifespan | The API identifier used in GraphQL. |
| Number | 5697 |
Main cap. asset no.
The parent capital asset, if capital assets are arranged in a hierarchy.
The hierarchy can be used in reports for capital assets. You can group on main units and add summary lines for the main units.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Cap. asset no. | Integer |
| SQL name | MainCapAssetNo | The database field name. |
| API identifier | mainCapitalAssetNo | The API identifier used in GraphQL. |
| Number | 20649 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Capital asset | MainCapitalAssetNo |
|
Memo file name
The file name for the Memo attached to the capital asset.
On the Editing menu, click Memo to create a new memo or to view the existing memo. The memo file name is saved in this text box.
Double-click or press * to open the Select file dialog box to manually select a memo file.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Memo file name | Text (260) |
| SQL name | NoteNm | The database field name. |
| API identifier | memoFileName | The API identifier used in GraphQL. |
| Number | 5408 |
Memo no.
Link to the memo for the entry.
The actual memo is stored in the Memo table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Memo no. | Integer |
| SQL name | MemoNo | The database field name. |
| API identifier | memoNo | The API identifier used in GraphQL. |
| Number | 19213 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Memo | Memo |
|
New cap. asset no.
If the capital asset number shall be changed, the new capital asset number here before the processing Change capital asset no. is run.
- Enter the new capital asset number in the New cap. asset no. field for the capital assets whose number you wish to change.
- Highlight or select the capital assets with a value in the New cap. asset no. field.
- Run the processing Change capital asset no.. This processing updates all foreign keys containing the Cap. asset no. field in all tables that refer to the field. Business NXT also deals with instances where two numerical keys exchange values.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Cap. asset no. | Integer |
| SQL name | NewPropNo | The database field name. |
| API identifier | newCapitalAssetNo | The API identifier used in GraphQL. |
| Number | 13809 |
Old cap. asset no.
When you change a capital asset number the old number is saved in this field.
See the explanation of the New cap. asset no. field in the Capital asset table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Cap. asset no. | Integer |
| SQL name | OldPropNo | The database field name. |
| API identifier | oldCapitalAssetNo | The API identifier used in GraphQL. |
| Number | 13810 |
Organisational unit 1
Enter the organisational units to which the capital asset belongs.
All the organisational unit classes that you have defined in the Company information table are loaded as separate fields. The most common ones are department, project and object. These fields are linked to the organisational unit tables, and are copied to the voucher, when vouchers are posted for the capital asset.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R1 | The database field name. |
| API identifier | orgUnit1 | The API identifier used in GraphQL. |
| Number | 5703 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 1 | OrgUnit1 |
|
Organisational unit 2
Enter the organisational units to which the capital asset belongs.
All the organisational unit classes that you have defined in the Company information table are loaded as separate fields. The most common ones are department, project and object. These fields are linked to the organisational unit tables, and are copied to the voucher, when vouchers are posted for the capital asset.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R2 | The database field name. |
| API identifier | orgUnit2 | The API identifier used in GraphQL. |
| Number | 5704 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 2 | OrgUnit2 |
|
Organisational unit 3
Enter the organisational units to which the capital asset belongs.
All the organisational unit classes that you have defined in the Company information table are loaded as separate fields. The most common ones are department, project and object. These fields are linked to the organisational unit tables, and are copied to the voucher, when vouchers are posted for the capital asset.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R3 | The database field name. |
| API identifier | orgUnit3 | The API identifier used in GraphQL. |
| Number | 5705 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 3 | OrgUnit3 |
|
Organisational unit 4
Enter the organisational units to which the capital asset belongs.
All the organisational unit classes that you have defined in the Company information table are loaded as separate fields. The most common ones are department, project and object. These fields are linked to the organisational unit tables, and are copied to the voucher, when vouchers are posted for the capital asset.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R4 | The database field name. |
| API identifier | orgUnit4 | The API identifier used in GraphQL. |
| Number | 5706 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 4 | OrgUnit4 |
|
Organisational unit 5
Enter the organisational units to which the capital asset belongs.
All the organisational unit classes that you have defined in the Company information table are loaded as separate fields. The most common ones are department, project and object. These fields are linked to the organisational unit tables, and are copied to the voucher, when vouchers are posted for the capital asset.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R5 | The database field name. |
| API identifier | orgUnit5 | The API identifier used in GraphQL. |
| Number | 5707 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 5 | OrgUnit5 |
|
Organisational unit 6
Enter the organisational units to which the capital asset belongs.
All the organisational unit classes that you have defined in the Company information table are loaded as separate fields. The most common ones are department, project and object. These fields are linked to the organisational unit tables, and are copied to the voucher, when vouchers are posted for the capital asset.
Organisational units fields can be used freely according to company needs to split accounting, sales and purchases into organisational units. The most common types are department, project and campaign. It is also possible to limit the organisational units a user should see by limiting the organisational units in the Limitation groups, User limitation groups and Limitations. The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Organisational unit no. | Integer |
| SQL name | R6 | The database field name. |
| API identifier | orgUnit6 | The API identifier used in GraphQL. |
| Number | 5394 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 6 | OrgUnit6 |
|
Organisational unit 7
Enter the organisational units to which the capital asset belongs.
All the organisational unit classes that you have defined in the Company information table are loaded as separate fields. The most common ones are department, project and object. These fields are linked to the organisational unit tables, and are copied to the voucher, when vouchers are posted for the capital asset.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Long alphanumeric organisational unit no. | Text (40) |
| SQL name | R7 | The database field name. |
| API identifier | orgUnit7 | The API identifier used in GraphQL. |
| Number | 9570 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 7 | OrgUnit7 |
|
Organisational unit 8
Enter the organisational units to which the capital asset belongs.
All the organisational unit classes that you have defined in the Company information table are loaded as separate fields. The most common ones are department, project and object. These fields are linked to the organisational unit tables, and are copied to the voucher, when vouchers are posted for the capital asset.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R8 | The database field name. |
| API identifier | orgUnit8 | The API identifier used in GraphQL. |
| Number | 9571 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 8 | OrgUnit8 |
|
Organisational unit 9
Enter the organisational units to which the capital asset belongs.
All the organisational unit classes that you have defined in the Company information table are loaded as separate fields. The most common ones are department, project and object. These fields are linked to the organisational unit tables, and are copied to the voucher, when vouchers are posted for the capital asset.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R9 | The database field name. |
| API identifier | orgUnit9 | The API identifier used in GraphQL. |
| Number | 9572 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 9 | OrgUnit9 |
|
Organisational unit 10
Enter the organisational units to which the capital asset belongs.
All the organisational unit classes that you have defined in the Company information table are loaded as separate fields. The most common ones are department, project and object. These fields are linked to the organisational unit tables, and are copied to the voucher, when vouchers are posted for the capital asset.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R10 | The database field name. |
| API identifier | orgUnit10 | The API identifier used in GraphQL. |
| Number | 9573 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 10 | OrgUnit10 |
|
Organisational unit 11
Enter the organisational units to which the capital asset belongs.
All the organisational unit classes that you have defined in the Company information table are loaded as separate fields. The most common ones are department, project and object. These fields are linked to the organisational unit tables, and are copied to the voucher, when vouchers are posted for the capital asset.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R11 | The database field name. |
| API identifier | orgUnit11 | The API identifier used in GraphQL. |
| Number | 9574 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 11 | OrgUnit11 |
|
Organisational unit 12
Enter the organisational units to which the capital asset belongs.
All the organisational unit classes that you have defined in the Company information table are loaded as separate fields. The most common ones are department, project and object. These fields are linked to the organisational unit tables, and are copied to the voucher, when vouchers are posted for the capital asset.
The field appear with the name assigned to it in the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Short alphanumeric organisational unit no. | Text (10) |
| SQL name | R12 | The database field name. |
| API identifier | orgUnit12 | The API identifier used in GraphQL. |
| Number | 9575 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 12 | OrgUnit12 |
|
Picture file name
Link to a picture of the capital asset.
By double-clicking in the field, a picture file can be linked to the capital asset.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Picture file name | Text (260) |
| SQL name | PictFNm | The database field name. |
| API identifier | pictureFileName | The API identifier used in GraphQL. |
| Number | 8559 |
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. Tip: Select Control columns in
the Unhide dialog to see the column. |
| 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 | 5413 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Active company process | CompanyProcess |
|
Product no.
Enter the product number for the capital asset.
The product no serves as information only, it does not serve as basis for any processings or calculations.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Product no. | Text (40) |
| SQL name | ProdNo | The database field name. |
| API identifier | productNo | The API identifier used in GraphQL. |
| Number | 5699 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product | Product |
| ||
| Search product | SearchProduct |
|
Purch. date
Displays the date on which the capital asset was purchased.
This field is filled in with the value date or the voucher date -if this is what you have selected in Capital asset options-, under updating of purchase voucher. When the purchase date is updated for a capital asset, the date fields End date investment, End date addition, End date devaluation and End date write up are updated in the same way as if you had selected the capital asset and held down the Ctrl key and clicked on the Initialize capital asset processing. This means that the end date is calculated on the purchase date plus the life span. Updating of the end date is carried out regardless of the whether the purchase date is entered manually and the processing Initialize capital asset is run or whether it is updated when updating the vouchers.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | PurcDt | The database field name. |
| API identifier | purchaseDate | The API identifier used in GraphQL. |
| Number | 5696 |
Responsible
Refers to a person responsible for the capital asset.
The Empl. no. is a unique number identifying one specific Employee.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Empl. no. | Integer |
| SQL name | Rsp | The database field name. |
| API identifier | official | The API identifier used in GraphQL. |
| Number | 5702 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Official |
|
Review date
Enter the date on which you want to review the various items of information on the capital asset.
The field is only used for information, it does not serve as basis for any calculations or processings.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | RevalDt | The database field name. |
| API identifier | reviewDate | The API identifier used in GraphQL. |
| Number | 5764 |
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 field in the dialog box 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 | 12180 |
Serial no.
The capital asset's serial number.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Serial no. | Text (40) |
| SQL name | SerNo | The database field name. |
| API identifier | serialNo | The API identifier used in GraphQL. |
| Number | 5759 |
Service agreement expires
Enter the date on which the service agreement for the capital asset expires.
The date is validated using the regional settings in Windows.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | SrvToDt | The database field name. |
| API identifier | serviceAgreementExpireDate | The API identifier used in GraphQL. |
| Number | 5763 |
Service agreement no.
Enter the number of the service agreement for the capital asset.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | SrvAgrNo | The database field name. |
| API identifier | serviceAgreementNo | The API identifier used in GraphQL. |
| Number | 5761 |
Service agreement supp.
Enter the supplier with whom you have a service agreement for the capital asset.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Sup. no. | Integer |
| SQL name | SrvAgrSp | The database field name. |
| API identifier | serviceAgreementSupplierNo | The API identifier used in GraphQL. |
| Number | 5762 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | ServiceAgreementSupplier |
|
Sup. no.
Enter who has supplied the capital asset.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Sup. no. | Integer |
| SQL name | SupNo | The database field name. |
| API identifier | supplierNo | The API identifier used in GraphQL. |
| Number | 5700 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Supplier |
|
Valuation
Enter the estimated value of the capital asset.
The field is only used for information, it does not serve as basis for any calculations or processings. To be used only for Capital asset`s market value normally differs from its market value, e.g. real estate.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | EstVal | The database field name. |
| API identifier | valuation | The API identifier used in GraphQL. |
| Number | 5766 |
VAT code
Not in use.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | VAT code | Integer |
| SQL name | TxCd | The database field name. |
| API identifier | taxCode | The API identifier used in GraphQL. |
| Number | 6675 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| VAT code | TaxCode |
|
Web page
Enter a reference to a document, e.g. in Word or Excel, or a home page on the Internet. You can use visualisation to view this page together with this account in the system.
Double-click or press * to open the web page in your web browser.
Alternatively the field can be used to refer to documents or other files. Double-click or press * in the empty field to open the Select file dialog box.
On the Design tab, in the Insert group, you can click on Web page to visualise the document or web page on the screen.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Web page | Text (260) |
| SQL name | WebPg2 | The database field name. |
| API identifier | webPage | The API identifier used in GraphQL. |
| Number | 8730 |
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. |