JP3309164B2 - Print processing device - Google Patents

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a data processing system, which is independent of a computer, a terminal device and the like and independently performs a form printing and the like.

[0002]

2. Description of the Related Art Conventionally, in an office processing device such as an office computer or a general-purpose computer, an accounting file,
Various types of files such as personnel files, sales slip files, and inventory files are stored and managed, but the record structure that constitutes each file is different for each file.
Each file is stored and managed as a separate file for each record of the same form (records in which each item of the record matches). Here, when an arbitrary item is specified and a record including the item is read out from the file and classified and totaled, even if a data in the item is first classified and classified so that it is easy to classify and total, the time elapses. As a result, the classification does not match the reality, and the classification and totaling cannot be performed as it is at present. Therefore, conventionally, as a countermeasure, a code conversion table for classifying and totaling is provided, and a method of classifying and totaling by converting the code system into an optimal code system for classifying and totaling using the code conversion table has been 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. In other words, creating a classification code system in response to various business needs requires extremely specialized and advanced knowledge, and it is extremely difficult for a general user's business staff to create it. At present, it was necessary to ask a system engineer to create it. Further, since the printing apparatus simply receives the result processed by each processing terminal device in the print format and prints it, each processing terminal device must have a processing program for each processing terminal device. It was necessary to take countermeasures in accordance with differences in the programming languages of the devices. An object of the present invention is to simply specify output contents of a form or the like from an external device such as a processing terminal apparatus to a print processing apparatus without creating a code system in advance to obtain a desired form or the like. The purpose is to select a print processing apparatus that can independently collect and process data necessary for form printing and the like according to the specified contents.

[0004]

The means of the present invention is as follows.
It is. A printing device that prints a form in response to a print request from an external device, and specifies records and items constituting the form, and specifies data that is a source of form creation;
A receiving unit for receiving a parameter including a designation of a data processing method from an external device when the parameter is transmitted from the external device, and a reading unit for reading from the external device data that is a source of a form specified by the parameter. Processing means for processing data read from the external device based on a data processing method specified by the parameter;
And a printing means for printing the processed data as a form including records and items designated by the parameters.

[0005]

[0006]

An embodiment will be described below with reference to FIGS. FIG. 1 is a system configuration diagram showing a data processing system. This data processing system is an in-company / private land information communication network (local area network) system and has a host computer 200 in addition to a form print processing device 100 unique to the present embodiment. Form print processing device 10 via
0, an input terminal device 300, a file server 400, and a printer 500 are connected. Further, in this system, various source files such as an accounting file, a personnel file, an inventory file, a sales slip file, etc. are stored and managed in the host computer 200, the file server 400, and the like. The user can arbitrarily specify an aggregation target for each aggregation level using the aggregation definition table from the host computer 200, the input terminal device 300, or the like, and transfer this definition content to the form print processing apparatus 100 as parameter data. The form print processing apparatus 100 analyzes the parameter data and stores the corresponding file in the host computer 200 or the file server 40.
The records are read out from 0 and the like, and the records are tabulated in a hierarchical structure corresponding to the tabulation level, and this tabulation result is printed out as form data. That is, the form print processing apparatus 100
Is a process for independently creating and printing out form data, and the host computer 200 or the input terminal device 300 inputs a summary definition table for obtaining a desired form, and simply uses this definition content as parameter data. What is necessary is just to transfer to the form print processing apparatus 100.

FIG. 2 is a block diagram of the form print processing apparatus 100. The form print processing apparatus 100 has a receiving unit 1 for receiving data and commands transmitted from the host computer 200, the input terminal device 300, and the like. It operates in response to a start command transmitted via the receiving unit 1. Here, in order for a business person or the like to instruct desired record totaling from the host computer 200 or the input terminal device 300, a definition table defining a record name of a totaling record, a totaling target, a totaling condition, and the like (this embodiment) There are two types of tables A and B)
Is input, the input data is transmitted to the form print processing apparatus 100 as parameters of Table A and Table B. At this time, the parameter setting unit 2 generates the tables A and B according to the parameters, and sets them in the parameter file 4. The tables A and B will be described in detail later, and will be described briefly here. For example,
In order to print out the “expense record table” as shown in FIG. 3 as a desired form, tables A and B are generated as a summary definition table according to the output image of the form. Here, the form shown in FIG. 3 is such that the record name of the tally record is arranged in a row item, and the data item name of the tally record is arranged in a column item. Table A is configured as shown in FIG. 4, and Table B is configured as shown in FIG. 5. Table A is a definition table that defines the record name of the total record and the item contents extracted as the total record for each total level. Table B is a definition table that defines the item names output as data items of the tally record, the output target items extracted as data items corresponding to the item names, the format when printing the form, the tally conditions, and the like. .

The parameter file 4 has a basic format (ruled line data, etc.) fixedly stored in advance by the maker side corresponding to the tables A and B, and various forms input arbitrarily from the receiving unit 1. A table parameter data and B table parameter data, and a correspondence table that associates various form names arbitrarily input from the receiving unit 1 with A table parameter data and B table parameter data are stored. When there is a request from the host computer 200 or the input terminal device 300 to instruct the form print processing apparatus 100 to set the parameters, the parameter setting unit 2 reads out the basic formats of the tables A and B from the parameter file 4 and transmits them. The data is transferred to the requesting host computer 200 or the input terminal device 300 via the unit 3. Also, the parameter file 4 stores an initial menu having “parameter setting”, “execution of form printing”, and “end of form printing” as menu items for form printing. It is transmitted to the request source according to the request from the input terminal device 300.

The table structure analysis unit 5 operates according to a start command (form output command) input from the reception unit 1 at the time of printing a form, and outputs an A table corresponding to a form name arbitrarily specified from the reception unit 1 as an output target. The parameter data and table B parameter data are analyzed, and various parameter analysis tables 6 are created according to the analysis results. In this case, in the present embodiment, the parameter analysis table 6 shown in FIG.
Table A as shown in FIG. 6B, and B as shown in FIG.
In addition to a table join table, a table B condition table as shown in FIG. 6C, a table B total item table as shown in FIG.
Although not shown, a table B calculation formula table is created. Further, the table structure analysis unit 5 analyzes a hierarchical structure or the like corresponding to the aggregation level defined in the table A, and creates a configuration file 7 based on the analysis result. Further, the table structure analysis unit 5 determines the item name of each column defined in the header / position of the table B, for example,
In addition to reading out the names such as "expense item" and "initial plan" and setting the same in the print format memory 8, the print format of each column defined in the format position of the table B is read out and stored in the print format memory 8. Set. After that, the table structure analysis unit 5 gives a start command to the expanded file creation unit 9.

The development file creation unit 9 designates a file to be summed up by referring to the contents of various tables in the parameter analysis table 6, and refers to the data file 10 to store and manage the file to be summed up in any external device. Search. The data file 10 associates file names of various source files that are distributed and managed by the host computer 200, the file server 400, and the like, with machine numbers that indicate physical addresses of external devices in which the source files are stored and managed. The development file creation unit 9 reads the machine number corresponding to the tallying target file from the data file 10, transmits the machine number from the transmission unit 3, and receives the necessary file via the reception unit 1. In addition, the expanded file creation unit 9 sequentially generates expanded records one record at a time based on the records extracted from the aggregation target file by referring to the parameter analysis table 6 and writes the generated records to the expanded file 11. When the development file 11 is created in this way, the development file creation unit 9 gives a start instruction to the development totalization processing unit 12.

The development tabulation unit 12 sequentially creates a total record one record at a time based on the contents of the development file 11 with reference to the configuration file 7, and writes the total record into the total file 13. When the tally file 13 is created in this way, the development tally processing unit 12 gives a start command to the print processing unit 14. The print processing unit 14 forms a form by causing the printer 15 to print out the contents of the tabulation file 13 together with the form format one record at a time in accordance with the print format set in the print format memory 8.

Next, the operation of this embodiment will be described. FIG. 7 is a flowchart showing an operation specific to the present embodiment in the host computer 200 and the input terminal device 300. When a predetermined operation is performed to specify the form print processing apparatus 100, the operation according to FIG. Is done. First, the user sets his / her own operation mode to the terminal mode (step S1) and designates activation of the form print processing apparatus 100 (step S2). In this case, the form print processing device 100
In step (1), the parameter setting unit 2 first reads and transmits the initial menu from the parameter file 4, and the host computer 200 and the input terminal device 300 receive the initial menu and display and output the initial menu (step S3). As described above, this initial menu has items of “parameter setting”, “execution of form printing”, and “end of form printing”.
When a desired item is selected and designated from the menu items (step S4), the designated item is determined (step S5).

[0013] Here, first, "parameter setting"
If the item is designated, the process proceeds to the next step S6, where parameter setting processing is performed. First, in the form print processing apparatus 100, the parameter setting unit 2 reads and transmits the basic format of the table A stored in the parameter file 4. The host computer 200 or the input terminal device 300 which has received the format of the table A displays the format on the CRT screen.

FIG. 8 shows the display state of the basic format of Table A. Here, the basic format of the table A is an alphabetic character A, B, C, D, E, or F indicating a totaling level of six levels as a heading part in the row direction, and a ruled line format for dividing each totaling level. Is displayed,
The ruled lines for this consolidation are "shifted" in the column direction for each aggregation level.
The “shift” expresses the hierarchical structure of the aggregation level. The hierarchical structure in this case is A>B>C> D
>E> F. Here, the record name of the aggregation record is input in the row item of the table A in correspondence with the aggregation level, and in the column direction, the name of the file to be aggregated and the item name to be extracted from the file as the aggregation record Is entered. A part of the basic format of the table A can be appropriately modified and changed, and the entire table frame can be expanded or reduced.

Now, in a state where the basic format of the table A is displayed and output, the business operator inputs the parameter data of the table A from the input unit. FIG. 4 is a display example when parameter data is input to Table A. Here, an arbitrary name corresponding to each totaling level is input as a record name of the totaling record in the row heading portion of the table A. For example, the record name “Total” is input to the row No. “01” corresponding to the aggregation level A, and the record name “Fixed Cost” and the row No. corresponding to the aggregation level B to the row No. “02”.
For “03”, the record name “personnel cost”... Corresponding to the aggregation level C is input. In the above example, an arbitrary record name is directly input for each aggregation level. However, when a record name to be used is predetermined,
These record names to be used are stored in a table, and when the record name is input, the contents of this table are displayed in a list on a 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 file name and an item name are input in the heading portion in the row direction of the table A. For example,
In table A shown in FIG. 4, two types of file names "plan F"
ILE "and" accounting FILE "are input, thereby defining a target file name from which file the totals record should be extracted. In addition, the item name “budget item” is input corresponding to the file name “plan FILE”, and the item name “account item” is input corresponding to the file name “accounting FILE”. A target item name to be extracted as a total record is defined. Further, specific item contents (item codes) of the tabulation target items are input to each of the matrix-shaped input areas formed by the row and column headings of Table A. For example, for the row No. “03”, that is, for the record name “personnel cost” corresponding to the aggregation level C,
Item codes “101” and “102” are input corresponding to “budget items” of “plan FILE”.
Item code “211” corresponding to “Account” of “LE”
1 "," 2112 ", and" 2134 "are input,
As a result, 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 among the account items constituting the accounting file, the item codes “2111” and “2”
It is defined that records corresponding to “112” and “2134” should be extracted.

In the table A, a management unit area is provided corresponding to each row No. By specifying an arbitrary row and inputting a circle at a position corresponding to the row, an item code is input to the row. Indicates that the area is to be used. This is to improve the processing speed by analyzing the definition content of the table A for each row, by analyzing the rows marked with the circles and excluding other rows from the analysis. At the same time, it also means that the business person in charge confirms that the data to be extracted and totaled is in the source file (account file, etc.). In Table A shown in FIG. 4, an example in which two types of file names are input is shown. However, three or more types of file names may be input, and one item name corresponds to one file name. Is input, but two or more item names may be input in correspondence with one file name.

Next, the parameter setting section 2 reads out the basic format of Table B from the parameter file 4 and sends it to the host computer 200 or the input terminal device 300. FIG. 9 shows a basic format of the table B. In the heading portion in the row direction, "format", "target FILE", "total item", "calculation formula",
“Condition items” and “condition values” are fixedly set in advance, and each column item of the heading portion in the column direction of Table B has “A”, “B”,
.., “G”. In the table B, similarly to the table A, a part of the basic format can be appropriately modified and changed, and the entire table frame can be expanded or reduced.

Now, in a state where the basic format of the table B is displayed and output, the business operator inputs the parameter data of the table B from the input unit. FIG. 5 is a display example when parameter data is input to the table B. Here, an item name to be printed out as a data item of the total record is input in the heading portion in the column direction of the table B. For example, item position “A” has “expense item” and item position “B”
Indicates the “initial plan”, item position “C” indicates the “correction plan”,
The item positions “D” and “E” have “real results” as a shared item, and the item positions “D” have “department expenses” as subordinate items, and the item position “E” has “distribution expenses”. The item position “F” is input with “actual meter”, and the item position “G” is input with “planned difference”.

In the row items of the table B, the column format, the character type, the character size, etc. are input for each column item as the print format of the item data in the "format". In the next "target FILE", "plan FILE" is input corresponding to column item positions "B" and "C", and column item position "D",
"Accounting FILE" is input corresponding to "E".
Further, the next “totaling item” defines which item data should be totaled out of the records extracted as the totaling target, and corresponds to “budget amount +” corresponding to the column item positions “B” and “C”. ", And" debit amount + "and" credit amount-"are input corresponding to the column item positions" D "and" E ". Here, the plus / minus signs define addition / subtraction tallying. The following “calculation formula” is used to input the output unit and the calculation formula of the tallying operation when outputting the tallying result. In the illustrated example “B / 1000”, the content of the data item B is divided by “1000” to Indicates that the output should be made in yen units. On the other hand, "condition item" and "condition value" define that only records whose item data corresponds to a predetermined value among the extracted records extracted according to the definition contents of Table A should be totaled. The column item positions "B" and "C" are each input with "plan type" as the "condition item", and the column item position "B" is "1" and the column item position ""C" is "2",
"3" and "4" are input, and similarly, "Contra account" is placed in column item positions "D" and "E" as "condition items", respectively.
Is input in the column item position "D" as "condition value", and "$ 0011 (indicating that all codes except for 0011 should be extracted)". In the column item position "E", “0011” has been entered. In addition, "Expense record table" is input as a form name outside the table frame of Table B.

Thus, the host computer 200
When the parameters of the tables A and B are input from the input terminal device 300 or the input terminal device 300, the parameters are transmitted to the form print processing device 100. Then, in the form print processing apparatus 100, the parameter setting unit 2 sets the A table parameter and the B table parameter in the parameter file 4 in association with the form name. Next, when the host computer 200 or the input terminal device 300 instructs execution of the form in order to print out the form, the process proceeds to step S7 in FIG. 7 and form print execution processing is performed. In this case, in the form print processing apparatus 100, the parameter setting unit 2 reads out the form name list from the table in the parameter file 4 and transmits the form name. The host computer 200 and the input terminal device 300 receive this form and display the form name list. . When a desired form name is selected and designated from the list screen, an execution command is transmitted to the form print processing apparatus 100 together with the form name. Thus, the parameter setting process (step S6), the form print execution process (step S6)
When 7) is completed, the process returns to step S3. If “end of form printing” is selected and designated from the initial menu, the process exits from this flow.

When a form printing execution command is input together with a form name from the host computer 200 or the input terminal device 300, the table structure analysis unit 5 in the form print processing apparatus 100 operates according to the flowchart shown in FIG. . FIG. 10 is a general flow diagram showing an outline of the entire operation of the table structure analysis unit 5. First, the table structure analysis unit 5 reads out the A table parameter data of the designated form from the parameter file 4 and creates an A table connection table. At the same time (step A1), a configuration file is created (step A2). Next, the table structure analysis unit 5 reads the B table parameter data of the designated form from the parameter file 4 and
While creating a join table of the tables (step A3),
A condition table (step A4), a total item table (step A5), and a calculation formula table (step A6) are created. Thereafter, data relating to the format is extracted from the parameter data of Table B and written into the print format memory 8 (step A7).

FIG. 11 shows a flow of creating the A table connection table. The table structure analysis section 5 analyzes the column heading portion of the A table and analyzes the A table connection table as shown in FIG. Create Here, the A table join table is a correspondence table that associates file names and item names defined in the A table, and includes “file name”, “sequential number SE”.
Q "," item name ", and" file symbol ". Here, the sequential number SEQ is a code for specifying an item name defined in the same file by a consecutive number from “01”, and “file symbol” is a file defined in Table A. Is a code for specifying the serial number from “1”.

First, the table structure analysis unit 5 reads out the parameter data of the designated form A from the parameter file 4 (step B1) and designates an initial value "1" as a file symbol (step B2). Then, the headings in the column direction of Table A are sequentially analyzed from the top.
That is, the table structure analysis unit 5 first specifies the first file name defined in the table A (step B3), and then specifies the initial value “1” of the sequential number SEQ (step B4). The first item name corresponding to the first file name is designated (step B5). The designated file name, sequential number SEQ, item name, and file symbol are written in the table A connection table (step B6). In this case, in the case of the table A shown in FIG. 4, data as shown in FIG. 6A is written in the first row of the table A connection 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 its value (step B8), and Is specified (step B5), and writing to the A table 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 designated, the process proceeds to the next step B9. If there is another file name in Table A, the file symbol “1” is added on condition that the other file name is present, and the value is updated. Perform (Step B10). Thereafter, returning to step B3, the other file name is specified from the table A, and writing to the table A connection table is performed while sequentially specifying all the item names corresponding to the file name.

Next, the process of creating the configuration file 7 (step A2) shown in FIG. 10 will be described in detail with reference to FIGS. 12 to 14 are flowcharts showing the operation when the configuration file 7 is created. FIG. 15 is a diagram schematically showing the operation contents of the table structure analysis unit 5 in this case, and FIG. FIG. 7 is a diagram showing a configuration file 7 that has been created. FIG. 16A shows the record structure of the configuration file 7. This configuration record is composed of "child food", "parent code", "end flag", and "name". "And" parent code "represent the hierarchical structure of Table A. The “end flag” is a flag that becomes “1” when the parent code includes the aggregation level A. “Name” is the record name of the tally 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). If the totaling level is A, the contents of the last item work memory (see FIG. 15B) in the table structure analysis unit 5 are all cleared for the initial setting (step C3). , Currently focused level (current level)
Is specified (step C4).

In this state, level row data is generated from the current level and the row number of the current row of interest (current row) (step C5). For example, taking Table A shown in FIG. 4 as an example, the first row of Table A is aggregation level A and its row No. is "01".
To generate level row data “A01”.
Next, the level row data “A01” and the name of the current row (record name “total” of the total record) are set at the position corresponding to the current level A in the last item work memory (step C6). The final item work memory is shown in Fig. 1.
As shown in FIG. 5 (B), the level row data and the name are stored corresponding to the aggregation levels A, B, C, D....

Next, it is checked whether or not the management unit area of the current line is marked with a circle (step C7). Now, as shown in FIG. 4, since the head row is not marked with a circle, it is checked whether or not a record name is set in the next row of Table A (step C8). Here, when the setting is detected, the current line is updated and the next line is designated (step C9). When the second row of the table A is designated by this, the process returns to the step C2. In this case, the totaling level of the second row is B, and thus the step C1 is performed.
In step C11, an error check is performed to determine whether or not the level of the specified line has exceeded the current level. If the level has exceeded the level, all contents below the level of the specified line are cleared in the last item memory (step C11).

Since the specified row level B is less than the current level A, the process proceeds to step C12, and the current level is updated using the specified 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 a position corresponding to the current level in the last 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. 15B).
Next, a symbol (•) is connected to the head of this level row data (step C15), and this combined data is combined with the data in FIG.
Is set as a child code of the configuration record (step C16). Here, the symbol (•) is set when the line of the table A in which no item code is input is set as the line of interest, and this indicates that there is no correspondence with the source file. Then, the process proceeds to step C17 in FIG. 13 to read out the level row data stored at the (current level + 1) level position from the last item work memory, and connect a symbol (•) to the head of this level row data. The combination code is set as the parent code of the constituent record (step C18). Now, the current level is B, and therefore, the combined code obtained by combining the symbol (•) with the level line data “A01” stored at the level A position of the last item work memory becomes the parent code ((A) in FIG. 15). reference). 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).
When the child code ".B02", the parent code ".A01", the end flag "1", and the name "total" are prepared as data for one record, the configuration record is written to the configuration file 7. (Step C22).

Next, returning to step C7 of FIG. 12, in this case, since the management unit area of the current line is not marked with a circle, the third line of the next line is designated (step C7).
9). Thereafter, as a result of the above-described steps C12 to C14 being executed, the level line data "C03" and the name of the current line "personnel cost" are set in the level C of the last item work memory ((FIG. 15) B)). Then, a linking code obtained by adding a symbol (.) To this level row data is set as a child code of the constituent record (steps C15 and C1).
6). Next, the level row data read from the level B position (one-level higher level position) in the last item work memory.
A combination code in which a symbol (•) is added to the data "B02" is set as a parent code of the constituent record (steps C17 and C18 in FIG. 13). 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 data for one record.
When the record ".B02" and the name "fixed cost" are prepared, the configuration record is written out to the configuration file 7 (step C2).
2).

Subsequently, when it is detected in step C7 in FIG. 12 that a circle is attached to the management unit area in the third row, the process proceeds to step C23 in FIG. 14, where "1" is set as the initial value of the file symbol. Is set. Next, the item code input to the current line is specified from the beginning (step C24), and the file code and the item code are combined to form the combined code as a child code of the constituent record. (Steps C25 and C26). In this case, since the file symbol "1" and the item code "101" are combined, the child code is "1101". Next, a symbol (.) Is linked to the head of the level row data of the current level in the last item work memory (step C27), and this linked data is set as the parent code of the constituent record. (Step C
28). Then, the parent code name "labor cost" is read from the last item work memory and set as the name of the constituent record (step C29). FIG. 15C shows a configuration record in this case, and the child code is "110".
1, a configuration record having a parent code of ".C03" and a name of "personnel cost" is written to the configuration file 7 (step C30). Next, it is checked whether or not another item code has been entered in the current line (step C31). If there is, the process returns to step C24 to specify the next item code and perform the above-described operation. repeat. As a result, when the item code "102" on the third line is designated, the constituent record is "1102" for the child code and ".C0" for the parent code.
3 "and the name is" personnel expenses ".

Thereafter, since no item code is detected in step C31, the flow advances to step C32 to check whether another file name is defined in the table A. "FILE" as the file name
Is defined, the process proceeds to step C33, "1" is added to the file symbol to update its 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 constituent record is "22111", the parent code is ".C03", and the name is "personnel cost". Now
If no other file is specified in step C32, the process returns to step C8 in FIG. 12, and thereafter, a process of creating a configuration record and writing it to the configuration file 7 until no configuration is detected in step C8 is one record. -Repeat step by step. As a result, a configuration file 7 as shown in FIG. 16 is created. The contents of the configuration file 7 are generated by referring to the table A of FIG. 4, and the eighth to twelfth records of the configuration file 7 correspond to the row No. "03" of the table A. The thirteenth record to the fifteenth record correspond to the row No. “04” of the table A.

When the construction file 7 has been created in this way, the table structure analyzer 5 connects the B table to the connection table and the condition table.
Create a calculation formula table in addition to a table and a total item table. Among them, the B table joining table, the condition table, and the total item table are created according to the flowcharts shown in FIGS. Here, the table B connection table (see FIG. 6B) is composed of "file name", "sequential number SEQ", condition item "item name", and "file symbol". The condition table (FIG. 6C)
) Includes "file name", "item position in table B", "condition value", and "negative flag". Here, the “negative flag” is a flag indicating that “≠ (not equal)” is set as the condition value. The tabulation item table (see FIG. 6D) includes "file name", "item position in table B", "item name" of the tabulation item, and "minus sign". Here, "minus sign" indicates that the item name has a minus sign in the total name, for example, "credit amount-".

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

Next, focusing on 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, a column name indicating the item position of the designated 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 a plurality of 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. If there is, 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. If there is, the process proceeds to step D20, where "1" is added to the sequential number SEQ to update the value. , Step D9
Returning to, the next condition item is designated, and thereafter, a corresponding combined record is generated, or a 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, where a condition item in the designated column is designated. If a minus sign is added to the condition item (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 obtained in this way are used to generate a total item record from the column name, the total item, and the minus sign flag (step D24), and are set in the total item table (step D25).

After analyzing the definition contents of one column of the B table and creating the B table joining table, condition table, and total item table of one column, the process proceeds to step D7, and the data is stored in the next column of the B table. Is specified, and if so, the line is specified (step D8).
And the above operation is repeated.

In addition, the table structure analysis unit 5 analyzes the table B parameter data and creates a calculation formula table. The calculation formula table associates each calculation formula with a column item position. Further, the table structure analysis unit 5 reads the format data from the table B parameter data in association with the column item position, and sets the format data in the print format memory 8.

When such a table creation process is completed, the table structure analysis unit 5 activates the development file creation unit 9. Then, the expanded file creating unit 9 performs an expanded file creating process according to the flowcharts shown in FIGS. The development file 11 is an intermediate file that is generated before the tally file 13 that is the output data of the form is created. Here, FIG. 21 shows an expanded record created according to the contents of the first to fourth records when the source file is the plan file, and FIG. 22 shows one record when the source file is the accounting file. The expanded records created according to the contents of the first to third records are shown. FIG. 23 shows the contents of the expanded file 11 created by this. Now, the parameter analysis table 6 contains FIGS.
It is assumed that various tables having contents as shown in (D) are set.

First, the expanded file creator 9 refers to the parameter analysis table 6, extracts a file name (firstly, the file name of the first record) from the table A connection table (step E1), and designates the file symbol. (Step E2). Next, a source file corresponding to the file name is specified (step E3), and a first record in the source file is specified (step E3).
4). As a result, the first record of the "plan file" defined first in Table A is specified as the file to be totaled. Next, an item name (the first item name of the first record) is extracted from the A table connection table (step E5),
The item value corresponding to this item name is extracted from the specified record (firstly the first record) in the specified file (step E6). Then, the item value is combined with the designated file symbol (step E7), and the combined data is set as a classification key of the expanded record (step E8). Now
As shown in FIG. 21, the item value “101” of the budget item is extracted from the top record of the plan file, and this item value “1” is acquired.
01 and the designated file symbol "1" are combined, and the 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 top record of the plan file is a record that matches the extraction condition defined in the table B. That is, first, the expanded file creation unit 9 refers to the table B connection table and checks whether or not the specified file symbol exists in this table (step E9). Here, the condition item is B as described above.
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 condition for extracting 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 extracted from the designated record. In this case, the item value “1” of the plan type is extracted from the first record. Then, a condition value corresponding to the item value is searched from the condition table B (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 is present in the first record in the table B condition table, the process proceeds to the next step E13, and the negative flag is set in the corresponding table B condition table. Is set or not. In this case,
Since the negative flag has not been set, step E19
Then, the value at the position corresponding to the matched condition value (B in this case) is extracted from the table B condition table, and the value of the item position corresponding to this value is searched for in the total item table (step E20). The corresponding item name is specified (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 the item position B is extracted, and the item value "800,000" corresponding to this item name is designated. At the same time as taking out from the record (step E22), it is checked whether a minus sign flag is set in the aggregation item table corresponding to the item position B (step E23).
Next, the process proceeds to step B24, where the item value "800,000" extracted from the designated record is totaled at the corresponding position "B" of the expanded record. If the minus sign flag is not set, it is added up. As a result, the first expanded record as shown in FIG. 21 is created.

Next, it is checked whether the same item position (B in this case) has been set in the total item table (step E25). As shown in FIG.
In the accounting file, the same item positions D and E are respectively set at two places in the aggregation item table corresponding to the item names “debit amount” and “credit amount”, but a plurality of item positions B are set. No, step E
Proceeding to 14, it is checked whether there is another condition value that matches the item value in the table B 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 designated on condition that the next record exists in the designated plan file. (Step E18).

As a result, the second record of the plan file is specified, the process returns to step E5, and the above operation is repeated. In this case, the classification key “1102” of the expanded record in the second record is generated based on the file symbol “1” and the budget item value “102” in the second record (steps E5 to E8). Similarly to the first record, the item value corresponding to the plan type in the second record is also “1”, and a condition value corresponding to the item value “1” exists in the table B condition table and corresponds to the condition value. Since the negative flag has not been set, the process proceeds to step E19,
The item position “B” is extracted from the table condition table, and the value of the item name “budget amount” corresponding to the item position “B” is extracted from the second record of the plan file (steps E20 to E20).
E22). In this case, as shown in FIG. 21, "200,000" is added from the item of the budget amount in the second record of the plan file.
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 expanded record (the third record) is generated. In this case, the item value of the plan type in the third record read from the plan file is “2”, and a condition value that matches this item value is set in the table B 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 to the corresponding position “C” in the expanded record (third record).

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

If it is detected in step E9 that the designated file symbol is not set in the table B connection table, the condition item is undefined, and the process proceeds to step E28. The same file name as the specified file is directly searched in the total item table without referring to the definition contents of the table B condition table, and thereafter, the process returns to the step E21.

As a result of performing such an operation one record at a time, when all records in the specified file are specified and no next record is detected in step E15, step E15 is executed.
Proceed to 16 to check whether another file is defined in the A table connection table. Now, since the accounting file is defined as another file in the table A joining 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 extracted as a file name from the table A connection table (step E1), and "2" is designated as its file symbol (step E2). Then, an accounting file is designated as a source file corresponding to this file name (step E).
3) Specify the first record (step E)
4).

In this state, the item value "2111" of the "account item" of the designated record is combined with the file symbol "2" 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 table B connection table,
The item value corresponding to the item name "counter account" of the table combination table is extracted from the first record of the accounting file (step E10). Now, since "0011" is extracted as the item value of "counter account" from the first record of the accounting file, a condition value that matches this item value is checked from the condition table of table B (step E11). In this case, since the corresponding condition value is set in the fifth and sixth rows in the table, a match is detected in step E12, and the process proceeds to step E13. And
Check whether the negation flag is set at the corresponding position. Since the negation flag is set in the fifth row of the table B condition table, the process proceeds to step E14, and another condition value that matches this item value "0011" in the table B condition table is added. Check if there is, but now B
Since the condition value “0011” exists in the sixth row in the table condition table, the process returns to step E13. Since the negative flag is not set at the position corresponding to this condition value, the process proceeds to step E19, where the corresponding item position "E" is extracted from the table B condition table, and this item position "E" is set. The item name in the matching total item table is specified (steps E20 and E21).
The first item position among the item positions “E” set on the second and sixth lines, that is, the item name “debit amount” corresponding to the fifth line is designated. Then, from the first record of the accounting file, the item value “5” corresponding to the designated item name is set.
"0000" is added to the corresponding position "E" of the expanded 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 in the sixth line as well as the fifth line in the total item table, the 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 extracted 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 is counted in the corresponding position "E" of the first record of the developed record. Since the minus sign flag is set in the sixth line of the totaling item table, the negative totaling, that is, the totaling operation of (previous debit amount “50,000” −current credit amount “0”) is performed. This is performed (step E24). Thereafter, the process proceeds from step E25, E14, E15 to step E18, where the second record of the accounting file is designated. As a result, an expanded record is generated corresponding to the second record of the accounting file. In this case, the item value of the account is also "2111" and the classification key is the same as in the first record. Becomes “22111”. Also, since the counter account of the second record is also “0011”, which matches the item condition value, the debit amount “0” is added up to the item position E of the developed record, and the credit amount is “40”. , 00
“0” is negatively counted in the item position E. Because of this,
The item position of the expanded record of the second record is "-40,
000 "is written.

Next, the third record of the accounting file is specified, and the item value of the counter account is "0011".
Since the corresponding condition value is not set in the table condition table, the process advances from step E12 to step E26 to determine whether the negative flag is set in the table B connection table for the designated file. To check. Since a negative flag is set in the fifth row of the condition table corresponding to the accounting file in the table B, step E27 is executed.
To “D” at the position where the negative flag is set.
Is retrieved from the condition table of table B, and a position corresponding to this value is retrieved from the totaling item table (step E2).
0), the item value “8” corresponding to the item name “debit amount”
"000" from the third record,
The total is added to the corresponding position D of the key. Then, step E
From step 25, the process returns to step E21, and the item value "0" of the next item name "credit amount" is negatively added to the position "D" of the development record in the same manner as described above. Thereafter, the next record is designated, and every time a mismatch is detected in step E12, the same operation as described above is repeated one record at a time. As a result, development records according to the condition value “$ 0011” of the condition item “counter account” are sequentially generated.

Thereafter, when all the records in the accounting file are designated and no next record is detected in step E15, the flow advances to step E16 to check whether there is another file in the table A connection table. Is checked, in this case, since no file is detected, the process proceeds to step E17, where the development record is edited. In other words, each of the development records having the same classification key is extracted, and this is combined into one record.
In addition, the records are sorted and the developed records are sorted in ascending order according to the classification keys. For example, as shown in FIG.
Since the first record and the second record have the same classification key, they are grouped into one expanded record, and the value of the item position "E" is "10,000". ". FIG. 23 shows the expanded file 1 created as described above.
1 is shown. That is, the development 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.

After the development file creation unit 9 creates the development file 11 in this manner, the development file processing unit 12 is activated. Then, the development tabulation processing unit 12 creates the tabulation file 13 according to the flowchart of FIG. FIG. 25 is a diagram for specifically explaining the operation contents of the development and aggregation processing unit 12. The development file creation unit 9 generates the total file 13 based on the contents of the development file 11 and the contents of the configuration file 7 in accordance with the component development method. First, the development tally processing unit 12 generates the development file 11
The data for one record is read from the beginning of the record (step F1). Then, in the next step F2, is it the end of the data?
That is, it is checked whether or not all records have been read from the beginning of the development file 11. Since the first case is a case where data for one record is read from the beginning of the development file 11, the process proceeds to the next step F3, where the configuration file 7 is read.
Is searched, and a child code matching the classification key is searched from the configuration file 7. Now, as shown in FIG. 25, the classification key in the first record of the development file 11 is "11
Since there is a child code corresponding to this in the configuration file 7 as shown in FIG. 16, this is detected in step F3 and the process proceeds to step F4, where the record (total record) of the total file 13 is displayed. Generate That is, in the specific example of FIG. 25, first, the expansion and aggregation processing unit 12 reads the parent code corresponding to the child code “1101” from the configuration file 7, and replaces the parent code “· C03” with the row No. “03” of the B table. ”And other“ • C ”.
No. “03” is placed at the head of the first record of the tally file 13, and other “• C” are placed following it. Then, the name corresponding to the child code is read from the configuration file 7, and is arranged in the next item of the tally record. Following this, the data items of the development file 11 are sequentially arranged after the next item of the tally record.

When data for one record of the tallying file 13 is thus generated, the generated record is written to the tallying file 13.
If a record having the same classification key already exists in the file, the record is added up to one record and written into the tally file 13. If no record with the same classification key exists, the record generated this time is newly added. Total file 1
3 (step F5).

Next, it is checked whether or not the end flag is set at the corresponding record position in the configuration file 7 (step F6). Here, the end flag in the configuration file 7 is set to “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 when the end flag is not "1", the writing to the development file 11 is performed (step F3).
7). In this case, a record as shown in FIG. 25B is generated and returned to the development file 11. That is, the corresponding parent code “· C03” in the configuration file 7 is placed at the head item, and subsequently, a record in which the data read from the development file 11 is sequentially arranged is written to the development file 11. In the expansion file 11 shown in FIG. 23, the records arranged below the broken line in the figure indicate the returned records. Thereafter, the process returns to step F3, and thereafter, the entire contents of the configuration file 7 are searched, and the above-described operation is repeated until the corresponding record is not detected. As a result, when the absence of the corresponding record is detected in step F3 and the matching ends, the process returns to step F1 to read the next record from the development file 11. Such an operation is performed for all records in the development file 11. Then, the end of data is detected in step F1, and
Proceeding to 8, the records constituting the tally file 13 are sorted in ascending order according to the contents of the first item.

When the tally file 13 is created in this way, the development tally processing unit 12 activates the print processing unit 14. Then, the print processing unit 14 fetches the contents of the print format memory 8 and causes the printer 15 to print out the contents of the aggregation file 13 together with the form format in accordance with the print format. In this case, each record name stored in the tally record of the tally file 13 is sequentially taken out and arranged vertically, and at the same time, each item name stored in the print format memory 8 is taken out sequentially and placed at the corresponding position in the form format. Print out. FIG. 3 shows a form printing example in this case. In the row direction, the record name of the total record is printed along with the hierarchical structure format corresponding to the total level, and the item name of the total record is printed in the column direction.
Further, the contents of the aggregation file 13 are printed out for each record.

As described above, in the present embodiment, in order to obtain a desired form from the host computer 200 or the input terminal device 300, the parameters of the tables A and B, which are totaling definition tables, according to the output image. Is arbitrarily input and specified, the form print processing apparatus 100 stores a predetermined file in the host computer 20 according to the specified content.
0 and read out from the file server 400, etc., extract the contents of predetermined record items from this file, classify and totalize them, and print the totaled result in a hierarchical structure. Also, a desired form can be easily obtained by simply inputting the parameters of Table A and Table B from the host computer 200 or the input terminal device 300. That is, since the form print processing apparatus 100 performs the function of reading out the file to be totaled from the external device, extracting the contents of the predetermined record items and creating the form data, and printing out the form data, the host computer 200 and the host computer 200 It is only necessary to simply input the table A and table B parameters from the input terminal device 300. As a result, there is no need to provide the host computer 200 or the input terminal device 300 with a function of creating and printing out form data.
The versatility can be improved accordingly, and the cost is extremely advantageous.

Although the above embodiment has been described with respect to the case where the records are totaled, by setting the totaling level of the A table to only A, the present invention is not limited to the totaling of records, but may simply perform record extraction, array, intra-item calculation and the like. It may be. In the above embodiment, the form is printed out.
You may make it output to a CRT screen display or other media. On the other hand, in the above embodiment, the tables A and B are defined separately and independently. However, the tables A and B may be defined simultaneously on the same screen. Further, in the above embodiment, the item code is input at an arbitrary intersection position on the matrix constituted by the head portion of Table A. However, the item name may be input, and the line direction may be input. Is input in a hierarchical structure according to the aggregation level, but it is a matter of course that the record name is not limited to the hierarchical structure. Further, by printing the images of the tables A and B from the parameter file, the images may be stored as specifications such as a form in a form that can be understood by a person in charge of business.

[0056]

According to the first aspect of the invention, when an external device issues a print request to a print processing device, the print data after data reading, processing, and print format conversion are transmitted to the printing device. If you do not, just send the information that specifies the read data, processing method, and print format to the print processing device, and the printing device itself will automatically read, process, and print the data and print the desired form. be able to.

[Brief description of the drawings]

FIG. 1 is a system configuration diagram showing a data processing system according to an embodiment.

FIG. 2 is a block diagram of a form print processing device that forms the data processing system.

FIG. 3 is a diagram showing a print output example of a form.

FIG. 4 is a diagram specifically showing the contents defined in Table A.

FIG. 5 is a diagram specifically showing the contents defined in Table B.

FIG. 6 is a table joined table, a table joined table obtained by analyzing the tables A and B shown in FIGS. 4 and 5,
This table specifically shows the contents of a table B condition table and a table B total item table, where (A) is a table A connection table and (B)
Is a B table join table, (C) is a B table condition table,
(D) is a diagram showing a table B total item table.

FIG. 7 shows a host computer 200 and an input terminal device 300
5 is a flowchart showing an operation when the function of the form print processing apparatus 100 is in the terminal mode.

FIG. 8 is a diagram showing a basic format of a table A.

FIG. 9 is a diagram showing a basic format of a table B.

FIG. 10 is a general flowchart showing an outline of the entire operation of the table structure analysis unit 5;

FIG. 11 is a flowchart showing details of the A-table connection table creation process shown in FIG. 10;

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

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

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

FIGS. 15A and 15C are diagrams specifically showing the operation contents of a configuration file creation process, wherein FIGS. 15A and 15C show configuration records, and FIG. 15B shows the contents of a last item work memory;

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

FIG. 17 is a flowchart showing a part of a table creation process for the table B shown in FIG. 10;

FIG. 18 is a flowchart showing a part of a table creation process following FIG. 17;

FIG. 19 is a flowchart showing a part of a development file creation process.

FIG. 20 is a flowchart showing a part of a development file creation process following FIG. 19;

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

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

FIG. 23 is a diagram specifically showing the contents of a development file 11;

FIG. 24 is a diagram showing a development tallying process by a development tallying processing unit 12;

FIGS. 25A and 25B are diagrams specifically showing the operation contents of the development and aggregation processing, where FIG. 25A shows a state in which a total record is generated from a development file and a configuration file, and FIG. The figure which showed the expansion record.

[Explanation of symbols]

 REFERENCE SIGNS LIST 1 reception unit 2 parameter setting unit 3 transmission unit 4 parameter file 5 table structure analysis unit 6 parameter analysis table 7 configuration file 8 printing format memory 9 expansion file creation unit 10 data file 11 expansion file 12 expansion aggregation processing unit 13 totalization file 14 printing Processing unit 15 Printer 100 Form print processing device 200 Host computer 300 Input terminal device 400 File server

Claims (4)

(57) [Claims] 1. A form processing method according to a print request from an external device.
A printing apparatus that performs printing , when parameters including the specification of records and items constituting a form, the specification of data to be a source of a form, and the specification of a data processing method are transmitted from an external device. Receiving means for receiving this parameter, reading means for reading data from which the form specified by the parameter is based on an external device, and reading the data read from the external device into the parameter.
Processing means for performing processing based on the data processing method specified by the parameter; and processing the processed data by the data specified by the parameter.
And a printing means for printing as a form including codes and items . 2. The method according to claim 1, further comprising the step of :
Holding means for holding the set parameters, and print instructing means for instructing printing, and when the print instructing means instructs printing, the reading means based on the parameters held in the holding means. 2. A print processing apparatus according to claim 1, wherein data reading by said processing means, data processing by said processing means, and printing of a form by said printing means are performed. 3. Each record constituting the form is data
Processing of the data is read in
Data is aggregated for each aggregation level, and the aggregation results are compared.
Print as the data of the record of the corresponding aggregation level
2. The print processing apparatus according to claim 1, wherein
Place. 4. The apparatus according to claim 1, wherein said receiving means receives a parameter input by an input terminal device, and said reading means reads data stored in a data storage device. Print processing device.