Árvore de páginas

Versões comparadas

Chave

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

001 - Banco do Brasil

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 linhaConteúdo da linhaValor para edição 
0H
      
HEADER DE ARQUIVO.T.                              
0T
      
TRAILER DE ARQUIVO.T.                              
1D1      
DETALHE SEGMENTO AIIF(SEA->EA_MODELO $ "01|02|03|04|10|41|43",.T.,.F.)                              
1D2      
DETALHE SEGMENTO BIIF(SEA->EA_MODELO $ "01|02|03|04|10|41|43",.T.,.F.)                               
1H
      
HEADER DE LOTE - A/BIIF(SEA->EA_MODELO $ "01|02|03|04|10|41|43",.T.,.F.)                               
1T
      
TRAILER DE LOTE - A/BIIF(SEA->EA_MODELO $ "01|02|03|04|10|41|43",.T.,.F.)                              
2D1      
DETALHE SEGMENTO JIIF(SEA->EA_MODELO $ "31",.T.,.F.)                               
2H
      
HEADER DE LOTE - JIIF(SEA->EA_MODELO $ "31",.T.,.F.)                              
2T
      
TRAILER DE LOTE JIIF(SEA->EA_MODELO $ "31",.T.,.F.)                              
0H
130CODIGO DO BANCO1                              
0H
470LOTE DE SERVICO0                              
0H
880TIPO REGISTRO0                              
0H
9170USO EXCL CNABSPACE(9)                              
0H
18180TP INSC EMPRESAIIF(SM0->M0_TPINSC == 3,"1","2")                              
0H
19320NRO INSC EMPRESPADL(ALLTRIM(SM0->M0_CGC),14,"0")                              
0H
33410NRO CONV BANCOPADL(ALLTRIM(SEE->EE_CODEMP),9,"0")                              
0H
42450COB CEDENTE BB126                              
0H
46500NRO VAR COB BBSPACE(5)                                 
0H
51520RESERVADOSPACE(2)                               
0H
53570AG MANT CONTAPADL(ALLTRIM(SEA->EA_AGEDEP),5,"0")                              
0H
58580DV AGENCIACNABDVAG()                              
0H
59700NRO CTA CORRENTPADL(ALLTRIM(SEA->EA_NUMCON),12,"0")                              
0H
71710DV CONTACNABDVCC()                              
0H
72720DV AGEN CONTASPACE(1)                               
0H
731020NOME EMPRESAPADR(ALLTRIM(SM0->M0_NOMECOM),30,"")                               
0H
1031320NOME BANCOPADR("BANCO DO BRASIL S.A.",30,"")                              
0H
1331420USO EXCL CNABSPACE(10)                              
0H
1431430COD REMESSA1                              
0H
1441510DT GER ARQUIVOGRAVADATA(DDATABASE,.F.,5){"DATE()","DDATABASE"}        
0H
1521570HR GER ARQUIVOSTRTRAN(TIME(),":","")                               
0H
1581630NRO SEQ ARQUIVOPADL(SEE->EE_ULTDSK,6,"0")                               
0H
1641660NRO VERS ARQUIV83                              
0H
1671710DENSID GRAVACAOSPACE(05)                                
0H
1721910USO BANCOSPACE(20)                              
0H
1922110USO EMPRESASPACE(20)                              
0H
2122400USO EXCLU CNABSPACE(29)                              
1D1130CODIGO BANCO1                              
1D1470LOTE DE SERVICO1                              
1D1880TIPO REGISTRO3                              
1D19130NRO SEQ LOTEPADL(INT(INCREMENTA()-1),5,"0")                              
1D114140COD SEG DETALHE                              
1D115150TIPO MOVIMENTO0                              
1D116170COD MOV REMESSA0                              
1D118200COD CAMARA CENTIIF(SEA->EA_MODELO $ "03|41|43",(IIF(SEA->EA_MODELO=="03","700","018")),"000")                              
1D121230COD BCO FAVORPADL(ALLTRIM(SA2->A2_BANCO),3,"0")                              
1D124280AGENCIA FAVORECPADL(ALLTRIM(SA2->A2_AGENCIA),5,"0")                              
1D129290DV AGENCIASA2->A2_DVAGE                              
1D130410CTA CORR FAVOREPADR(ALLTRIM(SA2->A2_NUMCON),12,"0")                               
1D142420DV CTA CORRENTESA2->A2_DVCTA                                                                                                                                                        
1D143430DV AGEN CONTASPACE(1)                                                                                                                                                             
1D144730NOME FAVORECIDOPADR(ALLTRIM(SA2->A2_NOME),30,"") {"A2_NREDUZ","A2_NOME"}       
1D174930NRO DOC EMPRESA                                                                                                                                                                     
1D1941010DT PAGAMENTOGRAVADATA(SE2->E2_VENCREA,.F.,5) {"E2_VENCTO","E2_EMISSAO","E2_VENCREA"} 
1D11021040TIPO MOEDABRL                                                                                                                                                                
1D11051195QTD MOEDAREPLICATE("0",5)                                                                                                                                                     
1D11201342VALOR PAGTOPADL(SE2->(E2_SALDO+E2_SDACRESC-E2_SDDECRESC)*100,15,"0")                              
1D11351540NRO DOC ATR BCOSPACE(20)                                                                                                                                                            
1D11551620DT REAL PAGTOREPLICATE("0",8)                                                                                                                                                     
1D11631772VLR REAL PAGTOREPLICATE("0",15)                                                                                                                                                    
1D11782170OUTRAS INFORMACREPLICATE("0",40)                                                                                                                                                    
1D12182190COMPL TIPO SERV                                                                                                                                                                     
1D12202240COD FINAL TED                                                                                                                                                                     
1D12252260COMPL FINAL PAG                                                                                                                                                                     
1D12272290USO EXCL CNABSPACE(3)                                                                                                                                                             
1D12302300AVISO FAVORECID0                              
1D12312400OCORRENCIASSPACE(10)                                                                                                                                                            
1D2130COD BANCO1                              
1D2470LOTE SERVICO1                              
1D2880TIPO REGISTRO3                              
1D29130NRO SEQ REG LTPADL(INT(INCREMENTA()-1),5,"0")                                                                                                                                      
1D214140COD SEG REG DETB                                                                                                                                                                  
1D215170USO EXCL CNABSPACE(3)                                                                                                                                                             
1D218180TIPO INSCRICAOIIF(SA2->A2_TIPO == "J","2","1")                                                                                                                                     
1D219320NRO INSCRICAOPADR((ALLTRIM(SA2->A2_CGC)),14,"0")                                                                                                                                  
1D233620ENDERECOPADR(ALLTRIM(SA2->A2_END),30,"")                                                                                                                                     
1D263670NUMEROIIF(EMPTY(SA2->A2_NR_END),REPLICATE("0",5),PADL(ALLTRIM(SA2->A2_NR_END),5,"0"))                              
1D268820COMPLEMENTOSPACE(15)                                                                                                                                                            
1D283970BAIRROPADR(ALLTRIM(SA2->A2_BAIRRO),15,"")                              
1D2981170CIDADEPADR(ALLTRIM(SA2->A2_MUN),20,"")                               
1D21181250CEPPADL(ALLTRIM(SA2->A2_CEP),8,"0")                              
1D21261270ESTADOPADR(ALLTRIM(SA2->A2_EST),2,"")                               
1D21281350DATA VENCIMENTOGRAVADATA(SE2->E2_VENCTO,.F.,5)                                
1D21361502VALOR DOCUMENTOPADL(SE2->(E2_SALDO)*100,15,"0")                              
1D21511652VALOR ABATIMENTPADL(SE2->(E2_SDDECRESC)*100,15,"0")                              
1D21661802VALOR DESCONTOREPLICATE("0",15)                                                                                                                                                    
1D21811952VALOR MORAPADL(SE2->(E2_SDACRESC)*100,15,"0")                              
1D21962102MULTAREPLICATE("0",15)                                                                                                                                                    
1D22112250COD DOC FAVORECSPACE(15)                                                                                                                                                            
1D22262260AVISO FAVORECID0                              
1D22272320USO EXCL SIAPESPACE(6)                                                                                                                                                             
1D22332400USO EXCL CNABSPACE(8)                                                                                                                                                             
1H
130COD BANCO1                              
1H
470LOTE SERVICO1                              
1H
880TIPO REGISTRO1                              
1H
990TIPO OPERACAOC                                                                                                                                                                  
1H
10110TIPO SERVICO20                              
1H
12130FORMA LANCTO1                              
1H
14160NRO VERS LOTE42                              
1H
17170USO EXCL CNABSPACE(1)                                                                                                                                                             
1H
18180TIPO INSC EMPREIIF(SM0->M0_TPINSC == 3,"1","2")                                                                                                                                     
1H
19320NRO INSC EMPRESPADL(ALLTRIM(SM0->M0_CGC),14,"0")                              
1H
33410CONVENIOPADL(ALLTRIM(SEE->EE_CODEMP),9,"0")                              
1H
42450COB CEDENTE BB126                              
1H
46500NRO CART COB BBSPACE(5)                                                                                                                                                             
1H
51520IDEN REMES TESTTS                                                                                                                                                                 
1H
53570AGENCIA MANTENEPADL(ALLTRIM(SEA->EA_AGEDEP),5,"0")                              
1H
58580DV AGENCIACNABDVAG()                                                                                                                                                           
1H
59700NRO CTA CORRENTPADL(ALLTRIM(SEA->EA_NUMCON),12,"0")                              
1H
71710DV CTA CORRENTECNABDVCC()                                                                                                                                                           
1H
72720DV AGE CONTASPACE(1)                                                                                                                                                             
1H
731020NOME DA EMPRESAPADR(ALLTRIM(SM0->M0_NOMECOM),30,"")                              
1H
1031420MENSAGEM 1SPACE(40)                                                                                                                                                            
1H
1431720ENDERECOPADR(IIF(EMPTY(SM0->M0_ENDENT),SM0->M0_ENDENT,SM0->M0_ENDENT),30,"")                              
1H
1731770NUMEROREPLICATE("0",5)                                                                                                                                                     
1H
1781920COMPLEMENTOPADR(ALLTRIM(SM0->M0_COMPENT),15,"")                              
1H
1932120CIDADEPADR(IIF(EMPTY(SM0->M0_CIDENT),SM0->M0_CIDCOB,SM0->M0_CIDENT),20,"")                              
1H
2132200CEPPADR(IIF(EMPTY(SM0->M0_CEPENT),SM0->M0_CEPCOB,SM0->M0_CEPENT),8,"0")                              
1H
2212220ESTADOPADR(IIF(EMPTY(SM0->M0_ESTENT),SM0->M0_ESTCOB,SM0->M0_ESTENT),2,"")                              
1H
2232300USO EXCL CNABSPACE(8)                                                                                                                                                             
1H
2312400OCORRENCIASSPACE(10)                                                                                                                                                            
1T
130COD BCO COMPENS1                              
1T
470LOTE SERVICO1                              
1T
880TIPO REGISTRO5                              
1T
9170USO EXCL CNABSPACE(09)                                                                                                                                                            
1T
18230QTDE REG LOTESIIF(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 MOEDAREPLICATE("0",18)                                                                                                                                                    
1T
60650NRO AVISO DEBITREPLICATE("0",6)                                                                                                                                                     
1T
662300USO EXCL CNABSPACE(165)                                                                                                                                                           
1T
2312400OCORRENCIASSPACE(10)                                                                                                                                                            
2D1130COD BANCO1                              
2D1470LOTE SERVICO1                              
2D1880CODIGO REGISTRO3                              
2D19130NSRPADL(INT(INCREMENTA()-1),5,"0")                                                                                                                                      
2D114140CODIGO SEGMENTOJ                                                                                                                                                                  
2D115150TIPO MOVIMENTO0                              
2D116170CODIGO MOVIMENT0                              
2D118610CODIGO BARRASSUBSTR(SE2->E2_CODBAR,1,44)                              
2D162910NOME CEDENTEPADR(ALLTRIM(SA2->A2_NOME),30,"")                               
2D192990DATA VENCIMENTOGRAVADATA(SE2-E2_VENCTO,.F.,5)                               
2D11001142VALOR TITULOPADL(SE2->(E2_SALDO)*100,15,"0")                              
2D11151292VLR DESC ABATIMPADL(SE2->(E2_SDDECRESC)*100,15,"0")                              
2D11301443VLR MORA MULTAPADL(SE2->(E2_SDACRESC)*100,16,"0")                               
2D11451520DATA PAGAMENTOGRAVADATA(SE2->E2_VENCREA,.F.,5){"E2_VENCTO","E2_EMISSAO","E2_VENCREA"} 
2D11531672VALOR PAGAMENTOPADL(SE2->(E2_SALDO+E2_SDACRESC-E2_SDDECRESC)*100,15,"0")                              
2D11681825QTD MOEDAREPLICATE("0",15)                                                                                                                                                    
2D11832020NRO ATRIB EMPREPADR(ALLTRIM(SE2->E2_IDCNAB),20,"")                               
2D12032220NRO ATRIB BANCO REPLICATE("0",20)                               
2D12232240CODIGO MOEDA9                              
2D12252300USO EXCL CNABSPACE(6)                                                                                                                                                             
2D12312400OCORRENCIASSPACE(10)                                                                                                                                                            
2H
130COD BANCO1                              
2H
470LOTE SERVICO1                              
2H
880TIPO REGISTRO1                              
2H
990TIPO OPERACAOC                                                                                                                                                                  
2H
10110TIPO SERVICO20                              
2H
12130FORMA LACTO                                                                                                                                                                     
2H
14160NRO VERSAO  LOT30                              
2H
17170USO EXCL CNABSPACE(1)                                                                                                                                                             
2H
18180TIPO INSC BENEFIIF(SM0->M0_TPINSC== 3,"1","2")                                                                                                                                      
2H
19320NRO INSC BENEFPADL(ALLTRIM(SM0->M0_CGC),14,"0")                                                                                                                                    
2H
33410CODIGO BENEFPADL(ALLTRIM(SEE->EE_CODEMP),9,"0")                               
2H
42450TIPO COMPROMISS126                              
2H
46500COD COMPROMISSSPACE(5)                                                                                                                                                             
2H
51520USO EXCL CNABTS                                                                                                                                                                 
2H
53570AGENCIA MANTENEPADL(ALLTRIM(SEA->EA_AGEDEP),5,"0")                              
2H
58580DV AGENCIACNABDVAG()                                                                                                                                                           
2H
59700NRO CTA CORRENTPADL(ALLTRIM(SEA->EA_NUMCON),12,"0")                              
2H
71710DV CTA CORRENTECNABDVCC()                                                                                                                                                           
2H
72720DV AGE CONTASPACE(1)                                                                                                                                                             
2H
731020NOME DA EMPRESAPADR(ALLTRIM(SM0->M0_NOMECOM),30,"")                              
2H
1031420MENSAGEM 1SPACE(40)                                                                                                                                                            
2H
1431720ENDERECOPADR(IIF(EMPTY(SM0->M0_ENDENT),SM0->M0_ENDENT,SM0->M0_ENDENT),30,"")                              
2H
1731770NUMEROREPLICATE("0",5)                                                                                                                                                     
2H
1781920COMPLEMENTOPADR(ALLTRIM(SM0->M0_COMPENT),15,"")                              
2H
1932120CIDADEPADR(IIF(EMPTY(SM0->M0_CIDENT),SM0->M0_CIDCOB,SM0->M0_CIDENT),20,"")                              
2H
2132200CEPPADR(IIF(EMPTY(SM0->M0_CEPENT),SM0->M0_CEPCOB,SM0->M0_CEPENT),8,"0")                              
2H
2212220ESTADOPADR(IIF(EMPTY(SM0->M0_ESTENT),SM0->M0_ESTCOB,SM0->M0_ESTENT),2,"")                              
2H
2232300USO EXCL CNABSPACE(8)                                                                                                                                                             
2H
2312400OCORRENCIASSPACE(10)                                                                                                                                                            
2T
130COD BCO COMPENS1                              
2T
470LOTE SERVICO1                              
2T
880TIPO REGISTRO5                              
2T
9170USO EXCL CNABSPACE(09)                                                                                                                                                            
2T
18230QTDE REG LOTESPADL((NTOTCNAB2*2)+2,6,"0")                                                                                                                                          
2T
24412SOMAT VALORESPADL(SOMAVALOR(),18,"0")                                                                                                                                             
2T
42595SOMAT QTD MOEDAREPLICATE("0",18)                                                                                                                                                    
2T
60650NRO AVISO DEBITREPLICATE("0",6)                                                                                                                                                     
2T
662300USO EXCL CNABSPACE(165)                                                                                                                                                           
2T
2312400OCORRENCIASSPACE(10)                                                                                                                                                            
0T
130COD BANCO1                              
0T
470LOTE SERVICO9999                              
0T
880TIPO REGISTRO9                              
0T
9170USO EXCL CNABSPACE(9)                                                                                                                                                             
0T
18230QTDE LOTES ARQ1                              
0T
24290QTDE REGISTROSPADL((NTOTCNAB2*3)+4,6,"0")                                                                                                                                          
0T
30350QTDE CONTASREPLICATE("0",.6)                                                                                                                                                    
0T
362400USO EXCL CNABSPACE(205)