Design and implementation of super BOM based on dynamic library table

Abstract

In the product lifecycle, there exist multi-view Boms for different departments and functions. Each department in the custom when the BOM is not a unified specification design and management, and for different products of different enterprise each department involved in custom BOM. BOM attribute column is also a dynamic variable, most enterprises for BOM custom is still adopt the way of print before the department and the department of information sharing. Therefore, this paper proposes a concept of super BOM table, which can dynamically generate each business BOM table to meet the customization requirements of each department for BOM table. In addition, this paper also designs a super BOM creation platform based on B/S architecture to realize the paperless management of BOM., and proposes a new database access development mode for dynamic table building behavior. The last part of the article takes the machine tool product of A company as an example to test the related functions of the web platform. Practice has proved that the design and implementation of super-BOM based on dynamic library table makes the way of customized BOM more standardized and convenient, realizes the paperless management of BOM information, and greatly improves the management level of BOM table in enterprises.