JP2000285183A - WWW linked inventory information distributed management system and method - Google Patents

Abstract

(57) [Summary] [Problem] To automatically and simplify management work of stock information and the like of a plurality of dispersed bases, and to prevent entry omission and mistakes due to manual input work. SOLUTION: In a WWW-linked inventory information distributed management system which manages and visually displays inventory information of articles moving among a plurality of distributed bases, a plurality of bases are selected from a plurality of bases. Each time the barcode affixed to the article is read, the received inventory information is received and accumulated, and the accumulated inventory information is tallyed,
A master WWW server that receives a request from a terminal having a master base inventory information section for visually processing and a WWW browser and returns data visually processed by the master base inventory information section to the terminal in response to the request. And

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a WWW-linked inventory information distributed management system. In particular, the present invention provides a WW for remotely grasping the management status of all of a plurality of distributed bases.
The present invention relates to a W-linked inventory information distribution management system.

[0002]

2. Description of the Related Art As a conventional example, there is disclosed an inventory display system for commodities described in Japanese Patent Application Laid-Open No. Hei 10-91711 in connection with the above management system. It discloses that when a stock inquiry is performed via the Internet using a terminal on the user side, information on the presence or absence of stock and the number of stocks is received. In this disclosure, the Web browser graphically displays the stock quantity and displays it on a display.

[0003] On the other hand, there has been a conventional example in which, at each of a plurality of dispersed bases, a computer manages in and out of a repaired article, repair status, and lending status as stock information using a computer. In this case, the stock information is manually input. Accordingly, it is possible to visually obtain inventory information of articles managed by one of a plurality of bases by accessing the Internet.

[0004]

However, according to the above-mentioned prior art, one of a plurality of bases can be accessed and the stock information of that part can be viewed, but the stock information of another base can be viewed. Can not. That is, there is a problem that all the bases must be sequentially accessed in order to know the stock information of all the bases.

In particular, if articles move among a plurality of dispersed bases, it becomes complicated to manage inventory information and movement history information of articles at each base, and inventory information of all bases is collectively managed. There is a problem that it is difficult to do. Furthermore, there is a problem in that manual entry operations often result in omission of entry and mistakes. Therefore, the present invention has been made in view of the above problem, and has a WWW link that can easily and visually manage inventory information of all locations where articles move between a plurality of locations and movement history information of articles between the locations. An object of the present invention is to provide an inventory information distribution management system.

[0006]

SUMMARY OF THE INVENTION In order to solve the above-mentioned problems, the present invention relates to a WWW-linked inventory information distribution management system for managing and visually displaying inventory information of articles moving between a plurality of dispersed bases. Receiving the stock information read from the plurality of locations each time the barcode attached to the article is read at each of the plurality of locations to the master location selected from the plurality of locations, accumulating, and accumulating; Receiving a request from a terminal having a WWW browser and a master base inventory information unit for visually processing the processed inventory information and visually processing the data visually processed by the master base inventory information unit in response to the request. Master WWW returned to the terminal
A WWW-linked inventory information distributed management system, comprising: a server;

By this means, the input operation using the bar code is simplified, all the movement histories of the inventory management distributed to the respective related bases are managed, and the repair, lending, and the display of the movement trajectory are realized. This makes it possible to automate and simplify management work and reduce management man-hours. Preferably, the bar code is provided with information of a district code and an article identification number,
The information read from the barcode is provided with the district code of the base, the read time, the entry / exit state of the article, the lender information, and the history information. Based on this information, the conventional manual management can be changed to automatic management by computerization, and the number of management steps can be reduced.

Preferably, the master base stock information section includes at least one of processing of the number of stock items at each base, the number of repair parts at each base, the total number of defective articles at each base, and the processing of the goods movement trajectory from the accumulated stock information. Do one. Based on this processing, the terminal that has made the inquiry request can analyze the stock status, the movement locus, and the like for all the bases.
Preferably, the master base stock information section calculates an article movement trajectory from a trajectory in which the article moves with time from a district code attached to the barcode of the article and a district code of the base from which the barcode is read. Ask. Based on this processing, the work at the time of stocktaking can be simplified.

Preferably, a master list information table holding the location of a master site is provided at each of the plurality of sites, and each time the bar code is read, a master site having the location held in the master list information table is provided. Send the loaded inventory information. By this means, it is possible to transmit inventory information to a plurality of master sites. Preferably, all of the plurality of bases are held in the master list information table, and the plurality of bases are set as master bases. By this means, unified inventory information of all bases can be obtained regardless of which base is inquired.

[0010] Preferably, the plurality of bases and the plurality of bases and the terminal are connected via the Internet or a dedicated line LA.
Connect with N or WAN. By this means, data transmission and reception between a plurality of distributed bases becomes possible, and an inquiry from a terminal to an arbitrary base becomes possible.

[0011] In a WWW-linked inventory information distribution management system for managing and visually displaying inventory information of articles moving between a plurality of dispersed locations, a bar code attached to the article is provided at each of a plurality of locations. An input terminal to be read, a master list information table holding the location of a master base selected from the plurality of bases, and a master that inputs stock information read from the input terminal and is stored in the master list information table A database server that transmits to the location of the base, performs a tallying process, performs visual processing, a base stock information database that stores stock information input to the database server, and receives a request from a terminal having a WWW browser, In response to the request, the stock information stored in the base stock information database is stored in the database server. And a WWW server for returning a visually processed result to the terminal, and an input terminal for reading a barcode attached to the article at the master base, and an inventory read from the input terminal. A master database server for inputting information, receiving inventory information transmitted from each of the database servers at the plurality of bases, performing aggregation processing, and performing visual processing, and inputting the database server from the input terminal. And a master base stock information database for storing stock information transmitted from the database servers at the plurality of bases, and a request from a terminal having a WWW browser. The stock information stored in the master database server WW, characterized in that it comprises a master WWW server to return more to aggregation processing, visually processed result to the terminal
A W-linked inventory information distribution management system is provided.

By this means, the input operation using the barcode is simplified, all the movement histories of the inventory management distributed to the related bases are managed, and the repair, lending, and movement trajectory display are realized. This makes it possible to automate and simplify management work and reduce management man-hours. WW for managing and visually displaying inventory information of articles moving between a plurality of dispersed bases
In the W-linked inventory information distributed management method, a processing step performed at a master site selected from the plurality of sites includes reading a bar code attached to the article at each of the plurality of sites. Receiving the accumulated inventory information, accumulating the accumulated inventory information, visually processing the accumulated inventory information, and processing the W from a terminal having a WWW browser.
Receiving a request from a WW server and returning data visually processed in response to the request to the terminal.

By this means, the input operation using the bar code is simplified, all the movement histories of the inventory management distributed to the respective related bases are managed, and the repair, lending, and movement trajectory display are realized. This makes it possible to automate and simplify management work and reduce management man-hours.

[0014]

Embodiments of the present invention will be described below with reference to the drawings. FIG. 1 shows a WWW according to the present invention.
It is a schematic structure figure for explaining the example of the cooperation stock information distributed management system. When articles are managed at a plurality of distributed bases, a master base that manages in cooperation with each base is set as shown in FIG. Each base has, for example, inventory and maintenance such as replacement packages and failures.
The repair article 10 exists and is managed. A bar code is attached to the maintenance / repair article 10, and the bar code identifies the maintenance / repair article 10, and is formed by a set of a district code + an article code. Here, the district code is the location (connection destination) for communication between each base and the master base via a communication line.
Information is described. IP (Intern) as location information
et Protocol) address, machine name, and the like.

An input terminal 11 is provided at each base, and the input terminal 11 reads a barcode of the maintenance / repair article 10. The input terminal 11 is connected to a communication line 100 in each site. The communication line 100 is preferably a LAN (Loc
al Area Network) or WAN (Wid)
e Area Network) and is connected to the Internet 17. Note that the Internet 17 is an example, and instead, a dedicated line configured by a LAN or a WAN may be used.

A stock information management system 12 at each site is connected to the input terminal 11 via a communication line 100. Each site inventory information management system 12 takes in inventory information from the input terminal 11. Each base inventory information management system 12 has W
WW (World Wide Web) server 13, D
A B (database) server 14 is provided. WWW
The server 13 is a server on which a so-called homepage is placed on the Internet. In response to receiving a display request for inventory information issued from an external terminal, the server 13 transmits the result to an external terminal in HTML (hyper text ma).
rkuplanguage) format. The data of the stock information is HTTP (Hyper Text Tran)
sfer Protocol) to an external terminal.

The DB server 14 is a server that manages inventory information data taken from the input terminal 11. Further, the DB server 14 performs a process of totalizing inventory information issued from an external terminal and a specified inventory status inquired from the WWW server 13 regarding a display request.
Aggregate inventory information and convert it to HTML (hyper text)
(Markuplanguage) format is returned to the WWW server 13. The DB server 14
Then, the input of the password may be requested before accepting the inquiry of the WWW server 13.

Each site inventory information management system 12 is provided with each site inventory information DB 15, and each site inventory information DB 1
Reference numeral 5 stores stock information of the maintenance / repair articles 10 fetched from the input terminal 11 under the management of the DB server 14. More specifically, each base inventory information DB 15 is a database file that stores rental information (rental date, lender name, lender name, etc.) of inventory items, and inventory status (number of loans, number of shortages).

Further, a master list information table 16 is provided in each site inventory information management system 12, and the master list information table 16 holds the location of the master inventory information management system at the master site. The number of master sites is usually one, but a plurality of sites may be the master sites. In this case, the master list information table 16 holds the locations of a plurality of bases. Preferably, all sites may be master sites. In this case, the locations of all bases are held in the master list information table 16.

Further, each time the barcode information is transferred from the input terminal 11, the base stock information DB 15 refers to the master list information table 16 to access the Internet 17.
And the stock status (the number of rents and the number of shortages) as difference information to the master site via the. In this case, when a plurality of bases or all bases are set as master bases, difference information is transmitted to a plurality of master bases or to all bases (master bases).

Next, an inventory terminal such as an exchange package and a maintenance / repair item 19 due to a failure are also present and managed at the master site, and an input terminal 20 for reading a barcode of the inventory item 19 is provided. Terminal 20 is
The barcode of the repaired article 19 is read. Since the master base also works as one base, it is for taking in inventory information of its own base.

The input terminal 20 is connected to a communication line 200 in the master site. The communication line 200 is preferably
It is configured with a LAN or WAN and is connected to the Internet 17. A master base stock information management system 21 is connected to the input terminal 20 via a communication line 200. A WWW server 22 is installed in the master base inventory information management system 21, and a DB server 23 is provided.

The master WWW server 22 is a server on which a home page is placed on the Internet.
In response to receiving a display request for inventory information issued from an external terminal, the result is returned to the external terminal in HTML format. The data of the stock information is transmitted to an external terminal using the HTTP protocol.

The master DB server 23 is connected to the input terminal 20
It is a server that manages inventory information data imported from. Further, the DB server 14 performs a tallying process on the stock information for the designated stock status inquired from the WWW server 13 regarding the tallying and display request of the stock information issued from the external terminal, processes the stock information into an HTML format, and converts the stock information into the WW format.
Return to W server 13.

Further, the DB server 23 tabulates the inventory information from each site, and checks the inventory status (the number of rentals,
(Insufficient number) and the movement trajectory information of the article are collectively managed. Here, the movement trajectory information of the article is history information such as information about where the article was lent from which base.

Further, the master base stock information management system 21 is provided with a master base stock information DB 24,
The master base stock information DB 24 accumulates stock information of the maintenance / repair articles 19 taken from the input terminal 20 under the management of the DB server 23. Specifically, the master base inventory information DB 24 stores the rental information (rental date,
Lender name, lender name, etc.), inventory status (number of loans, number of shortages)
Is a database file that stores

Further, the master base stock information DB 24 is also a database file for storing all data stored in each base stock information DB 15 and data of movement locus information of articles. When the master DB server 23 receives the inventory status (the number of rents and the number of shortages) as difference information transmitted from each site, the master site inventory information DB 24 accumulates this inventory status.

Next, a client PC 18 as an external terminal is connected to the Internet 17 and the client PC
A WWW browser 18A is installed in C18. The WWW browser 18A of the client PC 18
A request for displaying inventory information can be issued on the homepage of the WWW server 13 and the master server 22 at each site, and the displayed results can be viewed.

The homepage of the WWW server 13 allows browsing of stock information of each base, while the homepage of the WWW server 22 allows browsing of stock information of all bases and information of the movement locus of articles.

When a plurality of bases or all base masters are set as master bases in the master list information table 16 of each base, all the inventory information and the movement trajectory are managed at the plurality of bases or all bases. . Preferably, when all sites are set as masters, the same total result of stock information of all sites can be browsed from the homepage of the WWW server 13 of any site.

FIG. 2 is a diagram showing an example in which all the base stock information is visually processed in HTML format. As shown in the figure, the stock status is displayed in a list at the present time for each site. For example, it is possible to visually appeal, for example, by displaying an item with a stock quantity of “0” in red in an HTML format.

Although only four locations, Yokohama, Kawasaki, Setagaya, and Konan, are displayed here, the number of locations shown in the above figure increases in accordance with the number of locations to be managed. As described above, in the present invention, the inventory status scattered at each base is managed by each base inventory information management system 12 and the master base inventory information management system 21, and in the configuration of the master base inventory information management system 21. The master WWW server 22 extracts the aggregation information from the master DB server 23, and visually processes the stock status at each site in HTML format. WW of the client PC 18 from anywhere connected to the Internet 17
The W browser 18A can easily browse and grasp the stock status of all the bases displayed on the homepage of the WWW server 22 for the master base.

FIG. 3 is a diagram showing a specific example of the configuration of each site in FIG. As shown in this figure, a barcode 10A is attached to the stock article and the maintenance / repair article 10. As the input terminal 11 of FIG. 1, as shown in FIG.
A barcode reader 11A and a PC (personal computer) terminal 11B are provided. Barcode reader 11A
Is a bar code attached to the maintenance / repair article 10 every time a delivery of an article due to a malfunction, delivery of an article for lending to another base, replenishment of a maintenance article, or entry of a warehouse due to repair of a defective article occurs. 10A is read, and maintenance / repair items 10
The identification information is fetched as the stock information of.

The PC terminal 11 is connected to the barcode reader 11A.
B is connected, and the PC terminal 11B performs a transfer process of the input identification information and the like. The communication line 100 in each site is connected to the PC terminal 11B. Each site inventory information management system 12 is connected to the communication line 100, and identification information is transferred to each site inventory information management system 12. Each base inventory information management system 12 is, for example, WindowsNt.
4.0, a computer on which an operating system (OS) such as Solaris is installed.

Each site inventory information management system 12 is provided with a bar code information processing section 12A. The PC terminal 11 is connected to the barcode information processing unit 12A via the communication line 100.
B transmits the identification information. Barcode information processing unit 1
In 2A, for each location of the inventory information system of each base in advance,
The area code for classifying the location is correlated, and information for each article is processed based on the area code of the read location, the district code of the barcode, and the read time. The barcode information processing unit 12A transmits the difference information described above to the communication line 1
00, and transmits it to the master site via the Internet 17.

Each site inventory information management system 12 is provided with a web server (WebServer) 12B. Web server 12B specifically has Apache
e, software such as WAS is installed. The homepage of the web server 12B is browsed by the WWW browser 18A of the client PC 18,
When there is a request for totalizing the stock, the request is accepted and the totaling result is displayed.

Each site inventory information management system 12 is provided with a tally processing unit 12C, and the tally processing unit 12C uses the WWW of the client PC 18 by the web server 12B.
When the browser 18A requests a tally of the stock, the information is extracted based on the contents of the tally of the stock, the tally process is performed, the tally result is processed in the HTML format, and the result is delivered to the web server 12B.

Each site inventory information management system 12 has a database management system 12D (DBMS: Data B).
case management system) is provided. Database management system 12D is Oracle
e is a database in which software such as V8 is installed, and the database management system 12D is provided with the base stock information database 15 and the master list information table of FIG.

As described above, the database management system 12D stores history information for each article processed by the barcode information processing section 12A. The tallying processing unit 12C performs tallying processing based on information extracted from the database management system 12D via the barcode information processing unit 12A.

The bar code information processing section 12A shown in FIG.
The tallying unit 12C corresponds to the DB server 14 in FIG. 1, and the web server 12B corresponds to the WWW server 1 in FIG.
3, the database management system 12 </ b> D stores the base inventory information DB 15 and the master list table 16 in FIG.
Corresponding to

FIG. 4 is a diagram showing a specific example of the configuration of the master base in FIG. As shown in this figure,
A bar code 19 </ b> A is attached to the stock item and the maintenance / repair item 19.

As shown in FIG. 4, a bar code reader 20A and a PC (personal computer) terminal 20B are provided as the input terminal 20 in FIG. The barcode reader 20A is attached to the maintenance / repair article 19 every time when the delivery of the article due to the malfunction, the delivery of the article for lending to another base, the replenishment of the maintenance article, and the entry of the article due to the repair of the defective article occur. The barcode 10A is read, and identification information is taken in as inventory information of the maintenance / repair articles 19.

The PC terminal 20 is connected to the bar code reader 20A.
B is connected, and the PC terminal 20B performs a process of transferring the input identification information. The communication line 200 in the master site is connected to the PC terminal 20B. The master base stock information management system 21 is connected to the communication line 200, and the identification information is transferred to the master base stock information management system 21. The master base stock information management system 21 is a computer on which an operation system (OS) such as WindowsNt4.0 or Solaris is installed.

Each site inventory information management system 21 is provided with a barcode information processing section 21A. The PC terminal 20 is connected to the barcode information processing unit 21A via the communication line 200.
B transmits the identification information. Barcode information processing unit 2
In 1A, for each location of the inventory information system of each base in advance,
The area code for classifying the location is correlated, and information for each article is processed based on the area code of the read location, the district code of the barcode, and the read time. The barcode information processing unit 21A receives the above-described difference information from each base via the Internet 17 and the communication line 200.

Each site inventory information management system 21 is provided with a web server 21B. WebServer
Specifically, software such as Apache and WAS is installed in 21B. Web server 2
The homepage 1B is browsed by the WWW browser 18A of the client PC 18, and when there is a request for totalizing the stock, the request is received and the totaling result is displayed.

Each site inventory information management system 21 is provided with a tally processing unit 21C, and the tally processing unit 21C is requested by the web server 21B to request a tally of inventory from the WWW browser 18A of the client PC 18, and to request the tally of the inventory. Extract information based on the content, perform aggregation processing,
Processing the results in HTML format for web server 21
Hand over to B.

Each site inventory information management system 21 is provided with a database management system 21D. The database management system 21D is a database in which software such as Oracle V8 is installed.
In the database management system 21D, as described above,
History information for each article processed by the barcode information processing unit 21A is stored. The tabulation processing unit 21C performs a tabulation process based on information extracted from the database management system 21D via the barcode information processing unit 21A.

The bar code information processing section 21A shown in FIG.
And the aggregation processing unit 21C is the master DB server 2 of FIG.
3, the web server 21B corresponds to the master WWW server 22 in FIG. 1, and the database management system 21D corresponds to the master base stock information DB 24 in FIG.

FIG. 5 shows the client PC 18 in FIG.
It is a figure which shows the specific example regarding. As shown in this figure,
The client PC 18 is, for example, Windows NT
This is a computer on which an operating system (OS) such as 4.0, Windows 9x, or Mac is installed.

The WWW browser 18A of the client PC 18 has a NetscapeCommunication
software such as or is installed. The client PC 18 is connected to the communication line 300 and the Internet 17. Preferably, the communication line 300 is constituted by a LAN or a WAN.

As shown in the figure, the stock information management system uses the WWW browser 18A from the client PC 18 via the communication line 300 and the Internet 17 to use the web server 21B in the master base stock information management system 21 in FIG. The homepage is browsed and a tallying request is issued. Web server 2 that received the request
1B indicates that the tallying processing unit 21C has
When the inventory status obtained from the database management system 21D via A is totaled and the totaled result is processed into the HTM format, it is displayed on the homepage. The WWW browser 18A browses the totalized result on the homepage.

Similarly, from the client PC 18 via the communication line 300 and the Internet 17, the WWW browser 18 A sends each base inventory information management system 1 of FIG.
In 2, the homepage of the web server 12B may be browsed and a tallying request may be issued. In this case, upon receiving the request, the web server 12B, when the tabulation processing unit 12C tabulates the stock status obtained from the database management system 12D via the barcode information processing unit 12A, and processes the tabulation result into the HTM format, displays it on the homepage. . The WWW browser 18A browses the tally result.

It is to be noted that not only one master stock information management system manages all the stock information and the movement trajectory, but as described above, the master list information 16 of each base is used as the master base as the identification names of all the bases. If (District code) is posted, you can manage duplicate information at all sites. That is, the same total result can be browsed even if a total inquiry is made from the web server homepage of any base.

FIG. 6 is a flowchart for explaining the operation of each site inventory information management system 12 in FIG. 3, FIG. 7 is a diagram showing an example of the format of data to be stored in the database management system 12D, and FIG. FIG. 12 is a diagram for explaining history addition for data to be stored in a management system 12D. As shown in FIG.

In step S1, the maintenance / repair article 10
Is read by the barcode reader 11A. Repair, lending status, etc. are also input. Step S
The barcode information read in 2 is a barcode information processing unit 1 that constitutes each base inventory information management system 12.
2A.

In step S3, the barcode information processing section 12A checks whether or not the information corresponding to the barcode information already exists from the database management system 12D. Based on the time and information on repaired / new / loaned, information in the format shown in FIG. 7 is formed.

If the same barcode information exists in step S4, as shown in FIG. 8, the history number is moved up to indicate that the barcode information is stored in the database management system 12D together with the supplementary information. The upper part of FIG. 8 shows that the article with the article identification number “0000010” was previously in “Konan”, lent or transferred, and lent to “Shizuoka” at 14:10 on January 20, 1999.

The lower part of FIG. 8 shows that the article with the article identification number "000010" was replenished to "Osaka" from "Konan" several days after the lending, and the history number is raised. A line with a black dot at the beginning of the line indicates that there is additional history information. If the same barcode information does not exist, the barcode information is stored as new information in each site inventory information management system 12.

The difference is accumulated in the form of the history information, and the difference between the district code of each base and the district code of the main body constituting the bar code is examined. Thereby, at the time of stocktaking, it becomes possible to grasp where the initial management place or the main control was for the articles present at each base.

Further, when the master is changed at the time of the inventory, the new base can be managed by replacing the district code of this bar code with the district code of the new base. Further, the above history information is transferred to the master base stock information management system 21.

FIG. 9 is a flowchart for explaining the operation of the master base stock information management system 21 of FIG. 4, and FIG. 10 is a diagram showing an example of the format of data to be stored in the database management system 21D. In FIG. 9, the processing of the bar code information from the bar code reader 20A is the same as the processing of FIG. 6, and therefore the description is omitted, and the processing of the bar code information transmitted from each base will be described here.

In step S 11, each of the bases
The barcode information processing section 21A of the master base stock information management system 21 receives the history information of the goods at each base in order to manage the movement trajectory of lending, borrowing, and replenishment of the goods from each base. In step S12, the barcode information processing unit 21A converts the received history information, that is, the barcode information, the district code, the maintenance / repair, the lending status, and the read time into the history information of the movement trajectory of all the inventory items as shown in FIG. Then, process.

The upper part of FIG. 10 lends stock items managed by Konan located in Osaka to Shizuoka, and the lower part of FIG. 10 shows the history addition when arriving at Shizuoka the next day. FIG. 11 is a flowchart for explaining the operation of the master base stock information management system 21 of FIG. 4, and FIG. 12 is a diagram for explaining an example of stock totaling. In FIG.

In step S21, the client P
The WWW browser 18A of C18 browses the homepage of the web server of the master base stock information management system 21 and issues a total inventory count and a display request of the movement locus of the repaired article. In step S22, when the web server 21B requests this request to the tally processing unit 21C, the tally processing unit 2 extracts inventory information from the database management system 21D via the barcode information processing unit 21A.

In step S23, the tally processing unit 21
C, as shown in FIG. 12, counts the number of stocks at each site, counts the number of stocked items, repaired items, and defective items of each site management from the history information, and further extracts the movement locus of the items. Do. In step S24, these results are converted to an HTM
Convert to L format. In step S25, the HTML
The output information in the format is displayed on the homepage of the web server 21B. The WWW browser 18A of the client PC 18 browses the output information on a homepage.

[0066]

As described above, according to the present invention,
A barcode is attached to each maintenance / repair item and inventory item, and is read by a barcode reader each time a product is moved in and out, so that the number of input steps and errors can be reduced.

Further, by managing all the history of the inventory information at each site based on the information of the barcode, the procedure management by the conventional management ledger is changed to the automatic management by computerization. Can be expected. In addition, since the management information of each base is collectively managed by the master inventory information management system, it is easy to grasp the overall traffic status and trajectory.

Further, since the district code constituting the bar code is made to correspond to the managing base and is accumulated as history information together with the district code of the moved base, no matter where the user moves, the managing base is in the bar. Because you can understand from the code,
The work at the time of stocktaking can be simplified, and a reduction in man-hours can be expected.

Further, by linking the WWW system to the inventory information management system, the administrator does not need any special device, and can analyze the inventory status, the movement trajectory, etc. using only a general PC terminal or WWW browser. Can be easily performed, and a large reduction in the conventional man-hour can be expected.

[Brief description of the drawings]

FIG. 1 is a schematic configuration diagram for explaining an example of a WWW-linked inventory information distributed management system according to the present invention.

FIG. 2 is a diagram showing an example in which all base stock information is visually processed in an HTML format.

FIG. 3 is a diagram showing a specific example of a configuration of each base in FIG. 1;

FIG. 4 is a diagram showing a specific example of a configuration of a master site in FIG. 1;

FIG. 5 is a diagram showing a specific example of a client PC 18 in FIG.

FIG. 6 is a flowchart illustrating the operation of each base inventory information management system 12 of FIG. 3;

FIG. 7 is a diagram illustrating a format example of data to be stored in a database management system 12D.

FIG. 8 is a diagram for explaining history addition for data to be stored in the database management system 12D.

9 is a master base stock information management system 21 shown in FIG.
5 is a flowchart for explaining the operation of FIG.

FIG. 10 is a diagram showing a format example of data to be stored in a database management system 21D.

11 is a master base inventory information management system 2 of FIG.
3 is a flowchart illustrating the operation of FIG.

FIG. 12 is a diagram illustrating an example of inventory totalization.

[Explanation of symbols]

 DESCRIPTION OF SYMBOLS 10 ... Maintenance / repair articles 10A ... Barcode 11 ... Input terminal 11A ... Barcode reader 11B ... PC terminal 12 ... Each base stock information management system 12A ... Barcode information processing unit 12B ... Web server 12C ... Total processing unit 12D ... Database Management system 13 WWW server 14 DB server 15 Base stock information DB 16 Master list information table 17 Internet 18 Client PC 18 A WWW browser 19 Maintenance / repair items 20 Input terminal 20 A Bar code reader 20 B ... PC terminal 21 ... Master base stock information management system 21A ... Bar code information processing unit 21B ... Web server 21C ... Total processing unit 21D ... Data base management system 22 ... Master WWW server 23 ... Master DB server Bar 24 ... master base stock information DB 100,200,300 ... communication line

────────────────────────────────────────────────── ───

[Procedure amendment]

[Submission Date] January 20, 2000 (2000.1.2
0)

[Procedure amendment 1]

[Document name to be amended] Statement

[Correction target item name] Claim 1

[Correction method] Change

[Correction contents]

[Procedure amendment 2]

[Document name to be amended] Statement

[Correction target item name] Claim 11

[Correction method] Change

[Correction contents]

[Procedure amendment 3]

[Document name to be amended] Statement

[Correction target item name] Claim 12

[Correction method] Change

[Correction contents]

[Procedure amendment 4]

[Document name to be amended] Statement

[Correction target item name] 0006

[Correction method] Change

[Correction contents]

[0006]

SUMMARY OF THE INVENTION In order to solve the above-mentioned problems, the present invention manages stock information of articles moving between a plurality of geographically dispersed bases and visually displays the stock information. in the management system, the in the base
Read the barcode affixed to the goods, inventory information
And a base inventory information section for accumulating the information, and in the master location selected from the plurality of locations, the location inventory in the location
Each time the information unit reads the barcode affixed to the article, it receives and accumulates the read inventory information, accumulates the accumulated inventory information, and visually processes the master base inventory information unit. And a master WWW server that receives a request from a terminal having a WWW browser and returns the stock information visually processed by the master base stock information unit to the terminal in response to the request. A WWW-linked inventory information distribution management system is provided.

[Procedure amendment 5]

[Document name to be amended] Statement

[Correction target item name] 0007

[Correction method] Change

[Correction contents]

[0007] By this means, the input operation using the bar code is simplified, all the movement histories of the inventory management which are geographically distributed to the related bases are managed, and the repair, lending, and movement trajectory status are displayed. This has made it possible to automate and simplify management tasks and reduce management man-hours. Preferably, the barcode is provided with information of a district code and an identification number of the article, and the information read from the barcode includes a district code of a base, a read time, an entry / exit state of an article, renting destination information, and history information Is attached. Based on this information, the conventional manual management can be changed to automatic management by computerization, and the number of management steps can be reduced.

[Procedure amendment 6]

[Document name to be amended] Statement

[Correction target item name] 0011

[Correction method] Change

[Correction contents]

[0011] In a WWW-linked inventory information distributed management system for managing and visually displaying inventory information of articles moving between a plurality of geographically dispersed locations, each of the plurality of locations is attached to the article. An input terminal that reads a barcode, a master list information table that holds the location of a master base selected from the plurality of bases, and inventory information that is read from the input terminal, and is stored in the master list information table A database server that transmits to the location of the master base to be processed, tabulates, and performs visual processing; a base stock information database that stores stock information to be input to the database server;
A WWW server for receiving a request from a terminal having a browser, processing the inventory information accumulated in each of the base inventory information databases in response to the request by the database server, and returning a visually processed result to the terminal; An input terminal for reading a barcode attached to the article at the master site, and inventory information read from the input terminal, and inventory information transmitted from the database server at each of the plurality of sites. , A totaling process, and a master database server for performing visual processing, stock information input from the input terminal to the database server, and stock information respectively transmitted from the database servers at the plurality of locations. Master base inventory information database and WW
A request is received from a terminal having a W browser, inventory information stored in the master base inventory information database is processed by the master database server in response to the request, and the visually processed inventory information is returned to the terminal. A WWW-linked inventory information distributed management system, comprising:

[Procedure amendment 7]

[Document name to be amended] Statement

[Correction target item name] 0012

[Correction method] Change

[Correction contents]

By this means, the input operation using the barcode is simplified, all the movement histories of the inventory management which are geographically dispersed at the related bases are managed, and the repair, lending, and movement trajectory status are displayed. This has made it possible to automate and simplify management tasks and reduce management man-hours. In a WWW-linked inventory information distributed management method for managing and visually displaying inventory information of articles moving between a plurality of geographically dispersed locations, a bar code attached to the article in the location
Read, and a step for storing inventory information, in the master base selected from among the plurality of bases, each time the barcode attached before <br/> Symbol articles within the site is loaded, Receiving and accumulating the read inventory information, totalizing the accumulated inventory information, and visually processing the processed information;
Receiving a request from a terminal having a W browser to a WWW server, and returning the stock information visually processed in response to the request to the terminal. Provide a distributed management method.

[Procedure amendment 8]

[Document name to be amended] Statement

[Correction target item name] 0013

[Correction method] Change

[Correction contents]

By this means, the input operation using the bar code is simplified, all the movement histories of the inventory management which are geographically distributed to the respective related bases are managed, and the repair, lending, and movement trajectory status are displayed. This has made it possible to automate and simplify management tasks and reduce management man-hours.

[Procedure amendment 9]

[Document name to be amended] Statement

[Correction target item name] 0017

[Correction method] Change

[Correction contents]

The DB server 14 is a server that manages inventory information data taken from the input terminal 11. Further, the DB server 14 performs a process of totalizing inventory information issued from an external terminal and a designated inventory status inquired from the WWW server 13 regarding a display request.
Aggregate processing inventory information HTML (H yper T ext
Return the result of processing to the M arku p L anguage) format to the WWW server 13. DB server 1
In step 4, an input of a password may be requested before an inquiry from the WWW server 13 is accepted.

Continued on the front page F term (reference)

Claims (12)

[Claims] 1. A WWW-linked inventory information distributed management system that manages and visually displays inventory information of articles moving between a plurality of distributed locations, wherein a master location selected from the plurality of locations is Each time the barcode attached to the article is read at each of the plurality of bases, the read stock information is received and accumulated, the accumulated stock information is totaled, and the master base stock is visually processed. An information unit; and a master WWW server for receiving a request from a terminal having a WWW browser and returning data visually processed by the master base stock information unit to the terminal in response to the request. WWW-linked inventory information distribution management system. 2. The bar code is provided with information of a district code and an article identification number.
WWW-linked inventory information distributed management system described in 1. 3. The information read from the barcode, wherein a district code of a base, a read time, a state of entry / exit of goods, lender information, and history information are added. WWW linked inventory information distributed management system. 4. The master base inventory information section is configured to perform at least one of processing of the number of articles in each base, the number of repaired parts in each base, the total number of defective articles in each base, and the processing of the goods movement trajectory from the accumulated inventory information. 2. The WWW-linked inventory information distributed management system according to claim 1, wherein: 5. The master base inventory information section is configured to move the article from a locus along which the article moves with time based on a district code attached to the barcode of the article and a district code of the base from which the barcode is read. 5. The WWW-linked inventory information distribution management system according to claim 4, wherein a trajectory is obtained. 6. A master list information table holding the location of a master site is provided at each of the plurality of sites, and each time the barcode is read, the master list information table is read into the master site whose location is held in the master list information table. 2. The WWW-linked inventory information distribution management system according to claim 1, wherein the inventory information is transmitted. 7. The WWW according to claim 6, wherein all of the plurality of bases are held in the master list information table, and the plurality of bases are used as master bases.
Linked inventory information distributed management system. 8. The WWW-linked inventory information distribution management system according to claim 1, wherein the plurality of bases and the plurality of bases and the terminal are connected via the Internet. 9. The WWW-linked inventory information distribution management system according to claim 1, wherein the plurality of bases and the plurality of bases and the terminal are connected by a dedicated line. 10. The WWW-linked inventory information distribution management system according to claim 1, wherein the plurality of bases and the plurality of bases and the terminal are connected by a LAN or a WAN. 11. A WWW-linked inventory information distribution management system for managing and visually displaying inventory information of articles moving between a plurality of dispersed locations, wherein a bar attached to the article is provided at each of a plurality of locations. An input terminal that reads a code, a master list information table that holds the location of a master base selected from the plurality of bases, and inventory information that is read from the input terminal, and is stored in the master list information table. A database server that transmits the data to the location of the master's base, performs tally processing, and performs visual processing; a base stock information database that stores stock information to be input to the database server; and a request from a terminal having a WWW browser. Receiving, in response to the request, the inventory information stored in each of the base inventory information databases to the database WWW that collects data by server and returns the visually processed result to the terminal
And an input terminal for reading a barcode attached to the article at the master site, and inputting inventory information read from the input terminal, and transmitted from the database server at each of the plurality of sites. A master database server that receives, aggregates, and visually processes inventory information that is input from the input terminal to the database server, and is transmitted from the database servers at the plurality of locations, respectively. A request is received from a terminal having a master base stock information database for storing stock information and a WWW browser, and the stock information stored in the master base stock information database is tabulated by the master database server in response to the request. Return the processed result to the terminal WWW cooperation stock information distribution management system, characterized in that it comprises a coater WWW server. 12. A WWW-linked inventory information distributed management method for managing and visually displaying inventory information of articles moving between a plurality of distributed locations, wherein the method is performed at a master location selected from the plurality of locations. Each time the barcode affixed to the article is read at each of the plurality of locations, the processing step receives and accumulates the read inventory information, collects the accumulated inventory information, and visually processes the information. And a step of receiving a request from a terminal having a WWW browser to a WWW server and returning to the terminal visually processed data in response to the request.
WW linked inventory information distributed management method.