NC收发存报表修改取数(增删某些出入库单据数据)
--出入库涉及到的表4个如下4点
select ctrantypeid,a.*,rowid from ia_iabill a where a.vbillcode='IA2019022800001919';
select * from bd_billtype a where a.billtypename='转库出库';--材料出库 0001A910000000004V5N
--0001A910000000004V5Q 55007.38
1、select a.ctrantypeid,a.*,rowid from ia_monthout a where a.noutmny = '55007.38' order by a.noutmny asc;
2、select * from ia_monthin a where a.ninmny = '55007.38' order by a.ninmny desc;
3、select a.*,rowid from ia_periodnab a where a.nabnum=0 and a.nabmny=-55007.38000000 order by a.nabmny desc;
4、select a.cdetailledgerid ,a.nmny,a.ctrantypeid,a.*,rowid from ia_detailledger a where nmny = '55007.38' order by a.nmny asc;
--若要修改出入库数据,需要在上面所在的表中去修改类型
原文链接:https://blog.csdn.net/wxingcai/article/details/104248752