用友CDM货位间商品移库（一步）增加冲红功能

1.新增业务单据提取方案，在业务单据货位间商品移库（一步），单据菜单功能。

2.单据选择sql

select kaiprq,djbh,(select huowname from huoweizl b where a.dchw=b.hw) as dchwname,
(select huowname from huoweizl b where a.drhw=b.hw) as drhwname,bm,ywy
 from dbhz a order by  kaiprq DESC

单据抬头sql

select kaiprq,djbh,(select huowname from huoweizl b where a.dchw=b.hw) as dchwname,(select hw from huoweizl b where a.dchw=b.hw) as dchw,
(select huowname from huoweizl b where a.drhw=b.hw) as drhwname,(select hw from huoweizl b where a.drhw=b.hw) as drhw,bm,ywy
 from dbhz a
where a.djbh=:djbh

单据明细sql

select djbh,dj_sn,a.spid,recnum,dj_sort,xgdjbh,a.dw,pihao,a.jlgg,-shl as shl,-baozhshl as baozhshl,lingsshl,chbdj,dbdj,-dbje as dbje,ml,miejph,a.baozhiqi,drhw,dchw,sxrq,a.lshj,lshe,a.beizhu,b.* from dbmx a,spkfk b where a.spid=b.spid and a.djbh=:djbh

 

转载于:https://www.cnblogs.com/suixufeng/p/3336058.html