金蝶系统问题处理册(个人总结一).docVIP

删除领料单 select * from icstockbill where fbillno=领料单号记住它的finterid detele from icstockbill where finterid = 2182 detele from icstockbillentry where finterid= 2182 在使用请做好备份，另外在操作时，请先在测试帐套中完成测试 2、查看单据 declare @djtou varchar(50) declare @djti varchar(50) set @djtou=单据头 set @djti=单据体 select t2.fname as 单据名称, @djti as 单据头/体, t2.fentrytable as 单据表明, t1.ffieldname as 字段ID, t1.fheadcaption as 单据体字段名称, t2.fid as 单据类型内码, t2.ftemplateid as ftemplateid from ICTemplateEntry t1 left join (select * from ICTransactionType where fid not in (101,102))t2 on t1.