erDiagram
|
crm_customer ||--o{ crm_business : "拥有商机"
|
crm_business ||--o{ crm_sale_quotation : "形成报价"
|
crm_sale_quotation |o--o| crm_contract : "转为合同"
|
crm_contract ||--o| erp_sale_order : "生成销售订单"
|
crm_contract ||--o{ crm_receivable_plan : "分期计划"
|
crm_contract ||--o{ crm_invoice : "开票"
|
crm_invoice ||--o{ crm_receivable : "凭票回款"
|
erp_sale_order ||--o{ mes_pro_mps : "需生产行触发"
|
mes_pro_mps ||--o{ mes_pro_work_order : "下发工单"
|
mes_pro_work_order ||--o{ mes_pro_task : "按工序拆任务"
|
mes_pro_task ||--o{ mes_pro_feedback : "报工"
|
mes_pro_work_order ||--o{ mes_pro_work_order_bom : "工序投料BOM"
|
erp_purchase_request ||--o{ erp_purchase_order : "生成采购订单"
|
erp_purchase_order ||--o| mes_wm_arrival_notice : "确认收货"
|
mes_wm_arrival_notice ||--o| mes_qc_iqc : "触发IQC"
|
mes_wm_arrival_notice ||--o{ mes_wm_item_receipt : "生成采购入库"
|
erp_sale_order ||--o{ mes_wm_product_sales : "销售出库"
|
mes_wm_product_sales ||--o| mes_qc_oqc : "触发OQC"
|
mes_pro_feedback ||--o| mes_qc_ipqc : "质检工序触发IPQC"
|
mes_pro_feedback ||--o{ mes_wm_product_produce : "产出入库"
|
mes_pro_feedback ||--o{ mes_wm_item_consume : "BOM倒冲消耗"
|
mes_qc_iqc ||--o| mes_qc_ncr : "不合格生成NCR"
|
mes_wm_item_receipt ||--o{ mes_wm_material_stock : "库存增加"
|
mes_wm_material_stock ||--o{ mes_wm_transaction : "事务流水"
|
mes_wm_material_stock }o--|| mes_wm_batch : "按批次"
|
after_sale_ticket ||--o{ after_sale_return : "退货申请"
|
after_sale_return ||--o| mes_wm_return_sales : "生成MES退货单"
|
mdm_item ||--o{ erp_sale_order_items : "销售明细"
|
mdm_item ||--o{ erp_purchase_order_items : "采购明细"
|
mdm_item ||--o{ mes_wm_material_stock : "库存物料"
|
srm_supplier ||--o{ erp_purchase_order : "供货"
|
srm_supplier ||--o{ mes_wm_arrival_notice : "到货来源"
|
erp_purchase_order ||--o{ erp_purchase_invoice : "来票"
|
erp_purchase_invoice ||--o{ erp_finance_payment : "付款"
|
hrm_employee ||--o| hrm_user_handover : "离职交接映射"
|
qc_report_template ||--o{ qc_report_template_version : "多版本"
|
qc_report_template_version ||--o{ qc_report_instance : "冻结出件版本"
|
