JP3387162B2 - Transaction processing system - Google Patents

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention has a plurality of transaction processing P
OS performed by the terminal device, relates to transaction processing <br/> system that centrally managed collectively transaction data generated by the POS terminal for each transaction processed.

[0002]

2. Description of the Related Art In a transaction processing system, a POS terminal device transmits transaction data generated by product registration during transaction processing to a network controller, and the network controller stores this transaction data. In addition, when the store computer sends a request for a priority single item time zone, the network controller updates the sales result data including the total number of sales so far classified for each product based on the stored transaction data. , I was sending this sales performance data to the store computer. The store computer fetches and stores the transmitted sales record data, and manages sales. Further, the store computer transmits a priority single item time zone request to the network controller at regular time intervals or the like to manage changes in the sales situation such as the number of sales depending on the time zone for each product.

[0003]

However, in the conventional system, when the store computer sends a priority single item time zone request to the network controller, the network controller receives the priority single item time zone request and then based on the transaction data. There is a drawback that the response time becomes long because it is necessary to perform a series of operations for obtaining the sales performance data and transmitting the obtained sales performance data to the store computer.

Further, since the priority single item time zone request from the store computer to the network controller and the normal POS work at the network controller (for example, credit request from the terminal device and transmission of sales data) are asynchronous, the POS is performed. When the number of important single-item time zone requests overlaps when there is a lot of work, the load on the network controller increases, and the processing speed of POS work drops sharply.

An object of the present invention is to obtain and store sales performance data based on transaction data when the network controller reaches a preset time, and to store the sales performance data already stored when a request from the store computer is made. It is to provide a transaction processing system to transmit the data.

[0006]

Means for Solving the Problems] transaction processing system of the present invention, every time the transaction data are entered, and a plurality of POS terminal devices for outputting the input transaction data as sales data, each POS terminal The sales data file that captures and stores the sales data output by the sales data file, the sales performance data file that stores the sales performance data for each specific product based on the sales data and the sales time zone, and the sales performance data file Sales performance data write time setting table where the time to write performance data is set,
When the time set in the table is reached, sales performance data writing means for totaling sales performance data based on the sales data for each specific product and for each sales time zone and writing the sales performance data file into the sales performance data file. a network controller with, put to the network controller
Of sales data from each POS terminal device, and
And the sales result data based on the stored sales data
Of the sales results data
Writing to datafile, and asynchronously that, with a, and the store computer to perform the actual sales data of sales management captures the actual sales data stored in the file of the network controller to access the network controller Is characterized by.

The sales record data writing time setting table includes a plurality of time setting records for setting a time for writing the sales record data, and the sales record data file stores the sales record data. It is characterized in that it is provided with a plurality of frames for storing sales performance data by time zone, which are stored in correspondence with the time set in each of the time setting records.

[0008]

In the transaction processing system of the present invention, the PO
Transaction data is input by the S terminal device due to product registration, etc.
Each time it is input , the input transaction data is output as sales data. The network controller fetches the sales data output by the POS terminal device and stores it in a sales data file. When the time preset in the sales result data writing time setting table comes, the network controller outputs the sales result data based on the sales data. Write to sales data file. Further, the store computer fetches the sales performance data stored in the sales performance data file of the network controller when necessary regardless of the congestion degree of the POS work.

With the above-mentioned configuration, the store computer takes in sales performance data which the network controller has already calculated and stored, so that the response time can be shortened.

In addition, a plurality of time setting records of the network controller are preset with the time for writing the sales performance data to the sales performance data file. Further, the sales result data file stores the sales result data in the time-slot-based sales result data storage frame corresponding to the time set in the time setting record.

With the above configuration, the sales record data file stores and stores the sales record data for each time period.

[0012]

1 is a diagram showing the configuration of a transaction processing system according to an embodiment of the present invention. The transaction processing system performs processing such as product registration during transaction processing, outputs generated transaction data as sales data, and sends a request for credit processing.
1-n and the S terminal devices 1-1, 1-2, ..., 1-n and the sales data output by the POS terminal devices 1-1 to 1-n are stored and the credit processing request is sent to the public line. And a network controller 2 that is sent to the card company via
A store computer 3 that collectively manages sales and the like by fetching and processing data stored in the network controller 2 is provided. To the network controller 2, the POS terminal devices 1-1 to 1-n and the store computer 3 are connected inline by a data communication line.

FIG. 2 is a diagram showing the configuration of a network controller used in the transaction processing system of the embodiment. The network controller 2 stores in the PLU file 11 a PLU file 11 (sales data file) that stores a unit price for each product, and also stores the total sales points based on the sales data transmitted from the POS terminal device. Priority single product time zone file 12 (sales performance data file) that stores time-based sales performance data created based on the stored sales data and the sales performance data based on the sales data, and priority single product time A time activation table 13 (sales record data writing time setting table) in which the time to write to the band file 12 is set in advance.

FIG. 3 is a diagram showing the structure of an important single item time zone file used in the transaction processing system of the embodiment. Each record of the priority single product time zone file 12 stores a field for storing a PLU code that identifies a product as a priority single product and also serves as a record search key in the file, and a field for storing a department / class code indicating a department or class of the product. And a field for storing the status of a product indicating a discounted product, a special sale product, and the like, and a time frame for storing the sales amount and sales points of the product for each time period.

FIG. 4 is a diagram showing the structure of the time activation table used in the transaction processing system. Each record of the time activation table has a field for storing the execution time of the subsequent command statement, and a field for storing the command statement showing the processing content such as creating sales performance data and writing the sales performance data into the priority single product time zone file 12. ,,.

Each of the POS terminal devices 1-1 to 1-n outputs the transaction data input every time a transaction process is performed, as sales data. The network controller 2 takes in the output sales data and stores it in the PLU file 11. The PLU file 11 has an area for storing an identification code for identifying each product, a unit price of the product, a total number of sales of the product, a total sales amount of the product, and the like. The network controller 2 processes the sales data fetched from the POS terminal 1-1, and total sales points and total sales amount of the corresponding products stored in the PLU file 11 for the traded products. To update. In this way, the PLU file 11 is stored in the POS terminal devices 1-1 to 1-n.
Is updated every time a transaction is processed.

FIG. 5 is a diagram showing a flow of processing for updating and transmitting sales record data in the transaction processing system.
In the time activation table 13 provided in the network controller 2, as shown in FIG. 4, a plurality of records in which command statements indicating processing contents such as execution time and update of sales record data are written in advance are stored. The network controller 2 looks at the field that stores the execution time for all the records stored in the time activation table 13,
It is determined whether or not there is a record that has reached the execution time (n1).
If there is a record that has reached the execution time at this time, a command statement indicating the processing content of the corresponding record is read (n2), and it is determined whether this command statement indicates updating (writing) of sales record data. Yes (n3). If this command statement does not indicate the update of the sales result data, the network controller 2 performs the process corresponding to this command statement (n6), and the execution time of the record stored in the time activation table 13 is reached again. It is determined whether or not there is another record (n1).

On the other hand, if this command statement has the content indicating the update of the actual sales data, the network controller 2
Reads out the total number of sales and the total amount of sales of each product from the PLU file 11 (n4), and prepares for the corresponding record of the priority single product time zone file 12 for each product designated in advance as the priority single product. The sales performance data is written in the time frame (n5).

The determination of the corresponding time frame is made to be the frame next to the frame in which the total sales points and the total sales amount were written when the previous sales result data was updated. For example,
The first sales performance data after opening the store is written in frame-1.
The second sales result data is written in the next frame- 2. That is, the network controller 2 sequentially designates the next frame each time the sales result data is written. For this reason, the sales performance data is accumulated in the priority single-item time zone file 12 and stored for each time zone.

Further, the network controller 2 is n1.
If it is determined that there is no record for which the execution time is reached, it is determined whether or not there is a priority single-item time zone request from the store computer 3 (n7). At this time, if it is determined that there is no priority single product time zone request, the process returns to n1, but if it is determined that there is a priority single product time zone request, the network controller 2
Reads the key item time zone file 12 (n8),
A message is created based on this priority single product time zone file 12 (n9) and transmitted to the store computer 3 (n1).
0). Then, the network controller 2 again determines whether or not there is a record for which the execution time has been reached among the records stored in the time activation table 13 (n1).

The update and transmission processing of the sales record data is performed in parallel with other processing operations such as processing of transaction data transmitted from the POS terminal devices 1-1 to 1-n of the network controller 2. It has become so.

As described above, when the store computer 3 makes a request for the priority single-item time zone, the sales performance data previously created and stored in the priority single-item time zone file is transmitted as a telegram. , The processing of updating the sales result data is unnecessary, and the processing time can be shortened. Further, if the store computer outputs the priority single-item time zone request when the number of customers is small or after the store is closed, it is possible to prevent the speed of POS business processing from decreasing.

[0023]

[0024]

As described above, according to the present invention, sales record data is stored in the sales record data file at a preset time. Therefore, when a request for fetching the same data from the store computer is made, the work for obtaining the sales performance data from that time is not required, and the response time can be shortened.

Further, since the sales performance data for each time zone is accumulated and stored in the sales performance data file, and the data is transmitted when requested by the store computer, the storage performance data from the store computer is transmitted. If the data import request is output when the customer is few or after the store is closed, system performance can be prevented from decreasing.
It is possible to prevent a decrease in the processing speed of the transaction processing system.

[Brief description of drawings]

FIG. 1 is a diagram showing a configuration of a transaction processing system that is an embodiment of the present invention.

FIG. 2 is a diagram showing a configuration of a network controller used in the transaction processing system according to the embodiment.

FIG. 3 is a diagram showing a structure of a priority single product time zone file according to the embodiment.

FIG. 4 is a diagram showing a structure of a time activation table according to the embodiment.

FIG. 5 is a diagram showing an operation flow of the transaction processing system.

[Explanation of symbols]

1-POS terminal device 2-Network controller 3-store computer 11-PLU file 12-Important single item time zone file 13-hour activation table

Front page continuation (58) Fields surveyed (Int.Cl. ⁷ , DB name) G06F 17/60 118 G06F 17/60 318 G07G 1/14

Claims (2)

(57) [Claims] To 1. A time the transaction data is entered, the entered
Multiple POS to output and the transaction data as sales data
A terminal device, a sales data file that captures and stores sales data output by each POS terminal device, and a sales performance data file that stores sales performance data for each specific product and for each sales time zone based on the sales data And a sales result data writing time setting table in which the time to write the sales result data to the sales result data file is set, and the sales result data based on the sales data is specified when the time set in the table is reached. A network controller including sales result data writing means for totaling each product and for each sales time zone and writing the sales result data file, and each POS terminal device in the network controller .
Of sales data from the storage
Based on the above data, the sales result data is aggregated and this collection
Write the measured sales result data to the sales result data file
Inclusive can, and asynchronously, characterized in that it comprises a store computer to access the network controller performing the actual sales data of sales management captures the actual sales data stored in the file of the network controller, the Transaction processing system. 2. The sales result data writing time setting table includes a plurality of time setting records for setting a time for writing the sales result data, and the sales result data file stores the sales result data. 2. The transaction processing system according to claim 1, further comprising a plurality of time period-based sales record data storage frames that are stored in correspondence with the time set in each of the time setting records.