销售出库--暂估应收--财务应收单,以及暂估单和暂估冲回单关联关系 sql语句
可参考以下关联关系语句
---销售出库单和下游暂估单关联关系 select * from T_AR_RECEIVABLE a inner join T_AR_RECEIVABLEENTRY b on a.fid=b.fid inner join T_AR_RECEIVABLEENTRY_LK c on c.fentryid=b.FENTRYID and FSTABLENAME='T_SAL_OUTSTOCKENTRY' inner join T_SAL_OUTSTOCKentry d on d.FENTRYID=c.FSID and d.fid=c.FSBILLID inner join T_SAL_OUTSTOCK e on e.fid=d.fid ---暂估应收和财务应收关联关系 select e.fdate,a.fbillno 财务应收,e.fbillno 暂估应收,* from T_AR_RECEIVABLE a ---财务单 inner join T_AR_RECEIVABLEENTRY b on a.fid=b.fid inner join T_AR_RECEIVABLEENTRY_lk c on c.FENTRYID=b.FENTRYID and c.FSTABLENAME='T_AR_RECEIVABLEENTRY' inner join T_AR_RECEIVABLEENTRY d on d.FENTRYID=c.FSID and d.FID=c.FSBILLID inner join T_AR_RECEIVABLE e on e.fid=d.fid ---暂估单 where a.FSETACCOUNTTYPE=3 and e.FSETACCOUNTTYPE=2 ---暂估应收和暂估红冲关联关联 select a.fbillno 红冲,d.fbillno 暂估, a.fbillno 冲回,* from T_AR_RECEIVABLE a ---冲回单 left join T_AR_RECEIVABLEENTRY b on a.fid=b.fid left join T_AR_RECEIVABLEENTRY c on c.FENTRYID=b.FSRCROWID inner join T_AR_RECEIVABLE d on d.fid=c.fid ---暂估单 where a.FBYVERIFY=2 and d.FBYVERIFY=0
销售出库--暂估应收--财务应收单,以及暂估单和暂估冲回单关联关系 sql语句
可参考以下关联关系语句---销售出库单和下游暂估单关联关系select * from T_AR_RECEIVABLE ainner join T_AR_RECEIVABLEENTRY b on a.fid=b...
点击下载文档
上一篇:财务报表下一篇:星空发票表与应付明细表之间关联
本文2024-09-16 17:32:35发表“云星空知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3cloud-16377.html
您需要登录后才可以发表评论, 登录登录 或者 注册
最新文档
热门文章