Enterprise material universal dynamic column name encoding method and compiling system

Abstract

The invention discloses an enterprise material universal dynamic column name encoding method and a compiling system. The enterprise material universal dynamic column name encoding method comprises thesteps of: 1, creating an uncertainty tree chain table; 2, inquiring according to a tree chain table code; 3, selecting a material tree chain table code to inquire a material name; 4, when the corresponding material name cannot be inquired according to the tree chain table code, inquiring according to a material sequence number; 5, creating a material attribute dynamic column name code table; 6, carrying out accumulation multiplying and splicing on the material attribute dynamic column name code table and a tail chain of the tree chain table; 7, obtaining code data contents. The system comprises an uncertainty tree chain table inquiry module, a material sequence number inquiry module and a material dynamic column name code inquiry module; the uncertainty tree chain table inquiry module isused for inquiring the material name according to the material uncertainty tree chain table code; the material sequence number inquiry module is used for inquiring the material name according to the material sequence number; and the material dynamic column name code inquiry module is used for inquiring the material name according to the material attribute dynamic column name code.

Description

technical field [0001] The invention relates to the compilation technology of general codes for enterprise materials, in particular to a method and system for realizing the general dynamic listing and coding of enterprise materials 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 to designat...

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 that incorporate 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