JP2000029955A - Product information management system, and computer readable recording medium recorded with product information management data - Google Patents

Abstract

PROBLEM TO BE SOLVED: To enable follow-up check of information on the quality of products for every process without using a large capacity storage device. SOLUTION: This system is provided with production lot information recording files 14-44 for recording a lot number and lot information inputted corresponding to each process for every process, and recording the lot number of the precious process of each of all processes other than the first process by making it correspond to the lot number of the process, and a serial information recording file 53 for recording a serial number applied to each part manufactured in the first process, the lot number of the first process, and the lot number of the last process by making them correspond to each other. An information follow-up control means 5 retrieves the lot number of the first process and the lot number of the last process from the serial information recording file, and successively retrieves the lot number of the previous process from the lot information recording files based on the lot numbers. Thus, the information of the product of the serial number can be extracted across the whole processes.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

[0001] 1. Field of the Invention [0002] The present invention relates to a system for managing information on products manufactured in lot units through a plurality of processes, and a computer-readable recording medium for recording the product information management data.

[0002]

2. Description of the Related Art In the case of strictly required products requiring high accuracy and the like, if there are any defective products, countermeasures such as suspending the use and shipping of other products manufactured under the same manufacturing conditions are taken. There is a need. for that purpose,
It is necessary to be able to track information related to the quality of a product based on the serial number of the product. The information relating to quality is information such as manufacturing conditions of the product, quality inspection results, and the like.

When a product is manufactured through a plurality of steps as shown in FIG. 14, for example, a large-capacity storage device is required to record such information in each step for each product serial number. Becomes

[0004] Fig. 14 shows a product obtained by bonding a part formed in an injection molding step 1 and a part formed in an extrusion molding step 2 and subjected to a bending process in a next bending step 3 in a bonding step 4 in a bonding step 4. Is manufactured and shipped. After each step, a sampling inspection step is provided. Further, a serial number printing device is provided in the injection molding process 1, and a lot number in the extrusion molding process 2 is affixed to a cart transporting between the extrusion molding process 2 and the bending process 3. The lot number in the bending step 3 is affixed to the cart transporting between the step 3 and the bonding step 4.

In such a manufacturing process, for example, when six products are manufactured, if information of these products is to be recorded based on the serial number assigned to the product, a large amount of data is obtained as shown in FIG. Will be recorded. That is, for serial numbers from 001 to 006, one item of serial number, six items of injection molding process lot information, six items of extrusion molding process lot information, four items of bending process lot information, and four items of bonding process lot information Since a total of 21 items correspond, the number of data to be recorded is 126 (6 × 21). However, the number of items is limited here for easy understanding.

[0006]

As described above, the product is
When manufactured through a plurality of steps as shown in FIG.
If such information in each process is to be recorded for each product serial number, there is a problem that a large-capacity storage device is required as shown in FIG.

SUMMARY OF THE INVENTION The present invention has been made in order to solve such a problem, and an object of the present invention is to store product information in each process in association with each other without using a large-capacity storage device. Another object of the present invention is to provide a product information management system that enables information relating to product quality to be tracked for each process, and a computer-readable recording medium that records product information management data.

[0008]

According to a first aspect of the present invention, there is provided a product information management system for managing information on products manufactured in lots through a plurality of processes. Therefore, the lot number and the lot information input for each process are recorded for each process, and in each of all subsequent processes except the first process, the lot number of the previous process is recorded. A lot information recording file for recording in association with the lot number of the process, a serial number assigned to each of the parts manufactured in the first process, and the first process recorded in the lot information recording file. A serial information record file for recording the lot number and the lot number of the last process in association with each other, and tracking the product information from the serial number When searching the lot number of the first step and the lot number of the last step from the serial information recording file, based on this lot number, by sequentially searching the lot information recording file for the lot number of the previous step, Information tracking control means for extracting information on the product of the serial number over the entire process.

According to a second aspect of the present invention, there is provided a computer-readable recording medium on which product information management data is recorded, wherein the product information management data manages information on products manufactured in lot units through a plurality of processes. Wherein the product information management data is a lot information recording file for recording a lot number and lot information inputted corresponding to each process for each process, and a manufacturing process in the first process. Is recorded in a serial information recording file that records the serial number given to each of the parts to be processed, and the lot information recording file indicates the lot number of the preceding process in each of all subsequent processes except the first process. The serial information recording file has a lot information data area recorded in association with the lot number of the process. And it has a lot information data area recorded in association with the lot number of the Le number and the first step of the lot number and the last step.

A product information management system according to a third aspect of the present invention is a system for managing information on products manufactured in lot units through a plurality of processes, and corresponds to each of the processes. The entered lot number and lot information are recorded for each process, and in each of all subsequent processes except the first process, the lot number of the preceding process is recorded in association with the lot number of the process. A lot information recording file for recording the serial number given to each of the products manufactured through the last process in association with the lot number of the last process recorded in the lot information recording file. When tracking the product information from the serial information recording file and the serial number, the lot number of the last process from the serial information recording file Information tracking control means for searching for the lot number of the preceding process sequentially from the lot information recording file based on the lot number, thereby extracting the information of the product of the lot number over the entire process. And

According to a fourth aspect of the present invention, there is provided a computer-readable recording medium recording product information management data, wherein the product information management data manages information on products manufactured in lot units through a plurality of processes. The product information management data, the lot number and the lot information input corresponding to each of the steps, a lot information recording file for recording for each step and a last step It is recorded in a serial information recording file that records a serial number given to each manufactured product, and the lot information recording file is a lot number of a preceding process in each of all subsequent processes except the first process. Has a lot information data area recorded in association with the lot number of the process. And it has a lot information data area recorded in association with the lot number of the number and the last step.

[0012]

Embodiments of the present invention will be described below with reference to the drawings.

In the present embodiment, the manufacturing process to which the product information management system is applied is the same as the manufacturing process shown in FIG. That is, the part molded in the injection molding step 1 and the part molded in the extrusion molding step 2 and subjected to the bending process in the next bending step 3 are bonded in the bonding step 4 to produce a product, which is then shipped. Manufacturing process.

The various conditions in this manufacturing process are as follows. That is, in this manufacturing process, a part formed in the injection molding process 1 is used for a final product. Therefore, a label with a different serial number is attached to each of the parts molded in the injection molding process 1.

Each process is manufactured in lot units.
Here, the lot unit refers to manufacturing conditions, used raw materials (parts)
Indicates a group of identical items, and different lot numbers are assigned in a time series for each lot. However, even if the manufacturing conditions and raw materials (parts) are the same, different lot numbers are assigned to the lots before and after that when another product or one with manufacturing conditions is interposed therebetween as shown in FIG. Granted.

The transportation between the processes is performed by a transport trolley or the like, and the lot number of the previous process is attached to this trolley. In addition, quality inspection such as sampling dimensions is performed for each lot.

FIG. 1 is a block diagram showing the configuration of a product information management system of the present invention applied to a manufacturing process having the above conditions.

That is, for each of the steps 1 to 4, manufacturing condition input means 11 to 41 and inspection result input means 12 to 42 are provided, respectively.
From 1, a production lot number, a used raw material (part) lot number, and production conditions are input.

However, in the present embodiment, each of the manufacturing condition input means 11 to 41 is the equipment control device 13 of each of the steps 1 to 4.
To 43, and the manufacturing conditions are automatically input by communication from the equipment control devices 13 to 43. Further, the inspection result input means 12 to 42 in each of the steps 1 to 4 input the production lot number inspected and information on the quality inspection result of the lot.

Manufacturing condition information and quality inspection result information from the manufacturing condition input means 11 to 41 and the inspection result input means 12 to 42 are stored in lot information storage means (hereinafter referred to as lot information) provided for each of the steps 1 to 4. Recording file)
14 to 44.

Also, serial number input means 51, 52
Are provided in the injection molding step 1 and the bonding step 4 in the present embodiment. That is, every time one part is molded in the injection molding step 1, the serial number of the molded part and the lot number at that time are input, and each time one product is produced in the bonding step 4, the serial number of the produced product is The serial number and the lot number at that time are input, and the input information is stored in a serial number storage unit (hereinafter, referred to as a serial information recording file) 53. The serial number input by the serial number input means 51 is printed on each injection molded part by the serial number printing device 54 provided in the injection molding process 1.

Each lot information recording file 14-4
4 and the serial information recording file 53 are bidirectionally connected to the information tracking control means 55, and the information tracking control means 55 determines the product based on the data recorded in these files 14 to 44 and 53. And seek quality-related information. Although not shown, the obtained quality-related information is printed out by an output unit such as a printer, and is displayed on a screen by a display device such as a CRT.

FIG. 2A shows a data structure of lot information recorded in lot information recording files 14 to 44 provided corresponding to the respective steps 1 to 4, and FIG. 3 shows a data structure of serial information recorded in a recording file 53. Lot information includes lot number, raw material (part) 1 lot number, raw material (part)
2 lot number, ..., manufacturing condition 1, manufacturing condition 2, ...
.., The quality inspection result 1, the quality inspection result 2,..., And the serial information includes the serial number, the injection molding process lot number, and the bonding process lot number.

Next, the operation of the product information management system having the above configuration will be described using a simple manufacturing example shown in FIG. However, the operation description here corresponds to claims 1 and 2.

This manufacturing example is an example in which six identical products are manufactured while changing the manufacturing conditions in each step. That is, in the injection molding process 1, two lots A1 (manufacturing condition A1) and A2 (manufacturing condition A2) having different manufacturing conditions are formed, and four parts (serial number) of the lot number A1 are manufactured under the manufacturing condition A1. 001 to 004) and two parts (serial number 0
05, 006). Extrusion molding process 2
However, two lots B1 and B2 having different manufacturing conditions are formed, two parts of the lot number B1 are formed under the manufacturing conditions B1, and four parts of the lot number B2 are formed under the manufacturing conditions B2. ing.

In the bending step 3, the two parts of the lot number B1 formed in the extrusion forming step 2 are manufactured under the manufacturing conditions C1.
(Lot number C11), and the four parts of lot number B2 formed in the extrusion process 2 are manufactured under the manufacturing conditions C1 by 2
One piece (lot number C12) and two pieces (lot number C21) are processed under the manufacturing condition C2. In the bonding step 4,
All are processed under the same manufacturing conditions D, and the injection molding process 1
The two parts with serial numbers 001 and 002 affixed to the two parts with lot number C11 machined in bending step 3 and the two parts with serial numbers 003 and 004 affixed in injection molding step 1 Is bonded to the two parts of the lot number C12 processed in the bending step 3, and the two parts of serial numbers 005 and 006 affixed in the injection molding step 1 are the lot numbers processed in the bending step 3. C21-2
It is bonded to individual parts.

When six products are manufactured in this way,
Each of the lot information recording files 14 to 44 and the serial information recording file 53 records data having the contents shown in FIGS. However, FIGS. 4 to 7
Restricts the items to be recorded to the same items as those shown in FIG.

That is, in the lot information recording file 14 of the injection molding process 1, as shown in FIG. 4, "A1" and "A2" are recorded in the item of the lot number. Each item (in the present embodiment, six lots of used raw material (parts) 1 lot number, used raw material (parts) 2 lot number, manufacturing condition 1, manufacturing condition 2, quality inspection result 1, quality inspection result 2) The data is recorded in. Therefore, the total number of recorded data in the lot information recording file 14 is 14.

As shown in FIG. 5, in the lot information recording file 24 of the extrusion molding process 2, "B1" and "B2" are recorded in the item of the lot number. Each item (in the present embodiment, six lots of used raw material (parts) 1 lot number, used raw material (parts) 2 lot number, manufacturing condition 1, manufacturing condition 2, quality inspection result 1, quality inspection result 2) The data is recorded in. Therefore, the total number of recorded data in the lot information recording file 24 is 14.

As shown in FIG. 6, in the lot information recording file 34 of the bending step 3, "C11", "C12" and "C21" are recorded in the item of the lot number. Then, each item (in this embodiment,
Extrusion molding process lot number, manufacturing condition 1, manufacturing condition 2, quality inspection result 1, quality inspection result 2 which is the previous process)
Is recorded in each of them. Therefore, the total number of recorded data in the lot information recording file 34 is 18. Here, a feature of the present invention is that the lot information recording file 34 records the lot number of the extrusion molding process 2 which is the preceding process, corresponding to each lot number.

As shown in FIG. 7, in the lot information recording file 44 of the bonding step 4, "D11", "D12", and "D13" are recorded in the lot number field. Then, each item (in this embodiment,
Data is recorded in each of the bending process lot number, manufacturing condition 1, manufacturing condition 2, quality inspection result 1, and quality inspection result 2 which are the preceding processes. Therefore, the total number of recorded data in the lot information recording file 44 is 18. Here, it is a feature of the present invention that the lot information recording file 44 records a bending process lot number which is a preceding process corresponding to each lot number.

As shown in FIG. 8, the serial information recording file 53 has a lot number in the injection molding process 1 and a lot number in the bonding process 4 corresponding to the serial number given in the injection molding process 1. Lot numbers are recorded.
Accordingly, the total number of recorded data in the serial information recording file 53 is 18.

That is, according to this embodiment, when six identical products are manufactured while changing the manufacturing conditions in each process, the lot information recording files 14 to 44 and the serial information The total number of all data to be recorded is 82. That is, this total number of data is
5 when the data is recorded by the conventional method shown in FIG.
26, the number of data to be recorded is 46 (126).
-82) It can be seen that less is required. If the number of manufacturing and processing in the same lot is large, this difference will be further enlarged.

Next, referring to a tracking flowchart shown in FIG. 9, a description will be given of a processing operation in the case where information relating to the quality of the product (manufacturing conditions, quality inspection results, etc.) is traced from the serial number.

First, an injection lot number and an adhesion lot number used for a corresponding serial number are extracted from the serial information recording file 53 (step S1). For example,
An injection lot number A1 and an adhesion lot number D11 corresponding to the serial number 001 are extracted from the serial information shown in FIG. Then, by searching the lot information recording file 14 of the injection molding process 1 and the lot information recording file 44 of the bonding process 4 based on these lot numbers A1 and D11, the quality-related information in the injection molding process 1 and the bonding process 4 is searched. Information (information related to the lot number A1 shown in FIG. 4 and information related to the lot number D11 shown in FIG. 7) is obtained (step S2, step S3).

Next, since the lot number of the bending process 3 which is the preceding process is recorded in the lot information recording file 44 of the bonding process 1, the lot number is recorded based on the information of the lot number.
The lot information recording file 34 of the bending process 3 is searched to obtain quality-related information in the bending process 3 (Step S).
4). That is, from the lot information shown in FIG. 7, since the bending lot number corresponding to the bonding lot number D11 is C11, quality related information corresponding to the bending lot number C11 is obtained from the lot information of FIG.

Next, in the lot information recording file 34 of the bending process 1, the lot number of the extrusion molding process 2 which is the preceding process is recorded, so that the lot information of the extrusion process 2 is based on this lot number. The recording file 24 is searched to obtain quality related information in the extrusion process 2 (step S5).
That is, from the lot information shown in FIG. 6, since the extrusion lot number corresponding to the bending lot number C11 is B1, quality related information corresponding to this extrusion lot number B1 is obtained from the lot information of FIG.

As a result, it is possible to extract all the quality related information of the parts in each of the steps 1 to 4 relating to the product of the serial number 001. That is, information related to the quality of the product of the serial number 001 (manufacturing conditions, quality inspection results, etc.)
Can be traced back through each of the steps 1 to 4.

FIG. 10 is a block diagram showing another embodiment of the product information management system of the present invention applied to the manufacturing process having the above-mentioned various conditions.

That is, the difference from the configuration shown in FIG. 1 is that the serial number input means 51 and the serial number printing device 54 are not provided in the injection step 1, and the serial number printing device 54 is provided in the bonding step 4 side. This is the point that has been configured. Other configurations are the same as those shown in FIG.

In this embodiment, as a result of eliminating the serial number input means 51 in the injection molding process 1, the data structure of the lot information recording file 44 in the bonding process 4 is the same as the data structure shown in FIG. Slightly different, the data structure of the serial information recording file 53 is slightly different from the data structure shown in FIG.

FIG. 11 shows the data structure of the lot information recording file 44 in this embodiment, and FIG. 12 shows the data structure of the serial information recording file 53 in this embodiment. That is, the data structure shown in FIG. 11 has more items of the injection forming process lot number than the data structure shown in FIG. 7, and the injection lot number is recorded corresponding to the bonding lot number. Therefore, the total number of recorded data in the lot information recording file 44 is 21. On the other hand, the data structure shown in FIG. 12 is different from the data structure shown in FIG. 8 in that the item of the injection molding process lot number is deleted. Therefore, the total number of recorded data in the serial information recording file 53 is 12. Therefore, according to the present embodiment, when six identical products are manufactured while changing the manufacturing conditions in each process, the lot information recording files 14 to 44 and the serial information recording file 53 are changed.
Is 79 in total. That is,
Comparing this total number of data with the total number of data (126) recorded by the conventional method shown in FIG. 15, it can be seen that the number of data to be recorded can be reduced by 49 (126-79). If the number of manufacturing and processing in the same lot is large, this difference will be further enlarged.

Next, referring to a tracking flowchart shown in FIG. 13, a description will be given of a processing operation in a case where information relating to the quality of the product (manufacturing conditions, quality inspection results, etc.) is traced from the serial number.

First, an adhesive lot number used for a corresponding serial number is extracted from the serial information recording file 53 (step S11). For example, an adhesive lot number D11 corresponding to the serial number 001 is extracted from the serial information shown in FIG. And these lot numbers D
11, the lot information recording file 44 of the bonding process 4
To obtain the quality-related information in the bonding process 4 (information related to the lot number D11 shown in FIG. 11) (step S12).

Next, in the lot information recording file 44 of the bonding step 1, the lot number of the injection molding step 1 and the lot number of the bending step 3, which are the preceding steps, are recorded. , The lot information recording file 14 of the injection molding process 1 and the lot information recording file 34 of the bending process 3 are searched to obtain the quality-related information in the injection molding process 1 and the quality-related information in the bending process 3 (step). S13, step S14). That is, FIG.
From the lot information shown in FIG. 1, the injection lot number corresponding to the bonding lot number D11 is A1, and the bending lot number is C11. Therefore, the quality related information corresponding to the injection lot number A1 is shown in the lot information of FIG. And the quality-related information corresponding to the bending lot number C11 is obtained from the lot information in FIG.

Next, in the lot information recording file 34 of the bending process 1, the lot number of the extrusion molding process 2 which is the preceding process is recorded, so that the lot information of the extrusion process 2 is based on this lot number. The recording file 24 is searched to obtain quality-related information in the extrusion process 2 (step S1).
5). That is, from the lot information shown in FIG. 6, since the extrusion lot number corresponding to the bending lot number C11 is B1, quality related information corresponding to this extrusion lot number B1 is obtained from the lot information of FIG.

As a result, it is possible to extract all the quality related information of the parts in each of the steps 1 to 4 relating to the product of the serial number 001. That is, information related to the quality of the product of the serial number 001 (manufacturing conditions, quality inspection results, etc.)
Can be traced back through each of the steps 1 to 4.

The lot information recording file 14
44 and the serial information recording file 53 are provided by being recorded on a computer-readable recording medium.

[0049]

According to the product information management system of the present invention, a lot number and lot information input for each process are recorded for each process, and all subsequent processes except the first process are performed. In each of the above, a lot information recording file for recording the lot number of the previous process in association with the lot number of the process, and a serial number and lot information record individually given to the parts manufactured in the first process Using a serial information recording file for recording the lot number of the first process and the lot number of the last process recorded in a file in association with each other, the information of the product is tracked from the serial number. . Further, the product information management system of the present invention records the lot number and the lot information input corresponding to each process for each process, and in each of all subsequent processes except the first process. A lot information record file for recording the lot number of the previous process in association with the lot number of the process, and a serial number and a lot information record file assigned to each of the products manufactured through the last process. Using a serial information recording file for recording the lot number of the last process recorded in association with the lot number, the information of the product is tracked from the serial number. In other words, with such a file configuration, quality-related information such as manufacturing conditions and quality inspection results can be tracked over the entire process based on the serial number without using a large-capacity recording device for recording information. Can be investigated.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a configuration of a product information management system of the present invention.

FIG. 2A shows a data structure of lot information recorded in a lot information recording file provided for each process;
(B) shows the data structure of the serial information recorded in the serial information recording file.

FIG. 3 is an explanatory diagram of a simple manufacturing process.

FIG. 4 is a data configuration diagram of a lot information recording file in an injection molding process.

FIG. 5 is a data configuration diagram of a lot information recording file in an extrusion molding process.

FIG. 6 is a data configuration diagram of a lot information recording file in a bending process.

FIG. 7 is a data configuration diagram of a lot information recording file in a bonding process.

FIG. 8 is a data configuration diagram of a serial information recording file.

FIG. 9 is a flowchart for tracking information on the quality of the product from the serial number using the product information management system of the present invention.

FIG. 10 is a block diagram showing another embodiment of the product information management system of the present invention.

FIG. 11 is another data configuration diagram of a lot information recording file in the bonding process.

FIG. 12 is another data configuration diagram of a serial information recording file.

FIG. 13 is a flowchart of tracking information on the quality of a product from a serial number using the product information management system according to another embodiment.

FIG. 14 is an explanatory diagram illustrating an example of a manufacturing process.

FIG. 15 is a diagram showing a data structure when recorded in a recording file by a conventional method.

FIG. 16 is an explanatory diagram showing an example of assigning a lot number.

[Explanation of symbols]

DESCRIPTION OF SYMBOLS 1 Injection molding process 2 Extrusion molding process 3 Bending process 4 Adhesion process 11-41 Manufacturing condition input means 12-42 Inspection result input means 13-43 Manufacturing equipment control device 14-44 Lot information record file (lot information storage means) 51, 52 serial number input means 53 serial information recording file (serial information storage means) 55 information tracking control means

Claims (4)

[Claims] 1. A system for managing information on products manufactured in lot units through a plurality of processes, wherein a lot number and lot information input corresponding to each process are recorded for each process. And a lot information recording file for recording the lot number of the preceding process in association with the lot number of the process in each of all subsequent processes except the first process, and A serial information recording file for recording the serial number assigned to each part in association with the lot number of the first process and the lot number of the last process recorded in the lot information recording file; and a serial number. From the serial information record file, the lot number of the first process and the lot number of the last process Information tracking control means for extracting the product information of the serial number over the entire process by sequentially searching the lot information record file for the lot number of the previous process based on the lot number. Product information management system characterized by the following. 2. A computer-readable recording medium for recording product information management data for managing information on products manufactured in lot units through a plurality of processes, wherein the product information management data is A lot information record file that records the lot number and lot information input corresponding to each process and a serial information record file that records the serial number assigned to each of the parts manufactured in the first process The lot information recording file has a lot information data area in which, in each of all subsequent steps except the first step, the lot number of the preceding step is recorded in association with the lot number of the step, The serial information record file associates the serial number with the lot number of the first process and the lot number of the last process. A computer-readable recording medium on which product information management data is recorded, wherein the recording medium has a lot information data area recorded. 3. A system for managing information on products manufactured in lot units through a plurality of processes, wherein a lot number and lot information input corresponding to each process are recorded for each process. In each of the subsequent processes except the first process, a lot information record file for recording the lot number of the previous process in association with the lot number of the process, and a product manufactured through the last process A serial information recording file for recording the serial number assigned to each product and the lot number of the last process recorded in the lot information recording file in association with each other, and information of the product from the serial number. When tracking, the lot number of the last process is searched from the serial information recording file, and based on this lot number, the lot information is recorded. A product information management system comprising: an information tracking control unit for sequentially searching a lot number of a previous process from a record file to extract information of a product of the lot number over all processes. 4. A computer-readable recording medium for recording product information management data for managing information on products manufactured in lots through a plurality of processes, wherein the product information management data is A lot information record file that records the lot number and lot information entered corresponding to each process and a serial information record file that records the serial number assigned to each product manufactured through the last process Recorded, the lot information recording file, in each of all subsequent steps except the first step, has a lot information data area recorded in association with the lot number of the previous process and the lot number of the previous process, The serial information recording file is a lot information data recorded by associating the serial number with the lot number of the last process. A computer-readable recording medium on which product information management data is recorded.