摘要： 物料清单（BOM）是ERP 系统中极其重要的部分。制药行业的BOM 除了具有BOM 的通用性外，还具有本身的特点。该文在分析制药行业BOM 特点的基础上，介绍了适合制药行业BOM 的合理的数据库设计和高效的物料低位码计算算法、成品分解算法和任务分解算法，采用存储过程实现。

关键词: 物料清单；企业资源计划；物料需求计划；制药行业；存储过程

Abstract: The Bill of Materials (BOM) plays a very important role in ERP system. The BOM used in pharmacy has its own features beyond thegeneral ones. Based on analyzing its characteristic, this thesis introduces the sound design of database system about pharmacy BOM and efficientalgorithms of calculating materials’ low level code, disassembling products and disassembling tasks. The algorithms are implemented as storeprocedures.

Key words: Bill of materials (BOM); ERP; MRP; Pharmacy; Store procedure