Item location balance
This table shows quantity, weight and dimensions for each location, per product/warehouse combination. The table is defined as a view in the database.
| Property | Value | Description |
|---|---|---|
| Database | Company | This table is a view in the company databases. |
| View name | ItemLocBal | This table is a view and only displayed in the program, it is not stored in the database. |
| API identifier | itemLocationBalance | The API identifier used in GraphQL. |
| Table no. | 370 | The table number in the data model. |
The following fields exist in this table:
Area
The Area value from the Location table.
| 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. |
| SQL name | Area | The database field name. |
| API identifier | area | The API identifier used in GraphQL. |
| Number | 16157 |
Free quantity
The difference between Max quantity in base unit and Used quantity values.
| 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. |
| SQL name | FreeQty | The database field name. |
| API identifier | freeQuantity | The API identifier used in GraphQL. |
| Number | 16163 |
Height
The Height value from the Location table.
| 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. |
| SQL name | Hgt | The database field name. |
| API identifier | height | The API identifier used in GraphQL. |
| Number | 16156 |
Item location processing
Settings defining the behaviour of the item location.
The value is retrieved from the Item location table.
- 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 |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ItmLocProc | The database field name. |
| API identifier | itemLocationProcessing | The API identifier used in GraphQL. |
| Number | 16174 |
Length
The Length value from the Location table.
| 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. |
| SQL name | Lgt | The database field name. |
| API identifier | length | The API identifier used in GraphQL. |
| Number | 16154 |
Location
The location to which a product and a warehouse will be assigned.
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 |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | Loc | The database field name. |
| API identifier | location | The API identifier used in GraphQL. |
| Number | 16152 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Item location | ItemLocation |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Order line | OrderLineStockLocation |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Order line | OrderLineProductStockLocation |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Location balance | LocationBalanceStockLocation |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Location | Location |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Location processing
Settings defining the behaviour of location.
The value is retrieved from the Location table.
- 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 |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | LocProc | The database field name. |
| API identifier | locationProcessing | The API identifier used in GraphQL. |
| Number | 16153 |
Max quantity in base unit
How much can be debited from this location.
The value is retrieved from the Item location table.
| 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. |
| SQL name | MaxQtyUn | The database field name. |
| API identifier | maxQuantityInBaseUnit | The API identifier used in GraphQL. |
| Number | 16164 |
Product no.
The product to which a warehouse and a location will be assigned.
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 |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | ProdNo | The database field name. |
| API identifier | productNo | The API identifier used in GraphQL. |
| Number | 16150 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Item location | ItemLocation |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Product | Product |
| ||
| Product | ProductWarehouse |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Order line | OrderLineProductStock |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Order line | OrderLineProductToStock |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Order line | OrderLineProductStockLocation |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Used quantity
The total quantity based on Physical stock value from the Shipment table.
| 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. |
| SQL name | UsdQty | The database field name. |
| API identifier | usedQuantity | The API identifier used in GraphQL. |
| Number | 16162 |
Used volume
The total volume based on the Physical stock value from the Shipment table and the Volume value from the Product table.
| 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. |
| SQL name | UsdVol | The database field name. |
| API identifier | usedVolume | The API identifier used in GraphQL. |
| Number | 16159 |
Used weight
The total net weight based on the Physical stock value from the Shipment table and the Net weight value from the Product table.
| 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. |
| SQL name | UsdWgt | The database field name. |
| API identifier | usedWeight | The API identifier used in GraphQL. |
| Number | 16161 |
Volume
The Volume value from the Location table.
| 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. |
| SQL name | Volume | The database field name. |
| API identifier | volume | The API identifier used in GraphQL. |
| Number | 16158 |
Warehouse no.
The warehouse to which a product and a location will be assigned.
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 |
| Write Access | None | You are not allowed to modify the value in this field. |
| SQL name | StcNo | The database field name. |
| API identifier | warehouseNo | The API identifier used in GraphQL. |
| Number | 16151 |
| To table | Purpose | From columns | To columns | Comments |
|---|---|---|---|---|
| Item location | ItemLocation |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Product | ProductWarehouse |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Order line | OrderLineProductStock |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Order line | OrderLineProductToStock |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Order line | OrderLineStockLocation |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Order line | OrderLineProductStockLocation |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Location balance | LocationBalanceStockLocation |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. | |
| Location | Location |
| This is a combined foreign key. Making a lookup in one of the fields may also fill in value in the others. |
Weight
The Weight value from the Location table.
| 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. |
| SQL name | Wgt | The database field name. |
| API identifier | weight | The API identifier used in GraphQL. |
| Number | 16160 |
Width
The Width value from the Location table.
| 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. |
| SQL name | Wdt | The database field name. |
| API identifier | width | The API identifier used in GraphQL. |
| Number | 16155 |