JP5080152B2 - Sales fee calculation processing system and method, and program - Google Patents

Description

  The present invention relates to a sales fee calculation processing system and method, and a program comprising a computer that executes processing for calculating a fund sales fee to be paid to a fund sales company when a customer purchases the fund. This can be used to calculate sales commissions when a customer who purchased a fund in the country purchases the same or another fund at a securities company that manages the balance of the fund.

  Generally, in the fund sales commission system that is paid to the fund sales company when a customer purchases a fund, the sales commission rate is determined according to the purchase price of the fund, that is, the larger the purchase price, The sales commission rate is lowered, and the sales commission is calculated based on the determined sales commission rate. The sales commission rate is determined for each fund and for each order, and the sales commission is calculated for each fund and for each order.

  Therefore, whether a customer who already owns a fund purchases the same fund or buys another fund, regardless of the amount of funds already held, The sales commission rate corresponding to the purchase price is applied, and the sales commission is calculated based on the sales commission rate. In addition, even if multiple types of funds are purchased on the same day, the purchase price of each fund does not affect the sales commission rate or sales commission of another fund. Furthermore, even if the same fund is purchased in multiple orders on the same day, the purchase price of each order does not affect the sales commission rate or sales commission for another order.

  In addition, as a peripheral technology of the present invention, a coupon that changes the discount rate and discount product according to the magnitude of asset fluctuation is issued in that the financial asset held by the customer is linked to the discount rate related to product purchase. There is a financial product management system (see Patent Document 1).

  In addition, as a peripheral technology of the invention of the present application, when a depositor newly makes various deposits, a preferential treatment according to the transaction status of the depositor is made on the financial institution side in terms of taking preferential treatment for customers with a high degree of contribution. There is a deposit interest rate calculation method in which measures are executed in the form of an additional deposit interest rate (see Patent Document 2). In addition, personal account management that appropriately evaluates each client's profit contribution to financial institutions and provides services such as interest rate setting and commission discounts that are advantageous to the customer as much as possible. There is also a device (see Patent Document 3).

JP 2006-48387 A (paragraphs [0022] to [0024], summary) JP-A-10-214299 (summary) Japanese Patent Laid-Open No. 2002-222112 (Abstract)

  However, in the conventional method for calculating the fund sales commission described above, when the fund is purchased several times in succession, the sales commission is calculated independently for each fund purchase order. There is no opportunity or motivation for additional purchases for customers. Also, since the sales commission is calculated independently for each order, there is no advantage of continuing to purchase funds at the same sales company, so if the sales commission rate is the same, the customer purchases the fund at another sales company This may lead to outflow of customers for fund sales companies. Accordingly, a system that realizes a mechanism that leads to customer acquisition and payment prevention for the sales company as well as benefits to the customer for payment of the sales commission by additionally purchasing the fund at the same sales company.

  In the financial product management system described in Patent Document 1 described above, the discount rate applied to the amount of products to be purchased is the sum of the amount of products to be purchased and the amount of products already purchased. The sales commission rate applied to the purchase amount of the fund to be purchased is determined based on the purchase amount of the fund to be purchased and the balance of the fund that has already been purchased. The present invention is different from the present invention, which is configured to depend on the total amount. In addition, in the financial product management system described in Patent Document 1 described above, the discount rate of coupons once issued does not change after that. Depending on the purchase price of the fund that was purchased, the sales commission rate applied to the previously purchased fund purchase price may change, and the provisional sales commission rate may change once. This is different from the present invention.

  Further, in the deposit interest rate calculation method described in Patent Document 2 described above, the interest rate applied to the amount to be deposited depends on the total amount of the amount to be deposited and the deposit balance already deposited, and In other words, the sales commission rate applied to the purchase amount of the fund to be purchased depends on the total amount of the purchase amount of the fund to be purchased and the balance of the fund that has already been purchased. This is different from the invention of the present application. Furthermore, the configuration of the personal account management apparatus described in Patent Document 3 described above is also different from the present invention from the same viewpoint.

  An object of the present invention is to provide an advantage that a sales commission paid at the time of fund purchase for a customer is reduced, and a sales commission calculation processing system and method, and program for the fund sales company that can acquire a customer. Is to provide.

  The present invention determines the sales commission rate for calculating the sales commission to be paid when the fund is purchased by determining the sum of the amount of funds to be purchased and the balance of funds already purchased. Is to achieve. Specifically, the invention having the following configuration can be cited.

  <Invention that determines the sales commission rate based on the fund group unit balance>

  That is, the present invention is a sales commission calculation processing system comprising a computer that executes processing for calculating a fund sales commission to be paid to a fund sales company when a customer purchases a fund. As data, along with customer identification information about the customers who bought and sold the fund, processing to accept input of fund identification information about the fund to buy and sell, buying and selling classification data indicating whether selling and buying, and amount data or number data Order receiving processing means, fund identification information received by the order receiving processing means, trade classification data, and order data storage means for storing money amount data or unit data in association with customer identification information, and a fund owned by the customer Balance data, fund identification information and customer Correspondence between fund identification information for each fund and group identification information for the fund group to which each fund belongs at the time of contract processing of the order data stored in the balance data storage means stored in association with information and order data storage means Group identification corresponding to the fund identification information contained in the order data to be processed stored in the order data storage means by using a group table which is stored in the group table storage means and described in the program with a relationship defined Information is extracted, and the order data to be processed including the order data to be processed is the same as the customer identification information, and the group identification information corresponding to the fund identification information is the same. For each order data of buying and selling of each fund to which it belongs, In the case of the sentence, from the total amount data of the buy that is the sum of the amount data when the buy / sell category data is data indicating buy, the sell amount that is the sum of the amount data when the buy / sell category data is data indicating sell is Calculate the deduction amount data obtained by subtracting the total amount data, and add the calculated deduction amount data and the total amount data of the balance data of the previous day of all funds belonging to the customer fund group stored in the balance data storage means. To calculate the amount data for determining the fixed sales commission rate related to the order data to be processed, or, in the case of an order with a specified number of units, the total number of units in the case where the trading category data is data indicating buy. The total number data of the sale was subtracted from the total number data of the sale, which is the total of the number data when the trade classification data is data indicating sales. From the reference price storage means that calculates the subtraction data for each fund and stores the reference price data of each fund in association with the fund identification information, the reference price for the previous day of each fund using the fund identification information for each fund as a key Data is extracted, and the amount data of each fund is calculated by multiplying the calculated number of balances of each fund by the base price data of the previous day of each fund to calculate the amount of money for each fund. Amount data for determining the fixed sales commission rate related to the order data to be processed by adding the data and the total amount data of the balance data of the previous day of all funds belonging to the customer fund group stored in the balance data storage means The fixed sales commission rate determination amount calculation processing means for executing the process for calculating the Based on the fixed sales commission rate determination amount data related to the order data to be processed calculated by the fee calculation processing amount calculation processing means, the relationship between the fund purchase amount and the sales commission rate is determined and stored in the sales commission rate table storage means. About each order data of buying of each fund belonging to the customer fund group stored in the order data storage means including the order data to be processed using the sales commission rate table stored or described in the program In the case of an order for which the amount is specified with respect to the order data stored in the order data storage means and the final sales commission rate determination processing means for executing the processing for determining the fixed sales commission rate data applied in common. , Amount data when the transaction classification data is data indicating buying, and a fixed sales commission rate determination processing Stored in the unit price storage means, the reference price storage means or the order data storage means when the purchase / sale classification data is data indicating buying. Executes processing to calculate final sales commission data related to the contracted purchase orders to be processed, using the standard price data for trade dates and the final sales commission rate data determined by the final sales commission rate determination processing means And a fixed sales commission calculation processing means.

  Here, the “balance data” stored in the “balance data storage means” includes balance data deposited by the customer as collateral for margin transactions and loans. The same applies to other inventions.

  In such a sales commission calculation processing system of the present invention, if there is a total amount of each fund belonging to the same fund group purchased on the same day, or a fund belonging to the fund group sold on that day, purchase on the same day The final sales commission rate is calculated by adding the total amount of each fund to be subtracted from the total amount of each fund to be sold on that day and the total amount of the balance of each fund that already belongs to the fund group. Since the amount for decision is calculated and the fixed sales commission rate is determined based on this, the fixed sales commission rate is more advantageous to the customer than when it is determined based solely on the amount of funds purchased in one order, Because it is lower, the fixed sales commission is lower.

  This makes it easier for customers to make additional purchases of funds, and allows fund sales companies to acquire customers and prevent the outflow of customers to other sales companies. Achieved.

  Further, in the above-described sales commission calculation processing system, group table storage means for storing a group table for defining a correspondence relationship between fund identification information for each fund and group identification information for the fund group to which each fund belongs, and fund identification information The data for displaying the group designation screen for inputting and designating the correspondence between the ID and the group identification information is transmitted via a communication line to the sales company terminal device operated by the person in charge of the fund sales company, and the sales company terminal A group designation processing means for executing a process of storing the fund identification information transmitted from the apparatus via the communication line and the corresponding group identification information in the group table storage means in association with each other. Is desirable.

  In this way, when the group table storage means and the group designation processing means are provided, the person in charge of the fund sales company can easily group the funds and change the grouping according to the purpose. Can also be performed. For example, by grouping multiple funds that you want to recommend to customers, or by combining groups, you can create a larger group and conduct a campaign for a certain period of time. It can be realized.

  Further, in the above-mentioned sales commission calculation processing system, the same customer as the customer who placed the current order stored in the current order data and order data storage means received during the order data reception process by the order reception processing means For each order data of other trades that have already been placed orders before the execution of each fund belonging to the same fund group as the fund related to the current order by Calculates the deduction amount data by subtracting the total amount data of the sale, which is the sum of the amount data when the trade classification data is the data indicating the sale, from the total amount data of the purchase where the amount data is summed Amount of money data and balance data stored in the means for storing balance data for all funds belonging to the customer's fund group on the previous day. Data for determining the approximate sales commission rate for the current order data, or in the case of an order with a specified number of units, the purchase / sale classification data is data indicating a purchase. For each fund, subtracted data for each fund is calculated by subtracting the total number of units for selling, which is the sum of the number of units for buying / selling from the total number of units for buying. The reference price data for each fund is extracted from the reference price storage means that stores the reference price data of each fund in association with the fund identification information, using the fund identification information for each fund as a key. The amount data of each fund is multiplied by the base price data of the previous day of each fund that has been extracted. By adding the total amount data of the deduction amount data of each fund calculated and the total amount data of the balance data of the previous day of all funds belonging to the customer fund group stored in the balance data storage means, Approximate sales commission rate determination amount calculation processing means for executing provisional calculation of approximate sales commission rate determination amount data related to order data, and the current order temporarily calculated by the approximate sales commission rate determination amount calculation processing means In the case of a purchase accepted by the order acceptance processing means using the sales commission rate table stored in the sales commission rate table storage means or described in the program based on the approximate sales commission rate determination amount data relating to the data Each order data and other purchases that have already been placed before the trade are stored in the order data storage means In addition to the approximate sales commission rate determination processing means that executes the process of temporarily determining approximate sales commission rate data that is commonly applied to order data, and the current order data received by the order reception processing means, or the current order data For each order data of other trades that have already been placed before the trade stored in the order data storage means, in the case of an order for which the amount is specified, the amount data in the case where the trade classification data is data indicating buying, and the rough estimate Using the estimated sales commission rate data provisionally determined by the sales commission rate determination processing means, or in the case of order specifying the number of units, the quantity data when the trade classification data is data indicating buying, and stored in the reference price storage means Using the reference price data of the previous day and the estimated sales commission rate data tentatively determined by the estimated sales commission rate determination processing means, Approximate sales commission data related to the current purchase order, or approximate sales commission data related to the current purchase order, in addition to the estimated sales commission data related to the other orders that have already been placed prior to execution Approximate sales commission calculation processing means for executing the processing to be performed, and approximate sales commission data temporarily calculated by the approximate sales commission calculation processing means, or approximate sales temporarily determined by the approximate sales commission rate determination processing means in addition to the approximate sales commission data It is desirable to include a rough sales commission display processing means for executing processing for displaying the commission rate data on the screen of the terminal device in which the order data has been input.

  Here, the screen display by the approximate sales commission display processing means is performed "the terminal device to which the order data is input" may be a sales company terminal device provided in the fund sales company, the customer terminal operated by the customer It may be a device. The same applies to the following inventions.

  In this way, in the case of a configuration including the approximate sales commission rate determination amount calculation processing means, the approximate sales commission rate determination processing means, the approximate sales commission calculation processing means, and the approximate sales commission display processing means, the fund is purchased. When placing an order, the approximate sales commission for the order, or the approximate sales commission rate in addition to the approximate sales commission, is displayed on the terminal device, so the sales of the fund sales company that entered the order data When a worker or customer places an order, it is possible to check the estimated sales commission or the estimated sales commission rate in addition to the estimated sales commission. The approximate sales commission and the approximate sales commission rate displayed on the screen are values that reflect the amount of other orders that have not been executed if other orders have already been made by the customer on that day. Therefore, it becomes possible to grasp a more accurate value reflecting the latest information. In addition, the estimated sales commission rate applied to this order applies to other orders that have already been executed by the customer on that day as well. In some cases, the estimated sales commission rate applied to other orders that have been dealt with may change, and this change can be grasped.

  <Invention that determines the sales commission rate based on the fund unit balance>

  The present invention also relates to a sales commission calculation processing system comprising a computer that executes processing for calculating a fund sales commission to be paid to a fund sales company when a customer purchases a fund, and the order for the purchase and sale of the fund by the customer. As data, along with customer identification information about the customers who bought and sold the fund, processing to accept input of fund identification information about the fund to buy and sell, buying and selling classification data indicating whether selling and buying, and amount data or number data Order receiving processing means, fund identification information received by the order receiving processing means, trade classification data, and order data storage means for storing money amount data or unit data in association with customer identification information, and a fund owned by the customer Balance data for Balance data storage means stored in association with the order data stored in the order data storage means, the order data stored in the order data storage means and the customer identification information are the same, and For each order data for buying and selling the same fund by the same customer with the same fund identification information, in the case of an order for which the amount is specified, the buying is the sum of the amount data when the buying and selling classification data is data indicating buying From the total amount data, the deduction amount data obtained by subtracting the total amount data of the sale, which is the sum of the amount data when the trade classification data is data indicating sale, is calculated and stored in the calculated deduction amount data and balance data storage means By adding the balance data of the customer's fund the previous day, the final sales commission rate for the order data to be processed is determined. In the case of order for which the amount data is calculated or the number of units is specified, the buy / sell classification data is the data indicating the sale from the total buy quantity data obtained by adding up the quantity data when the buy / sell classification data is data indicating buy. Fund identification information about the fund is calculated from the reference price storage means that calculates the subtraction data obtained by subtracting the total number of sales data obtained by adding the number of units in a certain case and stores the reference price data of each fund in association with the fund identification information. Using the key as the key, the basic price data of the fund the previous day is extracted, and the calculated amount data is multiplied by the calculated basic price data of the previous day for the fund, and the calculated amount data and balance data are stored. By adding the previous day's balance data of the customer's fund stored in the means, the order data to be processed Finalized sales commission rate determination amount calculation processing means for executing processing for calculating final sales commission rate determination amount data, and final sales related to the processing target order data calculated by the final sales commission rate determination amount calculation processing means Based on the fee rate determination amount data, the relationship between the purchase amount of the fund and the sales fee rate is determined and stored in the sales fee rate table storage means or using the sales fee rate table described in the program. Finalized sales commission rate determination processing for executing processing for determining finalized sales commission rate data that is commonly applied to each order data of the customer's promised purchases stored in the order data storage means including the order data of Means and order data stored in the order data storage means in the case of an order for which the amount is specified If the order data is the data indicating buy and sell, and the fixed sales commission rate data determined by the fixed sales commission rate determination processing means, or in the case of an order with a specified number, Using unit data in the case of data indicating buying, reference price data stored in the reference price storage means or order data storage means, and fixed sales commission rate data determined by the fixed sales commission rate determination processing means And a fixed sales commission calculation processing means for executing a process of calculating final sales commission data relating to the contracted purchase order to be processed.

  Such a sales commission calculation processing system of the present invention (invention that determines the sales commission rate by the balance of the fund unit) has substantially the same operation as the above-described “invention of determining the sales commission rate by the balance of the fund group unit”.・ Effects can be obtained. In other words, the above-mentioned “invention for determining the sales commission rate based on the balance of fund group unit” adds the purchase amount and the sale amount of each fund belonging to the same fund group, and each fund belonging to the same fund group. The balance is also totaled and added to calculate the fixed sales commission rate determination amount, whereas in the above “invention to determine the sales commission rate based on the fund unit balance”, one fund group unit is used instead of one fund group unit. Sums the purchase amount and sale amount for the fund (meaning that if there are multiple purchases and multiple sales on the same day for one fund), the balance up to the previous day is not the unit of the fund group. The balance of one fund is different, but the balance up to the previous day and the amount of other orders on the same day Since it is the amount for determining the fixed sales commission rate that is reflected, it is the same as the “invention that determines the sales commission ratio based on the balance of the fund group unit” described above, so the fixed sales commission rate is purchased with one order. The fixed sales commission is cheaper because it is advantageous to the customer, that is, lower than the case where the decision is based only on the amount of funds to be made.

  This makes it easier for customers to make additional purchases of funds, and allows fund sales companies to acquire customers and prevent the outflow of customers to other sales companies. Achieved.

  The above-mentioned “invention that determines the sales commission rate based on the fund group balance” has a larger amount for determining the fixed sales commission rate than the above “invention that determines the sales commission rate based on the fund unit balance”. Therefore, a greater effect can be obtained.

  Further, in the above-described sales commission calculation processing system (invention for determining the sales commission rate by the balance of the fund unit), the current order data and order data storage means received during the order data acceptance processing by the order acceptance processing means In the case of an order for which the amount is specified with respect to the order data of other trades that have already been placed in the same fund as the fund related to the current order by the same customer who made the current order, Subtraction by subtracting the total amount data of selling by summing the amount data when buying and selling data is data showing sales from the total amount data of buying when the amount data is buying and selling data when buying and selling division data is data showing buying Calculate the amount data, balance data calculated and balance data of the previous day of the customer's fund stored in the balance data storage means To calculate the estimated sales commission rate amount data for the current order data, or, in the case of an order with a specified number of units, the number data when the trade classification data is data indicating buying Subtracted data, which is obtained by subtracting the total number of units sold from the total number of units in the case where the trade classification data is data indicating selling, The reference price data of the previous day of the fund is extracted from the reference price storage means stored in association with the identification information by using the fund identification information about the fund as a key, and the extracted reference price data of the previous day of the fund to the calculated subtraction number data. To calculate the deduction amount data, and the calculated deduction amount data and the customer data stored in the balance data storage means. By adding the balance data of the previous day, the approximate sales commission rate determination amount calculation processing means for executing a process of temporarily calculating the approximate sales commission rate determination amount data related to the current order data, and this approximate sales Sales commission rate table stored in the sales commission rate table storage means or described in the program based on the approximate sales commission rate determination amount data related to the current order data temporarily calculated by the commission rate determination amount calculation processing means Approximate sales that are commonly applied to the current order data in the case of a purchase accepted by the order acceptance processing means and other order data of other orders already placed before execution stored in the order data storage means Accepted by approximate sales commission rate determination processing means for executing processing for provisionally determining fee rate data and order acceptance processing means In addition to the current order data, or in addition to the current order data, for each order data of other trades that have already been placed before the trade stored in the order data storage means, in the case of an order with a specified amount, Amount data when it is data indicating a purchase and an approximate sales commission rate data temporarily determined by the approximate sales commission rate determination processing means, or in the case of an order with a specified number, data in which the trade classification data indicates a purchase For the current order when making a purchase, using the base price data of the previous day stored in the base price storage means and the approximate sales commission rate data provisionally determined by the approximate sales commission rate determination processing means. In addition to the estimated sales commission data related to the purchase, or the estimated sales commission data related to the current order in the case of a purchase, in addition to the estimated sales commission data prior to the contract, Approximate sales commission calculation processing means for executing provisional calculation of sales commission data, approximate sales commission data temporarily calculated by this approximate sales commission calculation processing means, or approximate sales commission rate determination processing means in addition to the approximate sales commission data It is desirable to have a configuration comprising approximate sales commission display processing means for executing processing for displaying the approximate sales commission rate data provisionally determined by the above on the screen of the terminal device to which the order data has been input.

  As described above, in the “invention for determining the sales commission rate by the balance of the fund unit”, the amount calculation processing means for determining the approximate sales commission rate, the approximate sales commission rate determination processing means, the approximate sales commission calculation processing means, and the approximate sales commission display processing Even when the configuration including the means is adopted, the same operation and effect as those obtained when the same configuration is adopted in the above-described “invention for determining the sales commission rate by the balance of the fund group unit” can be obtained.

  <Invention that determines the sales commission rate based on the balance of multiple specific funds specified by the customer>

  The present invention is also a sales commission calculation processing system comprising a computer that executes processing for calculating a fund sales commission to be paid to a fund sales company when a customer purchases a fund, and the sales commission is advantageous for the customer. The specific fund storage means for storing the fund identification information for a plurality of funds designated by the customer as a specific fund in association with the customer identification information for the customer who has designated the specific fund, and the customer designates the specific fund The data for displaying the specific fund designation screen for the customer is transmitted to the customer terminal device operated by the customer via the communication line, and the plurality of specific funds designated by the customer transmitted from the customer terminal device via the communication line Associate fund identification information with customer identification information for specific fund storage Specific fund registration processing means for executing the processing to be stored in the bank, as well as customer identification information about the funds that are bought and sold, as well as customer identification information about the funds that are bought and sold, as selling and buying order data. Order acceptance processing means for executing processing for accepting input of trade classification data, monetary data or number data, and fund identification information, trade classification data, amount data or number data received by the order acceptance processing means Is stored in the order data storage means, the balance data storage means for storing the balance data of the fund held by the customer in association with the fund identification information and the customer identification information, and the order data storage means. Order data at the time of order processing The customer's specific fund in which the fund identification information included in the order data is stored in the specific fund storage means by referring to the specific fund storage means using the customer identification information included in the processing order data stored in the storage means as a key. By the same customer whose order identification data and customer identification information are the same, and which contains fund identification information for one of the specific funds of the customer For each order data of the trades traded by each specific fund, in the case of an order with a specified amount, the trade classification data is obtained from the total amount data of the buy, which is the sum of the price data when the trade classification data is data indicating buy. Calculate the deduction amount data by subtracting the total amount data of the sale, which is the sum of the amount data when it is data indicating sales, and calculate Data for determining the fixed sales commission rate related to the order data to be processed by adding the total amount data of the balance data of the previous day for all the specific funds of the customer stored in the balance data storage means In the case of order for which the number of units is specified, or in the case where the trading category data is data indicating selling from the total number data of buying, where the trading category data is data indicating buying, Calculates the deducted unit data for each specific fund by subtracting the total unit data of the sale, which is the total of the unit number data of each unit, and stores the base price data of each fund in association with the fund identification information from each specific fund. The base price data of the previous day of each specific fund is extracted using the fund identification information for Calculate the deduction amount data of each specific fund by multiplying the number of subtraction data by the base price data of the previous day of each specific fund extracted, and store the total amount data and balance data of the calculated deduction amount data of each specific fund. Finalized sales commission that executes the process to calculate the final sales commission rate determination amount data for the order data to be processed by adding the total amount data of the balance data of the previous day for all the specific funds of the stored customer Based on the amount data for determining the fixed sales commission rate for the processing target order data calculated by the amount calculation processing means for determining the rate and the amount calculation processing means for determining the fixed sales commission rate, Sales number stored in the sales commission rate table storage means or described in the program Using the rate table, determine the fixed sales commission rate data that is commonly applied to each order data of the promised purchase of each specific fund of the customer stored in the order data storage means including the order data to be processed In the case of an order for which the amount is specified for the order data to be processed stored in the fixed sales commission rate determination processing means for executing the processing and the order data storage means, the purchase / sale classification data is data indicating purchase. Using the amount data and the fixed sales commission rate data determined by the fixed sales commission rate determination processing means, or in the case of an order with a specified number of units, the unit data and the reference price when the trade classification data is data indicating buying Determined by the reference price data of the contract date stored in the storage means or the order data storage means and the fixed sales commission rate determination processing means And a fixed sales commission calculation processing means for executing a process for calculating final sales commission data related to the contracted purchase order to be processed using the finalized sales commission rate data. It is.

  With respect to such a sales commission calculation processing system of the present invention (invention that determines a sales commission rate based on the balance of a set unit of a plurality of specific funds specified by the customer) Actions and effects similar to those of the “determining invention” can be obtained. In other words, the above-mentioned “invention for determining the sales commission rate based on the balance of fund group unit” adds the purchase amount and the sale amount of each fund belonging to the same fund group, and each fund belonging to the same fund group. The balance is also totaled, and these are added together to calculate the fixed sales commission rate determination amount, whereas in the above "Invention to determine the sales commission rate based on the balance of the collective unit specified by the customer" , The purchase amount and sale amount of multiple specified funds specified by the customer are totaled, and the balance of the specified funds specified by the customer is also added, and these are added together to calculate the fixed sales commission rate determination amount Although the point is different, as mentioned above, it will be the final sales commission rate determination amount that reflects the balance up to the previous day and the amount of other orders on the same day. Since it is the same as the invention that determines the sales commission rate based on the balance of the fund group unit, the fixed sales commission rate is advantageous to the customer compared with the case where it is determined based only on the amount of funds purchased in one order. In other words, because it is lower, the fixed sales commission is lower.

  This makes it easier for customers to make additional purchases of funds, and allows fund sales companies to acquire customers and prevent the outflow of customers to other sales companies. Achieved.

  In the above-mentioned “invention that determines the sales commission rate based on the balance of the fund group unit”, the fund group is determined by the fund sales company, whereas the above “set unit of a plurality of specific funds specified by the customer”. In the invention that determines the sales commission rate based on the balance, the customer can specify a plurality of specific funds. The “invention to be determined” has a higher degree of freedom for customer selection, and can provide a service that meets the customer's purpose or a service that reflects the customer's intention. However, in the case where a fund that is not designated as a specific fund is purchased, the effect of the present invention can be obtained if the fund to be purchased belongs to one of the fund groups. The above-mentioned “invention that determines the sales commission rate based on the balance of the fund group unit” that can be enjoyed can provide more uniform service.

  Further, in the above-described sales commission calculation processing system (invention that determines the sales commission rate based on the balance of a set unit of a plurality of specific funds specified by the customer) Amount specified for each order data of other trades that have already been placed before the execution of a specific fund of one of the customer's specific funds by the same customer who made the current order stored in the order data and order data storage means In the case of an order, the sum of the amount data when the trade classification data is data indicating the sale from the total amount data of the purchase when the trade classification data is data indicating the purchase, Calculate the deduction amount data by subtracting the total amount data, and calculate all the deduction amount data and all of the customers stored in the balance data storage means By adding the total amount data of the balance data on the previous day of the fixed fund, the amount data for determining the approximate sales commission rate related to the current order data is provisionally calculated, or in the case of an order with a specified number of units, the trading category Subtracted number data obtained by subtracting the total number data of selling, which is the sum of the number data when buying / selling data is data indicating selling, from the total number data of buying, where the number data is the data indicating buy. From the reference price storage means that stores the reference price data of each fund in association with the fund identification information, using the fund identification information for each specific fund as a key Data is extracted and the base price data of the previous day of each specific fund is extracted to the calculated subtraction number data for each specific fund. To calculate the total amount data of each specific fund, and the total amount data of the calculated subtraction amount data and the total amount data of the balance data of the previous day of all the specific funds of the customer stored in the balance data storage means By adding, the approximate sales commission rate determination amount calculation processing means for executing the process of temporarily calculating the approximate sales commission rate determination amount data related to the current order data, and the approximate sales commission rate determination amount calculation processing means Order reception processing means using the sales commission rate table stored in the sales commission rate table storage means or described in the program, based on the estimated sales commission rate determination amount data relating to the current order data temporarily calculated by In the case of the purchase accepted by the current order data and the existing trade data stored in the order data storage means Approximate sales commission rate determination processing means for executing provisional determination of approximate sales commission rate data applied in common to each order data of other purchases of the order, and current order data received by the order reception processing means, or In addition to the current order data, for each order data of other trades that have already been placed before the trade stored in the order data storage means, in the case of an order for which the amount is specified, the trade classification data is data indicating purchase. Amount data, and estimated sales commission rate data tentatively determined by the approximate sales commission rate determination processing means, or in the case of order with a specified number, the number data when the trade classification data is data indicating buying , The base price data of the previous day stored in the base price storage means, and the approximate sales commission rate data provisionally determined by the approximate sales commission rate determination processing means Approximate sales commission data related to the current order when buying, or estimated sales commission data related to the current order when buying, in addition to the estimated sales related to other orders that have already been placed before execution Approximate sales commission calculation processing means for executing provisional calculation of sales commission data, approximate sales commission data temporarily calculated by this approximate sales commission calculation processing means, or approximate sales commission rate determination processing means in addition to the approximate sales commission data It is desirable to have a configuration comprising approximate sales commission display processing means for executing processing for displaying the approximate sales commission rate data provisionally determined by the above on the screen of the terminal device to which the order data has been input.

  In this way, in the “invention that determines the sales commission rate based on the balance of the collective unit specified by the customer”, the amount calculation processing means for determining the approximate sales commission rate, the approximate sales commission rate determination processing means, and the approximate sales commission calculation Even in the case of adopting a configuration comprising processing means and approximate sales fee display processing means, the same effect as in the case of adopting a similar configuration in the above-mentioned “invention for determining the sales commission rate with the balance of the fund group unit”・ Effects can be obtained.

  <Invention that determines the sales commission rate based on the balance of a specific fund unit specified by the customer>

  The present invention is also a sales commission calculation processing system comprising a computer that executes processing for calculating a fund sales commission to be paid to a fund sales company when a customer purchases a fund, and the sales commission is advantageous for the customer. The specific fund storage means for storing the fund identification information for at least one fund designated by the customer as a specific fund in association with the customer identification information for the customer who designated the specific fund, and the specific fund designated by the customer Data for display of a specific fund designation screen to be transmitted to the customer terminal device operated by the customer via the communication line, and at least one specified by the customer transmitted from the customer terminal device via the communication line Associate fund identification information for a specific fund with customer identification information Specific fund registration processing means for executing processing to be stored in the specific fund storage means, as well as customer identification information about the customers who bought and sold the funds, as well as fund identification information about the funds to be bought and sold, as order data for buying and selling funds by the customers Order receiving processing means for executing processing for accepting input of selling / buying distinction data, amount data or number data, fund identification information received by the order receiving processing means, buying / selling classification data, and amount Order data storage means for storing data or quantity data in association with customer identification information, balance data storage means for storing balance data of funds held by customers in association with fund identification information and customer identification information, and order data Execution of order data stored in storage means At the time of processing, the specific fund storage means is referred to using the customer identification information included in the processing order data stored in the order data storage means as a key, and the fund identification information included in the processing order data is specified fund storage means. It is determined whether or not it is the fund identification information for the specific fund of the customer stored in, and the order data to be processed and the customer identification information are the same, and the same fund identification information for the specific fund is the same For each order data of contracts for the same specific fund by the customer, in the case of an order with specified amount, buy and sell from the total amount data of the buy that is the sum of the amount data when the buy and sell classification data is data indicating buy Subtraction amount data obtained by subtracting the total amount data of the sale, which is the sum of the amount data when the category data is data indicating sale , And adding the calculated deduction amount data and the balance data of the customer's specific fund stored in the balance data storage means the previous day's balance data, the final sales commission rate determination amount data relating to the processing order data is obtained. In the case of an order to calculate or to specify the number of units, if the trading category data is data indicating selling from the total number data of buying that is the sum of the number data when the trading category data is data indicating buying Calculate the deducted unit data by subtracting the total unit data of the sale that totaled the unit data, and store the base price data of each fund in association with the fund identification information, and store the fund identification information for the specific fund as a key. As a result, the base price data of the specific fund the previous day is extracted, and the calculated balance unit data is The price data is calculated by multiplying the base price data, and the order data to be processed is added by adding the calculated price data and the balance data of the customer's specific fund stored in the balance data storage means on the previous day. Finalized sales commission rate determination amount calculation processing means for executing processing for calculating the fixed sales commission rate determination amount data, and finalization related to the processing target order data calculated by the final sales commission rate determination amount calculation processing means Based on the sales commission rate determination amount data, the relationship between the fund purchase amount and the sales commission rate is determined and processed using the sales commission rate table stored in the sales commission rate table storage means or described in the program Each order of the promised purchase of the customer's specific fund stored in the order data storage means including the target order data The fixed sales commission rate determination processing means for executing the process for determining the fixed sales commission rate data that is commonly applied to the data, and the order data to be processed stored in the order data storage means If the order data is the data indicating buy and sell, and the fixed sales commission rate data determined by the fixed sales commission rate determination processing means, or in the case of a number-specified order, Quantity data when the category data is data indicating buying, reference price data stored in the reference price storage means or order data storage means, and fixed sales commission rate data determined by the fixed sales commission rate determination processing means Is used to execute the process of calculating the final sales commission data related to the contracted purchase order being processed. And a fixed sales fee calculation processing means.

  With regard to such a sales commission calculation processing system of the present invention (an invention in which the sales commission rate is determined based on the balance of a specific fund unit designated by the customer), the above-described “invention for determining the sales commission rate based on the balance of the fund group unit” It is possible to obtain substantially the same operations and effects. In other words, the above-mentioned “invention for determining the sales commission rate based on the balance of fund group unit” adds the purchase amount and the sale amount of each fund belonging to the same fund group, and each fund belonging to the same fund group. The balance is also totaled and added to calculate the fixed sales commission rate determination amount, whereas in the above “invention that determines the sales commission rate based on the balance of a specific fund unit specified by the customer”, the fund group unit Rather, sum the purchase amount and sale amount for one specific fund (meaning that if there is multiple purchases and multiple sales for one specific fund on the same day), the balance up to the previous day However, the difference is that the balance for one specific fund is added instead of the fund group unit. It is the same as the above-mentioned “Invention for determining the sales commission rate based on the balance of the fund group” in that it is the amount for determining the final sales commission rate that reflects the amount of other orders on the same day and high. Since the sales commission rate is advantageous to the customer, that is, lower than the case where the sales commission rate is determined only based on the amount of funds purchased in one order, the fixed sales commission is cheap.

  This makes it easier for customers to make additional purchases of funds, and allows fund sales companies to acquire customers and prevent the outflow of customers to other sales companies. Achieved.

  In addition, the above-mentioned “invention that determines the sales commission rate based on the collective unit balance of a plurality of specific funds specified by the customer” determines the sales commission rate based on the balance of the specific fund unit specified by the customer. Since the fixed sales commission rate determination amount is larger than that of the “invention”, a greater effect can be obtained.

  Furthermore, in the above-described sales commission calculation processing system (invention that determines the sales commission rate based on the balance of a specific fund unit specified by the customer), the current order data and order received during the order data acceptance processing by the order acceptance processing means For each order data of other trades that have already been placed before the execution of the same specific fund by the same customer as the customer who made the current order stored in the data storage means, in the case of an order with a specified amount, Subtracted amount obtained by subtracting the total amount data of selling, which is the sum of the amount data when buying / selling data is the data indicating selling, from the total amount data of buying, where the amount data is totaling when the category data is data indicating buying Data is calculated, and the calculated balance amount data and the balance data of the customer's specific fund stored in the balance data storage means the day before By adding, the amount data for determining the approximate sales commission rate related to the current order data is provisionally calculated, or in the case of an order with a specified number of units, the unit data when the trade classification data is data indicating buying Calculate the subtracted data by subtracting the total number of units of selling, which is the sum of the number of units when the selling / buying data is data indicating selling, from the total number of units of buying, and identify the fund's base price data The reference price data for the specific fund is extracted from the reference price storage means stored in association with the information using the fund identification information for the specific fund as a key. Multiply the price data to calculate the deduction amount data and store the calculated deduction amount data and balance data storage means. An approximate sales commission rate determination amount calculation processing means for executing a process of temporarily calculating the amount data for approximate sales commission rate determination related to the current order data by adding the balance data of the customer's specific fund the previous day; Sales stored in the sales commission rate table storage means or described in the program based on the approximate sales commission rate determination amount data related to the current order data temporarily calculated by the approximate sales commission rate determination amount calculation processing means Using the commission rate table, it applies in common to the current order data in the case of a purchase accepted by the order acceptance processing means and the other order data of other orders already placed before execution stored in the order data storage means. Approximate sales commission rate determination processing means for executing processing for temporarily determining approximate sales commission rate data and order reception processing means In the case of an order for which the amount is specified, the current order data received from the current order, or other order data of other orders that have already been placed and placed before the trade stored in the order data storage means in addition to the current order data. If the classification data is data indicating buy and purchase, and the estimated sales commission rate data provisionally determined by the approximate sales commission rate determination processing means, or in the case of an order with a specified number of units, the trade classification data is This is the case of buying using the unit price data, the base price data of the previous day stored in the base price storage means, and the approximate sales commission rate data provisionally determined by the approximate sales commission rate determination processing means. In addition to the estimated sales commission data for the current order or the estimated sales commission data for the current order in the case of a purchase, Approximate sales commission calculation processing means for executing a process for temporarily calculating approximate sales commission data related to the order, and approximate sales commission data temporarily calculated by this approximate sales commission calculation processing means, or approximate sales commission data in addition to the approximate sales commission data The estimated sales commission rate data temporarily determined by the rate determination processing means may be configured to include approximate sales commission display processing means for executing processing for displaying on the screen of the terminal device to which the order data has been input. desirable.

  In this way, in the “invention for determining the sales commission rate with the balance of a specific fund unit specified by the customer”, the amount calculation processing means for determining the approximate sales commission rate, the approximate sales commission rate determination processing means, the approximate sales commission calculation processing means, and Even when the configuration with the approximate sales commission display processing means is adopted, the same operation and effect as in the case of adopting the same configuration in the above-mentioned “invention for determining the sales commission rate by the balance of the fund group unit” is obtained. It is done.

  <Invention that determines the sales commission rate based on the collective balance of multiple funds with a large balance>

  The present invention also relates to a sales commission calculation processing system comprising a computer that executes processing for calculating a fund sales commission to be paid to a fund sales company when a customer purchases a fund, and the order for the purchase and sale of the fund by the customer. As data, along with customer identification information about the customers who bought and sold the fund, processing to accept input of fund identification information about the fund to buy and sell, buying and selling classification data indicating whether selling and buying, and amount data or number data Order receiving processing means, fund identification information received by the order receiving processing means, trade classification data, and order data storage means for storing money amount data or unit data in association with customer identification information, and a fund owned by the customer Balance data for Balance data storage means stored in association with the order data stored in the order data storage means, each order having the same processing target order data and customer identification information stored in the order data storage means In the case of an order for which the amount is specified, the amount data in the case where the transaction classification data is data indicating selling, from the total amount data of the purchase in which the amount data in the case where the transaction classification data is data indicating the purchase. For each fund, the deduction amount data obtained by subtracting the total amount data of the sale that is the sum of the sums is calculated. Calculate the balance data for each fund held by the customer by adding for each fund, or specify the number of orders In this case, the total number data of selling is the sum of the number data when buying and selling data is the data indicating selling from the total number data of buying when the buying and selling data is data indicating buying. From the reference price storage means that calculates the subtraction data for each fund and stores the reference price data of each fund in association with the fund identification information, using the fund identification information for each fund as a key, the previous day of each fund The base price data of each fund is extracted and the calculated base unit data for each fund is multiplied by the base price data of the previous day for each fund to calculate the subtracted amount data for each fund. The data and the balance data of the previous day for each fund of the customer stored in the balance data storage means are added for each fund. As a result, the balance data for each fund held by the customer is calculated, and a plurality of large balance funds whose amount of the calculated balance data for the funds is equal to or higher than a predetermined order are determined, and the order data to be processed is determined. If the fund with the fund identification information included is a large balance fund, the amount data for determining the fixed sales commission rate related to the order data to be processed is obtained by summing the balance data for each of the multiple large balance funds. Based on the fixed sales commission rate determination amount calculation processing means for executing the calculation process, and the fixed sales commission rate determination amount data related to the processing order data calculated by the fixed sales commission rate determination amount calculation processing means, The relationship between the purchase price of the fund and the sales commission rate is determined and stored in the sales commission rate table storage means. Using the sales commission rate table described in the program, it is commonly applied to each order data of promised purchases of the customer's large balance fund stored in the order data storage means including the order data to be processed. In the case of an order for which the amount is specified for the fixed order commission rate determination processing means for executing the processing for determining the fixed sales commission rate data to be processed and the order data to be processed stored in the order data storage means, the trade classification data Amount data when is a data indicating buy and a fixed sales commission rate data determined by the fixed sales commission rate determination processing means, or in the case of an order with a specified number, data in which the trade classification data indicates a buy Unit price data, standard price data stored in the standard price storage means or order data storage means, And a final sales commission calculation processing means for executing a process for calculating final sales commission data relating to the contracted purchase order to be processed using the final sales commission rate data determined by the final sales commission rate determination processing means. It is characterized by comprising.

  With regard to such a sales commission calculation processing system of the present invention (an invention in which the sales commission rate is determined based on the collective unit balance of a plurality of funds having a large balance), the above-described “determining the sales commission rate based on the fund group unit balance” is described above. Actions and effects similar to those of the invention can be obtained. In other words, the above-mentioned “invention for determining the sales commission rate based on the balance of fund group unit” adds the purchase amount and the sale amount of each fund belonging to the same fund group, and each fund belonging to the same fund group. The balance is also totaled, and these are added to calculate the fixed sales commission rate determination amount, whereas in the above "invention that determines the sales commission rate with the collective balance of multiple funds with many balances" Although the sum of the purchases and sales amounts of multiple funds with a large number of funds and the sum of the balances of multiple funds with a large balance are added together to calculate the final sales commission rate determination amount. In terms of the fixed sales commission rate determination amount reflecting the balance up to the previous day and the amount of other orders on the same day, Since the final sales commission rate is advantageous to the customer, that is, lower than the case where it is determined based only on the amount of funds purchased in one order, Fixed sales commissions are cheaper.

  This makes it easier for customers to make additional purchases of funds, and allows fund sales companies to acquire customers and prevent the outflow of customers to other sales companies. Achieved.

  Furthermore, in the above-described sales commission calculation processing system (invention for determining the sales commission rate based on the balance of the collective unit of a plurality of funds having a large balance), the current order data received at the time of order data reception processing by the order reception processing means In addition, for each order data of other trades that have already been placed by the same customer as the customer who made the current order stored in the order data storage means, in the case of an order with a specified amount, Each subtracted amount data is obtained by subtracting the total amount data of the sale, which is the sum of the amount data when the sales classification data is the data indicating the sale, from the total amount data of the purchase where the amount data is the data indicating the purchase. Calculated for each fund, the balance of the previous day of each fund of the customer stored in the balance data storage means and the balance amount data calculated for each fund Data for each fund is calculated by adding the data for each fund, or in the case of order with a specified number of units, the trading classification data is data indicating buying For each fund, subtracted data is calculated for each fund by subtracting the total data of the sales, which is the sum of the sales data when the trading classification data is data indicating selling, From the reference price storage means that stores the reference price data of the fund in association with the fund identification information, the reference price data of the previous day of each fund is extracted using the fund identification information for each fund as a key, and the calculated number of subtraction units for each fund Multiply the data by the base price data of the previous day of each extracted fund to calculate the deduction amount data for each fund. The balance data for each fund held by the customer is calculated by adding the balance data of the funds and the balance data of the previous day of each fund of the customer stored in the balance data storage means for each fund. If a large amount of funds is determined that the amount of the balance data by fund is equal to or higher than the predetermined order, and the fund with the fund identification information included in the current order data is a large amount balance fund, Approximate sales commission rate determination amount calculation processing means for executing provisional calculation of the estimated sales commission rate determination amount data related to the current order data by summing the balance data by funds for the balance fund, and this approximate Amount for determining the approximate sales commission rate related to the current order data temporarily calculated by the sales fee rate determination processing means Based on the data, the current order data and order data storage means in the case of a purchase accepted by the order acceptance processing means using the sales commission rate table stored in the sales commission rate table storage means or described in the program An approximate sales commission rate determination processing means for executing a process for temporarily determining approximate sales commission rate data to be commonly applied to each order data of other previously purchased orders that have been stored before the execution, and an order reception processing means In the case of an order with a specified amount for each order data of the current order data received, or other order data for other orders that have already been placed before execution, which is stored in the order data storage means in addition to the current order data, Amount data when the data is data indicating buying, and an approximate seller temporarily determined by the approximate sales commission rate determination processing means In the case of orders with rate data, or in the case of ordering units, the unit data when the trade classification data is data indicating buying, the base price data of the previous day stored in the base price storage means, and the approximate sales commission rate Using the estimated sales commission rate data provisionally determined by the decision processing means, in addition to the estimated sales commission data related to the current order in the case of buying, or the estimated sales commission data relating to the current order in the case of buying, Approximate sales commission calculation processing means for executing a process for temporarily calculating approximate sales commission data relating to each other purchase order already placed, and approximate sales commission data calculated by this approximate sales commission calculation processing means, or approximate sales In addition to the commission data, the order data was entered for the estimated sales commission rate data provisionally determined by the approximate sales commission rate determination processing means. It is desirable to adopt a configuration in which a rough estimate sales charge display processing means for executing processing for displaying on the screen of the end device.

  As described above, in the “invention for determining the sales commission rate with the balance of the collective unit of a plurality of funds having a large balance”, the amount calculation processing means for determining the approximate sales commission rate, the approximate sales commission rate determination processing means, the approximate sales commission calculation processing means , And when the configuration with the approximate sales commission display processing means is adopted, the same operation and effect as the case of adopting the same configuration in the above-mentioned “invention for determining the sales commission rate by the balance of the fund group unit” described above Is obtained.

  <Invention for determining the sales commission rate based on the balance of funds with a large balance>

  The present invention also relates to a sales commission calculation processing system comprising a computer that executes processing for calculating a fund sales commission to be paid to a fund sales company when a customer purchases a fund, and the order for the purchase and sale of the fund by the customer. As data, along with customer identification information about the customers who bought and sold the fund, processing to accept input of fund identification information about the fund to buy and sell, buying and selling classification data indicating whether selling and buying, and amount data or number data Order receiving processing means, fund identification information received by the order receiving processing means, trade classification data, and order data storage means for storing money amount data or unit data in association with customer identification information, and a fund owned by the customer Balance data for Balance data storage means stored in association with the order data stored in the order data storage means, each order having the same processing target order data and customer identification information stored in the order data storage means In the case of an order for which the amount is specified, the amount data in the case where the transaction classification data is data indicating selling, from the total amount data of the purchase in which the amount data in the case where the transaction classification data is data indicating the purchase. For each fund, the deduction amount data obtained by subtracting the total amount data of the sale that is the sum of the sums is calculated. Calculate the balance data for each fund held by the customer by adding for each fund, or specify the number of orders In this case, the total number data of selling is the sum of the number data when buying and selling data is the data indicating selling from the total number data of buying when the buying and selling data is data indicating buying. From the reference price storage means that calculates the subtraction data for each fund and stores the reference price data of each fund in association with the fund identification information, using the fund identification information for each fund as a key, the previous day of each fund The base price data of each fund is extracted and the calculated number of balances of each fund is multiplied by the base price data of the previous day of each extracted fund to calculate the balance amount data for each fund. And the balance data of the previous day for each fund of the customer stored in the balance data storage means for each fund. The balance data for each fund held by the customer is calculated, and multiple large balance funds whose amount of the calculated balance data is over a predetermined rank are determined and included in the processing order data. If the fund with the fund identification information is a large balance fund, the fixed sale that executes the processing that uses the balance data by fund for the large balance fund as the fixed sale commission rate determination amount data related to the order data to be processed Based on the amount calculation processing means for determining the commission rate and the amount data for determining the fixed sales commission rate related to the order data to be processed calculated by the amount calculation processing means for determining the fixed sales commission rate, the purchase price of the fund and the sales commission rate Sales that are stored in the sales commission rate table storage means or described in the program. Using the multi-rate table, determine the fixed sales commission rate data that is commonly applied to each order data of the promised purchases of the customer's large balance fund stored in the order data storage means including the order data to be processed In the case of an order for which the amount is specified for the order data to be processed stored in the fixed sales commission rate determination processing means and the order data storage means for executing the processing to be executed, when the trade classification data is data indicating buying Data, and the fixed sales commission rate data determined by the fixed sales commission rate determination processing means, or in the case of order with a specified number of units, the unit data when the trade classification data is data indicating buying, the standard To the reference price data of the contract date stored in the price storage means or the order data storage means, and the fixed sales commission rate determination processing means A fixed sales commission calculation processing means for executing a process for calculating final sales commission data related to the contracted purchase order to be processed using the finalized sales commission rate data determined To do.

  Such a sales commission calculation processing system of the present invention (invention that determines the sales commission rate based on the balance of the fund unit with a large balance) is abbreviated as the above-described “invention that determines the sales commission rate based on the balance of the fund group unit”. Similar actions and effects can be obtained. In other words, the above-mentioned “invention for determining the sales commission rate based on the balance of fund group unit” adds the purchase amount and the sale amount of each fund belonging to the same fund group, and each fund belonging to the same fund group. The balance is also totaled and added to calculate the fixed sales commission rate determination amount, whereas the above “invention to determine the sales commission rate with the balance of the fund unit with a large balance” is not the fund group unit. The sum of the purchase amount and sale amount for one large balance fund (meaning that if there is multiple purchases and multiple sales on the same day for one large balance fund), the balance up to the previous day However, the difference is that the balance for one large balance fund is added instead of the fund group unit. Since it is the amount for finalized sales commission rate determination that reflects the balance of other orders and the amount of other orders on the same day, it is the same as the above-mentioned `` invention to determine the sales commission rate with the balance of the fund group unit '', Since the fixed sales commission rate is advantageous to the customer, that is, lower than the case where the fixed sales commission rate is determined only based on the amount of funds purchased in one order, the fixed sales commission is low.

  This makes it easier for customers to make additional purchases of funds, and allows fund sales companies to acquire customers and prevent the outflow of customers to other sales companies. Achieved.

  The above-mentioned “invention that determines the sales commission rate with the balance of the collective unit of a plurality of funds having a large balance” is more than the above “invention that determines the sales commission rate with the balance of the fund unit with a large balance”. Since the amount for determining the fixed sales commission rate increases, a greater effect can be obtained.

  Furthermore, in the above-described sales commission calculation processing system (invention that determines the sales commission rate with the balance of each fund having a large balance), the current order data and order data stored during the order data acceptance processing by the order acceptance processing means For each order data of other trades that have already been placed by the same customer as the customer who placed the current order stored in the means, in the case of an order for which the amount is specified, the trade classification data indicates the purchase For each fund, subtracting the total amount data of the sale by subtracting the total amount data of the sum of the amount data when the trade classification data is the data indicating the sale from the total amount data of the purchase where the amount data is The calculated balance data of each fund and the balance data of the previous day of each customer's fund stored in the balance data storage means By adding for each fund, the balance data for each fund held by the customer is calculated, or in the case of an order with a specified number of units, the total of the number data when the trade classification data is data indicating buying The base price data of each fund is calculated for each fund by subtracting the total number of units of selling, which is the total of the number of units when the trading classification data is data indicating selling, from the total number of units of buying and selling. The reference price data for each fund was extracted from the reference price storage means that stores the information in association with the fund identification information, using the fund identification information for each fund as a key, and extracted to the calculated subtraction data for each fund. Multiply the base price data of the previous day of each fund to calculate the deduction amount data for each fund, The balance data for each fund held by the customer is calculated by adding the discount amount data and the balance data for the previous day for each fund of the customer stored in the balance data storage means. When multiple large balance funds whose amount is greater than or equal to a predetermined order are determined and the fund with fund identification information included in the current order data is a large balance fund, the balance by fund for the large balance fund Approximate sales commission rate determination amount calculation processing means for executing the process of making the data into the approximate sales commission rate determination amount data related to the current order data, and the estimated sales commission rate determination amount calculation processing means tentatively calculated this time Stored in the sales commission rate table storage means based on the approximate sales commission rate determination amount data relating to the order data of Alternatively, using the sales commission rate table described in the program, in addition to the current order data in the case of the purchase accepted by the order acceptance processing means and the pre-contracted orders that are stored in the order data storage means Approximate sales commission rate determination processing means for executing provisional determination of approximate sales commission rate data that is commonly applied to each purchase order data, and current order data received by the order reception processing means, or current order In addition to the data, for each order data of other trades that have already been placed before the trade stored in the order data storage means, in the case of an order with a specified amount, the amount when the trade classification data is data indicating buying Data, and approximate sales commission rate data temporarily determined by the approximate sales commission rate determination processing means In the case, the number data in the case where the trade classification data is data indicating buying, the base price data of the previous day stored in the base price storage means, and the approximate sales commission rate data temporarily determined by the approximate sales commission rate determination processing means Approximate sales commission data related to the current order when buying, or estimated sales commission data related to the current order when buying, in addition to the estimated sales commission data related to the current order before execution Approximate sales commission calculation processing means for executing processing to tentatively calculate commission data, approximate sales commission data temporarily calculated by the approximate sales commission calculation processing means, or approximate sales commission rate determination processing means in addition to the approximate sales commission data Approximate sales that execute the process of displaying the provisionally determined approximate sales commission rate data on the screen of the terminal device for which the order data has been entered It is desirable to adopt a configuration that includes a fee display processor.

  As described above, in the “invention for determining the sales commission rate with the balance of the fund unit having a large balance”, the amount calculation processing means for determining the approximate sales commission rate, the approximate sales commission rate determination processing means, the approximate sales commission calculation processing means, and the approximate sales Even in the case where the configuration including the fee display processing means is adopted, the same operation and effect as in the case where the same configuration is adopted in the “invention for determining the sales commission rate by the balance of the fund group unit” described above can be obtained.

  Further, as the sales commission calculation processing method realized by the sales commission calculation processing system of the present invention described above, the following sales commission calculation processing method of the present invention can be mentioned.

  <Invention that determines the sales commission rate based on the fund group unit balance>

  That is, the present invention is a sales commission calculation processing method executed by a sales commission calculation processing system comprising a computer that executes processing for calculating a fund sales commission paid to a fund sales company when a customer purchases a fund. The order reception processing means uses the customer identification information for the customer who bought and sold the fund as the order data for buying and selling the fund by the customer, as well as the fund identification information for the fund to buy and sell, Order data storage means for executing processing for accepting input of data, amount data or unit data, and associating the fund identification information, trading classification data, amount data or unit data received by the order acceptance processing unit with customer identification information And store the balance data of the funds held by the customer It is stored in the balance data storage means in association with the fund identification information and the customer identification information, and the fixed sales commission rate determination amount calculation processing means performs the order data stored in the order data storage means at the time of contract processing of each fund. The correspondence between the fund identification information and the group identification information for the fund group to which each fund belongs is determined and stored in the group table storage means or stored in the order data storage means using the group table described in the program. Group identification information corresponding to the fund identification information included in the processing target order data is extracted, the processing target order data including the processing target order data is the same as the customer identification information, and the fund identification information The same file by the same customer with the same group identification information For each order data of buying and selling of each fund belonging to a group, in the case of an order for which the amount is specified, buying and selling classification data from the total amount data of buying by adding up the amount data when the buying and selling classification data is data indicating buying Calculates the deduction amount data by subtracting the total amount data of the sale when the amount data is the data indicating the sale, and all the belonging to the fund group of the customer stored in the calculated deduction amount data and balance data storage means By adding the total amount data of the balance data of the previous day of the fund, the amount data for determining the fixed sales commission rate related to the order data to be processed is calculated, or in the case of the order with the number specified, the trading category The buy / sell category data indicates sell from the total number data of buys, which is the total of the number data when the data is data indicating buy. From the reference price storage means that calculates the subtraction data, which is obtained by subtracting the total data of the sales, which is the total of the data of the sales in the case of data, for each fund, and stores the reference price data of each fund in association with the fund identification information, Using the fund identification information for each fund as a key, extract the base price data for the previous day for each fund, and multiply the calculated number of units for each fund by the base price data for the previous day for each fund. Calculate the deduction amount data, and add the total amount data of the deduction amount data of each fund and the total amount data of the balance data of the previous day of all funds belonging to the customer fund group stored in the balance data storage means As a result, the amount data for determining the fixed sales commission rate for the order data to be processed is calculated. The fixed sale commission rate determination processing means executes the fixed sale commission rate determination amount calculation processing means based on the final sale commission rate determination amount data related to the processing target order data calculated by the fixed sale commission rate determination amount calculation processing means. Stored in the sales commission rate table storage means by defining the relationship with the commission rate or stored in the order data storage means including the order data to be processed using the sales commission rate table described in the program A process for determining fixed sales commission rate data to be applied in common to each order data of buying of each fund belonging to the customer's fund group is executed, and a final sales commission calculation processing means is stored in the order data storage means. Regarding order data to be processed, in the case of an order with a specified amount, the trade classification data is data indicating a purchase. The total amount data, and the fixed sales commission rate data determined by the fixed sales commission rate determination processing means, or in the case of an order with a specified number of units, the number data when the trade classification data is data indicating buying, Using the reference price data stored in the reference price storage means or order data storage means and the fixed sales commission rate data determined by the fixed sales commission rate determination processing means, The present invention is characterized in that a process for calculating fixed sales commission data relating to an order is executed.

  <Invention that determines the sales commission rate based on the fund unit balance>

  The present invention is also a sales commission calculation processing method executed by a sales commission calculation processing system comprising a computer that executes processing for calculating a fund sales commission paid to a fund sales company when a customer purchases a fund. The order reception processing means uses the customer identification information for the customer who bought and sold the fund as the order data for buying and selling the fund by the customer, as well as the fund identification information for the fund to buy and sell, Order data storage means for executing processing for accepting input of data, amount data or unit data, and associating the fund identification information, trading classification data, amount data or unit data received by the order acceptance processing unit with customer identification information And store the balance data of the funds held by the customer The order data storage means is stored in the balance data storage means in association with the customer identification information and the customer identification information, and the fixed sales commission rate determination amount calculation processing means performs the processing of the order data stored in the order data storage means. In the case of an order with a specified amount for each order data of the same fund traded by the same customer whose order identification data and customer identification information are the same and the fund identification information is the same The total amount data for buying, which is the sum of the amount data when buying / selling data is data showing the sale, is subtracted from the total amount data for buying, where the amount data is showing data for selling, Calculate the deduction amount data, and the balance data of the previous day of the customer's fund stored in the balance data storage means By adding, the amount data for determining the fixed sales commission rate related to the order data to be processed is calculated, or in the case of an order with a specified number of units, the unit data when the trade classification data is data indicating buying Calculate the subtracted data by subtracting the total number of units of selling, which is the sum of the number of units when the selling / buying data is data indicating selling, from the total number of units of buying, and identify the fund's base price data The reference price data of the previous day of the fund is extracted from the reference price storage means stored in association with the information using the fund identification information about the fund as a key, and the reference price data of the previous day of the extracted fund is added to the calculated subtraction number data. Multiplying to calculate the deduction amount data, the calculated deduction amount data and the customer fan stored in the balance data storage means By adding the balance data of the previous day, the process for calculating the fixed sales commission rate determination amount data related to the processing order data is executed, and the final sales commission rate determination processing means determines the final sales commission rate The relationship between the purchase price of the fund and the sales commission rate is determined and stored in the sales commission rate table storage means based on the fixed sales commission rate determination amount data related to the processing order data calculated by the business amount calculation processing means, or Using the sales commission rate table described in the program, the confirmation that is applied in common to each order data of the promised buy of the customer's fund stored in the order data storage means including the order data to be processed The processing for determining the sales commission rate data is executed, and the fixed sales commission calculation processing means is stored in the order data storage means. For order data to be processed, in the case of an order with a specified amount, use the amount data when the trade classification data is data indicating buying, and the fixed sales fee rate data determined by the fixed sales fee rate determination processing means. Or, in the case of an order with a specified number of units, the unit price data when the trade classification data is data indicating buying, the standard price data stored in the standard price storage means or the order data storage means, and the fixed sales fee Using the fixed sales commission rate data determined by the rate determination processing means, a process for calculating fixed sales commission data relating to a promised purchase order to be processed is executed.

  <Invention that determines the sales commission rate based on the balance of multiple specific funds specified by the customer>

  Furthermore, the present invention is a sales commission calculation processing method executed by a sales commission calculation processing system comprising a computer that executes processing for calculating a fund sales commission paid to a fund sales company when a customer purchases a fund. Thus, the fund identification information for a plurality of funds designated by the customer as a specific fund for which the sales commission is advantageous to the customer is stored in the specific fund storage means in association with the customer identification information for the customer designated as the specific fund. The specific fund registration processing means transmits the data for displaying the specific fund designation screen for the customer to designate the specific fund to the customer terminal device operated by the customer via the communication line and communicates from the customer terminal device. About multiple specific funds specified by customers sent via the line Executes the process of storing the fund identification information in the specific fund storage means in association with the customer identification information, and the order reception processing means uses the customer identification for the customer who bought and sold the fund as the order data of the fund trading by the customer. Along with information, fund identification information about funds to be bought and sold, buying and selling classification data indicating whether to sell and buy, and processing to accept input of amount data or number data, fund identification information received by order receiving processing means, buying and selling The classification data and the amount data or the number data are stored in the order data storage means in association with the customer identification information, and the balance data of the fund held by the customer is stored in the balance data storage means in association with the fund identification information and the customer identification information. The amount calculation processing means for determining and determining the fixed sales commission rate is At the time of execution of order data stored in the sentence data storage means, the specific fund storage means is referred to using the customer identification information contained in the order data to be processed stored in the order data storage means as a key, It is determined whether the included fund identification information is the fund identification information for the specific fund of the customer stored in the specific fund storage means, the order data to be processed and the customer identification information are the same, and any of the customers In the case of an order with a specified amount for each order data of the trade of each specific fund by the same customer that includes fund identification information for that specific fund, the trade classification data is data indicating buying Amount data in the case where the trade classification data is data indicating selling from the total amount data of buying that is the sum of the amount data in the case The deductible amount data obtained by subtracting the total amount data of the sale that is the sum of the sales amount is calculated. By adding, the amount data for determining the fixed sales commission rate related to the order data to be processed is calculated, or in the case of an order with a specified number of units, the unit data when the trade classification data is data indicating buying Calculate the subtracted data for each specific fund by subtracting the total number of units sold by adding the number of units when the trading category data is data indicating the sale from the total number of units of the total buy. From reference price storage means that stores price data in association with fund identification information, using fund identification information for each specific fund as a key Extract the basic price data for each specific fund the previous day, and calculate the deduction amount data for each specific fund by multiplying the calculated basic unit data for each specific fund by the calculated basic unit data for each specific fund. By adding the total amount data of the calculated deduction amount data of each specific fund and the total amount data of the balance data of the previous day for all the specific funds of the customer stored in the balance data storage means, the order data to be processed is added. A process for calculating the fixed sales commission rate determination amount data is executed, and the fixed sales commission rate determination processing means determines the fixed sales commission rate related to the processing target order data calculated by the fixed sales commission rate determination amount calculation processing means. Based on the decision amount data, the relationship between the purchase amount of the fund and the sales commission rate is determined and the sales commission rate table is stored. About each order data of promised purchase of each specific fund of customer stored in order data storage means including order data to be processed using sales commission rate table stored in or described in the program When the fixed sales commission calculation processing means executes the process of determining the commonly applied fixed sales commission rate data, and the fixed sales commission calculation processing means is the order of the amount specified with respect to the order data stored in the order data storage means, If the order data is the data indicating buy and sell, and the fixed sales commission rate data determined by the fixed sales commission rate determination processing means, or in the case of an order with a specified number, The base price of the trade date stored in the unit data, base price storage means or order data storage means in the case of data indicating buying Using the rating data and the finalized sales commission rate data determined by the finalized sales commission rate determination processing means, a process for calculating final sales commission data related to the contracted purchase order to be processed is executed. It is what.

  <Invention that determines the sales commission rate based on the balance of a specific fund unit specified by the customer>

  The present invention is a sales commission calculation processing method executed by a sales commission calculation processing system comprising a computer that executes processing for calculating a fund sales commission paid to a fund sales company when a customer purchases a fund. The fund identification information for at least one fund designated by the customer as a specific fund for which the sales commission is advantageous to the customer is associated with the customer identification information for the customer who designated the specific fund in the specific fund storage means. The specific fund registration processing means stores the specific fund designation screen display data for the customer to designate the specific fund to the customer terminal device operated by the customer via the communication line, and from the customer terminal device. At least one special feature specified by the customer sent over the communication line Executes the process of storing the fund identification information about the fund in the specific fund storage means in association with the customer identification information, and the order reception processing means uses the customer to buy and sell funds as order data In addition to the customer identification information, the fund identification information about the fund to be traded, the transaction classification data indicating the difference between selling and buying, and the process of accepting the input of the amount data or the number data, the fund identification received by the order acceptance processing means Information, trade classification data, amount data or number data is stored in the order data storage means in association with customer identification information, and the balance data of the fund held by the customer is related to the fund identification information and customer identification information and balance data Store in the storage means for determining the fixed sales commission rate The specific fund storage means using the customer identification information included in the order data to be processed stored in the order data storage means as a key when the amount calculation processing means executes the contract processing of the order data stored in the order data storage means To determine whether or not the fund identification information included in the order data to be processed is the fund identification information for the customer's specific fund stored in the specific fund storage means. For each order data of the same specific fund promised buying and selling by the same customer with the same identification information and the same fund identification information for the specific fund, in the case of an order with specified amount, In the case of the data indicating buy, the data indicating that the trade classification data indicates sale is obtained from the total amount data of purchase obtained by adding the amount data. Data is calculated by subtracting the total amount data of the sale, and the balance data of the previous day of the specific fund of the customer stored in the balance data storage means. To calculate the fixed sales commission rate determination amount data for the order data to be processed, or, in the case of an order with a specified number, the number data when the trade classification data is data indicating buying Subtracted data, which is obtained by subtracting the total number of units sold from the total number of units in the case where the trade classification data is data indicating selling, From the reference price storage means stored in association with the identification information, the fund identification information for the specific fund is used as a key and The base price data is extracted, and the calculated amount data is multiplied by the base price data of the specific fund the previous day to calculate the amount data, and the calculated amount data and the customer stored in the balance data storage means By adding the balance data for the specific fund of the previous day, the processing for calculating the fixed sales commission rate determination amount data for the order data to be processed is executed, and the fixed sales commission rate determination processing means Based on the fixed sales commission rate determination amount data related to the processing target order data calculated by the rate determination amount calculation processing means, the relationship between the fund purchase amount and the sales commission rate is determined and stored in the sales commission rate table storage means Or order data including order data to be processed using the sales commission rate table described in the program A process for determining fixed sales commission rate data that is commonly applied to each order data of promised purchases of a specific fund of the customer stored in the storage means is executed, and the final sales commission calculation processing means is the order data storage means In the case of an order for which the amount is specified for the order data to be processed, the amount data when the trade classification data is data indicating buying, and the fixed sales fee determined by the fixed sales fee rate determination processing means In the case of an order with rate data, or in the case of specifying the number of units, the unit price data when the trade classification data is data indicating buying, the reference price data stored in the reference price storage means or the order data storage means , And the contract to be processed using the fixed sales commission rate data determined by the fixed sales commission rate determination processing means The present invention is characterized in that a process of calculating final sales commission data relating to a purchase order is executed.

  <Invention that determines the sales commission rate based on the collective balance of multiple funds with a large balance>

  The present invention is also a sales commission calculation processing method executed by a sales commission calculation processing system comprising a computer that executes processing for calculating a fund sales commission paid to a fund sales company when a customer purchases a fund. The order reception processing means uses the customer identification information for the customer who bought and sold the fund as the order data for buying and selling the fund by the customer, as well as the fund identification information for the fund to buy and sell, Order data storage means for executing processing for accepting input of data, amount data or unit data, and associating the fund identification information, trading classification data, amount data or unit data received by the order acceptance processing unit with customer identification information And store the balance data of the funds held by the customer The order data storage means is stored in the balance data storage means in association with the customer identification information and the customer identification information, and the fixed sales commission rate determination amount calculation processing means performs the processing of the order data stored in the order data storage means. For each order data whose customer identification information is the same as the processing target order data stored in the Calculate the deduction amount data for each fund by subtracting the total amount data of the sale, which is the sum of the amount data when the trading classification data is data indicating sale, and the calculated deduction amount data for each fund The customer holds the balance data stored in the balance data storage means for each fund by adding the balance data of the previous day for each fund of the customer. Calculate the balance data for each fund for each fund, or, in the case of orders with a specified number of units, buy and sell classification data from the total number data of buying, which is the total of the number data when the trading classification data is data indicating buying. The base price for calculating the deducted unit data for each fund by subtracting the total unit data of the sale, which is the data indicating the sale, and storing the base price data of each fund in association with the fund identification information From the storage means, use the fund identification information for each fund as a key to extract the base price data for the previous day for each fund, and multiply the calculated number of units for each fund by the base price data for the previous day for each fund. To calculate the deduction amount data for each fund and store the calculated deduction amount data and balance data for each fund. The balance data for each fund of the customer is calculated by adding the balance data of the previous day of each fund of the customer stored for each fund, and the amount of the calculated balance data for each fund is calculated. When a plurality of large balance funds that are higher than the specified order are determined and the fund with fund identification information included in the order data to be processed is a large balance fund, the total balance data for each of the multiple large balance funds is summed The processing for calculating the fixed sales commission rate determination amount data related to the processing target order data is executed, and the fixed sales commission rate determination processing means calculates the fixed sales commission rate determination amount calculation processing means. Based on the data for determining the fixed sales commission rate for the target order data, the purchase price of the fund and the sales commission ratio The customer's large balance stored in the order data storage means including the order data to be processed using the sales commission rate table stored in the sales commission rate table storage means and described in the program. Executes the process of determining the fixed sales commission rate data that is commonly applied to each order data of the fund's promised purchase, and the final sales commission calculation processing means stores the order data to be processed stored in the order data storage means. In the case of an order for which the amount is specified, the amount data in the case where the trade classification data is data indicating buying, and the fixed sales fee rate data determined by the fixed sales fee rate determination processing means, or the number of units specified In the case of an order, the number data, reference price storage means or note when the trade classification data is data indicating buying. The fixed sales commission for the contracted purchase order to be processed using the reference price data for the contract date stored in the data storage means and the fixed sales commission rate data determined by the fixed sales commission rate determination processing means. A process for calculating data is executed.

  <Invention for determining the sales commission rate based on the balance of funds with a large balance>

  Furthermore, the present invention is a sales commission calculation processing method executed by a sales commission calculation processing system comprising a computer that executes processing for calculating a fund sales commission paid to a fund sales company when a customer purchases a fund. The order reception processing means uses the customer identification information for the customer who bought and sold the fund as the order data for buying and selling the fund by the customer, as well as the fund identification information for the fund to buy and sell, Order data storage means for executing processing for accepting input of data, amount data or unit data, and associating the fund identification information, trading classification data, amount data or unit data received by the order acceptance processing unit with customer identification information Store the balance data of the funds held by the customer, In order to store the order data stored in the order data storage means, the order data storage means is stored in the balance data storage means in association with the hand identification information and the customer identification information. For each order data whose customer identification information is the same as the processing target order data stored in the Calculate the deduction amount data for each fund by subtracting the total amount data of the sale, which is the sum of the amount data when the trading classification data is data indicating sale, and the calculated deduction amount data for each fund By adding the balance data stored in the balance data storage means the previous day for each fund of the customer for each fund, the customer can Calculate the balance data for each fund, or, in the case of order with a specified number of units, buy and sell classification data from the total number of units of buying that is the sum of the unit data when the trading category data is data indicating buy. The base price for calculating the deducted unit data for each fund by subtracting the total unit data of the sale, which is the data indicating the sale, and storing the base price data of each fund in association with the fund identification information From the storage means, extract the basic price data of the previous day of each fund using the fund identification information for each fund as a key, and multiply the calculated number of units of each fund by the basic price data of the previous day of each fund. Calculate the deduction amount data for each fund, and store the calculated deduction amount data and balance data storage means for each fund. The balance data for each fund of the customer is calculated for each fund by adding the balance data for the previous day of each fund for each customer, and the amount of the calculated balance data for each fund is predetermined. If multiple funds with higher balance than the ranking are determined and the fund with fund identification information included in the order data to be processed is a large balance fund, the balance data by fund for the large balance fund is processed. Executes the process for determining the fixed sales commission rate determination amount data related to the order data, and the fixed sales commission rate determination processing means determines the fixed sales related to the processing target order data calculated by the fixed sales commission rate determination amount calculation processing means. Sales commission rate table that defines the relationship between the fund purchase amount and the sales commission rate based on the commission rate determination data Using the sales commission rate table stored in the storage means or described in the program, the contracted purchase of the large balance fund of the customer stored in the order data storage means including the order data to be processed A process for determining fixed sales commission rate data that is commonly applied to each order data is executed, and the fixed sales commission calculation processing means performs an order for specifying the amount of order target data stored in the order data storage means. In the case of, using the amount data in the case where the trade classification data is data indicating buying, and the fixed sales commission rate data determined by the fixed sales commission rate determination processing means, or in the case of the order of the number specified, Stored in the number data, reference price storage means or order data storage means when the trade classification data is data indicating buying Using the reference price data for the trade date and the fixed sales commission rate data determined by the fixed sales commission rate determination processing means, to calculate the fixed sales commission data related to the contracted buy orders being processed. It is characterized by executing.

  In the sales commission calculation processing method of the present invention described above, the operations and effects obtained by the above-described sales commission calculation processing system of the present invention can be obtained as they are, thereby achieving the object.

  The program of the present invention is for causing a computer to function as the sales commission calculation processing system described above.

  The above-mentioned program or a part thereof is, for example, a magneto-optical disk (MO), a read-only memory (CD-ROM) using a compact disk (CD), a CD recordable (CD-R), a CD rewritable (CD -RW), read-only memory (DVD-ROM) using digital versatile disk (DVD), random access memory (DVD-RAM) using DVD, flexible disk (FD), magnetic tape, hard disk, It can be recorded on storage media such as read-only memory (ROM), electrically erasable and rewritable read-only memory (EEPROM), flash memory, and random access memory (RAM) for storage and distribution. And, for example, a local area network (LA ), A metropolitan area network (MAN), a wide area network (WAN), a wired network such as the Internet, an intranet, or an extranet, or a wireless communication network, or a combination thereof. It is also possible to carry it on a carrier wave. Furthermore, the above program may be a part of another program, or may be recorded on a recording medium together with a separate program.

  As described above, according to the present invention, the sales commission rate for calculating the sales commission to be paid when the fund is purchased is the sum of the amount of funds to be purchased and the balance of funds already purchased. Since it is determined by the amount of money, there is a merit that the sales commission paid at the time of fund purchase will be cheaper than before, and for the fund sales company, acquisition of customers and prevention of outflow of customers to other sales companies There is an effect that it can be planned.

  Embodiments of the present invention will be described below with reference to the drawings.

[First Embodiment]
FIG. 1 shows the overall configuration of a sales commission calculation processing system 10 according to the first embodiment of the present invention. The sales commission calculation processing system 10 of the first embodiment is an embodiment according to the above-described “invention for determining the sales commission rate based on the balance of the fund group unit”. The description of the “invention for determining” is also performed in the first embodiment. 2 shows the configuration of the group table storage unit 40, FIG. 3 shows the configuration of the balance data storage unit 41, FIG. 4 shows the configuration of the sales commission rate table storage unit 42, FIG. 5 shows the configuration of the order data storage means 43, and FIG. 6 shows the configuration of the reference price storage means 44. FIG. 7 is a flowchart showing the flow of sales commission calculation processing by the sales commission calculation processing system 10. Further, FIG. 8 shows an example of the group designation screen 100, and FIG. 9 shows an example of the order screen 120 and the order content confirmation screen 140.

  In FIG. 1, a sales commission calculation processing system 10 executes various processes relating to the calculation of sales commissions and stores various data necessary for the processing, and the sales commission calculation processing server 20 and the communication line. One or a plurality of customer terminal devices 50 connected via the network 1 and one or a plurality of sales companies connected to the sales fee calculation processing server 20 via the internal network 2 serving as a communication line It includes a terminal device 60 and one or a plurality of consignment company systems 70 connected to the sales commission calculation processing server 20 via the dedicated line 3 that is a communication line.

  The network 1 includes various forms such as LAN, MAN, WAN, the Internet, an intranet, an extranet, or a combination thereof, and is wired or wireless. Regardless of whether it is a type, in short, it may be anything that can transmit information at a certain speed between a plurality of points (regardless of the length of distance). The internal network 2 is an intranet or LAN provided inside a fund sales company (for example, a securities company) or a combination thereof. The internal network 2 may be a dedicated line, while the dedicated line 3 may be a network.

  The sales commission calculation processing server 20 includes processing means 20A for executing various processes relating to the calculation of sales commission, group table storage means 40 (see FIG. 2) connected to the processing means 20A, and balance data storage means 41 (FIG. 3). The sales commission rate table storage means 42 (see FIG. 4), the order data storage means 43 (see FIG. 5), and the reference price storage means 44 (see FIG. 6).

  The processing unit 20A includes a group designation processing unit 21, an order reception processing unit 22, an approximate sales commission rate determination amount calculation processing unit 23, an approximate sales commission rate determination processing unit 24, and an approximate sales commission calculation processing unit 25. The approximate sales commission display processing means 26, the reference price acquisition processing means 27, the order processing means 28, the fixed sales commission rate determination amount calculation processing means 29, the final sales commission rate determination processing means 30, and the final sales commission. The calculation processing means 31 and the balance update processing means 32 are included.

  The group designation processing means 21 is a group designation screen 100 (see FIG. 8) for inputting and designating the correspondence between fund identification information (in this embodiment, fund code) and group identification information (in this embodiment, group code). (For example, Web screen) display data is transmitted to the sales company terminal device 60 operated by the person in charge of the fund sales company (for example, a securities company) via the internal network 2 and the group designation screen 100 is used. The group table storage means 40 (see FIG. 2) correlates fund identification information inputted by a sales company representative and transmitted from the sales company terminal device 60 via the internal network 2 and group identification information corresponding thereto. ) Is stored. The number of funds belonging to one fund group can be, for example, three, etc., but may be any number depending on the purpose of the fund sales company, etc. Moreover, the number of funds belonging to each fund group does not need to be unified, and may be different for each fund group.

<In the case of an invention that determines the sales commission rate based on the fund unit balance>
In the case of the above-described “invention for determining the sales commission rate by the balance of the fund unit”, since the balance of the fund group unit is not calculated, the installation of the group designation processing means 21 can be omitted. . The case of the “invention for determining the sales commission rate based on the balance in units of funds” described above corresponds to the case where the group designation processing means 21 makes all fund groups a fund group composed of only one fund.

  The order reception processing means 22 is an order screen 120 (see FIG. 9, for example, Web) for a customer or a person in charge of a fund sales company (for example, a securities company) who receives a request from a customer to input order data for fund trading. Screen display data) is transmitted via the network 1 to the customer terminal device 50 operated by the customer in response to the customer's request, or the person in charge according to the request of the person in charge of the fund sales company. Is transmitted to the sales company terminal device 60 operated by the customer via the internal network 2, and as order data transmitted from the customer terminal device 50 or the sales company terminal device 60, customer identification information about the customer who bought and sold the fund (Account number in this embodiment), fund identification information (fund code in this embodiment) about the fund to be bought and sold, sale The processing is to receive the trade classification data indicating the type of purchase, the amount data or the number data, and store the received order data in the order data storage means 43 (see FIG. 5) in association with the customer identification information. . Further, the order reception processing means 22 automatically assigns order identification information (order number in the present embodiment) to each received order data, and stores it in the order data storage means 43 (see FIG. 5).

  The approximate sales commission rate determination amount calculation processing means 23 executes a process of temporarily calculating the approximate sales commission rate determination amount data related to the received current order data when the order reception processing means 22 receives the order data. Is. The amount data for determining the approximate sales commission rate is not the amount data for determining the final sales commission rate after the execution of the order, but is provisional data that is obtained using information before the execution, in order to determine the approximate sales commission rate This is the monetary data that is the basis of the.

  Specifically, the approximate sales commission rate determining amount calculation processing means 23 uses the group table storage means 40 (fund code) included in the current order data received by the order reception processing means 22 as a key. 2), group identification information (group code) corresponding to the fund identification information included in the current order data is extracted, and all fund identification information corresponding to the extracted group identification information is acquired from the group table storage means 40. By doing so, information of each fund belonging to the same fund group as the fund related to the current order data is obtained. Then, the approximate sales commission rate determination amount calculation processing means 23 includes each order data of other trades that have already been placed before the trade stored in the order data storage means 43 (see FIG. 5) in the current order data. By determining whether the order data has the same customer identification information as the customer identification information and the fund identification information for any fund belonging to the same fund group as the current order data. Since it is possible to grasp the order data of each fund belonging to the same fund group as the fund related to the current order by the same customer who made the current order, the amount calculation processing means 23 for determining the approximate sales commission rate Is the current order data received by the order reception processing means 22 and the current note stored in the order data storage means 43 (see FIG. 5). For each order data of other trade commitments before the pre-orders for this time of each fund belonging to the same fund group and fund according to the order by the same customer and the customer went to, the following processing is performed.

  That is, in the case of an order for which the amount is designated, the approximate sales commission rate determining amount calculation processing means 23 is stored in the current order data and order data storage means 43 (see FIG. 5) received by the order reception processing means 22. For each order data of other trades that have already been placed before the execution of each fund belonging to the same fund group as the fund related to the current order by the same customer who made the current order, Subtracted amount data is obtained by subtracting the total amount data of selling, which is the sum of the amount data when buying / selling data is data indicating selling, from the total amount data of buying, where the amount data is the data indicating . Then, by adding the calculated deduction amount data and the total amount data of the balance data of the previous day of all funds belonging to the fund group of the customer stored in the balance data storage means 41 (see FIG. 3), Temporary calculation of approximate sales commission rate determination amount data related to the current order data. At this time, the process of acquiring the balance data of the previous day of all funds belonging to the fund group of the customer from the balance data storage means 41 (see FIG. 3) is the customer identification information included in the current order data, This is performed using fund identification information for each fund belonging to the same fund group as the fund related to the order data as a key.

  For example, if the customer who made the current order (order number = N4 in FIG. 5) is Taro Yamato and the fund traded in this order is fund A, fund group 1 to which fund A belongs ( Since the funds belonging to the group code = G1) are funds A, B, and C (see FIG. 2), the funds A, B, and C among the other ordered data that have been ordered today by Taro Yamato have been placed. Is stored in the order data storage means 43 (see FIG. 5) as the order data of order numbers = N1, N2, and N3. Therefore, processing is performed for the current order data of order number = N4 and other order data of orders already placed before order number = N1, N2, N3. First, order number = N1, N2, Calculate the total amount data 5,000,000 yen of the purchase by summing the amount data 1,500,000 yen, 1,000,000 yen and 2,500,000 yen of N4 buy order data, and order number = Sale total data 2,000,000 Yen is calculated from the amount data 2,000,000 Yen of N3 selling order data (Since order data is only one of order number = N3, The amount data of order number = N3 is the total amount data for selling.), The deduction amount deducted by subtracting the total amount data for selling 2,000,000 yen from the total amount data for buying 5,000,000 yen To calculate the 3,000,000 yen data. Next, the total amount data of the balance data of the previous day of all funds A, B, C belonging to the fund group 1 (group code = G1) held by Taro Yamato, stored in the balance data storage means 41 (see FIG. 3) Is calculated. In the example of FIG. 3, Taro Yamato does not own Fund B at the previous day's stage, so the balance data of the previous day of Fund A is 5,008,952 yen and the balance data of Fund C the previous day is 2,999,889. The total amount data 8,008,841 yen with the yen is calculated. Then, by adding the subtraction amount data 3,000,000 yen obtained by subtracting the total amount data of selling from the total amount data of buying and the total amount data 8,008,841 yen of the balance data of the previous day, Approximately calculate 11,008,841 yen data for determining the approximate sales commission rate related to the order data.

  In the case of an order with a specified number of units, the approximate sales commission rate determination amount calculation processing means 23 is stored in the current order data and order data storage means 43 (see FIG. 5) received by the order reception processing means 22. For each order data of other trades that have already been placed before the execution of each fund belonging to the same fund group as the fund related to the current order by the same customer who made the current order, For each fund, subtracted data is obtained by subtracting the total number of units of selling, which is the sum of the number of units sold when the trading classification data is data indicating the selling, from the total number of units of buying, which is the total number of units of unit data. Calculate every time. Then, the base price data of the previous day of each fund is extracted from the base price storage means 44 (see FIG. 6) using the fund identification information for each fund as a key, and each of the extracted subtraction data for each fund is extracted. Subtract amount data for each fund by multiplying the base price data for the previous day of the fund. Then, the total amount data of the calculated deduction amount data of each fund and the total amount data of the balance data of the previous day of all the funds belonging to the fund group of the customer stored in the balance data storage means 41 (see FIG. 3). To temporarily calculate the amount data for determining the approximate sales commission rate related to the current order data. At this time, the process of acquiring the balance data of the previous day of all funds belonging to the fund group of the customer from the balance data storage means 41 (see FIG. 3) is the customer identification information included in the current order data, This is performed using fund identification information for each fund belonging to the same fund group as the fund related to the order data as a key.

  For example, if the customer who made this order (order number = N6 in FIG. 5) is Yamato Hanako and the fund sold and sold in this order is fund E, fund group 2 to which fund E belongs ( The funds belonging to the group code = G2) are funds D, E, F, G (see FIG. 2). Of the other order data that have already been ordered today by Hanako Yamato, funds D, E , F, or G is stored in the order data storage means 43 (see FIG. 5) as the order data of order number = N5. Accordingly, processing is performed for the current order data of order number = N6 and other order data of orders already placed before order number = N5. First, there is no order data of funds F and G. For fund D, 3,000,000 total purchase data is calculated from 3,000,000 purchase data of order number = N5 (the purchase order data of fund D is 1 for order number = N5. Since there is only one, the number of units purchased with order number = N5 is the total number of units purchased.), The total number of units sold is the total number of units sold, zero (the order data for the sale of Fund D is Since there is no one, the total number of units will be zero.) And the total number of units sold will be 3,000,000 units, the total number of units sold will be subtracted from Fund D minus zero. Calculate 3,000,000 units of data, and for fund E, calculate 2,000,000 units of total number of units purchased from 2,000,000 units of unit number = N6 (Fund E Since there is only one order data for order No. = N6, the data for the number of purchases for order number = N6 is the total number of units for buying.) Calculate the data, zero (there is no order data for selling Fund E, so the total number of units will be zero), and the total number of units sold, 2,000,000 units, and the total number of units sold, zero Calculate 2,000,000 units of subtraction number data for fund E that has been reduced. Then, from the base price storage means 44 (see FIG. 6), the base price data 10,423 yen (however, per 10,000 units) on the day before the fund D is extracted and calculated using the fund identification information about the fund D as a key. Fund D subtraction data 3,126,900 by multiplying 3,000,000 units of Fund D by the base price data 10,423 yen (per 10,000 units) the day before the extracted funds D And the base price data 9,634 yen (per 10,000 units) on the previous day of the fund E is extracted from the base price storage means 44 (see FIG. 6) using the fund identification information about the fund E as a key. In addition, 2,000,000 units of fund E subtraction data calculated is included in the base price data of the previous day of funds E extracted 9,634 yen (however, 10,000 units) ) To calculate the fund A deduction amount data 1,926,800 yen, the fund D deduction amount data 3,126,900 yen, and the fund E deduction amount data 1,926,800 yen The total amount data 5,053,700 yen is calculated. Next, the total of the balance data of the previous day of all funds D, E, F, G belonging to fund group 2 (group code = G2) held by Yamato Hanako, stored in balance data storage means 41 (see FIG. 3) Calculate amount data. In the example of FIG. 3, Hanawa Yamato does not own funds E and F at the previous day's stage, so the balance data 813,870 for the day before fund D and the balance data 8,384,042 for the day before fund G. The total amount data 9, 197, 912 yen with the yen is calculated. Then, by adding the total amount data 5,053,700 yen of the deduction amount data of each fund D, E and the total amount data 9,197,912 of the balance data of the previous day of each fund D, G, Approximately calculate 14,251,612 yen for determining the approximate sales commission rate related to the current order data.

<In the case of an invention that determines the sales commission rate based on the fund unit balance>
In the case of the “invention for determining the sales commission rate based on the balance of the fund unit” described above, the balance for the fund group unit is not calculated. No processing is performed to obtain information on each fund belonging to the same fund group as the fund related to the order data. Accordingly, the approximate sales commission rate determining amount calculation processing means 23 includes the order data of other trades already placed before the trade stored in the order data storage means 43 (see FIG. 5) in the current order data. This order is determined by determining whether the order data has the same customer identification information as the customer identification information and the same fund identification information as the fund identification information included in the current order data. Since it is possible to grasp each order data of the buying and selling of the same fund as the fund related to the current order by the same customer who made the order, the amount calculation processing means 23 for determining the approximate sales commission rate is the order reception processing means 22 for the current order data received by the customer 22 and the current order stored by the order data storage means 43 (see FIG. 5) by the same customer who made the current order. For each order data of the buying and selling of that fund and the same fund, the following processing is performed.

<In the case of an invention in which the sales commission rate is determined by the balance of the fund unit; continued>
That is, in the case of an order for which the amount is designated, the approximate sales commission rate determining amount calculation processing means 23 is stored in the current order data and order data storage means 43 (see FIG. 5) received by the order reception processing means 22. For each order data of other trades that have already been placed in the same fund as the fund related to the current order by the same customer who has placed the current order, the trade classification data is data indicating purchase. Then, subtracted amount data is calculated by subtracting the total amount data of selling, which is the sum of the amount data when the selling / dividing data is data indicating selling, from the total amount data of buying, which is the sum of the amount data. Then, by adding the calculated deduction amount data and the balance data of the customer's previous day stored in the balance data storage means 41 (see FIG. 3), the approximate sales commission rate relating to the current order data is added. The amount data for determination is provisionally calculated. At this time, the process of acquiring the balance data of the previous day of the customer's fund from the balance data storage means 41 (see FIG. 3) includes the customer identification information included in the current order data and the fund included in the current order data. The identification information is used as a key.

<In the case of an invention in which the sales commission rate is determined by the balance of the fund unit; continued>
For example, suppose that the customer who made this order (order number = N4 in FIG. 5) is Taro Yamato, and the fund sold and sold in this order is Fund A, the promise made today by Taro Yamato Of the other ordered data, the order data stored in the order data storage means 43 (see FIG. 5) is the order data of order number = N1. Accordingly, the current order data for order number = N4 and other order data for orders already placed before order number = N1 are processed. First, the order data for buying order numbers = N1, N4. Total amount data of 1,500,000 Yen and 2,500,000 Yen total, buy total amount data 4,000,000 Yen is calculated, there is no sell order data, so total amount data of Sell Then, zero yen is calculated, and the total amount data of selling is calculated from the total amount data of buying 4,000,000 yen, and the subtracted amount data 4,000,000 yen obtained by subtracting the zero yen is calculated. Next, the balance data on the previous day of the fund A held by Taro Yamato stored in the balance data storage means 41 (see FIG. 3) is acquired. In the example of FIG. 3, the balance data of the previous day of Taro Yamato's fund A is 5,008,952 yen. Then, by adding the deduction amount data 4,000,000 yen obtained by subtracting the total amount data of selling from the total amount data of buying and the balance data 5,008,952 yen of the previous day, it is related to the current order data. The amount data 9,008,952 for determining the approximate sales commission rate is provisionally calculated.

<In the case of an invention in which the sales commission rate is determined by the balance of the fund unit; continued>
In the case of an order with a specified number of units, the approximate sales commission rate determination amount calculation processing means 23 is stored in the current order data and order data storage means 43 (see FIG. 5) received by the order reception processing means 22. For each order data of other trades that have already been placed in the same fund as the fund related to the current order by the same customer who has placed the current order, the trade classification data is data indicating purchase. The subtracted number data obtained by subtracting the total number data of the selling, which is the sum of the number data in the case where the trading classification data is data indicating the sale, is calculated from the total number data of the buying, which is the total number data of the case. Then, the base price data of the previous day of the fund is extracted from the base price storage means 44 (see FIG. 6) using the fund identification information about the fund as a key, and the previous day of the fund is extracted to the calculated subtraction number data. The deduction amount data is calculated by multiplying the base price data. Then, by adding the calculated deduction amount data and the balance data of the customer's previous day of the fund stored in the balance data storage means 41 (see FIG. 3), an approximate sales commission rate relating to the current order data is added. The amount data for determination is provisionally calculated. At this time, the process of acquiring the balance data of the previous day of the customer's fund from the balance data storage means 41 (see FIG. 3) includes the customer identification information included in the current order data and the fund included in the current order data. The identification information is used as a key.

<In the case of an invention in which the sales commission rate is determined by the balance of the fund unit; continued>
For example, if the customer who made the current order (order number = N6 in FIG. 5) is Yamato Hanako, and the fund sold and sold in this order is Fund E, the promise made today by Yamato Hanako Among the other already ordered data, there is no data stored in the order data storage means 43 (see FIG. 5) as the order data of the fund E. Accordingly, only the current order data of order number = N6 is processed. First, the total number of purchase data 2,000,000 from the purchase number data 2,000,000 of order number = N6. (The order data for fund E is only one order number = N6, so the number data for buying with order number = N6 is the total number data for buying.) The total number of units sold is zero, and there is no order data for selling Fund E, so the total number of units is zero. The total number data of, and 2,000,000 units of funds E subtracted by subtracting zero are calculated. The base price data 9,634 yen (per 10,000 units) on the previous day of the fund E is extracted from the base price storage means 44 (see FIG. 6) using the fund identification information about the fund E as a key. Fund E's deduction amount data 1,926,800 yen by multiplying 2,000,000 units of Fund E's deduction unit data by 9,634 yen (excluding 10,000 units) on the previous day of the extracted funds E Is calculated. Next, the balance data of the day before the fund E owned by Hanako Yamato stored in the balance data storage means 41 (see FIG. 3) is acquired. In the example of FIG. 3, Hanawa Yamato does not have Fund E at the previous day's stage, so the balance data on the previous day of Fund E is zero. Then, by adding the fund A deducted amount data 1,926,800 yen, the balance data of the previous day of the fund E, and zero yen, the amount data 1,926 for determining the approximate sales commission rate related to the current order data , 800 yen is provisionally calculated.

  The approximate sales fee rate determination processing means 24 is based on the sales commission rate table storage means 42 ( Using the sales commission rate table stored in FIG. 4), the current order data and the contract data stored in the order data storage unit 43 (see FIG. 5) in the case of the purchase received by the order reception processing unit 22 Preliminarily determined approximate sales commission rate data that is commonly applied to each order data of other previously purchased orders, the provisional determined approximate sales commission rate data is associated with the order identification information (order number) and order data. The processing to be stored in the storage means 43 (see FIG. 5) is executed. In the example of the order for specifying the amount described above, 11,008,841 yen is provisionally calculated as the approximate sales commission rate determining amount data related to the current order data (order number = N4 in FIG. 5). Therefore, since it corresponds to “10 million yen or more and less than 500 million yen” in the sales commission rate table, the approximate sales commission rate data is provisionally determined to be 1.575% (including consumption tax), and this value is the order It is stored in the data storage means 43 (see FIG. 5). Further, in the example of the order specifying the number described above, 14,251,612 yen is provisionally calculated as the approximate sales commission rate determining amount data related to the current order data (order number = N6 in FIG. 5). Therefore, this also falls within the sales commission rate table and falls within the range of “10 million yen or more and less than 500 million yen”, so the approximate sales commission rate data is provisionally determined to be 1.575% (including consumption tax) This value is stored in the order data storage means 43 (see FIG. 5). Any of the order data of these order numbers = N4 and N6 falls under “less than 10 million yen” alone. Therefore, the conventional method for determining the sales commission rate is 2.100. % (Including consumption tax), it can be seen that according to the present invention, 1.575% (including consumption tax) is an advantageous value for the customer.

  Further, the approximate sales commission rate data temporarily determined by the approximate sales commission rate determination processing means 24 was used to calculate not only the current order data but also the approximate sales commission rate determination amount data related to the current order data. Since it is also applied in common to other order data of other orders that have already been placed before the contract, for example, when the order number = N1 is placed, the approximate sales fee applied to the order data of order number = N1 Even if the rate data is temporarily determined to be 2.100% (including consumption tax), for example, when the order of the order number = N4, which is a subsequent order, is placed, The estimated sales commission rate data applied to the order data of order number = N1 made before may change to 1.575% (including consumption tax). Details of Te will be described later with reference to FIGS. 5 and 9. Thus, since the value of the approximate sales commission rate data may change from the previous calculation time point, a new value is overwritten and saved in the order data storage means 43 (see FIG. 5).

  The approximate sales commission calculation processing means 25 tentatively calculates the approximate sales commission data related to the current order data in the case of the purchase received by the order reception processing means 22, and uses the provisional calculated approximate sales commission data as the order identification information (order The order data storage means 43 (see FIG. 5) stores the information in association with the (number). Further, the approximate sales fee calculation processing means 25 includes not only the current order data but also other order data of other trades that have already been placed before the trade stored in the order data storage means 43 (see FIG. 5). Approximate sales commission data related to each order data of other purchases that have already been placed before the contract used to calculate the amount data for determining the approximate sales commission rate related to the current order data is provisionally calculated, and the estimated sales commission calculated provisionally A process of storing the data in the order data storage unit 43 (see FIG. 5) in association with the order identification information (order number) is also executed.

  Specifically, in the case of an order for which the amount is designated, the approximate sales commission calculation processing means 25 is provisionally determined by the amount data when the trade classification data is data indicating buying and the approximate sales commission rate determination processing means 24. Approximate sales commission data is tentatively calculated using the estimated sales commission rate data. In other words, in this embodiment, the purchase order amount data is the internal fee data, so the approximate sales fee data = the purchase order amount data− {the purchase order amount data ÷ (1 + the approximate sales fee rate data). )} Provisionally calculate approximate sales commission data. In the example of the order for specifying the amount described above, the purchase amount data related to the current order data (order number = N4 in FIG. 5) is 2,500,000 yen, and the approximate sales commission rate determination amount data 11,008,841 yen is provisionally calculated, and the approximate sales commission rate data is provisionally determined to be 1.575% (including consumption tax), so the approximate sales related to the current order data (order number = N4) Fee data = 2,500,000 yen- {2,500,000 yen / (1 + 1.575%)} = 38,764 yen, and this value is stored in the order data storage means 43 (see FIG. 5). In addition, as order data for other purchases that have already been placed before the contract used for calculation of the amount data for determining the approximate sales commission rate related to the current order data (order number = N4), order numbers = N1, N2 Since there is order data, approximate sales commission data related to order data with order number = N1 = 1,500,000 yen-{1,500,000 yen / (1 + 1.575%)} = 23,259 yen Approximate sales commission data related to order data with order number = N2 = 1,000,000 yen-{1,000,000 yen / (1 + 1.575%)} = 15,506 yen (see FIG. 5) ). Since the value of the approximate sales commission data related to the order data of these order numbers = N1, N2 may change from the previous calculation time, the order data storage means 43 (see FIG. 5) is overwritten with the new value. Saved.

  Further, in the case of an order specifying the number of units, the approximate sales commission calculation processing unit 25 stores the previous day stored in the unit price data and the reference price storage unit 44 (see FIG. 6) when the trading classification data is data indicating buying. Approximate sales commission data is provisionally calculated using the reference price data (the day before the order reception process) and the approximate sales commission rate data provisionally determined by the approximate sales commission rate determination processing means 24. That is, approximate sales commission data is provisionally calculated by the formula: approximate sales commission data = number of purchase order data × standard price data of the previous day × approximate sales commission rate data. In the example of the order specifying the number of units described above, the number of units purchased for the current order data (order number = N6 in FIG. 5) is 2,000,000 units, and the amount data for determining the approximate sales commission rate 14,251,612 yen is provisionally calculated, the estimated sales commission rate data is provisionally determined to be 1.575% (including consumption tax), and stored in the base price storage means 44 (see FIG. 6) Since the base price data of the previous day (the day before the order reception process) is 9,634 yen (however, per 10,000 units), the approximate sales commission data relating to the current order data (order number = N6) = 2,000 000 units × (9,634 yen / 10,000 units) × 1.575% = 30,347 yen, and this value is stored in the order data storage means 43 (see FIG. 5). Further, the order data of order number = N5 is used as the order data for other purchases that have already been placed before the contract used to calculate the approximate sales commission rate determining amount data for the current order data (order number = N6). Therefore, the estimated sales commission data relating to the order data of order number = N5 = 3,000,000 units × (10,423 yen / 10,000 units) × 1.575% = 49,249 yen is also provisionally calculated ( (See FIG. 5). Since the value of the approximate sales commission data related to the order data of order number = N5 may change from the previous calculation time point, the new value is overwritten and saved in the order data storage means 43 (see FIG. 5). .

  The estimated sales commission display processing means 26 displays the data for displaying the order content confirmation screen 140 (see FIG. 9, for example, a Web screen, etc.) for the network 1 during the order reception processing from the customer terminal device 50 or the sales company terminal device 60. To the customer terminal device 50 via the internal network 2 or to the sales company terminal device 60 via the internal network 2 is executed. As shown in FIG. 9, on the order content confirmation screen 140, the approximate sales fee data provisionally calculated by the approximate sales fee calculation processing means 25 for the current order data (order number = N4 in the example of FIG. 9), and The approximate sales commission rate data temporarily determined by the approximate sales commission rate determination processing means 24 is displayed, and other order data (Taro Yamato in the example of FIG. 9) made on that day (in the example of FIG. 9) , Order data of order numbers = N1 and N2 that are other order data of other orders that have already been placed before execution used for calculation of the amount data for determining the approximate sales commission rate related to the current order data of order number = N4 ), Data before and after the change of the approximate sales commission rate data temporarily determined by the approximate sales commission rate determination processing means 24 is displayed. At this time, the data before the change of the approximate sales commission rate data is read from the order data storage means 43 (see FIG. 5). Note that other order data of the customer made on that date is not only the data before and after the change of the estimated sales commission rate data provisionally determined by the estimated sales commission rate determination processing means 24 but also the provisional sales commission calculation processing means 25. Data before and after the change of the calculated approximate sales commission data may be displayed. In this case, the data before the change of the approximate sales commission data can be read from the order data storage means 43 (see FIG. 5).

  The reference price acquisition processing means 27 receives fund identification information (for example, a fund code) and reference price data transmitted from the consignment company system 70 via the dedicated line 3, and receives the received reference price data as fund identification information. The reference price storage means 44 (see FIG. 6) stores the information in association with the above. At this time, the acquisition process of the reference price data from the commission company system 70 transmits the reference price data acquisition request signal from the reference price acquisition processing means 27 to the commission company system 70 at the timing managed by the reference price acquisition processing means 27. Alternatively, reference price data transmitted from the commission company system 70 at a timing managed by the commission company system 70 may be received.

  The order processing means 28 includes customer identification information (account number, etc.), fund identification information (fund code, etc.), order identification information (order number, etc.) for each order data stored in the order data storage means 43 (see FIG. 5). ), The transaction classification data, the money amount data, or the number data is transmitted to the consignment company system 70 through the dedicated line 3, and as contract data for each order transmitted from the consignment company system 70 through the dedicated line 3. , Customer identification information (account number, etc.), fund identification information (fund code, etc.), order identification information (order number, etc.), trading classification data, contract amount data, contract quantity data, contract unit price data (standard price data for contract dates) ) And the received contract data is stored in the order data storage means 43 (see FIG. 5).

  The fixed sales commission rate determining amount calculation processing means 29 is the processing target order stored in the order data storage means 43 at the time of execution of each order data stored in the order data storage means 43 (see FIG. 5). The processing for calculating the fixed sales commission rate determining amount data related to the data is executed. The amount data for determining the fixed sales commission rate is different from the amount data for determining the approximate sales commission rate, which is provisional data calculated at the time of order acceptance processing. This is the amount data that is the basis for determining the commission rate.

  Specifically, the fixed sales commission rate determination amount calculation processing means 29 uses the fund identification information (fund code) included in the processing target order data stored in the order data storage means 43 (see FIG. 5) as a key. As described above, group identification information (group code) corresponding to the fund identification information included in the order data to be processed is extracted from the group table storage means 40 (see FIG. 2), and all fund identifications corresponding to the extracted group identification information are extracted. By acquiring the information from the group table storage means 40, information on each fund belonging to the same fund group as the fund related to the order data to be processed is obtained. Then, the fixed sales commission rate determination amount calculation processing means 29 is a customer whose processing order data includes each order data of other trades after the contract stored in the order data storage means 43 (see FIG. 5). By determining whether the order data has the same customer identification information as the identification information and the fund identification information for any fund belonging to the same fund group as the order data to be processed, Since it is possible to grasp the order data of each fund belonging to the same fund group as the fund related to the order to be processed by the same customer who made the order to be processed, the amount calculation processing means for determining the fixed sales commission rate 29 is the order data to be processed and the order data storage means 43 (see FIG. 5) stored in the order data storage means 43 (see FIG. 5). The following processing is performed for each order data of other trades after the contract of each fund belonging to the same fund group as the fund related to the order to be processed by the same customer as the order for the processing target stored in I do.

  In other words, in the case of an order for which the amount is designated, the fixed sales commission rate determining amount calculation processing means 29 is the processing target order data and order data storage means 43 stored in the order data storage means 43 (see FIG. 5). (See FIG. 5) Stored order data of other trades after the contract of each fund belonging to the same fund group as the fund related to the order to be processed by the same customer as the customer who made the order to be processed Subtracting the total amount data of selling by summing the amount data when buying and selling data is data showing selling from the total amount data of buying when the buying and selling division data is data showing buying Calculate the deduction amount data. Then, by adding the calculated deduction amount data and the total amount data of the balance data of the previous day of all funds belonging to the fund group of the customer stored in the balance data storage means 41 (see FIG. 3), Calculate the fixed sales commission rate determination amount data related to the order data to be processed. At this time, the process of acquiring the balance data of the previous day of all the funds belonging to the fund group of the customer from the balance data storage means 41 (see FIG. 3) is the customer identification information included in the order data to be processed, and the process This is performed using the fund identification information for each fund belonging to the same fund group as the fund related to the target order data as a key. Further, at the time of performing this process, the reference price data of the contract date of each fund (the day on which this process is performed) is already stored in the reference price storage means 44 (see FIG. 6). After re-evaluating the balance data of each fund stored in the balance data storage means 41 (see FIG. 3) using the reference price data, the fixed sale using the balance data on the trade date after the re-evaluation It is possible to calculate fee rate determination amount data, but nevertheless, the balance data storage means 41 (see FIG. 3) obtains and uses the previous day's balance data as approximate sales fee rate data. This is because it is not preferable to change the value already displayed and announced on the order content confirmation screen 140 in FIG. 9 (particularly, in a direction that is disadvantageous to the customer), and the fixed sales commission rate This is to maintain the estimated sales commission rate data that has already been displayed and announced, and to calculate the final sales commission rate determination amount data in the same manner as the preliminary calculation of the approximate sales commission rate determination amount data. .

  For example, if the customer who made the order to be processed (order number = N4 in FIG. 5) is Taro Yamato and the fund traded in the order to be processed is fund A, the fund group to which fund A belongs Since the funds belonging to 1 (group code = G1) are funds A, B, and C (see FIG. 2), among the other order data made today by Taro Yamato, the funds A, B, and C What is stored in the order data storage means 43 (see FIG. 5) as any order data is the order data of order numbers = N1, N2, and N3. Therefore, the processing is performed for the order data to be processed with order number = N4 and the other order data after the execution with order numbers = N1, N2, N3. First, the order numbers = N1, N2, N4. The total amount data 5,000,000 yen of the purchase obtained by summing the amount data 1,500,000 yen, 1,000,000 yen and 2,500,000 yen of the purchase order data is calculated, and the order number = N3 Total amount data 2,000,000 yen of selling is calculated from the amount data 2,000,000 yen of selling order data (Since order data has only one of order number = N3, order number = The amount data of N3 is the total amount data of selling.), The amount of subtraction data obtained by subtracting the total amount of selling data 2,000,000 yen from the total amount data of buying 5,000,000 yen , To calculate the yen 000,000. Next, the total amount data of the balance data of the previous day of all funds A, B, C belonging to the fund group 1 (group code = G1) held by Taro Yamato, stored in the balance data storage means 41 (see FIG. 3) Is calculated. In the example of FIG. 3, Taro Yamato does not own Fund B at the previous day's stage, so the balance data of the previous day of Fund A is 5,008,952 yen and the balance data of Fund C the previous day is 2,999,889. The total amount data 8,008,841 yen with the yen is calculated. Then, by adding the subtraction amount data 3,000,000 yen obtained by subtracting the total amount data of selling from the total amount data of buying and the total amount data 8,008,841 yen of the balance data of the previous day, the processing object The fixed sales commission rate determining amount data 11,008,841 yen for the order data is calculated. This is the same as the tentatively calculated approximate sales commission rate determining amount data 11,008,841 yen in the example described above.

  In the case of an order with a specified number of units, the fixed sales commission rate determination amount calculation processing means 29 is the processing target order data and order data storage means 43 stored in the order data storage means 43 (see FIG. 5). (See FIG. 5) Stored order data of other trades after the contract of each fund belonging to the same fund group as the fund related to the order to be processed by the same customer as the customer who made the order to be processed Subtracting the total number data of selling by summing the number data when buying and selling data is data showing sales from the total number of buying data when buying and selling data is data showing buying The number of subtraction data is calculated for each fund. Then, the base price data of the previous day of each fund is extracted from the base price storage means 44 (see FIG. 6) using the fund identification information for each fund as a key, and each of the extracted subtraction data for each fund is extracted. Subtract amount data for each fund by multiplying the base price data for the previous day of the fund. At this time, although the reference price data of the contract date of each fund (the day on which this processing is performed) is already stored in the reference price storage means 44 (see FIG. 6), the reference price storage means 44 The standard price data of the previous day is extracted and used as the approximate sales commission rate data, which changes the value already displayed and announced on the order content confirmation screen 140 in FIG. This is because it is not preferable. For the fixed sales commission rate data, the estimated sales commission rate data that has already been displayed and announced is kept, and the calculation of the fixed sales commission rate determination amount data is estimated. This is because it is the same as the provisional calculation of the sales commission rate determination amount data. Then, the total amount data of the calculated deduction amount data of each fund and the total amount data of the balance data of the previous day of all the funds belonging to the fund group of the customer stored in the balance data storage means 41 (see FIG. 3). Is added to calculate the fixed sales commission rate determining amount data relating to the order data to be processed. At this time, the process of acquiring the balance data of the previous day of all the funds belonging to the fund group of the customer from the balance data storage means 41 (see FIG. 3) is the customer identification information included in the order data to be processed, and the process This is performed using the fund identification information for each fund belonging to the same fund group as the fund related to the target order data as a key. Further, the reason for acquiring and using the balance data of the previous day from the balance data storage means 41 (see FIG. 3) is as described in the case of the order for specifying the amount.

  For example, if the customer who made the order to be processed (order number = N6 in FIG. 5) is Yamato Hanako and the fund bought and sold in the order to be processed is fund E, the fund group to which fund E belongs. 2 (group code = G2) are funds D, E, F, G (see FIG. 2). Of the other order data made today by Hanako Yamato, funds D, E, What is stored in the order data storage means 43 (see FIG. 5) as the order data of either F or G is the order data of order number = N5. Accordingly, the processing is performed for the order data to be processed with order number = N6 and the other order data after the contract with order number = N5. First, since there is no order data for funds F and G, fund D , 3,000,000 units of total purchase data is calculated from 3,000,000 units of purchase number data of order number = N5 (the order data for purchase of fund D is only one of order number = N5) However, the order data = N5 buy unit data is the total number of buy units.), The total unit number data of the total unit of sell units, zero (the order data for the sale of Fund D is one Since the total number of units is zero, the total number of units purchased is 3,000,000 units, the total number of units sold is subtracted from zero, 3,000,000 units of funds, and for fund E, 2,000,000 units of total purchase data is calculated from 2,000,000 units of purchase number data of order number N6 (Fund E Since there is only one order data for order No. = N6, the data for the number of purchases for order number = N6 is the total number of units for buying.) Calculate the data, zero (there is no order data for selling Fund E, so the total number of units will be zero), and the total number of units sold, 2,000,000 units, and the total number of units sold, zero Calculate 2,000,000 units of subtraction number data for fund E that has been reduced. Then, from the base price storage means 44 (see FIG. 6), the base price data 10,423 yen (however, per 10,000 units) on the day before the fund D is extracted and calculated using the fund identification information about the fund D as a key. Fund D subtraction data 3,126,900 by multiplying 3,000,000 units of Fund D by the base price data 10,423 yen (per 10,000 units) the day before the extracted funds D And the base price data 9,634 yen (per 10,000 units) on the previous day of the fund E is extracted from the base price storage means 44 (see FIG. 6) using the fund identification information about the fund E as a key. In addition, 2,000,000 units of fund E subtraction data calculated is included in the base price data of the previous day of funds E extracted 9,634 yen (however, 10,000 units) ) To calculate the fund A deduction amount data 1,926,800 yen, the fund D deduction amount data 3,126,900 yen, and the fund E deduction amount data 1,926,800 yen The total amount data 5,053,700 yen is calculated. Next, the total of the balance data of the previous day of all funds D, E, F, G belonging to fund group 2 (group code = G2) held by Yamato Hanako, stored in balance data storage means 41 (see FIG. 3) Calculate amount data. In the example of FIG. 3, Hanawa Yamato does not own funds E and F at the previous day's stage, so the balance data 813,870 for the day before fund D and the balance data 8,384,042 for the day before fund G. The total amount data 9, 197, 912 yen with the yen is calculated. Then, by adding the total amount data 5,053,700 yen of the deduction amount data of each fund D, E and the total amount data 9,197,912 of the balance data of the previous day of each fund D, G, Calculate definite sales commission rate determining amount data 14,251,612 yen related to the processing target order data. This is the same as the tentatively calculated approximate sales commission rate determination amount data 14,251,612 yen in the above-described example.

<In the case of an invention that determines the sales commission rate based on the fund unit balance>
In the case of the above-mentioned “invention for determining the sales commission rate based on the balance of the fund unit”, the balance for the fund group unit is not calculated. No processing is performed to obtain information on each fund belonging to the same fund group as the fund related to the target order data. Therefore, the fixed sales commission rate determination amount calculation processing means 29 is a customer whose processing order data includes each order data of other trades after execution stored in the order data storage means 43 (see FIG. 5). The order to be processed is determined by determining whether the order data has the same customer identification information as the identification information and the same fund identification information as the fund identification information included in the order data to be processed. Since it is possible to grasp each order data of buying and selling of the same fund as the fund related to the order to be processed by the same customer as the customer who made the transaction, the final sales commission rate determining amount calculation processing means 29 is the order data storage Order data to be processed stored in the means 43 (see FIG. 5) and the customer who has placed the order to be processed stored in the order data storage means 43 (see FIG. 5) For each order data of the funds of the same fund and the buying and selling according to the order to be processed by the same customer, the following processing is performed.

<In the case of an invention in which the sales commission rate is determined by the balance of the fund unit; continued>
In other words, in the case of an order for which the amount is designated, the fixed sales commission rate determining amount calculation processing means 29 is the processing target order data and order data storage means 43 stored in the order data storage means 43 (see FIG. 5). For each order data of other trades after the contract of the same fund as the fund related to the order to be processed by the same customer as the customer who made the order to be processed stored in (see FIG. 5), the trade classification data Subtracted amount data obtained by subtracting the total amount data of selling, which is the sum of amount data when buying / selling data is data indicating selling, from the total amount data of buying, where amount data is the data indicating buy calculate. Then, by adding the calculated subtraction amount data and the balance data of the customer's previous day of the fund stored in the balance data storage means 41 (see FIG. 3), the fixed sales commission relating to the order data to be processed Calculate rate determining amount data. At this time, the processing for acquiring the balance data of the customer's previous day from the balance data storage means 41 (see FIG. 3) is included in the customer identification information included in the processing target order data and the processing target order data. This is done using fund identification information as a key.

<In the case of an invention in which the sales commission rate is determined by the balance of the fund unit; continued>
For example, if the customer who made the order to be processed (order number = N4 in FIG. 5) is Taro Yamato and the fund sold and sold in the order to be processed is Fund A, it was made today by Taro Yamato. Of the other order data after the contract, what is stored in the order data storage means 43 (see FIG. 5) as the order data of the fund A is the order data of order number = N1. Therefore, the processing is performed for the order data to be processed with order number = N4 and the other order data after the execution with order number = N1. First, the amount of order data for purchase with order numbers = N1, N4. Calculate the total amount data of purchase of 4,000,000 yen, which is the sum of data 1,500,000 yen and 2,500,000 yen. Since there is no sell order data, the total amount data of sell is zero. Yen is calculated, and the total amount data of selling is calculated from the total amount data of buying 4,000,000 yen, and the subtracted amount data 4,000,000 yen is calculated by subtracting zero yen. Next, the balance data on the previous day of the fund A held by Taro Yamato stored in the balance data storage means 41 (see FIG. 3) is acquired. In the example of FIG. 3, the balance data of the previous day of Taro Yamato's fund A is 5,008,952 yen. Then, by adding the deduction amount data 4,000,000 yen obtained by subtracting the total sale amount data from the total purchase amount data and the balance data 5,008,952 yen of the previous day, the order data to be processed is added. The fixed sales commission rate determining amount data 9,008,952 yen is calculated.

<In the case of an invention in which the sales commission rate is determined by the balance of the fund unit; continued>
In the case of an order with a specified number of units, the fixed sales commission rate determination amount calculation processing means 29 is the processing target order data and order data storage means 43 stored in the order data storage means 43 (see FIG. 5). For each order data of other trades after the contract of the same fund as the fund related to the order to be processed by the same customer as the customer who made the order to be processed stored in (see FIG. 5), the trade classification data Subtracted number data obtained by subtracting the total number data of selling, which is the sum of the number data when buying / selling data is data indicating selling, from the total number data of buying, where the number data is the data indicating buy. calculate. Then, the base price data of the previous day of the fund is extracted from the base price storage means 44 (see FIG. 6) using the fund identification information about the fund as a key, and the previous day of the fund is extracted to the calculated subtraction number data. The deduction amount data is calculated by multiplying the base price data. Then, by adding the calculated deduction amount data and the balance data of the customer's previous day of the fund stored in the balance data storage means 41 (see FIG. 3), a fixed sales commission relating to the order data to be processed Calculate rate determining amount data. At this time, the processing for acquiring the balance data of the customer's previous day from the balance data storage means 41 (see FIG. 3) is included in the customer identification information included in the processing target order data and the processing target order data. This is done using fund identification information as a key.

<In the case of an invention in which the sales commission rate is determined by the balance of the fund unit; continued>
For example, if the customer who placed the order to be processed (order number = N6 in FIG. 5) is Yamato Hanako, and the fund sold in the order to be processed is Fund E, it was made today by Yamato Hanako. Among the other order data after the contract, there is no order data stored in the order data storage means 43 (see FIG. 5) as the order data of the fund E. Therefore, only the order data to be processed with order number = N6 is processed. First, the total number data of purchases 2,000,000 from the purchase number data 2,000,000 of order numbers = N6. 000 units are calculated (the order data for the purchase of fund E is only one for order number = N6, so the number of units purchased for order number = N6 is the total number of units for buying) and the number of units sold. Calculate the total number of units sold, zero (there is no order data for the sale of Fund E, so the total number will be zero), and the total number of units purchased will be 2,000,000. Calculate the total number of units sold and 2,000,000 units of funds E subtracted by zero. The base price data 9,634 yen (per 10,000 units) on the previous day of the fund E is extracted from the base price storage means 44 (see FIG. 6) using the fund identification information about the fund E as a key. Fund E's deduction amount data 1,926,800 yen by multiplying 2,000,000 units of Fund E's deduction unit data by 9,634 yen (excluding 10,000 units) on the previous day of the extracted funds E Is calculated. Next, the balance data of the day before the fund E owned by Hanako Yamato stored in the balance data storage means 41 (see FIG. 3) is acquired. In the example of FIG. 3, Hanawa Yamato does not have Fund E at the previous day's stage, so the balance data on the previous day of Fund E is zero. Then, by adding the balance amount data 1,926,800 yen of the fund E, the balance data of the previous day of the fund E, and zero yen, the fixed sales commission rate determining amount data 1, 1 for the order data to be processed 926,800 yen is calculated.

  The fixed sales commission rate determination processing means 30 is based on the fixed sales commission rate determination amount data related to the processing target order data calculated by the fixed sales commission rate determination amount calculation processing means 29, based on the sales commission rate table storage means 42 ( Using the sales commission rate table stored in FIG. 4), the order data to be processed and the order data storage unit 43 (FIG. 5) stored in the order data storage unit 43 (see FIG. 5). Determine the fixed sales commission rate data that is commonly applied to each order data of other buys after the execution stored in (Ref.), And associate the determined final sales commission rate data with the order identification information (order number) The order data storage means 43 (see FIG. 5) stores the data. In the example of the order for specifying the amount described above, 11,008,841 yen is calculated as the amount data for determining the fixed sales fee rate related to the order data to be processed (order number = N4 in FIG. 5). Therefore, since it corresponds to “10 million yen or more and less than 500 million yen” in the sales commission rate table, the fixed sales commission rate data is determined to be 1.575% (including consumption tax), and this value is the order data It is stored in the storage means 43 (see FIG. 5). Further, in the example of the order specifying the number described above, 14,251,612 yen is calculated as the fixed sales commission rate determining amount data relating to the order data to be processed (order number = N6 in FIG. 5). Therefore, this also falls under “10 million yen or more and less than 500 million yen” in the sales commission rate table, so the final sales commission rate data is determined to be 1.575% (including consumption tax). The value is stored in the order data storage means 43 (see FIG. 5). Any of the order data of these order numbers = N4 and N6 falls under “less than 10 million yen” alone. Therefore, the conventional method for determining the sales commission rate is 2.100. % (Including consumption tax), it can be seen that according to the present invention, 1.575% (including consumption tax) is an advantageous value for the customer.

  The final sales commission rate data determined by the final sales commission rate determination processing means 30 is used not only to calculate the order data to be processed, but also to calculate the final sales commission rate determination amount data relating to the target order data to be processed. In addition, since the order data storage unit 43 (see FIG. 5) stores the fixed sales commission rate data for the processing target order data in addition to storing the final sales commission rate data in the order data storage means 43 (see FIG. 5). In the case where final sales commission rate data is also stored for each order data of other subsequent purchases, the final sales commission rate determined by the final sales commission rate determination processing unit 30 is processed again for each order data. It is not necessary to carry out rate data determination processing, and further, a fixed sales commission rate determination amount calculation processing means 29 for these as processing targets. It is not necessary to perform the calculation processing of the defined sales commission rate determined for the amount of money data due.

  The final sales commission calculation processing means 31 calculates final sales commission data related to the order data to be processed in the case of a purchase stored in the order data storage means 43 (see FIG. 5), and the calculated final sales commission data is calculated. Then, a process of storing in the order data storage means 43 (see FIG. 5) in association with the order identification information (order number) is executed. The fixed sales commission data stored in the order data storage means 43 (see FIG. 5) is then used for the settlement process.

  Specifically, in the case of an order for which the amount is designated, the fixed sales commission calculation processing means 31 is determined by the amount data when the trading classification data is data indicating buying and the fixed sales commission rate determination processing means 30. The fixed sales commission data is calculated using the fixed sales commission rate data. That is, in the present embodiment, the purchase order amount data is the internal fee data, so the fixed sales fee data = the purchase order amount data− {the purchase order amount data ÷ (1 + the fixed sales fee rate data). )} To calculate final sales commission data. In the example of the order for specifying the amount described above, the purchase amount data related to the order data to be processed (order number = N4 in FIG. 5) is 2,500,000 yen, and the fixed sales commission rate determining amount Since 11,008,841 yen is calculated as data and the fixed sales commission rate data is determined to be 1.575% (including consumption tax), final sales related to the processing target order data (order number = N4) Fee data = 2,500,000 yen- {2,500,000 yen / (1 + 1.575%)} = 38,764 yen, and this value is stored in the order data storage means 43 (see FIG. 5).

  Further, in the case of an order specifying the number of units, the fixed sales commission calculation processing unit 31 stores the unit number data, the reference price storage unit 44 (see FIG. 6) or the order data storage unit when the trade classification data is data indicating buying. The fixed sales commission data is calculated using the standard price data of the trade date (not the previous day) stored in 43 (see FIG. 5) and the final sales commission rate data determined by the final sales commission rate determination processing means 30. To do. That is, the fixed sales commission data is calculated according to the formula: fixed sales commission data = number of purchase order data × standard price data of trade date × fixed sales commission rate data. In the example of order specifying the number of units described above, the number of units of purchase related to the processing target order data (order number = N6 in FIG. 5) is 2,000,000 units, and the amount for determining the fixed sales commission rate As data, 14,251,612 yen is calculated, the fixed sales commission rate data is determined to be 1.575% (including consumption tax), and the reference price storage means 44 (see FIG. 6) or the order data storage means 43 (FIG. The reference price data (contract unit price data) of the fund E stored in (5) is 9,683 yen (however, per 10,000 units), so the order data to be processed (order number = N6) Such final sales commission data = 2,000,000 units × (9,683 yen / 10,000 units) × 1.575% = 30,501 yen, and this value is stored in the order data storage means 43 (FIG. 5). reference).

  The balance update processing means 32 uses the reference price data stored on the reference price storage means 44 (see FIG. 6) for each fund's contract date (the day on which this processing is performed) to use the balance data storage means 41 (see FIG. 6). 3), the balance data of each fund held by each customer is re-evaluated, and the balance data stored in the balance data storage means 41 (see FIG. 3) is stored in the balance data after the re-evaluation. Is executed. Specifically, the contract quantity data for each executed order data stored in the order data storage means 43 (see FIG. 5) has the same customer identification information as the customer identification information included in the order data, And it adds (in the case of buying) or subtracts (in the case of selling) the numerical data of the record of the balance data storage means 41 (refer FIG. 3) which has the same fund identification information as the fund identification information contained in the said order data. A record having the same customer identification information as the customer identification information included in the order data and having the same fund identification information as the fund identification information included in the order data is stored in the balance data storage means 41 (see FIG. 3). ), A new record is generated, and the contract quantity data for the order data is stored therein as the held quantity data. The balance data storage means 41 (see FIG. 3) uses the fund identification information included in each record as a key in the number data (including both cases where the number data has increased or decreased). By multiplying the standard price data of the contract date acquired from the standard price storage means 44 (see FIG. 6), the balance data of the contract date after the re-evaluation is calculated, and the balance data of the contract date after the re-evaluation calculated is the balance The balance data is updated by being stored in the data storage means 41 (see FIG. 3). Further, the balance update processing means 32 updates the reference price data of each record of the balance data storage means 41 (see FIG. 3) with the reference price data of the contract date acquired from the reference price storage means 44 (see FIG. 6). .

  As shown in FIG. 2, the group table storage means 40 includes fund identification information (in this embodiment, fund code) for each fund and group identification information (in this embodiment, group identification) for the fund group to which each fund belongs. A group table for defining the correspondence relationship with the code). The structure of the group table is not limited to the structure of FIG. 2. For example, the fund group is included in a record of group identification information (for example, group code = G1) for a certain fund group (for example, fund group 1). Fund identification information (for example, fund code = AAAA, BBBB, CCCC) for each fund (for example, funds A, B, and C) belonging to A may be stored side by side.

  As shown in FIG. 3, the balance data storage means 41 has balance data of each fund held by each customer, number data held, and reference price data (when the balance data stored correspondingly is evaluated). Reference price data) is stored in association with customer identification information (in this embodiment, an account number as an example) and fund identification information (in this embodiment, as an example, a fund code). . In the example of FIG. 3, the reference price data is an amount per 10,000 units, but is not limited to this. Here, the balance data of each fund held by each customer includes balance data deposited by customers as collateral for margin transactions and loans, etc. It is used for provisional calculation of rate determining amount data and calculation of fixed sales commission rate determining amount data.

  As shown in FIG. 4, the sales commission rate table storage means 42 stores a sales commission rate table that defines the relationship between the purchase amount of the fund and the sales commission rate. The table configuration in FIG. 4 is merely an example, and the number of sections and the numerical value of each section are arbitrary. In the present invention, when the provisional determination processing of the approximate sales commission rate data and the determination processing of the final sales commission rate data are performed, the amount of data for determining the approximate sales commission rate and the final sales commission rate determination are determined as the purchase amount of the fund. Use amount data.

  As shown in FIG. 5, the order data storage unit 43 includes customer identification information (in this embodiment, an account number as an example) and fund identification information (in this embodiment, a fund code as an example). And order identification information (in the present embodiment, an order number is taken as an example), buying / selling classification data indicating whether to sell and buy, and amount data relating to an order (in this embodiment, the amount of the internal fee as an example) ), The number data of orders, the estimated sales commission rate data, the estimated sales commission data, the contract amount data, the contract number data, and the reference price data on the contract date (10,000 in this embodiment). Unit price), fixed sales commission rate data, and fixed sales commission data.

  As shown in FIG. 6, the reference price storage means 44 includes the latest reference price data (in this embodiment, the amount per 10,000 units) and the reference price data at the time of previous acquisition (in this embodiment, the amount per 10,000 units). ) Is stored in association with fund identification information (in the present embodiment, it is a fund code as an example). In the state at the time of order reception processing, the reference price data of the previous day is stored in the latest reference price data, and the reference price data of the previous day is stored in the reference price data at the previous acquisition. In addition, in the state at the time of contract processing, the base price data of the contract date (the day on which the contract processing is performed) is stored in the latest base price data, and the base price of the previous day is stored in the base price data at the previous acquisition. Data is stored.

  In the above, each of the processing means 21 to 32 included in the processing means 20A of the sales fee calculation processing server 20 includes a central processing unit (CPU) provided inside the computer main body constituting the sales fee calculation processing server 20, and This is realized by one or a plurality of programs that define the operation procedure of the CPU.

  Each of the storage means 40 to 44 of the sales commission calculation processing server 20 is preferably realized by, for example, a hard disk or the like. Memory, RAM, MO, CD-ROM, CD-R, CD-RW, DVD-ROM, DVD-RAM, FD, magnetic tape, or a combination thereof may be employed.

  Further, the sales commission calculation processing server 20 is not limited to one realized by one computer or one CPU, but may be realized by performing distributed processing with a plurality of computers or the like.

  The customer terminal device 50 is a terminal device operated by a customer, and is configured by a computer. The customer terminal device 50 according to the present embodiment may be equipped with a general-purpose WWW browser for performing screen display using display data transmitted from the sales fee calculation processing server 20 via the network 1. The customer terminal device 50 may be equipped with a dedicated program for realizing a part of the function of the processing means 20A of the sales fee calculation processing server 20. Such a program may be downloaded and acquired from the sales commission calculation processing server 20, or may be installed from a recording medium such as a CD-ROM. The customer terminal device 50 includes input means such as a mouse and a keyboard, and display means such as a liquid crystal display and a CRT display. The customer terminal device 50 may be, for example, a portable terminal device such as a mobile phone (including PHS) and a personal digital assistant (PDA: personal digital assistance).

  The sales company terminal device 60 is a terminal device that is operated by a person in charge of a fund sales company (such as a sales person or a person in charge of system management), and is configured by a computer. If the sales company terminal device 60 of this embodiment is equipped with a general-purpose WWW browser for performing screen display using display data transmitted from the sales commission calculation processing server 20 via the internal network 2. However, a dedicated program for realizing a part of the function of the processing means 20A of the sales fee calculation processing server 20 may be installed in the sales company terminal device 60. Further, the sales company terminal device 60 includes input means such as a mouse and a keyboard and display means such as a liquid crystal display and a CRT display. The sales company terminal device 60 may be, for example, a portable terminal device such as a mobile phone (including PHS) and a personal digital assistant (PDA: personal digital assistance).

  The consignment company system 70 is a system configured by a computer managed by a consignment company that manages one or a plurality of funds. Information about the constituent stocks of the fund to be operated (the amount held, the amount held, etc.) and the number of beneficial interests ( In addition to managing the total remaining number of units, the market price data (closing price data) of each stock that constitutes the fund to be managed is acquired daily from a market price information providing system (including market system) (not shown), and the total net assets of the fund ( All stocks and bonds included in the investment trust are evaluated at the market price of the day, and debts such as expenses necessary for management are subtracted from the total assets obtained by adding income such as bond interest and stock dividends. ) And dividing the calculated total net assets by the number of beneficial interests at that time (remaining total units), the fund's base price data (per unit The calculation of the total assets) on a daily basis, is intended to provide a reference price data calculated in sales commission calculation process server 20 via a dedicated line 3.

  In the first embodiment as described above, the sales fee calculation processing system 10 calculates the sales fee for fund purchase as follows.

  In FIG. 7, the person in charge of the fund sales company (the person in charge of system management) operates the sales company terminal device 60 to calculate the sales commission through the internal network 2 using the display request signal of the group designation screen 100 of FIG. It transmits to the processing server 20. In the sales fee calculation processing server 20, when the display request signal is received by the group designation processing means 21, the display data of the group designation screen 100 is transmitted to the sales company terminal device 60 via the internal network 2. Then, a group designation screen 100 as shown in FIG. 8 is displayed on the screen of the sales company terminal device 60.

  In FIG. 8, the group designation screen 100 displays a group code input unit 101 for inputting a group code as group identification information and each fund belonging to the group of the group code input to the group code input unit 101. A “display” button 102 and a fund code which is fund identification information for each fund belonging to the group of the group code input to the group code input unit 101 when the “display” button 102 is clicked are displayed and newly set. Alternatively, the fund code input unit 103 for inputting the changed fund code and each fund code input to the fund code input unit 103 together with the group code input to the group code input unit 101 to the sales commission calculation processing server 20 Send "OK" button 104, list display unit 105 for displaying a list of group tables, and whether one fund belongs to a plurality of fund groups (one fund code corresponds to a plurality of group codes) A “Duplicate Check” button 106 is provided for checking whether or not the state has been changed.

  When the person in charge of the fund sales company inputs the group code to the group code input unit 101 and clicks the “display” button 102 on the group designation screen 100 in FIG. 8, the input group code is transmitted via the internal network 2. It is transmitted to the sales commission calculation processing server 20. In the sales fee calculation processing server 20, when the group designation is received by the group designation processing means 21, all fund codes corresponding to the group code are received from the group table storage means 40 (see FIG. 2) using the received group code as a key. And all the extracted fund codes are transmitted to the sales company terminal device 60 via the internal network 2. Then, all fund codes corresponding to the group code are displayed in the fund code input unit 103 of the group designation screen 100 in FIG. The person in charge of the fund sales company clicks the “OK” button 104 after adding / changing / deleting the fund code for the fund belonging to the group of the group code in the fund code input unit 103, The group designation information in the added / changed / deleted state (the group code and the fund code for each fund belonging to the group of the group code) is transmitted to the sales fee calculation processing server 20 via the internal network 2, and the group The designation processing means 21 stores the added / changed / deleted group designation information in the group table storage means 40 (see FIG. 2) (step S1). In addition, when creating a new group, since the constituent funds are not yet designated for the group, nothing is displayed in the fund code input section 103. Are input to the fund code input unit 103. For example, in the group table storage means 40 of FIG. 2, funds A, B, and C belong to group 1, funds D, E, F, and G belong to group 2, and fund H belongs to group 3, and this state is As shown in the list display section 105 of the group designation screen 100 in FIG. 8, when a group 90 is formed by combining the group 1 and the group 3 in a campaign or the like, the group code input section 101 stores the group. If the group code for G.90 = G90 is input, the fund code for the funds A, B, C, H = AAAAA, BBBB, CCCC, HHHH is input to the fund code input unit 103 and the “OK” button 104 is clicked. Good.

  After that, the person in charge (sales employee) of the fund sales company who received the request from the customer operates the sales company terminal device 60 to calculate the sales commission through the internal network 2 using the display request signal of the order screen 120 of FIG. It transmits to the processing server 20. In the sales fee calculation processing server 20, when the order reception processing means 22 receives this display request signal, the display fee display processing data is transmitted to the sales company terminal device 60 via the internal network 2. Then, an order screen 120 as shown in FIG. 9 is displayed on the screen of the sales company terminal device 60. Note that customer identification information (in this embodiment, an account number is used as an example in the present embodiment) about the customer who places an order is sent from the sales company terminal device 60 by the person in charge (salesperson) of the fund sales company at an appropriate stage. It is inputted and transmitted to the sales commission calculation processing server 20.

  When the customer places an order by himself, the customer operates the customer terminal device 50 and transmits a display request signal for the order screen 120 in FIG. 9 to the sales fee calculation processing server 20 via the network 1. In the sales fee calculation processing server 20, when the order reception processing means 22 receives this display request signal, it transmits display data for the order screen 120 to the customer terminal device 50 via the network 1. Then, an order screen 120 as shown in FIG. 9 is displayed on the screen of the customer terminal device 50. Note that customer identification information (in this embodiment, an account number is taken as an example) is input from the customer terminal device 50 by the customer and transmitted to the sales fee calculation processing server 20 at an appropriate stage.

  In FIG. 9, the order screen 120 includes a customer name display unit 121 for displaying a customer name, an account number display unit 122 for displaying a customer account number, a fund selection unit 123 for selecting a fund to be purchased, and a purchase. A purchase amount input unit 124 for inputting an amount (internal fee) and a “confirm” button 125 for confirming the order contents are provided. Note that the order screen 120 in FIG. 9 is an example of a purchase order screen. However, if sale is selected, an order screen for sale is displayed. The order screen 120 in FIG. 9 is an example of an order for specifying the amount, but when an order for specifying the number of units is selected, an order screen for specifying the number of units is displayed.

  In the order screen 120 shown in FIG. 9 displayed on the sales company terminal device 60, the person in charge (sales employee) of the fund sales company that has received a request from the customer selects the fund to be purchased by the fund selection unit 123 and purchases it. After inputting the purchase price (internal fee) in the money amount input section 124, clicking the “Confirm” button 125, fund identification information (fund code, etc.), trading classification data, and money amount data (number designation) for the fund to be purchased In the case of the order screen, the inputted number data) is transmitted to the sales fee calculation processing server 20 through the internal network 2 as the order data together with the customer identification information (account number or the like). Further, in the order screen 120 of FIG. 9 displayed on the customer terminal device 50, the customer himself / herself selects the fund to be purchased by the fund selection unit 123, and the purchase amount input unit 124 stores the purchase amount (internal fee). After inputting, click the “Confirm” button 125 to obtain fund identification information (fund code, etc.), trading classification data, and amount data (in the case of a number-specified order screen, entered number data). ) Is transmitted to the sales fee calculation processing server 20 via the network 1 as order data together with the customer identification information (account number, etc.).

  In the sales fee calculation processing server 20, the order reception processing means 22 uses the fund identification information (fund code, etc.), trading classification data, and amount data (in the case of an order screen for specifying a number, the input number data). Is received together with the customer identification information (account number, etc.), the received order data is stored in the order data storage means 43 (see FIG. 5) in association with the customer identification information (step S2). Further, the order acceptance processing means 22 automatically assigns order identification information (in this embodiment, an order number) to the accepted order data, and stores it in the order data storage means 43 (see FIG. 5). The order data storage unit 43 (see FIG. 5) stores the order data and automatically assigns the order number. The person in charge of the fund sales company (salesperson) or the customer who requested the customer receives the order contents. However, in this embodiment, for convenience of explanation, it is assumed to be performed immediately after receiving an order, that is, before confirming the order contents.

  Then, the estimated sales commission rate determination amount calculation processing means 23 stores the order data storage means 43 (see FIG. 5), group table storage means 40 (see FIG. 2), and balance data storage means 41 (see FIG. 3). In the case of an order for which the number of units is specified using each of the obtained data, the estimated sales commission rate relating to the current order data received is further determined using the data stored in the reference price storage means 44 (see FIG. 6). Provisional amount data is provisionally calculated (step S3).

  Subsequently, the sales commission rate table is stored on the basis of the approximate sales commission rate determination amount data relating to the current order data temporarily calculated by the approximate sales commission rate determination amount calculation processing unit 23 by the approximate sales commission rate determination processing unit 24. Using the sales commission rate table stored in the means 42 (see FIG. 4), it is stored in the current order data and order data storage means 43 (see FIG. 5) in the case of a purchase accepted by the order acceptance processing means 22. Approximate sales commission rate data that is commonly applied to each order data of other already purchased orders before the execution of funds belonging to the same fund group by the same customer is determined (step S4).

  Further, in the case of an order for which the amount is designated by the approximate sales fee calculation processing means 25, the amount data when the trade classification data is data indicating buying, and the approximate sales temporarily determined by the approximate sales fee rate determination processing means 24. In the case of an order for which the number of units is specified using the commission rate data, the unit price data when the trade classification data is data indicating buying, the reference price data of the previous day stored in the reference price storage means 44 (see FIG. 6). Approximate sales fee data is provisionally calculated using the approximate sales fee rate data provisionally determined by the approximate sales fee rate determination processing means 24 (step S5). At this time, in addition to the approximate sales commission data related to the current order data, the same fund group by the same customer stored in the order data storage means 43 (see FIG. 5) to which the same approximate sales commission rate data is applied. Approximate sales commission data related to each order data of other purchases that have already been placed before the contract of the fund to which it belongs is also calculated temporarily.

  After that, when the order data from the sales company terminal device 60 is received by the approximate sales commission display processing means 26, the display data of the order content confirmation screen 140 of FIG. When the order data from the customer terminal device 50 is received, the display data of the order content confirmation screen 140 in FIG. 9 is transmitted to the customer terminal device 50 via the network 1. Then, an order details confirmation screen 140 as shown in FIG. 9 is displayed on the screen of the sales company terminal device 60 or the customer terminal device 50 (step S6).

  In FIG. 9, on the order content confirmation screen 140, a fund display unit 141 for displaying the fund name or fund identification information (fund code, etc.) of the fund to be purchased, and an amount display unit 142 for displaying the purchase price (internal fee). The approximate sales commission display section 143 that displays the approximate sales commission (including tax), the approximate sales commission ratio display section 144 that displays the approximate sales commission ratio (including tax), and the approximate commission ratio changed for other orders today If the estimated fee rate before change is displayed, the estimated fee rate display unit 151 before change is displayed, the estimated fee rate is displayed after change is displayed 152, and other orders of the day when the estimated fee rate is changed. Approximate commission rate change order display section 153 for displaying “OK” button 154 for confirming that the displayed order contents are acceptable, and the displayed note The contents and the "cancel" button 155 for canceling is provided a. The order content confirmation screen 140 in FIG. 9 is a purchase order content confirmation screen. In the case of sale, an order content confirmation screen for sale is displayed. The order content confirmation screen 140 in FIG. 9 is an order content confirmation screen in the case of an order for which the amount is specified, but in the case of an order in which the number is specified, an order content confirmation screen including a number display unit for displaying the order number Is displayed.

  Among them, the fund display unit 141 and the amount display unit 142 are displayed using the order data received by the order reception processing unit 22, and the approximate sales fee display unit 143 is displayed by the approximate sales fee calculation processing unit 25. The estimated sales commission rate data is displayed by using the estimated sales commission rate data temporarily determined by the estimated sales commission rate determination processing means 24. In addition, the display of the estimated commission rate display unit 151 before the change is performed using the estimated sales fee rate data stored in the order data storage means 43 (see FIG. 5), and the display of the estimated commission rate display unit 152 after the change is performed. Is performed using the approximate sales commission rate data temporarily determined by the approximate sales commission rate determination processing unit 24, and the display of the approximate commission rate change order display unit 153 is stored in the order data storage unit 43 (see FIG. 5). Order identification information (order number, etc.), fund identification information (fund code, etc.), amount data or number data, and trade classification data.

  For example, as shown in FIG. 3, the total amount data of the balance data of funds A and C belonging to group 1 of Yamato Taro the previous day is 5,008,952 yen + 2,999,889 yen = 8,008,841 yen 5, as shown in FIG. 5, when there is a purchase order of 1,500,000 yen for fund A with order number = N1, the amount data for determining the approximate sales commission rate is 1,500,000 yen. Since +8,008,841 yen = 9,508,841 yen and less than 10 million yen, the approximate sales commission rate data is obtained from the sales commission rate table of the sales commission rate table storage means 42 (see FIG. 4). Is provisionally determined to be 2.100%. Next, when there is a purchase order of 1,000,000 yen for fund B with order number = N2, the amount data for determining the approximate sales commission rate is 1,500,000 yen + 1,000,000 yen + 8, 008,841 yen = 10,508,841 yen, which is 10 million yen or more, the sales commission rate table of the sales commission rate table storage means 42 (see FIG. 4) indicates that the approximate sales commission rate data is It is provisionally determined to be 1.575%. At this time, the estimated sales commission rate data is 1.575% even for the buy order of the fund A with the order number = N1 whose estimated sales commission rate data is temporarily determined to be 2.100%. 2. The fact that there has been a change from 100% to 1.575% is displayed in the pre-change approximate fee rate display unit 151 and the post-change approximate fee rate display unit 152, and in the approximate fee rate change order display unit 153, The purchase order of fund A with order number = N1 is displayed. Furthermore, when there is a sales order of 2,000,000 yen for fund C with order number = N3, the approximate sales commission rate determination amount data is 1,500,000 yen + 1,000,000 yen -2, 000,000 yen + 8,008,841 yen = 8,508,841 yen, which is less than 10 million yen, it is estimated by the sales fee rate table of the sales fee rate table storage means 42 (see FIG. 4). Sales commission rate data is provisionally determined to be 2.100%. At this time, since the order with order number N3 is a sell order, it is not subject to calculation of the approximate sales commission. However, once the approximate sales commission rate data is provisionally determined to be 1.575%, the order number is N1. For the buy order of fund A and the buy order of fund B with order number = N2, the estimated sales commission rate data is 2.100%, so there was a change from 1.575% to 2.100%. Is displayed in the pre-change approximate fee rate display unit 151 and the post-change approximate fee rate display unit 152, and the approximate fee rate change order display unit 153 displays the buy order of the fund A with order number = N1 and the order number = Display the purchase order of fund B of N2. Then, when there is a purchase order of 2,500,000 yen of fund A with order number = N4, the approximate sales commission rate amount data is 1,500,000 yen + 1,000,000 yen -2, 000,000 yen + 2,500,000 yen + 8,008,841 yen = 11,008,841 yen, which is more than 10 million yen, so sales of the sales commission rate table storage means 42 (see FIG. 4) Based on the fee rate table, the approximate sales fee rate data is provisionally determined to be 1.575%. At this time, the estimated sales commission rate data is temporarily estimated to be 2.100% for the purchase order of fund A with order number = N1 and the purchase order of fund B with order number = N2 as well. Since the rate data is 1.575%, the fact that there has been a change from 2.100% to 1.575% is displayed on the pre-change approximate fee rate display unit 151 and the post-change approximate fee rate display unit 152. At the same time, the approximate commission rate change order display unit 153 displays the buy order of fund A with order number = N1 and the buy order of fund B with order number = N2.

  Then, on the order details confirmation screen 140 in FIG. 9, when the person in charge (sales employee) or the customer of the fund sales company clicks the “OK” button 154, the order confirmation signal is sold via the internal network 2 or the network 1. The sales fee calculation processing server 20 transmits the estimated sales fee rate data related to the current order data temporarily determined by the approximate sales fee rate determination processing means 24 and the approximate sales fee calculation processing means 25. Approximate sales commission data relating to the current order data temporarily calculated by the above is stored in the order data storage means 43 (see FIG. 5). Not only the current order data, but also the estimated sales commission rate data and estimated data related to the order data of other orders already placed before the execution of each fund belonging to the same fund group by the same customer as the current order data. Sales commission data is rewritten to the changed value.

  Thereafter, after the reference price data of the day of each fund (contract date) is calculated in the commission company system 70, the reference price data of the day is obtained from the commission company system 70 via the dedicated line 3 by the reference price acquisition processing means 27. The acquired reference price data of the day is stored in the reference price storage means 44 (see FIG. 6) in association with fund identification information (for example, fund code) (step S7).

  Subsequently, the customer identification information (account number, etc.), fund identification information (fund code, etc.), order identification information (fund code, etc.) for each order data stored in the order data storage means 43 (see FIG. 5) by the order processing means 28. Order number, etc.), trade classification data, amount data (in the case of a commission, approximate sales commission rate data may also be transmitted) or number data is transmitted to the consignment company system 70 via the dedicated line 3. (Step S8). The order data may be transmitted to the consignment company system 70 every time the order reception processing means 22 receives the order data. However, when the approximate sales commission rate data is transmitted, the approximate sales commission rate data is Since it changes, correction information is transmitted when it changes.

  Also, as the contract data for each order transmitted from the consignment company system 70 via the dedicated line 3 by the order processing means 28, customer identification information (account number, etc.), fund identification information (fund code, etc.), order Identification information (order number, etc.), trade classification data, contract price data, contract quantity data, contract unit price data (standard price data for contract dates) is received, and the received contract data is stored in the order data storage means 43 (see FIG. 5). (Step S8).

  Then, the fixed sales commission rate determination amount calculation processing means 29 stores the order data storage means 43 (see FIG. 5), group table storage means 40 (see FIG. 2), and balance data storage means 41 (see FIG. 3). In the case of an order for which the number of units is specified using each of the obtained data, the processing target stored in the order data storage unit 43 is further stored using the data stored in the reference price storage unit 44 (see FIG. 6). Calculate final sale commission rate amount data for the order data (step S9).

  Subsequently, the sales commission rate table storage unit 30 stores the sales commission rate table based on the final sales commission rate determination amount data related to the processing target order data calculated by the final sales commission rate determination amount calculation processing unit 29 by the final sales commission rate determination processing unit 30. Using the sales commission rate table stored in the means 42 (see FIG. 4), the order data and order data storage means 43 to be processed in the case of a purchase stored in the order data storage means 43 (see FIG. 5). (See Fig. 5) Determine the fixed sales commission rate data that is commonly applied to each order data of other buys after the execution of funds belonging to the same fund group by the same customer stored in (see Figure 5) The sales commission rate data is stored in the order data storage means 43 (see FIG. 5) in association with the order identification information (order number) (see step 5). S10).

  Furthermore, in the case of an order for which the amount is designated by the fixed sales fee calculation processing means 31, the amount data when the trading classification data is data indicating buying, and the fixed sales fee determined by the fixed sales fee rate determination processing means 30. In the case of an order for which the number is specified using the rate data, the number data when the trade classification data is data indicating buying, the reference price storage means 44 (see FIG. 6) or the order data storage means 43 (see FIG. 5). ) Stored in the order data storage means 43 (see FIG. 5) using the reference price data for the contract date stored in () and the final sales commission rate data determined by the final sales commission rate determination processing means 30. Calculate the fixed sales commission data related to the order data to be processed, and relate the calculated final sales commission data to the order identification information (order number). Only to be stored in the order data storage unit 43 (see FIG. 5) (step S11).

  Thereafter, the number of units stored in the balance data storage unit 41 (see FIG. 3) based on the contract number data for each of the order data stored in the order data storage unit 43 (see FIG. 5) by the balance update processing unit 32. After updating the data, using the updated unit data and the reference price data of the contract date of each fund stored on the reference price storage means 44 (see FIG. 6) (the day on which the above contract processing is performed) The balance data of each fund held by each customer stored in the balance data storage means 41 (see FIG. 3) is re-evaluated, and the balance data on the trade date after the re-evaluation is converted into the balance data storage means 41 (see FIG. 3). (Step S12).

  According to such 1st Embodiment, there exist the following effects. That is, the sales commission calculation processing system 10 uses the total amount of funds belonging to the same fund group purchased on the same day (however, if there is a fund belonging to the fund group sold on that day, The total amount of each fund to be sold on that day) and the total amount of the balance of each fund that already belongs to the fund group. Since the amount for rate determination is calculated and the fixed sales commission rate is determined based on this, the fixed sales commission rate is more advantageous to the customer than when it is determined based only on the amount of funds purchased in one order. That is, since it becomes low, a fixed sales commission can be made cheap.

  For this reason, it is possible to provide customers with the opportunity and motivation to purchase additional funds, and the fund sales company can try to acquire customers and prevent the outflow of customers to other sales companies. it can.

  Further, since the sales commission calculation processing system 10 includes the group table storage means 40 and the group designation processing means 21, the person in charge of the fund sales company can easily group the funds. The grouping can be changed accordingly. For example, by grouping multiple funds that you want to recommend to customers, or by combining groups, you can create a larger group and conduct a campaign for a certain period of time. Can be realized.

  Further, the sales commission calculation processing system 10 includes an approximate sales commission rate determination amount calculation processing means 23, an approximate sales commission rate determination processing means 24, an approximate sales commission calculation processing means 25, and an approximate sales commission display processing means 26. Therefore, when an order for purchasing a fund is made, an approximate sales fee and an approximate sales fee rate for the order are displayed on the sales company terminal device 60 and the customer terminal device 50. The sales person or customer of the fund sales company who made the order can check the approximate sales commission and the approximate sales commission rate when placing an order. The approximate sales commission and the approximate sales commission rate displayed on the screen are values that reflect the amount of other orders that have not been executed if other orders have already been made by the customer on that day. Therefore, a more accurate value reflecting the latest information can be grasped. In addition, the estimated sales commission rate applied to this order applies to other orders that have already been executed by the customer on that day as well. In some cases, the estimated sales commission rate applied to other orders that have been dealt with may change, and this change can be grasped.

[Second Embodiment]
FIG. 10 shows a part of the configuration of the sales commission calculation processing system 200 according to the second embodiment of the present invention together with an example of the specific fund designation screen 250 and the configuration of the specific fund storage unit 240. The sales commission calculation processing system 200 according to the second embodiment is an embodiment according to the above-described “invention for determining a sales commission rate based on a balance of a set unit of a plurality of specific funds specified by a customer”. The description of the “invention for determining the sales commission rate based on the balance of a specific fund unit designated by the customer” is also performed in the second embodiment.

  In the sales commission calculation processing system 200 of the second embodiment, the calculation method of the approximate sales commission rate determination amount data and the final sales commission rate determination amount data is different from the sales commission calculation processing system 10 of the first embodiment. Since there are many portions having the same configuration and function, the same portions are denoted by the same reference numerals and detailed description thereof is omitted, and only different portions are described in detail below.

  The sales commission calculation processing server 20 of the first embodiment is provided with the group designation processing means 21 and the group table storage means 40. However, the sales commission calculation processing server 220 of the second embodiment includes Instead, the specific fund registration processing means 221 and the specific fund storage means 240 are provided instead. As in the first embodiment, the sales commission calculation processing server 220 includes an order reception processing means 22, an approximate sales commission rate determination processing means 24, an approximate sales commission calculation processing means 25, and an approximate sales commission display processing means 26. , Reference price acquisition processing means 27, order processing means 28, finalized sales commission rate determination processing means 30, finalized sales commission calculation processing means 31, balance update processing means 32, balance data storage means 41 (see FIG. 3), sales commission rate Table storage means 42 (see FIG. 4), order data storage means 43 (see FIG. 5), and reference price storage means 44 (see FIG. 6) are provided, but are not shown.

  The specific fund registration processing unit 221 displays display data for a specific fund designation screen 250 (see FIG. 10, for example, a Web screen) for the customer to designate a specific fund in response to a customer request from the customer terminal device 50. , To the customer terminal device 50 via the network 1, and the fund identification information (fund code, etc.) for a plurality of specific funds designated by the customer transmitted from the customer terminal device 50 via the network 1 The specific fund storage unit 240 stores the identification information (account number or the like) in association with the identification information.

  The specific fund designation screen 250 shown in FIG. 10 displayed on the customer terminal device 50 includes a customer name display unit 251 for displaying a customer name, an account number display unit 252 for displaying a customer account number, and a specific fund. A current registration status display unit 253 indicating the current registration status, a specific fund selection unit 254 for selecting and specifying a specific fund to be registered, and an “OK” button 255 for registering the specific fund selected by the specific fund selection unit 254 And are provided. In the case of newly registering a specific fund, there is no display of the specific fund on the current registration status display unit 253, and a display indicating that the specific fund is not registered is made. In addition, when changing the already registered specific fund, the specific fund selection unit 254 selects the changed specific fund. When the “OK” button 255 is clicked, the fund identification information (fund code, etc.) for the specific fund selected by the specific fund selection unit 254 is sent to the sales fee calculation processing server via the network 1 along with the customer identification information (account number, etc.). 220 to be transmitted. The customer identification information (account number and the like) is appropriately input from the customer terminal device 50 at the stage before the specific fund designation screen 250 is displayed. In the present embodiment, the maximum number of specific funds that can be registered is three, but the present invention is not limited to this.

  As shown in FIG. 10, the specific fund storage means 240 is fund identification information about a plurality of funds designated by the customer as a specific fund whose sales commission is advantageous to the customer (in this embodiment, a fund code is used as an example). .) Is stored in association with customer identification information (account number as an example in this embodiment) for a customer who has designated a specific fund.

  The approximate sales commission rate determination amount calculation processing means 223 executes a process of provisionally calculating approximate sales commission rate determination amount data related to the received current order data when the order reception processing means 22 receives the order data. Is.

  Specifically, the approximate sales commission rate determination amount calculation processing means 223 uses the customer identification information (account number or the like) included in the current order data received by the order reception processing means 22 as a key, and the specific fund storage means 240. (See FIG. 10), by extracting all the fund identification information (fund code, etc.) stored in correspondence with the customer identification information about the customer who placed the current order, the customer who placed the current order Get information about all the specific funds registered by. Then, the approximate sales commission rate determination amount calculation processing means 223 is configured such that the fund identification information included in the current order data is the fund identification information for any specific fund registered by the customer who made the current order. Judge whether there is. Here, in the case of the fund identification information for the specific fund of the customer, each order data of other trades already placed before the trade stored in the order data storage means 43 (see FIG. 5) is It is determined whether or not the order data has the same customer identification information as the customer identification information included in the order data and the fund identification information for any specific fund registered by the customer. As a result, it is possible to grasp the order data of each specific fund of the customer by the same customer as the customer who placed the order this time. The customer's order data received by the customer and the customer who has made the current order stored in the order data storage means 43 (see FIG. 5) For each order data of other buying and selling of pre-orders of the previous commitments of specific funds, perform the following processing. For example, if the customer who made the order this time is Taro Yamato and the fund traded in this order is Fund A, in the example of the specific fund storage means 240 shown in FIG. Since funds A, B, and C (see FIG. 2), the fund A that was bought and sold in this order is a special fund by Yamato Taro. Accordingly, the following processing is performed for each order data of the funds A, B, and C among other order data of orders already made by Taro Yamato today.

  That is, in the case of an order for which the amount is designated, the approximate sales commission rate determining amount calculation processing means 223 is stored in the current order data and order data storage means 43 (see FIG. 5) received by the order reception processing means 22. Amount data in the case where the trade classification data is data indicating purchase for each order data of other trades already placed before the execution of each specific fund of the customer by the same customer who made the current order The deduction amount data is calculated by subtracting the total amount data of the sale, which is the sum of the amount data when the selling / selling division data is data indicating the sale, from the total amount data of the purchase obtained by totaling the items. Then, by adding the calculated deduction amount data and the total amount data of the balance data of the previous day for all the specific funds of the customer stored in the balance data storage means 41 (see FIG. 3), the current order data Tentatively calculate the approximate sales commission rate amount data for At this time, the process of acquiring the balance data of the previous day for all the specific funds of the customer from the balance data storage means 41 (see FIG. 3) is performed by the customer identification information included in the current order data and the customer registering This is done using fund identification information for a specific fund as a key.

  In the case of an order with a specified number of units, the approximate sales commission rate determination amount calculation processing means 223 is stored in the current order data and order data storage means 43 (see FIG. 5) received by the order reception processing means 22. For each order data of other trades that have already been placed before the execution of each specific fund of the customer by the same customer who has placed the current order, the unit data when the trade classification data is data indicating buying For each specific fund, subtracted number data is calculated by subtracting the total number data of selling, which is the total of the number data when the trading classification data is data indicating selling, from the total number data of buying. Then, the reference price data of the previous day of each specific fund is extracted from the reference price storage means 44 (see FIG. 6) using the fund identification information for each specific fund as a key. Subtract amount data for each specific fund is calculated by multiplying the extracted reference price data for each specific fund on the previous day. Then, the total amount data of the calculated deduction amount data of each specific fund is added to the total amount data of the balance data of the previous day of all the specific funds of the customer stored in the balance data storage means 41 (see FIG. 3). As a result, the amount data for determining the approximate sales commission rate related to the current order data is provisionally calculated. At this time, the process of acquiring the balance data of the previous day for all the specific funds of the customer from the balance data storage means 41 (see FIG. 3) is performed by the customer identification information included in the current order data and the customer registering This is done using fund identification information for a specific fund as a key.

  On the other hand, the approximate sales commission rate determination amount calculation processing means 223 determines whether or not the fund identification information included in the current order data is the fund identification information for the specific fund registered by the customer who made the current order. If it is not the fund identification information for the specific fund of the customer, the calculation processing of the amount data for determining the approximate sales commission rate according to the present invention is not applied, and the normal estimation that has been performed conventionally is not applied. It is the amount data for determining the sales commission rate. That is, in the case of an order for which the amount is designated, the amount data when the trade classification data included in the current order data is data indicating buying is used as the approximate sales commission rate determining amount data. Further, in the case of order specifying the number of units, the order data extracted from the reference price storage means 44 (see FIG. 6) is added to the number data when the trade classification data included in the current order data is data indicating purchase. The amount data obtained by multiplying the basic price data on the previous day of the fund is used as the amount data for determining the approximate sales commission rate.

<In the case of an invention that determines the sales commission rate based on the balance of a specific fund unit specified by the customer>
In the case of the above-mentioned “invention that determines the sales commission rate with the balance of a specific fund unit specified by the customer”, the balance of the collective unit of a plurality of specific funds is not calculated, but the balance of one specific fund Pay attention to. Therefore, the approximate sales commission rate determination amount calculation processing means 223 first refers to the specific fund storage means 240 (see FIG. 10), and the fund identification information included in the current order data indicates that the customer who made the current order It is determined whether or not it is fund identification information for any specific fund registered. Here, in the case of the fund identification information for the specific fund of the customer, each order data of other trades already placed before the trade stored in the order data storage means 43 (see FIG. 5) is Whether the order data has the same customer identification information as the customer identification information included in the order data and the same fund identification information as the fund identification information for the specific fund included in the current order data Since the order data of the same specific fund by the same customer as the customer who made the order this time can be grasped, the amount calculation processing means 223 for determining the approximate sales commission rate is the order reception processing means. 22 by the same customer as the customer who placed the current order stored in the current order data and order data storage means 43 (see FIG. 5). For the same for each order data of other trade commitments before the pre-ordering of a particular fund, the following processing is performed. For example, if the customer who made the order this time is Taro Yamato and the fund traded in this order is Fund A, in the example of the specific fund storage means 240 shown in FIG. Since funds A, B, and C (see FIG. 2), the fund A that was bought and sold in this order is a special fund by Yamato Taro. However, among the other order data of orders already made by Taro Yamato today, the following processing is not performed for each order data of funds A, B, and C, but only for order data of fund A. Perform the following process.

<In the case of an invention in which the sales commission rate is determined by the balance of a specific fund unit specified by the customer; continued>
That is, in the case of an order for which the amount is designated, the approximate sales commission rate determining amount calculation processing means 223 is stored in the current order data and order data storage means 43 (see FIG. 5) received by the order reception processing means 22. For each order data of other trades that have already been placed on the same specific fund by the same customer who placed the current order, the sum of the amount data when the trade classification data is data indicating buying The subtracted amount data is calculated by subtracting the total amount data of the sale, which is the sum of the amount data when the sales division data is data indicating sale, from the total amount data of the purchased. Then, by adding the calculated deduction amount data and the balance data of the specific fund the previous day of the customer stored in the balance data storage means 41 (see FIG. 3), an approximate sales commission relating to the current order data is added. Temporary calculation of rate determining amount data. At this time, the process of acquiring the balance data of the specific fund the previous day of the customer from the balance data storage means 41 (see FIG. 3) is performed using the customer identification information and fund identification information included in the current order data as keys. .

<In the case of an invention in which the sales commission rate is determined by the balance of a specific fund unit specified by the customer; continued>
In the case of an order with a specified number of units, the approximate sales commission rate determination amount calculation processing means 223 is stored in the current order data and order data storage means 43 (see FIG. 5) received by the order reception processing means 22. For each order data of other trades that have already been placed for the same specific fund by the same customer who placed the current order, the total of the number data when the trade classification data is data indicating buying The subtracted number data obtained by subtracting the total number data of the sales, which is the sum of the number data when the trading classification data is data indicating sales, is calculated from the total number data of the purchased items. Then, the reference price data of the previous day of the specific fund is extracted from the reference price storage means 44 (see FIG. 6) using the fund identification information about the specific fund as a key, and the extracted specific number data is included in the calculated subtraction number data. Multiply the basic price data of the previous day of the fund to calculate the deduction amount data. Then, by adding the calculated deduction amount data and the balance data of the specific fund of the customer stored in the balance data storage means 41 (see FIG. 3) on the previous day, an approximate sales fee for the current order data is added. Temporary calculation of rate determining amount data. At this time, the process of acquiring the balance data of the specific fund the previous day of the customer from the balance data storage means 41 (see FIG. 3) is performed using the customer identification information and fund identification information included in the current order data as keys. .

<In the case of an invention in which the sales commission rate is determined by the balance of a specific fund unit specified by the customer; continued>
On the other hand, the approximate sales commission rate determination amount calculation processing means 223 determines whether or not the fund identification information included in the current order data is the fund identification information for the specific fund registered by the customer who made the current order. If it is not fund identification information for the specific fund of the customer, the same as in the case of “Invention for determining the sales commission rate based on the balance of the aggregate unit of a plurality of specific funds specified by the customer” The calculation processing of the approximate sales commission rate determining amount data according to the present invention is not applied, and the conventional approximate sales commission rate determining amount data is conventionally used.

  The fixed sales commission rate determination amount calculation processing means 229 performs processing of the order data stored in the order data storage means 43 during the contract processing of the order data stored in the order data storage means 43 (see FIG. 5). The processing for calculating the fixed sales commission rate determining amount data relating to the is executed.

  Specifically, the fixed sales commission rate determination amount calculation processing means 229 uses the customer identification information (account number, etc.) included in the processing target order data stored in the order data storage means 43 (see FIG. 5). Extracting, as a key, all fund identification information (fund code, etc.) stored in correspondence with the customer identification information about the customer who has placed the order to be processed from the specific fund storage means 240 (see FIG. 10) Thus, information on all the specific funds registered by the customer who has made the order to be processed is obtained. Then, the fixed sales commission rate determination amount calculation processing means 229 uses the fund identification information included in the order data to be processed as the fund identification for any specific fund registered by the customer who has made the order to be processed. It is determined whether it is information. Here, in the case of fund identification information for the specific fund of the customer, each order data of other trades executed and stored in the order data storage means 43 (see FIG. 5) is the order data to be processed. By determining whether the order data has the same customer identification information as the customer identification information included in the client and the fund identification information for any specific fund registered by the customer, Since it is possible to grasp the order data of each specific fund of the customer by the same customer who made the order to be processed, the fixed sales commission rate determination amount calculation processing means 229 is the order data storage means 43 (FIG. 5)), the order data of the trades of each specific fund of the customer by the same customer who made the order to be processed Processing is carried out.

  That is, in the case of an order for which the amount is designated, the fixed sales commission rate determination amount calculation processing means 229 is the same as the customer who has placed the processing target order stored in the order data storage means 43 (see FIG. 5). For each order data of the trade of each specific fund of the customer by the customer, the data indicating that the trade classification data indicates selling from the total price data of the purchase when the trade classification data is data indicating buy Is calculated by subtracting the total amount data of the sale that is the sum of the amount data. Then, by adding the calculated deduction amount data and the total amount data of the balance data of the previous day of all the specific funds of the customer stored in the balance data storage means 41 (see FIG. 3), the order to be processed Calculate amount data for determining the fixed sales commission rate related to the data. At this time, the process of acquiring the balance data for the specific day of all the specific funds of the customer from the balance data storage means 41 (see FIG. 3) is the customer identification information included in the order data to be processed, and the customer registered This is done using fund identification information for a specific fund as a key.

  In the case of an order with a specified number of units, the fixed sales commission rate determination amount calculation processing means 229 is the same as the customer who has placed the processing target order stored in the order data storage means 43 (see FIG. 5). For each order data of the trade of each specific fund of the customer by the customer, the data indicating that the trade classification data indicates sale from the total quantity data of the buys when the trade classification data is data indicating buy For each specific fund, subtracted unit data is calculated by subtracting the total number of units sold. Then, the reference price data of the previous day of each specific fund is extracted from the reference price storage means 44 (see FIG. 6) using the fund identification information for each specific fund as a key. Subtract amount data for each specific fund is calculated by multiplying the extracted reference price data for each specific fund on the previous day. Then, the total amount data of the calculated deduction amount data of each specific fund is added to the total amount data of the balance data of the previous day of all the specific funds of the customer stored in the balance data storage means 41 (see FIG. 3). By doing so, the fixed sales commission rate determining amount data relating to the order data to be processed is calculated. At this time, the process of acquiring the balance data for the specific day of all the specific funds of the customer from the balance data storage means 41 (see FIG. 3) is the customer identification information included in the order data to be processed, and the customer registered This is done using fund identification information for a specific fund as a key.

  On the other hand, in the fixed sales commission rate determination amount calculation processing means 229, the fund identification information included in the order data to be processed is fund identification information for a specific fund registered by the customer who has made the order to be processed. If it is not the fund identification information for the specific fund of the customer, the calculation processing of the amount data for determining the fixed sales commission rate according to the present invention is not applied, and it has been conventionally performed Data for determining the fixed sales commission rate. That is, in the case of an order for which the amount is designated, the amount data when the trade classification data included in the order data to be processed is data indicating buying is set as the amount data for determining the fixed sales commission rate. Further, in the case of an order for which the number is specified, the order extracted from the reference price storage means 44 (see FIG. 6) is used as the number data when the trade classification data included in the order data to be processed is data indicating buying. The amount data obtained by multiplying the previous day's base price data of the fund is used as the fixed sales commission rate determination amount data.

<In the case of an invention that determines the sales commission rate based on the balance of a specific fund unit specified by the customer>
In the case of the above-mentioned “invention that determines the sales commission rate with the balance of a specific fund unit specified by the customer”, the balance of the collective unit of a plurality of specific funds is not calculated, but the balance of one specific fund Pay attention to. Therefore, the fixed sales commission rate determination amount calculation processing means 229 first refers to the specific fund storage means 240 (see FIG. 10), and the fund identification information included in the order data to be processed places the order to be processed. It is determined whether or not it is fund identification information for any specific fund registered by the customer. Here, in the case of the fund identification information for the specific fund of the customer, each order data of the traded trade stored in the order data storage means 43 (see FIG. 5) is included in the order data to be processed. To determine whether the order data has the same customer identification information as the customer identification information and the same fund identification information as the fund identification information for the specific fund included in the order data to be processed Thus, the order data of the same specific fund by the same customer as the customer who placed the order to be processed can be grasped. 5)) for each order data of the traded transaction of the same specific fund by the same customer who made the order to be processed , Perform the following processing.

<In the case of an invention in which the sales commission rate is determined by the balance of a specific fund unit specified by the customer; continued>
That is, in the case of an order for which the amount is designated, the fixed sales commission rate determination amount calculation processing means 229 is the same as the customer who has placed the processing target order stored in the order data storage means 43 (see FIG. 5). For each order data of trades made by the same specific fund by a customer, the trading category data is data indicating selling from the total amount data of buying in which the trading amount data is data indicating buying when the trading category data is data indicating buying. In this case, the deduction amount data is calculated by subtracting the total amount data of the sale, which is the sum of the case amount data. Then, by adding the calculated deduction amount data and the balance data of the specific fund of the customer stored in the balance data storage means 41 (see FIG. 3) on the previous day, the final sale related to the order data to be processed is added. Calculate fee rate determination data. At this time, the process of acquiring the balance data of the specific fund of the customer the previous day from the balance data storage means 41 (see FIG. 3) is performed using the customer identification information and the fund identification information included in the order data to be processed as keys. Is called.

<In the case of an invention in which the sales commission rate is determined by the balance of a specific fund unit specified by the customer; continued>
In the case of an order with a specified number of units, the fixed sales commission rate determination amount calculation processing means 229 is the same as the customer who has placed the processing target order stored in the order data storage means 43 (see FIG. 5). For each order data of the trade of the same specific fund by the customer, the trade classification data is the data indicating the sale, from the total quantity data of the buy that is the total of the quantity data when the trade classification data is the data indicating the buy Subtracted number data is calculated by subtracting the total number data of selling, which is the sum of the number data of cases. Then, the reference price data of the previous day of the specific fund is extracted from the reference price storage means 44 (see FIG. 6) using the fund identification information about the specific fund as a key, and the extracted specific number data is included in the calculated subtraction number data. Multiply the basic price data of the previous day of the fund to calculate the deduction amount data. Then, by adding the calculated deduction amount data and the balance data of the specific fund of the customer stored in the balance data storage means 41 (see FIG. 3) on the previous day, the final sale related to the order data to be processed is added. Calculate fee rate determination data. At this time, the process of acquiring the balance data of the specific fund of the customer the previous day from the balance data storage means 41 (see FIG. 3) is performed using the customer identification information and the fund identification information included in the order data to be processed as keys. Is called.

<In the case of an invention in which the sales commission rate is determined by the balance of a specific fund unit specified by the customer; continued>
On the other hand, in the fixed sales commission rate determination amount calculation processing means 229, the fund identification information included in the order data to be processed is fund identification information for a specific fund registered by the customer who has made the order to be processed. If it is not fund identification information for the specific fund of the customer, the case of “invention that determines the sales commission rate based on the balance of the collective unit specified by the customer” Similarly, the calculation processing of the fixed sales commission rate determining amount data according to the present invention is not applied, and the conventional fixed sales commission rate determining amount data is conventionally used.

  According to such 2nd Embodiment, there exist the following effects. That is, in the sales commission calculation processing system 200, the total amount of purchase amounts of a plurality of specific funds designated by the customer (if any specific fund is sold, the amount is the amount obtained by subtracting the sale amount from the purchase amount. ) And the total amount of balances already held for multiple specific funds, the fixed sales commission rate amount is calculated and the final sales commission rate is determined based on this. Since the commission rate is advantageous to the customer, that is, lower than the case where the commission rate is determined based only on the amount of funds to be purchased in one order, the fixed sales commission can be reduced.

  For this reason, it is possible to provide customers with the opportunity and motivation to purchase additional funds, and the fund sales company can try to acquire customers and prevent the outflow of customers to other sales companies. it can.

  Further, since the sales commission calculation processing system 200 includes the specific fund registration processing means 221 and the specific fund storage means 240, the customer can select and register a specific fund that is advantageous for the sales commission. Depending on your purpose, you can make a selection.

  Further, the sales commission calculation processing system 200 includes an approximate sales commission rate determination amount calculation processing means 223, an approximate sales commission rate determination processing means 24, an approximate sales commission calculation processing means 25, and an approximate sales commission display processing means 26. Therefore, when an order for purchasing a fund is made, an approximate sales fee and an approximate sales fee rate for the order are displayed on the sales company terminal device 60 and the customer terminal device 50. The sales person or customer of the fund sales company who made the order can check the approximate sales commission and the approximate sales commission rate when placing an order. The approximate sales commission and the approximate sales commission rate displayed on the screen are values that reflect the amount of other orders that have not been executed if other orders have already been made by the customer on that day. Therefore, a more accurate value reflecting the latest information can be grasped. In addition, the estimated sales commission rate applied to this order applies to other orders that have already been executed by the customer on that day as well. In some cases, the estimated sales commission rate applied to other orders that have been dealt with may change, and this change can be grasped.

[Third Embodiment]
FIG. 11 shows a part of the configuration of the sales commission calculation processing system 300 according to the third embodiment of the present invention, along with an example of the processing flow. The sales commission calculation processing system 300 according to the third embodiment is an embodiment according to the above-described “invention for determining a sales commission rate based on a collective balance of a plurality of funds having a large balance”. The description of the “invention for determining the sales commission rate with a large fund unit balance” is also described in the third embodiment.

  In the sales commission calculation processing system 300 of the third embodiment, the calculation method of the approximate sales commission rate determination amount data and the final sales commission rate determination amount data is different from the sales commission calculation processing system 10 of the first embodiment. Since there are many portions having the same configuration and function, the same portions are denoted by the same reference numerals and detailed description thereof is omitted, and only different portions are described in detail below.

  The sales commission calculation processing server 20 of the first embodiment is provided with the group designation processing means 21 and the group table storage means 40. However, the sales commission calculation processing server 320 of the third embodiment includes these. Not provided. As in the first embodiment, the sales commission calculation processing server 320 includes the order reception processing means 22, the approximate sales commission rate determination processing means 24, the approximate sales commission calculation processing means 25, and the approximate sales commission display processing means 26. , Reference price acquisition processing means 27, order processing means 28, finalized sales commission rate determination processing means 30, finalized sales commission calculation processing means 31, balance update processing means 32, balance data storage means 41 (see FIG. 3), sales commission rate Table storage means 42 (see FIG. 4), order data storage means 43 (see FIG. 5), and reference price storage means 44 (see FIG. 6) are provided, but are not shown.

  The approximate sales commission rate determination amount calculation processing means 323 executes a process of temporarily calculating the approximate sales commission rate determination amount data related to the received current order data when the order reception processing means 22 receives the order data. Is.

  Specifically, the approximate sales commission rate determination amount calculation processing means 323 is configured to process each order data of other trades that have already been placed before the trade stored in the order data storage means 43 (see FIG. 5). Order data by the same customer as the customer who placed the current order by determining whether the order data has the same customer identification information as the customer identification information included in the current order data received by the means 22 Therefore, the approximate sales commission rate determination amount calculation processing means 323 stores the current order data received by the order reception processing means 22 and the current order data storage means 43 (see FIG. 5). The following processing is performed for each order data of other trades that have already been placed by the same customer as the customer who placed the order.

  That is, in the case of an order for which the amount is designated, the approximate sales commission rate determining amount calculation processing means 323 is stored in the current order data and order data storage means 43 (see FIG. 5) received by the order reception processing means 22. For each order data of other trades that have already been placed by the same customer as the customer who placed the current order, the total amount of the buy that is the sum of the amount data when the trade classification data is data indicating buy For each fund, subtraction amount data is calculated by subtracting the total amount data of selling, which is the sum of the amount data when the trade classification data is data indicating selling, from the data. Then, by adding the calculated deduction amount data of each fund and the balance data of the previous day of each fund of the customer stored in the balance data storage means 41 (see FIG. 3) for each fund, Calculate the balance data for each fund you have.

  In the case of an order with a specified number of units, the approximate sales commission rate determination amount calculation processing means 323 is stored in the current order data and order data storage means 43 (see FIG. 5) received by the order reception processing means 22. The total number of units purchased by adding the unit data when the transaction classification data is data indicating buying, for each order data of other orders that have already been ordered by the same customer who placed the current order. For each fund, subtraction number data obtained by subtracting the total number data of selling, which is the sum of the number data in the case where the trade classification data is data indicating selling, is calculated for each fund. Then, the base price data of the previous day of each fund is extracted from the base price storage means 44 (see FIG. 6) using the fund identification information for each fund as a key, and each of the extracted subtraction data for each fund is extracted. Subtract amount data for each fund by multiplying the base price data for the previous day of the fund. Then, by adding the calculated balance data of each fund and the balance data of the previous day of each fund of the customer stored in the balance data storage means 41 (see FIG. 3) for each fund, Calculate the balance data for each fund you have.

  Then, the approximate sales commission rate determination amount calculation processing means 323 determines a plurality (for example, three issues) of large balance funds in which the amount of the calculated balance data for each fund is equal to or greater than (within) a predetermined rank. Then, it is determined whether or not the fund of the fund identification information included in the current order data is a large balance fund. If the fund is a large balance fund, the balance data by funds for a plurality of large balance funds is totaled. As a result, the amount data for determining the approximate sales commission rate related to the current order data is provisionally calculated.

  On the other hand, when the fund identification information included in the current order data is not a large balance fund, the calculation processing of the approximate sales commission rate determination amount calculation processing means 323 performs the calculation processing of the approximate sales commission rate determination amount data according to the present invention. It is not applied, and it is assumed to be the usual data for determining the approximate sales commission rate that has been performed conventionally. That is, in the case of an order for which the amount is designated, the amount data when the trade classification data included in the current order data is data indicating buying is used as the approximate sales commission rate determining amount data. Further, in the case of order specifying the number of units, the order data extracted from the reference price storage means 44 (see FIG. 6) is added to the number data when the trade classification data included in the current order data is data indicating purchase. The amount data obtained by multiplying the basic price data on the previous day of the fund is used as the amount data for determining the approximate sales commission rate.

  For example, as shown in FIG. 11, the outstanding balance of each fund of Yamato Taro is “1st place: Fund A 5 million yen”, “2nd place: Fund B 4 million yen”, “3rd place: “Fund C 1.5 million yen” and “4th place: Fund D 500,000 yen”, and the system is set up so that a large balance fund up to the top three stocks will be a sales commission advantageous to customers To do. In this state, when fund D is purchased at 2 million yen (order number = N1), the balance data by fund for fund D increases to 2.5 million yen and is ranked 3rd and is the top 3 stocks. Since the total amount of balance data by funds for funds A, B, and D is 11.5 million yen, which exceeds 10 million yen, the approximate sales commission rate for order data with order number = N1 is At the time, it becomes 1.575% (see FIG. 4).

  Then, if you purchase 500,000 yen for fund C (order number = N2), the balance data by fund for fund C will increase to 2 million yen, but it will remain in 4th place, so order data for order number = N2 Based on the purchase amount of 500,000 yen, the estimated sales commission rate will be 2.100% using the usual method used in the past (see Fig. 4). Since there are no changes in the top three issues, the approximate sales commission rate relating to the order data of order number = N1 remains 1.575%.

  Furthermore, when fund E is purchased 3 million yen (order number = N3), the balance data by fund for fund E will be 3 million yen, so it is ranked 3rd and funds A and B which are the top 3 stocks. , E, the total amount of the balance data by fund is 12 million yen, which is more than 10 million yen. At this point, the estimated sales commission rate for order data with order number = N3 is 1 575% (see FIG. 4). On the other hand, the balance data by fund for fund D drops to fourth place, so the approximate sales commission rate related to the order data of order number = N1 varies from 1.575% to 2.100%. The balance data by fund for fund C dropped from 4th to 5th, but was not within 3rd place, so the approximate sales commission rate for order data with order number = N2 is 2. It remains 100%.

<In the case of an invention that determines the sales commission rate based on the balance of funds with a large balance>
In the case of the “invention for determining the sales commission rate with the balance of a fund unit with a large balance” as described above, the balance of the collective unit of a plurality of large balance funds is not calculated, but the balance of one large balance fund. Pay attention to. Accordingly, the amount calculation processing means 323 for determining the approximate sales commission rate first determines whether or not the above-mentioned “balance of a plurality of funds having a large balance” in both the case of the amount-designated order and the number-designated order. In the same manner as in the case of “the invention for determining the sales commission rate”, the balance data for each fund held by the customer is calculated.

<In the case of an invention in which the sales commission rate is determined by the balance of a fund unit with a large balance; continued>
Then, the approximate sales commission rate determination amount calculation processing means 323 determines a plurality (for example, three issues) of large balance funds in which the amount of the calculated balance data for each fund is equal to or greater than (within) a predetermined rank. Then, it is determined whether the fund of the fund identification information included in the current order data is a large balance fund. If the fund is a large balance fund, the balance data by fund for the large balance fund is Data for determining the approximate sales commission rate related to the order data.

<In the case of an invention in which the sales commission rate is determined by the balance of a fund unit with a large balance; continued>
On the other hand, when the fund identification information included in the current order data is not a large balance fund, the calculation processing of the approximate sales commission rate determination amount calculation processing means 323 performs the calculation processing of the approximate sales commission rate determination amount data according to the present invention. It is not applied, and it is assumed to be the usual data for determining the approximate sales commission rate that has been performed conventionally. That is, in the case of an order for which the amount is designated, the amount data when the trade classification data included in the current order data is data indicating buying is used as the approximate sales commission rate determining amount data. Further, in the case of order specifying the number of units, the order data extracted from the reference price storage means 44 (see FIG. 6) is added to the number data when the trade classification data included in the current order data is data indicating purchase. The amount data obtained by multiplying the basic price data of the previous day of the fund is used as the amount data for determining the approximate sales commission rate.

  The fixed sales commission rate determination amount calculation processing means 329 is processing order data stored in the order data storage means 43 at the time of execution of the order data stored in the order data storage means 43 (see FIG. 5). The processing for calculating the fixed sales commission rate determining amount data relating to the is executed.

  Specifically, the fixed sales commission rate determination amount calculation processing means 329 stores each order data of the traded trades stored in the order data storage means 43 (see FIG. 5) in the order data storage means 43. By determining whether or not the order data has the same customer identification information as the customer identification information included in the processing order order data, the order data from the same customer who placed the processing target order is grasped. Therefore, the fixed sales commission rate determining amount calculation processing means 329 can execute the contracted sales / purchase by the same customer as the customer who has placed the processing target order stored in the order data storage means 43 (see FIG. 5). The following processing is performed for each order data.

  That is, in the case of an order for which the amount is designated, the fixed sales commission rate determining amount calculation processing means 329 is the same as the customer who has placed the processing target order stored in the order data storage means 43 (see FIG. 5). For each order data of the trade executed by the customer, the amount data when the transaction classification data is data indicating sale is obtained from the total amount data of purchase when the transaction classification data is data indicating purchase. Subtract amount data obtained by subtracting the total amount data of the total sales is calculated for each fund. Then, by adding the calculated deduction amount data of each fund and the balance data of the previous day of each fund of the customer stored in the balance data storage means 41 (see FIG. 3) for each fund, Calculate the balance data for each fund you have.

  In the case of an order with a specified number of units, the fixed sales commission rate determination amount calculation processing means 329 is the same as the customer who has placed the processing target order stored in the order data storage means 43 (see FIG. 5). For each order data of the contracts traded by the customer, from the total number data of buying, where the trading classification data is data indicating buying, the number data when the trading classification data is data indicating selling is obtained. Subtract data is calculated for each fund by subtracting the total sales data of the total sales. Then, the base price data of the previous day of each fund is extracted from the base price storage means 44 (see FIG. 6) using the fund identification information for each fund as a key, and each of the extracted subtraction data for each fund is extracted. Subtract amount data for each fund by multiplying the base price data for the previous day of the fund. Then, by adding the calculated balance data of each fund and the balance data of the previous day of each fund of the customer stored in the balance data storage means 41 (see FIG. 3) for each fund, Calculate the balance data for each fund you have.

  Then, the fixed sales commission rate determination amount calculation processing means 329 determines a plurality (for example, three brands) of large balance funds whose calculated amount of balance data for each fund is equal to or greater than (within) a predetermined rank. Then, it is determined whether the fund of the fund identification information included in the order data to be processed is a large balance fund. If the fund is a large balance fund, the balance data for each fund for a plurality of large balance funds is obtained. By summing up, the final sales commission rate determining amount data relating to the processing target order data is calculated.

  On the other hand, when the fund identification information included in the order data to be processed is not a large balance fund, the fixed sales commission rate determination amount calculation processing means 329 calculates the fixed sales commission rate determination amount data according to the present invention. Is not applied, and it is assumed to be the usual data for determining the fixed sales commission rate that has been performed conventionally. That is, in the case of an order for which the amount is designated, the amount data when the trade classification data included in the order data to be processed is data indicating buying is set as the amount data for determining the fixed sales commission rate. Further, in the case of an order for which the number is specified, the order extracted from the reference price storage means 44 (see FIG. 6) is used as the number data when the trade classification data included in the order data to be processed is data indicating buying. The amount data obtained by multiplying the previous day's base price data of the fund is used as the fixed sales commission rate determination amount data.

<In the case of an invention that determines the sales commission rate based on the balance of funds with a large balance>
In the case of the “invention for determining the sales commission rate with the balance of a fund unit with a large balance” as described above, the balance of the collective unit of a plurality of large balance funds is not calculated, but the balance of one large balance fund. Pay attention to. Therefore, the fixed sales commission rate determination amount calculation processing means 329 first determines whether the balance of the collective unit of a plurality of funds having a large balance is the above-mentioned in both cases of the amount-designated order and the number-designated order. In the same manner as in the case of “the invention for determining the sales commission rate”, the balance data for each fund held by the customer is calculated.

<In the case of an invention in which the sales commission rate is determined by the balance of a fund unit with a large balance; continued>
Then, the fixed sales commission rate determination amount calculation processing means 329 determines a plurality (for example, three brands) of large balance funds whose calculated amount of balance data for each fund is equal to or greater than (within) a predetermined rank. Then, it is determined whether the fund of the fund identification information included in the order data to be processed is a large balance fund. If the fund is a large balance fund, the balance data by fund for the large balance fund is The fixed sales commission rate determining amount data related to the processing target order data is used.

<In the case of an invention in which the sales commission rate is determined by the balance of a fund unit with a large balance; continued>
On the other hand, when the fund identification information included in the order data to be processed is not a large balance fund, the fixed sales commission rate determination amount calculation processing means 329 calculates the fixed sales commission rate determination amount data according to the present invention. Is not applied, and it is assumed to be the usual data for determining the fixed sales commission rate that has been performed conventionally. That is, in the case of an order for which the amount is designated, the amount data when the trade classification data included in the order data to be processed is data indicating buying is set as the amount data for determining the fixed sales commission rate. Further, in the case of an order for which the number is specified, the order extracted from the reference price storage means 44 (see FIG. 6) is used as the number data when the trade classification data included in the order data to be processed is data indicating buying. The amount data obtained by multiplying the previous day's base price data of the fund is used as the fixed sales commission rate determination amount data.

  According to such 3rd Embodiment, there exist the following effects. That is, in the sales commission calculation processing system 300, the total purchase amount of a plurality of funds with a large balance (a large balance fund) (if any large balance fund is sold, the sale amount is subtracted from the purchase amount) And the total amount of balances already held for multiple large balance funds, the amount for determining the fixed sales commission rate is calculated, and the fixed sales commission rate is determined based on this Therefore, the fixed sales commission rate is advantageous to the customer, that is, lower than the case where the fixed sales commission rate is determined based only on the amount of funds purchased in one order, so that the fixed sales commission can be reduced.

  For this reason, it is possible to provide customers with the opportunity and motivation to purchase additional funds, and the fund sales company can try to acquire customers and prevent the outflow of customers to other sales companies. it can.

  Further, since the sales commission calculation processing system 300 performs a process in which the sales commission is advantageous to the customer for a fund with a large balance (a large balance fund), the fund in which the sales commission is advantageous to the customer is determined in advance by the fund sales company. Compared to the case stipulated by the stipulations, the sales commission will be advantageous to the customer who invested a large amount according to their own purpose, so it is possible to provide services according to the customer's intention and purpose Become.

  The sales commission calculation processing system 300 further includes an approximate sales commission rate determination amount calculation processing means 323, an approximate sales commission rate determination processing means 24, an approximate sales commission calculation processing means 25, and an approximate sales commission display processing means 26. Therefore, when an order for purchasing a fund is made, an approximate sales fee and an approximate sales fee rate for the order are displayed on the sales company terminal device 60 and the customer terminal device 50. The sales person or customer of the fund sales company who made the order can check the approximate sales commission and the approximate sales commission rate when placing an order. The approximate sales commission and the approximate sales commission rate displayed on the screen are values that reflect the amount of other orders that have not been executed if other orders have already been made by the customer on that day. Therefore, a more accurate value reflecting the latest information can be grasped. In addition, the estimated sales commission rate applied to this order applies to other orders that have already been executed by the customer on that day as well. In some cases, the estimated sales commission rate applied to other orders that have been dealt with may change, and this change can be grasped.

[Deformation form]
Note that the present invention is not limited to the above-described embodiments, and modifications and the like within a range in which the object of the present invention can be achieved are included in the present invention.

  For example, in each of the embodiments, the approximate sales fee and the approximate sales fee rate are displayed on the sales company terminal device 60 and the customer terminal device 50. However, the display may not be performed. . However, it is preferable to have a configuration for displaying these information, so that the customer or a salesperson who has received a request from the customer can check provisional information about the purchased fund in real time. By informing the customer that the sales commission rate has become more favorable than usual, the customer can be given the opportunity and motivation for the next investment.

  In the first embodiment, there is no description regarding switching (transfer) between funds. However, for switching between funds belonging to the same fund group, a fee can be free. That is, it is input by the person in charge (salesperson) of the fund sales company that has received a request from the customer and transmitted from the sales company terminal device 60 via the internal network 2, or is input by the customer and the customer terminal device. Switching acceptance processing means for executing processing for receiving fund identification information (fund code) and money amount data to be switched for funds before and after switching transmitted from the network 1 through the network 1, and group table storage means 40 (FIG. 2). The same fund group is determined by determining whether the fund identification information about the funds before and after switching received by the switching acceptance processing means is associated with the same group identification information (group code). Switching in When it is determined that the switching is within the same fund group, the intra-group switching success / failure determination processing means for executing the processing of setting the fee data to zero and storing it in the order data storage means for switching It may be provided. In addition, without providing any order data storage means for switching, by using a plurality of records in the order data storage means 43 in FIG. 5, information on the fund on the selling side and information on the fund on the purchasing side in switching can be obtained. You may make it preserve | save. On the other hand, when it is determined by the intra-group switching success / failure determination processing means that the switching is not within the same fund group, the same processing as in the case of purchasing the fund in the first embodiment is performed for the fund on the purchase side, Approximate sales commission data and temporary sales commission data are calculated.

  As described above, the sales commission calculation processing system, method and program thereof according to the present invention are the same or different funds at a securities company in which a customer who has purchased a fund at a securities company manages the balance of the fund. It is suitable for use in the sales fee calculation process when purchasing.

1 is an overall configuration diagram of a sales fee calculation processing system according to a first embodiment of the present invention. The block diagram of the group table memory | storage means of 1st Embodiment. The block diagram of the balance data storage means of 1st Embodiment. The block diagram of the sales commission rate table memory | storage means of 1st Embodiment. The block diagram of the order data storage means of 1st Embodiment. The block diagram of the reference | standard price memory | storage means of 1st Embodiment. The figure of the flowchart which shows the flow of the calculation process of the sales commission by the sales commission calculation processing system of 1st Embodiment. FIG. 4 is an exemplary diagram of a group designation screen according to the first embodiment. The illustration figure of the order screen and order content confirmation screen of 1st Embodiment. The figure which shows a part of structure of the sales commission calculation processing system of 2nd Embodiment of this invention, an example of a specific fund designation | designated screen, and the structure of a specific fund memory | storage means. The figure which shows a part of structure of the sales commission calculation processing system of 3rd Embodiment of this invention, and an example of the flow of a process.

Explanation of symbols

10, 200, 300 Sales commission calculation processing system 21 Group designation processing means 22 Order reception processing means 23, 223, 323 Approximate sales commission rate determination amount calculation processing means 24 Approximate sales commission rate determination processing means 25 Approximate sales commission calculation processing means 26 Estimated sales commission display processing means 29, 229, 329 Final sales commission rate determination amount calculation processing means 30 Final sales commission rate determination processing means 31 Final sales commission calculation processing means 40 Group table storage means 41 Balance data storage means 42 Sales commission Rate table storage means 43 Order data storage means 44 Base price storage means 221 Specific fund registration processing means 240 Specific fund storage means

Claims (20)

A sales commission calculation processing system comprising a computer that executes processing for calculating a fund sales commission paid to a fund sales company when a customer purchases a fund,
As order data for buying and selling funds by customers, customer identification information about the customers who bought and sold the funds, fund identification information about the funds to be bought and sold, buying and selling classification data indicating whether selling and buying, and amount data or number data Order acceptance processing means for executing processing for accepting input,
Order data storage means for storing the fund identification information received by the order reception processing means, the trade classification data, and the amount data or the number data in association with the customer identification information;
Balance data storage means for storing balance data of a fund held by a customer in association with the fund identification information and the customer identification information;
At the time of contract processing of the order data stored in the order data storage means, a correspondence relationship between the fund identification information for each fund and the group identification information for the fund group to which each fund belongs is defined in the group table storage means Using the group table stored or described in the program, the group identification information corresponding to the fund identification information included in the order data to be processed stored in the order data storage means is extracted, The order data to be processed including the order data to be processed and the customer identification information are the same, and the group identification information corresponding to the fund identification information belongs to the same fund group by the same customer Orders with specified amount for each order data of each fund's buying and selling In the case, from the total amount data of the buy that is the sum of the amount data when the buy / sell category data is data indicating buy, the total of the sum that is the sum of amount data when the buy / sell category data is data indicating sell Calculate the deducted amount data obtained by subtracting the amount data, and add the calculated deducted amount data and the total amount data of the balance data of the previous day of all the funds belonging to the fund group of the customer stored in the balance data storage means To calculate the fixed sales commission rate determining amount data relating to the order data to be processed, or, in the case of an order for which the number is specified, the number data when the trading classification data is data indicating buying From the total number data of buys totaled, the total number of units sold in the case where the trading category data is data indicating sales From the reference price storage means for calculating the subtraction data obtained by subtracting the total number of data for each fund and storing the reference price data of each fund in association with the fund identification information, the fund identification information for each fund is used as a key. The basic price data of the previous day of each fund is extracted, and the calculated amount data of each fund is multiplied by the extracted basic price data of the previous day of each fund to calculate the deducted amount data of each fund. By adding the calculated total amount data of the deduction amount data of each fund and the total amount data of the balance data of the previous day of all funds belonging to the fund group of the customer stored in the balance data storage means , Processing for calculating fixed sales commission rate determination amount data relating to the order data to be processed An amount calculation processing means for determining a fixed sales commission rate,
Based on the fixed sales commission rate determination amount data related to the processing target order data calculated by the fixed sales commission rate determination amount calculation processing means, the relationship between the purchase price of the fund and the sales commission rate is determined to determine the sales commission. It belongs to the fund group of the customer stored in the order data storage means including the order data to be processed using the sales commission rate table stored in the rate table storage means or described in the program A fixed sales commission rate determination processing means for executing a process for determining fixed sales commission rate data to be commonly applied to each order data of buying of each fund;
With respect to the order data to be processed stored in the order data storage means, in the case of an order for which the amount is designated, the amount data when the trade classification data is data indicating buying, and the determination of the fixed sales commission rate Using the fixed sales commission rate data determined by the processing means, or in the case of order specifying the quantity, the quantity data when the trade classification data is data indicating buying, the reference price storage means or the order data Final sale for the contracted purchase order to be processed, using the reference price data for the contract date stored in the storage means and the final sales commission rate data determined by the final sales commission rate determination processing means A sales commission calculation process characterized by comprising a fixed sales commission calculation processing means for executing a process for calculating commission data. Management system. Group table storage means for storing a group table for defining a correspondence relationship between fund identification information for each fund and group identification information for the fund group to which each fund belongs;
Send display data of a group designation screen for inputting and designating a correspondence relationship between the fund identification information and the group identification information to a sales company terminal device operated by a person in charge of the fund sales company via a communication line. And a group designation for executing a process of storing the fund identification information transmitted from the sales company terminal device via the communication line and the group identification information corresponding to the fund identification information in association with each other in the group table storage means The sales fee calculation processing system according to claim 1, further comprising: processing means. During the order data reception process by the order reception processing means, the current order data received and the fund related to the current order by the same customer who has placed the current order stored in the order data storage means, For each order data of other trades that have already been placed before the contract of each fund belonging to the same fund group, in the case of an order for which the amount is specified, the sum of the amount data when the trade classification data is data indicating buying The deduction amount data obtained by subtracting the total amount data of the sale, which is the sum of the amount data when the trade classification data is data indicating the sale, is calculated from the total amount data of the purchased purchase, and the calculated deduction amount data and the balance data Total amount data of balance data on the previous day of all funds belonging to the fund group of the customer stored in the storage means To calculate the amount data for determining the approximate sales commission rate related to the current order data, or, in the case of an order with a specified number of units, when the trading division data is data indicating buying For each fund, subtracted data is calculated for each fund by subtracting the total data of the sales, which is the sum of the unit data when the trading classification data is data indicating the sale, from the total unit data of the total of unit data. The reference price data of the previous day of each fund is extracted from the reference price storage means for storing the reference price data of the fund in association with the fund identification information, using the fund identification information for each fund as a key, and the calculated each fund Subtract each fund's subtraction by multiplying the base price data of the previous day of each fund extracted by Calculating the amount data, the total amount data of the calculated deduction amount data of each fund and the total amount data of the balance data of the previous day of all the funds belonging to the fund group of the customer stored in the balance data storage means; Approximate sales fee rate determination amount calculation processing means for executing provisional calculation of the approximate sales fee rate determination amount data relating to the current order data by adding
Based on the approximate sales commission rate determination amount data related to the current order data temporarily calculated by the approximate sales commission rate determination amount calculation processing means, stored in the sales commission rate table storage means or described in the program In the case of buying accepted by the order acceptance processing means using the sales commission rate table, the current order data and other purchase orders already placed before the trade stored in the order data storage means Approximate sales commission rate determination processing means for executing provisional determination of approximate sales commission rate data that is commonly applied to each order data;
The current order data received by the order reception processing means, or each order data of other trades that have already been placed before the contract stored in the order data storage means in addition to the current order data In the case of a specified order, use the amount data when the trading classification data is data indicating buying and the approximate sales commission rate data provisionally determined by the approximate sales commission rate determination processing means, or specify the number of units In the case of an order, the number data when the trade classification data is data indicating buying, the base price data of the previous day stored in the base price storage means, and the provisional decision by the approximate sales commission rate determination processing means Using the estimated sales commission rate data, the estimated sales commission data related to the current order when buying, or the current time when buying And estimated sales commission calculation processing means for executing the processing of temporary calculated the approximate sales commission data according to each order of the other buying commitments before the existing order in addition to the estimated sales commission data according to the order,
The approximate sales commission rate data provisionally calculated by the approximate sales commission calculation processing means, or the approximate sales commission rate data provisionally determined by the approximate sales commission rate determination processing means in addition to the approximate sales commission data, The sales commission calculation processing system according to claim 1, further comprising: an approximate sales commission display processing unit that executes a process of displaying on the screen of the terminal device to which the input has been made. A sales commission calculation processing system comprising a computer that executes processing for calculating a fund sales commission paid to a fund sales company when a customer purchases a fund,
As order data for buying and selling funds by customers, customer identification information about the customers who bought and sold the funds, fund identification information about the funds to be bought and sold, buying and selling classification data indicating whether selling and buying, and amount data or number data Order acceptance processing means for executing processing for accepting input,
Order data storage means for storing the fund identification information received by the order reception processing means, the trade classification data, and the amount data or the number data in association with the customer identification information;
Balance data storage means for storing balance data of a fund held by a customer in association with the fund identification information and the customer identification information;
At the time of execution of the order data stored in the order data storage means, the order identification data stored in the order data storage means and the customer identification information are the same, and the fund identification information is the same. For each order data for buying and selling the same fund by the same customer, in the case of an order for which the amount is specified, from the total amount data of buying that sums the amount data when the buying and selling classification data is data indicating buying In the case where the transaction classification data is data indicating sale, the deduction amount data is calculated by subtracting the total amount data of selling by summing the amount data, and the calculated deduction amount data and the balance data storage means store the amount data For determining the fixed sales commission rate related to the order data to be processed by adding the balance data of the previous day of the customer's fund In the case of an order for which amount data is calculated or the number of units is specified, the buy / sell category data indicates sell from the total buy unit data obtained by summing the buy / sell data when the buy / sell category data is data indicating buy. From the reference price storage means for calculating the subtraction data obtained by subtracting the total sales data of the sales, which is the total of the sales data, and storing the reference price data of each fund in association with the fund identification information, Using the fund identification information as a key, extract the basic price data of the previous day of the fund, multiply the calculated subtraction data by the extracted basic price data of the previous day of the fund, and calculate the deduction amount data. Add the amount data and the balance data of the previous day of the fund of the customer stored in the balance data storage means And by a definite sales commission rate determination amount calculation processing means for executing a process of calculating a definite sales commission rate determined for the amount data in accordance with the order data of the processing target,
Based on the fixed sales commission rate determination amount data related to the processing target order data calculated by the fixed sales commission rate determination amount calculation processing means, the relationship between the purchase price of the fund and the sales commission rate is determined to determine the sales commission. Using the sales commission rate table stored in the rate table storage means or described in the program, the contract of the fund of the customer stored in the order data storage means including the order data to be processed A fixed sales commission rate determination processing means for executing a process for determining fixed sales commission rate data commonly applied to each order data of buying;
With respect to the order data to be processed stored in the order data storage means, in the case of an order for which the amount is designated, the amount data when the trade classification data is data indicating buying, and the determination of the fixed sales commission rate Using the fixed sales commission rate data determined by the processing means, or in the case of order specifying the quantity, the quantity data when the trade classification data is data indicating buying, the reference price storage means or the order data Final sale for the contracted purchase order to be processed, using the reference price data for the contract date stored in the storage means and the final sales commission rate data determined by the final sales commission rate determination processing means A sales commission calculation process characterized by comprising a fixed sales commission calculation processing means for executing a process for calculating commission data. Management system. During the order data reception process by the order reception processing means, the current order data received and the fund related to the current order by the same customer who has placed the current order stored in the order data storage means, For the order data of other trades that have already been placed before the contract for the same fund, in the case of an order for which the amount is specified, the total amount data of the buy that is the sum of the amount data when the trade classification data is data indicating buy From the above, the deduction amount data obtained by subtracting the total amount data of the sale, which is the sum of the amount data when the trading classification data is data indicating sale, is calculated and stored in the calculated balance amount data and the balance data storage means By adding the balance data on the previous day of the fund of the customer, a money for determining the approximate sales commission rate related to the current order data In the case of an order for which data is provisionally calculated or the number of units is specified, the buy / sell category data indicates sell from the total buy unit data obtained by summing up the buy / sell data when the buy / sell category data is data indicating buy. From the reference price storage means for calculating the subtraction data obtained by subtracting the total sales data of the sales, which is the total of the sales data, and storing the reference price data of each fund in association with the fund identification information, Using the fund identification information as a key, extract the basic price data of the previous day of the fund, multiply the calculated subtraction data by the extracted basic price data of the previous day of the fund, and calculate the deduction amount data. Add the amount data and the balance data of the previous day of the fund of the customer stored in the balance data storage means And by, and the estimated sales commission rate determined for the amount of money calculation processing means for executing the processing of temporary calculated the estimated sales commission rate determined for the amount of money data of the to this time of the order data,
Based on the approximate sales commission rate determination amount data related to the current order data temporarily calculated by the approximate sales commission rate determination amount calculation processing means, stored in the sales commission rate table storage means or described in the program In the case of buying accepted by the order acceptance processing means using the sales commission rate table, the current order data and other purchase orders already placed before the trade stored in the order data storage means Approximate sales commission rate determination processing means for executing provisional determination of approximate sales commission rate data that is commonly applied to each order data;
The current order data received by the order reception processing means, or each order data of other trades that have already been placed before the contract stored in the order data storage means in addition to the current order data In the case of a specified order, use the amount data when the trading classification data is data indicating buying and the approximate sales commission rate data provisionally determined by the approximate sales commission rate determination processing means, or specify the number of units In the case of an order, the number data when the trade classification data is data indicating buying, the base price data of the previous day stored in the base price storage means, and the provisional decision by the approximate sales commission rate determination processing means Using the estimated sales commission rate data, the estimated sales commission data related to the current order when buying, or the current time when buying And estimated sales commission calculation processing means for executing the processing of temporary calculated the approximate sales commission data according to each order of the other buying commitments before the existing order in addition to the estimated sales commission data according to the order,
The estimated sales commission data temporarily calculated by the approximate sales commission calculation processing means, or the approximate sales commission rate data provisionally determined by the approximate sales commission rate determination processing means in addition to the approximate sales commission data, The sales commission calculation processing system according to claim 4, further comprising: approximate sales commission display processing means for executing processing to display on the screen of the terminal device to which the input has been made. A sales commission calculation processing system comprising a computer that executes processing for calculating a fund sales commission paid to a fund sales company when a customer purchases a fund,
Specific fund storage means for storing fund identification information for a plurality of funds designated by a customer as a specific fund for which the sales commission is advantageous to the customer in association with customer identification information for the customer who designates the specific fund When,
The display data of the specific fund designation screen for designating the specific fund by the customer is transmitted to the customer terminal device operated by the customer via the communication line, and transmitted from the customer terminal device via the communication line. Specific fund registration processing means for executing processing for storing the fund identification information for the plurality of specific funds designated by the coming customer in association with the customer identification information in the specific fund storage means;
As order data for buying and selling funds by customers, customer identification information about the customers who bought and sold the funds, fund identification information about the funds to be bought and sold, buying and selling classification data indicating whether selling and buying, and amount data or number data Order acceptance processing means for executing processing for accepting input,
Order data storage means for storing the fund identification information received by the order reception processing means, the trade classification data, and the amount data or the number data in association with the customer identification information;
Balance data storage means for storing balance data of a fund held by a customer in association with the fund identification information and the customer identification information;
When the order data stored in the order data storage means is executed, the specific fund storage means is referred to using the customer identification information included in the order data to be processed stored in the order data storage means as a key. And determining whether the fund identification information included in the order data is fund identification information for the specific fund of the customer stored in the specific fund storage means, and the order data to be processed and the For each order data of the contracts traded by each specific fund by the same customer that has the same customer identification information and includes fund identification information for any one of the said customer's specific funds, In this case, the total amount data of the purchase is the sum of the amount data when the trade classification data is data indicating purchase. From the data, the deduction amount data is calculated by subtracting the total amount data of the sale, which is the sum of the amount data when the trade classification data is data indicating sale, and is calculated and stored in the balance data storage means. Further, by adding the total amount data of the balance data on the previous day for all the specific funds of the customer, the amount data for determining the fixed sales commission rate related to the order data to be processed is calculated, or the number of units specified In the case of an order, from the total number data of buys obtained by summing up the number data when the trade classification data is data indicating buy, the sales obtained by adding the number data when the trade classification data is data indicating sell. For each specific fund, subtracted unit data is calculated by subtracting the total unit data for each fund, and the reference price data for each fund is related to the fund identification information. From the reference price storage means to be stored, the reference price data of the previous day of each specific fund is extracted using the fund identification information for each specific fund as a key, and extracted to the calculated subtraction number data of each specific fund The amount data for each specific fund is calculated by multiplying the reference price data for each specific fund on the previous day, and the calculated total amount data of the amount data for each specific fund is stored in the balance data storage means. In addition, the final sales for executing the processing for calculating the final sales commission rate determination amount data related to the processing target order data by adding the total amount data of the balance data on the previous day for all the specific funds of the customer An amount calculation processing means for determining a commission rate;
Based on the fixed sales commission rate determination amount data related to the processing target order data calculated by the fixed sales commission rate determination amount calculation processing means, the relationship between the purchase price of the fund and the sales commission rate is determined to determine the sales commission. Using the sales commission rate table stored in the rate table storage means or described in the program, the customer's each specific fund of the customer stored in the order data storage means including the order data to be processed A fixed sales commission rate determination processing means for executing a process for determining fixed sales commission rate data to be commonly applied to each order data of promised purchases;
With respect to the order data to be processed stored in the order data storage means, in the case of an order for which the amount is designated, the amount data when the trade classification data is data indicating buying, and the determination of the fixed sales commission rate Using the fixed sales commission rate data determined by the processing means, or in the case of order specifying the quantity, the quantity data when the trade classification data is data indicating buying, the reference price storage means or the order data Final sale for the contracted purchase order to be processed, using the reference price data for the contract date stored in the storage means and the final sales commission rate data determined by the final sales commission rate determination processing means A sales commission calculation process characterized by comprising a fixed sales commission calculation processing means for executing a process for calculating commission data. Management system. Specification of any of the customers by the same customer as the customer who has placed the current order data stored in the order data storage unit and the current order data received during the order data reception process by the order reception processing unit For each order data of other trades that have already been placed before the fund's contract, in the case of an order for which the amount is specified, from the total amount data of the buy that is the sum of the amount data when the trade classification data is data indicating buy In the case where the transaction classification data is data indicating sale, the deduction amount data is calculated by subtracting the total amount data of selling by summing the amount data, and the calculated deduction amount data and the balance data storage means store the amount data By adding the total amount data of the balance data of the previous day for all the specific funds of the customer, the rough estimate related to the current order data In the case of a provisional calculation of the selling fee rate determination amount data, or in the case of an order with a specified number of units, from the total number data of buying that is obtained by adding the number of units data when the buying and selling classification data is data indicating buying, When the category data is data indicating selling, the number of subtracted data obtained by subtracting the total number of units sold is calculated for each specific fund, and the reference price data of each fund is stored in association with the fund identification information. From the reference price storage means, using the fund identification information for each specific fund as a key, the reference price data of the previous day of each specific fund is extracted, and the calculated each subtraction data of each specific fund Calculate the difference amount data for each specific fund by multiplying the base price data for the previous day of the specific fund, respectively. By adding the total amount data of the amount data and the total amount data of the balance data on the previous day for all of the specific funds of the customer stored in the balance data storage means, the approximate sales commission related to the current order data An approximate sales commission rate determination amount calculation processing means for executing a process of temporarily calculating rate determination amount data;
Based on the approximate sales commission rate determination amount data related to the current order data temporarily calculated by the approximate sales commission rate determination amount calculation processing means, stored in the sales commission rate table storage means or described in the program In the case of buying accepted by the order acceptance processing means using the sales commission rate table, the current order data and other purchase orders already placed before the trade stored in the order data storage means Approximate sales commission rate determination processing means for executing provisional determination of approximate sales commission rate data that is commonly applied to each order data;
The current order data received by the order reception processing means, or each order data of other trades that have already been placed before the contract stored in the order data storage means in addition to the current order data In the case of a specified order, use the amount data when the trading classification data is data indicating buying and the approximate sales commission rate data provisionally determined by the approximate sales commission rate determination processing means, or specify the number of units In the case of an order, the number data when the trade classification data is data indicating buying, the base price data of the previous day stored in the base price storage means, and the provisional decision by the approximate sales commission rate determination processing means Using the estimated sales commission rate data, the estimated sales commission data related to the current order when buying, or the current time when buying And estimated sales commission calculation processing means for executing the processing of temporary calculated the approximate sales commission data according to each order of the other buying commitments before the existing order in addition to the estimated sales commission data according to the order,
The estimated sales commission data temporarily calculated by the approximate sales commission calculation processing means, or the approximate sales commission rate data provisionally determined by the approximate sales commission rate determination processing means in addition to the approximate sales commission data, The sales commission calculation processing system according to claim 6, further comprising: approximate sales commission display processing means for executing processing for displaying on the screen of the terminal device to which the input has been made. A sales commission calculation processing system comprising a computer that executes processing for calculating a fund sales commission paid to a fund sales company when a customer purchases a fund,
A specific fund storage that stores fund identification information for at least one fund designated by a customer as a specific fund for which the sales commission is advantageous to the customer in association with customer identification information for the customer who designates the specific fund Means,
The display data of the specific fund designation screen for designating the specific fund by the customer is transmitted to the customer terminal device operated by the customer via the communication line, and transmitted from the customer terminal device via the communication line. Specific fund registration processing means for executing a process of storing fund identification information about at least one specific fund designated by an incoming customer in association with the customer identification information in the specific fund storage means;
As order data for buying and selling funds by customers, customer identification information about the customers who bought and sold the funds, fund identification information about the funds to be bought and sold, buying and selling classification data indicating whether selling and buying, and amount data or number data Order acceptance processing means for executing processing for accepting input,
Order data storage means for storing the fund identification information received by the order reception processing means, the trade classification data, and the amount data or the number data in association with the customer identification information;
Balance data storage means for storing balance data of a fund held by a customer in association with the fund identification information and the customer identification information;
When the order data stored in the order data storage means is executed, the specific fund storage means is referred to using the customer identification information included in the order data to be processed stored in the order data storage means as a key. And determining whether or not the fund identification information included in the order data to be processed is fund identification information for the specific fund of the customer stored in the specific fund storage means. In the case of an order for which the amount is specified with respect to each order data of the trade of the same specific fund by the same customer with the same data and the customer identification information and the same fund identification information for the specific fund, , From the total amount data of the buy that is the sum of the amount data when the trade classification data is data indicating buy Calculates the deduction amount data by subtracting the total amount data of the sale, which is the sum of the amount data when the trade classification data is data indicating sale, and calculates the deduction amount data and the customer stored in the balance data storage means By adding the balance data of the specific fund on the previous day to calculate the fixed sales commission rate determining amount data relating to the order data to be processed, The number of subtracted units obtained by subtracting the total number of units sold by adding the number of units of data when the above-mentioned trading division data is data indicating the sale from the total number of units of the unit of purchases when the data is data indicating buy. The reference price storage means for calculating the data and storing the reference price data of each fund in association with the fund identification information The basic price data of the specific fund the previous day is extracted using the fund identification information for the fund as a key, and the deduction amount data is calculated by multiplying the calculated balance unit data by the extracted basic price data of the specific fund the previous day Then, by adding the calculated deduction amount data and the balance data of the customer's previous day stored in the balance data storage means, an amount for determining the fixed sales commission rate related to the order data to be processed A fixed sales commission rate determination amount calculation processing means for executing a process of calculating data;
Based on the fixed sales commission rate determination amount data related to the processing target order data calculated by the fixed sales commission rate determination amount calculation processing means, the relationship between the purchase price of the fund and the sales commission rate is determined to determine the sales commission. Using the sales commission rate table stored in the rate table storage means or described in the program, the contract of the specific fund of the customer stored in the order data storage means including the order data to be processed Fixed sales commission rate determination processing means for executing a process for determining fixed sales commission rate data that is commonly applied to each order data of purchased purchases;
With respect to the order data to be processed stored in the order data storage means, in the case of an order for which the amount is designated, the amount data when the trade classification data is data indicating buying, and the determination of the fixed sales commission rate Using the fixed sales commission rate data determined by the processing means, or in the case of order specifying the quantity, the quantity data when the trade classification data is data indicating buying, the reference price storage means or the order data Final sale for the contracted purchase order to be processed, using the reference price data for the contract date stored in the storage means and the final sales commission rate data determined by the final sales commission rate determination processing means A sales commission calculation process characterized by comprising a fixed sales commission calculation processing means for executing a process for calculating commission data. Management system. Prior to the execution of the same specific fund by the same customer as the customer who placed the current order data received in the current order data and the current order data stored in the order data storage means during the order data acceptance processing by the order acceptance processing means For each order data of other orders that have already been ordered, in the case of an order with a specified amount, the buy / sell category is obtained from the total amount data of buys obtained by adding up the amount data when the buy / sell category data is data indicating buy. When the data is data indicating sale, the amount data is calculated by subtracting the total amount data of the sale, and the identification of the customer stored in the balance data storage means is calculated. By adding the balance data of the previous day of the fund, the amount data for determining the approximate sales commission rate related to the current order data is provisionally calculated. Or, in the case of an order for which the number of units is specified, from the total number data of buying in which the number of pieces of data is totaled when the buying and selling section data is data indicating buying, and the buying and selling section data is data indicating selling The fund identification information for the specific fund is calculated from the reference price storage means for calculating the subtraction data obtained by subtracting the total sales data of the sales and adding the basic price data of each fund in association with the fund identification information. The key price data on the previous day of the specific fund is extracted using the key as the key, and the calculated amount data is calculated by multiplying the calculated number-of-subtraction data by the base price data on the previous day of the specified fund. The data and the balance data of the customer's previous day for the specific fund stored in the balance data storage means are added. And by, and the estimated sales commission rate determined for the amount of money calculation processing means for executing the processing of temporary calculated the estimated sales commission rate determined for the amount of money data of the to this time of the order data,
Based on the approximate sales commission rate determination amount data related to the current order data temporarily calculated by the approximate sales commission rate determination amount calculation processing means, stored in the sales commission rate table storage means or described in the program In the case of buying accepted by the order acceptance processing means using the sales commission rate table, the current order data and other purchase orders already placed before the trade stored in the order data storage means Approximate sales commission rate determination processing means for executing provisional determination of approximate sales commission rate data that is commonly applied to each order data;
The current order data received by the order reception processing means, or each order data of other trades that have already been placed before the contract stored in the order data storage means in addition to the current order data In the case of a specified order, use the amount data when the trading classification data is data indicating buying and the approximate sales commission rate data provisionally determined by the approximate sales commission rate determination processing means, or specify the number of units In the case of an order, the number data when the trade classification data is data indicating buying, the base price data of the previous day stored in the base price storage means, and the provisional decision by the approximate sales commission rate determination processing means Using the estimated sales commission rate data, the estimated sales commission data related to the current order when buying, or the current time when buying And estimated sales commission calculation processing means for executing the processing of temporary calculated the approximate sales commission data according to each order of the other buying commitments before the existing order in addition to the estimated sales commission data according to the order,
The estimated sales commission data temporarily calculated by the approximate sales commission calculation processing means, or the approximate sales commission rate data provisionally determined by the approximate sales commission rate determination processing means in addition to the approximate sales commission data, The sales commission calculation processing system according to claim 8, further comprising: approximate sales commission display processing means for executing processing for displaying on the screen of the terminal device to which the input has been made. A sales commission calculation processing system comprising a computer that executes processing for calculating a fund sales commission paid to a fund sales company when a customer purchases a fund,
As order data for buying and selling funds by customers, customer identification information about the customers who bought and sold the funds, fund identification information about the funds to be bought and sold, buying and selling classification data indicating whether selling and buying, and amount data or number data Order acceptance processing means for executing processing for accepting input,
Order data storage means for storing the fund identification information received by the order reception processing means, the trade classification data, and the amount data or the number data in association with the customer identification information;
Balance data storage means for storing balance data of a fund held by a customer in association with the fund identification information and the customer identification information;
At the time of contract processing of the order data stored in the order data storage means, an order for which the amount is specified for each order data having the same customer identification information as the processing target order data stored in the order data storage means In the case of the above, from the total amount data of buying that sums up the amount data when the buying and selling division data is data indicating buying, the selling amount summing up the amount data when the buying and selling division data is data showing selling Calculate the deducted amount data obtained by subtracting the total amount data for each fund, and calculate the deducted amount data of each fund and the balance data of the previous day of each fund of the customer stored in the balance data storage unit. By adding for each fund, the balance data for each fund held by the customer is calculated. In the case of the order, the total number data of the buys in the case where the trading category data is data indicating buying, the total number data in the case where the trading category data is data indicating selling is totaled from the total number data of buying. Calculate the deductible unit data by subtracting the total number of units sold, for each fund, and store the base price data of each fund in association with the fund identification information. The basic price data of the previous day of each fund is extracted, and the calculated subtraction data of each fund is multiplied by the extracted basic price data of the previous day of each fund, respectively. The calculated amount of the deducted amount data of each fund and the customer's stored in the balance data storage means The balance data for each fund held by the customer is calculated by adding the balance data for the previous day of the fund for each fund, and the amount of the calculated balance data for each fund is greater than or equal to a predetermined rank. If the fund of the fund identification information included in the order data to be processed is the large balance fund, the balance data by fund for the plurality of large balance funds is determined. A summation processing unit for determining the fixed sales commission rate for executing the processing for calculating the data for determining the final sales commission rate relating to the order data to be processed by summing;
Based on the fixed sales commission rate determination amount data related to the processing target order data calculated by the fixed sales commission rate determination amount calculation processing means, the relationship between the purchase price of the fund and the sales commission rate is determined to determine the sales commission. Using the sales commission rate table stored in the rate table storage means or described in the program, the large balance fund of the customer stored in the order data storage means including the order data to be processed A fixed sales commission rate determination processing means for executing a process for determining fixed sales commission rate data to be commonly applied to each order data of promised purchases;
With respect to the order data to be processed stored in the order data storage means, in the case of an order for which the amount is designated, the amount data when the trade classification data is data indicating buying, and the determination of the fixed sales commission rate Using the fixed sales commission rate data determined by the processing means, or in the case of order specifying the quantity, the quantity data when the trade classification data is data indicating buying, the reference price storage means or the order data Final sale for the contracted purchase order to be processed, using the reference price data for the contract date stored in the storage means and the final sales commission rate data determined by the final sales commission rate determination processing means A sales commission calculation process characterized by comprising a fixed sales commission calculation processing means for executing a process for calculating commission data. Management system. During the order data reception process by the order reception processing means, the received order data and the other orders already placed by the same customer as the customer who has placed the current order stored in the order data storage means. For each order data of buying and selling, in the case of an order with a specified amount, the buying and selling section data indicates selling from the total amount data of buying in which the buying and selling section data is data indicating buying. Data is calculated by subtracting the total amount data of the sale, which is the sum of the amount data in the case of data, for each fund, and the calculated amount data for each fund and the customer stored in the balance data storage means By adding the balance data of the previous day of each fund for each fund, the fans of the funds held by the customer In the case of another balance data calculation, or in the case of order specifying the number of units, the trading category data is sold from the total number of units of buying that is obtained by summing the unit number data when the trading category data is data indicating buying. From the reference price storage means that calculates the subtraction data for each fund by subtracting the total sales data of the sales, which is the total of the sales data, and stores the reference price data of each fund in association with the fund identification information The base price data of the previous day of each fund is extracted using the fund identification information for each fund as a key, and the calculated subtraction data of each fund is multiplied by the extracted base price data of the previous day of each fund. The deduction amount data is calculated for each fund, and the calculated deduction amount data and balance data for each fund are calculated. The balance data for each fund held by the customer is calculated by adding the balance data for the day before each fund of the customer stored in the means for each fund, and the calculated balance for each fund When a plurality of large balance funds whose data amount is equal to or higher than a predetermined order are determined and the fund of the fund identification information included in the current order data is the large balance fund, the plurality of large balance funds An approximate sales commission rate determination amount calculation processing means for executing a process of provisionally calculating approximate sales commission rate determination amount data related to the current order data by summing the balance data for each fund for the balance fund;
Based on the approximate sales commission rate determination amount data related to the current order data temporarily calculated by the approximate sales commission rate determination amount calculation processing means, stored in the sales commission rate table storage means or described in the program In the case of buying accepted by the order acceptance processing means using the sales commission rate table, the current order data and other purchase orders already placed before the trade stored in the order data storage means Approximate sales commission rate determination processing means for executing provisional determination of approximate sales commission rate data that is commonly applied to each order data;
The current order data received by the order reception processing means, or each order data of other trades that have already been placed before the contract stored in the order data storage means in addition to the current order data In the case of a specified order, use the amount data when the trading classification data is data indicating buying and the approximate sales commission rate data provisionally determined by the approximate sales commission rate determination processing means, or specify the number of units In the case of an order, the number data when the trade classification data is data indicating buying, the base price data of the previous day stored in the base price storage means, and the provisional decision by the approximate sales commission rate determination processing means Using the estimated sales commission rate data, the estimated sales commission data related to the current order when buying, or the current time when buying And estimated sales commission calculation processing means for executing the processing of temporary calculated the approximate sales commission data according to each order of the other buying commitments before the existing order in addition to the estimated sales commission data according to the order,
The estimated sales commission data temporarily calculated by the approximate sales commission calculation processing means, or the approximate sales commission rate data provisionally determined by the approximate sales commission rate determination processing means in addition to the approximate sales commission data, The sales commission calculation processing system according to claim 10, further comprising: approximate sales commission display processing means for executing processing for displaying on the screen of the terminal device to which the input has been made. A sales commission calculation processing system comprising a computer that executes processing for calculating a fund sales commission paid to a fund sales company when a customer purchases a fund,
As order data for buying and selling funds by customers, customer identification information about the customers who bought and sold the funds, fund identification information about the funds to be bought and sold, buying and selling classification data indicating whether selling and buying, and amount data or number data Order acceptance processing means for executing processing for accepting input,
Order data storage means for storing the fund identification information received by the order reception processing means, the trade classification data, and the amount data or the number data in association with the customer identification information;
Balance data storage means for storing balance data of a fund held by a customer in association with the fund identification information and the customer identification information;
At the time of contract processing of the order data stored in the order data storage means, an order for which the amount is specified for each order data having the same customer identification information as the processing target order data stored in the order data storage means In the case of the above, from the total amount data of buying that sums up the amount data when the buying and selling division data is data indicating buying, the selling amount summing up the amount data when the buying and selling division data is data showing selling Calculate the deducted amount data obtained by subtracting the total amount data for each fund, and calculate the deducted amount data of each fund and the balance data of the previous day of each fund of the customer stored in the balance data storage unit. By adding for each fund, the balance data for each fund held by the customer is calculated. In the case of the order, the total number data of the buys in the case where the trading category data is data indicating buying, the total number data in the case where the trading category data is data indicating selling is totaled from the total number data of buying. Calculate the deductible unit data by subtracting the total number of units sold, for each fund, and store the base price data of each fund in association with the fund identification information. The basic price data of the previous day of each fund is extracted, and the calculated amount data of each fund is multiplied by the extracted basic price data of the previous day of each fund to calculate the difference amount data for each fund. The calculated fan deduction amount data and the respective fan of the customer stored in the balance data storage means The balance data for each fund held by the customer is calculated by adding the balance data of the previous day for each fund, and the amount of the calculated balance data for each fund is equal to or higher than a predetermined rank. When a plurality of large balance funds are determined and the fund of the fund identification information included in the order data to be processed is the large balance fund, the balance data by fund for the large balance fund is the processing target A fixed sales commission rate determination amount calculation processing means for executing a process for determining the fixed sales commission rate determination amount data related to the order data;
Based on the fixed sales commission rate determination amount data related to the processing target order data calculated by the fixed sales commission rate determination amount calculation processing means, the relationship between the purchase price of the fund and the sales commission rate is determined to determine the sales commission. Using the sales commission rate table stored in the rate table storage means or described in the program, the large balance fund of the customer stored in the order data storage means including the order data to be processed A fixed sales commission rate determination processing means for executing a process for determining fixed sales commission rate data to be commonly applied to each order data of promised purchases;
With respect to the order data to be processed stored in the order data storage means, in the case of an order for which the amount is designated, the amount data when the trade classification data is data indicating buying, and the determination of the fixed sales commission rate Using the fixed sales commission rate data determined by the processing means, or in the case of order specifying the quantity, the quantity data when the trade classification data is data indicating buying, the reference price storage means or the order data Final sale for the contracted purchase order to be processed, using the reference price data for the contract date stored in the storage means and the final sales commission rate data determined by the final sales commission rate determination processing means A sales commission calculation process characterized by comprising a fixed sales commission calculation processing means for executing a process for calculating commission data. Management system. During the order data reception process by the order reception processing means, the received order data and the other orders already placed by the same customer as the customer who has placed the current order stored in the order data storage means. For each order data of buying and selling, in the case of an order with a specified amount, the buying and selling section data indicates selling from the total amount data of buying in which the buying and selling section data is data indicating buying. Data is calculated by subtracting the total amount data of the sale, which is the sum of the amount data in the case of data, for each fund, and the calculated amount data for each fund and the customer stored in the balance data storage means By adding the balance data of the previous day of each fund for each fund, the fans of the funds held by the customer In the case of another balance data calculation, or in the case of order specifying the number of units, the trading category data is sold from the total number of units of buying that is obtained by summing the unit number data when the trading category data is data indicating buying. From the reference price storage means that calculates the subtraction data for each fund by subtracting the total sales data of the sales, which is the total of the sales data, and stores the reference price data of each fund in association with the fund identification information The base price data of the previous day of each fund is extracted using the fund identification information for each fund as a key, and the calculated subtraction data of each fund is multiplied by the extracted base price data of the previous day of each fund. The deduction amount data is calculated for each fund, and the calculated deduction amount data and balance data for each fund are calculated. The balance data for each fund held by the customer is calculated by adding the balance data for the day before each fund of the customer stored in the means, and the amount of the calculated balance data for each fund is calculated. When a plurality of large balance funds whose length is equal to or higher than a predetermined order is determined and the fund of the fund identification information included in the current order data is the large balance fund, the balance by fund for the large balance fund Approximate sales fee rate determination amount calculation processing means for executing processing for making the data into the approximate sales fee rate determination amount data relating to the order data of the current time;
Based on the approximate sales commission rate determination amount data related to the current order data temporarily calculated by the approximate sales commission rate determination amount calculation processing means, stored in the sales commission rate table storage means or described in the program In the case of buying accepted by the order acceptance processing means using the sales commission rate table, the current order data and other purchase orders already placed before the trade stored in the order data storage means Approximate sales commission rate determination processing means for executing provisional determination of approximate sales commission rate data that is commonly applied to each order data;
The current order data received by the order reception processing means, or each order data of other trades that have already been placed before the contract stored in the order data storage means in addition to the current order data In the case of a specified order, use the amount data when the trading classification data is data indicating buying and the approximate sales commission rate data provisionally determined by the approximate sales commission rate determination processing means, or specify the number of units In the case of an order, the number data when the trade classification data is data indicating buying, the base price data of the previous day stored in the base price storage means, and the provisional decision by the approximate sales commission rate determination processing means Using the estimated sales commission rate data, the estimated sales commission data related to the current order when buying, or the current time when buying And estimated sales commission calculation processing means for executing the processing of temporary calculated the approximate sales commission data according to each order of the other buying commitments before the existing order in addition to the estimated sales commission data according to the order,
The estimated sales commission data temporarily calculated by the approximate sales commission calculation processing means, or the approximate sales commission rate data provisionally determined by the approximate sales commission rate determination processing means in addition to the approximate sales commission data, The sales commission calculation processing system according to claim 12, further comprising: approximate sales commission display processing means for executing processing for displaying on the screen of the terminal device to which the input has been made. A sales commission calculation processing method executed by a sales commission calculation processing system comprising a computer that executes processing for calculating a fund sales commission paid to a fund sales company when a customer purchases a fund,
Order reception processing means, as order data for buying and selling funds by customers, together with customer identification information for customers who bought and sold funds, fund identification information for funds to be bought and sold, buying and selling classification data indicating the difference between selling and buying, And processing to accept input of monetary amount data or unit data,
The fund identification information received by the order reception processing means, the trade classification data, and the amount data or the number data are stored in the order data storage means in association with the customer identification information,
Store the balance data of the fund held by the customer in the balance data storage means in association with the fund identification information and the customer identification information;
When the order data stored in the order data storage means is processed by the amount calculation processing means for determining the fixed sales commission rate, the fund identification information for each fund and the group identification information for the fund group to which each fund belongs The fund identification information contained in the order data to be processed stored in the order data storage means by using a group table stored in the group table storage means and described in the program. The group identification information corresponding to the fund identification information is extracted, the order identification data to be processed including the order data to be processed is the same as the customer identification information, and the group identification information corresponding to the fund identification information is the same. Of each fund belonging to the same fund group by the same customer For each order data for buying, in the case of an order for which the amount is specified, the data indicating that the buying and selling classification data indicates selling from the total amount data of buying when the buying and selling classification data is data indicating buying. If the total amount data of the sale is subtracted from the total amount data of the sale, the calculated amount data and all the funds belonging to the fund group of the customer stored in the balance data storage means are calculated. By adding the total amount data of the balance data of the previous day, the amount data for determining the fixed sales commission rate related to the order data to be processed is calculated. When the data is data indicating buy, the buy / sell classification data indicates sell from the total number data of buys obtained by adding the number data. From the reference price storage means that calculates the subtraction data, which is obtained by subtracting the total data of the sales, which is the total of the data of the sales in the case of data, for each fund, and stores the reference price data of each fund in association with the fund identification information, Using the fund identification information for each fund as a key, the base price data of the previous day of each fund is extracted, and the calculated subtraction data of each fund is multiplied by the extracted base price data of the previous day of each fund. And calculating the balance amount data of each fund, the total amount data of the calculated balance amount data of each fund, and the balance of the previous day of all funds belonging to the fund group of the customer stored in the balance data storage means Confirmation of the order data to be processed by adding the total amount data of the data Execute processing to calculate sales commission rate amount data,
Based on the fixed sales commission rate determination amount data related to the processing target order data calculated by the fixed sales commission rate determination amount calculation processing means by the fixed sales commission rate determination processing means, the fund purchase amount and the sales fee Stored in the sales commission rate table storage means by defining the relationship with the rate or stored in the order data storage means including the order data to be processed using the sales commission rate table described in the program Executing a process for determining fixed sales commission rate data that is commonly applied to each order data of buying of each fund belonging to the fund group of the customer,
When the fixed sales commission calculation processing means is the order for which the amount is specified for the order data to be processed stored in the order data storage means, the amount data when the trade classification data is data indicating buying , And in the case of an order with a specified number using the fixed sales fee rate data determined by the fixed sales fee rate determination processing means, or in the case of an order with a specified number, the number data when the trade classification data is data indicating buying, The contract to be processed using the reference price data stored in the reference price storage means or the order data storage means, and the final sales commission rate data determined by the final sales commission rate determination processing means. Sales commission calculation processing method, characterized in that it executes a process for calculating final sales commission data related to a purchased order. . A sales commission calculation processing method executed by a sales commission calculation processing system comprising a computer that executes processing for calculating a fund sales commission paid to a fund sales company when a customer purchases a fund,
Order reception processing means, as order data for buying and selling funds by customers, together with customer identification information for customers who bought and sold funds, fund identification information for funds to be bought and sold, buying and selling classification data indicating the difference between selling and buying, And processing to accept input of monetary amount data or unit data,
The fund identification information received by the order reception processing means, the trade classification data, and the amount data or the number data are stored in the order data storage means in association with the customer identification information,
Store the balance data of the fund held by the customer in the balance data storage means in association with the fund identification information and the customer identification information;
When the order data stored in the order data storage means is processed by the final sales commission rate determination amount calculation processing means, the order data to be processed and the customer identification information stored in the order data storage means Are the same and the order information for buying and selling the same fund by the same customer with the same fund identification information, in the case of an order with a specified amount, the buying and selling classification data is data indicating buying The deduction amount data is calculated by subtracting the deduction amount data obtained by subtracting the total amount data of the sale, which is the sum of the amount data in the case where the buy / sell classification data is data indicating the sale, from the total amount data of the purchase of the total amount data of By adding the data and the balance data of the previous day of the fund stored in the balance data storage means, the processing pair Calculate the final sales commission rate amount data related to the order data, or, in the case of an order with a specified number of units, the total number of units bought by summing the unit data when the trade classification data is data indicating buy From the data, subtracted data is calculated by subtracting the total number of units sold by adding the number of units when the trading classification data is data indicating selling, and the reference price data of each fund is stored in association with the fund identification information. From the reference price storage means, using the fund identification information about the fund as a key, the reference price data of the previous day of the fund is extracted, and the calculated number-of-subtraction data is multiplied by the extracted reference price data of the previous day of the fund. To calculate the deduction amount data, and the calculated deduction amount data and the customer data stored in the balance data storage means By adding the previous day's balance data of the serial Fund, it executes the process of calculating the fixed sales commission rate determined for the amount of money data according to the order data of the processing target,
Based on the fixed sales commission rate determination amount data related to the processing target order data calculated by the fixed sales commission rate determination amount calculation processing means by the fixed sales commission rate determination processing means, the fund purchase amount and the sales fee Stored in the sales commission rate table storage means by defining the relationship with the rate or stored in the order data storage means including the order data to be processed using the sales commission rate table described in the program Executing a process for determining fixed sales commission rate data that is commonly applied to each order data of the promised buy of the fund of the customer,
When the fixed sales commission calculation processing means is the order for which the amount is specified for the order data to be processed stored in the order data storage means, the amount data when the trade classification data is data indicating buying , And in the case of an order with a specified number using the fixed sales fee rate data determined by the fixed sales fee rate determination processing means, or in the case of an order with a specified number, the number data when the trade classification data is data indicating buying, The contract to be processed using the reference price data stored in the reference price storage means or the order data storage means, and the final sales commission rate data determined by the final sales commission rate determination processing means. Sales commission calculation processing method, characterized in that it executes a process for calculating final sales commission data related to a purchased order. . A sales commission calculation processing method executed by a sales commission calculation processing system comprising a computer that executes processing for calculating a fund sales commission paid to a fund sales company when a customer purchases a fund,
The fund identification information for a plurality of funds designated by the customer as a specific fund for which the sales commission is advantageous to the customer is stored in the specific fund storage means in association with the customer identification information for the customer who has designated the specific fund. And
The specific fund registration processing means transmits display data of a specific fund designation screen for the customer to designate the specific fund to a customer terminal device operated by the customer via a communication line, and from the customer terminal device Performing a process of storing the fund identification information for the plurality of specific funds designated by the customer transmitted via the communication line in the specific fund storage means in association with the customer identification information;
Order reception processing means, as order data for buying and selling funds by customers, together with customer identification information for customers who bought and sold funds, fund identification information for funds to be bought and sold, buying and selling classification data indicating the difference between selling and buying, And processing to accept input of monetary amount data or unit data,
The fund identification information received by the order reception processing means, the trade classification data, and the amount data or the number data are stored in the order data storage means in association with the customer identification information,
Store the balance data of the fund held by the customer in the balance data storage means in association with the fund identification information and the customer identification information;
The customer included in the order data to be processed stored in the order data storage means, when the final sales commission rate determination amount calculation processing means executes the contract processing of the order data stored in the order data storage means Whether or not the specific fund storage means is referred to using the identification information as a key, and the fund identification information included in the order data is fund identification information for the specific fund of the customer stored in the specific fund storage means And the execution of each specific fund by the same customer that includes the order identification data to be processed and the customer identification information, and includes the fund identification information for any one of the specific funds of the customer. For each order data for buying and selling, in the case of an order with a specified amount, the buying and selling classification data is data indicating buying. The deduction amount data is calculated by subtracting the total amount data of the sale, which is the sum of the amount data when the trade classification data is the data indicating the sale, from the total amount data of the purchase which is the sum of the total amount data. For determining the fixed sales commission rate related to the order data to be processed by adding the amount data and the total amount data of the balance data of all the specific funds of the customer the previous day stored in the balance data storage means In the case of order for which amount data is calculated or the number of units is specified, the buy / sell category data indicates sell from the total buy unit data obtained by summing up the buy / sell data when the buy / sell category data is data indicating buy. For each specific fund, subtracted data is calculated for each specific fund by subtracting the total number of units sold. From the reference price storage means that stores the reference price data of the specific fund in association with the fund identification information, the reference price data of the previous day of each specific fund is extracted and calculated using the fund identification information for each specific fund as a key. Calculate the deduction amount data for each specific fund by multiplying the number of deductions for each specific fund by the base price data of the previous day for each specific fund extracted, and the total amount of the deduction amount data for each specific fund calculated By adding the data and the total amount data of the balance data of the previous day of all the specific funds of the customer stored in the balance data storage means, an amount for determining the fixed sales commission rate related to the order data to be processed Execute the process to calculate the data,
Based on the fixed sales commission rate determination amount data related to the processing target order data calculated by the fixed sales commission rate determination amount calculation processing means by the fixed sales commission rate determination processing means, the fund purchase amount and the sales fee Stored in the sales commission rate table storage means by defining the relationship with the rate or stored in the order data storage means including the order data to be processed using the sales commission rate table described in the program Executing a process for determining fixed sales commission rate data that is commonly applied to each order data of promised purchases of each of the specific funds of the customer,
When the fixed sales commission calculation processing means is the order for which the amount is specified for the order data to be processed stored in the order data storage means, the amount data when the trade classification data is data indicating buying , And in the case of an order with a specified number using the fixed sales fee rate data determined by the fixed sales fee rate determination processing means, or in the case of an order with a specified number, the number data when the trade classification data is data indicating buying, The contract to be processed using the reference price data stored in the reference price storage means or the order data storage means, and the final sales commission rate data determined by the final sales commission rate determination processing means. Sales commission calculation processing method, characterized in that it executes a process for calculating final sales commission data related to a purchased order. . A sales commission calculation processing method executed by a sales commission calculation processing system comprising a computer that executes processing for calculating a fund sales commission paid to a fund sales company when a customer purchases a fund,
The fund identification information for at least one fund designated by the customer as a specific fund for which the sales commission is advantageous to the customer is associated with the customer identification information for the customer who designates the specific fund in the specific fund storage means. Remember,
The specific fund registration processing means transmits display data of a specific fund designation screen for the customer to designate the specific fund to a customer terminal device operated by the customer via a communication line, and from the customer terminal device Executing a process of storing, in the specific fund storage means, fund identification information about at least one specific fund designated by a customer transmitted via a communication line in association with the customer identification information;
Order reception processing means, as order data for buying and selling funds by customers, together with customer identification information for customers who bought and sold funds, fund identification information for funds to be bought and sold, buying and selling classification data indicating the difference between selling and buying, And processing to accept input of monetary amount data or unit data,
The fund identification information received by the order reception processing means, the trade classification data, and the amount data or the number data are stored in the order data storage means in association with the customer identification information,
Store the balance data of the fund held by the customer in the balance data storage means in association with the fund identification information and the customer identification information;
The customer included in the order data to be processed stored in the order data storage means, when the final sales commission rate determination amount calculation processing means executes the contract processing of the order data stored in the order data storage means The specific fund storage means is referred to using the identification information as a key, and the fund identification information included in the order data to be processed is the fund identification information for the specific fund of the customer stored in the specific fund storage means. Whether the order data to be processed and the customer identification information are the same, and each of the promised buying and selling of the same specific fund by the same customer with the same fund identification information for the specific fund As for order data, in the case of an order for which the amount is specified, the money when the trade classification data is data indicating buying. Calculate the deduction amount data by subtracting the total amount data of the sale, which is the sum of the amount data when the buy / sell classification data is data indicating the sale, By calculating the balance data stored in the balance data storage means on the previous day of the specific fund of the customer, the fixed sales commission rate determining amount data relating to the processing target order data is calculated, or the number of units In the case of a specified order, from the total number data of buys obtained by totaling the number data when the trade classification data is data indicating buy, the total number data when the trade classification data is data indicating sell is totaled. Calculates the subtracted data by subtracting the total number of sold units, and associates the base price data of each fund with the fund identification information. From the reference price storage means for storing, the fund identification information for the specific fund is extracted as a key, and the reference price data for the previous day of the specific fund is extracted, and the calculated reference number data for the specific fund is extracted to the calculated subtraction number data. Multiply the price data to calculate the deduction amount data, and add the calculated deduction amount data and the balance data of the customer's previous day stored in the balance data storage means, thereby adding the order to be processed Execute the process to calculate the data for determining the fixed sales commission rate related to the data,
Based on the fixed sales commission rate determination amount data related to the processing target order data calculated by the fixed sales commission rate determination amount calculation processing means by the fixed sales commission rate determination processing means, the fund purchase amount and the sales fee Stored in the sales commission rate table storage means by defining the relationship with the rate or stored in the order data storage means including the order data to be processed using the sales commission rate table described in the program Executing a process for determining fixed sales commission rate data that is commonly applied to each order data of promised purchases of the specific fund of the customer,
When the fixed sales commission calculation processing means is the order for which the amount is specified for the order data to be processed stored in the order data storage means, the amount data when the trade classification data is data indicating buying , And in the case of an order with a specified number using the fixed sales fee rate data determined by the fixed sales fee rate determination processing means, or in the case of an order with a specified number, the number data when the trade classification data is data indicating buying, The contract to be processed using the reference price data stored in the reference price storage means or the order data storage means, and the final sales commission rate data determined by the final sales commission rate determination processing means. Sales commission calculation processing method, characterized in that it executes a process for calculating final sales commission data related to a purchased order. . A sales commission calculation processing method executed by a sales commission calculation processing system comprising a computer that executes processing for calculating a fund sales commission paid to a fund sales company when a customer purchases a fund,
Order reception processing means, as order data for buying and selling funds by customers, together with customer identification information for customers who bought and sold funds, fund identification information for funds to be bought and sold, buying and selling classification data indicating the difference between selling and buying, And processing to accept input of monetary amount data or unit data,
The fund identification information received by the order reception processing means, the trade classification data, and the amount data or the number data are stored in the order data storage means in association with the customer identification information,
Store the balance data of the fund held by the customer in the balance data storage means in association with the fund identification information and the customer identification information;
When the order data stored in the order data storage means is processed by the final sales commission rate determination amount calculation processing means, the order data to be processed and the customer identification information stored in the order data storage means For each order data having the same value, in the case of an order with a specified amount, the purchase / sale category data indicates sale from the total amount data of the buys obtained by totaling the amount data when the purchase / sale category data is data indicating buy. Data is calculated by subtracting the total amount data of the sale, which is the sum of the amount data in the case of data, for each fund, and the calculated amount data for each fund and the customer stored in the balance data storage means The balance data of the previous day of each fund is added for each fund, and the fund of each fund held by the customer is added. In the case of an order with a specified number of units, or in the case of an order with a specified number of units, the trading unit data is sold from the total number of units of buying in which the unit number data is totaled when the trading unit data is data indicating buying. The reference price storage means for calculating, for each fund, subtracting unit data obtained by subtracting the total number of units sold by adding the unit number data, and storing the base price data of each fund in association with the fund identification information From the fund identification information for each fund as a key, the base price data of the previous day of each fund is extracted, and the calculated base price data of the previous day of each fund is included in the calculated subtraction number data of each fund. Multiply each to calculate the deduction amount data for each fund, and calculate the deduction amount data for each fund and the remaining amount. The balance data for each fund held by the customer is calculated by adding the balance data for the day before each fund of the customer stored in the data storage means for each fund, and the calculated fund When determining a plurality of large balance funds whose amount of the amount of the other balance data is equal to or higher than a predetermined rank, and the fund of the fund identification information included in the order data to be processed is the large balance fund, By calculating the fund-specific balance data for a plurality of large balance funds, a process for calculating fixed sales commission rate determining amount data relating to the order data to be processed is executed,
Based on the fixed sales commission rate determination amount data related to the processing target order data calculated by the fixed sales commission rate determination amount calculation processing means by the fixed sales commission rate determination processing means, the fund purchase amount and the sales fee Stored in the sales commission rate table storage means by defining the relationship with the rate or stored in the order data storage means including the order data to be processed using the sales commission rate table described in the program Executing a process for determining fixed sales commission rate data that is commonly applied to each order data of promised purchases of the large balance fund of the customer,
When the fixed sales commission calculation processing means is the order for which the amount is specified for the order data to be processed stored in the order data storage means, the amount data when the trade classification data is data indicating buying , And in the case of an order with a specified number using the fixed sales fee rate data determined by the fixed sales fee rate determination processing means, or in the case of an order with a specified number, the number data when the trade classification data is data indicating buying, The contract to be processed using the reference price data stored in the reference price storage means or the order data storage means, and the final sales commission rate data determined by the final sales commission rate determination processing means. Sales commission calculation processing method, characterized in that it executes a process for calculating final sales commission data related to a purchased order. . A sales commission calculation processing method executed by a sales commission calculation processing system comprising a computer that executes processing for calculating a fund sales commission paid to a fund sales company when a customer purchases a fund,
Order reception processing means, as order data for buying and selling funds by customers, together with customer identification information for customers who bought and sold funds, fund identification information for funds to be bought and sold, buying and selling classification data indicating the difference between selling and buying, And processing to accept input of monetary amount data or unit data,
The fund identification information received by the order reception processing means, the trade classification data, and the amount data or the number data are stored in the order data storage means in association with the customer identification information,
Store the balance data of the fund held by the customer in the balance data storage means in association with the fund identification information and the customer identification information;
When the order data stored in the order data storage means is processed by the final sales commission rate determination amount calculation processing means, the order data to be processed and the customer identification information stored in the order data storage means For each order data having the same value, in the case of an order with a specified amount, the purchase / sale category data indicates sale from the total amount data of the buys obtained by totaling the amount data when the purchase / sale category data is data indicating buy. Data is calculated by subtracting the total amount data of the sale, which is the sum of the amount data in the case of data, for each fund, and the calculated amount data for each fund and the customer stored in the balance data storage means The balance data of the previous day of each fund is added for each fund, and the fund of each fund held by the customer is added. In the case of an order with a specified number of units, or in the case of an order with a specified number of units, the trading unit data is sold from the total number of units of buying in which the unit number data is totaled when the trading unit data is data indicating buying. The reference price storage means for calculating, for each fund, subtracting unit data obtained by subtracting the total number of units sold by adding the unit number data, and storing the base price data of each fund in association with the fund identification information From the fund identification information for each fund as a key, the base price data of the previous day of each fund is extracted, and the calculated base price data of the previous day of each fund is included in the calculated subtraction number data of each fund. Multiplying and calculating the deduction amount data for each fund, the calculated deduction amount data and the balance data of each fund The balance data for each fund held by the customer is calculated by adding the balance data for the day before each fund of the customer stored in the storage means for each fund. When a plurality of large balance funds whose amount of balance data amount is equal to or higher than a predetermined order are determined and the fund of the fund identification information included in the order data to be processed is the large balance fund, the large amount The balance data for each fund for the balance fund is processed as a fixed sales commission rate determination amount data related to the order data to be processed,
Based on the fixed sales commission rate determination amount data related to the processing target order data calculated by the fixed sales commission rate determination amount calculation processing means by the fixed sales commission rate determination processing means, the fund purchase amount and the sales fee Stored in the sales commission rate table storage means by defining the relationship with the rate or stored in the order data storage means including the order data to be processed using the sales commission rate table described in the program Executing a process for determining fixed sales commission rate data that is commonly applied to each order data of promised purchases of the large balance fund of the customer,
When the fixed sales commission calculation processing means is the order for which the amount is specified for the order data to be processed stored in the order data storage means, the amount data when the trade classification data is data indicating buying , And in the case of an order with a specified number using the fixed sales fee rate data determined by the fixed sales fee rate determination processing means, or in the case of an order with a specified number, the number data when the trade classification data is data indicating buying, The contract to be processed using the reference price data stored in the reference price storage means or the order data storage means, and the final sales commission rate data determined by the final sales commission rate determination processing means. Sales commission calculation processing method, characterized in that it executes a process for calculating final sales commission data related to a purchased order. .   The program for functioning a computer as a sales commission calculation processing system in any one of Claims 1-13.

Images