From e9269528ae01bc4572b68148b9c801b51f23b669 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周四, 04 9月 2025 10:41:45 +0800
Subject: [PATCH] 查询优化
---
sql/DBScript/01_DDL/01_DDL_TABLE_YunNeiDongLi.sql | 2 ++
1 files changed, 2 insertions(+), 0 deletions(-)
diff --git a/sql/DBScript/01_DDL/01_DDL_TABLE_YunNeiDongLi.sql b/sql/DBScript/01_DDL/01_DDL_TABLE_YunNeiDongLi.sql
index 5532899..800ab5c 100644
--- a/sql/DBScript/01_DDL/01_DDL_TABLE_YunNeiDongLi.sql
+++ b/sql/DBScript/01_DDL/01_DDL_TABLE_YunNeiDongLi.sql
@@ -210,6 +210,7 @@
qty int NULL , -- 鏁伴噺
isSendToMes int NULL , -- 鏄惁鎺ㄧ粰MES
+ SendToMesCount int NULL , -- 鎺ㄧ粰MES娆℃暟
SendToMesTime datetime null, -- 鎺ㄧ粰MES鏃堕棿
MesRet NVARCHAR(128) NULL , -- MES杩斿洖缁撴灉
@@ -237,6 +238,7 @@
mainId bigint ,--- Wms_outInStockRecord_V2_Mes琛ㄧ殑ID
+ containerCode NVARCHAR(100) NULL , -- 鎵樼洏鍙�
productCode VARCHAR(100) NULL , -- 浜у搧缂栫爜
productName NVARCHAR(100) NULL , -- 浜у搧鍚嶇О
serialNumber NVARCHAR(100) NULL , -- 娴佹按鍙�
--
Gitblit v1.9.3