Budget line

This table contains one row for each line on a budget.

The following fields exist in this table:

Account group

In this field you can add an Account group to the Budget line.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAccount groupText (60)
SQL nameAcGrThe database field name.
API identifieraccountGroupThe API identifier used in GraphQL.
Number6511 
Table 1. Table relations
To tablePurposeFrom columnsTo columnsComments
Account groupAccountGroup
  • Account group

Account. year/period

This field is used by Visma Business Report Center.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainYear/Per.Integer
SQL nameAcYrPrThe database field name.
API identifieraccountingYearAndPeriodThe API identifier used in GraphQL.
Number11027 

Budget line type

A type number.

You can use this field for selecting or sorting Budget records according to type.

Budget line type texts for different languages can be defined in the Text table. These texts has text type 22.
Note:
If you double-click or press * in this field, you can look up a Budget line type in the Text table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainBudget line typeInteger
SQL nameGrThe database field name.
API identifierbudgetLineTypeThe API identifier used in GraphQL.
Number3305 

Budget no.

A reference to a record in the Budget table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainBudget no.Integer
Primary keyYesBudget no., Line no.
SQL nameBgNoThe database field name.
API identifierbudgetNoThe API identifier used in GraphQL.
Number3274 
Table 2. Table relations
To tablePurposeFrom columnsTo columnsComments
BudgetBudget
  • Budget no.

Cap. asset no.

The Capital asset for which you want to budget.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainCap. asset no.Integer
SQL namePropNoThe database field name.
API identifiercapitalAssetNoThe API identifier used in GraphQL.
Number5557 
Table 3. Table relations
To tablePurposeFrom columnsTo columnsComments
Capital assetCapitalAsset
  • Cap. asset no.

Cost price

The debit amounts/costs.

The Credit amount (invoiced) (dom.) field is suggested as the product of the Cost price field and Incurred quantity field. The currency for these fields is entered in the Currency no. field on the same record.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPriceDecimal
SQL nameCstPrThe database field name.
API identifiercostPriceInCurrencyThe API identifier used in GraphQL.
Number3294 

Credit amount (invoiced)

Use this field to specify a Credit amount (invoiced).

The Incurred quantity, Sales price, Credit amount (invoiced) (dom.) and Credit amount (invoiced) fields can be used to enter amounts/revenue. Credit amount (invoiced) (dom.) field is suggested as the product of the Sales price field and Invoiced quantity field. The currency for the value in the Sales price field is entrered in the Currency no. field on the same record.

A look-up in this column opens the calculator.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL nameCrCurAmThe database field name.
API identifiercreditAmountInvoicedInCurrencyThe API identifier used in GraphQL.
Number3349 

Credit amount (invoiced) (dom.)

The credit amount in domestic currency.

The Credit amount (invoiced) field updated if the value in this field is updated. This field will be updated if you the Credit amount (invoiced) field is updated. The values will be calculated from based on the value in the Exchange rate field.

A look-up in this column opens the calculator.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
SQL nameCrInvoAmThe database field name.
API identifiercreditAmountInvoicedDomesticThe API identifier used in GraphQL.
Number3302 

Credit amount (invoiced) in currency 2

Is calculated from Credit amount (invoiced) or Credit amount (invoiced) (dom.) fields if Currency no. 2 added on the record.

If you have access to it, you can override the value directly in the field. It is this field that is used for the Profit and loss account and balance sheet raport when you select to run it against currency 2.

A look-up in this column opens the calculator.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL nameCrCurAm2The database field name.
API identifiercreditAmountInvoicedInCurrency2The API identifier used in GraphQL.
Number16059 

Currency no.

If you want to calculate amounts in currency fields, there must be a value in this field.

If this field is empty, then it will be updated when you enter a value in Cust. no., Sup. no., Cap. asset no. or in the GL account field (if Currency no. is set on the reference).
Also when this field is updated, the Exchange rate field is updated based on the Sales rate field from the Currency table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainCurrency no.Integer
SQL nameCurThe database field name.
API identifiercurrencyNoThe API identifier used in GraphQL.
Number3346 
Table 4. Table relations
To tablePurposeFrom columnsTo columnsComments
CurrencyCurrency
  • Currency no.

Currency no. 2

If you want to calculate amounts in currency2 fields, there must be a value in this field.

If this field is empty, then it will be updated when you enter a value in Cust. no., Sup. no., Cap. asset no. or in the GL account field (if Currency no. 2 is set on the reference).
Also when this field is updated, the Exchange rate 2 field is updated based on the Sales rate field from the Currency table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainCurrency no.Integer
SQL nameCur2The database field name.
API identifiercurrencyNo2The API identifier used in GraphQL.
Number16056 
Table 5. Table relations
To tablePurposeFrom columnsTo columnsComments
CurrencyCurrency2
  • Currency no. 2

Cust. no.

You can split the budget line by customers.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainCust. no.Integer
SQL nameCustNoThe database field name.
API identifiercustomerNoThe API identifier used in GraphQL.
Number3280 
Table 6. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateCustomer
  • Cust. no.

Date

Is filled in with To date from Accounting period for the Year/Period you fill in on the Budget line.

This date is used as lookup for the rate for Currency no. 2.

You can narrow down a date for the Budget line in the Date and Week fields. You register in accordance with that which is the default for your regional settings in Windows.

The date is validated using the regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainDateInteger
SQL nameDtThe database field name.
API identifierdateThe API identifier used in GraphQL.
Number3276 

Debit amount (incurred)

Use these fields to specify debit amount/cost.

The Debit amount (incurred) (dom.) field is suggested as the product of the values in the Cost price and the Incurred quantity field. The cost price is expressed in the currency in the Budget line.

A look-up in this column opens the calculator.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL nameDbCurAmThe database field name.
API identifierdebitAmountIncurredInCurrencyThe API identifier used in GraphQL.
Number3348 

Debit amount (incurred) (dom.)

Use this field to specify debit amount.

The Debit amount (incurred) field in the default currency is calculated on the basis of the Exchange rate.

A look-up in this column opens the calculator.

PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainAmountDecimal
SQL nameDbIncCstThe database field name.
API identifierdebitAmountIncurredDomesticThe API identifier used in GraphQL.
Number3295 

Debit amount (incurred) in currency 2

Calculated from the value in the Debit amount (incurred) field or the Debit amount (incurred) (dom.) field when Currency no. 2 is used.

If you have access to it, you can override the value directly in the field. It is this field that is used for the Profit and loss account and balance sheet report when you select to run it against Currency no. 2.

A look-up in this column opens the calculator.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainAmountDecimal
SQL nameDbCurAm2The database field name.
API identifierdebitAmountIncurredInCurrency2The API identifier used in GraphQL.
Number16058 

Distribution key

The distribution key you want to use to distribute the record.

The distribution key is used in the Distribution processing menu item.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainDistribution keyInteger
SQL nameDstKThe database field name.
API identifierdistributionKeyNoThe API identifier used in GraphQL.
Number8315 
Table 7. Table relations
To tablePurposeFrom columnsTo columnsComments
Distribution keyDistributionKey
  • Distribution key

Empl. no.

If you want to Budget on Employees.

The Empl. no. is a unique number identifying one specific Employee.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainEmpl. no.Integer
SQL nameEmpNoThe database field name.
API identifieremployeeNoThe API identifier used in GraphQL.
Number3279 
Table 8. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateEmployee
  • Empl. no.

Exchange rate

This field is calculated based on the Currency no. field. The rate will be retrieved from the Currency rate table depending on the date in the Date field in this table.

If you want to enter prices and amounts in currency, you must complete this field.

Note:
The rate is first retrieved from the Currency rate table, but is again calculated after the Amount in currency is rounded, therefore the rates can vary.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainExchange rateDecimal
SQL nameExRtThe database field name.
API identifierexchangeRateThe API identifier used in GraphQL.
Number3347 

Exchange rate 2

This field is calculated based on the Currency no. 2 field. The rate will be retrieved from the Currency rate 2 table depending on the date in the Date field in this table.

If you want to enter prices and amounts in currency 2, you must complete this field.

Note:
The rate is first retrieved from the Currency rate 2 table, but is again calculated after the Amount in currency 2 is rounded, therefore the rates can vary.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainExchange rateDecimal
SQL nameExRt2The database field name.
API identifierexchangeRate2The API identifier used in GraphQL.
Number16057 

GL account

Specify a General ledger account number for the record.

When you enter an account number, the account name is displayed in the status bar so that you can check that you have entered the correct number.

All Budget line records with references to a General ledger account are accumulated for the account concerned and for the associated account group, and you can use these figures for comparison when generating Profit and loss account and balance sheet reports.

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

Gross profit

The gross profit in currency.

The gross profit is the difference between invoiceable amount (credit amount) and incurred costs (debit amount). Gross profit is calculated for the Transaction type = 1 - Sales.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainGross profitDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiergrossProfitInCurrencyThe API identifier used in GraphQL.
Number3350 

Gross profit (dom.)

The gross profit in domestic currency.

The gross profit is the difference between invoiceable amount (credit amount) and incurred costs (debit amount). Gross profit is calculated for the Transaction type = 1 - Sales.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainGross profitDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiergrossProfitDomesticThe API identifier used in GraphQL.
Number3303 

Incurred quantity

You can use this field to enter debit amounts/costs.

The value in the Debit amount (incurred) (dom.) field is suggested as the product of the values in the Cost price and Incurred quantity fields.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
SQL nameDbIncNoThe database field name.
API identifierincurredQuantityThe API identifier used in GraphQL.
Number3292 

Invoiced quantity

You can use this field to enter credit amounts or revenue.

The Invoiced quantity, Sales price, Credit amount (invoiced) (dom.) and Credit amount (invoiced) fields can be used to enter amounts/revenue. Credit amount (invoiced) (dom.) field is suggested as the product of the value in the Sales price and Invoiced quantity fields.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainQuantityDecimal
SQL nameCrInvoNoThe database field name.
API identifierinvoicedQuantityThe API identifier used in GraphQL.
Number3296 

Line no.

Each line in the table is given a consecutive number in the order in which they are entered.

Note:
The Line no. does not change when inserting new lines between existing ones. The Sort seq. no. specifies the order of the lines and is affected when new lines are inserted between existing lines.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainNo.Integer
Primary keyYesBudget no., Line no.
SQL nameLnNoThe database field name.
API identifierlineNoThe API identifier used in GraphQL.
Number3275 

Margin

Shows the contribution rate for the record.

The contribution rate is calculated by dividing the value in the Gross profit field by the value in the Credit amount (invoiced) field, both in default currency. The contribution rate shows what proportion of revenue is left over once costs have been covered.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainMarginDecimal
Write AccessNoneYou are not allowed to modify the value in this field.
Memory fieldYesThe value in this field is only displayed in the program, it is not stored in the database.
API identifiermarginThe API identifier used in GraphQL.
Number3304 

Memo file name

Refers to a text file. If you select the Memo processing or use the Memo icon, you call up a free text editing field.

Here you can create a new memo file or edit an existing file. If you want to create a new memo file, a memo number and a file name is suggested if you have not specified these yourself. The file name is created from the parameters in the dialog box for the Change counters processing in the Company information table.

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.

Note:
It is important that you save the file on a server and in a folder that is available to all users, otherwise users who try to open the memo will receive an error message.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainMemo file nameText (260)
SQL nameNoteNmThe database field name.
API identifiermemoFileNameThe API identifier used in GraphQL.
Number6435 

Memo no.

Link to the memo for the entry.

The actual memo is stored in the Memo table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainMemo no.Integer
SQL nameMemoNoThe database field name.
API identifiermemoNoThe API identifier used in GraphQL.
Number19244 
Table 10. Table relations
To tablePurposeFrom columnsTo columnsComments
MemoMemo
  • Memo no.

Order no.

Use this field if you want to budget on expected orders.

By specifying an order number you are able to budget on the basis of future expected large orders.

If you want to add up Budget amounts in accounts for use in Profit and loss account and balance sheet reports, you must enter a value in the GL account field. All budget lines with references to the same GL account (for different orders) will be added up to a global budget total for the General ledger account.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainOrder no.Integer
SQL nameOrdNoThe database field name.
API identifierorderNoThe API identifier used in GraphQL.
Number3277 
Table 11. Table relations
To tablePurposeFrom columnsTo columnsComments
OrderOrder
  • Order no.

Organisational unit 1

The field is used to specify organisational unit.

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.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR1The database field name.
API identifierorgUnit1The API identifier used in GraphQL.
Number3282 
Table 12. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 1OrgUnit1
  • Organisational unit 1

Organisational unit 2

The field is used to specify organisational unit.

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.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR2The database field name.
API identifierorgUnit2The API identifier used in GraphQL.
Number3283 
Table 13. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 2OrgUnit2
  • Organisational unit 2

Organisational unit 3

The field is used to specify organisational unit.

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.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR3The database field name.
API identifierorgUnit3The API identifier used in GraphQL.
Number3284 
Table 14. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 3OrgUnit3
  • Organisational unit 3

Organisational unit 4

The field is used to specify organisational unit.

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.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR4The database field name.
API identifierorgUnit4The API identifier used in GraphQL.
Number3285 
Table 15. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 4OrgUnit4
  • Organisational unit 4

Organisational unit 5

The field is used to specify organisational unit.

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.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR5The database field name.
API identifierorgUnit5The API identifier used in GraphQL.
Number3286 
Table 16. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 5OrgUnit5
  • Organisational unit 5

Organisational unit 6

The field is used to specify organisational unit.

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.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainOrganisational unit no.Integer
SQL nameR6The database field name.
API identifierorgUnit6The API identifier used in GraphQL.
Number3287 
Table 17. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 6OrgUnit6
  • Organisational unit 6

Organisational unit 7

The field is used to specify organisational unit.

The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainLong alphanumeric organisational unit no.Text (40)
SQL nameR7The database field name.
API identifierorgUnit7The API identifier used in GraphQL.
Number9618 
Table 18. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 7OrgUnit7
  • Organisational unit 7

Organisational unit 8

The field is used to specify organisational unit.

The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR8The database field name.
API identifierorgUnit8The API identifier used in GraphQL.
Number9619 
Table 19. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 8OrgUnit8
  • Organisational unit 8

Organisational unit 9

The field is used to specify organisational unit.

The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR9The database field name.
API identifierorgUnit9The API identifier used in GraphQL.
Number9620 
Table 20. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 9OrgUnit9
  • Organisational unit 9

Organisational unit 10

The field is used to specify organisational unit.

The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR10The database field name.
API identifierorgUnit10The API identifier used in GraphQL.
Number9621 
Table 21. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 10OrgUnit10
  • Organisational unit 10

Organisational unit 11

The field is used to specify organisational unit.

The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR11The database field name.
API identifierorgUnit11The API identifier used in GraphQL.
Number9622 
Table 22. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 11OrgUnit11
  • Organisational unit 11

Organisational unit 12

The field is used to specify organisational unit.

The field appear with the name assigned to it in the Company information table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainShort alphanumeric organisational unit no.Text (10)
SQL nameR12The database field name.
API identifierorgUnit12The API identifier used in GraphQL.
Number9623 
Table 23. Table relations
To tablePurposeFrom columnsTo columnsComments
Organisational unit 12OrgUnit12
  • Organisational unit 12

Period

Specify the period for the record.

Accounting data can be stored for several years, so you need to specify the year as well as the period numbers. The year refers to the financial year the record applies to.

The budgeting periods must already have been created in the Accounting period table.

These fields can only contain numbers. You only need to enter the last two numbers of the year. If you type + or / in the fields, the same year/period as in the record above is suggested. The cursor moves to the next field, so that you do not have to press Enter.

Note:
You should not change periods in the Accounting period table for which you have started updating vouchers.

You can distribute a Budget record over periods, either using the Distribution processing, as user-defined period keys, or by entering the budget records per period yourself.

Note:
If you enter the records directly in the periods, these will be in addition to the entries that are distributed using the Period key.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainPeriodInteger
SQL namePrThe database field name.
API identifierperiodThe API identifier used in GraphQL.
Number3383 
Table 24. Table relations
To tablePurposeFrom columnsTo columnsComments
Accounting periodAccountingPeriod
  • Year
  • Period
This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Period key

Use this field if you what to distribute the record over more then one period.

This Period key is used in the Distribution processing menu item. You define the Period key in the Period key table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultYesThis field is visible by default in the table display.
DomainPeriod keyInteger
SQL namePrKThe database field name.
API identifierperiodKeyNoThe API identifier used in GraphQL.
Number8316 
Table 25. Table relations
To tablePurposeFrom columnsTo columnsComments
Period keyPeriodKey
  • Period key

Product no.

You can use this field if you want to budget on a product.

By specifying a value in the Product no. field, you can budget on the basis of special products with potentially large sales.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainProduct no.Text (40)
SQL nameProdNoThe database field name.
API identifierproductNoThe API identifier used in GraphQL.
Number3278 
Table 26. Table relations
To tablePurposeFrom columnsTo columnsComments
ProductProduct
  • Product no.
Search productSearchProduct
  • Product no.

Sales price

You can use this field to enter credit amounts or revenue.

The Incurred quantity, Sales price, Credit amount (invoiced) (dom.) and Credit amount (invoiced) fields can be used to enter amounts/revenue. Credit amount (invoiced) is suggested as the product of the values in the Sales price and Invoiced quantity fields.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainPriceDecimal
SQL nameSalePrThe database field name.
API identifiersalesPriceInCurrencyThe API identifier used in GraphQL.
Number3297 

Sort seq. no.

The order of the lines.

In the Editing group, select Insert before (Ctrl+I) or Insert after (Shift+Ctrl+I) to insert rows between existing ones. Then all the existing subsequent lines will get an updated number.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainSort seq. no.Integer
Write AccessNoneYou are not allowed to modify the value in this field.
SQL nameSrtThe database field name.
API identifiersortSequenceNoThe API identifier used in GraphQL.
Number3306 

Sup. no.

You can use this field if you want to budget on suppliers.

A reference to the Sup. no. in the Associate table.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainSup. no.Integer
SQL nameSupNoThe database field name.
API identifiersupplierNoThe API identifier used in GraphQL.
Number3281 
Table 27. Table relations
To tablePurposeFrom columnsTo columnsComments
AssociateSupplier
  • Sup. no.

Text

This is a pure free text field used for storing comments or additional information relating to the record.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainTextText (200)
SQL nameTxtThe database field name.
API identifiertextThe API identifier used in GraphQL.
Number3541 

Unit

In this field you enter the relevant unit.

Unit texts for different languages can be defined in the Text table. These texts has text type 16.
Note:
If you double-click or press * in this field, you can look up a Unit in the Text table.
Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainUnitInteger
SQL nameUnThe database field name.
API identifierunitThe API identifier used in GraphQL.
Number3288 
Table 28. Table relations
To tablePurposeFrom columnsTo columnsComments
UnitUnit
  • Unit

Week

The week number is suggested when a date is entered.

You can narrow down a date for the record in the Date and Week fields. You enter the date using the format defined in regional settings in Windows.

PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainWeekInteger
SQL nameWkThe database field name.
API identifierweekThe API identifier used in GraphQL.
Number6588 

Year

Specify the year for the record.

Accounting data can be stored for several years, so you need to specify the year as well as the period numbers. The year refers to the financial year the record applies to.

The budgeting periods must already have been created in the Accounting period table.

These fields can only contain numbers. You only need to enter the last two numbers of the year. If you type + or / in the fields, the same year/period as in the record above is suggested. The cursor moves to the next field, so that you do not have to press Enter.

Note:
You should not change periods in the Accounting period table for which you have started updating vouchers.

You can distribute a Budget record over periods, either using the Distribution processing, as user-defined period keys, or by entering the budget records per period yourself.

Note:
If you enter the records directly in the periods, these will be in addition to the entries that are distributed using the Period key.
Note:
These fields are only used by the Profit and loss account and balance sheet report, apart from those who create windows with selection and sorting by Budget line.

Note:
If you double-click or press * in this field, you can look up a value in the related table.
PropertyValueDescription
Visible by defaultNoThis field is not visible by default in the table display.
DomainYearInteger
SQL nameYrThe database field name.
API identifieryearThe API identifier used in GraphQL.
Number3382 
Table 29. Table relations
To tablePurposeFrom columnsTo columnsComments
Accounting periodAccountingPeriod
  • Year
  • Period
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 user

The name of the user that changed the record.

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

Changed date

The date when the record was changed.

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

Changed time

The time when the record was changed.

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

Changed time stamp

The date and time when the record was changed.

The field is updated with the UTC time.

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

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

Created by user

The name of the user that created the record.

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

Created date

The date when the record was created.

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

Created time

The time when the record was created.

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

Created time stamp

The date and time when the record was created.

The field is updated with the UTC time.

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

Edit status

The current status of the record.

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

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

1 - Inserted: The record is new.

2 - Changed: The record is changed.

3 - Deleted: The record is deleted.

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

Process no

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

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