Item location

You define prioritised locations for products in the relevant warehouses in the Item location table. The Item location table contains one row for each location, per product/warehouse combination. You use the Location table in combination with the Item location table.

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

In the Location table you enter the measurements for the location and rules for how the location will be managed in the Location processing field, while in the Item location table you enter Max quantity in base unit and special rules in the Item location processing field, that only applies to this product. To check the measurements and quantity, select Check location balance in the Reservation processing field in the Company information table.

Please notice that checking on quantity, weight and volume require that you have defined the Item location table for control and lookup, and that an item location for each product is defined.

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

The following fields exist in this table:

Count date

The date on which the stock take of the product was performed.

The field is updated with the date you enter in the dialog box for the Transfer to stock count processing. You can override this value.

When you correct the stock level, this value is used in the Trans. date field in the Product transaction table. This makes it possible to select transactions by date. You can also select the same date in the Value date box in the Post cost processing dialog box, so that all transactions and posting fall within the desired period.

The date is validated using the regional settings in Windows.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Date	Integer
SQL name	LstCntDt	The database field name.
API identifier	countDate	The API identifier used in GraphQL.
Number	16080

Count difference

The difference between the values in the Counted quantity and Countable quantity fields.

Property	Value	Description
Visible by default	Yes	This field is 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	countDifference	The API identifier used in GraphQL.
Number	16078

Count group

You can use this field to group the products in the warehouse so that, for example, you can select them in connection with stock takes.

Stock count group texts for different languages can be defined in the Text table. These texts has text type 23.

Note:

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

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Stock count group	Integer
SQL name	CntGr	The database field name.
API identifier	countGroup	The API identifier used in GraphQL.
Number	16079

Count week

The week in which the stock take of the product was performed.

This value is calculated from the value in the Count date field.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Week	Integer
Memory field	Yes	The value in this field is only displayed in the program, it is not stored in the database.
API identifier	countWeek	The API identifier used in GraphQL.
Number	16081

Countable quantity

Shows the countable quantity of the product at a given location and warehouse. Value is filled in after you run the Transfer to stock count processing.

The following differences are deducted from the physical stock to attain this value;

The total difference between the quantities in the Finished and Invoiced/realised fields on the Order line where
- the Transaction type field has the value 1 - Sales or 2 - Hire, and the Finished field has a value greater than 0.
- the Transaction type field has the value 6 - Purchase, and the Finished field has a value less than 0.

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

Counted by

The name of the person who performed the stock take.

Property	Value	Description
Visible by default	Yes	This field is 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	CntBy	The database field name.
API identifier	countedBy	The API identifier used in GraphQL.
Number	16082

Counted quantity

The quantity of the product counted at the stock take.

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

Info. positioning

Information about the positioning of the item.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Trans. information @	Text (22)
SQL name	LocInf1	The database field name.
API identifier	informationPositioning	The API identifier used in GraphQL.
Number	8599

Item 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 Item 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 Item location cannot be used.

Property	Value	Description
Visible by default	Yes	This field is visible by default in the table display.
Domain	Item location processing	Integer
SQL name	ItmLocProc	The database field name.
API identifier	itemLocationProcessing	The API identifier used in GraphQL.
Number	16076

Location

The item's location, for example a shelf number and rack number.

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	Location	Text (18)
Primary key	Yes	Product no., Warehouse no., Location
SQL name	Loc	The database field name.
API identifier	location	The API identifier used in GraphQL.
Number	2804

Table 1. Table relations
To table	Purpose	From columns	To columns	Comments
Location	Location	Warehouse no. Location	Warehouse no. Location	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

Max quantity in base unit

The max quantity in base unit for this product at this location.

Used when you want to calculate how much 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	MaxQtyUn	The database field name.
API identifier	maxQuantityInBaseUnit	The API identifier used in GraphQL.
Number	16075

Priority

The priority of the rows.

The value is allocated automatically.

Property	Value	Description
Visible by default	No	This field is not visible by default in the table display.
Domain	No.	Integer
SQL name	Srt	The database field name.
API identifier	priority	The API identifier used in GraphQL.
Number	2805

Product no.

The product for this location.

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 no.	Text (40)
Primary key	Yes	Product no., Warehouse no., Location
SQL name	ProdNo	The database field name.
API identifier	productNo	The API identifier used in GraphQL.
Number	2801

Table 2. Table relations
To table	Purpose	From columns	To columns	Comments
Product	Product	Product no.	Product no.
Search product	SearchProduct	Product no.	Product no.

Warehouse no.

The warehouse of the product.

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	Product no., Warehouse no., Location
SQL name	StcNo	The database field name.
API identifier	warehouseNo	The API identifier used in GraphQL.
Number	2802

Table 3. Table relations
To table	Purpose	From columns	To columns	Comments
Warehouse	Warehouse	Warehouse no.	Warehouse no.
Location	Location	Warehouse no. Location	Warehouse no. Location	This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others.

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