JPH0744612A - Production information output device - Google Patents

Abstract

PURPOSE:To provide a production information output device which is capable of integrating much information on the production condition, etc., on the component parts of plural products and easily outputting necessary information in a necessary form. CONSTITUTION:A production information output device M 2 has a component parts information storage means M 10 storing the information on parts M 6 to M 6 composing plural products M 4 to M 4, a production information storage means M 12 storing the production information of each product M 4 to M 4 and a physical distribution information storage means M 14 storing physical distribution information for supplying each part M 6 to M 6. By an information extraction means M16, arbitrary information is extracted from each information stored in each information storage means M 10 to M 14, the extracted information is collated between arbitrary products by an edition output means M 18, and the information is outputted as either one of (1) the information on all the products composing more than two products, (2) the information on the only parts common to more than two products and (3) the information on only parts which are specific to each of more than two products.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a production information output device capable of extracting necessary information from production information, distribution information, etc. of parts constituting a plurality of products, editing the information in a required format and outputting the information. Regarding

[0002]

2. Description of the Related Art In a production system for producing a plurality of types of products, such as automobiles, which are made up of an extremely large number and types of parts, the production, distribution, and use of these various types of parts are accurately and efficiently controlled. Required to do so. That is, it is necessary to collectively manage the types and number of parts required for each product type, the production method and production line, and the inventory status and procurement method of each part. As a method of managing the parts, for example, Japanese Patent Publication No. 3-15223
There is an invention of a parts table management system described in Japanese Patent Publication. The technique described in this publication discloses a method of managing a design parts management table for extracting component information from a design drawing. That is, in the past, the version number of the child drawing of the component was described in the parent drawing of the product, but the version number of the child drawing is automatically output. This eliminates the inconvenience that the parent drawing must be revised every time the drawing of the component is revised, and management when changing the component is facilitated. In this way, efficient management of various types of parts is achieved.

[0003]

However, in the technique described in the above publication, basically, the data indicating the relationship between the product and the parts and the data for managing other production processes are separately provided. I can't. Therefore,
In order to obtain the data for production control, the manager etc. had to judge the relationship between these separate data.
In particular, in actual production control, it is often necessary to have information on the parts that are commonly used for multiple products. Therefore, multiple types of two-dimensional forms can be output and these forms can be used by an administrator or the like. Compared with each other, I got various information. In this way, when trying to obtain information on production conditions, distribution conditions, etc. for many types of parts that make up multiple products,
It was necessary for people to compare and judge a large number of forms. Such work is extremely complicated, and not only does it take a lot of time and labor until necessary information is obtained,
There was a problem that human error was likely to occur. As a result, it may not be possible to obtain correct information, and even an instruction error may occur in the procurement of parts and the product may not be produced. Therefore, in the present invention, a production information output device capable of reliably and easily extracting the necessary production management information from the information about a plurality of types of parts constituting a plurality of products and outputting it in a required format. The purpose is to provide.

[0004]

In order to solve the above problems, the production information output device according to the present invention is configured as follows. That is, the production information output device M2 is
As the configuration is schematically shown in FIG. 1, a component part information storage means M10 for storing information of parts M6 to M6 constituting each product for a plurality of products M4 to M4 and a production process of each product M4. Production information storage means M12 for storing production information such as production conditions, physical distribution information storage means M14 for storing physical distribution information for procuring each part M6, component parts information storage means M10 for each product M4, production Information extracting means M for extracting arbitrary information from the information stored in the information storing means M12 and the physical distribution information storing means M14.
16, and the information extracted by the information extracting means M16 is collated between any two or more products among the products M4 to M4,
Three types of information: information about all parts that make up the two or more products, information about only parts common to the two or more products, and information about only parts unique to each of the two or more products. Edit output means M18 for editing and outputting any one of the information.

[0005]

Now, the production information output device M2 according to the present invention is
Parts M constituting each product for a plurality of products M4 to M4
6-M6 component information storage means M10 for storing information
A production information storage means M12 for storing production information such as production conditions in the production process of each product M4, and a physical distribution information storage means M for storing physical distribution information for procuring each part M6.
14 and. Then, by the information extracting means M16, the component part information storing means M1 for each product M4.
0, production information storage means M12, physical distribution information storage means M14
Arbitrary information is extracted from each information stored in.
Further, by the edit output means M18, the information extraction means M
The information extracted in 16 is collated between any two or more products in the products M4 to M4, edited into any one of the following three types of information, and output. Information about all parts that make up the two or more products Information about only parts common to the two or more products Information about only parts unique to each of the two or more products In the production information output device M2, not only the necessary information can be arbitrarily extracted from the component information, the production information, and the physical distribution information of the plurality of products M4 to M4 and integrated, but the extracted information can be output. The products M4 to M4 can be collated and output as three types of collation information. In this way, it is possible to reliably and easily extract the necessary production control information from the information about the plurality of types of parts M6 to M6 that form the plurality of products M4 to M4 and output it in the required format. It becomes a production information output device that can be used.

[0006]

[Embodiment] Next, an embodiment embodying the present invention will be described.
This will be described with reference to FIGS. First, the outline of the production information output device will be described with reference to FIGS. 2 and 3. FIG. 2 is a block diagram showing a hardware configuration of an embodiment of the production information output device according to the present invention, and FIG.
FIG. 1 is a block diagram schematically showing an overall configuration of an embodiment of a production information output device. As shown in FIG. 2, the hardware configuration of the production information output device 2 in this embodiment is as follows.
A central processing unit (hereinafter abbreviated as “CPU”) 10 is provided as a center, and is configured by an information output device (output printer or the like) 12, an operator console 14, a main storage device 16, an auxiliary storage device 18, and the like. The CPU 10;
The information output device 12, the operator console 14, the main storage device 16, and the auxiliary storage device 18 are connected to each other by a data bus 20 so that data can be transferred to each other.

FIG. 3 shows the overall configuration of the production information output device 2 of this embodiment constructed on the hardware of FIG.
Will be described with reference to the block diagram of FIG. As shown in FIG. 3, in the production information output device 2 of the present embodiment, the output request condition input means 2 is provided through the operator console 14.
2, the output request condition is input and stored in the output request condition storage means 24. On the other hand, from the conventional information creating device 26, the component current unit information input means 28
Each information is stored in the technical information (component information) file 30, the production information file 32, and the distribution information file 34. Then, when an output notification is given from the operator console 14, according to the output request condition,
Necessary information is extracted from the technical information file 30, the production information file 32, and the physical distribution information file 34 and input to the editing result determining means 36. The information edited by the edit result determination means 36 is stored in the edit result storage means 38. Then, the edit result output means 40 outputs the result on the output device 12 of the conventional technique.

Next, the information output processing of the production information output device 2 will be described in accordance with a concrete example with reference to FIGS. In the present embodiment, as shown in FIG. 4, products A, products B, products C, ... Each product A, product B, product C, ... Has the component structure shown in FIG. That is, the product A is composed of two types of parts a and b, of which the part a is composed of two types of parts c and d. Further, the component c is composed of two types of components e and f. Here, the parts a and b that directly compose the product A are referred to as constituent level 1 parts, and LX
It is represented by 1 = 1. Hereinafter, the components c and d that directly configure the component a of configuration level 1 are referred to as the components of configuration level 2, and the components e and f that directly configure the component c of configuration level 2 are the components of configuration level 3. Call.

Further, as shown in FIG. 4, the product B is composed of two kinds of parts g and n, and the part g is composed of two kinds of parts c and h. Among them, part c
Is a part common to the product A, and two kinds of parts e and f
It consists of Therefore, the components g and n have the configuration level 1, the components c and h have the configuration level 2, and the components e and f have the configuration level 3. Further, the product C is composed of two kinds of parts m and b, and the part m is composed of two kinds of parts q and h. Of these, the part q is composed of two types of parts e and r. Therefore, the components m and b have the configuration level 1, the components q and h have the configuration level 2, and the components e and r have the configuration level 3. In addition, each product A, B, C of this embodiment
In the above, one component at each configuration level is used, but the production information output device 2 of the present embodiment can be applied to a product in which two or more components of the same type are used. it can.

The contents of the technical information file, which summarizes the constituent part information (technical information) of each product having such a part structure, will be described with reference to FIG. As shown in FIG. 5, the technical information file includes six variables LX1, HX1,
.., TX2.
The variable LX1 indicates the configuration level of each component,
The variable HX1 indicates the parent product number, that is, the product number of the original product or part. Further, the variable HX2 indicates a child product number, that is, the product number of a component forming the parent product or the parent component, and the variable NX indicates the number of used component parts. Furthermore, the variables TX1 and TX2 display the time control of each part. The time control indicates a period during which the component indicated by the child part number HX2 is effectively used, and the variable TX1 indicates the beginning of the period.
The variable TX2 indicates the end of each period. For example, in FIG. 5, the configuration level of the part a that constitutes the product A is 1, the number of used parts is 1, and it is used from February 1, 1992 to March 1, 1993. Recognize. The technical information file indicates the type (sub-product number) of the constituent parts, the number of used parts, the effective period (time control), etc. for each product, and all the information about the constituent parts can be obtained.

Next, the contents of the production information file in which information such as the production conditions in the production process of each product is collected will be described with reference to FIG. As shown in FIG. 6, the production information file is composed of data corresponding to six variables GX1, GK, ..., GTM. Variable GX1
Indicates the product number of each product, and the variable GK indicates the production process of each product. Further, the variable GF indicates the production code of each product, and the variable GID indicates the production I of each product.
D is shown. The variables GTK and GTM display the time control of each product. With this production information file, it is possible to know the process (production process) in which each product is produced from each component, the production conditions, etc., and all information regarding the production process of the product can be obtained.

Next, the contents of the distribution information file, which summarizes the distribution information for the procurement of each part, will be described with reference to FIG. As shown in FIG. 7, the distribution information file is composed of data corresponding to 11 variables SX2, SKG, ..., STM. The variable SX2 indicates the product number of each part, and the variable SKG indicates the process in which each product is manufactured. Further, the variable SKM indicates a process of receiving each part, that is, a process of manufacturing each part. Further, the variable SM indicates the part number name of each part, the variable SB indicates the ID of the part shelf in which each part is stored, and the variable SL indicates the ordering unit (the size of the lot at the time of distribution) of each part. Further, the variable KN is the name of the take-back destination (production process of parts) of each part, the variable SS is the part ID of each part, and the variable S is
N indicates the component characteristics of each component. And
The variables STK and STM represent the time control of each component. This distribution information file indicates the process (collection process) where each component is produced, the storage location (parts shelf ID), the size of the distribution lot (ordering unit), etc.
Get all information about parts procurement.

Next, output request conditions for designating which information is extracted from these three types of information files will be described with reference to FIG. This output request condition is the content stored in the output request condition storage means 24 shown in FIG. As shown in FIG. 8, this output request condition is a serial number R (= 1, 2, 3, ...) Attached to each condition.
, And 6 designated variables RK, RH, ..., UR. The variable RK specifies the production process of the product (variable GK in FIG. 6). The variable RH specifies the type of product by the product number (variable HX1 in FIG. 5 and variable GX1 in FIG. 6) and the like. In FIG. 8, RH is specified by the product number, but in addition, the production code GF and the production ID of FIG. 6 are used.
It can also be designated by = GID. As a result, the type of product can be output as a format that is highly relevant to the required information, and the output information is easy to use. Further, this variable RH can specify the type of product by a wild card method. For example, when designating with the production ID in FIG. 6, if GID = S001 is entered, only product A is designated. Here, if GID = S00 * is set using the wild card method, not only product A but also product B with GID = S003 and GID = S009.
The product C which is the same is also designated. This makes it possible to collectively specify related products.

Next, the variable RJ in FIG. 8 designates the editing method, and is a variable for determining which other serial number R the information obtained by one serial number R is to be matched with. .
For example, for serial numbers R = 1, 2, 3 respectively, RJ
= GR1, GR2, GR3, and the first two digits (GR) of the variable RJ are common. By this, serial number R =
The information items 1, 2, and 3 are collated with each other according to the designation of the editing condition RP described later. The order of collation is such that the last digit is 1 (Fig. 8), depending on the last digit of the variable RJ.
Then, the information of the product A of RJ = GR1) and the product of which the last digit is 2 (the information of the product B of RJ = GR2) are first compared.
Subsequently, the ones having the last one digit of 2 and the ones having the last one digit of 3 are finally collated. When only two pieces of information are to be collated, the last digit of the variable RJ is only 1, 2 and blanks are input to the variable RJ for those which are not collated. In the present embodiment, the last digit of the variable RJ is up to 3 and up to 3 pieces of information can be collated with each other, but it is also possible to collate 4 or more pieces of information as needed. is there.

The variable RT is also used to extract information about components at a specific time for each product by using the time control of each information file.
In FIG. 8, information about the component parts as of March 1, 1993 for product A and 1 for product B is shown.
Information about the component as of April 1, 993 is specified. The variable RP is for specifying the editing condition (output format) corresponding to the editing method RJ. When the editing method RJ is blank and there is no collation partner, only all information output can be designated, but when there is a collation partner, all information output, common partial output, or unique partial output can be designated. That is, as the editing condition RP, different output formats can be designated for the editing methods RJ having different first two digits. Then, with regard to the user numbers UR, the processing is executed with the same user number UR as one unit.

Three types of output formats by specifying the above-mentioned editing condition RP, that is, all information output, common partial output, and unique partial output will be described with reference to FIG. Here, consider a case where information about three types of products, which is the maximum number that can be collated, is collated. FIG. 9 shows information 61 about components of the product A, information 62 about components of the product B, and information 63 about components of the product C. An overlapping portion 64 of the information 61 and the information 62 indicates information about components common to the product A and the product B,
The overlapping portion 65 of the information 62 and the information 63 is the product B and the product C.
It shows information about components common to the. Further, the overlapping portion 66 of the information 63 and the information 61 represents information on the components common to the product C and the product A, and the information 6
An overlapping portion 67 of 1, 62 and 63 represents information on components common to all products A, B and C.

Of the three types of output formats described above, the all-information output is to output information 60 (61 + 62 + 63) about all the constituent parts of the products A, B, and C.
Further, the common part output is information about parts common to two or more types of products, that is, the overlapping parts 64, 65,
The information of 66 and 67 is output. Further, the unique part output is to output information about parts used only for any of the products A, B, and C, that is, the total information 60 excluding the information of the overlapping parts 64, 65, 66, and 67. Is. As described above, the variable RP indicating the editing condition
(RP = 1, 2, 3), any one of these three types of output formats can be selected. RP = 1
Designates all information output, RP = 2 corresponds to common partial output, and RP = 3 corresponds to unique partial output. In the present embodiment, the above three types of output formats can be designated.
It is possible to specify an output format such as outputting information 67 about components common to all B and C or outputting information about all components of two types of products (for example, A and B). It is also possible.

Specific examples of these three types of output formats will be described with reference to FIGS. FIG. 10 shows data output by all information output, FIG. 11 shows common part output, and FIG. 12 shows unique part output. These data are
The data corresponds to the component configuration diagram of FIG. In the all information output data of FIG. 10, information of all the constituent parts of the product manufactured in the production process KK1 is output according to the designation of the production process (RK = KK1) of FIG.
Since the products A, B, and C are all produced in the production process KK1 as shown in FIG. 6, FIG. 10 includes information about all the components shown in the component configuration diagram of FIG. There is. As all information output data, information such as the component configuration level, the product number (LX1 and HX2 in FIG. 5), and the number of products used for each product is output. Furthermore, for the part a, as a remark, the part shelf ID = SB11 in FIG. 7 is also output. Also, the product type is not the product numbers A, B, and C, but the product type shown in FIG.
The production code GF = ZA, ZB, ZC.
This is the output result when the production code GF is designated instead of the product number as the product type RH in FIG.
Further, according to the designation method of FIG. 8, as shown in FIG. 10, the part number name SM1, the part ID: SS1, the take-back destination process KK9, the take-over destination name KN9, etc. are output instead of or at the same time as the part number a. You can also

In the common part output data of FIG. 11,
Of all the information output data of FIG. 10, only the information of the parts common to two or more products is output. As shown in FIG. 4, components c, e, and
There are five types, f, h, and b. Here, the collation of the information between the products is executed in the order determined by the value of the last digit of the editing method RJ shown in FIG. That is, first, R
The product A having J = GR1 and the product B having RJ = GR2 are collated, and the parts are the parts common to the products A and B (including the parts common to all the products A, B, and C). The data of c, e, and f are output first. Next, RJ =
The product B of GR2 and the product C of RJ = GR3 are collated, and the data of the part h common to the products B and C is output. Then, finally, the data of the part b common to the products C and A is output.

On the other hand, in the peculiar partial output data of FIG. 12, only the peculiar parts of each product are output among all the information output data of FIG. As shown in FIG. 4, the parts unique to each product are the parts a, g, m, q,
There are seven types, r, d, and n. As shown in FIG. 9, the unique part is the common part 64, 65, 66, 6 from all the information 60.
7 is removed, the data obtained by combining the data shown in FIGS. 11 and 12 is the total information output data shown in FIG. Of the above-described FIGS. 10 to 12, what actually corresponds to the condition designated in FIG. 8 is the common partial output data of FIG. This is because RP = 2 is designated as the editing condition in FIG.

Now, the procedure of information processing performed in the production information output device 2 as described above will be described with reference to FIGS. 13 and 14.
This will be described with reference to FIGS. 3 to 12 according to the flowchart of FIG. FIG. 13 is a flow chart showing the overall flow of information processing in the production information output device 2 of this embodiment, and FIG. 14 is a flow chart showing the procedure for determining the output format. The information processing program shown in the flowcharts of FIGS. 13 and 14 is stored in the main storage device 16 of the production information output device 2 of FIG.
10 run on. When the process starts in step S10 of FIG. 13, first, the output request condition storage means 24 of FIG. 3 causes the variables R, RK, RH, R of FIG.
J, RT, RP, UR are read (step S1
2). Then, from the technical information file 30 of FIG.
Variables HX1, TX1, TX2 are HX1 = RH, TX
Data satisfying 1 ≧ RT and TX2 ≦ RT are extracted (step S14).

Next, it is determined whether the variable RJ is a space or blank (step S16). If the determination result is NO, the process proceeds to step S18,
When the first two digits of the variable RJ are the same, the last one digit is arranged in ascending order. Next, it is determined whether the variable RP is 2 or 3 (step S20). Then, if the determination result is YES, the process proceeds to step S22 and the matching process is executed. First, in step S18, the first and second ones of the variables RJ arranged in ascending order of the last digit of the variable RJ are collated and extracted according to the condition indicated by the variable RP. Subsequently, the second and third ones are similarly collated, and finally the third and first ones are similarly collated (step S22).
After the collation processing is executed in this way, the process proceeds to step S24. On the other hand, if the determination result in step S16 is YES, or if the determination result in step S20 is NO, the process directly proceeds to step S24.

The data thus extracted in step S14 or step S22 is output in the format (output format) shown in FIGS. 10 to 12 (step S24). Then, in step S26, it is determined whether or not there is another designation in which the upper two digits of the variable RJ are different. If the determination result is YES, the process returns to step S12 and steps S12 to S24.
The above process is repeated only for types in which the first two digits of the variable RJ are different. Then, if all the collations of the groups having different first two digits of the variable RJ are completed and the determination result in step S26 is NO, the process according to the flowchart of FIG. 13 is completed (step S28).

Next, in step S24 of FIG.
A procedure of determining the output format and outputting the output format will be described with reference to the flowchart of FIG. here,
The case of all information output shown in FIG. 10 is taken as an example. 14
When the format determination process is started in step S30, first, based on the output request condition of FIG.
Data corresponding to production process = KK1 is extracted from each information file of FIGS. 5 to 7 (step S32). Then, an output format is created according to the output requirement of FIG. Here, the format of all information output of FIG. 10 is created (step S34). Next, when the production code or the production ID is designated as the product type instead of the product numbers A, B, and C in the output requirement condition of FIG. 8, the product number is the production code or the production ID according to FIG. Is replaced with (step S36). further,
From the distribution information file of FIG. 7, data such as a product number name SM, a component ID: SS, a delivery destination process SKM, a delivery destination name KN corresponding to the output product number of the component is extracted. Then, these data are output in parallel in the part number column and the remarks column of the format of FIG. 10 (step S3).
8). In this way, all the information data shown in FIG. 10 is output, and the processing of the flowchart of FIG. 14 ends (step S40).

In this way, in the production information output device 2 of the present embodiment, the production conditions, physical distribution conditions, etc. for the respective parts a, b, ... Constituting the plurality of products A, B, C ,. Information can be integrated, necessary information can be extracted from the information, and the result of collation between products can be output. Therefore, it is possible to reliably output the required information in the required format from the enormous amount of information about the various types of parts. Therefore, unlike the conventional case where a person compares and judges multiple data files, human error does not occur, and it is possible to ensure that the production of products is hindered due to insufficient procurement of parts. Can be prevented.

In this embodiment, a technical information file,
As the production information file and the distribution information file, the data files in the tabular format as shown in FIGS. 5 to 7 have been described as an example, but each of these information files is not limited to the tabular file, and any format Information file may be used. Further, the information storage means in the present invention includes not only a mere data storage device but also all objects that can be accessed and processed by the information processing system, such as a memory device in a control unit of an automatic control machine. . Further, in the present embodiment, the output data shown in FIGS. 10 to 12 has been described as a specific example of data output, but the format and contents of these output data are merely examples, and various output other than this is also possible. Format and data contents are possible. The configuration, size, number, shape, etc. of the other parts of the production information output device are not limited to those in this embodiment.

[0027]

According to the present invention, the information extracting means for extracting arbitrary information from the three kinds of information storing means and the extracted information are collated between any two or more products, and all the information and the common part are obtained. Since a production information output device having an information output device and an edit output device for editing and outputting to any one of information of unique part information is created, among a vast amount of information about many kinds of parts constituting a plurality of products, The required information can be output reliably in the required format. This makes it possible to easily and surely obtain the necessary production control information from a large number of information, and to prevent troubles such as insufficient procurement of parts due to human error, and to output extremely practical production information. It becomes a device.

[Brief description of drawings]

FIG. 1 is a diagram schematically showing a configuration of a production information output device according to the present invention.

FIG. 2 is a block diagram showing a hardware configuration of an embodiment of the production information output device.

FIG. 3 is a block diagram schematically showing the overall configuration of an embodiment of the production information output device.

FIG. 4 is a parts configuration diagram showing a parts configuration of a product in one embodiment of the production information output device.

FIG. 5 is a diagram showing the contents of a technical information file in an embodiment of the production information output device.

FIG. 6 is a diagram showing the contents of a production information file in one embodiment of the production information output device.

FIG. 7 is a diagram showing the contents of a distribution information file in one embodiment of the production information output device.

FIG. 8 is a diagram showing the contents of output request condition storage means in an embodiment of the production information output device.

FIG. 9 is a diagram showing an editing unit of extracted information in an embodiment of the production information output device.

FIG. 10 is a diagram showing a state in which all information of the extracted information in the embodiment of the production information output device is output.

FIG. 11 is a diagram showing a state in which information of a common part among the extracted information in the embodiment of the production information output device is output.

FIG. 12 is a diagram showing a state in which a unique part of the extracted information is output in the embodiment of the production information output device.

FIG. 13 is a flowchart showing the overall flow of information processing in one embodiment of the production information output device.

FIG. 14 is a flowchart showing a procedure for determining an output format in an embodiment of the production information output device.

[Explanation of symbols]

 M2,2 Production information output device M4 to M4, A, B, C, ... Plural products M6 to M6, a, b, c, .. Parts constituting each product M10, 30 Component information storage means M12, 32 Production Information storage means M14,34 Physical distribution information storage means M16,14,22,24 Information extraction means M18,12,36,38,40 Edit output means

Claims (1)

[Claims] 1. A component information storage means for storing information of parts constituting each product for a plurality of products; a production information storage means for storing production information such as production conditions in a production process of each product; Physical distribution information storage means for storing physical distribution information for procuring parts constituting each product; and for each product, stored in the constituent part information storage means, the production information storage means, and the physical distribution information storage means. Information extracting means for extracting arbitrary information from each piece of information, and information extracted by the information extracting means is collated between arbitrary two or more products in each product to form the two or more products. Information about all parts to be used, information only on parts common to the two or more products, information only on parts unique to each of the two or more products, and any one of three types of information Edit output means editing and outputting, production information output apparatus characterized by having a city.