JPS63305460A - Document data processing system - Google Patents

Abstract

PURPOSE:To control the execution of data processing of all relating documents by retrieving necessary data processing for all the documents on a document definition data base and automatically executing the data processing in a correct execution order at the time of data entry or data updating of an optional input item in an optional document. CONSTITUTION:When a data processing execution control part 3 in a document processor 11 refers data processing information 7 for a document generating data entry or data revision and a document data 6, and repeats the cycle of the execution of data processing and the detection of reference data processing information, the data processing 7 referring the data into which a data processed result is substituted can be executed without fail. Otherwise, since execution starting information is set up, the automatic execution function of data processing in plural documents in a correct order, a processing start function based upon operator's designation or an incorrect execution preventing function can be obtained.

Description

[Detailed Description of the Invention] [Field of Industrial Application] The present invention relates to a method for processing data between multiple forms,
In particular, the present invention relates to a form data processing method suitable for automatically controlling the execution of all necessary data processing between related forms using only within-form data processing information that is independently defined for each form.

[Conventional technology]

Conventionally, a technique disclosed in Japanese Unexamined Patent Application Publication No. 118872/1983 is known as a technique related to this type of inter-form data processing. This technology aims to reduce the number of data entries between multiple forms, and by defining a form opening calculation formula, data can be automatically entered into other forms by executing the form opening calculation formula based on the entry data for a certain form. This is done in a specific manner.

[Problem that the invention seeks to solve]

However, this method only targets a group of forms in the same predefined group called "- forms", and data processing between forms is defined by an arithmetic expression, so it is simple to use fixed reference and substitution addresses. data transcription,
The problem is that the scope of application is limited to posting aggregated results, and furthermore, there is no consideration given to the processing method when data processing relationships between forms are connected at multiple stages, and data processing is mutually related between forms. was there.

The present invention has been made in view of the above circumstances, and it solves the above-mentioned problems in the conventional form data processing method, and even when the data processing relationship between forms is multi-level and interdependent, it is possible to improve the overall data processing relationship. And all 11 related cases can be triggered by data entry or data change for any form without having any information about the data processing execution order.
! It is an object of the present invention to provide a form data processing method that enables execution control of form data processing in the correct order.

[Means for solving problems]

The object of the present invention is to provide a form data processing device having a display keyboard, a form definition database, and a form processing device, wherein the form definition database comprises:
The form processing device stores form definition information configured for each form, including form data, data processing information, other form reference information, and form format;
It has a form storage control unit, a data processing execution control unit, and an execution control table that stores data processing that refers to other forms, and is capable of controlling any form on the form definition database that is input by the operator through the display keyboard. When data entry or data update is performed for any input item, the data processing that needs to be executed due to the data entry or data update is searched for all the forms in the form definition database, and the contents of the execution control table are searched for. This is achieved by a form data processing method that is characterized by automatically executing the corresponding data processing in the correct execution order based on the following.

[Effect]

In the form data processing method of the present invention, the data processing execution control unit in the form processing device refers to the data processing information and form data of the form in which data entry or data change has occurred, and executes the data processing described in the previous section. By repeating the cycle of detecting reference data processing information and data processing information, the data processing information that refers to the data to which the data processing result has been assigned will always be executed, or the execution start information will be set. It is possible to automatically execute data processing over time in the correct order, or to start processing specified by an operator and prevent unauthorized execution.

〔Example〕

Embodiments of the present invention will be described in detail below with reference to the drawings.

FIG. 2 is a block diagram of a form data processing system showing an embodiment of the present invention. In FIG. 0, 1 is a display/keyboard, 11 is a form processing device, and 4 is a form definition database. The above form processing device! 11 is a form storage control unit 2. Data processing execution control unit 3. It consists of an execution control table 10. The form definition database 4 also includes form data 6, data processing information 7, other form reference information 8. It has a plurality of form definition information 5 consisting of @ form format 9.

Form definition corrections and data entries are input through the display/keyboard 1, and are stored in the form definition database 4 in form definition information 5 in form units by the form storage control section 2. The form definition information 5 includes form data 6 that holds data in the @ form, data processing information 7 that describes data processing that refers to data within the form and other forms. It is composed of other form reference information 8 that describes the relationship of data reference within the form for data processing from other forms, and form format 9. The form data 6, data processing information 7, and form format 9 are used when defining the own form. Other document reference information 8 is stored via the document storage control unit 2.
is stored in the form definition information 5 of the form in which the reference data exists, if reference to other form data occurs during data processing information definition.

The data processing execution control unit 3 controls the execution of necessary data processing based on the contents of the form data 6, data processing information 7, and other form reference information 8, stores the processing results in the form data 6, Next, by sequentially repeating execution control of necessary data processing based on the data reference relationships of the processing results, execution control of data processing of all related forms is performed in the correct order. Further, the execution control table 10 is a control table indicating the execution order of data processing based on the contents of the other document reference information 8, as described later.

The display of each form on the display/keyboard 1 is executed by the form storage control section 2 by performing necessary editing based on the contents of the form data 6 and form format 9.

Next, details of the inter-form data processing execution control method by the data processing execution control section 3 will be explained with reference to FIG. 1(a). When the operator specifies the start of processing for an arbitrary form A via the display/keyboard 1, the data processing execution control section 3 performs the following processing.

(1) The data processing execution control unit 3 searches the data processing information 7 in the @form definition information 5 of the form A, and refers to other form data for which the startup flag has been set. In Fig. 1 (a), data processing ■ corresponds to the data processing form Z and F, and the start flag indicates that data processing It shows. There are two startup flags: data has been updated (with a bar on the form name) and data has not been updated (with no bar on the form name). In the latter case, it indicates that the data of the reference form has not been updated. The processing execution control unit 3 informs the operator that since there is a form whose data has not been updated, starting the processing of form A will result in an incorrect result, and indicates whether the processing of form A has ended or the processing of the form whose data has not been updated has been started. Encourage choice.

If applicable data is available, it will be processed immediately.
Store the processing results in the form data 6 in the form definition information 5,
0th order to clear the startup flag in data processing information 7,
The data processing information 7 is searched again, the data processing referring to the processing result is executed, and the new processing result is stored in the form data 6.

Thereafter, a cycle of searching the data processing information 7 for new processing results and executing reference data processing is executed until there is no more data processing in the data processing information 7 that refers to the processing results.

Through the above processing, the data processing of other documents that refer to the data to which the processing result has been substituted in the document A is searched for using the other document reference information 8, and if any, the reference document name and its data processing blood are matched. is stored as one piece of storage information next to the final storage position pointer 13 in the execution control table 10, and the value of the final storage position pointer 13 is incremented by one. If the same stored information exists at the time of storage, the previously stored information in the execution control table 10 is cleared (step 21).

(2) When a data entry by the operator occurs, search the data processing information 7 above, execute the data processing that refers to the entry data, and save the processing result to the form data 6 in the form definition information 5. Then, similar to the process (1), the cycle of searching the data processing information 7 for the processing result and executing the reference data processing is executed until there is no data processing in the data processing information 7 that references the processing result. .

Next, the search for other form reference information 8 for the data to which the processing result has been substituted in @form A and the storage process in the execution control table 10 are performed in exactly the same manner as in the process (1) (step 22).

(3) After performing data entry processing for form A any number of times, the operator issues a termination command that instructs the end of processing for form A, or an execution command that instructs automatic execution of related forms immediately after the processing is completed. Input (Step 2
3), the following process (step 24) is executed.

(4) Details of the processing contents will be explained according to FIG. 1(b).

(i) Read the stored information from the beginning of the execution control table 10 to the final storage area indicated by the final storage position pointer 13, and if the end command is input in (3), the data in the form corresponding to each stored information A data updated flag for form A is set in processing information 7 (step 31).

(n) Group the stored information read in above (i) into those having the same form name (step 32).

(iii) The following processes (a) to (d) are performed for each glue value (step 33).

(b) Perform a search using the data processing island of the stored information as a key from among the data processing information 7 of the form corresponding to the group,
Obtain the data to which the processing result will be substituted from the applicable data processing information. However, no processing is performed (step 34).

(b) Data processing that refers to the data obtained above,
The data processing information 7 is searched again to obtain data to which the processing results are substituted. No processing is performed.

Thereafter, similar processing is executed until there are no more data processes in the data processing information 7 that refer to the processing results (steps 35 and 34).

(c) Search the other form reference information 8 for the data processing of other forms that refer to the data to which the processing results obtained in (b) above are substituted, and if any exist, use the execution control table 10 in (1). The data processing of other forms is stored in the execution control table 10 in the same manner as in the case of storing the data into the execution control table 10 (step 36).
.

(d) If you input the termination command in (3), (ii)
Regarding the data processing of other forms obtained in i).

The form name corresponding to the group is set as a data non-update activation flag for the corresponding data processing information in the data processing information 7 of the corresponding form (step 38).

(fv) After completing the process (i) for all groups, it is checked whether new storage information has been added to the execution control table 10 (step 40).

(V) If there is no additional storage information, the process ends; if not, the additional storage information is grouped into those with the same form name, and the process in (m) is performed again (step 39).
.

(5) Execute termination processing (storage of necessary information, etc.) for @Vote A (step 25).

Next, when the execution command is input in (3) above,
The following processing is performed (steps 26 and 27).

(6) Check whether or not there is stored information in the execution control table 10. If not, the execution of the data processing execution control unit 3 is ended, and if there is, the following process (7) is performed.

(7) Sequentially execute data processing corresponding to the form name and data processing Nα shown in each piece of storage information from the beginning to the final storage area in the execution control table 10, and store the processing results in the form data 6 of the corresponding form. In addition, the processing result form data 6
Similarly to (1) or (2) above, the cycle of searching the data processing information 7 of the corresponding form for the processing result and executing the reference data processing is performed by searching the data processing information 7 in the data processing information 7 that refers to the processing result. As described above, the process is executed until there is no more data to be processed.

When all of this processing is completed, all related data processing of other forms for the data entry of form A has been executed in the correct order.

Furthermore, when the end command is input in (3), the startup flag is set for all the forms that refer to the data entry of form A or the updated data by data processing, so any of these forms When the operator specifies the start of processing, the necessary data processing is automatically executed according to (1). However, since the operator does not know the correct execution order among forms, there is a possibility that unupdated data of other forms will be referenced when processing the data of a certain form for which processing is specified. If executed, it will not give the correct result, but as mentioned in (1), in this case, the operator is always notified of the name of the form to be processed in advance, so processing with unupdated data is not possible. do not have.

Next, actual processing will be explained based on a specific example of a form.

Figure 3 shows the sales management table (form A) and the inventory management table (form B).
, which shows the mutual benefit of data processing between the purchase ledger (@ Form C) and the revenue management table (Form D).

For example, "product name", "unit price", etc. in form A indicate the data area name below, and ■, ■... are data processing Nα
Further, the data area "Inventory allocation" means that it is transferred to the data area "Output quantity" of Form B by the data processing of Form B.

If the relationship between the above-mentioned forms is expressed as an independent data processing description for each form, it will be as shown in data processing information 7 in FIG. 4. Below, some explanation of the data processing description format used in FIG. 4 will be given.

Data processing for form A means subtracting the inventory allowance from the sales quantity and assigning it to the order summary. It means assigning to the quantity.

The data processing ■ for form B means that if the result of (appropriate inventory amount - remaining quantity) is non-negative, that value is substituted for the replenishment order amount, and if it is negative, O is substituted for the replenishment order amount, and the data processing ■ for form B is as follows: Form A
This means assigning each data for inventory allocation to the row where the product name matches the product name in the issue quantity column of form B using the product name as the key. This means accumulating the value into the total sales amount, that is, substituting the value obtained by adding the total sales amount of form A to the current total sales amount to the total sales amount. In addition to each form, the form reference information 8 is also as shown in FIG.

Hereinafter, based on the data processing information 7 and other document reference information 8 in FIG. 4, the flow of execution from the time when the operator instructs the start of processing of the document A will be explained according to FIG. 1(a). In form A, since there is no process that refers to data in other forms, the process in (1) above is not executed, and the time when all data entries for the data entry section 12 shown with diagonal lines in FIG. 3 are completed. Then, by processing (2) above,
The contents of the execution control table IO are in the state shown in FIG. In addition, in FIG. 5, cleared stored information is shown deleted.

Next, at the end of the above-mentioned process (4), the contents of the execution control table 10 are in the state shown in FIG. 6. Also, processing (
When the end command is input in step 3), the startup flag for data processing information 7 of each form is changed to the fourth one in step (4) above.
The settings are as shown in the figure.

When the execution command is input, in the process (7) above, as shown in Figure 6, the data processing of the form ■ → the data processing of form B ■ → ... → the data processing of the form ■ is automatically performed. Execution is performed to obtain data processing results in the correct order for all related single-order slips for the sales quantity and inventory reservation data entries of slip A.

In addition, if the operator uses the end command to end the processing of form A without automatically executing it, and then instructs to start processing the form, the start flag of data processing ■ shown in Figure 4 will be activated. This occurs because the operator is informed of the necessity of processing form C first, and the update of the total purchase amount of form C by the data entry of form A has not been performed. Preventing incorrect data processing.

Therefore, when the operator instructs to start processing form C, the operator is notified of the necessity of preliminary processing of form B, since the replenishment order amount data has not been updated.

Generally speaking, the sales management table is managed by the person in charge of sales, and the purchase ledger is managed by the person in charge of purchasing.In many cases, the person in charge of management is different for each ledger, but according to the one-line method, each person in charge The person only needs to consider the data processing of the form that he or she manages and the data of other forms that are referenced therein, and there is no need to seriously consider the relationship with other forms in other respects. At least in the above-described embodiment, the system design that determines the processing means based on the overall relationship between documents, which is essential in the conventional method, is unnecessary.

Further, according to one method, only data processing related to change of form data such as data entry is executed, and an improvement in execution processing performance can be expected, for example.

In FIG. 3, the data processing of transferring the data in the unit price field of form A to the unit price field of form C is not executed at the time of data entry described above. On the other hand, if the operator changes the data in the unit price column of form A, the data processing of form C and form is executed by the process shown in Figure 1 (a), and there is no need to process the data of form B. Not executed.

〔Effect of the invention〕

As described above, according to the present invention, in a form data processing device having a display keyboard, a form definition database, and a form processing device, the form definition database stores form data and data processing information set for each form. information, other form reference information, and form format, and the form processing device includes a form storage control unit, a data processing execution control unit, and an execution control table that stores data processing that refers to other forms. and when data entry or data update is performed for any input item of any form on the form definition database inputted by the operator through the display/keyboard, the data entry or data update shall be executed by the data entry or data update. The necessary data processing is searched for all the forms on the form definition database, and the corresponding data processing is automatically executed in the correct execution order based on the contents of the execution control table.
Even when data processing relationships between forms are multi-level and interdependent, data entry or data change for any form can be used as a trigger to create relationships without having any information about the overall data processing relationship or data processing execution order. This has the remarkable effect of realizing a form data processing method that can execute and control the data processing of all forms.

[Brief explanation of the drawing]

FIG. 1(a) is a diagram illustrating details of an inter-form data processing execution control method by a data processing execution control unit which is an embodiment of the present invention, and FIG. 1(b) is a diagram showing the steps of FIG. 1(a). 24
FIG. 2 is a configuration diagram of the form data processing system of the embodiment, FIG. 3 is a diagram showing the forms used in the example and their mutual relationships, and FIG. 4 is a diagram showing the form data processing system used in the example. FIG. 5 is a diagram showing a specific example of data processing information and other document reference information, and FIG. 5 is a diagram showing an intermediate progress state in the embodiment of the execution control table. FIG. 6 is a diagram showing the final state of the execution control table in the embodiment. 1: Display/keyboard, 2: Form storage control unit,
3: data processing execution control unit, 4: form definition database, 5: form definition information, 6: form data, 7: data processing information, 8: other form reference information. 9: Form format, 10: Execution control table, 11
: Form processing device, 12: Data entry section, 13: Final storage position pointer. Figure 2

Claims (1)

[Claims] 1. In a form data processing device having a display keyboard, a form definition database, and a form processing device, the form definition database stores form data, data processing information, etc. set for each form. The form processing device stores form definition information including form reference information and form format, and the form processing device includes a form storage control unit, a data processing execution control unit, and an execution control table that stores data processing that refers to other forms. , when data entry or data update is performed for any input item of any form on the form definition database inputted by the operator through the display/keyboard, the data entry or data update requires execution. A form data processing method, characterized in that data processing is searched for all forms on the form definition database, and the corresponding data processing is automatically executed in the correct execution order based on the contents of the execution control table. 2. Set execution start information for all forms related to data processing that needs to be executed due to data entry or data update, and allow the operator to start processing for any form for which this execution start information has been set. The form data processing method according to claim 1, wherein the data processing is executed if . 3. The form data processing method according to claim 2, wherein a warning is issued to the operator if the operator's designation is to start processing in an incorrect processing order.