 select Id='1', valorbaixado, PlanoConta.CodSistContabil, DTVENCIMENTO,ISNULL(CONTAS.CodSistContabil, '1010101010001'),
HISTORICO=ISNULL(REPLACE(HISTORICO, ';', ' '),'OK'),NUMDOC
    FROM CPR, Contas, PlanoConta
    WHERE CPR.DTBAIXA BETWEEN :DATAINI_D and :DATAFIM_D
    AND CPR.IdPlanoConta = PlanoConta.IdPlanoConta
    AND CPR.CodConta = CONTAS.CodConta
    AND BaixaAutorizada = 'S' AND PagRec = 'P' AND CodTipoDoc <> 07
    AND CODTIPODOC = '04'
    AND TipoContabil = 'C'
    AND CONTAS.CODCONTA <> '25'
    AND DTVENCIMENTO > '2014-12-31'
    AND PlanoConta.IdPlanoConta IN ('39','149','93','472','473','474','476','126','493','26','27','28','29','444','445','32','33','34','154','155','157','158','456',
    '84','85','165','430','31','441','446','447','448','449','450','451','455','494','501','536','537','556','558','607','618','619',
    '645','654','506','507','512','518','519','520','521','522','634','525','526','527','528','529','530','531','532','533','534','551',
    '552','553','571','572','574','575','576','577','578','579','580','581','582','584','585','586','587','588','589','590','591','592')