JP6695452B2 - Information processing equipment - Google Patents

Description

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

  Conventionally, when a business operator who manages an export goods sales area (duty-free shop) sells products etc. to non-residents such as foreign tourists, it is subject to the sales target under certain conditions. There is a so-called tax exemption system that exempts taxes such as consumption tax. In recent years, “consumables” such as foods, beverages, medicines, cosmetics, etc. are also exempt from tax.

  Therefore, a technology is disclosed that performs batch tax exemption condition determination for products for which transaction processing related to product sales has been executed and tax exemption processing for tax exempt products that satisfy the tax exemption conditions.

  However, according to the conventional technology, although the tax exemption amount of tax exempted products can be aggregated, there is a problem that it is not possible to perform various analyzes of tax exemption such as individual products or nationality of tax exempted products. there were.

  The problem to be solved by the present invention is to provide an information processing apparatus capable of performing various analyzes on tax exemptions such as individual products and nationalities of tax exempt products.

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 The tax exemption information obtained by associating the tax exemption processing performed by the product sales data processing device and the tax exemption processing not associated with the transaction number, and the tax exemption processing of the person who receives the tax exemption processing input during 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 ..

FIG. 1 is a schematic configuration diagram of a POS system according to an embodiment. FIG. 2 is a block diagram showing the hardware configuration of the server. FIG. 3 is a diagram showing an example of the data structure of the product master file. FIG. 4 is a diagram showing an example of the data structure of the tax exemption classification file. FIG. 5 is a diagram showing an example of the data structure of the tax exemption set value file. FIG. 6 is a diagram showing an example of the data structure of the country / region information master file. FIG. 7 is a diagram showing an example of the data structure of the transaction history database. FIG. 8 is a diagram showing an example of the data structure of the tax exemption sales date-based performance database. FIG. 9 is a block diagram showing the hardware configuration of the POS terminal. FIG. 10 is a functional block diagram showing the functional configuration of the 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 flowchart 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 the purchase agreement. FIG. 18 is a diagram showing an example of a purchase record slip. FIG. 19 is a diagram showing an example of a receipt. FIG. 20 is a functional block diagram showing the functional configuration of the 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 goods sales area (duty-free shop) that sells a sales target used for normal life to non-residents such as foreign tourists by a certain method. Will be described. The embodiment is an example in which a POS terminal installed in a duty-free shop as an information processing apparatus is applied to a server for centralized management.

  FIG. 1 is a schematic configuration diagram of a POS system 1 according to an embodiment. As shown in FIG. 1, the POS system 1 includes a plurality of (two in the figure) POS terminals 2 which are commodity sales data processing devices, and a network 3 such as a LAN (Local Area Network) that connects these POS terminals 2 to each other. It is provided with a server 4 which is an information processing device which is connected and centrally managed.

  The server 4 is in charge of controlling the POS system 1 as a whole. 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 CPU (Central Processing Unit) 41, a ROM (Read Only Memory) 42, a RAM (Random Access Memory) 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 online communicates with a plurality of POS terminals 2 via the communication I / F 50 and the network 3 (see FIG. 1). 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. 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 set 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 relating to transactions for which sale registration processing has been performed by the POS terminal 2. Further, the HDD 48 holds a tax exemption sales date-based achievement database (DB) DB2 as a tax exemption sales achievement database for accumulating information about products subject to tax exemption processing described later in the POS terminal 2.

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

  Further, the control program 481 executed by the server 4 of the embodiment may be stored in a computer connected to a network such as the Internet and may be provided by being downloaded via the network. Further, the control program 481 executed by the server 4 of the embodiment may be configured to 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 diagram showing an example of the data structure 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 to be registered for sale in association with the product name, product price (unit price), classification code (classification 1 code, Product information such as classification 2 code), tax exemption classification code, and dangerous goods classification code is set. The dangerous goods classification code is given to products that require careful handling, such as sprays, which are prohibited from being brought into the aircraft.

  Products 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 categories according to the category 1 (higher class) which is a rough category. Further, each classification 1 is classified in more detail by classification 2 (subordinate classification) which is a finer classification. That is, the upper classification 1 is divided into a plurality of lower classifications 2 and includes at least one lower classification 2.

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

  Next, the tax exemption classification file F2 will be described. FIG. 4 is a diagram showing an example of the data structure of the tax exemption classification file F2. As shown in FIG. 4, a tax exemption classification name is set in the tax exemption classification file F2 in association with the tax exemption classification code. The tax exemption classification names are "consumables", "general goods", and "non-tax exempt". "Consumables" are goods exempt from tax exemption on goods sold to non-residents such as foreign travelers, and are goods such as foods, beverages, medicines, cosmetics, etc. . “General goods” are also goods exempt from taxation, and are goods that are used for normal life other than consumables. “Exempt from tax exemption” is a non-exempt item that is not exempt from tax. The tax exemption classification code of "consumables" is "01". The tax exemption classification code of “general goods” is “02”. The tax exemption classification code of "not subject to tax exemption" is "03".

  Next, the tax exemption set value file F3 will be described. FIG. 5 is a diagram showing an example of the data structure of the tax exemption set value file F3. As shown in FIG. 5, set values are set in the tax exemption set value file F3 in association with the tax exemption classification code. The set value is a standard for sales registration as tax exempt in each category. In the example shown in FIG. 5, the set value for the consumable item with the tax exemption classification code “01” is 5,000 yen to 500,000 yen. Further, the set value for general items (items used for normal life other than consumable items) with 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 delivers the product master file F1, the tax exemption classification file F2, and the tax exemption set value file F3 to the POS terminal 2 at a predetermined timing by following the control program 481.

  FIG. 6 is a diagram showing an example of the data structure 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 the tax exemption processing.

  Next, the transaction history database DB1 will be described. FIG. 7: is a figure which shows an example of a data structure of transaction history database DB1. As shown in FIG. 7, the transaction history database DB1 stores transaction information of transactions processed by each of the POS terminals 2 as a transaction history. The transaction history includes a transaction number for identifying each transaction (stored in the transaction number section DB11), a transaction date and time for the transaction (stored in the transaction date and time section DB12), and a POS terminal 2 for the transaction. Including a cashier number (stored in the cashier number portion DB13) for identifying Further, the transaction history includes a product code, a unit price, a sales point (stored in the product information DB 15) of each product registered for sale.

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

  Further, in the transaction history database DB1, the nationality (stored in the nationality division DB16) is set in association with the transaction number. Although details will be described later, 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 tourist read from a passport at the time of tax exemption processing.

  Next, the tax exemption sales date-based result database DB2 will be described. FIG. 8: is a figure which shows an example of a data structure of the performance database DB2 classified by tax exemption sales date. As shown in FIG. 8, in the tax exemption sales date-based result database DB2, the non-existence of non-Japanese tourists is associated with a single item code (product code) of a product subjected to a tax exemption process described later in the POS terminal 2. The country / region ID indicating the country or region of the resident (the person who receives tax exemption processing), the number of sales points for each region, the amount of sales, the number of customers, etc. are stored for each day.

  In the present embodiment, the daily tax-exempt sales results of the products subject to the tax exemption process are totaled, but the present invention is not limited to this, and may be totaled weekly or monthly. .

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

  The POS terminal 2 performs a transaction process related to the sale of products sold in the store. The transaction process is a process that combines the sales registration process and the settlement process.

  Sales registration processing is the product name and price (product name) of the product that is read based on the entered product code by optically reading the bar code or other code attached to the product being sold. Information) is displayed and the product information is stored in a buffer.

  Settlement processing is based on the product information stored in the buffer along with the sales registration processing, the display of the total amount of transactions, the processing of calculating and displaying change based on the deposit received from the customer, and the issue of change. Is a process for instructing a change machine, a process 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 including a CPU 31, a ROM 32, a RAM 33, and the like. The CPU 31 executes various arithmetic processes and controls each unit. The ROM 32 fixedly stores and saves fixed data. The RAM 33 rewritably stores variable data and is used as a work area. The CPU 31, the ROM 32, and the RAM 33 are connected and configured via a bus line 34.

  In the RAM 33, a tax exemption applicable amount table T for collecting tax exemption applicable amounts described later is formed.

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

  The keyboard 21 has various keys arranged in blocks. 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 current total key for declaring cash closing in the settlement process, various keys, etc. A PLU key for designating a product, a confirmation key for confirming the input of a numerical input by the numerical key, a clear key, and the like.

  The keyboard 21 also includes a tax exemption declaration key K1 and a product name list output key K2. The tax exemption declaration key K1 is an operator declared to perform tax exemption processing for the transaction. The product name list output key K2 is an operator for instructing the output of a list of products (product name list) 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 of optically reading a character string written in the passport.

  Further, the above-mentioned keyboard 21, display unit 22, printer 23, card reader / writer 24, scanner 25, and passport reader 27 are connected to the control unit 300 via the bus line 34 and the controller 35. The memory unit 26, which is a storage device, is connected to the control unit 300 via a bus line 34. The memory unit 26 includes an HDD (Hard Disk Drive), a flash memory, and the like, and retains the stored contents even when the power is cut 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 includes 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. This communication interface 28 is also connected to the bus line 34.

  By the way, an operating system, a control program 261 such as various computer programs, and various data files are stored in the memory unit 26 of the POS terminal 2. The data files include a product master file F1, a tax exemption classification file F2, a tax exemption set value file F3, etc. delivered from the server 4.

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

  Further, the control program 261 executed by the POS terminal 2 of the embodiment may be stored in a computer connected to a network such as the Internet and may be 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 incorporated in a ROM or the like in advance and provided.

  Next, a control process executed by the control unit 300 of the POS terminal 2 according to the embodiment in accordance with the control program 261 will be described with reference to FIGS.

  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 excluding tax from the amount of a product subject to tax exemption.

  FIG. 11 is a flowchart showing a 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 or not a product code specifying a product has been input using the scanner 25 (step S11). When it is determined that the product has been input (Yes in step S11), the control unit 300 determines the product based on the product information such as the product name and unit price obtained by searching the product master file F1 according to the input product code. Execute the sales registration process to calculate the registration amount. Then, the control unit 300 stores the product information of the sales-registered product in the RAM 33 (step S12).

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

  Then, the control unit 300 prints the product information, the payment information, and the like of the product for which payment processing has been performed on the receipt paper and issues a receipt (step S15). It should be noted that the transaction number identifying the transaction is printed on the issued receipt in the form of a bar code. Then, the control unit 300 transmits transaction information (transaction number, transaction date / time, cashier number, product code, unit price, number of sales, etc.) of the transaction-processed product 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 section 400 stores the transaction date and time in the transaction date and time section DB12. The control section 400 stores the cashier number of the POS terminal 2 that has performed the transaction processing in the cashier number section DB13. The product code, unit price, and sales score of the traded product are stored in the product information DB 15. The control unit 400 also stores a flag “0” indicating that tax exemption processing is not performed for the transaction in the flag DB 14 in association with the transaction number of the transaction.

  When it is determined that the current total key has not been operated (No in step S13), the control unit 300 determines whether the tax exemption declaration key K1 has been operated (step S21). When it is determined that the tax exemption process has been performed (Yes in step S21), the control unit 300 determines that the tax exemption process is declared, and executes the tax exemption process shown in FIG. 12 (step S22).

[Tax exemption processing]
Here, the tax exemption processing executed in step S22 when the tax exemption declaration key K1 is operated will be described in detail with reference to FIGS. FIG. 12 is a flowchart showing the flow of tax exemption processing. In FIG. 12, the control unit 300 operates the passport reader 27. Then, the control unit 300 determines whether the passport reader 27 has read a predetermined character string from the passport (step S51). Examples of such character strings include a passport number, name, nationality, date of birth, and the like. The control unit 300 displays on the display unit 22 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) that prompts reading of the passport. The operator of the POS terminal 2 opens a page in the passport presented by the customer (non-resident) in which matters relating to the tax exemption system are described, and holds the page over the passport reader 27. In response to this operation, the control unit 300 reads a predetermined character string from the passport.

  If the control unit 300 waits until the passport is read (No in step S51) and determines that the passport is read (Yes in step S51), the control unit 300 confirms on 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 shows an example of reading the character strings 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 associated with each item on the confirmation screen G3. The control unit 300 determines whether or not the delete button B1 is operated (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, if there is an error in the character string of any of the items read in step S51, the erroneous character string can be deleted by operating the delete button B1. .. The control unit 300 displays the confirmation screen G3 in which the character string of the item deleted in step S54 is blank.

  Further, the control unit 300 displays a confirmation button B2, a reread button B3, and a cancel button B4 corresponding to the confirmation accepting unit of the embodiment on the confirmation screen G3. When determining that the delete button B1 has not been operated (No in step S53), the control unit 300 determines whether or not the reread button B3 has been operated (step S55). If it is determined that the character string has been operated (Yes in step S55), the process returns to step S51 to read the character string from the passport again. The previously read character string is deleted in accordance with the operation of the reread button B3.

  When it is determined that the reread button B3 is not operated (No in step S55), the control unit 300 determines whether or not the cancel button B4 is operated (step S56). When it is determined that the operation has been performed (Yes in step S56), all the read character strings are deleted (step S57), and the process returns to step S51. Note that 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) in accordance with the operation of the cancel button B4.

  When it is determined that the cancel button has not been operated (No in step S56), the control unit 300 determines whether or not the confirm button B2 has been operated (step S58). When it is determined that the product has been operated (Yes in step S58), the control unit 300 displays the 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 confirm 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, on the product registration screen G4, a tax exemption indicator I displayed as "tax exemption" is displayed. By displaying the tax exemption indicator I on the product registration screen G4 in this way, the control unit 300 notifies the operator that the transaction is a tax exemption declaration transaction.

  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 product master file F1 for the already registered registered products, and determines the tax exemption target products to be tax exempted. When there is a tax exemption target product, the control unit 300 performs an addition process on the tax exemption target amount table T of the tax exemption target amount for each registered product group (general product group / consumables group) that is a tax exemption target.

  Correspondence according to the tax type of the tax exemption target product is performed as follows.

When the registered product subject to tax exemption is the internal tax, the control unit 300 adds the tax-excluded amount of the registered amount as the tax exemption target amount to the tax exemption target amount table T. More specifically, the control unit 300 sets the difference between the pre-tax exemption registered amount and the post-tax exemption registered amount as the tax exemption amount in the case of the tax-included product.
・ Unit price before tax exemption is 1080 yen-Unit price after tax exemption is 1000 yen → Tax exemption amount is 80 yen

  When the registered product subject to tax exemption is a tax exemption, the control unit 300 adds the registered amount to the tax exemption target amount table T as the tax exemption target amount. More specifically, in the case of a tax-excluded product, the control unit 300 sets the tax-exempt amount for the registered amount as the tax-exempt amount.

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

  Next, the control unit 300 determines whether or not the tax exemption target amount of the tax exemption target amount table T satisfies the set value (reference amount) of the tax exemption set value file F3. In the tax exemption set value file F3 of the embodiment, the set values for foods, beverages, medicines, cosmetics, and other consumables are 5,000 yen to 500,000 yen. Further, the set value for general articles (articles used for normal life other than consumables) is an amount exceeding 10,000 yen.

  When it is determined that the tax exemption target amount of the consumables satisfies the set value (5,000 yen to 500,000 yen), the control unit 300 performs a tax exemption process for exempting the tax on the tax exemption target amount. In addition, when the control unit 300 determines that the tax exemption target amount for general items (items used for normal life other than consumable items) satisfies the set value (amount exceeding 10,000 yen), the tax exemption target amount. Tax exemption processing to exempt the tax on.

  When the tax exemption applicable amount of the consumable item in the tax exemption applicable amount table T exceeds the upper limit value (500,000 yen) of the set value, the control unit 300 displays an error on the display unit 22.

  FIG. 15 is a diagram showing an example of the error screen. As shown in FIG. 15, when the tax exemption declaration key K1 is operated, when the tax exemption declaration is made, the control unit 300 displays 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 executing the tax exemption process, the control unit 300 redisplays the product registration screen (step S61). Here, FIG. 16 is a diagram showing an example of the product registration screen G7 after the re-display. As shown in FIG. 16, the re-displayed product registration screen G7 sets the tax amount to “0 yen” by exempting the tax by the tax exemption process. In addition, as shown in FIG. 16, the redisplayed product registration screen G7 sets the total display amount as the amount after the tax exemption process (the amount of the exempted tax is reduced). Further, the re-displayed product registration screen G7 displays the character "exempt" on the tax exempted products, that is, the products that have been subjected to the tax exemption process.

  Next, the control unit 300 refers to the product master file F1 and determines whether or not the tax exemption target product is in the dangerous goods category (step S62). When it is determined that there is a product in 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. If it is determined that there is no product in the dangerous goods category (No in step S62), the control unit 300 does not execute step S63.

  Next, the control unit 300 determines whether the current total key has been operated (step S64). When the operation is waited (No in step S64) and it is determined that the operation is performed (Yes in step S64), the control unit 300 calculates the total price of the transaction based on the registered price of the product and the product information. Then, the payment process is executed (step S65). Since the tax exemption process is performed in the settlement process executed in step S65, a tax such as a consumption tax is not added to the sold product, and the total amount including the tax amount is calculated.

  Then, the control unit 300 provides the server 4 with transaction information (transaction number, transaction date / time, cashier number, product code, unit price, number of sales, etc.) of the goods for which payment processing has been performed, tax exemption information, and the country or region of the person who receives the tax exemption processing. (Step S66). The server 4 receiving 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 section 400 stores the transaction date and time in the transaction date and time section DB12. The control section 400 stores the cashier number of the POS terminal 2 that has performed the transaction processing in the cashier number section DB13. The product code, unit price, and sales score of the traded product are stored in the product information DB 15. Then, the control unit 400 stores the flag “1” indicating that tax exemption processing has been performed on the transaction 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 a non-resident such as a foreign tourist read from the passport at the time of tax exemption 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, etc. of the product for which the payment processing has been performed on the receipt paper (step S67).

  In the process of step S67, the control unit 300 prints, for example, one purchase pledge, two purchase record slips, and one receipt in the case of a transaction for which tax exemption processing has been performed.

  First, the purchase agreement will be explained. FIG. 17 is a diagram showing an example of the purchase agreement R1. The purchase pledge R1 is a document that describes the fact of purchase of tax-free goods. The purchase pledge R1 is submitted as a copy of the store attached to the document (purchase pledge) to the business operator who operates the duty-free shop.

  As shown in FIG. 17, the purchase agreement R1 includes the name or name a of the business operator who operates the duty-free shop, the jurisdiction tax signature b, the location of the duty-free shop c, the transaction date d, the transaction number e, and the cashier number. f, item description (item name g, quantity and price h for each item name), total amount i of all items, total amount j of general items and consumable items, and tax exemption amount k.

Further, the purchase agreement R1 has a column for printing the character string of each item confirmed on the confirmation screen G3. Specifically, the character string confirmed on the confirmation screen G3 for the following items is printed on the purchase agreement R1.
・ Passport number… l
・ The nationality of the purchaser ... m
・ Name of purchaser ... n
・ Birth date of purchase ... o

  In addition, regarding 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 it is directly entered on the document (purchase agreement). Further, the layout of the purchase agreement R1 is not limited to the example shown in FIG. For example, a pledge to export after purchase (in the case of consumables, pledge to export within 30 days from the date of purchase), a purchaser's signature column, or the like may be printed.

  Next, the purchase record slip will be described. FIG. 18 is a diagram showing an example of the purchase record slip R2. The purchase record slip R2 is a document in which the fact of purchase of a tax-free article is described. Two purchase record slips R2 shown in FIG. 18 are printed for attachment to a document (purchase record slip) and for store copies. The attached purchase record slip R2 is attached to the document (purchase record slip). This document (purchase record slip) is attached to the passport and stamped.

  As shown in FIG. 18, the purchase record voucher R2 includes the name or name a of the business operator who operates the duty-free shop, the jurisdiction tax signature b, the location of the duty-free shop c, the transaction date d, the transaction number e, and the cashier number. f, item description (item name g, quantity and price h for each item name), total amount i of all items, total amount j of general items and consumable items, and tax exemption amount k.

Further, the purchase record slip R2 has a column for printing the character string of each item confirmed on the confirmation screen G3. Specifically, the character strings confirmed on the confirmation screen G3 for the following items are printed on the purchase record slip R2.
・ Passport number… l
・ The nationality of the purchaser ... m
・ Name of purchaser ... n
・ Birth date of purchase ... 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 entered directly on the document (purchase record slip) as in the purchase pledge R1. And 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 is a diagram showing an example of the receipt R3. The receipt R3 is given to the purchaser after the transaction.

  As shown in FIG. 19, the receipt R3 includes the name or name a of the business operator who operates the duty-free shop, the transaction date d, the transaction number e, the cashier number f, and the item details (item name g, quantity for each item name, and The price h) includes the total price i of all goods. Note that, as shown in FIG. 19, in the case of a tax-exempted product, "exempt" p is printed as tax. In the case of a tax exemption transaction, a tax exemption message "A tax exemption transaction has been completed." Q is printed on the receipt R3. The receipt R3 is printed with a bar code w that is an encoded transaction number e.

  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 all or some of the character strings of the items confirmed on the confirmation screen G3 in the journal corresponding to the receipt R3.

  In this way, 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 for the operator to confirm. After the 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 pledge. As a result, according to the POS terminal 2 of the embodiment, it is possible to efficiently perform the tax exemption procedure because a complicated procedure such as filling in a purchaser pledge or purchase record slip for each purchase of a product is unnecessary. ..

  Further, the control unit 300 automatically performs the tax exemption process when the tax exemption classification unit (consumables, general goods) exceeds the tax exemption standard amount (consumables: 5000 yen, general goods: 10,000 yen). As a result, according to the POS terminal 2 of the embodiment, the tax exemption registration operation at the operator's judgment becomes unnecessary, and the sale registration process of the product corresponding to the revision of the tax exemption system can be executed.

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

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

  The item name list includes the name or name of the business operator who operates the duty-free shop, the item name of the product subject to the tax exemption process, the quantity and price for each item name. It should be noted that, among the products subject to the tax exemption processing, only consumables may be printed on the product name list. In this case, whether or not the product is a consumable item is determined based on the tax exemption classification code of the product master file F1 or the tax exemption classification file F2. Further, when the POS terminal 2 is provided with a label printer separately, the control unit 300 may print the item name list using the label printer.

  As described above, according to the POS terminal 2, it is possible to output the product name list of the products subject to the tax exemption according to the operation of the product name list output key K2. Thus, according to the POS terminal 2 of the embodiment, the item name list can be easily issued when it is stipulated by law that the item name is indicated on the packaging of the product subject to the tax exemption. It is possible to efficiently carry out the procedure related to.

  Subsequently, a control process executed by the control unit 400 of the server 4 according to the embodiment by following the control program 481 will be described with reference to FIGS. 20 to 21.

  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 the totalizing unit 401 and the updating unit 402 by following the control program 481 stored in the HDD 48.

  The aggregating means 401 is associated with the product code of the product subject to the tax exemption processing based on the transaction information stored in the transaction history database DB1 at a predetermined timing, for each country or region of the person who receives the tax exemption processing. Transaction history is totaled over a predetermined period (for example, by day).

  The updating unit 402 updates the totaling information in the tax exemption sales date-based database DB2 based on the totaling result of the totaling 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 (totalizing means 401) of the server 4 determines whether or not there is a totaling instruction in accordance with an operation of the operator or a predetermined timing (step S1). When it is determined that the totaling instruction has been given (Yes in step S1), the control unit 400 (totaling unit 401), based on the information stored in the transaction history database DB1, the product code of the product targeted for tax exemption processing. The transaction history is aggregated in a predetermined period (for example, by day) for each country or region of the person who receives the tax exemption processing (step S2).

  Specifically, the aggregation process is to aggregate sales information (sales amount, sales points, number of customers, etc.) for each product for which tax exemption processing has been performed for a predetermined period (for example, by day), and Add the information of the country or region of the recipient.

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

  As described above, according to the server 4 of the present embodiment, sales information (sales amount, sales points, number of customers, etc.) for each product for which tax exemption processing is performed is totaled for a predetermined period (for example, daily). By doing so, it becomes possible to analyze sales information of tax-free products for each individual product. In addition, by adding information on the country or region of the person who receives tax exemption processing, POP advertisement (Point Of Purchase advertising) is displayed in the language for that country or region on the products that sell well in each country or region. Can be used for sales promotion.

  In the present embodiment, the operator of the POS terminal 2 reads the character string of the nationality written in the passport with the passport reader 27 and inputs it, but 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 written in the passport via the keyboard 21.

  Further, in the present embodiment, transaction information (transaction number, transaction date, cashier number, product code, unit price, number of sales, etc.) of the product that has been settled, tax exemption information, and the country or region of the person who receives the tax exemption process. Is stored in the transaction history database DB1, but the present invention is not limited to this. For example, for a product related to the tax exemption process, data based on the purchase pledge R1 or the purchase record slip R2 issued in the tax exemption process by the POS terminal 2 may be stored in the transaction history database DB1.

  Although some 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, replacements, and changes can be made without departing from the spirit of the invention. These embodiments and modifications thereof are included in the scope and the gist of the invention, and are also included in the invention described in the claims and the scope equivalent thereto.

2 POS terminal (product sales data processing device)
4 server (information processing device)
21 keyboard 27 passport reader (reader device)
401 aggregation means 402 updating means DB1 transaction history database DB2 tax-exempt sales date performance database (tax-exempt sales performance database)

JP, 2004-62496, A

Claims (5)

And including at least 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, duty free treatment by the product sales data processing apparatus for pre-Symbol transactions A transaction including the fact that the tax exemption processing is not performed and the tax exemption processing is not performed and the tax exemption information identified by associating with the transaction number A transaction history database that stores information,
Based on the duty-free information stored before Symbol transaction history database, correspondence to the transaction history to extract the product code of the product which is the object of the exemption process from among the items stored in the database, the extracted product code Then, a collecting means for collecting the number of sales and the amount of sales for each country or region of the person who receives the tax exemption processing,
A tax-exempt sales record database that stores the total information aggregated by the aggregate unit;
Update means for updating the aggregate information of the tax exempt sales record database based on the aggregate result by the aggregate 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 one in which the character string of the nationality described in the passport is read and input by the reader device,
The information processing apparatus according to claim 1, wherein: 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 entered through the keyboard,
The information processing apparatus according to claim 1, wherein: The transaction information stored in the transaction history database is data based on a purchase pledge or a purchase record issued in the tax exemption processing by the commodity sales data processing device,
The information processing apparatus according to claim 1, wherein: The aggregation period by the aggregation means is any of daily, weekly, and monthly,
The information processing apparatus according to claim 1, wherein:

Images