update-2026.06.sql
2.96 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
ALTER TABLE `receipt_detail`
ADD COLUMN `areaCode` varchar(50) NULL COMMENT '库位' AFTER `materialID`;
ALTER TABLE `receipt_header`
ADD COLUMN `qcFlag` varchar(20) NULL COMMENT '检验标识：0-待检；1-合格；2-不合格' AFTER `mesCode`;
ALTER TABLE `receipt_header`
ADD COLUMN `makerName` varchar(64) NULL COMMENT '制单人' AFTER `qcFlag`;
ALTER TABLE `receipt_header`
ADD COLUMN `po` varchar(64) NULL COMMENT '工单号' AFTER `makerName`;
ALTER TABLE `receipt_header`
ADD COLUMN `orderDate` datetime NULL COMMENT '操作时间' AFTER `po`;
ALTER TABLE `receipt_detail`
ADD COLUMN `ctn` varchar(128) NULL COMMENT '箱签号' AFTER `areaCode`;
ALTER TABLE `receipt_header`
ADD COLUMN `source` varchar(20) NULL COMMENT '来源' AFTER `orderDate`;
ALTER TABLE `receipt_detail`
ADD COLUMN `inspectionDate` datetime NULL COMMENT '检验日期' AFTER `qcCheck`,
ADD COLUMN `inspector` varchar(64) NULL COMMENT '检验人员' AFTER `inspectionDate`;
ALTER TABLE `receipt_header`
ADD COLUMN `orderNo` varchar(64) NULL COMMENT '收货单号' AFTER `source`;
INSERT INTO `receipt_type` (`warehouseCode`, `companyCode`, `code`, `name`, `referType`, `receiptFlow`, `enable`, `created`, `createdBy`, `lastUpdated`, `lastUpdatedBy`, `version`, `processStamp`)
SELECT 'CS0001', 'BHF', 'JY', '检验入库单', '', '2', 1, NOW(), 'MES', NOW(), 'MES', 0, '0'
WHERE NOT EXISTS (
SELECT 1 FROM `receipt_type` WHERE `warehouseCode` = 'CS0001' AND `companyCode` = 'BHF' AND `code` = 'JY'
);
-- shipment_header 新增字段
ALTER TABLE shipment_header ADD COLUMN workDate VARCHAR(32) DEFAULT NULL COMMENT '开工日期';
ALTER TABLE shipment_header ADD COLUMN urgentFlag VARCHAR(4) DEFAULT NULL COMMENT '紧急标识';
ALTER TABLE shipment_header ADD COLUMN inWarehouseCode VARCHAR(32) DEFAULT NULL COMMENT '调入仓库编码';
ALTER TABLE shipment_header ADD COLUMN billType VARCHAR(4) DEFAULT NULL COMMENT '单据类型：0-前序 1-后序';
ALTER TABLE shipment_header ADD COLUMN materialType VARCHAR(4) DEFAULT NULL COMMENT '备料类型：1-领料 2-补料';
ALTER TABLE shipment_header ADD COLUMN indadocno VARCHAR(32) DEFAULT NULL COMMENT '调拨单单别';
ALTER TABLE shipment_header ADD COLUMN applyUserName VARCHAR(64) DEFAULT NULL COMMENT '申请人工号';
ALTER TABLE shipment_header ADD COLUMN deptCode VARCHAR(32) DEFAULT NULL COMMENT '申请部门编码';
ALTER TABLE shipment_header ADD COLUMN productionOrderNumber VARCHAR(64) DEFAULT NULL COMMENT '交易工单号';
ALTER TABLE shipment_header ADD COLUMN machineNumber VARCHAR(32) DEFAULT NULL COMMENT '机台号';
-- shipment_detail 新增字段
ALTER TABLE shipment_detail ADD COLUMN mesId VARCHAR(64) DEFAULT NULL COMMENT 'MES行号';
ALTER TABLE shipment_detail ADD COLUMN outLocationCode VARCHAR(32) DEFAULT NULL COMMENT '拨出库位';
ALTER TABLE shipment_detail ADD COLUMN inLocationCode VARCHAR(32) DEFAULT NULL COMMENT '拨入库位';
ALTER TABLE shipment_header ADD COLUMN outWarehouseCode VARCHAR(32) DEFAULT NULL COMMENT '拨出仓库编码';