TW200411485A - BOM distribution management method and system - Google Patents

Abstract

The present invention provides a BOM distribution management method and system, wherein a distribution module executes the distribution of BOM content according to different user requirements and stores it into a database; next, a checking module searches out the matched BOM data from the database based on the checking right of the user and the inputted checking requirement, and transmits it to the client data processing system; then, making a modification module to modify the BOM content based on the modification right of the user; finally, making a management module to store the BOM content into the backend data processing system based on the modification content of the user for the user to conduct BOM management. The BOM distribution management method and system can provide the user to check or modify the required BOM content based on different privileges or requirements.

Description

200411485 V. Description of the invention (1) [Technical field to which the invention belongs] A method and system for managing and managing bills of materials. More specifically, it relates to a bill of materials that can provide different contents of bills of materials according to different user perspectives. Distribution management method and system. [Previous technology] As long as it is "manufacturing", it is necessary to buy raw materials from the supply side, process or assemble it, manufacture products, and sell to the demand side. This is also the difference between the manufacturing industry and the financial industry, commerce, and extraction (oil , Minerals), the main characteristics of the service industry. The operation and production activities of any manufacturing industry are carried out around its products, and the information system of the manufacturing industry is no exception. The process of material management is based on the product structure or bill of materials, which realizes the integration of material information. Wide tapered product structure: the top layer is the factory product, which is the business of the sales department of the enterprise; the bottom layer is the purchased raw materials or supporting parts, which is the business of the company's material supply department; the intermediate part is the manufacturing part, which is the production Department of business. In order to integrate the π sales and supply information of an enterprise under the guidance of a unified plan according to the priority order of needs, the bill of materials (B 1 1-1 〇f M ateria 1; Β 0 Μ) also This is the basic file of the product structure. The so-called bill of materials refers to a list of the number of components needed to produce a product. It also provides information about the product architecture. The main parts and materials needed for each product (including the material number, product name, requirements specifications and quantity, etc.) are included in the material usage list, so the material usage list is the most important working document required for product manufacturing. On the bill of materials, the subordinate relationship and quantity relationship between various materials are reflected, and the connection between them is reflected

17093. ptd Page 5 200411485 V. Description of the invention (2) Reflects the process flow and time period; in other words, through a product structure, the "quantity standard" commonly used in manufacturing production management can be explained. The bill of materials is mainly used In the manufacturing industry that assembles π-type products, if the process flow such as procedures, equipment or devices are integrated with the product structure, the characteristics of the process industry can be integrated. In summary, the Existence plays an important role in the product manufacturing process. Both the R & D designer and the manufacturer regard the bill of materials as the benchmark for their operations, especially for the manufacturing department. Known methods and systems for the allocation and management of bills of materials Only one kind of bill of materials content is provided for users to view and modify, that is, the data presented to the user is the entire content of a product's bill of materials. Although the presentation of this bill of materials is complete, it may not be practical, Because it is not from the perspective of the viewer to present the contents of the bill of materials actually needed. The designer may need the complete BOM content; while the manufacturer may have different production processes for the same product in different factories, the BOM should have different presentation methods. If the manufacturer and the R & D designer or The contents of the bill of materials viewed by manufacturers in different factories are the same, which not only lacks practicability, but also easily leads to the user's trouble of viewing and the opportunity for errors. _ On the other hand, the conventional management method and system of bill of materials cannot provide The user has to backtrack the original or previous version of the BOM content, which is extremely inconvenient for users who want to compare the content of the new and old BOM versions. Furthermore, when the user creates or changes the content of the BOM, its data

17093. ptd page 6 200411485 V. Description of the invention (3) Whether to store it in a back-end data management system. The conventional method and system for managing the allocation of bills of materials does not provide users with the function of choice. Therefore, it is easy to cause too many versions of the BOM, which is inconvenient for users to query and view. [Summary of the Invention] In order to solve the shortcomings of the conventional technology described above, the main purpose of the present invention is to provide a method and system for managing BOM allocation, which may provide a BOM allocation mechanism, and then create different BOM content structure. Another object of the present invention is to provide a method and a system for managing and managing the bill of materials, which can provide a function of displaying the contents of a bill of materials in accordance with user rights and requirements. Yet another object of the present invention is to provide a method and system for managing and managing the bill of materials, which can provide users to query the contents of different phases or versions of the bill of materials retrospectively. It is still another object of the present invention to provide a method and system for managing and managing bills of materials, which can provide users with a choice of whether to store or create a bill of materials to a back-end data processing system according to actual needs. In order to achieve the above-mentioned object, the BOM distribution management system of the present invention includes: a storage for providing the BOM distribution management system including at least BOM data, BOM allocation data, user authority data and BOM modification A database of recorded data, etc .; one for providing the BOM allocation management system to generate an allocation module corresponding to the requirements of the BOM content according to different user needs; and one for providing the BOM analysis

17093. ptd Page 7 200411485 V. Description of the invention (4) The distribution management system displays a viewable bill of materials content according to the user's authority and the viewing conditions entered; a view module for providing the basis of the bill of materials allocation management system User authority and input content to modify the BOM content modification module; and a module to provide the BOM distribution management system to store the BOM-BOM to the BOM according to the BOM content created or changed by the user and its requirements Management module for back-end data processing system. Through the BOM allocation management system, the implementation of the BOM allocation management method is as follows: first, make the allocation module execute the BOM content allocation according to different user needs and store it in the database; second, make the inspection module According to the user's viewing authority and the inputted viewing requirements, the permitted BOM data is retrieved from the database and transmitted to the client data processing system; further, the modification module is executed according to the user's modifying authority. Modification of BOM content; and finally, make the management module store the BOM content to the back-end data processing system based on the user's modified content and requirements for the user to manage the BOM. Compared with the conventional method and system of BOM allocation management, the method and system of BOM allocation of the present invention may provide a BOM allocation mechanism, and then establish different BOM content structures according to different user rights and requirements. In addition, FOUND provides a method to display the contents of the BOM according to user rights and needs, to query the contents of different phases or versions of the BOM retrospectively, and to choose whether to save the created or changed BOM to the back end according to the actual needs of the user Data processing system. [Embodiment] Please refer to FIG. 1. As shown in the figure, in this embodiment, the present invention

17093.ptd Page 8 200411485 V. Description of the invention (5) BOM distribution management system 1 0 0 is used in a master-slave architecture network communication system 2 0, and the BOM distribution management system 1 0 0 Built on a server side of the network communication system, a client user of the network terminal device 300 and the network terminal device 400 with a network connection function is provided through a browser application program through the The network communication system 2000 and the BOM distribution management system 100 built on the server end are interconnected to perform data transmission and reception including data related to BOM distribution management. The network communication system 2000 can be an Internet, an intranet, or an extranet; the network terminal device 300 and the network terminal device 4 0 0 must be a personal computer (PC), a notebook computer (NB) or a workstation (Workstat i on); the browser application must be Microsoft's Internet Explorer or Netscape's pilot (Netscape Navigator) and so on. The aforementioned master-slave architecture network communication system 2, the network terminal device, and the browser application are all known software and hardware architectures, so they are not described in detail here. Please refer to FIG. 2, which shows the system structure of the BOM allocation management system 100 of the present invention. As shown in the figure, the BOM allocation management system 1 0 0 is equipped with a network server 2 1 0. The network The road server 2 1 0 provides the BOM distribution management system 1 0 0 through the network communication system 2 0 0 and the network terminal device 3 0 0 and the network terminal device 4 0 0 to each other and provide the network terminal Device 300 and network terminal device 400 respond to the user's instructions or other needs for data access. In this embodiment, the network terminal device 300 and the network terminal device 400 are based on each of the network terminal devices.

17093. ptd Page 9 200411485 V. Description of the invention (6) A web browser application, such as the aforementioned Microsoft's Internet Explorer or Netscape's navigator, via the network communication system 2 0 0 through the network The road servo system 2000 and the BOM distribution management system 100 are connected to each other to carry out the work of transmitting, receiving and accessing the BOM data. In addition, the BOM distribution management system 100 and a back-end data processing system 500 are connected to each other through the network communication system 1 200, and are used to generate the BOM distribution management system 100 Material early morning related data is stored in the backend data processing system 500. In this embodiment, the backend data processing system 500 is an Enterprise Resource Planning (ERP) system. The BOM distribution management system 100 includes a database 110, a distribution module 120, a viewing module 130, a modification module 140, and a management module 150. The database 1 1 0 provides the BOM distribution management system 1 0 0 for storing a user through a network terminal device through the network terminal system 2 0. The input includes at least a BOM data table and a BOM Allocation data table, user authority data table, BOM modification record data table, etc. In this embodiment, in order to increase the efficiency of data query and retrieval, the database 110 can be an associated database. Among them, the BOM data sheet includes at least the information such as the product name, part number, specification, and quantity of each component required for product manufacturing; the BOM allocation data sheet includes at least the BOM allocation structure and the BOM Data fields such as viewer permissions and requirements; The user permission data table at least includes data blocks such as user identity, user's affiliation, and user permissions; the BOM modification record data

17093. ptd Page 10 200411485 V. Description of the invention (7) The table at least includes data fields such as records of BOM modification and BOM version. Through the establishment of such a relational database, when a user enters any of the above materials, the BOM distribution management system 100 can quickly find its corresponding data. However, it is necessary to specify that the aforementioned data fields and the data sheets to which they belong are just examples, and in actual circumstances, their content should be more clear and detailed. In addition, the content of each data field may also contain other data blocks or data lists. However, due to space limitations and conciseness in presentation, only some data related to the management of the bill of materials are displayed. On the other hand, there are many types of system architectures for the relational database. How to establish them is a conventional technique, so it is not described in other articles. The distribution module 12 is used to provide the BOM distribution management system 1 0 0 to generate the content of the corresponding BOM according to different user needs. In this embodiment, the bill of materials may have all or one part according to the nature of the user's work, his or her functions and powers, and the same or different presentation methods. It is sufficient for the responsible developer to view the complete contents of the bill of materials as a reference for design and development; while the manufacturer only needs to view the contents of the bill of materials related to the production line in which he is responsible. On the other hand, different factories may change the manufacturing process of the product and even temporarily change the content of components for the same product. Therefore, even if the same product is manufactured in different production lines in different factories, it is the responsibility of the manufacturer. The contents of the BOM are different. According to the previous description, the distribution module 120 can make all or all of the contents of the bill of materials according to the nature of work of different users, their powers and their needs.

17093. ptd Page 11 200411485 V. A description of the invention (8); the same or different presentation. In addition, the distribution module 120 manages the bill of materials of different contents in stages. For example, a complete bill of materials is used as the parent stage, and the contents of the bill of materials corresponding to different plants are used as child stages. And different factories have different ways of presenting the BOM, as before, so a parent BOM may include different child BOMs. The viewing module 1 30 is used to provide the BOM distribution management system 1 0 0 to display permitted BOM contents according to user permissions and inputted viewing conditions. In this embodiment, different BOM contents are displayed to correspond to different users. The detection module 130 will be based on the user name and authority identification entered by the user through the user's network terminal device. User rights such as codes, and viewing requirements such as plant data, product numbers and / or bill of materials numbers, retrieve the permitted bill of materials data from the database 110, and send it through the network communication system 2000 Go to the client network terminal device for users to view the contents of the BOM. The modification module 1 40 is used to provide the BOM distribution management system 1 0 0 to change the BOM content according to user rights and input content. In this embodiment, when the user views the BOM, the contents of the BOM will be modified according to different requirements. On the other hand, the user may re-establish the material inventory of the same or other products according to the contents of the BOM. Then the modification module 140 can provide users to add, delete or modify the contents of the bill of materials or establish a new bill of materials through the network terminal device. The management module 150 is used to provide the BOM distribution management system 1 0 0 According to the content of the BOM created or changed by the user and its requirements,

17093. ptd Page 12 200411485 V. Description of the invention (9) The bill of materials is stored in the database π 〇; In addition, the content or demand of a user is retrieved and the back end of the created or changed bill of materials is transmitted to the back end The data processing system 500 stores it. In this embodiment, when the BOM is created or modified by the owner, a different valley from the original BOM will be generated. In other words, a different BOM version will be generated. In addition, the bill of materials modified by the developer and the bill of materials modified by the manufacturer, because the content reviewed in the original 7 is different, the revised content is also different, so the ¥ mold, and 1 500 must be based on Contents modified by different users are implemented in the 2nd 2f database 1 1 0. The contents of the BOM are stored, and the mark is added to the material temple * ^ single series 5 tiger and / or the BOM version serial number The method is different from the version of the first W, and then stored in the database π 〇. ^ On the other hand, the management module 1550 will send the content of the bill of materials to the back-end data processing system 500 according to the needs of the user, and provide it to the back-end data processing system 500. Process the bill of materials. / 明 苍 看 第 3 图 ’which shows the steps of implementing the BOM management method through the aforementioned BOM distribution management system 100, is

: ^ Step 33〇1, make the allocation module 120 to allocate and store in the database 110 according to the contents of the bill of materials previously used. Which = card = In this embodiment, the distribution module 120 will make the content according to different :; = = content of the bill of materials for a distribution, such as the first product, Weier! T "Its number is °° 01, Bei 11 provides the research and development of the head office; two ;;;! List :; must but ... therefore corresponds to the material list of the research h and I number 0001; if corresponding

200411485 V. Manufacturer of the invention description (ίο) factory, because the A factory divides the product into a and b rain parts for manufacturing, the distribution module 1 2 0 will respond to the manufacturing process of the A factory. The bill of materials is defined as 001 A, and the 001 A is divided into a part corresponding to a and a part corresponding to b and stored in the database 1 1 0. Among them, the material list number corresponding to &amp; can be 〇 〇 〇 1 A a; the material list number corresponding to b can be 000lAb. The same is true In addition, due to the different users, the BOM may have no content, and there is a relationship between the parent and child steps, as described above. In this embodiment of the library, the material list of the number 0001 is the parent material clearing; the material list of 0 1 A is the child list of the 0 QQ 1; and 0 0 0 1 Aa and The 0 0 0 1 Ab is again the sub-level bill of materials of the 00001 a, and is pushed by ^ *. Create the BOM data master through the above-mentioned BOM allocation method, and then proceed to step S302. In step S3 02, the viewing module 13 is caused to retrieve the allowed material list contribution from the database 1 10 according to the user's inspection, authority, and input viewing requirements and send it to the client data. Processing system 5 00. When the database of the bill of materials is established, the user must use the user's network terminal device to view the material through the network communication system. For example, if the user wants to view the material, he can enter such information as User name and identification code, etc., user rights, and inspection requirements such as factory data, product number or material early morning ring. Then, after the viewing module 1 30 is connected with the failure / the viewing authority and the viewing requirements, P remains to check the permitted bill of materials data from the database 110 and transmit it through the network communication system 200. Chu = the client network terminal device for the user to view the material to <

17093. ptd Page 14 200411485 V. Description of Invention (11) Content. If the user is for research and development, # 生 Λ, if there is, then the viewer will be the number 0 0 0 1 Material &gt; Early in the month, Fang Liang A factory's system, leather and 0 0 0 1 Ab bill of materials will be paid The reviewing process includes editing the word 001 Aa and step S303. Must be numbered 〇00〇1 her bill of materials, and then enter ^ ^, especially if it is clear, if the user permissions are sufficient, you can retrospectively view the previous version or the higher-level through the "K-view module 1 3 0". Contents of the inventory. —In V &amp; S 3 0 3 ’, make the modification module 1 4 〇 according to the modification authority of the user = modify the contents of the bill of materials. In this embodiment, the developer and the manufacturer may respectively make amendments within the authority regarding the numbered bill of materials 0 0 0 1 and the numbered bill of materials 0 0 0 1 A viewed. If it is the developer, modify the entire contents of the bill of materials; if it is the manufacturer, you can only add or delete the number of the bill of materials 〇 〇 〇 丨It must be specially explained that the changes made by the user to the contents of the bill of materials may become another brand new. The bill of materials may only be part of the changes, so leave it alone. In step S304, and finally, the management module 150 is caused to store the contents of the bill of materials to the post # 次 料 士 2 ^ 500 俾 according to the user's modified content and requirements for the user to manage the bill of materials. ^^ 2g bill of materials ^ created by the user will be generated or modified-the original bill of materials will have different contents, in other words, different versions of the bill of materials will be produced: In addition, 'the bill of materials and manufacture modified by the developer The bill of materials modified by the developer 'because the content that was originally viewed is different, the revised content is $ different', so the management module 1 50 must perform the change corresponding to the content repaired by different users. Database 1 1 〇 stored bill of materials ^ content 'and add to the bill of materials number and / or bill of materials Xiaoping version serial number

17093. ptd page 15 200411485 V. Description of the invention (12) The method of recording the symbol of the ticket is different from the previous version, and then it is stored in the database 1 1 0. On the other hand, the management module 150 can retrieve the contents of the bill of materials to the back-end data processing system 500 according to the needs of the user, and provide the back-end data processing system 500 for the bill of materials. Its processing. In summary, the BOM allocation management method and system of the present invention may provide a BOM allocation mechanism, and then establish different BOM content structures based on different user rights and requirements. In addition, FOUND provides a way to display the contents of the bill of materials according to user permissions and requirements, trace back the contents of different phases or versions of the query #list, and choose whether to save the created or changed bill of materials to the back end according to the actual needs of the user Data processing system. The above is only a preferred embodiment of the method and system for managing the bill of materials of the present invention, and is not intended to limit the scope of the essential technical content of the present invention. The material list allocation management method and system of the present invention are broadly defined in the following patent application scope, and any technical entity or method completed by another person is exactly the same as defined in the following patent application scope , Or equivalent changes, will be considered to be covered by this patent.

17093.ptd Page 16 200411485 Simple illustration of the drawing [Simplified illustration of the drawing] Fig. 1 is a schematic diagram of an application architecture block for showing the application architecture of the BOM management system of the present invention; Fig. 2 is a system architecture block A schematic diagram showing the system structure of the BOM allocation management system of the present invention; and FIG. 3 is a flowchart showing the process of the BOM allocation management method of the present invention. 10 0 Bill of materials distribution management system 110 Database 12 0 Distribution module 1 3 0 View module 140 Modify module 150 Management module 2 0 0 Network communication system 210 Network server 3 0 0 Network terminal device 4 0 0 Network terminal device 5 0 0 Backend feed processing system

17093.ptd Page 17

Claims (1)

200411485 VI. Scope of patent application 1 A bill of materials allocation management method for providing users with control of a bill of materials allocation management process through a network terminal device through a network communication system. The bill of materials allocation management method includes: An allocation module performs the allocation of BOM content according to different user needs and stores it in a database; ^ causes a view module to retrieve permits from the database according to the user's viewing authority and the input viewing requirements The BOM data is transmitted to the client data processing system for users to view different BOM contents according to their permissions; Φ Order a modification module to modify the BOM content according to the user's modification permissions; and The management module stores the contents of the BOM to the back-end data processing system according to the user's modified content and requirements, and provides users with BOM management. 2. For the method of applying for the first item of the patent scope, in which the basis of the material list content allocation can be any one of the user's job nature, authority, and business requirements. -3. The method according to item 1 of the scope of patent application, wherein the bill of materials of different contents is stored in the database in a tree structure. 4 The method of applying for item 1 of the patent scope, wherein the network terminal device may be any one of a workstation, a personal computer, a notebook computer, a palmtop computer, a personal digital assistant (PDA), and a mobile phone. -5. The method according to item 1 of the scope of patent application, wherein the network communication system can be an Internet or an intranet. 17093. ptd page 18 200411485 6. Scope of patent application) and any intranet. 6. If the method of the first scope of patent application is applied, the network communication system may be any of a wired communication system and a wireless communication system. 7. The method of claim 1 in the scope of patent application, wherein the database is an associated database. 8. The method of claim 1 in the scope of patent application, wherein the back-end data processing system is an enterprise resource planning (E n t e r p r i s e R e s 0 u r c e P 1 a η n i n g; E R P) system. 9. A BOM allocation management system for providing users with control of a BOM allocation management process through a network communication device through a network communication system. The BOM allocation management system includes: a database, which is Used to provide the BOM allocation management system storage including at least BOM data, BOM allocation data, user rights data and BOM modification record data; an allocation module, which is used to provide the BOM allocation management system basis Different user needs generate the corresponding BOM contents;-A viewing module, which is used to provide the BOM allocation management system to display the approved BOM contents according to the user rights and the input viewing conditions; A modification module is used to provide the BOM distribution management system to change the contents of the BOM according to the user authority and the content entered; and a management module is used to provide the BOM allocation management 17093. ptd Page 19 200411485 6. Scope of patent application The system stores the BOM to the back-end data processing system according to the contents of the BOM created or changed by the user and its requirements. 10. If the system of item 9 of the scope of patent application is applied, the basis for generating the material list of the distribution module may be any one of the user's job nature, authority, and business requirements. 11. The system according to item 9 of the scope of patent application, wherein the bill of materials of different contents is stored in the database in a tree structure. 1 2. If the system of item 9 of the scope of patent application, the review module provides users with the authority to retrospectively view the previous version or the higher-level (bill of materials. 1 3V. A system of 9 items in which the network terminal device can be any one of a workstation, a personal computer, a notebook computer, a palmtop computer, a personal digital assistant (PDA), and a mobile phone. 1 4. If the scope of patent application is the ninth Item system, wherein the network communication system may be any one of the Internet, an intranet, and an extranet. 1. If the scope of patent application is the 9th The system of the above item, wherein the network communication system may be any one of a wired communication system and a wireless communication system. 1 6. The system of item 9 in the scope of patent application, wherein the database is a piece of L-linked data 1 7. The system according to item 9 of the scope of patent application, wherein the back-end data processing system is an Enterprise Resource Planning (ERP) system. 17093.ptd Page 20