ERP 延期交货：数据模型参考？
我的问题是：您知道 ERP 数据库设计有什么真正好的参考资料（书籍、网络）吗？
我使用 Sql Server 作为后端构建了一个 ERP。客户文档有不同类型（还有供应商文档）：
- 订单 -- 影响：延期交货 (BO)
- 交货单（也用于退货，数量为负） --影响：BO、库存
- 发票 --影响：仅限会计
- 贷方注释 --影响：会计、BO
BO 跟踪非常复杂，并且涉及不同文档之间的跟踪链接：想象一下，一位回头客多次订购了 10 个参考单位 X：哪个交货填充了哪个订单？如果有 5 个单位的参考 X 的贷方票据，对 BO 有影响吗？哪个订单？ （这些只是例子）
My question is: do you know of any real good reference (book, web) for ERP database design ?
I have built an ERP using Sql Server as a back-end. There are different types of Client documents (there are also Supplier Docs):
- Order -- impact: Back-Orders (BO)
- Delivery Note (also used for returns, with negative quantity) --impact: BO, Stock
- Invoice --impact: accounting only
- Credit Note --impact: accounting, BO
BO tracking is very complex, and involves tracking links between different documents: imagine a returning customer that has ordered several times 10 units of reference X: which delivery fills which order ? If there is a credit note for 5 units of reference X, does it have an impact on BO ? For which order ? (these are just examples)
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
数据模型资源手册。
The Data Model Resource Book.
有几种模式数据模型（行业标准数据模型）涵盖了该主题。除了 Len Silverston 的书籍（在另一个答案中提到）之外，还有昂贵的专有模型（Teradata、IBM 等）和来自零售技术标准协会的行业模型（www.nrf-arts.org)。协会会员免费。
它涵盖了商业的大量复杂性——运输、订购、延期交货、客户订单、发票、付款等。
There are several pattern data models (industry standard data models) that cover this topic. In addition to Len Silverston's books (mentioned in another answer), there are pricey proprietary models (Teradata, IBM, etc.) and an industry one from the Association for Retail Technology Standards (www.nrf-arts.org). It is free to members of the association.
It covers a great deal of the complexity of commerce - shipping, ordering, back orders, customer orders, invoicing, payments, etc.