| | |
| | | ], |
| | | [ |
| | | "售后如何闭环", |
| | | "工单判定退货 → 退货申请审核 → 自动建 MES 销售退货单 → RQC 质检/入库回调 → 退款回调 → 工单完结关闭" |
| | | "工单判定退货 → 仓储物流发起销售退货(原售后退货申请页面已下线) → 建 MES 销售退货单 → RQC 质检/入库回调 → 退款回调 → 工单完结关闭" |
| | | ], |
| | | [ |
| | | "AI 在哪里参与", |
| | |
| | | {"key": "crm", "name": "销售管理(客户关系)", "color": "#4f9cff", "tag": "CRM", "flow": "sales", |
| | | "positioning": "销售前端:从线索到回款的客户经营", |
| | | "problem": "客户资产沉淀、商机转化、合同审批与开票回款管控", |
| | | "features": ["线索转化客户", "公海池与领取上限", "联系人", "商机自定义阶段", "跟进记录", "报价单(AI OCR)", "合同(BPM审批→生成销售订单·支持Excel导入)", "开票(BPM审批·支持Excel导入·同一批数据不可重复导入)→回款(先开票校验)", "回款计划", "销售目标", "数据权限三级(负责人/只读/读写)"], |
| | | "objects": ["线索", "客户", "联系人", "商机", "报价单", "合同", "发票", "回款", "销售目标"], |
| | | "features": ["线索转化客户", "公海池与领取上限", "联系人", "商机自定义阶段", "跟进记录", "报价单(AI OCR)", "合同(BPM审批→生成销售订单·支持Excel导入)", "开票申请(绑定销售订单+MES销售出库单)→审批→录入发票(发票号/日期/附件+合同款/预付款/到货款/验收款/质保金收款节点)", "开票(BPM审批·支持Excel导入·同一批数据不可重复导入)→回款(先开票校验·核销明细可拆分到订单/出库/开票)", "回款计划(收款节点回写已回款/实际时间/状态)", "客户应收对账/已发货未开票/未核销应收账龄/月度开票回款趋势", "销售目标", "数据权限三级(负责人/只读/读写)"], |
| | | "objects": ["线索", "客户", "联系人", "商机", "报价单", "合同", "发票", "回款", "回款核销明细", "销售目标"], |
| | | "roles": ["销售内勤", "销售经理", "财务(开票回款)"], |
| | | "upstream": ["主数据(物料)"], "downstream": ["进销存(销售订单)", "售后(客户)", "AI(报价OCR)"], |
| | | "coreTables": ["crm_clue", "crm_customer", "crm_contact", "crm_business", "crm_sale_quotation", "crm_contract", "crm_invoice", "crm_receivable", "crm_receivable_plan", "crm_permission"]}, |
| | |
| | | {"key": "erp", "name": "进销存与财务", "color": "#5fc79e", "tag": "ERP", "flow": "purchase", |
| | | "positioning": "商贸与资金单据中枢,向 MES 发起实物收发", |
| | | "problem": "采购销售单据审批、来票付款控制、订单执行进度回写", |
| | | "features": ["采购申请(BPM)→订单(自动/手动生成)", "确认收货→MES到货通知", "入库/退货数量状态回写", "采购来票(金额≤订单)", "付款单(必须关联来票·BPM)", "销售订单(BPM·审批通过自动建MPS)", "出库状态回写", "收款单(关联CRM客户)", "结算账户", "AI发票OCR"], |
| | | "features": ["采购申请(BPM)→订单(自动/手动生成)", "确认收货→MES到货通知", "入库/退货数量状态回写", "采购来票(绑定采购订单+MES采购入库单·双层剩余额度校验)", "付款单(必须关联来票·BPM)", "销售订单(BPM·审批通过自动建MPS)", "出库状态回写", "收款单(关联CRM客户)", "结算账户", "AI发票OCR"], |
| | | "objects": ["采购申请", "采购订单", "采购来票", "付款单", "销售订单", "收款单", "结算账户"], |
| | | "roles": ["采购员", "销售员", "出纳", "会计"], |
| | | "upstream": ["CRM(合同)", "SRM(定标)", "主数据"], "downstream": ["生产(MPS)", "仓储(收发)"], |
| | |
| | | {"key": "finance", "name": "财务管理(会计核算)", "color": "#3ec9a7", "tag": "FIN", "flow": "finance", |
| | | "positioning": "独立核算模块:会计核算 + 资产核算 + 财务报表看板(与 ERP 进销存财务单据分离,yudao-module-finance)", |
| | | "problem": "进销存只管单据不管账,缺少会计科目/凭证/账簿与资产折旧摊销沉淀,无法出账表与资产净值", |
| | | "features": ["会计科目树(约68条一级科目种子·可建下级)", "记账凭证(字号自动生成·分录借贷平衡前后端双重校验)", "凭证状态机 未过账0→过账10/作废20,已过账不可改", "总账按期间逐月汇总", "明细账逐条分录并结转余额", "固定资产+计提折旧", "无形资产+计提摊销", "会计核算看板(收支/资产/凭证/月度趋势)", "附件走系统附件中心 recordType=fin_voucher"], |
| | | "features": ["会计科目树(约68条一级科目种子·可建下级)", "记账凭证(字号自动生成·分录借贷平衡前后端双重校验)", "凭证状态机 未过账0→过账10/作废20,已过账不可改", "总账按期间逐月汇总", "明细账逐条分录并结转余额", "固定资产+计提折旧", "无形资产+计提摊销", "会计核算看板(收支/资产/凭证/月度趋势)", "凭证来源单据关联(sourceType/sourceId/sourceNo,可回溯开票/回款/来票/付款)", "报表取数接入CRM客户应收对账/已发货未开票/未核销应收账龄/月度开票回款趋势", "附件走系统附件中心 recordType=fin_voucher"], |
| | | "objects": ["会计科目", "记账凭证", "凭证分录", "固定资产", "无形资产"], |
| | | "roles": ["会计", "财务主管", "资产会计", "管理层"], |
| | | "upstream": ["进销存(ERP 已审核收货/付款/购销单据)"], "downstream": ["财务报表看板", "BI 管理驾驶舱"], |
| | | "upstream": ["进销存(ERP 已审核收货/付款/购销单据)", "CRM(开票/回款/核销/对账报表)"], "downstream": ["财务报表看板", "BI 管理驾驶舱"], |
| | | "coreTables": ["fin_account_subject", "fin_voucher", "fin_voucher_entry", "fin_fixed_asset", "fin_intangible_asset"]}, |
| | | {"key": "pro", "name": "生产管理", "color": "#e0b34f", "tag": "MES-PRO", "flow": "production", |
| | | "positioning": "生产执行核心:计划-工单-任务-报工", |
| | |
| | | {"key": "aftersales", "name": "售后服务", "color": "#c78bd6", "tag": "AFTER", "flow": "aftersales", |
| | | "positioning": "客户反馈到退货/维修/退款闭环", |
| | | "problem": "售后工单流转、退货与质检入库退款的跨系统联动", |
| | | "features": ["工单六态(草稿→处理中→待入库→待退款→完结→关闭)", "问题判定(一般/维修/退货)", "维修(现场/返厂/远程)", "退货申请→自动建 MES 销售退货单", "质检结论/入库/退款三重回调", "行级数据权限四视图"], |
| | | "objects": ["售后工单", "维修记录", "退货申请"], |
| | | "features": ["工单六态(草稿→处理中→待入库→待退款→完结→关闭)", "问题判定(一般/维修/退货)", "客户诉求反馈描述+附件", "处理结果+附件", "工单流转记录", "维修(现场/返厂/远程)", "退货由仓储物流发起→MES 销售退货单(原售后退货申请页面已下线)", "质检结论/入库/退款三重回调", "行级数据权限四视图"], |
| | | "objects": ["售后工单", "工单流转记录", "维修记录", "退货申请(后台保留)"], |
| | | "roles": ["客服", "维修工程师", "售后管理员"], |
| | | "upstream": ["CRM(客户)", "ERP(销售订单)"], "downstream": ["仓储(销售退货)", "质量(RQC)", "财务(退款)"], |
| | | "coreTables": ["after_sale_ticket", "after_sale_ticket_item", "after_sale_repair", "after_sale_return", "after_sale_permission"]}, |
| | | {"key": "hrm", "name": "人力资源", "color": "#9db85a", "tag": "HRM", "flow": null, |
| | | "positioning": "员工入转调离与考勤薪酬", |
| | | "problem": "人事流程审批化、离职数据不丢(交接)、算薪自动化", |
| | | "features": ["员工档案(入职自动建系统账号)", "请假/加班/调岗/离职 BPM 审批", "离职交接映射 expandUserIds", "考勤(打卡·规则·排班·补卡审批·月度汇总)", "薪酬(应发-社保公积金-个税-请假扣款·1.5/2/3倍加班费·发放台账)", "培训证书(SQL先行待实现)"], |
| | | "features": ["员工档案(入职自动建系统账号)", "请假/加班/调岗/离职 BPM 审批", "离职交接同时转移员工ID/用户ID/业务数据 expandUserIds", "离职到期自动把员工状态改为离职并停用系统账号", "考勤(打卡·规则·排班·补卡审批·月度汇总)", "薪酬(应发-社保公积金-个税-请假扣款·1.5/2/3倍加班费·发放台账)", "培训证书(SQL先行待实现)"], |
| | | "objects": ["员工", "请假单", "离职申请", "交接映射", "考勤记录", "薪酬核算"], |
| | | "roles": ["HR", "部门主管", "员工本人"], |
| | | "upstream": [], "downstream": ["各模块(数据可见性扩展)", "system(账号)"], |
| | |
| | | {"name": "商机", "module": "销售管理", "table": "crm_business", "doc": "销售机会,DB 配置式阶段推进,结束态: 赢/输/无效", "upstream": ["客户"], "downstream": ["报价单", "合同"], "keywords": "商机 business 赢单 输单 阶段"}, |
| | | {"name": "报价单", "module": "销售管理", "table": "crm_sale_quotation", "doc": "QT编号,选 MDM 物料报价,AI OCR 录入,草稿→已转合同", "upstream": ["商机"], "downstream": ["合同"], "keywords": "报价 quotation QT"}, |
| | | {"name": "合同", "module": "销售管理", "table": "crm_contract", "doc": "HT编号,BPM 审批(0草稿/10审批中/20通过/30驳回/40取消/50作废),通过后可生成销售订单;支持 Excel 导入(一合同多产品明细行、合并单元格自动拉平,客户与物料按名称/编码校验);产品明细带出物料名称/编码/条码/规格型号/计量单位;删除合同时连带删除产品明细,不留孤儿数据", "upstream": ["报价单"], "downstream": ["销售订单", "回款计划", "开票"], "keywords": "合同 contract 审批 导入"}, |
| | | {"name": "发票", "module": "销售管理", "table": "crm_invoice", "doc": "KP编号(可留空自动生成、系统内唯一),BPM 审批,累计开票≤合同额,附件必传;支持 Excel 导入(仅新增不更新,合同须审核通过且本次金额≤合同剩余可开票额;同一批数据不可重复导入——同合同下发票号码相同、或发票号码留空时开票金额+发票抬头+开票日期相同即判重复,文件内重复行与库内已有单都拒该行并回显维度与实际值)", "upstream": ["合同"], "downstream": ["回款"], "keywords": "开票 发票 invoice 导入 去重"}, |
| | | {"name": "回款", "module": "销售管理", "table": "crm_receivable", "doc": "HK编号,创建即审批中(手动审核),强制先开票,金额双校验", "upstream": ["合同", "发票"], "downstream": ["收款单(关联)"], "keywords": "回款 收款计划 receivable"}, |
| | | {"name": "发票", "module": "销售管理", "table": "crm_invoice", "doc": "KP编号(可留空自动生成、系统内唯一),BPM 审批,累计开票≤合同额,附件必传;开票申请须绑定 ERP 销售订单与 MES 销售出库单,审批通过后进入录入发票阶段(entry_status 0待录入→10已录入),录入时填写发票号码/日期/附件并设置合同款/预付款/到货款/验收款/质保金收款节点;支持 Excel 导入(仅新增不更新,合同须审核通过且本次金额≤合同剩余可开票额;同一批数据不可重复导入——同合同下发票号码相同、或发票号码留空时开票金额+发票抬头+开票日期相同即判重复,文件内重复行与库内已有单都拒该行并回显维度与实际值)", "upstream": ["合同", "销售订单", "销售出库单"], "downstream": ["回款", "回款计划", "记账凭证"], "keywords": "开票 发票 invoice 导入 去重 开票申请 录入发票 出库单"}, |
| | | {"name": "回款", "module": "销售管理", "table": "crm_receivable", "doc": "HK编号,创建即审批中(手动审核),强制先开票,金额双校验;新增/编辑可带核销明细 items(20销售订单/21销售出库/23开票),明细合计必须等于回款金额,审核通过后回写回款计划已回款额/实际回款时间/状态(0未回款10部分回款20已回清)", "upstream": ["合同", "发票", "销售订单", "销售出库单"], "downstream": ["收款单(关联)", "回款核销明细", "回款计划", "记账凭证"], "keywords": "回款 收款计划 receivable 核销"}, |
| | | {"name": "回款核销明细", "module": "销售管理", "table": "crm_receivable_item", "doc": "每行把回款金额核销到一张业务单据:biz_type 20销售订单/21销售出库/23开票,biz_no、单据金额、已核销金额由后端按 biz_id 回填;每行核销额不得超过该单据剩余应收;不传 items 且带 invoice_id 时自动生成一条开票核销行", "upstream": ["回款", "销售订单", "销售出库单", "发票"], "downstream": ["客户应收对账", "未核销应收报表"], "keywords": "核销 核销明细 write off item receivable_item"}, |
| | | {"name": "销售目标", "module": "销售管理", "table": "crm_sales_target", "doc": "年/季/月×个人/部门/产品维度的合同回款等目标", "upstream": [], "downstream": ["业绩统计"], "keywords": "目标 target 业绩"}, |
| | | {"name": "供应商", "module": "供应商管理", "table": "srm_supplier", "doc": "供应商档案:执照/税号;多个联系人(srm_supplier_contact)与多个银行账户(srm_supplier_bank·含银行行号),主表保留默认联系人/默认银行字段,ERP 与 MES 共用", "upstream": ["手工建档/Excel 导入"], "downstream": ["询价比价", "投标保证金", "采购订单", "到货通知", "供应商退货", "供应商往来"], "keywords": "供应商 supplier vendor 联系人 开户行 银行行号"}, |
| | | {"name": "询价比价", "module": "供应商管理", "table": "srm_inquiry", "doc": "XJ编号,草稿0→已转订单20→已取消30(10询价中为历史状态);新增/编辑时一并录入产品行×参与供应商报价(srm_inquiry_quote)并选定每个产品的中标供应商,无需单独的报价/比价步骤,确认后按中标供应商拆分生成采购订单草稿并记录 srm_inquiry_order", "upstream": ["供应商", "主数据(物料)"], "downstream": ["采购订单(草稿)"], "keywords": "询价 比价 报价 中标 inquiry quote"}, |
| | | {"name": "投标保证金", "module": "供应商管理", "table": "srm_bid_bond", "doc": "BZ编号台账,关联供应商/询价单/采购订单,记录保证金金额、缴纳日期、是否中标、退回状态(0未退1部分2已退3无需退)/退回金额/退回日期", "upstream": ["供应商", "询价比价", "采购订单"], "downstream": ["供应商往来(参考)"], "keywords": "投标保证金 中标 退回 bid bond"}, |
| | | {"name": "采购申请", "module": "进销存", "table": "erp_purchase_request", "doc": "CGSQ编号,BPM 审批,通过后有供应商自动生成订单", "upstream": ["生产缺口(人工)"], "downstream": ["采购订单"], "keywords": "采购申请 请购 request"}, |
| | | {"name": "采购订单", "module": "进销存", "table": "erp_purchase_order", "doc": "CGDD编号,BPM 审批(草稿0→审批中15→已审核20),入库状态:未0部分1全部2;来源可为采购申请或询价比价确认生成的草稿(来源单号回溯);单价为含税单价,价税合计=单价×数量,税额从含税金额中反算(不再额外加税)", "upstream": ["采购申请", "询价比价(确认中标)"], "downstream": ["到货通知", "采购来票", "供应商退货(约束物料)", "供应商往来"], "keywords": "采购订单 purchase"}, |
| | | {"name": "采购来票", "module": "进销存", "table": "erp_purchase_invoice", "doc": "FPD编号,AI OCR 预填,累计≤订单总价,付款单的前置;供应商往来右侧展示开票金额/已付/剩余应付", "upstream": ["采购订单"], "downstream": ["付款单", "供应商往来"], "keywords": "来票 发票 采购发票"}, |
| | | {"name": "采购来票", "module": "进销存", "table": "erp_purchase_invoice", "doc": "FPD编号,AI OCR 预填,累计≤订单总价,付款单的前置;必须同时绑定采购订单与 MES 采购入库单(item_receipt_id),按订单与入库单两层剩余可来票额度校验;供应商往来右侧展示开票金额/已付/剩余应付", "upstream": ["采购订单", "MES 采购入库单"], "downstream": ["付款单", "供应商往来", "记账凭证"], "keywords": "来票 发票 采购发票 入库单"}, |
| | | {"name": "付款单", "module": "财务", "table": "erp_finance_payment", "doc": "FKD编号,必须关联来票+附件,累计≤来票金额,BPM 审批", "upstream": ["采购来票"], "downstream": ["结算账户", "供应商往来"], "keywords": "付款 应付 payment"}, |
| | | {"name": "供应商往来", "module": "进销存", "table": "无独立表(聚合视图)", "doc": "按供应商+时间范围聚合采购订单/来票/付款:汇总累计采购额、累计开票额、累计付款额、未付余额;左侧订单行含已开票/未开票金额,右侧来票行含开票金额/已付/剩余应付", "upstream": ["采购订单", "采购来票", "付款单"], "downstream": [], "keywords": "供应商往来 对账 开票金额 应付 statement"}, |
| | | {"name": "收款单", "module": "财务", "table": "erp_finance_receipt", "doc": "SKD编号,关联 CRM 客户校验,无 BPM(手动审核)", "upstream": ["销售(弱关联)"], "downstream": ["结算账户"], "keywords": "收款 应收 receipt"}, |
| | | {"name": "会计科目", "module": "会计核算", "table": "fin_account_subject", "doc": "科目树,parent_id 自关联;科目类型1资产2负债3权益4成本5损益,余额方向1借2贷,状态0启用1禁用;账表与分录统一按 subject_code 取数", "upstream": ["会计科目种子约68条一级科目"], "downstream": ["记账凭证分录", "总账", "明细账"], "keywords": "会计科目 科目 subject account 资产类 负债类 损益类"}, |
| | | {"name": "记账凭证", "module": "会计核算", "table": "fin_voucher", "doc": "凭证字号可留空由后端自动生成;状态 未过账0/已过账10/已作废20;已过账不可改,未过账与已过账均可作废,未过账与已作废可删除;附件按 recordType=fin_voucher 挂系统附件中心", "upstream": ["会计科目"], "downstream": ["总账", "明细账", "财务报表看板"], "keywords": "记账凭证 凭证 voucher 过账 作废 借贷平衡"}, |
| | | {"name": "记账凭证", "module": "会计核算", "table": "fin_voucher", "doc": "凭证字号可留空由后端自动生成;状态 未过账0/已过账10/已作废20;已过账不可改,未过账与已过账均可作废,未过账与已作废可删除;可通过 source_type/source_id/source_no 关联开票/回款/来票/付款等来源单据并支持按来源单号检索;附件按 recordType=fin_voucher 挂系统附件中心", "upstream": ["会计科目", "开票", "回款", "采购来票", "付款单"], "downstream": ["总账", "明细账", "财务报表看板"], "keywords": "记账凭证 凭证 voucher 过账 作废 借贷平衡"}, |
| | | {"name": "凭证分录", "module": "会计核算", "table": "fin_voucher_entry", "doc": "凭证下逐行分录:科目编码+借/贷金额+辅助核算(1客户2供应商3部门4员工5项目);一行不可借贷同时大于0,全表借贷合计必须相等且大于0", "upstream": ["记账凭证", "会计科目"], "downstream": ["总账", "明细账"], "keywords": "凭证分录 分录 entry 借方 贷方 辅助核算"}, |
| | | {"name": "固定资产", "module": "会计核算", "table": "fin_fixed_asset", "doc": "资产卡片,状态 1在用/2闲置/3维修中/4已报废;月折旧额=(原值×(1-残值率))÷(年限×12),累计折旧与净值由计提累加,不接收前端传值", "upstream": [], "downstream": ["财务报表看板", "总账"], "keywords": "固定资产 折旧 资产卡片 fixed asset 残值率"}, |
| | | {"name": "无形资产", "module": "会计核算", "table": "fin_intangible_asset", "doc": "无形资产卡片(证书编号/有效期),状态 1在用/2已失效/3已摊销完;月摊销额=(原值×(1-残值率))÷(摊销年限×12),累计摊销与净值由计提累加", "upstream": [], "downstream": ["财务报表看板", "总账"], "keywords": "无形资产 摊销 软件著作权 专利 intangible 有效期"}, |
| | |
| | | {"name": "采购入库单", "module": "仓储", "table": "mes_wm_item_receipt", "doc": "草稿0→待上架2→待执行3→完成4,完成后库存+并回写 ERP inCount/inStatus", "upstream": ["到货通知"], "downstream": ["库存台账", "采购订单(回写)"], "keywords": "采购入库 收货入库 receipt"}, |
| | | {"name": "生产领料单", "module": "仓储", "table": "mes_wm_product_issue", "doc": "草稿0→待拣货2→待执行3→完成4,库存-", "upstream": ["生产工单"], "downstream": ["库存台账"], "keywords": "领料 issue"}, |
| | | {"name": "销售出库单", "module": "仓储", "table": "mes_wm_product_sales", "doc": "发货通知审核后生成,提交→OQC检测→拣货→发运10→待执行3→完成4,回写销售订单出库数与状态", "upstream": ["发货通知", "销售订单"], "downstream": ["库存台账", "OQC"], "keywords": "销售出库 发货 出库单 sales"}, |
| | | {"name": "销售退货单", "module": "仓储", "table": "mes_wm_return_sales", "doc": "草稿→待检验(RQC)→待上架→待入库→完成,售后与手工两来源", "upstream": ["售后退货申请"], "downstream": ["库存台账", "RQC"], "keywords": "销售退货 退货入库"}, |
| | | {"name": "销售退货单", "module": "仓储", "table": "mes_wm_return_sales", "doc": "草稿→待检验(RQC)→待上架→待入库→完成,售后与手工两来源", "upstream": ["售后退货(仓储发起)"], "downstream": ["库存台账", "RQC"], "keywords": "销售退货 退货入库"}, |
| | | {"name": "供应商退货单", "module": "仓储", "table": "mes_wm_return_vendor", "doc": "IQC 不合格退货发起,待拣货→待执行→完成,库存-", "upstream": ["IQC"], "downstream": ["库存台账", "采购订单(returnCount)"], "keywords": "供应商退货 退料 退货 vendor"}, |
| | | {"name": "调拨单", "module": "仓储", "table": "mes_wm_transfer", "doc": "内部/外部调拨,成对 MOVE_OUT+MOVE_IN 事务,在途数量", "upstream": [], "downstream": ["库存台账"], "keywords": "调拨 移库 transfer"}, |
| | | {"name": "盘点任务", "module": "仓储", "table": "mes_wm_stock_taking_task", "doc": "静态/动态盘点,行结果:正常/盘盈(ADJUST_IN)/盘亏(ADJUST_OUT),可冻结库存、盲盘", "upstream": ["库存台账"], "downstream": ["库存台账(调整)"], "keywords": "盘点 盘盈 盘亏 stock taking"}, |
| | |
| | | {"name": "RQC退货检验", "module": "质量", "table": "mes_qc_rqc", "doc": "生产退料/销售退货/售后退货触发,结论回调售后;行操作「出报告」仅在已完成时可见。措辞已统一为「退货检验」(原菜单父项与 mes_qc_type 字典写「退料检验」,与后端枚举/表注释/菜单权限子项不一致;RQC 三者都覆盖,故取「退货检验」)", "upstream": ["退料", "退货"], "downstream": ["退货入库", "售后回调", "报告实例(出报告)"], "keywords": "RQC 退货检验 退料检验 出报告"}, |
| | | {"name": "NCR不合格品", "module": "质量", "table": "mes_qc_ncr", "doc": "待评审0→已评审6→已处置7→已关闭8,处置:退货/报废/返工/让步接收/降级", "upstream": ["IQC/IPQC/OQC/RQC"], "downstream": ["退货/报废/返工(台账)"], "keywords": "NCR 不合格 处置 特采 报废"}, |
| | | {"name": "设备", "module": "设备", "table": "mes_dv_machinery", "doc": "台账状态:停机/生产中/保养中;点检·保养·维修工单;AI 风险预测消费其数据", "upstream": [], "downstream": ["点检", "维修", "生产风险预测"], "keywords": "设备 点检 保养 维修 machinery"}, |
| | | {"name": "售后工单", "module": "售后", "table": "after_sale_ticket", "doc": "草稿0→处理中10→待入库30→待退款40→完结50→关闭60/取消99,判定:一般/维修/退货", "upstream": ["客户反馈(人工录入)"], "downstream": ["维修记录", "退货申请"], "keywords": "售后 工单 ticket 维修"}, |
| | | {"name": "退货申请", "module": "售后", "table": "after_sale_return", "doc": "草稿0→已审核20(自动建MES退货单)→已质检40→已入库50→已退款60→关闭70;类型:退款退货/换货/仅退款", "upstream": ["售后工单"], "downstream": ["销售退货单", "退款"], "keywords": "售后退货 return"}, |
| | | {"name": "员工", "module": "人力", "table": "hrm_employee", "doc": "在职1/试用2/离职3,入职自动建系统账号", "upstream": [], "downstream": ["交接映射", "考勤", "薪酬"], "keywords": "员工 入职 employee"}, |
| | | {"name": "离职交接", "module": "人力", "table": "hrm_user_handover", "doc": "from→to 映射,已完成20 后 expandUserIds 扩展交接人可见数据(当前各业务模块尚未实际接入调用)", "upstream": ["离职申请"], "downstream": ["各模块我的数据查询"], "keywords": "交接 离职 handover expandUserIds"}, |
| | | {"name": "售后工单", "module": "售后", "table": "after_sale_ticket", "doc": "草稿0→处理中10→待入库30→待退款40→完结50→关闭60/取消99,判定:一般/维修/退货;客户诉求反馈描述+附件、处理结果+附件;创建/更新/判定/完结/归档/取消/回访写入流转记录", "upstream": ["客户反馈(人工录入)"], "downstream": ["维修记录", "仓储销售退货(原退货申请页面已下线)"], "keywords": "售后 工单 ticket 维修 客户诉求 处理结果 流转记录"}, |
| | | {"name": "工单流转记录", "module": "售后", "table": "after_sale_ticket_flow", "doc": "售后工单每次动作留痕:动作编码/名称、变更前后状态、内容、操作人、时间", "upstream": ["售后工单"], "downstream": [], "keywords": "售后 流转记录 flow"}, |
| | | {"name": "退货申请", "module": "售后", "table": "after_sale_return", "doc": "后台保留,售后页面已下线;草稿0→已审核20(自动建MES退货单)→已质检40→已入库50→已退款60→关闭70;类型:退款退货/换货/仅退款", "upstream": ["售后工单"], "downstream": ["销售退货单", "退款"], "keywords": "售后退货 return"}, |
| | | {"name": "员工", "module": "人力", "table": "hrm_employee", "doc": "在职1/试用2/离职3,入职自动建系统账号;离职申请到期自动置为离职3并停用系统账号", "upstream": [], "downstream": ["交接映射", "考勤", "薪酬"], "keywords": "员工 入职 employee 离职"}, |
| | | {"name": "离职申请", "module": "人力", "table": "hrm_resignation_application", "doc": "草稿0→审批中10→通过20/驳回30/撤销40;审批通过后可交接0→10→20;到期任务写实际离职日期、把员工状态改为离职3并停用系统账号", "upstream": ["员工"], "downstream": ["员工档案状态", "离职交接"], "keywords": "离职 resignation 审批 交接 自动离职"}, |
| | | {"name": "离职交接", "module": "人力", "table": "hrm_user_handover", "doc": "同时记录离职/交接双方员工ID与用户ID;交接完成20 后 expandUserIds 扩展交接人可见数据;审批通过且到预计离职日期后自动把员工状态改为离职3并停用系统账号", "upstream": ["离职申请"], "downstream": ["各模块我的数据查询", "员工档案状态"], "keywords": "交接 离职 handover expandUserIds 自动离职"}, |
| | | {"name": "排班计划", "module": "设备", "table": "mes_cal_plan", "doc": "班组×班次×日期排班,供生产与考勤引用", "upstream": [], "downstream": ["生产任务", "考勤"], "keywords": "排班 班组 班次 日历"}, |
| | | {"name": "报告模板", "module": "质检报告", "table": "qc_report_template", "doc": "智能质检报告模板,启用0/停用1;画布内容存在 qc_report_template_version(草稿0/已发布1/已停用2,已发布不可覆盖),currentVersion 指向当前已发布版本;源文件经 AI 导入识别成草稿后由人工确认才成为版本;同一模板重复导入按【替换】处理——先删旧附件(连带 blob 行与磁盘文件)再绑新的,不留孤儿文件;删除模板会连带清附件", "upstream": ["人工设计(GrapesJS 设计器)", "AI 导入草稿(qc-report/ai-import/draft)"], "downstream": ["模板版本", "报告实例"], "keywords": "报告模板 质检报告 template 设计器 版本 AI导入 识别 草稿 源文件替换"}, |
| | | {"name": "报告实例", "module": "质检报告", "table": "qc_report_instance", "doc": "出件产物,编号 QR+yyyyMMdd+4位流水按天独立且业务唯一,可显式指定覆盖(注意 uk_report_no 不区分软删除,删掉的号不回收);两条出件入口:通用 generate(调用方自带 context)与 generate-from-qc(数据从 MES 质检单取,权限码 qc-report:instance:generate 已入 system_menu id=1075416,五道校验按业务优先级只报第一处:105_000 类型非法 / 105_001 单据不存在 / 105_002 未完成 / 105_003 未判定 / 105_005 模板类型不符 / 105_006 无可用检验项;四张质检单列表的行操作「出报告」仅在 status=已完成时可见,弹窗只列 reportType 一致、模板启用、且 currentVersion 指向的版本已发布的模板(后端 /qc-report/template/selectable 判定——停用版本不清空 currentVersion,前端拿分页结果自己推导会漏),结果就地展示并跳本页列表);冻结 data_snapshot(判定后数据,含后端算好的 PASS/FAIL 与合格率)与 render_html;regenerate 只重渲排版、数据与编号不变;business_id/business_type 存 MES 表名(mes_qc_iqc 等)与单据 ID,可反查、一单可出多份;报告头另带单据原判定 qcResult(数)/qcResultText(中文,合格/特采/不合格退货/不合格报废),与引擎三态判定并存互不覆盖;响应带 undecidableCount=快照中 result 为空串的项数与 warnings(分组标题跳过/指标已删/未录实测值/样品超3),两者都不落库、事后看不到", "upstream": ["报告模板版本", "质检单上下文(通用 generate 由调用方传入)", "MES 质检单 IQC/IPQC/OQC/RQC(generate-from-qc 经 MesQcReportApi 取数)"], "downstream": ["前端实例页 /qc/report-instance(列表·iframe预览·快照页签·导出PDF)", "PDF归档(system_storage_attachment recordType=qc_report_instance)"], "keywords": "报告实例 出件 QR编号 快照 复现 regenerate PDF归档 报告实例页 导出PDF generate-from-qc 质检单出报告 出报告弹窗 qcResult undecidableCount warnings 待判定 反查 业务单据筛选"} |
| | |
| | | {"stage": "盘点", "action": "方案→任务→明细行→结果,盘盈 ADJUST_IN、盘亏 ADJUST_OUT,可冻结与盲盘", "roles": ["盘点员"]}, |
| | | {"stage": "追溯", "action": "批次/SN(uuid)/条码(18类)/装箱嵌套支撑正反向追溯", "roles": ["质量", "售后"]}]}, |
| | | {"id": "aftersales", "name": "售后流程", "mermaid": "mermaid/07-after-sales-flow.mmd", "color": "#c78bd6", |
| | | "summary": "工单(六态+问题判定) → 维修三类型或退货申请 → 审核自动建 MES 销售退货单 → RQC 质检/入库/退款三回调逐级推进 → 工单完结关闭。", |
| | | "summary": "工单(六态+问题判定) → 客户诉求/处理结果附件与流转记录留痕 → 维修三类型或由仓储物流发起销售退货 → RQC 质检/入库/退款三回调逐级推进 → 工单完结关闭。", |
| | | "steps": [ |
| | | {"stage": "受理", "action": "人工录入工单(关联客户/订单/合同),分配处理人进入处理中", "roles": ["客服"]}, |
| | | {"stage": "受理", "action": "人工录入工单(关联客户/订单/合同),填写客户诉求反馈描述并上传附件,创建时指定的处理人直接进入处理中", "roles": ["客服"]}, |
| | | {"stage": "判定", "action": "问题判定: 一般/维修/退货,严重度 0-3", "roles": ["售后工程师"]}, |
| | | {"stage": "处理", "action": "填写处理结果并上传处理结果附件;创建、更新、判定、完结、归档、取消、回访均写入流转记录", "roles": ["售后工程师"]}, |
| | | {"stage": "维修", "action": "现场/返厂/远程维修,费用与结果记录,完成联动工单完结", "roles": ["维修工程师"]}, |
| | | {"stage": "退货", "action": "退货申请审核→自动建 MES 销售退货单(RQC)→质检/入库回调→退款回调→关闭", "roles": ["售后", "质检", "财务"]}]}, |
| | | {"stage": "退货", "action": "售后不再发起退货申请,由仓储物流发起销售退货单(RQC)→质检/入库回调→退款回调→关闭", "roles": ["仓储", "质检", "财务"]}]}, |
| | | {"id": "finance", "name": "会计核算流程", "mermaid": "mermaid/12-finance-flow.mmd", "color": "#3ec9a7", |
| | | "summary": "独立核算模块 yudao-module-finance:会计科目建账 → 记账凭证录入(借贷平衡校验) → 过账 → 总账/明细账 → 资产计提折旧与摊销 → 财务报表看板取数 ERP 已审核单据。", |
| | | "steps": [ |
| | |
| | | {"role": "仓管员", "modules": ["MES-WM"], "operations": ["15 类出入库单据执行", "调拨", "盘点", "条码装箱"], "data": ["mes_wm_*"], "scope": "仓库维度;WMS 可按仓库配置出入库/调拨/盘点是否走 BPM"}, |
| | | {"role": "质检员", "modules": ["MES-QC"], "operations": ["IQC/IPQC/OQC/RQC 检验", "NCR 评审处置"], "data": ["mes_qc_*"], "scope": "inspectorUserId 归属"}, |
| | | {"role": "设备员/维修工", "modules": ["MES-DV"], "operations": ["点检保养", "维修工单", "工装领用"], "data": ["mes_dv_*", "mes_tm_*"], "scope": "chargeUserId 归属"}, |
| | | {"role": "客服/售后工程师", "modules": ["售后"], "operations": ["工单受理派工", "维修", "退货申请"], "data": ["after_sale_*"], "scope": "行级数据权限四视图:我负责/我参与/下属负责/全部(aftersales:view-all)"}, |
| | | {"role": "客服/售后工程师", "modules": ["售后"], "operations": ["工单受理派工", "客户诉求/处理结果附件", "维修", "退货转仓储发起"], "data": ["after_sale_*"], "scope": "行级数据权限四视图:我负责/我参与/下属负责/全部(aftersales:view-all)"}, |
| | | {"role": "财务", "modules": ["ERP", "CRM", "FIN"], "operations": ["收款单", "付款单", "开票审核", "结算账户", "会计科目维护", "记账凭证录入与过账/作废", "总账与明细账查询", "固定资产折旧计提", "无形资产摊销计提", "会计核算看板"], "data": ["erp_finance_*", "crm_invoice", "crm_receivable", "fin_account_subject", "fin_voucher", "fin_voucher_entry", "fin_fixed_asset", "fin_intangible_asset"], "scope": "financeUserId 归属;财务核算模块按 finance:* 接口权限 + system_menu 授权,暂无数据权限字段"}, |
| | | {"role": "HR", "modules": ["HRM"], "operations": ["员工档案入转调离", "考勤规则排班", "薪酬核算发放", "离职交接"], "data": ["hrm_*"], "scope": "部门范围 dataScope"}, |
| | | {"role": "管理层", "modules": ["BI"], "operations": ["查看采购销售/仓库/生产设备/质量/人力五大主题大屏"], "data": ["bi_dashboard"], "scope": "只读"} |
| | |
| | | 工装夹具 |
| | | 班组班次与排班 |
| | | 售后服务 |
| | | 售后工单 |
| | | 售后工单(客户诉求/处理结果附件) |
| | | 工单流转记录 |
| | | 维修记录 |
| | | 退货申请 |
| | | 退货操作(仓储物流发起,原退货申请页面已下线) |
| | | 数据权限 |
| | | 人力资源 HRM |
| | | 员工档案 |
| | |
| | | </pre> |
| | | <pre style="display:none" class="mmd-src" data-mmd="07-after-sales-flow"> |
| | | flowchart TD |
| | | F1[客户反馈·后台人工录入工单·关联客户联系人销售订单合同] --> K1[售后工单·草稿0] |
| | | K1 -->|assignTicket 分配处理人| K2[处理中10·问题判定:一般1维修2退货3·严重度0-3] |
| | | F1[客户反馈·后台人工录入工单·关联客户联系人销售订单合同·客户诉求反馈+附件] --> K1[售后工单·草稿0] |
| | | K1 -->|创建时指定处理人,直接进入| K2[处理中10·问题判定:一般1维修2退货3·严重度0-3] |
| | | K2 -->|维修类| R1[维修记录·待处理0→维修中10→已完成20→已关闭30·现场返厂远程] |
| | | R1 -->|completeRepair| K4[已完结50] |
| | | K2 -->|退货类创建退货申请| T1[退货申请·草稿0] |
| | | K1 -.->|创建/更新/判定/完结/归档/取消/回访均留痕| FL[工单流转记录 after_sale_ticket_flow] |
| | | K2 -->|退货类→仓储物流发起销售退货| T1[退货申请·草稿0·售后页面已下线,后台保留] |
| | | T1 -->|approveReturn 审核通过| T2[已审核20·自动创建MES销售退货单] |
| | | T2 --> T3[MES 销售退货·草稿→待检验RQC→待上架→待入库→完成] |
| | | T3 -->|质检结论回调 onReturnQualityFinished 合格特采退货报废| T4[已质检40] |
| | |
| | | T2 -.->|状态流转中| T8[审核中10·预留未启用] |
| | | K2 -->|退货链路联动工单| K3[待入库30→待退款40] |
| | | K3 --> K4 |
| | | K2 -->|resolveTicket| K4 |
| | | K2 -->|resolveTicket 填写处理结果+附件| K4 |
| | | K4 -->|closeTicket| K5[已关闭60] |
| | | K1 -->|cancelTicket| K9[已取消99] |
| | | K2 -->|cancelTicket| K9 |
| | |
| | | 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_ticket ||--o{ after_sale_ticket_flow : "流转记录" |
| | | 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 : "采购明细" |
| | |
| | | M --> K |
| | | O --> K |
| | | P[ERP 已审核单据 status=20 收款单 付款单 销售订单 采购订单] -->|ErpFinanceStatisticsApi.getMonthlyStatistics 按月| K |
| | | subgraph 销售采购财务闭环 |
| | | R1[ERP 销售订单 status=20] -->|选择订单| R2[MES 销售出库单 status=4 已完成] |
| | | R2 -->|开票申请·绑定订单+出库单| R3[CRM 开票 crm_invoice entry_status=0 待录入] |
| | | R3 -->|审批通过| R4[录入发票 invoiceNo/日期/附件] |
| | | R4 -->|填写收款节点| R5[回款计划 crm_receivable_plan stage=1..5] |
| | | R4 -->|entry_status=10 已录入| R6[CRM 回款 crm_receivable] |
| | | R6 -->|核销明细 crm_receivable_item bizType=20/21/23| R7[销售订单 / 销售出库 / 开票] |
| | | R7 -->|订单金额-已回款| R8[客户应收对账单] |
| | | R5 -->|下月未回清节点| R8 |
| | | R2 -->|已完成出库-已开票| R9[已发货未开票报表] |
| | | R4 -->|开票-已回款| R10[未核销应收报表·账龄] |
| | | R8 --> R11[下月回款计划] |
| | | R1 -->|选择订单| P1[ERP 采购订单 status=20] |
| | | P1 -->|选择订单| P2[MES 采购入库单 mes_wm_item_receipt status=4] |
| | | P2 -->|来票·绑定订单+入库单| P3[ERP 来票 erp_purchase_invoice item_receipt_id] |
| | | P3 -->|剩余可来票| P1 |
| | | end |
| | | R4 -->|sourceType=CRM_INVOICE| C1[记账凭证 fin_voucher source_type/source_id/source_no] |
| | | R6 -->|sourceType=CRM_RECEIVABLE| C1 |
| | | P3 -->|sourceType=ERP_PURCHASE_INVOICE| C1 |
| | | K -.->|科目数 凭证数 未过账 已过账 已作废 资产净值 月度趋势| Q[看板卡片+月度趋势图] |
| | | V[附件中心 recordType=fin_voucher] --- C |
| | | V -.->|不落 file_url 列| C |