CN1804877A - Material list generation system and method - Google Patents
Material list generation system and method Download PDFInfo
- Publication number
- CN1804877A CN1804877A CNA2005100003814A CN200510000381A CN1804877A CN 1804877 A CN1804877 A CN 1804877A CN A2005100003814 A CNA2005100003814 A CN A2005100003814A CN 200510000381 A CN200510000381 A CN 200510000381A CN 1804877 A CN1804877 A CN 1804877A
- Authority
- CN
- China
- Prior art keywords
- bill
- bom
- commodity
- data
- accessory
- 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 relates to a material bill generating system and method which provides the user to input the basic module of the needed goods by the type of the goods and the material data of each mating part to generate the material bill of the goods. The material bill generating system comprises: a material bill database used to store the material basic data, the basic module material data, the mating part material data and the goods material data, a data input module used to provide the user to choose the needed goods comprising the basic module and each mating part and generate the material bill of the goods, a data storing module used to store the material data of the material bill database and a forms for reporting statistics generating module used to generate the material bill of the goods.
Description
Technical field
The invention relates to a kind of material list generation system and method,, produce the system and method for this commodity Bill of Material (BOM) particularly about a kind of material data that can import basic module and every accessory of commodity according to the type of merchandise.
Background technology
In the production of electronic installation, after completing, wiring diagram needs to produce Bill of Material (BOM) according to this wiring diagram, and existing is the material data of importing the contained accessory of each commodity with manually-operated, produces Bill of Material (BOM).In information communication commodity such as mobile phone, personal computer and PDA(Personal Digital Assistant), because all comprise many accessories in each commodity, comprise many materials in each accessory again, therefore the Bill of Material (BOM) of this commodity is often very huge, and numerous its kinds of not only contained material number are complicated especially.Have the Bill of Material (BOM) of keying in each commodity with manually-operated now, not only wasting time and energy more may be because the numerous and diverse of operation make a mistake.
In addition, because information communication commodity type is of a great variety, difference on the minority accessory is often only arranged again between the commodity of different type of machines, existing material data with artificial each commodity of input, may cause the inefficient repetition of work because of the material data between different commodity is mostly identical, more may obscure, mistake because of its contained material data is very close.
Summary of the invention
For overcoming the shortcoming of above-mentioned prior art, fundamental purpose of the present invention is to provide a kind of system and method for Bill of Material (BOM) generation, import the basic module of required commodity and included every accessory thereof for the user respectively according to the type of commodity, and read the material data of this basic module and every accessory, produce the Bill of Material (BOM) of these commodity automatically.This system not only can save many manpowers and time, more can avoid tradition to set up the contingent mistake of commodity Bill of Material (BOM) with manually-operated, simultaneously, also can avoid because of the close generation material of the contained accessory of each commodity data is obscured, mistake.
For reaching above-mentioned purpose, the present invention provides a kind of material list generation system.Material list generation system of the present invention comprises: the Bill of Material (BOM) database, and the material related data of each commodity such as storage material master data, basic module material data, accessory material data and commodity material data produces the respectively Bill of Material (BOM) of these commodity; The data input module is imported the contained basic module of each commodity and every accessory for the user, produces the Bill of Material (BOM) of these commodity; The data access module according to basic module and the every accessory that the data input module is chosen, reads the material data of Bill of Material (BOM) database, produces the Bill of Material (BOM) of these commodity, and deposits these Bill of Material (BOM) data in this database; This system also can comprise report generating module in addition, read the respectively Bill of Material (BOM) data of these commodity for the user, produce the respectively Bill of Material (BOM) form of these commodity, avoid tradition to set up the contingent mistake of Bill of Material (BOM), and avoid because of repeating spent manpower and the time of operation with manually-operated.
Bill of Material (BOM) production method of the present invention is: each the commodity material related data that has basic module material data and accessory material data in the Bill of Material (BOM) database storage at least; Make the user import the basic module and the accessory of required commodity; And, in this Bill of Material (BOM) database, look for the material data of this basic module and related accessory according to the basic module and the related accessory that receive, produce the Bill of Material (BOM) of these commodity.This method also comprises: deposit the Bill of Material (BOM) data of these commodity in the Bill of Material (BOM) database, read in this Bill of Material (BOM) database the respectively Bill of Material (BOM) data of these commodity, produce the respectively Bill of Material (BOM) form of these commodity.
In sum, material list generation system of the present invention and method, be with the material basic document, the basic module material data, the accessory material data deposits the Bill of Material (BOM) database in, make the data input module receive basic module and every accessory that these commodity respectively comprise, read the Bill of Material (BOM) database with seasonal data access module according to this basic module and every accessory, produce the Bill of Material (BOM) of these commodity, and deposit these Bill of Material (BOM) data in the Bill of Material (BOM) database, at last, report generating module produces the respectively Bill of Material (BOM) form of these commodity, avoid tradition to set up the contingent mistake of Bill of Material (BOM), and avoid because of repeating spent manpower and the time of operation with manually-operated.
Description of drawings
Fig. 1 is the basic structure block schematic diagram of material list generation system of the present invention;
Fig. 2 is the schematic flow sheet of the every step of Bill of Material (BOM) production method of the present invention; And
Fig. 3 is the steps flow chart synoptic diagram that Bill of Material (BOM) production method of the present invention is set up the required execution of Bill of Material (BOM) database.
Embodiment
Embodiment
Fig. 1 illustrates the basic structure block schematic diagram of material list generation system of the present invention.As shown in the figure, material list generation system 10 of the present invention comprises: Bill of Material (BOM) database 11, data input module 12, data access module 13 and report generating module 14.Material list generation system 10 of the present invention is to build to put on server or workstation, be connected to this server or working end for the user who is positioned at end device (not marking) by network system (for example Internet or LAN), and then select the basic module of required commodity and included every accessory thereof, and the content of the basic module of the commodity of selecting according to the user and included every accessory thereof produces corresponding Bill of Material (BOM) automatically.
In addition, material list generation system 10 of the present invention also can be directly installed on the computer installation, and the unit mode allows the user directly obtain the service that this material list generation system 10 provides by this computer installation.
Bill of Material (BOM) database 11 comprises material basic data file 111, basic module material data file 112, accessory material information paper 113 and commodity material information paper 114.Material basic document file 111 comprises stock number and name of material, stores the basic document of respectively making the required material of these commodity; Basic module material information paper 112 comprises the basic module numbering, basic module title and stock number, the related data of the material that the basic module of each commodity of storage making is required, wherein this basic module is meant the common module that possesses between the commodity of different model, for example between the computing machine of this different model, motherboard with same size, central processing unit, internal memory and hard disk, only comprise USB PORT whether, difference to some extent on wireless network card and the Bluetooth wireless transmission interface is so its basic module promptly refers to the motherboard of same size in this computing machine, central processing unit, the part of internal memory and hard disk; Accessory material information paper 113 comprises accessory numbering, accessory title and stock number, store each commodity accessory must spent material related data, wherein this accessory is meant between the commodity of different model, the different parts that are equipped with beyond the basic module, accessory is meant the different parts that are equipped with such as USB PORT, wireless network card and blue bud wireless transmission interface in last example; And commodity material information paper 114 comprises goods number, basic module numbering, accessory numbering and stock number, stores the respectively basic module of these commodity and the material data of every accessory, and produces the respectively Bill of Material (BOM) of these commodity according to this material data.
Basic module and every accessory that data access module 13 receives according to data input module 12, in the basic module material data file 112 and accessory material information paper 113 of Bill of Material (BOM) database 11, look for the basic module and the data of the required material of every accessory of making these commodity, produce the commodity material information paper 114 that the stock number inventory of these commodity respectively also deposits this stock number data in this Bill of Material (BOM) database 11.
Fig. 2 illustrates the process flow diagram of every step of the required execution of Bill of Material (BOM) production method of the present invention.As shown in the figure, at first execution in step S1 sets up Bill of Material (BOM) database 11, and the detailed process that this Bill of Material (BOM) database 11 is set up is seen Fig. 3, then enters step S2.
In this step S2, make this data input module 12 basic module and the every accessory included according to these commodity, choose listed basic module and related accessory in Bill of Material (BOM) database 11 basic module material data files 112 and the accessory material data file 113, then enter step S3.
In this step S3, make this data access module 13 according to data input module 12 received basic module and every accessory, in the basic module material data file 112 and accessory material information paper 113 of Bill of Material (BOM) database 11, look for the basic module of these commodity and the material data of the required use of every accessory, produce the respectively stock number inventory of these commodity, then enter step S4.
In this step S4, make this data access module 13 deposit the stock number inventory data of these commodity the commodity material information paper 114 of Bill of Material (BOM) database 11 in, then enter step S5.
In this step S5, make this report generating module 14 read in the commodity material information paper 114 of this Bill of Material (BOM) database 11 the respectively stock number inventory of these commodity, and read the name of material of material basic document file 111 according to this stock number, produce the respectively Bill of Material (BOM) form of these commodity.
The step S1 that Fig. 3 describes Fig. 2 in detail sets up the flow chart of steps of information paper to Bill of Material (BOM) database 11.As shown in the figure, at first carry out step S11, stock number that the extensive stock that the said firm produced is required and name of material, deposit the material basic document file 111 of Bill of Material (BOM) database 11 in, import the material data of required respectively these commodity for the user, and the generation Bill of Material (BOM), then enter step S12.
In this step S12, basic module numbering with the said firm's extensive stock basic module, basic module title and stock number, deposit the basic module material information paper 112 of this Bill of Material (BOM) database 11 in, store and make the data of the required material of the basic module of these commodity respectively, wherein this basic module is meant the common module that is possessed between the commodity of different model, for example between the computing machine of this different model, motherboard with same size, central processing unit, internal memory and hard disk, only comprise USB PORT whether, difference to some extent on wireless network card and the Bluetooth wireless transmission interface, so its basic module is meant the motherboard of same size in this computing machine, central processing unit, the part of internal memory and hard disk then enters step S13.
In this step S13, accessory numbering, accessory title and the stock number of every accessory that the said firm's extensive stock is included, deposit the accessory material information paper 113 of this Bill of Material (BOM) database 11 in, store and make the data of the required material of every accessory of these commodity respectively, wherein this accessory is meant between the commodity of different model, the different parts that are equipped with beyond the basic module, the accessory of for example going up this different model computing machine in the example is meant the different parts that are equipped with of each computing machine such as USB PORT, wireless network card and Bluetooth wireless transmission interface.
In sum, material list generation system of the present invention and method are with the material basic document, the basic module material data, the accessory material data deposits the Bill of Material (BOM) database in, the basic module and the every accessory that make the data input module comprise according to respectively these commodity that receive, read the Bill of Material (BOM) database with seasonal data access module according to this basic module and every accessory, produce the Bill of Material (BOM) of these commodity, and deposit these Bill of Material (BOM) data in the Bill of Material (BOM) database, at last, report generating module produces the respectively Bill of Material (BOM) form of these commodity, avoid tradition to set up the contingent mistake of Bill of Material (BOM), and avoid because of repeating manpower and the time that operation expends with manually-operated.
Claims (6)
1. a material list generation system is characterized in that, this material list generation system comprises:
The Bill of Material (BOM) database stores basic module material related data and accessory material related data at least;
The data input module receives basic module and accessory that required commodity comprise; And
The data access module, basic module and accessory data according to this data input module receives read the Bill of Material (BOM) database, produce the Bill of Material (BOM) of these commodity.
2. material list generation system as claimed in claim 1 is characterized in that, this data access module also deposits the Bill of Material (BOM) data of these commodity in this Bill of Material (BOM) database.
3. material list generation system as claimed in claim 1 is characterized in that this system also comprises report generating module, reads the Bill of Material (BOM) money of each commodity in the Bill of Material (BOM) database, and produces the Bill of Material (BOM) form of each commodity.
4. a Bill of Material (BOM) production method is characterized in that, this Bill of Material (BOM) production method comprises:
At least each the commodity material related data that has basic module material data and accessory material data in the Bill of Material (BOM) database storage;
Make the user import the basic module and the accessory of required commodity; And
According to the basic module and the related accessory that receive, in this Bill of Material (BOM) database, look for the material data of this basic module and related accessory, produce the Bill of Material (BOM) of these commodity.
5. Bill of Material (BOM) production method as claimed in claim 4 is characterized in that, this method comprises that also the Bill of Material (BOM) data with these commodity deposits the Bill of Material (BOM) database in.
6. Bill of Material (BOM) production method as claimed in claim 4 is characterized in that, this method also comprises the respectively Bill of Material (BOM) data of these commodity that reads in this Bill of Material (BOM) database, produces the respectively Bill of Material (BOM) form of these commodity.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2005100003814A CN1804877A (en) | 2005-01-10 | 2005-01-10 | Material list generation system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2005100003814A CN1804877A (en) | 2005-01-10 | 2005-01-10 | Material list generation system and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN1804877A true CN1804877A (en) | 2006-07-19 |
Family
ID=36866884
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2005100003814A Pending CN1804877A (en) | 2005-01-10 | 2005-01-10 | Material list generation system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1804877A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102819526A (en) * | 2011-06-07 | 2012-12-12 | 鸿富锦精密工业（深圳）有限公司 | System and method for modularization processing of BOM (bill of material) of electronic elements |
| CN111507609A (en) * | 2020-04-13 | 2020-08-07 | 兰剑智能科技股份有限公司 | Material list generation method and device and electronic equipment |
-
2005
- 2005-01-10 CN CNA2005100003814A patent/CN1804877A/en active Pending
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102819526A (en) * | 2011-06-07 | 2012-12-12 | 鸿富锦精密工业（深圳）有限公司 | System and method for modularization processing of BOM (bill of material) of electronic elements |
| CN111507609A (en) * | 2020-04-13 | 2020-08-07 | 兰剑智能科技股份有限公司 | Material list generation method and device and electronic equipment |
| CN111507609B (en) * | 2020-04-13 | 2023-10-27 | 兰剑智能科技股份有限公司 | Bill of materials generation method, apparatus and electronic device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103019636A (en) | Voucher design printing method and system | |
| CN105447723A (en) | Promotion system and promotion method | |
| CN102004954A (en) | Product information system and information integration method of product design system | |
| CN104820764A (en) | Method and device for producing electronic assembly technologic document | |
| CN104123422A (en) | Pre-manufacturing design method through database management system | |
| CN1924906A (en) | Product data statistics of flowing production line and management method | |
| CN106021528A (en) | Data processing method and device | |
| CN101668047A (en) | Method and device for automatically generating composite service description language | |
| CN1804877A (en) | Material list generation system and method | |
| CN109241510A (en) | A kind of autochart generation system and its implementation based on wechat small routine | |
| CN1845499A (en) | A many machines netting management method for tax-controlled cash register | |
| CN101388018A (en) | Computer aided design document management method | |
| CN1959709A (en) | System and method for creating list of materiel | |
| CN115034347B (en) | Industrial Internet of things for tracing two-dimensional code data and control method thereof | |
| CN102902516A (en) | Control inversion based pop-up frame design for call center | |
| CN101131709B (en) | Distributed circuit layout character face processing method and system thereof | |
| TW200417884A (en) | System and method for automatically classifying bill of material | |
| CN206649539U (en) | A kind of antenna works independently shelf of making an inventory | |
| CN1804892A (en) | Merchandise information acquisition and processing terminal | |
| CN107301239A (en) | A kind of database converter and conversion method | |
| CN113253951A (en) | Paper contract information printing method, system, device and readable storage medium | |
| CN1987855A (en) | Data processing method and system | |
| CN101482947A (en) | Foreign trade document information management method and system based on remote network | |
| CA3141311A1 (en) | Method and apparatus for report development based on generic indicators | |
| CN1484185A (en) | Vending machine and system thereof |
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: 20060719 |