select arap_djfb.paydate as 付款日期, bd_corp.unitname as 付款单位, bd_cubasdoc.custcode as 收款单位编码, bd_cubasdoc.custname as 收款单位名称, bd_accbank.bankacc as 收款银行账号, arap_djfb.bbye as 付款金额, arap_djfb.fkyhmc as 付款银行, arap_djfb.zy as 付款摘要 from bd_cubasdoc, arap_djfb, bd_cumandoc, arap_djzb, bd_corp, bd_accbank where arap_djfb.ksbm_cl = bd_cumandoc.pk_cumandoc and bd_cumandoc.pk_cubasdoc = bd_cubasdoc.pk_cubasdoc and arap_djfb.vouchid = arap_djzb.vouchid and bd_corp.pk_corp = arap_djzb.dwbm and bd_accbank.pk_accbank = arap_djfb.skyhzh --and arap_djfb.payflag in ('1', '2') and arap_djfb.dr = '0' and bd_corp.unitcode='010301' and arap_djfb.billdate ='2011-09-22' --填制单据日期,可以查询所有填制的,不一定付款 order by bd_corp.unitcode, arap_djfb.paydate, bd_cubasdoc.custname
![](https://img2024.cnblogs.com/blog/35695/202408/35695-20240826070647288-243310440.jpg)