JPH0224767A - Data processor - Google Patents

Abstract

PURPOSE:To simplify design to update various files by temporarily unifying input records inputted on the basis of various slips to a previously determined format. CONSTITUTION:Respective words in an input record inputted from a key input part 1 are converted into a reference record by a reference record forming part 2 by using a reference table 3 to allow respective words to correspond to respective word in a previously determined reference record and stored in a reference file 5. The stored reference record is read out by a file record forming part 6 on the basis of an instruction inputted from the key input part and an updating record for specified data is formed on the basis of the specified data corresponding to respective updating files 10 in a file updating table 7. Then, respective updating files 10 are updated by a file updating part 9.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a file processing device that stores and manages various transaction data in files.

[Prior Art] Generally, transactions occurring in businesses are processed by computers, and the transaction data is stored in electronic files. This file includes various files such as an account ledger file, item management file, and person in charge management file, and the system is designed such that these files are updated at the time a transaction occurs, that is, at the time transaction data is input. Therefore, the design of the update program for files and the design of the input processing program always have to be related to each other, and the design needs to take the entire system into consideration.

[Problem to be Solved by the Invention] However, with such a system, if you want to add a new file after the design of this system is completed, you will not only have to design an update program for that file, but also have to input the It was a very difficult task as it was necessary to review the design of the processing program and redesign the entire system. A similar problem also occurs when changing the record structure of an existing file that has already been designed or when changing the update processing contents.

An object of the present invention is to simplify the new design and design change of a processing program in an apparatus in which various files can be arbitrarily set.

[Means to solve the problem] The means of this invention are as follows.

This invention updates at least the following files: an account file with account as a keyword, an item file with item as a keyword, a person in charge file with person in charge as a keyword, and a business partner file with customer as a keyword when a transaction occurs. Generating means for generating a standard record including all the words for
)and.

A storage means for sequentially storing standard records generated each time a transaction occurs by this generation means (for example, the standard file 5 in the embodiment), and a specification means for arbitrarily specifying a file to be updated (for example, the file update table 7 in the embodiment). ), and a creation means (for example, The file record creation unit 6) of the embodiment) and an update unit (for example, the file update unit 9 of the embodiment) that updates a corresponding file with each update record created by this creation unit.

[Effect] The operation of the means of this invention is as follows.

When a transaction occurs, a standard record is generated based on this data that enters the transaction data according to a predetermined procedure. This standard record contains all the words that would be necessary to update various files, and these words are fixed in advance. The standard records generated in this way are sequentially stored in the storage means for each foam destination. In other words, at this point, no updates are made to the various files, so the design for performing this processing is to convert the input word into each word of the standard record (standard word).
All you need to do is to associate it with the file, and there is no need to consider what kind of file you want to update when designing this.

On the other hand, the design of the files to be updated can be specified arbitrarily using the specification means.This specification is completely arbitrary, and you only need to specify as many files as you need, and you can add and specify new files during processing. It is also possible to do this. This is possible because a standard record containing all the words necessary to update the various files at the time the transaction occurs is generated and stored in the storage means.

Then, when a file update command is input at any time, for example, at the end of a day's work, the creation means updates each file specified by the specification means based on each standard record stored in the storage means. Update records are created, and each file is updated by the update means based on each update record.

Therefore, it becomes easy to newly design and update the processing program in an apparatus in which various files can be arbitrarily set.

[Example] An example will be described below with reference to FIGS. 1 to 6.

Figure 1 shows a schematic system configuration diagram of the entire file processing device. The symbol l in the figure is a key human power section, and data input from this key human power section l is input to the standard record creation section 2. be done. The standard record generation unit 2 associates input words with standard words based on the standard word table 3 and creates one standard record for l increase/subtraction. FIG. 2 shows the structure of the standard word table 3, and shows that one standard record consists of 13 standard words. This standard word is necessary when updating various files described later, and includes “Year Month Date” Slip Number “Total Amount “Debit Account” Debit Business Partner “Debit Details” Credit Account “Credit Business Partner” Credit Details Standard words such as "Person in charge", "Item", "Quantity", and "Unit price" are prepared in advance.

Each standard word is set in association with an input word. That is, when inputting data from the key input unit 1, the label of the input word is displayed on the display unit 4, so that the data input corresponding to this label is converted into standard word data based on the standard word table 3. , and a standard record will be created. The standard records created for each transaction by the standard record generation unit 2 are sequentially stored in the standard file 5.

The standard record stored in this standard file 5 is updated by the file record creation unit 6 according to an update command from the key human power unit 1.
An update record for each file is created using each table for each file read out and set in the file update table 7. FIG. 3 shows the format of the table set in the file update table 7.
In addition to setting the file name and update type, it is possible to arbitrarily set the correspondence between file words and standard words. Settings for this file update table 7 are performed by a setting section 8. Note that the setting section 8 also sets arbitrary input words for the standard word table 3 mentioned above.

FIGS. 4(a) to 4(d) show examples of four types of file update tables set by the setting unit 8,
For example, FIG. 4(a) shows that an account summary file in file group 10, which will be described later, is updated, and the update type is "summary", and the update The word structure of the record (this word structure is the same as the word structure of the corresponding file) is four words: "Tokoma" year and month, Mizotaka, loan amount. ” indicates that it is the keyword for that file. Also, each file word contains “
Each standard word for debit account "year/month" gold m""/H" is associated, and the data corresponding to the word "debit account" in the standard record is the data for the word "current piece" in the account summary file. and “Year/Month” in standard records.
The data corresponding to the word “Year/Month” in the account summary file is stored as data in the word “year/month”, and the data corresponding to the word “amount” in the standard record is stored as “year/month” word data in the account summary file.
An update record for updating the account summary file is created from the standard record. Figures 4(b), (c), and (d) show the account ledger file in file group IO. , the item management file, and the file update table for the person in charge file.

In this way, update tables as many as the number of tables set in the file update table 7 are created for one standard record, and the file update unit 9 updates the corresponding files in the update file group 10. will be carried out.

Next, the operation of this embodiment will be explained.

First, when designing the system, it is determined what kind of data will be stored and managed in transaction processing, and the files to be used are set in the update file 10. There may be any number of configuration files, and the settings are made according to the purpose of use. Correspondingly, a file update table 7 for updating each file is also set. In addition to these settings, input words are also set for the standard word table.

When a transaction occurs, data is sequentially input from the key human resource section 1 in correspondence with the input word displayed on the display section 4, and these data are rearranged into a standard record by the standard record generation section 2. If this process is repeated every time a transaction occurs, a plurality of standard records will be stored in the standard file 5. After this, for example, when a file update command is input to update each file at the end of the day, the file record creation section 6 and the file update section 9 execute processing according to the flowchart shown in FIG. .

That is, one standard record in the standard file 5 is read in step Sl, and one of the preset file update tables 7 is designated (step S2).
Then, the standard word and the file word are associated with each other based on this update table 7, and an update record is created (step 53).Next, the update file group 10 corresponding to the file name set in the update table 7 is created (step 53). One of the files is opened (step S4), and in step S5, the update type set in the update table 7 is selected, and the file update unit 9 uses the update record to match the update type. Update the file, and then close this file.0 Next, in step S6, it is determined whether there is another file update table set, and if there is, the process returns to step S2, and the standard record read out in step 31. The above-described process is repeated based on .

When the file update process is completed based on all the file update tables 7 set in advance, the process moves to step S7, and it is determined whether or not there is an unread standard record in the standard file 5. If there is, the process returns to step Sl, reads the unread standard records, and repeats the above-mentioned process. Updates are made to the preset file based on all the standard records stored in the standard file 5 in this way. The process is completed.

Figure 6 shows another example of the word structure of a standard record.
For example, "Account ledger file", "Item ledger file", "Repair ledger file", "Seller management file", "Seller management file", "Item management file", "Repair management file", "Account summary file", "Account management file", "Assigned profit and loss management file" This is a standard word that corresponds to the word for updating the "Objective Profit and Loss Management File" and "Item Total File."In this figure, 1 of the settings for the correspondence between the standard word in the standard record and the word in each file is shown. An example is shown.

Therefore, if the word structure of such a standard record is fixed in advance, when designing a file, all you need to do is to set the word in the file that is necessary for the company, and you can easily design new files or change the design. It has the advantage of

[Effect of the invention] According to this invention, a standard record containing all the words necessary to update various files is generated and stored at the time of transaction occurrence, and when files are updated, arbitrary specifications can be made based on this standard record. Since the files are updated, new designs or design changes to the files to be updated can be made extremely easily at any time, and the effort required to design the entire system can be greatly simplified.

[Brief explanation of the drawing]

1 to 6 show an embodiment of the present invention. FIG. 1 is a schematic system configuration diagram of the entire file processing device, FIG. 2 is a diagram showing the configuration of a standard word table, and FIG. 3 is a diagram showing the configuration of a standard word table.
The figure shows the configuration of the file update table, Figure 4 shows an example of settings for the file update table shown in Figure 3, Figure 5 is a flowchart showing the operation when updating a file, and Figure 6 is a diagram showing another example of the word structure of a standard record. 1...Key human resources department, 2...Standard record generation section, 3...Standard word table, 5...
...Standard file, 6...File record creation section, 7...File update table, 8.
...Setting section, 9...File update section, l
O...Updated file group.

Claims (3)

[Claims] (1) When a transaction occurs, at least the following files are updated: an account file with account as a keyword, an item file with item as a keyword, a person in charge file with person in charge as a keyword, and a business partner file with customer as a keyword. a generating means for generating a standard record including all the words for the transaction, a storage means for sequentially storing the standard record generated each time a transaction occurs, a specifying means for arbitrarily specifying a file to be updated, and a file. a creating means for reading a standard record stored in the storage means and creating an update record for updating each file specified by the specifying means based on the standard record at the time of an update command; A file processing device comprising: updating means for updating a corresponding file with each created update record. (2) The generating means generates at least the following words: date, document number, amount, debit account item, debit customer, debit item, credit account item, credit customer, credit item, person in charge, item, quantity, and unit price. 2. The file processing device according to claim 1, wherein the file processing device generates a standard record containing a file. (3) The specifying means arbitrarily specifies the file name of the file to be updated and the word structure of the record of this file in association with the words of the standard record. file processing device.