红塔ERP配件数据准备的研究
摘要
在国有企业ERP的实施过程中，最困难的就是基础数据的准备，数据准备成功与否，是ERP实施能否成功的关键因素。
本文结合红塔实施ERP的实际情况，对企业配件的管理现状和数据现状进行了深入的调查和分析。着重研究了配件管理业务流程的重构和数据的重构、配件静态数据的分析整理及数据准备的实施技术。在配件管理业务流程和数据重构的研究中，深入分析了配件管理业务流程和数据现状存在的问题，提出了配件采购、库存管理业务流程重构的目标和模式，以及配件数据重构的方法，解决了配件管理业务流程的优化问题和分散的配件数据的整合问题。在对配件静态数据的分析整理及实施技术的研究中，基于重构后的配件数据，建立了科学合理的分类原则和编码体系，解决了配件数据的规范化和标准化问题，采用数据库编程技术，设计了数据准备、转换和检查程序，实现了对数据准确性和重码率的控制。最后分析了配件数据实施的效果。
本文的研究提出了一套系统的配件数据准备的方法，使红塔ERP配件数据准备在无现成的理论指导和成功先例借鉴情况下顺利完成，并取得良好效果，证明本文所提方法是可行的、先进的，它对红塔实施其它模块，对国企、大型企业实施ERP，以及任何大型管理项目的数据准备都具有借鉴意义。
One of the most difficult problems during the cause of the application of ERP in national enterprises is the preparation of fundamental data. Whether the data preparation is successful or failed is a key factor of whether the project will be succeeded or failed.
Integrating the practical complexion during the application of the Hongta ERP project, the author, in the dissertation, makes a deep investigation and analysis to the management-actuality and data-actuality of those fittings in Hongta. The dissertation works strictly over the operation-flow reformation and the data reformation during the management about those fittings, and also over the analysis and coordination about the data of those static ones. At the same time, the paper also stresses over the practical technique about the application of the data preparation. In the session of the operation-flow reformation and the data reformation, the paper analyses deeply the problems about the operation-flow in the management of fittings and the problems about those data of fittings and then brings out an aim and a pattern for the fittings-stock and the operation-flow about the storage management and also brings out a method for the fittings-data-reformation. We can see that, the paper has resolved the problem about the optimizing of the operation-flow of fittings-data-management and the problem of the conformity of those masses disperse fittings data. In the session of the analysis and coordination of those static data of fittings, on the basis of the reformed data of fittings, the paper establishes both a scientific classifying principle and also a rational coding system, which resolved the problem of the fittings-data- standardization. In order to control the actuality and the rate of overlapped codes, the paper has designed data-preparation programs and data-switch programs and data-checking ones through database programming technologies. At the end of the paper, the author gives us an analysis about the effect of the fittings data application.
The paper brings forward a suit of systematic method in the data preparation of fittings, and brings the fittings data preparation in the Hongta ERP project to a big success, without a guide of any ready-made theory or any succeeded precedent used for reference. And the method has acquired good effect. So, we can say, the method, that the paper brings forward, is feasible and advanced. It has its referent sense for the application of other parts of the Hongta ERP project, for the ERP project application of any other national enterprises and even any gigantic enterprises. In further, it even has its means for those data preparations of any big projects.
本文结合红塔实施ERP的实际情况，对企业配件的管理现状和数据现状进行了深入的调查和分析。着重研究了配件管理业务流程的重构和数据的重构、配件静态数据的分析整理及数据准备的实施技术。在配件管理业务流程和数据重构的研究中，深入分析了配件管理业务流程和数据现状存在的问题，提出了配件采购、库存管理业务流程重构的目标和模式，以及配件数据重构的方法，解决了配件管理业务流程的优化问题和分散的配件数据的整合问题。在对配件静态数据的分析整理及实施技术的研究中，基于重构后的配件数据，建立了科学合理的分类原则和编码体系，解决了配件数据的规范化和标准化问题，采用数据库编程技术，设计了数据准备、转换和检查程序，实现了对数据准确性和重码率的控制。最后分析了配件数据实施的效果。
本文的研究提出了一套系统的配件数据准备的方法，使红塔ERP配件数据准备在无现成的理论指导和成功先例借鉴情况下顺利完成，并取得良好效果，证明本文所提方法是可行的、先进的，它对红塔实施其它模块，对国企、大型企业实施ERP，以及任何大型管理项目的数据准备都具有借鉴意义。
One of the most difficult problems during the cause of the application of ERP in national enterprises is the preparation of fundamental data. Whether the data preparation is successful or failed is a key factor of whether the project will be succeeded or failed.
Integrating the practical complexion during the application of the Hongta ERP project, the author, in the dissertation, makes a deep investigation and analysis to the management-actuality and data-actuality of those fittings in Hongta. The dissertation works strictly over the operation-flow reformation and the data reformation during the management about those fittings, and also over the analysis and coordination about the data of those static ones. At the same time, the paper also stresses over the practical technique about the application of the data preparation. In the session of the operation-flow reformation and the data reformation, the paper analyses deeply the problems about the operation-flow in the management of fittings and the problems about those data of fittings and then brings out an aim and a pattern for the fittings-stock and the operation-flow about the storage management and also brings out a method for the fittings-data-reformation. We can see that, the paper has resolved the problem about the optimizing of the operation-flow of fittings-data-management and the problem of the conformity of those masses disperse fittings data. In the session of the analysis and coordination of those static data of fittings, on the basis of the reformed data of fittings, the paper establishes both a scientific classifying principle and also a rational coding system, which resolved the problem of the fittings-data- standardization. In order to control the actuality and the rate of overlapped codes, the paper has designed data-preparation programs and data-switch programs and data-checking ones through database programming technologies. At the end of the paper, the author gives us an analysis about the effect of the fittings data application.
The paper brings forward a suit of systematic method in the data preparation of fittings, and brings the fittings data preparation in the Hongta ERP project to a big success, without a guide of any ready-made theory or any succeeded precedent used for reference. And the method has acquired good effect. So, we can say, the method, that the paper brings forward, is feasible and advanced. It has its referent sense for the application of other parts of the Hongta ERP project, for the ERP project application of any other national enterprises and even any gigantic enterprises. In further, it even has its means for those data preparations of any big projects.
引文
[1] 烟草行业信息化建设背景资料．中国烟草在线．2002．1 1．
[2] 潘必兴．中国烟草发展报告(1949-1999)．北京工商出版社．1999
[3] 孙永、陈燕．运用ERP原理建设卷烟制造企业信息系统．烟草科技．2001．05潘必兴．中国烟草发展报告(1949 1999)．北京工商出版社．1999
[4] ERP and the Big Picture By Karen S. Gadson 原载于: APICS—The Performnce Advantage June 2001 Volume 11 NO. 6
[5] 廖雪珍、黎志成．卷烟生产企业物资供应管理探析．华中科技大学．2002．01
[6] 宋华、胡左浩．现代物流与供应链管理
[7] 王迎军、郭亚军．东北大学工商管理学院．供应链中的信息流．工业工程与管理．2000．3
[8] e—Coua boration Energizes the Heart of the Supply chain By George Schultz原载于: APICS—The Performance Advantage Jume 2001 Volume 11 NO. 6
[9] Good and Getting Better By Ajay Sharma原载于: APICS—The Performance Advantage May 2001 Volume 10 NO. 17
[10] Oliver W.Wight.Maugfacturing Resource Plenning. 1980
[11] Allen Mark K. and Omar Keith Helferich(1990).Putting EXPERT Systems to Work in logisics Counsil of Logitics M
[12] 国际管理趋势和我国企业管理创新．中国制造业信息化门户．2002
[13] 庄永耀、杨保建、王建中、黄洁．ERP在中国企业的应用与企业创新研究．企业资源研究中心．2003．01
[14] 余开朝、候开虎．我国制造业管理现状与E R P．昆明理工大学学报．1999．08
[15] 蒋明炜．中国制造业管理现代化之路．企业信息与管理现代化．1999．08
[16] 朱墨池、楼建忠、李瑞东．ERP失利原因之浅析．金华职业技术学院学报2001．06
[17] 周德荣．浅谈物资积压成因及其解决的途径．铜业工程．2000．01
[18] 刘鲁、张帮绪．信息系统设计原理与应用．北京．北京航空航天大学．1997年版
[19] 龚丁等．红塔ERP项目现状调研文档．云南．红塔集团．2002．05
[20] 彭雁虹．ERP实施与业务流程重组．工业工程与管理．200 1．06
[21] 蒋德强．包跃进．对现代企业应用业务流程重组的思考．慧眼聚焦．2002．06
[22] 饶艳超．从erp实施的角度看企业业务流程重组的重要性．江苏．上海会计．2001．03
[23] Hammer M Reengineering Work:Don't Automate[j]Harvard Business Review 1990.07
[24] Hammer M Champy Ⅰ Reengineering the Corporation Amanifesofor Business Revolution [M] New York Harper Collins. 1993
[25] 龚丁等．物料管理组织结构．云南．红塔集团．2002．08
[26] 龚丁等．红塔ERP项目未来业务蓝图文档．云南．红塔集团．2002．08
[27] J. Orlicy. Material Requirment Planning-The new way of Life in production and inventory management 1975
[28] 原型测试(ERP课程)．中国制造业信息化门户．2002
[29] Master data. sap. 1997.10
[30] Basics of procurement process, sap. 1997.10
[31] Hu Yah. Hong Yue-shan. The Base Data of the Successive Enterprise. (Hunan Computer Techmology Research Institiute, 410012)
[32] 高复先．企业信息化与数据环境的重建．大连海事大学信息系统工程研究所．2002
[33] ERP系统中库存管理的基本数据设置．企业资源研究中心．2001．11
[34] 吴智勇．ERP系统中的物料管理问题．计算机世界周报．2002．08
[35] 物料管理．企业资源研究中心．2002．09
[36] ERP实施顾问组．印刷业物料编码规则设计实践．广州今朝科技有限公司．2002．02
[37] 曹锦芳．信息系统分析与设计．北京．北京航空航天大学．1997
[38] R.G, murdatick," Management Information system:concepts and designs". prentice hall. 1980
[39] 海洋信息编码说明．中国制造业信息化门户．2002
[40] 周星．ERP系统上线前的数据输入．中国计算机报．1999年第30期
[41] Introduction to batch inout processions, sap. 1997.10
[42] 左小德等．我国企业MRPⅡ／系统应用调查．企业资源研究中心
[2] 潘必兴．中国烟草发展报告(1949-1999)．北京工商出版社．1999
[3] 孙永、陈燕．运用ERP原理建设卷烟制造企业信息系统．烟草科技．2001．05潘必兴．中国烟草发展报告(1949 1999)．北京工商出版社．1999
[4] ERP and the Big Picture By Karen S. Gadson 原载于: APICS—The Performnce Advantage June 2001 Volume 11 NO. 6
[5] 廖雪珍、黎志成．卷烟生产企业物资供应管理探析．华中科技大学．2002．01
[6] 宋华、胡左浩．现代物流与供应链管理
[7] 王迎军、郭亚军．东北大学工商管理学院．供应链中的信息流．工业工程与管理．2000．3
[8] e—Coua boration Energizes the Heart of the Supply chain By George Schultz原载于: APICS—The Performance Advantage Jume 2001 Volume 11 NO. 6
[9] Good and Getting Better By Ajay Sharma原载于: APICS—The Performance Advantage May 2001 Volume 10 NO. 17
[10] Oliver W.Wight.Maugfacturing Resource Plenning. 1980
[11] Allen Mark K. and Omar Keith Helferich(1990).Putting EXPERT Systems to Work in logisics Counsil of Logitics M
[12] 国际管理趋势和我国企业管理创新．中国制造业信息化门户．2002
[13] 庄永耀、杨保建、王建中、黄洁．ERP在中国企业的应用与企业创新研究．企业资源研究中心．2003．01
[14] 余开朝、候开虎．我国制造业管理现状与E R P．昆明理工大学学报．1999．08
[15] 蒋明炜．中国制造业管理现代化之路．企业信息与管理现代化．1999．08
[16] 朱墨池、楼建忠、李瑞东．ERP失利原因之浅析．金华职业技术学院学报2001．06
[17] 周德荣．浅谈物资积压成因及其解决的途径．铜业工程．2000．01
[18] 刘鲁、张帮绪．信息系统设计原理与应用．北京．北京航空航天大学．1997年版
[19] 龚丁等．红塔ERP项目现状调研文档．云南．红塔集团．2002．05
[20] 彭雁虹．ERP实施与业务流程重组．工业工程与管理．200 1．06
[21] 蒋德强．包跃进．对现代企业应用业务流程重组的思考．慧眼聚焦．2002．06
[22] 饶艳超．从erp实施的角度看企业业务流程重组的重要性．江苏．上海会计．2001．03
[23] Hammer M Reengineering Work:Don't Automate[j]Harvard Business Review 1990.07
[24] Hammer M Champy Ⅰ Reengineering the Corporation Amanifesofor Business Revolution [M] New York Harper Collins. 1993
[25] 龚丁等．物料管理组织结构．云南．红塔集团．2002．08
[26] 龚丁等．红塔ERP项目未来业务蓝图文档．云南．红塔集团．2002．08
[27] J. Orlicy. Material Requirment Planning-The new way of Life in production and inventory management 1975
[28] 原型测试(ERP课程)．中国制造业信息化门户．2002
[29] Master data. sap. 1997.10
[30] Basics of procurement process, sap. 1997.10
[31] Hu Yah. Hong Yue-shan. The Base Data of the Successive Enterprise. (Hunan Computer Techmology Research Institiute, 410012)
[32] 高复先．企业信息化与数据环境的重建．大连海事大学信息系统工程研究所．2002
[33] ERP系统中库存管理的基本数据设置．企业资源研究中心．2001．11
[34] 吴智勇．ERP系统中的物料管理问题．计算机世界周报．2002．08
[35] 物料管理．企业资源研究中心．2002．09
[36] ERP实施顾问组．印刷业物料编码规则设计实践．广州今朝科技有限公司．2002．02
[37] 曹锦芳．信息系统分析与设计．北京．北京航空航天大学．1997
[38] R.G, murdatick," Management Information system:concepts and designs". prentice hall. 1980
[39] 海洋信息编码说明．中国制造业信息化门户．2002
[40] 周星．ERP系统上线前的数据输入．中国计算机报．1999年第30期
[41] Introduction to batch inout processions, sap. 1997.10
[42] 左小德等．我国企业MRPⅡ／系统应用调查．企业资源研究中心