JPH07141445A - Data processor - Google Patents

Abstract

PURPOSE:To output form, etc., according to designated contents by only designating the record name, the item name, the output object item and the calculating formula, etc., of an output record in accordance with the outputted image of the form, etc. CONSTITUTION:When the parameters of an A table and a B table (the record name of a suming record, the item name, a suming object item and a calculating formula, etc.,) are designated from an input part 1, a table structure analysis part 5 analyzes the parameters of these A table and B table and prepares various kinds of tables such as a calculating table. An extension file preparation part 9 reads a prescribed record from a source file based on table contents and prepares an extension file 11. An extension suming processing part 12 prepares a suming file 13 from the contents of the extension file 11. A printing processing part 14 refers to the calculating formula table, prepares a printing file 15 from the suming file 13, prints the file and outputs it.

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data processing apparatus for reading and processing record data from an accounting file, a personnel file, etc. in an office computer, a personal computer or 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. By the way, a record is extracted from a predetermined file, arbitrary item data is read out from the extracted record, the record is totaled, and the form creation process for outputting the totalized result together with the form form is performed in advance by an expert such as a system engineer. Is performed according to a form processing program designed to correspond to each form 1: 1.

[0003]

As described above, in the conventional art, it is necessary to previously set an individual form processing program corresponding to each form in a one-to-one manner. As it changes with time, the form processing program may not fit in reality, and it may not be possible to obtain a form that matches the business content as it is.
In such a case, in the past, a part of the form processing program created in advance was changed to deal with it, but even if some changes are made, specialized and advanced knowledge such as programming is required. It is extremely difficult for general user business personnel to change the
In the current situation, it was necessary to ask the system engineer to change the program. An object of the present invention is to set an arbitrary calculation formula corresponding to each item name in addition to the record name of the output record, its item name, the output target item, etc. according to the output image of the form etc. without changing the program. By simply specifying, it is possible to output a form or the like according to the specified content.

[0004]

The means of the present invention are as follows. (1), the first designating means is a key input device or the like for designating the record name of the output record and the item contents (for example, item code) of the record to be extracted. The record name may be a name or code represented by characters. (2), the second designating means designates, in a table format, the item names output as the data items of the output record and the output target items extracted as the data items corresponding to the respective item names. In the corresponding column, specify the calculation formula that makes any column position a variable. Note that the second designating means sets the calculation formula in a plurality of fields provided corresponding to each item name in a ratio of 1: 1.
May be specified in association with. (3) The reading means reads the record from the predetermined file in accordance with the item contents designated by the first designating means. (4) Based on the record read by the reading means, the processing means outputs the output target designated by the second designating means for each record name of the output record designated by the first designating means. The item data is processed (for example, aggregated). (5), the arithmetic means is designated by the second designating means in the column corresponding to each item name, and the processing means processes a series of arithmetic operations according to a calculation formula in which any column position is a variable. Do this for each record. (6) The output means associates the record calculated by the calculation means with the record name specified by the first specifying means, and outputs the data of the output target item of the record by the second specifying means. Output in association with each item name specified in.

[0005]

The operation of the means of the present invention is as follows. First, in order to obtain a form or the like desired by a person in charge of business who does not have specialized knowledge, the record name of the output record and the item content of the record to be extracted are designated by the first designating means, and the second designation is made. Specify the item name output as a data item of the output record by the means and the output target item extracted as a data item corresponding to each item name in the table format, and further, in the column corresponding to each item name Specify a formula that uses the column position of as a variable. Then, a record that matches the contents of the designated item is read from a predetermined file, and the processing unit processes the data of the output target item for each record name of the output record based on this record. As a result, the calculation means is designated by the second designation means in the column corresponding to each item name, and a series of computations according to a calculation formula in which any column position is a variable is processed for each record processed by the processing means. To do. Then, the output means associates the record calculated by the calculation means with the record name specified by the first specifying means, and specifies the data of the output target item of the record by the second specifying means. It is possible to output in association with each of the created item names. Therefore, without changing the program, simply specify the record name of the output record, its item name, the item to be output, etc. according to the output image of the form, etc., and any calculation formula corresponding to each item name. Then, it is possible to output a form or the like according to the specified content.

[0006]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An 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 a person in charge of business who does not have specialized knowledge can simply specify the aggregation target etc. corresponding to the aggregation level using the aggregation definition table. Read the records corresponding to the definition contents of the aggregation definition table from the specified file and aggregate the records in the hierarchical structure according to the aggregation level.
The tabulation result is printed out as form data. 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, and a display unit 3 is provided.
Is displayed and output. The input unit 1 gives a start command to the parameter setting unit 2 in response to a predetermined key operation.

The parameter setting unit 2 operates in response to a start command from the input unit 1, and in order to instruct any record aggregation desired by a person in charge of business operation, the record name of the aggregation record, the aggregation target, the aggregation condition, etc. A definition table (in this embodiment, two types of A table and B table) that defines is generated according to the data input from the input unit 1, is displayed and output from the display unit 3, and is set in the parameter file 4. To do.
Note that Tables A and B will be described in detail later, so
A brief explanation will be given here. For example, in order to print out the “expense record table” as shown in FIG. 2 as a desired form, tables A and B are generated in advance as a summary definition table according to the output image of this form. Here, in the form shown in FIG. 2, the record name of the totalized record is arranged in the line item, and the data item name of the totalized record is arranged in the column item. The table A is configured as shown in FIG. 3 and the table B is configured as shown in FIG. 4, and the table A is a definition table that defines the record name of the aggregation record and the item contents extracted as the aggregation record for each aggregation level. Further, the table B defines, in a table format, the item names output as the data items of the aggregate record and the output target items extracted as the data items corresponding to the item names, the form at the time of printing the form, and the aggregate conditions. , Is a definition table that defines a calculation formula corresponding to each column constituting this table.

The parameter file 4 has its basic formats (ruled line data, etc.) fixedly stored in advance by the maker side corresponding to the tables A and B, and various forms arbitrarily input from the input unit 1. The A table parameter data, the B table parameter data, and a correspondence table that associates various form names arbitrarily input from the input unit 1 with the A table parameter data and the B table parameter data are stored.

The table structure analysis unit 5 operates according to a start command input from the input unit 1 when printing a form, and analyzes the A table parameter data and the B table parameter data corresponding to the form name arbitrarily designated as an output target. Then, various parameter analysis tables 6 are created according to the analysis results. In this case, in the present embodiment, as the parameter analysis table 6, the A table join table as shown in FIG.
B table combination table as shown in FIG. 5B, B table condition table as shown in FIG. 5C, B table total item table as shown in FIG. 5D, and B shown in FIG. Create a spreadsheet table. Further, the table structure analysis unit 5 analyzes the hierarchical structure or the like according to the aggregation level defined in the table A, and creates the configuration file 7 based on the analysis result. The configuration file 7, which will be described in detail later, is made up of various configuration records that represent the correspondence between the items to be aggregated in table A and their corresponding aggregate records, the hierarchical relationship in the hierarchical structure of the aggregate level, and the like. is there. Further, the table structure analysis unit 5 reads out the item name of each column defined in the header position of the B table, for example, the name of “initial plan” ... The print format of each column defined at the position is read and set in the print format memory 8. After that, the table structure analysis unit 5 gives a start command to the expansion file creation unit 9.

In addition to the print format arbitrarily input from the input unit 1, the print format memory 8 stores the contents of the heading column defined in the column direction of the B table as shown in FIG. The output item name and the ruled line format that forms the heading column are stored in association with the form name, and the ruled line format corresponding to the totaling level is also stored. This ruled line format is arbitrarily input and set from the input unit 1, and is a ruled line format for bundling corresponding to the counting level, and the upper and lower relations of the counting level are expressed by the shape of the ruled line format.

The expansion file creating unit 9 refers to various table contents in the parameter analysis table 6 to specify a file to be totalized from various source files A ... Based on the records extracted from the file, expanded records are sequentially generated one by one and written in the expanded file 11.
When the expansion file 11 is created in this way, the expansion file creation unit 9 gives a start command to the expansion aggregation processing unit 12.

The expansion totalization processing unit 12 sequentially creates totalization records one by one based on the contents of the expansion file 11 while referring to the configuration file 7, and writes the totalization records in the totalization file 13. When the totalization file 13 is created in this way, the expansion totalization processing unit 12 gives a start instruction to the print processing unit 14.

The print processing unit 14 reads out the totalized records from the totalization file 13 one by one, performs arithmetic processing on the totalization records according to the calculation formula set in the calculation formula table in the parameter analysis table 6, and writes them to the print file 15. . Then, the print processing unit 14 prints out the contents of the print file 15 one by one according to the print format set in the print format memory 8 together with the form format from the printer 16 to create a form.

Next, the operation of this embodiment will be described. First,
When the input unit 1 gives an instruction to create the tables A and B in order to obtain a desired form, the parameter setting unit 2 operates in response to this. First, when creating the A table, the parameter setting unit 2 displays and outputs a table frame and the like according to the basic format of the A table read from the parameter file 4. Now, with the basic format of table A being displayed and output,
The person in charge of business inputs the parameter data of table A from the input unit 1. FIG. 3 is a display example when the parameter data is input in the table A. Here, in the row heading portion of the table A, an arbitrary name is input as the record name of the totalized record corresponding to each totaling level. For example, line No "0
The record name “total” is entered in 1 ”corresponding to the aggregation level a, the record name“ fixed cost ”is entered in row No“ 02 ”corresponding to the aggregation level b, and the row No“ 03 ”is entered. The record name “personnel expenses” ... Is entered in correspondence with the aggregation level c. In the above example, an arbitrary record name is directly input from the input unit 1 for each aggregation level. However, if the record name to be used is predetermined, these record names to be used are stored in the table. Alternatively, when the record name is input, the table contents may be displayed in a list on the window screen, and the record name may be input by selecting an arbitrary record name from the list. Further, the record name is not limited to the name and may be a code.

Further, arbitrary file names and item names are entered in the column heading portion of table A. For example,
In the table A shown in FIG. 3, two types of file names "Plan F"
"ILE" and "accounting FILE" are entered, which defines the target file name from which the total record should be extracted. Further, the item name "budget item" is entered corresponding to the file name "plan FILE", and the item name "account item" is entered corresponding to the file name "accounting file". Target item names to be extracted as summary records are defined. Further, specific item contents (item codes) of the items to be totaled are entered in each matrix-shaped input area formed by the heading portions in the row direction and the column direction of the table A. For example, for line No. “03”, that is, for the record name “personnel cost” corresponding to the aggregation level c,
The item codes “101” and “102” are input in correspondence with the “budget item” of the “plan FILE”, and the “accounting FI” is entered.
Item code "211" corresponding to "LE""Account"
"1", "2112" and "2134" have been entered,
Of the budget items that make up the plan file,
It is defined that records corresponding to the item codes “101” and “102” should be extracted, and the item codes “2111” and “2” among the account items constituting the accounting file are defined.
It is defined that records corresponding to "112" and "2134" should be extracted.

Further, in the table A, a management unit area is provided corresponding to each row No. By designating an arbitrary row and inputting a circle mark at a position corresponding to it, an item code is inputted to the row. Indicates that this is an area to be covered. This is because, when the definition contents of the table A are analyzed line by line, the line marked with the circle becomes the analysis target, and the other lines are excluded from the target to improve the processing speed. At the same time, it also makes sense that the person in charge of business confirms that the data to be extracted and aggregated is in the source file (accounting file, etc.). In addition, in the table A shown in FIG. 3, an example in which two types are input as the file name is shown, but three or more types may be input, and one item name corresponds to one file name. However, it is also possible to input two or more item names in association with one file name. When the table A is created in this way, the parameter setting unit 2 sets the parameter data in the parameter file 4.

Next, the parameter setting unit 2 reads out the basic format of the table B from the parameter file 4 and outputs it for display. Here, in the heading portion in the row direction of table B, “format”, “target FILE”, “total item”, “calculation formula”,
“Condition item” and “condition value” are fixedly set in advance, and each column item in the heading section in the column direction of table B has “A”, “B” as names indicating the item position,
It is associated with "C", ... "G".

Now, in the state where the basic format of the table B is displayed and output, the person in charge of business operates from the input section 1 to B
Enter the parameter data in the table. FIG. 4 is a display example when the parameter data is input to the table B. Where B
In the heading portion in the column direction of the table, the item name to be printed out as the data item of the total record is input. For example, the item position “B” is “initial plan”, the item position “C” is “corrected plan”, and the item positions “D” and “E” are “actual product” as its shared item and its subordinate items. "Division expense" in item position "D", "replacement expense" in item position "E", "actual volume meter" in item position "F", "plan difference" in item position "G" Has been entered. Also,
In the row item of the table B, the column width, the character type, the character size, etc. are input in the “format” as the print format of the item data for each column item. In the next "target FILE", "planned FILE" is input corresponding to the column item positions "B" and "C", and "accounting FI" is input corresponding to the column item positions "D" and "E".
"LE" has been entered. Further, the next “total item” defines which item data should be totaled from the records extracted as the total target, and corresponds to the column item positions “B” and “C”, “budget amount + Is entered, and "debit amount +" and "credit amount-" are entered corresponding to the column item positions "D" and "E". here,
The plus / minus signs define addition or subtraction.

Next, in each column of the "calculation formula" corresponding to the column item positions B, C, D, ... Of the table B, the calculation formula for processing the output aggregate record is input. When defining that a certain item data should be output as it is, it is not necessary to write a calculation formula in the column corresponding to the item position, but when defining that a certain item data should be processed, Describes the calculation formula indicating the processing content in the column corresponding to the item position. In addition, each column for inputting a calculation formula is divided into three lines so that a plurality of calculation formulas (three calculation formulas in this embodiment) can be input, and the example shown in FIG. In, the formula input area has a matrix configuration of vertical 3 × horizontal 6. Each calculation formula input to this calculation formula input area is sequentially executed from the upper left (first line of the column item position B) to the right direction, and when all the calculation formulas of the first line are executed, The process is sequentially executed from the left end to the right direction, and finally, the third line is sequentially executed from the left end to the right direction. As described above, since the calculation formulas are sequentially executed in a predetermined order, it is necessary to describe the calculation formulas in consideration of this execution order. That is, in this embodiment, when a calculation formula is described, it is also possible to describe a calculation formula indicating that the result of another calculation formula should be referred to. Therefore, the calculation formula is considered in consideration of the calculation order. Need to be described.

On the other hand, in the calculation formula, an arbitrary column position is used as a variable, and this column position, a constant, and a simple operator are used for description. The column position is represented by the column item position in Table B. When the result of another calculation formula is to be referred to, the row number in which the calculation formula is input is added to the column item position. For example, the column positions "B" and "C" are substitution names for the item data in the tabulation record corresponding to the different item positions B and C in the B table, and indicate that this item data is used as a variable. . The column position "F1" is a substitute name for referring to the result of the calculation formula input in the first line of the column item position F, and the column position "G1".
"2" is an alternative name when referring to the result of the calculation formula input in the second line of the column item position G. Further, as an example of the description of the calculation formula, the calculation formula “D + E” shown in FIG.
Defines that the item data in the summary record corresponding to the column item positions D and E should be added. In addition, the calculation formula "B /
“1000” indicates that the item data corresponding to the column item position B is “1”.
Define that the value should be output in units of "thousands" by dividing by 000 ". Further, the calculation formula" C-F1 "is input from the item data corresponding to the column item position C to the column position F1. Define that the result of the formula "D + E" should be subtracted.

Further, in Table B, "condition item" and "condition value" are totaled only for the records in which some item data has a predetermined value among the extracted records extracted according to the definition contents of Table A. It defines what should be done. As the “condition item”, the column item positions “B” and “C” are input with the “plan type”, respectively, and as the “condition value”, the column item position “B” is “ 1 "and" 2 "," 3 ", and" 4 "are entered in the column item position" C ", and similarly," counter account "is entered in the column item positions" D "and" E "as" condition items ", respectively. Is input to the column item position “D” as “condition value” and “≠ 0011 (indicating that all other codes except 0011 should be extracted)”,
"0011" is entered in the column item position "E".
Note that "expense record list" is entered as the form name outside the frame of table B. When the table B is created in this way, the parameter setting unit 2 sets the parameter data in the parameter file 4.

After the tables A and B are created in this way, when an arbitrary form name is designated from the input unit 1 and a print command is given, the table structure analysis unit 5 follows the flow chart shown in FIG. Operate. Note that FIG. 8 shows the table structure analysis unit 5
In the general flow showing the outline of the overall operation of the table structure analysis unit 5, first, the table structure analysis unit 5 reads the designated form A from the parameter file 4.
The table parameter data is read to create a table A connection table (step A1) and a configuration file is created (step A2). Next, the table structure analysis unit 5 reads the B table parameter data of the specified form from the parameter file 4 to create a combined table of the B table (step A3), a condition table (step A4), and a total item table (step A5). ), Formula table (step A
Create 6) respectively. Then, the format data is extracted from the parameter data in Table B and written in the print format memory 8 (step A7).

FIG. 9 shows a flow of creating the A table join table. The table structure analysis unit 5 analyzes the column heading portion of the A table to analyze the A table join table as shown in FIG. 5 (A). To create. Here, the A table connection table is a correspondence table that associates the file names defined in the A table with the item names. The "file name" and "sequential number SE
It consists of "Q", "item name", and "file symbol". Here, the sequential number SEQ is a code for specifying the item names defined in the same file by consecutive numbers from "01", and the "file symbol" is the file defined in the table A. It is a code for specifying "1" by a serial number. First, the table structure analysis unit 5 reads the table A parameter data of the specified form from the parameter file 4 (step B1), and specifies the initial value "1" as the file symbol (step B2). And A
The heading portion in the column direction of the table is sequentially analyzed from the beginning. That is, the table structure analysis unit 5 first specifies the first file name defined in the table A (step B3), then specifies the initial value "1" of the sequential number SEQ (step B4), and further The first item name corresponding to the first file name is designated (step B5). The file name, the sequential number SEQ, the item name, and the file symbol designated by this are written in the A table connection table (step B6). In this case, if the table A shown in FIG.
Data as shown in FIG. 5A is written in the first row of the table combination table. Next, if another item name is defined corresponding to the same file name (step B7), "1" is added to the sequential number SEQ to update the value (step B8), and next. Item name is designated (step B5), and writing to the table A connection table is performed (step B6). Hereinafter, the above operation is repeated until all the item names corresponding to the same file name are designated. As a result, when all the item names have been specified, the next step B
If there is another file name in the table A, the file symbol "1" is added under that condition and the value is updated (step B10). After that, returning to step B3, while writing the other file name from the table A and sequentially designating all the item names corresponding to the file name, writing to the table A connection table is performed.

Next, the process of creating the configuration file 7 shown in FIG. 8 (step A2) will be described in detail with reference to FIGS. 10 to 12 are flowcharts showing the operation when creating the configuration file 7, FIG. 13 is a diagram schematically showing the operation content of the table structure analysis unit 5 in this case, and FIG. 14 is It is a figure showing composition file 7 created. Note that FIG. 14A shows the record structure of the configuration file 7, and this configuration record consists of "child hood", "parent code", "end flag", and "name". And "parent code" are codes that represent the correspondence between the items to be totalized in table A and the corresponding totalized records, or the parent-child relationship (upper / lower relationship) in the hierarchical structure at the totaling level. Further, the “end flag” is a flag that becomes “1” when the parent code includes the aggregation level a, and when the end flag is set to “1”, a higher level than that is set. It indicates that record aggregation is not performed. “Name” is the record name of the totalized record defined in table A. First, the table structure analysis unit 5 specifies the first row of the A table parameter (step C1), and checks whether the totaling level of the specified row is the highest level a (step C2). here,
If the aggregation level is a, the final item work memory in the table structure analysis unit 5 for initial setting (see (B) of FIG. 13)
While clearing all the contents of (Step C3),
Aggregation level a as the level currently being focused on (current level)
Is designated (step C4). In this state,
Level line data is generated from the current level and the line number of the line of interest (current line) (step C5). For example, taking the table A shown in FIG. 3 as an example, the first row of the table A is the aggregation level a and the row number is "01". Therefore, the level row combining the current level and the row number is shown. Data “a01” is generated. Next, the level row data "a01" and the name of the current row (record name "total" of the totalized record) are set at the position corresponding to the current level a of the final item work memory (step C6). The final item work memory is configured to store level line data and names corresponding to the aggregation levels a, b, c, d ... As shown in FIG. Is the work memory of.

Next, it is checked whether the management unit area of the current line is circled (step C7). Now, as shown in FIG. 3, since the first row is not marked with a circle, attention is paid to the next row of table A to check whether or not a record name is set in that row (step C8). When the setting is detected, the current line is updated and the next line is designated (step C9). When the second row of the A table is designated by this, the process then returns to step C2, but in this case, the summarization level of the second row is b, so
The process proceeds to 0, and an error check is performed to see if the level of the specified line is equal to or higher than the current level. If the level is equal to or higher than the current level, all contents below the level of the specified line are cleared in the last item memory (step C11). .

Since the designated row level b is now less than the current level a, the flow advances to step C12 to set the designated row level as the current level and update the current level. Next, level line data is generated from the current level and the line number of the current line (step C13), and the level line data and the name of the current line are set at the position corresponding to the current level of the final item work memory ( Step C14). In this case, the level row data “b02” and the name “fixed cost” are set at the position corresponding to the current level b (see FIG. 13B).
Next, a symbol (•) is combined at the beginning of this level row data (step C15), and this combined data is shown in FIG.
It is set as a child code of the configuration record as shown in (step C16). Here, the symbol (•) is set when the line of the table A in which the item code is not input is the line of interest, which indicates that there is no correspondence with the source file. Then, the process proceeds to step C17 in FIG. 11 to read the level row data stored in the level position (current level + 1) from the last item work memory, and combine the symbol (•) at the beginning of this level row data. , This combined code is set as the parent code of the configuration record (step C18). Now, the current level is b, and therefore the combined code in which the symbol (•) is combined with the level line data “a01” stored at the position of level a in the last item work memory becomes the parent code ((A) in FIG. 13). reference). Here, if the level of the parent code is a (step C19), "1" is set to the end flag of the configuration record (step C20). Next, the name of the parent code is read from the last item work memory and set as the name of the configuration record (step C21).
In this way, when the child code ".b02", the parent code ".a01", the end flag "1", and the name "total" are prepared as the data for one record, this configuration record is written to the configuration file 7. (Step C22).

Next, returning to step C7 of FIG. 10, in this case, since the management unit area of the current row is not marked with a circle, the third row of the next row is designated (step C).
9). After that, as a result of the above steps C12 to C14 being executed, the level line data "c03" and the name "personnel expenses" of the current line are set in the level c of the last item work memory (((Fig. 13)). See B)). Then, the join code in which the symbol (.) Is added to this level row data is set as a child code of the configuration record (steps C15 and C1).
6). Next, the level row data read from the position of level b in the last item work memory (level position one step higher).
The combined code in which the symbol (.) Is added to the data "b02" is set as the parent code of the constituent record (steps C17 and C18 in FIG. 11). In this case, the name "fixed cost" in the last item work memory corresponding to the parent code becomes the name of the constituent record (step C21). In this way, the child code ".c03" and the parent code are used as the data for one record.
When the code ".b02" and the name "fixed cost" are available, this configuration record is written to the configuration file 7 (step C2).
2).

Subsequently, when it is detected in step C7 in FIG. 10 that the management unit area on the third line is circled, the process proceeds to step C23 in FIG. 12, where "1" is set as the initial value of the file symbol. Set. Next, the item code entered in the current line is designated from the beginning (step C24), the file symbol and the item code are combined to form this combined code, which is a child code of the constituent record. -Set as a card (steps C25, C26). In this case, since the file symbol "1" and the item code "101" are combined, the child code becomes "1101". Next, the symbol (.) Is combined at the beginning of the level row data of the current level in the last item work memory (step C27), and this combined data is set as the parent code of the constituent record. Yes (Step C
28). Then, the name "personnel cost" of the parent code is read from the last item work memory and set as the name of the constituent record (step C29). FIG. 13C shows a configuration record in this case, in which the child code is "110".
1 ", the parent code is" .c03 ", and the name is" personnel expenses "is written to the configuration file 7 (step C30). Next, it is checked whether another item code is entered in the current line (step C31), and if there is, the process returns to step C24, the next item code is designated, and the above operation is performed. repeat. As a result, when the item code "102" on the third line is designated, the constituent code is "1102" for the child code and ".c0" for the parent code.
3 ”and the name is“ Personnel expenses ”.

After that, since no item code is detected in step C31, the process proceeds to step C32 and it is checked whether another file name is defined in the A table. File name of "accounting FILE"
Is defined, the process proceeds to step C33, "1" is added to the file symbol to update the value, and then the process returns to step C24. In this case, the file symbol is "2",
Since the first "2111" is specified as the item code,
The child code of the configuration record is "22111", the parent code is ".c03", and the name is "labor cost". Now
If no other file is specified in step C32, the process returns to step C8 in FIG. 10, and the process of creating a configuration record and writing it to the configuration file 7 is repeated until one setting is detected in step C8. -Repeat each one. As a result, the configuration file 7 as shown in FIG. 14 is created. The contents of the configuration file 7 are generated by referring to the table A in FIG.

After the configuration file 7 is created in this way, the table structure analysis unit 5 determines the join table of the B table and the condition table.
Create a calculation formula table in addition to the table and total item table. Of these, the B table connection table, the condition table, and the total item table are created according to the flowcharts shown in FIGS. Here, the B table connection table (see FIG. 5B) is composed of "file name", "sequential number SEQ", "item name" of condition item, and "file symbol". In addition, the condition table (Fig. 5 (C))
(Reference) comprises "file name", "item position of table B", "condition value", and "negative flag". Here, the "negative flag" is a flag indicating that "≠ (not equal)" is set as the condition value. Further, the total item table (see FIG. 5D) is composed of "file name", "item position of table B", "item name" of total item, and "minus sign". Here, the "minus sign" indicates that the item name is attached with a minus sign in the total item, such as "credit amount-".

First, the table structure analysis unit 5 reads the B table parameter data of the specified form from the parameter file 4 (step D1), and specifies the second column (item position B) thereof (step D2). Next, the target file name in the designated column is called (step D3), and the file symbol corresponding to this file name is called from the table A connection table (step D4). Then, in the next step D5, the initial value "1" of the sequential number SEQ is set, and then it is checked whether or not the item name is set by paying attention to the condition item in the designated column (step D6), and it is set. If so, the condition item name is designated (step D9). File name and sequential number SE obtained by this
After generating a join record from Q, the condition item name, and the file symbol (step D10), this join record is set in the B table join table. At that time, in order to avoid duplicate setting of the same record, the B table join table On condition that the same record is not set (step D1
1) The generated join record is set in the B table join table (step D12).

Next, paying attention to the condition value of the designated column, the condition value is designated (step D13), and if "≠" is added to this condition value (step D14), a negative flag is set. (Step D15). The file name obtained in this way, the column name indicating the item position of the specified column,
A condition record is generated from the condition value and the negative flag (step D16) and set in the condition table of table B (step D17). Here, if multiple condition values are defined in the specified column, a condition record is generated for each condition value.
In step D18, it is checked whether or not there is another condition value, and if there is another condition value, the process returns to step D13, the next condition value is designated, a corresponding condition record is generated and set in the condition table. Then, in the next step D19, it is checked whether or not there is another condition item in the designated column, and if there is another condition item, the process proceeds to step D20, where "1" is added to the sequential number SEQ to update the value. , Step D9
Then, the next condition item is designated, and thereafter, the corresponding join record is generated, or the condition record is generated and set in the correspondence table.

When it is detected in step D19 that there is no other condition item, the process proceeds to step D21, the condition item in the designated column is specified, and if the condition item is added with a minus sign (step D22), a minus sign is given. The flag is set (step D23). The file name and the column item position of the designated column thus obtained are generated from the column name, the tabulation item and the minus sign flag (step D24) and set in the tabulation item table (step D25).

After the definition contents for one column of the B table are thus analyzed and the B table connection table, condition table, and total item table for one column are created, the process proceeds to step D7, and the data in the next column of the B table is set. Is specified, and if there is, the line is specified (step D8), and then step D3
Then, the above operation is repeated.

After that, the table structure analysis unit 5 analyzes the B table parameter data and creates a calculation formula table. As shown in FIG. 6, the calculation formula table can store a plurality of sets of data having one set of variable name, calculation formula, and value, and this calculation formula table is paired with an output item table described later. Figure 1
7 shows the flow of creating this calculation formula table.
First, the table structure analysis unit 5 determines the second column of the B table (column item position B).
Is designated (step E1), and it is checked whether or not total items are defined in the designated column (step E2). Now, since "budget amount +" is defined as the total item in the second column, the process proceeds to step E3, and the column item position B is set as a variable name in the calculation formula table. In order to repeat such an operation until the last column of the B table is designated, it is checked in the next step E4 whether the designated column is the last column, and if it is not the last column, the process proceeds to the step E5 and the next column of the B table. Is designated, and the process returns to step E2. As a result, in the case of the B table shown in FIG. 4, the column item positions B, C, D, E of the B table in which the total items are defined as shown in FIG. 6 are set as variable names in the calculation formula table. .

When the last column of table B has been specified, B
The calculation formulas set in the calculation formula input area of the table are sequentially read according to the execution order and set in the calculation formula table (steps E6 to E13). First, in order to specify the upper left of the calculation formula input area, the first row of the input area is specified (step E6), and the second column is specified (step E7). Then, it is checked whether or not there is a calculation formula at this designated position (step E8),
If there is, the column item position on the B table showing the matrix and the row number of the calculation formula input area are combined and set in the calculation formula table together with the calculation formula as a variable name (step E).
9). Then, in steps E10 and E11, the above-described operation is repeated while designating the next row by designating the last column of the first row. Here, in the table B shown in FIG.
Since the formula is entered in the column, the variable name is "F
1 ”, and the calculation formula“ D + E ”is set in the calculation formula table together with this variable name (see FIG. 6). Hereinafter, in steps E12 and E13, the above operation is repeated while designating the last row of the calculation formula input area and designating the next row. As a result, the calculation formula “C-F1” described in the second line of the calculation formula input area shown in FIG. 4 is set in the calculation formula table with its position as the variable name “G2”.
Each calculation formula “B / 1000” described in the third line,
"C / 1000" ... "G2 / 1000" are set in the calculation formula table with their positions as variable names "B3", "C3" ... "G3".

When the last line (third line) of the calculation formula input area has been specified in this way, the process proceeds to step E14.
Create output item table. In this case, the last variable name in each column of table B is read from the formula table and sequentially written in the output item table. That is, in order to set the result of the calculation formula described in the last row in each column of the B table as the item content output as the data item of the totalized record, the last calculation is performed for each column of the B table. Write the expression description position as a variable name in the output item table.

Next, the table structure analysis unit 5 reads out the format data from the B table parameter data in association with the column item position and sets it in the print format memory 8.

Upon completion of such table creation processing, the table structure analysis unit 5 activates the expanded file creation unit 9. Then, the expansion file creating unit 9 performs the expansion file creating process according to the flowcharts shown in FIGS. 18 and 19. The expansion file 11 is a file that is intermediately generated until the total file 13 that is the output data of the form is created. Here, FIG. 20 shows the expanded record created according to the contents of the first record to the fourth record when the source file is the plan file, and FIG. 21 shows the one record when the source file is the accounting file. The expanded record created according to the contents of the third to third records is shown. Further, FIG. 22 shows the contents of the expanded file 11 created by this. Now, in the parameter analysis table 6, FIG.
It is assumed that various tables having the contents shown in (D) are set.

First, the expansion file creating section 9 refers to the parameter analysis table 6 to retrieve the file name (first file name of the first record) from the A table connection table (step F1) and specify the file symbol. (Step F2). Next, the source file corresponding to this file name is designated (step F3), and the first record in this source file is designated (step F3).
4). As a result, the top record of the "plan file" first defined in the table A is designated as the file to be totaled. Next, the item name (initially, the item name of the first record) is fetched from the table A connection table (step F5),
The item value corresponding to this item name is taken out from the designated record (first record at the beginning) in the designated file (step F6). Then, this item value and the designated file symbol are combined (step F7), and this combined data is set as the classification key of the expanded record (step F8). Now
As shown in FIG. 20, the item value “101” of the budget item is extracted from the first record of the plan file, and this item value “1
01 "and the designated file symbol" 1 "are combined, and this combined data" 1101 "becomes the classification key in the first record of the expanded record.

Next, it is checked whether or not the output target item in the first record of this plan file is a record that meets the extraction conditions defined in the B table. That is, first, the expansion file creation unit 9 refers to the B table connection table and checks whether or not there is a designated file symbol in this table (step F9). Here, as described above, the condition item is B
When defined in the table, file name, condition item name,
Since the file symbol etc. are set in the B table connection table,
The fact that the file symbol is not set means that the condition item is not defined in the table B (that is, the extraction condition of the output target item is unconditional). Since the designated file symbol "1" is set in the B table joining table, the process proceeds to step F10, and the item value corresponding to the item name of the B table joining table is taken out from the designated record. In this case, the item value “1” of the plan type is extracted from the first record. Then, the condition value corresponding to this item value is searched from the table B condition table (step F11), and it is checked whether there is a matching condition value (step F12). Since the item value “1” of the plan type included in the first record exists in the first record in the B table condition table, the process proceeds to the next step F13 and the negative flag in the corresponding B table condition table. Check if is set, but in this case,
Since the negative flag is not set, step F19
Then, the value of the position corresponding to the matched condition value (B in this case) is taken out from the B table condition table, and the value of the item position matching this is searched in the tabulation item table (step F20). The corresponding item name is designated (step F21). Here, since the item position B is set in the first record in the total item table, the item name "budget amount" corresponding to it is taken out and the item value "800,000" corresponding to this item name is specified. It is taken out from the record (step F22), and it is checked whether or not the minus sign flag is set in the tabulation item table corresponding to this item position B (step F23).
Next, proceeding to step F24, the item value “800,000” fetched from the designated record is totaled in the corresponding position “B” of the expansion record. In this case, if the minus sign flag is set, negative totalization is performed. If the minus sign flag is not set, it is counted as plus. As a result, the first expanded record as shown in FIG. 20 is created.

Next, it is checked whether another same item position (B in this case) is set in the total item table (step F25), but as shown in FIG.
In the accounting file, the same item positions D and E are set in two places in the total item table in correspondence with the item names "debit amount" and "credit amount", respectively, but a plurality of item positions B are set. No, so step F
In step 14, it is checked whether there is another condition value that matches the item value in the B table condition table. Since the condition value “1” exists only in the first line in the condition table B table, the process proceeds to step F15, and the next record is specified on condition that the next record exists in the specified plan file. (Step F18).

As a result, the second record of the plan file is designated, the process returns to step F5, and the above operation is repeated. In this case, the file code “1” and the budget item value “102” of the second record generate the classification key “1102” of the expanded record in the second record (steps F5 to F8). The item value corresponding to the plan type of the second record is “1” as in the case of the first record, and the condition value matching the item value “1” exists in the B table condition table and corresponds to it. Since the negative flag has not been set, the process proceeds to step F19 and B
The item position "B" is fetched from the table condition table, and the value of the item name "budget amount" corresponding to this item position "B" is fetched from the second record of the plan file (step F20-).
F22). In this case, as shown in FIG. 20, the budget amount item in the second record of the plan file is “200,000”.
Are taken out and added to the corresponding position “B” of the expanded record (second record) and added up (step F24).

Next, when the third record of the plan file is designated (step F18), the classification key "1103" of the expanded record (third record) is generated. In this case, the item value of the plan type of the third record read from the plan file is "2", and the condition value that matches this item value is set in the B table condition table. The matching item value is “C”. Therefore, the item value “400,000” of “budget amount” extracted from the third record of the plan file is added up to the corresponding position “C” in the expansion record (third record).

Further, when the fourth record of the plan file is designated, the expanded record (4
In the item position “C” of (record record), the item value “50,00” of the budget amount extracted from the fourth record of the plan file
"0" is added up. The classification key of this expansion record is "1104". Similarly, while sequentially designating the plan file one record at a time, referring to the A table join table, the B table join table, the condition table, and the total item table in the parameter analysis table 6, the expansion record of the plan file is set to 1 Create records one by one.

When it is detected in step F9 that the designated file symbol is not set in the B table join table, the condition item is an unconditional item that is not defined, so the process proceeds to step F28. The same file name as the designated file is directly searched in the tabulation item table without referring to the definition contents of the B table condition table, and thereafter, the process returns to step F21.

As a result of performing such an operation one record at a time, when all the records in the designated file have been designated and the absence of the next record is detected in step F15, step F
Proceed to step 16 and check whether another file is defined in the table A join table. Now, since the accounting file is defined as another file in the table A combination table, the process returns to the first step F1 and the processing for sequentially generating the expanded records corresponding to the accounting file is performed as described above. . That is, "accounting file" is taken out as a file name from the table A combination table (step F1), and "2" is designated as the file symbol (step F2). Then, the accounting file is designated as the source file corresponding to this file name (step F
3) Specify the top record (step F)
4).

In this state, the item value "2111" of the "account title" of the designated record and the file symbol "2" are combined to generate the classification key "22111" of the expanded record in the first record (step F5-). F8). Then, the process proceeds to step F9. In this case, since the file symbol "2" is stored in the B table connection table, B
The item value corresponding to the item name "counterpart" of the table combination table is taken out from the first record of the accounting file (step F10). Since "0011" is taken out as the item value of "counter account" from the first record of the accounting file, the condition value matching this item value is checked from the B table condition table (step F11). In this case, since the corresponding condition values are set in the fifth and sixth lines in the table, a match is detected in step F12, the process proceeds to step F13, and the first five lines are focused. Then
Check whether the negative flag is set in the corresponding position. Now, since the negative flag is set in the fifth row of the B table condition table, the process proceeds to step F14, and there is another condition value in the B table condition table that matches this item value "0011". I will check if there is, but now, B
Since the condition value "0011" is present on the sixth line in the table condition table, the process returns to step F13. Now, since the negative flag is not set at the position corresponding to this condition value, the routine proceeds to step F19, where the item position "E" corresponding to this is taken out from the table B condition table, and this item position "E" is set. The item name in the matching total item table is designated (steps F20 and F21), but in this case, 5 of the total item table is specified.
The first item position among the item positions "E" set in the lines 6 and 6, that is, the item name "debit amount" corresponding to the line 5 is designated. Then, from the first record of the accounting file, the item value "5" corresponding to the designated item name
10,000 "is added to the corresponding position" E "of the expansion record in the first record for the accounting file (steps F22 to F24).

Then, the process proceeds to step F25. In this case, since the same item position "E" exists on the sixth line in addition to the fifth line in the total item table, step E21 is performed.
Then, the item name "credit amount" corresponding to the item position in the total item table is designated, and the item value corresponding to the designated item name is taken out from the first record of the accounting file (step F22). . In this case, "D" is taken out as the item value of the credit amount from the first record of the accounting file, and it is totaled in the corresponding position "E" of the first record of the expansion record. Since the minus sign flag is set in the sixth line of the total item table, negative total, that is, (previous debit amount "50,000" -current credit amount "0") is calculated. (Step F24). Then, the process proceeds from step F25, F14, F15 to step F18, and the second record of the accounting file is designated. As a result, the expansion record is generated corresponding to the second record of the accounting file. In this case, the item value of the account item is also "2111" and the classification key is the same as the first record. Becomes “22111”. In addition, since the counter account of the second record is also "0011", which coincides with the item condition value, the debit amount "0" is added up to the item position E of the development record and the credit amount "40". , 00
"0" is negatively added up to the item position E. Therefore,
The item position of the expansion record of the second record is "-40,
000 ”is written.

Next, the third record of the accounting file is specified. The item value of this counter account is "0011", and B
Since the condition value corresponding to this is not set in the table condition table, the process proceeds from step F12 to step F26 to check whether the negative flag is set in the B table connection table for the specified file. To check. Now, in the table B condition table, a negative flag is set in the fifth line corresponding to the accounting file, so step F27.
To the value "D" at the position where the negative flag is set.
Is retrieved from the table B condition table, and the position corresponding to this value is searched from the tabulation item table (step F2).
0), the item value “8” corresponding to the item name “debit amount”
50,000 "is taken out from the 3rd record and expanded.
Add to the corresponding position D of D. Then step F
The process returns from step 25 to step F21, and similarly to the above, the item value "0" of the next item name "credit amount" is negatively added up to the expansion record position "D". After that, the next record is designated, and the same operation as described above is repeated one record each time a mismatch is detected in step F12. As a result, the expansion records according to the condition value "≠ 0011" of the condition item "counter account" are sequentially generated.

Thereafter, when all records of the accounting file have been designated and no next record is detected in step F15, the process proceeds to step F16, and there is another file in the A table join table. In this case, since the absence of a file is detected, the process proceeds to step F17, and the expansion record editing process is performed. That is, the development records having the same classification key are extracted, and these are extracted as one record.
Each development record is sorted in ascending order according to the classification key. For example, as shown in FIG.
The development records of the first record and the second record have the same classification key, so they are combined into one development record, and the value of the item position "E" is "10,000". It will be. FIG. 22 shows the expansion file 1 created as described above.
The contents of 1 are shown. That is, the expansion file 11 created according to the contents of the plan file and the accounting file
The record structure has items A, B, C, D, E, and F, and the first item A is a classification key.

In this way, the expansion file creating section 9 creates the expansion file 11 and then activates the expansion aggregation processing section 12. Then, the development totalization processing unit 12 creates the totalization file 13 according to the flowchart of FIG. Note that FIG. 24 is a diagram for specifically explaining the operation content of the expansion aggregation processing unit 12. The expansion file creation unit 9 generates the totalization file 13 according to the parts expansion method based on the contents of the expansion file 11 and the contents of the configuration file 7. First, the expansion totalization processing unit 12 uses the expansion file 11
The data for one record is read from the beginning of (step G1). Then, in the next step G2, is the data end?
That is, it is checked whether or not all the records have been read from the beginning of the expanded file 11. First, since the data for one record is read from the beginning of the expansion file 11, the process proceeds to the next step G3, and the configuration file 7
Is searched, and a configuration record having a child code matching the classification key is retrieved from the configuration file 7. Now, as shown in FIG. 24, the classification key in the first record of the expanded file 11 is "1101", and the configuration file 7 has a configuration record having a child code matching this as shown in FIG. Therefore, this is detected in step G3, and the process proceeds to step G4 to generate a record (total record) of the total file 13. That is, in the specific example of FIG. 24, first, the expansion totalization processing unit 12 reads out the parent code corresponding to the child code “1101” from the configuration file 7, and reads this parent code “· c03” from the row No. “0” of the B table.
This line No. "03"
Is placed in the first item of the first record of the totalization file 13, and the other ".c" is placed following it.
Then, the name corresponding to this child code is read from the configuration file 7 and placed in the next item of the tabulation record. Following this, the data items of the expanded file 11 are sequentially arranged after the next item of the totalized record. This aggregate record is the record name “personnel expenses” defined in No. 03 of table A,
It is a totalization record of the totalization level "c", and is the totalization of data corresponding to the totalization target code defined in the table A corresponding to this record name. As a result, when data for one record of the totalization file 13 is generated,
This generated record is written to the totalization file 13, but at this time, if a record having the same classification key already exists in the totalization file 13, it is totalized into one record and written in the totalization file 13, and the same If the classification key record does not exist, the record generated this time is newly added to the totalization file 13 (step G5).

Next, it is checked whether or not the end flag is set at the corresponding record position in the configuration file 7 (step G6). Here, the end flag in the configuration file 7 is "1" when the aggregation level of the parent code is "a".
When the end flag is "1", the process directly returns to step G3. If the end flag is not "1", a new expansion record is generated and written in the expansion file 11 (step G7). In this case, the expanded file 11 is created by generating a record as shown in FIG.
Return to. That is, if a record name at a higher level than the total record generated this time is defined in the table A, a new result is added in order to total the totalized result of the total record generated this time to the total record having the record name at the higher level. The expansion record is generated and written in the expansion file 15. Here, the corresponding parent code “・ in the configuration file 7
“C03” is arranged in the first item, and subsequently, a record formed by sequentially arranging the data read from the expansion file 11 is written to the expansion file 11. In the expanded file 11 shown in FIG. 22, the record arranged below the broken line in the drawing shows the returned record. After that, the process returns to step G3, and thereafter, the entire contents of the configuration file 7 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 G3 and the mismatch ends, the process returns to step G1 to read the next record from the expanded file 11. Such an operation is performed for all the records of the expanded file 11. As a result, the data corresponding to the aggregation target code is aggregated in the aggregate record of the corresponding record name in table A, and if a record name at a higher level than this aggregate record is defined in table A, this aggregate record The aggregation result of is aggregated to the aggregation record of the record name at the higher level. On the other hand, if the negative aggregation to the aggregation record at the higher level is defined, it is negatively aggregated to the aggregation record at the higher level. When the end of data is detected in step G1, step G8
Then, the records constituting the totalization file 13 are sorted in ascending order according to the contents of the first item. The records in the totalization file 17 sorted in this way are rearranged in the print order when the form is output.

When the totalization file 13 is created in this way, the expansion totalization processing unit 12 activates the print processing unit 14. FIG. 25 is a flowchart showing the operation of the print processing unit 14. First, the print processing unit 14 uses the tally file 1
Data for one record is read from the head of 3 (step H1), and the value in each field of this aggregate record is set in the calculation formula table as the value of the corresponding variable name in the calculation formula table (step H2). As a result, in the calculation formula table shown in FIG. 6, the variable names B, C, D, to which the values of the fields B, C, D, E of the aggregate record correspond.
Set each as the value of E.

Next, each calculation formula in the calculation formula table is sequentially executed, and the result is set as the corresponding value in the calculation formula table (step H3). That is, the calculation formula “D + E” is read from the calculation formula table shown in FIG. 6 and the operation according to the calculation formula is executed. Here, the values corresponding to the variable names D and E included in this calculation formula are read from the calculation formula table, the values of these variable names D and E are added, and the result is used as the value of the variable name F1. Set to. Next, from the formula table, the formula "CF
1 ”and read the values corresponding to the variable names C and F1 included in this formula from the formula table,
The value of the variable name F1 is subtracted from the value of the variable name C, and the result is set as the value of the variable name G2 in the calculation formula table. Next, from the formula table, the formula "B / 1000"
Is read, the value of the variable name B is divided by “1000”, and the result is set in the calculation formula table as the value of the variable name B3. Similarly, from the calculation formula table, the calculation formula "C / 1
000 ”,“ D / 1000 ”,“ E / 1000 ”,“ F ”
"1/1000" and "G2 / 1000" are sequentially read out,
The result is the corresponding variable name C3, D3, E3, F3, G
The value of 3 is set in the calculation formula table.

As described above, when the respective calculation formulas in the calculation formula table are sequentially executed in the predetermined order and the results are set in the calculation formula table, the print processing unit 14 displays as shown in FIG. The output item table that forms a pair with the calculation formula table is referred to, and its variable names B3, C3,
The values corresponding to D3, E3, F3, and G3 are read from the formula table, and these values are assigned to the corresponding fields B, C, D, E, F, and G of the aggregate record to create new records ( At step H4), this is written in the print file 15 (step H5). As a result, FIG.
As shown in, the first record of the totalization file 13 is written in the first record of the print file 15 by processing the values of the fields B to G according to the contents of the calculation formula table.

This processing is repeated until the end of all records is detected in step H6, and the totalization file 13
Is executed for all records of. As a result, each record of the totalization file 13 shown in FIG. 26A is processed according to the calculation formula table of FIG.
A print file 15 as shown in (B) is obtained. Then, the print processing unit 15 causes the printer 16 to print out the contents of the print file 15 as a form together with the ruled line format corresponding to the aggregation level in accordance with the print format in the print format memory 8. In this case, each record name of the print file 15 is sequentially taken out and arranged in the vertical direction of the form, and each item name in the print format memory 8 is taken out sequentially and arranged in the horizontal direction of the form. FIG. 2 shows an example of printing a form in this case. In the row direction, the record name of the total record is printed together with the ruled line format of the hierarchical structure corresponding to the total level, and the item name of the total record is printed in the column direction.
Further, the item data of each record in the print file 15 is printed out for each record corresponding to the item name.

As described above, in this embodiment, in order to obtain the form desired by the person in charge of business, the record name of the totalized record, the item name output as the data item of the totalized record, and the totalization according to the output image thereof. Target items are A
If the calculation formulas in which the column positions are defined as variables in the columns corresponding to each item name in Table B are specified in the tables and B tables, the definition contents of Tables A and B will be used. The contents of arbitrary record items are read from a predetermined file and tabulated for each record name, and the tabulated records are processed and printed out according to the formula defined in Table B. Even in such cases, the desired form can be easily obtained. Especially when writing a formula,
It suffices to describe a calculation formula in which any column position is a variable in the column corresponding to the output image of the form, and the description becomes extremely easy.

In the above embodiment, "D + E", "B / 1
Although a simple calculation formula such as “000” is given as an example, the calculation formula is not limited to the four arithmetic operations, and is arbitrary. It is also possible to add a condition to the calculation formula and execute the formula when the condition is true. Further, although the above-mentioned embodiment has explained the case of performing the record aggregation, if the aggregation level of the A table is set to only A, not only the record aggregation but also the record extraction, the array, the in-item calculation, etc. may be performed. Good. In the above embodiment, the form is printed out, but it may be output on a CRT screen display or other medium. On the other hand, in the above embodiment, the tables A and B are defined separately and independently, but the tables A and B may be defined simultaneously on the same screen. Further, in the above embodiment,
Although the item code is input at an arbitrary intersection position on the matrix formed by the heading section of the table A, the item name may be input, or the record of the totalized record input in the row direction. Although the names are input in a hierarchical structure according to the aggregation level, it goes without saying that the names are not limited to the hierarchical structure. From parameter file A
By printing the images of the table and the table B themselves, the specifications such as a form may be stored so that the person in charge of business can understand them.

[0060]

According to the present invention, in addition to the record name of the output record, its item name, the item to be output, etc. according to the output image of the form, any calculation formula is simply specified corresponding to each item name. By simply doing so, it is possible to output a form etc. according to the specified contents, so it is not necessary to request an expert such as a system engineer to change the program as in the past, and it is easy for a business person who is a general user It is possible to easily obtain a desired form or the like.

[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 printout example of a form.

FIG. 3 is a diagram specifically showing the contents defined in table A.

FIG. 4 is a diagram specifically showing the contents defined in table B.

5 is a table A join table, a table B join table obtained by analyzing the tables A and B shown in FIG. 3 and FIG.
The contents of the B table condition table and the B table total item table are concretely shown. (A) is the A table join table, (B)
Is a B table join table, (C) is a B table condition table,
FIG. 6D is a diagram showing a B-table tabulation item table.

6 is a diagram showing a calculation formula table obtained by analyzing the B table shown in FIG. 4 and an output item table forming a pair with the calculation formula table.

FIG. 7 is a diagram showing a part of contents set in a print format memory 8.

FIG. 8 is a general flowchart showing an outline of the overall operation of the table structure analysis unit 5.

9 is a flowchart showing in detail the table A join table creation process shown in FIG.

10 is a flowchart showing in detail a part of the configuration file creation processing shown in FIG.

FIG. 11 is a flowchart showing a part of a configuration file creation process following FIG.

FIG. 12 is a flowchart showing a part of a configuration file creation process following FIG.

FIG. 13 is a diagram specifically showing the operation contents of a configuration file creation process, in which (A) and (C) are configuration records and (B) is a diagram showing the contents of the final item work memory.

FIG. 14 is a diagram showing specific contents of a configuration file.

FIG. 15 is a flowchart showing a part of table creation processing relating to table B shown in FIG.

16 is a flowchart showing a part of the table creation processing continued from FIG.

FIG. 17 is a flowchart showing in detail the calculation formula table creation process shown in FIG. 8.

FIG. 18 is a flowchart showing a part of expanded file creation processing.

FIG. 19 is a flowchart showing a part of expanded file creation processing subsequent to FIG. 17;

FIG. 20 is a diagram showing a development record created based on the record contents of a plan file.

FIG. 21 is a diagram showing a development record created based on the record contents of an accounting file.

FIG. 22 is a diagram specifically showing the contents of the expansion file 11.

FIG. 23 is a diagram showing a deployment tabulation process by a deployment tabulation processing unit 12.

24A and 24B are diagrams specifically showing the operation contents of the development and aggregation processing, in which FIG. 24A is a diagram showing how a compilation record is generated from a development file and a configuration file, and FIG. 24B is newly generated. The figure which showed the expansion record.

FIG. 25 is a flowchart showing the operation of the print processing unit.

FIG. 26 is a diagram showing a print file 15 created based on the contents of the print processing unit 14 or the totalization file 13.

[Explanation of symbols]

 1 Input Section 2 Parameter Setting Section 3 Display Section 4 Parameter File 5 Table Structure Analysis Section 6 Parameter Analysis Table 7 Configuration File 8 Print Format Memory 9 Expansion File Creation Section 10 Data File 11 Expansion File 12 Expansion Aggregation Processing Section 13 Aggregation File 14 Printing Processing unit 15 Print file 16 Printer

Claims (2)

[Claims] 1. A first specifying means for specifying a record name of an output record and item contents of a record to be extracted, and an item name output as a data item of the output record and a data item corresponding to each item name. In addition to designating the output target items to be extracted in a table format, second designating means for designating a calculation formula having a variable at any column position in the column corresponding to each item name, and the first designating means. Reading means for reading a record from a predetermined file in accordance with the designated item content; and for each record name of the output record designated by the first designating means, based on the record read by the reading means A processing means for processing the data of the output target item designated by the second designating means, and an arbitrary column position designated in the column corresponding to each item name by the second designating means A calculation means for performing a series of calculations according to a calculation formula in which each variable is processed by each of the records processed by the processing means, and a record calculated by this calculation means is assigned a record name designated by the first designating means. In association with
A data processing device comprising: output means for outputting the data of the output target item of the record in association with each item name designated by the second designating means. 2. The second designating means designates a calculation expression in a plurality of fields provided corresponding to each item name in a one-to-one correspondence with each other. 1) The data processing device described.