CN101727611A - System and method for making material table - Google Patents
System and method for making material table Download PDFInfo
- Publication number
- CN101727611A CN101727611A CN200810169621A CN200810169621A CN101727611A CN 101727611 A CN101727611 A CN 101727611A CN 200810169621 A CN200810169621 A CN 200810169621A CN 200810169621 A CN200810169621 A CN 200810169621A CN 101727611 A CN101727611 A CN 101727611A
- Authority
- CN
- China
- Prior art keywords
- mentioned
- material table
- data
- bom
- bill
- 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
Abstract
The invention provides a system and a method for making a material table. The method for making the material table comprises the following steps of: providing a first material bill, a second material bill, a setting file and a material table template, wherein the setting file contains multiple first data and multiple second data, and the material table template is provided with a plurality of preset fields; retrieving the first data and the second data from the setting file, and filling the first data and the second data in the preset fields; and according to the first data and the second data, searching multiple first information corresponding to the first data and multiple second information corresponding to the second data by at least one of the first material bill and the second material bill, and finally making the material table.
Description
Technical field
The present invention is relevant for a kind of material table manufacturing system and method, and particularly relevant for a kind of system and method for automatic making material table.
Background technology
Electronic product often will be assembled in hundreds of electronic components or thousands of electronic component on the circuit board in the process of producing, yet, these are of a great variety and electronic component that number is huge to be assembled in an orderly manner on the circuit board be a very thing of complexity.So, in the process of producing, just can utilize some record sheets to come the essential information of recorded electronic set of pieces and its production equipment of arranging in pairs or groups etc.
For example: the material table is a kind of record sheet commonly used on production line, the master data of its essential record electronic component, feed situation and behaviour in service, the following information of material table general record: material station (Slot), item number (PartsNo), the specification of electronic component (Spec), put a part number (QTY), put part position (Location), bin model (Feeder) and/or supplier's information such as (QVL), its mid-number (QTY), putting part position (Location) mainly is that (surface mount technology can use when SMT) producing line at surface mounting technology.
Yet, present material table editor and production method, be to make with operating types such as artificial judgment and manual editings, this production method increases the probability of makeing mistakes easily, have a strong impact on work efficiency, and editor's time is also very long, handles such thing with the manpower of overspending, and delays production efficiency.In addition, because flowing or leaving office of related personnel also can have influence on the making of correct material table, and have influence on normal scheduling of production easily.
Summary of the invention
The present invention proposes a kind of material table manufacturing system and method, to improve the disappearance of prior art.
The present invention proposes a kind of material table method for making, comprise the following steps: to provide first Bill of Material (BOM), second Bill of Material (BOM), enactment document and material table template, and enactment document comprises a plurality of first data and a plurality of second data, and material table template has a plurality of preset field; First data and second data in the acquisition enactment document, and insert among the preset field; And according to first data and second data one of them is searched corresponding to the first information of first data with corresponding to second information of second data at least by first Bill of Material (BOM) and second Bill of Material (BOM), produce a material table.
The present invention proposes a kind of material table manufacturing system in addition, comprises storage element and material table making module.Storage unit stores has first Bill of Material (BOM), second Bill of Material (BOM) and enactment document.The material table is made module and is coupled storage element, the material table is made first data and second data in the module acquisition enactment document, and insert among above-mentioned these preset field, and the material table make module according to first data and second data by searching in first Bill of Material (BOM) and second Bill of Material (BOM) corresponding to a plurality of first information of first data with corresponding to a plurality of second information of second data, produce above-mentioned material table.
Material table manufacturing system provided by the present invention and method can be produced a material table automatically, make the material table wrong probability occur and reduce, and can save time and manpower, increase work efficiency, thereby fundamentally reduce production costs.
For above and other objects of the present invention, feature and advantage can be become apparent, preferred embodiment cited below particularly, and conjunction with figs. are described in detail below.
Description of drawings
Figure 1 shows that synoptic diagram according to the material table manufacturing system of a preferred embodiment of the present invention.
Figure 2 shows that process flow diagram according to the material table method for making of a preferred embodiment of the present invention.
Figure 3 shows that synoptic diagram according to first Bill of Material (BOM) of a preferred embodiment of the present invention.
Figure 4 shows that synoptic diagram according to second Bill of Material (BOM) of a preferred embodiment of the present invention.
Figure 5 shows that synoptic diagram according to the enactment document of a preferred embodiment of the present invention.
Figure 6 shows that the synoptic diagram of the material table of producing according to the material table method for making of a preferred embodiment of the present invention.
Embodiment
Figure 1 shows that synoptic diagram according to the material table manufacturing system of a preferred embodiment of the present invention.The material table manufacturing system 1 that present embodiment provided comprises storage element 11, material table making module 12, material sheet format module 13 and material table look-up module 14.
The material table is made module 12, material sheet format module 13 and material table look-up module 14 and is coupled storage element 11 respectively.
The material table is made first data and second data in the module 12 acquisition enactment documents 113, and insert among the preset field, and the material table make module 12 according to first data and second data by searching in a BOM table 111 and the 2nd BOM table 112 corresponding to the first information of first data with corresponding to second information of second data, make the discharging table.
Material sheet format module 13 is used to format the material table and makes the produced material table of module 12, and its formative object comprises to be handled the space of a whole page, gauge outfit, the page of material table.Material table look-up module 14 is used to check the correctness of above-mentioned material table, for example expects that table look-up module 14 can compare the material table and make module 12 produced a material table and a BOM table 111, or compares above-mentioned material table and the 2nd BOM table 112.
In the present embodiment, storage element 11 is implemented in the computer apparatus (figure does not show), and in other embodiments, storage element 11 also may be implemented in server or the disk array (RAID).In the present embodiment, storage element 11 is a hard disk (HDD), and in other embodiments, storage element 11 also can be the nonvolatile RAM of flash memory or other type.
In the present embodiment, above-mentioned material table is made module 12, material sheet format module 13 and material table look-up module 14 and can be arranged in the same computer apparatus or in the same server, in other embodiments, storage element 11, material table are made module 12, material sheet format module 13 and are expected that table look-up module 14 also can be arranged in the different computer apparatus or server.
In addition, in the present embodiment, the material table is made module 12, material sheet format module 13 and material table look-up module 14 and can be utilized software mode to reach, and in other embodiments, the material table is made module 12 and also can be utilized hardware mode to reach.
An above-mentioned BOM table 111 and the 2nd BOM table 112 are important basis forms in the production run, a BOM table 111 is similar to the content of the 2nd BOM table 112 in the present embodiment, but the content that a BOM table 111 is comprised is more than the content of the 2nd BOM table 112.For example: the content of a BOM table 111 comprises item number, specification, puts a part number, puts information such as part position, manufacturer, and the content of the 2nd BOM table 112 comprises item number, specification, puts information such as a part number, manufacturer, and wherein BOM table 111 content has more than the content of the 2nd BOM table 112 and puts the part position.In other embodiments, the content of a BOM table 111 also can be out of Memory than the part that content had more of the 2nd BOM table 112, or the content of the 2nd BOM table 112 is more than the content of a BOM table 111, and the present invention is not limited.
In the present embodiment, the content of enactment document 113 comprises material station, item number, packs, puts a part number and bin model.
Figure 2 shows that the process flow diagram according to the material table method for making of a preferred embodiment of the present invention, the relevant detailed description in detail please be in the lump with reference to Fig. 1.In the present invention, the order of step S201～step S205 is not limited, but it is intermodulation in proper order.
In step S201, storage element 11 provides first Bill of Material (BOM) 111, second Bill of Material (BOM) 112, enactment document 113 and material table template 114.The content of first Bill of Material (BOM) 111, as shown in Figure 3.The content of second Bill of Material (BOM) 112, as shown in Figure 4.Enactment document 113 comprises a plurality of first data and a plurality of second data, and a plurality of first data are for example other for the station, and a plurality of second data for example are item number, the content of enactment document 113, as shown in Figure 5.Material table template 114 has a plurality of preset field, as Slot field, PartsNo field, Spec field, location field, Feeder field and QVL field among Fig. 6.
Step S203, the material table is made first data (the other information of standing) and second data (item number information) of module 12 acquisition enactment documents 113, inserts among the preset field of material table template 114.As Fig. 6, the other information 10006L that will stand inserts the Slot field; Item number information 11-034110461SJ inserts the PartsNo field.
Step S205, material table make module 12, and one of them is searched corresponding to the first information of first data (the other information of standing) with corresponding to second information of second data (item number information) at least by first Bill of Material (BOM) 111 and second Bill of Material (BOM) 112 according to first data (the other information of standing) and second data (item number information).As Fig. 6, when the station Wei 10006L, when item number is 11-034110461SJ, then the material table is made information such as module 12 is taken specification out of, put the part position from first Bill of Material (BOM) 111 or second Bill of Material (BOM) 112, bin model, manufacturer and is inserted respectively in Spec field, location field, Feeder field and the QVL field, thus, can get a complete material table.
In the present embodiment, second data comprise the major ingredient item number and substitute the material item number, and for example: first the corresponding item number of stand is a major ingredient, expecting for substituting below this major ingredient.As Fig. 6, the item number 11-034110461SJ of the other 10006L correspondence of standing is a major ingredient, and is 11-034110463SJ, 11-034110467SJ and 11-034110468SJ for substituting material below the major ingredient 11-034110461SJ.
In other embodiments, material table method for making also comprises the step of utilizing material sheet format module 13 to carry out format material table.The step of format material table comprises to be handled the space of a whole page, gauge outfit, the page of material table, can set material and show the width and the font of each field or delete space in each field or the like.
In addition, in other embodiments, material table method for making comprises the following steps: that also the material table of producing with step S205 is a benchmark, material table look-up module 14 is searched corresponding major ingredient according to the not corresponding item number in station in first Bill of Material (BOM) and second Bill of Material (BOM), whether the alternative material of comparison material table is consistent with the alternative material of first Bill of Material (BOM) 111 and second Bill of Material (BOM) 112.
That is, putting from one derives one the program that part machine (figure do not show) followed when producing and mounts file, and this mounts to comprise in the file and puts part coordinate, angle, the second material station, second item number and second and put the part position, next relatively mounts second in the file again and puts first in part position and first Bill of Material (BOM) whether put part position corresponding respectively first item number and second item number consistent.
For example in Fig. 6, the major ingredient of the other 10006L correspondence in station is 11-034110461SJ in the material table, substitutes material and is 11-034110463SJ, 11-034110467SJ and 11-034110468SJ.In Fig. 3, the alternative material of the major ingredient 11-034110461SJ correspondence of first Bill of Material (BOM) 111 is 11-034110463SJ, 11-034110467SJ and 11-034110468SJ, and then the material table is entirely true.
In sum, the material table manufacturing system and the method thereof of preferred embodiment of the present invention, owing to can produce a material table automatically according to first Bill of Material (BOM), second Bill of Material (BOM) and enactment document, can reduce wrong appearance probability, save time and manpower, increase work efficiency greatly, thereby fundamentally reduce production costs.
Though the present invention discloses as above with preferred embodiment; right its is not in order to limit the present invention; have in the technical field under any and know the knowledgeable usually; without departing from the spirit and scope of the present invention; when can doing a little change and retouching, so protection scope of the present invention is as the criterion when looking claims person of defining.
Claims (15)
1. a material table method for making is characterized in that, comprises the following steps:
Provide first Bill of Material (BOM), second Bill of Material (BOM), enactment document and material table template, and above-mentioned enactment document comprises a plurality of first data and a plurality of second data, above-mentioned material table template has a plurality of preset field;
Capture above-mentioned these first data and above-mentioned these second data in the above-mentioned enactment document, and insert among above-mentioned these preset field; And
At least one of them is searched corresponding to a plurality of first information of above-mentioned these first data with corresponding to a plurality of second information of above-mentioned these second data by above-mentioned first Bill of Material (BOM) and above-mentioned second Bill of Material (BOM) according to above-mentioned these first data and above-mentioned these second data, produces above-mentioned material table.
2. material table method for making according to claim 1 is characterized in that, above-mentioned these first data are other for the station, and above-mentioned these second data are item number.
3. material table method for making according to claim 2 is characterized in that, above-mentioned these second data comprise the major ingredient item number and substitute the material item number.
4. material table method for making according to claim 1 is characterized in that, wherein above-mentioned first Bill of Material (BOM) comprises that item number, specification, first put a part number, first and put the part position and first manufacturer.
5. material table method for making according to claim 4 is characterized in that, above-mentioned second Bill of Material (BOM) comprises that above-mentioned item number, above-mentioned specification, above-mentioned first put a part number and above-mentioned first manufacturer.
6. material table method for making according to claim 5, it is characterized in that, above-mentioned material table method for making comprises that also with above-mentioned material table be benchmark, search corresponding major ingredient according to the item number that the station is not corresponding in above-mentioned first Bill of Material (BOM) and above-mentioned second Bill of Material (BOM), whether the alternative material of comparing above-mentioned material table is consistent with the alternative material of above-mentioned first Bill of Material (BOM) and above-mentioned second Bill of Material (BOM).
7. material table method for making according to claim 1 is characterized in that, above-mentioned material table method for making also comprises the following steps:
Format above-mentioned material table.
8. material table method for making according to claim 7 is characterized in that, the step that formats above-mentioned material table comprises to be handled the space of a whole page, gauge outfit, the page of above-mentioned material table.
9. material table method for making according to claim 1 is characterized in that, above-mentioned material table method for making also comprises the following step:
From put the program of being followed when the part machine is produced, derive and mount file.
10. material table method for making according to claim 9 is characterized in that, above-mentioned mount to comprise in the file put part coordinate, angle, the second material station, second item number and second and put the part position.
11. material table method for making according to claim 10 is characterized in that, above-mentioned material table method for making also comprises the following steps:
More above-mentionedly mount above-mentioned second in the file and put above-mentioned first in part position and above-mentioned first Bill of Material (BOM) whether put part position corresponding respectively above-mentioned first item number and above-mentioned second item number consistent.
12. a material table manufacturing system is characterized in that, comprising:
Storage element stores first Bill of Material (BOM), second Bill of Material (BOM), enactment document and material table template, and above-mentioned enactment document comprises a plurality of first data and a plurality of second data, and above-mentioned material table template has a plurality of preset field; And
The material table is made module, couple above-mentioned storage element, above-mentioned material table making module captures above-mentioned these first data and above-mentioned these second data in the above-mentioned enactment document, and insert among above-mentioned these preset field, and above-mentioned material table make module according to above-mentioned these first data and above-mentioned these second data by searching in above-mentioned first Bill of Material (BOM) and above-mentioned second Bill of Material (BOM) corresponding to a plurality of first information of above-mentioned these first data with corresponding to a plurality of second information of above-mentioned these second data, produce above-mentioned material table.
13. material table manufacturing system according to claim 12 is characterized in that, above-mentioned material table manufacturing system also comprises material sheet format module.
14. material table manufacturing system according to claim 12 is characterized in that, above-mentioned material table manufacturing system also comprises material table look-up module.
15. material table manufacturing system according to claim 14 is characterized in that, above-mentioned material table look-up module is above-mentioned material table of comparison and above-mentioned first Bill of Material (BOM), or compares above-mentioned material table and above-mentioned second Bill of Material (BOM).
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200810169621A CN101727611A (en) | 2008-10-13 | 2008-10-13 | System and method for making material table |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200810169621A CN101727611A (en) | 2008-10-13 | 2008-10-13 | System and method for making material table |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101727611A true CN101727611A (en) | 2010-06-09 |
Family
ID=42448477
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN200810169621A Pending CN101727611A (en) | 2008-10-13 | 2008-10-13 | System and method for making material table |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101727611A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107239923A (en) * | 2017-06-08 | 2017-10-10 | 深圳怡化电脑股份有限公司 | Generate the method and device of Application for Materials |
| CN111459599A (en) * | 2020-04-03 | 2020-07-28 | 上海闻泰信息技术有限公司 | Material list editing method, device, equipment and storage medium |
-
2008
- 2008-10-13 CN CN200810169621A patent/CN101727611A/en active Pending
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107239923A (en) * | 2017-06-08 | 2017-10-10 | 深圳怡化电脑股份有限公司 | Generate the method and device of Application for Materials |
| CN107239923B (en) * | 2017-06-08 | 2020-08-18 | 深圳怡化电脑股份有限公司 | Method and device for generating material application form |
| CN111459599A (en) * | 2020-04-03 | 2020-07-28 | 上海闻泰信息技术有限公司 | Material list editing method, device, equipment and storage medium |
| CN111459599B (en) * | 2020-04-03 | 2024-02-02 | 上海闻泰信息技术有限公司 | Bill of materials editing method, apparatus, device and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10824785B2 (en) | PCB stencil manufacturing method and system | |
| US20070073679A1 (en) | System and method for generating a bill of material file | |
| CN107992492B (en) | Data block storage method, data block reading method, data block storage device, data block reading device and block chain | |
| CN103049770A (en) | SMT (Surface Mount Technology) anti-false material detection system and method | |
| CN102567864B (en) | Material substitution method in MRP system, device | |
| CN103592898A (en) | An electronic product production automatic control system and a method | |
| CN105303097A (en) | Verification method of mobile terminal, mobile terminal and verification system | |
| CN103926254A (en) | Statistical system and method used for PCB defect detection | |
| CN104641308A (en) | Production system and program switching method used for same | |
| CN101996116A (en) | Testing method | |
| CN108829736A (en) | A kind of joining method and system of image data and label information | |
| CN102819526A (en) | System and method for modularization processing of BOM (bill of material) of electronic elements | |
| CN112445897A (en) | Method, system, device and storage medium for large-scale classification and labeling of text data | |
| CN101727611A (en) | System and method for making material table | |
| CN101645062B (en) | Report form generation method and system | |
| CN1959709A (en) | System and method for creating list of materiel | |
| WO2023116248A1 (en) | Material box, material box identification method, device and apparatus, storage system and medium | |
| CN115544975B (en) | Log format conversion method and device | |
| US20070038964A1 (en) | System and method for extracting material differences between different circuit board design diagrams | |
| CN105224515A (en) | The tool and method of XBRL instance document is edited based on Flex | |
| CN101739432A (en) | System and method for searching graphic elements | |
| CN102236660A (en) | Printed circuit board maintenance data analysis method | |
| CN1987855A (en) | Data processing method and system | |
| US7089074B2 (en) | Host feeder setup validation | |
| CN103838902A (en) | Wire arrangement checking system and 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 |
Open date: 20100609 |