JPH08185454A - Data processor - Google Patents

Abstract

PURPOSE: To use item data as data required for output similarly to the other item data of a data file by performing the output based on a record generated by a record generation means at the time of outputting the data file set in a file setting slip. CONSTITUTION: When a ledger registration slip is inputted from an input part 1, a registration slip input processing part 2 performs registration corresponding to the data file. The data file is generated based on the file setting slip defined in the ledger registration slip in a file generation processing part 12 provided in a file processing part 9 and the data file is updated corresponding to the generated record. Then, at the time of outputting the data tile, record summing-up or the like is performed based on the record generated by the record preparation part 16 of a slip output control part 15, storage is performed in the work file 19 of a slip preparation part 17, a slip form is outputted from a printing part 20 and a display part 21 and the item data are arbitrarily used as the required data.

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 data in an office computer, a personal computer, a host computer or the like based on various office processing files.

[0002]

2. Description of the Related Art Conventionally, in a data processing apparatus such as an office computer that performs office work, various files such as sales files, accounting files, transfer files, and personnel files are stored and managed. The record structure that constitutes a file is different for each data file, and the same record form (records in which each item that constitutes a record matches) is collectively managed as a separate file. By the way, in the sales file, records are updated by inputting sales slips, purchase slips, etc., that is, record aggregation, record addition, etc., but such update processing is performed individually by experts such as system engineers in advance. By designing a processing program for such slips, it becomes possible to process a predetermined file. The record structure of the file is designed in advance, and the field of the record, that is, the item is also predetermined.

[0003]

In the processing program, the items of the records that make up the file are designed in advance according to the record configuration. However, for these items, it is necessary to design the necessary items in advance when the record is output, but if all of these items are designed in advance as the items of the record structure of the file, the record becomes long. There is a drawback. Therefore, it is possible to create an item in the processing program that is needed at the time of outputting the record and add this item to the record read from the file, but each time the record is output, a program for that processing is individually added. Must be created. In addition, code data such as business partners and accounts are used as record items of the file. If only the code is stored, what does the data of that item mean when using this file? The user had to make an individual judgment. If you make a mistake in this judgment,
There was a risk that the same data would be used with different meanings. In addition, if the code and its character are also stored, the number of items in the record increases.

An object of the present invention is to determine what items are required as files by carrying out daily work without requesting a system engineer having specialized knowledge of programming to design a file processing program. A general business person who understands empirically can set the generation of necessary items that do not actually exist in the records of the data file to suit his or her business content, and the items generated by this setting Data can be used as the data required for output in the same way as the item data that actually exists in the data file, and any item content of the data file can be used as a key to convert the data by referencing the index table. The obtained item data can be used as the data required for output like other item data in the data file. It is to so.

[0005]

Means for Solving the Problems The means of the first invention (the invention according to claim (1)) is as follows. (1) Means for storing a file setting vote formed by setting each item corresponding to the record configuration of the data file, and a record of the data file is generated based on the file setting vote, and the generated record According to the above, (2), the item data generating means defines an item which does not exist in the record of the data file set in the file setting vote as a logical item. At the same time, when the generation condition of the item is defined in association with the logical item, the item data of the corresponding logical item is generated based on the generation condition. (3), the record generation means stores a record in which the item data existing in the record of the data file set in the file setting vote and the item data generated by the item data generation means are incorporated into one record. To generate. (4) When outputting the data file set in the file setting form, the output means outputs based on the record generated by the record generating means. Means of the second invention (the invention according to claim (2)) is as follows. (1) Means for storing a file setting vote formed by setting each item corresponding to the record configuration of the data file, and a record of the data file is generated based on the file setting vote, and the generated record And (2) the item data generating means specifies any item among the items of the data file set in the file setting form as an index key. When an index table indicating the index destination is set corresponding to this index key, the index table is referred to based on this index key to generate item data corresponding to the index key. (3) The record generating means generates a record in which the item data corresponding to the item of the data file set in the file setting vote and the item data generated by the item data generating means are incorporated in one record. To do. (4) When outputting the data file set in the file setting form, the output means outputs based on the record generated by the record generating means.

[0006]

The operation of the means of the first invention is as follows. Now, corresponding to the record structure of the data file, each item is set in the file setting vote. A record of the data file is generated corresponding to each item set in the file setting slip, and the record of the data file is updated according to the generated record. Then, in the output of the record of the data file, an item that does not exist in the record of the data file set in the file setting form is defined as a logical item, and the generation condition of the item is associated with this logical item. When defined, the item data generating means generates item data of the corresponding logical item based on this generation condition. Then, the record generation unit generates a record in which the item data existing in the record of the data file set in the file setting vote and the item data generated by the item data generation unit are incorporated in one record. The output means outputs the record based on the record thus generated. Therefore, without having to ask a system engineer with specialized knowledge of programming etc. to design a file processing program, you should have an empirical understanding of what items are needed as files for the daily work. In order for a general business person who is in charge of the job to suit his or her job content, the data of the required items that do not actually exist in the records of the data file can be arbitrarily generated according to the description contents of the file setting form, and the data of this generated item can be generated. It can be used as data necessary for output, just like item data that actually exists in the data file. The operation of the means of the second invention is as follows. Now, corresponding to the record structure of the data file, each item is set in the file setting vote. A record of the data file is generated corresponding to each item set in the file setting slip, and the record of the data file is updated according to the generated record. Then, in the output of the record of the data file, an arbitrary table among the respective items of the data file set in the file setting slip is designated as an index key, and an index table showing the index destination corresponding to the index key. When is set, the item data generating means generates the item data corresponding to the index key by referring to the index table based on this index key. Then, the record generating means generates a record in which the item data corresponding to the item of the data file set in the file setting vote and the item data generated by the item data generating means are incorporated in one record. . The output means outputs the record based on the record thus generated. Therefore, without having to ask a system engineer with specialized knowledge of programming etc. to design a file processing program, you should have an empirical understanding of what items are needed as files for the daily work. A general business person who is in charge of data conversion obtains the data by referring to the index table with the content of any item of the data file as a key according to the description content of the file setting slip so that it suits his / her business content. The item data can be used as data necessary for output in the same manner as other item data in the data file.

[0007]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment will be described below with reference to FIGS. FIG. 1 is a block diagram showing the overall configuration of the data processing device. The input unit 1 is configured to have a key input device for inputting various data and commands, a mouse as a pointing device, etc. When the input unit 1 is instructed to input a ledger registration slip, the registration slip input processing unit 2 Starts according to this instruction and executes the input process of the ledger registration slip input from the input unit 1.

Now, the original book registration slip will be described. FIG. 2 shows a specific example of the original book registration slip, and shows the original book registration slip for the accounting statement file. That is, in this embodiment, the original book registration slips 3-1, 4-1 and 5-1 are stored and managed in association with the transfer detailed file 3, the business detailed file 4 and the accounting detailed file 5. The vote form of votes basically has the same structure. In the original book registration sheet shown in FIG. 2, the ruled lines and headings (for example, original book name, item name, attribute, ... Input original book name, business name ...) Constituting the table frame and the cell frame are registered sheet input processing unit 2 in advance. It is included in the vote form set in the table, and while the vote form is output on the display screen, data is sequentially input while designating an arbitrary position from the input unit 1.

That is, the file name "accounting statement" of the accounting statement file 5 is input in correspondence with the heading "ledger name" of the vote form, and each item name (slip identification) is entered in correspondence with the record structure of the accounting statement file 5. , Slip no, establishment c
d, account cd ...) One by one. In addition,
In the figure, "cd" indicates a code, and "slip no" indicates a sequential slip number. Then, the predetermined items are input one by one in the fields of "attribute", "digit number", "table name", and "definition" in association with each item name. Here, “attribute” indicates the item attribute of the corresponding item, for example, “R” indicates right alignment and “N” indicates a numerical value. The "digit number" indicates the item digit number of the corresponding item. The “table name” indicates the table name of the index table to be referred to when the data of the corresponding item is generated, and for example, “business office cd” is the corresponding table name “business office cd”.
It indicates that the item data should be generated by code / character conversion by referring to the index table shown by. The item for which the generation of item data is instructed by referring to the index table in this way is particularly called an index item. Further, the "definition" is a column for referring to the index table according to the description content or defining a generation condition for generating a corresponding item data by performing a predetermined calculation statement. Note that the description contents of "attribute", "digit number", "table name", and "definition" are referred to as necessary particularly when the accounting statement file 5 is output as a form, and among them, "definition" The column of is also referred to when the record item of the input original book is generated. In addition, in the ledger registration form, the item name required for outputting the contents of the accounting statement file 5 in the form is displayed in the item name entry field below the horizontal double line in the figure. Is entered. In other words, items that do not actually exist in the record of the accounting statement file 5 but are required when the form is output can be entered by inputting the item name below the double line. Is distinguished from. Below the double line, an attribute entry column, a table name entry column, and a definition entry column are provided in addition to the item name entry column, and necessary items are entered in these columns. Here, in the definition entry field, in the figure, "# index (establishment tb, establishment c
d, establishment name) "is the record item of the accounting statement file 5, that is, the item content (establishment code) indicated by the item name" establishment cd "set in the ledger registration slip shown in FIG. It indicates that the business establishment table should be searched as a key and the business establishment name should be read from this table to generate item data. In addition, the description of “debit amount * 0.03” is the record item “debit amount” of the accounting statement file 5.
Is multiplied by "0.003" to generate the item data of the consumption tax amount. Furthermore, the description of “# join (# division (business office cd, 1, 1),“ 0 ”)” is the beginning of the numerical sequence that constitutes the record item “business office cd” of the accounting statement file 5. It indicates that one digit is divided into one digit and "0" is combined with it to generate item data of accounting unit. In order to distinguish the item entered below the double line of the ledger registration slip from the item actually existing in the record of the accounting statement file 5, the items entered below the double line are particularly logical. It is called an item. That is, if the item to be executed as the record item of the data file is a physical item, the item that does not exist as the record item of the data file is a logical item, as a concept opposite to that.

On the other hand, in the original book registration slip shown in FIG. 2, the file name "transfer details" of the transfer detailed file 3 and the file name "business details" of the business statement file 4 are entered in correspondence with the heading "input original book name". These files are files to be processed when the record of the accounting statement file 5 is updated, and correspond to the heading "Business name" to distinguish them when there are multiple slips having the same slip name. Then, a subordinate conceptual slip name is input for each slip. That is, the "business name" is a field that defines a subordinate conceptual slip name,
You may input the same name as the "input original book name". The "function name" defines whether special processing (journalization processing described later) is required. If special processing is required, "journal entry" is entered in the "function name" field. Also,
“Update type” indicates an update type when updating the record of the accounting statement file 5, and for example, an arbitrary update type is input from among record totalization, record addition, record addition totalization, and the like. In the illustrated example, "addition" that defines record addition is input as the update type of the file names "transfer details" and "business details" of the input ledger.

Further, the record item names constituting the transfer statement file 3 and the business statement file 4 are changed to the accounting statement file 5.
Enter one by one in association with the record item name of. That is, each item name of the transfer detailed file 3 is “transaction date,
Voucher type, voucher no, issuing office cd, account cd ... "
Is input in association with the record item name of the accounting statement file 5. Similarly, corresponding to the business statement file 4, the item name “transaction date, slip type, slip no, transaction office c”
"d, $ account ..." Is input in association with the record item name of the accounting detail file 5. When the item name entry field of the input ledger is blank and the record generation condition is described in the “definition” column of the corresponding item position, that is, as the record item of the input ledger If the item does not exist, but exists as a record item in the accounting statement file 5 and that item data needs to be generated in particular, enter a predetermined item in the “Definition” field, Therefore, the data of the item is generated. Further, “journal” is set as the “function name” of the business statement file 4 in the ledger registration slip. In this journal, an item in which "$" is described, such as "$ account" in the slip item name defined in the ledger registration slip, or "@" is described, such as "@ amount". For items, it indicates that item data should be generated by referring to the journal table 5-2.

On the other hand, when a voucher record such as a transfer voucher or a travel expense report is input from the input unit 1, the voucher input processing unit 6 fetches and processes the voucher record and writes it in the voucher record memory 7. The slip item name memory 8 is the slip record memory 7
In addition to the slip name in advance, the slip item names are stored in association with the slip records in the table according to the arrangement order. The slip input processing unit 6 stores the contents of the slip record memory 7 and the slip item names corresponding to the slip records. Is read out and given to the record processing unit 10 constituting the file processing unit 9.

In addition to the record processing unit 10, the file processing unit 9 includes an original book registration slip analysis unit 11, a file generation processing unit 12,
It has a journalizing unit 13 and a work file 14. When updating the record of the data file, the ledger registration slip analysis unit 11 takes in the ledger registration slip corresponding to the data file designated as the update target and analyzes the setting contents. The analysis result is the record processing unit 10. Given to. At this time, if the data file defined in the original book registration slip does not exist in the system, the original book registration slip analysis unit 10 activates the file generation processing unit 12 on the condition. The file generation processing unit 12 newly generates a data file having a record structure according to the order of the item names based on the file name of the data file and the record item name defined in the original book registration slip, and registers the original book. Set in correspondence with the votes.

When the record processing unit 10 updates the records such as the transfer detailed file 3, the business detailed file 4, the accounting detailed file 5 and the like, the record processing unit 10 generates a record according to the analysis result of the original book registration slip analyzing unit 11 and the work file 14 To store. Here, when the record processing unit 10 updates the record of the data file and the processing target is a slip, the slip record in the slip record memory 7 is arranged in the order of arrangement of the slip item names defined in the original book registration slip. Generate a record that sorts the item data of. At the time of rearranging the record items, the record processing unit 10 refers to the contents of the slip item name memory 8 to check the item position of the slip item name defined in the original book registration slip, extract the item data, and rearrange it. I do. Further, when the processing target is a file such as the transfer statement file 3 and the business statement file 4, the record processing unit 10 extracts the data of the record item of the processing object file defined in the original book registration slip, and the item name In this order, the item data of each record that constitutes the file to be processed such as the transfer detailed file 3 and the business detailed file 4 is rearranged to generate a record, which is stored in the work file 14.

If "journal" is defined in the function name column of the ledger registration slip, the journal entry processing unit 13 sends the ledger registration slip 5-1.
The data of the necessary items is generated by referring to the journal entry table 5-2 registered in advance corresponding to the above, and is set at the corresponding item position in the work file 14. Further, the record processing unit 10 takes in the contents of the work file 14, and selects the data set in the ledger registration slip as the “original book name” among the data files such as the transfer detailed file 3, the business detailed file 4 and the accounting detailed file 5. The record of the file is updated. At that time, the record processing unit 10 checks the “update type” defined in the ledger registration slip, updates the record of the data file according to the “update type”, and Aggregate, add records, etc.

The form output control unit 15 is a record creating unit 1.
6, a form creation unit 17, a table file 18, and a work file 19, and the name of the ledger set in the ledger registration form from the input unit 1 and various types set in the ledger registration form corresponding to this ledger name If any of the item names required for outputting the form is designated, the record creating unit 16 analyzes the description content of the original book registration form.
Then, the record creating unit 16 takes in a record from the data file corresponding to the specified original book name, and performs a record creating process according to the description content of the original book registration slip.
At this time, if the description content of the ledger registration slip indicates that the index table should be referred to and item data should be generated, the record creating unit 16 selects a predetermined index table from among various index tables in the table file 18. Is accessed and item data is generated based on the contents of this table. The form creation unit 17 performs record totalization and the like on the basis of the records created by the record creation unit 16 and stores it in the work file 19, and records the records in the work file 19 together with a predetermined form form from the printing unit 20 or the display unit 21. Output.

[0017]

Next, the operation of this embodiment will be described with reference to FIGS. FIG. 3 is a flow chart showing the operation of the file processing unit 9 to execute the file processing based on the original book registration slip. In the present embodiment, there are two methods for activating the file processing: "batch activation" and "one business activation". ",
There is a "Launch expansion table", and you can specify the desired startup. In other words, "collective activation" is a method of activation in which a plurality of input original book names are set in the original book registration slip, and for example, in the original book registration slip shown in FIG. Each of the "transfer detailed file" and the "business detailed file" is to be processed. In addition, "one business activation" is a method of activation in which only the input ledger corresponding to the arbitrarily designated business name is the processing target when a plurality of input ledger names are set in the ledger registration slip, for example, In the ledger registration slip shown in FIG. 2, when “transfer detail transfer” is designated as the business name, only the transfer detail file corresponding to the input master book is processed.

When the "ledger name" set in the ledger registration slip is entered from the input section 1 at the time of batch activation, the corresponding ledger registration slip is designated (step A1), and at the time of starting one business, When the "business name" is input from the input unit 1 in addition to the "ledger name", the ledger registration slip corresponding to the name of the ledger is designated (step A2). When the original book registration slip is designated in this way, the original book registration slip analysis unit 11 of the file processing unit 9 analyzes the specified original book registration slip (step A3). First, the original book registration slip analysis unit 11 checks whether or not the data file set as the “original book name” actually exists in the system based on the original book registration slip (step A4). Here, when the absence of a file is detected, the original book registration slip analysis unit 11 activates the file generation processing unit 12. Then, the file generation processing unit 12 reads the file name corresponding to the “original book name” and each item name, attribute, and number of digits from the original book registration slip according to the analysis result of the original book registration slip analysis unit 11, and the digit of each item is read. A data file having a record structure consisting of items in the order of item names is generated, and this data file is registered in association with the original book registration slip (step A5). As described above, in this embodiment, a data file corresponding to the original book registration slip can be newly created. Note that if the data file already exists, such file generation processing is not performed.

Next, the file processing unit 9 checks the starting method designated in advance when executing the file (step A).
6). If batch activation is specified, the first "input original book name" set in the original book registration slip is specified (step A7). When one business activation is specified, the "input original book name" in the original book registration slip corresponding to the relevant business name is specified (step A8). In this way, when the input original book to be processed is specified according to the activation method, the process proceeds to the next step A9, and the record processing unit 10 responds based on the input original book name specified as the processing object according to the activation method. A data file is designated, and data for one record is extracted from this designated file. Here, when the input original book name designated as the processing target is a slip, the record processing unit 10 reads the contents of the slip record memory 7 and the slip item name memory 8 and fetches the contents of the slip record memory 7 as an extracted record. . Then, on condition that the record has not ended (step A10), the process proceeds to the next step A11, and the original book registration slip analysis unit 11 analyzes the original book registration slip and checks whether "journal entry" is set for the function name. However, assuming that no journal is set, the record processing unit 10 sorts the item data of the extracted records in the order of arrangement of each item name set in the ledger registration slip in association with the input original book name. The generated record is generated as an output record and set in the work file 14 (step A12). In this case, when the input ledger is a slip, the record processing unit 10 determines that the contents of the slip item name memory 8 and the slip item name set in the ledger registration slip are the number of items,
Since the order of arrangement and the item names are different, the record processing unit 1
0 sequentially reads the slip item names set in the original book registration slip from the beginning and compares them with the contents of the slip item name memory 8 to determine at which item position of the extracted record the corresponding item data exists. While checking, sort the item data.

In this way, when the record processing unit 10 generates a record in which the data of one record of the input original book is rearranged according to the description content of the original book registration slip, the original book registration slip analysis unit 11 causes the original book registration slip definition field. With reference to the contents of the above, the record processing unit 10 generates data of necessary items according to the description contents, and sets the data in the corresponding item position in the output record set in the work file 14 (step A13). Here, the definition column describes the generation condition that defines that item data that exists in the record of the data file set as the original book name in the original book registration slip but does not exist in the input original book should be created. The record processing unit 10 generates item data while referring to the index table as needed.

Next, the original book registration slip analysis unit 11 refers to the "update type" set in the original book registration slip, and the record processing unit 10 updates the record of the data file in accordance with this "update type". In this case, "Add" as the update type
Is set, the record processing unit 10 adds the output record in the work file 14 to the data file set as the “book name” in the book registration slip (step A14). Further, when “total” is set as the update type, the output records in the work file 14 are totaled in the data file.

When the update process for one record is performed in this manner, the process returns to step A9, and the next one is read from the input original book.
The data for the records is extracted, and the above operation is repeated for each record for all the records of the input master. When the processing for all the records is completed, the file processing unit 9 checks the starting method again (step A1).
5) If batch activation is specified, the original book registration slip analysis unit 11 analyzes the original book registration slip and checks whether the next input original book name is set (step A16). Here, if the next input original book name is set in the original book registration slip, the original book registration slip analysis unit 11 specifies the next input original book name (step A17), and this input original book will be processed thereafter. Then, the process returns to step A9. Therefore, when batch activation is specified, all input original books set in the original book registration slip are to be processed, and step A16
The above operation is repeated until the end of processing for all the input originals is detected at. On the other hand, the ledger registration slip analysis unit 1
As a result of 1 analyzing the "function name" of the ledger registration slip, "journal entry"
Is detected (step A1)
1) The journal processing unit 13 is activated and the journal processing (step A18) is executed.

When outputting the record of the data file updated based on the original book registration slip in this manner, the output of the form is instructed from the input unit 1. In this case, the form output target is arbitrarily designated. For this purpose, the original book name and the item name are input from the input unit 1. Then, the record creating unit 16 in the form output control unit 15 executes the record creating process according to the flowchart shown in FIG. First, the record creating unit 16 reads the original book registration slip corresponding to the specified original book name and analyzes the stored contents (step B1). Then, a record is read from the data file corresponding to this original book name (step B2). here,
Assuming that “accounting statement” is designated as the ledger name, the record creating unit 16 reads the ledger registration slip shown in FIG. 2 to analyze the description content, and fetches a record from the accounting statement file 5. FIG. 5 shows each item name set in the ledger registration slip corresponding to the ledger name “accounting detail” and the corresponding actual record item value of the accounting detail file 5 in association with each other. Hereinafter, a specific description will be given with reference to FIG.

Assuming that the item names corresponding to (1) to (4) shown in FIG. 5 are sequentially designated as the items to be output on the form, the record creating unit 16 selects the item name "slip" among the designated item names. Type ”is read (Step B
3) Check if it is a logical item (step B)
4). In this case, as described above, each item set below the double line of the ledger registration slip becomes a logical item. Now, the item of “slip type” that actually exists as a record item of the accounting statement file 5 is Since this is the case of reading, the process proceeds to step B5 to check from the table index item. In this case, as described above, the table index item is an item in which the index table name is entered in the table name entry field in the original book registration slip, and the read item is not the index item at this time, so the procedure proceeds to step B9. The record item value "2" of the accounting statement file 5 corresponding to this read item
"0" is set to the position of the first item in the generated record. FIG. 6 shows the item contents of this generated record, and the value "20" of the slip type is set in the first item. That is, the value of the item (physical logic) that actually exists as the record item of the accounting statement file 5 is directly incorporated in the generated record.

Then, it is checked whether all the designated items have been read out. Since it is the case where only the first item is read out now, the process returns to step B3 to read out the next designated item. Since the "business name" set in the ledger registration form as a logical item is read out now, the definition entry field of the "business name" set as a logical item in the ledger registration form is accessed and the description content Read (step B
6). In this case, "# index (establishment tb, establishment cd,
"Business name)" is read, so the record creation unit 16
Analyzes the description content and accordingly generates the item data by referring to the office table shown in FIG. 7 (step B8). That is, the record creating unit 16 determines that the record item value (establishment c
d "456") as a key, the business establishment table shown in FIG. 7 is searched, and the business establishment name "Hamura business establishment" corresponding to this business establishment cd "456" is read from the table to generate item data (step B8). ), The data of this generated item is set to the position of the next item in the generated record (step B).
9). Therefore, as shown in FIG. 6, the second item in the generated record is item data generated in accordance with the definition field of "business name" set as a logical item in the original book registration slip.

Then, the following designated item is read out, and this item is the "consumption tax amount" as a logical item,
Since “debit amount * 0.03” is described in the definition entry field, the record item value “debit amount (12000)” in the accounting statement file 5 is multiplied by 0.03 to obtain “36”.
0 "is obtained (steps B6 and B8). This "36
The value "0" is set as the consumption tax amount in the third item position in the generated record as shown in FIG. 6 (step B
9). Further, the next designated item is also a logical item, and the content of the definition entry column corresponding to this item "accounting unit" is "# Combine (#
The item data is generated according to "division (establishment cd, 1, 1)," 0 ")" (steps B6 and B8).
That is, the record item value (establishment cd “456”) of the accounting statement file 5 is divided by one digit from the first digit, and “0” is combined with this value “4” to obtain “40”. "40" is set as the item data of "accounting unit" at the fourth item position in the generated record shown in FIG. 6 (step B9).

Next, the next designated item is read (step B3), but since this item is a table index item, that is detected in step B5 and step B7.
Then, the description content of the table name entry field corresponding to this item is read from the original book registration slip, and the command is generated by referring to this description content. In this case, the "#index (account tb, account cd, account title name)" is generated according to the content "establishment tb" in the table name entry field. Then, in accordance with this command, the record creating unit 16 searches the account table shown in FIG. 8 using the record item value “account cd (5111)” of the accounting specification file 5 as a key, and the account c
The account title name "product sales" corresponding to d "5111" is read from this table to generate item data (step B8). In this case, a plurality of index data “account item name”, “account item name”, “account detail name”, and “internal code” are set in the account table shown in FIG. 8 in correspondence with the account cd “5111”. However, any index data is read according to the content of the command. The item data generated in this way corresponds to 5 of the generated record shown in FIG.
It is set at the th item position (step B9).

When the operation of the record creating section 16 is completed by this, the form creating section 17 performs the record totalization based on the generated records sent from the record creating section 16 and writes the result in the work file 19.
The content of the work file 19 is output from the printing unit 20 and the display unit 21 together with a predetermined form form.

As described above, in the present embodiment, even if a system engineer having specialized knowledge of programming or the like is not requested to design a file processing program, what items as a file can be set as a file by carrying out daily work. A general business person who knows empirically whether it is necessary, and the data file and the processing target file that is the processing target when updating the records of this data file By simply describing the correspondence relationship of the above in the original book registration slip, the data file update process can be executed as intended according to the description contents of the original book registration slip. In this case, the items that do not exist in the record items of the data file are set as logical items in the ledger registration slip as logical items, and the definition entry fields of the ledger registration slip corresponding to these logical items are set. If necessary information is entered in, the data of the logical item is generated according to this description content. The data of the logical items thus generated can be used as the data necessary for the form output, like the record items that actually exist in the data file. Therefore, it is not necessary to incorporate such a logical item in the record of the data file in advance, and it is possible to prevent the number of record items constituting the data file from increasing. Further, since it is not necessary to generate such a logical item by a calculation program or the like when outputting a form, it is not necessary to individually set a complicated program each time the form is output.

Furthermore, if an index table name is described in the table name entry column of the original book registration slip corresponding to any record item of the data file, this record item becomes an index item and the corresponding table name entry column According to the description content, the index table is searched by using the content of this index item as a key, and the data of the index item is generated. The index item data thus generated can be used as the data necessary for outputting the form, like the other record items in the data file. Therefore, even if the account and supplier code data are used as record items in the data file, they can be converted into characters and output as a form, making it possible to easily understand the item contents. . As a result, it is not necessary to include the item of the character in addition to the item of the code in the record forming the data file, and thus the number of record items can be prevented from increasing. In addition, when the form is output, the code in the record items that make up the data file is read as it is, but whether to read the index data from the index table is arbitrarily specified by entering the required items in the table name entry field of the ledger registration form. be able to. In particular,
When a plurality of index data are defined in the index table in correspondence with the keys, it is possible to arbitrarily specify which index data to read.

In the above embodiment, the table name entry field of the original book registration slip is referred to when the form is output. Another example of using this table name entry field is to register the original book when inputting data. It is also possible to refer to the table name entry field of the vote and check whether or not there is an index table corresponding to it, and detect an input error depending on whether or not data that is not in the table is input.

[0032]

As described above, according to the present invention, what items are required as files by carrying out daily work without requesting a system engineer having specialized knowledge of programming to design a file processing program. In order for a general business person who knows empirically whether or not to do so, according to the content of his / her business, the data of the necessary items that do not actually exist in the record of the data file can be voluntarily set according to the description in the file setting form. The generated item data can be used as the data required for output in the same way as the item data that actually exists in the data file, and any item content of the data file can be used as a key according to the description contents of the file setting slip. Data conversion is performed by referring to the index table, and the item data obtained by this is converted into a data file. It can be used as the necessary data to the output as well as other items data.

[Brief description of drawings]

FIG. 1 is a diagram showing an overall configuration of a data processing device.

FIG. 2 is a diagram showing a ledger registration slip for an accounting statement file 5.

FIG. 3 is a flowchart showing an operation when file processing is executed according to an original book registration slip.

FIG. 4 is a flowchart showing an operation of a record creating unit 16 in the form output control unit 15.

FIG. 5: The original book name “accounting details” is added to the original book registration slip shown in FIG.
5 is a diagram showing each item name set in correspondence with the corresponding actual record item value of the accounting statement file 5 in association with each other.

FIG. 6 is a diagram showing the content of a record created by a record creating section 16.

FIG. 7 is a diagram showing a part of a business establishment table.

FIG. 8 is a diagram showing a part of an account table.

[Explanation of symbols]

 1 Input Part 2 Registration Voucher Input Processing Part 3 Transfer Detail File 3-1, 4-1 and 5-1 Ledger Registration Voucher 4 Business Detail File 5 Accounting Detail File 6 Voucher Input Processing Part 7 Voucher Record Memory 8 Voucher Item Name Memory 9 File processing unit 10 Record processing unit 11 Original book registration form analysis unit 14, 19 Work file 15 Form output control unit 16 Record creation unit 17 Form creation unit 18 Table file 20 Printing unit 21 Display unit

 ─────────────────────────────────────────────────── ─── Continuation of front page (72) Inventor Takashi Kurihara 3-2-1 Sakaemachi, Hamura-shi, Tokyo Casio Computer Co., Ltd. Hamura Technical Center (72) Inventor Junji Mori 3-2-1 Sakaemachi, Hamura-shi, Tokyo No. Casio Computer Co., Ltd. Hamura Technical Center

Claims (2)

[Claims] 1. A means for storing a file setting form in which each item is set corresponding to the record structure of the data file, and a record of the data file is generated based on the file setting form, and this generated Update means for updating the data file according to the record, and items that do not exist in the record of the data file set in the file setting form are defined as logical items, and the items are associated with this logical item. Exists in the record of the data file set in the file setting slip, and item data generation means for generating item data of the corresponding logical item based on the generation condition when the generation condition is defined. Item data and item data generated by the item data generating means are incorporated in one record. A record generating means for generating a code; and an output means for outputting based on the record generated by the record generating means when outputting the data file set in the file setting vote. And data processing device. 2. A means for storing a file setting form in which each item is set corresponding to the record structure of the data file, and a record of the data file is generated based on the file setting form, and this generated Updating means for updating the data file according to the record, and designating any item among the items of the data file set in the file setting form as an index key, and corresponding to this index key, the index destination When the index table shown is set, item data generation means for generating item data corresponding to the index key by referring to the index table based on the index key, and the item setting unit is set in the file setting vote. Item data corresponding to the items of the data file, and item data generated by the item data generating means Record generating means for generating a record incorporated in one record; and output means for outputting based on the record generated by the record generating means when outputting the data file set in the file setting vote A data processing device comprising: