JP2019050063A - Information processing apparatus - Google Patents

Abstract

To perform various analyses related to tax exemption by items, nationalities, and the like for tax-exempt commodities.SOLUTION: An information processing apparatus comprises: a transaction history database storing transaction information that includes a transaction history including at least a commodity code, a unit price, and the number of commodity products sold of each commodity, and a transaction number identifying a transaction of the commodity dealt with by a commodity sales data processing apparatus, tax exemption information corresponding to the transaction number and indicating that the transaction is subjected to a tax exemption process, and a country of a person for whom the tax exemption process is performed, the country being input during the tax exemption process; a tax exemption/sales achievement database storing tabulation information on transaction histories tabulated for each relevant country for a predetermined period to correspond to the commodity code of each commodity subjected to the tax exemption process; tabulation means tabulating the transaction histories for each relevant country for the predetermined period to correspond to the commodity code of each commodity subjected to the tax exemption process on the basis of the transaction information stored in the transaction history database at predetermined timing; and update means updating the tabulation information in the tax exemption/sales achievement database on the basis of a tabulation result.SELECTED DRAWING: Figure 8

Description

  Embodiments of the present invention relate to an information processing apparatus.

  Conventionally, when a company operating an export goods sales floor (duty-free shop) sells a sale target such as goods to a non-resident such as a foreign traveler, the sales target is applied under certain conditions. There is a so-called tax exemption system that exempts consumption taxes and other taxes. In recent years, “consumables” such as foods, beverages, medicines, cosmetics and the like are also exempted from tax.

  Therefore, a technology has been disclosed that executes judgment of tax exemption conditions for a product for which transaction processing relating to sale of goods has been executed in a batch, and tax exemption processing for tax exempt products that satisfy the tax exemption condition.

  However, according to the prior art, although it is possible to count the tax exemption amount for tax exempt products, it is not possible to analyze various tax exemptions such as single items or nationalities for tax exempt products. there were.

  The problem to be solved by the present invention is to provide an information processing apparatus which can carry out various analyzes of tax exemption target items such as single items and nationalities.

  The information processing apparatus according to the embodiment is a transaction including at least a commodity code, a unit price, a sales score, and a transaction number for identifying the transaction, of the commodity traded by the commodity sales data processing device which performs sales registration related to the commodity transaction. History, tax exemption information indicating that the transaction has been tax exempted by the commodity sales data processing apparatus in association with the transaction number, and the country or region of the person who receives the tax exempt processing entered during the tax exempt processing, And a transaction history database storing transaction information including the items, sales items, sales for each country or region of the person who receives the tax exempt processing in association with the same commodity code among the commodities subjected to the tax exempt processing. A tax-free sales record database storing tally information obtained by tallying each amount and number of customers in a predetermined period, and the transaction history data at a predetermined timing Of the products subject to the tax exemption processing based on the transaction information stored in the source code, in association with the same commodity code, sales points, sales for each country or region of the person who receives the tax exemption processing The totaling means for totaling the amount of money and the number of customers in a predetermined period, and the updating means for updating the totalizing information of the tax-free sales record database based on the totaling result by the totaling means.

FIG. 1 is a schematic configuration diagram of a POS system according to the embodiment. FIG. 2 is a block diagram showing the hardware configuration of the server. FIG. 3 is a view showing an example of the data configuration of the product master file. FIG. 4 is a view showing an example of the data configuration of the tax exemption classification file. FIG. 5 is a view showing an example of the data configuration of the tax exemption set value file. FIG. 6 is a view showing an example of the data configuration of the country / region information master file. FIG. 7 is a view showing an example of the data configuration of the transaction history database. FIG. 8 is a view showing an example of the data configuration of a tax-exempt sales date-based actual result database. FIG. 9 is a block diagram showing the hardware configuration of the POS terminal. FIG. 10 is a functional block diagram showing a functional configuration of a control unit of the POS terminal. FIG. 11 is a flowchart showing the flow of control processing of the POS terminal. FIG. 12 is a flow chart showing the flow of tax exemption processing. FIG. 13 is a diagram showing an example of the confirmation screen. FIG. 14 is a diagram showing an example of the product registration screen. FIG. 15 is a diagram showing an example of the error screen. FIG. 16 is a diagram showing an example of the product registration screen. FIG. 17 is a diagram showing an example of a purchase written oath. FIG. 18 shows an example of a purchase record slip. FIG. 19 shows an example of a receipt. FIG. 20 is a functional block diagram showing a functional configuration of a control unit of the server. FIG. 21 is a flowchart showing the flow of control processing of the server.

  In the embodiment, a POS (Point Of Sales) system used in an export article sales office (duty-free shop) that sells a sales object provided for normal living to non-residents such as foreign travelers by a certain method. Will be explained. The embodiment is an example applied to a server that centrally manages POS terminals installed in a duty free shop as an information processing apparatus.

  FIG. 1 is a schematic configuration diagram of the POS system 1 according to the embodiment. As shown in FIG. 1, the POS system 1 comprises a plurality of (two in the figure) POS terminals 2 which are commodity sales data processing devices, and these POS terminals 2 by a network 3 such as a LAN (Local Area Network). And a server 4 which is an information processing apparatus connected and centrally managed.

  The server 4 is responsible for control of the entire POS system 1. FIG. 2 is a block diagram showing the hardware configuration of the server 4. The server 4 includes a control unit 400 having a computer configuration including a central processing unit (CPU) 41, a read only memory (ROM) 42, a random access memory (RAM) 43, and the like.

  The control unit 400 is connected to the communication I / F (interface) 50 via the bus 49. The server 4 mutually communicates online with the plurality of POS terminals 2 via the communication I / F 50 and the network 3 (see FIG. 1). Further, a keyboard 45, a display unit 46, and a printer 47 are connected to the control unit 400 via the bus 49 and the controller 44. Further, an HDD (Hard Disk Drive) 48 is connected to the control unit 400 via a bus 49. The HDD 48 stores various control programs 481 for operating the control unit 400. The HDD 48 also stores a product master file F1, a tax exemption classification file F2, a tax exemption setting value file F3, and a country / region information master file F4.

  Further, the HDD 48 holds a transaction history database (DB) DB1 as a database for accumulating transaction information related to the transaction for which sales registration processing has been performed in the POS terminal 2. Further, the HDD 48 holds a tax-exclusive sales date database (DB) DB 2 as a tax-exempt sales record database for accumulating information on products subject to tax-exempt processing described later in the POS terminal 2.

  The control program 481 executed by the server 4 according to the embodiment is a file of an installable format or an executable format, and may be configured to be recorded and provided in a computer readable recording medium. . Such a recording medium is a CD-ROM, a flexible disk (FD), a CD-R, a DVD (Digital Versatile Disk) or the like.

  Furthermore, the control program 481 executed by the server 4 of the embodiment may be stored on a computer connected to a network such as the Internet and provided by being downloaded via the network. The control program 481 executed by the server 4 of the embodiment may be provided or distributed via a network such as the Internet.

  Next, the product master file F1 and the product classification (classification) set in the product master file F1 will be described. FIG. 3 is a view showing an example of the data configuration of the product master file F1. As shown in FIG. 3, the product master file F1 is associated with the product code (product identification information) of each product for sale registration, and the product name or product price (unit price), the classification code (class 1 code, Commodity information such as classification 2 code), tax exemption classification code, dangerous goods classification code, etc. is set. The dangerous goods classification code is given to goods requiring care in handling such as sprays which are prohibited to be brought into the aircraft.

  Goods are classified by a plurality of classification codes, and the plurality of classifications are hierarchically constructed.

  That is, as shown in FIG. 3, the products are classified into a plurality of items according to classification 1 (upper classification) which is a rough classification. Also, each category 1 is further classified in more detail by category 2 (subclass), which is a more detailed classification. That is, the upper classification 1 is classified into a plurality of classifications by the classification 2 lower than the classification 1 and includes at least one lower classification 2.

  It should be noted that the product code assigned to each product can be regarded as a lower classification than classification 2 in that it is hierarchically constructed. The product code can be regarded as the most detailed classification, ie, the lowest classification.

  Next, the tax exemption classification file F2 will be described. FIG. 4 is a view showing an example of the data configuration of the tax exemption classification file F2. As shown in FIG. 4, in the tax exemption classification file F2, tax exemption classification names are set in association with the tax exemption classification code. The tax exemption classification names are "consumables", "general goods", and "excluded from tax exemption". "Consumables" is a tax-free item exempt from taxes on goods sold to non-residents such as foreign travelers, and is an article such as food, beverages, medicines, cosmetics, etc. . "General goods" are also goods subject to tax exemption, and are goods provided for ordinary life other than consumables. "Excluded from tax exemption" is a non tax exempt item that is not exempt from tax exemption. The tax exemption classification code of “consumables” is “01”. The tax exemption classification code of “general goods” is “02”. The tax exemption classification code for "tax exempt" is "03".

  Next, the tax exemption setting value file F3 will be described. FIG. 5 is a view showing an example of the data configuration of the tax exemption setting value file F3. As shown in FIG. 5, in the tax exemption set value file F3, a set value is set in association with the tax exemption classification code. The set value is a standard for performing sales registration as tax exemption in each division. In the example shown in FIG. 5, the set value for the consumable item of the tax exemption classification code "01" is 5,000 yen to 500,000 yen. In addition, the set value for the general goods (the articles to be used for normal life other than expendable goods) of the tax exemption classification code "02" is an amount exceeding 10,000 yen.

  The control unit 400 of the server 4 according to the embodiment distributes the product master file F1, the tax exemption classification file F2 and the tax exemption setting value file F3 to the POS terminal 2 at a predetermined timing according to the control program 481.

  FIG. 6 is a view showing an example of the data configuration of the country / region information master file F4. As shown in FIG. 6, in the country / region information master file F4, the name of the country / region is set in association with the country / region ID of the country or region of the person who receives tax exemption processing.

  Next, the transaction history database DB1 will be described. FIG. 7 is a view showing an example of the data configuration of the transaction history database DB1. As shown in FIG. 7, transaction information of the transaction processed by each of the POS terminals 2 is stored in the transaction history database DB1 as a transaction history. The transaction history is a transaction number (stored in the transaction number part DB 11) for identifying each transaction, the date and time of the transaction on which the transaction was made (stored in the transaction date part DB 12), and the POS terminal 2 on which the transaction was performed. Registration number (stored in the registration number part DB 13). The transaction history also includes the product code, the unit price, the number of sales (stored in the product information section DB 15) of each product registered for sale, and the like.

  Further, in the transaction history database DB1, a flag (stored in the flag portion DB 14) is set in association with the transaction number. Based on the flag stored in the flag portion DB 14, it is determined whether the transaction has been subjected to tax exemption processing described later. In the example shown in FIG. 7, a transaction with a flag of “0” means a transaction that has not undergone tax exemption processing, and a transaction with a flag of “1” is a transaction that has undergone tax exemption processing. means. In the case of FIG. 7, the transaction of the transaction number “0425” is tax-exempt processing, and the transaction of the transaction number “0426” and the transaction number “0427” is not tax-exempt processing. The transaction history database DB1 functions as an electronic journal that stores data of the history of transactions.

  Furthermore, in the transaction history database DB1, the nationality (stored in the nationality section DB 16) is set in association with the transaction number. The nationality stored in the nationality department DB 16 is the nationality of a non-resident (a person who receives tax exemption processing) such as a foreign traveler who is read from a passport during tax exemption processing, although the details will be described later.

  Next, the duty-free sales date result database DB2 will be described. FIG. 8 is a diagram showing an example of the data configuration of the tax exemption sales date result database DB2. As shown in FIG. 8, in the tax-excluded sales daily result database DB2, the non-exclusive traveler such as a foreign traveler is associated with a single item code (commodity code) of a product subject to tax-exempt processing described later in the POS terminal 2. A country / region ID indicating the country or region of the resident (who is subject to tax exemption processing), the number of sales points for each region, the sales amount, the number of customers, etc. are stored by day.

  In the present embodiment, although the daily tax-free sales results of the products subject to tax-free processing are tabulated, the present invention is not limited to this, and may be tabulated by week or month. .

  Next, the POS terminal 2 will be described. The POS terminal 2 is assigned a unique cash register number and arranged at a settlement location. The POS terminal 2 is a terminal for performing transaction processing based on a product code input by an operator (a cashier).

  The POS terminal 2 performs transaction processing relating to the sale of a product sold in the store. The transaction process is a process combining the sales registration process and the settlement process.

  In the sales registration process, the product name or price of the product is read by optically reading a code such as a barcode attached to the product to be sold, inputting the product code, and reading based on the input product code. It refers to the process of displaying product information in a buffer while displaying information).

  The settlement process is a process of displaying the total amount of the transaction, calculating and displaying a change based on the deposit deposited from the customer, and displaying the change, based on the product information stored in the buffer along with the sales registration process. Processing for instructing the change machine, processing for issuing a receipt on which product information and payment information (total amount, deposit amount, change amount, etc.) are printed.

  FIG. 9 is a block diagram showing the hardware configuration of the POS terminal 2. As shown in FIG. 9, the POS terminal 2 includes a control unit 300 having a computer configuration that includes a CPU 31, a ROM 32, a RAM 33, and the like. The CPU 31 executes various arithmetic processing to control each part. The ROM 32 fixedly stores fixed data. The RAM 33 stores variable data in a rewritable manner and is used as a work area. The CPU 31, the ROM 32, and the RAM 33 are connected via a bus line 34.

  In the RAM 33, a tax-exempt target amount table T is formed, which tabulates tax-exempt target amounts described later.

  Further, the POS terminal 2 is attached to a keyboard 21, a display unit 22 which is a liquid crystal display device provided with a touch panel on a display surface, a printer 23, a card reader / writer (R / W) 24, A scanner 25 for optically reading a code such as a bar code or a two-dimensional code, and a passport reader 27 are connected.

  The keyboard 21 arranges various keys for each block. The various keys are, for example, a numeric key for entering a product code, an amount, etc., a subtotal key for declaring calculation of the total sales amount, a total amount key for declaring cash closing in settlement processing, various types They are a PLU key for designating a product, a confirmation key for confirming the input of a numeral with a numeral key, and a clear key.

  In addition, the keyboard 21 includes a tax exemption declaration key K1 and an item name list output key K2. The tax exemption declaration key K1 is an operator that declares the transaction in order to carry out tax exemption processing. The item name list output key K2 is an operator for instructing output of a list (item name list) of items subject to tax exemption.

  The passport reader 27 is a reader device that reads information held by a passport (passport). In the embodiment, the passport reader 27 has an optical character recognition (OCR) function to optically read a character string described in the passport.

  In addition, the keyboard 21, the display unit 22, the printer 23, the card reader / writer 24, the scanner 25, and the passport reader 27 described above are connected to the control unit 300 via the bus line 34 and the controller 35. Further, a memory unit 26 which is a storage device is connected to the control unit 300 via a bus line 34. The memory unit 26 is configured by a hard disk drive (HDD), a flash memory, or the like, and maintains stored contents even when the power is shut off. The keyboard 21, the display unit 22, the printer 23, the card reader / writer 24, the scanner 25, the memory unit 26, and the passport reader 27 are controlled by the control unit 300.

  Furthermore, the POS terminal 2 is provided with a communication I / F (interface) 28 for performing data communication with the server 4 which is a higher-level device via the network 3 provided in the store. The communication interface 28 is also connected to the bus line 34.

  The memory unit 26 of the POS terminal 2 stores an operating system, control programs 261 such as various computer programs, and various data files. As data files, there are a commodity master file F1 distributed from the server 4, a tax exemption classification file F2, a tax exemption setting value file F3 and the like.

  The control program 261 executed by the POS terminal 2 of the embodiment is a file in an installable format or an executable format, and is a computer such as a CD-ROM, a flexible disk (FD), a CD-R, a DVD (Digital Versatile Disk). It is recorded and provided on a readable recording medium.

  Further, the control program 261 executed by the POS terminal 2 of the embodiment may be stored on a computer connected to a network such as the Internet and provided by being downloaded via the network. The control program 261 executed by the POS terminal 2 of the embodiment may be provided or distributed via a network such as the Internet.

  In addition, the control program 261 executed by the POS terminal 2 of the embodiment may be configured to be provided by being incorporated in a ROM or the like in advance.

  Next, control processing executed by the control unit 300 of the POS terminal 2 according to the embodiment according to the control program 261 will be described with reference to FIGS. 10 to 19.

  FIG. 10 is a functional block diagram showing a functional configuration of the control unit 300 of the POS terminal 2. The control unit 300 functions as the tax exemption processing unit 301 by following the control program 261 stored in the memory unit 26.

  The tax exemption processing unit 301 has a function of performing tax exemption processing for exempting a tax from the amount of the product subject to tax exemption.

  FIG. 11 is a flowchart showing the flow of control processing of the POS terminal 2. As shown in FIG. 11, the control unit 300 of the POS terminal 2 determines whether a product code for specifying a product has been input using the scanner 25 (step S11). If it is determined that an input has been made (Yes in step S11), the control unit 300 searches for the product based on product information such as a product name and a unit price obtained by searching the product master file F1 according to the input product code. Execute sales registration processing to calculate the registration amount. Then, the control unit 300 stores the product information of the product for which the sales registration process has been performed in the RAM 33 (step S12).

  In addition, when it is determined that the product code is not input (No in step S11), the control unit 300 determines whether the total key provided on the keyboard 21 for making a declaration for ending the transaction has been operated. It is determined (step S13). If it is determined that the operation has been performed (Yes in step S13), the control unit 300 executes, for the transaction, a settlement process of calculating the total amount based on the registered amount of the product and the product information (step S14). The settlement process executed in step S14 is a settlement process for calculating the total amount including the taxed tax amount such as consumption tax on the product purchased by the customer.

  Then, the control unit 300 prints product information, payment information and the like of the product for which payment processing has been performed on a receipt sheet, and issues a receipt (step S15). In the issued receipt, a transaction number specifying the transaction is printed in the form of a bar code. Then, the control unit 300 transmits the transaction information (transaction number, transaction date, register number, commodity code, unit price, sales points, etc.) of the commodity subjected to transaction processing to the server 4 (step S16). The server 4 stores the received information in the transaction history database DB1. Specifically, the control unit 400 of the server 4 stores the transaction number in the transaction number unit DB11. The control unit 400 stores the transaction date and time in the transaction date and time unit DB 12. The control unit 400 stores the cash register number of the POS terminal 2 subjected to the transaction processing in the cash register number part DB 13. The product code, the unit price and the sales points of the traded product are stored in the product information section DB 15. Further, the control unit 400 stores a flag “0” indicating that the transaction is not subjected to tax exemption processing in the flag unit DB 14 in association with the transaction number of the transaction.

  When it is determined that the total key is not operated (No in step S13), the control unit 300 determines whether the tax exemption declaration key K1 is operated (step S21). If it is determined that the operation has been performed (Yes in step S21), the control unit 300 executes the tax exemption process shown in FIG. 12 (step S22) on the assumption that there is a declaration of the tax exemption process.

[Tax-free processing]
Here, the tax exemption processing performed in step S22 when the tax exemption declaration key K1 is operated will be described in detail with reference to FIGS. 12 to 19. FIG. 12 is a flow chart showing the flow of tax exemption processing. In FIG. 12, the control unit 300 causes the passport reader 27 to operate. Then, the control unit 300 determines whether the passport reader 27 reads a predetermined character string from the passport (step S51). As such a character string, for example, a passport number, name, nationality, date of birth, etc. may be mentioned. The control unit 300 causes the display unit 22 to display a message indicating that the passport is being read until the predetermined character string is read from the passport.

  The control unit 300 causes the display unit 22 to display a guide screen (not shown) prompting reading of a passport. The operator of the POS terminal 2 opens a page in which matters concerning the tax exemption system are described in a passport presented by a customer (non-resident), and sends the page to the passport reader 27. In response to this operation, the control unit 300 reads a predetermined character string from the passport.

  The process waits until the passport is read (No in step S51), and when it is determined that the passport is read (Yes in step S51), the control unit 300 confirms the display unit 22 to confirm the character string read in step S51. The screen G3 (FIG. 13) is displayed (step S52).

  FIG. 13 is a diagram showing an example of the confirmation screen. As shown in FIG. 13, on the confirmation screen G3, the character string read in step S51 is displayed for each item (item). FIG. 13 illustrates an example of reading the character string of the passport number, the name, the nationality, and the date of birth among the items described in the passport.

  Here, a delete button B1 is provided in association with each item of the confirmation screen G3. Control unit 300 determines the presence or absence of the operation of this delete button B1 (step S53). If it is determined that the operation has been performed (Yes in step S53), the control unit 300 deletes the character string read for the corresponding item (step S54), and returns to step S53. For example, when there is an error in the character string of any item among the character strings of each item read in step S51, the character string with an error can be deleted by operating the delete button B1. . The control unit 300 displays a confirmation screen G3 in which the character string of the item deleted in step S54 is empty.

  Further, the control unit 300 displays, on the confirmation screen G3, a confirmation button B2, a reread button B3 and a cancel button B4 corresponding to the confirmation receiving means of the embodiment. When the control unit 300 determines that the delete button B1 is not operated (No in step S53), the control unit 300 determines whether or not the reread button B3 is operated (step S55). If it is determined that the operation has been performed (Yes in step S55), the process returns to step S51 to read the character string from the passport again. It is assumed that the character string read last time is deleted in response to the operation of the re-reading button B3.

  When it is determined that the rereading button B3 is not operated (No in step S55), the control unit 300 determines whether the cancel button B4 is operated (step S56). If it is determined that the character string has been operated (Yes in step S56), all the read character strings are deleted (step S57), and the process returns to step S51. In addition, in response to the operation of the cancel button B4, the control unit 300 returns the display screen of the display unit 22 from the confirmation screen G3 to the product registration screen (not shown).

  When it is determined that the cancel button is not operated (No in step S56), the control unit 300 determines the presence or absence of the operation of the confirmation button B2 (step S58). If it is determined that the operation has been performed (Yes in step S58), the control unit 300 displays a product registration screen G4 (see FIG. 14) (step S59). Subsequently, the control unit 300 (tax exemption processing means 301) executes tax exemption processing (step S60). If it is determined that the confirmation button B2 is not operated (No in step S58), the process returns to step S53.

  FIG. 14 shows an example of the product registration screen G4. In FIG. 14, a tax exemption indicator I displayed as “tax exemption” is displayed on the commodity registration screen G4. The control unit 300 notifies the operator that the transaction is a tax exemption declaration transaction by displaying the tax exemption indicator I on the commodity registration screen G4 as described above.

  Here, the tax exemption process of step S60 will be described.

  First, the control unit 300 refers to the tax exemption classification code of the commodity master file F1 for the registered commodity that has already been registered, and determines the tax exempt object commodity that is subject to tax exemption. When there is a tax-exempt target product, the control unit 300 performs an addition process to the tax-exempt target amount table T of the tax-exempt target amount for each registered commodity group (general article group / consumables group) to be tax-exempt target.

  The correspondence according to the tax type of the tax exempt product is as follows.

When the registered product to be exempted from tax exemption is the internal tax, the control unit 300 adds the tax-excluded amount of the registered amount to the tax exempt object amount table T as the exempted amount. More specifically, in the case of a tax-included product, the control unit 300 sets the difference between the pre-tax exemption registration amount and the post-tax exemption registration amount as the tax exemption amount.
・ Price before tax exemption 1080 yen-Price after tax exemption 1000 yen → amount of tax exemption 80 yen

  If the registered product subject to tax exemption is an external tax, the control unit 300 adds the registered amount to the tax exempt object amount table T as a tax exempt object amount. More specifically, in the case of a foreign tax product, the control unit 300 sets the foreign tax amount for the registered amount as the tax exemption amount.

  When the registered product is a product that is not subject to tax exemption, the control unit 300 does not add the registration amount to the tax exemption target amount table T as the tax exemption target amount.

  Next, the control unit 300 determines whether the tax exemption target amount of the tax exemption target amount table T satisfies the set value (standard amount) of the tax exemption set value file F3. In the tax exemption set value file F3 of the embodiment, set values for foodstuffs, beverages, medicines, cosmetics, and other consumables are 5,000 yen to 500,000 yen. In addition, the setting value for a general item (an item to be provided for normal life other than consumables) is an amount exceeding 10,000 yen.

  If the control unit 300 determines that the tax-exempt target amount for the consumable item satisfies the set value (5,000 yen to 500,000 yen), the control unit 300 performs the tax-excluded process for exempting the tax on the tax-exempt target amount. In addition, when the control unit 300 determines that the tax-exempt target amount for general goods (goods to be used for ordinary life other than consumables) satisfies the set value (an amount exceeding 10,000 yen), the tax-free target amount Tax exemption from taxation.

  The control unit 300 displays an error on the display unit 22 when the tax exempt object amount for the consumable item of the tax exempt object amount table T exceeds the upper limit value (500,000 yen) of the set value.

  FIG. 15 is a diagram showing an example of the error screen. As shown in FIG. 15, at the time of the tax exemption declaration by the operation of the tax exemption declaration key K1, the control unit 300 sets the error screen G5 as “The tax exemption upper limit has been exceeded. Please cancel the product. "XX, XXX yen" is displayed. The control unit 300 erases the error screen when the clear key of the keyboard 21 is operated.

  After execution of such tax exemption processing, the control unit 300 redisplays the product registration screen (step S61). Here, FIG. 16 is a diagram showing an example of the commodity registration screen G7 after the redisplay. As shown in FIG. 16, on the product registration screen G7 after redisplay, the tax amount is set to "0 yen" by tax exemption by tax exemption processing. Further, as shown in FIG. 16, the product registration screen G7 after redisplaying is the total displayed amount as the amount after tax exemption processing (the amount obtained by reducing the exempted tax portion). Furthermore, the commodity registration screen G7 after redisplaying displays the character "exempt" on the tax exempted commodity, that is, the commodity subjected to tax exemption processing.

  Next, the control unit 300 refers to the product master file F1 and determines the presence or absence of a product of the dangerous goods category in the tax-free product (step S62). If it is determined that there is a commodity of the dangerous goods category (Yes in step S62), the control unit 300 pops up a warning screen (not shown) on the display unit 22 (step S63). The control unit 300 erases the warning screen when the clear key of the keyboard 21 is operated. When it is determined that there is no commodity of the dangerous goods classification (No in step S62), the control unit 300 does not execute step S63.

  Next, the control unit 300 determines whether the total key has been operated (step S64). It waits until it is operated (No in step S64), and when it is judged that it is operated (Yes in step S64), the control unit 300 calculates the total amount of the transaction based on the registered amount of the product and the product information. The settlement process is performed (step S65). The settlement process executed in step S65 is a settlement process for calculating the total amount not including the tax amount without adding the tax such as the consumption tax to the sold product, since the tax exemption process is performed.

  Then, the control unit 300 uses the server 4 for transaction information (transaction number, transaction date, cash register number, product code, unit price, sales score, etc.) of the product subjected to payment processing, tax exemption information, and the country or region of the person who receives tax exemption processing. (Step S66). The server 4 having received the transaction information stores the received information in the transaction history database DB1. Specifically, the control unit 400 of the server 4 stores the transaction number in the transaction number unit DB11. The control unit 400 stores the transaction date and time in the transaction date and time unit DB 12. The control unit 400 stores the cash register number of the POS terminal 2 subjected to the transaction processing in the cash register number part DB 13. The product code, the unit price and the sales points of the traded product are stored in the product information section DB 15. Then, the control unit 400 stores a flag “1” indicating that the transaction has undergone tax exemption processing in the flag unit DB 14 in association with the transaction number of the transaction. In addition, the control unit 400 stores the nationality of the non-resident such as a foreign traveler read from the passport in the tax-exempt processing in the nationality unit DB 16 in association with the transaction number of the transaction.

  Next, the control unit 300 prints and issues the product information, the payment information, the tax exemption amount, and the like of the product subjected to the payment processing on the receipt sheet (step S67).

  In the processing of step S67, the control unit 300 prints, for example, one purchase written oath, two purchase record votes, and one receipt in the case of a transaction subjected to tax exemption processing.

  First, explain the purchase written oath. FIG. 17 is a view showing an example of the purchase written oath R1. The purchase written oath R1 is a document that describes the fact of purchase of duty-free goods. The purchase written oath R1 is attached to a document (purchaser written oath) as a store refusal and is submitted to the company operating the duty free shop.

  As shown in FIG. 17, the purchase written oath R1 is the name or name a of the company operating the duty-free shop, jurisdiction tax signature b, store location c of the duty-free shop, transaction date d, transaction number e, cash register number f, item description of item (item name g, quantity per item name and price h), total amount i of all articles, total amount j of general articles and expendables, and tax exemption amount k.

The purchase written oath R1 has a field for printing the character string of each item confirmed on the confirmation screen G3. Specifically, in the purchase written oath R1, the character string confirmed on the confirmation screen G3 for the following items is printed.
・ Passport number ... l
・ Nationality of the buyer ... m
・ Buyer's name ... n
・ Buyer's date of birth ... o

  In addition, about the item (character string) deleted by operation of deletion button B1 on the confirmation screen G3, only the item name shall be printed and it shall be directly filled in on a document (purchase written oath). Further, the layout of the purchase written oath R1 is not limited to the example shown in FIG. For example, it may be printed that it purports to export after purchase (in the case of consumables, it purports to export within 30 days from the date of purchase), the purchaser's signature column, etc.

  Next, the purchase record slip will be described. FIG. 18 is a view showing an example of the purchase record slip R2. The purchase record slip R2 is a document describing the fact of purchase of duty-free goods. The purchase record slip R2 shown in FIG. 18 is printed as two sheets for attachment to a document (purchase slip) and for store refusal. The purchase record slip R2 for attachment is attached to the document (purchase record slip). This document (purchase record slip) is attached to the passport and is stamped.

  As shown in FIG. 18, the purchase record slip R2 is the name or name a of the company operating the duty-free shop, jurisdiction tax signature b, store location c of the tax-free shop, transaction date d, transaction number e, cash register number f, item description of item (item name g, quantity per item name and price h), total amount i of all articles, total amount j of general articles and expendables, and tax exemption amount k.

The purchase record slip R2 has a field for printing the character string of each item confirmed on the confirmation screen G3. Specifically, in the purchase record slip R2, the character string confirmed on the confirmation screen G3 for the following items is printed.
・ Passport number ... l
・ Nationality of the buyer ... m
・ Buyer's name ... n
・ Buyer's date of birth ... o

  As for the item (character string) deleted by the operation of the delete button B1 on the confirmation screen G3, only the item name is printed and written directly on the document (purchase record slip) as in the purchase written oath R1. I assume. Further, the layout of the purchase record slip R2 is not limited to the example of FIG.

  Next, the receipt will be described. FIG. 19 shows an example of the receipt R3. The receipt R3 is passed to the buyer after the transaction.

  As shown in FIG. 19, the receipt R3 is the name or name a of the business owner who operates the duty-free shop, transaction date d, transaction number e, register number f, specification of goods (item name g, quantity per item name and Including the price h), the total amount i of all items. In addition, as shown in FIG. 19, in the case of a tax-exempt-targeted product, “excluded” p is printed as the tax printing. Also, in the case of a tax-free transaction, a tax-free message "Tax-free transaction has been made." Q is printed on the receipt R3. In addition, on the receipt R3, a barcode w encoding the transaction number e is printed.

  When the information stored in the transaction history database DB1 does not function as a journal, the control unit 300 executes journal printing corresponding to the purchase record slip R2 and the receipt R3. At this time, the control unit 300 prints a character string of all or part of the items confirmed on the confirmation screen G3 on the journal corresponding to the receipt R3.

  As described above, the control unit 300 reads a predetermined character string from the passport using the passport reader 27, and displays the read character string on the confirmation screen G3 in order to cause the operator to confirm it. Then, after confirmation by the operator, the control unit 300 prints the character string displayed on the confirmation screen G3 on a document such as a purchase written oath. As a result, according to the POS terminal 2 of the embodiment, complicated procedures such as the entry into the purchaser's written oath for each product purchase and the purchase record slip are not necessary, and the procedure concerning tax exemption can be efficiently performed. .

  Further, the control unit 300 automatically performs tax exemption processing when the tax exemption division unit (consumables and general goods) exceeds the tax exemption standard amount (consumables: 5000 yen, general goods: 10000 yen). As a result, according to the POS terminal 2 of the embodiment, it is possible to eliminate the duty-free registration operation at the operator's judgment, and to execute the sales registration processing of goods corresponding to the revision of the tax-free system.

  In addition, when the control unit 300 receives an operation of the item name list output key K2, the control unit 300 executes a printing process for outputting an item name list (not shown) of the item targeted for tax exemption. Here, the timing of accepting the operation of the item name list output key K2 is not particularly limited. For example, when the operation of the item name list output key K2 is received during the sales registration process, the control unit 300 executes the list printing process together with the above-described printing process. When the operation of the item name list output key K2 is received outside the sales registration process, the control unit 300 executes the list printing process after inputting the transaction number of the transaction to be subjected to the list printing process. .

  In the list printing process of the embodiment, one item name list is printed. The item name list is a document that lists the items subject to tax exemption processing. The list of product names is attached to a bag or box for packaging the product subject to tax exemption processing.

  The item name list includes the name or name of the company operating the duty-free shop, the item name of the item subject to tax-free processing, the quantity per item name, and the price. It should be noted that among the products subjected to tax exemption processing, only consumables may be printed on the item name list. In this case, it is assumed that whether or not the product is a consumable item is determined based on the tax exemption classification code of the commodity master file F1 or the tax exemption classification file F2. When the POS terminal 2 additionally includes a label printer, the control unit 300 may print the item name list using the label printer.

  Thus, according to the operation of the item name list output key K2, the POS terminal 2 can output the item name list of the item for which tax exemption has been made. Thereby, according to the POS terminal 2 of the embodiment, the item name list can be easily issued when it is defined by a law that the item name is specified in the package of the item subject to tax exemption, Procedures can be performed efficiently.

  Subsequently, control processing executed by the control unit 400 of the server 4 according to the embodiment in accordance with the control program 481 will be described using FIGS.

  FIG. 20 is a functional block diagram showing a functional configuration of the control unit 400 of the server 4. The control unit 400 functions as an aggregation unit 401 and an update unit 402 by following the control program 481 stored in the HDD 48.

  The tabulating means 401 associates the product code of the product subject to tax exemption processing based on the transaction information stored in the transaction history database DB1 at a predetermined timing, and for each country or region of the person who receives the tax exemption processing A transaction history is totaled in a predetermined period (for example, every day).

  The updating unit 402 updates the aggregation information of the tax-exclusive sales day-by-date data base DB 2 based on the aggregation result by the aggregation unit 401.

  FIG. 21 is a flowchart showing the flow of control processing of the server 4. As shown in FIG. 21, the control unit 400 (counting means 401) of the server 4 determines whether or not a counting instruction has been given by an operation of the operator or a predetermined timing (step S1). If it is determined that there is a tabulation instruction (Yes in step S1), the control unit 400 (tabulation means 401) determines the commodity code of the commodity subject to tax exemption processing based on the information stored in the transaction history database DB1. The transaction history is totaled in a predetermined period (for example, every day) in correspondence with each country or area of the person who receives the tax exemption processing (step S2).

  Specifically, the tabulation processing tabulates sales information (sales amount, sales points, number of customers, etc.) by product for a product subject to tax-free processing in a predetermined period (for example, by day), and tax-free Add the country or region information of the recipient of the treatment.

  Next, the control unit 400 (the update unit 402) of the server 4 executes an update process of updating the aggregation information of the tax-exclusive sales date-based actual result database DB2 based on the aggregation result in step S2 (step S3).

  As described above, according to the server 4 of the present embodiment, sales information (sales amount, number of sales, number of customers, etc.) by product is totaled in a predetermined period (for example, by day) for products for which tax exemption processing is performed. By doing this, it becomes possible to analyze sales information of tax-free products for each item. Also, by adding information on the country or region of the person who is subject to tax exemption processing, to display POP advertisements (Point Of Purchase advertising) in the language for that country or region for products that are sold in each country or region. Can be used to promote sales.

  In the present embodiment, the operator of the POS terminal 2 reads the character string of the nationality described in the passport by the passport reader 27 and inputs it. However, the present invention is not limited to this. For example, the operator of the POS terminal 2 may input the character string of the nationality described in the passport via the keyboard 21.

  Further, in the present embodiment, transaction information (transaction number, transaction date, cash register number, product code, unit price, sales score, etc.) of the product subjected to settlement processing, tax exemption information, and the country or region of the person who receives tax exemption processing Is stored in the transaction history database DB1, but the present invention is not limited to this. For example, with regard to a product relating to tax-exempt processing, data based on the purchase pledge R1 or purchase record slip R2 issued in the tax-exempt processing by the POS terminal 2 may be stored in the transaction history database DB1.

  While certain embodiments of the present invention have been described, these embodiments have been presented by way of example only, 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 modifications can be made without departing from the scope of the invention. These embodiments and modifications thereof are included in the scope and the gist of the invention, and are included in the invention described in the claims and the equivalent scope thereof.

2 POS terminal (product sales data processing device)
4 Server (Information Processing Device)
21 Keyboard 27 Passport Reader (Reader Device)
401 Summary means 402 Update means DB1 Transaction history database DB2 Tax-free sales date actual database (tax-free sales actual database)

JP 2004-62496 A

The information processing apparatus according to the embodiment, at least including transaction history and transaction number for identifying a product code and unit price and sales points and the transaction of the commodity traded goods sales data processing apparatus, wherein the pre-Symbol transactions Tax exemption information that identifies the fact that tax exemption processing has not been performed by the commodity sales data processing device and that the tax exemption processing has not been performed in association with the transaction number, and the person who receives the tax exemption processing entered in the tax exemption processing a transaction history database for storing transaction information including a country or region, the front SL on the basis of the duty-free information stored in the transaction history database, and the target of duty-free treatment from products stored in said transaction history database extract the product code of the product that became, extracted in association with the product code, for each country or region of the person receiving the duty-free treatment, the sales number, sales amount Comprising a collecting unit that aggregates and duty free sales record database for storing summary information which the aggregator is aggregated, and a updating means for updating the summary information of the duty-free sales record database based on the counting result by the aggregator .

Claims (5)

It corresponds to a transaction history including at least a commodity code, a unit price, a sales score, and a transaction number for identifying the transaction in the commodity sales data processing apparatus which performs sales registration concerning the transaction of the commodity, and the transaction number A transaction that stores transaction information including tax exemption information indicating that the transaction has been tax exempted by the commodity sales data processing device, and the country or region of the person who receives the tax exemption processing that has been input during the tax exemption processing. History database,
Among the products subject to the tax exempt processing, the total number of sales points, sales amount and number of customers are tabulated in a predetermined period for each country or region of the person who receives the tax exempt processing in association with the same product code. Tax-free sales record database to store information,
The country or region of the person who receives the tax exemption processing in association with the same commodity code among the commodities subjected to the tax exemption processing based on the transaction information stored in the transaction history database at a predetermined timing And tallying means for tallying each of the sales points, the sales amount and the number of customers in a predetermined period,
Updating means for updating the tally information of the tax-free sales record database based on the tallying result by the tallying means;
An information processing apparatus comprising: The country or region of the person who receives the tax exemption processing stored in the transaction history database is the character string of the nationality described in the passport read by the reader device and input.
An information processing apparatus according to claim 1, characterized in that. The country or region of the person who receives the tax exemption processing stored in the transaction history database is the one obtained by inputting the nationality string described in the passport via the keyboard.
An information processing apparatus according to claim 1, characterized in that. The transaction information stored in the transaction history database is data based on a purchase written oath or a purchase record slip issued in the tax exemption processing by the commodity sales data processing apparatus.
An information processing apparatus according to claim 1, characterized in that. The aggregation period by the aggregation means is any of daily, weekly, and monthly,
An information processing apparatus according to claim 1, characterized in that.

Images