Warehouse Management & Structure
- Bart Friederichs
Introduction
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 are all the objects that do not change in day-to-day operation, such as zones and locations.
the Dynamic Structure are the objects that do change, such as stock, carriers and orders.
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 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 | carrierConsider 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 ~ labelpatternThe result will then be an object of type carrier with the carrierid received from the database.
You are allowed to use expressions in the wherecolumn, e.g. TRIM(label).
The code will construct a query from this data using string manipulation. Be sure that you know what you are doing when filling this table!