JP2013120410A - Product tracking-system and product tracking-program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To allow reduction of a work load of a user required to build information necessary for enabling tracking of a product in a distribution channel.SOLUTION: A product tracking-system includes: a virtual ID issuance part 17 for issuing a virtual ID to a packing style ID of a product; a first correlation process part 18 for correlating the virtual ID with product information; a second correlation process part 20 for correlating the virtual ID with the packing style ID; and a third correlation process part 22 for correlating master-slave relation of a set of virtual IDs before and after movement of a product when a new virtual ID is issued by the change of a packing style ID in association with movement of the product. The configuration of enabling tracking of a product in a distribution channel by following the master-slave relation of the virtual IDs using the correlation of the master-slave relation between the set of virtual IDs as well as the correlation between the packing style ID and the virtual ID corresponding thereto makes it possible to eliminate a cumbersome work such as manually inputting of product information every time the product is moved in event such as delivery and receiving.

Description

  The present invention relates to a product tracking system and a product tracking program, and is particularly suitable for use in a system for tracking a distribution channel of a product.

  Conventionally, much effort and time have been spent in order to track products that are distributed between bases such as factories, warehouses, and stores, and to specify distribution routes. For example, if you want to track the distribution route of a product based on information entered on a slip or work slip, the slip will be based on the delivery date / time, receipt date / time, etc. of the target product at each delivery location or each entry location. And tracking while confirming the work slip. Therefore, it takes a lot of manpower and time, and accuracy is not guaranteed.

  On the other hand, a system for managing a product distribution route by an information processing technique using a computer has been proposed (see, for example, Patent Documents 1 and 2). Usually, a product is assigned a product number for identifying the product, a lot ID for identifying a lot which is the minimum unit of production or the unit of minimum sales of the product, and the like. In order to be able to track the distribution channel of the product with a computer, in addition to the product number and lot ID, the production date of the product, The user needs to manually input product information including the expiration date, manufacturer, and quantity into the computer.

  In the technique described in Patent Document 1, a distribution identification number / symbol is assigned for each shipment unit (lot) of the producer or group in the production area, and the total amount (weight or capacity) of the lot and attachment of the product packaging are attached. By recording the number and unit quantity of labels and the label issuance time stamp, verification can be performed for each unit of the distribution process.

  In the technology described in Patent Document 2, the distribution status of individual products, changes in form, and identification information of individual products are collected from each distribution base of individual products, and each collected information is linked according to a predetermined rule. To do. And by grasping and managing the flow of distribution based on the linked information, it is possible to grasp what route the individual product has taken from what route.

JP 2004-94688 A JP 2005-267625 A

  If you use a system that manages the distribution channels of products using information processing technology using a computer, you can track the distribution channels of products compared to managing distribution channels based on information entered in slips and work slips. Work burden can be reduced. However, each time a product moves due to exit or receipt, product information must be manually entered into the computer. That is, there is a problem that a troublesome work such as manual input of product information has to be performed every time the product moves in order to construct information necessary for tracking the distribution channel.

  The present invention has been made to solve such a problem, and in order to construct information necessary to enable tracking of the distribution route of the product, the product information of each time the product moves is stored. It is an object to eliminate troublesome work such as manual input and reduce the work burden on the user.

  In order to solve the above-described problems, in the present invention, product information of a product to be distributed and a package ID assigned to the package of the product are acquired, and a virtual ID is issued for the package ID. Then, the product information and the virtual ID are associated with each other and stored in the first association table, and the package form ID and the virtual ID are associated with each other and stored in the second association table. Further, when a new virtual ID is issued due to a change in the package ID accompanying the movement of the product, the parent-child relationship between the virtual IDs before and after the movement of the product is linked and stored in the third linking table.

  According to the present invention configured as described above, when product information and package ID of a product are first obtained, a virtual ID is automatically issued for the package ID, and product information and virtual ID are The package ID and the virtual ID are linked and managed while being linked and managed. After that, when a new package ID is acquired in the product distribution process, a virtual ID is automatically issued for the new package ID, and the package ID and virtual ID are newly linked and managed. The Further, parent-child relationship is automatically assigned and managed between virtual IDs respectively associated with package IDs before and after product movement.

  Therefore, the parent and child of the virtual ID can be obtained by using the association between the package ID given in the product distribution process and the virtual ID issued to the package ID and the parent-child relationship between the virtual IDs before and after the product movement. By following the relationship, it is possible to trace the distribution route of the product specified by the package ID associated with the virtual ID.

  As a result, if the association between the product information of the product and the virtual ID issued for the package ID acquired first is stored in the first association table, in the subsequent distribution process of the product, Each time the product moves due to warehousing, etc., the troublesome work of manually entering product information can be eliminated. Therefore, it is possible to easily perform the work for constructing information necessary for tracking the product distribution route, and to reduce the work burden on the user.

It is a figure which shows the outline of the whole structure of the product tracking system by this embodiment. It is a block diagram which shows the function structural example of the server by this embodiment. It is a figure which shows an example of the 1st tied table by this embodiment. It is a figure which shows an example of the 2nd tied table by this embodiment. It is a figure which shows an example of the 3rd tied table by this embodiment. It is a figure which shows an example of the 4th tied table by this embodiment. It is a figure which shows an example of the event history table by this embodiment. It is a figure which shows an example of the menu screen displayed in the handy terminal or PC of this embodiment. It is a flowchart which shows the operation example at the time of performing initial registration of a product in this embodiment. It is a figure which shows the movement image of the product at the time of performing initial registration in this embodiment. It is a flowchart which shows the operation example at the time of performing the delivery of a product in this embodiment. It is a figure which shows the movement image of the product at the time of performing warehousing in this embodiment. It is a flowchart which shows the operation example at the time of warehousing of a product in this embodiment. It is a figure which shows the movement image of the product at the time of performing warehousing in this embodiment. It is a flowchart which shows the operation example at the time of transshipment of a product in this embodiment. It is a figure which shows the movement image of the product at the time of transshipment in this embodiment. It is a flowchart which shows the operation example at the time of mounting a product in the location in a base in this embodiment. It is a figure which shows the movement image of the product at the time of mounting in the location in a base in this embodiment. It is a flowchart which shows the operation example at the time of taking out a product from the location in a base in this embodiment. It is a figure which shows the movement image of the product at the time of taking out from the location in a base in this embodiment. It is a figure which shows the specific example regarding operation | movement of the product tracking system by this embodiment. It is a figure which shows another specific example regarding operation | movement of the product tracking system by this embodiment. It is a figure which shows another specific example regarding operation | movement of the product tracking system by this embodiment.

  Hereinafter, an embodiment of the present invention will be described with reference to the drawings. FIG. 1 is a diagram showing an outline of the overall configuration of the product tracking system according to the present embodiment. As shown in FIG. 1, the product tracking system of this embodiment includes a server 100, a handy terminal 200, and a personal computer (hereinafter referred to as a PC) 300, and the handy terminal 200 and PC 300 are connected to the server 100 via the Internet 400. It is configured to be connectable.

  In the product tracking system of this embodiment, one server 100 is provided. Further, at least one handy terminal 200 and PC 300 are provided for each base such as a factory, a warehouse, and a store. The handy terminal 200 and the PC 300 are used when inputting various information such as product information, package ID, place ID, location ID, and search key. As means for inputting the various information, an input device such as a keyboard and a mouse, a barcode reader, an RFID (Radio Frequency IDentification), or the like can be used.

  Here, the product information is information relating to the product to be distributed. For example, the product number for identifying the product, the lot number for identifying the lot of the product, the date of manufacture of the product, the expiration date, the manufacturer, the quantity Information. The packing form ID is information for identifying a packing form (conveyance management unit) in which one or more products are collectively formed in the distribution process. There are pallets, carts, containers, etc. In the following, for simplification of explanation, it is assumed that two pallets and containers are used as the packing form. The place ID is information for uniquely identifying each base such as a factory, a warehouse, and a store. The location ID is information for identifying a product placement position (location such as a flat placement area or a shelf) in the base.

  The search key is information used when tracking a product distribution route. For example, product information, packing ID, location ID, date and time when an entry / exit event occurs can be used as a search key.

  The handy terminal 200 and the PC 300 have a communication function, and various types of information such as product information, packing ID, location ID, and location ID input by a keyboard, barcode reader, RFID, etc. are input date and time information ( This represents the date and time of event occurrence) and is transmitted to the server 100 via the Internet 400. Note that the date / time information can be automatically acquired using a timekeeping function provided in the handy terminal 200 and the PC 300. In addition, the handy terminal 200 and the PC 300 also transmit event information described later. Furthermore, the handy terminal 200 and the PC 300 also transmit a search key to the server 100.

  FIG. 2 is a block diagram illustrating a functional configuration example of the server 100 according to the present embodiment. Each functional configuration of the server 100 described below can be realized by any of a hardware configuration, a DSP (Digital Signal Processor), and software. For example, when realized by software, each functional configuration of the server 100 can be realized by the CPU or MPU operating according to a product tracking program stored in a recording medium such as a hard disk.

  As a recording medium for recording the product tracking program, a ROM, a flexible disk, a magnetic tape, an optical disk, a magneto-optical disk, a DVD (Digital Versatile Disk), a nonvolatile memory card, or the like can be used in addition to a hard disk. The product tracking program may be downloaded to the server 100 via a network such as the Internet 400.

  In FIG. 2, the communication unit 11 communicates with the handy terminal 200 or the PC 300 via the Internet 400. For example, the communication unit 11 receives various pieces of information such as the product information, the package ID, the place ID, the location ID, the date information, the event information, and the search key. In addition, the communication unit 11 transmits the search result of the distribution route performed by the search processing unit 30 (described later) to the handy terminal 200 or the PC 300 using the search key.

  The product information acquisition unit 12 acquires product information received by the communication unit 11. The packing form ID acquisition unit 13 acquires the packing form ID received by the communication unit 11. The location ID acquisition unit 14 acquires the location ID received by the communication unit 11. The location ID acquisition unit 15 acquires the location ID received by the communication unit 11. The event information acquisition unit 16 acquires event information and date / time information received by the communication unit 11.

  The virtual ID issuing unit 17 issues a virtual ID to the package ID acquired by the package ID acquisition unit 13. Further, the virtual ID issuing unit 17 issues a virtual ID to the location ID acquired by the location ID acquiring unit 14. Note that the virtual ID issuing unit 17 always issues a virtual ID to the first package form ID acquired by the package form ID acquiring unit 13 at the time of initial registration of the product. On the other hand, the virtual ID issuing unit 17 acquires the package ID or location ID acquired by the package ID acquisition unit 13 when performing product entry, delivery, transshipment, placement, removal, etc. after the initial registration. A virtual ID is appropriately issued for the location ID acquired by the unit 14. Details on when the virtual ID is issued and when it is not issued will be described later.

  The first association processing unit 18 associates the product information acquired by the product information acquisition unit 12 and the virtual ID issued by the virtual ID issuing unit 17 and stores them in the first association table 19. FIG. 3 is a diagram illustrating an example of the first association table 19. In this embodiment, product information including the product number, lot number, date of manufacture, expiration date, manufacturer, initial quantity and current quantity of the product included in the package, and the virtual ID issuing unit 17 These virtual IDs are associated with each other and stored in the first association table 19.

  The initial quantity of products refers to the quantity of products included in the package at the time of initial registration. The current product quantity refers to the latest product quantity in the distribution process after initial registration. In the product distribution process, one package may be divided into two or more packages. When the package is divided, the number of products included in the package after the division is smaller than that before the division. In that case, the current quantity of the product indicated by the product information is smaller than the initial quantity. Details of such update of product information will be described later.

  The second association processing unit 20 associates the package form ID acquired by the package form ID acquisition unit 13 with the virtual ID issued by the virtual ID issue unit 17 and stores the package ID in the second association table 21. When a new virtual ID is not issued by the virtual ID issuing unit 17 for the package ID, the second linking processing unit 20 includes the package ID acquired by the package ID acquisition unit 13 and the second ID. Are associated with the virtual IDs already stored in the second association table 21 and stored in the second association table 21.

  For example, when a product is transshipped from one pallet to another in the base, if the package is not divided or integrated, a new virtual ID is added to the package ID of the pallet after transshipment. Is not issued by the virtual ID issuing unit 17. In this case, the second linking processing unit 20 associates the second linking by linking the package ID newly acquired by the package ID acquiring unit 13 with respect to the pallet after transshipment and the package ID of the pallet before transshipment. The virtual IDs already stored in the table 21 are associated with each other and stored in the second association table 21.

  On the other hand, when the package is divided when the products are transshipped, a new package ID is acquired by the package ID acquisition unit 13 for the divided package, and the new package ID is obtained. A new virtual ID is issued by the virtual ID issuing unit 17. In addition, even when a plurality of packing forms are integrated into one packing form, a new packing form ID is acquired by the packing form ID acquisition unit 13 for the combined packing form, and the new packing form ID is obtained. On the other hand, a new virtual ID is issued by the virtual ID issuing unit 17. In these cases, the second association processing unit 20 associates these new package IDs and new virtual IDs with each other and stores them in the second association table 21.

  FIG. 4 is a diagram illustrating an example of the second pegging table 21. In the present embodiment, in addition to the package ID acquired by the package ID acquisition unit 13, the location ID acquired by the location ID acquisition unit 15 is also associated with the virtual ID and stored in the second association table 21. Yes. The date and time of association indicates the date and time when the second association processing unit 20 performs association. The association date / time indicates the date / time when the second association processing unit 20 canceled the association.

  The third association processing unit 22 associates the parent-child relationship between the virtual IDs before and after the product movement when a new virtual ID is issued by the virtual ID issuing unit 17 due to the change in the package ID accompanying the product movement. And stored in the third pegging table 23. That is, the third association processing unit 22 associates the virtual ID newly issued by the virtual ID issuing unit 17 with respect to the package ID after the product movement, and the package ID before the product movement. The parent-child relationship with the virtual ID already stored in the association table 21 is associated and stored in the third association table 23.

  FIG. 5 is a diagram illustrating an example of the third tying table 23. In the present embodiment, in addition to the two virtual IDs to be associated with each other in the parent-child relationship, the association date / time, the association location ID, the release date / time, and the release location ID are stored in the third association table 23. The association location ID indicates the location ID of the base where the parent-child association of the virtual ID is performed. The association release location ID indicates the location ID of the base where the association between the parent and child is released.

  When the location ID is acquired by the location ID acquisition unit 14 with the placement of the product at the location in the base, the fourth association processing unit 24 is a virtual ID corresponding to the package ID of the placed product. And the location ID acquired by the location ID acquisition unit 14 are stored in the fourth linking table 25. Here, the virtual ID is used when a new virtual ID is issued by the virtual ID issuing unit 17, and the virtual ID already stored in the second association table 21 is used when it is not issued.

  For example, when the product is placed at the location in the base, if the package is not divided or integrated, a new virtual ID is not issued by the virtual ID issuing unit 17 for the location ID. In this case, the fourth linking processing unit 24 is acquired by the location ID acquisition unit 14 and the virtual ID that is stored in the second linking table 21 in association with the package ID before being placed. The location ID is associated and stored in the fourth association table 25.

  On the other hand, when the package is divided, the location ID is acquired by the location ID acquisition unit 14 for the package that is divided and placed at the location in the base, and a new virtual ID is obtained for the location ID. Is issued by the virtual ID issuing unit 17. Further, when a plurality of packing forms are integrated into one in-site location, the location ID is acquired by the location ID acquisition unit 14 for the packing forms integrated and placed in the in-site location, and the location A new virtual ID is issued by the virtual ID issuing unit 17 for the ID. In these cases, the fourth association processing unit 24 associates these new virtual IDs and location IDs and stores them in the fourth association table 25.

  FIG. 6 is a diagram illustrating an example of the fourth pegging table 25. In the present embodiment, in addition to the location ID acquired by the location ID acquisition unit 14, the location ID acquired by the location ID acquisition unit 15 is associated with the virtual ID and stored in the fourth association table 25. In addition, the date of association and the date of release of association are also stored in the fourth association table 25.

  Based on the event information acquired by the event information acquisition unit 16, the event history recording unit 26 stores an event history related to product entry / exit in the event history table 27. FIG. 7 is a diagram illustrating an example of the event history table 27. In the present embodiment, the event history table 27 also stores a location ID, a location ID, and a virtual ID in addition to the warehousing / exiting event information and date / time information acquired by the event information acquisition unit 16. As for the location ID, the location ID, and the virtual ID, those acquired by the location ID acquisition unit 14, the location ID acquisition unit 15, and the virtual ID issue unit 17, or the second association table 21 and the fourth association table. Any one of those acquired from 25 is used as appropriate.

  In addition, when entering various information on the handy terminal 200 or the PC 300, the event information for entering / exiting selects what information related to the event input. That is, a menu screen as shown in FIG. 8 is displayed on the handy terminal 200 or the PC 300. In this menu screen, after the user selects one of initial registration, warehousing, warehousing, transshipment, loading, and taking out, the necessary information is input to each.

  The handy terminal 200 or the PC 300 automatically acquires event information according to what is selected on this menu screen, and transmits it to the server 100. In the server 100, the event information acquisition unit 16 acquires this event information and supplies it to the event history recording unit 26. As a result, the event history recording unit 26 can store the event information in the event history table 27. In FIG. 8, only event information related to loading / unloading is stored, but event information related to initial registration, transshipment, loading, and removal may be further stored.

  By the way, when the package is divided along with the movement of the product, the number of products included in the package after division is smaller than that before the division. In this case, the handy terminal 200 or the PC 300 inputs product information including the number of products included in each package after division, and transmits the product information to the server 100. In the server 100, the product information is received by the communication unit 11, and the product information acquisition unit 12 acquires the number of products included in the divided package. Thus, the product information acquisition unit 12 also functions as the product number acquisition unit in the claims.

  The product information update unit 28 updates the product information stored in the first association table 19 based on the number of products acquired by the product information acquisition unit 12 (product number acquisition unit). Specifically, in the first association table 19, the product record indicated by the product information acquired by the product information acquisition unit 12 is copied to increase one record, and the original record and the increased record are divided. Assign to the last two packages. Then, the number of products included in each of the divided packages obtained by the product information acquisition unit 12 (product number acquisition unit) is stored in the field indicated by “current quantity” of the two records. Let For the increased records, the virtual ID newly issued by the virtual ID issuing unit 17 is stored.

  When a new package ID is acquired by the package ID acquisition unit 13 as the product is moved, if the number of products is not acquired by the product information acquisition unit 12 (product number acquisition unit), for example, When the product moves to another pallet without being divided due to transshipment or the like, the virtual ID issuing unit 17 adds a new package ID to the newly acquired package ID corresponding to the other pallet. Do not issue a virtual ID. In this case, the second association processing unit 20 associates the new packaging form ID with the virtual ID associated with the packaging form ID before the product movement, and stores it in the second association table 21.

  On the other hand, when a new package ID is acquired by the package ID acquisition unit 13 as the product is moved, if the number of products is acquired by the product information acquisition unit 12 (product number acquisition unit), for example, When the packing form is divided and a part of the product is moved to a new pallet, the virtual ID issuing unit 17 creates a new virtual ID for the newly acquired packing form ID corresponding to the new pallet. Issue.

  In this case, the second association processing unit 20 associates the new package ID and the new virtual ID and stores them in the second association table 21. In addition, the third linking processing unit 22 is between the virtual ID linked to the package ID before the product movement and the new virtual ID linked to the new package ID after the product movement. The parent-child relationship is associated and stored in the third association table 23.

  In addition, when the location ID is acquired by the location ID acquisition unit 14 along with the movement of the product, if the number of products is not acquired by the product information acquisition unit 12 (product number acquisition unit), for example, the package shape is divided. If the product is placed at the location in the base without being issued, the virtual ID issuing unit 17 does not issue a new virtual ID for the location ID. In this case, the fourth association processing unit 24 associates the location ID with the virtual ID associated with the package ID before moving the product and causes the fourth association processing unit 24 to store it.

  On the other hand, when the number of products is acquired by the product information acquisition unit 12 (product number acquisition unit) when the location ID acquisition unit 14 is acquired by the location ID acquisition unit 14 along with the movement of the product, When the figure is divided and a part of the product moves to the location in the base, the virtual ID issuing unit 17 issues a new virtual ID for the location ID.

  In this case, the fourth association processing unit 24 associates the location ID with the new virtual ID and stores them in the fourth association table 25. Further, the third linking processing unit 22 establishes a parent-child relationship between the virtual ID linked to the package ID before the product movement and the new virtual ID linked to the location ID after the product movement. It is linked and stored in the third linking table 23.

  Further, when a plurality of packing forms are integrated into one packing form as the product moves, that is, when a plurality of packing forms are integrated and the product moves to a new pallet, the packing form ID acquisition unit 13 Acquire a new package ID assigned to the package after integration. Further, the virtual ID issuing unit 17 issues a new virtual ID to the package ID newly acquired corresponding to the new pallet.

  In this case, the second association processing unit 20 associates the new package ID and the new virtual ID and stores them in the second association table 21. In addition, the third linking processing unit 22 includes a virtual ID linked to a plurality of package IDs before integration and a new virtual ID linked to a new package ID after integration. Each parent-child relationship is associated with each other and stored in the third association table 23.

  When a plurality of packages are moved to one in-base location and integrated with the movement of the product, the location ID acquisition unit 14 acquires the location ID assigned to the integrated in-base location. Further, the virtual ID issuing unit 17 issues a new virtual ID for the location ID.

  In this case, the fourth association processing unit 24 associates the location ID with the new virtual ID and stores them in the fourth association table 25. Further, the third linking processing unit 22 is provided between each virtual ID linked to a plurality of package IDs before integration and a new virtual ID linked to the location ID after integration. The parent-child relationship is associated and stored in the third association table 23.

  The search key acquisition unit 29 acquires the search key (product information, package ID, location ID, date and time when the entry / exit event occurred) received by the communication unit 11, and supplies it to the search processing unit 30. The search processing unit 30 uses the search key acquired by the search key acquisition unit 29, the first linking table 19, the second linking table 21, the third linking table 23, the fourth linking table 25, an event The virtual ID is specified by referring to the history table 27 as appropriate.

  And using the association of product information and virtual ID, the association of package ID and virtual ID, the association of location ID and virtual ID, and the association of parent-child relationship between virtual IDs, the above-mentioned By tracing the parent-child relationship of the virtual ID thus specified, the distribution route of the product specified by the packing form ID linked to the virtual ID is traced. Then, the tracked distribution route information is supplied to the communication unit 11 and returned to the handy terminal 200 or the PC 300. In the handy terminal 200 or the PC 300, the distribution route information sent from the server 100 is displayed on the screen.

  For example, when tracking the distribution channel of a product from downstream, the search processing unit 30 specifies a virtual ID from a search key (for example, product information, location ID, event occurrence date and time), and compares the specified virtual ID and product information. The location ID and the event occurrence date and time of the base where the warehousing / exiting that matches the combination is searched. Then, the matched information is supplied to the communication unit 11 as distribution route information and is returned to the handy terminal 200 or the PC 300.

  On the other hand, when tracking a product distribution channel from upstream, one or more virtual IDs are specified from a search key (for example, product information, package ID or location ID, event occurrence date and time), and the specified one or more virtual IDs are identified. The location ID and the event occurrence date and time of the base where the warehousing / exiting that matches the combination of the ID and the product information are searched. Then, the matched information is supplied to the communication unit 11 as distribution route information and is returned to the handy terminal 200 or the PC 300.

  Next, the operation of the product tracking system according to the present embodiment configured as described above will be described. FIG. 9 is a flowchart showing an operation example when performing initial registration of a product to be distributed. FIG. 10 is a diagram showing a moving image of a product at the time of initial registration, and shows a state in which a product to be distributed is first loaded on a pallet.

  In FIG. 9, the handy terminal 200 or the PC 300 inputs the product information of the product, the pallet packing form ID, and the location ID of the base (step S1). Then, the input information is transmitted to the server 100 (step S2). In the server 100, the communication unit 11 receives information transmitted from the handy terminal 200 or the PC 300 (step S3). Then, the product information acquisition unit 12 acquires the product information received by the communication unit 11, the packing form ID acquisition unit 13 acquires the packing form ID, and the place ID acquisition unit 15 acquires the place ID (step S4). .

  The product information acquisition unit 12 supplies the acquired product information to the first association processing unit 18. The package ID acquisition unit 13 supplies the acquired package ID to the virtual ID issuing unit 17 and the second association processing unit 20. Further, the location ID acquisition unit 15 supplies the acquired location ID to the second association processing unit 20. The virtual ID issuing unit 17 that has received the package ID issues a virtual ID for the package ID (step S5). Then, the issued virtual ID is supplied to the first association processing unit 18 and the second association processing unit 20.

  The first association processing unit 18 associates the product information acquired by the product information acquisition unit 12 with the virtual ID issued by the virtual ID issuing unit 17, and stores it in the first association table 19 shown in FIG. Store (step S6). In addition, the second association processing unit 20 includes the package ID acquired by the package ID acquisition unit 13, the location ID acquired by the location ID acquisition unit 15, and the virtual ID issued by the virtual ID issue unit 17. Are stored in the second linking table 21 shown in FIG. 4 (step S7). Thereby, the process of the flowchart shown in FIG. 9 is completed.

  FIG. 11 is a flowchart illustrating an operation example when a product is delivered. FIG. 12 is a diagram illustrating a moving image of a product when performing a delivery. FIG. 12 shows a state in which the product is loaded into the container together with the pallet (FIG. 12A), and a state in which the product is picked up from the pallet and loaded into the container (FIG. 12B).

  In FIG. 11, the handy terminal 200 or the PC 300 inputs the pallet packing form ID, the container packing form ID, and the location ID of the base (step S11). Then, the input information is transmitted to the server 100 together with the event information (step S12). In the server 100, the communication unit 11 receives information transmitted from the handy terminal 200 or the PC 300 (step S13). Then, the package ID acquisition unit 13 acquires the package ID received by the communication unit 11, the location ID acquisition unit 15 acquires the location ID, and the event information acquisition unit 16 acquires the event information (Step S14). .

  The virtual ID issuing unit 17 issues a new virtual ID to the container packing ID acquired by the packing ID acquisition unit 13 (step S15). Then, the issued virtual ID is supplied to the second association processing unit 20. The second linking processing unit 20 includes the container packing ID acquired by the packing ID acquisition unit 13, the location ID acquired by the location ID acquisition unit 15, and the new ID issued by the virtual ID issuing unit 17. The virtual ID is associated and added and stored in the second association table 21 shown in FIG. 4 (step S16).

  When the product is picked up from the pallet and loaded into the container as shown in FIG. 12B, the pallet packing form ID acquired by the packing form ID acquisition unit 13 in the second pegging table 21 and its Releases the association with the virtual ID already associated with the package ID. Whether the product is picked up from the pallet and loaded into the container is specified by, for example, the user inputting information to the handy terminal 200 or the PC 300 and transmitting it to the server 100.

  Further, the third linking processing unit 22 refers to the second linking table 21 by using the pallet package ID acquired by the package ID acquisition unit 13, thereby linking the pallet package ID to the pallet package ID. Get the virtual ID. Then, the virtual ID associated with the packing form ID of the pallet is a child, and the new virtual ID issued by the virtual ID issuing unit 17 is parented to the packing form ID of the container, and the parent-child relationship of both virtual IDs is linked. Then, it is stored in the third pegging table 23 shown in FIG. 5 (step S17).

  Thereafter, the event history recording unit 26 stores the event information related to the delivery acquired by the event information acquisition unit 16 in the event history table 27 shown in FIG. 7 (step S18). Thereby, the process of the flowchart shown in FIG. 11 is completed.

  FIG. 13 is a flowchart showing an operation example when goods are received. FIG. 14 is a diagram illustrating a moving image of a product when warehousing is performed. FIG. 14 shows a state where a product is removed from the container together with the pallet (FIG. 14A), and a state where the product is picked up from the container and loaded onto the pallet (FIG. 14B).

  In FIG. 13, the handy terminal 200 or the PC 300 inputs a pallet packing form ID, a container packing form ID, and a location ID of the base (step S21). Here, in the case of FIG. 14A, the packing form ID of the pallet taken out from the container is input. In the case of FIG. 14B, the packing form ID of a newly prepared pallet is input. Then, the handy terminal 200 or the PC 300 transmits the input information to the server 100 together with the event information (step S22).

  In the server 100, the communication unit 11 receives information transmitted from the handy terminal 200 or the PC 300 (step S23). Then, the package ID acquisition unit 13 acquires the package ID received by the communication unit 11, the location ID acquisition unit 15 acquires the location ID, and the event information acquisition unit 16 acquires the event information (Step S24). .

  The virtual ID issuing unit 17 refers to the second associating table 21 and determines whether or not the pallet packing form ID acquired by the packing form ID acquiring unit 13 is already registered in the second linking table 21. (Step S25). Here, when the packing form ID of the pallet is already registered, the packing form ID is the packing form ID of the pallet taken out from the container (that is, the pallet loaded in the container at the time of delivery).

  In this case, the second pegging processing unit 20 includes the pallet packing form ID acquired by the packing form ID acquisition unit 13, the location ID related to the warehousing destination newly acquired by the location ID acquisition unit 15, The virtual ID already associated with the packing form ID of the pallet is associated with and added to the second association table 21 and stored (step S26).

  Further, the third linking processing unit 22 includes a virtual ID linked to the packing form ID of the pallet and a virtual ID linked to the packing form ID of the container in the third linking table 23. The parent-child relationship is released (step S27). Thereafter, the event history recording unit 26 adds and stores event information related to warehousing acquired by the event information acquiring unit 16 in the event history table 27 (step S28). Thereby, the process of the flowchart shown in FIG. 13 is completed.

  On the other hand, if it is determined in step S25 that the package ID of the pallet acquired by the package ID acquisition unit 13 is not yet registered in the second linking table 21, the package ID is taken out from the container. This means the package ID of a new pallet prepared for loading a new product.

  In this case, the virtual ID issuing unit 17 issues a new virtual ID for the package appearance ID of the new pallet (step S29). Then, the issued virtual ID is supplied to the second association processing unit 20. The second linking processing unit 20 is issued by the new pallet packing form ID acquired by the packing form ID acquiring unit 13, the place ID acquired by the place ID acquiring unit 15, and the virtual ID issuing unit 17. The new virtual ID is linked and added to the second linking table 21 and stored (step S30). Thereafter, the process of the flowchart shown in FIG. 13 is terminated through the process of step S28.

  FIG. 15 is a flowchart showing an operation example when transshipping products. FIG. 16 is a diagram showing a moving image of a product at the time of transshipment, and shows a state where the product is transshipped from one pallet to another pallet in the base. In this case, it is assumed that the packing form is not divided or integrated at the time of pallet reloading.

  In FIG. 15, the handy terminal 200 or the PC 300 inputs the pallet packing form ID before reloading, the pallet packing ID after reloading, and the location ID of the base (step S31). Then, the input information is transmitted to the server 100 (step S32). In the server 100, the communication unit 11 receives information transmitted from the handy terminal 200 or the PC 300 (step S33). Then, the package ID acquisition unit 13 acquires the two package IDs received by the communication unit 11, and the location ID acquisition unit 15 acquires the location ID (step S34).

  The second linking processing unit 20 links the pallet after reloading with the packing ID newly acquired by the packing ID acquisition unit 13 and the packing ID of the pallet before reloading in the second linking table 21. The already stored virtual ID and the location ID acquired by the location ID acquisition unit 15 are associated with each other and stored in the second association table 21. Further, the second linking processing unit 20 cancels the linking between the packing form ID of the pallet before reloading and the corresponding virtual ID (step S35). Thereby, the process of the flowchart shown in FIG. 15 is completed.

  When the package is divided and reloaded onto two pallets, product information (such as the number of products included in each divided package) is further input in step S31. The product information is also transmitted to the server 100 (step S32) and received by the communication unit 11 (step S33). This product information is acquired by the product information acquisition unit 12 (step S34) and supplied to the product information update unit 28. In response to this, the product information update unit 28 updates the contents of the first association table 19.

  Moreover, when dividing a package form and reloading it into two pallets, the package form ID acquisition part 13 acquires two package form IDs about the pallet after reloading. In this case, the virtual ID issuing unit 17 issues new virtual IDs for the package IDs of both pallets.

  Then, the second linking processing unit 20 includes one package ID acquired by the package ID acquisition unit 13, one virtual ID newly issued by the virtual ID issuing unit 17, and a place ID. The location ID acquired by the acquisition unit 15 is linked and added to the second linking processing unit 20 for storage. In addition, the second association processing unit 20 includes the other package ID acquired by the package ID acquisition unit 13, the other virtual ID newly issued by the virtual ID issuing unit 17, and the location ID. The location ID acquired by the acquisition unit 15 is linked and added to the second linking processing unit 20 for storage. Further, the third linking processing unit 22 is a parent-child of each new virtual ID issued by the virtual ID issuing unit 17 and the virtual ID linked to the package ID corresponding to the package before the division. The relationships are associated with each other and stored in the third association table 23.

  FIG. 17 is a flowchart illustrating an operation example when placing a package in a location (flat placement area or shelf) in a certain base. FIG. 18 is a diagram showing a moving image of the product when the package is placed at the location in the base. FIG. 18 shows a state where the product is placed on the flat placement area together with the pallet (FIG. 18A), and a state where the product is taken out from the pallet and placed on the flat placement area (FIG. 18B). Here, it is assumed that the package is not divided or integrated when the package is placed at the location in the base.

  In FIG. 17, the handy terminal 200 or the PC 300 inputs the pallet packing form ID, the location ID of the location, and the location ID representing the location in the location (step S41). Then, the input information is transmitted to the server 100 (step S42). In the server 100, the communication unit 11 receives information transmitted from the handy terminal 200 or the PC 300 (step S43). Then, the package ID acquisition unit 13 acquires the package ID received by the communication unit 11, the location ID acquisition unit 14 acquires the location ID, and the location ID acquisition unit 15 acquires the location ID (step S44). .

  The fourth association processing unit 24 refers to the second association table 21 by using the pallet package ID acquired by the package ID acquisition unit 13, thereby associating with the package ID of the pallet. Get a virtual ID. Then, the virtual ID associated with the packing form ID of the pallet, the location ID acquired by the location ID acquisition unit 14, and the location ID acquired by the location ID acquisition unit 15 are associated with each other, as shown in FIG. 4 is stored in the pegging table 25 (step S45).

  When the product is taken out from the pallet and placed in the flat placement area as shown in FIG. 18B, the second tying processing unit 20 is obtained by the packing form ID obtaining unit 13 in the second tying table 21. The pallet packing form ID and the virtual ID already linked to the packing form ID are released (step S46). Whether the product is taken out from the pallet and placed in the flat placement area is specified by, for example, the user inputting information to the handy terminal 200 or the PC 300 and transmitting it to the server 100.

  By the way, when the package is divided and placed at two locations in the base, product information (such as the number of products included in each divided package) is further input in step S41. The product information is also transmitted to the server 100 (step S42) and received by the communication unit 11 (step S43). This product information is acquired by the product information acquisition unit 12 (step S44) and supplied to the product information update unit 28. In response to this, the product information update unit 28 updates the contents of the first association table 19.

  Further, when the package is divided and placed at two locations in the base, the location ID acquisition unit 14 acquires two location IDs. In this case, the virtual ID issuing unit 17 issues a new virtual ID for one location ID. The fourth association processing unit 24 is acquired by the new virtual ID issued by the virtual ID issuing unit 17, one location ID acquired by the location ID acquisition unit 14, and the location ID acquisition unit 15. The location ID is linked and stored in the fourth linking table 25 shown in FIG. The processing for the other location ID is as shown in steps S45 and S46 in the flowchart of FIG.

  FIG. 19 is a flowchart showing an operation example when a package is taken out from a location (a flat area or a shelf) in a certain base. FIG. 20 is a diagram showing a moving image of the product when the package is taken out from the location in the base. FIG. 20 shows a state in which the product is removed from the flat placement area together with the pallet (FIG. 20A), and a state in which the product is taken out from the flat placement area and loaded onto the pallet (FIG. 20B).

  In FIG. 19, the handy terminal 200 or the PC 300 inputs the pallet packing form ID, the location ID of the site, and the location ID representing the placement position in the site (step S51). Here, in the case of FIG. 20A, the packing form ID of the pallet taken out from the flat placement area is input. In the case of FIG. 20B, the package ID of a newly prepared pallet is input. The handy terminal 200 or the PC 300 transmits the input information to the server 100 together with the event information (step S52).

  In the server 100, the communication unit 11 receives information transmitted from the handy terminal 200 or the PC 300 (step S53). Then, the package ID acquisition unit 13 acquires the package ID received by the communication unit 11, the location ID acquisition unit 14 acquires the location ID, and the location ID acquisition unit 15 acquires the location ID (step S54). .

  The virtual ID issuing unit 17 refers to the second associating table 21 and determines whether or not the pallet packing form ID acquired by the packing form ID acquiring unit 13 is already registered in the second linking table 21. (Step S55). Here, when the pallet packing ID is already registered, the packing ID is the pallet packing ID taken out from the flat placement area.

  In this case, the fourth linking processing unit 24 uses the fourth linking table 25 to store the virtual ID linked to the package ID of the pallet and the location of the flat placement area linked to the virtual ID. The association with the ID is released (step S56). Thereby, the process of the flowchart shown in FIG. 19 is completed.

  On the other hand, if it is determined in step S55 that the packing form ID of the pallet acquired by the packing form ID acquisition unit 13 is not yet registered in the second pegging table 21, the packing form ID is obtained from the flat placement area. This means a package ID of a new pallet prepared for loading the taken out product.

  In this case, the virtual ID issuing unit 17 issues a new virtual ID for the package appearance ID of the new pallet (step S57). Then, the issued virtual ID is supplied to the second association processing unit 20. The second linking processing unit 20 is issued by the new pallet packing form ID acquired by the packing form ID acquiring unit 13, the place ID acquired by the place ID acquiring unit 15, and the virtual ID issuing unit 17. The new virtual ID is linked and stored in the second linking table 21 (step S58). Thereby, the process of the flowchart shown in FIG. 19 is completed.

  When the package is taken out from the location in the base, if it is divided and loaded on two pallets, product information (such as the number of products included in each divided package) is further input in step S51. The product information is also transmitted to the server 100 (step S52) and received by the communication unit 11 (step S53). This product information is acquired by the product information acquisition unit 12 (step S54) and supplied to the product information update unit 28. In response to this, the product information update unit 28 updates the contents of the first association table 19.

  In addition, when the package form is divided and loaded on two pallets, the package form ID acquisition unit 13 acquires two package form IDs. For example, as shown in FIG. 20 (a), in the case where a product is removed from the flat placement area as a whole pallet, the case where one pallet is taken out from the flat placement area as it is and the other pallet is newly prepared is considered. In this case, the virtual ID issuing unit 17 issues a new virtual ID for the package ID of the other pallet.

  Then, the second association processing unit 20 is acquired by the new virtual ID issued by the virtual ID issuing unit 17, the other package ID acquired by the package ID acquisition unit 13, and the location ID acquisition unit 15. The location ID that has been assigned is associated and stored in the second association processing unit 20. In addition, the third association processing unit 22 has a parent-child relationship between the new virtual ID issued by the virtual ID issuing unit 17 and the virtual ID associated with the package ID corresponding to the package before the division. It is linked and stored in the third linking table 23. The process for one package ID is as shown in step S56 in the flowchart of FIG.

  Alternatively, consider a case where two pallets are newly prepared when a product is taken out from a flat placement area and loaded onto a pallet as shown in FIG. In this case, the virtual ID issuing unit 17 issues new virtual IDs for the package IDs of both pallets.

  Then, the second linking processing unit 20 includes one package ID acquired by the package ID acquisition unit 13, one virtual ID newly issued by the virtual ID issuing unit 17, and a place ID. The location ID acquired by the acquisition unit 15 is linked and added to the second linking processing unit 20 for storage. In addition, the second association processing unit 20 includes the other package ID acquired by the package ID acquisition unit 13, the other virtual ID newly issued by the virtual ID issuing unit 17, and the location ID. The location ID acquired by the acquisition unit 15 is linked and added to the second linking processing unit 20 for storage. Further, the third linking processing unit 22 is a parent-child of each new virtual ID issued by the virtual ID issuing unit 17 and the virtual ID linked to the package ID corresponding to the package before the division. The relationships are associated with each other and stored in the third association table 23.

  In addition, when a plurality of locations in the base take out the packing form and integrate and load it on one pallet, the packing form ID acquisition unit 13 acquires the integrated packing form ID. In this case, the processes in steps S57 and S58 are performed on the package form ID corresponding to the package form after integration.

  FIG. 21 is a diagram showing a specific example relating to the operation of the product tracking system according to the present embodiment. FIG. 21 shows an operation example in the case where the product is distributed from the factory to the store through the warehouse without being divided or integrated. In FIG. 21, the event information is not shown.

  In the factory with the location ID “B001”, initial product registration is first performed. At this time, the virtual ID “V001” is first issued to the pallet packing form ID “C001”. The product information of the product and the virtual ID “V001” are associated with each other and stored in the first association table 19. Also, the pallet packing form ID “C001”, the virtual ID “V001”, and the factory location ID “B001” are linked and stored in the second linking table 21.

  Next, the product is delivered from the factory. Here, an example is shown in which the product is loaded into the container together with the pallet. At this time, a new virtual ID “V002” is issued for the container packing ID “C002”, the container packing ID “C002”, the new virtual ID “V002”, and the factory location ID “B001”. Are associated with each other and stored in the second association table 21. The virtual ID “V002” associated with the container packing ID “C002” is the parent, and the virtual ID “V001” linked to the pallet packing ID “C001” is the child. It is linked and stored in the third linking table 23.

  When the container moves from the factory to the warehouse, the warehouse with the place ID “B002” is first loaded. Here, an example is shown in which the product is taken out from the container together with the pallet. At this time, since the packing form ID “C001” of the extracted pallet has already been registered in the second linking table 21, the virtual ID linked to the pallet packing form ID “C001” in the third linking table 23. The parent-child relationship between “V001” and the virtual ID “V002” associated with the container packaging ID “C002” is released.

  Also, the package ID “C001” of the pallet taken out from the container, the virtual ID “V001” already associated with the package ID “C001” of the pallet, and the warehouse location ID “B002” are associated with each other. Are additionally stored in the second pegging table 21.

  Furthermore, in the example of FIG. 21, pallet transshipment of the received product is performed. At this time, since the packing form is not divided or integrated, the second packing table is linked to the new packing form ID “C003” relating to the pallet after reloading and the packing figure ID “C001” of the pallet before reloading. The virtual ID “V001” already stored in 21 and the warehouse location ID “B002” are associated with each other and stored in the second association table 21. Further, the association between the packing form ID “C001” and the virtual ID “V001” of the pallet before reloading is released.

  Next, the product is delivered from the warehouse. Here too, an example is shown in which the product is loaded into the container together with the pallet. At this time, a new virtual ID “V003” is issued for the container packing ID “C004”, the container packing ID “C004”, the new virtual ID “V003”, and the factory location ID “B002”. Are associated with each other and stored in the second association table 21. Further, the virtual ID “V003” associated with the container packaging ID “C004” is the parent and the virtual ID “V001” associated with the pallet packaging ID “C003” is the child. It is linked and stored in the third linking table 23.

  When the container moves from the warehouse to the store, at the store with the location ID “B003”, storage is first performed. Also here, an example is shown in which the product is taken out of the container together with the pallet. At this time, since the packing form ID “C003” of the extracted pallet is already registered in the second linking table 21, the virtual ID linked to the pallet packing form ID “C003” in the third linking table 23. The parent-child relationship between “V001” and the virtual ID “V003” associated with the container packaging ID “C004” is released.

  Further, the package ID “C003” of the pallet taken out from the container, the virtual ID “V001” already associated with the package ID “C003” of the pallet, and the store location ID “B003” are associated with each other. Are additionally stored in the second pegging table 21.

  Thereafter, in the example of FIG. 21, the received product is placed in the flat placement area. Here, the example which takes out a product from a pallet and mounts it in a flat placement area is shown. At this time, the virtual ID “V001” associated with the pallet appearance ID “C003”, the store location ID “B003”, and the location ID “LC01” representing the flat placement area in the store are associated with each other. Stored in the fourth pegging table 25. In the second linking table 21, the pallet packing state ID “C003” and the virtual ID “V001” already linked to the packing state ID “C003” are released.

  As described above, when the product is distributed in a state where the package is not divided or integrated, new virtual IDs (“V002”, “V003”) are temporarily stored when the product is loaded into the container at the time of loading / unloading. In other cases, product information, package ID, location ID, and location ID are linked by the virtual ID “V001” issued first. Therefore, by tracing the virtual ID “V001”, it is possible to trace the distribution route of the product specified by the packing form ID, the place ID, and the location ID associated with the virtual ID “V001”.

  FIG. 22 is a diagram showing another specific example relating to the operation of the product tracking system according to the present embodiment. FIG. 22 shows an example of operation in the case where the form of distribution in the factory and warehouse is the same as that in FIG. 21, but the packing form is divided at the last store. In FIG. 22, only the last store portion is illustrated. Also, the illustration of the event information is omitted in FIG.

  In FIG. 22, there are 10 products loaded on a pallet from a container at the time of warehousing, 5 of which are placed in a flat placement area, and the remaining 5 are still loaded on the same pallet. Show. In this case, as part of the product information, the number information indicating that the number of products placed in the flat placement area is five and the number of products remaining on the pallet is five is transmitted from the handy terminal 200 or the PC 300 to the server 100. . By acquiring the product number information, the server 100 can determine that the package is divided.

  When the packaging is divided, for the flat area, a new virtual ID “V004” is issued for the location ID “LC01”, the location ID “LC01”, the new virtual ID “V004”, and the store The location ID “B003” is associated and stored in the fourth association table 25. Further, a virtual ID “V001” linked to the package ID “C003” before the package shape division and a new virtual ID “V004” linked to the location ID “LC01” after the package shape division. A parent-child relationship is associated with each other and stored in the third association table 23.

  In the first association table 19, a record of product information associated with the virtual ID “V001” associated with the pallet packing form ID “C003” is specified and included in the record. The value of “current quantity” is updated to “5”. Further, a new record is created by copying the record of the product information, and the value of “current quantity” of the new record is updated to “5”. This new record is for the flat area, and the value of the virtual ID is “V004”.

  As shown in the example of FIG. 22, even when the packing form is divided, by tracking the virtual ID “V001”, the packing form ID, location ID, and location associated with the virtual ID “V001” are traced. The distribution route of the product specified by the ID can be traced. Further, by tracing the parent-child relationship between the virtual IDs ("V001" and "V004") stored in the third linking table 23, the package ID, location ID, and location ID linked to the virtual ID are used. The distribution channel of the identified product can be traced.

  When the packing form is divided, if it is a search from the downstream, the distribution route can be uniquely traced from “V001” to “V001” and from “V004” to “V001”. On the other hand, when searching from upstream, it is not possible to uniquely identify in which direction from “V001” to “V001” or “V004” the distribution route should be traced. Therefore, it is preferable to provide another device for uniquely identifying a distribution route even in a search from upstream.

  For example, in the example of FIG. 22, in a state before the package shape is divided, a parameter different from the package shape ID “C003” of the pallet before division is set for each package shape to be divided. And stored in the second pegging table 21. Then, even when the package changes with the subsequent movement of the product, the parameters are taken over and stored in the second pegging table 21. In this way, if one of the parameters is specified and the search is performed, the distribution route can be uniquely specified even when searching from upstream.

  FIG. 23 is a diagram showing still another specific example regarding the operation of the product tracking system according to the present embodiment. FIG. 23 shows an operation example in the case where two packages are integrated into one package in a warehouse. In FIG. 23, the event information is not shown. Here, it is assumed that one packing form before integration is a product loaded on a pallet, the packing form ID is “C010”, and the virtual ID is “V010”. The other package is a product placed in a flat area, and its location ID is “LC01” and the virtual ID is “V020”.

  When the above two packing forms are integrated on one pallet, a new virtual ID “V030” is issued to the packing form ID “C011” of the combined pallet, and the packing form ID “C011” is newly added. The virtual ID “V030” and the warehouse location ID “B002” are associated with each other and stored in the second association table 21. In addition, a virtual ID “V010” associated with the package ID “C010” before integration of the package, and a new virtual ID “V030” associated with the package ID “C011” after integration of the package. And the virtual ID “V020” linked to the location ID “LC01” before the package integration and the package ID after the package integration. The parent-child relationship is associated with the new virtual ID “V030” associated with the package ID “C011” and stored in the third association table 23.

  As in the example shown in FIG. 23, even when the packing forms are integrated, the virtual IDs stored in the third linking table 23 (“V010” and “V030”, or “V020” and “V030” are stored). ]), The distribution route of the product specified by the packing form ID, the place ID, and the location ID associated with the virtual ID can be traced.

  In the case where the packing forms are integrated, if the search is performed from upstream, the distribution route can be uniquely traced from “V010” to “V030” and from “V020” to “V030”. On the other hand, when searching from downstream, it is not possible to uniquely identify in which direction from “V030” to “V010” or “V020” the distribution route should be traced. Therefore, it is preferable to provide a device for uniquely identifying a distribution route even in a search from downstream.

  For example, in the example of FIG. 23, in a state where two packing forms are integrated on one pallet, the packing form ID “C011” of the combined pallet is different for the two packing forms to be integrated. Parameters are set and stored in the second linking table 21. Then, even when the package changes with the subsequent movement of the product, the parameters are taken over and stored in the second pegging table 21. In this way, if one of the parameters is specified and the search is performed, the distribution route can be uniquely specified even when searching from downstream.

  As an example of a parameter set separately from the package ID, a parameter set according to a rule such as first-in first-out or first-in last-out of a product can be considered. This means that when multiple packages are integrated into a single package, for example, a package that was first moved must always be moved first (first-in-first-out) when it is split later. Decide how to operate. Then, when the packing forms are integrated, different parameters are set for each packing form loaded on one pallet according to the order in which the packing forms are moved.

  As described above in detail, in this embodiment, the product information of the product to be distributed is acquired by the product information acquisition unit 12, the packing form ID assigned to the packing form of the product is acquired by the packing form ID acquisition unit 13, A virtual ID is issued by the virtual ID issuing unit 17 for the package ID. Then, the product information and the virtual ID are associated with each other by the first association processing unit 18 and stored in the first association table 19, and the package ID and the virtual ID are associated with each other by the second association processing unit 20. Store in the second pegging table 21. Furthermore, when a new virtual ID is issued due to a change in the package ID accompanying the movement of the product, the third linking table 22 links the parent-child relationship between the virtual IDs before and after the product movement by the third linking processing unit 22. 23 is stored in the memory.

  According to this embodiment configured as described above, the package ID given in the product distribution process and the virtual ID issued to the package ID are linked, and the parent-child relationship string between the virtual IDs before and after the product is moved. The distribution route of the product specified by the package ID linked to the virtual ID can be traced by tracing the parent-child relationship of the virtual ID using the attachment.

  In the present embodiment, the location ID representing the placement position of the product in the base is obtained by the location ID obtaining unit 14, and the virtual ID is issued by the virtual ID issuing unit 17 for the location ID. The fourth association processing unit 24 associates the location ID with the virtual ID and stores them in the fourth association table 25.

  According to the present embodiment configured as described above, the association between the location ID given in the product distribution process and the virtual ID issued to the location ID, and the association between the parent and child relationship between the virtual IDs before and after the product movement. By tracing the parent-child relationship of the virtual ID, the distribution route of the product specified by the location ID linked to the virtual ID can be traced.

  As a result, if the association between the product information of the product and the virtual ID issued for the package ID acquired first is stored in the first association table, in the subsequent distribution process of the product, Each time the product moves due to warehousing, etc., the troublesome work of manually entering product information can be eliminated. Therefore, it is possible to easily perform the work for constructing information necessary for tracking the product distribution route, and to reduce the work burden on the user.

  The above-described embodiments are merely examples of implementation in carrying out the present invention, and the technical scope of the present invention should not be interpreted in a limited manner. That is, the present invention can be implemented in various forms without departing from the gist or the main features thereof.

11 Communication Department 12 Product Information Acquisition Department (Product Number Acquisition Department)
DESCRIPTION OF SYMBOLS 13 Packing form ID acquisition part 14 Location ID acquisition part 15 Location ID acquisition part 16 Event information acquisition part 17 Virtual ID issuing part 18 1st correlation processing part 19 1st correlation table 20 2nd correlation process part 21 2nd Association table 22 Third association processing unit 23 Third association table 24 Fourth association processing unit 25 Fourth association table 26 Event history recording unit 27 Event history table 28 Product information update unit 29 Search key acquisition unit 30 Search processing Department 100 Server 200 Handy terminal 300 PC

Claims (11)

A product information acquisition unit for acquiring product information, which is information related to the product to be distributed;
A package ID acquisition unit for acquiring the package ID assigned to the package of the product;
A virtual ID issuing unit that issues a virtual ID to the package ID acquired by the package ID acquisition unit;
A first association processing unit that associates the product information with the virtual ID and stores the associated product information in the first association table;
A second linking processing unit for linking the packing form ID and the virtual ID and storing them in a second linking table;
When a new virtual ID is issued by the virtual ID issuing unit due to the change of the packing ID accompanying the movement of the product, the parent-child relationship between the virtual IDs before and after the product movement is linked to the third linking table. A product tracking system comprising a third pegging processing unit for storing. A location ID acquisition unit for acquiring a location ID assigned to the location in the base where the product is placed;
The fourth ID is stored in the fourth association table by associating the location ID acquired by the location ID acquisition unit and the virtual ID corresponding to the package ID of the product on which the location in the base is placed. The product tracking system according to claim 1, further comprising a linking processing unit. When the package is divided along with the movement of the product, a product number acquisition unit for acquiring the number of products included in each package after the division;
2. A product information update unit that updates the product information stored in the first association table based on the number of products acquired by the product number acquisition unit. Product tracking system as described in. When the package is divided along with the movement of the product, a product number acquisition unit for acquiring the number of products included in each package after the division;
3. A product information update unit for updating the product information stored in the first association table based on the number of products acquired by the product number acquisition unit. Product tracking system as described in. When a new package ID is acquired by the package ID acquisition unit along with the movement of the product, if the number of products is acquired by the product number acquisition unit, the virtual ID issuing unit A virtual ID is issued, the second linking processing unit links the new package ID and the new virtual ID and stores them in the second linking table, and the third linking processing unit A parent-child relationship is linked between the virtual ID linked to the package ID before the product movement and the new virtual ID linked to the new package ID after the product movement. The product tracking system according to claim 3, wherein the product tracking system is stored in a peg table. When a new package ID is acquired by the package ID acquisition unit with the movement of the product, if the number of products is not acquired by the product number acquisition unit, the virtual ID issuing unit Without issuing a virtual ID, the second association processing unit associates the new packaging form ID and the virtual ID associated with the packaging form ID before the product movement, and associates the second packaging table with the second packaging table. The product tracking system according to claim 3, wherein the product tracking system is stored in the product tracking system. When the location ID is acquired by the location ID acquisition unit as the product is moved, if the number of products is acquired by the product number acquisition unit, the virtual ID issue unit issues a new virtual ID. The second association processing unit associates the location ID and the new virtual ID and stores them in the fourth association table, and the third association processing unit stores the package ID before product movement. A parent-child relationship is linked between the virtual ID linked to the location ID and the new virtual ID linked to the location ID after the product is moved and stored in the third linkage table. The product tracking system according to claim 4. When the location ID is acquired by the location ID acquisition unit along with the movement of the product, if the number of the products is not acquired by the product number acquisition unit, the virtual ID issuing unit issues a new virtual ID And the second linking processing unit links the location ID and the virtual ID linked to the package ID before moving the product and stores them in the fourth linking table. The product tracking system according to claim 4 or 7. When a plurality of packages are integrated into one package as the product moves, the package ID acquisition unit acquires a new package ID assigned to the package after integration,
The virtual ID issuing unit issues a new virtual ID, and the second association processing unit associates the new package ID and the new virtual ID and stores them in the second association table, The third linking processing unit is configured between each virtual ID linked to a plurality of package IDs before integration and the new virtual ID linked to the new package ID after integration. The product tracking system according to claim 1, wherein a parent-child relationship is associated with each and stored in the third association table. Product information acquisition means for acquiring product information, which is information relating to products to be distributed;
Package ID acquisition means for acquiring the package ID assigned to the package of the product,
Virtual ID issuing means for issuing a virtual ID to the package ID acquired by the package ID acquisition means;
A first association processing means for associating the product information and the virtual ID and storing them in a first association table;
A second linking processing means for linking the package ID and the virtual ID and storing them in a second linking table; and a new ID by the virtual ID issuing means due to a change in the package ID associated with the movement of the product. Computer-readable, characterized by causing a computer to function as a third association processing means for associating a parent-child relationship between virtual IDs before and after product movement and storing them in a third association table when a virtual ID is issued Product tracking program. Location ID acquisition means for acquiring a location ID assigned to the location in the base where the product is placed, and the location ID acquired by the location ID acquisition means, and the product on which the location in the base is placed 11. The product tracking program according to claim 10, further comprising a computer functioning as fourth linking processing means for linking the virtual ID corresponding to the package ID to be stored in the fourth linking table.

Images