JP5923202B1 - Traceability management device, program - Google Patents

Abstract

A traceability management apparatus and a program capable of specifying a product manufactured in a specific time zone in a lot. According to the present invention, there is provided a traceability management apparatus for tracking a product with an arbitrary granularity, the traceability management apparatus including a management data acquisition unit for acquiring management data for tracking, a tracking target A tracking target data acquisition unit for acquiring tracking target data including data relating to a product and information related to the manufacturing time of the product assigned to each product, and a packing container for identifying a packing container related to packing of the tracked product There is provided a traceability management device including a specifying unit and a transport tool specifying unit that specifies a transport tool related to transport of a product to be tracked. [Selection] Figure 2

Description

  The present invention relates to a traceability system used for product tracking.

  As a conventional traceability system, the following Patent Document 1 discloses a traceability system that can immediately identify the current location of a product that may be defective and can stop further distribution.

  Further, Patent Document 2 below discloses a traceability management system that can grasp a transport destination for each production lot and is simple but excellent in confidentiality of management information.

  As described above, in order to manage the quality of products, a technique for performing quality control for each production lot has been introduced by various companies. And, in order to satisfy the interest in safety and selection, it is also used in combination with a traceability system that can track the distribution of products. And unfortunately, when a recall is performed due to the occurrence of a defective product due to contamination of foreign matters during production or deterioration during transportation, the product is collected in units of production lots using the trace results of the traceability system.

JP2009-122926 JP2013-124155A

  In these systems, the delivery destination can be grasped for each production lot, and when a defect is found in the product, the product manufactured in the same lot as that product can be identified. For example, the expiration date of the raw material in a lot has expired In case or when chemicals are mixed, it can be collected in lot units. However, there may be a case where a defect is found in a product manufactured in a specific time zone of a lot. For example, when water leaks from the ceiling on the production facility for several minutes, or when it is left in the transport vehicle for a long time after being delivered to the transporter, the quality of the product is significantly impaired. In such a case, among the products manufactured in the same lot, although the quality of only a specific product is degraded, it can be said that there is no problem in other products.

  However, with the conventional system, even in such a case, it was possible to collect only in units of production lots. In other words, even products that are not actually problematic are collected together simply because they are in the same lot as the product in which the problem occurred. There may not be much problem in the case of many kinds, small lots, etc. However, when producing a lot in one lot, it is time consuming and expensive to collect all the lots, and resources It is not preferable from the viewpoint of adverse effects on the environment due to the disposal of waste.

  This invention is made | formed in view of such a situation, and specifies the product manufactured in the specific time slot | zone in a lot by the unit of at least 1 or more types of a lot, a conveyance tool, and a packaging container. A traceability management device and a program that can be used.

  According to the present invention, there is provided a traceability management apparatus for tracking a product at an arbitrary granularity, the traceability management apparatus including a management data acquisition unit that acquires management data for tracking, and data related to a product to be tracked. A tracking target data acquisition unit that acquires tracking target data including information related to the manufacturing time of the product given to each product, a packaging container specifying unit that specifies a packaging container related to the packaging of the tracking target product, A transport tool specifying unit that specifies a transport tool related to transport of the product to be tracked, and the granularity for tracking is at least one of a manufacturing lot, a transport tool, and a packing container, and the management The data is assigned to each product in the production lot, the number of products packed in the packaging container, the packaging container identification information given to each packaging container, and the carrier. And includes transporting device identification information associated with the packaging container identification information based on the situation at the time of transportation, and the packaging container identification information is a unit for manufacturing a plurality of products including products to be tracked. When the time required for a certain production lot is divided into a plurality of sections, it is given to each packing container that packs a plurality of products manufactured in each section, and the packing container specifying unit is the tracking target With reference to the data and the management data, based on the production time of the product to be tracked and the number of products packed in the packaging container, the packaging given to the packaging container in which the product to be tracked is packed The container identification information is specified, and the carrier specifying unit refers to the packaging container identification information and the management data, and packs the product to be tracked based on the correspondence based on the situation at the time of transportation. The transporting tool identification information given to the transporting tool transporting the packaged container is specified, and the information regarding the manufacturing time is used for identifying the manufacturing time of the product and the lot in which the product is manufactured. And a traceability management device including at least one of the packaging container identification information.

Hereinafter, various embodiments of the present invention will be exemplified. The following embodiments can be combined with each other.
Preferably, the management data acquisition unit acquires data representing at least two of a start time, an end time, or a required time of the production lot, and the packing container specifying unit includes the product included in the tracking target data The manufacturing time of the product belongs to any of the plurality of sections based on the manufacturing time, the number of products packed in the packaging container and the received data representing at least two of the products included in the management data And the packaging container identification number corresponding to the section is specified.
Preferably, the information processing apparatus includes a determination unit that acquires information about the packaging container mounted on the identified transporting tool and determines a range to be collected.
Preferably, an output unit that outputs a range determined as a collection target by the determination unit is provided.
Preferably, the packing container identification number is a unique number in the manufacturing lot in which the product to be packed in the packing container is manufactured.
Preferably, when the packing container identification number does not correspond to the carrier identification number, the data representing the packing container identification number or the information for identifying the product manufactured in the manufacturing lot or the manufacturing lot A first code image including data representing the data and a second code image including data representing the transport device identification number are pasted on the transport device, and the pasted first code image and the first code image By reading a two-code image, a reading code correspondence unit that associates the packing container identification number with the transporting tool identification number is provided.
Preferably, the time required for a production lot, which is a unit for producing a product, is divided into a plurality of sections, and a packaging container identification number assigned to each packaging container packed for each of the plurality of products manufactured in the section; A receiving unit that receives data associated with a carrier identification number assigned to each of the carriers equipped with the plurality of packaging containers, and a trace target based on the data received by the receiver. A packaging container identification unit that identifies the packaging container identification number corresponding to the transporting instrument identification number, and which of the plurality of sections the identified packaging container identification number belongs to, and is manufactured in the section There is also provided a traceability management device having a product specifying unit for specifying the product.
Preferably, the computer is a traceability management apparatus that tracks products with an arbitrary granularity, and includes a management data acquisition unit that acquires management data for tracking, and data related to the products to be tracked, which is assigned to each product. A tracking target data acquisition unit for acquiring tracking target data including information related to the manufacturing time of the manufactured product, a packaging container specifying unit for specifying a packaging container related to the packaging of the tracked product, and a transport related to the transport of the tracked product A transport tool specifying unit for specifying tools, and the granularity for tracking is at least one of a manufacturing lot, a transport tool, and a packing container, and the management data is stored in the packing lot in the manufacturing lot. The number of products packed in the package, the packing container identification information given to each packing container, and the information given to each transport tool, Therefore, the transport container identification information associated with the packaging container identification information includes the time required for the production lot, which is a unit for manufacturing a plurality of products including the product to be tracked, in the plurality of sections. Is provided for each of the packaging containers for packing a plurality of products manufactured in each section, the packaging container specifying unit refers to the tracking target data and the management data, Based on the manufacturing time of the product to be tracked and the number of products packed in the packing container, the packing container identification information given to the packing container in which the product to be tracked is packed is specified, and the carrier The identification unit refers to the packaging container identification information and the management data, and transports the packaging container in which the product to be tracked is packed based on a correspondence relationship based on a situation at the time of transportation. The transporting device identification information given to the transporting device is specified, and the information regarding the manufacturing time includes the manufacturing time of the product, information for identifying the lot in which the product is manufactured, and the packing container identification information. A program for functioning as a traceability management device including at least one of them is provided.

It is explanatory drawing of the data created in the flow and each process after manufacturing a product in a factory. FIG. 2 is a functional block diagram of a traceability management apparatus and a diagram showing an overall system. It is a figure about the data created for every lot, (b) is a figure showing the contents of lot data about (a) the time packed in the bottle and cardboard manufactured by 1 lot. It is a figure explaining the correlation with QR Code and pallet ID, (a) is the content of the QR code added to corrugated cardboard, (b) is a figure showing matching with pallet ID and QRID. It is a manufactured bottle. It is a figure showing a mode that QR Code is added to the corrugated cardboard with which the bottle was packed. FIG. 6 is a diagram in which a plurality of cardboards are mounted on a conveyance pallet. It is a figure which represents distribution of a product notionally. It is a figure showing the flow which specifies the correspondence of a product and a conveyance tool, (a) is a figure showing the flow which specifies a conveyance tool from a product, and (b) is the figure showing the flow which specifies a product from a conveyance tool. . It is a figure about the recovery range determination processing, (a) is a flow for determining the recovery range, (b) is a diagram for explaining the breakdown of the cardboard mounted on the pallet.

  Hereinafter, embodiments of the present invention will be described. The following embodiments are exemplifications, and the scope of the present invention is not limited to those shown in the following embodiments.

<1. First Embodiment>
The traceability management apparatus 1 according to the first embodiment includes an ID assigned to a packaging container (hereinafter, cardboard 7) in which soy sauce bottles (hereinafter, bottle 5), which are products manufactured in a certain manufacturing lot, are sequentially packed. A product manufactured in a specific time zone in a manufacturing lot is specified by associating an ID assigned to a transport tool (hereinafter, pallet 11) on which a plurality of packing containers are mounted.

  FIG. 1 is an explanatory diagram of a flow from manufacturing a product in a factory to transportation and data created in each process. First, a product is manufactured in S11. In this embodiment, the bottle 5 is manufactured in large quantities at the factory. At this time, a label that describes each date of manufacture is attached to the bottle 5. At the same time, the bottle 5 may be laser engraved with the date of manufacture. And the data showing a manufacturing date (manufacturing time) are memorize | stored in the below-mentioned manufacturing time memory | storage part 209. FIG.

  Next, the bottle 5 is packed in the cardboard 7 in S13, and the QR code 9 is added to the cardboard 7. The QR code 9 is a two-dimensional code image including various information, and may be directly printed on the cardboard 7 or a label printed with the QR code 9 may be attached to the cardboard 7. At this time, the QR code 9 includes data representing an ID for identifying itself (hereinafter, QRID). In the present embodiment, ten bottles 5 are packed in the cardboard 7, and QRID is a serial number unique within the lot in which the bottles 5 packed in the cardboard 7 are manufactured. Accordingly, the cardboards 7 filled with the bottles 5 manufactured in the same lot are distinguished from each other by QRID. It should be noted that various two-dimensional codes may be used as long as QRID can be included instead of QR code 9.

  Next, the cardboard 7 filled with ten bottles 5 is loaded on the pallet 11 (S15). The amount to be loaded varies depending on the conveyance amount depending on the conveyance destination. For example, 10 boxes, 30 boxes, and 50 boxes are mounted. At this time, a bar code 13 including data representing an ID for identifying itself (hereinafter referred to as “pallet ID”) is added to the pallet 11, and the pallet ID of the pallet 11 and the pallet 11 are loaded by the system described later. The QRID of the cardboard 7 is stored in association with it.

  Next, the pallet 11 is transported and delivered to each transport destination. At this time, for each pallet 11 transported, the transport date, lot number, pallet ID, warehouse area, warehouse location, transport instruction number, delivery date, report destination name, delivery destination, transport quantity, amount and department in charge are associated with each other. Remember.

  FIG. 2 is a functional block diagram of the traceability management apparatus 1 according to the present embodiment and a diagram showing an overall system. In the present embodiment, the traceability management device 1, the direct marking device 2, and the pallet label output device 3 can communicate with each other via the network 4.

<Traceability management device 1>
The traceability management device 1 includes a control unit 10 that is configured by a CPU and the like and controls each unit and executes various programs and engines, and a storage medium such as a memory, a hard disk, and an SSD (solid state drive). A storage unit 20 for storing various data, an operation unit 30 including a touch panel, a keyboard, a voice input unit, and the like for operating the traceability management apparatus 1, a display for displaying information such as characters, images, and moving images Display unit 40 and a communication unit 50 connected to a network such as the Internet or an intranet and communicating with an external information terminal. The control unit 10 communicates with and controls the storage unit 20, the operation unit 30, the display unit 40, and the communication unit 50, respectively.

<Control unit 10>
The lot ID management / generation unit 101 is manufactured by data representing an ID for identifying each lot (hereinafter, lot ID), manufacturing start time, manufacturing end time, required manufacturing time, the number of bottles 5 to be manufactured. Data in which the number of bottles 5 packed in the cardboard 7, the time required to manufacture the bottles 5 packed per cardboard 7, and the product code of the bottle 5 are generated and the lot ID is managed.

  The QRID management / generation unit 103 generates, as information represented by the QR code 9, data that associates the lot ID, the manufacturing date, the QRID, the product code, and the expiration date of the lot in which the bottle 5 is manufactured. to manage.

  The QR / pallet association unit 107 generates data representing a pallet ID represented by the barcode 13 added to the pallet, and corresponds to the pallet ID and the pallet ID, and a pallet ID management / generation unit 105 that manages the pallet ID. The data which matched QRID corresponding to the corrugated cardboard 7 mounted in the pallet 11 to produce | generate is produced | generated.

  The transmission / reception unit 109 transmits / receives data to / from each unit in the control unit 10, the operation unit 30, the display unit 40, the communication unit 50, and the storage unit 20.

  The first packing container specifying unit 111 specifies the QRID added to the cardboard 7 packed with the bottles 5 based on the manufacturing time of the bottles 5 and the number of the bottles 5 packed in the cardboards 7.

  The transport tool specifying unit 113 specifies the pallet ID corresponding to the QRID specified by the first packing container specifying unit 111 with reference to the data generated by the QR / pallet correspondence unit 107.

  The second packing container specifying unit 117 specifies the QRID corresponding to the pallet ID assigned to the pallet 11 with reference to the data generated by the QR / pallet correspondence unit 107.

  The product specifying unit 119 specifies the manufacturing time of the bottle 5 packed in the cardboard 7 to which the QRID specified by the second packing container specifying unit 117 is added.

  The determination unit 121 determines a range to be collected.

  The controller 115 is a program that controls each unit in the control unit 10.

<Storage unit 20>
The lot data storage unit 201 stores the data generated by the lot ID management / generation unit 101. The QRID storage unit 203 stores the data generated by the QRID management / generation unit 103. The palette ID storage unit 205 stores the data generated by the palette ID management / generation unit 105. The QR / pallet storage unit 207 stores data generated by the QR / pallet association unit 107. The manufacturing time storage unit 209 stores the manufacturing time of the product in S11 of FIG.

<Direct marking device 2>
The direct marking device 2 is a device that adds QRID to a cardboard 7 filled with bottles 5 and flowing through the conveyor without stopping the flow of the conveyor. Receives data generated by the QRID management / generation unit 103 of the traceability management apparatus 1 that includes a control unit and a communication unit (not shown) and is connected via the network 4, generates a QR code 9, and adds it to the cardboard 7. To do. At this time, since the QRID is a unique number within the lot in which the bottle 5 to be packed is manufactured, the QRID is different if the cardboard 7 is different within a certain lot.

<Pallet label output device 3>
The pallet label output device 3 is a device that adds a pallet ID to the pallet 11 on which the cardboard 7 to which the QR code 9 is added is mounted. A bar code 13 is generated by receiving data generated by the pallet ID management / generation unit 105 of the traceability management apparatus 1 connected via the network 4, including a communication unit 31, a pallet label output unit 33, and a control unit (not shown). And added to the pallet 11. At this time, the pallet label output unit 33 outputs a label including the barcode 13. Such a label may be manually attached to the pallet 11 or may be automatically attached by a machine.

<Lot data>
FIG. 3 is a diagram showing data generated by the lot ID management / generation unit 101 and stored in the lot data storage unit 201. FIG. 3A shows the relationship between the lot and the time for filling the bottle 5 in the cardboard 7. ) Is a diagram showing data stored in the lot data storage unit 201.

  As shown in FIGS. 3A and 3B, for example, a lot represented by a production lot number (lot ID) “ao5y3lw” has a production start time “2015/4/10 10:00” The production end time is “2015/4/10 12:00”, the time required for production is “2 hours”, and the number of bottles 5 produced in the lot is “10,000”. The number of corrugated cardboards 7 in which the bottles 5 are packed is “1,000 boxes” (when ten bottles 5 are packed per one cardboard box 7), and the product code of the manufactured bottles 5 is “bqz8s01” is there.

  As shown in FIG. 3A, 10,000 bottles 5 are manufactured in 2 hours (= 7,200 s), and these are packed in 1,000 boxes of cardboard 7. Therefore, the time required to manufacture the bottle 5 packed in one box of cardboard 7 is “7.2 s (= 7,200 / 1,000)”. Then, the QRID management / generation unit 103 divides the required time of 2 hours into 1,000 sections (7.2 s per section), and generates a unique QRID for each section. In the present embodiment, QRID “00001” is packed on the cardboard 7 filled with ten bottles 5 manufactured during the first section, and ten bottles 5 manufactured during the second section are packed. A QRID “00002” is defined for the cardboard 7.

  Including the “required time per box” thus obtained, the lot ID management / generation unit 101 generates data as shown in FIG. 3B and stores it in the lot data storage unit 201.

<Association with QR code and palette ID>
4A and 4B are diagrams for explaining the association between the QR code 9 and the palette ID. FIG. 4A shows the contents of the QR code 9, and FIG. 4B shows the association between the palette ID and QRID.

  As shown in FIG. 4A, the QR code 9 printed on the cardboard 7 includes a “production lot (corresponding to a lot ID)” representing the lot in which the bottle 5 to be packed is manufactured, and the year of manufacture of the bottle 5. The date, “serial ID (corresponding to QRID)”, a product code indicating the product type of the bottle 5 and the expiration date of the bottle 5 are included. In the present embodiment, the QR code 9 does not include the “production time” of the bottle 5. This is because in order to generate the QR code 9 reflecting the manufacturing time for each bottle in real time, the load on the direct marking device 2 becomes large, and as a result, it is necessary to reduce the speed of the conveyor. This is because the time required for manufacturing the product increases, and the productivity decreases. Such data is generated by the QRID management / generation unit 103 and stored in the QRID storage unit 203.

  A pallet ID is generated for each pallet 11 by the pallet ID management / generation unit 105, and a barcode 13 including the pallet ID is added to the pallet 11. In order to associate the pallet 11 with the mounted cardboard 7 at S17 in FIG. 1, data as shown in FIG. 4B is generated by the QR / pallet association unit 107, and the QR / pallet storage unit 207 is created. Is remembered. In the present embodiment, 50 boxes of cardboard 7 specified by QRID “00001” to “0000000” are mounted on the pallet 11 specified by the pallet ID “001”, and specified by the pallet ID “002”. The pallet 11 is loaded with 45 boxes of cardboards 7 specified by QRID “00051” to “00095”, and the pallet 11 specified by pallet ID “003” is specified by QRID “00096” to “00140”. 45 boxes of cardboard 7 are mounted.

<Bottle>
FIG. 5 is a diagram illustrating the bottle 5 manufactured in S11 of FIG. Each bottle 5 is provided with a label on which the time of manufacture is written, and is also engraved on the main body of the bottle 5 by laser engraving. This is because the manufacturing time of the bottle 5 is reliably specified even when the bottle 5 with the label peeled off is sent as a defective product. In addition, although not shown about a label, various information, such as a brand name and a expiration date, is included besides manufacturing time. In the present embodiment, the manufacturing time is printed on the label in units of one second (the fractional part is rounded down), and data representing the manufacturing time is stored in the manufacturing time storage unit 209 in S11 of FIG. Note that the method of recording the manufacturing time is not limited to the above method, and is adjusted as appropriate in units of 5 seconds or 10 seconds. Further, the information related to the manufacturing time may be information indicating a lot classification or QRID instead of the time itself.

<Direct marking>
FIG. 6 is a diagram when the QR code 9 is added to the cardboard 7 packed with the bottle 5 in S13 of FIG. The cardboard 7 is transferred on the belt conveyor 15, and the QR code 9 is sequentially added by the direct marking device 2 provided on the side. At this time, the direct marking device 2 receives data from the traceability management device 1 connected via the network 4, and generates a QR code 9 including a different QRID for each cardboard 7.

<Installation on pallet>
FIG. 7 is a diagram illustrating a state in which a plurality of cardboards 7 are mounted on the pallet 11 in S15 of FIG. In S17 of FIG. 1, a barcode 13 representing the palette ID is added to the palette 11. At the time of mounting on the pallet 11, an on-site worker optically reads the barcode 13 of the pallet 11 and the QR code 9 added to the plurality of cardboards 7 mounted on the pallet 11 with a code reader or the like. By transmitting the received data to the traceability management apparatus 1, the QR / pallet correspondence unit 107 generates data as shown in FIG. Alternatively, the QR / pallet correspondence unit 107 may automatically generate the number of boxes of cardboard 7 to be mounted on the pallet 11, which is determined for each pallet 11. For example, in the present embodiment, so-called “first-in first-out”, which is transported first from the cardboard 7 that has been manufactured first, is adopted, so that the pallet 11 with the pallet ID “001” has 50 boxes and the pallet with the pallet ID “002”. If 45 are input to the traceability management apparatus 1 in advance as 45 in the pallet 11 and 45 in the pallet 11 with the pallet ID “003”, the QRID can be sequentially associated with the pallet ID based on the number of boxes.

<Distribution of bottles>
FIG. 8 is a diagram conceptually showing the distribution of the bottle 5 in S19 of FIG. The pallets 11 with the pallet IDs “001” and “002” are conveyed to the wholesaler X, and flow from there to the supermarkets a and b and the convenience stores c and d. The pallets 11 having the pallet IDs “003” to “005” are conveyed to the wholesaler Y, and flow from there to the soba shop e and the ramen shop f. At this time, as described above, for each pallet 11 transported by the worker, the notification destination name and the like are stored as history data and transmitted to the traceability management apparatus 1. In addition, you may convey directly to a major supermarket etc. without going through a wholesaler.

<Specification flow for bottles and pallets>
FIG. 9 is a diagram showing a flow for identifying the correspondence between the bottle 5 and the pallet 11, (a) is a flow for identifying the pallet 11 from the bottle 5, and (b) is for identifying the bottle 5 from the pallet 11. It is a figure showing a flow. For example, it is assumed that the bottle 5 has been mailed by the consumer because of a quality problem (S21). Then, the lot is specified based on the manufacturing time recorded in the bottle 5 and the cause is investigated. This can be done by referring to the lot data shown in FIG. If the cause of the quality problem affects the entire lot (S23: NO), the collection of the entire lot proceeds as in the past (S29b). When the cause of the quality problem is only in one or more specific time zones (sections) in the lot (S23: YES), the bottle 5 is packed from the manufacturing time recorded in the defective bottle 5 The first packing container specifying unit 111 specifies the QRID added to the corrugated cardboard 7 (S25). In this embodiment, when a problem occurs in the quality only in the bottle 5 manufactured in the section where the bottle 5 that has been mailed as a defective product is manufactured (such as when a water leak has occurred in such a time zone), this is required. When the bottle 5 mounted on the pallet 11 to which the bottle 5 is shipped has a wide quality problem (such as a mouse entering the pallet 11), or the bottle 5 transported by the transport vehicle carrying the bottle 5 It is assumed that there is a problem in quality widely (for example, the bottle 5 is left in a high temperature environment for a long time due to a trouble with the transport vehicle).

  Referring to FIG. 3, for example, when the manufacturing time is “2015/4/10 10:10”, it can be specified that the bottle 5 is manufactured 10 minutes (600 s) after the start of manufacturing in the lot. Then, since the “required time per box” is “7.2 s”, the 84th cardboard 7, that is, QRID is “00084” from “600 / 7.2 = 83.3. It can be seen that the cardboard 7 is packed. In other words, among the sections divided into 1,000 pieces as shown in FIG. 3A, the cardboard 7 is packed in the 84th section. That is, the first packaging container specifying unit 111 specifies the QRID with reference to the manufacturing time storage unit 209 and the lot data storage unit 201.

  Next, the transport tool specifying unit 113 specifies the pallet 11 on which the corrugated cardboard 7 with the specified QRID is mounted (S27). Referring to FIG. 4, it can be seen that the cardboard 7 to which the QRID “00084” is added is mounted on the pallet 11 with the pallet ID “002”. That is, the transporting tool specifying unit 113 specifies the pallet ID with reference to the specified QRID and the QR / pallet storage unit 209.

  Next, from FIG. 8, it is possible to specify that the destination of the pallet 11 with the pallet ID “002” is the wholesaler X, so in cooperation with the wholesaler X, the supermarket and the convenience store are notified of the collection ( S29a). Details of S29 will be described later.

  In this way, when the bottle 5 received as a defective product is the starting point, and the problem that has occurred in the bottle 5 occurs only in a specific section, the bottle 5 is packed from the manufacturing time of the bottle 5. It is possible to identify the QRID added to the corrugated cardboard 7 and thereby identify the corresponding pallet ID. Therefore, it is necessary to truly collect within the same lot without collecting the entire lot as in the past. Only the pallet 11 can be specified.

  Next, FIG. 9B will be described. Assume that a certain wholesaler, for example, wholesaler Y in FIG. 8, reports that there is a problem with the quality of a product conveyed on a specific day (S31). Of the pallet IDs “003” to “005” (see FIG. 8) added to the pallet 11 transported to the wholesaler Y, the pallet ID added to the pallet 11 transported on the specific day is “003”. ”. This is specified with reference to the data associated with the pallet ID and the transport destination stored in S19 of FIG. Then, based on the pallet ID “003”, the second packing container specifying unit 117 specifies the QRID added to the cardboard 7 mounted on the pallet 11 (S33). Referring to FIG. 4, it can be seen that the QRIDs are “00096” to “00140”.

  Next, the product specifying unit 119 specifies the manufacturing time of the bottle 5 packed in the corrugated cardboard 7 to which the specified QRID is added (S35). QRID “00096” to “00140” are cardboards 7 filled with bottles 5 manufactured between the 96th section and the 140th section, so that “start time of the 96th section = 10: 00 + 96 × 7.2 = 10:11:31 "and" Manufacturing end time of section 140 = 10:00 + 141 x 7.2 = 10: 16: 51.2 seconds ".

  Next, with respect to the bottle 5 manufactured in such a time zone and the bottle 5 manufactured in other time zones, the data stored in a quality control system (not shown) is compared, and a security camera provided at the manufacturing site is also combined. Use various sensors to investigate the cause. If the cause affects the entire lot (S37: No), the entire lot is collected as in the conventional case (S39b). On the other hand, when the cause affects only the 96th section to the 140th section (S37: Yes), it cooperates with the wholesaler Y and informs the soba shop e and the ramen shop f of the collection (S39a). At this time, if only the bottles 5 corresponding to the pallet 11 “003” can be specified, the bottles 5 are collected within that range. to recover. As a result of investigating the cause, a problem occurred in the transport vehicle that transported the pallet 11 with the pallet ID “003”, and the quality of the product packed in the bottle 5 because the pallet 11 was left in the transport vehicle for a long time Even if it is determined that a problem has occurred, only the bottle 5 corresponding to the pallet ID “003” is set as the collection target.

  In this way, starting from the pallet 11 to which the bottle 5 received as a defective product is transported, the production time of the other bottle 5 mounted on the pallet 11 is specified, and the cause of the problem is a specific section in the lot. This will help you determine whether it affects only the whole or the whole. As a result, if the cause of a problem affects only a specific section, only those that really need to be recovered within the same lot can be specified in units of 11 pallets without recovering the entire lot as in the past. can do.

<Recovery range>
Next, processing for determining the collection range of defective products will be described with reference to FIG. FIG. 10A is a flow for determining the collection range, and FIG. 10B is a diagram showing a breakdown of the cardboard 7 mounted on the pallet 11. Such processing is executed by the determination unit 121 of FIG. Specifically, it is a process of determining the collection range in S29a of FIG. 9, and when a problem occurs in quality only in the bottle 5 manufactured in a specific section (time zone), that is, a certain cardboard 7 (hereinafter, referred to as a cardboard 7). A case where a quality problem occurs only in the bottle 5 packed in the target cardboard will be described.

  In the example of FIGS. 8 and 9, the pallet 11 with the pallet ID “002” was transported only by the wholesaler X, but the bottles transported to the wholesalers A, B and C on the same pallet 11. It is assumed that 5 is loaded and transported to each. Then, the cause is investigated based on the bottle 5 collected as a defective product, and it is assumed that a quality defect has occurred in the bottle 5 packed in the cardboard 7 (target cardboard) of QRID “0201” to “0240”. In such a case, first, in S41, the determination unit 121 acquires the mounting breakdown of the pallet 11 from the history data. For example, as shown in FIG. 10B, the data indicates that 76 cardboards 7 with QRID “00195” to “00270” are mounted on the pallet 11 with the pallet ID “008”.

  Next, in S43, the transport destination of each cardboard 7 is specified based on the QRID of the target cardboard. From FIG. 10B, it can be identified that the target cardboard has been transported to Company A and Company B. In S45, the A company and the B company are determined as the collection range, and the result is output to the display unit 40.

  In this way, products can be tracked not in lot units as in the prior art, but in pallet units, and the collection range can be determined in consideration of the transport destination. As a result, the product can be collected very efficiently.

Second Embodiment
Next, a second embodiment of the present invention will be described. In the second embodiment, a factory A having a system including the traceability management apparatus 1 as in the first embodiment does not have a system including the traceability management apparatus 1 as in the first embodiment. This is an example in which the QRID added to 7 can be generated, but the bottles 5 manufactured at the factory B that does not have the function of associating the QRID with the pallet ID are collected and transported together.

  Since the factory B does not have such an association function, data as shown in FIG. 4B cannot be generated when the bottle 5 manufactured in the factory B is transported to the factory A. Therefore, in place of S17 in FIG. 1, in addition to the bar code 13 in the pallet 11 in FIG. 7, a QR code 9 including the QRID added to the cardboard 7 mounted on the pallet 11 is further added. Then, the operator reads the barcode 13 and the QR code 9 together with a code reader or the like, thereby generating data as shown in FIG. At this time, the information included in the QR code 9 may be QRID added to all the cardboards 7 to be mounted, and the cardboard 7 mounted with the lowest number among the QRIDs added to the cardboards 7 to be mounted. It may be a combination of the numbers.

  Thereby, even in the bottle 5 manufactured in the factory B that does not have the system including the traceability management apparatus 1, QRID and pallet ID can be associated with each other as in the first embodiment. 5 can be tracked.

<Third Embodiment>
Next, a third embodiment of the present invention will be described. The third embodiment is an example in which a cardboard 7a packed with bottles 5a (for example, soy sauce) and cardboards 7b packed with bottles 5b (for example ponzu), which are different types of products, are mounted on one pallet 11. .

  Unlike FIG. 4B of the first embodiment, the pallet 11 to which the pallet ID “001” is added includes 30 cardboards 7a to which the QRIDs “00001” to “00030” are added, and the QRID “00001”. Suppose that 20 cardboards 7b added with “00020” are mixed and mounted. Here, the lot in which the bottle 5a corresponding to the QRID “001” is manufactured and the bottle 5b corresponding to the QRID “001” are manufactured on different lines, so that they can be distinguished from each other even if the QRID is the same.

  Similarly to the first embodiment, for example, when soy sauce (bottle 5a) is mailed as a defective product from the consumer, the pallet 11 on which the bottle 5a is mounted is specified according to the flow of FIG. 9A. In addition, the bottle 5b can be similarly specified when the ponzu (bottle 5b) is mailed as a defective product from the consumer. This is made possible by adding a QRID unique to the lot to the cardboards 7a and 7b and associating them with the pallet ID added to the pallet 11 on which each is mounted. Note that the flow in FIG. 4B is also possible.

  In this way, even in the case of so-called “mixed loading” in which cardboards 7 packed with a plurality of types of production are loaded on one pallet 11, the pallet 11 corresponding to the bottle 5 is not a lot unit but a pallet 11 unit. Conversely, the bottle 5 corresponding to the pallet 11 can be specified.

  While the first to third embodiments of the present invention have been described above, the present invention is not limited to these. For example, instead of the QR code 9 and the bar code 13, an IC chip including information corresponding to these may be added to the cardboard 7 and the pallet 11, and information may be collected electromagnetically by a chip reader or the like. Further, in the traceability management device 1 of FIG. 2, the storage unit 20 may be provided in an external server and communicate with the control unit 10 via the network 4. Furthermore, as the pallet label output device 3, a label printer that can print data representing the barcode 13 generated by the traceability management device 1 can be used.

1: Traceability management device, 10: Control unit, 101: Lot ID management / generation unit, 103: QRID management / generation unit, 105: Pallet ID management / generation unit, 107: QR / pallet correspondence unit, 109: Transmission / reception unit , 111: first packing container specifying unit, 113: transporting tool specifying unit, 115: controller, 117: second packing container specifying unit, 119: product specifying unit, 121: determination unit, 20: storage unit, 201: lot data Storage unit 203: QRID storage unit 205: Pallet ID storage unit 207: QR / pallet storage unit 209: Manufacturing time storage unit 30: Operation unit 40: Display unit 4: Network 5: Bottle 7 : Cardboard, 9: QR code, 11: Pallet, 13: Bar code

Claims (7)

(1) A packaging container identification number assigned to each packaging container packaged for each of a plurality of products manufactured in the section, by dividing the time required for a production lot, which is a unit for manufacturing a product, into a plurality of sections A first receiver for receiving first data associated with a carrier identification number assigned to each carrier equipped with the plurality of packaging containers;
(2) a second receiving unit that acquires second data representing at least two of the start time, end time, or required time of the production lot;
(3) Based on the manufacturing time of the product, the number of products in which the product is packed in the packing container, and the second data, it is determined which of the plurality of sections the manufacturing time of the product belongs to, and the section A packaging container identification unit that identifies the packaging container identification number corresponding to the item (4), which is related to the transportation of the product to be tracked based on the packaging container identification number identified by the packaging container identification unit and the first data. A carrier specifying unit for specifying the carrier,
Traceability management device having The traceability management apparatus according to claim 1, further comprising: a determination unit that acquires information about the packaging container mounted on the identified transporting tool and determines a range to be collected. The traceability management device according to claim 2, further comprising: an output unit that outputs a range determined as a collection target by the determination unit. The packaging container identification number is:
It is a unique number in the production lot in which the product to be packed in the packing container is manufactured.
The traceability management apparatus according to any one of claims 1 to 3. In the case where the packing container identification number does not correspond to the carrier identification number, the data representing the packing container identification number or the data representing the manufacturing lot and information for identifying the product manufactured in the manufacturing lot A first code image including the first code image and a second code image including the data representing the transporter identification number are pasted on the transporter, and the pasted first code image and the second code image are read. And a reading code correspondence unit for associating the packing container identification number with the transporting tool identification number,
The traceability management apparatus according to any one of claims 1 to 4, further comprising: (1) A packaging container identification number assigned to each packaging container packaged for each of a plurality of products manufactured in the section, by dividing the time required for a production lot, which is a unit for manufacturing a product, into a plurality of sections A first receiver for receiving first data associated with a carrier identification number assigned to each carrier equipped with the plurality of packaging containers;
(2) a second receiving unit that acquires second data representing at least two of the start time, end time, or required time of the production lot;
(3) a packing container specifying unit that specifies the packing container identification number corresponding to the carrier identification number to be traced based on the first data received by the first receiving unit; and (4) the packing Based on the packing container identification number specified by the container specifying unit and the second data, it is determined which of the plurality of sections the packing container identification number belongs to, and the product manufactured in the section is specified. Product identification department,
Traceability management device having Computer
A traceability management device that tracks products with an arbitrary granularity,
(1) A packaging container identification number assigned to each packaging container packaged for each of a plurality of products manufactured in the section, by dividing the time required for a production lot, which is a unit for manufacturing a product, into a plurality of sections A first receiving unit that receives first data associated with a carrier identification number assigned to each carrier equipped with the plurality of packaging containers;
(2) a second receiving unit that acquires second data representing at least two of the start time, the end time, or the required time of the production lot;
(3) Based on the production time of the product, the number of products packed in the packaging container, the first data, and the second data, which of the plurality of sections the production time of the product belongs to And (4) a tracking target based on the packaging container identification number and the first data identified by the packaging container identification unit. A transport tool identifying unit for identifying a transport tool involved in transporting the product
A program for functioning as a traceability management device having