CN115063069A - Method, device, server and medium for modularization BOM - Google Patents
Method, device, server and medium for modularization BOM Download PDFInfo
- Publication number
- CN115063069A CN115063069A CN202210614664.1A CN202210614664A CN115063069A CN 115063069 A CN115063069 A CN 115063069A CN 202210614664 A CN202210614664 A CN 202210614664A CN 115063069 A CN115063069 A CN 115063069A
- Authority
- CN
- China
- Prior art keywords
- mixed insertion
- bom
- component
- rule
- material number
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Withdrawn
Links
- 238000000034 method Methods 0.000 title claims abstract description 57
- 238000003780 insertion Methods 0.000 claims abstract description 217
- 230000037431 insertion Effects 0.000 claims abstract description 214
- 238000004590 computer program Methods 0.000 claims description 12
- 238000002156 mixing Methods 0.000 claims 2
- 238000012384 transportation and delivery Methods 0.000 abstract description 4
- WYDFSSCXUGNICP-CDLQDMDJSA-N C[C@@H]([C@H]1CC[C@H]2[C@@H]3[C@@H]4O[C@@H]4[C@@]4(O)CC=CC(=O)[C@]4(C)[C@H]3CC[C@]12C)[C@H]1C[C@]2(C)O[C@]2(C)C(O)O1 Chemical compound C[C@@H]([C@H]1CC[C@H]2[C@@H]3[C@@H]4O[C@@H]4[C@@]4(O)CC=CC(=O)[C@]4(C)[C@H]3CC[C@]12C)[C@H]1C[C@]2(C)O[C@]2(C)C(O)O1 WYDFSSCXUGNICP-CDLQDMDJSA-N 0.000 description 9
- 238000012545 processing Methods 0.000 description 8
- 101100388291 Arabidopsis thaliana DTX49 gene Proteins 0.000 description 6
- 101100268840 Danio rerio chrna1 gene Proteins 0.000 description 6
- 101150065731 NIC1 gene Proteins 0.000 description 6
- PWHVEHULNLETOV-UHFFFAOYSA-N Nic-1 Natural products C12OC2C2(O)CC=CC(=O)C2(C)C(CCC2=C3)C1C2=CC=C3C(C)C1OC(O)C2(C)OC2(C)C1 PWHVEHULNLETOV-UHFFFAOYSA-N 0.000 description 6
- 238000010586 diagram Methods 0.000 description 6
- 230000008569 process Effects 0.000 description 5
- 238000012423 maintenance Methods 0.000 description 4
- 230000009471 action Effects 0.000 description 3
- 230000000694 effects Effects 0.000 description 3
- WYDFSSCXUGNICP-UHFFFAOYSA-N 24-methylenecholesta-5,7-dien-3beta-ol Natural products C1C2(C)OC2(C)C(O)OC1C(C)C1C2(C)CCC3C4(C)C(=O)C=CCC4(O)C4OC4C3C2CC1 WYDFSSCXUGNICP-UHFFFAOYSA-N 0.000 description 2
- 101100388299 Arabidopsis thaliana DTX54 gene Proteins 0.000 description 2
- 101100388300 Arabidopsis thaliana DTX55 gene Proteins 0.000 description 2
- 101100294133 Arabidopsis thaliana NIC2 gene Proteins 0.000 description 2
- 101100294134 Arabidopsis thaliana NIC3 gene Proteins 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- GWWNCLHJCFNTJA-UHFFFAOYSA-N nicandrenone-2 Natural products C12OC2C2(O)CC=CC(=O)C2(C)C(CCC23C)C1C3CCC2(O)C(C)C1OC(O)C2(C)OC2(C)C1 GWWNCLHJCFNTJA-UHFFFAOYSA-N 0.000 description 2
- 238000013473 artificial intelligence Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000013479 data entry Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000010801 machine learning Methods 0.000 description 1
- 230000005055 memory storage Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000013439 planning Methods 0.000 description 1
- 238000001907 polarising light microscopy Methods 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 238000009877 rendering Methods 0.000 description 1
- 230000001052 transient effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/04—Manufacturing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Economics (AREA)
- General Physics & Mathematics (AREA)
- Tourism & Hospitality (AREA)
- Theoretical Computer Science (AREA)
- General Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Quality & Reliability (AREA)
- Development Economics (AREA)
- Operations Research (AREA)
- Entrepreneurship & Innovation (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Manufacturing & Machinery (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application discloses a method, a device, a server and a medium for modularization BOM, and relates to the technical field of servers. The method comprises the following steps: acquiring a BOM data architecture table; wherein, the BOM data structure table at least comprises a product number, a module material number, a specification material number and a mixed insertion attribute; generating a component characteristic table according to the BOM data architecture table; the component characteristic table comprises a mixed insertion characteristic table of a mixed insertion component and a characteristic table of a non-mixed insertion component; generating an output rule according to the component characteristic table; and sending the component characteristic table and the output rule to the ERP for ordering. Therefore, the mixed insertion configuration of the components is realized through the method, and the diversification of the delivery requirements is realized; in addition, the list error rate can be reduced through the limitation of the output rule, and the requirements of users are met.
Description
Technical Field
The present application relates to the field of server technologies, and in particular, to a method, an apparatus, a server, and a medium for a modular BOM.
Background
The Bill Of Material (BOM) refers to the modular management Of general product components, and generally, modules (e.g., a memory module, a hard disk module, a network card module, a motherboard module, etc.) can be constructed according to the requirements Of assembling final products. The modular process is a process of decomposing a product into low-level modules, and is generally used for a complex series of products made of many common components and having various combinations.
In an actual business scenario, there may be a configuration requirement for a mixed insertion component, that is, materials of different specifications of the same module are used in a matching manner. However, at present, only materials with the same specification are allowed to be used in the same module, and the configuration requirements of mixed insertion components in various actual business scenes cannot be met.
Therefore, how to meet the configuration requirements of the mixed insertion component in various actual service scenes is a problem to be solved urgently by the technical personnel in the field.
Disclosure of Invention
The application aims to provide a method, a device, a server and a medium for modularized BOM, which are used for meeting the configuration requirements of mixed insertion components existing in various actual service scenes.
In order to solve the above technical problem, the present application provides a method of a modular BOM, including:
acquiring a BOM data architecture table; wherein, the BOM data structure table at least comprises a product number, a module material number, a specification material number and a mixed insertion attribute;
generating a component characteristic table according to the BOM data architecture table; the component characteristic table comprises a mixed insertion characteristic table of a mixed insertion component and a characteristic table of a non-mixed insertion component;
generating an output rule according to the component characteristic table;
and sending the component characteristic table and the output rule to ERP for ordering.
Preferably, the generating the component characteristic table according to the BOM data architecture table includes:
determining the quantity of mixed insertion according to the mixed insertion attribute in the BOM data architecture table;
when the mixed insertion quantity is 0, acquiring the characteristics of the non-mixed insertion part and adding a specification material number corresponding to the characteristics of the non-mixed insertion part to the non-mixed insertion characteristics to generate a characteristic table of the non-mixed insertion part;
and when the mixed insertion quantity is not 0, acquiring mixed insertion characteristics, and adding a specification number corresponding to the characteristics of the mixed insertion part to the mixed insertion characteristics to generate a characteristic table of the mixed insertion part.
Preferably, the BOM data architecture table further comprises: the number of the specification material numbers is selectable;
correspondingly, the component characteristic table further comprises: a quantitative feature corresponding to each characteristic.
Preferably, the output rule includes: the output condition rule of the specification material number and the output quantity rule of the specification material number;
the output condition rule of the specification material number is to output the characteristic and the corresponding specification material number under the condition that the characteristic is equal to the preset specification material number;
and the output quantity rule of the specification material number is to acquire the quantity characteristic corresponding to the characteristic under the condition of meeting the output condition rule of the rule material number.
Preferably, the insertion characteristic table of the insertion component further includes: a mixed insertion mark; and the same mixed insertion mark is arranged on the same mixed insertion part.
Preferably, the output rule further includes: a constraint between the mixed insertion characteristics belonging to the same mixed insertion component;
the limiting condition is that different specification material numbers are selected for the mixed insertion characteristics in the same mixed insertion part.
Preferably, the sending the component characteristic table and the output rule to the ERP for ordering includes:
sending the mixed insertion characteristic table in the component characteristic table, the output condition rule of the specification material number in the output rule, the output quantity rule of the specification material number and the limit condition between the mixed insertion characteristics belonging to the same mixed insertion component to the ERP for ordering;
and sending the characteristic table of the non-mixed insertion part in the part characteristic table, the output condition rule of the specification material number in the output rule and the output quantity rule of the specification material number to the ERP for ordering.
In order to solve the above technical problem, the present application further provides an apparatus of a modular BOM, including:
the acquisition module is used for acquiring a BOM data architecture table; wherein, the BOM data structure table at least comprises a product number, a module material number, a specification material number and a mixed insertion attribute;
the first generation module is used for generating a component characteristic table according to the BOM data architecture table; the component characteristic table comprises a mixed insertion characteristic table of a mixed insertion component and a characteristic table of a non-mixed insertion component;
the second generation module is used for generating an output rule according to the component characteristic table;
and the sending module is used for sending the component characteristic table and the output rule to the ERP for ordering.
In order to solve the above technical problem, the present application further provides a server, including:
a memory for storing a computer program;
a processor for implementing the steps of the method of the modular BOM described above when executing the computer program.
In order to solve the above technical problem, the present application further provides a computer-readable storage medium, on which a computer program is stored, and the computer program, when executed by a processor, implements the steps of the method of modular BOM described above.
The method of the modular BOM provided by the application comprises the following steps: acquiring a BOM data architecture table; wherein, the BOM data structure table at least comprises a product number, a module material number, a specification material number and a mixed insertion attribute; generating a component characteristic table according to the BOM data architecture table; the component characteristic table comprises a mixed insertion characteristic table of a mixed insertion component and a characteristic table of a non-mixed insertion component; generating an output rule according to the component characteristic table; and sending the component characteristic table and the output rule to the ERP for ordering. Therefore, the mixed insertion configuration of the components is realized through the method, and the diversification of the delivery requirements is realized; in addition, the list error rate can be reduced through the limitation of the output rule, and the requirements of users are met.
In addition, the application also provides a device, a server and a computer readable storage medium of the modular BOM, which have the same or corresponding technical characteristics and effects as the above mentioned method of the modular BOM.
Drawings
In order to more clearly illustrate the embodiments of the present application, the drawings required for the embodiments will be briefly described below, and it is obvious that the drawings in the following description are only some embodiments of the present application, and that other drawings may be obtained by those skilled in the art without inventive effort.
FIG. 1 is a flow chart of a method of modular BOM according to an embodiment of the present disclosure;
fig. 2 is a schematic diagram of a BOM structure in a PLM according to an embodiment of the present disclosure;
FIG. 3 is a block diagram of an apparatus of a modular BOM provided in an embodiment of the present application;
FIG. 4 is a block diagram of a server according to another embodiment of the present application;
fig. 5 is a flowchart of an implementation method for automatically adding a hybrid add-drop module to a modular BOM according to an embodiment of the present application.
Detailed Description
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all the embodiments. All other embodiments obtained by a person of ordinary skill in the art based on the embodiments in the present application without any creative effort belong to the protection scope of the present application.
The core of the application is to provide a method, a device, a server and a medium for modular BOM, which are used for meeting the configuration requirements of mixed insertion components existing in various actual service scenes.
A Bill Of Materials (BOM) is a list Of all children that are made up. A modular BOM is a hierarchical BOM that is distinct from a tiled BOM. The material composing the product is divided into a plurality of modules, such as a memory module, a hard disk module, a network card module, a mainboard module and the like, all the modules form a complete modular BOM, each module comprises a plurality of different specifications, and different specifications can be selected under different product configurations. For example, the server supports 12 hard disks, and hard disks with different specifications, such as 16T, 8T and 4T hard disks, can be used in a matched manner, so that a great amount of cost is saved finally. Therefore, in order to meet the configuration requirements of the mixed insertion component in various actual service scenes, the scheme of the application realizes that the mixed insertion module is automatically added into the modular BOM.
In order that those skilled in the art will better understand the disclosure, the following detailed description will be given with reference to the accompanying drawings. Fig. 1 is a flowchart of a method of a modular BOM according to an embodiment of the present disclosure, and as shown in fig. 1, the method includes:
s10: acquiring a BOM data architecture table; wherein the BOM data structure table at least comprises a product number, a module material number, a specification material number and a mixed insertion attribute.
BOM maintenance personnel maintain information such as products, modules, specifications, mixed insertion attributes and the like by creating a BOM data architecture table in a PLM (Product Lifecycle Management). Fig. 2 is a schematic diagram of a BOM structure in a PLM provided in an embodiment of the present application. As shown in fig. 2, the modular BOM is BOM data having a hierarchical structure, and is a BOM framework composed of a product level, a module level, a specification level, and the like. The module order represents the property and the specification order represents the property value. Take 3 kinds of mixed insertion of network cards with different specifications G1/G2/G3/G4 in BOM of product Z as an example. BOM maintainers apply for the material numbers of each layer. Suppose that the applied network card module has the material number of B-NIC-000, the specification G1 has the material number of G-NIC-001, the specification G2 has the material number of G-NIC-002, the specification G3 has the material number of G-NIC-003, the specification G4 has the material number of G-NIC-004, and the code of the Product Z is Product 000. And maintaining the material number applied by the BOM maintenance personnel in a form BOM data architecture table under the product folder. Table 1 is a BOM data architecture table. As shown in table 1, the table contains a Level: the product order is 1, the module order is 2, and the specification order is 3. The product, module, specification number and description are maintained in a form by hierarchy. In the table, the optional quantities 0-N are maintained according to the actual product conditions; filling in the matching name of the module, which needs to be embodied at the front end, for example, the name of the option of the matching interface in table 1 is a network card; fill in whether to interpolate the attribute, such as table 1, whether to interpolate 3. It should be noted that the BOM data architecture table in table 1 is only created by taking a network card as an example, in practice, a server is usually composed of a plurality of components, and the BOM data architecture table constituting each component including the server is created according to the data construction table in table 1.
TABLE 1 BOM data architecture Table
S11: generating a component characteristic table according to the BOM data architecture table; the component characteristic table comprises a mixed insertion characteristic table of mixed insertion components and a characteristic table of non-mixed insertion components.
And the PLM system automatically generates a component characteristic table based on the specific information in the BOM data architecture table created by the BOM maintainer in the steps. Since some components of the components constituting the server need to be inserted in a mixed manner and some components do not need to be inserted in a mixed manner, the finally formed component property table includes a mixed insertion property table of the mixed insertion components and a property table of the non-mixed insertion components. When the component characteristic table is established according to the BOM data architecture table, the PLM system determines the quantity of mixed insertion and establishes the corresponding characteristic according to whether the attribute data of the mixed insertion exist in the BOM data architecture table, and determines the characteristic name according to the option name of the matching interface in the BOM data architecture table. The mixed insertion characteristic table of the mixed insertion component and the characteristic table of the non-mixed insertion component may form a component characteristic table in the same table. In implementation, in order to distinguish the mixed insertion part from the non-mixed insertion part in the part characteristic table, a mixed insertion flag may be set, and whether the parts are mixed or not may be determined according to the mixed insertion flag.
Taking the BOM data architecture table in table 1 as an example, the PLM system automatically generates a component property table, which may also be referred to as Loadsheet, based on specific information in the BOM data architecture table created by a BOM maintainer. As the number of mixed insertions is 3 in table 1, a new feature with a new feature name of a network card 1/2/3 is created, and a NIC is marked at the mixed insertion mark; the material numbers of four specifications of a network card specification G1/G2/G3/G4 are respectively added into 1/2/3 characteristics. The number in Loadsheet is created from the optional numbers in table 1. Finally, property information of Loadsheet is generated, as shown in table 2. Table 2 is a part characteristic table.
TABLE 2 parts characteristic Table
Table 2 is a component characteristic table created by taking a network card as an example, and in implementation, a server is generally composed of a plurality of components, and characteristics of other components in the server are created in a manner of creating network card characteristics in table 2, so as to form a component characteristic table of the entire server.
S12: an output rule is generated from the component property table.
After adding the specification property values to the properties, the PLM automatically generates output rules for the module specification.
S13: and sending the component characteristic table and the output rule to the ERP for ordering.
Opening an Enterprise Resource Planning (ERP) system interface and a PLM system interface. And the PLM system sends the component characteristic table and the output rule to the ERP for ordering through the interface.
The method for the modular BOM provided by the embodiment comprises the following steps: acquiring a BOM data architecture table; wherein, the BOM data structure table at least comprises a product number, a module material number, a specification material number and a mixed insertion attribute; generating a component characteristic table according to the BOM data architecture table; the component characteristic table comprises a mixed insertion characteristic table of a mixed insertion component and a characteristic table of a non-mixed insertion component; generating an output rule according to the component characteristic table; and sending the component characteristic table and the output rule to the ERP for ordering. Therefore, the mixed insertion configuration of the components is realized through the method, and the diversification of the delivery requirements is realized; in addition, the list error rate can be reduced through the limitation of the output rule, and the requirements of users are met.
In implementation, in order to include configuration requirements of each component of the server in the component property table, preferably, the generating the component property table according to the BOM data architecture table includes:
determining the quantity of mixed insertion according to the mixed insertion attribute in the BOM data architecture table;
under the condition that the mixed insertion quantity is 0, acquiring the characteristics of the non-mixed insertion part and adding a specification material number corresponding to the characteristics of the non-mixed insertion part to the non-mixed insertion characteristics to generate a characteristic table of the non-mixed insertion part;
and when the mixed insertion number is not 0, acquiring mixed insertion characteristics, adding a specification number corresponding to the characteristics of the mixed insertion part to the mixed insertion characteristics to generate a characteristic table of the mixed insertion part.
When the mixed insertion number of a certain part forming the server in the BOM data architecture table is 0, the part is not mixed and inserted, namely, the part is not mixed and inserted, and the part is not mixed and inserted by using the same specification material number; when the mixed insertion number of a certain part forming the server in the BOM data architecture table is not 0, the part is indicated to have mixed insertion, namely a mixed insertion part, and material numbers with different specifications are used for the mixed insertion part. For the mixed insertion component and the non-mixed insertion component, it is necessary to form a component characteristic table constituting the server by adding the specification number to the corresponding characteristic.
The specification material numbers of the mixed insertion component and the non-mixed insertion component are added into the corresponding characteristics, so that all components forming the server can be included, and a complete material list is finally formed.
In the implementation, a user may need a plurality of parts with the same specification number of the same part, and therefore, it is preferable that the BOM data architecture table further includes: the optional number of specification material numbers;
correspondingly, the component characteristics table further includes: a quantitative feature corresponding to each characteristic.
The optional numbers in table 1 are 0-N, and the number of N is not limited and is determined according to actual conditions. Correspondingly, when the component property table in table 2 is established according to the BOM data architecture table in table 1, the network card 2, and the network card 3 are respectively represented by Product000_ NIC1_ QTY, Product000_ NIC2_ QTY, and Product000_ NIC3_ QTY, and the corresponding numbers are 0 to N.
The BOM data architecture table provided in this embodiment further includes the selectable number of the specification part numbers, and the maximum number that can be selected for part numbers of various scales can be known through the BOM data architecture table, so that whether the requirement is met can be determined according to the maximum number; in addition, since the component characteristic table further includes a quantity feature corresponding to each characteristic, the quantity corresponding to each component characteristic can be known from the component characteristic table.
In the implementation, in order to bring out the specification material numbers and the quantity more accurately, the preferred embodiment is that the output rule includes: the output condition rule of the specification material number and the output quantity rule of the specification material number;
the output condition rule of the specification material number is that the characteristic and the corresponding specification material number are output under the condition that the characteristic is equal to the preset specification material number;
the output quantity rule of the specification material number is to obtain quantity characteristics corresponding to the characteristics under the condition that the output condition rule of the rule material number is met.
The PLM system generates an output condition rule of the specification number and an output number rule of the specification number based on the component characteristic table of table 2. Taking the structure of adding the specification material number of the network card G-NIC-001 into the module material number B-NIC-000 as an example, the PLM automatically generates the output condition rule of the specification material number, namely, the selection condition, as shown in the formula (1), and the specification material number is brought out when any characteristic selects the characteristic value of the specification material number.
Product000_NIC1.equals("G-NIC-001")||Product000_NIC2.equals("G-NIC-001")||Product000_NIC3.equals("G-NIC-001") (1)
In the formula (1), when the feature 1, i.e., the Product000_ NIC1 wants to bring out the specification number G-NIC-001, the Product000_ NIC1 can only bring out the G-NIC-001 when the Product000_ NIC1.equals to the specification number G-NIC-001, and the feature 2, i.e., the Product000_ NIC2, and the feature 3, i.e., the Product000_ NIC3 are the same, and the description thereof is omitted.
The system generates output condition rules of the specification material numbers and also generates output quantity rules of the specification material numbers. The PLM automatically generates an output quantity rule of specification material numbers. The output quantity rule for the specification number uses a conditional operator (. The format is as follows: expression 1? Expression 2 expression 3. It is stated that if expression 1 is true, the result of the entire expression is the value of expression 2, and if expression false, the result of the entire expression is expression 3. Taking the example of adding the G-NIC-001 into the module B-NIC-000, the output quantity rule of the specification number is shown as the formula (2):
(Product000_NIC1.equals("G-NIC-001")?Product000_NIC1_QTY:0)+(Product000_NIC2.equals("G-NIC-001")?Product000_NIC2_QTY:0)+(Product000_NIC3.equals("G-NIC-001")?Product000_NIC3_QTY:0) (2)
firstly, judging whether specification material number G-NIC-001 is selected from the characteristic 1Product000_ NIC1, when the specification material number G-NIC-001 is selected from the characteristic 1Product000_ NIC1, firstly marking the number as the quantity characteristic of the characteristic 1, and if the specification material number G-NIC-001 is not selected from the characteristic 1Product000_ NIC1, firstly marking the number as 0; then judging whether the characteristic 2Product000_ NIC2 selects the specification material number G-NIC-001 or not, and acquiring the corresponding quantity characteristic; finally, whether the specification material number G-NIC-001 is selected by the characteristic 3Product000_ NIC3 is judged, and corresponding quantity characteristics are obtained; and the output quantity of the final specification material number is the sum of quantity characteristics obtained after each judgment is finished. The addition of G-NIC-001 to module B-NIC-000 is shown in Table 3.
TABLE 3G-NIC-001 Add Module B-NIC-000
Similarly, G-NIC-002/G-NIC-003/G-NIC-004 may also be added to module B-NIC-000 according to the logic of G-NIC-001.
The output rule provided by the embodiment includes: the output condition rule of the specification material number and the output quantity rule of the specification material number can accurately bring out the rule material number and the quantity through the output condition rule of the specification material number and the output quantity rule of the specification material number, and the configuration requirement of a user is met.
In order to realize that the PLM system can quickly identify the same group of characteristics among the characteristics in the whole BOM, it is preferable that the mixed insertion characteristic table of the mixed insertion component further includes: a mixed insertion mark; wherein the same mixed insertion part is provided with the same mixed insertion mark.
In the implementation, the selected mixed insertion mark is not limited, and the same mixed insertion mark is hooked behind the characteristics of the same mixed insertion characteristic group. The mixed insertion mark can be determined according to the name of the mixed insertion component, such as the mixed insertion mark column in the component characteristic table, for the mixed insertion of the network card, the NIC is hung behind the network card characteristic 1/2/3 to represent the mixed insertion of the network card; if there is a mixed insertion in the hard disk, the HDD is attached after the hard disk characteristic 1/2/3, representing the mixed insertion of the hard disk. The interpolation mark is also directly indicated by a number, and the selected number is not limited. However, in order to make the different components constituting the server distinguishable, different mix-insertion flags may be used for the different components, for example, the mix-insertion flag of the network card is denoted by numeral 1, and the mix-insertion flag of the hard disk is denoted by numeral 2.
The established mixed insertion mark table further comprises mixed insertion marks, different mixed insertion components can be quickly distinguished according to the mixed insertion marks, mixed insertion characteristics belonging to the same mixed insertion characteristic group can be quickly identified, and material configuration is convenient to carry out.
On the basis of the foregoing embodiment, in order to improve the accuracy of the front-end menu operator and achieve that materials of the same specification cannot be selected in different mixed insertion characteristics, preferably, the output rule further includes: a constraint between the mixed insertion characteristics belonging to the same mixed insertion component;
wherein, the limiting condition is that different specification material numbers are selected for each mixed insertion characteristic in the same mixed insertion part.
The mixed insertion flag is used for enabling the PLM system to quickly identify the same group of characteristics in a plurality of characteristics in the whole BOM. If the mixed insertion flag bits are the same, the mutual mixed insertion characteristic set is indicated. And the PLM edits the limit words of the identified mixed insertion characteristic group, namely the limit conditions among the mixed insertion characteristics belonging to the same mixed insertion part. The limiting conditions are as follows, where the "< >" symbol is not equal.
(1) Such as characteristics a and B if 2 types are mixed. The constraint relationship is: self.A < > B;
(2) for example, if there are 3 kinds of interpolation, the characteristic A/B/C is obtained. The constraint relationship is: self.A < > B; self.B < > C; self.C. A;
(3) for example, if there are 4 kinds of mixed insertion, the characteristic A/B/C/D is obtained. The constraint relationship is: self.A < > B; self.A < > C; self.A < > D; self.B < > C; self.B < > D; self.C < > D;
according to the limiting conditions, different specification material numbers are selected for the mixed insertion characteristics in the same mixed insertion part. Taking the network card in the above implementation as an example, the limiting conditions are as follows:
(1) two kinds of mixed insertion:
PRODUCT000_NIC1<>PRODUCT000_NIC2
(2) three kinds of mixed insertion:
PRODUCT000_NIC1<>PRODUCT000_NIC2;
PRODUCT000_NIC1<>PRODUCT000_NIC3;
PRODUCT000_NIC2<>PRODUCT000_NIC3;
(3) four kinds of mixed insertion:
PRODUCT000_NIC1<>PRODUCT000_NIC2;
PRODUCT000_NIC1<>PRODUCT000_NIC3;
PRODUCT000_NIC1<>PRODUCT000_NIC4;
PRODUCT000_NIC2<>PRODUCT000_NIC3
PRODUCT000_NIC2<>PRODUCT000_NIC4
PRODUCT000_NIC3<>PRODUCT000_NIC4
therefore, when two types of mixed insertion are carried out, the specification material number selected by the mixed insertion characteristic 1 cannot be the same as the specification material number selected by the mixed insertion characteristic 2; when three types of mixed insertion are carried out, the material number selected by the mixed insertion characteristic 1 cannot be the same as the material number selected by the mixed insertion characteristic 2, and the material number selected by the mixed insertion characteristic 2 cannot be the same as the material number selected by the mixed insertion characteristic 3; during four mixed interpolation, the material number selected by the mixed interpolation characteristic 1 cannot be the same as the material number selected by the mixed interpolation characteristic 2, the material number selected by the mixed interpolation characteristic 1 cannot be the same as the material number selected by the mixed interpolation characteristic 3, and the material number selected by the mixed interpolation characteristic 1 cannot be the same as the material number selected by the mixed interpolation characteristic 4; the specification material number selected by the mixed insertion characteristic 2 cannot be … … the same as the specification material number selected by the mixed insertion characteristic 3, namely after a certain mixed insertion characteristic selects the specification material number, other mixed insertion characteristics can only be selected from the rest specification material numbers, and the requirements of mixed insertion parts are fully met.
The output rule provided by this embodiment further includes: a constraint between the mixed insertion characteristics belonging to the same mixed insertion component; the limiting condition is that different specification material numbers are selected for each mixed insertion characteristic in the same mixed insertion part, so that the condition that the same specification material cannot be selected on different mixed insertion characteristics is realized, and the accuracy of front-end menu personnel is improved through the limiting condition.
In the above embodiment, the component characteristic table and the output condition are obtained, and in order to quickly place an order for the configuration, it is preferable that sending the component characteristic table and the output rule to the ERP for placing an order includes:
sending the mixed insertion characteristic table in the component characteristic table, the output condition rule of the specification material number in the output rule, the output quantity rule of the specification material number and the limiting condition between the mixed insertion characteristics belonging to the same mixed insertion component to the ERP for ordering;
and sending the characteristic table of the non-mixed insertion part in the part characteristic table, the output condition rule of the specification material number in the output rule and the output quantity rule of the specification material number to the ERP for ordering.
In order to fully meet the mixed insertion requirement, for the components with mixed insertion marks in the component characteristic table, the mixed insertion characteristic table in the component characteristic table, the output condition rule of the specification material numbers in the output rule, the output quantity rule of the specification material numbers and the limiting conditions among the mixed insertion characteristics belonging to the same mixed insertion component are sent to ERP for ordering; for a component without a mixed insertion mark in the component characteristic table, the mixed insertion limiting condition does not need to be output to the ERP, and only the characteristic table of the non-mixed insertion component in the component characteristic table, the output condition rule of the specification material number in the output rule and the output quantity rule of the specification material number need to be sent to the ERP for ordering.
The mixed insertion component and the non-mixed insertion component provided by the embodiment adopt different ordering modes, so that quick ordering can be realized, and the calculated amount of a system is reduced; and because the ERP can make a quick decision after data processing, when data entry is completed, the system can automatically integrate corresponding reports, manual processing is not needed, and rapid ordering of configuration is realized.
In the above embodiments, detailed descriptions are given to a method of a modular BOM, and the present application also provides embodiments corresponding to a device and a server of the modular BOM. It should be noted that the present application describes the embodiments of the apparatus portion from two perspectives, one from the perspective of the function module and the other from the perspective of the hardware.
Fig. 3 is a block diagram of a device of a modular BOM according to an embodiment of the present disclosure. The present embodiment is based on the angle of the function module, including:
an obtaining module 10, configured to obtain a BOM data architecture table; wherein, the BOM data structure table at least comprises a product number, a module material number, a specification material number and a mixed insertion attribute;
a first generating module 11, configured to generate a part property table according to the BOM data architecture table; the component characteristic table comprises a mixed insertion characteristic table of a mixed insertion component and a characteristic table of a non-mixed insertion component;
a second generating module 12, configured to generate an output rule according to the component characteristic table;
and a sending module 13, configured to send the component characteristic table and the output rule to the ERP for ordering.
Since the embodiments of the apparatus portion and the method portion correspond to each other, please refer to the description of the embodiments of the method portion for the embodiments of the apparatus portion, which is not repeated here.
In the apparatus for modularizing a BOM provided in this embodiment, a BOM data architecture table is obtained through an obtaining module; wherein, the BOM data structure table at least comprises a product number, a module material number, a specification material number and a mixed insertion attribute; generating a component characteristic table according to the BOM data architecture table through a first generation module; the component characteristic table comprises a mixed insertion characteristic table of a mixed insertion component and a characteristic table of a non-mixed insertion component; generating an output rule according to the component characteristic table through a second generation module; and sending the component characteristic table and the output rule to the ERP for ordering through a sending module. Therefore, the mixed insertion configuration of the components is realized through the device, and the diversification of the delivery requirements is realized; in addition, the order error rate can be reduced through the limitation of the output rule, and the requirements of users are met.
Fig. 4 is a block diagram of a server according to another embodiment of the present application. This embodiment is based on a hardware perspective, and as shown in fig. 4, the server includes:
a memory 20 for storing a computer program;
a processor 21 for implementing the steps of the method of modular BOM as mentioned in the above embodiments when executing the computer program.
The server provided by the embodiment may include, but is not limited to, a smart phone, a tablet computer, a notebook computer, or a desktop computer.
The processor 21 may include one or more processing cores, such as a 4-core processor, an 8-core processor, and the like. The Processor 21 may be implemented in hardware using at least one of a Digital Signal Processor (DSP), a Field-Programmable Gate Array (FPGA), and a Programmable Logic Array (PLA). The processor 21 may also include a main processor and a coprocessor, where the main processor is a processor for Processing data in an awake state, and is also called a Central Processing Unit (CPU); a coprocessor is a low power processor for processing data in a standby state. In some embodiments, the processor 21 may be integrated with a Graphics Processing Unit (GPU) which is responsible for rendering and drawing the content required to be displayed by the display screen. In some embodiments, the processor 21 may further include an Artificial Intelligence (AI) processor for processing computational operations related to machine learning.
The memory 20 may include one or more computer-readable storage media, which may be non-transitory. Memory 20 may also include high speed random access memory, as well as non-volatile memory, such as one or more magnetic disk storage devices, flash memory storage devices. In this embodiment, the memory 20 is at least used for storing the following computer program 201, wherein after being loaded and executed by the processor 21, the computer program can implement the relevant steps of the method of the modular BOM disclosed in any of the foregoing embodiments. In addition, the resources stored in the memory 20 may also include an operating system 202, data 203, and the like, and the storage manner may be a transient storage manner or a permanent storage manner. Operating system 202 may include, among other things, Windows, Unix, Linux, etc. Data 203 may include, but is not limited to, data related to the methods of modular BOM mentioned above, and the like.
In some embodiments, the server may also include a display screen 22, an input-output interface 23, a communication interface 24, a power supply 25, and a communication bus 26.
Those skilled in the art will appreciate that the architecture shown in FIG. 4 is not meant to be limiting of servers and may include more or fewer components than those shown.
The server provided by the embodiment of the application comprises a memory and a processor, and when the processor executes a program stored in the memory, the following method can be realized: the effect of the modularized BOM method is the same as that of the modularized BOM method.
Finally, the application also provides a corresponding embodiment of the computer readable storage medium. The computer-readable storage medium has stored thereon a computer program which, when being executed by a processor, carries out the steps as set forth in the above-mentioned method embodiments.
It is to be understood that if the method in the above embodiments is implemented in the form of software functional units and sold or used as a stand-alone product, it can be stored in a computer readable storage medium. Based on such understanding, the technical solutions of the present application may be embodied in the form of a software product, which is stored in a storage medium and executes all or part of the steps of the methods described in the embodiments of the present application, or all or part of the technical solutions. And the aforementioned storage medium includes: various media capable of storing program codes, such as a usb disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk.
The computer-readable storage medium provided by the present application includes the above-mentioned method of modular BOM, and the effects are the same as above.
In order to make those skilled in the art better understand the technical solution of the present application, the above-mentioned present application is further described in detail with reference to fig. 5, fig. 5 is a flowchart of an implementation method for automatically adding a pluggable module to a modular BOM according to an embodiment of the present application, and as shown in fig. 5, the method includes:
s14: building products, modules, specifications and frameworks;
s15: creating characteristics and maintaining mixed insertion marks;
s16: judging whether a mixed insertion mark exists or not; if yes, go to step S17; if not, go to step S18;
s17: the PLM sends the architecture of each level, the carrying-out condition, the mixed insertion limiting condition and the like to the ERP through the interface;
s18: the PLM sends the hierarchical architecture and the bringing-out condition to the ERP through the interface.
It should be noted that each hierarchical structure here is a component characteristic table in the above embodiment.
BOM maintenance personnel maintain information such as products, modules, specifications, mixed insertion attributes and the like by creating forms in PLMs. Based on the forms, the PLM system automatically establishes Loadsheet, and the Loadsheet comprises a plurality of characteristics of the mixed insertion part, a corresponding module, a specification structure, a carrying-out condition and a quantity program. In addition, the Loadsheet comprises a mixed insertion mark column which is used for marking a plurality of characteristics of the mixed insertion module, so that the system can record different characteristics of the same module conveniently. The method comprises the steps that an ERP and PLM system interface is opened, and the PLM sends constraint condition statements between the same group of characteristics identified from Loadsheet, carrying-out conditions of modules and specifications and quantity conditions to the ERP, so that when ordering personnel place orders, configurations with different specifications can be accurately selected from the same module according to service scenes and customer requirements, and the configuration requirements of mixed insertion components in various actual service scenes are met; the method reduces manual menu errors and errors caused by BOM maintainers building BOMs and manually compiling limit statements, and reduces the menu error rate; the accuracy of front-end menu personnel is improved, the workload of BOM creation personnel is reduced, and the BOM maintenance accuracy and efficiency are improved.
The method, apparatus, server and medium for modular BOM provided by the present application are described in detail above. The embodiments are described in a progressive manner in the specification, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments are referred to each other. The device disclosed by the embodiment corresponds to the method disclosed by the embodiment, so that the description is simple, and the relevant points can be referred to the method part for description. It should be noted that, for those skilled in the art, it is possible to make several improvements and modifications to the present application without departing from the principle of the present application, and such improvements and modifications also fall within the scope of the claims of the present application.
It is further noted that, in the present specification, relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
Claims (10)
1. A method of modular BOM, comprising:
acquiring a BOM data architecture table; wherein, the BOM data structure table at least comprises a product number, a module material number, a specification material number and a mixed insertion attribute;
generating a component characteristic table according to the BOM data architecture table; the component characteristic table comprises a mixed insertion characteristic table of a mixed insertion component and a characteristic table of a non-mixed insertion component;
generating an output rule according to the component characteristic table;
and sending the component characteristic table and the output rule to ERP for ordering.
2. The method of modular BOM of claim 1, wherein the generating the part characteristics table from the BOM data architecture table comprises:
determining the quantity of mixed insertion according to the mixed insertion attribute in the BOM data architecture table;
under the condition that the mixed insertion quantity is 0, acquiring the characteristics of the non-mixed insertion part and adding a specification material number corresponding to the characteristics of the non-mixed insertion part to the non-mixed insertion characteristics to generate a characteristic table of the non-mixed insertion part;
and when the mixed insertion quantity is not 0, acquiring the mixed insertion characteristics, and adding a specification material number corresponding to the characteristics of the mixed insertion part to the mixed insertion characteristics to generate a characteristic table of the mixed insertion part.
3. The method of modular BOM of claim 2, wherein the BOM data architecture table further comprises: the number of the specification material numbers is selectable;
correspondingly, the component characteristic table further comprises: a quantitative feature corresponding to each characteristic.
4. The method of modular BOM of claim 3, wherein the output rule comprises: the output condition rule of the specification material number and the output quantity rule of the specification material number;
the output condition rule of the specification material number is to output the characteristic and the corresponding specification material number under the condition that the characteristic is equal to the preset specification material number;
and the output quantity rule of the specification material number is to acquire the quantity characteristic corresponding to the characteristic under the condition of meeting the output condition rule of the rule material number.
5. The method of modular BOM according to any one of claims 1 to 4, wherein the blending profile of the blending component further comprises: a mixed insertion mark; and the same mixed insertion part is provided with the same mixed insertion mark.
6. The method of modular BOM of claim 5, wherein the outputting the rules further comprises: a constraint condition between the mixed insertion characteristics belonging to the same mixed insertion component;
the limiting condition is that different specification material numbers are selected for the mixed insertion characteristics in the same mixed insertion part.
7. The method of modular BOM of claim 5, wherein sending the parts characteristics table and the output rules to ERP for ordering comprises:
sending the mixed insertion characteristic table in the component characteristic table, the output condition rule of the specification material number in the output rule, the output quantity rule of the specification material number and the limiting condition between the mixed insertion characteristics belonging to the same mixed insertion component to the ERP for ordering;
and sending the characteristic table of the non-mixed insertion part in the part characteristic table, the output condition rule of the specification material number in the output rule and the output quantity rule of the specification material number to the ERP for ordering.
8. An apparatus of a modular BOM, comprising:
the acquisition module is used for acquiring a BOM data architecture table; wherein, the BOM data structure table at least comprises a product number, a module material number, a specification material number and a mixed insertion attribute;
the first generation module is used for generating a component characteristic table according to the BOM data architecture table; the component characteristic table comprises a mixed insertion characteristic table of a mixed insertion component and a characteristic table of a non-mixed insertion component;
the second generation module is used for generating an output rule according to the component characteristic table;
and the sending module is used for sending the component characteristic table and the output rule to the ERP for ordering.
9. A server, comprising:
a memory for storing a computer program;
a processor for implementing the steps of the method of modular BOM of any one of claims 1 to 7 when executing said computer program.
10. A computer-readable storage medium, having stored thereon a computer program which, when executed by a processor, carries out the steps of the method of modular BOM according to any one of claims 1 to 7.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202210614664.1A CN115063069A (en) | 2022-05-31 | 2022-05-31 | Method, device, server and medium for modularization BOM |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202210614664.1A CN115063069A (en) | 2022-05-31 | 2022-05-31 | Method, device, server and medium for modularization BOM |
Publications (1)
Publication Number | Publication Date |
---|---|
CN115063069A true CN115063069A (en) | 2022-09-16 |
Family
ID=83198819
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202210614664.1A Withdrawn CN115063069A (en) | 2022-05-31 | 2022-05-31 | Method, device, server and medium for modularization BOM |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN115063069A (en) |
-
2022
- 2022-05-31 CN CN202210614664.1A patent/CN115063069A/en not_active Withdrawn
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US20210049711A1 (en) | Method of automatically transmitting data information and device of automatically transmitting data information | |
CN111506444A (en) | Form approval method and device, storage medium and electronic equipment | |
CN110543303B (en) | Visual service platform | |
US20080091780A1 (en) | Integrated secure mobile collaborative environment that facilitates structured data capture and communication | |
US20090244059A1 (en) | System and method for automatically generating virtual world environments based upon existing physical environments | |
CN102105862A (en) | Automatic user interface generation for entity interaction | |
CN101149737A (en) | Method for quickly establishing web form and automatically establishing corresponding data table in database through Microsoft Word | |
CN110880097A (en) | Project progress simulation display method and device | |
CN109614685A (en) | Construction based on BIM model is told somebody what one's real intentions are method, apparatus, equipment and mobile terminal | |
CN110968751B (en) | Dynamic display method and device for engineering project capital curve | |
CN111190814B (en) | Method and device for generating software test case, storage medium and terminal | |
CN116401407A (en) | Node attribute configuration method, device, equipment and storage medium of mind map | |
CN110930056A (en) | Thinking-guidance-graph-based task management method, terminal device and storage medium | |
CN115063069A (en) | Method, device, server and medium for modularization BOM | |
CN116301785A (en) | Method and device for realizing custom text editor component | |
CN115879435A (en) | Cloud contract generation method in intelligent engineering scene | |
CN114124977B (en) | Cross-tenant data sharing method and device and electronic equipment | |
CN115130442A (en) | Report generation method and device, storage medium and computer equipment | |
CN114564197A (en) | Method for distinguishing field authority according to service scene and computer readable storage medium | |
CN114398226A (en) | Network asset report generation method and device | |
CN113689198A (en) | Project file generation method and device, storage medium and terminal equipment | |
US7702643B2 (en) | System and method for metamodel-based gap analysis | |
US20080319780A1 (en) | Defining reports for dimension based enterprise resource planning systems | |
CN109857991A (en) | Date storage method, device and electronic equipment | |
CN115543969B (en) | Data migration method, device, equipment and medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
WW01 | Invention patent application withdrawn after publication |
Application publication date: 20220916 |
|
WW01 | Invention patent application withdrawn after publication |