JP4686103B2 - Manufacturing information management system - Google Patents

Description

[0001]
BACKGROUND OF THE INVENTION
The present invention is a manufacturing information management system for easily and quickly searching for a product group in which a similar defect produced from the same lot may appear when a defect occurs in a product in a food manufacturer or the like. In particular, the present invention relates to a manufacturing information management function providing system that services contract companies that have remotely accessed this function.
[0002]
[Prior art]
For example, when a defect is found that a black spot is attached to the inner surface of a paper cup, which is a food container delivered to the food manufacturer by the food packaging manufacturer, the food manufacturer finds the defect in the packaging manufacturer. Tell the number of the label affixed to the case of the paper cup. Then, the packaging material manufacturer reverses the process of manufacturing the paper cup, and specifies a common intermediate material or raw material used for manufacturing the paper cup in which the defect is found. This specific work is based on the record that is left for each process at the packaging manufacturer (herein, the term “work slip” is used), and what was the input input that was the source of the intermediate output for that process This is done by following each process. Once a common raw material or intermediate material has been identified, this time, a similar problem has occurred by following the records of the relevant work schedules in the forward direction, i.e., from the input of the process to the output. Identify possible paper cups by case label number. The packaging manufacturer will take measures such as collecting all products with those label numbers, and will investigate the cause of the failure.
[0003]
However, since the delivered product was discovered in this way, the work to identify the raw material etc. that was the source of the delivered product based on the work record, and other similar problems may have occurred The work of identifying the delivered products (hereinafter, this work is referred to as “trace work”) is generally a time-consuming and troublesome work because a person reads and traces a handwritten work sheet. Moreover, if a defect is discovered by the end consumer after it reaches the end consumer, the slow response will severely damage the food manufacturer's credibility, which makes the packaging manufacturer quick, accurate, and leaky. No trace work is required.
[0004]
[Problems to be solved by the invention]
One method for solving such problems is to manage the input and output in each manufacturing process so that they can be specified, create a database of records of work results in each process, and perform the above trace work on a computer. Is to build a system that can be run on. However, in order to build a manufacturing information management system that can perform the above trace work quickly, easily and accurately without omission, a computer system with sufficient performance is installed, and a database and necessary software are designed and developed. After the start of operation, maintenance and troubleshooting measures must be taken so that the system operates stably. Therefore, in order to install and operate such a system on its own, it is necessary to have human resources with specialized knowledge and experience in IT technology and sufficient financial power. There was a problem that it was difficult to install and operate the system on its own.
[0005]
The present invention has been made in view of such problems, and a service providing system that can easily provide a manufacturing information management function to a client company that can perform the above-described tracing work quickly, easily, and accurately without omission. It is a problem to realize.
[0006]
In the present invention, the above-mentioned problem is configured by an access server or a router, and remote access accepting means for accepting access through a dial-up connection or a network from a user of a contract user and a user sent by the user. Content that consists of an authentication means that permits access if the ID or password is registered, and a WWW server that responds to the data requested in response to the user's request or the result of starting the program Delivery means;
Manufacturing information database that stores and records manufacturing performance information and manufacturing management information for each company,
According to the request of the content distribution means, manufacturing performance information is recorded in the manufacturing information database of each user company to which the user belongs, and the manufacturing information database is searched based on the search condition, and the result is stored in the content data. A manufacturing information management server that communicates to the content distribution means as
The manufacturing information management function provided in the manufacturing information management server is solved by a manufacturing information management function providing system that provides users of contracting companies that have accessed remotely.
In this manufacturing information management function providing system,
The manufacturing information database of each user company is
Record the performance of each unit process in each manufacturing process with an identification number. Work record And that unit processing Of raw materials or semi-finished products The identification code of the input processing and the identification code of the output generated by the unit processing In Relationship Basic unit that is a digit record Records are recorded and held as manufacturing performance information in a form that can be retrieved from an application process operating on the manufacturing information management server,
The manufacturing information management server is
Data management means for updating the manufacturing performance information at the request of a user of a user company, and for registering and managing necessary manufacturing management information other than the manufacturing performance information in the manufacturing information database of each user company;
Manufacturing information tracing means for retrieving information on the corresponding raw material or final product or related semi-finished product by referring to the manufacturing performance information from the identification code of the final product or raw material;
For function selection and search condition input or search result display of the data management means and manufacturing information trace means Including a trace table configured based on the basic unit record GUI means for generating a user interface,
The function is exhibited by operating as an application process that is called from the content distribution means and returns a processing result to the content distribution means,
According to the progress of the manufacturing work of the user company, the manufacturing performance information is recorded and accumulated, and the information on the corresponding raw material or final product or related semi-finished product based on the manufacturing performance information from the identification code of the final product or raw material. Can be obtained.
[0008]
In the manufacturing information database, the term “identification number” is used for the unit process of each manufacturing process, and the word “identification code” is used for the input material input to the unit process and the output product obtained from the unit process. It is a code with an appropriate number of digits. They are only used for convenience.
[0010]
DETAILED DESCRIPTION OF THE INVENTION
The manufacturing information management function providing system 2 (hereinafter referred to as system 2), which is an embodiment of the present invention, will be described below, but before that, the manufacturing information management system 1 (hereinafter referred to as system 1) will be described first. This is because the system 2 is provided with a function that enables the functions of the manufacturing information management system 1 to be provided to a user who accesses from a remote location.
[0011]
In the following description of the system 1, the manufacturing information management of the food packaging material manufacturer will be described. FIG. 3 is an overall configuration diagram of the system 1. The system 1 includes a manufacturing information management apparatus 20 that plays a central role, and several input terminals 10 and printing terminals 30 that are installed for each process.
[0012]
The input terminal 10 reads an identification code of a raw material input in a certain process or a semi-finished product created in the previous process before the process starts in a certain process, and transmits it to the manufacturing information management apparatus 20. At the end of the process in the process, the identification code attached to the generated semi-finished product is read. Also, the creation of a work form for leaving a work record and a request for registration of the work record to the manufacturing information management apparatus 20 are made. Therefore, for example, it can be comprised with the personal computer provided with the barcode reader. Alternatively, it may be a dedicated terminal equipped with a bar code reader, a work input display monitor, and an input keyboard. Further, what is attached to the semi-finished product as an identification code may be a medium such as a card or an IC tag having a magnetic tape recording portion on which the identification code is recorded, instead of a bar code. Therefore, the input terminal 10 may be provided with a device that reads those media in contact or non-contact. The printing terminal 30 generates and prints a code readable by the input terminal 10 that uniquely identifies the semi-finished product output in the process. The operator attaches an identification code printed in a predetermined manner to the semi-finished product or the set of semi-finished products. The input terminal 10 and the printing terminal 30 are arranged in pairs for each normal production process.
[0013]
The manufacturing information management apparatus 20 includes a manufacturing result recording unit 21, a manufacturing information management unit 24, a manufacturing information database 23, a manufacturing information tracing unit 25, and a graphical user interface unit (hereinafter referred to as GUI unit) 26. Reference numerals 40 and 41 denote input devices such as a graphic display and a keyboard connected to the manufacturing information management apparatus 20.
[0014]
The manufacturing record recording unit 21 receives the work start notification from the input terminal 10, presents the work form to the input terminal 10, receives the input of the manufacturing record information from the input terminal 10, and updates the manufacturing record information 52. ·sign up. That is, the manufacturing record information 52 includes a work record record, a process output product table 521 and an input / output coupling table 522 which will be described later. The manufacturing information management unit 24 receives other manufacturing information, that is, product master information necessary for each item, DTP data of a product (packaging package, etc.), and past complaint processing information in response to an input from the input device 41 by an operator. In addition, all necessary management information related to manufacturing, such as order receipt slips, product specifications, and master information of machines used in each process, is accumulated and managed in the database 23.
[0015]
The manufacturing information tracing means 25 identifies the specified final product. code The manufacturing performance information 52 is searched according to the search conditions such as the above, and the related work form data is extracted from the manufacturing information database 23. The result is displayed on the display 40 through the GUI means 26.
[0016]
FIG. 4 is a diagram showing the data structure of the manufacturing information database 23. The data structure can be broadly divided into information 50 relating to production lots created and managed each time based on one order received, product information 80 relating to the product itself handled, and information 90 relating to the process. The information 50 related to the production lot is recorded and managed by an order entry slip record, an order specification record, and manufacturing performance information 52 for each received order. The order entry slip record is a record in which basic information about an order, an order number, an order origin, a delivery date, a delivery destination, an order amount, etc. are recorded. The order specification record is a record for recording information related to the manufacturing specification of the product to be produced. The production performance information 52 includes a work record record 523 for each process for the received lot. Similarly, the process output product table 521 and the input / output coupling table 522 included in the manufacturing performance information 52 will be described later.
[0017]
The product information 80 includes a record of specification information of the product (paper box or bag), DTP data defining the design of the product, and a record record of past complaint processing for the product. In the process information 90, information about the manufacturing machine to be used is recorded for each process. It also includes form data for the work forms created in each process.
[0018]
FIG. 5 is a diagram for explaining the process output product table 521. Each column of this table is a set of two columns, each corresponding to one process. Two cells corresponding to a specific row of two columns forming one set of this table are paired with an identification code assigned to a product (semi-finished product) in the process and a number of a work ticket that has processed the semi-finished product. Record. For example, in FIG. 5, the fifth and sixth rows correspond to the process A. The two cells in the first row of these columns indicate that the semi-finished product “A-1” is generated in the process A, and the work work sheet at that time is “work sheet 00A1”. The first to fourth rows are titled Raw Material 1 and Raw Material 2, which are treated as a type of process in the sense of “Raw Material 1 Acceptance Process” and “Raw Material 2 Acceptance Process”. Is. Therefore, by referring to this table, for example, it is understood that the delivery note when receiving the raw material 1 specified by the identification code “Y” is “delivery note 02”.
[0019]
Each row of two columns forming one set of the process output product table 521 corresponds to one work unit of the process. In other words, it corresponds to a unit in which a work schedule for recording the person in charge of the work, the work content, and the like is created in the process. Therefore, even if the same line of records is recorded, it may be a work that takes a whole day in one process and a work that ends in two hours in another process.
[0020]
Next, the input / output coupling table 522 will be described with reference to FIG. The input / output coupling table 522 also has a set of two columns each corresponding to one process. Two cells corresponding to a specific row of two columns forming one set of the table indicate an output product in the process and raw materials input to the process as an input product or an output product of the previous process. For example, in the column of step A, it is recorded in the first row that “X” of raw material 1 is input to the product “A-1” of step A. In the second line, it is recorded that “Y” of raw material 1 is charged to product “A-1”. Since the product “A-1” matches, it can be understood that both “X” and “Y” of the raw material 1 are added to the product “A-1”.
[0021]
The production record recording unit 21 sequentially updates the process output product table 521 and the input / output coupling table 522 based on information input by the operator through the input terminal 10. The work performed by the operator at the input terminal 10 in each process is as follows. First, the system 1 is notified that processing of one unit of the process is newly started. The system 1 generates a work form number and displays a work form on the input terminal. Next, the worker inputs an input material to be input in the process process into the system 1. Specifically, an identification code affixed to a pallet or the like of the raw material or the output product of the previous process is input to the reading system 1 by the input terminal 10. When there are a plurality of types of input items, the identification codes are read for all the input items. Further, information necessary for creating work work forms is also input from the input terminal 10. An operator starts the process of the said process. When it is necessary to replenish the input material in the middle of the processing, the system reads the identification code pasted on the pallet of the raw material or the output material of the previous process with the input terminal 10 in the same way as when starting the process processing. Enter 1
[0022]
When the process is completed, the label (or the magnetic card or IC tag on which the new identification code is recorded) on which the new identification code is printed is output from the printing terminal 30, and the operator outputs the label. Paste the product. When many semi-finished products are stacked on one pallet or the like, the label is attached to the pallet or the like. If possible, direct printing on the product by an ink jet printer or the like may be used instead of labeling. Then, the operator reads this label with the input terminal 10. As a result, the contents to be newly recorded in the work record record 523, the process output product table 521, and the input / output coupling table 522 are determined. The manufacturing record recording means 21 newly registers the work record record 523, and for the process output product table 521 and the input / output connection table 522, the new input information and the identification number of the new work record record generated by the system 1 are entered. The contents are updated by adding to the end of the column corresponding to the process in each table.
[0023]
Next, the quality trace function of the system 1 will be described focusing on a graphical user interface (hereinafter referred to as GUI). FIG. 7 is a search screen at the time of process trace search, which is the main function of the system 1. Initially, the trace search table 700 is not displayed. Suppose a complaint is received about the delivered product. If the case number assigned to the product is 102, the case number “102” is displayed in the case number input field 701 at the upper left of the screen of FIG. 7, and the customer (manufacturer) is stored in the customer / product name designation field 703. When a name and a product name (product name) are input and a search button 702 is pressed, the database 23 is searched to identify the order number of the target product, and the manufacturing result information is displayed as a trace search table 700. FIG. 7 shows the display state at this stage. The color of the cell on the trace search table 700 corresponding to the delivery operation for the case number 102 is changed (FIG. 7A).
[0024]
Next, the front trace button 704 is clicked. Then, the search on the trace search table 700 starts as shown in FIG. That is, the search starts in the forward direction from the cell (FIG. 8A) representing the delivery operation corresponding to the case number 102, and the color of the cell in the related intermediate operation process is changed to combine the raw materials “X” “Y”. “Z” “a” (FIG. 8B) is reached. The portion where the color of the cell has changed in FIG. 8 indicates that the product is delivered as case number 102 and the work using a common intermediate product or raw material in the middle work process.
[0025]
next, Backward By clicking the trace button 705, starting from the combination of raw materials “X”, “Y”, “Z”, “a” (FIG. 8B), the work steps other than the work steps shown in FIG. Search the work process backwards. As a result, as shown in FIG. 9, it can be seen that case numbers “105” and “106” (FIG. 9C) were manufactured from the same raw material as the product of case number “102”. Therefore, if there is a defect in the case number “102”, the operator uses this search screen to confirm that the same defect is very likely to occur in the delivered products of the case numbers “105” and “106”. It can be easily known by using it.
[0026]
The operator can know from the display of the cells of the case numbers “105” and “106” in the delivery process column on the trace search table 700 that they have been shipped to the customer's Tokyo factory and Sendai factory. . Furthermore, by clicking these cells, it is possible to display the shipping slip on the screen and to know the contact information of the delivery destination and other detailed information.
[0027]
Next, the operation of the manufacturing information tracing means 25, which is a mechanism on the back side for realizing the GUI that operates as shown in FIGS. 7 to 9, will be described with reference to the flowchart of FIG. The manufacturing information trace unit 25 is called when the operator selects “quality trace” from the menu screen presented by the GUI unit 26. First, the operator designates in the input field 701 a case number that identifies a delivery unit of a defective product or a product printed on its packaging film or the like (S100). At this time, the customer (manufacturer) name and the product name (product name) are also input to the customer / product name designation field 703 as much as possible. Subsequently, when the search button 702 is pressed, the manufacturing information tracing unit 25 searches the delivery slip data and specifies the order number of the target product (S103). Then, the manufacturing result information 52 related to the order number is extracted from the manufacturing information database 23 (S104). The manufacturing performance information 52 includes a process output table 521, an input / output coupling table 522, and a manufacturing performance record 523 recorded in each manufacturing process. Therefore, the trace table 700 can be displayed based on those contents (S106). FIG. 7 is a trace table displayed.
[0028]
FIG. 2 shows the trace table displayed in FIG. 7 more clearly by combining cells corresponding to common work record records. As can be seen from FIG. 2, the trace table 700 is composed of basic units 790 shown in FIG. The basic unit 790 is a cell 791 that displays one input object identification code that is actually input in the process operation, a machine number that performed the process operation, a cell 792 that displays a progress date, and is obtained in the process operation. The cell is composed of three cells 793 for displaying an identification code of one output product. The cell 792 is linked to a work record record that records the work performance of the work. These cells are created by extracting necessary information based on the process output table 521 and the input / output coupling table 522.
[0029]
In this state, an input wait state (S110) is entered. If the operator designates the forward trace by clicking the forward trace button 704, the forward trace is performed from the designated case number (S113). This is because, in the trace table 700, in the column representing the process (packing process) immediately before the delivery process, the basic unit displaying the designated case number as an output is searched for, and the input side of this basic unit is displayed. Next, the basic unit 790 of the previous step having an identification code matching the identification code on the output side is searched for, and the identification code on the input side is obtained. What is necessary is just to repeat the trace to the previous process in order until it reaches the identification code of a raw material. FIG. 8 shows this state. The state again waits for input (S110).
[0030]
If the operator continues to specify the back trace, the back trace is performed from the extracted raw material (S115). The backward trace searches for the basic unit of the next process that has the first identification code (raw material identification code) on the input side, and matches the identification code of the output of the basic unit. The process of searching for the basic unit of the next process to be used as an input item is repeated until the case number of the delivery process is reached again. FIG. 9 shows a state in which the backward trace is finished. The state again waits for input (S110).
[0031]
When the worker selects the cell 792 for displaying the machine number and progress date of the basic unit 790, the manufacturing result record 523 of the relevant process work linked to this cell is called and the manufacturing result information is displayed (S117). .
[0032]
The manufacturing information management system 1 has been described above. The features of the system 1 can be summarized in the following three points. 1) For manufacturing unit information for each unit operation of each process, input items to one unit operation of the process, output items generated by one unit operation of the process, work record recording the operation results at that time To grasp as a record. 2) A unique identification code is physically combined with the output generated by the unit work in each process, and the information handled by the system is associated with the actual physical object. 3) When performing the trace work, the manufacturing result information stored and recorded in the structure of 1) is identified for each unit work of each process. code Output identification code A basic unit 790 composed of a link to the work record of the work is configured, and the trace work can be easily performed without omission by the basic unit 790. These are the above three points. Therefore, in the system 1, the manufacturing result information 52 is constituted by three points of the process output table 521, the input / output combination table 522, and the manufacturing result (work slip) record 523, and based on these, the basic unit 790 is constituted, Although the function of easily performing the tracing work is realized by the interactive interface, the manufacturing result information 52 may be accumulated and recorded in any form as long as the basic unit 790 can be configured.
[0033]
For example, the manufacturing performance information is stored as two types of records, that is, a set of data of the basic unit 790 and a manufacturing performance (work slip) record 523 linked and referenced from the elements of the set. It may be recorded.
[0034]
Further, the manufacturing information database 23 does not have to be a single database as shown in FIG. 4, and the product information 80 and the process information 90 may be independent databases. In FIG. 10, when the corresponding order number is obtained (S103), the product name is known from the order entry slip included in the order unit information 50 of the corresponding order number. Therefore, the specific product in the product information 80 is designated from the product name. Because it can.
[0035]
The system 1 that is the prototype of the manufacturing information management function providing system 2 (hereinafter referred to as system 2) as an embodiment of the present invention has been described above. In the description of the system 1, the manufacturing information management of the food packaging manufacturer is described in mind. Since food packaging manufacturers manufacture packaging materials in accordance with food manufacturer orders, manufacturing activities are started by “orders”, and one order is a standard unit for managing manufacturing information. The system 1 can be applied even to a manufacturer that needs to manage manufacturing activities based on manufacturing plans rather than orders. In that case, instead of the “order number”, the manufacturing information database 23 based on the manufacturing number is managed using a word representing a manufacturing activity of one unit based on a certain manufacturing plan, for example, “manufacturing number”. become.
[0036]
Next, the main system 2 will be described. In the system 2, an application server that provides the function of the manufacturing information management apparatus 20 in the system 1 is configured as the manufacturing information management server 29, and the function of the manufacturing information management server 29 is provided to a user who accesses remotely. A system configured by adding a remote access accepting means, an authenticating means for authenticating a user, and a content distribution means for responding to data requested in response to a user request or a result of starting a program. is there. FIG. 12 is an overall configuration diagram of the system 2. Hereinafter, the system 2 will be described with reference to FIG.
[0037]
Reference numerals 70a, 70b, and 70c denote companies that receive service provision. These companies have as many input terminals 10 and printing devices 30 as necessary. Reference numerals 61 and 62 denote access servers provided as the remote access receiving means. The input terminal 10 accesses the access server 61 or 62 via a communication network 7 of a telephone carrier of a mobile phone or a PHS terminal or a communication network 8 of a wired telephone, respectively. Reference numeral 70a shows a case of a company A having a department that handles original products such as agricultural products, marine products, and livestock products and a product processing department. In the department that handles the original product, manufacturing performance information can be recorded from the input terminal 10 through the wireless telephone network, and in the processing section, the manufacturing performance information can be recorded and the manufacturing information tracing function can be performed through the wired telephone communication network 8. is there. Reference numeral 63 denotes an authentication server provided as the authentication means. It is determined whether or not the access of the user who has accessed the access server 61 or 62 is accepted. Reference numeral 64 denotes a WWW server provided as the content distribution means. Information to be provided to the user is provided on the HTTP (HyperText Transfer Protocol) protocol.
[0038]
A manufacturing information management server 29 executes an application process that provides a manufacturing information tracing function and a manufacturing information management function. Each company has data management means 27, manufacturing information tracing means 25, and GUI means 26 of each company. The data management means 27 has the functions of the production record recording means 21 and the production information management means 24 in the production information management apparatus 20 of the system 1. Each of these means accesses the manufacturing information database 23 of each company and provides necessary services. The manufacturing information tracing means 25, the GUI means 26 of each company, and the manufacturing information database 23 are the same as the system 1.
[0039]
The operation mode of the system 2 is as follows. The user company makes a dial-up connection to the access server 61 or 62 by calling a predetermined telephone number from the input terminal 10. The access server 61 or 62 receives the user ID and password data sent by a WAN (Wide Area Network) protocol such as PPP (Point-to-Point Protocol) and passes it to the authentication server 63. The authentication server 63 determines whether or not the user is registered from the user ID and password. Thereafter, the authenticated user is permitted to access the WWW server 64. The access server 61 or 62 may be combined with a caller ID notification service provided by the telephone carrier so as not to receive an incoming call from a telephone number other than a pre-registered telephone number, or once disconnected. It is also possible to set to call back to the caller only when the phone number is registered.
[0040]
The user of the authenticated user company calls a necessary menu according to a GUI such as a menu screen generated by the corresponding GUI means 26 according to the authenticated company ID. For example, when recording the manufacturing results, from the presented menu, select a menu item for recording the manufacturing results, and according to the screen displayed thereafter, work start notification, input of manufacturing results information, in the process, The process data and the identification code of the input (input) and output are read by a code reader or input from a keyboard or the like. In addition, when performing a trace search for a production record, a menu item for a trace search for a production record is selected from the presented menu, and the production information tracing means 25 is activated. The processing contents of the manufacturing information tracing means 25 are the same as those in the system 1.
[0041]
The manufacturing information tracing unit 25 may also be prepared for each user company, like the data management unit 27 and the GUI unit 26. This is because the name of the process, the raw material to be used, and the name of the intermediate product to be managed are different for each user company. However, the structure of the process output product table 521 and the input / output connection table 522 in the manufacturing performance information is basically different except for the difference in the name of the process, the raw material to be used, and the name of the intermediate product to be managed. Absent. Therefore, the process name and the types of raw materials and intermediate products are managed by codes that can be identified by the computer, and the process output product table 521 and the input / output connection table 522 are defined by a common schema. If the name conversion table 28 that corresponds to the name of the process that can be recognized, the name of the raw material, and the name of the intermediate product is prepared for each company, the manufacturing information tracing means 25 has one program, Can be used in common by each user company. In this case, the GUI unit 26 and the data management unit 27 also refer to the name conversion table 28 and execute the process of generating the user interface screen and searching for the manufacturing result information 52.
[0042]
After all, the data management means 27, the name conversion table 28, and the GUI means 26 for each company are prepared for each user company, and the manufacturing information management server 29 provided with the manufacturing information tracing means 25 used in common, and access for accepting remote access By configuring the server 61 or 62, the authentication server 63 that authenticates the user, and the WWW server 64 that returns a GUI screen in response to the user's request using the HTTP protocol as the system 2, the user company can use the system 2 It is possible to use functions equivalent to the functions provided by the system 1 without providing any equipment other than installing the input terminal 10 and the printing terminal 30 in the company.
[0043]
In the above description of the system 2, the user of the user company dials up directly to the access server 61 or 62. However, as shown in FIG. 13, an IP network used in the IP (Internet Protocol) protocol. It is also possible to use the network 9. In this case, the system 2 side prepares a router 65 instead of the access servers 61 and 62, and the user of the user company makes a dial-up connection to the access point installed in the IP network 9 by the communication carrier. It becomes. In consideration of security, the data passing through the IP network 9 needs to be treated such as encryption. In the case of FIG. 13, the router 65 becomes a remote access means.
[0044]
FIG. 14 is an overall configuration diagram when a service fee collection function is added to the system 2 shown in FIG. In this configuration, the access server 62 includes an access log totaling unit 621 that keeps an access record from a contract use company, and a use fee calculation unit 622 that calculates a use fee for a certain period for each contract use company based on the access record. A bank account settlement unit 661 is provided in the billing processing server 66 installed separately. The bank account settlement means 661 sends an authentication request for starting a settlement process to the financial institution network 7 and a settlement request for debiting a bill amount for each user company from the bank account of the company. Is sent to the gateway of the financial institution network 7 as a message expressed by. Usually, the access log totaling unit 621 may use a function provided in an access server device as a commercial product. The usage fee calculation means 622 may be provided on a server other than the access server 62 or 61. Further, the bank account settlement unit 661 may use a function of a dedicated device that is commercially available as the accounting processing server 66.
[0045]
【The invention's effect】
As explained above, the manufacturing information management system easily and quickly leaks products that may produce similar defects produced from the same lot when a defect occurs in a food manufacturer or the like. There is a remarkable effect that the search can be performed without any problem. In addition, by using the manufacturing information management function providing system, it is possible to use the functions of the manufacturing information management system without providing any equipment other than installing the input terminal 10 and the printing terminal 30 in the company. There is an effect.
[Brief description of the drawings]
FIG. 1 is a model diagram of a manufacturing process.
FIG. 2 is an explanatory diagram of a trace table 700 and a basic unit 790;
FIG. 3 is an overall configuration diagram of a manufacturing information management system 1 which is a prototype of the present invention.
4 is an explanatory diagram of the structure of a manufacturing information database 23. FIG.
FIG. 5 is an explanatory diagram of a process output table 521;
FIG. 6 is an explanatory diagram of an input / output coupling table 522;
FIG. 7 is a screen interface for manufacturing information trace.
FIG. 8 is a screen interface for manufacturing information trace.
FIG. 9 is a screen interface for manufacturing information trace.
10 is a flowchart for explaining the operation of the manufacturing information tracing means 25. FIG.
11 is an explanatory diagram of a basic unit 790 constituting the trace table 700. FIG.
FIG. 12 is an overall configuration diagram of a manufacturing information management function providing system 2 according to an embodiment of the present invention.
FIG. 13 is an overall configuration diagram of different aspects of the manufacturing information management function providing system 2 according to the embodiment of the present invention.
FIG. 14 is an overall configuration diagram of different aspects of the manufacturing information management function providing system 2 according to the embodiment of the present invention.
[Explanation of symbols]
1 Manufacturing information management system
2. Manufacturing information management function provision system
7 Financial Institution Network
8 Telephone network
9 IP network
10 Input terminal
20 Manufacturing information management device
21 Manufacturing record recording means
23 Manufacturing information database
24 Manufacturing information management means
25 Manufacturing information tracing means
26 GUI means
27 Data management means
28 Name conversion table
29 Manufacturing information management server
50 Order unit information
51 Order information
52 Manufacturing results information
521 Process output table
522 I / O coupling table
523 Manufacturing record
61 Remote Access Server
62 Remote Access Server
621 Log aggregation means
622 Usage fee calculation means
63 Authentication server
64 WWW server
66 Billing server
661 Bank account settlement method
70 companies
80 Product Information
90 Process information
700 Trace table
790 basic units

Claims (1)

Consists of an access server or router, registered with the remote access accepting means that accepts dial-up connections from users of contracting companies or access via the network, and the user ID and password sent from the user In the case of the above, an authentication unit that permits access, a content distribution unit configured by a WWW server that returns a result of starting data requested for a user's request or a program,
Manufacturing information database that stores and records manufacturing performance information and manufacturing management information for each company,
According to the request of the content distribution means, manufacturing performance information is recorded in the manufacturing information database of each user company to which the user belongs, and the manufacturing information database is searched based on the search condition, and the result is stored in the content data. A manufacturing information management server that communicates to the content distribution means as
A manufacturing information management function providing system that provides a manufacturing information management function provided in the manufacturing information management server to a user of a contracting company that has remotely accessed,
The manufacturing information database of each user company is
And Engineering slip record to record with the identification number the work record of a unit process in each manufacturing step, the identification code and the output generated by the unit processing the input of raw materials or semi-products that are put into the unit process the basic unit record is recorded digits with related identification codes in the identification number of the unit process of a product, be those recorded retained as manufacturing performance information in a searchable form from application processes running the manufacturing information management server And
The manufacturing information management server is
Data management means for updating the manufacturing performance information at the request of a user of a user company, and for registering and managing necessary manufacturing management information other than the manufacturing performance information in the manufacturing information database of each user company;
Manufacturing information tracing means for retrieving information on the corresponding raw material or final product or related semi-finished product by referring to the manufacturing performance information from the identification code of the final product or raw material;
GUI means for generating a user interface including a trace table configured based on the basic unit record for function selection and search condition input or search result display of the data management means and manufacturing information trace means,
The function is exhibited by operating as an application process that is called from the content distribution means and returns a processing result to the content distribution means,
According to the progress of the manufacturing work of the user company, the manufacturing performance information is recorded and accumulated, and the information on the corresponding raw material or final product or related semi-finished product based on the manufacturing performance information from the identification code of the final product or raw material. Manufacturing information management function providing system characterized in that