JP2009076055A - Component related information management system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a component related information management system capable of suppressing the increase of data quantity even with an increase in the production number of products. <P>SOLUTION: The component related information management system 1 performs ID reading work for every combination of master-slave relations of components and units, and combines the master-slave relations of the components and units and records them in a database. When there is a large amount of combination data of the master-slave components, whenever retrieval of component related information is carried out, combination information of the object master-slave components is temporarily generated based on the component use information of the master-slave components to reduce data recording capacity. <P>COPYRIGHT: (C)2009,JPO&INPIT

Description

  The present invention relates to component-related information management for managing related information of each parent-child component in a production line for producing a product composed of a plurality of parent-child components consisting of at least one of a component and a unit that is a combination of components. About the system.

  Conventionally, the information indicating the relationship between the parts and / or the parent / child parts of the unit is related to the parent-child relationship by registering the lot number and ID information assigned to each part and / or unit at the time of assembly work. The association was made.

For example, in a part and unit assembly process of a production line, a lot number information assigned to each part is collected by character recognition (see Patent Document 1 below), or a part lot number is used for a carriage that carries parts and units. A system (see Patent Document 2 below) is proposed in which association information is recorded on an IC card in which data is rewritable.
JP 2002-94300 A JP 2006-4019 A

  However, in the systems described in Patent Documents 1 and 2, the ID information or the lot number is registered as key information for associating the parent-child relationship between the component and the unit. The amount of data increases dramatically with the increase in the number of products produced, the number of units that make up the product, and the number of products and parts used to produce the unit. In order to record these combinations, there is a problem that a huge database capacity is required.

  For example, taking a parent-child relationship between a printed circuit board and an electronic component mounted on the printed circuit board as an example, a unit (specifically, about 1 to 2000) for setting the child component ID in the production facility. Since a large amount of child parts may be used for one parent part, simply recording the combination of the parent part ID and the child part ID results in an enormous amount of data and records all information. It is practically difficult to do.

  Therefore, the present invention has been proposed to solve such a problem, and a system for managing component-related information that can suppress an increase in the amount of data associated with an increase in the number of products produced is provided. The purpose is to provide.

  The component-related information management system according to the present invention is a production line for producing a product composed of a plurality of parent-child parts consisting of at least one of a part and a unit that is a combination of the parts. A component related information management system for managing related information of assigned ID information, a component usage information recording unit for recording component usage information indicating a production status of a parent component and a usage status of a child component, and the component usage information Based on the component usage information recorded by the recording unit, the component-related information generation unit that generates component-related information that is parent-child relationship information of each parent-child component, and the component-related information generated by the component-related information generation unit It includes component-related information output means for searching for and outputting parent-child relationship information of the ID of each parent-child component.

  The part usage information includes parent part identification information such as a parent part name and a parent part ID for identifying a produced parent part, and child part identification information such as a child part name and a child part ID for identifying a child part used for production. , Production place information indicating the location where the parent part was produced, production location information such as production equipment, use location information indicating the location where the child part was used, use location information such as equipment used, and parent part production indicating when the parent part was produced Examples include production time information such as date and time, and use time information such as child component use date and time indicating the time when the child component was used.

  In the component-related information management system according to the present invention, the component usage information indicating the production status of the parent component and the usage status of the child component is recorded by the component usage information recording unit, and the component recorded by the component usage information recording unit Based on the usage information, component-related information that is parent-child relationship information of each parent-child component is generated by the component-related information generating unit, and the ID of each parent-child component is generated by the component-related information generated by the component-related information generating unit Is retrieved and output by the component related information output means. As a result, each time a part related information is searched, based on the part usage information of the parent and child parts, the combination information of the target parent and child parts is temporarily generated, and the obtained parent and child parts information is output as the part related information. Data can be output by means. Therefore, since it is not necessary to record a combination of all parent part IDs and child part IDs, an increase in the data amount associated with the increase in the number of products produced can be suppressed.

  In the component-related information management system according to the present invention, the ID information given to each parent-child component is read for each combination of parent-child relationships of each parent-child component during product assembly work, and the read parent-child component Further includes a component related information recording means for recording the parent-child relationship as ID combination information in the component related information recording unit, and the component related information output means records the component related information recording unit in the component related information recording unit. The parent-child relationship information of the ID of each parent-child component is retrieved and output from the ID combination information, or generated by the component-related information generating unit based on the component usage information recorded by the component usage information recording unit It may be possible to selectively switch whether the parent-child relationship information of the ID of each parent-child component is retrieved and output based on the component-related information.

  In this specific matter, when the parent-child relationship combination information of each parent-child component is recorded in the component-related information recording unit using the component-related information recording unit, the number of parent-child relationship combinations of each parent-child component increases. If the component-related information recording unit having a large capacity exceeding a predetermined recording capacity is required to record the combination information, the ID of each parent-child component is determined by the component-related information generated by the component-related information generating unit. By switching the component related information output means so as to search and output the parent-child relationship information, the amount of combination information about the parent-child relationship of each parent-child component can be reduced.

  In the component-related information management system according to the present invention, the component-related information recording unit reads and reads the “parent component ID” of the produced parent component and the “child component ID” of the child component used for production. An example may be exemplified in which there is provided means for recording component related information, which is combination information of “parent component ID” and “child component ID”, in the component related information recording unit.

  In the component-related information management system according to the present invention, the component usage information recording means reads the “parent part ID” of the produced parent part and records parent part production information indicating the production status of the parent part; And means for reading the “child part ID” of the child part used in the production and recording the child part usage information indicating the usage status of the child part, and the parent part production information includes at least the production Parent part identification information having information of “parent part ID” for identifying the parent part, production location information having information of “process” and “equipment” indicating the place where the parent part was produced, and producing the parent part Production time information including information on “parent part production start date and time” and “parent part production completion date and time” indicating the timing, and the child part usage information identifies at least a child part used for production. Child Child part identification information having ID information, use location information having information on “process” and “facility” indicating the place where the child part is used, and “child part use start date and time indicating the time when the child part is used” ”And“ use time information having “subcomponent use completion date and time” information can be exemplified.

More specifically, the following modes can be exemplified. That is,
(A) The component-related information generating means specifies an ID of a parent component and specifies an ID of a child component related to the ID, and information on a parent component ID to be searched from the parent component production information For each piece of information related to the parent part ID extracted in the parent part ID information extraction step and the parent part ID information extraction step, the same “process” and “ In “Equipment”, “Subpart use start date and time <= Parent part production start date and time” and “Parent part production start date and time <= Subpart use start date and time” or “Subpart use start date and time <= Parent part production start date and time” And “parent part production start date <= subpart use completion date <= parent part production completion date” or “parent part production start date <= child part use start date <= parent part production completion date” and “parent part production” Production completion date <= "Part use completion date and time" or "Parent part production start date and time <= Child part use start date and time <= Parent part production start date and time" and "Parent part production start date and time <= Child part use completion date and time <= Parent part production completion date and time" A first generation step of generating a combination information of a parent part ID and a child part ID by extracting a child part ID that satisfies any of the following conditions:
(B) The component-related information generating means specifies an ID of a child component and specifies an ID of a parent component related to the child component ID, and information on a child component ID to be searched from the child component usage information For each piece of information related to the child part ID extracted in the child part ID information extracting step and the child part ID information extracting step, the same “process” and the same “equipment as the child part are obtained from the parent part production information. "" Parent part production start date and time <= Child part use start date and time "and" Child part use completion date and time <= Parent part production start date and time "or" Parent part production start date and time <= Child part use start date and time "and “Subpart use start date <= Parent part production completion date <= Subpart use completion date” or “Subpart use start date <= Parent part production start date <= Subpart use completion date” and “Subpart use start” Completion date <= "Parts production completion date and time" or "Child parts use start date and time <= Parent part production start date and time <= Child parts use start date and time" and "Child parts use start date and time <= Parent part production start date and time <= Child parts use completion date and time" A second generation step of generating a combination information of a parent part ID and a child part ID by extracting a parent part ID that satisfies any one of the following conditions:
(C) A mode combining the modes (a) and (b).

  As described above, according to the component related information management system of the present invention, the component related information generating unit generates the component related information based on the component use information recorded by the component use information recording unit, Since the part-related information output means searches and outputs the parent-child relation information of the ID of each parent-child part based on the generated part-related information, even if the number of products produced increases, the increase in the amount of data associated therewith is suppressed. be able to.

  In addition, when the component-related information recording unit is further provided, the component-related information recording unit executes the component-related information recording unit. For example, the component-related information having a large capacity for recording the combination information of the parent-child relationship of each parent-child component. When a recording unit is required, by generating component-related information from the component usage information, it is possible to reduce the amount of combination information recorded regarding the parent-child relationship of each parent-child component.

  Hereinafter, embodiments of the present invention will be described with reference to the accompanying drawings. In addition, the following embodiment is an example which actualized this invention, Comprising: The thing of the character which limits the technical scope of this invention is not.

  FIG. 1 is a functional configuration diagram schematically showing an embodiment of a component-related information management system according to the present invention.

  A component-related information management system 1 shown in FIG. 1 is a product composed of a plurality of components consisting of at least one of components and a unit that is a combination of components, and parent / child components of the units (hereinafter simply referred to as components and units). In the production line that performs the production, the related information of the ID given to each individual part and unit is managed, and the ID reading unit 13 for part usage information, the part usage information recording unit 14, and the part related information A generation unit 15, a component related information output unit 16, and a control unit 17 are provided. Here, the unit is a combination of a plurality of parts.

  Specifically, the component-related information management system 1 records component usage information indicating the production status of the parent component and the usage status of the child component obtained by the ID reading unit 13 in the component usage information recording unit 14. And component-related information generating means for dynamically generating component-related information, which is parent-child relationship information of each component and unit, based on the component usage information recorded by the component usage information recording means. The component-related information output means for searching and outputting the parent-child relationship information of the ID of each component and unit by the component-related information generated by the component-related information generating means in the component-related information output section 16 It is supposed to run.

  That is, the component-related information management system 1 reads the component usage information by the ID reading unit 13 under the instruction of the control unit 17, records the read component usage information in the component usage information recording unit 14, and uses this component usage. The component usage information recorded in the information recording unit 14 is read, the read component usage information is transmitted to the component related information generation unit 15 to generate component related information, and the generated component related information is output to the component related information. The information is transmitted to the unit 16 and the parent-child relationship information of the ID of each component and unit is retrieved and output.

  Therefore, each time the component-related information management system 1 searches for component-related information, based on the component usage information of the parent-child component read from the component usage information recording unit 14, the combination information of the target parent-child component is used as the component-related information. The information can be temporarily generated in the information generation unit 15 and the data can be output to the component related information output unit 16. Thereby, since it is not necessary to record the combination of all the parent part IDs and child part IDs, even if the number of products produced increases, an increase in the data amount associated therewith can be suppressed.

  The control unit 17 includes an information processing device such as a CPU (Central Processing Unit) (not shown) and a memory. The memory includes a ROM (Read Only Memory) and a RAM (Random Access Memory), and can store a component-related information management system program to be described later. The control unit 17 controls the overall system by reading out the component-related information management system program from the memory and executing the read program by the CPU. The component-related information management system program causes the control unit 17 to function as means including the component usage information recording unit, the component-related information generation unit, and the component-related information output unit.

  The ID reading unit 13 is installed in each facility, and is, for example, an ID reading device such as a barcode reader. The ID reading unit 13 reads the “parent part ID” of the produced parent part and the “child part ID” of the child part used for production during the assembly operation of the product. The component usage information recording unit 14 is a large-capacity storage device such as a hard disk drive (HDD), and records component usage information as a database. The component related information generation unit 15 is, for example, a memory that temporarily stores a processing result obtained at the time of data processing for generating component related information based on the component usage information read from the component usage information recording unit 14. . Further, the component related information output unit 16 searches the component related information generation unit 15 for component related information related to the ID specified by the control unit 17 and outputs the parent-child relationship information of the searched ID. Yes. Specifically, the component-related information output unit 16 includes a display device, searches for component-related information generated by the component-related information generation unit 15, and outputs and displays the parent-child relationship information of the searched ID on the display device. It is like that.

  In the present embodiment, the part usage information includes parent part production information indicating the production status of the produced parent part and child part usage information indicating the usage status of the child part used for production.

  Then, the component-related information management system 1 reads the “parent component ID” of the produced parent component by the ID reading unit 13 in the component usage information recording means, and also uses the component usage information for the parent component production information of the parent component. Means for recording in the recording unit 14, and means for reading the “child component ID” of the child part used for production by the ID reading unit 13 and recording the child part usage information of the child part in the component usage information recording unit 14 Are executed by the control unit 17.

  Here, the parent part production information is the “parent part ID” which is an ID for identifying the produced parent part, the production “process” and the production “equipment” indicating the place where the parent part is produced, and the parent part is produced. It includes “parent part production start date and time” and “parent part production completion date and time” indicating the time. The child part use information includes “child part ID” that is an ID for identifying a child part used for production, use “process” and use “equipment” indicating a place where the child part is used, and time when the child part is used. "Child component use start date and time" and "child component use completion date and time".

  FIG. 2 is a schematic diagram for explaining the component usage information collection timing when the component usage information ID reading unit 13 reads the component usage information. Specific examples of FIG. 2 include, but are not limited to, a case in which a parent-child relationship between a printed circuit board and an electronic component mounted on the printed circuit board is read.

  First, a parent part: ID = “parent part A_001” is mounted with child parts: ID = “child part A_111” and “child part A_222”, which are child parts, in “facility A” of “process A”. . Each child part is set in advance in “equipment A” in a certain quantity unit (for example, about 1 to 2000 pieces or about 50 to 1000 pieces), and is mounted on the parent part in “facility A”. Is done. The child component ID is given to a certain unit of quantity set in “facility A” due to restrictions such as the size of the child component itself.

  In the parent part production information, “Production start date / time” is the date / time / minute / second when production (mounting of child parts) of the parent part: ID = “parent part A_001” is started in “equipment A”. “Date / time” is the date / time / minute / second at which the production of the parent part: ID = “parent part A_001” is completed in the equipment (“equipment A”). The parent part ID is read by the ID reading unit 13 (for example, an ID reading device such as a barcode reader) installed in each facility when the parent component is produced in each facility. The reading of the parent part ID is executed between “production start date and time” and “production completion date and time” in each facility.

  Further, in the child component usage information, “use start date / time” is the date / time / minute / second when the unit of child component: ID = “child component A_111” is set in “facility A”, and “use completion date / time” is “ Child parts set in “equipment A”: date = minute / second when all units of ID = “child parts A_111” are used up. The reading of the child component ID is read when the ID reading unit 13 sets the unit of the child component: ID = “child component A_111” in the facility A. Similarly, the reading of “use start date and time”, “use completion date and time”, and child component ID is performed for all other child component units set in the facility A.

  FIG. 3 is a diagram for explaining the component usage information recorded in the component usage information recording unit 14, and FIG. 3A is a diagram illustrating an example of parent part production information, and FIG. ) Is a diagram showing an example of the child component usage information, and FIG. 3C is an example of the production usage record of the parent component and the child component based on the information shown in FIGS. 3A and 3B. FIG.

  As shown in FIG. 3A, as the parent part production information constituting the part usage information, at least “process” and “equipment” that produced the parent part for all “processes” and “equipment” that produced the parent part. Component usage information includes “equipment”, “parent part ID” collected by the ID reading unit 13, “production start date and time” when production of the parent part is started, and “production completion date and time” when production of the parent part is completed. Recorded in the recording unit 14. Further, as shown in FIG. 3B, at least “process” using a child part for all “processes” and “equipment” in which the child parts are set as the child part use information constituting the part use information. And “facility”, “child component ID” collected by the ID reading unit 13, “use start date / time” using the child component unit first, and “use completion date / time” using all the child component units. Are recorded in the component usage information recording unit 14.

  Here, since the child component ID is assigned for each unit (for example, about 1 to 2000 units) set in the facility A, as shown in the recording example of the parent component production information and the child component usage information shown in FIG. A child part with a certain ID may be used for a plurality of parent parts. For example, as shown in FIG. 3C, the child part: ID = “child part A_111” is used for both the parent part: ID = “parent part A_001” and the parent part: ID = “parent part B_001”. Sometimes.

  FIG. 4 is an example of a flowchart showing a flow of processing performed by the component-related information generating unit in the present embodiment. FIG. 5 is a diagram showing a component usage pattern (1) used in the production facility.

  The component-related information management system program includes the following first to fifth steps P1 to P5 and can be executed by the control unit 17. That is, the component-related information generating means executes steps including steps P1 to P5 in which the control unit 17 designates a parent component ID to be searched and extracts a corresponding child component ID. .

  First, when a parent part ID is designated and a corresponding child part ID is extracted, in the first step P1, it acts as a parent part ID information extraction step, and a search target designated by the control unit 17 from the parent part production information The production information related to the parent part ID is extracted. Here, since the parent part is normally produced in a plurality of production “processes” and production “equipment”, a plurality of pieces of parent part production information are extracted. However, the following second to fifth steps P2 are performed. -P5 acts as a first generation step and is executed for each piece of parent part production information extracted in the first step P1.

  For example, in the example of the parent part production information shown in FIG. 3, the case where the child part ID related to the parent part ID = “parent part A_001” is extracted will be described as an example.

In the second step P2, the component usage information is recorded for the child parts of the “process” identical to the “process” of the parent part ID extracted in the first step P1 and the “equipment” identical to the “equipment” of the parent part ID. From the child component usage information recorded in the section 14,
“Subpart use start date <= Parent part production start date” and “Parent part production end date <= Subpart use completion date”
The child part ID satisfying the condition is extracted.

  Here, the child part ID used in the same “process (process A)” and the same “equipment (equipment A)” as the parent part: ID = “parent part A_001” is the child part: ID = “child part A_111”. , Child parts: ID = “child parts A_222”, of which the child parts use start date is before the parent parts production start date = “2008/3/10 10:00:00” and the child parts use is completed The child part: ID = “child part A_111” is extracted as the child part ID whose date and time is after the parent part production end date = “2008/3/10 10:00:30”.

Subsequently, the third to fifth steps P3 to P5 are executed. That is, from the child component usage information recorded in the component usage information recording unit 14 for the child component of the same “process” in the same “facility” as the parent component ID as in the second step P2,
In the third step P3, “subpart use start date <= parent part production start date” and “parent part production start date <= subpart use completion date <= parent part production completion date”.
Extract child part ID that satisfies the conditions
In the fourth step P4, “parent part production start date and time <= child component use start date and time <= parent part production completion date and time” and “parent part production completion date and time <= child component use completion date and time”
Extract child part ID that satisfies the conditions
In the fifth step P5, "parent part production start date and time <= child part use start date and time <= parent part production start date and time" and "parent part production start date and time <= child part use start date and time <= parent part production completion date and time"
The child part ID satisfying the condition is extracted.

  Here, in the third to fifth steps P3 to P5, since there is no child part ID that satisfies the condition, the child part ID related to the parent part: ID = “parent part A_001” is the child part: ID = “child part”. A_111 "only.

  Also, for example, in the example of extracting the parent part ID related to the parent part ID = “parent part B — 001” in the example of the parent part production information shown in FIG. 3, in this example, the condition of the second step P2 is described. There is no child part ID that matches.

Subsequently, in the third step P3,
“Subpart use start date and time <= Parent part production start date and time” and “Parent part production start date and time <= Subpart use start date and time <= Parent part production start date and time”
The child part ID satisfying the condition is extracted.

  Here, the child part ID used in the same “process (process A)” and the same “equipment (equipment A)” as the parent part: ID = “parent part B_001” is the child part: ID = “child part A_111”. , Child part: ID = “child part A_222”, of which the child part use start date is before the parent part production start date = “2008/3/10 10:00:31” and the child part is used As a child part ID between completion date and time of parent part production start date and time = “2008/3/10 10:00:31” and parent part production completion date and time = “2008/3/10 10:01:00”, child parts: ID = “child component A_111” is extracted.

Subsequently, in the fourth step P4,
"Parent part production start date and time <= Child part use start date and time <= Parent part production completion date and time" and "Parent part production completion date and time <= Child part use completion date and time"
The child part ID satisfying the condition is extracted.

  Here, the child component ID used in the same “process (process A)” and “equipment (equipment A)” as the parent component: ID = “parent component B_001” is the child component: ID = “child component A_111”, Child part: ID = “child part A_222”, among which the child part use start date and time is parent part production start date and time = “2008/3/10 10:00:31” and parent part production completion date and time = “2008” / 3/10 10:01:00 ", and the child parts use completion date and time is the parent part production completion =" 2008/3/10 10:01:00 "or later as the child parts ID: ID = “child component A_222” is extracted.

  Subsequently, although the fifth step P5 is executed, there is no child component ID extracted in the fifth step P5. Therefore, the child component ID related to the parent component: ID = “parent component B_001” is child component: ID = “child component A_111”, and child component: ID = “child component A_222”.

  Further, for example, in the example of extracting the parent part ID related to the parent part ID = “parent part C_001” in the example of the parent part production information shown in FIG. , “Part A”, “Equipment A”, “Process B”, and “Equipment B”, the parent part production information of two types of production locations exist in the part usage information recording unit 14.

  First, when the child component usage information regarding “process A” and “facility A” is extracted in the second to fifth steps P2 to P5, the related child component: ID = “child component A_222” is set in the second step P2. There is no child part ID to be extracted in the third to fifth steps P3 to P5.

  Next, when child component usage information regarding “process B” and “facility B” is extracted in the second to fifth steps P2 to P5, there is no child component ID that matches the condition of the second step P2.

  Subsequently, in the third step P3, the child component: ID = “child component B_111” can be extracted, and in the fourth step P4, the child component: ID = “child component B_333” can be extracted.

Furthermore, in the fifth step P5,
"Parent part production start date and time <= Child part use start date and time <= Parent part production start date and time" and "Parent part production start date and time <= Child part use start date and time <= Parent part production completion date and time"
The child part ID satisfying the condition is extracted.

  Here, the child part use start date / time is between the parent part production start date / time “2008/3/10 10:01:31” and the parent part production completion date / time “2008/3/10 10:03:00”. The child parts use completion date and time is between the parent part production start date and time = "2008/3/10 10:01:31" and the parent part production completion date and time = "2008/3/10 10:03:00" As the component ID, the child component: ID = “child component B_222” is extracted.

  Therefore, the child part ID related to the parent part: ID = “parent part C_001” is the child part: ID = “child part A_222”, the child part: ID = “child part B_111”, and the child part: ID = “child part”. B_222 ”, child part: ID =“ child part B_333 ”.

  If the conditions of the second to fifth steps P2 to P5 are illustrated, the part usage pattern (1) of the production facility in FIG. 5 is obtained. In FIG. 5, * 1 to * 4 correspond to the second to fifth steps P2 to P5 of FIG. 4, respectively.

  The child component ID extraction process performed by the component-related information generation unit in the present embodiment, that is, the process of extracting the related child component ID when the parent component ID is designated is completed.

  Next, an example in which a child component ID is designated and a corresponding parent component ID is extracted will be described. FIG. 6 is another example of a flowchart showing the flow of processing performed by the component-related information generating unit in the present embodiment. FIG. 7 is a diagram showing a component usage pattern (2) used in the production facility.

  The component-related information management system program includes the following sixth to tenth steps C1 to C5, and can be executed by the control unit 17. That is, the component related information generating means executes steps including steps C1 to C5 in which the control unit 17 specifies a child component ID to be searched and extracts a corresponding parent component ID.

  First, when a child part ID is specified and a corresponding parent part ID is extracted, in the sixth step C1, it acts as a child part ID information extracting step, and the search target specified by the control unit 17 from the child part usage information The usage information regarding the child part ID is extracted. Here, when the subpart ID is assigned to a unit (for example, a unit of about 1 to 2000) set in the production facility, the subpart may be used in a plurality of use “processes” and use “equipment”. Therefore, a plurality of parent part production information is extracted, but the following seventh to tenth steps C2 to C5 act as the second generation step and use the child parts extracted in the sixth step C1. It is executed for each piece of information.

  For example, the case where the parent component ID related to the child component: ID = “child component B_222” is extracted from the example of the child component usage information shown in FIG. 3 will be described.

In the seventh step C2, component usage information is recorded for the parent part of the “process” identical to the “process” of the child part ID extracted in the sixth step C1 and the “equipment” identical to the “equipment” of the child part ID. From the parent part production information recorded in the section 14,
“Parent part production start date and time <= Subpart use start date and time” and “Subpart use start date and time <= Parent part production completion date and time”
The parent part ID satisfying the condition is extracted.

  Here, the parent part ID produced in the same “process (process B)” and the same “equipment (equipment B)” as the child part: ID = “child part B_222” is parent part: ID = “parent part C_001”. Furthermore, the parent part production start date / time is before the child part use start date = “2008/3/10 10:02:01”, and the parent part production completion date / time is the child part use end date = “2008 / As the parent part ID after “3/10 10:02:45”, the parent part: ID = “parent part C_001” is extracted.

Subsequently, the eighth to tenth steps C3 to C5 are executed. That is, from the parent part production information recorded in the part usage information recording unit 14 for the parent part of the same “process” in the same “equipment” as the child part ID as in the seventh step C 2,
In the eighth step C3, “parent part production start date and time <= child component use start date and time” and “child component use start date and time <= parent part production start date and time <= child component use start date and time”
The parent part ID that satisfies the conditions of
In the ninth step C4, “subpart use start date <= parent part production start date <= subpart use completion date” and “subpart use completion date <= parent part production completion date”.
The parent part ID that satisfies the conditions of
In the tenth step C5, “subpart use start date <= parent part production start date <= subpart use start date” and “subpart use start date <= parent part production end date <= subpart use completion date”.
The parent part ID satisfying the condition is extracted.

  Here, in the eighth to tenth steps C3 to C5, since there is no parent part ID that satisfies the condition, the parent part ID related to the child part: ID = “child part B_222” is the parent part: ID = “parent part”. C_001 "only.

  Further, for example, in the case of extracting the parent part ID related to the child part: ID = “child part B_333” in the example of the child part usage information shown in FIG. 3, the condition of the seventh step C2 is used in this example. There is no parent part ID that matches.

Subsequently, in the eighth step C3,
"Parent part production start date and time <= Child part use start date and time" and "Child part use start date and time <= Parent part production start date and time <= Child part use start date and time"
The parent part ID satisfying the condition is extracted.

  Here, the parent part ID used in the same “process (process B)” and the same “equipment (equipment B)” as the child part: ID = “child part B_333” is the parent part: ID = “parent part C_001”. Furthermore, the parent part production start date is before the child part use start date = “2008/3/10 10:02:46”, and the parent part production completion date is the child part use start date = “2008 / The parent part ID: “parent part C_001” is extracted as the parent part ID between “3/10 10:02:46” and the child part use completion date = “2008/3/10 12:00:00” The

  Subsequently, although the ninth and tenth steps C4 and C5 are executed, there is no parent part ID extracted in the ninth and tenth steps C4 and C5. Therefore, the parent part ID associated with the child part: ID = “child part B_333” is the parent part: ID = “parent part C_001”.

  Further, for example, in the case where the parent part ID related to the child part: ID = “child part B_111” is extracted from the example of the child part usage information shown in FIG. 3, the seventh and eighth steps will be described in this example. There is no parent part ID that matches the conditions of C2 and C3.

Subsequently, in the ninth step C4,
“Subpart use start date and time <= Parent part production start date and time <= Subpart use start date and time” and “Subpart use start date and time <= Parent part production end date and time”
The child part ID satisfying the condition is extracted.

  Here, the child part ID used in the same “process (process B)” and the same “equipment (equipment B)” as the child part: ID = “child part B_111” is the parent part: ID = “parent part C_001”. Furthermore, the parent part production start date and time are the child part use start date and time = “2008/3/10 6:00:00” and the child part use completion date and time = “2008/3/10 10:02:00” The parent part ID = “parent part C_001” is extracted as the parent part ID after the parent part production completion date and time is the child part use completion date = “2008/3/10 10:02:00” The

  Subsequently, the tenth step C5 is executed, but there is no parent part ID extracted in the tenth step C5. Therefore, the parent part ID associated with the child part: ID = “child part B_111” is the parent part: ID = “parent part C_001”.

  Further, for example, in the case of extracting the parent part ID related to the child part: ID = “child part A_111” in the example of the child part usage information shown in FIG. 3, the seventh and eighth steps are described in this example. There is no child part ID that matches the conditions of C2 and C3.

  Subsequently, in the ninth step C4, the parent part: ID = “parent part B_001” can be extracted.

Furthermore, in the 10th step C5,
“Subpart use start date and time <= Parent part production start date and time <= Subpart use start date and time” and “Subpart use start date and time <= Parent part production start date and time <= Subpart use start date and time”
The parent part ID satisfying the condition is extracted.

  Here, the parent part production start date and time is between the child part use start date and time = “2008/3/10 6:30:00” and the child part use start date and time = “2008/3/10 10:00:45” The parent part production completion date / time is between the child part use start date / time = “2008/3/10 6:30:00” and the child part use completion date / time = “2008/3/10 10:00:45”. As the parent part ID, parent part: ID = “parent part A_001” is extracted. Accordingly, the parent part ID related to the child part: ID = “child part A_111” is parent part: ID = “parent part A_001”, and the parent part: ID = “parent part B_001”.

  If the conditions of the above 7th to 10th steps C2-C5 are illustrated, it will become the component usage pattern (2) of the production facility of FIG. In FIG. 7, * 1 to * 4 correspond to the seventh to tenth steps C2 to C5 of FIG. 6, respectively.

  The parent part ID extraction process performed by the part related information generation unit in the present embodiment, that is, the process of extracting the related parent part ID when the child part ID is designated is completed.

  FIG. 8 shows an example of the component related information generated by the component related information generating unit 14. As shown in FIG. 8, the component related information output unit 16 searches for the component related information generated by the production related information generation unit 14, and outputs the parent-child relationship information of the searched ID (here, output to the display device). indicate.

(Other embodiments)
In the present embodiment, the component-related information management system 1 may include a component-related information recording unit in addition to the above configuration.

  FIG. 9 is a functional configuration diagram schematically showing another embodiment of the component-related information management system shown in FIG. Note that in the component-related information management system 1 ′ shown in FIG. 9, the same reference numerals are assigned to substantially the same components as those in the component-related information management system 1 shown in FIG. 1. In the following, the description will focus on differences from the component-related information management system 1 shown in FIG.

  The component-related information management system 1 ′ shown in FIG. 9 further includes a component-related information ID reading unit 11 and a component-related information recording unit 12.

  Specifically, the component-related information management system 1 ′ reads the ID information given to each component and unit by the ID reading unit 11 for each combination of the parent-child relationship of each component and unit during product assembly work. , A combination of component-related information recording means for combining the read parent-child relationships of the respective parts and units and recording them in the part-related information recording section 12, and a combination of IDs recorded in the component-related information recording section 12 by the component-related information recording means The component-related information output unit 16 searches for and outputs the parent-child relationship information of the ID of each component and unit according to the information, or the ID of each component and unit according to the component-related information generated by the component-related information generating means. The control unit 17 includes a component-related information output unit that selectively switches whether parent-child relationship information is retrieved and output by the component-related information output unit 16. So that the further execution.

  That is, the part-related information management system program includes a control unit 17, the part-related information recording means, the part usage information recording means, the part-related information generating means, and the part-related information output means. To function as a means including

  The ID reading unit 11 is, for example, an ID reading device such as a bar code reader, and reads an ID for each combination of parts and units in the assembly process of a product. The component-related information recording unit 12 is a large-capacity storage device such as a hard disk device (HDD), and records the component-related information acquired by the ID reading unit 11 as a database. The component usage information ID reading unit 13 and the component related information ID reading unit 11 may be shared by either one of the ID reading units.

  In this embodiment, the part related information recording means reads the “parent part ID” of the produced parent part and the “child part ID” of the child part used for production, and reads the read “parent part ID”. In addition, the control unit 17 further executes means for recording the component related information, which is the combination information of “child component ID”, in the component related information recording unit 12.

  FIG. 10 is a diagram illustrating an example of ID information of the parent / child component recorded in the component-related information recording unit 12.

  As shown in FIG. 10, the component related information recording means records the registration information of the parent component and the child component as a one-to-one combination. For example, when two child parts are attached to a certain parent part, two records of “parent part: child part 1” and “parent part: child part 2” are registered in the part related information recording unit 12. . In this way, all combinations relating to the parent part ID and the child part ID are recorded in the part-related information recording unit 12.

  The component-related information output unit 16 searches the component-related information recording unit 12 or the component-related information generation unit 15 for component-related information related to the ID specified by the control unit 17, and finds the parent-child relationship information of the searched ID. It is designed to output. Specifically, the component-related information output unit 16 includes a display device, searches for component-related information recorded in the component-related information recording unit 12, or component-related information generated by the component-related information generation unit 15, The parent-child relationship information of the retrieved ID is output and displayed on the display device.

  According to the component-related information management system 1 ′ having such a configuration, when there is a large amount of combined data of parent-child relationships between the components and units constituting the product, the component usage information of the parent-child components is obtained each time the component-related information is searched. Based on this, it is possible to temporarily generate combination information of the target parent-child parts and output the data to the part-related information output unit 16. By doing so, it is not necessary to record all combination information in the database in advance, and the data recording capacity can be reduced.

(Other aspects of component-related information recording means)
By the way, in the conventional system using the part related information recording means, the lot number or ID is regarded as a mere unique character string for uniquely identifying the part and the unit, and a key for simply associating the parent-child relationship between the part and the unit. It is used for information only. For example, when assembling work using parts of the same type produced at multiple factories, if there is no standard common to all factories regarding ID assignment, duplication of IDs may occur, Information will be recorded. That is, only the information for uniquely identifying the parts and units is a record that has no meaning in practice, and if the ID and other information (for example, information about the factory that produced the product) are not managed in combination, the parts-related information As such, there was a problem that it could not be used effectively.

  Furthermore, the ID configuration is often different for each factory, such as when a new subcontractor factory enters the market. When an attempt is made to change the ID configuration, existing ID assignment, reading, and recording means are changed. I need it. For this reason, it has been practically difficult to unify the ID configuration in all factories.

  Therefore, it is possible to prevent erroneous parts-related information from being recorded for parts and units, which can be used effectively as part-related information, and to unify the ID configuration in all factories while maintaining a factory-specific ID management system. In order to register the part related information that can be used, the part related information management system 1 'is a production line for assembling products composed of units that are combinations of parts and parts produced at a plurality of factories. A component related information registration system for registering related information of IDs assigned to individual parts and units, regarding the configuration of information of the IDs assigned to parts and units, types of information included in the IDs, and “factories” The number of characters related to the location and the arrangement of each of the factories based on the standard common to all factories ID configuration information recording means for recording ID configuration information related to the configuration of the ID character string in the database, and when assembling the product, the ID is read for each combination of the parent and child relationships of the parts and units, and is unique for each factory. Component-related information record for decomposing the IDs assigned to components and units into character strings based on the defined ID configuration information and recording the IDs of the decomposed character strings in a database by combining the parent-child relationships of the components and units Preferably, the component-related information registration system includes a means and a component-related information output unit that searches and outputs the ID and parent-child relationship information registered by the component-related information recording unit.

  According to this component-related information management system, the ID configuration information recording unit records the ID configuration information in a database based on the standard common to all factories, and the component-related information recording unit performs a product assembly operation. The ID is read for each combination of the parent-child relationship of the part and the unit, the ID given to the part and the unit is decomposed into a character string based on the ID configuration information, and the ID of the part and the unit is obtained for the ID of the decomposed character string. Since the parent-child relationship is combined and recorded in the database, and the ID and parent-child relationship information registered in the component-related information recording unit is searched and output in the component-related information output unit, for example, the same produced in a plurality of factories Even when performing assembly work using different types of parts, there is no duplication of ID, and incorrect parts and parts It is possible to prevent the recording of the relevant information, thereby can be effectively utilized as a component related information. Furthermore, since the ID configuration information is recorded in the database based on the standard common to all factories, the ID configuration can be unified in all factories while maintaining a factory-specific ID management system. It is possible to interpret the ID information and record the component related information in the database.

  In the component-related information management system, the types of information included in the ID include, for example, “items” that are character strings for uniquely identifying the names of components and units produced in the same factory, individual components, and “Sequential number”, which is a number assigned to each “item” in order to uniquely identify the unit and is not duplicated within the same item, and “factory”, which is a character string for uniquely identifying the factory that has produced the unit. Can be mentioned. In this case, the component-related information recording means disassembles the ID assigned to the component and the unit into character strings of “item”, “serial number”, and “factory” based on the ID configuration information. Can do. Moreover, as an aspect of arrangement of information regarding the “factory”, an aspect of arrangement at the end of the ID can be exemplified.

  Specifically, the standard common to all factories is, as the type of information included in the ID, at least “items” that are character strings for uniquely identifying the names of parts and units produced in the same factory, In order to uniquely identify individual parts and units, a “serial number” that is numbered for each “item” and that does not overlap within the same item, and a character string that uniquely identifies the factory that produced it. The number of characters of a character string that includes a certain “factory” and that represents the “factory” is determined, and that the character string that represents the “factory” is arranged at the end in the ID. In addition, the ID configuration information uniquely determined for each factory includes at least a “product type” that is a character string indicating the type of the “item” of parts and units, and a “digit” that is the total number of characters of the ID. Number "and the above" factory " The character string, the start position and the number of characters of the character string representing the “item” in the ID, the start position and the number of characters of the character string representing the “serial number”, and the character representing the “factory” in the ID An example can be illustrated in which the information includes “factory presence / absence” indicating whether a column is included.

  More specifically, the component-related information recording means is configured to store one parent component ID based on a parent-child relationship between components and units defined in advance in an ID registration field that associates the “type” of components and units. Registered in the ID registration field, in the ID registration field, in the child part ID registration step in which a plurality of child part IDs for the parent part ID are registered, and in the ID registration step. For the parent part ID and the child part ID, a “registered digit number” that is the total number of characters is extracted, and a character string representing “factory” included in the ID is extracted based on the common standard for all factories. 1 extraction step, and from the ID configuration information uniquely determined for each factory for the parent part ID and all the child part IDs registered in the ID registration field, the “product type” = “Product” associated with the ID registration field, “Number of digits” = “Registered number of IDs” registered in the ID registration field, and “Factory” = Registered in the ID registration field Information on the start position and the number of characters of the character string representing the “item” in the ID and the start position and the number of characters of the character string representing the “serial number” on the condition of the character string representing the “factory” included in the ID In the first search step of searching for, and in the first search step, if the information of the character string start position and the number of characters of the "item" and "serial number" could not be searched from the ID configuration information, For the parent part ID and all child part IDs registered in the ID registration field, from the ID configuration information, the “product type” = the “product type” associated with the ID registration field, and the “number of digits” = the above-mentioned “Registration” of the ID registered in the ID registration field “Number of digits”, and “Factory presence / absence” = “None”, the start position and number of characters representing the “item” in the ID, and the start position of the character string representing the “serial number” A second search step for searching for information on the number of characters, a start position and the number of characters representing the “item” in the ID searched in the first or second search step, and a character representing the “serial number” A second extraction step for extracting a character string representing “item” and “serial number” of the parent part ID and all the child part IDs registered in the registration field using information on the start position of the line and the number of characters; A character string representing “item”, “serial number”, and “factory” of the parent part ID and all the child part IDs extracted in the first and second extraction steps for each combination of the parent part and the child part. To execute the component related information registration step to be registered in It can be illustrated.

  As explained above, according to this component-related information management system, it is possible to prevent erroneous component-related information from being recorded for parts and units, thereby enabling effective use as component-related information and maintaining a factory-specific ID management system. However, the ID configuration can be unified in all factories.

  Hereinafter, an embodiment of the component-related information management system will be described with reference to the accompanying drawings.

  FIG. 11 is a functional configuration diagram schematically showing another embodiment of the component-related information management system shown in FIG. Note that in the component-related information management system 1 ″ shown in FIG. 11, the same reference numerals are given to substantially the same components as those in the component-related information management system 1 ′ shown in FIG. The description will focus on the differences from the component-related information management system 1 ′.

  The part related information management system 1 ″ shown in FIG. 11 is related information on IDs assigned to individual parts and units in a production line for assembling products composed of parts and units produced at a plurality of factories. Are registered, and an ID configuration information recording unit 19 is further provided.

  Specifically, the component-related information management system 1 ″ further executes an ID configuration information recording unit, a component-related information recording unit, and a component-related information output unit by the control unit 17. Here, the program for the component-related information management system is for causing the control unit 17 to function as a unit including the ID configuration information recording unit, the component-related information recording unit, and the component-related information output unit. It is.

  The ID configuration information recording unit 19 records ID configuration information related to the configuration of the character string of the ID uniquely determined for each of the plurality of factories based on the common standard 18 for all factories. Here, the common standard 18 for all factories relates to the configuration of ID information given to parts and units, and is used in common for all factories regarding the type of information to be included in the ID and the number of characters and the arrangement of information relating to “factory”. The ID configuration information recording unit 19 records the ID configuration information as a database.

  The part-related information ID reading unit 11 reads an ID for each combination of parts and units in a product assembly operation, and based on the ID configuration information, the read ID is a character string (here, “Item”, “serial number”, “factory”), and component-related information obtained by combining the parent-child relationship of the component and unit for the ID of the decomposed character string is acquired. The component related information recording unit 12 records the component related information acquired by the ID reading unit 11. The component related information recording unit 12 records the component related information acquired by the ID reading unit 11 as a database.

  The component-related information output unit 16 searches for the ID recorded in the component-related information recording unit 12, and outputs the parent-child relationship information of the searched ID. Specifically, the component-related information output unit 16 includes a display device, searches for an ID recorded in the component-related information recording unit 12, and outputs and displays parent-child relationship information of the searched ID on the display device. ing.

  According to the component-related information management system 1 ″ shown in FIG. 11, the component-related information is registered using the ID configuration information registered in advance based on the common standard 18 for all factories. For example, even if a product containing defective parts leaks to the market, it is possible to easily identify a product that is subject to replacement repair of defective parts. Become.

  Also, according to the parts-related information management system 1 ″, even if a factory of a new partner company enters, the ID management system unique to the factory remains, and ID information with a different management system is interpreted and recorded in the database. For example, even in a production line in which parts and units of the same type from different factories are mixed, it is possible to uniquely identify information representing items such as factories and parts names that produce parts and units. It becomes.

  In this embodiment, the common standard 18 for all factories includes, as the types of information included in the ID, at least “items” that are character strings for uniquely identifying the names of parts and units produced in the same factory, and individual items. "Serial number", which is a number assigned to each "item" in order to uniquely identify the parts and units in the same item and does not overlap within the same item, and is a character string for uniquely identifying the factory that produced it. "Factory" is included, the number of characters of the character string representing "Factory" (two characters here) is defined, and the character string representing "Factory" is arranged at the end in the ID. Suppose that

  FIG. 12 is a diagram illustrating an example of ID configuration information recorded in the ID configuration information recording unit 19. Here, the ID configuration information shown in FIG. 12 includes at least “product type” that is a character string indicating the type of “item” of parts and units, “number of digits” that is the total number of characters of ID, and a standard common to all factories. 18, a character string representing “factory” to be included in the ID, a starting position and number of characters representing “item” in the ID, a starting position and number of characters representing “serial number” in the ID, Information indicating whether or not a character string representing “factory” is included in the ID is recorded for each “product type”, “number of digits”, and “factory” of parts and units. . Accordingly, the ID configuration information recorded in the ID configuration information recording unit 19 can be uniquely specified using “product type”, “number of digits”, and “factory” as keys.

  By the way, in the character string which comprises ID, the character string showing "item" and "serial number" may not be arrange | positioned continuously. Therefore, it is preferable to register two or more sets of information for registering the combination of the start position and the number of characters representing the “item” and the start position and the number of characters representing the “serial number”.

  FIG. 13 is a diagram showing an example of an ID registration screen used by the ID reading unit 11 in this embodiment. The ID registration screen shown in FIG. 13 is a child component ID field 10a in which one parent component ID can be registered and a child component that can be registered in association with a plurality (preferably five or more) of child component IDs for the one parent component ID. An ID registration field 10 including an ID field 10b is provided. The ID registration field 10 is preliminarily associated with “product type” information indicating the type of “item” of parts and units to be registered.

  FIG. 14 is an example of a flowchart showing the flow of processing performed by the component-related information recording means in this embodiment.

  The part-related information management system program includes the following steps S1 to S7, and causes the control unit 17 to execute the steps S1 to S7 in a process of assembling parts and units in the production line. it can. That is, the component-related information recording means includes a parent component ID registration step S1, a child component ID registration step S2, a first extraction step S3, a first search step S4, a second search step S5, and a second extraction. Steps including step S6 and component related information registration step S7 are executed.

  In the parent part ID registration step S1, the ID assigned to the parent part is read, and the read ID is registered in the parent part ID column 10a of the ID registration screen.

  In the child part ID registration step S2, IDs assigned to all (N (N is an integer of 2 or more)) child parts that perform attachment work on the parent part are read, and a child part ID field on the ID registration screen is read. The read ID is registered in 10b.

  In the first extraction step S3, for the parent part ID and the child part ID registered in the parent part ID registration step S1 and the child part ID registration step S2, “number of registered digits” that is the total number of characters is extracted, Based on the factory common standard 18, a character string representing “factory” included in the ID (here, a character string of the last two digits in the ID) is extracted.

In the first search step S4, for the parent part ID registered in the ID registration field 10 and all the child part IDs, from the ID configuration information recorded in the ID configuration information recording unit 19,
[“Product type” = “product type” associated with the ID registration field 10] AND
[“Digit number” = “registered digit number” extracted from the ID in the ID registration column 10] AND
[“Factory” = character string representing “factory” extracted from the ID in the ID registration field 10 based on the standard 18 common to all factories]
As a condition, information on the start position and number of characters of the character string representing “item” in the ID and the start position and number of characters of the character string representing “serial number” are searched.

In the second search step S5, when it is not possible to search the information on the character string start position and the number of characters of “item” and “serial number” from the ID configuration information in the first search step S4 (step S51: No) From the ID configuration information, the parent part ID and all the child part IDs registered in the ID registration field 10 are
[“Product type” = “product type” associated with the ID registration field 10] AND
[“Digit number” = “registered digit number” extracted from the ID in the ID registration column 10] AND
[“Factory presence / absence” = “None”]
As a condition, information on the start position and the number of characters representing the “item” in the ID and the start position and the number of characters representing the “serial number” are searched (step S52).

  When it is not possible to retrieve the information on the start position and the number of characters of the character strings “item” and “serial number” from the ID configuration information in step S52 (step S53: No), [ID configuration information does not exist. ] Is displayed (step S54), and the process proceeds to the parent part ID registration step S1.

  On the other hand, in the first search step S4 or the second search step S5, when the information on the character string start position and the number of characters of “item” and “serial number” is acquired from the ID configuration information (steps S51 and S53). : Yes), the process proceeds to the second extraction step S6.

  In the second extraction step S6, the start position and the number of characters representing the “item” in the ID searched in the first search step S4 or the second search step S5, the start position of the character string representing the “serial number”, and Using the information on the number of characters, a character string representing “item” and “serial number” of the parent part ID and all the child part IDs registered in the ID registration field 10 is extracted.

  In the component related information registration step S7, character strings representing “item”, “serial number”, and “factory” of the parent component ID and all child component IDs extracted in the first extraction step S3 and the second extraction step S6 are stored. The combination of the parent part and the child part is registered in the part related information recording unit 12.

  More specifically, FIG. 15 is a diagram showing a registration example of an ID registration screen read from components and units.

  As shown in FIG. 15, in the ID registration screen of FIG. 13, the ID registration field associated with parent part: product = “TV”, child component 1: product = “panel”, child component 2: product = “board”. 10, a case where a parent part: ID = “MODELTV1234567123456AB”, a child part 1: ID = “PNL12345123456CD”, a child part 2: ID = “200707PWB12312345” is registered as an example.

  In the parent part, “22” is extracted from the ID = “MODELTV1234567123456AB” as “registered digit number” which is the total number of characters, and the last two digits “AB” in the ID are extracted as a character string representing “factory” (step) S3). Then, [ID of the parent part = “TV”] AND [number of digits = “22”] AND [factory = “AB”] is designated to search the ID configuration information in FIG. 12 (step S4). The start position = “1”, the number of characters = “14”, the serial number start position = “15”, and the number of characters = “6” are acquired. From the obtained item part start position = “1” and the number of characters = “14”, serial number part start position = “15” and the number of characters = “6”, as shown in FIG. Registered character string “MODELTV1234567123456AB” as parent part: item (character string from the first to the 14th ID) = “MODELTV1234567”, parent part: serial number (character string from the 15th to the 20th ID) = “123456”, parent part: factory (character string extracted as a character string representing “factory”) = “AB” (step S6).

  Similarly, in the child component 1, “16” is extracted from the ID = “PNL12345123456CD” as “registered digit number” which is the total number of characters, and the last two digits “CD” in the ID is extracted as a character string representing “factory”. (Step S3). Then, specifying [product type of child component 1 = “panel”] AND [number of digits = “16”] AND [factory = “CD”] and retrieving the ID configuration information of FIG. Start position = “1”, the number of characters = “8”, the serial number start position = “9”, and the number of characters = “6”. From the obtained item part start position = “1” and the number of characters = “8”, serial number part start position = “9” and the number of characters = “6”, as shown in FIG. The character string “PNL12345123456CD” registered in the sub-part 1: Item (ID 1st to 8th character string) = “PNL12345”, Child part 1: Serial number (ID 9th to 14th characters) Column) = “123456”, child component 1: factory (character string extracted as a character string representing “factory”) = “CD” (step S6), and component-related information recording unit together with parent component information 12 (step S7).

  Similarly, in the child part 2, “17” is extracted from the ID = “200707PWB12312345” as the “registered digit number” which is the total number of characters, and the last two digits “45” in the ID are extracted as a character string representing “factory”. (Step S3). Then, [type of child component 2 = “board”] AND [number of digits = “17”] AND [factory = “45”] is designated to search the ID configuration information in FIG. 12 (step S4). Here, there is no corresponding ID configuration information under the above conditions, and the character string start position and the number of characters cannot be acquired from the ID configuration information. Therefore, this time, [product type of child component 2 = “board”] AND [number of digits = “17” ]] The ID configuration information is searched again under the condition of AND [factory presence = “none”] (step S5), the start position of the item part = “7”, the number of characters = “6”, and the start position of the serial number part 1 = "1" and the number of characters = "6", and the start position of the serial number part 2 = "13" and the number of characters = "5" are acquired. The start position of the obtained item part = “7” and the number of characters = “6”, the start position of the serial number part 1 = “1” and the number of characters = “6”, and the start position of the serial number part 2 = “13” and the number of characters = “5”, as shown in FIG. 15, the character string “200707PWB12312345” registered in the ID column of the child part 2 is changed to the child part 2: item (the seventh to 12th character strings of the ID) = “PWB123 ”, Child part 2: serial number (first to sixth character string of ID and 13th to 17th character string of ID) =“ 200707 ”and“ 12345 ”(step S6), parent Together with the component information, it is registered in the component-related information recording unit 15 (step S7).

  When the component-related information recording means as described above is used to record the combination information of the parent-child relationship of the component and unit in the component-related information recording unit 12, the number of combinations of the component and unit parent-child relationship increases, and all the combination information is stored. A large-capacity component-related information recording unit may be required for recording. In this case, in order to reduce the recording amount of the parent-child relationship combination information of parts and units, the part usage information recording means can be applied as illustrated in FIGS.

  By doing this, even if the combined data amount of the parent and child relationships of the parts and units constituting the product increases, the parts related information output means searches for the parts related information generated by the parts related information generation means. Every time it is executed, all the combination information is created in advance by temporarily generating and outputting the combination information of the target parent / child parts based on the part usage information indicating the production status of the parent parts and the usage status of the child parts. Need not be recorded in the database, and the data recording capacity can be reduced accordingly.

  Note that which one of the component-related information recording unit, the component usage information recording unit, and the component-related information generation unit is used to read the ID depends on the number of products produced, the components constituting the product, and In consideration of the number of units and the data recording capacity of the component-related information recording unit 12, the user of this system can determine in advance for each product production line.

1 is a functional configuration diagram schematically illustrating an embodiment of a component-related information management system according to the present invention. It is a schematic diagram for demonstrating the component usage information collection timing at the time of reading component usage information in the component usage information ID reading part. It is a figure for demonstrating the component usage information recorded on the component usage information recording part, Comprising: FIG. (A) is a figure which shows an example of parent part production information, (b) is child component usage information. (C) is a figure which shows an example of the production use record of the parent part and the child part based on the information shown to Fig. (A) and (b). It is an example of the flowchart which shows the flow of the process performed by a component relevant-information production | generation means. It is a figure which shows the component usage pattern (1) of a production facility. It is another example of the flowchart which shows the flow of the process performed by a component relevant-information production | generation means. It is a figure which shows the component usage pattern (2) of a production facility. It is a figure which shows an example of the component relevant information produced | generated in the component relevant information generation part. It is a functional block diagram which shows schematically other embodiment of the components relevant-information management system shown in FIG. It is a figure which shows an example of ID information of the parent-child components recorded on the component relevant information recording part. It is a function block diagram which shows schematically other embodiment of the components relevant-information management system shown in FIG. It is explanatory drawing which shows an example of the storage content of ID structure information recording part. It is a figure which shows an example of the ID registration screen used with the ID reading part of the components relevant-information management system shown in FIG. It is an example of the flowchart which shows the control operation in the component relevant information recording means of the component relevant information management system shown in FIG. It is a figure which shows the registration example of the registration screen of ID read from components and a unit.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Component relevant information management system 11 Component relevant information ID reading part 12 Part relevant information recording part 13 Part usage information ID reading part 14 Part usage information recording part 15 Part relevant information generation part 16 Part relevant information output part 17 Control part

Claims (6)

Managing related information of ID information assigned to each parent-child part in a production line that produces a product composed of a plurality of parent-child parts consisting of at least one of a part and a unit that is a combination of parts A component-related information management system,
Component usage information recording means for recording component usage information indicating the production status of the parent component and the usage status of the child component;
Based on the component usage information recorded by the component usage information recording unit, component related information generating unit for generating component related information that is parent-child relationship information of each parent-child component;
A component-related information management system comprising: a component-related information output unit that searches for and outputs parent-child relationship information of the ID of each parent-child component based on the component-related information generated by the component-related information generation unit. In the component-related information management system according to claim 1,
The ID information given to each parent-child part is read for each combination of parent-child parts of the parent-child parts at the time of product assembly work, and the part-related information is obtained by using the parent-child relation of the read parent-child parts as ID combination information. It further comprises a component related information recording means for recording in the recording unit,
The component related information output means includes
The parent-child relation information of the ID of each parent-child component is retrieved and output by the combination information of the ID recorded in the component-related information recording unit by the component-related information recording unit,
Alternatively, based on the component usage information recorded by the component usage information recording unit, the parent-child relationship information of the ID of each parent-child component is searched and output by the component-related information generated by the component-related information generating unit. A component-related information management system characterized in that it can be switched to In the component-related information management system according to claim 2,
The part related information recording means reads the “parent part ID” of the produced parent part and the “child part ID” of the child part used for production, and reads the read “parent part ID” and “child part ID”. A component-related information management system comprising means for recording component-related information, which is combination information, in the component-related information recording unit. In the parts related information management system according to any one of claims 1 to 3,
The component usage information recording means reads the “parent part ID” of the produced parent part and records the parent part production information indicating the production status of the parent part, and the “child part of the child part used for production” Means for reading “ID” and recording child component usage information indicating the usage status of the child component;
Further, the parent part production information includes at least parent part identification information having information of a “parent part ID” for identifying the produced parent part, and “process” and “facility” information indicating a place where the parent part is produced. And production time information having information of "parent part production start date and time" and "parent part production completion date and time" indicating the time when the parent part was produced,
The child component usage information includes at least child component identification information having information of “child component ID” for identifying a child component used for production, and “process” and “equipment” indicating a place where the child component is used. Component-related information, including usage location information having information on the location and usage date information having information on the date and time when the child component was used and the date and time when the child component was used. Management system. In the parts related information management system according to claim 4,
The component related information generating means specifies the ID of a parent component and specifies the ID of a child component related to the ID,
A parent part ID information extracting step for extracting information on a parent part ID to be searched from the parent part production information;
For each piece of information related to the parent part ID extracted in the parent part ID information extracting step, from the child part usage information, the same “process” and the same “equipment” as the parent part are used. = “Parent part production start date and time” and “Parent part production completion date and time <= Child part use completion date and time”,
Or, “subpart use start date <= parent part production start date” and “parent part production start date <= subpart use completion date <= parent part production completion date”,
Or “parent part production start date and time <= child component use start date and time <= parent part production completion date and time” and “parent part production completion date and time <= child component use completion date and time”,
Or, “parent part production start date and time <= subpart use start date and time <= parent part production start date and time” and “parent part production start date and time <= child part use start date and time <= parent part production start date and time”
A component-related information management system comprising: executing a first generation step of generating combination information of a parent component ID and a child component ID by extracting a child component ID satisfying any one of the conditions. In the parts related information management system according to claim 4 or 5,
The component related information generating means specifies an ID of a child component and specifies an ID of a parent component related to the child component ID,
A child component ID information extracting step for extracting information on the child component ID to be searched from the child component usage information;
For each piece of information regarding the child part ID extracted in the child part ID information extracting step, “parent part production start date <=” in the same “process” and the same “equipment” as the child part from the parent part production information. Child part use start date and time "Child part use completion date and time <= Parent part production completion date and time"
Or “parent part production start date and time <= child component use start date and time” and “child component use start date and time <= parent part production start date and time <= child component use completion date and time”,
Or “subpart use start date <= parent part production start date <= subpart use completion date” and “subpart use completion date <= parent part production completion date”,
Or, “subpart use start date and time <= parent part production start date and time <= subpart use start date and time” and “subpart use start date and time <= parent part production start date and time <= subpart use start date and time”
A component-related information management system comprising: executing a second generation step of generating combination information of a parent component ID and a child component ID by extracting a parent component ID that satisfies any one of the conditions.