MID1匹配不删，重传订单到WMS

查看 WMS对MID1的分配记录

SELECT A.*,A.rowid FROM Cqmscmwms.erpifoutformtbl A WHERE OUTFORMNO='61948688629'

删除WMS销毁出库订单

delete FROM erpifoutformtbl A where a.outformno='61946416717';
delete FROM erpifoutformdetailtbl A where a.outformno='61946416717';
delete FROM OUTSTOCKINFORMDTTBL_BATCH  A where a.outformno='61946416717';



delete FROM outstockinformtbl A where a.outstockinformid='61946416717';
delete FROM outstockinformdttbl A where a.outstockinformid='61946416717';
delete FROM delivertbl A where a.outstockinformid='61946416717';


delete FROM outstockindicationtbl A where a.outstockindicationid='61946416717';
delete FROM outstockindicationdttbl A where a.outstockindicationid='61946416717';
delete FROM outstockprocessdttbl A where a.outstockindicationid='61946416717';

检查SCM订单是否存在 销毁执行记录查询 5512

将历史表数据，移动到业务表，记得将历史数据备份到EXCEL

SELECT A.*,A.rowid FROM tpl2wms_out_doc A WHERE a.srcexpno='47408933';
SELECT A.*,A.rowid FROM tpl2wms_out_dtl A WHERE a.docid in (SELECT A.docid FROM tpl2wms_out_doc A WHERE a.srcexpno='47408933');


SELECT A.*,A.rowid FROM tpl2wms_out_doc_his A WHERE a.srcexpno='47408933';
SELECT A.*,A.rowid FROM tpl2wms_out_dtl_his A WHERE a.docid in (SELECT A.docid FROM tpl2wms_out_doc_his A WHERE a.srcexpno='47408933');

--转移头
insert into tpl2wms_out_doc
 (docid, srcexpno, operationtype, warehid, goodsownerid, gcompanyid, companystype, relevanceno, ordertype, transmode, receiveaddr, receivehead, receiveman, urgenflag, addinvoiceflag, exportmemo, detaillines, transid, outmemo, transclass, receivephone, salername, deptname, credate, deldate, errorflag, nowmsflag, zxcolumn1, zxcolumn2, zxcolumn3, zxcolumn4, zxcolumn5, zxcolumn6, zxcolumn7, zxcolumn8, zxcolumn9, zxcolumn10, selername, outid, outmode, companyid, nowlflag, erporderid, erpcompanyid, erptransid, outstocktype, prearrivedate, arrivedate, itemproperty, totalvalue, goodsownercode, warehno, salesmanphoneno, coldboxtype, urgencytype, sourcesystem, inputmanname, extendno, createuserid, salerid, salescd, address, shippingaddress, wldygs, psdbm, isjtkp, incometype, gpo_orderno, zx_hisorderno, twoinvflag, reqprintquflag, confirmmanname, confirmmanidcare, adjustername, reasonno, zx_paydaysway, reservedno,  preoutflag, yth, sourcesystemcode, wmsoutid, ftzs, bzkc, ydid, businesstype, gljy, clientname, idnumber, bankcardno, noindicationoutid, contactman, printobj, isarrive, isfir, isflag, invoicetype, ztorderid, notedate)
select docid, srcexpno, operationtype, warehid, goodsownerid, gcompanyid, companystype, relevanceno, ordertype, transmode, receiveaddr, receivehead, receiveman, urgenflag, addinvoiceflag, exportmemo, detaillines, transid, outmemo, transclass, receivephone, salername, deptname, credate, deldate, errorflag, nowmsflag, zxcolumn1, zxcolumn2, zxcolumn3, zxcolumn4, zxcolumn5, zxcolumn6, zxcolumn7, zxcolumn8, zxcolumn9, zxcolumn10, selername, outid, outmode, companyid, nowlflag, erporderid, erpcompanyid, erptransid, outstocktype, prearrivedate, arrivedate, itemproperty, totalvalue, goodsownercode, warehno, salesmanphoneno, coldboxtype, urgencytype, sourcesystem, inputmanname, extendno, createuserid, salerid, salescd, address, shippingaddress, wldygs, psdbm, isjtkp, incometype, gpo_orderno, zx_hisorderno, twoinvflag, reqprintquflag, confirmmanname, confirmmanidcare, adjustername, reasonno, zx_paydaysway, reservedno,  preoutflag, yth, sourcesystemcode, wmsoutid, ftzs, bzkc, ydid, businesstype, gljy, clientname, idnumber, bankcardno, noindicationoutid, contactman, printobj, isarrive, isfir, isflag, invoicetype, ztorderid, notedate 
from tpl2wms_out_doc_his
WHERE srcexpno='47408933';

再查询WMS，订单就已经过来了

如果MID1还未匹配，有可能是商品主表扫码标志取消了，可以查询T_LOG_GOODSMST_YJMSCAN 表查