A method, device and storage medium for adding component materials to module BOM
By constructing ECR process attachments and automatic matching material specification-level codes, the complex time problem of manually maintaining BOM tables in multi-module product design is solved, and efficient and automated material addition of module BOM is achieved, improving efficiency and accuracy.
Patent Information
- Application Number
- CN202210727021.8
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2022-06-24
- Publication Date
- 2024-11-01
- Estimated Expiration
- 2042-06-24
AI Technical Summary
In multi-module product design, manually maintaining the loadsheet and casetable tables of each module BOM leads to complex maintenance time and low efficiency, especially when the number of module BOMs to be maintained is large, the time consumed is multiplied.
By building ECR process attachments, including material specification-level encoding, material module-level encoding and similar values, configuring flags, automatically matching and adding material specification-level encoding to BOM information worksheet and configuration table, use feature encoding to create conditional statements with bring out and quantity calculation statements to realize automated module BOM material addition.
It realizes the automatic material addition of module BOM, improves the efficiency and accuracy of addition, reduces manual maintenance time, and frees up human resources.
Smart Images

Figure CN115048383B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of automatically adding component materials to a module BOM, and in particular to a method, a device and a storage medium for adding component materials to a module BOM. Background Art
[0002] At present, many enterprises, in order to meet the diverse needs of different customers, often design a product with many different configurations. Therefore, when creating a module BOM, a product will have one or more BOMs with different configurations. After the BOM is created, as the testing of new materials is completed, these materials need to be added to the module BOM through the ECR change process for customers to choose, giving customers more diverse choices; and 70% of the materials tested are component materials, such as: CPU, memory, network card, hard disk. When receiving the ECR change process, the BOM engineer needs to manually maintain the BOM Information Sheet (BOM information worksheet, including all module-level and material specification-level codes of the product), Character Information sheet (optional material information worksheet, including material specification-level codes of materials to be selected) and Casetable (configuration table, which specifies the restriction relationship between the selected materials) in each module BOM of this product to complete the action of adding component materials to the module BOM.
[0003] At present, in the prior art, for products with multiple module BOMs, it is necessary to refer to the attachment table in the ECR process, manually maintain the module BOM one by one to add components and materials, and separately maintain the loadsheet and casetable tables of each module BOM, where the loadsheet contains the BOM information worksheet and the optional material information worksheet. After all module BOMs are maintained separately, click the completion button in the ECR task to publish the latest data of the module BOM to the production and sales system. When the number of module BOMs that need to be maintained is large, the time spent will also increase exponentially. In order to solve the above problems, the present invention provides a method, device and storage medium for adding components and materials to a module BOM, so that the ECR change process has the function of automatically maintaining the module BOM and adding materials. Summary of the invention
[0004] In order to solve the above technical problem or at least partially solve the above technical problem, the present invention provides a method, device and storage medium for adding component materials to a module BOM.
[0005] In a first aspect, the present invention provides a method for adding component materials to a module BOM, comprising:
[0006] Construct an ECR process attachment containing the material specification level code of the changed material, the material module level code to which the material specification level code belongs, and similar values of the corresponding material specification level code;
[0007] Among them, flags are configured in both the material specification level code and the characteristic code, and the characteristic codes exist in the optional material information worksheet; based on the flag in the material specification level code in the ECR process attachment, the flag in the characteristic code in the optional material information worksheet is matched, and the material specification level code in the ECR process attachment is mounted under the matched characteristic code;
[0008] Based on the material module-level code in the ECR process attachment, the corresponding material module-level code in the BOM information worksheet is matched, and the material module-level code in the ECR process attachment and its subordinate material specification-level code are added non-repeatedly below the material module-level code matched from the BOM information worksheet, and each material specification-level code and its matching characteristic code are used to automatically create a conditional statement for the material specification-level code, and each material specification-level code is used to automatically create a quantity calculation statement;
[0009] Based on the similarity values and characteristic codes corresponding to the material specification level codes in the ECR process attachment, the material specification level codes are added to the characteristic codes corresponding to the matching restriction relationship grouping where the similarity values are located in the configuration table.
[0010] Furthermore, the optional material information worksheet includes the material specification level codes of the optional materials and the characteristic codes to which the material specification level codes belong. The material components corresponding to the subordinate material specification level codes under each characteristic code constitute the product, wherein the characteristic code includes the product line number, product model number, disk location number, serial code and flag bit.
[0011] Furthermore, the BOM information worksheet records the module BOM code, material module-level code, material specification-level code, bring-out conditional statements and quantity calculation statements for each material. When using the optional material information worksheet to build a product, the bring-out conditional statement can bring out the corresponding material specification-level code from the BOM information worksheet according to the characteristic code in the optional material information worksheet, and the quantity calculation statement gives the quantity of the material corresponding to the optional material specification-level code.
[0012] Furthermore, the configuration table includes at least two characteristic codes and the matching restriction relationship between the materials corresponding to the material specification level codes mounted under each characteristic code. Each group of matching restriction relationships is separated by a separator, and a terminator is configured after the final matching restriction relationship group.
[0013] Furthermore, the similar value is already in the BOM information worksheet, and according to the product design plan, it is the material specification level code of any material of the same type and with the same matching relationship as the material specification level code corresponding to the similar value in the ECR process attachment; the material specification level code is added before the separator or terminator after the optional restriction relationship grouping of the similar value in the configuration table.
[0014] Furthermore, before adding the added material specification level code to the optional material information worksheet, BOM information worksheet and configuration table, it is checked whether the added material specification level code exists in the corresponding table, otherwise the added material specification level code is added to the corresponding table.
[0015] Furthermore, each material specification level code and its matching characteristic code are used to automatically create a bring-out conditional statement for the material specification level code. Using each material specification level code to automatically create a quantity calculation statement includes: copying the "bring-out conditional statement" and "quantity calculation statement" of the last material specification level code under the current material module level code, pasting them in the "bring-out conditional statement" and "quantity calculation statement" fields of the added material specification level code, and replacing the original material specification level code with the current material specification level code.
[0016] Furthermore, before updating the module BOM according to the ECR process attachment, check whether the similar values in the ECR process attachment exist in the BOM information worksheet. If not, an abnormal prompt of the similar value of the ECR process attachment is given.
[0017] In a second aspect, the present invention provides a device for adding component materials to a module BOM, comprising: a processing unit, a storage unit, a bus unit and an interface unit, wherein the processing unit, the interface unit and the storage unit are connected via a bus, the storage unit stores computer instructions, a BOM information worksheet, an optional material information worksheet and a configuration table, the processing unit reads and executes computer instructions to receive ECR process attachments from the interface unit and implements the method for adding component materials to the module BOM.
[0018] In a third aspect, the present invention provides a storage medium for implementing a method for adding component materials to a module BOM, wherein the storage medium stores a computer program, and when the computer program is executed by a processor, the method for adding component materials to a module BOM is implemented.
[0019] The above technical solution provided by the embodiment of the present invention has the following advantages compared with the prior art:
[0020] The ECR process attachment includes the material specification level code of the changed material, the material module level code to which the material specification level code belongs, and the similar value of the corresponding material specification level code; wherein, flags are configured in both the material specification level code and the characteristic code, and the characteristic code exists in both the optional material information worksheet and the configuration table; based on the flag in the material specification level code in the ECR process attachment, the flag in the characteristic code in the optional material information worksheet is matched, and the material specification level code in the ECR process attachment is mounted under the matched characteristic code; based on the material module level code in the ECR process attachment, the corresponding material module level code is matched in the BOM information worksheet, and the material module level code in the ECR process attachment is matched. After the subordinate material specification level codes are non-repeatedly added to the matching material module level codes in the BOM information worksheet, each material specification level code and its matching characteristic code are used to automatically create the conditional statement and quantity calculation statement of the material specification level code; based on the similar values and characteristic codes of the corresponding material specification level codes in the ECR process attachment, the material specification level codes are added to the characteristic codes corresponding to the similar values in the optional restriction relationship grouping in the configuration table, so as to automatically add the component materials added to the module BOM to the optional material information worksheet, BOM information worksheet and configuration table according to the ECR process attachment, so as to realize more efficient and accurate material addition to the module BOM and liberate manpower. BRIEF DESCRIPTION OF THE DRAWINGS
[0021] The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the invention and, together with the description, serve to explain the principles of the invention.
[0022] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, for ordinary technicians in this field, other drawings can be obtained based on these drawings without paying any creative labor.
[0023] Figure 1 A flowchart of a method for adding component materials to a module BOM provided by an embodiment of the present invention;
[0024] Figure 2 A schematic diagram of an ECR process attachment provided by an embodiment of the present invention;
[0025] Figure 3 A schematic diagram of a material selection information worksheet provided in an embodiment of the present invention;
[0026] Figure 4 A schematic diagram of characteristic coding provided by an embodiment of the present invention;
[0027] Figure 5A schematic diagram of a BOM information worksheet provided in an embodiment of the present invention;
[0028] Figure 6 A schematic diagram of a configuration table provided for an embodiment of the present invention;
[0029] Figure 7 A schematic diagram of adding materials to the original optional material information worksheet using the ECR process attachment provided by an embodiment of the present invention;
[0030] Figure 8 A schematic diagram of adding materials to an original BOM information worksheet using an ECR process attachment provided by an embodiment of the present invention;
[0031] Fig. 9 A schematic diagram of automatically adding conditional statements and quantity calculation statements in a BOM information worksheet provided in an embodiment of the present invention;
[0032] Fig.10 A schematic diagram of adding a new material matching restriction relationship in a configuration table using an ECR process appendix provided in an embodiment of the present invention;
[0033] Fig.11 A flowchart of a method for adding component materials to a module BOM provided by an embodiment of the present invention;
[0034] Fig.12 A schematic diagram of a device for adding component materials to a module BOM provided by an embodiment of the present invention. DETAILED DESCRIPTION
[0035] In order to make the purpose, technical solution and advantages of the embodiments of the present invention clearer, the technical solution in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments are part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.
[0036] It should be noted that, in this article, the terms "include", "comprises" or any other variations thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device. In the absence of further restrictions, an element defined by the sentence "comprises a ..." does not exclude the existence of other identical elements in the process, method, article or device including the element.
[0037] Example 1
[0038] See also Figure 1 As shown, an embodiment of the present invention provides a method for adding component materials to a module BOM, comprising:
[0039] Build the ECR process attachment. For specific implementation, refer to Figure 2 As shown, the constructed ECR process attachment includes: the material specification level code of the module BOM changed material, the material module level code to which the material specification level code belongs, and the similar value of the corresponding material specification level code. Among them, flag bits are configured in the material specification level code. For the material CPU, the flag bit in its material specification level code is CPU, for the material memory, the flag bit in its material specification level code is MEM, for the material hard disk, the flag bit in its material specification level code is HDD, and for the network card, the flag bit in its material specification level code is NIC. Figure 2 In the above table, CPU (material) specification level code A, CPU (material) specification level code B, CPU (material) specification level code C all belong to CPU module level code, memory (material) specification level code a, memory (material) specification level code b, memory (material) specification level code c all belong to memory module level code. Similar values are already in the BOM information worksheet, and according to the product design plan, the material specification level code of any material of the same type and with the same matching relationship as the material specification level code corresponding to the similar value in the ECR process attachment.
[0040] Construct the optional material information worksheet of the module BOM. The optional material information worksheet of the module BOM contains: the material specification level code of the optional material and the characteristic code to which the material specification level code belongs. Figure 3 As shown, in the optional material information worksheet, the characteristic code _CPU is subordinate to the CPU (material) specification level code a, the characteristic code _MEM is subordinate to the memory (material) specification level code A, and the characteristic code _NIC is subordinate to the network card (material) specification level code 1. The materials corresponding to the material specification level codes subordinate to each characteristic code constitute the product. In the specific implementation process, the characteristic code includes: product line number, product model number, disk number, serial code and flag bit, among which the characteristic flag bits of the same type of materials have fixed coding names. For the material CPU, the flag bit in the characteristic code to which it belongs is CPU, for the material memory, the flag bit in the characteristic code to which it belongs is MEM, for the material hard disk, the flag bit in the characteristic code to which it belongs is HDD, and for the network card, the flag bit in the characteristic code to which it belongs is NIC. That is, the definition of the flag bit in the characteristic code is consistent with the definition of the material specification level code flag bit. See. Figure 4As shown in the figure, the product line code is: "S", the product model code is: "SA123", the disk position code is: "12", the serial code is: "1", the flag is: "CPU", and each attribute is connected by an underscore. The characteristic code is unique. In the optional material information worksheet, the characteristic code is used to establish a connection with the BOM Information sheet, and the flag in the characteristic code is used to establish a connection with the flag in the material specification level code in the ECR process attachment.
[0041] The BOM information worksheet of the construction module BOM. Figure 5 As shown, the BOM information worksheet records the BOM code of the module, the material module level code, the material specification level code, the bring-out conditional statement and the quantity calculation statement for each material. The bring-out conditional statement in the BOM information worksheet is written by the characteristic code in the optional material information worksheet and the material specification level code with the added material. When using the optional material information worksheet to build a product, the bring-out conditional statement can bring out the corresponding material specification level code from the BOM information worksheet according to the characteristic code in the optional material information worksheet, and the quantity calculation statement gives the quantity of the material corresponding to the optional material specification level code.
[0042] Build a configuration table. The configuration table includes at least two characteristic codes and the matching restriction relationships between the materials corresponding to the material specification level codes mounted under each characteristic code. Separators are used between each group of matching restriction relationships, and a terminator is configured after the final group of matching restriction relationships. By editing the corresponding relationship between the material specification level codes mounted under two or more characteristic codes in the configuration table, the matching restriction relationship of different types of materials in the module BOM matching interface is realized. A feasible separator is a blank line, and a feasible terminator is "#END". When traversing the matching restriction relationship of the entire configuration table, the traversal stops when the terminator is reached. For specific implementation, refer to Figure 6 As shown in the figure, the characteristic codes in the configuration table include characteristic code_CPU and characteristic code_MEM, which are used to limit the matching restriction relationship between the CPU and the memory. Separator and terminator. Figure 6 The matching restriction relationships are divided into two groups. One group is that CPU (material) specification level code a or / and CPU (material) specification level code b can be matched with memory (material) specification level code B; the other group is that CPU (material) specification level code c or / and CPU (material) specification level code d can be matched with memory (material) specification level code A.
[0043] Use the created ECR process attachments, optional material information worksheets, BOM information worksheets and configuration tables to automatically add materials.
[0044] See also Figure 7 and Fig.11 As shown, based on the ECR process attachment and the optional material information worksheet, the material specification level code in the ECR process attachment is added to the optional material information worksheet non-repeatedly. Based on the flag in the material specification level code in the ECR process attachment, the flag in the characteristic code in the optional material information worksheet is matched, and the material specification level code in the ECR process attachment is non-repeatedly mounted under the matched characteristic code; before the material specification level code added in the ECR process attachment is added to the optional material information worksheet, it is detected whether the added material specification level code exists under the matched characteristic code in the optional material information worksheet. If it exists, it will not be added. If it does not exist, the added material specification level code will be added under the matched characteristic code in the optional material information worksheet.
[0045] See also Figure 8 , Fig. 9 and Fig.11 As shown, based on the material module level code in the ECR process attachment, the corresponding material module level code is matched in the BOM information worksheet, and the material specification level code subordinate to the material module level code in the ECR process attachment is added to the matched material module level code in the BOM information worksheet without duplication, and each material specification level code and its matched characteristic code are used to automatically create the conditional statement and quantity calculation statement of the material specification level code. Before adding the material specification level code added in the ECR process attachment to the BOM information worksheet, check whether the added material specification level code exists in the BOM information worksheet. If it exists, it will not be added. If it does not exist, the added material specification level code will be added to the BOM information worksheet. Utilize each material specification level code and its matching characteristic code to automatically create a bring-out conditional statement for the material specification level code. Utilize each material specification level code to automatically create a quantity calculation statement, including: copying the "bring-out conditional statement" and "quantity calculation statement" of the last material specification level code under the current material module level code in the BOM information worksheet, pasting them in the "bring-out conditional statement" and "quantity calculation statement" fields of the added material specification level code, and replacing the original material specification level code with the current material specification level code.
[0046] See also Fig.10 and Fig.11As shown, based on the similarity value and characteristic code of the corresponding material specification level code in the ECR process attachment, the material specification level code is added to the characteristic code corresponding to the matching restriction relationship group in the configuration table in a non-repeated manner. Before the material specification level code added in the ECR process attachment is added to the configuration table, it is detected whether the added material specification level code exists in the corresponding matching restriction relationship group in the configuration table. If it exists, it is not added. If it does not exist, the added material specification level code is added to the corresponding matching restriction relationship group in the configuration table. Specifically, before the ECR process attachment updates the BOM of the module, it is traversed to see whether the similarity value in the ECR process attachment exists in the BOM information worksheet. If it does not exist, an abnormal prompt of the similarity value of the ECR process attachment is given. For the ECR process attachment without an abnormal prompt of the similarity value, the similarity value corresponding to each material specification level code in the ECR process attachment is used to find the matching restriction relationship group where the similarity value is located from the configuration table, and the material specification level code corresponding to the similarity value in the ECR process attachment is added to the separator or terminator after the matching restriction relationship group where the similarity value is located in the configuration table.
[0047] Example 2
[0048] See also Fig.12 As shown, an embodiment of the present invention provides a device for adding component materials to a module BOM, comprising: a processing unit, a storage unit, a bus unit and an interface unit, wherein the processing unit, the interface unit and the storage unit are connected via a bus, the storage unit stores computer instructions, a BOM information worksheet, an optional material information worksheet and a configuration table, the processing unit reads and executes computer instructions to receive ECR process attachments from the interface unit and implements the method for adding component materials to the module BOM.
[0049] Example 3
[0050] An embodiment of the present invention provides a storage medium for implementing a method for adding component materials to a module BOM. The storage medium stores a computer program. When the computer program is executed by a processor, the method for adding component materials to a module BOM is implemented.
[0051] In the embodiments provided by the present invention, it should be understood that the disclosed structures and methods can be implemented in other ways. For example, the structural embodiments described above are only schematic. For example, the division of the units is only a logical function division. There may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be an indirect coupling or communication connection through some interfaces, structures or units, which can be electrical, mechanical or other forms.
[0052] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
[0053] In addition, each functional unit in each embodiment of the present invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above-mentioned integrated unit may be implemented in the form of hardware or in the form of software functional units.
[0054] The foregoing is merely a specific embodiment of the present invention, which enables those skilled in the art to understand or implement the present invention. Various modifications to these embodiments will be apparent to those skilled in the art, and the general principles defined herein may be implemented in other embodiments without departing from the spirit or scope of the present invention. Therefore, the present invention will not be limited to the embodiments shown herein, but rather to the widest scope consistent with the principles and novel features claimed herein.
Claims
1. A method for adding component materials to a module BOM, characterized in that: include: Construct an ECR process attachment, which includes the material specification level code of the changed material, the material module level code to which the material specification level code belongs, and the similarity value of the corresponding material specification level code; Among them, flags are configured in both the material specification level code and the characteristic code, and the characteristic code exists in the optional material information worksheet; based on the flag in the material specification level code in the ECR process attachment, the flag in the characteristic code in the optional material information worksheet is matched, and the material specification level code in the ECR process attachment is non-repeatedly mounted under the matched characteristic code; Based on the material module-level code in the ECR process attachment, the corresponding material module-level code is matched in the BOM information worksheet, and the material specification-level code subordinate to the material module-level code in the ECR process attachment is added to the matched material module-level code in the BOM information worksheet without duplication. Then, each material specification-level code and its matched characteristic code are used to automatically create the conditional statement and quantity calculation statement of the material specification-level code; Based on the similar values and characteristic codes of the corresponding material specification level codes in the ECR process attachment, the material specification level codes are added non-repeatedly to the characteristic codes corresponding to the matching restriction relationship grouping of the similar values in the configuration table.
2. The method for adding component materials to module BOM according to claim 1, characterized in that: The optional material information worksheet contains the material specification level codes of the optional materials and the characteristic codes to which the material specification level codes belong. The materials corresponding to the material specification level codes under each characteristic code constitute the product. The characteristic code includes the product line number, product model number, disk location number, serial code and flag bit.
3. The method for adding component materials to module BOM according to claim 1, characterized in that: The BOM information worksheet records the module BOM code, material module-level code, material specification-level code, bring-out conditional statements and quantity calculation statements for each material. When using the optional material information worksheet to build a product, the bring-out conditional statement can bring out the corresponding material specification-level code from the BOM information worksheet according to the characteristic code in the optional material information worksheet, and the quantity calculation statement gives the quantity of the material corresponding to the optional material specification-level code.
4. The method for adding component materials to module BOM according to claim 1, characterized in that: The configuration table includes at least two characteristic codes and the matching restriction relationships between materials corresponding to the material specification level codes mounted under each characteristic code. Each group of matching restriction relationships is separated by a separator, and a terminator is configured after the final matching restriction relationship group.
5. The method for adding component materials to module BOM according to claim 4, characterized in that: The similar value is already in the BOM information worksheet, and according to the product design plan, it is the material specification level code of any material of the same type and with the same matching relationship as the material specification level code corresponding to the similar value in the ECR process attachment; the material specification level code corresponding to the similar value in the ECR process attachment is added to the separator or terminator after the matching restriction relationship grouping of the similar value in the configuration table.
6. The method for adding component materials to module BOM according to claim 1, characterized in that: Before adding the added material specification level code to the optional material information worksheet, BOM information worksheet and configuration table, check whether the added material specification level code exists in the corresponding table, otherwise the added material specification level code is added to the corresponding table.
7. The method for adding component materials to module BOM according to claim 1, characterized in that: Use each material specification level code and its matching characteristic code to automatically create a carry-out conditional statement for the material specification level code. Use each material specification level code to automatically create a quantity calculation statement, including: copying the "carry-out conditional statement" and "quantity calculation statement" of the last material specification level code under the current material module level code, pasting them into the "carry-out conditional statement" and "quantity calculation statement" fields of the added material specification level code, and replacing the original material specification level code with the current material specification level code.
8. The method for adding component materials to module BOM according to claim 1, characterized in that: Before updating the module BOM according to the ECR process attachment, check whether the similar values in the ECR process attachment exist in the BOM information worksheet. If not, a prompt will be given for abnormal similar values of the ECR process attachment.
9. A device for adding component materials to a module BOM, characterized in that: include: A processing unit, a storage unit, a bus unit and an interface unit, wherein the processing unit, the interface unit and the storage unit are connected via a bus, the storage unit stores computer instructions, a BOM information worksheet, an optional material information worksheet and a configuration table, the processing unit reads and executes computer instructions to receive ECR process attachments from the interface unit and implements a method for adding component materials to a module BOM as claimed in any one of claims 1-8.
10. A storage medium for implementing a method for adding component materials to a module BOM, wherein the storage medium stores a computer program, characterized in that: When the computer program is executed by a processor, the method for adding component materials to a module BOM as claimed in any one of claims 1-8 is implemented.
