JP2012181752A - Commodity data processing device and program - Google Patents

Abstract

PROBLEM TO BE SOLVED: To intelligibly indicate commodities related to respective tax categories such as a consumption tax, a liquor tax, and a cigarette tax, and tax amounts for the respective commodities.SOLUTION: A commodity data processing device comprises: commodity code reception means for receiving commodity codes of commodities; tax category discrimination means for discriminating a tax category related to each of the commodities identified by the commodity codes based on tax setting information in which tax category information indicating a tax category for each commodity and information concerning calculation of a tax amount to be imposed on a commodity in each tax category are set; calculation means for calculating a tax amount to be imposed on each of the commodities in each of the discriminated tax categories on the basis of the information concerning tax amount calculation; and output means for outputting information indicating commodities of which tax categories are discriminated and tax amounts imposed on the respective commodities for each tax category.

Description

  Embodiments described herein relate generally to a commodity data processing apparatus and a program.

  2. Description of the Related Art Conventionally, in a product data processing apparatus that handles product data relating to a product specified based on a product code, such as a POS (Point Of Sale) terminal, a tax rate is set for each product. At the time of sale registration of the product, the tax amount is calculated based on the tax rate corresponding to each product, and the calculated tax amount and tax rate for each product are printed on the receipt paper.

  However, in the prior art, since the tax amount for each product is output on a receipt sheet or the like, it is difficult to understand the tax amount of the product for each type of tax such as consumption tax, liquor tax and tobacco tax.

  In order to solve the above-described problems, the product data processing apparatus according to the embodiment taxes the product code receiving means for receiving the product code of the product, the tax type information indicating the tax type for each product, and the tax type. Tax type determination means for determining the type of tax applied to the product specified by the received product code, based on the tax setting information in which information related to calculation of the tax amount to be set is set, and calculation of the tax amount Calculation means for calculating the amount of tax applied to the product in the determined tax type, information indicating the product for which the tax type is determined for each tax type, Output means for outputting a tax amount for the product.

  In addition, the program of the embodiment is taxed by a computer of the product data processing apparatus using a product code receiving unit that receives a product code of the product, tax type information indicating a tax type for each product, and the tax type. Tax type determination means for determining the type of tax applied to the product specified by the received product code based on the tax setting information in which information related to the calculation of the tax amount is set, and the calculation of the tax amount Based on the information, a calculation means for calculating a tax amount for the product in the determined tax type, information indicating the product for which the tax type is determined for each tax type, and the product It functions as an output means for outputting the tax amount.

FIG. 1 is a schematic configuration diagram of a POS system according to an embodiment. FIG. 2 is a block diagram schematically showing a functional configuration of the store server. FIG. 3 is a diagram illustrating a data configuration of the product master. FIG. 4 is a diagram illustrating a data configuration of the product-specific tax rate setting master. FIG. 5 is a diagram illustrating a data configuration of the tax type setting master. FIG. 6 is an external perspective view of the POS terminal. FIG. 7 is a block diagram schematically showing the functional configuration of the POS terminal. FIG. 8 is a flowchart showing a procedure of operations executed by the POS terminal. FIG. 9 is a conceptual diagram showing an example of receipt paper printed by the POS terminal.

  In the present embodiment, a case will be described in which a product data processing apparatus is applied to a POS terminal used in a store such as a supermarket.

  FIG. 1 is a schematic configuration diagram of a POS system 1 according to the embodiment. As shown in FIG. 1, a POS system 1 connects a plurality of (two in the figure) POS terminals 2 as product data processing apparatuses and these POS terminals 2 via a network such as a LAN (Local Area Network) 3. And a store server 4 for centralized management.

  The store server 4 is responsible for overall control of the POS system 1. FIG. 2 is a block diagram schematically showing a functional configuration of the store server 4. The store server 4 includes a control unit 41 having a computer configuration including a central processing unit (CPU), a read only memory (ROM), a random access memory (RAM), a communication I / F 43, and an I / O device control unit. 44 is connected by a bus 42. The store server 4 performs online communication with a plurality of POS terminals 2 via the communication I / F 43 and the LAN 3 (see FIG. 1). In addition, a keyboard 45, a display 46, a printer 47, and an HDD (Hard Disk Drive) 48 are connected to the control unit 41 via a bus 42 and an I / O device control unit 44. The HDD 48 stores a product master M and a tax rate setting database DB, in addition to various control programs for operating the CPU of the control unit 41.

  FIG. 3 is a diagram illustrating a data configuration of the product master M. As illustrated in FIG. As shown in FIG. 3, product information such as a product name and a product price is set in the product master M in association with the product code of each product. The product code is identification information uniquely set for each product, and is used for specifying the product. For example, in a store, a product code set for the product is written on a label attached to the product. Then, the product code described on the label is input by the scanner 19 (see FIG. 6) of the POS terminal 2 connected via the bus 42 or the communication I / F 43. In the store server 4, the product can be specified by referring to the product master M with the input product code.

  The tax rate setting database DB is a database in which information on taxes on products is set for each product set in the product master M, that is, for each product handled in a store. Specifically, the tax rate setting database DB includes a product-specific tax rate setting master D1 and a tax type setting master D2.

  FIG. 4 is a diagram illustrating a data configuration of the product-specific tax rate setting master D1. As shown in FIG. 4, the product-specific tax rate setting master D <b> 1 includes a “tax rate” for calculating a tax-included price for each “product code” for identifying a product and a tax applied to the product identified by the product code. The “tax code” indicating the type of the item is stored. For the product identified by the “product code”, the price set in the product master M and the value set in the “tax rate” in the product-specific tax rate setting master D1 are multiplied to obtain the price including tax. Can be calculated. The “tax code” is identification information uniquely set for each tax type, and is used to specify the tax type for the product identified by the “product code”.

  FIG. 5 is a diagram illustrating a data configuration of the tax type setting master D2. As shown in FIG. 5, the tax type setting master D2 stores “tax type”, “tax amount calculation formula”, and “display data” for each “tax code”. “Tax type” indicates the name of the tax type identified by “Tax code”. Specifically, tax item names such as “consumption tax”, “cigarette tax”, and “liquor tax” are described. The “tax amount calculation formula” describes a calculation formula for calculating a tax amount to be taxed on a product in a tax type. Specifically, (product price) × (ratio of tax amount to product price) is described. By referring to this "tax amount calculation formula", in addition to the tax amount imposed on the product price at the time of sale, in addition to the tax amount imposed on the product price, the tax amount previously imposed on the product price is calculated. Is possible. The “display data” describes information to be displayed (or printed) regarding the tax type, such as the ratio of taxation on the product price in the tax type. For example, when the “tax type” is a consumption tax, information such as “5%”, which is the ratio of the tax imposed on the product price as the consumption tax, is described.

  Next, the POS terminal 2 will be described. FIG. 6 is an external perspective view of the POS terminal 2. As shown in FIG. 6, the POS terminal 2 is placed on a drawer 12 for storing cash and controls opening / closing of a drawer 12 a of the drawer 12. A mode key 14 is provided on the front side of the POS terminal 2 for selecting various business modes such as registration, inspection, checkout, and setting. Also, on the keyboard 13 provided in front of the POS terminal 2, an operator (store clerk) outputs, for example, a set key for setting a deposit amount or the like and a total output of products registered for sale as one commercial transaction. Operation keys for performing various operation inputs such as a current total key for instructing are provided.

  Further, the POS terminal 2 is provided with a store clerk display 15 on the front side and a customer display 16 on the back side. As the clerk display 15 and the customer display 16, for example, a liquid crystal display or the like is used, and the name, price, total amount of one business transaction, change amount, and the like of the product registered for sale are displayed. The POS terminal 2 includes a printer 17 that prints receipts and journals. The receipt printed by the printer 17 is issued from a receipt issuing port 18 formed on the front side of the POS terminal 2. The POS terminal 2 is connected to a scanner 19 for reading a barcode attached to the product.

  FIG. 7 is a block diagram schematically showing a functional configuration of the POS terminal 2. The POS terminal 2 includes a control unit 21 having a computer configuration including a CPU, a ROM, a RAM, and the like (all not shown). The ROM stores various programs executed by the CPU and various data. The RAM temporarily stores data and programs when the CPU executes various programs. Further, the RAM stores sales data indicating the sales record of the product, and various screen display data to be displayed on the store clerk display 15 and the customer display 16.

  The control unit 21 controls I / O devices such as the keyboard 13, the store clerk display 15, the customer display 16, the printer 17, and the scanner 19 through the I / O device control unit 24 and the bus 22. Further, the control unit 21 communicates with the store server 4 via the communication I / F 23 and the LAN 3 (see FIG. 1).

  The control unit 21 develops a program stored in the ROM on the RAM and executes the program, so that the product code receiving unit 25, the tax type determination unit 26, the sales registration unit 27, the display control unit 28, , Functions as the print control unit 29.

  The product code receiving unit 25 reads and receives a product code from the barcode data when the barcode attached to each product is scanned by the scanner 19. Note that the product code receiving unit 25 may receive an input of a product code using a key input from the keyboard 13. The product code receiving unit 25 may read the product code from other code symbols such as a two-dimensional code and receive the input.

  The tax type determination unit 26 refers to the tax rate setting database DB of the store server 4 via the communication I / F 23 based on the product code received by the product code receiving unit 25, so that the product specified by the product code is obtained. The type of tax is determined. Specifically, by referring to the product-specific tax rate setting master D1 in the tax rate setting database DB based on the product code, a “tax code” indicating the type of tax applied to the product specified by the product code, or including tax Get “tax rate” to calculate price. Next, by referring to the tax type setting master D2 of the tax rate setting database DB based on the acquired tax code, information on the tax type specified by the tax code (“tax type”, “tax amount calculation formula” , “Display data”).

  The sales registration unit 27 performs sales registration of the product specified by the product code received by the product code receiving unit 25. Specifically, the product code received by the product code receiving unit 25 is inquired of the store server 4 via the communication I / F 23, and the product name and price set in the product master M are acquired for the product code. . Next, a tax-included price is calculated based on the acquired price and the “tax rate” acquired by the tax type determination unit 26. Further, based on the acquired price and the “tax amount calculation formula” acquired by the tax type determination unit 26, the tax amount on the product (the tax amount imposed on the price of the product at the time of sale, the tax amount previously imposed on the price of the product) Etc.). Next, the sales registration unit 27 registers the product name, the price, the tax-included price (sales price), and the tax amount for the product as information on the sold product.

  The display control unit 28 displays the product name, price, tax-inclusive price, tax amount, and the like of each product registered by the sales registration unit 27 on the store clerk display 15 and the customer display 16. Specifically, the display control unit 28, based on the determination result by the tax type determination unit 26, for each tax type, information (product name, price, tax-included price) indicating the product for which the tax type is determined. ) And the tax amount for the product (details will be described later). The display content displayed by the display control unit 28 does not have to be displayed on both the store clerk display 15 and the customer display 16, and the display content may be appropriately distributed and displayed according to convenience. .

  The print control unit 29 prints the name of the store, contact information, the product name, price, tax-included price, tax amount, and the like of each product registered by the sales registration unit 27 on the receipt sheet. Specifically, the print control unit 29, for each tax type, based on the determination result by the tax type determination unit 26, information indicating the product for which the tax type is determined (product name, price, price including tax) ) And the tax amount for the product are printed on receipt paper (details will be described later). The printed receipt paper is issued from the receipt issuing port 18.

  Next, an operation procedure executed by the POS terminal 2 will be described. FIG. 8 is a flowchart showing a procedure of operations executed by the POS terminal 2.

  First, in the POS terminal 2, the barcode attached to the product is scanned by the scanner 19. The product code receiving unit 25 reads and receives the product code from the barcode data (S1: YES). While the product code receiving unit 25 does not accept the input of the product code (S1: NO), it waits for input (S1).

  Next, the tax type determination unit 26 reads the “tax rate”, “tax code”, “tax amount calculation formula”, etc., of the product corresponding to the product code received by the product code receiving unit 25 from the tax rate setting database DB (S2). ). Next, the tax type determination unit 26 determines the type of tax applied to the product corresponding to the product code based on the “tax code” (S3). Next, the sales registration unit 27 acquires the product name and price set in the product master M for the product code, and makes a determination based on the “tax amount calculation formula” acquired by reading from the tax rate setting database DB. The tax amount for the product is calculated for the tax type (S4).

  Next, the sales registration unit 27 stores the product identified by the product code and the calculated tax amount in the RAM in association with the determined tax type (S5). Specifically, based on the product code received by the product code receiving unit 25 and the “tax amount calculation formula” in an array (storage area) reserved for the “tax code” indicating the determined tax type. Stack with the tax amount.

  Next, the sales registration unit 27 calculates a tax-included price (sales price) based on the price set in the product master M for the product code and the “tax rate” of the product corresponding to the product code. Information on the sold product such as name, price, tax-included price, tax amount, etc. is registered (S6). Next, the display control unit 28 displays the product name, price, tax-inclusive price, tax amount, and the like of each product registered by the sales registration unit 27 on the store clerk display 15 and the customer display 16 (S7).

  Next, the POS terminal 2 determines whether or not the current key is pressed on the keyboard 13 (S8). While the current total key is not pressed (S8: NO), the process returns to S1 and the processes of S1 to S8 are continued until the sales registration of all products is completed. Therefore, in S5, the product and the calculated tax amount for each tax type are stacked and stored in the RAM for all the products.

  When the current total key is pressed (S8: YES), the print control unit 29 sequentially reads the product and the tax amount stored in the RAM for each tax type, and the product name of each product for each tax type. The price, the price including tax, and the tax amount for each product are printed on the receipt paper (S9). Specifically, the product code stored in the RAM is sequentially read for each tax type, and the contents (product name, price, tax-included price, tax amount) registered in S6 for the product specified by the product code are read. Print on receipt paper. In addition, the print control unit 29 reads “display data” for each tax type from the tax type setting master D2, and displays information related to the tax type, such as the rate of tax on the price of the product in the tax type. Print on receipt paper.

  FIG. 9 is a conceptual diagram showing an example of receipt paper printed by the POS terminal 2. As shown in FIG. 9, the name of each product, the price including tax, and the tax amount for each product are printed on the receipt sheet for each tax type in S9. In the illustrated example, for each consumption tax and liquor tax, a product (XX Noimizu 500 ml, liquor, etc.) and a tax amount (¥ 6, ¥ XX, etc.) are printed on the receipt paper. In addition, as information relating to the type of tax, the rate of tax on the product price (in the example shown, “Zay: 5%” for consumption tax, “Zay: XX%” for liquor tax) is printed.

  Next, the print control unit 29 issues a receipt sheet printed from the receipt issuing port 18 (S10). Then, the clerk performs an accounting process and ends the sales registration process for one account.

  In this embodiment, the operation of printing on the receipt paper in S9 and S10 is exemplified. However, the contents printed on the receipt paper in S9 and S10 by the display control unit 28 are displayed on the display 15 for the clerk, the customer It goes without saying that the data may be displayed on the display 16 for output. That is, it is only necessary to output at least one of the display on the salesclerk display 15 and the customer display 16 by the display control unit 28 and the printing on the receipt paper by the print control unit 29.

  As described above, in the POS terminal 2, for each tax type, information (product name, tax-included price, etc.) indicating the product for which the tax type is determined and the tax amount for the product are printed on the receipt sheet. Since it is output to the display 15 for the clerk and the display 16 for the customer by display, it is possible to make it easy to understand the product according to the tax type such as consumption tax, liquor tax and tobacco tax and the tax amount of the product. Further, in the POS terminal 2 of the present embodiment, for a plurality of products registered for sale, information indicating a product such as a product name and a tax-inclusive price and a tax amount for the product are output for each tax type. Therefore, the store clerk and the customer can easily know the product and the tax amount according to the tax type for each type of tax such as consumption tax, liquor tax and tobacco tax for a plurality of products registered for sale. In this embodiment, the operation at the time of sales registration is illustrated, but when performing inventory registration of a plurality of products, the same operation is performed, and for each tax type such as consumption tax, liquor tax, tobacco tax, Needless to say, the goods to be registered and the tax amount may be output.

  Note that the program executed by the POS terminal 2 of the present embodiment is provided by being incorporated in advance in a ROM or the like. The program executed in the POS terminal 2 of the present 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, or a DVD (Digital Versatile Disk). You may comprise so that it may record and provide on a readable recording medium.

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

  The program executed by the POS terminal 2 of the present embodiment has a module configuration including the above-described units (product code receiving unit 25, tax type determination unit 26, sales registration unit 27, display control unit 28, and print control unit 29). As actual hardware, a CPU (processor) reads the program from the ROM and executes it, so that the above-described units are loaded onto the main storage device and generated on the main storage device. .

  DESCRIPTION OF SYMBOLS 1 ... POS system, 2 ... POS terminal, 3 ... LAN, 4 ... Store server, 12 ... Drawer, 12a ... Drawer, 13 ... Keyboard, 14 ... Mode key, 15 ... Display for salesclerk, 16 ... Display for customer, 17 ... Printer, 18 ... Receipt issuing port, 19 ... Scanner, 21 ... Control unit, 22 ... Bus, 24 ... I / O device control unit, 23 ... Communication I / F, 25 ... Product code reception unit, 26 ... Tax type discrimination unit 27 ... Sales registration unit, 28 ... Display control unit, 29 ... Print control unit, 41 ... Control unit, 42 ... Bus, 43 ... Communication I / F, 44 ... I / O device control unit, 45 ... Keyboard, 46 ... Display unit 47... Printer 48. HDD M M Product Master DB DB Tax Rate Setting Database D1 Product Tax Rate Setting Master D2 Tax Type Setting Master

JP 2003-256937 A

Claims (6)

Product code receiving means for receiving the product code of the product;
Based on the tax setting information in which the tax type information indicating the tax type for each product and the information relating to the calculation of the tax amount to be taxed by the tax type are set by the received product code. Tax type discrimination means for discriminating the tax type of the product
Calculation means for calculating a tax amount for the product in the determined tax type based on the information for calculating the tax amount;
For each tax type, output means for outputting information indicating the product for which the tax type is determined, and a tax amount applied to the product,
A product data processing apparatus comprising: A sales registration means for performing sales registration of the product specified by the received product code;
The output means outputs, for each tax type, information indicating the product for which the tax type is determined and a tax amount for the product for the plurality of products registered for sale. The product data processing apparatus described.   The product data processing apparatus according to claim 1, wherein the output means outputs at least one of display on a display and printing on a sheet. The computer of the product data processing device
Product code receiving means for receiving the product code of the product;
It is specified by the received product code based on the tax setting information in which the tax type information indicating the tax type for each product and the information relating to the calculation of the tax amount taxed by the tax type are set. Tax type discrimination means for discriminating the tax type of the product
Calculation means for calculating a tax amount for the product in the determined tax type based on the information for calculating the tax amount;
For each tax type, output means for outputting information indicating the product for which the tax type is determined, and a tax amount applied to the product,
Program to make it function. Function as sales registration means for performing sales registration of the product specified by the received product code,
The output means outputs information indicating the product for which the tax type is determined and a tax amount for the product for each of the tax types for the plurality of products registered for sale. The listed program.   6. The program according to claim 4, wherein the output means outputs at least one of display on a display and printing on a sheet.

Images