JP3047397B2 - File processing device - Google Patents

Description

Description: TECHNICAL FIELD The present invention relates to a file processing apparatus having a plurality of files.

[Prior Art] In corporate economic activities, various transactions such as account transactions and logistics transactions occur. However, conventionally, the contents of the transactions have not been analyzed scientifically, and as shown in FIG. Processing is performed by a computer such as a processing device.

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, the transaction contents are not scientifically analyzed, and therefore, independent file processing programs are created for various transactions. It has been necessary to design in advance which word data should be used for each file and what file should be updated for each transmission type by a program.

Therefore, a great deal of labor is required to construct a system desired by the user. Specifically, when a system engineer performs a system design (program design) according to a user's request, all transaction contents, that is, types of slips such as orders, sales, orders, purchases,. There is a problem that it is necessary to design a program for each level individually, which takes much time and effort.

In addition, during the operation after the above-mentioned system construction, some modifications may be added to the user's request. In this case, the system engineer performs the maintenance work. Even so, the program modification was serious. 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 used as a dedicated machine for the transaction processing device.

An object of the present invention is to simplify the system design, significantly reduce the effort required for the design, and furthermore, when adding transaction types or changing individual processing contents, the processing can be performed with simple modifications. It is to be.

[MEANS FOR SOLVING THE PROBLEMS] The present invention relates to 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; A specific correspondence table storing means for storing a specific correspondence table that associates each word data inputted by the means with each specific word of a predetermined record structure prepared in advance as a specific record in a common format; A file correspondence table in which the update type information of the update type such as deletion, the word of the record structure in the file to be updated corresponds to which specific word of the specific record, and the file is used as the file to be updated. A definition table in which the code condition data for selection and the definition are stored in association with each other is provided for each file to be updated. Based on the definition table storage means separately stored, and the data corresponding to each word input by the input means and the specific correspondence table stored in the specific correspondence table storage means, input word correspondence data is stored in the predetermined correspondence table. A specific record generating means for generating a specific record allocated as data corresponding to each specific word of a specific record having a record structure; a specific record storage means for storing a plurality of specific records generated by the specific record generating means; and the specific record The specific records stored in the storage means are sequentially read, and a file whose code condition data matches is selected by referring to the definition table storage means based on predetermined code data included in each read specific record, For each selected file, the data of each specific word contained in the specific record is A record creation unit that creates an update record for updating the file by associating the file with a word of the record structure of the file based on the file correspondence table of each file; Based on each update record created by referring to the file correspondence table for each selected file, the file corresponding to the update record is updated according to the update type defined in the file correspondence definition table. File updating means for updating.

Embodiment 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,.
Input data for I, ... The slip input section 21a, 21
b,... are actually composed of one input device, for example, a mode key for designating various input modes, a type designation key for designating the type of transaction (type), a numeric keypad, and a numeric keypad. A function key and the like are provided. Then, the input devices 21a, 21b,
.. Are transmitted to the transmission type discriminating section 22 and the input data are transmitted to the input processing section 23. The input processing unit 23 includes a display unit (not shown), and displays an input format according to the input word table 24 on the display unit. The input processing unit 23 processes the input data from the slip input units 21a, 21b,... In accordance with the setting contents of the input word table 24, and outputs it 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 of the transmission setting table 27 and the word conversion table 28 are designated.
The setting tables of the input word table 24, the operation setting table 27, and the word conversion table 28 are read out according to the transaction type specified by the transmission type discriminating section 22, It is sent to the standard record creation unit 26. The standard record creation unit 26 converts a unique standard word data and an input word data corresponding to the transaction type from the business promotion setting table 27 into a word conversion table. Standard word converted to standard word data based on 28
The standard record is created by the data and the standard file 29
Write to. This standard record is a word record as shown in FIG.
In a predetermined order, various standard words such as “Nichiden”, “Debit subject”, “Debit client”, “Credit subject”,... It is arranged in. The above various words are referred to as standard words, and the records composed of the standard words are referred to as standard records regardless of the type of input slip (input word). The number of
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, which will be 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 above input word table 24, business setting table 27, and word
The data conversion table 28 and the 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 arbitrarily set by the user, and the input word table 24 can arbitrarily set the type, number, and order of input words according to the transaction type. This allows the user to input data in a desired format according to the type of transaction. In addition,
The input word of the input word table 24 and the standard word in the standard record are set in the conversion table 28 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 promotion setting table 27 stores data corresponding to a standard word which cannot be set from an input word, and various kinds of data specific to the transaction type are set in advance.

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

In the input word table 24, for example, as shown in FIG. 3, an input word name is set to a transaction type such as "sales", "purchase", "payment travel expenses",. For example, for the transaction type of “sales”, various word names such as “customer name”, “date”, “number”, “product name”, “quantity”, “unit price”, “amount”, etc. Is set.

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 the “debit subject”, subject code data indicating “accounts receivable”, “sales”, “purchase”... Corresponding to each transaction type are stored in advance, and as the “credit subject”, Item code data indicating "sales", "sellers", "payments",... Are stored in advance. Further, specific code data shown in the code correspondence table of FIG. 7 is set in advance as "transaction division", "in / out division", and "arrangement division". That is, the "transaction category" is a two-digit code, for example, "10" is "sales", "20" is "purchase", and "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 classification” 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 contents of various transactions not from the viewpoint of “money flow” but from the viewpoint of “article flow”. All transactions can be represented 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, and this table is an input word. It is used to convert data input corresponding to the word name into data corresponding to the standard word name.

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

The file update table 32 is a table used when various files are updated based on the standard record stored in the standard file 29. As shown in FIG. , "File name", "update type",..., Etc., the user can set any desired code condition, file name and update 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 the “transaction category”, “in / out category”,
The code of "arrangement section" is shown serially. In this case, for example, the code condition “1xx
"0", "2xx0", the transaction type is "10", "11", "12"
Alternatively, it is a code related to sales and purchase such as "20", "21", "22", etc., indicating that the arrangement category is "complete". In this case, any other code conditions may be used. The code condition “1020” in the A / R invoice ledger file is such that the transaction category is “sales”, the entry / exit category is “out”,
This indicates that the arrangement category is “completed”. Also, the keyword RK and the update words W1 to W5 are described in "File Word
And the standard word. For example, in the account ledger file, the file words "this insight (our account)", "Nikkei (date number)", "debt",
"Loan" is set, and "Debit subject",
"Nichiden", "Amount", "/" or "Debit subject",
“Nichiden”, “/”, and “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 set in association with each other. By simply setting, a desired file can be updated according to a desired update type based on the standard record. For example, the code indicating a transaction is "10
In the case of "20" (sales), this code corresponds to the code condition "1xx
0 ", two update records for the account ledger file based on the table 32-1 and the table 32-2.
(The records differ from each other in that one uses a standard word "debit subject" as a keyword and the other uses a standard word "credit subject" as a keyword). Create and update the account ledger file together.
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 are performed on the account ledger file.
Further, since this code also satisfies the code condition "xx2x", a record for updating the item ledger file is created by table 32-6, and additional updating is performed on the item ledger file. Do. Also, this code can be found in tables 32-3, 32-
Since the code condition matches the code condition of No. 7, the additional update and the total update are also performed on the receivable request 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. In addition, the settings can be set in the file update table. 32 makes it easier to set.

By the way, such a simple setting in the file update table 32 is performed only for the data for the file word.
In determining the data, it largely depends on the fact that the standardized word of the standardized 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). The standard word data necessary for each file is read from the record, and a record for updating the file may be created based on the data. For example, the account ledger file contains "this intuition" as a keyword,
One record is composed of each word of "Nichiden", "Debt", and "Lending" as update words, and "Debit subject" (or “Credit subject”), “Nichiden”, and “Amount” are set. Each data corresponding to the standard words "debit subject" and "credit subject" is a unique data corresponding to the transaction type based on the promotion setting table 27.
This data is used as keyword data for updating the file corresponding to the account ledger file.

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 type of the slip is sent to the type determining unit 22. This transmission type discriminating unit 22 is a slip input unit 21.
a, 21b,..., and the transaction type is specified for the input word table 24, and the input word corresponding to the specified transaction type is read out. Input to the input processing unit 23. For example, if "sales" is designated as the transaction type, the input word table "customer name", "date", "number", Are read out and sent to the input processing unit 23. The input processing unit 23 displays a slip input format on the display unit in accordance with the input word name from the input word table 24, and
Guide the input of data. The operator sequentially inputs data such as "customer name", "date", "file number", and the like in accordance with the format of the slip displayed on the display unit. As a result, the sequentially input data is input word.
The data is written in the input file 25 as data corresponding to the command name. Then, the input word table is input to this input file 25.
When data corresponding to all input word names has been input based on 24, this data group is sent to the standard record creation unit 26 as an input record for one record. .

Further, the transaction type of the business setting table 27 and the word conversion table 28 is designated by the discrimination output of the transmission type discriminating section 22, and the contents of the table are read out to the standard record creating section 26. Is done. In this case, since “sales” is specified as the transaction type, the sales promotion setting table 27 shows the unique data of “accounts”, “sales”, and “1020”, that is, the sales promotion setting data. Data is read out, and from the word conversion table 28, the correspondence between "Nichiden" and "Date-Number", the correspondence between "Debit customer" and "Customer name", and "Amount" , And the amount of money, are read, and sent to the standard record creation unit 26. The standard record creator 26 converts data corresponding to the input word name read out from the input file 25 in units of records into data corresponding to the standard word name according to the correspondence information. At this time, the standard record creating unit 26 also converts the above-mentioned business setting data from the business setting table 27 into one record as data corresponding to the standard word name. -Create a standard record for the data and write it in the standard file 29. In this way, the standard record for one record is stored in the standard file.
29, the standard record is stored in the file processing section.
Read to 31. The file processing unit 31 converts the standard record read from the standard file 29 into a file update table.
Process based on 32. First, the file processing unit 31 converts the code data corresponding to the standard words of "transaction division", "in / out division" and "arrangement division" in the standard record into the file update table 32. Check code conditions. Then, a file that matches 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 obtained. Then, an update process is performed on each file. Transaction types "purchase", "order", ...
And so on, 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 can be 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 of a specific record structure. And a file correspondence table for associating each word of the record structure in the file to be updated with which specific word of the specific record and for selecting the file. Based on the code condition data and one specific record with a transaction type code corresponding to the transaction type, it automatically selects which file to update from among various files with different record structures, and the selected Update records for updating files can be automatically created, and update types defined in advance for the files , The corresponding file can be updated.
Arbitrarily set which file of a plurality of files is to be updated, which word is to be updated at that time, etc. according to the definition method of each word in the file correspondence table. And updating the corresponding file based on each update record created based on the file correspondence table and the specific record according to the setting according to a predefined update type for the file. Can be.

[Brief description of the drawings]

FIGS. 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. FIG. 4 is a diagram showing an example of setting an input word table, FIG. 4 is a diagram showing an example of setting of an operation setting table, FIG. 5 is a diagram showing an example of setting a word conversion table, and FIG. FIG. 7 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, FIG. 9 is a diagram showing a system configuration of a conventional transaction processing apparatus. 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, ... file.

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; A specific correspondence table storage unit that stores a specific correspondence table that associates data with each specific word of a predetermined record structure prepared in advance as a specific record in a common format, and updates update types such as addition, aggregation, and deletion of a file to be updated. Type information, a file correspondence table in which each word of the record structure in the file to be updated corresponds to which specific word of the specific record, code condition data for selecting the file as a file to be updated, and , And a definition table that stores the definitions,
A definition table storage unit for individually storing each file to be updated; and a specific correspondence table stored in the specific correspondence table storage unit and each data corresponding to each word input by the input unit, Specific record generating means for generating a specific record in which the input word corresponding data is allocated as data corresponding to each specific word of the specific record having the predetermined record structure; and a plurality of specific records generated by the specific record generating means are stored. A specific record storage unit, sequentially reading the specific records stored in the specific record storage unit, and referring to the definition table storage unit based on predetermined code data included in each of the read specific records, to determine the code condition. Select files with matching data, and for each of the selected files, Record creation means for creating an update record for updating the file by associating the data of the fixed word with the word of the record structure of the file based on the file correspondence table of each selected file; The file corresponding to the update record is defined based on each update record created by referring to the file correspondence table for each specific record and for each selected file by the creating means. A file processing device, comprising: file updating means for updating with an update type defined in a table.