wms / wms_xiaogangabu · Files

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`;