JP2000276526A - Management system for member constitution table - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a member constitution table management system which extracts only needed information from unitarily managed basic production information at each production place, quickly provides it, provides an environment where basic production information does not have to be managed at the production place and also can quickly calculate necessary requirements at each production place. SOLUTION: A production integration center 1 is provided with a means which registers each part with a database and corrects and eliminates it when each part constituting one product is manufactured at plural production places and in plural processes, a means which registers materials for manufacturing the product with the database and corrects and eliminates them, a means which registers a member table constituting the relation of parts and materials with the database and corrects and eliminates it and a means which manages a member configuration table for parts an to be manufactured and materials for every production place and for every process.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a bill of materials management system, and more particularly to a system in which, when one product is produced at a plurality of production sites for each process, the production of different partial parts at the production sites as a whole is unified. The present invention relates to a system useful for generating a component table of parts and materials and centrally managing a component table dependent on a production base.

[0002]

2. Description of the Related Art In a conventional system, in many cases, components from a component to a finished product are produced in one factory, and a parts list only needs to be managed for each product in each factory. In order to improve the efficiency of replacement of locally procured parts at overseas production bases and to centralize management of multi-vendor parts in the development of electronic equipment and global production, the parts list is still one per product. I only manage one.

For example, Japanese Patent Application Laid-Open No. Hei 5-26644 (hereinafter referred to as a conventional example) discloses a standard part library in which a development center defines the names and specifications of standard parts required as a standard for manufacturing equipment, and a standard part library. It has a multi-vendor component library that stores compatible multi-vendor component information corresponding to component specifications.In the design of electronic equipment, the standard component library and the multi-vendor component library are collated and selected in the design of standard components. Create a basic parts list that stores information on each part necessary for manufacturing the device. Then, each overseas production base receives a basic parts list and a multi-vendor parts library from the development center, and adds information on the production base to create a local parts list of parts that can be procured at the production base. is there.

[0004]

However, according to the conventional example, if the production processes are distributed among domestic and overseas production bases, even if the basic parts list is sent as it is, the parts list of the part in charge of production is sent. Has to be regenerated, and it is difficult to manage the parts list of each production site with consistency as a whole. Further, the conventional parts configuration table is a configuration of parts to be assembled into a product, and does not include all the materials used in the process, and it is difficult to calculate a required amount of materials other than the parts.

The present invention is intended to solve these problems. In the case of multi-site production, the parts configuration table handled at each production site is a part of the parts configuration table of the entire product, and this is unified. By adding a parameter called process to the parts configuration table for the purpose of management, and using a component configuration table that also adds materials other than the parts used in the process, it is necessary for each production site from the centrally managed basic production information. The purpose is to provide an environment in which basic information is not required to be managed at the production base, and to provide an environment in which the required quantity can be calculated quickly at each production base. I do.

[0006]

In order to solve the above-mentioned problems, the present invention provides a management system comprising a plurality of production bases and a production control center for controlling each production base. A component that generates a unified parts and materials composition table as a whole and manufactures a unified component composition table that depends on the production base when manufacturing parts of different parts at the production base when it is manufactured by each process at the production base. In the bill management system, the production supervision center registers the means for registering, modifying, and deleting each part in the database, the means for registering, modifying, and deleting materials for producing products in the database, and the relationship between parts and materials. It is characterized by comprising means for registering, correcting, and deleting a constituent member table in a database, and means for managing a member constituent table of parts and materials produced for each production base and each process. A. Therefore, when a component and material composition table of the entire product is created, a component composition table including production process information can be automatically generated, and required amount calculation for each production process can be easily performed. Also, by inputting materials other than parts used in the process into the composition table, the required amount of materials other than parts can be calculated, and a highly accurate production plan can be realized.

[0007] Further, a means is provided for dividing a component configuration table for each product for each production site, and when a product is produced at a plurality of production sites and a plurality of processes, a parameter called a process is added to the parts and material configuration table, thereby providing a product. By creating the entire bill of materials, a bill of materials containing production process information can be generated. By extracting the bill of materials for each production site process from process parameters, the required amount calculation for each production site can be easily performed. it can.

Further, there is provided a means for transferring each of the divided member configuration tables corresponding to the production bases to the database of each production base, and by transferring each of the divided member configuration tables corresponding to the database of each production base, The centralized management can be performed without compensating for the matching of the component configuration table, and it is not necessary to take out only a part depending on the production base from a so-called basic parts list.

In addition, a means for managing change history information of a part or material when there is a change in the design of a part, a change in a material, or a change in the amount of use is provided. If there is a part or material ID number, part name, material name, part number, material number,
Applicable model, lot number, registration date, input date, information on whether the parts before change have been used up or discontinued,
By managing the change history, etc., it is possible to promptly respond to a design change and give an accurate instruction.

Further, when there is a change in the design of parts, a change in materials, or a change in the amount of use, there is provided means for transferring information on the parts or materials to be changed to the database of each of the production bases. If there is a change in the usage or the amount of use, the information on the parts or materials to be changed is transferred to the database of each production site, so that it is possible to respond quickly to design changes at a remote production site, I can give instructions.

In addition, when there is a change in the design of parts, a change in materials, or a change in the amount of use at each production base, there is provided means for transferring information on the parts or materials to be changed to the database of each production base. When there is a change, material change, or change in the amount of use, by managing the change history such as the above-mentioned history information and information on which product lot was actually used, it is possible to respond to design changes promptly and accurately I can give instructions.

Further, each production site is provided with a means for managing the history of actual use of the materials actually used, and the actually used materials, for example, the use date and amount of the cleaning liquid, the amount used, the target model, and the target product By managing the history of use results such as lot numbers, it is possible to grasp not only the use results of materials but also the use results of materials, and it is easy to control the cost of materials for each production site. In addition, source data for determining the standard usage of materials can be easily obtained.

[0013]

DESCRIPTION OF THE PREFERRED EMBODIMENTS When each part constituting one product is produced at a plurality of production sites and a plurality of processes in a production control center, means for registering, correcting, and deleting each part in a database, and a product Means for registering / modifying / deleting materials for producing the parts in the database, means for registering / modifying / deleting the material table constituting the relationship between parts and materials in the database, parts for each production base and process, and Means for managing a material composition table.

[0014]

Embodiments of the present invention will be described below with reference to the drawings. FIG. 1 is a block diagram illustrating a configuration of a member configuration table management system according to an embodiment of the present invention. In FIG. 1, the production control center 1 is responsible for company-wide functions. The production bases 12-1 to 12-N are N production bases including respective processes for producing products, regardless of domestic and overseas. In the production control center 1, the member / process management library 2
In a, registration information of parts, materials, and processes is stored. The member configuration table 2b describes the configuration relationship between parts, materials, and processes. The material performance DB 2c stores material performance data. The display device 3 is a CRT
Etc. and display data. The output device 4 is a printer or the like, and prints member data. Various means relating to data are mounted on the management device 6. In the management device 6, the component / material management means 7 performs registration / update / deletion or switching / update of the component / material. The all-manufacturing-base process management means 8 registers, updates, and deletes the configuration of the company-wide production sites and production processes. A member configuration table dividing unit 9 is a unit that extracts data from the component configuration table for each production site and divides the data into a member configuration table for each production site. The member configuration table updating unit 10 is a unit that updates the member configuration table of each production site. The member configuration table creating unit 11 is a unit that creates a member configuration table for each production site. The communication unit 5 is a communication unit that communicates with a communication unit 13 of a production base, which will be described later, and is, for example, a WAN using a company dedicated line. E
Ethernet, router, etc. are assumed.
M, a frame relay, a telephone line, or the like may be used.

Each of the production bases 12-1 to 12-N includes a management device 14, a member / process library 18a, a member configuration table 18b, a material record DB 18c, a display device 19, and an output device 20. In addition, the management device 14 includes a component /
It is configured to include a material management unit 15, a production base process management unit 16, and a member configuration table updating unit 17.

In the member library 2a, all parts and materials used for a product to be produced are registered. There are multiple product lineups, and the shape, function, etc., are determined by model. The registration / modification / deletion of the member is executed by the part / material management means 7 of the management device 6.

Next, the process of newly registering a member (parts / materials) in the member library in the production control center according to the present embodiment will be described with reference to the flowchart shown in FIG. FIG. 3 is a diagram illustrating an example of a member library. Here, parts are basically drawings (including CAD).
Material is defined as anything else. The ID is an index indicating that the file is basically referred to from another file. For the new registration of the member, a member name, a member number, a type, a target model, a registrant, a registration date, a state, a switching flag, and the like are input (step S10).
1). Check for duplicate registration (step S10
2) If not, member I of the current member library (Fig. 3)
A member ID is generated by adding 1 to the maximum value of D (step S).
103), each item data is newly registered with the member ID (step S104). Speaking of liquid crystal, components are substrates,
Refers to drivers, connectors, etc.

The process of newly registering all processes in the process library in the production control center according to the present embodiment will be described with reference to the flowchart shown in FIG. FIG. 5 is a diagram showing an example of the process library. For new registration of a process, a process name, a target model, a production base, a registrant, a registration date, a parent process ID and the like are selected / input (step S201), and it is checked whether there is a duplicate registration (step S202). Otherwise, the maximum value of the process ID in the process library (Fig. 5) is 1
To generate a process ID (step S203), and newly register each item data with the process ID (step S2).
04). Speaking of liquid crystal, there are a loader, a washing step, a coating step, a drying step, an exposure step, a developing / peeling step, and the like.

Further, a new registration process to the member configuration table according to the present embodiment will be described with reference to a flowchart shown in FIG. FIG. 7 is a diagram illustrating an example of a member configuration table. In the process of new registration in the member configuration table, selection of a target device, a parent member, a target process, usage, a registration date, and the like are input (step S30).
1) It is checked whether there is any duplicate registration (step S302). If not, a configuration ID is created by adding 1 to the maximum value of the configuration ID in the member configuration table (FIG. 7) (step S30).
3), each item data is newly registered with the configuration ID (step S304). For example, in the case of liquid crystals, substrates, cleaning liquids,
It is on the pattern substrate by a resist solution, a developing solution and a stripping solution.

Next, in the production control center according to the present embodiment, the division of the parts / material / process library and the member structure table for each production site and the data transfer process for each production site are shown in FIG.
This will be described according to the flowchart shown in FIG. In the production control center 1 of FIG. 1, the member configuration table is divided by the production site by the member configuration table dividing means 9 of the management device 6, and is transferred to each production site 1 or the like (step S401). In the division / transfer of the member configuration table, a process depending on the production base X to be transferred is extracted from the process library of FIG. 5 to generate a process list (step S402). Next, a record other than the member configuration ID matching the process ID of the process list is extracted from the member configuration table (step S403). Member ID of the member configuration data from the member library of FIG.
Is extracted (step S40).
4). As a result, the process list, the component configuration list, and the component list depending on only the target production base are divided. For example, SQL (Structured Query La)
In an RDB (relational database) corresponding to an nuggage), a member library, a process library, and a member configuration table are represented by RDB tables, and each data item is a record. In addition, in order to search for a member having the same member ID, a condition can be extracted for the Where by SQL.
Further, the list is transmitted to the target production base by the communication means 5 and 13 in FIG.
The process library is transferred to the base member configuration table (step S405). For example, if there is newly registered data on that day, the data is automatically transferred at 2:00 am the next day by a shell function or the like.

A member switching change process in the production control center according to the present embodiment will be described with reference to a flowchart shown in FIG. In FIG. 1, when there is a change in the design of a component, a change in a material, or a change in the amount of use, the member or the material is changed by the member configuration table unit 10 of the management device 6. The change of the switching of the member is performed by selecting a member to be switched in the member library of FIG. 3 and changing a change point of each item, for example, a member ID or a used amount. And enter
Check for duplicate registration (steps S501 and S50)
2). If there is no overlap, member I of the member library in FIG.
The member ID is generated by adding 1 to the maximum value of D, the switching flag is turned on, and each item data is newly registered with the member ID (step S503). A configuration ID of the component configuration table of FIG. 7 that matches the component ID before change is searched, and a configuration ID is generated by adding 1 to the maximum value of the configuration ID of the component configuration table (FIG. 7).
A new registration is made with the configuration ID and the changed member ID (step S504). For example, when the design of the driver used in the liquid crystal display device is changed from A to A1, the driver is temporarily and redundantly registered. When the change completely shifts, the state of the member A becomes used and A1 is in use.

Further, the switching member information division / transfer processing in the production control center according to the present embodiment will be described with reference to the flowchart shown in FIG. In the production control center shown in FIG. 1, when there is a switch registration due to a change in the design of a part, a change in a material, or a change in a used amount, the part or the material is switched by the member change table dividing means 9 of the management device 6 to a switch change member. Is divided and transferred to the base member / process library of the production base 12 and the base member configuration table by the communication means 5 and 13 in FIG. 1 (step S601). In the division / transfer of the switching change member configuration table, a process depending on the production base X to be transferred is extracted from the process library of FIG. 5 to generate a process list (step S602). Next, a record other than the member configuration ID corresponding to the process ID of the process list is extracted from the member configuration table (step S60).
3). A member list in which the member IDs of the member configuration data match and the switching flag is ON is extracted from the member library of FIG. 3 (step S604). As a result, a process list, a component configuration list, and a component list that depend only on the target production base and have a change in switching are divided. The list is transferred to the target production base by the communication means 5 and 13 in FIG. 1 to the base member / process library of the production base 12 and the base member configuration table (step S605).

Next, the switching member input history processing at the production site according to the present embodiment will be described with reference to the flowchart shown in FIG. FIG. 12 is a diagram illustrating an example of a material input record. In the production base 12 shown in FIG. 1, the parts / material management means 15 of the management device 14 generates an insertion history of the members when the members are switched, when they are actually input. The input history of the switched member is input with the input date, the person in charge, and the like, and an overlap check is performed (steps S701 and S702). If there is no overlap, the material input result (FIG. 12) is registered. Also, the state of the original member to be switched is set to “switched”, the switched flag is set to “OFF” for the changed member, and the respective members are corrected and registered in the member library (steps S703 and S70).
4).

The material use record registration process at the production site according to this embodiment will be described with reference to the flowchart shown in FIG. FIG. 14 is a diagram illustrating an example of the material use history. In the production base 12 shown in FIG. 1, in order to keep a history of how frequently the materials are used for each process, the parts / material management means of the management device 14 uses the base material results DB.
18c. The usage history of the material is obtained by inputting the used member ID, the lot number, the number of target lots, the input date, and the like (steps S801 and S802), and specifically stores in the base material performance DB 18c as shown in FIG. (Step S803). Thus, for example, the total number of parts that have been cleaned until a material such as a cleaning liquid is charged and replaced can be calculated, and the standard replacement frequency of the cleaning liquid, the total number of standard usable parts, and the like can be calculated.
In addition, the standard cost can be calculated from the purchase amount per unit amount, the total use in the month, and the total number of parts.

Further, the present invention is not limited to the above embodiment, and needless to say, various modifications and substitutions can be made within the scope of the claims.

[0026]

As described above, according to the present invention,
In the case of production at multiple production sites and multiple processes, by adding a parameter called process to the component configuration table, creating a component and material configuration table for the entire product, a component configuration table including production process information is automatically generated It is possible to easily calculate the required amount for each production process. Also, by inputting materials other than parts used in the process into the composition table, the required amount of materials other than parts can be calculated, and a highly accurate production plan can be realized.

Further, in the case of producing at a plurality of production bases and a plurality of processes, by adding a parameter called a process to a parts and material composition table, a component composition table of the entire product is created. A configuration table can be generated, and a required amount calculation for each production site can be easily performed by extracting a component configuration table for each process at the production site from the process parameters.

Further, by transferring each of the divided member configuration tables corresponding to the database system at each production site, unified management can be performed without compensating for the consistency of the component configuration tables. It is not necessary to take out only the part.

When there is a change in the design of a part, a change in a material, or a change in the amount of use, the ID number of the part or the material, the part name, the material name, the part number, the material number, the corresponding model,
By managing the change history of the lot number, registration date, input date, information on whether the parts before change have been used up or discontinued, etc., it is possible to respond quickly to design changes and provide accurate instructions. it can.

Further, when there is a change in the design of a part, a change in a material, or a change in the amount of use, information on the part or material to be changed is transferred to a database system at each production base, thereby enabling the production at a remote production base to be changed. Respond quickly to design changes and give precise instructions to the site.

Further, when there is a change in the design of a part, a change in a material, or a change in the amount of use, the change history such as the above-mentioned history information and information on which product lot was actually used is managed, so that the design change can be promptly performed. In response to the problem, can give accurate instructions to the site.

Further, by managing the history of actual use of materials, for example, the use date, use amount, target model, target product lot number, etc. of the cleaning liquid, the use history of materials as well as parts is managed. And material cost management can be easily performed for each production site. In addition, source data for determining the standard usage of materials can be easily obtained.

[Brief description of the drawings]

FIG. 1 is a block diagram illustrating a configuration of a member configuration table management system according to an embodiment of the present invention.

FIG. 2 is a flowchart illustrating a new registration process to a member library in the production control center according to the embodiment.

FIG. 3 is a diagram illustrating an example of a member library.

FIG. 4 is a flowchart illustrating a process of newly registering all processes to a process library in the production control center according to the embodiment.

FIG. 5 is a diagram showing an example of a process library.

FIG. 6 is a flowchart illustrating a process of newly registering information in a member configuration table according to the embodiment.

FIG. 7 is a diagram illustrating an example of a member configuration table.

FIG. 8 is a flowchart showing division of a parts / material / process library and a member configuration table for each production site and data transfer processing for each production site in the production control center according to the present embodiment.

FIG. 9 is a flowchart illustrating a member switching change process in the production control center according to the embodiment.

FIG. 10 is a flowchart illustrating switching member information division / transfer processing in the production control center according to the present embodiment.

FIG. 11 is a flowchart illustrating switching member input history processing at a production site according to the present embodiment.

FIG. 12 is a diagram illustrating an example of a material input record.

FIG. 13 is a flowchart illustrating material use result registration processing at a production site according to the present embodiment.

FIG. 14 is a diagram showing an example of a material use history.

[Explanation of symbols]

 1 Production Control Center 2a, 18a Material / Process Library 2b, 18b Material Composition Table 2c, 18c Material Result DB 3,19 Display Device 4,20 Output Device 5,13 Communication Means 6,14 Management Device 7,15 Parts / Material Management Means 8 All production base process management means 9 Member structure table division means 10, 17 Member structure table update means 11 Member structure table creation means 12-1 to 12-N Production base 16 Production base process management means

 ──────────────────────────────────────────────────続 き Continued on the front page F term (reference) 9A001 CC07 JJ02 JJ05 JJ44 KK36 KK54 LL09

Claims (7)

[Claims] 1. A management system comprising a plurality of production bases and a production control center for supervising each production base, wherein different parts of the production base when one product is produced by each process at the plurality of production bases. In the production of parts, in a parts table management system that generates a unified parts table of parts and materials as a whole and centrally manages the parts table dependent on the production base, the production control center Means for registering / modifying / deleting in the database, and registering / registering materials for producing the products in the database
Means for correcting / deleting, means for registering, correcting / deleting a member table constituting the relationship between the part and the material in a database, and a member structure table for the part and the material produced for each of the production base and the process Means for managing the member configuration table. 2. The member table management system according to claim 1, further comprising means for dividing the member table for each product based on the product. 3. The member configuration table management system according to claim 1, further comprising means for transferring each of the divided component configuration tables corresponding to the production sites to the database of each of the production sites. 4. A system according to claim 1, further comprising means for managing change history information of said part or said material when there is a design change of said part, a change of said material or a change of used amount.
3. The member configuration table management system according to any one of 3. 5. A means for transferring, when there is a change in the design of the part, a change in the material, or a change in the used amount, information on the part or the material to be changed to a database of each of the production bases. The member configuration table management system according to any one of claims 1 to 4. 6. The member configuration table management system according to claim 1, further comprising means for managing, at each of the production bases, history information of parts or materials input into an actual process in addition to the change history information. 7. The member configuration table management system according to claim 1, wherein each of the production bases is provided with means for managing a history of use results of materials actually used.