JP2007276971A - Distribution route management method and distribution route management system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To specify a distribution route of a desired distribution target in an optional distribution base without inspecting all distribution targets in each of the distribution bases, and to minimize the work load in the respective distribution bases. <P>SOLUTION: For example, in a middle trader 3, a case #1 is an inspection target, and identification information U001 is read. Inspection information of a carrying lot including the case #1 is designated. A distribution route management server 61 receives a link number o2 in inspection information designated as the identification information U001 read by the middle trader 3, and reads out a carrying number i1 in case information in correspondence with the identification information U001. Back to arrival and shipping information tied by the link number o2 up to arrival information of a pickup point 1 in which the carrying number i1 is written, the distribution route of the case #1 is specified. <P>COPYRIGHT: (C)2008,JPO&INPIT

Description

The present invention is a distribution target that is collected at a first distribution base, which is the base of distribution, such as a collection point, and sent from the first distribution base to a downstream distribution base (wholesale, wholesaler, retail store, etc.) The present invention relates to a distribution route management method and a distribution route management system for managing distribution routes of goods.

  Traditionally, crops such as tomatoes are packed in cases on the producer side, and the boxed cases are collected as goods (distribution items) at the collection point (first distribution base) for wholesale, intermediate wholesale, Sent to downstream distribution bases such as retail stores. In the merchandise distribution process, retail stores, which are the final stage of distribution, are increasingly demanding to disclose merchandise distribution channels from the viewpoint of food safety and security.

  In retail stores, as a method of disclosing the distribution route of the product, a method of attaching a recording medium to the product and writing the arrival time and the shipping time on the recording medium of each product at each distribution base can be considered (for example, see Patent Document 1). ). If such a method is adopted, the retailer can read the information written on the recording medium affixed to the product, and know the distribution route of the product by tracing the arrival time and the shipping time at each distribution base. Can do. Also, not only at retail stores, but also at wholesalers, it is possible to know the distribution route up to that point. Further, by reading the information written on the recording medium and sending it to the management center, the distribution center of the entire product can be managed by the management center.

JP 2002-351949 A (Japanese Patent Application No. 2001-154629)

  However, according to the distribution route management method described above, every time a product is received at the distribution base and every time the product is shipped from the distribution base, the arrival time and the shipping time are set on the recording medium attached to the product. Must be written. That is, for every distribution base, all products that are received and shipped must be inspected, and writing work (inspection) of the arrival time and the shipping time must be repeated for this inspection object, resulting in an excessive work load. . For this reason, it is difficult to implement at present.

  The present invention has been made in order to solve such problems. The object of the present invention is to carry out the distribution of desired distribution objects at any distribution base without inspecting all distribution objects for each distribution base. An object of the present invention is to provide a distribution route management method and a distribution route management system capable of specifying a distribution route and minimizing the work load at each distribution base.

  In order to achieve such an object, the present invention provides a distribution route of distribution objects collected at a first distribution base that is a distribution base and sent from the first distribution base to a downstream distribution base. In the distribution route management method to be managed, case information indicating the relationship between the identification information given to the distribution object collected at the first distribution base and the carry-in number determined for each carry-in lot of the distribution object. The relationship between the first step that is created and stored in the database, and the delivery number determined for each delivery lot of the distribution object received at the distribution base for each distribution base and the distribution base from which the distribution object is shipped is shown. The second step of creating the arrival information and storing it in the database, the unloading number determined for each unloading lot of the distribution object shipped from the distribution base for each distribution base, and the distribution target The third step of creating shipping information indicating the relationship with the distribution base of the shipping destination and storing it in the database and the arrival information of the distribution base downstream from the first distribution base are received at the distribution base. A fourth step of reading out the carry-out number in the shipment information of the distribution base of the distribution source of the distribution object carrying lot and writing the read-out number in the receipt information as a link number linked to the shipment information, and the first step When creating shipping information for a distribution base downstream from the distribution base, the loading number in the loading information of the unloading lot of the distribution object shipped from the distribution base is read, and the read loading number is referred to as the loading information. The fifth step of writing in the shipping information as the link number to be linked, and whether the desired distribution object is the inspection object at any distribution base, is it the inspection object? The carry-in number in the case information corresponding to the read identification information is read and written to the arrival information of the carry-in lot including the inspection object up to the arrival information of the first distribution base where the carry-in number is written. And a sixth step of identifying the distribution route of the inspection object by tracing back the receipt / shipment information linked by the link number.

  According to this invention, for example, the first distribution base is a pickup location (base 1), the downstream distribution base is wholesale (base 2), intermediate wholesale (base 3), and retail store (base 4). Identification information (for example, U001 to U010) given to the cases (for example, cases # 1 to # 10) collected at the collection point is read. Case information indicating a relationship between the read case identification information and a carry-in number (for example, i1, i2, i3) determined for each carry-in lot of the case is created. In addition, for the cases collected at the collection place, arrival information indicating the correspondence between the case carry-in number and the distribution base of the case from which the case is shipped is created. In the arrival information of the pickup location, since the case of the crop is received from the producer, the distribution base of the shipping source is set to “-(none)”.

  Here, for example, a case where U001 to U006 is assigned as identification information is i1, a case where U007 and U008 are assigned is i2, and a case where U009 and U010 is assigned is i3. Suppose that the lot including case # 1 is shipped from the collection point (base 1) to the wholesaler (base 2). In this case, if the lot delivery number including case # 1 shipped from the collection site is, for example, o1, the relationship between the delivery number o1 and the distribution base (base 2) of the shipping destination as the shipment information of the lot collection site. Is created. Further, if the delivery number of the lot including case # 1 received in the wholesale is i4, for example, as the receipt information of the wholesale of the lot, the delivery indicating the relationship between the delivery number i4 and the distribution base (base 1) of the shipping source is received. Information is created. In this wholesale receipt information, the carry-out number in the shipment information of the distribution base of the shipment source of the lot including case # 1, that is, the carry-out number o1 in the shipment information of the lot collection place including case # 1 is used as the link number. Written.

  Next, the lot including case # 1 is shipped from wholesale (base 2) to intermediate wholesaler (base 3). In this case, assuming that the lot export number including case # 1 shipped from wholesale is o2, for example, the relationship between the export number o2 and the distribution base (base 3) of the shipping destination is shown as wholesale shipment information of the lot. Shipping information is created. In this wholesale shipment information, the carry-in number in the receipt information of the lot including the case # 1, that is, the carry-in number i4 in the wholesale receipt information of the lot including the case # 1 is written as the link number. Also, if the lot delivery number including case # 1 that arrives at the wholesaler is i5, for example, the relation between the carry-in number i5 and the distribution base (base 2) of the shipping source is obtained as the intermediate wholesale arrival information. The arrival information shown is created. In the intermediate wholesale arrival information, the carry-out number in the shipment information of the distribution base of the lot that contains case # 1, ie, the carry-out number o2 in the wholesale shipment information of the lot that contains case # 1, is used as the link number. Written.

  Next, it is assumed that the lot including case # 1 is shipped from the intermediate wholesaler (base 3) to the retail store (base 4). In this case, if the export number of the lot including case # 1 shipped from intermediate wholesale is o3, for example, the relationship between the export number o3 and the distribution base (base 4) of the shipping destination is used as intermediate shipment information of the lot. Is created. In this intermediate shipment information, the carry-in number in the incoming information of the lot including case # 1, that is, the carry-in number i5 in the incoming information on the intermediate of the lot including case # 1, is written as the link number. Also, assuming that the lot number including case # 1 that arrives at a retail store is i6, for example, as the arrival information of the retail store of that lot, the relationship between the carry-in number i6 and the distribution base (base 3) of the shipping source is The arrival information shown is created. In the arrival information of the retail store, the carry-out number in the shipment information of the distribution base of the shipment source of the lot including the case # 1, that is, the carry-out number o3 in the shipment information of the intermediate wholesale of the lot including the case # 1 is the link number. Written as

  Here, for example, suppose that it is desired to know the distribution route of case # 1 in wholesaler. In this case, in the case of intermediate wholesale, the case # 1 is set as the inspection object, and the identification information given to the case # 1 is read. Then, the carry-in number in the case information corresponding to the identification information read from the case # 1 is read, and the carry-in lot information including the inspection object is received up to the arrival information of the pickup place where the carry-in number is written. The distribution route of case # 1 is identified by going back to the receipt / shipment information linked by the link number written in (intermediate receipt information of case # 1). In addition, the arrival information of the lot including the inspection object may be displayed on the screen of a personal computer or a portable information terminal as inspection information and specified on the screen.

  For example, when the identification information of case # 1 is set to U001, the distribution route is specified as follows. When the identification information U001 is read from the case # 1, i1 is read from the case information as a carry-in number corresponding to the identification information U001. Here, if the arrival information of the incoming lot including case # 1 (incoming information of intermediate wholesale of case # 1) is specified on the terminal screen, the link number o2 written in the incoming information of intermediate shipping is designated. The delivery number o2 (link number i4) in the wholesale shipment information, the link number i4 in the wholesale shipment information, the carry-in number i4 (link number o1) in the wholesale arrival information, and the link number o1 in the wholesale arrival information And the unloading number o1 in the shipping information of the pick-up place, going back to the pick-up information of the pick-up place in which the carry-in number i1 is written, “collection place (loading number i1, unloading number o1) → wholesale (import number i4) , Unloading number o2) → middle wholesale (importing number i5) ”, the distribution route of case # 1 is specified. It should be noted that the distribution route of case # 1 can be specified in the same manner at other distribution bases such as retail stores as well as wholesalers.

  In the present invention, the information related to the distribution route of the specified inspection object may be written in the case information in association with the identification information given to the inspection object. For example, the route information indicated by the group number indicating the distribution route of the specified inspection object and the route number is created, and the case information as the information regarding the distribution route of the inspection object specifying the group number and route number of the route information Write to. In this way, by specifying the identification information at the management center or the like, it is possible to know the distribution route of the inspection object specified at the distribution base at any time. In addition, for example, if information related to the distribution route specified by intermediate wholesale is written in the case information, the retail store can specify the remaining distribution route from intermediate wholesale to the retail store, thereby shortening the processing time. Is possible.

  In the present invention, the specified distribution route may be displayed on a screen of a personal computer or a portable information terminal. Further, the present invention can be realized not as a distribution route management method but as a distribution route management system. In the present invention, the distribution object is not limited to the case of agricultural products, and any object may be used as long as it is distributed from upstream to downstream. In addition, the distribution base is not limited to the collection place, wholesale, intermediate wholesale, and retail store, and may have a hierarchical structure from upstream to downstream, and there may be many distribution bases in the same hierarchy. .

  According to the present invention, in any case information corresponding to the identification information read from the inspection object, the identification information given to the detection object is read with a desired distribution object as a detection object at an arbitrary distribution base. The receipt / shipment information associated with the link number written in the receipt information of the carry-in lot including the inspection object up to the arrival information of the first distribution base where the carry-in number is written is read out. Going back, the distribution route of the inspection object is specified, so that the distribution route of the desired distribution object can be specified at any distribution base without inspecting the distribution object for every distribution base. Thus, the workload at each distribution base can be minimized.

  Hereinafter, the present invention will be described in detail with reference to the drawings. FIG. 1 is a diagram showing an example of a distribution route management system used for carrying out the distribution route management method according to the present invention. In the figure, 1 is a collection point (base 1), 2 is a wholesaler (base 2), 3 is a wholesaler (base 3), 4 is a retail store I (base 4), 5 is a retail store II (base 5), 6 is a data center and 7 is a network (Internet).

  A collection terminal 1, wholesale 2, intermediate wholesale 3, retail stores 4 and 5 are provided with management terminals such as personal computers (personal computers) and PDAs (Personal Digital Assistants). The data center 6 is provided with a distribution route management server 61, and the distribution route management server 61 has a database 62.

  In this example, the personal computer 11 and PDA 12 are in the pickup location 1, the personal computer 21 and PDA 22 are in the wholesale 2, the personal computer 31 and PDA 32 are in the wholesaler 3, the PDA 41 and the mobile phone 42 are in the retail store 4, and the PDA 51 and the mobile phone 42 are in the retail store 5. A mobile phone 52 is provided. These management terminals are connected to the distribution route management server 61 via the network 7.

  In this distribution route management system, crops such as tomatoes are packed in cases on the producer side, and the packed cases are collected as distribution objects (commodities) in a collection place 1 that is a first distribution base. Hereinafter, taking the case of the crops collected in the collection place 1 as an example of sending to the downstream wholesaler 2, the intermediate wholesaler 3, and the retail stores 4 and 5, while combining the functions of each management terminal and the distribution route management server 62, A characteristic operation in the distribution route management system will be described.

[Pickup site (base 1): Arrival from producer (10 boxes)]
As shown in FIG. 2, crop cases 100 are collected from the producers at the collection place 1. For example, cases # 1 to # 6 are received from the producer A, cases # 7 and # 8 are received from the producer B, and cases # 9 and # 10 are received from the producer C.

  In this example, it is assumed that the items of the agricultural products boxed in cases # 1 to # 10 are the same. In addition, a barcode label L is affixed to the cases # 1 to # 10, and items (product codes) and subcommittees (for example, product unit and region unit subcommittee codes) are displayed on the label L as bar code information. The package form (cardboard or bundle), the quantity (code indicating the unit of the package form), the identification number, etc. are written as identification information. In this example, the identification numbers of cases # 1 to # 10 are “U001” to “U0010” and the item code is α.

  In the pickup site 1, the manager (hereinafter, the manager of the pickup site 1 is referred to as a collector) receives the case # 1 to # 10 and receives the case # 1 by the barcode reading function added to the PDA 12. The barcode information is read from the labels L 1 to # 10 and input to the personal computer 11.

  Then, on the screen of the personal computer 11, the carry-in number (carry-in NO) is defined as i1 for the carry-in lots (incoming lots from producer A) of cases # 1 to # 6, and the carry-in lots of cases # 7 and # 8 The carry-in number is defined as i2 for (incoming lot from producer B), and the carry-in number is defined as i3 for the carry-in lots (received lots from producer C) in cases # 9 and # 10.

  Thereby, the personal computer 11 creates case information indicating the relationship between the identification numbers of the cases # 1 to # 10, the items, and the carry-in number, and sends the case information to the distribution route management server 61 via the network 7. The distribution route management server 61 adds “group” and “route” items, which will be described later, to the case information from the pickup location 1 and stores them in the database 62.

  In this case information, the items “group” and “root” are all set to “− (none)” because the group number and the route number are not yet determined. The group number and route number will be described later.

  In addition, the personal computer 11 has a base (1,1,1), item (α, α, α), group (×, ×, ×), packing state (×, ×) for each carry-in number (i1, i2, i3). X, x), quantity (x, x, x), delivery number (i1, i2, i3), arrival date (in1, in2, in3), arrival information describing the number of arrivals (6, 2, 2) It is created and sent to the distribution route management server 61 via the network 7. In this arrival information, the arrival date (in1, in2, in3) is automatically entered as the creation date of the arrival information.

  The distribution route management server 61 adds items of “shipping distribution base (From)” and “link (link number)” to the arrival information from the collection place 1 and stores them in the database 62. It should be noted that the item of “shipping distribution base (From)” is set to “-(none)” in the arrival information of this pickup location. In addition, the item “linking (link number)” is also set to “− (none)”. The “distribution base (From) of shipment source” and “linkage (link number)” will be described later.

[Collection site (base 1): Shipment to wholesale (base 2) (5 boxes))
Assuming that cases # 1 to # 10 currently collected at the collection site 1 are shipped, 5 arbitrary cases are shipped to the wholesaler 2 (see FIG. 3). In this case, the collector collects the shipping lot data from the screen of the personal computer 11 in addition to the product information such as item, subcommittee, packing form, and quantity, as well as the distribution base (base 2) and the number of shipments (5 Box). The product information such as items, subcommittees, packing styles, and quantities is input by referring to the arrival information of the pickup location 1 and copying it.

  As a result, the personal computer 11 has the base (1), the item (α), the subcommittee (×), the packing form (×), the quantity (×), the distribution base (2) of the shipping destination, the shipping date (out1), the shipping Shipment information describing the number (5) is created and sent to the distribution route management server 61 via the network 7. In this shipping information, the shipping date (out1) is automatically entered as the date of creation of the shipping information.

  The distribution route management server 61 adds items “carrying out number (carrying out NO)” and “linkage (link number)” to the shipping information from the collection place 1, and changes the item “distribution base of shipping destination”. Stored in the database 62 as “To”. In the shipping information of the pickup location 1, the item “linkage (link number)” is set to “-(none)”. In addition, o1 is written as an export number in the item “export number”. This export number is automatically numbered.

[Wholesale (base 2): Arrival at the pickup location (base 1) (5 boxes)]
When the distribution information from the collection site 1 to the wholesale 2 (shipment information of the 5 carry-out lots of the collection site 1) is created, the distribution route management server 61 receives the delivery information of the 5 carry-in lots of the wholesale 2 from this shipment information. Is automatically created (see FIG. 4).

  In this case, the distribution route management server 61 sets “location (1)” in the shipping information as “distribution location (From) (1)” of the shipping source, and “distribution location of the shipping destination” in the shipping information. (To) (2) ”is“ base (2) ”in the arrival information, and data of each item of“ item ”,“ committee ”,“ packing form ”, and“ quantity ”is copied.

  Also, the “shipping date (out1) in the shipping information is set as the“ arrival date (in4) ”in the receiving information, and the“ shipping number (5) ”in the shipping information is“ the number of receiving (5) ”in the receiving information. Also, the carry-in number is automatically numbered as i4 and written in the receipt information, and the carry-out number o1 in the shipment information is read, and the read-out number o1 is read as a link number linked to the shipment information. Write in the “Link” item.

[Wholesale (base 2): Shipment to intermediate wholesaler (base 3) (3 boxes)]
Next, in the case of five boxes received in wholesale 2, any three boxes are shipped to intermediate wholesale 3 (see FIG. 5). In this case, the wholesaler 2 administrator (hereinafter referred to as the wholesaler 2) is the product information such as item, subcommittee, packing form, and quantity as the data of the carry-out lot from the screen of the personal computer 21. In addition, the distribution base of the shipping destination (base 3) and the number of shipments (3 boxes) are input. The product information such as items, subcommittees, packing styles, and quantities is input by referring to the arrival information of 5 boxes in the carry-in lot 2 and copying it.

  As a result, the personal computer 21 has the base (2), the item (α), the subcommittee (×), the packing form (×), the quantity (×), the distribution base (3) of the shipping destination, the shipping date (out2), the shipping Shipment information describing the number (3) is created and sent to the distribution route management server 61 via the network 7. In this shipping information, the shipping date (out2) is automatically entered as the date of creation of the shipping information.

  The distribution route management server 61 adds items “carry out number” and “link (link number)” to the shipment information from wholesale 2 and sets the item “distribution base of shipment destination” to “To”. Store in the database 62. In the shipment information of wholesale 2, in the item “link (link number)”, the carry-in number i4 in the receipt information of the five carry-in lots of wholesale 2 is read, and the read carry-in number i4 is received. Write as a link number linked to information. In addition, o2 is automatically assigned as a carry-out number and is written in the item “carry-out number”.

[Intermediate wholesale (base 3): Arrival from wholesale (base 2) (3 boxes)]
When the distribution information from the wholesaler 2 to the intermediate wholesaler 3 (shipment information for the three unloading lots of the wholesaler 2) is created, the distribution route management server 61 receives the arrival information of the three imported lots of the intermediate wholesaler 3 from the shipped information. Is automatically created (see FIG. 6).

  In this case, the distribution route management server 61 sets “location (2)” in the shipping information as “distribution location (From) (From) (2)” in the arrival information, and “distribution location of the shipping destination” in the shipping information. (To) (3) ”is“ base (3) ”in the arrival information, and the data of each item of“ item ”,“ committee ”,“ packing shape ”, and“ quantity ”is copied.

  Further, the “shipping date (out2)” in the shipping information is set as the “arrival date (in5)” in the receiving information, and the “shipping number (3)” in the shipping information is “the number of receiving (3)” in the receiving information. And Also, the carry-in number is automatically assigned as i5 and written in the arrival information. Further, the carry-out number o2 in the shipment information is read out, and the read out carry-out number o2 is written in the item “linking” in the arrival information as a link number linked to the shipping information.

[Intermediate wholesale (base 3): Shipment to retail store I (base 4) (2 boxes)]
Next, it is assumed that arbitrary two boxes are shipped to the retail store 4 in the case of three boxes received in the wholesaler 3 (see FIG. 7). In this case, the manager of the wholesaler 4 (hereinafter, the administrator of the wholesaler 4 is referred to as the intermediate wholesaler) from the screen of the personal computer 31 as the data of the carry-out lot, item, subcommittee, packing form, quantity etc. In addition to the merchandise information, the distribution base (base 4) and the number of shipments (two boxes) of the shipping destination are input. The product information such as items, subcommittees, packing styles, and quantities is input by referring to the arrival information of the 3 carry-in lots of the wholesaler 3 and copying it.

  Thereby, the personal computer 31 has the base (3), the item (α), the subcommittee (×), the packing form (×), the quantity (×), the distribution base of the shipping destination (4), the shipping date (out3), the shipping Shipment information describing the number (2) is created and sent to the distribution route management server 61 via the network 7. In this shipping information, the shipping date (out3) is automatically entered as the date of creation of the shipping information.

  The distribution route management server 61 adds the items “carry out number” and “link (link number)” to the shipping information from the wholesaler 3, and sets the item “distribution base of shipping destination” as “To”. And stored in the database 62. In the shipping information of the intermediate wholesaler 3, in the item “link (link number)”, the carry-in number i5 in the incoming information of the carry-in lot 3 boxes in the intermediate wholesaler 3 is read out, and the read-in carry-in number i5 is read out. Write as a link number linked to the arrival information. In addition, o3 is automatically assigned as a carry-out number and is written in the item “carry-out number”.

[Intermediate wholesale (base 3): Shipment to retail store II (base 5) (1 box)]
Next, it is assumed that the remaining one of the three cases received in the wholesaler 3 is shipped to the retail store 5 (see FIG. 8). In this case, the wholesaler uses the screen of the personal computer 31 as the data of the carry-out lot, in addition to the product information such as item, subcommittee, packing form, and quantity, as well as the shipping destination distribution base (base 5) and the number of shipments ( 1 box). The product information such as items, subcommittees, packing styles, and quantities is input by referring to the arrival information of the 3 carry-in lots of the wholesaler 3 and copying it.

  As a result, the personal computer 31 includes the base (3), the item (α), the subcommittee (×), the packing form (×), the quantity (×), the distribution base of the shipping destination (5), the shipping date (out4), the shipping Shipping information in which the number (1) is written is created and sent to the distribution route management server 61 via the network 7. In this shipping information, the shipping date (out4) is automatically entered as the date of creation of the shipping information.

  The distribution route management server 61 adds the items “carry out number” and “link (link number)” to the shipping information from the wholesaler 3, and sets the item “distribution base of shipping destination” as “To”. And stored in the database 62. In the shipping information of the intermediate wholesaler 3, in the item “link (link number)”, the carry-in number i5 in the incoming information of the carry-in lot 3 boxes in the intermediate wholesaler 3 is read out, and the read-in carry-in number i5 is read out. Write as a link number linked to the arrival information. In addition, o4 is automatically assigned as the carry-out number and is written in the item “export number”.

[Retail store I (base 4): Stock from the wholesaler (base 3) (2 boxes)]
When the shipping information from the intermediate wholesaler 3 to the retail store 4 (shipment information of the two unloading lots of the intermediate wholesaler 3) is created, the distribution path management server 61 creates the two lots of the imported lots of the retail store 4 from the shipping information. Arrival information is automatically created (see FIG. 9).

  In this case, the distribution path management server 61 sets “location (3)” in the shipment information as “distribution location (From) (3)” of the shipment information, and “distribution location of the shipping destination” in the shipment information. (To) (4) ”is set as“ base (4) ”in the arrival information, and data of each item of“ item ”,“ committee ”,“ packing shape ”, and“ quantity ”is copied.

  Further, the “shipment date (out3)” in the shipment information is set as “arrival date (in6)” in the arrival information, and the “number of shipments (2)” in the shipment information is “the number of arrivals (2)” in the arrival information. And Also, the carry-in number is automatically assigned as i6 and written in the arrival information. Further, the carry-out number o3 in the shipment information is read out, and the read out carry-out number o3 is written in the “linking” item in the arrival information as a link number linked to the shipping information.

[Retail store II (base 5): Stock from the middle wholesaler (base 3) (1 box)]
When the shipping information from the intermediate wholesaler 3 to the retail store 5 (shipment information for one unloading lot of the intermediate wholesaler 3) is created, the distribution route management server 61 creates the one lot of the incoming lot of the retail store 5 from this shipping information. Arrival information is automatically created (see FIG. 10).

  In this case, the distribution path management server 61 sets “location (3)” in the shipment information as “distribution location (From) (3)” of the shipment information, and “distribution location of the shipping destination” in the shipment information. (To) (5) ”is set as“ base (5) ”in the arrival information, and the data of each item of“ item ”,“ subcommittee ”,“ packing shape ”, and“ quantity ”is copied.

  Further, the “shipping date (out4)” in the shipping information is set as the “arrival date (in7)” in the receiving information, and the “number of shipping (1)” in the shipping information is “number of receiving (1)” in the receiving information. And Also, the carry-in number is automatically assigned as i7 and written in the arrival information. Further, the carry-out number o4 in the shipment information is read out, and the read out carry-out number o4 is written in the item “linking” in the arrival information as a link number linked to the shipping information.

[Intermediate wholesale (base 3): Inspection]
Now, it is assumed that the distribution process described above is in the distribution process shown in FIG. 6, for example, and cases # 1, # 3, and # 10 are received in the wholesaler 3 (see FIG. 11). Here, it is assumed that the distribution routes of cases # 1, # 3, and # 10 are to be known. In this case, the wholesaler reads the barcode information from the labels L of the cases # 1, # 3, and # 4 by the barcode information reading function added to the PDA 32, and inputs the barcode information to the personal computer 31. Then, an operation command for starting inspection is given to the personal computer 31.

  When the personal computer 31 receives an operation command to start inspection from the wholesaler, the personal computer 31 accesses the distribution route management server 61 via the network 7 and reads the arrival information stored in the database 62 as inspection information. Display on the screen. From the inspection information displayed on the screen of the personal computer 31, the wholesaler designates the arrival information of the incoming lot including cases # 1, # 3, and # 10 (incoming information of the incoming lot 3 boxes of intermediate wholesale 3). .

  Then, the personal computer 31 reads out the link number o2 from the arrival information of the designated 3 delivery lots of the intermediate wholesaler 3, and identifies the link number o2 and the identification numbers U001, U003, U010 of cases # 1, # 3, and # 10. Is sent to the distribution route management server 61. The distribution route management server 61 distributes the link number o2 sent from the personal computer 31 and the identification numbers U001, U003, U010 to the intermediate wholesale 3 of cases # 1, # 3, and # 10 as follows. Is identified.

[Identification of Distribution Channel for Case # 1]
The distribution route management server 61 accesses the case information stored in the database 62 and checks whether the group number and the route number are written for the identification number U001 of the case # 1 (see FIG. 12A). ). In this case, since the group number and route number of the identification number U001 are “-(none)”, it is determined that the distribution route of the case # 1 is the first time, and the carry-in number corresponding to the identification number U001 is determined. The i1 is read, and the receipt / shipment information linked by the link number o2 is traced back to the arrival information of the collection place 1 where the carry-in number i1 is written, and the distribution route of the case # 1 is specified. The distribution route in case # 1 is specified as follows.

  First, the distribution route management server 61 uses the link number o2 sent from the personal computer 31 to determine the base (3), the arrival date (in5), and the item (α) in the arrival information to which this link number o2 is attached. The route information is created by reading, setting the group number to “1”, and the route number to “1” (see FIG. 12B).

  In this route information, “serial number” indicates the hierarchy of the distribution base. In this case, since the base (3) is a wholesaler and is located in the third layer, the serial number is “3”. That is, this route information is created as route information of the third layer of the group number “1” and the route number “1”.

  Next, the distribution route management server 61 reads the base (2), the shipping date (out2), and the item (α) from the shipping information linked to the link number o2, that is, the shipping information of the carry-out number o2, and the group number Is set to “1”, the route number is set to “1”, and route information of the second layer is created (see FIG. 12C). Then, the link number i4 in the shipping information of the carry-out number o2 is read, and the arrival date (in4) is read from the arrival information linked to the link number i4, that is, the arrival information of the carry-in number i4. Information is written (see FIG. 12D).

  Next, the link number o1 in the receipt information of the carry-in number i4 is read out, and the base (1), the shipment date (out1), and the item are determined from the shipment information linked to the link number o1, that is, the shipment information of the carry-out number o1. (Α) is read, the group number is “1”, the route number is “1”, and the route information of the first layer is created (see FIG. 12E).

  Then, it knows from the case information that the carry-in number of case # 1 (identification number U001) is i1, reads the arrival date in1 from the arrival information of the carry-in number i1, and writes it in the route information of the first layer (FIG. 12 ( f)).

  In this way, the distribution route management server 61 creates the route information of the group number “1” and the route number “1”, and the group number “1” and the route number “1” of the created route information are stored in the case. It writes in the column of the identification number U001 in the information (see FIG. 13A). Based on the route information of the group number “1” and the route number “1”, it is specified that the distribution route of the case # 1 is “collection area → wholesale → intermediate”, and the distribution route of the specified case # 1 Is displayed on the screen of the personal computer 31 including the receipt / shipment date.

[Identification of Distribution Channel for Case # 3]
The distribution route management server 61 accesses the case information stored in the database 62 and checks whether the group number and the route number are written for the identification number U003 of case # 3 (see FIG. 13B). ). In this case, since the group number and the route number of the identification number U003 are “-(none)”, it is determined that the distribution route of the case # 3 is the first time specified.

  Here, the carry-in number corresponding to the identification number U003 is i1, which is the same as the carry-in number in case # 1. Therefore, cases # 1 and # 3 have the same distribution route. In this case, the distribution route management server 61 has already identified the distribution route of case # 1, and the route information of the group number “1” and the route number “1” is created as information indicating the distribution route. The group number “1” and the route number “1” are written in the field of the identification number U003 in the case information (see FIG. 14A).

  Based on the route information of the group number “1” and the route number “1”, it is specified that the distribution route of the case # 3 is “collection place → wholesale → intermediate wholesale”, and the distribution route of the specified case # 3 Is displayed on the screen of the personal computer 31 including the receipt / shipment date.

[Identification of Distribution Channel for Case # 10]
The distribution route management server 61 accesses the case information stored in the database 62 and checks whether the group number and the route number are written for the identification number U010 of case # 10 (see FIG. 14B). ). In this case, since the group number and the route number of the identification number U010 are “-(none)”, it is determined that the distribution route of the case # 10 is specified for the first time.

  Here, the carry-in number corresponding to the identification number U010 is i3, which is different from the carry-in number of cases # 1 and # 3. This indicates that case # 10 and cases # 1 and # 3 have different arrival lots to the collection area 1. In this case, the distribution route management server 61 copies the route information of the group number “1” and the route number “1” indicating the distribution route of cases # 1 and # 3, and sets the route number “1” in the route information. It is rewritten as “2”, and the arrival date in3 in the arrival information of the delivery number i3 is written in the “arrival date” of the route information of the first layer (see FIG. 14C). Then, the group number and route number of the created route information are read out and written in the column of the identification number U010 in the case information.

  Based on the route information of the group number “1” and the route number “2”, it is specified that the distribution route of the case # 10 is “collection place → wholesale → intermediate”, and the distribution route of the specified case # 10 Is displayed on the screen of the personal computer 31 including the receipt / shipment date.

[Retail store I (base 4): Inspection]
Now, it is assumed that the distribution process described above is in the distribution process shown in FIG. 9, for example, and cases # 1 and # 10 are received in the retail store 4 (see FIG. 15). In this case, it is assumed that cases # 1, # 3, and # 10 are inspected at intermediate wholesaler 3.

  Here, when it is desired to know the distribution channels of cases # 1 and # 10, the manager of the retail store 4 (hereinafter, the manager of the retail store 4 is referred to as retailer A) has the barcode information added to the PDA 41. By the reading function, the barcode information is read from the labels L of the cases # 1 and # 10, and an operation command for starting inspection is given to the distribution route management server 61 via the Internet 7.

  When the distribution route management server 61 receives an operation command from the retailer A to start the inspection, the distribution information stored in the database 62 is read as inspection information and displayed on the screen of the PDA 41. From the inspection information displayed on the screen of the PDA 41, the retailer A designates the arrival information of the incoming lot including cases # 1 and # 10 (the incoming information of the two incoming lots in the retail store 4).

  Then, the PDA 41 reads the link number o3 from the arrival information of the two carry-in lots of the designated retail store 4, and distributes the link number o3 and the identification numbers U001 and U010 of cases # 1 and # 10 to the distribution route management server 61. Send to. The distribution route management server 61 specifies the distribution routes of cases # 1 and # 10 from the link number o3 and the identification numbers U001 and U010 sent from the PDA 41 as follows.

[Identification of Distribution Channel for Case # 1]
The distribution route management server 61 accesses the case information stored in the database 62 and checks whether the group number and the route number are written for the identification number U001 of the case # 1 (see FIG. 16A). ). In this case, since the group number of the identification number U001 is “1” and the route number is “1”, it is determined that the distribution route of case # 1 is not the first time, and is linked by the link number o3. Go back to receipt / shipment information and specify the distribution route of case # 1. The distribution route in case # 1 is specified as follows.

  First, the distribution route management server 61 reads the base (4), the arrival date (in6), and the item (α) in the arrival information to which the link number o3 is attached by using the link number o3 sent from the PDA 41. . Then, the fourth layer route information is created for the three layer route information of the group number “1” and the route number “1” already created (see FIG. 16B). Further, the shipping date out3 is read from the shipping information linked to the link number o3, that is, the shipping information of the carry-out number o3, and the “shipping date” of the third layer route information of the group number “1” and the route number “1” is read. "

  In this way, the distribution route management server 61 updates the route information of the group number “1” and the route number “1”. In this case, the group number and route number written in the column of the identification number U001 in the case information are left as they are. Based on the route information of the group number “1” and the route number “1”, it is specified that the distribution route of the case # 1 is “collection place → wholesale → intermediate wholesale → retail store I”. One distribution channel is displayed on the screen of the PDA 41 including the receipt / shipment date.

[Identification of Distribution Channel for Case # 10]
The distribution route management server 61 accesses the case information stored in the database 62 and checks whether the group number and the route number are written for the identification number U010 of case # 10 (see FIG. 17A). ). In this case, since the group number of the identification number U010 is “1” and the route number is “2”, it is determined that the distribution route of the case # 10 is not the first time, and is linked by the link number o3. Going back to receipt / shipment information, the distribution route of case # 10 is specified. The distribution route in case # 10 is specified as follows.

  First, the distribution route management server 61 reads the base (4), the arrival date (in6), and the item (α) in the arrival information to which the link number o3 is attached by using the link number o3 sent from the PDA 41. .

  Then, the fourth layer route information is created for the three layer route information of the group number “1” and the route number “2” already created (see FIG. 17B). Further, the shipping date out3 is read from the shipping information linked to the link number o3, that is, the shipping information of the carry-out number o3, and the “shipping date” of the third layer route information of the group number “1” and the route number “2” is read. "

  In this way, the distribution route management server 61 updates the route information of the group number “1” and the route number “2”. In this case, the group number and the route number written in the column of the identification number U010 in the case information are left as they are. Based on the route information of the group number “1” and the route number “2”, it is specified that the distribution route of the case # 10 is “collection place → wholesale → intermediate wholesale → retail store I”. Ten distribution channels are displayed on the screen of the PDA 41 including the receipt / shipment date.

[Retail store II (base 5): Inspection]
Now, in the distribution process described above, for example, in the distribution process shown in FIG. 10, it is assumed that case # 3 is received in the retail store 5 (see FIG. 18). In this case, it is assumed that cases # 1, # 3, and # 10 are inspected at intermediate wholesaler 3.

  Here, when it is desired to know the distribution route of the case # 3, the manager of the retail store 5 (hereinafter, the manager of the retail store 5 is referred to as a retailer B) uses a barcode information reading function added to the PDA 51. Then, the barcode information is read from the label L of the case # 3, and an operation command for starting inspection is given to the distribution route management server 61 via the Internet 7.

  When the distribution route management server 61 receives an operation command from the retailer B to start the inspection, the distribution information stored in the database 62 is read as inspection information and displayed on the screen of the PDA 51. From the inspection information displayed on the screen of the PDA 51, the retailer B designates the incoming information of the incoming lot including case # 3 (the incoming information of one incoming lot in the retail store 5).

  Then, the PDA 51 reads the link number o4 from the arrival information of one carry-in lot of the designated retail store 5, and sends this link number o4 and the identification number U003 of case # 3 to the distribution route management server 61. The distribution route management server 61 specifies the distribution route of case # 3 from the link number o4 and the identification number U003 sent from the PDA 51 as follows.

[Identification of Distribution Channel for Case # 3]
The distribution route management server 61 accesses the case information stored in the database 62 and checks whether the group number and the route number are written for the identification number U003 of case # 3 (see FIG. 19A). ). In this case, since the group number of the identification number U003 is “1” and the route number is “1”, it is determined that the distribution route of the case # 3 is not the first time, and is linked by the link number o4. Going back to receipt / shipment information, the distribution route of case # 3 is specified. The distribution route of case # 3 is specified as follows.

  First, the distribution route management server 61 reads the base (5), the arrival date (in7), and the item (α) in the arrival information to which the link number o4 is attached, using the link number o4 sent from the PDA 51. . Then, the route information of the fourth layer is to be created for the route information of the group number “1” and the route number “1” already created. However, in this case, route information of the fourth layer has already been created in the route information of the group number “1” and the route number “1” by the inspection of the case # 1 at the retail store 4 (FIG. 19B). )reference).

  Accordingly, the distribution route management server 61 copies the route information of the group number “1” and the route number “1” indicating the distribution route of the case # 1, and sets the route number “1” in the route information to “3”. By rewriting, the base (5), the arrival date (in7) and the item (in the arrival information in which the link number o4 is written in the fourth layer of the route information of the group number “1” and the route number “3” ( α) is written (see FIG. 19C). Then, the route number of the created route information is read and written in the column of the identification number U003 in the case information.

  Based on the route information of the group number “1” and the route number “3”, it is specified that the distribution route of the case # 3 is “collection place → wholesale → intermediate wholesale → retail store II”. 3 distribution channels are displayed on the screen of the PDA 52 including the receipt / shipment date.

  In the above-described embodiment, the inspection is performed at the retail store 4 and the retail store 5 after the inspection is performed at the intermediate wholesaler 3, but the retail store 4 and the retail store 5 are not performed at the intermediate wholesaler 3. You may make it inspect by. In this case, in the retail store 4 or the retail store 5, in the same manner as in the case of the intermediate wholesaler 3, the link number is used to connect to the arrival information of the collection place 1 where the carry-in number corresponding to the identification number read from the case is written. The receipt / shipment information to be attached is traced, and the distribution channel of the case is specified.

  In the above-described embodiment, the distribution base has a four-layer structure of the collection place 1, wholesale 2, intermediate wholesale 3, and retail stores 4, 5, but it is sufficient that the distribution base has a hierarchical structure from upstream to downstream. There may be many wholesalers 2 and intermediate wholesalers 3. Further, the inspection may be performed at the wholesaler 2, or the inspection may be performed at each of the wholesaler 2, the wholesaler 3, and the retail store 4 and 5. Also, by specifying an identification number in the case information at a management center (not shown) or the like, the distribution route of a desired case specified at wholesale 2, intermediate wholesale 3, retail stores 4, 5 etc. can be known at any time. It is possible, and the distribution channel of the entire product can be managed.

  As can be seen from the above description, according to the present embodiment, when the identification number is read with the desired case 100 as the inspection object at an arbitrary distribution base, the carry-in number in the case information corresponding to the identification number is read. Is read and the receipt / shipment information linked by the link number written in the receipt information of the delivery lot including the inspection object is traced back to the arrival information of the collection place 1 where the delivery number is written, The distribution route of the inspection object is specified, and the distribution route of the desired case 100 can be specified at any distribution base without inspecting all the cases 100 for each distribution base. 2, the work load in the intermediate wholesaler 3, the retail store 4, and the retail store 5 can be minimized and implemented as an actual system.

In the above-described embodiment, the barcode label L is attached to the case 100, but a wireless tag (RFID) or the like may be used.
In the above-described embodiment, the case of the agricultural product is the distribution target, but the distribution target is not limited to the case of the agricultural product, and may be a product such as an electric product. Further, the distribution object is not limited to products.

It is a figure which shows an example of the distribution route management system used for implementation of the distribution route management method concerning this invention. It is a figure explaining the creation processing of the case information at the time of goods arrival to the collection place from a producer in this distribution channel management system, and the arrival information of a collection place. It is a figure explaining the preparation processing of the shipping information of the collection place at the time of shipment of the goods from the collection place to a wholesale in this distribution channel management system. It is a figure explaining the creation processing of the wholesale receipt information at the time of shipment of the goods from the collection place to the wholesale in this distribution route management system. It is a figure explaining creation processing of wholesale shipment information at the time of shipment of goods from wholesale to intermediate wholesale in this distribution channel management system. It is a figure explaining the creation process of the receipt information of intermediate wholesale at the time of shipment of the goods from wholesale to intermediate wholesale in this distribution channel management system. It is a figure explaining the creation processing of the wholesale shipment information at the time of shipment of the goods from the intermediate wholesale to the retail store I in this distribution route management system. It is a figure explaining the creation processing of the wholesale shipment information at the time of the shipment of the goods from the middle wholesaler to the retail store II in this distribution channel management system. It is a figure explaining the creation processing of the receipt information of the retail store I at the time of shipment of the goods from the wholesaler to the retail store I in this distribution channel management system. It is a figure explaining the creation processing of the receipt information of the retail store II at the time of the shipment of the goods from the middle wholesaler to the retail store II in this distribution channel management system. It is a figure explaining the inspection of the goods in the wholesale in this distribution channel management system. It is a figure which shows the process of the production | generation process of the route information at the time of the inspection of the goods (case # 1) in the wholesale in this distribution route management system. It is a figure which shows the process of the production | generation process of the route information at the time of the inspection of the goods (case # 1, # 3) in the wholesale in this distribution route management system. It is a figure which shows the process of the production | generation process of the route information at the time of the inspection (case # 3, # 10) of the goods in the wholesale in this distribution route management system. It is a figure explaining the inspection of the goods in the retail store I in this distribution channel management system. It is a figure which shows the process of the production | generation process of the route information at the time of the inspection of goods (case # 1) in the retail store I in this distribution route management system. It is a figure which shows the process of the creation process of the route information at the time of the inspection of the goods (case # 10) in the retail store I in this distribution route management system. It is a figure explaining the process in the case of the inspection of the goods in the retail store II in this distribution channel management system. It is a figure which shows the process of the production | generation process of the route information in the case of the goods inspection (case # 3) in the retail store II in this distribution route management system.

Explanation of symbols

  DESCRIPTION OF SYMBOLS 1 ... Pickup place, 2 ... Wholesale, 3 ... Intermediate wholesale, 4 ... Retail store I, 5 ... Retail store II, 6 ... Data center, 7 ... Network (Internet) 11, 21, 31 ... Personal computer (PC), 12, 22, 32, 41, 51 ... PDA, 51, 52 ... mobile phone, 61 ... distribution route management server, 62 ... database, 100 (# 1 to # 10) ... merchandise (a crop case), L ... barcode Label.

Claims (10)

In a distribution route management method for managing a distribution route of distribution objects collected at a first distribution base, which is a base point of distribution, and sent from the first distribution base to a downstream distribution base,
Case information indicating the relationship between the identification information given to the distribution object collected at the first distribution base and the import number determined for each import lot of the distribution object is created and stored in the database. One step,
For each distribution base, inbound information indicating the relationship between the carry-in number determined for each lot of the distribution object to be delivered to the distribution base and the distribution base from which the distribution object is shipped is created and stored in the database. The second step;
For each distribution base, shipment information indicating the relationship between the carry-out number determined for each discharge lot of the distribution object shipped from the distribution base and the distribution base of the distribution target is shipped and stored in the database. The third step;
When creating the arrival information of the distribution base downstream from the first distribution base, read out the carry-out number in the shipping information of the distribution base of the distribution source of the distribution object to be delivered to the distribution base, A fourth step of writing the read out number in the arrival information as a link number associated with the shipping information;
When creating shipment information of a distribution base downstream from the first distribution base, the loading number in the loading information of the unloading lot of the distribution object shipped from the distribution base is read, and the read loading number is A fifth step of writing in the shipping information as a link number linked to the arrival information;
The first number in which the carrying number in the case information corresponding to the identification information read from the inspection object is read as a desired distribution object at an arbitrary distribution base, and the carrying number is written 6th step of identifying the distribution route of the inspection object by tracing back the receipt / shipment information linked by the link number written in the arrival information of the incoming lot including the inspection object until the distribution information of the distribution object A distribution route management method comprising: In the distribution channel management method according to claim 1,
The sixth step includes
A distribution path management method, wherein information relating to the distribution path of the specified inspection object is written in the case information in association with identification information given to the inspection object. In the distribution channel management method according to claim 2,
The sixth step includes
The route information indicated by the group number and the route number indicating the distribution route of the specified inspection object is created, and the group number and the route number of the route information are used as information relating to the distribution route of the specified inspection object. A distribution route management method characterized by writing information. In the distribution channel management method according to claim 2 or 3,
The sixth step includes
Corresponding to the identification information read from the inspection object, if information related to the distribution route of the inspection object is written in the case information, it is written in the arrival information of the incoming lot including the inspection object. The distribution route management method characterized by tracing back the receipt / shipment information linked by the link number, and specifying the remaining distribution route for which the inspection object is not specified. In the distribution channel management method according to claim 1,
The sixth step includes
A distribution path management method, comprising: displaying the distribution path of the specified inspection object on a terminal at the arbitrary distribution base. In a distribution route management system for managing a distribution route of distribution objects collected at a first distribution base that is a distribution base and sent from the first distribution base to a downstream distribution base,
Case information creating means for creating case information indicating a relationship between identification information given to a distribution object collected at the first distribution base and a carry-in number determined for each carry-in lot of the distribution object; ,
Incoming information creation means for creating inbound information indicating a relationship between a delivery number determined for each delivery lot of a distribution object to be received at the distribution base and a distribution base of the distribution target for each distribution base ,
Shipping information creating means for creating shipping information indicating the relationship between the unloading number determined for each unloading lot of the distribution object shipped from the distribution base and the distribution base of the distribution target for each distribution base; ,
When creating the arrival information of the distribution base downstream from the first distribution base, read out the carry-out number in the shipping information of the distribution base of the distribution source of the distribution object to be delivered to the distribution base, Means for writing the read out delivery number in the arrival information as a link number associated with the shipping information;
When creating shipment information of a distribution base downstream from the first distribution base, the loading number in the loading information of the unloading lot of the distribution object shipped from the distribution base is read, and the read loading number is Means for writing in the shipping information as a link number linked to the arrival information,
The first number in which the carrying number in the case information corresponding to the identification information read from the inspection object is read as a desired distribution object at an arbitrary distribution base and the carrying number is written The distribution route specifying means for identifying the distribution route of the inspection object by tracing the receipt / shipment information linked by the link number written in the arrival information of the incoming lot including the inspection object up to the arrival information of the distribution base And a distribution channel management system comprising: In the distribution channel management system according to claim 6,
The distribution route specifying means includes
A distribution path management system, wherein information relating to the distribution path of the specified inspection object is written in the case information in association with identification information given to the inspection object. In the distribution channel management method according to claim 7,
The distribution route specifying means includes
The route information indicated by the group number and the route number indicating the distribution route of the specified inspection object is created, and the group number and the route number of the route information are used as information relating to the distribution route of the specified inspection object. A distribution path management system characterized by writing information. In the distribution channel management system according to claim 7 or 8,
The distribution route specifying means includes
Corresponding to the identification information read from the inspection object, if information related to the distribution route of the inspection object is written in the case information, it is written in the arrival information of the incoming lot including the inspection object. A distribution route management system characterized by tracing back receipt / shipment information linked by a link number, and specifying a remaining distribution route in which the inspection object is not specified. In the distribution channel management system according to claim 6,
The distribution route specifying means includes
The distribution route management system, wherein the distribution route of the specified inspection object is displayed on a terminal at the arbitrary distribution base.

Images