<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="6.7.9" DotMatrixReport="False" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="167935" PreviewOptions.Zoom="1" PrintOptions.Printer="Default" PrintOptions.PrintOnSheet="0" ReportOptions.CreateDate="44110,3966951852" ReportOptions.Description.Text="" ReportOptions.LastChange="44721,6426789236" ScriptLanguage="PascalScript" ScriptText.Text="VAR&#13;&#10;  SOMADESPESAS : DOUBLE;    ///Criado variavel para somar despesas&#13;&#10;procedure MasterData1OnBeforePrint(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;  if Frac(&#60;Line&#62; / 2) = 0.5 then&#13;&#10;    fundoVendas.Color := clBtnFace&#13;&#10;  else&#13;&#10;    fundoVendas.Color := clWhite;&#13;&#10;end;&#13;&#10;&#13;&#10;procedure MasterData3OnBeforePrint(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;  if Frac(&#60;Line&#62; / 2) = 0.5 then&#13;&#10;    fundoSaidas.Color := clBtnFace&#13;&#10;  else&#13;&#10;    fundoSaidas.Color := clWhite;&#13;&#10;IF (&#60;qrySaidas.&#34;DESCRICAO&#34;&#62;) = 'DINHEIRO'  then&#13;&#10; /// VALIDA SE A MOEDA É DO TIPO DINHEIRO&#13;&#10;  BEGIN&#13;&#10; Memo23.text := FormatFloat('#,##0.00',(&#60;qrySaidas.&#34;VALOR&#34;&#62;-SOMADESPESAS));&#13;&#10; /// CASO SIM ELE VAI DESCONTAR DO VALOR DAS SAÍDAS&#13;&#10;  END&#13;&#10;    ELSE&#13;&#10;        BEGIN&#13;&#10;    Memo23.text := (&#60;qrySaidas.&#34;VALOR&#34;&#62;);&#13;&#10;/// CASO NÃO ELE VAI APARECER O VALOR QUE JA ESTAVA NA TELA&#13;&#10;         END&#13;&#10;&#13;&#10;end;&#13;&#10;&#13;&#10;procedure MasterData2OnBeforePrint(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;  if Frac(&#60;Line&#62; / 2) = 0.5 then&#13;&#10;    fundoEntradas.Color := clBtnFace&#13;&#10;  else&#13;&#10;    fundoEntradas.Color := clWhite;&#13;&#10;end;&#13;&#10;&#13;&#10;procedure MasterData4OnBeforePrint(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;  IF (&#60;qrySaidas.&#34;MANUAL&#34;&#62; = 'S') AND (&#60;qrySaidas.&#34;MOEDA&#34;&#62; &#60;&#62; '7')  THEN&#13;&#10;  BEGIN&#13;&#10;         //  SOMADESPESAS := SOMADESPESAS + &#60;qrySaidas.&#34;VALOR&#34;&#62;;&#13;&#10;&#13;&#10;  END&#13;&#10;end;&#13;&#10;&#13;&#10;begin&#13;&#10;&#13;&#10;end.">
  <Datasets>
    <item DataSet="tbRelatorio" DataSetName="tbRelatorio"/>
    <item DataSet="qryCaixa" DataSetName="qryCaixa"/>
    <item DataSet="qryEmpresa" DataSetName="qryEmpresa"/>
    <item DataSet="qryVenda" DataSetName="qryVenda"/>
    <item DataSet="qryEntradas" DataSetName="qryEntradas"/>
    <item DataSet="qrySaidas" DataSetName="qrySaidas"/>
    <item DataSet="QryFechamento" DataSetName="QryFechamento"/>
    <item DataSet="QryTotais" DataSetName="QryTotais"/>
  </Datasets>
  <Variables>
    <item Name="Empresa" Value="'_014'"/>
    <item Name="Layout" Value="'caixa.fr3'"/>
    <item Name="PastaFotos" Value="''"/>
    <item Name="Usuario" Value="'SISPLAN'"/>
    <item Name="emp_id" Value="'14'"/>
    <item Name="DATA" Value="'2022-06-07'"/>
    <item Name="TELA_ORDENACAO" Value="''"/>
    <item Name="NR_CAIXA" Value="'001'"/>
  </Variables>
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxFDDatabase Name="Conexao" DriverName="FB" DatabaseName="C:\Sistema\Sisplan\Base\14683F.FDB" Params.Text="Protocol=TCPIP&#13;&#10;Database=C:\Sistema\Sisplan\Base\14683F.FDB&#13;&#10;Server=172.20.8.202&#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="05704C65667402300470546F700250"/>
    <TfrxFDQuery Name="qryCaixa" UserName="qryCaixa" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" Master="tbRelatorio" IgnoreDupParams="False" SQL.Text="SELECT * FROM VENDA_FECHAMENTO_001 WHERE NRCAIXA = :NRCAIXA AND DATA = :DATA   AND EMP_ID=:EMP_ID                                             " MacroCreate="True" MacroExpand="True" ReadOnly="False" Database="Conexao" MasterFields="DATA=DATA;NRCAIXA=NRCAIXA" Left="196" Top="16">
      <Parameters>
        <item Name="NRCAIXA" DataType="ftDateTime" Expression="&#60;tbRelatorio.&#34;NRCAIXA&#34;&#62;"/>
        <item Name="DATA" DataType="ftString" Expression="&#60;tbRelatorio.&#34;DATA&#34;&#62;"/>
        <item Name="EMP_ID" DataType="ftInteger" Expression="&#60;tbRelatorio.&#34;EMP_ID&#34;&#62;"/>
      </Parameters>
    </TfrxFDQuery>
    <TfrxFDQuery Name="qryEmpresa" UserName="qryEmpresa" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="SELECT * FROM EMPRESA WHERE EMP_PAT = :EMP_PAT   AND EMP_ID = :EMP_ID                                                                                                                          " MacroCreate="True" MacroExpand="True" ReadOnly="False" Database="Conexao" MasterFields="DATA=DATA;NRCAIXA=NRCAIXA" Left="48" Top="16">
      <Parameters>
        <item Name="EMP_PAT" DataType="ftString" Expression="&#60;Empresa&#62;"/>
        <item Name="EMP_ID" DataType="ftInteger" Expression="&#60;tbRelatorio.&#34;EMP_ID&#34;&#62;"/>
      </Parameters>
    </TfrxFDQuery>
    <TfrxFDQuery Name="qryVenda" UserName="qryVenda" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" Master="tbRelatorio" IgnoreDupParams="False" SQL.Text="SELECT VENDA.NRCAIXA,VENDA.CODVEN, CONDIVENDA.BANDEIRA, VENDA.DATA, MOEDA.DESCRICAO, VENDA.CODCLI, ENTIDADE.NOME, MOEDA.CODMOE, SUM(ITCONDIVENDA.VALOR) VALOR,  &#13;&#10;       CAST((SELECT SUM(IT.QUANTIDADE) FROM ITVENDA_001 IT WHERE IT.CODVEN = VENDA.CODVEN AND IT.EMP_ID = VENDA.EMP_ID) AS NUMERIC(11,2)) QTDE, &#13;&#10;       CAST((SELECT SUM(IT.QUANTIDADE*UDF_NVL(IT.PRE_CUSTO)) FROM ITVENDA_001 IT WHERE IT.CODVEN = VENDA.CODVEN AND IT.CANCELADO &#60;&#62; 'S' AND IT.TROCA &#60;&#62; 'S' &#13;&#10;       AND IT.EMP_ID = VENDA.EMP_ID) AS NUMERIC(18,2)) VALOR_CUSTO, &#13;&#10;       REPRESEN.NOME VENDEDOR,  CONDICAO.DESCRICAO CONDICAO, VENDA.HR_VENDA, VENDA.TABELA, REGIAO.DESCRICAO DESCTABPRECO, &#13;&#10;       REPRESEN2.CODREP CODGUIA, REPRESEN2.NOME GUIA, (SELECT SVENDAOBS.OBSERVACAO FROM VENDAOBS_001 SVENDAOBS WHERE SVENDAOBS.CODVEN = VENDA.CODVEN AND SVENDAOBS.EMP_ID = VENDA.EMP_ID ) OBSERVACAO, &#13;&#10;       MAX(VENDA.VALOR_BRUTO) VALOR_BRUTO, MAX(VENDA.VALOR_DEVOL) VALOR_DEVOL, MAX(VENDA.DESCO) DESCO, MAX(VENDA.ACRES) ACRES, MAX(VENDA.VALOR) VENDA_VALOR, &#13;&#10;       MAX(VENDA_DEV.VALOR) VALOR_DEVOL_ORIG, VENDA.USR_CAIXA, MOEDA.NAO_GERA_RECEBER, &#13;&#10;       (SELECT MAX(FATURA) FROM CFE_001 CFE WHERE CFE.CODVEN = VENDA.CODVEN AND CFE.EMP_ID = VENDA.EMP_ID) FATURA_CFE  &#13;&#10;FROM CONDIVENDA_001 CONDIVENDA &#13;&#10;INNER JOIN VENDA_001 VENDA ON VENDA.CODVEN = CONDIVENDA.CDVENDA AND CONDIVENDA.EMP_ID = VENDA.EMP_ID &#13;&#10;INNER JOIN REPRESEN_001 REPRESEN ON VENDA.CODREP = REPRESEN.CODREP &#13;&#10;INNER JOIN ENTIDADE_001 ENTIDADE ON VENDA.CODCLI = ENTIDADE.CODCLI &#13;&#10;INNER JOIN MOEDA_001 MOEDA ON MOEDA.CODMOE = CONDIVENDA.CDMOEDA &#13;&#10;INNER JOIN ITCONDIVENDA_001 ITCONDIVENDA ON ITCONDIVENDA.CDCONDIVENDA  = CONDIVENDA.CDCONDIVENDA AND ITCONDIVENDA.CDVENDA = CONDIVENDA.CDVENDA &#13;&#10;AND ITCONDIVENDA.EMP_ID = CONDIVENDA.EMP_ID&#13;&#10;LEFT JOIN CONDICAO_001 CONDICAO ON CONDICAO.CODCOND = CONDIVENDA.CDCONDICAO &#13;&#10;LEFT JOIN REGIAO_001 REGIAO ON REGIAO.REGIAO = VENDA.TABELA &#13;&#10;LEFT JOIN REPRESEN_001 REPRESEN2 ON VENDA.CODREP2 = REPRESEN2.CODREP &#13;&#10;LEFT JOIN VENDA_001 VENDA_DEV ON VENDA_DEV.CODVEN = VENDA.CODDEV_CAIXA AND VENDA_DEV.EMP_ID = VENDA.EMP_ID &#13;&#10;WHERE 1=1 &#13;&#10;AND VENDA.DATA = :DATA&#13;&#10;AND VENDA.NRCAIXA = :NRCAIXA                  &#13;&#10;AND VENDA.FECHADA = 1&#13;&#10;AND VENDA.EMP_ID=:EMP_ID                                                       &#13;&#10;&#13;&#10;AND (VENDA.OP_FISCAL = 0 OR VENDA.OP_FISCAL IS NULL) &#13;&#10;GROUP BY VENDA.NRCAIXA,VENDA.CODVEN, VENDA.EMP_ID, VENDA.DATA, MOEDA.DESCRICAO, VENDA.CODCLI, ENTIDADE.NOME, MOEDA.CODMOE, REPRESEN.NOME,&#13;&#10;CONDIVENDA.BANDEIRA,VENDA.DESCO, VENDA.ACRES, CONDICAO.DESCRICAO,VENDA.HR_VENDA, VENDA.TABELA, REGIAO.DESCRICAO, REPRESEN2.CODREP, &#13;&#10;REPRESEN2.NOME, VENDA.USR_CAIXA, MOEDA.NAO_GERA_RECEBER &#13;&#10;ORDER BY VENDA.NRCAIXA,VENDA.CODVEN, VENDA.DATA, MOEDA.DESCRICAO  " MacroCreate="True" MacroExpand="True" ReadOnly="False" Database="Conexao" MasterFields="DATA=DATA;NRCAIXA=NRCAIXA" Left="128" Top="16">
      <Parameters>
        <item Name="DATA" DataType="ftDateTime" Expression="&#60;tbRelatorio.&#34;DATA&#34;&#62;"/>
        <item Name="NRCAIXA" DataType="ftString" Expression="&#60;tbRelatorio.&#34;NRCAIXA&#34;&#62;"/>
        <item Name="EMP_ID" DataType="ftInteger" Expression="&#60;tbRelatorio.&#34;EMP_ID&#34;&#62;"/>
      </Parameters>
    </TfrxFDQuery>
    <TfrxFDQuery Name="qryEntradas" UserName="qryEntradas" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" Master="tbRelatorio" IgnoreDupParams="False" SQL.Text="           SELECT VENDA_FECHAMENTO.ORDEM, VENDA_FECHAMENTO.DATA, VENDA_FECHAMENTO.TIPO, VENDA_FECHAMENTO.LANCAMENTO, &#13;&#10;VENDA_FECHAMENTO.DESCRICAO, VENDA_FECHAMENTO.MOEDA, MOEDA.DESCRICAO DESCMOEDA, RECEBER.DT_VENCTO, VENDA_FECHAMENTO.EMP_ID,                                                        &#13;&#10;SUM(VENDA_FECHAMENTO.VALOR) VALOR, &#13;&#10;SUM(RECEBER.JUROS) JUROS, &#13;&#10;SUM(RECEBER.DESCONTO) DESCONTO, &#13;&#10;SUM(RECEBER.VAL_ORIGIN) VALOR_ORIG, &#13;&#10;VENDA_FECHAMENTO.DUPLICATA, VENDA_FECHAMENTO.DT_FECHAMENTO ,&#13;&#10;VENDA_FECHAMENTO.NRCAIXA &#13;&#10;FROM  VENDA_FECHAMENTO_001 VENDA_FECHAMENTO &#13;&#10;LEFT JOIN MOEDA_001   MOEDA   ON (MOEDA.CODMOE   = VENDA_FECHAMENTO.MOEDA) &#13;&#10;LEFT JOIN RECEBER_001 RECEBER ON (RECEBER.NUMERO = VENDA_FECHAMENTO.DUPLICATA AND RECEBER.EMP_ID = VENDA_FECHAMENTO.EMP_ID)&#13;&#10;WHERE 1=1&#13;&#10;AND VENDA_FECHAMENTO.TIPO = 'E'  &#13;&#10;AND VENDA_FECHAMENTO.DATA = :DATA        &#13;&#10;AND VENDA_FECHAMENTO.NRCAIXA = :NRCAIXA&#13;&#10;AND VENDA_FECHAMENTO.EMP_ID=:EMP_ID                                                                        &#13;&#10;&#13;&#10;&#13;&#10; GROUP BY VENDA_FECHAMENTO.ORDEM, VENDA_FECHAMENTO.DATA, VENDA_FECHAMENTO.TIPO, VENDA_FECHAMENTO.DESCRICAO, &#13;&#10; VENDA_FECHAMENTO.MOEDA, MOEDA.DESCRICAO, VENDA_FECHAMENTO.LANCAMENTO, VENDA_FECHAMENTO.EMP_ID,                                                         &#13;&#10; VENDA_FECHAMENTO.DUPLICATA, VENDA_FECHAMENTO.DT_FECHAMENTO, RECEBER.DT_VENCTO &#13;&#10; ,VENDA_FECHAMENTO.NRCAIXA&#13;&#10; ORDER BY VENDA_FECHAMENTO.DESCRICAO  " MacroCreate="True" MacroExpand="True" ReadOnly="False" Database="Conexao" MasterFields="DATA=DATA;NRCAIXA=NRCAIXA" Left="128" Top="80">
      <Parameters>
        <item Name="DATA" DataType="ftDateTime" Expression="&#60;tbRelatorio.&#34;DATA&#34;&#62;"/>
        <item Name="NRCAIXA" DataType="ftString" Expression="&#60;tbRelatorio.&#34;NRCAIXA&#34;&#62;"/>
        <item Name="EMP_ID" DataType="ftInteger" Expression="&#60;tbRelatorio.&#34;EMP_ID&#34;&#62;"/>
      </Parameters>
    </TfrxFDQuery>
    <TfrxFDQuery Name="qrySaidas" UserName="qrySaidas" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" Master="tbRelatorio" IgnoreDupParams="False" SQL.Text="SELECT VENDA_FECHAMENTO.ORDEM, VENDA_FECHAMENTO.DATA, VENDA_FECHAMENTO.TIPO, VENDA_FECHAMENTO.LANCAMENTO, VENDA_FECHAMENTO.MANUAL,                                                                                   &#13;&#10;VENDA_FECHAMENTO.DESCRICAO, VENDA_FECHAMENTO.MOEDA, MOEDA.DESCRICAO DESCMOEDA, RECEBER.DT_VENCTO, VENDA_FECHAMENTO.EMP_ID,                                                 &#13;&#10;SUM(VENDA_FECHAMENTO.VALOR) VALOR, &#13;&#10;SUM(RECEBER.JUROS) JUROS, &#13;&#10;SUM(RECEBER.DESCONTO) DESCONTO, &#13;&#10;SUM(RECEBER.VAL_ORIGIN) VALOR_ORIG, &#13;&#10;VENDA_FECHAMENTO.DUPLICATA, VENDA_FECHAMENTO.DT_FECHAMENTO ,&#13;&#10;VENDA_FECHAMENTO.NRCAIXA &#13;&#10;FROM  VENDA_FECHAMENTO_001 VENDA_FECHAMENTO &#13;&#10;LEFT JOIN MOEDA_001   MOEDA   ON (MOEDA.CODMOE   = VENDA_FECHAMENTO.MOEDA) &#13;&#10;LEFT JOIN RECEBER_001 RECEBER ON (RECEBER.NUMERO = VENDA_FECHAMENTO.DUPLICATA AND RECEBER.EMP_ID = VENDA_FECHAMENTO.EMP_ID) &#13;&#10;WHERE 1=1&#13;&#10;AND VENDA_FECHAMENTO.TIPO = 'S'  &#13;&#10;AND VENDA_FECHAMENTO.DATA = :DATA        &#13;&#10;AND VENDA_FECHAMENTO.NRCAIXA = :NRCAIXA&#13;&#10;AND VENDA_FECHAMENTO.EMP_ID=:EMP_ID                    &#13;&#10;AND VENDA_FECHAMENTO.MOEDA &#60;&#62; 0                                                                   &#13;&#10;&#13;&#10;&#13;&#10; GROUP BY VENDA_FECHAMENTO.ORDEM, VENDA_FECHAMENTO.DATA, VENDA_FECHAMENTO.TIPO, VENDA_FECHAMENTO.DESCRICAO, &#13;&#10; VENDA_FECHAMENTO.MOEDA, MOEDA.DESCRICAO, VENDA_FECHAMENTO.LANCAMENTO,  VENDA_FECHAMENTO.EMP_ID,&#13;&#10; VENDA_FECHAMENTO.MANUAL,       &#13;&#10; VENDA_FECHAMENTO.DUPLICATA, VENDA_FECHAMENTO.DT_FECHAMENTO, RECEBER.DT_VENCTO &#13;&#10; ,VENDA_FECHAMENTO.NRCAIXA&#13;&#10; &#13;&#10;UNION ALL&#13;&#10;&#13;&#10;SELECT VENDA_FECHAMENTO.ORDEM, VENDA_FECHAMENTO.DATA, VENDA_FECHAMENTO.TIPO, VENDA_FECHAMENTO.LANCAMENTO, VENDA_FECHAMENTO.MANUAL,                                                                                   &#13;&#10;VENDA_FECHAMENTO.DESCRICAO, VENDA_FECHAMENTO.MOEDA, MOEDA.DESCRICAO DESCMOEDA, RECEBER.DT_VENCTO, VENDA_FECHAMENTO.EMP_ID,                                                 &#13;&#10;SUM(VENDA_FECHAMENTO.VALOR) VALOR, &#13;&#10;SUM(RECEBER.JUROS) JUROS, &#13;&#10;SUM(RECEBER.DESCONTO) DESCONTO, &#13;&#10;SUM(RECEBER.VAL_ORIGIN) VALOR_ORIG, &#13;&#10;VENDA_FECHAMENTO.DUPLICATA, VENDA_FECHAMENTO.DT_FECHAMENTO ,&#13;&#10;VENDA_FECHAMENTO.NRCAIXA &#13;&#10;FROM  VENDA_FECHAMENTO_001 VENDA_FECHAMENTO &#13;&#10;LEFT JOIN MOEDA_001   MOEDA   ON (MOEDA.CODMOE   = VENDA_FECHAMENTO.MOEDA) &#13;&#10;LEFT JOIN RECEBER_001 RECEBER ON (RECEBER.NUMERO = VENDA_FECHAMENTO.DUPLICATA AND RECEBER.EMP_ID = VENDA_FECHAMENTO.EMP_ID) &#13;&#10;WHERE 1=1 &#13;&#10;AND VENDA_FECHAMENTO.DATA = :DATA        &#13;&#10;AND VENDA_FECHAMENTO.NRCAIXA = :NRCAIXA&#13;&#10;AND VENDA_FECHAMENTO.EMP_ID=:EMP_ID  &#13;&#10;AND VENDA_FECHAMENTO.MOEDA = 0     &#13;&#10;AND VENDA_FECHAMENTO.TIPO = 'V'                                                              &#13;&#10;&#13;&#10;&#13;&#10; GROUP BY VENDA_FECHAMENTO.ORDEM, VENDA_FECHAMENTO.DATA, VENDA_FECHAMENTO.TIPO, VENDA_FECHAMENTO.DESCRICAO, &#13;&#10; VENDA_FECHAMENTO.MOEDA, MOEDA.DESCRICAO, VENDA_FECHAMENTO.LANCAMENTO,  VENDA_FECHAMENTO.EMP_ID,&#13;&#10; VENDA_FECHAMENTO.MANUAL,       &#13;&#10; VENDA_FECHAMENTO.DUPLICATA, VENDA_FECHAMENTO.DT_FECHAMENTO, RECEBER.DT_VENCTO &#13;&#10; ,VENDA_FECHAMENTO.NRCAIXA&#13;&#10;&#13;&#10;UNION ALL&#13;&#10;&#13;&#10;SELECT VENDA_FECHAMENTO.ORDEM, VENDA_FECHAMENTO.DATA, VENDA_FECHAMENTO.TIPO, VENDA_FECHAMENTO.LANCAMENTO, VENDA_FECHAMENTO.MANUAL,                                                                                   &#13;&#10;VENDA_FECHAMENTO.DESCRICAO, VENDA_FECHAMENTO.MOEDA, MOEDA.DESCRICAO DESCMOEDA, RECEBER.DT_VENCTO, VENDA_FECHAMENTO.EMP_ID,                                                 &#13;&#10;SUM(VENDA_FECHAMENTO.VALOR) VALOR, &#13;&#10;SUM(RECEBER.JUROS) JUROS, &#13;&#10;SUM(RECEBER.DESCONTO) DESCONTO, &#13;&#10;SUM(RECEBER.VAL_ORIGIN) VALOR_ORIG, &#13;&#10;VENDA_FECHAMENTO.DUPLICATA, VENDA_FECHAMENTO.DT_FECHAMENTO ,&#13;&#10;VENDA_FECHAMENTO.NRCAIXA &#13;&#10;FROM  VENDA_FECHAMENTO_001 VENDA_FECHAMENTO &#13;&#10;LEFT JOIN MOEDA_001   MOEDA   ON (MOEDA.CODMOE   = VENDA_FECHAMENTO.MOEDA) &#13;&#10;LEFT JOIN RECEBER_001 RECEBER ON (RECEBER.NUMERO = VENDA_FECHAMENTO.DUPLICATA AND RECEBER.EMP_ID = VENDA_FECHAMENTO.EMP_ID) &#13;&#10;WHERE 1=1 &#13;&#10;AND VENDA_FECHAMENTO.DATA = :DATA        &#13;&#10;AND VENDA_FECHAMENTO.NRCAIXA = :NRCAIXA&#13;&#10;AND VENDA_FECHAMENTO.EMP_ID=:EMP_ID  &#13;&#10;AND VENDA_FECHAMENTO.MOEDA = 0     &#13;&#10;AND VENDA_FECHAMENTO.MANUAL = 'S'&#13;&#10;AND VENDA_FECHAMENTO.TIPO='S'                                                              &#13;&#10;&#13;&#10;&#13;&#10; GROUP BY VENDA_FECHAMENTO.ORDEM, VENDA_FECHAMENTO.DATA, VENDA_FECHAMENTO.TIPO, VENDA_FECHAMENTO.DESCRICAO, &#13;&#10; VENDA_FECHAMENTO.MOEDA, MOEDA.DESCRICAO, VENDA_FECHAMENTO.LANCAMENTO,  VENDA_FECHAMENTO.EMP_ID,&#13;&#10; VENDA_FECHAMENTO.MANUAL,       &#13;&#10; VENDA_FECHAMENTO.DUPLICATA, VENDA_FECHAMENTO.DT_FECHAMENTO, RECEBER.DT_VENCTO &#13;&#10; ,VENDA_FECHAMENTO.NRCAIXA&#13;&#10;          " MacroCreate="True" MacroExpand="True" ReadOnly="False" Database="Conexao" MasterFields="DATA=DATA;NRCAIXA=NRCAIXA" Left="260" Top="16">
      <Parameters>
        <item Name="DATA" DataType="ftDateTime" Expression="&#60;tbRelatorio.&#34;DATA&#34;&#62;"/>
        <item Name="NRCAIXA" DataType="ftString" Expression="&#60;tbRelatorio.&#34;NRCAIXA&#34;&#62;"/>
        <item Name="EMP_ID" DataType="ftInteger" Expression="&#60;tbRelatorio.&#34;EMP_ID&#34;&#62;"/>
        <item Name="DATA" DataType="ftDateTime" Expression="&#60;tbRelatorio.&#34;DATA&#34;&#62;"/>
        <item Name="NRCAIXA" DataType="ftString" Expression="&#60;tbRelatorio.&#34;NRCAIXA&#34;&#62;"/>
        <item Name="EMP_ID" DataType="ftInteger" Expression="&#60;tbRelatorio.&#34;EMP_ID&#34;&#62;"/>
        <item Name="DATA" DataType="ftDateTime" Expression="&#60;tbRelatorio.&#34;DATA&#34;&#62;"/>
        <item Name="NRCAIXA" DataType="ftString" Expression="&#60;tbRelatorio.&#34;NRCAIXA&#34;&#62;"/>
        <item Name="EMP_ID" DataType="ftInteger" Expression="&#60;tbRelatorio.&#34;EMP_ID&#34;&#62;"/>
      </Parameters>
    </TfrxFDQuery>
    <TfrxFDQuery Name="QryFechamento" UserName="QryFechamento" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="SELECT&#13;&#10;	IT.CDMOEDA,&#13;&#10;	M.DESCRICAO,&#13;&#10;	CD.CDCONDICAO,&#13;&#10;	COND.DESCRICAO,&#13;&#10;	(SELECT&#13;&#10;		SUM(VF.VALOR)&#13;&#10;	FROM&#13;&#10;		VENDA_FECHAMENTO_001 VF&#13;&#10;	WHERE&#13;&#10;		1 = 1&#13;&#10;		AND VF.DATA = V.DATA&#13;&#10;		AND VF.MOEDA = IT.CDMOEDA&#13;&#10;		AND VF.TIPO IN  ('M','E')            &#13;&#10; AND VF.DATA = V.DATA) AS ENTRADA_MANUAL,&#13;&#10; (SELECT&#13;&#10;		SUM(VF.VALOR)&#13;&#10;	FROM&#13;&#10;		VENDA_FECHAMENTO_001 VF&#13;&#10;	WHERE&#13;&#10;		1 = 1&#13;&#10;		AND VF.DATA = V.DATA&#13;&#10;		AND VF.MOEDA = IT.CDMOEDA&#13;&#10;		AND VF.TIPO = 'V'&#13;&#10; AND VF.DATA = V.DATA) AS FATURADO,                                            &#13;&#10;	(&#13;&#10;	SELECT&#13;&#10;		SUM(VF.VALOR)&#13;&#10;	FROM&#13;&#10;		VENDA_FECHAMENTO_001 VF&#13;&#10;	WHERE&#13;&#10;		1 = 1&#13;&#10;		AND VF.DATA = V.DATA&#13;&#10;		AND VF.MOEDA = IT.CDMOEDA&#13;&#10;		AND VF.TIPO = 'S'&#13;&#10;  AND IT.CDMOEDA NOT IN ('3','9')) SAIDA_MANUAL            &#13;&#10;FROM&#13;&#10;	ITCONDIVENDA_001 IT&#13;&#10;LEFT JOIN MOEDA_001 M ON&#13;&#10;	(M.CODMOE = IT.CDMOEDA)&#13;&#10;INNER JOIN CONDIVENDA_001 CD ON&#13;&#10;	(CD.CDVENDA = IT.CDVENDA)&#13;&#10;INNER JOIN CONDICAO_001 COND ON&#13;&#10;	(COND.CODCOND = CD.CDCONDICAO)&#13;&#10;INNER JOIN VENDA_001 V ON&#13;&#10;	(V.CODVEN = IT.CDVENDA)&#13;&#10;WHERE&#13;&#10;	V.DATA = :DATA                             &#13;&#10;GROUP BY&#13;&#10;	IT.CDMOEDA,&#13;&#10;	M.DESCRICAO,&#13;&#10;	CD.CDCONDICAO,&#13;&#10;	COND.DESCRICAO,&#13;&#10;	V.DATA&#13;&#10;	&#13;&#10;&#13;&#10;&#13;&#10;                " MacroCreate="True" MacroExpand="True" ReadOnly="False" Database="Conexao" Left="196" Top="80">
      <Parameters>
        <item Name="DATA" DataType="ftDate" Expression="&#60;tbRelatorio.&#34;DATA&#34;&#62;"/>
      </Parameters>
    </TfrxFDQuery>
    <TfrxFDQuery Name="QryTotais" UserName="QryTotais" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="SELECT&#13;&#10;	V.DATA,    &#13;&#10;	(&#13;&#10;	SELECT&#13;&#10;		SUM(IT.VALOR_PAGO) VALOR&#13;&#10;	FROM&#13;&#10;		ITCONDIVENDA_001 IT&#13;&#10;	INNER JOIN VENDA_001 V2 ON&#13;&#10;		IT.CDVENDA = V2.CODVEN&#13;&#10;	WHERE&#13;&#10;		IT.CDMOEDA IN ('9', '3')&#13;&#10;		AND V2.DATA = V.DATA)	&#13;&#10;AS CREDITO,&#13;&#10;	(&#13;&#10;	SELECT&#13;&#10;		SUM(IT.VALOR_PAGO) VALOR&#13;&#10;	FROM&#13;&#10;		ITCONDIVENDA_001 IT&#13;&#10;	INNER JOIN VENDA_001 V2 ON&#13;&#10;		IT.CDVENDA = V2.CODVEN&#13;&#10;	WHERE&#13;&#10;		IT.CDMOEDA IN ('8', '2')&#13;&#10;			AND V2.DATA = V.DATA)	&#13;&#10;	AS DEBITO,&#13;&#10;	(&#13;&#10;	SELECT&#13;&#10;		SUM (VLDESCONTO) DESCONTO&#13;&#10;	FROM&#13;&#10;		CONDIVENDA_001 CD&#13;&#10;	INNER JOIN VENDA_001 V2 ON&#13;&#10;		(V2.CODVEN = CD.CDVENDA)&#13;&#10;			AND V2.DATA = V.DATA)&#13;&#10; AS DESCONTO,&#13;&#10;	(&#13;&#10;	SELECT&#13;&#10;		SUM(IT.VALOR_PAGO) VALOR&#13;&#10;	FROM&#13;&#10;		ITCONDIVENDA_001 IT&#13;&#10;	INNER JOIN VENDA_001 V2 ON&#13;&#10;		IT.CDVENDA = V2.CODVEN&#13;&#10;	WHERE&#13;&#10;		IT.CDMOEDA IN ('4')&#13;&#10;			AND V2.DATA = V.DATA)	&#13;&#10;	AS TROCA,                   &#13;&#10;	(&#13;&#10;	SELECT&#13;&#10;		SUM (VF.VALOR)&#13;&#10;	FROM&#13;&#10;		VENDA_FECHAMENTO_001 VF&#13;&#10;	WHERE&#13;&#10;		VF.MOEDA = '0'&#13;&#10;		AND VF.TIPO = 'E'&#13;&#10;	AND VF.DATA = V.DATA) FUNDO_CAIXA                                     &#13;&#10;FROM&#13;&#10;	CONDIVENDA_001 CONDi&#13;&#10;INNER JOIN ITCONDIVENDA_001 IT ON&#13;&#10;	(IT.CDVENDA = CONDI.CDVENDA)&#13;&#10;INNER JOIN VENDA_001 V ON&#13;&#10;	(V.CODVEN = IT.CDVENDA)&#13;&#10;WHERE&#13;&#10;	V.DATA = :DATA                           &#13;&#10;	AND IT.CDMOEDA IN ('9', '8', '2', '3')&#13;&#10;GROUP BY&#13;&#10;	V.DATA  " MacroCreate="True" MacroExpand="True" ReadOnly="False" Database="Conexao" Left="260" Top="80">
      <Parameters>
        <item Name="DATA" DataType="ftDate" Expression="&#60;tbRelatorio.&#34;DATA&#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.Color="536870911" Frame.ShadowColor="536870911" Frame.Typ="0" MirrorMode="0" HGuides.Text="" VGuides.Text="">
    <TfrxReportTitle Name="ReportTitle1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="117,16543" Left="0" Top="18,89765" Width="718,1107">
      <TfrxMemoView Name="Memo88" AllowVectorExport="True" Left="54,69295" Top="47,13389" Width="612,28386" Height="26,45671" Font.Charset="1" Font.Color="255" Font.Height="-24" Font.Name="Arial" Font.Style="7" Frame.Typ="0" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="RELATÓRIO DE FECHAMENTO DE CAIXA"/>
      <TfrxMemoView Name="Memo1" AllowVectorExport="True" Left="52,91342" Top="45,57483" Width="612,28386" Height="26,45671" Font.Charset="1" Font.Color="0" Font.Height="-24" Font.Name="Arial" Font.Style="7" Frame.Typ="0" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="RELATÓRIO DE FECHAMENTO DE CAIXA"/>
      <TfrxMemoView Name="Date" IndexTag="1" AllowVectorExport="True" Left="646,29963" Top="18,45671" Width="71,81107" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[Time]"/>
      <TfrxMemoView Name="Date1" IndexTag="1" AllowVectorExport="True" Left="646,29963" Top="0" Width="71,81107" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[Date]"/>
      <TfrxMemoView Name="Page" IndexTag="1" AllowVectorExport="True" Left="579,14997" Top="36,13389" Width="139,84261" Height="37,7953" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Pág. [Page#] de [TotalPages#]">
        <Formats>
          <item/>
          <item/>
        </Formats>
      </TfrxMemoView>
      <TfrxMemoView Name="Memo6" AllowVectorExport="True" Left="-2" Top="1" Width="612,28386" Height="22,67718" Font.Charset="1" Font.Color="0" Font.Height="-15" Font.Name="Arial" Font.Style="3" Frame.Typ="0" ParentFont="False" VAlign="vaCenter" Text="Empresa: [copy(&#60;qryEmpresa.&#34;EMP_PAT&#34;&#62;,2,4)] - [qryEmpresa.&#34;EMP_FANTASIA&#34;]"/>
      <TfrxMemoView Name="Memo11" AllowVectorExport="True" Left="-2" Top="68,03154" Width="389,29159" Height="41,57483" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" VAlign="vaBottom" Text="Data: [tbRelatorio.&#34;DATA&#34;] ">
        <Formats>
          <item/>
          <item/>
        </Formats>
      </TfrxMemoView>
      <TfrxMemoView Name="Memo89" AllowVectorExport="True" Left="328,81911" Top="68,03154" Width="389,29159" Height="41,57483" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" VAlign="vaBottom" Text="&#13;&#10;Caixa: [tbRelatorio.&#34;NRCAIXA&#34;]">
        <Formats>
          <item/>
          <item/>
        </Formats>
      </TfrxMemoView>
    </TfrxReportTitle>
    <TfrxMasterData Name="MasterData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="26,45671" Left="0" Top="291,02381" Width="718,1107" OnBeforePrint="MasterData1OnBeforePrint" ColumnWidth="0" ColumnGap="0" DataSet="qryVenda" DataSetName="qryVenda" RowCount="0">
      <TfrxShapeView Name="fundoVendas" AllowVectorExport="True" Left="0" Top="0" Width="718,1107" Height="26,45671" Fill.ForeColor="536870911" Frame.Color="536870911" Frame.Typ="0"/>
      <TfrxMemoView Name="qryVendaCODVEN" IndexTag="1" AllowVectorExport="True" Left="3,55906" Top="2,55906" Width="64,25201" Height="18,89765" DataField="CODVEN" DataSetName="qryVenda" Frame.Typ="0" Text="[qryVenda.&#34;CODVEN&#34;]"/>
      <TfrxMemoView Name="qryVendaDATA" IndexTag="1" AllowVectorExport="True" Left="70,82684" Top="2,55906" Width="75,5906" Height="18,89765" DataField="DATA" DataSetName="qryVenda" Frame.Typ="0" Text="[qryVenda.&#34;DATA&#34;]"/>
      <TfrxMemoView Name="qryVendaDESCRICAO" IndexTag="1" AllowVectorExport="True" Left="152,9765" Top="2,55906" Width="166,29932" Height="18,89765" DataField="DESCRICAO" DataSetName="qryVenda" Frame.Typ="0" Text="[qryVenda.&#34;DESCRICAO&#34;]"/>
      <TfrxMemoView Name="qryVendaVENDEDOR" IndexTag="1" AllowVectorExport="True" Left="451,29963" Top="2,55906" Width="154,96073" Height="18,89765" StretchMode="smActualHeight" DataField="VENDEDOR" DataSetName="qryVenda" Frame.Typ="0" WordWrap="False" Text="[qryVenda.&#34;VENDEDOR&#34;]"/>
      <TfrxMemoView Name="qryVendaCODMOE" IndexTag="1" AllowVectorExport="True" Left="607,14997" Top="2,23624" Width="79,37013" Height="18,89765" DataSetName="qryVenda" DisplayFormat.FormatStr="%2.2f" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[qryVenda.&#34;VALOR&#34;]"/>
      <TfrxMemoView Name="Memo39" IndexTag="1" AllowVectorExport="True" Left="321,26005" Top="2,55906" Width="109,60637" Height="18,89765" StretchMode="smActualHeight" DataSetName="qryVenda" Frame.Typ="0" WordWrap="False" Text="[qryVenda.&#34;BANDEIRA&#34;]"/>
    </TfrxMasterData>
    <TfrxHeader Name="Header1" FillType="ftBrush" Fill.BackColor="-16777194" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="27,10235" Left="0" Top="196,53556" Width="718,1107" ReprintOnNewPage="True">
      <TfrxShapeView Name="Shape1" AllowVectorExport="True" Left="-0,22047" Top="0" Width="718,1107" Height="22,67718" Fill.BackColor="-16777216" Frame.Typ="0"/>
      <TfrxMemoView Name="Memo9" IndexTag="1" AllowVectorExport="True" Left="0" Top="0,88188" Width="718,1107" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="Vendas"/>
    </TfrxHeader>
    <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="340,1577" Width="718,1107">
      <TfrxMemoView Name="Memo10" IndexTag="1" AllowVectorExport="True" Left="607,5201" Top="0" Width="79,37013" Height="18,89765" DataSetName="qryVenda" DisplayFormat.FormatStr="%2.2f" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[SUM(IIF(&#60;qryVenda.&#34;CODMOE&#34;&#62; &#60;&#62; '4', &#60;qryVenda.&#34;VALOR&#34;&#62;,0),MasterData1)]"/>
      <TfrxMemoView Name="Memo12" IndexTag="1" AllowVectorExport="True" Left="555,59091" Top="0" Width="41,57483" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Total:"/>
    </TfrxGroupFooter>
    <TfrxGroupHeader Name="GroupHeader1" FillType="ftBrush" Fill.BackColor="-16777194" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="22,67718" Left="0" Top="245,66945" Width="718,1107" Condition="&#60;qryVenda.&#34;NRCAIXA&#34;&#62;">
      <TfrxMemoView Name="Memo2" IndexTag="1" AllowVectorExport="True" Left="3,55906" Top="2,10235" Width="64,25201" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Venda"/>
      <TfrxMemoView Name="Memo3" IndexTag="1" AllowVectorExport="True" Left="72,82684" Top="2,10235" Width="75,5906" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Data"/>
      <TfrxMemoView Name="Memo4" IndexTag="1" AllowVectorExport="True" Left="152,9765" Top="2,10235" Width="166,29932" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Meio Pagamento"/>
      <TfrxMemoView Name="Memo8" IndexTag="1" AllowVectorExport="True" Left="452,29963" Top="2,10235" Width="154,96073" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Vendedor"/>
      <TfrxMemoView Name="Memo7" IndexTag="1" AllowVectorExport="True" Left="609,14997" Top="2,77953" Width="79,37013" Height="18,89765" DataSetName="qryVenda" DisplayFormat.FormatStr="%2.2f" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Valor"/>
      <TfrxMemoView Name="Memo40" IndexTag="1" AllowVectorExport="True" Left="322,26005" Top="2,10235" Width="109,60637" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Bandeira"/>
    </TfrxGroupHeader>
    <TfrxMasterData Name="MasterData2" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="26,45671" Left="0" Top="480,00031" Width="718,1107" OnBeforePrint="MasterData2OnBeforePrint" ColumnWidth="0" ColumnGap="0" DataSet="qryEntradas" DataSetName="qryEntradas" Filter="&#60;qryEntradas.&#34;MOEDA&#34;&#62; &#60;&#62; '7'" RowCount="0">
      <TfrxShapeView Name="fundoEntradas" AllowVectorExport="True" Left="0" Top="0" Width="718,1107" Height="26,45671" Frame.Color="536870911" Frame.Typ="0"/>
      <TfrxMemoView Name="Memo15" IndexTag="1" AllowVectorExport="True" Left="9,33859" Top="2,55905999999999" Width="404,40971" Height="18,89765" DataSetName="qryVenda" Frame.Typ="0" Text="[qryEntradas.&#34;DESCRICAO&#34;]"/>
      <TfrxMemoView Name="Memo17" IndexTag="1" AllowVectorExport="True" Left="608,50433" Top="3,23624" Width="83,14966" Height="18,89765" DataSetName="qryVenda" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[qryEntradas.&#34;VALOR&#34;]"/>
    </TfrxMasterData>
    <TfrxHeader Name="Header2" FillType="ftBrush" Fill.BackColor="-16777194" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="27,10235" Left="0" Top="385,51206" Width="718,1107" ReprintOnNewPage="True">
      <TfrxShapeView Name="Shape2" AllowVectorExport="True" Left="-0,22047" Top="0" Width="718,1107" Height="22,67718" Fill.BackColor="-16777216" Frame.Typ="0"/>
      <TfrxMemoView Name="Memo18" IndexTag="1" AllowVectorExport="True" Left="0" Top="0,88188" Width="718,1107" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="Entradas"/>
    </TfrxHeader>
    <TfrxGroupFooter Name="GroupFooter2" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="22,67718" Left="0" Top="529,1342" Width="718,1107">
      <TfrxMemoView Name="Memo19" IndexTag="1" AllowVectorExport="True" Left="608,50433" Top="0" Width="83,14966" Height="18,89765" DataSetName="qryVenda" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;qryEntradas.&#34;VALOR&#34;&#62;,MasterData2)]"/>
      <TfrxMemoView Name="Memo20" IndexTag="1" AllowVectorExport="True" Left="558,59091" Top="0" Width="41,57483" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Total:"/>
    </TfrxGroupFooter>
    <TfrxGroupHeader Name="GroupHeader2" FillType="ftBrush" Fill.BackColor="-16777194" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="22,67718" Left="0" Top="434,64595" Width="718,1107" Condition="&#60;qryVenda.&#34;NRCAIXA&#34;&#62;">
      <TfrxMemoView Name="Memo21" IndexTag="1" AllowVectorExport="True" Left="7,55906" Top="2,10235" Width="408,18924" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Meio de Pagamento"/>
      <TfrxMemoView Name="Memo25" IndexTag="1" AllowVectorExport="True" Left="612,14997" Top="2,77953" Width="79,37013" Height="18,89765" DataSetName="qryVenda" DisplayFormat.FormatStr="%2.2f" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Valor"/>
    </TfrxGroupHeader>
    <TfrxMasterData Name="MasterData3" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="26,45671" Left="0" Top="668,97681" Width="718,1107" OnBeforePrint="MasterData3OnBeforePrint" ColumnWidth="0" ColumnGap="0" DataSet="qrySaidas" DataSetName="qrySaidas" RowCount="0" Stretched="True">
      <TfrxShapeView Name="fundoSaidas" AllowVectorExport="True" Left="0" Top="1,77953" Width="718,1107" Height="22,67718" Frame.Color="536870911" Frame.Typ="0"/>
      <TfrxMemoView Name="Memo22" IndexTag="1" AllowVectorExport="True" Left="9,33859" Top="2,55906" Width="582,04762" Height="18,89765" DataSetName="qryVenda" Frame.Typ="0" Text="[IIF(&#60;qrySaidas.&#34;MOEDA&#34;&#62; = '5',&#60;qrySaidas.&#34;DESCMOEDA&#34;&#62;,'')] [qrySaidas.&#34;DESCRICAO&#34;]"/>
      <TfrxMemoView Name="Memo23" IndexTag="1" AllowVectorExport="True" Left="608,50433" Top="3,23624" Width="83,14966" Height="18,89765" DataSetName="qryVenda" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[(&#60;qrySaidas.&#34;VALOR&#34;&#62;)]"/>
    </TfrxMasterData>
    <TfrxHeader Name="Header3" FillType="ftBrush" Fill.BackColor="-16777194" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="27,10235" Left="0" Top="574,48856" Width="718,1107" ReprintOnNewPage="True">
      <TfrxShapeView Name="Shape3" AllowVectorExport="True" Left="-0,22047" Top="0" Width="718,1107" Height="22,67718" Fill.BackColor="-16777216" Frame.Typ="0"/>
      <TfrxMemoView Name="Memo24" IndexTag="1" AllowVectorExport="True" Left="0" Top="0,88188" Width="718,1107" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="Saídas"/>
    </TfrxHeader>
    <TfrxGroupFooter Name="GroupFooter3" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="30,23624" Left="0" Top="718,1107" Width="718,1107">
      <TfrxMemoView Name="Memo35" IndexTag="1" AllowVectorExport="True" Left="608,50433" Top="7,55906" Width="83,14966" Height="18,89765" DataSetName="qryVenda" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;qrySaidas.&#34;VALOR&#34;&#62;,MasterData3,1)]"/>
      <TfrxMemoView Name="Memo36" IndexTag="1" AllowVectorExport="True" Left="529,1342" Top="7,55906" Width="71,81107" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Total:"/>
    </TfrxGroupFooter>
    <TfrxGroupHeader Name="GroupHeader3" FillType="ftBrush" Fill.BackColor="-16777194" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="22,67718" Left="0" Top="623,62245" Width="718,1107" Condition="&#60;qryVenda.&#34;NRCAIXA&#34;&#62;">
      <TfrxMemoView Name="Memo28" IndexTag="1" AllowVectorExport="True" Left="7,55906" Top="2,10235" Width="408,18924" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Meio de Pagamento"/>
      <TfrxMemoView Name="Memo29" IndexTag="1" AllowVectorExport="True" Left="612,14997" Top="2,77953" Width="79,37013" Height="18,89765" DataSetName="qryVenda" DisplayFormat.FormatStr="%2.2f" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Valor"/>
    </TfrxGroupHeader>
    <TfrxHeader Name="Header4" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="22,67718" Left="0" Top="771,02412" Width="718,1107">
      <TfrxMemoView Name="Memo30" IndexTag="1" AllowVectorExport="True" Left="0" Top="0" Width="718,1107" Height="22,67718" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Arial" Font.Style="1" Frame.Typ="15" Fill.BackColor="13421772" HAlign="haCenter" ParentFont="False" Text="Despesas"/>
    </TfrxHeader>
    <TfrxGroupHeader Name="GroupHeader4" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="26,45671" Left="0" Top="816,37848" Width="718,1107" Condition="qryCaixa.&#34;NRCAIXA&#34;">
      <TfrxMemoView Name="Memo31" IndexTag="1" AllowVectorExport="True" Left="7,55906" Top="3" Width="408,18924" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Meio de Pagamento"/>
      <TfrxMemoView Name="Memo32" IndexTag="1" AllowVectorExport="True" Left="612,14997" Top="3,67718" Width="79,37013" Height="18,89765" DataSetName="qryVenda" DisplayFormat.FormatStr="%2.2f" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Valor"/>
    </TfrxGroupHeader>
    <TfrxMasterData Name="MasterData4" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="22,67718" Left="0" Top="865,51237" Width="718,1107" OnBeforePrint="MasterData4OnBeforePrint" ColumnWidth="0" ColumnGap="0" DataSet="qrySaidas" DataSetName="qrySaidas" Filter="(&#60;qrySaidas.&#34;MANUAL&#34;&#62; = 'S') AND (&#60;qrySaidas.&#34;MOEDA&#34;&#62; &#60;&#62; ('7'))  AND (&#60;qrySaidas.&#34;MOEDA&#34;&#62; &#60;&#62; ('5')) AND (&#60;qrySaidas.&#34;MOEDA&#34;&#62; &#60;&#62; ('4')) " RowCount="0">
      <TfrxShapeView Name="Shape4" AllowVectorExport="True" Left="0,10235" Top="0,11812" Width="718,1107" Height="22,67718" Frame.Color="536870911" Frame.Typ="0"/>
      <TfrxMemoView Name="Memo33" IndexTag="1" AllowVectorExport="True" Left="7,55906" Top="0" Width="404,40971" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[qrySaidas.&#34;DESCRICAO&#34;]"/>
      <TfrxMemoView Name="Memo34" IndexTag="1" AllowVectorExport="True" Left="608,50433" Top="0" Width="83,14966" Height="18,89765" DataSetName="qryVenda" DisplayFormat.FormatStr="%2.2n" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[qrySaidas.&#34;VALOR&#34;]"/>
    </TfrxMasterData>
    <TfrxGroupFooter Name="GroupFooter4" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="41,57483" Left="0" Top="910,86673" Width="718,1107">
      <TfrxMemoView Name="Memo44" IndexTag="1" AllowVectorExport="True" Left="419,52783" Top="-3,77953" Width="272,12616" Height="45,35436" DataSetName="qryVenda" Font.Charset="1" Font.Color="-16777201" Font.Height="-16" Font.Name="Arial" Font.Style="1" Frame.Typ="15" Fill.BackColor="13421772" HAlign="haCenter" ParentFont="False" Text=""/>
      <TfrxMemoView Name="Memo37" IndexTag="1" AllowVectorExport="True" Left="609,14997" Top="-0,54329" Width="79,37013" Height="18,89765" DataSetName="qryVenda" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;qrySaidas.&#34;VALOR&#34;&#62;,MasterData4,1)]"/>
      <TfrxMemoView Name="Memo38" IndexTag="1" AllowVectorExport="True" Left="423,39394" Top="-0,54329" Width="124,72449" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Total de Despesas:"/>
      <TfrxMemoView Name="Memo41" IndexTag="1" AllowVectorExport="True" Left="423,39394" Top="21,47248" Width="185,19697" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Vendas + Troco - Despesas: "/>
      <TfrxMemoView Name="Memo42" IndexTag="1" AllowVectorExport="True" Left="612,28386" Top="21,47248" Width="79,37013" Height="18,89765" DataSetName="qryVenda" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[(SUM(&#60;qrySaidas.&#34;VALOR&#34;&#62;,MasterData3)) + (SUM(&#60;qryEntradas.&#34;VALOR&#34;&#62;,MasterData2))  - (SUM(&#60;qrySaidas.&#34;VALOR&#34;&#62;,MasterData4,1))]"/>
    </TfrxGroupFooter>
  </TfrxReportPage>
  <TfrxReportPage Name="Page2" Visible="False" 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="102,04731" Left="0" Top="18,89765" Visible="False" Width="718,1107">
      <TfrxMemoView Name="Memo51" IndexTag="1" AllowVectorExport="True" Left="1" Top="-18,89765" Width="718,1107" Height="120,94496" Font.Charset="1" Font.Color="16777215" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" Fill.BackColor="128" HAlign="haRight" ParentFont="False" Text="">
        <Formats>
          <item/>
          <item/>
        </Formats>
      </TfrxMemoView>
      <TfrxMemoView Name="Memo52" AllowVectorExport="True" Left="12,93692" Top="22,89765" Width="612,28386" Height="26,45671" Font.Charset="1" Font.Color="16777215" Font.Height="-24" Font.Name="Arial" Font.Style="7" Frame.Typ="0" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Relatório de fechamento de caixa"/>
      <TfrxMemoView Name="Memo53" IndexTag="1" AllowVectorExport="True" Left="634,62245" Top="7,11812" Width="71,81107" Height="18,89765" Font.Charset="1" Font.Color="16777215" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[Time]"/>
      <TfrxMemoView Name="Memo54" IndexTag="1" AllowVectorExport="True" Left="634,62245" Top="-11,33859" Width="71,81107" Height="18,89765" Font.Charset="1" Font.Color="16777215" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[Date]"/>
      <TfrxMemoView Name="Memo55" IndexTag="1" AllowVectorExport="True" Left="567,47279" Top="24,7953" Width="139,84261" Height="37,7953" Font.Charset="1" Font.Color="16777215" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Pág. [Page#] de [TotalPages#]">
        <Formats>
          <item/>
          <item/>
        </Formats>
      </TfrxMemoView>
      <TfrxMemoView Name="Memo56" AllowVectorExport="True" Left="12,77953" Top="-6,55906" Width="612,28386" Height="22,67718" Font.Charset="1" Font.Color="16777215" Font.Height="-15" Font.Name="Arial" Font.Style="2" Frame.Typ="0" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Empresa: P&#38;A - [copy(&#60;qryEmpresa.&#34;EMP_PAT&#34;&#62;,2,4)]"/>
      <TfrxMemoView Name="Memo57" AllowVectorExport="True" Left="12,77953" Top="56,69295" Width="389,29159" Height="41,57483" Font.Charset="1" Font.Color="16777215" Font.Height="-19" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" VAlign="vaBottom" Text="Data: [tbRelatorio.&#34;DATA&#34;] Caixa: [tbRelatorio.&#34;NRCAIXA&#34;]"/>
    </TfrxPageHeader>
    <TfrxMasterData Name="MasterData5" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="22,67718" Left="0" Top="181,41744" Visible="False" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="qryEntradas" DataSetName="qryEntradas" RowCount="0">
      <TfrxSubreport Name="Subreport1" AllowVectorExport="True" Left="7,55906" Top="0" Width="94,48825" Height="18,89765" Page="Page3"/>
    </TfrxMasterData>
  </TfrxReportPage>
  <TfrxReportPage Name="Page3" 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="">
    <TfrxGroupFooter Name="GroupFooter5" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="34,01577" Left="0" Top="347,71676" Width="718,1107">
      <TfrxMemoView Name="Memo63" IndexTag="1" AllowVectorExport="True" Left="423,30736" Top="7,55906" Width="79,37013" Height="18,89765" DataSet="QryFechamento" DataSetName="QryFechamento" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="[SUM(&#60;QryFechamento.&#34;ENTRADA_MANUAL&#34;&#62;,MasterData6)]"/>
      <TfrxMemoView Name="Memo64" IndexTag="1" AllowVectorExport="True" Left="504,45702" Top="7,55906" Width="79,37013" Height="18,89765" DataSet="QryFechamento" DataSetName="QryFechamento" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="[SUM(&#60;QryFechamento.&#34;SAIDA_MANUAL&#34;&#62;,MasterData6)]"/>
      <TfrxMemoView Name="Memo65" IndexTag="1" AllowVectorExport="True" Left="589,60668" Top="7,55906" Width="98,26778" Height="18,89765" DataSet="QryFechamento" DataSetName="QryFechamento" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="[SUM(&#60;QryFechamento.&#34;ENTRADA_MANUAL&#34;&#62;,MasterData6) + SUM(&#60;QryFechamento.&#34;FATURADO&#34;&#62;,MasterData6) - SUM(&#60;QryFechamento.&#34;SAIDA_MANUAL&#34;&#62;,MasterData6)]"/>
      <TfrxMemoView Name="Memo72" IndexTag="1" AllowVectorExport="True" Left="246,88992" Top="7,55906" Width="79,37013" Height="18,89765" DataSet="QryFechamento" DataSetName="QryFechamento" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Totais:"/>
      <TfrxMemoView Name="Memo87" IndexTag="1" AllowVectorExport="True" Left="340,1577" Top="7,55906" Width="79,37013" Height="18,89765" DataSet="QryFechamento" DataSetName="QryFechamento" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="[SUM(&#60;QryFechamento.&#34;FATURADO&#34;&#62;,MasterData6)]"/>
    </TfrxGroupFooter>
    <TfrxMasterData Name="MasterData6" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="26,45671" Left="0" Top="298,58287" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="QryFechamento" DataSetName="QryFechamento" RowCount="0">
      <TfrxMemoView Name="Memo68" IndexTag="1" AllowVectorExport="True" Left="-4" Top="-0,22047" Width="718,1107" Height="26,45671" DataSet="QryFechamento" DataSetName="QryFechamento" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" Highlight.Font.Charset="1" Highlight.Font.Color="255" Highlight.Font.Height="-13" Highlight.Font.Name="Arial" Highlight.Font.Style="0" Highlight.Condition="&#60;Line&#62; mod 2 = 0" Highlight.FillType="ftBrush" Highlight.Fill.BackColor="15790320" Highlight.Frame.Typ="0" ParentFont="False" Text=""/>
      <TfrxMemoView Name="Memo58" IndexTag="1" AllowVectorExport="True" Left="0" Top="3,77953" Width="196,53556" Height="18,89765" DataField="DESCRICAO" DataSet="QryFechamento" DataSetName="QryFechamento" Frame.Typ="0" Text="[QryFechamento.&#34;DESCRICAO&#34;]"/>
      <TfrxMemoView Name="Memo59" IndexTag="1" AllowVectorExport="True" Left="202,65368" Top="3,77953" Width="132,28355" Height="18,89765" DataField="DESCRICAO_1" DataSet="QryFechamento" DataSetName="QryFechamento" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[QryFechamento.&#34;DESCRICAO_1&#34;]"/>
      <TfrxMemoView Name="QryFechamentoENTRADA" IndexTag="1" AllowVectorExport="True" Left="423,30736" Top="3,77953" Width="79,37013" Height="18,89765" DataSet="QryFechamento" DataSetName="QryFechamento" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="[QryFechamento.&#34;ENTRADA_MANUAL&#34;]"/>
      <TfrxMemoView Name="QryFechamentoSAIDA" IndexTag="1" AllowVectorExport="True" Left="504,45702" Top="3,77953" Width="79,37013" Height="18,89765" DataSet="QryFechamento" DataSetName="QryFechamento" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="[QryFechamento.&#34;SAIDA_MANUAL&#34;]"/>
      <TfrxMemoView Name="Memo66" IndexTag="1" AllowVectorExport="True" Left="589,60668" Top="3,77953" Width="98,26778" Height="18,89765" DataSet="QryFechamento" DataSetName="QryFechamento" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="[(&#60;QryFechamento.&#34;FATURADO&#34;&#62;)  + (&#60;QryFechamento.&#34;ENTRADA_MANUAL&#34;&#62;) - (&#60;QryFechamento.&#34;SAIDA_MANUAL&#34;&#62;)]"/>
      <TfrxMemoView Name="Memo85" IndexTag="1" AllowVectorExport="True" Left="340,1577" Top="3,77953" Width="79,37013" Height="18,89765" DataSet="QryFechamento" DataSetName="QryFechamento" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="[QryFechamento.&#34;FATURADO&#34;]"/>
    </TfrxMasterData>
    <TfrxPageHeader Name="PageHeader2" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="124,72449" Left="0" Top="18,89765" Width="718,1107">
      <TfrxMemoView Name="Memo50" IndexTag="1" AllowVectorExport="True" Left="0" Top="-0,10235" Width="718,1107" Height="124,72449" Font.Charset="1" Font.Color="16777215" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" Fill.BackColor="128" HAlign="haRight" ParentFont="False" Text="Pág. [Page#] de [TotalPages#]">
        <Formats>
          <item/>
          <item/>
        </Formats>
      </TfrxMemoView>
      <TfrxMemoView Name="Memo43" AllowVectorExport="True" Left="7,71645" Top="38,01577" Width="612,28386" Height="26,45671" Font.Charset="1" Font.Color="16777215" Font.Height="-24" Font.Name="Arial" Font.Style="7" Frame.Typ="0" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Relatório de fechamento de caixa"/>
      <TfrxMemoView Name="Memo45" IndexTag="1" AllowVectorExport="True" Left="629,40198" Top="22,23624" Width="71,81107" Height="18,89765" Font.Charset="1" Font.Color="16777215" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[Time]"/>
      <TfrxMemoView Name="Memo46" IndexTag="1" AllowVectorExport="True" Left="629,40198" Top="3,77953" Width="71,81107" Height="18,89765" Font.Charset="1" Font.Color="16777215" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[Date]"/>
      <TfrxMemoView Name="Memo47" IndexTag="1" AllowVectorExport="True" Left="562,25232" Top="39,91342" Width="139,84261" Height="37,7953" Font.Charset="1" Font.Color="16777215" Font.Height="-11" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Pág. [Page#] de [TotalPages#]">
        <Formats>
          <item/>
          <item/>
        </Formats>
      </TfrxMemoView>
      <TfrxMemoView Name="Memo48" AllowVectorExport="True" Left="7,55906" Top="8,55906" Width="612,28386" Height="22,67718" Font.Charset="1" Font.Color="16777215" Font.Height="-15" Font.Name="Arial" Font.Style="2" Frame.Typ="0" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Empresa: P&#38;A - [copy(&#60;qryEmpresa.&#34;EMP_PAT&#34;&#62;,2,4)]"/>
      <TfrxMemoView Name="Memo49" AllowVectorExport="True" Left="7,55906" Top="71,81107" Width="389,29159" Height="41,57483" Font.Charset="1" Font.Color="16777215" Font.Height="-19" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" VAlign="vaBottom" Text="Data: [tbRelatorio.&#34;DATA&#34;] Caixa: [tbRelatorio.&#34;NRCAIXA&#34;]"/>
    </TfrxPageHeader>
    <TfrxHeader Name="Header5" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="22,67718" Left="0" Top="204,09462" Width="718,1107">
      <TfrxMemoView Name="Memo61" IndexTag="1" AllowVectorExport="True" Left="-5,889765" Top="0" Width="718,1107" Height="22,67718" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Arial" Font.Style="1" Frame.Typ="15" Fill.BackColor="12632256" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Fechamento"/>
    </TfrxHeader>
    <TfrxGroupHeader Name="GroupHeader5" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="26,45671" Left="0" Top="249,44898" Width="718,1107" Condition="tbRelatorio.&#34;NRCAIXA&#34;">
      <TfrxMemoView Name="Memo62" IndexTag="1" AllowVectorExport="True" Left="-7,55906" Top="1" Width="721,89023" Height="26,45671" DataSetName="qryVenda" DisplayFormat.FormatStr="%2.2f" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" Fill.BackColor="15000804" ParentFont="False" Text=""/>
      <TfrxMemoView Name="Memo67" IndexTag="1" AllowVectorExport="True" Left="5,77953" Top="3,77953" Width="196,53556" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Moeda"/>
      <TfrxMemoView Name="Memo69" IndexTag="1" AllowVectorExport="True" Left="204,87415" Top="3,77953" Width="132,28355" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Condição"/>
      <TfrxMemoView Name="Memo70" IndexTag="1" AllowVectorExport="True" Left="420,50433" Top="3,77953" Width="71,81107" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="Entradas"/>
      <TfrxMemoView Name="Memo71" IndexTag="1" AllowVectorExport="True" Left="591,82715" Top="3,77953" Width="86,92919" Height="18,89765" DataSetName="qryVenda" DisplayFormat.FormatStr="%2.2f" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="Diferença"/>
      <TfrxMemoView Name="Memo60" IndexTag="1" AllowVectorExport="True" Left="508,67749" Top="3,77953" Width="71,81107" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="Saídas"/>
      <TfrxMemoView Name="Memo86" IndexTag="1" AllowVectorExport="True" Left="344,91373" Top="3,77953" Width="71,81107" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="Faturados"/>
    </TfrxGroupHeader>
    <TfrxHeader Name="Header6" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="22,67718" Left="0" Top="404,40971" Width="718,1107">
      <TfrxMemoView Name="Memo73" IndexTag="1" AllowVectorExport="True" Left="-5,889765" Top="0" Width="718,1107" Height="22,67718" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Arial" Font.Style="1" Frame.Typ="15" Fill.BackColor="12632256" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="Totais"/>
    </TfrxHeader>
    <TfrxMasterData Name="MasterData7" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="34,01577" Left="0" Top="498,89796" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="QryTotais" DataSetName="QryTotais" RowCount="0">
      <TfrxMemoView Name="Memo77" IndexTag="1" AllowVectorExport="True" Left="5,55906" Top="3,77953" Width="147,40167" Height="18,89765" DataSet="QryTotais" DataSetName="QryTotais" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[QryTotais.&#34;CREDITO&#34;]"/>
      <TfrxMemoView Name="Memo80" IndexTag="1" AllowVectorExport="True" Left="153,1812" Top="3,77953" Width="132,28355" Height="18,89765" DataSet="QryTotais" DataSetName="QryTotais" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[QryTotais.&#34;DEBITO&#34;]"/>
      <TfrxMemoView Name="Memo81" IndexTag="1" AllowVectorExport="True" Left="372,39394" Top="3,77953" Width="128,50402" Height="18,89765" DataSet="QryTotais" DataSetName="QryTotais" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="[QryTotais.&#34;FUNDO_CAIXA&#34;]"/>
      <TfrxMemoView Name="Memo82" IndexTag="1" AllowVectorExport="True" Left="285,46475" Top="3,77953" Width="71,81107" Height="18,89765" DataSet="QryTotais" DataSetName="QryTotais" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="[QryTotais.&#34;DESCONTO&#34;]"/>
      <TfrxMemoView Name="Memo83" IndexTag="1" AllowVectorExport="True" Left="506,45702" Top="3,77953" Width="192,75603" Height="18,89765" DataSet="QryTotais" DataSetName="QryTotais" DisplayFormat.FormatStr="%2.2m" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="[(&#60;QryTotais.&#34;CREDITO&#34;&#62; + &#60;QryTotais.&#34;DEBITO&#34;&#62;) ]"/>
    </TfrxMasterData>
    <TfrxGroupHeader Name="GroupHeader6" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="26,45671" Left="0" Top="449,76407" Width="718,1107" Condition="tbRelatorio.&#34;NRCAIXA&#34;">
      <TfrxMemoView Name="Memo74" IndexTag="1" AllowVectorExport="True" Left="-7,55906" Top="1" Width="721,89023" Height="26,45671" DataSetName="qryVenda" DisplayFormat.FormatStr="%2.2f" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" Fill.BackColor="15000804" ParentFont="False" Text=""/>
      <TfrxMemoView Name="Memo75" IndexTag="1" AllowVectorExport="True" Left="5,77953" Top="3,77953" Width="136,06308" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Cartão de Crédito"/>
      <TfrxMemoView Name="Memo76" IndexTag="1" AllowVectorExport="True" Left="153,40167" Top="3,77953" Width="132,28355" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Cartão de Débito"/>
      <TfrxMemoView Name="Memo78" IndexTag="1" AllowVectorExport="True" Left="372,61441" Top="3,77953" Width="132,28355" Height="18,89765" DataSetName="qryVenda" DisplayFormat.FormatStr="%2.2f" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="Fundo de Caixa"/>
      <TfrxMemoView Name="Memo79" IndexTag="1" AllowVectorExport="True" Left="285,68522" Top="3,77953" Width="71,81107" Height="18,89765" DataSetName="qryVenda" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="Desconto"/>
      <TfrxMemoView Name="Memo84" IndexTag="1" AllowVectorExport="True" Left="510,45702" Top="3,77953" Width="188,9765" Height="18,89765" DataSetName="qryVenda" DisplayFormat.FormatStr="%2.2f" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="Total - Devolução"/>
    </TfrxGroupHeader>
  </TfrxReportPage>
</TfrxReport>
