From 0b37ca51f1d90aedaad7fa883e7248cd2ebe7b45 Mon Sep 17 00:00:00 2001
From: liding <756868258@qq.com>
Date: 星期一, 06 七月 2026 11:51:21 +0800
Subject: [PATCH] fix(database): 修正客户和供应商应收应付金额计算逻辑 公式：应收/应付 = 合同金额 - 回款/付款金额 - 退货金额
---
doc/20260113-product_model.sql | 8 ++++++++
1 files changed, 8 insertions(+), 0 deletions(-)
diff --git a/doc/20260113-product_model.sql b/doc/20260113-product_model.sql
index de82a14..dcbb610 100644
--- a/doc/20260113-product_model.sql
+++ b/doc/20260113-product_model.sql
@@ -4,3 +4,11 @@
alter table process_route
add process_route_code varchar(255) null comment '宸ヨ壓璺嚎缂栫爜';
+alter table procurement_record_storage
+ add product_model_id bigint null comment '浜у搧瑙勬牸id';
+alter table procurement_record_out
+ add product_model_id bigint null comment '浜у搧瑙勬牸id';
+
+
+alter table quality_inspect
+ add product_model_id bigint null comment '浜у搧瑙勬牸id';
--
Gitblit v1.9.3