企业资源规划系统中物料清单合法性检查方法研究  

Validity inspection of BOM structure in ERP system

作　　者：杜杰[1] 陆金桂[1] 郁云[2] 邵定宏[2] 刘建国[2] 

机构地区：[1]南京工业大学自动化学院,江苏南京210009 [2]南京工业大学信息科学与工程学院,江苏南京210009

出　　处：《计算机集成制造系统》2007年第1期165-170,共6页Computer Integrated Manufacturing Systems

基　　金：江苏省教育厅基金资助项目(04KJB520042)。~~

摘　　要：针对物料清单深度遍历法和层次遍历法在物料清单合法性检查中的不足,提出了一种新的物料清单合法性检查方法,包括嵌套检查和完整性检查。该方法不受内存堆栈的限制,结合数据库存储过程操作,具有较高的执行效率,所开发的物料清单模块已成功应用于某制造型企业的企业资源规划系统中。To deal with shortcomings of Bill of Material （BOM） validity inspection using depth-first traversal and breadth-first traversal algorithms, a new BOM validity inspection method including deadlock inspection and integrity inspection was proposed. The deadlock inspection of BOM was carried out through the comparisons of several key parameters between the current materials and the result table during every step of traversal. The integrity inspection was conducted based on the analysis of the material type. In addition, the procedures of BOM traversal and validity inspection were compiled as stored procedure. Combined with the use of stored procedure, the method could deal with complex BOM tree structure without the limitation of CPU memory. The proposed BOM module in an Enterprise Resource Planning （ERP） system was successfully applied in a manufacturing enterprise.

关 键 词：企业资源计划 物料清单 合法性检查 

分 类 号：TP391[自动化与计算机技术—计算机应用技术]