The title of the invention: database, data management server, and data management program
Technical field
[0001]
　The present invention, the database is available in the ERP system, data management server equipped with the database, and a data management program, which is mounted to the data management server.
BACKGROUND
[0002]
　Conventionally, core business system as a package software for building, ERP (Enterprise Resource Planning) (or, ERP package) are utilized what is called in the enterprise.
[0003]
　As the ERP is mounted system, and sales management in the company, purchasing management, inventory management, production management, financial accounting, management accounting by linking the line-of-business in real time, such as, it allows for centralized management of information about each business those and is widely known.
[0004]
　Such a system (ERP system or enterprise resource planning system), for example, performs information management resources, the ERP system that performs communication of information by the first data format determined in advance, the first A data converting device connected to a plurality of information device that performs communication of information by a second data format different from the data format, and accepts an input of information by the first data format output from the ERP system By adopting a configuration incorporating the data conversion device for transmitting information received is converted into the second data format to the information apparatus, there is what tries to increase the convenience of the system (see Patent Document 1).
CITATION
Patent literature
[0005]
Patent Document 1: JP 2009-099070 JP
Summary of the invention
Problems that the Invention is to Solve
[0006]
　However, in the conventional ERP system, the data acquired in each business process (including the data calculated from the data and various data inputted by the user), is registered in a dedicated data table, respectively (Table), manage are doing. That is, in the conventional ERP system, for each input process, such as orders and shipping instructions, table to be updated is different. The "entry process", various data such as the administrator of the ERP system has been acquired (or determined) in each business process means a process of inputting the respective tables.
[0007]
　Figure 10 is an explanatory diagram for explaining an example of a table configuration in a conventional ERP system. For example, if the business flow constituted by a plurality of business processes (process flow) is the one that shows a "stock sales", input process, orders, shipping instructions, goods issue, acceptance, and a 5 bracts of sales. In this case, the table for storing data relating to the process flow of the "inventory turnover", for example, as shown in FIGS. 10 (A) 10 (E), respectively, for each input process, order table, delivery instruction table, goods issue Table , acceptance table, and 5 become bracts of the sales table.
[0008]
　That is, in the conventional ERP system, the table to be updated for each input process was different. Therefore, the association between multiple business processes that belong to the same process flow, in identifier (Fig. 10 for the data (process data) for each business process, and the sales order item and order number in the shipping instructions table, outgoing table It was done by applying a shipment such as instruction specification) and shipping instructions number in.
[0009]
　Therefore, in the conventional ERP system, for one of the input process, identification and the table corresponding to the type of the input process, and this has been an input of an identifier of the corresponding other process data it is needed. That is, for example, in the case shown in FIG. 10, process data specified out with order number "A00001" and the order item number "0010" (ie, the same column with the order number "A00001" and the order item number "0010" in the Orders table If the process data related to business processes "shipping instructions" associated with various types of data) that is stored to be registered in the database ERP system is provided to, as process data related to "shipping instructions" business processes, shipping instructions for identifying the process data number and shipping instructions item number, data indicating type, and the contents of the business process indicates the type of business processes (for example, sold-to party, quantity, amount, shipping instructions date, such as shipping text) together with, orders and order number "A00001" there was a need to be registered in the shipping instruction table and the item number "0010". This is part of the same data to multiple tables (for example, sold-to party and quantity, amount, etc.) and the like that would have been registered, there is efficient data processing point of view viewed from problems.
[0010]
　In the conventional ERP system, when attempting to create a document according to the user's request using the various data stored in the various tables, it retrieves the required process data by following the identifier of the process data, respectively and separately Because of the need to get, if the process flow includes a number of business processes, the processing load required for outputting a document related process flow is a problem that becomes excessive.
[0011]
　The present invention is to solve the problems described above, and an object thereof is to allow that to reduce the processing load required to update or retrieve data in the ERP system.
Means for Solving the Problems
[0012]
　Database of the present invention comprises a process flow table process flow data is registered with the various data about the process flow including a plurality of business processes, the process flow data, and status data, and the common data, the process-specific data is data including the status data is data showing the progress of each of the plurality of business processes contained in the process flow, the common data is data that is common between the business processes in the same process flow is the process-specific data is data unique to the business process in the same process flow, the status data, and characterized by being updated in response to said process-specific data is updated to.
[0013]
　By the the above configuration, it is possible to reduce the processing load required to update or retrieve data in the ERP system.
[0014]
　Provided in the process flow data management server that manages the process flow data generated for each of the process flow, the process flow data management server, in response to a request from the client terminal, the a part or all of the process flow data or it may be configured to include a process flow data providing means for providing to the client terminal.
[0015]
　With a progress determination condition table progress status determination condition data is data indicating a judgment condition of progress has been registered in the process flow, the process flow data management server, the status data based on the progress determination condition There the progress determining means for determining whether meets the progress determination condition, progress notification to notify the progress to the client terminal in response to the the determined progress determination conditions are satisfied by the progress determining means or it may be configured to include a means.
[0016]
　The progress provide condition data, the process flow may be configured to include a completion condition for determining whether complete.
[0017]
　The data management server according to the present invention, there is provided a data management server that provides various data to the client terminal, the process flow data storage for storing a process flow data that includes various data about the process flow including a plurality of business processes and means, and process flow data updating means for updating the process flow data according to the progress of the process flow, in response to a request from said client terminal, a part or all of the process flow data to the client terminal and a process flow data providing means for providing the process flow data, and status data is data including a common data and process-specific data, wherein the status data includes a plurality of business processes involved in the Process Flow is data indicating the respective progress, the common data is data that is common among the work process in the same process flow, the process-specific data, specific to each business process to be included in the same process flow a data, the process flow data updating means, characterized by updating the status data in response to the update status of the process-specific data.
[0018]
　Furthermore, the data management program of the present invention, there is provided a data management program for operating the control to the data management server to provide various data to the client terminal, the data management server comprises a plurality of business processes and process flow data updating process for updating the process flow data stored in the process flow data storage means for storing a process flow data including various data concerning the process flow, depending on the progress of the process flow, a request from said client terminal Depending on the part or all of a process flow data is allowed to execute the process flow data providing process for providing to the client terminal, the process flow data includes status data, and the common data, the process-specific data is the data, the status data is data showing the progress of each of the plurality of business processes contained in the process flow, the common data can be data that is common among the work process in the same process flow the process-specific data is the data specific to each business process in the same process flow, processing in the process flow data updating process, and updates the status data in response to the update status of the process-specific data this is the order to the execution.
Effect of the invention
[0019]
　According to the present invention, it is possible to reduce the processing load required to update or retrieve data in the ERP system.
BRIEF DESCRIPTION OF THE DRAWINGS
[0020]
[Figure 1] is a block diagram showing a configuration example of enterprise resource planning system according to an embodiment of the present invention.
It is an explanatory view showing an example of a storage state of FIG. 2 process flow data.
Is a flowchart illustrating an example of FIG. 3 the database update process.
It is a flowchart illustrating an example of FIG. 4 form output processing.
[Figure 5] is an explanatory view showing an example of a search key input screen.
6 is an explanatory diagram showing an example of a form display screen.
7 is an explanatory diagram for explaining the transition of the form status based on the status of the process flow data.
8 is an explanatory diagram for explaining the usefulness of the database update process.
9 is an explanatory diagram showing an example of a storage state of progress determination condition data.
[Figure 10] is an explanatory diagram for explaining an example of a table configuration in a conventional ERP system.
EMBODIMENTS OF THE INVENTION
[0021]
　Hereinafter, an example of one embodiment of the present invention will be described with reference to the drawings.
[0022]
　Figure 1 is a block diagram showing a configuration example of enterprise resource planning system 500 according to an embodiment of the present invention. As shown in Figure 1, enterprise resource planning system 500 includes a line-of-business server 200, a data warehouse server (DWH server) 300, the client 10, the client 20. Each of the elements that make up the enterprise resource planning system 500 are connected by the respective communication network.
[0023]
　In this example, the line-of-business server 200 and DWH server 300 is assumed to be connected by a dedicated line 51. The client 10 is connected to the DWH server 300 by LAN (Local Area Network) 52. The client 20 is connected to the DWH server 300 via the Internet 53.
[0024]
　Line-of-business server 200 is, for example, a server that is managed by the administrator of the enterprise resource planning system 500, such as document information about various services, and various functions for managing the process data is data indicating information in various operational processes It has. Note that line of business server 200 in this example is constituted by general information processing apparatus including an OS (Operating System) and a relational database (relational DB).
[0025]
　Here, the form and is a general term for books and slips. Moreover, carrying and are those regarding teller money and goods are entered, a document, it is to be the evidence of transactions on a data to be a basis for creating the books operations. Incidentally, mission-critical server 200, for example, may be configured to handle a process data indicating only the voucher information used to create the various documents.
[0026]
　In addition, mission-critical server 200 in this example, as shown in FIG. 1, a service application program DB210, a process flow DB220, various data necessary for realizing the general function of the line-of-business server (for example, Various programs stored in the business application program DB210 is and an other DB230 storing data) to be used. The rest DB230, because it is not particularly relevant portion of the present invention, detailed description thereof will be omitted.
[0027]
　Business application program DB210 is a storage medium that stores a program used for various operations. The programs that are stored in the business application program DB210, sales operations management program, purchasing business management program, production management program, and the like financial accounting management program, and management accounting management program.
[0028]
　Process Flow DB220 is a storage medium for storing a process flow data composed of various types of process data that is collected and organized, etc. (or form data) by various information processing using various programs stored in the business application program DB210 is there. In this example, the process flow DB220, a case will be described where the process flow data that includes various data about the process flow including a plurality of business processes is stored in the process flow table PT. In the present example, mission-critical server 200, if the centralized will be explained a process flow data generated for each process flow in one process flow table PT.
[0029]
　It should be noted that the line-of-business server 200, the process flow data, for example, for each type will be described later, or a part of the contents of the common data, which will be described later (for example, sold-to party) is for every same thing, managed by more than one table It may be configured.
[0030]
　2 is an explanatory view showing an example of a storage state of the process flow data in the process flow DB220. As shown in Figure 2, the process flow data in this example, includes a primary key portion, and the reference key portion, and a type portion, and the status portion, and the common data section, and a process-specific data unit. Note that the process flow items corresponding to the respective portions of the data (ie, the column items in the process flow table PT), respectively, indicating the type of process data constituting the process flow data. That is, data for each business processes constituting the process flow is stored and assigned to each part constituting the process flow data. In addition, one process flow (for example, a series of process flow from order to delivery from companies) process data on is stored in the same entry in the process flow table PT (ie, the same row in the process table PT). By such a configuration, it is possible to define the correspondence between each process data.
[0031]
　Here, the "primary key portion", among the process flow data, a portion where the primary key data is data for uniquely specifying a process flow data is stored. In this example, the primary key section is composed of a process flow ID and process flow item number. That is, in this example, the combination of the process flow ID and process flow item number, the each process flow data identifier (ID). Primary key part is updated at the time of the first registration of the process flow data. Here, the "first time registration Process flow data" when the process flow data entry (data lines) are added, for example, a process data belonging to a process flow, and corresponding other processes It shall mean the time the data is registered unregistered process data. In addition, where the "update" is meant to include additional data.
[0032]
　The "Process flow number", one process flow data (ie, one column in the process flow table PT shown in FIG. 2) is an identifier for specifying a. Process flow number is predetermined items is assigned to each same process data. In the present example, process flow number, the type of process flow data and orders where the same numbers are assigned to the same process flow data.
[0033]
　The "Process Flow item number" is an identifier for specifying a specific process flow data from the same process flow number is assigned process flow data. In other words, the process flow table PT shown in FIG. 2, for example, in the business process "order" in the type of process flow "stock sales", that it has received an order amount of money as "1200," the business of "2600" from the sold-to party "T001" Process flow data including process data shown, it is possible to identify uniquely by the combination of the process flow number "000001" and the process flow item number "0010" or "0020", respectively.
[0034]
　Then, the "reference key portion", among the process flow data, such as based on transactions for sales returns, the data for identifying the other process flow data associated with the process flow (or other process data) and reference it is a part that key data is stored. In this example, the reference key section is composed of a reference number and the reference item number. Reference key section is updated at the time of the first registration of the process flow data.
[0035]
　Note that the reference item number and reference numbers, respectively, and process flow ID and process flow item number of other process flows associated with the process flow is stored. However, such as when a new transaction, if no other process flow associated with the process flow, the reference key portion, data indicating the same value as the primary key of the same entry (ie, the process at reference numeral flow number is, the process flow item number in the reference item number, respectively) is stored. The reference key part, may exhibit other process data associated with the process flows, the reference key portion, data for specifying the type of the process data is further provided.
[0036]
　The "Type part" of the process flow data is a portion such as inventory turnover and sample shipment type data is data indicating the type of process flow is stored. Type section is updated at the time of the first registration of the process flow data. The type of process flow is not limited to the stock sales and shipping samples. In addition, it is assumed that what the process for each type of process flow is required it is predetermined (that is, different types and number of business processes involved for each type of process flow). Note that the other types of process flows, later a plurality presented (see Figure 9).
[0037]
　The "Status portion" of the process flow data, data representing the progress of the process flow (ie, data indicative of a plurality of business processes each progress in the process flow) status data is are stored Partial is. In this case, status data, to business processes required by the process flow, "0" for those pending, by "1" is set to those of Kisai, the progress of the business process It is shown. That is, as shown in FIG. 2, for example, a process flow of the "inventory turnover" business process in the process flow "order", "delivery", "outgoing", "outgoing inspection", and "sales" If it is, process-specific data related to business processes "order" (for example, order date) it is assumed that have been registered. In this case, the status data will become part corresponding to "sales" is "1", the other part is the initial state (that is, "0" is set state) and remains.
[0038]
　In other words, the status section in this example, is updated every business process. In other words, the status section, when the input of the process-specific data which will be described later, specifically, are updated when it is determined each business process is completed by a predetermined status change condition is satisfied. Note that the status change condition is not particularly limited, in this example, "one of the process-specific data is any input corresponding to the business process" is stored in a predetermined storage area of ​​the line-of-business server 200 as status change condition It is I shall have.
[0039]
　In the present example, since the different type of process flow is stored in the same table, one of item (column item) constituting the table, resulting in the portion for storing the unnecessary processes data for a particular process flow If there is also. In this case, in the process flow table portion for storing an unnecessary process data become null data, the status data corresponding to the null data is assumed that "0" is stored.
[0040]
　The "common data section" of the process flow data, such as sold-to party and shipping destination, is data that does not depend on business processes (that is, data that is common between the business processes in the same process flow) Common It is a portion in which the data is stored. Common data section is updated at the time of the first registration of the process flow data.
[0041]
　In addition, the "process-specific data portion" of the process flow data, indicating the notes, such as data to be registered in the Order Date and each business process (for example, "delivery no later than" and "Fragile (Fragile)" text Data) including, for each business process in the same process flow a portion to be stored in the process-specific data is a specific data. Process-specific data unit is updated every business process. Therefore, in this example, out of a process flow data, it is due to business processes "process-specific data", which does not depend on the business process is said to be "common data".
[0042]
　Above but a description of the process flow data in this example, wherein the briefly described definitions of various terms shown in FIG.
[0043]
　First, the "orders", in response to the order from the customer, it means a state that signed a contract with the customer. The "shipping instruction" means a state that made the instruction to ship goods to warehousing and distribution skilled personnel. Further, the "Issue", products are shipped from the warehouse, I mean a state in which the movement has been started. In addition, the "acceptance", and the customer's acceptance is complete, I mean a state in which the ownership of the goods has been transferred to the customer. In addition, the "sales", confirms the acceptance of customers, amount of receivables for the customer means a deterministic (= recorded a receivable) state.
[0044]
　In addition, the term "acceptance", at the time "delivery products and services, specification of order street (of = order as quantity, color and shape, quality) inspect business or has become" and "final acceptance, of assets It is also used in the sense of ownership transition. " Incidentally, financial accounting (or institutional accounting) On and ERP systems, in order to clarify the transition timing of the ownership of the asset, the event of "acceptance" is defined to distinguish the goods issue.
[0045]
　Line-of-business server 200, various kinds of data stored in the process flow DB220 and other DB230, CSV according to the predetermined extraction condition
has a function of transmitting the DWH server 300 is converted into (Comma Separated Values) format. It should be noted that, in this example, line-of-business server 200 transfers the data file that was in CSV format to DWH server 300 by FTP (File Transfer Protocol).
[0046]
　DWH server 300 is, for example, a server that is managed by the system administrator of the system, has various functions to realize the data warehouse. Here, "data warehouse", (in this example, the process flow data) business data, such as stored form data in a time series refers to a system for analyzing the relationship between the item from the. Also, DWH server 300 by, for example, convert the CSV format file transferred from the line-of-business server 200 into a predetermined data format, having the function of registering a variety of data in a predetermined storage area. Incidentally, DWH server 300 without conversion of the data format may be the extracted configuration data corresponding to each storage area from the state of the CSV format.
[0047]
　The client 10, 20, CPU (central processing unit), ROM, a RAM, and an information processing apparatus provided with such a display unit (client terminal). In this example, client 10 and 20, such as a Web browser or a spreadsheet, assumed to have a variety of applications available to handle form data. In the present example, client 10 and 20, for example in response to the operation input by the user (in this example, the process flow data) necessary form data from a DWH server 300 queries (search item for obtaining, search key, etc. extracts key) is defined, and has a function of transmitting the DWH server 300.
[0048]
　In this example, client 10 communicates with DWH server 300 via the LAN, has a function of outputting to the display unit data obtained from DWH server 300 by a given spreadsheet.
[0049]
　The client 20 communicates with DWH server 300 via the Internet, has a function of outputting the data acquired from DWH server 300 on the display unit by a Web browser.
[0050]
　In the present example, the client 10, 20 based on the process flow data stored in the process flow DB220 line-of-business server 200 has a function of outputting a document with a predetermined form on the display section itself comprising .
[0051]
　Note that integrated structure of the enterprise resource planning system 500 is not limited to this, for example, and the client 10, 20 and line-of-business server 200 may be configured to perform transmission and reception of data directly without the intervention of the DWH server 300 . That is, the client 10 and 20, the process flow may be directly accessible configuration DB220B.
[0052]
　Next, will be described with reference to the drawings, the operation of the line-of-business server 200 in the enterprise resource planning system 500. Note that in particular not related operations and processes of the present invention may have been omitted its contents.
[0053]
　Figure 3 is a flow chart showing an example of a database update process mission-critical server 200 executes. In the database update processing, the processing for updating the process flow DB220 in mission-critical server 200 is executed.
[0054]
　In database update processing, first, line of business server 200 determines whether it has acquired the new process flow data (New Process flow data) (step S101). Here, if it is determined that it has not acquired a new process flow data (N in step S101), line-of-business server 200 proceeds to the processing in step S103 described later.
[0055]
　On the other hand, when determining that it has acquired a new process flow data (Y in step S101), line-of-business server 200, and registers the acquired process flow data in the process flow table PT (step S102).
[0056]
　Then, line-of-business server 200 determines the registered process flows Process data corresponding to the data (ie, data about business processes constituting the process flow) whether it has acquired a (step S103). Here, if it is determined that it has not acquired the process data corresponding to the registered process flow data (N in step S103), line-of-business server 200 refers to the other DB230, a storage area corresponding to the obtained data and identify and registers the acquired data (step S104), and the process proceeds to step S101.
[0057]
　On the other hand, if it is determined that the acquired process data corresponding to the registered process flow data (Y in step S103), line-of-business server 200 registers the process data in the corresponding items in the process flow table PT (step S105).
[0058]
　Incidentally, whether or not the determination process data acquired by the line-of-business server 200 is registered in the process data, the process flow data process flow table having a combination of a process flow ID and process flow item number of the acquired data has It is performed by determining whether or not stored in the PT. Therefore, in this example, the data line-of-business server obtains the (data input by executing's business or data created by the business application program), the data (ie, constituting the main key portion, the process flow number a process flow item number) is it is necessary to contain.
[0059]
　When registering the process data, line-of-business server 200 determines whether a predetermined status change condition about the process flow data is satisfied by the registration of the process data (step S106). Here, the process data it is determined that not met the predetermined status change condition in response to registered (N in step S106), line-of-business server 200 moves to step S101.
[0060]
　Meanwhile, in response to the process data are registered is determined that the predetermined status change condition is satisfied (Y in step S106), line-of-business server 200, based on the filled status change condition, the process flow data It updates the status data including (step S107), and the process proceeds to step S101.
[0061]
　Database update process in this example, for example, be terminated by the end operation by the administrator of the line-of-business server 200.
[0062]
　The database updating process may be a process performed in real time, and may be a batch process to be executed for each certain unit of time. Also, for example, only the specified period of time, such as for real-time processing, it may be a process having a real-time part (near real time processing).
[0063]
　Next, will be described with reference to the drawings, the operation of the line-of-business server 200 and DWH server 300 and the client 10, 20 in the enterprise resource planning system 500 of this example. Note that in particular not related operations and processes of the present invention may have been omitted its contents.
[0064]
　Figure 4 is a line-of-business server 200, and DWH server 300 is a flowchart showing an example of a form output processing and the client 10 is performed. In form output processing, mission-critical server 200, by providing a process flow data (some or all of the process flow data) to the client 10 via the DWH server 300, displays the document on the display screen to the client 10 comprises processing for is executed. Incidentally, the client 10 and the client 20, the type of communication network such differ only, will be described as an example the case of using the client 10 in this example. In addition, DWH server 300 in this example, the auxiliary for the line-of-business server 200 and the client 10 to communicate (for example, authentication, etc. of the client) because only perform, a description of the operation of the following DWH server 300 omitted .
[0065]
　In form output processing, first, the client 10, for example in response to the operation input by the user A of the client 10, and sends the retrieval key input screen request to the line-of-business server 200 (step S301).
[0066]
　Upon receiving the search key input screen requirements, mission-critical server 200 transmits a search key input screen corresponding to the search key input screen request received (step S201).
[0067]
　Upon receiving the search key input screen, the client 10 displays the search key input screen on the display screen of the display unit itself provided (step S302).
[0068]
　5 is an explanatory view showing an example of a search key input screen. As shown in Figure 5, the search key input screen, pull-down format, a search item display area 11 for items that are set in the process flow table PT is displayed in a selectable manner, and accepts the input of the search key by the user A a search key input area 12, a button 13 for returning receiving a request for switching the display screen to be outputted to the display unit on the other display screen, and a search button 14 for accepting a retrieval request process flow data by a search key and search items provided.
[0069]
　The client 10, for example, upon receiving a selection of a search item by cursor P operable by mouse operation, to the selected search item and temporarily selected state. Then, when accepting the selection of the search button 14, the client 10, the selection of the search item in the provisional selection state is determined that it has been received (the selection) (step S303), the search key in the selected search item and it transmits the search key entered in the area 12 to the line-of-business server 200 (step S304).
[0070]
　Upon receiving the the search item and the search key, line-of-business server 200 of the process flow data registered in the process flow table PT, in the field (ie, column items in the process flow table PT) indicating the search item is received, identical to the search key that is received (or, including a search key received) string to search a process flow data registered (step S202). Note that if the search key at this time is empty data is mission-critical server 200 has a process data to the search item is received (ie, the data other than null data is stored in the search item received) Process Flow may be used as the configuration for all of the data retrieval, it may be configured to send a search error notice to the client 10.
[0071]
　A search process flow data, line-of-business server 200 sends process flow data that has been retrieved to the client 10 (step S203), the process ends here.
[0072]
　Meanwhile, upon receiving the process flow data, the client 10, based on the received process flow data, and displays the document display screen on the display screen of the display unit itself provided (step S305).
[0073]
　6 is an explanatory view showing an example of a form display screen. As shown in Figure 6, to the form display screen, a document display area 21 for displaying the document based on the process flow data, the document status display area 22, a return button 23, are provided a change button 24. The client 10 changes the scale of the document displayed in the document display area 21 in response to an operation of the keyboard provided for example, the client 10.
[0074]
　Here, the document display area 21, a part or the whole of the process flow data in a predetermined display mode is displayed. In the present example, information for displaying a part or the whole of the process flow data in a predetermined display form, is created by the line-of-business server 200, for example, at the timing of step S203 in the form output processing, the client 10 It shall be sent to. Incidentally, the client 10, based on the information stored in the storage device itself comprises a part or all of the received process flow data may be configured to be displayed in a predetermined display form to the form display region 21.
[0075]
　Furthermore, document status display area 22, the type of document to be displayed on the document display area 21 is an area for displaying (or situation. Hereinafter referred. Status). As the form of status, for example, sales order, material documents, inspection documents, and such as invoices, is considered a variety of things.
[0076]
　Further, a return button 23 is a button for receiving a request to return the display screen to the search key input screen. Also, change button 24 is a button for receiving a request to change the display contents of the document display area 21. The following, it will be described with respect to processing of changing the display contents of the document display area 21.
[0077]
　When displaying a document display screen, the client 10 determines whether it has received a document status change requested by the user A (step S306).
[0078]
　In this example, the client 10, first of all, accepts the selection of the form status display area 22 by the user A. Then, for example, upon receiving a selection of a document status display area 22 with a cursor P can be operated by the mouse operation, the client 10, selectably displays a list of form status name indicating a form of a viewable form, for example in the pull-down to.
[0079]
　As for the form status names to be displayed here, it is assumed that received together with the process flow data from the line-of-business server 200. Specifically, line-of-business server 200 in advance predetermined data relating to the form of the stored document in the storage area (form form data) and the process flow data state (ie, the input states of each column item in the process flow table PT ) and on the basis, to identify the document status name indicating a form of a viewable form. That is, for example, type of process flow data to be transmitted to the client 10 is "inventory turnover", if the process-specific data unit is not only the process data related to business processes "order" registration line-of-business server 200, document It identifies only the "sales order" as a status name. In addition, other process data related to business processes "order", if the process data related to business processes "Issue" is registered, line-of-business server 200, as document status name, as "sales order" and "material document" Identify.
[0080]
　7 is an explanatory diagram for explaining the transition of the form status based on the status of the process flow data. 7, image 101 to 104 (specifically, documents) form that may be displayed in the document display area 21 based on the respective process flow data to be in the form of. The image 101 to 104 is an explanatory diagram for explaining the transition of the form status does not indicate a specific description example for serving as a variety of forms.
[0081]
　Here, when described with the image 104 as an example, the region 111 is a form status name in the image 104, region 112 is the type of process flow, region 113 is the name of the business processes of the process data that is included in the process flow data, respectively (In this example, the character string display region) region shown is assumed to be. In the present example, the document status name corresponding to the type of process data in the process flow data is being displayed in the area 111.
[0082]
　In this case, as indicated by the transition from the image 101 in FIG. 7 to the image 104, every time the process data corresponding to each business process on one process flow data will be registered, the form status name (ie, the process so that the going increasing type in the form of displayable form) on the basis of the flow data. This is the "whether or not there are the following types of form" but that "in accordance with the state of the process flow data document status is going up (ie, gradually increasing the types of displayable form)" means.
[0083]
　Hereinafter, prior to the processing in step S305 in the form output processing, the client 10, the business process "order", continuously described as an example a case of receiving a process flow data including "outgoing". In the present example, in the process of step S305, the document status designation of the client 10 corresponds to the business process "orders" which is located higher than the business process "Issue" in the process flow shown received process flow data a form corresponding to the "sales order", it is assumed that was displayed in the form display region 21 (see Figure 6).
[0084]
　In the reception determination processing of a form status change request (step S306), and it is determined not received a form status change request from the user A (N in step S306), the client 10 proceeds to the processing in step S308 described later.
[0085]
　On the other hand, when determining that accepts the document status changes requested by the user A (the Y step S306), the client 10, the document display area 21, and displays the document in response to the change request has been accepted (step S307). In this example, the client 10, accepts the selection of a form status name "material document" corresponding to the business process "Issue" by the user A, the document display area to form the (material document) corresponding to the business process "Issue" It is assumed that to display in the 21. It should be noted that, in this case, the client 10, to the form status display area 22, to display the form status name "material document".
[0086]
　When displaying a document corresponding to the document status change request, the client 10 determines whether to end the form output processing (step S308). Here, if it is determined not to end the form output processing (N in step S308), the client 10 proceeds to the processing in step S306.
[0087]
　On the other hand, for example when it is determined as to terminate the form output processing by accepting a predetermined end operation by the user A (Y in step S308), the client 10, the process ends here.
[0088]
　As described above, in the embodiment described above, the database (for example, the process flow DB220) process, which includes various data relating to the process flow (for example, the process flow type "inventory turnover") containing a plurality of business processes comprising a process flow table PT which flow data is registered, the process flow data, including the status data, the common data, the process-specific data, status data, a plurality of business processes in the process flow (for example, order , shipping instructions, goods issue, goods issue inspection, sales) is the data that shows each of progress, common data, data that is common between business processes that are included in the same process flow (for example, data indicating such as sold-to party and the amount of money The) and the process-specific data, a specific data for the business process to be included in the same process flow (for example, order date and order text), status data, process-specific data in response to the updated It is updated (eg, in response to the process-specific data is added, the corresponding status data is changed from "0" to "1") so that a configuration, it is required to update or retrieve data in the ERP system it is possible to reduce the processing load.
[0089]
　In other words, it is possible to reduce the amount of I / O data that occurs during data updating (output data).
[0090]
　8 is an explanatory diagram for illustrating the usefulness of database update processing for mission-critical server 200 described above is executed.
[0091]
　Figure 8 (A) is a table showing a comparison result of the data updating amount at the time of the first process data input. Here, the first type of process data that is input (ie, the type of business process) is not particularly limited. The "conventional", as shown in FIG. 10 means a database with a table for each business process. Furthermore, the "difference data amount" is not intended to indicate the exact number, when updating the data stored in the conventional table and new type process flow table (ie, the process flow table PT, see FIG. Hereinafter, a case when comparing with the conventional type was compared with the case of updating the data stored in the appropriate "New Type" and is referred to.), the case where data quantity of the newer type handled increases to + ( Plus), a case where the amount of data handled by the newer type is low - (negative), the case where the amount of data handled by the new-type and the conventional type can be regarded as equivalent to a "0".
[0092]
　In this case, at the time of input of the first process data, it becomes large amount of data towards the new type handle only minute there is a need to update the status section. However, since the data amount of the status portion is small, in substantially the traditional and the new type, a large difference in the amount of I / O data (input data and output data) I said no.
[0093]
　On the other hand, FIG. 8 (B) is a table showing a comparison result of the data updating amount when the input for the second process and later process the data. That is, for example, the primary key unit, the reference key portion, the type unit, the status section, the common data section, and the process-specific data of the part (for example, business process process-specific data "reception date" corresponding to the "order", " Order Text ") is a table showing a comparison result of the data updating amount when the input of process data corresponding to the business process in the process flow entered into the process flow data table PT. The "traditional", in order to define the correspondence between the entered process data, such other process data corresponding to the registered process data (order data) to the order table (eg, business process "shipping If you enter a process data corresponding to the instruction "(shipping instruction data)) is, as a shipping instruction data, primary key part in the present example, the reference key section, type part, corresponding to the common data section, and process-specific data portion Other data (see FIGS. 2 and 10), which, it is necessary to input indicate corresponding order data as "order number" and "Order Details".
[0094]
　In this case, at the time of input of a second process after the process data, as compared with the conventional type that require all parts other than the status section, the new type, and updates only the status portion and the process-specific data section Because, the less the amount of I / O data.
[0095]
　Thus, the newer type is reduced the amount of I / O data than conventional, on the system of performance, it is advantageous.
[0096]
　In other words, since the I / O of the database it is possible to reduce, it becomes possible to realize reduction in the writing volume, reduction of the capacity of the entire database, and a reduction in processing load required for search processing of the data . Note that the reduction of the processing load required for the search process, that the process (process data) does not span multiple tables also becomes a factor.
[0097]
　In addition, in the new type, there is an advantage that to some extent the input order of the pre-Seth data, can be in any order. In other words, considering for example the type "inventory turnover", in the case of the conventional type, the order of the process flow, orders, shipping instructions, goods issue, goods issue acceptance, limited in the order of sales, it is not possible to change the order. This is, in the conventional table structure is because it is represented by giving a primary key of the previous business process relationships between business processes, the data of the business process after (eg, in the shipping instruction table "order number" and "order item" reference. Figure 10). On the other hand, in the table structure of the new type, the data of the business processes involved are stored in the same entry (ie, the same column of the same table). Therefore, it has no restrictions on the context between business processes, it becomes possible to flexibly rearranged the order of the business process. That is, when for example a sequence of actual operations is "orders after the shipping instruction", the input order of the process data, it is possible to make the shape along the order of the actual business. Therefore, (in other words, on the internal control) on the progress management, it is advantageous for the conventional. It should be noted, in particular, is a business order of the current wholesale industry "orders after the shipping instructions".
[0098]
　In the new type, it is possible to reduce the load required for querying the progress of the process flow. That is, if the process flow is to check whether or progressed far, in the conventional table structure, in order from the table of the starting slip, it is necessary to check the registration status of all the tables up to the final document table. For example, given the type "inventory turnover" as an example, orders, shipping instructions, goods issue, goods issue inspection, it is necessary to check the five tables claims. On the other hand, in the table structure of the new type, since the progress of the process flow to have a "Status portion", one of the tables, it is possible to check the progress by simply querying one entry. This is when using or developing a query screen progress, it is advantageous.
[0099]
　In the embodiment described above, the database (eg, process flow DB220) are process flow data management server that manages the process flow data generated for each process flow (for example, line of business server 200) provided in the process flow Data management server, a client terminal (for example, the client 10, 20) in response to a request from, since a structure that provides some or all of the process flow data to the client terminal, a task flow data (eg, the form of it is possible to construct a system in which the processing load is reduced compared to the prior art required to provide process flow data) indicating the document information needed to create.
[0100]
　Although not particularly mentioned in the embodiment described above, the database (eg, process flow DB220) is, progress determination progress determination condition data is data indicating a judgment condition of the progress of the process flow is registered and a condition table, process flow data management server (for example, line of business server 200), the status data based on the progress determination condition (for example, data stored in the status section in the process flow table PT. See Figure 2.) There it is determined that meets the progress determination conditions, filled in are as the determined progress determining client terminal to progress in accordance with the conditions (for example, the client 10, 20) may be configured to inform the.
[0101]
　9 is an explanatory view showing an example of a storage state of progress determination condition data stored in the progress status determination condition table. As shown in Figure 9, the progress determination condition data in this example, includes the type of process flows, and a progress determination conditions corresponding to the type of process flow.
[0102]
　Here, the type of process flow, other stock sales described above, sample shipping, service sales, change of name (sales), name change (shipment), sales returns (with reference the original transaction), sales returns (the original transaction reference No), the sales amount adjustment (plus), such as sales amount adjustment (minus), can be considered a variety of things with different business processes.
[0103]
　The "progress determination condition" is intended to indicate a criterion for the progress of the process flow, in this example, business processes required for each type of process flows (for example, orders, shipping instructions, goods issue, goods issue acceptance, and it shall "1" is set in advance business processes that are set for each type) of the sales.
[0104]
　Line-of-business server 200 of the process flow data stored in the process flow table PT, when the state of the status portion matches the progress status determination condition data, the process flow data entry is in a state of "completed" judgment (ie, it is determined that the process flow showing the process flow data is completed), to that effect a given client (eg, a client 10, 20) performs the process (notification process) for notifying the.
[0105]
　By such a configuration, it becomes possible to construct a possible determination of job performance status system. In particular, since the determination process of the business execution status by simply comparing the status data included in the process flow data and progress status determination condition data it is possible, it is necessary to refer to the input state of the data stored in multiple tables Compared with the prior art, it is possible to reduce the processing load required for the determination of the business execution status.
[0106]
　Note that the start timing determination process or notification process in progress, it may even when there is a request from the client terminal, may be a preset timing.
[0107]
　In the example of progress the determination condition table as described above, progress determination condition data, the process flow is configured to include a completion condition for determining whether complete, is easily completed determination of a series of operations it is possible to construct a system.
[0108]
　Incidentally, the progress determination condition data is not limited to those for determining the process flow is in the state of "completed" includes, for example, data for determining to be in the state of "50% complete" It may be configured. In addition, the progress determination condition data may be configured to indicate the types of process data that should be entered before the predetermined time from the time of input of the first process data has passed.
[0109]
　Also, the progress determination condition table, not only the determination function of the above-described "should be input data are entered all", the input data to "so that not to be the input data is not input" the ability to limit may be configured to have. In this case, for example, compared to line-of-business server 200, when updating the process flow table PT, if the process data to be added is a process-specific data, the the type of process-specific data to be added and the progress determination condition table And then, it is sufficient that the structure type of process-specific data to be added is not updated in the process flow table when the "1" to the progress condition table and corresponds to the business process that is not set.
Industrial applicability
[0110]
　According to the present invention, it is useful to build the ERP system and reduce the processing load required for updating and retrieving data.
Description of the code
[0111]
　PT process flow table
　10 client
　20 clients
　51 dedicated line
　52 LAN
　53 Internet
　200 line-of-business server
　210 business application program
　DB 220 process flow
　DB 230 other
　DB 300 DWH server
　500 enterprise resource planning system

Claims
[Claim 1]
　Comprising a process flow table to the process flow data is registered with the various data about the process flow including a plurality of business processes,
　the process flow data is data including the status data, the common data, the process-specific data,
　The status data is data showing the progress of each of the plurality of business processes contained in the process flow,
　the common data is data that is common among the work process in the same process flow,
　the process-specific data is data specific to each business process in the same process flow,
　the status data is updated in response to said process-specific data is updated
　and wherein the database.
[Claim 2]
　Provided in the process flow data management server that manages the process flow data generated for each of the process flow,
　the process flow data management server, in response to a request from the client terminal, the a part or all of the process flow data including the process flow data providing means for providing to the client terminal
　database of claim 1.
[Claim 3]
　With a progress determination condition table progress status determination condition data is data indicating a judgment condition of progress has been registered in the process flow,
　the process flow data management server,
　the status data based on the progress determination condition There the progress determining means for determining whether meets the progress determination condition,
　progress notification to notify the progress to the client terminal in response to the the determined progress determination conditions are satisfied by the progress determining means and means
　database of claim 2.
[Claim 4]
　The progress determination condition data includes a completion condition for determining whether the process flow is complete
　database of claim 3.
[Claim 5]
　A data management server that provides various data to the client terminal,
　and process flow data storage means for storing a process flow data that includes various data about the process flow including a plurality of business processes,
　the progress of the process flow and process flow data updating means for updating the process flow data according,
　comprises in response to a request from said client terminal, and the process flow data providing means for providing a part or all of the process flow data to the client terminal ,
　the process flow data, and status data is data including a common data and process-specific data,
　the status data is data showing the progress of each of the plurality of business processes contained in the process flow,
　The common data is data that is common among the work process in the same process flow,
　the process-specific data is data unique to the business process in the same process flow,
　the process flow data update It means to update the status data in response to the update status of the process-specific data
　data management server, characterized in that.
[6.]
　A data management program for operating the control to the data management server to provide various data to the client terminal,
　the data management server,
　and the process in accordance with the progress of the process flow including a plurality of business processes and process flow data updating process for updating the process flow data stored in the process flow data storage means for storing a process flow data including various data concerning the flow,
　in response to a request from said client terminal, the process flow data one The part or the whole to execute the process flow data providing process for providing to the client terminal,
　the process flow data is data including the status data, the common data, the process-specific data,
　the status data, the is data indicating a plurality of business processes each progress in the process flow,
　the common data is data that is common among the work process in the same process flow,
　the process-specific data, the same process a data specific to each business process in the flow,
　the process flow in the data update processing, the processing for updating the status data in response to the update status of the process-specific data
　data management program for executing.