selectbc.unitcode,bc.unitname,ih.pk_corp,ih.vbillcode,ih.dbilldate,bd.invcode,bd.invname,ib.nnumber,ib.nmoneyfromia_billih,ia_bill_bib,bd_corpbc,bd_invbasdocbdwhereih.cbillid=ib.cbillidandih.pk_corp=bc.pk_corpandib.cinvbasid=bd.pk_invbasdocandih.dr=0andib.dr=0--已经成本计算andib.iauditsequence>0--数据获得方式为中间成本andib.fdatagetmodelflag=12--计价方式为全月平均andib.fpricemodeflag=4orderbyih.pk_corp,bd.invcode