JP6613517B2 - Distribution stock information providing system, method and program - Google Patents

Description

  The present invention relates to a distribution inventory information providing system, and more particularly to a system for generating and providing distribution inventory information based on information acquired from a traceability system. “Distribution inventory” refers to inventory held by a merchant in the distribution process of goods, such as a wholesaler or a retailer.

The “traceability system” is a mechanism that allows the movement of a product to be grasped by keeping a record of the handling of the product. Prior art documents related to this mechanism include, for example, “Food Traceability Guidelines” (Patent Document 1) issued as part of a project of the Ministry of Agriculture, Forestry and Fisheries.
However, a system that generates and provides distribution inventory information based on information acquired from the traceability system has not been proposed.

“Food Traceability System Introduction Guide (Food Traceability Guidelines”, “Food Traceability System Introduction Guide” revision committee, March 2008, 2nd edition, 2nd edition

  An object of the present invention is to realize a system that generates and provides distribution inventory information based on information acquired from a traceability system.

  In order to solve this problem, in the distribution inventory information providing system of the present invention, the specified business ID and product ID are selected from the association information for chain traceability that is updated in real time in the storage unit by the traceability system. A search unit for extracting association information for a plurality of chain traceability is provided. Also, in order to provide the information acquisition device with inventory quantity information for each product by summing up the number of association information for multiple chain traceability extracted by this search unit for each downstream operator A processing unit is provided.

  According to this, the search unit extracts only association information for chain traceability related to a specific product purchased or sold by a specific company. Then, the processing unit determines the number of pieces of association information (that is, the product) for each of the most downstream businesses (that is, businesses that currently stock the product) indicated in the extracted association information. The number of identification units (individuals or lots)) is tabulated, and product-by-business-by-business-by-business-inventory inventory quantity information is generated. The product-by-business-by-business-unit stock quantity information is the stock quantity of the product identification unit (individual or lot), and represents the number of stocks currently held by each business.

  Instead of the process of counting the number of association information for the plurality of chain traceability for each downstream operator, the product quantity corresponding to the association information for the chain traceability is calculated for each downstream operator. You may count. In this case, the product-specific business-unit inventory quantity information is the inventory quantity of the product, and represents the inventory quantity currently held by each business operator. In this case, the inventory quantity may represent the number of products such as one or two, or may represent the amount of products such as 1 kg or 2 kg.

  The information acquisition device may also serve as an information requesting device, and the receiving unit may use a business operator ID of a business operator who is a user of the information requesting device as the designated business operator ID. In this case, since the search unit extracts only the association information including the operator ID of the user of the information requesting device, the association information to be processed is purchased or sold by the operator corresponding to the operator ID. Only the correspondence information of the identified unit. For this reason, the inventory information that can be known by the business operator who is the user of the information requesting device is only for the identification unit purchased or sold by the business operator, and is owned by the business operator upstream of the business operator. A filtering function is realized in which it is not possible to know about existing inventory or inventory that is not handled by the operator.

  ADVANTAGE OF THE INVENTION According to this invention, the system which produces | generates and provides distribution inventory information based on the information acquired from a traceability system is realizable.

FIG. 1 is a block diagram showing a system configuration of an embodiment of the present invention. FIG. 2 is a data structure diagram of association information for chain traceability shown in FIG. 1 (first embodiment). FIG. 3 is a data structure diagram of the product-by-business-unit stock quantity information generated based on the association information in FIG. 2 (first embodiment). FIG. 4 is a data structure diagram of merchandise distribution stock total amount information generated based on the association information of FIG. 2 (first embodiment). FIG. 5 is a data structure diagram of association information for chain traceability shown in FIG. 1 (second embodiment). FIG. 6 is a data structure diagram of product-by-business-unit stock quantity information generated based on the association information in FIG. 5 (second embodiment). FIG. 7 is a data structure diagram of the distribution stock total quantity information for each product generated based on the association information of FIG. 5 (second embodiment). FIG. 8 is a configuration diagram of the inventory list.

[First Embodiment]
Hereinafter, embodiments of the present invention will be described. In the following description, terms defined in “Food Traceability Guidelines” listed in Non-Patent Document 1 are used as appropriate. However, the present invention can be applied to products other than food.

  FIG. 1 shows the overall configuration of the system. The distribution inventory information providing system 10 is configured to exchange information with the traceability system 20 and the information requesting terminal 30.

  The traceability system 20 records association information for chain traceability in the storage unit. Correspondence information for chain traceability is information that makes it possible to grasp the movement of products through businesses at each stage of production, processing, processing, wholesale, retail, etc. It is configured by linking to a business operator (supplier) and a business operator (seller) downstream. The traceability system 20 serves as a center for acquiring real-time information regarding the movement of goods from each business operator, and always updates the association information for chain traceability to real-time information based on the information and manages it centrally.

  The distribution inventory information providing system includes a reception unit 1, a search unit 2, and a processing unit 3. The accepting unit 1 sends and receives information to and from the information requesting terminal 30 via the communication device. The search unit 2 accesses a database that stores association information for chain traceability. The processing unit 3 generates inventory information based on the association information acquired by the search unit 2 and passes it to the receiving unit 1. The operations of the units 1, 2, and 3 are realized by a processor executing a program. All information used by each unit 1, 2, 3 for processing is read from the storage area of the storage device. Further, all information processed by the units 1, 2, and 3 is stored in the storage area of the storage device.

  When the traceability system 20 and the distribution inventory information providing system 10 are processes executed on the same computer, information exchange between the two is performed via a storage area. When the traceability system 20 and the distribution inventory information providing system 10 are processes executed on different computers, transmission / reception of information between the two is performed via a communication device.

  The information requesting terminal 30 is a terminal that requests the distribution inventory information providing system 10 to provide inventory information. There are a plurality of information requesting terminals 30 communicating with the distribution inventory information providing system 10 corresponding to a plurality of users.

  In the present embodiment, the association information for chain traceability has the data structure shown in FIG. That is, for each identification unit ID, each business ID from the business ID of the most upstream business to the business ID of the most downstream business is linked directly or indirectly. The product ID is linked directly or indirectly to the identification unit ID. The identification unit is a unit when the traceability system identifies a product, and there are cases where a lot is a unit and an individual / individual product is a unit. The identification unit ID is an identification symbol for distinguishing one identification unit from other identification units. The product ID is an identification symbol for distinguishing product items, and corresponds to a JAN code or the like.

  Next, the operation of this embodiment will be described. The accepting unit 1 receives the business operator ID and the product ID from the information requesting terminal 30, and passes the received business operator ID and product ID to the search unit 2. This provider ID is a provider ID corresponding to the provider who is the user of the information requesting terminal 30. The product ID is a product ID specified by the user for the information requesting terminal 30.

  The search unit 2 extracts a plurality of pieces of association information including both the business ID and the product ID passed from the reception unit 1 from the association information for chain traceability stored in the storage unit, and performs processing Pass to part 3.

  The processing unit 3 aggregates the number of pieces of association information with the same business ID of the most downstream business operator for each business operator ID of the most downstream business, for the association information passed from the search unit 2. The product-specific business-unit inventory quantity information (FIG. 3) that associates the corresponding product ID, the business ID of the most downstream business operator, and the total number is generated and passed to the receiving unit 1. The product-by-business-inventory-by-business-unit inventory quantity information represents the inventory quantity of the product identification unit (product individual or lot) corresponding to the product ID, and represents the inventory quantity held by the business in the business ID.

  Further, the processing unit 3 totals the total number of association information passed from the search unit 2 and generates distribution stock total amount information (FIG. 4) for each product in which the corresponding product ID and the total number are associated with each other. Pass to 1. Alternatively, the processing unit 3 aggregates each company's product-specific inventory quantity information, and associates the corresponding product ID with the total number to generate product-specific distribution inventory total quantity information and passes it to the reception unit 1. Also good. The product-specific distribution stock total amount information represents the total amount of distribution stock in the product identification unit (product individual or lot) corresponding to the product ID.

  The receiving unit 1 transmits the product-specific business-specific stock quantity information and the product-specific distribution stock total amount information passed from the processing unit 3 to the request source information requesting terminal 30. When the information on the business name corresponding to the business ID can be acquired, the reception unit 1 may also transmit the business name corresponding to the business ID.

  The information requesting terminal 30 outputs the product-by-commercial-unit stock quantity information and the product-by-product circulation stock total information received from the distribution stock information providing system 10 to the output device. When information on the product name corresponding to the product ID can be acquired, the product name corresponding to the product ID may be output together.

  The user of the information requesting terminal 30 can know the product-specific stock quantity information for each product corresponding to the specified product ID and the product-specific distribution stock total amount information.

  In addition, since the search unit 2 extracts only the association information including the operator ID of the user of the information requesting terminal 30, the association information to be processed is purchased by the operator corresponding to the operator ID or It is only the correspondence information of the sold identification unit. For this reason, the inventory information that can be known by the business operator who is the user of the information requesting terminal 30 is only for the identification unit purchased or sold by the business operator, and is owned by the business operator upstream of the business operator. A filtering function is realized in which it is not possible to know the inventory that is in stock or the inventory that the business operator does not handle.

[Second Embodiment]
Next, a second embodiment of the present invention will be described. Since the system configuration of FIG. 1 described in the first embodiment is the same, the description thereof is omitted.

  In the present embodiment, the association information for chain traceability has a data structure shown in FIG. That is, for each identification unit ID, each business ID from the business ID of the most upstream business to the business ID of the most downstream business is linked directly or indirectly. The product ID and the product quantity are directly or indirectly linked to the identification unit ID. The merchandise quantity indicates the quantity of merchandise included in the lot as an identification unit. The quantity of the product may be a number such as one or two, or may be an amount such as 1 kg or 2 kg.

  Next, the operation of this embodiment will be described. The accepting unit 1 receives the business operator ID and the product ID from the information requesting terminal 30, and passes the received business operator ID and product ID to the search unit 2. This provider ID is a provider ID corresponding to the provider who is the user of the information requesting terminal 30. The product ID is a product ID specified by the user of the terminal 30 with respect to the information requesting terminal 30.

  The search unit 2 extracts a plurality of pieces of association information including both the business ID and the product ID passed from the reception unit 1 from the association information for chain traceability stored in the storage unit, and performs processing Pass to part 3.

  The processing unit 3 totals the number of products of the association information that has the same business ID of the most downstream business operator for each business operator ID of the most downstream business for the correspondence information passed from the search unit 2. Then, the product-specific business-unit inventory quantity information (FIG. 6) in which the corresponding product ID, the business ID of the most downstream business enterprise, and the aggregated quantity are associated is generated and passed to the receiving unit 1. The product-by-business-by-business-inventory-by-business-unit inventory quantity information represents the inventory quantity of the product corresponding to the product ID, and represents the inventory quantity held by the business in the business ID.

  Further, the processing unit 3 aggregates the product quantities of all the association information passed from the search unit 2, and obtains the distribution inventory total amount information (FIG. 7) by product that associates the corresponding product IDs with the aggregated quantities. Generate and pass to the accepting unit 1. Alternatively, the processing unit 3 aggregates the inventory quantity information by product of each business operator, associates the corresponding product ID and the aggregated quantity, generates the distribution inventory total quantity information by product, and passes it to the reception unit 1 Also good. The product-specific distribution stock total amount information represents the total amount of the distribution stock of the product corresponding to the product ID.

  The receiving unit 1 transmits the product-specific business-specific stock quantity information and the product-specific distribution stock total amount information passed from the processing unit 3 to the request source information requesting terminal 30. When the information on the business name corresponding to the business ID can be acquired, the reception unit 1 may also transmit the business name corresponding to the business ID.

  The information requesting terminal 30 outputs the product-specific business-by-business-unit stock quantity information and the product-by-product distribution stock total amount information received from the distribution stock information providing system 10 to the output device. When the information on the product name corresponding to the product ID can be acquired, the information requesting terminal 30 may also output the product name corresponding to the product ID.

  The user of the information requesting terminal 30 can know the product-specific stock quantity information for each product corresponding to the specified product ID and the product-specific distribution stock total amount information. In addition, according to the present embodiment, even when the identification unit of the association information for chain traceability is a lot, the quantity of the product is known as the inventory quantity information by product and the total inventory quantity information by product. Can do.

[Modifications of First Embodiment and Second Embodiment]
(1) Hereinafter, the generic term of “product-specific inventory quantity information by product” and “distributed inventory total quantity information by product” is referred to as “distribution inventory information”. Here, in 1st Embodiment and 2nd Embodiment, it was set as the structure which the provider who is the user of the information request | requirement terminal 30 can browse only the distribution inventory information of the goods which purchased or sold in-house. However, the present invention is not limited to this, and the user of the information requesting terminal 30 may be configured to be able to view the distribution inventory information of products that other companies have purchased or sold. The user may be a consumer. In this case, the reception unit 1 may be configured to receive the business ID and product ID of an arbitrary business from the information request terminal 30 and to pass the received business ID and product ID to the search unit 2.

  With this configuration, the user of this system can know distribution inventory information of an arbitrary business operator. For example, the information can be used as information for knowing the timing and place of purchase of a product, Stock information can be used as a reference for stock transactions.

(2) Also, in the first embodiment and the second embodiment, pull-type distribution that provides distribution inventory information in response to a request from the information request terminal 30 is performed. However, the present invention is not limited to this, and distribution inventory information may be push-distributed from the distribution inventory information providing system 10 to the information requesting terminal 30.

(3) In the first and second embodiments, the information requesting terminal 30 also serves as an information acquisition device that acquires distribution inventory information. However, the present invention is not limited to this, and an information acquisition device different from the information requesting device 30 may acquire the distribution inventory information. The “information acquisition device” may be a device that acquires distribution inventory information, regardless of whether it is a terminal or an external server. Further, an “information requesting device” may be provided instead of the “information requesting terminal”. The “information requesting device” only needs to be a device that requests distribution inventory information, regardless of whether it is a terminal or an external server.

According to each embodiment described above, it is possible to realize a system that provides distribution inventory information of merchandise based on association information for chain traceability managed by the traceability system. Knowing the product-by-product-by-product inventory number information and the product-by-product distribution inventory total number information enables the manufacturer as a manufacturer to measure the production timing and prevent wasteful production and disposal. Businesses in the distribution process can measure the timing of purchase, and can prevent wasteful purchase and disposal. Conversely, there is no loss of sales opportunities such as selling out. In addition, production costs and logistics costs can be reduced by planned production or purchase. It is also possible to link an automatic ordering system according to the status of the downstream distribution inventory, and management costs can be reduced. Furthermore, it can be used as big data by analyzing fluctuations in the number of distribution stocks at each business. If the association information for chain traceability is associated with the ID of the final consumer, it is possible to propose appropriate products by analyzing the consumer's preference and purchase timing. At the same time, since the person who bought the product can know who it is, it can be easily collected when recalling the product. In addition, since it is possible to know where the inventory of a specific product is now, it is possible to guide where the product can be purchased in response to an inquiry about the product.
In the above, the following can be considered as a method of taking the ID of the final consumer into the association information for chain traceability. For example, when paying at a cash register, the store side system acquires the identification unit ID of the product, acquires the final consumer ID, and traces transaction information including the association between the identification unit ID and the final consumer ID. By sending it to the system, it is possible to capture the association information. Here, it is conceivable that the product identification unit ID is acquired from an information holding unit such as a QR code (registered trademark). Further, it is conceivable that the final consumer ID is acquired from a personal information source such as a point card or a credit card. In addition, when purchased at an online shop, the final consumer ID may be obtained from a personal information source such as a user login ID managed by the online shop or a shopping mall to which the online shop belongs.

  The present invention is not limited to the above embodiments. For example, the search unit and the processing unit may be provided in a part of the traceability system. As the association information for chain traceability, information copied to a storage unit outside the traceability system may be used. Businesses may include contractors involved in the transfer of goods such as transportation and packaging.

[Provision of date and time information]
It is convenient for the wholesaler and the retailer because it is easy to ship the old product first if it can know the product with the oldest date of manufacture or the product with the old date of arrival in their inventory. In addition, manufacturers, wholesalers, etc. can know where old products are, and can exchange or discard them. As shown in FIG. 2 and FIG. 5, the association information for chain traceability is associated with date / time information T when the identification unit arrives for each business entity ID handling each identification unit. Yes. In the case of the most upstream business (manufacturer), T is the date of manufacture. In FIG. 1, when a product ID and a company ID are specified from the information request terminal 30 and a stock list request for the product is made, the distribution stock information providing system 10 executes the following processing.

  The accepting unit 1 accepts a request for an inventory list from the information requesting terminal, and passes the product ID and the business operator ID specified along with the request to the searching unit 2. The search unit 2 searches the association information for chain traceability for a record in which the product ID acquired from the reception unit 1 matches and the business ID matches the downstream business ID. The search unit 2 obtains the product ID, the identification unit ID, the production date / time associated with the most upstream business operator ID, and the arrival date / time associated with the most downstream business enterprise ID from each record hit as a result. Extract association with.

  And the search part 2 enumerates the extracted information for every identification unit ID, and produces | generates the inventory list shown in FIG. The processing unit 3 passes the inventory list generated by the search unit 2 to the receiving unit 1. The accepting unit 1 transmits the inventory list to the information requesting terminal 30 that has requested the inventory list. The information requesting terminal 30 displays the inventory list received from the receiving unit 1 on the display device. The business operator who operates the information requesting terminal 30 can easily know an identification unit that has been manufactured or received in the company's inventory or the inventory of other companies in the company's distribution by browsing the inventory list. Therefore, the business operator can ship their own inventory first from an identification unit whose manufacture or receipt is old. In addition, when the operator can know the stock of other companies, for example, the manufacturer knows which wholesale and retail stores have old products, so the old ones can be replaced and renewed. When the retail store B, which is different from the retail store A, ships, the old stock of A is used by B (for applications that do not stick to the expiration date, etc.), reducing waste and using the goods effectively Can do.

[Consumer management by traceability system]
In FIG. 1, the traceability system 20 includes a storage unit 21 that stores association information for chain traceability, and an update unit 22 that updates the association information. The operation of the update unit 22 is realized by the processing device of the traceability system 20 executing a program. The update unit 22 includes information indicating the shipment or arrival of a product from the information registration terminal 40 (the product ID, the identification unit ID, the shipping destination or the business ID or the consumer ID of the receiving destination, the shipping date or the arrival date and time, If the association unit ID) is received, the association information having the same identification unit ID is updated. That is, the update unit 22 adds the received business ID or consumer ID most downstream to the record of the matching information with the same identification unit ID, and also receives the received shipping to the business ID or the consumer ID. Link date and time or arrival date and time T. When the consumer ID is added most downstream in the association information, the distribution inventory information providing system 10 does not count as the inventory of the business, assuming that the identification unit is in the hands of the consumer.

  When the business operator consumes the inventory on its own, information indicating that the identification unit has moved from the business operator ID of the business operator to the consumer ID of the business operator is input from the information registration terminal 40 to the traceability system 20. That's fine. Thereby, the traceability system 20 adds the consumer ID of the business operator most downstream in the association information of the identification unit. Therefore, the distribution inventory information providing system 10 calculates a correct inventory quantity on the assumption that the inventory of the operator has decreased.

DESCRIPTION OF SYMBOLS 1 Reception part 2 Search part 3 Processing part 10 Distribution stock information provision system 20 Traceability system 21 Storage part 22 Update part 30 Information request terminal 40 Information registration terminal

Claims (11)

Each business unit ID and product ID from the business operator ID of the most upstream business operator to the business operator ID of the most downstream business operator is associated with each identification unit ID that is updated in real time in the storage unit by the traceability system. from the correspondence information for the plurality of chain traceability are, a search unit that extracts the correspondence information for the plurality of chain traceability containing the specified provider ID and product ID,
A process for generating, in order to provide the information acquisition device, inventory quantity information for each product by summing up the number of pieces of association information extracted by the search unit for each chain traceability for each downstream operator. And
Distribution inventory information provision system with In the distribution inventory information providing system according to claim 1,
The association information for chain traceability is further linked to the product quantity for each identification unit ID,
Instead of the process of counting the number of association information for the plurality of chain traceability for each downstream operator, the product quantity corresponding to the association information for the chain traceability is calculated for each downstream operator. Tally,
Distribution stock information provision system. The information acquisition device also serves as an information requesting device,
The distribution inventory information providing system according to claim 1, wherein the reception unit sets a business ID of a business who is a user of the information requesting device as the designated business ID. A method for providing distribution inventory information of products based on information managed by a traceability system,
Computer
Each business unit ID and product ID from the business operator ID of the most upstream business operator to the business operator ID of the most downstream business operator is associated with each identification unit ID that is updated in real time in the storage unit by the traceability system. A first step of extracting a plurality of association information for chain traceability including a specified business ID and product ID from the plurality of association information for chain traceability,
A second step of generating, in order to provide the information acquisition device, inventory quantity information for each product, which is obtained by counting the number of pieces of association information for a plurality of chain traceability extracted for each downstream operator; ,
A distribution inventory information providing method. In the distribution inventory information provision method according to claim 4,
The association information for chain traceability is further linked to the product quantity for each identification unit ID,
In the second step, instead of the process of counting the number of pieces of association information for a plurality of chain traceability for each downstream operator, the product quantity corresponding to the association information for the chain traceability is most downstream. For each company
Distribution inventory information provision method. The information acquisition device also serves as an information requesting device,
5. The distribution inventory information providing method according to claim 4, wherein in the first step, a business ID of a business who is a user of the information requesting device is set as the designated business ID. A program that provides distribution inventory information of products based on information managed by the traceability system,
Each business unit ID and product ID from the business operator ID of the most upstream business operator to the business operator ID of the most downstream business operator is associated with each identification unit ID that is updated in real time in the storage unit by the traceability system. from the correspondence information for the plurality of chain traceability are, a first process of extracting the correspondence information for the plurality of chain traceability containing the specified provider ID and product ID,
A second process for generating, in order to provide the information acquisition device, inventory quantity information for each product, which is obtained by counting the number of pieces of association information for a plurality of chain traceability extracted for each downstream operator; ,
Distribution inventory information provision program that causes computers to execute. In the distribution inventory information provision program according to claim 7,
The association information for chain traceability is further linked to the product quantity for each identification unit ID,
In the second process, instead of the process of counting the number of association information for a plurality of chain traceability for each downstream operator, the product quantity corresponding to the association information for the chain traceability is most downstream. For each company
Distribution inventory information provision program. The information acquisition device also serves as an information requesting device,
The distribution stock information providing program according to claim 7, wherein the first processing uses a business ID of a business who is a user of the information requesting device as the designated business ID. In the distribution inventory information providing system according to claim 1,
The traceability system has a function of associating an end consumer ID with the association information for the chain traceability,
The identification unit ID of the product purchased by the final consumer is acquired from an information holding unit such as a two-dimensional barcode, the final consumer ID is acquired from a personal information source such as a point card, and the acquired identification unit ID and A distribution inventory information providing system including a store side system that generates transaction information linked with an ID of a final consumer and outputs the transaction information for the traceability system. In the distribution inventory information provision method according to claim 4,
The traceability system has a function of associating an end consumer ID with the association information for the chain traceability,
The store side system acquires the identification unit ID of the product purchased by the final consumer from the information holding unit such as a two-dimensional barcode, and acquires the final consumer ID from a personal information source such as a point card. A distribution inventory information providing method of generating transaction information in which the identification unit ID and the ID of the final consumer are linked, and outputting the transaction information for the traceability system.

Images