CN101859405A - Method for synchronizing data between BOMs by utilizing implicit BOM model - Google Patents
Method for synchronizing data between BOMs by utilizing implicit BOM model Download PDFInfo
- Publication number
- CN101859405A CN101859405A CN201010138272A CN201010138272A CN101859405A CN 101859405 A CN101859405 A CN 101859405A CN 201010138272 A CN201010138272 A CN 201010138272A CN 201010138272 A CN201010138272 A CN 201010138272A CN 101859405 A CN101859405 A CN 101859405A
- Authority
- CN
- China
- Prior art keywords
- bom
- technology
- rule
- model
- data
- 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.)
- Pending
Links
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a method for synchronizing data between BOMs by utilizing an implicit BOM model, in particular to a realization method for synchronizing data between BOMs and production order process information by utilizing an implicit BOM model in the field of erp management software, which realizes the data synchronization among manufacturing BOM, process BOM and production order process information through the restriction of a synchronization rule. The synchronization rule is defined by users according to the actual needs in the use process, and a production order automatically forms the table information of the production order according to the defined rule and the process route information of products; conversely, a system forms a new-edition process BOM according to the new production order table information to be used for next scheduling, and the system presets up the synchronization rule of the manufacturing BOM and the process BOM, the synchronization rule of the process BOM and the production order and the data update rule of the process BOM; the change of the manufacturing BOM is predominant, and the rules are utilized to automatically form the implicit process BOM; and simultaneously, the synchronization rule of the process BOM and the production order process information is established so as to realize the synchronization of the data among the manufacturing BOM, the process BOM and the production order process information, so that the purchasing plan and the production plan are more accurate after the calculation of the MRP.
Description
Technical field
Patent of the present invention is to be used for a kind of implementation method of utilizing data between the synchronous BOM of implicit expression technology BOM model of ERP management software
Background technology
General foundation earlier made BOM in traditional erp software, the technology BOM that the back will be used in conjunction with product processing technique initialization plant working, the initialization initial stage, the data of the parts among two BOM are consistent, but along with making component number among the BOM according to changing or producing the order technique information and adjust according to field condition, the component number certificate of these variations and technique information need be embodied among the technology BOM, realize making BOM, technology BOM and produce the triangular data sync of order; But use in the software process in reality, because user's carelessness or workshop in-situ processing technology change, often cause triangular information inconsistency, cause the MRP operation result difference also to occur, finally influence the accuracy of the enterprise procurement plan and the production schedule.Therefore, in the method for the invention, by the master that is changed to manufacturing BOM, utilize rule to form the technology BOM of implicit expression automatically, the synchronization rules of also setting up simultaneously technology BOM and producing the order technique information, realize data synchronization between the three, thereby make the procurement plan and the production schedule after the MRP computing more accurate.
Summary of the invention
The purpose of this invention is to provide a kind of method of utilizing data between the synchronous BOM of implicit expression technology BOM model.
The objective of the invention is to realize in the following manner, this method comprises the following steps and content:
A, in operation system, set up implicit expression technology BOM model (seeing accompanying drawing 1) and attribute definition thereof: serial number, type, date, father's item material, father's item quantity, version number, process route numbering, operation, subitem material, attributes such as subitem quantity; This tables of data can not safeguard by hand that its content is produced automatically by system and safeguards.
B, in operation system, set up synchronization rules model (seeing accompanying drawing 2) and attribute definition thereof: rule number, stock number, rule description, rule value, default value; After list structure forms, carry out rule by system and preset;
Make BOM and technology BOM synchronization rules value and have two kinds: 1-is dosed into the operation that goes into operation, and 2-is dosed into completion procedures, and default value is 1.
Technology BOM and production order synchronization rules value have three kinds: 1-selects the technology BOM of latest edition, and 2-selects temporarily, and the technology BOM of 3-latest edition last month, default value are 1.
Technology BOM Data Update rule value has two kinds: 1-upgrades corresponding technology BOM according to producing order, and the 2nd, do not upgrade, default value is 1.
C, in operation system, set up to produce order model (seeing accompanying drawing 3) and attribute definition thereof:
Gauge outfit: produce the order serial number, the system phase in odd-numbered day, father's item material, father's item quantity is made the single attribute of Denging.
Table body: produce the order serial number, record separately serial number, operation, attributes such as subitem material, subitem quantity.
The implementation method of D, the concrete business by model instanceization, implementation method comprises 3 steps: (1) determines environment for use, selects IT technology and the instrument realized; (2) data structure of the example of design implicit expression technology BOM model, synchronization rules model and production order model description, the attribute of describing among data structure such as above-mentioned A, B, the C; (3) select suitable programming tool realization foreground and back-end data mutual, realize utilizing the data between the synchronous BOM of implicit expression technology BOM model.
At first when BOM is made in user's initialization, if the processing technology information of corresponding product is arranged, then when preserving, form new technology BOM according to the constraint of making BOM and technology BOM synchronization rules automatically, if making BOM occurs changing, then then revise the technology BOM of latest edition when revising, changing then as version forms the technology BOM of a redaction according to the technology BOM structure of the latest edition of correspondence.
Produce order when quoting technology BOM, select corresponding technology BOM information to form the production sequence information according to technology BOM and production order synchronization rules, then need to determine whether upgrading corresponding technology BOM information when producing the technique information modification in the order according to technology BOM Data Update rule.
Like this, technology BOM respective user is sightless, comes automatic service procedure BOM information by system according to the data sync rule fully, therefore utilizes the technology BOM of this implicit expression to realize making BOM, technology BOM and production order three's data sync.
Method of the present invention must be including but not limited to step and the content that reaches described above, and the order of step can be adjusted and refinement; In the implementation procedure of model, to satisfy the data structure of describing in the instructions, and realize on this basis realizing making the data sync of BOM and technology BOM according to aforementioned algorithm, call the requirement of technology BOM accurately thereby solve the production order
Excellent effect of the present invention:
Description of drawings
Fig. 1 is an implicit expression technology BOM model structure synoptic diagram
Fig. 2 is a synchronization rules model structure synoptic diagram
Fig. 3 produces order model structure synoptic diagram
Embodiment
Explain below with reference to Figure of description method of the present invention being done.
A kind of implementation method of utilizing data between the synchronous BOM of implicit expression technology BOM model of the present invention, comprise and set up implicit expression technology BOM model (definition of accompanying drawing 1), synchronization rules model (definition of accompanying drawing 2) and production order model (definition of accompanying drawing 3), implementation method realizes by the following algorithm of data between the synchronous BOM of implicit expression technology BOM model that utilizes, finally realizes data synchronization between BOM:
A. implicit expression technology BOM model attributes is described below:
1) serial number a: record in the unique identification table;
2) type: the type of sign BOM, all use as manufacturing, cost or the two;
3) date: sign technology BOM sets up the date;
4) father's item material: sign is wanted the material of father's item correspondence of output;
5) father's item quantity: the batch of sign father item material;
6) version number: the version number of sign BOM;
7) process route numbering: corresponding process route is numbered among the sign technology BOM;
8) operation: the production process among the sign technology BOM;
9) subitem material: the subitem material that sign will drop into;
10) subitem quantity: sign subitem material is with respect to the input quantity of father's item quantity correspondence;
11) other attributes are no longer described.
B. the synchronization rules model attributes is described below:
1) regular number: a record in the unique identification table;
2) production code member: the material that will produce of sign technology BOM;
3) rule description: describe corresponding synchronization rules;
4) rule value: sign will be preserved the rule value behind the user definition;
5) default value: the default value that tag system presets, can revise.If rule value is not empty, then default value is inoperative.
C. producing the order model attributes is described below:
Specific object is no longer described, and sees the definition of accompanying drawing 3.
D, utilize the algorithm of data between the synchronous BOM of implicit expression technology BOM model
At first when BOM is made in user's initialization, if the processing technology information of corresponding product is arranged, then when preserving, form new technology BOM according to the constraint of making BOM and technology BOM synchronization rules automatically, if making BOM occurs changing, then then revise the technology BOM of latest edition when revising, changing then as version forms the technology BOM of a redaction according to the technology BOM structure of the latest edition of correspondence.
Produce order when quoting technology BOM, select corresponding technology BOM information to form the production sequence information according to technology BOM and production order synchronization rules, then need to determine whether upgrading corresponding technology BOM information when producing the technique information modification in the order according to technology BOM Data Update rule.
Like this, technology BOM respective user is sightless, comes automatic service procedure BOM information by system according to the data sync rule fully, therefore utilizes the technology BOM of this implicit expression to realize making BOM, technology BOM and production order three's data sync.
Embodiment: the present invention has been successfully applied in tide ERP-PS (v10.1) management software, helps the enterprise of the frequent change type of many BOM to solve product BOM synchronisation requirement and MRP generate the procurement plan accurately and the production schedule according to accurate BOM demand.
Claims (2)
1. method of utilizing data between the synchronous BOM of implicit expression technology BOM model, it is characterized in that realizing making BOM by setting up a kind of synchronization rules constraint, data sync between technology BOM and production order technique information three, synchronous rule is in use defined according to actual needs by the user, produce order and form the table body information of producing order automatically according to the rule of definition and the process route information of product, system forms the technology BOM of redaction for row's product use next time according to new production order table body information conversely, BOM and technology BOM synchronization rules are made in system intialization, technology BOM and production order synchronization rules, technology BOM Data Update rule three rule-likes comprise the following steps and content:
A, in operation system, set up implicit expression technology BOM model and attribute definition thereof: serial number, type, date, father's item material, father's item quantity, version number, process route numbering, operation, subitem material, attributes such as subitem quantity; This tables of data can not safeguard by hand that its content is produced automatically by system and safeguards; Implicit expression technology BOM model attributes is described below:
Serial number a: record in the unique identification table;
Type: the type of sign BOM comprises that manufacturing, cost or the two all use;
Date: sign technology BOM sets up the date;
Father's item material: sign is wanted the material of father's item correspondence of output;
Father's item quantity: the batch of sign father item material;
Version number: the version number of sign BOM;
The process route numbering: corresponding process route is numbered among the sign technology BOM;
Operation: the production process among the sign technology BOM;
Subitem material: the subitem material that sign will drop into;
Subitem quantity: sign subitem material is with respect to the input quantity of father's item quantity correspondence;
Other attributes are no longer described;
B, in operation system, set up synchronization rules model and attribute definition thereof: rule number, stock number, rule description, rule value, default value; After list structure forms, carry out rule by system and preset; Wherein: the synchronization rules model attributes is described below:
Regular number: a record in the unique identification table;
Production code member: the material that will produce of sign technology BOM;
Rule description: describe corresponding synchronization rules;
Rule value: sign will be preserved the rule value behind the user definition;
Default value: the default value that tag system presets, can revise, rule value is not empty, then default value is inoperative;
Make BOM and technology BOM synchronization rules value and have two kinds: 1) be dosed into the operation that goes into operation, 2) be dosed into completion procedures, default value is 1;
Technology BOM and produce order synchronization rules value and have three kinds: 1) select the technology BOM of latest edition, 2) temporarily select 3) last month latest edition technology BOM, default value is 1;
Technology BOM Data Update rule value has two kinds: 1) be to upgrade corresponding technology BOM, 2 according to producing order) be not upgrade, default value is 1;
C, in operation system, set up to produce order model and attribute definition thereof: comprise following content:
Gauge outfit: produce the order serial number, the system phase in odd-numbered day, father's item material, father's item quantity is made the single attribute of Denging;
Table body: produce the order serial number, record separately serial number, operation, attributes such as subitem material, subitem quantity;
D, utilize the algorithm of data between the synchronous BOM of implicit expression technology BOM model, comprise 3 steps: (1) determines environment for use, selects IT technology and the instrument realized; (2) data structure of the example of design implicit expression technology BOM model, synchronization rules model and production order model description, the attribute of describing among data structure such as above-mentioned A, B, the C; (3) select suitable programming tool realization foreground and back-end data mutual, realize utilizing the data between the synchronous BOM of implicit expression technology BOM model;
When BOM is made in user's initialization, the processing technology information that corresponding product is arranged, then when preserving, form new technology BOM according to the constraint of making BOM and technology BOM synchronization rules automatically, making BOM occurs changing, then then revise the technology BOM of latest edition when revising, version changes then and to form the technology BOM of a redaction according to the technology BOM structure of the latest edition of correspondence;
Produce order when quoting technology BOM, select corresponding technology BOM information to form the production sequence information according to technology BOM and production order synchronization rules, then need to determine whether upgrading corresponding technology BOM information when producing the technique information modification in the order according to technology BOM Data Update rule;
Technology BOM respective user is sightless, comes automatic service procedure BOM information by system according to the data sync rule fully, therefore utilizes the technology BOM of this implicit expression to realize making BOM, technology BOM and production order three's data sync.
2. method according to claim 1 is characterized in that, the attribute description of synchronization rules model comprises but do not limit to: rule number, production code member, rule description, rule value, default value.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010138272A CN101859405A (en) | 2010-04-02 | 2010-04-02 | Method for synchronizing data between BOMs by utilizing implicit BOM model |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010138272A CN101859405A (en) | 2010-04-02 | 2010-04-02 | Method for synchronizing data between BOMs by utilizing implicit BOM model |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101859405A true CN101859405A (en) | 2010-10-13 |
Family
ID=42945296
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201010138272A Pending CN101859405A (en) | 2010-04-02 | 2010-04-02 | Method for synchronizing data between BOMs by utilizing implicit BOM model |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101859405A (en) |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103268538A (en) * | 2013-03-26 | 2013-08-28 | 大连海洋大学 | Production plan change-oriented multi-objective constraint material substitution method |
| CN103514520A (en) * | 2013-10-15 | 2014-01-15 | 苏州荣越网络技术有限公司 | Production plan arrangement system |
| CN105988431A (en) * | 2015-01-30 | 2016-10-05 | 中芯国际集成电路制造(上海)有限公司 | Management information system and product process configuration data updating method and product process configuration data updating device thereof |
| CN106779936A (en) * | 2016-12-08 | 2017-05-31 | 上海携程国际旅行社有限公司 | Firm Order system and Firm Order method |
| CN107316179A (en) * | 2017-05-31 | 2017-11-03 | 长园和鹰智能科技有限公司 | The assisted method and its assistance terminal of a kind of industrial products production |
| CN107451707A (en) * | 2016-10-24 | 2017-12-08 | 禾盈软件科技有限公司 | Intelligent order development data generation method and its system |
| CN107944685A (en) * | 2017-11-16 | 2018-04-20 | 郑州云海信息技术有限公司 | A kind of method that packing list is automatically generated based on PLM system and SAP system |
| CN109359752A (en) * | 2018-11-01 | 2019-02-19 | 郑州云海信息技术有限公司 | A kind of batch maintenance method and device of ERP system material |
| CN110442916A (en) * | 2019-07-05 | 2019-11-12 | 济南百真智能科技有限公司 | A kind of undirected drawing generating method of door and window manufacturing BOM, system, terminal and storage medium |
| CN111626689A (en) * | 2020-04-21 | 2020-09-04 | 徐工集团工程机械股份有限公司 | Intelligent data algorithm based on product example |
| CN111754112A (en) * | 2020-06-24 | 2020-10-09 | 精效新软新技术（北京）有限公司 | Automatic control method and medium for synchronous process scenes in production and processing processes |
| CN113298433A (en) * | 2021-06-21 | 2021-08-24 | 中国电子科技集团公司第二十九研究所 | Method, equipment and medium for acquiring demand of belt material outsourcing material |
| CN113449033A (en) * | 2021-06-11 | 2021-09-28 | 北京卫星制造厂有限公司 | Manufacturing process technical state synchronization method and system based on product bill of material |
| CN113554409A (en) * | 2021-06-15 | 2021-10-26 | 杭州控客信息技术有限公司 | BOM system-based production testing tool materialization method and system |
| CN117171215A (en) * | 2023-10-08 | 2023-12-05 | 深圳硬之城信息技术有限公司 | Processing method, device, equipment and storage medium based on historical data |
-
2010
- 2010-04-02 CN CN201010138272A patent/CN101859405A/en active Pending
Cited By (20)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103268538A (en) * | 2013-03-26 | 2013-08-28 | 大连海洋大学 | Production plan change-oriented multi-objective constraint material substitution method |
| CN103514520A (en) * | 2013-10-15 | 2014-01-15 | 苏州荣越网络技术有限公司 | Production plan arrangement system |
| CN105988431A (en) * | 2015-01-30 | 2016-10-05 | 中芯国际集成电路制造(上海)有限公司 | Management information system and product process configuration data updating method and product process configuration data updating device thereof |
| CN105988431B (en) * | 2015-01-30 | 2018-06-01 | 中芯国际集成电路制造(上海)有限公司 | The method for updating configuration data and device of management information system and products thereof flow |
| CN107451707A (en) * | 2016-10-24 | 2017-12-08 | 禾盈软件科技有限公司 | Intelligent order development data generation method and its system |
| CN106779936A (en) * | 2016-12-08 | 2017-05-31 | 上海携程国际旅行社有限公司 | Firm Order system and Firm Order method |
| CN106779936B (en) * | 2016-12-08 | 2020-09-22 | 上海携程国际旅行社有限公司 | Order verification system and order verification method |
| CN107316179A (en) * | 2017-05-31 | 2017-11-03 | 长园和鹰智能科技有限公司 | The assisted method and its assistance terminal of a kind of industrial products production |
| CN107944685A (en) * | 2017-11-16 | 2018-04-20 | 郑州云海信息技术有限公司 | A kind of method that packing list is automatically generated based on PLM system and SAP system |
| CN109359752A (en) * | 2018-11-01 | 2019-02-19 | 郑州云海信息技术有限公司 | A kind of batch maintenance method and device of ERP system material |
| CN110442916B (en) * | 2019-07-05 | 2023-05-26 | 济南百真智能科技有限公司 | Undirected graph generation method, undirected graph generation system, undirected graph generation terminal and undirected graph generation storage medium for manufacturing BOM (building object model) of doors and windows |
| CN110442916A (en) * | 2019-07-05 | 2019-11-12 | 济南百真智能科技有限公司 | A kind of undirected drawing generating method of door and window manufacturing BOM, system, terminal and storage medium |
| CN111626689A (en) * | 2020-04-21 | 2020-09-04 | 徐工集团工程机械股份有限公司 | Intelligent data algorithm based on product example |
| CN111626689B (en) * | 2020-04-21 | 2022-10-28 | 徐工集团工程机械股份有限公司 | Intelligent data algorithm based on product example |
| CN111754112A (en) * | 2020-06-24 | 2020-10-09 | 精效新软新技术（北京）有限公司 | Automatic control method and medium for synchronous process scenes in production and processing processes |
| CN111754112B (en) * | 2020-06-24 | 2023-11-17 | 精效新软新技术（北京）有限公司 | Automatic control method and medium for synchronous procedure scene in production and processing process |
| CN113449033A (en) * | 2021-06-11 | 2021-09-28 | 北京卫星制造厂有限公司 | Manufacturing process technical state synchronization method and system based on product bill of material |
| CN113554409A (en) * | 2021-06-15 | 2021-10-26 | 杭州控客信息技术有限公司 | BOM system-based production testing tool materialization method and system |
| CN113298433A (en) * | 2021-06-21 | 2021-08-24 | 中国电子科技集团公司第二十九研究所 | Method, equipment and medium for acquiring demand of belt material outsourcing material |
| CN117171215A (en) * | 2023-10-08 | 2023-12-05 | 深圳硬之城信息技术有限公司 | Processing method, device, equipment and storage medium based on historical data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101859405A (en) | Method for synchronizing data between BOMs by utilizing implicit BOM model | |
| US8175733B2 (en) | Modeling manufacturing processes to include defined markers | |
| EP2996073A1 (en) | A method for increasing the work performance of a manufacturing executing system (MES) and an enterprise resource planning system (ERP) | |
| CN103824136A (en) | MES (Manufacturing Execution System) dynamic workshop scheduling and manufacturing execution system | |
| CN102289743A (en) | Computer simulation system and method in product production process | |
| CN103577474B (en) | The update method and system of a kind of database | |
| JP5401176B2 (en) | Dynamic maintenance planning device | |
| CN101976240A (en) | Form number generating method and system | |
| CN104537515A (en) | Order splitting method and device | |
| CN103116813A (en) | Method of intelligent navigation for manufacturing operations of real-time information-driven production equipment | |
| US10019467B2 (en) | Method, system and computer readable medium for managing design updates in a manufacturing execution system | |
| EP2610696A1 (en) | Process design/production planning device | |
| CN104517014B (en) | A kind of product automatic assembly design system based on Pro/E | |
| CN105335813A (en) | Material kitting acquisition method and system | |
| US10664149B2 (en) | Method for configuring a MOM data warehouse and providing a UI to the MOM data warehouse configuration and computer readable medium | |
| JP2017122955A (en) | Production schedule planning support system and support method | |
| CN102184482A (en) | Realization method for synchronizing data between BOM (Bill Of Material) by implicit technical BOM model | |
| CN101477656A (en) | Implementation process for scheduling production tasks in accordance with production capability gradually in production management process | |
| CN102467697A (en) | Material demand generation method and system | |
| CN101510281A (en) | System and method for determining cost calculation step | |
| CN101561899A (en) | MBOM increasingly receiving method with integration of design, production and management | |
| CN105741003A (en) | Plan generation method and plan generation device | |
| CN102542364B (en) | Method and system for balancing substitute materials in material requirement planning | |
| CN109634637A (en) | A kind of PDM system and BOM multi version CAD data disparity comparative approach | |
| CN104281902A (en) | Material requirement suggestion making method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20101013 |