<?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="44762,3835525579" ScriptLanguage="PascalScript" ScriptText.Text="&#13;&#10;begin&#13;&#10;&#13;&#10;end." ShowProgress="False" StoreInDFM="False">
  <Datasets>
    <item DataSet="tbRelatorio" DataSetName="tbRelatorio"/>
    <item DataSet="qryEmpresa" DataSetName="qryEmpresa"/>
    <item DataSet="qryPedIten" DataSetName="qryPedIten"/>
    <item DataSet="qryPedidoCapa" DataSetName="qryPedidoCapa"/>
    <item DataSet="qryRegiao" DataSetName="qryRegiao"/>
    <item DataSet="qryPaIten" DataSetName="qryPaIten"/>
  </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="'relPedidoAcesso.fr3'"/>
    <item Name="PastaFotos" Value="'C:\Sisplan\Foto'"/>
    <item Name="Usuario" Value="'SISPLAN'"/>
    <item Name="emp_id" Value="'1'"/>
    <item Name="DT_SAIDA" Value="''"/>
    <item Name="DT_EMISSAO" Value="''"/>
    <item Name="TAB_PRE" Value="''"/>
    <item Name="FINANCEIRO" Value="''"/>
    <item Name="DT_FATURA" Value="''"/>
    <item Name="CODCLI" Value="''"/>
    <item Name="COLECAO" Value="''"/>
    <item Name="NUMERO" Value="'00019'"/>
    <item Name="BLOQUEIO" Value="''"/>
    <item Name="ENTREGA" Value="''"/>
    <item Name="TELA_ORDENACAO" Value="''"/>
  </Variables>
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxFDDatabase Name="Conexao" DriverName="FB" DatabaseName="C:\Sisplan\Base\14148F.FDB" Params.Text="Protocol=TCPIP&#13;&#10;Database=C:\Sisplan\Base\14148F.FDB&#13;&#10;Server=192.168.1.254&#13;&#10;user_name=SYSDBA&#13;&#10;password=masterkey&#13;&#10;MonitorBy=Remote&#13;&#10;DriverID=FB&#13;&#10;ApplicationName=C:\Sisplan\apiWeb.exe&#13;&#10;Port=3050" LoginPrompt="False" Connected="false" PropData="05704C656674021A0470546F700237"/>
    <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="169" Top="61">
      <Parameters>
        <item Name="EMP_ID" DataType="ftInteger" Expression="&#60;emp_id&#62;"/>
      </Parameters>
    </TfrxFDQuery>
    <TfrxFDQuery Name="qryPedIten" UserName="qryPedIten" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="SELECT PEDI.NUMERO, PEDI.CODIGO, PEDI.PRECO, PEDI.QTDE, PEDI.QTDE_F, PEDI.TAM, PEDI.COR, PEDI.QTDE_ORIG,&#13;&#10;C.DESCRICAO AS DESCRICAO_COR, PRO.DESCRICAO, PA.CODIGO, PA.COR, PA.TAM, PA.QUANTIDADE, PA.BARRACLI, PA.LOCAL, CAD.DESCRICAO&#13;&#10;FROM PED_ITEN_001 PEDI&#13;&#10;LEFT JOIN PRODUTO_001 PRO&#13;&#10;ON PEDI.CODIGO=PRO.CODIGO&#13;&#10;LEFT JOIN CADCOR_001 C&#13;&#10;ON PEDI.COR = C.COR&#13;&#10;LEFT JOIN PA_ITEN_001 PA&#13;&#10;ON PA.CODIGO = PEDI.CODIGO AND PEDI.COR = PA.COR AND PEDI.QUALIDADE = PA.TIPO&#13;&#10;AND PEDI.TAM = PA.TAM&#13;&#10;LEFT JOIN CAD_LOC_ESTOQ_001 CAD&#13;&#10;ON CAD.CODIGO = PA.LOCAL&#13;&#10;LEFT JOIN PEDIDO_001 PE&#13;&#10;ON PEDI.NUMERO = PE.NUMERO&#13;&#10;WHERE PEDI.NUMERO= :NUMERO     &#13;&#10;AND PEDI.COR = PA.COR&#13;&#10;AND PEDI.TAM = PA.TAM&#13;&#10;AND PE.DEPOSITO = PA.DEPOSITO                 " MacroCreate="True" MacroExpand="True" ReadOnly="False" Database="Conexao" Left="232" Top="61">
      <Parameters>
        <item Name="NUMERO" DataType="ftString" Expression="&#60;tbRelatorio.&#34;NUMERO&#34;&#62;"/>
      </Parameters>
    </TfrxFDQuery>
    <TfrxFDQuery Name="qryPedidoCapa" UserName="qryPedidoCapa" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="SELECT &#13;&#10;PED.CODCLI, EN.NOME, ENT.CNPJ, PED.CLI_BAIRRO, PED.CLI_CEP, PED.CLI_COMPL, PED.CLI_DDD, PED.CLI_FONE, PED.CLI_END, PED.CLI_NUM, PED.PGTO, PED.PED_CLI, ENT.EMAIL,                                      &#13;&#10;PED.CODREP, REP.NOME AS REP_NOME, PED.DESCONTO, PED.FRETE, PED.PER_DESC, PED.PERC_DESC_EMPENHO, PED.VAL_DESC_EMPENHO, PED.CIF, PED.REDESP_CIF, PED.STATUS, PED.DT_EMISSAO, ST.DESCRICAO,   &#13;&#10;PED.TAB_TRANS, TAB.NOME AS TRANSPORTADORA_NOME, CID.NOME AS CIDADE, CID.COD_UF                           &#13;&#10;FROM PEDIDO_001 PED&#13;&#10;LEFT JOIN SITPROD_001 ST    &#13;&#10;ON PED.STATUS = ST.CODIGO&#13;&#10;LEFT JOIN TABTRAN_001 TAB           &#13;&#10;ON PED.TAB_TRANS = TAB.CODIGO&#13;&#10;LEFT JOIN REPRESEN_001 REP&#13;&#10;ON PED.CODREP=REP.CODREP&#13;&#10;LEFT JOIN ENTIDADE_001 ENT&#13;&#10;ON PED.CODCLI=ENT.CODCLI&#13;&#10;LEFT JOIN CADCEP_001 CEPC&#13;&#10;ON PED.CLI_CEP = CEPC.CEP&#13;&#10;LEFT JOIN CIDADE CID&#13;&#10;ON CEPC.CODMUN=CID.CODIGO &#13;&#10;LEFT JOIN ENTIDADE_001 EN&#13;&#10;ON PED.CODCLI=EN.CODCLI  &#13;&#10;WHERE PED.NUMERO = :NUMERO                                                                                               " MacroCreate="True" MacroExpand="True" ReadOnly="False" Database="Conexao" Left="299" Top="61">
      <Parameters>
        <item Name="NUMERO" DataType="ftString" Expression="&#60;tbRelatorio.&#34;NUMERO&#34;&#62;"/>
      </Parameters>
    </TfrxFDQuery>
    <TfrxFDQuery Name="qryRegiao" UserName="qryRegiao" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="SELECT REGIAO, DESCRICAO FROM REGIAO_001 WHERE REGIAO= :TAB_PRECO                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       " MacroCreate="True" MacroExpand="True" ReadOnly="False" Database="Conexao" Left="364" Top="61">
      <Parameters>
        <item Name="TAB_PRECO" DataType="ftInteger" Expression="&#60;tbRelatorio.&#34;TAB_PRE&#34;&#62;"/>
      </Parameters>
    </TfrxFDQuery>
    <TfrxFDQuery Name="qryPaIten" UserName="qryPaIten" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="SELECT PA.CODIGO, PA.COR, PA.TAM, PA.BARRACLI, PA.DEPOSITO, PA.LOCAL, PA.QUANTIDADE, PE.CODIGO, PE.NUMERO                       &#13;&#10;FROM PA_ITEN_001 PA&#13;&#10;INNER JOIN PED_ITEN_001 PE ON PE.CODIGO = PA.CODIGO&#13;&#10;WHERE PE.CODIGO = :NUMERO                                                                                        " MacroCreate="True" MacroExpand="True" ReadOnly="False" Database="Conexao" Left="437" Top="63">
      <Parameters>
        <item Name="NUMERO" DataType="ftString" Expression="&#60;tbRelatorio.&#34;NUMERO&#34;&#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="">
    <TfrxPageHeader Name="PageHeader1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="141,92919" Left="0" Top="18,89765" Width="718,1107">
      <TfrxMemoView Name="Memo2" AllowVectorExport="True" Left="619,06339" Top="12,67718" Width="98,26778" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-8" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="Pag.: [&#60;Page#&#62;] / [&#60;TotalPages#&#62;]">
        <Formats>
          <item/>
          <item/>
        </Formats>
      </TfrxMemoView>
      <TfrxMemoView Name="Memo3" AllowVectorExport="True" Left="619,28386" Top="24,11812" Width="98,26778" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-8" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="[vUsuario]"/>
      <TfrxMemoView Name="Memo4" AllowVectorExport="True" Left="0" Top="71,03154" Width="718,1107" Height="18,89765" DataSetName="tbEmpresa" Font.Charset="1" Font.Color="-16777208" Font.Height="-16" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="PEDIDO: [qryPedIten.&#34;NUMERO&#34;]"/>
      <TfrxMemoView Name="tbEmpresaEMP_NOME" AllowVectorExport="True" Left="114,94496" Top="-0,22047" Width="498,89796" Height="18,89765" DataSetName="tbEmpresa" Font.Charset="1" Font.Color="-16777208" Font.Height="-15" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="[qryEmpresa.&#34;EMP_NOME&#34;]">
        <Formats>
          <item/>
          <item/>
        </Formats>
      </TfrxMemoView>
      <TfrxMemoView Name="Date" AllowVectorExport="True" Left="619,28386" Top="2,44094" Width="98,26778" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-8" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[Date] - [Time]">
        <Formats>
          <item/>
          <item/>
        </Formats>
      </TfrxMemoView>
      <TfrxMemoView Name="Memo6" AllowVectorExport="True" Left="114,94496" Top="17,01577" Width="498,89796" Height="15,11812" DataSetName="tbEmpresa" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[qryEmpresa.&#34;EMP_ENDERECO&#34;], [qryEmpresa.&#34;EMP_NUMERO&#34;], [qryEmpresa.&#34;EMP_BAIRRO&#34;], [qryEmpresa.&#34;EMP_CIDADE&#34;]([qryEmpresa.&#34;EMP_ESTADO&#34;]) - [qryEmpresa.&#34;EMP_CEP&#34;]">
        <Formats>
          <item/>
          <item/>
          <item/>
        </Formats>
      </TfrxMemoView>
      <TfrxPictureView Name="Picture1" AllowVectorExport="True" Left="2,22047" Top="0" Width="109,60637" Height="73,03154" Center="True" DataField="EMP_LOGO" DataSet="qryEmpresa" DataSetName="qryEmpresa" Frame.Typ="0" HightQuality="False" Transparent="False" TransparentColor="16777215"/>
      <TfrxMemoView Name="Memo26" AllowVectorExport="True" Left="619,28386" Top="36,7953" Width="98,26778" Height="15,11812" Font.Charset="1" Font.Color="-16777208" Font.Height="-8" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" VAlign="vaCenter" Text="[vLayout]"/>
      <TfrxMemoView Name="qryEmpresaEMP_EMAIL" IndexTag="1" AllowVectorExport="True" Left="114,94496" Top="46,10235" Width="184,63018" Height="15,89765" DataField="EMP_EMAIL" DataSet="qryEmpresa" DataSetName="qryEmpresa" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="[qryEmpresa.&#34;EMP_EMAIL&#34;]"/>
      <TfrxMemoView Name="qryEmpresaEMP_TELEFONE" IndexTag="1" AllowVectorExport="True" Left="114,94496" Top="30,10235" Width="202,3859" Height="18,89765" DataSet="qryEmpresa" DataSetName="qryEmpresa" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="TELEFONE: [qryEmpresa.&#34;EMP_TELEFONE&#34;]"/>
      <TfrxMemoView Name="Memo64" AllowVectorExport="True" Left="3" Top="-5,89765" Width="49,26778" Height="17,33859" Font.Charset="1" Font.Color="-16777208" Font.Height="-12" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" WordWrap="False" Text=""/>
      <TfrxBarCodeView Name="BarCode1" AllowVectorExport="True" Left="332,59864" Top="94,48825" Width="101" Height="41,57483" BarType="bcCodeCodabar" Expression="&#60;tbRelatorio.&#34;NUMERO&#34;&#62;" Frame.Typ="0" Rotation="0" TestLine="False" Text="12345678" WideBarRatio="2" Zoom="1" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Arial" Font.Style="0" ColorBar="0"/>
    </TfrxPageHeader>
    <TfrxGroupHeader Name="GroupHeader1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="26,23593" Left="0" Top="222,99227" Width="718,1107" Condition="tbRelatorio.&#34;NUMERO&#34;">
      <TfrxMemoView Name="Memo30" AllowVectorExport="True" Left="3,77953" Top="-0,37817" Width="186,29932" Height="17,33859" Font.Charset="1" Font.Color="-16777208" Font.Height="-12" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" WordWrap="False" Text="Data de Emissão: [qryPedidoCapa.&#34;DT_EMISSAO&#34;]"/>
      <TfrxShapeView Name="Shape3" AllowVectorExport="True" Left="0" Top="19,56679" Width="718,1107" Height="3,77953" Fill.BackColor="-16777201" Frame.Typ="0" Shape="skRoundRectangle"/>
      <TfrxMemoView Name="Memo13" AllowVectorExport="True" Left="194,31509" Top="-1" Width="435,7483" Height="17,33859" Font.Charset="1" Font.Color="-16777208" Font.Height="-12" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" WordWrap="False" Text="Nome: [qryPedidoCapa.&#34;NOME&#34;]"/>
      <TfrxMemoView Name="Memo17" AllowVectorExport="True" Left="632,85869" Top="0,77953" Width="83,63791" Height="15,11812" DataSet="qryPedIten" DataSetName="qryPedIten" DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" Fill.BackColor="16777215" HAlign="haRight" ParentFont="False" Processing.ProcessAt="paGroupFinished" WordWrap="False" VAlign="vaCenter" Text="QTDE Total: [SUM(&#60;qryPedIten.&#34;QTDE&#34;&#62;,MasterData1,1)]"/>
    </TfrxGroupHeader>
    <TfrxMasterData Name="MasterData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="41,57483" Left="0" Top="272,12616" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="qryPedIten" DataSetName="qryPedIten" RowCount="0">
      <TfrxMemoView Name="Memo9" AllowVectorExport="True" Left="664,3859" Top="1,98392" Width="49,62214" Height="11,33859" DataField="QTDE" DataSet="qryPedIten" DataSetName="qryPedIten" DisplayFormat.FormatStr="%2.0n" 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="[qryPedIten.&#34;QTDE&#34;]"/>
      <TfrxMemoView Name="Memo10" AllowVectorExport="True" Left="206,24397" Top="13,32251" Width="83,72449" Height="11,33859" DataField="DESCRICAO_COR" DataSet="qryPedIten" DataSetName="qryPedIten" 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="[qryPedIten.&#34;DESCRICAO_COR&#34;]"/>
      <TfrxMemoView Name="Memo50" AllowVectorExport="True" Left="-0,11812" Top="1,98392" Width="204,66945" Height="11,33859" DataSet="qryPedIten" DataSetName="qryPedIten" 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="[qryPedIten.&#34;BARRACLI&#34;]"/>
      <TfrxMemoView Name="Memo51" AllowVectorExport="True" Left="-1,03154" Top="13,32251" Width="204,66945" Height="11,33859" DataField="DESCRICAO" DataSet="qryPedIten" DataSetName="qryPedIten" 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="[qryPedIten.&#34;DESCRICAO&#34;]"/>
      <TfrxMemoView Name="Memo63" AllowVectorExport="True" Left="2,12616" Top="39,10204" Width="714,906" Height="11,33859" DataSet="qryPedIten" DataSetName="qryPedIten" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Style="fsDot" Frame.Typ="4" Frame.Width="0,5" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text=""/>
      <TfrxMemoView Name="Memo14" AllowVectorExport="True" Left="0" Top="26,45671" Width="178,21274" Height="11,33859" DataSet="qryPedIten" DataSetName="qryPedIten" 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="Localização: [qryPedIten.&#34;DESCRICAO_1&#34;]"/>
      <TfrxMemoView Name="Memo15" AllowVectorExport="True" Left="183,62214" Top="26,45671" Width="529,70903" Height="11,33859" DataSet="qryPedIten" DataSetName="qryPedIten" 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="Disponível: [qryPedIten.&#34;DESCRICAO_1&#34;] [qryPedIten.&#34;QUANTIDADE&#34;]"/>
    </TfrxMasterData>
    <TfrxGroupFooter Name="GroupFooter1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="22,67718" Left="0" Top="336,37817" Visible="False" Width="718,1107">
      <TfrxMemoView Name="Memo16" AllowVectorExport="True" Left="665,19728" Top="7,55906" Width="53,40167" Height="11,33859" DataSet="qryPedIten" DataSetName="qryPedIten" DisplayFormat.FormatStr="%2.0n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" Fill.BackColor="16777215" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SUM(&#60;qryPedIten.&#34;QTDE&#34;&#62;,MasterData1,1)]"/>
    </TfrxGroupFooter>
  </TfrxReportPage>
</TfrxReport>
