Location

You can use locations to store and manage the stock at a more detailed level than on warehouse level. The Location table contains one row for each location, per warehouse.

If you also want to control the stock on individual product level, you can combine the Location table with the Item location table.

The Location table gives a more detailed description of where you have placed the products. Here you can set up how the physical warehouse is constructed. In the Location table you enter the measurements for the location and rules for how the location will be managed.

If you want locations to be pre-defined, select Use location control and Check location values against locations in the Reservation processing field in the Company information table.

Stock count

You can add rows to the Location table using the Transfer to stock count processing in the Stock balance table.

If the Stock take based on locations setting is enabled in the Reservation processing field in the Company information table, you can't use the Correct stock balances processing in the Stock balance table. Posts are created in the Item location table after Transfer to stock count, and the Correct stock balances processing needs to be performed in this table instead.

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

The following fields exist in this table:

Area

The area of the location. The value is calculated based on the values in the Length and Width fields.

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

Description

A complementary description/specification in addition to the description of the product.

You can also use this field to have both the original and translated description for the product, for example in English and Norwegian.

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

Height

The height of the location. The value is used to calculate the Volume.

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

Inf. 1

Additional location information.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Inf. @	Text (40)
SQL name	Inf	The database field name.
API identifier	information1	The API identifier used in GraphQL.
Number	11201

Inf. 2

Additional location information.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Inf. @	Text (40)
SQL name	Inf2	The database field name.
API identifier	information2	The API identifier used in GraphQL.
Number	11202

Inf. 3

Additional location information.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Inf. @	Text (40)
SQL name	Inf3	The database field name.
API identifier	information3	The API identifier used in GraphQL.
Number	11203

Inf. 4

Additional location information.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	Inf. @	Text (40)
SQL name	Inf4	The database field name.
API identifier	information4	The API identifier used in GraphQL.
Number	11204

Length

The length of the location. The value is used to calculate the Area and the Volume.

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

Location

The description of the product location.

You could enter whether the product is located in several places.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Location	Text (18)
Primary key	Yes	Warehouse no., Location
SQL name	Loc	The database field name.
API identifier	location	The API identifier used in GraphQL.
Number	11096

Location processing

Settings related to how the location should be managed.

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

During stock take: This Location is used during the Transfer to stock count processing.
Note:
You have to select Stock take based on locations. This is done in the Reservation processing field in the Company information table.
Suspended: This Location cannot be used.
One product at a time: You cannot add another Product on this Location, as long as there is a balance with a different Product no.
Note:
This requires that the Reservation processing options Use location control and Check location values against item locations are selected.
External processing: Selected for free use of external programs.
Quantity: The defined Quantity of the Product will be selected when several products are Finished in this Location, so that the Max quantity in base unit will not be exceeded. The Max quantity in base unit must be entered in the Item location table.
Weight: The defined Weight of the Location will be selected when several products are Finished in this Location, so that the maximum Weight will not be exceeded. The maximum Weight is entered in the Weight field in the Location table.
Volume: The defined Volume of the Product will be selected when several products are Finished in this Location, so that the maximum Volume will not be exceeded. The maximum Volume is entered in the Volume field in the Location table.
Blocked for picking: When set, the location will not be available for reservation or picking.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Location processing	Integer
SQL name	LocProc	The database field name.
API identifier	locationProcessing	The API identifier used in GraphQL.
Number	16061

Physical location

Where the product is physically located, for example the shelf number and row.

Using this field makes it easier to find the product.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Location	Text (18)
SQL name	PhysLoc	The database field name.
API identifier	physicalLocation	The API identifier used in GraphQL.
Number	11097

Volume

The volume that can be debited from this location. The value is calculated based on the values in the Length, Width and Height fields.

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

Warehouse no.

The warehouse the location is in.

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	Warehouse no.	Integer
Primary key	Yes	Warehouse no., Location
SQL name	StcNo	The database field name.
API identifier	warehouseNo	The API identifier used in GraphQL.
Number	16060

Table 1. Table relations
To table	Purpose	From columns	To columns	Comments
Warehouse	Warehouse	Warehouse no.	Warehouse no.

Weight

The weight that can be debited from this location.

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

Width

The width of the location. The value is used to calculate the Area and Volume.

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

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