<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="6.7.9" DotMatrixReport="False" EngineOptions.DoublePass="True" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="167935" PreviewOptions.Zoom="1" PrintOptions.Printer="Padrão" PrintOptions.PrintOnSheet="0" ReportOptions.CreateDate="43487,3236286458" ReportOptions.Description.Text="" ReportOptions.LastChange="44665,7325080093" ScriptLanguage="PascalScript" ScriptText.Text="&#13;&#10;begin&#13;&#10;&#13;&#10;end.">
  <Datasets>
    <item DataSet="tbRelatorio" DataSetName="tbRelatorio"/>
    <item DataSet="QryEmpresa" DataSetName="QryEmpresa"/>
    <item DataSet="QryParcelas" DataSetName="QryParcelas"/>
  </Datasets>
  <Variables>
    <item Name=" Sisplan"/>
    <item Name="vUsuario" Value="'SISPLAN'"/>
    <item Name="vLayout" Value="''"/>
    <item Name="vNivel" Value="''"/>
    <item Name="vNivelDesc" Value="''"/>
    <item Name="vPastaFotos" Value="'C:\Sisplan\..\Foto\'"/>
    <item Name="vPath" Value="'C:\Sisplan'"/>
    <item Name="vTipoBanco" Value="'F'"/>
    <item Name="Empresa" Value="'_001'"/>
    <item Name="Layout" Value="'BaixasReceber.fr3'"/>
    <item Name="PastaFotos" Value="''"/>
    <item Name="Usuario" Value="'SISPLAN'"/>
    <item Name="emp_id" Value="'1'"/>
  </Variables>
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxFDDatabase Name="Conexao" DriverName="FB" DatabaseName="d:\dados\Bases\14184001F.FDB" Params.Text="Protocol=TCPIP&#13;&#10;Database=d:\dados\Bases\14184001F.FDB&#13;&#10;Server=172.20.10.204&#13;&#10;Port=3051&#13;&#10;user_name=sysdba&#13;&#10;password=masterkey&#13;&#10;MonitorBy=Remote&#13;&#10;DriverID=FB" LoginPrompt="False" Connected="false" PropData="05704C65667402640470546F70038400"/>
    <TfrxFDQuery Name="QryEmpresa" UserName="QryEmpresa" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="                SELECT * FROM EMPRESA                                                  " MacroCreate="True" MacroExpand="True" ReadOnly="False" Database="Conexao" Left="196" Top="132"/>
    <TfrxFDQuery Name="QryParcelas" UserName="QryParcelas" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" Master="tbRelatorio" IgnoreDupParams="False" SQL.Text="SELECT R.NUMERO, R.DT_VENCTO, R.DT_EMISSAO, MOE.CODMOE, MOE.DESCRICAO, R.NRO_CUPOM, R.VALOR, RB.DT_PAGTO, R.VALOR_PAGO, R.VALOR2, SUM(RB.DESCONTO) DESCONTO, SUM(RB.JUROS) JUROS                                                                                                                         &#13;&#10;FROM RECEBER_001 R    &#13;&#10;LEFT JOIN RECEBERB_001 RB ON (RB.NUMERO = R.NUMERO)&#13;&#10;LEFT JOIN MOEDA_001 MOE ON (MOE.CODMOE = RB.MOEDA) &#13;&#10;WHERE R.NUMERO = (:NUMERO)&#13;&#10;GROUP BY R.NUMERO, R.DT_VENCTO, R.DT_EMISSAO, MOE.CODMOE, MOE.DESCRICAO, R.NRO_CUPOM, R.VALOR, RB.DT_PAGTO, R.VALOR_PAGO, R.VALOR2                                                                                                                " MacroCreate="True" MacroExpand="True" ReadOnly="False" Database="Conexao" MasterFields="NUMERO=NUMERO" Left="384" Top="140">
      <Parameters>
        <item Name="NUMERO" DataType="ftString" Expression="&#60;tbRelatorio.&#34;NUMERO&#34;&#62;"/>
      </Parameters>
    </TfrxFDQuery>
  </TfrxDataPage>
  <TfrxReportPage Name="Page1" PaperWidth="72" PaperHeight="3276" PaperSize="256" LeftMargin="5" RightMargin="5" TopMargin="5" BottomMargin="5" ColumnWidth="0" ColumnPositions.Text="" Frame.Typ="0" MirrorMode="0" HGuides.Text="" VGuides.Text="">
    <TfrxMasterData Name="MasterData2" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="0" Left="0" Top="147,40167" Width="234,33086" ColumnWidth="0" ColumnGap="0" DataSet="tbRelatorio" DataSetName="tbRelatorio" RowCount="0"/>
    <TfrxPageFooter Name="PageFooter1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="15,11812" Left="0" Top="370,39394" Width="234,33086">
      <TfrxMemoView Name="Memo1" AllowVectorExport="True" Left="0" Top="3,77953" Width="653,85869" Height="11,33859" Font.Charset="1" Font.Color="-16777208" Font.Height="-8" Font.Name="Arial" Font.Style="0" Frame.Typ="4" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="Sisplan Sistemas e Planejamento LTDA - (47) 3380-6100  - "/>
      <TfrxMemoView Name="Memo25" AllowVectorExport="True" Left="0" Top="3,77953" Width="347,71676" Height="11,33859" Font.Charset="1" Font.Color="-16777208" Font.Height="-8" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" VAlign="vaCenter" Text="[&#60;vNivel&#62;] - [&#60;vNivelDesc&#62;]"/>
      <TfrxMemoView Name="Memo23" AllowVectorExport="True" Left="650,5201" Top="3,77953" Width="105,82684" Height="11,33859" Hyperlink.Value="https://sisplansistemas.com.br/" Font.Charset="1" Font.Color="16711680" Font.Height="-8" Font.Name="Arial" Font.Style="0" Frame.Typ="4" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="www.sisplansistemas.com.br"/>
    </TfrxPageFooter>
    <TfrxReportTitle Name="ReportTitle1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="45,35436" Left="0" Top="18,89765" Width="234,33086">
      <TfrxMemoView Name="Memo13" AllowVectorExport="True" Left="-7,55906" Top="0" Width="234,33086" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="RECIBO DE BAIXA"/>
      <TfrxMemoView Name="Memo2" AllowVectorExport="True" Left="-7,55906" Top="17,89765" Width="238,11039" Height="26,45671" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="[QryEmpresa.&#34;EMP_FANTASIA&#34;] - CNPJ: [QryEmpresa.&#34;EMP_CNPJ&#34;]">
        <Formats>
          <item/>
          <item/>
        </Formats>
      </TfrxMemoView>
    </TfrxReportTitle>
    <TfrxGroupHeader Name="GroupHeader2" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="0" Left="0" Top="124,72449" Width="234,33086" Condition="QryParcelas.&#34;NUMERO&#34;"/>
    <TfrxGroupFooter Name="GroupFooter1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="3,77953" Left="0" Top="306,14193" Width="234,33086"/>
    <TfrxDetailData Name="DetailData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="113,60637" Left="0" Top="170,07885" Width="234,33086" ColumnWidth="0" ColumnGap="0" DataSet="QryParcelas" DataSetName="QryParcelas" RowCount="1">
      <TfrxMemoView Name="Memo21" AllowVectorExport="True" Left="0" Top="0" Width="52,91342" Height="15,11812" DataSet="QryEmpresa" DataSetName="QryEmpresa" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="1" Frame.Typ="13" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="NÚMERO"/>
      <TfrxMemoView Name="Memo5" IndexTag="1" AllowVectorExport="True" Left="111,60637" Top="0" Width="60,47248" Height="15,11812" DataSet="QryParcelas" DataSetName="QryParcelas" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="1" Frame.Typ="12" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="VLR PAGO"/>
      <TfrxMemoView Name="Memo22" IndexTag="1" AllowVectorExport="True" Left="52,26778" Top="0" Width="60,47248" Height="15,11812" DataSet="QryParcelas" DataSetName="QryParcelas" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="1" Frame.Typ="12" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="VALOR"/>
      <TfrxMemoView Name="Memo24" IndexTag="1" AllowVectorExport="True" Left="171,37013" Top="0" Width="64,25201" Height="15,11812" DataSet="QryParcelas" DataSetName="QryParcelas" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="1" Frame.Typ="14" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="VENCTO"/>
      <TfrxMemoView Name="QryParcelasVENCIMENTO" IndexTag="1" AllowVectorExport="True" Left="171,37013" Top="15,33859" Width="64,25201" Height="15,11812" DataSet="QryParcelas" DataSetName="QryParcelas" DisplayFormat.FormatStr="dd/mm/yyyy" DisplayFormat.Kind="fkDateTime" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Style="fsDot" Frame.Typ="0" Frame.Width="0,5" HAlign="haRight" ParentFont="False" WordWrap="False" Text="[QryParcelas.&#34;DT_VENCTO&#34;]"/>
      <TfrxMemoView Name="Memo4" IndexTag="1" AllowVectorExport="True" Left="115,3859" Top="15,33859" Width="56,69295" Height="15,11812" DataSet="QryParcelas" DataSetName="QryParcelas" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Style="fsDot" Frame.Typ="0" Frame.Width="0,5" HAlign="haRight" ParentFont="False" WordWrap="False" Text="[&#60;QryParcelas.&#34;VALOR_PAGO&#34;&#62;]"/>
      <TfrxMemoView Name="QryParcelasVALOR" IndexTag="1" AllowVectorExport="True" Left="52,26778" Top="15,33859" Width="60,47248" Height="15,11812" DataSet="QryParcelas" DataSetName="QryParcelas" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Style="fsDot" Frame.Typ="0" Frame.Width="0,5" HAlign="haRight" ParentFont="False" WordWrap="False" Text="[QryParcelas.&#34;VALOR2&#34;]"/>
      <TfrxMemoView Name="Memo20" AllowVectorExport="True" Left="0" Top="15,33859" Width="52,91342" Height="15,11812" DataSet="QryEmpresa" DataSetName="QryEmpresa" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Style="fsDot" Frame.Typ="0" Frame.Width="0,5" ParentFont="False" WordWrap="False" Text="[tbRelatorio.&#34;NUMERO&#34;]">
        <Formats>
          <item/>
          <item/>
        </Formats>
      </TfrxMemoView>
      <TfrxMemoView Name="Memo14" AllowVectorExport="True" Left="0,44094" Top="83,5906" Width="79,37013" Height="15,11812" DataSet="QryEmpresa" DataSetName="QryEmpresa" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" WordWrap="False" Text="Data de Emissão: "/>
      <TfrxMemoView Name="Memo15" AllowVectorExport="True" Left="79,03154" Top="83,5906" Width="83,14966" Height="15,11812" DataSet="QryEmpresa" DataSetName="QryEmpresa" DisplayFormat.FormatStr="dd/mm/yyyy" DisplayFormat.Kind="fkDateTime" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" WordWrap="False" Text="[QryParcelas.&#34;DT_EMISSAO&#34;]"/>
      <TfrxMemoView Name="Memo6" AllowVectorExport="True" Left="79,03154" Top="98,48825" Width="94,48825" Height="15,11812" DataSet="QryEmpresa" DataSetName="QryEmpresa" DisplayFormat.FormatStr="dd/mm/yyyy" DisplayFormat.Kind="fkDateTime" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" WordWrap="False" Text="[IIF(&#60;QryParcelas.&#34;DT_PAGTO&#34;&#62; = '0', '',&#60;QryParcelas.&#34;DT_PAGTO&#34;&#62;)]"/>
      <TfrxMemoView Name="Memo17" AllowVectorExport="True" Left="0,44094" Top="36,01577" Width="79,37013" Height="15,11812" DataSet="QryEmpresa" DataSetName="QryEmpresa" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" WordWrap="False" Text="Forma de Pagto:"/>
      <TfrxMemoView Name="Memo18" AllowVectorExport="True" Left="79,03154" Top="36,01577" Width="147,40167" Height="15,11812" DataSet="QryEmpresa" DataSetName="QryEmpresa" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" WordWrap="False" Text="[QryParcelas.&#34;CODMOE&#34;] - [QryParcelas.&#34;DESCRICAO&#34;]">
        <Formats>
          <item/>
          <item/>
        </Formats>
      </TfrxMemoView>
      <TfrxMemoView Name="Memo16" AllowVectorExport="True" Left="0,44094" Top="98,48825" Width="79,37013" Height="15,11812" DataSet="QryEmpresa" DataSetName="QryEmpresa" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" WordWrap="False" Text="[IIF(&#60;QryParcelas.&#34;DT_PAGTO&#34;&#62; = '0', '', 'Data de Pagto:')]"/>
      <TfrxMemoView Name="Memo19" AllowVectorExport="True" Left="0" Top="15,11812" Width="234,33086" Height="15,11812" DataSet="QryEmpresa" DataSetName="QryEmpresa" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="1" Frame.Style="fsDot" Frame.Typ="8" Frame.Width="0,5" ParentFont="False" WordWrap="False" Text=""/>
      <TfrxMemoView Name="Memo26" AllowVectorExport="True" Left="0,44094" Top="51,91342" Width="79,37013" Height="15,11812" DataSet="QryEmpresa" DataSetName="QryEmpresa" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" WordWrap="False" Text="Desconto:"/>
      <TfrxMemoView Name="Memo28" AllowVectorExport="True" Left="79,03154" Top="51,91342" Width="79,37013" Height="15,11812" DataField="DESCONTO" DataSet="QryParcelas" DataSetName="QryParcelas" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" WordWrap="False" Text="[QryParcelas.&#34;DESCONTO&#34;]"/>
      <TfrxMemoView Name="Memo29" AllowVectorExport="True" Left="0,44094" Top="68,03154" Width="79,37013" Height="15,11812" DataSet="QryEmpresa" DataSetName="QryEmpresa" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" WordWrap="False" Text="Juros:"/>
      <TfrxMemoView Name="Memo30" AllowVectorExport="True" Left="79,37013" Top="68,03154" Width="79,37013" Height="15,11812" DataField="JUROS" DataSet="QryParcelas" DataSetName="QryParcelas" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" WordWrap="False" Text="[QryParcelas.&#34;JUROS&#34;]"/>
    </TfrxDetailData>
    <TfrxMemoView Name="Memo27" AllowVectorExport="True" Left="83,14966" Top="411,96877" Width="79,37013" Height="15,11812" DataSet="QryEmpresa" DataSetName="QryEmpresa" Font.Charset="1" Font.Color="-16777208" Font.Height="-9" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" WordWrap="False" Text=""/>
  </TfrxReportPage>
</TfrxReport>
