Account no. series

This table is used to define the account type for intervals of account numbers.

When you enter vouchers, you don't need to fill in the Debit account type and Credit account type fields, as long as these account number intervals are defined in the Account no. series table, since the account type can be derived from the account number (in the Debit account and Credit account field, respectively).

Each account type may have several account number intervals.

The following fields exist in this table:

Account series processing

Setting that specifies whether the system will check that the number series you enter falls within series specified for another account type.

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

Exclude from lookup

The current Account no. series will be excluded from lookup when entering a new:

Cust. no.
Sup. no.
Account no.
Cap. asset no.
Empl. no.
Res. no.

Note:

To get a lookup dialog in the Cust. no. column you need to have Use account series on customer numbers selected in the Accounting processing column in the Company information table.
To get a lookup dialog in the Sup. no. column you need to have Use account series on supplier numbers selected in the Accounting processing column in the Company information table.
To get a lookup dialog in the Cap. asset no. column you need to have Use account series on capital assets no. selected in the Accounting processing column in the Company information table.
To get a lookup dialog in the Empl. no. column you need to have Use employee account series selected in the CRM processing column in the Company information table.
To get a lookup dialog in the Res. no. column you need to have Use resource account series selected in the CRM processing column in the Company information table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account series processing	Integer
SQL name	AcIntProc	The database field name.
API identifier	accountSeriesProcessing	The API identifier used in GraphQL.
Number	12833

Account type

The account type the number series is valid for.

It is possible to define several ranges for each Account type. You can define a separate number series for i.e. 5 - Employee. This does not apply to the Account type field in other tables.

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

1 - Customer
2 - Supplier
3 - General ledger account
4 - Capital asset
5 - Employee
6 - Resource

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account type	Integer
SQL name	AcCl	The database field name.
API identifier	accountType	The API identifier used in GraphQL.
Number	3414

Client responsible account 1

The GL account to update for this account range of the account type.

The GL account that you enter here will be overridden with the GL account from the Associate table. If you do not enter a GL account here neither in the Associate table, the GL account will be retrieved from the Company information table.

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	Account no.	Integer
SQL name	ClReAcNo	The database field name.
API identifier	clientResponsibleAccountNo1	The API identifier used in GraphQL.
Number	8444

Table 1. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	ClientResponsibleAccount1	Client responsible account 1	Account no.

Client responsible account 2

The GL account to update for this account range of the account type.

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	Account no.	Integer
SQL name	ClBaAcNo	The database field name.
API identifier	clientResponsibleAccountNo2	The API identifier used in GraphQL.
Number	8445

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	ClientResponsibleAccount2	Client responsible account 2	Account no.

Client responsible account 3

The GL account to update for this account range of the account type.

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	Account no.	Integer
SQL name	Cl3AcNo	The database field name.
API identifier	clientResponsibleAccountNo3	The API identifier used in GraphQL.
Number	12265

Table 3. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	ClientResponsibleAccount3	Client responsible account 3	Account no.

Description

The description of the account no. series.

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

Expense account

The GL account to update for this account range of the account type.

The GL account that you enter here is overridden if there is a GL account in the Associate table. If you do not enter a GL account here, neither in the Associate table, the GL account will be retrieved from the Company information table.

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	Account no.	Integer
SQL name	OlAcNo	The database field name.
API identifier	outlayAccountNo	The API identifier used in GraphQL.
Number	8443

Table 4. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	OutlayAccount	Expense account	Account no.

From no.

The from account no. in the account no. range.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account no.	Integer
SQL name	FromNo	The database field name.
API identifier	fromNo	The API identifier used in GraphQL.
Number	3412

GL account

The GL account to update.

This applies to account no. ranges where the Account type value is 1 - Customer, 2 - Supplier or 4 - Capital asset.

The GL account that you enter here is overridden if there is a GL account in the Associate and Capital asset tables. If you do not enter a GL account here, neither in the Associate table, the GL account will be retrieved from the Company information table. This applies to account types 1 - Customer and 2 - Supplier.

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	Account no.	Integer
SQL name	GenAcNo	The database field name.
API identifier	generalLedgerAccountNo	The API identifier used in GraphQL.
Number	3415

Table 5. Table relations
To table	Purpose	From columns	To columns	Comments
General ledger account	GeneralLedgerAccount	GL account	Account no.

Primary key

A unique number identifying the account no. series.

Note:

If you press + in this field, the next available number is suggested. Gaps in the number series resulting from any deleted rows are not suggested. If you enter an existing number you will receive an error message. The number cannot be changed once it is entered.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Account number series no.	Integer
Primary key	Yes	Primary key
SQL name	PK	The database field name.
API identifier	primaryKey	The API identifier used in GraphQL.
Number	12831

To no.

The to account no. in the account no. range.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Account no.	Integer
SQL name	ToNo	The database field name.
API identifier	toNo	The API identifier used in GraphQL.
Number	3413

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.

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 6. Table relations
To table	Purpose	From columns	To columns	Comments
Active company process	CompanyProcess	Process no.	Process no.