<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="6.7.9" DotMatrixReport="False" EngineOptions.SilentMode="True" EngineOptions.NewSilentMode="simSilent" EngineOptions.UseFileCache="True" IniFile="\Software\Fast Reports" PreviewOptions.AllowEdit="False" PreviewOptions.Buttons="167935" PreviewOptions.Zoom="1" PrintOptions.Printer="Padrão" PrintOptions.PrintOnSheet="0" ReportOptions.CreateDate="43487,3236286458" ReportOptions.Description.Text="" ReportOptions.LastChange="44818,6708746643" ScriptLanguage="PascalScript" ScriptText.Text="begin&#13;&#10;&#13;&#10;end." ShowProgress="False" StoreInDFM="False">
  <Datasets>
    <item DataSet="tbRelatorio" DataSetName="tbRelatorio"/>
    <item DataSet="qryReceber" DataSetName="qryReceber"/>
    <item DataSet="qryEmpresa" DataSetName="qryEmpresa"/>
  </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="'_005'"/>
    <item Name="Layout" Value="'Receber.fr3'"/>
    <item Name="PastaFotos" Value="'\\172.20.10.208\arquivos\Desenvolvimento\Sisplan\Foto'"/>
    <item Name="Usuario" Value="'SISPLAN'"/>
    <item Name="emp_id" Value="'8'"/>
    <item Name="NUMERO" Value="'''1102C-1/8'''"/>
    <item Name="TELA_ORDENACAO" Value="''"/>
  </Variables>
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxFDDatabase Name="Conexao" DriverName="SisplanMSSqlDB" DatabaseName="14809S" Params.Text="Protocol=TCPIP&#13;&#10;Database=14809S&#13;&#10;Server=172.20.10.212&#13;&#10;user_name=sa&#13;&#10;password=Sisposm,&#13;&#10;MonitorBy=Remote&#13;&#10;DriverID=SisplanMSSqlDB&#13;&#10;ApplicationName=P:\Sisplan\projeto\apiWeb.exe&#13;&#10;Port=3051" LoginPrompt="False" Connected="false" PropData="05704C65667402740470546F70025C"/>
    <TfrxFDQuery Name="qryReceber" UserName="qryReceber" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" Master="tbRelatorio" IgnoreDupParams="False" SQL.Text="SELECT REC.CODCLI, ENT.NOME, REC.DT_EMISSAO, REC.DT_VENCTO, REC.FATURA, REC.NUMERO,  &#13;&#10;REC.PEDIDO, REC.STATUS, REC.VAL_ORIGIN, REC.VAL_PRODUTOS, REC.VALOR, REC.VALOR_PAGO, REC.VALOR2, REC.JUROS,                                    &#13;&#10;REC.DESCONTO, RECB.DESCONTO AS DESCONTO_BAIXA, RECB.NUMERO AS BAIXA_NUMERO, RECB.DT_PAGTO, RECB.VALOR2 AS VALOR2_BAIXA, RECB.VALOR_PAGO AS VALORPAGO_BAIXA&#13;&#10;FROM RECEBER_001 REC&#13;&#10;LEFT JOIN RECEBERB_001 RECB&#13;&#10;ON REC.NUMERO=RECB.NUMERO&#13;&#10;LEFT JOIN ENTIDADE_001 ENT&#13;&#10;ON REC.CODCLI=ENT.CODCLI&#13;&#10;WHERE REC.NUMERO IN (:DUPLICATA)                                                                              " MacroCreate="True" MacroExpand="True" ReadOnly="False" Database="Conexao" Left="228" Top="99">
      <Parameters>
        <item Name="DUPLICATA" DataType="ftString" Expression="&#60;tbRelatorio.&#34;NUMERO&#34;&#62;"/>
      </Parameters>
    </TfrxFDQuery>
    <TfrxFDQuery Name="qryEmpresa" UserName="qryEmpresa" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="SELECT * FROM EMPRESA WHERE EMP_ID = :EMP_ID                                                                                                    " MacroCreate="True" MacroExpand="True" ReadOnly="False" Database="Conexao" Left="280" Top="98">
      <Parameters>
        <item Name="EMP_ID" DataType="ftInteger" Expression="&#60;emp_id&#62;"/>
      </Parameters>
    </TfrxFDQuery>
  </TfrxDataPage>
  <TfrxReportPage Name="Page1" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" Frame.Typ="0" MirrorMode="0" HGuides.Text="" VGuides.Text="">
    <TfrxMasterData Name="MasterData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="19" Left="0" Top="215,43321" Width="718,1107" OnBeforePrint="MasterData1OnBeforePrint" ColumnWidth="0" ColumnGap="0" DataSet="tbRelatorio" DataSetName="tbRelatorio" RowCount="0" Stretched="True">
      <TfrxMemoView Name="fundoColor" AllowVectorExport="True" Left="0" Top="0,75572" Width="718,1107" Height="15,11812" DataSet="qryReceber" DataSetName="qryReceber" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Style="fsDot" Frame.Typ="8" Frame.Width="0,5" HAlign="haCenter" Highlight.ApplyFont="False" Highlight.ApplyFill="False" Highlight.Font.Charset="1" Highlight.Font.Color="255" Highlight.Font.Height="-13" Highlight.Font.Name="Arial" Highlight.Font.Style="0" Highlight.Condition="&#60;qryReceber.&#34;VALORPAGO_BAIXA&#34;&#62; = 0" Highlight.FillType="ftBrush" Highlight.Frame.Typ="0" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text=""/>
      <TfrxMemoView Name="Memo33" AllowVectorExport="True" Left="0" Top="0,4329" Width="719,37013" Height="16,33859" DataSet="qryReceber" DataSetName="qryReceber" DisplayFormat.FormatStr="DD/MM/YYYY" DisplayFormat.Kind="fkDateTime" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text=""/>
      <TfrxMemoView Name="Memo17" AllowVectorExport="True" Left="3" Top="1,32282" Width="60,47248" Height="11,33859" DataField="NUMERO" DataSet="qryReceber" DataSetName="qryReceber" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[qryReceber.&#34;NUMERO&#34;]"/>
      <TfrxMemoView Name="Memo18" AllowVectorExport="True" Left="63" Top="1,32282" Width="176,3859" Height="11,33859" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[qryReceber.&#34;CODCLI&#34;] - [qryReceber.&#34;NOME&#34;]"/>
      <TfrxMemoView Name="Memo20" AllowVectorExport="True" Left="324" Top="1,32282" Width="68,03154" Height="11,33859" DataSet="qryReceber" DataSetName="qryReceber" DisplayFormat.FormatStr="DD/MM/YYYY" DisplayFormat.Kind="fkDateTime" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[qryReceber.&#34;DT_VENCTO&#34;]"/>
      <TfrxMemoView Name="Memo22" AllowVectorExport="True" Left="448" Top="1,32282" Width="60,04731" Height="11,33859" DataField="VALOR2" DataSet="qryReceber" DataSetName="qryReceber" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[qryReceber.&#34;VALOR2&#34;]"/>
      <TfrxMemoView Name="Memo23" AllowVectorExport="True" Left="598" Top="1,32282" Width="60,47248" Height="11,33859" DataField="VALOR_PAGO" DataSet="qryReceber" DataSetName="qryReceber" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[qryReceber.&#34;VALOR_PAGO&#34;]"/>
      <TfrxMemoView Name="Memo24" AllowVectorExport="True" Left="660" Top="1,32282" Width="56,69295" Height="11,33859" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[&#60;qryReceber.&#34;VALOR2&#34;&#62; - &#60;qryReceber.&#34;VALOR_PAGO&#34;&#62;]"/>
      <TfrxMemoView Name="Memo27" AllowVectorExport="True" Left="394" Top="1,32282" Width="52,91342" Height="11,33859" DataField="STATUS" DataSet="qryReceber" DataSetName="qryReceber" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[qryReceber.&#34;STATUS&#34;]"/>
      <TfrxMemoView Name="Memo30" AllowVectorExport="True" Left="511" Top="1,32282" Width="41,57483" Height="11,33859" DataField="DESCONTO" DataSet="qryReceber" DataSetName="qryReceber" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[qryReceber.&#34;DESCONTO&#34;]"/>
      <TfrxMemoView Name="Memo31" AllowVectorExport="True" Left="554" Top="1,32282" Width="41,57483" Height="11,33859" DataField="JUROS" DataSet="qryReceber" DataSetName="qryReceber" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[qryReceber.&#34;JUROS&#34;]"/>
      <TfrxMemoView Name="Memo19" AllowVectorExport="True" Left="243" Top="1,32282" Width="79,37013" Height="11,33859" DataField="DT_EMISSAO" DataSet="qryReceber" DataSetName="qryReceber" DisplayFormat.FormatStr="DD/MM/YYYY" DisplayFormat.Kind="fkDateTime" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[qryReceber.&#34;DT_EMISSAO&#34;]"/>
    </TfrxMasterData>
    <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="321,26005" Width="718,1107">
      <TfrxMemoView Name="Memo1" AllowVectorExport="True" Left="0" Top="3,77953" Width="718,1107" 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 - www.sisplansistemas.com.br"/>
      <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="[Page#]/[TotalPages#]"/>
    </TfrxPageFooter>
    <TfrxPageHeader Name="PageHeader1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="75,23624" Left="0" Top="18,89765" Width="718,1107">
      <TfrxMemoView Name="Memo4" AllowVectorExport="True" Left="0" Top="44,23624" Width="718,1107" Height="26,45671" DataSetName="tbEmpresa" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="Arial" Font.Style="5" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="RELATÓRIO DE CTAS A RECEBER"/>
      <TfrxMemoView Name="tbEmpresaEMP_NOME" AllowVectorExport="True" Left="109,60637" Top="13,77953" Width="498,89796" Height="26,45671" DataSetName="tbEmpresa" Font.Charset="1" Font.Color="-16777208" Font.Height="-15" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="[qryEmpresa.&#34;EMP_NOME&#34;]">
        <Formats>
          <item/>
          <item/>
        </Formats>
      </TfrxMemoView>
      <TfrxPictureView Name="Picture1" AllowVectorExport="True" Left="6,22047" Top="0" Width="105,82684" Height="68,03154" Center="True" DataField="EMP_LOGO" DataSet="qryEmpresa" DataSetName="qryEmpresa" Frame.Typ="0" HightQuality="True" Transparent="False" TransparentColor="16777215"/>
    </TfrxPageHeader>
    <TfrxGroupHeader Name="GroupHeader1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="0" Left="0" Top="192,75603" Width="718,1107" Condition="tbRelatorio.&#34;NUMERO&#34;" KeepTogether="True" Stretched="True"/>
    <TfrxGroupFooter Name="GroupFooter1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="1,67718" Left="0" Top="257,00804" Width="718,1107" Stretched="True"/>
    <TfrxHeader Name="Header1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="15,11812" Left="0" Top="154,96073" Width="718,1107" ReprintOnNewPage="True" Stretched="True">
      <TfrxShapeView Name="Shape1" AllowVectorExport="True" Left="0" Top="0" Width="718,1107" Height="15,11812" Fill.BackColor="-16777201" Frame.Typ="0" Shape="skRoundRectangle"/>
      <TfrxMemoView Name="Memo7" AllowVectorExport="True" Left="2" Top="1,48825" Width="60,47248" Height="11,33859" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="NÚMERO"/>
      <TfrxMemoView Name="Memo9" AllowVectorExport="True" Left="64" Top="1,48825" Width="176,3859" Height="11,33859" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="CLIENTE"/>
      <TfrxMemoView Name="Memo10" AllowVectorExport="True" Left="243" Top="1,48825" Width="79,37013" Height="11,33859" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="DT EMISSAO"/>
      <TfrxMemoView Name="Memo11" AllowVectorExport="True" Left="324" Top="1,48825" Width="68,03154" Height="11,33859" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="DT VENCTO"/>
      <TfrxMemoView Name="Memo13" AllowVectorExport="True" Left="449" Top="1,48825" Width="60,04731" Height="11,33859" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="VALOR"/>
      <TfrxMemoView Name="Memo14" AllowVectorExport="True" Left="598" Top="1,48825" Width="60,47248" Height="11,33859" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="VLR PAGO"/>
      <TfrxMemoView Name="Memo15" AllowVectorExport="True" Left="660" Top="1,48825" Width="56,69295" Height="11,33859" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="SALDO"/>
      <TfrxMemoView Name="Memo16" AllowVectorExport="True" Left="394" Top="1,48825" Width="52,91342" Height="11,33859" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="STATUS"/>
      <TfrxMemoView Name="Memo28" AllowVectorExport="True" Left="511" Top="1,48825" Width="41,57483" Height="11,33859" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="DESC"/>
      <TfrxMemoView Name="Memo29" AllowVectorExport="True" Left="554" Top="1,48825" Width="41,57483" Height="11,33859" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="JUROS"/>
    </TfrxHeader>
  </TfrxReportPage>
</TfrxReport>
