JP2005107702A - Accounting support device - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide an accounting support device capable of preventing operation error while saving labor of a store staff of a service business, capable of accurately calculating a fee in accounting, and capable of flexibly corresponding to complicated rates. <P>SOLUTION: A composition has an input means for inputting information relevant to an original room and a destination room for providing service, service information relevant to services to be provided to a customer, and a customer attribute relevant to the customer, a fee database storing a fee table showing fees of services responding to the customer attribute, a time zone, and each room, a record generating means for generating a record showing a fee per predetermined unit time from the start time to the completion time of provision of the services on the basis of the input information inputted by the inputting means and the fee table, and a sum up means for summing up fees from the start time until the completion time of provision of the services at payment when rooms have been changed during a service provision time on the basis of the record generated by the record generating means. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

  The present invention relates to an accounting support apparatus, and more particularly to an accounting support apparatus that supports calculation of charges at the time of accounting in accordance with various charge systems in an amusement facility or the like.

  In recent years, in service industries such as entertainment facilities (karaoke shops), restaurants, hotels, etc., services based on various sales conditions and sales forms are provided to customers in order to acquire customers. In particular, in a karaoke shop service that requires management for each individual room, the charge may differ depending on the room price, the food and drink price, the day of the week, the time zone, and the sex. Further, there is a POS (Point Of Sales) system that is used at the time of accounting in such a service industry. Many large-scale restaurants accept orders from customers using a handy terminal, and when a customer performs accounting, a method of calculating a charge for an order received at a POS terminal is used. In addition, barcodes may be used for retailing merchandise, or store staff may receive handwritten orders and calculate charges using a POS terminal manually.

  Further, as a conventional technique, there is a panel display method for a product order POS terminal that displays only a menu that is currently used in a store whose menu configuration changes according to a time zone (for example, Patent Document 1).

  In addition, there is a fee collection device for pay rental rooms such as paid karaoke rooms, rental rooms, changing rooms, shower rooms, toilets, and the like that settles charges when entering and leaving the room (for example, Patent Document 2).

For the purpose of grasping the usage status of multiple sections such as hotel rooms, as described in paragraph [0036], the original guest room and the changed guest room are linked to the original guest room by dragging and dropping. There is a usage management system that reassociates information about a guest stayed with a guest room after the change (for example, Patent Document 3).
Japanese Patent Laid-Open No. 10-63955 JP-A-9-212696 Japanese Patent Laid-Open No. 9-153089

  However, in the conventional POS system, an order received from a customer by a store staff is input from a handy terminal. However, a plurality of buttons (for example, “beer (˜18: 00) economy”, “beer ( 18: 00-) Economy "," Beer (~ 18: 00) First Class "," Beer (18: 00) First Class ", etc.), the store staff will use the product name and POS operation It took a long time to memorize, and it was easy to make mistakes.

  In addition, when a customer accounts at a karaoke store, the store staff must calculate the room used by the customer, the start and end times, and the total price of the ordered products. Depending on the time of year, the price setting may be different, or the room may be changed to a room with a different price on the way.Therefore, it is difficult for the staff to grasp all the price systems and accurately reflect them in the price. It was.

  In addition, at a conventional karaoke shop, regardless of the number of customers, every hour when the room is used and food and beverage charges are charged as charges, but if one of the customers leaves the room on the way, another customer will leave the room at a later date There is a problem that it is difficult for the store side to request payment of the correct fee to the person leaving the room, or when paying when leaving the room by estimating the fee to be paid from the stay time . Depending on the store, the room charge varies depending on the time of day, and the calculation at the time of accounting is difficult.

  In addition, if a customer requests to move to another room, such as a large room or a beautifully decorated room, while using a given room, he / she pays the fee for the room once used and checks in a new room again. There was a problem that work had to be done and the labor was complicated. In addition, there is a problem that the customer escapes without paying a fee when changing the room.

  SUMMARY OF THE INVENTION Accordingly, an object of the present invention is to provide an accounting support apparatus that saves labor of store staff in the service industry, prevents operation errors, can accurately calculate charges during accounting, and can flexibly cope with complicated charge settings Is to provide.

  In order to solve the above problems, the present invention provides an input means for inputting information about an original room providing a service and a destination room, service information about a service provided to a customer, and customer attributes about the customer. Providing the service based on the charge database storing the charge table indicating the charge of the service corresponding to the customer attribute, the time zone, and each room, the input information input by the input means, and the charge table Record generating means for generating a record indicating a charge per predetermined unit time from the start time to the end time, and when the room is moved within the service providing time based on the record generated by the record generating means, And a totaling means for accumulating charges from the service provision start time to the end time.

  In such an accounting support apparatus, information relating to an original room providing a service and a destination room, service information relating to a service provided to a customer, and customer attributes relating to the customer are input, and the input information and customer attributes are input. Based on these records, a record indicating a charge for each predetermined unit time from the service provision start time to the end time is generated based on the charge table indicating the charge of the service corresponding to the time zone and each room. When the room moves within the service provision time, by accumulating the fee from the service provision start time to the end time at the time of accounting, it saves the trouble of the store staff of the service industry and prevents operation mistakes, and accurately charges at the time of accounting Can be calculated flexibly to cope with complicated pricing.

  In order to solve the above problems, the present invention may be a program for causing a computer to perform the accounting support method and the accounting support method.

  In such an accounting support apparatus, information related to an original room providing a service and a destination room, service information related to a service provided to a customer, and customer attributes related to the customer are input, and the input information and customer attributes are input. Based on these records, a record indicating a charge for each predetermined unit time from the service provision start time to the end time is generated based on the charge table indicating the charge of the service corresponding to the time zone and each room. When the room moves within the service provision time, by accumulating the fee from the service provision start time to the end time at the time of accounting, it saves the trouble of the store staff of the service industry and prevents operation mistakes, and accurately charges at the time of accounting Can be calculated flexibly to cope with complicated pricing.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings. FIG. 1 is a system configuration diagram of an accounting support apparatus according to a first embodiment of the present invention. In FIG. 1, a POS terminal 10 which is an example of an accounting support apparatus of the present invention is provided in a store such as a karaoke store, and a room for providing services to customers, for example, a karaoke device capable of singing music is provided. This is a device for calculating a charge for each usage time of an installed room and a charge for a product (menu) ordered by a customer at the time of accounting. The POS terminal 10 mainly uses a main processing unit 5 that manages room entry and exit and accounting processing, an associated master table 70 that stores information necessary for room management and accounting processing, and rooms. And an associated log table 60 that stores accounting information calculated based on history information.

  The POS terminal 10 has the following components controlled by a CPU (Central Processing Unit). When a program for realizing the accounting support method of the present invention is recorded in an auxiliary storage device (not shown) and processing in an accounting support method described later is started, the program is executed according to the program stored in the auxiliary storage device. The CPU starts the process using the internal work table 50.

  The main processing unit 5 refers to the information in the related master table 70 and the related log table 60 and executes processing such as calculation of charges at the time of accounting by the following processing units. The main processing unit 5 includes a new entry processing unit 21 that performs registration and other processing when a new customer enters the room, an exit processing unit 25 that performs room exit processing, and a process when the customer is in the room. The in-room processing unit 30, the menu unit price acquisition processing unit 40 that acquires the unit price of the menu ordered by the customer, and the in-program work used as a work table when the main processing unit 5 executes the program Table 50. The in-room processing unit 30 includes an intermediate processing unit 31 that performs processing when a customer enters the room being used from the middle, an extension processing unit 32 that performs processing when the use of the room is extended, A midway exit processing unit 33 that performs processing when a customer leaves, a room movement processing unit 34 that performs processing during room movement, a food order registration processing unit 35 that performs registration processing of orders from customers, and customer input And a number-of-persons change processing unit 36 for changing the number of people by leaving the room.

  The related master table 70 stores a menu master DB 71 storing information about menus, a menu unit price acquisition master DB 72 storing information when menu unit price acquisition is performed, and information about daily charge categories. The daily charge classification master DB 73, the daily charge master DB 74 storing information related to daily charges, the room pattern master DB 75 storing information related to the patterns of each room, and information related to each room are stored. It has a room master DB 76 and a member master DB 77 in which information about members is stored.

  The related log table 60 includes an order (header) DB 61 that stores information on orders (rooms) from customers, an order (details) DB 62 that stores information on orders (menus) from customers, and the usage status of rooms. And a room information DB 63 in which information on the history of the room is stored.

  The table items stored in the menu master DB 71 are shown in FIG. 7, the table items stored in the menu unit price acquisition master DB 72 are shown in FIG. 8, and the table items stored in the daily charge category master DB 73 are shown in FIG. 10 shows the table items stored in the daily charge master DB 74 in FIG. 11, FIG. 9 shows the table items stored in the room master DB 76, and shows the table items stored in the member master DB 77. 12 shows the table items stored in the room information DB 63 in FIG. 13, the table items stored in the order (header) DB 61 in FIG. 14, and the table stored in the order (detail) DB 62. The items will be described in detail with reference to FIG.

  For example, when a customer newly uses a room, the store staff registers information about the room to be newly entered and the customer from a screen displayed on a display device such as a display of the POS terminal 10. At this time, the new entry processing unit 21 refers to the related master table 70 and stores the registered new entry information in the related log table 60.

  When the customer enters the room after the new room entry process, the midway entry processing unit 31 updates information stored in the related log table 60, for example, the number of people in the room. Similarly, when the customer leaves the room on the way, the halfway leaving processing unit 33 updates the information stored in the related log table 60. In addition, when the customer moves the room, the room movement processing unit 34 registers information about the room before and after the movement in the related log table 60 and information about the advance when the advance is collected at the time of moving the room. To do. When there is an order from the customer in the room while using the former room, the food order registration processing unit 35 registers the room in which the order has been placed, order information, and the like in the related log table 60. Further, when there is a change in the number of people when entering or leaving the room or moving the room, the number of people change processing unit 36 registers the changed number of people in the related log table 60.

  Thereafter, when all of the customers who have used the room leave the room, the leaving processing unit 25 stores information related to leaving the room in the related log table 60. At the time of customer accounting, the leaving processing unit 25 calculates a fee based on the information stored in the related log table 60, and the calculated total fee is output from the POS terminal 10 to a receipt. The receipt output will be described in detail with reference to FIGS.

  In this way, the room entry / exit processing, room movement processing, order registration processing, etc. are performed at the POS terminal 10 and the processing result is stored in the related log table 60, and the charge is calculated at the time of accounting based on the related log table 60. This eliminates the trouble of store staff and prevents operation mistakes, and can accurately calculate charges even when the room charge varies depending on the time of day or when the customer enters or leaves the room. It is possible to respond flexibly to pricing.

  Next, the screen transition displayed on the POS terminal 10 in the new room entry process will be described. In addition, a touch panel is used for the screen display of the POS terminal 10 installed at the front of the karaoke store, and the operator selects the display portion by touching the screen. FIG. 2 is a diagram showing a main screen displayed on the POS terminal in the new room entry process. A screen 200 shown in FIG. 2 is a main screen displayed in the new room entry process by the new room entry processing unit 21. Registered on the screen 200 are a display area 201 that shows the date and time displayed on the screen and the charge system information at that date, a display area 202 that displays the number of multiple rooms, the number of people restricted, and the usage status, and a new entry. A new entry button 204 is displayed. For example, when the display area 203 indicating the room number “Room 1 D” in the display area 202 is confirmed to be vacant, this room is selected (shaded display) and the new entry button 204 is touched. The new room entry processing unit 21 acquires the room pattern stored in the room master DB 76 from the room number and displays the screen shown in FIG.

  FIG. 3 is a diagram showing a room entry processing screen displayed on the POS terminal. A screen 206 shown in FIG. 3 shows an entrance processing screen for the room selected on the main screen 200. The screen 206 includes a date and time displayed on the screen, a display area 207 indicating charge system information and an input person in charge at the date and time, a display area 208 indicating an entry state (entrance mode) “new entry”, and information on customers. A display area 209 indicating information about the selected room, a display area 210 indicating charge information (accounting information) such as a room usage fee, a cancel button 211 for canceling information displayed on the screen or the screen, and a screen A confirmation button 212 to be selected when the information is confirmed is displayed. For example, by entering a member number in the customer information in the display area 209 and selecting the confirmation button 212, the new room entry processing unit 21 acquires and displays detailed member information from the member master DB 77. In addition, the charge category, the number of men or women, and the usage time are entered in the entry information of the display area 209, and the menu number (hereinafter referred to as “No”), the number of men, the number of women, the use start time, and the use end time are entered. Confirm. After each item in the display area 209 is confirmed, the charge calculation result is displayed in the display area 210. As described above, when information related to a new room is input in the display area 209, the charge information displayed in the display area 210 is confirmed, and the confirmation button 212 is selected, the screen shown in FIG. 4 is displayed.

  FIG. 4 is a diagram showing a main screen after the new room entry process displayed on the POS terminal. A screen 215 shown in FIG. 4 shows the main screen after being set on the room entry processing screen 206. Registered on the screen 215 are a display area 216 that shows the date and time displayed on the screen and the charge system information at that date, a display area 217 that displays the number of multiple rooms, the number of people restricted, and the usage status, and a mid-room entry. A midway entry button 218 for registering an order, an order button 219 for registering an order, a midway exit button 220 for registering midway exit, and an exit button 221 for registering exit are displayed. For example, in the display area 222 indicating the room number “Room 1 D” in the display area 217, the new room entry is registered, so the usage time “15:20 to 17:20” and the remaining time “120 (minutes)”. , The number of people “4” and the usage status “in use” are displayed.

  In this way, new entry is easily registered according to the screen displayed on the POS terminal 10, and the new entry processing unit 21 of the POS terminal 10 calculates the reference with reference to the related master table 70 and the related log table 60. Displayed charges can be displayed.

  Next, the new room entry process will be specifically described. FIG. 5 is a flowchart of the new room entry process. In FIG. 5, first, in the process of step S <b> 10, the main screen is displayed on the POS terminal 10 by the new room entry processing unit 21, and a room is selected from the main screen. In the process of step S11, a new entry processing screen relating to the room selected by the new entry processing unit 21 is displayed. In step S12, the new entry processing unit 21 extracts the member information stored in the member master DB 77 from the member number input on the new entry processing screen, and determines the member classification. In step S13, the new room entry processing unit 21 extracts a menu charge from the menu master DB 71 from the charge category code input on the new room entry processing screen, and determines the menu number. In step S14, the new room entry processing unit 21 determines the number of males input on the new room entry process screen. In step S15, the new room entry processing unit 21 determines the number of women input on the new room entry process screen. In the process of step S <b> 16, the new room entry processing unit 21 determines the room entry time from the current time measured by the POS terminal 10. In step S <b> 17, the new room entry processing unit 21 determines the room exit time from the use time input on the new room entry process screen. In the process of step S18, the new room entry processing unit 21 performs a process of creating a new room entry (charge information) based on the confirmed information. This new room entry process will be described in detail with reference to FIG. In step S19, the new room entry processing unit 21 updates the room information table stored in the room information DB 63 from the created new room entry details. When the main screen including the new entry details updated by the new entry processing unit 21 is displayed in the process of step S20, the room information table stored in the room information DB 63 is updated as the new entry is confirmed.

  In this way, necessary information is entered from the screen to create a new room description, which is managed by the room information DB 63, thereby saving labor of the karaoke shop staff and preventing operation errors, and accurately at the POS terminal 10 at the time of accounting. Charges can be calculated, and complex charge settings can be flexibly handled.

  Next, the new room entry creation process shown in step S18 of FIG. 5 will be described. FIG. 6 is a diagram showing a flowchart of the new entry details creation process. In FIG. 6, first, in the process of step S <b> 25, the new room entry processing unit 21 sets the use time input on the new room entry process screen as the remaining use time. In the process of step S26, the new room entry processing unit 21 repeatedly performs the subsequent processes (steps S27 to S39) until the remaining usage time becomes zero. In step S27, the new room entry processing unit 21 determines whether or not the number of repetitions is the first time. When the number of repetitions is the first time in the process of step S27, the new room entry processing unit 21 repeats the subsequent processes (steps S29 to S32) twice in the process of step S28. In step S29, the new room entry processing unit 21 determines whether or not the number of repetitions is the first time. If the number of repetitions is the first time in the process of step S29, the new room entry processing unit 21 acquires the male unit price for the reference time (60 minutes) from the menu unit price acquisition master DB 72 in the process of step S30. If the number of repetitions is not the first time in the process of step S29, the new room entry processing unit 21 acquires the unit price of the woman for the reference time (60 minutes) from the menu unit price acquisition master DB 72 in the process of step S31. After acquiring each unit price in steps S30 and S31, in the process of step S32, the new room entry processing unit 21 adds a detail record with branch number 1 to the order (detail) DB 62. In the process of step S38, the new room entry processing unit 21 repeats the process from step S27 until the remaining use time becomes 0 with the time obtained by subtracting 60 minutes from the remaining use time as the remaining use time.

  If the number of repetitions is not the first time in the process of step S27, the new room entry processing unit 21 repeats the subsequent processes (steps S34 to S37) twice in the process of step S33. In step S34, the new room entry processing unit 21 determines whether or not the number of repetitions is the first time. When the number of repetitions is the first time in the process of step S34, the new room entry processing unit 21 acquires the male unit price for the additional time (30 minutes) from the menu unit price acquisition master DB 72 in the process of step S35. If the number of repetitions is not the first time in the process of step S34, the new room entry processing unit 21 acquires the unit price of the woman for the additional time (30 minutes) from the menu unit price acquisition master DB 72 in the process of step S36. After acquiring each unit price in steps S35 and S36, in the process of step S37, the new room entry processing unit 21 adds a detail record with branch number 1 to the order (detail) DB 62. In the process of step S39, the new room entry processing unit 21 repeats the process from step S27 until the remaining usage time becomes 0 with the time obtained by subtracting 30 minutes from the remaining usage time as the remaining usage time. In the process of step S <b> 40, the new room entry processing unit 21 stores a header record with branch number 1 in the order (header) DB 61.

  In this way, charges for new entry registration are accumulated every 60 minutes, every 30 minutes, and by gender, and the order (header) DB 61, order (details) are used as accounting information for calculating the charges at the time of accounting. By storing it in the DB 62 and the room information DB 63, it is possible to save trouble of the store staff of the service industry, prevent an operation error, accurately calculate the fee at the time of accounting, and flexibly deal with complicated fee setting. .

  Next, basic items of the tables stored in each DB of the related master table 70 will be described. FIG. 7 is a diagram showing a table stored in the menu master DB. A table 710 shown in FIG. 7 is a table stored in the menu master DB 71, and stores information related to menus of services provided to customers. The table 710 includes items indicating menu numbers, items indicating menu names, items indicating menu unit prices, and the like.

  FIG. 8 is a diagram showing a table stored in the menu unit price acquisition master DB. A table 720 shown in FIG. 8 is a table stored in the menu unit price acquisition master DB 72 and stores information for each menu No. The table 720 includes an item indicating the menu No., an item indicating the daily charge category, an item indicating the room pattern, an item indicating the application start time of the menu, an item indicating the application end time of the menu, It consists of a male flag item indicating a male target menu, a female flag item indicating a female target menu, an item indicating a member classification, an item indicating a menu unit price, and the like.

  FIG. 9 is a diagram illustrating a table stored in the room master DB. A table 760 shown in FIG. 9 is a table stored in the room master DB 76, and stores detailed information on each room. The table 760 includes items indicating room codes, items indicating room patterns, items indicating room names, and the like.

  FIG. 10 is a diagram showing a table stored in the daily charge category master DB. A table 730 shown in FIG. 10 is a table stored in the daily fee category master DB 73, and stores information on the daily room fee. The table 730 includes items indicating daily charge codes, items indicating daily charge names, and the like.

  FIG. 11 is a diagram showing a table stored in the daily charge master DB. A table 740 shown in FIG. 11 is a table stored in the daily charge master DB 74, and stores detailed information on daily charges. The table 740 includes items indicating business days, items indicating daily charge codes, and the like.

  FIG. 12 is a diagram showing a table stored in the member master DB. A table 770 shown in FIG. 12 is a table stored in the member master DB 77 and stores member information. The table 770 includes an item indicating a member number, an item indicating a member name, an item indicating a member classification, and the like.

  Next, basic items of the table stored in each DB of the related log table 60 will be described. FIG. 13 is a diagram illustrating a table stored in the room information DB. A table 630 illustrated in FIG. 13 is a table stored in the room information DB 63, and stores a room entry history for each room. The table 630 includes an item indicating a room code, an item indicating a slip No., an item indicating the number of men, an item indicating the number of women, an item indicating a use start time, an item indicating a use end time, It consists of items indicating the usage status (status). In addition, the vacancy state “0” or the entry state “1” is stored in the status.

  FIG. 14 is a diagram showing a table stored in the order (header) DB. A table 610 shown in FIG. 14 is a table stored in the order (header) DB 61, and stores slip information when the total amount of charges is calculated once the room usage time has elapsed. The table 610 includes an item indicating a slip No., an item indicating a branch number, an item indicating a room code, an item indicating the number of men, an item indicating the number of women, an item indicating an order time, and a use start time. It consists of the following items: items indicating end-of-use time, items indicating total before tax, items indicating total consumption tax, items indicating total including tax, items indicating advance payment, items indicating membership classification, etc. Yes.

  FIG. 15 is a diagram showing a table stored in the order (detail) DB. A table 620 shown in FIG. 15 is a table stored in the order (detail) DB 62 and stores information for each slip (order). The table 620 includes an item indicating a slip No., an item indicating a branch number, an item indicating a branch number, an item indicating an index within a branch number, an item indicating a menu No., an item indicating a unit price, and the number of males. An item indicating the number of women, an item indicating a reference time, an item indicating a usage time, an item indicating a basic time, an item indicating a quantity, and the like.

  Next, a specific example of each table of the related log table 60 after the new room entry process will be described. FIG. 16 is a diagram illustrating a specific example of the order header table. A table 611 shown in FIG. 16 is a specific example of a table including a record generated by the new room entry process stored in the order (header) DB 61. For example, the table 611 includes slip number “757”, branch number “1”, room number “001”, number of males “2”, number of females “2”, order time “20030825152016”, use start time “200308525152003”, The use end time “20030825172003”, the external tax room charge “2400”, the external tax amount “120”, the total amount “2520”, the advance payment “0”, and the member classification “1” are stored. In addition, the calculation method of the sum total is calculated by multiplying the value obtained by adding the number of men and the number of women by the unit price. In addition, for each detail table, the sum of calculation results is the total before tax in the order header table.

  FIG. 17 is a diagram illustrating a specific example of the order detail table. A table 621 shown in FIG. 17 is a specific example of a table stored in the order (detail) DB 62. For example, in the table 621, slip number “757”, branch number “1”, branch number index “1”, menu number “7001”, unit price “300”, male number “2”, female number “0”, A reference time “200308525152003”, a usage time “60”, and a basic time “60” are stored.

  FIG. 18 is a diagram illustrating a specific example of the room information table. A table 631 shown in FIG. 18A shows a table before the new room entry process is performed, and a table 632 shown in FIG. 18B shows a table after the new room entry process is performed. . For example, the table 632 illustrated in FIG. 18B includes a room code “001”, a slip number “757”, a male number “2”, a female number “2”, a usage start time “20030825152003”, and a usage end time “20030825172003. ”And status“ 1 ”are stored.

  As described above, the new room processing unit 21 of the POS terminal 10 registers the room entry for each room based on the information stored in the related master table 70 and the related log table 60, and sets the time zone and the sex of the customer. It is possible to manage accounting information indicating a fee difference due to a difference and a fee accurately reflecting a product order. Accordingly, it is possible to save labor of the store staff in the service industry, prevent an operation error, accurately calculate the fee at the time of accounting, and flexibly cope with complicated fee setting.

  Next, the midway entry processing according to the second embodiment of the present invention will be described. FIG. 19 is a diagram showing a main screen displayed on the POS terminal in the midway entry processing according to the second embodiment of the present invention. A screen 230 illustrated in FIG. 19 is a main screen displayed in the midway entry process by the midway entry processing unit 31. Registered on the screen 230 are a display area 231 that shows the date and time displayed on the screen and the charge system information at that date, a display area 232 that displays the number of multiple rooms, the number of people restricted, and the usage status, and midway entry. A room entry button 234 for registration, a room movement button 235 for registering room movement, an extension button 236 for extension registration, an order button 237 for registering an order, and a room exit registration A midway exit button 238 and an exit button 239 for registering exit are displayed. For example, when another customer joins the room in the display area 233 indicating the room number “Room 1 D” in use, when the customer selects the display area 233 and touches the halfway entry button 234, the midway entry processing unit 31 acquires the room pattern stored in the room master DB 76 from the room number and displays the screen shown in FIG.

  FIG. 20 is a diagram showing a midway entry screen displayed on the POS terminal. A screen 240 shown in FIG. 20 shows a midway entry processing screen for the room selected on the main screen 200. On the screen 240, the date and time displayed on the screen, the charge system information at that date and the display area 241 indicating the person in charge of the input, the display area 242 indicating the room entry state (room entry mode) “midway entry”, and information on the customer A display area 243 indicating information about the selected room, a display area 244 indicating charge information such as a room usage fee, a cancel button 245 for canceling the information displayed on the screen or the screen, and the screen information A confirmation button 246 that is sometimes selected is displayed. For example, by entering the member number in the customer information in the display area 243 and selecting the confirmation button 246, the midway entry processing unit 31 acquires and displays the detailed information of the member from the member master DB 77. In addition, the fee classification, the number of men or women, and the usage time are input in the entry information of the display area 243, and the menu number, the number of men, the number of women, the use start time, and the use end time are determined. After each item in the display area 243 is confirmed, a charge calculation result is displayed in the display area 244. As described above, when the information about entering the room on the way is input to the display area 243, the charge information displayed on the display area 244 is confirmed, and the confirmation button 246 is selected, the screen shown in FIG. 21 is displayed.

  FIG. 21 is a diagram showing a main screen after midway entry processing displayed on the POS terminal. A screen 250 shown in FIG. 21 shows the main screen after being set on the midway entry processing screen 240. Registered on the screen 250 are a display area 251 showing the date and time displayed on the screen and the charge system information at that date, a display area 252 displaying the number of multiple rooms, the number of people restricted, and the usage status, and entering the room on the way A midway entry button 254 for registering an order, an order button 255 for registering an order, a midway exit button 256 for registering midway exit, and a leave button 257 for registering exit are displayed. For example, in the display area 253 indicating the room number “Room 1 D” in the display area 252, the room entry is registered halfway, so the usage time “15: 20-17: 20” and the remaining time “120 (minutes)”. , The number of people “6” and the usage status “in use” are displayed.

  As described above, the registration of the halfway entry is easily performed according to the screen displayed on the POS terminal 10, and the calculation is performed by referring to the related master table 70 and the related log table 60 by the halfway room entry processing unit 31 of the POS terminal 10. Displayed charges can be displayed.

  Next, the midway entry process will be specifically described. FIG. 22 is a diagram showing a flowchart of midway entry processing. In FIG. 22, first, in the process of step S <b> 41, the main screen is displayed on the POS terminal 10 by the midway entry processing unit 31, and a room is selected from the main screen. In the process of step S42, the midway entry processing screen relating to the room selected by the midway entry processing unit 31 is displayed. In the process of step S43, the midway entry processing unit 31 extracts the member information stored in the order (header) DB 61 and the order (details) DB 62 from the member number input on the midway entry processing screen, and determines the member classification. To do. In the process of step S44, the midway entry processing unit 31 extracts the menu No. stored in the order (header) DB 61 and the order (details) DB 62 from the charge category code input on the midway entry processing screen, and the menu No. Determine. In the process of step S45, the midway entry processing unit 31 determines the number of males entering the midway room entered on the midway entry process screen. In the process of step S46, the midway entry processing unit 31 determines the number of women in the midway entry entered on the midway entry processing screen. In the process of step S <b> 47, the midway entry processing unit 31 determines the entry time from the current time measured by the POS terminal 10. In the process of step S48, the midway entry processing unit 31 determines the exit time from the use time input on the midway entry processing screen. In the process of step S49, the midway entry processing unit 49 performs a process of creating halfway entry details (charge information) based on the confirmed information. This midway entry detailed process will be described in detail with reference to FIG. In the process of step S50, the midway entry processing unit 31 updates the room information table stored in the room information DB 63 from the created new entry details. When the main screen including the halfway entry details updated by the halfway entry processing unit 31 is displayed in the process of step S51, the room information table stored in the room information DB 63 is updated as the midway entry is confirmed.

  In this way, by entering necessary items from the screen and creating the room entry details on the way, and managing with the order (header) DB 61, the order (details) DB 62, and the room information DB 63, the operation of the karaoke shop staff can be saved and operated. It is possible to prevent mistakes, accurately calculate charges at the POS terminal 10 at the time of accounting, and flexibly cope with complicated charge settings.

  Next, the halfway entry details creation process shown in step S49 of FIG. 22 will be described. FIG. 23 is a diagram illustrating a flowchart of the halfway entry details creation process. In FIG. 23, first, in the process of step S55, the midway entry processing unit 31 sets the use time (subtracting the current time from the room leaving time) input on the midway entry processing screen as the remaining use time. In the process of step S56, the midway entry processing unit 31 repeats the subsequent processes (steps S57 to S69) until the remaining usage time becomes zero. In the process of step S57, the midway entry processing unit 31 determines whether or not the number of repetitions is the first time. If the number of repetitions is the first time in the process of step S57, the midway entry processing unit 31 repeats the subsequent processes (steps S59 to S62) twice in the process of step S58. In the process of step S59, the midway entry processing unit 31 determines whether or not the number of repetitions is the first time. When the number of repetitions is the first time in the process of step S59, the midway entry processing unit 31 acquires the male unit price for the reference time (60 minutes) from the menu unit price acquisition master DB 72 in the process of step S60. If the number of repetitions is not the first time in the process of step S59, the midway entry processing unit 31 acquires the unit price of the woman for the reference time (60 minutes) from the menu unit price acquisition master DB 72 in the process of step S61. After acquiring each unit price in steps S60 and S61, in the process of step S62, the midway entry processing unit 31 adds a detail record with branch number 2 to the order (detail) DB 62. In the process of step S68, the midway entry processing unit 31 repeats the process from step S57 until the remaining use time becomes 0 with the time obtained by subtracting X minutes from the remaining use time as the remaining use time. Note that X minutes is set to a value that can round the usage time of 60 minutes so that it is divisible by 30 minutes. For example, in the time available for 60 minutes, 60 minutes is set to 40 minutes, and 60 minutes is set to 80 minutes, so that collection of extra use time can be avoided.

  If the number of repetitions is not the first time in the process of step S57, the midway entry processing unit 31 repeats the subsequent processes (steps S64 to S67) twice in the process of step S63. In the process of step S64, the midway entry processing unit 31 determines whether or not the number of repetitions is the first time. If the number of repetitions is the first time in the process of step S64, the midway entry processing unit 31 acquires the male unit price for the additional time (30 minutes) from the menu unit price acquisition master DB 72 in the process of step S65. If the number of repetitions is not the first time in the process of step S64, the midway entry processing unit 31 acquires the female unit price for the additional time (30 minutes) from the menu unit price acquisition master DB 72 in the process of step S66. After acquiring each unit price in steps S65 and S66, in the process of step S67, the midway entry processing unit 31 adds a detail record with branch number 2 to the order (detail) DB 62. In the process of step S69, the midway entry processing unit 31 repeats the process from step S67 until the remaining usage time becomes 0 with the time obtained by subtracting 30 minutes from the remaining usage time as the remaining usage time. In the process of step S <b> 70, the midway entry processing unit 31 stores a header record with branch number 2 in the order (header) DB 61.

  As described above, the order (header) DB 61, the order (details) are used as accounting information for calculating the charges at the time of accounting by accumulating the charges for registration during mid-term use every 60 minutes, every 30 minutes, and by gender. By storing it in the DB 62 and the room information DB 63, it is possible to save trouble of the store staff of the service industry, prevent an operation error, accurately calculate the fee at the time of accounting, and flexibly deal with complicated fee setting. .

  Next, a specific example of each table of the related log table 60 after midway entry processing will be described. FIG. 24 is a diagram illustrating a specific example of the order header table. A table 612 shown in FIG. 24 is a specific example of a table to which a record generated in the midway entry process stored in the order (header) DB 61 is added. For example, in the table 612, in addition to the record of branch number “1” stored in the new room entry process, slip No. “757”, branch number “2”, room number “ 001 ”, the number of men“ 3 ”, the number of women“ 3 ”, the order time“ 200308251031033 ”, the use start time“ 200308825152003 ”, the use end time“ 20030825172003 ”, the tax room charge“ 3300 ”, and the tax amount“ 165 ”. , The item total “3465”, the advance payment “0”, and the member classification “1” are stored.

  FIG. 25 is a diagram showing a specific example of the order detail table. A table 622 shown in FIG. 25 is a specific example of a table stored in the order (detail) DB 62. For example, in the table 622, slip No. “757”, branch number “1”, branch number index “1”, menu number “7001”, unit price “300”, number of males “2” generated in the midway entry process. The number of women “0”, the reference time “20030825152003”, the usage time “60”, and the basic time “60” are stored. In the table 622, the branch number index is assigned to each of the branch numbers “1” and “2” and managed.

  FIG. 26 is a diagram illustrating a specific example of the room information table. A table 632 shown in FIG. 26 shows a table after the midway entry process. For example, the changed number of people who entered the room on the way is added to the table 632, the room code “001”, the slip number “757”, the number of men “3”, the number of women “3”, the use start time “20030825152003”, A use end time “20030825172003” and a status “1” are stored.

  In this way, the midway entry processing unit 31 of the POS terminal 10 accurately reflects the change in the charge and the number of people when entering midway based on the information stored in the related master table 70 and the related log table 60. Accounting information can be managed.

  Next, the midway exit processing according to the second embodiment of the present invention will be described. FIG. 27 is a diagram showing a main screen displayed on the POS terminal in the midway leaving process. A screen 260 shown in FIG. 27 is a main screen displayed in the midway exit process by the midway entry / exit processing unit 33. Registered on the screen 260 are a display area 261 showing the date and time displayed on the screen and the charge system information at that date, a display area 262 displaying the number of multiple rooms, the number of people restricted, and the usage status, and leaving the room on the way A room entry button 264 for registering room movement, a room movement button 265 for registering room movement, an extension button 266 for registering extension, an order button 267 for registering an order, and a room exit registering for registering room exit A midway exit button 268 and an exit button 269 for registering exit are displayed. For example, when the customer leaves the room in the display area 263 indicating the room number “No. 1 room D” in use, when the display area 263 is selected and the halfway exit button 268 is touched, the halfway exit processing unit 33 The room pattern stored in the room master DB 76 is acquired from the number, and the screen shown in FIG. 28 is displayed.

  FIG. 28 is a diagram showing a midway exit screen displayed on the POS terminal. A screen 270 shown in FIG. 28 shows a midway exit processing screen for the room selected on the main screen 260. On the screen 270, the date and time displayed on the screen, the charge system information at that date and time, the display area 271 indicating the person in charge of input, the display area 272 indicating the midway leaving list, and the person who has left the room are selected from the midway leaving list. Selection buttons 274 and 275, an input area 273 for inputting the number of persons leaving the room, a cancel button 276 for canceling information displayed on the screen or the screen, and a confirmation button 277 to be selected when the screen information is confirmed Is displayed. In the halfway withdrawal list in the display area 272, the room entry time, the sex of the customer, the room charge per person, and the number of people leaving the middle are entered for each room. For example, the screen shown in FIG. 29 is displayed by selecting a predetermined column from the midway leaving list in the display area 272 using the selection buttons 274 and 275, inputting the number of midway leaving from the input area 273, and then selecting the confirmation button 277. Is displayed.

  FIG. 29 is a diagram showing the main screen after the midway leaving process displayed on the POS terminal. A screen 280 shown in FIG. 29 shows the main screen after being set on the midway exit processing screen 270. The screen 280 displays a display area 281 indicating the date and time displayed on the screen and the charge system information at the date and time, and a display area 282 displaying the number of a plurality of rooms, the limited number of people, and the usage status. For example, in the display area 283 indicating the room number “Room 1 D” in the display area 282, the use of “15:20 to 17:20” and the remaining time “120 (minutes)” are registered because the exit from the room is registered. , The number of people “5” and the usage status “in use” are displayed.

  As described above, the registration of the halfway exit is easily performed according to the screen displayed on the POS terminal 10, and the halfway withdrawal processing unit 33 of the POS terminal 10 calculates by referring to the related master table 70 and the related log table 60. Displayed charges can be displayed.

  Next, the new leaving process will be specifically described. FIG. 30 is a diagram illustrating a flowchart of midway exit processing. In FIG. 30, first, in the process of step S80, the midway leaving processing unit 33 displays a main screen on the POS terminal 10, and a room is selected from the main screen. In the process of step S <b> 81, the midway exit processing unit 33 creates a list of possible midway exits for the rooms selected with reference to the order (detail) DB 62. In the process of step S82, the midway exit processing unit 33 displays a midway exit processing screen including a list of possible midway exits. In the process of step S83, the midway exit processing unit 33 determines the number of midway exiters (male) entered on the midway exit processing screen. In the process of step S84, the midway exit processing unit 33 determines the number of midway exiters (female) entered on the midway exit processing screen. In the process of step S85, the midway exit processing unit 33 performs a process of creating a new room entry (charge information) based on the confirmed information. This midway exit detail process will be described in detail with reference to FIG. In the process of step S86, the midway leaving processing unit 33 updates the room information table stored in the room information DB 63 from the created midway leaving details. In the process of step S87, when the main screen including the halfway withdrawal details updated by the halfway withdrawal processing unit 33 is displayed, the room information table stored in the room information DB 63 is updated assuming that halfway withdrawal has been confirmed.

  In this way, by entering the number of people leaving the room on the way from the room leaving process screen, creating the room leaving details, and managing them in the order (header) DB 61, the order (details) DB 62, and the room information DB 63, the labor of the staff of the karaoke shop The POS terminal 10 can accurately calculate the fee at the time of accounting, and can flexibly cope with complicated fee setting.

  Next, a description will be given of the process of creating a list of possible exits shown in step S81 of FIG. FIG. 31 is a diagram illustrating a flowchart of a process for creating a list of possible exits on the way. In FIG. 31, first, in the process of step S <b> 90, the midway exit processing unit 33 rearranges the midway exit orders stored in the order (detail) DB 62 in ascending order according to the condition of the branch number index. In the process of step S91, the midway exit processing unit 33 repeats the subsequent processes (steps S92 to S96) until all orders are rearranged. In the process of step S <b> 92, the midway leaving processing unit 33 determines whether or not the basic time of the midway leaving order stored in the order (detail) DB 62 is 60 minutes. If the basic time is 60 minutes in the process of step S92, the midway exit processing unit 33 creates the charge calculation work table 51 for each room entry time and sex in the process of step S97. For example, the fee calculation work table 51 is composed of room entry time, number of people, fee, and branch number.

  If the basic time is not 60 minutes in the process of step S92, the midway exit processing unit 33 repeats the subsequent processes (steps S94 to S96) using the charge calculation work table 51 in the process of step S93. In step S94, the midway exit processing unit 33 determines whether or not the branch number of the charge calculation work table 51 matches the branch number of the specification from the midway exit order stored in the order (detail) DB 62. To do. When the branch number of the charge calculation work table 51 matches the branch number of the details in the process of step S94, the midway exit processing unit 33 in the process of step S95, the midway exit order stored in the order (details) DB 62. From this, it is determined whether or not the reference time is less than the current time. If the reference time is less than the current time in the process of step S95, the midway exit processing unit 33 updates the charge calculation work table 51, that is, charges a charge, in the process of step S96. If it is determined in step S95 that the reference time is greater than the current time, step S93 is repeated. If the branch number of the charge calculation work table 51 does not match the branch number of the specification in the process of step S94, the process of step S93 is repeated. In the process of step S98, the midway exit processing unit 33 displays a list of possible midway exits that are the plurality of fee calculation work tables 51 created.

  In this way, by displaying the list of possible midway exits on the midway exit processing screen, it is possible to easily input information about midway exits, and to accurately calculate the midway exit charges at the POS terminal 10 at the time of payment.

  Next, the halfway exit statement creation process shown in step S85 of FIG. 30 will be described. FIG. 32 is a diagram illustrating a flowchart of a midway exit statement creation process. In FIG. 32, first, in the process of step S <b> 100, the midway exit processing unit 33 repeats the subsequent processes (steps S <b> 101 to S <b> 103) until all the orders for the midway exit stored in the order (detail) DB 62 are rearranged. In the process of step S <b> 101, the midway leaving processing unit 33 determines whether or not the basic time of the midway leaving order stored in the order (detail) DB 62 is 60 minutes. If the basic time is not 60 minutes in the process of step S101, the midway exit processing unit 33 determines whether the reference time is larger than the current time from the midway exit order stored in the order (detail) DB 62 in the process of step S102. Determine whether. If the reference time is larger than the current time in the process of step S102, the midway exit processing unit 33 in the process of step S103 determines the negative details of the corresponding details from the number of males and females input from the midway exit processing screen. It is created and registered in the order (detail) DB 62 as branch number “3”.

  When the basic time is 60 minutes in the process of step S101, the process of step S100 is repeated. If the reference time is smaller than the current time in the process of step S102, the process of step S100 is repeated. In the process of step S104, the midway exit processing unit 33 determines whether there is a down payment. When there is a down payment in the process of step S104, the midway exit processing unit 33 adds the advance amount input from the midway exit processing screen to the order details in the process of step S106. In step S107, the midway exit processing unit 33 adds the corresponding order details to the order (header) DB 61 as the branch number “3”. If there is no advance payment in the process of step S104, the midway exit processing unit 33 adds the corresponding order details to the order (header) DB 61 as the branch number “3” in the process of step S105.

  In this way, by adding the order details for which exit processing has been performed on the way to the order (header) DB 61 and the order (detail) DB 62 as a branch number “3”, it is possible to save the labor of the store staff in the service industry and to make an operation error. Therefore, it is possible to accurately calculate charges at the time of accounting, and flexibly cope with complicated charge settings.

  Next, a specific example of each table of the related log table 60 after the midway leaving process will be described. FIG. 33 is a diagram illustrating a specific example of the order header table. A table 613 shown in FIG. 33 is a specific example of a table to which a record generated by the midway leaving process stored in the order (header) DB 61 is added. For example, in the table 613, in addition to the record of the branch number “1” stored in the new room entry process and the branch number “2” stored in the midway room entry process, the slip No. that is a record generated in the midway exit process “757”, branch number “3”, room number “001”, number of men “2”, number of women “3”, order time “20030825163058”, use start time “20030825152003”, use end time “20030825172003”, foreign tax The room charge “3150”, the external tax amount “135”, the total amount “2835”, the advance payment “450”, and the member classification “1” are stored. Note that the order (header) tax-included total amount, that is, the invoiced amount is calculated by adding the value obtained by subtracting the pre-tax amount from the pre-tax total amount and the consumption tax amount obtained by subtracting the pre-tax amount from the pre-tax amount. Charge amount.

  FIG. 34 is a diagram showing a specific example of the order detail table. A table 623 shown in FIG. 34 is a specific example of a table stored in the order (detail) DB 62. The table 623 stores the number of people who exit on the way with the branch number “3”. For example, slip number “757”, branch number “3”, branch number index “1”, menu number “7501”, unit price “150”, the number of men “−1”, the number of women “0”, the reference time “20030825165003”, the usage time “30”, and the basic time “30” are stored.

  FIG. 35 is a diagram illustrating a specific example of the room information table. A table 633 shown in FIG. 35 shows a table after the midway leaving process. For example, in the table 633, the number of people who have left the room is updated, the room code “001”, the slip number “757”, the number of men “2”, the number of women “3”, the use start time “20030825152003”, the use The end time “20030825172003” and the status “1” are stored.

  As described above, the halfway leaving processing unit 33 of the POS terminal 10 accurately reflects the change in the charge and the number of people when leaving the middle based on the information stored in the related master table 70 and the related log table 60. Accounting information can be managed.

  Next, a room movement process according to the third embodiment of the present invention will be described. FIG. 36 is a diagram showing a main screen displayed on the POS terminal in the room movement process according to the third embodiment of the present invention. A screen 290 illustrated in FIG. 36 is a main screen displayed by the room movement processing by the room movement processing unit 34. On the screen 290, a display area 291 indicating the date and time displayed on the screen and the charge system information at that date, a display area 292 displaying the number of the plurality of rooms, the number of people restricted, and the usage status, and exiting midway are registered. A middle entry button 294 for registering, a room movement button 295 for registering room movement, an extension button 296 for registering extension, an order button 297 for registering an order, and a room exit registering A midway exit button 298 and an exit button 299 for registering exit are displayed. For example, when moving from the room of the display area 293 indicating the room number “Room 1 D” in use to another room (Room 3 D), when the display area 293 is selected and the room move button 295 is touched, The movement processing unit 34 acquires the room pattern stored in the room master DB 76 from the room number, and displays the screen shown in FIG.

  FIG. 37 is a diagram showing a room movement processing screen displayed on the POS terminal. A screen 310 shown in FIG. 37 shows a room movement processing screen showing the room selected on the main screen 290 and a plurality of movable rooms. The screen 310 includes a date and time displayed on the screen, a charge system information at that date and time, a display area 311 indicating the person in charge of input, a display area 312 indicating information on the selected source room, and a movable room. A display area 313 showing a list, selection buttons 315 and 314 for selecting a room to be moved, a cancel button 317 for canceling information displayed on the screen or the screen, and a confirmation button 318 for selecting when the screen information is confirmed. Is displayed. The display area 312 displays the source room code and room name, the charge category, the membership category, the gender category and the total number of people, the entry time, the exit time, and the remaining time. The display area 313 includes a room code, a room name, and room detailed information in the destination room list. For example, the room code “003” in the display area 313, the room name “Room 3 D (10 persons)”, the room 316 having the room detailed information “Zashiki” is selected by the selection buttons 314 and 315, and the confirmation button 318 is selected. As a result, the screen shown in FIG. 38 is displayed.

  FIG. 38 is a diagram showing a main screen after the room moving process displayed on the POS terminal. A screen 320 shown in FIG. 38 shows the main screen after being set on the room movement processing screen 310. The screen 320 displays a display area 321 indicating the date and time displayed on the screen and the charge system information at the date and time, and a display area 322 displaying the number of a plurality of rooms, the limited number of people, and the usage status. Since the room movement is set, the usage time “15:20 to 17:20”, the remaining time “40 (minutes)”, the number of people “5” are displayed in the display area 323 indicating the room number “Room 3 D” in the display area 322. Name ”and usage status“ in use ”are displayed.

  As described above, the room movement is easily performed according to the screen displayed on the POS terminal 10, and the charge information related to the room movement is stored in the related master table 70 and the related log table 60 by the room movement processing unit 34 of the POS terminal 10. can do.

  Next, the room moving process will be specifically described. FIG. 39 is a diagram illustrating a flowchart of the room movement process. In FIG. 39, first, in the process of step S110, the main screen is displayed on the POS terminal 10 by the room movement processing unit 34, and the original room is selected from the main screen. In the processing of step S111, the room movement processing unit 34 displays a room movement processing screen based on the room information stored in the room information DB 63. In the process of step S112, the room movement processing unit 34 determines the destination room selected on the room movement processing screen. In step S113, the room movement processing unit 34 determines whether or not the pattern of the destination room is different. If the pattern of the destination room is different in the process of step S113, the room movement processing unit 34 in the process of step S114 until the rearrangement of all orders related to the room movement stored in the order (detail) DB 62. (Steps S115 to S117) are repeated. In step S115, the room movement processing unit 34 determines whether or not the basic time of the room movement order stored in the order (detail) DB 62 is 60 minutes. If the basic time is not 60 minutes in the process of step S115, the room movement processing unit 34 determines whether or not the reference time is larger than the current time from the room movement order stored in the order (detail) DB 62 in the process of step S116. Determine whether. When the reference time is larger than the current time in the process of step S116, the room movement processing unit 34 creates a minus detail of the corresponding detail and recreates the corresponding detail in the process of step S117, and the order (header) DB 61. And stored in the order (details) DB 62. This detail re-creation process will be described in detail with reference to FIG. When the basic time is 60 minutes in the process of step S115, the process of step S114 is repeated. If the reference time is smaller than the current time in the process of step S116, the process of step S114 is repeated. In step S118, the room movement processing unit 34 updates the room information table stored in the room information DB 63 from the details relating to the created room movement. In the process of step S119, the main screen after the room movement updated by the room movement processing unit 34 is displayed.

  In this way, the room movement is set from the room movement processing screen, the fee details relating to the room movement are created, and managed by the order (header) DB 61, the order (detail) DB 62, and the room information DB 63, so that the staff of the karaoke shop It is possible to save trouble and prevent an operation error, accurately calculate the fee with the POS terminal 10 at the time of accounting, and flexibly cope with complicated fee setting.

  Next, the detail re-creation process shown in step S117 of FIG. 39 will be described. FIG. 40 is a diagram illustrating a flowchart of the detail re-creation process. In FIG. 40, first, in the process of step S120, the room movement processing unit 34 repeats the subsequent processes (steps S121 to S124) for the target details. In the process of step S121, the room movement processing unit 34 determines whether the specification is for a male subject. In the process of step S121, if it is a male target detail, in step S122, the room movement processing unit 34 creates a negative detail of the male target, that is, a detail with the number of people minus. In step S123, the room movement processing unit 34 acquires the male unit price for the additional time (30 minutes) from the menu unit price acquisition master DB 72.

  Further, in the process of step S121, if it is not a male target detail, the room movement processing unit 34 creates a female target negative detail in step S125. In the process of step S126, the room movement processing unit 34 acquires the unit price of the woman for the additional time (30 minutes) from the menu unit price acquisition master DB 72. In the process of step S <b> 124, the room movement processing unit 34 adds a detail record with the branch number X to the order (detail) DB 62. In step S127, the room movement processing unit 34 stores a header record with a branch number of 4 in the order (header) DB 61.

  In this way, by storing in the order (header) DB 61, the order (detail) DB 62, and the room information DB 63 as accounting information for calculating the charge in the room moving process at the time of accounting, the labor of the store staff in the service industry is saved. In addition, operation mistakes can be prevented, charges can be accurately calculated at the time of accounting, and it is possible to flexibly cope with complicated charge settings.

  Next, a specific example of each table of the related log table 60 after the room movement process will be described. FIG. 41 is a diagram showing a specific example of the order header table. A table 614 shown in FIG. 41 is a specific example of a table to which a record generated by the room moving process stored in the order (header) DB 61 is added. For example, the table 614 includes slip No. “757”, branch number “4”, room number “003”, male number “2”, female number “3”, order time “ 200308251644009 ”, use start time“ 20030825152003 ”, use end time“ 20030825172003 ”, external tax room charge“ 3650 ”, external tax amount“ 160 ”, item total“ 3360 ”, advance payment“ 450 ”, member classification“ 1 ” Stored.

  FIG. 42 is a diagram showing a specific example of the order detail table. A table 624 shown in FIG. 42 is a specific example of a table stored in the order (detail) DB 62. For example, in the table 624, the record 625 stores the man and woman before the room movement of branch number “4” generated by the room movement process, and the details after the room movement.

  FIG. 43 is a diagram illustrating a specific example of the room information table. A table 634 shown in FIG. 43 shows the table after the room movement process. For example, in the table 634, the number of persons who moved to the room code after the room movement is updated, the room code “003”, the slip number “757”, the male number “2”, the female number “3”, the use start time. "20030825152003", use end time "200308825172003", and status "1" are stored.

  As described above, the room movement processing unit 34 of the POS terminal 10 stores the records after the room movement processing in the related master table 70 and the related log table 60, thereby changing the charge and the number of people when the room is moved. It is possible to manage accounting information that accurately reflects.

  Next, specific examples of each table of the related master table 70 will be described. 44 is a diagram showing a specific example of a menu master table. A table 711 shown in FIG. 44 is a table stored in the menu master DB 71, and stores information related to menus such as products and room charge categories. This table 711 includes items indicating menu numbers, items indicating menu names, and items indicating menu unit prices. For example, the table 711 stores a menu number “0001”, a menu name “Coke”, a menu unit price “0000250”, a menu number “7001”, a menu name “normal charge”, and the like.

  FIG. 45 is a diagram illustrating a specific example of the room master table. A table 761 shown in FIG. 45 is a table stored in the room master DB 76, and stores information related to the room. This table 761 includes an item indicating a room number, an item indicating a room pattern, and an item indicating a room name (maximum number of people entering the room). For example, the table 761 stores a room number “001”, a room pattern “01”, a room name “room No. 1 D 50”, and the like.

  FIG. 46 is a diagram showing a specific example of the daily charge category master table. A table 731 shown in FIG. 46 is a table stored in the daily charge category master DB 73, and stores information related to daily room charge categories. The table 731 includes an item indicating a daily fee code and an item indicating a daily fee name. For example, the table 731 stores a daily fee code “01”, a daily fee name “weekday fee”, and the like.

  FIG. 47 is a diagram showing a specific example of the daily fee master table. A table 741 shown in FIG. 47 is a table stored in the daily charge master DB 74, and stores information related to daily charges. This table 741 includes items indicating business days and items indicating daily charge codes. For example, the table 741 stores business days “20030825”, daily charge code “01”, and the like.

  FIG. 48 is a diagram showing a specific example of the member master table. A table 771 shown in FIG. 48 is a table stored in the member master DB 77, and stores information related to members. The table 771 includes an item indicating a member number, an item indicating a member name, and an item indicating a member classification. For example, the table 771 stores a daily fee code “00000001”, a member name “Hanako Yamada”, a member classification “01”, and the like.

  FIG. 49 is a diagram showing a specific example of the menu unit price acquisition master table. A table 725 shown in FIG. 49 is a table stored in the menu unit price acquisition master DB 72, and stores information related to acquisition of the menu unit price of the POS terminal 10. This table 725 includes an item indicating a menu No., an item indicating a daily charge code, an item indicating a room pattern, an item indicating an application start time, an item indicating an adaptation end time, and an item indicating a male flag. And an item indicating a female flag, an item indicating a member classification, and an item indicating a unit price. For example, records 721 and 722 (menu Nos. “7001” and “7002”) of the table 725 store information on basic charges, and records 723 and 724 (menus “7501” and “7502”) have additional basic charges. Information about is stored.

  In this way, by managing the above table with the related master table 70, it is possible to save trouble of the store staff in the service industry and prevent an operation error, and the POS terminal 10 can accurately calculate the fee at the time of accounting. It is possible to respond flexibly to pricing.

  Next, the receipt output from the POS terminal 10 will be described in detail. FIG. 50 is a diagram showing a room entry slip output in the new room entry process according to the first embodiment of the present invention. As shown in FIG. 50, the receipt 110 shows a room entry slip output from the POS terminal 10 in the new room entry process. The receipt 110 includes a display area 111 indicating information such as store opening hours, a location, a display area 112 indicating detailed information on the accounting slip, a display area 113 indicating details of the room charge, a total charge, and the like. A display area 114 is displayed. In the display area 112, the output time of the accounting slip (new) “2003/08/25 15:20”, the slip number “757-01”, the room classification “normal charge”, the room number (room) and the use The time “Room 1 (Usage time 15:20 to 17:20)”, the number of people “4 people”, and the person in charge “store manager” are displayed. In the display area 113, as a room charge description (male) basic (60 minutes) “¥ 300” and number of people: “¥ 600”, (female) basic (60 minutes) “¥ 300” and number of people: 2 people Like “¥ 600”, (male) added (30 minutes) “¥ 150” and the number of people: 2 people, usage: 2 “¥ 600”, (female) added (30 minutes) “¥ 150” and the number of people: 2 Name, number of uses: 2 “¥ 600” is displayed. In addition, the contents of the room entry slip are read in the display area 114 as the room usage fee “¥ 2,400”, the subtotal “¥ 2,400”, the consumption tax “¥ 120”, and the total “¥ 2,520”. And a bar code for display. In this way, after entering a new room, it is possible to output the fee details when leaving the room to the receipt 110.

  FIG. 51 is a diagram showing a halfway entry slip output in the halfway entry process according to the second embodiment of the present invention. A receipt 120 shown in FIG. 51 shows a halfway entry slip output from the POS terminal 10 in the middle entry process. The receipt 120 includes a display area 121 that shows information such as store hours and locations, a display area 122 that shows detailed information on the accounting slip, a display area 123 that shows the charge details of the previous room, a total of charges, etc. A display area 124 is displayed. In the display area 122, the output time of the accounting slip (addition) “2003/08/25 16:10”, the slip number “757-02”, the room classification “normal charge”, the room number (room) and the use The time “Room 1 (Usage time 15: 20-17: 20)”, the number of people “6 people”, and the person in charge “store manager” are displayed. In the display area 123, the total before tax (excluding tax) “¥ 2,400”, No. “01”, entry “16:10”, exit “17:20”, male “1”, female “1”, and room charge “¥ 900” are displayed. In addition, the contents of the room entry slip are read in the display area 124 as usage details such as room charge “¥ 3,300”, subtotal “¥ 3,300”, consumption tax “¥ 165”, total “¥ 3,465”. And a bar code for display. In this way, it is possible to output the billing details for entering the room on the receipt 120.

  FIG. 52 is a diagram showing a midway exit slip output in the midway exit process according to the second embodiment of the present invention. A receipt 130 shown in FIG. 52 shows a halfway leaving slip output from the POS terminal 10 in the middle leaving process. The receipt 130 includes a display area 131 that shows information such as store hours and locations, a display area 122 that shows detailed information on the accounting slip, a display area 133 that shows the charge details of the previous room, a total of charges, etc. A display area 134 is displayed. In the display area 132, the output time of the accounting slip (addition) “2003/08/25 16:30”, the slip number “757-03”, the room classification “normal charge”, the room number (room) and the use The time “Room 1 (Usage time 15: 20-17: 20)”, the number of people “5 people”, and the person in charge “store manager” are displayed. In the display area 133, a total of “¥ 3,300”, “No. “01”, entry “15:20”, exit “16:30”, male “1”, female “0”, and room charge “¥ 450” are displayed. In the display area 134, the room charges “¥ 3,150”, the subtotal “¥ 3,150”, the advance payment “¥ 450”, the consumption tax target amount “¥ 2,700”, and the consumption tax “¥ 135” are displayed as usage details. ”, The total“ ¥ 2,835 ”, and a bar code for reading the contents of the room entry slip. In this way, the billing details when leaving the room on the way can be output to the receipt 130.

  FIG. 53 is a diagram showing a room movement slip output in the detail re-creation process according to the third embodiment of the present invention. A receipt 140 shown in FIG. 53 shows a room movement slip output from the POS terminal 10 in the room movement process. The receipt 140 includes a display area 141 indicating information such as store hours and locations, a display area 142 indicating detailed information on the accounting slip, a display area 143 indicating charge details before and after the room movement, a total of charges, and the like. A display area 144 is displayed. In the display area 142, the output time of the accounting slip (addition) “2003/08/25 16:30”, the slip number “757-04”, the room classification “ordinary fee⇒special fee”, and the room number (room) ) And the usage time “Room 1 → Room 5 (Time 15: 20-17: 20)”, the number of people “5 people”, and the person in charge “store manager” are displayed. In the display area 143, the room charge “¥ 3,150” before the move, the room charge “¥ 3,650” after the move, the difference between the room charges “¥ 500”, the usage time before the move “ "90 minutes", difference from previous room charge: "100 yen" per person (30 minutes), subtotal "¥ 3,650" are displayed. In the display area 144, the room charges “¥ 3,650”, the subtotal “¥ 3,650”, the advance payment “¥ 450”, the consumption tax target amount “¥ 3,200”, the consumption tax “¥ 160” are displayed as usage details. ", A total of" ¥ 3,360 "and a bar code for reading the contents of the room entry slip. In this way, the billing details when the room is moved can be output to the receipt 140.

  FIG. 54 is a diagram showing an accounting slip output at the time of accounting according to the third embodiment of the present invention. A receipt 150 shown in FIG. 54 indicates an accounting receipt output from the POS terminal 10 when a customer leaves and performs accounting. The receipt 150 includes a display area 151 indicating information such as store opening hours and locations, a display area 152 indicating detailed information on the accounting slip, a display area 153 indicating details of room charges, and entering / exiting and moving on the way A display area 154 showing the hourly charge details and a display area 155 showing the total of charges and the like are displayed. In the display area 152, the POS terminal number and output time “POS001, August 25, 2003 17:45”, the room classification “special rate”, the room number (room), and the usage time “Room 5 (Usage time 15 : 20-17: 20) ", the number of people" 5 ", the person in charge" store manager (transaction # 00001) ", and the slip number" 757 ". In the display area 153, as a room charge description (male) basic (60 minutes) “¥ 300” and number of people: “¥ 600”, (female) basic (60 minutes) “¥ 300” and number of people: 2 people Like “¥ 600”, (male) added (30 minutes) “¥ 150” and the number of people: 2 people, usage: 2 “¥ 600”, (female) added (30 minutes) “¥ 150” and the number of people: 2 Name, number of uses: 2 “¥ 600” is displayed.

  In the display area 154, the total before tax (excluding tax) “¥ 2,400”, No. “01”, entering room “16:10”, leaving room “17:20”, male “1”, female “1”, room charge “¥ 900”, and a total of “¥ 3” before leaving the room, 300 ", no. “01”, entry “15:20”, exit “16:30”, male “1”, female “0”, room charge “¥ 450” and room charge difference “¥ 500” Is displayed. In the display area 155, the room charges “¥ 3,650”, the subtotal “¥ 3,650”, the advance payment “¥ 450”, the consumption tax target amount “¥ 3,200”, and the consumption tax “¥ 160” are displayed as usage details. ”, The total“ ¥ 3,360 ”, the deposit amount“ ¥ 4,000 ”, and the change“ ¥ 640 ”. In this way, it is possible to output to the receipt 150 a billing statement that reflects the fee for entering or leaving the room or moving the room.

  In this way, information relating to accounting is stored in the related log table 60 and the related master table 70 by the POS terminal 10, and charges are calculated at the time of accounting based on those tables, and are output to a receipt or the like, thereby providing a karaoke shop or the like. This eliminates the trouble of store staff in the service industry, prevents operation mistakes, accurately calculates charges at the time of accounting, and can flexibly cope with complicated charge settings.

  Next, an application example of the POS terminal 10 will be described as a fourth embodiment of the present invention. FIG. 55 is a diagram showing an application example of the accounting support apparatus of the present invention. In FIG. 55, when the POS terminal 10, which is the accounting support apparatus of the present invention, is used in a karaoke shop or a family restaurant, the POS terminal 10 is installed at the accounting front, and is connected to the POS terminal 10 and the LAN 1 in the cooking room. A printer 13 is installed. When an order from a customer is input by the handy terminal 12, the order is transmitted to the POS terminal 10 by wireless communication. An order is supplied from the POS terminal 10 to the printer 13 via the LAN 1. The printer 13 outputs the supplied order as an order slip 14 to a paper medium. The cooking room looks at the order slip 14 and cooks the food and drink provided to the customer. When the customer leaves the room and performs accounting, the POS terminal 10 calculates the total amount of the room used by the customer or the ordered fee and outputs it to the receipt 11. The POS terminal 10 can calculate the room usage fee according to the time zone, the difference in the fee when changing the room, the advance collected when entering or leaving the room on the way, and the like.

  Therefore, in the POS terminal 10 which is the accounting support apparatus of the present invention, the service information related to the service provided to the customer and the customer attribute related to the customer are input for each room providing the service, and the input information and the customer attribute input. And a charge table showing the charge of the service according to the time zone, a record showing the charge for each predetermined unit time from the service start time to the end time is generated, and the charge is based on the generated record By accumulating, it is possible to save trouble of the store staff of the service industry, prevent an operation error, accurately calculate the fee at the time of accounting, and flexibly deal with complicated fee setting.

Note that the accounting support apparatus of the present invention can also be applied to an industry in which the price of goods fluctuates dynamically in time zones, for example, home delivery services such as pizza and lunch boxes.
(Additional remark 1) The input means which inputs the information regarding the original room which provides a service, the room of a movement destination, the service information regarding the service provided to a customer, and the customer attribute regarding a customer,
A charge database storing a charge table showing the charge of the service according to the customer attribute, time zone, and each room;
Record generating means for generating a record indicating a charge for each predetermined unit time from the service start time to the end time based on the input information input by the input means and the charge table;
And a cumulative unit for accumulating charges from the service provision start time to the service end time at the time of accounting when the room is moved within the service provision time based on the record generated by the record generation means. Accounting support device.
(Additional remark 2) The said record production | generation means produces | generates the record which shows the charge of the original room for every predetermined unit time from the provision start time of the said service to room movement time, and is predetermined from the room movement time to the provision end time of the said service The accounting support apparatus according to appendix 1, wherein a record indicating a room charge after movement for each unit time is generated.
(Supplementary note 3) The accounting support apparatus according to Supplementary note 1 or 2, wherein the input means includes display means for displaying a screen showing the original room information and a plurality of movable room information.
(Additional remark 4) The said display means displays the screen which shows the utilization condition for every room which provides the said service, The accounting assistance apparatus of Additional remark 3 characterized by the above-mentioned.
(Additional remark 5) The said service includes provision of the goods to the said customer, The accounting assistance apparatus as described in any one of additional marks 1 thru | or 4 characterized by the above-mentioned.
(Additional remark 6) The said record production | generation means adds the identification information which identifies the said service content to the said record, The accounting assistance apparatus as described in any one of additional remark 1 thru | or 5 characterized by the above-mentioned.
(Additional remark 7) It is the accounting support method in the accounting support apparatus which has the charge database in which the charge table which shows the charge of the service according to the customer attribute regarding the customer who provides a service, a time slot | zone, and each room,
An input procedure for entering information about the source and destination rooms of the service, service information about the service provided to the customer, and customer attributes about the customer;
A record generation procedure for generating a record indicating a charge for each predetermined unit time from a service start time to an end time based on the input information input by the input procedure and the charge table;
And a cumulative procedure for accumulating charges from the service provision start time to the service end time at the time of accounting when the room is moved within the service provision time based on the record generated by the record generation procedure. Accounting support method.
(Supplementary Note 8) For causing a computer to perform a process in an accounting support apparatus having a charge database storing a charge table indicating a service attribute corresponding to a customer attribute, a time zone, and each room relating to a service providing customer A program,
An input procedure for entering information about the source and destination rooms of the service, service information about the service provided to the customer, and customer attributes about the customer;
A record generation procedure for generating a record indicating a charge for each predetermined unit time from a service start time to an end time based on the input information input by the input procedure and the charge table;
A program having a cumulative procedure of accumulating charges from the service start time to the end time at the time of accounting when a room is moved within the service provision time based on the record generated by the record generation procedure. .

1 is a system configuration diagram of an accounting support apparatus according to a first embodiment of the present invention. It is a figure which shows the main screen displayed on a POS terminal in a new room entry process. It is a figure which shows the room entry process screen displayed on a POS terminal. It is a figure which shows the main screen after the new entrance process displayed on a POS terminal. It is a figure which shows the flowchart of a new room entry process. It is a figure which shows the flowchart of a new room entry detailed preparation process. It is a figure which shows the table stored in menu master DB. It is a figure which shows the table stored in menu unit price acquisition master DB. It is a figure which shows the table stored in room master DB. It is a figure which shows the table stored in the daily charge classification master DB. It is a figure which shows the table stored in the daily charge master DB. It is a figure which shows the table stored in member master DB. It is a figure which shows the table stored in room information DB. It is a figure which shows the table stored in order (header) DB. It is a figure which shows the table stored in order (detail) DB. It is a figure which shows the specific example of an order header table. It is a figure which shows the specific example of an order details table. It is a figure which shows the specific example of a room information table. It is a figure which shows the main screen displayed on a POS terminal in the midway entry process which concerns on 2nd Example of this invention. It is a figure which shows the midway entrance screen displayed on a POS terminal. It is a figure which shows the main screen after the middle entrance process displayed on a POS terminal. It is a figure which shows the flowchart of a room entry process. It is a figure which shows the flowchart of a midway room description preparation process. It is a figure which shows the specific example of an order header table. It is a figure which shows the specific example of an order details table. It is a figure which shows the specific example of a room information table. It is a figure which shows the main screen displayed on a POS terminal in a midway leaving process. It is a figure which shows the leaving screen on the way displayed on a POS terminal. It is a figure which shows the main screen after the middle leaving process displayed on a POS terminal. It is a figure which shows the flowchart of a midway leaving process. It is a figure which shows the flowchart of a room leaving possible list creation process. It is a figure which shows the flowchart of a leaving process specification preparation process on the way. It is a figure which shows the specific example of an order header table. It is a figure which shows the specific example of an order details table. It is a figure which shows the specific example of a room information table. It is a figure which shows the main screen displayed on the POS terminal in the room movement process which concerns on 3rd Example of this invention. It is a figure which shows the room entry process screen displayed on the POS terminal in a room movement process. It is a figure which shows the main screen displayed on the POS terminal in a room movement process. It is a figure which shows the flowchart of a room movement process. It is a figure which shows the flowchart of a detail re-creation process. It is a figure which shows the specific example of an order header table. It is a figure which shows the specific example of an order details table. It is a figure which shows the specific example of a room information table. It is a figure which shows the specific example of a menu master table. It is a figure which shows the specific example of a room master table. It is a figure which shows the specific example of a daily charge classification master table. It is a figure which shows the specific example of a daily charge master table. It is a figure which shows the specific example of a member master table. It is a figure which shows the specific example of a menu unit price acquisition master table. It is a figure which shows the entrance slip output by the new entrance process which concerns on 1st Example of this invention. It is a figure which shows the midway entrance slip output by the midway entrance process which concerns on 2nd Example of this invention. It is a figure which shows the midway leaving slip output by the midway leaving process which concerns on 2nd Example of this invention. It is a figure which shows the room moving slip output by the detailed re-creation process based on 3rd Example of this invention. It is a figure which shows the accounting slip output at the time of the accounting which concerns on 3rd Example of this invention. It is a figure which shows the example of application of the accounting assistance apparatus which concerns on 4th Example of this invention.

Explanation of symbols

1 LAN
5 Main processing section 10 POS terminal 11 Receipt 12 Handy terminal 13 Printer 14 Order slip 21 New room processing section 25 Exit processing section 30 In-room processing section 31 Midway entrance processing section 32 Extension processing section 33 Midway exit processing section 34 Room movement processing Unit 35 Food Order Registration Processing Unit 36 Number Change Processing Unit 40 Menu Unit Price Acquisition Processing Unit 50 Program Work Table 60 Related Log Table 61 Order (Header) DB
62 Order (Detail) DB
63 Room information DB
70 Related master table 71 Menu master DB
72 Menu unit price acquisition master DB
73 Daily fee classification master DB
74 Daily charge master DB
75 Room Pattern Master DB
76 Room Master DB
77 Member Master DB

Claims (5)

An input means for inputting information about the original room to which the service is provided and the destination room, service information about the service provided to the customer, and customer attributes about the customer;
A charge database storing a charge table showing the charge of the service according to the customer attribute, time zone, and each room;
Record generating means for generating a record indicating a charge for each predetermined unit time from the service start time to the end time based on the input information input by the input means and the charge table;
An accumulating unit that accumulates charges from the service provision start time to the service end time at the time of accounting when the room is moved within the service provision time based on the record generated by the record generation unit. Accounting support device.   The record generation means generates a record indicating the charge of the original room for each predetermined unit time from the service provision start time to the room movement time, and for each predetermined unit time from the room movement time to the service provision end time. The accounting support apparatus according to claim 1, wherein a record indicating a charge of a room after movement is generated.   3. The accounting support apparatus according to claim 1, wherein the input means includes display means for displaying a screen showing the original room information and a plurality of movable room information.   4. The accounting support apparatus according to claim 1, wherein the service includes provision of products to the customer.   5. The accounting support apparatus according to claim 1, wherein the record generation unit adds identification information for identifying the service content to the record.

Images