Universal material code writing method suitable for enterprise material management

Abstract

The invention discloses a universal material code writing method suitable for enterprise material management. The method comprises the steps of performing a query by using material names and material specifications, and querying whether the material names and the material specifications are all existent in a database or not according to the material names and the material specifications input by a user; when the database does not store the material names and / or the material specifications, self-defining the material names and / or the material specifications and corresponding material name codes and / or material specification codes by the user, and returning the self-defined material names and / or material specifications and corresponding material name codes and / or material specification codes to the database for performing storage; and combining the material name codes with the material specification codes to obtain material codes. Through the method, the user can add the material codes in the database when the material codes need to be used, so that the technical problems of heavy work, low efficiency and definition solidification of conventional material code pre-definition are avoided.

Description

technical field [0001] The present invention relates to the preparation of material codes, specifically an open and completely user-defined general material code preparation method and a device for realizing the method. The above method is used for material management within an enterprise organization. Background technique [0002] At present, all enterprises have compiled material codes for internal material management of the enterprise organization. Most of these material codes are in the form of multi-level classification + specification sequence code or multi-level classification + specification feature code (multi-segment). The main problems in this code compilation form are: in the early stage of code compilation, it takes a lot of manpower and material resources to compile the material classification code and the specification list corresponding to each type of material. Due to the limited knowledge of coders and the rapid development of new materials, material class...

AI Technical Summary

Problems solved by technology

The main problems in this code compilation form are: in the early stage of code compilation, it takes a lot of manpower and material resources to compile the material classification code and the specification list corresponding to each type of material

Due to the limited knowledge of coders and the rapid development of new materials, material classification and specification data are often incomplete, which cannot meet the new needs of material code users

Moreover, since material classification and specification data have been pre-defined, it is very difficult to modify unreasonable definitions or add new material classification and specification data

At the same time, there is also the problem that the product is not universal and cannot be widely used among enterprises

Images