Location Labels

To create a label from a location record, or to get aisle-rack-plank-section from a label, you can should use the wms_format_location and wms_unformat_location functions. They use the location_format setting to find out how it should be done. By default, this is set to AA-RR-PP-SS. Consider the following example:

testdb=# select * from wms_setting where name='location_format';
 settingid |      name       |  value   
-----------+-----------------+----------
         8 | location_format | AA-RRPPS

testdb=# select locationid, aisle, rack, plank, section from wms_location;
 locationid | aisle | rack | plank | section 
------------+-------+------+-------+---------
         23 | AA    | 01   | 01    | A

testdb=# select wms_format_location(23);
 wms_format_location 
---------------------
 AA-0101A

testdb=# select wms_unformat_location('AA-0101A');
 wms_unformat_location 
-----------------------
 (AA,01,01,A)

StockControl Legacy Public

Location Labels

Analytics

Related content