Product category

This table contains one row for each product category and can be used to group products hierarchically.

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

The following fields exist in this table:

Description

The description of the Product category.

Descriptions may be overwritten for different languages in the Text table.

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	8457

e-Bus. Access gr.

An access group defined in Visma e-Business.

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

Main category no.

The parent Product category, if the Product categories are arranged in a hierarchy.

Product category texts for different languages can be defined in the Text table. These texts has text type 145.

Note:

If you double-click or press * in this field, you can look up a Product category in the Text 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	Product category	Integer
SQL name	MainPrC	The database field name.
API identifier	mainCategoryNo	The API identifier used in GraphQL.
Number	8458

Table 1. Table relations
To table	Purpose	From columns	To columns	Comments
Product category	MainCategory	Main category no.	Product category

Memo file name

The file name for the Memo attached to the Product category.

The field is intended for use in the Zpider solution.

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.

Property	Value	Description
Visible by default	Yes	This field is 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	11980

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.

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	19235

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
Memo	Memo	Memo no.	Memo no.

Picture file name

A link to the picture file for the Product category.

The field is intended for use in the Zpider solution.

Tip:

Double-clicking or pressing * in this box opens the picture. If the box is empty, a dialog box for selecting a picture file will open.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Picture file name	Text (260)
SQL name	PictFNm	The database field name.
API identifier	pictureFileName	The API identifier used in GraphQL.
Number	11981

Product category

A unique number identifying the Product category.

Product category texts for different languages can be defined in the Text table. These texts has text type 145.

Note:

If you double-click or press * in this field, you can look up a Product category in the Text table.

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	Product category	Integer
Primary key	Yes	Product category
SQL name	PrCatNo	The database field name.
API identifier	productCategoryNo	The API identifier used in GraphQL.
Number	8456

Text

Free text.

The field is intended for use in the Zpider solution.

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

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.