JP4847730B2 - Water charge management method, water charge management apparatus, and computer program - Google Patents

Description

  The present invention relates to a water charge management method for managing a water charge using a computer, and in particular, a water charge management method that can be applied to a past unpaid portion when an overcharge or a refund occurs, and implements the method. TECHNICAL FIELD The present invention relates to a water charge management device and a computer program for causing a computer to execute the method.

  In recent years, with the rapid spread of computer systems, the management of charges (utility charges) for those having a strong public interest such as electricity and gas has been made by computer systems. There are no exceptions to water charges, and many local governments manage them with computer systems.

  Patent Document 1 discloses a charge management system applicable to the management of public charges including water charges. This charge management system, when there is a charge for charge payment, when payment is made for the charge, first, the application is executed for the amount of the charge, and as a result, overcharge occurs. It is configured to be used for the next bill.

In the case of the conventional fee management system configured in this way, if overpayment occurs, it will be used for future billing, so it is possible to avoid complicated procedures such as refund, and in the future There is an advantage that it is possible to secure the payment for the billing.
JP 2002-207952 A

  By the way, about the past unpaid amount in a water rate, loss processing (payment of debts) is made when a predetermined period passes. Therefore, it is desirable for the side collecting water charges to be able to apply not only for future billing but also for past unpaid portion when overcharge occurs.

  In addition, unlike other public charges such as electricity and gas, water charges may be refunded to payers even if they are stored within the claimed range. For example, such a refund is performed when red water or water leakage occurs. As for the refund, as in the case of the overpayment described above, it is desirable that the side that collects the water charge can be used for the past unpaid portion.

  The present invention has been made in view of such circumstances, and its purpose is to provide a water rate management method that can be used for past unpaid payments when a water charge is overcharged or refunded. Is to provide a computer program for causing a computer to execute the method.

  In order to solve the above-described problems, the water rate interest management method according to the present invention uses a computer including a billing / payment information database for storing billing / payment information related to billing and depositing water bills. In the water charge management method for management, the water charge is charged and paid separately for the water supply and the sewage, and when there is an overpayment or refund that should be paid to the user of the water supply, Storing the amount information indicating the amount of the deposit or refund, and the billing / payment information related to the user from the billing / payment information stored in the billing / payment information database; Search for past unpaid portion according to water supply and sewage based on the amount information and the searched billing / payment information. Based on the first appropriation step for appropriating the overcharge or refund, and the amount information and the retrieved bill / payment information, the past unpaid portion relating to the water supply (or sewage) If the remaining amount of the overpayment or refund is not zero as a result of executing the process of applying the deposit or refund, the process of applying the remaining amount to the past unpaid portion relating to sewage (or tap water) A second allocation step to be executed, and the computer stores water and sewage allocation management information that defines which one of the first allocation step and the second allocation step is to be executed. The method further includes a step of selecting which of the first allocation step and the second allocation step is executed based on management information.

  In the water charge management method according to the invention, the first appropriation step and the second appropriation step are sequentially performed from the past unpaid portion according to the earliest claim when there are a plurality of past unpaid portions. The above-described process may be executed.

  Further, in the water rate management method according to the invention, the computer stores refund application method information indicating whether the computer performs a refund or appropriation process, and the overpayment to be paid to the user is You may make it further have a step which judges whether processing of refund or appropriation is performed about the overpayment based on the refund appropriation method information.

  Further, in the water charge management method according to the invention, the refund appropriation method information defines for each user whether to perform a refund or appropriation, and the determining step includes the refund appropriation method information. Based on this, it may be determined for each user whether to perform refund or appropriation for the overpayment.

  The water charge management method according to the invention further includes a step of extracting billing / payment information whose deposit amount is larger than the billing amount from the billing / payment information stored in the billing / payment information database. And storing the amount information includes amount information indicating the amount of the overdeposit specified based on the extracted billing / payment information, and a refund generated when the user's application for reduction or exemption is approved. The amount information indicating the amount of money may be stored.

  In addition, the water rate management device according to the present invention includes a billing / payment information database for accumulating billing / payment information related to billing and depositing water bills, and manages the water rate using the billing / payment information. In the management device, when an overpayment or refund to be paid to a user of water supply occurs, storage means for storing amount information indicating the amount of the overpayment or refund, and the billing / payment information database Is stored in the storage means and the search means for searching for the charge / payment information related to the user that has unpaid portion in the past from the charge / payment information stored in Based on the amount information and the billing / payment information retrieved by the retrieval means, a process of applying the overpayment or refund to the past unpaid portion for each of the water and sewage. Based on the amount of money stored in the storage means and the billing / payment information searched by the search means, the past unpaid portion relating to the water supply (or sewage) If the remaining amount of the overpayment or refund is not zero as a result of executing the process of applying the deposit or refund, the process of applying the remaining amount to the past unpaid portion relating to sewage (or tap water) A second water appropriation management information storage unit for storing water appropriation water management information for specifying which of the appropriation process by the first appropriation unit and the appropriation process by the second appropriation unit to be executed; Based on the water and sewage allocation management information stored by the water and sewage allocation management information unit, which of the allocation process by the first allocation unit and the allocation process by the second allocation unit is to be executed Characterized in that it comprises selecting means for-option.

  In the water charge management device according to the present invention, the first appropriation unit and the second appropriation unit sequentially start from the past unpaid portion according to the claim made first when there are a plurality of past unpaid portions. Alternatively, it may be configured to execute the process to be applied.

  Further, in the water rate management device according to the invention, a refund application method information storage unit for storing refund application method information indicating whether to perform refund or appropriation processing, and overpayment to be paid to the user And a determination means for determining whether to perform a refund or an appropriate process on the overcharge based on the refund application method information stored in the refund application method information storage means. It may be.

  Further, in the water rate management device according to the invention, the refund allocation method information determines for each user whether to perform refund or allocation, and the determination means is based on the refund allocation method information. And it may be constituted so that it may be judged for every user whether processing of refund or appropriation is performed about the overpayment.

  Further, in the water charge management device according to the invention, an extraction means for extracting billing / payment information whose deposit amount is larger than the billing amount from the billing / payment information stored in the billing / payment information database. The storage means includes amount information indicating the amount of the overdeposit specified based on the billing / payment information extracted by the extraction means, and a refund generated when the user's application for reduction or exemption is approved. It may be configured to store amount information indicating the amount.

  Further, a computer program according to the present invention is a computer program for causing a computer having a billing / payment information database for accumulating billing / payment information related to billing and payment of water bills to manage the water bill. In the event that an overpayment or refund to be paid to a user of the water supply occurs, a procedure for storing amount information indicating the amount of the overpayment or refund, and the charge / payment information database are stored. A procedure for searching for billing / payment information related to the user and having past unpaid portion, and the amount information and the searched billing / payment information. Based on the first appropriation to execute the process of appropriating the overpayment or refund to the past unpaid portion according to the water supply and sewage Based on the order, the amount information and the searched billing / payment information, execute the process of applying the overpayment or refund to the past unpaid portion related to tap water (or sewage), and as a result If the remaining amount of the overpayment or refund is not zero, the computer executes the second allocation procedure for executing the process of applying the remaining amount to the past unpaid portion relating to sewage (or tap water), Water and sewage allocation management information that defines which of the first allocation procedure and the second allocation procedure is to be stored is stored, and the first allocation procedure and the second allocation are based on the water and sewage allocation management information. This is for executing a procedure for selecting which of the allocation procedures to execute.

  In the computer program according to the invention, the first appropriation procedure and the second appropriation procedure are performed when the plurality of past unpaid portions exist, from the past unpaid portion according to the earliest claim made to the computer. You may make it perform the process to allocate sequentially.

  According to the water charge management method of the present invention, the water charge management apparatus for carrying out the method, and the computer program for causing the computer to carry out the method, when an overcharge or refund occurs for the water charge, These can be applied to past unpaid amounts.

  Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings.

    FIG. 1 is a block diagram showing a configuration of a water rate management apparatus 1 according to the present invention. As shown in FIG. 1, the water charge management apparatus 1 of this invention is provided with CPU10, and this CPU10 is connected with each hardware mentioned later via the bus | bath. The CPU 10 controls the operation of the hardware and executes a computer program loaded into the memory 11. Thereby, the water charge management apparatus 1 can perform the process mentioned later.

  The memory 11 is composed of, for example, a DRAM or an SRAM, and stores temporary data generated when the computer program is executed.

  The hard disk 12 is composed of a readable / writable magnetic disk, and stores an OS (Operating System) 101, a water charge management program 102 which is a computer program necessary for the operation of the water charge management apparatus 1, and various data. Yes. The hard disk 12 is provided with a plurality of databases (DB) as will be described later.

  The input unit 13 includes a keyboard and a mouse, and is used when an operator gives an instruction to the water rate management apparatus 1. The output unit 14 is composed of a CRT, a liquid crystal display, or the like, and displays a processing result or the like by the CPU 10.

  Details of the DB provided in the hard disk 12 will be described below.

[Billing / Payment Information DB]
The billing / payment information DB 103 stores billing / payment information related to billing for water charges and depositing for the billing.

  FIG. 2 is a conceptual diagram showing an example of a format of billing / payment information stored in the billing / payment information DB 103. As shown in FIG. 2, the billing / payment information includes a user number field 103a, a billing month field 103b, a water charge amount field 103c, a water charge amount field 103d, a sewage charge amount field 103e, and a sewage charge amount field 103f. Etc. each field. Hereinafter, information stored in each of these fields will be described.

  The user number field 103a stores a user number for identifying a water user, and the billing month field 103b stores billing month information indicating the year and month when the water bill was charged. In addition, the water charge amount information 103 indicating the charge amount of the water charge related to the water supply is paid in the water supply charge amount field 103c, and the water charge amount field 103d is paid for the charge of the water charge related to the water supply. The amount information for water supply indicating the amount of money received is stored. Similarly, the sewage billing amount field 103e contains sewage billing amount information indicating the amount billed for the sewage water charge, and the sewage deposit amount field 103f is the deposit amount paid for the bill for the sewage water bill. The sewage deposit amount information indicating is stored respectively.

  This billing / payment information is generated each time a water bill is billed and is registered in the billing / payment information DB 103. As will be described later, when there is a deposit for the billing, the billing / payment information is updated at an appropriate timing.

[Overpayment information DB]
The overpayment information DB 104 stores overpayment information related to overpayments generated in response to billing for water charges.

  FIG. 3 is a conceptual diagram showing an example of a format of overcharge information stored in the overcharge information DB 104. As shown in FIG. 3, the overpayment information includes a user number field 104a, a user name field 104b, a billing month field 104c, a water bill amount field 104d, a water bill amount field 104e, and a water bill amount field 104f. Sewage invoice amount field 104g, sewage deposit amount field 104h, sewage surcharge amount field 104i, overcharge reason field 104j, refund application method field 104k, management number section field 104l, management number field 104m, and the like. ing.

  The user number field 104a stores the above user number, the user name field 104b stores the name of the user identified by the user number, and the billing month field 104c stores the above billing month information. Yes.

  In addition, the above water billing amount information is stored in the water billing amount field 104d, the above water billing amount information is stored in the water filling amount field 104e, and the water billing amount field 104f corresponds to the amount of water billing. Stored in each case is information on the amount of overcharged water that indicates the amount of the overcharge generated for the payment. Similarly, the above-mentioned sewage billing amount information is generated in the sewage billing amount field 104g, the above sewage amount information is generated in the sewage deposit amount field 104h, and the sewage overcharge amount field 104i is generated in relation to the payment for the sewage billing amount. Sewage surcharge amount information indicating the amount of surcharge is stored.

  In addition, the overpayment reason field 104j shows the reason for overpayment (for example, “1” for double deposit, “2” for settling reduction (red water), settling reduction) In the case of (leakage), “3” etc.), refund application method information indicating whether to perform refund or appropriation processing in the refund appropriation method field 104k, and refund processing and appropriation processing in the management number classification field 104l The management number classification information indicating any of settlement reduction is stored, and the management number field 104m stores a management number for identifying processing such as refund or allocation.

[Appropriation information DB]
The allocation destination information DB 105 stores allocation destination information related to the allocation destination when the allocation process is performed.

  FIG. 4 is a conceptual diagram showing an example of the format of the allocation destination information stored in the allocation destination information DB 105. As shown in FIG. 4, the allocation destination information includes a user number field 105a, a billing month field 105b, a water billing amount field 105c, a water billing amount field 105d, a water bill not paid field 105e, and a water billing amount field 105f. Each field includes a sewage invoice amount field 105g, a sewage deposit amount field 105h, a sewage unpaid amount field 105i, a sewage allocated amount field 105j, a management number classification field 105k, a management number field 105l, and the like.

  The user number field 105a stores the above user number, and the billing month field 105b stores the above billing month information.

  In addition, the above water billing amount information is stored in the water billing amount field 105c, the above water billing amount information is stored in the water billing amount field 105d, and the billing amount of water is charged in the unpaid water amount field 105e. The amount of unpaid water information indicating the amount that has not yet been delivered, and the amount of water allocated that indicates the amount of overpayment, etc., applied to the unpaid amount of the water in the water supply amount field 105f. Each piece of information is stored. Similarly, the above-mentioned sewage billing amount information is delivered to the sewage billing amount field 105g, the above-mentioned sewage amount information is delivered to the sewage receipt amount field 105h, and the sewage billing amount field 105i is still delivered to the sewage billing amount. The sewage unpaid amount information indicating the amount that has not been allocated is stored, and the sewage allocated amount field 105j stores sewage allocated amount information that indicates the amount when the overpayment is allocated to the sewage unpaid amount.

  Further, the management number division field 105k stores the management number division information, and the management number field 105l stores the management number.

[User information DB]
The user information DB 106 stores user information related to water users.

  FIG. 5 is a conceptual diagram illustrating an example of a format of user information stored in the user information DB 106. As shown in FIG. 5, the user information includes fields such as a user number field 106a, a user name field 106b, and a refund application method field 106c.

  The user number field 106a contains the above user number, the user name field 106b contains the name of the user identified by the user number, and the refund application method field 106c contains the above refund application method information. Stored.

  The refund allocation method information may be arbitrarily determined by the user, or may be determined by the side collecting the water charge.

[Reduction application information DB]
The reduction / exemption application information DB 107 stores reduction / exemption application information for applying for reduction / exemption of water charges due to red water or water leakage.

  FIG. 6 is a conceptual diagram showing an example of a format of reduction / exemption application information stored in the reduction / exemption application information DB 107. As shown in FIG. 6, the reduction / exemption application information includes a user number field 107a, a billing month field 107b, a water bill amount field 107c, a water bill bill reduction amount field 107d, a water bill amount field 107e, and a water surcharge amount. Field 107f, sewage billing amount field 107g, sewage billing reduction amount field 107h, sewage receipt amount field 107i, sewage overcharge amount field 107j, reduction reason field 107k, application approval method field 107l, management number classification field 107m, and management number field Each field includes 107n.

  The user number field 107a stores the above user number, and the billing month field 107b stores the above billing month information.

  In addition, the above water bill information is shown in the water bill amount field 107c, and the water bill bill information is shown in the water bill bill field 107d. In addition, the above-mentioned water charge amount information is stored in the water charge amount field 107e, and the above water charge amount information is stored in the water charge amount field 107f, respectively. Similarly, the sewage billing amount field 107g contains the above sewage billing amount information, and the sewage billing reduction amount field 107h contains sewage billing amount information indicating a reduction amount with respect to the sewage billing amount realized by the reduction application. The sewage surcharge information is stored in the amount field 107i, and the sewage surcharge information is stored in the sewage overcharge field 107j.

  Further, the reduction reason field 107k has reduction reason information indicating the reason for reduction (for example, “red water”, “leakage”, etc.), and the application approval classification field 107l is information indicating whether or not a reduction / exemption application has been approved (for example, “1” when approving the reduction / exemption application, “2” when rejecting the approval, etc.), the management number division field 107m contains the above management number division information, and the management number field 107n contains the above management number. Each is stored.

[Deposit Information DB]
Deposit information DB 108 stores deposit information indicating deposits from water users.

  FIG. 7 is a conceptual diagram showing an example of the format of deposit information stored in the deposit information DB 108. As shown in FIG. 7, the deposit information includes each of a user number field 108a, a billing month field 108b, a water deposit amount field 108c, a sewage deposit amount field 108d, a management number classification field 108e, a management number field 108f, and the like. Has a field.

  The user number field 108a stores the above user number, and the billing month field 108b stores the above billing month information.

  Further, in the water deposit amount field 108c, the water deposit amount information indicating the amount of deposit for water is stored, and in the sewage deposit amount field 108d, sewage deposit amount information indicating the amount of deposit for sewage is stored. Has been.

  Further, the management number division field 108e stores the management number division information, and the management number field 108f stores the management number.

[Refund information DB]
The refund information DB 109 stores refund information related to a refund when a refund is made to the user as a result of a refund process described later.

  FIG. 8 is a conceptual diagram showing an example of the format of refund information stored in the refund information DB 109. As shown in FIG. 8, the refund information includes a user number field 109a, a user name field 109b, a billing month field 109c, a water bill amount field 109d, a water bill amount field 109e, and a water bill amount field 109f. , Sewage refund amount field 109g, sewage charge amount field 109h, sewage deposit amount field 109i, sewage overcharge amount field 109j, sewage refund amount field 109k, overcharge reason field 109l, refund application method field 109m, management number classification field 109n , And a management number field 109o.

  The user number field 109a stores the above user number, the user name field 109b stores the name of the user identified by the user number, and the billing month field 109c stores the above billing month information. ing.

  In addition, the water bill amount information 109d is in the water bill amount field 109d, the water amount information is in the water amount field 109e, and the water amount is in the water amount field 109f. The received water amount information, and the water return amount field 109g respectively store the water return amount information indicating the amount to be returned for the water. Similarly, the sewage billing amount field 109h includes the sewage billing amount information, the sewage deposit amount field 109i includes the sewage deposit amount information, the sewage overcharge amount field 109j includes the sewage subscription amount information, The sewage refund amount field 109k stores sewage return amount information indicating the amount to be returned for sewage.

  Further, the reason for overpayment field 109l includes the above reason for overpayment information, the refund application method field 109m includes the above refund application method information, the management number section field 109n includes the management number section information, and the management number field 109o. Each stores a management number.

[Management number information DB]
The management number information DB 110 stores management number information related to the management number.

  FIG. 9 is a conceptual diagram showing an example of the format of management number information stored in the management number information DB 110. As shown in FIG. 9, the management number information has fields such as a management number section field 110a and a latest management number field 110b.

  The management number section field 110a stores the management number section information described above, and the latest management number field 110b stores the latest management number indicating the latest management number that has not yet been assigned to each process.

  The latest management number may be set manually by the operator, or may be automatically set by the water rate management apparatus 1.

  Although not specifically mentioned below, the latest management number is automatically set, and the latest management number is appropriately stored in the management number field in each information.

[Water and wastewater allocation management information DB]
The water and sewage allocation management information DB 111 stores the water and sewage allocation management information indicating whether the allocation process of the water rate is performed separately between the water and the sewage or whether the allocation process is performed between the water and the sewage. To do.

  FIG. 10 is a conceptual diagram showing an example of the format of the water and sewage allocation management information stored in the water and sewage allocation management information DB 111. As shown in FIG. 10, the water and sewage allocation management information includes a water / sewage allocation field 111 a, and in this water / sewage pipe allocation field 111 a, for example, an allocation process is performed between water and sewage. When executing, “1” is stored, and when not executing, “2” is stored.

  Next, operation | movement of the water rate management apparatus 1 of this Embodiment comprised as mentioned above is demonstrated, referring a flowchart.

  FIG. 11 is a flowchart showing an operation flow of the water rate management apparatus 1 of the present invention when a reduction / exemption application is accepted.

  When receiving an application for water tax reduction due to red water / leakage from a water user, the operator inputs the application for reduction / exemption based on the contents of the application for reduction / exemption. Specifically, the operator inputs information to be stored in each field other than the application approval classification field 107l in the reduction / exemption application information described above with reference to FIG. To do.

  When the water charge management apparatus 1 receives the input of the reduction / exemption application information by the operator (S101), the reduction / exemption application information is registered in the reduction / exemption application information DB 107 (S102).

  Next, the water rate management apparatus 1 determines whether or not to approve a reduction / exemption application related to the reduction / exemption application information (S103). In addition, this determination may be performed by determining whether or not the operator confirms and approves the contents of the reduction / exemption application, and inputs the determined result to the water rate management apparatus 1. The water rate management device 1 may automatically perform the calculation by using a calculation formula or the like.

  When the approval of the reduction application is rejected in step S103 (NO in S103), the water charge management device 1 stores the information “2” indicating the rejection in the application approval classification field 107l, thereby reducing the reduction application information. The DB 107 is updated (S109).

  Then, the water rate management device 1 creates a reduction / exemption application rejection notice indicating that the reduction / exemption application has not been approved (S110). This reduction / exemption application rejection notice may be electronic data or printed on a paper medium. The notification of rejection of the reduction / exemption application created in this way is sent to the user who applied for reduction / exemption.

  On the other hand, if the reduction application is approved in step S103 (YES in S103), the water charge management device 1 stores the information “1” indicating that the application has been approved in the application approval classification field 107l. The information DB 107 is updated (S104).

  Next, the water rate management device 1 reads the billing / payment information related to the reduction / exemption application from the billing / payment information DB 103 (S105), and compares the billing / payment information with the reduction / exemption application information. Information is generated (S106).

  In addition, the water rate for the amount reduced or reduced by the application for reduction is usually a refund to be paid to the user of the water supply. As will be described later, it can be used for processing to be applied to the past unpaid portion.

  In this case, the overpayment reason field 104j of the overpayment information stores “2” indicating settling reduction (red water), “3” indicating settling reduction (leakage), and the like. The refund application method field 104k stores the refund application method information stored in the user application information refund application method 106c for the overcharge information.

  Then, the water charge management apparatus 1 registers the overpayment information generated in this way in the overpayment information DB 104 (S107), and further creates a settlement change notification indicating that the reduction / exemption application has been approved. (S108). Note that, as in the case of the above-described notice of rejection of reduction / exemption application, this settlement change notice may be electronic data or printed on a paper medium.

  FIG. 12 is a flowchart showing a flow of operation of the water rate management device 1 of the present invention when payment for billing is performed.

  When a water charge is billed to the user of the water supply, and then the user receives payment for the charge, the amount is entered by the operator separately for the water supply and the sewage.

  The water bill management apparatus 1 updates the billing / payment information DB 103 using the water supply amount and the sewage amount input as described above (S201).

  In addition, such an update process of the billing / payment information DB 103 may be performed each time a payment is made from each user, and when a predetermined number of deposits are made, these deposits are collectively performed. Also good.

  Next, the water charge management apparatus 1 extracts from the billing / payment information DB 103 billing / payment information in which overpayment has occurred due to double depositing, that is, billing / payment information in which the deposit amount is larger than the billed amount (S202). ).

  For each of the billing / payment information extracted in this way, the water charge management device 1 calculates the overpayment amount obtained by subtracting the billing amount from the deposit amount for each of the water supply and sewage, thereby obtaining the overpayment. Information is generated (S203).

  In this case, “1” indicating double payment is stored in the overpayment reason field 104j of the overpayment information. The refund application method field 104k stores the refund application method information stored in the user application information refund application method 106c for the overcharge information.

  And the water rate management apparatus 1 registers the overpayment information produced | generated in that way in overpayment information DB104 (S204).

  As described above, overpayment information is generated and registered in the overpayment information DB 104 when a reduction / exemption application is made and when payment for a claim is made. Below, operation | movement of the water rate management apparatus 1 of this invention in the case of performing refund or appropriation using the overpayment information produced | generated in this way is demonstrated.

  FIG. 13 is a flowchart showing a flow of operation of the water rate management device 1 of the present invention when refunding or appropriation is performed.

  First, the water rate management apparatus 1 searches the overpayment information DB 104 for overpayment information that has not been refunded or allocated (S301).

  Next, the water rate management device 1 determines whether to execute a refund process or an appropriation process for the overcharge related to the searched overcharge information (S302). This determination is made based on the refund application method information stored in the refund application method field 104k of the overpayment information.

  When it is determined in step S302 that the refund process is to be executed (refund in S302), the water rate management apparatus 1 generates refund information in which the refund amount is the refund amount indicated in the deposit information (S307). ), The generated refund information is registered in the refund information DB 109 (S308).

  Then, the water rate management device 1 creates a refund notice indicating that the refund process is to be performed (S309). This refund notice may be electronic data or printed on a paper medium, as in the case of the above-described reduction / exemption application rejection notice. The refund notice prepared in this way is sent to the user who made the overpayment.

  On the other hand, when it determines with performing an allocation process in step S302 (appropriation by S302), an allocation process is performed (S303).

  FIG. 14 is a flowchart showing an operation flow of the water rate management device 1 of the present invention in the allocation process.

  As shown in FIG. 14, the water rate management apparatus 1 first reads the water and sewage allocation management information (S401), and determines whether or not to allocate between the water and sewage based on the water and sewage allocation management information. (S402). Here, when it determines with not appropriating between water supply and sewage, the water rate management apparatus 1 reads the overpayment information currently processed (S409), and the user who concerns the overpayment information concerned The information on the billing / payment information for the item having past unpaid portion is searched (S410).

  Next, the water rate management apparatus 1 performs the process of appropriating the overcharge of the clean water in the oldest unpaid amount for the previous clean water (S411). Specifically, when there are a plurality of past unpaid portions for water supply, the oldest one is allocated in accordance with the overcharge amount stored in the overcharge amount field 104f of the overcharge information. The water allocation amount information to be stored in the water allocation amount field 105f of the previous information is generated. For example, if the overpayment amount for water supply is 3000 yen, 2000 yen is unpaid in February 2005, and 2500 yen is unpaid in March 2005, the first is February 2005 In order to ensure that the full amount of 2000 yen is appropriated, water supply appropriation information indicating 2000 yen is generated, and then the remaining amount of 1000 yen, which is the remaining amount of 2500 yen in March 2005, is to be appropriated. Water supply amount information indicating 1000 yen is generated.

  Similarly, in the case of sewage, the water rate management device 1 performs a process of appropriating sewage surcharges in the order of the unpaid portion of the past sewage (S412). Specifically, when there are a plurality of past unpaid portions for sewage, the oldest of them is ordered in accordance with the overcharge amount stored in the sewage overcharge amount field 104i of the overcharge information. Sewage allocation amount information is generated in the same manner as in the case. Thereafter, the water rate management apparatus 1 proceeds to step S304.

  On the other hand, when it is determined in step S402 that allocation between clean water and sewage is performed (YES in S402), the water rate management device 1 reads overpayment information currently being processed (S403). ) And billing / payment information about the user related to the overpayment information, in which past unpaid portion exists (S404).

  Next, the water rate management device 1 determines whether or not there is a past unpaid portion for the water supply (S405), and if it is determined that it does not exist (NO in S405), the process proceeds to step S407. On the other hand, when it determines with existing (it is YES at S405), the water rate management apparatus 1 performs allocation in the order from the oldest amount of unpaid water supply similarly to step S411 mentioned above (S406).

  Next, the water rate management apparatus 1 determines whether or not there is a past unpaid portion for sewage (S407), and if it does not exist (NO in S407), the process proceeds to step S304. On the other hand, when it determines with existing (it is YES at S407), the water rate management apparatus 1 performs appropriation in order of the oldest amount of sewage unpaid (S408). In this case, as a result of the appropriation in step S406, if there is still a remaining amount in the water supply overcharge amount, an amount obtained by adding the overcharge amount stored in the sewage overcharge amount field 104i of the overcharge information to the remaining amount, It becomes the amount appropriated. That is, for example, if there is a remaining amount of 1000 yen in the amount of the sewage surplus as a result of the appropriation in step S406, if the amount of sewage surplus is 2000 yen, the amount of sewage surplus 2000 will be added to this remaining amount of 1000 yen 3000 yen including the yen will be used for unpaid sewage.

  In this embodiment, the water supply is allocated first, and in that case, when the remaining amount is generated in the overcharge, the remaining amount is processed to be applied to the unpaid portion of the sewage. If there is a remaining amount in the overpayment, the remaining amount may be applied to the unpaid portion of the water supply.

  The water charge management device 1 uses the above-mentioned water supply allocation amount information generated as a result of the processing in step S406 or S411 and the sewage allocation amount information generated as a result of the processing in step S408 or S412. Is generated (S304), and the generated allocation destination information is registered in the allocation destination information DB 105 (S305).

  Then, the water rate management device 1 creates an appropriation notice indicating that appropriation processing is performed (S306). This allocation notice may be electronic data or printed on a paper medium, as in the case of the above-described reduction / exemption application rejection notice. The appropriation notice created in this way is sent to the user who made the overpayment.

  FIG. 4 shows an example of appropriation information for the same user when the unpaid water amount in the charge in February 2005 is 2330 yen and the unpaid amount in the water charge in March 2005 is 2415 yen. It is shown. In this case, assuming that the amount of water supply surcharge is 2850 yen as in the example of the overpayment information shown in FIG. 3, 2330 yen of that amount will be allocated to the amount of unpaid water in the claim in February 2005, As a result, “2330 yen” is generated and stored as the water allocation amount information for the billing month. Next, the remaining amount of 520 yen, which is the remaining amount of the water supply surplus, is applied to the unpaid amount of the water in the claim in March 2005, and as a result, “520 yen” is generated as the water supply amount information for the billing month. Stored.

  In addition, when overcharge occurs, the water rate management device 1 generates deposit information using the overpayment as a deposit when neither the above-described allocation process nor the refund process is performed. Information is registered in the deposit information DB 108. The deposit shown in the deposit information will be used later in the appropriation process or refund process.

  The water rate management method, the water rate management device, and the computer program according to the present invention can execute allocation processing for past unpaid portions, and therefore a computer for water rate management that is desired to reduce loss processing Useful for systems and the like.

It is a block diagram which shows the structure of the water rate management apparatus of this invention. It is a conceptual diagram which shows an example of the format of the billing / payment information memorize | stored in billing / payment information DB. It is a conceptual diagram which shows an example of the format of the overpayment information memorize | stored in overpayment information DB. It is a conceptual diagram which shows an example of the format of the allocation destination information memorize | stored in allocation destination information DB. It is a conceptual diagram which shows an example of the format of the user information memorize | stored in user information DB. It is a conceptual diagram which shows an example of the format of the reduction / exemption application information memorize | stored in reduction / exemption application information DB. It is a conceptual diagram which shows an example of the format of the deposit information memorize | stored in deposit information DB. It is a conceptual diagram which shows an example of the format of the refund information memorize | stored in refund information DB. It is a conceptual diagram which shows an example of the format of the management number information memorize | stored in management number information DB. It is a conceptual diagram which shows an example of the format of the water and sewage allocation management information memorize | stored in water and sewage allocation management information DB. It is a flowchart which shows the flow of operation | movement of the water rate management apparatus of this invention in the case of receiving a reduction / exemption application. It is a flowchart which shows the flow of operation | movement of the water rate management apparatus of this invention when the payment with respect to a claim is performed. It is a flowchart which shows the flow of operation | movement of the water rate management apparatus of this invention in the case of performing refund or appropriation. It is a flowchart which shows the flow of operation | movement of the water rate management apparatus of this invention in an allocation process.

Explanation of symbols

1 Water charge management device 10 CPU
11 Memory 12 Hard Disk 13 Input Unit 14 Output Unit 101 OS
102 Water Charge Management Program 103 Billing / Payment Information DB
104 Overpayment information DB
105 Allottee information DB
106 User information DB
107 Exemption application information DB
108 Deposit information DB
109 Refund information DB
110 Management number information DB
111 Water and Sewage Allocation Management Information DB

Claims (12)

In a water charge management method for managing water charges using a computer equipped with a charge / payment information database for accumulating billing / payment information related to billing and payment of water charges,
The water charges are billed and deposited separately for water and sewage,
A step of storing amount information indicating the amount of the overpayment or refund when an overpayment or refund to be paid to a user of the water supply occurs;
Searching billing / payment information related to the user from among the billing / payment information stored in the billing / payment information database, and having a past unpaid portion,
Based on the amount information and the searched billing / payment information, a first appropriation step of executing a process of apportioning the overpayment or refund to the past unpaid portion for each of water and sewage,
Based on the amount information and the retrieved billing / payment information, a process of applying the overpayment or refund to the past unpaid portion relating to tap water (or sewage) is executed, and as a result, the overpayment or A second appropriation step of executing a process of appropriating the remaining amount to the past unpaid portion relating to sewage (or tap water) if the remaining amount of the refund is not zero;
Have
The computer stores water and sewage allocation management information that defines which of the first allocation step and the second allocation step is executed,
The water rate management method further comprising a step of selecting which of the first allocation step and the second allocation step is executed based on the water and sewage allocation management information . The first appropriation step and the second appropriation step , when there are a plurality of past unpaid portions, execute the process of sequentially applying the past unpaid portion according to the most recent claim. Item 1. A water charge management method according to item 1. Stores refund application method information indicating whether the computer performs a refund or appropriation process,
The method further comprises a step of determining whether to perform refund or appropriation processing for the overpayment based on the refund appropriation method information when an overpayment to be paid to the user occurs. The water charge management method according to 1 or 2. The refund allocation method information defines for each user whether to perform refund or allocation,
The water rate management method according to claim 3, wherein the determining step determines, based on the refund appropriation method information, whether to perform refund or appropriation for the overpayment for each user. A step of extracting billing / payment information whose deposit amount is larger than the billing amount from the billing / payment information stored in the billing / payment information database;
The step of storing the amount information includes the amount information indicating the amount of the overdeposit specified based on the extracted billing / payment information, and the amount of refund generated when the user's application for reduction or exemption is approved. The water rate management method according to any one of claims 1 to 4, further comprising storing money amount information indicating In a water charge management device that has a charge / payment information database for accumulating billing / payment information related to billing and payment of water charges, and manages water charges using the billing / payment information,
Storage means for storing amount information indicating the amount of the overpayment or refund when an overpayment or refund to be paid to a user of water supply occurs;
Search means for searching for billing / payment information relating to the user from among the billing / payment information stored in the billing / payment information database;
Based on the amount information stored in the storage means and the billing / payment information retrieved by the retrieval means, a process of applying the overpayment or refund to the past unpaid portion for each of the water and sewage is executed. First assigning means to
A process of applying the overpayment or refund to the past unpaid portion relating to tap water (or sewage) based on the amount information stored in the storage unit and the billing / payment information searched by the search unit And, as a result, when the remaining amount of the overpayment or refund is not zero, a second appropriation means for executing the process of applying the remaining amount to the past unpaid portion relating to sewage (or tap water);
A water and sewage allocation management information storage unit that stores water and sewage allocation management information that defines which one of the allocation process by the first allocation unit and the allocation process by the second allocation unit is to be executed;
Selection means for selecting which one of the allocation process by the first allocation means and the allocation process by the second allocation means is to be executed based on the water and sewage allocation management information stored by the water and sewage allocation management information means; A water charge management device comprising: The first appropriation means and the second appropriation means , when there are a plurality of past unpaid portions, execute the process of sequentially applying the past unpaid portions according to the most recently made claim. The water rate management apparatus according to claim 6, which is configured. A refund application method information storage unit for storing refund application method information indicating whether to perform a refund or an appropriation process;
When overpayment to be paid to the user occurs, either refund or appropriation is performed on the overpayment based on the refund application method information stored in the refund application method information storage means Determination means for determining whether or not
The water rate management device according to claim 6 or 7, further comprising: The refund allocation method information defines for each user whether to perform refund or allocation,
The water supply according to claim 8, wherein the determination unit is configured to determine, for each user, whether to perform refund or appropriation for the overpay based on the refund appropriation method information. Charge management device. An extraction means for extracting billing / payment information whose deposit amount is larger than the billing amount from the billing / payment information stored in the billing / payment information database;
The storage means includes amount information indicating the amount of overpayment specified based on the billing / payment information extracted by the extraction means, and the amount of refund generated when the user's application for reduction or exemption is approved. The water rate management device according to any one of claims 5 to 9, wherein the water rate management device is configured to store money amount information to be displayed. In a computer program for causing a computer equipped with a billing / payment information database to store billing / payment information related to billing and payment of water bills to manage water bills,
In the computer,
A procedure for storing amount information indicating the amount of the overpayment or refund when an overpayment or refund to be paid to a user of the water supply occurs;
A procedure for searching for billing / payment information relating to the user from among the billing / payment information stored in the billing / payment information database,
Based on the amount information and the searched billing / payment information, a first appropriation procedure for executing the process of apportioning the overpayment or refund to the past unpaid portion for each water and sewage,
Based on the amount information and the retrieved billing / payment information, a process of applying the overpayment or refund to the past unpaid portion relating to tap water (or sewage) is executed, and as a result, the overpayment or If the remaining amount of the refund is not zero, the second allocation procedure is executed to execute a process to allocate the remaining amount to the past unpaid portion relating to sewage (or tap water) ,
The computer stores water and sewage allocation management information that defines which of the first allocation procedure and the second allocation procedure is executed,
A computer program for executing a procedure for selecting which of the first allocation procedure and the second allocation procedure to execute based on the water and sewage allocation management information . In the first allocation procedure and the second allocation procedure , when there are a plurality of the past unpaid portions, the computer sequentially performs the process of performing the allocation from the past unpaid portion according to the claim made first. The computer program according to claim 11, which is executed.

Images