JP2005339373A - Parts management system and method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To avoid duplicate requests of a reply request of content of chemicals to a purchase destination of purchased parts constituting a product. <P>SOLUTION: An investigation support device 5 specifies the purchased parts constituting an object product of an investigation request using a parts constitution DB device 2. Then, the chemicals of the purchased parts of which the content data of the chemicals of investigation objects is not stored in a purchased parts DB device 3 are specified among the specified purchased parts. Then, reply request data of the content of the chemicals of the specified purchased parts is transmitted to a reply request support device 6. The reply request support device 6 transmits the reply request data to a supplier terminal 8 at the purchase destination of the specified purchased parts. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to a technique for managing chemical substance information of purchased parts.

  Non-Patent Document 1 discloses a system that transmits a response request for the content of a chemical substance in a purchased part to a purchaser of the purchased part constituting the product in accordance with a survey request from the delivery destination of the product. .

Edited by the Green Procurement Survey Standardization Council "Practice of Green Procurement Guidelines for Standardization of Green Procurement Surveys for Components for Electric and Electronic Equipment" Published by Japan Industrial Environment Management Association September 20, 2003, pages 20-101

  Usually, the range of chemical substances to be investigated varies depending on the delivery destination of the product, but there are many cases where some overlap. In addition, the same purchased parts may be used for different products, and when a chemical substance is investigated for one product, the purchased part may have been investigated in a chemical substance investigation for the other product.

  However, the system described in Non-Patent Document 1 does not consider these points, and every time a survey request is received from a delivery destination of a product, the purchase part of the purchase part constituting the product receives the purchase part. A response request for the content of chemical substances was being sent.

  The present invention has been made in view of the above circumstances, and it is an object of the present invention to avoid requesting multiple chemical substance content response requests from a purchaser of purchased parts constituting a product.

  In order to solve the above-mentioned problems, the present invention specifies a chemical substance of a purchased part that really needs to be investigated among purchased parts constituting the product in response to a survey request from a delivery destination of the product.

For example, in the parts management system of the present invention, for each product, a parts configuration storage unit in which product part configuration table data is stored, and parts purchase destination data and chemical substance content data are stored for each part. A purchased parts storage unit, and a survey support unit that supports a survey on the content of chemical substances in the product. And the investigation support department
Investigation part storage means that stores information on parts that require chemical investigation,
A survey request receiving means for receiving an input of a survey request including identification information of a survey target product and a list of survey target chemical substances;
A purchased part that identifies a purchased part of the product using the part structure table data of the product having identification information included in the survey request received by the survey request receiving unit, stored in the part configuration storage unit Among the purchased parts specified by the specifying means and the purchased parts specifying means, the purchased parts in which the chemical substance content data is not stored in the purchased parts storage unit are detected, and the detected purchased parts are determined as uninspected parts. In addition to the purchaser data of the purchased part and the list of chemical substances included in the survey request received by the survey request accepting unit, the uninvestigated part detecting unit stored in the survey required part storage unit,
Included in the survey request received by the survey request accepting means for each of the purchased parts identified by the purchased part identifying means and having the chemical substance content data stored in the purchased parts storage unit It is checked whether or not the content data of all chemical substances listed in the list of chemical substances being stored is stored in the purchased part storage unit. Of the chemical substances included in the list of chemical substances included in the purchase request data and the survey request received by the survey request receiving means, content data is stored in the purchased parts storage unit. Re-investigation part detection means for storing in the investigation required part storage means together with a non-chemical substance,
Survey required parts output means for outputting data of purchased parts stored in the required survey parts storage means by the unsurveyed parts detection means and the re-survey parts detection means.

  In the present invention, among the purchased parts constituting the survey target product, the chemical substance of the purchased part whose content data of the survey target chemical substance is not stored in the purchased part storage unit is specified. As described above, according to the present invention, the chemical substance of the purchased part that really needs to be investigated can be specified, so that the purchase request for the purchased part does not require duplicate response requests for the content of the chemical substance. Can be.

  Hereinafter, embodiments of the present invention will be described.

  FIG. 1 is a schematic configuration diagram of a parts management system to which an embodiment of the present invention is applied. As shown in the figure, the parts management system 1 is connected to a supplier terminal 8 which is a network terminal from which parts are purchased, via a network 9 such as the Internet. Further, the parts management system 1 includes a parts configuration DB (database) device 2, a purchased parts DB device 3, a customer DB device 4, a survey support device 5, a response request support device 6, and the devices 2 to 6. And a network 7 such as a LAN to be interconnected.

  The component configuration DB apparatus 2 manages the component configuration table of each product. The part configuration table is data representing a tree structure of component parts obtained by expanding parts of a product by a parent-child relationship between parts. FIG. 3A is a schematic diagram of a component configuration table. Here, reference numeral 204 denotes a part number which is part identification information, and reference numeral 205 denotes a part name.

  FIG. 2 is a schematic configuration diagram of the component configuration DB apparatus 2. As shown in the figure, a network IF unit 201 for connecting to the network 7, a part number storage unit 202, a parent-child relationship storage unit 203, and a storage control unit 204 for controlling access to the storage units 202 and 203 are provided. Have.

  The part number storage unit 202 stores information on component parts of various products. FIG. 3B is a diagram showing an example of registered contents in the part number storage unit 202. As shown in the figure, a record 2021 is formed with a field 2022 for registering the part number of the part and a field 2023 for registering the part name of the part.

  The parent-child relationship storage unit 203 stores the parent-child relationship of each component whose record is stored in the component number storage unit 202. FIG. 3C is a diagram showing an example of registered contents in the parent-child relationship storage unit 203. As shown in the figure, a field 2032 for registering a part number of a parent part, a field 2033 for registering a part number of a child part, and a field 2034 for registering the number of child parts are provided. Two records 2031 are formed.

  Returning to FIG. 1, the description will be continued. The purchased parts DB device 3 manages the purchase destination of each part and the content of chemical substances. FIG. 4 is a schematic configuration diagram of the purchased parts DB device 3. As shown in the figure, access to the network IF unit 301 for connecting to the networks 7 and 9, the purchase destination storage unit 302, the substance number storage unit 303, the content amount storage unit 304, and the storage units 302 to 304 is performed. And a storage control unit 305 for controlling.

  The purchase destination storage unit 302 stores purchase destination information of each purchased part. FIG. 5A is a diagram illustrating an example of registered contents in the purchase destination storage unit 302. As shown in the figure, a field 3022 for registering the part number of the part, a field 3023 for registering identification information (purchaser ID) of the purchaser of the part, and a management number ( One record 3021 is formed with a field 3024 for registering the purchaser model number, a field 3025 for registering the part name of the part, and a field 3026 for registering the mass of the part. ing.

  The substance number storage unit 303 stores the substance number of each chemical substance. FIG. 5B is a diagram showing an example of registered contents in the substance number storage unit 303. As shown in the figure, a record 3031 is formed with a field 3032 for registering a substance number (CAS registration number) of a chemical substance and a field 3033 for registering the name of the chemical substance. .

  The content storage unit 304 stores the chemical substance content in the purchased part reported from the purchaser of the purchased part. FIG. 5C is a diagram illustrating an example of registered contents in the content storage unit 304. As shown in the figure, a field 3042 for registering a purchaser ID of a purchased part, a field 3043 for registering a purchaser model number of the purchased part, and a field 3044 for registering a substance number of a chemical substance to be investigated. And a field 3045 for registering the content of the investigation target chemical substance in the purchased part, one record 3041 is formed.

  Returning to FIG. 1, the description will be continued. The customer DB device 4 manages information on the delivery destination (customer) of the product. FIG. 6 is a schematic configuration diagram of the customer DB device 4. As shown in the figure, a network IF unit 401 for connecting to the network 7, a customer storage unit 402, and a storage control unit 403 that controls access to the storage unit 402 are included.

  The customer storage unit 402 stores information on chemical substances that each customer (product delivery destination) requests to investigate. FIG. 7 is a diagram illustrating an example of registered contents in the customer storage unit 402. As shown in the figure, a field 4022 for registering customer identification information (customer ID) and a field 4023 for registering a list of substance numbers of chemical substances for which the customer requests a content survey are provided. One record 4021 is formed.

  Returning to FIG. 1, the description will be continued. In response to a request for a chemical substance survey for a customer's product, the survey support apparatus 5 identifies the chemical substance of the purchased part that really needs to be surveyed among the purchased parts constituting the product. FIG. 8 is a schematic configuration diagram of the survey support apparatus 5. As shown in the figure, an arithmetic unit 500, a storage unit 520, an input / output unit 540 for inputting / outputting information to / from peripheral devices such as a keyboard, a display, and a CD-ROM drive, and a network IF unit for connection to the network 7 560.

  The storage unit 520 includes a survey request registration unit 521, a survey component registration unit 522, and a purchase component registration unit 523.

  In the survey request registration unit 521, customer survey request data is registered. FIG. 9A is a diagram illustrating an example of registration contents of the survey request registration unit 521. As shown in the figure, a field 5211 for registering identification information (request ID) of a survey request, a field 5212 for registering a customer ID of a customer, and a part number of a product requested for survey by the customer are registered. A field 5213 for registering, a field 5214 for registering a list of substance numbers of chemical substances requested to be surveyed by the customer, a field 5215 for registering the time limit of the survey report to the customer, One record 5210 is formed with a field 5216 for registering a flag indicating whether or not a survey report has been made to the customer.

  In the investigation required parts registration unit 522, information on parts that require investigation of chemical substances is registered for each investigation request. FIG. 9B is a diagram showing an example of registered contents of the investigation required component registration unit 522. As shown in the figure, a table 5225 is provided for each request ID of the survey request record 5210 registered in the survey request registration unit 521. Registered in the table 5224 is a record 5220 of purchased parts that requires investigation of chemical substances. The record 5220 includes a field 5221 for registering the purchaser model number of the purchased part, a field 5222 for registering the purchaser ID of the purchased part, and the substance number of the chemical substance that needs to be investigated for the purchased part. A field 5223 for registering a list of, and a field 5224 for registering a flag indicating whether or not the investigation has been completed.

  Then, the purchased parts registration unit 523 registers the information of the purchased parts constituting the product for each product for which the survey request is made. FIG. 9C is a diagram showing an example of registration contents of the purchased parts registration unit 523. As shown in the figure, a field 5231 for registering the part number of the target product for the survey request and a field 5232 for registering a list of part numbers of purchased parts constituting the target product for the survey request are provided. Two records 5230 are formed.

  Next, the calculation unit 500 includes a survey request accepting unit 501, a purchased component specifying unit 502, an unexamined component detecting unit 503, a re-examined component detecting unit 504, an investigation required component output unit 505, and an investigation state monitoring unit. 506, a cover ratio calculation unit 507, and a survey report creation unit 508.

  FIG. 10 is a flowchart for explaining the operation of the survey support apparatus 5.

  When the input / output unit 540 receives a survey request registration instruction from the user via the input device (YES in step S11), the input / output unit 540 notifies the survey request receiving unit 501 of this. In response to this, the survey request receiving unit 501 displays an information input screen on the display device via, for example, the input / output unit 540, and the customer ID, the part number of the product to be surveyed, and the like from the input device via the input / output unit 540. The time limit for the investigation report is accepted (step S12).

  Then, the survey request receiving unit 501 accesses the customer DB device 4 via the network IF unit 560, and reads the record 4021 having the customer ID received in step S12 from the customer storage unit 402. Then, a list of substance numbers of chemical substances registered in the read record 4021 is specified (step S13).

  Next, the survey request receiving unit 501 adds a new record 5210 to the survey request registration unit 521, assigns a unique request ID to the field 5211 of the newly added record 5210, and steps S12 to the fields 5212, 5213, and 5215. Customer ID, part number of survey target product, survey report deadline, list of substance numbers of the chemical substances identified in step S13 in field 5214, and flag indicating that no survey has been reported in field 5216 Is registered (step S14). Then, it returns to step S11.

  In addition, when the input / output unit 540 receives a survey start instruction from the user via the input device (YES in step S15), the input / output unit 540 notifies the purchased component specifying unit 502 of this. In response to this, the purchased component specifying unit 502 displays the contents of the record 5210 of the survey request registered in the survey request registration unit 521 on the display device via the input / output unit 540, for example. The selection of the survey request for starting the survey is accepted from the input device (step S16).

  Next, the purchased part specifying unit 502 accesses the part configuration DB apparatus 2 via the network IF unit 560 and uses the part number storage unit 202 and the parent-child relationship storage unit 203 to check the survey request selected in step S16. Identify purchased parts that make up the target product. Then, the information on the specified purchased part is registered in the purchased part registration unit 523 in association with the target product for the survey request. Also, the request ID of the investigation request and the part number of the target product are notified to the uninvestigated part detection unit 503 (step S17). Details of step S17 will be described later.

  Next, when the uninvestigated part detecting unit 503 receives the request ID and the part number from the purchased part specifying unit 502, the uninvestigated part detecting unit 503 accesses the purchased part DB device 3 via the network IF unit 560, and purchase source storage unit 302, substance number Using the storage unit 303 and the content storage unit 304, among the purchased parts constituting the target product of the survey request specified by the part number, the purchased parts whose chemical substances have not been investigated are detected, and each detected purchased part is detected. Together with the list of substance numbers of the chemical substances identified in step S13, the part number is registered in the table 5225 associated with the request ID in the part-to-be-inspected part registration unit 522. Further, the part number of each purchased part whose chemical substance has been investigated is notified to the re-investigation part detection unit 504 together with the request ID of the investigation request (step S18). Details of step S18 will be described later.

  Next, when the re-investigation part detection unit 504 receives the request ID and the part number from the non-investigation part detection unit 503, the re-investigation part detection unit 504 accesses the purchase part DB device 3 via the network IF unit 560, and purchase source storage unit 302, substance Using the number storage unit 303 and the content storage unit 304, a purchased part that requires a chemical substance re-investigation is detected from among the purchased parts (purchased parts whose chemical substances have already been investigated) identified by the received part number. Then, the part number of each detected purchased part is registered in the table 5225 associated with the request ID in the investigation-part registration unit 522 together with the list of substance numbers of the chemical substances to be investigated. Also, the request ID for the survey request is notified to the survey component output unit 505 (step S19). Details of step S19 will be described later.

  Next, when the requested component output unit 505 receives the request ID from the re-investigated component detection unit 504, the table 5225 associated with the requested ID and registered in the requested component registration unit 522 is read and checked. The expiry date of the investigation report registered in the field 5216 of the record 5215 having the request ID in the request registration unit 521 is read out. Then, the response request data having the read table 5225 and the expiry date of the investigation report is generated and transmitted to the response request support apparatus 6 via the network IF unit 560 (step S20). Then, it returns to step S11.

  In addition, the survey state monitoring unit 506 periodically accesses the purchased part DB device 3, and for each record 5220 registered in the surveyed part registration unit 522, the chemical substance data of the purchased part is stored in the purchased part DB device 3. It is checked whether it is registered in the content storage unit 304. Then, the investigation result is reflected in the flag of the field 5224 of each record 5220 registered in the investigation required component registration unit 522 (step S21). Details of step S21 will be described later.

  In addition, the coverage calculation unit 507 periodically performs a chemistry for which an investigation is requested for a purchased part constituting a target product of the investigation request for each investigation request in which the record 5210 is registered in the investigation request registration unit 512. Calculate the coverage of the survey request unit indicating the proportion of purchased parts whose substances have been surveyed. Then, the calculated survey request unit coverage is notified to the survey report creating unit 508 together with the request ID of the survey request (step S22). Details of step S22 will be described later.

  Further, the survey report creation unit 508 periodically determines whether or not there is a survey request that has become the survey report creation timing. Specifically, when the survey request unit coverage rate received together with the survey request request ID from the cover rate calculation unit 507 is equal to or greater than a predetermined threshold, the survey request identified by the request ID is the timing at which the survey report is created. Judge that it became. Also, when a survey report creation instruction with a request ID designation is received from the input device via the input / output unit 540, it is determined that the survey request specified by the designated request ID has reached the survey report creation timing. To do. In addition, in the survey request registration unit 521, a flag indicating that no survey has been reported is registered in the field 5216, and the number of days from the present to the reporting deadline registered in the field 5215 is less than a predetermined threshold. If the record 5210 is registered, it is determined that the survey request specified by the request ID registered in the field 5211 of the record 5210 has reached the creation timing of the survey report (step S23).

  Then, if the survey report creation unit 508 detects a survey request that has become the survey report creation timing (YES in step S23), the survey report creation unit 508 creates survey report data of the survey request and outputs it via the input / output unit 540. Output from the apparatus (step S24). Then, it returns to step S11.

  Specifically, the survey report creation unit 508 reads the part number (field 5213) and chemical substance of the target product of the survey request from the record 5210 of the survey request registration unit 521 having the request ID of the survey request for which the survey report is to be created. The substance number list (field 5214) is read out. Further, the part number of each purchased part is read out from the record 5230 having the part number of the target product of the investigation request in the purchased part storage unit 523. Next, the survey report creation unit 508 accesses the purchased parts DB device 3 via the network IF unit 560. Then, the following processing is performed for the read part number of each purchased part. First, the purchaser ID and purchaser model number corresponding to the part number are specified using the purchaser storage unit 302, and all records 3041 having the specified purchaser ID and purchaser model number are read from the content storage unit 304. . In the read record 3041, it is checked whether or not the substance number of the chemical substance registered in the field 3044 is registered in the substance number list of the chemical substance of the target product of the survey request. Selected for investigation report target record. Then, the survey report creation unit 508 creates survey report data including information on the survey report target record selected for each purchased part of the target product of the survey request, and outputs this from the output device via the input / output unit 540. .

  Further, when the input / output unit 540 receives from the user an instruction for calculating the coverage ratio of the product unit indicating the ratio of the purchased parts whose chemical substances have already been investigated with respect to the purchased parts constituting the product, from the user (step). In S25, YES, the cover ratio calculation unit 507 accepts the designation of the product, calculates and outputs the product unit cover ratio of the designated product (Step S26). Then, it returns to step S11. Similarly, when the input / output unit 540 receives from the user an instruction to calculate the coverage ratio of the purchaser unit indicating the response rate to the chemical substance survey of the purchaser of the purchased parts from the user (YES in step S27). The cover rate calculation unit 507 receives the designation of the purchase destination, calculates and outputs the purchase unit unit coverage of the designated purchase destination (step S28). Then, it returns to step S11. Details of steps S26 and S28 will be described later.

  FIG. 11 is a flowchart for explaining the processing in S17 of FIG. 10 (purchased part identification processing). First, the purchased component identification unit 502 adds a new record 5230 to the purchased component registration unit 523, and registers the component number of the target product for the survey request in the field 5231 of the record 5230 (step S171). Next, the purchased component identification unit 502 accesses the component configuration DB apparatus 2 via the network IF unit 560, and records the record 2031 in which the part number of the target product for the survey request is registered in the field 2032 as the parent component. A search is performed from the relationship storage unit 203 (step S172).

  Next, for each part number registered in the field 2033 of the searched record 2031, the purchased part specifying unit 502 stores a part record 2031 in which the part number is registered in the field 2032 as a parent part. Further searching is performed from the section 203, and the record 2031 having no part number registered in the field 2033 is detected from the further searched records 2031. When the part number is not registered in the field 2033 of the record 2031, the part having the part number registered in the field 2032 of the record 2031 is a terminal part having no child parts and is purchased from the outside. . Therefore, this part number is registered in the field 5232 of the record 5230 added in step S171 as the part number of the purchased part (step S173).

  Next, has the purchased part identification unit 502 registered the part number registered in the field 2032 as the part number of the purchased part in the record added in step S171 for all the records 2031 further detected in step S173? Whether or not is checked (step S174). If there is an unregistered record 2031 (NO in step S1174), the record 2031 whose part number registered in the field 2033 of this record 2031 is registered in the field 2032 as a parent part is stored in the parent-child relationship storage unit. Search from 203 (step S175), and then the process returns to step S172. If there is no record 2031 that is not registered (YES in step S174), the request ID of the survey request and the part number of the target product of the survey request are notified to the unexamined component detection unit 503, and this flow ends. .

  FIG. 12 is a flowchart for explaining the processing in S18 of FIG. 10 (processing for detecting an uninvestigated purchased part). First, the uninvestigated component detection unit 503 registers a new table 5225 in the survey required component registration unit 523 in association with the request ID of the survey request received from the purchased component identification unit 502 (step S181).

  Next, the uninvestigated part identification unit 503 searches the purchase part registration unit 523 for a record 5230 in which the part number of the target product of the survey request received from the purchase part identification unit 502 is registered in the field 5231. The part number of an unfocused purchased part is read from the field 5232 of 5230, and this is set as the attention number (step S182). Then, the uninvestigated part specifying unit 503 accesses the purchased parts DB device 3 via the network IF unit 560, and specifies the purchaser ID and purchaser model number corresponding to the attention number using the purchaser storage unit 302 ( Step S183). Then, it is checked whether or not the content record 3041 of the chemical substance having the specified purchaser ID and purchaser model number is stored in the content storage unit 304 (step S184).

  In step S184, when the record 3041 having the purchaser ID and purchaser model number corresponding to the attention number is not stored in the content storage unit 304 (NO in step S184), the uninvestigated part specifying unit 503 determines in step S181. A new record 5220 is added to the table 5225 corresponding to the registered request ID of the survey request. Then, in the fields 5221 and 5222 of this record, the purchaser ID and the purchaser model number corresponding to the attention number are stored. In the field 5223, the survey request received from the purchased component identification unit 502 registered in the survey request registration unit 521. A list of chemical substance numbers registered in the field 5214 of the record 5210 having the request ID of, and a flag indicating that the content of the chemical substance is unanswered from the purchase part purchaser in the field 5224 Registration is performed (step S185). Then, the process proceeds to step S187. On the other hand, when the record 3041 having the purchaser ID and purchaser model number corresponding to the attention number is stored in the content storage unit 304 in step S184 (YES in step S184), the uninvestigated part identification unit 503 The purchased part having the number is specified as the investigated part (step S186). Then, the process proceeds to step S187.

  In step S 187, the uninvestigated part identification unit 503 displays all the parts registered in the field 5232 of the record 5230 in which the part number of the target product of the survey request received from the purchased part identification unit 502 is registered in the field 5231. It is checked whether or not the number is an attention number. If all the part numbers are not set as the attention numbers, the process returns to step S182. On the other hand, if all the part numbers are the attention numbers, the part number of the surveyed part identified in step S186 is sent to the re-survey part detection unit 504 together with the request ID of the survey request and the part number of the target product of the survey request. Notify and end this flow.

  FIG. 13 is a flowchart for explaining the processing in S19 of FIG. 10 (detection processing of purchased parts that require re-investigation). First, the re-investigation part detection unit 504 searches the investigation request registration part 521 for the record 5210 having the request ID of the investigation request received from the uninvestigated part detection unit 503, and is registered in the field 5214 of the record 5210. A list of substance numbers of the existing chemical substances is obtained (step S191).

  Next, the re-investigation part identification unit 504 selects one unnotified part number from the part numbers of the investigated parts received from the uninvestigated part identification unit 503, and sets this as the attention number (step S192). Then, the reinvestigation part specifying unit 504 accesses the purchased parts DB device 3 via the network IF unit 560 and uses the purchase destination storage unit 302 to specify the purchaser ID and purchaser model number corresponding to the attention number ( Step S193). Then, all of the chemical substance content records 3041 having the specified purchaser ID and purchaser model number are read from the content storage unit 304. Next, the re-investigation part specifying unit 504 determines whether or not all the substance numbers listed in the substance number list of the chemical substance obtained in step S191 are registered in the field 3044 of any of the read records 3041. It investigates (step S194).

  If all the substance numbers listed in the substance number list of the chemical substance are registered in the field 3044 of any of the records 3041 that have been read (YES in step S194), it is determined that re-investigation is unnecessary, and step S196 Proceed to

  On the other hand, if a substance number not registered in the field 3044 of any of the read records 3041 is in the substance number list of the chemical substance (NO in step S194), the investigated part having the attention number is set as the re-investigation part. Then, a new record 5220 is added to the table 5225 corresponding to the request ID of the survey request received from the unexamined component identifying unit 503 registered in the survey required component registration unit 522. Next, in the fields 5221 and 5222 of this record, the purchaser ID and purchaser model number corresponding to the attention number are stored. In the field 5223, among the substance numbers listed in the substance number list of the chemical substance obtained in step S191. , The substance number not registered in the content record 3041 having the purchaser ID and purchaser model number corresponding to the attention number, and the content of the chemical substance in the field 5224 is unanswered from the purchaser of the purchased part. A flag indicating the presence is registered (step S195). Then, the process proceeds to step S196.

  In step S196, the re-investigation part detection unit 504 checks whether or not the part numbers of all the investigated parts received from the uninvestigated part detection unit 503 are the attention numbers. If all the part numbers are not set as the attention numbers, the process returns to step S192. On the other hand, when all the part numbers are set as the attention numbers, the request ID of the investigation request is notified to the investigation necessary part output unit 505, and this flow is finished.

  FIG. 14 is a flowchart for explaining the process (investigation state monitoring process) in S21 of FIG. First, the survey state monitoring unit 506 pays attention to the unfocused table 5225 among the tables 5225 registered in the survey required component registration unit 522, and sets this as the focus table (step S211).

  Next, the survey state monitoring unit 506 pays attention to the record 5220 in which the flag indicating unanswered is registered in the field 5224 among the records 5220 registered in the attention table and is not attention. This is the record of interest (step S212).

  Then, the survey state monitoring unit 506 accesses the purchased parts DB device 3 via the network IF unit 560, and all the substance numbers listed in the substance number list of the chemical substances registered in the field 5223 of the record of interest. Is checked whether or not the record 3041 having the purchase destination ID and purchase destination model number registered in the fields 5221 and 5222 of the record of interest is stored in the content storage unit 304 (step S213). If registered, the flag registered in the field 5224 of the record of interest is changed from a flag indicating unanswered to a flag indicating answered (S214), and then the process proceeds to step S215. On the other hand, if not registered, the process immediately proceeds to step S215.

  In step S215, the investigation state monitoring unit 506 checks whether or not all the records 5220 in the attention table are noticed. If not, the process returns to step S212, and if attention is paid, the process proceeds to step S216.

  In step S216, the investigation state monitoring unit 506 checks whether or not all the tables 5225 registered in the investigation required component registration unit 522 have been noticed, and if not, returns to step S211. On the other hand, if attention is paid, a survey unit cover ratio calculation instruction is output to the cover ratio calculation unit 507, and this flow ends.

  FIG. 15 is a flowchart for explaining the processing (investigation unit coverage calculation processing) in S22 of FIG. First, the cover rate calculation unit 507 is a record 5210 registered in the survey request registration unit 521, which is a record 5210 in which a flag indicating an unreported survey is registered in the field 5216, and an unfocused record 5210. Attention is made to be a noted record (step S221).

  Next, the cover ratio calculation unit 507 specifies the table 5225 registered in the investigation required component registration unit 522 in association with the request ID registered in the field 5211 of the record of interest, and further registers in the table 5225. The number of records 5220 that are registered and have a flag indicating unanswered in the field 5224 is measured (step S222). Further, the cover ratio calculation unit 507 identifies the record 5230 in which the part number registered in the field 5213 of the record of interest is registered in the field 5231 from the purchased parts storage unit 523 and registers the record 5230 in the field 5232 of the record 5230. The number of part numbers of purchased parts that have been purchased is measured (step S223).

  Then, the coverage calculation unit 507 calculates the survey unit coverage using the number of records 5220 measured in step S222 and the number of part numbers of purchased parts measured in step S223 (step S224). When the number of records 5220 measured in step S222 is N1, and the number of part numbers of purchased parts measured in step S223 is N2, the survey unit coverage ratio = (N2-N1) / N2. Thereafter, the cover ratio calculation unit 507 notifies the survey report creation unit 508 of the calculated survey unit cover ratio together with the request ID registered in the field 5211 of the record of interest (step S225). At this time, the data may also be output to the output device via the input / output unit 540.

  Now, the cover rate calculation unit 507 determines whether or not all the records 5210 registered in the field 5216 with the flag indicating that the survey has not been reported among the records 5210 registered in the survey request registration unit 521 have been noticed. If no attention is paid, the process returns to step S221. On the other hand, when attention is paid, this flow is ended (step S226).

  FIG. 16 is a flowchart for explaining the processing in S26 of FIG. 10 (product unit cover ratio calculation processing). First, the cover rate calculation unit 507 displays an information input screen on the display device via, for example, the input / output unit 540, and receives a product part number for calculating the product unit coverage from the input device via the input / output unit 540. (Step S261).

  Next, the cover ratio calculation unit 507 performs the same processing as the processing of the purchased component specifying unit 502 shown in S172 to S175 of FIG. 11 on the component number received in step S261, and receives the component received in step S261. Identify purchased parts for products with numbers. Then, the number of purchased parts is measured (step S262).

  Next, the cover ratio calculation unit 507 performs the same processing as the processing of the unexamined component detection unit 503 shown in S182 to S187 of FIG. 12 for the component number received in step S261, and receives it in step S261. Of the purchased parts of the product with the part number, unexamined parts that have not been investigated for chemical substances are detected. Then, the number of uninvestigated parts is measured (step S263).

  Then, the cover ratio calculation unit 507 calculates the product unit cover ratio using the number of purchased parts measured in step S262 and the number of uninspected parts measured in step S263 (step S264). When the number of purchased parts is M2 and the number of uninvestigated parts is M1, the product unit coverage rate is (M2−M1) / M2. Thereafter, the cover ratio calculation unit 507 outputs the calculated cover ratio of the product unit to the output device via the input / output unit 540.

  FIG. 17 is a flowchart for explaining the processing in S28 of FIG. 10 (purchase unit cover rate calculation processing). First, the cover rate calculation unit 507 displays an information input screen on the display device via, for example, the input / output unit 540, and purchases the purchased parts from which the purchaser unit cover rate is calculated from the input device via the input / output unit 540. At least one ID is received (step S281).

  Next, the cover rate calculation unit 507 pays attention to the unfocused purchaser ID among the purchaser IDs received in step S281 (step S282), and from all the tables 5225 registered in the investigation required component registration unit 522. The record 5220 in which the noticed purchaser ID is registered in the field 5222 is searched, and the number of records is measured (step S283). Also, from all the tables 5225 registered in the investigation required component registration unit 522, a record 5220 in which the attention purchaser ID is registered in the field 5222, and a flag indicating that a response has been completed is registered in the field 5224. The recorded record 5220 is searched and the number of records is measured (step S284).

  Then, the cover ratio calculation unit 507 calculates the purchaser unit cover ratio using the number of records measured in step S283 and the number of records measured in step S284 (step S285). When the number of records measured in step S283 is L2, and the record measured in step S284 is L1, the purchaser unit coverage is L1 / L2.

  Next, the coverage calculation unit 507 checks whether or not all the purchaser IDs received in step S281 have been noticed (step S286). When not paying attention, the process returns to step S282. On the other hand, if attention is paid, a ranking table is created in which the customer unit unit coverage for each purchaser ID received in step S 281 is arranged in order of high or low, and this is input via the input / output unit 540. Output from the output device (step S287).

  Returning to FIG. 1, the description will be continued. The response request support device 6 transmits the response request data received from the survey support device 5 to the supplier terminal 8. FIG. 18 is a schematic configuration diagram of the response request support apparatus 6. As shown in the figure, the network IF unit 601 for connecting to the networks 7 and 9, the response request data storage unit 602 for storing the response request data received from the survey support device 5, and the addresses of the supplier terminals of each purchase destination It has a supplier terminal address storage unit 603 for storing and a request processing unit 604.

  Upon receiving the response request data from the survey support device 5 via the network IF unit 601, the request processing unit 604 stores this in the response request data storage unit 602. Further, the records 5220 included in the table 5225 (see FIG. 9B) included in the response request data are grouped for each customer ID. Then, the grouped record 5220 is associated with the customer terminal ID of the group and the address of the supplier terminal 8 stored in the supplier terminal address storage unit 603, together with the report deadline included in the response request data. Send.

  Each of the devices 2 to 6 constituting the component management system 1 having the above configuration includes, for example, a CPU 901, a memory 902, an external storage device 903 such as an HDD, a CD-ROM, a DVD-ROM, and the like as shown in FIG. General equipped with a reading device 905 for reading information from a portable storage medium 904, an input device 906 such as a keyboard and a mouse, an output device 907 such as a display, and a communication device 908 for connecting to a communication network In a typical computer system, it can be realized by the CPU 901 executing a predetermined program loaded on the memory 902.

  The predetermined program is downloaded from the storage medium 904 via the reading device 905 or from the network via the communication device 908 to the external storage device 903, and then loaded onto the memory 902 and executed by the CPU 901. You may do it. Further, the program may be directly loaded on the memory 902 from the storage medium 904 via the reading device 905 or from the network via the communication device 908 and executed by the CPU 901. In this case, the memory 902, the external storage device 903, and the storage medium 904 are used for the storage unit, and the communication device 908 is used for the network IF unit.

  Next, an outline of the operation from reception of a survey request to creation of a survey report of the component management system 1 having the above configuration will be described. FIG. 20 is a flowchart for explaining the outline of the operation from the reception of the survey request of the parts management system 1 to the creation of the survey report.

  When the survey support apparatus 5 receives a survey request instruction from the user, the survey support device 5 executes steps S12 to S14 in FIG. That is, the customer ID and the part number of the investigation target product are received from the user, and a list of substance numbers of chemical substances requested by the customer having the customer ID from the customer DB device 4 is obtained. Then, based on these pieces of information, survey request data is created and registered (step S501).

  Moreover, when the survey support apparatus 5 receives a survey start instruction from the user, the survey support device 5 first executes steps S16 and S17 in FIG. That is, the request ID is received from the user, and information on the purchased parts of the target product of the survey request specified by the request ID is obtained from the part configuration DB apparatus 2 (step S502). Next, step S17 in FIG. 10 is executed, and information on uninvestigated parts is obtained from the purchased parts DB device 3 (step S503). Further, step S18 of FIG. 10 is executed, and information on the reinvestigation part is obtained from the purchased part DB device 3 (step S504).

  Then, the survey support apparatus 5 executes step S20 of FIG. 10, creates response request data using information on the non-survey parts and the re-survey parts, and transmits the response request data to the response request support apparatus 6. In response, the response request support apparatus 6 transmits the response request data to the supplier terminal 8 from which the uninvestigated parts and the reinvestigated parts are purchased (step S505).

  Now, the purchaser of uninvestigated parts and re-investigated parts prepares the content data of the chemical substances to be investigated that contain these parts according to the response request data, and purchases them using the supplier terminal 8 Registration in the component DB apparatus 3 (step S506).

  On the other hand, the survey support apparatus 5 periodically executes S21 and S22 of FIG. 10 to update the flag registered in the field 5224 of each record 5220 registered in each table 5225 of the survey component registration unit 522 required. Then, the survey unit coverage is calculated (S507). Then, S24 in FIG. 10 is executed for a survey request whose survey unit coverage is equal to or higher than a predetermined threshold value, and a survey report is created (step S507).

  The embodiment of the present invention has been described above.

  In the present embodiment, the survey support apparatus 5 selects a chemical substance of a purchased part whose content data of the chemical substance to be surveyed is not stored in the purchased part DB apparatus 3 among the purchased parts constituting the target product for the survey request. Identify. And the reply request | requirement of content of the specified chemical substance is transmitted to the purchase place of the specified purchase parts. As described above, according to the present embodiment, the chemical substance of the purchased part that really needs to be investigated can be identified, so the chemical substance content response request is repeatedly transmitted to the purchaser of the purchased part. You can avoid it.

  In addition, this invention is not limited to said embodiment, Many deformation | transformation are possible within the range of the summary.

  For example, in the above-described embodiment, each of the devices 2 to 6 constituting the parts management system 1 is constructed using different computers, but the present invention is not limited to this. Two or more devices constituting the component management system 1 may be constructed using one computer, or one device constituting the component management system 1 may be constructed using a plurality of computers. I do not care.

FIG. 1 is a schematic diagram of a parts management system to which an embodiment of the present invention is applied. FIG. 2 is a schematic configuration diagram of the component configuration DB apparatus 2. 3A is a schematic diagram of the part configuration table, FIG. 3B is a diagram showing an example of registered contents of the part number storage unit 202, and FIG. 3C is a diagram of the parent-child relationship storage unit 203. It is a figure which shows the example of registration content. FIG. 4 is a schematic configuration diagram of the purchased parts DB device 3. FIG. 5A is a diagram showing an example of registered contents in the purchase destination storage unit 302, FIG. 5B is a diagram showing an example of registered contents in the substance number storage unit 303, and FIG. It is a figure which shows the example of registration content of the content memory | storage part. FIG. 6 is a schematic configuration diagram of the customer DB device 4. FIG. 7 is a diagram illustrating an example of registered contents in the customer storage unit 402. FIG. 8 is a schematic configuration diagram of the survey support apparatus 5. FIG. 9A is a diagram showing an example of registered contents of the survey request registering unit 521, FIG. 9B is a diagram showing an example of registered contents of the investigation required component registering unit 522, and FIG. FIG. 5 is a diagram showing an example of registration contents of a purchased parts registration unit 523. FIG. 10 is a flowchart for explaining the operation of the survey support apparatus 5. FIG. 11 is a flowchart for explaining the processing in S17 of FIG. 10 (purchased part identification processing). FIG. 12 is a flowchart for explaining the processing in S18 of FIG. 10 (processing for detecting an uninvestigated purchased part). FIG. 13 is a flowchart for explaining the processing in S19 of FIG. 10 (detection processing of purchased parts that require re-investigation). FIG. 14 is a flowchart for explaining the process (investigation state monitoring process) in S21 of FIG. FIG. 15 is a flowchart for explaining the processing (investigation unit coverage calculation processing) in S22 of FIG. FIG. 16 is a flowchart for explaining the processing in S26 of FIG. 10 (product unit cover ratio calculation processing). FIG. 17 is a flowchart for explaining the processing in S28 of FIG. 10 (purchase unit cover rate calculation processing). FIG. 18 is a schematic configuration diagram of the response request support apparatus 6. FIG. 19 is a diagram illustrating a hardware configuration example of each of the devices 2 to 6 constituting the component management system 1. FIG. 20 is a flowchart for explaining the outline of the operation from the reception of the survey request of the parts management system 1 to the creation of the survey report.

Explanation of symbols

  1: parts management system, 2: parts configuration DB device, 3: purchased parts DB device, 4: customer DB device, 5: survey support device, 6: response request support device, 7: network, 8: supplier terminal, 9: Network: 201: Network IF unit, 202: Part number storage unit, 203: Parent-child relationship storage unit, 204: Storage control unit, 301: Network IF unit, 302: Purchase destination storage unit, 303: Substance number storage unit, 304: Content storage unit, 305: storage control unit, 401: network IF unit, 402: customer storage unit, 403: storage control unit, 500: calculation unit, 501: survey request receiving unit, 502: purchased part specifying unit, 503: Unexamined part detection unit, 504: Reexamination part detection part, 505: Investigation part required output part, 506: Investigation state monitoring part, 507: Cover rate calculation part, 508: Investigation report 520: storage unit, 521: survey request registration unit, 522: survey component registration unit, 523: purchased component registration unit, 540: input / output unit, 560: network IF unit, 601: network IF unit, 602: Answer request data storage unit 603: Supplier terminal address storage unit 604: Request processing unit

Claims (9)

A parts management system for managing chemical substance information of purchased parts,
A component configuration storage unit that stores the component configuration table data of each product;
Purchased part storage unit storing the purchaser data and chemical substance content data of each part,
And a survey support department that supports surveys on the content of chemical substances in products,
The survey support department
Investigation part storage means that stores information on parts that require chemical investigation,
A survey request receiving means for receiving an input of a survey request including identification information of a survey target product and a list of survey target chemical substances;
A purchased part that identifies a purchased part of the product using the part structure table data of the product having identification information included in the survey request received by the survey request receiving unit, stored in the part configuration storage unit Specific means,
Among the purchased parts specified by the purchased part specifying means, a purchased part in which the chemical substance content data is not stored in the purchased part storage unit is detected, and the detected purchased part is set as an uninvestigated part. Together with a list of chemical substances contained in the survey request received by the purchase request data and the survey request accepting means, and an unsurveyed part detection means for storing in the survey required parts storage means,
Included in the survey request received by the survey request accepting means for each of the purchased parts identified by the purchased part identifying means and having the chemical substance content data stored in the purchased parts storage unit It is checked whether or not the content data of all chemical substances listed in the list of chemical substances being stored is stored in the purchased part storage unit. Of the chemical substances included in the list of chemical substances included in the purchase request data and the survey request received by the survey request receiving means, content data is stored in the purchased parts storage unit. Re-investigation part detection means for storing in the investigation required part storage means together with a non-chemical substance,
A component management system, comprising: a survey component output unit that outputs data of purchased components stored in the survey component storage unit by the unsurveyed component detection unit and the re-survey component detection unit. The component management system according to claim 1,
The survey support department
It is checked whether content data is stored in the purchased parts storage unit for the chemical substances of the purchased parts stored in the required parts storage means. Survey state monitoring means for assigning a flag indicating that a survey has been completed to the stored chemical substance of the purchased part,
Using the number of purchased parts specified by the purchased parts specifying means and the number of purchased parts in which the flag is not given to any chemical substance among the purchased parts stored in the investigation required parts storage means A coverage ratio calculating means for calculating a survey request coverage ratio indicating a ratio of purchased parts for which content data of chemical substances listed in the list included in the survey request has been obtained;
When the survey request coverage rate is equal to or higher than a predetermined value, the purchased component storage unit stores the content data of the chemical substance listed in the survey request list of the purchased components specified by the purchased component specifying means. The component management system further comprising: report data creating means for reading out from the report and creating and outputting report data for the survey request. The component management system according to claim 2,
The coverage calculating means causes the purchased parts specifying means to specify purchased parts constituting the specified product, and stores the purchased parts among the purchased parts constituting the product and the number of purchased parts constituting the product. A part management system that calculates a product coverage ratio indicating the ratio of purchased parts for which chemical substance content data has been obtained, using the number of purchased parts stored in the department. The component management system according to claim 2 or 3,
The coverage calculating means is associated with the purchaser data of the designated purchaser, and the number of purchased part chemical substances stored in the required parts storage means and the chemical substances of the purchased parts among the chemical substances A parts management system, wherein a purchaser cover ratio indicating a ratio of responses from the purchaser is calculated using the number of chemical substances of the purchased parts to which a flag is attached. The component management system according to claim 4,
The coverage calculation means calculates a purchaser cover rate indicating a ratio of responses from the purchaser for each of the specified purchasers, and sets the purchaser cover rate for the specified purchasers. A parts management system characterized by generating ranking table data based thereon. A component management system according to any one of claims 1 to 5,
It further has a response request support unit that supports a response request for chemical substance content data to the purchaser of the purchased parts,
The response request support unit
Address storage means for storing the address of the terminal for each purchase destination data,
The data of the purchased product output from the investigation required component output means is transferred to the terminal having the address stored in the address storage means in association with the purchase destination data included in the data via the network. And a response request transmission means for transmitting the component management system. The component management system according to any one of claims 1 to 6,
The purchased parts storage unit
A parts management system characterized by storing parts purchaser data and chemical substance content data received from a terminal via a network. A parts management method in which a computer manages chemical substance information of purchased parts,
A survey request receiving step for receiving a survey request including the identification information of the survey target product and a list of chemical substances to be surveyed from the input device;
From the component configuration storage unit storing the component configuration table data of each product, the component configuration table data of the product having the identification information included in the survey request received in the survey request receiving step is read, and the read data is Using a purchase part identification step for identifying a purchase part of the product,
Of the purchased parts identified in the purchased parts identification step, purchased parts in which no chemical substance content data is stored in the purchased parts storage unit in which the purchase destination data and chemical substance content data of each part are stored The unpurchased part is stored in the storage device together with the purchase destination data of the purchased part and the list of chemical substances included in the survey request received in the survey request receiving step. A component detection step;
Included in the survey request received in the survey request accepting step for each of the purchased components identified in the purchased component identifying step and having the chemical substance content data stored in the purchased component storage unit It is checked whether or not the content data of all chemical substances listed in the list of chemical substances being stored is stored in the purchased part storage unit. Among the chemical substances listed in the purchaser data of the purchased parts and the chemical substances included in the survey request received in the survey request receiving step, content data is stored in the purchased parts storage unit A re-examination part detection step stored in the storage device together with a non-chemical substance;
A component management method comprising: performing an unrequired component output step of outputting data of purchased components stored in the storage device to the output device by the uninvestigated component detection step and the re-inspection component detection step. A computer readable program for managing chemical substance information of purchased parts,
A survey request receiving step for receiving a survey request including the identification information of the survey target product and a list of chemical substances to be surveyed from the input device;
From the component configuration storage unit storing the component configuration table data of each product, the component configuration table data of the product having the identification information included in the survey request received in the survey request receiving step is read, and the read data is Using a purchase part identification step for identifying a purchase part of the product,
Of the purchased parts identified in the purchased parts identification step, purchased parts in which no chemical substance content data is stored in the purchased parts storage unit in which the purchase destination data and chemical substance content data of each part are stored The unpurchased part is stored in the storage device together with the purchase destination data of the purchased part and the list of chemical substances included in the survey request received in the survey request receiving step. A component detection step;
Included in the survey request received in the survey request accepting step for each of the purchased components identified in the purchased component identifying step and having the chemical substance content data stored in the purchased component storage unit It is checked whether or not the content data of all chemical substances listed in the list of chemical substances being stored is stored in the purchased part storage unit. Among the chemical substances listed in the purchaser data of the purchased parts and the chemical substances included in the survey request received in the survey request receiving step, content data is stored in the purchased parts storage unit A re-examination part detection step stored in the storage device together with a non-chemical substance;
A computer which causes the computer to execute an unrequired parts detection step of outputting the purchased parts data stored in the storage device to the output device by the unsurveyed parts detection step and the re-survey parts detection step. Readable program.

Images