JP2008310681A - Business management system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a business management system which can manage a change history appropriately even if a code used in the business management system is reused or changed. <P>SOLUTION: The business management system has: a business data storage means for storing data of respective targets with the data corresponding to a general code, a fixed code, and a subordinate code; a change history storage means; a business data control means; a change history control means; and a code generating means for generating the fixed code and the subordinate code by using the general code in response to a requirement from a client terminal. When the business data control means receives a data registration request of a new target from the client terminal, it transfers the general code to the code generating means, makes the code generating means generate the fixed code and the subordinate code, receives the fixed code and the subject code generated by the code generating means, and makes the business data storage means store the general code, the fixed code, and the subordinate code in a set as the new target data. <P>COPYRIGHT: (C)2009,JPO&INPIT

Description

The present invention relates to a business management system used in a company or the like. More specifically, the present invention relates to a business management system that manages a change history of a code used in the business management system, so that even if the code is reused or changed, the change history can be managed accurately.

  In order to carry out business in a company or the like, a business management system for managing business in various fields such as product management, sales management and salary management is used. In such a business management system, a code (identification information) is assigned to each in order to identify targets such as customers, products, and employees, and various information management is performed by using the codes. An example of such a business management system is shown in the following patent document.

  In recent years, from the viewpoint of security and the utilization of IT in internal control, when, who, and what kind of data operations are performed by the business management system are managed by logs. This log management is very important, for example, it is possible to find the leakage source at the time of information leakage. A conventional log management system is shown in Patent Document 7 below.

  If it is necessary to trace some kind of log in the business management system, conventionally, the log list is extracted by inputting the target code and the log is traced.

JP 2007-18402 A JP 2006-333141 A JP 2006-113771 A JP 2006-12043 A JP 2005-173848 A JP 2004-287575 A JP 2007-48266 A

  In various conventional business management systems represented by the above, it is possible to add, change, and delete codes assigned to objects according to the circumstances of the business. However, if you perform any changes or deletions on the code in this way, the code will not match the target, so if you follow the log using the code as a key, you will not be able to accurately track it. End up.

  For example, if you delete code that was used for one target and later use the deleted code for another target, two targets are extracted for one code, so you can track the log accurately. Difficult to perform (conventional example 1). In another example, when the code used for a certain target is changed, the code before the change and the code after the change are different, which makes it difficult to accurately track the log (conventional example 2). ).

  More specifically, problems in the case where a code used for a certain target is deleted in a conventional business management system and the deleted code is used for another target later (conventional example 1) will be described.

  For example, as shown in FIG. 13A, it is assumed that the code “001” is used for “Magazine A” on March 7, 2007 in the sales management system. Thereafter, if the magazine A is discarded on April 7, 2007, the code “001” becomes an empty number (FIG. 13B). Thereafter, when “Novel C” is purchased on May 1, 2007, in order to minimize the total number of codes in the normal business management system, the unused codes are used, and the code “001” is changed to “Novel C”. Are often reused (FIG. 13C). Then, for some reason, even if the log of the business management system is tracked with the code “001” as a key for the purpose of acquiring the log for magazine A, the log for magazine A and the log for novel C are mixed. (FIG. 13D). Therefore, accurate tracking cannot be performed.

  Even in such a case, the log can be traced if the log is acquired using not only the code but also the period as a key. In this case, the period during which the code “001” is used for the magazine A is changed. You must know in advance or make a prediction.

  Next, the problem in the conventional example 2 will be described more specifically.

  For example, in the sales management system, it is assumed that the code of magazine A is “001” and the code of magazine B is “002” (FIG. 14A). In this case, the code of magazine A is changed for some reason, for example, the sales of magazine A decreases, the information of magazine A becomes less important, and you want to prevent magazine A from being displayed at the top when displaying the code list. There are things to do. For example, if the code of magazine A is changed from “001” to “099” on April 1, 2007, code “001” becomes an empty number and code “099” becomes magazine A (FIG. 14B).

  Thereafter, when the novel C is purchased on May 1, 2007, the code “001” is often reused in the novel C for the same reason as described above (FIG. 14C). Then, as shown in FIG. 14D, even if the log of the code “001” is tracked with the intention of acquiring the log of the magazine A, the log related to the magazine A and the log related to the novel C are mixed. Then, the log concerning the magazine A after the code change leaks (log of April 1, 2007 in FIG. 14C). Therefore, even in such a case, accurate log tracking cannot be performed for each target.

  Because the above problems are assumed, there is a business management system that can accurately track logs using codes even when the code is changed or deleted in the business management system. It is desired.

  In view of the above problems, the present inventor manages the code change history using the fixed code and the subordinate code in addition to the normal code, so that even if the code is reused or changed, the correct change is made. Invented a business management system capable of managing history.

  The invention of claim 1 is a business management system connected to a client terminal via a network, wherein the business management system stores data of each object processed by the business management system, and each of the objects Data stored in correspondence with the normal code to be displayed to the user, the fixed code generated by the business management system and the subordinate code, and the change history for each target data is stored Change history storage means for storing the change history in correspondence with the normal code, fixed code, and subordinate code, business data management means for executing processing for the business data storage means, and processing for the change history storage means The change history management means for executing the command and a new request in the business data storage means in response to the request from the client terminal Code generation means for generating a set of a fixed code and a subordinate code using a normal code assigned to the target data when registering the data of the object, the business data management When the means accepts a registration request for new target data from the client terminal, the means passes the normal code received from the client terminal or the automatically assigned normal code to the code generation means for the new target. Thus, the fixed code and the subordinate code are generated, the fixed code and the subordinate code generated by the code generation means are received, and the normal code, the fixed code and the subordinate code are combined as the new target data. Is a business management system stored in the business data storage means.

  By configuring as in the present invention, even if a code (ordinary code) given to a target is added, changed, or deleted as in the past, the normal code that the user currently knows is changed. It is possible to accurately track the log for the object.

  In the invention of claim 2, the fixed code is the same code as the normal code assigned to the target when the target is registered in the business management system, and the normal code is changed. It is a code that is not changed even if it is, and the subordinate code is a business management system that is a code for identifying different fixed codes from the same fixed code used for different objects in the past.

  In the present invention, a fixed code and a subordinate code are used in addition to the normal code, and the process is executed by associating the fixed code and the subordinate code with the normal code. It is preferable to set as in the present invention.

  4. The business management system according to claim 3, wherein the subordinate code is a code indicating how many times the fixed code has been used in the past.

  The subordinate code is preferably set as in the present invention.

  In the invention of claim 4, the code generation means generates the same code as the normal code received from the business data management means as a fixed code, and based on the generated fixed code, the business data storage means or the It is searched from the change history storage means whether the same fixed code as the fixed code exists, and as a result of the search, if there is no same fixed code in any storage means, it is initialized as a subordinate code for the fixed code If the same fixed code exists in either or both storage means as a result of the search, a predetermined value is calculated for the maximum value of the subordinate code assigned to the same fixed code. This is a business management system that generates a subordinate code and passes the generated fixed code and subordinate code to the business data management means.

  Generating a fixed code and a subordinate code based on a normal code can be performed by processing as in the present invention.

  6. The log output according to claim 5, wherein when the business system further receives a log output request for a target from the client terminal, the business system searches the change history storage unit and executes a log output process for the target. The log output means accepts a normal code given to the target from the client terminal, and outputs a fixed code and a subordinate code corresponding to the normal code to the business data storage means or The business management system searches from the change history storage means, searches the change history storage means for a change history corresponding to the fixed code and the subordinate code, and transmits the change history to the client terminal.

  When tracking logs using the present invention, the user basically searches for a fixed code and a subordinate code associated with each other by inputting and selecting a normal code. Based on these, log search can be accurately performed from the change history storage means.

By using the present invention, it is possible to provide a business management system capable of accurately managing a change history even if a code is reused or changed. Thereby, for example, even if the same code is used again for a different target after deleting or changing a code once used for a certain target, the log can be traced accurately.

  A schematic diagram of the entire business management system 1 of the present invention is shown in FIG.

  The business management system 1 is a system composed of business software necessary for business execution of a company and the like and hardware (computer terminal, server, etc.) that executes the software. For example, an accounting management system, a sales / purchase management system, There are HR / salary management system, customer management system (CRM system), sales support system (SFA (Sales Force Automation) system) and so on. In addition, these systems may be linked in real time as modules to manage data collectively.

  The business management system 1 is realized on a computer system (including a server) that controls the processing of the present invention. FIG. 15 schematically shows a conceptual diagram of hardware of a computer system. This computer system has at least an arithmetic device 20 such as a CPU for executing arithmetic processing of a program, and a storage device 21 such as a RAM and a hard disk for storing information. Each function (each means) realized on the computer system is executed when a means (program, module, etc.) for executing the process is read into the arithmetic unit 20. When using the information stored in the storage device 21 in the processing, each function reads the corresponding information from the storage device 21 and uses the read information for processing in the arithmetic device 20 as appropriate. The computer system includes a communication device 24 that transmits / receives processing results of the arithmetic device 20 and information stored in the storage device 21 via a network such as the Internet or a LAN, an input device 23 such as a keyboard, a mouse, or a numeric keypad, and a display. A display device 22 may be included.

  Each function (each unit) in the present invention is only logically distinguished from each other, and may be physically or effectively the same area. Each function can be processed by one or a plurality of programs, modules, devices, or the like.

  The business management system 1 stores business data such as financial accounting, sales, purchasing, personnel, salary, customer, sales information, etc. in a server, and performs various management (registration, deletion, change) in response to a request from the client terminal 2 described later. Etc.). Data of each business is stored in the database server as business data storage means 8 (for example, a product (master) table, a customer (master) table, etc.)).

  Further, in order to realize business processing in the business management system 1, business data management means 7 is further provided. The business data management means 7 receives input data (registration data, change data, deletion data) from an input processing means 9 to be described later, registers the input data in the business data storage means 8, or stores business data based on the input data The data of the means 8 is changed or deleted, and the fixed code / subordinate code received from the code generation means 3 described later is stored in the business data storage means 8. That is, the business data management unit 7 manages the information stored in the business data storage unit 8 and functions the normal business management system 1 for the client terminal 2 operated by the user in order to make the normal business management system 1 function. Execute.

  The business data storage unit 8 manages data of each business such as financial accounting, sales, purchasing, personnel, salary, customer, and sales information. For example, there are a product (master) table, a customer (master) table, a sales (master) table, a journal entry (master) table, and the like. The business data storage unit 8 preferably stores data in a table format, but is not limited thereto. In the business data storage unit 8, at least a normal code, a fixed code, a subordinate code, and a target name are included in one record. The business data storage means 8 preferably functions on the database server.

  In order to realize the business management system 1 of the present invention, the function of managing the code change history further includes a code generation means 3, a change history storage means 6, a change history management means 4, and a log output means 5. ing. In order to realize general processing, input processing means 9 and output processing means 10 are also provided.

  The code generation means 3 generates a set of a fixed code and a subordinate code based on a code (this is called “normal code”) used for a certain target inputted by the user. Specifically, when a normal code is designated for a certain target, a fixed code identical to the normal code is generated. For example, if the normal code is “A123”, the fixed code is also generated as “A123”. Next, by passing the generated fixed code to the change history management means 4 to be described later, an inquiry is made as to whether or not the same fixed code exists in the change history storage means 6, and based on the presence or absence, a combination with the fixed code Generate subordinate code that can be specified by the target.

  When generating the subordinate code, the change history management means 4 searches the change history storage means 6 with the generated fixed code, and if the same fixed code exists in the change history storage means 6, the same fixed code A new value is generated by adding a predetermined value (preferably “1”) to the maximum value of the dependency codes assigned to. If the same fixed code does not exist in the change history storage means 6, the business data management means 7, which will be described later, searches the business data storage means 8 with the fixed code and stores the same fixed code in the business data storage means 8. Search if exists. When the same fixed code exists, a predetermined value (preferably “1”) is added to the maximum value of the dependent codes assigned to the same fixed code to generate a new dependent code. If neither the change history storage means 6 nor the business data storage means 8 has the same fixed code, an initial value (preferably “0”) is assigned as a subordinate code.

  The “normal code” in this specification is a code displayed to a user (for example, an auditor, a system administrator, a business administrator, a general user, etc.) by the business management system 1, and is subject to change and deletion processing. Is the code. The normal code may be manually given after the user confirms the business data storage means 8 or may be automatically generated and given by the business data management means 7. When there are a plurality of free normal codes and the business data management means 7 automatically assigns them, it is preferable to assign them in ascending order of the code numbers of the normal codes. For example, when the normal codes “001” and “003” are empty, the business data management means 7 preferably assigns “001” as the normal code, but the type of code that is not suitable for reuse (for example, employee In the case of a code or the like, a free code may be left as it is and a new code may be generated.

  The “fixed code” is generated as a fixed code when the normal code is registered in the business data storage unit 8. Fixed code cannot be changed, deleted, or otherwise changed. The fixed code may be displayed to the user, or may not be displayed to the user unless there is a special need such as maintenance.

  The “subordinate code” is a code assigned to each fixed code, and is a code indicating how many times the fixed code has been used in the past. That is, it is a code for distinguishing the fixed code from the same fixed code used in the past. The subordinate code is preferably assigned as a serial number. Further, the subordinate code assigned to the fixed code is not changed, and even if the normal code is changed, the normal code is not changed in the same manner as the fixed code.

  The change history storage unit 6 records the operation history (change history) of the business data storage unit 8. The data is preferably stored in a table format, but is not limited thereto. The change history storage means 6 includes at least one user identification information (such as a user ID), operation date / time or operation order information, normal code, fixed code, subordinate code, target name, and processing content identification information in one record. It is. In addition, it is preferable to use a history number as the operation order information. By managing the operation order by history number, even if the date and time acquired from the date and time information generation source (server etc.) is inaccurate, it is possible to maintain the correct history order and accurate change history Can be managed. A history number is generated by a history number generation means (not shown) by the following process when a set of fixed code / subordinate code is registered in the change history storage means 6.

  First, when there is a combination of the same fixed code and subordinate code in the change history storage means 6, the change history storage means 6 is searched / extracted with the combination of the fixed code and subordinate code, and the maximum value of the extracted history number is set to a predetermined value. Add the value of. For example, 1 is added. Further, when there is no combination of the same fixed code and dependent code in the change history storage means 6, an initial value (for example, 0, 1, etc.) is assigned.

  The change history storage means 6 is preferably provided for each business data storage means 8. In particular, when the business data storage unit 8 is in a table format, it is preferable that the change history storage unit 6 stores data in a table format for each table. Moreover, it is preferable that the change history storage unit 6 functions on the database server.

  The change history management unit 4 performs processing related to the change history storage unit 6. Specifically, search of the change history storage unit 6, extraction of search results, registration and deletion of data in the change history storage unit 6 are performed. If there is any processing in the data stored in the business data storage means 8 for execution of processing related to the change history, the change history management means 4 receives history data described later from the business data management means 7, Based on this, the change history is stored in the change history storage means 6.

  The log output means 5 performs processing related to log output. Specifically, when the user operates the client terminal 2, the client terminal 2 logs a specific normal code or all normal codes for either registered data or deleted data. Receive an output request (specified display request or full display request).

  In the case of designation display, the normal code selected by the user is searched. In the case of full display, the business data storage means 8 or the change history storage means 6 is searched for all data, and a combination of fixed code and subordinate code is acquired. In the case of designated display, a record having the acquired combination of fixed code and subordinate code is extracted from the change history storage means 6 to generate display screen data, which is transmitted to the client terminal 2.

  In the case of full display, all fixed code / subordinate code pairs are acquired from the business data storage means 8 or the change history storage means 6, and based on these, selection screen data is once generated, transmitted to the client terminal 2, and sent to the client side. Select display target data. A record having a pair of fixed code and subordinate code corresponding to the selected data is extracted from the change history table, display screen data is generated, and transmitted to the client terminal 2.

  In the log output for deleted data, it is preferable to acquire a combination of a fixed code and a subordinate code including a record whose processing classification is “deleted”. For example, taking the contents of the customer change history table of FIG. 8 to be described later as an example, the record with process classification = 2 (deletion) is the record of history number 3, and “001001” is the fixed code of the deleted normal code. ”, The subordinate code“ 0 ”is acquired. When a record having the acquired combination of fixed code and subordinate code is extracted, records with history numbers 1, 2, and 3 are obtained. However, the selection screen data may be generated from all sets regardless of the processing category by a user instruction “include registered data”. In this way, for example, it is possible to investigate what operation a certain user has performed regardless of whether the user has been registered or deleted.

  The input processing means 9 receives data input by the user at the client terminal 2 from the client terminal 2 and receives the data from the change history management means 4, code generation means 3, log output means 5, business data management means 7, etc. Pass to the necessary means.

  The output processing unit 10 generates screen data for displaying the data processed by the business management system 1 on the client terminal 2 and transmits the screen data to the client terminal 2.

  Next, an example of a processing process in the business management system 1 of the present invention will be described with reference to the flowcharts of FIGS. 2 and 3 and the conceptual diagram of FIG. In the following description of the processing process, first, registration of a certain target data is performed in the business management system 1, and then a correction process for the name of the target data is performed. This is a case where the log is output after the target is input and the code is changed.

  First, the user performs a predetermined operation on the client terminal 2 to access the business management system 1 and perform a predetermined authentication process. Then, after the authentication process ends normally, target data is input to the business management system 1.

  For example, when the user selects a predetermined menu (for example, “registration menu”, corresponding to the operation program ID = “HAN060”) on the input screen of the client terminal 2 and inputs “XX store”, the user is good at the input data. Name = “XX store”, normal code = “00101”, processing classification = “0” (indicating “registration”), operation program ID, user ID, etc. are transmitted to the business management system 1 and input processing means 9 (S100). The normal code input at this time may be manual as described above, or may be automatically given by inputting a customer name or the like.

  When the input processing means 9 passes the input data to the business data management means 7, the business data management means 7 determines that the processing category = 0 (registration) and inputs it to the customer table (business data storage means 8). Perform data registration processing. After confirming that the normal codes do not overlap, the business data management means 7 records the customer name = XX store and the normal code = 00101 in the customer table (business data storage means 8).

  Since the business data management means 7 has received “00101” as the normal code, the code generation means 3 uses it to generate the fixed code and the dependent code for the normal code (S110).

  First, the business data management means 7 receives “00101” as a normal code, and passes it to the code generation means 3 (S200). The code generation means 3 generates the same fixed code “00101” based on the received normal code “00101” (S210). The code generation means 3 passes the fixed code generated in this way to the change history management means 4 (S220).

  The change history management means 4 searches whether the same fixed code as the fixed code received from the code generation means 3 exists in the change history storage means 6 (S230). When the same fixed code exists in the change history storage unit 6, the change history management unit 4 extracts a record having the same fixed code from the change history storage unit 6 (S240). The code generation unit 3 receives the result extracted by the change history management unit 4, and the code generation unit 3 obtains the maximum value among the subordinate codes assigned to the extracted same fixed code (S250). Then, the code generation means 3 adds a predetermined value, for example, “1” to the maximum value to generate a new subordinate code (S260).

  On the other hand, if the same fixed code does not exist in the change history storage means 6, the code generation means 3 receives the result from the change history management means 4. The code generation unit 3 passes the generated fixed code to the business data management unit 7, and the business data management unit 7 has the same fixed code as the fixed code received from the code generation unit 3 in the business data storage unit 8. (S270). When the same fixed code exists in the business data storage unit 8, the business data management unit 7 extracts a record having the same fixed code from the business data storage unit 8 (S240). The code generation unit 3 receives the result extracted by the business data management unit 7, and the code generation unit 3 obtains the maximum value among the subordinate codes assigned to the extracted same fixed code (S250). Then, the code generation means 3 adds a predetermined value, for example, “1” to the maximum value to generate a new subordinate code (S260).

  If there is no fixed code identical to the fixed code generated by the code generation means 3 in either the change history storage means 6 or the business data storage means 8, it is a new fixed code. The initial value is received from the means 7 and used as a subordinate code (S280).

  The fixed code / subordinate code generation processing will be described more specifically using the above example. Since the business data management unit 7 assigns the normal code “00101” to the customer name “XX store”, the business data management unit 7 passes the code to the code generation unit 3 so that the code generation unit 3 can fix the fixed code. “00101” is generated. Then, the code generation means 3 passes this fixed code to the change history management means 4 to search whether the record having the same fixed code as the fixed code “00101” exists in the change history storage means 6. At this time, since no record is stored in the change history storage means 6, there is no identical fixed code. Therefore, the change history management unit 4 returns to the code generation unit 3 a result indicating that the same fixed code does not exist. The code generation means 3 receives this search result and passes the fixed code “00101” to the business data management means 7, and the business data management means 7 detects that the record having the same fixed code as the fixed code “00101” is the customer record. It is searched whether it exists in (business data storage means 8).

  At this point, no records are stored in the customer table (business data storage means 8), and the same fixed code does not exist. Therefore, the business data management unit 7 returns a result indicating that the same fixed code does not exist to the code generation unit 3. In response to this result, the code generation means 3 generates an initial value “0” as a subordinate code. The code generation means 3 passes the fixed code “00101” and the subordinate code “0” generated in this way to the business data management means 7, and the business data management means 7 uses the fixed code “00101” and the subordinate code “0”. Are stored in the customer table (business data storage means 8). FIG. 4A schematically shows the customer table (business data storage means 8) in this state.

  Further, the business data management means 7 acquires the date and time data obtained by storing the input data in the customer table (business data storage means 8) from the database server, and stores it as history data in the customer table (business data storage means 8). Each record data, processing classification = 0 (registration), operation program ID = HAN060, acquired date / time data, and user ID are passed to the change history management means 4.

  The change history management means 4 stores the history data received from the business data management means 7 in the customer change history table (change history storage means 6). At this time, the history number generation means (not shown) searches the customer change history table for a combination of the same fixed code and subordinate code, and stores the initial value “1” as the history number. FIG. 4B schematically shows the customer change history table (change history storage means 6) in this state.

  By performing the above processing, first, the customer name “XX store” was registered in the business management system 1.

  Next, since the name of “XX store” is erroneously described, a case where the name is corrected to “XX store” will be described.

  For example, the user selects a predetermined menu (for example, “target name correction menu”, corresponding to the operation program ID = “HAN0611”) on the input screen of the client terminal 2, and changes the customer name from “XX store” to “XX”. When the request for correction is input to “shop”, the customer name before correction = “XX store”, the customer name after correction = “XX store”, and the processing category = “1” (“change”). The operation program ID, user ID, etc. are transmitted to the business management system 1 and received by the input processing means 9.

  When the input processing means 9 passes the input data to the business data management means 7, the business data management means 7 determines that the processing category = 1 (change), and changes the customer table (business data storage means 8). Process. The business data management means 7 rewrites the customer name from “XX store” to “XX store” and records it. Such correction processing is the same as that of the conventional business management system 1.

  Further, the business data management means 7 obtains the date / time data obtained by correcting the input data in the customer table (business data storage means 8) from the database server, and rewrites it as history data in the customer table (business data storage means 8). Each data of the recorded record, processing classification = 1 (change), operation program ID = HAN0611, acquired date / time data, and user ID are passed to the change history management means 4.

  The change history management means 4 stores the history data received from the business data management means 7 in the customer change history table (change history storage means 6). At this time, the history number generation means (not shown) searches for the same fixed code and dependent code pair in the customer change history table, but the same fixed code and dependent code pair already exists. Therefore, the history number is extracted, and “1” is added to the history number, that is, the history number is set to “2” and stored in the customer change history table (change history storage means 6).

  FIG. 5A schematically shows the state of the customer table (business data storage means 8) in the state where the correction processing as described above is performed. The customer change history table (change history storage) in this state is shown in FIG. FIG. 5B schematically shows the means 6). Although correction of the customer name has been described here, other items (not shown) such as the customer's address, telephone number, person in charge name, etc. can be managed in a table and can be corrected.

  A case will be described in which the customer name “Ox store” is deleted after the customer name correction processing is performed in this way.

  For example, the user selects a predetermined menu (for example, “delete menu”, corresponding to the operation program ID = “HAN062”) on the input screen of the client terminal 2 and deletes the code related to the customer name “XX store”. When the request is input, the customer name = “XX store”, the processing category = “2” (indicating “delete”), the operation program ID, the user ID, etc. are transmitted to the business management system 1 as input data. And is received by the input processing means 9.

  When the input processing means 9 passes the input data to the business data management means 7, the business data management means 7 determines that the processing category = 2 (deletion) and deletes it in the customer table (business data storage means 8). Process. The business data management means 7 extracts each data of the record with the customer name = “Ox store” from the customer table (business data storage means 8), passes it to the change history management means 4, and then the customer. The record is deleted from the table (business data storage means 8). Such deletion processing is the same as that of the conventional business management system 1.

  Further, the business data management means 7 acquires the date and time data obtained by deleting the input data in the customer table (business data storage means 8) from the database server and deletes it as history data in the customer table (business data storage means 8). Each data of the record, processing classification = 2 (deletion), operation program ID = HAN062, acquired date / time data, and user ID are passed to the change history management means 4.

  The change history management means 4 stores the history data received from the business data management means 7 in the customer change history table (change history storage means 6). At this time, the history number generation means (not shown) searches for the same fixed code and dependent code pair in the customer change history table, but the same fixed code and dependent code pair already exists. Therefore, the history number is extracted, and “1” is added to the history number, that is, the history number is set to “3” and stored in the customer change history table (change history storage means 6).

  FIG. 6A schematically shows the state of the customer table (business data storage means 8) in the state where the correction processing as described above is performed. The customer change history table (change history storage) in this state is shown in FIG. FIG. 6B schematically shows means 6).

  A case will be described in which after “customer name deletion processing” is performed as described above, a new registration of “◯ △ store” is performed.

  For example, when the user selects a predetermined menu (for example, “registration menu”, corresponding to the operation program ID = “HAN060”) on the input screen of the client terminal 2 and inputs “○ △ store”, the user is good at the input data. Name = “◯ △ store”, normal code = “00101”, processing category = “0” (indicating registration), operation program ID, user ID, etc. are transmitted to the business management system 1 and received by the input processing means 9 (S100). The normal code input at this time is “00101” deleted above for convenience of explanation. The normal code may be manual as described above, or may be automatically given by inputting a customer name or the like. In the case of automatic assignment, it is preferable to assign the smallest normal code among the free normal codes.

  When the input processing means 9 passes the input data to the business data management means 7, the business data management means 7 determines that the processing category = 0 (registration) and inputs it to the customer table (business data storage means 8). Perform data registration processing. The business data management means 7 confirms that the normal codes do not overlap (at this time, the record of “XX store” having the same normal code “00101” has been deleted from the business data storage means 8. The customer name = ○ Δ store and the normal code = 00101 are recorded in the customer table (business data storage means 8).

  Since the business data management means 7 has received “00101” as the normal code, the code generation means 3 uses it to generate the fixed code and the subordinate code for the normal code.

  First, since the normal code assigned to the customer name “◯ △ store” by the business data management means 7 is “00101”, the business data management means 7 passes the code to the code generation means 3 so that the code generation means 3 Generates a fixed code “00101”. Then, the code generation means 3 passes this fixed code to the change history management means 4 to search whether the record having the same fixed code as the fixed code “00101” exists in the change history storage means 6. Then, it is searched that the same fixed code “00101” already exists in the customer change history table (change history storage means 6). In this case, the fixed code “00101” and the subordinate code “0” of “XX store” and the fixed code “00101” and the subordinate code “0” of “Ox store” can be searched. Accordingly, the change history management means 4 has the same fixed code, and the result thereof, that is, the fixed code “00101” of “XX store”, the subordinate code “0”, and the fixed code “00101” of “XX store”. And the subordinate code “0” are passed to the code generation means 3.

  In response to this result, the code generation means 3 acquires the maximum value “0” of the dependent code, adds a predetermined value, for example, “1” to the maximum value, and generates the dependent code “1”. In this way, the code generation unit 3 generates a set of the fixed code “00101” and the subordinate code “1” and passes it to the business data management unit 7. The business data management unit 7 records the set of the fixed code and the subordinate code received from the code generation unit 3 in the customer table (business data storage unit 8). FIG. 7A shows the customer table (business data storage means 8) in this state.

  Further, the business data management means 7 acquires the date and time data obtained by storing the input data in the customer table (business data storage means 8) from the database server, and stores it as history data in the customer table (business data storage means 8). Each record data, processing classification = 0 (registration), operation program ID = HAN060, acquired date / time data, and user ID are passed to the change history management means 4.

  The change history management means 4 stores the history data received from the business data management means 7 in the customer change history table (change history storage means 6). At this time, the history number generation means (not shown) searches the customer change history table for a combination of the same fixed code and subordinate code, and stores the initial value “1” as the history number. FIG. 7B schematically shows the customer change history table (change history storage means 6) in this state.

  Through the processing as described above, registration processing of a customer name having the same normal code as the normal code used in the past can be performed.

  Next, a process of changing the normal code “00101” to “10001” when the necessity to change the normal code of “◯ △ store” occurs will be described. Even if the normal code is changed, the fixed code cannot be changed, so it is not changed.

  For example, the user selects a predetermined menu (for example, “code change menu”, corresponding to operation program ID = “HAN0612”) on the input screen of the client terminal 2, and changes the normal code of the customer name “○ △ shop” When the request to be input is input, as input data, normal code before correction = “00101”, normal code after correction = “10001”, processing category = “1” (indicating “change”), operation program ID, user ID Are transmitted to the business management system 1 and received by the input processing means 9.

  When the input processing means 9 passes the input data to the business data management means 7, the business data management means 7 determines that the processing category = 1 (change), and changes the customer table (business data storage means 8). Process. The business data management means 7 rewrites and records the normal code from “00101” to “10001”. Such correction processing is the same as that of the conventional business management system 1.

  Further, the business data management means 7 obtains the date / time data obtained by correcting the input data in the customer table (business data storage means 8) from the database server, and rewrites it as history data in the customer table (business data storage means 8). Each data of the recorded record, process classification = 1 (change), operation program ID = HAN0612, acquired date / time data, and user ID are passed to the change history management means 4.

  The change history management means 4 stores the history data received from the business data management means 7 in the customer change history table (change history storage means 6). At this time, the history number generating means (not shown) searches the customer change history table for a combination of the same fixed code and subordinate code, but already has the same fixed code “00101” and subordinate code “1”. Since the history number is extracted, “1” is added to the history number, that is, the history number is set to “2” in the customer change history table (change history storage means 6). Remember me.

  FIG. 8A schematically shows the state of the customer table (business data storage means 8) in a state where the correction processing as described above has been performed. The customer change history table (change history storage) in this state is shown in FIG. FIG. 8B schematically shows the means 6).

  Next, a description will be given of a case where the log output processing is performed in the business management system 1 in which the above processing has been performed, because the log output is necessary.

  For example, when the user selects a predetermined menu (for example, “log output menu”) on the input screen of the client terminal 2 and inputs a log tracking request for the normal code “10001”, the log output means 5 is good at A set of the fixed code “00101” and the subordinate code “1” corresponding to the normal code “10001” is acquired from the destination table (business data storage means 8). Next, a record having a set of the acquired fixed code and dependent code is extracted from the customer change history table (change history storage means 6), and the change history of the corresponding fixed code and dependent code is searched and extracted. An example of the log extracted in this way is shown in FIG.

  According to the log in FIG. 9, the normal code “10001” registered at this time is a code indicating the customer name “◯ △ store” and is registered by the operator “P012” on June 11, 2007. It can be seen that the code was changed by the same operator on September 5, 2007.

  A case where the log output process of the normal code “00101” is performed will be described.

  As described above, when the user selects a predetermined menu (for example, “log output menu”) on the input screen of the client terminal 2 and inputs a log tracking request for the normal code “00101”, the log output means 5 Retrieves a set of a fixed code and a subordinate code corresponding to the normal code “00101” from the customer table (business data storage means 8), but it does not exist. Accordingly, the log output means 5 next searches the customer change history table (change history storage means 6) for a combination of the fixed code and the subordinate code corresponding to the normal code “00101” (from the beginning, the customer change history table is stored). You can search).

  Then, a set of a fixed code and a subordinate code having the inputted normal code “00101” is acquired. Then, the customer name that was the normal code “00101” in the past can be searched. Here, “XX store” (fixed code “00101” subordinate code “0”), “XX store” (name changed from ○ □ store) (fixed code “00101” subordinate code “0”), “ A list of △ shops (fixed code “00101” but changed to “10001” in the middle, subordinate code “1”) can be searched. This state is schematically shown on the screen via the output processing means 10 in FIG.

  If the deletion data is the target of the log output process from the beginning, the log output means 5 starts from the customer change history table (change history storage means 6) with the processing classification “2” (in addition to the normal code) ( Searching for a record having “delete”) is the fastest. FIG. 11 schematically shows this state on the screen via the output processing means 10.

  When the user selects a specific record with the mouse or the like from the log search result screen of FIG. 10 or FIG. 11, the log output means 5 displays the more detailed history screen as shown in FIG. Display through. History transitions can also be displayed by selecting before and after each history. FIG. 12A to FIG. 12C show three history transitions.

By using the present invention, the business management system 1 capable of managing the change history accurately even if the code is reused, changed, or the like can be realized. Thereby, for example, even if the same code is used again for a different target after deleting or changing a code once used for a certain target, the log can be traced accurately.

It is a conceptual diagram of the system configuration | structure of this invention. It is a flowchart which shows the whole process of this invention. It is a flowchart which shows the production | generation process of the fixed code and a dependent code of this invention. It is a figure which shows typically a customer table at the time of registering "(circle) shop" and a customer change log | history table. It is a figure which shows typically a customer table at the time of correcting "XX store" to "XX store" and a customer change log | history table. It is a figure which shows typically a customer table at the time of deleting "(circle) * shop" and a customer change log | history table. It is a figure which shows typically a customer table at the time of registering "(circle) store" and a customer change log | history table. It is a figure which shows typically a customer table at the time of correcting the normal code of "(circle) store" and a customer change log | history table. It is a figure which shows an example of a log output process typically. It is a figure which shows typically another example of a log output process. It is a figure which shows typically another example of a log output process. It is a figure which shows typically the display screen of detailed historical information. It is a figure which shows typically the case where the code is deleted and reused in the conventional business management system. It is a figure which shows typically the case where the code is changed in the conventional business management system. It is a figure which shows an example of the hardware constitutions of the computer system of the business management system of this invention.

Explanation of symbols

1: business management system 2: client terminal 3: code generation means 4: change history management means 5: log output means 6: change history storage means 7: business data management means 8: business data storage means 9: input processing means 10: Output processing means 20: arithmetic device 21: storage device 22: display device 23: input device 24: communication device

Claims (5)

A business management system connected to a client terminal via a network,
The business management system includes:
Data of each target processed by the business management system is stored, and the data of each target is stored in correspondence with a normal code displayed to a user, a fixed code generated by the business management system, and a subordinate code Business data storage means,
Change history storage means for storing change history for each target data, and storing the change history in association with the normal code, fixed code, and subordinate code;
Business data management means for executing processing for the business data storage means;
Change history management means for executing processing for the change history storage means;
When registering new target data in the business data storage means in response to a request from the client terminal, a combination of a fixed code and a subordinate code is used using a normal code assigned to the target data. Code generation means for generating
The business data management means includes
When a registration request for new target data is received from the client terminal, the normal code received from the client terminal or the automatically assigned normal code is passed to the code generation means for the new target. The fixed code and the subordinate code are generated, the fixed code and the subordinate code generated by the code generation means are received, and the normal code, the fixed code and the subordinate code are paired as the new target data. Memorize it in the data storage means,
A business management system characterized by this. The fixed code is a code that is the same as the normal code assigned to the target when the target is registered in the business management system, and is not changed even if the normal code is changed. Yes,
The subordinate code is a code for identifying a different fixed code from the same fixed code used for different objects in the past.
The business management system according to claim 1, wherein: The subordinate code is a code indicating how many times the fixed code has been used in the past.
The business management system according to claim 2, wherein: The code generation means includes
Generate the same code as the normal code received from the business data management means as a fixed code,
Based on the generated fixed code, a search is made as to whether the same fixed code as the fixed code exists from the business data storage unit or the change history storage unit,
As a result of the search, if the same fixed code does not exist in any storage means, an initial value is generated as a subordinate code for the fixed code,
If the same fixed code exists in one or both storage means as a result of the search, a dependent code is generated by calculating a predetermined value for the maximum value of the dependent code assigned to the same fixed code. And
Passing the generated fixed code and subordinate code to the business data management means;
The business management system according to any one of claims 1 to 3, wherein The business system further includes:
Upon receiving a log output request for the target from the client terminal, the log search means searches the change history storage means and executes log output processing for the target,
The log output means includes:
Receiving from the client terminal a normal code assigned to the target;
A fixed code and a subordinate code corresponding to the normal code are retrieved from the business data storage means or the change history storage means;
Retrieving the change history corresponding to the fixed code and the subordinate code from the change history storage means, and transmitting to the client terminal,
The business management system according to any one of claims 1 to 4, wherein

Images