TW201905764A - Barcode consolidation system including a business unit barcode data server, a supplier barcode data server, a supplier electronic device, and a business unit electronic device - Google Patents

Barcode consolidation system including a business unit barcode data server, a supplier barcode data server, a supplier electronic device, and a business unit electronic device

Info

Publication number
TW201905764A
TW201905764A TW106121409A TW106121409A TW201905764A TW 201905764 A TW201905764 A TW 201905764A TW 106121409 A TW106121409 A TW 106121409A TW 106121409 A TW106121409 A TW 106121409A TW 201905764 A TW201905764 A TW 201905764A
Authority
TW
Taiwan
Prior art keywords
data
item
barcode
supplier
business unit
Prior art date
Application number
TW106121409A
Other languages
Chinese (zh)
Other versions
TWI643132B (en
Inventor
程福堂
林世章
Original Assignee
優賀普股份有限公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 優賀普股份有限公司 filed Critical 優賀普股份有限公司
Priority to TW106121409A priority Critical patent/TWI643132B/en
Application granted granted Critical
Publication of TWI643132B publication Critical patent/TWI643132B/en
Publication of TW201905764A publication Critical patent/TW201905764A/en

Links

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Cash Registers Or Receiving Machines (AREA)

Abstract

A barcode consolidation 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 can link the stored supplier item data with the business unit item data stored in the business unit barcode data server. The supplier barcode data server is further capable of obtaining, by comparison, the correct number of units of the commodity item supplied by the supplier in the business unit according to the minimum unit of measurement of the business unit and the package level information of the commodity item provided by the supplier. Finally, the linked and calculated linked data files are transmitted to the business unit barcode data server for storage using data exchange such as mail or FTP.

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.

由於我國近年發生心臟支架、人工水晶體、骨釘、骨板等高風險植入式醫療器材未經許可擅自輸入、仿冒及擅改製造日期等情事,消費者端急需有上市後有效識別醫療器材之工具以限縮非法產品流通範圍。故本國FDA則參考國際醫療器材管理趨勢,於102年啟動醫療器材單一識別系統(Unique Device Identification System,以下簡稱UDI)研究工作,以加強醫療器材於使用端快速識別,因此FDA除了著手醫療器材單一識別系統資訊管理平台建置,亦須加強醫療器材藥商對於UDI單一識別系統之了解,提升其導入UDI系統之意願。期能協助醫療器材使用端快速查詢產品來源,避免誤用,保護消費者安全;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. Can assist medical device users to quickly query product sources, avoid misuse and protect consumer safety;

在目前的條碼使用,最常碰到以下問題: 1. 在不同營業單位內的商品品項,即使具有相同料號,但由於因為管理規格不同,故對應的條碼就會不同; 2. 由於各營業單位的庫存系統內,所設定之管理的最小單位不同,因此即使讀取相同的條碼,當在不同營業單位時,會因為管理單位不同,所讀取出來的數量與實際數量不同;例如,當在製造商的庫存是以箱管理時,當讀取一個外箱條碼是代表一箱時,若是另一個使用者的庫存是以盒管理時,則會讀到一個外箱條碼代表的是10盒,由這明顯可知,同一個條碼於不同對象(供應商或是營業單位)時,所得出的讀取資訊會因不同而產生混亂; 3. 若是各營業單位能夠自行建立條碼資料庫,也許能夠解決上述問題,但各營業單位自行建立條碼資料庫,通常無法通行於各供應鏈之間,而且同一條碼在供應商中及在營業單位所代表的品項代號、規格描述及包裝數量,往往無法共用,所建立的條碼資料庫往往也不會進行業界共享,因此上述問題始終無法全面性的解決。In the current bar code use, the following problems are most frequently encountered: 1. Even if the product items in different business units have the same item number, the corresponding bar code will be different because of different management specifications; In the inventory system of a business unit, the minimum unit of management is set differently, so even if the same bar code is read, when it is in different business units, the number read out is different from the actual quantity because of the management unit; for example, When the manufacturer's inventory is managed by the box, when reading a box barcode is a box, if another user's inventory is managed by a box, then a box barcode is read to represent 10 Box, it is obvious that when the same barcode is used in different objects (suppliers or business units), the read information will be confused due to different reasons. 3. If each business unit can build a barcode database by itself, maybe Can solve the above problems, but each business unit establishes a barcode database by itself, usually cannot pass between supply chains, and the same barcode is in the supplier. Business unit represented by the product item code, quantity and packaging specifications describe, often can not be shared, established barcode database industry were often not shared, so the above problem has not yet comprehensive solution.

由上述內容可知,如何能夠僅讀取一個條碼,就能夠依據不同營業單位的設定,自行將供應商所提供的商品品項於營業單位內的正確單位數轉換出來,因此本發明應為一最佳解決方案。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 includes at least one piece of supply item data and at least one piece of package item data, wherein the item of supply item data The system includes at least one item number, one item name and one specification code, and the package item data has packaging level information, and The supply commodity item data represents a commodity item provided by a supplier; a supplier data exchange 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 connected to the supplier data storage module and the supplier data exchange module for linking the supplier material number data file with the business unit material number data file; The conversion module is connected to the data corresponding connection module and the supplier data exchange module, and can be configured according to the minimum measurement unit of the business unit item data and the package level information of the package detail item. Comparing the correct number of units of the goods provided by the supplier in the business unit, and storing the data after the comparison with the pen as a linked data file, and transmitting to the data exchange module through the supplier The business unit barcode data server; a supplier electronic device, which has a barcode collection software connected to the supplier barcode data server, and the The code collection soft system includes: a login module for logging in with the vendor account and connecting with the provider barcode data server; a specification search module is connected to the login module. The specification search module can search for one of the supply item items in the shared server platform according to one or more of the item number, the specification code, and the specification code, and each of the supply items The 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 represented by the searched supply item data. Information; a code reading and decoding module is connected with the specification search module, and is used for reading 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 to the specification search module, and is configured to set a content included in the commodity item represented by the searched supply item data. The quantity of the contents; a package detailing data creation and uploading module is connected with the login module, the specification search module, the packaging level setting module, the barcode reading and decoding module and the quantity setting module, Establishing and uploading the package details to the supplier barcode data server, and linking the package details to the searched supply item data, wherein the package detail data includes at least a packaging level Information, international bar code, international bar code containing information, content quantity; a business unit electronic device, which has a bar code reading software connected with the business unit bar code data server, and the bar code reading soft system includes A login module is used to log in using the business unit account and is connected to the business unit barcode data server; a code reading module is connected to the login module for reading The international bar code on the commodity item provided by the supplier, and can search for the product in the bar code data server of the business unit according to the read international bar code The correct number of units in the business unit.

更具體的說,所述供應商品項資料更包含有一供應商統編、一供應商名稱及一規格碼說明。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.

有關於本發明其他技術內容、特點與功效,在以下配合參考圖式之較佳實施例的詳細說明中,將可清楚的呈現。Other details, features, and advantages of the present invention will be apparent from the following description of the preferred embodiments.

請參閱第1~5圖,為本發明條碼統整系統之整體架構示意圖、供應商條碼資料伺服器之架構示意圖、營業單位條碼資料伺服器之架構示意圖、條碼收集軟體之架構示意圖及條碼讀取軟體之架構示意圖,由圖中可知,該院內解碼系統係包含一供應商條碼資料伺服器11、一營業單位條碼資料伺服器12、一內建有條碼收集軟體21之供應商電子裝置2及一內建有條碼讀取軟體31之營業單位電子裝置3,其中該供應商電子裝置2及該營業單位電子裝置3係能夠為手持智慧型裝置、桌上型電腦或是筆記型電腦。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.

而該供應商條碼資料伺服器11係包含有一供應商資料儲存模組111、一供應商資料交換模組112、一資料對應連結模組113及一資料轉換模組114,其中該供應商資料儲存模組111用以能儲存至少一個供應商料號資料檔,而該供應商料號資料檔至少包含有至少一筆的供應商品項資料及至少一筆的包裝細項資料,該供應商品項資料係至少包含有一供應商統編、一供應商名稱、一料號、一品名、一規格碼及一規格碼說明,且該包裝細項資料係具有包裝層級資訊(該包裝層級資訊係代表包裝的單位別,而該單位別係能夠為一個、一包、一盒、一箱或是一板),另外該供應商品項資料係代表一種由供應商提供的商品品項;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 Included is 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 pack, one box, one box or one board), and the supply item data represents a commodity item provided by the supplier;

其中該供應商資料交換模組112係用以能夠接收至少一個營業單位料號資料檔,並將接收之營業單位料號資料檔能夠透過該資料對應連結模組113與該營業單位料號資料檔進行連結,而該供應商資料交換模組112係能夠透過郵件(Mail)或是檔案傳輸協定(FTP)的方式與該營業單位條碼資料伺服器12進行資料傳輸與交換;The supplier data exchange module 112 is configured to receive at least one business unit item number data file, and the received business unit item number data file can pass the data corresponding link module 113 and the business unit item number data file. The connection is performed, and the supplier data exchange module 112 can transmit and exchange data with the business unit barcode data server 12 by means of mail or file transfer protocol (FTP);

其中該資料轉換模組114用以能夠依據該營業單位品項資料之最小計量單位別與該包裝細項資料之包裝層級資訊,進行比對出該供應商所提供的商品品項於該營業單位內的正確單位數,並將連結與筆比對後的資料儲存為一連結資料檔,再透過該供應商資料交換模組112傳輸至該營業單位條碼資料伺服器11。The data conversion module 114 is configured to compare the packaged level information of the package item data with the minimum measurement unit of the business item item data, and compare the product item provided by the supplier to the business unit. The correct number of units is stored, and the data after the link is compared with the pen is stored as a linked data file, and then transmitted to the business unit barcode data server 11 through the supplier data exchange module 112.

而該營業單位條碼資料伺服器12係包含一營業單位資料儲存模組121及一營業單位資料交換模組122,其中該營業單位資料儲存模組121用以能儲存至少一個營業單位料號資料檔及至少一個的連結資料檔,而該營業單位料號資料檔至少包含有至少一筆的營業單位品項資料,而該營業單位品項資料係至少包含有一營業單位統編、一營業單位名稱、一料號、一品名、一規格碼、一規格碼說明及一最小計量單位別;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 Item number, first product name, one specification code, one specification code description and one minimum measurement unit;

且該營業單位資料交換模組122用以將營業單位料號資料檔進行傳輸,並能夠接收至少一個的連結資料檔,其中該營業單位資料交換模組122係能夠透過郵件(Mail)或是檔案傳輸協定(FTP)的方式與該供應商條碼資料伺服器11進行資料傳輸與交換。The business unit data exchange module 122 is configured to transmit the business unit item data file and receive at least one linked data file, wherein the business unit data exchange module 122 is capable of transmitting mail or a file. The transfer protocol (FTP) is transmitted and exchanged with the vendor barcode data server 11.

而該供應商電子裝置2之條碼收集軟體21係包含一登入模組211、一規格搜尋模組212、一包裝層級設定模組213、一條碼讀取暨解碼模組214、一數量設定模組215、一攝影紀錄模組216、一包裝細項資料建立暨上傳模組217,其中該登入模組211係用以使用一供應商帳號進行登入,並與該共用伺服器平台1進行連線,而該規格搜尋模組212能夠依據料號、規格碼、規格碼說明之其中之一或是兩個以上的資料於該共用伺服器平台1中進行搜尋出其中一個供應商品項資料,而每一個供應商品項資料係用以代表一種具有國際條碼的商品品項;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 vendor account, and is connected to the shared server platform 1, The specification search module 212 can search for one of the supply item items in the shared server platform 1 according to one or more of the item number, the specification code, and the specification code, and each of the items is provided. The supply item data is used to represent a commodity item with an international bar code;

其中該包裝層級設定模組213用以將所搜尋出之供應商品項資料進行設定所代表的包裝層級資訊,而該條碼讀取暨解碼模組214係用以讀取該商品品項之國際條碼,並能夠解讀該國際條碼,以取得該國際條碼內含訊息,其中該國際條碼內含訊息係能夠為批號、效期或序號;The package level setting module 213 is configured to set the package level information represented by the searched product item data, and the bar code reading and decoding module 214 is configured to read the international bar code of the product item. And being able to interpret the international bar code to obtain the information contained in the international bar code, wherein the international bar code contains the message system can be a batch number, a validity period or a serial number;

其中該數量設定模組215係用以設定所搜尋出之供應商品項資料所代表的商品品項內所包含的內容物數量,而該攝影紀錄模組216用以將所搜尋出之供應商品項資料所代表的商品品項進行拍攝,並儲存為至少一個影像檔,其中該影像檔係能夠為圖片或是影片;The quantity setting module 215 is configured to set the quantity of the content included in the commodity item represented by the searched supply item data, and the photographic record module 216 is configured to use the searched supply item. The product item represented by the data is taken and stored as at least one image file, wherein the image file can be a picture or a movie;

其中該包裝細項資料建立暨上傳模組217用以建立暨上傳該包裝細項資料至該共用伺服器平台1、並使該包裝細項資料能夠與所搜尋出之供應商品項資料進行連結,其中該包裝細項資料係至少包含有包裝層級資訊、國際條碼、國際條碼內含訊息、內容物數量及影像檔。The package detail data creation and uploading module 217 is configured to create and upload the package detail data to the shared server platform 1, and enable the package detail data to be linked with the searched supply item data. The package details include at least package level information, international bar code, international bar code information, content quantity and image file.

而該營業單位電子裝置3之條碼讀取軟體31係包含一登入模組311及一條碼讀取模組312,其中該登入模組311用以使用該營業單位帳號進行登入,並與該共用伺服器平台1進行連線,而該條碼讀取模組312用以讀取該供應商所提供的商品品項上的國際條碼,並能夠依據所讀取之國際條碼於該共用伺服器平台1中搜尋出該商品品項於該營業單位內的正確單位數。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 the shared server is used. The bar code reading module 312 is configured to read the international bar code on the product item provided by the supplier, and can be in the shared server platform 1 according to the read international bar code. Search for the correct number of units of the item in the business unit.

如第6圖所示,能夠由供應商上傳該供應商品項資料至該共用伺服器平台1,或是由該共用伺服器平台1協助供應商建立資料,而該供應商品項資料係至少包含有一供應商統編、一供應商名稱、一料號、一品名、一規格碼及一規格碼說明,而該規格碼是用以定義商品品項是屬於哪一種類別的物品,例如001是代表藥品、002是代表醫材…等等設定,而規格碼說明則是用以說明規格碼所代表的意義;As shown in FIG. 6, the supply commodity item data can be uploaded by the supplier to the shared server platform 1, or the shared server platform 1 can assist the supplier to establish the data, and the supply commodity item data includes at least one The supplier's editor, a supplier name, a material number, a product name, a specification code, and a specification code description, and the specification code is used to define which category the commodity item belongs to, for example, 001 is a representative drug. 002 is a representative of medical materials, etc., and the specification code description is used to explain the meaning represented by the specification code;

而當建立完供應商品項資料之後,如第7A圖所示,供應商能夠透過該供應商電子裝置2之條碼收集軟體21上所提供的軟體介面210進行建立包裝細項資料,因此先進行登入後,如第7B圖所示,則輸入料號以進行搜尋相關的供應商品項資料,如圖中所示,則能夠搜尋到已建立的供應商品項資料,之後再選擇要收集條碼的規格(選擇規格碼為002的資料);After the provision of the supply item data, as shown in FIG. 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 the login is performed first. After that, as shown in FIG. 7B, the item number is input to search for related supply item data, as shown in the figure, the found supply item data can be searched, and then the specification of the barcode to be collected is selected ( Select the data with the specification code 002);

之後,如第7C及7D圖所示,則能夠選擇包裝層級(選擇Bag)並拍攝商品品項的外觀,最後如第7E圖所示,進行讀取商品品項上的國際條碼,並收集條碼及內含的訊息,並將該條碼及內含的訊息與規格碼及包裝層級資訊進行連結,並再輸入該商品品項的最小數量(數量輸入為10),最後儲檔以形成為一包裝細項資料,而該包裝細項資料的資料格式如第8圖所示。Then, as shown in Figures 7C and 7D, it is possible to select the packaging level (select Bag) and capture the appearance of the product item, and finally, as shown in Fig. 7E, read the international barcode on the item and collect the barcode. And the included 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 input is 10), and finally store the file to form a package. The detailed information, and the data format of the package details is shown in Figure 8.

另外,如第9圖所示,營業單位能夠上傳該營業單位品項資料至該共用伺服器平台1,或是由該共用伺服器平台1協助營業單位建立資料,而該營業單位品項資料係至少包含有一營業單位統編、一營業單位名稱、一料號、一品名、一規格碼、一規格碼說明及一最小計量單位別(圖中未示),而該規格碼是用以定義商品品項是屬於哪一種類別的物品,例如001是代表藥品、002是代表醫材…等等設定,而規格碼說明則是用以說明規格碼所代表的意義。In addition, as shown in FIG. 9, the business unit can upload the business unit item data to the shared server platform 1, or the shared server platform 1 assists the business unit to establish data, and the business unit item data is At least one business unit editor, one business unit name, one item number, one product name, one specification code, one specification code description and one minimum measurement unit (not shown), and the specification code is used to define the product The item belongs to which category of items, for example, 001 is a representative drug, 002 is a representative medical material, etc., and the specification code description is used to explain the meaning represented by the specification code.

而當該供應商料號資料檔與該營業單位料號資料檔建立完成後,則能夠由該資料對應連結模組13將兩者進行連結,如第10圖所示,則會將營業單位的規格碼與供應商的規格碼進行如第10圖所示的連結,而該供應商所提供之商品品項上的條碼則能夠與該營業單位的規格碼與供應商的規格碼進行關聯,另外將營業單位的規格碼與供應商的規格碼連結,除了能夠透過共用伺服器平台1處理之外,亦能夠條碼收集軟體21或是條碼讀取軟體31進行連結處理;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 in addition to being processed by the shared server platform 1, the barcode collection software 21 or the barcode reading software 31 can also be connected;

因此若是當營業單位掃描一商品品項上的條碼為4710000112332時,該條碼讀取軟體31則會先到該共用伺服器平台1進行搜尋相關的資料,並能找出如第8圖所示的包裝細項資料,並再由該包裝細項資料再找到如第6圖所示的供應商品項資料,更由於如第10圖所示的連結,故能夠輕易找出比對的關聯性(C01-001對A01-001),但如圖中所示,C01-001的最小計量單位別為盒(BOX),但由第8圖所示,條碼為4710000112332的包裝層級為Carton,因此必須透過轉換以判斷出營業單位的真實數量為10盒;Therefore, if the business unit scans the barcode on a commodity item to 4710000112332, the barcode reading software 31 first searches the shared server platform 1 for the relevant information, and can find out as shown in FIG. Packing the detailed information, and then finding the supply item data as shown in Figure 6 by the package details, and because of the link as shown in Figure 10, it is easy to find the correlation (C01). -001 pairs A01-001), but as shown in the figure, the minimum unit of measurement for C01-001 is Box (BOX), but as shown in Figure 8, the package level of 4710000112332 is Carton, so it must be converted. To determine the actual number of business units is 10 boxes;

而上述提到的真實數量判斷則會依據不同營業單位自行設定的最小計量單位別而有所改變,因此最小計量單位別的設定與包裝層級資訊是本申請案重要的技術特徵。The actual quantity judgment mentioned above will be changed according to the minimum unit of measurement set by different business units. Therefore, the setting of the minimum unit of measurement and the information of the packaging level are important technical features of the present application.

本發明所提供之條碼統整系統,與其他習用技術相互比較時,其優點如下: (1) 本發明能夠透過最小計量單位別與包裝層級資訊的設定,讓營業單位能夠僅讀取一個條碼,就可依據不同營業單位之最小計量單位別的設定,自行將供應商所提供的商品品項於營業單位內的正確單位數轉換出來。 (2) 本發明能夠解決不同對象讀取同一個條碼時,所得出的讀取資訊會因不同而產生的混亂。The bar code integration system provided by the present invention has the following advantages when compared with other conventional technologies: (1) The present invention enables the business unit to read only one bar code by setting the minimum measurement unit and the package level information. According to the setting of the smallest unit of measurement of different business units, the correct number of units of the goods provided by the supplier in the business unit can be converted. (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.

1‧‧‧共用伺服器平台1‧‧‧Shared server platform

11‧‧‧供應商條碼資料伺服器11‧‧‧Supplier barcode data server

111‧‧‧供應商資料儲存模組111‧‧‧Supplier data storage module

112‧‧‧供應商資料交換模組112‧‧‧Supplier Data Exchange Module

113‧‧‧資料對應連結模組113‧‧‧ Data Correspondence Link Module

114‧‧‧資料轉換模組114‧‧‧Data Conversion Module

12‧‧‧營業單位條碼資料伺服器12‧‧‧Business unit barcode data server

121‧‧‧營業單位資料儲存模組121‧‧‧Business unit data storage module

122‧‧‧營業單位資料交換模組122‧‧‧Business unit data exchange module

2‧‧‧供應商電子裝置2‧‧‧Supplier electronic devices

21‧‧‧條碼收集軟體21‧‧‧Barcode collection software

210‧‧‧軟體介面210‧‧‧Software interface

211‧‧‧登入模組211‧‧‧ Login Module

212‧‧‧規格搜尋模組212‧‧‧Specification Search Module

213‧‧‧包裝層級設定模組213‧‧‧Package level setting module

214‧‧‧條碼讀取暨解碼模組214‧‧‧Barcode reading and decoding module

215‧‧‧數量設定模組215‧‧‧Quantity setting module

216‧‧‧攝影紀錄模組216‧‧‧Photography Recording Module

217‧‧‧包裝細項資料建立暨上傳模組217‧‧‧Package details creation and upload module

3‧‧‧營業單位電子裝置3‧‧‧Business unit electronic device

31‧‧‧條碼讀取軟體31‧‧‧Barcode reading software

311‧‧‧登入模組311‧‧‧ Login Module

312‧‧‧條碼讀取模組 312‧‧‧ barcode reading module

[第1圖]係本發明條碼統整系統之整體架構示意圖。 [第2圖]係本發明條碼統整系統之供應商條碼資料伺服器之架構示意圖。 [第3圖]係本發明條碼統整系統之營業單位條碼資料伺服器之架構示意圖。 [第4圖]係本發明條碼統整系統之條碼收集軟體之架構示意圖。 [第5]係本發明條碼統整系統之條碼讀取軟體之架構示意圖。 [第6]係本發明條碼統整系統之供應商品項資料示意圖。 [第7A圖]係本發明條碼統整系統之包裝細項資料建立示意圖。 [第7B圖]係本發明條碼統整系統之包裝細項資料建立示意圖。 [第7C圖]係本發明條碼統整系統之包裝細項資料建立示意圖。 [第7D圖]係本發明條碼統整系統之包裝細項資料建立示意圖。 [第7E圖]係本發明條碼統整系統之包裝細項資料建立示意圖。 [第8圖]係本發明條碼統整系統之包裝細項資料示意圖。 [第9圖]係本發明條碼統整系統之營業單位品項資料示意圖。 [第10圖]係本發明條碼統整系統之供應商與營業單位連結資料示意圖。[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.

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 unit of measurement; The module 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 supply a business data storage module for storing at least one supplier item number data file, wherein the supplier item number data file includes at least one supply item data and at least one package detail item, wherein the supply item The item data includes at least one item number, one item name and one specification code, and the package item data has a packaging level In addition, the supply item data represents a commodity item provided by the supplier; a supplier data exchange module is connected to the supplier data storage module for receiving at least one business unit item number A data link module is connected to the supplier data storage module and the supplier data exchange module for linking the supplier item number file to the business unit item number file A data conversion module is connected to the data corresponding connection module and the supplier data exchange module for being capable of being based on the minimum measurement unit of the business unit item data and the packaging level of the package item data Information, comparing the correct number of units of the goods provided by the supplier in the business unit, and storing the data after the comparison with the pen as a linked data file, and then transmitting the data through the supplier The group transmits to the business unit barcode data server; a supplier electronic device has a built-in bar code collection connected with the supplier barcode data server The barcode collection soft system includes: a login module for logging in with the vendor account and connecting with the provider barcode data server; a specification search module, and the login module The group is connected, and the specification search module can search for one of the supply item data in the shared server platform according to one or more of the item number, the specification code, and the specification code. Each of the supply 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 searched supply item data. Representing the packaging level information; a code reading and decoding module is connected with the specification search module, is used to read the international barcode of the commodity item, and can interpret the international barcode to obtain the international barcode A message setting module is connected to the specification search module for setting the commodity item represented by the searched supply item data. The number of contents contained in the package; a package detailing data creation and uploading module, and the login module, the specification search module, the packaging level setting module, the barcode reading and decoding module, and the quantity setting module Connected to establish and upload the package details to the supplier barcode data server, and enable the package details to be linked with the searched supply item data, wherein the package details are at least Including packaging level information, international bar code, international bar code containing information, content quantity; a business unit electronic device, has a bar code reading software connected with the business unit bar code data server, and the bar code reading The soft-receiving 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 is connected with the login module. It is used to read the international bar code on the commodity item provided by the supplier, and can be based on the international bar code read in the bar code data server of the business unit. Search for the correct number of units of the item in the business unit. 如請求項1所述之條碼統整系統,其中該供應商品項資料更包含有一供應商統編、一供應商名稱及一規格碼說明。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. 如請求項1所述之條碼統整系統,其中該營業單位品項資料更包含有一營業單位統編、一營業單位名稱及一規格碼說明。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. 如請求項1所述之條碼統整系統,其中該包裝層級資訊係代表包裝的單位別,而該單位別係能夠為一個、一包、一盒、一箱或是一板。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. 如請求項1所述之條碼統整系統,其中該條碼收集軟體更包含有一與該規格搜尋模組相連接之攝影紀錄模組,其中該攝影紀錄模組用以將所搜尋出之供應商品項資料所代表的商品品項進行拍攝,並儲存為至少一個影像檔,而該影像檔更包含於該包裝細項資料內。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. 如請求項5所述之條碼統整系統,其中該影像檔係能夠為圖片或是影片。The barcode integration system of claim 5, wherein the image file can be a picture or a movie. 如請求項1所述之條碼統整系統,其中該國際條碼內含訊息係能夠為批號、效期或序號。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. 如請求項1所述之條碼統整系統,其中該供應商電子裝置係能夠為手持智慧型裝置、桌上型電腦或是筆記型電腦。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. 如請求項1所述之條碼統整系統,其中該營業單位電子裝置係能夠為手持智慧型裝置、桌上型電腦或是筆記型電腦。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. 如請求項1所述之條碼統整系統,其中該供應商資料交換模組係能夠透過郵件或是檔案傳輸協定的方式與該供應商條碼資料伺服器進行資料傳輸與交換。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. 如請求項1所述之條碼統整系統,其中該營業單位資料交換模組係能夠透過郵件或是檔案傳輸協定的方式與該供應商條碼資料伺服器進行資料傳輸與交換。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. 如請求項1所述之條碼統整系統,其中該供應商資料交換模組係能夠透過郵件或是檔案傳輸協定的方式與該營業單位條碼資料伺服器進行資料傳輸與交換。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.
TW106121409A 2017-06-27 2017-06-27 Bar code alignment system TWI643132B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
TW106121409A TWI643132B (en) 2017-06-27 2017-06-27 Bar code alignment system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
TW106121409A TWI643132B (en) 2017-06-27 2017-06-27 Bar code alignment system

Publications (2)

Publication Number Publication Date
TWI643132B TWI643132B (en) 2018-12-01
TW201905764A true TW201905764A (en) 2019-02-01

Family

ID=65431564

Family Applications (1)

Application Number Title Priority Date Filing Date
TW106121409A TWI643132B (en) 2017-06-27 2017-06-27 Bar code alignment system

Country Status (1)

Country Link
TW (1) TWI643132B (en)

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
TW559721B (en) * 2002-05-09 2003-11-01 Hon Hai Prec Ind Co Ltd A system and method for managing inventory
US20030233293A1 (en) * 2002-06-13 2003-12-18 Michael Hsu Warehouse management system and method
CN103455614B (en) * 2013-09-09 2016-09-07 北京京东尚科信息技术有限公司 A kind of commodity that reduce paste the method for code check, Apparatus and system
TWI569223B (en) * 2015-08-27 2017-02-01 A bar code decoding system for medical supplies and its operation
TWM534382U (en) * 2016-06-22 2016-12-21 Ahop Co Ltd In-hospital decoding system for medical supplies

Also Published As

Publication number Publication date
TWI643132B (en) 2018-12-01

Similar Documents

Publication Publication Date Title
RU2670800C9 (en) Inter-system data interaction platform based on data tags and application method thereof
US20120037700A1 (en) Electronic device and method for image files with embedded inventory data
TWM548838U (en) Barcode integration system
CN106203919A (en) Run through the book keeping operation formula commodity counterfeit prevention source tracing method of supply chain
TWI569223B (en) A bar code decoding system for medical supplies and its operation
CN104217344B (en) Tag marker and commodity track of the whole process RFID label tag system
CN103559590A (en) Packaging method capable of observing inner commodity without unpacking and system thereof
US20120110543A1 (en) Application Store System for Supporting Development of Application Interoperated with Unified Device and Method for Managing Application Store
TWI643132B (en) Bar code alignment system
KR20190034185A (en) Component integration network system for selling parts using disassemble scrap car and method for using the same
JP2024019617A (en) Inventory management system
WO2023054537A1 (en) Production method and production system for non-fungible token, registration method and system for unique identifier, and production method for combination product
CA2740266C (en) Encoding of a bank transfer
TW202004588A (en) Method of managing inventory, method of searching inventory, server for managing inventory and server for searching inventory
WO2021124878A1 (en) Information processing method, information processing device, information processing program, and history reference program
KR100764089B1 (en) Tag recycling system enabling two-way interaction based on rfid/usn and method thereof
JP2014118259A (en) Information processor and program
CN113052701A (en) Tea transaction management system and transaction method based on block chain
JP2015101424A (en) Commodity inventory system
JP2005135309A5 (en)
JP2021131620A (en) Package traceability system
CN203786754U (en) Digital-verification anti-fake label
TWM516276U (en) Single identification decoding system for medical supplies
TWI628615B (en) Single identification decoding identification method for medical supplies
CN204791160U (en) A network remote prescription evaluation system