JPH10340306A - General purpose document system in billing system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To reduce program development/maintenance man-hour by generating document control information, layout control information, coordinate control information and extraction condition information as definition information. SOLUTION: As a definition information file 100, a control level information file 101, a sorting order information file 102, a row/column information file 103, an item editing information file 104, a coordinate line control information file 105, a coordinate index information file 106 and an extraction condition information file 107 are provided. A definition information input means 111 prepares the definition of the definition information file 100 and inputs the information of the definition file 100 as an input parameter and thus, an analysis/editing/output means 116 extracts the user data of a slip preparation request object from a document generation object data file 108, performs analysis/editing and generates basic data to become document output data. A general purpose document output means 117 outputs a bill 118 by editing/outputting the basic data.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a general-purpose accounting system in a billing system, and more particularly to a general-purpose billing system for generating (layout, totaling unit, extraction condition, sort order) according to a request of a billing party from the same data file. It relates to a general-purpose report system in a system.

[0002]

2. Description of the Related Art In a business system for issuing invoices to other companies, a form (invoice) is created according to a format specified by each user (company), and a form (invoice) is output according to the billing date. Is required.

FIG. 4 shows a conventional form system in a billing system. In the conventional billing form system, first, in order to respond to a request from each user, a data file 40 dedicated to each user is converted from the target data file 401.
2 is created by the extraction and classification means 403. Next, from the extracted and classified data file 402, a program developed individually to realize a form layout, a print character, a print position, an output item, a tally item, and a sort order based on a use request from each user is used. A form output data file 405 is created by a certain data processing / aggregating unit 404. Finally, data is edited from the form output data file 405 by the individually developed form output means 406,
The bill is output to obtain a bill 407 dedicated to each user.

Various prior arts related to the present invention are known. For example, Japanese Unexamined Patent Publication No.
Called Prior Art 1. ), The request information is parameterized when creating a request for a multi-dimensional tabulation report, information including tabulation-related information is retained as control information, and the process from request to output is integrated, reducing the development man-hour and program management man-hour for each form A "general-purpose multi-dimensional tabulation book creation system" is disclosed. In the prior art 1, the system control file holds guide information for creating a multidimensional tabulation form. The input means determines request information for creating the target multidimensional total information based on the target multidimensional total form image corresponding to the screen according to the guide information and parameterizes the request information. The tabulation expansion file stores a plurality of field tabulation expansion files that store the tabulation destination titles of the tabulation target data corresponding to the fields of the tabulation target data. The analysis / search / aggregation / processing means analyzes the parameters and extracts aggregation target data from the aggregation development file based on the aggregation destination title to classify, aggregate, and process. An analysis, editing, and output unit analyzes the parameters and edits and outputs the form to a target position.

Japanese Patent Application Laid-Open No. 61-267870 (hereinafter referred to as “prior art 2”) discloses a general-purpose form by associating a file corresponding to a fixed pattern with a report definition and storing the file. There is disclosed a "book table creation processing method" which can be easily output. In Prior Art 2, the means for executing the program loaded from the program file inputs a report definition file, an output book table menu file, a database, and screen parameters, and outputs a book table. The report definition file and the output book table menu file are created in the book table format definition phase, and the program file contains the program for each fixed pattern that performs parameter input processing, database search, and editing / tabulation. It is stored in advance using the number as a key. Thus, the book format can be changed only by changing the report definition.

Further, Japanese Patent Application Laid-Open No. 4-141723 (hereinafter referred to as Prior Art 3) collectively manages selection conditions, thereby eliminating the need for complicated operations when creating a form. A selection condition management system "is disclosed. In the prior art 3, all information that becomes unique information at the time of form creation is separated from the program and stored in the control file. Then, the selection items to be specified for creating the form read from the control file are displayed on the screen of the workstation, and the items selected by the input control unit are stored in the condition file and managed. Therefore, in a form program requiring a large number of selection items to be input, general-purpose management of form selection conditions can be collectively managed by a unified selection item input screen. This eliminates the complexity of creating a form, and provides a general-purpose form creation condition management system.

[0007]

The conventional billing form system described above has the following problems. In other words, in response to a new user addition or a change request from an existing user, creation / change of a user-specific data file, and design, manufacture, test, and extraction / classification program, data processing / editing program, and form output program for individual extraction / sorting programs. Release work is required. As a result, the fixing work increases, and the management of the program becomes complicated.

On the other hand, the above-mentioned prior arts 1 to 3 have the following problems. Prior Art 1 only discloses a technique for generalizing the tallying process, and cannot set how the layout is to be performed. Also,
Prior Art 2 only discloses a technique of patterning and selecting a form, and can only obtain a form having a predetermined fixed pattern, which limits the types of forms that can be created,
Poor versatility. Prior art 3 only discloses a technique for selecting items of a form, and can obtain only a preset form as in prior art 2, restricts the types of forms that can be created, and is inferior in versatility. .

SUMMARY OF THE INVENTION Accordingly, an object of the present invention is to solve the above-mentioned problems by individually determining a form layout, print characters, print positions, output items, total items, and a sort order based on specifications required by a user. An object of the present invention is to reduce program development and maintenance man-hours without developing an extraction classification program, a data processing aggregation program, and a form output program.

[0010]

According to the present invention, there is provided a definition information file for storing definition information, input means for creating a definition of the definition information file, and the definition stored in the definition information file. A general-purpose form system in a billing system, comprising: analysis / edit / output means for processing and editing form creation target data according to information; and general-purpose form creation means for outputting data created by the analysis / edit / output means to a form. In the definition information file,
A form control information file for storing form control information for form control, a layout control information file for storing layout control information for layout control, and a coordinate control information file for storing coordinate control information for coordinate control; An extraction condition information file for storing extraction condition information when extracting the form creation target data, wherein the input unit includes the form control information, the layout control information, the coordinate control information, and the extraction condition. A general-purpose form system in a billing system is provided, wherein information is created as the definition information.

Further, according to the present invention, a definition information file for storing definition information, input means for creating a definition of the definition information file, and a form creation in accordance with the definition information stored in the definition information file Processing of target data,
A general-purpose form system in a billing system, comprising: analysis-editing-output means for performing editing; and general-purpose file output means for editing / outputting target user-specific data from data created by the analysis / editing / output means. As a definition information file, a form control information file for storing form control information for form control, a layout control information file for storing layout control information for layout control, and a method for extracting the form creation target data. An extraction condition information file for storing extraction condition information, wherein the input unit creates the form control information, the layout control information, and the extraction condition information as the definition information. A form system is obtained.

[0012]

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

Referring to FIG. 1, a general-purpose form system in a billing system according to a first embodiment of the present invention includes a definition information file 100 storing definition information as described below,
Target data file 108 and definition information input means 111
, An analysis / edit / output unit 116 and a general-purpose form creation unit 117.

In the illustrated general-purpose form system, a control level information file 101 for storing control level information, a sort order information file 102 for storing sort order information, a line Row / column information file 103 for storing column information, item edit information file 104 for storing item edit information, coordinate line control information file 10 for storing coordinate line control information
5. A coordinate index information file 106 for storing coordinate index information and an extraction condition information file 107 for storing extraction condition information are provided.

The control level information and the sort order information are information for form control, and are collectively called form control information. Therefore, the combination of the control level information file 101 and the sort order information file 102 is called a form control information file for storing the form control information.
The row / column information and the item editing information are information for layout control, and are collectively called layout control information. Therefore, the combination of the row / column information file 103 and the item edit information file 104 is called a layout control information file for storing layout control information. Furthermore, since the coordinate line control information and the coordinate heading information are information for coordinate control, they are collectively called coordinate control information. Therefore, the combination of the coordinate line control information file 105 and the coordinate heading information file 106 is called a coordinate control information file for storing coordinate control information.

The control level information file 101 has, as control level information, item information for performing a page break control, information on the number of line feeds of headings, details, and footnotes, and information on the positions of fixed headings and digits. The sort order information file 102 has position and number of digits information for designating the data sort order as sort order information. The row / column information file 103 has the number of print lines and the number of columns as row / column information. The item editing information file 104 includes, as item editing information, editing source information (position, digit, attribute), editing destination information (digit, attribute), and reference information at the time of editing (other files, Edited parts) information. The coordinate line control information file 105 has coordinates (vertical and horizontal), ruled line type, line width, and halftone dot information for ruled line printing as coordinate line control information. The coordinate heading information file 106 has information such as coordinates for character printing and character size as coordinate heading information. The extraction condition information file 107 includes a position, a digit, and the like of an extraction condition item for extracting data as extraction condition information.
Attributes, extraction conditions (AND, OR), comparison conditions (FRO)
M, TO).

The definition information input means 111 creates the definition of the definition information file. Analysis / edit / output means 116
Analyzes the definition information stored in the definition information file. The general-purpose form creation means 117 obtains the target bill 118 by editing and outputting the edited data.

Next, the operation of the general-purpose form system in the billing system shown in FIG. 1 will be described in detail. The definition information input unit 111 first uses the form control information definition screen 112 to set item information for performing a page break control, a heading / specification, the number of line feeds of a footnote, a position of a fixed heading, and information of a digit as control level information. The information is stored in the control level information file 101, and information on the position and the number of digits of the item for specifying the data sort order is stored in the sort order information file 102 as sort order information. Subsequently, the definition information input unit 111 stores the number of print lines and the number of columns as row / column information in the row / column information file 103 on the layout control information definition screen 113, and edits the item from the form creation target data. Source information (position, digit, attribute), destination information (digit, attribute), and reference information (other files, editing parts) at the time of editing are stored in the item editing information file 104 as item editing information. I do. Further, the definition information input unit 111 uses the coordinate control information definition screen 114 to
Coordinates (vertical and horizontal) for ruled line printing, information on ruled line types, line widths, and halftone dots are stored in the coordinate line information file 105 as coordinate line information, and information such as coordinates and character size for character printing is stored. It is stored in the coordinate header information file 106 as coordinate header information. Finally, definition information input means 1
Reference numeral 11 denotes the position, digit, attribute, extraction condition (AND, OR), and comparison condition (FROM, TO) of the extraction condition item when data is extracted on the extraction condition information definition screen 115.
Extraction information file 10 as the extraction condition information
7 is stored.

By inputting information of these definition information files 100 as input parameters, analysis, editing,
The output unit 116 outputs the form creation target data file 108.
Extract user data for form creation request from
Edit and create basic data that will be the form output data. The general-purpose form output means 117 outputs a bill 118 by editing and outputting the basic data.

Next, FIG. 2 shows a specific example of the invoice 118 created by the general-purpose form system shown in FIG.

Item information, heading / specification, number of line feeds for footing,
The position and digit information of the fixed heading are designed and determined, and the control level 1 and the control level 2 of the control level 203 are defined. Next, the position and the number of digits of the item for designating the sort order of the data are designed and determined, and the definition is performed as in the sort order 205. Subsequently, the number of lines and the number of columns on which the details are printed are defined. Then, design and determine information of editing source information (position, digit, attribute), editing destination information (digit, attribute), and reference information (other files, editing parts) at the time of editing from the target data. Then, a definition is made for each item as in the item edit 204. Next, the coordinates (vertical and horizontal) for ruled line printing, ruled line type, line width, halftone dot, coordinates for character printing, character size, etc. are designed and determined.
9 are defined as a coordinate heading 201 and a coordinate line 202 which are fixedly printed on the reference numeral 9. Then, the position, digit, attribute, extraction condition (AND, OR), and comparison condition (FROM, TO) of the extraction condition item are determined, and the target data file 1 is determined.
From 08, the condition of data to be output (or not output) to the bill 118 is defined.

Next, referring to FIG. 1 in addition to FIG. 2, a specific operation of the general-purpose form system will be described in detail.

On the form control information definition screen 112 of the definition information input means 111, item information for performing a page break control, heading / specification, the number of line breaks in footing, the position of a fixed heading, and digit information are used as control level information. By storing the information in the control level information file 101, the control level 1 and the control level 2 of the control level 203 in FIG. 2 are determined, and the heading, footprint, and the total information for each control level 1 and 2 are determined. Can be defined. Subsequently, the form control information definition screen 112 of the definition information input means 111
By storing the information on the position and the number of digits of the item for specifying the data sort order in the sort order information file 102 as the sort order information, the sort of the item at the time of outputting the details as in the sort order 205 of FIG. 2 is performed. The order can be determined.

Next, the number of print lines and the number of columns are stored as row / column information in the row / column information file 103 on the layout control information definition screen 113 of the definition information input means 111, so that The definition of the number can be determined.
Subsequently, on the layout control information definition screen 113 of the definition information input unit 111, editing source information (position, digit, attribute), editing destination information (digit, attribute) for editing items from the form creation target data, and editing time Reference information (other files,
By storing the information of the editing part in the item editing information file 104 as the item editing information, the item editing 2 in FIG.
Target data file 1 for each item unit, such as 04
The definition of which item on 08 is to be output at which position on invoice 118, how many digits, what kind of editing, and which item on another file is to be output on invoice 118 is defined. I can do it.

Next, the coordinates (vertical, vertical, etc.) for printing the ruled line are displayed on the coordinate control information definition screen 114 of the definition information input means 111.
Information such as width), ruled line type, line width, halftone dot, coordinates for character printing, and character size are stored in the coordinate line information file 105 and the coordinate heading information file 106 as coordinate line information and coordinate heading information. As a result, the coordinate index 201 of FIG.
And a coordinate line 202 can be defined.

Finally, on the extraction condition information definition screen 115 of the definition information input means 111, the position, digit, attribute, extraction condition (AN
D, OR) and comparison conditions (FROM, TO) are stored in the extraction condition information file 107 as extraction condition information, so that the invoice 11
8 can define the conditions of the data to be output (or not output).

By inputting the information of the definition information file 100 as an input parameter, the analyzing / editing / outputting unit 116 allows the form creation target data file 10
8 to extract the user data of the form creation request target, analyze control level information, sort order information, line / digit information, item editing information, coordinate line control information, coordinate heading information, and process data according to the definition information. Edit. The general-purpose form output means 117 edits the data created by the analysis / edit / output means 116 into data to be output to a form, and outputs a target bill 118.

With reference to FIG. 3, a general-purpose form system in a billing system according to a second embodiment of the present invention will be described. The illustrated general-purpose form system creates user request data in order to respond to a data request (FD, MT, transmission) from a user together with an invoice, and changes the definition information file 100 to a definition information file 100A. However, it has the same configuration as that shown in FIG. 1 except that a general-purpose file output unit 119 is used instead of the general-purpose form output unit 117. Therefore, components having the same functions as those of the components shown in FIG. 1 are denoted by the same reference numerals, and their description for simplifying the description will be omitted.

The definition information file 100A has the same configuration as the definition information file 100 shown in FIG. 1, except that the coordinate line information file 105 and the coordinate heading information file 106 are omitted. Accordingly, the coordinate control information definition file 114 is also omitted.

The general-purpose file output means 119 edits and outputs the data edited by the analysis / edit / output means 116, and outputs a target user-specific data file 120.

The program executed by the computer constituting the general-purpose form system may be recorded on a recording medium (not shown). Here, the “recording medium” refers to a computer-readable recording medium on which a program is recorded. Specifically, it includes a magnetic disk such as a CD-ROM and a plexible disk, and a semiconductor memory. Further, the recording medium may be paper on which a program is recorded. In this case, the computer
What is necessary is just to have a reading device such as an (optical character reading device) and a compiler that translates a character (code) read by the reading device into a machine language that can be recognized by a computer. In any case, by installing the program recorded on the recording medium into the computer, the computer can perform a predetermined process.

The present invention is not limited to the above-described embodiment, and various changes and modifications can be made without departing from the spirit of the present invention.

[0033]

As described above, the present invention has the following effects. In other words, there is no need to develop an extraction classification program, a data processing aggregation program, and a form output program in order to realize a form layout, print characters, print positions, output items, total items, and a sort order based on the specification required by the user. Development and maintenance man-hours can be reduced.

[Brief description of the drawings]

FIG. 1 is a block diagram showing a configuration of a general-purpose form system in a billing system according to a first embodiment of the present invention.

FIG. 2 is a diagram showing a specific example of a bill created by the general-purpose form system of FIG. 1;

FIG. 3 is a block diagram showing a configuration of a general-purpose form system in a billing system according to a second embodiment of the present invention.

FIG. 4 is a block diagram showing a configuration of a general-purpose form system in a conventional billing system.

[Explanation of symbols]

 100, 100A Definition information file 101 Control level information file 102 Sort order information file 103 Row / column information file 104 Item edit information file 105 Coordinate line information file 106 Coordinate header information file 107 Extraction condition information file 108 Target data file 111 Definition information input Means 112 Form control information definition screen 113 Layout control information definition screen 114 Coordinate control information definition screen 115 Extraction condition information definition screen 116 Analysis / editing / output means 117 General-purpose form output means 118 Invoice 119 General-purpose file output means 120 Data file for each user

Claims (25)

[Claims] 1. A definition information file for storing definition information, input means for creating a definition of the definition information file, and processing and editing of form creation target data in accordance with the definition information stored in the definition information file A general-purpose form system in a billing system having analysis / edit / output means for performing the following, and a general-purpose form creation means for outputting data created by the analysis / edit / output means to a form; A form control information file for storing form control information for layout control, a layout control information file for storing layout control information for layout control, a coordinate control information file for storing coordinate control information for coordinate control, An extraction condition information file for storing extraction condition information when extracting form creation target data; It means the form control information, the layout control information, generic form system in claim system, characterized in that to create the coordinate control information, and the extracting condition information as the definition information. 2. The form control information file includes a control level information file storing control level information for performing a page break control as one of the form control information, and a data as another one of the form control information. 2. A general-purpose form system according to claim 1, further comprising a sort order information file storing sort order information for designating the sort order. 3. The control level information file according to claim 2, wherein the control level information file has, as the control level information, item information, the number of line feeds of a heading / detail / footprint, the position of a fixed heading, and information on a digit. General-purpose form system in billing system. 4. The general-purpose form system according to claim 2, wherein the sort order information file stores information on the position of the item and the number of digits as the sort order information. 5. The layout control information file includes a row / column information file storing row / column information as one of the layout control information, and an item from a form creation target data as another one of the layout control information. 2. The general-purpose form system according to claim 1, further comprising an item editing information file storing item information for performing editing. 6. The general-purpose form system according to claim 5, wherein the row / column information file has information on the number of print lines and the number of columns as the row / column information. 7. The general-purpose form system in claim system according to claim 5, wherein the item editing information file has information of editing source information, editing destination information, and reference information at the time of editing as the item editing information. . 8. The editing source information includes position, digit, and attribute information, the editing destination information includes digit and attribute information, and the reference information at the time of editing includes information on other files and editing parts. A general-purpose form system in a billing system according to claim 7. 9. The coordinate control information file includes a coordinate line control information file storing coordinate line control information for ruled line printing as one of the coordinate control information, and a character line as another one of the coordinate control information. 2. The general-purpose form system according to claim 1, further comprising a coordinate index information file for storing coordinate index information for printing. 10. The coordinate line control information file includes:
10. The general-purpose form system according to claim 9, wherein the coordinate line control information includes coordinate line (vertical and horizontal), ruled line type, line width, and halftone dot information for ruled line printing. 11. The general-purpose form system according to claim 9, wherein the coordinate heading information file has information on coordinates and character size for character printing as the coordinate heading information. 12. The general-purpose form system according to claim 1, wherein the extraction condition information file has information on a position, a digit, an attribute, an extraction condition, and a comparison condition of an extraction condition item as the extraction condition information. 13. The general-purpose form system according to claim 12, wherein said extraction condition includes AND and OR, and said comparison condition includes FROM and TO. 14. A definition information file for storing definition information, input means for creating a definition of the definition information file, and processing and editing of form creation target data according to the definition information stored in the definition information file. A general-purpose form system in a billing system, comprising: an analysis / edit / output unit that performs the above-mentioned processing; and a general-purpose file output unit that edits / outputs target user-specific data from the data created by the analysis / edit / output unit. As information files, a form control information file for storing form control information for form control, a layout control information file for storing layout control information for layout control, and extraction when extracting the form creation target data An extraction condition information file for storing condition information, wherein the input means includes the form control information; Generic form system in claim system, wherein to create the layout control information, and the extracting condition information as the definition information. 15. The form control information file includes a control level information file storing control level information for performing a page break control as one of the form control information, and a data as another one of the form control information. 15. The general-purpose form system according to claim 14, further comprising a sort order information file for storing sort order information for designating the sort order. 16. The control level information file according to claim 15, wherein the control level information file has, as the control level information, item information, headline / specification / footprint line feed number, fixed heading position, and digit information. General-purpose form system in billing system. 17. The general-purpose form system according to claim 15, wherein the sort order information file has information on the position of the item and the number of digits as the sort order information. 18. The layout control information file includes:
A row / column information file for storing row / column information as one of the layout control information, and an item edit for storing item information for performing item editing from form creation target data as another one of the layout control information 15. The general-purpose form system according to claim 14, comprising an information file. 19. The line / column information file contains the row / column information file.
19. The billing system according to claim 18, wherein the column information includes the number of print lines and the number of columns. 20. The general-purpose form system according to claim 18, wherein the item editing information file has editing source information, editing destination information, and reference information at the time of editing as the item editing information. . 21. The editing source information includes position, digit, and attribute information, the editing destination information includes digit and attribute information, and the reference information at the time of editing includes information on other files and editing parts. A general-purpose form system in a billing system according to claim 20. 22. The general-purpose form system according to claim 14, wherein the extraction condition information file has information on a position, a digit, an attribute, an extraction condition, and a comparison condition of an extraction condition item as the extraction condition information. 23. The general-purpose form system according to claim 22, wherein said extraction condition includes AND and OR, and said comparison condition includes FROM and TO. 24. A process for storing form control information for form control provided from input means in a form control information file, and storing layout control information for layout control provided from said input means in a layout control information file. Processing for storing coordinate control information for coordinate control provided from the input means in a coordinate control information file; and extracting extraction condition information for extracting form creation target data provided from the input means. Processing to be stored in a condition information file; and the form control information, the layout control information, and the coordinates respectively stored in the form control information file, the layout control information file, the coordinate control information file, and the extraction condition information file. The form creation target data according to the control information and the extraction condition information. Processing, and processing for editing, recording medium characterized by recording a program for executing a process of outputting the processed and edited data to the form to the computer. 25. A process for storing form control information for form control provided from an input means in a form control information file, and storing layout control information for layout control provided from the input means in a layout control information file. Processing for extracting the form creation target data provided from the input means in the extraction condition information file; and processing the form control information file, the layout control information file, and the extraction condition. The form control information, the layout control information respectively stored in the information file,
And a program for causing a computer to execute a process of processing and editing the form creation target data in accordance with the extraction condition information, and a process of editing and outputting target user-specific data from the processed and edited data. Recording medium characterized by the above-mentioned.