TWI643132B - Bar code alignment system - Google Patents

Abstract

A bar code integration system includes a business unit barcode data server, a supplier barcode data server, a supplier electronic device with built-in barcode collection software, and a business unit electronic device with built-in barcode reading software. The supplier barcode data server is capable of linking the stored supply item data with the business unit item data stored by the business unit barcode data server, and the supplier barcode data server is further capable of operating according to the business The minimum unit of measurement of the unit and the supplier provide the packaging level information of the commodity item, compare the correct number of units of the commodity item provided by the supplier in the business unit, and finally connect and calculate The linked data file is transmitted to the business unit barcode data server for storage by means of Mail or FTP data exchange.

Description

Bar code alignment system

The invention relates to a bar code integration system, in particular to a bar code code that compares a product item code provided by the supplier to a business item code corresponding to the business unit and converts the bar code corresponding to the correct unit number of the business unit. Integrate the system.

Because in recent years, high-risk implantable medical devices such as cardiac stents, artificial crystals, bone nails, and bone plates have been imported without authorization, counterfeiting, and tampering with manufacturing dates, consumers are in urgent need of effective identification of medical devices after listing. Tools to limit the circulation of illegal products. Therefore, the domestic FDA refers to the international medical equipment management trend, and started the research of the Unique Device Identification System (UDI) in 2003 to strengthen the rapid identification of medical equipment at the use end. Therefore, the FDA has to start with a single medical device. To identify the establishment of the system information management platform, it is also necessary to strengthen the medical device drug dealer's understanding of the UDI single identification system and enhance its willingness to introduce the UDI system. The medical equipment can be used to quickly query the source of the product to avoid misuse and protect consumer safety. In the current bar code use, the following problems are most frequently encountered: 1. The goods in different business units, even with the same item number However, because the management specifications are different, the corresponding barcodes will be different; 2. Since the minimum unit of management is set in the inventory system of each business unit, even if the same barcode is read, when in different business units , will be read out because of different management units The quantity is different from the actual quantity; for example, when the manufacturer's inventory is managed by the box, when reading one outer box barcode represents one box, if another user's stock is managed by box, it will read An outer box bar code represents 10 boxes. It is obvious that when the same bar code is used in different objects (suppliers or business units), the read information will be confused due to different reasons; 3. If it is a business unit The ability to create a barcode database by itself may solve the above problems, but each business unit establishes a barcode database on its own, which is usually not accessible between supply chains, and the product code represented by the same barcode in the supplier and in the business unit. The specification, the number of packages, and the number of packages are often not shared. The established barcode database is often not shared by the industry. Therefore, the above problems cannot always be solved comprehensively.

It can be known from the above that how to read only one bar code can convert the correct number of items in the business unit provided by the supplier according to the setting of different business units, so the present invention should be the most Good solution.

A barcode integration system includes a business unit barcode data server, comprising: a business unit data storage module, configured to store at least one business unit item number data file and at least one linked data file, and the business The unit item data file contains at least one business unit item data, and the business unit item data includes at least one item number, one item name, one specification code and one minimum unit of measurement; The group is connected to the business unit data storage module for transmitting the business unit item data file and capable of receiving at least one linked data file; a supplier barcode data server comprising a supplier data a storage module for storing at least one supplier item number file, wherein the supplier item number file contains at least one supply item Data and at least one package detail item, wherein the supply item data includes at least one item number, one item name and one specification code, and the package item item information has packaging level information, and the supply item item data representative A commodity item provided by a supplier; a supplier data exchange module connected to the supplier data storage module for receiving at least one business unit item number data file; The system is connected to the supplier data storage module and the supplier data exchange module for linking the supplier item number file with the business unit item number file; a data conversion module is associated with the The data corresponding link module and the supplier data exchange module are connected, and can be compared with the package level information of the package detail data according to the minimum measurement unit of the business unit item data. The correct number of units of the goods provided in the business unit, and the data after the comparison with the pen is stored as a linked data file, and then through the supply The data exchange module is transmitted to the business unit barcode data server; a supplier electronic device has a barcode collection software connected to the supplier barcode data server, and the barcode collection soft system includes: The module is used to log in with the supplier account and is connected to the provider barcode data server; a specification search module is connected to the login module, and the specification search module can be based on One or more of the item number, specification code, and specification code descriptions are used to search for one of the supply item data in the supplier barcode data server, and each supply item item data is used to represent A product item having an international bar code; a package level setting module is connected to the specification search module for setting the package level information represented by the searched supply item data; one code reading The cum decoding module is connected with the specification search module, and is used for reading the international barcode of the commodity item, and is capable of interpreting the international barcode Obtaining the information contained in the international barcode; a quantity setting module is connected to the specification search module, and is configured to set the quantity of the content included in the commodity item represented by the searched supply item data. ; a package of detailed data creation and upload module, Department And the login module, the specification search module, the package level setting module, the barcode reading and decoding module and the quantity setting module are connected to establish and upload the package detailed item data to the supplier barcode data servo And enabling the package item data to be linked with the searched supply item data, wherein the package item data includes at least package level information, international bar code, international bar code information, and content quantity; The business unit electronic device has a barcode reading software connected to the business unit barcode data server, and the barcode reading soft system includes a login module for using the business unit account to log in. And connecting with the bar code data server of the business unit; a code reading module is connected with the login module to read the international bar code on the commodity item provided by the supplier, and can The correct number of units of the commodity item in the business unit is searched for in the business unit barcode data server according to the read international barcode.

More specifically, the supply item data further includes a supplier editor, a supplier name, and a specification code description.

More specifically, the business unit item data further includes a business unit editor, a business unit name and a specification code description.

More specifically, the package level information represents a unit of packaging, and the unit can be one, one, one, one, or one.

More specifically, the barcode collection software further includes a photographic record module connected to the specification search module, wherein the photographic record module is configured to display the commodity items represented by the searched supply item data. The shooting is performed and stored as at least one image file, and the image file is further included in the package details.

More specifically, the image file can be a picture or a movie.

More specifically, the international barcode contains a message that can be a batch number, a validity period, or a serial number.

More specifically, the vendor electronic device can be a handheld smart device, a desktop computer, or a notebook computer.

More specifically, the business unit electronic device can be a handheld smart device, a desktop computer or a notebook computer.

More specifically, the supplier data exchange module is capable of transmitting and exchanging data with the provider barcode data server by means of mail or file transfer protocol.

More specifically, the business unit data exchange module is capable of transmitting and exchanging data with the provider barcode data server by way of mail or file transfer protocol.

More specifically, the supplier data exchange module is capable of data transmission and exchange with the business unit barcode data server by way of mail or file transfer agreement.

11‧‧‧Supplier barcode data server

111‧‧‧Supplier data storage module

112‧‧‧Supplier Data Exchange Module

113‧‧‧ Data Correspondence Link Module

114‧‧‧Data Conversion Module

12‧‧‧Business unit barcode data server

121‧‧‧Business unit data storage module

122‧‧‧Business unit data exchange module

2‧‧‧Supplier electronic devices

21‧‧‧Barcode collection software

210‧‧‧Software interface

211‧‧‧ Login Module

212‧‧‧Specification Search Module

213‧‧‧Package level setting module

214‧‧‧Barcode reading and decoding module

215‧‧‧Quantity setting module

216‧‧‧Photography Recording Module

217‧‧‧Package details creation and upload module

3‧‧‧Business unit electronic device

31‧‧‧Barcode reading software

311‧‧‧ Login Module

312‧‧‧ barcode reading module

[Fig. 1] is a schematic diagram of the overall architecture of the bar code integration system of the present invention.

[Fig. 2] is a schematic diagram showing the architecture of a supplier bar code data server of the bar code integration system of the present invention.

[Fig. 3] is a schematic structural diagram of a bar code data server of a business unit of the bar code integration system of the present invention.

[Fig. 4] is a schematic structural view of a bar code collection software of the bar code integration system of the present invention.

[5] is a schematic structural diagram of a bar code reading software of the bar code integration system of the present invention.

[6] is a schematic diagram of the supply item data of the barcode integration system of the present invention.

[Fig. 7A] is a schematic diagram showing the establishment of packaging details of the bar code integration system of the present invention.

[Fig. 7B] is a schematic diagram for establishing the package details of the barcode integration system of the present invention.

[FIG. 7C] FIG. 7 is a schematic diagram showing the establishment of packaging details of the barcode integration system of the present invention.

[Fig. 7D] is a schematic diagram for establishing the package details of the bar code integration system of the present invention.

[FIG. 7E] FIG. 7 is a schematic diagram showing the establishment of packaging details of the barcode integration system of the present invention.

[Fig. 8] is a schematic diagram of packaging details of the bar code integration system of the present invention.

[Fig. 9] is a schematic diagram of the product data of the business unit of the barcode integration system of the present invention.

[Fig. 10] is a schematic diagram of the link between the supplier and the business unit of the bar code integration system of the present invention.

Other details, features, and advantages of the present invention will be apparent from the following description of the preferred embodiments.

Please refer to FIG. 1 to FIG. 5 , which are schematic diagrams of the overall architecture of the barcode integration system, the architecture diagram of the supplier barcode data server, the architecture diagram of the business unit barcode data server, the architecture diagram of the barcode collection software and the barcode reading. The architecture diagram of the software, as shown in the figure, the in-hob decoding system includes a supplier barcode data server 11, a business unit barcode data server 12, a supplier electronic device 2 with a barcode collection software 21 and a The business unit electronic device 3 of the bar code reading software 31 is built therein, wherein the supplier electronic device 2 and the business unit electronic device 3 can be a handheld smart device, a desktop computer or a notebook computer.

The supplier barcode data server 11 includes a supplier data storage module 111, a supplier data exchange module 112, a data corresponding connection module 113, and a data conversion module 114, wherein the supplier data storage The module 111 is configured to store at least one supplier item data file, and the supplier item number data file includes at least one supply item item data and at least one package item item data, and the supply item item data is at least Contains a supplier's editor, a supplier name, a item number, a product name, a specification code, and a specification code description, and the package details information has package level information. (The package level information represents the unit of the package, and the unit can be one, one package, one box, one box or one board), and the supply item data represents a product provided by the supplier. The product data exchange module 112 is configured to be capable of receiving at least one business unit item number data file, and the received business unit item number data file can be transmitted through the data corresponding connection module 113 and the business unit material. The data file module is linked, and the supplier data exchange module 112 is capable of transmitting and exchanging data with the business unit barcode data server 12 by means of a mail or a file transfer protocol (FTP); The conversion module 114 is configured to compare the minimum measurement unit of the business unit item data with the package level information of the package item data, and compare the product items provided by the supplier to the business unit. The number of units is stored in the linked data file and transmitted to the business unit barcode data through the supplier data exchange module 112. Service 11.

The business unit barcode data server 12 includes a business unit data storage module 121 and a business unit data exchange module 122, wherein the business unit data storage module 121 is configured to store at least one business unit item number data file. And at least one linked data file, wherein the business unit item data file contains at least one business unit item data, and the business unit item data includes at least one business unit editor, one business unit name, and one a item number, a product name, a specification code, a specification code description, and a minimum measurement unit; and the business unit data exchange module 122 is configured to transmit the business unit item data file and receive at least one link data The file, wherein the business unit data exchange module 122 is capable of data transmission and exchange with the supplier barcode data server 11 by way of mail or file transfer protocol (FTP).

The barcode collection software 21 of the vendor electronic device 2 includes a login module 211, a specification search module 212, a package level setting module 213, a code reading and decoding module 214, and a quantity setting module. 215, a photographic record module 216, a package detail data creation and upload module 217, wherein the login module 211 is used to log in using a supplier account and is connected to the provider barcode data server 11. And the specification search module 212 can search for one of the supply item data in the supplier barcode data server 11 according to one or more of the item number, the specification code, and the specification code description. And each of the supply item data is used to represent a product item having an international bar code; wherein the package level setting module 213 is configured to set the packaged item information represented by the searched supply item item data, and The barcode reading and decoding module 214 is configured to read an international barcode of the commodity item, and can interpret the international barcode to obtain the information contained in the international barcode, wherein the country The barcode containing information can be a batch number, a validity period or a serial number; wherein the quantity setting module 215 is configured to set the quantity of the content contained in the commodity item represented by the searched supply item item data, and the quantity The photographic record module 216 is configured to capture the product item represented by the searched product item and store it as at least one image file, wherein the image file can be a picture or a movie; wherein the package item The data creation and uploading module 217 is configured to create and upload the package detail data to the supplier barcode data server 11, and enable the package detail data to be linked with the searched supply item data, wherein the package The detailed data includes at least package level information, international bar code, international bar code information, content quantity and image file.

The bar code reading software 31 of the business unit electronic device 3 includes a login module 311 and a code reading module 312, wherein the login module 311 is used to log in using the business unit account. And connecting with the business unit barcode data server 12, and the barcode reading module 312 is configured to read the international barcode on the commodity item provided by the supplier, and can be based on the read international barcode The business unit barcode data server 12 searches for the correct number of units of the commodity item in the business unit.

As shown in FIG. 6, the supply item data can be uploaded by the supplier to the supplier barcode data server 11, or the supplier barcode data server 11 can assist the supplier to establish the data, and the supply item data The system includes at least one supplier editor, a supplier name, a material number, a product name, a specification code, and a specification code, and the specification code is an item for defining which category the product item belongs to, for example, 001 is the representative drug, 002 is the representative medical material, etc., and the specification code description is used to explain the meaning of the specification code; and when the supply item data is established, as shown in Figure 7A, The supplier can establish the package details through the software interface 210 provided on the barcode collection software 21 of the supplier electronic device 2, so after logging in first, as shown in FIG. 7B, input the item number to perform the search. The supply item data, as shown in the figure, can search for the established supply item data, and then select the barcode specification (select the specification code 002); after that, As shown in Figures 7C and 7D, it is possible to select the packaging level (select Bag) and capture the appearance of the merchandise item. Finally, as shown in Fig. 7E, the international barcode on the merchandise item is read, and the barcode and the inclusion are collected. The message, and link the barcode and the included information with the specification code and the package level information, and then input the minimum quantity of the product item (the quantity is input as 10), and finally store the file to form a package detail item. The data format of the package details is shown in Figure 8.

In addition, as shown in FIG. 9, the business unit can upload the business unit item data to the business unit barcode data server 12, or the business unit barcode data server 12 assists the business unit to establish data, and the business unit The item data includes at least one business unit and one business unit. Name, a material number, a product name, a specification code, a specification code description, and a minimum measurement unit (not shown), and the specification code is an item for defining which category the commodity item belongs to, for example 001 is the representative drug, 002 is the representative medical material, etc., and the specification code description is used to explain the meaning of the specification code.

When the supplier item number file and the business unit item number file are completed, the data connection module 13 can be used to link the two, as shown in FIG. 10, the business unit will be The specification code and the supplier's specification code are linked as shown in Figure 10, and the barcode on the commodity item provided by the supplier can be associated with the specification code of the business unit and the supplier's specification code. The specification code of the business unit is linked with the specification code of the supplier, and can be processed by the supplier barcode data server 11 and the business unit barcode data server 12, and can also be performed by the barcode collection software 21 or the barcode reading software 31. Link processing; therefore, if the business unit scans the barcode on a product item to 4710000112332, the barcode reading software 31 first goes to the business unit barcode data server 12 to search for relevant information, and can find out Figure 8 shows the details of the package, and then the package details to find the supply item data as shown in Figure 6, but also because of the link shown in Figure 10, It is easy to find the correlation of the comparison (C01-001 vs. A01-001), but as shown in the figure, the smallest unit of measurement of C01-001 is box (BOX), but as shown in Fig. 8, the barcode is 4710000112332. The packaging level is Carton, so it is necessary to determine the actual quantity of the business unit through the conversion to 10 boxes; and the actual quantity judgment mentioned above will be changed according to the smallest unit of measurement set by different business units, so the minimum The setting of the measurement unit and the packaging level information are important technical features of this application.

The bar code integration system provided by the invention is compared with other conventional technologies, The advantages are as follows: (1) The invention can enable the business unit to read only one bar code through the setting of the minimum measurement unit and the package level information, and can independently supply the supplier according to the setting of the smallest measurement unit of different business units. The goods provided are converted into the correct number of units in the business unit. (2) The present invention can solve the confusion caused by different reading information when different objects read the same barcode.

The present invention has been disclosed in the above embodiments, and is not intended to limit the present invention. Any of those skilled in the art can understand the foregoing technical features and embodiments of the present invention without departing from the invention. In the spirit and scope, the scope of patent protection of the present invention is subject to the definition of the claims attached to the present specification.

Claims (12)

A bar code integration system includes: a business unit bar code data server, comprising: a business unit data storage module, configured to store at least one business unit item number data file and at least one linked data file, and the The business unit item data file contains at least one business unit item data, and the business unit item data includes at least one item number, one product name, one specification code and one minimum measurement unit, wherein the specification code is For the material number combined with the flow sequence; a business unit data exchange module is connected with the business unit data storage module for transmitting the business unit material data file and capable of receiving at least one linked data file A supplier barcode data server includes: a supplier data storage module for storing at least one supplier item number data file, and the supplier item number data file includes at least one supply item Information and at least one package detail item, wherein the supply item data includes at least one item number, one item name and one specification Wherein the specification code is generated by the item number combined with the flow sequence, and the package item data has package level information, and the supply item item data represents a commodity item provided by the supplier; a supplier data exchange The module is connected to the supplier data storage module for receiving at least one business unit item number data file; a data corresponding connection module is associated with the supplier data storage module and the supplier data exchange The module is connected to connect the supplier item number file with the business unit item number file; a data conversion module is connected with the data corresponding connection module and the supplier data exchange module And comparing the minimum measurement unit of the business unit item data with the package level information of the package detail item, and comparing the product item provided by the supplier to the business unit The number of units is determined, and the linked and compared data is stored as a linked data file, and then transmitted to the business unit barcode data server through the supplier data exchange module; a supplier electronic device has a built-in The provider bar code data server performs the bar code collection software, and the bar code collection soft system includes: a login module, which is used to log in using the vendor account and is connected with the provider bar code data server. a specification search module is connected to the login module, and the specification search module can be based on one of the item number, the specification code, the specification code, or two or more pieces of data on the supplier barcode. The data server searches for one of the supply item items, and each of the supplied item items is used to represent a product item having an international bar code; a package level setting module is connected to the specification search module. a package level information for setting up the searched supply item data; a code reading and decoding module is searched for the specification The group is connected to read the international barcode of the commodity item, and can interpret the international barcode to obtain the information contained in the international barcode; a quantity setting module is connected with the specification search module. For setting the quantity of the content contained in the commodity item represented by the searched supply item data; a package detailing data creation and uploading module, and the login module, the specification search module, and the packaging level The setting module, the bar code reading and decoding module and the quantity setting module are connected to establish and upload the package detail data to the supplier barcode data server, and enable the package detail data to be searched The supply item data is linked, wherein the package details include at least package level information, international bar code, international bar code information, and content quantity; a business unit electronic device has a built-in business unit Barcode data server for connection The code reading software system includes: a login module for using the business unit account to log in, and connecting with the business unit barcode data server; a code reading module, Connected to the login module, which is used to read the international barcode on the product item provided by the supplier, and can search for the product in the business unit barcode data server according to the read international barcode. The correct number of units in the business unit. The barcode integration system of claim 1, wherein the supply item data further includes a supplier editor, a supplier name, and a specification code description. The barcode integration system according to claim 1, wherein the business unit item data further comprises a business unit editor, a business unit name and a specification code description. The bar code integration system of claim 1, wherein the package level information represents a package unit, and the unit can be one, one package, one box, one box or one board. The barcode integration system of claim 1, wherein the barcode collection software further comprises a photographic record module coupled to the specification search module, wherein the photographic record module is configured to search for the supplied product item The product item represented by the data is taken and stored as at least one image file, and the image file is further included in the package details. The barcode integration system of claim 5, wherein the image file can be a picture or a movie. The bar code integration system of claim 1, wherein the international bar code contains a message system capable of a batch number, a validity period or a serial number. The barcode integration system of claim 1, wherein the vendor electronic device can be a handheld smart device, a desktop computer or a notebook computer. The bar code integration system of claim 1, wherein the business unit electronic device can be a handheld smart device, a desktop computer or a notebook computer. The barcode integration system of claim 1, wherein the supplier data exchange module is capable of transmitting and exchanging data with the provider barcode data server by means of an email or a file transfer protocol. The barcode integration system of claim 1, wherein the business unit data exchange module is capable of transmitting and exchanging data with the provider barcode data server by means of an email or a file transfer protocol. The barcode integration system of claim 1, wherein the supplier data exchange module is capable of transmitting and exchanging data with the business unit barcode data server by means of an email or a file transfer protocol.