On-site material management method, device and system

Abstract

The application relates to the field of material processing technology, in particular to a field material management method, equipment and system. The field material management method comprises the following steps: obtaining a manufacturing BOM of a product; processing the manufacturing BOM to form a material preparation task, wherein the material preparation task comprises required material demand indication information; sending the material preparation task to a WMS, so that the WMS side prepares materials according to the material preparation task; receiving a material preparation result returned by the WMS, wherein the material preparation result comprises material production information of the materials; when materials prepared by the WMS side are taken for assembly, the material production information of the taken materials is recorded, and an assembly BOM corresponding to an assembly task is generated based on the material preparation result and the material production information. The accuracy of the product assembly BOM can be effectively improved.

Description

Technical Field

[0001] This application relates to the field of materials management technology, and in particular to on-site materials management methods, equipment and systems. Background Technology

[0002] A BOM (Bill of Material) is a detailed list of all the underlying materials used in a project, along with their specific information.

[0003] During the product assembly process, staff will use barcode scanners to scan the physical QR codes of materials to obtain specific information about the materials, and then form the product assembly BOM based on the specific information of the materials.

[0004] However, during product assembly, warehouse staff cannot arrange material preparation in advance; they can only begin preparation after receiving notification from the assembly personnel. Therefore, material preparation is often rushed. Furthermore, staff frequently forget to scan the physical QR codes of materials during assembly, leading to frequent omissions in the assembly BOM. Thus, the accuracy of the product's assembly BOM is relatively low with current technology. Summary of the Invention

[0005] To improve the accuracy of product assembly BOM and ensure subsequent quality traceability, this application provides on-site material management methods, equipment, and systems.

[0006] Firstly, the on-site material management method provided in this application adopts the following technical solution: The on-site material management method includes: Obtain the product's manufacturing BOM; The manufacturing BOM is processed to form a material preparation task, which includes the requirement information of the required materials. The material preparation task is sent to the warehouse management system (WMS) so that the WMS can prepare materials according to the material preparation task. Receive the material preparation result sent back by the WMS, the material preparation result containing the material production information of the material; When performing an assembly task using materials prepared by the WMS side, the material production information of the materials being used is entered, and an assembly BOM corresponding to the assembly task is generated based on the material preparation results and the material production information.

[0007] By adopting the above technical solution, during the actual assembly process of the product, the Manufacturing Execution System (MES) first obtains the product's Manufacturing Bill of Materials (BOM). The MES then processes the BOM to generate a material preparation task, which includes the required material demand information. The MES then sends the material preparation task to the Manufacturing Management System (WMS), which prepares the materials according to the demand information. The WMS then sends the material preparation result, containing material production information, back to the MES, which receives the result. When assembly personnel perform their tasks, they can retrieve the corresponding materials from the WMS, and the MES records the material production information for the retrieved materials. After assembly is complete, the MES records all the material production information for all materials in the assembled product. Based on the recorded material production information and the material preparation result, the MES generates the corresponding Assembly BOM, achieving mutual verification between the material preparation result and the material production information during assembly. This completes the entire process from BOM acquisition, WMS material preparation, product assembly, to Assembly BOM generation.

[0008] In the aforementioned process, the WMS (Warehouse Management System) can obtain the required material demand information in advance, meaning the warehouse can access the basic information of the required materials beforehand. This allows warehouse staff to prepare materials ahead of time. Simultaneously, when assembly personnel retrieve the corresponding materials, the pre-arranged material preparation effectively reduces manual operation steps. Furthermore, the material preparation results in the warehouse can be verified against the material production information during assembly, thereby reducing the possibility of errors and effectively improving the accuracy of the product assembly BOM (Bill of Materials).

[0009] Optionally, the material preparation task includes a process material preparation task, wherein the demand indication information included in the process material preparation task is used to indicate the materials required by the process; the process of processing the manufacturing BOM to form the material preparation task includes: The manufacturing BOM is broken down according to the process steps to form the material preparation task for each process step.

[0010] By adopting the above technical solution, after processing the manufacturing BOM, process material preparation tasks can be formed. The process material preparation tasks are decomposed according to the process sequence of product assembly. The process material preparation tasks contain demand information for indicating the materials required for the process, and assembly personnel can directly pick up materials according to the process.

[0011] Optionally, the material preparation task further includes supporting demand information, wherein the demand indication information included in the supporting demand information is used to instruct the WMS side to prepare the materials required for the production of the product; the process of processing the manufacturing BOM to form the material preparation task further includes: Based on the manufacturing BOM, generate supporting requirements information.

[0012] By adopting the above technical solution, after processing the manufacturing BOM, matching requirement information can be generated. The matching requirement information is decomposed according to the total materials required for product assembly. The matching requirement information includes the total material requirement information, and the assembly personnel can directly install the total material requirement to obtain materials.

[0013] When requisitioning materials according to process steps, if process A requires 30 units of product a and process B requires 20 units of product a, then 30 units of product a must be requisitioned during assembly in process A, and 20 units of product a must be requisitioned during assembly in process B. However, when requisitioning materials according to the total material demand, only 50 units of product a need to be requisitioned at once. This avoids multiple requisitions caused by multiple processes, allowing for the completion of the total material demand for a single product in one go, thereby improving the efficiency of material issuance.

[0014] Optionally, the material preparation result includes process material preparation result, and the step of entering the material production information of the material to be used, and generating the assembly BOM corresponding to the assembly task based on the material preparation result and the material production information includes: In any step of the assembly task, when the material corresponding to the step is taken, the material production information of the material is obtained; Based on the obtained material production information, query the process material preparation result, add the single material total information corresponding to the material production information in the process material preparation result to the first database table corresponding to the process, the single material total information includes production task information, process information and material information, and the material information includes the material production information; The assembly BOM is generated based on the first database table corresponding to each of the aforementioned processes.

[0015] By adopting the above technical solution, in any step of product assembly, as long as the material corresponding to that step is used, the MES can obtain the material production information of the material, query the material preparation results of the step based on the obtained material production information, and then add the total information of the single material corresponding to the material production information from the material production information and the material preparation results of the step to the first database table corresponding to the step, thus obtaining the first database table. The total information of the single material includes production task information, step information, and material information, with the material information containing the material production information. That is, a corresponding first database table is generated upon completion of each assembly step. After all assembly steps of the product are completed, multiple first database tables are obtained, and the MES can generate the assembly BOM from these multiple first database tables.

[0016] Optionally, after sending the material preparation task to the WMS, the method further includes: A second database table is generated based on the material preparation results of the aforementioned process. The second database table contains sub-tables that correspond one-to-one with each of the aforementioned processes. The step of generating the assembly BOM based on the first database table corresponding to each of the aforementioned processes includes: In any of the aforementioned processes, the first database table of the current process is compared with the sub-table of the second database table corresponding to the process. If a match is found, the first database table is added to the third database table corresponding to the assembly BOM. After the production task is completed, the third database table will be used as the assembly BOM.

[0017] By adopting the above technical solution, the MES can obtain material production information from the process material preparation results and generate a second database table based on this information. During assembly, once the first database table is generated, it is compared with the sub-tables of the corresponding second database table. If they match, it proves that the first database table corresponds to the sub-tables of the second database table, and the corresponding first database table can be added to the third database table. After all processes are completed, the third database table is added and contains all records of the actual assembled materials. Therefore, the third database table can serve as the final assembly BOM.

[0018] Optionally, the step of entering the material production information of the material being used includes: Scan the graphic code on the material, which is set by the material's manufacturer; Material production information of the material is obtained based on the graphic code.

[0019] By adopting the above technical solution, each material will have material production information during the production process, which is usually displayed in the form of a graphic code. Assembly personnel can obtain the material production information by scanning the graphic code on the material with a scanner connected to the MES.

[0020] Secondly, the on-site material management method provided in this application adopts the following technical solution: The on-site material management method includes: Receive material preparation tasks from MES, which are decomposed from the manufacturing BOM and contain the required material demand information; The material preparation result is generated based on the material preparation task; the material preparation result includes the material production information of the prepared materials; The material preparation results are sent to the MES so that the MES can generate the assembly BOM corresponding to the assembly task based on the material preparation results and the material production information.

[0021] By adopting the above technical solution, the WMS can receive material preparation tasks from the MES, which are decomposed from the manufacturing BOM. These tasks contain demand instructions for the required materials. The WMS then processes the material preparation tasks to generate preparation results, which include the material production information for the prepared materials. Finally, the preparation results are sent to the MES, providing it with materials for generating the assembly BOM based on the preparation results and material production information.

[0022] Optional, also includes: The system receives the supporting requirement information sent by the MES, which is generated from the product's manufacturing BOM, and outputs the supporting requirement information to prompt the preparation of the materials.

[0023] By adopting the above technical solution, the WMS can receive the supporting requirement information sent by the MES, which is generated by the MES from the product's manufacturing BOM. The WMS can then output this supporting requirement information, thereby reminding assembly personnel to prepare materials. The output of material preparation information corresponds to the assembly task, while the output of supporting requirement information corresponds to the total amount of materials required for product assembly.

[0024] Thirdly, the computer equipment provided in this application adopts the following technical solution: A computer device includes a processor, a memory, and a communication bus, wherein the communication bus is used to establish a communication connection between the processor and the memory; the memory stores either a first computer program or a second computer program, wherein the first computer program can be executed by the processor to implement the field material management method as described in any of the first aspects above; and the second computer program can be executed by the processor to implement the field material management method as described in any of the second aspects above.

[0025] By adopting the above technical solution, a processor and a memory storing a first computer program provide a computer device capable of executing the field material management method implementing the first aspect; a processor and a memory storing a second computer program provide a computer device capable of executing the field material management method implementing the second aspect.

[0026] Fourthly, the on-site material management system provided in this application adopts the following technical solution: On-site material management system, including: EMS and WMS are communicatively connected; the EMS is a computer device storing the first computer program in the memory described in the first aspect, and the WMS is a computer device storing the second computer program in the memory described in the second aspect.

[0027] By adopting the above technical solution, the MES can obtain the product's manufacturing BOM, process it to form a backup task, and then send the backup task to the WMS. When entering the material production information of the materials to be used, the MES generates the assembly BOM corresponding to the assembly task based on the material production information. Simultaneously, the WMS can receive material preparation tasks from the MES, process them, generate material preparation information, and finally output the material preparation information to improve material preparation. In this process, the MES can generate an assembly BOM from the manufacturing BOM, and the WMS can understand the required material demand information in advance to prepare materials ahead of time.

[0028] In summary, this application includes at least the following beneficial technical effects: The WMS can obtain the required material demand information in advance, meaning the warehouse can obtain the basic information of the required materials in advance. Simultaneously, when assembly personnel retrieve the corresponding materials, the advance arrangement of material preparation effectively reduces manual operation steps. Furthermore, the material preparation results in the warehouse can be matched with the material production information during assembly, thereby reducing the possibility of errors and effectively improving the accuracy of the product assembly BOM. Attached Figure Description

[0029] Figure 1 This is a flowchart of the on-site material management method in the embodiments of this application.

[0030] Figure 2 This is an interactive flowchart of the on-site material management method in the embodiments of this application.

[0031] Figure 3 This is a flowchart of step S200 in the on-site material management method of this application embodiment.

[0032] Figure 4 This is a flowchart of step S300 in the on-site material management method of this application embodiment.

[0033] Figure 5 This is a flowchart of step S400 in the on-site material management method of this application embodiment.

[0034] Figure 6 This is a flowchart of step S400 in the on-site material management method of this application embodiment.

[0035] Figure 7This is a block diagram illustrating the communication principle of the on-site material management system in an embodiment of this application.

[0036] Figure label: 1. MES; 2. WMS. Detailed Implementation

[0037] To make the purpose, technical solution, and advantages of this application clearer, the following description is provided in conjunction with the appendix. Figure 1-7 The present application will be further described in detail below with reference to embodiments. It should be understood that the specific embodiments described herein are for illustrative purposes only and are not intended to limit the scope of the application.

[0038] This application discloses a method for on-site material management.

[0039] refer to Figures 1-6 The on-site material management method includes the following steps: S100: MES obtains the product's manufacturing BOM.

[0040] Reference Figure 1 and Figure 2 MES1 receives the product's manufacturing BOM from the upstream process system or through methods such as importing from Excel. The structure of the manufacturing BOM in the system includes the product, multiple materials under the product, and material codes, material names, process numbers, and quantities under each material.

[0041] S200: MES processes the manufacturing BOM and generates material preparation tasks.

[0042] Reference Figures 1-3 The material preparation task includes the required material demand information, which can instruct the WMS2 side to prepare materials.

[0043] Step S200 includes the following steps; S210: MES generates supporting requirement information based on the manufacturing BOM.

[0044] The material preparation task includes supporting demand information. MES1 decomposes the manufacturing BOM and generates supporting demand information. The demand indication information contained in the supporting demand information is used to instruct WMS2 to prepare the materials required for the production of the product.

[0045] The supporting requirements information includes the production task number, multiple material information under the production task number, and the material code, material name, and quantity under each material information. After receiving the supporting requirements information, WMS2 can determine the total number of each material required for assembling the product based on the supporting requirements information.

[0046] Furthermore, the supporting requirements information is in JSON (JavaScript Object Notation) format. JSON is a lightweight data exchange format that uses a text format completely independent of programming languages ​​to store and represent data. Its concise and clear hierarchical structure makes JSON an ideal data exchange language. It is easy for humans to read and write, and also easy for machines to parse and generate, which can effectively improve network transmission efficiency.

[0047] S220: MES generates material preparation tasks based on the manufacturing BOM.

[0048] Material preparation tasks include process material preparation tasks, and the demand indication information contained in the process material preparation tasks is used to indicate the materials required by the process. MES1 decomposes the manufacturing BOM according to the process, thereby forming the process material preparation tasks for each process.

[0049] The material preparation task for each process also uses JSON format. The material preparation task includes a header and, below the header, production task information, process information, and material information. The production task information includes the production task number and manufacturing target; the process information includes the process number and process name; and the material information includes the material code and quantity.

[0050] S300: MES sends the material preparation task to WMS.

[0051] Reference Figure 1 , Figure 2 and Figure 4 Step S300 includes the following steps: S310: MES sends the supporting requirements information to WMS.

[0052] MES1 sends the required materials information to WMS2, which in turn receives it. The required materials information includes instructions for WMS2 to prepare the materials needed for product production, and these materials represent the total amount required for product assembly. WMS2 can output the required materials information on its display panel, prompting assembly personnel to prepare materials according to the total amount needed for the product.

[0053] S320: MES sends the process material preparation task to WMS.

[0054] MES1 sends the process material preparation task to WMS2, which then receives the task. The requirement information included in the process material preparation task instructs WMS2 to prepare materials according to the process requirements. WMS2 can generate the process material preparation result based on the task and output it on the display panel, thus prompting assembly personnel to prepare materials according to the process.

[0055] S400: MES receives the material preparation results sent back by WMS, and then generates a second database table.

[0056] Reference Figure 1 , Figure 2 and Figure 5 Step S400 includes the following steps: S410: MES receives the material preparation results sent back by WMS.

[0057] When materials are issued from the warehouse, that is, when materials are taken in preparation for assembly, assembly personnel use a barcode scanner to scan the graphic code on the material, and then obtain the material's production information based on the graphic code. The graphic code is set by the material manufacturer and can be a barcode, QR code, or other form of graphic code.

[0058] After obtaining the material production information, WMS2 adds the material production information to the material preparation task to form the process material preparation result. WMS2 then sends the process material preparation result to MES1, which receives the result.

[0059] Since the process material preparation result is generated by adding material production information to the material preparation task, the process material preparation result includes a message header, as well as production task information, process information, and material information under the message header. Specifically, the production task information in the process material preparation result is consistent with the production task information in the material preparation task, and the process information in the process material preparation result is also consistent with the process information in the material preparation task.

[0060] The difference between the two lies in the material information. Material production information is added under the material information section, and this information includes the manufacturer, production date, and production batch. Therefore, in the process material preparation results, the material information includes not only the material code and actual quantity, but also the manufacturer, production date, and production batch from the material production information.

[0061] S420: Generate the second database table.

[0062] After receiving the process material preparation results from WMS2, MES1 enters the corresponding process material preparation results and then generates a second database table based on the process material preparation results and material production information. Since assembling a product involves multiple processes, the second database table contains sub-tables corresponding to each process.

[0063] S500: Generate the first database table.

[0064] Reference Figure 1 , Figure 2 and Figure 6 Step S500 includes the following steps: S510: Obtain material production information for assembly materials.

[0065] When performing any assembly task, the assembly personnel will take the materials corresponding to the process. At this time, the MES1 can scan the graphic code of the material with a barcode scanner to obtain the material production information.

[0066] S520: MES generates the first database table based on material production information and process material preparation results.

[0067] Once the material production information of the material to be used is obtained, MES1 can query the process preparation results corresponding to the material production information. Then, the total information of the single material corresponding to the material production information in the process preparation results is added to the first database table corresponding to the process, and the first database table corresponding to the single material can be obtained.

[0068] Since the first database table needs to be compared with the second database table later, the first database table also includes production task information, process information, and material information. The material information includes material production information, which includes the manufacturer, production date, and production batch.

[0069] S600: Generate assembly BOM.

[0070] Reference Figure 1 and Figure 2 In any assembly process, MES1 compares the first database table in the current process with the corresponding sub-table in the second database table to determine if they match. If they match, the first database table for each process is added to the third database table corresponding to the assembly BOM. Once the assembly task is completed, all first database tables have been generated and added to the third database table. After the third database table is added, the product's assembly BOM can be generated. The second database table is stored in MES1 as part of its data pool, facilitating subsequent traceability of the entire assembly record.

[0071] In an optional embodiment of this application, the assembly BOM can also be generated using only multiple first database tables.

[0072] Based on the same design concept, this embodiment also discloses a field material management system.

[0073] Referring to Figure 7, the on-site material management system includes MES1 and WMS2 mentioned in the previous embodiments, and MES1 and WMS2 are connected by communication. MES1 and WMS2 can be connected via wired or wireless communication. MES1 can be deployed in the central control room, and WMS2 can be deployed at the warehouse entrance / exit.

[0074] This application also provides a computer-readable storage medium storing information that can be loaded and executed by a processor to perform the above steps.

[0075] The computer-readable storage medium includes, for example, various media capable of storing program code, such as USB flash drives, portable hard drives, read-only memory (ROM), random access memory (RAM), magnetic disks, or optical disks.

[0076] Based on the same inventive concept, embodiments of this application provide a computer device, including a memory and a processor, wherein the memory stores a computer program that can be loaded by the processor and execute the above-described method.

[0077] Those skilled in the art will clearly understand that, for the sake of convenience and brevity, the above-described division of functional modules is merely an example. In practical applications, the above functions can be assigned to different functional modules as needed, that is, the internal structure of the device can be divided into different functional modules to complete all or part of the functions described above. The specific working process of the system, device, and unit described above can be referred to the corresponding process in the foregoing method embodiments, and will not be repeated here.

[0078] In the several embodiments provided in this application, it should be understood that the disclosed systems, devices, and methods can be implemented in other ways. For example, the device embodiments described above are merely illustrative; for instance, the division of modules or units is only a logical functional division, and in actual implementation, there may be other division methods. For example, multiple units or components may be combined or integrated into another system, or some features may be ignored or not executed. Furthermore, the mutual coupling or direct coupling or communication connection shown or discussed may be through some interfaces; the indirect coupling or communication connection between devices or units may be electrical, mechanical, or other forms.

[0079] The units described as separate components may or may not be physically separate. The components shown as units may or may not be physical units; that is, they may be located in one place or distributed across multiple network units. Some or all of the units can be selected to achieve the purpose of this embodiment according to actual needs.

[0080] Furthermore, the functional units in the various embodiments of this application can be integrated into one processing unit, or each unit can exist physically separately, or two or more units can be integrated into one unit. The integrated unit can be implemented in hardware or as a software functional unit.

[0081] If the integrated unit is implemented as a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of this application, in essence, or the part that contributes to the prior art, or all or part of the technical solution, can be embodied in the form of a software product. This computer software product is stored in a storage medium and includes several instructions to cause a computer device (which may be a personal computer, server, or network device, etc.) or processor to execute all or part of the steps of the methods described in the various embodiments of this application. The aforementioned storage medium includes various media capable of storing program code, such as USB flash drives, portable hard drives, read-only memory, random access memory, magnetic disks, or optical disks.

[0082] The above description of the embodiments is only used to provide a detailed introduction to the technical solutions of this application. However, the description of the above embodiments is only for the purpose of helping to understand the methods and core ideas of this application, and should not be construed as a limitation of this application. Any variations or substitutions that can be easily conceived by those skilled in the art within the scope of the technology disclosed in this application should be included within the protection scope of this application.

Claims

1. A method for on-site material management, characterized in that, The on-site material management method includes: Obtain the product's manufacturing BOM; The manufacturing BOM is processed to form a material preparation task, which includes the requirement information of the required materials. The material preparation task is sent to WMS (2) so that WMS (2) can prepare materials according to the material preparation task; Receive the material preparation result sent back by the WMS (2), wherein the material preparation result contains the material production information of the material; When performing an assembly task using materials prepared by the WMS (2) side, the material production information of the material being used is entered, and an assembly BOM corresponding to the assembly task is generated based on the material preparation result and the material production information. The material preparation task includes process material preparation tasks, and the demand indication information included in the process material preparation task is used to indicate the materials required by the process; the process of processing the manufacturing BOM to form material preparation tasks includes: decomposing the manufacturing BOM according to the process to form the process material preparation task for each process. The material preparation result includes the process material preparation result. The step of entering the material production information of the material to be used, and generating the assembly BOM corresponding to the assembly task based on the material preparation result and the material production information, includes: In any step of the assembly task, when the material corresponding to the step is taken, the material production information of the material is obtained; the material preparation result of the step is queried according to the obtained material production information, and the total information of a single material corresponding to the material production information in the material preparation result of the step is added to the first database table corresponding to the step. The total information of a single material includes production task information, step information and material information, and the material information includes the material production information. The assembly BOM is generated based on the first database table corresponding to each of the aforementioned processes; After sending the material preparation task to WMS (2), the process further includes: A second database table is generated based on the material preparation results of the aforementioned processes. The second database table contains sub-tables corresponding one-to-one with each of the aforementioned processes. Generating the assembly BOM based on the first database table corresponding to each of the aforementioned processes includes: In any of the aforementioned processes, the first database table of the current process is compared with the sub-table in the second database table corresponding to the process; if they match, the first database table is added to the third database table corresponding to the assembly BOM; after the production task is completed, the third database table is used as the assembly BOM.

2. The on-site material management method according to claim 1, characterized in that, The material preparation task also includes supporting demand information, wherein the demand indication information included in the supporting demand information is used to instruct the WMS (2) side to prepare the materials required for the production of the product; the process of processing the manufacturing BOM to form the material preparation task also includes: Based on the manufacturing BOM, generate supporting requirements information.

3. The on-site material management method according to claim 1, characterized in that, The process of entering the material production information of the material being used includes: Scan the graphic code on the material, which is set by the material's manufacturer; Material production information of the material is obtained based on the graphic code.

4. On-site material management method, characterized in that, The on-site material management method includes: Receive the material preparation task issued by MES (1), the material preparation task is decomposed from the manufacturing BOM, and the material preparation task contains the demand indication information of the required materials; The material preparation result is generated based on the material preparation task; the material preparation result includes the material production information of the prepared materials; The material preparation results are sent to the MES (1) so that the MES (1) can generate the assembly BOM corresponding to the assembly task based on the material preparation results and the material production information. The material preparation task includes process material preparation tasks, and the demand indication information included in the process material preparation task is used to indicate the materials required by the process; the process of processing the manufacturing BOM to form material preparation tasks includes: decomposing the manufacturing BOM according to the process to form the process material preparation task for each process. The material preparation result includes the process material preparation result, the input of the material production information of the material to be used, and the generation of the assembly BOM corresponding to the assembly task based on the material preparation result and the material production information, including: In any step of the assembly task, when the material corresponding to the step is taken, the material production information of the material is obtained; the material preparation result of the step is queried according to the obtained material production information, and the total information of a single material corresponding to the material production information in the material preparation result of the step is added to the first database table corresponding to the step. The total information of a single material includes production task information, step information and material information, and the material information includes the material production information. The assembly BOM is generated based on the first database table corresponding to each of the aforementioned processes; After sending the material preparation task to WMS (2), the process further includes: A second database table is generated based on the material preparation results of the aforementioned processes. The second database table contains sub-tables corresponding one-to-one with each of the aforementioned processes. Generating the assembly BOM based on the first database table corresponding to each of the aforementioned processes includes: In any of the aforementioned processes, the first database table of the current process is compared with the sub-table in the second database table corresponding to the process; if they match, the first database table is added to the third database table corresponding to the assembly BOM; after the production task is completed, the third database table is used as the assembly BOM.

5. The on-site material management method according to claim 4, characterized in that, Also includes: Receive the supporting requirements sent by the MES (1), the supporting requirements are generated by the product manufacturing BOM, and output the supporting requirements to prompt the material preparation.

6. A computer device, characterized in that, The system includes a processor, a memory, and a communication bus, wherein the communication bus is used to establish a communication connection between the processor and the memory; the memory stores either a first computer program or a second computer program, wherein the first computer program can be executed by the processor to implement the field material management method as described in any one of claims 1-3; and the second computer program can be executed by the processor to implement the field material management method as described in any one of claims 4 or 5.

7. An on-site material management system, characterized in that, Includes MES (1) and WMS (2), wherein MES (1) and WMS (2) are communicatively connected; MES (1) is a computer device storing the first computer program in the memory as described in claim 6, and WMS (2) is a computer device storing the second computer program in the memory as described in claim 6.

Images