JPH06103517B2 - Sales registration device - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION [Industrial field of application] The present invention relates to a sales registration device which can be purchased in advance with a predetermined amount of money and can be paid with a prepaid card that allows merchandise to be purchased instead of cash. In particular, it relates to an electronic cash register (ECR), a POS (point of sale) system, an electronic scale for face-to-face sales, and the like.

[Prior Art] Recently, due to the relaxation of legal regulations, a system that allows payment by a prepaid card has been put into practical use as a POS system, and has been attracting attention. And it is expected to spread rapidly in the future.

In this type of system, the prepaid card is also used as a membership card for the customer management system, and when the customer purchases a new prepaid card, the unused balance of the old card is added to the pure balance of the new card. There is a system that handles the balance of new cards.

[Problems to be Solved by the Invention] However, as described above, when the unused balance of the old card is added to the balance of the new card, a special device is required to satisfy the accounting request. Become.

That is, the uncollected amount of the prepaid card (= issue amount of prepaid card-collected amount) can be treated as profit of the store under the tax law at the time when 5 years have passed from the issue date of the prepaid card. As described above, when one card has different balances of issue dates, the ordinary balance management can determine how much unpaid amount of prepaid card is five years from the issue date. It is impossible, and the above accounting requirements cannot be satisfied.

This proposal was made in view of the above points, and even if the unused balance of the old card is added to the purchase balance of the new card to make it the balance of the new card, for a certain period from the issue date (for example, It is an object of the present invention to provide a sales registration device equipped with a prepaid balance management method capable of facilitating the uncollected amount of a prepaid card that has passed 5 years.

[Means for Solving the Problem] The sales registration device according to claim 1 of the present invention registers the sale of a product to each customer, calculates the total purchase amount of all the products sold to the customer, and pays the purchase amount. The usable amount is read from the prepaid card in which the usable amount is written, and the balance obtained by paying a part or all of the total purchase amount from the usable amount is used as the new usable amount. In a sales registration device that writes to a prepaid card, the accumulated value of the issued amount that is the usable amount at the time of issuing the prepaid card and the accumulated value of the collected amount that is the paid amount paid by the prepaid card are stored for the past certain years. A storage means that stores each issuance period that includes the issuance date of the card, and when the prepaid card is issued If you have a prepaid card in Japan, add the usable amount of the old prepaid card you currently have to the usable amount of the new prepaid card that you issued this time, and add the new prepaid card as the issued amount of the new prepaid card. A prepaid card issuing means for issuing and an issuance amount read out from the storage means at the time of issuing the new prepaid card, the issuance amount of the new prepaid card corresponding to the issuance period including the issuance date of the new prepaid card. The amount is added to the amount and stored in the storage unit, and the usable amount of the old prepaid card at the time of issuing the new prepaid card is read from the storage unit corresponding to the issuance period including the issuance date of the old prepaid card. Stored in the storage means by adding to the recovered amount collected When the prepaid card is used to pay the total purchase amount of the customer and the total purchase price of the customer, the collected amount read out from the storage means corresponding to the issue period including the issue date of the prepaid card is sold to the customer. Second accumulating means for adding a part or all of the total purchase amount of all commodities and storing it in the storage means.

Further, the sales registration device according to claim 2 is characterized in that the member number is stored in the prepaid card and is also used as the member card for the customer management system.

[Operation] In the above configuration, if the customer currently holds the prepaid card at the time of issuing the prepaid card, the prepaid card issuing means currently holds the usable amount of the new prepaid card issued this time. The usable amount of the old prepaid card is added and the new prepaid card is issued as the issue amount of the new prepaid card. At this time, the first accumulating means adds the issuance amount of the new prepaid card to the issuance amount read from the storage means corresponding to the issuance period including the issuance date of the new prepaid card, and stores it in the storage means. Remember
The usable amount of the old prepaid card at the time of issuing the new prepaid card is stored in the storage means by adding it to the collected amount read from the storage means corresponding to the issuance period including the issue date of the old prepaid card. . That is, the usable amount of money of the old prepaid card is considered to have been used when the new prepaid card was issued.

In addition, when paying the total purchase amount of the customer with the prepaid card, the second accumulating means adds the collected amount read from the storage means to the customer corresponding to the issuance period including the issuance date of the prepaid card. A part or all of the total purchase price of all the commodities sold to is added and stored in the storage means.

Further, it is possible to perform total management of the issued amount, the collected amount, and the uncollected amount for each issuing period.

Embodiments Embodiments of the present invention will be described below with reference to the drawings.

In this embodiment, the prepaid card is also used as a membership card.

First, the overall configuration will be described.

FIG. 1 is a block diagram showing the configuration of a store controller type POS system according to an embodiment of the present invention. In this figure, reference numeral 1 is a store controller, 2 _{1 to} 2 n are ECRs, 3 _{1 to} 3n ₊₁ are store controllers 1 and respective ECRs 2 ₁
~ 2n is a signal line such as a fiber optic fiber cable that connects to 2n in a loop. The store controller 1 manages data used in the ECR2 _{1 to} 2n and data generated in these by communicating with the ECR2 _{1 to} 2n via the signal lines 3 _{1 to} 3n _{+ 1} .

Next, the electrical configuration of the store controller 1 will be described. FIG. 2 is a block diagram showing an electrical configuration of the store controller 1. In this figure, reference numeral 4 is each ECR2
A general-purpose computer such as a personal computer that controls the management and ECR2 ₁ to 2n of data data and generating used in ₁ to 2n. This general-purpose computer body 4 is a CPU (central processing unit) that controls each part of the device.
With the ROM that stores the control program used in the CPU and each treatment program loaded,
It is composed of a RAM for storing various data during program execution, and a floppy disk device for driving a floppy disk in which application programs and various data are stored. Further, 5 is a hard disk device. As an external storage device, it drives a hard disk in which application programs and various data are stored. The hard disk attached to the hard disk device 5 has a prepaid card management file (described later),
A customer file (described later), a performance file, and a product file (PLU file) are set. 6 is a CPU display for displaying aggregated data and the like, 7 is a printer for printing aggregated data and the like on paper, 8 is a keyboard composed of ten keys and function keys, 9 is a communication control unit, and the general-purpose computer main body 4 is polls via the communication control unit 9 performs the exchange of data with the ECR2 ₁ to 2n.

Next, the electrical configuration of ECR2 will be described. Figure 3 shows
FIG. 4 is a block diagram showing the electrical configuration of the ECR2, and FIG. 4 is a perspective view showing the same external configuration. In these figures, 10 is ECR2
CPU that controls each part of the device inside, 11 is the product name, price,
The display unit displays the total amount of money, various messages, and the like, and is composed of a salesclerk display unit 11a and a customer display unit 11b. 12 is an operation unit, and the function key 12a
And a numeric keypad 12b, a preset key 12c, and a control key 12d. Further, 13 is a printing section, which is a receipt printing section 13a for printing and issuing a receipt.
And a journal printing unit 13b for printing a journal. 14 is a communication interface, CP
The U10 exchanges data with the store controller 1 through the communication interface 14. Reference numeral 15 is a ROM in which a control program used in the CPU 10 is stored, 1
6 is a RAM in which various data are temporarily stored. This RAM16
A display register area, a total register area, a working area, etc. are provided in each. Further, 17 is a cash drawer for storing cash, 18 is a magnetic card read / writer for reading and writing various data such as membership numbers and balances stored in a prepaid card, and the prepaid card insertion shown in FIG. When the prepaid card is inserted through the opening 18a, various data such as the membership number and the balance are read and written from the prepaid card, and then the prepaid card is ejected through the prepaid card insertion opening 18a. Further, the magnetic card reader / writer 18 is provided with a printer (not shown). On the back side of the prepaid card, the membership number and the purchase amount are premium (if the old prepaid card has a balance, further, In addition to printing the amount including the balance, the product purchase date, balance, and service points are printed. In addition,
The prepaid card is used as a membership card even when the balance becomes "0", and the service points are printed.
Reference numeral 19 is a bar code scanner used as an option, which reads the code data corresponding to the bar code from the bar code printed portion of the product and inputs it to the CPU 10.

FIG. 5 is a diagram showing a planar configuration of the prepaid card used in this example. In this figure, 20 is a card base, and 21 is a magnetic stripe for magnetically storing data.

As shown in FIG. 6, the magnetic stripe 21 stores a membership number, an issue date, a ticket type, an issue amount, and a balance.

In the above-mentioned ticket types, "1" is displayed as a 10,000-yen ticket, "2" is a 5,000-yen ticket, and "3" is a 1,000-yen ticket depending on the purchase amount of the card. Then, as a purchaseable amount of each of the above ticket types (balance of purchase card itself), when a card is purchased with a premium, the purchase amount of the card is added to the premium to be the purchaseable amount. For example, when issuing a 10,000-yen ticket, if there is no premium, "10,000" yen, and if there is a 500-yen premium, "10,500" yen is the 10,000-yen card purchase amount. Becomes When issuing a new card, the unused balance of the old card is read as described later, and this is added to the purchaseable amount of the new card, that is, the balance of the purchased card itself, and the addition result of the new card is added. Write as issue data.

Also, the membership number is given when the customer first purchases the prepaid card. And the membership application procedure (name,
Become a member by recording the address, gender, age, Tel, etc.). A member number is recorded on the prepaid card although the member is not a member unless the member application procedure is performed, and the store controller 1 manages the balance of the prepaid card by this number. That is, magnetic stripe
The membership number stored in 21 is the management number of the prepaid card if it is not a member.

As for the issue date, the issue date of this card, that is, the purchase date is stored.

As described above, for example, when a new card is purchased, the issue amount is the issue amount of the new card by adding the unused balance of the old card to the purchaseable amount of the purchase card. That is,
If you buy a 10,000-yen ticket and the old card has an unused balance of 1,000 yen, the purchaseable amount (10,000 yen) of the purchase card (10,000 yen ticket, no premium) + the unused balance of the old card (1,000 yen) (Yen) = New card issuance amount (11,000 yen), which is stored in the magnetic stripe 21 issuance amount area.

In addition, the balance is the amount issued when a new card is issued.If you settle a payment with a prepaid card, the amount settled is subtracted from the current balance, and the value after subtraction is stored as the current balance. is there.

Next, the prepaid card management file (hereinafter,
Only the management file) will be described.

FIG. 7 is a diagram showing an area structure of the management file. This management file is for the prepaid card issuance amount,
It is a file that stores the collected amount, the uncollected amount, and the like, and is set for each ticket type. That is, with respect to the cards issued in the last 5 years, the issued amount, the recovered amount, and the uncollected amount are separately registered in the management file for each issuing month. (FIG. 7 (a)). Further, the cumulative values of the separately registered issuance amount, collected amount, and uncollected amount are also registered ((a) in the same figure). The registration category is
Up to 60 lines (12 months x 5 years worth) are available. Therefore, for cards that have been issued for more than 5 years, it is not possible to register them separately for each issue date. In this case,
The accumulated value of issued cards, the accumulated value of collected amount, the accumulated value of uncollected amount, and the collected amount generated this month are registered for five years or more (FIG. 2B). Various data of the above issued amount are for each ticket type (10,000 yen, 5,000 yen, 10,00
Every 0 yen), it can be updated online in real time or in batch.

In the registration process to the management file, for example, the total amount of prepaid cards issued during February 1990 is stored in the issue amount column of the line 1990.2. The issue amount column is updated each time a prepaid card is issued in February 1990, but it does not change after February 1990.

When the customer pays the balance of the prepaid card issued in February 1990, the amount is stored in the collection amount column of the line 1990.2 as the collection amount.

The uncollected amount is stored in the uncollected amount column by subtracting the collected amount column from the issued amount column.

The uncollected amount is recorded as profit when five years have passed since the issue date.

As for the data before 5 years, the cumulative total of the issued amount, the collected amount, the uncollected amount, and the 5
The collection amount of prepaid cards issued before the year is stored.

The collection amount of the prepaid card issued before the above 5 years was recorded as a profit, but since it was not actually a profit, it is used as adjustment data.

The customer file set in the hard disk device 5 has the structure shown in FIG. That is, this customer file includes personal data (member code, address, name, age, sex, phone number, birthday, etc.), purchase data (cumulative purchase history, purchase details, cumulative service amount, service points, etc.) Card data (issue date, ticket type,
This is a file that stores the issued amount and balance.

Next, the operation of this example will be described.

First, FIG. 9 shows the store controller 1, the CPU 10 of the ECR2, the clerk and the customer's processing when the customer stores the desired product for purchase in the basket while visiting the sales floor, and then comes to the checkout place where the ECR2 is placed. This will be described with reference to the flowchart shown in FIG.

When the customer brings in one or more products and requests payment, the clerk receives the product at a position facing the customer, and presses the preset key 12c, the numeric keypad 12b, the function key 12a, etc. of the operation unit 12, Enter the code. Alternatively, the optional bar code scanner 19 is made to read the bar code of the product. As a result, the product code is transferred to the CPU 10.

From this, the CPU 10 proceeds to step SA1 and performs product registration processing. That is, the CPU 10 receives, via the signal line 3 and the communication interface 14, the data such as the product name and price of the product read from the product file of the store controller 1 based on the product code. On the other hand, the store controller 1 registers the product in the performance file. EC
The CPU 10 of the R2 displays the product name and price of the product on the display unit 11 and drives the printing unit 13 to print on the receipt paper. In addition, the CPU 10 accumulates the price of the product for which the product code is input in the RAM 16, and then proceeds to step SA2.

In step SA2, the CPU 10 determines whether the "subtotal" key has been pressed. If the result of this judgment is "NO",
Wait for input of code data for the next product. Therefore, when the code data of the next product is supplied, the process returns to step SA1 and the above-described product registration process is repeated. Then, when registration of all the products is completed and the clerk presses the "subtotal" key in the function keys 12a, the determination result of step SA2 becomes "YES", and the process proceeds to step SA3.

At step SA3, the CPU 10 displays the total amount on the display unit 11 and drives the printing unit 13 to print on the receipt paper. The total amount of money is the total price of the products purchased by the customer, and is the amount that the customer should pay to the store. Then, the process proceeds to step SA4.

In step SA4, the store clerk inquires of the customer whether he / she wants to make a payment with a prepaid card. If the customer does not wish to make a payment with the prepaid card, the process proceeds to step SA5, and a normal payment process with cash is performed. That is, in step SA5, the clerk and the CPU 10
By inputting the amount of money received, calculating and displaying change,
The receipt is printed. After giving the receipt and change to the customer, the clerk finishes the series of operations.

On the other hand, in step SA4, if the customer wishes to make a payment with a prepaid card, the CPU 10 executes step SA6.
Go to.

In step SA6, the store clerk receives the prepaid card from the customer and inserts it into the prepaid card insertion slot 18a. The inserted prepaid card is detected by the photosensor installed in the insertion slot, and the feeder of the magnetic card reader / writer 18 is started by this. While the card is being transported by the feeder, the magnetic head reads the membership number, the issue date, the issue amount, and the balance.
Then, the process proceeds to step SA7.

In step SA7, the payment amount (total purchase amount) is subtracted from the read balance to obtain a new balance. Then, the process proceeds to step SA8.

In step SA8, the CPU 10 determines whether the new balance is positive or zero.

(1) When the new balance is positive or 0 When the new balance is positive or 0, the CPU 10 performs step S
At A9, write the value in the balance.

Then, in step SA10, the corresponding data in the management file is updated. That is, in step SA10, the CPU 10 searches the management file based on the ticket type and issuance date read from the prepaid card, and the content of the collection amount column (collection amount) in the row of the relevant issuance date of the management file. )
Read out. Then, the current payment amount is added to the read recovery amount, and the contents of the recovery amount column are rewritten to the addition result. Along with this, the storage contents of the uncollected amount column and the collected amount column of the management file and the accumulated value column of each uncollected amount are sequentially updated.

Then, the CPU 10 proceeds to step SA11 and updates the balance of the corresponding card data column in the customer file. Further, the CPU 10 updates the contents of the corresponding purchase data column of the customer file, but since this is not directly related to the present application, description thereof will be omitted.

When the CPU 10 completes the update process of the customer file, it reverses the feeder of the magnetic card read / writer to eject the card.

(2) When the new balance is negative When the calculated new balance is negative in step SA8, the CPU 10 proceeds to step SA12, sets the card balance to "0", and replaces the shortfall with a new one. Calculate as payment amount. Then, the process proceeds to step SA13.

In step SA13, the CPU 10 writes "0" in the balance and ejects the card. Then, the process proceeds to step SA14.

In step SA14, the CPU 10 updates the corresponding data in the management file. That is, the balance P read in step SA6 is added to the amount of money collected for the issuance date of the bill type of this card. Along with this, the stored contents of the uncollected amount column, the collected amount column, and the cumulative total column of the uncollected amount column of the management file are sequentially updated. Then, the CPU 10 proceeds to step SA15, updates the purchase data in the corresponding card data column in the customer file, and sets the balance to "0". This allows
The series of processing shown in FIG. 9 ends.

Then, further to step SA5 in FIG. 9, the customer
The shortfall will be settled in cash.

Next, the operation of issuing a prepaid card will be described with reference to FIG.

In this embodiment, the prepaid card issuing (sale) operation is
Although the case is shown where each ECR in the checkout place is shown, the prepaid card is not issued in the ECR in the checkout place, and an ECR dedicated to issuing the prepaid card may be provided in the service counter or the like. Alternatively, a prepaid card automatic ticket issuing machine capable of communicating with the store controller may be arranged in the store so that the customer can operate it by himself to issue the prepaid card.

First, in step SB1, the clerk inputs the type of prepaid card that the customer wishes to purchase (10,000 yen ticket, 5,000 yen ticket, 1000 yen ticket, etc.). As a result, the purchaseable amount of the purchase card is set in the register.

Next, in step SB2, the clerk confirms with the customer whether or not it is a new purchase, that is, whether or not he has an old card.

When the customer purchases the prepaid card for the first time, he / she performs a key operation to input that fact, and in step SB8 described later, the data written on the card, that is, a new number as a member number and a ticket issue date / month are issued. Issued date, type of ticket entered in step SB1),
Further, the amount of money and the balance set in step SB1 are set in the respective registers. In addition, as described above, the newly purchased customer becomes a member by completing the membership application form and submitting it to the store, and the membership number becomes the membership number of this customer. This number is used as a prepaid card management number for customers who do not apply for membership.

On the other hand, if the customer brings in the old card in step SB2, in step SB4 the member number stored from the old card, the balance Po (unused balance of the old card),
The issue date is read.

Then, in step SB5, the management file is updated. That is, the unused balance of the old card is treated as collected at this point. That is, the balance of the old card is added to the collection amount of the old card's type of issue.

Next, in step SB6, the issue amount P is calculated by the sum of the purchaseable amount of the purchase card and the balance Po of the old card. Then, in step SB7, the membership number read in step SB4 as the membership number, the issue date at the time of ticketing (today) as the issue date, the ticket type entered in step SB1 as the ticket type, and the issue amount and balance as step SB6.
The amount calculated in step 1 is set in each register. Then, in step SB8, step SB3 or step SB3
Write the data stored in the register at SB7 to the prepaid card. At the same time, the above data is printed on the prepaid card.

Next, in step SB9, the management file is updated.
That is, the above-mentioned amount P (issued amount of new card) is accumulated in the issued amount of the issue date of the new card type. And step
In SB10, update the card data in the customer file.

Finally, at the end, the store clerk receives the payment from the customer and hands over the issued card.

Here, for monthly update of the management file of the prepaid card, the store controller 1 is equipped with a clock with a calendar function, and every time the month changes, the contents of the management file up to each month are printed in a predetermined format. After that, update processing is performed. In other words, the data of five years have passed is accumulated in the accumulated data of five years or more, and the stored contents are sequentially replaced.

In the above-described embodiment, the prepaid card management file is the case where the issue date, that is, "month" is used as the aggregation unit. However, for example, "week" or "month" is not used as the aggregation unit. "Multiple weeks" can be used as the unit of aggregation, or can be divided into 10-day units such as May 1-10, 1990, May 11-20, 1990, May 21-31, 1990. Also, the same effect can be obtained.

In addition, the prepaid card has a membership number, issuance date, ticket type,
The issue amount and balance are stored, and the same data is stored in the customer file. However, if the store controller 1 does not manage the balance of each prepaid card, it is not necessary to store the card data in the customer file.

Further, in the embodiment, since the prepaid card is also used as the customer management membership card, the membership number is stored in the card. However, when the member card is not used also, it is not necessary to store the member number. Therefore, in order to carry out the present application, when issuing date, balance, and management file for each ticket type are stored in the prepaid card, the ticket type may be stored.

Further, only the membership number (card management number) may be stored in the card, and the ticket type, the issue date and the balance may be stored only in the memory of the store controller 1.

Further, in the embodiment, the management file and the customer file are updated in real time, but processing data for one day may be stored and updated by batch processing when the processing for one day is completed. .

In addition, when reissuing the prepaid card, different cards are used for the new card and the old card,
The old card may be used again. That is,
It becomes a new card by rewriting the memory contents of the old card. In this case, it is conceivable that the display of the card balance can be variably displayed using magnetic or magnetic powder.

[Advantages of the Invention] As described above, according to the present invention, when a new prepaid card is issued, the usable amount of the old prepaid card is accumulated as the collected amount of the issuance period including the issue date of the old prepaid card. At the same time, we added the usable amount of the old prepaid card to the usable amount of the new prepaid card issued this time as the issued amount of the new prepaid card, so add the usable amount of the old prepaid card to the new prepaid card Sales Despite the registration device, the issue amount for each issue period,
Collected amount and uncollected amount can be managed.

Therefore, the uncollected amount of the prepaid card which has passed a certain year from the issuance is required, and this uncollected amount can be processed as a profit, and the accounting processing requirement can be satisfied.

[Brief description of drawings]

FIG. 1 is a block diagram showing a configuration of a store controller type POS system according to an embodiment of the present invention, and FIG. 2 is a block diagram showing an electrical configuration of a store controller applied to the POS system. FIG. 4 is a block diagram showing the electrical configuration of the ECR applied to the POS system, FIG. 4 is a perspective view showing the external configuration of the ECR, and FIG. 5 is a plan configuration of the prepaid card used in the embodiment. 6 is a diagram showing the area structure of the magnetic stripe of the same prepaid card, FIG. 7 is a diagram showing the area structure of the prepaid card management file used in the same embodiment, and FIG. 8 is the same embodiment. Showing the area structure of the customer file used in FIG. 9, FIG. 9 is a flow chart showing the outline of the settlement processing procedure of the embodiment, and FIG. 10 is a flow chart showing the procedure of issuing the prepaid card. It is over door. 1 ... Store controller, 2 ... ECR (prepaid card issuing means), 5 ... Hard disk device (prepaid card management file) (storage means), 10 ... CPU (first accumulating means, second accumulating means) , 15 …… ROM, 16 …… RAM, 18 …… Magnetic card reader / writer, 20 …… Card base, 21 …… Magnetic stripe.

Claims (2)

[Claims] 1. Registering the sale of goods to each customer,
Calculate the total purchase amount of all products sold to the customer, read the usable amount from the prepaid card in which the usable amount that is the amount usable for payment is written,
In the sales registration device that writes the balance paid a part or all of the total purchase amount from the usable amount to the prepaid card as a new usable amount, of the issue amount that is the usable amount when the prepaid card is issued. When the prepaid card is issued, there is a storage means that stores the cumulative value and the cumulative amount of the collected amount of money paid by the prepaid card for each issuance period including the issuance date of the prepaid card for the last certain year. If the customer currently holds a prepaid card, the available amount of the old prepaid card currently held will be added to the usable amount of the new prepaid card issued this time, and the new prepaid card will be issued as a new prepaid card. Prepaid card issuing means to issue cards, At the time of issuing a new prepaid card, the issuance amount of the new prepaid card is added to the issuance amount read out from the storage means corresponding to the issuance period including the issuance date of the new prepaid card, and is added to the storage means. At the same time as storing, the usable amount of the old prepaid card at the time of issuing the new prepaid card is added to the recovery amount read from the storage means corresponding to the issuance period including the issuance date of the old prepaid card. A first accumulating means to be stored in the storage means, and a payment amount read from the storage means corresponding to an issuance period including the issuance date of the prepaid card when paying the total purchase amount of the customer with the prepaid card. To
A second totalizing means for adding a part or all of the total purchase price of all the commodities sold to the customer and storing the result in the storage means. 2. The sales registration device according to claim 1, wherein a membership number is stored in the prepaid card and is also used as a membership card for a customer management system.