JP6599517B2 - Product data processing apparatus and program - Google Patents

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. As for the tax rate, there is a tax system such as a reduced tax rate that sets a tax rate lower than the original tax rate for specific products such as food.

  By the way, the tax system such as the reduced tax rate may be implemented in various forms. For example, a tax system that changes the tax rate (consumption tax) on the product according to the number of sales points of the specific product can be considered. However, since the conventional merchandise data processing apparatus cannot change the tax rate according to the number of sales points, it cannot cope with such a tax system.

The product data processing apparatus according to the embodiment includes a receiving unit, a first counting unit, a second counting unit, a first specifying unit, a second specifying unit, a calculating unit, and an output unit. . The receiving means receives an input of a product code for specifying a product. The first counting means counts the numerical value received via the numeric key as the sales score of the product specified by the product code. The second counting means counts the number of the product codes input in duplicate as the number of sales points of the product specified by the product code. The first specifying means is based on the first tax setting information in which the product code of each product is associated with the tax classification applied in accordance with the number of sales points, and the first counting means or the second The tax classification corresponding to the condition of the number of sales points of the goods counted by the counting means is specified. The second specifying means is based on the second tax setting information in which each of the tax classifications is associated with the tax rate applied in the tax classification, and the tax rate of the tax classification specified by the first specifying means Is identified. The calculating means calculates the tax amount of the product specified by the product code based on the tax rate of the tax classification specified by the second specifying means. The output means outputs information indicating the product, the tax classification specified by the first specification means, and the tax amount calculated by the calculation means for the product specified by the product code input in one transaction. To do.

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 tax classification master. FIG. 5 is a diagram illustrating a data configuration of the condition 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.

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

  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, the product master M stores product information such as a product name and a product price 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 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. 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 tax classification master D1 and a condition setting master D2.

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

  FIG. 5 is a diagram illustrating a data configuration 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 classification related to the product identified by the “product code”. The “applicable condition” includes a “condition ID”, a “sales score lower limit”, and a “sales score upper limit”. “Condition ID” is identification information uniquely set for each application condition. In addition, a lower limit value of sales points is set in “sales point lower limit”, and an upper limit value of sales points is set in “sales point upper limit”. Each of the application conditions is defined by a range of sales points set by the “sales point lower limit” and “sales point upper limit”. Note that “null” in the “sales point upper limit” means that the upper limit is unlimited.

  For example, for the product A with “00101” as the “product code”, if the number of sales of the product is 1, it corresponds to the application condition of the condition ID “201”, and therefore the tax rate “0” of the tax classification ID “102”. .05 "applies. In addition, regarding the product A with “00101” as the “product code”, when the number of sales points of the product is two or more, it corresponds to the application condition of the condition ID “202”, and therefore the corresponding tax classification ID “101”. The tax rate “0.02” applies.

  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 12a 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), for example, a numeric key for inputting a deposit amount, a sales score, etc., or a product registered for sale as one commercial transaction. Operation keys for performing various operation inputs such as a current 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. As the clerk display 15 and the customer display 16, for example, a liquid crystal display or the like is used, and the product name and price of the product registered for sale, the total amount of one commercial transaction, the amount of change, and the like 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 (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. 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 31, the sales point receiving unit 32, the tax rate specifying unit 33, the sales registration unit 34, The display control unit 35 and the print control unit 36 function.

  The product code receiving unit 31 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 31 may receive an input of a product code using a key input from the keyboard 13. Further, the product code receiving unit 31 may read the product code from other code symbols such as a two-dimensional code and receive the input.

  The sales point receiving unit 32 receives an input of the sales points of the same type of products classified under a predetermined condition among the products specified by the product code received by the product code receiving unit 31. Here, the “same type” is, for example, a product specified by the same product code, and the number of the product is input as a sales score via a numeric key of the keyboard 13 or the like. If the numeric key is not operated, the sales number “1” may be input as a default value. The method for inputting the sales score is not limited to the numeric key, and the number of duplicate product codes among the product codes received by the product code receiving unit 31 is received as the sales score of the product specified by the product code. May be.

  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 based on the product code received by the product code receiving unit 31 and the number of sales of the product code. 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 sales score received by the product code receiving unit 31 and the sales score receiving unit 32. A “tax classification ID” corresponding to the condition of the product code and the number of sales points is acquired. Next, the tax rate specifying unit 33 refers to the tax category master D1 of the tax rate setting database DB based on the acquired tax category ID, and acquires the tax rate associated with the tax category ID.

  The sales registration unit 34 registers the sales of the product specified by the product code received by the product code receiving 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 are acquired for the product code. . Next, the tax amount and the tax-included price are calculated based on the acquired price and the “tax rate” acquired by the tax rate specifying unit 33. Specifically, the sales registration unit 34 calculates the tax amount imposed on the product by multiplying the acquired price by the “tax rate” acquired by the tax rate specifying unit 33. In addition, the sales registration unit 34 calculates the price including tax 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-included price (sales price), and the like as information on the sold product.

  The display control unit 35 displays the product name, price, tax amount, tax-included price, and the like of each product registered by the sales registration unit 34 on the store clerk display 15 and the customer display 16. Specifically, the display control unit 35, based on the determination result by the tax rate specifying unit 33, information (product name, price, tax-included price) indicating the product for which the tax classification is determined for each tax classification, The tax amount for the product is displayed (details will be described later). Note that the display content displayed by the display control unit 35 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 sorted and displayed according to convenience. .

  The print control unit 36 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 34 on the receipt paper. Specifically, the print control unit 36, for each tax classification, based on the determination result by the tax rate specifying unit 33, information (product name, price, tax-included price) indicating the product for which the tax classification is determined, The tax amount for the merchandise is 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 reception unit 31 stands by until the barcode is scanned by the scanner 19 (step S11: No). When the barcode is scanned by the scanner 19, the product code receiving unit 31 reads and receives the product code from the barcode data (step S11: Yes). At this time, when the sales score of the scanned product is input by operating the numeric key or the like, the sales score receiving unit 32 receives the input sales score (step S12).

  Subsequently, the tax rate specifying unit 33 sets the condition based on the tax distinction ID of the product corresponding to the product code received by the product code receiving unit 31 and the number of sales of the product received by the sales point receiving unit 32. Is acquired from the condition setting master D2 (step S13). Next, the tax rate specifying unit 33 acquires the tax rate specified by the tax category ID from the tax category master D1 based on the tax category ID acquired in step S13 (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 tax-inclusive price based on the tax rate acquired by the tax rate specifying unit 33. (Step S15). Next, the sales registration unit 34 associates the tax information and the 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 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 the “tax distinction ID” indicating the tax distinction.

  Subsequently, the sales registration unit 34 registers information on the sold products such as the product name, price, tax amount, tax-inclusive price, and the number of sales (step S17). Next, the display control unit 35 displays the product name, price, tax amount, tax-included 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 current key is pressed on the keyboard 13 (step S19). While the current 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 products subject to sales registration, the product and the calculated tax amount for each tax classification are stacked and stored in the RAM.

  When the current key is pressed (step S19: Yes), the print control unit 36 sequentially reads the product and the tax amount stored in the RAM for each tax category, and stores the product name, price, The tax amount, tax-included price, sales points, etc. are printed on the receipt paper (step S20). Specifically, the product codes stored in the RAM are sequentially read for each tax category, and the contents registered in step S17 for the products specified by the product codes are read and printed on the receipt paper. In addition, the print control unit 36 reads the “tax category name” for each tax category from the tax category master D1, and prints information on the tax category, such as the tax rate that is imposed on the price of the product in the tax category, on the receipt sheet. To do.

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

  Returning to FIG. 8, the print control unit 36 issues a receipt sheet printed from the receipt issuing port 18 (step S21). 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 steps S20 and S21 is exemplified. However, the display control unit 35 displays the contents printed on the receipt paper in steps S20 and S21 described above. It may be displayed on the customer display 16. 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 35 and the printing on the receipt paper by the print control unit 36.

  As described above, the POS terminal 2 specifies the tax rate according to the sales point of the product specified by the same product code, and calculates the tax amount and the tax-inclusive price calculated based on the tax rate. Use for sales registration. As a result, the tax rate imposed on a product can be changed according to the number of sales points of the product, so it is possible to cope with a tax system that changes the tax rate (consumption tax) on the condition of the number of sales points of the product. . Further, in the POS terminal 2 of the present embodiment, 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 category for the product registered for sale. Therefore, the store clerk and the customer can easily know the product and the tax amount for each tax category for each product registered for sale.

  As mentioned above, although embodiment of this invention was described, the said embodiment was shown as an example and is not intending limiting the range of invention. The above-described embodiment can be implemented in various other forms, and various omissions, replacements, and changes can be made without departing from the spirit 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 invention described in the claims and equivalents thereof.

  For example, in the above embodiment, the same type of product is the product specified by the same product code. However, the present invention is not limited to this, and products belonging to the same category (for example, alcoholic beverages) are the same type of product. Also good. In this case, the product master M stores a 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 associates the classification code with the application code. And the tax classification ID are stored in association with each other. And the sales point reception part 32 receives the input of the sales point for every goods group which belongs to the same category among the goods used as the object of 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 points of the product group belonging to the same category. The classification code may be included in a part of the product code (for example, the upper three digits).

  In the above-described embodiment, a product in which the tax rate does not depend on the number of sales and the tax rate is constant is registered in the condition setting master D2 (see the product code “00102” in FIG. 5). It is good also as a form registered into this area | region. For example, for a product 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 this configuration is adopted, the tax rate specifying unit 33 searches for the product code received by the product code receiving unit 31 from the condition setting master D2, and when the corresponding product code (applicable condition) does not exist, the product master M Refer to Then, the tax rate specifying unit 33 reads the tax rate corresponding to the product code received by the product code receiving 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. However, the present invention is not limited to this, and part or all of the product master M and the tax rate setting database DB are stored in the POS terminal 2. It is good also as a form hold | maintained.

  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, 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 programs executed by the POS terminal 2 of the above embodiment are the above-described units (product code receiving unit 31, sales point receiving unit 32, tax rate specifying unit 33, sales registration unit 34, display control unit 35, print control unit 36). As the actual hardware, the CPU (processor) reads the program from the ROM and executes it, so that the respective units are loaded onto the main storage device and generated on the main storage device. It is like that.

  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, 23 ... Communication I / F, 24 ... I / O device control unit, 31 ... Product code receiving unit, 32 ... Sales point receiving unit , 33 ... Tax rate specifying part, 34 ... Sales registration part, 35 ... Display control part, 36 ... Print control part, 41 ... Control part, 42 ... Bus, 43 ... Communication I / F, 44 ... I / O device control part, 45 ... Keyboard, 46 ... Display, 47 ... Printer, 48 ... HDD, M ... Product master, DB ... Tax rate setting database, D1 ... Tax category 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;
First counting means for counting the numerical value received via the numeric key as the sales score of the product specified by the product code;
Second counting means for counting the number of the product codes input in duplicate as the number of sales of the product specified by the product code;
Products counted by the first counting means or the second counting means based on the first tax setting information in which the product code of each product is associated with the tax classification applied according to the sales points A first identifying means for identifying a tax classification corresponding to the condition of the number of sales points,
Second specification for specifying the tax rate of the tax category specified by the first specifying means based on the second tax setting information in which each of the tax categories is associated with the tax rate applied in the tax category Means,
Calculating means for calculating a tax amount of the product specified by the product code based on the tax rate of the tax classification specified by the second specifying means;
Output means for outputting information indicating the goods, the tax classification specified by the first specifying means, and the tax amount calculated by the calculating means for the goods specified by the product code input in one transaction ,
A product data processing apparatus comprising: The second tax setting information stores a name of the tax category in association with each of the tax categories,
The commodity data processing apparatus according to claim 1, wherein the output unit outputs the name of the tax classification specified by the first specifying unit based on the second tax setting information. Further comprising sales registration means for registering sales of the product specified by the product code;
The said output means outputs the information which shows the said goods, the tax classification which the said 1st specific means specified, and the tax amount which the said calculation means calculated about the goods registered by one transaction. 2. The product data processing apparatus according to 2.   The product data processing apparatus according to any one of claims 1 to 3, wherein the output unit outputs the sales score of a product in association with information indicating the product. Said calculating means includes a commodity code of each commodity, commodity specified based on the product master associating the price of a product corresponding to the product code, the rate which the second identification means has identified by the product code The product data processing apparatus according to any one of claims 1 to 4, wherein a 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;
First counting means for counting the numerical value received via the numeric key as the sales score of the product specified by the product code;
Second counting means for counting the number of the product codes input in duplicate as the number of sales of the product specified by the product code;
Products counted by the first counting means or the second counting means based on the first tax setting information in which the product code of each product is associated with the tax classification applied according to the sales points A first identifying means for identifying a tax classification corresponding to the condition of the number of sales points,
Second specification for specifying the tax rate of the tax category specified by the first specifying means based on the second tax setting information in which each of the tax categories is associated with the tax rate applied in the tax category Means,
Calculating means for calculating a tax amount of the product specified by the product code based on the tax rate of the tax classification specified by the second specifying means;
Output means for outputting information indicating the goods, the tax classification specified by the first specifying means, and the tax amount calculated by the calculating means for the goods specified by the product code input in one transaction ,
Program to make it function.

Images