JP3598026B2 - Production management system and production management program storage medium - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention relates to a production management system that manages production of various products.
[0002]
[Prior art]
2. Description of the Related Art Conventionally, in various factories that produce various products, production management systems that manage a large number of various material requirements and product production plans have been adopted. The material requirement plan development process (MRP: Material Requirements Planning) in this production management system is generally roughly divided into two methods. One is the “MRP method” in which the production plan is managed on a quantity basis in a time bucket format and the requirements for the component parts are expanded. The production plan is managed in detail data with "" as a unit, and is broadly classified into "manufacturing number system" in which the requirements of the component parts are expanded with the production number as a unit. Furthermore, in recent years, the “manufacturing number MRP method” based on the “manufacturing number method”, taking advantage of these two methods, is becoming widespread.
[0003]
Here, since the conventional production management system has immature information processing technology (IT), the material requirement plan development process (MRP) requires a large amount of computer resources and processing time. It is realized as a regular batch process. This is because priority is given to saving of computer resources and avoiding duplication of data, and the bill of materials constituting the product is developed each time the MRP process is performed. In addition, since the programming language used when developing a system is mainly a third generation language and it has been difficult to realize real-time processing, it is realized as easy batch processing of a large amount of data.
[0004]
As a result, even though it is possible to collect data that occurs from time to time, such as parts in and out of daily production activities and the progress of the manufacturing process, in real time, in order to reflect the collected data in MRP, In addition, batch processing once a week is necessary, and there is a gap between the actual product and data.
[0005]
Realization of production management in real time is realized by using complicated processing logic such as dedicated file system and memory access, although it is realized in partial simulation systems, etc., and it is complicated and extremely expensive. However, it is not incorporated into the core production management system.
[0006]
[Problems to be solved by the invention]
Therefore, due to changes in the market environment and diversification of customer needs, there has been a drawback of waiting for a long time in order to reflect a change in production plan or a change in design specifications that occurs every moment. In addition, since the distribution information that occurs every moment is reflected on the next day, wasteful work such as actually going to the site and checking it has occurred.
[0007]
In view of the above circumstances, the present invention realizes real-time processing with an open system with simple logic at a low cost, thereby changing a production plan, a design specification, and further reflecting physical distribution information in real time. Another object of the present invention is to provide a production management program storage medium in which a production management program for realizing such production management is stored.
[0008]
[Means for Solving the Problems]
The production management system of the present invention that achieves the above object is as follows.
In a production management system for managing the production of products, original configuration information consisting of part information representing information of a single part number, parts table information representing a parent-child relationship of the part number, and application information representing a change of the part number to be applied to the product, A database having development configuration information, which is updated based on the original configuration information and in which the requirements of each product number for each command product number are expanded;
Original configuration information updating means for updating the original configuration information according to an operation;
And a deployment configuration updating means for updating the deployment configuration information based on the updated original configuration information.
[0009]
The production management system of the present invention eliminates the time required for the parts table development process in the MRP process by having the above-described development configuration information, and automatically and instantaneously reflects the change in the plan information in the required information of the component parts. be able to.
[0010]
Here, in the production management system of the present invention, the database further includes component part number information indicating whether or not the development configuration information needs to be updated for each parent part number,
It is started when the original configuration information is updated, and comprises a component part number update means for updating the component part number information based on the updated original configuration information.
The expanded configuration update means preferably updates the expanded configuration information with reference to the component product number information and reflects the update result in the component product number information.
[0011]
By having the component part number information, which is intermediate information for propagating changes in the original configuration information, which is the source of the expanded configuration information, to the expanded configuration processing means, the changes in the original configuration information are easily reflected in the expanded configuration information Can be made.
[0012]
Also, in this case, the component part number updating means is activated in response to the update of any part number information in the original configuration information, searches for the parent part number affected by the update, and updates that in the component part number information. It is preferable that the information of the parent product number affected by the item is updated.
[0013]
In this case, when a change occurs in the original configuration information, products affected by the change are automatically and instantaneously searched, and products that need to be reflected in the development configuration information are automatically and immediately recorded.
[0014]
Furthermore, it is preferable that the original configuration information update unit displays the component part number information and activates the expanded configuration update unit according to the operation.
[0015]
By displaying the component part number information, it is possible to visualize the range of influence when the original configuration information is changed, and the user must immediately obtain information on deficiencies in the original configuration information (expansion error to the expanded configuration information). Can do. In addition, by providing an activation unit that activates the expanded configuration update unit according to an operation, for example, after the deficiency in the original configuration information is resolved, the expanded configuration update unit is immediately activated as necessary, and the original configuration information is updated. Changes in configuration information can be quickly reflected in the deployment configuration information.
[0016]
Furthermore, in the production management system of the present invention, the database further includes plan information representing a production plan for each command part number, and part requirement information representing a requirement for each part number,
Plan information update means for updating the plan information according to the operation;
It is preferable that the apparatus includes a component required expansion unit that starts upon receiving update of the plan information and expands the plan information into the component required information while referring to the expansion configuration information.
[0017]
Since the present invention has a configuration in which the development configuration information is always maintained as described above, the plan information can be immediately developed into the component requirement information.
[0018]
In addition, when the expanded configuration update means is updated normally as a result of updating the expanded configuration information, the expanded configuration information refers to the plan information and reflects the updated contents in the expanded configuration information in the component requirement information. Is preferred.
[0019]
In this way, when the cause of the development error is resolved, only the portion where the development error has occurred can be quickly reflected in the component requirement information.
[0020]
Further, in the production management system of the present invention, the database further includes parts inventory information representing inventory status for each product number, parts inventory information representing the inventory status for each product number, and provision details for each product number. With provision details information representing
A parts inventory remaining information updating means for updating the parts inventory information and the parts remaining information according to the operation;
It is preferable to include provision detail updating means for updating the provision detail information based on the original provision information including part requirement information, parts inventory information, and part order information.
[0021]
In the production management system of the present invention, as described above, the deployment configuration information is always maintained, and when the plan information is changed, the parts requirement information is always updated to the latest one. It is possible to immediately reflect the change of the original allocation information including the allocation details information.
[0022]
In this case, the database further includes provision item number information indicating a cause of updating the provision item information,
The provisional item number updating means is activated in response to the update of the original allocation information, and updates the allocation item number information based on the updated original allocation information.
It is preferable that the allocation detail update means updates the allocation detail information with reference to the allocation item number information and reflects the update result in the allocation item number information.
[0023]
In the production management system, as described above, the allocation details information is created by allocating the remaining inventory (part inventory, part inventory) for the required plan for each part and clarifying the shortage and surplus of parts. When there is a change in the original provision information by having provision part number information that is intermediate information for propagating a change in the original provision information that is the source of this provision detail information to the provision information updating means It is possible to update the provision details information efficiently and immediately.
[0024]
The production management system of the present invention may be realized by a single device (for example, one computer) or may be realized by a plurality of distributed devices (for example, a server / client system). The production management system of the present invention can be constructed from a large general-purpose computer to a small personal computer in an environment where the database system operates.
[0025]
In addition, the production management program stored in the production management program storage medium of the present invention that achieves the above object operates by incorporating the computer or the distributed computer system as a production management system. Program
Original configuration information updating means for updating original configuration information consisting of component information representing information of a single product number, parts table information representing a parent-child relationship of product numbers, and application information representing a change in product number to be applied to a product according to an operation When,
And a deployment configuration updating means for updating the deployment configuration information obtained by deploying the requirements of each product number for each command product number based on the updated original configuration information.
[0026]
Here, the production management program is further activated in response to the update of the original configuration information, and indicates whether the development configuration information needs to be updated for each parent product number based on the updated original configuration information. A component part number updating means for updating the component part number information is provided,
The expanded configuration update means preferably updates the expanded configuration information with reference to the component product number information and reflects the update result in the component product number information.
[0027]
In this case, the component part number updating means is activated upon receiving the update of any part number information in the original configuration information, searches for the parent part number affected by the update, and updates the component part number information in the information. It is preferable that the information of the parent product number affected by the is updated.
[0028]
The production management program further includes plan information updating means for updating the plan information representing the production plan of each command part number according to the operation,
It is preferable that the apparatus is provided with parts required expansion means for starting up upon receiving update of the plan information and expanding the plan information into part required information representing the requirements of each product number while referring to the expansion configuration information.
[0029]
In this case, when the expanded configuration information is updated normally as a result of updating the expanded configuration information, the expanded configuration update means refers to the plan information and reflects the updated contents in the expanded configuration information in the component requirement information. Preferably there is.
[0030]
Further, the production management program further includes parts inventory information that indicates inventory status for each part number and parts inventory information that indicates inventory status for each part number according to the operation, ,
Provided with provision details updating means for renewing provision details information representing provision details for each product number based on original provision information consisting of parts requirement information, parts inventory information, and parts stock information Is preferred,
The production management program is further activated in response to the update of the original allocation information, and the allocation item number updating means for updating the allocation item number information representing the cause of the update of the allocation details information based on the updated original allocation information With
It is preferable that the allocation detail update means updates the allocation detail information with reference to the allocation item number information and reflects the update result in the allocation item number information.
[0031]
DETAILED DESCRIPTION OF THE INVENTION
Hereinafter, embodiments of the present invention will be described.
[0032]
FIG. 1 is a diagram showing a computer network in which an embodiment of the production management system of the present invention is deployed.
[0033]
In FIG. 1, two client machines 100 and 200 and one server machine 300 are illustrated as computer systems constituting a computer network. These computer systems 100, 200, and 300 are connected via a communication network 400. Are connected to each other.
[0034]
Each computer system 100, 200, 300 has a main unit 101, 201, 301 containing a CPU, main storage device, hard disk, communication board, etc., and display screens 102 a, 202 a according to instructions from the main unit 101, 201, 301. , 302a, display units 102, 202, 302 for displaying images and character strings, keyboards 103, 203, 303 for inputting user instructions to the computer systems 100, 200, 300, and display screens 102a, 202a, 302a The mouse 104, 204, 304 is provided for inputting an instruction corresponding to the icon or the like displayed at that position by designating an arbitrary position.
[0035]
Further, the main body portions 101, 201, and 301 of the computer systems 100, 200, and 300 have an FD loading port 101a into which a floppy disk and a CD ROM (not shown in FIG. 1; see FIG. 2) are further loaded. , 201a, 301a, CDROM loading ports 101b, 201b, 301b, in which floppy disks and CDROMs loaded from the loading ports 101a, 101b; 201a, 201b; 301a, 301b are driven. A floppy disk driver and a CDROM driver are also built in.
[0036]
The server machine 100 functions as a host computer for the client machines 200 and 300, and a database is built therein. The client machines 200 and 300 access the server machine 100.
[0037]
Here, the production management program according to the present invention is stored in the CDROM loaded in the server machine 100, and this CDROM is loaded into the main body 101 from the CDROM loading slot 101b and stored in the CDROM by the CDROM driver. A production management program is installed in the hard disk of the server machine 100. Of the production management programs installed in the server machine 300, programs necessary for the client machines 100 and 200 to access the server machine 300 are distributed from the server machine 300 to the client machines 100 and 200.
[0038]
The CD ROM storing the production management program corresponds to an embodiment of the production management program storage medium of the present invention.
[0039]
The production management program stored in the CDROM is installed in the hard disk of the server machine 100 as described above. The hard disk in which the production management program is installed is also stored in the production management program of the present invention. This corresponds to one form of the medium.
[0040]
Further, when the production management program is downloaded to a floppy disk or the like, the floppy disk or the like that stores the downloaded production management program also corresponds to an embodiment of the production management program storage medium of the present invention. .
[0041]
Hereinafter, the hardware configuration of the computer systems 100, 200, and 300 will be described. The computer system 100 will be described as a representative of the computer systems 100, 200, and 300.
[0042]
FIG. 2 is a hardware configuration diagram of the computer system shown in FIG.
[0043]
Here, a central processing unit (CPU) 111, a RAM 112, a hard disk controller 113, a floppy disk driver 114, a CDROM driver 115, a mouse controller 116, a keyboard controller 117, a display controller 118, and a communication board 119 are provided. , They are connected to each other by a bus 110.
[0044]
As described with reference to FIG. 1, the floppy disk driver 114 and the CDROM driver 115 are loaded with the floppy disk 510 and the CDROM 520, and access the loaded floppy disk 510 and CDROM 520.
[0045]
Further, here, the hard disk 120 accessed by the hard disk controller 113, the mouse 104 controlled by the mouse controller 116, the keyboard 103 controlled by the keyboard controller 117, the display unit 102 controlled by the display controller 118, and for communication A communication network 400 connected via a board is also shown.
[0046]
As described above, the production management program is stored in the CDROM 520, and the production management program is read from the CDROM 520 by the CDROM driver 115 and stored in the hard disk 120 by the hard disk controller 113 via the bus 110. In actual execution, the production management program in the hard disk 120 is loaded onto the RAM 112 and executed by the CPU 111.
[0047]
FIG. 3 is a schematic diagram showing each means constituting the production management program stored in the CD ROM 520.
[0048]
The CDROM 520 stores a production management program 700. The production management program 700, as will be described in detail later, is an original configuration information updating unit 701 for updating the original configuration, and a component part number updating unit for updating the component part number information. 702, an expansion configuration updating unit 703 for updating the expansion configuration information, a plan information updating unit 704 for updating the plan information, a component required expansion unit 705 for expanding the plan information into the component requirement information, and updating the component inventory information and the part remaining information. Parts inventory remnant information updating means 706, provision item number information updating means 707 for updating provision item number information, and provision details updating means 708 for updating provision details information. Here, the names are used without distinction, but each means 701 to 708 constituting the production management program 700 means means as software, and this production management program 700 is loaded into the computer system shown in FIG. Each means when operating is referred to as means including both software and hardware as an environment for operating the software.
[0049]
The production management program 700 stored in the CDROM 580 shown in FIG. 3 is uploaded to the host machine 100 as described above, and then a program necessary for accessing the host machine 100 is distributed to each client machine 200, 300. However, the programs distributed to the clients 200 and 300 include operations of the original configuration information updating unit 701, the plan information updating unit 704, and the parts inventory remaining information updating unit 706 on the client machines 200 and 300. Is transmitted to the host machine 100.
[0050]
FIG. 4 is a schematic diagram showing the entire production management system constructed in the computer system shown in FIGS. FIG. 5 is a conceptual diagram of data handled by this production management system.
[0051]
FIG. 5 shows a part system relating to each product represented by command product numbers X, Y, Z. In this figure, for example, the product of the command part number X is composed of one part represented by part number A, five parts represented by part number B, and five modules represented by part number C. Each of the modules shown is composed of one part, five parts, and three parts represented by product numbers a, b, and c, respectively. Here, a relatively higher product number in the hierarchy is called a parent product number, and a lower product number of the parent product number is called a child product number. For example, the product number A is a child product number of the parent product number X, and the child product numbers a, b, and c correspond to the parent product number C.
[0052]
A database is constructed in the server machine 100. The database includes parts information 601, parts table information 602, application information 603, component part number information 604, expanded configuration information 605, plan information 606, parts shown in FIG. Required information 607, parts inventory information 608, parts remaining information 609, allocation item number information 610, and allocation details information 611 are stored.
[0053]
Here, the parts information 601, the parts table information 602, and the application information 603 (herein, these are collectively referred to as “original configuration information”) are operated by an operator from each client machine (here, the client machine 200). It is updated by the original configuration information updating means 700 (see FIG. 2) that operates according to the above.
[0054]
6, 7, and 8 are diagrams illustrating examples of the part information 601, the parts table information 602, and the application information 603, respectively.
[0055]
The part information shown in FIG. 6 represents information of each part number. Here, the part number, the part name, and the lead time (hand number; the number of days required to obtain the part or product represented by the part number). ) Etc. are shown in association with each other.
[0056]
The parts table information shown in FIG. 7 represents a parent-child relationship of product numbers, and is shown in association with a parent product number, a child product number, a basic unit (the number of child product numbers required for the configuration of the parent product number), and the like. Yes.
[0057]
The application information shown in FIG. 8 represents the change of the product number to be applied to the product. As an example, the assembly information of 1999/06/01 to 1999/09/30 is used for assembling the parent product number X. In the meantime, it is shown that the application product number E is used instead of the child product number A, and that when the parent product number Y is assembled, the application product number F is used without using the child product number B after 1999/07/01. .
[0058]
Returning to FIG. 4, the description will be continued.
[0059]
The original configuration information, that is, the parts information 601, the parts table information 602, and the application information 603 are updated by the operator who operates the client machine 200 as described above.
[0060]
3 is a “stored procedure” stored in the database. When any one of the part information 601, the parts table information 602, and the application information 603 is changed, the change is made. Is started as a “database trigger”, and the component part number update process 702a shown in FIG. 4 is executed. This component part number update process 702a is a process of updating the component part number information 604 based on the original configuration information, that is, the part information 601, the parts table information 602, and the application information 603, and includes a part number in the original configuration information. When the information is updated, the parent product number affected by the update is detected, and the information of the parent product number affected by the update in the component product number information is updated.
[0061]
FIG. 9 is a diagram illustrating an example of component part number information.
[0062]
This component product number information indicates whether or not development configuration information to be described later needs to be updated for each parent product number. Here, for the parent product number X, the parent product number X itself or the parent product number exists on the date 1. This indicates that there was some change in the child part number that affects X, and that the expansion to the later-described expansion configuration information performed on date 2 was successful. This indicates that a change has occurred in the parts table at the date and time 4, but after the change at the date and time 4, the expanded configuration information has not been expanded, and the change in the BOM has not been reflected in the expanded configuration information. ing. Regarding the parent product number Z, this indicates that there was a change in the date and time 5 and the change was attempted to be reflected in the deployment configuration information at the subsequent date and time 6, but the information related to the product number E was missing and could not be deployed successfully. ing.
[0063]
The expanded configuration update process 703a shown in FIG. 4 is a process executed by the expanded configuration update unit 703 shown in FIG. 3. In the expanded configuration update process 703a, the component part number information 604 is referred to, and the original configuration information (parts The expanded configuration information 605 is updated based on the information 601, the parts table information 602, and the application information 603). The update result is reflected in the component part number information 604. FIG. 10 is a diagram illustrating an example of the deployment configuration information. In this development configuration information, the requirements (required number (cumulative basic unit), required time (cumulative lead time), etc. of each product number for each command product number are developed.
[0064]
The component product number information 604 is displayed on the display screen 202a of the client machine 200 by the above-described original configuration information updating unit 701, and the operator can confirm whether or not the expansion to the expanded configuration information is successful. Further, for example, in response to the message “No Product Number Ho” shown in the column of the parent product number Z in the component product number information in FIG. 9, information related to the product number E is input, and then the operator instructs execution of the expanded configuration update process 703a. When the operation is performed, the original configuration information update unit 701 activates the expanded configuration update unit 703, and the expanded configuration update process 703a is executed.
[0065]
As described above, the component part number information 604 is used to manage the status of the expanded configuration information, and when the change occurs in any of the part information 601, the parts table information 602, and the application information 603, the change contents are displayed in the message column. Record and change the status to "Undeployed (deployment required)". The expanded configuration update processing 705a can be started by notifying this information on an inquiry screen or the like and further instructing from the screen.
[0066]
In addition, in the expanded configuration update processing 703a, when a data defect (no component information, component table loop, etc.) occurs, the status is changed to “development NG (development required)” and the error content is displayed in the message field. It is possible to check the contents from the expanded screen by recording in
[0067]
11 and 12 are diagrams showing examples of the plan information 606 and the part requirement information 607 shown in FIG. 4, respectively.
[0068]
The plan information shown in FIG. 11 represents a production plan for each command product number, and here, the quantity and delivery date are shown for each product number of each command product number.
[0069]
This plan information is updated by the plan information update means 704 (see FIG. 3) in accordance with the operation of the operator of the client machine 200.
[0070]
Further, the part requirement information shown in FIG. 12 indicates the requirement (required number, required date, etc.) of each part number, and the plan information 606 is converted into the part requirement information by the part requirement development processing 705a by the part requirement development means 705. Expanded to 607.
[0071]
The component required expansion means 705 for executing the required component expansion processing 705a is stored in the database as a stored pronger similarly to the above-described expansion configuration update means 703, and is activated with a change in the plan information 606 as a database trigger. Therefore, if there is a change in the plan, the plan change is reflected in the component requirement information 607 in real time.
[0072]
In this way, in the expansion process from the plan information 606 to the part requirement information 607, the parts table is expanded only in advance with the development information 605 and the plan information 606 that have been expanded in advance without expanding the multi-stage parts table each time. The required information 608 is updated instantaneously.
[0073]
Here, when the above-described expanded configuration update processing 703a is executed, the expanded configuration information is updated as described above. When the expanded configuration information is updated normally, the expanded configuration update processing 703a With reference to the plan information 606, the updated content in the expanded configuration information 605 is reflected in the part requirement information 607. By doing so, for example, in the column of the parent product number Z in FIG. 9, “No product number ho” is displayed. For this reason, when the development configuration information is not normally updated, the operator inputs information on the product number E to develop the configuration. When the update process 703 is executed, the part requirement information 607 is quickly updated to normal information without waiting for the part requirement development process 705 to be executed in response to the change of the plan information 606. The
[0074]
In this way, in the expanded configuration update process 703 a for updating the expanded configuration information 605, the result is normally completed, and the status of the component product number information 604 is changed to “expanded OK” from the plan information 606. The indeterminate detail information is retrieved instantly, and the component requirement information 607 is recreated. In addition, in the change information to the component part number information 604, when a change to the part information of the component to be configured is recorded, the target part number is not expanded without reducing the entire configuration in order to shorten the processing time. Only the expanded configuration information 605 and the component requirement information 607 reflect the changed contents.
[0075]
Further, the component requirement information 607 can be referred to by the client machine 200 and can be changed directly from the client machine 200.
[0076]
FIGS. 13 and 14 are diagrams showing examples of the parts inventory information 608 and the part order information 609 shown in FIG. 4, respectively.
[0077]
The part inventory information in FIG. 13 represents the inventory situation for each part number, and the part order information in FIG. 14 is in the order situation for each part number, that is, in the state of the current order for each part number. It represents the situation of unpaid items.
[0078]
The parts inventory information 608 and the parts inventory information 609 are updated by the parts inventory inventory information update unit 706 (see FIG. 3) according to the operation of the client machine 200.
[0079]
FIGS. 15 and 16 are diagrams showing examples of the allocation item number information 610 and the allocation details information 611 shown in FIG. 4, respectively.
[0080]
The provision item number information in FIG. 15 represents the cause of the update of the provision item information in FIG. 16, and is updated by the execution of the provision item number update process 707a.
[0081]
In this database, provision product number update means 707 (see FIG. 3) for executing the provision product number update processing 707a is stored as a stored procedure. When any of the component requirement information 607, the component inventory information 608 and the component remnant information 609 (collectively referred to as “original allocation information”) is updated, the allocation product number updating unit 707 updates the database / It is started as a trigger, and the change of the original allocation information is reflected in the allocation product number information 610.
[0082]
Further, the allocation details information 611 in FIG. 16 represents the allocation details for each product number, and is information finally obtained by this production management system.
[0083]
The allocation details information 611 is updated by periodically activating the allocation information update unit 708 (see FIG. 3) and executing the allocation information update processing 708a. The allocation information update processing 708a While referring to the product number information 610, the allocation details information 611 is updated based on the original allocation information (part requirement information 607, part inventory information 608, and part order information 609). Further, the allocation information update processing 708 a reflects the update result of the allocation details information 611 in the allocation product number information 610.
[0084]
In this way, at the moment when a change occurs in the original allocation information that is the source of the allocation process, information such as the product number is recorded in the allocation item number information 610, and the item number information that needs to be updated is acquired in the allocation details update processing 708a. At the same time, the detailed information is deleted from the allocated product number information 610.
[0085]
Further, in the present embodiment, when the provision item number information 610 is recorded, it is recorded as additional data, so that system trouble caused by contention (dead lock) at the detail line level when deleting the detail data after processing is recorded. Occurrence is avoided.
[0086]
As described above, the provision item number information 610 is information (data) that records the contents of changes when the part requirement information 607, the part inventory information 608, and the part order information 609 are changed. The part number information of the parts that need to be updated is recorded.
[0087]
Based on this information, the allocation details update process 708a is executed to update the allocation details information 611 in which the parts inventory / parts remaining are allocated to the part requirements, and the allocation details update processing of the details is performed from the allocation item number information 610. Is automatically deleted at the time of completion. The registration to the allocated product number information 610 is automatically recorded by the allocated product number update processing 707a at the moment when a change (addition / update / deletion) occurs in the information (data) of parts requirement, parts inventory, and parts remaining. Is done. In addition, by automatically starting the allocation details update processing 708a, the latest allocation details information can be provided at intervals (several seconds to several tens of seconds) until the processing is completed.
[0088]
As described above, the development configuration information 605 is a combination of application information such as stacking of component lead times (work numbers) and design changes at each hierarchical level by previously developing a multi-stage bill of materials that constitutes a product. It is information (data), and the change information is reflected instantaneously by reducing the procedure in the expansion process from the plan information 606 to the part required information 607.
[0089]
In the part required development processing 705a, even if the plan information 606 is changed, it is possible to develop the part required information 607 by simply referring to the development configuration information 605 without developing a large part table. The component requirement information 607 can be automatically changed at the moment of the plan change.
[0090]
The component part number information 604 is information (data) in which contents of changes are recorded when changes occur in the parts information 601, the parts table information 602, and the design change application information 603. Information such as part number information of parts that need to be updated is recorded. By referencing this information on the online screen, it is possible to confirm the contents of the configuration information that requires expansion processing, and at the same time, instantly change it by instructing activation of the expanded configuration update processing 703a from the screen. The result can be reflected.
[0091]
The component part number information 604 is automatically updated by the component part number update processing 703a when each piece of information (data) of the part information 601, the parts table information 602, and the application information 603 is changed (added / updated / deleted). At this time, if there is a change in the component information that requires the update of the expanded configuration information 605, the details of all the parent products that use the component are automatically updated from the expanded configuration information 605. The target is retrieved instantly and recorded in the component part number information 604.
[0092]
In the component part number information 604, the update processing result of the expanded configuration information 605 is also managed as status information, and the processing results of all the details of the configuration information requiring the expansion processing are recorded. Among these, details of errors that occur due to data defects (no parts information, parts configuration loops, etc.) are automatically recorded for the cause of the error, so check the contents from the inquiry screen. Can do.
[0093]
Further, when the data is normally developed as the development configuration information 605 without any data deficiency, it is necessary to reflect the contents of the change in the developed part requirement information 607. In the expansion configuration update processing 703a, when the expansion processing is completed normally, the contents of the change are automatically and instantaneously reflected in the component requirement information 607 in the undetermined range, and the component information 601 and the parts table information 602 are reflected. And the component requirement information 607 are synchronized in real time.
[0094]
FIG. 17 is a diagram showing, in the form of a flowchart, processing up to the creation of expanded configuration information among the processing described with reference to FIG. 4, and FIG. 18 shows allocation details information with reference to the expanded configuration information. It is the figure which represented the process until it produces in the form of a flowchart. Since each processing content has already been described, the processing flow will be briefly described here.
[0095]
As shown in FIG. 17, when the component information 601 is updated while referring to the online screen of the client machine, the expanded configuration update process is required by the database trigger and stored procedure for determining the update contents. For the parent product number, the status information of the detailed data in the component product number information 604 is automatically and instantaneously updated. This update content determination process constitutes a part of the component part number update process 702a described with reference to FIG. When the parts table information 602 and the application information 603 are changed, the same processing as when the parts information 601 is changed is performed, and the component part number information 604 is updated.
[0096]
The component part number information 604 records all the details of the configuration information that needs to be expanded. Among these, for the details in which a data defect (no part information, part configuration loop, etc.) has occurred, The cause of the error is also automatically recorded. The contents of this component part number information 604 are confirmed from an online screen or the like, and all the parent information (parent part number) that is affected by the change of the part information is confirmed, or the result of the expanded configuration update process (normal deployment, defective, etc. ) Can be queried.
[0097]
Further, the expanded configuration update processing 703a is started from an online screen and can immediately process the parent product number for which the expanded configuration update processing is required, and at the same time, the result of the processing can be obtained immediately. In addition, as for the details in which the expansion process has been completed normally as a result of the expansion configuration update process, the change contents of various master information are automatically reflected in the component requirement information in real time. At this time, the contents of the change are reflected in the expanded configuration information and the component requirement information of only the target component without unnecessarily expanding the component and re-deploying the component requirement.
[0098]
Further, in the processing flow shown in FIG. 18, when the plan information 606 is updated from an online screen or the like, the parts required expansion processing 705a which is a stored flow procedure is started by a database trigger for determining the update contents, The component requirement information 607 is updated according to the update contents. When the detailed information (data) of the plan is deleted, the part requirement information of the relevant product number is deleted, and when there is an addition or change, the part requirement information of the relevant product number is deleted / added. At the time of this addition process, the expanded configuration information 605 previously expanded in a table is referred to. Further, the database trigger determines the content of the component requirement information, and the provision item number is recorded in the provision item number information 610.
[0099]
In the example shown here, the process from the plan change to the recording of the provision item number information is processed in real time. Further, in the present embodiment, the allocation details update processing 708a registered as a stored procedure is automatically activated at 10-second intervals on the server side based on the data amount and system configuration conditions. If the system performance is low or there is room in the system performance, it may be realized in real time as a series of subsequent processes, not from the plan change to the recording of the provision product number information.
[0100]
The parts inventory update process and the parts order update process are update processes for the input data of the allocation details update process, and the allocation details update process is automatically and instantaneously performed even when the distribution information is updated every moment. In the allocation details information inquiry process, the latest information is always displayed.
[0101]
According to the present embodiment described above, it is possible to construct a real-time production management system using a general open system database in the material requirement plan development by the “manufactured MRP method”. As a result, even if a plan change or design change occurs in a short delivery time, the effect can be immediately reflected in the data to determine the impact, and the logistics information that occurs from time to time is stored in real time in the database. It is possible to reflect this in the production process with higher mobility. Furthermore, it can be realized as a small personal computer or a client-server system, and a real-time production management system can be provided at a low cost to a small and medium-sized manufacturing industry with a small capital investment.
[0102]
【The invention's effect】
As described above, according to the present invention, it is possible to provide a versatile production management system that reflects production plan changes, design specification changes, logistics information, and the like in real time at low cost.
[0103]
The environment surrounding Japan's manufacturing industry is changing drastically due to changes in consumer consciousness and diversification of customer needs. Plan changes and design changes in a short delivery period are expected to increase further. In such an environment, the core production management system needs to be constructed at a lower cost, at a higher speed, and more easily, and an information infrastructure for implementing “speed management” is provided by the present invention. I expect to be done.
[Brief description of the drawings]
FIG. 1 is a diagram showing a computer network in which an embodiment of a production management system of the present invention is deployed.
2 is a hardware configuration diagram of the computer system shown in FIG. 1. FIG.
FIG. 3 is a schematic diagram showing each means constituting a production management program stored in a CDROM.
4 is a schematic diagram showing an entire production management system constructed in the computer system shown in FIGS. 1 and 2. FIG.
FIG. 5 is a conceptual diagram of data handled by a production management system.
FIG. 6 is a diagram illustrating an example of component information.
FIG. 7 is a diagram illustrating an example of parts table information.
FIG. 8 is a diagram illustrating an example of application information.
FIG. 9 is a diagram illustrating an example of component part number information.
FIG. 10 is a diagram illustrating an example of development configuration information.
FIG. 11 is a diagram illustrating an example of plan information.
FIG. 12 is a diagram illustrating an example of component requirement information.
FIG. 13 is a diagram showing an example of parts inventory information.
FIG. 14 is a diagram illustrating an example of part order remaining information.
FIG. 15 is a diagram showing an example of provision item number information;
FIG. 16 is a diagram illustrating an example of allocation detail information.
FIG. 17 is a diagram showing, in the form of a flowchart, processing until creation of development configuration information.
FIG. 18 is a diagram showing, in the form of a flowchart, processing until creation detail information is created with reference to development configuration information.
[Explanation of symbols]
100, 200, 300 computer system
101, 201, 301 body
101a, 201a, 301a Display screen
101b, 201b, 301b CDROM loading slot
102, 202, 302 Display section
102a, 202a, 302a Display screen
103, 203, 303 Keyboard
104,204,304 mouse
111 Central processing unit (CPU)
112 RAM
113 Hard disk controller
114 floppy disk driver
115 CDROM driver
116 Mouse controller
117 Keyboard controller
118 Display controller
119 Communication board
120 hard disk
400 communication network
510 floppy disk
520 CDROM
601 Parts information
602 BOM information
603 Applicable information
604 Component part number information
605 Deployment configuration information
606 plan information
607 Parts requirement information
608 Parts inventory information
609 Parts leftover information
610 Allocated product number information
611 Provision details information
700 Production management program
701 Original configuration information update means
702 Component product number update means
702a Component part number update processing
703 Deployment configuration update means
703a Deployment configuration update processing
704 Plan information update means
705 Part required development means
705a Parts required development processing
706 Parts inventory remaining information update means
707 Provision product number information update means
707a Provision product number update processing
708 Provision information update means
708a Provision information update processing

Claims (8)

In the production management system that manages the production of products,
Updated based on the original configuration information including component information representing information of a single product number, parts table information representing a parent-child relationship of the product number, and application information representing a change in the product number to be applied to the product, A database having development configuration information in which the requirements for each product number for each command product number are expanded and component product number information indicating whether or not the development configuration information needs to be updated for each parent product number ;
Original configuration information updating means for updating the original configuration information according to an operation;
Expanded configuration update means for updating the expanded configuration information based on the updated original configuration information ;
A component part number updating unit that is activated in response to the update of the original component information and updates the component part number information based on the updated original component information;
The expanded configuration update means updates the expanded configuration information with reference to the component part number information, and reflects the update result in the component part number information. The component part number updating means is activated upon receiving an update of any part number information in the original configuration information, searches for a parent part number affected by the update, and is affected by the update in the constituent part number information. 2. The production management system according to claim 1, wherein information on a parent product number for receiving the product is updated. 2. The production management system according to claim 1, wherein the original configuration information updating unit displays the component part number information and activates the expanded configuration updating unit according to an operation. The database further includes plan information representing a production plan for each command part number, and parts requirement information representing requirements for each part number,
  Plan information updating means for updating the plan information according to an operation;
  The production management according to claim 1, further comprising: a component required expansion unit that starts upon receiving the update of the plan information and expands the plan information into the component required information while referring to the expansion configuration information. system. The expanded configuration update means refers to the plan information and reflects the updated contents in the expanded configuration information in the component requirement information when the expanded configuration information is updated normally as a result of updating the expanded configuration information. The production management system according to claim 4. The database further includes parts inventory information representing the inventory status for each product number, parts inventory information representing the inventory status for each product number, and allocation details information representing the allocation details for each product number. And
  Parts inventory remaining information updating means for updating the parts inventory information and the parts remaining information according to an operation;
  5. The allocation details updating means for updating the allocation details information on the basis of original allocation information consisting of the parts requirement information, the parts inventory information, and the parts inventory information. The production management system described. The database further includes provision item number information indicating a reason for updating the provision item information,
  The provisional item number updating means is activated in response to the update of the original allocation information, and updates the allocation item number information based on the updated original allocation information,
  7. The production management according to claim 6, wherein the allocation detail updating means updates the allocation detail information with reference to the allocation item number information and reflects the update result in the allocation item number information. system. In a production management program storage medium storing a production management program for operating a computer as a production management system for managing product production,
  The computer,
  Based on the original configuration information, which includes component information representing information of a single product number, parts table information representing a parent-child relationship of the product number, and application information representing a change in the product number to be applied to the product A database having updated configuration information obtained by expanding the requirements of each product number for each command product number and component product number information indicating whether or not the development configuration information needs to be updated for each parent product number;
  Original configuration information updating means for updating the original configuration information according to an operation;
  Expanded configuration update means for updating the expanded configuration information based on the updated original configuration information;
  A component part number updating unit that is activated in response to the update of the original component information and updates the component part number information based on the updated original component information;
  The expanded configuration updating means stores a production management program that operates as a production management system that updates the expanded configuration information with reference to the component part number information and reflects the update result in the component part number information. A production management program storage medium characterized by the above.

Images