Um select diferente

Delphi

27/09/2010

Olá amigos,

Um cliente me pediu um relatório de contas a receber, da seguinte forma:

- A 1ª ordem é pelas parcelas mais atrasadas
- A 2ª ordem é pelo cliente

Exemplificado:









Notem que a ordem na verdade é sobre o vencimento mais atrasado, e consequentemente agrupa os demais do cliente, independentemente do próximo cliente.

Campos utilizados:
- Codcli
- doc
- pa
- datven

Há alguma forma de fazer um select assim, ou vai ter que ser no braço mesmo?

att
Mario
Mario Inacio

Mario Inacio

Curtidas 0

Respostas

Eriley Barbosa

Eriley Barbosa

27/09/2010

Select  
            IdCliente,
            NomeCliente,
            Doc,
            Pa,             Valor,
            Min(Vencimento) Vencimento
From SuaTabela
Group By             IdCliente,
            NomeCliente,
            Doc,
            Pa,             Valor
GOSTEI 0
Eriley Barbosa

Eriley Barbosa

27/09/2010

Mas talvez um simples order by possa resolver seu problema: Select  
            IdCliente,
            NomeCliente,
            Doc,
            Pa,               Valor,
              Vencimento
From SuaTabela
order By             Vencimento,
            IdCliente
GOSTEI 0
Mario Inacio

Mario Inacio

27/09/2010

Olá Eriley,

A primeira sugestão saiu como a imagem:

A segunda apenas ordena pelo vencimento e depois pelo cliente.

No exemplo acima, como a Eliene possui a conta vencida a mais tempo, todas as suas outras contas deveriam estar agrupadas ela, não somadas, apenas agrupadas, depois a ROSANE que possui a segunda conta vencida a mais tempo deveria ter suas outras contas tbm agrupadas.
GOSTEI 0
Eriley Barbosa

Eriley Barbosa

27/09/2010

Você só vai conseguir isso utilizando uma stored procedure ou fazendo um relatório por agrupamento no quick report, ou utilizando o clientdataset como tabela temporaria.
GOSTEI 0
Bruno Batista

Bruno Batista

27/09/2010

Boa tarde,

verifica da seguinte maneira.

Select    IdCliente,
            NomeCliente,
            Doc,
            Pa, 
              Valor,
              Vencimento
From SuaTabela
order By IdCliente,
            Vencimento


Mas talvez um simples order by possa resolver seu problema: Select  
            IdCliente,
            NomeCliente,
            Doc,
            Pa,               Valor,
              Vencimento
From SuaTabela
order By             Vencimento,
            IdCliente
GOSTEI 0
Bruno Batista

Bruno Batista

27/09/2010

Boa tarde,

caso o acima não funcione verifique se o SQL seguinte resolve o seu problema.

P.S.: Este SQL não cheguei a realizar o teste, pelo o que pude perceber poderá ocasionar problema ao unir os dois SELECT, pois as colunas CodCli e NomCli poderão ser de tipos diferentes, com isso será necessário converter para string a coluna CodCli.

Select CodCli,
       NomCli,
       Doc,
       Pa,
       DatVen, 
       ValDoc,
       Venc
  FROM (
Select 1 As Linha,
       CodCli AS Codigo,
       CodCli,
       NomCli,
       Doc,
       Pa,
       DatVen,
       ValDoc,
       Venc
  From Tabela
 Where (CodCli, Venc) In (Select CodCli,
                                 Min(Venc)
                            From Tabela)
Union All
Select 2 As Linha,
       CodCli AS Codigo,
       ' ' As CodCli,
       ' ' As NomCli,
       Doc,
       Pa,
       DatVen,
       ValDoc,
       Venc
  From Tabela 
 Where (CodCli, Venc) Not In (Select CodCli,
                                     Min(Venc)
                                From Tabela)
        
 Order by Codigo,
          Linha,
          Venc)



Boa tarde,

verifica da seguinte maneira.

Select    IdCliente,
            NomeCliente,
            Doc,
            Pa, 
              Valor,
              Vencimento
From SuaTabela
order By IdCliente,
            Vencimento


Mas talvez um simples order by possa resolver seu problema: Select  
            IdCliente,
            NomeCliente,
            Doc,
            Pa,               Valor,
              Vencimento
From SuaTabela
order By             Vencimento,
            IdCliente
GOSTEI 0
William Galleti

William Galleti

27/09/2010

Boa tarde   Eu usaria assim.   
  Select Cliente,
         Doc,
         Pa,
         Vencimento,
         Sum(Valor) Valor --soma os campos agrupados
    From Tabela
   Group By Cliente, Doc, Pa, Vencimento --Aqui ele agrupa todos os campos que consegue
   Order By Vencimento, Cliente --Ordena por vencimento e depois por Cliente
  Se eu entendi direito é simples isso em código.   Ai para fazer em relatorio (QuickReport por exemplo), da maneira que esta ali, vai dar um pouco mais de trabalho, mais também não tem segredo.   Espero ter ajudado.   msn: william.galleti@gmail.com
GOSTEI 0
Emerson Nascimento

Emerson Nascimento

27/09/2010

qual o banco de dados utilizado?

dependendo do banco de dados e da versão dele, dá pra fazer assim:

select
  t2.vencto,
  t1.Codcli,
  t1.doc,
  t1.pa,
  t1.datven
from
  tabela t1
left join
  (select min(datven) vencto, codcli
   from tabela
   group by codcli) t2 on t2.codcli = t1.codcli
order by
  t2.vencto, t1.codcli

GOSTEI 0
Mario Inacio

Mario Inacio

27/09/2010

Olá amigos,
Obrigado pelas respostas a té agora, mas não consegui reproduzir o que preciso.

Segue abaixo os scripts 1 e 2 que cria a tabela areceber e o outro insere os dados para possibilitar testar.
Verifiquem minha primeira imagem deste post pra saber o que preciso.

- Não é ordenar nem somar os débitos do cliente.
- É agrupar por cliente pela ordem do vencimento mais antigo.

Se puderem auxiliar, agradeço mais uma vez.


***** SCRIPT 1

/******************************************************************************/
/****         Generated by IBExpert 2006.10.14 4/10/2010 15:35:20          ****/
/******************************************************************************/

SET SQL DIALECT 3;

SET NAMES WIN1252;

SET CLIENTLIB 'C:\Arquivos de programas\Firebird\Firebird_2_0\bin\fbclient.dll';



/******************************************************************************/
/****                               Domains                                ****/
/******************************************************************************/

CREATE DOMAIN BINT AS
BIGINT;

CREATE DOMAIN CARAC13 AS
VARCHAR(13)
COLLATE WIN_PTBR;

CREATE DOMAIN CARAC15 AS
VARCHAR(15)
COLLATE WIN_PTBR;

CREATE DOMAIN CARAC200 AS
VARCHAR(200)
COLLATE WIN_PTBR;

CREATE DOMAIN CARAC30 AS
VARCHAR(30)
COLLATE WIN_PTBR;

CREATE DOMAIN CARAC50 AS
VARCHAR(50)
COLLATE WIN_PTBR;

CREATE DOMAIN CARAC500 AS
VARCHAR(500)
COLLATE WIN_PTBR;

CREATE DOMAIN CARAC5000 AS
VARCHAR(5000)
COLLATE WIN_PTBR;

CREATE DOMAIN CARAC70 AS
VARCHAR(70)
COLLATE WIN_PTBR;

CREATE DOMAIN DCEP AS
VARCHAR(14)
COLLATE WIN_PTBR;

CREATE DOMAIN DCNPJ AS
VARCHAR(30)
COLLATE WIN_PTBR;

CREATE DOMAIN DCPF AS
VARCHAR(30)
COLLATE WIN_PTBR;

CREATE DOMAIN DDATA AS
DATE;

CREATE DOMAIN DECIMALQTD AS
DECIMAL(15,4);

CREATE DOMAIN DFONE AS
VARCHAR(30)
COLLATE WIN_PTBR;

CREATE DOMAIN DHORA AS
VARCHAR(8)
COLLATE WIN_PTBR;

CREATE DOMAIN DIE AS
VARCHAR(30)
COLLATE WIN_PTBR;

CREATE DOMAIN DRG AS
VARCHAR(30)
COLLATE WIN_PTBR;

CREATE DOMAIN DUF AS
VARCHAR(14)
COLLATE WIN_PTBR;



/******************************************************************************/
/****                                Tables                                ****/
/******************************************************************************/



CREATE TABLE ARECEBER (
    INCLUSAO        CARAC200 /* CARAC200 = VARCHAR(200) */,
    ALTERACAO       CARAC200 /* CARAC200 = VARCHAR(200) */,
    MARCAR          VARCHAR(1) COLLATE WIN_PTBR,
    CODCLI          INTEGER NOT NULL,
    DOC             VARCHAR(10) NOT NULL,
    PA              INTEGER NOT NULL,
    PEDIDO          INTEGER,
    HORAGER         DHORA /* DHORA = VARCHAR(8) */,
    HORAREC         DHORA /* DHORA = VARCHAR(8) */,
    DATDOC          DDATA /* DDATA = DATE */,
    DATVEN          DDATA /* DDATA = DATE */,
    DATREC          DDATA /* DDATA = DATE */,
    VALPRI          DECIMAL(12,2),
    VALDOC          DECIMAL(12,2),
    JUROS           DECIMAL(12,2),
    DESCONTO        DECIMAL(12,2),
    PDESCTO         DECIMAL(12,2),
    COMISSAO        DECIMAL(12,2),
    DEVOLUCAO       DECIMAL(12,2),
    TOTREC          DECIMAL(12,2),
    DINHEIRO        DECIMAL(12,2),
    CHEQUE          DECIMAL(12,2),
    CARTAOD         DECIMAL(12,2),
    CARTAOC         DECIMAL(12,2),
    ONLINE          DECIMAL(12,2),
    VALE            DECIMAL(12,2),
    HISTOR1         CARAC50 /* CARAC50 = VARCHAR(50) */,
    HISTOR2         CARAC50 /* CARAC50 = VARCHAR(50) */,
    HISTOR3         CARAC50 /* CARAC50 = VARCHAR(50) */,
    OBSREC1         CARAC50 /* CARAC50 = VARCHAR(50) */,
    OBSREC2         CARAC50 /* CARAC50 = VARCHAR(50) */,
    DIASATRA        INTEGER,
    PA_ORIGEM       INTEGER,
    CAIXAV          INTEGER,
    CAIXAR          INTEGER,
    CODCOB          INTEGER,
    RECIBO          INTEGER,
    BANCO           INTEGER,
    QUITADO         INTEGER,
    DOCRENEGOCIADO  VARCHAR(10) COLLATE WIN_PTBR,
    CODUCLI         INTEGER,
    PJUROS          DECIMAL(14,4),
    DATLAN          DDATA /* DDATA = DATE */,
    BOLETO          CARAC15 /* CARAC15 = VARCHAR(15) */,
    NUMCHEQUE       CARAC15 /* CARAC15 = VARCHAR(15) */,
    DATREG          DDATA /* DDATA = DATE */,
    DATBAI          DDATA /* DDATA = DATE */,
    SITUACAO        INTEGER,
    TIPOCOB         INTEGER,
    JUROSCAL        DECIMAL(12,2),
    TOTALCAL        DECIMAL(12,2),
    ESERVER         INTEGER,
    VALDOCMER       DECIMAL(15,2)
);



/******************************************************************************/
/****                             Primary Keys                             ****/
/******************************************************************************/

ALTER TABLE ARECEBER ADD CONSTRAINT IP_ARECEBER PRIMARY KEY (CODCLI, DOC, PA);





****** SCRIPT 2

INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES (NULL, NULL, NULL, 5, '8079', 101, 999999999, NULL, NULL, '2009-12-22', '2010-01-21', NULL, NULL, 17.9, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:01', '06/07/2010 17:03:01', '', 5, '8355', 1, 999999999, '', '', '2010-01-14', '2010-02-13', '1899-12-30', 23.95, 23.95, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-01-14', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:01', '06/07/2010 17:03:01', '', 5, '8355', 2, 999999999, '', '', '2010-01-14', '2010-03-15', '1899-12-30', 23.95, 23.95, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-01-14', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:02', '06/07/2010 17:03:02', '', 5, '8443', 1, 999999999, '', '', '2010-02-01', '2010-03-03', '1899-12-30', 48.34, 48.34, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-02-01', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:02', '06/07/2010 17:03:02', '', 5, '8443', 2, 999999999, '', '', '2010-02-01', '2010-04-02', '1899-12-30', 48.33, 48.33, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-02-01', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:02', '06/07/2010 17:03:02', '', 5, '8443', 3, 999999999, '', '', '2010-02-01', '2010-05-02', '1899-12-30', 48.33, 48.33, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-02-01', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:04', '06/07/2010 17:03:04', '', 6, '8680', 1, 999999999, '', '', '2010-03-08', '2010-04-07', '1899-12-30', 30.9, 30.9, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-03-08', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:04', '06/07/2010 17:03:04', '', 6, '8680', 2, 999999999, '', '', '2010-03-08', '2010-05-07', '1899-12-30', 30.9, 30.9, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-03-08', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:05', '06/07/2010 17:03:05', '', 5, '9024', 1, 999999999, '', '', '2010-04-10', '2010-05-10', '1899-12-30', 59.9, 59.9, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-04-10', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES (NULL, NULL, NULL, 3, '8992', 102, 999999999, NULL, NULL, '2010-04-08', '2010-06-07', NULL, NULL, 8.5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:07', '06/07/2010 17:03:07', '', 3, '8992', 3, 999999999, '', '', '2010-04-08', '2010-07-07', '1899-12-30', 55.5, 55.5, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-04-08', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:07', '06/07/2010 17:03:07', '', 5, '8985', 1, 999999999, '', '', '2010-04-17', '2010-05-08', '1899-12-30', 76.4, 76.4, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-04-17', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES (NULL, NULL, NULL, 2, '9034', 103, 999999999, NULL, NULL, '2010-04-12', '2010-07-11', NULL, NULL, 39.36, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:08', '06/07/2010 17:03:08', '', 5, '8985', 2, 999999999, '', '', '2010-04-17', '2010-06-07', '1899-12-30', 76.4, 76.4, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-04-17', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:08', '06/07/2010 17:03:08', '', 6, '9161', 1, 999999999, '', '', '2010-04-26', '2010-05-26', '1899-12-30', 25.7, 25.7, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-04-26', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:09', '06/07/2010 17:03:09', '', 4, '9177', 1, 999999999, '', '', '2010-04-28', '2010-05-28', '1899-12-30', 87.4, 87.4, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-04-28', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:09', '06/07/2010 17:03:09', '', 4, '9177', 2, 999999999, '', '', '2010-04-28', '2010-06-27', '1899-12-30', 87.4, 87.4, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-04-28', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:09', '06/07/2010 17:03:09', '', 4, '9251', 1, 999999999, '', '', '2010-05-05', '2010-06-04', '1899-12-30', 32.45, 32.45, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-05-05', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:09', '06/07/2010 17:03:09', '', 4, '9251', 2, 999999999, '', '', '2010-05-05', '2010-07-04', '1899-12-30', 32.45, 32.45, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-05-05', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:10', '06/07/2010 17:03:10', '', 5, '9189', 1, 999999999, '', '', '2010-05-07', '2010-05-29', '1899-12-30', 92.35, 92.35, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-05-07', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:10', '06/07/2010 17:03:10', '', 5, '9189', 2, 999999999, '', '', '2010-05-07', '2010-06-28', '1899-12-30', 92.35, 92.35, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-05-07', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:10', '06/07/2010 17:03:10', '', 2, '9338', 2, 999999999, '', '', '2010-05-14', '2010-07-13', '1899-12-30', 147.5, 147.5, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-05-14', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:10', '06/07/2010 17:03:10', '', 2, '9338', 3, 999999999, '', '', '2010-05-14', '2010-08-12', '1899-12-30', 147.5, 147.5, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-05-14', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:10', '06/07/2010 17:03:10', '', 6, '9353', 1, 999999999, '', '', '2010-05-17', '2010-06-16', '1899-12-30', 31.45, 31.45, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-05-17', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:10', '06/07/2010 17:03:10', '', 6, '9353', 2, 999999999, '', '', '2010-05-17', '2010-07-16', '1899-12-30', 31.45, 31.45, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-05-17', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:10', '06/07/2010 17:03:10', '', 5, '9367', 1, 999999999, '', '', '2010-05-17', '2010-06-16', '1899-12-30', 40.8, 40.8, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-05-17', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:10', '06/07/2010 17:03:10', '', 5, '9367', 2, 999999999, '', '', '2010-05-17', '2010-07-16', '1899-12-30', 40.8, 40.8, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-05-17', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:11', '06/07/2010 17:03:11', '', 4, '9475', 1, 999999999, '', '', '2010-05-27', '2010-07-01', '1899-12-30', 27.35, 27.35, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-05-27', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:11', '06/07/2010 17:03:11', '', 2, '9421', 2, 999999999, '', '', '2010-05-22', '2010-07-21', '1899-12-30', 86.67, 86.67, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-05-22', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:11', '06/07/2010 17:03:11', '', 2, '9421', 3, 999999999, '', '', '2010-05-22', '2010-08-20', '1899-12-30', 86.67, 86.67, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-05-22', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:11', '06/07/2010 17:03:11', '', 4, '9475', 2, 999999999, '', '', '2010-05-27', '2010-07-31', '1899-12-30', 27.35, 27.35, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-05-27', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:12', '06/07/2010 17:03:12', '', 1, '9521', 2, 999999999, '', '', '2010-06-02', '2010-08-01', '1899-12-30', 42, 42, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-06-02', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:14', '06/07/2010 17:03:14', '', 2, '9699', 1, 999999999, '', '', '2010-06-22', '2010-07-22', '1899-12-30', 29.9, 29.9, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-06-22', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:14', '06/07/2010 17:03:14', '', 2, '9699', 2, 999999999, '', '', '2010-06-22', '2010-08-21', '1899-12-30', 29.9, 29.9, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-06-22', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:15', '06/07/2010 17:03:15', '', 1, '9790', 1, 999999999, '', '', '2010-07-06', '2010-07-10', '1899-12-30', 65, 65, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-07-06', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:15', '06/07/2010 17:03:15', '', 1, '9790', 2, 999999999, '', '', '2010-07-06', '2010-08-10', '1899-12-30', 65, 65, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-07-06', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);
INSERT INTO ARECEBER (INCLUSAO, ALTERACAO, MARCAR, CODCLI, DOC, PA, PEDIDO, HORAGER, HORAREC, DATDOC, DATVEN, DATREC, VALPRI, VALDOC, JUROS, DESCONTO, PDESCTO, COMISSAO, DEVOLUCAO, TOTREC, DINHEIRO, CHEQUE, CARTAOD, CARTAOC, ONLINE, VALE, HISTOR1, HISTOR2, HISTOR3, OBSREC1, OBSREC2, DIASATRA, PA_ORIGEM, CAIXAV, CAIXAR, CODCOB, RECIBO, BANCO, QUITADO, DOCRENEGOCIADO, CODUCLI, PJUROS, DATLAN, BOLETO, NUMCHEQUE, DATREG, DATBAI, SITUACAO, TIPOCOB, JUROSCAL, TOTALCAL, ESERVER, VALDOCMER) VALUES ('06/07/2010 17:03:15', '06/07/2010 17:03:15', '', 1, '9790', 3, 999999999, '', '', '2010-07-06', '2010-09-10', '1899-12-30', 65, 65, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 1, '', 0, 0, '2010-07-06', '', '', NULL, NULL, 0, 1, NULL, NULL, NULL, NULL);

COMMIT WORK;



GOSTEI 0
POSTAR