Language

This table contains one row for each language.

The entries in this table can be referred to from many other tables. If no language has been specified, the value in the Language no. field Company information is used.

The following fields exist in this table:

Add descr.

The contents of the Product description table will replace the description in the order line when order documents are printed.

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

Language no.

A unique number identifying the Language.

Tip:

You can choose the numbers freely or you can use the international country numbers.

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	Yes	This field is visible by default in the table display.
Domain	Language no.	Integer
Primary key	Yes	Language no.
SQL name	LangNo	The database field name.
API identifier	languageNo	The API identifier used in GraphQL.
Number	561

Name

The name of the language.

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

Regional format

Setup for regional formats used on printouts.

When not defined for the relevant printout language, the setup in System information table will be used instead.

Different formatting rules for date, time and number fields in the user interface and on printouts can be set for different languages.

For printouts the formatting rules will be determined in the following order:

The Regional format in the Language table, from row with the actual Language no. from the document.
The Regional format in the Language table, from row with the actual Language no. from Company information table.
The Regional format in the System information table.
Values returned from the operating system on the machine producing the report (the "Region" format, taken e.g. from HKEY_CURRENT_USER\Control Panel\International).
The default values (indicated by "(default)" in the description below).

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

Date

Date format

Undefined: Value is not set.
Day Month Year: Date format ddmmyyyy (default).
Year Month Day: Date format yyyymmdd.
Month Day Year: Date format mmddyyyy.

Date separator

Undefined: Value is not set.
Period (.): Period as date separator, like format dd.mm.yyyy (default).
Hyphen (-): Hyphen as date separator, like format dd-mm-yyyy.
Slash (/): Slash as date separator, like format dd/mm/yyyy.

Leading zero for single digit day

Undefined: Value is not set.
Yes: Date format like 01.mm.yyyy.
No: Date format like 1.mm.yyyy.

Leading zero for single digit month

Undefined: Value is not set.
Yes: Date format like dd.01.yyyy.
No: Date format like dd.1.yyyy.

Include century in year

Undefined: Value is not set.
Yes: Date format like dd.mm.yyyy (default).
No: Date format like dd.mm.yy.

Time

Time format

Undefined: Value is not set.
24-hour clock: 24 hours clock (default).
12-hour clock: 12 hours clock, should be used in connection with Before noon designator and After noon designator.

Time separator

Undefined: Value is not set.
Colon (:): Time format mm:hh (default).
Period (.): Time format mm.hh.

Before noon designator

Undefined: Value is not set.
a.m.: Time format like 11:45 a.m. (default).
am: Time format like 11:45 am.
AM: Time format like 11:45 AM.

After noon designator

Undefined: Value is not set.
p.m.: Time format like 11:45 p.m. (default).
pm: Time format like 11:45 pm.
PM: Time format like 11:45 PM.

Leading zero for hours

Undefined: Value is not set.
Yes: Time format like 09:45 (default).
No: Time format like 9:45.

Number

Decimal separator

Undefined: Value is not set.
Comma (,): Number format like 100,25 (default).
Period (.): Number format like 100.25.

Thousands separator

Selected Thousands separator must be different than Decimal separator (when "Period" or "Comma" selected).

Undefined: Value is not set.
Space ( ): Number format like 10 000,00 (default).
Period (.): Number format like 10.000,00.
Comma (,): Number format like 10,000.00 (Decimal separator must be set to Period (.)).

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Regional format	Integer
SQL name	RgnFmt	The database field name.
API identifier	regionalFormat	The API identifier used in GraphQL.
Number	19167

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