JPH04304598A - Merchandise sales data processor - Google Patents

Abstract

PURPOSE:To reduce memory capacity while accumulating sales data for this time on the data if the sales data for the same merchandise is stored when the merchandise sales data is stored in a memory of the terminal equipment and to manage registration history in one transaction unit while restoring a data summed up by merchandises in the terminal equipment of a host device to a sales data for merchandise in one transaction unit. CONSTITUTION:An off-line table 32i storing the number of sales for merchandise sales data stored in a transaction buffer 32f and buffer number storing the data in one transaction unit is provided in the termnal equipment. In the host device, based on the storage information of a transaction buffer and an off-line table, the merchandise sales data is restored in one transaction unit.

Description

[Detailed description of the invention]

0001

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a product sales data processing device called a POS (point of sale) system.

0002

2. Description of the Related Art Generally, a POS system is constructed by connecting one or more terminals having a product registration function and a host device that centrally manages the terminals via a transmission line.

[0003] Here, when one of the product codes attached to each product is input from an input device such as a keyboard, the terminal reads out a unit price preset for that product code, and applies the unit price to that unit price. The sales amount is calculated by multiplying the number of sales items, and product sales data consisting of the product code, number of sales items, sales amount, etc. is edited. The product sales data is displayed on a display and is also printed on a receipt or the like using a printer.

[0004] On the other hand, the host device collects product sales data edited by the terminal, and manages sales totals for each product and registration history for each transaction.

By the way, if the online status between the terminal device and the host device becomes abnormal and the terminal device becomes offline, the product sales data edited by the terminal device cannot be sent to the host device, and the data is lost.

[0006] Conventionally, therefore, a memory for accumulating and storing product sales data is prepared in a terminal, and when offline, the product sales data edited on the terminal is sequentially stored in the memory, and when restored online, the memory is The data was protected by transmitting the stored information to the host device.

[0007] However, the time required for recovery from an online abnormality varies depending on its scale, and a large-capacity backup memory is required in order to be able to cope with a long-term abnormality. For this reason, it was inevitable that the terminals would become larger and more expensive. Moreover, as the amount of data stored in the memory increases, it takes more time to send the memory data during online restoration, and it takes more time to start business after restoration.

[0008] When storing product sales data in a memory in a conventional terminal device, it is determined whether or not the same product's sales data is already stored in the memory, and if it is, the same product's sales data is stored in the memory. A technique for reducing memory capacity by accumulating current sales data in sales data is already known. (Refer to Japanese Patent Application Laid-Open No. 02-105998)

However, when this conventional technology is used,
When online is restored, product sales data aggregated by product code in memory is sent to the host device, so the host device can manage the sales total by product, but it is not possible to manage the registration history for each transaction. will no longer be possible.

0010

[Problems to be Solved by the Invention] As mentioned above, in the conventional product sales data processing device of this type, if the host device attempts to manage even the registration history of each transaction, it is difficult to manage a large amount of product sales at the terminal device. Memory for data backup was required, which inevitably increased the size and cost. Furthermore, it took time to send memory data during online recovery, and it took a long time to start operations after recovery. .

[0011] Therefore, in the present invention, when storing product sales data in the memory of a terminal device, if sales data of the same product has already been stored, the current sales data is accumulated in that data, thereby reducing the memory capacity. In addition, in the host device, the data aggregated by product on the terminal device can be restored to product sales data for one transaction unit, reducing the size and cost of the terminal device, and reducing the time required for online restoration. The present invention aims to provide a product sales data processing device that can reduce line occupation time.

0012

[Means for Solving the Problems] The present invention provides a terminal device that edits and outputs product sales data including the number of sales items, sales amount, etc. by inputting a product code, and a terminal device that is connected to the terminal device via a transmission line. This is a product sales data processing device comprising a host device that collects product sales data edited by the terminal device via the transmission line and manages registration history for each transaction.

[0013] Then, the terminal device stores a transaction buffer that stores product sales data corresponding to a series of buffer numbers, the number of sales items of the product sales data stored in this transaction buffer, and the buffer number in which the data is stored. an offline table for storing data in one transaction unit; a data determining means for determining whether or not product sales data of the same product code is stored in the transaction buffer when a product code is input while offline with the host device; If the determination means determines that there is data for the same product code, the current product sales data is accumulated in the data for the same product code in the transaction buffer, and if it is determined that there is no data for the same product code, the current product sales data is stored in the transaction. A data processing means for storing data in a new area of the buffer, a table creation means for setting the corresponding data of one transaction in an offline table based on the data processing result by this processing means, and a transaction buffer and offline table when the host device is restored online. and data transmitting means for transmitting each of the stored information to the host device via a transmission line.

[0014] When the host device receives the storage information of the transaction buffer and the offline table from the terminal device via the transmission line, the host device extracts the buffer number and the number of sales items from the storage information of the offline table in units of transactions. Then, product sales data is extracted based on the storage information of the transaction buffer corresponding to the buffer number extracted by this extraction means and the extracted number of sales items.
The system is equipped with a data restoration means for restoring data on a transaction-by-transaction basis.

[0015]

[Operation] With the present invention having such a configuration, when a product code is input on the terminal when the terminal and the host device are offline, the product sales data is edited according to the input code and stored in the transaction buffer. Ru. At this time, if product sales data with the same product code has already been stored in the same buffer, the current product sales data will be accumulated in the data with the same product code, and if it has not been stored, it will be stored in a new area of the same buffer. Ru. Also,
In the off-line table, the number of sales items of the product sales data stored in the transaction buffer and the buffer number in which the data is stored are stored in units of transactions. Then, at the time of online restoration with the host device, each of the stored information in the transaction buffer and offline table is transmitted to the host device via the transmission line.

[0016] When the host device receives the storage information of the transaction buffer and offline table from the terminal, the buffer number and the number of sales items from the storage information of the offline table are extracted for each transaction. Then, product sales data is restored in units of transactions based on the storage information of the transaction buffer corresponding to the extracted buffer number and the corresponding number of sales items. Using the product sales data of one transaction unit thus restored, sales totals for each product are performed, and registration history of one transaction unit is managed.

[0017]

DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment in which the present invention is applied to the POS system shown in FIG. 1 will be described below with reference to the drawings.

In FIG. 1, 11 is a terminal equipped with a product registration function, and 12 is a host device for centrally managing the terminal 11, which are electrically connected to each other via a transmission line 13.

As shown in FIG. 2, the host device 12 includes a processor 21 constituting a main body of the control unit, a RAM (random access memory) 22 forming various memory areas used for data processing, and a RAM (random access memory) 22 that forms various memory areas used for data processing. A communication interface 23 that controls data communication with the terminal 11 via the line 13, and a hard disk driver 2 that reads and writes data to and from the hard disk 24.
5. A full keyboard 26 equipped with numerical keys, character keys, function keys, etc., a display device 27 such as a CRT display, a printer 28 for printing out sales aggregation reports, registration history reports, etc. on recording paper are connected. It is configured.

The hard disk 24 has a product file 24a in which the product name, unit price, etc. are preset in correspondence with the product code assigned to each product, and the sales of each product are stored by product.
Sales aggregation file 24 that aggregates by time zone, person in charge, etc.
b. A registration history file 24c for accumulating and storing registration history data for one transaction unit is formed.

As shown in FIG. 3, the terminal device 11 includes a processor 31 constituting a control unit main body, a RAM 32 forming various memory areas used for data processing, and a RAM 32 that connects the host device via the transmission line 13. 12, a clock circuit 34 that measures the current time, a keyboard 35 equipped with various keys necessary for product registration, and the product name and sales amount of the registered product. The printer 37 is connected to a display 36 for displaying information such as receipts, etc., and a printer 37 for printing on receipts and the like.

The keyboard 35 includes a product key 35a for presetting the product code of each product, a number key 35b for entering the number of sales items, discount amount, payment amount, etc.
Clear key 3 used for clearing numbers, resetting errors, etc.
In addition to 5c, etc., there is a cash total key 35d that indicates that the entered number data is the amount to be paid by cash transaction, a credit key 35e that indicates that the amount is to be paid by credit transaction,
A discount key 35f for indicating the discount amount and a multiplication key 35g for indicating the number of items sold are provided.

The RAM 32 also stores the product file 24 in the hard disk 24 of the host device 12.
a, a totalizer 32b that stores the total amount of one transaction, a flag memory 32c of the registration flag F, a transaction number counter 32d that counts and stores transaction numbers, and a person in charge number that stores the number of the person in charge. Memory 32e
In addition, as shown in FIG. 4, there is a transaction buffer 32f that stores product sales data consisting of a product code, number of sales items, sales amount, and discount information corresponding to a series of buffer numbers, and a series of transaction buffers 32f as shown in FIG. Totalizer buffer 3 that stores payment codes and payment amounts corresponding to buffer numbers
2g, as shown in FIG. 6, a transaction buffer 32f that stores the transaction number, time, person in charge number, transaction quantity, and totalizer quantity as data related to one transaction, and also stores all product sales data processed in that transaction. A transaction buffer 32h stores therein the buffer number and number of items sold, and the buffer number and payment amount of the totalizer buffer 32g in which all payment data is stored, respectively.As shown in FIG. An offline table 32i is formed that sequentially stores transaction information as one table data. However,
The processor 31 of the terminal 11 executes the interrupt process shown in FIG. 8 in response to a one-second timer interrupt, for example.

That is, when this interrupt processing is started, it is first checked whether online with the host device 12 is normal. If the online status is abnormal and the online status is offline, it is determined by key input on the keyboard 35 whether or not product registration has been performed. Then, if the product has not been registered, this interrupt processing is ended.

[0025] When product registration is performed by key input of the product key 35a, offline registration processing shown in FIG. 9 is performed. That is, first, the registration flag F in the flag memory 32c is checked. Then, the same flag F is reset (0
), this is the first product registration in one transaction, so after setting (1), the transaction buffer 32h and totalizer 32b are cleared. Next, transaction number counter 3
2d is updated by "+1" and the count value is set as the transaction number, and is set in the transaction buffer 32h together with the time data measured by the clock circuit 34 and the person in charge number set in the person in charge number memory 32e. After that, the process moves to editing the product sales data. On the other hand, the registration flag F
If it is set, the product registration is for the second item in one transaction, so the process immediately moves to editing the product sales data.

[0026] In this product sales data editing process,
When product registration is performed only by inputting a product code using the product key 35a, the product file 32a is searched for the product code preset to the input product key 35a,
Read the corresponding product name and unit price. Then, with the unit price as the sales amount and the number of sales items as "1", the product sales data consisting of the product code, number of sales items, and sales amount is edited. However, when registering a product, the number key 35b and multiplication key 35g
When the number of sales items is inputted, the unit price read from the product file 32a is multiplied by the number of sales items keyed in to calculate the sales amount and edit the product sales data. In addition, when a discount amount is entered using the number key 35b and the discount key 35f, the sales amount is determined by subtracting the discount amount from the amount calculated by multiplying the unit price by the number of items sold, and the discount amount is set as the sales amount. Edit product sales data as reference information.

When the product sales data is edited in this manner, the sales amount in the data is added to the value stored in the totalizer 32b. In addition, the product name read from the product file 32a,
The number of items sold, sales amount, discount information, etc. are displayed on the display 36, and are printed out on a receipt or the like using the printer 37.

Next, the product code area of the transaction buffer 32f is searched to determine whether the same product code as the product code in the currently edited product sales data has already been stored. (Data judgment means)

00
29] Then, if the same product code is stored and the discount information also matches, the number of sales items and sales amount of the product sales data edited this time are stored in the area of the transaction buffer 32f where the same product code is stored. Accumulate. After that, the transaction quantity in the transaction buffer 32h is updated by "+1" and the transaction buffer 3 is updated with the current product sales data.
The buffer number 2f and the accumulated sales number are set as a pair in the product sales data number/score area in the transaction buffer 32h, and this processing is completed.

On the other hand, if the same product code is not stored, or if it is stored but the discount information does not match, the transaction buffer 32
Write the product sales data edited this time in the new area of f. After that, the transaction quantity in the transaction buffer 32h is updated by "+1", and the buffer number of the transaction buffer 32f in which the current product sales data has been written is paired with the written number of sales items, and the product in the transaction buffer 32h is updated. Once set in the sales data number/score area, this process ends. (Data processing means)

[0031] When the offline registration process is completed, it is determined whether or not a closing input has been made by key input on the keyboard 35. If the closing input has not been performed, the next product in one transaction has been registered, so the offline registration process described above is repeated.

When the closing input is performed by key inputting the current total key 35d or the credit key 35e, the screen shown in FIG.
Execute the offline closing process shown in That is, first, the registration flag F in the flag memory 32c is checked. If the same flag F is reset, the closing input was performed before the product registration in one transaction, so
It is treated as an error.

1 if the same flag F is set.
Since payment for the product registered in the transaction has been instructed, the number key 35b is selected from the total amount stored in the totalizer 32b.
The payment amount set by is subtracted, and the result of the subtraction is written into the totalizer 32b as the difference between the total amount and the payment amount. Here, if the difference is positive, it will be the remaining amount, and if it is negative, it will be change.

Next, the current total key 35d or the credit key 35
Payment method corresponding to e (cash payment or credit payment)
Edit the payment data from the payment code and the above payment amount. This payment data is then displayed on the display 36 and printed out on a receipt or the like by the printer 37. Further, the payment data is stored in a new area of the totalizer buffer 32g. Furthermore, the totalizer quantity of the transaction buffer 32h is updated by "+1", and the buffer number of the totalizer buffer 32g in which the current payment data is written is paired with the written payment amount to make the payment in the transaction buffer 32h. Set in the data number/amount area.

Thereafter, the value stored in the totalizer 32b is checked, and if it is positive, there is a balance to be paid, so the system waits for the balance to be input. Then, when the tightening input is performed, the offline tightening process described above is repeated.

If the value stored in the totalizer 32b is "0" or negative, it means that the payment has been completed, and the off-line table 32
Determine whether data is set in the start transaction number area of i. If not set, the transaction number in the transaction buffer 32h is used as the start transaction number, and the contents of the transaction buffer 32h are transferred to the head area of the offline table 32i. On the other hand, if data has already been set in the start transaction number area, the contents of the transaction buffer 32h excluding the transaction number are transferred to the empty area of the offline table 32i. Note that the data in the offline table 32i is arranged in order of time starting from the top area. (Table creation means) Thereafter, the registration flag F in the flag memory 32c is reset, and this process is ended.

On the other hand, in the interrupt processing shown in FIG. 8, if the online connection with the host device 12 is normal, it is determined whether data is stored in the start transaction number area of the offline table 32i. If the data has been stored, the offline state has been restored to the online state, so the data of the offline table 32i, the transaction buffer 32f and the totalizer buffer 3
2g of data is transmitted to the host device 12 via the communication interface 33 and the transmission line 13. Thereafter, after clearing the offline table 32i, transaction buffer 32f, and totalizer buffer 32g, normal online processing is performed. If no data is stored in the start transaction number area, the process immediately shifts to normal online processing.

[0038] In normal online processing,
When product registration is performed by key input on the keyboard 35, the product sales data is edited in the same way as in the offline registration process, and the product sales data is displayed and printed out and sent to the host device 12. In addition, in response to the first product registration of one transaction, the transaction number in the transaction number counter 32d (updated to "+1"), the person in charge number in the person in charge number memory 32e, and the time data measured by the clock circuit 34 are stored. Send. Also, when closing input is performed, the payment data is edited in the same way as offline closing processing, and the payment data is displayed and printed, and the host device 1
Send to 2.

On the other hand, when the processor 21 of the host device 12 receives each data of the offline table 32i, transaction buffer 32f, and totalizer buffer 32g from the terminal device 11 via the transmission line 13 and the communication interface 23, the processor 21 executes the data as shown in FIG. The program is configured to perform an information recovery process.

That is, first, the start transaction number is read from the received data of the offline table 32i and set as transaction number n. Next, the offline table 32i
Get the first time and person in charge number from. Also, read the transaction quantity corresponding to the time data,
Set the down counter T. Furthermore, the first data of the buffer number/sales item data corresponding to the time data is extracted (data extraction means). Then, data (product code, number of sales items, sales amount, discount information) corresponding to the buffer number extracted from the data of the transaction buffer 32f is obtained, and product sales data is restored based on that data and the extracted number of sales items. do. Specifically, the sales amount obtained as data in the transaction buffer 32f is divided by the number of sales items in the same data to obtain the amount per item, and that amount is multiplied by the number of sales items extracted as data in the offline table 32i. Calculate the sales amount and enter the corresponding product sales data (product code,
number of sales items, sales amount, discount information) (data restoration means).

[0041] Thereafter, the counter T is counted down by "-1", and if T = 0, another product has been registered in the transaction with the transaction number, so the time data corresponding to the time data in the offline table 32i is counted down. The following data is extracted from the buffer number and sales item data (data extraction means). Then, the product sales data is restored in the same manner as above (data restoration means).

[0042] When the counter T becomes "0", all the product sales data registered in the transaction with the transaction number has been restored, so the received offline table 32
The totalizer quantity data is read from the data of i and set in the down counter A.

Next, the first data of the buffer number/amount data of the payment data in the offline table 32i is extracted. Then, data (payment code, payment amount) corresponding to the buffer number extracted from the data in the totalizer buffer 32g is obtained. Then, payment data is restored from the payment code and the extracted payment amount.

[0044] Thereafter, the counter A is counted down by "-1", and if A does not become 0, another payment has been made in the transaction with the transaction number, so the next number of payment data is counted down from the offline table 32i. , Extract the amount data. Then, the payment data is restored in the same manner as above.

When the counter A becomes "0", all the payment data for the transaction with the transaction number has been restored, so it is determined whether or not the next time data is included in the data in the offline table 32i. If there is data, the product sales data and payment data for the transaction of that time data are restored in the same manner as above. At this time, the transaction number of the transaction is a number obtained by adding "+1" to n. When the restoration process described above is completed for all the time data included in the data of the offline table 32i, this process ends.

In this embodiment with such a configuration, when product registration is performed on the terminal 11 when the transmission line 13 connecting the terminal 11 and the host device 12 is offline,
The corresponding product sales data is in transaction buffer 3
It is stored in 2f. In this case, it is determined whether sales data of the same product as the currently registered product (even the discount information matches) is already stored in the transaction buffer 32, and if so, the The current sales data is accumulated and stored in the sales data of the same product. Therefore, transaction buffer 32
The capacity of f can be reduced compared to the conventional method in which generated product sales data is stored sequentially.

[0047] Also, the transaction buffer 32f stores the transaction time and person in charge number of each transaction conducted offline, the number of products registered in that transaction (transaction quantity), and product sales data for that number. The number and number of items sold, the number of payment methods specified in the transaction (totaling unit quantity), and the buffer number and payment amount of the totaling machine buffer 32g in which the payment data for that number are stored are stored in the offline table 32i. Stored in transaction units.

[0048] Then, at the time of online restoration, the storage information of the offline table 32i is sent to the host device 12 together with the storage information of the transaction buffer 32f and totalizer buffer 32g, and the host device 12 collects the product sales data and payment data for one transaction. is restored. Then, based on this restored data, the sales aggregation file 24b manages the sales aggregation by product, time period, person in charge, etc., and the registration history file 24c manages the registration history of one transaction unit. .

As described above, according to this embodiment, the terminal 11
Even if the storage capacity of the transaction buffer 32f, which is a backup memory for protecting product sales data that occurs when offline, is reduced, the registration history of transactions that occur while offline can be reliably managed in the host device 12 after online restoration. . Therefore, it is possible to reduce the size and cost of the terminal device 11 by reducing the memory capacity, and also to shorten the time required for the transmission line 13 to be occupied during online restoration, and to shorten the time until business can be started after online restoration.

Although the above embodiment has been explained using one terminal, it goes without saying that the present invention can also be applied to a POS system in which a plurality of terminals are connected to one host device.

[0051]

Effects of the Invention As described in detail above, according to the present invention, when storing product sales data in the memory of a terminal, if sales data of the same product has already been stored, that data will be used for the current sale. The memory capacity can be reduced by accumulating data, and in the host device, the data aggregated by product on the terminal can be restored to product sales data for one transaction unit, making the terminal smaller and cheaper. It is an object of the present invention to provide a product sales data processing device that can reduce costs and shorten the line occupation time at the time of online restoration.

[Brief explanation of the drawing]

FIG. 1 is a schematic diagram of a POS system that is an embodiment of the present invention.

FIG. 2 is a block diagram of a host device in the same embodiment.

FIG. 3 is a block diagram of a terminal in the same embodiment.

FIG. 4 is a detailed diagram of a transaction buffer provided in the terminal in the same embodiment.

FIG. 5 is a detailed diagram of a totalizer buffer provided in the terminal in the same embodiment.

FIG. 6 is a detailed diagram of a transaction buffer provided in the terminal in the same embodiment.

FIG. 7 is a detailed diagram of an offline table provided in the terminal in the same embodiment.

FIG. 8 is a flowchart of interrupt processing executed by the processor of the terminal in the same embodiment.

FIG. 9 is a flowchart specifically showing the offline registration process in FIG. 8;

FIG. 10 is a flowchart specifically showing the offline tightening process in FIG. 8;

FIG. 11 is a flowchart of information restoration processing executed by the processor of the host device in the same embodiment.

[Explanation of symbols]

11...Terminal device, 12...Host device, 13...Transmission line, 2
1, 31... Processor, 32f... Transaction buffer, 32g... Totalizer buffer, 32h... Transaction buffer, 32i... Offline table.

Claims (1)

[Claims] [Claim 1] A terminal device that edits and outputs product sales data including the number of sales items, sales amount, etc. by inputting a product code, and is connected to this terminal device via a transmission line,
It consists of a host device that collects the product sales data edited by the terminal device via the transmission line and manages the registration history of each transaction, and the terminal device sells the product according to a series of buffer numbers. A transaction buffer that stores data; an offline table that stores the number of sales items of product sales data stored in this transaction buffer and the buffer number in which the data is stored in units of transactions; data judgment means that judges whether or not product sales data with the same product code is stored in the transaction buffer when the code is input; data processing means for accumulating sales data into data of the same product code in the transaction buffer, and storing the current product sales data in a new area of the transaction buffer when it is determined that there is no data of the same product code; table creation means for setting the corresponding data of one transaction in the offline table based on the data processing result by the host device; data transmitting means for transmitting data to a host device, the host device comprising:
data extraction means for extracting the buffer number and the number of sales items from the storage information of the offline table in units of transactions when each storage information of the transaction buffer and the offline table is received from the terminal device via the transmission line; Product sales data processing characterized by comprising: data restoration means for restoring product sales data in units of transactions based on storage information of the transaction buffer corresponding to the buffer number extracted by the means and the extracted number of sales items. Device.