From 3d43ffa3152110b7823f9fa6320c08a6ae02358a Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周三, 10 9月 2025 11:15:40 +0800
Subject: [PATCH] 1、增加 堆垛机运行统计 2、增加po单空物料描述
---
siemenswmssditcode/sql/DBScript/01_DDL/01_DDL_TABLE.sql | 31 +++++++++++++++++++++++++++++++
1 files changed, 31 insertions(+), 0 deletions(-)
diff --git a/siemenswmssditcode/sql/DBScript/01_DDL/01_DDL_TABLE.sql b/siemenswmssditcode/sql/DBScript/01_DDL/01_DDL_TABLE.sql
index 7ff15f6..38ae33c 100644
--- a/siemenswmssditcode/sql/DBScript/01_DDL/01_DDL_TABLE.sql
+++ b/siemenswmssditcode/sql/DBScript/01_DDL/01_DDL_TABLE.sql
@@ -255,4 +255,35 @@
GO
+use YrtWMS_Siemens2;
+go
+
+/*==============================================================*/
+/* Table: Purchase_OrderList_EmptyMaterialCode */
+/* Description: PO鏄庣粏绌虹墿鏂欏彿琛� */
+/* Author:shaocx */
+/* CreateTime:2025-09-09 */
+/*==============================================================*/
+IF NOT EXISTS( SELECT 1 FROM SYSOBJECTS WHERE ID = OBJECT_ID('Purchase_OrderList_EmptyMaterialCode') AND TYPE = 'U')
+create table Purchase_OrderList_EmptyMaterialCode (
+ ID bigint NOT NULL, -- 涓婚敭
+
+ PoCode nvarchar(50) null,-- 閲囪喘鍗曞彿
+ ProductName nvarchar(500) null,-- 鐗╂枡鍚嶇О
+ Quantity decimal null, -- 鏁伴噺
+ ItemNumber nvarchar(50) null,-- 椤瑰彿
+ BatchNumber nvarchar(50) null,-- 鎵规鍙�
+
+ Remark nvarchar(2000) null, -- 澶囨敞
+
+ Creator varchar(128) null,-- 鍒涘缓浜�
+ CreateTime datetime null,-- 鍒涘缓鏃堕棿
+ LastModifier varchar(128) null,-- 淇敼浜�
+ LastModifyTime datetime null -- 淇敼鏃堕棿
+
+ constraint PK_Purchase_OrderList_EmptyMaterialCode_Id primary key (ID)
+)
+GO
+
+
--
Gitblit v1.9.3