JP3047396B2 - File processing device - Google Patents

Description

The present invention relates to a file processing device having a plurality of files.

[Conventional technology]

In corporate economic activities, various transactions such as account transactions and logistics transactions occur. However, conventionally, the details of the transactions have not been analyzed scientifically, and as shown in FIG. To be processed.

That is, in the conventional transaction processing, as shown in FIG. 9, the slip input sections 11a and 11
file processing programs I, I for b, 11c, ... respectively
I, III, ... are provided. 12 is a file group,
A plurality of files such as files A, B,... Are provided. Therefore, when issuing a slip, it is necessary to build an update program for file A (A1, A2,...), An update program for file B (B1, B3,. A completely separate file update program is set for each transaction.

[Problems to be solved by the invention]

As described above, in the conventional transaction processing, an independent file processing program is created for each type of transaction. , Etc. had to be designed in advance one by one by a program.

Therefore, in order to construct a system desired by the user, it is difficult to design the system, especially when there are many transgenic species. Specifically, when a system engineer performs a system design (program design) according to a user's request, all transaction contents, ie, orders, sales, orders, purchases,... In addition, there is a problem that it is necessary to design a program, and it takes much time and effort.

Also, during the operation after the above-mentioned system construction, some corrections may be added to the user's request, in this case, the system engineer will be responsible for the maintenance work, but at this time, even if some corrections are made The program modification was terrible. In addition, the above design often fails to construct a system desired by a user depending on the ability of a system engineer. This is because the conventional office computer is a device that can perform all kinds of processing depending on how to create a program, and it seems that the cause is that it cannot be fully used as a dedicated machine of the transaction processing device.

An object of the present invention is to make it possible to perform file processing on all desired files only by setting simple conditions without having to design completely separate file processing programs for each transaction. .

[Means for solving the problem]

The present invention relates to a file processing apparatus having a plurality of files, comprising: input means for inputting data in words for a plurality of words included in an input record; and data of each word input by the input means. First correspondence table storage means for storing a specific correspondence table for associating each word of a predetermined record structure prepared in advance as a specific record, and each word of the record structure in the file to be updated corresponds to any word of the specific record A second correspondence table that individually stores, for each file to be updated, a code correspondence data for selecting the file as the file to be updated for each file. Storage means, and each data corresponding to each word input by the input means and stored in the first correspondence table storage means Based on the specific correspondence table, specific record generating means for generating a specific record in which the input word corresponding data is allocated as data corresponding to each word of the specific record of the predetermined record structure, and the specific record generating means Specific record storage means for storing a plurality of specific records, and sequentially reading the specific records stored in the specific record storage means, based on predetermined code data included in each of the read specific records. A file whose code condition data matches is selected with reference to the table storage means, and for each of the selected files, the data of each word included in the specific record is determined based on the file correspondence table of each of the selected files. Update the file by associating it with the word in the record structure of the file Record creation means for creating an update record for updating, based on each update record created by referring to the file correspondence table for each specific record and for each selected file by the record creation means. File updating means for updating each corresponding file.

〔Example〕

An embodiment will be described below with reference to FIGS. 1 to 8.

FIG. 1 shows a system configuration diagram of a transaction processing apparatus for performing processing such as voucher issuance, voucher issuance, and the like. In the figure, reference numerals 21a, 21b,.
Enter the data for I, ... The slip input section 21a, 21
b,... are actually composed of one input device, and include, for example, a mode key for designating various input modes, a type designation key for designating the type of transaction (type), a numeric keypad, a function key, and the like. I have. Then, the input devices 21a, 21b,
.. Are transmitted to the transmission type discriminating unit 22 and the input data are transmitted to the input processing unit 23. The input processing unit 23 includes a display unit (not shown), and displays an input format on the display unit according to the input word table 24. The input processing unit 23 performs input processing on the input data from the slip input units 21a, 21b,... According to the setting contents of the input word table 24, and outputs the input data to the input file 25. The file data stored in the input file 25 is read out to the standard record creation unit 26.

On the other hand, the transmission type discriminating unit 22 determines the transmission type to be issued according to the transmission data transmitted from the slip input units 21a, 21b,. The transaction type in the word conversion table 28 is specified.
The setting tables of the input word table 24, the business transfer setting table 27, and the word conversion table 28 are read out according to the transaction type designated by the transmission type determining unit 22, and sent to the standard record creating unit 26. The standard record creation unit 26 uses standard word data unique to the transaction type from the business promotion setting table 27 and standard word data obtained by converting input word data into standard word data based on the word conversion table 28. Create record, standard file 29
Write to. This standard record has a word structure as shown in FIG. 2, in which various standard words such as "Nichiden", "Debit subject", "Debit client", "Credit subject", etc. are predetermined. They are arranged in a predetermined order for a few minutes. Here, the above-mentioned various words are called standard words, and records composed of the standard words are called standard records, regardless of the type of input slip (the number of input words,
This is because all input data is stored and managed as a single type of unified record as shown in FIG. The standard record written in the standard file 29 is read by the file processing unit 31. The file processing unit 31 performs processes such as addition and aggregation for the designated files 33a, 33b,... Based on a file update table 32 described in detail later. The above file 33a,
As 33b,..., For example, files such as an account ledger, an account receivable billing ledger, an item ledger, an item management, an account tally, and the like are set.

The input word table 24, business setting table 27, word conversion table 28, and file update table 32 are set as shown in FIGS.

Of these, input word table 24, word conversion table 2
8. The file update table 32 is a table that can be set arbitrarily by the user. The input word table 24 allows the user to arbitrarily set the type, number, and order of input words according to the type of transaction. Data can be input in a desired format according to the type. In the word conversion table 28, the input words of the input word table 24 and the standard words in the standard records are set in association with each other. In the file update table 32, it is possible to arbitrarily set what kind of transaction is to be performed and what kind of file is to be updated. On the other hand, the business transfer setting table 27 stores data corresponding to a standard word that cannot be set from the input word, and various data unique to the transaction type are set in advance.

Next, setting examples of the various tables will be specifically described.

In the input word table 24, for example, as shown in FIG. 3, input word names are set for transaction types such as “sales”, “purchase”, “payment travel expenses”,. For example, various word names such as “customer name”, “date”, “transport number”, “product name”, “quantity”, “unit price”, “amount” are set for the transaction type “sales”. Is done.

As shown in FIG. 4, the sales promotion setting table 27 includes “Orders”, “Sales”, “Sales Returns”, “Orders”, “Purchases”,
.., Etc., specific data for each standard word such as “debit subject”, “credit subject”, “transaction category”, “in / out category”, “arrangement category” and the like are stored. For example, as “debit item”, item code data indicating “account”, “sales”, “purchase”... Corresponding to each transaction type is stored in advance, and “sales”, “ Account code data indicating "accounts receivable", "accounts", ... is stored in advance. Further, specific code data shown in the code correspondence table of FIG. 7 is preset as the “transaction category”, “in / out category”, and “arrangement category”. That is, “transaction category” is a two-digit code, for example, “10” is “sales”, “20” is “purchase”, “3”
“0” indicates “pure distribution”. The “in / out section” is a one-digit code, where “0” indicates “none”, “1” indicates “in”, and “2” indicates “out”. The “arrangement category” is a one-digit code, where “0” indicates “complete”, “1” indicates “arrangement”, and “2” indicates “temporary arrangement”. The various categories of "transaction category,""in / out category," and "arrangement category" are categories that analyze the content of various transactions not from the viewpoint of "money flow" but from the viewpoint of "flow of goods." All transactions can be expressed by a combination of codes in each section. For example, a transaction called "orders" is a transaction in which goods are delivered to the other party to receive money, that is, a transaction that occurs immediately before a transaction called "sales", and the "transaction category" is the same as the transaction of "sales". This corresponds to the transaction classification code “10” and corresponds to the entry / exit classification code “2” indicating “out” of the article. The arrangement classification code corresponds to "1", indicating that the article has not been delivered to the destination.

The word conversion table 28 is a table for associating an input word with a standard word for each transaction type as shown in FIG. 5. The table converts data input corresponding to the input word name into a standard word name. It is used to convert to data corresponding to.

Therefore, standard record data composed of various standard words as shown in FIG. 2 can be created by the above-mentioned business transfer setting table 27 and word conversion table 28.

The file update table 32 is a table used when updating various files based on the standard records stored in the standard file 29. As shown in FIG. 6, the "code condition", "file name", "update" The user can set any code condition, file name, and update type desired by the user for items such as "type",.
RK and update words W1 to W5 are set. As the above-mentioned “file name”, “account ledger”, “receivable billing ledger”, “payable billing ledger”, “item ledger”, “item management”, “account summarization”, etc. are set. "Add", "Total", etc. are set. The “code conditions” are “transaction category”, “in / out category”,
The code of "arrangement section" is serially shown. In this case, for example, the code condition “1 ×
× 0 ”and“ 2xx0 ”indicate that the transaction category is“ 10 ”,“ 11 ”,
A code related to sales and purchase such as “12” or “20”, “21”, “22”, etc., indicating that the arrangement category is “completed”. In this case, any other code condition may be used. The code condition “1020” in the receivable request source file indicates that the transaction category is “sales”, the entry / exit category is “out”, and the arrangement category is “completed”.
The keyword RK and the update words W1 to W5 indicate the correspondence between the “file word” and the “standard word”. For example, in the consideration ledger file, "this insight (our account)", "Nichiden (date number)", "debt", "loan" are set as file words, and "debit subject", ""Nikkei","amount","/" or "debit subject", "Nikkei", "/", "amount" are set.

When setting the file update table 32, the user (user or system engineer) must determine in advance what transaction should be performed and what file should be updated in what transaction. Once this is determined, the code condition at that time, the file name, and the update type are sequentially set, and the file word and the standard word in the file at that time are simply set in association with each other, and the standard record is set. , A desired file can be updated according to a desired update type. For example, if the code indicating a transaction is "10
20 ”(sales), this code is based on the code condition“ 1 ×
× 0 ”, the table 32-1 and the table 32-2
Based on the two update records for the ledger file (one of these records has the standard word "debit item" as a keyword and the other has the standard word "credit item"
Are different from each other in that the keyword is used as a keyword), and both the ledger files are additionally updated. Since this code condition is also set in the table 32-8, a record for updating the account totaling file is created, and totalizing and updating is performed on the account ledger file. Further, since this code also satisfies the code condition "xx2x", an update record for the item ledger file is created from the table 32-6, and the item ledger file is additionally updated. This code is also shown in Table 32-3,
Since it matches the code condition of 32-7, additional updating and totalizing updating are also performed on the receivable billing ledger file and the item management file.

As described above, various update records for a plurality of files can be created from one standard record, and the corresponding files can be updated, and the settings can be easily set by the file update table 32. .

By the way, the simple setting in the file update table 32 is largely attributable to the fact that when determining data for a file word, a standard word of a standardized standard record can be used as the corresponding word. In other words, the standard record shown in FIG. 2 has all necessary words necessary for the subsequent processing (in this case, file processing). It is sufficient to read the data of the standard word necessary for the user and create a record for updating the file based on the data. For example, in the ledger file, "this intuition" is a keyword,
One record is composed of the words “Nichiden”, “Debt”, and “Loan” as the update words, and the corresponding standard words “Debit subject” (or “Credit subject”) and “Day” ”And“ Amount ”are set. Each data corresponding to the standard words “debit subject” and “credit subject” is set as unique data corresponding to the transaction type based on the business promotion setting table 27, and this data corresponds to the account ledger file. Used as keyword data for file update.

Next, the operation of the above embodiment will be described with reference to FIG.
When a slip input mode is designated from the slip input units 21a, 21b,... At the time of issuing a slip, data indicating the slip type is sent to the slip type determination unit 22. This transmission type discriminating unit 22 is a slip input unit 21.
a, 21b,... are determined, the transaction type is specified in the input word table 24, the input word corresponding to the specified transaction type is read, and input to the input processing unit 23. . Assuming that “sales” is designated as the transaction type, for example, the input word names “customer name”, “date”, “biographical number”,... It is sent to the input processing unit 23. The input processing unit 23 displays the slip input format on the display unit according to the input word name from the input word table 24, and guides data input. The operator sequentially inputs data such as "customer name", "date", "number", and the like in accordance with the format of the slip displayed on the display unit. As a result, sequentially input data is written to the input file 25 as data corresponding to the input word name. Then, input word table in this input file 25
When the data corresponding to all the input word names has been input based on 24, this data group is sent to the standard record creation unit 26 as one input record.

The transaction type of the business transfer setting table 27 and the word conversion table 28 is designated by the discrimination output of the transmission type discriminating unit 22, and the contents of the table are read out to the standard record creating unit 26. In this case, since “sales” is specified as the transaction type, unique data of “accounts receivable”, “sales”, and “1020”, that is, business promotion setting data are read from the business promotion setting table 27. Also, from the word conversion table 28, the correspondence between "Nichiden" and "Date-Branch", the correspondence between "Debit customer" and "Customer name", the correspondence between "Amount" and "Amount", ... Are read and sent to the standard record creation unit 26. The standard record creation unit 26 converts data corresponding to an input word name read out from the input file 25 on a record-by-record basis as data corresponding to the standard word name according to the correspondence information. The creation unit 26 creates a standard record for one record as the data corresponding to the standard word name also from the business promotion setting data from the business promotion setting table 27, and writes it in the standard file 29. In this way, the standard record for one record is stored in the standard file
29 is written to the file processing unit.
Read to 31. The file processing unit 31 stores the standard record read from the standard file 29 in the file update table.
Process based on 32. First, the file processing unit 31 checks the code conditions of the file update table 32 from the code data corresponding to the standard words of “transaction category”, “entry / exit category”, and “arrangement category” in the standard record. And
A file matching the code condition is selected, an update type is determined, and a standard word and a file word are converted, so that a file update record corresponding to each file is created, and update processing for each file is performed. Is performed. The transaction types are “purchase”, “order”,
.. Etc. are specified, the same operation is performed, and the desired file can be arbitrarily updated.

[Effects of the Invention] According to the present invention, various input data are converted into a specific record in a common format based on a specific correspondence table in which each word arbitrarily input corresponds to a word in a specific record structure. A file correspondence table in which each word of the record structure in the file to be updated corresponds to which word of the specific record, and a code condition for selecting the file Based on the data, from one specific record with a transaction type code corresponding to the transaction type, it automatically selects which file to update from various files with different record structures, and stores the selected file Update records for updating can be automatically created, so which of multiple files can be updated And the word to be updated at that time can be arbitrarily set according to the definition of the correspondence of each word in the file correspondence table, and the file correspondence according to the setting can be set. The corresponding file can be updated based on each update record created based on the table and the specific record.

[Brief description of the drawings]

1 to 8 show an embodiment of the present invention. FIG. 1 is a system configuration diagram of a transaction processing apparatus, FIG. 2 is a diagram showing an example of setting a standard record, and FIG. 3 is an input word. FIG. 4 is a diagram showing a setting example of a commercialization setting table, FIG. 5 is a diagram showing a setting example of a word conversion table, and FIG. 6 is a diagram showing a setting example of a file update table. , FIG. 7 is a diagram showing a correspondence relationship of each code in the above-mentioned operation setting table, FIG. 8 is a diagram for explaining a file update operation, and FIG. is there. 21a, 21b, ...… slip input section, 22… type discrimination section, 23…
Input processing unit, 24: Input word table, 25: Input file, 26: Standard record creation unit, 27: Business setting table, 28: Word conversion table, 29: Standard file, 31: File Processing unit, 32... File update table, 33a, 33b,.

Claims (1)

(57) [Claims] 1. A file processing apparatus provided with a plurality of files, comprising: input means for inputting data in a word unit to a plurality of words included in an input record; First correspondence table storage means for storing a specific correspondence table for associating data with each word of a predetermined record structure prepared in advance as a specific record; and each word of the record structure in the file to be updated corresponds to any word of the specific record. A second correspondence that stores, separately for each file to be updated, a code correspondence data for selecting the file as a file to be updated for each file to be updated. Table storage means, and each data corresponding to each word input by the input means and stored in the first correspondence table storage means A specific record generating means for generating a specific record in which the input word corresponding data is allocated as data corresponding to each word of the specific record of the predetermined record structure based on the specified specific correspondence table, and the specific record generating means. A specific record storage unit for storing a plurality of the generated specific records; a specific record stored in the specific record storage unit is sequentially read; and the second record is stored on the basis of predetermined code data included in each of the read specific records. A file whose code condition data matches is selected with reference to the correspondence table storage means, and for each of the selected files, the data of each word included in the specific record is stored in the file correspondence table of each of the selected files. File by matching it to the word in the record structure of the file A record creation unit for creating an update record for updating, based on each update record created by referring to the file correspondence table for each specific record and for each selected file by the record creation unit File updating means for updating each corresponding file.