Fórum Um select diferente #387353
27/09/2010
0
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
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
Curtir tópico
+ 0
Responder
Posts
27/09/2010
Eriley Barbosa
Select
IdCliente,
NomeCliente,
Doc,
Pa, Valor,
Min(Vencimento) Vencimento
From SuaTabela
Group By IdCliente,
NomeCliente,
Doc,
Pa, Valor
IdCliente,
NomeCliente,
Doc,
Pa, Valor,
Min(Vencimento) Vencimento
From SuaTabela
Group By IdCliente,
NomeCliente,
Doc,
Pa, Valor
Responder
Gostei + 0
27/09/2010
Eriley Barbosa
Mas talvez um simples order by possa resolver seu problema:
Select
IdCliente,
NomeCliente,
Doc,
Pa, Valor,
Vencimento
From SuaTabela
order By Vencimento,
IdCliente
IdCliente,
NomeCliente,
Doc,
Pa, Valor,
Vencimento
From SuaTabela
order By Vencimento,
IdCliente
Responder
Gostei + 0
29/09/2010
Mario Inacio
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.
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.
Responder
Gostei + 0
29/09/2010
Eriley Barbosa
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.
Responder
Gostei + 0
29/09/2010
Bruno Batista
Boa tarde,
verifica da seguinte maneira.
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
IdCliente,
NomeCliente,
Doc,
Pa, Valor,
Vencimento
From SuaTabela
order By Vencimento,
IdCliente
Responder
Gostei + 0
29/09/2010
Bruno Batista
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.
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.
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
IdCliente,
NomeCliente,
Doc,
Pa, Valor,
Vencimento
From SuaTabela
order By Vencimento,
IdCliente
Responder
Gostei + 0
29/09/2010
William Galleti
Boa tarde
Eu usaria assim.
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
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
Responder
Gostei + 0
29/09/2010
Emerson Nascimento
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
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
Responder
Gostei + 0
04/10/2010
Mario Inacio
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;
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;
Responder
Gostei + 0
Clique aqui para fazer login e interagir na Comunidade :)