金蝶专业版已启用物料修改属性

金蝶专业版启用物料修改属性

                                                                       Xc Sang   

启用批次管理

t_icitemmaterial  ---> FbatchManager 列 是否启用批号管理  （物料盘零后可以修改此项启用批次管理）

例： 将665 物料设为批次管理

select fitemid,fnumber,fname,fmodel from t_icitem where fnumber = '02.11.01003508100'

select fitemid,fbatchmanager from t_icitemmaterial where fitemid = '665'

UPDATE t_icitemmaterial SET fbatchmanager = 1  where fitemid = '665'

select fitemid,fbatchmanager from t_icitemmaterial where fitemid = '665'

单个物料修改辅助属性

select fitemid,fnumber,fname,fmodel,FAuxClassID from t_icitem where fnumber like 'HJ.0H%'

select a.fitemid,b.fmodel,a.FAuxClassID from t_icitembase a  join (select fitemid,fnumber,fname,fmodel,FAuxClassID from t_icitem where fnumber like 'HJ.0H%') b
on a.fitemid = b.fitemid  --where a.fitemid = 2203

select fitemid,FAuxClassID from t_icitembase where fitemid = 2203

UPDATE t_icitembase SET FAuxClassID = 3068  where fitemid = 2203

select fitemid,FAuxClassID from t_icitembase where fitemid = 2203

批量修改辅助属性

select a.fitemid,b.fmodel,a.FAuxClassID from t_icitembase a  join (select fitemid,fnumber,fname,fmodel,FAuxClassID from t_icitem where fnumber like 'HJ.0H%') b
on a.fitemid = b.fitemid

update   t_icitembase   set   t_icitembase.FAuxClassID=3068   FROM   t_icitembase a  inner   join     (select fitemid,fnumber,fname,fmodel,FAuxClassID from t_icitem where fnumber like 'HJ.0H%') b  on  a.fitemid = b.fitemid

select a.fitemid,b.fmodel,a.FAuxClassID from t_icitembase a  join (select fitemid,fnumber,fname,fmodel,FAuxClassID from t_icitem where fnumber like 'HJ.0H%') b
on a.fitemid = b.fitemid 

修改计量单位

select * from t_measureunit

select fitemid,fnumber,fname,fmodel from t_icitem where fnumber = '01.01.0050130'

select fitemid,funitid,funitgroupid,ffullname,forderunitid,fsaleunitid,fstoreunitid,fproductunitid from t_icitembase where fitemid = 2309

UPDATE t_icitembase SET funitgroupid=1185,funitid = 1914,forderunitid =1914,fsaleunitid=1914,fstoreunitid=1914,fproductunitid=1914  where fitemid = 2309

select fitemid,funitid,funitgroupid,ffullname,forderunitid,fsaleunitid,fstoreunitid,fproductunitid from t_icitembase where fitemid = 2309