TWI778623B - Traceability management method of agricultural, fishery and animal husbandry industry product supply chain - Google Patents

Abstract

The supply chain traceability management method for agricultural, fishery, and animal husbandry products provided by the present invention is to provide the user to input an identification data, and to find at least one first data and second data matching the identification data from the aforementioned databases. data and/or third data, and then perform a recursive operation on the first data, the second data and/or the third data to search for and establish a link with the first data, the second data and/or the third data A traceability node for a relationship. Accordingly, it is possible to trace the relevant historical footprint of the product in the supply chain across factories.

Description

Traceability management method of agricultural, fishery and animal husbandry industry product supply chain

The invention relates to related data management technology, in particular to a traceability management method of agricultural, fishery and animal husbandry industry product supply chain.

Press, like other industries, the products produced by agriculture, fishery and animal husbandry need the cooperation of upstream, middle and downstream manufacturers to complete the production, transportation and sales of products. Among them, taking the chicken industry as an example, chickens need to go through feed factories, vaccine factories, chick hatcheries, breeding farms, slaughter plants, cutting plants, processing plants, cold chain logistics, stores and restaurants from breeding to sales. Many heterogeneous manufacturers form an industrial supply chain.

Furthermore, in order to ensure the issue of food safety, food safety has become the focus of the management of each manufacturer. However, although some manufacturers use manual record management, the reliability and timeliness of their data is a long-standing problem.

In response to the aforementioned problems, some manufacturers have switched to using the data system to record. However, because the data are usually stored in different databases or different files, the current production and sales records are sometimes connected in the upstream, middle and downstream raw materials-semi-finished products-finished products. It is quite difficult, and consumers often only get fragmented food safety information.

The main purpose of the present invention is to provide a traceability management method for the supply chain of agricultural, fishery and animal husbandry industry products, which can digitally manage various data in the agricultural, fishery and animal husbandry industry supply chain, so as to improve the concatenation and immediacy of relevant data. effect.

Another object of the present invention is to provide a traceability management method for the supply chain of agricultural, fishery and animal husbandry products, which can utilize the traceability nodes obtained by calculation, so as to facilitate users to quickly search for the cross-plant/farm data they want to inquire.

The reason is that, in order to achieve the above purpose, the present invention provides a supply chain traceability management method for agricultural, fishery and animal husbandry industry products, which is for the user to input an identification data, and to find at least one related identification data from the aforementioned databases. Matching the first data, the second data and/or the third data, and perform the relational recursive operation on the first data, the second data and/or the third data to search for and establish the relationship with the first data, the second data And/or the third data has a link relationship with a traceability node. Based on this, it is possible to query the relevant historical footprints of the product in the supply chain across factories.

The identification information includes the code of the company to be checked, the batch number to be checked and the order number to be checked.

The first data includes company code and inventory data.

The second data includes source documents and return documents, and the source documents include purchase orders, material picking lists, out-of-consignment purchase orders, shippers, sales orders, storage orders, transfer orders, material transfer orders, and inventory. Transaction document, the return document includes return document, material return document, consignment return document and sales return document.

Among them, the database further includes third data, the third data includes the source manufacturing order, the receiving order and the batch number process data, the batch number process data includes the process, the manufacturing batch number, the mother manufacturing batch number, and the receiving batch number. The first data and/or the third data are recorded on the source document and the returned document respectively.

First of all, the terms "first", "second" and "third" disclosed in the present invention represent similar technical features, which are used to distinguish different data, information, equipment or modules, etc., and It does not represent the order of arrangement among "first", "second" and "third", nor does it represent any order of execution, nor does it represent that they are necessarily related to each other, nor does it represent their function or structure. It is necessarily different or the same, and it does not limit the "first", "second" or "third" to be different or the same type, which will be explained together first.

Next, please refer to FIG. 1 , the method for traceability management of the supply chain of agricultural, fishery and animal husbandry products provided in the preferred embodiment of the present invention can be applied to a platform 10 , and the platform 10 mainly includes a production and sales management system 20 , a production monitoring system 30, a supply chain traceability management product footprint management system 40 and a resource management system 50, these systems are connected to each other by wired or wireless communication technology, and provide each manufacturer in the supply chain with a single platform The product management function provides independent digital management for manufacturers, and can automatically generate and release product footprints to achieve the purpose of automatic management and monitoring.

The platform 10 can be, but is not limited to, a computer program constructed and stored in a computing device (such as a desktop computer, a notebook computer, a smart phone or a tablet computer, etc.) or a server for It is used by the user to read or execute.

The production and sales management system 20 includes a data management database 21, an invoicing management database 22, an operation management database 23 and a financial management database 24, wherein the data management database 21 stores a plurality of 1. Information, the first information can be but not limited to company code information, site (factory) information, item main classification information, item sub-category information, item name information, item information, inventory information, item number information, Brand information, item registration information, item schedule information, supplier information, manufacturer information, customer information, user information, employee information, etc. Among them, the field (factory) category information includes field (factory) category number and field (factory) alias. The main classification data of the item may be, but not limited to, feed, vaccine, chicken, frozen chicken or others. The classification data of the item can be but not limited to chicken feed, antibiotic vaccine, antivirus vaccine, chick, adult chicken, red-feather chicken or waste. The supplier information includes supplier number, supplier name, supplier uniform number, supplier telephone number, and supplier address. The manufacturer's information includes the manufacturer's number, the manufacturer's name, the manufacturer's uniform number, the manufacturer's telephone number, and the manufacturer's address. The customer information includes customer number, customer name, customer uniform number, contact person, contact telephone number, fax number, delivery address, etc.

The invoicing management database 22 stores a plurality of second data, each of which may be, but not limited to, source documents and return documents. Wherein, the source document may be, but not limited to, a purchase order, a material picking list, an out-of-consignment purchase order, a shipper, a sales order, a warehouse receipt, a transfer order, a material transfer order, and an inventory transaction document. The return document may be, but not limited to, a return order, a material return order, a consignment return order, and a sales return order.

The operation management database 23 stores a plurality of third data, each of which may be, but not limited to, operation order data, batch number process data, batch process real-time production records, batch number history data, and work order data. Among them, the operation order data includes the operation order type, the operation order number, the date of the document, the estimated production quantity, the production unit, the item specification, the source control order and the receiving order, and the source control order can be divided into breeding system Order, Planting Order, Processing Order, Slaughtering Order, Breeding Order, Fishing Order, Transportation Order, Harvest Order, Fertilization Order, Automatic Feeding/Dosing Order, Fishing Order/Operation Order, Packaging order, sampling inspection order, warehousing order, purchase order, warehousing order, purchase order, etc.; the receiving order can be divided into in-factory order, outsourced order, etc.

The batch number process data includes batch number, process, workstation/supplier, process, start operation time, end operation time, operator, and growth record. Among them, the batch number can be divided into production (manufacturing) batch number, receiving batch number, parent production (manufacturing) batch number, sales batch number, purchase batch number, storage batch number, and outsourcing purchase batch number. The process can be divided into, but not limited to, breeding process, planting process, processing process, slaughtering process, breeding process, fishing process, transportation process, harvesting process, fertilization process, automatic feeding/dosing process, fishing order/operation process, packaging Process, warehousing process, sampling process, etc. The process is the sequence in which the process is performed.

The batch number process real-time production record includes batch number process, inbound quantity, outbound quantity, transfer quantity, scrapped quantity, rework quantity, short quantity, surplus quantity, inbound time, and outbound time. The batch number resume data may be, but not limited to, nutrition labels, inspection data, abnormal types, abnormal causes and other data. The inspection data may be, but not limited to, poultry health certificates, phytosanitary certificates, etc.

In addition, these data of different types can correspond to each other, and each of the order and each process has other related data, for example, the related data of processing order and food processing operation - seasoning and pickling are as follows presented in the table.

Article number Product name brand number brand name Required quantity Unclaimed quantity Quantity received unit Feeding job number Feeding job name Expected pick date Actual Picking Date MIT001 chicken breast (semi-finished product) B001 self made 100.0 -50.0 50.0 Bag 001E0100 Food processing operations - seasoning and pickling 2020/08/10 2020/08/08

It should be noted that, in this embodiment, the first data, the second data and the third data are respectively stored in various corresponding fields of different databases according to their types, attributes, and types. In other embodiments, the first data, the second data, and the third data may also be stored in the same database, and are not limited by the methods listed in the specification.

In addition, these documents respectively contain various types of information corresponding to different operation activities. In this embodiment, each of the documents corresponds to the first data and/or the third data. For example, the picking list includes the information of receiving the required raw materials according to the source manufacturing order or process, and the receiving Use batch number. The raw materials include feed, vaccines, antibacterial agents, feed additives, etc., wherein, the feed additives can be but not limited to vitamins, amino acids, minerals, antifungal agents, mycotoxins adsorbents, growth factors, enzymes, live yeast, Yeast substrate, acidulant, ammonia decomposition neutralizer, etc.

The table below further lists the relevant information of the sales order.

single single number document date Field (factory) serial number Field (factory) alias Customer Number client's name delivery address A21 20200713001 2020/07/08 Fty001 Liduan Livestock Operation Headquarters TPAC Taipei Animal Husbandry and Marketing Co., Ltd. Huanhe South Road…

In addition, the production and sales management system 20 can receive customer orders, perform order operation procedures, issue an operation order according to the order or production plan, and allow users to set the batch number, estimated production volume, field (factory) on the platform 10 Information such as category, product name, item, supplier, brand, etc., is used to change the relevant information in these databases. In addition, the platform 10 allows the issuance of the job order to execute the corresponding process.

The financial management database 24 stores management financial statements, account details, accounting books, accounting entry subpoenas, business tax declaration materials, input and output tax data, and the like.

The production monitoring system 30 has at least one sensor 31, which is not limited to be disposed in production lines, mobile vehicles (such as drones, cars, intelligent robots), agricultural machinery or related facilities (such as farms, fish farms) ), and the sensor 31 is used to detect water quality, soil temperature, leaf humidity, illuminance, temperature and humidity, carbon dioxide, carbon monoxide, ammonia, dust, wind speed, litter humidity, etc., to monitor the current production of agricultural products , manufacturing or packaging and other procedures, and can carry out the corresponding process accordingly, and transmit the maintenance data of the operation to the production and sales management system 20 to update the relevant data. In addition, hyperspectral technology can also be used to detect whether agricultural products have problems with pests and diseases.

The supply chain traceability management product footprint management system 40 includes a product footprint module 41, a reverse traceability module 42, a forward traceability module 43 and a product footprint database 44, wherein the product footprint module 41 is respectively associated with The backtracking module 42 , the backtracking module 43 and the product footprint database 44 are connected, and can generate a product footprint web page for consumers to browse and inquire about through operations.

The product footprint database 44 includes a plurality of fourth data, each of which may be, but not limited to, a footprint number, a footprint name, a footprint type, and the like. Wherein, each of the fourth data has a corresponding associated first data, the second data and/or the third data. In one embodiment, the name of the footprint is "shipping information", the type of the footprint is "other", and the related information is shown in the following table.

footprint number Footprint name Article number Product name brand number brand name Footprint Type Process/Origin Order C001 Shipping Information LB01T001 He Duan-Red Feather Chicken B004 He Duan other Shipping operation

The traceability module 43 can search out the flow direction of bad raw materials based on various data contained in the databases, so as to timely and accurately recycle problematic agricultural products, so as to control the risks caused by bad raw materials with loss. For example, if it is known that there is a problem with a certain batch of chicks, the traceability module 43 searches for all the purchase orders of the batch of problematic chicks, and traces each purchase order downstream to see if there is any breeding or shipment. , auctions, etc., and the traced problem products, whether they are semi-finished products or finished products, are collected in a recycling list, so that relevant units can quickly recycle according to the list. Furthermore, the traceability module 43 can further trace whether the products are shipped to the wholesale market for auction in a cross-company way. Among them, if the problem chicks are shipped to the wholesale market, it will be investigated whether there are chickens that have not been auctioned or have been auctioned. If there are problem chickens that have been auctioned, continue to trace whether the problem chickens shipped to the slaughterhouse are being processed or have been processed and shipped. If there is a problem chicken product that has been processed and shipped, continue to track down the vendor who shipped it.

The traceback module 42 can trace the source and batch number of defective raw materials used in the product in question based on various data contained in the databases. For example, if there is a problem with the frozen chickens sold by the stall, the traceback module 42 can trace back whether there is any abnormality in the production process of the processing factory from the sales order of the product in question, and the production process refers to different Various operational activities represented by source orders and/or processes, such as packaging, slaughtering, veterinary inspections, auctions, and the collection of raw chickens. In addition, the traceability module 42 can further trace back to the breeding of the farm from the purchase order of the auctioned chickens in a cross-company way, such as logistics and breeding management to the receipt and purchase of breeding raw materials. In addition, the traceability module 42 can be traced back to the most upstream manufacturer of chick raising, vaccine administration and feed supply from the purchase order of raw materials.

In addition, the platform 10 is available for users to log in and use the supply chain traceability management product footprint management system 40 to execute the method disclosed in the present invention, wherein the main steps are as follows: first, receive an identification data input by the user, and Find at least one first data, second data or third data matching the identification data from the aforementioned databases. Among them, the identification information is the company code to be checked, the batch number to be checked or the order number to be checked that the user wants to check. To be detailed, the identification data can be any key element, and the character is any one or a combination of Chinese characters, English letters, character strings, numbers or other symbols.

Next, perform a recursive relational operation on the first data, the second data and/or the third data to search for and establish a traceability relationship with the first data, the second data and/or the third data node. Based on this, you can check the relevant historical footprint of the product. Wherein, the traceability node may be, but not limited to, a batch number node, a manufacturing lot number node, a manufacturing order node, a batch number process node, a customer node, a supplier node, a warehouse node or an inventory node, and each of the nodes can be classified according to different types, and It is further connected with corresponding child nodes and/or leaf nodes, respectively.

In addition, the more detailed implementation steps in this embodiment are as follows.

As shown in FIG. 2 to FIG. 6 , the tracing module 43 can execute the following procedures:

A: Root node program and node type confirmation program

As shown in Figure 2, based on the code of the company to be checked and/or the batch number to be checked, a batch number traceability program is entered to generate and return the root node, and after the company code and root node data are imported again, the category of the node to which it belongs is confirmed. That is, the batch number node, the manufacturing batch number node, the order node or the customer node, and the confirmation result is repeated in a recursive loop (Loop), and the result is returned.

B: Traceable batch number program

As shown in Figure 3, the implementation steps of this retroactive batch number program are as follows:

Step S401: Enter the code of the company to be checked and the batch number to be checked.

Step S402: Query all source documents matching the batch number to be checked, and confirm the document type.

Step S403: In step S402, when the source document is a purchase order, a warehouse receipt and/or an out-of-consignment purchase order, a purchase type batch number sub-node, a self-made type batch number sub-node and/or an out-of-consignment type are respectively generated. Lot number child node.

Step S404 : query the batch number source document and the return document, and calculate the quantity of the batch number to be checked recorded on the documents. In detail, the source document queried here will be of the same type as the source document in step S403, for example: the purchase type batch number sub-node only queries the purchase order and the return document; the self-made type batch number sub-node only queries the warehouse receipt; the out-consignment type batch number Sub-nodes only query out-of-consignment purchase orders and out-of-consignment return orders.

Step S405: In step S402, when the source document is not a stock receipt, a stock receipt and/or a consignment receipt, then check whether the batch number to be checked is a manufacturing batch number.

Step S406: In step S405, if the lot number to be checked is a manufacturing lot number, it is further judged whether the manufacturing lot number is related to the material transfer order in the database.

Step S407 : In Step S406 , if there is the material transfer order matching the manufacturing lot number in the database, a sub-node of the manufacturing lot number in process is generated.

Step S408 : query the material transfer order with the manufacturing batch number, and calculate the quantity of the batch number to be checked recorded in the documents.

Step S409: In step S406, if the material transfer order matching the manufacturing lot number does not exist in the database, a sub-node of the manufacturing lot number of a project type is generated.

Step S410 : Inquire about the source control order related to the manufacturing lot number, and calculate the quantity of other batch numbers to be checked related to the source control order.

Step S411: In step S405, if the batch number to be checked is not a manufacturing batch number, it is further determined whether the identification data is related to an inventory transaction document.

Step S412: In step S411, if there is the inventory transaction document associated with the identification data in the database, an initial inventory type inventory leaf node is generated; and the records in the inventory transaction documents are calculated. The number of the batch number to be checked.

Step S414 In step S411, if the inventory transaction document associated with the identification data does not exist in the database, an inventory leaf node of unknown inventory type is generated.

Step S415: Calculate the inventory quantity of the product.

Step S416: Return the traceability results of the preceding steps.

C: Traceable manufacturing batch number node program

As shown in Figure 4, the implementation steps of the traceability manufacturing batch number node program are as follows:

Step S101: Enter the code of the company to be checked and the batch number to be checked.

Step S102: Inquire about all the processes corresponding to the batch number to be checked.

Step S103: In step S102, if the process matching the identification data exists in the database, the traceability module 43 generates a process type batch number process leaf node, and further, the traceability module 43 updates the process leaf node. Sort according to the steps of the process.

Step S104 : query the matching transfer order based on the batch number to be checked, the process obtained in step S103 and the source system order related to the batch number to be checked.

Step S105: Calculate the quantity of the lot numbers to be checked recorded in the transfer orders.

Step S106: temporarily store the node, and return to step S102.

Step S107: In step S102, after processing all the processes matching the identification data, continue to query all the inbound orders and/or the out-of-consignment order and their corresponding batch numbers corresponding to the batch number to be checked.

Step S108: In step S107, if there is the inbound order and/or the out-of-consignment order in the database that matches the identification data, confirm the document type, and when the batch number to be checked is the inbound batch number, the document type For a stock-in document, a sub-node of the batch number of a stock-in type is generated; when the batch number to be checked is an out-of-consignment purchase batch number, the document type is an out-of-consignment purchase order, and a sub-node of an out-of-consignment type batch number is generated.

Step S109 : query the source document and/or the return document with the corresponding incoming batch number and/or outsourcing batch number. In detail, the source document queried here will be of the same type as the document type in step S108, for example: the batch number sub-node of inbound batch number type can only inquire the inbound document; return form.

Step S110 : Calculate the quantity of the batch numbers to be checked recorded in the stock-in slips and/or out-of-consignment purchase slips and out-of-consignment return slips.

Step S111: temporarily store the node, and return to step S107.

Step S112 : In step S107 , after processing all the inbound orders and/or the out-of-consignment receipts that match the identification data, return the traceability result.

D: Trace back batch number node program

As shown in Figure 5, the implementation steps of the batch traceability node program are as follows:

Step S201: Enter the code of the company to be checked and the batch number to be checked.

Step S202 : Inquire about all the receiving orders for the batch number to be checked.

Step S203: In step S202, when a matching order for use is found, it is then judged whether the order for use is an in-factory order or an outsourced order.

Step S204: In step S203, when the receiving order is an in-factory order, the traceability module 43 generates a self-made ordering type order sub-node; when the receiving order is an outsourcing order, The traceback module 43 generates a sub-node of the type of out-of-pocket requisition.

Step S205 : query the matching source document and return document with the receiving batch number and the receiving order obtained in step S203 . In detail, the source document to be queried here will be judged according to the document type in step S203, for example: the sub-node of self-made requisition type order can only inquire the material requisition; one.

Step S206 : Calculate the quantity of the batch numbers to be checked recorded in the source documents and the return documents.

Step S207: temporarily store the node, and return to step S202.

Step S208: In step S202, after processing all the use orders corresponding to the batch number to be checked, continue to check all the sales objects of the batch number to be checked.

Step S209: Check whether the sales object is a company in the supply chain system. Specifically, in step S208, when the sales object is found, it is then determined whether the sales object is a company role. When the judgment result is yes, the traceability module 43 generates a client-type client child node; when the judgment result is no, the traceability module 43 generates a client-type client leaf node.

Step S210 : Query the matching sales order and the sales-return order based on the batch number to be checked and the result obtained in step S209 , and calculate the quantity of the batch number to be checked recorded on the receipts.

Step S211: temporarily store the node, and return to step S208.

Step S212: In step S208, after all the sales objects matching the identification data are processed, it is further queried whether the databases have inventory data matching the identification data.

Step S213: In step S212, if the inventory data matching the identification data exists in the databases, a warehouse leaf node of inventory type is generated, the inventory data is read again, and the quantity thereof is calculated.

Step S214: In step S212, after processing all the inventory data matching the identification data, return the traceability results of the preceding steps.

E: Traceability order node program

As shown in Figure 6, the implementation steps of the traceability order node program are as follows:

Step S301: Enter the code of the company to be checked and the order number to be checked.

Step S302: Query all related manufacturing lot numbers of the manufacturing order matching the order number to be checked.

Step S303: In step S302, if the manufacturing lot number matching the identification data exists in the database, a manufacturing type manufacturing lot number sub-node is generated.

Step S304 : Query the matching transfer order based on the manufacturing lot number and the source system order related to the manufacturing lot number, and calculate the quantity of the pending order number recorded on the documents.

Step S305: temporarily store the node, and return to step S302.

Step S306: In step S302, after all the manufacturing batch numbers matching the identification data are processed, the traceability result is returned.

As shown in FIG. 7 to FIG. 11 , the retrospective module 42 can execute the following procedures:

A: Node Type Confirmation Procedure

As shown in Figure 7, based on the code of the company to be checked and/or the batch number to be checked, a reverse batch number program is entered to generate and return the root node, and after the company code and root node data are imported again, the category of the node to which it belongs is confirmed. That is, the batch number node, the manufacturing batch number node, the order node or the supplier node, and the confirmation result is returned in a recursive loop (Loop), and the result is returned.

B: Backtracking batch number program

As shown in Figure 8, the implementation steps of this retroactive batch number program are as follows:

Step S801: Enter the code of the company to be checked and the batch number to be checked.

Step S802: Query all source documents matching the batch number to be checked, and determine the type of the source documents. That is to say, it is to check whether each document data is related to the batch number to be checked to determine the source document type.

Step S803: In step S802, when the source document is a sales order, a stock receipt, an out-of-consignment receipt and/or a receipt, a sales type batch number sub-node, a manufacturing type batch number sub-node, a Outsourcing Type Lot Number sub-node and/or a Purchase Type Lot Number sub-node.

Step S804 : query the batch number source document and the return document, and calculate the quantity of the batch number to be checked recorded on the documents. In detail, the source document queried here will be of the same type as the source document in step S803, for example: the batch number sub-node of the sales type can only query the sales document and the sales return document; the batch number sub-node of the self-made type can only query the inventory document ; The sub-node of the batch number of the out-of-consignment type can only check the out-of-consignment purchase order and the out-of-consignment return order; the sub-node of the purchase type of the batch number can only check the purchase order and the return order.

Step S805: In step S802, when the source document is not a sales order, a stock receipt, an out-of-consignment receipt and/or a receipt, it is then inquired whether the batch number to be checked is a manufacturing batch number.

Step S806: In step S805, if the lot number to be checked is a manufacturing lot number, it is further judged whether the source manufacturing order related to the manufacturing lot number is related to the transfer order in the database.

Step S807: In step S806, if there is the transfer order matching the source manufacturing order associated with the manufacturing lot number in the database, a manufacturing lot number sub-node of the type in process is generated.

Step S809: In step S806, if the transfer order matching the source order associated with the manufacturing lot number does not exist in the database, a project type manufacturing lot number sub-node is generated.

Step S810: Continue to step S807 or step S809, inquire about the source manufacturing order matching the manufacturing lot number, and calculate the quantity.

Step S811: In step S805, if the batch number is not the manufacturing batch number, it is further judged whether the identification data is related to the inventory transaction document.

Step S812: In step S811, if there is the inventory transaction document associated with the identification data in the database, an initial inventory type inventory leaf node is generated; and the transaction document of the batch number is queried, and the The quantity of the batch number to be checked recorded on these documents.

Step S813 In step S811, if the inventory transaction document associated with the identification data does not exist in the database, an inventory leaf node of unknown inventory type is generated.

Step S814: Calculate the inventory quantity of the product.

Step S815: Return the traceability results of the preceding steps.

C: Backtracking batch number node program

As shown in Figure 9, the implementation steps of the reverse traceability batch number node program are as follows:

Step S501: Enter the code of the company to be checked and the batch number to be checked.

Step S502: Query whether the batch number to be checked is a manufacturing batch number.

Step S503: In step S502, if the identification data is a manufacturing lot number, it is further judged whether there is a parent manufacturing lot number matching the manufacturing lot number in the database.

Step S504: if there is a parent manufacturing lot number matching the manufacturing lot number in the database, a manufacturing type manufacturing lot number sub-node is generated based on the parent manufacturing lot number; if there is no matching manufacturing lot number in the database When the mother manufacturing lot number is used, a manufacturing type manufacturing lot number child node is generated based on the manufacturing lot number.

Step S505 : Query the designated incoming/outgoing purchase batch number, the source document of the original production source order, and the return document. In detail, step S504 is used to generate the manufacturing lot number of the node and the source manufacturing order of the parent manufacturing lot number or the original production of the manufacturing lot number to query the matching source documents, and calculate the records on the source documents. The number of the batch number to be checked.

Step S506: Find out all the suppliers who purchase the batch number to be checked. Specifically, in step S502, if the identification data is not the manufacturing batch number, the database is queried to see if there is a supply object matching the identification data.

Step S507: Check whether the supplier is a company in the supply chain system. Specifically, in step S506, if there is the supply object that matches the identification data in the database, it is then judged whether the supply object is a company role, and when the supply object is a company role , which generates a vendor-type supplier child node, which can further perform other supply chain traceability operations; when the supply object is not a company role, a vendor-type vendor leaf node is generated.

Next, read the relevant purchase slips and return slips respectively, and calculate the quantity of the batch number to be checked recorded on the slips.

Step S508: After step S505 or in step S506, when all the supply objects matching the identification data are processed, return the traceability results of the preceding steps.

D: Retrospective manufacturing batch number node program

As shown in Figure 10, the implementation steps of the retrospective manufacturing batch number node program are as follows:

Step S601: Enter the code of the company to be checked and the batch number to be checked.

Step S602: Inquire about all the processes of the batch number to be checked.

Step S603: In step S602, if the process matching the identification data exists in the database, a process type lot number process leaf node is generated. Furthermore, the reverse tracking module 42 is further sorted according to the steps of the manufacturing process.

Step S604 : query the matching transfer orders based on the batch number to be checked and the source system related to the process obtained in step S603 and the batch number to be checked, and calculate the quantity of the batch numbers to be checked recorded on the transfer orders.

Step S605 : In step S602 , after processing all the processes matching the identification data, query the database for the source control order to which the identification data belongs, and generate a self-made type control order sub-node.

Step S606: Determine whether there is a related material transfer order for the source control order.

Step S607: In step S606, when there is a material transfer order related to the manufacturing order, calculate the quantity of the batch number to be checked recorded on the material transfer order;

Step S608: In step S606, when there is no related material transfer order in the source control order, calculate the quantity of the lot number to be checked recorded on the source control order.

E: Reverse traceability order node program

As shown in Figure 11, the implementation steps of the reverse traceability order node program are as follows:

Step S701: Enter the code of the company to be checked and the order number to be checked.

Step S702: Query all related picking lists of source orders matching the order number to be checked, and then extract all batch numbers included in the found picking lists.

Step S703: In step S702, if there is a picking list and a picking lot number associated with the identification data in the database, a picking type lot number sub-node is generated.

Step S704: Query the matching picking list and/or return list with the receiving batch number obtained in step S703 and the source system order related to the receiving batch number, and calculate the number of the pending order number recorded on the receipt. .

Step S705: temporarily store the node, and return to step S702.

Step S706: In step S702, after processing all the picking lists and the picking batch numbers associated with the identification data, the traceability results are returned.

In addition, the child nodes and the leaf nodes respectively established by the backtracking module 42 and the backtracking module 43 respectively establish a connection relationship with the backtracking node. The procedures disclosed above are only representative examples to illustrate the functions of the preferred embodiment of the present invention, and it does not mean that the preferred embodiment can only perform the traceability methods listed above, nor does it mean that there is an inevitable relationship between the procedures. order of execution.

Accordingly, the user can use the traceability node, child node and/or leaf node obtained by the operation to quickly search for the cross-plant/farm data to be queried, as a basis for judging food safety.

The resource management system 50 is used for water resource management and reuse, green energy management, agricultural waste or sewage treatment. In this embodiment, the resource management system 50 includes a water purification and recovery device and a green energy device. The water purification and recovery device is used to filter and/or remove pollutants such as fish manure in the water, and make fertilizers. The filtered water is recycled and reused to reduce resource waste. The green energy device can cooperate with an intelligent (AI) solar energy storage system to store electricity during off-peak hours to reduce electricity costs.

10: Platform 20: Production and sales management system 21: Data Management Database 22: Invoicing management database 23: Job Management Database 24: Financial Management Database 30: Production Monitoring System 31: Sensor 40: Supply Chain Traceability Management Product Footprint Management System 41: Product Footprint Module 42: Retrospective module 43: Traceability module 44: Product Footprint Database 50: Resource Management System

FIG. 1 is a system block diagram of a preferred embodiment of the present invention. FIG. 2 is a flowchart of the root node procedure and the node type confirmation procedure executed by the traceback module according to a preferred embodiment of the present invention. FIG. 3 is a flow chart of a batch number tracing program according to a preferred embodiment of the present invention. FIG. 4 is a flow chart of a process of tracing back the manufacturing lot number node according to a preferred embodiment of the present invention. FIG. 5 is a flow chart of a program of tracing back the batch number node according to a preferred embodiment of the present invention. FIG. 6 is a flow chart of a traceability order node program according to a preferred embodiment of the present invention. FIG. 7 is a flowchart of the root node procedure and the node type confirmation procedure executed by the backtracking module according to a preferred embodiment of the present invention. FIG. 8 is a flow chart of a batch number retrospective program according to a preferred embodiment of the present invention. FIG. 9 is a flow chart of a reverse batch number node program according to a preferred embodiment of the present invention. FIG. 10 is a flow chart of a process of retrospecting the manufacturing lot number node according to a preferred embodiment of the present invention. FIG. 11 is a flowchart of a reverse traceability order node program according to a preferred embodiment of the present invention.

10: Platform

20: Production and sales management system

21: Data Management Database

22: Invoicing management database

23: Job Management Database

24: Financial Management Database

30: Production Monitoring System

31: Sensor

40: Supply Chain Traceability Management Product Footprint Management System

41: Product Footprint Module

42: Retrospective module

43: Traceability module

44: Product Footprint Database

50: Resource Management System

Claims (8)

A supply chain traceability management method for agricultural, fishery and animal husbandry industry products, comprising: receiving identification data representing a product; wherein the identification data includes the code of the company to be checked, the batch number to be checked and the order number to be checked; from one or more databases Find at least one first data, second data and/or third data matching the identification data; wherein, the first data includes company code data and inventory data; the second data includes source documents and return documents , the source documents include purchase orders, material picking orders, out-of-consignment purchase orders, shippers, sales orders, storage orders, transfer orders, material transfer orders, and inventory transaction documents, and the return documents include return orders, material returns The third data includes the source manufacturing order, the receiving order and the batch number process data. The batch number process data includes the process, the manufacturing process, the manufacturing batch number, the mother manufacturing batch number, and the receiving batch number. The first data and/or the third data are recorded on the source document and the returned document respectively; the related recursive operation is performed on the first data, the second data and/or the third data to search and establish a The first data, the second data and/or the third data are linked to a traceability node; wherein, the traceability node may be, but not limited to, a batch number node, a manufacturing batch number node, a manufacturing order node, a batch number process node, a customer node, Supplier node, warehouse node or inventory node, and each node can be classified according to different types, and it is further connected with corresponding child nodes and/or leaf nodes; wherein, in the step of calculating the traceability node, more use A batch number tracing program traces the flow of the product. The batch tracing procedure includes the following steps: Step a1: Query all source documents matching the batch number to be checked; Step a2: When the source document is a purchase order, a warehouse receipt and/or Or in the case of an out-of-consignment purchase order, a purchase type batch number sub-node, a self-made type batch number sub-node and/or an out-consignment type batch number sub-node are respectively generated, and the quantity of the batch number recorded on the corresponding source document is calculated respectively; Step a3: When the source document is not a stock receipt, a stock receipt and/or a consignment receipt, check whether the batch number to be checked is a manufacturing batch number; Step a4: In step a3, if the batch number to be checked is a manufacturing batch number , is to further judge whether the manufacturing lot number is related to the material transfer order in the database; step a5: in step a4, if there is the material transfer order matching the manufacturing lot number in the database, It generates a sub-node of the manufacturing batch number of the type in process, and then inquires out the material transfer order with the manufacturing lot number, and calculates the quantity of the batch number to be checked recorded on the material transfer order; step a6: in step a4 , if the material transfer order matching the manufacturing lot number does not exist in the database, a sub-node of the planning type manufacturing lot number is generated, and then the source system related to the manufacturing lot number in each database is read. order, and calculate the number of other batch numbers to be checked related to the source manufacturing order; step a7: in step a3, if the batch number to be checked is not a manufacturing batch number, it is then judged whether the identification data is related to an inventory transaction document related; step a8: in step a7, if there is the inventory transaction document related to the identification data in the database, an initial inventory type inventory leaf node is generated, and the record on the inventory transaction document is calculated. The quantity of the batch number to be checked; if the inventory transaction document related to the identification data does not exist in the database, an inventory leaf node of an unknown inventory type is generated, and the inventory quantity of the product is calculated; among them, the purchase Type batch number child node, the self-made type batch number child node, the outsourced type batch number child node, the manufacturing batch number child node of the manufacturing type, the planning type manufacturing batch number child node, the initial inventory type inventory leaf node, and the unknown inventory type The inventory leaf nodes are respectively connected with the traceability node to establish a connection relationship with each other. A supply chain traceability management method for agricultural, fishery and animal husbandry industry products, comprising: receiving identification data representing a product; wherein the identification data includes the code of the company to be checked, the batch number to be checked and the order number to be checked; Find at least one first data, second data and/or third data matching the identification data from one or more databases; wherein, the first data includes company code data and inventory data; the second data The data includes source documents and return documents. The source documents include purchase orders, material picking orders, out-of-consignment purchase orders, shippers, sales orders, storage orders, transfer orders, material transfer orders, and inventory transaction documents. The return Documents include return order, material return order, consignment return order and sales return order; the third data includes source manufacturing order, requisition order and batch number process data, the batch number process data includes process, process, manufacturing batch number, mother manufacturing Lot number, receiving lot number, the source document and the return document respectively record the first data and/or the third data; the first data, the second data and/or the third data are related and returned operation to search for and establish a traceability node that has a connection relationship with the first data, the second data and/or the third data; wherein, the traceability node may be, but not limited to, a batch number node, a manufacturing batch number node, a manufacturing order node, Lot number process node, customer node, supplier node, warehouse node or inventory node, and each of the nodes can be classified according to different types, and it is further connected with corresponding child nodes and/or leaf nodes; wherein, when calculating the traceability In the node step, a traceability manufacturing lot number node program is used to trace the flow direction of the product. The traceability manufacturing lot number node program includes the following steps: Step b1: Query the database whether there is a process matching the identification data; step b2: In step b1, if there is the process matching the identification data in the database, a process type batch number process leaf node is generated and sorted according to the process of the process; The process and the source system related to the batch number to be checked are inquired about the matching transfer order, and the quantity of the batch number to be checked recorded in the transfer order is calculated; step b3: In step b1, all identification data related to the identification data are processed. After matching the manufacturing process, query the database to see if there is the inbound order and/or the out-of-consignment order that matches the identification data; step b4: In step b3, if the identification data exists in the database When matching the receipt document and/or the out-of-consignment receipt, confirm the document type, and respectively generate a receipt type batch number sub-node and/or An out-of-consignment type batch number sub-node, and calculates the quantity of the batch number to be checked recorded on the corresponding source document and/or return document; Step b5: In step b3, process all the batches matching the identification data. After the receipt and/or the out-of-consignment receipt, return the traceability result; wherein, the process type batch number process leaf node, the in-warehouse type batch number sub-node and the out-of-consignment type batch number sub-node are respectively and the traceability node each other establish a connection between them. A supply chain traceability management method for agricultural, fishery and animal husbandry industry products, comprising: receiving identification data representing a product; wherein the identification data includes the code of the company to be checked, the batch number to be checked and the order number to be checked; from one or more databases Find at least one first data, second data and/or third data matching the identification data; wherein, the first data includes company code data and inventory data; the second data includes source documents and return documents , the source documents include purchase orders, material picking orders, out-of-consignment purchase orders, shippers, sales orders, storage orders, transfer orders, material transfer orders, and inventory transaction documents, and the return documents include return orders, material returns The third data includes the source manufacturing order, the receiving order and the batch number process data. The batch number process data includes the process, the manufacturing process, the manufacturing batch number, the mother manufacturing batch number, and the receiving batch number. The first data and/or the third data are recorded on the source document and the returned document respectively; the related recursive operation is performed on the first data, the second data and/or the third data to search and establish a The first data, the second data and/or the third data are linked to a traceability node; wherein, the traceability node may be, but not limited to, a batch number node, a manufacturing batch number node, a manufacturing order node, a batch number process node, a customer node, Supplier node, warehouse node or inventory node, and each node can be classified according to different types, and it is further connected with corresponding child nodes and/or leaf nodes; wherein, in the step of calculating the traceability node, more use A traceable batch number node program traces the flow of the product, and the traceable batch number node program includes the following steps: Step c1: Inquire about all the use orders that use the identification information; Step c2: Continue with step c1, if there is the use order for the identification data in the database, then determine the type of the order, and Generate a sub-node of self-made receipt type order or a sub-node of out-of-consignment receipt type order, respectively query the source document and the return document that match the application order, and calculate the value recorded on the document. The number of the batch numbers to be checked; Step c3: Continuing with Step c1, after processing all the receiving orders for the identification data, check whether there is a sales object matching the identification data in the database; Step c4 : Continue to step c3, if there is the sales object matching the identification data in the database, then determine whether the sales object is a company role, and respectively generate a customer type customer sub-node or a customer type The customer leaf node, then inquires out the corresponding sales order and the sales return order, and calculates the quantity of the batch number to be checked recorded on the sales order and the sales return order; step c5: continue with step c3, process After finishing all the sales objects that match the identification data, further query the database to see if there is inventory data that matches the identification data; Step c6: Continue to Step c5, if there is a match to the identification data in the database When the inventory data matches, an inventory type warehouse leaf node will be generated; if the inventory data matching the identification data does not exist in the database, the traceability result will be returned; The order sub-node, the outsourced receipt type order sub-node, the customer-type customer sub-node, the customer-type customer leaf node, and the inventory-type warehouse leaf node respectively establish a connection relationship with the traceability node. A supply chain traceability management method for agricultural, fishery and animal husbandry industry products, comprising: receiving identification data representing a product; wherein the identification data includes the code of the company to be checked, the batch number to be checked and the order number to be checked; from one or more databases Find at least one first data, second data and/or third data matching the identification data; wherein, the first data includes company code data and inventory data; the second data The material includes source documents and return documents. The source documents include purchase orders, material picking lists, out-of-consignment purchase orders, shippers, sales orders, storage orders, transfer orders, material transfer orders, and inventory transaction documents. The return Documents include return order, material return order, consignment return order and sales return order; the third data includes source manufacturing order, requisition order and batch number process data, the batch number process data includes process, process, manufacturing batch number, mother manufacturing Lot number, receiving lot number, the source document and the return document respectively record the first data and/or the third data; the first data, the second data and/or the third data are related and returned operation to search for and establish a traceability node that has a connection relationship with the first data, the second data and/or the third data; wherein, the traceability node may be, but not limited to, a batch number node, a manufacturing batch number node, a manufacturing order node, Lot number process node, customer node, supplier node, warehouse node or inventory node, and each of the nodes can be classified according to different types, and it is further connected with corresponding child nodes and/or leaf nodes; wherein, when calculating the traceability In the node step, a traceability system is used to trace the flow direction of the product, and the traceability control node program includes the following steps: Step d1: Query the database whether there is a manufacturing batch number that matches the identification data; Step d2: In step d1, if there is the manufacturing lot number matching the identification data in the database, a manufacturing type manufacturing lot number sub-node is generated, and the manufacturing lot number and the source system order related to the lot number are queried For the matching transfer order, calculate the quantity of the lot number to be checked recorded on the transfer order; after processing all the manufacturing lot numbers that match the identification data, return the traceability result; among them, the manufacturing type manufacturing The batch number sub-node establishes a connection relationship with the traceability node. A supply chain traceability management method for agricultural, fishery and animal husbandry industry products, comprising: receiving identification data representing a product; wherein the identification data includes the code of the company to be checked, the batch number to be checked and the order number to be checked; Find at least one first data, second data and/or third data matching the identification data from one or more databases; wherein, the first data includes company code data and inventory data; the second data The data includes source documents and return documents. The source documents include purchase orders, material picking orders, out-of-consignment purchase orders, shippers, sales orders, storage orders, transfer orders, material transfer orders, and inventory transaction documents. The return Documents include return order, material return order, consignment return order and sales return order; the third data includes source manufacturing order, requisition order and batch number process data, the batch number process data includes process, process, manufacturing batch number, mother manufacturing Lot number, receiving lot number, the source document and the return document respectively record the first data and/or the third data; the first data, the second data and/or the third data are related and returned operation to search for and establish a traceability node that has a connection relationship with the first data, the second data and/or the third data; wherein, the traceability node may be, but not limited to, a batch number node, a manufacturing batch number node, a manufacturing order node, Lot number process node, customer node, supplier node, warehouse node or inventory node, and each of the nodes can be classified according to different types, and it is further connected with corresponding child nodes and/or leaf nodes; wherein, when calculating the traceability In the step of the node, a reverse tracking batch number node program is used to trace the flow direction of the product. The reverse tracking batch number node program includes the following steps: step e1: query whether the identification data is a manufacturing batch number; step e2: in step e1, if When the identification data is the manufacturing lot number, it is further judged whether there is a parent manufacturing lot number matching the manufacturing lot number in the database, and a manufacturing type manufacturing lot number sub-node is generated based on the parent lot number or the manufacturing lot number, and then query and the batch number to be checked and the source document and the return document that match the parent manufacturing batch number or the source manufacturing order related to the manufacturing batch number, and calculate the quantity of the batch number to be checked recorded on the source document and the return document; Step e3: In step e1, if the identification data is not a manufacturing batch number, then inquire whether there is a supply object matching the identification data in the database; Step e4: In step e3, if there is the supply object matching the identification data in the database, it is further determined whether the supply object is a company role, and a vendor type supplier child is generated respectively. node or a manufacturer type supplier leaf node, and read the corresponding purchase order and return order respectively, and calculate the quantity of the batch number to be checked recorded on the purchase order and the return order; step e5: in step e2 or in step e2 Step e4 returns the traceability result after processing all the supply objects matching the identification data; wherein, the manufacture type manufacturing lot number sub-node, the manufacturer type supplier sub-node and the manufacturer type supplier leaf node are A connection relationship is established with the traceability nodes respectively. A supply chain traceability management method for agricultural, fishery and animal husbandry industry products, comprising: receiving identification data representing a product; wherein the identification data includes the code of the company to be checked, the batch number to be checked and the order number to be checked; from one or more databases Find at least one first data, second data and/or third data matching the identification data; wherein, the first data includes company code data and inventory data; the second data includes source documents and return documents , the source documents include purchase orders, material picking orders, out-of-consignment purchase orders, shippers, sales orders, storage orders, transfer orders, material transfer orders, and inventory transaction documents, and the return documents include return orders, material returns The third data includes the source manufacturing order, the receiving order and the batch number process data. The batch number process data includes the process, the manufacturing process, the manufacturing batch number, the mother manufacturing batch number, and the receiving batch number. The first data and/or the third data are recorded on the source document and the returned document respectively; the related recursive operation is performed on the first data, the second data and/or the third data to search and establish a The first data, the second data and/or the third data are linked to a traceability node; wherein, the traceability node may be, but not limited to, a batch number node, a manufacturing batch number node, a manufacturing order node, a batch number process node, a customer node, Supplier node, warehouse node or inventory node, each of which can be classified according to different types, and is further connected with corresponding child nodes and/or leaf nodes respectively; Wherein, in the step of calculating the traceability node, a reverse traceability order node program is used to trace the flow direction of the product, and the reverse traceability order node program includes the following steps: Step f1: Query whether the database exists with the identification data All related picking lists of the matching source order, and then extract all batch numbers contained in the found picking list; Step f2: In step f1, if there is a relationship with the identification data in the database When the requisition list is generated, a sub-node of the requisition type batch number is generated, and the requisition list and the return list are read, and the quantity of the pending order number recorded on the pick list and the return list is calculated; After processing all the picking lists related to the identification data, return the traceability result; wherein, the sub-node of the batch number of the requisition type establishes a connection relationship with the traceability node. A supply chain traceability management method for agricultural, fishery and animal husbandry industry products, comprising: receiving identification data representing a product; wherein the identification data includes the code of the company to be checked, the batch number to be checked and the order number to be checked; from one or more databases Find at least one first data, second data and/or third data matching the identification data; wherein, the first data includes company code data and inventory data; the second data includes source documents and return documents , the source documents include purchase orders, material picking orders, out-of-consignment purchase orders, shippers, sales orders, storage orders, transfer orders, material transfer orders, and inventory transaction documents, and the return documents include return orders, material returns The third data includes the source manufacturing order, the receiving order and the batch number process data. The batch number process data includes the process, the manufacturing process, the manufacturing batch number, the mother manufacturing batch number, and the receiving batch number. The first data and/or the third data are recorded on the source document and the returned document respectively; the related recursive operation is performed on the first data, the second data and/or the third data to search and establish a The first data, the second data and/or the third data are linked to a traceability node; wherein, the traceability node may be, but not limited to, a batch number node, a manufacturing batch number node, a manufacturing order node, a batch number process node, Customer node, supplier node, warehouse node or inventory node, and each of the nodes can be classified according to different types, and it is further connected with corresponding child nodes and/or leaf nodes; wherein, the step of calculating the traceability node In the process, a reverse traceability manufacturing lot number node program is used to trace the raw materials and their batch numbers of the product. The reverse trace manufacturing lot number node program includes the following steps: Step g1: Query the database whether there is a process matching the identification data; Step g2: In step g1, if the process matching the identification data exists in the database, a process type batch number process leaf node is generated, and the transfer order is read respectively, and the transfer order is calculated. The number of the batch numbers to be checked recorded; step g3: in step g1, after processing all the manufacturing processes that match the identification data, query the database to which the identification data belongs to the source manufacturing order, and generate a self-made Type order sub-node; then, it is further judged whether the source order has a related staging transfer order; step g4: in step g3, when the source order has a related material staging transfer order, calculate the material staging transfer order The quantity of the batch number to be checked recorded above; when there is no related material transfer order in the source manufacturing order, calculate the quantity of the batch number to be checked recorded on the source manufacturing order; wherein, the process type batch number process leaf node And the self-made type command sub-nodes are respectively connected with the traceability nodes to establish a connection relationship with each other. A supply chain traceability management method for agricultural, fishery and animal husbandry industry products, comprising: receiving identification data representing a product; wherein the identification data includes the code of the company to be checked, the batch number to be checked and the order number to be checked; from one or more databases Find at least one first data, second data and/or third data matching the identification data; wherein, the first data includes company code data and inventory data; the second data includes source documents and return documents , the source documents include purchase orders, material picking orders, out-of-consignment purchase orders, shippers, sales orders, storage orders, transfer orders, material transfer orders, and inventory transaction documents, and the return documents include return orders, material returns Form, outsourced return form and sales return form; the third data includes source-making order, receipt and use Manufacturing order and batch number process data, the batch number process data includes process, manufacturing process, manufacturing batch number, parent manufacturing batch number, and receiving batch number, the source document and the return document respectively record the first data and/or the third data ; perform a recursive operation on the first data, the second data and/or the third data to search for and establish a traceability node that has a link relationship with the first data, the second data and/or the third data; Wherein, the traceability node may be, but not limited to, a batch number node, a manufacturing lot number node, a manufacturing order node, a batch number process node, a customer node, a supplier node, a warehouse node or an inventory node, and each of the nodes can be classified according to different types, and It is further connected with corresponding child nodes and/or leaf nodes respectively; wherein, in the step of calculating the traceability node, a reverse traceability batch number program is used to trace the flow direction of the product, and the reverse traceability batch number program includes the following steps: Step h1 : Query whether there are sales orders, stock receipts, out-of-consignment receipts and/or purchase orders that match the identification data in the database; Step h2: In step h1, if there is a match with the identification data in the database When there are matching sales orders, warehouse receipts, out-of-consignment purchase orders and/or purchase orders, a sales type batch number sub-node, a manufacturing type batch number sub-node, an out-of-consignment type batch number sub-node and/or a Purchase type batch number sub-node, then query the corresponding source document and/or the return document, and calculate the quantity of the batch number to be checked recorded on the source document and the return document; Step h3: In step h1, if When there are no sales orders, stock receipts, out-of-consignment receipts and/or receipts that match the identification data in the database, check whether the database is a manufacturing batch number; step h4: In step h3, if When the identification data is a manufacturing lot number, it is further judged whether the source manufacturing order related to the manufacturing lot number is related to the transfer order in the database; Step h5: If there is a manufacturing lot number related to the database in step h5 When the source order matches the transfer order, it will generate a sub-node of the manufacturing batch number of the type in process, then read the transfer order in each database, and calculate the batch number to be checked recorded on the transfer order Quantity; if the system does not exist in the database When the transfer order matches the source manufacturing order related to the manufacturing lot number, a sub-node of the manufacturing lot number of the project type is generated, and then the source manufacturing order matching the manufacturing lot number in each database is queried, and its quantity is calculated. ; Step h6: In step h3, if the identification data in the database is not a manufacturing batch number, it is then judged whether the identification data is related to an inventory transaction document; Step h7: In step h6, if the database When there is the inventory transaction document related to the identification data, an initial inventory type inventory leaf node is generated, and the quantity of the batch number to be checked recorded on the inventory transaction document is calculated; if the database does not exist When the inventory transaction document is associated with the identification data, an unknown inventory type inventory leaf node is generated, and the inventory quantity of the product is calculated; The batch number sub-node of the foreign type, the batch number sub-node of the purchase type, the manufacturing batch number sub-node of the manufacturing type, the manufacturing batch number sub-node of the planning type, the inventory leaf node of the initial inventory type and the inventory leaf node of the unknown inventory type are respectively related to the The traceability nodes establish connection relationships with each other.

Images