JP2010020507A - Charge calculation system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a charge calculation system allowing rapid coping with addition or a change of a charge plan, and allowing easy coping with another company in the same trade or another business category, too. <P>SOLUTION: This charge calculation system has a package development company side charge calculation system 7 and a use enterprise side charge calculation system 8 of a package use enterprise. The package development company side charge calculation system 7 integrates and manages charge calculation logic in a plurality of package use enterprises, and creates a charge calculation table 4 wherein demanded money amounts are associated to a plurality of pieces of input information based on the charge calculation logic. The use enterprise side charge calculation system 8 manages the charge calculation table 4 created by the package development company side charge calculation system 7 as a secondary table, performs charge calculation based on a retrieving table wherein partial data are extracted from the secondary table and the plurality of pieces of the input information, and decides the demanded money amount. <P>COPYRIGHT: (C)2010,JPO&INPIT

Description

  The present invention relates to a charge calculation system for determining a charge charged to a consumer in a gas, an electric power company or the like, and more particularly to improving the efficiency of the calculation process.

  2. Description of the Related Art Conventionally, in a system for calculating a charge charged to a consumer in an electric power, gas company, or the like, an individual program is created for each charge plan, for example, described in Japanese Patent Application Laid-Open No. 2001-94688 (Patent Document 1) "Invoice creation method and its implementation apparatus and recording medium on which the processing program is recorded", "Contract fee management system by table driven system" described in Japanese Patent Application Laid-Open No. 2005-241318 (Patent Document 2), etc. There was a table-driven form in which the result of charge calculation was calculated with a combination of various functions.

Further, although not in the field of electric power, gas companies, etc., as a technology for calculating charges using a table, Japanese Patent Application Laid-Open No. 11-39385 discloses that a table is prepared in advance when calculating charges. There has been a “medium for recording a method for calculating a shipping amount and a calculation program for a shipping amount” described in the publication (Patent Document 3).
JP 2001-94688 A JP-A-2005-241318 Japanese Patent Laid-Open No. 11-39385

  Currently, in order to win the competition with other companies in the same industry due to the liberalization of gas and electricity retail due to deregulation, diversified fee menus have been set up by each company, and it is necessary to provide them quickly with consumers. Is coming out. For this reason, it is necessary for the charge calculation system to cope with quick addition / change of charge plans.

  Against this backdrop, the first issue is that in the current gas and power company package systems, each package user company takes input arguments according to the charge calculation logic, and sets basic charges. Processing such as basic fee calculation to be confirmed and metered fee calculation to determine a metered fee is performed every time at the timing of the fee calculation processing, and for each supplier and demander.

  Therefore, useless processing is performed in the fee calculation processing, and a lot of time is spent in the fee calculation processing. However, it is not necessary to perform processing according to the charge calculation logic each time for the charge plan of the gas charge and the electricity charge, and the charge amount is generally calculated when information such as the usage amount to be input is determined.

  In addition, most of the rate plans offered within the same industry are the same, with the exception of the large-scale contract rate plans that are set individually, and the unit price settings are generally different. . Therefore, in the conventional technology, similar charge calculation logic is managed for each package using company, and similar charge calculation logic is scattered. In such a state, when the charge calculation logic is modified, it is necessary to deal with each package using company, and it has not been possible to quickly respond to the addition / change of the charge plan.

  As a second problem, there is a technique of preparing table data in advance and determining the amount of charge calculation as described in Patent Document 3, but it is a simple calculation such as calculation of shipping cost, which is called the number of orders. This technique is effective only when the amount of money is determined from one variable information that fluctuates within a limited range, or when the amount of money is changed at certain intervals.

  However, the amount of money determined by multiple variable information, such as gas charges, and the amount of money is not determined step by step. The number of records defined in the table becomes enormous, and there is a problem that the response cannot be improved even if the table is prepared in advance.

  As the third problem, as described in Patent Documents 1 and 2, in the form of creating a program individually, in the table-driven form, the program creation and table definition are performed in the sales department of the gas company and the power company, It is necessary to add / change a new fee menu, and in order to perform such a response, there is a problem that a development period is required and it is impossible to respond quickly, and the cost increases in proportion to the development period. there were.

  As for the table-driven form, there are issues that require specialized technology on the part of the company when defining the table. Further, when packaging the charge calculation system, each gas and electric power company The package development company cannot grasp the details of the charge calculation logic of each user company, and the package development company is quick when adding or changing a charge plan. There is a problem that it is not possible to cope with the situation, and there is a problem that it is necessary to assign a responder for each package application company, resulting in a shortage of human resources.

  SUMMARY OF THE INVENTION An object of the present invention is to provide a fee calculation system that can quickly respond to the addition / change of a fee plan and can easily cope with other companies in the same industry and other industries.

  The above and other objects and novel features of the present invention will be apparent from the description of this specification and the accompanying drawings.

  Of the inventions disclosed in the present application, the outline of typical ones will be briefly described as follows.

  In other words, the outline of a typical one is for a search in which the user company's charge calculation system manages the charge calculation table created by the package development company's charge calculation system as a secondary table and extracts some data from the secondary table. Based on the table and a plurality of input information, charge calculation is performed to determine the billing amount.

  Among the inventions disclosed in the present application, effects obtained by typical ones will be briefly described as follows.

  In other words, the effect obtained by the typical one is that companies such as gas and electric power companies that use the charge calculation system can quickly respond to the addition or change of the charge plan, and the charge calculation processing time. Can be shortened.

  In addition, companies that develop / provide charge calculation systems have integrated charge calculation table creation functions, so they can quickly respond to the provision of charge calculation systems to other companies in the same industry and other industries. .

  Hereinafter, embodiments of the present invention will be described in detail with reference to the drawings. Note that components having the same function are denoted by the same reference symbols throughout the drawings for describing the embodiment, and the repetitive description thereof will be omitted.

  With reference to FIG. 1, the configuration of a fee calculation system according to an embodiment of the present invention will be described. FIG. 1 is a configuration diagram showing a configuration of a fee calculation system according to an embodiment of the present invention.

  In FIG. 1, the fee calculation system includes a package company-side fee calculation system 7 of a package development company 1 that develops a package of the fee calculation system, and a use company-side fee calculation system 8 of a company that uses the fee calculation system. .

  The package development company 1 of the charge calculation system is composed of a package development company side charge calculation system 7 for creating the charge calculation table 4 and a package development company online terminal 6 that maintains a charge calculation rule table 50 defining charge calculation logic. Has been.

  The package development company side charge calculation system 7 includes a pseudo input information creation processing unit 2 having a program for creating the charge calculation table 4 and charge calculation table creation based on information such as the charge calculation rule table 50 and the charge calculation unit price table 51. This is a system configured by the processing unit 3.

  Further, in the package development company side charge calculation system 7, a charge target charge plan table, charge calculation table definition information, which are used by processing of a pseudo input information creation processing unit 2 and a charge calculation table creation processing unit 3 described later, A calculation target charge plan definition table, contract information, and the like are held, and the pseudo input information creation processing unit 2 and the charge calculation table creation processing unit 3 perform processing based on such information and input parameters.

  Further, the user company side is configured by a user company side charge calculation system 8 that receives the charge calculation table 4 distributed from the package development company 1 and calculates the charge by the charge calculation table 4.

  The charge calculation logic is centralized and managed by the package development company 1, and is not held by the package using company.

  Here, an outline of processing of the fee calculation system will be described.

  (1) The package development company 1 uses the package development company online terminal 6 to create a charge calculation rule table 50 based on the contracts of the gas industry and the electric industry. The definition method of the charge calculation rule table 50 is the same as the conventional method.

  (2) The unit price information necessary for the charge calculation is defined in the charge calculation rule table 50 according to the package using company. Normally, the price plans for gas and power companies are the same, even when looking at other companies in the same industry, and the unit price, discount rate, etc. are different, and the charge calculation logic is not added or changed. By changing only the unit price information, it is possible to provide each package using company.

  (3) Based on the input parameters, the package development company 1 performs processing in the pseudo input information creation processing unit 2 and creates input information for performing charge calculation.

  (4) Based on the created input information, processing within the fee calculation table creation processing unit 3 is performed to create a fee calculation table 4 to be provided to the package using company. The charge calculation table 4 is created for each charge plan. Further, it is created as a charge calculation table 4 for each company that uses the package.

  (5) The created fee calculation table 4 is provided to the user company side fee calculation system 8 of each package user company.

  (6) The timing of providing to the package using company side is at the initial purchase of the charge calculation system package, at the time of changing the unit price information, or at the time of adding the charge plan due to the charge revision.

  (7) The user-side fee calculation system 8 uses the provided fee calculation table 4 to determine the billing amount.

  With such a charge calculation system consisting of package development company 1 and the user company, the calculation process based on the charge calculation logic is not carried out by the package user company, so the charge calculation time is shortened and the charge plan added / It is possible to realize a system that can quickly respond to changes.

  In addition, since the charge calculation logic can be managed collectively in the package development company 1, the charge calculation logic is not scattered.

  Next, processing on the package development company 1 side of the fee calculation system according to one embodiment of the present invention will be described with reference to FIGS. FIG. 2 is an explanatory diagram for explaining a pseudo input information creation process on the package development company side of the charge calculation system according to the embodiment of the present invention, and FIG. 3 is a diagram of the charge calculation system according to the embodiment of the present invention. It is explanatory drawing for demonstrating the charge calculation table preparation process by the package development company side.

  First, in creating the charge calculation table 4 in the package development company 1, as shown in FIG. 2, the pseudo charge calculation input for processing in the charge calculation table creation processing unit 3 in the pseudo input information creation processing unit 2 Information 32 is created.

  The pseudo input information creation processing unit 2 has a pseudo input information creation program 31 that comprehensively creates input conditions for determining the billing amount for each rate plan. By the processing of the pseudo input information creation program 31, Charge calculation table definition information 30 for defining a calculation target charge plan definition table 29 for specifying a charge plan code for actually performing charge calculation, an input upper limit, a lower limit threshold, a fixed value, etc. for an argument for each charge plan code From the above, pseudo charge calculation input information 32 is created.

  The calculation target charge plan definition table 29 is a table that defines the correspondence relationship between the charge plan code conscious on the package using company side and the charge plan code conscious on the package development company side.

  As shown in FIG. 2, the charge plan code “RYOKIN01” is a code that is recognized by the user company, and is changed according to the user company. The calculation target charge plan code “PLAN02” is a code for the charge calculation logic managed in common on the package side.

  The charge calculation table definition information 30 defines the range in which the charge calculation is performed for each argument. The charge calculation table definition information 30 is a form in which addition is performed one by one from the threshold (lower limit) to the threshold (upper limit), and the customer's district code. There are fixed values 1, 2, and 3 that are fixedly determined.

  In the example shown in FIG. 2, the key 1 of “PLAN01” is an input value having a numerical value with a lower limit value of 1 and an upper limit of 1000, and the key 2 is an input value “01”, “02”, and “03” as fixed values. Value. The charge calculation table definition information 30 holds a charge plan code conscious of the package development company 1 as a key item, and changes and executes the lower limit value, the upper limit value, and the fixed value according to the user company.

  Based on the information defined in this way, pseudo charge calculation input information 32 covering the combination of arguments of each charge plan is created by the charge plan code on the package development company 1 side.

  For the contractor who actually calculates the fee, pseudo contract information is created to deal with it.

  Further, as shown in FIG. 3, the charge calculation table creation processing unit 3 includes a charge calculation program 34 that calculates calculation result information 35 based on the pseudo charge calculation input information 32 created by the pseudo input information creation processing unit 2. A charge calculation table creation program 37 for creating the charge calculation table 4 based on the calculation result information 35 is provided.

  For the charge calculation program 34, the contract information 33 for managing the contract information created as a dummy, the pseudo charge calculation input information 32 created by the pseudo input information creation program 31, the charge calculation rule table 50, and the charge calculation unit price table 51 are input. As a result, the calculation result information 35 is created. A charge calculation unit price table 51 is defined according to each package using company, and calculation result information 35 corresponding to the using company is created by executing charge calculation.

  In the charge calculation table creation program 37, in order to develop the charge calculation table 4 on the user company side, the charge plan code conscious on the user company side from the charge plan code conscious on the package development company 1 side is calculated. In 29, the result of the calculation result information is converted into the format of the charge calculation table 4.

  The charge calculation rule table 50 is defined based on the contracts of the gas industry and the electric power industry, and the charge calculation table 4 corresponding to each package using company is created by changing the unit price information and calculating the charge. be able to.

  Conventionally, a charge calculation rule table 50 is provided to the package using company as a charge calculation system, and a plurality of the same charge calculation logic exists among other companies in the same industry. In addition, since the package calculation company side has the charge calculation rule table 50 in the past, there is an advantage that the application company side can customize it as necessary, while the necessity to secure personnel for table definition is necessary. Even when applying the contracts made by other companies, it is necessary to define the table from 1 on each application company side, and there is a drawback that it is not possible to respond quickly to charge calculation.

  In this embodiment, by integrating the personnel who define the charge calculation rule table 50 that requires specialized knowledge into the package development company 1, the charge calculation unit price can be reduced even in the case of reducing personnel at the package using company or adding a charge plan. By changing the table 51, it is possible to cope with quick addition / change of the rate plan.

  Next, with reference to FIG. 4, an outline of processing on the package using company side of the fee calculation system according to the embodiment of the present invention will be described. FIG. 4 is an explanatory diagram for explaining the processing on the package using company side of the fee calculation system according to the embodiment of the present invention.

  In FIG. 4, a user company side charge calculation system 8 provided to the package user company side is a system for determining a billing amount based on a charge calculation table 4 provided by the package development company 1. It is a general-purpose charge calculation system that does not bring in charge calculation logic.

  The user company side charge calculation system 8 includes a charge plan determination unit 12, a bill amount determination unit 13, and a search table reflection unit 14 in the control unit.

  The fee calculation table 4 extracts only the secondary table 10 that is the information as provided by the package development company 1, the records used to determine the billing amount, and a part of the records that are extracted in consideration of the extraction range. The search table 11 is configured.

  The user company side charge calculation system 8 provided to the package user company side includes a charge plan code for identifying a charge plan as input information, arguments 1, 2, and 3 (keys for the charge calculation table 4) for acquiring the charge calculation result. ), And an additional fee is required to add lump sums and past due interest.

  The argument for determining the billing amount is information for confirming the billing amount, and information on variable values that change according to the usage situation of the consumer such as monthly usage amount, holiday usage amount, Consists of fixed information such as a district code indicating the district where the consumer resides.

  For additional charges, if there is information about lump sums to be billed to customers or past due interest, in addition to the amount charged for each rate plan, billing that takes into account lump sums, past due interest, etc. by defining it as input information Used to calculate the amount and consumption tax.

  Using the input information shown above, the price plan determination unit 12 acquires a TABLE name (search table, secondary table) to be searched from the price plan code. Based on the TABLE name and argument information specified by the price plan determination unit 12, the billing amount determination unit 13 searches the search table 11 to obtain the billing amount, consumption tax amount, and discount amount.

  If it cannot be obtained from the search table 11, the secondary table 10 is searched. The final charge amount is determined by adding the additional charge amount and additional charge consumption tax amount to the acquired result.

  The process of moving records from the secondary table 10 of the charge calculation table 4 to the search table 11 is performed by the search table reflection unit 14. The search table reflection unit 14 specifies a target to be extracted to the search table 11 based on the record used to determine the billing amount at the timing when the charge calculation for one consumer is completed.

  When the target to be extracted is specified, a record is acquired from the secondary table 10, and a record highly relevant to the record used when determining the billing amount is also extracted into the search table. Therefore, it is possible to configure the search table 11 that statistically determines the usage status of the consumer.

  Further, since the charge amount determination unit 13 determines the charge amount without bringing in the charge calculation logic, the charge calculation process can be shortened.

  The reason why the fee calculation logic can be simplified and the processing time can be shortened by the above-described mechanism is that if the input information which is an element for calculating the billing amount is fixed, the above-described conventional patent documents 1 and 2 described above. This is because it is not necessary to perform the calculation process every time.

  In general, the majority of gas and power company customers are general customers, and the amount of usage, which is input information for determining the billing amount, varies depending on the customer. Since it does not change, the statistical calculation status of the consumer is taken into consideration using the charge calculation table 4 (search table 11), so that the processing time can be shortened in the present embodiment.

  Furthermore, by configuring the two tables of the search table and the secondary table, the response deterioration of the search process due to an increase in the number of records defined in the table that has been the subject of the above-mentioned Patent Document 3. Can be prevented.

  Next, a processing flow on the package using company side of the fee calculation system according to the embodiment of the present invention will be described with reference to FIG. FIG. 5 is a flowchart showing a processing flow on the package using company side of the fee calculation system according to the embodiment of the present invention.

  The processing in the use company side fee calculation system 8 on the package use company side is performed as follows.

  First, in the target table specifying process (step 100) of the charge plan determination unit 12, the table names for the search table and secondary table to be searched are acquired from the charge plan code received as the input value. The TABLE name to be acquired is the TABLE name on the database.

  In the example shown in FIG. 4, the calculation target specifying table 9 is searched with the charge plan code “RYOKIN01” as an input value, and the search table name “TABLE1” and the secondary table name “TABLE4” are acquired.

  In the billing amount information acquisition process (step 101) of the billing amount determination unit 13, first, a search is performed in the search table 11, and the billing amount, the consumption tax amount, the discount is calculated using the arguments 1, 2, and 3 corresponding to the keys. Get the amount. If there are not up to three keys, a NULL value is set as argument information.

  In step 102, it is determined whether or not it can be acquired from the search table 11. If it cannot be acquired from the search table 11 in step 102, the secondary table 10 is searched to determine the charge amount (billing amount information acquisition process ( Secondary): Step 103).

  In the example shown in FIG. 4, the key 1 that is the input value is “district 1” as the district code for determining the gas supply and demand area, and the key 2 is “100” as the information indicating the amount of gas used. In that case, the search is performed using “TABLE 1” of the table name for search acquired in the target TABLE specifying process in step 100 as “search area” for key 1 and “100” for key 2.

  Since the corresponding record exists as a result of the search, the billing amount “2000”, the consumption tax “100”, and the discount amount “0” are acquired. If it cannot be obtained from the search table 11, the name of the table to be searched is changed and the secondary table 10 is searched.

  In step 104, it is determined whether or not additional charge information exists. If additional charge information is present in step 104, in the additional charge information addition process (step 105), the amount charged in steps 102 and 103 is charged. The information acquired in the information acquisition process is added.

  For amounts that do not have the concept of consumption tax, such as arrears, the additional consumption tax is not set.

  In the example shown in FIG. 4, since the additional charge amount 1 as an input value is “100” and the additional charge consumption tax amount is “5”, the charge amount is “2100” and the consumption tax amount is “105”.

  Then, the billing amount, the consumption tax amount, and the discount amount, which are finally output information, are confirmed and output (billing amount confirmation processing: step 106).

  Then, in the search table reflection process (step 107), a record used to determine the billing amount at the time when the batch process for one consumer is completed and a record highly related to the record are searched. To be used for batch processing of the next supplier and demander.

  Next, the outline of the processing of the search table reflection unit on the package using company side of the fee calculation system according to the embodiment of the present invention will be described with reference to FIG. FIG. 6 is an explanatory diagram for explaining the processing of the search table reflection unit on the package using company side of the charge calculation system according to the embodiment of the present invention, and records are reflected from the secondary table 10 to the search table 11. Processing is shown.

  In addition processing to the search table 11, a record is added to the search table 11 when a record is acquired from the secondary table 10 without acquiring a record from the search table 11.

  The number of records defined in the secondary table 10 differs depending on the number of input information (variable values) necessary for each price plan, and the number of records increases as the input information becomes plural.

  As an element for specifying a target to be moved to the search table 11, an extraction range increase / decrease number that defines a target range for moving a record related to information used for the search together is necessary. By having a range in the record to be extracted, it is possible to search from the search table even in a similar search, and the search efficiency can be improved.

  The secondary table (image diagram) 22 is an image diagram in which the correspondence between the key 1 and the key 2 is visualized in the secondary table composed of one record. As described in the secondary table (image diagram) 22, the definition of the extraction range increase / decrease number is the one adjacent to the record used as the extraction target (in the example of FIG. 6, the extraction range increase / decrease number is “1”).

  In FIG. 6, the amount of charge calculation is determined from two pieces of input information (variable values).

  In determining the amount charged by one consumer, it is assumed in the example of FIG. 6 that the usage amount is “2” and the contract maximum usage amount is “2”. The record used to determine the billing amount is a record with a usage amount of “2” and a maximum contract usage amount of “2”, and 8 records of the extraction target records adjacent to that record are also added. To do.

  When the secondary table 10 is expanded from the package development company 1, there is no corresponding record in the search table 11, and when the billing amount is determined by batch processing, the search table 11 is changed from the secondary table 10. Add to.

  The record is extracted from the search table 11 at the timing when the confirmation of the billing amount for one consumer is completed, and for the confirmation of the billing amount for the next consumer, the added content is referred to.

  The processing time cannot be shortened when calculating the charge for the first supply / demand after being provided by the package development company 1, but the optimized record is registered in the search table 11 as the charge calculation process is performed. become.

  As a result, in most of the processes for determining the billing amount, the search table 11 is accessed, and the search process with improved search efficiency can be performed. In consideration of operation, when the secondary table 10 is received from the package development company 1, the number of extraction range increases / decreases is increased, and as the search table 11 is optimized, the number of extraction range increases / decreases is decreased. As a result, the record can be added to the search table without waste.

  Next, a processing flow of the search table reflection unit on the package using company side of the fee calculation system according to the embodiment of the present invention will be described with reference to FIG. FIG. 7 is a flowchart showing the processing flow of the search table reflection unit on the package using company side of the fee calculation system according to one embodiment of the present invention.

  As described with reference to FIG. 6, when adding a record to the search table 11, the record is acquired from the secondary table 10.

  First, it is determined whether or not a search is made from the secondary table 10 (step 110), and when the acquisition is performed from the secondary table 10 in step 110, the extraction range increase / decrease number is obtained in the extraction range increase / decrease acquisition process (step 111). To get.

  The internal variable is initialized in order to acquire the target record from the acquired number of extraction ranges and the information of the key 1 and key 2 used for the search (loop process initialization process: step 112).

  Next, it is determined whether or not the end flag is 1 (step 113). If the end flag is 1 in step 113, the process ends. If the end flag is not 1 in step 113, search record addition processing (step 114) is performed. ) To add a record from the secondary table 10 to the search table 11.

  In step 114, when the addition is performed, a search is performed to determine whether or not a record having key 1 = X and key 2 = Y exists in the search table 11 in the search table. Perform the process.

  Next, in the X count-up process (step 115), the variable X is counted up in order to specify the next target within the target of the extraction range.

  Next, it is determined whether or not X is larger than X_END (step 116). If X is not larger than X_END in step 116, the process returns to step 113. If X is larger than X_END in step 116, Y count-up processing ( In step 117), when the value of Y is counted up and all the additional processing for the X axis within the extraction range is performed, the variable X is initialized to perform processing for the next row (X initial) Processing: step 118).

  As described above, in the present embodiment, the package calculation company 1 creates the charge calculation table 4, and the charge calculation table 4 performs charge calculation by the user company charge calculation system 8. The time required for the charge calculation process can be shortened.

  Further, as the charge calculation table 4, the two tables of the secondary table 10 which is a table for calculating all charges and the search table 11 used for normal charge calculation are used. It is possible to improve the search efficiency when specifying the target data from.

  In the charge calculation process, batch processing is performed for a large number of consumers at a time. Therefore, the effect of shortening the charge calculation process becomes more apparent as the number of demand and supply increases.

  In the present embodiment, the charge calculation table 4 manages information in which input information is associated with the billing amount, and the charge development table 4 is created on the package development company 1 side. For this reason, since the package development company 1 retains the fee calculation logic in an integrated manner, it can be used to quickly add or change a charge plan for package companies that have the same charge calculation processing logic among other companies in the same industry. The corresponding fee calculation table 4 can be distributed. As a result, the package using company can quickly respond to the addition / change of the price plan.

  In addition, when providing a fee calculation package only with the terms and conditions provided in the same industry, the existing fee calculation table can be applied, so the cost for purchasing the package can be reduced and the introduction period can be shortened. .

  As mentioned above, the invention made by the present inventor has been specifically described based on the embodiment. However, the present invention is not limited to the embodiment, and various modifications can be made without departing from the scope of the invention. Needless to say.

  For example, in the present embodiment, when a record is reflected from the secondary table 10 to the search table 11, a check is made as to whether each record of the secondary table 10 exists in the search table 11, and if there is no addition, In this case, if the records in the search table 11 are optimized and there is no need to add them to the search table 11, useless processing is performed.

  In this case, useless processing may be avoided by the following processing.

  -Provide an extracted flag in the secondary table, and if the flag is ON, do not check the search table.

  When the flag is OFF, an additional process is performed on the search table 11 and the extracted plug of the corresponding record in the secondary table 10 is turned ON.

  As a result, useless check processing is not performed, so no overhead occurs even when the search table 11 is optimized. This determination is performed for each customer.

  -An extraction target flag is provided in the secondary table 10, and the extraction target flag is collectively added to the search table 11 when charge calculation for all customers is completed.

  In updating to the extraction target flag, ON is set for the records in the range in consideration of the number of extraction range increase / decrease. If the same record is specified as a range in a single charge calculation process, the extraction target flag is already ON, but the flag is turned ON without any particular determination (determined and flagged If it is ON, there is no problem even if it is not updated, and there is no particular difference).

  Since the check process to the search table 11 and the addition process to the search table 11 are not performed, the response is not deteriorated.

  When one charge calculation is completed, since there is a record to be extracted in the secondary table 10, it is checked whether the record exists in the search table 11, and the record is added.

  Further, in this embodiment, an example in which charges are calculated by the use company side charge calculation system 8 has been described. However, as the use company side charge calculation system 8, the charge calculation table 4 is used in the handy terminal used by the company. You may make it perform charge calculation.

  In this case, in the handy terminal, usually, the charge calculation can be performed by the search table 11 of the charge calculation table 4, and the charge calculation can also be performed in the handy terminal having a low processing capacity.

  The present invention relates to a charge calculation system for determining a charge charged to a consumer in a gas, an electric power company, etc., and can be applied to a system that requires shortening of charge calculation processing.

It is a block diagram which shows the structure of the charge calculation system which concerns on one embodiment of this invention. It is explanatory drawing for demonstrating the pseudo input information creation process by the package development company side of the charge calculation system which concerns on one embodiment of this invention. It is explanatory drawing for demonstrating the charge calculation table preparation process by the package development company side of the charge calculation system which concerns on one embodiment of this invention. It is explanatory drawing for demonstrating the process by the package utilization company side of the charge calculation system which concerns on one embodiment of this invention. It is a flowchart which shows the processing flow by the package utilization company side of the charge calculation system which concerns on one embodiment of this invention. It is explanatory drawing for demonstrating the process of the search table reflection part by the package utilization company side of the charge calculation system which concerns on one embodiment of this invention. It is a flowchart which shows the processing flow of the search table reflection part by the package utilization company side of the charge calculation system which concerns on one embodiment of this invention.

Explanation of symbols

  DESCRIPTION OF SYMBOLS 1 ... Package development company, 2 ... Pseudo input information creation process part, 3 ... Charge calculation table creation process part, 4 ... Charge calculation table, 6 ... Package development company online terminal, 7 ... Package development company side charge calculation system, 8 ... User-side fee calculation system, 9 ... calculation target specification table, 10 ... secondary table, 11 ... search table, 12 ... charge plan determination unit, 13 ... charge amount determination unit, 14 ... search table reflection unit, 29 ... calculation Target charge plan definition table, 30 ... charge calculation table definition information, 31 ... pseudo input information creation program, 32 ... pseudo charge calculation input information, 33 ... contract information, 34 ... charge calculation program, 35 ... calculation result information, 37 ... charge Calculation table creation program, 50 ... charge calculation rule table, 51 ... charge calculation unit price table.

Claims (5)

A package development company side charge calculation system of a package development company that provides a package for charge calculation to a plurality of package use companies,
A charge calculation system on the use company side of the package use company,
The package development company side charge calculation system collects and manages charge calculation logics in the plurality of package using companies, and based on the charge calculation logic, charges corresponding to billing amounts for a plurality of input information Create a calculation table
The user company side charge calculation system manages the charge calculation table created by the package development company side charge calculation system as a secondary table, a search table obtained by extracting some data from the secondary table, and the plurality of the plurality of data A fee calculation system characterized in that a charge is calculated based on input information and a charge amount is determined. In the charge calculation system according to claim 1,
When the data required for the charge calculation does not exist in the search table, the user company side charge calculation system performs the charge calculation based on the secondary table, determines the billing amount, and uses it for the charge calculation. A charge calculation system characterized by adding the processed data to the search table. In the charge calculation system according to claim 2,
The user company side charge calculation system is characterized in that when adding data from the secondary table to the search table, data of a preset extraction range is also added, centering on data used for the charge calculation. Charge calculation system. In the charge calculation system according to claim 3,
The user company side charge calculation system provides an extracted flag in the secondary table, and when adding data from the secondary table to the search table, if the extracted flag is valid, the data adding process is performed. A fee calculation system characterized by not being performed. In the charge calculation system according to claim 3,
The user company side charge calculation system provides an extraction target flag in the secondary table, and when the charge calculation is performed based on the secondary table, the extraction target flag of the data used for the charge calculation is enabled. The data to be extracted is valid from the secondary table to the search table in a lump after all the charge calculation is completed, without adding to the search table. A charge calculation system characterized by

Images