JP2013178663A - Tabulation program, tabulation device, and tabulation method - Google Patents

Abstract

An object of the present invention is to suppress the situation where the consistency of aggregation cannot be obtained.
A master server uses a unified code to aggregate the values of business data numeric items that can be converted from a dummy code to a unified code, and erases the dummy data numeric items that have been aggregated in the past. Include.
[Selection] Figure 2

Description

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

  An organization such as a company may have bases such as factories that produce products and dealers that sell products over a plurality of regions and countries. These bases often have different business systems and code systems and languages used by the business systems. For this reason, it is desired to visualize the situation regarding various operations including production, sales and inventory across the boundaries between bases.

JP 2001-195472 A

  As an example of the above visualization, after collecting business data associated with business attribute items and numerical items from the business system introduced at each base, the value of the numerical item included in the business data is set to a predetermined attribute, For example, it is conceivable to tabulate in units such as organization, period, and item.

  However, the business systems introduced at each base are not necessarily the same. For this reason, it is assumed that the code of the attribute item included in the business data collected from the business system is converted into a unified code unified among the bases.

  At this time, if the code of any attribute item among the attribute items is not registered as a unified code, it cannot be determined which other business data should be aggregated with the value of the numerical item corresponding to the code. . In this way, when the numerical items of codes that are not in the unified code are excluded from the totalization, the total amount becomes inaccurate.

  For this reason, in order to prevent the total amount from becoming inaccurate even if some attribute items are unknown, a dummy code that has a dummy code in the business data is converted after converting a code that is not in the unified code into a dummy code. It is assumed that the values of numeric items are aggregated between data.

  However, the above assumed technology has a problem that the consistency of aggregation cannot be obtained when the unified code is updated.

  For example, in the above assumed technology, when a unified code is newly added, a code of an attribute item that has been a dummy code may be converted into a unified code. In this case, the values of the numerical items of the business data that can be converted into the unified code are again totaled. However, the value of the numeric item that was aggregated before the update of the unified code still remains in the aggregate value of the dummy data. As described above, in the above assumed technique, the values of the numerical items are counted twice before and after the update of the unified code, and as a result, the totals are not matched.

  The disclosed technology has been made in view of the above, and an object thereof is to provide a totaling program, a totaling apparatus, and a totaling method capable of suppressing a situation in which tabulation consistency cannot be obtained.

  The aggregation program disclosed in the present application causes a computer to execute processing for receiving business data associated with business-related attribute items and numerical items from a base server connected via a network. Further, in the computer, in the unified code storage unit that stores a base code of the attribute item defined by the base server in association with a unified code in which the base code of the attribute item is unified among the base servers. When the site code of the attribute item included in the data is not registered, a process of converting the site code of the attribute item into a dummy code is executed. Further, when the base code of the attribute item included in the business data is registered in the unified code storage unit, the computer is caused to execute processing for converting the base code of the attribute item into the unified code. Further, in the computer, the unit code of the attribute item included in the conversion history converted to the dummy code among the conversion history stored in the conversion history storage unit that stores the conversion history of the base code of the attribute item, and the unified When the site code of the attribute item included in the business data converted into the code matches, the site code of the attribute item is the dummy data conversion data converted into the dummy code, and is included in the dummy data Execute processing to generate consumption data that erases the value of a numeric item. Further, the business data, the dummy data of the attribute items included in the dummy data and the consumption data, and the business data, the dummy data of the attribute items included in the consumption data, the dummy data and the consumption data Then, a process of aggregating the values of the numeric items of the dummy data and the consumption data is executed.

  According to one aspect of the aggregation program disclosed in the present application, there is an effect that it is possible to suppress a situation in which aggregation consistency cannot be obtained.

FIG. 1 is a diagram illustrating the configuration of the monitoring 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 an example of slip data. FIG. 4 is a diagram illustrating an example of a unified code master. FIG. 5 is a diagram illustrating an example of totaling data. FIG. 6 is a diagram illustrating an example of conversion history data. FIG. 7 is a diagram illustrating an example of summary level data. FIG. 8 is a diagram illustrating an example of a product type master. FIG. 9 is a diagram illustrating an example of summary data. FIG. 10 is a diagram illustrating an example of data for aggregation. FIG. 11 is a diagram illustrating an example of summary data. FIG. 12 is a diagram illustrating an example of conversion history data. FIG. 13 is a flowchart illustrating the procedure of the aggregation process according to the first embodiment. FIG. 14 is a schematic diagram illustrating an example of a computer that executes a counting program according to the first and second embodiments.

  Hereinafter, embodiments of a counting program, a counting device, and a counting method 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 monitoring system according to the present embodiment will be described. FIG. 1 is a diagram illustrating the configuration of the monitoring system according to the first embodiment. A monitoring system 1 shown in FIG. 1 provides a monitoring service for monitoring the status of various businesses of a company that develops bases 3A to 3C across a plurality of regions and countries.

  As shown in FIG. 1, the monitoring system 1 accommodates a master server 10, base servers 30 </ b> A to 30 </ b> C, a head office terminal 50, and a monitoring server 70. In the example of FIG. 1, three base servers and one head office terminal are illustrated, but the disclosed system is not limited to the illustrated configuration. That is, the monitoring system 1 can accommodate any number of base servers and head office terminals. Hereinafter, the bases 3A to 3C are collectively referred to as “base 3” when collectively referred to, and the base servers 30A to 30C are collectively referred to as “base server 30”. May be described.

  The master server 10, the base server 30, the head office terminal 50, and the monitoring server 70 are connected via the network 9 so that they can communicate with each other. The network 9 can employ any type of communication network such as the Internet, LAN (Local Area Network), and VPN (Virtual Private Network) regardless of wired or wireless.

  Among these, the base server 30 is a server device for business management disposed in the base 3 such as a factory that produces products or a store that sells products. As an example of the base server 30, production, sales, inventory, so-called live sales PSI, and various business data such as finance, procurement, distribution, etc. are managed. Resource Planning) server can be adopted.

  The base server 30 uploads business data related to various business plans or results to the master server 10. At this time, the base server 30 may upload the business data in real time or may upload it by batch processing. In the following, the following description will be given on the assumption that the base server 30 uploads the slip data relating to the product sales plan to the master server 10 as an example.

  Here, the slip data uploaded to the master server 10 by the base server 30 includes an attribute item in which an attribute relating to the sales plan is defined and a numerical item in which a numerical value relating to the sales plan is defined.

  For example, as an example of the attribute item of the slip data, a slip number, a base item number, a planned sales date, and the like can be given. The “slip number” here refers to a number for identifying slip data. In addition to the identification of the slip, a number that also serves as the identification of the base 3 and the department in the base 3 can be assigned to the slip number. Further, when the identification information of the base 3 or the department in the base 3 is not incorporated in the slip number, the identification information of the department in the base 3 or the base 3 can be individually added to the slip data. Further, the “base item number” indicates a number for identifying a product item in each of the bases 3A to 3C. The “scheduled sales date” indicates a schedule for selling the product. For example, the date can be described by “yyyy / mm / dd”. Of these, the base item number may be assigned a different code system depending on the ERP package installed in the base server 30, and therefore, a code common to the bases 3 is not necessarily assigned. Absent. As described above, a code used locally at the site 3 may be referred to as a “site code” below. Moreover, as an example of the numerical item of the slip data, there is a planned sales indicating a sales planned for the sale of the product.

  The master server 10 is a server device that manages various masters. The master server 10 may be implemented as a Web server or may be implemented as a cloud.

  The master server 10 converts the base code of the attribute item included in the slip data collected from the base server 30 into a unified code unified between the bases 3 by using a unified code master 13b described later. In this way, the reason for converting the base code to the unified code is to comprehensively manage the slip data of each base 3 after absorbing the difference between the ERP package introduced at the base 3 and the code system used by the ERP package. .

  In addition, the master server 10 notifies the monitoring server 70 of data used for monitoring various operations. At this time, the master server 10 immediately transmits the slip data collected from the base servers 30A to 30C just because the code system of the attribute items included in the slip data is unified among the bases 3. I do not. This is because if the slip data that increases with the expansion of the number of business sites and the number of product items is transmitted to the monitoring server 70 as it is, the communication load between the master server 10 and the monitoring server 70 also increases. . Therefore, the master server 10 summarizes the slip data by aggregating the slip data according to the summary level set by the person in charge in the sales department of the head office 5, for example, the organization, the period, and the product name granularity. In addition, the master server 10 notifies the monitoring server 70 of summary data in which the slip data is summarized. As described above, the master server 10 transmits summary data in which the granularity of attribute items such as the organization, period, and product name is larger than the slip data collected from the base server 30, so that the master server 10 and the monitoring server 70 are Reduce the communication load.

  The monitoring server 70 is a server device that provides a monitoring service that publishes summary data of slip data notified from the master server 10 to the head office terminal 50 or the like. The monitoring server 70 may be implemented as a Web server or may be implemented as a cloud.

  The monitoring server 70 can provide the summary data of the slip data as a report as it is, or provide the summary data report after further summarizing the summary data according to the granularity of the report designated from the head office terminal 50. You can also. Further, when the monitoring server 70 receives a request for generating a report for predictive comparison from the headquarters terminal 50, the values of the numerical items are written together so that the numerical comparison with the summary data regarding the sales plan and the sales results is facilitated. You can also generate chart reports such as charts and graphs.

  In addition, the monitoring server 70 releases the monitoring service by focusing on specific members belonging to the organization. For example, the monitoring server 70 receives input of login authentication information such as an account name and a password from the head office terminal 50. Then, the monitoring server 70 performs login authentication of the user of the head office terminal 50 using the login authentication information received from the head office terminal 50. At this time, if the login authentication is successful, the monitoring server 70 authenticates that the user of the head office terminal 50 is a member and releases the monitoring service.

  The head office terminal 50 is a terminal device used by a member of the head office 5 which is a head quarter that supervises the bases 3A to 3C. As an example of the head office terminal 50, a mobile terminal such as a mobile phone, a PHS, and a PDA can be employed in addition to a fixed terminal such as a personal computer. For example, the head office terminal 50 is used by a member of the head office 5, for example, a sales department, a purchasing department, a person in charge of an order receiving department, or the like. Here, it is assumed that the monitoring service is provided to the members of the headquarters 5 through the headquarters terminal 50, but the bases used by the members of the respective bases 3, for example, managers of the sales department, the purchasing department, and the order receiving department. The monitoring service may be provided through the terminal.

[Configuration of Master Server 10]
Subsequently, a functional configuration of the master server 10 according to the present embodiment will be described. FIG. 2 is a block diagram illustrating a functional configuration of the master server 10 according to the first embodiment. As illustrated in FIG. 2, the master server 10 includes a communication I / F (interface) unit 11, a storage unit 13, and a control unit 15. The master server 10 may include various functional units included in a known server device, for example, functional units such as various input devices and audio output devices, in addition to the functional units illustrated in FIG.

  The communication I / F unit 11 is an interface that performs communication control with other devices, for example, the base servers 30A to 30C, the head office terminal 50, and the monitoring server 70. As an aspect of the communication I / F unit 11, a network interface card such as a LAN card can be employed. For example, the communication I / F unit 11 receives slip data from the base server 30 and transmits summary data of the slip data generated by the master server 10 to the monitoring server 70.

  The storage unit 13 is a storage device that stores various programs such as an OS (Operating System) executed by the control unit 15 and a summary program that generates summary data of slip data by tallying slip data. As one aspect of the storage unit 13, a storage device such as a semiconductor memory element such as a flash memory, a hard disk, and an optical disk can be cited. The storage unit 13 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 13 includes slip data 13a, a unified code master 13b, totaling data 13c, conversion history data 13d, and summary level data 13e as an example of data necessary for executing the program executed by the control unit 15. And the product type master 13f are stored.

  Of these, the slip data 13a is data representing a slip relating to a sales plan, which is an aspect of the business data relating to a business plan or actual performance. As an example, the slip data collected from the base server 30 is registered in the slip data 13a by the receiving unit 15a described later. As another example, the slip data 13a is referred to by a conversion unit 15b described later in order to generate summary data from the slip data 13a. As a further example, the slip data 13a is deleted by a later-described notification unit 15e when summary data is notified to the monitoring server 70.

  As an aspect of the slip data 13a, data in which an attribute item in which an attribute related to a sales plan is defined and a numerical item in which a numerical value related to the sales plan is defined can be employed. For example, as an example of the attribute item, there are a slip number, a base item number, a planned sales date, and the like. Moreover, as an example of the numerical item, there is a planned sales that indicates a sales planned for the sale of the product.

  FIG. 3 is a diagram illustrating an example of the slip data 13a. In the example of FIG. 3, four slip data collected from the base server 30A is illustrated as an example. The example of the slip data of slip number “D001” shown in FIG. 3 indicates that sales of 1000 yen are expected on April 10, 2012 due to the sale of the product of base item number “L001”. Further, the example of the slip data of the slip number “D002” shown in FIG. 3 indicates that sales of 2000 yen are expected by the sale of the product of the base item number “L002” on April 15, 2012. The example of the slip data with the slip number “D003” shown in FIG. 3 indicates that sales of 3000 yen are expected on August 10, 2012 due to the sale of the product with the base item number “L003”. Further, the example of the slip data of the slip number “D004” shown in FIG. 3 indicates that sales of 4000 yen are expected by the sale of the product of the base item number “L004” on August 30, 2012.

  The unified code master 13b is master data in which the correspondence relationship between the base code and the unified code of the attribute item is defined. As an example, the unified code master 13b is referred to by a conversion unit 15b described later in order to convert a base code of an attribute item included in the slip data 13a into a unified code. As another example, the unified code master 13b is updated by the head office terminal 50 such as new registration, change, or deletion of the unified code.

  As an aspect of the unified code master 13b, data in which a base item number and a unified item number are associated can be employed. FIG. 4 is a diagram illustrating an example of the unified code master 13b. In the example of FIG. 4, the base item numbers “L001” and “M001” used at different bases indicate the same item, and indicate that these item numbers are unified to “S001”. Further, in the example of FIG. 4, the base item numbers “L002” and “M002” used at different bases indicate the same item, and indicate that these item numbers are unified to “S002”. . Note that the unified code does not necessarily have a code system different from the base code, and any one of the base codes can be set as the unified code.

  In the example of FIG. 4, the correspondence between the base code and the unified code related to the product item number is illustrated, but the master in which the correspondence between the base code and the unified code other than the product item number is defined is held. It doesn't matter. For example, when the master server 10 collects ledger data related to business partners, business partner numbers having different code systems may be used between the bases 3. In this case, the disclosed apparatus may hold a master in which the correspondence between the base supplier number and the unified supplier number is defined.

  The aggregation data 13c is data used for aggregation by a later-described aggregation unit 15c. As an example, in the data for aggregation 13c, slip data obtained by converting the base code of the attribute item into a unified code is registered by the generation unit 15c described later. As another example, in the data for aggregation 13c, dummy data obtained by converting the attribute item base code into a unified code without being converted into a unified code is registered by the generation unit 15c described later. As a further example, in the aggregation data 13c, when the slip accepted by the accepting unit 15a is a dummy data correction slip, consumption data for erasing the dummy data is registered by the generation unit 15c described later. As another example, the aggregation data 13c is referred to by the aggregation unit 15d described later in order to generate summary data by aggregating the values of the numerical items included in the aggregation data 13c, and after the summary data is generated It is deleted by a counting unit 15d described later.

  As an aspect of the totaling data 13c, data in which a slip number, a slip classification, a unified item number, a planned sales date, and a planned sales amount are associated can be employed. The “slip category” here refers to a category of a slip. Such slip classification includes, for example, a black slip that adds the value of a numeric item and a red slip that erases the value of a numeric item. FIG. 5 is a diagram illustrating an example of the totaling data 13c. In the example of FIG. 5, the four slip data of the slip numbers “D001” to “D004” are all black slips that are added when the numerical items are aggregated. Among these, the slip data of the slip number “D004” indicates that the unified item number is dummy data including a dummy code.

  The conversion history data 13d is data representing the conversion history of the base code of the attribute item. As an example, the conversion history data 13d is generated by a generation unit 15c described later in order to determine whether the slip data 13a that has been able to convert the base code of the attribute item into a unified code is a new slip or a dummy data correction slip. Referenced. As another example, the conversion history data 13d indicates that when summary data is generated from the slip data 13a, the conversion history corresponding to the slip number included in the slip data 13a is updated by the conversion unit 15b described later. Updated.

  As the conversion history data 13d, data in which a slip number, a base item number, a unified item number, a planned sales date, and a planned sales amount are associated can be adopted. FIG. 6 is a diagram illustrating an example of the conversion history data 13d. Of the conversion histories shown in FIG. 6, the conversion histories of the slip numbers “D001” to “D003” all indicate that the base item number can be converted into the unified item number. On the other hand, the conversion history of the slip number “D004” indicates that the base item number cannot be converted into a unified item number, and the base item number has been converted into a dummy code.

  The summary level data 13e is data in which the granularity of the attribute item after aggregation is defined. As an example, the summary level data 13e is referred to by a later-described aggregation unit 15d when the values of numerical items included in the aggregation data 13c are aggregated. As another example, in the summary level data 13e, the head office terminal 50 executes setting registration and setting change of the type and granularity of attribute items such as organization, period, and product name. As an aspect of the summary level data 13e, data in which the aggregated organization, period, and product name granularity are associated can be employed. FIG. 7 is a diagram illustrating an example of the summary level data 13e. In the example of FIG. 7, the numerical items of the data 13c for aggregation are three units of “organization”, “period”, and “product name” as aggregation keys, and the granularity after aggregation is “base”, “monthly” and This indicates that it is set to be aggregated so as to be “product type”.

  The product master 13f is master data in which a unified product number that is a unified product product code is defined. The “variety” here refers to a group of items in which items having a certain commonality are grouped into a series, and is also called a series item. As an example, the product type master 13f is referred to by a later-described totaling unit 15d in order to total the numerical items linked to the unified item number included in the same product type. As another example, in the product master 13f, the headquarters terminal 50 updates the unified product number such as new registration, change or deletion. As an aspect of the product type master 13f, data in which a unified product number and a unified product number are associated can be employed. FIG. 8 is a diagram illustrating an example of the product type master 13f. In the example of FIG. 8, the products having the unified item numbers “S001” and “S002” are series items.

  The control unit 15 has an internal memory for storing programs defining various processing procedures and control data, and executes various processes using these. As shown in FIG. 2, the control unit 15 includes a reception unit 15a, a conversion unit 15b, a generation unit 15c, a totaling unit 15d, and a notification unit 15e.

  Among these, the reception unit 15 a is a processing unit that receives slip data from the base server 30. As one aspect, the accepting unit 15a stores the slip data uploaded from the base server 10 until a predetermined period elapses after the summary data is generated last time or until a predetermined periodic time is reached. Register with Here, a case will be described in which the slip data stored in the storage unit 13 in the subsequent function unit is batch-processed on a daily basis, but the aggregation process is performed on the condition that a predetermined number of slip data has been stored. It may be activated or the aggregation process may be activated every time slip data is received.

  The conversion unit 15b is a processing unit that converts the base code of the attribute item included in the slip data using the unified code master 13b. As one aspect, when the base item number included in the slip data 13a is registered in the unified code master 13b, the conversion unit 15b converts the base item number into a unified item number. The conversion unit 15b converts the base item number into a dummy code when the base item number included in the slip data 13a is not registered in the unified code master 13b. Thereafter, the conversion unit 15b updates the conversion history corresponding to the slip number included in the slip data 13a in the conversion history data 13d to the latest conversion history. At this time, if the same conversion history as the combination of the slip number and the base item number that has been converted this time is not registered, the conversion unit 15b records the conversion history including the base code and the unified code before and after the conversion. Is newly registered. On the other hand, when the same conversion history as the combination of the slip number and the base item number that has been converted this time has already been registered, the conversion unit 15b records a conversion history record including the base code and the unified code before and after conversion. Overwrite and register.

  The generation unit 15c is a processing unit that generates erase data that erases dummy data. As one aspect, when the base item number is converted into a unified item number by the conversion unit 15b, the generation unit 15c registers the slip data after conversion into the unified item number as the aggregation data 13c. Then, the generation unit 15c reads the conversion history having the same slip number as the slip number included in the slip data converted into the unified item number in the conversion history data 13d and converted into the dummy code. Then, the generation unit 15c determines whether the base item number included in the conversion history read out earlier matches the base item number included in the slip data converted into the unified item number. At this time, if the base item numbers of the two coincide, it can be determined that the slip data uploaded from the base server 30 is a correction slip of dummy data received in the past. In this case, the generation unit 15c includes a numerical item having a value obtained by inverting the value of the numerical item value included in the dummy data in order to erase the value of the numerical item that has been tabulated as dummy data in the past. After generating the consumption data, so-called red slip, the consumption data is registered as the totaling data 13c. If the base item numbers do not match, it is possible to determine that the slip data uploaded from the base server 30 is a new slip, so there is no need to generate consumption data. In addition, the production | generation part 15c registers the dummy data containing a dummy code as the data 13c for aggregation, when the base item number is converted into the dummy code by the conversion part 15b.

  The aggregation unit 15d is a processing unit that aggregates the values of the numerical items included in the aggregation data 13c using the summary level data 13e. As one aspect, the aggregation unit 15d refers to an attribute item whose granularity is set in the summary level data 13e when registration of the aggregation data 13c has been completed for all the slip data 13a, and Specify whether to be used as a summary key. Then, the aggregation unit 15d refers to the granularity of the attribute item as the aggregation key, and groups the aggregation data 13c that aggregates the values of the numerical items. In addition, the totaling unit 15d totals the values of the numerical items of the totaling data 13c for each group of the totaling data 13c determined in advance. In this way, summary data in which the slip data is summarized is generated by summing up the values of the numerical items of the summation data 13c.

  For example, when the granularity is set for all of “organization”, “period”, and “product name” in the summary level data 13e, three attribute items “organization”, “period”, and “product name” are displayed. Identified as a summary key. In this case, the data 13c for aggregation which belong to the same base, belong to the same month and whose unified item number belongs to the same unified product number are grouped. For this reason, the dummy data with the dummy code assigned to the unified item number and the consumption data are not grouped with the slip data having no dummy code.

  More specifically, it is assumed that the summary data 13c shown in FIG. 5 is aggregated using the summary level data 13e shown in FIG. In this case, three attribute items “organization”, “period”, and “product name” are specified as the aggregation key. The data 13c for the slip number “D001” and the slip number “D002” are both slip data collected from the same base 3, belong to the same April, and have a unified item number. Are set to the same unified product number “A” in the product master 13f. Therefore, the aggregation data 13c of the slip number “D001” and the slip number “D002” is grouped. On the other hand, the data 13c for the slip number “D003” and the slip number “D004” is slip data collected from the same base 3 and the sales date belongs to the same August. A dummy code is assigned to the unified product number of “D004”. Therefore, the aggregation data 13c of the slip number “D003” and the slip number “D004” is not grouped. The aggregation data 13c of the slip number “D003” and the slip number “D004” that have not been grouped in this way is not aggregated.

  Therefore, summary data shown in FIG. 9 is generated. FIG. 9 is a diagram illustrating an example of summary data. The example of FIG. 9 indicates that sales of 3000 yen are expected in April 2012 due to the sale of the product of the unified product number “A”. Furthermore, the example of FIG. 9 indicates that sales of 3000 yen are expected in August 2012 due to the sale of the product with the unified item number “B”. In the example of FIG. 9, although the site item number is unknown, it indicates that sales of 3000 yen are expected in August 2012 due to product sales. Further, “*” shown in FIG. 9 is inserted into attribute items that cannot be reproduced with the granularity of the summary data by being aggregated according to the granularity set in the summary level data 13e. For example, in the example of FIG. 9, since the items are not distinguished from each other in the value of the numerical item by being aggregated into the product type, “*” is added to the value of the unified item number at the time of aggregation.

  In addition, when “base” and “monthly” are set in the “organization” and “period” in the summary level data 13e, “organization” and “period” are specified as aggregation keys. , It is specified that the granularity of the attribute item as the aggregation key should be “base” and “monthly”. In this case, if the data for aggregation 13c belongs to the same base and the scheduled sales date belongs to the same month, even if the unified item number is different or a dummy code is assigned to the unified item number, it is the same Grouped into groups.

  The notification unit 15e is a processing unit that notifies the monitoring server 70 of the summary data in which the aggregation data 13c is aggregated by the aggregation unit 15d. As one aspect, the notification unit 15e notifies the monitoring server 70 of the summary data aggregated by the aggregation unit 15d. In addition, when the transmission of the summary data to the monitoring server 70 is completed, the notification unit 15e deletes the slip data 13a from the storage unit 13. This suppresses the same summary data from being transmitted to the monitoring server 70 a plurality of times.

[Concrete example]
Here, a specific example of deletion of dummy data will be described with reference to FIGS. FIG. 10 is a diagram illustrating an example of the aggregation data 13c. FIG. 11 is a diagram illustrating an example of summary data. FIG. 12 is a diagram illustrating an example of the conversion history data 13d. Here, a slip having the record of the slip number “D004” shown in FIG. 3 after the correspondence relationship between the base item number “L004” and the unified item number “S004” is added to the unified code master 13b shown in FIG. Assume that data is newly received as a dummy data correction slip.

  As described above, when the correspondence data of the base item number “L004” and the unified item number “S004” is added to the unified code master 13b and the slip data of the slip number “D004” is newly received, the slip of the slip number “D004” is received. The base item number “L004” included in the data is not converted into a dummy code as in the previous case, but is converted into a unified item number “S004”. Then, as shown in FIG. 10, the slip data of the slip number “D004” is registered as the totaling data 13c. Further, referring to the conversion history data 13d shown in FIG. 6, since the conversion history having the slip number “D004” and the base item number “L004” is registered, it is determined that this is a dummy data correction slip at this point. Is done. In this case, as shown in FIG. 10, consumption data including a numerical item having a value “−4000” obtained by inverting the sign of the planned sales value “4000” included in the dummy data is generated. The consumption data is further registered as totaling data 13c.

  Since these data for aggregation 13c are not grouped, the aggregation of numerical items is not executed, but the granularity of the attribute item is changed from item to product type, and the scheduled sales date is changed monthly to monitor data as summary data. 70 to be transmitted.

  As a result, in the monitoring server 70, when the summary data notified this time is added to the summary data shown in FIG. 9 that was previously notified, the summary data is updated as shown in FIG. That is, by adding the dummy code to the unified product number and adding the planned sales “-4000 yen” of the consumption data to the record whose scheduled sales date is August, the dummy code is added to the unified product number in FIG. The planned sales of the dummy data records that were included are zeroed and deleted. On the other hand, when the summary data shown in FIG. 9 is notified by adding the planned sales “4000 yen” to the record whose unified product number is “B” and the scheduled sales date is August, the planned sales The planned sales of the record of the unified product number “B” whose price is 3000 yen is updated to 7000 yen. In this way, the planned sales value of the slip data that can be converted to the unified code is aggregated again, and the planned sales value aggregated before the unified code update is erased from the aggregated value of the dummy data. Is included. Therefore, it is possible to prevent the planned sales value from being duplicated before and after the update of the unified code.

  Furthermore, the fourth record from the top having the slip number “D004” and the unified item number “S004” in the conversion history shown in FIG. 6 is updated to the conversion history shown in FIG. That is, since the base item number “L004” included in the slip data of the slip number “D004” is converted to the unified item number “S004” instead of the dummy code, the converted value of the conversion history is changed from the dummy code to “S004”. S004 "is updated. For this reason, it is possible to suppress the generation of duplicated data even when a dummy code correction slip is subsequently received.

  Note that various integrated circuits and electronic circuits can be employed for the control unit 15. In addition, a part of the functional unit included in the control unit 15 may be another integrated circuit or an electronic circuit. For example, an ASIC (Application Specific Integrated Circuit) is an example of the integrated circuit. Examples of the electronic circuit include a central processing unit (CPU) and a micro processing unit (MPU).

[Process flow]
Next, the flow of processing according to the present embodiment will be described. FIG. 13 is a flowchart illustrating the procedure of the aggregation process according to the first embodiment. This counting process is started when a predetermined period elapses after the summary data is generated last time or when a predetermined periodic time is reached.

  As shown in FIG. 13, the conversion unit 15b reads the slip data 13a from the storage unit 13 (step S101). Then, the conversion unit 15b searches the unified code master 13b for a unified item number corresponding to the base item number included in the slip data 13a (step S102).

  At this time, if the unified item number cannot be retrieved from the unified code master 13b (No at Step S103), the conversion unit 15b converts the base item number into a dummy code (Step S104). Then, the generation unit 15c registers the dummy data including the dummy code in the storage unit 13 as the aggregation data 13c (Step S105).

  On the other hand, when the unified item number can be retrieved from the unified code master 13b (Yes at Step S103), the conversion unit 15b converts the base item number into the unified item number (Step S106). Then, the generation unit 15c registers the slip data after conversion into the unified item number in the storage unit 13 as the aggregation data 13c (step S107).

  Thereafter, the generation unit 15c reads the conversion history having the same slip number as the slip number included in the slip data converted into the unified item number in the conversion history data 13d and converted into the dummy code (step S108). .

  Then, the generation unit 15c determines whether or not the base item number included in the conversion history read out earlier matches the base item number included in the slip data converted into the unified item number (step S109). .

  At this time, if the base item numbers of the two match (Yes in step S109), it can be determined that the slip data uploaded from the base server 30 is a correction slip of dummy data received in the past. Therefore, the generation unit 15c generates consumption data including a numerical item having a value obtained by inverting the value of the numerical item included in the dummy data, and then registers the consumption data as the aggregation data 13c ( Step S110).

  On the other hand, if the base item numbers do not match (No at Step S109), it can be determined that the slip data uploaded from the base server 30 is a new slip, and thus the process proceeds to Step S111 without generating consumption data. .

  Thereafter, the processes from step S101 to step S110 are repeatedly executed until the registration of the total data 13c is completed for all the slip data 13a (No in step S111).

  When the registration of the totaling data 13c is completed for all the slip data 13a (Yes at Step S111), the values of the numerical items included in the totaling data 13c are totaled using the summary level data 13e (Step S112).

  Subsequently, the notification unit 15e notifies the monitoring server 70 of the summary data in which the totaling data 13c is totaled by the totaling unit 15d (step S113). Thereafter, the conversion unit 15b updates the conversion history corresponding to the slip number included in the slip data 13a in the conversion history data 13d to the latest conversion history (step S114). Finally, the notification unit 15e deletes the slip data 13a from the storage unit 13 (step S115) and ends the process.

[Effect of Example 1]
As described above, the master server 10 according to this embodiment uses the unified code to count the values of the business data numerical values that can be converted from the dummy code to the unified code, and has been tabulated in the past. Erase the numeric item of dummy data. For this reason, in the master server 10 which concerns on a present Example, it can suppress that the value of a numerical item is counted twice before and after the update of a unified code. Therefore, according to the master server 10 according to the present embodiment, it is possible to suppress a situation in which aggregation consistency cannot be obtained.

  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.

[Business data]
For example, in the above-described first embodiment, a case where slip data related to a sales plan is collected as an example of business data is illustrated, but the disclosed system can be similarly applied to a case where business data other than a sales plan is collected. . As an example, the disclosed apparatus can collect business data such as a product procurement schedule or a procurement record as business data related to a sales department, in addition to a sales plan. As another example, the disclosed apparatus can also collect business data relating to production schedules, production results, consumption material use schedules, consumption material use results, defect results, and the like as business data related to the production department. As a further example, the disclosed apparatus can collect business data related to the budget and balance of each account item as business data related to the finance department. As another example, the disclosed apparatus can collect business data related to inventory, inventory adjustment, cost, etc. as business data related to the inventory management department.

[Consumption data generation timing]
In the first embodiment described above, the case has been described where dummy data consumption data is generated on condition that a dummy data correction slip is issued from the base server 30. However, dummy data correction is not necessarily required for generation of consumption data. No voucher is required. For example, the disclosed apparatus can also generate consumption data for the conversion history data 13d having the base code when the base code and the unified code are newly associated with the unified code master 13b. . In this case, it is not always necessary to accept a dummy data correction slip.

[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 unit 15a, the conversion unit 15b, the generation unit 15c, the aggregation unit 15d, or the notification unit 15e may be connected as an external device of the master server 10 via a network. In addition, the functions of the master server 10 described above are realized by having a receiving unit 15a, a converting unit 15b, a generating unit 15c, a totaling unit 15d, or a notifying unit 15e, which are connected to a network and cooperate. You may do it.

[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. 14 is a schematic diagram illustrating an example of a computer that executes a counting program according to the first and second embodiments. As illustrated in FIG. 14, the computer 100 includes an operation unit 110a, a speaker 110b, a camera 110c, a display 120, and a communication unit 130. Further, the computer 100 includes a CPU 150, a ROM 160, an HDD 170, and a RAM 180. These units 110 to 180 are connected via a bus 140.

  As shown in FIG. 14, the HDD 170 is preliminarily provided with a totaling program 170a that exhibits the same functions as the receiving unit 15a, the converting unit 15b, the generating unit 15c, the totaling unit 15d, and the notification unit 15e described in the first embodiment. Remembered. The aggregation program 170a may be integrated or separated as appropriate, like the respective components of the receiving unit 15a, the conversion unit 15b, the generation unit 15c, the aggregation unit 15d, and the notification unit 15e illustrated in FIG. In other words, all data stored in the HDD 170 need not always be stored in the HDD 170, and only data necessary for processing may be stored in the HDD 170.

  Then, the CPU 150 reads the aggregation program 170 a from the HDD 170 and expands it in the RAM 180. Thereby, as shown in FIG. 14, the aggregation program 170a functions as an aggregation process 180a. The aggregation process 180a expands various data read from the HDD 170 in an area allocated to itself on the RAM 180 as appropriate, and executes various processes based on the expanded data. The aggregation process 180a includes processing executed by the receiving unit 15a, the conversion unit 15b, the generation unit 15c, the aggregation unit 15d, and the notification unit 15e illustrated in FIG. 2, for example, the processing illustrated in FIG. In addition, each processing unit virtually realized on the CPU 150 does not always require that all processing units operate on the CPU 150, and only a processing unit necessary for the processing needs to be virtually realized.

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

1 monitoring system 3A, 3B, 3C base 5 head office 9 network 10 master server 11 communication I / F unit 13 storage unit 13a slip data 13b unified code master 13c data for aggregation 13d conversion history data 13e summary level data 13f product type master 15 control unit 15a reception unit 15b conversion unit 15c generation unit 15d aggregation unit 15e notification unit 30A, 30B, 30C base server 50 head office terminal 70 monitoring server

Claims (4)

On the computer,
Accept business data associated with business-related attribute items and numerical items from base servers connected via the network,
An attribute item included in the business data in a unified code storage unit that stores a base code of the attribute item defined by the base server and a unified code in which the base code of the attribute item is unified among the base servers If the site code is not registered, the site code of the attribute item is converted to a dummy code,
When the site code of the attribute item included in the business data is registered in the unified code storage unit, the site code of the attribute item is converted into a unified code,
Of the conversion history stored in the conversion history storage unit that stores the conversion history of the base code of the attribute item, the base code of the attribute item included in the conversion history converted to the dummy code, and the business converted to the unified code When the site code of the attribute item included in the data matches, the erased data of the dummy data in which the site code of the attribute item is converted to a dummy code, and the value of the numeric item included in the dummy data is deleted Generating consumption data
Using the business data, the dummy code of the attribute item included in the dummy data and the application data, the dummy code of the attribute item included in the dummy data and the application data, the business data, the dummy data, and the A tabulation program characterized by causing a process to count the values of numerical items of consumption data. As a process for generating the consumption data,
2. The tabulation program according to claim 1, wherein consumption data including a numerical item having a value obtained by inverting the value of a numerical item included in the dummy data is generated. A unified code storage unit for storing a base code of an attribute item defined by the base server and a base code in which the base code of the attribute item is unified between the base servers;
A conversion history storage unit for storing the conversion history of the base code of the attribute item;
A reception unit that receives business data associated with business-related attribute items and numerical items from a base server connected via a network;
When the base code of the attribute item included in the business data is registered in the unified code storage unit, the base code of the attribute item contained in the business data is converted to the unified code Is not registered in the unified code storage unit, a conversion unit for converting the base code of the attribute item into a dummy code,
Of the conversion history stored in the conversion history storage unit, the base code of the attribute item included in the conversion history converted to the dummy code, the base code of the attribute item included in the business data converted to the unified code A generation unit for generating consumption data for erasing the value of the numeric item included in the dummy data, wherein the base code of the attribute item is converted to the dummy code when ,
Using the business data, the dummy code of the attribute item included in the dummy data and the application data, the dummy code of the attribute item included in the dummy data and the application data, the business data, the dummy data, and the A tally device comprising: a tally unit for tallying the values of numerical items of consumption data. Computer
Accept business data associated with business-related attribute items and numerical items from base servers connected via the network,
An attribute item included in the business data in a unified code storage unit that stores a base code of the attribute item defined by the base server and a unified code in which the base code of the attribute item is unified among the base servers If the site code is not registered, the site code of the attribute item is converted to a dummy code,
When the site code of the attribute item included in the business data is registered in the unified code storage unit, the site code of the attribute item is converted into a unified code,
Of the conversion history stored in the conversion history storage unit that stores the conversion history of the base code of the attribute item, the base code of the attribute item included in the conversion history converted to the dummy code, and the business converted to the unified code When the site code of the attribute item included in the data matches, the erased data of the dummy data in which the site code of the attribute item is converted to a dummy code, and the value of the numeric item included in the dummy data is deleted Generating consumption data
Using the business data, the dummy code of the attribute item included in the dummy data and the application data, the dummy code of the attribute item included in the dummy data and the application data, the business data, the dummy data, and the An aggregation method characterized by executing a process for aggregating the values of numerical items of consumption data.

Images