摘要
物料清单(BOM)是ERP系统中极其重要的部分。制药行业的BOM除了具有BOM的通用性外,还具有本身的特点。该文在分析制药行业BOM特点的基础上,介绍了适合制药行业BOM的合理的数据库设计和高效的物料低位码计算算法、成品分解算法和任务分解算法,采用存储过程实现。
The Bill of Materials (BOM) plays a very important role in ERP system. The BOM used in pharmacy has its own features beyond the general ones. Based on analyzing its characteristic, this thesis introduces the sound design of database system about pharmacy BOM and efficient algorithms of calculating materials' low level code, disassembling products and disassembling tasks. The algorithms are implemented as store procedures.
出处
《计算机工程》
EI
CAS
CSCD
北大核心
2006年第1期270-272,共3页
Computer Engineering
基金
浙江省重大科技攻关计划资助项目(2003C11009)
上海市科委科技攻关计划资助项目(03DZ19320)