Árvore de páginas

Versões comparadas

Chave

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

...

Contas a Pagar

Arquivo de Remessa

Obs.: - A coluna "Valor para Edição" quando preenchida, conterá os valores disponíveis para edição do "Conteúdo da linha". Quando a linha coluna "Valor para Edição" estiver vazia, o sistema não permitirá edição do respectivo "Conteúdo da linha".

Controle
Linhas
Controle
Detalhes
Controle
Sequencial
Posição
Inicial
Posição
Final
DecimalInformação da linhaConteudo Conteúdo da linhaValor para edição 
0H
      
HEADER DE ARQUIVO                       .T.                                                                                                                                                                  
0T
      
TRAILER DE ARQUIVO                      .T.                                                                                                                                                                  
1D1      
DETALHE SEGMENTO A                      IIF(SEA->EA_MODELO $ "01|02|03|04|10|41|43",.T.,.F.)                                                                                                                 
1D2      
DETALHE SEGMENTO B                      IIF(SEA->EA_MODELO $ "01|02|03|04|10|41|43",.T.,.F.)                                                                                                                 
1H
      
HEADER DE LOTE - A/B                    IIF(SEA->EA_MODELO $ "01|02|03|04|10|41|43",.T.,.F.)                                                                                                                 
1T
      
TRAILER DE LOTE - A/B                   IIF(SEA->EA_MODELO $ "01|02|03|04|10|41|43",.T.,.F.)                                                                                                                 
2D1      
DETALHE SEGMENTO J                      IIF(SEA->EA_MODELO $ "31",.T.,.F.)                                                                                                                                   
2H
      
HEADER DE LOTE - J                      IIF(SEA->EA_MODELO $ "31",.T.,.F.)                                                                                                                                   
2T
      
TRAILER DE LOTE J                       IIF(SEA->EA_MODELO $ "31",.T.,.F.)                                                                                                                                   
0H
130CODIGO DO BANCO                         1                              
0H
470LOTE DE SERVICO                         0                              
0H
880TIPO REGISTRO                           0                              
0H
9170USO EXCL CNAB                           SPACE(9)                                                                                                                                                             
0H
18180TP INSC EMPRESA                         IIF(SM0->M0_TPINSC == 3,"1","2")                                                                                                                                     
0H
19320NRO INSC EMPRES                         PADL(ALLTRIM(SM0->M0_CGC),14,"0")                                                                                                                                    
0H
33410NRO CONV BANCO                          PADL(ALLTRIM(SEE->EE_CODEMP),9,"0")                                                                                                                                  
0H
42450COB CEDENTE BB                          126                              
0H
46500NRO VAR COB BB                          SPACE(5)                                                                                                                                                             
0H
51520RESERVADO                               SPACE(2)                                                                                                                                                             
0H
53570AG MANT CONTA                           PADL(ALLTRIM(SEA->EA_AGEDEP),5,"0")                                                                                                                                  
0H
58580DV AGENCIA                              CNABDVAG()                                                                                                                                                           
0H
59700NRO CTA CORRENT                         PADL(ALLTRIM(SEA->EA_NUMCON),12,"0")                                                                                                                                 
0H
71710DV CONTA                                CNABDVCC()                                                                                                                                                           
0H
72720DV AGEN CONTA                           SPACE(1)                                                                                                                                                             
0H
731020NOME EMPRESA                            PADR(ALLTRIM(SM0->M0_NOMECOM),30,"")                                                                                                                                 
0H
1031320NOME BANCO                              PADR("BANCO DO BRASIL S.A.",30,"")                                                                                                                                   
0H
1331420USO EXCL CNAB                           SPACE(10)                                                                                                                                                            
0H
1431430COD REMESSA                             1                              
0H
1441510DT GER ARQUIVO                          GRAVADATA(DDATABASE,.F.,5)                                                                                                             {"DATE()","DDATABASE"}        
0H
1521570HR GER ARQUIVO                          STRTRAN(TIME(),":","")                                                                                                                                               
0H
1581630NRO SEQ ARQUIVO                         PADL(SEE->EE_ULTDSK,6,"0")                                                                                                                                           
0H
1641660NRO VERS ARQUIV                         83                              
0H
1671710DENSID GRAVACAO                         SPACE(05)                                                                                                                                                            
0H
1721910USO BANCO                               SPACE(20)                                                                                                                                                            
0H
1922110USO EMPRESA                             SPACE(20)                                                                                                                                                            
0H
2122400USO EXCLU CNAB                          SPACE(29)                                                                                                                                                            
1D1130CODIGO BANCO                            1                              
1D1470LOTE DE SERVICO                         1                              
1D1880TIPO REGISTRO                           3                              
1D19130NRO SEQ LOTE                            PADL(INT(INCREMENTA()-1),5,"0")                                                                                                                                      
1D114140COD SEG DETALHE                         A                                                                                                                                                                  
1D115150TIPO MOVIMENTO                          0                              
1D116170COD MOV REMESSA                         0                              
1D118200COD CAMARA CENT                         IIF(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 FAVOREC                         PADL(ALLTRIM(SA2->A2_AGENCIA),5,"0")                                                                                                                                 
1D129290DV AGENCIA                              SA2->A2_DVAGE                                                                                                                                                        
1D130410CTA CORR FAVORE                         PADR(ALLTRIM(SA2->A2_NUMCON),12,"0")                                                                                                                                 
1D142420DV CTA CORRENTE                         SA2->A2_DVCTA                                                                                                                                                        
1D143430DV AGEN CONTA                           SPACE(1)                                                                                                                                                             
1D144730NOME FAVORECIDO                         PADR(ALLTRIM(SA2->A2_NOME),30,"")                                                                                                      {"A2_NREDUZ","A2_NOME"}       
1D174930NRO DOC EMPRESA                                                                                                                                                                                              
1D1941010DT PAGAMENTO                            GRAVADATA(SE2->E2_VENCREA,.F.,5)                                                                                                       {"E2_VENCTO","E2_EMISSAO","E2_
1D11021040TIPO MOEDA                              BRL                                                                                                                                                                
1D11051195QTD MOEDA                               REPLICATE("0",5)                                                                                                                                                     
1D11201342VALOR PAGTO                             PADL(SE2->(E2_SALDO+E2_SDACRESC-E2_SDDECRESC)*100,15,"0")                                                                                                            
1D11351540NRO DOC ATR BCO                         SPACE(20)                                                                                                                                                            
1D11551620DT REAL PAGTO                           REPLICATE("0",8)                                                                                                                                                     
1D11631772VLR REAL PAGTO                          REPLICATE("0",15)                                                                                                                                                    
1D11782170OUTRAS INFORMAC                         REPLICATE("0",40)                                                                                                                                                    
1D12182190COMPL TIPO SERV                                                                                                                                                                                              
1D12202240COD FINAL TED                                                                                                                                                                                                
1D12252260COMPL FINAL PAG                                                                                                                                                                                              
1D12272290USO EXCL CNAB                           SPACE(3)                                                                                                                                                             
1D12302300AVISO FAVORECID                         0                              
1D12312400OCORRENCIAS                             SPACE(10)                                                                                                                                                            
1D2130COD BANCO                               1                              
1D2470LOTE SERVICO                            1                              
1D2880TIPO REGISTRO                           3                              
1D29130NRO SEQ REG LT                          PADL(INT(INCREMENTA()-1),5,"0")                                                                                                                                      
1D214140COD SEG REG DET                         B                                                                                                                                                                  
1D215170USO EXCL CNAB                           SPACE(3)                                                                                                                                                             
1D218180TIPO INSCRICAO                          IIF(SA2->A2_TIPO == "J","2","1")                                                                                                                                     
1D219320NRO INSCRICAO                           PADR((ALLTRIM(SA2->A2_CGC)),14,"0")                                                                                                                                  
1D233620ENDERECO                                PADR(ALLTRIM(SA2->A2_END),30,"")                                                                                                                                     
1D263670NUMERO                                  IIF(EMPTY(SA2->A2_NR_END),REPLICATE("0",5),PADL(ALLTRIM(SA2->A2_NR_END),5,"0"))                                                                                      
1D268820COMPLEMENTO                             SPACE(15)                                                                                                                                                            
1D283970BAIRRO                                  PADR(ALLTRIM(SA2->A2_BAIRRO),15,"")                                                                                                                                  
1D2981170CIDADE                                  PADR(ALLTRIM(SA2->A2_MUN),20,"")                                                                                                                                     
1D21181250CEP                                     PADL(ALLTRIM(SA2->A2_CEP),8,"0")                                                                                                                                     
1D21261270ESTADO                                  PADR(ALLTRIM(SA2->A2_EST),2,"")                                                                                                                                      
1D21281350DATA VENCIMENTO                         GRAVADATA(SE2->E2_VENCTO,.F.,5)                                                                                                                                      
1D21361502VALOR DOCUMENTO                         PADL(SE2->(E2_SALDO)*100,15,"0")                                                                                                                                     
1D21511652VALOR ABATIMENT                         PADL(SE2->(E2_SDDECRESC)*100,15,"0")                                                                                                                                 
1D21661802VALOR DESCONTO                          REPLICATE("0",15)                                                                                                                                                    
1D21811952VALOR MORA                              PADL(SE2->(E2_SDACRESC)*100,15,"0")                                                                                                                                  
1D21962102MULTA                                   REPLICATE("0",15)                                                                                                                                                    
1D22112250COD DOC FAVOREC                         SPACE(15)                                                                                                                                                            
1D22262260AVISO FAVORECID                         0                              
1D22272320USO EXCL SIAPE                          SPACE(6)                                                                                                                                                             
1D22332400USO EXCL CNAB                           SPACE(8)                                                                                                                                                             
1H
130COD BANCO                               1                              
1H
470LOTE SERVICO                            1                              
1H
880TIPO REGISTRO                           1                              
1H
990TIPO OPERACAO                           C                                                                                                                                                                  
1H
10110TIPO SERVICO                            20                              
1H
12130FORMA LANCTO                            1                              
1H
14160NRO VERS LOTE                           42                              
1H
17170USO EXCL CNAB                           SPACE(1)                                                                                                                                                             
1H
18180TIPO INSC EMPRE                         IIF(SM0->M0_TPINSC == 3,"1","2")                                                                                                                                     
1H
19320NRO INSC EMPRES                         PADL(ALLTRIM(SM0->M0_CGC),14,"0")                                                                                                                                    
1H
33410CONVENIO                                PADL(ALLTRIM(SEE->EE_CODEMP),9,"0")                                                                                                                                  
1H
42450COB CEDENTE BB                          126                              
1H
46500NRO CART COB BB                         SPACE(5)                                                                                                                                                             
1H
51520IDEN REMES TEST                         TS                                                                                                                                                                 
1H
53570AGENCIA MANTENE                         PADL(ALLTRIM(SEA->EA_AGEDEP),5,"0")                                                                                                                                  
1H
58580DV AGENCIA                              CNABDVAG()                                                                                                                                                           
1H
59700NRO CTA CORRENT                         PADL(ALLTRIM(SEA->EA_NUMCON),12,"0")                                                                                                                                 
1H
71710DV CTA CORRENTE                         CNABDVCC()                                                                                                                                                           
1H
72720DV AGE CONTA                            SPACE(1)                                                                                                                                                             
1H
731020NOME DA EMPRESA                         PADR(ALLTRIM(SM0->M0_NOMECOM),30,"")                                                                                                                                 
1H
1031420MENSAGEM 1                              SPACE(40)                                                                                                                                                            
1H
1431720ENDERECO                                PADR(IIF(EMPTY(SM0->M0_ENDENT),SM0->M0_ENDENT,SM0->M0_ENDENT),30,"")                                                                                                 
1H
1731770NUMERO                                  REPLICATE("0",5)                                                                                                                                                     
1H
1781920COMPLEMENTO                             PADR(ALLTRIM(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
2232300USO EXCL CNAB                           SPACE(8)                                                                                                                                                             
1H
2312400OCORRENCIAS                             SPACE(10)                                                                                                                                                            
1T
130COD BCO COMPENS                         1                              
1T
470LOTE SERVICO                            1                              
1T
880TIPO REGISTRO                           5                              
1T
9170USO EXCL CNAB                           SPACE(09)                                                                                                                                                            
1T
18230QTDE REG LOTES                          IIF(SEA->EA_MODELO $ "01/03/41/43",PADL((NTOTCNAB2*2)+2,6,"0"),PADL((NTOTCNAB2+2),6,"0"))                                                                            
1T
24412SOMAT VALORES                           PADL(SOMAVALOR(),18,"0")                                                                                                                                             
1T
42595SOMAT QTD MOEDA                         REPLICATE("0",18)                                                                                                                                                    
1T
60650NRO AVISO DEBIT                         REPLICATE("0",6)                                                                                                                                                     
1T
662300USO EXCL CNAB                           SPACE(165)                                                                                                                                                           
1T
2312400OCORRENCIAS                             SPACE(10)                                                                                                                                                            
2D1130COD BANCO                               1                              
2D1470LOTE SERVICO                            1                              
2D1880CODIGO REGISTRO                         3                              
2D19130NSR                                     PADL(INT(INCREMENTA()-1),5,"0")                                                                                                                                      
2D114140CODIGO SEGMENTO                         J                                                                                                                                                                  
2D115150TIPO MOVIMENTO                          0                              
2D116170CODIGO MOVIMENT                         0                              
2D118610CODIGO BARRAS                           SUBSTR(SE2->E2_CODBAR,1,44)                                                                                                                                          
2D162910NOME CEDENTE                            PADR(ALLTRIM(SA2->A2_NOME),30,"")                                                                                                                                    
2D192990DATA VENCIMENTO                         GRAVADATA(SE2-E2_VENCTO,.F.,5)                                                                                                                                       
2D11001142VALOR TITULO                            PADL(SE2->(E2_SALDO)*100,15,"0")                                                                                                                                     
2D11151292VLR DESC ABATIM                         PADL(SE2->(E2_SDDECRESC)*100,15,"0")                                                                                                                                 
2D11301443VLR MORA MULTA                          PADL(SE2->(E2_SDACRESC)*100,16,"0")                                                                                                                                  
2D11451520DATA PAGAMENTO                          GRAVADATA(SE2->E2_VENCREA,.F.,5)                                                                                                       {"E2_VENCTO","E2_EMISSAO","E2_
2D11531672VALOR PAGAMENTO                         PADL(SE2->(E2_SALDO+E2_SDACRESC-E2_SDDECRESC)*100,15,"0")                                                                                                            
2D11681825QTD MOEDA                               REPLICATE("0",15)                                                                                                                                                    
2D11832020NRO ATRIB EMPRE                         PADR(ALLTRIM(SE2->E2_IDCNAB),20,"")                                                                                                                                  
2D12032220NRO ATRIB BANCO                         REPLICATE("0",20)                                                                                                                                                    
2D12232240CODIGO MOEDA                            9                              
2D12252300USO EXCL CNAB                           SPACE(6)                                                                                                                                                             
2D12312400OCORRENCIAS                             SPACE(10)                                                                                                                                                            
2H
130COD BANCO                               1                              
2H
470LOTE SERVICO                            1                              
2H
880TIPO REGISTRO                           1                              
2H
990TIPO OPERACAO                           C                                                                                                                                                                  
2H
10110TIPO SERVICO                            20                              
2H
12130FORMA LACTO                                                                                                                                                                                                  
2H
14160NRO VERSAO  LOT                         30                              
2H
17170USO EXCL CNAB                           SPACE(1)                                                                                                                                                             
2H
18180TIPO INSC BENEF                         IIF(SM0->M0_TPINSC== 3,"1","2")                                                                                                                                      
2H
19320NRO INSC BENEF                          PADL(ALLTRIM(SM0->M0_CGC),14,"0")                                                                                                                                    
2H
33410CODIGO BENEF                            PADL(ALLTRIM(SEE->EE_CODEMP),9,"0")                                                                                                                                  
2H
42450TIPO COMPROMISS                         126                              
2H
46500COD COMPROMISS                          SPACE(5)                                                                                                                                                             
2H
51520USO EXCL CNAB                           TS                                                                                                                                                                 
2H
53570AGENCIA MANTENE                         PADL(ALLTRIM(SEA->EA_AGEDEP),5,"0")                                                                                                                                  
2H
58580DV AGENCIA                              CNABDVAG()                                                                                                                                                           
2H
59700NRO CTA CORRENT                         PADL(ALLTRIM(SEA->EA_NUMCON),12,"0")                                                                                                                                 
2H
71710DV CTA CORRENTE                         CNABDVCC()                                                                                                                                                           
2H
72720DV AGE CONTA                            SPACE(1)                                                                                                                                                             
2H
731020NOME DA EMPRESA                         PADR(ALLTRIM(SM0->M0_NOMECOM),30,"")                                                                                                                                 
2H
1031420MENSAGEM 1                              SPACE(40)                                                                                                                                                            
2H
1431720ENDERECO                                PADR(IIF(EMPTY(SM0->M0_ENDENT),SM0->M0_ENDENT,SM0->M0_ENDENT),30,"")                                                                                                 
2H
1731770NUMERO                                  REPLICATE("0",5)                                                                                                                                                     
2H
1781920COMPLEMENTO                             PADR(ALLTRIM(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
2232300USO EXCL CNAB                           SPACE(8)                                                                                                                                                             
2H
2312400OCORRENCIAS                             SPACE(10)                                                                                                                                                            
2T
130COD BCO COMPENS                         1                              
2T
470LOTE SERVICO                            1                              
2T
880TIPO REGISTRO                           5                              
2T
9170USO EXCL CNAB                           SPACE(09)                                                                                                                                                            
2T
18230QTDE REG LOTES                          PADL((NTOTCNAB2*2)+2,6,"0")                                                                                                                                          
2T
24412SOMAT VALORES                           PADL(SOMAVALOR(),18,"0")                                                                                                                                             
2T
42595SOMAT QTD MOEDA                         REPLICATE("0",18)                                                                                                                                                    
2T
60650NRO AVISO DEBIT                         REPLICATE("0",6)                                                                                                                                                     
2T
662300USO EXCL CNAB                           SPACE(165)                                                                                                                                                           
2T
2312400OCORRENCIAS                             SPACE(10)                                                                                                                                                            
0T
130COD BANCO                               1                              
0T
470LOTE SERVICO                            9999                              
0T
880TIPO REGISTRO                           9                              
0T
9170USO EXCL CNAB                           SPACE(9)                                                                                                                                                             
0T
18230QTDE LOTES ARQ                          1                              
0T
24290QTDE REGISTROS                          PADL((NTOTCNAB2*3)+4,6,"0")                                                                                                                                          
0T
30350QTDE CONTAS                             REPLICATE("0",.6)                                                                                                                                                    
0T
362400USO EXCL CNAB                           SPACE(205)