oracle erp 系统设计----圆珠笔制作流程 系统设计

ORACLEERP系统设计圆珠笔制作流程第一部分产品BOM设计BILLOFMATERIALPRODUCTSTRUCTURETREE实物产品A1A0A2BPFGA2A3BPRM1A2A4BPSUB1A6A5A7A8BPSUB2A10A0BPRM2A10A9A11BPRM3A13A12BPRM4A13A14BPRM5A6A5A3BPRM6A16A15BPRM7第二部分基本数据设置一、创建物料A18A17A20A21A19A22A23A24A25A26A28A29A27A30A31A32A34A35A33A36A37A38M2A28A29A27A30A31A32A34A40A39A41A42A44A43A20A46A45A47A26A48A49A50A41A42A50A51A36A37A41A42A521A53A41A42A20BPFGA54A55A56A57“A58A59”A60A61A54A62“MPS/MRP”A63A64A65A66“A67A68”A69A70“A71A72/A73A74A75”,A76A77A782A79A80A81A82A83A84M2A85A54A76A77A783A79A86A87A88A89A90A91A92BPSUB1A54BPSUB2A54A55A56A57“A93A72A81A94”A60A61A54A76A77A54A80A81A82A83A54A76A77A784A79A86A87A88A89A90A91A92BPRM1A95BPRM2A95BPRM3A95BPRM4A95BPRM5A95BPRM6A96BPRM7A54A55A56A57“A97A98A90A91”A60A61,A99“A97A98”A63A64A65A100A101“A102A103A104”A102A105A54A76A77A54A80A81A82A83A54A76A77A106A107A108A109A110A111A112A113A114A115A116A117A118A785A79A119A120A121A122二、创建物料清单A123A124BOMA125A126A127A128A129A130A131A132A130A131A132A130A131A1331A134A135A123A124A136A137A138A139BOMA140BPSUB1A141A142BPRM2,BPRM3,BPRM4,BPRM5A143BPSUB2A141A142BPRM6,BPRM7A144“A145A146”A147A148A149A150A151“BPSUB1”,“BPSUB2”BPSUB1“A152A153”A147A148A149A150A151“BPRM2”A154“BPRM3”A154“BPRM4”A154“BPRM5”A154A155A156A157A1581A159BPSUB2“A152A153”A147A150A151“BPRM6”A160“BPRM6”A160A155A156A1581A1612A162A163A164A165A166A167A168BOMA154A169A170A171A172A173A166A167A161BPSUB1,BPSUB2A162A174A175A172A176A177A146BPRM1A160A178“A145A146A179A180”A147“A181A182A183A184”A185A158“A186A187”A1613A162A188A189BOM三、创建设备A190A191A192A193A194A195A196A197A198A199A190A200A197A201A202A2031A204“A201A202”A205A206A207A208A209A210A211“BPRS”A212A213A214A215A216A217“A218A219”A220“A221A222”A223“A224A225”A220“HR”A226A227A228A229A230A231A232A233A234A235“WIPA236A237”A2382A239A240A241四、创建部门A242A243A244A245A246A247A248A249A250A251A242A252A249A253A254A2551A2“A253A254”A63A0A1A3A4“BPDN”A53A80A5A6A7A82A9A145A10A11A12A136A11A12A128A13A14A15A16A17A11A12“BPRS”A53A110A18A1281,A149A19“24A138A20A21A22”A233A24A25A26“A152A27”,“A28A29”A154A30A31A28A32NORMALDAILYSHIFTA34A334A35A71A36五、创建工序A44A37A38A42A39A40A41A50A125A43A44A45A50A157A46A125A47A481A49A51A52A54A55“BPSUB1”,“BPSUB2”A56A57A58A59A60A61A62A64A65A143A66A67A68A69A58A59A70A143A66“BPDN”A722A73A160A741A100A65“A162A75”A76A77A78A62A64A79A81“BPAS”A65A77A78A82A83A65A143A66A67A84A85A70A143A66“BPDN”A723A73A86A87“A62A64A88A89”A90“A88A89”A76A77A78A84A85A70A88A89“BPRS”A90A91“A165A92”A76A77A78A93A94A95A70A96A111A65“A168A97”A98A99“A170”A724A73A67A96A101A102A58A59A60A61A62A64A65A143A66A67A68A69A58A59A70A143A66“BPDN”A725A73A160A741A100A103“A162A75”A76A77A78A62A64A79A81“BPAF”A65A77A78A82A83A65A143A66A67A84A85A70A143A66“BPDN”六、创建工艺路线A104A105A106A107A108A109A112A113A114A115A104A116A113A114A115A104A116A1171A118A119A120A121A122A123A124A126A127A114A115A104A116“A107A108”A129A130A131A132“BPSUB1”A133“BPSUB1”“A134A135”A137A139A140A141A142A144A146“BPAS”A147A148A1502A151A153A155A156A158A159A161A163A164A166A167A169A171“A172A173”A174A175“BPFG”“A176A177”A178A179A180A181A182A183A184“BPAF”七、创建价目表A185A186A187A188A189A190A191A192A193A194A192A194A195A196A192A194A195A196A197A198A1991A200A201A202“CORPORATE”A203A204“CORPORATE”A205“A206A207A208”A209A210A211A208A212“A213A214A215A216”A217A218“A219A220A221A222”A212“A213A214A223”A224A225A226A213A227A214“BPFG”A203A203A225A226A228A229A230A2312A200A232A233第三部分具体实现过程一、创建销售订单A234A235A236A237A238A239A240A241A237A238A242A243A244A241A245A246A237A238A2471A248A249A250A251A252“BUSINESSWORLD”A2531608A254A2552A2A145A0A186A100A1A3A189A53A79“A171A4A5A6”A63A7A8A9A10A11“BPFG”A53A190A7A8A12A13A14A15A16A253A28A254A2553A2A145A0“A193A17A171A18”A2554A2A17A194A171A18A19A20A253A196A196A21A22A196A254二、创建预测A44A23A24A42A25A26A27A50A199A29A50A201A301A31A80A32A33A34A35A36A37A38“BPFS”A39A80A32A40A41A39A80A32A33A34A37A38“BPFC”A432A45A46A47“A48A49A51A52”,A54“A51A52”A115A55A56A57A58A59A60“BPFG”A61A62A64A65A66A673A68A69A70“A203A71A72A73”,A74A75A76A77A78A81A82A834A68A84A85三、定义主需求计划（MDS）A86A87A88A89A90A91A92A93MDSA93A132A94A951A96A97A98MDSA99A101A102“BPMDS”A103A104A105A106A107A1082A109A110A111四、装载MDSA112A113A114A116A117A118A119A120MDSA120A121A122/A123A124/A205A125A1261A127“A128A129A130A131”A133A134A135MDSA136A137“BPMDS”“A206A138A139A140”A154A141“A207A142A143A144”“A206A138A146A147”A154A141A148A149A142A150A151A143A144A152“BPFS”“A153A155”A156A157“A210A158A159A160”“A161A162A163A164”A156A157“A165A166”“A214A167”A156A157“A170”A168A169A172A173A174A214A167A175A161A176A219A177A175A178A1792A180A181A182A183A184A1793A180A181A182A185A187A188A223A191A192A195A197A198A200A202A204A198A202A198A208五、定义和运行MRPA228A209A211A197A212A213A215A216A217A229A218A220A221A222A224A225A217A226A227A1791A180A230A231A232A233A234A235A236MRPA237A226A227“BPMRP”A238A239A240A2412A242A243A244“A245A246”A247A248“A249A250”A251A252A253MDSA254A255“BPMDS”,A154A0“A168A1A2A3”A23“A69A4”A136A71A5A63A7A145A8“A234A9”A53“A101A10”A53“A221A11”A136A235A12A13“MRP”六、生成采购计划（释放计划单）A228A14A15A16A17A18A19A20A21MRPA22A24A25A26A21A27A28A29A301A31A32A33A34A35A36MRPA37A38“BPMRP”A39A40A41A42A302A31A43A44“A45A46”A47A48“A49A50”A51A16A52A54“A55A56A57A58A59”A60“A238A61”“A59A78”A62A63“A171A64A121A65”A60“A238A61”“A66A67A64”A62A63“A68A70”A60“A241A61”A72A73A74A75A76A58A59A68A70“BPRM1”,“BPRM7”A773A79A80A81“A82A83”A844A85A86A87“A88A89A90A91”A925A93A94A95“A96A97”七、生成生产工单（释放计划单）A98A99A100A102A103A104A105A106MRPA107A108A109A110A106A111A112A113A1141A115A116A117A118A119A120A122A123A124A125A126“BPMRP”A127A128A129A130A1312A115A132A133“A134A135”A137A138“A139A140”A141A142A143A144“A146A147A148A149A150”A151“A152A153”“A146A147”A155A156“A157A158A159A160”A151“A152A153”“A161A162A158”A155A156“A163A164”A151“A165A153”A166A167A169A170A172A149A150A163A164“BPFG”,“BPSUB2”A1733A174A175A176“A177A178”A1794A180A181A182“A183A184A185A186”A1875A188A189A190“A185A186”八、创建采购申请（PR）A191A191A192A193A194A195A196A197A198A199A200A201A199A200A201A2021A203A204A205“A206A207”A208“A209A210”A211A212A213A214A215A216A217A218A219A220A222A2232A224A225A226A227A229A230A231A232A233A227A229A236A237A239“BPRM1”,“BPRM2”,“BPRM3”A240“BPRM4”,“BPRM5”“BPRM6”,“BPRM7”A240A242A243A244A245A246A247A248A249A250A251A252A253A2543A255A28A0“A77A1”A24A3A79A4A43A5A81A57A82A6A7A8A61A25A3A9A10“A86A11”九、创建采购订单（PO）A44A44A12A13A14A45A15A16A17A18A88A19A20A21A21A3A90A22A45A15A23A93A26A24A25A27A20A21A29A45A15A30A31A57A82A6A7A8A61A22A3A96A32A33A34A30A31A35A93A9A10A88A19A93A36A37A38A96A32A100A39A40A41A42A105A46A47A46A48A49A40A41A105A50A39A51A43A105A52A48A49A53A41A40A93A79A54A115A55A81A57A117A117A8A6A61A23A3A62A56A9A10“A58A59”A93A60A35A62A63A93A64A65A66A67A68A69A1A5A47A43A24A3A77A1A25A3A9A10A86A11A26A3A26A70A71A72A73A74A75A76“A11A87”十、采购接收入库A78A80A83A84A85A89A91A92A120A94A92A120A94A951A97A98A99A101A102A103A104A106A106A107A108A109A110A111A112A113A952A97A114A116十一、查找并释放工单A118A118A78A80A83A119A121A122A89A91A92A133A123A92A133A123A124A125A951A97A126A127A98A99A128A129A130A110A111A112A131A132A134A122“BPSUB1”A135“BPSUB1”A135A119A136A137“A138A139”A140A141A142“A143A144A145A146”A147A148A149A150A151A1522A153A154A155A1523A153A156A157A150A151A158A159“BPFG”A160A161A162十二、进行生产A163A163A164A165A166A167A168A169A170A171A172A173A174A175A176A177A171A172A173A174A175A176A177A171A178A179A180A181A182A169A183A184A166A1851A186A187A188A161A162A189A178A190A191A192A192A190A180A193A194A195A196A197“BPSUB1”A198“BPSUB1”A198A187A188A199A189A200“A2