2023/11/1

DFWMS货位库存数量修改

  --wms 库存查询   select Bindcode,dbo.Get_INnum(Ratio,INnum) as INnum,Sunit,Pname,Pmake,Pspec,MNE,Psort,Ratio,Batch,ProdDate,ExpiDate,SHYcode,b.GOname,a.PPOO from WBV_WBT_Inventory a,WBT_…

  • DFWMS
  • 2023/11/1
  • 332
  • 2023/10/31

    DFWMS捡货上架前单据删除代码

    --查询WMS订单 select WOID,* from WAT_WareOrder where bindid='XSGZDA00064745' select * from WAT_WareOrderDetail where bindid='XSGZDA00054476'   --删除预约、收货、验收、上架表数据 DELETE from WA…

  • DFWMS
  • 2023/10/31
  • 339