JPS61267870A - Form production processing system - Google Patents

Abstract

PURPOSE:To attain the easy output of a general-purpose form by filing a program corresponding to a fixed type pattern and the report definition related with each other. CONSTITUTION:A program executing means PGM loaded from a program file PGF delivers a form TBL with a report definition file RDF, an output form menu file TMF, a data base DBS and a picture parameter defined as inputs respectively. The files RDF and TMF are produced with the form style definition phase. While the file PGF stores previously programs with the program identification numbers defined as keys for each fixed type pattern to perform parameter input processing and retrieving, editing and plotting jobs of the data base DBS. Thus the form style can be changed just with the change of the report definition.

Description

DETAILED DESCRIPTION OF THE INVENTION (Field of Industrial Application) The present invention relates to a method for creating a ledger, and more particularly, to a work stage projector connected to a host comviator, which is equipped with input operation, screen display, and ledger output means. Concerning the book preparation processing method by. More specifically, the present invention relates to a processing method for creating a ledger whose content is data extracted from a database whose dimensions are item, time, and area units. The territorial unit is the range covered by items such as entry, budget, sales, deposits, tax revenue, etc., and refers to prefectures, districts, towns, branches, sales offices, etc.

(Prior Art) Conventionally, this type of accounting book creation processing method has a program file in which a program including all procedures related to accounting book creation processing is stored in advance for each accounting sheet, and a list of these programs is stored in advance. When a predetermined program is selected from among the program menu files displayed on the CRT display of the work stage operator using the keyboard,
the program is loaded from a program file;
When you enter the relevant data on the keyboard according to the screen guidance provided by this program, the program searches the database, edits and tabulates the data obtained through the search, and outputs the specified ledger to a simple printer. There is.

(Problems to be Solved by the Invention) In such conventional methods, programs are created in seconds to correspond to ledgers, and are generally COBOL.
The first problem is that since it is expressed in a language such as RBC (RPC) or the like, compilation and linking are required, and flexible operation by partially changing the program is not possible.

In addition, since programming is required, there is a second problem in that it goes against the trend of the era of end-user orientation.

In addition, there are conventional examples in which the procedure for creating a ledger is written in a simple language to achieve non-programming and non-compilation, but even in such examples, it is necessary to be aware of the structure of the database, and it is necessary to It is limited to a standardized tabulation function based on some processing, and there is no tabulation function that dynamically combines each element of the database.

(Means for Solving the Problems) The method of the present invention is a method for creating a ledger using a work stage connected to a host combination, which is equipped with input operation, screen display, and ledger output means. , a database whose dimensions are item, time, and area units; a program identification number corresponding to the surface plate pattern determined by the combination of the dimensions that correspond to the rows and columns of the ledger; the number of digits of the data in the ledger; and the number of data items. Create an output ledger menu file and a report definition file based on the ledger pattern menu file in which is stored in advance, and the parameters and report definition data inputted by the input operation means for each fixed pattern displayed on the screen display means. report definition registration program, parameter input processing, database search and editing,
A program for each standard pattern for tabulation is associated with a program identification number and a pre-stored program file is provided, and when determining the report format, the report is defined by connecting the report pattern menu file to the host combiator. Load the registration program and output the ledger menu file showing the correspondence between the ledger name, ledger identification number, and program job number, and the data name of the dimension corresponding to the row and column of the ledger in correspondence with the ledger identification number. , create a report definition file that defines a report definition consisting of operators and editing codes for the data name Ilc, and when outputting the ledger, send the output ledger many files, program 7 isle, report to the host combiator. Simply by connecting the definition file and the database and selecting the accounting form base from the output accounting menu file displayed on the screen display means and inputting parameters for the fixed pattern using the input operation means, the program will run and the accounting will start. The present invention is characterized in that the table output means can output a desired account table.

(Example) Next, an example of the present invention will be described in detail with reference to the drawings.

1 and 2 are block diagrams of one embodiment of the present invention, and FIG. 4 is a diagram explaining the hardware environment of this embodiment.

Referring to FIG. 4, this hardware environment includes a host combiator HCP, nine N (N≧1) 07-1xf-shiwyWsi-WSNs each having a keyboard, a CRT display, and a printer, and items and time. and DBS, a three-dimensional database that stores data by associating area units with any of the X, Y, and 2 axes.
, ledger pattern menu file PMF, program file PGF, and output ledger menu file TMF
and a report definition file RDF.

As shown in Figure 1, the ledger pattern menu file PMF includes CLM indicating either the item, time or area unit that should correspond to the row of the ledger, the item, time or area that should correspond to the column of the ledger. A comment that specifies the ROW indicating one of the units and the number of digits of data in the ledger sheet) CO
Standard patterns (at least six) determined by combinations of M are stored in advance together with program identification numbers PID.

#! Figure 1 shows the configuration when determining the book form in this embodiment, in which the report definition registration means RDP, which inputs the book form pattern menu file PMF, screen parameters, and report definition, outputs the form form menu file TMF.
and report definition file RDF are output. Definition of such a book form and output of a book form to be described later can be performed at any work stage WSX of the work stages WSI and WSN.

First, by the action of a file reading program (not shown), a list method containing the row correspondence dimension CLN, column correspondence dimension ROW, and comment COM of the ledger pattern menu file PMF is displayed in the work stage ten WSX.
displayed on the CRT display. When the operator selects one standard pattern from among the menu items of the standard patterns by operating the keyboard, the corresponding program identification number of the ledger pattern menu file PMF is read, and the report definition registration program is loaded.

The report definition registration means RDP first displays a screen on the CRT display that guides the input of screen parameters, so when the operator inputs the report base TNA and the report identification number TID on the keyboard, the report definition registration means The screen switches to a screen that guides input. In the report definition, specify the data name specifically for the row-corresponding dimension CLN of the fixed pattern selected by Menier first, and at the same time specify the operator and edit code (number of digits after the decimal point, etc.) for the data name as necessary. This is to establish the following. FIG. 3A shows a specific example of a report definition for a ledger as shown in FIG. 3B. It is noteworthy that report definition can be performed independently of the data arrangement on the database DBS in this way.

N Program 1 special number, name TNA, @ special number TI
Based on D and the report definition, each code of the report definition file RL)F and the output song menu 7 isle TMF is output. The report definition file stores the above report definition using the ledger identification number as a key, and the output ledger menu file TMF contains the ledger base TNA, the ledger identification number TID, and the program identification number TID. It stores the correspondence with the program identification number PID.

By repeating the above-described operations and processing for the number of desired book form formats, that many book form records can be stored in the report definition file RDF and the output book form menu file TMF.

Next, operations and processing when outputting a ledger will be explained.

Figure 2 shows the configuration at this time, with the report definition file RDF, the output book display file TMF1, the database DBS, and the screen parameters as input, and the execution means PGM of the program loaded from the program file PGF. Output. The report definition file RDF and the output book form menu file TMF were created using the book form definition 7 aids explained earlier.
Further, in the program file PGF, a program for each fixed pattern for performing parameter input processing, searching, editing, and tabulation of the database DBS is stored in advance using the program identification number PID as a key.

First, when a book-table name is selected from the output book-table many-file TMF by the action of the file reading program, the book-table identification number TID and program identification number PID corresponding to this book-table name are read.

Next, a predetermined program is loaded into the program execution means PGM from the program file PGF using the read log system identification number PID as a key. The program execution means PGM inputs the screen parameters corresponding to the fixed pattern.The screen parameters include a specific data name for the column-corresponding dimension ROW of the fixed pattern, and comments for this data name as necessary. FIG. 2 shows an example of the table shown in FIG. 3B.

The program execution means PGM then outputs the account identification number TID previously input from the output account menu file TMF.
is the key, read the corresponding report definition from the report definition 7 isle RDF, and create the database D based on this report definition and the screen parameters that have already been input.
Search the BS and obtain predetermined data.

The data obtained from the database DBS is edited and tabulated based on data definitions, screen parameters, and fixed patterns.
Based on this result, the printer outputs the book table TBL.

As is clear from the above explanation, the program is created for each standard pattern, responds to the input of n1 screen parameters, reads the report standard a file RDF using the ledger identification number TID as a key, searches the database DBS, and retrieves data. It is a tool that only has general processing procedures such as editing and tabulation, and the specific specifications for these processing are done by the user by inputting the report definition and screen parameters, so it is difficult to use. This means that those who are involved in the program will be able to do no programming or compiling.

(Effects of the Invention) According to the present invention, as described above, a program corresponding to a fixed pattern and a report definition that gives specific specifications for this program are created in advance by parameter input, and the two are associated and filed. By doing so, when creating a ledger, you can input a predetermined program and report definition and output the ledger just by inputting the ledger name and screen parameters, so it is easier for users to output the ledger. In addition, the report format can be easily changed just by changing the report definition, and report definitions can be made without being aware of the database structure, making it easier to create more general-purpose ledgers. It will be possible to output.

[Brief explanation of the drawing]

1 and 2 are block diagrams of one embodiment of the present invention, FIGS. 3A and 3B are diagrams explaining partial details of this embodiment, and FIG. 4 is a block diagram of this embodiment. FIG. 2 is a diagram illustrating a software environment. PMF・・・・・・Book Hatamanmeni S-7 Isle, R
DP...Report definition registration means, TMF...
...Output ledger menu file, RDF...
V Baud) Constant a file, PGF...Program file, PGM...Program execution means, D
BS...Database, TBL...Book fi, HCP...Host combinator, WS1
~WSN・・・・・・Work stage manager. Figure 1 Figure 2 Figure 3A Figure 4

Claims (1)

[Scope of Claims] A book creation processing method using a workstation connected to a host computer and equipped with means for input operation, screen display, and book output, comprising: a database whose dimensions are item, time, and area units; a ledger pattern menu file in which a program identification number corresponding to a fixed pattern determined by a combination of the dimensions corresponding to the rows and columns of the ledger, the number of digits of data in the ledger, and the number of pieces of data is stored in advance; a report definition registration program that creates an output ledger menu file and a report definition file based on the parameters and report definition data input by the input operation means for each of the fixed patterns displayed on the screen display means; and parameter input processing. , a program for each surface plate pattern that searches, edits, and tabulates the database is provided with a program file stored in advance in association with the program identification number, and when determining the accounting format, the program file is stored in advance in the host computer. Connect the ledger pattern menu file, load the report definition registration program, and create a correspondence between the output ledger menu file and the ledger identification number, which indicate the correspondence between the ledger name, ledger identification number, and the program identification number. When creating a report definition file that defines a report definition consisting of a data name of the dimension corresponding to the row and column of the book, an operator for the data name, an edit code, etc., and when outputting the book, The output ledger menu file, the report definition file, and the database are connected to the host computer and the output is displayed on the screen display means;
By simply selecting a ledger name from the ledger menu file and inputting the parameters for the fixed pattern using the input operation means, the program operates and the ledger output means can output the desired ledger. A book creation processing method characterized by the following.