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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Account group | Text (60) |
| SQL name | AcGr | The database field name. |
| API identifier | accountGroup | The API identifier used in GraphQL. |
| Number | 6511 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Account group | AccountGroup |
|
Account. year/period
This field is used by Visma Business Report Center.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Year/Per. | Integer |
| SQL name | AcYrPr | The database field name. |
| API identifier | accountingYearAndPeriod | The API identifier used in GraphQL. |
| Number | 11027 |
Budget line type
A type number.
You can use this field for selecting or sorting Budget records according to type.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Budget line type | Integer |
| SQL name | Gr | The database field name. |
| API identifier | budgetLineType | The API identifier used in GraphQL. |
| Number | 3305 |
Budget no.
A reference to a record in the Budget table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Budget no. | Integer |
| Primary key | Yes | Budget no., Line no. |
| SQL name | BgNo | The database field name. |
| API identifier | budgetNo | The API identifier used in GraphQL. |
| Number | 3274 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Budget | Budget |
|
Cap. asset no.
The Capital asset for which you want to budget.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Cap. asset no. | Integer |
| SQL name | PropNo | The database field name. |
| API identifier | capitalAssetNo | The API identifier used in GraphQL. |
| Number | 5557 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Capital asset | CapitalAsset |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| SQL name | CstPr | The database field name. |
| API identifier | costPriceInCurrency | The API identifier used in GraphQL. |
| Number | 3294 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | CrCurAm | The database field name. |
| API identifier | creditAmountInvoicedInCurrency | The API identifier used in GraphQL. |
| Number | 3349 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | CrInvoAm | The database field name. |
| API identifier | creditAmountInvoicedDomestic | The API identifier used in GraphQL. |
| Number | 3302 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | CrCurAm2 | The database field name. |
| API identifier | creditAmountInvoicedInCurrency2 | The API identifier used in GraphQL. |
| Number | 16059 |
Currency no.
If you want to calculate amounts in currency fields, there must be a value in this field.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Currency no. | Integer |
| SQL name | Cur | The database field name. |
| API identifier | currencyNo | The API identifier used in GraphQL. |
| Number | 3346 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | Currency |
|
Currency no. 2
If you want to calculate amounts in currency2 fields, there must be a value in this field.
| 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 | 16056 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Currency | Currency2 |
|
Cust. no.
You can split the budget line by customers.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Cust. no. | Integer |
| SQL name | CustNo | The database field name. |
| API identifier | customerNo | The API identifier used in GraphQL. |
| Number | 3280 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Customer |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Date | Integer |
| SQL name | Dt | The database field name. |
| API identifier | date | The API identifier used in GraphQL. |
| Number | 3276 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | DbCurAm | The database field name. |
| API identifier | debitAmountIncurredInCurrency | The API identifier used in GraphQL. |
| Number | 3348 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | DbIncCst | The database field name. |
| API identifier | debitAmountIncurredDomestic | The API identifier used in GraphQL. |
| Number | 3295 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Amount | Decimal |
| SQL name | DbCurAm2 | The database field name. |
| API identifier | debitAmountIncurredInCurrency2 | The API identifier used in GraphQL. |
| Number | 16058 |
Distribution key
The distribution key you want to use to distribute the record.
The distribution key is used in the Distribution processing menu item.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Distribution key | Integer |
| SQL name | DstK | The database field name. |
| API identifier | distributionKeyNo | The API identifier used in GraphQL. |
| Number | 8315 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Distribution key | DistributionKey |
|
Empl. no.
If you want to Budget on Employees.
The Empl. no. is a unique number identifying one specific Employee.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Empl. no. | Integer |
| SQL name | EmpNo | The database field name. |
| API identifier | employeeNo | The API identifier used in GraphQL. |
| Number | 3279 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Employee |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Exchange rate | Decimal |
| SQL name | ExRt | The database field name. |
| API identifier | exchangeRate | The API identifier used in GraphQL. |
| Number | 3347 |
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.
| 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 | 16057 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Account no. | Integer |
| SQL name | AcNo | The database field name. |
| API identifier | generalLedgerAccountNo | The API identifier used in GraphQL. |
| Number | 3384 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| General ledger account | GeneralLedgerAccount |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Gross profit | 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 | grossProfitInCurrency | The API identifier used in GraphQL. |
| Number | 3350 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Gross profit | 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 | grossProfitDomestic | The API identifier used in GraphQL. |
| Number | 3303 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | DbIncNo | The database field name. |
| API identifier | incurredQuantity | The API identifier used in GraphQL. |
| Number | 3292 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Quantity | Decimal |
| SQL name | CrInvoNo | The database field name. |
| API identifier | invoicedQuantity | The API identifier used in GraphQL. |
| Number | 3296 |
Line no.
Each line in the table is given a consecutive number in the order in which they are entered.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | No. | Integer |
| Primary key | Yes | Budget no., Line no. |
| SQL name | LnNo | The database field name. |
| API identifier | lineNo | The API identifier used in GraphQL. |
| Number | 3275 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Margin | 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 | margin | The API identifier used in GraphQL. |
| Number | 3304 |
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.
| 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 | 6435 |
Memo no.
Link to the memo for the entry.
The actual memo is stored in the Memo table.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is 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 | 19244 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Memo | Memo |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Order no. | Integer |
| SQL name | OrdNo | The database field name. |
| API identifier | orderNo | The API identifier used in GraphQL. |
| Number | 3277 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Order | Order |
|
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.
| 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 | 3282 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 1 | OrgUnit1 |
|
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.
| 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 | 3283 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 2 | OrgUnit2 |
|
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.
| 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 | 3284 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 3 | OrgUnit3 |
|
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.
| 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 | 3285 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 4 | OrgUnit4 |
|
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.
| 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 | 3286 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 5 | OrgUnit5 |
|
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.
| 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 | 3287 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 6 | OrgUnit6 |
|
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.
| 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 | 9618 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 7 | OrgUnit7 |
|
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.
| 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 | 9619 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 8 | OrgUnit8 |
|
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.
| 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 | 9620 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 9 | OrgUnit9 |
|
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.
| 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 | 9621 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 10 | OrgUnit10 |
|
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.
| 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 | 9622 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 11 | OrgUnit11 |
|
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.
| 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 | 9623 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Organisational unit 12 | OrgUnit12 |
|
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.
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Period | Integer |
| SQL name | Pr | The database field name. |
| API identifier | period | The API identifier used in GraphQL. |
| Number | 3383 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | Yes | This field is visible by default in the table display. |
| Domain | Period key | Integer |
| SQL name | PrK | The database field name. |
| API identifier | periodKeyNo | The API identifier used in GraphQL. |
| Number | 8316 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Period key | PeriodKey |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Product no. | Text (40) |
| SQL name | ProdNo | The database field name. |
| API identifier | productNo | The API identifier used in GraphQL. |
| Number | 3278 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Product | Product |
| ||
| Search product | SearchProduct |
|
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Price | Decimal |
| SQL name | SalePr | The database field name. |
| API identifier | salesPriceInCurrency | The API identifier used in GraphQL. |
| Number | 3297 |
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Sort seq. no. | Integer |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Srt | The database field name. |
| API identifier | sortSequenceNo | The API identifier used in GraphQL. |
| Number | 3306 |
Sup. no.
You can use this field if you want to budget on suppliers.
A reference to the Sup. no. in the Associate table.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Sup. no. | Integer |
| SQL name | SupNo | The database field name. |
| API identifier | supplierNo | The API identifier used in GraphQL. |
| Number | 3281 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Associate | Supplier |
|
Text
This is a pure free text field used for storing comments or additional information relating to the record.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not 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 | 3541 |
Unit
In this field you enter the relevant unit.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Unit | Integer |
| SQL name | Un | The database field name. |
| API identifier | unit | The API identifier used in GraphQL. |
| Number | 3288 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Unit | 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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Week | Integer |
| SQL name | Wk | The database field name. |
| API identifier | week | The API identifier used in GraphQL. |
| Number | 6588 |
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.
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.
| Property | Value | Description |
|---|---|---|
| Visible by default | No | This field is not visible by default in the table display. |
| Domain | Year | Integer |
| SQL name | Yr | The database field name. |
| API identifier | year | The API identifier used in GraphQL. |
| Number | 3382 |
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.
| 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 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. |