CN1755718A - System for automatically generating bill of material for electronic product - Google Patents
System for automatically generating bill of material for electronic product Download PDFInfo
- Publication number
- CN1755718A CN1755718A CNA2004100806264A CN200410080626A CN1755718A CN 1755718 A CN1755718 A CN 1755718A CN A2004100806264 A CNA2004100806264 A CN A2004100806264A CN 200410080626 A CN200410080626 A CN 200410080626A CN 1755718 A CN1755718 A CN 1755718A
- Authority
- CN
- China
- Prior art keywords
- item number
- bill
- bom
- electronic component
- number group
- 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 relates to automatic generating system for bill of electric product, which comprises material mark group classification, mark grade database composed of at least one mark record with at least same electric standard product group and mark group part provider/manufacturer code and recording comparison value according to one grade key factor, and automatic bill generating program to generate the opposite bill by input bill draft, mark group classification database, grade database and key factor.
Description
Technical field
The present invention relates to the making of a kind of Bill of Material (BOM) (BOM), particularly relate to a kind of Bill of Material (BOM) (BOM) automatic creation system in conjunction with item number classification (Grouping) mechanism and scoring (Ranking) mechanism.
Background technology
The edit mode of existing Bill of Material (BOM), be with artificial judgment and manual operating types such as editor, this shines into error in judgement and edit session too tediously long very easily, thereby delay the whole Time To Market of electronic product, even because the mistake of Bill of Material (BOM), and cause purchasing the electronic component of mistake, finally cause the serious disappearance of electronic product.Moreover, because flowing or leaving office of related personnel also can have influence on the correct output of Bill of Material (BOM) fully.
This because the disappearance of above-mentioned prior art is invented out a kind of Bill of Material (BOM) (BOM) automatic creation system in conjunction with item number classification (Grouping) mechanism and scoring (Ranking) mechanism through urgently thinking invention.
Summary of the invention
The technical matters that the present invention solves provides a kind of generation system of automatic generation bill of material for electronic product.
Another technical matters that the present invention solves provides a kind ofly can adjust and generate automatically Bill of Material (BOM) corresponding to an electronic product according to strategy.
For solving the problems of the technologies described above, the generation system that the invention provides a kind of automatic generation bill of material for electronic product comprises: an item number group taxonomy database comprises at least more than one item number group record, wherein each item number group record comprises an identical electrical specification product group and at least more than one item number group part supplier/manufacturer code at least; One item number score data storehouse comprises at least more than one item number scoring record, and wherein the item number group record corresponding to one of them is write down in each item number scoring, and in order to write down the comparation and assessment value after foundation one scoring key factor is appraised through comparison item number group record; One Bill of Material (BOM) generates handling procedure automatically, produces the Bill of Material (BOM) of corresponding design of electronic circuits figure in order to the key factor of selecting materials according to materials and parts inventory rough draft, item number group taxonomy database, the item number score data storehouse, of the design of electronic circuits figure that is imported.
Description of drawings
Fig. 1 is that Fig. 1 shows that the present invention generates the Organization Chart of the generation system of bill of material for electronic product automatically.
Fig. 2 shows the structural drawing of item number of the present invention group taxonomy database.
The specific embodiment synoptic diagram of Fig. 3 item number of the present invention group taxonomy database.
Fig. 4 shows the structural drawing in item number score data of the present invention storehouse.
Fig. 5 shows the specific embodiment synoptic diagram in item number score data of the present invention storehouse.
Fig. 6 shows that item number score data of the present invention storehouse carries out the picture of upkeep operation.
The embodiment picture of its materials and parts inventory rough draft of the electronic product of the computer main frame panel that Fig. 7 is shown.
Fig. 8 shows that execution Bill of Material (BOM) of the present invention generates the key frame of handling procedure automatically.
Fig. 9 shows that carrying out Bill of Material (BOM) of the present invention generates the handling procedure institute picture of the Bill of Material (BOM) of generation automatically automatically, and it exports the Bill of Material (BOM) of main materials.
Figure 10 shows and carries out the picture that Bill of Material (BOM) of the present invention generates the Bill of Material (BOM) that handling procedure institute generates automatically automatically, the Bill of Material (BOM) of the alternative materials of its output.
Figure 11 shows and carries out the picture that Bill of Material (BOM) of the present invention generates the Bill of Material (BOM) that handling procedure institute generates automatically automatically that it integrates the Bill of Material (BOM) of exporting main materials and alternative materials.
Figure 12 shows the embodiment of its listed part of key Parts List of the present invention (CCL-Critical Component List byProject).
Figure 13 shows the embodiment that does not approve its listed part of part manufacturer inventory (DVL-Disapproved VendorList by Project) of the present invention.
The figure number explanation
10, generation system 11, Bill of Material (BOM) generate handling procedure automatically
13, item number group taxonomy database 15, item number score data storehouse
17, electronic component database 19, Bill of Material (BOM)
20, materials and parts inventory rough draft 130, item number group record
131, identical electrical specification product group 133, item number group part supplier/manufacturer code
150, item number scoring record 151, scoring key factor
153, comparation and assessment value
Embodiment
Its major function of the generation system of automatic generation bill of material for electronic product of the present invention, be can according to strategy from the movable property life to should the strategy Bill of Material (BOM) (BOM), allow the electronic product of producing according to Bill of Material (BOM) can meet the expection target setting fully.Alleged its specific embodiment of strategy of this paper can be " the most high-quality assurance ", " minimum fabrication cost ", " leadless process electronic product " or the like, and the source of strategy can be to come from procurement unit, marketing unit, maintaining unit, research and development unit, persons in charge at different levels or the like.
Fig. 1 shows that the present invention generates the Organization Chart of the generation system of bill of material for electronic product automatically.Generation system 10 mainly includes item number group taxonomy database 13, item number score data storehouse 15, electronic component database 17 and Bill of Material (BOM) and generates handling procedure 11 automatically, is respectively described below interior literary composition.See also the structural drawing that Fig. 2 shows item number of the present invention group taxonomy database, item number group taxonomy database 13 consists predominantly of at least more than one item number group record 130, and each item number group record 130 comprises identical electrical specification product group 131 and at least more than one item number group part supplier/manufacturer code 133 at least.Please cooperate specific embodiment synoptic diagram again referring to Fig. 3 item number of the present invention group taxonomy database, in Fig. 3, seven numerical codes of identical electrical specification product group's 131 employings write down and distinguish the electrical specification product of each, and for example " 20-21472 " represents different electrical specification products respectively with " 20-21473 ".In Fig. 3, item number group part supplier/manufacturer code 133 adopts three numerical codes to write down and distinguish the otherness that belongs to this electrical specification product together, for example " 00 " represents all electronic component suppliers of this electrical specification product, with another angle, " 20-21472 " this electrical specification also can be represented in the item number group of " 20-21472-00 " this hypostazation (Instance) record 130.For example " 01 " represents A supplier, and with another angle, the A supplier of this electrical specification of supply " 20-21472 " also can be represented in the item number group of " 20-21472-01 " this hypostazation (Instance) record 130; And the A supplier of this electrical specification of supply " 20-21473 " also can be represented in the item number group of " 20-21473-01 " this hypostazation (Instance) record 130.For example " 02 " represents B supplier, and with another angle, the B supplier of this electrical specification of supply " 20-21472 " also can be represented in the item number group of " 20-21472-02 " this hypostazation (Instance) record 130.
Fig. 4 shows the structural drawing in item number score data of the present invention storehouse.Item number score data storehouse 15 comprises at least more than one item number scoring record 150, and each item number scoring record 150 is corresponding to the item number groups record 130 of one of them, and the comparation and assessment value 153 after coming item number group record 130 appraised through comparison according to every scoring key factor 151 in order to record.Please cooperate the specific embodiment synoptic diagram that shows item number score data of the present invention storehouse referring to Fig. 5 again, in Fig. 5, the concrete means of scoring key factor 151 can adopt " reducing cost ", " quality guarantee ", " leadless process ".The item number group record 130 of " 20-21472-01 " that Fig. 5 is shown, wait the comparation and assessment value 153 of each item rating key factor 151 to be respectively 100 minutes, 75 minutes, 50 minutes, 25 minutes at " reducing cost ", " quality guarantee ", " leadless process ", hold the continuous example explanation of going up, the electronic component of " 20-21472 " these electric rule product that A supplier supplied, its procurement price can meet the requirements, yet factors such as quality guarantee and leadless process can't meet the requirements.
Fig. 6 shows that item number score data of the present invention storehouse carries out the picture of upkeep operation.Each item number group record 130 in item number score data of the present invention storehouse 150 can be changed according to strategy, at the picture of Fig. 6, the maintenance of its every item number scoring record 150 that is associated of electronic component product of a computer main frame panel is described.
Generally speaking, the deviser of electronic product can directly carry out existing similar commercial application software as computer-aided design (CAD), and for example the OrCAD computer aided design software produces design of electronic circuits figure.When the deviser selects electronic component to design electronic circuit, can carry out the selected of materials and parts by the access of electronic component database 17, because the numbering of each materials and parts in the electronic component database 17, the identical electrical specification product group 131 of one of them of respectively corresponding item number group taxonomy database 13, be the item number group record 130 that the numbering of each materials and parts in the electronic component database 17 can be associated with one of them, see also the embodiment picture of its materials and parts inventory rough draft 20 of electronic product of the shown computer main frame panel of Fig. 7.
The major function that Bill of Material (BOM) of the present invention generates handling procedure 11 automatically be according to the design of electronic circuits figure that is imported its corresponding to affiliated materials and parts inventory rough draft 20, item number group taxonomy database 13, item number score data storehouse 15, the key factor etc. of selecting materials, come electronic product is produced corresponding Bill of Material (BOM) 19.The concrete means of the key factor of selecting materials can adopt indivedual one scoring key factors 151, or adopt the combination of indivedual scoring key factors 151.Fig. 8 shows that execution Bill of Material (BOM) of the present invention generates the key frame of handling procedure automatically; And please cooperate referring to the shown execution of Fig. 9 Bill of Material (BOM) of the present invention generate automatically handling procedure the picture of the Bill of Material (BOM) that automatically generates, the main Bill of Material (BOM) of its output with material; The shown execution of Figure 10 Bill of Material (BOM) of the present invention generate automatically handling procedure the picture of the Bill of Material (BOM) that automatically generates, its output substitutes the Bill of Material (BOM) of materials; And the shown execution of Figure 11 Bill of Material (BOM) of the present invention generate automatically handling procedure the picture of the Bill of Material (BOM) that automatically generates, it once exports the Bill of Material (BOM) of main materials and alternative materials.After determining the desired key factor of selecting materials, that is to say good scoring (Ranking) mode of decision, the key factor of selecting materials is according to all electronic components of design of electronic circuits figure, retrieve item number group taxonomy database 13 and item number score data storehouse 15, and added up the amount of commenting total points height according to the comparation and assessment value 153 of retrieving each electronic component that is obtained, last just output is according to the best Bill of Material (BOM) 19 of the key factor of selecting materials.
Moreover the condition that the key factor of selecting materials of the present invention can attachedly be given a kind of special appointment allows Bill of Material (BOM) generate the Bill of Material (BOM) 19 that handling procedure 11 is produced automatically, can meet the condition of this special appointment fully.The key factor of selecting materials under the special specified requirements, it for example is a restrictive condition that is used to specify the specific part that will use of a certain project, please cooperate referring to Figure 12, show its listed part of key Parts List (CCL-Critical Component List by Project) at Figure 12, through generating the Bill of Material (BOM) 19 that handling procedure 11 produces corresponding this project automatically, the content of Bill of Material (BOM) 19 can show that these parts are all selected.Again for example, the key factor of selecting materials under the special specified requirements is a restrictive condition of avoiding using some particular manufacturer part in some project, please cooperate referring to Figure 13, its listed part of part manufacturer inventory (DVL-Disapproved Vendor List by Project) is not approved in Figure 13 demonstration, through generating the Bill of Material (BOM) 19 that handling procedure 11 produces corresponding those projects automatically, Bill of Material (BOM) 19 is not selected these parts for use.
The present invention generates the advantage that generation system possessed of bill of material for electronic product automatically, and is as described below:
1. reduce the fault rate of artificial judgment materials and parts greatly.
2. shorten the time of Bill of Material (BOM) output greatly.
3. can select suppliers different in the Bill of Material (BOM) to come the supplies electrons part according to different strategy execution modes.
4. can select suppliers different in the Bill of Material (BOM) to come the supplies electrons part according to different electronic product project demands.
5. can be according to client's project demands, select or filter out the electronic component of specific part manufacturer supply, make part can directly be present in or not be present in generation Bill of Material (BOM) in.
6. can set up standardized item number group taxonomy database, item number score data storehouse and electronic component database, impel each design department to shorten building the time of putting of data, and can allow all design datas and each design department between, all can have identical database.
Pass through the above detailed description of preferred embodiments, the Ji can be known description feature of the present invention and spirit more, and the present invention comes scope of the present invention is limited with above-mentioned disclosed preferred embodiment, the more important thing is that the present invention can have been contained the modification of various changes and tool equality in the category of the claim of institute of the present invention desire application.
Claims (4)
1. a generation system that generates bill of material for electronic product automatically is characterized in that, comprising:
One item number group taxonomy database comprises at least more than one item number group record, and wherein each item number group record comprises an identical electrical specification product group and at least more than one item number group part supplier/manufacturer code at least;
One item number score data storehouse comprises at least more than one item number scoring record, and wherein the item number group record corresponding to one of them is write down in each item number scoring, and in order to write down the comparation and assessment value after foundation one scoring key factor is appraised through comparison this item number group record;
One Bill of Material (BOM) generates handling procedure automatically, produces Bill of Material (BOM) that should design of electronic circuits figure in order to the key factor of selecting materials according to design of electronic circuits figure, this item number group taxonomy database, this item number score data storehouse, one of being imported.
2. generation system according to claim 1, it is characterized in that, this generation system also comprises: an electronic component database, in order to write down the electrical specification of each electronic component at least, wherein the electrical specification of each electronic component corresponds respectively to the identical electrical specification product group of one of them item number group record.
3. generation system according to claim 1, it is characterized in that, this item number group part supplier/manufacturer code, numerical value according to this code comes in order to represent all electronic component suppliers that supply this defined electronic component of identical electrical specification product group and each electronic component supplier who represents this defined electronic component of identical electrical specification product group of supply respectively.
4. generation system according to claim 1 is characterized in that, this key factor of marking, be selected from one reduce cost, a quality guarantee, a leadless process.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2004100806264A CN1755718A (en) | 2004-09-29 | 2004-09-29 | System for automatically generating bill of material for electronic product |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2004100806264A CN1755718A (en) | 2004-09-29 | 2004-09-29 | System for automatically generating bill of material for electronic product |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN1755718A true CN1755718A (en) | 2006-04-05 |
Family
ID=36688925
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2004100806264A Pending CN1755718A (en) | 2004-09-29 | 2004-09-29 | System for automatically generating bill of material for electronic product |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1755718A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102054231A (en) * | 2010-12-30 | 2011-05-11 | 用友软件股份有限公司 | Method and device for generating bill of material |
| CN102422289A (en) * | 2009-05-04 | 2012-04-18 | 涡轮梅坎公司 | Data structure for specifications |
| CN103699605A (en) * | 2013-12-13 | 2014-04-02 | 广东长虹电子有限公司 | Automatic CKD (completely knock down)/SKD (semi knock down) inventory generation method |
| CN111709210A (en) * | 2020-05-22 | 2020-09-25 | 深圳市元征科技股份有限公司 | Method and device for generating component list, terminal equipment and storage medium |
-
2004
- 2004-09-29 CN CNA2004100806264A patent/CN1755718A/en active Pending
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102422289A (en) * | 2009-05-04 | 2012-04-18 | 涡轮梅坎公司 | Data structure for specifications |
| CN102422289B (en) * | 2009-05-04 | 2014-10-15 | 涡轮梅坎公司 | Data structure for specifications |
| CN102054231A (en) * | 2010-12-30 | 2011-05-11 | 用友软件股份有限公司 | Method and device for generating bill of material |
| CN103699605A (en) * | 2013-12-13 | 2014-04-02 | 广东长虹电子有限公司 | Automatic CKD (completely knock down)/SKD (semi knock down) inventory generation method |
| CN111709210A (en) * | 2020-05-22 | 2020-09-25 | 深圳市元征科技股份有限公司 | Method and device for generating component list, terminal equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Bartels et al. | Strategies to the prediction, mitigation and management of product obsolescence | |
| Tan et al. | Mediating effects of computer-aided design usage: From concurrent engineering to product development performance | |
| US20040225390A1 (en) | Direct methods system for assembly of products | |
| CN1395184A (en) | Order assembly production system and method | |
| AU2006235195A1 (en) | Mining optimisation | |
| CN111400354B (en) | Machine tool manufacturing BOM (Bill of Material) storage query and tree structure construction method based on MES (manufacturing execution System) | |
| CN110728422A (en) | Building information model, method, device and settlement system for construction project | |
| US20060106685A1 (en) | Generating system for automatically generating the bill of materials for electrical products | |
| CN1842796A (en) | Method, system, and storage medium for integrating rework operations into an advanced planning process | |
| JP2007041950A (en) | Production simulation management apparatus | |
| CN1755718A (en) | System for automatically generating bill of material for electronic product | |
| CN1529269A (en) | Metal plate cutting auto-discharing method | |
| CN112182708A (en) | Method for evaluating delivery rate of digital design result of urban rail transit engineering | |
| JP2000202746A (en) | Product part list editing method and device therefor | |
| US7657410B2 (en) | Process simulation system | |
| Nascimento et al. | The two-dimensional cutting stock problem with usable leftovers and uncertainty in demand | |
| US20230325770A1 (en) | Computer aided design assembly part scraping | |
| CN1627255A (en) | Automatic method for generating modular software of user customized and system | |
| CN101183448A (en) | Method for planning parts demand coverage based on variable percentage of substitution parts | |
| CN113781011A (en) | Verification method and system for project cost of power distribution network | |
| Al-Aomar | A simulation-based DFSS for a lean service system | |
| CN1453721A (en) | Inventory planing method | |
| CN1598847A (en) | System and method for supporting design change, and recording medium having the method stored | |
| US20110172801A1 (en) | Method and system for determining manufacturing throughput target | |
| Tanaga et al. | Material Requirement Planning Information System: Prototype And Lead Time Analysis |
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 |