Árvore de páginas

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.

237 - Banco Bradesco

...

- Contas a Pagar

...

- Arquivo de Remessa

...


Aviso
titleImportante

A coluna "

...

Opções de Edição"

...

contém as lista de possíveis valores para edição da expressão do "Conteúdo

...

". Os campos que não possuem listas de edição, não permitem edição no processo de download dos modelos.

Controle
Linhas
Controle
Detalhes
Controle
Sequencial
Posição
Inicial
Posição
Final
DecimalInformação da LinhaConteúdo da LinhaValor Para Opções de edição
0H
      
HEADER DE ARQUIVO.T.                                                                                                                                                                                                                                        
0T
      
TRAILLER ARQUIVO.T.                                                                                                                                                                                                                                        
1D1      
DETALHE SEGMENTO AIIF(SEA->EA_MODELO $ "01/03/05/10/41/43",.T.,.F.)                                                                                                                                                                                          
1D2      
DETALHE SEGMENTO B IIF(SEA->EA_MODELO $ "01/03/05/10/41/43",.T.,.F.)                                                                                                                                                                                          
1H
      
HEADER DE LOTE - A / BIIF(SEA->EA_MODELO $ "01/03/05/10/41/43",.T.,.F.)                                                                                                                                                                                          
1T
      
TRAILLER DE LOTE - A / BIIF(SEA->EA_MODELO $ "01/03/05/10/41/43",.T.,.F.)                                                                                                                                                                                          
2D1      
DETALHE SEGMENTO JIIF(SEA->EA_MODELO $ "30/31", .T.,.F.)                                                                                                                                                                                                     
2D2      
DETALHE SEGMENTO J-52IIF(SEA->EA_MODELO $ "30|31" .AND. SE2->E2_SALDO >= GETMV(MV_PAGJ52),.T.,.F.)                                                                                                    
2H
      
HEADER DE LOTE - J / J52IIF(SEA->EA_MODELO $ "30/31", .T.,.F.)                                                                                                                                                                                                     
2T
      
TRAILLER DE LOTE - J / J52IIF(SEA->EA_MODELO $ "30/31", .T.,.F.)                                                                                                                                                                                                     
9T
130COD BANCO                               237                                                                                                    
9T
470LOTE SERVICO                            9999                                                                                                    
9T
880TIPO REGISTRO                           9                                                                                                    
9T
9170USO EXCL CNAB                           SPACE(9)                                                                                                                                                                                                                                   
9T
18230QTD LOTES ARQUI                                                                                                                                                                                                                                                                    
9T
24290QTD REG ARQUIVO                                                                                                                                                                                                                                           
9T
30354QTD CTAS CONCIL                                                                                                                                                                                                                                           
9T
362400USO EXCL CNAB                           SPACE(205)                                                                                                                                                                                                                                 
1H
130COD BANCO                               237                                                                                                    
1H
470LOTE SERVICO                            1                                                                                                    
1H
880TIPO REGISTRO                           1                                                                                                    
1H
990TIPO OPERACAO                           C                                                                                                                                                                                                                                        
1H
10110TIPO SERVICO                                                                                                                                                                                                                                                                       
1H
12130FORMA LANCAM                                                                                                                                                                                                                                                                       
1H
14160NUM VERS LOTE                           45                                                                                                    
1H
17170USO EXCL CNAB                           SPACE(1)                                                                                                                                                                                                                                   
1H
18180TP INSC EMPRESAIIF(SM0->M0_TPINSC == 3,"1","2")                                                                                                                                                                                                           
1H
19320NUM INSC EMP                            PADL(ALLTRIM(SM0->M0_CGC),14,"0")                                                                                                                                                                                                           
1H
33520CONVENIO                                PADR(ALLTRIM(SEE->EE_CODEMP),20,"")                                                                                                                                                                                                        
1H
53570AG MANT CC                              PADL(ALLTRIM(SEA->EA_AGEDEP),5,"0")                                                                                                                                                                                                         
1H
58580DV AGENCIA                              CNABDVAG()                                                                                                                                                                                                                                 
1H
59700NRO CTA CORRENTPADL(ALLTRIM(SEA->EA_NUMCON),12,"0")                                                                                                    
1H
71720DV CTA CORRENTECNABDVCC()                                                                                                                                                                                                                                 
1H
731020NOME EMPRESAPADR(ALLTRIM(SM0->M0_NOMECOM),30,"")                                                                                                    
1H
1031420MENSAGEM                                SPACE(40)                                                                                                                                                                                                                                  
1H
1431720ENDERECO                                PADR(IIF(EMPTY(SM0->M0_ENDENT),SM0->M0_ENDCOB,SM0->M0_ENDENT),30,"")                                                                                                    
1H
1731770NUMERO                                  REPLICATE("0",5)                                                                                                                                                                                                                           
1H
1781920COMPLEMENTO                             PADR(SM0->M0_COMPENT,15,"")                                                                                                                                                                                                                 
1H
1932120CIDADE                                  PADR(IIF(EMPTY(SM0->M0_CIDENT),SM0->M0_CIDCOB,SM0->M0_CIDENT),20,"")                                                                                                    
1H
2132200CEP                                     PADR(IIF(EMPTY(SM0->M0_CEPENT),SM0->M0_CEPCOB,SM0->M0_CEPENT),8,"0")                                                                                                    
1H
2212220ESTADO                                  PADR(IIF(EMPTY(SM0->M0_ESTENT),SM0->M0_ESTCOB,SM0->M0_ESTENT),2,"")                                                                                                    
1H
2232240IND FOR PGT SER                         1                                                                                                    
1H
2252300USO EXCL CNAB                           SPACE(6)                                                                                                                                                                                                                                   
1H
2312400OCORRENCIAS                                                                                                                                                                                                                                                                        
1D2130COD BANCO                               237                                                                                                    
1D2470LOTE SERVICO                            1                                                                                                    
1D2880TIPO REGISTRO                           3                                                                                                    
1D29130NRO SEQ LOTE                            PADL(INT(INCREMENTA()-1),5,"0")                                                                                                                                                                                                            
1D214140COD SEG DETALHEB                                                                                                                                                                                                                                        
1D215170USO EXCL CNAB                           SPACE(3)                                                                                                                                                                                                                                   
1D218180TP INSC FAVOR                           IIF(SA2->A2_TIPO == "J","2","1")                                                                                                                                                                                                           
1D219320NRO INSC FAVOR                          PADL(ALLTRIM(SA2->A2_CGC),14,"0")                                                                                                                                                                                                          
1D233620LOGRAD FAVORECPADR(ALLTRIM(SA2->A2_END),30,"")                                                                                                                                                                                                            
1D263670NRO LOCAL                               REPLICATE("0",5)                                                                                                                                                                                                                           
1D268820COMPLEMENTO                             PADR(ALLTRIM(SA2->A2_COMPLEM),15,"")                                                                                                    
1D283970BAIRRO FAVORECPADR(ALLTRIM(SA2->A2_BAIRRO),15,"")                                                                                                                                                                                                        
1D2981170CIDADE FAVORECPADR(ALLTRIM(SA2->A2_MUN),20,"")                                                                                                                                                                                                           
1D21181250CEP FAVOREC                             PADL(ALLTRIM(SA2->A2_CEP),8,"0")                                                                                                                                                                                                            
1D21261270FAV ESTADO                              SA2->A2_EST                                                                                                                                                                                                                                
1D21281350DATA VENCIMENTOGRAVADATA(SE2->E2_VENCTO,.F.,5)                                                                                                         {"
  • E2_VENCTO
","
  • E2_EMISSAO
","
  • E2_
VENCREA"}                                                             
  • VENCREA                                                           
1D21361502VALOR                                   PADL(SE2->(E2_SALDO)*100,15,"0")                                                                                                       {"
  • E2_VALOR
","
  • E2_SALDO    
  • E2_
SALDO"}                                                                             
  • VLCRUZ                                                                         
1D21511652VLR ABATIMENTO                          PADL(SE2->(E2_SDDECRESC)*100,15,"0")                                                                                                                                                                                                       
1D21661802VLR  DESCONTO                           REPLICATE("0",15)                                                                                                                                                                                                                          
1D21811952VLR MORA                                PADL(SE2->(E2_SDACRESC)*100,15,"0")                                                                                                                                                                                                        
1D21962102VLR MULTA                               REPLICATE("0",15)                                                                                                                                                                                                                          
1D22112250COD DCTO FAVOREPADL(ALLTRIM(SE2->E2_IDCNAB),15,"")                                                                                                                                                                                                        
1D22262260AVISO FAVOREC                           0                                                                                                    
1D22272320USO EXCL SIAPE                          REPLICATE("0",6)                                                                                                                                                                                                                           
1D22332400COD ISPB                                REPLICATE("0",8)                                                                                                                                                                                                                           
1T
130COD BANCO                               237                                                                                                    
1T
470LOTE SERVICO                            1                                                                                                    
1T
880TIPO REGISTRO                           5                                                                                                    
1T
9170USO EXCL CNAB                           SPACE(9)                                                                                                                                                                                                                                   
1T
18230QUANT DE REG                            IIF(SEA->EA_MODELO $ "01/03/41/43",PADL((NTOTCNAB2*2)+2,6,"0"),PADL((NTOTCNAB2+2),6,"0"))                                                                                                    
1T
24412SOMAT VALORESPADL(SOMAVALOR(),18,"0")                                                                                                                                                                                                                   
1T
42595SOMAT QTD MOEDREPLICATE("0",18)                                                                                                                                                                                                                          
1T
60650NRO AVISO DEBIT                         REPLICATE("0",6)                                                                                                                                                                                                                           
1T
662300USO EXCL CNAB                           SPACE(165)                                                                                                                                                                                                                                 
1T
2312400OCORRENCIAS                             SPACE(10)                                                                                                                                                                                                                                  
2H
130COD BANCO                               237                                                                                                    
2H
470LOTE SERVICO                            1                                                                                                    
2H
880TIPO REGISTRO                           1                                                                                                    
2H
990TIPO OPERACAO                           C                                                                                                                                                                                                                                        
2H
10110TIPO SERVICO                                                                                                                                                                                                                                                                       
2H
12130FORMA LANCAM                                                                                                                                                                                                                                                                       
2H
14160NUM VERS LOTE                           40                                                                                                    
2H
17170USO EXCL CNAB                           SPACE(1)                                                                                                                                                                                                                                   
2H
18180TP INSC EMPRESAIIF(SM0->M0_TPINSC == 3,"1","2")                                                                                                                                                                                                           
2H
19320NUM INSC EMP                            PADL(ALLTRIM(SM0->M0_CGC),14,"0")                                                                                                                                                                                                          
2H
33520CONVENIO                                PADR(ALLTRIM(SEE->EE_CODEMP),20,"")                                                                                                                                                                                                        
2H
53570AG MANT CC                              PADL(ALLTRIM(SEA->EA_AGEDEP),5,"0")                                                                                                                                                                                                        
2H
58580DV AGENCIA                              CNABDVAG()                                                                                                                                                                                                                                 
2H
59700NRO CTA CORRENTPADL(ALLTRIM(SEA->EA_NUMCON),12,"0")                                                                                                    
2H
71720DV CTA CORRENTECNABDVCC()                                                                                                                                                                                                                                 
2H
731020NOME EMPRESAPADR(ALLTRIM(SM0->M0_NOMECOM),30,"")                                                                                                    
2H
1031420MENSAGEM                                SPACE(40)                                                                                                                                                                                                                                  
2H
1431720ENDERECO                                PADR(IIF(EMPTY(SM0->M0_ENDENT),SM0->M0_ENDCOB,SM0->M0_ENDENT),30,"")                                                                                                    
2H
1731770NUMERO                                  REPLICATE("0",5)                                                                                                                                                                                                                           
2H
1781920COMPLEMENTO                             PADR(SM0->M0_COMPENT,15,"")                                                                                                                                                                                                                
2H
1932120CIDADE                                  PADR(IIF(EMPTY(SM0->M0_CIDENT),SM0->M0_CIDCOB,SM0->M0_CIDENT),20,"")                                                                                                    
2H
2132200CEP                                     PADR(IIF(EMPTY(SM0->M0_CEPENT),SM0->M0_CEPCOB,SM0->M0_CEPENT),8,"0")                                                                                                    
2H
2212220ESTADO                                  PADR(IIF(EMPTY(SM0->M0_ESTENT),SM0->M0_ESTCOB,SM0->M0_ESTENT),2,"")                                                                                                    
2H
2232300IND FOR PGT SER                         SPACE(8)                                                                                                                                                                                                                                   
2H
2312400OCORRENCIAS                                                                                                                                                                                                                                                                        
2D1130COD BANCO                               237                                                                                                    
2D1470LOTE SERVICO                            1                                                                                                    
2D1880TIPO REGISTRO                           3                                                                                                    
2D19130NUM SEQ REG LOTPADL(INT(INCREMENTA()-1),5,"0")                                                                                                                                                                                                            
2D114140COD SEG DETALHEJ                                                                                                                                                                                                                                        
2D115150TIPO MOVIMENTO                          0                                                                                                    
2D116170COD INST MOVIM                          0                                                                                                    
2D118610COD BARRAS                              SUBSTR(SE2->E2_CODBAR,1,44)                                                                                                                                                                                                                
2D162910NOME DO CEDENTEPADR(ALLTRIM(SA2->A2_NOME),30,"")                                                                                                      {"
  • A2_NREDUZ
","
  • A2_
NOME"}                                                                             
  • NOME                                                                             
2D192990DATA VENCIMENTOGRAVADATA(SE2->E2_VENCTO,.F.,5)                                                                                                         {"
  • E2_VENCTO
","
  • E2_EMISSAO
","
  • E2_
VENCREA"}                                                             
  • VENCREA                                                            
2D11001142VLR NOM TIT                             PADL(SE2->(E2_SALDO)*100,15,"0")                                                                                                       {"
  • E2_VALOR
","
  • E2_SALDO    
  • E2_
SALDO"}                                                                             
  • VLCRUZ
2D11151292VALOR DESCONTOPADL(SE2->E2_SDDECRE*100,15,"0")                                                                                                                                                                                                           
2D11301442VALOR JUROS                             PADL(SE2->E2_SDACRES*100,15,"0")                                                                                                                                                                                                           
2D11451520DATA PAGAMENTOGRAVADATA(SE2->E2_VENCREA,.F.,5)                                                                                                       {"
  • E2_VENCTO
","
  • E2_EMISSAO
","
  • E2_
VENCREA"}                                                             
  • VENCREA 
2D11531672VALOR PAGAMENTOPADL(SE2->(E2_SALDO+E2_SDACRESC-E2_SDDECRESC)*100,15,"0")                                                                                                    
2D11681825QTDE MOEDA                              REPLICATE("0",15)                                                                                                                                                                                                                          
2D11832020NRO DOC EMPRESAPADR(ALLTRIM(SE2->E2_IDCNAB),20,"")                                                                                                                                                                                                        
2D12032220NRO DOC BANCOPADR(ALLTRIM(SE2->E2_NUMBCO),20,"")                                                                                                                                                                                                        
2D12232240COD MOEDA                               9                                                                                                    
2D12252300USO EXCL CNAB                           SPACE(6)                                                                                                                                                                                                                                   
2D12312400OCORRENCIAS                             SPACE(10)                                                                                                                                                                                                                                  
2D2130COD BANCO                               237                                                                                                    
2D2470LOTE SERVICO                            1                                                                                                    
2D2880TIPO REGISTRO                           3                                                                                                    
2D29130NRO SEQ LOTE                            PADL(INT(INCREMENTA()-1),5,"0")                                                                                                                                                                                                            
2D214140COD SEG DETALHEJ                                                                                                                                                                                                                                        
2D215150USO EXCL CNAB                           SPACE(1)                                                                                                                                                                                                                                   
2D216170COD MOV REMESSA                                                                                                                                                                                                                                           
2D218190ID REGISTRO                             52                                                                                                    
2D220200TIPO INSC SACAD                         IIF(SM0->M0_TPINSC == 3,"1","2")                                                                                                                                                                                                           
2D221350NRO INSC SACADOPADL(ALLTRIM(SM0->M0_CGC),15,"0")                                                                                                                                                                                                          
2D236750NOME SACADO                             PADR(ALLTRIM(SM0->M0_NOMECOM),40,"")                                                                                                    
2D276760TIPO INSC CEDEN                         IIF(SA2->A2_TIPO == "J","2","1")                                                                                                                                                                                                           
2D277910NRO INSC CEDEN                          PADL(ALLTRIM(SA2->A2_CGC),15,"0")                                                                                                                                                                                                          
2D2921310NOME CEDENTE                            PADR(ALLTRIM(SA2->A2_NOME),40,"")                                                                                                      {"
  • A2_NREDUZ
","
  • A2_NOME
"}                                                                             
2D21321320TP INSC SACADORIIF(SA2->A2_TIPO == "J","2","1")                                                                                                                                                                                                           
2D21331470NRO INS SACADORPADL(ALLTRIM(SA2->A2_CGC),15,"0")                                                                                                                                                                                                          
2D21481870NOME SACADORPADR(ALLTRIM(SA2->A2_NOME),40,"")                                                                                                      {"
  • A2_NREDUZ
","
  • A2_NOME
"}                                                                             
2D21882400USO EXCL CNAB                           SPACE(53)                                                                                                                                                                                                                                  
2T
130COD BANCO                               237                                                                                                    
2T
470LOTE SERVICO                            1                                                                                                    
2T
880TIPO REGISTRO                           5                                                                                                    
2T
9170USO EXCL CNAB                           SPACE(9)                                                                                                                                                                                                                                   
2T
18230QUANT DE REG                            IIF(SEA->EA_MODELO $ "01/03/41/43",PADL((NTOTCNAB2*2)+2,6,"0"),PADL((NTOTCNAB2+2),6,"0"))                                                                                                    
2T
24412SOMAT VALORESPADL(SOMAVALOR(),18,"0")                                                                                                                                                                                                                   
2T
42595SOMAT QTD MOEDREPLICATE("0",18)                                                                                                                                                                                                                          
2T
60650NRO AVISO DEBIT                         REPLICATE("0",6)                                                                                                                                                                                                                           
2T
662300USO EXCL CNAB                           SPACE(165)                                                                                                                                                                                                                                 
2T
2312400OCORRENCIAS                             SPACE(10)                                                                                                                                                                                                                                  
0H
130COD DO BANCO                            237                                                                                                    
0H
470LOTE DE SERV                            0                                                                                                    
0H
880TIPO REGISTRO                           0                                                                                                    
0H
9170USO EXCL CNAB                           SPACE(9)                                                                                                                                                                                                                                   
0H
18180TP INSC EMPRESAIIF(SM0->M0_TPINSC == 3,"1","2")                                                                                                                                                                                                           
0H
19320NUM INSC EMPPADL(ALLTRIM(SM0->M0_CGC),14,"0")                                                                                                    
0H
33520COD CONVENIO BCPADR(ALLTRIM(SEE->EE_CODEMP),20,"")                                                                                                    
0H
53570AG MANT CONTAPADL(ALLTRIM(SEA->EA_AGEDEP),5,"0")                                                                                                    
0H
58580DV AGENCIA                              CNABDVAG()                                                                                                                                                                                                                                 
0H
59700NUM CTA CORREN PADL(ALLTRIM(SEA->EA_NUMCON),12,"0")                                                                                                    
0H
71720DV AGCONTA                              CNABDVCC()                                                                                                                                                                                                                                 
0H
731020NOME DA EMPRESAPADR(ALLTRIM(SM0->M0_NOMECOM),30,"")                                                                                                    
0H
1031320NOME BANCO                              PADR("BANCO BRADESCO SA",30,"")                                                                                                    
0H
1331420USO EXCL CNAB                           SPACE(10)                                                                                                                                                                                                                                  
0H
1431430CODIGO REMESSA1                                                                                                    
0H
1441510DT GERAC ARQ                            GRAVADATA(DDATABASE,.F.,5)                                                                                                             {"
  • DATE()
","DDATABASE"}                                                                              
  • DDATABASE                                                                             
0H
1521570HORA GR ARQ                             STRTRAN(TIME(),":","")                                                                                                                                                                                                                     
0H
1581630NUM SEQ ARQ                             PADL(SEE->EE_ULTDSK,6,"0")                                                                                                                                                                                                                 
0H
1641660VERSAO LAY-OUT                          89                                                                                                    
0H
1671710DENSID GRV ARQ                          REPLICATE("0",5)                                                                                                                                                                                                                           
0H
1721910RESERVADO BCOSPACE(20)                                                                                                                                                                                                                                  
0H
1922110RESERVADO EMP SPACE(20)                                                                                                                                                                                                                                  
0H
2122400USO EXCL CNAB                           SPACE(29)                                                                                                                                                                                                                                  
0T
130COD BANCO                               237                                                                                                    
0T
470LOTE SERV                               9999                                                                                                    
0T
880TP DE REG                               9                                                                                                    
0T
9170USO EXCL CNAB                           SPACE(9)                                                                                                                                                                                                                                   
0T
18230QUANT LOT ARQ                           1                                                                                                    
0T
24290QUANT REG ARQ                           IIF(SEA->EA_MODELO$ "01/03/41/43",(M->NTOTCNAB2*2)+4,M->NSEQ+4)                                                                                                    
0T
30350QTDE CTAS CONCREPLICATE("0",6)                                                                                                                                                                                                                           
0T
362400USO EXCL CNAB                           SPACE(205)                                                                                                                                                                                                                                 
1D1130COD BANCO                               237                                                                                                    
1D1470LOTE SERVICO                            1                                                                                                    
1D1880TIPO REGISTRO                           3                                                                                                    
1D19130NRO SEQ LOTE                            PADL(INT(INCREMENTA()-1),5,"0")                                                                                                                                                                                                            
1D114140COD SEG DETALHEA                                                                                                                                                                                                                                        
1D115150TIPO MOVIMENTO                          0                                                                                                    
1D116170COD INST MOVIME                         0                                                                                                    
1D118200COD CAM CENTRALIIF(SEA->EA_MODELO $ "03/41/43",(IIF(SEA->EA_MODELO = "03","700","018")) ,"000")                                                                                                    
1D121230COD BCO FAVOR                           PADL(ALLTRIM(SA2->A2_BANCO),3,"0")                                                                                                    
1D124280AGENCIA FAVOR                           PADL(ALLTRIM(SA2->A2_AGENCIA),5,"0")                                                                                                    
1D129290DV AGENCIA                              SA2->A2_DVAGE                                                                                                                                                                                                                              
1D130410CTA CORRENTE                            PADL(ALLTRIM(SA2->A2_NUMCON),12,"0")                                                                                                    
1D142430DV CONTA                                PADR(SA2->A2_DVCTA,2,"")                                                                                                                                                                                                                   
1D144730NOME FAVOR                              PADR(ALLTRIM(SA2->A2_NOME),30,""){"
  • A2_NREDUZ
","
  • A2_NOME
"}                                                                             
1D174930NUM DOC EMPRESPADR(ALLTRIM(SE2->E2_IDCNAB),20,"")                                                                                                    
1D1941010DATA PAGAMENTOGRAVADATA(SE2->E2_VENCREA,.F.,5){"
  • E2_VENCTO
","
  • E2_EMISSAO
","
  • E2_
VENCREA"}                                                             
  • VENCREA 
1D11021040TIPO DA MOEDA                           BRL                                                                                                                                                                                                                                      
1D11051195QUANT MOEDA                             REPLICATE("0",15)                                                                                                                                                                                                                          
1D11201342VLR PAGAMENTOPADL(SE2->(E2_SALDO+E2_SDACRESC-E2_SDDECRESC)*100,15,"0")                                                                                                    
1D11351540NRO DOC ATRI BC                         PADR(ALLTRIM(SE2->E2_NUMBCO),20,"")                                                                                                    
1D11551620DT REAL PGTO                            REPLICATE("0",8)                                                                                                                                                                                                                           
1D11631772VLR REAL PGTO                           REPLICATE("0",15)                                                                                                                                                                                                                          
1D11782170OUTRAS INFORMACSPACE(40)                                                                                                                                                                                                                                  
1D12182190COMP TP SERVICO7                                                                                                    
1D12202240COD FINAL TED                                                                                                                                                                                                                                                                      
1D12252260COMPL FINAL PAG                                                                                                                                                                                                                                                                    
1D12272290USO EXCL CNAB                           SPACE(03)                                                                                                                                                                                                                                  
1D12302300AVISO FAVOREC                           0                                                                                                    
1D12312400OCORRENCIAS                             SPACE(10)