JPH06301701A - Data processor - Google Patents

Abstract

PURPOSE:To output a business form, etc., by reading out data from a prescribed file in accordance with the designated contents, even if a person in charge of business, etc., designate directly the item contents to be extracted as an output record in accordance with an output image of the business form, etc., by a slip name and the slip item contents. CONSTITUTION:At the time of designating parameters (a record name and item contents of a sum-up record, an item name and a sum-up object item of the sum-up record, etc.) of a table A and a table B from an input part 1, when the item contents and the sum-up object item are designated by a slip name and a slip item name, a parameter converting part 5 converts them to a file name and a file item name corresponding thereto and sets them to a conversion parameter file 8. As a result, data corresponding to the defined contents of these tables A and B are read out of a prescribed file and summed up, and its sum-up record is allowed to correspond to the record name and outputted for printing.

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 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. 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. In addition, for business users of general users,
You can see the names of the slips and the slip item names that you use every day, but what kind of files are stored and managed in your office computer, etc., and how are their record structures organized?
In order to know which item exists in which file, etc., it is necessary to refer to the system design document, and in this sense, it is extremely difficult for the person in charge of business to obtain the desired form. The problem to be solved by the present invention is that even if a person in charge of business directly designates the contents of an item to be extracted as an output record according to the output image of a form or the like by the slip name and the contents of the slip item, the data from the predetermined file is specified according to the specified contents. Is to be able to read out and output forms and the like.

[0004]

Means for Solving the Problems The means of the first invention is as follows. (1A), the designation means is a key input device or the like that designates a record name of an output record (for example, a totalization record) and designates the contents of items to be extracted as an output record by a slip name and a slip item name. (2A), the correspondence table storage means stores each item name of the file defined by the file name and each item name of the slip defined by the slip name in association with each other. (3A), the reading means searches the correspondence table storage means, and stores the file name corresponding to the slip name designated by the designation means and the item name of the file corresponding to the designated slip item name in the correspondence table storage. Read from the means. (4A), the extracting means extracts a record from the file based on the file name read by the reading means and the item name of the file. (5A), the processing means processes this extracted record for each output record having the record name designated by the designating means on the basis of the record extracted by the extracting means. For example, record aggregation is performed. (6A), the output means outputs the output record processed by the processing means in association with the record name designated by the designating means. For example, by printing the aggregate record in association with the record name. Create a form. The means of the second invention is as follows. (1B), the designating means designates an item name to be output as a data item of an output record, and the output target item to be extracted as a data item corresponding to each item name is a slip name and an item name of this slip. It is a key input device or the like for specifying and further specifying the extraction condition of the output target item. (2B), correspondence table storage means, (3B), read means is the correspondence table storage means of (1A), (2A)
Since the reading means is the same as the reading means, the description thereof is omitted. (4B), the extracting means extracts the record according to the file name read by the reading means and the item name of the file, and according to the extraction condition designated by the designating means. (5B), the processing unit processes the data of each item of the record extracted by the extraction unit for each item name designated by the designation unit. (6B), the output means outputs the output record processed by the processing means in accordance with the item name designated by the designating means.

[0005]

The operation of the means of the first invention is as follows. Now, in order to obtain the desired form etc., specify the record name of the output record from the keyboard etc. according to the output image, and specify the item contents to be extracted as the output record with the slip name and the slip item name. According to the contents, the corresponding file name and the item name of this file are read from the correspondence table. Then,
The extracted record extracted from the file according to this file name and the item name of this file is processed for each output record of the specified record name. The output record thus processed is output in association with the designated record name. The operation of the means of the second invention is as follows. Now, in order to obtain the desired form etc., specify the item name to be output as a data item of the output record from the keyboard etc. according to the output image, and the output target to be extracted as a data item corresponding to each item name Specify the item with the slip name and the item name of this slip,
Further, when the extraction condition of the output target item is designated, the file name and the item name of this file corresponding to the file are read from the correspondence table according to the designated contents.
Then, the data of each item of the extracted record extracted from the file according to the file name, the item name of the file, and the specified extraction condition is processed for each specified item name. The output record thus processed is output according to the designated item name. Therefore, even if the person in charge of business directly specifies the item content to be extracted as an output record according to the output image of the form etc. by the slip name and the slip item content, the data is read from the predetermined file according to the specified content and the form is read. Etc. can be output.

[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 in accordance with the data input from the input unit 1, is displayed and output from the display unit 3, and is stored in the input parameter file 4. Set. Since the tables A and B will be described in detail later, they will be briefly described 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 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 set in the input parameter file 4 is configured as shown in FIG. 3 and the table B is configured as shown in FIG. 4, and the table A corresponds to the aggregation level and the record name of the aggregation record and the items to be extracted as the aggregation record. It is a definition table that defines contents and the like. Further, the table B defines the item names to be extracted as the data items of the aggregate record and the items to be aggregated to be extracted as data items corresponding to the item names, the format at the time of printing the form, the extraction conditions of the items to be aggregated, and the like. It is a definition table.

In the input parameter file 4, the basic formats (ruled line data, etc.) corresponding to tables A and B are fixedly stored in advance by the maker side.
Correspondence between the A table parameter data and B table parameter data of various forms arbitrarily input from the input unit 1 and the various form names arbitrarily input from the input unit 1 and the A table parameter data and B table parameter data The table is stored.

The table A parameter set in the input parameter file 4 does not define the content of the item to be extracted as the totalized record by the file name and the item name of the file, but by the slip name and the slip item name. It was done. Similarly, in the B table parameter, the totaling target item to be extracted as a data item is not defined by the file name and the item name of the file, but by the slip name and the slip item name, and the totaling target item is extracted. The condition is also defined by the slip item name. Since the parameters of the tables A and B set in the input parameter file 4 in this way are parameters based on the slip name, the parameter conversion unit 5
Converts the contents of the input parameter file 4 into parameters based on the file name. That is, the parameter conversion unit 5 refers to the table A parameter and the table B parameter in the input parameter file 4 by referring to the file name / slip name correspondence table 6 and the file item name / slip item name correspondence table 7 and based on the file name. The converted result is set in the conversion parameter file 8.

FIG. 5 shows the contents of the file name / slip name correspondence table 6, which corresponds to various file names such as "plan file" and "accounting file". "Budget plan", "Purchase slip"
The parameter setting unit 2 sets the file name and the slip name in the file name / slip name correspondence table 6 based on the data input from the input unit 1.
The parameter setting unit 2 also creates a file item name / slip item name correspondence table 7 based on the contents of the file name / slip name correspondence table 6. FIG. 6 shows a part of the file item name / slip item name correspondence table 7, and the file item name / slip item name correspondence table 7 shows, for each file, each item name of the file defined by the file name. , And various table names associated with each item name defined by the slip name. Here, Fig. (A) shows each item name of the file defined by the file name "plan file" and each of the slips defined by the slip name "budget plan document", "corrected budget application form" for the slip type. It is a table in which item names are associated with each other. Similarly, FIG. 6B is a table in which each item name of the file defined by the file name "accounting file" is associated with each item name of the slip defined by the slip name "purchase slip". Is. In this case, since the purchase slip is further divided into “debit” and “credit” as shown in the figure, the slip item name “debit” and the slip item name “credit” are associated with the file item name, respectively. There is. The "type" set corresponding to the item name of the file is identification information indicating that the item content indicated by the corresponding file item name is a code, and the "table name" corresponds Is a reference table for code / character conversion that is referred to when the item content indicated by the file item name to be executed is a code. Here, as shown in FIG. 7A, the type is “code” and the table name is “budget table” corresponding to the file item name “budget item”.
Is set, and corresponding to the file item name "plan type", "type" is set for the type and "plan table" is set for the table name. In the figure, the value in <> indicates a fixed value, and <4251> indicates a fixed value of the ruled line code.

On the other hand, referring to the file name / slip name correspondence table 6 and the file item name / slip item name correspondence table 7 shown in FIGS. 3 shows conversion parameters when the A table parameters and B table parameters are converted. FIG. 7 shows conversion parameters of the table A obtained by converting the input parameters shown in FIG. 3, and in this case, the item contents to be extracted as the totalized record are defined by the file name and the file item name. Further, FIG. 8 shows conversion parameters of the table B obtained by converting the input parameters shown in FIG. 4, and in this case, the totaling target items to be extracted as data items are defined by the file name and the file item name, and the extraction condition is also set. It is defined by the file item name.

The table structure analysis unit 9 operates according to the start command input from the input unit 1 when printing the form, and the A table parameter data in the conversion parameter file 8 corresponding to the form name arbitrarily designated as an output target, The B-table parameter data is analyzed, and various parameter analysis tables 10 are created according to the analysis results. In this case, in this embodiment, the parameter analysis table 10 shown in FIG.
Other than the A table join table as shown in (A), the B table join table as shown in (B), the B table condition table as shown in (C), and the B table total item table as shown in (D) Although not shown, a B spreadsheet calculation table is created. Further, the table structure analysis unit 9 analyzes the hierarchical structure and the like according to the aggregation level defined in the table A, and creates the configuration file 11 based on the analysis result. The configuration file 11, which will be described in detail later, represents the correspondence between the items to be totalized in the table A and the corresponding totalized records, the vertical relationship in the hierarchical structure of the totaling level, and the like. Further, the table structure analysis unit 9 reads out the item names of each column defined in the header position of the table B, for example, “expense item”, “initial plan”, etc. and sets them in the print format memory 12. , The print format of each column defined in the format position of the table B is read and set in the print format memory 12. After that, the table structure analysis unit 9 gives a start command to the expansion file creation unit 13.

The expansion file creation unit 13 refers to various table contents in the parameter analysis table 10 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 15. When the expansion file 15 is created in this way, the expansion file creating unit 13 gives a start instruction to the expansion aggregation processing unit 16.

The expansion totalization processing section 16 refers to the configuration file 11 and sequentially creates totalization records one by one based on the contents of the expansion file 15, and the totalization file 17
Export to. When the totalization file 17 is created in this way, the expansion totalization processing unit 16 gives a start instruction to the print processing unit 18. The print processing unit 18 prints the contents of the totalization file 17 one by one according to the print format set in the print format memory 12 together with the form format and the printer 19.
The form is created by printing out from.

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, at the time of 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 input parameter file 4. FIG. 10 shows the display state of the basic format of Table A. Here, the basic format of table A is alphabetical characters A, B, C, D, E, and F that represent six levels of aggregation as the heading portion in the row direction, and a ruled line format for grouping that divides each aggregation level. The displayed ruled lines are "shifted" in the column direction for each counting level, and the "shift" expresses the hierarchical structure of the counting level. The hierarchical structure in this case has a relationship of A>B>C>D>E> F. A part of the basic format of the table A can be modified and changed as appropriate, and the entire table frame can be expanded or contracted.

Now, in the state in which the basic format of the table A is displayed and output, the person in charge of business operation inputs from the input section 1 to A.
Enter the parameter data in the table. FIG. 3 is a display example when the parameter data is input to the table A. In the heading portion in the row direction of the table A, an arbitrary name is input as the record name of the totalized record corresponding to each totaling level. For example, in row No. “01”, the record name “total” is input corresponding to the aggregation level A, and in row No. “02”, the record name “fixed cost” and row No. corresponding to the aggregation level B. In “03”, the record name “personnel cost” ... Is entered corresponding to 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, when the record name to be used is predetermined,
The record names of these records to be used are stored in the table, and when the record name is input, the table contents are displayed in a list on the window screen, and the record name can be input by selecting an arbitrary record name from the list. Good. Further, the record name is not limited to the name and may be a code.

Further, an arbitrary slip name and its slip item name are entered in the column heading portion of table A, which defines the item contents to be extracted as the totalized record. For example, in the table A shown in FIG. 3, two types of slip names “budget plan” and “purchase slip” are entered,
Also, the slip item name "type code" is entered in correspondence with the slip name "budget plan", and the slip name "purchase slip"
The slip item name “credit / subject code” is entered in correspondence with, and this defines the target item to be extracted as an aggregate record. When the purchase slip has “debit” and “credit”, the item name is specified by adding “credit” or “debit” before the item name. Further, in each of the matrix-shaped input areas formed by the heading portions in the row direction and the column direction of table A, the specific item contents (item code) of the item to be totaled
Has been entered. For example, for the line No. “03”, that is, the record name “personnel cost” corresponding to the aggregation level C,
The item codes “101” and “102” are entered corresponding to the “type code” of the “budget plan”, and the item code “2” corresponding to the “credit / subject code” of the “purchase slip”.
"111", "2112", and "2134" have been input. In addition, table A has a management unit area corresponding to each row No. By specifying an arbitrary row and entering a circle in the corresponding position, that row is the area where the item code is entered. Is shown. 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. Note that FIG.
In the table A shown in, an example of inputting two types of slip names is shown, but three or more types may be input, and one slip item name is input corresponding to one slip name. However, two or more slip item names may be input in correspondence with one slip name. When the table A is created in this way, the parameter setting unit 2 sets the parameter data in the input parameter file 4.

Next, the parameter setting unit 2 reads the basic format of the table B from the input parameter file 4 and outputs it for display. FIG. 11 shows the basic format of this B table. In the heading portion in the row direction, as the label of the line item, “format”, “target slip”, “total item”, “calculation formula”, “condition item”, The “condition value” is 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". Similar to the table A, in the table B, a part of the basic format can be appropriately modified and changed, and the entire table frame can be expanded or contracted.

Now, in the state in which the basic format of the table B is displayed and output, the person in charge of business works from the input section 1 to the B
Enter the parameter data in the table. FIG. 4 is a display example in the case of inputting parameter data to the B table. In the heading portion in the column direction of the B table, the item name printed out as the data item of the total record is input. For example, the item position "A" is "expense item", the item position "B" is "initial plan", the item position "C" is "corrected plan", the item positions "D", "E" are As a shared item, "actual product", and as a subordinate item, "department expense" in item position "D",
Item position "E" is "replacement expense", and item position "F"
"Factor total" is entered in the field, and "Plan difference" is entered in the item position "G".

Further, in the row item of the table B, the column width, the character type, the character size, etc. are input for each column item as the print format of the item data in "Format". The next "target slip" and "summary item" are the output target item to be extracted as a data item corresponding to the data item name that is printed out as the data item of the total record, the slip name and the item name of this slip. First, the slip name "budget plan" is entered corresponding to the column item position "B" in the "target slip", and the slip corresponding to the column item position "C" is entered. The name "corrected budget application form" is input, and further, the slip name "purchase slip" is input corresponding to the column item positions "D" and "E". Further, in the next "total item", the slip item name "amount +" is entered corresponding to the column item position "B", and the "correction amount +" is entered corresponding to the column item position "C". Further, “debit / acceptance amount +” and “credit / acceptance amount −” are entered corresponding to the column item positions “D” and “E”, respectively. Here, the plus / minus sign defines the addition total or the subtraction total when totaling the records. The next "calculation formula" is for inputting the output unit and the calculation formula of the aggregation operation when outputting the aggregation result. In the illustrated example "B / 1000", the content of data item B is divided by "1000" It indicates that output should be made in units of yen.

On the other hand, the condition item and the condition value define that only records whose item data correspond to a predetermined value among the extracted records extracted according to the definition contents of the table A should be totaled. This "condition item"
Enter the slip item name. Here, “plan No” is input to each of the column item positions “B” and “C” as the “condition item”, and “1” is input to the column item position “B” and the column item position as the “condition value”. "C" is "2", "3", "4"
Similarly, the column item positions "D" and "E" are entered as "condition items" and "debit / item code", respectively, and the column item position "D" is displayed as "condition value". ≠ 0011 (indicating that all codes other than 0011 should be extracted) ", and" 0011 "is entered in the column item position" E ". Also, like the above,
When a purchase slip has “debit” and “credit” like a purchase slip, “debit” or “debit” is added in front of the item name in the description for specifying the item name. 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 input parameter file 4.

Here, since the table A parameters and table B parameters set in the input parameter file 4 are based on the slip name, the parameter conversion unit 5 uses the file name / slip name correspondence table 6 and the file items. By referring to the name / slip item name correspondence table 7, the contents of the input parameter file 4 are converted into parameters based on the file name. That is, the parameter conversion unit 5 first reads the table A parameter in the input parameter file 4, searches the file name / slip name correspondence table 6 for the file name corresponding to this slip name, and searches this file name for the corresponding file name. Convert to. Next, the file item name / slip item name correspondence table 7 is searched based on this file name, and the correspondence table is accessed. Then, this correspondence table is searched and the slip item name in the A table is converted into the item name of the corresponding file. Since "budget plan" is entered as the slip name in the table A shown in FIG. 3, this slip name is converted into the corresponding file name "plan file".
Since the "type code" is input as the item name of the slip, the item name of this slip is converted into the item name "budget item" of the corresponding file. Similarly, the next slip name "purchasing slip" in table A corresponds to the corresponding file name "accounting file".
Further, the item name "credit / subject code" of the slip is converted into the item name "account item" of the corresponding file. As a result, the input parameters of the table A shown in FIG. 3 are converted into the table A parameters based on the file name as shown in FIG. 7 and set in the conversion parameter file 8.

Next, the parameter conversion unit 5 reads the parameters of the B table shown in FIG. 4 from the input parameter file 4, and corresponds to the column item position of the B table, and the form name "target form" defined in the "target form". Budget Plan ”,“ Modified Budget Request Form ”
To the corresponding file name “plan file” and the slip name “purchase slip” to the corresponding file name “accounting file”. Further, the item name "amount +" of the slip defined in "Aggregation item" corresponding to each column item position in table B corresponds to the item name "budget amount +" of the corresponding file.
, "Correction amount +" to "budget amount +", and further, "debit /
The “inspection amount +” and “credit / inspection amount −” are converted into “debit amount +” and “credit amount −”, respectively. Next, the item name "plan No" of the slip defined in the "condition item" corresponding to each column item position in the table B, the item name "plan type" of the corresponding file of the "debit / subject code", Convert to "counterpart". As a result, the input parameters of the A table shown in FIG. 4 are converted into B table parameters based on the file name as shown in FIG. 8 and set in the conversion parameter file 8.

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 9 follows the flowchart shown in FIG. Operate. Note that FIG. 12 is a general flow showing an outline of the entire operation of the table structure analysis unit 9.
The table structure analysis unit 9 reads the A table parameter data of the specified form from the conversion parameter file 8 to create an A table connection table (step A1) and a configuration file (step A2). Next, the table structure analysis unit 9 reads the B table parameter data of the specified form from the conversion parameter file 8 to create a combined table of the B table (step A3), and a condition table (step A4).
A total item table (step A5) and a calculation formula table (step A6) are created respectively. Then, the format data is extracted from the parameter data in the table B and written in the print format memory 12 (step A7).

FIG. 13 shows a flow of creating the A table join table. The table structure analysis unit 9 analyzes the column heading portion of the A table to analyze the A table join table as shown in FIG. 9 (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 9 reads the table A parameter data of the specified form from the conversion parameter file 8 (step B1), and specifies the initial value "1" as the file symbol (step B2). Then, the column heading portion of table A is analyzed sequentially from the beginning. That is, the table structure analysis unit 9 first specifies the first file name defined in the table A (step B).
3) The initial value "1" of the sequential number SEQ is designated (step B4), and the first item name corresponding to this leading file name is designated (step B5). File name and sequential number S specified by this
The EQ, item name, and file symbol are written in the A table connection table (step B6). In this case, in the case of the A table shown in FIG. 7, the data as shown in FIG. 9A is written in the first row of the A table combination table. Next, if another item name is defined corresponding to the same file name (step B
7) Add "1" to the sequential number SEQ to update the value (step B8), specify the next item name (step B5), and write to the table A join table (step B8). 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 process proceeds to the next step B9, and if there is another file name in the table A,
Under that condition, the file symbol "1" is added 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 11 shown in FIG. 12 (step A2) will be described in detail with reference to FIGS. 14 to 16 are flowcharts showing the operation when the configuration file 11 is created.
7 is a diagram schematically showing the operation contents of the table structure analysis unit 9 in this case, and FIG. 18 is the created configuration file 1
It is the figure which showed the content of 1. Note that FIG. 18A shows the record structure of the configuration file 11, and this configuration record is composed of "child hood", "parent code", "end flag", and "name", and "child hood". 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. The “end flag” is a flag that becomes “1” when the parent code includes the aggregation level A, and when the end mark is set to “1”, the 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 9 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 C).
2). Here, if the aggregation level is A, the final item work memory in the table structure analysis unit 9 (see FIG. 17) is set for initialization.
(See (B)) is cleared (step C3), and the totaling level A is designated as the currently focused level (current level) (step C4). In this state, level line data is generated from the current level and the line number of the line currently focused (current line) (step C5). For example, taking the table A shown in FIG. 7 as an example, the first row of the table A is the aggregation level A, and the row number is "0".
Since it is "1", level line data "A01" that combines the current level and the line number is generated. Next, the level line data “A01” and the name of the current line (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 or not the management unit area of the current row is circled (step C7). Now, as shown in FIG. 7, since the first row is not marked with a circle, attention is paid to the next row of table A and it is checked 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. In this case, the totaling level of the second row is B, and therefore step C1
At 0, an error check is performed as to whether or not the level of the designated line is higher than or equal to the current level. If the level is higher than or equal to the current level, all contents below the level of the designated line are cleared in the last item memory (step C11). ).

Since the designated row level B is lower than the current level A, the flow advances to step C12 to update the current level with the designated row level as 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. 17B).
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, proceeding to step C17 in FIG. 15, the level line data stored at the level position (current level + 1) is read out from the last item work memory, and the symbol (•) is combined at the beginning of this level line data. , This combined code is set as the parent code of the configuration record (step C18). Now, the current level is B, and thus the combined code in which the symbol (•) is combined with the level row data “A01” stored in the position of the final item work memory at level A becomes the parent code ((A) in FIG. 17). 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 11. (Step C22).

Next, returning to step C7 of FIG. 14, 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). Then, 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 at the position of level C in the last item work memory (Fig. 17). (B)). Then, a join code in which a symbol (•) is added to the level row data is set as a child code of the configuration record (step C15,
C16). Next, a combination code in which the symbol (•) is added to the level row data "B02" read from the position of the level B in the last item work memory (one level higher position) is a configuration record. It is set as the parent code of (steps C17 and C18 in FIG. 15). 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, when the child code ".C03", the parent code ".B02", and the name "fixed cost" are gathered as the data for one record, this composition record becomes the composition file 11 (Step C22).

Subsequently, when it is detected in step C7 of FIG. 14 that the management unit area on the third line is circled, the process proceeds to step C23 of FIG. 16 and "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. 17C shows a configuration record in this case, where the child code is "110".
1 ", the parent code is" .C03 ", and the name is" personnel expenses "is written to the configuration file 11 (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" in the third line is specified, 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 to check 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 "personnel expenses". Now
If no other file is specified in step C32, the process returns to step C8 in FIG. 14, and thereafter, the process of creating a configuration record and writing the configuration record 11 in the configuration file 11 is performed until one setting is detected in step C8. -Repeat each one. As a result, the configuration file 11 as shown in FIG. 18 is created. The contents of the configuration file 11 are generated by referring to the table A of FIG. 3, and the eighth record to the twelfth record of the configuration file 11 are the row number “0” of the table A.
3 ", and the 13th to 15th records correspond to the row No." 04 "of the A table.

When the construction file 11 is created in this way, the table structure analysis unit 9 creates a calculation table in addition to the connection table of the B table, the condition table, the total item table. Among 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. 9B) is composed of "file name", "sequential number SEQ", "item name" of condition item, and "file symbol". In addition, the condition table (Fig. 9)
(Refer to (C)) is "file name", "item position of table B",
It consists of "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. 9D) 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 9 reads the B table parameter data of the specified form from the conversion parameter file 8 (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 and designating the condition value (step D13), 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 no other condition item is detected in step D19, 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. 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 analyzed in this way to create the B table connection table, condition table, and total item table for one column, the process proceeds to step D7, and the data in the next column of the B table is data. Is specified, and if there is, the line is specified (step D8), and then step D3
Then, the above operation is repeated.

In addition, the table structure analysis unit 9 analyzes the B-table parameter data to create a calculation formula table. In this calculation formula table, each calculation formula is associated with a column item position. Further, the table structure analysis unit 9 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 12.

Upon completion of such table creation processing, the table structure analysis unit 9 activates the expanded file creation unit 13.
Then, the expansion file creating unit 13 displays
The expanded file creation process is performed according to the flowchart shown in FIG. The expansion file 13 is a file that is intermediately generated until the totalization file 1 that is the output data of the form is created. Here, FIG. 23 shows expanded records created according to the contents of the first record to the fourth record when the source file is a plan file,
Further, FIG. 24 shows expanded records created according to the contents of the first record to the third record when the source file is the accounting file. Further, FIG. 25 shows the contents of the expansion file 15 created by this. Now, the parameter analysis table 10 is shown in FIG.
It is assumed that various tables having the contents shown in (A) to (D) are set.

First, the expansion file creating unit 13 refers to the parameter analysis table 10, extracts the file name (first file name of the first record) from the table A connection table (step E1), and specifies the file symbol. (Step E2). Next, the source file corresponding to this file name is designated (step E3), and the first record in this source file is designated (step E).
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 E5),
The item value corresponding to this item name is fetched from the designated record (first record) in the designated file (step E6). Then, this item value and the designated file symbol are combined (step E7), and this combined data is set as the classification key of the expanded record (step E8). Now
As shown in FIG. 23, the item value “101” of the budget item is extracted from the first record of the plan file, and the 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 13 refers to the B table connection table and checks whether or not there is a designated file symbol in this table (step E9). Here, as described above, when the condition item is defined in the B table, the file name, condition item name, file symbol, etc. are set in the B table connection table, so 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 not set). Since the designated file symbol "1" is set in the B table joining table, the process proceeds to step E10, 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 E11), and it is checked whether there is a matching condition value (step E12). 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 E13 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 E19
Then, the value of the position (B in this case) corresponding to the matched condition value is fetched from the B table condition table, and the value of the item position matching this is searched in the tabulation item table (step E20). The corresponding item name is designated (step E21). 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. At the same time as taking out from the record (step E22), it is checked whether or not the minus sign flag is set in the tabulation item table corresponding to this item position B (step E23).
Next, proceeding to step B24, the item value “800,000” fetched from the designated record is totaled in the corresponding position “B” of the expansion record, but in this case, for those for which the negative sign flag is set, negative totalization is performed. If the minus sign flag is not set, it is counted as plus. As a result, a first expanded record as shown in FIG. 23 is created.

Next, it is checked whether another same item position (B in this case) is set in the total item table (step E25), but as shown in FIG. 9 (D),
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 E
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 row in the condition table B, the process proceeds to step E15, and the next record is specified on condition that the next record exists in the specified plan file. (Step E18).

As a result, the second record of the plan file is designated, the process returns to step E5, 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 E5 to E8). 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 E19, where 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 E20-).
E22). In this case, as shown in FIG. 23, the budget amount item in the second record of the plan file is “200,000”.
Is taken out and added to the corresponding position “B” of the expanded record (second record) (step E24).

Next, when the third record of the plan file is designated (step E18), the classification key "1103" of the expansion 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 10, the plan file expansion record is set to 1 Create records one by one.

When it is detected in step E9 that the designated file symbol is not set in the B table connection table, the condition item is an unconditional item that is not defined, so the process proceeds to step E28. The same file name as the specified 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 E21.

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 E15, step E
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 E1 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 E1), and "2" is designated as the file symbol (step E2). Then, the accounting file is specified as the source file corresponding to this file name (step E
3) Specify the top record (step E)
4).

In this state, the item value "2111" of the "account item" 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 (steps E5 to E5). E8). Then, the process proceeds to step E9. 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 E10). 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 E11). 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 E12, the process proceeds to step E13, 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 E14, 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 E13. Now, since the negative flag is not set at the position corresponding to this condition value, the routine proceeds to step E19, 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 E20 and E21), 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 E22 to E24).

Then, the process proceeds to step E25. 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 E22). . 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. It is performed (step E24). Then, the process proceeds from step E25, E14, E15 to step E18, 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 E12 to step E26, and whether the negative flag is set corresponding to the designated file in the B table connection table. Check. B now
In the table condition table, a negative flag is set in the fifth line corresponding to the accounting file, so step E2
7, the value "D" at the position where the negative flag is set is fetched from the B table condition table, and the position matching this value is retrieved from the totalized item table (step E).
20), 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 E
From step 25, the process returns to step E21, and similarly to the above, the item value "0" of the next item name "credit amount" is negatively added 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 E12. As a result, the expansion records according to the condition value "≠ 0011" of the condition item "counter account" are sequentially generated.

After that, when all records of the accounting file have been designated and no next record is detected in step E15, the process proceeds to step E16, 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 E17, 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. 25 shows the expanded 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 creation unit 13 creates the expansion file 15 and then the expansion aggregation processing unit 16
To start. Then, the development totalization processing unit 16 creates the totalization file 17 according to the flowchart of FIG. 27. FIG. 27 is a diagram for specifically explaining the operation content of the expansion totalization processing unit 16. The development totalization processing unit 16 generates the totalization file 17 based on the contents of the expansion file 15 and the contents of the configuration file 11 according to the component expansion method. First, the expansion totalization processing unit 16 uses the expansion file 15
The data for one record is read from the beginning of (step F1). Then, in the next step F2, 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 15. At first, since the data for one record is read from the beginning of the expansion file 15, the process proceeds to the next step F3, and the configuration file 1
The contents of 1 are searched, and the configuration file 11 is searched for a configuration record having a child code that matches the classification key. Now, as shown in FIG. 27, the classification key in the first record of the expansion file 15 is "1101", and the configuration file 11 has a configuration record having a child code matching this as shown in FIG. Therefore, it is detected in step F3, and the process proceeds to step F4, and the totalization file 1
Record 7 (aggregate record) is generated. That is, FIG.
In the specific example of No. 7, first, the expansion totalization processing unit 16 reads the parent code corresponding to the child code “1101” from the configuration file 11, and the parent code “· C03” is stored in the row No. “03” of the B table and Other than ".C"
No. "03" is placed in the first item of the first record of the aggregation file 13, and ".C" other than that is placed following it. Then, the name corresponding to this child code is read from the configuration file 11 and placed in the next item of the aggregation record. Following this, the data item “8
"0000" is sequentially arranged after the next item of the totalized record. This aggregate record is an aggregate record of record name "personnel expenses" and aggregate level "C" defined in row No. "03" of table A, and aggregates defined in table A corresponding to this record name. This is a summary of the data corresponding to the target code. When the data for one record of the totalization file 17 is generated by this, this generated record is written to the totalization file 17. At this time, the totalization file 1
If a record having the same classification key already exists in 7, the record is totalized into one record and written in the totalization file 17, and if no record having the same classification key exists, the record generated this time is set. New aggregate file 1
7 (step F5).

Next, it is checked whether the end flag is set at the corresponding record position in the configuration file 11 (step F6). Here, the end flag in the configuration file 11 is "1" when the aggregation level of the parent code is "A". When the end flag is "1", the process directly returns to step F3, but the end flag is " If it is not 1 ”, a new expansion record is generated and the expansion file 15
Is written to (step F7). In this case,
A record as shown in (B) of 7 is generated and returned to the expansion file 15. That is, if a record name at a higher level than the totalized record generated this time is defined in table A,
A new expansion record is generated and written in the expansion file 15 in order to total the totalization result of the totalization record generated this time into the totalization record of the record name in the upper level. Here, the corresponding parent code “· C03” in the configuration file 11 is placed in the first item, and subsequently, a record in which the data read from the development file 15 is sequentially placed is written to the development file 15. In the expanded file 15 shown in FIG. 25, the record placed below the broken line in the drawing shows the returned record.

Thereafter, the process returns to step F3, and thereafter, the entire contents of the configuration file 11 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 F3 and the disagreement ends, the process returns to step F1 to read the next record from the expansion file 15. Such an operation is performed for all records in the expanded file 15. 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. Then, the end of data is detected in step F1 and the process proceeds to step F8, and the records forming the totaling file 17 are sorted in ascending order according to the contents of the first item (row No.) thereof. 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 17 is created in this way, the expansion totalization processing unit 16 activates the print processing unit 18. Then, the print processing unit 18 takes in the contents of the print format memory 12 and causes the printer 19 to print out the contents of the summary file 17 together with the form format in accordance with the print format. In this case, each record name stored in the totalized record of the totalization file 17 is sequentially taken out and arranged in the vertical direction, and each item name stored in the print format memory 12 is sequentially taken out to the corresponding position of the form format. Print out. 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 hierarchical structure format according to the total level, and the item name of the total record is printed in the column direction. Further, the contents of the totalization file 13 are printed out for each record.

As described above, in the present embodiment, in order to obtain a form desired by a person in charge of business who does not have specialized knowledge, the table A and the table B, which are aggregate definition tables, are arbitrarily defined according to the output image. Then, the contents of any record item are read from the specified file according to the definition contents, records are aggregated in a hierarchical structure according to the aggregation level, and the aggregation results are printed in a hierarchical structure. Even a person can easily obtain a desired form. In particular, when the table A and the table B are defined, even if they are defined by the slip name and the slip item name that the business person is familiar with, the slip name and the slip item name correspond to the corresponding file name and file item name. Since it is automatically converted to, it is not necessary for the person in charge of business to define tables A and B with file names and file item names by referring to the system design document, and anyone can easily define tables A and B. It is possible to

In the above embodiment, the case where the records are totaled has been described, but by setting the totaling level of the table A to only A, not only the totalization of the records but also the record extraction, the array, the intra-item calculation, etc. are performed. You may Further, although the above-mentioned embodiment shows the case where the form is printed out,
You may make it output to CRT screen display or other media. 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, and the configurations of the tables A and B are also possible. Is not limited to the above embodiment. Further, in the above embodiment, the item code is input at an arbitrary intersection position on the matrix formed by the heading section of the table A, but the item name may be input.
Further, the record name of the totalized record input in the row direction is input in the hierarchical structure according to the totaling level, but it is needless to say that the record name is not limited to the hierarchical structure. By printing the images of the tables A and B themselves from the parameter file, it may be possible to store the specifications such as a form in a form that the person in charge of business can understand.

[0058]

According to the present invention, even if the person in charge of business directly specifies the item content to be extracted as an output record according to the output image of the form or the like by the slip name and the slip item content, the specified content is Therefore, it is possible to read data from a specified file and output forms, etc., so there is no need to request an expert such as a system engineer to create a code system as in the past, and the contents of items to be extracted as output records It is not necessary to check the file name and file item name by referring to the system design document when designating, and it is possible for a business person who is a general user to easily obtain the desired form, which is extremely practical. It will be rich in.

[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 concretely showing the definition contents of table A based on the slip name defined in the input parameter file 4.

FIG. 4 is a diagram specifically showing the definition contents of table B based on the slip name defined in input parameter file 4.

FIG. 5 is a diagram showing the contents of a file name / slip name correspondence table 6.

FIG. 6 is a diagram showing the contents of a file item name / slip item name correspondence table 7.

FIG. 7 is a diagram concretely showing the definition contents of a table A based on the file name converted by the parameter conversion unit 5 and set in the conversion parameter file 8.

FIG. 8 is a diagram concretely showing the definition contents of a table B based on the file name converted by the parameter conversion unit 5 and set in the conversion parameter file 8.

9 is a table A join table, a table B join table obtained by analyzing the tables A and B shown in FIG. 7 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.

FIG. 10 is a diagram showing a basic format when defining table A.

FIG. 11 is a diagram showing a basic format when defining a B table.

FIG. 12 is a general flowchart showing an overview of the overall operation of the table structure analysis unit 9.

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

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

FIG. 15 is a flowchart showing a part of configuration file creation processing continued from FIG. 14;

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

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

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

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

FIG. 20 is a flowchart showing a part of table creation processing continued from FIG. 19;

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

FIG. 22 is a flowchart showing a part of expanded file creation processing following FIG. 21.

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

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

FIG. 25 is a diagram concretely showing the contents of the expansion file 15.

FIG. 26 is a diagram showing a deployment tabulation process by a deployment tabulation processing unit 16;

27A and 27B are diagrams specifically showing the operation contents of the expansion and aggregation processing, in which FIG. 27A is a drawing showing the generation of a totalization record from the expansion file and the configuration file, and FIG. The figure which showed the expansion record.

[Explanation of symbols]

 1 input section 2 parameter setting section 3 display section 4 input parameter file 5 parameter conversion section 6 file name / slip name correspondence table 7 file item name / slip item name correspondence table 8 conversion parameter file 9 table structure analysis section 10 parameter analysis table 11 Configuration file 12 Print format memory 13 Expanded file creation unit 14 Data file 15 Expanded file 16 Expanded aggregation processing unit 17 Aggregation file 18 Print processing unit 19 Printer

Claims (2)

[Claims] 1. A designation means for designating a record name of an output record and designating the contents of items to be extracted as an output record by a slip name and a slip item name, and each item name of a file defined by the file name. Correspondence table storage means for storing each item name of the slip defined by the slip name in association with each other, and searching the correspondence table storage means, and the file name and the designated file name corresponding to the slip name designated by the designation means. Reading means for reading the item name of the file corresponding to the slip item name from the correspondence table storage means, and a record is extracted from the file based on the file name read by the reading means and the item name of the file. Based on the extraction means and the record extracted by this extraction means, this extraction record is designated by the designation means. And an output unit that outputs the output record processed by the processing unit in association with the record name designated by the designating unit. Data processing device. 2. An item name to be output as a data item of an output record is specified, and an output target item to be extracted as a data item corresponding to each item name is specified by a slip name and an item name of this slip. Further, a specifying means for specifying the extraction condition of the output target item, and a correspondence table storing means for storing the item name of the file defined by the file name and the item name defined by the slip name in association with each other. Reading means for searching the correspondence table storage means and reading out the file name corresponding to the slip name designated by the designation means and the item name of the file corresponding to the designated slip item name from the correspondence table storage means; According to the file name read by the reading means and the item name of this file, and according to the extraction condition designated by the designating means. An extracting means for extracting a code, a processing means for processing the data of each item of the record extracted by the extracting means for each item name designated by the designating means, and an output record processed by the processing means A data processing device comprising: an output unit that outputs according to the item name designated by the designation unit.