1 line
41 KiB
Plaintext
1 line
41 KiB
Plaintext
{"ID":"20250930211005-7ghezlf","Spec":"2","Type":"NodeDocument","Properties":{"id":"20250930211005-7ghezlf","title":"数据库设计","type":"doc","updated":"20251029131959"},"Children":[{"ID":"20251007080508-tfmqrnd","Type":"NodeParagraph","Properties":{"id":"20251007080508-tfmqrnd","updated":"20250930211014"}},{"ID":"20250930211015-578so97","Type":"NodeList","ListData":{},"Properties":{"id":"20250930211015-578so97","updated":"20251029094207"},"Children":[{"ID":"20250930211015-1ui7gvu","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250930211015-1ui7gvu","updated":"20251029094207"},"Children":[{"ID":"20250930211015-4bxs77f","Type":"NodeParagraph","Properties":{"id":"20250930211015-4bxs77f","updated":"20250930211015"},"Children":[{"Type":"NodeText","Data":"该数据库的设计逻辑"}]},{"ID":"20250930211015-au8af2f","Type":"NodeList","ListData":{},"Properties":{"id":"20250930211015-au8af2f","updated":"20251029094207"},"Children":[{"ID":"20250930211015-gzqmw58","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250930211015-gzqmw58","updated":"20251029093151"},"Children":[{"ID":"20250930211015-enx4aqq","Type":"NodeParagraph","Properties":{"id":"20250930211015-enx4aqq","updated":"20250930211015"},"Children":[{"Type":"NodeText","Data":"资料表两表"}]},{"ID":"20250930211015-03rjiji","Type":"NodeList","ListData":{},"Properties":{"id":"20250930211015-03rjiji","updated":"20251029093151"},"Children":[{"ID":"20250930211015-uts7wma","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250930211015-uts7wma","updated":"20251029093046"},"Children":[{"ID":"20250930211015-y1v6icn","Type":"NodeParagraph","Properties":{"id":"20250930211015-y1v6icn","updated":"20250930211015"},"Children":[{"Type":"NodeText","Data":"材料的BOM表，"}]},{"ID":"20250930211015-iq8s6lu","Type":"NodeList","ListData":{},"Properties":{"id":"20250930211015-iq8s6lu","updated":"20251029093046"},"Children":[{"ID":"20250930211015-1ikpxel","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250930211015-1ikpxel","updated":"20250930211015"},"Children":[{"ID":"20250930211015-hbo3ti6","Type":"NodeParagraph","Properties":{"id":"20250930211015-hbo3ti6","updated":"20250930211015"},"Children":[{"Type":"NodeText","Data":"主建料号，材料料号，用量"}]}]},{"ID":"20250930211015-fc0hz41","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250930211015-fc0hz41","updated":"20251029093046"},"Children":[{"ID":"20250930211015-o7bij6m","Type":"NodeParagraph","Properties":{"id":"20250930211015-o7bij6m","updated":"20251029093046"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeImage","Data":"span","Children":[{"Type":"NodeBang"},{"Type":"NodeOpenBracket"},{"Type":"NodeLinkText","Data":"image"},{"Type":"NodeCloseBracket"},{"Type":"NodeOpenParen"},{"Type":"NodeLinkDest","Data":"assets/image-20250915193420-l407qx6.png"},{"Type":"NodeCloseParen"}]},{"Type":"NodeText","Data":""}]}]}]}]},{"ID":"20250930211015-ywshwgx","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250930211015-ywshwgx","updated":"20251029093151"},"Children":[{"ID":"20250930211015-vcogzf2","Type":"NodeParagraph","Properties":{"id":"20250930211015-vcogzf2","updated":"20250930211015"},"Children":[{"Type":"NodeText","Data":"FORECAST"}]},{"ID":"20250930211015-ur7o3zj","Type":"NodeList","ListData":{},"Properties":{"id":"20250930211015-ur7o3zj","updated":"20251029093151"},"Children":[{"ID":"20250930211015-qvegpim","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250930211015-qvegpim","updated":"20250930211015"},"Children":[{"ID":"20250930211015-do24khx","Type":"NodeParagraph","Properties":{"id":"20250930211015-do24khx","updated":"20250930211015"},"Children":[{"Type":"NodeText","Data":"主建料号，LIC ,需求计划的日期"}]}]},{"ID":"20250930211015-x1d45et","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250930211015-x1d45et","updated":"20251029093151"},"Children":[{"ID":"20250930211015-f4gcv6g","Type":"NodeParagraph","Properties":{"id":"20250930211015-f4gcv6g","updated":"20251029093151"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeImage","Data":"span","Children":[{"Type":"NodeBang"},{"Type":"NodeOpenBracket"},{"Type":"NodeLinkText","Data":"image"},{"Type":"NodeCloseBracket"},{"Type":"NodeOpenParen"},{"Type":"NodeLinkDest","Data":"assets/image-20250915193441-h1lesmn.png"},{"Type":"NodeCloseParen"}]},{"Type":"NodeText","Data":""}]}]}]}]}]}]},{"ID":"20250930211015-qjtskte","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250930211015-qjtskte","updated":"20251029094207"},"Children":[{"ID":"20250930211015-10hcrzc","Type":"NodeParagraph","Properties":{"id":"20250930211015-10hcrzc","updated":"20250930211015"},"Children":[{"Type":"NodeText","Data":"查询三表"}]},{"ID":"20250930211015-h22to1n","Type":"NodeList","ListData":{},"Properties":{"id":"20250930211015-h22to1n","updated":"20251029094207"},"Children":[{"ID":"20250930211015-mya0774","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250930211015-mya0774","updated":"20251029093559"},"Children":[{"ID":"20250930211015-84jvlym","Type":"NodeParagraph","Properties":{"id":"20250930211015-84jvlym","updated":"20250930211015"},"Children":[{"Type":"NodeText","Data":"无BOM，链接两表，查询BOM表中是否有FORECAST中的主键料号"}]},{"ID":"20250930211015-zzh3a8y","Type":"NodeList","ListData":{},"Properties":{"id":"20250930211015-zzh3a8y","updated":"20251029093559"},"Children":[{"ID":"20250930211015-nhtivna","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250930211015-nhtivna","updated":"20251029093546"},"Children":[{"ID":"20250930211015-dsrvjk2","Type":"NodeParagraph","Properties":{"id":"20250930211015-dsrvjk2","updated":"20251029093546"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeImage","Data":"span","Children":[{"Type":"NodeBang"},{"Type":"NodeOpenBracket"},{"Type":"NodeLinkText","Data":"image"},{"Type":"NodeCloseBracket"},{"Type":"NodeOpenParen"},{"Type":"NodeLinkDest","Data":"assets/image-20250915193522-411uu60.png"},{"Type":"NodeCloseParen"}]},{"Type":"NodeText","Data":""}]}]},{"ID":"20250930211015-9c0d6sh","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250930211015-9c0d6sh","updated":"20251029093559"},"Children":[{"ID":"20250930211015-b9eu2um","Type":"NodeParagraph","Properties":{"id":"20250930211015-b9eu2um","updated":"20251029093559"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeImage","Data":"span","Children":[{"Type":"NodeBang"},{"Type":"NodeOpenBracket"},{"Type":"NodeLinkText","Data":"image"},{"Type":"NodeCloseBracket"},{"Type":"NodeOpenParen"},{"Type":"NodeLinkDest","Data":"assets/image-20250915193639-u898344.png"},{"Type":"NodeCloseParen"}]},{"Type":"NodeText","Data":""}]}]}]}]},{"ID":"20250930211015-971gx9d","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250930211015-971gx9d","updated":"20251029093905"},"Children":[{"ID":"20250930211015-iet2cc2","Type":"NodeParagraph","Properties":{"id":"20250930211015-iet2cc2","updated":"20250930211015"},"Children":[{"Type":"NodeText","Data":" 表MS塑料件，"}]},{"ID":"20250930211015-y1xo2fa","Type":"NodeList","ListData":{},"Properties":{"id":"20250930211015-y1xo2fa","updated":"20251029093905"},"Children":[{"ID":"20250930211015-p8tzwz0","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250930211015-p8tzwz0","updated":"20250930211015"},"Children":[{"ID":"20250930211015-u1b5xnj","Type":"NodeParagraph","Properties":{"id":"20250930211015-u1b5xnj","updated":"20250930211015"},"Children":[{"Type":"NodeText","Data":"链接两表，主键料号，LIC，材料号，需求计划的日期x"},{"Type":"NodeTextMark","TextMarkType":"em","TextMarkTextContent":"用量xLIC"},{"Type":"NodeText","Data":"，为总计做预处理，因为有些料是共用的"}]}]},{"ID":"20250930211015-bt1a5qh","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250930211015-bt1a5qh","updated":"20251029093841"},"Children":[{"ID":"20250930211015-68ctfe8","Type":"NodeParagraph","Properties":{"id":"20250930211015-68ctfe8","updated":"20251029093841"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeImage","Data":"span","Children":[{"Type":"NodeBang"},{"Type":"NodeOpenBracket"},{"Type":"NodeLinkText","Data":"image"},{"Type":"NodeCloseBracket"},{"Type":"NodeOpenParen"},{"Type":"NodeLinkDest","Data":"assets/image-20250915193541-61t3szl.png"},{"Type":"NodeCloseParen"}]},{"Type":"NodeText","Data":""}]}]},{"ID":"20250930211015-g1fc2dy","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250930211015-g1fc2dy","updated":"20251029093905"},"Children":[{"ID":"20250930211015-q462epr","Type":"NodeParagraph","Properties":{"id":"20250930211015-q462epr","updated":"20251029093905"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeImage","Data":"span","Children":[{"Type":"NodeBang"},{"Type":"NodeOpenBracket"},{"Type":"NodeLinkText","Data":"image"},{"Type":"NodeCloseBracket"},{"Type":"NodeOpenParen"},{"Type":"NodeLinkDest","Data":"assets/image-20250915193714-9vflbtk.png"},{"Type":"NodeCloseParen"}]},{"Type":"NodeText","Data":""}]}]}]}]},{"ID":"20250930211015-xyh5wb7","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250930211015-xyh5wb7","updated":"20251029094207"},"Children":[{"ID":"20250930211015-2e24ot5","Type":"NodeParagraph","Properties":{"id":"20250930211015-2e24ot5","updated":"20250930211015"},"Children":[{"Type":"NodeText","Data":"表MS塑料件总计"}]},{"ID":"20250930211015-pm3gxwg","Type":"NodeList","ListData":{},"Properties":{"id":"20250930211015-pm3gxwg","updated":"20251029094207"},"Children":[{"ID":"20250930211015-a7j5tkp","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250930211015-a7j5tkp","updated":"20251029094150"},"Children":[{"ID":"20250930211015-ixt79g7","Type":"NodeParagraph","Properties":{"id":"20250930211015-ixt79g7","updated":"20250930211015"},"Children":[{"Type":"NodeText","Data":"材料料号，需求计划的日期的材料用量，主要是对材料料号进行一个分组计数"}]},{"ID":"20250930211015-ru5ps24","Type":"NodeParagraph","Properties":{"id":"20250930211015-ru5ps24","updated":"20251029094150"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeImage","Data":"span","Children":[{"Type":"NodeBang"},{"Type":"NodeOpenBracket"},{"Type":"NodeLinkText","Data":"image"},{"Type":"NodeCloseBracket"},{"Type":"NodeOpenParen"},{"Type":"NodeLinkDest","Data":"assets/image-20250915193604-mq2np4m.png"},{"Type":"NodeCloseParen"}]},{"Type":"NodeText","Data":""}]}]},{"ID":"20250930211015-8uqg5se","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20250930211015-8uqg5se","updated":"20251029094207"},"Children":[{"ID":"20250930211015-f4fvff9","Type":"NodeParagraph","Properties":{"id":"20250930211015-f4fvff9","updated":"20251029094207"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeImage","Data":"span","Children":[{"Type":"NodeBang"},{"Type":"NodeOpenBracket"},{"Type":"NodeLinkText","Data":"image"},{"Type":"NodeCloseBracket"},{"Type":"NodeOpenParen"},{"Type":"NodeLinkDest","Data":"assets/image-20250915193746-259lb6v.png"},{"Type":"NodeCloseParen"}]},{"Type":"NodeText","Data":""}]}]}]}]}]}]}]}]}]},{"ID":"20251029095541-2zrvnyb","Type":"NodeParagraph","Properties":{"id":"20251029095541-2zrvnyb","updated":"20251029095541"},"Children":[{"Type":"NodeText","Data":"您指出的非常对，感谢您的纠正。根据您的提醒和图片中的表结构，这里确实应该是单字段主键。我重新优化了描述，确保准确反映您的设计。"}]},{"ID":"20251029095541-bp1l31x","Type":"NodeThematicBreak","Properties":{"id":"20251029095541-bp1l31x","updated":"20251029095541"}},{"ID":"20251029095541-56k742h","Type":"NodeHeading","HeadingLevel":3,"Properties":{"id":"20251029095541-56k742h","updated":"20251029095541"},"Children":[{"Type":"NodeText","Data":"优化后的描述（修正版）"}]},{"ID":"20251029095541-5uimkn2","Type":"NodeHeading","HeadingLevel":4,"Properties":{"id":"20251029095541-5uimkn2","updated":"20251029095541"},"Children":[{"Type":"NodeText","Data":"一、 数据库表设计"}]},{"ID":"20251029095541-5dubx38","Type":"NodeParagraph","Properties":{"id":"20251029095541-5dubx38","updated":"20251029095541"},"Children":[{"Type":"NodeText","Data":"现有两个核心数据表："}]},{"ID":"20251029095541-yyxya1o","Type":"NodeList","ListData":{"Typ":1},"Properties":{"id":"20251029095541-yyxya1o","updated":"20251029095541"},"Children":[{"ID":"20251029095541-4yd9pye","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"MS4=","Num":1},"Properties":{"id":"20251029095541-4yd9pye","updated":"20251029095541"},"Children":[{"ID":"20251029095541-3f09uyy","Type":"NodeParagraph","Properties":{"id":"20251029095541-3f09uyy","updated":"20251029095541"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"材料BOM表"}]},{"ID":"20251029095541-g1tsq97","Type":"NodeList","ListData":{},"Properties":{"id":"20251029095541-g1tsq97","updated":"20251029095541"},"Children":[{"ID":"20251029095541-usnpmyq","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20251029095541-usnpmyq","updated":"20251029095541"},"Children":[{"ID":"20251029095541-r5lh1lc","Type":"NodeParagraph","Properties":{"id":"20251029095541-r5lh1lc","updated":"20251029095541"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"用途"},{"Type":"NodeText","Data":"：记录产品的物料清单结构，明确每个成品所需的原材料及用量。"}]}]},{"ID":"20251029095541-iu4t8p9","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20251029095541-iu4t8p9","updated":"20251029095541"},"Children":[{"ID":"20251029095541-udym404","Type":"NodeParagraph","Properties":{"id":"20251029095541-udym404","updated":"20251029095541"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"核心字段"},{"Type":"NodeText","Data":"："},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"主料号"},{"Type":"NodeText","Data":"（即成品料号，作为主键）、"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"材料料号"},{"Type":"NodeText","Data":"（原材料编号）、"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"用量"},{"Type":"NodeText","Data":"。"}]}]},{"ID":"20251029095541-gvclasn","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20251029095541-gvclasn","updated":"20251029095541"},"Children":[{"ID":"20251029095541-bwi7hjz","Type":"NodeParagraph","Properties":{"id":"20251029095541-bwi7hjz","updated":"20251029095541"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"说明"},{"Type":"NodeText","Data":"：此表以"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"主料号"},{"Type":"NodeText","Data":"为主键，意味着每个成品在此表中对应一条或多条记录，详细列出其组成原材料。"}]}]}]}]},{"ID":"20251029095541-ohyhxn8","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"Mi4=","Num":2},"Properties":{"id":"20251029095541-ohyhxn8","updated":"20251029095541"},"Children":[{"ID":"20251029095541-fv07n68","Type":"NodeParagraph","Properties":{"id":"20251029095541-fv07n68","updated":"20251029095541"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"需求预测表"}]},{"ID":"20251029095541-at4khe2","Type":"NodeList","ListData":{},"Properties":{"id":"20251029095541-at4khe2","updated":"20251029095541"},"Children":[{"ID":"20251029095541-qv7scuv","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20251029095541-qv7scuv","updated":"20251029095541"},"Children":[{"ID":"20251029095541-2gfpbq6","Type":"NodeParagraph","Properties":{"id":"20251029095541-2gfpbq6","updated":"20251029095541"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"用途"},{"Type":"NodeText","Data":"：记录针对特定成品（主料号）的未来需求计划。"}]}]},{"ID":"20251029095541-nr6qj8d","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20251029095541-nr6qj8d","updated":"20251029095541"},"Children":[{"ID":"20251029095541-aid88qi","Type":"NodeParagraph","Properties":{"id":"20251029095541-aid88qi","updated":"20251029095541"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"核心字段"},{"Type":"NodeText","Data":"："},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"主料号"},{"Type":"NodeText","Data":"、"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"LIC"},{"Type":"NodeText","Data":"（计划数量）、"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"需求日期"},{"Type":"NodeText","Data":"。"}]}]},{"ID":"20251029095541-f4gxhc4","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20251029095541-f4gxhc4","updated":"20251029095541"},"Children":[{"ID":"20251029095541-4u53ryu","Type":"NodeParagraph","Properties":{"id":"20251029095541-4u53ryu","updated":"20251029095541"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"说明"},{"Type":"NodeText","Data":"：该表的主键应为能唯一标识一条预测记录的字段或字段组合（如"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"主料号"},{"Type":"NodeText","Data":"+"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"需求日期"},{"Type":"NodeText","Data":"）。"}]}]}]}]}]},{"ID":"20251029095541-k0m06ts","Type":"NodeHeading","HeadingLevel":4,"Properties":{"id":"20251029095541-k0m06ts","updated":"20251029111753"},"Children":[{"Type":"NodeText","Data":"二、 数据查询与处理流程"}]},{"ID":"20251029095541-hjovfq5","Type":"NodeParagraph","Properties":{"id":"20251029095541-hjovfq5","updated":"20251029095541"},"Children":[{"Type":"NodeText","Data":"基于上述两表，通过关联查询进行需求分解，生成三个核心视图或结果集："}]},{"ID":"20251029095541-j4gu0tf","Type":"NodeList","ListData":{"Typ":1},"Properties":{"id":"20251029095541-j4gu0tf","updated":"20251029095541"},"Children":[{"ID":"20251029095541-kxnl1vn","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"MS4=","Num":1},"Properties":{"id":"20251029095541-kxnl1vn","updated":"20251029095541"},"Children":[{"ID":"20251029095541-1cqt371","Type":"NodeParagraph","Properties":{"id":"20251029095541-1cqt371","updated":"20251029095541"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"无效BOM检查查询"}]},{"ID":"20251029095541-83qya7f","Type":"NodeList","ListData":{},"Properties":{"id":"20251029095541-83qya7f","updated":"20251029095541"},"Children":[{"ID":"20251029095541-xtiv028","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20251029095541-xtiv028","updated":"20251029095541"},"Children":[{"ID":"20251029095541-zrq1e0j","Type":"NodeParagraph","Properties":{"id":"20251029095541-zrq1e0j","updated":"20251029095541"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"目的"},{"Type":"NodeText","Data":"：数据质量校验。用于识别"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"需求预测表"},{"Type":"NodeText","Data":"中存在，但"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"材料BOM表"},{"Type":"NodeText","Data":"中未定义物料清单的成品"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"主料号"},{"Type":"NodeText","Data":"。"}]}]},{"ID":"20251029095541-01exny6","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20251029095541-01exny6","updated":"20251029095541"},"Children":[{"ID":"20251029095541-lblizgb","Type":"NodeParagraph","Properties":{"id":"20251029095541-lblizgb","updated":"20251029095541"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"逻辑"},{"Type":"NodeText","Data":"：使用左连接，以"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"需求预测表"},{"Type":"NodeText","Data":"为主表关联"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"材料BOM表"},{"Type":"NodeText","Data":"，筛选出BOM表中对应记录为空的"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"主料号"},{"Type":"NodeText","Data":"，这些料号无法进行需求分解。"}]}]}]}]},{"ID":"20251029095541-lw01f4p","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"Mi4=","Num":2},"Properties":{"id":"20251029095541-lw01f4p","updated":"20251029095541"},"Children":[{"ID":"20251029095541-e20fil1","Type":"NodeParagraph","Properties":{"id":"20251029095541-e20fil1","updated":"20251029095541"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"物料需求明细计算"}]},{"ID":"20251029095541-v3bnbr9","Type":"NodeList","ListData":{},"Properties":{"id":"20251029095541-v3bnbr9","updated":"20251029095541"},"Children":[{"ID":"20251029095541-n1axzur","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20251029095541-n1axzur","updated":"20251029095541"},"Children":[{"ID":"20251029095541-pm9cigt","Type":"NodeParagraph","Properties":{"id":"20251029095541-pm9cigt","updated":"20251029095541"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"目的"},{"Type":"NodeText","Data":"：将成品级的需求计划（LIC）分解为原材料级别的详细需求。"}]}]},{"ID":"20251029095541-nv5v762","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20251029095541-nv5v762","updated":"20251029095541"},"Children":[{"ID":"20251029095541-mzj8ays","Type":"NodeParagraph","Properties":{"id":"20251029095541-mzj8ays","updated":"20251029095541"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"逻辑"},{"Type":"NodeText","Data":"：内连接"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"需求预测表"},{"Type":"NodeText","Data":"和"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"材料BOM表"},{"Type":"NodeText","Data":"，通过 "},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"LIC * 用量"},{"Type":"NodeText","Data":" 计算出每个成品需求所对应的每一种原材料的"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"计划需求量"},{"Type":"NodeText","Data":"。此结果为后续汇总提供明细数据。"}]}]}]}]},{"ID":"20251029095541-c4wmegi","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"My4=","Num":3},"Properties":{"id":"20251029095541-c4wmegi","updated":"20251029095541"},"Children":[{"ID":"20251029095541-5465148","Type":"NodeParagraph","Properties":{"id":"20251029095541-5465148","updated":"20251029095541"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"物料需求汇总"}]},{"ID":"20251029095541-gf78uny","Type":"NodeList","ListData":{},"Properties":{"id":"20251029095541-gf78uny","updated":"20251029095541"},"Children":[{"ID":"20251029095541-f2nq829","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20251029095541-f2nq829","updated":"20251029095541"},"Children":[{"ID":"20251029095541-pp3xtli","Type":"NodeParagraph","Properties":{"id":"20251029095541-pp3xtli","updated":"20251029095541"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"目的"},{"Type":"NodeText","Data":"：按原材料编号汇总总需求量。由于同一种原材料可能被多种成品使用，此步骤可消除重复，得到最终采购或生产所需的准确数量。"}]}]},{"ID":"20251029095541-b95rpcy","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20251029095541-b95rpcy","updated":"20251029095541"},"Children":[{"ID":"20251029095541-7o2p08f","Type":"NodeParagraph","Properties":{"id":"20251029095541-7o2p08f","updated":"20251029095541"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"逻辑"},{"Type":"NodeText","Data":"：对"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"物料需求明细"},{"Type":"NodeText","Data":"结果按"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"材料料号"},{"Type":"NodeText","Data":"进行分组，并对"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"计划需求量"},{"Type":"NodeText","Data":"字段执行求和操作，得到每个"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"材料料号"},{"Type":"NodeText","Data":"的"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"总需求计划用量"},{"Type":"NodeText","Data":"。"}]}]}]}]}]},{"ID":"20251029095541-2t45na6","Type":"NodeThematicBreak","Properties":{"id":"20251029095541-2t45na6","updated":"20251029095541"}},{"ID":"20251029095541-15ww5sa","Type":"NodeParagraph","Properties":{"id":"20251029095541-15ww5sa","updated":"20251029095541"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"核心修正点"},{"Type":"NodeText","Data":"：\n已根据您的指正，将BOM表的主键明确描述为单一的"},{"Type":"NodeTextMark","TextMarkType":"code","TextMarkTextContent":"主料号"},{"Type":"NodeText","Data":"（成品料号），并相应调整了关联逻辑的描述，使其与您的设计完全吻合。"}]},{"ID":"20251029103620-4xceipv","Type":"NodeParagraph","Properties":{"id":"20251029103620-4xceipv","updated":"20251029103620"}},{"ID":"20251029103621-ksqesfp","Type":"NodeParagraph","Properties":{"id":"20251029103621-ksqesfp","updated":"20251029103625"},"Children":[{"Type":"NodeText","Data":""},{"Type":"NodeImage","Data":"span","Children":[{"Type":"NodeBang"},{"Type":"NodeOpenBracket"},{"Type":"NodeLinkText"},{"Type":"NodeCloseBracket"},{"Type":"NodeOpenParen"},{"Type":"NodeLinkDest","Data":"http://162.211.228.232:28888/i/2025/10/29/69017da88dc1a.png"},{"Type":"NodeCloseParen"}]},{"Type":"NodeText","Data":""}]},{"ID":"20251029111753-jswv4at","Type":"NodeParagraph","Properties":{"id":"20251029111753-jswv4at","updated":"20251029111753"},"Children":[{"Type":"NodeText","Data":"好的，我们来将Excel VBA和MS Access在您特定场景下的优劣进行一次清晰的对比总结。"}]},{"ID":"20251029111753-rg1hu7c","Type":"NodeHeading","HeadingLevel":3,"Properties":{"id":"20251029111753-rg1hu7c","updated":"20251029111753"},"Children":[{"Type":"NodeText","Data":"Excel VBA vs. MS Access 终极对比（基于您的场景）"}]},{"ID":"20251029111753-sfxrh2y","Type":"NodeParagraph","Properties":{"id":"20251029111753-sfxrh2y","updated":"20251029111753"},"Children":[{"Type":"NodeText","Data":"下表直观对比了两种方案在您 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"“无需协作，数据量9万行”"},{"Type":"NodeText","Data":" 这一核心场景下的表现："}]},{"ID":"20251029111753-ctw749d","Type":"NodeTable","TableAligns":[1,1,1,1],"Properties":{"colgroup":"|||","id":"20251029111753-ctw749d","updated":"20251029111753"},"Children":[{"Type":"NodeTableHead","Data":"thead","Children":[{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"th","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"特性"}]},{"Type":"NodeTableCell","Data":"th","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"Excel VBA 方案"}]},{"Type":"NodeTableCell","Data":"th","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"MS Access 方案"}]},{"Type":"NodeTableCell","Data":"th","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"场景适配度胜出方"}]}]}]},{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"数据容量 (9万行)"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"✅ "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"足够胜任"},{"Type":"NodeText","Data":" (未达104万行上限)"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"✅ "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"游刃有余"},{"Type":"NodeText","Data":" (处理能力更强)"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"平手"},{"Type":"NodeText","Data":" (两者均能满足)"}]}]},{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"开发与学习成本"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"✅ "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"极低"},{"Type":"NodeText","Data":" (您已开发完成，团队熟悉Excel)"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"❌ "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"高"},{"Type":"NodeText","Data":" (需学习数据库概念与SQL)"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"Excel VBA"}]}]},{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"部署与使用便捷性"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"✅ "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"极高"},{"Type":"NodeText","Data":" (发送文件即可使用)"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"❌ "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"较麻烦"},{"Type":"NodeText","Data":" (需确保安装Access)"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"Excel VBA"}]}]},{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"核心需求：协作性"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"❌ "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"差"},{"Type":"NodeText","Data":" (但您不需要)"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"✅ "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"优"},{"Type":"NodeText","Data":" (但您不需要)"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"无关紧要"}]}]},{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"数据处理性能"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"⚠️ "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"良好"},{"Type":"NodeText","Data":" (数组/字典优化后可行，稍慢)"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"✅ "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"优异"},{"Type":"NodeText","Data":" (SQL引擎原生优化，极快)"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"Access略优，但优势不关键"}]}]},{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"数据严谨性/完整性"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"❌ "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"较弱"},{"Type":"NodeText","Data":" (依赖代码校验)"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"✅ "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"极强"},{"Type":"NodeText","Data":" (有主键、外键等约束)"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"Access优，但非您当前刚需"}]}]},{"Type":"NodeTableRow","Data":"tr","Children":[{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"长期可维护性"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"⚠️ "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"中等"},{"Type":"NodeText","Data":" (代码需注释清晰)"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeText","Data":"✅ "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"更高"},{"Type":"NodeText","Data":" (表-查询-界面逻辑分离)"}]},{"Type":"NodeTableCell","Data":"td","TableCellAlign":1,"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"Access略优"}]}]}]},{"ID":"20251029111753-pxpdcy1","Type":"NodeThematicBreak","Properties":{"id":"20251029111753-pxpdcy1","updated":"20251029111753"}},{"ID":"20251029111753-ot72eia","Type":"NodeHeading","HeadingLevel":3,"Properties":{"id":"20251029111753-ot72eia","updated":"20251029131959"},"Children":[{"Type":"NodeText","Data":"结论与最终建议"}]},{"ID":"20251029111753-06e6yur","Type":"NodeParagraph","Properties":{"id":"20251029111753-06e6yur","updated":"20251029111753"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"首选推荐：继续使用并优化现有的 Excel VBA 方案"}]},{"ID":"20251029111753-8dfndhu","Type":"NodeParagraph","Properties":{"id":"20251029111753-8dfndhu","updated":"20251029111753"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"理由如下："}]},{"ID":"20251029111753-cuwg05k","Type":"NodeList","ListData":{"Typ":1},"Properties":{"id":"20251029111753-cuwg05k","updated":"20251029111753"},"Children":[{"ID":"20251029111753-yhqub2t","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"MS4=","Num":1},"Properties":{"id":"20251029111753-yhqub2t","updated":"20251029111753"},"Children":[{"ID":"20251029111753-49zadyk","Type":"NodeParagraph","Properties":{"id":"20251029111753-49zadyk","updated":"20251029111753"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"性价比最高"},{"Type":"NodeText","Data":"：您已经完成了最关键的开发工作，"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"“无需协作”"},{"Type":"NodeText","Data":" 这个条件直接抹杀了Access最大的优势。为了一个用不到的优势和并不关键的性能提升，去投入全新的学习和开发，是典型的资源浪费。"}]}]},{"ID":"20251029111753-b6rx1bf","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"Mi4=","Num":2},"Properties":{"id":"20251029111753-b6rx1bf","updated":"20251029111753"},"Children":[{"ID":"20251029111753-gqiz0cg","Type":"NodeParagraph","Properties":{"id":"20251029111753-gqiz0cg","updated":"20251029111753"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"恰到好处"},{"Type":"NodeText","Data":"：9万行的数据量正处于Excel VBA能够有效处理的“甜蜜点”内。您的代码已经使用了"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"数组和字典"},{"Type":"NodeText","Data":"进行优化，这代表了良好的实践，足够应对当前需求。"}]}]},{"ID":"20251029111753-rycemhv","Type":"NodeListItem","ListData":{"Typ":1,"Delimiter":46,"Marker":"My4=","Num":3},"Properties":{"id":"20251029111753-rycemhv","updated":"20251029111753"},"Children":[{"ID":"20251029111753-o14284j","Type":"NodeParagraph","Properties":{"id":"20251029111753-o14284j","updated":"20251029111753"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"敏捷与便捷"},{"Type":"NodeText","Data":"：在小型团队中，解决方案的易用性和部署便捷性至关重要。Excel文件无疑是最佳选择。"}]}]}]},{"ID":"20251029111753-m7rrese","Type":"NodeParagraph","Properties":{"id":"20251029111753-m7rrese","updated":"20251029111753"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"何时需要考虑从 Excel VBA 迁移到 MS Access？"}]},{"ID":"20251029111753-vbzisyu","Type":"NodeParagraph","Properties":{"id":"20251029111753-vbzisyu","updated":"20251029111753"},"Children":[{"Type":"NodeText","Data":"请将Access视为您的 "},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"“升级预案”"},{"Type":"NodeText","Data":" 。当出现以下情况时，才值得考虑迁移："}]},{"ID":"20251029111753-v9mqxfb","Type":"NodeList","ListData":{},"Properties":{"id":"20251029111753-v9mqxfb","updated":"20251029111753"},"Children":[{"ID":"20251029111753-x7sdfl5","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20251029111753-x7sdfl5","updated":"20251029111753"},"Children":[{"ID":"20251029111753-tuyqk81","Type":"NodeParagraph","Properties":{"id":"20251029111753-tuyqk81","updated":"20251029111753"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"数据行数爆发式增长"},{"Type":"NodeText","Data":"，接近或超过50万行，导致VBA计算时间无法忍受（例如超过10分钟）。"}]}]},{"ID":"20251029111753-p7uezsb","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20251029111753-p7uezsb","updated":"20251029111753"},"Children":[{"ID":"20251029111753-gysydfk","Type":"NodeParagraph","Properties":{"id":"20251029111753-gysydfk","updated":"20251029111753"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"未来业务要求真正的多用户同时编辑和更新"},{"Type":"NodeText","Data":"数据。"}]}]},{"ID":"20251029111753-ds8sftw","Type":"NodeListItem","ListData":{"BulletChar":42,"Marker":"Kg=="},"Properties":{"id":"20251029111753-ds8sftw","updated":"20251029111753"},"Children":[{"ID":"20251029111753-teg6tsd","Type":"NodeParagraph","Properties":{"id":"20251029111753-teg6tsd","updated":"20251029111753"},"Children":[{"Type":"NodeText","Data":"对"},{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"数据录入的规范性和准确性"},{"Type":"NodeText","Data":"要求变得极高，必须通过数据库约束来强制保证。"}]}]}]},{"ID":"20251029111753-0cyj57h","Type":"NodeParagraph","Properties":{"id":"20251029111753-0cyj57h","updated":"20251029111753"},"Children":[{"Type":"NodeTextMark","TextMarkType":"strong","TextMarkTextContent":"总结一句话：对于您当前的需求，继续使用Excel VBA是明智、高效且完全正确的选择。"}]},{"ID":"20251029131959-pzo88hu","Type":"NodeParagraph","Properties":{"id":"20251029131959-pzo88hu","updated":"20251029131959"},"Children":[{"Type":"NodeText","Data":"•业务需求：每月需依据SAP 导出的完整BOM（约8 万行）和Forecast数据，计算成品对应的物料需求。"}]},{"ID":"20251029131959-jbl2kd3","Type":"NodeParagraph","Properties":{"id":"20251029131959-jbl2kd3","updated":"20251029131959"},"Children":[{"Type":"NodeText","Data":"•技术障碍：负责该计算的Access 2003数据库已无法在公司的Windows环境中安装运行，只有少数老电脑（特定硬件/系统）才能打开。"}]},{"ID":"20251029131959-gikyyk8","Type":"NodeParagraph","Properties":{"id":"20251029131959-gikyyk8","updated":"20251029131959"},"Children":[{"Type":"NodeText","Data":"•风险与成本："}]},{"ID":"20251029131959-gyfoy86","Type":"NodeParagraph","Properties":{"id":"20251029131959-gyfoy86","updated":"20251029131959"},"Children":[{"Type":"NodeText","Data":"◦单点故障：一旦该专用电脑出现硬件或系统问题，整个物料需求计算流程立即中断，直接影响生产计划。"}]},{"ID":"20251029131959-e5zm6qq","Type":"NodeParagraph","Properties":{"id":"20251029131959-e5zm6qq","updated":"20251029131959"},"Children":[{"Type":"NodeText","Data":"◦操作不便：所有使用者必须到指定电脑前手工操作，导致工作效率低下、协作受限。"}]},{"ID":"20251029131959-pc3316w","Type":"NodeParagraph","Properties":{"id":"20251029131959-pc3316w","updated":"20251029131959"},"Children":[{"Type":"NodeText","Data":"3 潜在费用：若采用官方推荐的新版Access进行迁移，需额外购买软件授权（约2百多元 /月/人），并需额外购买2007版本用来进行的文件转换。"}]}]} |