Unit

This table contains one row for each unit. You can enter descriptions of the various units in which you buy and sell products.

You can also define how many items the unit consists of, e.g. to convert from boxes to units in the order lines. For fields that are also present in the Product table, the value in the Unit table overrides the corresponding field in the Product table and suggested on the order line if it is not overridden by the field in the Barcode table.

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

The following fields exist in this table:

Area

The area of the unit used to specify the stock for the product.

The value overrides the corresponding field in the Product table, and is suggested on the order line if it is not overridden by the field in the Barcode table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Quantity	Decimal
SQL name	AreaU	The database field name.
API identifier	area	The API identifier used in GraphQL.
Number	5919

Density

The density of the unit used to specify the stock for the product.

The value overrides the corresponding field in the Product table, and is suggested on the order line if it is not overridden by the field in the Barcode table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Quantity	Decimal
SQL name	DensU	The database field name.
API identifier	density	The API identifier used in GraphQL.
Number	6263

Description

The description of the unit.

If texts on printouts are used, they need to be defined in the Text table. The numbers are replaced by text in the language of the customer or supplier.

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	5590

EDI unit

The code used for the units in EDI and with Visma.net AutoInvoice.

If the value of the EDI unit occurs several times in the Unit table then always the first occurrence registered in the table is going to be retrieved on EDI import. It should not necessarily be the lowest number. In an EDI export the correct EDI unit is exported because there is a reference to the particular unit.

Note:

In electronic invoicing and order exchange with Visma.net AutoInvoice unit code is mandatory. If unit code is not set, the default value will be ZZ.

See also Unit code under InvoiceLine - Invoice line information for more information.

For example KGM for kilos, LTR for litres, PCE for units or MTK for m².

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	String of length 3	Text (3)
SQL name	EDIUn	The database field name.
API identifier	ediUnit	The API identifier used in GraphQL.
Number	3068

Factor 3

Instead of entering a quantity directly in the Order line table, you can have it calculated as the difference between the To and From fields or as the product of them and the Factor 3 field.

When the quantity is calculated as the difference between the To and From fields, it can be expressed as a quantity, time or date, depending on the quantity format selected in the Proc. method 1 field in the Order line table. If the Factor 3 field does not have any value in the Order line table, the value in this field will be imported.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Quantity	Decimal
SQL name	Factor3	The database field name.
API identifier	factor3	The API identifier used in GraphQL.
Number	15257

Gross weight

The value is calculated based on the values in the Net weight and Tare fields.

The value overrides the corresponding field in the Product table, and is suggested on the order line if it is not overridden by the field in the Barcode table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Quantity	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	grossWeight	The API identifier used in GraphQL.
Number	5915

Height

The height of the unit used to specify the stock for the product.

The value overrides the corresponding field in the Product table, and is suggested on the order line if it is not overridden by the field in the Barcode table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Quantity	Decimal
SQL name	HgtU	The database field name.
API identifier	height	The API identifier used in GraphQL.
Number	5918

Length

The length of the unit used to specify the stock for the product.

The value overrides the corresponding field in the Product table, and is suggested on the order line if it is not overridden by the field in the Barcode table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Quantity	Decimal
SQL name	LgtU	The database field name.
API identifier	length	The API identifier used in GraphQL.
Number	5916

Net weight

The net weight of the unit used to specify the stock for the product.

The value overrides the corresponding field in the Product table, and is suggested on the order line if it is not overridden by the field in the Barcode table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Quantity	Decimal
SQL name	NWgtU	The database field name.
API identifier	netWeight	The API identifier used in GraphQL.
Number	5913

Price qty.

The number of units the price is valid for.

If the Price qty. field is blank in the Order line table, it is updated with the value in this field. There is no control when you enter a value in this field, but the price quantity is not imported from the Barcode or Unit table if the product has been placed in stock.

Note:

You cannot change the value in thePrice qty. field for a product that has a stock balance. This would affect the cost price calculation.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Quantity	Decimal
SQL name	PrNo	The database field name.
API identifier	priceQuantity	The API identifier used in GraphQL.
Number	15256

Quantity per unit

The quantity per unit of the unit used to specify the stock for the product.

The value overrides the corresponding field in the Product table, and is suggested on the order line if it is not overridden by the field in the Barcode table.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Quantity	Decimal
SQL name	StUnRt	The database field name.
API identifier	quantityPerUnit	The API identifier used in GraphQL.
Number	5591

Stock measure

The type of measurement for the unit.

The value overrides the corresponding field in the Product table, and is suggested on the order line if it is not overridden by the field in the Barcode table.

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

1 - Quantity in base unit
2 - Length
3 - Area
4 - Volume
5 - Net weight

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Stock measure	Integer
SQL name	Measure	The database field name.
API identifier	stockMeasure	The API identifier used in GraphQL.
Number	5957

Tare

The packaging weight of the unit used to specify the stock for the product.

The value overrides the corresponding field in the Product table, and is suggested on the order line if it is not overridden by the field in the Barcode table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Quantity	Decimal
SQL name	TareU	The database field name.
API identifier	tare	The API identifier used in GraphQL.
Number	5914

Unit

A unique number identifying the Unit.

Unit texts for different languages can be defined in the Text table. These texts has text type 16.

Note:

If you double-click or press * in this field, you can look up a Unit 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	Unit	Integer
Primary key	Yes	Unit
SQL name	Un	The database field name.
API identifier	unit	The API identifier used in GraphQL.
Number	5589

Volume

The volume of the unit used to specify the stock for the product.

The value overrides the corresponding field in the Product table, and is suggested on the order line if it is not overridden by the field in the Barcode table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Quantity	Decimal
SQL name	VolU	The database field name.
API identifier	volume	The API identifier used in GraphQL.
Number	5920

Width

The width of the unit used to specify the stock for the product.

The value overrides the corresponding field in the Product table, and is suggested on the order line if it is not overridden by the field in the Barcode table.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Quantity	Decimal
SQL name	WdtU	The database field name.
API identifier	width	The API identifier used in GraphQL.
Number	5917

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