KR100646181B1 - Visual bom building system for total materials management system - Google Patents

Abstract

A system for forming a visual BOM(Bill Of Material) for an integrated material management system is provided to automatically generate part classification codes of an infinite reverse tree structure, automate registration caused from Excel import, form the BOM through a visual interface by a drag and drop function of Windows, and inquire the BOM while viewing an inputted part. A basic information module(110) receives/registers company information and customer company information, and performs search by receiving an inquiry for the registered company information. A material information database(120) registers a code length and a unit by receiving the code length of material, half-finished product, and finished product information, and registers the material, half-finished product, and finished product information. A BOM forming module(130) registers part formation of the half-finished or finished product, and a vertical level among the parts. A production managing module(140) registers a production plan received from a company and performs the search by periodically receiving the inquiry for the production plan based on the received production plan.

Description

Visual BOM building system for total materials management system

Figure 1 is a block diagram showing a visual BM configuration system for an integrated material management system according to the present invention.

FIG. 2 is a block diagram illustrating a detailed module of the visual BIEM configuration system of FIG. 1. FIG.

3 is a data flow diagram illustrating a detailed data flow of the visual BOM configuration system of FIG.

<Brief description of the major symbols in the drawings>

10: visual biom configuration system 12: integrated material management server

14: Database 16a, 16n: User PC

20: Integrated Material Management System

The present invention relates to a visual BOM configuration system, and more specifically, to import and export existing Excel data (BOM, material master) to the computerized construction of SMEs lacking manpower and time Automatic generation, mass registration and management of material codes prevents manual errors, improves the accuracy of data, and shortens the development period of the computer system. It relates to a BOM configuration system.

In general, the Bill of Material (BOM) is simply defined as data on which parts a specific product is composed of. The most basic information in such a BOM is a product structure information (Product -Structure) '. A BOM that represents the structure of a product made up of discrete parts is called the Product Structure, Bill of Material, Part List, etc. In the oil and chemical producers, it is called Recipe and Formulation. There are many departments in an enterprise, and each department has a wide variety of views on products or parts. It is used for the purpose of making sales forecasting and MPS easy, and there are various types of bills which have been modified. These are collectively called plan bills.

Such a bill of material may include a list, chart, or figure that shows the relationship between the product and its parts, the amount used to manufacture the product, and the units of use for all items.

As described above, since the BOM information is slightly different from each manufacturer and the corresponding field, computerization is performed by inputting the BOM information from the corresponding company operating the integrated material management system.

However, generally used integrated material management system has the following problems.

First, most small and medium sized companies use inconsistency because they use the code of the subcontractor without subcontractor's own part code in parts management, and if all the subcontractor changes or changes, all the codes change. Standardized management is difficult. This is the most basic and most important part of the company's computerization, but it has the problem of being neglected.

Second, the BOM information must be entered manually by hand, of which part codes must be entered manually as well, and since the small and medium manufacturers cannot spend much time on the computerization, the most basic BOM cannot be constructed and thus integrated. The material management system has the disadvantage of becoming useless.

Third, in order to successfully computerize after inputting the BOM information, there must be a support tool that can verify the inputted BOM information before building. However, since there is no such support tool, it is not possible to classify or verify the code. There is a problem.

The present invention is to solve the above-described problems , automatically generate the part classification code of the infinite inverse tree structure, automate registration by Excel import, configure the BOM according to the visual interface by dragging and dropping windows Inquiry of BOM by looking at inputted part image, search of similar parts name by synonym DB dictionary, backtracking search of common parts according to product name, and visual visual for integrated material management system to facilitate conversion to heterogeneous DB Its purpose is to provide an OM configuration system.

In order to achieve the above object, the present invention provides an integrated material management server, a database, and an integrated material management system composed of a plurality of computers. The part code auto generation function that automatically composes the overall part code length by selecting the number of digits by the lower level of each classification of the code and automatically generates the classification code, and the part code is moved by freely moving the item by selecting the part item with the mouse on the window screen New window drag and drop interface that automatically changes according to classification, database synonym search function to standardize part names by searching similar names of parts before parts registration, Access, MS-SQL, Oracle To migrate the classification code registered between heterogeneous DB Conversion function, image registration and display function for registering, modifying, and rotating images of parts, visual BioM configuration function to register BOM by selecting the relevant parts with mouse on the window screen, product registration and authentication on the Internet web It is equipped with a web distribution function that allows you to track and manage the required components of the parts.

 A basic information module for receiving and registering corresponding company information and trading company information, and receiving and searching an inquiry about registered company information; Register code length by inputting code length of material, semi-finished product and finished product information used by company, register material master information by inputting material, semi-finished product and finished product information used by company, and register A material information module for receiving and registering a unit; BOM configuration module that receives and registers the vertical level between the parts, which parts are semi-finished or finished products; A production management module that receives and registers a production plan for the enterprise to produce a product, and receives and searches for a periodic production plan based on the registered production plan; A purchase management module that calculates a quantity required for materials used for production based on data transmitted from the BOM configuration module and a production management module, and receives and registers orders of the trading company; It is characterized in that it comprises a material input and output management module for receiving and registering the goods receipt and release of the material, and displays the incoming and outgoing status of the registered material.

In a preferred embodiment, the BOM configuration module is a material lookup screen, the searched subpart list screen, BOM can be searched for the sub-parts when the semi-finished or finished product is composed of what parts, the vertical level between the parts And displaying a configuration screen and receiving the searched sub-components by dragging and dropping the BOM configuration screen or by double-clicking the searched sub-components.

According to a preferred embodiment, according to the code length input from the material information module, the BOM configuration module is characterized in that it automatically generates a part code according to the completed part information.

Hereinafter, the present invention will be described in detail with reference to the accompanying drawings.

Figure 1 is a block diagram showing a visual bioM configuration system for an integrated material management system according to the present invention, automatically generates the part code in the specified number of digits, can be moved freely by drag and drop on the window screen, graphics An integrated material for integrated management of materials of a company in real time using the BOM information delivered from the visual BOM configuration system 10 and the visual BOM configuration system 10 for composing BOM information, which is an attached bill of materials. It consists of a management system 20.

Here, the integrated material management system 20 is an integrated material management server 12 for integrated material management, a database 14 for this, and a client for performing the integrated material management work remotely in real time through the Internet. The first to nth user PCs 16a and 16n are included.

This will be described in more detail the Visual BioM configuration system 10 for the integrated material management system (20).

FIG. 2 is a detailed block diagram of a visual BM configuration system according to the present invention, wherein the BMB configuration system automatically generates an overall component code length and automatically generates a classification code by selecting a digit for each lower level of each component classification code. 1) Component code automatic generation and, two weeks to select a part item in the Windows screen, with the mouse sikimyeo free to move items to the newly changed automatically according to the classification to move the part code) Windows drag and drop (drag and drop) interface Function is installed.

In addition, the Visual BM configuration system searches for similar names of parts before registration of parts, and standardizes the parts names. 3) Database synonym search function , Access, MS-SQL, Oracle heterogeneous classification code registered between different DBs 4) Data conversion function for migrating, image registration and display function for registering, modifying, rotating, etc. of parts, and 5) Visual BioM configuration for registering BOM by selecting the relevant parts with the mouse on the window screen function, the product will be registered on the web and Internet certificates that 6) Web deployment feature 7 can keep track of the amount of component parts) BOM reverse lookup stars featured.

These functions are performed by the following modules.

In other words, the visual BM configuration system receives the relevant company information, the trading partner company information is registered, and the basic information module (11) to request and search for the inquiry on the registered company information, materials, semi-finished products used in the enterprise Register code length by inputting code length of finished product information, input material, semi-finished product and finished product information used by company, and register material master information, and input material of semi-finished product and finished product Module 120 is provided.

Here, the material information module 120 can be used by importing (Excel) file of the Excel format of Microsoft (Microsoft) company used in the existing company, access, MS-SQL, Oracle heterogeneous It is configured to migrate the classification code registered in the DB, and is configured to register the material image information taken by the camera, the code length in the material information module 120 can form a tree at an infinitely lower level. The registered code length affects all modules of the Visual BM configuration system, and a part information having a standardized code length is constructed, and whether or not a similar part name already entered and registered exists is searched for. A thesaurus is provided to help you.

In addition, the semi-finished or finished product is composed of parts, BOM configuration module 130 for receiving the registration of the vertical level between the corresponding parts, and the company receives the production plan for the production of the product, registered and registered Based on the production plan, the production management module 140 for receiving a search for a request for a periodic production plan, and the materials used for production based on the data transmitted from the BOM configuration module 130 and production management module 140 The purchase management module 150 is provided to calculate the required quantity and to receive and register the order information of the customer company, that is, the order. At this time, the BOM configuration module 130 is a semi-finished or finished product is composed of what parts, when receiving the vertical level between the corresponding parts, the material search screen to search for the lower parts, the searched lower parts list screen, BOM A configuration screen is displayed, the searched sub-components are dragged and dropped into the BOM configuration screen or inputted by double-clicking the searched sub-components, and data conversion is performed in heterogeneous MS-SQL or Oracle format as necessary.

In addition, the material input and output management module 160 for receiving and registering the goods receipt and release of the material, and displays the status of incoming and outgoing registration of the registered material, and stores the information processed by each module as a database and stored at any time It is configured to include a backup management module 170 to restore the.

Looking at the data flow between each module of the Visual BOM configuration system 10 in detail as follows.

3 is a data flow diagram illustrating the detailed data flow of the visual BOM configuration system according to the present invention.

① Basic Information Module 110 → Purchase Management Module 150

Basic information module 110 transmits the registered company information and customer information to the purchase management module 150,

② Material Information Module 120 → BOM Configuration Module 130

The material information module 120 transmits basic information of registered materials and products to the BOM configuration module 130.

③ material information module 120 → production management module 140

Material information module 120 transmits the basic information of registered materials, products to the production management module 140,

④ material information module 120 → purchase management module 150

The material information module 120 transmits basic information of registered materials and products to the purchase management module 150.

⑤ material information module 120 → material access management module (160)

The material information module 120 transmits basic information of registered materials and products to the material access management module 160.

⑥BOM configuration module 130 → production management module 140

BOM configuration module 130 transmits the registered material specification information to the production management module 140,

⑦BOM configuration module (130) → purchase management module (150)

BOM configuration module 130 delivers the registered material specification information to the purchase management module 150,

⑧Production Management Module (140) → Purchase Management Module (150)

Production management module 140 transmits the production plan information for producing a product to the purchase management module 150,

⑨ production management module 140 → material access management module (160)

Production management module 140 transmits the production plan information for producing a product to the material access management module 160,

매 Purchasing management module 150 → Material access management module 160

The purchase management module 150 automatically calculates a requirement of the material based on the production plan and the material specification information, and transfers it to the material access management module 160.

For reference, each step is not to be carried out instantaneously, but is given a number for convenience of description.

According to a preferred embodiment of the present embodiment as described above has the following advantages.

First, there is an advantage that the part code can be automatically generated by the infinite tree structure and the registration can be automated.

Second, BOM information can be configured by double-clicking or dragging and dropping the mouse, and can be verified compared to manual input.

Third, the part information can be input to Excel and can be converted to a heterogeneous database.

Fourth, there is an advantage that the similarity between parts names can be confirmed by thesaurus search.

Fifth, after verifying the company's coding and BOM configuration information using the automatic part code generation function and the Excel import function, it can be used as a preparatory step to transition to an integrated material management system or an enterprise resource planning system (ERP system). .

Claims (3)

In the visual biom configuration system for providing visual biom information to the integrated material management system consisting of an integrated material management server, a database, a plurality of computers, The visual non ohem configuration system overall part code length automatic configuration and classification codes 1) Item code automatic generation and part selection item in the Windows screen, with the mouse, to the automatically generated according to the classified-low-level-specific digit selection of parts sort code 2) The window drag and drop interface function that automatically moves the item freely and automatically changes according to the classification that moved the part code, and standardizes the part name by searching the similar name of the part before the part registration. 3) Database thesaurus search function , Access, MS-SQL, Oracle 4) Data conversion function for migrating the classification code registered between heterogeneous DB cross-products, image registration for image registration, modification, rotation, etc. display function, 5 for registering the BOM by selecting the appropriate parts with the mouse in the window screen) a visual non ohem configuration feature, the As registered products from the four and web authentication that 6) Web distribution capabilities, 7) BOM reverse lookup feature that one can keep track of the required component parts are mounted, A basic information module for receiving and registering corresponding company information and trading company information, and receiving a search for a request for registered company information; Register code length by inputting code length of material, semi-finished product and finished product information used by company, register material master information by inputting material, semi-finished product and finished product information used by company, and register Material information module to register the unit received; BOM configuration module that receives and registers the component level of the semi-finished or finished product, the vertical level between the corresponding parts; A production management module that receives and registers a production plan for a company to produce a product, and requests and retrieves a periodic production plan based on the registered production plan; A purchase management module that calculates a quantity required for materials used for production based on data transmitted from the BOM configuration module and a production management module, and receives and registers orders of the trading company; Material input and output management module to receive and register incoming and outgoing goods, and to display the status of registered goods. Visual bioM configuration system for an integrated material management system comprising a. The method of claim 1, The BOM configuration module displays a material inquiry screen, a searched sub-part list screen, and a BOM configuration screen for searching for sub-parts when the semi-finished or finished product is composed of which parts and the vertical level between the corresponding parts. And visually drag and drop the searched sub-components onto the BOM configuration screen or by inputting the searched sub-components by double-clicking the searched sub-components. The method according to claim 1 or 2, According to the code length input from the material information module , the BOM configuration module Visual BMS system for an integrated material management system, characterized in that for automatically generating the part code according to the input part information.

Images