JP6119101B2 - Aggregation device, aggregation method, and aggregation system - Google Patents

Description

The present invention relates to a counting device , a counting method, and a counting system .

  As globalization progresses, companies may have branches, factories, subsidiaries, dealers, suppliers, and other locations in multiple regions and countries. In order to perform various types of analysis, it is desired to visualize various situations such as sales results, orders received, and delivery status of products at each base.

JP 2008-181236 A

  As a system that visualizes various situations, for example, a collection server that collects data and an analysis server that performs analysis are provided, and various slip information such as sales results from each base is collected in the collection server, and the collected information Can be configured to perform analysis by transmitting to the analysis server.

  When the collection server stores the slip information generated at each site, a large amount of data is stored. When the collection server transmits this large amount of data to the analysis server, the communication load is large.

  Therefore, it is conceivable that the collection server summarizes the slip information generated at each base and transmits the summarized data to the analysis server. For example, the collection server aggregates sales slip information for each product and each sales month, and transmits total data for the number of sales for each product for each sales month to the analysis server.

  By the way, in each base, there are cases where numerical values such as the quantity and amount of the slip transmitted to the collection server are corrected and the slip information is transmitted again as a corrected slip. When the collection server sums up the numerical values of the slip information of the correction slip and sends it to the analysis server, the summation data that sums up the values before correction and the summation data that sums up the values after correction are sent separately. The consistency of the numerical value cannot be obtained between the numerical value and the numerical value obtained by adding up the aggregated data.

The disclosed technology has been made in view of the above, and an object thereof is to provide a totaling device , a totaling method, and a totaling system capable of suppressing the inconsistency of numerical values even when a slip is corrected. .

  The tabulation device disclosed in the present application includes a storage unit, a reception unit, and a tabulation unit. The storage unit stores identification information that identifies each of the slips and slip information that includes numerical values of predetermined count items. The receiving unit receives the slip information. When the slip information including the same identification information as the identification information included in the slip information received by the receiving unit is stored in the storage unit, the totaling unit stores the total items included in the stored slip information. The difference between the numerical values of the total items included in the received slip information with respect to the numerical values is totaled. In addition, when the slip information that includes the same identification information as the identification information included in the received slip information is not stored in the storage unit, the totaling unit counts the numerical values of the total items included in the received slip information. To do.

  According to one aspect of the aggregation device disclosed in the present application, there is an effect that it is possible to prevent the numerical value from being inconsistent even when the slip is corrected.

FIG. 1 is a diagram illustrating the configuration of the analysis system according to the first embodiment. FIG. 2 is a block diagram illustrating a functional configuration of the master server according to the first embodiment. FIG. 3 is a diagram illustrating a configuration example of business data according to the first embodiment. FIG. 4 is a diagram illustrating a configuration example of a reception data storage table according to the first embodiment. FIG. 5 is a diagram illustrating a configuration example of a unified code table according to the first embodiment. FIG. 6 is a diagram illustrating an example of the configuration of the aggregation target storage table according to the first embodiment. FIG. 7 is a diagram illustrating a configuration example of the summarized data according to the first embodiment. FIG. 8 is a diagram illustrating another configuration example of the summarized data according to the first embodiment. FIG. 9 is a block diagram illustrating a functional configuration of the monitoring server according to the first embodiment. FIG. 10 is a diagram illustrating a configuration example of accumulated data according to the first embodiment. FIG. 11 is a diagram illustrating an example of the analysis screen according to the first embodiment. FIG. 12 is a diagram illustrating a configuration example of a correction slip in which the sales amount is corrected. FIG. 13 is a diagram illustrating a configuration example of a totaling target storage table that stores red slips and black slips. FIG. 14 is a diagram illustrating a configuration example of the summarized data obtained by totaling the records of the total target storage table illustrated in FIG. FIG. 15 is a diagram illustrating a configuration example of accumulated data obtained by accumulating correction data summarization data. FIG. 16 is a flowchart illustrating the procedure of the storage process according to the first embodiment. FIG. 17 is a flowchart illustrating the procedure of the aggregation process according to the first embodiment. FIG. 18 is a diagram for explaining an example of a computer that executes the aggregation program.

  Hereinafter, embodiments of a counting device and a counting program disclosed in the present application will be described in detail with reference to the drawings. Note that this embodiment does not limit the disclosed technology. Each embodiment can be appropriately combined within a range in which processing contents are not contradictory.

[System configuration]
First, the configuration of the analysis system according to the present embodiment will be described. FIG. 1 is a diagram illustrating the configuration of the analysis system according to the first embodiment. The analysis system 10 shown in FIG. 1 visualizes various situations such as sales results, orders received, and delivered status of products at each base of a company.

  As illustrated in FIG. 1, the analysis system 10 includes a plurality of business systems 11, a master server 12, and a monitoring server 13. The business system 11 is a system that is respectively operated at a company base and used for the business at the base. The master server 12 and the monitoring server 13 are operated at the corporate headquarters. The master server 12 is a server device that collects information related to business at each base from each business system 11. The monitoring server 13 is a server device that provides various types of information indicating the situation to each site using information collected by the master server 12. In the example of FIG. 1, the case where there are two business systems 11 is illustrated, but the disclosed system is not limited to this, and the business systems 11 can be an arbitrary number. In the example of FIG. 1, the case where there is one monitoring server 13 is illustrated, but the disclosed system is not limited to this, and two or more monitoring servers 13 may be provided.

  The business system 11 and the master server 12 and the monitoring server 13 are connected via a network 14 so that they can communicate with each other. The network 14 may be any communication network such as the Internet, a local area network (LAN), a wide area network (WAN), or a virtual private network (VPN), regardless of whether it is wired or wireless.

  The business system 11 is input with plans and results concerning various business operations at each site. The business system 11 may be different depending on the business content performed by each base, and may include a plurality of systems. For example, the business system 11 includes an accounting system that manages the accounting of a base, a work management system that manages schedules and results of various operations, an equipment management system that manages schedules and results of operation of each facility, and the production status of products, etc. Production management system to manage The business system 11 includes a sales planning system that manages sales plans for products, a sales management system that manages sales results and order status of products, a production management system that manages the production status of products, and the like. There is an inventory management system for managing inventory status. Further, the business system 11 includes an ERP (Enterprise Resource Planning) system that manages information related to all management resources in a company such as production, sales, inventory, purchase, distribution, and accounting. The business system 11 receives information on plans and results regarding various business operations such as accounting, work management, equipment management, sales management, production management, sales planning, and inventory management. For example, when there is a transaction for selling a product, the business system 11 receives sales slip information related to the transaction.

  The business system 11 transmits information related to various businesses such as the input slip information to the master server 12 as business data. For example, business data relating to accounting includes budget data for each account item, balance data for each account item, and the like. Further, the business data related to work management includes work schedule data, work performance data, and the like. Business data related to equipment management includes equipment operation schedule data and equipment operation performance data. The business data related to production management includes production schedule data, production performance data, consumption material usage schedule data, consumption material usage performance data, defect performance data, and the like. The business data relating to the sales plan includes sales plan data, procurement schedule data for products, etc., procurement results data for products, etc. Business data related to sales management includes order data, shipping record data, sales record data, and the like. Business data related to inventory management includes inventory data, inventory adjustment data, cost data, and the like. The business system 11 may transmit the business data to the master server 12 in real time, or may transmit the business data at a timing when an operation for instructing transmission is performed by the user, or by batch processing at regular intervals such as every day. You may transmit in bulk.

  The master server 12 collects business data of each base from each business system 11. Here, with the progress of globalization, companies may have their bases in multiple regions and countries. Since the business systems 11 at each base are individually operated, different names and codes may be used for the same target such as the same product or the same supplier. The master server 12 stores master information for unifying names and codes used in each business system 11. In the master information, names and codes used in each business system 11 and names and codes used in common are associated. Based on the master information, the master server 12 converts the code of the information collected from each business system 11 into a unified code and stores it.

  In addition, the master server 12 transmits data for analysis used for analyzing various situations of each base to the monitoring server 13. Here, the master server 12 stores a large amount of business data such as slip information generated from each business system 11 at each site. When the master server 12 transmits this large amount of business data to the monitoring server 13, the communication load is large. When a plurality of monitoring servers 13 are provided, the communication load is further increased. Therefore, the master server 12 summarizes the business data collected from each business system 11 and transmits the summarized data to the monitoring server 13 as analysis target data. For example, the master server 12 aggregates the sales slip information for each item of information that is the aggregation key, generates summarized data, and transmits the generated summarized data to the monitoring server 13 as analysis target data.

  The monitoring server 13 accumulates the summarization data transmitted to the master server 12, and provides various information regarding each site using the accumulated summarization data. The manager or the person in charge of the head office or the person in charge of each base performs an analysis based on various information regarding each base provided from the monitoring server 13.

  The master server 12 appropriately collects slips from each base as business data. The master server 12 aggregates the business data collected from each base and generates summarized data. Therefore, the summarized data may include a total result of a plurality of slips. In addition, after the sales information of a certain product is aggregated and transmitted to the monitoring server 13 in the master server 12, the sales information of the same product may be collected again. The master server 12 also collects the sales information collected again and transmits it to the monitoring server 13. As described above, the monitoring server 13 may transmit the summarized data regarding the same product in a plurality of times. Therefore, the monitoring server 13 does not replace the summarization data received from the master server 12 with the previously received summarization data, but accumulates and summarizes the received summarization data to provide various information.

  By the way, after transmitting the slip information to the master server 12 in each base, the numerical values such as the quantity and amount of the slip in the transmitted slip information may be corrected, and the slip information of the corrected slip with the corrected numerical value is transmitted again. There is a case. When the master server 12 transmits the summarization data obtained by summing up the numerical values of the slip information of the correction slip to the monitoring server 13, the summarization data obtained by summing the values before correction and the summarization data obtained by summing up the values after correction are respectively transmitted. . The monitoring server 13 accumulates and summarizes the summarization data received in the master server 12, but when summarizing the summarization data obtained by summing up the numerical values of the correction slip, the numerical value is calculated between the sum of the slip and the summation data. Consistency is lost. For example, the master server 12 aggregates sales slip information on sales of ten products A collected from the base A and transmits the collected slip information to the monitoring server 13. Thereafter, the master server 12 collects sales slip information in which the sales volume of the product A has been corrected to 8 from the base A, aggregates the slip information in which the sales volume has been corrected, and transmits it to the monitoring server 13. Suppose. In this case, the monitoring server 13 accumulates and summarizes the received summary data, and as a result, the number of sales of the product A becomes 18.

  Therefore, the master server 12 according to the present embodiment stores slip information including identification information for identifying each slip and a numerical value of a predetermined total item. As one aspect, the slip information received most recently is stored for each identification information for identifying each slip. For example, when a slip number is defined in the slip information so as to be unique at all locations, the master server 12 stores the slip information for each slip number using the slip number as identification information. Further, when a slip number that is unique for each base is determined in the slip information, the master server 12 stores the slip information for each base code and slip number using the base code and slip number as identification information. Further, when a slip number that is unique for each base and slip type is defined in the slip information, the master server 12 uses the base code, slip type, and slip number as identification information, and the base code, type, and slip number. The slip information is stored every time. Then, when the slip information having the same identification information as the received slip information is stored, the master server 12 according to the present embodiment adds up the difference between the numerical values of the received slip information and the numerical values of the stored slip information. . On the other hand, when the same slip information is not stored, the master server 12 according to the present embodiment adds up the numerical values of the received slip information. As described above, when slip information having the same identification information is stored, the difference between the numerical value of the received slip information with respect to the stored slip information numerical value is aggregated to correct the corrected slip and the numerical value before the correction. Subsequent numerical differences are aggregated. Therefore, according to the monitoring server 13 according to the present embodiment, it is possible to prevent the numerical value from being inconsistent even when the slip is corrected.

[Configuration of Master Server 12]
Subsequently, the functional configuration of the master server 12 included in the system according to the present embodiment will be described. FIG. 2 is a block diagram illustrating a functional configuration of the master server according to the first embodiment. As illustrated in FIG. 2, the master server 12 includes a communication I / F (interface) unit 20, a storage unit 21, and a control unit 22.

  The communication I / F unit 20 is an interface that performs communication control with other devices such as the monitoring server 13 and the business system 11. For example, the communication I / F unit 20 receives various business data such as slip information from the business system 11. In addition, the communication I / F unit 20 transmits the analysis target data to the monitoring server 13. As an aspect of the communication I / F unit 20, a network interface card such as a LAN card can be employed.

  The storage unit 21 is a storage device such as a semiconductor memory element such as a flash memory, a hard disk, or an optical disk. The storage unit 21 is not limited to the type of storage device described above, and may be a RAM (Random Access Memory) or a ROM (Read Only Memory).

  The storage unit 21 stores various programs such as an OS (Operating System) executed by the control unit 22, a program used for maintenance of master data described later, and a program used for summarizing business data. Furthermore, the storage unit 21 stores various data necessary for executing the program executed by the control unit 22. As an example of such data, the storage unit 21 stores business data 30, a received data storage table 31, master data 32, an aggregation target storage table 33, and summary data 34.

  The business data 30 is business data received from each business system 11. As an example, business data received by the communication I / F unit 20 from each business system 11 is stored in the business data 30 by a reception control unit 40 described later. As another example, the business data 30 is referred to by the specifying unit 41 described later. As another example, the business data 30 is deleted by a storage unit 43 described later.

  FIG. 3 is a diagram illustrating a configuration example of business data according to the first embodiment. FIG. 3 is a diagram illustrating a configuration example of sales slip information as business data. As shown in FIG. 3, the business data 30 includes items of “base code”, “slip number”, “department”, “base part number”, “sales date”, and “sales amount”. The item of base code is an area for storing information indicating the base of the transmission source of business data. A code indicating each base is uniquely defined for each base. In the base code item, a code indicating the base from which the business data is transmitted is stored. The slip number item is an area for storing a number for identifying a slip. Each slip has a unique slip number for each transaction. In this embodiment, it is assumed that a slip number that is unique for each site is determined for each slip. A predetermined slip number is stored in the slip number field. The department item is an area for storing a code indicating the department from which the performance data is transmitted. A code indicating each department is uniquely defined in each department. The code indicating this department may be uniquely determined in the entire company, or may be uniquely determined in each base for each base. In the department item, a code indicating the department from which the business data is transmitted is stored. The item of the base product number is an area for storing a code indicating the product at the base. At the base, a code is set for each product. Since the code indicating this product can be determined for each site, the same product may be different for each site. In the item of the base product number, a code indicating the product at the base where the business data is transmitted is stored. The item of sales date is an area for storing the date on which the transaction was made. The item of sales amount is an area for storing the amount of money traded.

  In the example of FIG. 3, the slip number “D001” of the base code “01” has a sales transaction of a product of the base part number “L001” in the department “A” on April 10, 2012, and the sales amount is “1,”. 000 "yen. Further, the slip number “D002” of the base code “01” has a sales transaction of a product of the base part number “L002” in the department “A” on April 15, 2012, and the sales amount is “2,000” yen. Indicates that there was. Further, the slip number “D003” of the base code “01” has a sales transaction of the product of the base part number “L003” in the department “B” on August 30, 2012, and the sales amount is “3,000” yen. It shows that there was.

  The reception data storage table 31 is a table that stores business data 30 received from each business system 11. For example, the received data storage table 31 stores the most recently received business data 30 for each base code and slip number. As an example, the reception data storage table 31 is referred to by the generation unit 42 described later. As another example, the received data storage table 31 stores business data 30 by a storage unit 43 described later.

  FIG. 4 is a diagram illustrating a configuration example of a reception data storage table according to the first embodiment. FIG. 4 is a diagram illustrating a configuration example of the reception data storage table 31 that stores the sales slip information received most recently as the business data 30. As shown in FIG. 4, the reception data storage table 31 is similar to the business data 30 shown in FIG. 3, and includes “location code”, “slip number”, “department”, “location product number”, “sales date”, It has each item of “sales amount”. The reception data storage table 31 has an item “unified code”. The item of the unified code is an area for storing a unified code, which will be described later, of the product of the base product number. In this embodiment, since all the contents of the business data 30 are stored, all items of the business data 30 are included in the received data storage table 31, but only necessary items may be extracted and stored.

  In the example of FIG. 4, the slip number “D001” of the base code “01” has a sales transaction of the product of the base part number “L001” in the department “A” on April 10, 2012, and the unified code of the product is “ S001 ", indicating that the sales amount was" 1,000 "yen. Further, the slip number “D002” of the base code “01” has a sales transaction of the product of the base part number “L002” in the department “A” on April 15, 2012, and the unified code of the product is “S002”. , Indicating that the sales amount was “2,000” yen. Further, the slip number “D003” of the base code “01” has a sales transaction of the product of the base part number “L003” in the department “B” on August 30, 2012, and the unified code of the product is “S003”. , Indicating that the sales amount was “3,000” yen.

  The master data 32 is data in which various basic information used in common is stored. The master data 32 includes a unified code table 32a and total key information 32b as data related to the present embodiment.

  The unified code table 32a is a table in which names and codes used in each business system 11 and unified names and unified codes are stored in association with each other. As an example, the unified code table 32a is referred to by the specifying unit 41 described later in order to unify the codes of the business data 30 transmitted from each business system 11. As another example, the unified code table 32a is updated by a master management unit 45 described later. The summary key information 32b is data indicating a summary key for which item unit to summarize the business data in the summarization. As an example, the aggregation key information 32b is referred to by the aggregation unit 44 described later in order to summarize each business data. As another example, the total key information 32b is updated by a master management unit 45 described later.

  FIG. 5 is a diagram illustrating a configuration example of a unified code table according to the first embodiment. As shown in FIG. 5, the unified code table 32 a includes items of “base code”, “base part number”, and “unified code”. The base code item is an area for storing a code indicating the base. The item of the base product number is an area for storing a code indicating the product at the base. The item of unified code is an area for storing a unified code indicating a product. Note that this unified code may be a code for a product at any of the bases, or may be uniquely determined for each product.

  In the example of FIG. 5, the base product number “L001” of the base code “01” indicates that the unified code is “S001”. Further, the base product number “M001” of the base code “02” indicates that the unified code is “S001”. Further, the base product number “L002” of the base code “01” indicates that the unified code is “S002”. The base product number “M002” of the base code “02” indicates that the unified code is “S002”. Further, the base product number “L003” of the base code “01” indicates that the unified code is “S003”. The base product number “M003” of the base code “02” indicates that the unified code is “S003”.

  The aggregation target storage table 33 is a table that stores business data 30 to be aggregated. As an example, the aggregation target storage table 33 stores data by the storage unit 43 described later. As another example, the aggregation target storage table 33 is referred to and deleted by the aggregation unit 44 described later.

  FIG. 6 is a diagram illustrating an example of the configuration of the aggregation target storage table according to the first embodiment. FIG. 6 is a diagram illustrating a configuration example of the aggregation target storage table 33 that stores sales slip information as the business data 30. As shown in FIG. 6, the aggregation target storage table 33 is similar to the received data storage table 31 shown in FIG. 4, as “base code”, “slip number”, “department”, “unified code”, “sales date”. And “sales amount”. The aggregation target storage table 33 includes an item “category”. The item of category is an area for storing the category of the slip. In the category item, “01” is stored when representing a red slip for canceling a previous slip, and “02” is stored when representing a black slip. In this embodiment, the total object storage table 33 includes all items other than the base product number of the received data storage table 31, but only necessary items may be extracted and stored.

  In the example of FIG. 6, the slip number “D001” of the base code “01” is the sales amount of “1,000” yen for the product of the department “A” and the unified code “S001” on April 10, 2012. Since there is a transaction and the classification is “02”, it indicates that the transaction is a black slip. Further, the slip number “D002” of the base code “01” has a sales transaction with a sales amount of “2,000” yen for a product of the department “A” and the unified code “S002” on April 15, 2012. Since the classification is “02”, it indicates a black slip. Further, the slip number “D003” of the base code “01” has a sales transaction with a sales amount of “3,000” yen for the product of the base part number “L003” in the department “B” on August 30, 2012. Since the classification is “02”, it indicates a black slip.

  The summarized data 34 is data obtained by summarizing the record data stored in the aggregation target storage table 33. As an example, the summarized data 34 is generated by totaling the business data 30 by a totaling unit 44 described later. As another example, the summarized data 34 is referred to by a transmission control unit 46 described later.

  FIG. 7 is a diagram illustrating a configuration example of the summarized data according to the first embodiment. FIG. 7 is a diagram illustrating a configuration example of the summarized data generated by collecting the sales slip information. As shown in FIG. 7, the summary data 34 includes items of “base code”, “department”, “unified code”, “sales date”, and “sales amount”. The base code item is an area for storing a code indicating the base. The item of unified code is an area for storing a unified code indicating a product. The item of sales year and month is an area for storing the year and month when sales are totaled. The item of sales amount is an area for storing the sales amount collected for each sales year and month. Further, in the summarized data 34, “*” is stored as information indicating that the item is summarized in the summarized item.

  The example of FIG. 7 shows the result of totaling the sales amount for each sales month, using the sales slip information as the base code and the department item as the total key. In the example of FIG. 7, the department “A” with the base code “01” indicates that sales were “3,000” yen in April 2012. Further, the department “B” with the base code “01” indicates that sales were “3,000” yen in August 2012. Here, when the sales slip information stored in the aggregation target storage table 33 shown in FIG. 6 is aggregated using the base code and department items as the aggregation keys, the items of the unified code are unified items. I cannot specify which code is. Therefore, in the example of FIG. 7, “*” indicating that the item is a summarized item is stored in the item of the unified code.

  FIG. 8 is a diagram illustrating another configuration example of the summarized data according to the first embodiment. The example of FIG. 8 shows the result of totaling the sales amount for each sales month using the sales slip information as the base code and the items of department and unified code as the total key. In the example of FIG. 8, the product with the unified code “S001” of the department “A” with the base code “01” sold “1,000” yen in April 2012. In addition, the product of the unit code “S002” of the department “A” with the base code “01” sold “2,000” yen in April 2012. Further, the product of the unit code “S003” of the department “B” of the base code “01” has been sold “3,000” yen in August 2012. Here, when the sales slip information stored in the aggregation target storage table 33 shown in FIG. 6 is aggregated using the base code, department, and unified code items as the summary key, the base code, department, and unified code items can be specified. . For this reason, in the example of FIG. 8, “*” is not stored in any item.

  Returning to FIG. 2, the control unit 22 includes an internal memory for storing programs and control data that define various processing procedures, and executes various processes using these. As shown in FIG. 2, the control unit 22 includes a reception control unit 40, a specification unit 41, a generation unit 42, a storage unit 43, a totaling unit 44, a master management unit 45, and a transmission control unit 46. Have.

  Among these, the reception control unit 40 is a processing unit that stores business data transmitted from each business system 11 in the storage unit 21. As one aspect, when receiving the business data from each business system 11, the reception control unit 40 stores the business data in the storage unit 21.

  The specifying unit 41 is a processing unit that specifies the unified code of the code of the business data 30 stored in the storage unit 21 based on the unified code table 32a. As one aspect, when the business data 30 is stored in the storage unit 21, the specifying unit 41 sequentially reads each record of the stored business data 30. When the stored business data 30 includes an item to be converted into a code registered in the unified code table 32a, the specifying unit 41 unifies the code corresponding to the code set in the item to be converted into the code of the read record. The code is specified from the unified code table 32a. For example, when the base part number is included in the business data 30, the specifying unit 41 specifies the base code and the unified code corresponding to the code set in the base part number from the unified code table 32a.

  The generation unit 42 is a processing unit that generates red slip data for canceling a previously received slip when the business data 30 stored in the storage unit 21 includes a previously received slip correction slip. As one aspect, the generation unit 42 determines whether or not a record having the same identification information as the record of the business data 30 read by the specifying unit 41 is stored in the received data storage table 31. When the records having the same identification information are stored in the reception data storage table 31, the generation unit 42 records the values obtained by reversing the sign of the numerical values of the items to be aggregated of the records stored in the reception data storage table 31. Is generated as a red slip. For example, when the business data 30 is the sales slip information shown in FIG. 3, the generation unit 42 determines whether or not a record having the same base code and slip number as the business data 30 record is stored in the received data storage table 31. . When the record having the same base code and slip number is stored in the reception data storage table 31, the generation unit 42 reverses the sign of the numerical value of the item of the sales amount of the record stored in the reception data storage table 31, A record with the same information as the item is generated.

  The storage unit 43 is a processing unit that stores data in the received data storage table 31 and the aggregation target storage table 33. As one aspect, the storage unit 43 stores the record of the business data 30 read by the specifying unit 41 in the aggregation target storage table 33 when there is no item whose code is to be converted in the business data 30. Further, the storage unit 43 adds the unified code specified by the specifying unit 41 and adds the unified code specified by the specifying unit 41, and records the records of the business data 30 read by the specifying unit 41 when there are items to be converted into codes. Store in the storage table 33. For example, when the business data 30 is the sales slip information shown in FIG. 3, the storage unit 43 stores a record in which the following data is set in the aggregation target storage table 33. That is, the storage unit 43 sets the data of the corresponding item of the record of the business data 30 to each item of the total storage table 33, sets the unified code specified by the specifying unit 41 to the item of the unified code, A record in which “02” indicating a black slip is set in the item is stored.

  In addition, when the red slip record is generated by the generation unit 42, the storage unit 43 stores the generated red slip record in the aggregation target storage table 33. For example, when the business data 30 is the sales slip information shown in FIG. 3, a record in which the following data is set is stored in the aggregation target storage table 33. In other words, the storage unit 43 sets the data of the corresponding item of the red slip record in each item of the aggregation target storage table 33, and stores the record in which “01” indicating the red slip is set in the category item.

  In addition, the storage unit 43 stores the record of the business data 30 read by the specifying unit 41 in the received data storage table 31. As one aspect, the storage unit 43 determines whether or not a record having the same identification information as the record of the business data 30 read by the specifying unit 41 is stored in the received data storage table 31. When records having the same identification information are stored in the reception data storage table 31, the generation unit 42 updates the record stored in the reception data storage table 31 with the information of the read record. On the other hand, when the record having the same identification information is not stored in the received data storage table 31, the storage unit 43 stores the read record information in the received data storage table 31. For example, when the business data 30 is the sales slip information shown in FIG. 3, the storage unit 43 determines whether or not a record having the same base code and slip number as the business data 30 record is stored in the received data storage table 31. . When the record having the same base code and slip number is stored in the received data storage table 31, the storage unit 43 updates the data of items other than the base code and slip number to the information of the read record. In this embodiment, items other than the base code and the slip number are updated. However, only the data of the items to be counted may be updated to the read record information. For example, when the business data 30 is the sales slip information shown in FIG. 3, the storage unit 43 may update only the numerical value of the sales amount item to the numerical value of the sales amount item of the read record. On the other hand, when the record having the same base code and slip number is not stored in the received data storage table 31, the storage unit 43 stores a record in which the following data is set in the received data storage table 31. That is, the storage unit 43 sets the item data corresponding to the record of the business data 30 in each item of the received data storage table 31, and stores the record in which the unified code specified by the specifying unit 41 is set in the unified code item. To do. As a result, the received data storage table 31 stores the slip information received most recently for each piece of identification information.

  The storage unit 43 deletes the business data 30 from the storage unit 21 when the storage of all the records of the business data 30 is completed in the received data storage table 31 and the aggregation target storage table 33. Note that the storage unit 43 may sequentially delete the business data 30 from records that have been stored in the received data storage table 31 and the aggregation target storage table 33. Thereby, it is possible to prevent the same business data 30 from being stored a plurality of times in the aggregation target storage table 33.

  The tabulation unit 44 is a processing unit that tabulates data stored in the tabulation target storage table 33 based on the tabulation key information 32 b and generates the summarized data 34. The total key information 32b includes data indicating a total key indicating in which unit the business data 30 is totaled for each type of business data 30 such as each type of slip. For example, the total key information 32b specifies a base code and a department as a total key for totaling sales transaction slip information. The aggregation unit 44 groups the records in the aggregation target storage table 33 for each base code and department, aggregates the numerical values of the aggregation items of the records for each group, and generates summarized data 34 indicating the aggregation result. Further, the aggregation unit 44 stores “*” as information indicating that the item is summarized in the summarized item. For example, the tabulation unit 44 tabulates the sales transaction slip information stored in the tabulation target storage table 33 for each base code and department to generate the summarized data 34 as shown in FIG.

  Here, when a record having the same base code and slip number as the record of the business data 30 is stored in the received data storage table 31, the total object storage table 33 stores the red slip record and the black slip record. The This red slip record is a record obtained by inverting the sign of the numerical value of the summary item of the slip before correction stored in the received data storage table 31. Therefore, the totaling unit 44 counts the red slip record and the black slip record to be included in the received correction slip for the numerical value of the total item included in the slip before correction stored in the received data storage table 31. The difference in the numerical values of the total items to be collected is totaled. Further, when a record having the same base code and slip number as the record of the business data 30 is not stored in the received data storage table 31, only the black slip record is stored in the tabulation target storage table 33. The tabulation unit 44 tabulates the numerical values of the tabulation items included in the received correction slip by tabulating the black slip records.

  When the aggregation of all the records stored in the aggregation target storage table 33 is completed, the aggregation unit 44 deletes all the records stored in the aggregation target storage table 33. Thereby, it is possible to prevent the same record from being counted a plurality of times.

  The master management unit 45 is a processing unit that performs registration, correction, and deletion of the master data 32. As an aspect, the master management unit 45 displays various screens for registering, correcting, and deleting the master data 32 on a terminal device (not shown), and registering, correcting, and deleting the master data 32 from the screen. Accept. For example, the master management unit 45 displays a registration screen for registering the unified code table 32a and the total key information 32b, and accepts registration of new information from the registration screen.

  The transmission control unit 46 is a processing unit that transmits various data to the monitoring server 13. As one aspect, the transmission control unit 46 transmits the summarized data 34 aggregated by the aggregation unit 44 to the monitoring server 13 as analysis target data. Note that the transmission control unit 46 may transmit the summary data 34 to the monitoring server 13 in a batch process at regular intervals such as every day, or may be transmitted at the timing when an operation instructing transmission is performed from the user. Good.

  When the transmission of the summary data 34 to the monitoring server 13 is completed, the transmission control unit 46 deletes the summary data 34 from the storage unit 21. Thereby, it is possible to prevent the same summarized data 34 from being transmitted to the monitoring server 13 a plurality of times.

[Configuration of Monitoring Server 13]
Subsequently, the functional configuration of the monitoring server 13 included in the system according to the present embodiment will be described. FIG. 9 is a block diagram illustrating a functional configuration of the monitoring server according to the first embodiment. As shown in FIG. 9, the monitoring server 13 includes a communication I / F unit 50, a storage unit 51, and a control unit 52.

  The communication I / F unit 50 is an interface that performs communication control with another device, for example, the master server 12. For example, the communication I / F unit 50 receives the summarized data 34 from the master server 12 as analysis target data. As an aspect of the communication I / F unit 50, a network interface card such as a LAN card can be employed.

  The storage unit 51 is a storage device such as a semiconductor memory element such as a flash memory, a hard disk, or an optical disk. The storage unit 51 is not limited to the above type of storage device, and may be a RAM or a ROM.

  The storage unit 51 stores various programs such as an OS executed by the control unit 52 and a program for adding attribute information described later. Furthermore, the storage unit 51 stores various data necessary for executing the program executed by the control unit 52. As an example of such data, the storage unit 51 stores accumulated data 61.

  The accumulated data 61 is data in which various types of information used for various types of analysis are accumulated. As an example, the accumulated data 61 is stored by the storage unit 70 described later. As another example, the accumulated data 61 is referred to by an analysis control unit 71 described later in order to output various analysis results.

  FIG. 10 is a diagram illustrating a configuration example of accumulated data according to the first embodiment. FIG. 10 is a diagram illustrating a configuration example of the accumulated data 61 in which the summarized data 34 of the sales slip information is accumulated. As shown in FIG. 10, the accumulated data 61 is similar to the summary data 34 shown in FIG. 7 and includes “base code”, “department”, “unified code”, “sales date”, and “sales amount”. And “base code”, “department”, and “unified code” are key items.

  In the example of FIG. 10, the department “A” with the base code “01” indicates that sales were “3,000” yen in April 2012. Further, the department “B” with the base code “01” indicates that sales were “3,000” yen in August 2012. FIG. 10 shows an example in which the master server 12 accumulates the summarization data 34 obtained by collecting the sales slip information using the base code and the department as the aggregation key. Therefore, the item “summary code” is summarized in the item “summary code”. “*” Indicating that it is stored.

  Returning to FIG. 9, the control unit 52 has an internal memory for storing programs and control data that define various processing procedures, and executes various processes using these. As shown in FIG. 9, the control unit 52 includes a storage unit 70 and an analysis control unit 71.

  The storage unit 70 is a processing unit that stores the summarized data 34 in the accumulated data 61. As an aspect, the storage unit 70 stores the summarized data 34 as accumulated data 61 for each type of the summarized data 34. Note that, when a record having the same key item information as the summarizing data 34 to be stored is already stored in the accumulated data 61, the storage unit 70 sets the summation item value of the summarizing data 34 to the value of the already stored record. Sum the values of the corresponding summary items. On the other hand, the storage unit 70 stores the summarized data 34 in the accumulated data 61 when there is no record in the accumulated data 61 that has the same key item information as the summarized data 34 to be stored.

  The analysis control unit 71 is a processing unit that provides various types of information based on the accumulated data 61. As one aspect, the analysis control unit 71 transmits the analysis target data stored in the storage data 61 to the terminal device in response to a request for analysis of the analysis target data from the terminal device that performs various types of analysis. At this time, the analysis control unit 71 may transmit the analysis target data as it is without counting any items. Thereby, the terminal device can perform various analyzes such as displaying the analysis target data as it is, or adding up any item. Further, the analysis control unit 71 may aggregate and transmit the analysis target data using any item including attribute information. Accordingly, the terminal device can perform analysis without performing aggregation on the analysis target data. As another aspect, the analysis control unit 71 causes the terminal device to display analysis screens used for analyzing various situations at each site based on the accumulated data 61. When the analysis target data is actual data such as sales results or planned data such as sales plans, the analysis control unit 71 may individually display the schedule and actual results. The analysis control unit 71 may display the schedule and the results side by side so that they can be compared, or display the achievement rate from the ratio of the results to the schedule.

  FIG. 11 is a diagram illustrating an example of the analysis screen according to the first embodiment. FIG. 11 is a diagram showing an example of an analysis screen for analyzing monthly sales based on the accumulated data 61 shown in FIG. As shown in FIG. 11, the analysis screen 150 is provided with a display area 151 for displaying monthly sales.

[Specific processing flow]
Next, an example of a specific processing flow of the analysis system 10 according to the first embodiment will be described. The business system 11 receives information related to various businesses such as various slips. The business system 11 transmits information related to various businesses, such as the input slip information, to the master server 12 as business data. For example, the business system 11 transmits sales slip information as shown in FIG. 3 to the master server 12 as business data.

  In the master server 12, when the business data transmitted from each business system 11 is received, the reception control unit 40 stores the received business data in the storage unit 21. The specifying unit 41 sequentially reads each record of the stored business data 30 and, when there is an item whose code is to be converted, a unified code corresponding to the code set in the item whose code is to be converted is read from the unified code table 32a. Identify. For example, when sales slip information as shown in FIG. 3 is stored as the business data 30 and the unified code table 32a is as shown in FIG. 5, the specifying unit 41 unifies the base part number “L001” of the base code “01”. The code is specified as “S001”. Further, the specifying unit 41 specifies the unified code of the base part number “L002” of the base code “01” as “S002”. Further, the specifying unit 41 specifies the unified code of the base part number “L003” of the base code “01” as “S003”.

  The generation unit 42 determines whether or not a record having the same identification information as the read record is stored in the received data storage table 31. And when the record with the same identification information is memorize | stored, the production | generation part 42 produces | generates the record which reversed the positive / negative of the numerical value of the item used as the object of aggregation of the memorize | stored record as a red slip. For example, when any record of sales slip information as shown in FIG. 3 is transmitted as the business data 30 to the master server 12 for the first time, a record having the same identification information is not stored in the received data storage table 31, so the generation unit 42 does not generate a red slip. The storage unit 43 stores the read record of the business data 30 in the received data storage table 31 and the aggregation target storage table 33. As a result, when the business data 30 is sales slip information as shown in FIG. 3, the received data storage table 31 stores information as shown in FIG. 4. Further, information as shown in FIG. 6 is stored in the aggregation target storage table 33.

  The aggregation unit 44 aggregates the data stored in the aggregation target storage table 33 based on the aggregation key information 32 b to generate the summarized data 34. For example, the tabulation unit 44 tabulates each record of the tabulation target storage table 33 shown in FIG. 6 for each base code and department, and generates the summarized data 34 as shown in FIG. Further, when the aggregation is completed, the aggregation unit 44 deletes all the records stored in the aggregation target storage table 33.

  The transmission control unit 46 transmits the summarized data 34 aggregated by the aggregation unit 44 to the monitoring server 13 as analysis target data. The transmission control unit 46 deletes the summarized data 34 from the storage unit 21 when the transmission of the summarized data 34 is completed.

  In the monitoring server 13, when receiving the summarized data 34 transmitted from the master server 12, the storage unit 70 stores the summarized data 34 in the accumulated data 61. For example, when the summarized data 34 as shown in FIG. 7 is received, the accumulated data 61 stores information as shown in FIG.

  By the way, in each base, after sending the slip information to the master server 12, numerical values such as the quantity and amount of the slip of the sent slip information may be corrected. When the numerical value such as the quantity or amount of the slip of the slip information transmitted is corrected, the business system 11 transmits the slip information of the corrected slip with the same identification information as that before the correction to the master server 12 as business data. . For example, in the business system 11, when the sales amount of the sales slip information as shown in FIG. 3 is corrected, the slip information of the corrected slip with the corrected sales amount is transmitted to the master server 12 as business data. FIG. 12 is a diagram illustrating a configuration example of a correction slip in which the sales amount is corrected. In the example of FIG. 12, the sales amount of the slip number “D001” of the base code “01” is corrected to “2,000” yen from the sales slip information shown in FIG. 3. Further, for the slip number “D002” of the base code “01”, the sales amount is corrected to “3,000” yen from the sales slip information shown in FIG. Further, for the slip number “D003” of the base code “01”, the sales amount is corrected to “1,000” yen from the sales slip information shown in FIG.

  In the master server 12, when receiving the business data of the correction slip, the reception control unit 40 stores the received business data in the storage unit 21. The specifying unit 41 sequentially reads each record of the stored business data 30, and specifies a unified code corresponding to the code set in the item whose code is to be converted from the unified code table 32a.

  The generation unit 42 determines whether or not a record having the same identification information as the read record is stored in the received data storage table 31. And when the record with the same identification information is memorize | stored, the production | generation part 42 produces | generates the record which reversed the positive / negative of the numerical value of the item used as the object of aggregation of the memorize | stored record as a red slip. For example, when the business data 30 is the sales slip information shown in FIG. 12 and the information shown in FIG. 4 is stored in the received data storage table 31, the generation unit 42 displays the item of the sales amount of each record shown in FIG. Generate a record with red and negative of the numerical value of.

  The storage unit 43 stores the read record of the business data 30 in the received data storage table 31 and the aggregation target storage table 33. In addition, when the red slip record is generated by the generation unit 42, the storage unit 43 stores the generated red slip record in the aggregation target storage table 33. FIG. 13 is a diagram illustrating a configuration example of a totaling target storage table that stores red slips and black slips. The total object storage table 33 stores a red slip record with a classification “01”, a classification slip “02”, and a black slip record with the correction slip information shown in FIG.

  The aggregation unit 44 aggregates the data stored in the aggregation target storage table 33 based on the aggregation key information 32 b to generate the summarized data 34. For example, the tabulation unit 44 tabulates each record of the tabulation target storage table 33 shown in FIG. 13 for each base code and department, and generates the summarized data 34 shown in FIG. Further, when the aggregation is completed, the aggregation unit 44 deletes all the records stored in the aggregation target storage table 33.

  FIG. 14 is a diagram illustrating a configuration example of the summarized data obtained by totaling the records of the total target storage table illustrated in FIG. In the example of FIG. 14, the department “A” with the base code “01” indicates that the total result of the sales amount in April 2012 is “2,000”. Further, the department “B” of the base code “01” indicates that the total result of the sales amount in August 2012 is “−2,000” yen.

  The transmission control unit 46 transmits the summarized data 34 aggregated by the aggregation unit 44 to the monitoring server 13 as analysis target data. The transmission control unit 46 deletes the summarized data 34 from the storage unit 21 when the transmission of the summarized data 34 is completed.

  In the monitoring server 13, when receiving the summarized data 34 transmitted from the master server 12, the storage unit 70 stores the summarized data 34 in the accumulated data 61. When a record having the same key item information as the summary data 34 to be stored is already stored in the accumulated data 61, the storage unit 70 corresponds to the value of the summary item in the record already stored. Sum the values of summary items. On the other hand, the storage unit 70 stores the summarized data 34 in the accumulated data 61 when there is no record in the accumulated data 61 that has the same key item information as the summarized data 34 to be stored. Thus, for example, when the information shown in FIG. 10 is stored in the accumulated data 61 and the summarized data 34 as shown in FIG. 14 is received, the accumulated data 61 is updated as shown in FIG. FIG. 15 is a diagram illustrating a configuration example of accumulated data obtained by accumulating correction data summarization data. In the example of FIG. 15, the department “A” with the base code “01” indicates that sales of “5,000” yen were made in April 2012. Further, the department “B” with the base code “01” indicates that sales were “1,000” yen in August 2012. The tabulation result shown in FIG. 15 matches the result obtained by tabulating the correction slip shown in FIG. 12 for the sales amount for each base code and department. Thus, according to the master server 12 according to the present embodiment, it is possible to prevent the numerical value from being inconsistent even when the slip is corrected.

[Process flow]
Next, the process flow of the master server 12 according to the present embodiment will be described. FIG. 16 is a flowchart illustrating the procedure of the storage process according to the first embodiment. This storage processing is executed when the business data transmitted from the business system 11 is stored in the storage unit 21. For example, the storage process is executed when business data received from the business system 11 is stored in the storage unit 21 by the reception control unit 40. The storage process may be executed at regular intervals such as every day.

  As illustrated in FIG. 16, the storage unit 43 determines whether or not the processing for all the records of the business data 30 stored in the storage unit 21 has been completed (Step S <b> 10). When the processing for all the records is completed (Yes at Step S10), the storage unit 43 deletes the business data 30 stored in the storage unit 21 (Step S11), and ends the processing.

  On the other hand, when the processing for all the records has not been completed (No at Step S10), the specifying unit 41 sequentially reads one record from the business data 30 (Step S12). If there is an item whose code is to be converted in the read record, the specifying unit 41 specifies a unified code corresponding to the code set in the item to be converted from the unified code table 32a (step S13).

  The generation unit 42 determines whether or not a record having the same identification information as the read record is stored in the received data storage table 31 (step S14). When records with the same identification information are stored (Yes at Step S14), the generation unit 42 inverts the sign of the numerical value of the item for which the identification information stored in the received data storage table 31 is the target of aggregation. The recorded record is generated as a red slip (step S15). When there is an item whose code is to be converted in the read record, the storage unit 43 adds the unified code specified by the specifying unit 41 and stores the information of the record in the aggregation target storage table 33 (step S16). Further, the storage unit 43 stores the information of the generated red slip record in the tabulation target storage table 33 (step S17). Thereafter, the storage unit 43 updates the record of the received data storage table 31 having the same identification information as the read record to the read record information (step S18), and proceeds to step S10.

  On the other hand, when the record with the same identification information is not stored (No at Step S14), the storage unit 43 adds the unified code and totals the information of the record when there is an item whose code is to be converted in the read record It stores in the target storage table 33 (step S19). Thereafter, the storage unit 43 stores the read record information in the received data storage table 31 (step S20), and proceeds to step S10.

  Next, a description will be given of the flow of aggregation processing for generating summarized data by the master server 12 according to the present embodiment. FIG. 17 is a flowchart illustrating the procedure of the aggregation process according to the first embodiment. This counting process is executed at regular intervals such as every day.

  As shown in FIG. 17, the totaling unit 44 specifies the total key from the total key information 32b (step S30). The tabulation unit 44 tabulates the data stored in the tabulation target storage table 33 with the identified tabulation key (step S31). The totaling unit 44 generates the summarized data 34 indicating the totaling result obtained by totaling the data stored in the totaling target storage table 33 (Step S32), and ends the process.

[Effect of Example 1]
The master server 12 according to the present embodiment stores slip information including identification information for identifying each slip and a numerical value of a predetermined total item. The master server 12 according to the present embodiment receives received slip information as business data from each business system 11. When the master server 12 according to the present embodiment stores the slip information including the same identification information as the identification information included in the received slip information, the master server 12 receives the numerical values of the total items included in the stored slip information. The difference of the numerical value of the total item included in the slip information is calculated. In addition, the master server 12 according to the present embodiment, when the slip information including the same identification information as the identification information included in the received slip information is not stored, the numerical value of the total item included in the received slip information Tally. Thereby, according to the master server 12 which concerns on a present Example, even when a slip is corrected, it can suppress that the consistency of a numerical value cannot be taken.

  Further, the master server 12 according to the present embodiment, when the slip information including the same identification information as the identification information included in the received slip information is stored, the numerical value of the summation item of the stored slip information The slip information is generated by inverting. And the master server 12 which concerns on a present Example totals the numerical value of the said total item contained in the received slip information, and the numerical value of the total item contained in the produced | generated slip information. As described above, according to the master server 12 according to the present embodiment, the slip information corrected on the data can be easily identified by generating the slip information of the red slip in which the numerical value of the aggregation item is reversed. . Further, according to the master server 12 according to the present embodiment, the contents of the slip information before the correction can be easily grasped by generating the slip information of the red slip for the corrected slip information.

  Further, the master server 12 according to the present embodiment, when the slip information including the same identification information as the identification information included in the received slip information is stored, the stored slip information is stored in the received slip information. Update. Further, the master server 12 according to the present embodiment stores the received slip information when the slip information including the same identification information as the identification information included in the received slip information is not stored. Thereby, according to the master server 12 which concerns on a present Example, only the slip information received most recently for every identification information can be memorize | stored. Thus, by storing only the most recently received slip information, the capacity of the storage area for storing the slip information can be reduced.

  Although the embodiments related to the disclosed apparatus have been described above, the present invention may be implemented in various different forms other than the above-described embodiments. Therefore, another embodiment included in the present invention will be described below.

  For example, in the above embodiment, a case has been described in which only slip information received most recently for each piece of identification information is stored, but the disclosed device is not limited to this. For example, the received slip information is stored together with the reception date and time, and when the slip information is received, it is determined whether or not the slip information having the same identification information as the received slip information is stored. You may make it total the difference of new identification information and a numerical value.

  In the above embodiment, when the slip information having the same identification information as the received slip information is stored, the slip information of the red slip is generated by reversing the sign of the summation item of the stored slip information. However, the disclosed apparatus is not limited to this. For example, a red slip is not generated, and it is determined whether or not slip information having the same identification information as the received slip information is stored in the counting process. If no slip information having the same identification information is stored, the numerical values of the tabulation items included in the received slip information are tabulated. When slip information having the same identification information is stored, the difference between the numerical values of the total items included in the received slip information may be totaled with respect to the numerical values of the total items included in the stored slip information.

[Distribution and integration]
In addition, each component of each illustrated apparatus does not necessarily need to be physically configured as illustrated. In other words, the specific form of distribution / integration of each device is not limited to that shown in the figure, and all or a part thereof may be functionally or physically distributed or arbitrarily distributed in arbitrary units according to various loads or usage conditions. Can be integrated and configured. For example, the reception control unit 40, the specifying unit 41, the generation unit 42, the storage unit 43, the totaling unit 44, the master management unit 45, and the transmission control unit 46 of the master server 12 may be appropriately integrated. Further, the processing of each processing unit may be appropriately separated into a plurality of processing units. In addition, the reception control unit 40, the identification unit 41, the generation unit 42, the storage unit 43, the totaling unit 44, the master management unit 45, or the transmission control unit 46 have different devices, respectively, and are connected to the network to cooperate. The function of the master server 12 may be realized.

[Aggregation program]
The various processes described in the above embodiments can be realized by executing a prepared program on a computer such as a personal computer or a workstation. Therefore, in the following, an example of a computer that executes a counting program having the same function as that of the above embodiment will be described with reference to FIG.

  FIG. 18 is a diagram for explaining an example of a computer that executes the aggregation program. As illustrated in FIG. 18, the computer 200 includes an operation unit 210, a display 220, and a communication unit 230. The computer 200 further includes a CPU 250, a ROM 260, an HDD 270, and a RAM 280. These units 210 to 280 are connected via a bus 240.

  The HDD 270 stores in advance a totaling program 270a that performs the same functions as the reception control unit 40, the specifying unit 41, the generation unit 42, the storage unit 43, the totaling unit 44, the master management unit 45, and the transmission control unit 46. About this totaling program 270a, you may integrate or isolate | separate suitably like each component shown in Example 1. FIG. In other words, all the data stored in the HDD 270 need not always be stored in the HDD 270, and only the data necessary for processing may be stored in the HDD 270.

  Then, the CPU 250 reads the aggregation program 270a from the HDD 270 and expands it in the RAM 280. Thereby, as shown in FIG. 18, the aggregation program 270a functions as an aggregation process 280a. The aggregation process 280a expands various data read from the HDD 270 in an area allocated to itself on the RAM 280 as appropriate, and executes various processes based on the expanded data. The aggregation process 280a is a process executed by the reception control unit 40, the identification unit 41, the generation unit 42, the storage unit 43, the aggregation unit 44, the master management unit 45, and the transmission control unit 46, for example, as shown in FIGS. Includes storage processing and aggregation processing. For example, when business data is transmitted from the business system 11, the aggregation process 280 a executes storage processing and aggregation processing. That is, the aggregation process 280a performs the same operations as the reception control unit 40, the identification unit 41, the generation unit 42, the storage unit 43, the aggregation unit 44, the master management unit 45, and the transmission control unit 46. It should be noted that all the processing units virtually realized on the CPU 250 do not always have to operate on the CPU 250, and only the processing units necessary for processing need only be virtually realized.

  Note that the totaling program 270a is not necessarily stored in the HDD 270 or the ROM 260 from the beginning. For example, each program is stored in a “portable physical medium” such as a flexible disk inserted into the computer 200, so-called FD, CD-ROM, DVD disk, magneto-optical disk, or IC card. Then, the computer 200 may acquire and execute each program from these portable physical media. Each program is stored in another computer or server device connected to the computer 200 via a public line, the Internet, a LAN, a WAN, etc., and the computer 200 acquires and executes each program from these. It may be.

DESCRIPTION OF SYMBOLS 10 Analysis system 12 Master server 13 Monitoring server 20 Communication I / F part 21 Storage part 22 Control part 30 Business data 31 Reception data storage table 32b Total key information 33 Total object storage table 34 Summarization data 40 Reception control part 41 Identification part 42 Generation | occurrence | production Unit 43 Storage unit 44 Totaling unit 46 Transmission control unit

Claims (5)

When defining a slip number that is unique at all locations where multiple business systems are operated, the slip number is used as identification information for identifying the slip, and when a slip number that is unique for each location is determined, the location code and When the slip number is used as the identification information and a unique slip number is determined for each base and slip type, the base code, the slip type, and the slip number are used as the identification information for a predetermined total item including the identification information. and document to be registered in the new number, received from the plurality of business systems for transmitting the modified slips that fixes the value of the aggregate field in the document includes the identification information, the value of the identification information and a predetermined summary Field A storage unit for storing the slip information included;
When slip information is newly received from at least one of the plurality of business systems, is slip information including the same identification information as the identification information included in the received slip information stored in the storage unit ? search, if the voucher information of the identification information and the same identification information included in the received document information is stored, voucher information obtained by inverting the sign of numerical values of the summary items included in the stored the voucher information A generating unit for generating
A totaling unit that counts the numerical value of the totaling item included in the received slip information and the numerical value of the totaling item included in the generated slip information for each data of a predetermined totaling key item;
A transmission unit that transmits the aggregated data to the server;
A tally device characterized by comprising:   When slip information including the same identification information as the identification information included in the received slip information is stored in the storage unit, the slip information stored in the storage unit is updated to the received slip information and received. The storage unit for storing the received slip information in the storage unit when the slip information including the same identification information as the identification information included in the slip information is not stored in the storage unit. 1. The counting device according to 1. When defining a slip number that is unique at all locations where multiple business systems are operated, the slip number is used as identification information for identifying the slip, and when a slip number that is unique for each location is determined, the location code and When the slip number is used as the identification information and a unique slip number is determined for each base and slip type, the base code, the slip type, and the slip number are used as the identification information for a predetermined total item including the identification information. New slip information is received from at least one business system among the plurality of business systems that transmits a slip for newly registering a numerical value and a correction slip that includes the identification information and corrects the numerical value of the summary item of the slip . If, in the storage unit for storing the received voucher information, or form information including the same identification information as the identification information included in the received form information is stored And search, if the voucher information of the identification information and the same identification information included in the received document information is stored, voucher information obtained by inverting the sign of numerical values of the summary items included in the stored the voucher information Produces
The value of the summary fields counted for each item of data of a predetermined aggregation key that is included in the summary field values and the generated form information included in the received document information,
A totaling method characterized in that the computer executes a process of transmitting the totaled data to the server. A tally system that sends tally data of slips from a first server to a second server,
The first server is
When defining a slip number that is unique at all locations where multiple business systems are operated, the slip number is used as identification information for identifying the slip, and when a slip number that is unique for each location is determined, the location code and When the slip number is used as the identification information and a unique slip number is determined for each base and slip type, the base code, the slip type, and the slip number are used as the identification information for a predetermined total item including the identification information. New slip information is received from at least one business system among the plurality of business systems that transmits a slip for newly registering a numerical value and a correction slip that includes the identification information and corrects the numerical value of the summary item of the slip . If, in the first storage unit that stores the received document information, voucher information including the same identification information as the identification information included in the received document information is stored Luke searching, if the voucher information of the identification information and the same identification information included in the received document information is stored, by inverting the sign of numerical values of the summary items included in the stored the voucher information Generate slip information
The value of the summary fields counted for each item of data of a predetermined aggregation key that is included in the summary field values and the generated form information included in the received document information,
Send the aggregated data to the second server,
The second server is
When other aggregate data corresponding to the data of the item of the aggregate key is stored in the second storage unit, the value of the aggregate item received in the other aggregate data of the second storage unit is received. Summing up the values of the summary items of the summary data, and storing the received summary data in the second storage unit when the other summary data corresponding to the data of the summary key item is not stored Total system characterized by A tally method for sending tally data of a slip from a first server to a second server,
The first server is
When defining a slip number that is unique at all locations where multiple business systems are operated, the slip number is used as identification information for identifying the slip, and when a slip number that is unique for each location is determined, the location code and When the slip number is used as the identification information and a unique slip number is determined for each base and slip type, the base code, the slip type, and the slip number are used as the identification information for a predetermined total item including the identification information. New slip information is received from at least one business system among the plurality of business systems that transmits a slip for newly registering a numerical value and a correction slip that includes the identification information and corrects the numerical value of the summary item of the slip . If, in the first storage unit that stores the received document information, voucher information including the same identification information as the identification information included in the received document information is stored Luke searching, if the voucher information of the identification information and the same identification information included in the received document information is stored, by inverting the sign of numerical values of the summary items included in the stored the voucher information Generate slip information
The value of the summary fields counted for each item of data of a predetermined aggregation key that is included in the summary field values and the generated form information included in the received document information,
Send the aggregated data to the second server,
The second server is
When other aggregate data corresponding to the data of the item of the aggregate key is stored in the second storage unit, the value of the aggregate item received in the other aggregate data of the second storage unit is received. Summing up the values of the summary items of the summary data, and storing the received summary data in the second storage unit when the other summary data corresponding to the data of the summary key item is not stored A tally method characterized by

Images