INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('02')::integer, TRIM('C'), TRIM('Entrada Confirmada') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('R'), TRIM('Entrada Rejeitada') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('05')::integer, TRIM('C'), TRIM('Campo Livre Alterado') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('06')::integer, TRIM('B'), TRIM('Liquidacao Normal') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('08')::integer, TRIM('B'), TRIM('Liquidacao em Cartorio') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('09')::integer, TRIM('C'), TRIM('Baixa Automatica') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('10')::integer, TRIM('C'), TRIM('Baixa por ter sido liquidado') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('12')::integer, TRIM('C'), TRIM('Confirma Abatimento') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('13')::integer, TRIM('C'), TRIM('Abatimento Cancelado') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('14')::integer, TRIM('C'), TRIM('Vencimento Alterado') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('15')::integer, TRIM('C'), TRIM('Baixa Rejeitada') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('C'), TRIM('Instrucao Rejeitada') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('19')::integer, TRIM('C'), TRIM('Confirma Recebimento de Ordem de Protesto') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('20')::integer, TRIM('C'), TRIM('Confirma Recebimento de Ordem de Sustacao') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('22')::integer, TRIM('C'), TRIM('Seu numero alterado') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('23')::integer, TRIM('C'), TRIM('Titulo enviado para cartorio') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('24')::integer, TRIM('C'), TRIM('Confirma recebimento de ordem de nao protestar') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('28')::integer, TRIM('C'), TRIM('Debito de Tarifas/Custas – Correspondentes') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('40')::integer, TRIM('C'), TRIM('Tarifa de Entrada (debitada na Liquidacao)') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('43')::integer, TRIM('C'), TRIM('Baixado por ter sido protestado') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('96')::integer, TRIM('C'), TRIM('Tarifa Sobre Instrucoes – Mes anterior') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('97')::integer, TRIM('C'), TRIM('Tarifa Sobre Baixas – Mes Anterior') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('98')::integer, TRIM('C'), TRIM('Tarifa Sobre Entradas – Mes Anterior') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('99')::integer, TRIM('C'), TRIM('Tarifa Sobre Instrucoes de Protesto/Sustacao – Mes Anterior') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('998')::integer, TRIM('E'), TRIM('Gerada a Remessa') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('637')::integer, TRIM('999')::integer, TRIM('E'), TRIM('Impressao do Boleto') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('01')::integer, TRIM('C'), TRIM('Confirma Entrada Titulo na CIP') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('02')::integer, TRIM('C'), TRIM('Entrada Confirmada') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('R'), TRIM('Entrada Rejeitada') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('05')::integer, TRIM('C'), TRIM('Campo Livre Alterado') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('06')::integer, TRIM('B'), TRIM('Liquidacao Normal') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('08')::integer, TRIM('B'), TRIM('Liquidacao em Cartorio') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('09')::integer, TRIM('C'), TRIM('Baixa Automatica') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('10')::integer, TRIM('C'), TRIM('Baixa por ter sido liquidado') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('12')::integer, TRIM('C'), TRIM('Confirma Abatimento') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('13')::integer, TRIM('C'), TRIM('Abatimento Cancelado') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('14')::integer, TRIM('C'), TRIM('Vencimento Alterado') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('15')::integer, TRIM('C'), TRIM('Baixa Rejeitada') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('16')::integer, TRIM('C'), TRIM('Instrucao Rejeitada') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('19')::integer, TRIM('C'), TRIM('Confirma Recebimento de Ordem de Protesto') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('20')::integer, TRIM('C'), TRIM('Confirma Recebimento de Ordem de Sustacao') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('22')::integer, TRIM('C'), TRIM('Seu numero alterado') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('23')::integer, TRIM('C'), TRIM('Titulo enviado para cartorio') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('24')::integer, TRIM('C'), TRIM('Confirma recebimento de ordem de nao protestar') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('28')::integer, TRIM('C'), TRIM('Debito de Tarifas/Custas – Correspondentes') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('40')::integer, TRIM('C'), TRIM('Tarifa de Entrada (debitada na Liquidacao)') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('43')::integer, TRIM('C'), TRIM('Baixado por ter sido protestado') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('96')::integer, TRIM('C'), TRIM('Tarifa Sobre Instrucoes – Mes anterior') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('97')::integer, TRIM('C'), TRIM('Tarifa Sobre Baixas – Mes Anterior') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('98')::integer, TRIM('C'), TRIM('Tarifa Sobre Entradas – Mes Anterior') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('99')::integer, TRIM('C'), TRIM('Tarifa Sobre Instrucoes de Protesto/Sustacao – Mes Anterior') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('998')::integer, TRIM('E'), TRIM('Gerada a Remessa') FROM bas_filial); INSERT INTO rcb_dup_retorno (SELECT codigo, TRIM('707')::integer, TRIM('999')::integer, TRIM('E'), TRIM('Impressao do Boleto') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('03'), TRIM('CEP invalido – Nao temos cobrador – Cobrador nao Localizado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('04'), TRIM('Sigla do Estado invalida') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('05'), TRIM('Data de Vencimento invalida ou fora do prazo minimo') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('06'), TRIM('Codigo do Banco invalido') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('08'), TRIM('Nome do sacado nao informado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('10'), TRIM('Logradouro nao informado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('14'), TRIM('Registro em duplicidade') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('19'), TRIM('Data de desconto invalida ou maior que a data de vencimento') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('20'), TRIM('Valor de IOF nao numerico') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('21'), TRIM('Movimento para titulo nao cadastrado no sistema') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('22'), TRIM('Valor de desconto + abatimento maior que o valor do titulo') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('25'), TRIM('CNPJ ou CPF do sacado invalido (aceito com restricoes)') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('26'), TRIM('Especie de documento invalida') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('27'), TRIM('Data de emissao do titulo invalida') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('28'), TRIM('Seu numero nao informado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('29'), TRIM('CEP e igual a espaco ou zeros; ou nao numerico') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('30'), TRIM('Valor do titulo nao numerico ou invalido') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('36'), TRIM('Valor de permanencia (mora) nao numerico') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('37'), TRIM('Valor de permanencia inconsistente, pois, dentro de um mes, sera maior que o') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('38'), TRIM('valor do titulo') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('39'), TRIM('Valor de desconto/abatimento nao numerico ou invalido') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('42'), TRIM('Valor de abatimento nao numerico') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('43'), TRIM('Titulo ja existente em nossos registros. Nosso numero nao aceito') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('44'), TRIM('Titulo enviado em duplicidade nesse movimento') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('46'), TRIM('Titulo zerado ou em branco; ou nao numerico na remessa') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('51'), TRIM('Titulo enviado fora da faixa de Nosso Numero, estipulada para o cliente.') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('52'), TRIM('Tipo/Numero de Inscricao Sacador/Avalista Invalido') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('53'), TRIM('Sacador/Avalista nao informado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('54'), TRIM('Prazo de vencimento do titulo excede ao da contratacao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('55'), TRIM('Banco informado nao e nosso correspondente 140-142') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('56'), TRIM('Banco correspondente informado nao cobra este CEP ou nao possui faixas de') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('57'), TRIM('CEP cadastradas') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('58'), TRIM('Nosso numero no correspondente nao foi informado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('60'), TRIM('Remessa contendo duas instrucoes incompativeis – nao protestar e dias de') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('87'), TRIM('protesto ou prazo para protesto invalido.') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('AA'), TRIM('Entradas Rejeitadas – Reprovado no Represamento para Analise') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('AB'), TRIM('CNPJ/CPF do sacado invalido – titulo recusado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('AE'), TRIM('Excede Prazo maximo entre emissao e vencimento') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('AI'), TRIM('Servico de cobranca invalido') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('AJ'), TRIM('Servico de "0" ou "5" e banco cobrador <> zeros') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('AL'), TRIM('Titulo nao possui abatimento') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('AU'), TRIM('Nossa carteira invalida') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('AV'), TRIM('Modalidade com bancos correspondentes invalida') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('AX'), TRIM('Sacado impedido de entrar nesta cobranca') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('BC'), TRIM('Data da ocorrencia invalida') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('BD'), TRIM('Valor da tarifa de cobranca invalida') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('BE'), TRIM('Titulo em pagamento parcial') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('BF'), TRIM('Analise gerencial-sacado invalido p/operacao credito') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('BG'), TRIM('Analise gerencial-sacado inadimplente') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('BH'), TRIM('Analise gerencial-sacado difere do exigido') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('CC'), TRIM('Analise gerencial-vencto excede vencto da operacao de credito') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('CD'), TRIM('Analise gerencial-sacado com baixa liquidez') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('CE'), TRIM('Analise gerencial-sacado excede concentracao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('CF'), TRIM('Valor de iof incompativel com a especie documento') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('CG'), TRIM('Titulo nao aceito – por analise gerencial') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('CH'), TRIM('Titulo em espera – em analise pelo banco') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('CJ'), TRIM('Analise gerencial-vencto do titulo abaixo prazo curto') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('CK'), TRIM('Analise gerencial-vencto do titulo abaixo prazo longo') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('CS'), TRIM('Titulo rejeitado pela checagem de duplicatas') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('DA'), TRIM('Analise gerencial – Entrada de Titulo Descontado com limite cancelado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('DB'), TRIM('Analise gerencial – Entrada de Titulo Descontado com limite vencido') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('DC'), TRIM('Analise gerencial - cedente com limite cancelado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('DD'), TRIM('Analise gerencial – cedente e sacado e teve seu limite cancelado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('DE'), TRIM('Analise gerencial - apontamento no Serasa') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('DG'), TRIM('Endereco sacador/avalista nao informado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('DH'), TRIM('Cep do sacador/avalista nao informado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('DI'), TRIM('Cidade do sacador/avalista nao informado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('DJ'), TRIM('Estado do sacador/avalista invalido ou n informado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('DM'), TRIM('Cliente sem Codigo de Flash cadastrado no cobrador') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('DN'), TRIM('Titulo Descontado com Prazo ZERO – Recusado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('DP'), TRIM('Data de Referencia menor que a Data de Emissao do Titulo') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('DT'), TRIM('Nosso Numero do Correspondente nao deve ser informado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('EB'), TRIM('HSBC nao aceita endereco de sacado com mais de 38 caracteres') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('G1'), TRIM('Endereco do sacador incompleto ( lei 12.039)') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('G2'), TRIM('Sacador impedido de movimentar') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('G3'), TRIM('Concentracao de cep nao permitida') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM('G4'), TRIM('Valor do titulo nao permitido') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('15')::integer, TRIM('05'), TRIM('Solicitacao de baixa para titulo ja baixado ou liquidado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('15')::integer, TRIM('06'), TRIM('Solicitacao de baixa para titulo nao registrado no sistema') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('15')::integer, TRIM('08'), TRIM('Solicitacao de baixa para titulo em float') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('04'), TRIM('Data de vencimento nao numerica ou invalida') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('05'), TRIM('Data de Vencimento invalida ou fora do prazo minimo') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('14'), TRIM('Registro em duplicidade') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('19'), TRIM('Data de desconto invalida ou maior que a data de vencimento') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('20'), TRIM('Campo livre nao informado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('21'), TRIM('Titulo nao registrado no sistema') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('22'), TRIM('Titulo baixado ou liquidado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('26'), TRIM('Especie de documento invalida') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('27'), TRIM('Instrucao nao aceita, por nao ter sido emitida ordem de protesto ao cartorio') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('28'), TRIM('Titulo tem instrucao de cartorio ativa') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('29'), TRIM('Titulo nao tem instrucao de carteira ativa') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('30'), TRIM('Existe instrucao de nao protestar, ativa para o titulo') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('36'), TRIM('Valor de permanencia (mora) nao numerico') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('37'), TRIM('Titulo Descontado – Instrucao nao permitida para a carteira') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('38'), TRIM('Valor do abatimento nao numerico ou maior que a soma do valor do titulo + permanencia + multa') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('39'), TRIM('Titulo em cartorio') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('40'), TRIM('Instrucao recusada – Reprovado no Represamento para Analise') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('44'), TRIM('Titulo zerado ou em branco; ou nao numerico na remessa') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('51'), TRIM('Tipo/Numero de Inscricao Sacador/Avalista Invalido') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('53'), TRIM('Prazo de vencimento do titulo excede ao da contratacao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('57'), TRIM('Remessa contendo duas instrucoes incompativeis – nao protestar e dias de protesto ou prazo para protesto invalido.') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('AA'), TRIM('Servico de cobranca invalido') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('AE'), TRIM('Titulo nao possui abatimento') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('AG'), TRIM('Movimento nao permitido – Titulo a vista ou contra apresentacao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('AH'), TRIM('Cancelamento de valores invalidos') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('AI'), TRIM('Nossa carteira invalida') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('AK'), TRIM('Titulo pertence a outro cliente') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('AU'), TRIM('Data da ocorrencia invalida') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('AY'), TRIM('Titulo deve estar em aberto e vencido para acatar protesto') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('CB'), TRIM('Titulo possui protesto efetivado/a efetivar hoje') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('CT'), TRIM('Titulo ja baixado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('CW'), TRIM('Titulo ja transferido') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('DO'), TRIM('Titulo em Prejuizo') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('16')::integer, TRIM('99'), TRIM('Ocorrencia desconhecida na remessa') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('02')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('03')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('05')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('06')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('08')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('09')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('10')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('12')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('13')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('14')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('19')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('20')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('22')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('23')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('24')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('28')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('40')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('43')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('96')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('97')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('98')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('637')::integer, TRIM('99')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('03'), TRIM('CEP invalido – Nao temos cobrador – Cobrador nao Localizado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('04'), TRIM('Sigla do Estado invalida') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('05'), TRIM('Data de Vencimento invalida ou fora do prazo minimo') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('06'), TRIM('Codigo do Banco invalido') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('08'), TRIM('Nome do sacado nao informado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('10'), TRIM('Logradouro nao informado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('14'), TRIM('Registro em duplicidade') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('19'), TRIM('Data de desconto invalida ou maior que a data de vencimento') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('20'), TRIM('Valor de IOF nao numerico') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('21'), TRIM('Movimento para titulo nao cadastrado no sistema') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('22'), TRIM('Valor de desconto + abatimento maior que o valor do titulo') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('25'), TRIM('CNPJ ou CPF do sacado invalido (aceito com restricoes)') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('26'), TRIM('Especies de documento invalida (difere de 01...10,13 e 99)') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('27'), TRIM('Data de emissao do titulo invalida') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('28'), TRIM('Seu numero nao informado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('29'), TRIM('CEP e igual a espaco ou zeros') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('30'), TRIM('Valor do titulo nao numerico ou invalido') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('36'), TRIM('Valor de permanencia nao numerico') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('37'), TRIM('Valor de permanencia inconsistente, pois, dentro de um mes, sera maior que o valor do titulo') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('38'), TRIM('Valor de desconto/abatimento nao numerico ou invalido') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('39'), TRIM('Valor de abatimento nao numerico') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('42'), TRIM('Titulo ja existente em nossos registros. Nosso numero nao aceito') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('43'), TRIM('Titulo enviado em duplicidade nesse movimento') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('44'), TRIM('Titulo zerado ou em branco') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('46'), TRIM('Titulo enviado fora da faixa de Nosso Numero, estipulada para o cliente.') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('51'), TRIM('Tipo/Numero de Inscricao Sacador/Avalista Invalido') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('52'), TRIM('Sacador/Avalista nao informado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('53'), TRIM('Prazo de vencimento do titulo excede ao da contratacao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('54'), TRIM('Banco informado nao e nosso correspondente 140-142') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('55'), TRIM('Banco correspondente informado nao cobra este CEP ou nao possui faixas de CEP cadastradas') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('56'), TRIM('Nosso numero no correspondente nao foi informado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('57'), TRIM('Remessa contendo duas instrucoes incompativeis – nao protestar e dias de protesto ou prazo para protesto invalido.') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('58'), TRIM('Entradas Rejeitadas – Reprovado no Represamento para Analise') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('60'), TRIM('CNPJ/CPF do sacado invalido – titulo recusado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('87'), TRIM('Excede Prazo maximo entre emissao e vencimento') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('99'), TRIM('Titulo nao acatado pelo banco – entrar em contato Gerente da conta') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('AA'), TRIM('Servico de Cobranca invalido') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('AB'), TRIM('Nossa Carteira invalida') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('AE'), TRIM('Titulo nao possui abatimento') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('AI'), TRIM('Nossa Cobranca invalida') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('AJ'), TRIM('Modalidade com bancos correspondentes invalida') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('AL'), TRIM('Sacado impedido de entrar nesta cobranca') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('AU'), TRIM('Data de ocorrencia invalida') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('AV'), TRIM('Valor de tarifa de cobranca invalida') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('AX'), TRIM('Titulo em pagamento parcial') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('BC'), TRIM('Analise gerencial-sacado invalido p/operacao credito') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('BD'), TRIM('Analise gerencial-sacado inadimplente') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('BE'), TRIM('Analise gerencial-sacado difere do exigido') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('BF'), TRIM('Analise gerencial-vencto excede vencto da operacao de credito') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('BG'), TRIM('Analise gerencial-sacado com baixa liquidez') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('BH'), TRIM('Analise gerencial-sacado excede concentracao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('CC'), TRIM('Valor de iof incompativel com a especie documento') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('CD'), TRIM('Efetivacao de protesto sem agenda valida') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('CE'), TRIM('Titulo nao aceito - pessoa fisica') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('CF'), TRIM('Excede prazo maximo da entrada ao vencimento') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('CG'), TRIM('Titulo nao aceito – por analise gerencial') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('CH'), TRIM('Titulo em espera – em analise pelo banco') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('CJ'), TRIM('Analise gerencial-vencto do titulo abaixo przcurto') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('CK'), TRIM('Analise gerencial-vencto do titulo abaixo przlongo') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('CS'), TRIM('Titulo rejeitado pela checagem de duplicatas') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('DA'), TRIM('Analise gerencial – Entrada de Titulo Descontado com limite cancelado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('DB'), TRIM('Analise gerencial – Entrada de Titulo Descontado com limite vencido') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('DC'), TRIM('Analise gerencial - cedente com limite cancelado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('DD'), TRIM('Analise gerencial – cedente e sacado e teve seu limite cancelado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('DE'), TRIM('Analise gerencial - apontamento no Serasa') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('DG'), TRIM('Endereco sacador/avalista nao informado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('DH'), TRIM('Cep do sacador/avalista nao informado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('DI'), TRIM('Cidade do sacador/avalista nao informado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('DJ'), TRIM('Estado do sacador/avalista invalido ou n informado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('DM'), TRIM('Cliente sem Codigo de Flash cadastrado no cobrador') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('DN'), TRIM('Titulo Descontado com Prazo ZERO – Recusado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('DP'), TRIM('Data de Referencia menor que a Data de Emissao do Titulo') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('DT'), TRIM('Nosso Numero do Correspondente nao deve ser informado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('03')::integer, TRIM('EB'), TRIM('HSBC nao aceita endereco de sacado com mais de 38 caracteres') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('15')::integer, TRIM('05'), TRIM('Solicitacao de baixa para titulo ja baixado ou liquidado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('15')::integer, TRIM('06'), TRIM('Solicitacao de baixa para titulo nao registrado no sistema') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('15')::integer, TRIM('08'), TRIM('Solicitacao de baixa para titulo em float') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('16')::integer, TRIM('04'), TRIM('Data de Vencimento nao numerica ou invalida') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('16')::integer, TRIM('05'), TRIM('Data de vencimento invalida ou fora do prazo minimo') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('16')::integer, TRIM('14'), TRIM('Registro em duplicidade') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('16')::integer, TRIM('19'), TRIM('Data de desconto invalida ou maior que a data de vencimento') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('16')::integer, TRIM('20'), TRIM('Campo livre informado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('16')::integer, TRIM('21'), TRIM('Titulo nao registrado no sistema') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('16')::integer, TRIM('22'), TRIM('Titulo baixada ou liquidado') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('16')::integer, TRIM('26'), TRIM('Especie de documento invalida') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('16')::integer, TRIM('27'), TRIM('Instrucao nao aceita, por nao ter sido emitida ordem de protesto ao cartorio') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('16')::integer, TRIM('28'), TRIM('Titulo tem instrucao de cartorio ativa') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('16')::integer, TRIM('29'), TRIM('Titulo nao tem instrucao de cartorio ativa') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('16')::integer, TRIM('30'), TRIM('Existe instrucao de nao protestar, ativa para o titulo') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('16')::integer, TRIM('36'), TRIM('Valor de permanencia (mora) nao numerico') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('16')::integer, TRIM('37'), TRIM('Titulo Descontado Instrucao nao permitida para a carteira') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('16')::integer, TRIM('38'), TRIM('Valor do abatimento nao numerico ou maior que a soma do valor do titulo + permanencia + multa') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('16')::integer, TRIM('39'), TRIM('Titulo em cartorio') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('16')::integer, TRIM('40'), TRIM('Instrucao recusada - cobranca vinculada / caucionada') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('16')::integer, TRIM('44'), TRIM('Titulo zerado ou em brancos ou nao numerico na remessa') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('16')::integer, TRIM('99'), TRIM('Ocorrencia desconhecida na remessa') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('01')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('02')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('05')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('06')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('08')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('09')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('10')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('12')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('13')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('14')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('19')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('20')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('22')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('23')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('24')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('28')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('40')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('43')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('96')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('97')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('98')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial); INSERT INTO rcb_dup_evento (SELECT codigo, TRIM('707')::integer, TRIM('99')::integer, TRIM(' 00'), TRIM('Sem definicao') FROM bas_filial);