JPH0786876B2 - Information processing equipment - Google Patents

Description

The present invention relates to an information processing apparatus having a function of referring and inputting data from a reference document to a reference input document.

(B) Conventional technology In this type of information processing apparatus, a reference search item corresponding to a reference index item is specified in a reference input document for reference input, and a reference input item corresponding to the reference search item is specified. Must be specified.

In this case, in addition to outputting the data of the reference search item that matches the data of the reference index item, if there is no match, it may be necessary to output the data of the reference index item of the approximate value.

For example, in JP-A-59-68041 (G06F3 / 02),
An example of this information processing apparatus is shown.

This example relates to creation of a quotation for a product whose unit price varies depending on the quantity.

In this example, "quantity" of "quote" which is the reference input document
The "commercial price list", which is the reference document, is searched for by the data in the column, and the "unit price" data corresponding to this "quantity" is obtained. Then, this "unit price" data is written in the "unit price" field which is the reference input item of the "estimate".

The "quantity" of the "quote" is a reference search item, and the "quantity" of the "commodity price list" is a reference index item.

In this example, the "quantity" of the "commodity price list" is composed of two "quantity" data defining the range.

In this example, if the "quantity" of the "quote" is within the range specified by the two "quantities" of the "commodity price list", the corresponding "unit price" of the "commodity price list" Is copied in the “Unit price” column of the “Quotation”.

In addition, in this example, the range is specified by providing two pieces of "quantity" data of the "quote", but this is "50" in the "quantity" column.
"Less than""...less""...
-It is also proposed to add "above" and analyze this to define the range.

As described above, conventionally, when a match between the data of the reference search item and the data of the reference index item is searched and the searched data is copied to the search input item, the data of the reference search item and the data of the reference index item are There is a case in which an approximation (less than, less than, greater than or equal to, etc.) is searched and the searched data is copied to the search input item.

In this latter case, it is necessary to make the data of the reference index item two or to add "less than ...""more than ..." To the data of the reference index item.

That is, conventionally, the format of the reference document is different between the case of detecting a match and the case of searching for an approximation (less than, less than, more than, or the like).

(C) Problems to be Solved by the Invention As described above, in the conventional art, the reference document (reference file) is
The format differs depending on the search.

That is, conventionally, the format of the reference document (reference file) has been changed according to the reference input conditions such as match, less than, less than or equal to or more.

In consideration of the above-mentioned drawbacks, the present invention proposes an information processing apparatus that sets reference input conditions such as matching, less than, less than, or more than regardless of the format of a reference document (reference file).

(D) Means for Solving the Problem The present invention compares the item data of the reference search item of the reference input document (input file) with the item data of the reference index item of the reference document (reference file), and compares them. In the information processing apparatus for copying the corresponding data corresponding to the item data of the reference index item to the reference input item of the reference input document (input file) when is within the specified range, the reference input document (input file ) Of the reference search item and the reference index item of the reference document (reference file) are specified, a plurality of searches in which the specified range is set in advance, such as matching, less than, or less than It is characterized by comprising means for selectively setting from a type (search condition).

(E) Operation By specifying the search type when setting the reference index by the above means, it is not necessary to be aware of it when setting the reference input, and the operation is the same as the conventional setting of the reference input. .

(F) Embodiment One embodiment of the present invention will be described below with reference to the drawings. The apparatus of the embodiment switches between a document processing mode that functions as a word processor and a data processing mode that inputs record data in a card display format or the like and does not perform various data processing such as sorting and selection and outputs the processing result in a card format or the like. This is an information processing apparatus that can be provided with the hardware configuration shown in FIGS. 2-1 and 2-2 and the functional block configuration shown in FIG. In FIG. 2A, (1) is a central processing unit (CPU) including a microprocessor, which controls various input / output devices, performs document processing, data processing and the like. (2) is a main memory composed of a dynamic RAM, in which various programs, document files created in the document processing mode and data processing files created in the data processing mode are temporarily stored. (3) is a first auxiliary memory composed of a hard disk connected to the bus (5) through the hard disk I / O interface (4). The hard disk I / O interface (4) includes a hard disk control unit, and a main memory (2) and an auxiliary memory (3) under the control of the DMA controller (6) by a start instruction from the central processing unit (1).
Controls high speed data transfer to and from. Reference numeral (7) is a CRT as a display means, which is connected to the bus (5) via a CRT interface (8). CRT interface (8) is C
Character code generator for displaying the code data for display under the control of the central processing unit, including the circuit that controls the RT screen (9)
Change to a pattern with and open the display buffer memory (10) and display it on the CRT (7).

(11) is a keyboard as an input means for inputting data, text, etc. and selecting various functions, and a keyboard interface including a circuit for a keyboard control circuit (12)
To the bus (5). The keyboard (1
1) is basically the key arrangement of a commercially available word processor. As shown in FIG. 2-2, the arrangement of the essential parts is shown. The function keys (F1) to (F1) change depending on the function mode.
0) and fixed function key (F11) ... The keyboard interface (12) discriminates the pressed key, converts it into a control signal or a data signal, and sends it to the central processing unit (1). The central processing unit receives the control signal and executes various functions.

(13) is a printer such as a laser beam printer, an LED printer, a thermal transfer printer, etc., for sending and receiving print data for printing, for example, 48 × 48 dot matrix characters, a main memory (3) and a print buffer (not shown) of the printer (13).
It is connected to the bus via a printer interface (14) which is connected to the bus. Printing control is performed by the central processing unit (1).

Reference numeral (15) is a second portable auxiliary memory composed of a floppy disk connected to the bus (5) through the floppy disk interface (16), and the document file and the data file created by the apparatus of the embodiment are stored in the first auxiliary memory. It is transferred from (3) and stored, or a document file created by another document file creation device or the like is saved. The floppy disk interface (16) includes a floppy disk controller, and the main memory (2) and the auxiliary memory (15) are under the control of the DMA controller (6) by a start instruction from the central processing unit.
Control high-speed data transfer between.

The functional block diagram of the apparatus of this embodiment having the above-described hardware configuration is shown in FIG. That is, the control means (17) corresponds to various programs indicating the control procedure of the central processing unit stored in the central processing unit (1) and the main memory (2) or the first auxiliary memory (3), and the main storage means (18). ) Corresponds to the main memory (2), the auxiliary storage means (19) corresponds to the hard disk (3) and the interface (4), the floppy disk (15) and the interface (16), and the display means (20) is the CRT.
The input means (21) corresponds to the keyboard (7) and the interface (8), and the keyboard (11) and the interface (12).
The printing means (22) corresponds to the printer (13) and the interface (14), respectively.

The control means (17) forms various buffer memories (M1) ... And tables (T1) on the main storage means (18), and the control means (P2) to (P5) realized by the various programs (software). ), The document file function and the data processing function are executed using the buffer memory and the table. To explain buffers and tables,
(M1) is a text memory that stores text created in the document processing mode and image data (text data) of the card created in the data processing mode, and (T1) is the number of pages for managing the text data in the text memory (M1). , A text management table that stores the number of lines, pages being accessed, line numbers, etc., (M2) is a record memory that stores multiple records consisting of multiple items (fields) input in data processing mode, (T2) Is a record management table that manages the number of records for managing records in the record memory (M2), the number of items, the record being accessed and the item number, and (T3) manages the items to which data is input in the data processing mode. The item management table (M3) that stores the data for FA and various registers,
(M4) is a program memory that stores various programs,
(T4) is a directory table in which data necessary for reading and writing the document file and the data processing file on the first auxiliary memory (3) and various programs is recorded.

Further, (M5) is a memory for storing a reference index, (T5) is a reference index management table for storing management data for reading and writing the index, and (T6) is a reference input management table for storing reference input conditions.

The control means will be described. (P1) is a main control means that fulfills the basic function of the control means.
2), file management means (P3), document processing means (P4),
It manages and controls the data processing means (P5).

The input control means (P2) controls the input means (21), the display means (20) and the printing means (22), and these (21)
Control data is exchanged between (20) and (22) and the main storage means (18), and character data is transferred between these (21) (20) (22) and the main storage means (18). Transfer.

The file management means (P3) uses the data in the directory table (T4) to access various files (document files, data files, dictionary files, font files, program files) recorded in the auxiliary storage unit (19). And manage files logically. In the directory table (T4), the data necessary for displaying on the document selection screen, the position information of the files configured for the document on the second auxiliary memory, the configuration file number information, and the usage status flag of each table are stored. Contains.

The document processing means (P4) executes the function of a Japanese word processor, and a kana-kanji conversion function for converting characters input from the input means (21) into kanji-kana mixed sentences, various document editing functions, and this editing In order to facilitate the work, the document creating means (P41) having a document display function for displaying the document being created on the display section, the edited document printing means (2
It consists of function control means such as document printing means (P42) for printing in 2).

The data processing means (P5) is a card creating means (P51), a document creating means (P52), a record creating means (P53), a display format managing means section (P54), a record processing means (P55), a condition registering means (P56). , Reference index creation means (P58), etc.
The document creating means (P52) has the same function as the document creating means (P41), and the card creating means (P51) creates a card image (card format) as shown in FIG. 5-6 when creating a new card. The function to create using the function of the means (P52) and the function to set the definition data in the item management table (T3) by defining the item name, type, etc. for the item (field) to which data is input . The card image and management data are stored in the text memory (M1) and the text management table (T1), respectively. Then, by the document creating means (P52) having an access line pointer and an access column pointer indicating a line (R) / writable (W) readable / writable to the text memory (M1), the pointer and the text management table (T1) R / W of the text memory (M1) is performed using the information of. The card creating means (P51) also has a function of displaying the card of the created data file when the new card is not created. The record creating means (P53) displays the input data from the keyboard (11) in the item input area (definition range) of the card created by the card creating means (P51) and stores it in the record memory (M2). , A write (W) function that stores data for managing records in the record management table (T2), and a specified record in the record memory (M
It has a read (R) function that reads from 2) and combines it with a card image for display. The record creating means (P53) has an access pointer for designating a record that can be read / written. The display format management means (P54) records 1
It has a function of switching between displaying in a single-card format (see, for example, FIG. 5-7) or in a list format (not shown) in which a plurality of records are collected.

The record processing means (P55) has various record processing (data processing) functions such as record selection and sorting. For example, in the case of a select process, a record that does not meet the select specification condition is excluded from the process target. At the same time, when the selection is released, all records are returned to the processing target.

The condition registration means (P56) refers to the entry processing function for changing the type of the process definition described later, the process definition function for changing the type of the process definition set in the entry process, and the reference index in association with each other. It includes a reference search function such as specifying a search item and a reference input defining function such as specifying a reference input item.

The reference index creating means (P57) has a function of creating an index from a reference document using a reference index item as a search key.

The function control means (P1) of the control means (17) have been described above. However, it is said that they do not exist so that they can be extracted and separated by hardware, but that they exist by software and functionality. As described above, for example, it is realized by the flow chart shown in FIG. 3 and FIG. 4 (an outline of the processing procedure performed by the central processing unit is shown). Each function control means (P1) ... Can be replaced with a logic circuit as needed.

Next, the basic operation and function of the apparatus of this embodiment will be mainly described with reference to FIGS.
A description will be given according to the flow chart of the control means (17) shown in FIG. 4 and the display screen of FIG.

[A] Device startup and document selection First, when the device is powered on, a document creation program is loaded and an initial screen is displayed on the display means (20). On this screen, the files already created under the new creation field and stored in the auxiliary storage means (19) are displayed. Then, although not shown, function keys corresponding to the function keys (F1) to (F10) at the top of the keyboard (11) are displayed at the bottom of the screen. For example, F1 corresponds to editing (document creation) and F6 corresponds to data processing.

[B] Activation of data processing mode As described above, when the apparatus is activated, an initial screen for new creation and selection of an existing document is displayed. In this state, the cursor (CI) is moved to select the document based on step S1 in FIG. When the function key (F6) for selecting data processing from the menu item at the bottom of the display screen is pressed, the data processing mode is entered in step S2. Step
When a new creation is judged in S3 and the document name, date, etc. are entered and the execute key (SW1) is pressed, the previously created document creation program is invalidated and the data processing program is loaded instead. . As a result, the data processing mode is activated, and the process proceeds to the card creation routine after step S5.

[C] Card Creation In step S5, the screen becomes a screen corresponding to one blank page in the document creation mode, and the cursor can be freely moved within one blank page by inputting characters from the input means (21) and drawing a key line. A free input screen can be designed by the same operation as in the document creation mode using the function of the document creation means (P52). At the bottom of the display screen, as shown in FIG. 5-2, function keys for designating the data type (character or numerical value) of the item to be input are displayed. Now, the 5-1st
The design of the address book card in the format shown in FIG. 5-6 consisting of the five items of name, address, telephone, age, and date of birth will be described in accordance with FIG.

Fig. 5-1 shows a card consisting of item names such as "name", "address", "telephone", etc. by the function of the document creating means (P52) by setting the cursor to full-width and inputting the kana key or key line key. While the image is created, the record position creation means (P53) completes the item position definition of “name” and “address”, and shows the middle of the item position definition of “telephone”. The item definition will be explained by taking this "telephone" item as an example. First, for example, position the cursor (C1) at the item definition start position of the "telephone" item, and press the card function: character function key (F1). . Next, when the cursor key (SW2) is used to move the cursor, the character data input range (R) is indicated by the length of the cursor as shown in the “Telephone” item column in FIG. The input (definition) range is 30 characters (calculated with half-width characters) such as "Character item position definition: Number of half-width characters, 30 characters". In this case, the cursor size is set to full-width, indicating that it is 15 full-width characters. To do.

If the item position definition for the telephone, that is, the data input range and the number of characters indicated by the cursor are all right, press the execution key (SW1) to set the cursor size in the cursor size register and set as shown in Fig. 5-2. The range (R) has a bright line (Z) and changes to the character "X" of the size set in the cursor register.

In this state, 15 characters of "X" indicating that it is character data are displayed and a bright line (Z) is added under each "X", but how to hold the data in the text memory (M1) is "X". Character code data consisting of 3 words (16 bits / 1 word, attribute part such as character size, JIS code part, and extension word including brightness bit and character modification information is 1 word each) Of these, the luminance bit (1 bit) is set to "1". If the bit is "1", the bright line (Z) is added to the character at the time of display, and if "0", the bright line (Z) is erased.
Thus, the item position definition for the item name "telephone" is provisionally registered.

Next, operate the cursor key (SW2) to move the cursor to a predetermined position, create card image parts of "age" and "age" using the function of the document creating means, and then define the "age" item. After locating the cursor (C2) at the start position and selecting the card definition: Numerical function key (F2), the provisional definition of the numerical item is executed in the same way as the definition of the character item. The difference from the above definition of the character item is that the displayed character is "N" indicating that it is a numerical item, instead of "X" indicating that it is a character item (Fig. 5-2).

Next, the designation of date and time items will be described. As shown in Fig. 5-3, move the cursor next to the date of birth and enter the actual data of the desired date and time. Then move the cursor to the start position of that value and select the function key (F3) of "Card definition: Date and time". Since the cursor position is highlighted in black, the date and time data is highlighted and the execute key is pressed (Chapter 5-4).
Figure). The control unit automatically recognizes a date and time pattern prepared in advance from the Kanji portion of the inversion area. Then replace the number part with English letters that represent each type. Then, the reversed character string is removed from the reversed character string, a bright line (Z) is added, and the character string is written into the text memory and displayed again (FIG. 5-5).

When the end key (F11) of the input means (21) is pressed in this way and the end key (F11) of the input means (21) is pressed, two long left and right function keys are displayed at the bottom of the screen, and the left half (F1) to When any one of (F5) is pressed, it is determined in step S6 in FIG. 4 that the card design is completed, and the process proceeds to the item management table setting routine in step S7. Here, definition information about each item is set in the item management table (T3) as shown in FIG.

The outline of the routine of this item management table set is as follows. That is, the text memory (M11) has the 5th-5th
The text data as shown in the figure is stored (tentative definition), and processing is performed line by line from the first line to the last line of the card and from the leftmost digit to the rightmost digit. In this process, first, when a bright lined character is found, a continuous line of bright lined characters is regarded as one item, and a number is automatically assigned. And for each item, item name, character size, position information (item start line,
Column and end row and column) Data length and table specification information (information of row repeat or column repeat if inside or outside specified table)
Etc. are stored in the item management table (T3). The item name is read and set by looking to the left or above the item definition position, or is automatically set as a character item 1, ..., A numerical item 1. The character size, position information, and data length are set by reading the characters with bright lines. If no item is defined in step S7, a table set error is determined in step S8, and if there is no error, the process proceeds to step S9. When it is determined that there is an error in step S8, the process returns to step S5.
If any of the function keys (F6) to (F10) is pressed in step S6, the card definition is stopped and the process returns to step S1.

[D] Record Creation At step S9, only the bright line characters "X" and "N" are erased on the display screen of FIG. 5-5, and at step S10 a blank card is displayed with only the item name (FIG. 5-6). In step S11, the cursor (C1) is positioned at the beginning of the first input item area. When entering data, the cursor (C1) cannot move due to the item area (area with X or N) set in the card design,
The cursor size is also automatically changed and set to the defined character size. In addition, in the character item, you can enter free kanji, kana, numbers, etc. by converting kana to kanji.
Although it is stored as a bit JIS code, only numeric keys of the input means (1) can be accepted for numeric items, and only numeric strings can be entered. The input data is a 4-bit code system that differs from the 16-bit JIS code. It is stored in BCD code.

When the input of each item is completed in step S13, the display screen as shown in FIG. 5-7 appears and the next page key (F1 of the input means (21) (F1
When 2) is pressed, the screen is changed to a new blank card based on step S14 as shown in Fig. 5-6, the second card is displayed, and the process returns to steps S11 and S12 to display the second card. Item data is entered in card format. In this way steps S12-S13-S12-S14-S12-S13
By circulating the loop of, the card-type address book data of one leaf per case is created at an arbitrary number (number), for example, 12 cases.

When the display switching key (F13) is pressed in step S12, the process moves to the flow of FIG. 4 and the table format management means (P54) automatically switches from the card format screen so far to the list display (not shown) (step S21). ) Next, in the list display, entry or correction of item data is accepted in step S18.

When the next page key (F12) is pressed in step S19, a blank field (not shown) is automatically added and displayed at the end of the field in step S20. New creation of new record (card) is executed.

[E] Record Processing Next, returning to FIG. 3, select processing will be described as an example of record processing in a data processing file consisting of 12 records that have been input. In step S12,
When the select key (F15) is pressed, the screen changes to that shown in FIG. 5-8 and the process proceeds to step S15 for accepting the select condition. Then, the condition input lower surface is displayed at the bottom of the card display screen, and "Osaka *" is input by word processing from the input means (21) to search for a record whose address is Osaka in the condition input field. “*” Is a prefix match operator that indicates what the letters after Osaka are. When the input of conditions is completed, the execution key (SW1) is pressed to proceed to step S15, and the selection processing by the selection processing means (14) is executed.

Then, by pressing the end key (F11) in S12, the screen for the document name etc. is displayed, and in step S15 the document name, author name,
The date is displayed in the window. If the displayed contents are good, press the execution key (SW1), and after inputting items such as the document name and date you want to correct them (step S17),
By pressing the execution key (SW1), the data processing file of "address book" is closed, and the process returns to step S1. In addition to such selection, as data processing, sorting and other conditional expression search using logical operators such as AND and OR are also possible. For example, it is a search based on a conditional expression [address = Osaka *] AND [age> 30 years].

[F] Structure of data processing file One data processing file created in this way is
The card image of the "address book" is stored in the text memory (M1) line by line as a series of character data, and multiple record data (each record consists of multiple item data)
Are stored in the record memory (5) in the order of items as shown in FIG. Information on where each item of the record is embedded in the card image and other definition information are stored in the item management table (6) as shown in FIG.

[G] Detailed explanation of the embodiment using different types of cards In the device of this embodiment, basic item management data such as item names and model types are defined by the card creating means (P51), and are stored in the item management table (T3). Although it is set, management data regarding reference input can be further defined by the condition registration means (P56). The input file shown in FIG.
According to the example of reference input from the master file shown in the figure,
Describe the reference input.

(1) Outline explanation of reference input in the embodiment When performing data processing using a plurality of files, refer to data from a master file (reference document), input this, and copy it to a file (input document) (reference input) ). For example, if you enter the monthly remuneration and then the insurance premium etc. corresponding to the monthly remuneration, if you enter the insurance premium each time, the number of inputs will increase and the original data will be the same, but due to an input error There is a problem that accurate input cannot be performed.

Reference input solves this problem. This will be described with reference to the operation flow chart shown in FIG. 8. In the master file, an index is created with key items (for example, monthly reward) (step S80). On the other hand, the reference condition is set (defined) in the input file, that is, the master file to be referenced is designated (step S81), the reference index is designated (step S82), and the reference search item is associated with the reference index. Designate (step S83) and designate the input item to input the data obtained corresponding to the reference search item (step S8)
4) Keep it. After that, when data is input in the reference search item (step S85), a search is performed based on the reference index in the designated master file (reference document) (step S86),
Reference input can be performed by reading the input item based on the record number in the reference index (step S87) and writing the read input item data into the input item of the reference document (step S88). By such reference input, data input can be reduced and accurate data input can be performed.

However, this cannot output the data that matches the reference index. Therefore, in this embodiment, by setting the search type in the reference index, not only the data matching the reference index but also the data corresponding to the approximate value can be output (reference input with range).

An image exemplifying this reference input with range is
It is FIG. (30) is a reference input document, and there are five data input items, but if the income amount is decided, health insurance-total amount, health insurance-burden, welfare-total amount, welfare-burden is uniquely determined, and reference input data Input is possible. For this reason, the five item fields containing the data of each insurance premium corresponding to the upper limit of the monthly remuneration equivalent to the income amount are regarded as one record, and the reference document (31) consisting of many records is used as the card creating means (P51). The reference index (32) having the monthly salary as a reference index item (search key) is created with a search type of “less than (<)” and stored in the index memory (M5). As shown in Fig. 10, the reference index is created for all records of the reference document with a pair of information (record number) of the record having the upper limit of the monthly remuneration and the upper limit of the monthly remuneration. It is configured so that the record number corresponding to the search type can be read. Further, not only one reference index item but also a plurality of reference index items can be set. In this case, an index corresponding to each index item is formed, and each index memory is created by the reference index management table (T5) as shown in FIG. Read / write from / to is controlled. The management table records the reference index item number, the reference index search type, the reference index file address, and the file length.

(2) Detailed description of embodiment Next, the reference input function with range will be described in detail with reference to FIGS. 12-1 to 12-10 and 15-1 to 15-18.

(C) Creation of reference index The process of forming a reference index as shown in FIG. 10 as a preparation process for performing reference search and input processing will be described with reference to the flowchart of FIG. 13 and the display screens of FIGS. 12-1 to 12-10. To do.

Fig.12-3 shows that the card format reference document (data file) shown in Fig.12-1 has already been created.
12 shows a state in which the registration key is pressed in step S12 of FIG. 3 after the reference document in the card format shown in FIG. 1 is opened. It should be noted that this reference document has a large number of records including the monthly remuneration item and each insurance premium item as shown in the list in FIG. 12-2. (In the figure, the size of the monthly remuneration data is arranged in order, but they do not have to be arranged.) If you press the function key (F4) and select the reference key, the reference index creation flow in Figure 13 will be processed. Shift (step S23). Then, the screen becomes as shown in Fig. 12-4, the 1/4 window is displayed at the lower right, and the cursor (C1) is moved in step S90, and new or registered (if registered, registered reference under New is registered reference index). Items are displayed, but in this case there is no registered one) (S9
2). In this case, press the function key F1 to select "Reference key: Create reference key" by positioning it above the new one.
Then, in step S93, a new card is determined and the card is displayed in the upper 1/2 window (Fig. 12-5). In this window, move the cursor (C1) to the item you want to use as the reference index item (key item), press the Enter key (S94), and the reference index item specified in the message line (ML). The search type is displayed as "match (=)" (by default) along with the name (Fig. 12-6). Then, with the conversion key, the search type is converted in the order of match (=) → less than (<) → below (≦) → match (=) (12th, 7th, 8th, 8th, and 8th).
(Fig. 9). This means that when inputting a reference, the match (=) returns the record number of the reference search item and the reference index item that match, and the less than (<) is the minimum value among the reference index items that is larger than the data of the reference search item. Returns the record number of the data, and the following (≦) returns the record number of the minimum value data in the reference index items that are equal to or larger than the reference search item data. In this way, the search type is determined (S95), and when the enter key is pressed, the reference index as shown in Fig. 10 is automatically formed (S96), and the screen changes to Fig. 12-8 and the search type is less than The operator is informed that the index has been created and registered, and the process returns to step S90. In S60, the reference document cards are sorted in ascending order of reference index items and the reference index as shown in FIG. 10 is formed based on this, but it is not necessary to have the amount data of monthly remuneration in FIG. That is, it is possible to search for a required record by having a record number string sorted in ascending order of monthly reward or a code address. The automatic index generation step S96 may be executed when the reference document is opened and the ending process is performed in S17. In this case, the index is automatically recreated when the reference document is recreated, which is convenient, but the index creation becomes slow, and high-speed search using the index cannot be performed.
In this respect, this is possible in the embodiment shown in FIG.

When the cancel key is pressed in step S90 to exit the reference index creation processing, this is determined in step S91, and the processing ends. When registered is selected in step S93, a reference index is formed again in step S96. This is effective in rebuilding the index when a record of the reference document is added or the content of the record is changed. It should be noted that, by displaying the date of creation on the screen of Fig. 12-8 in the place such as horizontally next to the item of the reference index, the operator can be informed of the newness of the index, or the record addition / correction is detected and the index is also updated. It is desirable to update the index automatically. Step S9 again
4, When the cursor is positioned on the registered item name in Fig. 12-8 and Delete (function key F2) is selected, the index is deleted.

(D) Condition registration process The definition information obtained by the item definition and set in the item management table is the minimum management information required for writing and reading records in card format. Various item definitions can be added to the output for various conveniences, and definition information of these items can be set in the item management table. This is realized by the condition registration process described below.

Figure 15-1 shows a blank card of a created reference input document. When the function key F1 is pressed to select the condition registration on the screen of FIG. 15-2, the step of FIG.
The process moves to S24, and the condition registration process whose details are shown in FIG. 14 is performed.

That is, the screen is divided into upper and lower parts in step S100 of FIG.
The card image is displayed on the upper side in step S101, and the item condition definition table (37) is displayed on the lower side in step S102 (FIG. 15-3).

The condition registration in which the item of income amount is used as a reference search item and each insurance premium is used as a reference input item will be described with reference to the flowcharts of FIGS. 14 and 16 to 17.

Reference search item specification In step S106, move the cursor (C
Item name for which you want to specify 1) as a reference search item: In the line of income amount and when it is moved to the column of key specification (reference key), it is displayed in the message line as master, master, master (15th) -4) (S124). this is,
Since up to three master files can be registered, the master will be described as an example here. When the function key F1 is pressed (S130), the pressing of the function key F1 is detected in step S131, and the selected master number 1 is saved in the buffer (S132). And step
In S133, the cabinet selection screen is displayed in the lower right 1/4 window (Fig. 15-5), and when the cabinet containing the reference document is selected, the screen displays the document selection screen in the selected cabinet in the lower right 1/4. It will be displayed in the window (Fig. 15-6), and the reference document is selected in step S134.
It should be noted that the file storage structure has a plurality of cabinets in the upper level, and a plurality of files exist in each cabinet. Selection is performed by moving the cursor and pressing the execution key.

The reference document is opened by selecting the reference document, and the reference index specification screen is displayed in the window in the lower right 1/4 of the screen (first
(Fig. 5-7), the item name for which the reference index has already been formed is displayed, so press the execute key with the cursor C1 on the reward monthly amount in order to specify the reference index whose key is the reward monthly amount. Then, in step S136, the reference condition is displayed in the lower window of the screen 1/2 (Fig. 15-8). The reference condition is information regarding a reference document indicating which document is in which cabinet and which document is obtained (obtained in S133 and S134) and information regarding an index name of the reference document with respect to the reference search item (information regarding the reference search item) (S135). It can be obtained at). At this time, the search type of the key item may be displayed together.

If you decide that this condition is acceptable, press the Enter key, but if you want to return to the registration, press the Function key (F1) or the Enter key, and if you want to delete the displayed reference condition, press the Function key (F2). This is determined in step S137, and in the case of the F1 key or the execution key, the reference condition is registered in the reference input management table (T6) of the saved master (S138), and the process proceeds to step S139. If it is the F2 key, the condition is deleted and the process returns to S130. In step S139, the registration screen shown in Fig. 15-9 is displayed. On this screen, both the reference document name and the reference index item name are partially displayed to notify that the reference condition is set in the reference key field of the income amount item. The reference input management table (T6) has information as shown in FIG. 19, and refers to the reference search item number (a), the reference input item number (b) related to this, and each reference input item. It includes information on the reference read item (C1) read in the document and the reference input item number (C2) in the reference input document. This table is created for each master.

Specification of reference input item Although the item data of the reference document can be referred to by reference search, it is necessary to specify which item data of which reference document is to be written to which item of the reference input document.

This designation is executed by the entry process and process definition in FIG. That is, when the cursor (C1) is moved to the entry processing field of "health insurance-total amount" in FIG.
The process enters the entry process according to the determination in S104. Here, the key input is accepted in step S112, and in step S113 it is determined whether the key is a conversion key, the previous state is stored, and the processing flow is changed every time the key is pressed. That is, the initial value of the entry processing set is "No" (blank), and the processing is changed from step S114 → S115 → S116 → S117 every time the conversion key is pressed, and the entry processing field is displayed as "reference input" (see 15
-10, S116), then use the cursor keys to move the cursor (C
1) Move the cursor to the process definition field and execute the reference input definition routine whose details are shown in FIG. If the entry process is "Automatic calculation", the operation formula is defined in the process definition (S125).
However, if "selection input" is selected, the selection input definition (S126) is executed.

That is, when the reference input is determined in step S120, the reference input operation guide is displayed at the bottom of the screen in step S140 of FIG. 19 (FIGS. 15-11). Here, as in the case of setting the reference key, "master, master, master" is displayed in the message line. The master will be described here.
When the function key F1 is pressed (S142), the master is saved in the buffer (S143). Then, the process proceeds to step S145, the card of the reference document is displayed on the upper half of the screen, and the cursor (C1) is moved to the card side (15th position).
(Fig. 12). If you move the cursor (C1) to the item of data you want to input by reference (in this case, the total amount of health insurance) and press the execute key, the process moves to step S146 and the reference condition is displayed in the lower 1/2 window of the screen (15th). (Fig. 14). This condition is
In addition to the information about the reference document and the information about the reference search item, the information about the reference input item,
That is, here, the reference input item "health insurance-total amount" includes information that the data item of the reference document referred to is "all health insurance". At this time, the search type of the key item may be displayed. If the execute key is pressed here, the setting conditions are registered in the reference input management table of the saved master (S148). The results are displayed in the process definition column as shown in Figure 15-15. This display is a summary of the reference conditions in FIG. 15-14, and the display is performed in the order of reference document name: item name of reference document to be read and written: reference search item name and reference index name.

When the operator looks at the condition definition table regarding the reference search item and the reference input item and determines that this is enough, the operator presses the end key in step S103 of FIG. Incidentally, in FIG. 19, (a) of the reference input management table is the item number of the income amount,
(B) is each insurance premium (health-total, health-burden, welfare-total, welfare-burden) 4, (C1) is the item number of each insurance amount of the reference document, (C2) is the reference input document Is the item number of each insurance amount. When the end key is operated, the screen returns to the card screen shown in Fig. 15-1 and the condition registration process ends.

(E) Input of reference data Here, move the cursor key to the item for data input. In this case, move the cursor (C1) to the item of income amount for reference input, and input data (S16 in Fig. 18).
0, Fig. 15-17). After that, when the enter key is pressed (S161), it is checked in step S162 whether or not there is a reference input item corresponding to the reference search item, by referring to the reference input management table, and if there is, the process proceeds to step S163, and the reference index " 148,00
Search for "0". In this case, since the search type of the reference index item is less than (<), the data with the smallest value among those greater than 148,000 is searched for, and if found, the process proceeds from step S164 to step S165 to read the corresponding record number,
The data of each insurance premium is read from this record. After that, the data read out in step S166 is written and displayed in each insurance premium item which is an input item (Fig. 15-18).

It should be noted that the present invention is not limited to the above-mentioned embodiment, and it is possible to specify>, ≧ as a search type, or to search for a record having a closer value to two adjacent reference index item values. is there.

(G) Effect According to the present invention configured as described above, it is possible to provide an information processing apparatus in which the reference input condition setting operation is easy.

[Brief description of drawings]

The drawings all illustrate embodiments of the present invention.
FIG. 2 is a functional block configuration diagram, FIG. 2-1 is a hardware block configuration diagram, FIG. 2-2 is a main part plan view, FIG. 3 is an overall flowchart, and FIG. 4 is a display switching flowchart.
FIGS. 5-1 to 5-8 are schematic diagrams of display screens for each state, FIG. 6 is a schematic diagram showing a storage state of record data in the record memory, and FIG. 7 is a schematic diagram of an item management table. , FIG. 8 is a flowchart of the overall structure of reference input, FIG. 9 is an explanatory view of reference input, FIG. 10 is a schematic view of reference index,
Fig. 11 is a schematic diagram of the reference index item management table, Fig. 12-1
Fig. ~ Fig. 12-10 are schematic views of the display screen in each state on the reference document card, Fig. 13 is a flow chart of reference index creation, Fig. 14 is a condition registration flow chart, and Fig. 15-1 ~.
FIGS. 15-18 are schematic views of display screens for each state in the reference input document card, FIG. 16 is a flowchart for specifying reference index items, FIG. 17 is a flowchart for specifying reference input items,
FIG. 18 is a flow chart for inputting item data, and FIG. 19 is a schematic diagram of a reference input management table. (20) ... Display means, (T3) ... Item management table, (C2)
… Cursors, (F1) to (F18)… Function keys,
(SW1) ... Execute key, (SW2) ... Cursor key, (P51)
… Card creation means, (P52)… Document creation means, (P53)…
Record creation means (P56) ... Condition registration means (P57) ...
Index creation means

 ─────────────────────────────────────────────────── ─── Continuation of front page (72) Inventor Tsurumi Ito 2-18 Keihan Hondori, Moriguchi City, Osaka Prefecture Sanyo Electric Co., Ltd. (72) Inventor Hiroyuki Honda 2-18 Keihan Hondori, Moriguchi City, Osaka Sanyo Electric Co., Ltd. Within the corporation

Claims (1)

[Claims] 1. Item data of a reference search item of an input file is compared with item data of a reference index item of a reference file, and when the comparison result is within a prescribed range, the item data of this reference index item In the information processing apparatus for copying the corresponding data corresponding to the reference input item of the input file, at the time of setting the reference index for specifying the reference search item of the input file and the reference index item of the reference file, the specified range An information processing apparatus comprising: means for selectively setting a plurality of search conditions that are preliminarily set such as match, less than, and less than.