I. Overview
With the development of information science and technology, today's society has entered an information age. Currently, most large-scale Chinese wire and cable companies have their own ERP systems. In the implementation and application of enterprise ERP, code compilation is one of the most fundamental and crucial tasks. Developing a complete, practical, and highly scalable coding scheme that meets system requirements is a problem that every enterprise must solve in its information technology construction. Enterprise information coding should start from the overall system, based on the functions of each subsystem, taking all information related to the enterprise's product design, production, inventory, quality, and sales activities as the object. It should define and name the main information involved, determining its content, scope, and representation methods, thereby achieving unified coding of information classification and establishing a commonly recognized unified language and unified identifier within a certain scope. I was fortunate to participate in the coding work of the TBEA New Cable Factory ERP project, and this article will elaborate on some of the coding ideas and practices.
II. Basic Encoding Rules:
One of the key tasks in the early stages of ERP system implementation is information coding standardization, which runs through the entire lifecycle of the ERP system's design, implementation, and application. Information coding standardization is characterized by its high manpower requirements, wide scope, large amount of information, long timeframe, and significant complexity. Therefore, material coding is a crucial master data element in the ERP system. At the beginning of the project, the new cable factory established a basic data team, led by a senior technical staff member from the technical department, to collect and analyze all materials used throughout the factory. This data served as the fundamental basis for coding. The new cable factory's information coding possesses the following characteristics.
1. Uniqueness: The code must be uniquely identifiable. One code represents one type of material. It cannot be repeated or ambiguous.
The new cable factory mainly produces 35KV and below medium-voltage cables, computer cables, control cables, overhead lines, fire-resistant cables, halogen-free low-smoke cables, and low-voltage cables. The product range is extensive, with approximately 30,000 finished products and 100,000 semi-finished products. To ensure the uniqueness of product codes, we categorize our national standard products into 10 major categories based on their usage characteristics: bare wires, plastic-insulated wires, rubber-insulated cables, overhead lines, control cables, and plastic-insulated power cables.
The product categories include rubber cables, cross-linked cables, computer cables, and mining cables. This broad category encompasses all products the factory can manufacture. Products are further subdivided into dozens of subcategories based on voltage levels and product attributes. This clear and organized categorization of cables makes the classification easy to understand, simple, and practical, effectively solving the problem of multiple codes for a single item.
2. Standardization: Given the wide variety of cable products and their numerous models and specifications, national and ministerial standards should be adopted as much as possible.
Some wire and cable products currently lack unified national standards, leading to inconsistent product naming. Inconsistent coding within the system can disrupt smooth operations in product sales, production, and warehousing. To effectively address this issue, for national standard products, coding is uniformly based on national standards, correcting inconsistencies in product coding used across different departments within the company. For non-standard products, enterprise-standard coding rules have been established, ensuring that the same type of cable entering the system uses the same code. If customers have special requirements, the same product code is used internally, with special requirements only applied to printing. This effectively reduces the amount of BOM and process route maintenance required and simplifies sales and inventory management.
3. Simplification: Item codes should be simple, clear, easy to read, easy to understand, and easy to use;
Material codes are not inherently meaningful. Our factory uses numbers to encode all projects. The codes are 13 digits long, with each digit representing a different category and model specification. This coding method is simple and clear, and greatly facilitates later maintenance.
4. Systematic: The system architecture of the object code should be established comprehensively and systematically;
In the initial stage of system construction, all materials entering the ERP system should be considered in a comprehensive manner, including all materials used by the enterprise, and classified according to usage attributes. The products used in our factory are divided into seven categories, mainly finished products, semi-finished products, raw materials, fixed assets, low-value consumables, office supplies, and equipment maintenance supplies. This facilitates maintenance and unified modification by different departments.
5. Scalability: All code should have room for expansion.
Some cable types have many names and models, so it's necessary to leave some leeway; otherwise, there may be a shortage of codes. Examples include computer cables and power cables.
III. Conclusion
In today's ever-changing society, enterprises must carry out information technology construction in order to better adapt to and capture the market. More and more wire and cable companies will implement ERP. I hope that some coding experience mentioned in this article can provide them with assistance.
