JP2008242560A - Cash collection and delivery management system, terminal, server and program - Google Patents

Abstract

Provided is a cash collection and delivery management system that can be introduced at low cost, can prevent human error, and can reduce work time.
An IC tag is attached to a dedicated bag, and a reader / writer performs batch reading of the IC tag of the dedicated bag when the dedicated bag is unloaded and loaded. Then, the reader / writer 15 confirms whether or not the planned delivery number matches the number of readings. Further, the server 13 collates the list of management No. 52 of the dedicated bag 4 that has been received with the list of management No. 52 of the dedicated bag 4 that is scheduled to be received, and the terminal 11 displays the management No. 52 of the dedicated bag 4 that is excessive or insufficient from the comparison result. .
[Selection] Figure 3

Description

  The present invention relates to a system for managing cash collection and delivery, and more particularly to a cash collection and delivery management system using an IC tag.

At retail stores such as stations, the collection and delivery of change and sales proceeds are entrusted to cash collection and delivery companies, reducing the labor and risk of cash management. The entrusted cash collection / delivery company distributes change from the cash collection / delivery center to each retail store and collects sales from each retail store and manages the cash collection / delivery center.
As a mechanism for managing such cash collection and delivery, there is, for example, Patent Document 1. In Patent Document 1, a sales deposit machine that deposits the sales proceeds of a store, a cash cassette that is detachably installed in the sales deposit machine, and a cash collection and delivery center (a cash processing center in Patent Document 1) are installed. And a system having a cash cassette receiving device for receiving a cash cassette is disclosed. Then, an IC tag is affixed to the cash cassette, and the cash cassette receiving device is provided with an IC tag information reading unit, so that a change reserve necessary for cash processing center can be ordered from each store.
JP 2006-243991 A

However, in the mechanism described in Patent Document 1, it is necessary to provide devices such as a sales deposit machine, a cash cassette, and a cash cassette receiving device, and the introduction of the system is very expensive. Further, in order to read the information of the IC tag, it is necessary to set the cash cassettes one by one in the cash cassette receiving apparatus, which takes time.
On the other hand, for example, when cash to be collected and delivered is put into a dedicated cash bag for each retail store and managed in units of dedicated bags, the existing dedicated bag may be used, so that the cost problem can be solved. However, the confirmation work for the dedicated bag received at the cash collection / delivery center is still time-consuming. In addition, if the time zones during which the dedicated bags are received at the cash collection / delivery center overlap, human errors in the confirmation work are likely to occur.

  The present invention has been made in view of the above-described problems, and its purpose can be introduced at low cost, and a cash collection / delivery management system that can prevent human error and reduce work time. Is to provide.

  In order to achieve the above-described object, the first invention is a cash in which at least one terminal and a server are connected to a network, and cash collection and delivery is managed using a dedicated bag with an IC tag and a reader / writer. In the collection / delivery management system, the reader / writer writes a management number for uniquely identifying the dedicated bag to the IC tag, and the IC tag attached to the dedicated bag when the dedicated bag is issued. And a means for confirming whether or not the number of the management numbers read at the same time and the planned number of delivery items obtained from the server via the terminal match, are provided. It is.

  In the first invention, the terminal comprises means for acquiring a list of the management numbers of the dedicated bag that has been received from the reader / writer when the dedicated bag is received, and transmitting the list to the server. Comprises means for comparing the list of management numbers of the dedicated bag that has been received with the list of management numbers of the dedicated bag that is scheduled to be received, and the terminal is configured to check whether the dedicated bag that is excessive or insufficient from the verification result. It is desirable to further comprise means for displaying the management number.

  1st invention WHEREIN: The said server is the receipt detail information which shows that the said exclusive bag was delivered, the receipt detailed information which shows that the said exclusive bag was received, and the receipt which shows that the said exclusive bag was received And a means for counting the number of goods issued, the number received, and the number of goods received from the goods receipt details information. It is desirable to further comprise means for displaying whether or not the number of receipts and the number of receipts all match.

  In the first invention, it is preferable that the terminal further includes means for displaying whether the delivery, receipt, and entry are performed for each management number of the dedicated bag.

A second invention is a terminal connected to a server via a network and having a function of reading an IC tag attached to a dedicated bag, and the management number of the dedicated bag that is received when the dedicated bag is received A list of the management number of the dedicated bag that has been received and the list of the management number of the dedicated bag that is scheduled to be received from the server. And a means for displaying the management number of the dedicated bag that is excessive or insufficient from the result.
The reading function of the IC tag attached to the dedicated bag is realized via a reader / writer.

  In the second invention, it is preferable that the information processing apparatus further comprises means for receiving from the server the number of goods issued, the number of goods received, and the number of goods received from the server, and displaying whether or not they all match.

  2nd invention WHEREIN: The detailed information of the issue, receipt, and receipt for every said management number of the said exclusive bag was received from the said server, and the issue, receipt, and receipt were performed for every said management number of the said exclusive bag It is desirable to further include a means for displaying.

  A third invention is a server connected to a terminal having a function of reading an IC tag attached to a dedicated bag via a network, and a list of management numbers of the dedicated bag that has been received and the dedicated to be stored A server comprising: means for collating with the list of management numbers of a bag; and means for transmitting a collation result to the terminal.

  In the third invention, delivery details information indicating that the dedicated bag has been issued, receipt details information indicating that the dedicated bag has been received, warehousing details information indicating that the dedicated bag has been received, And a means for counting the number of goods issued, the number received, and the number of goods received from the warehousing details information, the receipt details information, and the warehousing details information, and means for transmitting the counting results to the terminal. It is desirable.

  A fourth invention is a program for causing a computer to function as a terminal according to any one of claims 5 to 7.

  A fifth invention is a program for causing a computer to function as the server according to claim 8 or claim 9.

  According to the present invention, it is possible to provide a cash collection and delivery management system or the like that can be introduced at a low cost, can prevent human error, and can reduce work time.

  Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings.

FIG. 1 is a diagram showing an outline of the cash collection and delivery management business according to the embodiment of the present invention.
As shown in FIG. 1, in the cash collection and delivery management business, the advance collection 101 process is performed in the cash collection and delivery center 2, and a name tag 7 indicating a delivery destination is attached to the dedicated bag 4. The dedicated bag 4 is a bag dedicated to cash. Then, when the dedicated bag 4 is loaded into the collection and delivery vehicle 9, the process of the delivery 102 is performed, and when the dedicated bag 4 is delivered to the retail store 3, the processing of the delivery 103 is performed. On the other hand, the process of receiving 104 is performed when the dedicated bag 4 is collected from the retail store 3, and the process of the warehousing 105 is performed when the dedicated bag 4 is unloaded from the collection and delivery vehicle 9. Further, in the cash collection / delivery center 2, the search 106 is processed using the terminal 11.

FIG. 2 is a diagram showing the address tag 7.
As shown in FIG. 2, the address tag 7 is obtained by laminating the addressed printed matter 6 with barcode and the IC tag 5 together. On the addressed printed matter 6 with the barcode, the address to which the dedicated bag 4 is delivered, the management number as a management number for uniquely identifying the dedicated bag 4, and a barcode indicating the management number are printed. In the IC tag 5, information similar to the barcode is written.

FIG. 3 is a diagram showing a schematic configuration of the cash collection and delivery management system 1 according to the embodiment of the present invention.
FIG. 3 shows an example of the cash collection / delivery management system 1, and as shown in FIG. Connected via the network 19 as necessary. The network 19 is the Internet, a local area network (LANN), or the like, and may be wired or wireless.

  The dedicated bag 4 is a dedicated bag for cash, and is loaded on a collection and delivery vehicle 9 to and from the cash collection and delivery center 2 and each retail store 3.

  The terminal 11 is a computer and is connected to the network 19 and includes an interface capable of transmitting and receiving data to and from the reader / writer 15.

  The server 13 is a computer and is connected to the network 19 and includes a database related to cash collection and delivery management.

  The reader / writer 15 is a device that reads and writes the IC tag 5 and can be carried.

  The printer 17 is a printing device, is connected to the network 19, and performs printing in accordance with a printing instruction from the terminal 11 or the server 13.

  Next, the hardware configuration of various devices will be described with reference to FIGS.

FIG. 4 is a hardware configuration diagram of the terminal 11. The server 13 has the same configuration.
The terminal 11 includes a control unit 21, a storage unit 22, a media input / output unit 23, a communication control unit 24, an input unit 25, a display unit 26, and a peripheral device I / F (interface) unit 27 connected via a bus 28. Configured.

The control unit 21 includes a CPU (Central Processing Unit), a ROM (Read Only Memory), a RAM (Random Access Memory), and the like.
The CPU calls and executes a program stored in the storage unit 22, ROM, storage medium, or the like to the work memory area of the RAM, and drives and controls each device connected via the bus 28.
The ROM is a non-volatile memory and permanently holds a computer boot program, a program such as BIOS, data, and the like.
The RAM is a volatile memory, and temporarily stores a program, data, and the like loaded from the storage unit 22, ROM, recording medium, and the like, and includes a work area used by the control unit 21 for performing various processes.

The storage unit 22 is an HDD (hard disk drive), and stores a program executed by the control unit 21, data necessary for program execution, an OS (operating system), and the like. As for the program, a control program corresponding to an OS (operating system) and an application program corresponding to processing described later are stored.
Each of these program codes is read by the control unit 21 as necessary, transferred to the RAM, read by the CPU, and executed as various means.

  The media input / output unit 23 (drive device) inputs / outputs data, for example, a floppy (registered trademark) disk drive, a CD drive (-ROM, -R, RW, etc.), a DVD drive (-ROM, -R, -RW etc.) and media input / output devices such as MO drives.

  The communication control unit 24 has a communication control device, a communication port, and the like, and is a communication interface that mediates communication between the server 7 and the network, and controls communication between the terminal 11 and other computers via the network 19. Do.

The input unit 25 inputs data and includes an input device such as a pointing device such as a keyboard and a mouse, a numeric keypad, and a touch panel.
An operation instruction, an operation instruction, data input, and the like can be performed on the terminal 11 via the input unit 25.

  The display unit 26 includes a display device such as a CRT monitor and a liquid crystal panel, and a logic circuit (a video adapter or the like) for realizing a video function of a computer in cooperation with the display device.

  The peripheral device I / F (interface) unit 27 is a port for connecting a peripheral device to the computer, and the computer transmits and receives data to and from the peripheral device via the peripheral device I / F unit 27. The peripheral device I / F unit 27 is configured by USB, IEEE 1394, RS-232C, or the like, and usually includes a plurality of peripheral devices I / F. The connection form with the peripheral device may be wired or wireless.

  The bus 28 is a path that mediates transmission / reception of control signals, data signals, and the like between the devices.

FIG. 5 is a hardware configuration diagram of the reader / writer 15.
The reader / writer 15 includes a control unit 31, a power supply unit 32, an input unit 33, a display unit 34, a barcode scanner unit 35, an external device input / output unit 36, a communication unit 37, an antenna 38, and the like.

  The control unit 31 includes a CPU for executing a program, an OS (Operating System), a ROM (Read Only Memory) for storing program instructions or data, and a RAM (Random) for storing temporary work data. (Access Memory) or the like. The control unit 31 controls the entire reader / writer 15.

  The power supply unit 32 supplies power for driving the reader / writer 15.

  The input unit 33 inputs data and includes an input device such as a numeric keypad or a touch panel. An operation instruction, an operation instruction, data input, and the like can be performed on the reader / writer 15 via the input unit 33.

  The display unit 34 includes a display device such as a liquid crystal panel.

  The barcode scanner unit 35 controls reading of barcode information.

  The external device input / output unit 36 controls transmission / reception of data to / from the external device. The external device input / output unit 36 is configured by USB, RS-232C, or the like.

  The communication unit 37 modulates and demodulates data, and controls wireless communication with the IC tag 5 via the antenna 38.

FIG. 6 is a hardware configuration diagram of the IC tag 5.
The IC tag 5 includes a memory 41, an antenna 42, and the like.

  The memory 41 includes a RAM (Random Access Memory) for storing data. The IC tag 5 performs wireless communication with the reader / writer 15 via the antenna 42.

  Next, the database held by the server 13 will be described with reference to FIGS.

FIG. 7 is a diagram illustrating an example of the dedicated bag information 51.
The dedicated bag information 51 is detailed information of the dedicated bag 4. As shown in FIG. 7, the dedicated bag information 51 has a management No. 52, a delivery destination No. 53, an employee No. 54, a planned delivery date 55, a planned delivery date 56, etc., and the management No. 52 is the main key.
The management No. 52 is a management number that uniquely identifies the dedicated bag 4.
The delivery destination No. 53 is a number that uniquely identifies the delivery destination.
Employee No. 54 is a number that uniquely identifies the employee.
The scheduled delivery date 55 is the date on which the dedicated bag 4 is scheduled to be delivered.
The scheduled storage date 56 is the date on which the dedicated bag 4 is scheduled to be stored.

FIG. 8 is a diagram illustrating an example of the shipping details information 61.
In the following, the same elements as those shown in FIG.
The delivery detail information 61 is history information indicating that the dedicated bag 4 has been delivered. As shown in FIG. 8, the delivery details information 61 includes management No. 52, delivery date 62, employee No. 54, etc., and the management No. 52 is the main key.
The shipping date 62 is the date when the dedicated bag 4 was shipped.

FIG. 9 is a diagram showing an example of the receipt details information 71.
The receipt details information 71 is history information indicating that the dedicated bag 4 has been received. As shown in FIG. 9, the receipt details information 71 has a management No. 52, a receipt date 72, an employee No. 54, etc., and the management No. 52 is a primary key.
The receipt date 72 is the date on which the exclusive bag 4 was received.

FIG. 10 is a diagram illustrating an example of the warehousing details information 81.
The receipt details information 81 is history information indicating that the dedicated bag 4 has been received. As shown in FIG. 10, the warehousing details information 81 has management No52, warehousing date 82, employee No54, etc., and management No52 is a main key.
The warehousing date 82 is the date on which the exclusive bag 4 was received.

FIG. 11 is a diagram illustrating an example of the delivery destination information 91.
The delivery destination information 91 is master information of a store that delivers the dedicated bag 4. As shown in FIG. 11, the delivery destination information 91 includes a delivery destination No 53, a store name 92, a station name 93, a business consignment 94, a delivery course 95, etc., and the delivery destination No. 53 is the main key.
The store name 92 is a name of a delivery destination store.
The station name 93 is the name of the station where the delivery destination store is located.
The business consignee 94 is the name of a company that consigns the business of the delivery destination store.
The delivery course 95 is a course delivered by the collection and delivery vehicle 9 and is, for example, a train route.

  Next, details of the operation of the cash collection / delivery management system 1 in the various processes shown in FIG. 1 will be described with reference to FIGS. 12 to 19.

[Preparation 101]
FIG. 12 is a diagram illustrating an example of a screen transition of the preparatory process displayed on the reader / writer 15.
First, when information on the dedicated bag 4 is input from the terminal 11, the input information is held by the server 13 as the dedicated bag information 51, and the terminal 11 instructs the printer 17 to print the addressed printed material 6 with barcode.

  Next, when <link> is selected from a menu screen (not shown) displayed on the display unit 34 of the reader / writer 15, the control unit 31 of the reader / writer 15 displays the display unit as shown in FIG. A message of “address tag barcode reading” is displayed on the screen 34 (201). Then, when the reader / writer 15 is placed over the barcode of the printed addressed product 6 with barcode, the barcode scanner unit 35 of the reader / writer 15 reads the barcode information. Here, the barcode information is the management number 52 of the dedicated bag 4. In the example illustrated in FIG. 12, the management number 52 is “0001”.

  Next, the control unit 31 of the reader / writer 15 displays a message “IC tag write” on the display unit 34 (202). When the reader / writer 15 is held over the IC tag 5, the control unit 31 of the reader / writer 15 writes the read barcode information into the memory 41 of the IC tag 5 via the communication unit 37.

Next, the control unit 31 of the reader / writer 15 displays the message “Completed. Management No: 0001” on the display unit 34 (203).
The pre-preparation process is completed by performing the above process on all dedicated bags 4 that need to be prepared.

[Shipping 102]
FIG. 13 is a diagram illustrating an example of a screen transition of the exit process displayed on the reader / writer 15.
First, when <departing special bag> is selected from a menu screen (not shown) displayed on the display unit 34 of the reader / writer 15, the control unit 31 of the reader / writer 15 inputs the employee No. 54 on the display unit 34. A message prompting the user is displayed (not shown). When employee No. 54 is input via the input unit 33 of the reader / writer 15, the control unit 31 of the reader / writer 15 displays a message “Employee No .: 999999” on the display unit (301). In the example shown in FIG. 13, the input employee number 54 is “999999”.

  Next, the control unit 31 of the reader / writer 15 displays a message “IC tag read” on the display unit 34 (302). When the reader / writer 15 is held over the IC tag 5, the control unit 31 of the reader / writer 15 reads the management number 52 from the memory 41 of the IC tag 5 via the communication unit 37 and calculates the number of readings.

Next, the control unit 31 of the reader / writer 15 displays a message of “management No. 0001 / number of readings: 1” on the display unit 34 (303).
The delivery process is performed by performing the above process on all the dedicated bags 4 to be delivered. The input of employee No. 54 can be omitted from the second case. In the above processing, the IC tag 5 can be collectively read.
When the reading of the IC tag is completed for all the dedicated bags 4, the number of items to be shipped is checked.

FIG. 14 is a flowchart showing details of the operation of the reader / writer 15 in the delivery process.
As illustrated in FIG. 14, the reader / writer 15 acquires the planned number of items to be delivered from the server 13 via the terminal 11 (S401). Here, the planned delivery number is the number of data of the dedicated bag information 51 searched using the employee No. 54 and the scheduled delivery date 55 as keys. In addition, when checking the planned number of delivery for each delivery destination, delivery destination No. 53 may be further included in the key.

Next, the reader / writer 15 reads the IC tag 5 of the dedicated bag 4 (S402), and adds the number of readings (S403). Then, the reader / writer 15 checks whether or not the processing has been completed for all the dedicated bags 4 (S404).
If the process has not been completed, the process is repeated from S402.
If the process has been completed, the process proceeds to S405.

Next, the reader / writer 15 confirms whether or not the planned delivery number matches the number of readings (S405).
If they match, the process ends.
If they do not match, the reader / writer 15 displays a message prompting confirmation whether there is any dedicated bag 4 that has not read the IC tag (S406), and ends the process.
By the above processing, it can be checked whether or not the dedicated bag 4 has been left out.
The information acquired by the reader / writer 15 is, for example, transmitted from the reader / writer 15 to the terminal 11 at once after the work for one day is completed, and is transmitted from the terminal 11 to the server 13. Then, the server 13 holds the delivery details information 61.

[Delivery 103]
In delivery of the exclusive bag 4 to the retail store 3, a predetermined slip is filled in. In the slip, for example, the store name of the delivery destination, the delivery date, the number of dedicated bags 4 delivered, etc. are entered.

[Reception 104]
FIG. 15 is a diagram illustrating an example of screen transition of the reception process displayed on the reader / writer 15.
First, when <Receive Special Bag> is selected from a menu screen (not shown) displayed on the display unit 34 of the reader / writer 15, the control unit 31 of the reader / writer 15 inputs the employee No 54 on the display unit 34. A message prompting the user is displayed (not shown). When the employee No. 54 is input via the input unit 33 of the reader / writer 15, the control unit 31 of the reader / writer 15 displays a message “Employee No. 999999” on the display unit 34 (501). In the example illustrated in FIG. 15, the input employee number 54 is “999999”.

  Next, the control unit 31 of the reader / writer 15 displays an “IC tag read” message on the display unit 34 (502). When the reader / writer 15 is held over the IC tag 5, the control unit 31 of the reader / writer 15 reads the management number 52 from the memory 41 of the IC tag 5 via the communication unit 37 and calculates the number of readings.

Next, the control unit 31 of the reader / writer 15 displays the message “management No. 0001 / number of readings: 1” on the display unit 34 (503).
By performing the above processing on all the exclusive bags 4 received from the retail store 3, the receiving processing is performed. The input of employee No. 54 can be omitted from the second case. In the above processing, the IC tag 5 can be collectively read.
The information acquired by the reader / writer 15 is, for example, transmitted from the reader / writer 15 to the terminal 11 at once after the work for one day is completed, and is transmitted from the terminal 11 to the server 13. Then, the server 13 holds the receipt details information 71.

[Receiving 105]
FIG. 16 is a diagram illustrating an example of screen transition of the warehousing process displayed on the reader / writer 15.
First, when <Receive dedicated bag> is selected from a menu screen (not shown) displayed on the display unit 34 of the reader / writer 15, the control unit 31 of the reader / writer 15 inputs the employee No. 54 on the display unit 34. A message prompting the user is displayed (not shown). When the employee No. 54 is input via the input unit 33 of the reader / writer 15, the control unit 31 of the reader / writer 15 displays a message “Employee No .: 999999” on the display unit 34 (601). In the example illustrated in FIG. 16, the input employee number 54 is “999999”.

  Next, the control unit 31 of the reader / writer 15 displays a message “IC tag read” on the display unit 34 (602). When the reader / writer 15 is held over the IC tag 5, the control unit 31 of the reader / writer 15 reads the management number 52 from the memory 41 of the IC tag 5 via the communication unit 37 and calculates the number of readings.

Next, the control unit 31 of the reader / writer 15 displays the message “management No. 0001 / number of readings: 1” on the display unit 34 (603).
The warehousing process is performed by performing the above processing on all the dedicated bags 4 that are warehousing. The input of employee No. 54 can be omitted from the second case. In the above processing, the IC tag 5 can be collectively read.
When reading of the IC tag 5 is completed for all the dedicated bags 4, the number of warehousing is checked.

FIG. 17 is a flowchart showing details of operations of the terminal 11 and the server 13 in the warehousing process.
As illustrated in FIG. 17, the terminal 11 acquires a list of management numbers 52 of the dedicated bag 4 received from the reader / writer 15 (S701). Next, the terminal 11 transmits a list of management numbers 52 of the dedicated bag 4 that has been received to the server 13 (S702).

  Next, the server 13 acquires a list of management No. 52 of the dedicated bag 4 scheduled to be stored (S703). Here, the list of management No. 52 of the dedicated bag 4 scheduled to be stored is, for example, a list of management No. 52 of the dedicated bag information 51 searched using the employee No. 54 and the scheduled storage date 56 as keys. Further, when all employees are collated together, the employee number 54 need not be included in the key. Then, the server 13 collates the list of management No. 52 of the dedicated bag 4 that has been received with the list of management No. 52 of the dedicated bag 4 that is scheduled to be stored (S704), and transmits the collation result to the terminal 11 (S705).

Next, the terminal 11 checks whether or not the collation result is excessive or insufficient (S706).
When there is excess or deficiency, the terminal 11 displays the management No. 52 of the dedicated bag 4 that is the subject of excess or deficiency (S707), and ends the process.
If there is no excess or deficiency, the terminal 11 displays a “warehouse OK” message (S708) and ends the process.
By the above processing, it can be checked whether or not there is an omission in the dedicated bag 4.
The information acquired by the reader / writer 15 is, for example, transmitted from the reader / writer 15 to the terminal 11 at once after the work for one day is completed, and is transmitted from the terminal 11 to the server 13. The server 13 holds the receipt details information 81.

[Search 106]
FIG. 18 is a diagram illustrating an example of a dedicated bag exchange search screen displayed on the terminal 11.
As shown in FIG. 18, the dedicated bag exchange search screen includes an area 1001 for inputting search conditions, an area 1007 for displaying search results, a detail confirmation button 1016, and the like.
FIG. 18 shows the search result displayed by searching the dedicated bag information 51 and the like held by the server 13 when the course condition is “A line”, the station name condition is “no condition (blank)”, and the state condition is “all”. It is.

The search condition input area 1001 includes a pull-down menu 1002 for inputting course conditions, a pull-down menu 1003 for inputting station name conditions, a pull-down menu 1004 for inputting state conditions, a search button 1005, a condition clear button 1006, and the like.
A pull-down menu 1002 for inputting course conditions is used to input a route serving as a delivery course for the dedicated bag 4.
A pull-down menu 1003 for inputting a station name condition is for inputting a station of a delivery destination store.
A pull-down menu 1004 for inputting a state condition is used to input a state indicating whether all the number of goods issued, the number of goods received, and the number of goods received in the dedicated bag 4 match, and “all”, “match”, and “not match” are entered. Either can be selected.
A search button 1005 is used to instruct a search based on an input condition.
The condition clear button 1006 instructs to return the input condition to the initial state.

An area 1007 for displaying the search result has display items such as a delivery date 1008, a station name 1009, a store name 1010, a business consignment 1011, a delivery number 1012, a receipt number 1013, a receipt number 1014, and a status 1015.
One line of the search result is a collection of data having the same delivery date 1008 and delivery destination No. 53, the delivery date 1008 is delivery details information 61, the station name 1009, the store name 1010, and the outsourcing destination 1011 is delivery destination information. 91 is acquired and displayed. That is, for one line of the search result, the exclusive bag information 51 and the shipping details information 61 are internally combined by the management No. 52 which is both primary keys, and the delivery destination information 91 is externally combined by the delivery destination No. 53, and the exclusive bag information A collection of 51 delivery destinations No. 53 and a delivery date 62 of the delivery details information 61 as an aggregation key is displayed. Although the search key differs depending on the input search condition, in the example shown in FIG. 18, the delivery course 95 of the delivery destination information 91 is the search key.
The number of outgoings 1012 is the number of records when the searched dedicated bag information 51 and the outgoing details information 61 are combined by the management No. 52 and the delivery destination No. 53 of the dedicated bag information 51 is tabulated as a total key.
The number of receipts 1013 is the number of records when the searched dedicated bag information 51 and the receipt details information 71 are combined with the management No. 52 and the delivery destination No. 53 of the dedicated bag information 51 is tabulated using the aggregation key.
The number of warehousing 1014 is obtained by combining the searched dedicated bag information 51 and the warehousing details information 81 with the management No. 52 and totaling the delivery destination No. 53 of the dedicate bag information 51 and the warehousing date 82 of the warehousing details information 81 as an aggregation key. Is the number of records.
The state 1015 is “match” when the number of exits 1012, the number of receipts 1013, and the number of receipts 1014 all match, and “no match” when either does not match.

  The detail confirmation button 1016 is used to instruct the display of the detail confirmation screen for one line selected from the area 1007 for displaying the search result.

  As described above, on the delivery / reception search screen for the dedicated bag, the number of delivery, receipt and receipt of the dedicated bag 4 are displayed for each delivery destination No. 53 and delivery date 62. Can be confirmed.

FIG. 19 is a diagram illustrating an example of a detail confirmation screen displayed on the terminal 11.
As shown in FIG. 19, the detail confirmation screen includes an area 1101 for displaying common information, an area 1106 for displaying detailed information, and the like.
The example shown in FIG. 19 is a detail confirmation screen displayed when the second item is selected from the search results in FIG. 18 and the detail confirmation button 1016 is pressed.

  The area 1101 for displaying common information includes display items such as a delivery date 1102, a station name 1103, a store name 1104, and a sales contractor 1105. These display items are the same as the delivery date 1008, the station name 1009, the store name 1010, and the sales contractor 1011 shown in FIG.

The area 1106 for displaying detailed information has display items such as management No. 1107, delivery 1108, receipt 1109, receipt 1110, and status 1111. The detailed information is obtained by internally connecting the exclusive bag information 51 and the shipping details information 61 with the management No. 52 and searching and displaying the delivery destination No. 53 of the dedicated bag information 51 and the shipping date 62 of the shipping details information 61 as search keys. It is.
The management No. 1107 is acquired from the dedicated bag information 51 or the shipping details information 61 and displayed.
The delivery 1108 displays “◯” when the record of the management No. 52 corresponding to the delivery detail information 61 exists, and displays “X” when there is no record.
The receipt 1109 displays “◯” when the record of the management No. 52 corresponding to the receipt details information 71 exists, and “x” when there is no record.
The warehousing 1110 displays “◯” when the record of the management No. 52 corresponding to the warehousing details information 81 is present, and displays “X” when it does not exist.
In the state 1111, “match” is displayed when all of the delivery 1108, the receipt 1109, and the receipt 1110 are “◯”, and “non-match” is displayed when any of them is “×”.

  As described above, on the detail confirmation screen, it is displayed for each management No. 52 whether or not delivery, receipt, and entry have been performed, and it is possible to confirm in detail how far the exclusive bag 4 has been exchanged.

  As described above in detail, according to the embodiment of the present invention, when the dedicated bag 4 is discharged, the reader / writer 15 performs batch reading of the IC tags 5 of the discharged dedicated bag 4. As a result, it is possible to reduce the work time for unloading the special bag 4. Further, the reader / writer 15 confirms whether or not the planned delivery number matches the number of readings. As a result, it can be checked whether or not the dedicated bag 4 has been left out.

  When the dedicated bag 4 is received, the reader / writer 15 performs batch reading of the IC tags 5 of the received dedicated bag 4. As a result, it is possible to reduce the work time for warehousing the dedicated bag 4. Further, the server 13 collates the list of management No. 52 of the dedicated bag 4 that has been received with the list of management No. 52 of the dedicated bag 4 that is scheduled to be received, and the terminal 11 displays the management No. 52 of the dedicated bag 4 that is excessive or insufficient from the comparison result. To do. By this, it can be checked whether there is no omission leakage of the exclusive bag 4.

  Further, when searching for delivery of the exclusive bag 4, the server 13 totals the number of deliveries, the number of receipts, and the number of receipts of the dedicated bag 4 for each delivery destination No. 53 and delivery date 62. , Whether the number of receipts and the number of warehousing matches all. This makes it possible to confirm whether or not the exclusive bag 4 is being exchanged correctly. In addition, when confirming the details, the terminal 11 displays whether the delivery, receipt, and receipt have been performed for each management No. 52 of the dedicated bag 4. This makes it possible to confirm in detail how far the dedicated bag 4 has been exchanged.

  The database held by the server 13 is not limited to the table design shown in FIGS. The database table design is performed in consideration of the processing speed, the amount of data, and the like, and any table design may be used as long as similar information can be held.

  Further, the search screen is not limited to the screen design shown in FIG. In the example shown in FIG. 18, the search results are aggregated and displayed for each delivery date and each delivery destination, but may be aggregated and displayed for each delivery date and each station name. A delivery course may be added and displayed for each delivery date and delivery course.

  The preferred embodiments of the cash collection and delivery management system and the like according to the present invention have been described above with reference to the accompanying drawings, but the present invention is not limited to such examples. It will be apparent to those skilled in the art that various changes or modifications can be conceived within the scope of the technical idea disclosed in the present application, and these naturally belong to the technical scope of the present invention. Understood.

The figure which shows the outline of cash collection delivery management business Figure showing address card 7 The figure which shows schematic structure of the cash collection delivery management system 1 Hardware configuration diagram of the terminal 11 Hardware configuration of reader / writer 15 Hardware configuration diagram of IC tag 5 The figure which shows an example of the exclusive bag information 51 The figure which shows an example of the delivery details information 61 The figure which shows an example of receipt details information 71 The figure which shows an example of the receipt details information 81 The figure which shows an example of the delivery destination information 91 The figure which shows an example of the screen transition of the preparatory process displayed on the reader / writer 15 The figure which shows an example of the screen transition of the leaving process displayed on the reader / writer 15 The flowchart which shows the detail of operation | movement of the reader / writer 15 in the delivery process. The figure which shows an example of the screen transition of the reception process displayed on the reader / writer 15 The figure which shows an example of the screen transition of the warehousing process displayed on the reader / writer 15 A flowchart showing details of operations of the terminal 11 and the server 13 in the warehousing process. The figure which shows an example of the search screen displayed on the terminal 11 The figure which shows an example of the detail confirmation screen displayed on the terminal 11

Explanation of symbols

1 ……… Cash collection and delivery management system 2 ……… Cash collection and delivery center 3 ……… Retail store 4 ……… Dedicated bag 5 ……… IC tag 6 ……… Address printed matter with barcode 7 ……… Address tag 9 ......... collection and delivery car 11 ......... terminal 13 ......... server 15 ......... reader / writer 17 ......... printer 19 ......... network 51 ......... dedicated bag information 61 ......... exit details 71 ... ... Received item information 81 ... …… Receiving item information 91 ... …… Delivery address information

Claims (11)

A cash collection / delivery management system in which at least one terminal and a server are connected to a network and manage collection and delivery of cash using a dedicated bag and a reader / writer with an IC tag attached thereto,
The reader / writer is
Means for writing a management number for uniquely identifying the dedicated bag on the IC tag;
When the dedicated bag is issued, the IC tags attached to the dedicated bag are collectively read, and whether the number of the management numbers read and the planned number of items obtained from the server via the terminal match. Means to confirm,
The cash collection delivery management system characterized by comprising. The terminal
Means for acquiring a list of the management numbers of the dedicated bag that has been received from the reader / writer when the dedicated bag is received;
Comprising
The server
Means for collating the list of management numbers of the dedicated bag that has been received with the list of management numbers of the dedicated bag that is scheduled to be received;
Comprising
The terminal
Means for displaying the management number of the dedicated bag having an excess or deficiency from the verification result;
The cash collection and delivery management system according to claim 1, further comprising: The server
Means for holding delivery details information indicating that the dedicated bag has been issued, receipt details information indicating that the dedicated bag has been received, and receipt details information indicating that the dedicated bag has been received;
Means for aggregating the number of goods issued, the number received, and the number of goods received from the goods exit details information, the receipt details information, and the goods receipt details information;
Comprising
The terminal
Means for displaying whether the number of goods issued, the number received, and the number of goods received all match,
The cash collection and delivery management system according to claim 1 or 2, further comprising: The terminal
Means for displaying whether the delivery, receipt and receipt have been performed for each management number of the dedicated bag;
The cash collection and delivery management system according to claim 3, further comprising: A terminal connected to a server via a network and having a function of reading an IC tag attached to a dedicated bag;
Means for reading the list of management numbers of the dedicated bags that have been received, and transmitting them to the server when the dedicated bags are received;
The server receives a result of collating the management number list of the dedicated bag that has been received and the management number list of the dedicated bag that is scheduled to be received, and the management number of the dedicated bag that is excessive or insufficient from the verification result Means for displaying,
A terminal comprising: Means for receiving, from the server, the number of goods issued, the number received, and the number of goods received from the dedicated bag, and whether or not all match;
The terminal according to claim 5, further comprising: Means for receiving, from the server, detailed information on the delivery, receipt and receipt for each management number of the dedicated bag, and displaying whether or not the delivery, receipt and receipt have been performed for each management number of the dedicated bag;
The terminal according to claim 6, further comprising: A server connected to a terminal having a function of reading an IC tag attached to a dedicated bag via a network,
Means for collating the list of management numbers of the dedicated bag that has been received with the list of management numbers of the dedicated bag that is scheduled to be received;
Means for transmitting a verification result to the terminal;
A server comprising: Means for holding delivery details information indicating that the dedicated bag has been issued, receipt details information indicating that the dedicated bag has been received, and receipt details information indicating that the dedicated bag has been received;
Means for aggregating the number of goods issued, the number received, and the number of goods received from the goods exit details information, the receipt details information, and the goods receipt details information;
Means for transmitting the counting results to the terminal;
The server according to claim 8, further comprising:   A program that causes a computer to function as the terminal according to any one of claims 5 to 7.   A program that causes a computer to function as the server according to claim 8 or 9.

Images