JP2006268655A - Input form management system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To efficiently generate/change forms matched to various requests such as a form used for establishment of a company performance management system. <P>SOLUTION: The data input form generation management system 1d which performs generation and change of a data input form composed of a plurality of lines and a plurality of rows comprises a row information table M2 storing one or more row item names preliminarily inputted from an input device in conformation to identification information assigned to any one of a plurality of data input forms; a line information table M3 storing one or more line item names preliminarily inputted from the input device in conformation to the identification information of data input forms; and an input form editing function d1 reading one or more row item names and one or more line item names conformed to identification information of a data input form inputted from the input device from the row information table M2 and the line information table M3, and generating a data input form composed of lines of the read item names and rows of the read item names, and displaying it on a display device. <P>COPYRIGHT: (C)2007,JPO&INPIT

Description

  The present invention relates to a technique for generating and changing a form screen for inputting data by computer processing, and more particularly, to the construction of a company performance management system using a host computer or an ERP (Enterprise Resource Planning) package. The present invention relates to a technique suitable for efficiently generating and changing a form that meets various requirements such as a form to be used.

  In Patent Document 1, in the construction of an information system using the Web, an “input / output screen is generated by combining database information based on information read from the screen generation information by the screen generation system. If there is a need to change the display format, the contents of items that require changes to the display items, display positions, display names, related database items, etc., defined in terms commonly used in screen generation information are generally A technique is described that automatically calculates and generates the entire layout of the input / output screen when rewritten using the terminology used.

  The technology of this Patent Document 1 is limited to the construction of an information system using the Web, but also in the construction of information systems other than the information system using the Web, for example, the construction of an information system using a host, an ERP package, or the like. Therefore, there is a demand for a system that can easily create an input form (screen) that meets various requirements and can search and register data using the created input form (screen).

  In a conventional information system, for example, input forms (screens) such as company performances differ depending on their use (combination of (1) to (10) below). The data processing program corresponding to the created screen was developed individually.

<Application>
(1) Form type (monthly / quarterly / half-year / annual etc),
(2) Usage restrictions (user restrictions etc),
(3) Conversion display (local price display / yen conversion display etc),
(4) Display units (thousand units / million units / currency units etc),
(5) Deadline date and time (registration restrictions by date and time),
(6) Data type (target data is budget / actual calculation / actual estimation / forecast etc),
(7) Data period (the target data is the previous month, current month, previous period, current period, next period etc),
(8) Data items (target data are account items, management indicators, working personnel, working hours etc),
(9) Automatic calculation (automatic calculation display of increase / decrease / ratio and automatic calculation registration etc of total subjects),
(10) Check (check input data).

JP 2003-99241 A

  The problem to be solved is that with the conventional technology, for example, regarding data entry forms (screens) such as company performance, different data entry forms (screens) are prepared for each company and for each business content. In addition, a program for storing and managing data input in each data input form (screen) must be prepared for each data input form (screen).

  The object of the present invention is to solve these problems of the prior art, and to efficiently generate and change forms that meet various requirements, such as forms used in the construction of a company performance management system. That is.

  In order to achieve the above object, in the present invention, screen edit information such as display contents and display method of a data input form is registered as master data in advance, and the data input form is generated based on the screen edit information. And the registration of the data input in the data input form. That is, the data input form generation management system of the present invention comprises (1) an input device, a display device, a storage device, and a processing device that performs computer processing using a program, and data input consisting of a plurality of rows and a plurality of columns. A data input form generation management system for generating and changing a form, wherein one or more column items are input in advance from an input device in association with identification information assigned to any one of a plurality of data input forms Column information table M2 for storing names, row information table M3 for storing item names of one or more lines previously input from the input device in association with identification information of the data input form, and data input from the input device Read item names of one or more columns and item names of one or more rows associated with the identification information of the input form from the column information table M2 and the row information table M3. , And having an input form editing function d1 of displaying the generated and display data input form consisting of a sequence of the read item name rows and item names. (2) The input form editing function d1 has a form string editing function d12 and a form line editing function d13. With these functions d12 and d13, the data input is performed in accordance with a user operation on the displayed data input form. Add a new column item name or row item name to the form. (3) Conditions for restricting user operations on the displayed data input form are stored in advance in the user table K1 in accordance with the user identification information, and the user check function S1 causes the data input form to be input from the input device. The operation restriction condition corresponding to the user identification information input together with the identification information is read with reference to the user table K1, and the operation of the user on the data input form is restricted. (4) In the form number table M1, conditions for restricting user operations on the displayed data input form are stored in advance according to the time period, and the user's action on the data input form is performed by the deadline check function S3. A restriction condition is specified by comparing the operation execution time with the time zone stored in the form number table M1, and a user operation on the data input form is restricted according to the specified restriction condition. Further, (5) in the check type table M5, conditions for determining the correctness of the data input to the data input form are stored in advance by specifying column items and line items constituting the data input form. The data check function d31 determines whether the data input by the user for the data input form is correct or not according to the conditions stored in the check expression table M5. Also, (6) the user's data input result for the data input form displayed by the input form editing function d1 is stored in the performance table T1, and the data input result is read from the performance table T1 by the data display function d2. Are displayed on the embedded display device. In addition, (7) an arithmetic expression using each data in a plurality of column items is included as a column item constituting the data input form, and the automatic calculation function d22 performs an arithmetic operation based on the arithmetic expression, and the result is displayed in the column item area. To display. (8) In the column information table M2, conditions for restricting user operations on the columns of the data input form displayed by the input form editing function d1 are stored in advance according to the user identification information, and the column protection editing function By S5, the operation restriction condition corresponding to the user identification information input together with the identification information of the data input form from the input device is read from the column information table M2, and the column of the data input form of the user according to the read operation restriction condition Restrict operations on. (9) In the line information table M3, conditions for restricting user operations on the lines of the data input form displayed by the input form editing function d1 are stored in advance according to the user identification information, and the line protection editing function is stored. By S7, the operation restriction condition corresponding to the user identification information input together with the identification information of the data input form from the input device is read from the line information table M3, and the line of the data input form of the user according to the read operation restriction condition Restrict operations on. (10) The data table function d2 displays all the column item names stored in the column information table M2 on the display device, and displays all the row item names stored in the row information table M3 on the display device.

  According to the present invention, screen edit information such as display contents and display method of a data input form (screen) registered in advance as a master data in a database or the like is searched, and the data input form is edited and displayed. Therefore, the data input form can be stored in the database and the data input form can be managed, so that a new data input form (screen) can be easily created by simple master registration. In addition, the layout of an existing data input form (screen) can be easily changed by simple master update. Also, it is not necessary to prepare (new development / modification etc) a data processing program corresponding to the data input form (screen).

  The best mode for carrying out the present invention will be described below with reference to the drawings. FIG. 1 is a block diagram showing a configuration example of a computer network provided with a data input form generation management system according to the present invention. FIG. 2 is a block diagram showing an example functional configuration of the data input form generation management system according to the present invention. FIG. 3A is an explanatory diagram showing a 1/3 portion of a registered content example in the common master, the input form management master, the performance table, and the save area used in the data input form generation management system according to the present invention. FIG. 3C is an explanatory diagram showing a 2/3 portion of the registered contents in the common master, the input form management master, the performance table, and the save area used in the data input form generation management system according to the present invention, and FIG. Common data and input form management master used in related data entry form generation management system, performance table and save area FIG. 4-a is an explanatory diagram showing details of the user table in FIG. 1, and FIG. 4-b is an explanatory diagram showing details of the company information table in FIG. 4-c is an explanatory diagram showing details of the settlement period table in FIG. 1, FIG. 4-d is an explanatory diagram showing details of the management item table in FIG. 1, and FIG. 4-e is a currency rate in FIG. FIG. 4-f is an explanatory diagram showing details of the number table in FIG. 1, FIG. 4-g is an explanatory diagram showing details of the column information table in FIG. 1, and FIG. 1 is a diagram illustrating details of the row information table in FIG. 1, FIG. 4-i is a diagram illustrating details of the automatic calculation formula table in FIG. 1, and FIG. 4-j is a diagram illustrating details of the check formula table in FIG. Fig. 4-k is the achievement table in Fig. 1 FIG. 5A is a flowchart showing the first half of the processing operation example related to the check function of the data input form generation management system according to the present invention, and FIG. 5-B is the data input form generation according to the present invention. 6 is a flowchart showing the second half of the processing operation example related to the check function of the management system, FIG. 6 is a flowchart showing an example of the document string editing processing operation of the data input form generation management system according to the present invention, and FIG. 7 is the data related to the present invention. FIG. 8A is a flowchart showing the first half of a processing operation example related to data search of the data input form generation management system according to the present invention. Shows the latter half of the processing operation example related to data search of the data input form generation management system according to the present invention. FIG. 9 is a flowchart showing an example of processing operation related to automatic calculation of the data input form generation management system according to the present invention. FIG. 10A is a processing operation related to display editing of the data input form generation management system according to the present invention. A flowchart showing the first half of the example, FIG. 10B is a flowchart showing the latter part of the processing operation example related to display editing of the data input form generation management system according to the present invention, and FIG. 11A is a data input according to the present invention. FIG. 11B is a flowchart showing the second half of the processing operation example related to the input data check of the data input form generation management system according to the present invention. FIG. 12 shows a data input form generation management system according to the present invention. It is a flowchart showing a first half of a processing operation example of data storage.

  In FIG. 1, reference numerals 1 to 3 denote computers including a central processing unit (CPU), a main memory, a display device, an input device, and an external storage device. For example, the computer 1 is a CD-ROM via an optical disk drive device or the like. After the program and data recorded in the storage medium such as the above are installed in the external storage device, they are read from the external storage device into the main memory and processed by the CPU, whereby the data input form generation management system 1d (FIG. (Indicated as “input form management system”).

  The computer 1 communicates with the terminal computers 2 and 3 through the intranets 4 and 5, receives data input from the master registration function 2 a from the terminal computer 2, and receives the input form management master 1 a and the common master 1 c. Table (form number table M1, column information table M2, row information table M3, automatic calculation formula table M4, check formula table M5, user table K1, company information table K2, closing date table K3, management item table K4, Stores data of rate table K5).

  Further, the computer 1 activates the data input form generation management system 1d in response to a request from the terminal computer 3, and the data input form generation management system 1d uses the data in the tables of the input form management master 1a and the common master 1c. Is used to generate a data input form composed of a plurality of rows and a plurality of columns, which is transmitted to the terminal computer 3 and displayed on the display device.

  The operator of the terminal computer 3 inputs various data to the data input form 3a displayed on the display device, transmits the input results to the data input form generation management system 1d of the computer 1, and generates the data input form. The management system 1d stores the input result in the performance table T1.

  In order to perform such processing, the data input form generation management system 1d has the functions shown in FIG.

  As shown in FIG. 2, the data input form generation management system 1d has an input form edit function d1, a data display function d2, and a data storage function d3. The input form edit function d1 has a check function d11 and a form sequence edit function. d12 and form row editing function d13, data display function d2 has data search function d21, automatic calculation function d22 and display editing function d23, data storage function d3 has input data check function d31 and data storage function d32.

  Further, the check function d11 in the input form edit function d1 has a user check function S1, a domestic / internal check function S2, and a deadline check function S3, and the form column edit function d12 has a column title edit function S4 and a column protection edit function S5. The form line editing function d13 has a line title editing function S6 and a line protection editing function S7, and the display editing function d23 in the data display function d2 is a conversion rate setting function S8, foreign currency conversion function S9, unit conversion A function S10 and a minority editing function S11 are provided.

  The data input form generation management system 1d having such a function stores screen editing information such as display contents and display method of a data input form composed of a plurality of rows and a plurality of columns as master data in advance in the input form management master 1a. Based on the screen editing information, the data entry form is generated and displayed, and the data entered in the data entry form is registered.

  In other words, the data input form generation management system 1d has one or more column items previously input from the input device in association with the identification information given to any one of the plurality of data input forms in the row information table M3. Names are stored, and in the line information table M3, item names of one or more lines previously input from the input device are stored in association with the identification information of the data input form.

  In the input form editing function d1, one or more column item names and one or more line item names associated with the identification information of the data input form input from the terminal computer 3 are converted into the column information table M2 and the row information. A data input form including a row of item names and a column of item names read out from the table M3 is generated, transmitted to the terminal computer 3, and displayed on the display device.

  The input form editing function d1 has a form string editing function d12 and a form line editing function d13, and the form input editing function d12 and the form line editing function d13 are used for the data input form 3a displayed on the terminal computer 3. In response to a user operation, a new column item name or row item name is added to the data input form.

  In the user table K1, conditions for restricting user operations on the data entry form are stored in advance according to the user identification information, and the identification information of the data entry form is obtained from the terminal computer 3 by the user check function S1. The operation restriction condition corresponding to the user identification information input together with the user identification information is read with reference to the user table K1, and the operation on the data input form by the user terminal computer 3 is restricted.

  In the form number table M1, conditions for restricting user operations on the displayed data input form are stored in advance according to the time zone, and the user for the data input form in the terminal computer 3 is recorded by the deadline check function S3. The restriction condition is specified by comparing the operation execution time and the time zone stored in the form number table M1, and the user operation by the terminal computer 3 on the data input form is restricted according to the specified restriction condition.

  Further, in the check expression table M5, conditions for determining whether the data input to the data input form is correct or not are specified and stored in advance by specifying column items and row items constituting the data input form. By d31, the correctness of the data input by the user for the data input form in the terminal computer 3 is determined according to the condition stored in the check type table M5.

  Further, the data input result of the user in the terminal computer 3 for the data input form displayed by the input form editing function d1 is stored in the achievement table T1, and the data input result is read from the achievement table T1 by the data display function d2. It is transmitted to the terminal computer 3 embedded in a form and displayed on the display device.

  Further, in the automatic calculation formula table M4, an arithmetic expression using each data in a plurality of column items is registered as a column item constituting the data input form, and an arithmetic operation using this arithmetic expression is performed by the automatic calculation function d22. Is transmitted to the terminal computer 3 and displayed in the column item area.

  In the column information table M2, conditions for restricting the user's operation of the terminal computer 3 with respect to the column of the data input form displayed on the terminal computer 3 by the input form editing function d1 are stored in advance according to the user identification information. The column protection editing function S5 reads the operation restriction condition corresponding to the user identification information input together with the identification information of the data input form from the terminal computer 3 from the column information table M2, and according to the read operation restriction condition, Operations from the terminal computer 3 on the data input form column are restricted.

  In the line information table M3, conditions for restricting the user's operation on the line of the data input form displayed on the terminal computer 3 by the input form editing function d1 are stored in advance according to the user identification information, and the line protection editing is performed. By the function S7, an operation restriction condition corresponding to the user identification information input together with the identification information of the data input form from the terminal computer 3 is read from the row information table M3, and the data input form of the user is determined according to the read operation restriction condition. The operation from the terminal computer 3 on the line is restricted.

  In response to a request from the terminal computer 3, the data table function d2 transmits all the column item names stored in the column information table M2 and all the row item names stored in the row information table M3 to the terminal computer 3. Display on the display device.

  As described above, in this example, when the operator activates the input form management system 1d via the terminal computer 3 and designates the company for inputting results and the form number used for the input operation, the operator registers them in advance. The screen layout (arrangement) is configured based on the screen editing information such as the displayed contents and display method, and the existing (past) data is acquired from the performance table (T1), and conversion processing, unit conversion, display editing, etc. are performed. In the terminal computer 3, the information is displayed on the screen of the layout.

  Further, when the operator inputs data into the input field on the screen and performs a storage instruction operation, the data can be registered or updated.

  3A to 3C show a schematic configuration of a table storing information used for control of the data input form management system 1d, and each item of the table in the data input form management system 1d and its description are shown. As a supplement, FIG. 3C also shows a save area.

  4A to 4K show specific contents of the tables shown in FIGS. 3A to 3C.

  For example, in FIG. 3A, in the user table (K1), company information table (K2), settlement period table (K3), management item table (K4), rate table (K5), and input form management master in the common master. Each item of the form number table (M1) is described. In FIG. 3B, in the input form management master, the column information table (M2), the row information table (M3), the automatic calculation formula table (M4), the check formula table ( M5) and the performance table (T1) as performance data are described. In FIG. 3C, a key area (X) as a save area for storing data generated in the processing related to the performance table (T1) , Y), editing method area (X, Y), and data area (X, Y). Each item is designated in the explanation in the figure.

  The items in the user table (K1) in FIG. 3A include a login ID, a login name, a password, a secret number, and a protection number. As illustrated in FIG. 4-A, the login ID includes “100001” and “100002”. ”Is registered,“ User Ichiro ”and“ User Jiro ”are registered in the login name,“ **** ”is registered in the password, and“ 100 ”and“ 200 ”are registered in the secret number. Are registered, and “150” and “250” are registered as the protection numbers.

  The items of the company information table (K2) consist of company code, company name, company currency, settlement month [first half], settlement month [second half], conversion month [first half], conversion month [second half]. As shown in the figure, “100”, “200”, “300”, “400” are registered in the company code, and “Japan Company,” “US Company,” “Europe, Inc.” is registered as the company name. "Company" and "China Company Ltd." are registered, "JPY", "USD", "EUR" and "CHY" are registered in the company currency, and "09" and "06" are registered in the first half of the fiscal year. , “09”, “06” are “03”, “12”, “03”, “12” in the closing month [second half], “09”, “06”, “ 09 ”and“ 06 ”are“ 03 ”,“ 12 ”,“ 03 ”in the conversion month [second half] "12" is registered.

  The items in the closing date table (K3) consist of the closing date and the closing date. As shown in Fig. 4-c, "2002SO (second half of 2002)" and "200303 (March 2003)" are registered respectively. The items of the management item table (K4) are composed of item codes, item names, and item types. As shown in FIG. 4D, the item codes include “001”, “301”, “401”, “601”. ”,“ 701 ”are the item names“ Sales ”,“ Orders received ”,“ Profit rate ”,“ Working personnel ”,“ Working hours ”, and“ 1 (Amount) ”,“ 1 ”are the item types (Amount), “4 (rate)”, “2 (person)”, and “3 (time)” are registered.

  The items in the rate table (K5) include the rate date, currency, and conversion rate. As shown in FIG. 4E, for example, “200303” is converted into the rate date and “CNY” is converted into the currency. For example, “14.5200” is registered in the rate.

  The form number table (M1) is composed of items such as form application number, form name, type, domestic / overseas, yen / foreign currency, secret number, deadline date, deadline time, and each item has data shown in FIG. In this form number table (M1), for example, what type of input form (for example: for half-year), what target (for example: overseas company), what display method (for example: yen display), what restrictions (for example) : Usage restriction only for budget officers), and information such as when the deadline (for example, registration by 18:00:00 on March 31, 2004) is stored.

  Further, the column information table (M2) shown in FIG. 3B includes items such as a form application number, a column number, a processing cycle, a pre-reaction category, a display category, a column title 1, and a column title 2. 4-g is registered, and this column information table (M2) indicates, for example, what (eg, budget) data the displayed or input data is (eg, first half of 2003). The stored information is stored for each column of the input form.

  Further, the line information table (M3) shown in FIG. 3B includes items such as a form application number, a line number, an item code, an item name, a unit, a decimal number, and a protection number. In the line information table (M3), for example, information indicating what management item (eg, sales) data is displayed or input is included in each line of the input form. Stored in units.

  Combining the column information and the row information stored in the column information table (M2) and the row information table (M3) shown in FIG. 3B, for example, the first column and the first row of the input form are sales in the first half of 2003. It becomes a high budget achievement input display column.

  The automatic table calculation formula table (M4) shown in FIG. 3B includes items of form application number, column number, row number, fixed value, and operator, and each item has data shown in FIG. 4-i. In this automatic calculation formula table (M4), for example, in the column (area) of the column number “001” and the row number “007” in the form with the form number “KP301101”, the form with the form number “KP301101” is stored. Stores the result of the operation indicated by the operator for each data in the column number “001” and the row numbers “005” and “002”.

  Further, the check expression table (M5) shown in FIG. 3B includes items of form application number, column number, row number, fixed value, and operator, and each item has data shown in FIG. 4-j. In this check formula table (M5), for example, the data registered in the columns (area) of the row numbers “001” and “002” in the column number “003” in the form with the form number “KP301101” It is determined whether or not the condition indicated by the operator is met.

  Further, the performance table (T1) shown in FIG. 3B includes items of company code, processing time, forecast category, item code, and performance value, and data of contents shown in FIG. 4-k is registered in each item. Is done.

  As described above, FIGS. 4A to 4J show examples of input of each table in the common master and the input form management master used for the control of the data input form generation management system 1d. The master and the input form management master are registered, and the data input form generation management system 1d generates the data input form using the tables of the common master and the input form management master in response to a request from the terminal computer 3. When the operator inputs data to the terminal computer 3 and the data is input to the data input form, the data input form generation management system 1d stores the input data in the performance table (T1).

  Hereinafter, processing contents of the data input form generation management system 1d will be described with reference to FIGS.

  FIGS. 5A and 5B show the processing contents of the check function d11 of the input form editing function d1 in the data input form generation management system 1d. First, from the system, the current date and time (system date, system (Time) is acquired (step 501), and information such as a login ID, company code, and form number input by the operator (user) is acquired (step 502).

  Further, the secret number of the user is obtained from the user table (K1) using the user's login ID as a key (step 503), and the company currency (JPY) is obtained from the company information table (K2) using the specified company code as a key. (Domestic companies / others are overseas companies), etc. (Step 504), using the designated form number as a key, the form number table (M1), the secret number of the form, domestic and overseas (domestic / overseas / company-wide) ), Information such as deadline date and deadline time is acquired (step 505).

  Then, by comparing each secret number (step 506), it is determined whether or not the input form having the form number designated by the user can be used (steps 507 and 508). If the secret number of the user is not greater than the secret number of the form. The processing is disabled (the processing in steps 506 to 508 described above is processing of the user check function S1).

  Further, by checking the consistency between the company currency and domestic / overseas (step 509), it is determined whether the input form of the form number designated by the company can be used (steps 510, 511), and the consistency between domestic and overseas is matched. If not, it is disabled (the processing in steps 509 to 511 described above is processing in the domestic / internal check function S2).

  Also, the deadline date and time of the form are obtained from the form number table (M1) using the designated form number as a key, and a comparison check is performed between the current date and time obtained from the system (step 512). It is determined whether or not data can be input or updated at that time (steps 513 and 514) (the processing in steps 512 to 514 is processing of the deadline check function S3). .

  When restricting input updates after a specific date and time, if both the deadline date and time are registered, all input items on the screen are protected and displayed only under the condition of system date and time> deadline date and time. (Cannot be updated).

  In addition, when restricting input updates for a specific cycle schedule, if only the deadline date is registered, all input items on the screen are protected and display only (cannot be updated) under the condition of system date> deadline date. . When limiting the daily input update time, if only the deadline time is registered, all input items on the screen are protected and displayed only (cannot be updated) under the condition of system time> deadline time.

  FIG. 6 shows the processing contents of the form column editing function d12 of the input form editing function d1 in the data input form generation management system 1d. First, the accounting period table (K3) is searched using the specified form number as a key. The current closing date information (closing year, closing date, etc.) is acquired (step 601).

  Next, the column information table (M2) is searched using the designated form number as a key, and each piece of information (processing month, forecast / classification, display classification, column title 1, column title 2) is acquired, and the column title The column title editing by the editing function S4 and the column protection editing by the column protection editing function S5 are repeated (steps 602, 603, 613).

  First, column title 1 and column title 2 are acquired from the column information table (M2) in units of column numbers using the designated form number as a key, and if there is registration information (steps 604 and 607), the contents are stored in the column. Is displayed as a title (steps 605 and 608).

  If there is no registration information in column title 1 (step 604), the processing month of the column information table (M2) is added based on the fiscal year or fiscal year of the fiscal year table (K3), and the column Is calculated as a column of the time and is displayed in the first row of the column title (step 606). For example, if the fiscal year end is the first half of 2004 and the processing period is “−1”, the second half of 2003 will be entered.

  If there is no registration information in the column title 2 (step 607), the pre-real category of the column information table (M2) is edited (budget / actual estimation / actual calculation / forecast, etc.), and the second column of the column title is displayed. It is displayed (step 609). The above is the processing of the column editing function S4.

  Furthermore, using the designated form number as a key, the display classification is acquired from the column information table (M2) in units of column numbers, and it is determined whether the input field of each column is protected or unprotected. When the display category is “display” (step 610), all the input fields in the column are protected (cannot be updated) to display only (step 611). If the display category is “update” (step 610), all input fields in the column are unprotected (protection canceled), and registration and updating are enabled (step 612). The above is the processing of the column protection editing function S5.

  FIG. 7 shows the processing contents of the form row editing function d13 of the input form editing function d1 in the data input form generation management system 1d. First, the user's login ID is used as a key from the user table (K1) for the user. A protection number is acquired (step 701).

  Next, the row information table (M3) is searched using the designated form number as a key, each piece of information (item code, item name, protection number) is obtained, and the row title editing function and the row are edited by the row title editing function S6. The row protection editing process by the protection editing function S7 is repeated (steps 702, 703, 711).

  First, the line title editing function S6 displays the contents as the title of the line if there is registration information in the item name (step 704), and if there is no registration information in the item name (step 704). The item name is acquired from the management item table (K4) using the item code of the row information table (M3) as a key (step 706) and displayed as the title of the row (step 707).

  Next, the row protection editing function S7 performs a comparison check between the protection number acquired from the user table (K1) in step 701 and the protection number acquired in step 703 (step 708), and the user manages the row. It is determined whether or not there is an input authority for the item. If the protection number of the user is not equal to or smaller than the protection number of the line, the input field of the line is protected and only displayed (cannot be updated) (step 709). If the protection number of the row ≦ the protection number of the relevant row, the input field of the relevant row is set as a non-protected field (data registration / updating is possible) (step 710).

  8A and 8B show the processing contents of the data search function d21 of the data display function d2 in the data input form generation management system 1d.

  The performance value input display field in the data entry form is a two-dimensional (column position X, row position Y) tabular format, and a key area (X, Y) for saving the search key of the performance table (T1) in a corresponding form. ), An editing method area (X, Y) for saving an editing method such as a display, and a data area (X, Y) for saving a performance value are prepared in advance.

  From the column information table (M2) and the row information table (M3) for the specified form number, the column position X is set in ascending order of the column numbers, and the row position Y is set in ascending order of the row numbers. X, Y) information and editing method area (X, Y) information are set, the performance table (T1) is searched with the search key saved in the key area (X, Y), and the performance value is stored in the data area. Retreat to (X, Y).

  The information saved in the key area (X, Y) includes a company code, a processing time, a prediction category, and an item code.

  The company code saves the company code specified by the user, the precautions category saves the acquired information from the column information table (M2), and the item code saves the information from the row information table (M3).

  The processing time differs depending on the type of the form number table (M1) of the designated form number. When the type is monthly, the processing month period of the column information table (M2) is set to the closing date of the closing period table (K3). If the type is for semi-annual or annual use, the processing month period of the column information table (M2) is added to the closing period of the closing period table (K3) and saved.

  Information saved in the editing method area (X, Y) includes a display category, a unit, the number of decimal places, and an item type. The information obtained from the column information table (M2) for the display category and the row information table (M3) for the unit and the number of decimal digits are saved respectively. As the item type, information acquired by searching the management item table (K4) with the item code of the row information table (M3) is saved.

  Information saved in the data area (X, Y) is a performance value. The achievement value is a search key saved in the key area (X, Y), and information obtained by searching the achievement table (T1) is saved.

  That is, in FIG. 8, first, the company information data (K2) is searched by company code to acquire information such as company currency and conversion month (step 801), and the form number table (M1) is searched by form number. Information such as type, yen foreign currency, etc. is acquired (step 802), and the current fiscal period information such as the fiscal year, fiscal year, etc. is retrieved by searching the financial period table (K3) (step 803).

  Then, all the column information tables (M2) are searched with the designated form number, and the processing of steps 805 to 817 is repeated (steps 804 and 818).

  First, information such as a column number, a processing month period, a preparatory category, and a display category is acquired from the column information table (step 805), and the column position (X) is set in ascending order of the column numbers (step 806).

  If the type acquired in step 802 is for monthly use (step 807), the processing time is calculated by “financial year + processing month period” (step 808), and if the type is for semi-annual use / annual use. (Step 807), the processing time is calculated by “financial year period + processing month period” (step 809).

  Next, all line information tables (M3) are searched with the designated form number, and the processing of steps 811 to 816 is repeated (steps 810 and 817).

  That is, first, information such as a line number, item code, unit, number of decimal digits, and protection number is acquired from the line information table (step 811), and the line position (Y) is set in ascending order of the line numbers (step 812). ). Also, the management item table (K4) is searched with the item code acquired in step 811 to acquire information such as item type (step 813).

  Then, a search key for the performance table (T1) is set, and the company code, processing time, forecast category, and item code are saved in the key area (X, Y) (step 814), and the performance value in the performance table (Y1) Edit information (display category, unit, number of decimal digits, item type) is saved in the edit method area (X, Y) (step 815), the achievement table (T1) is searched, and the achievement value is stored in the data area (X, Y). (Step 816).

  FIG. 9 shows the processing contents of the automatic calculation function d22 of the data display function d2 in the data input form generation management system 1d.

  The information is obtained from the automatic calculation formula table (M4) using the designated form number as a key, the formula is assembled in the calculation formula unit, and the calculation result is calculated. The operator of the automatic calculation formula table (M4) is The column row position (X, Y) is set from the column number and the row number, respectively, as the calculation destination when the operator is “=” and as the calculation source when the operator is other than “=”. A performance value as a calculation source value is acquired from the data area (X, Y), and when a fixed value is registered, the fixed value is used as the calculation source value and a calculation result is calculated according to the calculation formula.

  At the timing when the calculation formula breaks, the calculation result is set in the data area (X, Y) corresponding to the column row position (X, Y) of the calculation destination.

  That is, all the automatic calculation formula tables (M4) are searched with the designated form number, and the processing of steps 902 to 912 is repeated (step 913). First, information such as column numbers, row numbers, fixed values, operators, etc. is acquired from the automatic calculation formula table (step 902).

  If the acquired operator is not a break (next calculation formula) (step 903), it is determined whether or not the operator is "=" and requires calculation destination information (step 904). If necessary, the column row position (X, Y) of the calculation destination is set from the column number and the row number, and the processing returns to step 903 (step 905). If the calculation destination information is not required, it is registered as a fixed value. It is determined whether or not there is (step 906).

  If the fixed value is not registered, the column row position (X, Y) of the calculation source is set from the column number and the row number (step 907), and the data area (X, Y) corresponding to the column row position of the calculation source is set. The value of the performance data is acquired (step 908), the performance value is saved as the calculation source value of the calculation formula (step 909), and if the fixed value is registered, the value registered in the fixed value is The calculation source value is saved (step 911), the calculation destination value is calculated according to the operator using the saved calculation source value (step 910), and the processing returns to step 903.

  In step 903, if the operator acquired in step 902 is a break (next calculation formula), the calculated calculation destination value is set in the data area (X, Y) corresponding to the column row position of the calculation destination. (Step 912) The process ends.

  10A and 10B show the processing contents of the display editing function d23 of the data display function d2 in the data input form generation management system 1d.

  The display editing function d23 has a conversion rate setting function S8, a foreign currency conversion function S9, a unit conversion function S10, and a decimal number editing function S11.

  First, in the conversion rate setting function S8, a rate search is performed by the processing of steps 1001 to 1007 in FIG. That is, if the specified company code is an overseas company (company information table (K2) company currency ≠ JPY) and the form number is displayed in yen (foreign currency foreign currency = yen display in the form number table (M1)) Therefore, the conversion rate is acquired from the rate table (K5).

  The company currency that is the search key for the rate table (K5) is set in the information in the company information table (K2), but for the rate date, the type in the form number table (M1) and the settlement in the settlement period table (K3) It depends on the fiscal year.

  When the type is monthly, the fiscal year and month of the fiscal year table (K3) is set, and when the type is half-year and the fiscal year is the first half, the fiscal year and company information table (K2) of the fiscal year table (K3) The conversion month [first half] is set, and if the classification is for half-year and the settlement period is in the second half or the classification is annual, the settlement year in the settlement period table (K3) and the conversion month in the company information table (K2) [second half] Set. Then, the conversion rate is acquired from the rate table (K5) using the set search key.

  After the processing by the conversion rate setting function S8, information such as the display category, unit, number of decimal digits, item type, etc. is acquired from the editing method area (X, Y) in which the performance value editing information is saved (step 1009). ), The process branches according to the item type (step 1010).

  If the item type is a monetary amount, first, in the foreign currency conversion function S9, an editing method area (X, Y) in which editing information relating to the performance value of the data area (X, Y) is saved by the processing of steps 1011 to 1012 in FIG. Y) is determined, and if the item type is monetary and the conversion rate is set, the exchange rate is reflected in the performance value of the data area (X, Y) and the foreign currency is converted.

  Thereafter, in the unit conversion function S10, by the processing of steps 1013 to 1016 in FIG. 10B, 1/1000 if the unit is 1,000, 1/10000 if 10,000, and 1/1000000 if million. And the performance value in the data area (X, Y) is converted according to the unit.

  If the determination result in step 1010 is rate, person, time, etc., the decimal point conversion of the performance value is performed in the decimal conversion function S11 by the processing of steps 1017 to 1019 in FIG.

  11A and 11B show the processing contents of the input data check function d31 of the data storage function d3 in the data input form generation management system 1d, and information from the check type table (M5) using the designated form number as a key. Is obtained, the formula is assembled in the formula unit, the calculation result is calculated, and whether the input achievement value and the calculation result match the conditional formula is checked.

  The operator of the check expression table (M5) is determined. When the operator is “=”, the input destination of the user, and when the operator is other than “=”, the calculation source is the column number and the row number. Set column row position (X, Y). A performance value as a calculation source value is acquired from the data area (X, Y), and when a fixed value is registered, the fixed value is used as the calculation source value and a calculation result is calculated according to the calculation formula.

  Then, at the timing when the calculation formula breaks, it is checked whether the achievement value at the input destination column row position (X, Y) and the calculation result match the conditional expression.

  More specifically, all the check type tables (M5) are searched with the designated form number, and the processing of steps 1102 to 1115 is repeated (steps 1101 and 1116). First, information such as column numbers, row numbers, fixed values, operators, etc. is acquired from the check expression table (M5) (step 1102).

  If the acquired operator is not a break (next calculation formula) (step 1103), the operator is “>”, “≧”, “=”, “≦”, “<”, and information on the calculation destination is required. (Step 1104), and if calculation destination information is required, the column row position (X, Y) of the input achievement value is set from the column number and the row number, and the process proceeds to Step 1110 ( Step 1105) If no calculation destination information is required, it is determined whether or not there is a registration for a fixed value (step 1106).

  If the fixed value is not registered, the column row position (X, Y) of the calculation source is set from the column number and the row number (step 1107), and the data area (X, Y) corresponding to the column row position of the calculation source is set. The achievement value is acquired (step 1108), the achievement value is saved as the calculation source value of the calculation formula (step 1109), and if the fixed value is registered, the value registered in the fixed value is calculated The value is saved as a value (step 1111), the calculated value is calculated according to the operator using the saved calculation source value (step 1110), and the process proceeds to step 1112.

  In step 1112, information input from the input screen (saved business values of saved column row positions X and Y) is acquired. Then, in step 1113, whether the calculation result and the input business value match the conditional expression. Determine whether or not.

  If the input achievement value and the conditional expression do not match (step 1114), an input error is displayed (step 1115), and the process is terminated using the check form table (M5) of the designated form number (step 1116).

  FIG. 12 shows the processing contents of the data storage function d32 of the data storage function d3 in the data input form generation management system 1d, and the editing method area (X, Y) in which editing information relating to the performance value of the data area (X, Y) is saved. ) And the display category is updated, the storage destination key is set from the key area (X, Y), the achievement value is set from the data area (X, Y), and stored in the achievement table (T1). To do.

  Specifically, for all data areas (X, Y) in which achievement values are saved (step 1202), first, if the display category of the editing method area (X, Y) is updated (step 1202), the key Acquire information such as company code, processing time, predictive classification, item code, etc. from the key area (X, Y) from which information was saved (step 1203), and from the data area (X, Y) from which achievement values were saved The achievement value is acquired (step 1204).

  Then, the storage key (company code, processing time, forecast / classification, item code) of the performance table (T1) is set (step 1205), and the performance value stored in the performance table (T1) is set (step 1206). The result is stored in the performance table (T1) (step 1207).

  As described above with reference to FIGS. 1 to 12, in the data input form generation management system of this example, screen editing information such as the display contents and display method of the data input form is registered in advance as master data. Based on the screen editing information, the data input form is generated and displayed, and the data input in the data input form is registered.

  That is, the data input form generation management system 1d of this example generates and changes a data input form consisting of a plurality of rows and a plurality of columns, and is attached to any one of the plurality of data input forms. A column information table M2 for storing item names of one or more columns input in advance from the input device in association with the identification information, and one or more input in advance from the input device in association with the identification information of the data input form. A row information table M3 that stores row item names, and column information table M2 that stores one or more column item names and one or more row item names associated with identification information of a data input form input from an input device. And an input form editing function d1 that reads out from the line information table M3, generates a data input form including the read item name row and item name column, and displays the data input form on the display device. And butterflies. The input form editing function d1 has a form string editing function d12 and a form row editing function d13. By these functions d12 and d13, a new data input form is added to the displayed data input form. Add a column item name or row item name.

  Thus, according to this example, a new data input form (screen) can be easily created by simple master registration. In addition, the layout of existing data entry forms (screens) can be easily changed by simple master update (item change [order received → sales], unit change [local price → thousand local price], range change [four periods → 6 Epoch] etc.) becomes possible. Further, it is not necessary to individually develop (new / remodeled etc) data processing programs corresponding to input forms (screens).

  In addition, this invention is not limited to the example demonstrated using FIGS. 1-12, A various change is possible in the range which does not deviate from the summary. For example, in this example, the computer 1 and the terminal computers 2 and 3 are connected via the intranets 4 and 5, but the Internet may be used for connection. Alternatively, a LAN may be used.

  Also, the computer configuration example of this example may be a computer configuration without a keyboard or optical disk drive. In this example, an optical disk is used as a recording medium, but an FD (Flexible Disk) or the like may be used as a recording medium. As for the program installation, the program may be downloaded and installed via a network via a communication device.

It is a block diagram which shows the example of a computer network structure provided with the data input form production | generation management system concerning this invention. It is a block diagram which shows the function structural example of the data input form production | generation management system concerning this invention. It is explanatory drawing which shows 1/3 part of the registration content example in the common master used in the data input form production | generation management system concerning this invention, an input form management master, a performance table, and a save area. It is explanatory drawing which shows the 2/3 part of the registration content example in the common master used in the data input form production | generation management system concerning this invention, an input form management master, a performance table, and a save area. It is explanatory drawing which shows the 3/3 part of the registration content example in the common master used in the data input form production | generation management system concerning this invention, an input form management master, a performance table, and a save area. It is explanatory drawing which shows the detail of the user table in FIG. It is explanatory drawing which shows the detail of the company information table in FIG. It is explanatory drawing which shows the detail of the account settlement period table in FIG. It is explanatory drawing which shows the detail of the management item table in FIG. It is explanatory drawing which shows the detail of the currency rate table in FIG. It is explanatory drawing which shows the detail of the number table in FIG. It is explanatory drawing which shows the detail of the column information table in FIG. It is explanatory drawing which shows the detail of the line information table in FIG. It is explanatory drawing which shows the detail of the automatic calculation formula table in FIG. It is explanatory drawing which shows the detail of the check type | formula table in FIG. It is explanatory drawing which shows the detail of the performance table in FIG. It is a flowchart which shows the first half part of the processing operation example regarding the check function of the data input form production | generation management system concerning this invention. It is a flowchart which shows the second half part of the processing operation example regarding the check function of the data input form production | generation management system concerning this invention. It is a flowchart which shows the example of a document row | line edit process operation of the data input form production | generation management system concerning this invention. It is a flowchart which shows the example of a form line edit process operation of the data input form production | generation management system concerning this invention. It is a flowchart which shows the first half part of the processing operation example regarding the data search of the data input form production | generation management system concerning this invention. It is a flowchart which shows the second half part of the processing operation example regarding the data search of the data input form production | generation management system concerning this invention. It is a flowchart which shows the processing operation example regarding the automatic calculation of the data input form production | generation management system concerning this invention. It is a flowchart which shows the first half part of the processing operation example regarding the display edit of the data input form production | generation management system concerning this invention. It is a flowchart which shows the latter part of the processing operation example regarding the display edit of the data input form production | generation management system concerning this invention. It is a flowchart which shows the first half part of the processing operation example regarding the input data check of the data input form production | generation management system concerning this invention. It is a flowchart which shows the second half part of the processing operation example regarding the input data check of the data input form production | generation management system concerning this invention. It is a flowchart which shows the first half part of the processing operation example regarding the data storage of the data input form production | generation management system concerning this invention.

Explanation of symbols

  1: computer, 1a: input form management master, 1b: common master, 1d: data input form generation management system, 2, 3: terminal computer, 2a: master registration function, 3a: data input form, 4, 5: intranet, d1: input form edit function, d11: check function, d12: form row edit function, d13: form row edit function, d2: data display function, d21: data search function, d22: automatic calculation function, d23: display edit function, d3: data storage function, d31: input data check function, d32: data storage function, M1: form number table, M2: column information table, M3: row information table, M4: automatic calculation formula table, M5: check formula table, K1: User table, K2: Company information table, K3: Financial period table, K4: Management item table K5: Rate table, S1: User check function, S2: Domestic and overseas check function, S3: Deadline check function, S4: Column title editing function, S5: Column protection editing function, S6: Row title editing function, S7: Row Protection editing function, S8: Conversion rate setting function, S9: Foreign currency conversion function, S10: Unit conversion function, S11: Decimal number editing function, T1: Achievement value table.

Claims (11)

A data input form generation management system that includes an input device, a display device, a storage device, and a processing device that performs computer processing using a program, and generates and changes a data input form consisting of a plurality of rows and a plurality of columns. ,
Column information storage processing means for storing item names of one or more columns input in advance from an input device in association with identification information given to any one of a plurality of data input forms;
Line information storage processing means for storing item names of one or more lines previously input from the input device in association with identification information of the data input form;
Read and read the item names of one or more columns and the item names of one or more rows associated with the identification information of the data input form input from the input device from the column information storage processing means and the row information storage means A data input form generation management system comprising: form processing means for generating a data input form including a row of item names and a column of item names and displaying the form on a display device. A data input form generation management system according to claim 1,
The form processing means is
A data input form generation management system comprising means for adding a new column item name or row item name to the data input form in response to a user operation on the displayed data input form. A data input form generation management system according to claim 1 or 2,
User restriction management means for preliminarily storing conditions for restricting user operations on the data input form displayed by the form processing means according to user identification information;
Use for restricting the operation of the user on the data input form by reading out the operation restriction condition corresponding to the user identification information input together with the identification information of the data entry form from the input device with reference to the user restriction management means. A data input form generation management system characterized by having a person checking means. A data input form generation management system according to any one of claims 1 to 3,
An operation time limit management means for preliminarily storing a condition for restricting a user's operation on the data input form displayed by the form processing means according to a time zone;
The user's operation execution time for the data input form is compared with the time zone stored by the operation time restriction management means to specify the restriction condition, and the user operation for the data input form is restricted according to the specified restriction condition. A data input form generation management system comprising an operation time limiter. A data input form generation management system according to any one of claims 1 to 4,
Data correct / incorrect condition management means for preliminarily storing the conditions for determining the correctness of data input to the data input form by specifying the column items and row items constituting the data input form,
A data input form generation management system, comprising: an input data check unit that determines whether data input by the user with respect to the data input form is correct or not according to a condition stored by the data correct condition management unit. A data input form generation management system according to any one of claims 1 to 5,
Data storage means for storing a user's data input result for the data input form displayed by the form processing means;
A data input form generation management system comprising: data display means for reading the data input result from the data storage means and embedding it in the data input form and displaying it on the display device. A data input form generation management system according to any one of claims 1 to 6,
The data entry form includes an arithmetic expression using each data in a plurality of column items as a column item, and has an automatic calculation means for displaying a calculation result by the arithmetic expression in the column item area. Data entry form generation management system. A data input form generation management system according to any one of claims 1 to 7,
Column management means for preliminarily storing conditions for restricting user operations on the columns of data input forms displayed by the form processing means according to user identification information;
An operation restriction condition corresponding to the user identification information input together with the identification information of the data input form from the input device is read from the column management means, and the user's column of the data input form is read according to the read operation restriction condition. A data input form generation management system characterized by comprising a column check means for restricting operations. A data input form generation management system according to any one of claims 1 to 8,
A line management means for preliminarily storing a condition for restricting a user's operation on a line of the data input form displayed by the form processing means according to user identification information;
An operation restriction condition corresponding to the user identification information input together with the identification information of the data input form from the input device is read from the row management unit, and the line of the data input form of the user is read according to the read operation restriction condition. A data input form generation management system comprising line check means for restricting operations. A data input form generation management system according to any one of claims 1 to 9,
Column item display means for displaying all column item names stored in the column information storage processing means on a display device;
A data entry form generation management system comprising line item display means for displaying all line item names stored in the line information storage processing means on a display device.   The program for functioning a computer as each means in the data input form production | generation management system in any one of Claims 1-10.

Images