JP5709559B2 - Master maintenance device, master maintenance method, and master maintenance program - Google Patents

Description

  The present invention relates to a master maintenance device, a master maintenance method, and a master maintenance program.

  Patent Document 1 discloses a technology for extracting information necessary for development of a master maintenance system from a master maintenance design product, converting the extracted information into a code, and executing the obtained code to generate a master maintenance screen. Has been.

JP 2010-157165 A

  However, according to the prior art, when an operator exceeding the limit value of the number of used operator licenses is newly registered, or when data in the master exists in actual data such as billing data or sales data, If the data is corrected or deleted, or if the data is deleted from the master of only one data, an unnecessarily large amount of data is registered, or the actual data and the master There is a problem that an unfavorable situation may occur in the operation of the master maintenance such that consistency between the two cannot be ensured or there is a master without data.

  The present invention has been made in view of the above, and an object of the present invention is to provide a master maintenance device, a master maintenance method, and a master maintenance program that can improve the convenience in operation of master maintenance.

  In order to solve the above-described problems and achieve the object, a master maintenance device according to the present invention is a master maintenance device including a control unit, a storage unit, and a display unit, and is newly registered and modified in the storage unit. And a character string related to a command for performing a predetermined process is stored for each processing category including deletion, and when the control unit receives an instruction to newly register data, the control unit uses the master for maintenance. Based on the maintenance target master specified in advance on the master maintenance screen displayed in advance on the display unit, and when receiving an instruction to correct or delete data, the maintenance target master and the master Based on the maintenance target data in the master specified in advance on the maintenance screen, the instruction corresponding to the instruction In the case where the predetermined process specified by the character string of the physical classification is executed, and confirmation means for confirming whether or not the instruction is permitted based on the execution result, and when the instruction relates to new registration When the confirmation result by the confirmation means is that the instruction is permitted, the master maintenance screen displayed on the display unit is changed to the master maintenance screen in a state where data can be input. When the instruction relates to correction or deletion, the master maintenance screen displayed on the display unit is displayed in a form in which the data to be maintained corresponds to the instruction and the confirmation result of the confirmation means. And a screen control means for making a transition to the master maintenance screen outputted in (1).

  Further, a master maintenance method according to the present invention includes a control unit, a storage unit storing a character string related to a command for performing a predetermined process for each processing category including new registration, correction, and deletion, a display unit, A master maintenance method executed by an information processing apparatus including: when an instruction for new registration of data executed by the control unit is received, is displayed in advance on the display unit used for master maintenance Based on the maintenance target master specified in advance on the master maintenance screen, and when a data correction or deletion instruction is received, the maintenance target master and the master maintenance screen And the character of the processing classification corresponding to the instruction based on the maintenance target data in the master A confirmation step for executing the predetermined processing specified in step (b) and confirming whether or not the instruction is permitted based on the execution result; and a confirmation in the confirmation step when the instruction relates to new registration When the result is that the instruction is permitted, the master maintenance screen displayed on the display unit is changed to the master maintenance screen in a state where data can be input, and the instruction is corrected or changed. If it is related to deletion, the master maintenance screen displayed on the display unit, the maintenance target data is output in a form according to the instruction and the confirmation result in the confirmation step And a screen control step for transitioning to a master maintenance screen.

  A master maintenance program according to the present invention includes a control unit, a storage unit storing a character string related to a command for performing a predetermined process for each processing category including new registration, correction, and deletion, a display unit, A master maintenance program to be executed by an information processing apparatus provided with an information processing apparatus, and when a new data registration instruction to be executed by the control unit is received, it is displayed in advance on the display unit used for master maintenance. Based on the maintenance target master specified in advance on the master maintenance screen, and when receiving an instruction to modify or delete data, specify the maintenance target master and the master maintenance screen in advance. Based on the maintenance target data in the master. A step of executing the predetermined processing specified by the character string of the processing classification and confirming whether or not to permit the instruction based on the execution result; and when the instruction relates to new registration When the confirmation result in the confirmation step is to allow the instruction, the master maintenance screen displayed on the display unit is changed to the master maintenance screen in a state where data can be input, Further, when the instruction is related to correction or deletion, the master maintenance screen displayed on the display unit corresponds to the maintenance target data according to the instruction and the confirmation result in the confirmation step. And a screen control step for transitioning to the master maintenance screen output in the form.

  According to the present invention, the storage unit stores a character string related to an instruction for performing a predetermined process for each processing category including new registration, correction, and deletion. When a new registration instruction is received, an instruction to modify or delete data is received based on the maintenance target master specified in advance on the master maintenance screen displayed in advance for master maintenance. In this case, based on the maintenance target master and the maintenance target data in the master specified in advance on the master maintenance screen, a predetermined character string specified by the processing category corresponding to the instruction is specified. And confirming whether or not to allow the instruction based on the execution result, and (ii) if the instruction is related to new registration If the confirmation result is that the instruction is permitted, the displayed master maintenance screen is changed to a master maintenance screen in which data can be input, and the instruction is related to correction or deletion. In this case, the displayed master maintenance screen is changed to a master maintenance screen in which the maintenance target data is output in a form corresponding to the instruction and the confirmation result. Thereby, there is an effect that the convenience in operation of the master maintenance can be improved.

FIG. 1 is a block diagram illustrating an example of the configuration of the master maintenance device. FIG. 2 is a diagram illustrating an example of a general-purpose business check master. FIG. 3 is a flowchart illustrating an example of the main process. FIG. 4 is a diagram illustrating an example of the general-purpose master maintenance screen in the initial state. FIG. 5 is a diagram illustrating an example of a general-purpose master maintenance screen when a maintenance target is selected. FIG. 6 is a diagram illustrating an example of a general-purpose master maintenance screen when a data list is displayed. FIG. 7 is a diagram illustrating an example of a general-purpose master maintenance screen when new data is registered. FIG. 8 is a diagram illustrating an example of a general-purpose master maintenance screen at the time of data correction registration. FIG. 9 is a diagram illustrating an example of a general-purpose master maintenance screen at the time of data deletion registration. FIG. 10 is a diagram illustrating an example of an error message dialog. FIG. 11 is a diagram illustrating an example of a general-purpose master maintenance screen at the time of data inquiry. FIG. 12 is a diagram illustrating an example of a general-purpose master maintenance screen when a data list is displayed. FIG. 13 is a diagram illustrating an example of a general-purpose master maintenance screen at the time of data correction registration. FIG. 14 is a diagram illustrating an example of a general-purpose master maintenance screen when a data list is displayed. FIG. 15 is a diagram illustrating an example of a general-purpose master maintenance screen at the time of data correction registration. FIG. 16 is a diagram illustrating an example of the condition item selection screen. FIG. 17 is a diagram illustrating an example of the operator selection screen. FIG. 18 is a diagram illustrating an example of a file output screen.

  Embodiments of a master maintenance device, a master maintenance method, and a master maintenance program according to the present invention will be described in detail with reference to the drawings. In addition, this invention is not limited by this embodiment.

[1. Constitution]
An example of the configuration of the master maintenance device according to the present embodiment will be described with reference to FIG. The master maintenance device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part with which the master maintenance apparatus 100 is provided is connected so that communication is possible via arbitrary communication paths.

  The communication interface unit 104 communicatively connects the master maintenance device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via a communication line.

  An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker (including a home television), a speaker, and a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that realizes a pointing device function in cooperation with the mouse can be used. In the following description, the output device 114 may be described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112.

  The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 stores a computer program for giving various instructions to the CPU in cooperation with an OS (Operating System). The storage unit 106 includes a master storage unit 106a. As the storage unit 106, for example, a memory device such as a RAM / ROM, a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used.

  The master storage unit 106a stores definition masters such as a general purpose main master, a general purpose edit master, an extraction condition master, and a general purpose business check master. Note that these definition masters may be stored in an external server 200 that is communicably connected to the master maintenance apparatus 100 via a network 300 such as the Internet, an intranet, and a LAN (Local Area Network).

Here, the general-purpose Main master is a master table including data on the following items.
・ Company CD
・ EditID
・ Process classification: “0”: Master maintenance
“1”: Data output
“2”: Data maintenance • Edit name: Screen display name • Target view: Process classification is 0 or 2 → Screen list
Processing category is 1 → Data extraction / target table: Processing category is 0 or 2 → Update target
Process classification is 1 → unnecessary ・ Authority: Link with authority value of operator master “0”: General, “1”: Administrator / Arrangement order / General-purpose GroupID: Process classification is 0 or 2 → Unnecessary ・ KeyIndex 1-5: Processing Division is 0 or 2 → Edit from list
Key at the time of transition to the screen
Compatible with View items
Processing category is 1 → unnecessary

The general-purpose Edit master is a master table that includes data relating to the following items.
・ Company CD
・ EditID
・ Item No.
-Item name: Screen display name-Item Type: "0": Normal
“1”: Item description → Label displayed next to the item
“2”: Master check only → Invalid error
“3”: External reference → when valid, acquired data display / data type: “1”: numeric value
“2”: Character
“3”: Amount
“4”: Date
“5”: Year
“6”: Alphanumeric characters
“7”: Half-width kana
"9": Revision date / input not possible FLG: "0": Possible
“1”: Impossible / required FLG: “0”: Optional
"1": Mandatory-ControlWidth
-Number of digits: Number of bytes-Maximum value-Minimum value-Search activation FLG: "0": No search-SubLabel name: Display contents when item Type = 1-Reference table: When item Type = 2 or 3 Reference destination / reference item: Reference destination item / reference result display item when item Type = 2 or 3 Reference destination acquisition item / reference classification type when item Type = 3: Item Type = 3 and common category reference Time / Company for reference: Use company CD for reference / update item: Update item name / company classification: “0”: Other than company CD
“1”: Company CD
-Initial value-KeyFLG: "0": Other than Key item
“1”: Key item / Key duplication check FLG: “0”: No check
“1”: Checked
When all items with KeyFLG of 1 are checked
Presence check
Duplicate error parameter number when valid: Link with key index number of general purpose main master
KeyIndex1 → “1”, KeyIndex4 → “4”

The extraction condition master is a master table including data on the following items.
・ Company CD
-Extraction target: target table, View name-Target classification: "0": Master
“1”: Search / Row number: Display order / Real column name: Target table, View real column name / Display name: Display name / number of digits in search: Number of real column digits / Data type: “1”: Numerical value
“2”: Character
“3”: Amount
“4”: Date
“5”: Year
“6”: Character (Code)
“7”: Half-width kana
“9”: Revision date / search activation FLG: “0”: No
“1”: Yes • Search extraction target • Return value FLG: “0”: None
“1”: Return value
When 1 is returned, the search result is returned. Result display FLG: “0”: No display
“1”: Display
When 1, the name is displayed

Further, as shown in FIG. 2, the general-purpose business check master is a master table including data on the following items.
-EditID: Key item linked to a general-purpose master maintenance screen described later-No: Serial number-Name: Name-Check query: Query character string used for checking-ReplaceKey1-4: Character strings 1-4 replaced in the query character string
Interlocking with parameters at the time of screen transition / Processing category: New / Modified / Deleted Result FLG: True / False
The query string result is True / False.
・ Invalid FLG: Valid / Invalid ・ Message: NG message

  Returning to FIG. 1, the master storage unit 106a stores masters such as a company master, a transfer fee master, and a bank master. For example, the bank master is a master table including data relating to a plurality of items such as bank CD, bank name, bank name Kana, registration person CD, registration date, registration time, update person CD, update date, and update time. . Note that these masters may be stored in the external server 200. Further, actual data such as billing data or sales data including the master data may be stored in the storage unit 106 or the external server 200.

  The control unit 102 is a CPU (Central Processing Unit) that controls the master maintenance device 100 in an integrated manner. The control unit 102 has an internal memory for storing a control program such as an OS (Operating System), a program that defines various processing procedures, and necessary data, and performs various information processing based on these programs. Run. The control unit 102 includes a screen control unit 102a, a confirmation unit 102b, and a registration unit 102c in terms of functional concept.

  The screen control unit 102a creates various screens such as a general-purpose master maintenance screen used for maintenance of each master stored in the master storage unit 106a, and displays the created screen on the output device 114. In addition, about the example of the process which the screen control part 102a implements, the following [2. Processing] will be described in detail.

  The confirmation unit 102b is a feature of the present invention. Upon receiving an instruction for new data registration, data correction registration, or data deletion registration from the user, the confirmation unit 102b is selected by the user as a maintenance target with reference to the general-purpose business check master. Whether to allow the user to register the data in the master, modify the data in the record selected by the user included in the master, or delete the data in the record included in the master as instructed Confirm. Specifically, when the confirmation unit 102b receives an instruction for new data registration, when the operator is newly registered in the master, the number of registrations of the operator is set as a limit value of the number of operator licenses set in advance ( Check whether the upper limit is exceeded. Specifically, when the confirmation unit 102b receives an instruction for data correction registration or data deletion registration, whether the data in the record included in the master exists in the actual data such as billing data or sales data. (Whether it is used in performance data) or not. Specifically, when the confirmation unit 102b receives a data deletion registration instruction so that the number of records in the master does not become zero, whether or not the master includes only one record. To check. In addition, about the specific example of the process which the confirmation part 102b implements, the following [2. Processing] will be described in detail.

  When the registration unit 102c receives a registration instruction from the user, at the time of new registration or correction registration, the data displayed in a predetermined edit box in the general-purpose master maintenance screen is transferred to the master selected by the user as a maintenance target. At the time of registration (including overwriting) and deletion registration, data displayed in a predetermined edit box in the general-purpose master maintenance screen is deleted from the master.

[2. processing]
An example of main processing performed by the master maintenance device 100 having the above-described configuration will be described with reference to FIG.

  First, the screen control unit 102a displays the general-purpose master maintenance screen MA in the initial state shown in FIG. 4 on the monitor 114 (step SA1). Here, the general-purpose master maintenance screen MA shown in FIG. 4 roughly includes an area MA1 and an area MA2. The area MA1 includes a selection button for causing the user to select a desired master maintenance object to be maintained, an edit box for displaying the selected master, and the like. The area MA2 is roughly divided into an area MA21 and an area MA22. The area MA21 includes a plurality of selection buttons for allowing the user to select extraction conditions including condition items, operators, condition values, etc., an edit box for displaying the selected extraction conditions, and the like. The area MA22 is for displaying a view relating to a list of data extracted (searched) by the process performed by the control unit 102.

  The user presses the selection button included in the area MA1 using the mouse 112 in order to select the master maintenance to be maintained.

  Upon receiving the press (Step SA2: Yes), the screen control unit 102a acquires EditID data and Edit name data registered as maintenance targets from the general-purpose main master, and the acquired EditID data and Edit name are acquired. Are output to the area MA22 (step SA3). As a result, the general-purpose master maintenance screen MA changes (transitions) from the state shown in FIG. 4 to the state shown in FIG. 5 in which EditID data and Edit name data are displayed as a list.

  The user double-clicks the record displaying the desired name to be maintained using the mouse 112. In this description, it is assumed that a record whose Edit name is “bank master maintenance” is double-clicked.

  When the screen control unit 102a receives the double click (step SA4: Yes), the screen control unit 102a outputs the EditID “MS_Ginkou” and the Edit name “bank master maintenance” of the double clicked record to the area MA1 (step SA5). Further, the screen control unit 102a refers to the general-purpose Main master to identify the master corresponding to the EditID “MS_Ginkou”, and from the identified master (in this description, the bank master whose ID is “MS_GINKOU”) Data of each item included in the master is extracted (searched), and the extracted data is output to the area MA22 (step SA5). As a result, the general-purpose master maintenance screen MA changes (transitions) from the state of FIG. 5 to the state of FIG. 6 in which EditID and Edit name are displayed and the data of each item included in the identified master is listed. To do.

  When the user wants to newly register data in the bank master, the user presses the function key F2 that functions to select new data registration. When the user wants to correct the data registered in the bank master, the user double-clicks the record to be corrected displayed in the area MA22 using the mouse 112 in order to select the data correction registration. Or select the record using the mouse 112 and then press the Enter key. When the user wants to delete the data registered in the bank master, the user selects the record to be deleted displayed in the cutting area MA22 using the mouse 112, and then selects the data deletion registration. The function key F3 that functions is pressed down.

  When the confirmation unit 102b receives any of these presses or double-clicks (step SA6: Yes), the confirmation unit 102b refers to the general-purpose business check master and checks the business at the time of new data registration, data correction registration, or data deletion registration. Processing is performed (step SA7).

  Here, the business check process, which is a feature of the present invention, performed in step SA7 will be described in detail. In this description, it is assumed that the general-purpose business check master is as shown in FIG.

[A: Business check process when registering new data]
First, when the confirmation unit 102b receives a press of the function key F2, the confirmation unit 102b searches the general-purpose job check master for a record whose processing category is “new”. In the present description, a record whose process category is “new” is not searched.

  Next, the confirmation unit 102b transfers a determination result indicating that new data registration is possible to the screen control unit 102a when a record having the process classification “new” is not found.

  Note that a record whose processing classification is “new” includes, for example, a Check query for determining “whether an operator exceeding the limit value (upper limit value) of the number of used operator licenses will be registered?”. In the case where an item has been registered in the general-purpose business check master, the confirmation unit 102b (1) can execute the Check query to allow the user to newly register an operator as instructed. (2) When the number of acquired data items by the executed Check query is larger than 0, “True” is determined. When the number of acquired data items is 0, “False” is determined. Check whether the result matches the result FLG included in the record. (3) If the check result matches the result FLG, The determination result indicating that the registration is not possible is transferred to the image control unit 102a together with the message included in the record, and if the confirmation result does not match the result FLG, the determination is made that new data registration is possible The result is transferred to the image control unit 102a.

[B: Business check process during data correction registration]
First, when the confirmation unit 102b receives a double click or presses the Enter key, the confirmation unit 102b searches the general-purpose job check master for a record whose processing classification is “correction”. In this description, one record having a process classification “correction” is searched.

  Next, the confirmation unit 102b sets Key1 “@okikae” as the ReplaceKey included in the retrieved record, and further specifies “bank CD = '@ okikae'” in the Check query included in the record. Therefore, the part of “@okikae” in the Check query is replaced with the bank CD “0001” included in the record to be corrected selected in the area MA22, and the Check query “SELECT * FROM billing data WHERE after the replacement Bank CD = '0001' "is executed. Thus, “whether there is a maintenance target bank in the billing data” is determined.

  Next, the confirmation unit 102b determines “True” when the number of acquired data items according to the executed Check query is greater than 0, and determines “False” when the acquired data number is 0. It is confirmed whether or not the result matches the result FLG included in the retrieved record.

  Next, when the confirmation result matches the result FLG, the confirmation unit 102b transfers the determination result that data correction registration is impossible together with the message included in the retrieved record to the image control unit 102a. If the confirmation result does not coincide with the result FLG, a determination result indicating that data correction registration is possible is transferred to the image control unit 102a.

[C: Business check process at the time of data deletion registration]
First, when the confirmation unit 102b receives a press of the function key F3, the confirmation unit 102b searches the general-purpose job check master for a record whose processing category is “deleted”. In this description, two records are searched for a record whose processing category is “delete”, a record whose No is “2” and a record whose No is “3”.

  Next, the confirmation unit 102b sets Key1 “@okikae” as the ReplaceKey included in the searched higher-level record (the record whose No is “2”), and further, in the Check query included in the record, “Bank” Since “CD = '@ okikae'” is designated, the “@okikae” portion in the Check query is replaced with the bank CD “0001” included in the record to be deleted selected in the area MA22. The subsequent Check query “SELECT * FROM sales data WHERE bank CD = '0001'” is executed. Thus, “whether there is a maintenance target bank in the sales data” is determined.

  Next, the confirmation unit 102b determines “True” when the number of acquired data items according to the executed Check query is greater than 0, and determines “False” when the acquired data number is 0. It is confirmed whether or not the result matches the result FLG included in the retrieved upper record.

  Next, when the confirmation result matches the result FLG, the confirmation unit 102b sends a determination result indicating that data deletion registration is impossible to the image control unit 102a together with the message included in the retrieved upper record. If the confirmation result does not match the result FLG, the determination result indicating that the data deletion registration is possible is transferred to the image control unit 102a.

  Next, since nothing is set in the ReplaceKey included in the searched lower-level record (the record whose No is “3”), the confirmation unit 102b checks the Check query “SELECT Count (*) included in the record. as number of items FROM bank master WHERE number of cases = 1 ”is executed as it is. Thereby, “whether the number registered in the bank master is 1 or not” is determined.

  Next, the confirmation unit 102b determines “True” when the number of acquired data items according to the executed Check query is greater than 0, and determines “False” when the acquired data number is 0. It is confirmed whether or not the result matches the result FLG included in the retrieved lower level record.

  Next, when the confirmation result matches the result FLG, the confirmation unit 102b notifies the image control unit 102a of the determination result indicating that the data deletion registration is impossible together with the message included in the retrieved lower record. If the confirmation result does not match the result FLG, the determination result indicating that the data deletion registration is possible is transferred to the image control unit 102a.

  This completes the description of the business check process.

  Next, when the screen control unit 102a receives the determination result transferred from the confirmation unit 102b to enable new data registration, data correction registration, or data deletion registration (step SA8: Yes), FIG. The general master maintenance screen MA at the time of new data registration shown, the general master maintenance screen MA at the time of data correction registration shown in FIG. 8, or the general master maintenance screen MA at the time of data deletion registration shown in FIG. Thus, the general-purpose master maintenance screen MA is changed (transitioned) from the state shown in FIG. 6 to the state shown in FIG. 7, FIG. 8, or FIG. 9 (step SA9).

  Here, the process performed in step SA9 will be described in detail.

  First, the screen control unit 102a searches the general edit master for a record whose Edit ID is “MS_Ginkou” displayed in the area MA1. In this description, the retrieved records are those in which the item number is “1” and the item name is “bank CD”, the item number is “2” and the item name is “bank name”. Is “3”, and the item name is “bank name Kana”.

  Next, the screen control unit 102a selects “1 bank CD”, “2 bank name”, and “3 bank name kana” based on the data (setting values) of each item included in the retrieved three records. A general-purpose master maintenance screen MA in which three edit boxes titled “” are arranged in the area MA2 is created. Note that the edit boxes for the number of necessary items (defined as edits) are arranged at fixed coordinates.

  Next, when the determination result transferred from the confirmation unit 102b indicates that new data can be registered, the screen control unit 102a, based on the set values of the three records searched, Output initial values to the three edit boxes. In this description, it is assumed that no initial value is set for the three retrieved records, so nothing is output to the three edit boxes.

  Next, the screen control unit 102a displays the general-purpose master maintenance screen MA shown in FIG. As a result, the general-purpose master maintenance screen MA has three editable input boxes titled “1 Bank CD”, “2 Bank name”, and “3 Bank name Kana” arranged in the area MA2 from the state of FIG. Change (transition) to the state shown in FIG.

  On the other hand, when the determination result transferred from the confirmation unit 102b is that data correction registration or data deletion registration is possible, the screen control unit 102a displays the EditID from the general-purpose main master in the area MA1. Search for a record that is “MS_Ginkou”. In this description, it is assumed that the searched table has the target table “MS_GINKOU”.

  Next, the screen control unit 102a identifies a master corresponding to the target table “MS_GINKOU” included in the retrieved record, and from the identified master (a bank master whose ID is “MS_GINKOU” in this description), Bank name data and bank name data associated with the bank CD “0001” included in the record to be corrected or deleted selected in the area MA22 are extracted. In this description, it is assumed that “A bank” is extracted as the bank name data and “Aginko” is extracted as the bank name data.

  Next, when the determination result transferred from the confirmation unit 102b is that data correction registration is possible, the screen control unit 102a includes the bank CD included in the correction target record selected in the area MA22. Output “0001” to the edit box titled “1 Bank CD”, lock the edit box for the Key item, and extract the extracted bank name “A bank” and bank name Kana “Aginkou”, respectively. Output to the edit box titled “2 Bank Name” and the edit box titled “3 Bank Name Kana”.

  Next, the screen control unit 102a displays the general-purpose master maintenance screen MA shown in FIG. As a result, the general-purpose master maintenance screen MA has been changed from the state shown in FIG. 6 to a locked (non-enterable) edit box titled “1 bank CD” and “2 bank name” and “3 bank name kana”. The two edit boxes that can be entered change (transition) to the state of FIG. 8 arranged in the area MA2.

  On the other hand, when the determination result transferred from the confirmation unit 102b indicates that data deletion registration is possible, the screen control unit 102a includes the bank CD “0001” included in the deletion target record selected in the area MA22. , And the extracted bank name “Bank A” and bank name Kana “Aginkou”, respectively, an edit box titled “1 Bank CD”, an edit box titled “2 Bank Name”, and “3 Bank Name Kana” To each edit box and lock all the edit boxes.

  Next, the screen control unit 102a displays the general-purpose master maintenance screen MA shown in FIG. As a result, the general-purpose master maintenance screen MA is changed from the state shown in FIG. 6 to three locked edit boxes titled “1 bank CD”, “2 bank name”, and “3 bank name Kana”. Changes (transitions) to the state of FIG. 9 arranged in the area MA2.

  This completes the description of the process performed in step SA9.

  When the user instructs new data registration, the user inputs desired data into each edit box included in the general-purpose master maintenance screen MA shown in FIG. Press the function key F10 that functions to instruct (add). When the user instructs data correction registration, the user inputs desired data into the editable input box included in the general-purpose master maintenance screen MA shown in FIG. Then, the function key F10 that functions to instruct registration (correction, overwriting) is pressed. When the user instructs data deletion registration, the user confirms the data displayed in the locked edit box included in the general-purpose master maintenance screen MA shown in FIG. The function key F10 that functions to instruct is pressed.

  Next, when the general-purpose master maintenance screen MA is in the state shown in FIG. 7, the registration unit 102c receives the pressed function key F10 (step SA10: Yes), and adds the input data to the maintenance-target bank master ( Step SA11).

  Further, when the general-purpose master maintenance screen MA is in the state shown in FIG. 8 and the registration unit 102c receives a press of the function key F10 (step SA10: Yes), the data of the bank master to be maintained is corrected with the input data ( Overwriting) (step SA11).

  When the registration unit 102c receives the press of the function key F10 when the general-purpose master maintenance screen MA is in the state shown in FIG. 9 (step SA10: Yes), the registration unit 102c changes the data from the maintenance target bank master to the general-purpose master maintenance screen MA. The displayed data is deleted (step SA11).

  When the screen control unit 102a receives the message transferred from the confirmation unit 102b (step SA8: No), the screen control unit 102a displays the error dialog MB shown in FIG. 10 on which the message is displayed on the monitor 114 (step SA12). When the OK button included in the error dialog MB is pressed (step SA13: Yes), the general-purpose master maintenance screen MA shown in FIG. 11 is created and displayed on the monitor 114, thereby displaying the general-purpose master maintenance screen MA in FIG. The state is changed (transitioned) to the state of FIG. 11 at the time of inquiry (step SA14). Note that the processing performed in step SA14 is the same as that for creating and displaying the general-purpose master maintenance screen MA at the time of deletion described above, and a description thereof will be omitted.

  This concludes the description of an example of the main process.

  In this description, the case where new data registration, data correction registration, or data deletion registration is performed with the bank master as a maintenance target is taken as an example. For example, a general-purpose main master, a general-purpose edit master, an extraction condition master, a general-purpose business check master It is also possible to perform new data registration, data correction registration, or data deletion registration with the definition master as the maintenance target. For example, when data correction registration is performed with the general-purpose main master as a maintenance target, the general-purpose master maintenance screen MA shown in FIG. 12 is displayed instead of the general-purpose master maintenance screen MA shown in FIG. Instead of the general master maintenance screen MA shown, a general master maintenance screen MA shown in FIG. 13 is displayed. In addition, for example, when data correction registration is performed for the general-purpose Edit master as a maintenance target, the general-purpose master maintenance screen MA shown in FIG. 14 is displayed instead of the general-purpose master maintenance screen MA shown in FIG. In place of the general-purpose master maintenance screen MA shown in FIG. 8, a general-purpose master maintenance screen MA shown in FIG. 15 is displayed.

  When the area MA2 for selecting / displaying the extraction condition is included in the area MA2 of the general-purpose master maintenance screen MA, the user operates the selection button included in the area MA21 to select the desired extraction condition. And data extraction based on the selected extraction condition can be instructed. For example, when the general master maintenance screen MA shown in FIG. 6 is displayed, when the user presses a selection button for selecting a condition item included in the area MA21 using the mouse 112, the screen control unit 102a displays on the monitor 114 a condition item selection screen MC shown in FIG. 16 in which the items of the bank master displayed in the area MA22 are listed as condition items. Further, for example, when the user presses a selection button for selecting an operator included in the area MA21 using the mouse 112 in the same state as this, the screen control unit 102a is prepared in advance. An operator selection screen MD shown in FIG. 17 listing a plurality of operators is displayed on the monitor 114.

  Further, when “F9: output” is displayed at the bottom, for example, when the general-purpose master maintenance screen MA shown in FIG. 6, FIG. 12, or FIG. 14 is displayed on the monitor 114, the user presses the function key F9. By pressing, it is possible to instruct the CSV file output of the data displayed in the area MA22. For example, when the user presses the function key F9 while the general-purpose master maintenance screen MA shown in FIG. 6 is displayed, the screen control unit 102a displays the number of data items displayed in the area MA22. A file output screen ME shown in FIG. 18 is displayed on the monitor 114. When the OK button included in the file output screen ME is pressed, the screen control unit 102a displays the CSV file having the specified file name in the area MA22 in the storage location specified on the file output screen ME. That contains the data being processed.

[3. Summary of this embodiment and other embodiments]
As described above, according to the present embodiment, (i) when the confirmation unit 102b receives an instruction to newly register data, it is selected by the user on the general-purpose master maintenance screen MA shown in FIG. Based on the maintenance target master, and when receiving an instruction to correct or delete data, the maintenance target master and the maintenance in the master selected by the user on the general-purpose master maintenance screen MA Based on the target data, the general job check master executes the process specified by the Ckeck query of the processing category corresponding to the instruction, and confirms whether the instruction is permitted based on the execution result. (Ii) The screen control unit 102a determines that the confirmation result is correct when the instruction is related to new registration of data. When the instruction is permitted, the general-purpose master maintenance screen shown in FIG. 6 displayed on the monitor 114 is referred to the definition master (at least the general-purpose Edit master) and data can be input as shown in FIG. If the transition is made to the general-purpose master maintenance screen MA and the instruction relates to correction or deletion of data, the general-purpose master maintenance screen shown in FIG. 6 displayed on the monitor 114 is changed to the definition master (at least the general-purpose edit master). ), The maintenance target data is output in a form (input enabled or input disabled (locked)) according to the instruction and the confirmation result. Transition to screen MA. As a result, it is not preferable in the operation of the master maintenance (for example, “unnecessary amount of data is registered by newly registering an operator exceeding the limit number of use operator licenses”, “data in the master If data exists in the actual data such as billing data or sales data, the data in the master will be modified or deleted, and consistency between the actual data and the master will not be guaranteed. And “there is a master without data by deleting the data for a master with only one data”, etc.), so there is no convenience in the operation of master maintenance. Can be improved.

  Further, according to the present embodiment, a plurality of master data can be maintained on one master maintenance screen MA. In addition, the definition master itself can be easily maintained by converting the DB definition item of each master data to be maintained into data. Further, since it is not necessary to develop a screen for each master, it is possible to reduce the man-hours and costs for the development. Further, since the master data can be customized only by changing the setting of the DB item definition, the master maintenance device 100 can be provided to the user at a low cost and quickly.

  Although the embodiments of the present invention have been described so far, the present invention can be implemented in various different embodiments within the scope of the technical idea described in the claims other than the above-described embodiments. It ’s good.

  In addition, among the processes described in the embodiment, all or a part of the processes described as being automatically performed can be manually performed, or all of the processes described as being manually performed can be performed. Alternatively, a part can be automatically performed by a known method.

  In addition, unless otherwise specified, the processing procedures, control procedures, specific names, information including registration data for each processing, parameters such as search conditions, screen examples, and database configurations shown in the above documents and drawings Can be changed arbitrarily.

  Further, regarding the master maintenance apparatus 100, each illustrated component is functionally conceptual and does not necessarily need to be physically configured as illustrated.

  For example, the processing functions provided in the master maintenance device 100, particularly the processing functions performed by the control unit 102, are all or any part of the processing functions in a CPU (Central Processing Unit) and a program interpreted and executed by the CPU. Alternatively, it may be realized as hardware based on wired logic. The program is recorded on a recording medium to be described later, and is mechanically read by the master maintenance device 100 as necessary. That is, in the storage unit 106 such as a ROM or an HD, a computer program for performing various processes by giving instructions to the CPU in cooperation with an OS (Operating System) is recorded. This computer program is executed by being loaded into the RAM, and constitutes a control unit in cooperation with the CPU.

  Further, this computer program may be stored in an application program server connected to the master maintenance device 100 via an arbitrary network 300, and may be downloaded in whole or in part as necessary. is there.

  In addition, the master maintenance program according to the present invention may be stored in a computer-readable recording medium, and may be configured as a program product. Here, the “recording medium” means a memory card, USB memory, SD card, flexible disk, magneto-optical disk, ROM, EPROM, EEPROM (registered trademark), CD-ROM, MO, DVD, and Blu-ray Disc. And any other “portable physical medium”.

  The “program” is a data processing method described in an arbitrary language or description method, and may be in any format such as source code or binary code. The “program” is not necessarily limited to a single configuration, but is distributed in the form of a plurality of modules and libraries, or in cooperation with a separate program represented by an OS (Operating System). Including those that achieve the function. In addition, a well-known structure and procedure can be used about the specific structure for reading a recording medium in each apparatus shown in embodiment, a reading procedure, or the installation procedure after reading.

  Various databases and the like stored in the storage unit 106 (each table stored in the master storage unit 106a) are storage devices such as a memory device such as a RAM / ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk. It stores various programs, tables, databases, web page files, etc. used for various processes and website provision.

  The master maintenance apparatus 100 may be configured as an information processing apparatus such as a known personal computer or workstation, or may be configured by connecting an arbitrary peripheral device to the information processing apparatus. The master maintenance apparatus 100 may be realized by installing software (including programs, data, and the like) that realizes the master maintenance method according to the present invention in the information processing apparatus.

  Furthermore, the specific form of distribution / integration of the devices is not limited to that shown in the figure, and all or a part of them may be functional or physical in arbitrary units according to various additions or according to functional loads. Can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and may be selectively implemented.

  As described above, the master maintenance device, the master maintenance method, and the master maintenance program according to the present invention are useful in maintenance of various masters set in the sales management system or the like.

100 Master maintenance device 102 Control unit
102a Screen control unit
102b Confirmation part
102c Registration unit 104 Communication interface unit 106 Storage unit
106a Master storage unit 108 Input / output interface unit 112 Input device 114 Output device 200 External server 300 Network

Claims (4)

A master maintenance device including a control unit, a storage unit, and a display unit,
In the storage unit, for each processing category including new registration, correction, and deletion, True, which means that if the processing of the processing category is performed, it becomes an unfavorable situation for the operation of master maintenance, and processing of the processing category is performed. Even if it is not, it is not permitted to execute the processing of the character string related to the instruction for performing the predetermined processing that returns either one of the results indicating that the master maintenance operation is not unfavorable as a result. A variable that is set with either one of True and False indicating that the processing of the processing classification is permitted is stored,
The controller is
When receiving an instruction for new registration of data, based on the maintenance target master specified in advance on the master maintenance screen displayed in advance on the display unit used for maintenance of the master, When a deletion instruction is received, based on the maintenance target master and the maintenance target data in the master specified in advance on the master maintenance screen, the processing category corresponding to the instruction Confirming means for executing the predetermined processing specified by the character string and confirming whether or not to permit the instruction based on a match or mismatch between the execution result and the variable ;
When the instruction is related to new registration and the confirmation result by the confirmation means is that the instruction is permitted, data can be input to the master maintenance screen displayed on the display unit. The state is changed to the master maintenance screen, and when the instruction is related to correction or deletion, when the confirmation result by the confirmation means permits the instruction , the display is displayed on the display unit. Screen control means for transitioning the master maintenance screen to the master maintenance screen in which the maintenance target data is output in a form according to the instruction and the confirmation result of the confirmation means. A master maintenance device. If the confirmation result by the confirmation means is that the instruction is not permitted, the screen control means can only view the master maintenance screen displayed on the display unit with existing data. Transition to the master maintenance screen output in the state,
  The master maintenance device according to claim 1. For each processing category including the control unit and new registration, correction, and deletion, True means that if the processing of that processing category is performed, the master maintenance operation becomes unfavorable, and the processing of that processing category is performed This also means that a character string related to a command for performing a predetermined process that returns one of False as a result, which means that it is not an unfavorable situation in the operation of the master maintenance, and that the processing of the processing category is not permitted. It is executed by an information processing apparatus including a storage unit storing a variable in which one of True and False indicating that processing of the processing category is permitted, and a display unit are stored. A master maintenance method,
Executed by the control unit,
When receiving an instruction for new registration of data, based on the maintenance target master specified in advance on the master maintenance screen displayed in advance on the display unit used for maintenance of the master, When a deletion instruction is received, based on the maintenance target master and the maintenance target data in the master specified in advance on the master maintenance screen, the processing category corresponding to the instruction A step of performing the predetermined process specified by the character string and confirming whether or not to permit the instruction based on a match or mismatch between the execution result and the variable ;
When the instruction is related to new registration and the confirmation result in the confirmation step is that the instruction is permitted, data can be input to the master maintenance screen displayed on the display unit. When the state transitions to the master maintenance screen, and the instruction is related to correction or deletion , and the confirmation result in the confirmation step is that the instruction is permitted, the instruction is displayed on the display unit. A screen control step for transitioning the master maintenance screen to the master maintenance screen in which the maintenance target data is output in a form according to the instruction and the confirmation result in the confirmation step;
The master maintenance method characterized by including. For each processing category including the control unit and new registration, correction, and deletion, True means that if the processing of that processing category is performed, the master maintenance operation becomes unfavorable, and the processing of that processing category is performed This also means that a character string related to a command for performing a predetermined process that returns one of False as a result, which means that it is not an unfavorable situation in the operation of the master maintenance, and that the processing of the processing category is not permitted. In order to cause an information processing apparatus including a storage unit in which one of True and a variable that is set to False to permit processing of the processing category to be stored, and a display unit to be executed, to be executed Master maintenance program of
For causing the control unit to execute,
When receiving an instruction for new registration of data, based on the maintenance target master specified in advance on the master maintenance screen displayed in advance on the display unit used for maintenance of the master, When a deletion instruction is received, based on the maintenance target master and the maintenance target data in the master specified in advance on the master maintenance screen, the processing category corresponding to the instruction A step of performing the predetermined process specified by the character string and confirming whether or not to permit the instruction based on a match or mismatch between the execution result and the variable ;
When the instruction is related to new registration and the confirmation result in the confirmation step is that the instruction is permitted, data can be input to the master maintenance screen displayed on the display unit. When the state transitions to the master maintenance screen, and the instruction is related to correction or deletion , and the confirmation result in the confirmation step is that the instruction is permitted, the instruction is displayed on the display unit. A screen control step for transitioning the master maintenance screen to the master maintenance screen in which the maintenance target data is output in a form according to the instruction and the confirmation result in the confirmation step;
A master maintenance program characterized by including

Images