Terminal and its program
An information processing device within an electronic receipt management server accurately identifies and updates OTC drug data, addressing asynchronous updates and ensuring precise OTC drug record management.
Patent Information
- Application Number
- JP2024033144
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2024-03-05
- Publication Date
- 2025-12-05
- Estimated Expiration
- 2038-01-04
AI Technical Summary
The existing electronic receipt systems fail to accurately reflect information on Over-the-Counter (OTC) drugs in the data files due to asynchronous updates between product master files and OTC drug setting files, leading to missing data for OTC drugs in consumer-specific management.
An information processing device, integrated with an electronic receipt management server, detects and maintains a list of OTC drugs not reflected in the OTC drug setting file by comparing product data from receipt data with the OTC drug setting file, and notifies administrators to update the OTC drug setting file.
Ensures accurate extraction and management of OTC drug information, preventing missing data and enabling precise tax deductions by maintaining up-to-date OTC drug records.
Smart Images

Figure 0007781200000001 
Figure 0007781200000002 
Figure 0007781200000003
Abstract
Description
[Technical Field]
[0001] An embodiment of the present invention comprises: Terminal and its Regarding the program. [Background technology]
[0002] Japan has introduced a self-medication tax system to promote self-medication. The self-medication tax system allows individuals to receive income tax deductions for the purchase of prescription drugs and over-the-counter (OTC) drugs (hereafter simply referred to as "OTC drugs"). For example, from January 1, 2017, to December 31, 2021, if a household's total annual purchases of OTC drugs (including consumption tax) exceed 12,000 yen, the excess amount (A = total - 12,000 yen; A is capped at 88,000 yen) can be deducted from income tax. To comply with this tax system, consumers must keep receipts issued by pharmacies and other institutions when they purchase OTC drugs.
[0003] An electronic receipt system is effective for managing such receipts. An electronic receipt system stores receipt data, including sales data for products purchased by a consumer in a single transaction, in association with each consumer on a server, for example. The system then makes it possible for the consumer to view the receipt for the transaction of their choice on the information terminal they use.
[0004] To comply with the self-medication tax system using such an electronic receipt system, a data file containing information on OTC drugs is required. For example, a server that stores receipt data can detect which products a consumer has purchased from the stored receipt data and check whether information on those products exists in the data file. If information exists, the server manages the purchase information for those products as OTC drug purchase information for each consumer. The server can provide consumers with tax return forms that comply with the self-medication tax system based on the OTC drug purchase information managed for each consumer.
[0005] OTC drug data files are updated regularly, for example, every two months, based on information on the launch and discontinuation of OTC drug sales provided by manufacturers and distributors. In contrast, product files, which are queried by POS terminals and other devices when products are sold in stores and serve as the master data for each product included in each transaction receipt, are updated more frequently over a shorter period of time. Therefore, even if a newly sold OTC drug is treated as an OTC drug in the receipt data, the information may not be reflected in the data file. In such cases, the data for that OTC drug may be missing from the consumer-specific management data. [Prior art documents] [Patent documents]
[0006] [Patent Document 1] International Publication No. 2017 / 056443 Summary of the Invention [Problem to be solved by the invention]
[0007] The problem to be solved by the embodiments of the present invention is to provide a system for storing information on OTC medicines based on receipt data. data It is possible to accurately extract OTC drugs whose information is not reflected in the file. Electronic receipt system terminal The aim is to provide the following. [Means for solving the problem]
[0008] In one embodiment, The terminal includes a display device, a transmitting means, a receiving means, and a display control means. And, it is equipped with. The transmission means is an electronic receipt management server. Is it information about purchased items included in receipt data? et al., year Information indicating that the product is subject to a tax system that allows tax deductions when the purchase amount is within a specified amount range The electronic receipt management server transmits a maintenance command requesting the creation of a maintenance list including the product name of the purchased product and the date on which it was confirmed that the purchased product does not exist in the storage unit, the maintenance list being created using data identifying the purchased product for which the target product has been detected and data identifying the purchased product that does not exist in the storage unit that stores the data identifying the target product. The receiving means receives display data for the maintenance list from the electronic receipt management server that transmitted the maintenance command. The display control means displays the maintenance list on the display device based on the received display data. [Brief explanation of the drawings]
[0009] [Figure 1] FIG. 1 is a schematic diagram showing a general configuration of an electronic receipt system. [Figure 2] FIG. 4 is a schematic diagram showing the structure of receipt data. [Figure 3] FIG. 2 is a schematic diagram showing an example of a product master file. [Figure 4] FIG. 2 is a block diagram showing the main circuit configuration of an electronic receipt management server. [Figure 5] FIG. 2 is a schematic diagram showing main data files formed in an auxiliary storage device of the electronic receipt management server. [Figure 6] FIG. 6 is a schematic diagram showing the structure of store data stored in the store file of FIG. 5. [Figure 7] 6 is a schematic diagram showing the structure of product data stored in the OTC drug setting file of FIG. 5. [Figure 8] FIG. 6 is a schematic diagram showing the structure of maintenance data stored in the maintenance file of FIG. 5. [Figure 9] 10 is a flowchart showing the main steps of a process for tallying up purchase amounts for OTC medicines by member, which is executed by the CPU of the electronic receipt management server. [Figure 10] 10 is a flowchart showing the main steps of a process for tallying up purchase amounts for OTC medicines by member, which is executed by the CPU of the electronic receipt management server. [Figure 11] 10 is a flowchart showing the main steps of an OTC drug check process executed by a CPU of the electronic receipt management server. [Figure 12]10 is a flowchart showing the main steps of a maintenance process for an OTC drug setting file executed by a CPU of the electronic receipt management server. [Figure 13] FIG. 4 is a schematic diagram showing an example of a display of a maintenance screen SC. DETAILED DESCRIPTION OF THE INVENTION
[0010] Below is a list of OTC drug information based on receipt data. data An embodiment of an information processing device that can accurately extract OTC drugs whose information is not reflected in a file will be described with reference to the drawings. Note that this embodiment is a case where the electronic receipt management server 10 of the electronic receipt system 100 shown in FIG. 1 is provided with the function of the information processing device.
[0011] As shown in FIG. 1, the electronic receipt system 100 includes an electronic receipt management server 10, a plurality of POS (Point Of Sales) systems 20, a network 30 such as the Internet, a plurality of base stations 40 connected to the network 30, a plurality of information terminals 50 capable of wireless communication with the base stations 40, and an administrator terminal 60. The electronic receipt management server 10 is established in an electronic receipt management center that oversees the electronic receipt service. The POS systems 20 are established in each store that is a member of the electronic receipt service. The information terminals 50 are used by consumers who have registered as members to receive the electronic receipt service. The administrator terminal 60 is used by the administrator of the electronic receipt management server 10.
[0012] The POS system 20 includes multiple POS terminals 21, a store server 22, and a printer 23, which are connected by a communication line 24 such as a LAN (Local Area Network). The POS terminals 21 function as payment terminals for commercial transactions. The store server 22 manages sales, inventory, and the like for the entire store based on data on commercial transactions settled at each POS terminal 21. The printer 23 is capable of printing various types of slips. The printer 23 may be a dedicated printer, or may be a multifunction printer with multiple functions such as copying and facsimile.
[0013] The POS system 20, which functions as part of the electronic receipt system 100, has a member ID reception function and a receipt data generation function. A member ID is personal identification information issued to consumers who have registered as members to receive the electronic receipt service. The member ID reception function is provided in the POS terminal 21.
[0014] When the POS system 20 accepts input of a member ID at the POS terminal 21, it converts receipt print data, which indicates the details of a commercial transaction for the consumer identified by the member ID, into a structured format to create electronic receipt data 25 (see FIG. 2). The POS system 20 then outputs the receipt data 25 together with the member ID to the electronic receipt management server 10 via the network 30. The process of converting the receipt print data into a structured format may be performed by the POS terminal 21 or the store server 22. When the process of converting the receipt print data into a structured format is performed by the POS terminal 21, the receipt data 25 may be output directly from the POS terminal 21 to the electronic receipt management server 10 via the network 30, or may be output via the store server 22. When the process of converting the receipt print data into a structured format is performed by the store server 22, the receipt data 25 is output from the store server 22 to the electronic receipt management server 10 via the network 30. The process of converting receipt print data into a structured format is a well-known technique, so a detailed description thereof will be omitted here.
[0015] 2 is a schematic diagram showing the structure of receipt data 25. Receipt data 25 includes a member ID, a store code, a transaction date and time, a transaction number, product sales data, and payment data. The product sales data includes a product code, a classification code, a product name, a unit price, a quantity, and an amount. The payment data includes a payment amount, a payment type, payment information, and the like.
[0016] The store code is a unique code assigned to each store to identify it. The transaction date and time is, for example, the date and time when a transaction is initiated or settled at the POS terminal 21. The transaction number is a unique number assigned to each transaction. The product code is a unique code assigned to each product to identify it. The classification code is a unique code assigned to each product classification to identify the product classification (food, daily necessities, medical supplies, clothing, etc.) based on the attributes of each product. The product name is the name given to the product identified by the corresponding product code, and the unit price is the price per item. The points are the number of the same product purchased in one transaction, and the amount is calculated by multiplying the unit price by the points. The payment amount is the amount paid by the member to settle the transaction. The payment type is information specifying the type of payment for the payment amount (cash, credit card, points, gift certificate, etc.), and the payment information is the amount paid for that payment type.
[0017] Returning to Figure 1. The store server 22 manages a product master file 26. The product master file 26 stores basic information about each product sold in the store. The basic information includes items such as product code, classification code, product name, and unit price.
[0018] Fig. 3 is a schematic diagram showing an example of a product master file 26. In Fig. 3, product master file 26A is managed by the store server 22 of the first store. Product master file 26B is managed by the store server 22 of the second store. The first store and the second store are both pharmacies, drug stores, dispensing pharmacies, etc. that sell OTC drugs. The first store and the second store are operated by different corporate entities.
[0019] In FIG. 3, product "Drug B" with product code "2222222222" is an OTC drug. In product master file 26A, a star mark is added to the beginning of the product name of product "Drug B." In product master file 26B, a double circle mark is added to the beginning of the product name of product "Drug B." The star mark is a mark established by the corporate entity operating the first store as information for identifying the product as an OTC drug, i.e., a product eligible for tax deductions when the annual purchase amount is within a specified amount range. Similarly, the double circle mark is a mark established by the corporate entity operating the second store as information for identifying the product as an eligible product.
[0020] Incidentally, with the introduction of the self-medication tax system, receipts and other proof documents must clearly indicate that the product is an OTC drug, along with the product name, price, store name, and purchase date. There are two ways to indicate that a product is an OTC drug: by adding the above-mentioned mark before the product name and stating on the proof document that the product with this mark is an OTC drug, or by listing the total price for OTC drugs separately.
[0021] Returning to Figure 1 again, the explanation will be made. The information terminal 50 includes at least a display device, an input device, and a wireless communication device. The information terminal 50 also includes a web browser. A consumer who receives the electronic receipt service installs an electronic receipt viewing program, which is a dedicated application program, into the information terminal 50. Installing this electronic receipt viewing program in the information terminal 50 enables member registration, viewing of receipt images, and output of tax return forms that comply with the self-medication tax system. By registering as a member, a member ID is set in the management area of the electronic receipt viewing program formed in the memory of the information terminal 50. Electronic devices such as smartphones, mobile phones, tablet terminals, and laptop computers can be used as this type of information terminal 50.
[0022] The electronic receipt management server 10 stores receipt data 25 output from the POS system 20 of each store for a certain period of time. Then, in response to a viewing request from the information terminal 50, the electronic receipt management server 10 transmits receipt image data created based on the receipt data 25 to the information terminal 50 that made the viewing request. Furthermore, in response to a creation request from the information terminal 50, the electronic receipt management server 10 creates a tax return form that complies with the self-medication tax system. The form can be printed out, for example, via the printer 23 of the POS system 20.
[0023] The administrator terminal 60 includes at least a display device, an input device, and a communication unit for the network 30. The administrator terminal 60 is capable of data communication with the electronic receipt management server 10 via the network 30. The administrator terminal 60 is used for maintenance of data files managed by the electronic receipt management server 10. In other words, an application program for controlling the maintenance of the data files is installed in the administrator terminal 60. The data files to be maintained will be described later. The maintenance processing procedure will also be described later. A personal computer, a smartphone, a tablet terminal, etc. may be used as this type of administrator terminal 60.
[0024] 4 is a block diagram showing the main circuit configuration of the electronic receipt management server 10. The electronic receipt management server 10 includes a CPU (Central Processing Unit) 11, a ROM (Read Only Memory) 12, a RAM (Random Access Memory) 13, an auxiliary storage device 14, a clock unit 15, and a communication unit 16. The CPU 11, the ROM 12, the RAM 13, the auxiliary storage device 14, the clock unit 15, and the communication unit 16 are connected to each other by a system transmission path 17 such as an address bus or a data bus.
[0025] The electronic receipt management server 10 is configured as a computer including a CPU 11, a ROM 12, a RAM 13, an auxiliary storage device 14, and a system transmission line 17 connecting these components. The CPU 11 corresponds to the central part of the computer. The CPU 11 controls each part to realize various functions of the electronic receipt management server 10 in accordance with an operating system and application programs.
[0026] The ROM 12 corresponds to the main memory of the computer. The ROM 12 stores the operating system and application programs. The ROM 12 may also store data necessary for the CPU 11 to execute processes for controlling each unit.
[0027] The RAM 13 corresponds to the main memory of the computer. The RAM 13 stores data necessary for the CPU 11 to execute processing. The RAM 13 is also used as a work area where information is rewritten by the CPU 11 as needed.
[0028] The auxiliary storage device 14 corresponds to the auxiliary storage portion of the computer. The auxiliary storage device 14 may store the operating system and application programs. The auxiliary storage device 14 may also store data used by the CPU 11 when performing various processes, or data generated by the processes in the CPU 11. The auxiliary storage device 14 may be, for example, an EEPROM (Electric Erasable Programmable Read-Only Memory), an HDD (Hard Disc Drive), or an SSD (Solid State Drive).
[0029] The clock unit 15 keeps track of the current date and time. The communication unit 16 performs data communication with the POS system 20, the information terminal 50, or the administrator terminal 60 via the network 30 using a predetermined protocol.
[0030] As shown in FIG. 5, the electronic receipt management server 10 configured as above uses part of the memory area of the auxiliary memory device 14 as a member file 141, a store file 142, an electronic receipt file 143, a monthly tally file 144, an OTC drug setting file 145, and a maintenance file 146.
[0031] The member file 141 is an area for storing member data created for each consumer who has registered as a member to receive the electronic receipt service. The member data includes information such as a member ID, email address, and password. The email address and password are information that the consumer, identified by the member ID, has arbitrarily set by operating the information terminal 50.
[0032] The store file 142 is an area for storing store data 142R (see FIG. 6) created for each store that is a member of the electronic receipt service. As shown in FIG. 6, the store data 142R includes information such as a store code, a company code, an OTC drug identification mark, and a printer address. The company code is information unique to the business entity that operates the store identified by the store code. The OTC drug identification mark is a mark established by the business entity that operates the store identified by the store code as information for identifying an OTC drug. The printer address is a communication address for identifying the printer 23 incorporated in the POS system 20 of the store identified by the store code. The printer 23 is designated by the store as a device for printing tax return forms that comply with the self-medication tax system.
[0033] The electronic receipt file 143 is an area for storing receipt data 25 received from each POS system 20 via the network 30 for a certain period of time by member ID.
[0034] The monthly tally file 144 is an area for storing monthly tally data created by year and month for each consumer who has registered as a member to receive the electronic receipt service. The monthly tally data is data that totals the purchase amounts of products belonging to each product category for each month. The monthly tally data also includes data that totals the purchase amounts of OTC drugs for each month.
[0035] The OTC drug setting file 145 is an area for storing product data 145R (see FIG. 7) for OTC drugs that have been announced by the Ministry of Health, Labor and Welfare as items subject to the self-medication tax system. As shown in FIG. 7, the product data 145R includes information such as a product code, a product name, and a validity flag. The validity flag is 2-bit information that identifies whether a product identified by the product code is valid as an OTC drug. For example, when the validity flag is "1," the product is valid as an OTC drug. For example, when the validity flag is "0," the product is invalid as an OTC drug. The OTC drug setting file 145 updates the product data 145R periodically, for example, once every two months, based on information such as the start and end of sales of OTC drugs provided to the Ministry of Health, Labor and Welfare by manufacturers and distributors. In this embodiment, the OTC drug setting file 145 is a data file that is subject to maintenance.
[0036] The maintenance file 146 is an area for storing maintenance data 146R (see FIG. 8) for the OTC drug setting file 145 to be maintained. As shown in FIG. 8, the maintenance data 146R includes a product code, a product name, a status, a registration date and time, and an update date and time. The status is information indicating the reflection status of the maintenance data 146R, and the reflection status can be "unprocessed," "registered," or "not registered." For example, status = 0 indicates the reflection status "unprocessed," status = 1 indicates the reflection status "registered," and status = 9 indicates the reflection status "not registered." The registration date and time is the date and time when the maintenance data 146R was registered in the maintenance file 146. The update date and time is the date and time when the reflection status of the maintenance data 146R was updated.
[0037] Here, the OTC drug setting file 145 constitutes a first storage unit, and the maintenance file 146 constitutes a second storage unit. It should be noted that the data items stored in each of the files 141 to 146 are not limited to the above items, and the data may be configured to further include other items.
[0038] Next, the main information processing executed by the CPU 11 of the electronic receipt management server 10 will be described. First, the process of tallying up purchase amounts for OTC medicines by member will be described using Figures 9 and 10. Note that the content of the process shown in Figures 9 and 10 and described below is an example. The procedure and content are not particularly limited as long as similar results can be obtained.
[0039] When the time measured by the clock unit 15 reaches a predetermined time, the CPU 11 starts information processing according to the procedure shown in the flowcharts of Figures 9 and 10. The time can be any time. Also, the number of times defined per day is not limited to one. Two or more times may be defined.
[0040] When the information processing starts, the CPU 11 first resets counter n to "0" as Act 1 in Fig. 9. Counter n is formed in, for example, RAM 13. After resetting counter n, the CPU 11 counts up counter n by "1" as Act 2. Then, the CPU 11 detects the nth member data (n is the count value of counter n) from the member file 141 as Act 3.
[0041] In Act 4, the CPU 11 checks whether or not the n-th member data has been detected from the member file 141. If the n-th member data has been detected (Act 4, YES), in Act 5, the CPU 11 detects the member ID from the n-th member data.
[0042] Next, in Act 6, the CPU 11 searches the electronic receipt file 143 and sequentially reads the receipt data 25 that was newly added to the electronic receipt file 143 after the previous processing. Then, in Act 7, the CPU 11 determines whether the member ID in the receipt data 25 matches the member ID detected in the processing of Act 5. If they do not match, the CPU 11 determines whether the search of the electronic receipt file 143 has ended in Act 8. If the search has not ended (NO in Act 8), the CPU 11 returns to Act 6 and continues searching the electronic receipt file 143.
[0043] When the CPU 11 reads the receipt data 25 including the member ID detected in the processing of Act 5 from the electronic receipt file 143 (Act 7, YES), in Act 11 of Fig. 10, the CPU 11 detects the store code from the receipt data 25. Then, in Act 12, the CPU 11 searches the store file 142, acquires store data 142R including the store code detected in the processing of Act 9, and detects the OTC drug identification mark from the store data 142R.
[0044] Next, in Act 13, the CPU 11 sequentially detects the product sales data from the receipt data 25. Then, in Act 14, the CPU 11 determines whether the OTC drug identification mark detected in the processing of Act 10 is added to the product name included in the product sales data.
[0045] When the CPU 11 detects product sales data with an OTC drug identification mark added to the product name (Act 14, YES), in Act 15, it checks whether valid product data 145R including the product code included in the product sales data exists in the OTC drug setting file 145. Here, valid product data 145R refers to product data 145R whose valid flag is set to "1."
[0046] If the corresponding product data 145R exists in the OTC drug setting file 145 (Act 16, YES), the product sales data detected in the processing of Act 13 is data on the OTC drugs purchased by the member identified by the member ID after the previous processing. In Act 17, the CPU 11 stores the product sales data in the work area of the RAM 13. Then, the CPU 11 proceeds to Act 18.
[0047] On the other hand, if the OTC drug identification mark is not added to the product name (Act 14, NO), the CPU 11 skips the processes of Act 15 to Act 17 and proceeds to Act 18. Also, if the OTC drug identification mark is added to the product name but the corresponding product data 145R does not exist in the OTC drug setting file 145 (Act 16, NO), the CPU 11 skips the process of Act 17 and proceeds to Act 18.
[0048] In Act 18, the CPU 11 determines whether or not the detection of the product sales data has been completed from the receipt data 25 read from the electronic receipt file 143. If the detection has not been completed (Act 18, NO), the CPU 11 returns to the processing of Act 13. Then, the CPU 11 repeats the processing of Act 13 to Act 18 in the same manner as described above.
[0049] In this way, when all product sales data has been detected from the receipt data 25 (Act 18, YES), the CPU 11 proceeds to Act 8 in Fig. 9. That is, the CPU 11 determines whether or not the search of the electronic receipt file 143 has ended. If the search has not ended (Act 8, NO), the CPU 11 returns to Act 6 and continues the search of the electronic receipt file 143.
[0050] When the search of the electronic receipt file 143 is thus completed (Act 8, YES), the CPU 11 performs aggregation processing for each member based on the product sales data of OTC drugs stored in the work area. That is, the CPU 11 searches the monthly aggregation file 144 using the member ID acquired in the processing of Act 5, and adds the amount of the product sales data stored in the work area to the total purchase amount of OTC drugs included in the monthly aggregation data set for that member ID.
[0051] When the counting process is completed, the CPU 11 returns to Act 2. That is, the CPU 11 further counts up the counter n by 1. Then, the CPU 11 detects the nth member data from the member file 141.
[0052] If the n-th member data cannot be found in the member file 141 (Act 4, NO), that is, if the processing from Act 5 onwards has been completed for all member data stored in the member file 141, the CPU 11 ends this information processing.
[0053] Next, the OTC drug check process executed by the CPU 11 each time receipt data 25 is received from the POS system 20 will be described with reference to Figure 11. Note that the process shown in Figure 11 and described below is an example. The procedure and content are not particularly limited as long as similar results can be obtained.
[0054] In Act 21, the CPU 11 waits to receive receipt data. When receipt data 25 is received via the communication unit 16 (Act 21, YES), the CPU 11 resets the determination flag F to "0" in Act 22. The determination flag F is stored in the RAM 13.
[0055] In Act 23, the CPU 11 detects the store code from the receipt data 25. Then, in Act 24, the CPU 11 searches the store file 142 and detects the OTC drug identification mark from the store data 142R that includes the store code detected in the processing of Act 23.
[0056] Next, in Act 25, the CPU 11 sequentially detects the product sales data from the receipt data 25. Then, in Act 26, the CPU 11 determines whether the OTC drug identification mark detected in the processing of Act 24 is attached to the product name included in the product sales data. If the OTC drug identification mark is not attached (Act 26, NO), the CPU 11 proceeds to the processing of Act 33.
[0057] If product sales data with an OTC drug identification mark added to the product name is detected (Act 26, YES), the CPU 11 checks in Act 27 whether valid product data 145R including the product code included in the product sales data exists in the OTC drug setting file 145. If valid product data 145R exists (Act 28, YES), the CPU 11 proceeds to the processing of Act 33.
[0058] On the other hand, if the corresponding product data 145R does not exist in the OTC drug setting file 145 (Act 28, NO), the CPU 11 checks in Act 29 whether maintenance data 146R including the product code and product name of the product sales data to which the OTC drug identification mark has been added is already stored in the maintenance file 146. If the duplicate maintenance data 146R is already stored in the maintenance file 146 (Act 29, YES), the CPU 11 proceeds to the processing of Act 33.
[0059] On the other hand, if the duplicate maintenance data 146R is not saved in the maintenance file 146 (Act 29, NO), the CPU 11 writes and saves the maintenance data 146R including the product code and product name of the product sales data to which the OTC drug identification mark has been added in the maintenance file 146 in Act 30. At this time, the registration date and time and update date and time of the maintenance data 146R are set to the current date and time kept by the clock unit 15.
[0060] When writing to the maintenance file 146 is completed, the CPU 11 checks whether the determination flag F is set to "1" in Act 31. If the determination flag F is not set (NO in Act 31), the CPU 11 sets the determination flag F to "1" in Act 32. If the determination flag F is already set to "1" (NO in Act 31) or if it is set to "1" in Act 32, the CPU 11 proceeds to Act 33.
[0061] In Act 33, the CPU 11 determines whether or not the product sales data has been detected from the receipt data 25. If the detection has not been completed (Act 33, NO), the CPU 11 returns to the process of Act 25. Then, the CPU 11 repeats the processes of Act 25 to Act 33 in the same manner as described above.
[0062] When all product sales data has been detected from the receipt data 25 in this way (Act 33, YES), the CPU 11 checks in Act 34 whether the determination flag F is set to "1." If it is set (Act 33, YES), the CPU 11 notifies the maintenance operator in Act 35 that the maintenance data 146R has been written to the maintenance file 146. Specifically, the CPU 11 automatically sends an email to the administrator terminal 60, and notifies the administrator in the body of the email that the maintenance data 146R has been written to the maintenance file 146. Note that if the determination flag F is reset to "0" in Act 34 (Act 34, NO), the maintenance data 146R has not been written to the maintenance file 146. In this case, the CPU 11 skips the processing in Act 35. This concludes the processing performed by the CPU 11 after receiving the receipt data.
[0063] Here, the computer of the electronic receipt management server 10, which is mainly composed of the CPU 11, constitutes a detecting means by executing the processes of Act 21 to Act 26 in Fig. 11. The same computer also constitutes a storing means by executing the processes of Act 27 to Act 30 in Fig. 11. The same computer also constitutes a notifying means by executing the processes of Act 31 to Act 32 in Fig. 11.
[0064] Thus, if product data 145R including the product code and product name of product sales data with a mark attached to the product name does not exist in the OTC drug setting file 145, maintenance data 146R related to that product sales data is stored in the maintenance file 146.
[0065] Generally, when a manufacturer or distributor provides information regarding the start of sales of an OTC drug, each store updates the product master file 26. The electronic receipt management center also updates the OTC drug setting file 145. However, the timing at which the product master file 26 is updated and the timing at which the OTC drug setting file 145 is updated are not synchronized. For this reason, as described above, there may be a case where the product data 145R containing the product code and product name of the product sales data with a mark added to the product name does not exist in the OTC drug setting file 145. In such a case, in this embodiment, maintenance data 146R containing the product code and product name is stored in the maintenance file 146.
[0066] Next, the maintenance process of the OTC drug setting file 145 executed by the CPU 11 will be described with reference to Figure 12. Note that the content of the process shown in Figure 12 and described below is an example. The procedure and content are not particularly limited as long as similar results can be obtained.
[0067] The operator of the administrator terminal 60, who has confirmed the email informing that the maintenance data 146R has been written to the maintenance file 146, operates the administrator terminal 60 to start the maintenance application program. This starts up a maintenance command from the administrator terminal 60 to the electronic receipt management server 10.
[0068] In Act 41 of FIG. 12, the CPU 11 of the electronic receipt management server 10 waits for a maintenance command. Then, when the CPU 11 detects that a maintenance command has been received via the communication unit 16 (Act 41, YES), in Act 42, the CPU 11 creates display data for a maintenance list based on the maintenance data 146R saved in the maintenance file 146. The maintenance list is a list of maintenance data 146R whose reflection status is "unprocessed." In Act 43, the CPU 11 controls the communication unit 16 to send this display data to the administrator terminal 60. Through this control, the display data for the maintenance list is sent to the administrator terminal 60 via the network 30. In the administrator terminal 60 that has received this display data, a maintenance screen SC (see FIG. 13) is displayed on the display device.
[0069] FIG. 13 is an example of a maintenance screen SC. As shown in FIG. 13, the maintenance screen SC displays a maintenance list L, a registration button B1, and a cancel button B2. The maintenance list L lists the product codes and product names that make up the maintenance data 146R, as well as the registration date and time, update date and time, and reflection status. The registration date and time is the date and time when the data was written to the maintenance file 146 in Act 30 of FIG. 11. The update date and time is the date and time when the reflection status was updated. The maintenance list L displays check boxes CB in association with each product code.
[0070] After checking the maintenance screen SC, the operator selects a product that is publicly announced as an OTC drug from the maintenance list L and checks the corresponding check box CB. Then, the operator presses the registration button B1. When the registration button B1 is pressed, a registration command is sent from the administrator terminal 60 to the electronic receipt management server 10. The registration command includes paired data of the product code and product name that are checked in the corresponding check box CB in the maintenance list L. Note that, if the operator wishes to end the maintenance work without pressing the registration button B1, he or she presses the cancel button B2. When the cancel button B2 is pressed, a cancel command is sent from the administrator terminal 60 to the electronic receipt management server 10.
[0071] The CPU 11 of the electronic receipt management server 10 that has transmitted the display data of the maintenance list checks whether a stop command has been received in Act 44. If a stop command has not been received (Act 44, NO), the CPU 11 checks whether a registration command has been received in Act 45. If a registration command has not been received (Act 45, NO), the CPU 11 returns to Act 44. Thus, the CPU 11 waits for reception of a stop command or a registration command through the processing of Act 44 and Act 45.
[0072] In this standby state, if it is detected that a stop command has been received via the communication unit 16 (Act 44, YES), the CPU 11 ends this process.
[0073] On the other hand, if it is detected that a registration command has been received (Act 45, YES), the CPU 11 detects paired data between a product code and a product name from the registration command in Act 46. Then, the CPU 11 creates product data 145R for the OTC drug including this paired data and adds it to the OTC drug setting file 145. At this time, the valid flag of the product data 145R is set to "1" indicating a valid state.
[0074] Once the product data 145R, including the product code and product name of the paired data included in the registration command, has been added to the OTC drug setting file 145, the CPU 11 updates the status of the maintenance data 146R in Act 47. Specifically, for the maintenance data 146R added to the OTC drug setting file 145, the CPU 11 also updates the reflection status from "unprocessed" to "registered." On the other hand, for the maintenance data 146R not added to the OTC drug setting file 145, the CPU 11 updates the reflection status from "unprocessed" to "not registered." Then, the CPU 11 ends this process.
[0075] Here, the computer of the electronic receipt management server 10, which is mainly composed of the CPU 11, constitutes an additional means by executing the processes of Act 45 and Act 46 in Fig. 12. The same computer also constitutes a receiving means by executing the processes of Act 42 and Act 43 in Fig. 12.
[0076] As described above, the electronic receipt management server 10 of this embodiment can accurately extract OTC drugs whose information is not reflected in the OTC drug setting file 145 based on the receipt data received from the POS system 20 of each store.
[0077] Furthermore, the electronic receipt management server 10 can notify the operator in charge of maintenance that an OTC drug whose information is not reflected in the OTC drug setting file 145 has been extracted.
[0078] Furthermore, according to the electronic receipt management server 10, in response to an instruction from an operator in charge of maintenance, information about OTC drugs that is not reflected in the OTC drug setting file 145 can be added to the OTC drug setting file 145. Therefore, by adding the missing information to the OTC drug setting file 145 before the process of tallying the purchase amounts of OTC drugs by member starts, the electronic receipt management server 10 can accurately manage the purchase information of OTC drugs by consumer.
[0079] However, when updating the product master file 26 at each store, there may be cases where a mark is mistakenly assigned to a product other than an OTC drug. In such cases, in this embodiment, data on the product other than an OTC drug is stored in the maintenance file 146. However, in this embodiment, the electronic receipt management server 10 creates a maintenance list L based on the data stored in the maintenance file 146, displays this maintenance list L on the display device of the administrator terminal 60, and accepts a selection of whether or not to add the list to the OTC drug setting file 145. Therefore, it is possible to prevent data related to a product other than an OTC drug from being mistakenly added to the OTC drug setting file 145.
[0080] Next, the modified sequence of this embodiment will be described.
[0081] In the above embodiment, the electronic receipt management server 10 is provided with the function of the information processing device. In this regard, the function of the information processing device may be provided in a computer device other than the electronic receipt management server 10. In this case, the computer device having the function of the information processing device is connected to the electronic receipt management server 10 via a communication means and includes a maintenance file 146. The computer device then imports the receipt data 25 received by the electronic receipt management server 10 and executes the information processing shown in the flowcharts of FIGS. 11 and 12. By doing so, it is possible to realize a computer device that can accurately extract OTC drugs whose information is not reflected in the OTC drug setting file 145. Such a computer device may be, for example, the administrator terminal 60.
[0082] In the above embodiment, the store data stored in the store file 142 includes an OTC drug identification mark. The electronic receipt management server 10 then searches the store file 142 using the store code included in the receipt data to obtain the mark used at that store. In this regard, the following configuration may be adopted. That is, the receipt data includes a mark added to the product name of an OTC drug, as well as text indicating that the product to which the mark is attached is an OTC drug. The electronic receipt management server 10 analyzes this text to obtain the mark. This eliminates the need to store an OTC drug identification mark for each store in the store file 142.
[0083] In the above embodiment, an OTC drug identification mark is set for each store in the store file 142. However, an OTC drug identification mark may also be set for each business entity that operates the store. In this case, a business entity code that identifies the business entity is included in the receipt data 25. A data file that centrally manages OTC drug identification marks for each business entity code is then provided in the electronic receipt management server 10. This allows OTC drug identification marks to be set for each business entity. Furthermore, by incorporating a store code into the data file, it is also possible to set an OTC drug identification mark by combining a business entity code and a store code.
[0084] Furthermore, the information indicating that the purchased product is an OTC drug does not necessarily have to be a mark. The product sales data included in the receipt data may contain information other than a mark indicating that the product is an OTC drug.
[0085] In the above embodiment, the operator who checks the maintenance screen SC checks the check boxes CB corresponding to products that are published as OTC drugs from the maintenance list L. In this regard, the check boxes CB are checked by default, and the check boxes CB corresponding to products other than OTC drugs may be unchecked.
[0086] In the above embodiment, OTC drugs are used as the subject products of the tax system that allows tax deductions when the annual purchase amount is within a predetermined amount range. The subject products are not necessarily limited to OTC drugs. This embodiment can be similarly applied to other products subject to similar tax systems.
[0087] Note that an information processing device is generally transferred with the program stored in ROM 12 or auxiliary storage device 14. However, this is not limiting, and the program may be transferred without being stored in ROM 12 or auxiliary storage device 14. In this case, the transferred program is written to a writable storage device of the information processing device separately from the information processing device in response to a user's operation. The program can be transferred by recording it on a removable recording medium or by communication via a network. The recording medium may be in any form, such as a CD-ROM or memory card, as long as it can store the program and is readable by the device. Furthermore, functions obtained by installing or downloading a program may be realized in cooperation with the device's internal operating system (OS).
[0088] Although several embodiments of the present invention have been described, these embodiments are presented as examples and are not intended to limit the scope of the invention. These novel embodiments can be embodied in various other forms, and various omissions, substitutions, and modifications can be made without departing from the spirit of the invention. These embodiments and their modifications are included within the scope and spirit of the invention, and are also included in the scope of the invention and its equivalents as defined in the claims. The inventions described in the original claims of this application are set forth below. [1] An information processing device comprising: a detection means for detecting, from information about a purchased item contained in receipt data, information indicating that the purchased item is a product subject to a tax system that allows tax deductions when the annual purchase amount is within a predetermined amount range; and a storage means for storing, in a second storage unit, data identifying the purchased item for which information indicating that the purchased item is a target product has been detected from the information about the purchased item, if the data identifying the target product is not present in a first storage unit that stores data identifying the target product. [2] The information processing device according to appendix [1], further comprising a notification means for notifying an external party that the data identifying the purchased product has been stored in the second storage unit. [3] An information processing device according to appendix [1] or [2], further comprising an adding means for adding data identifying the purchased product stored in the second storage unit to the first storage unit. [4] An information processing device as described in appendix [3], further comprising an acceptance means for accepting whether or not to add the data identifying the purchased product stored in the second memory unit to the first memory unit, wherein the addition means adds the data identifying the purchased product that has been accepted for addition to the first memory unit. [5] An information processing device according to any one of appendices [1] to [4], wherein the detection means checks whether a predetermined mark is attached to the product name included in the information about the purchased product, and if so, detects the mark as information indicating that the product is the target product. [6] A program for causing a computer to function as a detection means for detecting, from information about purchased goods contained in receipt data, information indicating that the purchased goods are subject to a tax system that allows tax deductions when the annual purchase amount is within a specified amount range, and a storage means for storing, in a second storage unit, data identifying the purchased goods for which information indicating that the purchased goods are subject to a tax system is detected from the information about the purchased goods, if the data identifying the purchased goods is not present in a first storage unit that stores data identifying the subject goods. [Explanation of symbols]
[0089] 10...electronic receipt management server, 20...POS system, 21...POS terminal, 22...store server, 23...printer, 25...receipt data, 26...product master file, 30...network, 40...base station, 50...information terminal, 60...administrator terminal, 100...electronic receipt system, 141...membership file, 142...store file, 143...electronic receipt file, 144...monthly summary file, 145...OTC drug setting file, 146...maintenance file.
Claims
1. A display device; a first transmitting means for transmitting to the electronic receipt management server a maintenance command requesting the creation of a maintenance list including data identifying purchased products for which information indicating that the purchased products are subject to a tax system that allows tax deductions when the annual purchase amount is within a predetermined amount range has been detected from information about the purchased products included in receipt data, and the maintenance list including product names of purchased products included in the receipt data but not in the storage unit, the maintenance list being created using data identifying purchased products that do not exist in the storage unit of the electronic receipt management server that stores the data identifying the subject products, and the date on which it was confirmed that the purchased products do not exist in the storage unit; a receiving means for receiving display data of the maintenance list from the electronic receipt management server to which the maintenance command is sent; a display control means for displaying a maintenance screen on the display device based on the received display data, the maintenance list being a list of names of purchased items that are included in the receipt data but do not exist in the storage unit, and dates on which it was confirmed that the purchased items do not exist in the storage unit; and a receiving means for receiving a first operation by an operator on the maintenance list displayed on the maintenance screen as an instruction to add data identifying purchased products that are included in the receipt data but not present in the storage unit to the storage unit; a second transmitting means for transmitting to the electronic receipt management server a registration command requesting that the data identifying the purchased product, the instruction of which to add to the storage unit has been accepted by the accepting means, be added to the storage unit; A terminal equipped with:
2. a receiving means in the electronic receipt management server for receiving a notification indicating that data identifying a purchased product, in which information indicating that the purchased product is subject to a tax system that allows tax deduction when the annual purchase amount is within a predetermined amount range, has been detected from information about the purchased product included in the receipt data, and that the data identifying the purchased product does not exist in a storage unit of the electronic receipt management server that stores the data identifying the subject product; The terminal of claim 1 further comprising:
3. the accepting means further accepts a second operation by the operator on the maintenance list displayed on the maintenance screen as an instruction not to add to the storage unit data identifying purchased products that are included in the receipt data but do not exist in the storage unit; a third transmission means for transmitting to the electronic receipt management server a cancellation command requesting not to add to the storage unit the data identifying the purchased product for which the instruction not to add to the storage unit has been received by the receiving means; 10. The terminal of claim 1, further comprising:
4. the maintenance screen further displays a registration button and a cancel button; The receiving means a first operation by an operator on the maintenance list displayed on the maintenance screen to select a purchased item that is included in the receipt data but does not exist in the storage unit, and when the register button is operated, data identifying the selected purchased item is accepted as an instruction to add the data to the storage unit; The terminal according to claim 3, wherein when a purchased item that is included in the receipt data but does not exist in the storage unit is selected by a second operation by the operator on the maintenance list displayed on the maintenance screen and the cancel button is operated, the terminal accepts this as an instruction not to add data identifying the selected purchased item to the storage unit.
5. A terminal computer equipped with a display device and a means for communicating with an electronic receipt management server, a first transmission means for transmitting to the electronic receipt management server via the communication means a maintenance command requesting the creation of a maintenance list including data identifying purchased products for which information indicating that the purchased products are subject to a tax system that allows tax deductions when the annual purchase amount is within a predetermined amount range has been detected from information about the purchased products included in the receipt data, and data identifying purchased products that do not exist in a storage unit of the electronic receipt management server that stores the data identifying the subject products, the maintenance list including product names of purchased products that are included in the receipt data but do not exist in the storage unit, and dates on which it was confirmed that the purchased products do not exist in the storage unit; a display control means for, when receiving display data of the maintenance list from the electronic receipt management server to which the maintenance command is sent via the communication means, changing the screen of the display device based on the received display data to a maintenance screen displaying a maintenance list that lists product names of purchased products that are included in the receipt data but do not exist in the storage unit and dates on which it was confirmed that the purchased products do not exist in the storage unit; a receiving means for receiving a first operation by an operator on the maintenance list displayed on the maintenance screen as an instruction to add data identifying purchased products that are included in the receipt data but not present in the storage unit to the storage unit; and a second transmission means for transmitting, to the electronic receipt management server via the communication means, a registration command requesting that the data identifying the purchased product, the instruction of which to add to the storage unit has been accepted by the accepting means, be added to the storage unit; A program to function as a
Citation Information
Patent Citations
Retrieval system for information on stored / surplus medicine
JP2000331110A
Article selling data processing apparatus
JP2006004251A
Electronic receipt system, electronic receipt management server, program and electronic receipt management method
JP2017062816A
Electronic receipt system, server, terminal, method and program
WO2017056443A1