JP4256815B2 - Data management method in chemical substance content data management device - Google Patents

Description

The present invention relates to a data management method in a chemical substance content data management apparatus that manages the content of chemical substances contained in parts included in products that are subject to restriction on the use of chemical substances.

The following methods are known as methods for managing product information.
The first method is to check the maintenance status and the like by reading maintenance information indicating the maintenance status of the product stored in the product itself (see, for example, Patent Document 1).
Second, for each product, a series of transactions from manufacture to disposal of the product is performed by associating and storing a part ID of a part constituting the product and information indicating whether the part is harmful when the part is discarded. (See, for example, Patent Document 2). Although managed by the design change date in FIG. 7 of Patent Document 2, this represents a design change for the product, and by this, different IDs are assigned to the components and managed as different components.
Third, it is a method of evaluating the environmental impact of manufacturing a product by storing the recycling classification of parts contained in the product, material composition, specific chemical substances, etc. in a database (for example, (See Patent Document 3).
Fourth, there is a method in which product distribution management is performed by attaching a sticker with a barcode and a non-contact ID tag embedded on the product (see, for example, Patent Document 4).
Fifth, it is a method of confirming the number of members to be delivered by reading the member information printed on the delivery note (see, for example, Patent Document 5).
Japanese Patent Laid-Open No. 10-222568 (paragraphs 0006-0007, FIG. 1) JP 2000-48066 A (paragraphs 0049-0052, 0084, FIG. 7) JP 2002-215775 A (paragraphs 0061-0064, FIG. 4-7) JP 2001-5931 A (paragraphs 0012-0014, FIGS. 1-3) JP 2002-92434 A (paragraph 0026, FIG. 2)

However, the methods disclosed in Patent Documents 1 to 5 described above have a problem in that it is not possible to more accurately grasp the content of chemical substances contained in products subject to restriction on the use of specific hazardous substances. there were. The use restriction command is, for example, RoHS (Restriction of Use of Certain Substances in Electrical and Electronic Equipment), and here, six chemical substances such as lead are designated as specific hazardous substances.
And when grasping the content situation of the above-mentioned chemical substance more accurately, even if it is the same part, there are cases where the content of the chemical substance is different due to different production lots, etc. It is strongly desired to accurately grasp the chemical substance content.

Therefore, the present invention has been made to solve the above-mentioned problems, and its purpose is to more accurately grasp the content of chemical substances contained in products subject to use restriction orders. It is to provide a data management method in a chemical substance content data management apparatus.

In order to solve the above-mentioned problem, the method of the present invention stores the correspondence between the identification information given to the delivered item and the revision of the part regarding the part included in the product subject to the chemical substance use restriction command. The identification information management unit, the chemical substance content data management unit that stores the content data of the chemical substance contained in the part for each part and each revision, and the delivery for a specific part A revision specifying unit that specifies the revision corresponding to the identification information read by the orderer reading device that reads the identification information from the identification information management unit, and a revision of the specific part specified by the revision specifying unit. The chemical substance content data management unit retrieves the content data of the chemical substance in question, and the content data of the retrieved chemical substance is A data management method in the chemical substance content data management apparatus and a content data providing unit that provides the orderer terminal for each according to the object parts.

  According to the present invention, the chemical substance content data corresponding to the revision is provided, so that the chemical substance content status included in the product subject to the use restriction command can be grasped more accurately.

  Hereinafter, the “chemical substance-containing data management device”, “chemical substance-containing data management program”, and “computer-readable recording medium on which this is recorded”, which are the best modes for carrying out the present invention, will be described.

FIG. 1 is a block diagram showing the entire system including the chemical substance content data management apparatus of the present invention. Here, a transaction between an orderer of a part (memory or the like) included in a product (server or the like) subject to a use restriction command will be described as an example.
In FIG. 1, a chemical substance content data management device (hereinafter simply referred to as “management device”) 10 is connected to an orderer terminal 30 and a supplier terminal 40 via a communication network 20 such as the Internet.

  This will be described more specifically. A local area network (LAN) 41 is connected to the customer terminal 40, and data communication between the customer terminal 40 and the management apparatus 10 is realized through the LAN 41 and the communication network 20. On the LAN 41, a reading device (reading device for business partner) 42 for a chip ID (identification information) given to the delivery note (delivery item) 50 is connected.

The delivery note 50 is one of deliverables to be delivered by the business partner to the orderer, and is sent to the orderer together with one part (delivery part) related to the delivery note 50. Note that there are delivered parts themselves as deliverables other than the delivery note 50.
An IC chip is attached to the delivery note 50, and a unique chip ID is recorded on each IC chip.
For this reason, there is a one-to-one correspondence between the parts associated with the delivery note 50 and the chip ID assigned to the delivery note 50, and the orderer side assigns the chip ID of the IC chip mounted on the delivery note 50. By using this, it is possible to uniquely identify the part related to the delivery note 50 to which the chip ID is assigned.

  In the following description, a method for mounting an IC chip on the delivery note 50 will be described as a method for identifying a part related to the delivery note 50, but other different methods may be adopted. For example, a barcode having unique identification information may be attached to the delivery note 50, or an ID tag having unique identification information may be attached to a delivered part. Alternatively, an IC tag with an RFID function may be attached to a delivered part. RFID is an abbreviation for Radio Frequency Identification.

  Further, a LAN 31 is also connected to the orderer terminal 30 of FIG. 1, and data communication between the orderer terminal 30 and the management apparatus 10 is realized through the LAN 31 and the communication network 20. . Also connected to the LAN 31 is a reading device (reading device for orderer) 32 of the chip ID given to the delivery note 50 described above.

  In FIG. 1, the orderer terminal 30 and the reader 32 connected on the LAN 31 are constructed as a system on the orderer side, and the customer terminal 40 and the reader 42 connected on the LAN 41 are It is built as a supplier system. In FIG. 1, the orderer side and the supplier system are each shown as one system, but there may be a plurality of them depending on the circumstances of the transaction. Hereinafter, the management apparatus 10, the supplier system, and the orderer side system will be described in further detail.

[Configuration of management device]
First, the configuration of the management apparatus 10 will be described in detail. As shown in FIG. 1, the management device 10 includes a communication unit 11, an information storage unit 12, and a processing unit 13 that controls them. For example, a web server is used for the management apparatus 10.
The communication unit 11 is an interface such as a network interface.
The information storage unit 12 is a storage device such as a memory or a hard disk. The information storage unit 12 includes a chemical substance content data file (chemical substance content data management unit) 121, a chemical substance name file 122, an order data file (order data management unit) 123, and an identification information file (identification information management unit) 124. In addition, a product-specific component-related data file 125 is stored. Hereinafter, these files 121 to 125 will be described in order.

In the chemical substance content data file 121, as shown in FIG. 2, a part code, a revision, a chemical substance code, and content data are associated with each other. The component code is for identifying a component such as a memory included in the product subject to the use restriction command, and a code such as “B001” is used here.
The revision is given whenever the content of chemical substances contained in a part differs due to the difference in the production lot of the part. Here, “A” indicating the initial revision and the next latest revision are shown. “B” is used. In FIG. 2, only “A” and “B” are shown, but it is assumed that “C” indicating the latest revision next to the revision “B” is also included. The revision can specify a desired part even if the same part is used for the same period. That is, when managed by the production date, if the production periods overlap for different parts, the part cannot be identified from the production date. However, when managed by the revision, the part can be identified by identifying the revision.
The chemical substance code is for identifying, for example, six chemical substances specified by RoHS, that is, cadmium, hexavalent chromium, cyanide, mercury, selenium and lead. Here, a code such as “Y001” is used. It has been.
The content data is data indicating the content of the above-mentioned chemical substance, and here, it is shown as a combination of the content and its unit (such as “0.001 mg”). Also good.

  As shown in FIG. 3, the chemical substance name file 122 is associated with the chemical substance code and the chemical substance name shown in FIG. In FIG. 3, for example, the chemical substance code “Y001” and the chemical substance name “cadmium” are associated with each other.

In the order data file 123, as shown in FIG. 4, the order code, the part code, the quantity, and the chip ID shown in FIG. 2 are associated with each other. The order code is for identifying all the parts ordered by the orderer from the business partner, and the quantity represents the quantity of the part indicated by the part code.
As described above, the chip ID is used to uniquely identify a part related to the delivery note 50, and a code such as “M00001” is used here.

  As shown in FIG. 5, the identification information file 124 is associated with the chip ID shown in FIG. 4 and the revision shown in FIG. By using the correspondence relationship of the identification information file 124, the revision of the part relating to the delivery note 50 is identified. For example, in FIG. 5, since the chip ID “M00001” and the revision “A” are associated with each other, the revision of the part on the delivery note 50 with the IC chip recorded with the chip ID “M00001” is the initial revision “ A ”will be identified.

  As shown in FIG. 6, the product-related component-related data file 125 includes a product code, the above-described component code (see FIGS. 2 and 4), the above-described quantity (see FIG. 4), and the above-described chip ID (see FIG. Are associated with each other. The product code is for identifying a product such as a server produced by the orderer, for example, and a code such as “S0001” is used here.

  Returning to FIG. The processing unit 13 is, for example, a CPU. The processing unit 13 includes a content data registration unit 131, a latest revision extraction unit 132, a revision allocation unit 133, a revision identification unit 134, and a content data provision unit 135. Since these units 131 to 135 are realized by the processing unit 13 operating according to the chemical substance content data management program incorporated in the management device 10, these functions will be described in the operation description to be described later.

  The managed substance-containing data management program described above may be stored in advance in a predetermined area of the information storage unit 12, or may be read from a computer-readable recording medium such as a CD-ROM.

[Partner system configuration]
Next, the configuration of the supplier system will be described in detail. The customer terminal 40 in FIG. 1 is a computer such as a personal computer, and is used by the client of the orderer. Specifically, the supplier terminal 40 is used by a supplier such as a manufacturer that manufactures a part included in a product that is subject to a use restriction command.
The reading device 42 has a printer function in addition to the reading function of the IC chip mounted on the delivery note 50. The printer function is a function for issuing (printing) the delivery note 50.

[System configuration on the orderer side]
Next, the configuration of the system on the orderer side will be described in detail. The orderer terminal 30 in FIG. 1 is a computer such as a personal computer, and is used by an orderer such as a manufacturer of a product subject to a use restriction command. The reading device 32 has a function of reading an IC chip mounted on the delivery note 50.

  Next, various operations of the management apparatus 10 will be described. Here, the content data registration process in the supplier system will be described first.

[Registration process of content data in supplier system]
FIG. 7 is a diagram showing a processing procedure of the supplier terminal 40 and the management apparatus 10 and a procedure related to a registration process of content data of chemical substances contained in parts. Here, the description will be made on the assumption that a trader manufactures a part with a different production lot and calculates the content of a chemical substance contained in the part.
For example, when the business operator logs in to the management apparatus 10 using the business partner terminal 40, the input screen shown in FIG. 8 is displayed on the business partner terminal 40. The input screen in FIG. 8 includes input fields for a part code, revision, chemical substance code, chemical substance name, content, and unit.
Then, the trader uses the customer terminal 40 in the entry field of the part code, chemical substance code, content and unit (chemical substance content data) of the corresponding part in the input screen of FIG. "B001", "Y001", "Y002", "Cadmium", "Hexavalent chromium", "0.0005", "0.001", etc.) are entered, and the registration button is clicked.

  Then, the processing unit 13 of the management device 10 stores the chemical substance (here, “cadmium”, “hexavalent chromium”) associated with the part code and the chemical substance code input by the trader from the supplier terminal 40. The content data (here, “0.0005 mg” and “0.001 mg”) is received via the communication network 20 (S101).

  Next, the processing unit 13 refers to the chemical substance name file 122 in FIG. 3 to determine whether or not a new chemical substance is included in the content data received in S101 (here, chemicals other than the six chemical substances in FIG. 3). (S102), for example, when it is determined that a new chemical substance is included (in the case of “YES” in S102), the communication network 20 To the customer terminal 40 (S103). Here, for example, the processing unit 13 transmits a message requesting input of a chemical substance name to the input screen of FIG. 8 described above.

  As a result, the supplier terminal 40 displays the input screen shown in FIG. 8 with a message requesting the input of the chemical substance name. Then, when the trader uses the customer terminal 40 to associate the new chemical substance name with the chemical substance code and inputs the new chemical substance name on the input screen, the associated new chemical substance name and chemical substance code are set to a predetermined value. At the timing, it is transmitted from the supplier terminal 40 to the management device 10.

  Then, the processing unit 13 of the management apparatus 10 registers the association between the new chemical substance name and the chemical substance code transmitted from the supplier terminal 40 in the chemical substance name file 122 (S104), and proceeds to the next S105.

  On the other hand, in the determination in S102, for example, when it is determined that the content data received in S101 does not contain a new chemical substance (in the case of “NO” in S102), the processing unit 13 proceeds to the next S105. move on.

  In S105, the processing unit 13 refers to the chemical substance content data file 121 of FIG. 2 and determines whether or not the part indicated in the part code received in S101 is a new part (S105). That is, the processing unit 13 determines whether or not the part code received in S101 is registered in the chemical substance containing data file 121 of FIG.

  In the determination in S105, for example, when it is determined as a new part (in the case of “Yes” in S105), the processing unit 13 associates “A” indicating the initial revision with the component code received in S101, The data is registered in the chemical substance content data file 121 (S106: the processing unit 13 at this time is referred to as “content data registration unit 131” shown in FIG. 1). More specifically, the content data registration unit 131 registers the chemical substance code and content data received in S101 in the chemical substance content data file 121 when registering the initial revision.

On the other hand, in the determination in S105, for example, when it is determined that it is not a new part, that is, when it is determined that it is a registered part (in the case of “No” in S105), the processing unit 13 performs the chemical process shown in FIG. With reference to the substance content data file 121, the revision associated with the part code received in S101 is moved up to the next latest revision and registered (S107: the content data shown in FIG. Registration unit 131 "). For example, when the registered revision is the initial revision “A”, the processing unit 13 registers “B” obtained by incrementing “A” as the latest revision. Thus, the chemical substance content data file 121 of FIG. 2 always stores the correspondence between the latest revision and the part code.
To describe S107 in detail, the content data registration unit 131 registers the chemical substance code and content data received in S101 in the chemical substance content data file 121 when registering the latest revision.

  Finally, the processing unit 13 transmits the registration result in S106 or S107 to the customer terminal 40 via the communication network 20, for example, by e-mail (S108).

[Processing for parts delivery in the supplier's system]
Next, processing related to parts delivery in the supplier's system will be described. FIG. 9 is a diagram illustrating a processing procedure of the supplier terminal 40, the reading device 42, and the management device 10 and a processing procedure related to parts delivery. Here, the description will be made on the assumption that the trader requests the management apparatus 10 to transmit his / her order data using the customer terminal 40.

  In S <b> 201, the processing unit 13 of the management apparatus 10 refers to the order data file 123 of FIG. 4 and transmits the order data requested from the supplier terminal 40 to the supplier terminal 40 via the communication network 20. . Here, for example, the processing unit 13 transmits the order code, the part code, and the quantity of FIG. 4 associated with each other as order data.

  Then, the order data transmitted from the management device 10 is displayed on the customer terminal 40. Then, by the operation of the supplier terminal 50 by the supplier, the supplier terminal 40 instructs the reading device 42 through the LAN 41 to issue a delivery slip 50 for each part code included in the order data ( S202).

  In response to the instruction from the customer terminal 40, the reading device 42 issues a delivery slip 50 for each part, and at the same time, the chip ID (IC ID of the IC chip mounted on each delivery slip 50). That is, a new chip ID) is read (S203). The issued delivery note 50 is delivered from the business partner to the orderer together with the corresponding parts.

  Then, the management device 10 receives each chip ID read by the reading device 42 from the reading device 42 via the LAN 41 and the communication network 20 in association with each order data and each part code (S204).

Next, the processing unit 13 refers to the chemical substance content data file 121 of FIG. 2, and the latest revision of the part code associated with each chip ID received in S204, that is, the delivery form 50 instructed in S202. The latest revision associated with the component is extracted (S205: the processing unit 13 at this time is referred to as “latest revision extraction unit 132” shown in FIG. 1). For example, when the part code is “B001”, since “A” and “B” exist as revisions of “B001” in FIG. 2, “B” is extracted as the latest revision of the part code “B001”. It will be.
Before extracting the latest revision, the processing unit 13 refers to the correspondence relationship between the order code and the part code associated with each chip ID for each chip ID received in S204, as shown in FIG. Register in the data file 123.

  Next, the processing unit 13 registers the correspondence between each latest revision extracted in S205 and each chip ID received in S204 in the identification information file 124 in FIG. 5 (S206: the processing unit 13 at this time is changed). (Referred to as “revision allocation unit 133” shown in FIG. 1). Thereby, all the parts concerning each delivery note 50 are uniquely identified using the chip ID.

  Finally, the processing unit 13 notifies the customer terminal 40 by e-mail, for example, of the registration result in S206 via the communication network 20 (S207). As a result, the trader confirms that the chip ID assigned to each delivery note 50 has been registered.

[Process related to retrieval of content data by product in the orderer's system]
Next, processing relating to retrieval of content data by product in the orderer side system will be described. FIG. 10 is a diagram showing a processing procedure of the orderer terminal 30 and the management device 10 and a processing procedure related to display of the product-specific content data.
Here, first, when the orderer produces each product, the reading device 32 reads each chip ID of the IC chip mounted on the delivery sheet 50 of the parts incorporated in each product. Then, the orderer transmits each chip ID for each product code of each product to the management apparatus 10 using the orderer terminal 30, so that the management apparatus 10 can obtain the relevant data file for each product part in FIG. The description will be made on the assumption that 125 is registered.

  For example, when the orderer's terminal 30 is operated, the processing unit 13 of the management apparatus 10 receives the search target product code from the orderer's terminal 30 (S301), and the part code associated with the product code. The quantity and chip ID are extracted (searched) from the product-specific component-specific related data file 12 shown in FIG. 6 (S302).

  Next, the processing unit 13 specifies the revision associated with the extracted chip ID from the identification information file 124 in FIG. 5 (S303: the processing unit 13 at this time is referred to as “revision specifying unit 134” illustrated in FIG. 1). .)

  Next, the processing unit 134 calculates (searches) content data for each corresponding chemical substance from the chemical substance content data file 121 of FIG. 2 based on the part code and quantity extracted in S302 and the revision specified in S303. (S304). In this case, for example, the content of the quantity extracted in S302 is multiplied for each chemical substance code, and the content for each chemical substance is calculated.

Then, the processing unit 13 transmits the content data for each chemical substance calculated in S304 to the orderer terminal 30 via the communication network 20 (S305: the processing unit 13 in S304 and S305 is shown in FIG. The content data providing unit 135 "). Thereby, for example, the display screen shown in FIG. 11 is displayed on the orderer terminal 30. The display screen of FIG. 11 includes a part code, a chemical substance code, a chemical substance name, and content data for the product code. As a result, the orderer can grasp the chemical substance content of parts contained in a certain product.
Moreover, since the content of chemical substances according to the latest revision can be ascertained, it becomes possible to more accurately ascertain the content of chemical substances contained in products subject to use restriction orders.

In addition, although FIG. 10 demonstrated the case where the process part 13 searches the containing data classified by product, you may make it search the containing data about a specific component.
In this case, the revision specifying unit 134 in FIG. 1 specifies the revision corresponding to the chip ID given to the delivery note 50 for the specific part from the identification information file 124 in FIG. Then, the content data providing unit 135 in FIG. 1 searches the chemical content data file 121 in FIG. 2 for content data associated with the revision of the specific part specified by the revision specification unit 134, The content data is provided to the orderer terminal 30 for each part code of the part on the delivery note 50. In this way, the orderer can grasp the chemical substance content according to the revision of each part.

It is a block diagram which shows the whole system containing the chemical substance containing data management apparatus of this invention. It is explanatory drawing which shows the chemical substance containing data file of FIG. It is explanatory drawing which shows the chemical substance name file of FIG. It is explanatory drawing which shows the order data file of FIG. It is explanatory drawing which shows the identification information file of FIG. It is explanatory drawing which shows the part related data file classified by product of FIG. It is a processing procedure of the supplier terminal and the management device of FIG. It is explanatory drawing which shows the input screen displayed on the customer terminal of FIG. FIG. 3 is a diagram illustrating a processing procedure of a supplier terminal, a reading device, and a management device in FIG. It is a process procedure regarding the display of content data classified by product, which is a process procedure of the orderer terminal and the management device of FIG. It is a figure which shows the display screen displayed on the terminal for orderers of FIG.

Explanation of symbols

10 Chemical Substance Content Data Management Device 30 Orderer's Terminal 40 Supplier's Terminal

Claims (3)

An identification information storage unit for storing a correspondence relationship between the identification information given to the delivery of the part included in the product subject to the chemical substance use restriction command and the revision of the part;
For each part code of the part and for each revision, a chemical substance content data storage unit that stores chemical substance content data contained in the part,
A revision that uses the identification information storage unit to identify the revision corresponding to the identification information read by the orderer's reader that reads the identification information given to the delivery of the parts that should identify the contained chemical substances. A specific part,
Search for containing data of chemicals associated with revision of the identified part article by the revision identification unit from the chemical substance content data storage unit, the content data of the found chemicals according each component to the deliverable A content data providing unit to be provided to the terminal for the orderer;
A method for managing data in a chemical substance content data management device comprising:
The chemical substance data management device, as a process when registering content data of chemical substances of the parts,
When receiving a part code and chemical substance content data contained in a part of the part code from a business partner terminal operated by a business partner who is a supplier of the part, the received part code is Judging whether or not it is already registered by comparing with the content stored in the chemical substance content data storage unit,
If the part code is not registered, it is determined that the received part code is a new part code, and an initial revision indicating that the revision is the first is given to the new part code. Issued as the latest revision, updated the chemical substance content data storage unit by performing additional registration to associate the received new part code with the latest revision issued as the initial revision,
If the part code is registered, it is determined that the received part code is a non-new part code, and for the non-new part code, any revision of the part that has already been issued Issue a newer latest revision, update the chemical substance content data storage unit by performing additional registration to associate the received part code with the issued latest revision,
The process of registering the received chemical substance content data in association with the latest revision of the updated chemical substance content data storage unit,
The chemical substance data management device is a process in which a supplier delivers a part with the latest revision to the orderer,
When the identification information given to the delivery and the part code corresponding to the delivery are received from the supplier terminal via a communication line, the latest revision corresponding to the received part code is sent to the chemical Extracting from the substance-containing data storage unit, performing the process of associating the received identification information with the extracted latest revision and registering it in the identification information storage unit
Data management method in the chemical substance content data management apparatus according to feature a. The chemical substance content data management device is:
A product-related component-related data storage unit that stores the product code of the product, the component code of the component used in the product, the quantity of the component for each component code, and the correspondence of the identification information corresponding to the component code Prepared,
The chemical substance content data management device is:
When the product code is received via a communication line from the orderer terminal operated by the orderer who delivered the product, all of the part code, quantity and identification information corresponding to the received product code are Extracted from product-related parts-related data storage,
Identify the revision associated with each extracted identification information from the identification information storage unit,
Extracting chemical substance content data for each chemical substance contained in the specific revision part code from the chemical substance content data storage unit by the extracted part code and the specified revision,
Accumulating the content of each chemical substance from the content data of the chemical substance for each chemical substance for each extracted part and the quantity for each extracted part
The data management method in the chemical substance content data management apparatus according to claim 1 . The chemical substance content data management device is:
An order data storage unit that stores the order data in which the part code and the order quantity of the part of the part code are associated with each other;
The chemical substance content data management device is:
When there is a request for reference to the order data from the supplier terminal, the order data corresponding to the orderer is extracted with reference to the order data storage unit and displayed on the supplier terminal that has made the reference request.
The data management method in the chemical substance containing data management apparatus according to claim 1 or 2, characterized in that :

Images