Nothing Special   »   [go: up one dir, main page]

CN112183956B - System and method for creating engineering Inplan materials by using PCB - Google Patents

System and method for creating engineering Inplan materials by using PCB Download PDF

Info

Publication number
CN112183956B
CN112183956B CN202010947097.2A CN202010947097A CN112183956B CN 112183956 B CN112183956 B CN 112183956B CN 202010947097 A CN202010947097 A CN 202010947097A CN 112183956 B CN112183956 B CN 112183956B
Authority
CN
China
Prior art keywords
materials
database
data
bill
production
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.)
Active
Application number
CN202010947097.2A
Other languages
Chinese (zh)
Other versions
CN112183956A (en
Inventor
胡敏杰
赖小雯
周恒�
柳闯
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Victory Giant Technology Huizhou Co Ltd
Original Assignee
Victory Giant Technology Huizhou Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Victory Giant Technology Huizhou Co Ltd filed Critical Victory Giant Technology Huizhou Co Ltd
Priority to CN202010947097.2A priority Critical patent/CN112183956B/en
Publication of CN112183956A publication Critical patent/CN112183956A/en
Application granted granted Critical
Publication of CN112183956B publication Critical patent/CN112183956B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Administration; Management
    • G06Q10/06Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
    • G06Q10/063Operations research, analysis or management
    • G06Q10/0631Resource planning, allocation, distributing or scheduling for enterprises or organisations
    • G06Q10/06315Needs-based resource requirements planning or analysis
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/23Updating
    • G06F16/2365Ensuring data consistency and integrity
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • G06Q10/0875Itemisation or classification of parts, supplies or services, e.g. bill of materials
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/04Manufacturing
    • YGENERAL 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
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30Computing systems specially adapted for manufacturing

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • Human Resources & Organizations (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • Economics (AREA)
  • Strategic Management (AREA)
  • Databases & Information Systems (AREA)
  • Marketing (AREA)
  • General Engineering & Computer Science (AREA)
  • General Business, Economics & Management (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Tourism & Hospitality (AREA)
  • Data Mining & Analysis (AREA)
  • Quality & Reliability (AREA)
  • Operations Research (AREA)
  • Development Economics (AREA)
  • Computational Linguistics (AREA)
  • Computer Security & Cryptography (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Manufacturing & Machinery (AREA)
  • Health & Medical Sciences (AREA)
  • General Health & Medical Sciences (AREA)
  • Primary Health Care (AREA)
  • Educational Administration (AREA)
  • Game Theory and Decision Science (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • General Factory Administration (AREA)

Abstract

The invention provides a system and a method for creating engineering Inplan materials by a PCB, which are used for storing material information data, comprising a material Dk database and a material Df database, and further arranging a purchasing module and a research and development module for updating Dk compensation values, in-plant thickness and other material data for different MI material requirements, so that one-key automatic inquiry, inspection and import functions of an MI end bill of materials are realized, manpower is saved, and special people are not required to maintain the material creation matters. All steps can be completed by MI autonomous independent operation, the aging is improved, the standard is further unified, and the operation flow is simplified. And the system also supports Inplan material inquiry and multiple online real-time acquisition such as material Dk value and Df value inquiry, thereby further improving the yield and processing efficiency of production and reducing the management and control cost.

Description

System and method for creating engineering Inplan materials by using PCB
Technical Field
The invention relates to the technical field of production monitoring, in particular to a system and a method for creating engineering Inplan materials by using a PCB.
Background
The engineering Inplan software is created by manual operation, manually searching for the parameters of a provider, needing to do the job by standing manpower, waiting from time to time, consuming manpower, and cooperating with purchasing, researching and developing, suppliers and engineering departments, which has complicated process and is a difficult point for maintaining engineering Inplan software.
Disclosure of Invention
The invention provides a system and a method for creating engineering Inplan materials by using a PCB (printed Circuit Board), which are used for establishing links including research and development, purchasing, engineering, systems, suppliers and the like in series, establishing a big data platform, establishing a material system, automatically importing materials by using an API (application program interface) instruction for operation, establishing a material Dk and Df database, and automatically acquiring material parameters.
The method comprises the following steps: a system for PCB creation engineering Inplan material, comprising:
and (3) an engineering module: for obtaining a material requirement set forth by the production indication (Manufacturing Instruction, MI);
And a purchasing module: creating a purchasing bill of materials according to the material requirements in ERP, and checking the materials;
And a research and development module: obtaining specification parameter (datasheet) parameters provided by suppliers, reversely deducing the compensating value of the dielectric constant (DIELECTRIC CONSTANT, dk) in the factory and the thickness in the factory according to the datasheet parameters, and inputting material information data into a system;
and (3) a data platform: the system comprises a database and a data processing center, wherein the database is used for storing the bill of materials and corresponding material information data thereof; the data processing center is used for automatically creating a production bill of materials according to the material requirements set forth by the MI and presenting the production bill of materials through the terminal.
Wherein, the MI automatically creates a production bill of materials according to the bill of materials information data: and the MI automatically queries material information data of corresponding materials in the database according to the material requirements, automatically performs inspection, and automatically leads the inspected materials to a bill of materials generation interface after the inspected materials are qualified.
Further, checking whether the queried result is consistent with the input result of the research and development module, and if so, obtaining the data correctly; otherwise, reacquire.
Further, the material information data at least includes: dk value, loss factor (damping factor, df) value, and in-plant thickness.
Further, an API instruction is used to perform an automatic import function.
Further, the database at least comprises a material Dk database and a Df database.
Further, the system of the present invention further comprises: the database also supports ERP material inquiry, inplan material inquiry, material Dk value and Df value inquiry.
Preferably, the invention also provides a method for creating engineering Inplan materials by using the PCB, which comprises the following steps:
Acquiring MI and inputting material requirements in the system.
Automatically inquiring according to the material demand, checking an inquiry result, judging whether the inquiry result is consistent with the material information number input by the research and development module, if so, acquiring the data correctly, and automatically importing the data to a bill of material generation interface by adopting an API instruction; otherwise, the material information data is acquired again.
Further, the method further comprises: if the corresponding data or data acquisition errors cannot be queried in the database, the purchasing module creates a purchasing bill of materials according to the material requirements in the ERP, performs material auditing, acquires datasheet parameters provided by suppliers through a research and development module, reversely pushes the Dk compensation value and the thickness in the factory according to the datasheet parameters, and inputs material information data into the system to finish updating of the database.
Wherein, the bill of materials generates the interface and includes at least: ERP material inquiry interface, inplan material inquiry interface, material Dk value and Df value inquiry interface.
In summary, the system and the method for creating engineering Inplan materials by using the PCB are provided by the invention, a unified MySql database platform is established to store material information data, including a material Dk database and a material Df database, and a purchasing module and a research and development module are further arranged to update Dk compensation values, in-plant thickness and other material data for different MI material requirements, so that one-key automatic inquiry, inspection and introduction of MI end bill of materials are realized, the function of importing is realized, manpower is saved, special personnel are not required to maintain the material creation matters, all steps can be completed by MI autonomous independent operation completely, the timeliness is improved, the standards are further unified, and the operation flow is simplified. And the system also supports Inplan material inquiry and multiple online real-time acquisition such as material Dk value and Df value inquiry, thereby further improving the yield and processing efficiency of production and reducing the management and control cost.
Drawings
Fig. 1 is a system schematic diagram of PCB creation engineering Inplan materials in an embodiment.
Fig. 2 is a flow chart of a method of creating engineering Inplan materials for a PCB in an embodiment.
Fig. 3 is a system terminal operation interface display diagram in an embodiment.
Detailed Description
A system and method for creating engineering Inplan materials for PCBs according to the present invention will be described in further detail with reference to specific embodiments and accompanying drawings.
Fig. 1 shows a system for creating engineering Inplan materials by using a PCB in an embodiment, at least including a data acquisition side and a data platform management side, where the data acquisition side further includes: engineering module, purchasing module, research and development module; the data platform management side comprises a database and a data processing center, and is specifically:
And (3) an engineering module: the method is used for acquiring the material requirements proposed by MI; preferably, the material requirement is a bill of materials for the product in each order.
And a purchasing module: and creating a purchasing bill of materials according to the material requirements in the ERP, and performing material auditing. The purchasing bill of materials is used for providing material demand information to the suppliers, and the suppliers feed back parameter data of corresponding materials to the research and development module according to the bill of materials.
And a research and development module: the research and development personnel acquire datasheet parameters provided by suppliers, namely a parameter comparison table of production materials, and because certain errors exist in production standards of different suppliers, the materials are required to be adaptively adjusted according to the material information provided by each material supplier, namely the corresponding adjustment coefficient is revised according to the production standard of the enterprise, the research and development personnel reversely push Dk compensation values and thicknesses in factories according to the datasheet parameters, and input material information data into a system for reference of subsequent production and processing, so that the problem of error of product regulations caused by a supplier end can be avoided, and the accuracy and the qualification rate of products are further ensured. The research and development module can determine specific material parameters in the bill of materials listed in the purchasing module, so that the problem of inconsistent material parameters caused by different suppliers is avoided, and the consistency of product manufacture is improved.
And (3) a data platform: the system comprises a database and a data processing center, wherein the database is used for storing the bill of materials and corresponding material information data thereof, and at least comprises a material Dk database and a Df database. The data processing center is used for inquiring corresponding material data in the database according to the material demands proposed by the MI, realizing automatic creation of a production bill of materials and presenting the bill of materials through the terminal. The terminal may be a PC terminal or a mobile display screen, which is not limited thereto.
The database of the invention can also be imported historical data, but in order to be further consistent with market demands and purchased data, corresponding material information is updated according to new production demands.
Further, the MI automatically creates a production bill of materials according to the bill of materials information data, and further includes: according to the material requirements set forth by the MI, automatically inquiring material information data of corresponding materials in the database, automatically executing inquiry result check, checking whether the inquired result is consistent with the input result of the research and development module, and if so, obtaining the data correctly; otherwise, re-acquiring, and automatically importing the data into a bill of materials generation interface after the data is checked to be qualified.
Further, the material information data at least includes: dk value, df value, and in-plant thickness, but is not limited thereto.
The automatic import described in the present system preferably performs an automatic import function using API instructions, but is not limited thereto.
Further, the database also supports ERP material inquiry, inplan material inquiry and material Dk value and Df value inquiry.
Preferably, the present invention also provides a method (as shown in fig. 2) of creating engineering Inplan material of a PCB corresponding to the system of creating engineering Inplan material of the PCB, comprising the steps of:
Acquiring MI and inputting material requirements in the system.
Carrying out automatic query according to the material demand, checking a query result, judging whether the query result is consistent with the material information data input by the research and development module, if so, obtaining the data correctly, and automatically importing the data to a bill of material generation interface by adopting an API instruction; otherwise, the material information data is acquired again.
Further, the method further comprises the following steps: if the corresponding data or data acquisition errors cannot be queried in the database, the purchasing module creates a purchasing bill of materials according to the material requirements in the ERP, performs material auditing, acquires datasheet parameters provided by suppliers through a research and development module, reversely pushes Dk compensation values in factories and thicknesses in factories according to the datasheet parameters, inputs material information data into a system, completes updating of the database, and then automatically queries again after updating of the database is completed to acquire the bill of materials required.
Wherein, the bill of materials generates the interface and includes at least: the ERP material inquiry interface, inplan material inquiry interface, material Dk value and Df value inquiry interface are shown in a system terminal operation interface display diagram in FIG. 3, wherein the system terminal operation interface display diagram optionally comprises a bill of materials list detail, a Dk value window, an ERP window, a Inplan window and the like; the bill of materials list details at least comprise the functions of material coding, material name, engineering specification, brands, models, plate types, substrate thickness information, manual modification, inspection, row increasing, reloading and the like.
In summary, the invention provides a system and a method for monitoring the progress of a PCB product in real time, wherein a unified MySql database platform is constructed to manage material information data, an API instruction is adopted to realize the function of automatically making a bill of materials by MI, further, according to MI, a large data platform is constructed by refining engineering manufacturing stages, and the integrated production WIP achieves real-time management and control from PCB sample order receiving to shipment aging. Specifically, target values of all stages are set in the production process, and when the dead time exceeds the set time, an email early warning function is automatically triggered to inform relevant responsible persons in real time. Therefore, labor is saved, special personnel are not required to count related data and prompt, management efficiency of a manager is improved, and time consumption of each stage can be controlled in real time.
While the preferred embodiments of the present invention have been illustrated by reference to the accompanying drawings, those skilled in the art will appreciate that many modifications are possible in carrying out the invention without departing from the scope and spirit thereof. For example, features illustrated or described as part of one embodiment can be used on another embodiment to yield still a further embodiment. The foregoing description and drawings are merely illustrative of preferred embodiments of the present invention and are not intended to limit the scope of the claims, but rather to cover all modifications within the scope of the present invention.

Claims (1)

1. A system for creating engineering Inplan materials on a PCB, comprising:
a data acquisition side and a data platform management side, wherein the data acquisition side comprises: engineering module, purchasing module and research and development module; the data platform management side comprises a database and a data processing center;
The engineering module is as follows: the method comprises the steps of obtaining material requirements set forth by production and production instructions, wherein the material requirements are a bill of materials of products in each order;
The purchasing module is used for: creating a bill of materials for purchase according to the material requirements in ERP, and checking the materials; the purchasing bill of materials is used for providing material requirements for suppliers, and the suppliers feed corresponding material information data back to the research and development module according to the purchasing bill of materials;
The research and development module is as follows: acquiring a parameter comparison table of production materials provided by a supplier, reversely pushing Dk compensation values and thicknesses in a factory according to the parameter comparison table of the production materials, and inputting material information data into a system;
The database: the database is used for storing the purchased bill of materials and corresponding material information data thereof, the database at least comprises a material Dk database and a material Df database, and the material information data at least comprises: dk value, df value and in-plant thickness;
The data processing center: the method is used for inquiring corresponding material information data in the database according to the material requirements set forth by the production and production instructions, including ERP material inquiry, inplan material inquiry, material Dk value and Df value inquiry, and automatically creating a production bill of materials, and comprises the following steps: according to the material requirements set forth by the production and production instructions, automatically inquiring material information data of corresponding materials in the database, automatically executing inquiry result check, checking whether the inquiry result is consistent with the material information data input by the research and development module, and if so, obtaining the data correctly; otherwise, re-acquiring, automatically importing the data into a bill of materials generating interface by adopting an API instruction after the data is checked to be qualified, wherein the bill of materials generating interface at least comprises: the ERP material inquiry interface, inplan material inquiry interface, material Dk value and Df value inquiry interface are presented through a PC end or a mobile display screen;
If the corresponding data or data acquisition errors cannot be queried in the database, the purchasing module creates a purchasing bill of materials according to the material requirements in the ERP, performs material auditing, acquires a parameter comparison table of production materials provided by suppliers through a research and development module, reversely pushes the Dk compensation value in the factory and the thickness in the factory according to the parameter comparison table of the production materials, inputs material information data into a system, completes updating of the database, and then performs automatic query again after finishing updating of the database to acquire the bill of materials required.
CN202010947097.2A 2020-09-10 2020-09-10 System and method for creating engineering Inplan materials by using PCB Active CN112183956B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010947097.2A CN112183956B (en) 2020-09-10 2020-09-10 System and method for creating engineering Inplan materials by using PCB

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010947097.2A CN112183956B (en) 2020-09-10 2020-09-10 System and method for creating engineering Inplan materials by using PCB

Publications (2)

Publication Number Publication Date
CN112183956A CN112183956A (en) 2021-01-05
CN112183956B true CN112183956B (en) 2024-08-02

Family

ID=73921697

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010947097.2A Active CN112183956B (en) 2020-09-10 2020-09-10 System and method for creating engineering Inplan materials by using PCB

Country Status (1)

Country Link
CN (1) CN112183956B (en)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN113128857A (en) * 2021-04-13 2021-07-16 惠州中京电子科技有限公司 PCB equipment intelligence manufacturing production system
CN115187180B (en) * 2022-09-09 2023-01-20 荣耀终端有限公司 Material data processing method and electronic equipment

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111275314A (en) * 2020-01-17 2020-06-12 广州兴森快捷电路科技有限公司 Method, device and equipment for generating bill of material and storage medium

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1963849A (en) * 2005-11-08 2007-05-16 陈金元 Conformity method of managing system of data of product
KR20130134590A (en) * 2012-05-31 2013-12-10 현대중공업 주식회사 Method and system for managing an information of material in the ship
KR101868993B1 (en) * 2017-10-27 2018-06-20 주식회사 피에스캠 System, method and computer program for work management to manufacture printed circuit board
CN109919524A (en) * 2017-12-12 2019-06-21 小圈信息科技(上海)有限公司 A kind of management system and method based on bill of materials

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN111275314A (en) * 2020-01-17 2020-06-12 广州兴森快捷电路科技有限公司 Method, device and equipment for generating bill of material and storage medium

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
印制电路板阻抗探讨;乐禄安 等;《印制电路信息》,(第8期);第10-25页 *

Also Published As

Publication number Publication date
CN112183956A (en) 2021-01-05

Similar Documents

Publication Publication Date Title
CN104866599B (en) The production method and system of Visual Report Forms
CN110580572B (en) Product life-span traceability system
CN112183956B (en) System and method for creating engineering Inplan materials by using PCB
US20090299513A1 (en) Product recovery management system
US7398187B2 (en) Method of batching and analyzing of data from computerized process and control systems
CN1462974A (en) Intelligent method and device for managing production technology information
Tekin et al. Composite manufacturing data management in aerospace industry
CN102467699B (en) To defect management modeling and method based on defect management process defect
US6985786B2 (en) Method for managing manufacturing data
US20050096774A1 (en) System and method for integrating transactional and real-time manufacturing data
US10515336B2 (en) Material harmonization disposition system for electronic inventories
CN116757464A (en) Production plan management method, system, equipment and readable storage medium
CN111144841A (en) Inspection method and system platform for conveying and storing equipment in chemical product production line
US20080234851A1 (en) System and method for managing a product manufacturing process
US11308533B2 (en) Supplier evaluation system and supplier evaluation method
JPH07160325A (en) Article storing history information and its manufacture and maitenance method
US20100268748A1 (en) System and method of updating supplier information
US20160071042A1 (en) Quoting Tool and Design Module for Continuous Emission Monitoring Systems
CN118172013A (en) Tool material management method and device
CN118606329B (en) Production equipment informatization management method and system for resource sharing among enterprises
CN111882220B (en) Data detection method and device
CN115293371A (en) Method and device for repairing defective electric valve, electronic equipment and medium
JP2002182722A (en) Schedule managing method
CN118295370A (en) Automatic test system and test scheduling method for complete machine of electronic controller of aero-engine
CN114253566A (en) Chip burning control system, control method and chip burning device

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
GR01 Patent grant
GR01 Patent grant