A material coding method based on material attributes

Abstract

The present invention discloses a material coding method based on material attributes, which includes the following steps in sequence: S1: according to the material category and material attributes, a rule table is set to establish a mapping relationship between the material category and the rule table, wherein the rule table includes the following items: classification code name, classification code symbol, attribute segment name and attribute segment serial number; S2: the rule table is selected to establish a coding library: the material category corresponding to the material is determined, and the rule table corresponding to the material category is selected; the material code and the attribute segment name in the rule table are used as items in the coding library, and the information content corresponding to each item is input or imported to obtain several groups, and each group is given unique pseudo-material coding information; S3: whether there is a duplicate code is determined; S4: material coding information is generated; S5: saving. The present invention is applicable to coding various different materials, has a wide range of applications, and is highly practical; it can avoid the problem of duplicate codes and improve the efficiency of material management.

Description

Technical Field

[0001] The present invention relates to the field of data management, and in particular to a material coding method based on material attributes. Background Art

[0002] Currently, most companies use material descriptions to distinguish different materials. However, this method is prone to duplicate codes or multiple codes for the same item. Duplicate codes can occur due to the order in which the material specifications are described, such as "TV Tower Paint" versus "Paint TV Tower Paint." Duplicate codes can cause confusion in a company's material management and can easily lead to obsolete and scrapped materials.

[0003] For a company, there are likely to be hundreds of material categories, each of which is described by multiple material attributes, often with significant differences. Therefore, material coding requires following the specific coding rules for each material. However, current material coding methods can only be used for the same material, resulting in a limited scope of application and low versatility.

[0004] Therefore, enterprises urgently need to develop a new material coding method to meet the coding requirements of different types of materials and avoid the problem of duplicate codes. Summary of the Invention

[0005] In order to solve the problems of duplicate codes in existing different material codes and a small scope of application of coding methods, the present invention provides a material coding method based on material attributes.

[0006] A material coding method based on material attributes includes the following steps in sequence:

[0007] S1: Set up a rule table based on material categories and material attributes, and establish a mapping relationship between material categories and rule tables;

[0008] The rule table includes the following items: classification code name, classification code symbol, attribute segment name and attribute segment sequence number;

[0009] Classify materials, name materials of the same classification, obtain classification code names, and assign unified classification code symbols to materials of the same classification code name. Each material has several material attribute segments. Name all material attribute segments of the same classification material separately to obtain attribute segment names, and assign each attribute segment name a unique attribute segment serial number.

[0010] S2: Select the rule table and establish the coding library

[0011] Determine the material category corresponding to the material and select the rule table corresponding to the material category;

[0012] Use the material code and the attribute segment name in the rule table as the items in the code library. In ascending order of the attribute segment number, use the corresponding attribute segment name as the first item, the second item, and so on, the Nth item in the code library.

[0013] Input or import the information content corresponding to each project to obtain several groups, each group including the project and a group of information content corresponding to the project;

[0014] Assign each group of unique pseudo-material coding information;

[0015] S3: Determine whether there is a duplicate code

[0016] Obtain the pseudo-material coding information of the current group and compare it with the existing material coding information one by one. If there is a duplicate, compare the content corresponding to the same attribute segment name in the current group and other groups. After completing the comparison of the content corresponding to all attribute segment names of the two, if the content of the current group is consistent with that of a certain group, it is judged as a duplicate code, and the same pseudo-material coding information is assigned to them. This pseudo-material coding information is used as the final material coding information; the pseudo-material coding information is the classification code symbol + serial number;

[0017] Otherwise, it is judged as non-duplicate code and proceed to the next step;

[0018] S4: Generate material coding information, and use the quasi-material coding information as the material coding information;

[0019] S5: Save. This method is applicable to various materials, has good versatility and flexibility, and can avoid the problem of duplicate codes.

[0020] Optionally, assign each group of unique pseudo-material coding information. The specific steps are as follows:

[0021] Obtain the existing pseudo-material coding information in the current coding library, determine the maximum serial number value, add 1 to the maximum value to generate a new serial number, and use the classification code symbol corresponding to the current group + the new serial number as the pseudo-material coding information for the group. This helps avoid duplicate codes.

[0022] Optionally, the rule table further includes the following items: a splicing sequence number, which is assigned to each attribute segment name and corresponds to a splicing sequence number. Different attribute segment names have different splicing sequence numbers.

[0023] The coding library also includes the following items: material description;

[0024] After step S2, the process also includes generating material description information. The material description information concatenates the contents corresponding to the attribute segment names, with the concatenation sequence numbered from smallest to largest. The concatenated contents serve as the corresponding material description. The material description information allows for direct and quick access to the attributes of the group of materials, making it simple and clear.

[0025] Optionally, the rule table further includes the following items: prefix and suffix, which customize the prefix content and suffix content corresponding to each attribute segment name;

[0026] The generating of the material description information further includes placing the content of the prefix and the content of the suffix before and after the content of the corresponding attribute segment name, respectively, to make the material description information clearer.

[0027] Optionally, the rule table further includes the following items: data type and decimal places, and content for customizing the data type and decimal places;

[0028] If the data type corresponds to data, the information in the encoding library is adjusted accordingly based on the number of decimal places, so that the number of decimal places of the data in the corresponding item in the encoding library is consistent with the number of decimal places in the rule table, making the data in the encoding library more standardized and normalized.

[0029] Optionally, set preset contents for several items in the rule table;

[0030] When entering or importing the information content corresponding to each item, only the preset content can be filled in.

[0031] Optionally, the rule table further includes the following items: entry method;

[0032] The user defines the content of the entry method corresponding to each attribute segment name, and the entry method content can be manual entry or drop-down selection.

[0033] Optionally, the rule table further includes the following items: whether recording is required;

[0034] The user defines whether each attribute segment name corresponds to the content to be entered, and whether the content must be entered is yes or no.

[0035] Optionally, the serial number is provided with a preset number of digits. When the generated serial number exceeds the preset number of digits, zeros are added before the serial numbers in all existing material coding information.

[0036] Optionally, before assigning the pseudo-material coding information, set the preset number of digits of the serial number.

[0037] Compared with the prior art, the beneficial effects of the present invention are: the present invention provides a material coding method based on material attributes, each material category can set its corresponding rule table, select the rule table to establish a coding library, and apply different materials to coding. The method has a wide range of applications and high practicality; it can avoid the problem of duplicate codes by judging whether there are duplicate codes, thereby improving the efficiency of material management. BRIEF DESCRIPTION OF THE DRAWINGS

[0038] Figure 1A schematic diagram of a process for encoding material attributes according to an embodiment of the present invention;

[0039] Figure 2 A schematic diagram of a rule table provided in an embodiment of the present application;

[0040] Figure 3 A schematic diagram of the encoding library provided in an embodiment of the present application. DETAILED DESCRIPTION

[0041] In order to explain the technical solution of the present invention in detail, the technical solution of the embodiment of the present invention will be clearly and completely described below. In order to explain the technical solution of the present invention in detail, the technical solution of the embodiment of the present invention will be clearly and completely described below in conjunction with the drawings of the embodiment of the present invention. Obviously, the described embodiment is a part of the embodiment of the present invention, not all the embodiments. Based on the described embodiment of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0042] Example 1

[0043] This embodiment provides a material coding method based on material attributes, which includes the following steps in sequence:

[0044] S1: Set up a rule table based on material categories and material attributes, and establish a mapping relationship between material categories and rule tables. That is, each material category is set up with its corresponding rule table;

[0045] The rule table includes the following items: classification code name, classification code symbol, attribute segment name and attribute segment sequence number;

[0046] Classify the materials, name the materials of the same classification, obtain the classification code name, and assign a unified classification code symbol to the same classification code name. Each material has several material attribute segments. Name all material attribute segments of the same classification material separately to obtain attribute segment names, and assign each attribute segment name a unique attribute segment serial number.

[0047] Details are as attached Figure 2As shown, materials can be customized to different material categories. Taking copper foil as an example, the classification code symbol assigned to copper foil is ATB. Different categories of materials have different classification code symbols, and materials of the same category have the same classification code symbol. The material attribute segments of copper foil include copper foil manufacturer, product name, copper foil type, inventory unit, copper thickness, etc. The attribute segment names obtained by naming are copper foil manufacturer, product name, copper foil type, inventory unit, copper thickness, etc. Each attribute segment name has a unique attribute segment sequence number. For example, the attribute segment sequence number of the copper foil manufacturer is 1, and the attribute segment sequence number of the product name is 2. The attribute segment sequence number can be set from small to large according to the position of the attribute segment name in the rule table.

[0048] S2: Select the rule table and establish the coding library

[0049] Determine the material category corresponding to the material and select the rule table corresponding to the material category;

[0050] Use the material code and the attribute segment name in the rule table as the items in the code library. In ascending order of the attribute segment number, use the corresponding attribute segment name as the first item, the second item, and so on, the Nth item in the code library.

[0051] Input or import the information content corresponding to each project to obtain a plurality of groups, each group including each project and a set of information content corresponding to each project;

[0052] Assign each group of unique pseudo-material coding information;

[0053] Assign each group of unique pseudo-material coding information. The specific steps are as follows:

[0054] Obtain the existing pseudo-material coding information in the current coding library, determine the maximum value of the serial number, add 1 to the maximum value to generate a new serial number, and use the classification code symbol corresponding to the current group + the new serial number as the pseudo-material coding information of the group.

[0055] For example, refer to the attached Figure 2 and attached Figure 3 In the rule table, the attribute segment number is 1, and the corresponding attribute segment name is copper foil manufacturer. The copper foil manufacturer is taken as the first item in the encoding library, and so on, to obtain the name of each item in the encoding library. Figure 3 Two groups are given. The first group is aluminum foil manufacturer in Changchun, product name is copper foil... width is 660, and the second group is aluminum foil manufacturer in Changchun, product name is reverse copper foil... width is 1295. First, each group is given unique pseudo-material coding information. In the next step, the final material coding information is determined by judging whether there is a duplicate code, and the generated material coding information is the content of the material code.

[0056] The pseudo-material coding information of the first group is 000066. The pseudo-material coding information currently available in the coding library is obtained, and the maximum serial number value is determined to be 000066. The new serial number is 000067, and the classification code symbol is ATB. ATB000067 is used as the pseudo-material coding information of the second group, and so on.

[0057] S3: Determine whether there is a duplicate code

[0058] Get the pseudo-material coding information of the current group and compare it with the existing material coding information one by one. If there is duplication, compare the content corresponding to the same attribute segment name in the current group and other groups. After completing the content comparison of all attribute segment names of the two, if the current group is consistent with the content of a certain group, it is judged as a duplicate code and assigned the same pseudo-material coding information. This pseudo-material coding information is used as the final material coding information; the pseudo-material coding information is the classification code symbol + serial number; the current group calls the material coding information of a group with the same content as its material coding information.

[0059] Otherwise, it is judged as non-duplicate code and proceed to the next step.

[0060] The pseudo-material coding information of all groups is obtained and judged one by one, and finally the material coding information of all groups is obtained.

[0061] For example, the pseudo-material coding information assigned to the current group is ATB000068, which is judged to be a duplicate code. The pseudo-material coding information of the group with the duplicate code is ATB000068, then the material coding information of the current group is modified to ATB000066. If there is no duplicate code, proceed to the next step.

[0062] S4: Generate material coding information

[0063] Generate material coding information and use the quasi-material coding information as the material coding information.

[0064] S5: Save, including the following steps:

[0065] After adding, deleting or modifying content in the code library, it will be automatically saved.

[0066] In some embodiments, the rule table further includes the following items: a splicing sequence number, which is assigned to each attribute segment name and corresponds to a splicing sequence number. Different attribute segment names have different splicing sequence numbers.

[0067] The coding library also includes the following items: material description;

[0068] After step S2, the process also includes generating material description information. This material description information is concatenated by concatenating the contents corresponding to the attribute segment names, with the concatenation sequence numbered from smallest to largest. The concatenated contents serve as the corresponding material description. The generated material description information is stored in the encoding library. This material description information can be generated before or after determining duplicate codes.

[0069] For example, refer to the attached Figures 2-3 If the splicing numbers are 10, 20, and 30 from small to large, the corresponding attribute segment names are product name, copper thickness OZ, and copper thickness um. The corresponding content of the material description of the first group in the coding library is: copper foil 0.5 (OZ) 18um. Through the material description information of each group, the material properties of the material code can be quickly extracted and known.

[0070] In some embodiments, after the user applies for a material code, it is first determined whether a rule table has been established based on the material category. If so, a coding library is established in the next step. If not, a rule table is established first.

[0071] In some embodiments, the rule table further includes the following items: prefix and suffix, which customize the content of the prefix and the content of the suffix corresponding to each attribute segment name;

[0072] Generating material description information also includes placing the prefix content and the suffix content before and after the corresponding attribute segment name content respectively.

[0073] In some embodiments, the rule table further includes the following items: data type and number of decimal places. Customizing the data type and number of decimal places is conducive to achieving data standardization and normalization.

[0074] The data type is text or data. If the data type corresponds to data, the information in the encoding library is adjusted accordingly based on the number of decimal places, so that the number of decimal places in the data in the corresponding item in the encoding library is consistent with the number of decimal places in the rule table. If the data type corresponds to text, the information in the encoding library does not need to be adjusted.

[0075] Example 2

[0076] Set preset contents for several items in the rule table;

[0077] When entering or importing the information content corresponding to each item, only the preset content can be filled in.

[0078] For example, if the default content of "Data Type" in the rule table is text or data, then the corresponding content of the data type can only be filled in as "text" or "data".

[0079] In some embodiments, the rule table further includes the following items: entry method;

[0080] The user defines the entry method for each attribute segment name, which can be either manual entry or drop-down selection. If a project has preset content, only the preset content can be selected through the drop-down selection; otherwise, manual entry is possible. The drop-down selection method helps avoid duplicate codes.

[0081] In some embodiments, the rule table further includes the following items: whether recording is required;

[0082] The user defines whether each attribute segment name corresponds to the content to be entered, and whether the content is required to be entered is Yes or No. If it is "Yes", the corresponding content of the item must be entered, if it is "No", the corresponding content of the item can be omitted.

[0083] It is understandable that the user can choose to set items such as "entry method" and "whether to enter" in the rule table according to this method to adapt to different material coding requirements.

[0084] Example 3

[0085] The serial number has a preset number of digits. When the generated serial number exceeds the preset number of digits, zeros are added to the front of the serial numbers in all existing material coding information.

[0086] Before assigning the material coding information, set the preset number of digits in the serial number.

[0087] For example, if the preset number of digits of the serial number is 3, the maximum serial number is 999. When the serial number 1000 is needed, the original serial number 999 is changed to 0999, and the coded information can continue to be assigned.

[0088] The present invention provides a material coding method based on material attributes. Each material category can be set with its corresponding rule table, and a coding library is established by selecting the rule table to encode different materials. The method has a wide range of applications and high practicality. It can avoid the problem of duplicate codes by judging whether there are duplicate codes, thereby improving the efficiency of material management.

[0089] The following detailed description of the embodiments of the present invention provided in the accompanying drawings is not intended to limit the scope of the claimed invention but is merely representative of selected embodiments of the present invention.

[0090] Unless otherwise defined, all technical and scientific terms used herein have the same meaning as those commonly understood by those skilled in the art to which the present invention pertains. The terms used herein are for the purpose of describing specific embodiments only and are not intended to limit the present invention.

[0091] The above description is merely a preferred embodiment of the present invention and is not intended to limit the present invention. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art may still modify the technical solutions described in the aforementioned embodiments or replace some of the technical features therein with equivalents. Any modifications, equivalent replacements, improvements, etc. made within the spirit and principles of this embodiment are included within the scope of protection of the present invention.

Claims

1. A material coding method based on material attributes, characterized by: The following steps are included in sequence: S1: Set up a rule table based on material categories and material attributes, and establish a mapping relationship between material categories and rule tables; The rule table includes the following items: classification code name, classification code symbol, attribute segment name and attribute segment sequence number; Classify materials, name materials of the same classification, obtain classification code names, and assign unified classification code symbols to materials of the same classification code name. Each material has several material attribute segments. Name all material attribute segments of the same classification material separately to obtain attribute segment names, and assign each attribute segment name a unique attribute segment serial number. S2: Select the rule table and establish the coding library Determine the material category corresponding to the material and select the rule table corresponding to the material category; Use the material code and the attribute segment name in the rule table as the items in the code library. In ascending order of the attribute segment number, use the corresponding attribute segment name as the first item, the second item, and so on, the Nth item in the code library. Input or import the information content corresponding to each project to obtain several groups, each group including the project and a group of information content corresponding to the project; Assign each group of unique pseudo-material coding information; S3: Determine whether there is a duplicate code Obtain the pseudo-material coding information of the current group and compare it with the existing material coding information one by one. If there is a duplicate, compare the content corresponding to the same attribute segment name in the current group and other groups. After completing the comparison of the content corresponding to all attribute segment names of the two, if the content of the current group is consistent with that of a certain group, it is judged as a duplicate code, and the same pseudo-material coding information is assigned to them. This pseudo-material coding information is used as the final material coding information; the pseudo-material coding information is the classification code symbol + serial number; Otherwise, it is judged as non-duplicate code and proceed to the next step; S4: Generate material coding information, and use the quasi-material coding information as the material coding information; S5: Save; In step S2, the rule table also includes a splicing sequence number, which is assigned to each attribute segment name. The splicing sequence numbers of different attribute segment names are different; the coding library also includes a material description; after step S2, it also includes generating material description information, and the material description information splices the content corresponding to the attribute segment name. The splicing order is based on the splicing sequence numbers from small to large, and the spliced ​​content is used as the content corresponding to the material description.

2. A material coding method based on material attributes according to claim 1, characterized in that: Assign each group of unique pseudo-material coding information. The specific steps are as follows: Obtain the existing pseudo-material coding information in the current coding library, determine the maximum value of the serial number, add 1 to the maximum value to generate a new serial number, and use the classification code symbol corresponding to the current group + the new serial number as the pseudo-material coding information of the group.

3. The material coding method based on material attributes according to claim 1, characterized in that: The rule table also includes the following items: prefix and suffix, which customize the prefix content and suffix content corresponding to each attribute segment name; The generating of the material description information further includes placing the content of the prefix and the content of the suffix before and after the content of the corresponding attribute segment name respectively.

4. The material coding method based on material attributes according to claim 1, characterized in that: The rule table also includes the following items: data type and decimal places, and content of customizing the data type and decimal places; If the data type corresponds to data, the information in the encoding library is adjusted accordingly based on the number of decimal places so that the number of decimal places of the data in the corresponding item of the encoding library is consistent with the number of decimal places in the rule table.

5. The material coding method based on material attributes according to claim 1, characterized in that: Set preset contents for several items in the rule table; When entering or importing the information content corresponding to each item, only the preset content can be filled in.

6. A material coding method based on material attributes according to claim 5, characterized in that: The rule table also includes the following items: entry method; The user defines the content of the entry method corresponding to each attribute segment name, and the entry method content can be manual entry or drop-down selection.

7. A material coding method based on material attributes according to claim 1 or 3, characterized in that: The rule table also includes the following items: whether recording is required; The user defines whether each attribute segment name corresponds to the content to be entered, and whether the content must be entered is yes or no.

8. The material coding method based on material attributes according to claim 1, characterized in that: The serial number is provided with a preset number of digits. When the generated serial number exceeds the preset number of digits, zeros are added to the front of the serial numbers in all existing material coding information.

9. The material coding method based on material attributes according to claim 8, characterized in that: Before assigning the material coding information, set the preset number of digits in the serial number.

Images