wms / wms_xiaogangabu · Files

update-2026.06.sql 468 Bytes
1 2 3 4 5 6 7 8 9 10 11 12 
ALTER TABLE `receipt_detail`
ADD COLUMN `areaCode` varchar(50) NULL COMMENT '库位' AFTER `materialID`;

ALTER TABLE `receipt_detail_history`
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`;