Capital asset transaction
This table contains transactions posted on capital assets.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is in the company databases. |
| SQL name | PropTr | The table name in the database. |
| API identifier | capitalAssetTransaction | The API identifier used in GraphQL. |
| Table no. | 171 | The table number in the data model. |
The following fields exist in this table:
Account. year/period
The accounting year and accounting period saved as one field. This value can be used by external applications, e.g. reporting tools, to avoid having to merge the two fields accounting year and accounting period.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Year/Per. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcYrPr | The database field name. |
| API identifier | accountingYearAndPeriod | The API identifier used in GraphQL. |
| Number | 11023 |
Accounting document no.
The accounting document no refers to Incoming accounting document table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | System supervisor user | Only users who are marked as System supervisor in the User table are allowed to modify the value in this field. |
| SQL name | InAcDocNo | The database field name. |
| API identifier | incomingAccountingDocumentNo | The API identifier used in GraphQL. |
| Number | 17962 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Accounting document | IncomingAccountingDocument |
|
Active approval task no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Approval Task no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcAppTskNo | The database field name. |
| API identifier | activeApprovalTaskNo | The API identifier used in GraphQL. |
| Number | 18977 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Approval task | ApprovalTask |
|
Additional text
Any additional information entered in the voucher.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Text | Text (200) |
| SQL name | Txt2 | The database field name. |
| API identifier | additionalText | The API identifier used in GraphQL. |
| Number | 5820 |
Amount in currency
Amount expressed in the foreign currency. The preceding sign is reversed if the transaction concerns a credit account number.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CurAm | The database field name. |
| API identifier | amountInCurrency | The API identifier used in GraphQL. |
| Number | 14226 |
Amount in currency 2
Amount expressed in the currency2. The preceding sign is reversed if the transaction concerns a credit account number.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CurAm2 | The database field name. |
| API identifier | amountInCurrency2 | The API identifier used in GraphQL. |
| Number | 14322 |
Amount in EURO
The Amount field converted to EURO.
If the standard currency, given in the Company information table is defined as Currency type 2 or 3 in the Currency table, the Amount in EURO will be calculated with the exchange rate given for Euro in Sales rate field in the Currency table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | amountInEuro | The API identifier used in GraphQL. |
| Number | 14229 |
Audit no.
Part of the records unique identification together with the Voucher jour. no.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Audit no. | Integer |
| Primary key | Yes | Voucher jour. no., Audit no. |
| SQL name | EntNo | The database field name. |
| API identifier | auditNo | The API identifier used in GraphQL. |
| Number | 5420 |
Balances not updated
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Boolean | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | BalUpd | The database field name. |
| API identifier | balancesNotUpdatedYet | The API identifier used in GraphQL. |
| Number | 19698 |
Basis
Shows the basic amount for the calculation of VAT.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Bas | The database field name. |
| API identifier | basisDomestic | The API identifier used in GraphQL. |
| Number | 5785 |
Cap. asset no.
Shows the capital asset to which the transaction applies.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Cap. asset no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PropNo | The database field name. |
| API identifier | capitalAssetNo | The API identifier used in GraphQL. |
| Number | 5421 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Capital asset | CapitalAsset |
| ||
| Capital asset balance | CapitalAssetBalance |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Product transaction | ProductTransaction |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Product transaction before compression | ProductTransaction2 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Capital asset proc.
Shows how the capital asset transaction was processed.
- 1 - Acquisition
- To be used on records concerning the main acquisition of capital assets. E.g. cars, or buildings.
- 2 - Addition
- To be used on records concerning additions. The definition of an "addition" is e.g. winter tyres for a car or marquises on a building. Additions can be given a lifetime, that differs from the main acquisition.
- 3 - Revaluation
- To be used on records meant to adjust the total value of a capital
asset. An example when a revaluation can be performed is when a very old real estate
has a much higher market value, than the book value.Note:Revaluation shall NOT be performed when a capital asset has a lower value than expected due to under-usage, in this case the lifetime, and consequently the periodic depreciations, shall be adjusted instead.Note:Revaluation of capital assets is in most countries surrounded by legal restrictions and shall be performed only after accurate consideration.
- 4 - Devaluation
- To be used on records meant to adjust the total value of a capital
asset. An example when a devaluation can be performed is when the value of a real
estate falls under the book value due to a financial crisis or another extraordinary
occurrence.Note:Devaluation shall NOT be performed when a capital asset has a higher value than expected due to over-usage, in this case the lifetime, and consequently the periodic depreciations, shall be adjusted instead.Note:Devaluation of capital assets might be surrounded by legal restrictions in your country and shall be performed only after accurate consideration.
- 5 - Sale
- To be used on records concerning sales of capital assets.
- 6 - Discarded
- To be used on records concerning discard of capital assets.
- 7 - (Not in use)
- Not in use.
- 8 - Back transfer
- Resets depreciation when capital assets are sold or discarded.
- 9 - Depreciation on investment
- 10 - Depreciation on addition
- 11 - Depreciation on revaluation
- 12 - Depreciation on devaluation
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Capital asset proc. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PropPrc | The database field name. |
| API identifier | capitalAssetProcessing | The API identifier used in GraphQL. |
| Number | 5429 |
Control status
Can be used by the user to give the record a freely definable status, for selecting during reporting / analysis routines.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Control status/Accounting trans. | Integer |
| SQL name | Ctrl | The database field name. |
| API identifier | controlStatus | The API identifier used in GraphQL. |
| Number | 5446 |
Cost %
Stores the rate on which the system has based the calculation of the tax amount.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Percent | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CstP | The database field name. |
| API identifier | costPercent | The API identifier used in GraphQL. |
| Number | 5793 |
Cost amount
Shows non-deductible received VAT amounts.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CstAm | The database field name. |
| API identifier | costAmountDomestic | The API identifier used in GraphQL. |
| Number | 5794 |
Country no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Country no. | Integer |
| SQL name | Ctry | The database field name. |
| API identifier | countryNo | The API identifier used in GraphQL. |
| Number | 17534 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Country | Country |
|
Credit
Defines that the amount is < 0.
The field can be used for selection of credit amounts. Eg for reporting and analysis purposes
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Boolean | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Cr | The database field name. |
| API identifier | credit | The API identifier used in GraphQL. |
| Number | 5431 |
Credit amount in currency
The absolute value of the Amount in currency. The field is updated only if the Amount in currency is negative.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Amount in currency | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditAmountInCurrency | The API identifier used in GraphQL. |
| Number | 14228 |
Credit amount in EURO
The absolute value of the Amount in EURO. The field is updated only if the Amount in EURO is negative.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Credit amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditAmountInEuro | The API identifier used in GraphQL. |
| Number | 14231 |
Credit entered amount
The credit amount originally entered on the voucher line.
The amount can be incl VAT if it refers to purchase of a capital asset.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Entered amount | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditEnteredAmountDomestic | The API identifier used in GraphQL. |
| Number | 5784 |
Credit posted amount
The credit amount posted.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Posted amount | Credit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | creditPostedAmountDomestic | The API identifier used in GraphQL. |
| Number | 5433 |
Cross-account no.
The cross account no that existed on the original voucher line.
If postings are made to both debit and credit accounts in the same voucher line, the Cross-account no. and Cross-account type fields indicate the customer, supplier, Capital assetor General ledger accountaccount relating to the other transaction generated from the voucher line.
If the Posting errors account from the Company information table has been used, because the original account is non-existent, the Cross-account no. and Cross-account type fields indicate instead the customer, supplier, Capital asset or General ledger account to which you attempted to post the voucher.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Account no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AgAcNo | The database field name. |
| API identifier | crossAccountNo | The API identifier used in GraphQL. |
| Number | 5445 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | CrossCustomer |
| ||
| Associate | CrossSupplier |
| ||
| General ledger account | CrossGeneralLedgerAccount |
| ||
| Capital asset | CrossCapitalAsset |
|
Cross-account type
The cross account no that existed on the original voucher line.
If postings are made to both debit and credit accounts in the same voucher line, the Cross-account no. and Cross-account type fields indicate the customer, supplier, Capital asset or General ledger account account relating to the other transaction.
If the Posting errors account from the Company information table has been used, because the original account is non-existent, the Cross-account no. and Cross-account type fields indicate instead the customer, supplier, Capital asset or General ledger account to which you attempted to post the voucher.
- 1 - Customer
- The account number refer to a customer.
- 2 - Supplier
- The account number refer to a supplier.
- 3 - General ledger account
- The account number refer to a general ledger account.
- 4 - Capital asset
- The account number refer to a capital asset.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Account type | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AgAcCl | The database field name. |
| API identifier | crossAccountType | The API identifier used in GraphQL. |
| Number | 5444 |
Curr. corr. amount
The product of the most recent Curr. corr. exch. rate and the amount.
The field originally contains the same value as the Outstanding amount, or the Posted amount field if the correction is run on General ledger transaction or Capital asset transaction.
Each time the Currency correction processing is run, the field will be updated with the product of Curr. corr. exch. rate and Outstanding amount in currency or the Amount in currency if the correction is run on General ledger transaction or Capital asset transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | CurCAm | The database field name. |
| API identifier | currencyCorrectionAmount | The API identifier used in GraphQL. |
| Number | 14233 |
Curr. corr. date
The date for the last run of the Currency correction processing.
If no exchange rate adjustment has been performed, the field shows the same value as the Value date field.
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 | CurCDt | The database field name. |
| API identifier | currencyCorrectionDate | The API identifier used in GraphQL. |
| Number | 14234 |
Curr. corr. exch. rate
The Curr. corr. exch. rate from the latest run of the currency correction processing.
The field is updated when you run the Transfer corrections to table processing from the Currency correction data table. If no exchange rate adjustment has ever been performed, the field shows the same value as the Exchange rate field, which is inherited from the voucher.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Exchange rate | Decimal |
| SQL name | CurCExRt | The database field name. |
| API identifier | currencyCorrectionExchangeRate | The API identifier used in GraphQL. |
| Number | 14232 |
Curr. corr. run no.
A unique number identifying the last run of the Currency correction processing.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | CurCRNo | The database field name. |
| API identifier | currencyCorrectionRunNo | The API identifier used in GraphQL. |
| Number | 14235 |
Currency no.
The records currency number.
The currency number is normally inherited from the voucher. If no currency number was entered on the voucher, the field will anyway be updated with the Currency no. from the Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Currency no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Cur | The database field name. |
| API identifier | currencyNo | The API identifier used in GraphQL. |
| Number | 14224 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | Currency |
|
Currency no. 2
The records currency no 2 number, which is inherited from the voucher.
| 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 | 14320 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | Currency2 |
|
Debit amount in currency
The value of the Amount in currency. The field is updated only if the Amount in currency is positive.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Amount in currency | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitAmountInCurrency | The API identifier used in GraphQL. |
| Number | 14227 |
Debit amount in EURO
The value of the Amount in EURO. The field is updated only if the Amount in EURO is positive.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Debit amount in currency | Euro |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitAmountInEuro | The API identifier used in GraphQL. |
| Number | 14230 |
Debit entered amount
The debit amount originally entered on the voucher line.
The amount can be incl VAT if it refers to sale of a capital asset.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Entered amount | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitEnteredAmountDomestic | The API identifier used in GraphQL. |
| Number | 5783 |
Debit posted amount
The debit amount posted.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Source column | Posted amount | Debit |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | debitPostedAmountDomestic | The API identifier used in GraphQL. |
| Number | 5432 |
Entered amount
Shows the amount you entered in the voucher line.
If the transaction line refers to a purchase or a sale of capital asset it can be incl VAT. Credit amounts will be shown with negative sign.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | EntAm | The database field name. |
| API identifier | enteredAmountDomestic | The API identifier used in GraphQL. |
| Number | 5782 |
Error message
Any errors detected during a batch update.
If several errors are detected, they are listed with a comma separating them.
- Illegal value date
- Unknown organisational unit 1
- Unknown organisational unit 2
- Unknown organisational unit 3
- Unknown organisational unit 4
- Unknown organisational unit 5
- Unknown organisational unit 6
- Unknown debit account, Cust. no., Account no. or Cap. asset no.
- Unknown credit account, Cust. no., Account no. or Cap. asset no.
- Unknown debit VAT code or VAT code
- Unknown credit VAT code or VAT code
- Unknown debit VAT rate
- Unknown credit VAT rate
- Unknown debit investment tax
- Unknown credit investment tax
- Unknown debit payment terms
- Unknown credit payment terms
- Unknown distribution key
- Illegal debit turnover cl. or Turnover class
- Illegal credit turnover cl. or Turnover class
- Missing credit turnover cl. or Turnover class
- The grace period for the debit has exceeded
- The grace period for the credit has exceeded
- Unknown organisational unit 7
- Unknown organisational unit 8
- Unknown organisational unit 9
- Unknown organisational unit 10
- Unknown organisational unit 11
- Unknown organisational unit 12
- Missing accounting period
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Error message | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Err | The database field name. |
| API identifier | errorMessage | The API identifier used in GraphQL. |
| Number | 5443 |
Exchange rate
The exchange rate for the currency.
Is updated from the Voucher table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Exchange rate | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ExRt | The database field name. |
| API identifier | exchangeRate | The API identifier used in GraphQL. |
| Number | 14225 |
Exchange rate 2
The exchange rate for currency 2.
Is updated from the Voucher table.
| 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 | 14321 |
Free 1
Additional numeric information about the transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free1 | The database field name. |
| API identifier | free1 | The API identifier used in GraphQL. |
| Number | 9169 |
Free 2
Additional numeric information about the transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free2 | The database field name. |
| API identifier | free2 | The API identifier used in GraphQL. |
| Number | 9170 |
Free 3
Additional numeric information about the transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free3 | The database field name. |
| API identifier | free3 | The API identifier used in GraphQL. |
| Number | 9171 |
Free 4
Additional numeric information about the transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | Free4 | The database field name. |
| API identifier | free4 | The API identifier used in GraphQL. |
| Number | 9172 |
GL account
The General ledger account in which the transaction has been accumulated.
- The Associate table for the specific associate.
- The Account no. series table.
- The Company information table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Account no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | GenAcNo | The database field name. |
| API identifier | generalLedgerAccountNo | The API identifier used in GraphQL. |
| Number | 5434 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | GeneralLedgerAccount |
|
Inv. tax rate
Not in use. (Relates to a former Norwegian tax, that has been removed.)
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Percent | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InvTxRt | The database field name. |
| API identifier | investmentTaxRate | The API identifier used in GraphQL. |
| Number | 5790 |
Invest. tax amount
Not in use. (Relates to a former Norwegian tax, that has been removed.)
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InvTxAm | The database field name. |
| API identifier | investmentTaxAmountDomestic | The API identifier used in GraphQL. |
| Number | 5787 |
Invoice no.
The invoice number from the Voucher.
If the Invoice no. field is empty on the Voucher, this field will be updated with the Voucher no. field instead. This requires that Affects turn./purch. is selected in the Voucher type table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Doc. no. | Text (40) |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | InvoNo | The database field name. |
| API identifier | invoiceNo | The API identifier used in GraphQL. |
| Number | 14299 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product transaction | ProductTransaction |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Product transaction before compression | ProductTransaction2 |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Last curr. corr. amount
The last recalculated amount from the Currency correction processing.
The field will equal the Amount field if no Currency correction processing has been performed.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | LastCAm | The database field name. |
| API identifier | lastCurrencyCorrectionAmount | The API identifier used in GraphQL. |
| Number | 14237 |
Memo file name
The file name for the Memo attached to the Customer transaction.
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 | 5447 |
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 | 19214 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Memo | Memo |
|
Order no.
Displays the order number for the purchase of the capital asset.
The number of the Order from which the transaction has its origin.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | OrdNo | The database field name. |
| API identifier | orderNo | The API identifier used in GraphQL. |
| Number | 6528 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Order | Order |
|
Organisational unit 1
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
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 | 5435 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 1 | OrgUnit1 |
|
Organisational unit 2
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
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 | 5436 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 2 | OrgUnit2 |
|
Organisational unit 3
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
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 | 5437 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 3 | OrgUnit3 |
|
Organisational unit 4
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
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 | 5438 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 4 | OrgUnit4 |
|
Organisational unit 5
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
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 | 5439 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 5 | OrgUnit5 |
|
Organisational unit 6
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
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 | 5440 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 6 | OrgUnit6 |
|
Organisational unit 7
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
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 | 9576 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 7 | OrgUnit7 |
|
Organisational unit 8
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
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 | 9577 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 8 | OrgUnit8 |
|
Organisational unit 9
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
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 | 9578 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 9 | OrgUnit9 |
|
Organisational unit 10
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
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 | 9579 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 10 | OrgUnit10 |
|
Organisational unit 11
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
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 | 9580 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 11 | OrgUnit11 |
|
Organisational unit 12
The organisational unit you entered in vouchers, possibly via the distribution key in vouchers.
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 | 9581 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 12 | OrgUnit12 |
|
Origin
Indicates whether the Voucher was entered manually or generated automatically.
The automatically generated transactions are labelled as to their origin (for example reminder, interest note or payment).
- 1 - Manually entered
- 2 - Automatically generated
- 13 - Automatic entry
- 3 - VAT report
- 41 - OSS VAT report
- 10 - Direct debiting
- 4 - Reminder
- 5 - Interest note
- 8 - OCR payment
- 21 - Write off payments
- 6 - Giro payment
- 7 - Direct payment
- 11 - Depreciation on capital assets
- 9 - Order processing
- 23 - Incoming invoice
- 12 - Import
- Normal text import.
- 14 - Previous batch
- 15 - Compressing transactions
- 16 - Posting of costs
- 18 - Internal invoicing
- 17 - Differences
- When you update a batch with this origin code debit/credit control is not carried out.
- 19 - EDI invoice import
- 20 - Payroll
- 22 - Visma Business Services
- 24 - Activate Capital asset
- 25 - Calculate client interest
- 26 - Document Center temporary batch
- 27 - Document Center finished batch
- 28 - Debt collector
- 29 - Split invoice
- 30 - Currency correction
- 31 - External application
- If this origin code is used, this value can be used by other applications that use BIG or SQL and create batches.
- 32 - Cash order document
- 33 - Sell or scrap capital asset
- 34 - Initializing capital asset
- 35 - EDI read dirdeb vouchers
- 37 - Accrual accounting
- 38 - Order processing with picking after invoicing
- 39 - Picked after invoicing
- 40 - Correction of costs
- 42 - Accounting document
- Batch was created from Accounting document table.
- 43 - Order match pre-registration
- 44 - Self billing invoice
- 45 - Split batch, supplier transactions
- Batch was created by Update supplier transactions processing for supplier transactions only.
- 46 - Split batch, cost transactions
- Batch was created by Update supplier transactions processing for cost and capital transactions to be adjusted after payment.
- 47 - Account statement vouchers
- Batch was created by Create voucher processing in the Account statement transaction table.
- 48 - WebFaktura
- 49 - Central
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Origin | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SrcTp | The database field name. |
| API identifier | origin | The API identifier used in GraphQL. |
| Number | 5441 |
Original run no.
The Order journal number from which the transaction origin.
The number can be used to trace the transactions generated from orders.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Journal no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | SrcJNo | The database field name. |
| API identifier | originalRunNo | The API identifier used in GraphQL. |
| Number | 5442 |
Original voucher no.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Voucher no. | Integer |
| SQL name | OrVoNo | The database field name. |
| API identifier | originalVoucherNo | The API identifier used in GraphQL. |
| Number | 18626 |
Period
Shows the accounting period to which the transaction was posted.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Period | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcPr | The database field name. |
| API identifier | period | The API identifier used in GraphQL. |
| Number | 5426 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Accounting period | AccountingPeriod |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Capital asset balance | CapitalAssetBalance |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Period batch no.
The period batch number and the value is retrieved from the Batch.
The period batch number is included in automatic entries. On normal transactions, the value is taken from the Batch unless it is given on vouchers.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | PrBt | The database field name. |
| API identifier | periodBatchNo | The API identifier used in GraphQL. |
| Number | 10551 |
Picture file name
the file name for the scanned image file for the vouchers.
| 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 | PictNo | The database field name. |
| API identifier | pictureFileName | The API identifier used in GraphQL. |
| Number | 9167 |
Posted amount
The amount actually posted on the capital asset account in credit.
The amount is always shown excl VAT
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcAm | The database field name. |
| API identifier | postedAmountDomestic | The API identifier used in GraphQL. |
| Number | 5430 |
Previous voucher no.
The original voucher number when you reverse transactions.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Voucher no. | Integer |
| SQL name | PrevVoNo | The database field name. |
| API identifier | previousVoucherNo | The API identifier used in GraphQL. |
| Number | 6258 |
Running total
Use this field for account statements to show a running total in the printout.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | runningTotalDomestic | The API identifier used in GraphQL. |
| Number | 11006 |
Running total in curr.
Use this field for account statements to show a running total in the printout.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| Memory field | Yes | The value in this field is only displayed in the program, it is not stored in the database. |
| API identifier | runningTotalInCurrency | The API identifier used in GraphQL. |
| Number | 14236 |
Scan doc. no.
The ID of the scanned document.
Is used in connection with Visma Document Center.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | PLDNo | The database field name. |
| API identifier | scanDocumentNo | The API identifier used in GraphQL. |
| Number | 11178 |
Scan status
The status of the scanned document.
Is used in connection with Visma Document Center.
- 1 - Scanned document
- 2 - Document on flow
- 4 - Document finished
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Scan status | Integer |
| SQL name | PLDFlow | The database field name. |
| API identifier | scanStatus | The API identifier used in GraphQL. |
| Number | 11179 |
Sup. no.
Supplier number that was entered on the voucher line.
If the original voucher line contained a supplier no in the Debit account field or in the Credit account field, the supplier no will be automatically entered and inherited to the capital asset transaction
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Sup. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Sup | The database field name. |
| API identifier | supplierNo | The API identifier used in GraphQL. |
| Number | 5767 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Supplier |
|
Text
The text of the transaction.
For automatically generated transactions Visma Business takes the Voucher type from the Voucher series for automatically generated transactions and the text field is filled in with the default text for this Voucher type.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Text | Text (200) |
| SQL name | Txt | The database field name. |
| API identifier | text | The API identifier used in GraphQL. |
| Number | 5428 |
Trans. status
Various transaction statuses, inherited from Voucher table.
Overwritten
- Amount excl. VAT
- When you complete the Amount excl. VAT field in the Voucher table, this check box is selected.
- VAT amount
- This field is checked if you have overridden the VAT amount in the voucher line.
- Org. unit
- If organisational units are overridden in the General ledger transaction table, Business NXT defines a value here that indicates that the organisational unit has been corrected after updating.
Debt collector
- Transferred to debt collector
- This field applies only to open customer entries and customer transactions. Business NXT updates the field when you run the Transfer to debt collection processing.
- Returned from debt collector
- This field applies only to open customer entries and customer transactions. Business NXT updates the field when you run the Return from debt collection processing.
- Added during debt collection
- This field applies only to open customer entries and customer transactions. Business NXT updates the field when you run the List debt collection related transactions processing.
Duration
- Permanent
- All regular transactions.
- Temporary
- Business NXT uses this field in connection with reversal of transactions.
- Reversing
- Business NXT uses this field in connection with reversal of transactions.
Accounting rule
- Created by an accounting rule
- The option is automatically enabled when a voucher line is created by
an accounting rule.The field is greyed out in the following tables:
- Customer transaction
- Supplier transaction
- General ledger transaction
- Capital asset transaction
- Open customer entry
- Open supplier entry
- Do not apply accounting rule
Per.
- Per. Debit acc.
- Per. Credit acc.
____
- Do not create open entries
- Business NXT does not produce open entries for the voucher line. This field overrides the
Matching method
parameter in the Company information table and
Matching method cust./Matching method sup.
in the Associate table. You can use this parameter, for example, when converting from other systems
in which you want to refer to earlier transactions. You can also increase the speed
when updating a batch if you define this flag for vouchers that you know are fully
matched.The field is greyed out in the following tables:
- Customer transaction
- Supplier transaction
- General ledger transaction
- Capital asset transaction
- Open customer entry
- Open supplier entry
- Ref. Entry Free of interest
- This comes from the order module and will exempt this entry and the cross-reference from interest computation in connection with updating.
- Ref. Entry Free of reminder fee
- If you in the Order table have selected the Ref. Entry Free of interest check box in Order options, this check box is selected. When you update the batch the post and the cross-references are exempted from interest calculation.
- Credit note
- Business NXT checks for credit note if the transaction is a credit entry for a customer or a
debit entry for a supplier. Business NXT assumes that you have checked the Affects turn./purch. box in the Voucher type
table for the relevant voucher type.
This field is used for customer transactions and supplier transactions, and is therefore greyed out in the voucher line.
- Authorised
- This field is checked if you have authorised a general ledger transaction. You can also check the field manually if the transaction has already been authorised.
- Factoring performed
- You only use this check box for open customer entries, and it is therefore greyed out in the voucher lines.
- Period flow processed
- Business NXT will select this field when you execute the Automatic entries processing in the General ledger account table.
- Paid
- Business NXT will select this field when you transfer the open entry to payment lines. You
cannot select the field manually.
Business NXT inserts a cross in this field when you save a cross reference line which has a cross in the Payment reg. field. When you delete a voucher line, transaction status Paid is deleted if you press Delete in the cross reference line or the voucher line, and not in the batch head.
- Partly paid in AutoPay
- Automatically set when an open customer/supplier entry is updated as a partial payment, i.e. when an approver has overridden the payment amount in Visma.net AutoPay.
- Cancelled/Rejected payment
- This check box is selected when a payment line is cancelled or rejected. The Paid and Payment no. fields are then deleted, so that you can create payment for the entry once more. This requires that the parameter Set to "Cancelled" for payments not transferred in the EFT processing field of the Bank partner table has been checked.
- Prepayment
- This check box is selected when OCR transactions are imported containing advance payment. The routine enters the order number in the voucher line. This requires that you have selected the parameter Prepayment in Payment processing in the Company information or Factoring company tables.
- Accept transactions with amount 0
- If you select this field in a voucher line, transactions are produced
even if both the amount and quantity are 0 (zero) in the voucher line.
In these voucher lines and updated voucher lines, 0 (zero) is shown instead of a blank Amount field (in default currency).
The Accept transactions with amount 0 field are greyed out when you open the dialog box in the Trans. status field from tables other than the Voucher table.
- Direct debit from order
- When posting invoices from the order system, Business NXT checks whether the customer has a direct debiting agreement, and whether the voucher date is within the applicable from and to dates for this. If so, the flag from Direct debit from order is placed in the Trans. status field in the voucher line. If this amount exceeds a maximum amount specified by the customer, the Exceeded max amount flag is inserted.
- Exceeded max amount
- When posting invoices from the order system, Business NXT checks whether the customer has a direct debiting agreement, and whether the voucher date is within the applicable from and to dates for this. If so, the flag from Direct debit from order is placed in the Trans. status field in the voucher line. If this amount exceeds a maximum amount specified by the customer, the Exceeded max amount flag is inserted.
- Do not update exchange rate from voucher date
- The voucher line’s exchange rate from the Currency rate or Currency rate 2 table will not be updated when you change the voucher date.
- Debt collection voucher lines already expanded
- Value date overridden
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Trans. status | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TransSt | The database field name. |
| API identifier | transactionStatus | The API identifier used in GraphQL. |
| Number | 6269 |
Turnover class
Shows the turnover class for the transaction.
On vouchers with general ledger entries for sales and purchases that are generated on the basis of orders, the turnover class is defined on the basis of the Transaction type, Trade area and Service type fields.
- 1 - Taxable sales
- Is used for sales of taxable products. I.e. when
- the Transaction type is 1 - Sales or 2 - Hire
- the Trade area is 0 - Taxable domestic according to VAT- and accounting inf./VAT code
- 2 - Non-taxable domestic sales
- Is used for sales of non-taxable products. I.e. when
- the Transaction type is 1 - Sales or 2 - Hire
- the Trade area is 1 - Non-taxable domestic
- 10 - Transfer of goods to EU countries
- Used when
- the Transaction type is 1 - Sales or 2 - Hire
- the Trade area is 4 - Subsidiary in another EU country
- Service type1 - Services is not selected
- 5 - Sale of goods to EU countries
- Used when
- the Transaction type is 1 - Sales or 2 - Hire
- the Trade area is 2 - Within other EU country
- Service type1 - Services is not selected
- 3 - Sale of goods outside EU/Abroad
- Used when
- the Transaction type is 1 - Sales or 2 - Hire
- the Trade area is 3 - Outside EU/Abroad
- Service type1 - Services is not selected
- 9 - Sale of services abroad
- Used when
- the Transaction type is 1 - Sales or 2 - Hire
- the Trade area is 2 - Within other EU country, 3 - Outside EU/Abroad or 4 - Subsidiary in another EU country
- Service type1 - Services is selected
- 13 - Non-taxable sales
- 16 - Sales outside tax area
- 18 - Sales, taxable for purchaser
- 20 - Agent sales to third party
- 22 - Sales of services to EU countries
- 26 - Rent income voluntary
- 27 - OSS union scheme services
- 28 - OSS union scheme goods
- 29 - OSS import scheme
- 4 - Taxable purchases
- Is used for purchases of taxable products. I.e. when
- the Transaction type is 6 - Purchase
- the Trade area is 0 - Taxable domestic according to VAT- and accounting inf./VAT code
- 7 - Non-taxable domestic purchases
- Is used for purchases of non-taxable products. I.e. when
- the Transaction type is 6 - Purchase
- the Trade area is 1 - Non-taxable domestic
- 15 - Domestic purchases with reversed VAT deduction
- 11 - Transfer of goods between other EU countries
- Used when
- the Transaction type is 6 - Purchase
- the Trade area is 5 - Transfer between other EU countries
- Service type1 - Services is not selected
- 6 - Purchase of goods from EU countries
- Used when
- the Transaction type is 6 - Purchase
- the Trade area is 2 - Within other EU country
- Service type1 - Services is not selected
- 8 - Purchase of goods outside EU/Abroad
- Used when
- the Transaction type is 6 - Purchase
- the Trade area is 3 - Outside EU/Abroad
- Service type1 - Services is not selected
- 12 - Purchase of services abroad
- Used when
- the Transaction type is 6 - Purchase
- the Trade area is 2 - Within other EU country or 5 - Transfer between other EU countries
- Service type1 - Services is selected
- 14 - Non-taxable purchases
- 17 - Purchase outside tax area
- 19 - Purchase, taxable by purchaser
- 21 - Purchase of services from EU countries
- 23 - Domestic purchase of services
- 24 - Taxable product consumption
- 25 - Domestic purchases with reversed VAT liability
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Turnover class | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TxCl | The database field name. |
| API identifier | turnoverClass | The API identifier used in GraphQL. |
| Number | 6676 |
Unit
The field is transferred from vouchers when Batch are updated.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Unit | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Un | The database field name. |
| API identifier | unit | The API identifier used in GraphQL. |
| Number | 10550 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Unit | Unit |
|
Updated batch no.
When batches are updated, a reference is filled in to transaction records produced from the batch.
The reference is important for the case when it is demanded to withdraw the record with the Create new voucher processing in the Updated voucher table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Batch no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | UpdBndNo | The database field name. |
| API identifier | updatedBatchNo | The API identifier used in GraphQL. |
| Number | 10958 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Updated batch | UpdatedBatch |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Updated voucher | UpdatedVoucher |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Updated voucher line no.
When batches are updated, a reference is filled in to vouchers from which the voucher is produced in this field.
The reference is important for the case when it is demanded to withdraw the record with the Create new voucher processing in the Updated voucher table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | UpdLnNo | The database field name. |
| API identifier | updatedVoucherLineNo | The API identifier used in GraphQL. |
| Number | 10959 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Updated voucher | UpdatedVoucher |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Value date
The value date for the voucher.
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 |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ValDt | The database field name. |
| API identifier | valueDate | The API identifier used in GraphQL. |
| Number | 5424 |
VAT amount
Is inherited from the Voucher line. If not entered on the voucher line, it will be inherited from the Batch.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VatAm | The database field name. |
| API identifier | vatAmountDomestic | The API identifier used in GraphQL. |
| Number | 5786 |
VAT amount in currency
Is inherited from the Voucher line. If not entered on the voucher line, it will be inherited from the Batch.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | CurVatAm | The database field name. |
| API identifier | vatAmountInCurrency | The API identifier used in GraphQL. |
| Number | 18153 |
VAT code
Displays the VAT code for the transaction.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | VAT code | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TxCd | The database field name. |
| API identifier | taxCode | The API identifier used in GraphQL. |
| Number | 5788 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| VAT code | TaxCode |
|
VAT period from voucher date
Shows the VAT period within which the voucher date falls and is in addition to the VAT term field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Period | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TxTrmVoD | The database field name. |
| API identifier | taxTermFromVoucherDate | The API identifier used in GraphQL. |
| Number | 8525 |
VAT rate
Stores the rate on which the system has based the calculation of the tax amount.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Percent | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VatRt | The database field name. |
| API identifier | vatRate | The API identifier used in GraphQL. |
| Number | 5789 |
VAT report no.
Not in use.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TxStNo | The database field name. |
| API identifier | taxStatementNo | The API identifier used in GraphQL. |
| Number | 8896 |
VAT term
Shows the VAT period to which the transaction belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Period | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TxTrm | The database field name. |
| API identifier | taxTerm | The API identifier used in GraphQL. |
| Number | 5781 |
VAT year
Shows the VAT year to which the transaction belongs.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Year | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TxYr | The database field name. |
| API identifier | taxYear | The API identifier used in GraphQL. |
| Number | 5780 |
VAT year from voucher date
Shows the VAT year within which the voucher date falls and is in addition to the VAT year field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Year | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | TxYrVoD | The database field name. |
| API identifier | taxYearFromVoucherDate | The API identifier used in GraphQL. |
| Number | 8524 |
Visma ID
The ID of the scanned document.
Is used in connection with Visma Document Center.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| SQL name | WfId | The database field name. |
| API identifier | vismaId | The API identifier used in GraphQL. |
| Number | 11177 |
Voucher date
The date of the voucher. If the field is missing, the voucher date is set equal to the Value date.
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 |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VoDt | The database field name. |
| API identifier | voucherDate | The API identifier used in GraphQL. |
| Number | 5423 |
Voucher group 1
The voucher group the transaction belongs to. It is inherited from the voucher line and can be defined in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Voucher group 1 | Integer |
| SQL name | VoGr1 | The database field name. |
| API identifier | voucherGroup1 | The API identifier used in GraphQL. |
| Number | 6160 |
Voucher group 2
The voucher group the transaction belongs to. It is inherited from the voucher line and can be defined in the Text table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Voucher group 2 | Integer |
| SQL name | VoGr2 | The database field name. |
| API identifier | voucherGroup2 | The API identifier used in GraphQL. |
| Number | 6161 |
Voucher jour. no.
A unique number identifying voucher journal number.
The same voucher journal number is allocated to customer, supplier, general ledger and capital asset transactions in each batch update. It is also allocated to the tables Updated batch, Updated voucher and Updated cross reference and is the major key to trace both the transactions origin and related transactions, such as automatically generated G/L transactions and VAT transactions.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Journal no. | Integer |
| Primary key | Yes | Voucher jour. no., Audit no. |
| SQL name | JNo | The database field name. |
| API identifier | voucherJournalNo | The API identifier used in GraphQL. |
| Number | 5419 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Updated journal | UpdateJournal |
| ||
| Updated batch | UpdatedBatch |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Updated voucher | UpdatedVoucher |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Voucher no.
The voucher number the transaction applies to. For automatically generated transactions, the voucher number is taken from the voucher series for automatically generated transactions.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Voucher no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VoNo | The database field name. |
| API identifier | voucherNo | The API identifier used in GraphQL. |
| Number | 5422 |
Voucher type
The voucher type for the transaction. For automatically generated transactions, the voucher type is taken from the Voucher series for automatically generated transactions.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Voucher type | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | VoTp | The database field name. |
| API identifier | voucherType | The API identifier used in GraphQL. |
| Number | 5427 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Voucher type | VoucherType |
|
Web page
If you want to link a special web page to one of your vouchers, you can enter the address here.
The value in the field is transferred from vouchers to Updated voucher and on to the transactions and open entries.
If you use the Design/Add/Visualise menu item, Visma Business uses what is in this field.
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 | WebPg | The database field name. |
| API identifier | webPage | The API identifier used in GraphQL. |
| Number | 9168 |
Withholding tax amount
Shows the withholding tax amount that the system has arrived at.
This type of tax is specific for the lithuanian market.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | WthAm | The database field name. |
| API identifier | withholdingTaxAmountDomestic | The API identifier used in GraphQL. |
| Number | 5792 |
Withholding tax rate
This type of tax is specific for the lithuanian market.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Percent | Decimal |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | WthRt | The database field name. |
| API identifier | withholdingTaxRate | The API identifier used in GraphQL. |
| Number | 5791 |
Workflow document ID
An identifier for a document, such as an invoice or a voucher, that is processed via Visma Business Workflow.
Workflow document ID is assigned when sending the document for approval. The identifier can be used to find the document for example in Visma.net Approval.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Workflow document ID | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | WfDocId | The database field name. |
| API identifier | workflowDocumentId | The API identifier used in GraphQL. |
| Number | 18978 |
Year
The relevant accounting year for the transactions. The year is deducted from the value date.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Year | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | AcYr | The database field name. |
| API identifier | year | The API identifier used in GraphQL. |
| Number | 5425 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Accounting period | AccountingPeriod |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Capital asset balance | CapitalAssetBalance |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
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. |