CN102542389A - Part information integration system and method - Google Patents
Part information integration system and method Download PDFInfo
- Publication number
- CN102542389A CN102542389A CN2010106041740A CN201010604174A CN102542389A CN 102542389 A CN102542389 A CN 102542389A CN 2010106041740 A CN2010106041740 A CN 2010106041740A CN 201010604174 A CN201010604174 A CN 201010604174A CN 102542389 A CN102542389 A CN 102542389A
- Authority
- CN
- China
- Prior art keywords
- information
- production
- supplier
- excel document
- parts
- 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 discloses a part information integration method applied to a computer and used for integrating part information of a PDM (Product Data Management) system, a Tiptop system and an EPO (ePolicy Orchestrator) system. The method comprises the following steps of: acquiring part feather information from a part feature database of the PDM system; acquiring part production information in the production process from a production information database of the Tiptop system; acquiring part purchasing information from a purchasing information database of the EPO system; establishing an Excel document and establishing a field for each kind of obtained information in the Excel document; and sequentially filling the obtained information into the fields established in the Excel document. The invention also provides a part information integration system.
Description
Technical field
The present invention relates to the whole system and method for a kind of parts information remittance.
Background technology
In manufacturing enterprise; Production information relevant with part and the part sourcing information in EPO (the Electronic Procurement Order) system in part characteristic information in the product data management system (Product Data Management System:PDM system), the Tiptop system are that the product design personnel are in the research and development of products process and marketing personal's important referential data that produce market is expanded.The mode of in the past obtaining these parts informations all adopts manual type from different systems, to obtain relevant information respectively and converges and put in order, and offers product design personnel or marketing personal again and does reference.Yet, need waste many times through the mode that the manual work remittance is put in order, can't in time obtain up-to-date parts information and supply product design personnel and marketing personal as the design and the reference of offering, make product in design time and quotation, lose ground.
Summary of the invention
In view of above content, be necessary to provide a kind of parts information remittance whole system, it can use a computer and in time obtain up-to-date parts information in PDM system, Tiptop system and the EPO system, and converges whole to the information that obtains automatically.
Also be necessary to provide a kind of parts information remittance adjusting method, it can use a computer and in time obtain up-to-date parts information in PDM system, Tiptop system and the EPO system, and converges whole to the information that obtains automatically.
Said parts information converges adjusting method, is applied in the computing machine, is used for converging the parts information of whole PDM system, Tiptop system and EPO system.The method comprising the steps of: from the part property database of said PDM system, obtain the part characteristic information; From the production information database of said Tiptop system, obtain part production information in process of production; From the procurement information database of said EPO system, obtain the procurement information of part; Set up an Excel document, and in this Excel document, set up a field for above-mentioned every kind of information obtaining; The above-mentioned information of obtaining is filled in the field of setting up in the said Excel document successively.
Said parts information converges whole system, runs in the computing machine, is used for converging the parts information of whole PDM system, Tiptop system and EPO system.This system comprises: the module of from the part property database of said PDM system, obtaining the part characteristic information; From the production information database of said Tiptop system, obtain the module of part production information in process of production; From the procurement information database of said EPO system, obtain the module of the procurement information of part; Set up an Excel document, and in this Excel document, be the module that above-mentioned every kind of information obtaining is set up a field; The above-mentioned information of obtaining is filled in successively the module in the field of setting up in the said Excel document.
Compared to prior art, said parts information converges puts in order system and method, uses a computer and in time obtains up-to-date parts information in PDM system, Tiptop system and the EPO system, and converge whole to the information that obtains automatically.Can provide up-to-date parts information to supply product design personnel and marketing personal, make product seize the first opportunity on the design time with in the quotation as design and quotation reference.
Description of drawings
Fig. 1 is the running environment Organization Chart of the whole system of parts information remittance of the present invention.
Fig. 2 is the process flow diagram of parts information remittance adjusting method of the present invention preferred embodiment.
The main element symbol description
| |
1 |
| The whole system of |
10 |
| The |
20 |
| The |
200 |
| The Tiptop |
30 |
| The |
300 |
| The |
40 |
| |
400 |
Embodiment
As shown in Figure 1, be the running environment Organization Chart of the whole system of parts information remittance of the present invention.This whole system 10 of parts information remittance runs in the computing machine 1.This whole system 10 of parts information remittance is used for from product data management system (Product Data Management System:PDM system) 20, Tiptop system 30 and EPO (Electronic Procurement Order; The e-procurement order) obtains parts information in the system 40, and converge the parts information of obtaining whole.Said PDM system 20, Tiptop system 30 and EPO system 40 can run directly in the computing machine 1, also may operate on far-end computer or the server.If this PDM system 20, Tiptop system 30 and EPO system 40 operate on far-end computer or the server, this parts information converges 10 of whole systems and from this PDM system 20, Tiptop system 30 and EPO system 40, obtains said parts information through network.In other embodiments, said parts information converges whole system 10 and also can directly be implanted in said PDM system 20, Tiptop system 30 and the EPO system 40.
Said PDM system 20 is one and is used for managing all information relevant with product (comprising parts information, configuration, document, cad file, structure, authority information etc.) and all and the relevant process electronic system of product; It comprises a part property database 200, stores the part characteristic information in this part property database 200.This part characteristic information comprises supplier, industrial limitations standard and the industry standard specifications etc. of part.The supplier of said part can be sole supplier or multiple supplier.
Said Tiptop system 30 manufactures an electronic system commonly used in the enterprise production process management, and it comprises a production information database 300, stores part production information in process of production in this production information database 300.This production information comprises time that stockpile number, engineering changing order, the production of part is required and the information that whether stops production etc.
Said EPO system 40 manufactures an e-procurement order management system commonly used in the enterprise, and it comprises a procurement information database 400, stores the procurement information of part in this procurement information database 400.This procurement information comprises the information such as suggestion supplier, qualified part tabulation, part price, part price risk grade, part situation and part alternate orders of part.Said part price risk grade comprises high, medium and low Three Estate.
The above whole system 10 of parts information remittance comprises one or more functional modules; These one or more functional modules are the software program section with specific function; These software program section are stored in the readable storage medium storing program for executing or other memory device of computing machine 1; Can be carried out by computing machine 1 or other calculation element that comprises processor, thereby accomplish the whole work flow of parts information remittance among the present invention.
Below in conjunction with Fig. 2, the method that the whole system 10 of parts information remittance is obtained parts information and whole this parts information of obtaining of remittance is elaborated.
As shown in Figure 2, be the process flow diagram of parts information remittance adjusting method of the present invention preferred embodiment.The whole system 10 of said parts information remittance accomplishes the whole work flow of parts information remittance through the step of carrying out the following stated.
Step S01 obtains the part characteristic information from the part property database 200 of said PDM system 20.
Step S02 obtains part production information in process of production from the production information database 300 of said Tiptop system 30.
Step S03 obtains the procurement information of part from the procurement information database 400 of said EPO system 40.
Step S04 sets up an Excel document, and in this Excel document, sets up a field for above-mentioned every kind of information obtaining.
Step S05 is filled in the above-mentioned information of obtaining in the corresponding field of setting up in the said Excel document successively, converges whole to this Excel document with the parts information that this is obtained.
Be commonly called part risk assessment analysis report through the whole resulting Excel document of work flow of the remittance of above-mentioned parts information.The parts information of client, manufacturer and factory that this part risk assessment analysis report can provide the most instant, accuracy is high.This part risk assessment analysis report can directly offer the product design personnel and the marketing personal carries out reference when product design and quotation, to obtain the advantage of product in design time and quotation.
In addition; If the product client also provides the qualified part supplier information of appointment; The whole system 10 of said parts information remittance also can obtain the qualified part supplier information of this appointment from the product client through network, and in said Excel document, sets up a field for the qualified part supplier information of this appointment.Then the qualified part supplier information of this appointment is inserted in the field of being set up for the qualified part supplier information of this appointment in this Excel document, to obtain more perfect part risk assessment analysis report.
Above embodiment is only unrestricted in order to technical scheme of the present invention to be described; Although the present invention is specified with reference to preferred embodiment; Those of ordinary skill in the art is to be understood that; Can make amendment or be equal to replacement technical scheme of the present invention, and not break away from the spirit and the scope of technical scheme of the present invention.
Claims (10)
1. a parts information converges adjusting method, is applied in the computing machine, is used for converging the parts information of whole PDM system, Tiptop system and EPO system, it is characterized in that the method comprising the steps of:
From the part property database of said PDM system, obtain the part characteristic information;
From the production information database of said Tiptop system, obtain part production information in process of production;
From the procurement information database of said EPO system, obtain the procurement information of part;
Set up an Excel document, and in this Excel document, set up a field for above-mentioned every kind of information obtaining; And
The above-mentioned information of obtaining is filled in the field of setting up in the said Excel document successively.
2. parts information remittance adjusting method as claimed in claim 1 is characterized in that this method also comprises step:
Obtain the qualified part supplier information of appointment through network from the product client, and in said Excel document, set up a field for the qualified part supplier information of this appointment; And
The qualified part supplier information of said appointment is filled in the field of setting up for the qualified part supplier information of this appointment in the said Excel document.
3. parts information remittance adjusting method as claimed in claim 1 is characterized in that said part characteristic information comprises supplier, industrial limitations standard and the industry standard specifications of part.
4. parts information remittance adjusting method as claimed in claim 1 is characterized in that said production information comprises time that stockpile number, engineering changing order, the production of part is required and the information that whether stops production.
5. parts information remittance adjusting method as claimed in claim 1; It is characterized in that; Said procurement information comprises suggestion supplier, qualified part tabulation, part price, part price risk grade, part situation and the part alternate orders of part, and said part price risk grade comprises high, medium and low Three Estate.
6. a parts information converges whole system, runs in the computing machine, is used for converging the parts information of whole PDM system, Tiptop system and EPO system, it is characterized in that this system comprises:
From the part property database of said PDM system, obtain the module of part characteristic information;
From the production information database of said Tiptop system, obtain the module of part production information in process of production;
From the procurement information database of said EPO system, obtain the module of the procurement information of part;
Set up an Excel document, and in this Excel document, be the module that above-mentioned every kind of information obtaining is set up a field; And
The above-mentioned information of obtaining is filled in successively the module in the field of setting up in the said Excel document.
7. the whole system of parts information remittance as claimed in claim 6 is characterized in that this system also comprises:
Obtain the qualified part supplier information of appointment through network from the product client, and in said Excel document, set up the module of a field for the qualified part supplier information of this appointment; And
The qualified part supplier information of said appointment is filled in the module in the field of setting up for the qualified part supplier information of this appointment in the said Excel document.
8. the whole system of parts information remittance as claimed in claim 6 is characterized in that said part characteristic information comprises supplier, industrial limitations standard and the industry standard specifications of part.
9. the whole system of parts information remittance as claimed in claim 6 is characterized in that said production information comprises time that stockpile number, engineering changing order, the production of part is required and the information that whether stops production.
10. the whole system of parts information remittance as claimed in claim 6; It is characterized in that; Said procurement information comprises suggestion supplier, qualified part tabulation, part price, part price risk grade, part situation and the part alternate orders of part, and said part price risk grade comprises high, medium and low Three Estate.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010106041740A CN102542389A (en) | 2010-12-24 | 2010-12-24 | Part information integration system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2010106041740A CN102542389A (en) | 2010-12-24 | 2010-12-24 | Part information integration system and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102542389A true CN102542389A (en) | 2012-07-04 |
Family
ID=46349234
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2010106041740A Pending CN102542389A (en) | 2010-12-24 | 2010-12-24 | Part information integration system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102542389A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104657906A (en) * | 2013-11-20 | 2015-05-27 | 山东银鹰炊事机械有限公司 | PDM system-based part information generation method |
| CN106408077A (en) * | 2016-09-14 | 2017-02-15 | 重庆大学 | SMD part counting method and SMD part counting device |
| CN106469141A (en) * | 2016-08-31 | 2017-03-01 | 北京汽车研究总院有限公司 | A kind of ECN inspection method based on Excel and TeamCenter |
| CN109801179A (en) * | 2017-11-17 | 2019-05-24 | 英业达科技有限公司 | Data update method and Information System |
| CN110610060A (en) * | 2019-09-26 | 2019-12-24 | 广东省海洋工程装备技术研究所 | Product modeling method of open expandable information, computer device and computer readable storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1361474A (en) * | 2000-12-29 | 2002-07-31 | 神基科技股份有限公司 | Material list establishing method |
| CN1622103A (en) * | 2003-11-25 | 2005-06-01 | 英业达股份有限公司 | Production control system and method |
| CN1963849A (en) * | 2005-11-08 | 2007-05-16 | 陈金元 | Conformity method of managing system of data of product |
-
2010
- 2010-12-24 CN CN2010106041740A patent/CN102542389A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1361474A (en) * | 2000-12-29 | 2002-07-31 | 神基科技股份有限公司 | Material list establishing method |
| CN1622103A (en) * | 2003-11-25 | 2005-06-01 | 英业达股份有限公司 | Production control system and method |
| CN1963849A (en) * | 2005-11-08 | 2007-05-16 | 陈金元 | Conformity method of managing system of data of product |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104657906A (en) * | 2013-11-20 | 2015-05-27 | 山东银鹰炊事机械有限公司 | PDM system-based part information generation method |
| CN106469141A (en) * | 2016-08-31 | 2017-03-01 | 北京汽车研究总院有限公司 | A kind of ECN inspection method based on Excel and TeamCenter |
| CN106469141B (en) * | 2016-08-31 | 2018-10-23 | 北京汽车研究总院有限公司 | A kind of ECN inspection methods based on Excel and TeamCenter |
| CN106408077A (en) * | 2016-09-14 | 2017-02-15 | 重庆大学 | SMD part counting method and SMD part counting device |
| CN109801179A (en) * | 2017-11-17 | 2019-05-24 | 英业达科技有限公司 | Data update method and Information System |
| CN110610060A (en) * | 2019-09-26 | 2019-12-24 | 广东省海洋工程装备技术研究所 | Product modeling method of open expandable information, computer device and computer readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Dai et al. | Design of traceability systems for product recall | |
| Wang | Random yield and uncertain demand in decentralised supply chains under the traditional and VMI arrangements | |
| CN102542389A (en) | Part information integration system and method | |
| US10354343B2 (en) | Automated process control hardware engineering using schema-represented requirements | |
| CN105786474A (en) | Multi-tenant-supporting collaborative business flow customizing system and method | |
| CN112418798A (en) | Information auditing method and device, electronic equipment and storage medium | |
| CN112115145A (en) | Data acquisition method and device, electronic equipment and storage medium | |
| Wang et al. | Developing an employee turnover risk evaluation model using case-based reasoning | |
| CN110765750A (en) | Report data entry method and terminal equipment | |
| Boysen et al. | Just-in-time vehicle scheduling with capacity constraints | |
| Chiu et al. | Mathematical modelling for determining economic batch size and optimal number of deliveries for EPQ model with quality assurance | |
| CN114372731B (en) | Post target making method, device, equipment and storage medium based on big data | |
| Ahn et al. | Modeling of smart supply chain for sustainability | |
| CN116562588A (en) | Enterprise supply chain analysis system, method and equipment based on ERP | |
| Chiu et al. | Optimal replenishment policy for manufacturing systems with failure in rework, backlogging and random breakdown | |
| CN102306199A (en) | Data management device and data management method | |
| US20100268748A1 (en) | System and method of updating supplier information | |
| CN108681559B (en) | Comparison method and system based on multi-system data application | |
| Zhao et al. | Optimizing pricing and inventory strategies for dietary supplement production under stochastic demand | |
| CN104766179A (en) | Maintenance method and system for substitute materials | |
| Suwanda et al. | Information System for Operational Goods Management at the Career Guidance and Entrepreneurship Center Malikussaleh University | |
| CN108388978A (en) | A kind of intelligence asset management statistical method and device | |
| KR20210033605A (en) | Integrated supply chain management system between fashion designers and manufacturers | |
| CN116501748A (en) | Material distribution method, device, equipment and storage medium | |
| CN102542048A (en) | Data matching device and data matching 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: 20120704 |