JP7393497B2 - Tax exemption processing system, information processing equipment and its program - Google Patents

Description

Embodiments of the present invention relate to a tax exemption processing system compatible with a tax exemption system for non-residents, an information processing device used in this system, and a program for causing a computer to function as an information processing device.

When a general consumption tax duty-free store manager sells goods in a certain way to non-residents such as foreign tourists, excise taxes (consumption tax, liquor tax, etc.) are levied on the goods. is exempted. Recently, even in specific commercial facilities such as shopping districts, shopping centers, and tenant buildings, a third party, an approved tax exemption procedure operator, has set up a tax exemption procedure counter within the facility, allowing non-residents to be It is now possible to carry out procedures for tax exemption on sales of goods to business owners on behalf of business owners.

In such specified commercial facilities, non-resident purchasers purchase goods at tax-inclusive prices at each duty-free shop within the facility. When the purchaser finishes shopping within the facility, the purchaser goes to the tax exemption procedure counter, completes the tax exemption procedure, and receives a refund of the tax exempt amount.

Specifically, the purchaser presents proof of non-resident status, such as a passport, to the approved tax exemption procedure operator, along with a receipt showing the details of the purchased item. The approved tax exemption procedure business operator will classify the tax exempt goods purchased by the purchaser into consumables and other general goods based on the information on the receipt, add up the tax-excluded prices of each item, and determine whether the goods are tax exempt or not. to judge. If the item is subject to tax exemption, the approved tax exemption procedure operator prepares the documents necessary for tax exemption procedures, such as a purchase record slip, purchaser's oath, and consumables caution label.

Here, the purchaser's pledge is obligated to be kept for 7 years from the day two months have passed from the day after the last day of the taxable period in which the tax-free sale occurred at the duty-free store, so the purchaser must Create one for each duty-free shop.

The approved tax exemption procedure operator attaches the purchase record slip to a passport, etc. and returns it to the purchaser. In addition, if the approved tax exemption procedure operator is unable to ascertain the contents of a case packed with consumables, they will attach a detailed description of the contents and a warning not to open the package until departure from the country and hand it over to the purchaser. Further, the approved tax exemption procedure operator refunds the tax exempt amount to the purchaser, receives signatures on each purchaser's pledge from the purchaser, and collects each signed purchaser's pledge. This completes the tax exemption procedure. The collected purchaser's pledge will be kept at each duty-free shop.

In this way, by installing a tax exemption procedure counter within a specified commercial facility, an approved tax exemption procedure business operator can perform tax exemption procedures for duty free shops within the specified commercial facility all at once. By the way, it is conceivable that the tax exemption amount to be refunded to the purchaser would be temporarily borne by the tax exemption procedure business operator and later collected from each duty free shop. However, in order to do so, the amount to be collected must be managed for each duty-free shop, which poses a problem in that it places a heavy burden on tax-free procedures businesses.

JP2012-234324A

The problems to be solved by the embodiments of the present invention are a tax exemption processing system that can simplify the management of tax exempt amounts collected from each duty free shop and reduce the burden on tax exemption procedure businesses, and an information processing device used in this system. This is what we are trying to provide.

In one embodiment, the tax exemption processing system includes an information processing device and a storage device. The storage device is associated with a purchaser code that identifies a purchaser who purchases an item, and is created for each item purchased by a purchaser identified by the purchaser code, and stores a store that identifies the store that sold the item. A purchaser data file that stores purchase records including the code and the tax amount levied on the sale of the item, and the total amount including tax, total amount excluding tax, and tax amount for each store code in association with the aggregation period. and a tally table having an area for storage . The information processing device includes a first receiving means, a second receiving means, a first processing means, and a transmitting means . The first receiving means receives a purchaser code of a purchaser who wishes to receive a refund for purchasing an item. The second receiving means receives the purchaser data file associated with the purchaser code received by the first receiving means from the storage device. The first processing means acquires a store code from the purchase record stored in the purchaser data file received by the second receiving means, and the store code is configured to include a total amount including tax, a total amount excluding tax, and a tax amount for each store code. It is determined whether the data table exists in a data table that has an area for storing the . If it is determined that the purchase record does not exist, the store code of the purchase record, the total amount including tax, the total amount excluding tax, and the tax amount are stored in the data table in association with each other. If it is determined that the store code exists, the total amount including tax, total amount excluding tax, and tax amount stored in the data table in association with the store code are calculated, respectively. Update the amount by adding . The transmitting means transmits the data of the data table to the storage device together with the date information after the first processing means finishes processing the purchase records stored in the purchaser data file.

FIG. 1 is a schematic diagram showing the overall configuration of a tax exemption processing system in one embodiment. 2 is a block diagram showing the main circuit configuration of a POS terminal included in the tax exemption processing system of FIG. 1. FIG. FIG. 2 is a block diagram showing a main circuit configuration of a reception terminal included in the tax exemption processing system of FIG. 1. FIG. FIG. 2 is a block diagram showing a main circuit configuration of a payment terminal included in the tax exemption processing system of FIG. 1. FIG. FIG. 5 is a schematic diagram showing the data structure of a data table formed in the RAM in the payment terminal of FIG. 4. FIG. FIG. 2 is a block diagram showing a main circuit configuration of a management server included in the tax exemption processing system of FIG. 1. FIG. FIG. 7 is a schematic diagram showing the data structure of a duty-free item database stored in the management server of FIG. 6; FIG. 7 is a schematic diagram showing the data structure of a purchaser data file stored in the management server of FIG. 6; FIG. 9 is a schematic diagram showing the data structure of a purchase record stored in the purchaser data file of FIG. 8; FIG. 7 is a schematic diagram showing the data structure of a tally table stored in the management server of FIG. 6; 2 is a flowchart showing the main information processing procedure executed by the CPU of the reception terminal according to the control program. 5 is a flowchart showing the main information processing procedure executed by the CPU of the POS terminal according to the control program. 5 is a flowchart showing the main information processing procedure executed by the CPU of the payment terminal according to the control program. 14 is a flowchart showing the procedure of tax exemption amount calculation processing in FIG. 13. 5 is a flowchart showing the main information processing procedure that the CPU of the management server executes when receiving tax exemption reception data. 5 is a flowchart showing the main information processing procedure executed by the CPU of the management server when receiving tax-free purchase data. The flowchart which shows the main information processing procedure which the CPU of a management server performs when tax exemption settlement data is received. The flowchart which shows the procedure of the tax-exempt amount aggregation process performed by the CPU of the management server. A schematic diagram showing an example of a collection report by duty-free shop.

Hereinafter, an embodiment of a tax exemption processing system that can simplify the management of tax exempt amounts collected from each duty free shop will be described with reference to the drawings.

FIG. 1 is a schematic diagram showing the overall configuration of a tax exemption processing system 1. As shown in FIG. The tax exemption processing system 1 is comprised of a specified commercial facility 2 (hereinafter referred to as facility 2) to which a tax exemption system based on entrusted procedures is applied, and an approved tax exemption procedure operator for the facility 2 or a corporate entity entrusted by this operator. It is constructed with the data center 3 managed by .

Facility 2 is a collection of stores such as a shopping district, a shopping center, and a tenant building. Each store is approved by the government as a consumption tax duty-free store 4 (hereinafter referred to as duty-free store 4) that handles procedures on a consignment basis. In each duty-free shop 4, a well-known POS (Point Of Sales) terminal 40 is operated as an accounting device. The number of POS terminals 40 per store is not particularly limited. Note that the facility 2 may be a general consumption tax-free store, that is, a duty-free store with only one store.

The facility 2 is equipped with a tax exemption reception counter 5 (hereinafter referred to as reception counter 5) and a tax exemption procedure counter 6 (hereinafter referred to as procedure counter 6) that are managed by an approved tax exemption procedure operator. The reception counter 5 and the procedure counter 6 may be installed at different locations within the facility 2, or may be installed at the same location.

The reception counter 5 is a place where non-residents such as foreign travelers receive a tax exemption card C or a tax exemption sheet S necessary for buying and selling goods tax exempt before shopping in the facility 2. At the reception counter 5, a reception terminal 50 for issuing a tax exemption card C or a tax exemption sheet S is in operation. The reception terminal 50 is one aspect of an information processing device that functions as a reception device. The tax exemption card C is a card medium (magnetic card, IC card, etc.) that can hold information magnetically or electrically. The tax exemption sheet S is, for example, a receipt paper with necessary information printed on it.

The procedure counter 6 is a place where non-residents who shop at the duty-free shop 4 in the facility 2 complete procedures for tax exemption. Procedures include refunding of excise taxes (consumption tax, liquor tax, etc.) paid by non-residents on goods purchased at duty-free shops 4, purchaser oaths, purchase record sheets, consumables caution labels, etc. Our services include issuing documents necessary for tax exemption measures and collecting purchaser pledges. At the procedure counter 6, a payment terminal 60 is in operation. The payment terminal 60 is one aspect of an information processing device that functions as a payment device.

The data center 3 is installed for at least one facility 2 for the purpose of managing data related to tax exemption procedures at the facility 2 and storing data processed through the tax exemption procedures. One data center may also be used to manage data related to tax exemption procedures at a plurality of facilities 2 and to store data processed through tax exemption procedures. In the data center 3, a management server 31 is in operation for managing data related to tax exemption procedures and data processed through tax exemption procedures.

In FIG. 1, the management server 31 is provided in the data center 3, but the management server 31 may be provided in the facility 2 and connected via a network for management.

The tax exemption processing system 1 includes a computer network 7 (hereinafter referred to as the network 7) such as the Internet. The tax exemption processing system 1 is configured by connecting the POS terminals 40, reception terminals 50, and payment terminals 60 in the facility 2 to the management server 31 in the data center 3 through this network 7 so as to enable bidirectional communication. Constructed.

FIG. 2 is a block diagram showing the main circuit configuration of the POS terminal 40. As shown in FIG. The POS terminal 40 includes a CPU (Central Processing Unit) 401, a ROM (Read Only Memory) 402, a RAM (Random Access Memory) 403, an auxiliary storage device 404, a clock section 405, a communication interface 406, a LAN interface 407, a keyboard 408, and a display. 409, a receipt printer 410, a scanner 411, a card reader 412, a drawer 413, and a touch panel 414. The POS terminal 40 includes a CPU 401, a ROM 402, a RAM 403, an auxiliary storage device 404, a clock section 405, a communication interface 406, a LAN interface 407, a keyboard 408, a display 409, a receipt printer 410, a scanner 411, a card reader 412, a drawer 413, and a touch panel. 414 directly through a system transmission path 415 such as an address bus, data bus, or control signal line, or indirectly through an input/output circuit.

The POS terminal 40 constitutes a computer including a CPU 401, a ROM 402, a RAM 403, an auxiliary storage device 404, and a system transmission path 415 connecting these.

The CPU 401 corresponds to the central part of the computer. The CPU 401 controls each part to realize various functions of the POS terminal 40 according to the operating system and application programs.

ROM 402 corresponds to the main memory portion of the computer. The ROM 402 stores the above operating system and application programs. The ROM 402 may also store data necessary for the CPU 401 to execute processing for controlling each unit.

RAM 403 corresponds to the main memory portion of the computer. The RAM 403 stores data necessary for the CPU 401 to execute processing. The RAM 403 is also used as a work area where information is rewritten as appropriate by the CPU 401.

The auxiliary storage device 404 corresponds to the auxiliary storage portion of the computer. The auxiliary storage device 404 is, for example, an EEPROM (Electric Erasable Programmable Read-Only Memory), an HDD (Hard Disc Drive), or an SSD (Solid State Drive). The auxiliary storage device 404 stores data used by the CPU 401 when performing various processes, data generated by processing by the CPU 401, and the like. The auxiliary storage device 404 may also store the above application program.

The clock unit 405 functions as a time information source for the POS terminal 40. The CPU 401 measures the current date and time based on time information measured by the clock unit 405.
Communication interface 406 is connected to network 7 . The communication interface 406 performs data communication with the management server 31 of the data center 3 via the network 7 according to a preset protocol.

LAN interface 407 is connected to LAN 41 formed within the store. The LAN 41 may be a wired LAN or a wireless LAN. In addition to the POS terminal 40, the LAN 41 is connected to a store server 42, etc. for managing a product database storing various data regarding products sold in the store (including duty-free and non-tax-free products). . The LAN interface 407 performs data communication with the store server 42 and the like via the LAN 41 according to a preset protocol.

The keyboard 408 is a dedicated input device that is provided with various function keys such as a multiplication key, a subtotal key, and a close key in addition to a number key for entering numerical values such as points and amounts. The functions necessary for the POS terminal 40 may be assigned to arbitrary keys on a general-purpose keyboard. The closing key is a key used by the operator to declare closing of transaction registration. A commercial transaction is an act of buying and selling products with a single purchaser.

The display 409 is a display device for displaying product names, prices, total amounts, change amounts, and the like. There are two types of displays 409, one for a store clerk who operates the POS terminal 40 and one for a purchaser.
Note that a touch panel that serves as both an input device and a display device may be used instead of the keyboard 408 and the display 409.

Receipt printer 410 prints receipt data representing details of one commercial transaction on a predetermined receipt paper. The printed receipt paper is cut by a cutter, issued as a purchase details receipt, and handed to the purchaser.

The scanner 411 optically reads code symbols such as barcodes and two-dimensional data codes. Most of each product has a code symbol that is a barcode of a product code unique to that product. The scanner 411 is used to read code symbols attached to products purchased by the purchaser. Further, a barcode is printed on the tax exemption sheet S, and the scanner 411 is also used to read this barcode.

Card reader 412 reads data recorded on a card medium. If the card medium is a magnetic card, card reader 412 is a magnetic card reader. When the card medium is an IC card, the card reader 412 is an IC card reader. The IC card reader may be a contact type or a non-contact type. The card reader 412 is used to read data recorded on a credit card, point card, etc. used by the purchaser. The card reader 412 is also used to read data recorded on the tax exemption card C. Therefore, if the tax exemption card C is a magnetic card, the card reader 412 becomes a magnetic card reader. If the tax exemption card C is an IC card, the card reader 412 becomes an IC card reader.

The drawer 413 stores cash and the like, and opens in response to an open signal from the CPU 401. By opening the drawer 413, cash such as a deposit or change can be exchanged between the clerk and the purchaser. Note that an automatic change machine may be connected to the POS terminal 10 instead of the drawer 413. In that case, the automatic change machine dispenses cash as change based on the dispensing data from the CPU 401.

Touch panel 414 includes a display device and a touch sensor. The display device uses an arbitrary screen such as a GUI screen as its display screen. As the display device, for example, a well-known device such as a color LCD can be used. The touch sensor is arranged to overlap the display surface of the display device. The touch sensor detects the touch position of the operator on the display surface of the display device, and sends the position information to the CPU 401. A well-known device can be used as the touch sensor.

FIG. 3 is a block diagram showing the main circuit configuration of the reception terminal 50. As shown in FIG. The reception terminal 50 is equipped with a CPU 501, a ROM 502, a RAM 503, an auxiliary storage device 504, a clock section 505, a communication interface 506, a touch panel 507, a card reader 508, a printer interface 509, and an external device interface 510. The reception terminal 50 connects the CPU 501, ROM 502, RAM 503, auxiliary storage device 504, clock unit 505, communication interface 506, touch panel 507, card reader 508, printer interface 509, and external device interface 510 to an address bus, a data bus, They are connected directly through a system transmission path 511 such as a control signal line or indirectly through an input/output circuit.

The CPU 501, ROM 502, RAM 503, auxiliary storage device 504, clock unit 505, and communication interface 506 of the reception terminal 50 are similar to those of the POS terminal 40.

Touch panel 507 includes a display device and a touch sensor. The display device uses an arbitrary screen such as a GUI screen as its display screen. As the display device, for example, a well-known device such as a color LCD can be used. The touch sensor is arranged to overlap the display surface of the display device. The touch sensor detects the touch position of the operator on the display surface of the display device, and sends the position information to the CPU 501. A well-known device can be used as the touch sensor.

Card reader 508 reads data recorded on a card medium. If the card medium is a magnetic card, card reader 508 is a magnetic card reader. When the card medium is an IC card, card reader 508 is an IC card reader. The IC card reader may be a contact type or a non-contact type. The card reader 508 is used to read data recorded on the tax exemption card C. Therefore, if the tax exemption card C is a magnetic card, the card reader 508 becomes a magnetic card reader. If the tax exemption card C is an IC card, the card reader 508 becomes an IC card reader.

The printer interface 509 performs data communication with the printer 51, which is detachably connected via the communication cable 51C, according to a preset protocol. The printer 51 is used to print the tax exemption sheet S. As this type of printer 51, a thermal printer, a dot impact printer, or the like can be applied. The reception terminal 50 may be configured with a well-known POS terminal, and the receipt printer installed in this POS terminal may be used as a printer for printing the tax exemption sheet S.

The external device interface 510 performs data communication according to a preset protocol with an OCR (Optical Character Reader) 52 that is detachably connected via a communication cable 52C. OCR52 optically scans the information recorded on proof of non-resident status, such as a passport (passport type, name, passport number, nationality, date of birth, gender, passport expiration date, etc.). provided for reading. Note that the proof is not limited to a passport. For example, in an area such as Okinawa Prefecture where a specific tax exemption system is in effect, the ticket may be a flight ticket departing from that area.

FIG. 4 is a block diagram showing the main circuit configuration of the payment terminal 60. The payment terminal 60 is equipped with a CPU 601, a ROM 602, a RAM 603, an auxiliary storage device 604, a clock section 605, a communication interface 606, a touch panel 607, a scanner 608, a card reader 609, a printer interface 610, and two external device interfaces 611 and 612. The payment terminal 60 then addresses the CPU 601, ROM 602, RAM 603, auxiliary storage device 604, clock unit 605, communication interface 606, touch panel 607, scanner 608, card reader 609, printer interface 610, and external device interfaces 611, 612. They are connected directly via a system transmission path 613 such as a bus, data bus, or control signal line, or indirectly via an input/output circuit.

The CPU 601, ROM 602, RAM 603, auxiliary storage device 604, clock unit 605, and communication interface 606 of the payment terminal 60 are similar to those of the POS terminal 40 and the reception terminal 50.

Touch panel 607 includes a display device and a touch sensor. The display device uses an arbitrary screen such as a GUI screen as its display screen. As the display device, for example, a well-known device such as a color LCD can be used. The touch sensor is arranged to overlap the display surface of the display device. The touch sensor detects the operator's touch position on the display surface of the display device, and sends the position information to the CPU 601. A well-known device can be used as the touch sensor.

Scanner 608 optically reads code symbols such as barcodes and two-dimensional data codes. The scanner 608 is used to read the barcode printed on the tax exemption sheet S.

A card reader 609 reads data recorded on a card medium. If the card medium is a magnetic card, card reader 609 is a magnetic card reader. When the card medium is an IC card, the card reader 609 is an IC card reader. The IC card reader may be a contact type or a non-contact type. The card reader 609 is used to read data recorded on the tax exemption card C. Therefore, if the tax exemption card C is a magnetic card, the card reader 609 becomes a magnetic card reader. If the tax exemption card C is an IC card, the card reader 609 becomes an IC card reader.

The printer interface 610 performs data communication with the printer 61, which is detachably connected via the communication cable 61C, according to a preset protocol. The printer 61 is used to print documents such as purchase record sheets and consumable supplies caution labels. The printer 61 is also used to print a tax-exempt amount collection report 200 for each duty-free shop, which will be described later. As this type of printer 61, a thermal printer, a dot impact printer, or the like can be applied. The payment terminal 60 may be configured with a well-known POS terminal, and a receipt printer installed in the POS terminal may be used as a printer for printing the document.

External device interface 611 performs data communication with pen tablet 62, which is detachably connected via communication cable 62C, according to a preset protocol. The pen tablet 62 is a detection device that reads the position of an electronic pen with respect to a plate-shaped tablet body using a sensor built into the tablet body, and detects the trajectory of the electronic pen and electronically captures the trajectory as information written by the user. As the pen tablet 62, a well-known one such as a liquid crystal pen tablet can be used. The pen tablet 62 is used to record a purchaser's electronic signature on the purchaser's pledge, which is an electronic document.

The external device interface 612 performs data communication with the dispensing machine 63, which is detachably connected via the communication cable 63C, according to a preset protocol. The dispensing machine 63 has a stocker that stores cash such as banknotes and coins by denomination, and a mechanism that dispenses cash in an amount according to dispensing data from the stocker to a dispensing port. The withdrawal machine 63 withdraws the tax-exempt amount that will be refunded to the purchaser (non-resident) who purchases a tax-free item at the tax-inclusive price at the duty-free shop 4 in the facility 2 and completes the tax exemption procedure at the procedure counter 6. do. The dispensing machine 63 may be a well-known automatic change machine that works with a POS terminal. Further, instead of the dispensing machine 63, a drawer storing cash may be connected and the drawer may be controlled to open in response to an opening signal from the CPU 601. In this case, by displaying the tax exempt amount on the touch panel 607, the person in charge of the procedure counter 6 collects cash corresponding to the tax exempt amount from the drawer and hands it to the purchaser.

The payment terminal 60 having such a configuration forms a data table 64 having the data structure shown in FIG. 5 in the RAM 603. The data table 64 is a data table for calculating the payment amount for each duty-free shop with respect to the tax-free amount to be refunded to the purchaser (non-resident) who has completed the tax-free procedure at the procedure counter 6. The data table 64 has a column for the store code, a column for the total amount including tax, a column for the total amount excluding tax, and a column for the tax exemption amount, arranged in one direction (row direction). In each column, data of the store code, total amount including tax, total amount excluding tax, and tax exempt amount are stored in order from the first row.

FIG. 6 is a block diagram showing the main circuit configuration of the management server 31. As shown in FIG. The management server 31 is equipped with a CPU 311, a ROM 312, a RAM 313, an auxiliary storage device 314, a clock section 315, a communication interface 316, and a LAN interface 317. The management server 31 connects the CPU 311, ROM 312, RAM 313, auxiliary storage device 314, clock unit 315, communication interface 316, and LAN interface 317 directly or Connected indirectly via input/output circuits.

The CPU 311, ROM 312, RAM 313, auxiliary storage device 314, clock unit 315, and communication interface 316 of the management server 31 are the same as those of the POS terminal 40, reception terminal 50, and payment terminal 60.

The LAN interface 317 is connected to a LAN 33 formed within the data center 3. The LAN 33 may be a wired LAN or a wireless LAN.

The management server 31 having such a configuration can store the duty-free article database 34 , the purchaser data file 35 , and the total table 36 in the auxiliary storage device 314 . The duty-free goods database 34 stores data regarding so-called duty-free goods, which are goods sold at each duty-free shop 4 to non-residents exempt from excise tax.

Duty-free goods include consumables such as foods, beverages, medicines, and cosmetics, and general goods other than consumables. Currently, in Japan, consumables are eligible for tax exemption if the total daily sales amount to the same non-resident at a duty-free shop 4 in the same facility 2 exceeds 5,000 yen and is within the range of 500,000 yen. Become. That is, 5,011 yen and 500,000 yen are set as tax exemption points for consumables. On the other hand, general goods are eligible for tax exemption if the total sales amount exceeds 10,000 yen. In other words, 10,001 yen is set as the tax exemption point for general goods.

FIG. 7 is a schematic diagram showing part of the data stored in the duty-free product database 34. As shown in FIG. 7, the duty-free product database 34 stores data records including the following items: store code, product code, item name, price, consumption tax category, and tax-free category. The store code is a unique code set for each duty-free store 4 in order to identify the duty-free store 4 individually. The product code is a unique code set for each product to individually identify the products (including duty-free and non-tax-free products) sold at the duty-free shop 4 identified by the corresponding store code. Incidentally, the product code for the same type of product may be common to each duty free shop 4 or may be different for each duty free shop 4. Furthermore, this does not prevent different types of products from being given the same product code at different duty-free shops 4.

The item name is the name of the product identified by the corresponding product code. The price is the price (tax-included price or tax-excluded price) for the product identified by the corresponding product code. Incidentally, the item name or price for the same type of product may be common to each duty-free shop 4 or may be different for each duty-free shop 4.

The consumption tax classification is information that distinguishes whether the product identified by the corresponding product code is defined as including tax or excluding tax, and what the consumption tax rate is set at. Incidentally, the consumption tax classification for the same type of product may be the same for each duty-free shop 4 or may be different for each duty-free shop 4. Further, the consumption tax classification may be different for each product handled at the same duty-free shop 4.

The tax exemption classification is information that distinguishes whether the product identified by the corresponding product code is defined as a consumable item, a general item other than a consumable item, or not subject to tax exemption. For example, when the classification is "1", the CPU 311 of the management server 31 recognizes that the product corresponding to this classification is a consumable item. Similarly, if the category is "2", the CPU 311 recognizes that the products corresponding to this category are general goods, and if the category is "3", the CPU 311 recognizes that the products corresponding to this category are not eligible for tax exemption. do. Note that if the product identified by the corresponding product code is a tax-exempt product, no classification is set, or a classification other than "1", "2", or "3" is set.

The purchaser data file 35 contains various data regarding non-residents who have been issued a tax-free card C or tax-free sheet S at the reception counter 5 of the facility 2, that is, purchasers who have expressed their intention to purchase tax-free items at the duty-free shop 4. This is an area for storing.

FIG. 8 is a schematic diagram showing main data items stored in the purchaser data file 35. As shown in FIG. 8, the purchaser data file 35 contains the following data: purchaser code, non-resident data, reception date and time, payment date and time, general goods purchase record, consumables purchase record, general goods total, and consumables total. is saved.

The purchaser code is a unique code that individually identifies a purchaser who has been issued a tax exemption card C or tax exemption sheet S at the reception counter 5 of the facility 2. Non-resident data is information written on an item proving non-resident status presented by a purchaser identified by a corresponding purchaser code. For example, if the proof of non-resident status is a passport, non-resident data includes the type of passport, name, passport number, nationality, date of birth, gender, expiration date of the passport, etc. It will be done. The reception date and time is the date and time when the purchaser identified by the corresponding purchaser code made the reception at the reception counter 5. The payment date and time is the date and time when the purchaser identified by the corresponding purchaser code made payment at the procedure counter 6.

The general goods purchase record records data regarding sales of general goods among duty-free goods purchased at each duty-free shop 4 by the purchaser identified by the corresponding purchaser code. The consumables purchase record records data regarding sales of consumables among the tax-free items purchased by the same purchaser at each duty-free shop 4. The general goods purchase record and the consumables purchase record have a common data structure, and are created for each duty-free item. The total general goods is the sum of the number of general goods purchased and their tax-excluded prices among the duty-free goods purchased at each duty-free shop 4 by the purchaser identified by the corresponding purchaser code. The total consumables is the sum of the number of purchased consumables and the tax-excluded price of the tax-free goods purchased by the same purchaser at each duty-free shop 4.

FIG. 9 is a schematic diagram showing the structure of data included in the general goods purchase record and the consumables purchase record. As shown in FIG. 9, the general goods purchase record and the consumables purchase record include a store code, product code, item name, number of items purchased, price, consumption tax amount, and the like. The store code, product code, item name, and number of items purchased are as described above. Prices are excluding tax. The consumption tax amount is the amount of consumption tax levied on the product identified by the corresponding product code.

The aggregation table 36 is used to calculate the amount paid by each duty-free shop (recovered amount) for the total amount of tax-free amount refunded to non-residents within a certain period of time.
FIG. 10 is a schematic diagram showing the data structure of the tally table 36. As shown in FIG. 10, the total table 36 includes a start date area and an end date area. In addition, the tally table 36 has a column for the store code, a column for the total price including tax, a column for the total price excluding tax, and a column for the tax exemption amount in one direction (row direction). The start date and end date of the aggregation period are stored in the start date area and the end date area. For example, if the unit of aggregation period is monthly, the first day of the month is stored in the start date area, and the last day of the month is stored in the end date area. In each column, data of a store code, total amount including tax, total amount excluding tax, and tax exempt amount are stored in order from the first row.

FIG. 11 is a flowchart showing the main steps of the control process executed by the CPU 501 of the reception terminal 50 according to the control program. FIG. 12 is a flowchart showing the main steps of the control process executed by the CPU 401 of the POS terminal 40 according to the control program. 13 and 14 are flowcharts showing the main steps of the control process executed by the CPU 601 of the payment terminal 60 according to the control program. 15 to 17 are flowcharts showing the main steps of the control process executed by the CPU 311 of the management server 31 according to the control program. The operation of the tax exemption processing system 1 will be described below with reference to FIGS. 11 to 17. Note that the content of the processing described below is an example, and various processing that can obtain similar results can be used as appropriate.

First, the approved tax exemption procedure operator of the facility 2 places a business person at the reception counter 5 and the procedure counter 6, respectively. The person in charge of operations may also serve as the reception counter 5 and the procedure counter 6.

Non-residents such as foreign tourists who wish to shop at each duty-free shop 4 within the facility 2 by utilizing the excise tax exemption system first go to the reception counter 5. The non-resident presents, for example, a passport to the person in charge of the business as proof of non-resident status. The person in charge of business starts up the reception terminal 50. For example, the reception terminal 50 is activated when the touch panel 507 is touched. When the reception terminal 50 is activated, the CPU 501 starts processing of the procedure shown in the flowchart of FIG. 11, so-called reception processing.

First, the CPU 501 receives non-resident data as Act1. Specifically, the CPU 501 causes the touch panel 507 to display guidance such as "Please read the information on the passport." After confirming this guidance, the business person causes the OCR 52 to read the text information on the page where the passport number, etc. of the passport presented by the non-resident is recorded. The character information of the passport read by the OCR 52 is given to the CPU 501 via the external device interface 510. The CPU 501 analyzes the character information and receives passport information such as passport type, name, passport number, nationality, date of birth, gender, and passport expiration date as non-resident data.

Next, in Act 2, the CPU 501 determines whether or not the non-resident data could be legitimately received. For example, if the character information read by the OCR 52 is analyzed but all or part of the passport information cannot be received, the CPU 501 determines that the non-resident data cannot be received. If the non-resident data cannot be received (NO in Act 2), the CPU 501 causes the touch panel 507 to display an error message such as "Could not read passport information", for example. This completes the reception process.

If the non-resident data can be received (YES in Act 2), the CPU 501 determines the options set in the reception terminal 50 in Act 3. The approved tax exemption procedure business operator issues tax exemption cards C or tax exemption sheets S to non-residents shopping within the facility 2 at the reception counter 5. The facility 2 decides in advance which of the tax exemption card C and the tax exemption sheet S will be issued. In the facility 2 that issues the tax-free card C, an option for issuing a tax-free card is set in advance on the reception terminal 50. In the facility 2 that issues the tax-free sheet S, an option for issuing a tax-free sheet is set in advance on the reception terminal 50. Note that an option not to issue the tax exemption card C and the tax exemption sheet S may be set in advance for the reception terminal 50. In this case, no tax exemption card or tax exemption sheet will be issued. These options are set, for example, by a maintenance person of the tax exemption processing system 1 operating the touch panel 507 to set or reset option flags stored in the RAM 503.

In Act 4, the CPU 501 checks the state of the option flags and determines whether the issuance of the tax-free card C is set, whether the issuance of the tax-free sheet S is set, or whether the issuance of the tax-free card C and tax-free sheet S is set. identify.
If the issuance of the tax-free card S is set (YES in Act 4), the CPU 501 receives the purchaser code in Act 5. Specifically, the CPU 501 causes the touch panel 507 to display guidance such as "Please read the data on the tax exemption card C." After confirming this guidance, the business person takes out one tax exemption card C that is stocked in advance at the reception counter 5. A unique code is recorded in advance on the tax exemption card C. The business person causes the card reader 508 to read the code recorded on the tax exemption card C taken out. The code (card data) read by the card reader 508 is given to the CPU 501. The CPU 501 receives this unique code for each tax exemption card C as a purchaser code.

On the other hand, if the issuance of the tax exemption sheet S or non-issuance of the tax exemption card C and the tax exemption sheet S is set (NO in Act 4), the CPU 501 generates a purchaser code in Act 6. Specifically, the CPU 501 generates a purchaser code from the passport number of the passport information acquired in the process of Act 1 and the date and time information clocked by the clock unit 505. For example, the CPU 501 uses a code obtained by adding date and time information after the passport number as the purchaser code. Alternatively, a code obtained by adding date and time information in front of the passport number is used as the purchaser code.

After completing the processing in Act 5 or Act 6, the CPU 501 generates tax exemption reception data as Act 7. The tax exemption reception data includes a purchaser code, non-resident data, and reception date and time. That is, the CPU 501 adds the non-resident data received in the process of Act 1 and the date and time information (reception date and time) clocked by the clock unit 505 to the purchaser code received in the process of Act 5 or the purchaser code generated in the process of Act 6. are associated with each other to form tax exemption reception data.

The CPU 501 transmits tax exemption reception data to the management server 31 in Act 8. Specifically, the CPU 501 notifies the communication interface 506 to transmit the tax exemption reception data to the management server 31. Upon receiving this notification, the communication interface 506 transmits the tax exemption reception data to the management server 31 via the network 7 .

The CPU 501 issues the tax exemption sheet S as Act 9. The contents of the tax exemption sheet S to be issued differ depending on the state of the option flag determined in Act 3. Specifically, when the option to issue the tax-free sheet S is set, the CPU 501 generates print data for the tax-free sheet S including the barcode of the purchaser code generated in Act 6. In addition to the above barcode, this print data includes date and time information measured by the clock unit 505, logo information of the facility 2, text data indicating how to use the tax exemption sheet S, and the like. Furthermore, if the tax exemption card C option is set, print data other than the above barcode is generated. The CPU 501 notifies the printer interface 509 that the print data for the tax exemption sheet S will be output to the printer 51. Upon receiving this notification, the printer interface 509 outputs print data for the tax exemption sheet S to the printer 51. Through the above processing, the printer 51 is driven and the tax exemption sheet S is issued. Note that if the option of not issuing the tax exemption card C and the tax exemption sheet S is set for the reception terminal 50, the tax exemption sheet S will not be issued.

The CPU 311 of the management server 31 that has received the tax exemption reception data starts information processing according to the procedure shown in the flowchart of FIG.
First, in Act 51, the CPU 311 confirms whether the received data is tax exemption reception data. If the received data is tax exemption reception data (YES in Act 51), the CPU 311 creates a new purchaser data file 35 on the auxiliary storage device 314 in Act 52.

Next, the CPU 311 obtains the purchaser code from the tax exemption reception data as Act 53. Further, the CPU 311 acquires non-resident data from the tax exemption reception data as Act 54. Furthermore, the CPU 311 obtains the reception date and time from the tax exemption reception data as Act 55. Note that the procedures of Acts 53, 54, and 55 are not limited to this order. Any procedure may be used as long as the purchaser code, non-resident data, and reception date and time can be obtained from the tax exemption reception data.

After completing the processing in Acts 53, 54, and 55, the CPU 311 stores the purchaser code, non-resident data, and reception date and time obtained from the tax exemption reception data as Act 56 in the purchaser data file 35 created in the processing in Act 52. With this, the CPU 311 ends the reception process for the tax exemption reception data.

When the CPU 501 of the reception terminal 50 finishes transmitting the tax exemption reception data, it causes the touch panel 507 to display, for example, a message indicating that the transmission has been completed. With this, the CPU 501 ends the reception process for non-residents.

After confirming the message indicating the completion of transmission of the tax exemption reception data, the person in charge at the reception counter 5 hands the tax exemption card C or the tax exemption sheet S to the non-resident. Which of the tax exemption card C or the tax exemption sheet S to be handed out is determined for each facility 2 as described above. Non-residents can utilize the tax exemption system to purchase products by presenting their tax exemption card C or tax exemption sheet S at each duty free shop 4 within the facility 2.

When a clerk at the duty-free shop 4 receives a tax-free card C or a tax-free sheet S from a product purchaser, he operates the POS terminal 40 and declares the sales registration of the product purchased by a non-resident. For example, the keyboard 408 of the POS terminal 40 is provided with a declaration key for declaring sales registration of a product purchased by a non-resident, and the clerk inputs this declaration key. After inputting the declaration key, the clerk causes the card reader 412 to read the data recorded on the tax exemption card C. Alternatively, the clerk causes the scanner 411 to read the barcode printed on the tax exemption sheet S.

When the declaration key is input, the CPU 401 of the POS terminal 40 starts information processing according to the procedure shown in the flowchart of FIG.
First, the CPU 401 receives the purchaser code in Act 11. Specifically, when the data of the tax exemption card C is read by the card reader 412, the CPU 401 receives the data as a purchaser code. Alternatively, when the barcode of the tax exemption sheet S is read by the scanner 411, the CPU 401 receives a code obtained by analyzing the barcode as the purchaser code.

Next, in Act 12, the CPU 401 determines whether the purchaser code has been properly received. For example, if the card data read by the card reader 412 is analyzed, but the code system does not match the code recorded on the tax exemption card C, the CPU 401 determines that the purchaser code could not be received. Similarly, if the code system obtained from the barcode read by the scanner 411 is different from the purchaser code generated from the passport number and date and time information, the CPU 401 determines that the purchaser code could not be received. judge. If the purchaser code cannot be received (NO in Act 22), the CPU 401 causes the display 409 to display an error message such as "Purchaser code could not be read." This completes the information processing in FIG. 12.

If the purchaser code can be received (YES in Act 12), the CPU 401 initializes the transaction buffer in Act 13. The transaction buffer is an area for storing data of products bought and sold as one commercial transaction, and is formed in the RAM 403, for example.

After initializing the transaction buffer, the CPU 401 checks whether the product is registered in Act 14. Specifically, the CPU 401 determines whether or not a barcode attached to a product is read by the scanner 411, whether a product code is input by key input on the keyboard 408, or whether a product key is touched on the touch panel 414. Check whether it is correct or not. When a barcode is read, a product code is input, or a product key is touched, it is recognized that the product is registered.

If it is not possible to recognize that the product is registered (NO in Act 14), the CPU 401 checks whether a registration confirmation operation has been performed in Act 15. Specifically, the CPU 401 checks whether the confirmation key on the touch panel 414 has been touched. When the confirmation key is touched, it is recognized that a registration confirmation operation has been performed.

If it is not recognized that the registration confirmation operation has been performed (NO in Act 15), the CPU 401 proceeds to Act 14 again and confirms whether or not the product has been registered. Therefore, the CPU 401 waits for product registration or registration confirmation operation to be performed through the processing in Acts 14 and 15. In addition, in this standby state, if the input of another key (number key, multiplication key, subtotal key, etc.) is detected, the process corresponding to that key is executed, and then the system returns to the standby state of Act 14 and Act 15. return.

The store clerk registers the data of the product purchased by the purchaser in the POS terminal 40. For example, if a barcode is attached to the product, the store clerk causes the scanner 411 to read the barcode. If a barcode is not attached, the store clerk inputs the product code from the keyboard 408 or touches a product key displayed on the screen from the touch panel 414. In this way, when the purchaser has finished registering the data of all the products to be purchased, the store clerk touches the confirmation key.

In the standby state of Act14 and Act15, if it is recognized that the product is registered (YES in Act14), the CPU 401 executes product data registration processing in Act16. This registration process is a process executed by an existing POS terminal, so a detailed explanation will be omitted. In the POS terminal 40, through this registration process, purchased product data including the product code, product name, price, consumption tax amount, number of sales items, and sales amount is stored in the transaction buffer as information related to the sale of the product purchased by the purchaser. be remembered.

After completing the registration process, the CPU 401 proceeds to Act 14 again and checks whether the product has been registered. Therefore, each time the CPU 401 recognizes that the product is registered, it repeatedly executes the registration process in Act 16. In this way, information related to the sale of products purchased by the purchaser is collectively stored in the transaction buffer.

In the standby state of Act 14 and Act 15, if it is recognized that there is a registration confirmation operation (YES in Act 15), the CPU 401 determines in Act 17 whether or not the product has been registered. If purchased product data is not stored in the transaction buffer, the product has not been registered. In this case (NO in Act 17), the CPU 401 proceeds to Act 14 again and recognizes the presence or absence of product registration.

If the purchased product data is stored in the transaction buffer and it is recognized that the product has been registered (YES in Act 17), the CPU 401 generates tax-free purchase data in Act 18. Specifically, the CPU 401 associates the purchase product data stored in the transaction buffer with the purchaser code received in the process of Act 11 and the store code set in advance in the auxiliary storage device 404 to generate tax-free purchase data. do.

The CPU 401 transmits the tax-free purchase data to the management server 31 as Act 19. Specifically, the CPU 401 notifies the communication interface 406 to transmit the tax-free purchase data to the management server 31. Upon receiving this notification, the communication interface 406 transmits the tax-free purchase data to the management server 31 via the network 7 .

After completing the transmission process, the CPU 401 controls the issuance of a purchase detailed receipt in Act 20. Specifically, the CPU 401 generates print data of a purchase detailed receipt based on the purchased product data stored in the transaction buffer. The CPU 401 then outputs this print data to the receipt printer 410 to print a purchase details receipt. Since the printed purchase details receipt is issued from the issuing port, the clerk hands it to the purchaser.
With this, the CPU 401 ends the registration process for products purchased by non-residents.

The CPU 311 of the management server 31 that has received the tax-free purchase data starts information processing according to the procedure shown in the flowchart of FIG.
First, in Act 61, the CPU 311 confirms whether the received data is tax-free purchase data. If the received data is tax-free purchase data (YES in Act 61), the CPU 311 acquires a purchaser code from the tax-free purchase data in Act 62. Then, as Act 63, the CPU 311 reads the purchaser data file 35 including the acquired purchaser code from the auxiliary storage device 314, expands it to the RAM 313, and opens the purchaser data file 35.

Next, the CPU 311 obtains the store code from the tax-free purchase data as Act 64. Further, the CPU 311 obtains purchased product data from the tax-free purchase data as Act 65. If the tax-free purchase data includes a plurality of purchased product data, the CPU 311 selectively acquires any one purchased product data.

In Act 66, the CPU 311 searches the duty-free product database 34 using the store code obtained in the process of Act 64 and the product code included in the purchased product data obtained in the process of Act 65 as search keys. Then, the CPU 311 determines the tax exemption category of the record whose search key, store code, and product code match. That is, in Act 67, the CPU 311 confirms whether the tax exemption category represents general goods. If the tax-free category does not represent general goods (NO in Act 67), the CPU 311 checks in Act 68 whether the tax-free category represents consumables. If the tax exemption classification does not represent consumables (NO in Act 68), the CPU 311 proceeds to the process in Act 72. Such a procedure is executed when the product identified by the corresponding product code is not subject to tax exemption or is tax exempt.

On the other hand, if the tax exemption category represents general goods (YES in Act 67), the CPU 311 generates a general goods purchase record in Act 69. That is, the CPU 311 generates a general goods purchase record from the store code obtained in the process of Act 64 and the product code, item name, number of purchased items, price, and consumption tax amount of the purchased product data obtained in the process of Act 65. Further, if the tax exemption category represents a consumable item (YES in Act 68), the CPU 311 generates a consumable item purchase record in Act 70. That is, the CPU 311 generates a consumables purchase record from the store code obtained in the process of Act 64 and the product code, item name, number of purchased items, price, and consumption tax amount of the purchased product data obtained in the process of Act 65. After generating the general goods purchase record or the consumables purchase record in this manner, the CPU 311 registers the generated record in the purchaser data file 35 on the RAM 43 as Act 71. Thereafter, the CPU 311 proceeds to the process in Act72.

In Act72, the CPU 311 determines whether or not there is purchased product data that has not yet been obtained in the process of Act65 in the tax-free purchase data. If it exists (YES in Act 72), the CPU returns to the process in Act 65. Then, the subsequent processing is repeated in the same manner as above.

In this way, if the processing from Act 65 onward is executed for all purchased product data included in the tax-free purchase data (NO in Act 72), the CPU 311 performs the processing of the total general goods and the total consumables in the purchaser data file 35 in Act 73. Update each data. Specifically, the CPU 311 totals the number of purchased items, prices, and consumption tax amounts of all general goods purchase records registered in the purchaser data file 35, and overwrites the total general goods data in the purchaser data file 35. . Similarly, the CPU 311 totals the number of purchased items, prices, and consumption tax amounts of all consumables purchase records registered in the purchaser data file 35, and overwrites the total consumables data in the purchaser data file 35.

Thereafter, the CPU 311 overwrites and stores the purchaser data file 35 on the RAM 43 in the auxiliary storage device 314 as Act 74, and closes the purchaser data file 35. With this, the CPU 311 ends the tax-free purchase data reception process.

A non-resident who has finished shopping at each duty-free shop 4 goes to a counter 6 for procedures. The non-resident then presents the tax exemption card C or tax exemption sheet S to the person in charge of the business.
When a non-resident presents a tax exemption card C or a tax exemption sheet S, the business person activates the payment terminal 60. For example, the payment terminal 60 is activated when the touch panel 507 is touched. When the payment terminal 60 is activated, the CPU 601 starts processing of the procedure shown in the flowchart of FIG. 13, ie, so-called payment processing.

First, the CPU 601 receives the purchaser code as Act 31. Specifically, the CPU 601 causes the touch panel 607 to display guidance such as "Please let me read the data on the tax exemption card" or "Please scan the barcode on the tax exemption sheet." After confirming this guidance, the business person causes the card reader 609 to read the data of the tax exemption card C presented by the non-resident. Alternatively, the business person causes the scanner 608 to read the barcode of the tax exemption sheet S presented by the non-resident. When the data on the tax exemption card C is read by the card reader 609, the CPU 601 receives the data as a purchaser code. When the barcode of the tax exemption sheet S is read by the scanner 608, the CPU 601 receives the code obtained by analyzing the barcode as the purchaser code. Here, the computer mainly including the CPU 601 constitutes a first receiving means that receives the purchaser code of the purchaser who wishes to receive a refund for the purchase of the article through the process of Act 31.

Next, in Act 32, the CPU 601 determines whether the purchaser code has been properly received. For example, if the card data read by the card reader 609 is analyzed, but the code system does not match the code recorded on the tax exemption card C, the CPU 601 determines that the purchaser code could not be received. Similarly, if the code system obtained from the barcode read by the scanner 608 is different from the system of the purchaser code generated from the passport number and date and time information, the CPU 601 cannot receive the purchaser code. It is determined that there was no such thing. If the purchaser code cannot be received (NO in Act 32), the CPU 601 displays an error message such as "Purchaser code could not be read" on the touch panel 607, for example. This completes the payment process.

If the purchaser code can be received (YES in Act 32), the CPU 601 requests the purchaser data file 35 from the management server 31 in Act 33. Specifically, the CPU 601 generates an inquiry command for the purchaser data file 35 including the purchaser code received in the process of Act 31, and notifies the communication interface 606 to send it to the management server 31. Upon receiving this notification, the communication interface 606 transmits an inquiry command to the management server 31 via the network 7.

The CPU 311 of the management server 31 that receives the inquiry command searches the purchaser data file 35 in which the purchaser code in the command is set. When the CPU 311 detects the corresponding purchaser data file 35, the CPU 311 transmits the purchaser data file 35 via the network 7 to the payment terminal 60 that is the source of the inquiry command.

The CPU 601 that sent the inquiry command checks whether there is a response from the purchaser data file 35 in Act 34. If there is no response from the purchaser data file 35 (NO in Act 34), the CPU 601 causes the touch panel 607 to display an error message such as "Purchaser data could not be obtained." With this, the payment processing shown in FIG. 11 is completed.

If there is a response from the purchaser data file 35 (YES in Act 34), the CPU 601 stores the purchaser data file in the work area of the RAM 313. Then, the CPU 601 executes the following processing on this purchaser data file. That is, the CPU 601 checks the tax exemption point in Act 35. Specifically, the CPU 601 determines whether the amount of general goods total data stored in the purchaser data file 35 (total price excluding tax) is equal to or greater than the lower limit amount "10,001 yen" that is certified as a tax exemption point. confirm. In addition, the CPU 601 determines whether the amount of consumables total data (total price excluding tax) stored in the purchaser data file 35 has changed from the lower limit amount of "5,011 yen" that is certified as a tax exemption point to the upper limit amount of "5,000 yen". Check if the amount is within the range of 10,000 yen.

After checking the tax exemption points in this manner, the CPU 601 determines whether or not the item is subject to tax exemption in Act 36. Specifically, in the process of Act 35, if the amount of general goods total data is equal to or higher than the minimum amount that is certified as tax exemption point for general goods, or if the amount of consumables total data is tax exempt for consumables. If the amount is within the range from the minimum amount to the maximum amount recognized as a point, the CPU 601 determines that the amount is eligible for tax exemption. If the amount of general goods total data is less than the lower limit amount that is recognized as the tax exemption point for general goods, or the lower limit amount that the amount of consumables total data is recognized as the tax exemption point for consumables If the amount is less than the maximum amount or exceeds the upper limit amount, the CPU 601 determines that the amount is not eligible for tax exemption.

If it is determined that the item is not eligible for tax exemption (NO in Act 36), the CPU 601 displays a message such as "Not eligible for tax exemption" on the touch panel 607 in Act 37. Further, the CPU 601 generates tax exempt data as Act 38. This non-tax exemption data includes the purchaser code acquired in the process of Act 31. Thereafter, the CPU 601 proceeds to the process in Act44.

On the other hand, if it is determined that the amount is tax exempt (YES in Act 36), the CPU 601 calculates the tax exempt amount, the so-called tax exempt amount, in Act 39. This tax exemption amount calculation process will be specifically explained using FIG. 14.

That is, the CPU 601 forms the data table 64 in the RAM 603 as Act 101. Next, the CPU 601 detects the first purchase record from the purchaser data file 35 received from the management server 31 as Act 102. The purchase record may be a general goods purchase record or a consumables purchase record.

The CPU 601 acquires the store code from the purchase record as Act 103. Then, in Act 104, the CPU 601 determines whether this store code is a new store code that is not registered in the data table 64 or an existing store code that has already been registered. In this case, since the store code is new (YES in Act 104), the CPU 601 sets the store code of the purchase record in the store code column of the data table 64 in Act 105. Further, the CPU 601 calculates the tax-included price by adding up the price of the purchase record and the consumption tax amount. Then, the CPU 601 sets the tax-included price, price, and consumption tax amount in the column of the total amount including tax, the column of the total amount excluding tax, and the column of tax-exempt amount in the data table 64. At this time, the store code, tax-included price, price, and consumption tax amount are set in the same line.

Next, in Act 107, the CPU 601 checks whether the purchaser data file 35 has the next purchase record. If there is a purchase record (YES in Act 107), the CPU 601 returns to the process in Act 102 and detects the purchase record. The CPU 601 then acquires the store code from the purchase record (Act 103), and determines whether this store code is a new code or an existing code (Act 104).

At this point, the store code may be a new store code or it may be an existing store code. If it is a new store code (YES in Act 104), the CPU 601 executes the process in Act 107 described above.

If it is an existing store code (NO in Act 104), the CPU 601 calculates the tax-included price by adding up the price of the purchase record and the consumption tax amount in Act 106. Then, the CPU 601 stores the tax-included price, price, and consumption tax amount in the column of the total amount including tax, the column of the total amount excluding tax, and the column of tax-exempt amount in the row in which the existing store code is stored in the data table 64. Add each to the data.

Next, in Act 107, the CPU 601 checks whether the purchaser data file 35 has the next purchase record. If there is a purchase record (YES in Act 107), the CPU 601 returns to the processing in Act 102 and repeats the subsequent processing in the same manner as above.

When the processing in Acts 102 to 106 is completed for all purchase records in the purchaser data file 35 (NO in Act 107), the CPU 601 stores the processing in the tax exemption amount column of the data table 64 as Act 108. Total amount data. Then, the CPU 601 displays the total amount of the tax exempt amount on the touch panel 607 as the refund amount. For example, the CPU 601 causes the touch panel 607 to display "The tax exempt amount XXX yen will be refunded." With this, the tax exemption amount calculation process ends.

In this way, when a non-resident is eligible for tax exemption, the touch panel 607 displays the refund amount (total amount eligible for tax exemption). Incidentally, if a non-resident is not eligible for tax exemption, a message such as ``Not eligible for tax exemption'' will be displayed as described above. Therefore, the person in charge of business can easily identify whether or not a non-resident is eligible for tax exemption from the content displayed on the touch panel 607.

The explanation returns to FIG. 13.
When the tax exemption amount calculation process is completed, the CPU 601 creates a purchaser oath based on the data in the purchaser data file 35 as Act 40. A purchaser's pledge will be prepared for each of the four duty-free shops.

The purchaser's written oath requires common items such as the purchaser's (non-resident) name, nationality, date of birth, passport number, etc. The CPU 601 obtains this information from the non-resident data in the purchaser data file 35. In addition, the purchaser's pledge requires the date of purchase as a common item. The CPU 601 obtains the date of purchase from the reception date and time data in the purchaser data file 35. Alternatively, the date of purchase may be obtained from the date and time data clocked by the clock unit 605. In addition, the purchaser's written oath requires the name or name of the business operator who operates the duty-free shop 4 as a common item. The auxiliary storage device 604 of the payment terminal 60 stores a data table in which the name or name of the duty-free shop operator is set in association with the store code of each duty-free shop 4. The CPU 601 obtains the name of the business operator from the data table using each store code included in the general goods purchase record and the consumables purchase record as a key.

On the other hand, the purchaser's pledge requires the item names, quantities, and tax-excluded prices of all purchased items classified as general goods, as well as the total of the tax-excluded prices. The CPU 601 obtains this information from the general goods purchase record and the general goods total data in the purchaser data file 35. Similarly, the purchaser's pledge requires the item names, quantities, and tax-excluded prices of all purchased items classified as consumables, as well as the total of the tax-excluded prices. The CPU 601 obtains this information from the consumables purchase record and the total consumables data in the purchaser data file 35.

Additionally, the purchaser's pledge requires the purchaser's signature as a common item. After confirming the purchaser's oath, the person in charge requests the non-resident to sign (electronic signature) on the pen tablet 62. The CPU 601 accepts input of an electronic signature. Specifically, CPU 601 takes in handwriting data from pen tablet 62 via external device interface 611. Then, the CPU 601 stores this handwriting data in the work area as electronic signature data by the non-resident purchaser.

Further, the auxiliary storage device 604 of the payment terminal 60 stores layout data of a purchaser's pledge in which the pledge to the duty-free shop is recorded in the buyer's native language. The CPU 601 obtains the layout data of the purchaser oath for the number of store codes included in the general goods purchase record and the consumables purchase record of the purchaser data file 35. Then, the CPU 601 completes the electronic data of the purchaser oath for each duty free store 4 by arranging the data of the record items acquired from the purchaser data file 35 and the like in the layout data.

Next, the CPU 601 issues a purchase record slip or the like based on the data in the purchaser data file 35 as Act 41. The purchase record slip contains the seller's information (name), the purchaser's information (name, date of birth, passport number, etc.), the date of purchase, and information related to the purchased product (item name, tax excluded). It describes the sales price, number of items sold, total amount excluding tax, etc.) and precautions. For this reason, the auxiliary storage device 604 of the payment terminal 60 stores layout data of a purchase record slip in which precautions are written in the native language. The CPU 601 completes the print data of the purchase record form by arranging the data of the descriptive items acquired from the purchaser data file 35 or the like in this layout data. Then, the CPU 601 notifies the printer interface 610 that the print data of the purchase record form will be output to the printer 61. Upon receiving this notification, the printer interface 610 outputs the print data of the purchase record slip to the printer 61. Through the above processing, the printer 51 is driven and a purchase record slip is issued.

Next, the CPU 601 performs refund processing as Act 42. Specifically, the CPU 601 notifies the external device interface 612 that the withdrawal data of the tax exemption amount (refund amount) calculated in the process of Act 39 will be output to the dispensing machine 63. Upon receiving this notification, the external device interface 612 outputs the withdrawal data to the withdrawal machine 63. Through the above processing, the dispensing machine 63 is activated and cash corresponding to the tax exemption amount is dispensed.

Next, the CPU 601 generates tax exemption settlement data as Act 43. Specifically, the CPU 601 adds the date and time data (settlement date and time) clocked by the clock unit 605 to the purchaser code acquired in the process of Act 31, the data of the data table 64 created in the process of Act 39, and the process of Act 41. The electronic data of the purchaser's written oath created in 2018 will be attached as tax-exempt settlement data. After generating the tax exemption settlement data in this way, the CPU 601 proceeds to the process of Act 44.

In Act 44, the CPU 601 transmits the tax-exempt settlement data generated in the process of Act 43 or the non-tax-exempt data generated in the process of Act 38 to the management server 31. Specifically, the CPU 501 notifies the communication interface 606 to transmit tax-exempt settlement data or tax-exempt data to the management server 31. Upon receiving this notification, the communication interface 606 transmits the tax-exempt settlement data or the non-tax-exempt data to the management server 31 via the network 7 . Here, the computer mainly including the CPU 601 cooperates with the communication interface 606 to constitute an output means for outputting the tax exempt amount calculated for each duty free shop.

The CPU 311 of the management server 31 that has received the tax-exempt settlement data or the non-tax-exempt data starts information processing according to the procedure shown in the flowchart of FIG.
First, in Act 81, the CPU 311 confirms whether the received data is tax exemption settlement data. If the received data is tax-exempt payment data (YES in Act 81), the CPU 311 acquires a purchaser code from the tax-exempt payment data in Act 82. Then, as Act 83, the CPU 311 stores the payment date and time data included in the tax exemption payment data in the purchaser data file 35 including the acquired purchaser code.

Next, the CPU 311 selects the total table 36 in Act84. In the present embodiment, the auxiliary storage device 314 stores a plurality of aggregation tables 36 in which the aggregation period is monthly. The CPU 311 selects the summary table 36 of the month to which the payment date and time included in the tax exemption payment data belongs.

If the total table 36 is selected, the CPU 311 detects the data of the data table 64 from the tax exemption settlement data in Act 85. Then, the CPU 311 sequentially acquires store codes from the first row of the data table 64 as Act 86. Then, in Act 87, the CPU 311 determines whether this store code is a new store code that is not registered in the tally table 36 or an existing store code that has already been registered. If it is a new store code (YES in Ac87), the CPU 311 stores the store code in Act 88, and the data of the total amount including tax, total amount excluding tax, and tax exemption amount stored in the same line as the store code. are stored in order from the first row of the total table 36.

On the other hand, if the code is an existing store code (NO in Act 87), the CPU 311, in Act 89, calculates the total amount including tax, total amount excluding tax, and Each data of the tax exemption amount is updated to a value obtained by adding the total amount including tax, total amount excluding tax, and tax exemption amount stored in the same row as the existing store code in the data table 64.

In Act 90, the CPU 311 checks whether the data table 64 has the next store code. If there is a next store code, the CPU 311 returns to Act 86 and executes the subsequent processes in the same manner as described above. That is, the CPU 311 obtains the next store code (Act 86), and determines whether it is a new store code or an existing store code (Act 87). If it is a new store code (YES in Ac87), the CPU 311 stores the store code and the data of the total amount including tax, total amount excluding tax, and tax exemption amount stored in the same line as the store code. is stored in the total table 36 (Act 88). If it is an existing store code (NO in Act 87), the CPU 311 stores the data of the total amount including tax, total amount excluding tax, and tax exemption amount in the row in which the existing store code is stored in the tally table 36. , the total amount including tax, total amount excluding tax, and tax exemption amount stored in the same row as the existing store code in the data table 64 are updated to a value obtained by adding each data (Act 89).

Here, the computer mainly including the CPU 331 constitutes a totaling means for totalizing the amount of tax-free items for each duty-free shop within a predetermined period based on the data of the data table 64 sent from the payment terminal 60.

In this way, when the processing in Acts 86 to 89 is completed for all store codes stored in the data table 64 (NO in Act 90), the CPU 311 acquires the electronic data of the purchaser's oath from the tax exemption settlement data in Act 91. , and stored in the auxiliary storage device 314. With this, the CPU 311 ends the tax exemption settlement data reception process.

On the other hand, if the received data is not tax-exempt settlement data (NO in Act 81), the CPU 311 checks in Act 92 whether the received data is data that is not subject to tax exemption. If the received data is data not subject to tax exemption (YES in Act 92), the CPU 311 acquires a purchaser code from the data not subject to tax exemption in Act 93. Then, the CPU 311 deletes the purchaser data file 35 including the acquired purchaser code from the auxiliary storage device 314 as Act 94. With this, the CPU 311 ends the process of receiving data that is not subject to tax exemption.

In this way, in the facility 2 where the tax exemption processing system 1 of the present embodiment is constructed, non-residents such as foreign travelers who present proof of tax exemption eligibility such as a passport at the reception counter 5 The person receives a tax exemption card C or tax exemption sheet S from the person in charge at the reception counter 5. Thereafter, the non-resident goes to the duty-free shop 4 and presents the tax-free card C or the tax-free sheet S to the clerk and goes shopping. After finishing shopping in the facility 2, the non-resident goes to the procedure counter 6 and presents the tax exemption card C or the tax exemption sheet S to the person in charge. The person in charge of the procedure counter 6 operates the payment terminal 60 to read the data on the tax exemption card C or the barcode on the tax exemption sheet S.

Then, the payment terminal 60 collects from the management server 31 information related to sales of products purchased by the non-resident at each duty-free shop 4 within the facility 2. Based on this information, it is automatically checked whether the item is eligible for tax exemption or not. If the product is tax exempt, the total tax amount levied on the taxable product, the so-called tax exempt amount, is displayed on the touch panel 607 as the refund amount. Further, at the procedure counter 6, cash equivalent to this refund amount is paid out from a dispensing machine 63.

Therefore, conventionally, the person in charge of the procedure counter 6 has been able to classify the tax-exempt goods purchased by the non-resident into consumables and other general goods based on the information on the receipt that the non-resident has received from each duty-free shop 4. Previously, the tax-excluded price for each item was summed up to determine whether or not it was eligible for tax exemption, but all of this time and effort will be simplified. In addition, there is no need to calculate how much the tax-exempt amount is if the item is tax-exempt. As a result, the tax exemption procedure performed at the procedure counter 6 is simplified, and excellent effects such as reducing the burden on the person in charge and shortening the time required for the procedure can be achieved.

Additionally, non-residents do not present their passports or other documents at each duty-free shop 4. Therefore, there is no need for each duty-free shop 4 to prepare an OCR 52 for reading passport information, and the existing POS terminal 40 equipped with a scanner 411 and a card reader 412 can be used as the hardware. Therefore, it is possible to easily convert to a tax-free shop that handles procedures outsourcing without incurring equipment costs.

Furthermore, non-residents do not have to present their passports at each duty-free shop 4. Therefore, the risk of losing the passport due to dropping or theft can be reduced. Moreover, non-residents do not have to present a receipt at the procedure counter 6. Therefore, non-residents do not need to keep receipts issued at each duty-free shop 4 in their wallets or the like so as not to lose them. Therefore, the system is very efficient and easy to use even for non-residents.

Further, at the payment terminal 60, the total amount of tax levied on the taxable product is calculated for each store code of the duty-free shop that sold the product. Specifically, a data table 64 is created in the RAM 603 of the payment terminal 60 during processing for non-residents. In this data table 64, the tax-included price, tax-excluded price, and consumption tax amount of tax-exempt products purchased by non-residents are summed up for each store code of the duty-free store that sold the product. The total amount of consumption tax calculated for each store code is then calculated as the tax-exempt amount for each duty-free shop. The tax exemption amount for each duty free shop is stored in the data table 64. Therefore, by considering the data in this data table 64, the tax exemption procedure operator can easily obtain information on how much of the tax exemption amount refunded to non-residents at the procedure counter 6 should be collected from each duty free shop. can be obtained.

In the tax exemption processing system 1 of this embodiment, data in the data table 64 is sent from the payment terminal 60 to the management server 31. Based on the data in the data table 64, the management server 31 totals the amount of money to be collected from each duty-free shop, for example, for one month. Specifically, the management server 31 uses the aggregation table 36 stored in the auxiliary storage device 314 to aggregate the tax exempt amount for each store code stored in the data table 64 received within the aggregation period. The management server 31 has a function of issuing a report recording the collected amount for each duty-free shop based on the data in the aggregation table 36 when the aggregation period ends. This report issuing function will be explained below using FIGS. 18 and 19.

FIG. 18 is a flowchart showing the main steps of interrupt processing executed by the CPU 311 of the management server 31 according to the control program. Note that the content of the processing described below is an example, and various processing that can obtain similar results can be used as appropriate.

Each time the date counted by the clock unit 315 is updated to the next day, the CPU 311 starts the process shown in the flowchart of FIG. First, the CPU 311 determines as Act 111 whether or not there is any table in the total table 36 stored in the auxiliary storage device 311 whose date the day after the total end date matches the date on the clock unit 315 . If the corresponding tally table 36 does not exist (NO in Act 111), the CPU 311 ends the interrupt process.

If the corresponding tally table 36 exists (YES in Act 111), the CPU 311 creates a collection report 200 for each duty-free shop having the layout shown in FIG. 19, for example, based on the data in the tally table 36.

FIG. 19 is an example of a collection report 200 for each duty-free shop. The issue date 201 of the collection report 200 is the date recorded in the clock section 315. The period 202 of the collection report 200 is from the aggregation start date to the aggregation end date of the aggregation table 36. The store name 203, tax-included amount 204, tax-excluded amount 205, and collection amount 206 of the collection report 200 are data in the store code column, tax-included total column, tax-excluded total column, and tax-exempt amount column of the total table 36. The management server 31 is provided with a conversion table that associates store codes with store names, and the CPU 311 uses this conversion table to convert the store code in the store code string into a store name.

The CPU 311 transmits the data of the collection report 200 by duty free shop to the payment terminal 60 as Act 113. Specifically, the CPU 311 notifies the communication interface 316 to transmit the data of the collection report 200 by duty free shop to the payment terminal 60. Upon receiving this notification, the communication interface 316 transmits the data of the collection report 200 by duty free shop to the payment terminal 60 via the network 7 .

The CPU 601 of the payment terminal 60, which has received the data of the collection report 200 by duty free shop, notifies the printer interface 610 that this data will be output to the printer 61. Upon receiving this notification, the printer interface 610 outputs the data of the collection report 200 by duty free shop to the printer 61. Through the above processing, the printer 61 is activated and the collection report 200 for each duty-free shop is issued.

Therefore, by viewing the tax-free store collection report 200 issued from the payment terminal 6, the tax-exemption procedure operator can easily obtain information on how much to collect from each duty-free store 4 on a monthly basis, for example. can be grasped. Therefore, the person in charge of the procedure counter 6 does not have to manage the amount to be collected from each duty-free shop 4 when paying the tax-exempt amount to a non-resident, which greatly reduces the burden on the person in charge of the procedure counter 6. be done.

The explanation returns to FIG. 18.
As Act 114, the CPU 311 notifies the POS terminal 40 of each duty-free shop 4 of the tax-exempt amount (collected amount) compiled in the tally table 36 for each store code of the duty-free shop. Specifically, for each store code stored in the tally table 36, the CPU 311 generates a collection amount notification command with the store code as the destination address, and notifies the printer interface 610 to send this notification command. . Upon receiving this notification, the printer interface 610 transmits a notification command to the POS terminal 40 of each duty free shop 4 via the network 7.

The CPU 401 of the POS terminal 40 that receives the notification command checks whether the destination address matches its own store code. If they do not match, the CPU 401 discards the notification command. If they match, the CPU 401 causes the display 409 to display the collection amount included in the notification command. Therefore, for example, the manager of the duty-free shop 4 can easily grasp the collection period and collection amount of the tax-free amount by confirming that the collection amount is displayed on the display 409.

It goes without saying that in FIG. 19, the CPU 311 may first execute the process in Act 114 and then execute the process in Act 113.

The present invention is not limited to the embodiments described above.
For example, in the embodiment described above, the option of issuing a tax exemption card C or a tax exemption sheet S to a non-resident is set on the reception terminal 50, but this option may be omitted. That is, in the flowchart of FIG. 11, the control program may be configured so that when the determination is "YES" in the process of Act2, the process proceeds to the process of Act5. Alternatively, the control program may be configured so that when the determination in Act 2 is "YES", the process proceeds to Act 6. In the former case, the operation is limited to using the tax exemption card C. Therefore, the card readers 412, 508, and 609 may not be provided in the POS terminal 40, the reception terminal 50, and the payment terminal 60. In the latter case, the operation is limited to using the tax exemption sheet S. Therefore, the scanners 411 and 608 may not be provided in the POS terminal 40 and the payment terminal 60.

Further, in the embodiment described above, the reception terminal 50 converted the purchaser code generated from the passport number and date and time information into a barcode and printed it on the tax exemption sheet S. However, by using the card reader 508 as a card reader/writer, A purchaser code generated from the passport number and date and time information may be recorded on the tax exemption card C. Similarly, the reception terminal 50 may be equipped with a random number generator, generate a unique purchaser code using random numbers, and issue the tax exemption sheet S on which the barcode of this purchaser code is printed.

Further, in the above embodiment, a case has been described in which the collection report 200 for each duty-free shop is issued from the payment terminal 60, but the issuing machine for the collection report 200 for each duty-free store is not limited to the payment terminal 60. For example, it may be issued from the POS terminal 40 of each duty free shop. Alternatively, the information may be issued from the management server 31 by connecting a printer to the management server 31.

Further, in the embodiment, the function as a storage device is applied to the management server 31, but it is also possible to apply the function as a storage device to a device other than the management server 31, for example, the reception terminal 50 or the payment terminal 60.

Further, in the above embodiment, the case where the tax amount levied on taxable goods is fully refunded is shown, but it is also possible to refund a part of the tax amount by changing the method of calculating the refund amount. Further, it goes without saying that the amount of tax exemption points, which is the standard amount of tax exemption, is not limited to the amount in the embodiment.

Note that the transfer of the POS terminal 40, the reception terminal 50, and the payment terminal 60 is generally performed with programs such as a control program stored in the ROM. However, the present invention is not limited to this, and a control program or the like that is transferred separately from the computer device may be written in a writable storage device provided in the computer device in response to an operation by a user or the like. The control program and the like can be transferred by recording it on a removable recording medium or by communicating via a network. The recording medium may be in any form as long as it can store the program and is readable by the device, such as a CD-ROM or a memory card. Further, the functions obtained by installing or downloading a program may be realized in cooperation with an OS (operating system) or the like inside the device.

Although several other 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 implemented in various other forms, and various omissions, substitutions, and changes can be made without departing from the gist of the invention. These embodiments and their modifications are included within the scope and gist of the invention, as well as within the scope of the invention described in the claims and its equivalents.
Below, the invention described in the original claims of the present application will be added.
[1] Includes an information processing device and a storage device, wherein the storage device stores items purchased by a purchaser identified by the purchaser code in association with a purchaser code that identifies a purchaser who purchases the item. a purchaser data file that stores information related to the sale of the item along with a store code identifying the duty-free shop where the item was purchased, and the information processing device stores information regarding the sale of the item, and the information processing device stores information regarding the sale of the item, and the information processing device a first receiving means for receiving the purchaser code received by the first receiving means; a second receiving means for receiving from the storage device the purchaser data file associated with the purchaser code received by the first receiving means; a calculation means for calculating a tax-exempt amount for each duty-free shop based on information related to the sale of the article in the purchaser data file received by the second receiving means; and a calculation means for calculating the tax-free amount for each duty-free shop by the calculation means A tax exemption processing system comprising: an output means for outputting a target amount.
[2] The output means includes means for transmitting data indicating the amount of tax exemption calculated for each duty-free shop to the storage device, and the storage device is configured to perform processing based on the data sent from the information processing device. The tax exemption processing system according to appendix [1], further comprising a totaling means for totaling the tax exempt amount for each duty free shop within a predetermined period.
[3] Supplementary note [2], further comprising issuing means for issuing a collection report indicating the amount of tax exempt to be collected from each duty free shop based on the data compiled by the counting means. tax-free processing system.
[4] A first receiving means that receives a purchaser code that identifies a purchaser who wishes to receive a refund for the purchase of goods; The purchaser code received by the first receiving means is associated with a storage device having a purchaser data file that stores information related to the sale of the purchased item together with a store code that identifies the duty-free shop where the item was purchased. a second receiving means that receives the purchased purchaser data file, and calculates the tax-exempt amount for each duty-free shop based on the information regarding the sale of the goods in the purchaser data file received by the second receiving means. An information processing device comprising: a calculation means for calculating the amount of tax exempted by the calculation means; and an output means for outputting the tax-exempt amount calculated for each duty-free shop by the calculation means.
[5] The information processing device according to appendix [4], wherein the output means includes means for transmitting data indicating the tax-exempt amount calculated for each duty-free shop to the storage device.
[6] A computer is provided with a function to receive a purchaser code that identifies a purchaser who wishes to receive a refund for the purchase of an item, and is associated with the purchaser code so that the purchaser identified by the purchaser code makes a purchase. the purchaser data file associated with the received purchaser code from a storage device having a purchaser data file that stores information related to the sale of the purchased item together with a store code identifying the duty-free shop where the item was purchased; a function that calculates the amount eligible for tax exemption for each duty free shop based on the information related to the sale of the item in the received purchaser data file, and outputs the amount eligible for tax exemption calculated for each duty free shop. functions and programs to realize them.

1...Tax exemption processing system, 2...Specified commercial facility (facility), 3...Data center, 4...Duty free shop, 5...Tax exemption reception counter (reception counter), 6...Tax exemption procedure counter (procedure counter), 7...Computer network ( Network), 8...Refund receipt, 31...Management server, 32...Storage server, 34...Duty free item database, 35...Purchaser data file, 36...Tally table, 40...POS terminal, 50...Reception terminal, 51, 61... Printer, 52...OCR, 60...Payment terminal, 62...Pen tablet, 63...Payment machine, 64...Data table, C...Tax exemption card, S...Tax exemption sheet, 200...Collection report by duty free shop, 311,401, 501,601...CPU, 411,608...Scanner, 412,508,609...Card reader, 414,507,607...Touch panel.

Claims (6)

including an information processing device and a storage device,
The storage device is
A store code that identifies the store that sold the item, created for each item purchased by the purchaser identified by the purchaser code, in association with a purchaser code that identifies the purchaser who purchases the item, and a purchaser data file storing purchase records including the amount of tax levied on the sale of the item ;
an aggregation table having an area for storing a total amount including tax, a total amount excluding tax, and a tax amount for each store code in association with an aggregation period;
Equipped with
The information processing device includes:
a first receiving means for receiving the purchaser code of a purchaser who wishes to receive a refund for the purchase of goods;
a second receiving means for receiving the purchaser data file associated with the purchaser code received by the first receiving means from the storage device;
The store code is acquired from the purchase record stored in the purchaser data file received by the second receiving means, and the store code stores the total amount including tax, total amount excluding tax, and tax amount for each store code. If it is determined that it does not exist, the store code of the purchase record, the total amount including tax, the total amount excluding tax, and the If it is determined that the store code exists, the total amount including tax, total amount excluding tax, and tax amount stored in the data table in association with the store code. a first processing means for updating the purchase record to the sum of the total amount including tax, the total amount excluding tax, and the tax amount ;
Transmitting means for transmitting the data of the data table to the storage device together with date information after the first processing means finishes processing the purchase record stored in the purchaser data file;
Equipped with
The storage device is
receiving means for receiving data transmitted from the information processing device;
Selection means for selecting the aggregation table whose aggregation period is date information received together with the data, when the data of the data table is received by the reception means;
The total amount including tax, total amount excluding tax, and tax amount for each store code are acquired from the data table received by the receiving means, and the store code associated with the total amount including tax, total amount excluding tax, and tax amount is Check whether or not it exists in the aggregation table selected by the selection means, and if it does not exist, store the store code, total amount including tax, total amount excluding tax, and tax amount obtained from the data table in the aggregation table. If there is a store code, the total amount including tax, total amount excluding tax, and tax amount stored in the aggregation table in association with that store code are updated to the total amount including tax, total amount excluding tax, and tax for the same store code obtained from the data table, respectively. a second processing means for updating the amount by adding the deducted total amount and the tax amount;
A tax-free processing system equipped with the purchase record stored in the purchaser data file includes a price for the item;
The information processing device includes:
It is determined whether the purchase record is eligible for tax exemption based on the price of the purchase record stored in the purchaser data file received by the second receiving means, and if it is not eligible for tax exemption, the first receiving means generating means for generating non-tax exemption data including the purchaser code received at
The transmitting means includes means for transmitting the non-tax exemption data generated by the generating means to the storage device,
The storage device is
Claim further comprising: when the data received by the receiving means is data not subject to tax exemption, deletion means deletes the purchaser data file specified by the purchaser code included in the data not subject to tax exemption. The tax exemption processing system described in 1. The storage device is
creating means for creating a store-by-store collection report indicating the tax-exempt amount to be collected from each store based on the data in the aggregation table for which the aggregation period has ended ;
report transmitting means for transmitting the store-by-store collection report to the information processing device;
The tax exemption processing system according to claim 1 , further comprising : A store code that identifies the store that sold the item, created for each item purchased by the purchaser identified by the purchaser code, in association with a purchaser code that identifies the purchaser who purchases the item, and A purchaser data file for storing purchase records including the amount of tax levied on the sale of the item, and for storing the total amount including tax, total amount excluding tax, and tax amount for each store code in association with the aggregation period. An information processing device constituting a tax exemption processing system together with a storage device having a tally table having an area of
a first receiving means for receiving the purchaser code of a purchaser who wishes to receive a refund for the purchase of goods;
a second receiving means for receiving the purchaser data file associated with the purchaser code received by the first receiving means from the storage device ;
The store code is acquired from the purchase record stored in the purchaser data file received by the second receiving means, and the store code stores the total amount including tax, total amount excluding tax, and tax amount for each store code. If it is determined that it does not exist, the store code of the purchase record, the total amount including tax, the total amount excluding tax, and the If it is determined that the store code exists, the total amount including tax, total amount excluding tax, and tax amount stored in the data table in association with the store code. a first processing means for updating the purchase record to an amount including the tax amount;
Transmitting means for transmitting the data of the data table to the storage device together with date information after the first processing means finishes processing the purchase record stored in the purchaser data file;
An information processing device comprising : the purchase record stored in the purchaser data file includes a price for the item;
It is determined whether the purchase record is eligible for tax exemption based on the price of the purchase record stored in the purchaser data file received by the second receiving means, and if it is not eligible for tax exemption, the first receiving means further comprising generating means for generating non-tax exemption data including the purchaser code received at
5. The information processing apparatus according to claim 4 , wherein said transmitting means includes means for transmitting the non-tax exemption data generated by said generating means to said storage device . A store code that identifies the store that sold the item, created for each item purchased by the purchaser identified by the purchaser code, in association with a purchaser code that identifies the purchaser who purchases the item, and A purchaser data file for storing purchase records including the amount of tax levied on the sale of the item, and for storing the total amount including tax, total amount excluding tax, and tax amount for each store code in association with the aggregation period. A computer of an information processing device constituting a tax exemption processing system together with a storage device having a tally table having an area of
a first receiving means for receiving the purchaser code of a purchaser who wishes to receive a refund for the purchase of goods;
second receiving means for receiving the purchaser data file associated with the purchaser code received by the first receiving means from the storage device ;
The store code is acquired from the purchase record stored in the purchaser data file received by the second receiving means , and the store code stores the total amount including tax, total amount excluding tax, and tax amount for each store code. If it is determined that it does not exist, the store code of the purchase record, the total amount including tax, the total amount excluding tax, and the If it is determined that the store code exists, the total amount including tax, total amount excluding tax, and tax amount stored in the data table in association with the store code. a first processing means for updating the purchase record to an amount including the tax amount; and
Transmitting means for transmitting the data of the data table to the storage device together with date information after the first processing means finishes processing the purchase record stored in the purchaser data file;
A program to function as