Material station table synthesis method, system and equipment and storage medium

Abstract

The invention discloses a material station table synthesis method, system and device and a storage medium, and the method comprises the steps: importing a first material table into a first blank table in a spreadsheet, and carrying out the formatting operation to obtain a first target material table, constructing a substitute material relationship and establishing a substitute material data table based on the substitute group number, the material number and the feature column corresponding to the substitute material in the screened first target material table; importing a second material table exported by automatic surface mounting and automatic plug-in machine software into a second blank table, and formatting to obtain a second target material table; and combining the substitute material data table and the material description information in the screened first target material table with the second target material table based on the material number to generate a material station table. According to the method, the legal compliant material station table is automatically generated based on the first material table and the second material table, manual operation is replaced, missing, excessive and wrong parts in electronic product manufacturing are avoided, the burden of technicians is relieved, and the production efficiency is improved.

Description

technical field [0001] The invention relates to the field of material list management in the electronic manufacturing industry, in particular to a material station list synthesis method, system, equipment and storage medium. Background technique [0002] At present, for the PCBA (Printed Circuit Board Assembly, printed circuit board assembly) industry, automatic placement and automatic insertion operations are the core process, and automatic placement and automatic insertion are compliant and legal material stations Table, directly related to the quality and traceability of PCBA. For example, non-compliance or non-uniform material station tables may cause personnel to easily place wrong parts, resulting in bad situations such as wrong parts or reverse parts, which will bring huge losses to the company; Illegal The material station table cannot be imported into MES (manufacturing execution system, manufacturing execution system), and manual assistance is required, which may ...

AI Technical Summary

Problems solved by technology

For example, non-compliant or non-uniform material station tables may cause personnel to easily place wrong parts, resulting in bad situations such as wrong parts or reverse parts, which will bring huge losses to the company; illegal The material station table cannot be imported into MES (manufacturing execution system, manufacturing execution system), and manual assistance is required, which may easily cause incomplete PCBA data in the MES system or wrong traceability of MES data

Images