JPH06149781A - Data processor - Google Patents

Abstract

PURPOSE:To read only records corresponding to the definition contents of a totalization definition table out of a specific file and classify and totalize the records in hierarchical structure corresponding to a totalization level only by optionally defining a totalization object by totalization levels by a person in charge who does not have technical knowledge by using the totalization definition table. CONSTITUTION:A parameter setting part 2 arranges the data names in the items constituting the records to be totalized and the record names of the totalization levels on a display screen in the column or row direction to display the index part of a table B. When an optional intersection position on the matrix consisting of the index part of the table B is specified at an input part 1, the data name corresponding to the intersection position is detected. Then a data extraction processing part 5 reads records containing the data name out of the data file 10. Consequently, the read records are totalized by the record names corresponding to the totalization level.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data processing device for collecting record data from accounting files, personnel files, etc. in office computers, personal computers and the like.

[0002]

2. Description of the Related Art Conventionally, in an office processing device such as an office computer or a general-purpose computer, an accounting file,
Various types of files such as personnel files, sales slip files, inventory files, etc. are stored and managed, but the record structure that constitutes each file is different for each file.
The same record form (records in which each item that constitutes a record matches) is collectively managed as a separate file. Here, when you specify an arbitrary item and read the record containing that item from the file and classify and aggregate it, even if you make a classification code system that makes it easy to classify and aggregate the data in the item first, As a result, the classification does not actually fit, and it is not possible to perform the classification and aggregation as it is. Therefore, conventionally, as a countermeasure, a code conversion table for classification and aggregation is provided, and a method of performing classification and aggregation by converting the code system suitable for classification and aggregation using this code conversion table is widely adopted at present.

[0003]

However, in the method using the code conversion table, a system engineer who is an expert has to create a code system (conversion table) for classification and aggregation. That is, creating a classification code system according to various business needs requires extremely specialized and sophisticated knowledge, so it is extremely difficult for a general user's business person to create it. The current situation was that we had to ask the system engineer to create it. An object of the present invention is to simply define an aggregation target for each aggregation level using an aggregation definition table when a person in charge of business who does not have specialized knowledge wants to create an aggregation table according to its business purpose. The records corresponding to the definition contents of the tabulation definition table are read out from a predetermined file, and the records can be classified and tabulated in a hierarchical structure according to the tabulation level.

[0004]

Means for Solving the Problems The means of the first invention is as follows. (1A), the display means arranges the data name in the item constituting the record to be aggregated and the record name of the aggregated record for each aggregate level as a heading on the display screen to display the heading section of the aggregate definition table. A display device or the like. The data name and record name may be expressed by either a code or a character. When the item designating means for designating an arbitrary item constituting the record to be aggregated as the aggregation target item is provided, the display means displays the data names in the items designated by the item designating means in a predetermined name table. It may be read out and arranged in the heading section on the display screen to be displayed. Further, the display means may identify and display the record name of the totalized record in correspondence with the totalization level, or the display means may read out the record name of the totalized record from a predetermined name table and display the heading portion on the display screen. You may make it arrange | position and display it. (2A), the aggregation target designating unit designates an arbitrary intersection position on the matrix constituted by the heading section of the aggregation definition table as an aggregation target, and is, for example, a keyboard or a mouse as a pointing device. The totaling target designating means may specify the totaling target by inputting a symbol at the intersection point on the matrix forming the totaling definition table. (3A), the detection means detects, for each record name corresponding to the aggregation level, the data name of the aggregated record corresponding to each intersection point position designated by the aggregation target designating means. (4A), the reading means reads each record to be counted including the data name detected by the detecting means from a predetermined file. (5A), the totaling means totalizes the totaled records read by the reading means for each record name corresponding to the totaling level. In addition, when a plurality of data names in the same item forming the record to be aggregated are designated by the aggregation target designating means and data names in other items are also designated, the aggregating means determines the data in the same item. At the same time as the logical sum condition of the names, the summed records including the data names that satisfy the logical product condition of the data names between the items may be totaled.
The means of the second invention is as follows. (1B), the display means arranges the item names constituting the aggregated records of the original data to be aggregated and the record name of the aggregated record for each aggregate level to be generated as a heading on the display screen, and the heading portion of the aggregate definition table Is a CRT display device or the like. (2B), the aggregation target designating means, for each record name corresponding to the aggregation level in the aggregation definition table, assigns a data name or code as the aggregation target item data to be input at the corresponding position of the record name and the item name. It is a designated keyboard or mouse. (3B), the reading means reads, for each record name corresponding to the aggregation level, each aggregated record including the item data designated by the aggregation target designating means from a predetermined file. (4B), the totaling means totalizes the totaled records read by the reading means for each record name corresponding to the totaling level.

[0005]

The operation of the means of the first invention is as follows. Now, the data name in the items that make up the aggregated record of the original data to be aggregated and the record name of the aggregated record for each aggregation level to be generated are placed as headings on the display screen and the heading section of the aggregate definition table is displayed. In this state, the person in charge of business specifies an arbitrary intersection point position on the matrix constituted by the heading section of the aggregation definition table as the aggregation target. Then, for each record name corresponding to the aggregation level, the data name of the record to be aggregated corresponding to each intersection point designated by the aggregation target designating means is detected, and each record to be aggregated including this data name is extracted from the predetermined file. After being read, this counted record is totaled for each record name corresponding to the total level. The operation of the means of the second invention is as follows. Now, the item names that make up the aggregated records of the original data to be aggregated and the record name of the aggregated record for each aggregation level to be generated are placed as headings on the display screen and the heading part of the aggregate definition table is displayed In, the business operator designates, for each record name corresponding to the totaling level, a data name or a code as the totaling item data to be input at the corresponding position of the record name and the item name. Then, for each record name corresponding to the aggregation level, each aggregated record including the item data designated by the aggregation target designating means is read from the predetermined file, and this aggregated record corresponds to the aggregation level. It is totaled for each record name. Therefore, a person in charge of business who does not have specialized knowledge can simply define the aggregation target for each aggregation level using the aggregation definition table, and the records corresponding to the definition contents of this aggregation definition table will be stored in the specified file. The records can be read out and classified and aggregated in a hierarchical structure according to the aggregation level.

[0006]

[First Embodiment] A first embodiment will be described below with reference to FIGS. FIG. 1 is a block diagram of the data processing apparatus according to this embodiment. This data processing device constitutes an office computer, and its main components are an input unit 1, a parameter setting unit 2, a CRT display unit 3, a configuration file generation unit 4, a data extraction processing unit 5, and a development aggregation processing unit 6. In addition to the horizontal calculation processing unit 7 and the print processing unit 8, various files, that is, a file recognition table 9, a data file 10, a table file 11, and a parameter file 1
2. The configuration has a file disk device (not shown) for storing the configuration file 13, the primary totalization file 14, and the secondary totalization file 15.

The input unit 1 is a key input device for inputting various data and commands, and the data input from the input unit 1 is taken into a parameter setting unit 2 and processed. Here, the input unit 1 responds to the key operation by the parameter setting unit 2
And a start instruction to the data extraction processing unit 5. The parameter setting unit 2 operates in response to the start command from the input unit 1, and defines the total contents and print items at the time of total printing in order to instruct arbitrary totalization of records desired by the person in charge of business. Definition table to be defined (3 types of A in this embodiment)
A table, a table B, and a table C) are generated according to the data and the like input from the input unit 1, and are displayed and output on the CRT display unit 3.
It should be noted that the tables A, B, and C will be described in detail later, and therefore will be briefly described here. For example, the A table is configured as shown in FIG. 4, the B table is configured as shown in FIG. 5, and the C table is configured as shown in FIG. 6, and the A table is a definition table that defines aggregate data,
The table B is a definition table that defines the records to be extracted as the totalized record for each totaling level, and the table C is a definition table that defines the print items, the printing order, and the like at the time of totalizing printing. Further, the parameter setting unit 2 generates a definition table (table A, table B, table C) based on the data input from the input unit 1, and also refers to the file recognition table 9 and the data file 10 as necessary. By doing so, the data obtained as input candidates can be displayed in a list on the window screen, and the definition table can be generated based on the data arbitrarily selected from the list display. Then, when the parameter setting unit 2 generates the A table, the B table, and the C table, they are set in the parameter file 12, and then the activation instruction is given to the configuration file generating unit 4. The configuration file generator 4 creates the configuration file 13 by referring to the parameters of the B table in the parameter file 12, and the configuration file 13 has a hierarchical structure according to the aggregation level defined in the B table. Is a file that represents.

The data extraction processing unit 5 operates in accordance with a start instruction from the input unit 1 when executing record aggregation, reads the parameters of the table A from the parameter file 12, and extracts the corresponding record from the data file 10 based on this. After the data is stored in the primary totalization file 14, a start command is given to the expansion totalization processing unit 6. The data file 10 is a file that stores the record data corresponding to various files. The expansion totalization processing unit 6 generates a secondary totalization file 15 based on the primary totalization file 14 and the configuration file 13. The secondary totalization file 15
After generating, the start instruction is given to the horizontal calculation processing unit 7.
The horizontal calculation processing unit 7 sets the contents of the secondary totalization file 15 to 1 according to the parameters of the table C in the parameter file 12.
A table calculation (horizontal calculation) is performed for each record, and the calculation result is given to the print processing unit 8 record by record while the print processing unit 8 is activated. The print processing unit 8 sequentially prints out the calculation result from the horizontal calculation processing unit 7 and the predetermined data read from the secondary totalization file 15 one record at a time along with the ruled line format according to the parameters of the C table in the parameter file 12. , Form 16 is created.

On the other hand, the file recognition table 9 stores the file structure of various files stored in the data file 10, and FIG. 2 shows the file recognition table of the accounting file. That is, the accounting file has a plurality of items (for example, as shown in the "item name" column in the figure).
"Type No.", "Organization C (code)", "Destination C (code)", "Item C (code)" ... "Account C (code)", ... "Debit amount", "Credit amount" ] ...) is a record structure. Further, in the file recognition table of the accounting file, each item name of the accounting file and a table to be referred to among the various tables stored in the table file 11 (listed in the column of “corresponding T” in the drawing). Table) is set. For example, the accounting file item name "organization code" corresponds to the "organization table" as a reference table, and the accounting file item name "destination code" corresponds to the reference table "destination table". There is. In addition, in the accounting file that constitutes this file recognition table, the correspondence relationship between each item name of the accounting file and the input slip for each type of input slip (transfer slip, sales slip, purchase slip ...) is set. ing. In this case, according to the item names “debit amount” and “credit amount” of the accounting file, two types of correspondence are set for each input slip in the same slip.

The table file 11 stores various reference tables. FIG. 3A shows a destination table in which destination codes and names represented by characters are stored in correspondence with each other, and FIG. 3B shows the table. Is an item table that stores the item code and the name represented by the character in association with each other, FIG.
(C) indicates a name table for sequentially storing names represented by various characters.

Next, the operation of this embodiment will be described with reference to FIGS. First, various definition tables (A table, B table, C
When a creation instruction is given from the input unit 1 to generate the (table), the parameter setting unit 2 operates in response to this. Here, at the time of generating the A table, the parameter setting unit 2 displays and outputs the table frame, the title name, and the like on the CRT screen according to the format of the A table that is predetermined.

FIG. 4 shows the display state of table A. First, “accounting file” is defined as the source file, and “organization code = 8 *” is defined as the target range. The highest digit of "organization code = 8 *" is "8"
The organization (for example, sales) represented by is shown. Also,
Aggregated data is defined in the table frame of table A. Here, in the table frame, "item name", "extracted data", "condition"
In the first line, the "item name" is "sales amount 1", the "extracted data" is "debit amount", and the "condition" is "account code = domestic". "Sales, export sales, trilateral sales" are defined. The definition content of the first line is that the data content of the item "account code" of the accounting file is "domestic sales", "export sales", "trilateral sales".
The record corresponding to any of the above is used as the search condition, the corresponding record satisfying any of these conditions is extracted, and the data in the item "debit amount" defined as "extracted data" of this corresponding record is extracted. However, this extracted data is set as the item of “sales amount 1”. In this way, the data of the item names "sales amount 1", "sales amount 2", "return item 1", "return item 2", "discount amount 1", and "discount amount 2" are shown in Table A. It is defined as aggregated data in the frame.

The "item name" in the table frame of table A is data which is arbitrarily input from the input unit 1 and set. In addition, when setting “extracted data”, the parameter setting unit 2 uses the “item name” of the accounting file in the file recognition table 9.
Is displayed as a list on the window screen, and the item name arbitrarily selected by key operation from this list display is set as extracted data. Similarly, when setting the “condition”, the parameter setting unit 2 uses the file recognition table 9
The item names of the accounting files in the list are displayed in a list on the window screen, and the accounting files in the file recognition table 9 are accessed according to the item names arbitrarily selected from this list display and selected. The table corresponding to the "item name" is recognized, the corresponding table is read from the table file 11, the contents of the table are displayed in a list on the window screen, and the data arbitrarily selected from this list display is set as the condition data. It is a thing. On the other hand, in the table A, for example, "item" and "destination" are further defined as items to be totalized, and they are designated in the window similarly to the above. The table B is generated according to the items to be totaled.

When the table A is generated in this way, the parameter setting unit 2 creates the table B based on this. FIG. 5 shows the display state of table B. FIG. 7 is a flowchart showing the operation of the parameter setting unit 2 when generating the heading section of the B table. First, the parameter setting unit 2 checks, for each item defined as an item to be totalized in the table A, whether or not the process of generating the heading portion of the table B has been completed (step A1). Now, in Table A, "item" and "destination" are defined as items to be totaled, so the parameter setting unit 2 first pays attention to the first item, "item", and refers to the file recognition table 9. The corresponding item in the source file (accounting file) defined in Table A is accessed and the contents of the item table (see (B) in FIG. 3) in the table file 11 associated with this item are shown in Table B. Are sequentially output in the column direction to generate a heading section for "item" (step A3). For example, as shown in FIG. 5, the name of the data name “radio” and its item code “10” corresponding to the “item”, the name of the data name “TV” and its item code “11”, ... …
Is displayed as the item heading of table B. When the item heading is generated, the parameter setting unit 2 also displays the format of the table frame or the like that constitutes the heading.

Next, the parameter setting unit 2 executes the same processing (steps A2 and A3) as described above for the next item "destination" defined as the item to be totaled, thereby finding the "destination". Produce a copy. Even in this case, the parameter setting unit 2 uses the corresponding table in the table file 11 (destination table shown in FIG. 3A).
By expanding the table contents as the heading of the table B by referring to, for example, as shown in FIG. 5, the name of the data name “domestic” and its destination in the item corresponding to “destination” The place code "00", the data name "Europe", and the destination code "02" ... Are displayed as the item headings of the table B. Although the name and the code are displayed as the data name, either one may be displayed as the data name.

When the item headline generation process is completed, the flow advances to step A4 to display the total structure level together with the format of the headline section. At that time, the parameter setting unit 2
First tentatively generates three display levels A, B, and C and outputs them for display. Thereafter, in order to arbitrarily increase or decrease the number of aggregation structure levels, the presence or absence of a level number setting change request is checked (step A5). If there is no change request, the headline generation processing ends at this point, If there is a setting change request, the total level is inserted or deleted in the column direction of table B according to the changed number of levels (step A6).

When the heading section of the B table is generated, the person in charge of business writes an arbitrary name as the record name of the totaling record in the heading section of the tabulation structure of the B table corresponding to each level. Here, in the table B shown in FIG. 5, the record name name “audio” is assigned to the row No. “001”, the record name name “video” is assigned to the row No. “007” in correspondence with the aggregation level A. Is written, and the record name is “domestic” and line N is in line No. “002” corresponding to the aggregation level B.
o The record name “Export” ... is written in “003”, and the line number “004” corresponds to the aggregation level C.
The record name "Europe" is written in, and the record name "US" is written in line No. "005". In addition,
The record name is not written in the row No. “006” for any of the aggregation levels for the reason described later. On the other hand, the aggregation levels A, B, and C have a hierarchical structure in which the left end (aggregation level A) has the highest level in the figure, and the levels gradually decrease toward the right side. In the example of FIG. 5, A> B > C.

In the above example, when the record name is input for each totaling level, the record name is directly input from the input section 1. However, if the record name to be used is predetermined, these are used. The scheduled record name may be stored in a table, and when writing the record name, the table contents may be displayed in a list on the window screen, and the record name may be written by arbitrarily selecting from the list. The record name is not limited to the name but may be a code.

Next, the person in charge of business sequentially designates, from the input section 1, an arbitrary intersection point position on the matrix constituted by the heading section of the table B as a counting target. In this case, a symbol (circle) as shown in FIG. 5 is displayed at the position designated as the aggregation target. For example, for the row No. “002”, that is, for the record name “domestic” corresponding to the aggregation level B, circles are displayed at the positions of the data names “radio”, “stereo”, and “radio cassette”, In addition to indicating that the data name has been designated as the aggregation target, a circle is displayed at the position of the data name “domestic” of the destination, indicating that the data name has been designated as the aggregation target.

Here, as in the case of line No. "002",
If multiple data names "radio", "stereo", and "radio cassette" are specified in the same item, and data names "domestic" in other items are also specified, the data names of the same item It defines that records that include a data name that satisfies the logical product condition of the data names between the items at the same time as the logical sum condition are to be aggregated. Further, as described above, the record name is not written in the line No. “006”, but in this case, the data name “video” of the item and the data name “Asia” of the destination are written in the line No. “006”. Since the circles are displayed respectively, the record including the data name corresponding to these logical product conditions becomes the record corresponding to the definition content of the line No. “006”, and this line No. “006”
Corresponding to the record and the line No. "00 one line before that"
"5" should be summed with each other, that is, a logical sum is defined. In other words, the line in which the record name is not written is associated with the line in which the record name is written before, and defines that the corresponding records in each line should be summed.

Next, the case of generating the C table will be described. FIG. 6 is a display state diagram of the C table, and the parameter setting unit 2 displays and outputs the format of the title name, the table frame, and the like constituting the C table. In this state, after inputting the "print title, for example, display management table (sales)" from the input section 1, the "item name" to be printed in the print order in the table frame and the corresponding item data are input. Enter the "calculation formula" for calculation, the "unit" of the calculation result, and the "column width" of the item print column. Here, in the table C shown in FIG. 6, as print item names, "total sales", "sales discount",
“Sales return” ... is defined, and what should be printed in this order is defined. In addition, the first item, "total sales", is defined by a calculation formula, that is, "sales 1-sales 2", and it is defined that the result should be printed in units of 1,000 yen. The width is defined to be 10 digit size. Similarly, the second item "Sales discount" is calculated by "Discount 1-Discount 2", and it is defined that the result should be printed in units of 1,000 yen, and the column width is an 8-digit size. It is defined that there is. In the figure, the unit "-
"2R" indicates that the second digit of the decimal point should be rounded.

As described above, the parameter setting unit 2
When the table, the table B, and the table C are generated, these are set in the parameter file 12, and then the configuration file generator 4 is operated. FIG. 8 is a flowchart showing the operation of the configuration file generating unit 4, and FIG. 9 is a diagram for specifically explaining the operation content of the configuration file generating unit 4. First, the configuration file generator 4 reads the parameters of the table B from the parameter file 12 for one line from the top line (step B1).
Then, at the next step B2, is the data end, that is,
It is checked whether or not all the data from the first line to the last line of table B has been read from the parameter file 12. At first, the first row of the table B is focused on, and the parameter is read from the parameter file 12. Therefore, the process proceeds to the next step B3, and it is checked whether the counting level of the focused row is the highest level A or not. . Now, since the first row of the table B shown in FIG. 5 is the level A, the process proceeds to step A4, and the final item work memory shown in FIG. 9B in the configuration file generator 4 is written. First, since the top row of the table B is the total level A and the row No is "001", the combination of this level and the row No is shown as the level row "A001" in FIG. 9B. As shown in the drawing, the final item work memory is written, and the record name "audio" is written in the final item work memory in association with the level line.

Next, the process proceeds to step B5, and the intersection position marked with a circle in the target line is searched. However, since there is no intersection marked with a circle in the first line, the process returns from step B6 to step B1. , B, paying attention to the next line of the table, the parameter of the line of interest is read from the parameter file 12. Now, since the second line is the summarization level B, the process proceeds to step B9, and the target line is an empty line in which the record name is not written, that is, the record name is set to any level such as the line No. “006” described above. Checks if is an empty line that has not been written. Since "Domestic" is written as the record name in the second line, the process proceeds to step B10.
Execute the process to generate the aggregation code. FIG. 9A shows the generation state of the totalization code. The totalization code includes “child code”, “parent code”, “end flag”,
It consists of "name". The child code “B002” is a code generated by adding the line No. “002” to the totaling level B of the second line, which is the line of interest, and the parent code “A00”.
“1” is obtained by searching the last item work memory shown in FIG. 9B and reading out the level row that is one step higher than the aggregation level of the row of interest. The final flag is a flag that becomes “1” when the aggregation level of the corresponding parent code is A. . The name "audio" is a name corresponding to the level row "A001" read from the last item work memory shown in FIG. 9B. The tabulation code generated in this way is written to the configuration file 13 (step B1).
1)

Next, in step B4, as in the first row of table B, the second row is also written into the last item work memory in the configuration file generating section 4. in this case,
As shown in FIG. 9B, "B002" is written as the level line and "domestic" as the name in the final item work memory. Then, the intersection search process is executed (step B5), but as shown in FIG. 5, the second line is marked with three circles corresponding to "item" and one circle corresponding to "destination". Therefore, the process proceeds to the generation process of the totalization code accordingly (step B7). Although the total code generation process in this case is different from the generation process in step B10 described above, the total data in this case also includes a child code, a parent code, an end flag, and a name. Child code "1000"
Is a combination code that is a combination of the item code “10” of “radio” and the destination code “00” of “domestic” that are designated as aggregation targets. Parent code "B002"
Is a code in which the line No. “002” is added to the aggregation level B of the line of interest, and the end flag is a flag which becomes “1” when the parent code includes the aggregation level A as in the above. The name "domestic" is the record name of the line of interest. The tabulation code generated in this way is written to the configuration file 13 (step B8).

Then, the process returns to step B5, and the total code generation process starts again (step B7). In this case, the child code is the code "1400" which is a combination of the item code "14" of "stereo" and the domestic destination code "00". The other parent codes, end flags, and names are the same as those in the above case. Then, after the totalization code is written in the configuration file 13, the totalization code is further generated (step B7). Even in this case, only the child code is different, and the child code is the combination code “1500” which is a combination of the item code “15” of “radio cassette” and the destination code “00” of “domestic”. In this way, when the three totalization codes are written in the configuration file 13 corresponding to the second line, it is detected in step B6 that the process of the second line is completed. Then, returning to step B1, paying attention to the third line of the B table, reading the parameter, and thereafter, the same operation as described above is repeated line by line up to the last line of the B table to generate the configuration file 13.

FIG. 10 shows the configuration file 13, and each record of this configuration file 13 is composed of "child code", "parent code", "end flag", and "name", and the file content is B in FIG. It is generated by referring to the table,
The first to fourth records of the configuration file 13 correspond to the first and second rows of table B.

Now, the tables A, B, and C as described above have been generated, and the configuration file 13 is based on this table B.
In the state in which the
When a record total is instructed from, the data extraction processing unit 5 starts the operation in response to the instruction. Data extraction processing unit 5 The parameters of the table A are read from the parameter file 12, and the data file 1 is read based on the contents of the aggregated data.
The relevant record is extracted from 0, and this extracted record is stored in the primary totalization file 14. That is, since the table A is now defined as shown in FIG. 4, the data extraction processing unit 5 determines the record structure of the primary totalization file 14 based on this. FIG. 11 shows the primary totalization file 14, and the record structure of this primary totalization file 14 is a “combination code” in which an item code and a destination code are combined,
It consists of "sales money 1", "sales money 2", "return money 1", "return money 2", "discount money 1", and "discount money 2". In addition,
The combination code of the item and the destination corresponds to the number of combinations of all the items and the destination.

First, the data extraction processing unit 5 pays attention to the first line of the aggregated data in the table A and extracts the corresponding record from the data file 10 according to the definition contents. That is,
The data extraction processing unit 5 pays attention to the condition of the table A and finds a record in which the "account" having the record item in the accounting file corresponds to "domestic sales", "export sales", or "trilateral sales". As a search condition, the corresponding records that satisfy any of these conditions are retrieved and "extracted data"
Data in the item "credit amount" defined as is extracted from the corresponding record, and this extracted data is used as item data of "sales amount 1" of the primary totalization file 14. Also, A
Focusing on the second row of the table, the record that meets any of the search conditions is extracted, and the data in the item "Debit amount" defined as the extracted data is extracted from the applicable record. The item data of “sales amount 2” in the aggregation file 14 is used. Hereinafter, with respect to the other items “returned money 1” and “discount 2” that constitute the primary totalization file 14, corresponding item data is extracted by referring to the table A in the same manner as described above.

When the primary totalization file 14 is generated in this way, the data extraction processing unit 5 activates the expansion totalization processing unit 6. Then, the development totalization processing unit 6 executes the operation according to the flowchart of FIG. Note that FIG.
FIG. 6 is a diagram for specifically explaining the operation content of the expansion totalization processing unit 6. The development totalization processing unit 6 uses the primary totalization file 14
The secondary totalization file 15 is generated based on the contents of the above and the contents of the configuration file 13 in accordance with the component expansion method. 14
Indicates the secondary totalization file 15, and the record structure of the secondary totalization file 15 is “print order”, “level”, “name”, “sales amount 1”, “sales amount 2”, “return amount 1”. ,
It consists of "return money 2", "discount 1", and "discount 2".
The “print order” is the parent code of the configuration file 13 (see FIG. 1).
This indicates that printing should be performed according to the arrangement order of the number string (row No. of table B) in the reference numeral 0).

First, the expansion totalization processing unit 6 reads data for one record from the beginning of the primary totalization file 14 (step C1). Then, in the next step C2, it is checked whether the data ends, that is, whether all the records have been read from the beginning of the primary totalization file 14. Initially,
Since this is the case where one record's worth of data has been read from the beginning of the primary totalization file 14, the process proceeds to the next step C3, the contents of the configuration file 13 are searched, and the item code and destination code of the primary totalization file 14 are combined. The child code of the configuration file 13 that matches the combination code is searched. Now, as shown in FIG. 11, the item code + destination code that constitutes the first record of the primary totalization file 14 is “1000”, and in the configuration file 13, as shown in FIG. Exists, it is detected in step C3, and the process proceeds to step C4 to generate a record of the secondary totalization file 15. Here, (A) of FIG. 13 is a diagrammatic representation of the operation contents at the time of generating this record. First, the expansion and aggregation processing unit 6 reads the parent code corresponding to this child code from the configuration file 13, and the parent code The alphabetic characters (summary level) and number strings (row B in table B
o), and the row No. is placed in the first item of the secondary tally file 15, and the tally level is placed in the next item. Then, the name corresponding to this child code is read from the configuration file 13 and placed in the third item of the secondary totalization file 15. Subsequent to this, “sales amount 1”, “sales amount 2”, “return money amount 1”, ... “Discount amount 2” of the primary aggregation file 14 are sequentially arranged in the corresponding items of the secondary aggregation file 15.

As a result, 1 of the secondary totalization file 15 is obtained.
When the data for the records is generated, the generated records are written to the secondary totalization file 15. At that time, if records of the same type already exist in the secondary totalization file 15, they are converted into one record. The data is totalized and written in the secondary totalization file 15, and if there is no record of the same type, the record generated this time is added to the secondary totalization file 15 (step 5).

Next, the relevant end flag in the configuration file 13 is referred to and it is checked whether or not it is "1" (step C6). Here, the end flag in the configuration file 13 is "1" when the aggregation level of the parent code is A, and when the termination flag is "1" (when the aggregation level of the parent code is A). Returns to step C3 as it is, but if the end flag is not "1" (when the aggregation level of the parent code is B, C, etc.), it is written to the primary aggregation file 14 (step C7). In this case, a record as shown in FIG. 13B is generated and returned to the primary totalization file 14. That is, the corresponding parent code of the configuration file 13 is placed in the first item, and subsequently, the records in which “sales amount 1”, “sales amount 2”, ... Write to 14. In the primary totalization file 14 shown in FIG. 11, the records arranged below the broken line in the figure represent the records returned from the expansion totalization processing unit 6 to the primary totalization file 14. After that, the process returns to step C3, and thereafter, the entire contents of the configuration file 13 are searched, and the above operation is repeated until the corresponding record is not detected. As a result, when no corresponding record is detected in step C3 and the mismatch ends, the process returns to step C1 and the next record is read from the primary tabulation file 14. Such an operation is performed for all records in the primary tabulation file 14. . Then, the end of data is detected in step C1 and the process proceeds to step C8, where 1
The records constituting 5 are sorted in ascending order according to the contents of the first item. FIG. 14 shows the contents of the secondary totalization file 15 after sorting.

Thereafter, the expansion totalization processing unit 6 activates the horizontal calculation processing unit 7. The horizontal calculation processing unit 7 is the secondary aggregation file 1
5 and the C table in the parameter file 12 are used to calculate each item. Now, since the C table is defined as shown in FIG. 6, the horizontal calculation processing unit 7 first pays attention to the first record (name: audio) of the secondary totalization file 15, and selects the "total" defined in the C table. "Sales" is calculated. In this case, "sales amount 1" and "sales amount 2" are read from the first record of the secondary totaling file 15, and "sales amount 1-sales amount 2" is read.
The calculation is performed, and the calculation result is defined as “total sales” of “audio”. Next, the "sales discount" in Table C is calculated, and the calculation result of "discount discount 1-discount discount 2" is taken as "sales discount" of "audio". Hereinafter, the “return sales”, “total sales amount”, “return rate”, and the like of “audio” are obtained according to the definition contents of Table C. Then, the horizontal calculation processing unit 7
Pays attention to the next record of the secondary aggregation file 15, and hereinafter, for "domestic", "total sales", "sales discount",
"Sales return", "Net sales", "Return rate" etc. are requested. In this way, every time the contents of the secondary totalization file 15 are calculated record by record according to the table C, the horizontal calculation processing unit 7 gives the calculation result for one record to the print processing unit 8.

Then, the print processing unit 8 prints the data from the lateral calculation processing unit 7 and the data from the secondary totalization file 15 according to the definition contents of the C table. FIG. 15 shows the printing result in this case. That is, first, the print processing unit 8
Read the title (sales management table (sales)) from the table and print it. Next, the item names (total sales, sales discount ...) Defined in Table C are printed together with the format. In this case, the print order of item names will be the definition order of table C, and
The column width of each item follows the definition in Table C.

Next, the print processing unit 8 uses the secondary tabulation file 1
According to the “printing order” of 5, the “totaling level” and the “name” are read from the secondary totaling file 15, and the “name” is printed together with the format of the hierarchical structure according to the totaling level. In this case, the name "audio" is first printed together with the format of the aggregation level A. Next, the print processing unit 8 prints the calculation results of “total sales”, “sales discount”, “sales return” ... Obtained by the horizontal calculation processing unit 7 corresponding to this name. As a result, data for one record is printed. Thereafter, similarly, the print processing unit 8 prints data for each record in accordance with the printing order in the secondary totalization file 15 together with the format of the hierarchical structure according to the totalization level. As a result, the form 16 as shown in FIG. 15 is obtained. In this case, since the names “audio”, “domestic”, “export”, etc. printed on the form 16 are bounded by ruled lines for each level, it is possible to easily identify the hierarchical structure according to the aggregation level.

As described above, in this embodiment, Table A, B
When the table and the C table are arbitrarily defined, the contents of arbitrary record items are read out from a predetermined file according to the definition contents and classified and aggregated, and the aggregated results are printed in a hierarchical structure. The desired form can be obtained. That is, when an arbitrary item is designated in advance in Table A as an item to be totaled, the data name in each item designated as the item to be totaled is listed in the heading section of Table B. Then, an arbitrary name is entered in this B table for each aggregation level to make it the heading section of the B table, and a circle mark is input at an arbitrary intersection point position on the matrix constituted by the respective heading sections. If you specify the position as the aggregation target,
The data name designated as the aggregation target is detected for each name corresponding to the aggregation level, records including this data name are read from the source file, and are aggregated for each name corresponding to the aggregation level. As a result, by simply defining the aggregation target for each aggregation level using the aggregation definition table, the records corresponding to the definition contents of this aggregation definition table are read from the specified file and the hierarchy corresponding to the aggregation level is obtained. It becomes possible to perform classification and aggregation of structures.

[0037]

[Second Embodiment] A second embodiment will be described below with reference to FIG. The data processing apparatus of the present embodiment is also configured similarly to that of FIG. 1, so description thereof will be omitted, but in this embodiment, a part of table B is different from that of the first embodiment.
That is, in the first embodiment described above, an arbitrary intersection point position on the matrix constituted by the heading portion of the B table is designated as the aggregation target, but the B table of the present embodiment is configured as shown in FIG. There is. Here, the heading section of the aggregation structure level is configured in the same manner as in FIG. 5, but the data names such as “radio” and “television” as shown in FIG. 5 are listed in the heading section of the item. Instead, instead of this, in the present embodiment, for each record name corresponding to the aggregation level, the item code, the destination code, etc. are respectively associated with the items to be aggregated (for example, "item" and "destination"). A code input area for inputting is provided. That is, an item code input area and a destination code input area are provided in the table B shown in FIG.

In this way, in the code input area provided in the table B, the item code or the destination code is input as the totaling target for each record name corresponding to the totaling level. In the table B of FIG. 16, the item code “1
Enter "0" and destination code "99" as aggregation targets. Also, in the second line, item code "10", "14", "15".
And the destination code “00” is input as the aggregation target. As described above, also in this embodiment in which the code is directly input to specify the aggregation target, the same aggregation processing as in the first embodiment is performed, and the print result of the form also has a hierarchical structure according to the aggregation level.

The structure of Table B is not limited to the above-mentioned first and second embodiments, and may be as shown in FIGS. FIG. 17 is a modification of the B table shown in the first embodiment, which is characterized by the heading section at the aggregation structure level, and has the same structure as the B table shown in FIG. 5 in other respects. That is, in the first embodiment, as shown in FIG. 5, a name input area is provided for each of the aggregation levels A, B, and C arranged in the column direction of the B table, but the B table of FIG. The name input areas for three columns are not provided as in the first embodiment, but only the name input areas for one column are provided, and the aggregation level (in this case, the number 1,
2, 3, and 4) are arranged in the row direction. Here, when the table B is generated, the person in charge of business sequentially inputs the names while inputting and specifying the totaling level, and accordingly, the numbers representing the totaling level in the table B are arranged in the column direction for each totaling level. They are displayed "shifted", and this "shift" expresses the hierarchical structure of the aggregation level. In this case, the hierarchical structure has a relationship of 1>2>3> 4.

FIG. 18 shows another modification of the table B, which also has a feature in the heading section at the aggregation structure level. That is,
The table B in FIG. 18 is also composed of a name input area for one column, and in this name input area, a ruled line format for grouping the aggregation levels A, B, C, and D is displayed, thereby Represents a hierarchical structure. Also in this case, as in the case of the table B of FIG. 17, when the names are sequentially input while inputting and specifying the totaling level, the names are displayed together with the ruled line format for bundling according to the specified totaling level. .

FIG. 19 shows still another modified example of the table B, which also has a feature in the heading section at the aggregation structure level. That is, the table B is configured to express the hierarchical structure of the aggregation level by hierarchically connecting the names input for each aggregation level in the ruled line format.
Even in this case, if the names are sequentially input while inputting and specifying the totaling level, the names are displayed together with the ruled line format corresponding to the specified totaling level.

Furthermore, the present invention is not limited to the above-mentioned first and second embodiments, but can be applied in various modifications. That is, in the first embodiment, when an arbitrary intersection point position on the matrix constituted by the heading section of the table B is designated as the aggregation target, the circle mark is displayed at that position. By writing an X mark at the position, an intersection position not marked with an X mark may be designated as an aggregation target. Further, the arrangement positions of the heading parts in the row direction and the column direction of the B table are arbitrary, and for example, the heading parts of the items may be arranged in the row direction of the B table. Further, in the above-mentioned second embodiment, the code such as the item code or the destination code is inputted as the item data in the table B.
The name may be directly input, such as "TV", "video", "domestic".

[0043]

According to the present invention, a person in charge of business, who does not have specialized knowledge, simply defines an aggregation target for each aggregation level by using the aggregation definition table. Since records corresponding to the contents are read from a predetermined file and records with a hierarchical structure according to the aggregation level can be classified and aggregated, an expert such as a system engineer creates a code system in advance as in the past. There is no need, and anyone can easily classify and aggregate the records in a desired hierarchical structure.

[Brief description of drawings]

FIG. 1 is a block configuration diagram of a data processing device according to an embodiment.

FIG. 2 is a diagram showing a file structure of an accounting file as a part of a file recognition table 9.

FIG. 3 shows the contents of a table file 11, where (A) is a destination table, (B) is an item table, and (C) is a name table.

FIG. 4 is a diagram showing a definition screen of table A.

FIG. 5 is a diagram showing a definition screen of table B.

FIG. 6 is a diagram showing a definition screen of table C.

FIG. 7 is a flowchart showing an operation when the parameter setting unit 2 generates a B table.

FIG. 8 is a flowchart showing an operation when the configuration file generator 4 generates a configuration file.

FIG. 9 is a flowchart for specifically explaining the operation content when generating a configuration file.

FIG. 10 is a diagram specifically showing the contents of a configuration file 13 generated by a configuration file generator 4.

FIG. 11 is a diagram concretely showing the contents of the primary totalization file 14 generated by the data extraction processing unit 5.

FIG. 12 is a flowchart showing the operation when the development tabulation processing unit 6 generates a secondary tabulation file 15.

FIG. 13 is a flowchart for specifically explaining the operation content when the secondary totalization file 15 is generated.

FIG. 14 is a diagram specifically showing the contents of a secondary totalization file 15 generated by the expansion totalization processing unit 6.

FIG. 15 is a diagram showing a sales management table printed as a form 16.

FIG. 16 is a diagram showing a definition screen of table B in the second embodiment.

FIG. 17 is a diagram showing a modification of the B-table definition screen.

FIG. 18 is a diagram showing a modified example of another B-table definition screen.

FIG. 19 is a diagram showing another modification of the B-table definition screen.

[Explanation of symbols]

 1 Input Section 2 Parameter Setting Section 3 CRT Display Section 4 Configuration File Generation Section 5 Data Extraction Processing Section 6 Expansion and Aggregation Processing Section 7 Horizontal Calculation Processing Section 8 Printing Processing Section 9 File Recognition Table 10 Data File 11 Table File 12 Parameter File 13 Configuration File 14 Primary summary file 15 Secondary summary file 16 Form

Claims (9)

[Claims] 1. A heading of a tabulation definition table in which a data name in an item constituting a counted record of original data to be tabulated and a record name of a tabulation record for each tabulation level to be generated are arranged as a heading on a display screen. Display means for displaying a part, aggregation target designating means for designating an arbitrary intersection position on a matrix constituted by the heading part of the aggregation definition table as an aggregation target, and for each record name corresponding to the aggregation level, Detecting means for detecting the data name of the aggregated record corresponding to each intersection position designated by the aggregate target designating means, and reading out each aggregated record including the data name detected by this detecting means from a predetermined file Means and aggregating means for aggregating the records to be aggregated read by the reading means for each record name corresponding to the aggregation level, The data processing apparatus characterized by equipped. 2. The data processing according to claim 1, wherein the display means arranges the data name in the item in the upper column of the display screen and the record name of the totalized record in the left column of the display screen. apparatus. 3. An item specifying means for specifying an arbitrary item constituting a record to be totalized as an item to be totaled,
2. The display means reads out the data name in the item designated by the item designating means from a predetermined name table and arranges and displays the data name in the heading section on the display screen. The described data processing device. 4. A record name designating means for arbitrarily designating a record name of a summary record for each summary level, and the display means displays the record name designated by the record name designating means for each summary level. The display device is arranged and displayed in a heading portion on the screen.
The described data processing device. 5. The data processing apparatus according to claim 1, wherein said display means identifies and displays the record name of the totalized record corresponding to the totalization level. 6. The totaling object specifying means specifies a totaling object by inputting a symbol at an intersection position on a matrix forming the totalization definition table.
The described data processing device. 7. The summing means specifies the same item when a plurality of data names in the same item constituting the record to be summed are specified by the summing target specifying device and data names in other items are also specified. 2. The data according to claim 1, wherein the aggregated records including the data name corresponding to the logical product condition of the data names between Processing equipment. 8. The record name in the header section is not specified,
When a data name is designated by the aggregation target designating means, the aggregating means aggregates the records to be aggregated according to the designation of the data name, and aggregates by designating the aggregated record and the immediately preceding record name. 8. The data processing device according to claim 7, wherein a logical sum is obtained with the calculated aggregated record. 9. The heading section of the tabulation definition table is displayed by arranging the item names of the aggregated records of the original data to be tabulated and the record name of the tabulated record for each tabulation level to be generated as headings on the display screen. Display means for displaying, and for each record name corresponding to the totalization level in the totalization definition table, a totaling target designation for specifying a data name or a code as totaling item data to be entered at the corresponding position of the record name and the item name Means, reading means for reading from the predetermined file each record to be counted including the item data designated by the counting target designation means for each record name corresponding to the counting level, and read by this reading means. A data processing device, comprising: an aggregating unit for aggregating records to be aggregated for each record name corresponding to an aggregation level.