Inspection achievement management device, inspection achievement management method, and inspection achievement management program

Abstract

To provide an inspection achievement management device capable of acquiring an accurate inspection achievement with a low workload, an inspection achievement management method, and an inspection achievement management program.SOLUTION: In an inspection achievement management device, an inspection result aggregation unit refers to production achievement data to trace a lot about a product with item number to be shipped of shipment achievement data, acquires item numbers and lot numbers of each manufacturing process, creates lot trace information including item numbers, hierarchies, and lot numbers of products of each manufacturing process in a high hierarchical order with the downstream side of the manufacturing process as a higher hierarchy, acquires inspection items and inspection results from the inspection achievement data with the item numbers and lot numbers of the lot trace information as keys, creates inspection result aggregation data per inspection item, and adopts the inspection results of a process with a higher hierarchy of a downstream process about the inspection results of duplicated inspection items.SELECTED DRAWING: Figure 2

Description

[Technical field]

[0001] The present invention relates to an inspection record management device, an inspection record management method, and an inspection record management program. [Background technology]

[0002] For example, when manufacturing solder, inspection is performed at each manufacturing process. In this case, the inspection items are different at each manufacturing process, and the lot is subdivided as it proceeds to the next process, so it is necessary to input the inspection results each time, which causes a large input load and generates inconsistent data. For example, Patent Document 1 is known as a conventional system related to manufacturing inspection. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Patent No. 7158777 Summary of the Invention [Problem to be solved by the invention]

[0004] However, there is no mention of performing lot tracing (trace-back) on the product number and lot number for which the product inspection report is issued, obtaining and consolidating the inspection results for the product number and lot number that occurred, and obtaining accurate inspection results with a low workload.

[0005] The present invention has been made in consideration of the above, and has an object to provide an inspection record management device, an inspection record management method, and an inspection record management program that are capable of performing lot tracing on product numbers and lot numbers for which product inspection reports are issued, and acquiring and consolidating inspection records for the generated product numbers and lot numbers, thereby acquiring accurate inspection records with a low workload. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the present invention provides an inspection record management device that includes a control unit and manages inspection results in a manufacturing process of a product, the control unit accessing order record data including a customer, a delivery destination, an estimate destination, a product number, and an order quantity, shipping record data including a customer, a delivery destination, an estimate destination, a product number, a lot number, and a shipment quantity, manufacturing record data including product numbers and lot numbers of input items including raw materials, which are input in each manufacturing process, and product numbers and lot numbers of finished products manufactured from the input items, and inspection record data that is an inspection result of the finished products manufactured in each manufacturing process and includes product numbers, inspection patterns, lot numbers, inspection items, inspection standards, and inspection results. the inspection result aggregation means is configured to be accessible from the upstream to downstream of the inspection result data, and performs lot tracing on the product having the part number of the shipped product in the shipping result data by referring to the manufacturing result data, obtains the part number and lot number of each manufacturing process, creates lot tracing information including the part number, layer, and lot number of the manufactured product of each manufacturing process in order of higher layers with the downstream side of the manufacturing process being the higher layer, obtains inspection items and inspection results from the inspection result data using the part number and lot number of the lot tracing information as keys, creates aggregated data of the inspection results for each inspection item, and at this time, for the inspection results of overlapping inspection items, the inspection result of the downstream process having the higher layer is adopted.

[0007] According to another aspect of the present invention, the inspection items and inspection standards of the inspection performance data may be in-house standards.

[0008] According to one aspect of the present invention, the order performance data includes inspection report destinations including customers, estimate recipients, or delivery destinations, and the control unit is further configured to be able to access a product number master in which product numbers and external product specification patterns are associated and registered, and an external product specification pattern master in which the external product specification pattern, inspection report destinations including customers, estimate recipients, delivery destinations, or common, and external standards including inspection items and inspection specifications are associated and registered, and the control unit is further configured to be able to access a product number master in which the external product specification pattern, inspection report destinations including customers, estimate recipients, delivery destinations, or common, and external standards including inspection items and inspection standards are associated and registered, and the control unit is further configured to be able to access a product number master in which the external product specification pattern, inspection report destinations including customers, estimate recipients, delivery destinations, or common, and external standards including inspection items and inspection standards are associated and registered, and the control unit is further configured to be able to access an external product specification pattern master in which the external product specification pattern, inspection report destinations including customers, estimate recipients, delivery destinations, or common, and external standards including inspection items and inspection standards are associated and registered, and the control unit is further configured to

[0009] According to another aspect of the present invention, the inspection report output means may, when there is no corresponding data in the external product specification pattern master using the inspection report destination of the order performance data as a key, obtain an external standard having a common inspection report destination from the external product specification pattern master.

[0010] According to another aspect of the present invention, the order history data may include an inspection report language, and the inspection report output means may output the inspection report in the inspection report language of the order history data.

[0011] According to another aspect of the present invention, the manufacturing process of the product may include a solder manufacturing process.

[0012] In order to solve the above-mentioned problems and achieve the object, the present invention provides an inspection performance management method executed by an information processing device having a control unit, the control unit being configured to be able to access order performance data including a customer, a delivery destination, an estimate destination, a product number, and an order quantity; shipping performance data including a customer, a delivery destination, an estimate destination, a product number, a lot number, and a shipment quantity; manufacturing performance data including product numbers and lot numbers of input items including raw materials, which are input in each manufacturing process, and product numbers and lot numbers of finished products manufactured from the input items; and inspection performance data which is an inspection result of the finished products manufactured in each manufacturing process, and includes product numbers, inspection patterns, lot numbers, inspection items, inspection standards, and inspection results. The control unit refers to the manufacturing performance data, performs lot tracing on the product having the product number of the shipped product in the shipping performance data, obtains the product number and lot number of each manufacturing process, creates lot tracing information including the product number, layer, and lot number of the manufactured product of each manufacturing process in order of higher layers with the downstream side of the manufacturing process being the higher layer, obtains inspection items and inspection results from the inspection performance data using the product number and lot number of the lot tracing information as keys, creates aggregated data of the inspection results for each inspection item, and in this case, includes an inspection result aggregation process in which, for the inspection results of overlapping inspection items, the inspection result of a process having a higher layer downstream is used.

[0013] In order to solve the above-mentioned problems and achieve the object, the present invention provides an inspection record management program to be executed by an information processing device having a control unit, the control unit being configured to be able to access order record data including a customer, a delivery destination, an estimate destination, a product number, and an order quantity, shipping record data including a customer, a delivery destination, an estimate destination, a product number, a lot number, and a shipment quantity, manufacturing record data including product numbers and lot numbers of input items including raw materials, which are input in each manufacturing process, and product numbers and lot numbers of finished products manufactured from the input items, and inspection record data which is an inspection result of the finished products manufactured in each manufacturing process and includes product numbers, inspection patterns, lot numbers, inspection items, inspection standards, and inspection results, and the control unit being configured to be able to access order record data including a customer, a delivery destination, an estimate destination, a product number, and an order quantity, shipping record data including a customer, a delivery destination, an estimate destination, a product number, a lot number, and a shipment quantity, manufacturing record data including product numbers and lot numbers of input items including raw materials, which are input in each manufacturing process, and product numbers and lot numbers of finished products manufactured from the input items, and inspection record data which is an inspection result of the finished products manufactured in each manufacturing process, and includes product numbers, inspection patterns, lot numbers, inspection items, inspection standards, and inspection results, the inspection results management program is for executing an inspection result consolidation process in which, with reference to the manufacturing results data, the program is executed in a control unit, and performs lot tracing for the product having the product number of the shipped product in the shipping results data, and obtains the product number and lot number of each manufacturing process, and creates lot tracing information including the product number, layer, and lot number of the manufactured product of each manufacturing process in order of higher layers, with the downstream side of the manufacturing process being the higher layer; the program obtains inspection items and inspection results from the inspection results data using the product number and lot number of the lot tracing information as keys, and creates consolidated data of the inspection results for each inspection item, and in this case, for the inspection results of overlapping inspection items, the inspection results of a process with a higher layer downstream are used. Effect of the Invention

[0014] According to the present invention, it is possible to perform lot tracing on the product number and lot number for which a product inspection report is to be issued, and to obtain and consolidate the inspection results for the generated product number and lot number, thereby making it possible to obtain accurate inspection results with a low workload. [Brief description of the drawings]

[0015] [Figure 1] FIG. 1 is a diagram showing an image of the solder manufacturing process. [Diagram 2] FIG. 2 is a block diagram showing an example of the configuration of an inspection record management device according to this embodiment. [Diagram 3]FIG. 3 is a diagram showing a data correlation diagram of the part number master, the external product standard pattern master, the order record data, the shipping record data, the lot details, the manufacturing record data, the inspection record data, the inspection report data, and the like. [Figure 4] FIG. 4 is a flow chart showing an example of an outline of the overall processing of the control unit of the inspection result management device according to this embodiment. [Diagram 5] FIG. 5 is a diagram for explaining a specific example of the process of the control unit of the inspection result management device according to the present embodiment. [Figure 6] FIG. 6 is a diagram for explaining a specific example of the process of the control unit of the inspection result management device according to the present embodiment. [Figure 7] FIG. 7 is a diagram for explaining a specific example of the process of the control unit of the inspection result management device according to the present embodiment. [Figure 8] FIG. 8 is a diagram for explaining a specific example of the process of the control unit of the inspection result management device according to the present embodiment. [Figure 9] FIG. 9 is a diagram for explaining a specific example of the process of the control unit of the inspection result management device according to the present embodiment. [Figure 10] FIG. 10 is a diagram for explaining a specific example of the process of the control unit of the inspection result management device according to the present embodiment. [Figure 11] FIG. 11 is a diagram for explaining a specific example of the process of the control unit of the inspection result management device according to the present embodiment. [Figure 12] FIG. 12 is a diagram for explaining a specific example of the process of the control unit of the inspection result management device according to the present embodiment. [Figure 13] FIG. 13 is a diagram for explaining a specific example of the process of the control unit of the inspection result management device according to the present embodiment. [Figure 14] FIG. 14 is a diagram for explaining a specific example of the process of the control unit of the inspection result management device according to the present embodiment. [Figure 15] FIG. 15 is a diagram for explaining a specific example of the process of the control unit of the inspection result management device according to the present embodiment. [Figure 16]FIG. 16 is a diagram for explaining a specific example of the process of the control unit of the inspection result management device according to the present embodiment. [Figure 17] FIG. 17 is a diagram for explaining a specific example of the process of the control unit of the inspection result management device according to the present embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS

[0016] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the drawings. However, the present invention is not limited to the embodiment.

[0017] [1. Overview] The outline of the present embodiment will be described in the order of (background and problems), (main points), (functional outline of the present embodiment), and (effects of the present embodiment).

[0018] (Background / Issues) For example, when manufacturing solder, the following background and challenges exist: (1) The inspection items differ at each manufacturing process, and the lot is subdivided as it progresses to the next process. Since inspection reports require inspection results data for the final product, it is necessary to register the inspection results for each subdivided lot. This makes data entry a lot of work and increases the possibility of data inconsistency.

[0019] (2) Inspections at each manufacturing process must be managed according to in-house standards, and inspection reports must be issued in the language and external standards of each destination. In the process of the final product that is the subject of the inspection report, inspection results management is required according to external standards, so inspection results management according to in-house standards is not possible. The contents of inspection results management include the mixture ratio management of metal components for raw materials and the content management of auxiliary raw materials.

[0020] (Point of interest) Figure 1 shows an image of the solder manufacturing process, where (A) shows an example of coil type or bar solder, and (B) shows an example of solder paste.

[0021] As shown in Figure 1(A), in the case of coil type and bar solder, (1) multiple metal raw materials are mixed in the mixing process to produce a billet, (2) extrusion processing is performed in the extrusion process, (3) wire drawing processing is performed in the wire drawing process, and (4) molding according to the shape is performed in the winding and cutting process.

[0022] In the case of solder paste, (1) multiple metal raw materials are mixed and atomized in the spraying process, (2) the particles are sifted to a specified particle size in the classification process, and (3) the mixture is mixed uniformly in the kneading process.

[0023] In this embodiment, attention is paid to the following two points. (1) In the blending and spraying processes, the metal raw materials are blended, and in subsequent processes the shape is changed, so the metal components (blending ratio) do not change. In the wire drawing and classification processes, non-metallic auxiliary raw materials such as flux are added. The inspection results managed in the above processes are compiled into an inspection report.

[0024] (2) Inspection results are managed according to in-house standards, and inspection reports are issued in the language and external standards of each recipient.

[0025] (Functional Overview of the Present Embodiment) (1) When issuing an inspection report, perform lot tracing (trace back) based on the target product number and lot number, and obtain and consolidate the inspection results for the generated lot number. In this case, the lot number must be unique as a prerequisite.

[0026] (2) In accordance with external standards, the inspection results from (1) are obtained. When tracing back, the hierarchical levels (final product hierarchical level = 0, downstream manufacturing processes are considered higher hierarchical levels, and final product hierarchical level = 0 is considered the top hierarchical level) are counted, and if results are duplicated for an inspection item, the inspection results from the lower hierarchical level (higher hierarchical level) are used.

[0027] (Effects of this embodiment) (1) When issuing an inspection report, it is necessary to carry out product inspection, but this can improve the redundant work and reduce the risk of registering inconsistent data. (2) Inspection results are managed according to in-house standards. In-house standards are set stricter than external standards, which allows for improved accuracy in inspection results management.

[0028] The inspection record management device of this embodiment can be widely applied in industries and business types that involve mixing and processing in the manufacturing process, and can be applied to industries and business types that require quality control based on ingredients, such as the solder industry and the chemical industry.

[0029] [2. Configuration] An example of the configuration of the inspection record management device 100 according to the present embodiment will be described with reference to Fig. 2. Fig. 2 is a block diagram showing an example of the configuration of the inspection record management device 100. The inspection record management device 100 of the present embodiment can be applied to, for example, inspection record management for the manufacture of solder, and can also be applied to the manufacture of other products.

[0030] The inspection record management device 100 is a commercially available desktop personal computer. The inspection record management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.

[0031] The inspection record management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. The units included in the inspection record management device 100 are connected to each other so as to be able to communicate with each other via any communication path.

[0032] The communication interface unit 104 communicably connects the inspection record management device 100 to a network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the inspection record management device 100 and the server 200 to each other so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

[0033] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a home television), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to realize a pointing device function. In the following, the output device 114 may be referred to as the monitor 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112. Displaying information on the monitor 114 and the user operating the input device 112 may be referred to as a "user operation via a UI."

[0034] The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used as the storage unit 106. The storage unit 106 stores a part number master 106a, an external product standard pattern master 106b, order performance data, shipping performance data, lot details, manufacturing performance data, inspection performance data, inspection report data, and the like. FIG. 3 is a diagram showing a data correlation diagram of the part number master 106a, the external product standard pattern master 106b, order performance data, shipping performance data, lot details, manufacturing performance data, inspection performance data, inspection report data, and the like.

[0035] The part number master 106a can be configured as a table in which part numbers and external product standard patterns are registered in association with each other. "External product standards" are also called "external standards."

[0036] The external product specification pattern master 106b can be configured as a table or the like in which the external product specification pattern, the inspection report destination, the supplier CD, and the external specifications (inspection items, the number of decimal places, and the inspection specifications) are registered in association with each other.

[0037] The order performance data may include, for example, order header data (order number, customer, delivery destination, estimate destination) and order detail data (product code, product number, inspection report destination, inspection report language).

[0038] The shipping performance data may include shipping header data (shipment number, order number, customer, delivery destination, quotation destination), shipping detail data (product number code, product number, shipping date), and shipping detail data (number shipped, lot number).

[0039] The lot detail data may include a product code, a product number, a lot number, a manufacturing date, and an expiration date.

[0040] The production performance data may include the part numbers of input items (raw materials, auxiliary raw materials, supplies, auxiliary materials, work-in-progress) and their lot numbers in each manufacturing process, as well as the part numbers of finished products (work-in-progress, final products) produced from the input items and their lot numbers.

[0041] The inspection results data may include inspection header data (inspection number), inspection details data (product number, inspection pattern code, lot number), and detailed inspection data (inspection item, number of decimal places, inspection standard, inspection result). Here, the inspection item, number of decimal places, and inspection standard use in-house standards. In-house standards are stricter than external standards, so inspection results can be managed precisely.

[0042] The inspection report data may include order number, customer, delivery destination, quotation destination, product number code, product number, inspection report destination, inspection report language, shipping number, shipping date, shipment quantity, lot number, manufacturing date, expiration date, external specifications (inspection items, number of decimal places, inspection specifications), and inspection results.

[0043] The control unit 102 is a CPU or the like that comprehensively controls the inspection record management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, required data, and the like, and executes various types of information processing based on these stored programs.

[0044] The control unit 102 is configured to be able to access the part number master 106a, the external product standard pattern master 106b, order performance data, shipping performance data, lot details, manufacturing performance data, inspection performance data, inspection report data, and the like stored in the storage unit 106. Note that the part number master 106a, the external product standard pattern master 106b, order performance data, shipping performance data, lot details, manufacturing performance data, inspection performance data, and inspection report data may be provided in another location (for example, the server 200) as long as the control unit 102 is able to access them.

[0045] The control unit 102, in terms of functional concept, includes an order input unit 102a, a shipment input unit 102b, a manufacturing performance input unit 102c, an inspection performance input unit 102d, an inspection result aggregation unit 102e, an inspection report output unit 102f, a screen display control unit 102g, and a master maintenance unit 102h.

[0046] The order input unit 102a inputs and registers actual order data in the storage unit 106 in response to, for example, an operator's operation on an order input screen (not shown) displayed on the monitor 114.

[0047] The shipment input unit 102b inputs shipment performance data and registers it in the storage unit 106 in response to, for example, an operator's operation on a shipment input screen (not shown) displayed on the monitor 114.

[0048] The manufacturing performance input unit 102c inputs manufacturing performance data for each manufacturing process in response to an operator's operation on a manufacturing performance input screen (not shown) displayed on the monitor 114, for example, and registers the data in the storage unit 106.

[0049] The inspection record input unit 102d inputs inspection record data for products manufactured in each manufacturing process, for example, in response to an operator's operation on an inspection record input screen (not shown) displayed on the monitor 114, and registers the data in the memory unit 106.

[0050] The inspection result consolidation unit 102e refers to the manufacturing performance data, performs lot tracing on the products with the product numbers shipped in the shipping performance data, obtains the product numbers and lot numbers of each manufacturing process, creates lot tracing information including the product numbers, layers, and lot numbers of the manufactured products of each manufacturing process in order of higher layers, with the downstream side of the manufacturing process being the higher layer, obtains the inspection items and inspection results from the inspection performance data using the product numbers and lot numbers of the lot tracing information as keys, and creates consolidated data of the inspection results for each inspection item, whereby for the inspection results of overlapping inspection items, the inspection results of the downstream process with the higher layer are used.

[0051] The inspection report output unit 102f acquires an external product specification pattern from the product number master 106a using the product number of the order performance data as a key, acquires external standards from the external product specification pattern master 106b using the acquired external product specification pattern and the inspection report destination of the order performance data as keys, creates inspection report data based on the order performance data, shipping data, the acquired external standards, and aggregated data of the inspection results, registers it in the memory unit 106, and outputs (prints out and / or displays) an inspection report based on the inspection report data.

[0052] If there is no corresponding data in the external product specification pattern master 106b using the inspection report destination of the order result data as a key, the inspection report output unit 102f may obtain an external standard with a common inspection report destination from the external product specification pattern master 106b.

[0053] The inspection report output unit 102f may output the inspection report in the inspection report language of the order result data.

[0054] The screen display control unit 102g controls the display of various screens (for example, various input screens, master maintenance screen, etc.) displayed on the monitor 114 and the inputs thereto.

[0055] The master maintenance unit 102h performs settings such as data input, addition, change, and update for the part number master 106a and the external product standard pattern master 106b in response to, for example, an operator's operation on a master maintenance screen (not shown) displayed on the monitor 114.

[0056] [3. Specific Examples] A specific example of the process performed by the control unit 102 of the inspection record management device 100 in this embodiment will be described with reference to FIGS.

[0057] (3-1. Overall processing) 4 is a diagram showing a flow for explaining an outline of the overall processing of the control unit 102 of the inspection record management device 100 in this embodiment. With reference to FIG. 4, an outline of the overall processing of the control unit 102 of the inspection record management device 100 in this embodiment will be explained.

[0058] 4, first, an order is received for the manufacture of a product. The order input unit 102a executes an order input process (step S1). Specifically, in the order input process, the order input unit 102a inputs order performance data and registers it in the storage unit 106 in response to an operator's operation on an order input screen (not shown) displayed on the monitor 114, for example.

[0059] The ordered product is manufactured in each manufacturing process. The manufacturing performance input unit 102c executes a manufacturing performance input process (step S2). Specifically, in the manufacturing performance input process, the manufacturing performance input unit 102c inputs manufacturing performance data for each manufacturing process in response to an operator's operation on a manufacturing performance input screen (not shown) displayed on the monitor 114, for example, and registers the data in the storage unit 106.

[0060] The products manufactured in each manufacturing process are inspected for predetermined inspection items. The inspection result input unit 102d executes an inspection result input process (step S3). Specifically, in the inspection result input process, the inspection result input unit 102d inputs inspection result data for the products manufactured in each manufacturing process in response to an operator's operation on an inspection result input screen (not shown) displayed on the monitor 114, for example, and registers the data in the storage unit 106.

[0061] The manufactured product is shipped. The shipment input unit 102b executes a shipment input process (step S4). Specifically, in the shipment input process, the shipment input unit 102b inputs shipment performance data and registers it in the storage unit 106 in response to an operator's operation on a shipment input screen (not shown) displayed on the monitor 114, for example.

[0062] An inspection report is required when shipping. First, the inspection result consolidation unit 102e executes an inspection result consolidation process (step S5). Specifically, in the inspection result consolidation process, the inspection result consolidation unit 102e refers to the manufacturing performance data, performs lot tracing for the product with the product number to be shipped in the shipping performance data, acquires the product number and lot number of each manufacturing process, creates lot tracing information including the product number, layer, and lot number of the manufactured product of each manufacturing process in order of higher layers, with the downstream side of the manufacturing process being the higher layer, acquires the inspection item and the inspection result from the inspection performance data using the product number and lot number of the lot tracing information as a key, creates consolidated data of the inspection result for each inspection item, and at this time, adopts the inspection result of the process with a higher layer downstream for the inspection results of overlapping inspection items.

[0063] The inspection report output unit 102f executes the inspection report output process (step S6). Specifically, in the inspection report output process, the inspection report output unit 102f acquires an external product specification pattern from the product number master 106a using the product number of the order result data as a key, acquires an external specification from the external product specification pattern master 106b using the acquired external product specification pattern and the inspection report destination of the order result data as a key, creates inspection report data based on the order result data, shipping data, the acquired external specification, and the aggregated data of the inspection results, registers the data in the storage unit 106, and outputs (prints and / or displays) an inspection report based on the inspection report data.

[0064] (3-2. Sample data) 5 to 17 are diagrams showing sample data for explaining a specific example of the processing by the control unit 102 of the inspection record management device 100 in this embodiment. A specific example of the processing by the control unit 102 of the inspection record management device 100 in this embodiment will be explained with reference to Figs. 5 to 17.

[0065] (Prerequisite data) Fig. 5 is a diagram showing an example of the configuration of the part number master 106a. The part number master 106a has items for part number and external product standard pattern. The part number master 106a is used to set the inspection pattern for the inspection report to be sent to the customer, and an external product standard pattern is set for each part number. In the example shown in the figure, an external product standard pattern for "Product 001" is set, with the part number "Product 001" and the external product standard pattern "S00001" being set.

[0066] 6 is a diagram showing an example of the configuration of the external product specification pattern master 106b. The external product specification pattern master 106b includes items such as external product specification pattern, inspection report destination, supplier CD, and external specifications (inspection item, number of decimal places, inspection standard). The external product specification pattern master 106b includes a pattern with a specified inspection report destination and a common pattern with no specified inspection report destination.

[0067] The external product specification pattern obtained from the product number master 106a using the product number of the order result data as a key, and the external specifications (inspection items, number of decimal places, inspection specifications) are obtained from the external product specification pattern master 106b using the customer, delivery destination, or quotation destination specified in the inspection report destination of the order result data as a key. If the data cannot be obtained, the data of the common destination is obtained again.

[0068] FIG. 6(A) is an example of a pattern in which the destination of the inspection report is specified, for example, the external product specification pattern is "S00001", the destination of the inspection report is "Quoter", and the business partner CD is "Quoter C". For the inspection item "A", the number of decimal places is "3", the inspection specification is "75.000 to 85.000", for the inspection item "B", the number of decimal places is "1", the inspection specification is "8.0 to 12.0", for the inspection item "C", the number of decimal places is "3", the inspection specification is "up to 10.000", for the inspection item "D", the number of decimal places is "3", the inspection specification is "up to 10.000", for the inspection item "E", the number of decimal places is "4", the inspection specification is "24.0750 to 25.0250". For example, if the destination of the inspection report of the order performance data is specified as the quoter, this data is obtained using the quoter as a key.

[0069] Figure 6 (B) is an example of a common pattern where the inspection report destination is not specified, for example, the external product specification pattern is "S00001", the inspection report destination is "common", and the customer CD is "-", and for the inspection item "A", the number of decimal places is "3", the inspection specification is "75.000 to 85.000", for the inspection item "B", the number of decimal places is "1", the inspection specification is "8.0 to 12.0", for the inspection item "C", the number of decimal places is "2", the inspection specification is "up to 10.00", and for the inspection item "E", the number of decimal places is "4", the inspection specification is "20.000 to 30.0000". If the data cannot be acquired by the above, this data will be acquired.

[0070] (Data information) Fig. 7 is a diagram showing an example of actual order data. The actual order data includes order header data (order number, customer, delivery destination, quotation destination) and order detail data (product code, product code, inspection report destination, inspection report, language). In the example shown in the figure, the data are order number "J0001", customer "Customer A", delivery destination "Delivery destination B", quotation destination "Quotation destination C", product code "S001", product code "Product 001", inspection report destination "Delivery destination", and inspection report language "Japanese".

[0071] 8 is a diagram showing an example of shipping performance data and lot detail data. The shipping performance data includes shipping header data (shipping number, order number, customer, delivery destination, quotation destination), shipping detail data (product code, product code, shipping date), and shipping detail data (shipment quantity, lot number). In the example shown in the figure, the shipping number is "S0001", the order number is "J0001", the customer is "Customer A", the delivery destination is "Delivery Destination B", the quotation destination is "Quotation Destination C", the product code is "S001", the product code is "Product 001", the shipping date is "2023 / 03 / 20", the shipping quantity is "100.000 kg", and the lot number is "0000111123".

[0072] The lot detail data includes fields for product code, product number, lot number, manufacturing date, and expiration date. The lot detail data holds information on the manufacturing date and expiration date for each product number and lot number by registering a slip with each manufacturing record input. In the example shown in the figure, the product number code is "S001", the product number is "Product 001", the lot number is "0000111123", the manufacturing date is "2023 / 03 / 10", and the expiration date is "2023 / 09 / 09".

[0073] (S5: Test result aggregation process) A specific example of the inspection result consolidation process will be described with reference to Fig. 9 to Fig. 13. An inspection report is issued for the shipping performance data, but before that, the inspection result consolidation process is executed. The inspection result consolidation unit 102e refers to the manufacturing performance data, performs lot tracing for the product with the product number shipped in the shipping performance data, acquires the product number and lot number of each manufacturing process, creates lot tracing information including the product number, layer, and lot number of the manufactured product of each manufacturing process in order of higher layers, with the downstream side of the manufacturing process being the higher layer, links the lot tracing information with the inspection performance data of each manufacturing process, creates consolidated data of the inspection results for each inspection item, and at this time, for the inspection results of overlapping inspection items, adopts the inspection results of the process with the higher layer downstream.

[0074] (1) With reference to the manufacturing performance data, lot tracing is performed for the part number of the shipped product in the shipping performance data, and the part number and lot number of each manufacturing process are obtained to create lot tracing information.

[0075] 9(A) to 9(D) show examples of manufacturing performance data for the compounding process (adding flux, etc.), the large wire drawing process, and the winding process (adding bobbins for coils and packing cases). Fig. 9(E) is a diagram showing an example of lot tracing information. In the following example, a case where lot tracing information is created for the product number "Product 001" in the shipping performance data in Fig. 8 will be described.

[0076] As shown in Figures 9(A) to (D), the production performance data includes the part numbers of input items (raw materials, auxiliary raw materials, supplies, auxiliary materials, work-in-progress) and their lot numbers in each production process, as well as the part numbers of finished products (work-in-progress, final products) produced from the input items and their lot numbers.

[0077] As shown in FIG. 9(A), the production performance data for the blending process is as follows: (manufactured product) part number: work in progress 101, lot number: 0000100023, (input product) part number: raw material 001, lot number: 0003950123, ...

[0078] As shown in FIG. 9(B), the manufacturing performance data for the large wire drawing process is as follows: (manufactured product) part number: work in process 201, lot number: 0000110023, (input product) part number: work in process 101, lot number: 0000100023.

[0079] As shown in FIG. 9(C), the manufacturing performance data for the small wire drawing process is as follows: (manufactured product) part number: work in process 301, lot number: 0000111023, (input product) part number: work in process 201, lot number: 0000110023, part number: auxiliary raw material 001, lot number: 0005221123.

[0080] As shown in FIG. 9(D), the production performance data for the winding process is as follows: (manufactured product) part number: product 001, lot number: 0000111023, (input product) part number: work in process 301, lot number: 0000110023 part number: auxiliary material 001, part number: auxiliary material 002.

[0081] For the product number "Product 001" to be shipped in the shipping performance data, the manufacturing performance data in Figures 9(A) to (D) is lot traced, the product number and lot number of each manufacturing process are obtained, and lot tracing information is created that includes the product number, layer, and lot number of the manufactured product of each manufacturing process in order of higher layers, with the downstream side of the manufacturing process being the higher layer. Note that lot tracing obtains all information related to performance (manufacturing performance, purchasing performance, shipping and returning, automatic movement, inventory performance, etc.).

[0082] Fig. 9(E) shows an example of the lot trace information that is created. The lot trace information organizes the manufactured and input products of each manufacturing process into a hierarchy, and includes the items of configuration (product number of manufactured and input products of each manufacturing process), hierarchy, and lot number. In the example shown in the figure, the highest hierarchy is product 001, which is the shipped product, with hierarchy "0" and lot number "0000111023." The lowest hierarchy is raw material 001, with hierarchy "4" and lot number "0003950123."

[0083] FIG. 10 is a diagram for explaining the lot numbering rules. Lot numbers are assigned automatically. Lot numbers may be, for example, 10 digits in total. The top five digits are consecutive consecutive numbers. The middle three digits are counted up for each process. The number of digits to be counted is specified in the item number master 106a. The first lot on the first line of the disbursement item is the target. The bottom two digits are the last two digits of the year in which production began. Examples of lot numbering for coil type and bar solder, and for solder paste are shown in the figure.

[0084] (2) Link the lot tracing information with the inspection results data for each manufacturing process, and use the product number and lot number in the lot tracing information as keys to obtain the inspection items and inspection results from the inspection results data for each manufacturing process, and create aggregated data of the inspection results for each inspection item.

[0085] Linking of the lot tracing information and the inspection result data will be described with reference to Figures 11 to 13. The lot tracing information and the inspection result data are linked by the product number and the lot number.

[0086] Fig. 11(A) shows an example of lot trace information, and Fig. 11(B) shows an example of inspection results data for the winding process. The inspection results data includes inspection header data (inspection number), inspection details data (product number, inspection pattern code, lot number), and inspection details data (inspection item, number of decimal places, specifications, inspection results).

[0087] In the example shown in the figure, the inspection number is "003", the part number is "Product 001", the inspection pattern code is "00001", the lot number is "0000111123", the inspection item is "E", the number of decimal places is "4", the specification is "24.0750~25.0250", and the inspection result is "25.1000".

[0088] Using the part number "product 001" and lot number "0000111123" of the lot tracing information as keys, the inspection item "E" and the inspection result "25.1000" are obtained from the inspection performance data of the winding process.

[0089] Fig. 12(A) shows an example of lot trace information, and Fig. 12(B) shows an example of inspection result data for a small wire drawing process. In the example shown in the figure, the inspection number is "002", the product number is "Work in progress 301", the inspection pattern code is "00002", the lot number is "0000111123", the inspection item is "E", the number of decimal places is "4", the specification is "24.0750~25.0250", and the inspection result is "25.1250".

[0090] Using the part number "Work in progress 301" and lot number "0000111123" of the lot tracing information as keys, the inspection item "E" and the inspection result "25.1250" are obtained from the inspection performance data of the small wire drawing process.

[0091] FIG. 13(A) shows an example of lot trace information, and FIG. 13(B) shows an example of inspection performance data for the blending process. In the example shown in the figure, for the inspection number "001", product number "Work in progress 101", inspection pattern code "00003", and lot number "0000111123", for inspection item "A", the number of decimal places is "3", inspection specification "78.000 to 82.000", and inspection result "80.000", for inspection item "B", the number of decimal places is "3", inspection specification "9.000 to 11.000", and inspection result "10.000", for inspection item "C", the number of decimal places is "3", inspection specification "up to 6.000", and inspection result "5.000", and for inspection item "D", the number of decimal places is "3", inspection specification "up to 6.000", and inspection result "5.000".

[0092] Using the part number "Work in progress 301" and lot number "0000111123" of the lot tracing information as keys, the following are obtained from the inspection performance data of the small wire drawing process: inspection item "A", inspection result "80.000", inspection item "B", inspection result "10.000", inspection item "C", inspection result "5.000", and inspection item "D", inspection result "5.000".

[0093] As shown in Figure 13(C), the inspection items and results obtained above are aggregated for each inspection item by hierarchical level, and for overlapping inspection items, the inspection results from the higher hierarchical level in the downstream process are used as shown in Figure 13(D).In this example, for inspection item "E", the inspection result "25.1250" from hierarchical level "1" overlaps with the inspection result "25.1000" from hierarchical level "0", so the inspection result "25.1000" from the higher hierarchical level in the downstream process is used.

[0094] (S6: Inspection report output processing) A specific example of the inspection report output process will be described with reference to Fig. 14 to Fig. 17. The inspection report output unit 102f acquires an external product specification pattern from the product number master 106a using the product number of the order result data as a key, and acquires external product standards (inspection items, number of decimal places, inspection standards) from the external product specification pattern master 106b using the acquired external product specification pattern and the customer, delivery destination, or quotation destination specified in the inspection report destination of the order result data as a key. If there is no corresponding item, it acquires external product standards (inspection items, number of decimal places, inspection standards) with a destination of "common" from the external product specification pattern master 106b using the customer, delivery destination, or quotation destination specified in the inspection report destination of the order result data as a key.

[0095] FIG. 14(A) is an example of a pattern in which the “destination” is specified as “quoter” in the external product standard pattern master 106b, and FIG. 14(B) is an example of a pattern in which the “destination” is specified as “common.”

[0096] Using the part number "Product 001" of the order performance data in Fig. 7 as a key, the external product standard pattern "S0001" is obtained from the part number master 106a in Fig. 5, and using the external product standard pattern "S0001" and the inspection report destination "Delivery destination" of the order performance data in Fig. 7 as keys, the external standards (inspection items, number of decimal places, inspection standards) are obtained from the external product standard pattern master 106b. In the pattern of the external product standard pattern master 106b in Fig. 14(A), the destination is "quoter", so it does not match, and so the external standards are obtained from Fig. 14(B) where the destination is "common".

[0097] The inspection report output unit 102f creates inspection report data based on the order record data, shipping data, lot detail data, external standards (inspection items, number of decimal places, inspection standards) acquired from the external product standard pattern master 106b, and aggregated data of the inspection results.

[0098] 15 is a diagram showing an example of inspection report data. The inspection report data includes the following items: order number, customer, delivery destination, quotation destination, product code, product number, inspection report destination, inspection report language, shipping number, shipping date, shipping quantity, lot number, manufacturing date, expiration date, external product standards (inspection items, number of decimal places, inspection standards), and inspection results. Note that when the inspection results overflow due to the number of decimal places, rounding processing (rounding off) may be performed.

[0099] The inspection report output unit 102f outputs an inspection report based on the inspection report data in the "inspection report language" of the order result data. FIG. 16 shows an example of an inspection report in Japanese. FIG. 17 shows an example of an inspection report in English. The inspection report may be in an Excel form. For example, template Excel data may be obtained and the obtained data may be set in a specified cell. By using an Excel form, it is possible to accommodate layout changes and layout additions, and scalability can be taken into consideration.

[0100] As described above, by referring to the manufacturing performance data, lot tracing is performed for the product with the product number to be shipped in the shipping performance data, the product number and lot number of each manufacturing process are obtained, and lot tracing information including the product number, layer, and lot number of the manufactured product of each manufacturing process is created in order of the upper layer, with the downstream side of the manufacturing process being the higher layer. The inspection items and inspection results are obtained from the inspection performance data using the product number and lot number of the lot tracing information as keys, and aggregated data of the inspection results for each inspection item is created. At this time, for the inspection results of overlapping inspection items, the inspection results of a process with a higher downstream layer are adopted. Therefore, it is possible to perform lot tracing for the product number and lot number for which a product inspection report is to be issued, and to obtain and aggregate the inspection results for the generated product number and lot number, thereby obtaining accurate inspection results with a low workload.

[0101] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to goals 8 and 9 of the SDGs.

[0102] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.

[0103] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.

[0104] 5. Other embodiments The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.

[0105] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.

[0106] In addition, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.

[0107] Moreover, with regard to the inspection record management device 100, the components shown in the figures are merely functional concepts, and the device does not necessarily have to be physically configured as shown in the figures.

[0108] For example, the processing functions of the inspection record management device 100, particularly the processing functions performed by the control unit, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium including programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the inspection record management device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and constitutes the control unit in cooperation with the CPU.

[0109] In addition, this computer program may be stored in an application program server connected to the inspection record management device 100 via an arbitrary network, and it is also possible to download all or a part of it as necessary.

[0110] In addition, the program for executing the process described in this embodiment may be stored in a non-transitory computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.

[0111] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a distributed configuration as multiple modules or libraries, and a program that achieves its function by working with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in the embodiments, as well as the installation procedure after reading, may use well-known configurations and procedures.

[0112] The various databases etc. stored in the memory unit are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files etc. used for various processes and providing websites.

[0113] The inspection record management device 100 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as the information processing device to which any peripheral device is connected. The inspection record management device 100 may be realized by installing software (including programs, data, etc.) that causes the device to realize the processing described in this embodiment.

[0114] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Explanation of symbols]

[0115] 100 Inspection performance management device 102 Control section 102a Order Entry Section 102b Shipping input section 102c Manufacturing performance input section 102d Inspection results input section 102e Test Results Collection Department 102f Inspection report output section 102g Screen display control unit 102h Master Maintenance Department 104 Communication interface section 106 Storage section 106a Part Number Master 106b Foreign product standard pattern master 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network

Claims

1. An inspection record management device for managing inspection results in a manufacturing process of a product, the inspection record management device comprising: The control unit is Order history data including customers, delivery destinations, quotation recipients, product numbers, and order quantities, Shipping performance data including customers, delivery destinations, quotation recipients, product numbers, lot numbers, and shipment quantities, Production performance data including part numbers and lot numbers of input items including raw materials, and part numbers and lot numbers of finished products manufactured using the input items, which are input in each manufacturing process; The inspection results for the products manufactured in each manufacturing process include product numbers, inspection patterns, lot numbers, inspection items, inspection standards, and inspection results. is configured to be accessible to an inspection history management device comprising: inspection result aggregating means for performing lot tracing on products having a product number of a shipped product in the shipping history data by referring to the manufacturing history data, obtaining the product number and lot number of each manufacturing process, creating lot tracing information including the product number, layer, and lot number of the manufactured product of each manufacturing process in order of higher layers, with the downstream side of the manufacturing process being the higher layer; obtaining inspection items and inspection results from the inspection history data using the product number and lot number of the lot tracing information as keys, creating aggregated data of the inspection results for each inspection item, and in this case, for the inspection results of overlapping inspection items, using the inspection results of a process with a higher layer downstream.

2. 2. The inspection record management device according to claim 1, wherein the inspection items and inspection standards of the inspection record data are in-house standards.

3. The order performance data includes an inspection report destination, including a customer, an estimate destination, or a delivery destination, The control unit further A part number master that associates part numbers with external product standard patterns and registers them; An external product standard pattern master in which an external product standard pattern, an inspection report destination including a customer, an estimate destination, a delivery destination, or a common destination, and an external standard including an inspection item and an inspection standard are associated and registered; is configured to be accessible to 2. The inspection record management device according to claim 1, further comprising an inspection report output means for acquiring an external product specification pattern from said product number master using a product number of said order performance data as a key, acquiring external standards from said external product specification pattern master using the acquired external product specification pattern and an inspection report destination of said order performance data as keys, creating inspection report data based on aggregated data of said order performance data, said shipping performance data, said acquired external standards, and said inspection results, and outputting an inspection report based on said inspection report data.

4. The inspection record management device according to claim 3, characterized in that, when there is no corresponding data in the external product standard pattern master using the inspection report destination of the order record data as a key, the inspection report output means acquires an external standard having a common inspection report destination from the external product standard pattern master.

5. The order performance data includes an inspection report language, 4. The inspection record management device according to claim 3, wherein the inspection report output means outputs the inspection report in an inspection report language of the order record data.

6. 6. The inspection record management device according to claim 1, wherein the manufacturing process of the product includes a manufacturing process of solder.

7. An inspection record management method executed by an information processing device having a control unit, The control unit is Order history data including customers, delivery destinations, quotation recipients, product numbers, and order quantities, Shipping performance data including customers, delivery destinations, quotation recipients, product numbers, lot numbers, and shipment quantities, Production performance data including part numbers and lot numbers of input items including raw materials, and part numbers and lot numbers of finished products manufactured using the input items, which are input in each manufacturing process; The inspection results for the products manufactured in each manufacturing process include product numbers, inspection patterns, lot numbers, inspection items, inspection standards, and inspection results. is configured to be accessible to Executed in the control unit: an inspection results management method comprising: referring to said manufacturing results data, lot tracing the product of the product number shipped in said shipping results data, obtaining the product number and lot number of each manufacturing process, creating lot tracing information including the product number, layer, and lot number of the manufactured product of each manufacturing process in order of higher layers, with the downstream side of the manufacturing process being the higher layer; obtaining inspection items and inspection results from said inspection results data using the product number and lot number of the lot tracing information as keys, creating aggregated data of the inspection results for each inspection item, and in this case, for the inspection results of overlapping inspection items, including an inspection result aggregation step of adopting the inspection result of a process that is higher in the downstream layer.

8. An inspection record management program to be executed by an information processing device having a control unit, The control unit is Order history data including customers, delivery destinations, quotation recipients, product numbers, and order quantities, Shipping performance data including customers, delivery destinations, quotation recipients, product numbers, lot numbers, and shipment quantities, Production performance data including part numbers and lot numbers of input items including raw materials, and part numbers and lot numbers of finished products manufactured using the input items, which are input in each manufacturing process; The inspection results for the products manufactured in each manufacturing process include product numbers, inspection patterns, lot numbers, inspection items, inspection standards, and inspection results. is configured to be accessible to Executed in the control unit: an inspection results management program for executing an inspection results consolidation process that refers to the manufacturing results data, performs lot tracing on products having the product numbers of the products shipped in the shipping results data, obtains the product numbers and lot numbers of each manufacturing process, creates lot tracing information including the product numbers, layers, and lot numbers of products manufactured in each manufacturing process in order of higher layers, with the downstream side of the manufacturing process being the higher layer, obtains inspection items and inspection results from the inspection results data using the product numbers and lot numbers of the lot tracing information as keys, creates consolidated data of the inspection results for each inspection item, and in this case, adopts the inspection results of a downstream process with a higher layer for the inspection results of overlapping inspection items.

Images