WO2017212557A1

WO2017212557A1 - Distribution inventory information provision system, method, and program

Info

Publication number: WO2017212557A1
Application number: PCT/JP2016/066976
Authority: WO
Inventors: 鍵和田　芳光
Original assignee: 鍵和田　芳光; 株式会社キーソフト
Priority date: 2016-06-07
Filing date: 2016-06-07
Publication date: 2017-12-14
Also published as: JPWO2017212557A1; JP6853984B2

Abstract

[Problem] A problem to be solved by the present invention is to implement a system which generates and provides distribution inventory information on the basis of information which is acquired from a traceability system. [Solution] Provided is a distribution inventory information provision system, comprising a search unit 2 which extracts, from among association information for chain traceability which is updated in realtime in a storage unit by a traceability system 20, a plurality of instances of association information for chain traceability which include a designated vendor ID and product ID. The distribution inventory information provision system further comprises a processing unit 3 which generates, for provision to an information request terminal 30, product-specific/vendor-specific inventory quantity information in which the number of instances of the plurality of instances of the association information for chain traceability which have been extracted by the search unit 2 is aggregated for each of the furthest downstream vendors.

Description

Distribution stock information providing system, method and program

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.

This invention makes it a subject to implement | achieve the system which produces | generates and provides distribution inventory information based on the 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 the storage unit in real time 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, only the association information for chain traceability relating to the specific product purchased or sold by the specific business operator is extracted by the search unit. 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.

In addition, the information acquisition device may also serve as an information requesting device, and the reception 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. Therefore, 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.

According to the present invention, it is possible to realize a system that generates and provides distribution inventory information based on information acquired from a traceability system.

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. FIG. 9 is a block diagram showing a modification of the embodiment shown in FIG. FIG. 10 is a block diagram showing another embodiment of the inventory information providing system. FIG. 11 is a data structure diagram of product delivery information stored in the product delivery information DB of FIG. FIG. 12 is a flowchart of processing executed by the inventory information generation unit of FIG.

[First Embodiment]
Embodiments of the present invention will be described below. 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.

Figure 1 shows the overall system configuration. 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 is transferred between the two through 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 this 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 accepting unit 1 transmits the product-by-business-by-business-unit stock quantity information and the product-by-product 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-by-product inventory number information and the product-by-product distribution stock total number information received from the distribution inventory 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 designated 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 this 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 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 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 information requesting terminal 30 outputs the product-by-business-by-product-by-product-based inventory quantity information and the product-by-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 designated product ID and the product-specific distribution stock total amount information. Further, 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 product-specific inventory quantity information by product and the distribution inventory total 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 requesting terminal 30 and a stock list request for the product is requested, 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.

Then, the search unit 2 lists the extracted information for each identification unit ID, and 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.

[Cooperation with transaction management system]
FIG. 9 shows a modification of the first embodiment and the second embodiment. The traceability system 20 communicates with the transaction management system 50 instead of communicating with the information registration terminal 40 described above. Other configurations are the same as those in FIG.
The distribution inventory information providing system 10, the traceability system 20, and the transaction management system 50 do not necessarily need to be independent network nodes. For example, each of the distribution inventory information providing system 10, the traceability system 20, and the transaction management system 50 may be a program unit. Communication between units can be performed by passing data between programs.

The transaction management system 50 has an order processing function, a shipping / delivery processing function, and a slip issuance processing function. Each function is realized by a computer executing a program.
The order processing function receives an ordering instruction for a product from the business operator or the consumer to the first business operator from an external terminal, and processes the ordering instruction. In addition, the order processing function determines whether or not the product needs to be ordered from the first business to the second business upstream, and if the product needs to be ordered from the second business, The order processing is executed.

The shipping / delivery processing function manages the status of product shipment by the business operator. In addition, the shipping / delivery processing function manages the delivery status of goods to the ordering business operator or consumer. When the product is delivered from the supplier to the ordering business operator or consumer, the shipping / delivery processing function is the business ID or consumer ID of the delivery destination, the product ID of the delivered product, The product identification unit ID and the delivery date and time are acquired from an external terminal, and these pieces of information are associated and stored in the storage unit. The transaction management system 50 reads out these pieces of information from the storage unit at a predetermined timing and delivers them to the update unit 22 of the traceability system 20.

The update unit 22 acquires the association between the product ID, the identification unit ID, the business ID or the consumer ID of the arrival destination, and the arrival date and time from the transaction management system 50, and the matching that the identification unit ID matches. The information is searched and the business ID or consumer ID received this time is added to the association information and updated.
The slip issue processing function issues a purchase order (order slip) from the orderer of the product to the purchaser, and an invoice (billing slip) and a delivery note (delivery slip) from the orderer of the product to the orderer. As described above, when there is an ordering instruction for a product from the ordering business operator or consumer to the first business operator, and the product is ordered from the first business enterprise to the second business operator upstream. The slip issuance processing function is not only a transaction slip between the business operator or consumer who first instructed the order and the first business operator, but also the order from the first business enterprise to the second business enterprise upstream. Automatically issue a transaction slip.

[Other inventory information provision system]
The invention described below relates to a system that provides information on inventory quantities that increase or decrease due to the distribution of merchandise.
For example, the manufacturer can grasp the quantity of goods delivered from the manufacturer to the wholesaler. However, the producer may not be able to ascertain the delivery destination and quantity of the goods that are subsequently delivered from the wholesaler to the retailer. It is an object of the present invention to make it possible to know the distribution of inventory after a direct delivery destination for delivered goods.

FIG. 10 shows an embodiment. In transactions of Company A, Company B, Company C, and Company D, transactions between Company A and Company B are managed by an AB company transaction management system 201. Similarly, transactions between Company B and Company C are managed by the transaction management system 202 between BC companies. Similarly, transactions between Company B and Company D are managed by a transaction management system 203 between BD companies. Each transaction management system 201-203 sends the product ID, production lot ID, delivery quantity, delivery route information, delivery route information, and delivery date and time information of products delivered based on the business-to-business transaction to the inventory information providing system 100. Send each one. Each transaction management system 201-203 operates by a computer executing a program. Communication between each transaction management system 201-203 and the inventory information providing system 100 is performed through the Internet or the like. Each transaction management system 201-203 is an independent system having different specifications, and the specification of data to be transmitted to the inventory information providing system 100 is also different for each system.

The inventory information providing system 100 includes a system adapter 101-103, a recording processing unit 104, a product delivery information DB 105, an inventory information generating unit 106, and an inventory information providing I / F 107. The system adapter 101-103, the recording processing unit 104, the inventory information generating unit 106, and the inventory information providing I / F are realized by a computer executing a program. The merchandise delivery information DB 105 is a database provided in the storage device.

The system adapter 101-103 receives data transmitted from each transaction management system 201-203. Data is received via a communication device. The AB system adapter 101 understands the specifications of the data transmitted from the AB company transaction management system 201, and uses the data to indicate the product ID, production lot ID, delivery quantity, delivery route information, and delivery. Information indicating the date and time is extracted, and product delivery information associated with the information is delivered to the recording processing unit 104. Similarly, the BC system adapter 102 understands the specifications of the data transmitted from the BC intercompany transaction management system 202, and from this data, information indicating the product ID, production lot ID, delivery quantity, delivery route, And the information which shows delivery date is extracted, and the goods delivery information which linked | related these information is handed over to the recording process part 104. FIG. Similarly, the BD system adapter 103 understands the specifications of the data transmitted from the BD intercompany transaction management system 203, and from this data, information indicating the product ID, production lot ID, delivery quantity, delivery route, And the information which shows delivery date is extracted, and the goods delivery information which linked | related these information is handed over to the recording process part 104. FIG.

The record processing unit 104 stores the product delivery information acquired from each system adapter 101-103 in the product delivery information DB 105. FIG. 11 shows an example of product delivery information stored in the product delivery information DB 105. Here, as shown in the lower part of FIG. 10, a certain product is delivered from Company A to 100 Company B, then 50 products are delivered from Company B to Company C, and from Company B to Company D, 40 products. Suppose that it was delivered.

In this case, the commodity delivery information indicated by the symbol ab in FIG. 11 is transmitted from the AB company transaction management system 201 and stored in the commodity delivery information DB 105. The breakdown is that 100 products with product ID p001 are delivered from Company A to Company B, and the delivery date and time is 12:00 on June 1st.

Further, the product delivery information indicated by the symbol bc in FIG. 11 is transmitted from the BC company-to-company transaction management system 202 and accumulated in the product delivery information DB 105. The breakdown is that 50 products with product ID p001 are delivered from Company B to Company C, and the delivery date and time is 18:00 on June 1st.

Further, the product delivery information indicated by the symbol bd in FIG. 11 is transmitted from the BD intercompany transaction management system 203 and accumulated in the product delivery information DB 105. The breakdown is that 40 products with product ID p001 are delivered from Company B to Company D, and the delivery date and time is 9:00 on June 2. Similarly, other products p002 and the like are accumulated in the product delivery information DB 105 according to the delivery results.

As mentioned earlier, the inter-company transaction management system 201-203 does not share information with other companies' transaction management systems, and is operated in the form of a closed system. On the other hand, the inventory information providing system 100 is operated as an open system that collects and processes information from each closed system.

The inventory information generation unit 106 refers to the product delivery information stored in the product delivery information DB 105, and in order to show the distribution of inventory in a company downstream from the company, Calculate the stock quantity of each company.

This operation is shown in FIG. In the description, it is assumed that the product delivery information shown in FIG. 11 is assumed and the product p001 sent out by the company A is designated as a processing target. First, the inventory information generation unit 106 selects product delivery information (record) ab with the designated company A as a delivery source for the designated product p001, and delivers 100 delivered quantities of the record ab to the record. It is set as the stock quantity of company B, which is the destination (S1).

Subsequently, the inventory information generation unit 106 inspects the records from the previously selected record ab in time series of the delivery date and time, and for the specified product p001, the company B that is the delivery destination of the previously selected record ab delivers The original records bc and bd are selected (YES in S2 and S3).

Subsequently, the inventory information generation unit 106 subtracts the delivery quantity 50 of the selected record bc from the inventory quantity of the company B that is the delivery source of the record bc, and the inventory quantity of the company C that is the delivery destination of the record bc. Set to. Also, the delivery quantity of the selected record bd of 40 is subtracted from the inventory quantity of the company B that is the delivery source of the record bd, and is set to the inventory quantity of the company D that is the delivery destination of the record bd (S4). Thereafter, the inventory information generation unit 106 repeats the processing from S2. In the example of FIG. 11, since there is no record in which the company C or D, which is the delivery destination of the previously selected record, is the delivery source, the process is terminated (NO in S2 and S3). As a result, the stock quantity of 100 products p001 delivered by company A is calculated as 10 (100-50-40) for company B, 50 for company C, and 40 for company D.

The inventory information providing I / F 107 provides a user interface to the external inventory information requesting apparatus 300. Communication between the inventory information providing I / F 107 and the inventory information requesting device 300 is performed via a communication device and the Internet. The inventory information providing I / F 107 authenticates the user of the inventory information requesting apparatus 300 that uses the inventory information providing system 100. Here, company A is authenticated as a user. Thereafter, the stock information providing I / F 107 receives from the stock information requesting device 300 designation of a product whose stock is to be checked and an information requesting operation. Here, designation of p001 is received as the product ID. Upon receiving the information request operation from the inventory information requesting apparatus 300, the inventory information providing I / F 107 passes the authenticated identifier of the company A and the designated product ID to the inventory information generating unit 106, and instructs generation of inventory information. .

Upon receipt of the instruction, the inventory information generation unit 106 calculates the inventory quantity distributed to each company as described above, and passes it to the inventory information providing I / F 107. According to the example shown in FIG. 11, the inventory information generation unit 106 has the inventory of 100 products p001 shipped by Company A, 10 products from Company B, 50 products from Company C, and 40 products from Company D. Is sent to the inventory information providing I / F 107.

The inventory information providing I / F 107 shapes the inventory information acquired from the inventory information generating unit 106 and transmits it to the requesting inventory information requesting apparatus 300. The user of the inventory information requesting apparatus 300 can know the distribution of the inventory downstream of the products shipped by the company, which can be used for planning the procurement of products in the future.

According to the present embodiment, by collecting transaction information managed by a plurality of closed systems with different specifications in an inventory information providing system as an open system, not only in-house inventory that can be grasped by the closed system, but also further downstream You can know the distribution of inventory including distribution destinations.

Also, the inventory information providing I / F 107 may indicate the current inventory quantity possessed by the delivery source to the delivery destination. In this case, the inventory information providing I / F 107 receives from the inventory information requesting apparatus 300 the identifier of the company authenticated as the user of the inventory information requesting apparatus and the designation of the product ID. Here, it is assumed that p001 is received as the product ID and the identifier of company C is received as the user identifier. The inventory information generation unit 106 searches the product delivery information DB 105 for a product delivery information record bc in which the product ID is p001 and the delivery destination indicated in the delivery route is company C. The inventory information generation unit 106 determines the delivery source company indicated in the delivery route of the searched record bc, and reads the stock quantity of p001 set for the delivery source company from the storage device. Then, the inventory information generating unit 106 passes the read inventory quantity to the inventory information providing I / F 107. The inventory information providing I / F 107 transmits the inventory quantity passed from the inventory information generating unit 106 to the inventory information requesting apparatus 300 that is the information request source.

The stock quantity of p001 owned by company B can be calculated by the stock quantity calculation process shown in FIG. In this case, the record ab in which the company B is the delivery destination indicated in the delivery route for the product p001 may be set as the processing target in step S1.

In this way, the delivery company can know the inventory quantity of the goods held by the delivery company, so it can be used as a reference for purchasing timing. In addition, the inventory information providing system 100 can acquire the inventory quantity of the product owned by the manufacturer company from the transaction management system, and can indicate the inventory quantity to the downstream delivery destination through the inventory information requesting apparatus 300. . In this case as well, downstream companies can know how much inventory is available to manufacturers, and can be used as a reference for purchasing timing.

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 50 Transaction management system 100 Inventory information provision system 101,102,103 System adapter 104 Recording Processing unit 105 Product delivery information DB
106 Inventory Information Generation Unit 107 Inventory Information Provision I / F
201, 202, 203 Intercompany transaction management system 300 Inventory information request device

Claims

A search unit for extracting a plurality of pieces of association information for chain traceability including a specified company ID and product ID from association information for chain traceability updated in real time in the storage unit by the traceability system; ,
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,
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
First step of extracting a plurality of association information for chain traceability including a specified business ID and product ID from association information for chain traceability updated in real time in the storage unit by the traceability system When,
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,
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,
A first process for extracting a plurality of association information for chain traceability including a specified company ID and product ID from association information for chain traceability updated in real time in the storage unit by the traceability system When,
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,
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 associated 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.
A search unit for extracting a plurality of pieces of association information for chain traceability including a specified company ID and product ID from association information for chain traceability updated in real time in the storage unit by the traceability system; ,
In order to provide the information acquisition apparatus with inventory quantity information for each product and for each product, and for each product, the number of pieces of association information extracted by the search unit for chain traceability A processing unit to generate,
Distribution inventory information provision system with
In the distribution stock information providing system according to claim 12,
Instead of the process of counting the number of pieces of association information for the plurality of chain traceability for each selected business operator and each product, the product quantity corresponding to the association information for chain traceability is calculated for each business operator. Aggregating
Distribution stock information provision system.
A system for providing a stock quantity of goods to a requesting device,
A first system adapter adapted to a first system for managing a first business transaction and receiving first product delivery information from the system;
A second system adapter adapted to a second system for managing a second business-to-business transaction and receiving second product delivery information from the system;
A record processing unit for storing the first product delivery information and the second product delivery information in a product delivery information DB;
Based on the delivery route and delivery quantity of the product P included in the first delivery information stored in the product delivery information DB, the delivery quantity is set to the inventory quantity of the delivery destination B indicated in the delivery route. After that, based on the delivery route and delivery quantity of the product P included in the second product delivery information accumulated in the product delivery information DB, the delivery quantity is the inventory quantity of the delivery source B indicated in the delivery route. And an inventory information generation unit for calculating the inventory quantities of B and C by setting the delivery quantity to the inventory quantity of the delivery destination C shown in the delivery route,
An inventory information providing system comprising: an inventory information providing I / F that provides an inventory quantity calculated by the inventory information generating unit to the requesting device.