BOM effective date capture method, system, BOM order update method

Abstract

The present invention relates to the technical field of bill of materials, and discloses a BOM effective date capture method, system, and BOM order update method. The method comprises the following steps: determining a target BOM; configuring a BOM screening library; traversing the BOM screening library, screening out all BOMs containing creator information, and defining them as benchmark BOMs; drawing a generalized benchmark ellipse according to the number of benchmark BOMs and the creation date of the benchmark BOMs; drawing a generalized benchmark ellipse according to the number of benchmark BOMs and the creation date of the benchmark BOMs; obtaining a benchmark BOM cluster from the BOM screening library based on the BOM number similarity matching as a criterion; determining the creator information offset and creation date information offset of the target BOM and each BOM in the benchmark BOM cluster; determining the offset point coordinates in the generalized benchmark ellipse according to the creator information offset and the creation date information offset, and drawing a deviation circle with a radius of r with the offset point coordinates as the center of the circle; generating the effective date of the target BOM based on the effective date of the order number of the BOM with the highest matching degree.

Description

Technical Field

[0001] The present invention belongs to the technical field of bill of materials, and in particular relates to a BOM effective date capture method, system, and BOM order update method. Background Art

[0002] The Bill of Materials (BOM) is an important document used to describe the composition of a product. The BOM contains all the components, raw materials, effective dates, order dates, etc. of the product. The BOM can be organized in a hierarchical structure, from the top-level final assembly product to the bottom-level raw materials, to clearly show the composition relationship and structure of the product.

[0003] In actual operations, it is found that a BOM has errors and needs to be updated. Although the BOM has an order number, the order number may be wrong. At this time, the effective date cannot be determined by the wrong order number. Therefore, it is urgent to propose a method that can automatically and accurately capture the effective date. In addition, there may be update errors in the effective date of the historically updated BOM. In view of this, it is also necessary to apply the method of capturing the effective date to correct the updated effective date. Summary of the invention

[0004] The purpose of the present invention is to provide a BOM effective date capture method, system, and BOM order update method, which are used to automatically and accurately capture the effective date of the target BOM when the BOM that needs to be updated and the effective date reset cannot accurately confirm the order effective date due to an error in the order number or the absence of an order number, thereby ensuring that the target BOM is successfully updated.

[0005] In a first aspect, the present invention provides a method for capturing a BOM effective date, comprising the following steps:

[0006] Determine the target BOM. The target BOM is a BOM without an order number. The target BOM has a BOM number, but no other BOMs have the same order number as the target BOM. The target BOM has creator information and creation date information.

[0007] Configure a BOM screening library, which includes multiple BOMs. Each BOM has a BOM number and an order number. Each BOM includes multiple sub-items. Each sub-item has information about the creator of the sub-item and the date on which the sub-item was created.

[0008] Traverse the BOM screening library and filter out all BOMs containing creator information, which are defined as benchmark BOMs; draw a generalized benchmarking ellipse based on the number of benchmark BOMs and the creation date of the benchmark BOMs;

[0009] Obtain the corresponding BOM cluster from the BOM screening library based on the BOM number similarity matching criterion;

[0010] Determine the creator information offset and creation date information offset of the target BOM and each BOM in the benchmark BOM cluster;

[0011] Determine the offset point coordinates in the generalized alignment ellipse based on the creator information offset and the creation date information offset, and draw a deviation circle with a radius of r with the offset point coordinates as the center. The value of r is the absolute value of the difference between the number of BOMs created by the creator and the number of BOMs associated with the creator in the BOM screening library. The BOM with the largest overlap area between the deviation circle and the generalized alignment ellipse in the current BOM cluster is taken as the BOM with the highest matching degree.

[0012] Generate the effective date of the target BOM based on the effective date of the order number of the BOM with the highest matching degree.

[0013] As a possible implementation, a generalized alignment ellipse is drawn as follows:

[0014] Determine the major axis a of the generalized alignment ellipse, a=(number of alignment BOMs / 10)+1;

[0015] Determine the minor axis b of the generalized ellipse, b=e -q +1, q is the creation date of the target BOM;

[0016] Draw a generalized alignment ellipse based on the major axis a and the minor axis b.

[0017] As a possible implementation, the creator information offset x is determined as follows: x = ((total number of sub-items - number of items where the sub-item creator is the creator) / total number of sub-items) × a;

[0018] The creation date information offset y is determined as follows: y = ((sub-item creation month - target BOM creation month) / average value of sub-item creation months in the benchmark BOM cluster) × b.

[0019] As a possible implementation method, the BOM number includes N digits, and the corresponding BOM cluster is obtained from the BOM screening library based on the BOM number similarity matching criterion, which specifically includes the following steps:

[0020] Take X consecutive digits as the screening items, X<N;

[0021] Group BOMs with the same filter items into benchmark BOM clusters.

[0022] As a possible implementation, the number of X digits is obtained as follows:

[0023] S10. Configure initial X, 3<X<N;

[0024] S11. Determine one by one whether the overlapping area of ​​the deviation circle of the BOM corresponding to the X-digit digital filter item in the BOM filter library and the generalized reference ellipse is less than the percentage threshold of the area of ​​the generalized reference ellipse; if so, execute S12; if not, execute S13;

[0025] S12. Reduce the number of digits by X, and then return to S11 after the number of digits reaches X-1. The loop ends when X-1=3;

[0026] S13. Update X, where the overlap area of ​​the deviation circle of the BOM corresponding to the updated X-digit digital filter item and the generalized reference ellipse is greater than the percentage threshold of the area of ​​the generalized reference ellipse.

[0027] As a possible implementation, the X-digit code is used as the filter item by the following method:

[0028] S20. Configure initial X, X=3;

[0029] S21. Determine one by one whether the overlapping area of ​​the deviation circle of the BOM corresponding to the X-digit digital filter item in the BOM filter library and the generalized reference ellipse is less than the percentage threshold of the area of ​​the generalized reference ellipse; if so, execute S22; if not, execute S23;

[0030] S22. Keep the X value unchanged, adjust the position of the X-digit code and return to S21;

[0031] S23. Update X, where the overlap area of ​​the deviation circle of the BOM corresponding to the updated X-digit digital filter item and the generalized reference ellipse is greater than the percentage threshold of the area of ​​the generalized reference ellipse.

[0032] As a possible implementation method, when all BOMs corresponding to continuous three-digit filter items are polled and no BOM is found whose overlapping area between the deviation circle and the generalized benchmark ellipse is greater than or equal to the percentage threshold of the generalized benchmark ellipse, continuous two-digit numbers are configured as filter items, and the BOMs corresponding to the filter items with the same continuous two-digit numbers are divided into corresponding BOM clusters.

[0033] In a second aspect, the present invention further provides a BOM effective date capture system, comprising:

[0034] The target BOM determination unit is used to determine the target BOM. The target BOM is a BOM without an order number. The target BOM has a BOM number, but no other BOMs have the same order number as the target BOM. The target BOM has creator information and creation date information.

[0035] A BOM screening library storage unit is configured with a BOM screening library, wherein the BOM screening library includes multiple BOMs, each BOM has a BOM number, and each BOM includes multiple sub-items, and each sub-item has sub-item creator information and sub-item creation date information;

[0036] The generalized benchmarking ellipse drawing unit traverses the BOM screening library, filters out all BOMs containing creator information, and defines them as benchmarking BOMs; draws the generalized benchmarking ellipse according to the number of benchmarking BOMs and the creation date of the benchmarking BOMs;

[0037] Benchmark BOM cluster division units, and obtain benchmark BOM clusters from the BOM screening library based on BOM number similarity matching criteria;

[0038] An offset calculation unit determines the creator information offset and creation date information offset between the target BOM and each BOM in the benchmark BOM cluster;

[0039] The BOM matching degree determination unit determines the offset point coordinates in the generalized benchmarking ellipse according to the creator information offset and the creation date information offset, and draws a deviation circle with a radius of r with the offset point coordinates as the center. The value of r is the absolute value of the difference between the number of BOMs of the creator and the number of BOMs of the associated person in the BOM screening library. The BOM with the largest overlap area between the deviation circle and the generalized benchmarking ellipse in the current BOM cluster is taken as the BOM with the highest matching degree.

[0040] The effective date determination unit generates an effective date of the target BOM based on the effective date of the order number of the BOM with the highest matching degree.

[0041] In a third aspect, the present invention further provides a BOM order updating method, comprising the following steps:

[0042] S30. Determine the BOM to be updated;

[0043] S31. Determine whether the BOM to be updated has an order number. If so, the BOM is not updated; if not, the BOM is defined as the target BOM and S32 is executed;

[0044] S32. Determine whether there is a benchmark BOM with the same number as the target BOM in the BOM screening library. If so, generate the effective date of the target BOM according to the order number of the benchmark BOM. If not, execute S33;

[0045] S33. Apply the BOM effective date capture method provided in the first aspect to obtain the effective date of the target BOM.

[0046] In a fourth aspect, the present invention further provides a BOM order updating terminal, which executes the BOM order updating method provided in the third aspect.

[0047] Compared with the prior art, the present invention has the following effects:

[0048] 1. When the target BOM has no order number or contains error information that needs to be updated and the updated effective date needs to be determined, the BOM effective date capture method provided by the present invention can be used to automatically and accurately match the BOM that is closest or similar to the target BOM, and directly assign the effective date of the BOM with the highest similarity to the target BOM, so as to realize automatic and accurate update of the error information and effective date of the target BOM.

[0049] 2. The BOM effective date capture method provided by the present invention can also correct the effective date of the historically updated BOM, that is, the BOM effective date capture method provided by the present invention is applied to traverse all BOMs, and when it is found that the effective date of the historically updated BOM is inconsistent with the currently determined effective date, the operator can be reminded whether to update according to the currently determined effective date. Based on this, the historically updated wrong effective date can be corrected.

[0050] 3. The BOM effective date capture method provided by the present invention constructs a BOM screening library, and based on the creator of the target BOM, screens out all BOMs including the creator and each sub-item whose creator is the same as the creator of the target BOM from the BOM screening library to obtain a benchmark BOM. On this basis, a generalized benchmarking ellipse is drawn using the number of items and creation dates of multiple benchmarking BOMs. When looking for other BOMs with the highest matching degree with the target BOM, the center of the generalized benchmarking ellipse is used as the only reference point. Based on this, the benchmarking BOM cluster is determined from the BOM screening library based on the order number similarity matching criterion. The creator information offset and creation date information offset of each BOM in the benchmarking BOM cluster and the target BOM are determined one by one. According to the creator information offset and creation date information offset, the offset point coordinates are determined in the generalized reference ellipse, and the offset point coordinates are used as the center to draw a deviation circle with a radius of r, where r is the absolute value of the difference between the number of creator BOMs and the number of associated BOMs in the BOM screening library; the BOM with the largest overlap area between the deviation circle and the generalized reference ellipse in the current BOM cluster is taken as the BOM with the highest matching degree, and its effective date is directly assigned to the target BOM. In view of this, when capturing the effective date, the creator information and creation date information of the target BOM are integrated, as well as the BOM number, sub-item creator information, sub-item creation date information in the BOM screening library to identify the BOM with the highest correlation or the highest matching degree, so that users can obtain the relevant BOM number more intelligently and accurately, thereby capturing the effective date with high accuracy. BRIEF DESCRIPTION OF THE DRAWINGS

[0051] The drawings described herein are used to provide further understanding of the present invention and constitute a part of the present invention. The exemplary embodiments of the present invention and their descriptions are used to explain the present invention and do not constitute improper limitations on the present invention.

[0052] Figure 1 A flowchart of a BOM effective date capture method provided by an embodiment of the present invention;

[0053] Figures 2 to 5 A schematic diagram of a generalized alignment ellipse and a deviation circle provided in an embodiment of the present invention; wherein, Figure 2 It is a schematic diagram of the maximum overlap area between the deviation circle and the reference ellipse; Figure 3 The generalized reference ellipse and the deviation circle have no deviation in the x-axis direction and have deviation in the y-axis direction; Figure 4 The generalized reference ellipse and the deviation circle have deviations in the x-axis direction and no deviations in the y-axis direction; Figure 5 There are deviations between the generalized reference ellipse and the deviation circle in both the x-axis and y-axis directions;

[0054] Figure 6 A flowchart of a BOM order updating method provided in an embodiment of the present invention. DETAILED DESCRIPTION

[0055] In order to clearly describe the technical solutions of the embodiments of the present invention, in the embodiments of the present invention, words such as "first" and "second" are used to distinguish the same items or similar items with basically the same functions and effects. For example, the first threshold and the second threshold are only used to distinguish different thresholds, and their order is not limited. Those skilled in the art can understand that words such as "first" and "second" do not limit the quantity and execution order, and words such as "first" and "second" do not necessarily limit them to be different.

[0056] It should be noted that, in the present invention, words such as "exemplary" or "for example" are used to indicate examples, illustrations or descriptions. Any embodiment or design described as "exemplary" or "for example" in the present invention should not be interpreted as being more preferred or more advantageous than other embodiments or designs. Specifically, the use of words such as "exemplary" or "for example" is intended to present related concepts in a specific way.

[0057] In the present invention, "at least one" means one or more, and "plurality" means two or more. "And / or" describes the association relationship of associated objects, indicating that three relationships may exist. For example, A and / or B can mean: A exists alone, A and B exist at the same time, and B exists alone, where A and B can be singular or plural. The character " / " generally indicates that the objects associated before and after are in an "or" relationship. "At least one of the following" or similar expressions refers to any combination of these items, including any combination of single or plural items. For example, at least one of a, b or c can mean: a, b, c, the combination of a and b, the combination of a and c, the combination of b and c, or the combination of a, b and c, where a, b, c can be single or multiple.

[0058] See also Figure 1 The embodiment of the present invention provides a method for capturing the BOM effective date, comprising the following steps:

[0059] S10. Determine the target BOM, which is a BOM without an order number. The target BOM has a BOM number, but no other BOMs have the same order number as the target BOM. The target BOM has creator information and creation date information.

[0060] In actual applications, BOMs with incorrect order numbers can also be checked. For example, if one of the BOMs has an incorrect order number 1050100019 (the order number is redundant), it is necessary to capture the BOM corresponding to the correct order number 105010001 with a higher matching degree and assign the effective date of the BOM to the target BOM.

[0061] It needs to be further explained that the target BOM without order number has a unique BOM number. There may be other BOMs with the same number (here the number is the BOM number, not the order number) as the target BOM in the entire product library. If the other BOM has an order number, the effective date of the BOM with the order number will be directly assigned to the target BOM. If the BOM with the same number also has no order number, S11 to S15 need to be executed.

[0062] S11. Configure a BOM screening library, the BOM screening library includes multiple BOMs, each BOM has a BOM number and an order number, and each BOM includes multiple sub-items, each sub-item has sub-item creator information and sub-item creation date information.

[0063] It needs further explanation that the BOM number refers to the unique number of the product within the company. The order number is the number of the order received when the product is sold.

[0064] As an example, a BOM may be a row of data in an Excel table, which includes multiple sub-items. Each sub-item may specifically be a product structure, order code, material quantity, sub-item creator, sub-item creation date, sub-item effective date, etc.

[0065] S12. Traverse the BOM screening library and filter out all BOMs containing creator information, which are defined as benchmark BOMs; draw a generalized benchmark ellipse based on the number of benchmark BOMs and the creation date of the benchmark BOM. The generalized benchmark ellipse can be an ellipse with unequal major and minor axes, or a perfect circle with equal major and minor axes. The generalized benchmark ellipse is drawn in the following way:

[0066] S120. Determine the major axis a of the generalized alignment ellipse, a=(number of aligned BOM items / 10)+1. For example, if the number of aligned BOM items is 20, a=3.

[0067] S121. Determine the minor axis b of the generalized ellipse, b=e -q +1. q is the creation date of the target BOM.

[0068] S122. Draw a generalized alignment ellipse based on the determined a and b.

[0069] S13. Obtaining a benchmark BOM cluster from the BOM screening library based on BOM number similarity matching as a criterion, specifically comprising the following sub-steps: taking X consecutive digits as screening items, X<N; and dividing BOMs with the same screening items into the benchmark BOM cluster.

[0070] For example, for a target BOM numbered 1050100019, the first X digits can be intercepted, where X can be 4, 5, or 6, that is, "1050", "10501", or "105010" can be intercepted as a filter item, and the BOMs that meet the above filter items can be filtered out from the BOM filter library to form a benchmark BOM cluster. For example, 10 BOMs that meet the filter items are filtered out. Based on the creator information of the aforementioned target BOM, continue to filter the BOM with the highest matching degree with the target BOM in the BOM cluster.

[0071] Get the X digits by the following method:

[0072] S10. Configure initial X, 3<X<N;

[0073] S11. Determine one by one whether the overlapping area of ​​the deviation circle of the BOM corresponding to the X-digit digital filter item in the BOM filter library and the generalized reference ellipse is less than the percentage threshold of the area of ​​the generalized reference ellipse; if so, execute S12; if not, execute S13;

[0074] S12. Reduce the number of digits by X, that is, return to S11 when the number of digits reaches X-1, and terminate the loop when X-1=3;

[0075] S13. Update X, where the overlap area of ​​the deviation circle of the BOM corresponding to the updated X-digit digital filter item and the generalized reference ellipse is greater than the percentage threshold of the area of ​​the generalized reference ellipse.

[0076] As an embodiment, the X-digit code is selected as the filter item by the following method:

[0077] S100. Configure the initial X, 3<X<N; for example, "1050100019", the initial X-digit code is configured to be "10501".

[0078] S110. Determine one by one whether the overlapping area of ​​the deviation circle of the BOM corresponding to the X-digit digital filter item in the BOM filter library and the generalized reference ellipse is less than the percentage threshold of the area of ​​the generalized reference ellipse; if so, execute S111; if not, execute S112;

[0079] S111. After reducing the position of the X-digit code, return to S110; for example, the reduced X-digit code is "05010".

[0080] S112. Update X, that is, the final X-digit code is updated from the initial "10501" to "05010".

[0081] The loop terminates when X-1=3.

[0082] As a second embodiment, the X digits are obtained by the following method:

[0083] S20. Configure initial X, X=3;

[0084] S21. Determine one by one whether the overlapping area of ​​the deviation circle of the BOM corresponding to the X-digit digital filter item in the BOM filter library and the generalized reference ellipse is less than the percentage threshold of the area of ​​the generalized reference ellipse; if so, execute S22; if not, execute S23;

[0085] S22. Keep the X value unchanged, adjust the position of the X-digit code and return to S21;

[0086] S23. Update X, where the overlap area of ​​the deviation circle of the BOM corresponding to the updated X-digit digital filter item and the generalized reference ellipse is greater than the percentage threshold of the area of ​​the generalized reference ellipse.

[0087] When the continuous X-digit digital filter item is 3, and all BOMs corresponding to the continuous 3-digit filter items are polled, and no BOM is found whose overlapping area between the deviation circle and the generalized benchmark ellipse is greater than or equal to the percentage threshold of the generalized benchmark ellipse, then continuous two-digit numbers are configured as filter items, and the BOMs corresponding to the filter items with the same continuous two-digit numbers are divided into corresponding BOM clusters.

[0088] For example, when X=3, and still not found, configure two consecutive two-digit numbers as matching objects. In other words, two consecutive two-digit numbers can be used as matching objects. For example, the original number is 123454321. At this time, 12xxxxx21 and x23xxxx21 are also considered to be matched successfully.

[0089] S14. Determine the creator information offset and creation date information offset of each BOM in the target BOM and the benchmark BOM cluster. Determine the creator information offset x by the following method: x = ((total number of sub-items - number of items for which the sub-item creator is the creator) / total number of sub-items) × a. Determine the creation date information offset y by the following method: y = ((sub-item creation month - target BOM creation month) / total number of sub-items) × b.

[0090] S15. Determine the offset point coordinates in the generalized benchmarking ellipse based on the creator information offset and the creation date information offset, and draw a deviation circle with a radius of r with the offset point coordinates as the center. The value of r is the absolute value of the difference between the number of BOMs of the creator and the number of BOMs of the associated person in the BOM screening library. The BOM with the largest overlap area between the deviation circle and the generalized benchmarking ellipse in the current BOM cluster is taken as the BOM with the highest matching degree. Among them, the database pre-stores the association relationship between the associated person and the creator. For example, the project leader is the creator, and all the team members of the leader are associated persons. Similarly, the team members are the creators and the team leader is the associated person.

[0091] According to the above logic, each BOM in the benchmarking BOM cluster corresponds to a deviation circle, and the BOM with the largest intersection area between the deviation circle and the generalized benchmarking ellipse is selected as the BOM with the highest matching degree with the target BOM in the BOM cluster.

[0092] See also Figures 2 to 5 ,in, Figure 2 It means that there is no deviation in the x-axis and y-axis directions. At this time, the overlapping area between the deviation circle and the reference ellipse is the largest, that is, the deviation between the BOM corresponding to the deviation circle and the target BOM is the smallest. In other words, this BOM has the highest matching degree with the target BOM. Figure 3 It means that there is no deviation in the x-axis direction and there is deviation in the y-axis direction; Figure 4 It means that there is deviation in the x-axis direction and no deviation in the y-axis direction; Figure 5It means that there is deviation in both the x-axis and y-axis directions. The BOM corresponding to the deviation circle with the largest overlap area with the reference ellipse is selected.

[0093] S16. Generate the effective date of the target BOM based on the order number of the BOM with the highest matching degree.

[0094] When the target BOM has error information that needs to be updated and the effective date of the update needs to be determined, the BOM effective date capture method provided by the present invention can be used to automatically and accurately match the BOM that is closest to or similar to the target BOM, and directly assign the effective date of the BOM with the highest similarity to the target BOM, so as to achieve automatic and accurate update of the target BOM error information and effective date.

[0095] The BOM effective date capture method provided by the present invention can also correct the effective date of the historically updated BOM, that is, the BOM effective date capture method provided by the present invention is applied to traverse all BOMs. When it is found that the effective date of the historical update of the BOM is inconsistent with the currently determined effective date, the operator can be reminded whether to update according to the currently determined effective date. Based on this, the effective date of the historical update error can be corrected. For example, an order number (1050100019) has a redundant BOM, and its actual effective date is May 5, 2024, and its order date is May 10, 2024. On May 15, 2024, an error is found somewhere and the BOM needs to be changed. After the BOM is updated, the effective date is reset to May 15, 2024, resulting in the failure of the order content update of the BOM. In view of the above situation, the BOM with the order number 1050100019 can be defined as the target BOM, that is, the BOM whose effective date needs to be re-determined. In view of this, all BOMs with the "10501" filter item are filtered out in the BOM filtering library, and then the BOM effective date capture method provided in the embodiment of the present invention is applied to first match the closest BOM, and then the effective date corresponding to the closest BOM is assigned to the target BOM to correct the effective date of the historical erroneous update.

[0096] The BOM effective date capture method provided by the present invention constructs a BOM screening library, and based on the creator of the target BOM, screens out all BOMs including the creator and each sub-item whose creator is the same as the creator of the target BOM from the BOM screening library to obtain a benchmark BOM. On this basis, a generalized benchmark ellipse is drawn using the number of items and creation dates of multiple benchmark BOMs. When looking for other BOMs with the highest matching degree with the target BOM, the center of the generalized benchmark ellipse is used as the only reference point. Based on this, a benchmark BOM cluster is determined from the BOM screening library based on the order number similarity matching criterion. Determine the creator information offset and creation date information offset of each BOM in the benchmark BOM cluster and the target BOM one by one. According to the creator information offset and creation date information offset, the offset point coordinates are determined in the generalized reference ellipse, and the offset point coordinates are used as the circle point to draw a deviation circle with a radius of r. The value of r is the absolute value of the difference between the number of BOMs created by the creator or sub-item creator in the BOM screening library and the number of BOMs created by the creator in the current BOM cluster. The BOM with the largest overlap area between the deviation circle in the current BOM cluster and the generalized reference ellipse is taken as the BOM with the highest matching degree, and its effective date is directly assigned to the target BOM. In view of this, when capturing the effective date, the creator information and creation date information of the target BOM, as well as the BOM number, sub-item creator information, sub-item creation date information, etc. in the BOM screening library are integrated to identify the BOM with the highest correlation or the highest matching degree, so that users can obtain the relevant BOM number more intelligently and accurately, thereby capturing the effective date with high accuracy.

[0097] In a second aspect, the present invention further provides a BOM effective date capture system, comprising:

[0098] The target BOM determination unit is used to determine the target BOM. The target BOM is a BOM without an order number. The target BOM has a BOM number, but no other BOMs have the same order number as the target BOM. The target BOM has creator information and creation date information.

[0099] A BOM screening library storage unit is configured with a BOM screening library, wherein the BOM screening library includes multiple BOMs, each BOM has a BOM number, and each BOM includes multiple sub-items, and each sub-item has sub-item creator information and sub-item creation date information;

[0100] The generalized benchmarking ellipse drawing unit traverses the BOM screening library, filters out all BOMs containing creator information, and defines them as benchmarking BOMs; draws the generalized benchmarking ellipse according to the number of benchmarking BOMs and the creation date of the benchmarking BOMs;

[0101] Benchmark BOM cluster division units, and obtain benchmark BOM clusters from the BOM screening library based on BOM number similarity matching criteria;

[0102] An offset calculation unit determines the creator information offset and creation date information offset between the target BOM and each BOM in the benchmark BOM cluster;

[0103] The BOM matching degree determination unit determines the offset point coordinates in the generalized benchmarking ellipse according to the creator information offset and the creation date information offset, and draws a deviation circle with a radius of r with the offset point coordinates as the center. The value of r is the absolute value of the difference between the number of BOMs of the creator and the number of BOMs of the associated person in the BOM screening library. The BOM with the largest overlap area between the deviation circle and the generalized benchmarking ellipse in the current BOM cluster is taken as the BOM with the highest matching degree.

[0104] The effective date determination unit generates an effective date of the target BOM based on the effective date of the order number of the BOM with the highest matching degree.

[0105] In a third aspect, the present invention also provides a BOM order update method, such as Figure 6 As shown, the following steps are included:

[0106] S30. Determine the BOM to be updated;

[0107] S31. Determine whether the BOM to be updated has an order number. If so, the BOM is not updated; if not, the BOM is defined as the target BOM and S32 is executed;

[0108] S32. Determine whether there is a benchmark BOM with the same number as the target BOM in the BOM screening library. If so, generate the effective date of the target BOM according to the order number of the benchmark BOM. If not, execute S33;

[0109] S33. Apply the BOM effective date capture method provided in the first aspect to obtain the effective date of the target BOM.

[0110] In a fourth aspect, the present invention further provides a BOM order updating terminal, which executes the BOM order updating method of the third aspect.

[0111] In a fifth aspect, the present invention further provides a computer-readable storage medium, comprising a processor and a communication interface coupled to the processor, wherein the processor is used to run a computer program or instruction to implement the BOM order update method of the third aspect.

[0112] Although the present invention is described herein in conjunction with various embodiments, in the process of implementing the claimed invention, those skilled in the art may understand and implement other variations of the disclosed embodiments by viewing the drawings, the disclosure, and the drawings, etc. In the specification, the word "comprising" does not exclude other components or steps, and "one" or "an" does not exclude multiple situations. A single processor or other unit can implement several functions listed in the specification. Certain measures are recorded in different embodiments, but this does not mean that these measures cannot be combined to produce good results.

[0113] Although the present invention has been described in conjunction with specific features and embodiments thereof, it is apparent that various modifications and combinations may be made thereto without departing from the spirit and scope of the present invention. Accordingly, this specification and the accompanying drawings are merely exemplary illustrations of the present invention and are deemed to cover any and all modifications, variations, combinations or equivalents within the scope of the present invention. Obviously, those skilled in the art may make various modifications and variations to the present invention without departing from the spirit and scope of the present invention. Thus, the present invention is intended to include such modifications and variations as fall within the scope of the technology to which the present invention relates and its equivalents.

Claims

1. A method for capturing the BOM effective date, characterized in that: The steps include: Determine the target BOM. The target BOM is a BOM without an order number. The target BOM has a BOM number, but no other BOMs have the same order number as the target BOM. The target BOM has creator information and creation date information; Configure a BOM screening library, which includes multiple BOMs. Each BOM has a BOM number and an order number. Each BOM includes multiple sub-items. Each sub-item has information about the creator of the sub-item and the date on which the sub-item was created. Traverse the BOM screening library and filter out all BOMs containing creator information, which are defined as benchmark BOMs; Draw a generalized benchmarking ellipse based on the number of items in the benchmarking BOM and the creation date of the benchmarking BOM; Obtain the corresponding BOM cluster from the BOM screening library based on the BOM number similarity matching criterion; Determine the creator information offset and creation date information offset of the target BOM and each BOM in the benchmark BOM cluster; Determine the offset point coordinates in the generalized alignment ellipse based on the creator information offset and the creation date information offset, and draw a deviation circle with a radius of r with the offset point coordinates as the center. The value of r is the absolute value of the difference between the number of BOMs created by the creator and the number of BOMs associated with the creator in the BOM screening library. The BOM with the largest overlap area between the deviation circle and the generalized alignment ellipse in the current BOM cluster is taken as the BOM with the highest matching degree. Generate the effective date of the target BOM based on the effective date of the order number of the BOM with the highest matching degree.

2. The BOM effective date capture method according to claim 1, characterized in that: Draw a generalized alignment ellipse as follows: Determine the major axis a of the generalized alignment ellipse, a=(number of alignment BOM items / 10)+1; Determine the minor axis b of the generalized ellipse, b=e -q +1, q is the creation date of the target BOM; Draw a generalized alignment ellipse based on the major axis a and the minor axis b.

3. The BOM effective date capture method according to claim 2, characterized in that: The creator information offset x is determined as follows: x = ((total number of sub-items - number of items where the sub-item creator is the creator) / total number of sub-items) × a; The creation date information offset y is determined in the following way: y = ((sub-item creation month - target BOM creation month) / average value of sub-item creation months in the benchmark BOM cluster) × b.

4. The BOM effective date capture method according to claim 1, characterized in that: The BOM number includes N digits. The matching BOM cluster is obtained from the BOM screening library based on the BOM number similarity matching criterion. The specific steps include the following: Take X consecutive digits as the screening items, X<N; Group BOMs with the same filter items into benchmark BOM clusters.

5. The BOM effective date capture method according to claim 4 is characterized in that: Get the X digits by the following method: S10. Configure initial X, 3<X<N; S11. Determine one by one whether the overlap area of ​​the deviation circle of the BOM corresponding to the X-digit digital filter item in the BOM screening library and the generalized reference ellipse is less than the percentage threshold of the area of ​​the generalized reference ellipse; If yes, execute S12; if no, execute S13; S12. Reduce the number of digits by X, and then return to S11 after the number of digits reaches X-1. The loop ends when X-1=3; S13. Update X, where the overlap area between the deviation circle of the BOM corresponding to the updated X-digit digital filter item and the generalized reference ellipse is greater than the percentage threshold of the area of ​​the generalized reference ellipse.

6. The BOM effective date capture method according to claim 4, characterized in that: Use the following method to select X digits as filter items: S20. Configure initial X, X=3; S21. Determine one by one whether the overlapping area of ​​the deviation circle of the BOM corresponding to the X-digit digital filter item in the BOM filter library and the generalized reference ellipse is less than the percentage threshold of the area of ​​the generalized reference ellipse; if so, execute S22; if not, execute S23; S22. Keep the X value unchanged, adjust the position of the X-digit code and return to S21; S23. Update X, where the overlap area of ​​the deviation circle of the BOM corresponding to the updated X-digit digital filter item and the generalized reference ellipse is greater than the percentage threshold of the area of ​​the generalized reference ellipse.

7. The BOM effective date capture method according to claim 5, characterized in that: When all BOMs corresponding to the filter items with consecutive three digits are polled and no BOM is found whose overlapping area between the deviation circle and the generalized benchmark ellipse is greater than or equal to the percentage threshold of the generalized benchmark ellipse, consecutive two digits are configured as filter items, and the BOMs corresponding to the filter items with the same consecutive two digits are divided into corresponding BOM clusters.

8. A BOM effective date capture system, characterized in that: include: The target BOM determination unit is used to determine the target BOM. The target BOM is a BOM without an order number. The target BOM has a BOM number, but no other BOM has the same order number as the target BOM. The target BOM has creator information and creation date information; A BOM screening library storage unit is configured with a BOM screening library, wherein the BOM screening library includes multiple BOMs, each BOM has a BOM number, and each BOM includes multiple sub-items, and each sub-item has sub-item creator information and sub-item creation date information; The generalized benchmarking ellipse drawing unit traverses the BOM screening library, filters out all BOMs containing creator information, and defines them as benchmarking BOMs; draws the generalized benchmarking ellipse according to the number of benchmarking BOMs and the creation date of the benchmarking BOMs; Benchmark BOM cluster division units, and obtain benchmark BOM clusters from the BOM screening library based on BOM number similarity matching criteria; An offset calculation unit determines the creator information offset and creation date information offset between the target BOM and each BOM in the benchmark BOM cluster; The BOM matching degree determination unit determines the offset point coordinates in the generalized benchmarking ellipse according to the creator information offset and the creation date information offset, and draws a deviation circle with a radius of r with the offset point coordinates as the center. The value of r is the absolute value of the difference between the number of BOMs of the creator and the number of BOMs of the associated person in the BOM screening library. The BOM with the largest overlap area between the deviation circle and the generalized benchmarking ellipse in the current BOM cluster is taken as the BOM with the highest matching degree. The effective date determination unit generates an effective date of the target BOM based on the effective date of the order number of the BOM with the highest matching degree.

9. A BOM order update method, characterized in that: The steps include: S30. Determine the BOM to be updated; S31. Determine whether the BOM to be updated has an order number. If so, the BOM is not updated; if not, the BOM is defined as the target BOM and S32 is executed; S32. Determine whether there is a benchmark BOM with the same number as the target BOM in the BOM screening library. If so, generate the effective date of the target BOM according to the order number of the benchmark BOM. If not, execute S33; S33. Apply the BOM effective date capture method described in any one of claims 1 to 7 to obtain the effective date of the target BOM.

10. A BOM order update terminal, characterized in that: The BOM order updating terminal executes the BOM order updating method described in claim 9.

Images