JP5424740B2 - Method for creating traceability information, apparatus for manufacturing a product by processing a plurality of materials, traceability information output method, material information output method, and material information management program - Google Patents

Description

  The present invention relates to a method for creating traceability information of an individual identification number of an original material from which a product to be sold is manufactured, an apparatus for manufacturing a product by processing a plurality of materials, a traceability information output method, a material information output method, and a material. It relates to information management programs.

  Conventionally, a serial number such as a car body number has been assigned to a product such as an automobile that requires management after sales in order to facilitate management of each individual. This serial number is assigned at the factory where it is produced, and the manufacturer identifies the dealer that sold the car body with the corresponding serial number, for example, when a recall occurs, and further identifies the sales destination. , I was able to send out a recall guide. Also, the user side can obtain information specific to the vehicle body by inquiring of the vehicle body number assigned to the vehicle body owned by the user to the manufacturer.

In addition, by attaching a serial number barcode to each part and reading and associating the barcode during assembly, the individual parts used in each car can be identified for efficient manufacturing. There is a technique for managing a history (Patent Document 1).
JP-A-6-203040

  The above-described prior art is effective for products such as automobiles that are printed on an individual as it is, but is not suitable for products such as fresh food.

  For example, in the case of beef sold at a supermarket, the serial number cannot be printed on the product itself. In addition, it is conceivable to attach a label with a serial number printed on the package, but if it is a normal household, the package will be peeled off and discarded immediately before use for cooking. Even if it occurred, it was not possible to identify the individual because the label was already discarded with the package at that time.

  In order to solve such a problem, the present invention aims to enable a user to specify an individual of a consumed product even if it is not immediately after purchase by printing a number for categorizing the individual on a receipt. And

  Means for solving the problem will be described with reference to FIG.

  In FIG. 1, the POS 32 prints or pays the product name, price, and individual identification number retrieved and retrieved based on the individual identification number read from the barcode attached to the product, the IC tag, etc. It is something to do.

  The receipt 35 is printed with a product name, price, and individual identification number at the time of product purchase.

  The headquarter server 41 manages various information. Here, the original material information is presented based on the individual identification number printed on the receipt notified by the customer, or based on the customer ID. A list of products purchased by the customer is presented, and when selected, the original material information that produced the product is presented based on the individual identification number associated with the product.

  Next, the operation will be described.

  The POS 32 retrieves the product name and price by searching the database based on the individual identification number read from the label attached to the product when the product is sold. The retrieved product name, price, and individual identification number are It prints on receipts.

  In addition, when there are a plurality of materials from which the product is manufactured, information or symbols indicating that are printed on the receipt.

  Further, the headquarters server 41 or the like searches the database based on the individual identification number received from the customer who searches for information and presents the material information of the original material that manufactured the product, or receives the individual identification The database is searched based on the number, the individual identification number of the material corresponding to the individual identification number is extracted, and the material information of the material of the extracted one or more individual identification numbers is presented. .

  As information, an individual weaving number is assigned to each material, and when a new product is manufactured from a plurality of materials, a new individual identification number is assigned to the new product. Therefore, individual identification numbers given to raw materials such as beef and pork are called individual identification numbers, and individual identification numbers given to processed products such as minced meat and hamburger made by combining these ingredients are called company identification numbers. And

  The individual identification number and the company identification number are managed in a database. Thereby, the company identification number of the product is printed at the time of selling the product version, and the customer can later search on the website of the store using the company identification number as a key to confirm the material information.

  According to the present invention, when a product is purchased, a number by which the POS system identifies the individual is printed on the receipt, so that the user can specify the individual of the consumed product even if it is not immediately after purchase. For example, it becomes possible for the customer to search later on the website of the store or the like using the individual identification number (in-house identification number) of the product printed on the receipt as a key and confirm the material information.

  According to the present invention, when a product is purchased, a number by which the POS system identifies the individual is printed on the receipt, so that the user can specify the individual of the consumed product even if it is not immediately after purchase. For example, the customer can later perform a search on a store website or the like using the individual identification number (in-house identification number) of the product printed on the receipt as a key to confirm the material information.

  Next, embodiments and operations of the present invention will be described in detail sequentially with reference to FIGS.

  FIG. 1 shows a system configuration diagram of the present invention.

  In FIG. 1, a dairy farmer 1 is an original material for producing a product, here, a cow, and a unique individual identification number (for example, 001) for each cow (material) by operating the lower PC 11. ) And the breeding information is registered and managed in the breeding information database 12.

  The PC 11 is a personal computer that performs various processes by installing various software. Here, the breeding information of the material (for example, cattle) is registered and managed in the breeding information database 12 or via the network 13. Various types of data are transmitted to and received from the PC 21 and the like.

  The breeding information database 12 registers and manages the breeding information of the material (see (a) of FIG. 9).

  The network 13 is a communication path for transmitting and receiving data between the PC 11 and the PC 21.

  The slaughterhouse 2 is a material that has been bred. Here, the slaughterhouse 2 is a place where a material (such as carcass) that has been slaughtered and processed is manufactured, and the material that has been bred to the processed material (such as carcass) It inherits the individual identification number and trace code and manages the processed material.

  The PC 21 is a personal computer that performs various processes by installing various software. Here, the slaughter information such as carcass processed from the material (eg, beef) is registered and managed in the slaughter information database 22. Various data are transmitted / received to / from the PC 11 and the head office server 31 through the networks 13 and 23.

  The slaughter information database 22 registers and manages material slaughter information (see FIG. 9B).

  The network 23 is a communication path for transmitting and receiving data between the PC 21 and the headquarter server 31.

  The store 3 is composed of a sales floor, a headquarters, and the like, and processes materials and sells them to customers.

  The sales floor processes the raw material to produce a product (for example, steak, minced meat, etc.), attaches an IC tag to the product, reads the tag of the product, prints a receipt and prints a receipt 35, and passes it to the customer. This is the place where the store server 31, POS 32, card reader 33, scanner 34, receipt 35, PLU master database 36, food processing master database 37, store product master database 38, customer master database 39, etc. are installed.

  The store server 31 is set in a sales floor (store) and manages a plurality of POS 32 and the like in the sales floor and various databases.

  The POS 32 reads the code from the IC tag (or barcode) attached to the product when the customer brings the product from the shelf or the like to the counter, and obtains the product name, price, individual identification number, and company identification number. The receipt 35 is printed and settled.

  The card reader 33 reads a customer ID or the like from the customer's customer card or reads a code from a credit card.

  The scanner 34 reads information (a solid identification number, a company identification number, etc.) from a barcode attached to (printed on) a product or an IC tag.

  The receipt 35 is printed with the product name, price, quantity of the product purchased by the customer, the individual identification number for each product, the company identification number, and the like.

  In the PLU master database 36, product names and the like are registered in association with codes (JAN codes) and the like (see (l) in FIG. 11).

  The food processing master database 37 registers product names and the like in association with codes (for example, JAN codes) (see (k) in FIG. 11).

  The store-by-store product master database 38 is registered in association with products by store in association with codes (for example, JAN codes) (see (j) in FIG. 11).

  The customer master database 39 stores personal information (name, address, etc.) of the customer in association with the customer ID (membership number, etc.) (see (d) of FIG. 10).

  The headquarters supervises a plurality of sales floors. Here, the headquarters server 41, the traceability information database 42, the product master database 43, etc. are installed and managed centrally.

  The headquarter server 41 manages the store server 31 installed in the sales floor. Here, the headquarter server 41 manages the traceability information database 42, the product master database 43, and the like, or identifies individual items printed on receipts from customers. The corresponding individual identification information is presented in response to the inquiry of the individual identification information that notifies the number, the company identification number, and the like.

  The traceability information database 42 is registered with individual identification information of the original material from which the product is manufactured in association with the company identification number and the individual identification number (see (c) of FIG. 9).

  The product master database 43 registers and manages information such as product names (product names, product codes, prices, quantities, etc.) in association with codes (for example, JAN codes).

  The customer 5 is a customer who purchased the product. Here, the individual identification number printed on the receipt 35 received at the time of purchasing the product and the company identification number are notified, and the individual information of the original material from which the product is manufactured The customer who installed the PC 51 and the like.

  The PC 51 is operated by the customer 5 and inputs the individual identification number and the company identification number for each product printed on the receipt 35 delivered at the time of purchasing the product, and connects to the headquarter server 41 via the network. It requests and displays the material information of the original material produced.

  Next, the operation of the configuration of FIG. 1 will be sequentially described in detail according to the flowcharts of FIGS.

  FIG. 2 shows a flowchart for explaining the operation of the present invention (creating an individual identification number).

  In FIG. 2, S1 inputs a call code (4-digit JAN code short call key) from the screen of the measuring instrument. For example, the carcass purchased from the slaughterhouse is processed at the sales floor in FIG. 1, and the call code (4-digit JAN code short call key) is input from the measuring instrument screen for the product “ground beef”.

  In S 2, the JAN code, the original unit price, the selling unit price, the product name, and the tray weight are read from the measuring instrument master 61 from the input call key. For example, the JAN code, the original unit price, the selling unit price, the product name, and the tray weight are read from the input master key, for example, from the measuring device master 61 in FIG.

  In S3, the individual identification number of the manufactured product is input. Enter more than one if there are more. This is the individual identification number of the original material of the product manufactured (processed) in S1 and S2, for example, when the product (ground beef) is manufactured from three types of carcass, the individual identification number of the three types of carcass, For example, 001, 002, 003 is input.

  In S4, if the individual identification number is 1, it is the same as the tres code, and if it is plural, the company identification number (automatic numbering) is written in the trace code. This is the same as the tres code (single identification number and trace code are the same) when the individual identification number input in S3 is one, and in the case of multiple cases, for example, when the individual identification number is 001, 002, 003 For example, the company identification number (automatic numbering) 004 is written in the trace code. Here, in the trace code, an individual identification number is stored for a product sold as one individual, and an in-house identification number is stored for a product combining a plurality of individuals. However, since each is a number for identifying an individual, the meaning is an individual identification number.

  In S5, it is determined whether the registration of the individual identification number is completed. If YES, the process proceeds to S6. If NO, return to S3 and repeat.

  In S6, the manufactured product is placed on the measuring instrument, and an automatic numbering of the calibration / company identification number and an IC tag label are issued. The JAN code, trace code, product name, cost, selling price, weight, date of manufacture are written on the IC tag label (cost is written only on the IC).

  In S7, an IC tag label is attached to the manufactured product.

  In S8, the process proceeds to the next manufactured product.

  S9 discriminate | determines whether it is the same goods. In the case of YES, S6 and subsequent steps are repeated. On the other hand, if NO, the process proceeds to S10.

  In S10, it is determined whether or not it is completed. If YES, the process ends. In the case of NO, S1 and subsequent steps are repeated.

  As described above, when a product is manufactured by processing the purchased carcass and the like in the sales floor of FIG. 1, the product is manufactured by processing one or a plurality of materials (such as carcass), and one or more of the products The individual identification number of each material is entered and registered, and when the number is one, the individual identification number is used as a trace code, and when there are a plurality of items, the unique company identification number automatically assigned is used as a trace code. By writing the code, product name, price, etc. on the tag and pasting the IC tag on the product, the individual identification number of the original material manufactured for each product can be traced from the material of multiple individual identification numbers. Each manufactured product is created by registering and storing the individual material identification number of the original material by generating the code assigned in-house as a trace code and associating it with the product. Grant individual identification number of the original material so that it is possible to manage.

  FIG. 3 is a flowchart for explaining the operation of the present invention (POS shopping purchase settlement to receipt output).

  In FIG. 3, in S21, the label of the ground beef bought is read by a scanner. In this case, the customer brings the ground beef bag from the shelf to the POS 32 location at the sales floor in FIG. 1, and the store clerk reads the label of the ground meat pack with a scanner.

  In S22, the previously created PLU master database 36 is read using the read data (trace code or the like) as a key.

  In S23, it is determined whether it is an error or OK. If it is OK, the process proceeds to S26. If there is an error, an error message is output to the POS screen in S24, and the clerk performs error handling processing in S25. And when it becomes OK, it progresses to S26.

  In S26, the data (product name, selling price, company identification number, trace code, etc.) in the PLU master database 36 is edited and output to the transaction file. The same contents are output to the receipt. The customer then pays and receives the receipt and the merchandise.

  As described above, when the customer brings the product to the POS 32 location, the store clerk reads the data from the label attached to the product, searches the database, extracts the product name, price, company identification number, and trace code and prints it on the receipt. At the same time, the customer prints the individual identification number of the original material that produced the product, or the company identification number (trace code) that summarizes the product, in addition to the product name and price for each purchased product. Can be received.

  FIG. 4 is a flowchart for explaining the operation of the present invention (receipt output when a personal card is read at the time of payment for a POS purchase).

  In FIG. 4, S31 reads the store's personal card from the card reader.

  In S32, the customer master database 39 (see (d) of FIG. 10) is read using the read data as a key.

  In S33, it is determined whether the error or OK. If OK, the process proceeds to S36. If there is an error, an error message is output to the POS screen in S34, error handling processing is performed in S35, and if OK, the process proceeds to S36.

  In S36, the label of the ground beef bought is read by the scanner. In this case, the customer brings the ground beef pack from the shelf to the POS 32 in the sales floor of FIG. 1, and the store clerk reads the label of the ground meat pack with the scanner.

  In S37, the PLU master database 36 is read using the read data as a key.

  In S38, it is determined whether it is an error or OK. If it is OK, the process proceeds to S41. If there is an error, an error message is output to the POS screen in S39, and the clerk performs error handling processing in S40. And when it becomes OK, it progresses to S41.

  In S41, the data (product name, selling price, company identification number, trace code, etc.) in the PLU master database 36 is edited and output to the transaction file. The same contents are output to the receipt. The customer then pays and receives the receipt and the merchandise.

  As described above, when the customer presents the card, the store clerk reads the data from the card, compares it with the customer master database 39, and if it is OK, reads the data from the label attached to the product brought by the customer and searches the database. By taking out the product name, price, company identification number, and trace code, printing them on the receipt and registering them for storage, the customer can add the product name, price, etc. for each purchased product, as well as the original material from which the product was manufactured. It becomes possible to print and receive an identification number or a company identification number (trace code) that summarizes these.

  FIG. 5 is a flowchart for explaining the operation of the present invention (when searching for safety based on receipt information from a personal computer).

  In FIG. 5, S51 connects a personal computer to the store homepage.

  In S52, the individual identification number (in-house identification number) or the trace code output on the receipt from the search key input screen is input. In S51 and S52, the customer 5 operates the PC 51 in FIG. 1 to connect to the home page of the headquarter server 41 (WWW server) via the network 52, and downloads, for example, on the search screen in FIG. The individual identification number (in-house identification number) and the trace code printed on the receipt are input, and the search is requested by pressing the Enter key.

  S53 reads the corresponding traceability information database 42 based on the input individual identification number (in-house identification number) or trace code.

  In S54, it is determined whether it is OK or an error. If OK, the process proceeds to S56. If there is an error, an error message is output to the personal computer screen in S55. Then, S52 and subsequent steps are repeated.

  In S56, the read data of the traceability information database 42 is edited and output to the screen of the personal computer. For example, as shown in the screen example of FIG. 8B to be described later, the input individual identification number (in-house identification number), presenting the material information of the original material used for manufacturing corresponding to the trace code, Presented as shown below.

-Purchased product name: ground beef-Trace code: 1004
・ Processing date: March 1, 2003 ・ Expiration date: March 2, 2003 ・ Distributor: ABC Super D store ・ Shipping origin: XX Dairy ・ Shipping date: February 25, 2003 ・BSE test result: Individual identification number 001: February 10, 2003
: Individual identification number 002: February 11, 2003
: Individual identification number 003: Already February 11, 2003 ・ Production place: Individual identification number 001: XX prefecture Kita Dairy 30% wt
: Individual identification number 002: XX prefecture South Dairy Farming 20% wt
: Individual identification number 003: XX prefecture dairy farming 50% wt
-Breeding information: Feed: Milk
: Vaccination: None
-Antibiotics: None As described above, the individual identification number (in-house identification number) and the trace code printed on the receipt received by the customer at the time of product purchase are connected to the store headquarters server 41 and the website shown in FIG. When a search instruction is input and entered on the search screen of (a), material information (production place, breeding information, production information, breeding information, etc.) on the search result screen of FIG. BSE test results and the like) can be presented.

  FIG. 6 is a flowchart for explaining the operation of the present invention (when searching for safety based on shopping history information of a store from a personal computer).

  In FIG. 6, S61 connects the personal computer to the store homepage.

  In S62, the personal card number is input from the search key input screen. In S61 and S62, the customer 5 operates the PC 51 of FIG. 1 to connect to the home page of the headquarter server 41 (WWW server) via the network 52, and downloads, for example, on the search screen of FIG. Enter the member number in the member number input field, and press the Enter key to request a search.

  S63 reads the customer master database 39 ((d) of FIG. 10) with the card number as input.

  In S64, it is determined whether it is OK or an error. If OK, the process proceeds to S66. If there is an error, an error message is output to the personal computer screen in S65. Then, S62 and subsequent steps are repeated.

  In S66, the shopping history information in the read customer master database 39 is edited and output to the screen of the personal computer.

  S67 designates the corresponding shopping date on the screen.

  In S68, the details of shopping in the customer master database 39 are edited and output to the screen of the personal computer.

  S69 designates a corresponding shopping from the shopping details output on the screen.

  In S70, the traceability information database 42 is read from the purchase (goods) based on the individual identification number (in-house identification number) and the trace code. The store master database is read based on the store code. Edit the read traceability information and store information data and output them to the screen. For example, the material information of the original material used for manufacturing corresponding to the purchased product is presented (see FIG. 8B).

  As described above, when a customer inputs a member number to display a shopping history list, specifies a shopping date from among them, displays a shopping product list, and specifies a product from that, an individual identification number of the product (In-house identification number) and material information (production location, breeding information, BSE test results, etc.) of a plurality of materials that have been searched and manufactured based on the trace code are presented ((b) in FIG. 8). Is possible.

  FIG. 7 shows an example of receipt printing according to the present invention.

  FIG. 7A shows a receipt printing example 1. This receipt printing example 1 is printed in association with the following information shown in the figure.

・ Distributor: ABC Super Komagome Store ・ Sales date: March 1, 2003 ・ Product name: ground beef ・ Selling price: ¥ 500
-Individual identification number: 1004
Trace code: 1004
・ Consumption tax: ¥ 25
・ Total: ¥ 525
Here, the individual identification number and the trace code are a unique individual identification number (or in-house identification number) and a trace code assigned to the product “ground beef”.

  By printing the individual identification number (or in-house identification number) and the trace code for each product on the receipt as described above, it is printed on the receipt from the search screen of FIG. 8A according to the flowchart of FIG. When the individual identification number (or the company identification number) and the trace code entered are input, it is possible to present information on the original material that produced the product.

  FIG. 7B shows a receipt printing example 2. In this receipt printing example 2, the symbol ☆ is printed after the individual identification number and the trace code, and the fact that the product is manufactured from a plurality of materials is printed.

  FIG. 8 shows a search explanatory diagram of the present invention.

  FIG. 8A shows a product safety search key input screen (trace code usage example). The illustrated screen is an example of a search screen that is downloaded and displayed by the customer by connecting the PC 51 to the headquarter server 41 (WWW server) in S51 of FIG. 5 described above. An example of inputting “1004” is shown. In addition, it is possible to search in the same manner by inputting an individual identification number or a member number.

  FIG. 8B shows an example of a product safety search screen. In this screen, when the trace code “1004” is input on the screen of FIG. 8A and the search is instructed by pressing the Enter key, the traceability is performed according to the steps S52 to S56 of FIG. In this example, information retrieved from the information database 42 is displayed, and the following information shown in the figure is displayed in association with each other.

-Title: ABC Super Safety Search-Search Date: March 2, 2003-Purchased Product Name: Ground Beef-Trace Code: 1004
・ Processing date: March 1, 2003 ・ Expiration date: March 2, 2003 ・ Distributor: ABC Super D store ・ Shipping origin: XX Dairy ・ Shipping date: February 25, 2003 ・BSE test result: Individual identification number 001: February 10, 2003
: Individual identification number 002: February 11, 2003
: Individual identification number 003: Already February 11, 2003 ・ Production place: Individual identification number 001: XX prefecture Kita Dairy 30% wt
: Individual identification number 002: XX prefecture South Dairy Farming 20% wt
: Individual identification number 003: XX prefecture dairy farming 50% wt
-Breeding information: Feed: Milk
: Vaccination: None
Antibiotic: None Here, the title indicates that it is a search screen for “ABC Super”, which is the company name of the store 3 in FIG. 1, and the search date indicates the search date. The purchased product name represents the product name (ground beef) corresponding to the trace code input on the search screen. The trace code is a trace code entered on the search screen. The date of processing and the expiration date are the date of processing the product and its expiration date. The dealer is the dealer who sold the product. The shipping source and shipping date are the shipping source and shipping date of the product. The BSE inspection result is the date and time of the BSE inspection for each individual identification number of the material (in this case, carcass) used for manufacturing the product of the trace code 1004 and the OK result. The production area is the production area of the original material used to manufacture the product. The breeding information is the original material used in the manufacture of the product (here, the carcass breeding information and the individual identification numbers 001, 002,003 are the same breeding information and are displayed together).

  As described above, based on the trace code of the product printed on the receipt, the database is searched and each shipping source, BSE inspection date and time based on the individual identification numbers of a plurality of materials used for manufacturing the product. It is possible to present OK information and breeding information.

  9 to 11 show DB examples of the present invention.

  FIG. 9A shows an example of a breeding information database (header part, body part). The breeding information database 12 shown in FIG. 1 is for the dairy farmer in FIG. 1 described above to register and manage the breeding information of the material (here, cattle). Here, the individual identification for each cow is unique. A number, for example, 001 is assigned, and the following information shown in the figure is registered and managed in association with each other.

・ Header:
-Individual identification number: 001
Trace code: 001
-Product name: Matsusaka beef-Classification code: Shigofuku-Producer code: 1234
-Producer name: Kita Dairy-Variety: Japanese black beef-Standard size: Half head right-Ship date: 200221220
・ Shipping name: Kinki Dairy ・ Inspection date: 20030210
・ Inspection organization: ○ Inspection place ・ Quantity: 900 kg
・ Production start date: 1995.01.01
・ Others:
・ Body part:
-Individual identification number: 001
Trace code: 001
・ Production date: 19950102
・ Feed / fertilizer name: Milk ・ Ingredients: Powdered milk ・ Quantity / weight: 40L
・ Vaccination: None ・ Antibiotics: None ・ Others:
Here, the individual identification number is a unique individual identification number 001 assigned to the material (cow). In the case of a product (carcass) consisting of a single material (cow), the individual identification number and the trace code are the same 0001. In the case of a product made of a plurality of materials (for example, ground beef), the individual identification number (in-house identification number) is automatically numbered and the same trace code is used (hereinafter the same). The product name, classification code, producer code, producer name, breed, and standard size are the product name (Matsusaka beef), classification code, producer code, producer name, and breed (Japanese black beef) of the product (cow). The standard size, shipping date, and shipping destination name are the standard size, shipping date, and shipping destination name of the product. The inspection date, inspection organization, quantity, and production start date are the date of inspection such as BSE, the inspection organization, quantity, and the date of production start. The feed / fertilizer name, raw material, quantity / weight, vaccination, and antibiotics are the feed, raw material, quantity, presence / absence of vaccination, and administration of antibiotics used for breeding the material (cow).

  As mentioned above, breeding information (production start date, producer, search organization, inspection date, presence / absence of vaccination, presence / absence of antibiotics, etc.) by giving a unique individual identification number to each material (cow) By registering and managing in the database 12, individual identification numbers are assigned to each material (cow) to individually manage the breeding information, and the individual identification number (in-house identification number) of the product printed on the receipt by the customer, tracing Based on the code, it is possible to present breeding information on the material of the product.

  FIG. 9B shows an example of a slaughter information database. The illustrated slaughter information database 22 registers and manages the following information shown in association with each other.

・ Individual identification number:
・ Trace code:
・ Product name:
·classification code :
・ Producer code:
・ Processor name:
・ Variety:
・ Standard size:
·Inspection date :
·Inspection agency :
・ Inspection content:
・ Processing date:
·ship date :
・ Shipping code:
·quantity :
・ Others:
Here, the individual identification number is a unique individual identification number of the material, and here, only the material (carcass) that slaughtered the material (cow) of the individual identification number 001 of the breeding information database 12 of FIG. Therefore, the same individual identification number 001 is set, and the trace code is also set to the same individual identification number 001. The product name, classification code, producer code, and breed are the same as the material (cow) in the breeding information database 12. The name of the processor is the name of the processor who processed the material (cow) into carcass. The inspection date, inspection organization, and inspection content are the inspection date, inspection organization, and inspection content when processing the material (cow) into the material (carcass). The processing date is the date when the material (cow) is processed into the material (carcass). The shipping date, shipping destination code, and quantity are the date, shipping destination code, and quantity when the processed material (carcass) is shipped.

  As described above, the individual identification number of the material (cow) used for manufacturing the material (carcass) obtained by processing and processing the material (cow) registered and managed in the breeding information database 12 in FIG. The material identification number and trace code of the material (carcass) are used as they are, and the material information (breeding information, etc.) of the original material (cow) is linked (related) so that it can be easily searched and processed. Processing information (processing name, inspection date, inspection organization, inspection contents, processing date, shipping destination, shipping destination code) can be registered and managed in the slaughter information database 22. Similarly, the individual identification number and trace code of the material are linked to each other, and the product is sold to the customer and printed on the receipt for each product (in-house identification number) and the trace code. It is possible to easily present material information (eg, breeding information) of the original material by the individual identification number.

  FIG. 9C shows an example of a traceability information DB. The traceability information DB 52 registers and manages the following information shown in association with each other.

・ Header:
・ Company identification number:
・ Trace code:
·store code :
・ Product name:
·classification code :
・ Individual identification number:
・ Ratio:
・ Producer name:
·Producing area :
・ Production start date:
・ Variety:
・ Standard size:
·ship date :
・ Shipping code:
-Shipment quantity:
・ Processor name:
・ Processing date:
·Inspection date :
·Inspection agency :
・ Inspection content:
・ Processing quantity:
・ Others:
・ Body part:
・ Individual identification number:
・ Production date:
・ Feed / fertilizer name:
・ Raw materials:
・ Quantity / weight:
・ Vaccination: None ・ Antibiotics: None ・ Others:
Here, the company identification number is a unique identification number assigned to a product manufactured based on a plurality of materials (individual identification numbers). Here, the individual identification numbers 001, 002, 003 of the materials (carcasses) are The company identification number 1004 is automatically assigned and assigned to the product (ground beef) manufactured (processed) by using it. The trace code is 1004 which is the same as the company identification number. The store code is the code of the store that sold the product. The product name and classification code are the product name (ground beef) and the classification code of the product. The individual identification number is the individual identification number 001, 002, 003 of the original material (carcass) used for manufacturing (processing) the product (ground beef). The ratio is the use ratio (%) for each individual identification number of the original material (carcass) used. Producer name, production location, production start date, product type, standard size, shipping date, ship-to party code, shipping quantity, processor name, processing date, inspection date, inspection organization, inspection contents, processing quantity is the original material ( Carcass) for each individual identification number. Similarly, for the body part, production date, feed / fertilizer name, raw material, quantity / weight, presence of vaccination, antibiotic administration for each individual identification number of the material (carcass) used in the manufacture (processing) of the product It is a registration of breeding information such as the presence or absence of each.

  As described above, when there are multiple original materials (carcasses) used for manufacturing (processing) products (ground minced meat), the material information and breeding information for each individual identification number of the original materials (carcasses) By registering and managing the product, all the materials used for manufacturing (processing) the product based on its own identification number (individual identification number) and trace code printed on the receipt at the time of purchase of the product ( The material information and breeding information can be searched with the individual identification number of carcass and presented to the customer (for example, (b) in FIG. 8 described above).

  FIG. 10D shows an example of a customer master database. The customer master database 39 registers and manages the following information shown in association with each other.

・ Header:
·Membership number :
・ Name:
·Birthday :
·Family structure :
・ Address / 〒 number:
·phone number :
·mail address:
・ PIN code:
・ Other:
・ Body part:
·Membership number :
・ Date:
・ JAN code:
・ Product name:
·quantity :
・ Sales price:
・ Point:
・ In-house identification number (individual identification number):
・ Trace code:
・ Other:
Here, the membership number is a unique number assigned to the customer. Name, date of birth, family structure, address / postal code, telephone number, e-mail address, and personal identification number are customer personal information. Further, the date, JAN code, product name, quantity, selling price, point, company identification number (individual identification number), and trace code in the body part are the product history purchased by the customer of the member number.

  As described above, a member number is assigned to the customer, and the customer's personal information (name, address, etc.) and product purchase history (date, JAN code, company identification number (individual identification number), trace code are assigned to the member number as a key. 6), the member number is input on the search screen of FIG. 8A in accordance with the flowchart of FIG. 6 described above, and the customer master database 39 is searched to display the product purchase history list. For the selected date and the selected product, the traceability information database 52 in FIG. 9C described above is searched based on the company's own identification number (individual identification number) and the trace code of the product. Based on the company identification number (individual identification number) and trace code, the material information and breeding information of the original material used for manufacturing (processing) the product And as shown by (b) in FIG. 8, it is possible presented.

  FIG. 10E shows an example of a product master database. The merchandise master database registers and manages the following information shown in association with each other.

・ JAN code (NONLU):
・ Product name:
・ POS product name:
·classification code :
・ Manufacturer code:
・ Standard size:
・ Cost ○ 1 (represents the number 1 with circles, the same shall apply hereinafter):
・ Sales price ○ 1:
・ Cost ○ 2:
・ Sales price ○ 2:
・ Sales floor pattern:
·Suppliers :
・ Handling classification by store:
・ Center division:
・ Order unit:
・ Ordering cycle:
·lead time :
・ Unit price:
·expiration date :
・ Others:
Here, the JAN code is a code assigned to the product, and the information shown in the figure is registered and managed in association with the JAN code.

  (F) of FIG. 10 shows an example of a store master. The store master registers and manages the following information shown in association with each other.

・ Store code:
·Store name :
·Street address :
・ Others:
FIG. 10G shows an example of an IC tag. The following information shown in the figure is registered in association with the IC tag and pasted on the product.

・ Header:
・ JAN code:
・ Company identification number:
・ Trace code:
・ Product name:
・ Cost:
・ Sales price:
・ Weight:
・ Production date and time:
・ Others:
・ Body part:
・ Trace code:
・ Individual identification number:
・ Others:
(H) of FIG. 10 shows an example of a measuring instrument master. The weighing machine master 61 registers and manages the following information shown in association with each other.

・ Call code:
・ JAN code (NONLU):
・ Product name:
・ Original unit price:
・ Unit price:
・ Tare type:
・ Label identification:
・ Others:
This is used when creating the information that weighs the product of FIG. 2 and writes it to the IC tag.

  (I) of FIG. 11 shows an example of measuring instrument performance data. The measuring instrument result data is registered and managed in association with the following information shown in the figure. The measuring instrument master 61 is referred to to measure the merchandise, create the merchandise information, and write it to the IC tag. It is to register and manage the performance information at that time.

・ Company identification number:
・ JAN code (NONLU):
・ Trace code:
・ Individual identification number ○ 1:
・ Percentage (%) ○ 1:
・ Individual identification number ○ 2:
・ Percentage (%) ○ 2:
・ Individual identification number ○ 3:
-Ratio (%) ○ 3:
・ Cost:
・ Sales price:
・ Weight:
・ Production date and time:
・ Others:
(J) of FIG. 11 shows an example of a store-specific product master database. The store-specific product master database 38 registers and manages the following information shown in association with each other.

・ JAN code (NONLU):
・ Product name:
・ POS product name:
·classification code :
・ Manufacturer code:
・ Standard size:
・ Cost:
・ Sales price:
·Suppliers :
·start date :
·End date :
・ Order unit:
·expiration date :
・ Other
FIG. 11 (k) shows an example of a food processing database. The merchandise processing database 37 registers and manages the following information shown in association with each other.

・ Header:
・ JAN code:
・ Product name:
・ POS product name:
·classification code :
・ Manufacturer code:
・ Standard size:
・ Company identification number:
・ Cost:
・ Sales price:
·Suppliers :
·start date :
·End date :
・ Order unit:
·expiration date :
・ Other
・ Body part:
・ JAN code:
・ Trace code:
・ Individual identification number:
・ Others:
FIG. 11 (l) shows an example of a PLU master database. The PLU master database 36 registers and manages the following information shown in association with each other.

・ JAN code (NONLU):
・ Company identification number:
・ Trace code:
・ POS product name:
・ Cost:
・ Sales price:
・ Weight:
・ Others:

  The present invention relates to a method for creating traceability information of an individual identification number of an original material from which a product to be sold is manufactured, an apparatus for manufacturing a product by processing a plurality of materials, a traceability information output method, a material information output method, and a material. It relates to information management programs.

It is a system configuration diagram of the present invention. It is operation | movement description flowchart (creation of an individual identification number) of this invention. It is operation | movement description flowchart (receipt output from payment adjustment of POS shopping) of this invention. It is operation | movement explanatory drawing flowchart (receipt output when a personal card is read at the time of payment of POS shopping). It is an operation explanation flowchart of the present invention (when searching for safety based on receipt information from a personal computer). It is an operation explanation flowchart of the present invention (when searching for safety based on store shopping history information from a personal computer). It is an example of receipt printing of the present invention. It is a search explanatory view of the present invention. It is DB example (the 1) of this invention. It is DB example (the 2) of this invention. It is DB example (the 3) of this invention.

1: Dairy Farmer 11: PC
12: Breeding information database 13: Network 2: Slaughterhouse 21: PC
22: Slaughter information database 23: Network 24: Carcass 3: Store 31: Store server 32: POS
33: Card reader 34: Scanner 35: Receipt 36: PLU master database 37: Food processing master database 38: Store-specific product master database 39: Customer master database 41: Headquarter server 42: Traceability information database 43: Product master database 44: Network 5: Customer 51: PC
52: Network

Claims (5)

A method for creating traceability information for a product,
Receiving a number body identification information for uniquely identifying a number of materials for each of a plurality of materials constituting the product,
Generating one trace code that uniquely identifies the product;
The one trace code, and recording each of the individual body identification information and traceability information database in association with uniquely identifying a plurality of material pieces constituting the product specified by the single trace code,
A method of creating traceability information, wherein the computer executes a step of writing the one trace code on a label attached to the product. A device for managing products,
An input unit for inputting the individual member identification information for uniquely identifying a plurality of each of the materials to individual body of the material making up the product,
A trace code generation unit for generating one trace code for uniquely identifying the product;
The one trace code, a recording unit for recording the traceability information database in association with each of the individual body identification information uniquely identifying a plurality of material pieces constituting the product specified by the single trace code ,
An apparatus for managing a product, comprising: a writing unit that writes the one trace code on a label of the product. Server device
Receiving information for uniquely identifying a product composed of a plurality of materials;
Information for uniquely identifying the product received in the step of receiving information for uniquely identifying the product composed of the plurality of materials, information for uniquely identifying the product, and materials for each of the plurality of materials constituting the product product of using traceability information database with the individual body in association with individual member identification information that uniquely identifies, identified by uniquely specifying information items received in the step of accepting a uniquely specifying information the product obtaining a number body identification information for a plurality of materials constituting the,
Slaughter information having association with the plurality of material pieces body identification information constituting the product obtained in step to obtain the individual body identification information for the plurality of materials, and a number of information materials of the individual member identification information and said workpiece by using the database, and executes a step of outputting to obtain information of a plurality of materials each of pieces of configuring the product obtained in the step of obtaining the individual member identification information of the plurality of material Traceability information output method. A material information output method for causing a server to execute a process of searching a database and outputting processed product material information.
The database is
A unique number between materials, the first material, the first individual identification number which is assigned with the first material information,
A unique number between materials, the second material, the second individual identification number granted with information of the second material,
A unique number between items, and a third individual unit identification number assigned to the work item processed the first material and the second material,
Wherein the third individual identification number and association with the first identification number and said second individual identification number is registered,
The server is
The third of individual identification number on the basis of material information output method, characterized by performing the step of outputting said second material information and the first material of the information from the database. A material information management program for causing a computer to execute processing for managing material information of processed products,
In the computer,
Together with the first material information and the second material information, and storing the processed granted individual identification number to the products obtained from the said first material and the second material in the database,
Wherein the input of the individual identification number, material information management program for causing and a step of displaying the said first material information and the second material of the information on a display device.

Images