Inspection result management device, inspection result management method, and inspection result 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 result management device, an inspection result management method, and an inspection result management program.

Background Art

[0002] For example, when manufacturing solder, inspections are performed in each manufacturing process. In this case, the inspection items are different in each manufacturing process, and since the lots are subdivided as the process proceeds to the next step, it is necessary to input the inspection results each time, resulting in a large input load and inconsistent data. Conventionally, as a system related to manufacturing inspection, for example, there is Patent Document 1.

Prior Art Documents

Patent Documents

[0003]

Patent Document 1

Summary of the Invention

Problems to be Solved by the Invention

[0004] However, with respect to the product number and lot number for which an inspection certificate of a product is to be issued, no description is made regarding performing lot traceability (traceback), acquiring and aggregating the inspection results for the generated product number and lot number, and obtaining accurate inspection results with a low work load.

[0005] The present invention has been made in view of the above, and an object of the present invention is to provide an inspection result management device, an inspection result management method, and an inspection result management program capable of performing lot traceability for the product number and lot number for which an inspection certificate of a product is to be issued, acquiring and aggregating the inspection results for the generated product number and lot number, and obtaining accurate inspection results with a low work load.

Means for Solving the Problems

[0006] In order to solve the above-described problems and achieve the object, the present invention is an inspection result management device including a control unit for managing inspection results in a manufacturing process of a product. The control unit is configured to be able to access order fulfillment data including customer, supplier, quotation destination, product number, and order quantity, shipment result data including customer, supplier, quotation destination, product number, lot number, and shipment quantity, manufacturing result data including the product number of input items including raw materials, their lot numbers, and the product number of manufactured products and their lot numbers input in each manufacturing process, and inspection result data which is inspection results for manufactured products manufactured in each manufacturing process and includes product number, inspection pattern, lot number, inspection item, inspection standard, and inspection result. The control unit refers to the manufacturing result data, performs lot tracing for the products of the shipped product numbers in the shipment result data, obtains the product numbers and lot numbers of each manufacturing process, and creates lot tracing information including the product number, hierarchy, and lot number of the manufactured products in each manufacturing process in the order of the upper hierarchy with the downstream side of the manufacturing process as the upper hierarchy. Using the product number and lot number of the lot tracing information as keys, the control unit obtains the inspection items and inspection results from the inspection result data, creates aggregated data of the inspection results for each inspection item, and includes inspection result aggregation means for adopting the inspection results of the process with a higher hierarchy in the downstream process for the inspection results of duplicate inspection items.

[0007] Further, according to one aspect of the present invention, the inspection items and inspection standards of the inspection result data may be internal standards.

[0008] Also, according to one aspect of the present invention, the order performance data includes the inspection report destination including the customer, the quotation recipient, or the delivery destination, and the control unit further includes a part number master in which a part number is associated with an external product standard pattern, an external product standard pattern, an inspection report destination including a customer, a quotation recipient, a delivery destination, or common, and an external standard including inspection items and inspection standards. It is configured to be accessible to the registered external product standard pattern master, and the external product standard pattern is obtained from the part number master using the part number of the order performance data as a key, and the external standard is obtained from the external product standard pattern master using the obtained external product standard pattern and the inspection report destination of the order performance data as keys. It is characterized by comprising inspection report output means for creating inspection report data based on the order performance data, the shipment data, the obtained external standard, and the aggregated data of the inspection results, and outputting an inspection report based on the inspection report data.

[0009] Also, according to one aspect of the present invention, when there is no data corresponding to the external product standard pattern master using the inspection report destination of the order performance data as a key, the inspection report output means may obtain an external standard in which the inspection report destinations are common from the external product standard pattern master.

[0010] Also, according to one aspect of the present invention, the order performance data includes an inspection report language, and the inspection report output means may output the inspection report in the inspection report language of the order performance data.

[0011] Also, according to one aspect of the present invention, the manufacturing process of the product may include a manufacturing process of solder.

[0012] In addition, in order to solve the above-described problems and achieve the object, the present invention provides an inspection result management method executed by an information processing apparatus including a control unit. The control unit is configured to be able to access order result data including a customer, a supplier, a quotation destination, a product number, and the number of orders received, shipment result data including a customer, a supplier, a quotation destination, a product number, a lot number, and the number of shipments, manufacturing result data including the product number of input items including raw materials, the lot number thereof, input in each manufacturing process, and the product number of manufactured products manufactured by the input items and the lot number thereof, and inspection result data which is the inspection result of manufactured products manufactured in each manufacturing process and includes a product number, an inspection pattern, a lot number, an inspection item, an inspection standard, and an inspection result. In the control unit, with reference to the manufacturing result data, lot tracing is performed for the products of the product numbers shipped in the shipment result data, the product number and lot number of each manufacturing process are acquired, and lot tracing information including the product number, hierarchy, and lot number of the manufactured products of each manufacturing process is created in the order of the upper hierarchy with the downstream side of the manufacturing process as the upper hierarchy. Using the product number and lot number of the lot tracing information as keys, the inspection item and inspection result are acquired from the inspection result data, and aggregated data of the inspection results for each inspection item is created. At this time, for the inspection results of duplicate inspection items, an inspection result aggregation step of adopting the inspection result of the process with a higher hierarchy in the downstream process is included.

[0013] Also, in order to solve the above-described problems and achieve the object, the present invention is an inspection result management program for execution by an information processing apparatus including a control unit, wherein the control unit is capable of accessing order fulfillment data including customer, supplier, quotation destination, product number, and order quantity, shipment result data including customer, supplier, quotation destination, product number, lot number, and shipment quantity, manufacturing result data including the product number of input items including raw materials, their lot numbers, and the product number of manufactured products and their lot numbers input in each manufacturing process, and inspection result data for manufactured products manufactured in each manufacturing process, including product number, inspection pattern, lot number, inspection item, inspection standard, and inspection result. In the control unit, with reference to the manufacturing result data, for the products of the product numbers shipped in the shipment result data, lot tracing is performed to obtain the product numbers and lot numbers of each manufacturing process, and lot tracing information including the product number, hierarchy, and lot number of the manufactured products of each manufacturing process is created in the order of the upper hierarchy with the downstream side of the manufacturing process as the upper hierarchy. Using the product number and lot number of the lot tracing information as keys, the inspection items and inspection results are obtained from the inspection result data, and aggregated data of the inspection results for each inspection item is created. At this time, for the inspection results of duplicate inspection items, an inspection result aggregation process is executed to adopt the inspection results of the process with a higher hierarchy in the downstream process. The inspection result management program is characterized by this.

Effect of the Invention

[0014] According to the present invention, lot tracing is performed on the product number and lot number that are the issuance targets of the product inspection certificate, and the inspection results for the generated product number and lot number are obtained and aggregated, so that it is possible to obtain accurate inspection results with a low workload.

Brief Description of the Drawings

[0015]

Figure 1

Figure 2

Figure 3

Figure 4

Figure 5

Figure 6

Figure 7

Figure 8

Figure 9

Figure 10

Figure 11

Figure 12

Figure 13

Figure 14

Figure 15

Figure 16

Figure 17

[0016] Embodiments of the present invention will be described in detail with reference to the drawings. Note that the present invention is not limited to these embodiments.

[0017] [1. Overview] The overview of the present embodiment will be described in the order of (Background and Problems), (Focus), (Functional Overview of the Present Embodiment), and (Effects of the Present Embodiment).

[0018] (Background and Problems) For example, when manufacturing solder, there are the following background and problems. (1) The inspection items are different in each manufacturing process, and as the process proceeds to the next process, the lot is subdivided. Since the inspection result form requires inspection result data for the final product, it is necessary to register the inspection results for the subdivided lots. Therefore, this is a task that involves a lot of input effort and has a high possibility of data inconsistency.

[0019] (2) In each manufacturing process, inspection result management is required according to in-house standards, and the inspection result form needs to be issued in the language for each destination and according to external standards. In the process of the final product targeted by the inspection result form, inspection result management according to external standards is required, so inspection result management according to in-house standards cannot be performed. The content of inspection result management includes, for example, the management of the blending ratio of metal components for raw materials and the management of the content for auxiliary raw materials.

[0020] (Focus) FIG. 1 shows an image of the solder manufacturing process. (A) shows an example in the case of coil-type or bar solder, and (B) shows an example in the case of solder paste.

[0021] In the case of coil type or bar solder, as shown in Fig. 1(A), (1) in the compounding process, raw materials of a plurality of metals are compounded to produce a billet, (2) in the extrusion process, extrusion is performed, (3) in the wire drawing process, wire drawing is performed, and (4) in the winding and cutting process, it is molded according to the shape.

[0022] In the case of solder paste, (1) in the spraying process, raw materials of a plurality of metals are compounded and atomized, (2) in the classification process, it is sieved to be below a predetermined particle size, and (3) in the kneading process, it is made into a uniformly mixed state.

[0023] In this embodiment, attention was paid to the following two points. (1) In the compounding and spraying processes, the raw materials of the metals are compounded, and in the subsequent processes, the shape is changed, so the metal components (mixing ratio) do not change. In the wire drawing and classification processes, additional input of auxiliary raw materials other than metals such as flux is performed. The inspection results managed in the above processes are aggregated into an inspection report.

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

[0025] (Functional outline of this embodiment) (1) When issuing an inspection report, lot traceability (trace back) is performed based on the target part number and lot number, and for the generated lot number, the inspection results are obtained and aggregated. In this case, as a prerequisite, the lot number is unique.

[0026] (2) According to the external standards, the inspection results in (1) are obtained. When performing trace back, the hierarchy (the hierarchy of the final product = 0, the downstream side of the manufacturing process is the upper hierarchy, and the hierarchy of the final product = 0 is the top hierarchy) is counted. When there are duplicate results for the inspection items, the inspection results with a younger hierarchy (upper hierarchy) are adopted.

[0027] (Effects of this embodiment) (1) When issuing an inspection report, it is necessary to conduct product inspections, but duplicate operations can be improved. Also, the risk of registering inconsistent data can be reduced. (2) Conduct inspection result management against in-house standards. Since in-house standards are set more strictly than external standards, the accuracy of inspection result management can be further improved.

[0028] The inspection result management device of this embodiment can be widely applied in industries and business types where there is compounding + processing in the manufacturing process, for example, industries and business types that require quality control by components such as the solder industry and the chemical industry.

[0029] [2. Configuration] With reference to FIG. 2, an example of the configuration of the inspection result management device 100 according to this embodiment will be described. FIG. 2 is a block diagram showing an example of the configuration of the inspection result management device 100. The inspection result management device 100 of this embodiment can be applied to the inspection result management of, for example, solder manufacturing, and can also be applied to the manufacturing of other products.

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

[0031] The inspection result management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part included in the inspection result management device 100 is communicably connected via an arbitrary communication path.

[0032] The communication interface unit 104 communicably connects the inspection result management device 100 to the 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 a communication line. Here, the network 300 has a function of communicably connecting the inspection result management device 100 and the server 200 to each other, and is, for example, the Internet or a LAN (Local Area Network).

[0033] An input / output interface unit 108 has an input device 112 and an output device 114 connected thereto. As the output device 114, in addition to a monitor (including a home television), a speaker or a printer can be used. As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. Hereinafter, the output device 114 may be described as the monitor 114, and the input device 112 may be described as the keyboard 112 or the mouse 112. Further, displaying information on the monitor 114 and the user operating the input device 112, etc. may be described as "user operation via the UI".

[0034] The storage unit 106 stores various databases, tables, files, etc. The storage unit 106 records a computer program for giving instructions to the CPU (Central Processing Unit) to perform various processes in cooperation with the OS (Operating System). As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, etc. can be used. The storage unit 106 stores the item number master 106a, the external product specification pattern master 106b, the order receiving performance data, the shipping performance data, the lot details, the manufacturing performance data, the inspection performance data, the inspection report data, etc. FIG. 3 is a diagram showing a data correlation diagram of the item number master 106a, the external product specification pattern master 106b, the order receiving performance data, the shipping performance data, the lot details, the manufacturing performance data, the inspection performance data, the inspection report data, etc.

[0035] The item number master 106a can be composed of a table or the like that registers by associating the item number and the external product specification pattern. "External product specification" is also called "off - company specification".

[0036] The external product specification pattern master 106b can be composed of a table or the like that registers by associating the external product specification pattern, the inspection report destination, the customer CD, the off - company specification (inspection items, number of digits after the decimal point, inspection standards).

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

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

[0039] Lot detail data may include the product number code, product number, lot number, manufacturing date, and expiration date.

[0040] Manufacturing performance data may include, for each manufacturing process, the product number (raw materials, sub-raw materials, materials, sub-materials, work-in-progress) of the input items and their lot numbers, and the product number (work-in-progress, final product) of the manufactured items produced by the input items and their lot numbers.

[0041] Inspection performance data may include inspection header data (inspection No), inspection detail data (product number, inspection pattern code, lot number), and inspection detailed data (inspection items, number of decimal places, inspection standards, inspection results). Here, the inspection items, number of decimal places, and inspection standards use in-house standards. Since the in-house standards are stricter than the external standards, the inspection performance can be precisely managed.

[0042] Inspection certificate data may include the order number, customer, consignee, quotation recipient, product number code, product number, inspection certificate recipient, inspection certificate language, shipment number, shipment date, shipment quantity, lot number, manufacturing date, expiration date, external standards (inspection items, number of decimal places, inspection standards), and inspection results.

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

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

[0045] Functionally conceptually, the control unit 102 includes an order receiving input unit 102a, a shipping 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 receiving input unit 102a inputs and registers the order receiving performance data in the storage unit 106 in response to an operator's operation on an order receiving input screen (not shown) displayed on the monitor 114, for example.

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

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

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

[0050] The inspection result aggregation unit 102e refers to the manufacturing performance data, performs lot tracing for the products with the item numbers to be shipped in the shipping performance data, obtains the item numbers and lot numbers of each manufacturing process, and creates lot tracing information including the item numbers, hierarchies, and lot numbers of the manufactured products in each manufacturing process in the order of the upper hierarchies with the downstream side of the manufacturing process as the upper hierarchy. Using the item number and lot number of the lot tracing information as keys, it obtains the inspection items and inspection results from the inspection performance data, creates aggregated data of the inspection results for each inspection item. At this time, for the inspection results of duplicate inspection items, it adopts the inspection results of the process with a higher hierarchy in the downstream process.

[0051] The inspection report output unit 102f obtains the external product specification pattern from the item number master 106a using the item number of the order fulfillment performance data as a key, and obtains the external specifications from the external product specification pattern master 106b using the obtained external product specification pattern and the inspection report destination of the order fulfillment performance data as keys. Based on the order fulfillment performance data, shipping data, the obtained external specifications, and the aggregated data of the inspection results, it creates inspection report data, registers it in the storage unit 106, and outputs (print output and / or display output) an inspection report based on the inspection report data.

[0052] When there is no data corresponding to the inspection report destination of the order fulfillment performance data in the external product specification pattern master 106b, the inspection report output unit 102f may obtain the external specifications 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 fulfillment performance data.

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

[0055] The master maintenance unit 102h performs settings such as data input, addition, modification, and update on the item number master 106a and the external product standard pattern master 106b according to, for example, the operations of the operator on a master maintenance screen (not shown) displayed on the monitor 114.

[0056] [3. Specific Example] With reference to FIGS. 2 to 17, a specific example of the processing of the control unit 102 of the inspection result management apparatus 100 in the present embodiment will be described.

[0057] (3-1. Overall Processing) FIG. 4 is a diagram showing a flow for explaining the outline of the overall processing of the control unit 102 of the inspection result management apparatus 100 in the present embodiment. With reference to FIG. 4, the outline of the overall processing of the control unit 102 of the inspection result management apparatus 100 in the present embodiment will be described.

[0058] In FIG. 4, first, an order for manufacturing a product is received. 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 result data according to the operation of the operator on an order input screen (not shown) displayed on the monitor 114, for example, and registers it in the storage unit 106.

[0059] For the ordered product, manufacturing is performed in each manufacturing process. The manufacturing result input unit 102c executes a manufacturing result input process (step S2). Specifically, in the manufacturing result input process, for each manufacturing process, the manufacturing result input unit 102c inputs manufacturing result data according to the operation of the operator on a manufacturing result input screen (not shown) displayed on the monitor 114, for example, and registers it in the storage unit 106.

[0060] For the products manufactured in each manufacturing process, inspections are carried out on 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 in response to an operator's operation on an inspection result input screen (not shown) displayed on the monitor 114 for the products manufactured in each manufacturing process, and registers it in the storage unit 106.

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

[0062] When shipping, an inspection certificate is required. First, the inspection result aggregation unit 102e executes an inspection result aggregation process (step S5). Specifically, in the inspection result aggregation process, the inspection result aggregation unit 102e refers to the manufacturing result data, performs lot tracing for the products of the item numbers to be shipped in the shipping result data, obtains the item numbers and lot numbers of each manufacturing process, creates lot tracing information including the item numbers, hierarchies, and lot numbers of the manufactured products in each manufacturing process in the order of the upper hierarchies with the downstream side of the manufacturing process as the upper hierarchy, obtains the inspection items and inspection results from the inspection result data using the item numbers and lot numbers of the lot tracing information as keys, creates aggregated data of the inspection results for each inspection item, and in that case, for the inspection results of duplicate inspection items, adopts the inspection results of the process with a higher hierarchy in the downstream process.

[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 in the order fulfillment data as the key, and the customer, delivery destination, or quotation destination specified in the inspection report destination of the order fulfillment data are used as keys to obtain the external specifications (inspection items, number of digits after the decimal point, inspection specifications) from the external product specification pattern master 106b. If the data cannot be obtained, the data for the common destination is retrieved again.

[0068] Figure 6(A) is an example of a pattern where the inspection report destination is specified. For example, the external product specification pattern is "S00001", the inspection report destination is "quotation destination", and the trading partner CD is "quotation destination C". For the inspection item "A", the number of digits after the decimal point is "3", the inspection specification is "75.000~85.000"; for the inspection item "B", the number of digits after the decimal point is "1", the inspection specification is "8.0~12.0"; for the inspection item "C", the number of digits after the decimal point is "3", the inspection specification is "~10.000"; for the inspection item "D", the number of digits after the decimal point is "3", the inspection specification is "~10.000"; for the inspection item "E", the number of digits after the decimal point is "4", the inspection specification is "24.0750~25.0250". For example, if the inspection report destination of the order fulfillment data is specified as the quotation destination, this data is obtained using the quotation destination as the 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 trading partner CD is "-". For the inspection item "A", the number of digits after the decimal point is "3", the inspection specification is "75.000~85.000"; for the inspection item "B", the number of digits after the decimal point is "1", the inspection specification is "8.0~12.0"; for the inspection item "C", the number of digits after the decimal point is "2", the inspection specification is "~10.00"; for the inspection item "E", the number of digits after the decimal point is "4", the inspection specification is "20.000~30.0000". If the data could not be obtained as described above, this data is obtained.

[0070] (Data Information) FIG. 7 is a diagram showing a data example of order reception performance data. The order reception performance data includes order reception header data (order number, customer, consignee, quotation source) and order reception detail data (item number code, item number, inspection certificate destination, inspection certificate, language). In the example shown in the figure, the order number is "J0001", the customer is "Customer A", the consignee is "Consignee B", the quotation source is "Quotation Source C", the item number code is "S001", the item number is "Product 001", the inspection certificate destination is "Consignee", and the inspection certificate language is "Japanese".

[0071] FIG. 8 is a diagram showing examples of shipment performance data and lot detail data. The shipment performance data includes shipment header data (shipment number, order number, customer, consignee, quotation source), shipment detail data (item number code, item number, shipment date), and shipment detail data (quantity shipped, lot number). In the example shown in the figure, the shipment number is "S0001", the order number is "J0001", the customer is "Customer A", the consignee is "Consignee B", the quotation source is "Quotation Source C", the item number code is "S001", the item number is "Product 001", the shipment date is "2023 / 03 / 20", the quantity shipped is "100.000 kg", and the lot number is "0000111123".

[0072] The lot detail data includes item number code, item number, lot number, manufacturing date, and expiration date. In the lot detail data, information on the manufacturing date and expiration date is retained for each item number and each lot number by registering vouchers for each manufacturing performance input. In the example shown in the figure, the item number code is "S001", the item 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: Inspection Result Aggregation Process) With reference to FIGS. 9 to 13, a specific example of the inspection result aggregation process will be described. An inspection result certificate is issued for the shipment performance data, and prior to that, the inspection result aggregation process is executed. The inspection result aggregation unit 102e refers to the production performance data, lot-traces the products of the item numbers to be shipped in the shipment performance data, obtains the item numbers and lot numbers of each manufacturing process, creates lot-trace information including the item numbers, hierarchies, and lot numbers of the manufactured products in each manufacturing process in the order of the upper hierarchies with the downstream side of the manufacturing process as the upper hierarchy, associates the lot-trace information with the inspection performance data of each manufacturing process, creates aggregated data of the inspection results for each inspection item, and in this case, for the inspection results of duplicate inspection items, adopts the inspection results of the process with the higher hierarchy in the downstream process.

[0074] (1) Refer to the production performance data, lot-trace the item numbers of the products to be shipped in the shipment performance data, obtain the item numbers and lot numbers of each manufacturing process, and create lot-trace information.

[0075] FIGS. 9(A) to 9(D) show examples of production performance data for the compounding process (inputting flux, etc.), large wire drawing process, and winding process (inputting bobbins for coils and packing cases). FIG. 9(E) is a diagram showing an example of lot-trace information. In the following example, the case of creating the lot-trace information for the item number "Product 001" in the shipment performance data of FIG. 8 will be described.

[0076] As shown in FIGS. 9(A) to (D), the production performance data includes, for each manufacturing process, the item numbers (raw materials, sub-raw materials, materials, sub-materials, work-in-progress) and lot numbers of the input items, and the item numbers (work-in-progress, final products) and lot numbers of the manufactured products produced by the input items.

[0077] As shown in FIG. 9(A), the production performance data in the compounding process is (manufactured product) item number: Work-in-progress 101, lot number: 0000100023, (input item) item number: Raw material 001, lot number: 0003950123, ···

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

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

[0080] As shown in Fig. 9(D), the manufacturing performance data in the winding process is as follows: (manufactured product) part number: product 001, lot number: 0000111023, (input products) part number: work-in-progress 301, lot number: 0000110023, part number: sub-material 001, part number: sub-material 002.

[0081] Regarding the part number "product 001" of the shipping performance data, the manufacturing performance data in Figs. 9(A) to (D) is lot traced to obtain the part numbers and lot numbers of each manufacturing process. Taking the downstream side of the manufacturing process as the upper hierarchy, lot trace information including the part numbers, hierarchy, and lot numbers of the manufactured products in each manufacturing process is created in the order of the upper hierarchy. Note that in lot tracing, all actual performance (receipt and payment) system information such as manufacturing performance, purchase performance, shipping returns, automatic movement, and inventory count performance is obtained.

[0082] Fig. 9(E) shows an example of the created lot trace information. The lot trace information is a hierarchical structure of the manufactured products and input products in each manufacturing process, and has items of composition (part numbers of the manufactured products and input products in each manufacturing process), hierarchy, and lot number. In the example shown in the figure, the topmost hierarchy is the product 001 of the shipped product, with a hierarchy of "0" and a lot number of "0000111023". The bottommost hierarchy is the raw material 001, with a hierarchy of "4" and a lot number of "0003950123".

[0083] FIG. 10 is a diagram for explaining the numbering rule of lot numbers. The lot numbers are automatically numbered. The lot numbers are, for example, 10 digits in total. The upper 5 digits are consecutive serial numbers. The middle 3 digits are incremented for each process. In the product number master 106a, the number of digits to be counted is specified. The target is the first lot in the first row of the shipped items. The lower 2 digits are the last 2 digits of the AD year of the manufacturing start date. An example of lot numbering for coil type and bar solder, and an example of lot numbering for solder paste are illustrated.

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

[0085] With reference to FIGS. 11 to 13, the linking of the lot trace information and the inspection result data will be described. The lot trace 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 result data of the winding process. The inspection result data includes inspection header data (inspection No), inspection detail data (product number, inspection pattern code, lot number), and inspection detailed data (inspection item, number of digits after the decimal point, standard, inspection result).

[0087] In the example shown in the figure, the inspection No is "003", the product number is "Product 001", the inspection pattern code is "00001", the lot number is "0000111123", the inspection item is "E", the number of digits after the decimal point is "4", the standard is "24.0750 to 25.0250", and the inspection result is "25.1000".

[0088] Using the product number "Product 001" and the lot number "0000111123" in the lot trace information as keys, the inspection item "E" and the inspection result "25.1000" are acquired from the inspection result data of the winding process.

[0089] Fig. 12(A) shows lot trace information, and Fig. 12(B) shows an example of inspection result data for the small wire drawing process. In the example shown in the figure, the inspection No is "002", the part number is "Work in process 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 standard is "24.0750 to 25.0250", and the inspection result is "25.1250".

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

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

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

[0093] As shown in Fig. 13(C), for each inspection item, the inspection items and inspection results obtained above are aggregated by hierarchy. As shown in Fig. 13(D), for the inspection results of duplicate inspection items, the ones in the upper hierarchy of the downstream process are adopted. In this example, for the inspection item "E", since the inspection result "25.1250" in hierarchy "1" and the inspection result "25.1000" in hierarchy "0" are duplicated, the inspection result "25.1000" in the upper hierarchy "0" of the downstream process is adopted.

[0094] (S6: Inspection Report Output Process) With reference to Figs. 14 to 17, a specific example of the inspection report output process will be described. The inspection report output unit 102f acquires the external product specification pattern from the product number master 106a using the product number of the order fulfillment actual data as a key, and acquires the external product specification (inspection item, number of digits after the decimal point, inspection standard) from the external product specification pattern master 106b using the acquired external product specification pattern and the customer, supplier, or quotation destination specified in the inspection report destination of the order fulfillment actual data as keys. If there is no corresponding one using the customer, supplier, or quotation destination specified in the inspection report destination of the order fulfillment actual data as a key, the external product specification (inspection item, number of digits after the decimal point, inspection standard) with the destination being "common" is acquired from the external product specification pattern master 106b.

[0095] Fig. 14(A) is an example of a pattern in the external product specification pattern master 106b where the "destination" is specified as "quotation destination", and Fig. 14(B) is an example of a pattern where the "destination" is specified as "common".

[0096] Using the product number "Product 001" of the order fulfillment actual data in Fig. 7 as a key, the external product specification pattern "S0001" is acquired from the product number master 106a in Fig. 5, and the off-site specification (inspection item, number of digits after the decimal point, inspection standard) is acquired from the external product specification pattern master 106b using the external product specification pattern "S0001" and the inspection report destination "supplier" of the order fulfillment actual data in Fig. 7 as keys. In the pattern of the external product specification pattern master 106b in Fig. 14(A), since the destination is "quotation destination" and it does not match, the off-site specification is acquired from Fig. 14(B) where the destination is "common".

[0097] The inspection result report output unit 102f creates inspection result report data based on the order receipt performance data, the shipping data, the lot detail data, the external product standard (inspection items, number of digits after the decimal point, inspection standard) obtained from the external product standard pattern master 106b, and the aggregated data of the inspection results.

[0098] FIG. 15 is a diagram showing an example of inspection result report data. The inspection result report data includes order receipt number, customer, consignee, quotation destination, item code, item name, inspection result report destination, inspection result report language, shipping number, shipping date, quantity shipped, lot number, manufacturing date, expiration date, external product standard (inspection items, number of digits after the decimal point, inspection standard), and inspection result items. Regarding the inspection result, when there is an overflow in the number of digits after the decimal point, rounding processing (rounding) may be performed.

[0099] The inspection result report output unit 102f outputs an inspection result report based on the inspection result report data in the "inspection result report language" of the order receipt performance data. FIG. 16 shows an example of an inspection result report in Japanese. FIG. 17 shows an example of an inspection result report in English. The inspection result report may be in the form of a form, such as an Excel form. For example, template Excel data may be obtained and the acquired data may be set in the specified cells. By using an Excel form, it is possible to respond to layout changes and layout additions and consider scalability.

[0100] As described above, with reference to the manufacturing performance data, for the products with the item numbers to be shipped in the shipping performance data, lot tracing is performed to obtain the item numbers and lot numbers of each manufacturing process. Taking the downstream side of the manufacturing process as the upper hierarchy, in the order of the upper hierarchy, lot tracing information including the item numbers, hierarchies, and lot numbers of the manufactured products of each manufacturing process is created. Using the item numbers and lot numbers of the lot tracing information as keys, inspection items and inspection results are obtained from the inspection performance data, and aggregated data of the inspection results for each inspection item is created. At this time, for the inspection results of duplicate inspection items, the inspection result of the process with a higher hierarchy in the downstream process is adopted. Since the inspection result aggregation unit 102e is provided, lot tracing is performed for the item numbers and lot numbers that are the issuance targets of the product inspection certificates, and the inspection performance for the generated item numbers and lot numbers is obtained and aggregated, making it possible to obtain accurate inspection performance with a low workload.

[0101] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] According to this embodiment, it is possible to contribute to promoting business efficiency and appropriate business judgment of the enterprise, so it is possible to contribute to Goals 8 and 9 of the SDGs.

[0102] Also, according to this embodiment, it is possible to contribute to reducing waste loss and promoting paperless and digitization, so it is possible to contribute to Goals 12, 13, and 15 of the SDGs.

[0103] Also, according to this embodiment, it is possible to contribute to strengthening control and governance, so it is possible to contribute to Goal 16 of the SDGs.

[0104] [5. Other Embodiments] The present invention may be implemented in various different embodiments within the scope of the technical idea described in the claims, in addition to the above-described embodiments.

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

[0106] In addition, regarding 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 the drawings, they can be arbitrarily changed unless otherwise specified.

[0107] Regarding the inspection result management device 100, each illustrated component is a functional concept and does not necessarily have to be physically configured as shown in the drawings.

[0108] For example, regarding the processing functions provided by the inspection result management device 100, particularly each processing function performed by the control unit, all or any part of them may be realized by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware by wired logic. Note that the program is recorded on a non-transitory computer-readable recording medium including programmed instructions for causing an information processing device to execute the processes described in this embodiment, and is mechanically read by the inspection result management device 100 as necessary. That is, in a storage unit such as a ROM or an HDD (Hard Disk Drive), a computer program for giving commands to the CPU in cooperation with the OS to perform various processes is recorded. This computer program is executed by being loaded into the 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 result management device 100 via an arbitrary network, and all or part of it can be downloaded as necessary.

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

[0111] Also, the "program" is a data processing method described in any language or description method, and is not limited to a specific form such as source code or binary code. Note that the "program" is not necessarily limited to being configured singly, and also includes those that are distributed as a plurality of modules or libraries, or those that achieve their functions in cooperation with other separate programs represented by an OS. Note that for the specific configuration, reading procedure, and installation procedure after reading for reading the recording medium in each device shown in the embodiment, well-known configurations and procedures can be used.

[0112] The various databases and the like stored in the storage unit are storage means such as a memory device such as a RAM or a ROM, a fixed disk device such as a hard disk, a flexible disk, and an optical disk, and store various programs, tables, databases, and web page files used for various processes and website provision.

[0113] Further, the inspection result management device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. Further, the inspection result management device 100 may be realized by installing software (including programs or data, etc.) for realizing the processes described in this embodiment in the device.

[0114] Furthermore, the specific form of the 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 arbitrary units according to various additions or according to the functional load. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

Explanation of Signs

[0115] 100 Inspection result management device 102 Control unit 102a Receiving input unit 102b Shipping input unit 102c Manufacturing result input unit 102d Inspection result input unit 102e Inspection result aggregation unit 102f Inspection report output unit 102g Screen display control unit 102h Master maintenance unit 104 Communication interface unit 106 Storage unit 106a Part number master 106b External product specification pattern master 108 Input / output interface unit 112 Input device 114 Output device 200 Server 300 Network

Claims

1. An inspection result management device that includes a control unit and manages inspection results in the manufacturing process of products, wherein the control unit is configured to be able to access order fulfillment data including customer, supplier, quotation recipient, product number, and order quantity, shipment result data including customer, supplier, quotation recipient, product number, lot number, and shipment quantity, manufacturing result data including the product number of input items including raw materials, their lot numbers, the product number of manufactured products produced by the input items, and their lot numbers, which are input in each manufacturing process, inspection result data that is the inspection result of manufactured products manufactured in each manufacturing process and includes product number, inspection pattern, lot number, inspection item, inspection standard, and inspection result, and is configured to be able to access them, refer to the manufacturing result data, perform lot tracing for the products of the shipped product numbers in the shipment result data, obtain the product numbers and lot numbers of each manufacturing process, and create lot tracing information including the product number, hierarchy, and lot number of the manufactured products in each manufacturing process in the order of the upper hierarchy with the downstream side of the manufacturing process as the upper hierarchy. Using the product number and lot number of the lot tracing information as keys, obtain the inspection items and inspection results from the inspection result data, create aggregated data of the inspection results for each inspection item, and in this case, for the inspection results of duplicate inspection items, adopt the inspection results of the process with a higher hierarchy in the downstream process. An inspection result management device characterized by comprising inspection result aggregation means.

2. The inspection item and inspection standard of the inspection result data are internal company standards. The inspection result management device according to claim 1.

3. The order fulfillment data includes an inspection report destination including a customer, a quotation recipient, or a supplier, and the control unit further is configured to be able to access a product number master in which a product number is associated with an external product specification pattern and registered, and an external product specification pattern master in which an external product specification pattern is associated with an inspection report destination including a customer, a quotation recipient, a supplier, or common, and an external company standard including inspection items and inspection standards and registered, and is configured to be able to access them, Obtain the external product standard pattern from the product number master using the product number of the order receipt actual data as a key, and obtain the external standard from the external product standard pattern master using the obtained external product standard pattern and the inspection result notice destination of the order receipt actual data as keys. Based on the order receipt actual data, the shipment actual data, the obtained external standard, and the aggregated data of the inspection results, create inspection result notice data, and include inspection result notice output means for outputting an inspection result notice based on the inspection result notice data. The inspection result management device according to claim 1, characterized in that it has this.

4. When there is no data corresponding to the external product standard pattern master using the inspection result notice destination of the order receipt actual data as a key, the inspection result notice output means obtains an external standard with a common inspection result notice destination from the external product standard pattern master. The inspection result management device according to claim 3, characterized in that it does this.

5. The order receipt actual data includes the inspection result notice language. The inspection result notice output means outputs the inspection result notice in the inspection result notice language of the order receipt actual data. The inspection result management device according to claim 3, characterized in that it does this.

6. The manufacturing process of the product includes the manufacturing process of solder. The inspection result management device according to any one of claims 1 to 5, characterized in that it has this.

7. An inspection result management method executed by an information processing device equipped with a control unit, The control unit is Order receipt actual data including customer, delivery destination, quotation destination, product number, and order quantity, Shipment actual data including customer, delivery destination, quotation destination, product number, lot number, and shipment quantity, Manufacturing actual data including the product number of the input items including raw materials, its lot number, and the product number of the manufactured product manufactured by the input item, its lot number, input at each manufacturing process, Inspection result data for the manufactured products manufactured at each manufacturing process, including product number, inspection pattern, lot number, inspection item, inspection standard, and inspection result, Is configured to be accessible to, Executed in the control unit, With reference to the manufacturing performance data, perform lot tracing on the products with the item numbers shipped in the shipping performance data, obtain the item numbers and lot numbers of each manufacturing process, and create lot tracing information including the item numbers, hierarchies, and lot numbers of the manufactured products of each manufacturing process in the order of the upper hierarchies with the downstream side of the manufacturing process as the upper hierarchy. Using the item number and lot number of the lot tracing information as keys, obtain the inspection items and inspection results from the inspection performance data, and create aggregated data of the inspection results for each inspection item. In this case, for the inspection results of duplicate inspection items, an inspection result aggregation process that adopts the inspection results of the process with a higher hierarchy in the downstream process is included. A method for managing inspection performance characterized by this.

8. An inspection performance management program for execution by an information processing apparatus provided with a control unit, wherein the control unit is configured to be able to access order performance data including customer, supplier, quotation recipient, item number, and order quantity, shipping performance data including customer, supplier, quotation recipient, item number, lot number, and shipping quantity, manufacturing performance data including the item number of the input items including raw materials, its lot number, and the item number of the manufactured product produced by the input item and its lot number, which are input in each manufacturing process, inspection performance data which is the inspection result for the manufactured product manufactured in each manufacturing process and includes item number, inspection pattern, lot number, inspection item, inspection standard, and inspection result, and is configured to be accessible, and an inspection performance management program for executing, in the control unit, with reference to the manufacturing performance data, performing lot tracing on the products with the item numbers shipped in the shipping performance data, obtaining the item numbers and lot numbers of each manufacturing process, and creating lot tracing information including the item numbers, hierarchies, and lot numbers of the manufactured products of each manufacturing process in the order of the upper hierarchies with the downstream side of the manufacturing process as the upper hierarchy. Using the item number and lot number of the lot tracing information as keys, obtaining the inspection items and inspection results from the inspection performance data, and creating aggregated data of the inspection results for each inspection item. In this case, for the inspection results of duplicate inspection items, an inspection result aggregation process that adopts the inspection results of the process with a higher hierarchy in the downstream process.

Images