Compiling method and compiling system for enterprise universal material codes

Abstract

The invention discloses a compiling method and a compiling system for enterprise universal material codes, and the method comprises the following steps: 1, inquiring according to a material distinguishing attribute code; 2, inquiring whether a material name corresponding to the material distinguishing attribute code exists; 3, inquiring according to a material uncertainty unordered tree chain table code; 4, choosing the material uncertainty unordered tree chain table code to inquire whether the material name exists; 5, inquiring according to a material sequence number; 6, inquiring whether thematerial name corresponding to the material sequence number exists. The system comprises a material distinguishing attribute code inquiring module, an uncertainty unordered tree chain table code inquiring module and a material sequence number inquiring module; the material distinguishing attribute code inquiring module is used for selecting an attribute which is significant for distinguishing toinquire the material name; the uncertainty unordered tree chain table code inquiring module is used for inquiring the material name according to the uncertainty unordered tree chain table code; and the material sequence number inquiring module is used for inquiring the material name according to the material sequence number.

Description

technical field [0001] The invention relates to a compilation method and a compilation system for enterprise general material coding, in particular to a compilation method and compilation system for realizing enterprise general material coding through an intelligent database. Background technique [0002] The usual form of a material code is a string of numbers or a string containing other English characters. It is a "unique identification" that all enterprises that implement information management must establish in the computer system for each different material they use. To ensure that managed materials can be correctly distinguished, high-quality management control work is completed in various related management processes including procurement, inventory, maintenance, etc. Due to the large number and the form and representative content of these character strings are not easy to be directly identified by personnel, general users cannot directly identify them from the codes...

AI Technical Summary

Problems solved by technology

Due to the different sources of data from multiple parties and different narrative representations, coupled with the large number of items, errors are unavoidable, and the proportion of repeated codes is high;

[0006] 2. It is impossible to accurately distinguish the coding methods of materials. The data coding methods adopted by most enterprises are mostly "fixed level (three layers are the most common) classification + serial code", and there are also implementations of incorporating material specifications into coding and other different methods. Variation method; or establish attribute "templates" for the specifications of different materials, and use relatively standardized descriptions of specification parameters to solve the problem of "one thing with multiple numbers" caused by coding by different personnel. No matter which coding method is adopted, it cannot be solved. Complex attribute expression / item distinction problems caused by multi-fields and multi-material varieties / structures;

As time goes by, the accumulated amount of data is increasing, and the numbering sequence is also chaotic, and the efficiency of human inspection will become lower and lower. Often, a new material number is directly edited to meet the urgent needs of users when it is uncertain, and the accumulated data will accumulate over time. The mistakes are getting harder to clean up

Images