JP4990215B2 - Manufacturing history management system and manufacturing history management method - Google Patents

Description

  The present invention relates to a manufacturing history management system and a manufacturing history management method. In particular, the present invention relates to a technology that makes it possible to manage distribution history more easily and detect inconsistencies in the history of product processing performed on a distribution route. This includes a technology that enables management of the distribution route without allowing each person on the distribution route to manage the ID.

As a system that can efficiently track the distribution channel of products, for example, product information storage means for storing product information, for each order information of products related to the product information, a payment amount based on the order information, and the order information Delivery package information storage means for storing product delivery status information, communication means with external devices, and processing means for controlling the operation of each means, the processing means having received the product information Receives product order information related to the product information from the product recipient's terminal via the communication means, and stores the amount charged for payment based on the received order information in the parcel delivery information storage means for each received order information. The delivery status information of the product related to the order information is received from the delivery side terminal via the communication means for each order information, and the received distribution Storing status information in the delivery package information storage means for each order information, and receiving a transmission request for the storage result stored in the delivery package information storage means from the recipient side terminal or the goods order receiver side terminal The delivery request information stored in the delivery package information storage means is referred to, and for each order information, the amount requested for payment based on the order information and the delivery status information of the product related to the order information are requested to be transmitted. A distribution management system (see Patent Document 1), which performs transmission to the recipient side terminal or the orderee side terminal via the communication means, has been proposed.
JP 2004-196550 A

  By the way, in the so-called conventional traceability system, information for uniquely identifying the traceability data across each person (eg, a product ordering trader or a carrier) on the distribution channel of the goods, etc. The system must always be maintained and managed. In addition, when deleting or correcting traceability data managed by a certain person, for example, traceability data managed by another person who is adjacent to this person on the distribution route is also related to the data to be deleted or modified. There is a need to modify the traceability data.

  In addition to tracking the merchandise distribution process, the conventional technology has not realized correspondence between the history information in the processing line of the merchandise and checking the consistency of the processing procedure and the processing result on the distribution channel. .

  Accordingly, the present invention has been made in view of the above problems, and enables distribution history management without allowing each person on the distribution path to manage IDs that uniquely identify product information. The object is to provide a technique for detecting inconsistencies in the history of product processing made above.

  The manufacturing history management system of the present invention includes a communication unit that communicates with other terminals on a network, a communication unit that communicates with a supplier terminal through the communication unit to receive delivery data A, and a product corresponding to the delivery data A As delivery data when delivering a product manufactured from a product to another person, an individual identification number is extracted from the delivery data A, and delivery data B including the individual identification number and product information of the corresponding product is generated. A terminal provided with delivery data processing means for communicating with the orderer terminal by the communication means and transmitting the delivery data B, a communication means for communicating with a terminal on a network, and the terminal by the communication means The data acquisition means for acquiring the delivery data A or B by storing the data and storing it in a storage device, and communicating with any terminal on the network via the communication means. A data search means for executing a delivery data search process in the storage device using the product information included in the data disclosure request as a key, and an individual included in the delivery data searched in the search process A process of extracting the identification number and the product orderer ID or the product supplier ID, and searching for other delivery data including the product orderer ID extracted in the extraction process as the product supplier ID and having a common individual identification number X or other delivery data is retrieved from the delivery data by searching for delivery data Y of other delivery data that includes the product supplier ID extracted in the extraction process as the product orderer ID and has a common individual identification number. As long as the list is generated in the storage device, the list generation means stores the continuous list of delivery data searched by the search processing X or the search processing Y in the storage device, and the storage device Moreover, reading out a series of the delivery data, generating a tree original data in which display areas indicating the delivery data in the list are linked according to the series, and product information included in each delivery data in the list; The product orderer ID or the product supplier ID is set in the display area of the corresponding delivery data in the tree original drawing data to generate tree diagram data, and the tree diagram data is transmitted to the terminal that has transmitted the data disclosure request And a tree data transmitting means.

  Further, in the manufacturing history management system, the delivery data processing means of the terminal includes the delivery data B including data of the transmission date and time of the delivery data B, and transmits the delivery data B to the orderer terminal. The list generation means of the server extracts the individual identification number and the product orderer ID or product supplier ID and the transmission date / time data included in the delivery data searched by the search processing, and the transmission extracted by the extraction processing Other deliveries that are sent to other terminals from the date and time indicated by the date and time data to the other terminal and include the product orderer ID extracted by the extraction process as the product supplier ID and have a common individual identification number Data that has been sent to another terminal at a transmission date / time within a predetermined period from the date / time indicated by the data search processing X or the transmission date / time data extracted by the extraction processing. The other delivery data search process Y including the delivered product supplier ID as the product orderer ID and having a common individual identification number is executed in the storage device as long as further delivery data is searched from the delivery data, A continuous list of delivery data searched by the search process X or the search process Y may be stored in a storage device.

  Further, in the manufacturing history management system, the server includes a first table that defines a normal correspondence relationship between product information of a predetermined product and product information of a product manufactured from the predetermined product. The server extracts the product information included in each delivery data searched in the search process X or Y, and the delivery data searched in the search process X or Y uses the product information of each delivery data thus extracted. The product information of each delivery data in the series is matched with the normal correspondence in the first table by matching with the first table in the order of the series, and the result of the judgment is disclosed in the data disclosure It is good also as providing the process consistency determination means which transmits to the terminal which transmitted the request | requirement.

  In the manufacturing history management system, the delivery data processing means of the terminal includes the delivery data B including the weight data of the corresponding product indicated by the delivery data, and transmits the data to the orderer terminal. The server includes a second table that defines a normal correspondence relationship between weight data of a predetermined product and weight data of a product manufactured from the predetermined product, and the server includes the search process X or The weight data included in each delivery data retrieved by Y is extracted, and the weight data of each delivery data subjected to the extraction processing is added to the second table in accordance with the series of delivery data retrieved by the retrieval process X or Y. To determine whether the weight data of the delivery data in the series match the normal correspondence in the second table, and It sends the results to the terminal which has transmitted the data disclosure request may be provided with a weight consistency determination unit.

  In the manufacturing history management method of the present invention, the terminal communicates with the supplier terminal through the communication means to receive the delivery data A, and delivers the product corresponding to the delivery data A or the product manufactured from the product to the other party. As the delivery data, the individual identification number is extracted from the delivery data A, the delivery data B including the individual identification number and the product information of the corresponding product is generated, and the communication means communicates with the orderer terminal. The delivery data B is transmitted, and the server communicates with the terminal by communication means to acquire the delivery data A or B and stores it in a storage device, and any one on the network via the communication means A process for receiving a data disclosure request by communicating with a terminal, a process for executing a delivery data search process in the storage device using the product information included in the data disclosure request as a key, and a search by the search process The individual identification number and the product orderer ID or product supplier ID included in the product data are extracted and the product orderer ID extracted by the extraction process is included as the product supplier ID, and the individual identification number is common. The delivery data search process X or other delivery data search process Y including the product supplier ID extracted in the extraction process as a product orderer ID and having a common individual identification number is further separated from the delivery data. As long as the delivery data is searched, the storage device executes the storage data, and stores the list of the delivery data searched by the search process X or the search process Y in the storage device, and the series of the delivery data from the storage device. A list of the delivery data in the list is generated, and the display area indicating the delivery data in the list is linked in accordance with the series, and the original map data is generated. The terminal that has generated the data of the data contained in the data and set the product orderer ID or the product supplier ID in the display area of the corresponding delivery data in the tree original data to generate the tree diagram data and transmitted the data disclosure request And a process of transmitting the tree diagram data.

  A lot number may be adopted instead of the individual identification number. In this case, the server stores the individual identification number of each product composing the corresponding lot product in the storage device in association with the lot number data. Of course, when the server acquires delivery data from the terminal, the server acquires set data of a lot number and an individual identification number associated with the lot number. In the process by the list generating means, the process with the lot number replaced with the individual identification number may be executed.

  In addition, the problems disclosed by the present application and the solutions thereof will be clarified by the embodiments of the present invention and the drawings.

  According to the present invention, it is possible to manage distribution history without causing each person on the distribution route to manage IDs that uniquely specify the product information, and it is also possible to avoid the history of product processing performed on the distribution route. Alignment can be detected.

--- System configuration ---
Embodiments of the present invention will be described below in detail with reference to the drawings. FIG. 1 is a configuration diagram of a manufacturing history management system 10 in the present embodiment. The manufacturing history management system 10 (hereinafter, system 10) in the present embodiment acquires the delivery data exchanged between the terminals 50 of various vendors existing on the distribution channel of the product and the terminals 50 and the manufacturing history. It is a computer system which consists of the server 100 which performs the management of this, and a public process.

  The terminal 50 constituting the system 10 reads out the program 52 stored in the storage means 51 such as a nonvolatile memory to the memory 53 in order to realize the function of executing the manufacturing history management method together with the server 100, and the arithmetic device This is executed by the CPU 54. Further, the terminal 50 includes an input interface 55 such as various buttons and a keyboard generally provided in a computer device, and an output interface 56 such as an LED and a display, and further communicates with the server 100 via the network 140. It has communication means 57 and the like.

  Next, a description will be given of means configured and held by the terminal 50 based on the program 52, for example. The terminal 50 is assumed to store delivery data to be transmitted to other terminals in the storage device 51 (in FIG. 1, delivery data 59). The terminal 50 communicates with the supplier terminal 50a by the communication means 57 to receive the delivery data A, and deliver the product corresponding to the delivery data A or the product manufactured from the product to another person. As data, an individual identification number is extracted from the delivery data A, delivery data B including the individual identification number and product information of the corresponding product is generated, and communicated with the orderer terminal 50b by the communication means 57 Delivery data processing means 58 for sending delivery data B is provided.

  The delivery data processing means 58 of the terminal 50 includes the delivery data B including the data of the delivery date and time of the delivery data B (the date and time data called from the clock function of the terminal 50 can be assumed), It may be transmitted to the orderer terminal 50b. Of course, as the data of the transmission date and time, data of the delivery date and time or delivery date and time of the product corresponding to the delivery data may be assumed.

  Further, the delivery data processing means 58 of the terminal 50 may include the delivery data B including the weight data of the corresponding product indicated by the delivery data and transmit it to the orderer terminal 50b. For example, the weight data can be obtained automatically by the terminal 50 communicating with a weight meter connected to the terminal 50 to automatically obtain the weight data for each product. At this time, the weight meter includes a reader of a tag (RFID, barcode, etc.) attached to the product, and transmits the product code read from the tag of the product to the terminal 50 together with the weight data.

  Next, the server 100 that constitutes the manufacturing history management system together with the terminal 50 will be described. The server 100 reads the program 102 stored in the storage means 101 such as a nonvolatile memory into the memory 103 and executes it by the CPU 104 as an arithmetic unit in order to realize the function of executing the manufacturing history management method. In addition, the server 100 includes an input interface 105 such as various buttons and a keyboard that are generally provided in a computer device, and an output interface 106 such as an LED and a display as necessary, and further the terminal 50 via the network 140. The communication means 107 which bears communication with is provided.

  Next, the means that the server 100 configures and holds based on the program 102 will be described. Each means may be provided integrally in one server device or the like, but distributed in a group of computers arranged on the network 140 and cooperates under the initiative of one server device (the server 100 of the system 10). An example of this may also be assumed. The server 100 stores an order information table 125, a trace information table 126, and a lot configuration information table 127, which will be described later, in the storage unit 101.

  The server 100 includes data acquisition means 110 that communicates with the terminal 50 through the communication means 107 to acquire the delivery data A or B and store it in the storage device 101 (the ordering information table 125).

  In addition, the server 100 may connect any terminal on the network 140 via the communication means 107 (in this case, the “terminal” may be the terminal 50 or the terminal 60 of a general consumer who has purchased a product). The data disclosure request may be received, and the storage device 101 (the order information table 125) may be used to search for delivery data using the product information included in the data disclosure request as a key. The data search means 111 is provided.

  Further, the server 100 extracts an individual identification number and a product orderer ID or a product supplier ID included in the delivery data searched by the search process, and uses the product orderer ID extracted by the extraction process as a product. Search processing X for other delivery data that includes the same individual identification number as the supplier ID, or other product ID that includes the product supplier ID extracted by the extraction processing as the product orderer ID. The delivery data search process Y is executed in the storage device 101 (the ordering information table 125) as long as another delivery data is searched from the delivery data, and the delivery searched by the search process X or the search process Y A list generation unit 112 is provided for storing a list of data in the storage device 101 (trace information table 126 thereof).

  Further, the server 100 reads a list of the delivery data from the storage device 101 (the trace information table 126 thereof), and a tree in which display areas indicating the delivery data in the list are linked according to the series. Generate original drawing data, and set the product information included in each delivery data in the list and the product orderer ID or the product supplier ID in the display area of the corresponding delivery data in the original tree drawing data to generate the tree drawing data And a tree data transmitting unit 113 for transmitting the tree diagram data to a terminal that has transmitted the data disclosure request.

  The list generation unit 112 extracts the individual identification number and the product orderer ID or the product supplier ID and the transmission date / time data included in the delivery data searched by the search process, and extracts by the extraction process. Other than the date and time indicated by the transmission date and time data transmitted to the other terminal 50 at the transmission date and time within a predetermined period, the product orderer ID extracted by the extraction process is included as the product supplier ID, and the individual identification number is common. The delivery date of the delivery data extracted by the extraction process is sent to the other terminal 50 at the transmission date and time within a predetermined period from the date and time indicated by the transmission date and time data extracted by the extraction process X or the extraction date and time. The storage device 101 performs a search process Y for other delivery data including the product orderer ID and having a common individual identification number as long as another delivery data is retrieved from the delivery data. The order list of delivery data searched by the search process X or the search process Y is stored in the storage device 101 (trace information table 126). .

  Further, the server 100 may include a first table 128 that defines a normal correspondence relationship between product information of a predetermined product and product information of a product manufactured from the predetermined product in the storage device 101. In this case, the server 100 extracts the product information included in each delivery data searched in the search process X or Y, and searches for the product information of each delivery data extracted in the search process X or Y. The product information of each delivery data in the series is matched with the normal correspondence relationship in the first table 128 by collating with the first table 128 in accordance with the order of the delivered delivery data. The processing consistency determining means 114 may be provided which transmits the result of the above to the terminal that has transmitted the data disclosure request.

  Further, the server 100 may include a second table 129 in which the normal correspondence relationship between the weight data of a predetermined product and the weight data of a product manufactured from the predetermined product is provided in the storage device 101. In this case, the server 100 extracts the weight data included in each delivery data retrieved in the retrieval process X or Y, and retrieves the weight data of each delivery data retrieved in the retrieval process X or Y. The second table 129 is collated with the series of delivered data, and it is determined whether the weight data of the delivery data in the series match the normal correspondence in the second table 129. The weight consistency determination means 115 may be provided which transmits the result of the above to the terminal that has transmitted the data disclosure request.

  Note that the means 58 in the terminal 50 and the means 110 to 115 in the server 100 constituting the system 10 described so far may be realized as hardware, a memory, an HDD (Hard Disk Drive), or the like. It may be realized as a program stored in the appropriate storage means. In this case, each CPU of the terminal 50 or the server 100 reads out the corresponding program from the storage means to the memory in accordance with the program execution, and executes it.

--- Example of table structure ---
Next, the structure of the table used by the server 100 configuring the system 10 in the present embodiment will be described. FIG. 2 is a diagram showing an example of the data structure of the ordering / ordering information table 125 of this embodiment. FIG. 3 is a diagram showing an example of the data structure of (a) the trace information table 126 and (b) the lot configuration information table 127 of this embodiment.

  The order information table 125 is a table in which the server 100 acquires and stores delivery data exchanged between the terminals 50. This ordering / ordering information table 125 includes, for example, the code of the sending company and the receiving company of the delivery data, the slip information, the individual identification number, the lot number, the data creation date, the delivery date and time, the refrigerated warehouse for storing the product. Information, merchandise carrier information, merchandise code, merchandise name, merchandise weight, expiry date, physical flow information, and the like.

  In addition, the trace information table 126 is a table that stores a continuous list of delivery data searched by the search process X or the search process Y generated by the list generation unit 112 of the server 100. The trace information table 126 includes, for example, a registered company code (a code of a company that is a management company of the terminal 50 and provides delivery data to the server 100), a purchase company code (a code of a company that is a supplier of goods) , A set of records in which data such as individual identification number, delivery date, product code, purchase weight, sales weight, processing information, and inspection information is associated with the sales company code (code of the company that ordered the product) It is a body.

  As shown in FIG. 2, the trace information table 126 shows that a product company (product code “1000”, individual identification number) from a supplier company “A” to a customer company “B” as “a series of delivery data”. "1234567895") and the product (product code "2000", individual identification number is the same as that of the product code "1000") processed by this product is now purchased by the customer company "B". The product A located upstream on the distribution channel between the companies on the distribution channel, such as becoming the source company “B” and delivering to the customer company “B1”, is processed through another process, etc. The data shows the repetition of delivery to downstream companies. For example, if the product is “beef”, the most upstream product in the distribution channel is “one beef”, and this one beef is disassembled and processed downstream in the distribution channel. As it turns out, the carcasses, fins, mince, etc. will be transformed into different products. Since the data structure of the trace information table 126 corresponds to the relationship between the product upstream of the distribution channel and various derived products manufactured using this product, it becomes the source of the tree original map data.

  The lot configuration information table 127 is a table that stores data on the correspondence between a lot, which is a delivery unit of a product, and a product constituting the lot. The lot configuration information table 127 is, for example, a collection of records in which a registered company code and a lot number are associated with a list of individual identification numbers of product groups that constitute a lot corresponding to the lot number. For example, if the product corresponding to the lot is “mince”, the product groups used to manufacture this “mince” are “individual A beef”, “individual B beef”, “individual C beef” If there are three types of "", individual identification numbers corresponding to these three types of beef will be associated with the lot. When the server 100 acquires delivery data from the terminal 50, the server 100 acquires set data of a lot number and an individual identification number associated with the lot number. In the processing by the list generation means 112, processing with a lot number may be executed instead of the individual identification number.

  FIG. 4 is a diagram showing an example of the data structure of (a) the first table 128, (b) the image 5 of the first table contents, and (c) the second table 129 of the present embodiment.

  The first table 128 is a table that defines a normal correspondence between product information of a predetermined product and product information of a product manufactured from the predetermined product. The first table 128 is, for example, a collection of records in which product code data of derivative products that are normally assumed to be manufactured from the product are associated with the product code of a product as a key. Yes. For example, since the product “Katabara” may be manufactured from the product “Carcass half-circle”, the product code of the product “Katabara” is changed to the product code of the product “Carcass half-circle”. It is specified in the product code column. However, the product “carcass half-circle” cannot be manufactured from the product “Katabara”. The normal relationship between such products shown in the first table 128 and their derivatives is shown in image 5 of FIG. In this image 5, the product (cow) “500” of the producer “A” is delivered to the manufacturer “B” of the delivery destination and processed into the products “1000”, “2000”, and “3000” by the manufacturer “B”. The product “1000” is delivered to the manufacturer “B1”, the product “2000” is delivered to the manufacturer “B2”, the product “3000” is delivered to the manufacturer “B3”, and the products “1000” to “3000” are It is delivered from the manufacturer “B1” to “B3” to the retail store “C”, and the sales unit (product) of “LOTC1000” can be generated from the products “1000” to “3000” in the retail store “C”. Show.

  The second table 129 is a table that defines a normal correspondence between the weight data of a predetermined product and the weight data of a product manufactured from the predetermined product. This second table 129 shows, for example, that the purchase weight of the product “500” is, for example, “70 kg”, the products “1000” to “3000” obtained by processing the product “500” with the processing type “type001”. According to the characteristics of the product and its processing form, the allowable range of weight change at the time of purchase and at the time of sale, such as the total sales weight is within a range obtained by subtracting a predetermined gram below “70 kg”. Is stipulated.

--- Processing flow example 1 ---
Hereinafter, the actual procedure of the manufacturing history management method in the present embodiment will be described with reference to the drawings. Various operations corresponding to the manufacturing history management method described below are realized by programs that the terminal 50 and the server 100 configuring the system 10 read into the respective memories and execute. And such a program is comprised from the code | cord | chord for performing the various operation | movement demonstrated below.

  FIG. 5 is a flowchart showing an example of a processing procedure of the manufacturing history management method of the present embodiment. Here, for example, as shown in 4 (b) above, a situation is assumed in which one beef meat as a product and its derivatives are on the distribution channel. In addition, consumers who have purchased products such as beef and their derivatives (not limited to general consumers but may be traders on the distribution channel) can also record manufacturing history for products they have acquired. When we want to know, we assume a situation (traceback) in which the history is identified from the product obtained by this consumer up the distribution channel upstream to the most upstream product (one cow itself) and its dealer .

  Here, the traders on the distribution channel mutually order and deliver beef and its derivatives, and the beef for one head is subdivided every time this order is repeated, or It is mixed with beef of other individual beef, etc., or given processing and cooking, and finally becomes a product for general consumers. Therefore, first, a description will be given from the stage in which the server 100 obtains delivery data exchanged by these vendors via the terminal 50.

  In this case, for example, a cow producer “A” has delivered one cow (individual identification number “1234567895”, product code “500”) in response to an order from a beef processor “B” (manufacturer). . Along with the delivery, the terminal 50a of the cow producer “A” receives data on the cow (individual identification number, sex, age, meat quality grade, weight, production place, producer, product code “500”, etc.) And the delivery date / time data or the transmission date / time data of the delivery data D1 are transmitted to the terminal 50b of the beef processor “B” (s100).

  In the following description, the product orderer's terminal is labeled “50b”, and the product supplier's terminal is labeled “50a”. If an order is received from another person on the distribution channel, Since the person who has been the "orderer" changes the position to the "delivery person", the code is also changed whenever the position changes.

  The delivery data processing means 58 of the terminal 50b of the beef processor “B” receives the delivery data D1 from the terminal 50a and stores it in the storage device 51 (s101). After that, this beef processor “B” (manufacturer) processes the beef of the one beef (product code “500”) by dismantling it appropriately, and processes each product with product codes “1000” to “3000”. Suppose that it manufactured.

  If the wholesalers “B1” to “B3” place orders for the product codes “1000” to “3000” to the beef processor “B”, the beef processor “B” B "changes the position to" supplier ". The delivery data processing means 58 of the terminal 50a of the beef processor “B” reads the delivery data D1 from the storage device into the memory 53, and extracts the individual identification number “1234567895” from the delivery data D1 (s102). Then, delivery data D2 to D4 including the individual identification number “1234567895” and the product information (meat quality, weight, processing place, processor, product codes “B1” to “B3”, etc.) of the corresponding product are generated (s103). . The delivery data processing means 58 of the terminal 50a of the beef processing business “B” attaches delivery date data or delivery date data of the delivery data B to the delivery data D2 to D4 generated here. It transmits to each terminal 50b of the traders “B1” to “B3” (s104).

  Such exchange of delivery data received from another person and delivery data to be sent to another person is, for example, the above-mentioned meat processing company that manufactured the products “1000” to “3000” using the product “500” “ B ”and wholesalers“ B1 ”to“ B3 ”who have ordered these products“ 1000 ”to“ 3000 ”, and the products“ 1000 ”to“ 3000 ”are delivered to the wholesalers and sold as“ LOTC1000 ”. (= Associated with the individual identification number group) the retail store “C”, and the other retail stores “C1” to “C3” that received the sales unit “LOTC1000” from this retail store “C”, (See FIG. 4B. The corresponding flow is omitted in FIG. 5). Note that there is no exchange of delivery data between the retailers “C1” to “C3” that retail the sales unit “LOTC1000” and general consumers who have purchased them.

  On the other hand, the data acquisition unit 110 of the server 100 communicates with the terminal 50a or the terminal 50b included in each trader on the distribution route by the communication unit 107, and acquires and stores the delivery data D1 to D4. The information is stored in the order information table 125 of the device 101 (s105). Of course, at this time, in addition to the case where the server 100 transmits a delivery data acquisition request to the terminals 50 and so on, each of the terminals 50 has a delivery data upload program and each time the delivery data is processed. It may be uploaded to the server 100. In this way, delivery data is accumulated in the ordering information table 125. In addition, the delivery data that the server 100 obtains from the terminals is naturally obtained not only for the delivery data D1 to D4 but also for the data (D5 to D10) exchanged via a downstream distribution channel (FIG. 4B). )reference).

  In addition, the data search unit 111 of the server 100 is assumed to be a terminal on the network 140 via the communication unit 107 (the “terminal” here is a terminal 60 of a general consumer who has purchased a product as an example. The data disclosure request is received (s106). Further, the data search means 111 receives, from the data disclosure request received from the terminal 60 of the general consumer, for example, the individual identification number “1234567895” of the corresponding product among the product information and the retailer who has sold the product. The code “C1” (preferably also the individual identification number “LOTC1000”) is extracted, and the delivery data search process in the order information table 125 of the storage device 101 is executed using the extracted data as a key (s107). .

  Next, the list generation means 112 of the server 100 uses the individual identification number “1234567895” and the merchandise supplier ID “C” (= the retail store “C1”) from the delivery data retrieved by the retrieval process in the step s107. And the data of the delivery date / time or the data transmission date / time, the weight at the time of purchase or the weight at the time of sales (S108).

  In addition, the list generation unit 112 includes the product supplier ID “C” extracted in the extraction process of the step s108 as a product orderer ID, and has a common individual identification number “1234567895”, and the delivery date or the transmission date and time. Search processing of other delivery data transmitted to other terminals on the transmission date and time within a predetermined period from the date and time indicated by the data is executed (s109). In performing the search process, the condition that the data is transmitted to another terminal on the transmission date / time within a predetermined period from the date / time indicated by the delivery date / time or transmission date / time data is, for example, the same product code or individual identification number. This is to eliminate the corresponding delivery data if it comes with an ordering at a completely different time.

  In the example of FIG. 4B, the deliverers when the retail store “C” is the orderer are wholesalers “B1” to “B3”. The list generation means 112 performs a delivery data retrieval process that goes back upstream in the distribution route from the downstream side to the upstream side of the distribution route (since “trace back” is assumed in this embodiment). As long as another delivery data is retrieved from a certain delivery data, that is, as long as the distribution route can be traced, it is executed in the storage device 101 (the order information table 125).

  The list generation means 112 stores a continuous list of delivery data retrieved by the retrieval process in step s109 in the trace information table 126 of the storage device 101 (s110). In the example of the trace information table 126 in FIG. 3A, for the delivery data having the same individual identification number “1234567895”, the other retail stores that are the sales company “C1” to “C3” and the supplier company “C”. “Starting with the ordering relationship with the retail store, the retail store“ C ”and the wholesalers“ B1 ”to“ B3 ”, the wholesalers“ B1 ”to“ B3 ”and the beef processor“ B ” , The beef processor “B” and the producer “A” are traced back to the business relationship on the distribution channel.

  Subsequently, the processing consistency determination unit 114 of the server 100 extracts, for example, a product code as the product information included in each delivery data searched in the step s109, and the product code of each delivery data subjected to the extraction processing. Are matched with the first table 128 in accordance with the sequential order of the delivery data retrieved in the retrieval process of step s109 (s111). For example, in the example of FIG. 4A, the retail unit that has delivered the sales unit “LOTC1000” extracted from the delivery data D10 derived from the retail store “C1” and the sales unit “LOTC1000” in the extraction process. By comparing the product code “1000” extracted from the delivery data D7 derived from “C” with the first table 128, it can be determined that the sales unit “LOTC1000” can be derived from the product “1000”. In this way, the processing consistency determination unit 114 determines whether the product information of each delivery data in the series matches the normal correspondence in the first table 128, and the result of the determination is used as the data disclosure request. It transmits to the consumer terminal 60 which has transmitted (s112).

  In addition, the weight consistency determination unit 115 of the server 100 extracts the weight data included in each delivery data retrieved in the retrieval process of the step s109, and the weight data of each delivery data subjected to the extraction process is extracted from the series. At the same time, the second table 129 is collated (s113). The weight data consists of purchase weight (product weight when the orderer receives the product delivery) and sales weight (product weight when the supplier delivers the product to the orderer), and is consistent between them. This means that there is no unmanaged item in the distribution process of the product, or that there is no unnecessary part deletion. In the example of FIG. 4C, assuming that the purchase weight of the product “500” is, for example, “70 kg”, the products “1000” to “3000” obtained by processing the product “500” with the processing type “type001”. The weight consistency determination unit 115 determines whether the total sales weight is less than 5% when the rate of decrease from the “70 kg” is within 5%.

  The weight consistency determination unit 115 transmits the determination result in the step s113 to the consumer terminal 60 that has transmitted the data disclosure request (s114).

  Subsequently, the tree data transmission means 113 of the server 100 reads the list of the delivery data from the trace information table 126 of the storage device 101, that is, the relationship between the supplier of the product and the company of the sales destination. A pair of products ordered and received between companies, and an individual identification number common to these products are read (s115). Then, display area data (in this example, an icon) for indicating each delivery data in the list is read from the storage device 101, and the original tree data 600 (FIG. a)) is generated (s116). In the original tree diagram 600 of FIG. 6A, “◯” is shown as the icon of the display area.

  Next, the tree data transmission means 113 sets the product information included in each delivery data in the list and the product orderer ID or the product supplier ID in the display area of the corresponding delivery data in the tree original data. Tree diagram data 610 (see FIG. 6B) is generated and transmitted to the consumer terminal 60 that has transmitted the data disclosure request (s117). In the example of FIG. 6B, delivery date and time as product information data and company name data of the product orderer or product supplier are embedded around and between the icons.

  In the above-described example, the so-called traceback process has been described. On the contrary, from the most upstream product on the beef distribution route such as beef to the end product that the consumer has. It may be assumed that the history is specified (trace forward) by moving the route downstream. In this case, for example, in the step s109, the list generating means 112 includes the product orderer ID “C1” extracted in the extraction process of the step s108 as the product supplier ID, and the individual identification number “1234567895” is common. Yes, a search process for other delivery data transmitted to another terminal on the transmission date / time within a predetermined period from the date / time indicated by the delivery date / time or transmission date / time data is executed.

  As described above, according to the present embodiment, it is possible to manage the distribution history without causing each person on the distribution route to manage the ID for uniquely identifying the product information, and the product processing performed on the distribution route can be performed. History inconsistencies can be detected.

  As mentioned above, although embodiment of this invention was described concretely based on the embodiment, it is not limited to this and can be variously changed in the range which does not deviate from the summary.

It is a whole block diagram of the manufacture log | history management system in this embodiment. It is a figure which shows the example of a data structure of the ordering information table of this embodiment. It is a figure which shows each data structure example of (a) trace information table of this embodiment, and (b) lot structure information table. It is a figure which shows each data structure example of (a) 1st table, (b) Image of the 1st table content, (c) 2nd table of this embodiment. It is a flowchart which shows the example of a process sequence of the manufacture log | history management method of this embodiment. It is a figure which shows the example of a display screen of the tree figure of this embodiment.

Explanation of symbols

DESCRIPTION OF SYMBOLS 10 Manufacturing history management system 50 Terminal 50a Supplier terminal 50b Orderer terminal 58 Delivery data processing means 100 Server 51, 101 Storage means 52, 102 Program 53, 103 Memory 54, 104 CPU
55, 105 Input interface 56, 106 Output interface 57, 107 Communication means 110 Data acquisition means 111 Data search means 112 List generation means 113 Tree data transmission means 114 Processing consistency determination means 115 Weight consistency determination means 125 Ordering order information table 126 Trace information table 127 Lot configuration information table 128 First table 129 Second table 140 Network

Claims (5)

A communication means for communicating with other terminals on the network;
As the delivery data when delivering the product corresponding to the delivery data A or the product manufactured from the product to another party by communicating with the supplier terminal by the communication means and receiving the delivery data A, the delivery data A The delivery data is obtained by extracting the individual identification number from the data, generating delivery data B including the individual identification number and the product information of the relevant product, and transmitting the delivery data B by communicating with the orderer terminal by the communication means. A terminal comprising processing means;
A communication means for communicating with a terminal on the network;
Data acquisition means for communicating with the terminal by the communication means to acquire the delivery data A or B and store it in a storage device;
Data that communicates with any terminal on the network via the communication means, receives a data disclosure request, and executes a delivery data search process in the storage device using product information included in the data disclosure request as a key Search means;
An individual identification number and a product orderer ID or a product supplier ID included in the delivery data searched in the search process are extracted, and the product orderer ID extracted in the extraction process is included as a product supplier ID. Search processing X for other delivery data having a common identification number, or search processing Y for other delivery data having a common individual identification number including the product supplier ID extracted by the extraction processing as the product orderer ID A list generation means for executing in the storage device as long as further delivery data is searched from the delivery data, and storing a list of the delivery data searched by the search processing X or the search processing Y in the storage device; ,
A list of delivery data series is read from the storage device, and display data indicating each delivery data in the list is generated in accordance with the series to generate tree original data, and each delivery data in the list includes The tree information is generated by setting the product information and the product orderer ID or the product supplier ID in the display area of the corresponding delivery data in the tree original map data, and the tree diagram is transmitted to the terminal that has transmitted the data disclosure request. A server comprising tree data transmission means for transmitting data;
A manufacturing history management system comprising: The delivery data processing means of the terminal includes the delivery data B including data on the transmission date and time of the delivery data B, and transmits the delivery data B to the orderer terminal.
The list generation means of the server extracts the individual identification number and the product orderer ID or the product supplier ID and the transmission date / time data included in the delivery data searched by the search processing, and extracts by the extraction processing Others that are transmitted to other terminals from the date and time indicated by the transmission date and time data to the other date and include the product orderer ID extracted by the extraction process as the product supplier ID and have a common individual identification number Product delivery ID that was sent to another terminal at the sending date / time within a predetermined period from the date / time indicated by the sending date / time data extracted by the delivery data search process X or the extracting process, and extracted by the extracting process is ordered. Search processing Y for other delivery data including the person ID and having the same individual identification number is executed in the storage device as long as further delivery data is retrieved from the delivery data, It is for storing a list of series of search processing X or search process delivery data retrieved by Y in the storage device,
The manufacturing history management system according to claim 1. The server includes a first table defining a normal correspondence relationship between product information of a predetermined product and product information of a product manufactured from the predetermined product;
The server extracts the product information included in each delivery data searched in the search process X or Y, and the delivery data searched in the search process X or Y uses the product information of each delivery data thus extracted. The product information of each delivery data in the series is matched with the normal correspondence in the first table by matching with the first table in the order of the series, and the result of the judgment is disclosed in the data disclosure The manufacturing history management system according to claim 1, further comprising a processing consistency determination unit that transmits the request to the terminal that has transmitted the request. The delivery data processing means of the terminal includes the delivery data B including the weight data of the corresponding product indicated by the delivery data, and transmits it to the orderer terminal;
The server includes a second table that defines a normal correspondence between weight data of a predetermined product and weight data of a product manufactured from the predetermined product in a storage device;
The server extracts the weight data included in each delivery data searched in the search process X or Y, and the delivery data searched in the search process X or Y uses the weight data of the extracted delivery data. In accordance with the series, the second table is collated to determine whether the weight data of the respective delivery data in the series match the normal correspondence in the second table, and the result of the judgment is disclosed in the data disclosure The manufacturing history management system according to claim 1, further comprising a weight consistency determination unit that transmits the request to the terminal that has transmitted the request. The device
From the delivery data A as delivery data when receiving a delivery data A by communicating with a delivery terminal through a communication means and delivering a product corresponding to the delivery data A or a product manufactured from the product to another person Extracting the individual identification number, generating delivery data B including the individual identification number and product information of the corresponding product, communicating with the orderer terminal by the communication means, and sending the delivery data B,
The server
Processing to communicate with the terminal by communication means to acquire the delivery data A or B and store it in a storage device;
A process of receiving a data disclosure request by communicating with any terminal on the network via a communication means, and executing a delivery data search process in the storage device using product information included in the data disclosure request as a key;
An individual identification number and a product orderer ID or a product supplier ID included in the delivery data searched in the search process are extracted, and the product orderer ID extracted in the extraction process is included as a product supplier ID. Search processing X for other delivery data having a common identification number, or search processing Y for other delivery data having a common individual identification number including the product supplier ID extracted by the extraction processing as the product orderer ID , A process that is executed in the storage device as long as further delivery data is searched from the delivery data, and a list of the delivery data searched by the search processing X or the search processing Y is stored in the storage device;
A list of delivery data series is read from the storage device, and display data indicating each delivery data in the list is generated in accordance with the series to generate tree original data, and each delivery data in the list includes The tree information is generated by setting the product information and the product orderer ID or the product supplier ID in the display area of the corresponding delivery data in the tree original map data, and the tree diagram is transmitted to the terminal that has transmitted the data disclosure request. Processing to send data, and
Manufacturing history management method characterized by the above.