A virtual inventory method and device for materials on an elevated warehouse

Abstract

The present application discloses a virtual inventory method and device for materials on an elevated warehouse. The virtual inventory method includes: establishing a virtual query system for materials based on the material storage information on the elevated warehouse, where the virtual query system includes data units in multiple dimensions; querying at least two data units according to query conditions to obtain a virtual inventory result; and outputting the virtual inventory result. By converting the material storage information into virtual data units and using the virtual query system to implement data query, the present application realizes the intelligent inventory of materials, effectively reduces the labor intensity of the existing material inventory, greatly reduces the time required for the current inventory, and makes the inventory business tend to be routine.

Description

Technical Field

[0001] This application relates to the field of logistics technology, and more specifically, to a virtual inventory method and device for materials on an elevated warehouse. Background Art

[0002] An elevated warehouse, that is, a stereoscopic warehouse, has remarkable characteristics, such as fast goods access speed, large storage capacity, high space utilization rate, etc., and has become a key link in logistics. It is widely used in various manufacturing enterprises, mainly including fields such as medicine, tobacco, food, manufacturing, coal industry, military supply departments, airports, and ports. The elevated warehouse belongs to logistics equipment, and its associated equipment types are numerous and the process is complex. During operation, failures are inevitable. If not handled properly, there will be a situation where the information and the materials are inconsistent, resulting in the re-entry, emptying of the inventory elevated warehouse, or the long-term retention of materials.

[0003] With the increase in the scale of automated stereoscopic warehouses, deeper demands have gradually emerged. For example, an important function in the warehousing management system such as "material inventory" becomes inadequate in the automated stereoscopic warehouse system. Problems such as how to confirm whether the physical inventory in the warehouse at a certain time point is consistent with the information, and whether the goods in the warehouse can be reconciled with the information in the database have become very important and practical issues.

[0004] Under the current circumstances, inventory basically depends on the accounts at the time of warehousing. When actual inspection is required, only by using a stacker to take out the pallet for manual inspection, or by taking the risk of entering the roadway for on-site inspection, or by installing radio frequency identification (RFID) on the pallet and obtaining the information of a specific pallet through the radio frequency reading device installed on the load platform of the stacker can physical inventory be achieved.

[0005] Currently, the academic and business communities have invested a lot of energy in inventory and achieved fruitful research results. However, the research on database virtual inventory is relatively weak. However, in the overall inventory of the logistics information system, the database is often the most worthy of research because many pallet information and storage location status are stored in the database. The traditional warehousing management system database is only used for the access of logistics data, and the potential of the data to play a role has far from been explored, and it cannot effectively support the material inventory behavior, especially the intelligent inventory needs of warehouse management personnel (such as determining whether the goods in a specified storage location are the same as when they were warehoused). Summary of the Invention

[0006] This application provides a virtual inventory method and device for materials on an elevated warehouse. By converting the material storage information into virtual data units and using a virtual query system to implement data query, intelligent inventory of materials is achieved, effectively reducing the labor intensity of the existing material inventory, greatly reducing the time required for the current inventory, and making the inventory business tend to be routine.

[0007] The present application provides a virtual inventory method for materials on an elevated warehouse, including:

[0008] Establishing a virtual query system for materials based on the material storage information on the elevated warehouse, where the virtual query system includes data units in multiple dimensions;

[0009] Querying at least two data units according to the query conditions to obtain a virtual inventory result;

[0010] Outputting the virtual inventory result.

[0011] Preferably, the data units in multiple dimensions include a location unit and a pallet unit. The location unit records the location status on the shelves of the elevated warehouse, and the pallet unit records the location information of the materials on the pallet.

[0012] Preferably, querying at least two data units according to the query conditions to obtain a virtual inventory result specifically includes:

[0013] Querying the location unit to determine whether there is a location status that meets the first condition, and taking the location corresponding to the location status that meets the first condition as the first location;

[0014] If so, screening the locations that meet the second condition from the first locations as the second locations;

[0015] If there are second locations, querying the pallet unit to determine whether there is location information that meets the third condition;

[0016] If so, taking the second location as the virtual inventory result.

[0017] Preferably, the location status includes the regional storage status of the location, the parent location number of the location, and the location number of the location, and the location information includes the current regional information of the location.

[0018] Preferably, the first condition is that the regional storage status of the location is a non-idle state, the second condition is that the parent location number of the location is a specified location, the third condition is that there is no pallet information of a third location in the pallet unit, and the current regional information of the third location is the same as the location number of the second location;

[0019] The virtual inventory result indicates that the second location is the location where information is lost.

[0020] Preferably, the first condition is that the regional storage status of the location is an idle state, the second condition is that the parent location number of the location is a specified location, the third condition is that there is pallet information of a third location in the pallet unit, and the current regional information of the third location is the same as the location number of the second location;

[0021] The virtual inventory result indicates that the second location is the location where materials are lost.

[0022] Preferably, the data unit is an SQL table, and the data unit is queried through an SQL statement.

[0023] This application provides a virtual inventory device for materials on an elevated warehouse, including a virtual query system establishment module, a query module, and an output module.

[0024] The virtual query system establishment module is used to establish a virtual query system for materials based on the material storage information on the elevated warehouse. The virtual query system includes data units in multiple dimensions.

[0025] The query module is used to query at least two data units according to the query conditions to obtain a virtual inventory result.

[0026] The output module is used to output the virtual inventory result.

[0027] Preferably, the query module includes a location unit query module, a screening module, a pallet unit query module, and a virtual inventory result obtaining module.

[0028] The location unit query module is used to query the location unit, judge whether there is a location status that meets the first condition, and use the location corresponding to the location status that meets the first condition as the first location.

[0029] The screening module is used to screen the locations that meet the second condition from the first locations as the second locations.

[0030] The pallet unit query module is used to query the pallet unit and determine whether there is location information that meets the third condition.

[0031] The virtual inventory result obtaining module is used to use the second location as the virtual inventory result.

[0032] Preferably, the data unit is an SQL table, and the data unit is queried through an SQL statement.

[0033] Through the following detailed description of the exemplary embodiments of the present application with reference to the accompanying drawings, other features and advantages of the present application will become clear. BRIEF DESCRIPTION OF THE DRAWINGS

[0034] The drawings incorporated in the specification and constituting a part of the specification illustrate embodiments of the present application and, together with the description, are used to explain the principles of the present application.

[0035] Figure 1 is a flowchart of the virtual inventory method for materials on the elevated warehouse provided by the present application;

[0036] Figure 2 is a flowchart of the data query provided by the present application;

[0037] Figure 3Structural diagram of the virtual inventory device for materials on the high-bay warehouse provided by this application. Detailed implementation manners

[0038] Now, various exemplary embodiments of this application will be described in detail with reference to the accompanying drawings. It should be noted that: Unless otherwise specifically stated, the relative arrangements, numerical expressions, and numerical values of the components and steps set forth in these embodiments do not limit the scope of this application.

[0039] The following description of at least one exemplary embodiment is merely illustrative in nature and is in no way a limitation on this application or its application or use.

[0040] Technologies, methods, and devices known to those of ordinary skill in the relevant art may not be discussed in detail, but where appropriate, such technologies, methods, and devices should be regarded as part of the specification.

[0041] In all the examples shown and discussed here, any specific value should be construed as merely exemplary and not as a limitation. Therefore, other examples of the exemplary embodiments may have different values.

[0042] This application provides a virtual inventory method and device for materials on a high-bay warehouse. By converting the material storage information into virtual data units and using a virtual query system to implement data query, intelligent inventory of materials is achieved, effectively reducing the labor intensity of the existing material inventory, greatly reducing the time required for the current inventory, and making the inventory business tend to be routine.

[0043] The high-bay warehouse of this application uses pallet racks, that is, pallets for spacing are placed on the racks to facilitate the access of materials using auxiliary warehousing equipment such as forklifts and elevators. The pallets on the racks make the material storage form a cell style, and each complete material forms a storage location. Therefore, the pallet rack is also called a location rack. Such a storage method has a large storage density and the materials will not be confused with each other.

[0044] Theoretically, the location information on the pallet is consistent with the status information of the corresponding location on the rack. However, during the material operation process, there may be update errors in the location information on the pallet or the location status on the rack (such as not being updated in time or updated incorrectly). Therefore, during the material inventory process, there may be differences between the two. Through this difference, the location where the error occurs can be found, providing data support for the fuzzy inventory of materials.

[0045] Based on the above description, as Figure 1 shown, the virtual inventory method for materials on the high-bay warehouse provided by this application includes the following steps:

[0046] S110: Establish a virtual query system for materials based on the material storage information in the high-rise warehouse. The virtual query system includes data units in multiple dimensions.

[0047] Specifically, first input the material storage information in the high-rise warehouse into the virtual query system. The virtual query system sorts the material storage information into data units in multiple dimensions according to preset rules, which are used to reflect the storage status or storage information of materials from different dimensions.

[0048] As an embodiment, the data unit includes a location unit and a pallet unit. The location unit records the location status on the shelves of the high-rise warehouse, and the pallet unit records the location information of the materials on the pallet.

[0049] Specifically, as an embodiment, convert the material storage information into SQL data. The data unit is an SQL table, and subsequent queries of the data unit are performed through SQL statements.

[0050] In this embodiment, the pallet unit is the pallet table TWMS_PLT, and the location unit is the location table TWMS_LOC.

[0051] As an example, the pallet table TWMS_PLT is the primary key and has 15 fields, namely virtual container VPLTNUM, object type OBJECTTYPE, container number PLTNUM, container automatic type PLTAUTOTYPE, container type PLTTYPE, full pallet IFFULLPLT, automatic item combination number ITEMCMBAUTONUM, item category ITEMTYPE, palletizing time PACKDATE, earliest transfer-in time OLDMVINDATE, transfer-in time MVINDATE, source area SLOC, current area CURRLOC, target area DLOC, status STATUS, entry time ENTERDATE, etc.

[0052] Among them, the virtual container VPLTNUM is used to connect other tables. The object type OBJECTTYPE specifically includes single-item palletizing and mixed palletizing. The container automatic type PLTAUTOTYPE specifically includes empty pallet groups, full-material pallets, and fractional pallets. The container type PLTTYPE specifically includes empty pallet groups, full-material pallets, and fractional pallets. The full pallet IFFULLPLT represents the full pallet mark, where Y represents a full pallet and N represents a fractional pallet.

[0053] The current area CURRLOC can reflect the location information. If the information corresponding to the location is not recorded on the pallet, then no pallet corresponding to this location will be found when querying the pallet table, that is, the location information on the pallet.

[0054] The location table TWMS_LOC has a primary key and consists of 26 fields, namely location number LOCNUM, location type OBJECTTYPE, system number SYSNODE, control number LOCDCSNUM, virtual area IFDUMMYLOC, location description LOCDESC, address ADDRESS, location status LOCSTATUS, inbound priority I_PRIORITY, outbound priority O_PRIORITY, zone movement strategy MVSTOCK1, affiliated roadway BYLANENUM, platform type STNTYPE, zone storage status LOCSTORESTATUS, parent location number PRNTNUM, etc.

[0055] Among them, the specific location types of OBJECTTYPE include high-bay storage locations TStoreBuff, conveyor platforms TStation, and unit platforms TPuStationBuff. The control number LOCDCSNUM is the target address of the electric control section. The virtual area IFDUMMYLOC is a marker for virtual platforms, where Y indicates a virtual platform and N indicates an actual platform. The location description LOCDESC is a textual description of the location, such as the left side of the 2nd floor, column 69, roadway 1. The location status LOCSTATUS includes the goods location access prohibited status ProhibitInOut, the goods location entry prohibited status ProhibitIn, and the goods location normal status Normal.

[0056] The zone storage status LOCSTORESTATUS includes four states: move-in allocation MoveIn, idle free, loaded Load, and move-out allocation MoveOut. MoveIn, Load, and MoveOut are non-idle states.

[0057] The parent location number PRNTNUM is displayed as the warehouse number and the roadway number. For example, L046x represents the warehouse number, where L0463 is the auxiliary materials warehouse, L0464 is the finished product warehouse, and L0466 is the filter rod warehouse. 00y% represents the roadway number. Among them, L0463_001% is the first roadway of the auxiliary materials warehouse, L0463_002% is the second roadway of the auxiliary materials warehouse, and L0463_003% is the third roadway of the auxiliary materials warehouse.

[0058] Secondly, analyze the internal correlation between data units and set data query conditions according to the requirements of material inventory.

[0059] As can be seen from the above, in the location table, the regional storage status LOCSTORESTATUS can indicate whether a location is idle, the parent location number can indicate the location range of the location, and the location number indicates the specific location of the location. The pallet information in the pallet table represents the status of the corresponding location. Thus, it is possible to determine whether there is an abnormal situation in the correspondence between the location and the material by the information consistency between the location table and the pallet table.

[0060] Specifically, the correlation between the location table and the pallet table can be divided into four cases, which are respectively:

[0061] (1) The location status is non-idle, and there is pallet information corresponding to the location in the pallet table, that is, a location that is idle and has pallet information;

[0062] (2) The location status is non-idle, but there is no pallet information corresponding to the location in the pallet table, that is, a location that is not idle but has no pallet information;

[0063] (3) The location status is idle, but there is pallet information corresponding to the location in the pallet table, a location that is idle but has pallet information;

[0064] (4) The location status is idle, and there is no pallet information corresponding to the location in the pallet table, that is, a location that is idle and has no pallet information.

[0065] Among them, (1) and (4) are determined to have a normal location status, and (2) and (3) are determined to have an abnormal location status. Thus, only by querying the locations corresponding to (2) and (3) and displaying them can the fuzzy inventory of materials be realized.

[0066] S120: Query data units according to the query conditions to obtain a virtual inventory result.

[0067] As an embodiment, as Figure 2 shown, query at least two data units according to the query conditions to obtain a virtual inventory result, which specifically includes:

[0068] S210: Query the location unit, determine whether there is a location status that meets the first condition, and use the location corresponding to the location status that meets the first condition as the first location.

[0069] S220: If there is a first location, screen the locations that meet the second condition from the first locations as the second locations. Otherwise, end the process.

[0070] S230: If there is a second location, then query the pallet unit to determine whether there is location information that meets the third condition. Otherwise, end the process.

[0071] S240: If there is bin location information that meets the third condition, then use the second bin location as the virtual inventory count result. Otherwise, end the process.

[0072] Specifically, for the above-mentioned situation (2), the first condition is that the regional storage status of the bin location is non-idle (Move In, Load, or Move Out), the second condition is that the parent location number of the bin location is the specified bin location (e.g., 'L0464_001%'), the third condition is that there is no tray information of the third bin location in the tray unit, the current regional information of the third bin location is the same as the location number of the second bin location, and the virtual inventory count result indicates that the second bin location is the bin location where information is lost due to operations, system failures, equipment failures, etc.

[0073] As an example, the SQL query statement corresponding to situation (2) is as follows:

[0074] select t.*,t.rowid from TWMS_LOC t

[0075] where T.LOCSTORESTATUS<>'Free'

[0076] and T.PRNTNUM in('L0464_001%','L0464_002%','L0464_003%','L0464_004%',

[0077] 'L0464_005%','L0464_006%','L0464_007%','L0464_008%')

[0078] and T.LOCNUM not in(select T.CURRLOC from TWMS_PLT T);

[0079] Specifically, for the above-mentioned situation (3), the first condition is that the regional storage status of the bin location is idle, the second condition is that the parent location number of the bin location is the specified bin location (e.g., L0464_008%), the third condition is that there is tray information of the third bin location in the tray unit, the current regional information of the third bin location is the same as the location number of the second bin location, and the virtual inventory count result indicates that the second bin location is the bin location where materials are lost due to operations, system failures, equipment failures, etc.

[0080] As an example, the SQL query statement corresponding to situation (3) is as follows:

[0081] select t.*,t.rowid from TWMS_LOC t

[0082] where T.LOCSTORESTATUS = 'Free'

[0083] and T.PRNTNUM in ('L0464_001%', 'L0464_002%', 'L0464_003%', 'L0464_004%', 'L0464_005%', 'L0464_006%', 'L0464_007%', 'L0464_008%')

[0084] and T.LOCNUM in (select T.CURRLOC from TWMS_PLT T);

[0085] Similarly, for the above situation (1), the SQL query statement is as follows:

[0086] select t.*, t.rowid from TWMS_LOC t

[0087] where T.LOCSTORESTATUS <> 'Free'

[0088] and T.PRNTNUM in ('L0464_001%', 'L0464_002%', 'L0464_003%', 'L0464_004%', 'L0464_005%', 'L0464_006%', 'L0464_007%', 'L0464_008%')

[0089] and T.LOCNUM in (select T.CURRLOC from TWMS_PLT T);

[0090] For the above situation (4), the SQL query statement is as follows:

[0091] select t.*, t.rowid from TWMS_LOC t

[0092] where T.LOCSTORESTATUS = 'Free'

[0093] and T.PRNTNUM in ('L0464_001%', 'L0464_002%', 'L0464_003%', 'L0464_004%', 'L0464_005%', 'L0464_006%', 'L0464_007%', 'L0464_008%')

[0094] and T.LOCNUM not in(select T.CURRLOC from TWMS_PLT T);

[0095] S130: Output the virtual inventory result.

[0096] Based on the above method, this application provides a virtual inventory device for materials on an elevated warehouse, as Figure 3 shown, including a virtual query system establishment module 310, a query module 320, and an output module 330.

[0097] The virtual query system establishment module 310 is used to establish a virtual query system for materials based on the material storage information on the elevated warehouse. The virtual query system includes data units in multiple dimensions.

[0098] The query module 320 is used to query at least two data units according to the query conditions to obtain the virtual inventory result.

[0099] The output module 330 is used to output the virtual inventory result.

[0100] Preferably, as Figure 3 shown, the query module 320 includes a location unit query module 3201, a screening module 3202, a pallet unit query module 3203, and a virtual inventory result obtaining module 3204.

[0101] The location unit query module 3201 is used to query the location unit, determine whether there is a location status that meets the first condition, and use the location corresponding to the location status that meets the first condition as the first location.

[0102] The screening module 3202 is used to screen the locations that meet the second condition from the first locations as the second locations.

[0103] The pallet unit query module 3203 is used to query the pallet unit to determine whether there is location information that meets the third condition.

[0104] The virtual inventory result obtaining module 3204 is used to use the second location as the virtual inventory result.

[0105] In the fuzzy inventory method of the application, the database is jointly queried through multiple tables to realize the multi-dimensional identification of material information, which can effectively reduce the labor intensity of the existing material inventory, greatly reduce the time required for the current inventory, and make the inventory business tend to be daily. In the database system, the user interacts with the database management system through SQL statements to complete operations such as information query, modification, and deletion. By executing relevant SQL statements, the information status and location status of the inventory in the elevated warehouse can be queried more quickly.

[0106] Although some specific embodiments of the present application have been described in detail by way of examples, those skilled in the art should understand that the above examples are only for illustration and not for limiting the scope of the present application. Those skilled in the art should understand that the above embodiments can be modified without departing from the scope and spirit of the present application. The scope of the present application is defined by the appended claims.

Claims

1. A virtual inventory method for materials in a high-bay warehouse, characterized in that, it includes: Establish a virtual query system for materials based on the material storage information in the high-bay warehouse. The virtual query system includes data units in multiple dimensions; among them, the data units in the multiple dimensions include a location unit and a pallet unit. The location unit records the location status on the shelves of the high-bay warehouse, and the pallet unit records the location information of the materials on the pallet; Query at least two of the data units according to the query conditions to obtain a virtual inventory result; Output the virtual inventory result; Among them, querying at least two of the data units according to the query conditions to obtain a virtual inventory result specifically includes: Query the location unit to determine whether there is a location status that meets the first condition, and use the location corresponding to the location status that meets the first condition as the first location; where the location status includes the regional storage status of the location, the parent location number of the location, and the location number of the location; If so, screen the locations that meet the second condition from the first locations as the second locations; If there are the second locations, query the pallet unit to determine whether there is location information that meets the third condition; where the location information includes the current regional information of the location; If so, use the second location as the virtual inventory result; Among them, if the first condition is that the regional storage status of the location is a non-idle state, the second condition is that the parent location number of the location is the specified location, and the third condition is that there is no pallet information of the third location in the pallet unit, and the current regional information of the third location is the same as the location number of the second location, then the virtual inventory result indicates that the second location is the location with missing information.

2. The virtual inventory method for materials in a high-bay warehouse according to claim 1, characterized in that, If the first condition is that the regional storage status of the location is an idle state, the second condition is that the parent location number of the location is the specified location, and the third condition is that there is pallet information of the third location in the pallet unit, and the current regional information of the third location is the same as the location number of the second location, then the virtual inventory result indicates that the second location is the location with missing materials.

3. The virtual inventory method for materials in a high-bay warehouse according to claim 1, characterized in that, The data unit is an SQL table, and the data unit is queried through an SQL statement.

4. A virtual inventory device for materials in a high-bay warehouse, characterized in that, It includes a virtual query system establishment module, a query module, and an output module; The virtual query system establishment module is used to establish a virtual query system for materials based on the material storage information in the high-bay warehouse. The virtual query system includes data units in multiple dimensions; among them, the data units in the multiple dimensions include a location unit and a pallet unit. The location unit records the location status on the shelves of the high-bay warehouse, and the pallet unit records the location information of the materials on the pallet; The query module is used to query at least two of the data units according to the query conditions to obtain a virtual inventory result; The output module is used to output the virtual inventory result; Among them, the query module includes a location unit query module, a screening module, a pallet unit query module, and a virtual inventory result obtaining module; The location unit query module is used to query the location unit, determine whether there is a location status that meets the first condition, and use the location corresponding to the location status that meets the first condition as the first location; where the location status includes the regional storage status of the location, the parent location number of the location, and the location number of the location; The screening module is used to screen the locations that meet the second condition from the first locations as the second locations; The pallet unit query module is used to query the pallet unit to determine whether there is location information that meets the third condition; where the location information includes the current regional information of the location; The virtual inventory result obtaining module is used to use the second location as the virtual inventory result when there is location information that meets the third condition; Among them, if the first condition is that the regional storage status of the location is a non-idle state, the second condition is that the parent location number of the location is the specified location, the third condition is that there is no pallet information of the third location in the pallet unit, and the current regional information of the third location is the same as the location number of the second location, then the virtual inventory result indicates that the second location is the location with lost information.

5. The virtual inventory device for materials on the high-rise warehouse according to claim 4, characterized in that, The data unit is an SQL table, and the data unit is queried through SQL statements.

Images