From cea8396d93b31fe6037a0558febcabb2169363a8 Mon Sep 17 00:00:00 2001
From: gaoluyang <2820782392@qq.com>
Date: 星期三, 14 十月 2026 14:02:25 +0800
Subject: [PATCH] feat(wm): 入库单和领料单支持手工填写关联信息
---
yudao-module-mes/src/test/resources/sql/create_tables.sql | 8 +++++++-
1 files changed, 7 insertions(+), 1 deletions(-)
diff --git a/yudao-module-mes/src/test/resources/sql/create_tables.sql b/yudao-module-mes/src/test/resources/sql/create_tables.sql
index 780ff99..a766f59 100644
--- a/yudao-module-mes/src/test/resources/sql/create_tables.sql
+++ b/yudao-module-mes/src/test/resources/sql/create_tables.sql
@@ -202,6 +202,7 @@
"source_line_id" bigint DEFAULT NULL,
"source_doc_code" varchar(64) DEFAULT NULL,
"vendor_id" bigint DEFAULT NULL,
+ "vendor_name" varchar(255) DEFAULT NULL,
"vendor_batch" varchar(64) DEFAULT NULL,
"item_id" bigint DEFAULT NULL,
"received_quantity" decimal(24,6) DEFAULT NULL,
@@ -393,7 +394,7 @@
"source_doc_id" bigint DEFAULT NULL,
"source_line_id" bigint DEFAULT NULL,
"source_doc_code" varchar(64) DEFAULT NULL,
- "client_id" bigint NOT NULL,
+ "client_id" bigint DEFAULT NULL,
"batch_code" varchar(64) DEFAULT NULL,
"item_id" bigint NOT NULL,
"min_check_quantity" int DEFAULT 1,
@@ -542,10 +543,15 @@
"name" varchar(255) DEFAULT NULL,
"iqc_id" bigint DEFAULT NULL,
"notice_id" bigint DEFAULT NULL,
+ "notice_code" varchar(64) DEFAULT NULL,
"vendor_id" bigint DEFAULT NULL,
+ "vendor_name" varchar(128) DEFAULT NULL,
"purchase_order_code" varchar(64) DEFAULT NULL,
+ "purchase_order_id" bigint DEFAULT NULL,
"receipt_date" timestamp DEFAULT NULL,
"status" tinyint NOT NULL DEFAULT 0,
+ "process_instance_id" varchar(64) DEFAULT NULL,
+ "process_definition_key" varchar(64) DEFAULT NULL,
"remark" varchar(500) DEFAULT NULL,
"creator" varchar(64) DEFAULT '',
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
--
Gitblit v1.9.3