Content Comparison

...

Warehouse Management is mainly done using the Client . As a user of level administrator, you can edit the structure of the warehouse:

• the static structure Static Structure are all the objects that do not change in day-to-day operation, such as zones and locations.

• the dynamic structure Dynamic Structure are the objects that do change, such as stock, carriers and carriersorders.

Static Structure

StockControl has a certain way of structuring the warehouse.

...

Identification

To identify different objects, StockControl often uses barcodes. Each barcode used in the system has to be unique and adhere to a certain pattern. Based on that pattern, the system can decide what kind of object it is dealing with.

Object Types

Status
colour Yellow title Developer

All known barcode patterns are stored in the wms_object_type table. This table stores the regular expression that defines the barcode pattern and configures how a certain object can be found in the system.

testdb=# select * from wms_object_type;
 typeid |    name    | properties | labelpattern |  relation   | wherecolumn | idcolumn  |  type   
--------+------------+------------+--------------+-------------+-------------+-----------+---------
      3 | ordercrate |            | ^[0-9]{8}$   | wms_carrier | label       | carrierid | carrier

Consider the above example, the system will try to find an object when the code 10002000 is scanned by running the following query:

SELECT carrierid FROM wms_carrier WHERE :barcode ~ labelpattern

The result will then be an object of type carrier with the carrierid received from the database.