JP2010044473A - Contained chemical substance information management system, contained chemical substance information common base management system, contained chemical substance information acquisition method, material master creation method and contained chemical substance information evaluation support program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To efficiently collect information about a contained chemical substance of a product. <P>SOLUTION: A contained chemical substance information management system includes: a component list component information table managed by a delivery destination maker; an information monitoring part detecting addition/update information of a component of a component list component configuration table, and extracting component configuration information and information about the component including a vender ID purchased from a vender; a registration information acquisition part storing information for performing an investigation request to a supplier in a green procurement component information table and a green procurement component configuration table based on the information, changing and registering only an investigation request flag to the component information whose information is present in the tables by using existing information of the tables, and storing the contained chemical substance information of the component and a configuration article purchased from the supplier, and the contained chemical substance information of the component in a chemical substance information table; and a provision instruction part retrieving a contact point of the supplier by an investigation request table from the extracted vender ID, and notifying the contact point about the component configuration information and the information of the component purchased from the supplier. <P>COPYRIGHT: (C)2010,JPO&INPIT

Description

  The present invention relates to a contained chemical substance information management system, a contained chemical substance information common infrastructure management system, a contained chemical substance information acquisition method, a material master creation method, and a contained chemical substance information evaluation support program. This technology relates to technology that efficiently extracts only the information necessary for manufacturers from the massive chemical substance information group of parts and materials in the information common infrastructure management system, generates a material master based on that information, and evaluates design information. .

  Increasing social interest in environmental issues and the strengthening of laws and regulations are demanding the manufacturing industry to manufacture products with less environmental impact and to disclose specific information on chemical substances in products. From such a background, when the manufacturing industry purchases raw materials and parts, it is obliged to provide suppliers with information on contained chemical substances. In the near future, industry organizations will establish a common base for comprehensive management of information on chemical substances contained. Companies use this common platform to obtain information on chemical substances contained in purchased products, evaluate chemical information on their products, and register that information in the common platform to provide information on chemical substances. To do.

  There are the following conventional techniques for acquiring information on contained chemical substances. For example, there is a parts management system for managing chemical substance information of purchased parts under the problem of not requesting chemical substances content response requests redundantly from the purchaser of the purchased parts that make up the product. , A component configuration storage unit storing the component configuration table data of each product, a purchase part storage unit storing the purchase destination data and chemical substance content data of each component, and a survey on the chemical substance content of the product A survey support unit that supports the search component storage unit that stores information on parts that need to be investigated for chemical substances, identification information of the product to be surveyed, and information on the chemicals to be surveyed. A survey request accepting unit that accepts an input of a survey request including a list, and a part of the product having identification information included in the survey request received by the survey request accepting unit, stored in the component configuration storage unit Among the purchased parts specified by the purchased parts specifying means and the purchased parts specifying means, the chemical substance content data is stored in the purchased parts storage unit using the composition table data. The detected purchase part is detected as an uninvestigated part, together with the purchase data of the purchased part and the list of chemical substances included in the investigation request received by the investigation request accepting means, the investigation required For each unpurchased part detection means stored in the part storage means, and each purchased part that is the purchased part specified by the purchased part specifying means and the chemical substance content data is stored in the purchased part storage unit, Content data of all chemical substances included in the list of chemical substances included in the survey request received by the survey request receiving means is stored in the purchased parts storage unit. The chemical substance contained in the survey request received by the purchase request data of the purchased part and the survey request accepting means as a re-survey part if the purchased part is not memorized. Re-investigation part detection means for storing in the investigation-required parts storage means together with chemical substances whose content data is not stored in the purchased parts storage unit among the chemical substances listed in A component management system (refer to Patent Document 1), and the like, and a required component output unit that outputs the data of the purchased component stored in the required component storage unit by the reexamined component detection unit Has been proposed.

JP 2005-339373 A

  Accurately grasping information on chemical substances contained in products means collecting information on contained chemical substances in accordance with the supply chain sequence for manufacturing the relevant products. However, in reality, it is not always possible to accurately obtain the details of information requested by a supplier manufacturer that is a downstream manufacturer of the supply chain from a customer.

  In the future, there will be a common platform for managing parts information by industry groups and the like for such issues. However, the amount of information registered in the common base is enormous, and it is a problem to extract only information required by the delivery destination manufacturer from the registered information.

  In addition, when the delivery maker manufactures a product, first, a designer performs a product design work for creating a drawing or a bill of materials. In the design work, the shape and material of each part constituting the product are selected. Care should be taken when selecting materials, even if the materials are the same, as the information on the chemical substances contained in the materials changes significantly if the material manufacturers differ, the color of the materials, or the surface finishing method. In order to realize the manufacture of products with less environmental burden due to the recent increase in environmental regulations, it is a challenge to be able to select materials with low chemical substance content more efficiently.

  In response to the problem, from the enormous product information and material information managed on the common base, only the information required by the delivery maker is extracted and registered in the database managed by the delivery maker, Material selection issues by design work by displaying priorities regarding candidate groups of materials with low chemical substance content from the bill of materials that is the design information of the supplier and the registered product information and substance information. To solve.

The present invention is a computer system that manages information on chemical substances contained in parts traded between a supplier manufacturer and a common infrastructure management system in a supply chain of product manufacturing, and the computer system is manufactured by a supplier manufacturer. Parts table part configuration table for storing part configuration information for each part of the product to be processed, parts table part information table for managing the name and material classification ID of the part, and parts table usage table for managing the usage of the corresponding product A storage device that is managed by another system or stored as input information from another system;
An information request notification process for making a data reception request to the common infrastructure management system in order to store a huge amount of product information managed by the common infrastructure management system in the previous computer system at the delivery destination;
A common base information extraction process for extracting information necessary for a delivery destination from a huge product information group received from the common base management system;
For the information extracted in the common base information extraction process, a supplier company information table that manages supplier information that is a supplier, a supplier part information table that manages supplier product information, and a product of the supplier A storage device for storing a substance information table for managing the contained chemical substance information;
Similar to the chemical substance information corresponding to the use ID, part / material classification ID, attribute 1 and attribute 2 regarding the information extracted and stored from the information managed by the common infrastructure management system Material master creation process to calculate the properties,
The material ID and material classification ID, usage ID, attribute 1 and attribute 2 material management table for managing the material master creation process for each similar information, and similar chemistry using the material ID as a key A material large classification chemical substance table for managing substance information, a material small classification table for managing similar company information using a material ID as a key, and a material master for managing a threshold for similarity used in the material master creation processing A storage device for storing the setting table;
Based on the parts table parts information table, the parts table parts configuration information table, the parts table application table, the material large classification table, the material large classification chemical substance table, and the material small classification table, the material Using the classification ID as a key, for each part related to the parts table, a contained chemical substance evaluation support process for calculating information with less contained chemical substance information;
A storage device that stores a substance master that manages an influence value for each substance that is necessary for the contained chemical substance evaluation support process.

  According to this, it is possible to efficiently extract and manage the information necessary for the supplier manufacturer from the enormous amount of information managed by the common infrastructure management system, and at the time of material selection in design work, the content of chemical substances is small. By displaying the priorities with respect to the candidate group of materials, it is possible to perform an efficient and quick chemical substance evaluation process.

  According to the present invention, it is possible to efficiently collect information on chemical substances contained in products required by a supplier manufacturer from a vast amount of information in a common infrastructure management system, and to efficiently and quickly evaluate material selection in design work. it can.

--- Overall system flow ---
Embodiments of the present invention will be described below in detail with reference to the drawings. FIG. 1 shows the flow of the entire supply chain including the contained chemical substance management system in the present embodiment. The delivery maker has a chemical substance management system, and notifies the information provision request to the common base management system which is a database (DB) group that can be created in the future.

  The common base management system receives the component information and the chemical substance content information managed by the common base management system by the chemical substance management system based on the notification from the supplier manufacturer. For the received information, based on the parts table information and the parts information, only the information necessary for the delivery manufacturer is extracted by the data extraction function.

  Using the material master creation function from the part information, the similarity is compared from the chemical information contained in the part information and the part information and the company information, and the material master is created and updated. Based on the created / updated material master and the parts table information, the material information candidates for each part are calculated in the order of the least environmental load and displayed on the screen by the contained chemical substance evaluation support function.

--- System configuration ---
FIG. 2 is a network configuration diagram including the contained chemical substance information management system 100 in the present embodiment. A contained chemical substance information management system 100 (hereinafter, system 100) in this embodiment manages information on contained chemical substances in parts traded between a supplier manufacturer and a common infrastructure management system 200 in a product manufacturing supply chain. The common base management system 200 is connected to the contained chemical substance information management system 100 of the delivery maker via the network 140 so that data communication is possible, and additionally writes and receives part information, contained chemical substance information, and the like. An example is assumed here.

  As another example, data managed by the common infrastructure management system 200 may be stored in an electronic recording medium, sent to a delivery destination manufacturer using mail, and electronic data may be registered from the input I / F 106. .

  The system 100 reads the program 102 stored in a storage device such as the hard disk drive 101 to the memory 103 and executes it by the CPU 104 which is an arithmetic device in order to realize the function of executing the method for managing contained chemical substance information of the present invention. Further, the system 100 includes an input interface 105 such as various keyboards and buttons generally provided in a computer device, an output interface 106 such as a display, and a communication device 107 that performs data exchange with the common infrastructure management system 200 and the like. Etc. The system 100 uses the communication device 107 to connect to the common infrastructure management system 200 via a network 140 such as the Internet, a LAN, or a serial interface communication line, and execute data exchange.

  Next, functions configured and held by the system 100 based on the program 102 will be described. In the hard disk drive 101, the system 100 includes a supplier part information table 122 that stores information on a corresponding part for each part, and a chemical substance information table that stores information on chemical substances contained in the part for each part. 123, a supplier company information table 121 that stores information on companies that manufacture products of each part information, and a parts / material classification master table 125 that stores names of parts / material classification IDs.

  In addition, the system 100 includes a material master setting table 129 that stores setting values for calculating similarity of information from the component information and chemical substance information, and a material classification ID and usage from the result of calculating the similarity. A material classification table 125 that manages ID, material ID, attribute 1, and attribute 2, a material large classification chemical substance table 127 that stores chemical substance information for the material ID, and a company summarized by the result of the similarity calculation A material small classification table 128 for storing information is provided.

  In addition, the system 100 includes a substance master table 123 that stores a set value for each CAS-NO of the material classification chemical substance master for the chemical substance evaluation process for displaying material candidates in the bill of materials, and a chemical substance evaluation process. Parts table component information table 130 for storing a part name and material classification ID, a parts table part configuration table 131 for storing product configuration information, and a parts table application for managing product usage A table 132 is provided.

  Such a system 100 receives registration information including product ID and company ID of component information registered in the common infrastructure management system 200 and information on contained chemical substances from the network 140, and receives the supplier company information table 121, A registration information acquisition unit 110 is provided that stores a supplier part information table 122 and a substance information table 123 in association with each of a part information ID, a company ID, and a product ID.

  The registration information acquisition unit 110 makes an acquisition request via the network 140 before receiving the information of the common infrastructure management 200.

  Further, the system 100 uses the parts table part information table 130 and the parts table application table 132 from the registration information including the product ID and company ID of the part information received from the common infrastructure management system 200 and information on the contained chemical substances. Information with a part / material classification ID is extracted based on the use ID and the part / material classification ID, and the application ID and the supplier company information table 121 already registered, the supplier part information table 122, and the substance An information processing unit 112 that determines an update flag by comparing with an information table 123 and a component information ID, a company ID, and a product ID is provided.

  In addition, the system 100 monitors the update date of the supplier part information table 122 and uses the part information ID for use in generating information related to the material master from the information extracted and registered from the common infrastructure management system 200. , A supplier company information table 121 related to the company ID and an information monitoring unit 111 that extracts the substance information table 123 are provided.

  Further, the registration information processing unit 112 relates to information extracted from the update date, part information including a use ID, a part / material classification ID, attribute 1 and attribute 2, and chemical substance information corresponding to the part information ID. The similarity is calculated, and the result is stored in the material major classification table 126, the material major classification chemical substance information table 127, and the material minor classification table 128.

  The registered information processing unit 112 also includes parts table part information, parts table part configuration information, parts table usage information, which are product information of a supplier manufacturer, the registered material large-class chemical substance information, material large-class chemical Using the CAS-NO setting value set in the substance master table 124 from the substance information and the material small classification information, the product sum evaluation process is performed for each material ID, and the evaluation result values are displayed on the output interface 106 in ascending order. To do.

The above is the configuration of the system 100. On the other hand, there is a common infrastructure management system 200 connected to the contained chemical substance information management system 100 through a network 140.
The common infrastructure management system 200 is connected to the system 100 through a network 140 so that data communication is possible.

  The common infrastructure management system 200 reads the program 202 stored in the storage device such as the hard disk drive 201 to the memory 203 in order to realize the function of executing the contained chemical substance information management method of the present invention in cooperation with the system 100. It is executed by the CPU 204 which is an arithmetic unit. The common infrastructure management system 200 includes an input interface 205 such as various keyboards and buttons generally provided in a computer device, and an output interface 206 such as a display. The common infrastructure management system 200 is connected to the system 100 via the network 140 such as the Internet, a LAN, or a serial interface communication line by the communication device 107 and executes data exchange.

  The common base management system 200 includes a common base company information table 221, a common base part information table 222, and a common base chemical substance that store product IDs of products manufactured by the supplier and information on contained chemical substances as registration information. An information table 223 is provided.

The common infrastructure management system 200 includes a registration information transmission unit 210 that transmits a product ID of a product manufactured by the supplier and information on contained chemical substances to the system 100 as registration information.
The registration information transmission unit 210 receives the registration information from the registration information acquisition unit 111 of the system 100 via the network 140 before transmitting the registration information to the registration information acquisition unit 110 of the system 100.

--- Example of table structure ---
Next, the structure of the table used by the system 100 in this embodiment will be described. 3A to 3E show a supplier company information table 121, a supplier part information table 122, a substance information table 123, a substance master table 124, a parts / material classification master table, and a material large classification table in the present embodiment. 126, each of the data structure examples of the material large classification chemical substance information table 127, the material small classification table 128, the material master setting table 129, the parts table part information table 130, the parts table part configuration information table 131, and the parts table usage table 132 is shown. FIG.

  The trading company information table 121 is, for example, a table that manages information of a supplier company of product information related to information extracted from the common infrastructure management system. When product information manufactured by the supplier A is managed by the system 100, it is a collection of records in which information such as the company name, the representative, and the contact information is associated with the company ID of the supplier A as a key.

  The supplier part information table 122 is a table for managing product information related to information extracted from the common infrastructure management system, for example. With respect to the product manufactured by supplier A, using component information ID as a key, attribute 1 and attribute 2 for managing company ID, product ID corresponding to product model number, color, surface treatment method, etc., and the product of supplier A is final This is a set of records in which information such as a use ID of a product that is used in general and a part / material classification ID that is the type information of the product of the supplier A are associated with each other.

  The substance information table 123 is a table that stores information on chemical substances contained in products manufactured by the supplier A. For example, the chemical information contained in the parts is stored using the part information ID determined for each product or part as a key. Corresponding information such as substance number, CAS number (CAS-NO) (identification number unique to chemical substance registered in chemical substance registration system in CAS (Chemical Abstracts Service) of American Chemical Society), content, and its unit It is a collection of attached records.

  The substance master table 124 corresponds to, for example, information such as the name, the set value obtained by quantifying the risk of the chemical substance corresponding to the CAS number, and the management name describing the name of the risk using the CAS number as a key. It is a collection of attached records.

  Further, the part / material classification master 125 manages information such as an outer diameter of 1.000 mm and a pitch of 0.20 with a symbol such as M1 × 0.2, and records information such as parts / material names corresponding to the explanation. It becomes an aggregate.

  Further, the material large classification table 126 includes, for example, information such as the material classification ID, the attribute 1 and the attribute 2 that manage the material classification ID, the use used as the final product, the color, the surface treatment method, and the like. It is a collection of associated records.

  In addition, the material large classification chemical substance information table 127 manages, for example, general information for each similar rule of the supplier part information table 122 and the substance information table 123 using the material ID as a key, This is a set of records in which information such as CAS-NO, content, content maximum value, content minimum value, and unit is associated.

  In addition, the material sub-classification table 128 manages the supplier company information of the summarized information for each similar rule of the supplier part information table 122 and the substance information table 123, for example, using the material ID as a key. Then, it is an aggregate of records in which information such as company ID and product ID (manufacturer model ID) is associated.

  In addition, the material master setting table 129 uses, for example, the ratio value calculated from the content of the CAS number for each CAS number in order to determine similar rules of the supplier part information table 122 and the substance information table 123. It is a collection of records in which information such as setting values and units obtained within and outside the setting value range is associated.

  The parts table part information table 130 is a table that defines part information of each part constituting the product of the delivery destination manufacturer. For example, the part name and material classification ID are set using the part ID determined for each part as a key. It is a table to be managed.

  Also, the parts table parts configuration table 131 is a table that defines a parent-child relationship between the parts that make up the product of the delivery destination manufacturer. For example, the parts corresponding to the parts ID and the parts are displayed using the parts ID as a key. This is a set of records for managing the component IDs of the child components to be configured, and the number of the components and the child components.

  The parts table usage table 132 is a collection of records for managing product IDs and usage IDs of products of the delivery destination manufacturer.

--- Processing flow example ---
Hereinafter, the actual procedure of the contained chemical substance information management method in the present embodiment will be described with reference to the drawings. Of the various operations corresponding to the contained chemical substance information management method described below, those related to the system 100 are realized by the program 102 that the system 100 reads into the memory 103 and executes, and the common infrastructure management system. 200 is realized by the program 202 that the common infrastructure management system 200 reads into the memory 203 and executes. Each of these programs is composed of codes 102 and 202 for performing various operations described below.

  FIG. 4A is a diagram showing an example of a processing procedure of the contained chemical substance information management method of the present embodiment. FIG. 4 shows an example of processing procedures S101 to S302 in which data is extracted from the common infrastructure management system 200 and registered in the contained chemical substance management system 100 in the delivery maker.

  Fig. 4 (b) creates material major classification information, material major classification chemical substance information, and material minor classification information from the similarity of the parts information and the contained chemical substance information extracted and registered from the common infrastructure management system 200. This is an example of processing steps S401 to S423.

  Fig. 4 (c) shows the risk of chemical substances calculated and processed based on the material major classification information, material major classification chemical substance information, material minor classification information, and the parts list information of the product of the manufacturer. This is an example of processing steps S501 to S506 for displaying candidate parts from a few parts.

  Here, the system 100 used by the manufacturer of the delivery destination manages a parts table / parts configuration table 130 and a parts table / parts information table 131. The information monitoring unit 111 searches the part table part information table 130 or the part table part configuration information table 131 for the status new or update flag and the data of the update date and time within the set processing interval, It is determined whether the parts table part configuration information is added or a part of part information is updated for a part. For example, FIG. 4 shows a case where a parent part ID 101 and a child part ID 103 of the parts table part configuration information table 131 are newly added, and in FIG. 5, a part having a status deletion flag in the parts table part configuration information table 130. This is a case where the table part configuration information is added or deleted. In FIG. 6, the status of the part table component configuration information table 131 is not changed, and the status of the part ID 303 of the parts table component information table 130 is updated (S101). ).

When the BOM part configuration information is newly added (S102: configuration change, S103: new addition), for example, using the added part ID 103 as a key, the supplier ID supplier of the upper part from the BOM part configuration information table 131 is used. A and child component ID 101 are extracted, and configuration information with the component ID 101 as the parent component ID is extracted (S104).
The component information of the component table component information table 130 is extracted using the component ID of the extracted configuration information as a key. In the example in FIG. 4, information using the component ID 100, the component ID 101, the component ID 102, and the component ID 103 as keys is extracted from the component table component information table 130. (S105)
The configuration information extracted in S104 is added to the extracted supplier ID supplier A and registered in the green procurement configuration information table 127 (S106).
A supplier ID supplier A and a status investigation request are assigned to the component information in the extracted component ID 100, component ID 101, component ID 102, and component ID 103, and registered in the green procurement component information table (S107).

  The provided information instruction unit 112 notifies the delivery destination manufacturer terminal of the component ID 100, the component ID 101, the component ID 102, and the component ID 103 whose status is the request for investigation (S108).

The information monitoring unit 111 of the system 100 receives confirmation data from the delivery maker terminal (S109).
The information monitoring unit 111 of the system 100 searches the contact information of the survey request table for the supplier ID supplier A and the component ID 100, the component ID 101, the component ID 102, and the component ID 103 of the status survey request in the green procurement component information table 128, An email is transmitted to the supplier terminal (S110).

The registration information acquisition unit 110 of the system 100 receives chemical substance response data from the supplier terminal (S111).
The registration information acquisition unit 110 of the system 100 stores the contained chemical substance information in the chemical substance information table in association with the corresponding part ID 102 and part ID 103 (S112).

  Further, when the parts table part configuration information is added and deleted (S102: configuration change, S103: addition and deletion), for example, the parent part ID 201 and the child part ID 203 whose status is deleted in the parts table part configuration information table 131 are extracted. (S201).

The information monitoring unit 111 of the system 100 searches for the status-added parent part ID 201 and child part ID 204 in the parts table part configuration information table using the extracted status-deleted parent part ID 201 as a key (S202).
The information monitoring unit 111 of the system 100 extracts relevant part information from the parts table part information table 130 using the added child part ID 204 as a key. Here, it is component ID204, mass 10, and unit mg (S203).

  The information monitoring unit 111 of the system 100 uses the parent part ID 201 and the child part ID 203 in S201 as keys, and from the green procurement part configuration table 127, the supplier ID supplier B and the highest part ID 201 including the child part ID 203 are included. , The configuration information with the component ID 201 as the highest component is extracted, and the data of the parent component ID 201 and the child component ID are deleted (S204).

Using the component ID as a key, the presence / absence of a supplier ID (customer ID) is searched from the parent part ID of the parts table component configuration information table 131. If there is no supplier ID, the information of the parent part ID is used as a child part ID, and the presence / absence of the supplier ID is searched from the parent part ID of the upper structure of the child part ID. The above process is performed until the supplier ID is searched. After searching for the supplier ID, the parts information is extracted from the parts table part information table 130 from the parts configuration below the parent part ID with the supplier ID and the corresponding part ID, and stored in the memory 103. (S102)
When the update information is new (S103: New), the extracted parts table part information and parts table configuration information are stored in the green procurement parts information table 128 and the green procurement parts configuration table 127. At this time, the extracted supplier ID (customer ID) and each part ID key are stored in the green procurement part information table 128 and the green procurement configuration table 127. (S104)
The information monitoring unit 111 of the system 100 searches the supplier contact information from the survey request table 127 based on the supplier ID and notifies the person in charge of the delivery destination manufacturer as the survey request information. (S105)
The information monitoring unit 111 receives notification of confirmation information from an input I / F of the system 100 from a person in charge of a delivery manufacturer. (S106)
The investigation request flag of the green procurement parts information table 128 is set to the investigation request, and communication is made with the supplier's contact information using the supplier ID of the investigation request table 126 as a key through the communication device 107 of the system 100 via the network 140 (S107). .
Through the supplier terminal 200 and the network 140 used by the supplier, the relevant part and relevant part configuration information delivered to the delivery destination manufacturer by the supplier are received as the survey request information (S108).

Based on this survey request information, each contained chemical substance information is stored in association with the corresponding part ID in the chemical substance information table 125 of the system 100. (S109). The child component ID may be added from the corresponding component ID to the configuration information that only the supplier has from the received corresponding component configuration information. Then, each contained chemical substance information can be stored in association with the added corresponding part ID.
At this time, the information monitoring unit 111 of the system 100 monitors the registration information stored in the chemical substance information table 125 and updates the survey request flag of the green procurement parts information table 128 to the surveyed from the registration information. To do.

  On the other hand, when the update information of the parts table part information is update (S103: update), green procurement is performed using the extracted part table part information and the part ID with the supplier ID of the parts table configuration information and the supplier ID as keys. The configuration information between components purchased from the supplier in the component configuration table 127 is retrieved and stored in the memory 103 of the system 100 (S201).

Then, the update date and the survey request flag, which are attribute information in which the parts table part information table 130 is updated, are stored in the green procurement parts information table 128 using the part ID of each configuration information as a key (S202).
This registration date is stored from the green procurement component information ID using the component ID as a key. At this time, the extracted supplier ID (customer ID) and each part ID key are stored in the green procurement parts information table 128 and the green procurement configuration table 127 (S104).

It is a conceptual diagram which shows the flow of the whole supply chain containing the contained chemical substance management system in this embodiment. It is a network block diagram including the contained chemical substance information management system in this embodiment. It is a figure which shows each data structure example of the supplier company information table 121, the supplier component information table 122, and the substance information table 123 of the common infrastructure management system in this embodiment. It is a figure which shows each data structure example of the supplier company information table 121 in this embodiment, the supplier components information table 122, the substance information table 123, the substance master table 124, and a components and material classification master table. It is a figure which shows each data structure example of the supplier company information table 121 of the in-house system (before registration), the supplier component information table 122, and the substance information table 123 in this embodiment. It is a figure which shows each data structure example of the material large classification table 126, the material large classification chemical substance information table 127, the material small classification table 128, and the material master setting table 129 of the in-house system (after registration) in this embodiment. It is a figure which shows each data structure example of the parts table parts information table 130, the parts table parts structure information table 131, and the parts table usage table 132 in this embodiment. It is a figure which shows the process sequence example (the 1) of the contained chemical substance information management method of this embodiment. It is a figure which shows the process sequence example (the 2) of the contained chemical substance information management method of this embodiment. It is a figure which shows the process sequence example (the 3) of the contained chemical substance information management method of this embodiment.

Explanation of symbols

100 ... contained chemical substance information management system 101, 201 ... hard disk drive (storage device)
102, 202 ... Program 103, 203 ... Memory 104, 204 ... CPU
105, 205 ... input interfaces 106, 206 ... output interfaces 107, 207 ... communication device 110 ... registration information acquisition unit 111 ... information monitoring unit 112 ... provision instruction unit 125 ... chemical substance information table 126 ... survey request table 127 ... green procurement parts Configuration information table 128 ... Green procurement parts information table 130 ... Parts table parts information table 131 ... Parts table parts configuration information table 140 ... Network 200 ... Supplier terminal 210 ... Registration information transmission unit 211 ... Acquisition instruction reception unit

Claims (5)

A computer system for managing information on chemical substances contained in parts traded between a supplier manufacturer and a common infrastructure management system in a product manufacturing supply chain. Separate system for parts table parts configuration table for storing parts configuration information for each part, parts table part information table for managing the name and material classification ID of the part, and parts table usage table for managing the use of the corresponding product A storage device that is managed by or stored as input information from another system;
An information request notification process for making a data reception request to the common infrastructure management system in order to store a huge amount of product information managed by the common infrastructure management system in the previous computer system at the delivery destination;
A common base information extraction process for extracting information necessary for a delivery destination from a huge product information group received from the common base management system;
For the information extracted in the common base information extraction process, a supplier company information table that manages supplier information that is a supplier, a supplier part information table that manages supplier product information, and a product of the supplier A storage device for storing a substance information table for managing the contained chemical substance information;
Similar to the chemical substance information corresponding to the use ID, part / material classification ID, attribute 1 and attribute 2 regarding the information extracted and stored from the information managed by the common infrastructure management system Material master creation process to calculate the properties,
The material ID and material classification ID, usage ID, attribute 1 and attribute 2 material management table for managing the material master creation process for each similar information, and similar chemistry using the material ID as a key A material large classification chemical substance table for managing substance information, a material small classification table for managing similar company information using a material ID as a key, and a material master for managing a threshold for similarity used in the material master creation processing A storage device for storing the setting table;
Based on the parts table parts information table, the parts table parts configuration information table, the parts table application table, the material large classification table, the material large classification chemical substance table, and the material small classification table, the material Using the classification ID as a key, for each part related to the parts table, a contained chemical substance evaluation support process for calculating information with less contained chemical substance information;
Contained chemical substance management system comprising a storage device for storing a substance master for managing the influence value of each substance necessary for the contained chemical substance evaluation support process The chemical substance information management system includes:
A communication device for communicating via the network with the common infrastructure management system that manages the product information of the supplier, information on contained chemical substances, and company information of the supplier,
The trading company information table manages only the company information required by the delivery maker from the company information stored in the common infrastructure management system,
The supplier parts information table manages only the product information required by the supplier manufacturer from the product information stored in the common infrastructure management system,
The substance information table manages only the manufactured chemical substance information required by the delivery manufacturer from the contained chemical substance information of the product information stored in the common infrastructure management system,
The information request notification communicates with the common infrastructure management system through a network, and extracts and supplies registration information including information on company ID, product ID, and contained chemical substances stored in the common infrastructure management system. To notify the common infrastructure management system,
The common base information extraction process receives information registered in the common base management system from the common base management system through a network, and from each part / material classification ID of the parts table part information table and parts table usage table. , Extracting information including each part / material classification ID in the information received from the common infrastructure management system, and supplier information table, supplier part information in a form that meets the registration conditions based on the use ID in the extracted information The contained chemical substance information management system according to claim 1, wherein the chemical substance information management system is stored in a table and a substance information table.   The material master creation process extracts a newly added and updated part information ID from the supplier company information table, the supplier part information table, and the substance information table, and based on the part information ID. , Use ID, part / material classification ID, attribute 1 and attribute 2, and material classification ID, use ID, attribute 1 and attribute 2 in the material large classification table are compared. Information and content information are registered in the material major classification table, the material major classification chemical substance information table, and the material minor classification table, and when there is a comparison target, the corresponding part is set using the material ID of the material major classification table as a key. The chemical substance information in the substance information table and the content information in the material large classification chemical substance information table are compared. Registered in the chemical substance information table and the material minor classification table, and when the previous period content information is the same, the content for each CAS-NO in the substance information table of the relevant part and the CAS- in the material major classification chemical substance information table The ratio of the content for each NO is calculated, and when it is other than the setting value of the material master setting table, it is registered in the material large classification table, the material large classification chemical substance information table, and the material small classification table, and the recording material master 3. The contained chemistry according to claim 1, wherein when the value is within the set value of the setting table, the company ID and product ID of the part information of the corresponding part are registered in the material small classification table in the material small classification table. Substance information management system.   The contained chemical substance evaluation support process includes the material major classification table registered in the material master creation process, the material major classification chemical substance information table, the material minor classification table, the parts table parts information table, Based on the parts table parts configuration table and the parts table usage table, the usage ID of the parts usage table, the parts / material ID of the parts table part information table, the usage ID and material classification of the material large classification table If the IDs are compared, and if they are the same, the content of each CAS-NO in the material major classification chemical substance information table and the set value of each CAS-NO in the substance master are integrated from the corresponding material ID, The sum total of the integrated values for each part ID in the parts table part information table is calculated, and the information of the material major classification table and the information of the material minor classification table are displayed on the screen in ascending order. Chemical substances information management system according to claim 1 or 2 or 3, characterized in that output. Information on chemical substances contained in parts traded between the common base management system that manages company information, parts information, and contained chemical substance information of suppliers and suppliers in the product manufacturing supply chain is managed by a computer system. A way to
The computer system is
The information required by the delivery manufacturer is extracted from the enormous information registered in the common infrastructure management system based on the parts table part information, the material classification ID and the application ID of the parts table application information, and each part. Stores a supplier part information table that stores part information for each part, a chemical substance information table that stores information on contained chemical substances corresponding to the part, and a company information table that registers information about each part. In preparation for the device
From each part information and contained chemical substance information, the part information updated based on the update date is extracted and compared according to the similarity condition. The material major classification table, the material major chemical substance information table, and the material The storage device has a table for updating and registering the small classification material table,
From the parts table parts information table, the parts table parts configuration table, the parts table application table, the material large classification table, the material large classification chemical substance information table, and the material small classification material table, each component A contained chemical substance information management method comprising displaying material candidates on the screen in ascending order of chemical substance content from an ID, a use ID, and a material classification ID.

Images