银科环企修改入库单

-- 采购入库单据
SELECT  * FROM  GS_I_WHINDL WHERE WHINID  ='INB2021071316495900095' and WHNUMBER IN (440.000000)
select * from GS_T_COMMODITY where NCOMMSONCLASS =5 and ncommid =123

--采购入库单，显示明细名字
SELECT  gtc.VCOMMYNAME ,g.* FROM  GS_I_WHINDL g LEFT JOIN GS_T_COMMODITY gtc on g.ITID = gtc.NCOMMID  WHERE WHINID  ='INB2021071316495900095' 

--删除数据
DELETE FROM Galasys.dbo.GS_I_WHINDL
WHERE WHINID=N'INB2021071316495900095' AND INREC=N'102';

- 分类
select * from GS_T_CLASSES  
--- select * from GS_T_CLASSES_SK

-- 明细商品
select * from GS_T_COMMODITY where NCOMMSONCLASS =5 and VCOMMYNAME in (
select VCOMMYNAME from GS_T_COMMODITY where NCOMMSONCLASS =5 group by VCOMMYNAME
having count (VCOMMYNAME)>1) order by VCOMMYNAME

select * from GS_T_COMMODITY where NCOMMSONCLASS =5 and NCOMMID in (145)
delete  GS_T_COMMODITY where NCOMMSONCLASS =5 and NCOMMID in (145)

--超过反审核日期入库单如何修改

--报表查询
select * from GS_RM_REPORTMANAGEMENT where RM_GROUP like '%库%'

--库存视图
select * from v_item_base 

--库存视图
select b.VCOMMYNAME 商品名称,ra.itid,b.VCOMMBARCODE 商品编码,Convert(decimal(18,2),ra.stocknumber) 库存数量
FROM V_STOCK ra left join v_item_base b on b.NCOMMID=ra.itid
where b.VCOMMBARCODE='03B306'

-- 库存明细数据，自入库日期以后，明日数据
SELECT   *  FROM   GS_WH_STOCK WHERE itid=306   --TODO这里需要进行修改明细数据

--入库单据视图
select * from v_ioflow where billid ='INB2022060211052800655' and vcommbarcode  ='03B306'
--    入库单明细                             
select * from GS_I_WHINDL where WHINID ='INB2022060211052800655'   --TODO这里需要进行修改明细数据
--入库单主单
select * from GS_I_WHIN where WHINID ='INB2022060211052800655'

-- 更新入库单审核时间
-- UPDATE GS_I_WHIN SET BLADTTIME = '2022-06-21 11:10:36.000' where WHINID ='INB2022060211052800655'

landv / landv.github.io

银科环企修改入库单 #81