Material usage check device, material usage check method, and material usage check program

Abstract

To provide an applied material checking device, an applied material checking method and an applied material checking program capable of preventing the false selection of an applied material, contributing to the reduction of a waste production and the improvement of the delivery deadline observance rate, and contributing to SDGs by checking the performance of a material to be applied and the requested specification by a client when an instruction for processing is given and by limiting the material that can be applied to a product.SOLUTION: Order acceptance data that sets the destination of a product is obtained, and when an instruction for processing the product is set, and a determination result on a stocked and reserved material to the specification of the destination is obtained on the basis of a specification master, a customer-site composition specification master, stock data, material composition data, and the order acceptance data.SELECTED DRAWING: Figure 2

Description

[Technical Field]

[0001] The present invention relates to a material use check device, a material use check method, and a material use check program. [Background technology]

[0002] Patent Document 1 discloses a configuration in which an incoming material check is performed so that the material is received if the width, height, and length components of the material are within an allowable range when the material is received. [Prior art documents] [Patent documents]

[0003] [Patent Document 1] Japanese Patent Application Laid-Open No. 2002-293413 Summary of the Invention [Problem to be solved by the invention]

[0004] However, the invention described in Patent Document 1 above has a problem in that it is not possible to check whether the material can be used for the product when issuing a processing instruction.

[0005] The present invention has been made in consideration of the above-mentioned problems, and aims to provide a material use checking device, a material use checking method, and a material use checking program that can prevent mistakes in the selection of materials to be used by checking the performance of the materials to be used and the customer's required specifications at the time of issuing processing instructions, and by limiting the materials that can be used in the product, thereby contributing to reducing wasteful production and improving delivery deadline compliance rates, and also contributing to the SDGs. [Means for solving the problem]

[0006] In order to solve the above-mentioned problems and achieve the object, the material use check device of the present invention is a material use check device comprising a memory unit and a control unit, wherein the memory unit comprises: a specification master that links together product specification management, destination, and the product; a customer component standard master that links together the specification management of the product, inspection items for material components of materials, upper limits for the material components, and lower limits for the material components; inventory storage means that stores inventory data that links together the material type and manufacturer for each material; and material component storage means that stores material component data that links together the material type, manufacturer, inspection items for the material components, and actual values ​​for the material components for each material; and the control unit comprises: order acquisition means that acquires order data that sets the destination of the product, and material check means that, when a processing instruction for the product is set, acquires a judgment result for the specifications of the destination of the material that has been allocated to inventory, based on the specification master, the customer component standard master, the inventory data, the material component data, and the order data.

[0007] In addition, in the material usage checking device according to the present invention, the material checking means is characterized in that, when the processing instructions for the product are set, if the actual value of the material component is equal to or greater than the lower limit value of the material component and equal to or less than the upper limit value of the material component, based on the specification master, the customer component standard master, the inventory data, the material component data, and the order data, it obtains the determination result that the stock-allocated material meets the specifications of the destination.

[0008] In addition, in the material usage check device according to the present invention, the material check means is characterized in that, when the processing instruction in which the product and the specification management are set is set on a processing instruction input acceptance details screen, it obtains the judgment result for the specifications of the destination of the material allocated to inventory based on the specification master, the customer component standard master, the inventory data, the material component data, and the order data.

[0009] Furthermore, in the material usage check device according to the present invention, the memory unit further includes an allocable material type master that links and sets the destination, the product, the material type of the material, and the manufacturer, and the inventory data is further set and linked with a serial number for each material, and the material check means is further characterized in that, based on the allocable material type master, the inventory data, and the order data, if the manufacturer or the serial number is set correctly in the inventory data, it obtains the determination result that the stock-allocated material meets the specifications of the destination.

[0010] In addition, in the material usage check device according to the present invention, the memory unit further includes an allocable material type master that is set by linking the destination, the product, the material type of the material, and the manufacturer, and the material check means is further characterized in that, based on the allocable material type master, the specification master, the inventory data, and the order data, if the material type set in the inventory data and the manufacturer satisfy the specifications of the destination, it obtains the determination result that the stock-allocated material satisfies the specifications of the destination.

[0011] Furthermore, in the material usage check device according to the present invention, the inventory data is further set in association with a manufacturing number for each material, and the material check means is further characterized in that, based on the inventory data, the material composition data, and the order data, if the material type, the manufacturing number, and the manufacturer set in the inventory data match the material type, the manufacturing number, and the manufacturer set in the material composition data, it obtains the determination result that the allocated material meets the specifications of the destination.

[0012] In addition, in the material usage check device according to the present invention, the memory unit further comprises an inspection item master in which inspection items for the material components are set, and the control unit further comprises a purchase acquisition means for acquiring material purchase data in which the manufacturer's mill sheet is set, and a material component acquisition means for acquiring the material component data based on the inspection item master and the material purchase data.

[0013] In the material usage checking device according to the present invention, the serial number is a charge number.

[0014] Furthermore, in the material usage check device according to the present invention, the inventory data is further set in association with the lot number of the material, and the material check means, when a processing instruction for the product for which the lot number is set, acquires the judgment result for the specifications of the destination of the material with the lot number that has been allocated to inventory based on the specification master, the customer component standard master, the inventory data, the material component data, and the order data.

[0015] a customer component standard master that links together the specification management of the product, the inspection items for the material components of the material, the upper limit values ​​of the material components, and the lower limit values ​​of the material components; an inventory storage means that stores inventory data that links together the material type and manufacturer for each material; and a material component storage means that stores material component data that links together the material type, the manufacturer, the inspection items for the material components, and the actual values ​​of the material components for each material; and the control unit executes an order acquisition step of acquiring order data that sets the destination of the product, and a material check step of acquiring a judgment result for the destination specifications of the material allocated to the inventory based on the specification master, the customer component standard master, the inventory data, the material component data, and the order data when a processing instruction for the product is set.

[0016] a customer component standard master that links together the specification management of the product, the inspection items for the material components of the material, the upper limit values ​​of the material components, and the lower limit values ​​of the material components; an inventory storage means that stores inventory data that links together the material type and manufacturer for each material; and a material component storage means that stores material component data that links together the material type, the manufacturer, the inspection items for the material components, and the actual values ​​of the material components for each material; and the control unit executes an order acquisition step of acquiring order data that sets the destination of the product, and a material check step of acquiring, when a processing instruction for the product is set, a judgment result for the destination specification of the material allocated to inventory based on the specification master, the customer component standard master, the inventory data, the material component data, and the order data. [Effects of the Invention]

[0017] The present invention has the advantage of enabling material composition checks at the processing instruction stage, when selecting materials to be used, among the inspection items for material composition characteristics and mechanical properties. The present invention also has the advantage of supporting IATF 16949 certification by establishing business processes. The present invention also has the advantage of enabling checks on designated materials using composition inspection data for allocated materials. The present invention also has the advantage of adding lot search and other functions to material composition checks. The present invention also has the advantage of improving yield and productivity, which represents added value relative to input, by determining whether a material meets customer specifications from the time of material selection, rather than at the time of product completion. The present invention also has the advantage of being applicable to businesses such as electrical steel sheets, which have strong material properties and are required to reduce CO2 emissions. The present invention also has the advantage of preventing transactional issues such as reworking and delivery delays due to reworking, as well as the burden on the work department, by checking materials to be used according to customer requirements. Furthermore, the present invention can suppress the loss of materials due to incorrect processing and the increase in costs due to the disposal of finished products, and the reduction in loss also contributes to the protection of the global environment. [Brief explanation of the drawings]

[0018] [Figure 1] FIG. 1 is a diagram showing an example of the material use check process in this embodiment. [Figure 2] FIG. 2 is a block diagram showing an example of the configuration of the material use check device according to this embodiment. [Figure 3] FIG. 3 is a diagram showing an example of a master in this embodiment. [Figure 4] FIG. 4 is a flowchart showing an example of processing performed by the material use check device in this embodiment. [Figure 5] FIG. 5 is a diagram showing an example of the material use check process in this embodiment. [Figure 6]FIG. 6 is a diagram showing an example of the material use check process in this embodiment. [Figure 7] FIG. 7 is a diagram showing an example of the material use check process in this embodiment. [Figure 8] FIG. 8 is a diagram showing an example of the material use check process in this embodiment. [Figure 9] FIG. 9 is a diagram showing an example of the material use check process in this embodiment. [Figure 10] FIG. 10 is a diagram showing an example of a processing instruction input screen in this embodiment. DETAILED DESCRIPTION OF THE INVENTION

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

[0020] [1. Overview] First, an overview of the present invention will be described with reference to Fig. 1. Fig. 1 is a diagram showing an example of a material use check process in this embodiment.

[0021] In response to quality fraud issues in the steel industry and other sectors, processing manufacturers are being asked to implement thorough quality control.

[0022] Traditionally, material component properties (e.g., component values ​​other than Fe) and the mechanical properties of processed products (e.g., tensile strength, hardness, etc.) have been checked to ensure they meet customer specifications. For convenience, these checks were conducted at the time of shipment using inspection reports (mill sheets). Therefore, in the past, if a product failed due to a material issue, problems such as delivery delays and production losses due to remanufacturing occurred due to the timing of the checks. Furthermore, while checking whether the finished product met customer requirements at the time of shipment helped prevent problems due to incorrect shipments, it was necessary to select or manufacture inventory that met the requirements.

[0023] Therefore, in this embodiment, unlike conventional methods, the object of judgment is the material that constitutes the finished product, and the timing of judgment is at the time of processing instruction, and a mechanism is provided to check whether the material to be used at the time of processing instruction meets the component performance specifications required by the customer.

[0024] That is, in this embodiment, an inspection item master is created in which inspection items can be registered, a check category of whether or not to check material components is set in the specification master for each product (material), a material component input function and a material component import function are created in which material inspection data can be registered, a customer component standard master is created in which inspection standards (upper limit, lower limit) can be registered for each customer, destination, product, and inspection item, and when material data is entered in the delivery details of processing instruction input and when a slip is registered, the material component data and customer component standard data are checked by referring to the destination (end user), product, and material data held in the specification master.

[0025] For example, as shown in FIG. 1 , in this embodiment, when material data is entered in the dispensing details of the processing instruction input or when a slip is registered, a check is made to see if the material properties (component data) meet the customer specifications. Here, in this embodiment, the specification master for the product's specification control number is referenced. If the "test report issuance category = 0: not required" or the "component printing category = 0: not required," only a check may be made to see if the material type is registered in the allocable material master. That is, in this embodiment, if the "test report issuance category = 1: required" and the "component printing category = 1: required," checks are made in order, starting with (1), to see if there are any errors in the material registration, (2) whether the material type is allocable, (3) whether the material composition has been entered, and (4) whether the component inspection data for the allocated material is outside the specification value range of the customer component specification master. If even one item meets the "error condition," an error is declared, and the error check may end at the point in time when an error is detected.

[0026] [2. Configuration] An example of the configuration of the material usage check device 100 according to this embodiment will be described with reference to Fig. 2 and Fig. 3. Fig. 2 is a block diagram showing an example of the configuration of the material usage check device 100 according to this embodiment. Fig. 3 is a diagram showing an example of a master according to this embodiment.

[0027] 2, the material usage check device 100 is a commercially available desktop personal computer. Note that the material usage check device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may also be a portable information processing device such as a commercially available notebook personal computer, PDA (Personal Digital Assistant), smartphone, or tablet personal computer.

[0028] The material usage check device 100 comprises a control unit 102, a communication interface unit 104, a memory unit 106, and an input / output interface unit 108. Each unit of the material usage check device 100 is connected to each other so that they can communicate with each other via any communication path.

[0029] The communication interface unit 104 communicably connects the material usage check 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 material usage check device 100 and the server 200 so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).

[0030] 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 touch panel), 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 achieve a pointing device function. In the following, the output device 114 may be referred to as the monitor 114 or the printer 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.

[0031] The memory unit 106 stores various databases, tables, files, and the like. The memory unit 106 stores computer programs that cooperate with the OS (Operating System) to issue commands to the CPU (Central Processing Unit) to perform various processes. The memory unit 106 may be, 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, or an optical disk. The memory unit 106 includes a material processing database 106a, a specification master 106b, a customer component specification master 106c, an available material type master 106d, an inspection item master 106e, a material type master 106f, a product master 106g, a manufacturer master 106h, a customer master 106i, a destination master 106j, and a general name master 106k.

[0032] The material processing database 106a stores material data and processing data. Here, the material processing database 106a may store inventory data that is set by linking the material type and manufacturer for each material. Here, the inventory data may be set by linking the serial number and / or lot number of each material. Here, the serial number may be a charge number. Furthermore, the material processing database 106a may store material component data that is set by linking the material type, manufacturer, material component inspection items, and material component performance values ​​for each material. Furthermore, the material processing database 106a may store order data and / or material purchase data.

[0033] The specification master 106b is a master that sets product specifications. Here, the specification master 106b may be set in such a way that product specification management, destination, and product are linked to each other.

[0034] The customer component standard master 106c is a master that sets inspection items for material components of materials used in customer products. Here, the customer component standard master 106c may be set in such a way that product specification management, inspection items for material components, upper limit values ​​of material components, and lower limit values ​​of material components are linked to each other.

[0035] The allocable material type master 106d is a master that sets the material type and manufacturer of materials that can be used for products. Here, the allocable material type master 106d may be set in association with the destination, product, material type, and manufacturer.

[0036] As shown in FIG. 3, the allocable material type master 106d in this embodiment is set by associating a destination code, a product code, a line number, a material type code, and a manufacturer code.

[0037] 2, the inspection item master 106e is a master in which inspection items for inputting components are set. Here, the inspection item master 106e may set inspection items for material components.

[0038] As shown in FIG. 3, the examination item master 106e in this embodiment is set with the examination item code, examination item name, and the number of decimal places linked together.

[0039] Returning to FIG. 2, the material type master 106f is a master that sets the material type of the product or material.

[0040] As shown in FIG. 3, the material type master 106f in this embodiment is set with a material type code and a material type name linked to each other.

[0041] Returning to FIG. 2, the product master 106g is a master in which products or materials are set.

[0042] As shown in FIG. 3, the product master 106g in this embodiment is set with a product code, a product name, an asset classification, and a material type code linked together.

[0043] Returning to FIG. 2, the manufacturer master 106h is a master that sets manufacturers from which materials are purchased.

[0044] As shown in FIG. 3, the manufacturer master 106h in this embodiment is set with a manufacturer code and a manufacturer name linked to each other.

[0045] Returning to FIG. 2, the customer master 106i is a master in which customers are set.

[0046] As shown in FIG. 3, the customer master 106i in this embodiment is set with customer codes and customer names linked to each other.

[0047] Returning to FIG. 2, the destination master 106j is a master in which destinations such as end users are set.

[0048] As shown in FIG. 3, the destination master 106j in this embodiment is set with a destination code and a destination name linked to each other.

[0049] Returning to FIG. 2, the general-purpose name master 106k is a master in which general-purpose codes or categories are set.

[0050] As shown in FIG. 3, the general name master 106k in this embodiment is set with a type code, a code value, a type name, and a name associated with each other.

[0051] Returning to Fig. 2, the control unit 102 is a CPU or the like that performs overall control of the material usage check 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, etc., and executes various information processing based on these stored programs. Functionally, the control unit 102 conceptually includes a purchase acquisition unit 102a, a material component acquisition unit 102b, an order acquisition unit 102c, and a material check unit 102d.

[0052] The purchase acquisition unit 102a acquires purchase data. Here, the purchase acquisition unit 102a may acquire material purchase data in which a manufacturer's mill sheet is set.

[0053] The material component acquiring unit 102b acquires material component data of the material. Here, the material component acquiring unit 102b may acquire the material component data of the material based on the inspection item master 106e and material purchase data. Furthermore, the material component acquiring unit 102b may store the material component data in the material processing database 106a.

[0054] The order acquisition unit 102c acquires order data for the product. Here, the order acquisition unit 102c may acquire order data for the product in which the destination of the product has been set.

[0055] The material check unit 102d acquires a determination result for the destination specifications of the material. Here, when a product processing instruction is set, the material check unit 102d may acquire a determination result for the destination specifications of the stock-allocated material based on the specification master 106b, the customer component standard master 106c, inventory data, material component data, and order data. Furthermore, when a product processing instruction is set, the material check unit 102d may acquire a determination result that the stock-allocated material meets the destination specifications based on the specification master 106b, the customer component standard master 106c, inventory data, material component data, and order data if the actual value of the material component is equal to or greater than the lower limit value of the material component and equal to or less than the upper limit value of the material component. Furthermore, when a processing instruction in which product and specification management are set is set on the processing instruction input / receiving detail screen, the material check unit 102d may acquire a determination result for the destination specifications of the stock-allocated material based on the specification master 106b, the customer component standard master 106c, inventory data, material component data, and order data. Furthermore, the material check unit 102d may obtain a determination result that the stock-allocated material meets the destination specifications when the manufacturer or serial number is properly set in the inventory data based on the allocable material type master 106d, inventory data, and order data. Furthermore, the material check unit 102d may obtain a determination result that the stock-allocated material meets the destination specifications when the material type and manufacturer set in the inventory data meet the destination specifications based on the allocable material type master 106d, specification master 106b, inventory data, and order data. Furthermore, the material check unit 102d may obtain a determination result that the stock-allocated material meets the destination specifications when the material type, serial number, and manufacturer set in the inventory data match the material type, serial number, and manufacturer set in the material composition data based on the inventory data, material composition data, and order data. In addition, when a processing instruction for a product is set with a material lot number set, the material check unit 102d may obtain a judgment result regarding the destination specifications of the material with the inventory-allocated lot number based on the specification master 106b, the customer component standard master 106c, inventory data, material component data, and order data.Furthermore, when a negative determination result is obtained, the material check unit 102d may output an error message.

[0056] [3. Specific Examples] A specific example of this embodiment will be described with reference to FIGS.

[0057] [Materials used check process] An example of the material use check process in this embodiment will now be described with reference to Fig. 4. Fig. 4 is a flowchart showing an example of the process of the material use check device 100 in this embodiment.

[0058] As shown in FIG. 4, the purchase acquisition unit 102a acquires material purchase data in which the manufacturer's mill sheet is set (step SA-1).

[0059] Then, the material composition acquiring unit 102b acquires material composition data of the material based on the inspection item master 106e and the material purchase data, and stores the material composition data in the material processing database 106a (step SA-2).

[0060] Then, the order acquisition unit 102c acquires order data for the product for which the destination of the product has been set (step SA-3).

[0061] Then, when the processing instruction that sets the product and specification management is set on the processing instruction input acceptance details screen, the material check unit 102d acquires the judgment result for the destination specifications of the stock-allocated material based on the specification master 106b, customer component standard master 106c, inventory data, material component data, and order data (step SA-4), and ends the processing.

[0062] An example of the material use check process in this embodiment will now be described with reference to Figures 5 to 9. Figures 5 to 9 are diagrams showing an example of the material use check process in this embodiment.

[0063] In this embodiment, in order to prevent material data from being overlooked and to check it correctly, an error message is displayed if there is an error in the registration of the necessary material data. For example, as shown in Figure 5, in this embodiment, inventory data is referenced from the product code and lot number in the dispensing details, and if either the manufacturer code or charge number is NULL, an error message is displayed stating, "There is an item of material data that has not been registered. Please check with the material purchasing department."

[0064] In this embodiment, if the material type is not available for allocation, an error message is displayed. Specifically, in this embodiment, 1) the specification master 106b is referenced using the specification management number of the receiving details, and the specification master 106b. destination and specification master 106b. product code are acquired. Then, the specification master 106b. destination and specification master 106b. product code are referenced using the acquired specification master 106b. destination and specification master 106b. product code, and the allocable material type master 106d is referenced to acquire the material type code and manufacturer code. Then, in this embodiment, 2) the product master 106g is referenced using the product code of the dispensing details, and the material type code is acquired. Then, the inventory data is referenced using the product code and lot number of the dispensing details, and the manufacturer code is acquired. (Note that if the manufacturer code is NULL, a code name with the general name master 106k. type = 20096 and code value = 1 may be set.) In this embodiment, 3) if the material type code and manufacturer code acquired in step 2) do not match either the material type code or manufacturer code acquired in step 1), an error is detected and an error message is displayed stating "This is not an available material type. Please check with the technical department." (However, if the manufacturer acquired in step 1) matches the code name in the general name master 106k. type = 20096 and code value = 1, only the material type code may be checked.)

[0065] For example, as shown in FIG. 6, in this embodiment, 1) for product specification data for a product with destination = MU0001 and product code = SUS301, the destination and product code are obtained from the specification master 106b using the processing instruction input screen.Specification management number, and if the material type and / or manufacturer is different, an error message is notified; and 2) for product specification data for a product with destination = MU9999 and product code = SUS304, the destination and product code are obtained from the specification master using the processing instruction input screen.Specification management number, and if the material type and / or manufacturer is different, an error message is notified.

[0066] In addition, in this embodiment, if the material composition data has not been entered (for example, the material composition data is referenced using the material type code, charge number, material manufacturer, and application start date before the processing instruction date in the dispensing details, and no data can be obtained), an error message is notified. That is, in this embodiment, 1) the product master 106g is referenced using the product code in the dispensing details, and the material type code is obtained, and inventory data is referenced using the product code and lot number in the dispensing details, and the charge number and manufacturer code are obtained, and 2) the material composition data is referenced using the material type code, charge number, manufacturer code, and screen.processing instruction date (processing instruction date > material composition data. data most recent to application start date) obtained in step 1), and if no data can be obtained, an error message stating "The composition data has not been entered. Please check with the quality control department" is notified.

[0067] For example, as shown in Figure 7, in this embodiment, if inventory data in which the material type, manufacturer code, and charge number do not match is selected for a dispensing detail with a processing instruction date of 2021 / 1 / 1, an error message will be displayed.

[0068] In this embodiment, if the component inspection data of the allocated material is outside the standard value range of the customer component standard master, an error message is notified. That is, in this embodiment, 1) the customer component standard master 106c is referenced using the specification management number of the receipt details, and the inspection item code, magnification, lower limit value, and upper limit value are obtained, 2) the product master 106g is referenced using the product code of the dispensing details, and the material type code is obtained, and inventory data is referenced using the product code and lot number of the dispensing details, and the charge number and manufacturer code are obtained, 3) the material component data is referenced using the material type code, charge number, manufacturer code, and screen.processing instruction date (processing instruction date > material component data. most recent data from application start date) obtained in step 2), and the inspection item code, magnification, and actual value are obtained, and 4) the customer component standard work (main table) and material component work (sub table) are linked by the inspection item code, and if the material component work.inspection item code is NULL, an error message is displayed stating, "There is no material component data corresponding to the customer component standard. Please check with the technical department." Furthermore, in this embodiment, 5) the customer component standard work (main table) and the material component work (sub-table) are linked by inspection item codes, and if even one item A) customer component standard work.upper limit value / customer component standard work.multiplication factor < material component work.actual value / material component work.multiplication factor, or B) customer component standard work.lower limit value / customer component standard work.multiplication factor > material component work.actual value / material component work.multiplication factor, an error message stating "This material does not meet the component standard. Please check with the technical department" is displayed.

[0069] For example, in this embodiment, as shown in Figure 8, when inventory data (1), (2), or (3) is selected for a dispensing detail with a processing instruction date of January 1, 2021, the material composition data and customer component standard master 106c are identified. Here, the multiplier set for the material composition data is multiplied by a multiplier to make it easier to see on the mill sheet, since the decimal point increases depending on the inspection item. As shown in FIG. 9, in this embodiment, 1) when inventory data (1) is allocated for specification control number = SUS301 product-001 and processing instruction date = 2021 / 5 / 1, the inventory material type: SUS301, manufacturer: MA0001, charge number: C801, and the latest actual values ​​of material composition data before application start date = 2021 / 5 / 1 (S actual value = 8, P actual value = 90) are acquired, and the specification values ​​(0≦S standard value≦12, 70≦P standard value≦89) of the customer component specification master 106c are acquired for specification control number = SUS301 product-001. As a result, an error occurs because the P actual value exceeds the upper limit value (90). When inventory data (2) is allocated, the inventory material type: SUS309, manufacturer: MA0002, charge number: C802 and the most recent actual values ​​of the material component data before the application start date = 2021 / 5 / 1 (no corresponding data) are obtained, and the specification values ​​(0≦S specification value ≦ 12, 70≦P specification value ≦ 89) are obtained from the customer component standard master 106c for the specification management number = SUS301 product-001, and an error occurs because the material component data does not exist, and inventory data (3) is allocated. In this case, the inventory material type: SUS304, manufacturer: MA0002, charge number: C802, and the most recent actual values ​​of the material component data before the application start date = 2021 / 5 / 1 (S specification value = 7, P specification value = 81) are obtained, and the specification values ​​(0≦S specification value ≦ 12, 70≦P specification value ≦ 89) are obtained from the customer component standard master 106c for the specification management number = SUS301 product-001, and the allocation is successful.In addition, in this embodiment, when inventory data (1) is allocated for specification management number = SUS304 product-001 and processing instruction date = 2021 / 5 / 1, the actual values ​​of the inventory material type: SUS301, manufacturer: MA0001, charge number: C801, and the most recent material component data actual values ​​(S actual value = 8, P actual value = 90) before the application start date = 2021 / 5 / 1 are obtained, and the standard values ​​(0≦S standard value≦10, 10≦P standard value≦120, 17≦Pb standard value≦27) of the customer component standard master 106c are obtained for specification management number = SUS304 product-001, and an error occurs because material component data for Pb does not exist.

[0070] An example of a processing instruction input screen in this embodiment will be described with reference to Fig. 10. Fig. 10 is a diagram showing an example of a processing instruction input screen in this embodiment.

[0071] As shown in Figure 10, on the processing instruction input screen in this embodiment, processing instructions are entered by entering information from the item in the upper left, allocated materials are entered as receipt detail data, and check processing is performed when entering product and lot numbers and when registering a slip.

[0072] [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 the achievement of SDGs Goals 8 and 9.

[0073] 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.

[0074] Furthermore, this embodiment can contribute to strengthening control and governance, which can contribute to the achievement of Goal 16 of the SDGs.

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

[0076] 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.

[0077] Furthermore, 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 can be changed as desired unless otherwise specified.

[0078] Furthermore, with regard to the material usage checking device 100, the components shown in the figures are functional concepts, and do not necessarily have to be physically configured as shown in the figures.

[0079] For example, all or any part of the processing functions of the material use check device 100, particularly the processing functions performed by the control unit 102, may be implemented by a CPU and a program interpreted and executed by the CPU, or may be implemented as hardware using wired logic. The program is recorded on a non-transitory computer-readable recording medium containing programmed instructions for causing an information processing device to execute the processes described in this embodiment, and is mechanically read by the material use check device 100 as needed. That is, a computer program for providing 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 RAM, and cooperates with the CPU to form the control unit.

[0080] This computer program may also be stored in an application program server connected to the material usage check device 100 via any network, and all or part of it may be downloaded as needed.

[0081] Furthermore, the program for executing the processes described in this embodiment may be stored in a non-transitory computer-readable recording medium or configured as a program product. Here, the term "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.

[0082] Furthermore, a "program" is a data processing method written in any language or description method, and does not matter whether it is in the form of source code or binary code. Note that a "program" is not necessarily limited to a single structure, but also includes a structure that is distributed as multiple modules or libraries, or a structure that achieves its function by cooperating 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 this embodiment, as well as the installation procedure after reading, can use well-known configurations and procedures.

[0083] The various databases stored in the memory unit 106 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 used for various processes and providing websites.

[0084] The material usage check 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 any peripheral device is connected. The material usage check device 100 may also be realized by installing software (including programs, data, etc.) that causes the device to perform the processes described in this embodiment.

[0085] 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 configured by functionally or physically distributing and integrating them in any unit depending on various additions or functional loads. In other words, the above-described embodiments can be implemented in any combination, or embodiments can be implemented selectively. [Industrial Applicability]

[0086] The present invention is useful in industries such as the steel industry, which operates businesses that require specific materials, such as the electrical steel sheet business. [Explanation of symbols]

[0087] 100 Material usage check device 102 Control section 102a Purchasing Department 102b Material component acquisition section 102c Order Acquisition Department 102d Material Check Department 104 Communication interface unit 106 Storage section 106a Materials Processing Database 106b Specification Master 106c Customer component standard master 106d Available material type master 106e Inspection item master 106f Material Master 106g Product Master 106h Manufacturer Master 106i Customer Master 106j destination master 106k General Name Master 108 Input / Output Interface Section 112 Input Device 114 Output Device 200 servers 300 Network

Claims

1. A material usage check device equipped with a memory unit and a control unit, The storage unit A specification master that links product specification management, destination, and the product; a customer component standard master that links and sets the specification management of the product, the inspection items of the material components of the material, the upper limit values ​​of the material components, and the lower limit values ​​of the material components; an inventory storage means for storing inventory data set by linking the material type and manufacturer of each material; a material component storage means for storing material component data that is set by linking the material type, the manufacturer, the inspection items of the material components, and actual values ​​of the material components for each of the materials; Equipped with The control unit an order acquisition means for acquiring order data that sets the destination of the product; a material check means for, when a processing instruction for the product is set, identifying the specification control set in the specification master linked to the destination of the product set in the order data, acquiring the inspection items and the upper and lower limit values ​​of the material components of the material linked to the specification control set in the customer component standard master, identifying the material type and manufacturer of the material set in the inventory data, acquiring the actual value linked to the material type and manufacturer set in the material component data, and comparing the actual value with the upper and lower limit values ​​to acquire a judgment result for the specifications of the destination of the material allocated to inventory; A material usage checking device comprising:

2. The material checking means 2. The material usage check device according to claim 1, wherein, when the processing instructions for the product are set, the specification control set in the specification master linked to the destination of the product set in the order data is identified, the inspection items, the upper limit value, and the lower limit value of the material components of the material linked to the specification control set in the customer component standard master are acquired, the material type and the manufacturer of the material set in the inventory data are identified, the actual value linked to the material type and the manufacturer set in the material component data is acquired, and if the actual value is equal to or greater than the lower limit value and equal to or less than the upper limit value, the determination result is acquired that the stock-allocated material meets the specifications of the destination.

3. The material checking means 2. The material usage check device according to claim 1, wherein, when the processing instruction in which the product and the specification management are set is set on a processing instruction input acceptance details screen, the device identifies the specification management set in the specification master that is linked to the destination of the product set in the order data, acquires the inspection items, the upper limit value, and the lower limit value of the material components of the material that are linked to the specification management set in the customer component standard master, identifies the material type and the manufacturer of the material set in the inventory data, acquires the actual value linked to the material type and the manufacturer set in the material component data, and acquires the judgment result for the specifications of the destination of the material allocated to inventory by comparing the actual value with the upper limit value and the lower limit value.

4. The storage unit an allocable material type master set by linking the destination, the product, the material type of the material, and the manufacturer; Further provided with The inventory data is Furthermore, a manufacturing number is set for each material, The material checking means The material usage checking device according to claim 2, further comprising: identifying the material type and the manufacturer of the material set in the allocable material type master that are linked to the destination of the product set in the order data; and, if the manufacturer or the serial number of the material is set correctly in the inventory data, obtaining the determination result that the material allocated to inventory satisfies the specifications of the destination.

5. The storage unit an allocable material type master set by linking the destination, the product, the material type of the material, and the manufacturer; Further provided with The material checking means The material usage checking device according to claim 2 further identifies the material type and manufacturer of the material set in the allocable material type master that are linked to the destination of the product set in the order data, and if the material type and manufacturer set in the inventory data meet the specifications of the destination set in the specification master, obtains the determination result that the stock-allocated material meets the specifications of the destination.

6. The inventory data is Furthermore, a manufacturing number is set for each material, The material checking means The material usage checking device according to claim 2, further characterized in that, when the material type, the serial number, and the manufacturer set in the inventory data match the material type, the serial number, and the manufacturer set in the material component data, the device obtains the determination result that the stock-allocated material meets the specifications of the destination set in the order data.

7. The storage unit an inspection item master that sets inspection items for the material components; Further provided with The control unit A purchasing acquisition means for acquiring material purchasing data in which the manufacturer's mill sheet is set; a material component acquisition means for acquiring the material component data based on the inspection item master and the material purchase data; 7. The material usage checking device according to claim 1, further comprising:

8. The manufacturing number is 7. The material usage checking device according to claim 4, wherein the charge number is a charge number.

9. The inventory data is Furthermore, the lot number of the material is linked and set, The material checking means 7. The material usage check device according to claim 1, wherein, when a processing instruction for the product for which the lot number is set is set, the specification control set in the specification master linked to the destination of the product set in the order data is identified, the inspection items, the upper limit value, and the lower limit value of the material components of the material linked to the specification control set in the customer component standard master are acquired, the material type and the manufacturer of the material set in the inventory data are identified, the actual value linked to the material type and the manufacturer set in the material component data is acquired, and the actual value is compared with the upper limit value and the lower limit value to acquire the judgment result for the specification of the destination of the material of the lot number allocated to inventory.

10. A material use check method to be executed by a material use check device having a memory unit and a control unit, The storage unit A specification master that links product specification management, destination, and the product; a customer component standard master that links and sets the specification management of the product, the inspection items of the material components of the material, the upper limit values ​​of the material components, and the lower limit values ​​of the material components; an inventory storage means for storing inventory data set by linking the material type and manufacturer of each material; a material component storage means for storing material component data that is set by linking the material type, the manufacturer, the inspection items of the material components, and actual values ​​of the material components for each of the materials; Equipped with Executed in the control unit: an order acquisition step of acquiring order data that sets the destination of the product; a material check step of, when a processing instruction for the product is set, identifying the specification control set in the specification master linked to the destination of the product set in the order data, acquiring the inspection items, the upper limit value, and the lower limit value of the material components of the material linked to the specification control set in the customer component standard master, identifying the material type and the manufacturer of the material set in the inventory data, acquiring the actual value linked to the material type and the manufacturer set in the material component data, and comparing the actual value with the upper limit value and the lower limit value to acquire a judgment result for the specifications of the destination of the material allocated to inventory; A method for checking materials used, comprising:

11. A material use check program to be executed by a material use check device having a storage unit and a control unit, The storage unit A specification master that links product specification management, destination, and the product; a customer component standard master that links and sets the specification management of the product, the inspection items of the material components of the material, the upper limit values ​​of the material components, and the lower limit values ​​of the material components; an inventory storage means for storing inventory data set by linking the material type and manufacturer of each material; a material component storage means for storing material component data that is set by linking the material type, the manufacturer, the inspection items of the material components, and actual values ​​of the material components for each of the materials; Equipped with In the control unit, an order acquisition step of acquiring order data that sets the destination of the product; a material check step of, when a processing instruction for the product is set, identifying the specification control set in the specification master linked to the destination of the product set in the order data, acquiring the inspection items, the upper limit value, and the lower limit value of the material components of the material linked to the specification control set in the customer component standard master, identifying the material type and the manufacturer of the material set in the inventory data, acquiring the actual value linked to the material type and the manufacturer set in the material component data, and comparing the actual value with the upper limit value and the lower limit value to acquire a judgment result for the specifications of the destination of the material allocated to inventory; A material usage check program to execute the above.

Images