WMS2.0获取库存

WMS2.0 获取库存

背景简介

由于货主在ERP 自己把单据违规做完，导致WMS、SCM产生 垃圾库存数据，需要手动删除。

涉及系统

SCM    英克WMS（2.0）

找客户确定要抽单的单据，把SKU记录下来，然后分别删除WMS和SCM库存

1.获取WMS库存

SELECT A.WAREHID,A.goodsownerid ,A.GOODSID,A.ownergoodsid ,A.LOTID, A.*,A.rowid FROM tpl_st_qty_lst_v A WHERE goodsownid='SJ023084';

--获取平台库存
SELECT A.*,A.rowid FROM tpl_st_qty_lst A WHERE A.ownergoodsid = 46881 AND A.LOTID=7552;
--AND A.WAREHID=42
--AND A.goodsownerid=942
--AND A.GOODSID=29837

--获取wms库存
SELECT A.*,A.rowid FROM wms_st_qty_lst A WHERE A.ownergoodsid = 46881 AND A.LOTID=7552;
--AND A.WAREHID=42
--AND A.goodsownerid=942
--AND A.GOODSID=29837

--修改 状态为抽单  usestatus=0
SELECT A.usestatus, A.*,A.rowid FROM wms_in_order_v A WHERE srcno='SJ022210CG300'

2.获取SCM库存

SELECT A.WAREHID,A.goodsownerid ,A.GOODSID,A.ownergoodsid ,A.LOTID, A.*,A.rowid FROM tpl_st_qty_lst_v A WHERE goodsownid='SJ023084';

--获取平台库存
SELECT A.*,A.rowid FROM tpl_st_qty_lst A WHERE 1=1 
AND A.WAREHID=561
AND A.goodsownerid=922
AND A.GOODSID=522543
AND A.ownergoodsid = 940435
AND A.LOTID=2079326;

--修改 状态为抽单  usestatus=0
SELECT a.usestatus, A.*,A.rowid FROM tpl_in_order_v A WHERE srcno='SJ022210CG300'