JPH02133871A - Record data processor - Google Patents

Abstract

PURPOSE:To cope with the input forms of various slips, etc., by using a control means which controls the production of the record data in response to an input form which is designated by a designating means when a process having the contents corresponding to the word type is executed. CONSTITUTION:Each word and its type of a record to be produced are set and registered into a register memory 1, and an input form designating means 2 previously designates the input form of the word type showing the input of data. Then the contents set at the memory 1 are read out every word in response to a slip production command, etc., and a process having the contents corresponding to the word type is executed for production of the record data. In this case, a control means 3 controls the production of the record data in accordance with the input form designated previously by the means 2 as long as the word type shows the input of data. Thus it is possible to cope with the input forms of various slips without designing a complicated production program of the slips, etc., in a program language.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a record data processing device for creating record data constituting a form file or the like in an office computer, a personal computer, or the like.

[Prior Art] Conventionally, office processing devices such as office computers, personal computers, and general-purpose computers have been generally used to create and process sales slip files, inventory files, and the like.

In order to make these main processing devices compatible with various data input formats of vouchers, a voucher creation program was designed for each input format.

That is, FIGS. 8 and 9 show specific examples of this case,
FIG. 8(A) shows a display screen when a slip is created according to a normal slip input format, and FIG. 9(A) shows a display screen when a slip is created according to a special slip input format. Here, rXXXJ in the figure is "r date", "
It shows the display contents related to headings such as "Slip number".

First, in the 8th v4, the key human power items “IIJ, rI
This shows a sequential input format in which a slip is created by sequentially inputting data in the order of ``2'', ``I3'', ..., r114J. In this input format, for example, when data is input into the key manual item "I3", the data is displayed in the item "Dl" accordingly, and the process moves to the next key manual item "I4". When creating a slip according to such sequential input method, as shown in Fig. 8 (B),
rXNPUT instruction in J-ra, rDIsPLAY instruction J
It is necessary to design a slip creation program that makes one set and repeats it.

In addition, in FIG. 9, when creating a slip by reading out a record that satisfies a certain condition, such as the number of sold items being r101 or more and less than r2O0J, from a previously created slip file, input items rI on one display screen are shown.
When you input a certain condition from 20J to "Engineer 23", records that match the condition are read from the file and displayed between items "D20" and rD30J, and then - are collectively entered into the key manpower item rI24J. This shows a batch input format in which data is input sequentially from "I27" to "I27". Since a slip is created in this way, from now on, such slip creation will be referred to as an inquiry update.However, when updating an inquiry according to the batch input format as described above, Figure 9 (B
), first, according to the READ command, the process of reading records from the file and storing them in an array is repeated, and then the records stored in the array are sent to DISPLA.
It is necessary to design a slip creation program that repeats the process for display according to the Y command, and repeats the process for inputting the last input data into key manual items "I24" to rI27J according to the INPUT command. Issue 111 that the C invention seeks to solve As described above, in the past, it was necessary to prepare various invoice creation programs in advance to correspond to various invoice input formats, but it was not possible to solve such problems using a programming language. Designing various slip creation programs requires a great deal of effort and is difficult for general users to create, and it has also been difficult to make partial changes to the programs.

The problem of this invention is to enable versatile record data processing on office computers, etc., which can be adapted to various input formats of vouchers, etc., without having to design a program for creating complex vouchers, etc. using a programming language. The goal is to provide equipment.

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

Registration memory! (See the functional block diagram in Figure 1, the same applies hereinafter) is a word that is set and registered in advance to create record data that constitutes a form file, etc., and defines the word name of each record to be created and its processing content. Remember the seeds. Here, word names include "product", "person in charge",
"Affiliation" etc., and the word type is "input word" which defines that word data should be input, and "calculation word" which defines that calculation such as "unit price x quantity" should be performed.
, a [table index word] that defines that an index table or the like should be referred to. Then, in response to a form creation command or the like, the setting contents of the registration memory 1 are read word by word, and processing of the contents according to the word type is executed, thereby creating record data.

The input format specifying means 2 is a key input unit or the like that specifies the input format of the word type indicating data input. Here, the input format refers to a format in which word data is input sequentially, a format in which word data is input all at once, and the like.

When the control means 3 executes processing of the content according to the word type, if the word type is a word type indicating data input, the control means 3 inputs the record data according to the input format specified by the input format specifying means 2. Control creation.

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

First, the user sets and registers each word name of the record to be created and its word type in the registration memory l, and then specifies in advance the input format of the word type indicating data input using the input format specifying means 2. .

In this state, in response to a form creation command, etc., the setting contents of the registration memory 1 are read word by word, and processing according to the word type, such as data input processing, table indexing processing, calculation processing, etc., is executed. By doing this, record data is created. At this time, if the word type indicates data input, the control means 3 selects the record data according to the input format specified in advance by the input format specifying means 2. Controls creation 0 For example, if the sequential input format is specified, the word type is Record data is created sequentially by faithfully executing processing according to the content. In addition, when the bulk input format is specified, if the word type read from the registration memory l indicates data input, that data input process is skipped, a temporary record is created, and all records are After creation, the word data that has been sequentially input into the data input word area in the temporary record is input into all records at once.

Therefore, the present invention provides a highly versatile record data processing device such as an office computer that can accommodate various input formats of vouchers, etc. without having to design a complicated voucher creation program using a programming language. can do.

[Implementation Ml Hereinafter, one embodiment will be described with reference to FIGS. 2 to 7.

FIG. 2 is a block circuit diagram showing the basic configuration of an office computer.

The CPU II controls various operations according to a fixed program such as an operating system stored in the ROM 12. In addition to the ROM 12, the CPU 11 has a key input section 13. Display unit 14, RAM 15, table memory 16. A file memory 17 is connected.

The key human power section 13 is used to input various data such as slip data and various commands such as a slip creation command and a slip printing command.The key code outputted from the key human power section 13 corresponding to the operation key is sent to the CPU II. It is imported and input processed.

The display section 14 is constituted by a CRT display device, and displays and outputs slip data and the like on its display screen according to a predetermined output format.

RAM 15 includes registration memory 15-1 and data creation area 15
-2, -A configuration having a bulk input flag memory 15-3,
Data aging/reading operations are side-lined under the control of the CPU II. Here, the registration form memory 15-1 stores data registered in advance by the user in place of the conventional slip creation program, and the CPU II stores the registered contents of the registration form memory 15-1 when creating slip data. By executing the solution station, slip data is created one by one and stored in the data creation area 15-2. At this time, the key human power section 13 inputs the data input from the key human power section 13 and the data read from the file memory 17. Data creation area 15 with data as is
-2, or by performing a predetermined calculation on data obtained by referring to the contents of the table memory 16, input data from the key human power section 13, or data read from the file memory 17. The obtained data is stored in the data creation area 15-2 as slip data. Also, when creating slip data, CP
The UII determines a prespecified input format (normal sequential input format or batch input format) by referring to the contents of the batch input flag memory 15-3, and executes processing according to the input format. Note that the slip data thus stored in the data creation area 15-2 is sent to the file memory 17 and stored therein when the creation of one slip is completed.

Next, the settings of the registration form memory 15-1 will be explained with reference to FIG.

FIGS. 3(I), (II), and (III) show registration form I, registration form (2), and registration form (2) which are arbitrarily set by the user in advance according to the type of slip. In other words, the registration form! , ■, ■, the "word name" is set for each word of the l record, and the "word type" and "word content" are set as necessary.

Here, "word name" is a code indicating "product", "person in charge", "affiliation", etc. In the figure, "word A", "word B", etc.
”, “Word C”, “Word D”, “Word E”
indicates a "word name". In addition, "word type" is a code that defines the processing content of the word.For example, "key manual word", "table index word", "calculation word"
, "tally word", etc. Furthermore, “word content” is “
A code that more specifically (auxiliary) defines the processing content defined in the word type. For example, if the word type is a table index word, the Indicates that "Table" should be searched for "Word A".

In this way, if the word names of the records to be created in place of the normal slip creation program and the word types that define the processing contents are written in the registration form memory 15-1 and registered in advance, the key In response to a slip creation command from the human resources section 13, the CPU II reads the setting contents of the registration form memory 15-1 for each word name and creates record data by executing processing according to the word type. The data is then stored in the data creation area 15-2.

Note that the table memory 16 has various index tables; for example, a product table stores various product names corresponding to product codes, and a person in charge table stores various names corresponding to person in charge codes. The name of the person in charge is memorized.

Next, the operation of this embodiment will be explained with reference to FIGS. 4 to 7.

It is now assumed that before creating a sales slip, the user has previously created a registration document I as shown in FIG. 3(I) and set it in the registration document memory 15-1. In this case, registration form I is a registration form for creating sales slips in which each word of an item (l record) is composed of "product code", "product name", and "quantity", and the first word is Define that the product code should be entered, define that the product table in table memory 16 should be indexed based on the product food entered in the next word, and define that the quantity should be entered in the last word. Defined.

Therefore, when creating a slip using such a registered calligrapher, the input format of the slip must be specified beforehand. Now, suppose that the slip is created according to the normal sequential input format, - A flag 0'' is set in the speaker flag memory 15-3.

In this state, when a slip creation command is input from the key manual section 13, the CPU II responds to the command and performs the operation according to the flowchart of FIG.

Here, Figure 5 shows the creation process when creating a sales slip using Registration Form I, and each time data is input, the contents of the data creation area 15-2 and the display screen are as shown in Figure 5. It changes as shown in (1) to (4). And Figure 5 (1)
~(4) shows the data input waiting state in sequence,
On the display screen, the hatched area in the figure is displayed in reverse to show the current input position. Furthermore, in this embodiment, the data is handled as variable length data by dividing the data into records and words using the record delimiter code ")" and the word delimiter code "9".

When the flow shown in FIG. 4 is entered, a record start code "(") is set in the data creation area 15-2 in step S1 (see FIG. 3 (1)).

Then, the first word is read from the registered calligrapher set in the registration form memory 15-1 (Step S2), and the word type is determined (Step S3). Here, the word type of the first word is " Since it is a "key human power word", the process advances to step S4.

The input format specified in advance is checked by referring to the contents of the pattern input flag memory 15-3, but since the sequential input format is currently specified, the process advances to step S5 and enters a state of waiting for key input. . In this case, Fig. 5 (1)
As shown in , the input canister is displayed in reverse video on the display screen, indicating that the first word of the l record is the input canister. Here, if you input word data (for example, product code), the input word data will be stored in the data creation area 1.
5-2 and displayed on the input screen of display screen-L. At this time, a delimiter code "9" indicating a word delimiter is added to the next digit of the word data stored in the data creation area 15-2.

Then, on the condition that there is a next word in the registration form ■ (step S7), the next word is read from the registration form I (step S8), and the process returns to step S3 to check the word type. Since "table index word" is defined as the word, the process proceeds to step S9.If other word types other than "key manual word" are defined in this way, "N
On the condition that it is determined as "O", processing according to the word type is executed to create word data (step 5IO).Now, since the word type is "table index word", table index processing is performed. In this case, the product table in the table memory 16 is searched based on the word data (product code) input in the first word processing, and the delimiter code "9" is added to the product name. '' and stores it in the data creation area 15-2 (see FIG. 5 (2)).

Next, the process advances to step S7, and similar processing is executed hereafter, but in this case, the 3#i-th word is a "key human-powered word", so in this case as well, the key-powered word data (for example, , quantity data) in data creation area 15.
-2 (steps S5, S6).

Next, when it is detected in step S7 that there is no next word, that is, the end of l records, the process proceeds to step Sll, where it is detected whether or not the processing for l slips has been completed, depending on the input format. The detection methods are different. In other words, when the sequential input format is specified, detection is performed based on whether or not the end key is pressed when all records that make up a sales slip, etc. If an input format is specified, detection is performed based on whether all records satisfying a certain condition have been read from the file memory 17.

Since the sequential input format is now specified, if the end key is not operated, the process returns to step S1 on that condition. As a result, as shown in FIG. 5(3), the data creation area 15-
The record start code "(" for the second record is set in 2, and the input signal at the top of the display screen moves to the beginning of the second record. Also, in the second record,
As in the case described above, the first word is read from the registration document I and the processing according to the word type is executed. Therefore, FIG. 5(4) shows a state in which the third word of two records is waiting for key input.

Hereinafter, similar processing is executed, but if the end key is operated here, this is detected in step S11 and the process proceeds to step 312, where - pattern entry flag memory 15-3
Find out the currently specified input format based on the contents of . Since the sequential input format is currently specified, the slip creation process ends at this point.

When creating a slip in this sequential input format, record data is created sequentially by faithfully executing the processing according to the word type of the words read out from the registration form I sequentially.

Next, an explanation will be given of the operation when creating a sales slip (updating an inquiry) using a registration form (2) as shown in FIG. 3(n).

The content of this registration form ■ is almost the same as the registration form I mentioned above, so when creating the registration form ■, all you have to do is copy the registered heavy industry and delete or change a part of it. can be created.

FIG. 6 shows the process of creating a slip when updating an inquiry using such a registration form (2). Note that in this example, the number of records matching the inquiry condition is four.

When creating a document by updating an inquiry like this,
Since the input format is a batch input format, first specify it. Then, flag 1" is set in the speaker flag memory 15-3 and the batch input format is specified. Enter the inquiry conditions as shown below.

In such a state, the CPU II responds to the slip creation command and executes the operation according to the flowchart of FIG. In this case, as shown in FIG. 3 (II), the registration form ■ matches the inquiry condition in which the data up to the second word is read from the file memory 17 because the "key human power word" is the third word. The input words are created based on the records (steps 5l-5ll), and then input words are created by collectively inputting data to each record (steps 312-522).

First, enter the record start code "(" in the data creation area 15-
2, the ml word is read from the registration form ■ and the word type is determined (steps S1 to S3).
In this case, since the "word type" is not defined for the first word, the data read from the file memory 17 (
For example, the product code) is stored as is in the data creation area 15-2 (step 310).

Next, the 2nd # word is read from the registration book ■ (
Step S8), in this case, the word type is "table index word", so the data (for example, product name) obtained by the table index is stored in the data creation area 15-2 (step 5lO), FIG. (1) shows the contents of the data creation area 15-2 at this time. Next, the third word is read from the registration form ■, but since this word field is a "key human word", it is detected in step S3 and the process proceeds to step 513, where a pending code is created and inserted. The 6th word is the hold code (6th word
(See Figure (2)), the hold code consists of 3 digits and is inserted to temporarily hold data input and secure 3 digits in advance in the data creation area 15-2. Shown with shading. Note that the word delimiter code "9" is added even when inserting a suspension code, as in the normal case.

In this way, if the -pattern input format is specified and the word type read from the registration form is a "key manual word", the key manual word processing is skipped and a hold code is used instead. A temporary record is created by inserting it into a record.

When the processing for l records is completed, step S7
This is detected in step S11, and the process proceeds to step S11.
Returning to step S1, the above-described operation is repeated.

FIG. 6(3) shows a case where the temporary record creation process as described above is performed on all records, and the third word of each record becomes a suspension code.

However, since the pattern input format is now specified, this is detected in step 512, and the following step 31
The process moves to batch input processing from step 4 to step S22.

That is, step 5 to read the first word from the registration form ■
14) Check whether the word type is a "key human word" (step 515).

Now, since the first word is not a "key human-powered word", the process proceeds to step 321, where the same judgment as in step S9 above is made. Here, steps S9 and S21 are used to perform processing according to the word type. This is to check whether or not the word contains a word for which key human power is being held as a "holding code". In this case, the word type is not defined, so the process directly proceeds to step S18. Here, the next word is Read the next word on the condition that it exists (step 319), check the word type (step 515)
), in this way, a search is performed for the word defined as a "key manual word" among each word in the l record, but in the registered tooth H, the third word is defined as a "key manual word". Therefore, the process advances to step S16 and enters a key human power waiting state.

Now, when word data (for example, unit price) is input to the first code, the process proceeds to step 517, and the input word data is assigned to the reserved code position of the first code in the data creation area 15-2 (see FIG. 6). 4)), in this case, on the display screen, the input canister is as shown in Figure 6 (4).
) moves to the next record position as shown.

Then, in the next step 518, the absence of the next word is detected, so the process proceeds to step S20, and it is checked whether data input to all records has been completed. In this case, end detection is performed based on whether or not the next record is stored in the data creation area 15-2, but since the presence of the next code is now detected, the process returns to step S14 and the registered record is stored again. ■
The first word is read from , and similar processing is performed thereafter.

FIG. 6(5) shows the state when word data is manually input to the second record.

In this way, the above-described operations are repeated until all data input to each record is completed.

Next, when creating a sales slip (updating an inquiry) using the registered tooth m as shown in FIG. 3 (III), first,
A registered tooth ■ is created, but in this case, the contents of the registered tooth ■ are almost the same as the registered tooth ■, so just copy the registered tooth ■ and add a new word to create the registered tooth ■. can be created. In addition, for the newly added word as a registered tooth ■, the word name is ``sales amount'', the word type is ``calculation word'', and the word content is 荊 word, and the key data (unit price) is saved in file memory 17 This indicates that the data (for example, the number of items) read from is to be multiplied.

FIG. 7 shows the process of creating a slip when an inquiry is updated using such registered tooth (2).

In this case as well, the slip is created according to the same process as in the case of the registered tooth H described above.

That is, first, Fig. 7 (1) shows the case where up to the third word of the if record is processed, and since the third word is a "key manual word", a hold code is created and inserted, and the third word is processed. becomes a hold code (step 513)
.

Next, FIG. 7(2) shows the case where up to the fourth word of the 1st code is processed. Here, since the fourth word is a "calculation word", it is detected in step S9 that a pending code is included as the third word in the process. Therefore, in this case as well, a pending code is created and inserted, and the fourth word also becomes a pending code (step 513), that is, the fourth word is 3? ! This is a word that performs calculation processing based on the i-th "key human power word". Therefore, in order to suspend processing of the fourth word until the third word is determined, that word is also set to a suspension code.

Figure 7 (3) shows the case where the above-mentioned process is performed on all records, and all records matching the query conditions are created in the data creation area 15-2, but in this case, the third record of each record is , the fourth word is all reserved codes. Also, the display screen at this time is 3 of the first record.
The second word is displayed in reverse video and becomes the entry point.

Figure 7 (4) shows the key human power waiting state shown in Figure 7 (3).
In step 516), when word data r123J is input, the input word data is substituted into the pending code position. In this way, when the third word is determined, the process moves on to the fourth word.
Since the th word is not a pending code, step 32
1, this is detected and the process proceeds to step S22, where the word data created by the fourth word processing (calculation processing) is substituted into the pending code position δ. At this time, the input signal on the 1st display screen moves to the 3rd word of the next record [1].

Figure 7 (5) shows the case where data is input into the third word of the second record, and word data is substituted into the third and fourth pending code positions as in the case of Figure 7 (4).
Also, the input information on the display screen moves to the third word of the three records.

Thereafter, similar processing is performed for all records.

In addition, in the above embodiment, when inputting data all at once, a hold code is inserted in the created record, and then when data is input, the input data is assigned to the hold code position, but at least By inserting a word delimiter code, you can later insert data of any length between word delimiters.

[Effects of the Invention 1] Since the present invention does not require designing a complicated slip creation program using a programming language, general users can easily create desired slips, and
By simply specifying the input format, it can be made compatible with the input formats of the various forms.

[Brief explanation of the drawing]

Figure 1 is a functional block diagram of this invention, Figure 2 - 1m'g
Fig. 7 shows an embodiment, Fig. 2 is a block circuit diagram showing the basic configuration of the office computer, and Fig. 3 is a diagram showing the contents of registered teeth I, ■, ■ set in advance for creating slips. , W44 is a flowchart for explaining the operation when creating a slip, FIG. 5 is a diagram showing the creation process when creating a slip based on the registered tooth H, and FIG. FIG. 7 is a diagram showing the creation process when creating a slip based on the registered teeth m. FIGS. 8 and 9 are for explaining the conventional example. This is a diagram. 11...CPU, 12...ROM,
13...Key power section, 14...Display section, 15...RAM. 15-1... Registration port memory, 15-2...
...Data creation area, 15-3...-Pattern input flag memory. 16...Table memory, 17...File memory. Figure 1 Figure 2 (I) ([) @ Figure 3 (I[) Figure Figure CB)

Claims (1)

[Scope of Claims] A registration memory that is set and registered in advance to create record data constituting a form file, etc., and stores word types that define each word name of the record to be created and its processing content; A record data processing device that creates record data by reading setting contents set in a registration memory word by word and sequentially executing processing of the contents according to the word type, the word indicating data input. a specifying means for specifying a seed input format; and when executing processing of contents according to the word type, if the word type is a word type indicating data input, the input specified by the specifying means; A record data processing device comprising: a control means for controlling the creation of record data according to a format; and a record data processing device.