客商支付明细SQL_billdate

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