JP4157112B2 - Business integrated management system automatic generation device, business integrated management system automatic generation method, business integrated management system automatic generation program - Google Patents

Description

  The present invention relates to an automatic generation apparatus or the like that adapts a management integration system to the work of an individual company.

  Conventionally, in the field of management integrated systems, system engineers and systems have been designed by system engineers to deal with individual circumstances of users. Specifically, each program such as purchasing, inventory, accounting, cost, process, etc. is created, a unit test of each program module is performed, an operation test of the entire system is performed, and an actual operation is started. However, developing such a unique program is a large economic burden for small-scale companies, and not only is it economical, but also the development period is long before the system is completed. In addition, obstacles to daily work are also a major burden.

Therefore, in recent years, in order to efficiently construct such a system, an effort has been made to apply an existing base program to a business of an individual company by customizing the base program. As a result, it has become possible to achieve a certain purpose by modifying only the output form part according to the individual company without changing the base program or database.
JP 2001-5656 A

  However, since this kind of customization concept cannot be changed after all, the base program itself cannot be changed, so partial customization of the screen and print output is the limit. Therefore, there are limits to responding to the specific circumstances of various companies. Conversely, when introducing a system, it is necessary for the company to redefine the organization with respect to the base program. Met. There has been a problem that the actual organization management on the company side is bound by the business integration system, making it difficult to operate the company as desired.

  In particular, in the conventional business integration system, the wider the application range of the system, the more the difference between the business practice of the introducing company and the system side occurs. Therefore, there was also a problem that the system could not be used immediately without practical adjustment.

  In addition, the conventional concept of customization is to input customization information required individually and modify the screen and the like correspondingly. Therefore, when this operation is repeated, there is a case where the operation becomes complicated in the middle and the operation is confused, and it is difficult to totally customize the system.

  The present invention has been made in view of the above problems, and specifically updates the management integration system that can follow in-house business management in principle and can be introduced with a minimum organizational change. An object of the present invention is to provide an automatic generation apparatus.

  The above object is achieved by the following means.

(1) An automatic generation apparatus for a business integrated management system that integrates and manages business using a plurality of programs, and presents a basic table having basic information, and the basic table is instructed to change the basic information and By writing correction basic information including an instruction to add the basic information, information fetching means for capturing the correction basic information, a basic information array composed of a plurality of basic information, and a program array composed of the plurality of programs Tabular data formed and stored in the storage means, each cell is flagged with whether or not each program set in the program array uses the basic information of the basic information array The program matrix and the modified basic information fetched by the information fetching means are A correction program matrix generating means for writing and saving as a correction program matrix in association with the basic information array of the program, and the program integrated arrangement based on the correction program matrix when customizing the business integrated management system Program automatic updating means for expanding a plurality of the programs sequentially and customizing and updating the programs collectively using the flag description, the basic information, and the correction basic information of the correction program matrix corresponding to the expanded programs And the tabular data formed by the instruction type array and the database array, each cell having the basic information necessary for generating each database set in the database array, Set to type array A database matrix described for each instruction type and the basic correction information captured by the information capturing unit are written in association with the basic information described in the cells in the database matrix, and the corrected database matrix Correction database matrix generation means for storing the database, and the database set in the database array in order based on the correction database matrix when customizing the business integrated management system, the basic information for each instruction type And a database automatic generation means for batch generation using the correction basic information, and based on an instruction to add basic information included in the correction basic information, either the correction program matrix generation means or the program automatic update means However, in conjunction with the program to be updated, an additional field is set in the database used by the program .

  (2) The business integrated management system automatic generation device according to (1), further comprising a system management interface providing unit capable of outputting the correction program matrix to a display device.

  (3) The business integrated management system automatic generation apparatus according to (1) or (2), wherein the information fetching unit includes a plurality of the basic tables for each predetermined purpose.

  (4) The program according to any one of (1) to (3), wherein the program includes any one of a sales program, a purchase program, an inventory management program, an accounting program, a cost calculation program, and a process management program. The business integrated management system automatic generation device described.

  (5) The instruction type array of the database matrix includes a name instruction area for setting a classification name, a code instruction area for setting a code necessary for classification, a field addition instruction area for setting a field to be added, and a key item. Any one of the key item instruction | indication area | region to set, The business integrated management system automatic generation apparatus in any one of said (1) thru | or (4) characterized by the above-mentioned.

  According to the present invention, it is possible to achieve an excellent effect that introduction of an ERP system is extremely facilitated.

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

  FIG. 1 shows a device configuration example of the automatic generation device 1 of the present embodiment. The automatic generation apparatus 1 is for automatically customizing and generating a business integrated management system (hereinafter referred to as an ERP system). The automatic generation apparatus 1 includes a central processing unit 10 having a CPU 11 and a memory 12, an image display unit 12 connected to the central processing unit 10 to display various information, and an input device for inputting information to the central processing unit 10. (Keyboard) 14, a storage device 16 capable of storing various information, an external media device 18 capable of inputting / outputting information using a recording medium, a printer 20 capable of outputting necessary information as a paper medium, a client terminal 22, and the like I have. The central processing unit 10 performs arithmetic processing such as program execution and data processing. The memory 12 temporarily expands various information recorded in the storage device 16, passes data processing information to the CPU 11, temporarily holds the processed result information, and stores the storage device as necessary. 16. As the storage device 16, a hard disk is used here, and a large amount of information can be stored by a magnetic recording method. The external media device 18 uses a movable medium such as a compact disk (CD), a magnetic disk, a DVD, and a magnetic tape, and executes input / output of information to / from them. The image display device 12 is a CRT display, for example, and transmits information from the central processing unit 10 to a person in charge (user) through a screen. Therefore, communication between the person in charge and the central processing unit 10 is not established until both the image display device 12 and the input device 14 are present. Each of these devices is interconnected by a LAN, a communication line, a bus, etc., and moves as a whole in cooperation.

  The program of the automatic generation device 1 of this embodiment is stored in the storage device 16. Therefore, when the user operates the automatic generation apparatus 1, the program is called from the storage device 16, loaded into the memory 12 and executed. When the automatic generation device 1 is activated, a basic table to be described later is displayed on the image display device 12, and the person in charge who is the user follows the display to provide information unique to the company, item names used in the ERP system, and processing. Enter information about approval / change / addition of the contents as basic correction information. The input device 14 is used for this input. In addition, when the examination time is required for the input, the basic table is printed by the printer 20 and examined on the paper.

  The input correction basic information is temporarily expanded in the memory 12, but is stored in the storage device 16 at work breaks or at regular timing. By doing in this way, it is avoided that the work content disappears when a power failure or the like occurs during the work. Of course, it is always stored in the storage device 16 when the work is completed.

  The central processing unit 10 stores and saves the basic table including the corrected basic information input from the screen in the storage device 16 with the date, the input person, and the data name. At the same time, the program matrix and the database matrix stored in advance in the storage device are taken out, expanded in the memory 12, and the CPU 11 is operated to modify the program matrix and the like. This correction work is also performed by a matrix generation program stored in the storage device 16, and as a result, a correction program matrix and a correction database matrix are generated and stored in the storage device 16 again. The storage device 16 also stores a system management program and basic software, and manages basic operations of the entire system. For example, basic software means database management middleware or software for text input and table input. The correction program matrix and the correction database matrix can be output as a list.

  On the image display device 12, a basic table, error check information, a correction program matrix, a correction database matrix, correction information for each program, remaining work information, and the like are displayed as appropriate.

  Next, the functional configuration of the automatic generation device 1 will be described with reference to FIG.

  As shown in FIG. 2, the automatic generation apparatus 1 includes an information capturing unit 30, a correction program matrix generation unit 36, a correction database matrix generation unit 42, a program automatic update unit 44, a database automatic generation unit 46, and a system management interface. Providing means 48 and the like are provided.

  Further, the correction program matrix generation unit 36 includes a basic table check unit 36A as a part thereof. In addition, the program automatic update unit 44 includes a program-specific change data extraction unit 44A, an update table generation unit 44B, a program update unit 44C, and a database linkage change unit 44D. The database automatic update means 46 includes a database-specific change data extraction unit 46A and a database update unit 46B in part.

  The information capturing unit 30 captures the correction basic information in the automatic generation apparatus 1 by writing the correction basic information 54 in the basic table 50 including the basic information 52. Specifically, the basic table 50 stored in advance in the storage device 16 is displayed on the image display device 12 and presented to the user, and the basic correction information 54 required for the basic table 50 is input to the input device. 14 through the user. As a result, it becomes possible to capture the basic correction information 54 that is individually required by the company in correspondence with the basic information 52.

  The correction program matrix generation unit 36 uses the basic table 50 to check the input contents by the basic table check unit 36A while executing the writing operation on the program matrix 32 to generate the correction program matrix 34. Similarly, the modified database matrix generation means 42 uses the basic table 50 to execute a writing operation on the database matrix 38 to generate the modified database matrix 40. The program automatic update means 44 extracts necessary change data from the correction program matrix 34 by the program-specific change data extraction unit 44A. Then, the update table generation unit 44B creates an update table 44F with reference to the program change specification 44E, and the program update unit 44C updates individual programs based on the update table 44F. The database automatic generation means 46 extracts update information for each database from the modified database matrix 40 by the database-specific change data extraction unit 46A, and generates each database by the database update unit 46B. The system management interface providing means 48 provides the user with a highly convenient interface using the image display device 12 and the input device 14 during work by the automatic generation device 1.

  These functional configurations are classified as actual forms as follows. (1) As an automatically generated program, information fetching means 30, corrected program matrix generating means 36, corrected database matrix generating means 42, program automatic updating means 44, database automatic generating means 46, system management interface are provided. Means 48 are applicable. (2) Examples of the data stored and updated as data in the storage device 16 include the program matrix 32, the modified program matrix 34, the database matrix 38, the modified database matrix 40, the updated table 44F, and the program change specification 44E. To do. Furthermore, (3) although stored in the storage device 16 as data, there are 20 types of basic tables 50 that function as templates used by the user.

  As shown in an enlarged manner in FIG. 3, the program matrix 32 is data in a matrix (table) format configured by a basic information array 60 and a program array 62. In the basic information array 60, a part of the basic information 52 included in the basic table 50 is listed. The basic information 52 is a data item necessary for the ERP system. In the program array 62, names of various programs 64 (hereinafter referred to as ERP programs) operating in the ERP system are listed. Each cell 66 in the program matrix 32 is marked with a circle when the corresponding basic information 52 (data item) is used for the individual ERP program 64, and when not used. A blank is set. Therefore, the usage relationship between the program 64 and the basic information 52 is preset based on this flag description (circle mark). Further, a correction input array 68 is prepared in the program matrix 32 in parallel with the basic information array 60. In detail, a name correction input array 68A and a branch calculation correction input array 68B are prepared in the correction input array 68, and necessary correction basic information 54 can be inserted into each of them in the future. .

  The correction program matrix generation means 36 writes necessary information in the correction input array 68 in the program matrix 32 as appropriate using the correction basic information 54 acquired by the information acquisition means 30, as shown in FIG. A correction program matrix 34 is generated. Eventually, in this correction program matrix 34, the basic information 52 used in each ERP program 64 must be customized as a list. The correction program matrix 34 is temporarily stored in the storage device 16.

  The automatic program updating means 44 individually develops the ERP programs 64 described in the program array 62 based on the correction program matrix 34, and converts the basic information 54 used by the ERP program 64 into the correction input array 68. Are updated to the basic correction information 54 written in At this time, since the flag (◯ mark) is set in advance in the cell 66 of the correction program matrix 34, only necessary items can be extracted in advance, and an efficient and safe program update process is possible. This is automatically repeated until the update of all the ERP programs 64 described in the program array 62 is completed, details of which will be described later.

  The ERP program includes, for example, a sales program, a purchase program, an inventory management program, an accounting program, a cost calculation program, a process management program, and the like, which are each formed as a program module group of smaller units. Yes.

  FIG. 5 shows the database matrix 38 in an enlarged manner. The database matrix 38 is data in a matrix (table) format configured by an instruction type array 80 and a database array 82. The instruction type array 80 is set with instruction instruction types (areas) necessary for generating a database. For example, a classification table instruction area 80A for setting a classification table, a code for setting codes necessary for classification Instruction area 80B, field addition instruction area 80C for setting additional fields, key item instruction area 80D for setting key items, data description instruction area 80E for specifying data to be imported at the time of database generation, details of all items (symbols) of the database It includes an item table instruction area 80F for indicating an item table name in which setting information is described. Since the number of arrays (instruction quantity) for each instruction type varies depending on the database, the maximum values of all databases are adopted. For example, there are databases that need to set two items in the classification table to databases that need to set tens to hundreds of items in the classification table. I will prepare. In addition, when the number of arrangements is insufficient, the matrix of the database matrix 38 can be automatically expanded as necessary. The item table name set in the item table instruction area 80F means the name of data (file) in which the names and specification data of all items used in the corresponding ERP database are described.

  In the database array 82, names of various databases 84 (hereinafter referred to as ERP databases) operating in the ERP system are set. In each cell 86 in the database matrix 38, specific instruction information for generating the ERP database 84 is described in advance based on the basic information 52 for each classification of the instruction region array 80. For example, only the cell management ID (for example, A, B, C...) Is set for the blank portion that must be set by the user, and specific information is described in this cell 86 in the future. Will be.

  As shown in FIG. 6, the correction database matrix generation unit 42 overwrites the correction basic information 54 acquired by the information acquisition unit 30 while being associated with the basic information 52 of the cell 86 in the database matrix 38. A modified database matrix 40 is generated and stored in the storage device 16. In this example, the data is overwritten for convenience. For example, the inside of the cell 86 is divided into two columns, and the basic information 52 before correction is written in the upper row and the basic information 54 is written in the lower row. It doesn't matter.

  The database automatic generation means 46 automatically generates each ERP database 84 using the modified database matrix 40 stored in the storage device 16. Since all the commands necessary for generation are classified for each area (type) of the instruction type array 80 and described in the cell 86, the commands are used. Further, when the basic correction information 54 is described in the cell 86, the ERP database 84 is generated using the instruction of the basic correction information 54 preferentially over the basic information 52. The ERP database 84 includes various databases necessary for the ERP system, such as an order file, sales file, organization master, process route type master, account item master, accounts receivable file, and accounts payable file. All are automatically generated by repeated processing.

  Next, a basic table that prompts input of various information in the automatic generation apparatus 1 will be described.

  In order to accept a business system according to each company, the present inventor has come up with the idea of using a plurality of basic tables 50 in combination with his earnest efforts. By using the plurality of basic tables 50, the user can quickly set the basic policy of the company. Specifically, basic information that is similar in how it affects ERP programs and ERP databases is compiled into a basic table, and finally 20 types with 7 systems. In this way, the system can be flexibly customized by setting seven fundamental business management policies.

  The following 7 systems are available. (1) System based on products (products / processing / adults) handled by individual companies, (2) System based on individual company organization, (3) System based on individual company's business partners, (4) Individual company (5) System based on individual company unit price usage method, (6) System based on individual company product / material arrangement method, (7) Individual company database Business processing function system. By using these seven types of systems, it becomes possible to automatically generate a management integrated system suitable for each company.

  A plurality of basic tables 50 belong to these seven types of systems, and a total of 20 basic tables are prepared in this embodiment. Therefore, based on this system logic, each company person in charge registers company-specific information in the basic table 50 for each system. This is performed on the input screen of the automatic generation apparatus 1. Specifically, it is determined whether the basic information 52 itself displayed in the basic table matches an appropriate name used by each company, and is changed or added as necessary. In addition, there is information that is newly set in the blank based on the basic information 52. Hereinafter, a reference example will be shown for some of the plurality of basic tables 50.

  FIG. 7 shows a basic table 50 in which components such as parts and materials constituting a product are set in a product system handled by a company. Further, element expansion can be set for the constituent element, and for example, information that expansion to the X level is necessary can be set. For example, even in the same product, there are various systems such as color / size distinction, several finished products such as gifts combined, or products handled only by one item, Even the same components may have different systems. By using this basic table 50, it is possible to generate masters of product components of individual user companies. For example, here, a list of parts table, configuration table, and color size is included in the basic table 50.

  FIG. 8 is a basic table 50 for registering process names and the like. This basic table 50 registers all processes in a state including a management organization from user order reception to delivery. For example, a process code, a process name, a person in charge, the number of persons, a standard stoppage time, a worker, etc. are registered for each process. For each product, a list of which process is passed is registered. For example, even if they are common as products, there are cases where the process through which the materials and the like are prepared and the arrangement conditions are satisfied is different from the other cases. Such products are registered as different types. This makes it possible to specifically manage which process an individual product goes through. FIG. 9 illustrates a case where specific information is input to the basic table 50. Thus, each process name is newly set, and various information is set for each process.

  FIG. 10 is a basic table 50 for setting a system based on a company organization. Usually, the basic table 50 is the largest and is frequently used. Specifically, they are company registration, division of duties, department / organization name registration, and staff / employee registration. Furthermore, the person in charge, the person in charge, and the relationship of the work flow can be registered. This is the basic data for accounting, cost, cash flow calculation, aggregation and classification, as well as all basic data such as process name registration, product path and work name registration, production and process management. FIG. 11 shows an example of specific input.

  FIG. 12 is a basic table 50 for registration of work names. For each process, the work code, work name, work content, work category, worker name, concurrent worker name, standard work quantity per day, etc. are registered. If there is a subcontracted product from the process, this subcontracting process is also registered as a work. In this case, the subcontractor name is also registered. Also, register the operator column, the names of persons who can concurrently serve, and special work. These are the basic materials for schedule progress management, work volume calculation, and difference analysis.

  FIG. 13 is a basic table 50 for registration of production capacity. The basic table 50 is used when an auto-scheduler designed on the ERP system side based on the constraint condition (TOC) theory is attached. This auto-scheduler can analyze the product quantity work quantity, work setup time, worker name, process passing time (including transport time), etc. in the bottleneck process. As a result, planned production is also possible for high-mix low-volume production management. It is also possible to set information for making arrangements manually, so that the progress of all processes can be grasped and displayed. FIG. 14 shows a basic table 50 that can be set for a plurality of processes at the same time, but has the same purpose as FIG.

  FIG. 15 is a basic table 50 for registering business divisions and the like. The division of work is information on who is responsible for which work in the organization, and the department in charge, division of security, deliberation route, responsible person, person in charge, etc. for the division of work is described and registered. . The basic table 50 is in a table format, and changes are made by adding lines. If the security classification is specified, it means that the information can only be viewed by personnel in the department whose security has been released. In addition, the report screen created along the approval path is automatically sent to the approval base. The information registered as the business assignment / work assignment table is disclosed to all employees as shared information in the ERP system.

  FIG. 16 is a basic table 50 for registering affiliated companies. It considers the case where affiliated companies use the integrated management system at the same time. This basic table 50 includes the names, locations and forms of affiliated companies (manufacturing / sales company / construction / real estate / management / warehouse, etc.)・ Register security etc. By registering this affiliated company, all files in the database are created for each company. As a result, a conbox is automatically created and pasted on the input screen.

  FIG. 17 shows a basic table 50 for registering all employee data. Since this information is not disclosed in principle, it can only be viewed by people with a key (password). The employee data is taken into the ERP system and set as an employee master, and is used for department aggregation and department cost classification / aggregation. It is also used for forecast calculation (scheduled profit / loss calculation / scheduled department cost / TOC calculation / scheduled rent / scheduled occupancy rate) in conjunction with department data. Furthermore, it is also used as a material for analyzing the difference in department costs from the aggregate of actual payments. Basic information includes employee code, name, gender classification, department, date of birth, final educational background, labor costs (salary, social insurance, commuting costs, scheduled overtime fees), job description (business code), and status Classification (regular employees, part, etc.), responsibility, etc. This basic table 50 is also used as data for budget department, individual cost calculation, planned man-hours, cash flow calculation, planned profit / loss calculation, difference analysis, and the like.

  The ERP system requires an account item master as an account item. FIG. 18 is a basic table 50 for inputting information for creating the master. Therefore, it is used as the basic information for summing up each subject and generating the account subject ledger. The accounts receivable / accounts payable ledger shall be a receivable / accounting ledger for each company with a customer code / supplier code under the account item. For the account item / account item, approval / change / addition judgment can be set as the basic correction information, and the item itself can be corrected.

  Specifically, the account code, account name, loan classification, loan name, PL / BS classification, PL / BS name, book classification, book name, etc. can be overwritten and entered by the user. Replace with the account you want. You can also write new credit / debit items, current assets / fixed assets. This information is the basis for accounting tables such as trial balance sheets, profit and loss statements, balance sheets and daily balance sheets. These account items are used simultaneously in accounting programs, cost calculation programs, throughput calculation programs, etc. in the ERP system.

  FIG. 19 is a basic table 50 for registering business partners. The information input here is used in the ERP system as a supplier master. Note that items related to money (for example, payment site on the closing date, payment type, credit limit, bill site, etc.) correspond to the financial master, and management items are added to each. The management items and the financial master are a common system for the entire company. For details, supplier code, supplier name, address, department, company, person in charge, telephone number, FAX number, e-mail address, company employee, closing date, payment date, payment site, payment type, bill site Enter the consumption tax category usage limit, customer, delivery destination, billing, construction, ordering, supplier, subcontractor, subcontractor, quotation, etc.

  FIG. 20 is a basic table 50 for registering information related to electronic orders. Recently, the exchange of corporate information through electronic data transmission / reception has become active, and accordingly, the form of electronic ordering / ordering has become widespread. Therefore, a framework for electronic orders including normal orders is registered here. Specifically, electronic data, customer name, electronic order type, etc. are registered. Also, the presence / absence of design data, presence / absence of member data, presence / absence of database unification (orders / members), schedule / delivery staff, responsible person, etc. are also registered. Using the basic table 50 shown in FIG. 21, the person in charge of the individual company corresponding to this electronic order is registered (sales, arrangement, design, product, material, manufacturing, inspection, shipping, etc.).

  FIG. 22 is a basic table 50 for registering information related to sales accounting. There are various types of sales recording, and each type is registered. For example, when the sales calculation formula becomes complicated, it is also possible to describe the calculation contents in a basic table for calculation formula setting described later by describing the calculation formula name. Specifically, the sales item name, its category, calculation formula name, etc., and the unit is unified in a circle. In the present embodiment, numerical items and constants can be used in the basic table 50. The constants are limited to 15 digits or less, and “*” “+” “−” “/” “/” The four arithmetic operations “=” can be used.

  FIG. 23 shows a basic table 50 for setting unit prices. The unit price master is generated based on the information input to the basic table 50. Unit prices can be classified into sales, purchase, and evaluation. Sales and purchase unit prices can be set for each product. Sales unit price can also be set by customer, and purchase can also be set by supplier. It is also possible to set a standard unit price for each product. The unit price for evaluation is divided into products (commodities) and material components, and unit prices based on the evaluation method adopted by the company are set.

  FIG. 24 shows a basic table 50 for setting a material / member management method, and the allocation method is standard. The allocation method includes (1) a method for allocating a developed product after parts development, (2) a method for allocating after color / size master development, (3) a method for allocating using a component master, (4) Since there is a method (single item management) for allocating from the order table, the material management method is registered.

In addition, an allocation method (ordering / planning), an automatic ordering method based on an ordering point order lot, a periodic ordering method, a report (bulk management) ordering method, and a composite method thereof can be employed. In detail, the management item / manager / worker of the material is registered. When a new calculation formula is used for the amount of incoming / outgoing material members using a special calculation method, the calculation formula name is registered.

  FIG. 25 is a basic table 50 for setting information related to simultaneous arrangements. Order management code, distribution material, database completion date, collection material (by related department), related department, person in charge by related department, responsible person (management responsibility) Registered). Although not specifically shown here, the person in charge of arrangement / person in charge, order code, arrangement material / person in charge of next process / person in charge, etc. are registered. Arrangements are generally shortened in terms of delivery time, and simultaneous arrangements are necessary to cope with this. Therefore, in addition to the conventional arrangement method, the simultaneous arrangement determined here is utilized.

  FIG. 26 is a basic table for changing / adding the input screen / form item of each ERP program as necessary. Each item already described can be changed / added in the same manner, but here, each item is divided into a header, a detail, and a footer. In addition, when there is a logical change addition, a change process name is set in this item change column, and the process is performed with reference to a separately set logical format (branch / calculation).

  FIG. 27 is a basic table 50 for setting user authority of the ERP system. Various input screens displayed in the ERP system may be used simultaneously by a large number of persons in charge for one screen. On the other hand, there is a screen in which a person in charge is determined and information cannot be input by anyone other than the person in charge. For example, accounting files and personnel files cannot be input / output by anyone other than the person in charge. Such a relationship between the user and the input file (screen) can be set here, and a person in charge of the input screen, work security for the input screen, search security for the related file, and the like are specified.

  FIG. 28 is a basic table 50 for comprehensively setting whether or not the names of programs, books, and screens used in the management integrated system may remain as they are. If no change is necessary, “approval” is set. On the other hand, if correction is necessary, the content of the change is input. When there are databases / files to be newly used in the ERP system, their data names are newly set. For example, product / material data, customer data, employee personal data, company organization data, account item data, and the like. The amount of data and the contents differ depending on the company. By doing so, the ERP system can be flexibly customized.

  FIG. 29 shows a basic table 50 for setting approval / change / addition of all file item names / table item (symbol) names and box item names used in the ERP system. For example, when there is a change / addition, the changed item name is entered in the change column. When a change is accompanied by a logical method (branch / calculation), the logical process name is set so that the actual processing refers to the basic table for setting the logical expression. Therefore, branching within a program, branching processing across a plurality of programs, and the like can be customized together.

  Here, file item names, table item names, and the like are set in the order of sales management, purchase management, inventory management, process management, accounting, cost calculation (individual / by department), TOC calculation, various masters, and box.

  FIG. 30 is a basic table 50 for setting a calculation formula when a new calculation formula is required in the ERP system for changing / adding item names, branch descriptions, sales accounting, purchase processing, and the like. . If the calculation formula name set here is set in another basic table 50, the calculation formula set here can be applied. In this embodiment, “=”, “+”, “−”, “*”, “/”, “(”, “”), etc. are included as symbols that can be used specifically, and the calculation buffer is W01. ~ W05 are available. Each symbol, item, and buffer can be 1 digit, and up to 15 digits can be set left-justified.

  FIG. 31 shows the basic table 50 for setting the logical contents when the items are changed / added in the various basic tables 50 already described and correction in the logical method is necessary. Specifically, the actual branch condition / selection condition and the like are input together with the logical expression name. When further calculation processing is necessary after branching, the calculation formula name is only described here, and the calculation formula can be set in the calculation formula basic table 50 described later. Thereby, it becomes possible to easily and flexibly customize the individual requirements of each company while utilizing logical expressions. Here, five conditions of “=”, “<”, “>”, “= <”, “=>” are prepared for the branch condition, and the processing item name, conditional expression, etc. to be executed when the conditional expression is not met are the lowest. Set one.

  Next, an example in which each matrix is set based on the basic information and the basic correction information set in the basic table 50 will be described.

  For example, as shown in FIG. 29, a case is considered where “product name” is changed to “product name” as a change item in the basic table 50. In other words, this company desires customization to “product name” as basic information for correction, not “product name” as basic information. Therefore, “product name” is added next to “product name” in the program matrix 32 of FIG. 3, and this correction has an influence on the program marked with ○, that is, the order entry maintenance program / sales input maintenance program. I understand. As a result, the “product name” in both programs is changed to “product name” by the correction program matrix 34 of FIG.

  As shown in FIG. 29, when it is necessary to add “quantity 2” to “quantity”, as shown in the correction program matrix 34 of FIG. The item “2” is added. Regarding “quantity”, since the order / sales input maintenance program is marked with “◯”, “quantity 2” is also added to the order / sales input maintenance program. Further, in FIG. 29, the calculation formula “KEISA01” is specified in relation to the addition of “quantity 2”, and the content is set as “quantity * 12 = quantity 2” in FIG. Refer to the formula. That is, it can be understood that one dozen of “quantity” corresponds to “quantity 2”. Here, since the “order input” maintenance program is specified in the calculation formula, this calculation formula is updated only by the order input maintenance program, and it is not calculated by other sales input maintenance programs. Only the calculation result is used.

  Returning to FIG. 6, for example, the correction database matrix 40 shows a classification table based on the organization name corresponding to the organization master in the classification table instruction area 80A, and also corresponds to the process route master. Thus, a classification table based on the process name is created. For example, in the classification table based on the process name, the process name is extracted from the basic table 50 for process path type registration shown in FIG. That is, on the basic table 50 side, a specific process name described in a place that is initially blank (state in which only an address is assigned: see FIG. 8) is the process path type master of the database matrix 40. Is registered in the cell corresponding to. As a result, a classification table in which items such as etching, chemical conversion, manufacturing management,... Are set is automatically generated. The item attributes set in this classification table are a part code and a process code.

  For the account item master, a classification table is created based on the PL / BS name. In the account table registration basic table 50 shown in FIG. 18, the account items are current assets, fixed assets, carry-over assets, etc. In this case, no correction occurs here. Since the contents of fixed assets and current assets differ depending on the company, the account item master is generated by taking in the data in the basic table 50. These classification tables are passed to the ERP system as classification tables for each database and used in each program. Similarly, key items and the like are sent to the ERP system and used in each program.

  A classification table corresponding to the order file / sales file is not created. The code item means the arrangement order of the data. The order / sales file is arranged in the order of the customer code. In the organization master / process route master, the data is arranged in the order of the organization code, department code, and process code. In the account item master, data is arranged in the order of lending category, PL / BS category, PL / BS name, and account item name.

  Regarding field addition, there is an addition to the order / sales file, and a new field (symbol) is created based on this. Key items are set in the database, and data is usually specified according to this setting.

  Next, an operation flow in the automatic generation apparatus 1 will be described.

  It should be noted that it is reasonable to execute these operation flows by dividing them into the following seven functional blocks. This block is (1) need to change physical items (display item change), (2) need to change / automatically generate SQL statement to access database in ERP program, (3) item / branch・ Necessity of calculation formula change, (4) Necessity of adding items, (5) Necessity of change of branch and calculation formula and their combination (combination), (6) Setting of database table and system basic information, ( 7) Database field addition, item name change, key (classification) item setting necessity. Details will be described below.

  FIG. 32 shows a matrix generation procedure. First, the basic table 50 is used to input various basic information 52 and corrected basic information 54 (S200), and these information are stored in the hard disk (S202). The basic information 52 and the corrected basic information 54 are classified from a different viewpoint, and are incorporated in advance in the ERP system such as the number of employees and the employee list, as well as change / addition information for symbols (items) pre-installed in the ERP system. It can be classified into individual company information that cannot be stored.

  After the input is completed, the basic table check unit 36A checks whether the information input to the basic table 50 is not missing essential information, is consistent, or has a logical contradiction (S204). If there are omissions or inconsistencies, the verification list is automatically written (S206). As a result of the verification, only when the individual company information and the change / addition information for the ERP system are correct, the information is written in the program matrix 32 and stored in the hard disk as the correction program matrix 34 (S208). The correction program matrix generation unit 36 generates the correction program matrix 34 along with the correspondence information between the basic table 50 and the program matrix 32 that is held in advance.

  Next, various information is written in the database matrix 38 based on the already stored basic table 50 (S210). The correction database matrix generation unit 42 holds correspondence information between the basic table 50 and the database matrix 38 in advance, and generates the correction database matrix 40 by performing writing according to the correspondence. The correction program matrix 34 and the correction database matrix 40 can be comprehensively verified by extracting a list from the screen or printer after completion (S212).

  Thereafter, using the correction program matrix 34 and the correction database matrix 40, the program automatic update means 44 and the database automatic generation means 46 create individual update information, and sequentially update and generate individual programs and databases. (S214).

  After completion of the update and generation, the object code is finally converted into an object code executable by the computer (S216). Specifically, each program and database updated / generated including the logical formula (calculation formula / branch logic) set in the basic table 50 can be converted into an execution format, sent to the ERP system, and set. Transition to the state.

  Next, the program update process will be described in detail.

  FIG. 33 is a routine for extracting the update data written in the correction program matrix 34 for each program. The program-specific change data extraction unit 44A in the program automatic update unit 44 first develops the correction program matrix from the hard disk to the memory (S300). Thereafter, the program names are sequentially extracted according to the program array 62 (S302). At this time, if the program 64 cannot be retrieved, that is, if the final term of the program array 62 has been reached, it is determined that all the programs 64 have been updated, and the process is terminated (S304).

  On the other hand, when the program name can be extracted, the basic information array 60 of the correction program matrix 34 in the program is referred to, and items therein are sequentially extracted from the top (S306). At this time, it is determined whether or not the item has been extracted (S308). If it is determined that the item has not been extracted and the final item of the basic information array 60 has been reached, the update process for this program 64 has been completed, and the process returns to S302. Returning, the update of the next program 64 is started.

  If the item can be extracted, the process proceeds to S310, and it is determined from the mark in the cell 66 whether each item is used in the program 64 being extracted. If there is no mark, the item is irrelevant, so return to S306 and refer to the next item. If the cell 66 is marked with a circle, the update table generation unit 44B refers to the correction input array 68 to determine whether or not the item has been changed (S312). If the item has been changed, the update is performed. The change information is described in the table 44F (S314). If the description of the change information is completed in S314, or if the change information does not exist in S312, it is next determined whether there is an additional setting for the item (S316). Additional information is described (S318), and further, depending on the additional information, it is determined whether or not an update of the SQL statement for controlling the database 84 is necessary (S320). The SQL statement to be changed is described in the SQL update table in the program 64 (S322).

  After the processing of S318 to S322 is completed, or when there is no additional setting in S316, it is next determined whether or not there is a logical branch setting request (S324), and if there is a setting request, The branch change setting of the program 64 is described in the update table 44F (S326). After the description is completed, or when there is no logical branch setting request in S324, it is next determined whether or not there is a request to change or add a calculation formula (S328). Completes the process by describing the calculation formula of the program 64 in the update table 44F (S330), returns to S306, and proceeds to the process of the next item. As a result, the update table 44F and the SQL update table in which all update information is efficiently and comprehensively integrated are completed. The update table and the SQL update table may be separate, but may be combined into one file.

  FIG. 34 shows a flow of finally generating a computer-executable ERP program using the update table 44F and the SQL update table generated along FIG. When the generation routine by the update table generation unit 44B shown in FIG. 33 is completed, the program described here automatically moves and continues until the processing is automatically completed without human intervention. .

  In the update table 44F, program names and their update contents are listed, and these are sequentially extracted (S400). If there is no information to be extracted, it is determined that the update process for all the programs 64 has been completed, and the process ends (S402). After fetching the update contents, an update specification corresponding to the update of the program 64 is taken out from the program update specification 44E prepared in advance (S404), and the object is updated according to the update contents. Start the program generation process.

  Specifically, first, it is determined whether or not a calculation formula is changed or added in the update contents (S406). If there is an update or addition, a partial calculation program routine for realizing the calculation formula is created. Is described in the program file (S408). In conjunction with the description of the calculation program routine, if a change occurs in the area or area name of the database 84 used by the program 64, the change is also described in the corresponding database 84. As a result, it is possible to maintain the consistency by simultaneously modifying the database generated in association with the program update.

  Next, it is determined whether or not the branch process is changed / added (S410). If there is a change, a partial branch program routine for realizing the branch process is created and described in the program file (S412). ). At that time, in conjunction with the description of the branch program routine, if there is a change in the area or area name of the database 84 used by the program 64, the change is also described in the database 84. .

  Next, it is determined whether or not an SQL statement needs to be updated (S414). If there is an update, an SQL statement is created and described in the program file (S416). At that time, in conjunction with the update of the SQL sentence, if the area (field) or area name of the database 84 used by the SQL sentence changes, the change is also described in the database 84. .

  Finally, it is determined whether or not a new item is added / changed (S418). If there is, an addition / change routine for setting the item addition / change is created and described in the program file (S420). In conjunction with the description of the addition / change routine, if a change occurs in the area or area name of the database 84 used by the program 64, the change is also described in the database 84. As a result, the actual object program of each ERP program 64 is generated and the basic setting of the related database 84 is completed.

  In this embodiment, the basic setting of the database 84 (for example, addition of a field area, etc.) that must be linked with the specific update of each program 64 is performed simultaneously with this program update. The basic setting of the database 84 may be performed in conjunction with the correction of the program matrix 32 at the previous stage, for example, at the stage of writing the correction basic information 54 in the program matrix 34. The basic setting is, for example, information related to update / addition of field / item names. In addition, a correction item that works in conjunction with program update may be written and stored on the hard disk as database correction information without setting it directly in the database 84. These pieces of information may be added to the database matrix 38.

  In this way, by adopting an automatic update program using the program matrix 34, all ERP programs can be automatically updated with one update program.

  FIG. 35 shows a flow for generating the database 84.

  First, the modified database matrix 40 is expanded in the memory, and database names to be generated are sequentially extracted by referring to the database array 82 (S500). If it cannot be extracted, it is determined that the generation process of all the databases 84 has been completed, and the process is completed (S502). Next, based on the extracted database name, the classification table, code item, additional field, key item setting, data description, etc. set in each cell 86 of the modified database matrix 40 are extracted (S504).

  Next, the individual company information described in the basic table 50 is expanded in the memory (S506), and it is then determined whether or not a new classification table needs to be created in relation to the database 84 (S508). If it is necessary to create a classification table, the classification table is created (S510), and the classification code is set (S512). For the creation of this classification table, individual company information is usually used.

  After the creation of the classification table is completed, or when the creation of the classification table is unnecessary, the process proceeds to S514, where it is determined whether or not a field is added for each database 84. Generation is performed (S516). Next, it is determined whether or not a key item needs to be set (S518), and if necessary, an item name to be a key item is set (S520). Next, it is determined whether or not there is a description of the data to be referred to (S522). If there is data, the consistency between the data and the ERP system is confirmed, and the content of the data is stored in this database. Capture (S524). This makes it possible to import data already created by the company into the database 84. As a result, the generation of the database 84 is completed. Therefore, the process returns to S500 and the generation of the next new database 84 is started.

  According to the present embodiment, by using the basic table 50, it is possible to allow the user to input information efficiently. The information is organized and stored in the program matrix 34 and the database matrix 38 to enable a rational update operation for a complex ERP system. In the modified program matrix 34 and the modified database matrix 38, the update information is classified for each purpose. Therefore, a common update / generation routine can be used in all program update operations and all database generation operations. The automatic generation apparatus 1 can be made a simple configuration. Furthermore, by using such a matrix form, it is possible to check the customization contents in a list, so it is easy to deal with troubles that occur during automatic updating, and the development cost of the ERP system can be greatly reduced. Yes.

  The automatic generation apparatus 1 of the present invention is not limited to the above-described embodiment, and it is needless to say that various changes can be made without departing from the gist of the present invention.

  According to the present invention, it is possible to automatically customize the ERP system along individual users.

The block diagram which showed the apparatus structure of the automatic production | generation apparatus which concerns on embodiment of this invention. Block diagram showing the functional configuration of the automatic generation device The figure which shows the program matrix which is used with the same automatic generation device The figure which shows the correction program matrix which is used with the same automatic generation device The figure which shows the database matrix which is used with the same automatic generation device The figure which shows the correction database matrix which is used with the same automatic generation device Diagram showing a basic table in which components such as parts and materials that make up a product are set The figure which shows the basic table which registers the process name etc. The figure which shows the specific example of the basic table which registers process name etc. Diagram showing basic table for setting system based on company organization Diagram showing a specific example of a basic table that sets a system based on the company organization Figure showing the basic table for registering work names Diagram showing basic table for registration of production capacity The figure which shows the other example of the basic table about registration of production capacity Diagram showing the basic table for registering business divisions, etc. Diagram showing basic table for registering affiliated companies Diagram showing the basic table for registering all employee data Figure showing a basic table for entering information to create an employee master Diagram showing the basic table for registering business partners The figure which shows the basic table for registering the information regarding the electronic order The figure which shows the basic table which registers the person in charge of the individual company which corresponds to the electronic order Diagram showing the basic table for registering information related to sales accounting The figure which shows the basic table which sets the unit price Diagram showing basic table for setting the management method for materials and parts The figure which shows the basic table which sets the information regarding simultaneous arrangement The figure which shows the basic table for making change / addition regarding the input screen / form item of each ERP program The figure which shows the basic table which sets the user authority of an ERP system The figure which shows the basic table which sets the program, the book table and the screen name of the ERP system comprehensively The figure which shows the basic table for setting all the file item names etc. which are used with the ERP system The figure which shows the basic table for setting the calculation formula in the ERP system The figure which shows the basic table for setting a logical content in an ERP system Flow chart showing matrix generation procedure A flowchart showing a routine for extracting update data of a correction program matrix A flowchart showing a procedure for finally generating an ERP program using an update table or the like Flow chart showing the procedure for creating a database

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Automatic generator 30 Information taking means 32 Program matrix 34 Correction program matrix 36 Correction program matrix generation means
38 Database matrix 40 Modified database matrix 42 Modified database matrix generation means
44 Program automatic update means 46 Database automatic generation means

Claims (5)

An automatic generation device for a business integrated management system that performs integrated management of a plurality of programs,
A basic table including basic information is presented, and the correction basic information is captured by writing correction basic information including an instruction to change the basic information and an instruction to add the basic information to the basic table. Information capture means;
Tabular data formed by a basic information array made up of a plurality of basic information and a program array made up of the plurality of programs and stored in a storage means, each program being set in the program array A program matrix in which whether or not to use the basic information of the basic information array is flagged,
A correction program matrix generation means for writing the correction basic information acquired by the information acquisition means in association with the basic information array of the program matrix, and storing the correction basic information as a correction program matrix;
When customizing the business integration management system, the plurality of programs described in the program array are sequentially expanded based on the correction program matrix, and the flag description of the correction program matrix corresponding to the expanded program Automatic program updating means for customizing and updating the program collectively using the basic information and the corrected basic information;
Tabular data formed by an instruction type array and a database array, each cell having the basic information necessary for generating each database set in the database array, the instruction type array A database matrix described for each instruction type set in
A modified database matrix generating unit that writes the modified basic information captured by the information capturing unit in association with the basic information described in the cell in the database matrix, and stores the modified basic information as a modified database matrix;
When customizing the business integration management system, the databases set in the database array are sequentially collected based on the correction database matrix using the basic information and the correction basic information for each instruction type. Automatic database generation means for generating;
With
Based on an instruction to add basic information included in the basic correction information, either the correction program matrix generation unit or the program automatic update unit is linked to the program to be updated in a database used by the program. A business integrated management system automatic generation apparatus characterized by setting an additional field.   2. The business integrated management system automatic generation device according to claim 1, further comprising a system management interface providing unit capable of outputting the correction program matrix to a display device.   3. The business integrated management system automatic generation apparatus according to claim 1, wherein the information fetching unit includes a plurality of the basic tables for each predetermined purpose.   The business integrated management system according to any one of claims 1 to 3, wherein the program includes any one of a sales program, a purchase program, an inventory management program, an accounting program, a cost calculation program, and a process management program. Automatic generator.   In the instruction type array of the database matrix, a name instruction area for setting a classification name, a code instruction area for setting a code necessary for classification, a field addition instruction area for setting a field to be added, and a key for setting a key item 5. The business integrated management system automatic generation apparatus according to claim 1, further comprising: an item instruction area.

Images