JP2009080531A - Integrated parts list preparation system, and integrated parts list preparation method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide an integrated parts list preparation system capable of preparing various integrated parts lists with a plurality of various pieces of production basic information combined freely from a higher rank toward a lower rank, and capable of preparing efficiently the integrated parts list of various articles. <P>SOLUTION: This integrated part list preparation system 10 has: an integrated part list preparation means for integrating a binary relation and a trinomial relation extracted from a constitutional master, and for preparing the integrated parts list of the articles by laying serially the pieces of production basic information extracted from a production basic information master 12, from a higher rank thereof toward a lower rank thereof, according to the integrated relations thereof; a relation sharing means for sharing the binary relation and the trinomial relation applicable for the other article, out of the binary relations and the trinomial relations of the prescribed article, between the prescribed article and the other article; and a relation diverting means for diverting the binary relation and the trinomial relation applicable for the other article, out of the binary relations and the trinomial relations of the prescribed article, to the other article from the prescribed article. <P>COPYRIGHT: (C)2009,JPO&INPIT

Description

  The present invention relates to an integrated parts table creation system and an integrated parts table creation method for creating an integrated parts table of articles by connecting various pieces of basic production information in series from the upper level to the lower level.

There is a production management system that creates a configuration table of a mechanical device by developing a plurality of parts constituting the mechanical device in a tree structure (see Patent Document 1). In this system, the data number of the mechanical device is set to 000, the first part number of the first part connected to the nearest lower part is set to 100, 200, 300. The second part numbers of the two parts are 110, 120, 130..., And the third part numbers of the third parts that are immediately below the second part number 110 are 111, 112, 113. The second part numbers connected to the first part number 200 are 210, 220, 230..., And the second part numbers connected to the first part number 300 are 310, 320, 330. Further, the third part numbers that are connected to the second part number 210 are 211, 212, 213, and the third part numbers that are connected to the second part number 310 are 311, 312, 313, and so on. In this system, the first part number is connected to the data number of the machine, the second part number is connected to the first part number, and the third part number is connected to the second part number, thereby forming a plurality of machines. Can be expanded as a tree structure.
JP 2004-62526 A

  In the production management system disclosed in the above publication, the component parts of the mechanical device are managed by part numbers, and the first to third parts specified by the part numbers are arranged in order of numbers, so that they are specified in the immediate lower order of the first part. The second part is connected, and the specific third part is connected immediately below the second part. Therefore, in this system, the first to third parts arranged in a tree shape are uniquely defined, and different types of parts are arranged below the first parts and different kinds of parts are arranged below the second parts. Not only cannot be incorporated, but production basic information other than parts cannot be incorporated, and a configuration table in which different types of basic production information are freely combined cannot be created. In addition, in this system, it is not possible to create a configuration table that shares common parts or a configuration table that diverts common parts, and it is necessary to create a configuration table by assigning a different part number to each common part. The efficiency of creating a bill of materials is significantly reduced.

  An object of the present invention is to provide an integrated parts table creation system and an integrated parts table creation method capable of creating a wide variety of integrated parts tables in which various basic pieces of production information are freely combined from top to bottom. It is to provide. Another object of the present invention is to provide an integrated parts table creation system and an integrated parts table creation method capable of efficiently creating an integrated parts table for various articles.

  The premise of the present invention for solving the above-mentioned problem is an integrated parts table creation system that creates an integrated parts table of articles by connecting various pieces of basic production information in series from the upper level to the lower level.

  As a feature of the present invention based on the premise, the basic production information is linked by the binary relation between the arbitrary first basic production information and the second basic production information that is immediately below the first basic production information. The integrated parts table is linked by a ternary relationship between the first production basic information and the second production basic information that is immediately below the first production basic information and the third production basic information that is immediately below the second production basic information. The creation system includes a production basic information master that stores various types of basic production information, and a configuration master that stores various types of two-term relationships and various types of three-term relationships. Integrate the binary and ternary relationships extracted from the master, and connect the basic production information extracted from the basic production information master in a series from the higher level to the lower level according to the integrated relationship. Of the integrated part table creation means for creating an integrated part list of articles, and the two-term relation and the three-term relation of the predetermined article, the two-term relation and the three-term relation applicable to other articles are defined as the predetermined article. Relation sharing means for sharing with other articles, and relation diverting means for diverting the two-term relation and the three-term relation applicable to other articles from the predetermined article to the other articles among the two-term relation and the three-term relation of the predetermined article It is in having.

  As an example of the integrated parts table creation system, the relationship sharing unit changes when at least one of the first to third production basic information forming the binary relationship and the tertiary relationship of a predetermined article is changed. Among the two-term relationship and the three-term relationship of the predetermined article including the produced basic information, the predetermined article and the other article share the two-term relation and the three-term relation applicable to the other article.

  As another example of the integrated parts table creation system, the relationship sharing means includes at least one of the second production basic information and the third production basic information in at least one of the binary relationship and the tertiary relationship of the predetermined article. When added, the two-term relationship and the three-term relationship applicable to other articles among the two-term relation and the three-term relation of the predetermined article including the added production basic information are shared by the predetermined article and the other article. .

  As another example of the integrated parts table creation system, the relationship sharing unit deletes at least one of the second production basic information and the third production basic information forming the binary relationship and the ternary relationship of a predetermined article. Then, among the two-term relationship and the three-term relationship of the predetermined article excluding the deleted production basic information, the two-term relation and the three-term relation applicable to the other article are shared by the predetermined article and the other article.

  As another example of the integrated parts table creation system, the production basic information master stores the parts table formation time and the parts table departure time to classify the generation of the production basic information in time series, and the configuration master has two terms Are stored in chronological order, and the integrated BOM creation means is used to create BOM-related and ternary-related BOM formation and BOM withdrawal times. , A plurality of binary relations and ternary relations necessary for creating an integrated parts table at an arbitrary point in time from the past to the present are extracted from the configuration master, and the binary relations and 3 extracted from the configuration master are extracted. By integrating the term relations and connecting the basic production information extracted from the basic production information master in a series from the upper level to the lower level according to the integrated relations, any arbitrary items from the past to the present Creating an integrated bill of goods at the point.

  As another example of the integrated parts table creation system, when the relationship sharing unit changes the generation of the two-term relation and the three-term relation of the predetermined article, the two-term relation and the three-term relation of the predetermined article whose generation is changed Of these, the two-term relationship and the three-term relationship applicable to other articles are shared by the predetermined article and the other article.

  Another premise of the present invention for solving the above-mentioned problem is that the computer system is used to create an integrated bill of materials by connecting a plurality of various basic production information in series from the upper level to the lower level. This is a method for creating an integrated parts table.

  The feature of the present invention based on the above premise is that the integrated parts table creation method is linked to the production basic information master storing a plurality of various production basic information, and immediately below the arbitrary first production basic information and the first production basic information. A plurality of various binary relations of the basic production information linked by the binary relation with the second basic production information are stored, and the second basic production information that is connected immediately below the arbitrary first basic production information and the first basic production information. And a composition master storing a plurality of various three-term relationships of basic production information linked by a three-term relationship with the third basic production information that is immediately below the second basic production information. By integrating the binary and ternary relationships extracted from the configuration master, and connecting the basic production information extracted from the basic production information master in a series from the higher level to the lower level according to the integrated relationship. Of the integrated BOM creation process for creating an integrated BOM for a product and the binary and ternary relationships of a predetermined article, the two-term relationship and the three-term relationship applicable to other articles are defined as the predetermined article and the other article. And a relationship diversion process that diverts the two-term relationship and the three-term relationship that can be used for other articles from the predetermined article to the other article. There is to do.

  As an example of the integrated parts table creation method, the relationship sharing process is changed when at least one of the first to third production basic information forming the binary relation and the tertiary relation of the predetermined article is changed. Among the two-term relationship and the three-term relationship of the predetermined article including the produced basic information, the predetermined article and the other article share the two-term relation and the three-term relation applicable to the other article.

  As another example of the integrated parts table creation method, the relation sharing process includes at least one of second production basic information and third production basic information in at least one of a binary relation and a three-term relation of a predetermined article. When added, the two-term relationship and the three-term relationship applicable to other articles among the two-term relation and the three-term relation of the predetermined article including the added production basic information are shared by the predetermined article and the other article. .

  As another example of the integrated parts table creation method, at least one of the second production basic information and the third production basic information forming the binary relation and the ternary relation of the predetermined article is deleted in the relation sharing process. Then, among the two-term relationship and the three-term relationship of the predetermined article excluding the deleted production basic information, the two-term relation and the three-term relation applicable to the other article are shared by the predetermined article and the other article.

  As another example of the integrated parts table creation method, the production basic information master stores the parts table formation time and the parts table departure time for classifying the generation of the production basic information in time series, and the configuration master has a binary relation. The BOM formation time and the BOM withdrawal time that classify the generations of 3 and ternary relationships are stored in time series, and the integrated BOM creation process is performed when the BOM and ternary BOM formation and BOM withdrawal times , A plurality of binary relations and ternary relations necessary for creating an integrated BOM at any time from the past to the present are extracted from the configuration master, and the binary relations extracted from the configuration master and By integrating the ternary relationships and according to the integrated relationships, the basic production information extracted from the basic production information master is connected in a series from the higher level to the lower level. Creating an integrated bill of goods at the time of.

  As another example of the integrated parts table creation method, when the relationship sharing process changes the generation of the binary relationship and the ternary relationship of the predetermined article, the binary relationship and the ternary relationship of the predetermined article whose generation is changed Among them, the two-term relationship and the three-term relationship applicable to other articles are shared by the predetermined article and the other article.

  According to the integrated BOM creation system and the integrated BOM creation method according to the present invention, a plurality of various binary relationships and ternary relationships extracted from the configuration master are integrated, and according to the integrated binary relationship and ternary relationship. Since an integrated parts table corresponding to various articles is created by connecting a plurality of various pieces of basic production information extracted from the basic production information master from the upper level to the lower level, the first basic production information and the second basic production information By using binary relations formed from information and ternary relations formed from the first to third basic production information, a wide variety of integrated BOMs are created by freely combining various basic production information. be able to. In the integrated parts table creation system and the integrated parts table creation method, the two-term relation and the three-term relation applicable to other articles among the two-term relation and the three-term relation of the predetermined article are changed to the predetermined article and the other article. It is necessary to set a common two-term relationship or three-term relationship separately for a predetermined article and another article because the common two-term relation or three-term relation is applied to the predetermined article and other article in a unified manner. Therefore, it is possible to efficiently create an integrated parts list for various articles. The integrated parts table creation system and the integrated parts table creation method have the two-term relationship and the three-term relationship of the predetermined article, and the two-term relation and the three-term relation that can be used for the other article are changed from the predetermined article to the other article. Since it is diverted, it is not necessary to newly set the binary relation or the tertiary relation to other articles, and an integrated parts table for various articles can be efficiently created.

  When at least one of the first to third basic production information forming the two-term relationship and the three-term relationship of the predetermined article is changed, the two-term relation and the three-term relation of the predetermined article including the changed basic production information Among these, the integrated BOM creation system and the integrated BOM creation method that share the two-term relationship and the three-term relationship applicable to the other article between the predetermined article and the other article include the changed basic production information. Since the common relationship between the predetermined article and other articles in the two-term relation and the three-term relation is applied to these articles in a unified manner, the common two-term relation or the three-term relation is separately applied to the predetermined article and the other article. There is no need to set, and an integrated parts table for various articles can be created efficiently.

  When at least one of the second production basic information and the third production basic information is added to at least one of the binary relationship and the ternary relationship of the predetermined article, the binary relation of the predetermined article including the added production basic information An integrated BOM creation system and an integrated BOM creation method that share a two-term relationship and a three-term relationship applicable to other articles among the predetermined article and the other article are added production. Since a common relationship between a predetermined article and other articles in the two-term relation and the three-term relation including basic information is applied to these articles in a unified manner, the common two-term relation or the three-term relation is applied to the predetermined article and the other article. Therefore, it is possible to efficiently create an integrated parts table for various articles.

  When at least one of the second production basic information and the third production basic information forming the binary relation and the ternary relation of the predetermined article is deleted, the binary relation and 3 of the predetermined article excluding the deleted basic production information Among the item relationships, the integrated BOM creation system and the integrated BOM creation method that share the two-term relationship and the three-term relationship applicable to the other article between the predetermined article and the other article are the basic production information deleted. Since the common relationship between the predetermined article and other articles in the two-term relationship and the three-term relationship excluding the item is applied to these articles in a unified manner, the common two-term relation or the three-term relation is applied to the predetermined article and the other article. There is no need to set them separately, and an integrated parts table for various articles can be created efficiently.

  An integrated bill of materials creation system and an integrated bill of materials creation method for creating an integrated bill of materials at an arbitrary point in time from the past to the present store the bill of material formation time and the bill of material departure time of basic production information. Thus, the basic production information can be managed in time series from the past to the present, and by storing the BOM-related and ternary-related parts table formation time and BOM departure time, the binary relation and the 3 terms are stored. Since the relationship can be managed in chronological order from the past to the present, an integrated parts table at an arbitrary point in the past as well as the present can be created at the present.

  When the generations of the two-term relationship and the three-term relationship of the predetermined article are changed, the two-term relationship and the three-term relationship of the predetermined article whose generations are changed are changed to the two-term relationship and the three-term relationship applicable to other articles. The integrated parts table creation system and the integrated parts table creation method that are shared by other articles and the other parts are the same in the two-term relation and the three-term relation in which generations are changed. Therefore, it is not necessary to set a common binary relation or ternary relation separately for a predetermined article and another article, and an integrated parts table for various articles can be created efficiently.

  The details of an integrated parts table creation system and an integrated parts table creation method according to the present invention will be described below with reference to the accompanying drawings. FIG. 1 is a schematic configuration diagram of an integrated parts table creation system 10 shown as an example for executing an integrated parts table creation method. The integrated parts table creation system 10 includes a management computer 11, and a production basic information master 12 and a configuration master 13 connected to the computer 11 via an interface (wired or wireless).

  The basic production information is a plurality of various pieces of technical information (technical elements) indispensable for manufacturing articles, and in this embodiment, articles, bases, processes, and parts are illustrated as basic production information. However, the basic production information shown is an example, and the basic production information is not limited to them. The basic production information includes all pieces of technical information about the article. Articles and parts are item information, bases are base information, and processes are process information. The articles include not only finished products but also semi-finished products.

  In the basic production information, data division numbers (first to nth data division numbers) for dividing the basic production information for each type are individually set. The item data classification number (first data classification number, PC001) is set in the basic production information belonging to the item information, and the base data classification number (second data classification number, PC002) is set in the basic production information belonging to the base information. Is set. In the basic production information belonging to the process information, a process data division number (third data division number, PC003) is set. The basic production information items to which the basic production information belongs are not limited to items, processes, and bases. The production basic information item to which the basic production information belongs includes all the other items necessary for manufacturing the article, and the fourth to nth data classification numbers that specify it are set in the other production basic information items. Is done.

  The basic production information is linked by upper and lower binary relations between arbitrary first basic production information (parent production basic information) and second production basic information (child production basic information) that is immediately below the first production basic information. In addition, any first basic production information (parent production basic information) and second production basic information (intermediate production basic information) that are immediately below the first production basic information and second most basic production information that are immediately below the second production basic information. Linked with the upper and lower three-term relationship with the three basic production information (child production basic information).

  The management computer 11 has a central processing unit (CPU or MPU) and a storage device (memory), and incorporates a large-capacity hard disk. Although not shown, an input device such as a keyboard and a mouse and an output device such as a display and a printer are connected to the computer 11 via an interface. In the internal address file of the storage device, an integrated parts table creation application for executing each means (each process) of the system 10 is stored. The integrated parts table creation application is installed in the storage device of the computer 11 from an optical disk (storage medium) such as a CD-ROM storing the integrated component table creation application. In addition to the optical disk, a semiconductor memory or a magnetic disk can be used as the storage medium.

  When the integrated parts table creation application is installed in the computer 11, a model of basic production information items such as items, bases, and processes, and basic production information items are stored in a storage device of the computer 11 or a hard disk built in the computer 11. A plurality of various basic production information models belonging to, and data classification numbers corresponding to these basic production information items are stored. Further, a basic production information master 12 (item master 13, base master 14, process master 15) and configuration master 13 are created in the hard disk built in the computer 11. The computer 11 extracts necessary information from the storage device, the hard disk, the production basic information master 12, and the configuration master 13, and stores the information in the storage device, the hard disk, the production basic information master 12, and the configuration master 13 as necessary.

  In this system 10, in addition to the existing basic production information items and basic production information, new basic production information items and new basic production information can be freely set. It is also possible to create an integrated bill of materials using new basic production information. New production basic information items and new production basic information are input from the input device to the computer 11 and stored in the storage device or the hard disk of the computer 11. In the system 10, existing basic production information items and basic production information can be deleted from the storage device and the hard disk, and newly created basic production information items and new basic production information are deleted from the storage device and the hard disk. You can also.

  The central processing unit of the computer 11 starts an integrated parts table creation application stored in the internal address file of the storage device, and can be applied to other articles among the two-term relation and the three-term relation of a predetermined article according to the application. Relationship sharing means (relationship sharing process) for sharing a two-term relationship and a three-term relationship between a predetermined article and another article, and a two-term relation applicable to other articles among the two-term relation and the three-term relation of the predetermined article And a related diversion means (relevant diversion process) for diverting the three-term relationship from a predetermined article to another article.

  The central processing unit of the computer 11 includes binary relation integration means (binary relation integration process) for integrating various plural binary relations, and ternary relation integration means (ternary relation integration process) for integrating various plural ternary relations. ), A two-term / three-term relationship integration means (two-term / three-term relationship integration process) for integrating various binary relationships and ternary relationships. Furthermore, an integrated BOM creation means (integrated BOM creation process) that creates an integrated BOM corresponding to each article in real time based on the integrated relationship, and an integrated BOM created by the integrated BOM creation means Integrated bill of materials storage means (integrated bill of material storage process) that stores the data in the storage device or hard disk, and the integrated bill of materials created by the integrated bill of materials creation means is output via the output device The means (integrated parts table output process) is executed.

  The basic production information master 12 centrally manages a plurality of production basic information, the start date (parts table start time) and the end date (parts table end time) of the production basic information in a unified and time series. The configuration master 13 has two-term relation, three-term relation, two-term relation start date (BOM start time) and end date (BOM end time), three-term start date (BOM start time) and end date. Manage (at the end of the bill of materials) centrally and in time series. The production basic information master 12 and the configuration master 13 transfer each information to the computer 11 based on the information transfer command from the computer 11 and store each information based on the information storage command from the computer 11.

  The basic production information master 12 includes an item master 14 for storing item information for which the first data classification number (PC001) is set, and a base master 15 for storing base information for which the second data classification number (PC002) is set. , And a process master 16 for storing process information in which a third data division number (PC003) is set. The basic production information master 12 is not limited to the masters 14, 15, and 16, but other basic production information essential to the manufacture of the articles are stored separately for each type. In some cases, the n basic production information master is set in the hard disk.

  2 and 3 are diagrams showing examples of a plurality of pieces of item information (production basic information) stored in the item master 14 (production basic information master 12). An example of a procedure for storing item information in the item master 14 is as follows. Each item information of the article (A1), the article (B1), the article (C1), the article (D1), the part (a1), the part (b1), the part (c1), and the part (d1) This is information on the 1st of the month, and each item information of the article (A2), the article (B2), the article (C2), the part (a2), the part (b2), and the part (d2) is as of July 1, 2007. Information.

  When the computer 11 is activated, a screen for selecting a production basic information master and a configuration master is displayed on a display connected to the computer 11 (not shown). When the production basic information master is selected and a new setting is selected, a plurality of various production basic information items are displayed on the display. When you select an item from the basic production information item, the display will show the item input area, the start date (start time) input area when the BOM of item information is formed, and the end date when the item information leaves the BOM (When finished) The input area is displayed. The article (A1), the article (B1), the article (C1), the article (D1), the part (a1), the part (b1), the part (c1) and their product numbers (*, φ) are entered into the item input area by the input device. ), Product numbers (A1), (B1), (C1), (D1), (a1), (b1), (c1) (production basic information identification number) for identifying them and a start date input area Enter their start date (April 1, 2007). On April 1, the end dates of (A1), article (B1), article (C1), article (D1), part (a1), part (b1), and part (c1) are not fixed. The end date is not entered in the end date input area.

  The computer 11 refers to the basic production information item, basic production information, and data classification number stored in the storage device or the hard disk, and refers to the article (A1), article (B1), article (C1), article (D1), part ( It is determined that a1), part (b1), and part (c1) are items in the basic production information items, and an item data category (PC001) is set for them. The computer 11 includes an article (A1), an article (B1), an article (C1), an article (D1), a part (a1), a part (b1), a part (c1) and an item data classification (PC001), a product number (* , Φ), product number (A1), (B1), (C1), (D1), (a1), (b1), (c1), start date (April 1, 2007) and end date (-) Store in the item master 14. The basic production information of the article includes the name of the article (A1), the article (B1), the article (C1), the article (D), the usage instruction, the durability, and the like. a1), part (b1), name of part (c1), instructions for use, durable years, and the like.

  On April 30, the part (c1) is deleted from the item master 14, and the part (d1) is added. When the basic production information master is selected and information modification is selected, a plurality of various basic production information items are displayed on the display. When you select an item from the basic production information item, the display shows the pre-change item input area, post-change item input area, deleted item input area, added item input area, changed added item start date input area, and changed added item end The day input area is displayed. The part (c1) and its product number (*, φ) and the product number (c1) for specifying the part (c1) and its product number (c1) are input to the deleted item input area by the input device, and the part (d1) and its product number (*) are entered in the additional item input area. ), And the part number (d1) for specifying it and the start date (April 1, 2007) of the part (d1) are input in the start date input area.

  The computer 11 deletes the item information regarding the part (c1) from the item master 14, and adds the item information regarding the part (d1) to the item master 14. The computer 11 determines that the part (d1) is an item in the basic production information item, and sets the item data classification (PC001) to it. The computer 11 stores the part (d1), item data classification (PC001), product number (*), product number (d1), start date (April 1, 2007), and end date (-) in the item master 14. . The basic production information of a part includes the name of the part (d1), the usage description, the durable years, and the like.

  On July 1, the generation of the article (A1), the article (B1), the article (C1), the part (a1), the part (b1), and the part (d1) is completed, and the item information is the article (A2), the article (B2), article (C2), part (a2), part (b2), and part (d2) are changed generations. The generation is a division of basic production information from the disclosure date (start time) to the end date (end time), and one generation of basic production information is from the disclosure date to the end date. An example of the generation change procedure will be described as follows. When the basic production information master is selected on the display and the information generation setting is selected, various basic production information items are displayed on the display. When an item is selected from the basic production information items, the display shows an item input area, a start date input area, and an end date input area, as well as an end target item input area and an end target item end date input area. .

  Article (A2), article (B2), article (C2), part (a2), part (b2), part (d2) and their product number (*), and their product number (*) are specified in the item input area by the input device. (A2), (B2), (C2), (a2), (b2), (d2) are input, and their start dates (July 1, 2007) are input in the start date input area. Further, the article (A1), the article (B1), the article (C1), the part (a1), the part (b1), the part (d1), and their production number (*) are specified in the end target item input area. Enter the product number (A1), (B1), (C1), (a1), (b1), (d1), and enter the end date (June 30, 2007) in the end target item end date input area To do. On July 1, the end date of the article (A2), the article (B2), the article (C2), the part (a2), the part (b2), and the part (d2) has not been determined, so the end date is entered. No end date is entered in the area. The article (A1), the article (B1), the article (C1), the part (a1), the part (b1), and the part (d1) form an integrated bill of materials on June 30, 2007 depending on the end date setting. Depart from basic production information (withdrawal).

  The computer 11 refers to the basic production information item, basic production information, and data classification number stored in the storage device or the hard disk, and the article (A2), article (B2), article (C2), part (a2), part ( b2) It is determined that the part (d2) is an item in the basic production information items, and an item data classification (PC001) is set for them. The computer 11 includes an article (A2), an article (B2), an article (C2), a part (a2), a part (b2), a part (d2) and an item data classification (PC001), a product number (*), and a part number (A2). ), (B2), (C2), (a2), (b2), (d2), the start date (July 1, 2007), and the end date (−) are stored in the item master 14. The basic production information of the article includes the name of the article (A2), the article (B2), the article (C2), the usage description, the durability, and the like. The basic production information of the part includes the part (a2), the part ( b2), the name of the component (d2), the usage description, the durable years, etc. are included.

  FIG. 4 is a diagram showing an example of various pieces of base information (production basic information) stored in the base master 15 (production basic information master 12). The base information of the base (α1) and the base (β1) is information as of April 1, 2007, and the base information of the base (β2) is information as of July 1, 2007. After selecting the production basic information master and selecting a new setting, when selecting a base from the basic production information item, the display shows the base input area, the start date input area that is the formation point of the integrated bill of materials for the base information, An end date input area that is the point of departure from the integrated parts table of the base information is displayed. The base (α1), the product number (*, φ), and the product number (α1) for specifying the base (α1) are input to the base input area by the input device, and the start date (April 1, 2007) is input to the start date input area. ).

  The computer 11 determines that the base (α1) is the base in the basic production information item, and sets the base data classification (PC002) thereto. The computer 11 stores the base (α1), the base data classification (PC002), the product number (*, φ), the product number (α1), the start date (April 1, 2007), and the end date (−) in the base master 15. Store. The basic production information of the base includes the name, address, guide map and the like of the base (α1).

  On April 30, the base (α1) is changed to the base (β1). After selecting the production basic information master and selecting information modification, if you select a base from the production basic information item, the base input area before change, the base input area after change, the deleted base input area, the additional base input area The start date input area of the change addition base and the end date input area of the change addition base are displayed. The base (α1) and its product number (*, φ) and the product number (α1) for specifying the base (α1) and the product number (α1) are entered into the base input area before change by the input device, and the base (β1) and the product number are entered in the post-change base input area. (*) Enter the product number (β1) that identifies it and the start date (April 1, 2007) of the base (β1) in the start date input area.

  The computer 11 changes the base information related to the base (α1) to the base information related to the base (β1). The computer 11 determines that the base (β1) is the base in the basic production information item, and sets the base data classification (PC002) thereto. The computer 11 stores the base (β1), the base data classification (PC002), the product number (*), the product number (β1), the start date (April 1, 2007), and the end date (−) in the base master 15. . The basic production information of the base includes the name, address, guide map, and the like of the base (β1).

  On July 1, the generation of the base (β1) has ended, and the base information has been changed to the base (β2). After selecting the production basic information master and selecting the information generation setting, if you select a base from the basic production information item, the display will show the base input area, start date input area, and end date input area. The target base input area and the end target base end date input area are displayed. Enter the base (β2) and its product number (*) and the part number (β2) that identifies it in the base input area using the input device, and enter the start date (July 1, 2007) in the start date input area. To do. Further, the base (β1), its product number (*), and the product number (β1) for specifying the base (β1) are input in the end target base input area, and the end date (June 30, 2007) is input in the end target base end date input area. Day). On July 1, since the end date of the base (β2) is not fixed, the end date is not input in the end date input area. The base (β1) is excluded from the basic production information that forms the integrated parts table on June 30, 2007 by setting the end date.

  The computer 11 determines that the base (β2) is the base in the basic production information item, and sets the base data classification (PC002) thereto. The computer 11 stores the base (β2), the base data classification (PC002), the product number (*), the product number (β2), the start date (July 1, 2007), and the end date (−) in the base master 15. . The basic production information of the base includes the name, address, guide map, and the like of the base (β2).

  FIG. 5 is a diagram showing an example of various pieces of process information (production basic information) stored in the process master 16 (production basic information master 12). In addition, each process information of a process (L1) and a process (M1) is information on April 1, 2007, and the base information of a process (M2) is information on July 1, 2007. After selecting the production basic information master and selecting a new setting, when selecting a process from the production basic information item, the display shows a process input area, a start date input area that is the formation point of the integrated bill of materials for the process information, An end date input area that is the point of departure from the integrated parts table of process information is displayed. The process (L1) and its manufacturing number (*, φ) and the product number (L1) for specifying the process (L1) are input to the process input area by the input device, and the start date (April 1, 2007) is input to the start date input area. ).

  The computer 11 determines that the process (L1) is a process in the basic production information item, and sets a process data category (PC003) to it. The computer 11 stores the process (L1), process data classification (PC003), product number (*, φ), product number (L), start date (April 1, 2007) and end date (-) in the process master 16. Store. The production basic information of the process includes details of the process (L1), process drawings, process descriptions, and the like.

  On April 30, the process (L1) is changed to the process (M1). After selecting the basic production information master and selecting information modification, when selecting a process from the basic production information item, the display shows the pre-change process input area, post-change process input area, deletion process input area, and additional process input area. The start date input area for the change addition process and the end date input area for the change addition process are displayed. The base (L1) and its product number (*, φ) and the product number (L1) for specifying the base (L1) and the product number (L1) are input to the pre-change process input area by the input device, and the process (M1) and the product number are entered in the post-change process input area. (*) Enter the product number (M1) for specifying it and the start date (April 1, 2007) of the process (M1) in the start date input area.

  The computer 11 changes information related to the process (L1) to information related to the process (M1). The computer 11 determines that the process (M1) is a process in the basic production information item, and sets a process data classification (PC003) to it. The computer 11 stores the process (M1), process data classification (PC003), product number (*), product number (M1), start date (April 1, 2007), and end date (-) in the process master 16. . The production basic information of the process includes details of the process (M1), process drawings, process descriptions, and the like.

  On July 1, the generation of the process (M1) is completed, and the process information is changed to the generation of the process (M2). After selecting the production basic information master and selecting the information generation setting, if you select a process from the production basic information item, the process input area, start date input area and end date input area will be displayed on the display, and the end A target process input area and an end target process end date input area are displayed. Enter the process (M2) and its product number (*) and the product number (M2) that identifies it in the process input area using the input device, and enter the start date (July 1, 2007) in the start date input area. To do. Furthermore, the process (M1), its manufacturing number (*), and the product number (M1) for specifying the process (M1) are input to the end target base input area, and the end date (June 30, 2007) is input to the end target base end date input area. Day). On July 1, since the end date of the process (M2) is not fixed, the end date is not input in the end date input area. The process (M1) deviates from the basic production information forming the integrated parts table on June 30, 2007 by setting the end date.

  The computer 11 determines that the process (M2) is a process in the basic production information item, and sets the base data classification (PC003) to it. The computer 11 stores the process (M2), the base data classification (PC003), the product number (*), the product number (M2), the start date (July 1, 2007), and the end date (-) in the process master 16. . The production basic information of the process includes details of the process (M2), process drawings, process descriptions, and the like.

  6 to 9 are diagrams illustrating an example of a binary relationship and a ternary relationship between the basic production information stored in the configuration master 13. The configuration master 13 stores a binary relationship (parent-child relationship) and a ternary relationship (parent, intermediate, child relationship). Based on the binary relationship, second production basic information (child production basic information) is specified from the first production basic information (parent production basic information), and first production basic information is specified from the second production basic information. Based on the three-term relationship, second production basic information (intermediate production basic information) is identified from the first production basic information (parent production basic information), and third production basic information (child production basics) is determined from the first and second production basic information. Information) is identified. Here, when the ternary relation is converted into the binary relation, the second basic production information (intermediate production basic information) in the three-term relation becomes the second basic production information (child production basic information) in the binary relation. In other words, the child production basic information related to two terms becomes the intermediate production basic information related to three terms.

  On April 1, 2007, the binary relationship between the articles (A1), (B1), (C1) and the base (α1), the articles (A1), (B1), (C1) and the base (α1) Three-term relationship with step (L1), three-term relationship between articles (A1), (B1), (C1), base (α1), and part (a1), articles (A1), (B1), (C1) And the three-term relationship between the base (α1) and the part (b1) and the three-term relationship between the articles (A1), (B1), (C1), the base (α1), and the part (c1) are stored in the configuration master 13. The Further, a binary relationship between the article (D1) and the base (α1), a three-term relation between the article (D1), the base (α1), and the step (L1), an article (D1), the base (α1), and a part (a1). ), A three-term relationship between the article (D1), the base (α1), and the part (b1), and a three-term relation between the article (D1), the base (α1), and the part (c1). Stored in

  On April 30, 2007, the binary relationship and the ternary relationship were changed, whereby the binary relationship between the article (A1), (B1), (C1) and the base (β1), the article (A1) , (B1), (C1), the base (β1) and the step (M1), the three-term relationship, the article (A1), (B1), (C1), the base (β1) and the part (a1) Relationship, article (A1), (B1), (C1) and base (β1) and part (b1), ternary relation, article (A1), (B1), (C1), base (β1) and part ( The ternary relationship with d1) is stored in the configuration master 13.

  An example of a procedure for storing the binary relation and the ternary relation between the basic production information in the configuration master 13 will be described based on FIGS. When the configuration master is selected from the selection screen displayed on the display of the computer 11 and the relation setting is selected, the two-term relation input area (1) to the two-term relation input area (n) and the three-term relation input area are displayed on the display. (1) to the item 3 related input area (n) are displayed.

  The article (A1), the parent product number (*), and the parent article number (A1) for specifying the article (A1) are input to the parent information (first production basic information) input area in the binary relation input area (1) by the input device. . The base (α1), the child product number (*, φ), and the product number (α1) for identifying the base (α1) are input to the child information (second production basic information) input area in the binary relation input area (1). Further, a binary relation start date (April 1, 2007) is input to the relation start date (relation start time) input area corresponding to the binary relation input area (1). On April 1st, the end date of those binary relations is not fixed, so the end date is not entered in the relationship end date (relation end time) input area.

  The computer 11 refers to the production basic information item, production basic information, and data division number stored in the storage device or the hard disk, sets the item data division (PC001) as the parent data division to the article (A1), and sets the child data. The base data classification (PC002) as the classification is set to the base (α1). When the information regarding the binary relation is input, the computer 11 stores the information in the configuration master 13. In the configuration master 13, the article (A1) and the base (α1) are linked, and they are linked based on the binary relationship.

  Input the article (A1), the parent product number (*), and the product number (A1) for specifying the article (A1) in the parent information (first production basic information) input area in the three-item relationship input area (1) by the input device, The base (α1), the intermediate product number (*, φ), and the product number (α1) for identifying the base (α1) are input to the intermediate information (second production basic information) input area in the three-term relationship input area (1). Furthermore, the process (L1), the child product number (*, φ), and the product number (L1) for specifying the process (L1) are input to the child information (third production basic information) input area in the three-term relationship input area (1). The start date (April 1, 2007) of the ternary relationship is entered in the relationship start date (relation start time) input area corresponding to the ternary relationship input area (1). On April 1st, the end dates of those three terms are not fixed, and therefore no end date is entered in the relationship end date (relation end point) input area.

  The computer 11 sets the item data category (PC001) as the parent data category to the article (A1), sets the base data category (PC002) as the intermediate data category to the base (α1), and sets the item data category (PC001) as the child data category. The process data classification (PC003) is set to the process (L1). When information related to the ternary relationship is input, the computer 11 stores the information in the configuration master 13. In the configuration master 13, the article (A1), the base (α1), and the process (L1) are linked, and they are linked based on the three-term relationship.

  The input device inputs the article (A1), the parent product number (*), and the product number (A1) for specifying the article (A1) in the parent information input area of the three-term relation input area (2). ) In the intermediate information input area, the base (α1), the intermediate product number (*, φ), and the product number (α1) for specifying it are input. Further, the part (a1), the child product number (*, φ), and the product number (a1) for specifying the part (a1) are input into the child information input area of the ternary relation input area (1). The start date (April 1, 2007) of the three-term relationship is input in the relationship start date input area corresponding to 2).

  The computer 11 sets the item data category (PC001) as the parent data category to the article (A1), sets the base data category (PC002) as the intermediate data category to the base (α1), and sets the item data category (PC001) as the child data category. The item data classification (PC001) is set to the part (a1). In the configuration master 13, the article (A1), the base (α1), and the part (a1) are linked, and they are linked based on the three-term relationship.

  The article (A1), the parent product number (*), and the product number (A1) for specifying the article (A1) are input to the parent information input area in the ternary relation input area (3) by the input device. ) In the intermediate information input area, the base (α1), the intermediate product number (*, φ), and the product number (α1) for specifying it are input. Further, the part (b1), the child product number (*, φ), and the product number (b1) for specifying the part (b1) are input to the child information input area of the three-term relation input area (1). In the relationship start date input area corresponding to 3), the start date (April 1, 2007) of the ternary relationship is input.

  The computer 11 sets the item data category (PC001) as the parent data category to the article (A1), sets the base data category (PC002) as the intermediate data category to the base (α1), and sets the item data category (PC001) as the child data category. The item data classification (PC001) is set to the part (b1). In the configuration master 13, the article (A1), the base (α1), and the part (b1) are linked, and they are linked based on the three-term relationship.

  The article (A1), the parent product number (*), and the article number (A1) for specifying the article (A1) are input to the parent information input area in the ternary relation input area (4) by the input device. ), The base (α1), the intermediate product number (*, φ), and the product number (α1) for identifying the base (α1) are input. Further, the component (c1), the child product number (*, φ), and the product number (c1) for specifying the component (c1) are input to the child information input area of the three-term relationship input area (1). In the relationship start date input area corresponding to 4), the start date (April 1, 2007) of the ternary relationship is input.

  The computer 11 sets the item data category (PC001) as the parent data category to the article (A1), sets the base data category (PC002) as the intermediate data category to the base (α1), and sets the item data category (PC001) as the child data category. The item data classification (PC001) is set to the part (c1). In the configuration master 13, the article (A1), the base (α1), and the part (c1) are linked, and they are linked based on the three-term relationship.

  When the configuration master is selected from the selection screen displayed on the display of the computer 11 and the relation sharing is selected, the sharing source production basic information input area, the sharing source parent product number input area, the sharing source parent product number input area, A shared production basic information input area, a shared parent product number input area, and a shared parent product number input area are displayed. Enter the product (A1) in the common source production basic information input area, the product number (*) in the common source parent product number input area, and the product number (A1) in the common source parent product number input area. Enter the item (B1), the item (C1) in the information input area, the product number (*) in the shared parent product number input area, the (B1), (C1) in the shared parent product number input area, and click the share button To do.

  When the share button is clicked, the computer 11 refers to the parent product number (*) and configures the two-item relationship and the three-item relationship of the basic production information in which the intermediate product number (*) and the child product number (*) are set. The binary and ternary relationships similar to those of the article (A1) are extracted from the master and applied to the articles (B1) and (C1) (relationship sharing means, relationship sharing process). The computer 11 includes a binary relationship between the article (B1) and the base (α1), a three-term relation between the article (B1), the base (α1), and the process (L1), and an article (B1), the base (α1), and a part. The three-term relationship between (a1), the three-term relationship between the article (B1), the base (α1), and the part (b1), and the three-term relation between the article (B1), the base (α1), and the part (c1). Store in the master 13. Further, a binary relationship between the article (C1) and the base (α1), a three-term relation between the article (C1), the base (α1), and the process (L1), an article (C1), the base (α1), and a part (a1). ), A three-term relationship between the article (C1), the base (α1), and the part (b1), and a three-term relation between the article (C1), the base (α1), and the part (c1). To store. In the configuration master 13, as shown in FIG. 6, the article (A1) and the articles (B1) and (C1) share the binary and ternary relationships of the article (A1).

  After the shared processing is performed, in the configuration master 13, the articles (A1), (B1), (C1) and the base (α1) are linked, and they are linked based on the binary relationship, and the article (A1 ), (B1), (C1), the base (α1), and the step (L1) are linked, and they are linked based on the three-term relationship. The articles (A1), (B1), (C1), the base (α1), and the part (a1) are linked to each other based on the three-term relationship, and the articles (A1), (B1), (C1) ), The base (α1), and the component (b1) are linked to each other based on the three-term relationship. The articles (A1), (B1), (C1), the base (α1), and the part (c1) are linked, and they are linked based on the three-term relationship.

  The integrated parts table creation system 10 and the integrated parts table creation method are used for articles (B1) and (C1) (other articles) among the two-term relation and the three-term relation of the article (A1) (predetermined article). Applicable binary and ternary relationships are shared between article (A1) and article (B1), (C1), and common binary or ternary relations are shared between article (A1) and article (B1), ( C1) is centrally applied, so there is no need to set a common binary or ternary relationship separately for article (A1) and article (B1), (C1). A table can be created efficiently.

  When the configuration master is selected from the selection screen displayed on the display of the computer 11 and the related diversion is selected, the diversion source production basic information input area, the diversion source parent product number input area, the diversion source parent product number input area, The diversion destination production basic information input area, the diversion destination parent product number input area, and the diversion destination parent product number input area are displayed. Enter the product (A1) in the diversion source production basic information input area, the production number (*) in the diversion source parent product number input area, and the product number (A1) in the diversion source parent product number input area by the input device. Enter the article (D1) in the information input area, the product number (φ) in the diversion destination parent product number input area, and (D1) in the diversion destination parent product number input area, and click the diversion button.

  When the diversion button is clicked, the computer 11 refers to the parent product number (φ) and configures the two-term relationship and the three-term relationship of the basic production information in which the intermediate product number (φ) and the child product number (φ) are set. The two-term relationship and the three-term relationship similar to those of the article (A1) are extracted from the master and used for the article (D1) (related diversion means, relation diversion process). The computer 11 includes a binary relationship between the article (D1) and the base (α1), a three-term relation between the article (D1), the base (α1), and the process (L1), and an article (D1), the base (α1), and a part. A three-term relationship with (a1), a three-term relationship with article (D1), base (α1), and part (b1), and a three-term relation with article (D1), base (α1), and part (c1) Store in the master 13. In the configuration master 13, as shown in FIG. 7, the article (D1) diverts the binary and ternary relations of the article (A1).

  After the diversion processing is performed, in the configuration master 13, the article (D1) and the base (α1) are linked, and they are linked based on the binary relationship, and the article (D1), the base (α1), and the process (L1) is linked and they are linked based on the ternary relationship. The article (D1), the base (α1), and the part (a1) are linked to each other based on the three-term relationship, and the article (D1), the base (α1), and the part (b1) are linked to each other. They are linked based on the ternary relationship. The article (D1), the base (α1), and the part (c1) are associated with each other based on the three-term relationship. The integrated parts table creation system 10 and the integrated parts table creation method can be diverted to the article (d1) (other articles) out of the two-term relation and the three-term relation of the article (A1) (predetermined article). Since the item relation and the ternary relation are diverted from the article (A1) to the article (d1), there is no need to newly set the two-term relation or the three-term relation in the article (d1), and the integrated parts table of various articles is displayed. Can be created efficiently.

  Here, the relation between the binary relation and the ternary relation, taking as an example the binary relation between the article (A1) and the base (α1) and the ternary relation between the article (A1), the base (α1), and the process (L1). Is described as follows. Of the binary relationship between the article (A1) and the base (α1), the base (α1) which is the second production basic information (child production basic information) is the article (A1), the base (α1), the process (L1), The second production basic information (intermediate production basic information) in the three-term relationship. Thereby, not only the connection between the article (A1) and the base (α1) but also the connection between the base (α1) and the process (L1) is determined, and the process (L1) is determined by the article (A1) and the base (α1). Is confirmed. Therefore, in the two-term relationship between the article (A1) and the base (α1) and the three-term relation between the article (A1), the base (α1) and the process (L1), the combination of basic production information other than the process (L1) is It is excluded (see FIG. 6).

  On April 30, 2007, in the basic production information, the base (α1) is changed to the base (β1), the process (L1) is changed to the process (M1), and the part (c1) is further deleted. , A part (d1) is added. As a result, the binary and ternary relationships stored in the configuration master 13 are changed. When the configuration master is selected and the relationship change is selected, the display of the computer 11 has two-term relationship change input area (1) to two-term relationship change input area (n) and three-term relationship change input areas (1) to three. A term relation change input area (n) is displayed.

  The article (A1), its parent product number (*), and the article number (A1) for specifying it are input to the parent information (first production basic information) input area in the binary relation change input area (1) by the input device. Then, the base (β1), the child product number (*), and the product number (β1) for identifying the base (β1) are entered in the child information (second production basic information) input area. The start date (April 1, 2007) of the changed binary relationship is input to the relationship start date input area corresponding to the binary relationship change input area (1). Further, the article (A1), its parent product number (*), and the article number (A1) for specifying the article (A1) are input to the pre-change parent information input area in the binary relation change input area (1), and the pre-change child information. In the input area, the base (α1), its child product number (*), and the product number (α1) that identifies it are entered.

  The computer 11 sets the item data category (PC001) as the parent data category to the article (A1), and sets the base data category (PC002) as the child data category to the base (β1). When the information regarding the change of the binary relation is input, the computer 11 stores the information in the configuration master 13. In the configuration master 13, the article (A1) and the base (β1) are linked, and they are linked based on the binary relationship.

  Enter the item (A1), its parent product number (*), and the product number (A1) that identifies it in the parent information (first production basic information) input area in the three-item relationship change input area (1) In the information (second production basic information) input area, the base (β1) and its child product number (*) and the product number (β1) for identifying the base (β1) are entered, and in the child information (third production basic information) input area, the process ( M1), its child product number (*), and the product number (M1) that identifies it. The start date (April 1, 2007) after the change is input to the relationship start date input area corresponding to the ternary relationship change input area (1). Further, the article (A1), its parent product number (*), and the article number (A1) for identifying the article (A1) are input to the pre-change parent information input area in the three-term relationship change input area (1), and the pre-change intermediate information The base (α1) and its child product number (*, φ) and the product number (α1) for specifying it are input in the input area, and the process (L1) and its child product number (*, φ) are entered in the pre-change child information input area. , The product number (L1) for specifying it is input.

  The computer 11 sets the item data category (PC001) as the parent data category to the article (A1), sets the base data category (PC002) as the intermediate data category to the base (β1), and sets the item data category (PC001) as the child data category. The process data classification (PC003) is set to the process (M1). When information related to the change in the ternary relationship is input, the computer 11 stores the information in the configuration master 13. In the configuration master 13, the article (A1), the base (β1), and the process (M1) are linked, and they are linked based on the three-term relationship.

  The article (A1), its parent product number (*), and the product number (A1) for identifying the article (A1) are input in the parent information input area of the three-term relationship change input area (2), and the base (β1 ), Its child product number (*), and the product number (β1) that identifies it, and the part (a1), its child product number (*), and the product number (a1) that identifies it are entered in the child information input area. . In the relationship start date input area corresponding to the ternary relationship change input area (2), the changed ternary relationship start date (April 1, 2007) is input. Further, the article (A1), its parent product number (*), and the article number (A1) for specifying the article (A1) are input to the parent information input area before change in the three-part relationship change input area (2), and the intermediate information before change is entered. The base (α1) and its child product number (*, φ) and the product number (α1) that identifies it are entered in the input area, and the part (a1) and its child product number (*, φ) in the pre-change child information input area , The product number (a1) for specifying it is input.

  The computer 11 sets the item data category (PC001) as the parent data category to the article (A1), sets the base data category (PC002) as the intermediate data category to the base (β1), and sets the item data category (PC001) as the child data category. The item data classification (PC001) is set to the part (a1). In the configuration master 13, the article (A1), the base (β1), and the part (a1) are linked, and they are linked based on the three-term relationship.

  The article (A1), its parent product number (*), and the product number (A1) for identifying the article (A1) are input in the parent information input area of the three-term relationship change input area (3), and the base (β1 ) And its child product number (*), and the product number (β1) that identifies it, and the part (b1), its child product number (*), and the product number (b1) that identifies it are entered in the child information input area. . The start date (April 1, 2007) after the change is input to the relationship start date input area corresponding to the ternary relationship change input area (3). Further, the article (A1), its parent product number (*), and the article number (A1) for identifying the article (A1) are input to the pre-change parent information input area in the three-term relationship change input area (3), and the pre-change intermediate information The base (α1) and its child product number (*, φ) and the product number (α1) that identifies it are entered in the input area, and the part (b1) and its child product number (*, φ) in the pre-change child information input area , The product number (b1) for specifying it is input.

  The computer 11 sets the item data category (PC001) as the parent data category to the article (A1), sets the base data category (PC002) as the intermediate data category to the base (β1), and sets the item data category (PC001) as the child data category. The item data classification (PC001) is set to the part (b1). In the configuration master 13, the article (A1), the base (β1), and the part (b1) are linked, and they are linked based on the three-term relationship.

  The article (A1), its parent product number (*), and the product number (A1) for identifying the article (A1) are input to the parent information input area of the three-term relationship change input area (4), and the base (β1) is input to the intermediate information input area. ) And its child product number (*), and the product number (β1) that identifies it, and the part (d1), its child product number (*), and the product number (d1) that identifies it are entered in the child information input area. . In the relationship start date input area corresponding to the ternary relationship change input area (4), the changed ternary relationship start date (April 1, 2007) is input. Further, the article (A1), its parent product number (*), and the article number (A1) for specifying the article (A1) are input to the pre-change parent information input area in the three-term relationship change input area (4), and the pre-change intermediate information The base (α1) and its child product number (*, φ) and the product number (α1) for identifying the base (α1) are entered in the input area, and the part (c1) and its child product number (*, φ) are entered in the pre-change child information input area. , The product number (c1) that identifies it is input.

  The computer 11 sets the item data category (PC001) as the parent data category to the article (A1), sets the base data category (PC002) as the intermediate data category to the base (β1), and sets the item data category (PC001) as the child data category. The item data classification (PC001) is set to the part (d1). In the configuration master 13, the article (A1), the base (β1), and the part (d1) are linked, and they are linked based on the three-term relationship.

  When the configuration master is selected from the selection screen displayed on the display of the computer 11 and the relation sharing is selected, the sharing source production basic information input area, the sharing source parent product number input area, the sharing source parent product number input area, A shared production basic information input area, a shared parent product number input area, and a shared parent product number input area are displayed. Enter the product (A1) in the common source production basic information input area, the product number (*) in the common source parent product number input area, and the product number (A1) in the common source parent product number input area. Enter the item (B1), the item (C1) in the information input area, the product number (*) in the shared parent product number input area, the (B1), (C1) in the shared parent product number input area, and click the share button To do.

  When the share button is clicked, the computer 11 refers to the parent product number (*) and configures the two-item relationship and the three-item relationship of the basic production information in which the intermediate product number (*) and the child product number (*) are set. The binary and ternary relationships similar to those of the article (A1) are extracted from the master and applied to the articles (B1) and (C1) (relationship sharing means, relationship sharing process). The computer 11 includes a binary relationship between the article (B1) and the base (β1), a three-term relation between the article (B1), the base (β1), and the process (M1), and an article (B1), the base (β1), and a part. A three-term relationship with (a1), a three-term relationship with article (B1), base (β1), and part (b1), and a three-term relation with article (B1), base (β1), and part (D1) Store in the master 13. Further, a binary relationship between the article (C1) and the base (β1), a three-term relation between the article (C1), the base (β1), and the process (M1), an article (C1), the base (β1), and a part (a1). ), The three-term relationship between the article (C1), the base (β1), and the part (b1), and the three-term relation between the article (C1), the base (β1), and the part (D1). To store. In the configuration master 13, the article (A1) and the articles (B1) and (C1) share the binary and ternary relationships of the article (A1) as shown in FIG.

  After the shared processing is performed, in the configuration master 13, the articles (A1), (B1), (C1) and the base (β1) are linked, and they are linked based on the binary relationship, and the article (A1 ), (B1), (C1), the base (β1), and the step (M1) are linked, and they are linked based on the three-term relationship. The articles (A1), (B1), (C1), the base (β1), and the part (a1) are linked to each other based on the three-term relationship, and the articles (A1), (B1), (C1) ), The base (β1), and the component (b1) are linked to each other based on the three-term relationship. Articles (A1), (B1), (C1), a base (β1), and a part (D1) are linked, and they are linked based on a three-term relationship.

  In the integrated parts table creation system 10 and the integrated parts table creation method, the base (α1) forming the binary relation and the tertiary relation of the article (A1) (predetermined article) is changed to the base (β1), and the process ( When L1) is changed to the step (M1), the changed base (β1), the two-term relationship including the step (M1) and the three-term relationship are changed to the article (A1) (predetermined article) and the article (B1), ( C1) The article (A1) and the articles (B1) and (C1) of the two-term relation and the three-term relation including the changed basic production information are shared with the (other goods), and the goods have a common relation to the goods (B1) and (C1). Since it is applied centrally to (A1), (B1), and (C1), it is necessary to set a common binary or ternary relationship separately for article (A1) and article (B1), (C1). Therefore, it is possible to efficiently create an integrated parts list for various articles.

  When the part (d1) is added to the three-part relationship of the article (A1) (predetermined article), the integrated parts table creation system 10 and the integrated parts table creation method include three items including the added component (d1). The article (A1) (predetermined article) and the article (B1), (C1) (other article) share the relationship, and the article (A1) and the article (3) including the added part (d1) B1) and (C1) are applied in a unified manner to the articles (A1), (B1), and (C1), and therefore the common three-term relation is applied to the articles (A1) and the articles (B1), ( C1) need not be set separately, and an integrated parts table for various articles can be created efficiently.

  The integrated parts table creation system 10 and the integrated parts table creation method exclude the deleted part (c1) when the part (c1) forming the ternary relationship of the article (A1) (predetermined article) is deleted. The article (A1) (predetermined article) and the article (B1), (C1) (other articles) are shared with the article (A1) (predetermined article), and the article (A1) in the article 3 relationship except for the deleted part (c1) Since the common relationship between the articles (B1) and (C1) is applied to the articles (A1), (B1), and (C1) in a unified manner, the common three-term relationship is applied to the articles (A1) and the articles (B1). , (C1) need not be set separately, and an integrated parts table of various articles can be efficiently created.

  On June 30, 2007, the generations of binary relations and ternary relations were changed. On June 30, 2007, the binary relationship between the article (A2) and the base (β2), the three-term relation between the article (A2), the base (β2), and the process (M2), the article (A2) and the base ( The three-term relationship between β2) and the part (a2), the three-term relationship between the article (A2), the base (β2), and the part (b2), and the three-term relation between the article (A2), the base (β2), and the part (d2). Stored in the configuration master. When the configuration master is selected and the related generation setting is selected, the display of the computer 11 displays the binary related generation input area (1) to the binary related generation input area (n) and the binary related generation input area (1) to A ternary related generation input area (n) is displayed.

  The article (A2), its product number (*), and the product number (A2) for identifying it are input to the parent information (first production basic information) input area in the binary relation generation input area (1) by the input device. In the child information (second production basic information) input area, the base (β2), its product number (*), and the product number (β2) that identifies it are input. The relation start date (relation start time) corresponding to the binary relation generation input area (1) is input to the new binary relation start date (July 1, 2007). Furthermore, the article (A1), its product number (*), and the product number (A1) for identifying the article (A1) are entered in the parent information input area of the termination target binary relation input area corresponding to the binary relation generation input area (1). Enter the base (β1), its product number (*), and the product number (β1) that identifies it in the child information input area, and the relationship end date (relationship end) corresponding to the binary relation generation input area (1) Time point) Enter the end date (June 30, 2007) of the binary relationship in the input area.

  The computer 11 sets the item data category (PC001) as the parent data category to the article (A2), and sets the base data category (PC002) as the child data category to the base (β2). When information relating to the binary relation generation is input, the computer 11 stores the information in the configuration master 13. In the configuration master 13, the article (A2) and the base (β2) are linked, and they are linked based on the binary relationship. The binary relationship between the article (A1) and the base (β1) deviates (leaves) from the binary relationship that forms the integrated bill of materials on June 30, 2007 by setting the end date.

  The article (A2), its product number (*), and the product number (A2) for specifying it are input to the parent information (first production basic information) input area in the three-term related generation input area (1) by the input device. In addition, in the intermediate information (second production basic information) input area, the base (β2), its product number (*), and the product number (β2) that identifies it are input, and in the child information (third production basic information) input area Enter the process (M2), its product number (*), and the product number (M2) that identifies it. The start date (July 1, 2007) of the new ternary relationship is input to the relationship start date (relation start time) input area corresponding to the ternary relationship generation input area (1).

  Further, the article (A1), its product number (*), and the product number (A1) for identifying the article (A1) are entered in the parent information input area of the termination target 3-term input area corresponding to the 3-term related generation input area (1). Enter the base (β1) and its product number (*) in the intermediate information input area, and the product number (β1) that identifies it, and the process (M1) and its product number (*), Enter the product number (M1) that identifies it. The ending date (June 30, 2007) of the ternary relationship is input to the relationship ending date (relation ending point) input area corresponding to the ternary related generation input area (1).

  The computer 11 sets the item data category (PC001) as the parent data category to the article (A2), sets the base data category (PC002) as the intermediate data category to the base (β2), and sets the item data category (PC002) as the child data category. The process data classification (PC003) is set to the process (M2). When the information related to the ternary generation is input, the computer 11 stores the information in the configuration master 13. In the configuration master 13, the article (A2), the base (β2), and the process (M2) are linked, and they are linked based on the three-term relationship. The three-term relationship among the article (A1), the base (β1), and the process (M1) deviates from the three-term relationship that forms an integrated parts table on June 30, 2007 by setting the end date.

  The article (A2), its product number (*), and the product number (A2) for specifying the article (A2) are input in the parent information input area of the three-term related generation input area (2), and the base (β2) is input in the intermediate information input area And the product number (*) and the product number (β2) for specifying the product number are entered, and the part (a2), the product number (*) and the product number (a2) for specifying the product are entered in the child information input area. A new ternary relation start date (July 1, 2007) is entered in the relation start date input area corresponding to the ternary relation generation input area (2).

  Further, the article (A1), its product number (*), and the product number (A1) for identifying the article (A1) are entered in the parent information input area of the termination target 3-term input area corresponding to the 3-term related generation input area (2). Enter the base (β1) and its product number (*) in the intermediate information input area, and the product number (β1) that identifies it, and the part (a1) and its product number (*), Enter the product number (a1) that identifies it. The end date (June 30, 2007) of the ternary relationship is input to the relationship end date input area corresponding to the ternary relationship generation input area (2).

  The computer 11 sets the item data category (PC001) as the parent data category to the article (A2), sets the site data category (PC002) as the intermediate data category to the site (β2), and sets the item data category (PC002) as the child data category. The item data classification (PC001) is set to the part (a2). In the configuration master 13, the article (A2), the base (β2), and the part (a2) are linked, and they are linked based on the three-term relationship. The three-term relationship among the article (A1), the base (β1), and the component (a1) deviates from the three-term relationship that forms an integrated bill of materials on June 30, 2007 by setting the end date.

  The article (A2) and its product number (*) and the product number (A2) for specifying the article (A2) are input to the parent information input area in the three-term related generation input area (3), and the base (β2) is input to the intermediate information input area. And the product number (* 2) and the product number (β2) for specifying the product number are entered, and the part (b2), the product number (*) and the product number (b2) for specifying the product (b2) are entered in the child information input area. A new ternary relation start date (July 1, 2007) is entered in the relation start date input area corresponding to the ternary relation generation input area (3).

  Furthermore, the article (A1), its product number (*), and the product number (A1) for identifying the article (A1) are entered in the parent information input area of the termination target 3-term input area corresponding to the 3-term related generation input area (3). Enter the base (β1) and its product number (*) in the intermediate information input area and the product number (β1) that identifies it, and also enter the part (b1) and its product number (*) in the child information input area. Enter the product number (b1) that identifies it. The end date (June 30, 2007) of the ternary relationship is input to the relationship end date input area corresponding to the ternary relationship generation input area (3).

  The computer 11 sets the item data category (PC001) as the parent data category to the article (A2), sets the base data category (PC002) as the intermediate data category to the base (β2), and sets the item data category (PC002) as the child data category. The item data classification (PC001) is set to the part (b2). In the configuration master 13, the article (A2), the base (β2), and the part (b2) are linked, and they are linked based on the three-term relationship. The three-term relationship among the article (A1), the base (β1), and the component (b1) deviates from the three-term relationship that forms the integrated bill of materials on June 30, 2007 by setting the end date.

  The article (A2), its product number (*), and the product number (A2) for specifying the article (A2) are input in the parent information input area of the three-term related generation input area (4), and the base (β2) is input in the intermediate information input area And the product number (* 2) and the product number (β2) for specifying the product number are entered, and the part (d2), the product number (*) and the product number (d2) for specifying the product (d2) are entered in the child information input area. A new ternary relation start date (July 1, 2007) is entered in the relation start date input area corresponding to the ternary relation generation input area (4).

  Further, the article (A1), its product number (*), and the product number (A1) for specifying the article (A1) are entered in the parent information input area of the termination target 3-term input area corresponding to the 3-term related generation input area (4). Enter the base (β1) and its product number (*) in the intermediate information input area, and the product number (β1) that identifies it, and the component (d1) and its product number (*), Enter the product number (d1) that identifies it. The ending date (June 30, 2007) of the ternary relationship is entered in the relationship end date input area corresponding to the ternary relationship generation input area (4).

  The computer 11 sets the item data category (PC001) as the parent data category to the article (A2), sets the base data category (PC002) as the intermediate data category to the base (β2), and sets the item data category (PC002) as the child data category. The item data classification (PC001) is set to the part (d2). In the configuration master 13, the article (A2), the base (β2), and the part (d2) are linked, and they are linked based on the three-term relationship. The three-term relationship among the article (A1), the base (β1), and the component (d1) deviates from the three-term relationship that forms the integrated bill of materials on June 30, 2007 by setting the end date.

  When the configuration master is selected from the selection screen displayed on the display of the computer 11 and the relation sharing is selected, the sharing source production basic information input area, the sharing source parent product number input area, the sharing source parent product number input area, A shared production basic information input area, a shared parent product number input area, and a shared parent product number input area are displayed. Enter the product (A2) in the common source production basic information input area, the product number (*) in the common source parent product number input area, and the product number (A2) in the common source parent product number input area. Enter the item (B2), the item (C2) in the information input area, the product number (*) in the shared parent product number input area, the (B2), (C2) in the shared parent product number input area, and click the share button To do.

  When the share button is clicked, the computer 11 refers to the parent product number (*) and configures the two-item relationship and the three-item relationship of the basic production information in which the intermediate product number (*) and the child product number (*) are set. The two-term relationship and the three-term relationship similar to those of the article (A2) are extracted from the master and applied to the articles (B2) and (C2) (relationship sharing means, relationship sharing process). The computer 11 includes a binary relationship between the article (B2) and the base (β2), a three-term relation between the article (B2), the base (β2), and the process (M2), and an article (B2), the base (β2), and a part. A three-term relationship with (a2), a three-term relationship between article (B2), base (β2), and part (b2), and a three-term relation between article (B2), base (β2), and part (d2) Store in the master 13. Further, a binary relationship between the article (C2) and the base (β2), a three-term relation between the article (C2), the base (β2), and the step (M2), an article (C2), the base (β2), and a part (a2). ), The three-term relationship between the article (C2), the base (β2), and the part (b2), and the three-term relation between the article (C2), the base (β2), and the part (d2). To store. In the configuration master 13, as shown in FIG. 9, the article (A2) and the articles (B2) and (C2) share the binary and ternary relationships of the article (A2).

  After the shared processing is performed, in the configuration master 13, the articles (A2), (B2), (C2) and the base (β2) are linked, and they are linked based on the binary relationship, and the article (A2 ), (B2), (C2), the base (β2), and the step (M2) are linked, and they are linked based on the three-term relationship. The articles (A2), (B2), (C2), the base (β2), and the part (a2) are linked to each other based on the three-term relationship, and the articles (A2), (B2), (C2 ), The base (β2), and the part (b2) are linked to each other based on the three-term relationship. The articles (A2), (B2), (C2), the base (β2), and the part (d2) are linked, and they are linked based on the three-term relationship.

  The integrated bill of materials creation system 10 and the integrated bill of materials creation method are as follows: when the generations of the binary and ternary relationships of the article (A1) (predetermined article) change, the binary and ternary relations in which the generations are changed The article (A1) (predetermined article) and the article (B1), (C1) (other article) are shared, and the article (A1) and the article (B1) of the two-term relationship and the three-term relationship in which generations are changed ) And (C1) are applied in a unified manner to the articles (A1), (B1), and (C1), and the common binary or ternary relation is applied to the articles (A1) and (B1). ) And (C1) need not be set separately, and an integrated parts table for various articles can be efficiently created.

  FIG. 10 is a diagram showing a list of the start date and the end date of each basic production information, and FIGS. 11 and 12 are explanatory diagrams for creating an integrated parts table on April 15. FIG. 13 is a diagram illustrating an example of the created integrated parts table. In FIG. 10, the period from April 1, 2007 to August 31, 2007 is shown. In this system 10, an integrated parts table at an arbitrary time point that goes back in the past can be created. When an instruction to create an integrated parts table is issued on the date specified by the input device, the computer 11 is designated from the configuration master 13 while referring to the start date and end date of the binary relation or the ternary relation. A plurality of various two-term relationships and a plurality of various three-term relationships in the date are extracted, and a plurality of various basic production information forming the two-term relationships and the three-term relationships are extracted from the production basic information master 12.

  The computer 11 refers to the parent data classification of the first production basic information and the child data classification of the second production basic information forming the binary relation, and determines the basic production information of the same data classification in the binary relation. The various binary relations extracted by combining are integrated. The computer 11 refers to the parent data classification of the first production basic information forming the binary relation and the child data classification of the second production basic information, and the parent data classification of the first production basic information forming the ternary relation. Extracted by referring to the intermediate data category of the 2nd production basic information and the child data category of the 3rd production basic information and combining the production basic information of the same data category of these binary relationships and ternary relationships Integrate various binary and ternary relationships. Further, the computer 11 refers to the parent data category of the first production basic information, the intermediate data category of the second production basic information, and the child data category of the third production basic information that form the ternary relationship. A plurality of three-term relationships extracted by combining basic production information of the same data section are integrated. In accordance with the integrated relationship, the computer 11 connects a plurality of various basic production information extracted from the basic production information master 12 from its superordinate concept to its subordinate concept, so that the integrated parts list of articles on a specified date is obtained. Create

  The creation of the integrated parts table on April 15 will be described as follows. When an instruction to create an integrated bill of materials is issued on April 15, 2007, the computer 11 refers to the start date and end date of the binary relationship and the tertiary relationship, and integrates as of April 15, 2007. The binary and ternary relationships that form the parts table are extracted from the configuration master 13. The computer 11 extracts the binary relation between the articles (A1), (B1), (C1) and the base (α1) from the configuration master 13. Further, the three-term relationship between the articles (A1), (B1), (C1), the base (α1), and the step (L1), the articles (A1), (B1), (C1), the base (α1), and the article ( ternary relationship with a1), ternary relationship between article (A1), (B1), (C1) and base (α1) and step (b1), article (A1), (B1), (C1) and base A ternary relationship between (α1) and step (c1) is extracted.

  The computer 11 reads the parent data classification (PC001) of the articles (A1), (B1), and (C1) into the item data classification (PC001), and the item data classification (A1), (B1), (C1) and the item data classification ( PC001), the articles (A1), (B1), and (C1) are extracted from the item master, the child data classification (PC002) of the base (α1) is read as the base data classification (PC002), and the article number (α1) And the base (α1) are extracted from the base master based on the base data classification (PC002). The child data classification (PC003) of the process (L1) is replaced with the process data classification (PC003), the process (L1) is extracted from the process master based on the product number (L1) and the process data classification (PC003), and the part (a1 ) Is read as the item data category (PC001), and the part (a1) is extracted from the item master based on the item number (a1) and the item data category (PC001).

  The computer 1111 replaces the child data classification (PC001) of the part (b1) with the item data classification (PC001), and extracts the part (b1) from the item master based on the item number (b1) and the item data classification (PC001). The child data class (PC001) of the part (c1) is replaced with the item data class (PC001), and the part (c1) is extracted from the item master based on the product number (c1) and the item data class (PC001).

  Among the extracted binary and ternary relationships, the computer 11 uses the same data items (PC001) and product numbers (A1), (B1), and (C1) as the articles (A1), (B1), and (C1). It is determined that the basic production information is common, and the base (α1) is determined as the same basic production information from the data classification (PC002) and the product number (α1). The computer 11 combines basic production basic information in the binary relation and the ternary relation. As a result, these binary relationships are integrated (binary relationship integration means, binary relationship integration process), these ternary relationships are integrated (ternary relationship integration means, ternary relationship integration process), and these binary terms The relations and these ternary relations are integrated (two-term three-term relation integration means, two-term three-term relation integration process).

  After integrating these relationships, the computer 11 incorporates the basic production information extracted from each master into the combined relationship, and an integrated parts table in which a plurality of various basic production information is connected in series from the higher concept to the lower concept. Create (integrated parts table creation means, (integrated parts table creation process)). In the created integrated parts table, as shown in FIG. 13, the base (α1) is located immediately below the articles (A1), (B1), and (C1), and the process ( L1), part (a1), part (b1), and part (c1) are positioned in parallel. The computer 11 stores the integrated parts table of the articles (A1), (B1), and (C1) created on April 15 in a storage device or a hard disk (integrated parts table storage means, integrated parts table storage process) ), And outputs the integrated parts table of the created articles (A1), (B1), and (C1) via the output device (integrated parts table output means, integrated parts table output process).

  FIG. 14 is an explanatory diagram of creating an integrated parts table on May 31, and FIG. 15 is a diagram showing another example of the created integrated parts table. The creation of the integrated bill of materials on May 31 is described as follows. When an instruction to create an integrated bill of materials as of May 31, 2007 is issued, the computer 11 refers to the start date and end date of the binary relation or the ternary relation and integrates as of May 31, 2007. The binary and ternary relationships that form the parts table are extracted from the configuration master 13.

  The computer 11 extracts the binary relationship between the articles (A1), (B1), (C1) and the base (β1) from the configuration master 13. Further, the three-term relationship between the articles (A1), (B1), (C1), the base (β1), and the process (M1), the articles (A1), (B1), (C1), the base (β1), and the article ( ternary relationship with a1), ternary relationship between article (A1), (B1), (C1) and base (β1) and step (b1), article (A1), (B1), (C1) and base A ternary relationship between (β1) and step (d1) is extracted.

  The computer 11 reads the parent data classification (PC001) of the articles (A1), (B1), and (C1) into the item data classification (PC001), and the item data classification (A1), (B1), (C1) and the item data classification ( PC001), the articles (A1), (B1), and (C1) are extracted from the item master, the child data classification (PC002) of the base (β1) is read as the base data classification (PC002), and the product number (β1) And the base (β1) are extracted from the base master based on the base data classification (PC002). The child data classification (PC003) of the process (M1) is replaced with the process data classification (PC003), the process (M1) is extracted from the process master based on the product number (M1) and the process data classification (PC003), and the part (a1 ) Is read as the item data category (PC001), and the part (a1) is extracted from the item master based on the item number (a1) and the item data category (PC001).

  The computer 1111 replaces the child data classification (PC001) of the part (b1) with the item data classification (PC001), and extracts the part (b1) from the item master based on the item number (b1) and the item data classification (PC001). The child data classification (PC001) of the part (d1) is replaced with the item data classification (PC001), and the part (d1) is extracted from the item master based on the product number (d1) and the item data classification (PC001).

  Of the extracted binary and ternary relationships, the computer 11 uses the same data item (PC001) and product numbers (A1), (B1), and (C1) as the articles (A1), (B1), and (C1). It is determined that the basic production information is common, and the base (β1) is determined as the same basic production information from the data classification (PC002) and the product number (β1). The computer 11 combines basic production basic information in the binary relation and the ternary relation. As a result, these binary relationships are integrated (binary relationship integration means, binary relationship integration process), these ternary relationships are integrated (ternary relationship integration means, ternary relationship integration process), and these binary terms The relations and these ternary relations are integrated (two-term three-term relation integration means, two-term three-term relation integration process).

  After integrating these relationships, the computer 11 incorporates the basic production information extracted from each master into the combined relationship, and an integrated parts table in which a plurality of various basic production information is connected in series from the higher concept to the lower concept. Create (integrated parts table creation means, (integrated parts table creation process)). In the created integrated parts table, as shown in FIG. 15, the base (β1) is located immediately below the articles (A1), (B1), and (C1), and the process ( M1), part (a1), part (b1), and part (d1) are positioned in parallel. The computer 11 stores the created integrated parts table of the articles (A1), (B1), and (C1) as of May 31 in a storage device or a hard disk (integrated parts table storage means, integrated parts table storage process) ), And outputs the integrated parts table of the created articles (A1), (B1), and (C1) via the output device (integrated parts table output means, integrated parts table output process).

  FIG. 16 is an explanatory diagram of creating an integrated parts table on August 31, and FIG. 17 is a diagram showing another example of the created integrated parts table. The creation of the integrated parts table on August 31 will be described as follows. When an instruction to create an integrated bill of materials as of August 31, 2007 is issued, the computer 11 refers to the start date and end date of the binary relation or the ternary relation and integrates as of August 31, 2007. The binary and ternary relationships that form the parts table are extracted from the configuration master 13.

  The computer 11 extracts the binary relationship between the article (A2), (B2), (C2) and the base (β2) from the configuration master 13. Further, the ternary relationship between the article (A2), (B2), (C2) and the base (β2) and the step (M2), the article (A2), (B2), (C2), the base (β2) and the part ( ternary relationship with a2), article (A2), (B2), (C2) and base (β2) and part (b2), ternary relationship, article (A2), (B2), (C2) and base The ternary relationship between (β2) and the part (d2) is extracted.

  The computer 11 replaces the parent data classification (PC001) of the articles (A2), (B2), and (C2) with the item data classification (PC001), and the item data classification (A2), (B2), (C2) and the item data classification ( PC001), the articles (A2), (B2), and (C2) are extracted from the item master, the child data classification (PC002) of the base (β2) is replaced with the base data classification (PC002), and the article number (β2) And the base (β2) are extracted from the base master based on the base data classification (PC002). The child data classification (PC003) of the process (M2) is replaced with the process data classification (PC003), the process (M2) is extracted from the process master based on the product number (M2) and the process data classification (PC003), and the part (a2 ) Is replaced with the item data category (PC001), and the part (a2) is extracted from the item master based on the item number (a2) and the item data category (PC001).

  The computer 1111 replaces the child data classification (PC001) of the part (b2) with the item data classification (PC001), and extracts the part (b2) from the item master based on the item number (b2) and the item data classification (PC001). The child data classification (PC001) of the part (d2) is replaced with the item data classification (PC001), and the part (d2) is extracted from the item master based on the product number (d2) and the item data classification (PC001).

  Of the extracted binary and ternary relationships, the computer 11 uses the same data items (PC001) and product numbers (A2), (B2), and (C2) as the articles (A2), (B2), and (C2). Based on the common production basic information, the base (β2) is determined to be the same common basic production information from the data classification (PC002) and the product number (β2). The computer 11 combines basic production basic information in the binary relation and the ternary relation. As a result, these binary relationships are integrated (binary relationship integration means, binary relationship integration process), these ternary relationships are integrated (ternary relationship integration means, ternary relationship integration process), and these binary terms The relations and these ternary relations are integrated (two-term three-term relation integration means, two-term three-term relation integration process).

  After integrating these relationships, the computer 11 incorporates the basic production information extracted from each master into the combined relationship, and an integrated parts table in which a plurality of various basic production information is connected in series from the higher concept to the lower concept. Create (integrated parts table creation means, (integrated parts table creation process)). In the created integrated parts table, as shown in FIG. 17, the base (β2) is positioned immediately below the articles (A2), (B2), and (C2), and the process ( M2), component (a2), component (b2), and component (d2) are positioned in parallel. The computer 11 stores the created integrated parts table of the articles (A2), (B2), and (C2) on August 31 in a storage device or a hard disk (integrated parts table storage means, integrated parts table storage process) ), And outputs the integrated parts table of the created articles (A2), (B2), and (C2) via the output device (integrated parts table output means, integrated parts table output process).

  The integrated parts table creation system 10 and the integrated parts table creation method can create an integrated parts table of articles formed from the basic production information, and item information, base information, process information, etc. of predetermined articles. It is possible to create an integrated bill of materials that can be grasped. The integrated BOM creation system 10 and the integrated BOM creation method are designed to manage basic information and binary relations by managing the production start information and the end dates for classifying generations of binary relations and ternary relations. The ternary relationship can be managed chronologically and by generation, and an integrated parts table of articles at any time in the past as well as the present can be created.

  The integrated bill of materials creation system 10 and the integrated bill of materials creation method integrate various plural binary relationships extracted from the configuration master 13, integrate various plural binary relationships extracted from the configuration master 13, and various Plural binary relations and ternary relations are integrated, and a plurality of various production basics extracted from the basic production information master 12 according to the integrated binary relations, the integrated ternary relations, the integrated binary relations and the ternary relations. Since the integrated parts table corresponding to each article is created by linking information from its superordinate concept to the subordinate concept, the binary relation formed from the first and second basic production information and the first to second By utilizing the ternary relationship formed from the three production basic information, it is possible to create a wide variety of integrated parts tables in which different types of production basic information are freely combined.

  When an integrated parts table is constructed based on only the binary relationship, a plurality of different second production basic information types are linked in the immediate lower order of the first basic production information, and a plurality of different integrated parts are associated with the same article. A table may be constructed, and an integrated parts table for each specific condition cannot be represented. However, the integrated parts table creation system 10 and the integrated parts table creation method add a ternary relation to a binary relation so that specific second production basic information is linked immediately below the first production basic information. At the same time, specific third production basic information is linked immediately below the second production basic information, and only the integrated parts table with specific conditions corresponding to various articles can be constructed using the basic production information.

  In the integrated bill of materials creation system 10 and the integrated bill of materials creation method, the basic production information start date is set as the production basic information bill of material formation time, and the basic production information as the departure date of the production basic information from the bill of material. In addition, the start date is set as the time of forming the BOM related to the second term and the third item, and the end date is set as the time when leaving the BOM related to the second item, the third item. Not only units but also time units (hours, minutes, seconds) can be set.

The schematic block diagram of the integrated components table | surface preparation system shown as an example. The figure which shows an example of the various some item information stored in the item master. The figure which shows an example of the various some item information stored in the item master. The figure which shows an example of the various some base information stored in the base master. The figure which shows an example of the various various process information stored in the process master. The figure which shows an example of 2 term relation and 3 term relation between production basic information stored in the composition master. The figure which shows an example of 2 term relation and 3 term relation between production basic information stored in the composition master. The figure which shows an example of 2 term relation and 3 term relation between production basic information stored in the composition master. The figure which shows an example of 2 term relation and 3 term relation between production basic information stored in the composition master. The figure which shows the list of the start date and end date of each production basic information. Explanatory drawing of integrated parts table creation on April 15. Explanatory drawing of integrated parts table creation on April 15. The figure which shows an example of the created integrated components table | surface. Explanatory drawing of integrated parts table creation on May 31. The figure which shows another example of the created integrated components table | surface. Explanatory drawing of creation of an integrated parts table on August 31. The figure which shows another example of the created integrated components table | surface.

Explanation of symbols

10 Integrated parts table creation system 11 Management computer 11
12 Production Basic Information Master 13 Configuration Master 14 Item Master 15 Base Master 16 Process Master

Claims (12)

In an integrated bill of materials creation system that creates an integrated bill of materials by linking various basic production information in series from the top to the bottom,
The basic production information is linked by a binary relationship between arbitrary first basic production information and second basic production information that is immediately below the first basic production information, and any first basic production information and the first production basic information. The first production basic information is linked by a ternary relationship between the second production basic information that is immediately below the second production basic information and the third production basic information that is immediately below the second production basic information. Production master information master, and a plurality of two-term relationships and a plurality of configuration masters that store a plurality of three-term relationships,
The system integrates binary relations and ternary relations extracted from the configuration master, and connects production basic information extracted from the production basic information master in a series from the higher order to the lower order according to the integrated relations. The integrated parts table creating means for creating an integrated parts table of articles and the two-term relations and the three-term relations of a predetermined article among the two-term relation and the three-term relation applicable to other articles Of the relationship sharing means to be shared between the article and the other article, and the two-term relation and the three-term relation of the predetermined article, the two-term relation and the three-term relation that can be diverted to the other article from the predetermined article. An integrated parts table creation system comprising a related diversion means for diverting to an article.   When the relationship sharing means changes at least one of the first to third production basic information forming the two-term relationship and the three-term relationship of the predetermined item, the predetermined item including the changed production basic information 2. The integrated parts table creation system according to claim 1, wherein the two-term relationship and the three-term relationship applicable to other articles are shared between the predetermined article and the other article. .   When the relationship sharing means adds at least one of the second production basic information and the third production basic information to at least one of the two-term relationship and the three-term relationship of a predetermined article, the added production 2. The two-term relationship and the three-term relationship applicable to other articles among the two-term relation and the three-term relation of the predetermined article including basic information are shared by the predetermined article and the other article. Item 3. The integrated parts table creation system according to item 2.   When at least one of the second production basic information and the third production basic information forming the two-term relationship and the three-term relationship of the predetermined article is deleted by the relationship sharing means, the deleted basic production information 4. The two-term relationship and the three-term relationship applicable to other articles among the two-term relation and the three-term relation of the predetermined article excluding the item are shared by the predetermined article and the other article. An integrated BOM creation system described in any one of the above. The production basic information master stores the parts table formation time and the parts table departure time that classify the generation of the basic production information in time series, and the configuration master classifies the generations of the two-term relation and the three-term relation. The BOM formation time and BOM withdrawal time are stored in chronological order,
The integrated BOM creation means is necessary for creating an integrated BOM at any time from the past to the present while referring to the BOM-related and BOM-related BOM formation time and BOM departure time. Various binary and ternary relationships are extracted from the configuration master, the binary and ternary relationships extracted from the configuration master are integrated, and production extracted from the basic production information master according to the integrated relationships 5. An integrated bill of materials creation according to claim 1, wherein an integrated bill of materials of an article at an arbitrary point in time from the past to the present is created by connecting basic information in a series from the top to the bottom. system.   The relationship sharing means can be applied to other articles among the two-term relation and the three-term relation of a predetermined article whose generation is changed when the generation of the two-term relation and the three-term relation of the predetermined article is changed. 6. The integrated parts table creation system according to claim 5, wherein the two-term relationship and the three-term relationship are shared by the predetermined article and the other article. In an integrated bill of materials creation method for creating an integrated bill of materials by using computer resources and connecting various types of basic production information in series from the top to the bottom,
The integrated parts table creation method includes a production basic information master storing a plurality of pieces of basic production information, arbitrary first production basic information, and second production basic information connected immediately below the first production basic information. A plurality of various binary relations of the production basic information linked by a binary relation are stored, arbitrary first production basic information, second production basic information that is immediately below the first production basic information, and the second A configuration master storing a plurality of various three-term relationships of the basic production information linked by a three-term relationship with the third production basic information that is immediately below the basic production information;
The integrated parts table creation method integrates binary relations and ternary relations extracted from the configuration master, and moves the basic production information extracted from the basic production information master from the higher order to the lower order according to the integrated relations. The integrated BOM creation process for creating an integrated BOM for articles by connecting them in series, and the two-term relation and 3 applicable to other articles among the two-term relation and the three-term relation for a predetermined article Of the relationship sharing process for sharing the term relationship between the predetermined article and the other article, and the two-term relation and the three-term relation of the predetermined article, the two-term relation and the three-term relation applicable to the other article are An integrated parts table creation method, comprising: executing a related diversion process that diverts a predetermined article to the other article.   When at least one of the first to third production basic information forming the two-term relationship and the three-term relationship of the predetermined article is changed in the relation sharing process, the predetermined article including the changed production basic information 8. The integrated parts table creation method according to claim 7, wherein among the two-term relationship and the three-term relationship, the two-term relationship and the three-term relationship applicable to other articles are shared by the predetermined article and the other article. .   When the relationship sharing process adds at least one of the second production basic information and the third production basic information to at least one of the two-term relationship and the three-term relationship of a predetermined article, the added production 8. The two-term relationship and the three-term relationship applicable to other articles among the two-term relation and the three-term relation of the predetermined article including basic information are shared by the predetermined article and the other article. Item 9. The integrated parts table creation method according to Item 8.   When at least one of the second production basic information and the third production basic information forming the two-term relationship and the three-term relationship of the predetermined article is deleted in the relationship sharing process, the deleted production basic information is deleted. 10. The two-term relationship and the three-term relationship applicable to other articles among the two-term relation and the three-term relation of the predetermined article excluding the item are shared by the predetermined article and the other article. The integrated bill of materials creation method described in any one. The production basic information master stores the parts table formation time and the parts table departure time that classify the generation of the basic production information in time series, and the configuration master classifies the generations of the two-term relation and the three-term relation. The BOM formation time and BOM withdrawal time are stored in chronological order,
The integrated BOM creation process refers to various items necessary for creating an integrated BOM at any point in time from the past to the present while referring to the BOM-related and ternary-related BOM formation time and the BOM departure time A plurality of binary relations and ternary relations are extracted from the configuration master, the binary relations and ternary relations extracted from the configuration master are integrated, and production extracted from the production basic information master according to the integrated relations The integrated parts table creation according to any one of claims 7 to 10, wherein an integrated parts table for an article at an arbitrary point in time from the past to the present is created by connecting the basic information in a series from the top to the bottom. Method.   When the generation of the two-term relationship and the three-term relationship of the predetermined article is changed, the relation sharing process can be applied to other articles among the two-term relation and the three-term relation of the predetermined article whose generation is changed. 12. The integrated parts table creation method according to claim 11, wherein the two-item relationship and the three-item relationship are shared by the predetermined article and the other article.

Images