sql查询工程结算分包款转出

select gl_detail.explanation,
      bd_accsubj.subjcode,
      bd_accsubj.dispname,       
       gl_detail.debitamount 借方,   
        gl_detail.creditamount 贷方,
        gl_detail.prepareddatev 制单日期 , 
       gl_voucher.no 凭证号, 
       to_char(wmsys.wm_concat(gl_freevalue.valuecode)) valuecode,
        to_char(wmsys.wm_concat(gl_freevalue.valuename)) valuename
         from gl_detail, bd_accsubj, bd_glorgbook,gl_freevalue,gl_voucher
 where gl_detail.pk_accsubj = bd_accsubj.pk_accsubj
   and gl_detail.pk_glorgbook = bd_glorgbook.pk_glorgbook
   and   gl_detail.assid=gl_freevalue.freevalueid
   and gl_detail.pk_voucher=gl_voucher.pk_voucher
   and gl_detail.dr = ‘0‘
   and gl_detail.yearv=‘2014‘
   and bd_glorgbook.glorgbookcode = ‘015101-0001‘
   and bd_accsubj.subjcode like ‘2123%‘ 
   and  gl_detail.creditamount<0
   group by gl_detail.explanation,
   bd_accsubj.subjcode,
         bd_accsubj.dispname,       
       gl_detail.creditamount,
       gl_detail.debitamount,   
         gl_detail.prepareddatev,gl_voucher.no
  order by gl_detail.prepareddatev,gl_voucher.no

sql查询工程结算分包款转出

标签：