select c.FBillID 发票内码,max(t.FDate) FDate from t_rp_checkEntry c
join t_rp_newcheckinfo a on c.FInterID=a.FInterID
join t_rp_contact b on a.FContactID=b.FID
inner join (
select b.FDate, c.FID from t_rp_checkEntry c
join t_rp_newcheckinfo a on c.FInterID=a.FInterID
join t_rp_contact b on a.FContactID=b.FID
where c.FType=5) t on t.FID=c.FID
where c.FType=3 group by c.FBillID
金蝶WISE获取最新核销收款日期
最新推荐文章于 2024-09-19 11:25:27 发布