JP7229301B2 - Product data processing device and program - Google Patents

Description

TECHNICAL FIELD Embodiments of the present invention relate to product data processing apparatuses and programs.

Conventionally, a product data processing device, such as a POS (Point Of Sale) terminal, which handles product data related to products specified based on product codes, sets a tax rate for each product. As for tax rates, there are tax systems such as reduced tax rates that stipulate lower tax rates than the original tax rates for specific products such as foodstuffs.

By the way, it is conceivable that the tax system such as the above-mentioned reduced tax rate may be implemented in various forms. For example, a tax system is conceivable in which the tax rate (consumption tax) applied to a specific product is changed according to the number of sales of the product. However, since the conventional product data processing device cannot change the tax rate according to the number of sales, it cannot cope with such a tax system.

A product data processing apparatus according to an embodiment includes reception means, counting means, first identification means, second identification means, calculation means, storage means, and output means. The receiving means receives input of a product code for specifying the product. The counting means counts the number of sales in one transaction of the product specified by the product code. The first specifying means is based on the first tax setting information that associates the product code of each product with the tax classification applied according to the sales points, and the sales points of the products counted by the counting means. Identify the tax categories that meet the conditions of The second identifying means is the tax rate of the tax classification identified by the first identifying means based on second tax setting information that associates each of the tax classifications with the tax rate applied in the tax classification identify. The calculating means calculates the tax amount of the product specified by the product code based on the tax rate of the tax category specified by the second specifying means. The storage means associates the tax classification specified by the first specification means, the input product code, and the tax amount calculated by the calculation means for the product code, and stores them in a storage area . When an operation to end one transaction is performed, the output means outputs, based on the information stored in the storage area, information indicating the product specified by the product code input in one transaction, and the calculation The tax amount calculated by the means is output for each tax category specified by the first specifying means.

FIG. 1 is a schematic configuration diagram of a POS system according to an embodiment. FIG. 2 is a block diagram schematically showing the functional configuration of the store server. FIG. 3 is a diagram showing the data structure of the product master. FIG. 4 is a diagram showing the data structure of the tax classification master. FIG. 5 is a diagram showing the data configuration of the condition setting master. FIG. 6 is an external perspective view of a POS terminal. FIG. 7 is a block diagram schematically showing the functional configuration of the POS terminal. FIG. 8 is a flow chart showing the procedure of operations performed by the POS terminal. FIG. 9 is a conceptual diagram showing an example of receipt paper printed by a POS terminal.

Embodiments of a product data processing device and a program will be described below with reference to the accompanying drawings. In this embodiment, a case where the product data processing device and program are applied to a POS terminal used in stores such as supermarkets will be described.

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

The store server 4 is in charge of controlling the POS system 1 as a whole. FIG. 2 is a block diagram schematically showing the functional configuration of the store server 4. As shown in FIG. The store server 4 includes a computer-configured control unit 41 composed of a CPU (Central Processing Unit), a ROM (Read Only Memory), a RAM (Random Access Memory), etc., a communication I/F 43, and an I/O device control unit. 44 are connected by a bus 42 . Store server 4 communicates online with multiple POS terminals 2 via communication I/F 43 and LAN 3 (see FIG. 1). A keyboard 45 , a display 46 , a printer 47 and a HDD (Hard Disk Drive) 48 are connected to the controller 41 via a bus 42 and an I/O device controller 44 . The HDD 48 stores various control programs for operating the CPU of the control unit 41, as well as a product master M and a tax rate setting database DB.

FIG. 3 is a diagram showing the data structure of the product master M. As shown in FIG. As shown in FIG. 3, the product master M stores product information such as the product name and product price in association with the "product code" of each product. The "product code" is identification information that is uniquely set for each product, and is used to identify the product. For example, in a store, the product code set for the product is written on the label attached to the product. Then, the product code written 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 or the like. The store server 4 can identify the product 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 the tax imposed on each product set in the product master M, that is, each product handled at the store, is set. Specifically, the tax rate setting database DB includes a tax classification master D1 and a condition setting master D2.

FIG. 4 is a diagram showing the data configuration of the tax classification master D1. As shown in FIG. 4, the tax classification master D1 stores a "tax classification name" and a "tax rate" in association with a "tax classification ID" that identifies a tax classification. “Tax classification ID” is identification information uniquely set for each tax classification. In this embodiment, the type of consumption tax imposed according to the number of sales of each product is defined as the tax category. The “tax division name” indicates the name of the tax division identified by the “tax division ID”. FIG. 4 shows an example in which "necessary items", "daily necessities", and "luxury items" are set as "tax category names". "Tax rate" indicates the tax rate applied to the "tax classification ID".

FIG. 5 is a diagram showing the data structure of the condition setting master D2. As shown in FIG. 5, the condition setting master D2 stores "application condition" and "tax classification ID" in association with "product code". Here, the "applicable condition" is used to specify the tax category for the product identified by the "product code". The 'applicable condition' includes a 'condition ID', a 'lower limit of sales points', and a 'upper limit of sales points'. “Condition ID” is identification information uniquely set for each applicable condition. Also, the lower limit of sales points is set in the "lower limit of sales points", and the upper limit of sales points is set in the "upper limit of sales points". Each applicable condition is defined by the range of sales points set by the "lower limit of sales points" and "upper limit of sales points". It should be noted that "null" in the "sales number upper limit" means that the upper limit is unlimited.

For example, for product A with a “product code” of “00101”, if the number of units sold for that product is 1, the applicable condition of condition ID “201” is met. .05" applies. In addition, for product A with the “product code” of “00101”, if the number of sales for that product is 2 or more, the applicable condition of condition ID “202” is met. A tax rate of "0.02" is applied.

Next, the POS terminal 2 will be explained. FIG. 6 is an external perspective view of the POS terminal 2. As shown in FIG. As shown in FIG. 6, the POS terminal 2 is placed on a drawer 12 for storing cash and the like, and controls opening and closing of a drawer 12a of the drawer 12. As shown in FIG. A mode key 14 is provided on the front side of the POS terminal 2 for selecting various business modes such as registration, inspection, settlement, and setting. The keyboard 13 provided on the front of the POS terminal 2 has numerical keys for the operator (clerk) to enter, for example, the amount deposited and the number of sales points, as well as the number of items registered for sale as one commercial transaction. Operation keys for performing various operation inputs, such as a cash total key for instructing total output, are arranged.

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. Liquid crystal displays, for example, are used for the store clerk display 15 and the customer display 16, and display the names and prices of products registered for sale, the total amount of one transaction, the amount of change, and the like. The POS terminal 2 incorporates a printer 17 for printing receipts and journals. A 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 also connected to a scanner 19 for reading barcodes attached to products.

FIG. 7 is a block diagram schematically showing the functional configuration of the POS terminal 2. As shown in FIG. The POS terminal 2 includes a computer-configured control section 21 including a CPU (Central Processing Unit), a ROM (Read Only Memory), a RAM (Random Access Memory), 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. The RAM also stores sales data indicating sales records of products, 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 via the I/O device control unit 24 and the bus 22 . The control unit 21 also communicates with the store server 4 via the communication I/F 23 and LAN 3 (see FIG. 1).

The control unit 21 develops a program stored in the ROM into the RAM and executes it, thereby creating a product code reception unit 31, a sales number reception unit 32, a tax rate identification unit 33, and a sales registration unit 34. , a display control unit 35 and a print control unit 36 .

When the barcode attached to each product is scanned by the scanner 19, the product code accepting unit 31 reads and accepts the product code from the barcode data. Note that the product code receiving unit 31 may receive the input of the product code using the key input from the keyboard 13 . Moreover, the product code receiving unit 31 may read a product code from other code symbols such as a two-dimensional code and receive the input.

The sales point reception unit 32 receives an input of sales points of products of the same type classified according to predetermined conditions among the products specified by the product code received by the product code reception unit 31 . Here, the "same type" is, for example, products specified by the same product code, and the number of the products is entered as the number of sales through the number keys of the keyboard 13 or the like. It should be noted that the number of sales "1" may be input as a default value when the number key is not operated. In addition, the method of inputting the number of sales is not limited to the number key, and the number of duplicate product codes among the product codes accepted by the product code accepting unit 31 is accepted as the number of sales of the product specified by the product code. may

Based on the product code received by the product code receiving unit 31 and the sales number of the product code, the tax rate specifying unit 33 refers to the product master M and the tax rate setting database DB of the store server 4 via the communication I/F 23. By doing so, the tax rate imposed on the product specified by the product code is specified.

Specifically, the tax rate specifying unit 33 refers to the condition setting master D2 of the store server 4 based on the product code and the number of sales received by the product code receiving unit 31 and the sales number receiving unit 32. Acquire the "tax classification ID" corresponding to the condition of this product code and sales quantity. Next, based on the obtained tax classification ID, the tax rate specifying unit 33 obtains the tax rate associated with the tax classification ID by referring to the tax classification master D1 of the tax rate setting database DB.

The sales registration unit 34 performs sales registration of the product specified by the product code received by the product code reception unit 31 . Specifically, the product code received by the product code receiving unit 31 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 for that product code are acquired. . Next, based on the acquired price and the “tax rate” acquired by the tax rate specifying unit 33, the tax amount and the tax-inclusive price are calculated. Specifically, the sales registration unit 34 multiplies the acquired price by the “tax rate” acquired by the tax rate identification unit 33 to calculate the amount of tax imposed on the product. The sales registration unit 34 also calculates the tax-inclusive price by adding the calculated tax amount to the price of the product. Then, the sales registration unit 34 registers the product name, price, tax amount, tax-inclusive price (selling price), etc. as information of the sold product.

The display control unit 35 displays the product name, price, tax amount, tax-inclusive price, etc. of each product registered by the sales registration unit 34 on the store clerk display 15 and the customer display 16 . Specifically, based on the determination result by the tax rate identification unit 33, the display control unit 35 provides information (product name, price, tax-inclusive price) indicating the product for which the tax category is determined for each tax category, The amount of tax on the product is displayed (details will be described later). It should be noted that it is not necessary to display all of the display contents displayed by the display control unit 35 on both the store clerk display 15 and the customer display 16, and the display contents may be appropriately distributed and displayed according to convenience. .

The print control unit 36 prints the store name and contact information of the store, and the product name, price, tax-inclusive price, tax amount, etc. of each product registered by the sales registration unit 34 on the receipt paper by the printer 17 . Specifically, based on the determination result by the tax rate identification unit 33, the print control unit 36 provides information (product name, price, tax-inclusive price) indicating the product for which the tax category is determined for each tax category, The amount of tax imposed on the product is printed on the receipt paper (details will be described later). The printed receipt paper is issued from the receipt issuing port 18 .

Next, the procedure of operations performed by the POS terminal 2 will be described. FIG. 8 is a flow chart showing the procedure of operations performed by the POS terminal 2 .

First, at the POS terminal 2 , the barcode attached to the product is scanned by the scanner 19 . The product code receiving unit 31 waits until the barcode is scanned by the scanner 19 (step S11: No). When the barcode is scanned by the scanner 19, the product code reception unit 31 reads and receives the product code from the barcode data (step S11: Yes). Also, at this time, when the number of sales of the scanned product is input by operating the number key, the sales number receiving unit 32 receives the input number of sales (step S12).

Subsequently, the tax rate specifying unit 33 determines the condition based on the tax distinction ID of the product corresponding to the product code accepted by the product code accepting unit 31 and the number of sales of the product accepted by the sales unit 32. from the condition setting master D2 (step S13). Next, based on the tax classification ID obtained in step S13, the tax rate identifying unit 33 obtains the tax rate identified by the tax classification ID from the tax classification master D1 (step S14).

The sales registration unit 34 acquires product information such as the product name and price set in the product master M for the product code, and calculates the tax amount and the tax-inclusive price based on the tax rate acquired by the tax rate identification unit 33. (step S15). Next, the sales registration unit 34 associates the tax category and tax rate acquired by the tax rate specifying unit 33 with the product information of the product specified by the product code and the calculated tax amount, and stores them in the RAM (step S16). Specifically, the product code received by the product code receiving unit 31 and the calculated tax amount are stacked in an array (storage area) reserved for "tax classification ID" indicating the tax classification.

Subsequently, the sales registration unit 34 registers information on the sold product, such as the product name, price, tax amount, tax-inclusive price, sales number, etc. (step S17). Next, the display control unit 35 displays the product name, price, tax amount, tax-inclusive price, etc. of each product registered by the sales registration unit 34 on the store clerk display 15 and the customer display 16 (step S18).

Next, the POS terminal 2 determines whether or not the cash key on the keyboard 13 has been pressed (step S19). While the cash total key is not pressed (step S19: No), the process returns to step S11 and the processes of steps S11 to S19 are continued until the sales registration of all products is completed. Therefore, in step S16, for all the products to be registered for sale, the products and the calculated tax amount for each tax category are stacked and stored in the RAM.

If the cash total key is pressed (step S19: Yes), the print control unit 36 sequentially reads out the products and tax amounts stored in the RAM for each tax classification, and displays the name, price, and price of each product for each tax classification. The tax amount, tax-inclusive price, sales number, etc. are printed on the receipt paper (step S20). Specifically, the product code stored in the RAM is sequentially read for each tax category, and the contents registered in step S17 for the product specified by the product code are read and printed on the receipt paper. In addition, the print control unit 36 reads out the "tax classification name" for each tax classification from the tax classification master D1, and prints information on the tax classification, such as the tax rate imposed on the product price in the tax classification, on the receipt paper. do.

FIG. 9 is a conceptual diagram showing an example of receipt paper printed by the POS terminal 2. As shown in FIG. As shown in FIG. 9, the product name and tax amount of each product are printed on the receipt paper in step S20 for each tax classification. In the illustrated example, the product name (such as “product A”) and the tax amount (such as “¥8”) are printed on the receipt paper for each of the tax classifications of “necessities,” “daily necessities,” and luxury goods. In addition, as information on the tax classification, the tax rate ("Ze: 2%" etc.) to be taxed on the price of the product is printed.

Returning to FIG. 8, the print control unit 36 issues the printed receipt paper from the receipt issuing port 18 (step S21). Then, the store clerk performs accounting processing and completes the sales registration processing for one transaction.

In this embodiment, the operation of printing and outputting the receipt paper in steps S20 and S21 is exemplified. , may be displayed on the customer display 16 . In other words, at least one of the display on the store clerk's display 15 and the customer's display 16 by the display control unit 35 and the printing on the receipt paper by the print control unit 36 may be output.

As described above, the POS terminal 2 identifies the tax rate according to the number of sales of products identified by the same product code, and calculates the tax amount and tax-inclusive price based on the tax rate. Register for sale using As a result, the tax rate imposed on a product can be changed according to the number of sales of the product, making it possible to respond to tax systems that change the tax rate (consumption tax) based on the number of sales of the product. . In addition, the POS terminal 2 of the present embodiment outputs information indicating the product such as the product name, tax-inclusive price, etc., and the tax amount applied to the product for each tax classification for the product registered for sale. Therefore, a store clerk or a customer can easily know the product and the tax amount for each tax category for each product registered for sale.

Although the embodiment of the present invention has been described above, the above embodiment is presented as an example and is not intended to limit the scope of the invention. The above embodiment can be implemented in various other forms, and various omissions, replacements, and modifications can be made without departing from the scope of the invention. The above-described embodiments and modifications thereof are included in the scope and gist of the invention, and are included in the scope of the invention described in the claims and equivalents thereof.

For example, in the above embodiment, products of the same type are identified by the same product code. good too. In this case, the product master M stores the classification code for identifying the category to which the product belongs in association with the product code of each product, and the condition setting master D2 stores the applicable condition in association with the classification code. and the tax classification ID are associated with each other and stored. Then, the sales point receiving unit 32 receives an input of the sales points for each product group belonging to the same category among the products targeted for sales registration. By adopting such a configuration, it is possible to change the tax rate imposed on the product group according to the number of sales of the product group belonging to the same category. Note that the classification code may be included in a part of the product code (for example, upper 3 digits).

In addition, in the above-described embodiment, a product whose tax rate does not depend on the number of sales items and whose tax rate is constant is registered in the condition setting master D2 (see product code "00102" in FIG. 5). may be registered in the area of For example, for products with a fixed tax rate, the tax rate may be stored in the product master M in association with the product code of the product. When adopting this configuration, the tax rate specifying unit 33 searches the condition setting master D2 for the product code accepted by the product code accepting unit 31, and if the applicable product code (applicable condition) does not exist, the product master M See Then, the tax rate specifying unit 33 reads the tax rate corresponding to the product code accepted by the product code accepting unit 31 from the product master M, thereby specifying the tax rate.

In the above embodiment, the store server 4 holds the product master M and the tax rate setting database DB. may be held.

The program executed by the POS terminal 2 of the present embodiment is preinstalled in a ROM or the like and provided. The program executed by the POS terminal 2 of this embodiment is a file in an installable format or an executable format, and can be stored on a computer such as a CD-ROM, flexible disk (FD), CD-R, DVD (Digital Versatile Disk). It may be configured to be recorded on a readable recording medium and provided.

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

The program executed by the POS terminal 2 of the above-described embodiment includes the above-described units (the product code reception unit 31, the sales number reception unit 32, the tax rate identification unit 33, the sales registration unit 34, the display control unit 35, and the print control unit 36). As the actual hardware, the CPU (processor) reads out the program from the ROM and executes it, and the above parts are loaded onto the main memory and generated on the main memory. It's like

DESCRIPTION OF SYMBOLS 1...POS system 2...POS terminal 3...LAN 4...Store server 12...Drawer 12a...Drawer 13...Keyboard 14...Mode key 15...Clerk's display 16...Customer's display 17... Printer 18 Receipt issuing port 19 Scanner 21 Control unit 22 Bus 23 Communication I/F 24 I/O device control unit 31 Product code reception unit 32 Sales number reception unit , 33... tax rate identification unit, 34... sales registration unit, 35... display control unit, 36... print control unit, 41... control unit, 42... bus, 43... communication I/F, 44... I/O device control unit, 45...Keyboard, 46...Display, 47...Printer, 48...HDD, M...Product master, DB...Tax rate setting database, D1...Tax classification master, D2...Condition setting master

JP 2012-181752 A

Claims (6)

a receiving means for receiving an input of a product code for specifying a product;
a counting means for counting the number of sales in one transaction of the product specified by the product code;
The tax category corresponding to the condition of the sales quantity of the product counted by the counting means based on the first tax setting information that associates the product code of each product with the tax category applied according to the sales quantity. a first identifying means for identifying the
a second identification for identifying the tax rate of the tax classification identified by the first identifying means based on second tax setting information that associates each of the tax classifications with the tax rate applied in the tax classification; means and
calculation means for calculating the tax amount of the product specified by the product code based on the tax rate of the tax category specified by the second specifying means;
storage means for associating the tax category specified by the first specifying means, the input product code, and the tax amount calculated by the calculation means for the product code, and storing in a storage area ;
When the end operation of one transaction is performed, the information indicating the product specified by the product code input in one transaction and the information calculated by the calculating means are calculated based on the information stored in the storage area. an output means for outputting a tax amount for each tax category specified by the first specifying means;
Product data processing device comprising. the second tax setting information stores the name of the tax classification in association with each of the tax classifications;
2. The product data processing apparatus according to claim 1, wherein said output means outputs the name of the tax category specified by said first specifying means based on said second tax setting information. further comprising sales registration means for registering sales of the product specified by the product code;
When an operation to end one transaction is performed, the output means outputs information indicating the product registered for sale in one transaction and the tax amount calculated by the calculation means based on the information stored in the storage area. 3. The product data processing apparatus according to claim 1, wherein the first specifying means outputs and for each tax classification specified by said first specifying means. The product data processing apparatus according to any one of claims 1 to 3, wherein the output means outputs the tax rate specified by the second specification means and the tax amount calculated by the calculation means for each product. The calculation means calculates the tax rate specified by the second specifying means based on a product master in which the product code of each product and the price of the product corresponding to the product code are associated with the product specified by the product code. 5. The product data processing device according to any one of claims 1 to 4, wherein the tax amount of the product is calculated by multiplying the price of the product. The computer of the product data processing device,
a receiving means for receiving an input of a product code for specifying a product;
a counting means for counting the number of sales in one transaction of the product specified by the product code;
The tax category corresponding to the condition of the sales quantity of the product counted by the counting means based on the first tax setting information that associates the product code of each product with the tax category applied according to the sales quantity. a first identifying means for identifying the
a second identification for identifying the tax rate of the tax classification identified by the first identifying means based on second tax setting information that associates each of the tax classifications with the tax rate applied in the tax classification; means and
calculation means for calculating the tax amount of the product specified by the product code based on the tax rate of the tax category specified by the second specifying means;
storage means for associating the tax category specified by the first specifying means, the input product code, and the tax amount calculated by the calculation means for the product code, and storing in a storage area ;
When the end operation of one transaction is performed, the information indicating the product specified by the product code input in one transaction and the information calculated by the calculating means are calculated based on the information stored in the storage area. an output means for outputting a tax amount for each tax category specified by the first specifying means;
program to function as

Images