JP2007179420A - Fee calculating system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a fee calculating system not depending on a system, and capable of easily and quickly correcting a fee, on the basis of databases respectively constructed per company used in provision of energy in an energy supplying company. <P>SOLUTION: The fee calculating system has a means for sending information of a data list, and meter reading information to a calculation layer, the calculation layer calculating a used amount of energy on the basis of the transmitted information, a means for sending a calculation result calculated by the calculation layer, and a means for creating a meter reading calculation result integrating the sent calculation result and pieces of information necessary for calculation. Information of the meter reading calculation result is stored in a database of a host computer. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention is a system that can accurately calculate according to the charge system using different databases when calculating electricity charges, gas charges, and water charges, and extracts necessary data from the data in the original database. The present invention relates to a system that creates a common variable area from the table and encapsulates unit price information and a calculation formula to calculate a charge.

Conventionally, for example, with regard to electricity charges, etc., one charge calculation has been performed using a charge system that is extremely detailed and based on contract types, contract details, and the like.
In other words, when it comes to electricity charges, flat-light rate structure, metered-rate charge structure, temporary light charge structure, public street light charge structure, low-voltage power charge structure, high-voltage power charge structure, and temporary power charge structure It is divided into two categories, such as agricultural power charges and special high-voltage charges.
Among them, for example, the charge system for metered lamps often used in ordinary households is determined according to the amperage of the contract as 10A, 15A, 20A, 30A, etc. as the basic charge, and further as the first stage as the electricity charge It is calculated by adding based on the charge, the second stage charge, and the third stage charge.

Furthermore, the current electricity charges include a fee structure such as a discount charge system based on hourly lamps, a discount charge system based on seasonal hourly lamps, or a charge system as late-night electricity, as a selection clause.
Therefore, at present, electricity charges are calculated based on such various charge systems.
In this case, for example, for meter reading and calculation of the amount of electricity used in ordinary households, the number of meter reading instructions of each household watt-hour meter is input by holding a portable terminal, and the number of previous instructions and this instruction The number of charges and the estimated billing amount calculated using both are presented to each household, and the number of instructions entered in the terminal is stored in the database on the host side on the current day or the next day, and the final data is stored using the stored data. Calculations are made to calculate the fixed price of electricity charges and charge each household.

Furthermore, there are many different databases used by electric power companies, and charge calculation and customer management are performed using an extremely wide variety of systems.
Accordingly, it is necessary to sequentially maintain the changes in accordance with each system, that is, the form in accordance with the latest system.
Furthermore, as a system for performing more detailed management, JP 2004-362326 (Patent Document 1), as a system for preventing mishandling, JP 2004-295413 (Patent Document 2), and an estimated charge amount can be notified. Japanese Patent Laid-Open No. 2003-61263 (Patent Document 3) and Japanese Patent Application Laid-Open No. 2002-175656 (Patent Document 4) that enable online settlement exist.
All of these were done in consideration of how accurately and accurately the fee to be revised can be calculated and managed.
JP 2004-362326 A JP 2004-295413 A JP 2003-61263 A JP 2002-175666

As described above, there are various charge calculation systems and customer management systems used for calculating charges such as electricity charges, gas charges, and water charges.
As mentioned above, these are systems created under individual circumstances based on the fee structure at that time, and various improvements were made in response to changes in the fee structure, etc. It is calculated by taking steps.
Therefore, when a new fee system that starts newly in the future appears, it is necessary to make further improvements in the environment, and when this system is operated and calculated, it can be an extremely complicated system.

In addition, if there is a change in the fee structure or if the fee itself is revised, that is, if the unit price is raised or lowered, it is necessary to calculate the fee according to those changes. As a result, apportionment calculation based on the meter reading date and the fee revision date occurs, and it is extremely difficult to perform this calculation well.
Further, according to Patent Document 1, it is meaningful in creating individual data, but it is not useful for each of the above problems.
Further, according to Patent Document 2, it is meaningful in that an error can be made and accurate meter reading can be performed, but accurate calculation cannot be performed due to a charge revision or the like.

With regard to Patent Document 3, it is effective in that a server computer is installed in each customer's house and the latest data can be used to calculate the basic expected amount or the usage fee at a specific point in time using the usage data. In some cases, the system itself is premised on the construction of accurate data on the host side, and the host side must be revised as well as the fee system revision.
Therefore, it is necessary to modify the system itself in a very complicated and diverse manner, and it takes a lot of cost as well as labor.
Further, Patent Document 4 is a system that transmits meter reading values, collects meter reading values, and creates a slip based on the meter values, and operates as a whole system in the position system. It is to maintain a responsive system.

Therefore, a system corresponding to each is required, and further, when there is a change in charge system or a change in charge, it is naturally necessary to modify the entire system.
As described above, in the conventional system, it is necessary for each company to construct a system according to the basic system on each host side, and there are changes and revisions to the fee system or revisions to the fee that are currently being carried out extremely frequently. In such a case, it takes time to correct the entire system or to calculate the number of steps using a correction program each time, which requires not only high cost but also heavy time.
In particular, the competition is intensifying due to the liberalization of electric power, etc., and it is a system that can be easily modified at a low cost and with a change in the charge system or a revision of the charge, and the charge calculation can be easily performed. It is desired to provide a system that can be used even in a special environment system that is individually constructed for various companies.

Therefore, the invention according to claim 1 of the present invention extracts a data in a database of a host computer operating in an arbitrary system, creates a data list, and uses energy by another system based on the data list. A charge calculation system for calculating a usage fee of an amount, a means for sending data list information and meter reading information to a calculation layer, a calculation layer for calculating an energy usage based on the sent information, Means for sending the calculation results calculated by the calculation layer, means for creating a meter reading calculation result that summarizes the sent calculation results and necessary information for the calculation, and information on the meter reading calculation results is stored in a database of the host computer. The fee calculation system is stored in the system, and the problems can be solved by the invention.
Alternatively, as in the invention according to claim 2, an extracting means for extracting data in the database of the host computer, a means for creating a data list based on the extracted information, a means for inputting meter reading information, and a data list The information to be stored in the memory and the meter reading result information are extracted and sent to the calculation layer, and the calculation result sent by the calculation layer is sent to the control layer, and the information is sent in advance based on the information sent by the calculation layer control means. Means comprising a calculation layer for calculating usage based on the billing system, means for creating a meter reading calculation result based on the calculation result sent by the control means of the calculation layer, and information on the meter reading calculation result A charge calculation system having means for storing the data in a host computer, and extracting information in a database of the host computer based on the one system to obtain data A list is created, energy usage is calculated based on the meter reading results without depending on the host computer system based on the information stored in the data list, and the calculation results are stored in the host computer database. A charge calculation system may be used.

  Furthermore, as in the invention according to claim 3, there is provided a charge calculation system for calculating a use charge for energy consumption, a means for extracting arbitrary information in a database of a host computer, and the extracted information A means for creating a data list, a means for extracting information for performing arbitrary calculation from the information extracted in the data list, a means for inputting meter-reading information on energy usage, and calculating a usage fee Means for controlling the calculation layer to extract the respective information to be extracted from the data list and the meter reading result information and to send the calculation result to the means comprising the calculation layer and to collect the calculation result as data of the examination calculation result And means comprising a calculation layer for calculating a charge for the usage amount using a calculation formula having a unit price information for the usage amount of energy in advance, and the calculation result A charge calculation system having means for collecting as needle calculation result information, and means for storing information extracted from the collected data as a calculation result update in a database of the host computer. Data is extracted from the information in the database by means of extracting it, a data list is created based on this information, and meter reading is performed by a system independent of the host computer system based on the information stored in this data list. Even when using a charge calculation system that calculates energy usage based on the results and then summarizes the calculation results as information on the calculation results and stores them in the database of the host computer, the same as above The problem can be solved.

In these cases, the information based on the data list sent from the database of the host computer to the server is stored in the portable terminal for meter reading as in the invention according to claim 4, the meter reading information is input to the portable terminal for meter reading, Charge calculation that can identify the information of meter reading calculation results based on the input meter reading information and data list information, print the information, and store the information of meter reading calculation results in the database of the host computer via the server By using the system, it can be used more effectively during meter reading.
In this case, as in the invention according to claim 5, the metering portable terminal may be a charge calculation system capable of calculating the amount of energy used based on the meter reading information and the data list information.

Alternatively, as in the invention according to claim 6, the extraction of data from the database of the host computer is based on a preset item correspondence table, and the extracted information is stored in a preset data list. Accordingly, a charge calculation system that extracts and stores information to be calculated may be used.
Furthermore, a charge calculation system corresponding to a change in charge may be made by changing the usage charge and / or charge system of the calculation layer as in the invention according to claim 7, and in particular, the energy as in the invention according to claim 8. If this is a charge calculation system used for electricity charges, the system can be used most effectively.

Because of the above configuration, first, according to each of the inventions of claims 1 to 3, customers of each type of host computer system that is different for each company that manages the amount of energy used are stored in the database in the system. Information and necessary information for usage calculation can be extracted, and a charge calculation system that can calculate energy consumption based on this information can be provided. It is not dependent on the system, and can be calculated by the system.
Further, the result of calculation processing can be stored in a database on the host side.

With the above configuration, even when using various different host-side systems and server-side systems, it is possible to calculate unique usage charges independent of these systems. is there.
Furthermore, not only can the complex and remarkably intertwined fee structure be revised as the usage fee is revised, but the change in the fee structure and amount can be dealt with immediately, and the system on the host side that is already in operation can be handled. No need to add.
Accordingly, it is possible to sequentially correct, add, and add to the fee calculation, various corrections, and update items without correcting the existing extremely sophisticated and complicated host.

Next, according to the invention according to claim 4 or 5, the present system can be applied to a portable terminal for meter reading, and the meter reading information can be effectively utilized and the latest calculation processing can be performed in the portable terminal by the present system. It will be possible.
Therefore, it is possible to distribute information that properly copes with the revision of the fee system or the change of the amount of money to each home at the time of meter reading.
According to the sixth aspect of the invention, it is possible to easily extract the usage when necessary in the host-side database.
Furthermore, according to the invention according to claim 7, when the charge system is modified or revised or the charge is changed, it can be dealt with by simply modifying the calculation layer in the present system. Can provide.

  In addition, if this system is used for calculating the amount of power used as in the invention according to claim 8, it is possible not only to deal with a very complicated fee structure and a large number of fee revisions, but also to be extremely special and enormous. This charge calculation system is independent of the basic system of the electric power company, and meter reading data update and charge calculation in various different systems can be performed very efficiently.

FIG. 1 is a diagram showing an example of a basic flow according to the present invention.
In other words, this system consists of a system that performs meter reading as appropriate for the usage amount of energy and the like to calculate the usage fee for the latest data.
This figure clearly shows the charge calculation system for energy, particularly power.
First, calculation target customer information is extracted from a database based on a system such as a power company on the host side, and a data list is created based on the extracted customer information.
Information necessary for charge calculation is extracted from this data list.

For example, customer number, contract type, date of revision, date of previous meter reading, date of current meter reading, late payment fee, unpaid estimated fee, contract start date, contract contents clause, number of instructions for calculation, current instruction It is the usage fee for the second meter reading, the previous usage amount, etc.
With respect to these clauses, some data are extracted for one clause, and many data are extracted for one clause.
These extractions are performed using an extraction item item correspondence table for selecting and specifying extraction items, and it is possible to create a separate data list using the extracted data and perform processing based on this data list. Therefore, a layer independent of the system environment is configured.
Next, a message composed of a fixed data list is created from the extracted data, and a common variable area in which data that can be commonly used is collected via a driver is set.

Thus, for example, necessary items can be picked up from different systems used in each electric power company, and certain items necessary for calculation can be used from each company's system by extracting calculation target customer information that is a physical compatibility layer.
Of course, the information in the data list can be appropriately picked up and calculated via the driver, or information in the common variable area may be used.
Next, a new numerical value is input by the meter reading process and can be extracted and calculated as necessary.
Furthermore, using the data list information and the common variable area data, the calculation variable area data used in the calculation layer is created.

This calculation layer is a program group for executing a calculation formula having unit price information for each contract type defined in the electricity supply agreement.
This unit price and calculation formula can be easily modified separately.
A control layer for controlling the calculation layer is provided for this calculation layer.
This control layer sends necessary data to the calculation layer and receives calculation results.
Further, it is input to the calculation result variable area, and the calculation result is accumulated as data.
Further, a message of a data list is created for this data as a meter reading result via a driver.

This data is compiled as information on the meter reading calculation result, and further, the calculation result that is the physical compatibility layer is updated and stored as data in the original database.
As described above, first, necessary items are extracted from various different systems, thereby creating a data list and common variable area that are independent of the system environment, and extracting data using this data list and common variable area. To calculate.
Furthermore, the calculation result is used as a calculation result variable area, a data list is created, and further collected as data of the meter reading calculation result. To be stored.

Therefore, for example, when using different operating systems for different electric power companies, using different database systems or structures, different data item attributes, completely different code systems, etc. It can be independent of the system environment of the system.
Furthermore, even in the case of a charge revision, the electricity charge can be easily calculated by modifying the calculation layer.

FIG. 2 is a diagram showing a series of flow of meter reading processing of the present system.
As shown in the figure, first, data for meter reading is extracted from the database of the electric power company, and this data is transmitted to the server of each sales office.
In other words, all items necessary for charge calculation and all items necessary for terminal meter reading are specified, and these are extracted and extracted as meter reading data.
This data may be sent as message information in a data list that matches this system, or data in the common variable area, or the data necessary for the operation of this system in the mobile terminal is specifically extracted. May be transmitted.

In this figure, as an example, necessary items are extracted from an item correspondence table and this data is transmitted.
The server side, that is, the sales office, downloads this data to the portable terminal and performs meter reading.
In this case, the terminal is controlled by a Java (registered trademark) environment or the like.
For example, the meter reading data by the meter reader can be stored together with the data before meter reading in the terminal, and a charge calculation routine can be provided to give a calculation result, which can be printed and provided for each door.

For example, it is possible to extract data necessary for creating a notification, such as notification of electricity bills, the number of instructions at the time of meter reading, the number of previous instructions, and create a notification, that is, a print of information.
This meter reading result is input and stored in the portable terminal, and this data is further input to the server of the sales office and transmitted to the host side.
The host side that has received the transmission receives this data as a meter reading result update, and stores the meter reading result in a database.
At this time, update information is created as meter reading result update data using the update correspondence table, and this is stored in the database.
Next, the electric power company calculates the amount of electricity used and extracts the settling time for charging.

The extracted data, that is, the data for adjustment is calculated for a fee in a Java (registered trademark) environment or the like.
As a result, the calculation routine is not constrained by the type of the power company system, and the calculation can be performed independently.
The calculation result is calculated according to the calculation routine of the present system, and the calculation result can be updated as calculation result data, thereby enabling billing.
The calculation result is updated together with the charge, etc., and the data is created and stored in the database using an update item correspondence table or the like that creates conventional data and calculation result data as calculation result update data.

FIG. 3 is a diagram simply showing the independence of the present system on the system environment. The calculation target customer information is extracted from the host system of the electric power company.
By extracting this data, a separate message, that is, a data list is created.
By performing meter reading and calculation along this data list, data processing can be performed without being constrained by the power company system.
Furthermore, even if the meter readings change due to a change in the charge system or a change in the charge, it is only necessary to change the data list etc., and there is no need to change the system of a major power company. Is.

Furthermore, even if a calculation routine changes due to a change in charge system or a change in charge, it is only necessary to modify the calculation module, and a system that can easily cope with the correction can be provided.
Next, the results of meter reading / calculation are further created as a message, that is, a data list, and this data may be stored in the host-side database as meter reading / calculation result update data.
Therefore, it is only necessary to transfer and manage a unique system such as a power company as before.

FIG. 4 is a diagram illustrating an example of a procedure for creating an item correspondence table for extracting necessary items from different systems of each electric power company.
For example, an item correspondence setting screen is provided, and necessary items such as an acquisition source table and an acquisition source item name are set in this figure, and a system type of the electric power company is selected.
As a result, an item correspondence table is created.
Further, based on this, an extraction program is automatically generated to extract necessary items from the power company database and create a data list as a message.
As a result, a data table having independence on the system environment can be created very easily, and the system can be operated based on the data table.

As described above, this system creates a data list by extracting data in the database of the host computer running on any system, sends the data list information and meter reading information to the calculation layer, and based on this information The amount of energy used is calculated by the calculation layer, and the calculation result is sent, and the meter reading calculation result including the information is created and stored in the database of the host computer.
In particular, the data in the database of the host computer is extracted to create a data list and meter reading information is input, and arbitrary data from these data is sent to the calculation layer by the control means and calculated by the calculation layer, In this calculation layer calculation, the usage is calculated based on the fee structure inputted in the pre-calculated external variable area.

Accordingly, information such as a result obtained by this calculation is created as a meter reading calculation result, and this information is further stored in the host computer.
From this, information in the database of the host computer based on one system is extracted to create a data list, and further, the meter reading result is obtained without depending on the host computer system based on the information stored in this data list. Based on this, it is possible to calculate the amount of energy used, and it is also possible to store the calculation result in a database of the host computer.

  The present invention is a system for calculating charges using information in a host-side database that does not depend on a host-side database system or an operation system, etc., and extracts information in the database and uses this to extract data Create a list, calculate charges using a calculation formula with unit price information, etc., and store the results in a database. Use hardware resources of the computer and perform processing accurately. Therefore, the present invention has industrial applicability.

The figure which shows an example of the basic flow concerning this invention Diagram showing a series of flow of meter reading processing of this system A diagram showing the independence of this system on the system environment The figure which shows an example of the creation procedure of the item correspondence table for extracting a necessary item from a different system of each electric power company

Claims (8)

A fee calculation system that extracts data in a database of a host computer that operates in an arbitrary system, creates a data list, and calculates a usage fee of energy usage by another system based on the data list,
Means for sending data list information and meter reading information to the calculation layer;
A calculation layer for calculating the amount of energy used based on the sent information;
Means for sending a calculation result calculated by the calculation layer;
Means for creating a meter reading calculation result that summarizes the calculated calculation result and necessary information for calculation;
A charge calculation system characterized by storing information on the meter reading calculation result in a database of a host computer. Extraction means for extracting data in the database of the host computer;
Means for creating a data list based on the extracted information;
Means for inputting meter reading information;
Means for controlling the calculation layer to extract the information stored in the data list and the meter reading result information and send it to the calculation layer and send the calculation result calculated by the calculation layer;
Means comprising a calculation layer for calculating a usage amount based on a fee structure inputted in advance based on information sent by the control means of the calculation layer;
Means for creating a meter reading calculation result based on the calculation result sent by the control means of the calculation layer;
A charge calculation system having means for storing information of the meter reading calculation result in a host computer,
Create a data list by extracting information in the database of the host computer based on one system,
Based on the information stored in this data list, the energy consumption is calculated based on the meter reading results without depending on the host computer system.
A charge calculation system characterized by further storing calculation results in a database of a host computer. A charge calculation system that calculates a usage charge for energy consumption,
Means for extracting arbitrary information in the database of the host computer;
Means for creating a data list based on the extracted information;
Means for extracting information for performing arbitrary calculation from the information extracted in the data list;
Means for inputting meter reading information of energy usage;
Each of the information for calculating the usage fee is extracted from the data list and meter reading result information and sent to the means consisting of the calculation layer, and the calculation result is sent to the means for collecting the calculation results as data of the examination calculation result. A means of controlling,
Means comprising a calculation layer for calculating usage charges using a calculation formula having unit price information of usage charges for energy usage in advance;
Means for collecting the calculation results as information on the meter reading calculation results;
A charge calculation system having means for storing information extracted from the collected data as a calculation result update in a database of a host computer,
Data is extracted from the information in the database of the host computer based on one system by means of extracting it, a data list is created based on this information, and the host computer's database is created based on the information stored in this data list. A charge calculation system that calculates the amount of energy used based on the meter reading result by a system independent of the system, and further stores the calculation result as information of the calculation result and stores it in the database of the host computer. . Information based on the data list sent from the host computer database to the server is stored in the portable terminal for meter reading.
Enter meter reading information into the meter reading portable terminal,
Based on the entered meter reading information and data list information, the meter reading calculation result information can be specified and the information can be printed,
The charge calculation system according to any one of claims 1 to 3, wherein information on the meter reading calculation result can be stored in a database of a host computer via a server. 5. The charge calculation system according to claim 4, wherein the metering portable terminal can calculate the amount of energy used based on meter reading information and data list information. The extraction of data from the host computer database is based on a preset item correspondence table, and the information to be calculated is extracted by storing the extracted information in a preset data list. 5. The charge calculation system according to claim 1, wherein the charge calculation system is stored. 7. The charge calculation system according to claim 1, wherein the charge calculation system corresponds to a change in charge by changing a use charge and / or charge system of the calculation layer. The fee calculation system according to claim 1, wherein the amount of energy used is the amount of power used.

Images