P&L and balance sheet definition line

This table contains one row for each line in a profit and loss and balance sheet definition.

Property	Value	Description
Database	Company	This table is in the company databases.
SQL name	DfLn	The table name in the database.
API identifier	profitAndLossAccountAndBalanceSheetDefinitionLine	The API identifier used in GraphQL.
Table no.	78	The table number in the data model.

The following fields exist in this table:

Account lines

Settings defining the behaviour of the profit and loss and balance sheet definition line.

A look-up opens the dialog box where you can see the following check boxes and options:

Grouping

None: All lines will be printed.
Specified: If the Specify accounts check box is selected in the advanced report parameter dialog (to the Profit and loss account and balance sheet report in the General ledger account table), lines may be included for general ledger accounts belonging to the actual account group, assumed that the Formula field contains a single account group. This will normally apply to detail lines, not sum lines.
Exempt if not specified: If the Specify accounts check box is not selected in the advanced report parameter dialog (to the Profit and loss account and balance sheet report in the General ledger account table), the line should not be printed.
Omit sum if no values: The line will not be printed if all amounts are 0.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account lines	Integer
SQL name	AcLn	The database field name.
API identifier	accountLines	The API identifier used in GraphQL.
Number	1962

Bal./PL def. no.

The definition number of the P&L and balance sheet definition.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	No.	Integer
Primary key	Yes	Bal./PL def. no., Line no.
SQL name	DfNo	The database field name.
API identifier	definitionNo	The API identifier used in GraphQL.
Number	1708

Table 1. Table relations
To table	Purpose	From columns	To columns	Comments
P&L and balance sheet definition	ProfitAndLossAccountAndBalanceSheetDefinition	Bal./PL def. no.	Bal./PL def. no.

Font

The font for the line in the report.

The field shows the font family, style and size within square brackets. In the database there are three separate fields for font family, font style and font size. The field shown on the screen keeps the font size in the database.

Is normally set with the Font command (in the Design group in the Home tab).

The font size may be set as a percentage (e.g. 120) of the normal font size, cf. the Relative option in the Type drop-down list in the dialog box.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Font	Integer
SQL name	FSz	The database field name.
API identifier	fontSize	The API identifier used in GraphQL.
Number	1715

Formula

The formula for which figures are presented on the line in the report.

Syntax

The formulas may include:

account groups
account numbers, prefixed with #
account number ranges, prefixed with # and having a double dot between the from and to account no. (e.g. #4000..4999)
macro functions, prefixed with @
numbers (integers or floating point numbers)
arithmetical operators (+, -, *, /)
parentheses (in an unlimited number of levels)

If the name of an account group is surrounded by @( and ), it may contain arithmetical operator characters.

Macro Functions

The following macro functions may be used:

@SystemInteger, @SystemDecimal and @SystemText: System dependent variables.
@FirmInteger, @FirmDecimal and @FirmText: Company dependent variables.

They all take a variable name as parameter, and optionally an element number. Element numbers should be in the interval 1 - 12 for integer and decimal variables, and 1 - 2 for text variables. Element numbers default to 1 if they are omitted. The namespace for the variables are stated in a separate field in the table.

Evaluation order

Parentheses are evaluated first. Then multiplication and division have higher priority than addition and subtraction. Operators at the same level are evaluated from left to right.

Error handling

After you have entered a formula, the program displays an error message if:

the number of opening and closing parentheses is not the same (or if, for any positions from left to right, there are more closing parentheses than opening parentheses)
there is a syntax error, including account groups which do not exist (the program shows the part of the expression in which an error has been detected, on the status bar)

On reports, the following error codes may be shown:

(?: Parentheses mismatch.
?: Syntax error.
#?: Unknown account number.
/0: Division by zero.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Formula	Text (500)
SQL name	AcGr	The database field name.
API identifier	formula	The API identifier used in GraphQL.
Number	1711

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
Account group	AccountGroup	Formula	Account group

Indentations

The number of indentations the program should insert at the beginning of the line in the report.

Each indentation is 3 spaces.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	No.	Integer
SQL name	IndLvl	The database field name.
API identifier	indentations	The API identifier used in GraphQL.
Number	16364

Inf. 1

A free text to be included on the line in the report.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	String of length 20	Text (20)
SQL name	FreeTxt1	The database field name.
API identifier	inf1	The API identifier used in GraphQL.
Number	13033

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.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	No.	Integer
Primary key	Yes	Bal./PL def. no., Line no.
SQL name	LnNo	The database field name.
API identifier	lineNo	The API identifier used in GraphQL.
Number	1709

Namespace

The namespace for variables used in macro functions in the formula.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	GUID	Text (40)
SQL name	NmSp	The database field name.
API identifier	namespace	The API identifier used in GraphQL.
Number	10779

P&L and balance sheet definition line processing

A look-up opens the dialog box where you can see the following check boxes and options:

Do not show notes

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	P&L and balance sheet definition line processing	Integer
SQL name	DfLnPrc	The database field name.
API identifier	definitionLineProcessing	The API identifier used in GraphQL.
Number	17590

Sort seq. no.

The order of the lines.

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	2097

Swap sign

Swaps the sign of amounts on the line in the report.

May make the printouts easier to read, depending on the text and grouping of figures. Originally, debit amounts are positive and credit amounts negative.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Boolean	Integer
SQL name	Sgn	The database field name.
API identifier	swapSign	The API identifier used in GraphQL.
Number	1712

Text

The text to be shown on the line in the report.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Name	Text (80)
SQL name	Txt	The database field name.
API identifier	text	The API identifier used in GraphQL.
Number	1710

View % of turnover

The closing balance will be shown in percent of the turnover on the line in the report.

The Include in turnover field in the General ledger account table indicates what accounts that make up the turnover.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Boolean	Integer
SQL name	PTrn	The database field name.
API identifier	viewPercentOfTurnover	The API identifier used in GraphQL.
Number	1713

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.

Note:

If you double-click or press * in this field, you can look up a value in the related table.

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.

Table 3. Table relations
To table	Purpose	From columns	To columns	Comments
Active company process	CompanyProcess	Process no.	Process no.