JP2004102354A - Household account book system, household account book information converting device and method and recording medium recording the program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a household accounts book system for converting purchase information into information processable by household account book software, and actually realizing the automatic input of the information on the household accounts book software side. <P>SOLUTION: A household account book information converting device 21 of a database center 20 manages a database constituted of a purchase history data storing part 22, a full merchandise data storing part 23, a merchandise basic number information storing part 24 and a household accounts book data storing part 25, and converts purchase information into information for a household accounts book. Furthermore, the household account book information converting device 21 functions as a database server, and executes the download of the household account book information in response to a request from a household accounts book processor 41. <P>COPYRIGHT: (C)2004,JPO

Description

[0001]
TECHNICAL FIELD OF THE INVENTION
The present invention relates to a household account book system that automatically inputs household account book information to a household account book processing device owned by a customer. In addition, the present invention relates to a household account book information conversion device and a household account book information conversion method for converting purchase information regarding a product purchased in a store by a member customer into household account book information suitable for a household account book processing device. In addition, the present invention relates to a recording medium that records a household account book information conversion program for converting purchase information regarding a product purchased in a store by a member customer into household account book information suitable for a household account book processing device.
[0002]
[Prior art]
Software for attaching a household account book on a personal computer, so-called household account book software, has become widely known. By using the preset expense items, the work sheets can be used only with simple correction without creating a worksheet. The user is required to input purchased products and their prices, numbers, and the like, and display these items in, for example, food, miscellaneous goods, and the like. In terms of expenses, there are items such as water supply, light and heat, medical care, and dating. As for income, there are items such as salary and miscellaneous income.
[0003]
In conventional household account book software, the display method of data aggregation and the ease of data entry have been devised, but the data such as the product name, price, and number purchased by the user, for example, using a keyboard or mouse It was common to input using.
[0004]
On the other hand, Japanese Patent Application Laid-Open No. H11-265409 discloses a household account book processing device in which a receipt of an unspecified POS terminal is input as an image and edited and output in a predetermined household account book format. Register the receipt data and the image of the household account book such as a POS terminal and the format of the household account book in the household account book processing device, edit the print of the receipt into the household account book data by referring to the format, and superimpose on the household account book image. It is characterized by outputting.
[0005]
Japanese Unexamined Patent Application Publication No. 11-53650 discloses a receipt electronic mail POS terminal system in which receipt information from a POS terminal is sent to a user as electronic mail, and input to household account book software is automated. The POS terminal reads the mail address or registration ID from the customer with a barcode reader and transmits it to the product management center. At this time, the product, unit price, quantity, and payment and change are sent to the product management center at the time of payment processing. The merchandise management center adds the additional information to the receipt information accumulated up to the payment processing, converts the receipt information into an e-mail by pressing a receipt e-mail conversion key of the POS terminal, and transmits the e-mail to the mail host. The customer receives the receipt email and automatically stores it in the household accounting software.
[0006]
In addition, Japanese Patent Application Laid-Open No. 10-275185 discloses a household account book automatic input system and the like for the purpose of removing the burden of input work to household account book software. This household account book automatic input system allows a user to input, from a user side computer, purchased product specifying information for specifying a product purchased by a consumer, which is printed on a receipt, and a POS database of a store is used by a center computer. To receive the purchased merchandise information corresponding to the purchased merchandise identification information, convert this into data suitable for the user's computer, send it to the user's computer, and perform household account book processing. is there.
[0007]
[Patent Document 1]
JP-A-11-265409
[Patent Document 2]
JP-A-11-53650
[Patent Document 3]
JP-A-10-275185
[0008]
[Problems to be solved by the invention]
However, the household account book processing device disclosed in Japanese Patent Application Laid-Open No. H11-265409 requires an image input device to be connected to read the receipt or the like, resulting in an increase in the size of the device. In addition, it is troublesome to read each receipt or the like by the image input device.
[0009]
Further, in the receipt electronic mail POS terminal system disclosed in Japanese Patent Application Laid-Open No. 11-53650, the contents of the receipt are unclear. Although it is provided as receipt information, it is difficult to categorize categories only with the receipt information, and selection must be made by product name (simplified product names cannot be used). Usually, the product number described on the receipt is mainly for the purpose of sales floor management, and it is impossible to automatically enter the household account book software only with the product name and its number.
[0010]
In any of these two known technologies, in any case, product numbers used in supermarkets and retail stores and posted on receipts are set as categories on the premise of creating a sales floor, so that category classification for household account book classification is performed. It has not been. Therefore, it is difficult for the household account book processing device to automatically input the product number on the receipt. Consumers must perform category classification for each product, and simplification by automatic input is difficult to achieve.
[0011]
Further, in the household account book automatic input system disclosed in the above-mentioned Japanese Patent Application Laid-Open No. 10-275185, the user has to input the purchased product specifying information printed on the receipt from the user-side computer. In addition, the center computer accesses the POS database of the store to receive the purchased product information corresponding to the purchased product specifying information, converts the JAN code into a product classification code, adds it as JAVA applet data, and transmits it to the user side computer. However, the number of JAN codes is enormous, the database becomes huge, and the collation time is required, and conversion to JAVA applet data is not easy. Further, depending on the product, it is not possible to classify, for example, fresh fish, meat, fruits and vegetables, which are said to be three fresh products.
[0012]
The present invention has been made in view of the above-described circumstances, and provides a household account book system that converts purchase information into information that can be handled by household account book software, and enables automatic input on the household account book software side. Aim.
[0013]
Another object of the present invention is to provide a household account book information conversion apparatus and a household account book information conversion method that convert purchase information into information that can be handled by household account book software, and enable automatic input on the household account book software. And
[0014]
In addition, the present invention provides a recording medium that records a household account book information conversion program that converts purchase information into information that can be handled by household account book software, and enables automatic input on the household account book software. Aim.
[0015]
[Means for Solving the Problems]
In order to solve the above-mentioned problems, the household account book system according to the present invention includes a purchase information output terminal device that outputs purchase information on a product purchased by a customer in a store, and the purchase information output terminal device that outputs the purchase information. A first transmission unit for transmitting information, and the purchase information transmitted by the first transmission unit is classified into merchandise classification number information for store use and a household account book which are stored in advance. A household account book information conversion device that converts the household account book information for automatic input while comparing the basic number information, and a second transmission unit that transmits the household account book information converted by the household account book information conversion device; A household account book processing device for automatically inputting the household account book information transmitted by the second transmission means.
[0016]
With such a configuration, the household account book system transmits the purchase information output from the purchase information output terminal device by the first transmission means, and the household account book information conversion device receives the purchase information, and stores the store-use product stored in advance. Since the classification number information and the product basic number information classified into categories for the household account book are compared and converted into household account book information for automatic input, the household account book processing device transmits the household account information to the second transmission. It can be downloaded via means.
[0017]
A household account book information conversion device according to the present invention, in order to solve the above-mentioned problem, in a household account book information conversion device that converts purchase information regarding a product purchased by a customer in a store into household account book information suitable for a household account book processing device. The purchase information is compared with the product classification number information of stores used in advance and the product basic number information that is categorized for the household account book, while comparing the purchase information with the household account book information suitable for the household account book processing device. There is provided household account book information generating means for conversion.
[0018]
With such a configuration, the household account book information conversion apparatus automatically compares purchase information with merchandise basic number information that is categorized for household account book by comparing store-stored merchandise classification number information stored in advance with the household use book. Convert to household account information for input.
[0019]
A household account book information conversion method according to the present invention is a household account book information conversion method for converting purchase information relating to a product purchased by a customer in a store into household account book information suitable for a household account book processing apparatus in order to solve the above-mentioned problem. In the method, the product classification number information corresponding to the purchase information stored in the purchase information storage unit is read from the product classification number storage unit, and the product classification information and the product basic number information stored in the product basic number information storage unit are read. And a household account book information generating step of generating household account book information by comparing
[0020]
The household account book information conversion step compares the purchase information with the previously stored merchandise classification number information for store use and the commodity basic number information categorized for the household account book, and compares the purchase information with the household account book suitable for the household account book processing device. Convert to book information.
[0021]
The recording medium on which the household account book information conversion program according to the present invention is recorded, in order to solve the above-mentioned problem, to convert purchase information regarding a product purchased by a customer in a store into household account book information suitable for a household account book processing device. In the storage medium storing the household account book information conversion program, the product classification number information corresponding to the purchase information stored in the purchase information storage unit is read from the product classification number storage unit, and the product classification information and the product basic number information are stored. A household account book information conversion program including a household account book information generation step of generating household account book information by collating with product basic number information stored in the department is recorded.
[0022]
Therefore, when the computer reads out and executes the household account book information conversion program from the recording medium on which the household account book information conversion program is recorded, the computer apparatus transmits the purchase information to a store-stored product classification number stored in advance. The information can be converted into household account book information suitable for the household account book processing device while collating the information with the product basic number information categorized for the household account book.
[0023]
BEST MODE FOR CARRYING OUT THE INVENTION
Hereinafter, embodiments of a household account book system, a household account book information conversion apparatus and method, and a recording medium that records a household account book information conversion program according to the present invention will be described with reference to the drawings.
[0024]
FIG. 1 shows the configuration of the household account book system. This household account book system can be used by customers such as large-scale stores, supermarkets, and convenience stores. ₁ , 40 ₂ ... 40 _n Household account book processing device 41 owned by ₁ , 41 ₂ ... 41 _n This is a system for automatically inputting household account information to the system.
[0025]
For this reason, the household account book system is ₁ , Supermarket 10 ₂ , Convenience store 10 _m POS (Point of Sales) terminal device 11 as a terminal device for outputting purchase information in each store 10 such as ₁ , 11 ₂ ... 11 _m Is provided. The household account book system is a POS terminal device 11. ₁ , 11 ₂ ... 11 _m Of the purchase information output by the household account book processing device 41 ₁ , 41 ₂ ... 41 _n The database center 20 has a household account book information conversion device 21 that converts the information into household account information suitable for the user. The household account book information conversion device 21 has functions of a database management device and a database server. And the household account book processing device 41 ₁ , 41 ₂ ... 41 _n Automatically inputs the household account book information converted and transmitted by the household account book information converting device 21.
[0026]
In this household account book system, the POS terminal 11 ₁ , 11 ₂ ... 11 _m Output the purchase information, for example, ₁ , 15 ₂ ... 15 _m Is transmitted to the household account book information conversion device 21 in the database center 20. The household account book information converted by the household account book information converting device 21 is stored in a dedicated storage medium 25 (details will be described later), and is downloaded to the household account book processing device 41 via the Internet 30 at the request of the customer 40. You.
[0027]
In other words, the POS terminal device 11 ₁ , 11 ₂ ... 11 _m Is a dedicated line 15 ₁ , 15 ₂ ... 15 _m Thus, each household account book processing device 41 of each customer 40 is connected to the household account book information conversion device 21 via the Internet 30.
[0028]
Large-scale store 10 ₁ , Supermarket 10 ₂ , Convenience store 10 _m Etc. belong to the related company group. Further, the affiliated company group may include retail stores, restaurant stores, banks, and the like. It is assumed that the customer has previously become a member at any of the stores in the related company group when using the household account book system. To become a member, perform the enrollment procedure at the store in advance. Then, a member card 12 such as a magnetic tape type card or an IC card in which a member profile (member information such as attribute information) is recorded is delivered.
[0029]
For example, a large-scale store 10 ₁ Suppose that a member has brought a plurality of products to a cash register in order to purchase the plurality of products. At this time, the membership card 12 ₁ Submit. The cashier in charge of the POS terminal device 11 ₁ A barcode reading unit (barcode reader) described later reads a barcode attached to each product, and performs a barcode registration process as shown in FIG. Then, after performing payment, confirming the payment method, and performing payment processing, the member card 12 ₁ POS terminal device 11 ₁ Read by a card reader connected to. Membership card 12 ₁ , A member number is also recorded as attribute information of the member.
[0030]
Therefore, the POS terminal device 11 ₁ Reads the purchase information from the barcode together with the member number, and outputs this information to the database center 20. The purchase information is raw customer purchase information, and can be described as raw store information or product purchase history information. It is synonymous with receipt data that is printed as a type on the receipt, and is often expressed as purchase information below.
[0031]
Stores 10 of different business types, that is, supermarkets 10 ₂ And convenience store 10 _m POS terminal device 11 installed in ₂ ... 11 _m Has a similar function, reads the purchase information of the product purchased by the member by the barcode cash register processing, and outputs the information to the database center 20 together with the member information read from the member card 12 by the card reader.
[0032]
In the past, a receipt indicating the details of use was issued to the member in order to indicate that the checkout process at the cash register was completed, but in this example, the household account book processing device 41 owned by the member will be described later. Since the household account information is automatically entered, there is no need to issue a receipt. Therefore, the store can reduce receipt issuance and contribute to environmental protection. Of course, a receipt may be issued at the request of the member. Alternatively, receipt data may be input to a membership card or another card-type recording medium.
[0033]
The household account book information conversion device 21 provided in the database center 20 manages a database including a purchase history data storage unit 22, an all-product data storage unit 23, a product basic number information storage unit 24, and a household account data storage unit 25 described later. Then, the purchase information is converted into household account book information. That is, the purchase information is compared with the pre-stored merchandise classification number information of the store use and the merchandise basic number information categorized for the household account book, and is converted into household account book information suitable for the household account book processing device 41. A household account book information generating unit for conversion is provided. Further, the household account book information conversion device 21 functions as a database server, and downloads household account information in response to a request from the household account book processing device 41.
[0034]
The household account book information conversion device 21 stores ₁ , 10 ₂ ... 10 _m Output, and each dedicated line 15 ₁ , 15 ₂ ... 15 _m Receiving the member number and the purchase information transmitted by the user. Then, as shown in FIG. 3, the purchase information is stored in the purchase history data storage unit 22 for each member. The household account book information conversion device 21 also stores the household account information for each member in the household account data storage unit 25 after the purchase information is converted so as to be suitable for the household account processing device 41. The purchase history data storage unit 22 and the household account data storage unit 25 constitute a two-layer dedicated box (BOX) for each member.
[0035]
Since the purchase information is stored in the purchase history data storage unit 22 as it is, there are data of the cash register processing number, the purchase store, the purchase date and time, and the payment method, which can be used as data to be confirmed by the store when the product is replaced. The household account book data storage unit 25 stores data that has been collated with the product basic number. Therefore, an easy-to-use mechanism can be provided.
[0036]
Further, the household account book information conversion device 21 stores in advance the merchandise classification number information used in the store in the merchandise classification number information storage unit (all merchandise data storage units) 23. The product basic number information classified into categories for the household account book is stored in the product basic number information storage unit 24 in advance.
[0037]
The product basic number information is a number setting that clarifies the category of the product used by the current consumer. The merchandise number (sales section number + merchandise number) used by the distribution side has a collation number (specifically, a serial number to be described later) for solving the problem that the category cannot be classified at the time of automatic input of the household account book.
[0038]
The purchase history data storage unit 22, the total product data storage unit 23, the product basic number information storage unit 24, and the household account data storage unit 25 constitute a database, for example, a large-scale capacity formed by connecting a plurality of HDDs. Disk array is used. Of course, an optical disk, a magneto-optical disk, a semiconductor memory, a magnetic tape, or the like may be used as a medium.
[0039]
Then, the household account book information conversion device 21 reads out the product classification number information corresponding to the purchase information stored in the purchase history data storage unit 22 from the product classification number storage unit 23, and reads the product classification number information and the product basic number information. By comparing the product basic number information stored in the storage unit 24 with the purchase information, the purchase information is converted into the household account book information and stored in the household account data storage unit 25. Therefore, the household account book information conversion device 21 functions as a collation system as shown in FIG. This function as the collation system is a part of the function of managing the database. Also, this is a specific example of the household account book information generation unit described above.
[0040]
In addition, the household account book information conversion device 21 arbitrarily or periodically processes the collation of the merchandise classification number information with the merchandise basic number information according to an instruction from a customer. When the processing is performed periodically, a notification of the collation processing is automatically delivered to the computer apparatus serving as the household account book processing apparatus 41 via the Internet 30 by mail. For this reason, the customer can automatically input the household account book information to the household account book processing device when necessary, and can schedule the work for attaching the household account book.
[0041]
The household account book processing device 41 owned by the customer 40 is a desktop or notebook personal computer. After setting up the household account book processing software that has been installed or installed in advance, it is made executable, and it is configured as software by sequentially taking out and executing it by a CPU described later. Dedicated software for household account book is made in cooperation with existing household account book creation software, or various household account book software can be used by a plug-in method.
[0042]
As shown in FIG. 4, the household account book processing device 41 uses a download plug-in for each of the household account book processing software in the customer 40 and uses the plug-in for download to connect to the household account book information conversion device 21. The household account book information is downloaded from the data storage unit 25, and various forms 42 such as a general household account book and a household account book are prepared. Further, it periodically receives a mail transmission requesting a usage history download from a mail server 28 installed in the database center 20 together with the household account book information conversion device 21. Further, another consumption history is manually input to the household account book processing device 41.
[0043]
FIGS. 5 to 7 show the POS terminal device 11, the household account book information conversion device 21, and the household account book processing device 41, each of which has the configuration shown in FIGS. Indicates the format of the information to be performed.
[0044]
First, FIG. 5 shows merchandise sales (purchase) information (a) and member information (b) obtained by bar code registration processing and reading of the membership card 12 by the POS terminal device 11, and (a) and (b). The format of the product purchase history information (c) generated based on the information and output to the database center 20 is shown.
[0045]
The product purchase history information (c) includes, following the member information (b) read from the member card, a sales date and a sales time indicating a purchase date and time, a store code indicating a purchase store, a cash register number indicating a cash register processing number, and a cash register number. The person-in-charge code indicating the person in charge, the receipt number indicating the number of the issued receipt, the department code indicating the number of the sales floor of the product, the single item code (PLU) which is the unique product number indicating the product, the sales amount indicating the amount, and the quantity The sales points, tax classification, discount classification, flags 1, 2, 3, ..., total amount, consumption tax amount, total amount, and payment class are arranged. By treating the discount amount and its name, the cash register processing number, the payment method, and the like as information, automation of household account book sorting can be further improved.
[0046]
Among these, the section code indicating the number of the sales floor of the product and the single item code (PLU), which is a unique number indicating the product, are data for specifying the product, but are arbitrary data different for each store.
[0047]
FIG. 6 shows POS product number information (a), product basic number information (b) sent from the POS data center managing the data of the POS terminal to the database center 20, and the same as FIG. 5 (c). The format of the product purchase history (c) and the household account book information (d) are shown.
[0048]
The product purchase history information (c) shown in FIG. 5 is directly stored in the purchase history data storage unit 22 connected to the household account book information conversion device 21 of the database center 20, as shown in FIG. For example, data is downloaded on a weekly basis. FIG. 6 shows the product purchase history information (c) as it is.
[0049]
The POS product number information (a) stored in the all-product data storage unit 23 indicates a department code indicating a sales floor number of a product in all stores, a single product code (PLU) which is a unique product number indicating a product, and an amount. The sales amount, taxation category, discount category, and payment category are arranged. The term “all stores” refers to all stores in a group company, including stores for each region such as large-scale stores, supermarkets, and convenience stores.
[0050]
The commodity basic number information (b) is classification number information classified into categories for the household account book as described above. For example, large classification codes for large classifications such as food and miscellaneous goods, medium classification codes for classifications such as cereals and seafood in foods, and further classifications such as rice, bread and noodles in cereals. And a product classification code such as glutinous rice and other rice among rice.
[0051]
The household account book information (d) is data suitable for the household account book processing device 41, and is data that the household account information conversion device 41 functions as a collation system and is finally generated. The household account book information (d) includes a sales date and a sales time indicating a purchase date and time, a store code indicating a purchase store, a large classification code, a medium classification code, and a small classification code according to the commodity basic number information (b). A classification code and a product code are arranged, and a sales amount, a sales point, a taxation class, a discount class, flags 1, 2, 3 to, a total amount, a consumption tax amount, a total amount, and a payment class are arranged.
[0052]
FIG. 7 shows household account book information (a) downloaded from the household account data storage unit 25, automatic mail (b) from the mail server 28, other consumption history input information manually, and the household account book processing device 41. The various forms (d) to be created are shown. The household account book information (a) is the same as that already shown in FIG.
[0053]
The household account book processing device 41 automatically inputs the household account book information (a) downloaded from the household account book data storage unit 25 and creates various forms (d) such as a general household account book and a household account book. Further, it periodically receives a mail transmission requesting the use history download from the mail server 28. In the household account book processing device 41, other consumption histories such as income histories, bank use histories, utility bill expenditure histories, and other store expenditure histories can also be manually input.
[0054]
Next, the flow of the household account book information conversion process in the household account book information converter 21 will be described with reference to FIGS. In FIG. 8, purchase history information is stored in the purchase history data storage unit 22 from the POS terminal 10. Then, the household account book information conversion device 21 refers to the POS product number information (a) of all stores stored in advance in the all product data storage unit 23, and obtains arbitrary data different for each store, such as the sales floor of the product. The product identification data consisting of a department code indicating a number and a single item code (PLU), which is a unique number indicating a product, is decoded to obtain decoding information.
[0055]
It is impossible to automatically input to the household account book processing device 41 only with the same decoding information as the POS product number information (a). Therefore, the household account book information conversion device 21 collates the product basic number information stored in advance in the product basic number storage unit 24 with the same decryption information as the POS product number information (a) as shown in FIG. The household account book information (a) is created and stored in the household account book data storage unit 25.
[0056]
The purchase history data storage unit 22 and the household account data storage unit 25 are configured to store the member-specific storage information in a two-layer dedicated box (BOX) for each member as described above.
[0057]
For example, a case where a part of the purchase information stored in the purchase history data storage unit 22 is information as shown in FIG. 9 will be described as a specific example. In this information, the section code “213” indicates the number of the sales floor of the product. Also, the single item code “4951527521362” is a unique product number indicating a product. These are data that specify a product, but are arbitrary data that differs for each store.
[0058]
Therefore, the household account book information conversion device 21 refers to the POS product number information (a) of all the stores stored in the all product data storage unit 23 and decodes different product specifying data for each store. Then, the obtained decryption information is collated with, for example, a commodity basic number table as shown in FIG. 10 for explanation, thereby generating household account book information (d).
[0059]
When the product name “Butter roll” is obtained as decryption information, information matching this “Butter roll” is searched for in the product basic number table, and the information is compared to obtain a large classification code “A” and a middle classification code “ The corresponding serial number [A01-2-1] (the above-described collation information) is obtained from “1”, the small classification code “−2”, and the product classification “01”. Then, as shown in FIG. 6D, this is included in the household account book information.
[0060]
In addition, the matching of the product identification data corresponding to the obtained decryption information with the product basic number table is performed, for example, by using “Butter roll” as an example, with a code converted into a data as a butter roll in the product basic number table. The same code can be prepared in the all-commodity data storage unit 23.
[0061]
As described above, the household account book information conversion device 21 converts the purchase information downloaded from the POS terminal device 10 into household account account information suitable for the household account book processing device 41, generates the information, and stores the generated information in the household account data storage unit 25. .
[0062]
Next, a specific example of the POS terminal device 11 will be described. As shown in FIG. 11, the POS terminal device 11 has a configuration in which a ROM 101, a RAM 104, a display 105, an I / F 106 of various data input units, and a communication port 110 are connected to a CPU 101 via a bus 102. In particular, the POS terminal device 11 is characterized in that a bar code reading unit 108 such as a fixed scanner or a hand scanner is connected to the I / F 106.
[0063]
The barcode that is in-store-marked or source-marked on each product is read by the barcode reading unit 108, and the read information is sent to, for example, a store computer (or POS data center) installed in a store. The store computer or the like searches for the purchase information corresponding to the barcode, and returns the purchase information to the POS terminal device 11. Then, the POS terminal device 11 stores the purchase information for each product in the RAM 104 and transmits the total purchase information together with the member information read from the member card by the card reader 109 through the port 110 and the modem 111. Output to the database center 20 via the dedicated line 15. Of course, the store computer may send the total purchase information together with the member information to a database center. The POS terminal device 11 also includes an operation unit 107 including a numeric keypad. The display device 105 is used to display each product name read by the barcode reading unit 108 and the price each time, or to display the total price.
[0064]
Next, a specific example of the household account book information conversion device 21 will be described. The household account book information conversion device 21 is composed of a computer device as shown in FIG. The configuration is such that a ROM 203, a RAM 204, a display 205, an I / F 206 for data input, an HDD 208, and ports 209 and 211 for communication are connected to a CPU 201 via a bus 202. In addition, the CPU 201 is connected to the purchase history data storage unit 22, the all product data storage unit 23, the product basic number storage unit 24, and the household account data storage unit 25 via the bus 202.
[0065]
The ROM 203 or the HDD 208 stores a household account book information conversion program based on the household account book information conversion method according to the present invention. The CPU 201 functions as a household account book information conversion device by sequentially executing the household account book information conversion program recorded in the ROM 203 or the HDD 208 using the RAM 204 as a work area.
[0066]
The household account book information conversion program includes a purchase information storing step of storing the purchase information in a purchase history data storage unit 22, a product classification number information storing step of storing the product classification number information in advance in an all product data storage unit 23, A commodity basic number information accumulating step of preliminarily accumulating the commodity basic number information in the commodity basic number accumulating section 24; and commodity classification number information corresponding to the purchase information accumulated in the purchase history data accumulating section 22 by the purchase information accumulating step Is read from the all product data storage unit 23 used in the product classification number storing step, and the product classification information and the product basic number information stored in the product basic number storage unit 24 used in the product basic number information storing step are read out. A household account book information generating step of converting and generating the household account book information by comparing Consisting of a household account book information storage step of storing the household account book information forming step is generated household account book data storage unit 25. The detailed processing procedure of this household account book information conversion program will be described later with reference to FIG.
[0067]
A modem 210 is connected to the port 209, and is used to receive the purchase information output from the POS terminal 11 or the like through a dedicated line. In addition, a modem 212 is connected to the port 211 and connected to the Internet 30. Thereby, the household account book information is downloaded from the household account book data storage unit 25 by the household account book processing device 41 via the Internet 30.
[0068]
Next, a specific example of the household account book processing device 41 will be described. The household account book processing device 41 is composed of a computer device as shown in FIG. The configuration is such that a ROM 403, a RAM 404, a display 405, an I / F 406 for data input, an HDD 408, and a port 409 for communication are connected to a CPU 401 via a bus 402.
[0069]
The ROM 403 or the HDD 408 records household account book software for causing the computer device to function as the household account book processing device 41. The CPU 401 sequentially executes household account book software recorded in the ROM 403 or the HDD 408 using the RAM 404 as a work area.
[0070]
A modem 410 is connected to the port 409, and is connected to the Internet 30. Thereby, the household account book information is downloaded from the household account book data storage unit 25 to the household account book processing device 41 via the Internet 30.
[0071]
Next, FIG. 14 shows a processing procedure of the household account book information conversion device 41. 13 is a processing procedure of a household account book information conversion program executed by the CPU 201 of the computer device shown in FIG.
[0072]
First, in step S1, the purchase information downloaded from the POS terminal device 11 is stored in the purchase history data storage unit 22. This download may be performed weekly or daily.
[0073]
In step S2, the CPU 201 determines whether or not there has been any instruction from the customer (member) to process the unprocessed purchase information and convert it to household account information. If it is determined that the instruction has been received from the customer, the process proceeds to step S3.
[0074]
In step S3, the CPU 201 sequentially executes the household account book information conversion program, compares the product classification number information corresponding to the purchase information with the product basic number information, and generates household account book information. Then, in step S4, the household account book information is stored in the household account book data storage unit 25.
[0075]
If it is determined in step S2 that there is no instruction from the customer, the process proceeds to step S5, and it is determined whether a predetermined period, for example, one week has elapsed. This is because the household account book information is periodically generated. By proceeding to step S3, household account book information is generated. When the household account book information is periodically generated, a notification that the household account book information has been generated by performing the matching process is sent through the mail server 28.
[0076]
Further, when the processed information (household account book information) is not downloaded, it may be periodically notified by e-mail.
[0077]
As described above, the household account book information conversion device 21 converts the purchase information downloaded from the POS terminal device 11 so as to be suitable for the household account book processing device 41, and then converts the household account information for each member into the household account data. It can be stored in the storage unit 25.
[0078]
In addition, the household account book system including the household account book information conversion device 21 uses the household account book processing device 41 to download the household account book information converted by the household account book information conversion device 21 from the household account book information storage unit 25. be able to. Since the household account book information has been converted so as to be suitable for the household account book processing device 41, it can be automatically input.
[0079]
In the household account book system, the member can access the database center 20 and check the purchase history directly from the purchase history data storage unit 22. Of course, the purchase history can be confirmed from each store to the purchase history data storage unit 22. It can be used as data that the store confirms when replacing products.
[0080]
In the household account book system, a large-scale store 10 ₁ , Supermarket 10 ₂ , Convenience store 10 _m In this case, household account information was automatically entered by members of stores belonging to a related company group, but if a bank that handles Internet banking belongs to the related company group, the bank usage history Can be reflected in the household account book system and automatically input to the household account book processing device 41. Internet banking is the operation of a bank through the Internet. A bank function is set up on the Internet homepage, and users can receive financial services such as balance inquiry, various payments, account transfer, and loan application from a personal computer or mobile terminal without going to a bank.
[0081]
If a bank belongs to the affiliated company group and the member uses Internet banking, a special financial membership system can be set as an optional service. For example, a loan for individuals can be made with a special privilege. Specific examples of the special preferential treatment include an increase in the loan amount, a temporary suspension of payment, and a reduction in the interest rate depending on the usage amount. Of course, these special offers are available to members using the household account system.
[0082]
To increase the loan amount is to increase the amount of the target loan in addition to the normal assessment (the conventional assessment). The temporary payment suspension measure is a measure to temporarily suspend the payment of a loan when the member or his / her family becomes ill, restructured, or injured by the head of the household or family. The interest rate reduction based on the usage amount is a system in which the loan interest rate is reduced according to the annual fee amount of each store using the household account book system within the related symbol group.
[0083]
Further, preferential services for various purpose loans can be provided by a household account statement prepared by the household account system. The household account statement is submitted as loan application material. Using the main items of consumption such as income, food expenses, rent, utilities, household goods, etc. as materials, we can provide new services that provide preferential treatment for personal loans from the balance sheet. The reliability is high because not only the applicant's declaration but also the details of the expenditure can be compared with the database center.
[0084]
Further, in addition to the membership card, a family card for the family can be issued, and the shopping, payment, and the like by the family in a store, a bank, and the like in the related company group can be reflected in the household account book system. The issuance of a family card also enables a nutrition diagnosis of the whole family based on the purchased food on the Internet.
[0085]
As described above, according to the household account book system, in general retail stores, department stores, supermarkets, restaurants, and the like, instead of issuing receipts indicating usage details, the use history to the database center using the Internet or the like. Is stored, and this is automatically input to the household account book processing device owned by the member or the user by the household account information conversion device.
[0086]
In addition, in order to automate the input to the household account book processing device, a basic number for each category is newly created that matches consumer life. With regard to the usage history stored in the database center, the product numbers arranged by distribution company and the basic numbers by category are collated and processed, and the product purchase information (product purchase history) categorized into categories is provided to members and users. To download and use it to automatically input to the household account book processing device.
[0087]
Further, members and users can use this household account book system to prepare a household financial statement and use it as application materials for various personal loans.
[0088]
Therefore, the household account book system of the present invention aims to reduce issuance of receipts used in general retail stores, department stores, supermarkets and restaurants, contribute to environmental protection, and digitize the consumption history of consumers, and This will dramatically improve processing and create and submit a new household account statement to encourage consumers to use personal loans.
[0089]
In the household account book system, members of stores belonging to the affiliated company group are required to automatically input the household account information. Up to this point, stores of different business types may be targeted.
[0090]
In this case, each store contracts with the database center to prepare a connection environment to the household account book system. The structure shown in FIG. 1 can be applied to the structure of the household account book system. Of course, it is necessary to store in advance the POS product number information of each store, which differs from store to store, in the all product data storage unit 23 connected to the household account book information conversion device 21 in advance.
[0091]
This household account book system can also reduce receipt issuance, contribute to environmental protection, digitize the consumption history of consumers, and dramatically improve household account book processing. In addition, each store can collect customers by using the connection to the household account book system as a selling point.
[0092]
In the household account book system, the first transmission means is, for example, a dedicated line, but may be a general public line or the Internet. Further, the second transmission means may be another personal computer communication network. In addition, the household account book processing device is configured by the computer device executing the household account book processing program, but may be another information processing device, for example, a personal digital assistant (PDA). Further, it may be a mobile phone device.
[0093]
【The invention's effect】
In the household account book system according to the present invention, the purchase information output by the purchase information output terminal device is transmitted by the first transmission means, and the household account information conversion device receives the information and stores the merchandise classification number stored in the store in advance. Since the information is converted into household account information for automatic input while comparing the information with the product basic number information classified into categories for the household account book, the household account book processing device transmits the household account information to the second transmission means. Via the Internet, thus enabling automatic input.
[0094]
The household account book information conversion device according to the present invention, the purchase information, while comparing the previously stored merchandise classification number information for store use and the commodity basic number information categorized for household account book, while automatically inputting To manage the database, and use the usage history etc. stored in each storage means to collate and process the product numbers organized by distribution company with the basic numbers by category while managing the database. The member and the user are allowed to download and use the product purchase information (product purchase history) classified into the category, thereby enabling automatic input to the household account book processing device.
[0095]
In the household account book information conversion method according to the present invention, in the household account book information conversion step, the purchase information is converted into pre-stored merchandise classification number information for store use and merchandise basic number information categorized for the household account book. Since the information is converted into household account book information suitable for the household account book processing device while collating, the product numbers arranged by distribution company using the usage history and the like stored in each storage means while managing the database, and this category Different basic numbers are collated and processed, and product purchase information (product purchase history) classified into categories is downloaded and used by members and users, thereby enabling automatic input to the household account book processing device.
[0096]
The recording medium storing the household account book information conversion program according to the present invention reads out from the article classification number storage unit the article classification number information corresponding to the purchase information stored in the purchase information storage means in the household account book information generating step. Since a program for converting and generating household account book information by comparing this product classification information with the product basic number information stored in the product basic number information storage unit is recorded, while managing the database, Using the usage histories and the like stored in each storage unit, the product numbers arranged for each distribution company are compared and processed with the basic numbers for each category, and the product purchase information (product purchase history) classified into categories is added to the members. It is possible to cause a computer device to execute a process that allows a user to download and use the data to automatically input to a household account book processing device.
[Brief description of the drawings]
FIG. 1 is a diagram showing a configuration of a household account book system.
FIG. 2 is a diagram for explaining processing in a POS terminal device.
FIG. 3 is a diagram for explaining processing in the household account book information conversion device.
FIG. 4 is a diagram for explaining processing in the household account book processing device.
FIG. 5 is a format diagram of information exchanged between a POS terminal device and a peripheral portion thereof.
FIG. 6 is a diagram showing a format of information exchanged between the household account book information conversion device and a peripheral portion thereof.
FIG. 7 is a diagram showing a format of information exchanged between a household account book processing device and a peripheral portion thereof.
FIG. 8 is a diagram illustrating a process of converting household account information.
FIG. 9 is a diagram showing a specific example of purchase information.
FIG. 10 is a diagram showing a product basic number table.
FIG. 11 is a block diagram illustrating a configuration of a POS terminal device.
FIG. 12 is a block diagram illustrating a configuration of a household account book information conversion device.
FIG. 13 is a block diagram illustrating a configuration of a household account book processing device.
FIG. 14 is a flowchart showing a processing procedure of the household account book information conversion device.
[Explanation of symbols]
10 stores, 11 POS terminal devices, 12 membership cards, 15 dedicated lines, 20 database centers, 21 household account information conversion devices, 22 purchase history data storage units, 23 all product data storage units, 24 product basic number information storage units, 25 Household account data storage unit, 30 Internet, 40 customers, 41 Household account processor

Claims (10)

A purchase information output terminal device for outputting purchase information on products purchased by the customer in the store;
First transmission means for transmitting the purchase information output by the purchase information output terminal device;
Automatically inputting the purchase information transmitted by the first transmission means, while comparing previously stored merchandise classification number information for store use and merchandise basic number information categorized for a household account book. Household account book information conversion device for converting into household account book information for
Second transmission means for transmitting the household account book information converted by the household account book information conversion device,
A household account book processing device for automatically inputting the household account book information transmitted by the second transmission means. The household account book information conversion device includes a purchase information storage unit for storing the purchase information transmitted by the first transmission unit and a household account book information storage unit for storing the household account information, which are exclusively used for a two-layer customer. The household account book system according to claim 1, wherein the household account book system is provided as storage means. The household account book information conversion device further includes a product classification number information storage unit that stores the product classification number information in advance, and a product basic number information storage unit that stores the product basic number information in advance. 3. The household account book system according to claim 2, wherein: The household account book information conversion device reads out, from the product classification number storage unit, product classification number information corresponding to the purchase information stored in the purchase information storage unit, and stores the product classification number information and the product basic number information storage unit. 4. The household account book system according to claim 3, wherein the purchase information is converted into the household account book information by comparing the product basic number information stored in the household account number information. In a household account book information conversion device that converts purchase information about a product purchased by a customer in a store into household account book information suitable for a household account book processing device,
The purchase information is converted into the household account book information suitable for the household account book processing device, while comparing previously stored merchandise classification number information for store use and commodity basic number information categorized for the household account book. A household account book information converting device, comprising: 6. The household account book information conversion device according to claim 5, further comprising a purchase information accumulating unit that accumulates the purchase information and a household account information accumulating unit that accumulates the household account information, as a customer-only accumulating unit having a two-layer structure. . 7. The apparatus according to claim 6, further comprising: a merchandise classification number information storing unit that stores the merchandise classification number information in advance; and a merchandise basic number information storing unit that stores the merchandise basic number information in advance. Household account book information conversion device. The household account book information generating means reads out the product classification number information corresponding to the purchase information stored in the purchase information storage means from the product classification number storage means, and stores the product classification number information and the product basic number information storage means. 8. The household account book information conversion device according to claim 7, wherein said purchase information is converted into said household account book information by checking the product basic number information stored in said household account information. In a household account book information conversion method for converting purchase information regarding a product purchased by a customer in a store into household account book information suitable for a household account book processing device,
The product classification number information corresponding to the purchase information stored in the purchase information storage unit is read from the product classification number storage unit, and the product classification information is compared with the product basic number information stored in the product basic number information storage unit. A household account book information converting method for generating household account book information. In a recording medium recording a household account book information conversion program for converting purchase information regarding a product purchased by a customer in a store into household account book information suitable for a household account book processing device,
The product classification number information corresponding to the purchase information stored in the purchase information storage unit is read from the product classification number storage unit, and the product classification information is compared with the product basic number information stored in the product basic number information storage unit. A recording medium characterized by recording a household account book information conversion program including a household account book information generating step of generating household account book information by doing so.

Images