单据合并校验
创建入库合并单
生成入库拓展信息
生成入库批次单
SELECT * FROM `wms_stock_in_detail` where stock_in_id = 7620096;
SELECT * FROM `wms_stock_in` WHERE id = 7620096;
根据入库通知单id校验入库单是否存在
单据合并
生成入库单详情
根据入库单id查询入库单明细
SELECT * FROM `wms_stock_in_batch` where principal_id = 7620096;
更新入库通知单状态:未创建入库单->进行中
SELECT * FROM `wms_stock_in_notice` where notice_no in( 'ION2482800000L0305');
生成入库单
非差异退仓单
结束
仓库状态校验(关停并转/已关仓)
SELECT * FROM `wms_stock_in_notice_detail` where id in(SELECT id FROM `wms_stock_in_notice` where notice_no in( 'ION2482800000L0305'));