Electronic component material coding method and system based on color identification

Abstract

The invention belongs to the technical field of material management in the manufacturing industry, and provides an electronic component material coding method and system based on color identification, and the technical scheme is that the method comprises the steps: carrying out the encryption processing of obtained multi-dimensional electronic component material characteristic data, and obtaining a corresponding encryption code; according to an application scene of the electronic component material, associating the encrypted code with a specific color in combination with a corresponding color mapping rule to obtain a color mapping code of the electronic component material; based on the collected multi-dimensional material characteristic data and enterprise internal rules, generating a structured internal code containing complete information; and fusing the electronic component material color mapping code and the structured internal code to obtain a unique material code for material classification. And the system is suitable for multi-industry and multi-link material management.

Description

Technical Field

[0001] This invention belongs to the field of manufacturing material management technology, and in particular relates to a method and system for coding electronic components based on color identification. Background Technology

[0002] The statements in this section are merely background information related to the present invention and do not necessarily constitute prior art.

[0003] In the Enterprise Resource Planning (ERP) system management framework of electronics manufacturing companies, material master data management is the core foundation for ensuring the smooth operation of production, procurement, inventory, and other business processes. Currently, the industry generally uses pure numeric or mixed numeric and alphanumeric coding, which includes information such as material categories and specifications through preset rules and relies on the ERP system to achieve data association. However, the coding design does not incorporate visual identifiers, and the rules lack flexibility.

[0004] While some technologies can achieve automatic database updates and data flow consistency by parsing BOM files, TC table files, and color lists, the "colors" in these technologies are only associated with the product itself and are not designed for the material characteristics in the BOM, nor do they solve the core problem of the uniqueness of material codes. Summary of the Invention

[0005] To address at least one of the technical problems mentioned above, this invention provides a color-coded electronic component material coding method and system that integrates data sources, processing engines, and application systems to form a complete material coding management ecosystem, adaptable to material management across multiple industries and stages.

[0006] To achieve the above objectives, the present invention adopts the following technical solution: A first aspect of the present invention provides a method for color-coded electronic component material coding, comprising the following steps: Obtain multi-dimensional material characteristic data for electronic components; The acquired multi-dimensional electronic component material characteristic data is encrypted to obtain the corresponding encryption code; Based on the application scenarios of electronic components and materials, and combined with the corresponding color mapping rules, the encrypted code is associated with the specific color to obtain the color mapping code of the electronic components and materials. Based on the collected multi-dimensional material characteristic data and internal enterprise rules, a structured internal code containing complete information is generated; By fusing color-mapped coding and structured internal coding of electronic components, a unique material code is obtained for material classification.

[0007] Furthermore, the multi-dimensional electronic component material characteristic data includes basic information, technical parameters, physical characteristics, and existing coding data.

[0008] Furthermore, the acquired multi-dimensional electronic component material characteristic data is encrypted to obtain corresponding encryption codes, including: inputting the collected multi-dimensional electronic component material characteristic data into the encryption algorithm to generate encryption codes of a set number of bits and a fixed length.

[0009] Furthermore, the application scenarios for electronic component materials include the first scenario, which is applicable to warehouse sorting and bill of materials review, and the second scenario, which is applicable to SMT workshops and soldering operations.

[0010] Furthermore, when the application scenario is the first scenario, the color mapping rule adopted is as follows: determine the major categories of materials and the key parameters of each material in each major category, determine the primary color and secondary color, use the primary color to represent the major category of materials, and use the secondary color to represent the key parameters of the corresponding materials; When the application scenario is the second scenario, the color mapping rule adopted is as follows: determine the package / size and special process requirements; determine the primary color and secondary color, using the primary color to represent the package / size and the secondary color to represent the special process requirements.

[0011] Furthermore, the specific mapping process for using primary colors to represent major categories of materials includes: mapping resistors to orange, capacitors to yellow, integrated circuits to black, and connectors to green; The secondary colors represent the key parameters of the corresponding materials. The specific mapping process includes: in terms of resistance value order of magnitude, brown corresponds to the Ω level, red corresponds to the KΩ level, and blue corresponds to the MΩ level. In the capacitor value type, sky blue corresponds to pF level, purple corresponds to μF level, and green corresponds to electrolytic capacitor; In the integrated circuit function types, red corresponds to power IC, green corresponds to logic IC, and blue corresponds to MCU; In connector interface types, dark green corresponds to board-to-board and light green corresponds to wire-to-board.

[0012] Furthermore, the fusion of electronic component material color mapping code and structured internal code includes: inputting the electronic component material color mapping code and structured internal code into a HASH algorithm to generate an 8-bit fixed compressed code, and then concatenating the enterprise prefix to form the final unique code.

[0013] A second aspect of the present invention provides a color-coded electronic component material coding system, comprising: The characteristic data acquisition module is used to acquire multi-dimensional characteristic data of electronic components. The encryption module is used to encrypt the acquired multi-dimensional electronic component material characteristic data to obtain the corresponding encryption code. The color mapping module is used to associate encrypted codes with specific colors based on the application scenario of electronic component materials and the corresponding color mapping rules to obtain the color mapping code of electronic component materials. The internal coding module is used to generate structured internal codes containing complete information based on the collected multi-dimensional material characteristic data and the company's internal rules. The encoding output module is used to merge the color mapping code and structured internal code of electronic component materials to obtain a unique material code for material classification.

[0014] A third aspect of the present invention provides a computer-readable storage medium.

[0015] A computer-readable storage medium having a computer program stored thereon, which, when executed by a processor, implements the steps of the color-coded electronic component material coding method described above.

[0016] A fourth aspect of the present invention provides a computer device.

[0017] A computer device includes a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor executes the program to implement the steps of the color-coded electronic component material coding method described above.

[0018] Compared with the prior art, the beneficial effects of the present invention are: This invention eliminates the problem of "one item, multiple codes" and "one code, multiple items" at its source by ensuring the uniqueness of the code through multi-dimensional characteristic collection and encryption algorithms. It introduces color identification, applying different color mapping rules according to different application scenarios, and deeply binds them to the multi-dimensional characteristics of materials, achieving seamless integration with existing ERP, warehouse management and other systems, taking into account both "system digital management" and "on-site visual operation". It is adaptable to the management needs of materials from multiple industries (especially the electronics manufacturing industry) and multiple sources (customer-supplied / self-purchased) and has flexible scalability.

[0019] Advantages of additional aspects of the invention will be set forth in part in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention. Attached Figure Description

[0020] The accompanying drawings, which form part of this invention, are used to provide a further understanding of the invention. The illustrative embodiments of the invention and their descriptions are used to explain the invention and do not constitute an improper limitation of the invention.

[0021] Figure 1This is a flowchart of a color-coded electronic component material coding method provided in an embodiment of the present invention; Figure 2 This is a schematic diagram of a material label provided in an embodiment of the present invention; Figure 3 This is a schematic diagram of the BOM list interface of the ERP system provided in an embodiment of the present invention. Detailed Implementation

[0022] The present invention will be further described below with reference to the accompanying drawings and embodiments.

[0023] It should be noted that the following detailed description is illustrative and intended to provide further explanation of the invention. Unless otherwise specified, all technical and scientific terms used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention pertains.

[0024] It should be noted that the terminology used herein is for the purpose of describing particular embodiments only and is not intended to limit the scope of exemplary embodiments according to the invention. As used herein, the singular form is intended to include the plural form as well, unless the context clearly indicates otherwise. Furthermore, it should be understood that when the terms "comprising" and / or "including" are used in this specification, they indicate the presence of features, steps, operations, devices, components, and / or combinations thereof.

[0025] Current material management technologies cannot simultaneously meet the dual requirements of "unique coding" and "efficient identification." Specific shortcomings are as follows: 1. Lack of uniqueness of codes: Due to factors such as material source (customer-supplied / self-purchased), input habits (such as "10KΩ±5%" and "10K5%"), and rule loopholes, there are common problems such as "one item with multiple codes" (the same material corresponds to multiple codes, resulting in inventory redundancy) and "one code with multiple items" (a single code corresponds to multiple materials, causing production errors).

[0026] 2. Low efficiency of manual identification: Pure character encoding is abstract and lengthy. Warehouse staff and engineers need to repeatedly check text information in the processes of receiving and issuing materials, inventory counting, and BOM review, which can easily lead to visual fatigue and a high rate of human error.

[0027] 3. High system dependence: Material information needs to be queried through the ERP system. In on-site operations (workshops and warehouses) that are not connected to the system, the efficiency of material communication and verification is greatly reduced.

[0028] 4. Limitations of color application: In existing technologies, color is not deeply bound to the multi-dimensional characteristics of materials, but is only used as an auxiliary display element, and has not formed a closed-loop association of "visual identification - coding logic - characteristic data".

[0029] This invention aims to overcome the shortcomings of existing technologies and provide a unique material coding scheme driven by both visualization and algorithmization. Specific objectives include: 1. Eliminate the problem of "one item, multiple codes" and "one code, multiple items" at the source by ensuring the uniqueness of the code through multi-dimensional feature collection and encryption algorithms; 2. Introducing color-coding enhances the intuitiveness of material identification, reducing the difficulty and error rate of manual operation; 3. Achieve seamless integration with existing ERP, warehouse management and other systems, balancing "digital system management" and "visualized on-site operation"; 4. Adaptable to the management needs of multiple industries (especially the electronics manufacturing industry) and multiple sources (customer-supplied / self-purchased) of materials, with flexible scalability.

[0030] Example 1 like Figure 1 As shown, this embodiment provides a color-coded electronic component material coding method, including the following steps: Step 1: Obtain multi-dimensional material characteristic data for electronic components; In this embodiment, the acquired multi-dimensional material characteristic data includes basic information, technical parameters, physical properties, and existing coding data; Specifically, the basic material information includes the material name, supplier, manufacturer part number, and procurement method; Technical parameters include specifications (e.g., resistance 10KΩ±5%), function type (e.g., power IC), and accuracy class; Physical characteristics include package size (e.g., 0805 surface mount), form factor (through-hole / surface mount), and process requirements (anti-static / high temperature resistance). The existing coding data includes customer-supplied material codes and temporary codes within the enterprise.

[0031] Step 2: Encrypt the acquired multi-dimensional electronic component material characteristic data to obtain the corresponding encryption code; In this embodiment, the collected multi-dimensional characteristic data is input into a HASH algorithm based on the national cryptographic standard to generate a 10-bit fixed-length compressed encryption code. Different data inputs correspond to unique outputs, ensuring the underlying uniqueness of the color identifier.

[0032] This invention uses the national cryptographic HASH algorithm to convert multi-source characteristic data into unique encrypted codes, laying the foundation for the uniqueness of the encoding.

[0033] It should be noted that the encryption process here can also use non-national cryptographic standard algorithms or non-HASH algorithms, as long as it can generate code of a fixed length. The fixed length can be 10 bits or other lengths, depending on the algorithm used, as long as the data before and after encryption corresponds one-to-one.

[0034] Step 3: Based on the application scenario of electronic component materials, and in conjunction with the corresponding color mapping rules, associate the encryption code with the specific color to obtain the color mapping code of the electronic component materials; In this embodiment, when the application scenario of the material is the first scenario, which is applicable to warehouse sorting and bill of materials (BOM) review, the first color mapping rule is adopted. When the application scenario of the material is the second scenario, which is applicable to the SMT workshop (Surface Mount Technology (SMT)) and soldering operations, the second color mapping rule is adopted; When using the first color mapping rule, determine the major categories of materials and the key parameters of each material in each major category, and then determine the primary and secondary colors. The primary color represents the major category of materials (e.g., orange = resistor, yellow = capacitor), and the secondary color represents the key parameters of the corresponding materials (e.g., red = KΩ level resistance, blue = MΩ level resistance). In this embodiment, the major categories of materials include resistors, capacitors, integrated circuits, connectors, etc.; resistors include different resistance values, capacitors include different capacitance types, integrated circuits include different functional types, and connectors include unprovided interface types, etc. The specific mapping process for using primary colors to represent major material categories includes: mapping resistors to orange, capacitors to yellow, integrated circuits to black, and connectors to green; The secondary colors represent the key parameters of the corresponding materials. The specific mapping process includes: in terms of resistance value order of magnitude, brown corresponds to the Ω level, red corresponds to the KΩ level, and blue corresponds to the MΩ level. In the capacitor value type, sky blue corresponds to pF level, purple corresponds to μF level, and green corresponds to electrolytic capacitor; In the integrated circuit function types, red corresponds to power IC, green corresponds to logic IC, and blue corresponds to MCU; In connector interface types, dark green corresponds to board-to-board and light green corresponds to wire-to-board. The specific mapping table is shown in Table 1: Table 1 shows the mapping table using the first color mapping rule.

[0035] When using the second color mapping rule, determine the package / size and special process requirements; then determine the primary and secondary colors, using the primary color to represent the package / size (e.g., dark green = 0805 surface mount, brown = through-hole), and the secondary color to represent special process requirements (e.g., yellow = electrostatic sensitive, red = polarized). In this embodiment, the package / size includes 0805 surface mount, 0603 surface mount, through-hole, SOIC packaged IC, etc.; special process requirements include polarity, electrostatic sensitivity, and pin 1 marking. The specific mapping table is shown in Table 2: Table 2 shows the mapping table using the second color mapping rule.

[0036] The final electronic component material mapping scheme includes a color code of "YS + 10-bit encryption code" (such as YS1234567890), and determines the corresponding primary color + secondary color visual scheme.

[0037] This invention associates encryption codes with color mapping tables for functional / encapsulation categories, achieving the dual characteristics of "unique at the underlying level + visually intuitive".

[0038] Step 4: Based on the collected multi-dimensional material characteristic data and internal enterprise rules, generate a structured internal code containing complete information; In this embodiment, the format of the structured internal encoding is as follows: The format is "Class Code - Key Parameters - Packaging - Manufacturing Process - Internal Serial Number", as shown in the example below: 10KΩ±5% 0805 Chip Resistor (Purchased by the supplier, supplier A01): R-10K-0805-±5%-A001 Polarized 0805 SMD LED (customer supplied, supplier B02): D-LED-0805-POL-B003 The encoding rules must meet the following requirements: Includes core information that uniquely identifies the material (to avoid confusion due to missing parameters); Associated with encryption codes, this ensures data consistency between "color-coded internal codes".

[0039] Step 5: Merge the color mapping code and structured internal code of electronic component materials to obtain a unique material code for material classification; In this embodiment, the color code and the structured internal code are input into the HASH algorithm: Bcrypt / PBKDF2 / Argon2 to generate an 8-bit fixed compressed code, which is then concatenated with the enterprise prefix (such as the enterprise code "USR") to form the final unique code (such as USR87654321).

[0040] When a unique material code is obtained for material classification, the physical application involves outputting material labels with a "color code area + information area" via a label printing system, such as... Figure 2 (as shown) Color code area: A large area of ​​main color background + secondary color stripes / dots to intuitively display material classification; Information area: Print the final code, structured internal code, and common parameter descriptions (such as "surface mount resistor 10KΩ 0805 ±5%)".

[0041] When obtaining a unique material code for material classification, the system-level application involves adding "Color Identifier" and "Final Code" fields to ERP (such as UFIDA U8) and warehouse management systems. System interface rendering: The background of the material code row automatically matches the main color, such as... Figure 3 As shown, engineers can quickly review the rationality of the BOM through the color distribution; Data linkage: Color identification, internal coding, and final coding are synchronized in real time, supporting functions such as "filter by color" and "reverse coding lookup".

[0042] This invention generates the final code through secondary HASH encryption, while simultaneously enabling the linkage between physical tags and system data.

[0043] Taking "10KΩ±5% 0805 package surface mount resistor (self-purchased, supplier code A01)" as an example, the implementation process is explained in detail: Characteristic data acquisition: The acquired data includes "Name: Chip resistor; Manufacturer: XX Electronics; Procurement method: Self-purchase; Specification: 10KΩ±5%; Package: 0805 Chip; Supplier code: A01". Encryption and color matching: Input the HASH algorithm to generate a 10-digit encryption code "1234567890", and the color code is "YS1234567890". Match "Scheme A": Primary color = orange (resistor category), Secondary color = red (KΩ level resistance value).

[0044] Internal code generation: Generate "R-10K-0805-±5%-A001" according to the rules. Final code synthesis: Input "YS1234567890" and "R-10K-0805-±5%-A001" into the HASH algorithm to generate an 8-bit compressed code "87654321", and concatenate it with the company prefix "USR" to obtain the final code "USR87654321". Physical and system applications: Print label: Orange background + red stripe, indicating the final code and parameter description; ERP configuration: Assign the value "orange + red" to the "color identifier" field, and the background of the material row in the BOM interface will be rendered as orange.

[0045] Example 2 This embodiment provides a color-coded electronic component material coding system, including: The characteristic data acquisition module is used to acquire multi-dimensional characteristic data of electronic components. The encryption module is used to encrypt the acquired multi-dimensional electronic component material characteristic data to obtain the corresponding encryption code. The color mapping module is used to associate encrypted codes with specific colors based on the application scenario of electronic component materials and the corresponding color mapping rules to obtain the color mapping code of electronic component materials. The internal coding module is used to generate structured internal codes containing complete information based on the collected multi-dimensional material characteristic data and the company's internal rules. The encoding output module is used to merge the color mapping code and structured internal code of electronic component materials to obtain a unique material code for material classification.

[0046] It should be noted that the specific implementation of the color-coded electronic component material coding system of this invention is similar to the specific implementation of the color-coded electronic component material coding method of this invention. Please refer to the description in the method section for details. To reduce redundancy, it will not be repeated here.

[0047] Example 3 This embodiment provides a computer-readable storage medium storing a computer program that, when executed by a processor, implements the steps of the color-coded electronic component material coding method described above.

[0048] Example 4 This embodiment provides a computer device, including a memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the program, it implements the steps in the color-coded electronic component material coding method described above.

[0049] Those skilled in the art will understand that embodiments of the present invention can be provided as methods, systems, or computer program products. Therefore, the present invention can take the form of hardware embodiments, software embodiments, or embodiments combining software and hardware aspects. Furthermore, the present invention can take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage and optical storage) containing computer-usable program code.

[0050] This invention is described with reference to flowchart illustrations and / or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each block of the flowchart illustrations and / or block diagrams, and combinations of blocks in the flowchart illustrations and / or block diagrams, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, special-purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, generate instructions for implementing the flowchart illustrations and / or block diagrams. Figure 1 One or more processes and / or boxes Figure 1 A device that provides the functions specified in one or more boxes.

[0051] These computer program instructions may also be stored in a computer-readable storage medium that can direct a computer or other programmable data processing device to function in a particular manner, such that the instructions stored in the computer-readable storage medium produce an article of manufacture including instruction means, which are implemented in a process Figure 1 One or more processes and / or boxes Figure 1 The function specified in one or more boxes.

[0052] These computer program instructions may also be loaded onto a computer or other programmable data processing equipment to cause a series of operational steps to be performed on the computer or other programmable equipment to produce a computer-implemented process, thereby providing instructions that execute on the computer or other programmable equipment for implementing the process. Figure 1 One or more processes and / or boxes Figure 1 The steps of the function specified in one or more boxes.

[0053] Those skilled in the art will understand that all or part of the processes in the above embodiments can be implemented by a computer program instructing related hardware. The program can be stored in a computer-readable storage medium, and when executed, it can include the processes of the embodiments of the above methods. The storage medium can be a magnetic disk, optical disk, read-only memory (ROM), or random access memory (RAM), etc.

[0054] The above description is merely a preferred embodiment of the present invention and is not intended to limit the invention. Various modifications and variations can be made to the present invention by those skilled in the art. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present invention should be included within the scope of protection of the present invention.

Claims

1. A color-coded electronic component material coding method, characterized in that, Includes the following steps: Obtain multi-dimensional material characteristic data for electronic components; The acquired multi-dimensional electronic component material characteristic data is encrypted to obtain the corresponding encryption code; Based on the application scenarios of electronic components and materials, and combined with the corresponding color mapping rules, the encrypted code is associated with the specific color to obtain the color mapping code of the electronic components and materials. Based on the collected multi-dimensional material characteristic data and internal enterprise rules, a structured internal code containing complete information is generated; By fusing color-mapped coding and structured internal coding of electronic components, a unique material code is obtained for material classification.

2. The method for color-coded electronic component materials as described in claim 1, characterized in that, The multi-dimensional electronic component material characteristic data includes basic information, technical parameters, physical properties, and existing coding data.

3. The method for color-coded electronic component materials as described in claim 1, characterized in that, The acquired multi-dimensional electronic component material characteristic data is encrypted to obtain corresponding encryption codes, including: inputting the collected multi-dimensional electronic component material characteristic data into the encryption algorithm to generate encryption codes of a set number of bits and a fixed length.

4. The method for color-coded electronic component materials as described in claim 1, characterized in that, The application scenarios for electronic component materials include the first scenario, which is suitable for warehouse sorting and bill of materials review, and the second scenario, which is suitable for SMT workshops and soldering operations.

5. The electronic component material coding method based on color identification as described in claim 4, characterized in that, When the application scenario is the first scenario, the color mapping rule adopted is: determine the major categories of materials and the key parameters of each material in each major category, determine the primary color and secondary color, use the primary color to represent the major category of materials, and use the secondary color to represent the key parameters of the corresponding materials; When the application scenario is the second scenario, the color mapping rule adopted is as follows: determine the package / size and special process requirements; determine the primary color and secondary color, using the primary color to represent the package / size and the secondary color to represent the special process requirements.

6. The method for color-coded electronic component materials as described in claim 5, characterized in that, The specific mapping process for using primary colors to represent major material categories includes: mapping resistors to orange, capacitors to yellow, integrated circuits to black, and connectors to green; The secondary colors represent the key parameters of the corresponding materials. The specific mapping process includes: in terms of resistance value order of magnitude, brown corresponds to the Ω level, red corresponds to the KΩ level, and blue corresponds to the MΩ level. In the capacitor value type, sky blue corresponds to pF level, purple corresponds to μF level, and green corresponds to electrolytic capacitor; In the integrated circuit function types, red corresponds to power IC, green corresponds to logic IC, and blue corresponds to MCU; In connector interface types, dark green corresponds to board-to-board and light green corresponds to wire-to-board.

7. The method for color-coded electronic component materials as described in claim 1, characterized in that, The process of integrating the color mapping code and structured internal code of electronic component materials includes: inputting the color mapping code and structured internal code of electronic component materials into a HASH algorithm to generate an 8-bit fixed compressed code, and then concatenating the enterprise prefix to form a final unique code.

8. A color-coded electronic component material coding system, characterized in that, include: The characteristic data acquisition module is used to acquire multi-dimensional characteristic data of electronic components. The encryption module is used to encrypt the acquired multi-dimensional electronic component material characteristic data to obtain the corresponding encryption code. The color mapping module is used to associate encrypted codes with specific colors based on the application scenario of electronic component materials and the corresponding color mapping rules to obtain the color mapping code of electronic component materials. The internal coding module is used to generate structured internal codes containing complete information based on the collected multi-dimensional material characteristic data and the company's internal rules. The encoding output module is used to merge the color mapping code and structured internal code of electronic component materials to obtain a unique material code for material classification.

9. A computer-readable storage medium having a computer program stored thereon, characterized in that, When the program is executed by the processor, it implements the steps in the color-coded electronic component material coding method as described in any one of claims 1-7.

10. A computer device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that, When the processor executes the program, it implements the steps in the color-coded electronic component material coding method as described in any one of claims 1-7.

Images