Árvore de páginas

Versões comparadas

Chave

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

033 - Banco Santander

...

- 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|04|05|03|10|41|43",.T.,.F.)                                                                                                                                                                                       
1D2      
DETALHE SEGMENTO BIIF(SEA->EA_MODELO $ "01|04|05|03|10|41|43",.T.,.F.)                                                                                                                                                                                         
1H
      
HEADER DE LOTE - A/BIIF(SEA->EA_MODELO $ "01|04|05|03|10|41|43",.T.,.F.)                                                                                                                                                                                        
1T
      
TRAILLER DE LOTE - A/BIIF(SEA->EA_MODELO $ "01|04|05|03|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_VALOR >= VAL(GETMV(MV_PAGJ52)), .T.,.F.)                                                                                                    
2H
      
HEADER LOTE - J / J52IIF(SEA->EA_MODELO $ "30/31", .T.,.F.)                                                                                                                                                                                                     
2T
      
TRAILLER DE LOTE - J / J52IIF(SEA->EA_MODELO $ "30/31", .T.,.F.)                                                                                                                                                                                                     
1D2130COD BANCO                               33                                                                                                    
1D2470LOTE SERVICO                            1                                                                                                    
1D2880TIPO REGISTRO                           3                                                                                                    
1D29130NUM SEQ DO REGPADL(INT(INCREMENTA()-1),5,"0")                                                                                                                                                                                                            
1D214140COD SEG DETALHEB                                                                                                                                                                                                                                        
1D215170USO EXCL CNAB                           SPACE(3)                                                                                                                                                                                                                                   
1D218180TP INSC FAV                             IIF(SA2->A2_TIPO == "J", "2", "1")                                                                                                                                                                                                         
1D219320CNPJ/CPF FAV                            PADL(ALLTRIM(SA2->A2_CGC),14,"0")                                                                                                                                                                                                          
1D233620LOGRAD FAVORECPADR(ALLTRIM(SA2->A2_END),30,"")                                                                                                                                                                                                           
1D263670NUMERO                                  REPLICATE("0",5)                                                                                                                                                                                                                           
1D268820COMPLEMENTO                             PADR(ALLTRIM(SA2->A2_COMPLEM),15,"")                                                                                                    
1D283970BAIRRO FAVOR                            PADR(ALLTRIM(SA2->A2_BAIRRO),15,"")                                                                                                                                                                                                        
1D2981170CIDADE FAVOR                            PADR(ALLTRIM(SA2->A2_MUN),20,"")                                                                                                                                                                                                            
1D21181250CEP FAVOR                               PADL(ALLTRIM(SA2->A2_CEP),8,"0")                                                                                                                                                                                                           
1D21261270ESTADO FAVOR                            SA2->A2_EST                                                                                                                                                                                                                                
1D21281350DATA VENCIMENTOGRAVADATA(SE2->E2_VENCTO,.F.,5)                                                                                                         {"
  • E2_VENCTO
","
  • E2_EMISSAO
","
  • E2_
VENCREA"}                                                             
  • VENCREA                                                           
1D21361502VALOR DOCUMENTOPADL(SE2->(E2_SALDO+E2_SDACRESC-E2_SDDECRESC)*100,15,"0")                                                                                                    
1D21511652VLR ABATIMENTO                          PADL(SE2->E2_SDDECRE*100,15,"0")                                                                                                                                                                                                           
1D21661802VLR  DESCONTO                           REPLICATE("0",15)                                                                                                                                                                                                                          
1D21811952VLR MORA                                REPLICATE("0",15)                                                                                                                                                                                                                          
1D21962102VLR MULTA                               PADR(SE2->E2_SDACRES*100,15,"0")                                                                                                                                                                                                           
1D22112140HR ENVIO TED                            REPLICATE("0",4)                                                                                                                                                                                                                           
1D22152250USO EXCL CNAB                           SPACE(11)                                                                                                                                                                                                                                  
1D22262290COD HIST CREDIT                         REPLICATE("0",4)                                                                                                                                                                                                                           
1D22302300AVISO FAVOR                             0                                                                                                    
1D22312310USO EXCL CNAB                           SPACE(1)                                                                                                                                                                                                                                   
1D22322320TED INST FINANC                         S                                                                                                                                                                                                                                        
1D22332400ID DA IF NO SPB                         SPACE(8)                                                                                                                                                                                                                                   
2D1130COD BANCO                               33                                                                                                    
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                              PADL(SE2->E2_CODBAR,44,"0")                                                                                                                                                                                                                
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 TITULO                          PADL(SE2->(E2_SALDO)*100,15,"0")                                                                                                                                                                                                           
2D11151292VALOR DESCONTOPADL(SE2->(E2_SDDECRESC)*100,15,"0")                                                                                                                                                                                                       
2D11301442VALOR JUROS                             PADL(SE2->(E2_SDACRESC)*100,15,"0")                                                                                                                                                                                                        
2D11451520DATA PAGAMENTOGRAVADATA(SE2->E2_VENCREA,.F.,5)                                                                                                        {"
  • E2_VENCTO
","
  • E2_EMISSAO
","
  • E2_
VENCREA"}                                                             
  • VENCREA                                                             
2D11531672VLR PAG                                 PADL(SE2->(E2_SALDO+E2_SDACRESC-E2_SDDECRESC)*100,15,"0")                                                                                                    
2D11681820QTD MOEDA                               REPLICATE("0",15)                                                                                                                                                                                                                          
2D11832020NRO DOC CLIENTEPADR(ALLTRIM(SE2->E2_IDCNAB),20,"")                                                                                                                                                                                                        
2D12032220DOC ATR BANCO                           SPACE(20)                                                                                                                                                                                                                                  
2D12232240COD MOEDA                               9                                                                                                    
2D12252300USO EXCL CNAB                           SPACE(6)                                                                                                                                                                                                                                   
2D12312400OCORRENCIAS                             SPACE(10)                                                                                                                                                                                                                                  
2D2130COD BANCO                               33                                                                                                    
2D2470LOTE SERVICO                            1                                                                                                    
2D2880TIPO REGISTRO                           3                                                                                                    
2D29130NUM SEQ REG LOTPADL(INT(INCREMENTA()-1),5,"0")                                                                                                                                                                                                            
2D214140COD SEG DETALHEJ                                                                                                                                                                                                                                        
2D215150USO EXCL CNAB                           SPACE(1)                                                                                                                                                                                                                                   
2D216170COD MOV REMESSA0                                                                                                    
2D218190IDENT REG OPCIO                         52                                                                                                    
2D220200TP INSC SACADO                          IIF(SM0->M0_TPINSC == 3,"1","2")                                                                                                                                                                                                           
2D221350NRO INSC SACADOPADL(ALLTRIM(SM0->M0_CGC),15,"0")                                                                                                                                                                                                          
2D236750NOME DO SACADOPADR(ALLTRIM(SM0->M0_NOMECOM),40,"")                                                                                                    
2D276760TP INSC CEDENTEIIF(SA2->A2_TIPO == "J","2","1")                                                                                                                                                                                                           
2D277910NRO INSC CEDENTPADL(ALLTRIM(SA2->A2_CGC),15,"0")                                                                                                                                                                                                          
2D2921310NOME DO CEDENTEPADR(ALLTRIM(SA2->A2_NOME),40,"")                                                                                                                                                                                                          
2D21321320TP INSC SACADO                          IIF(SA2->A2_TIPO == "J","2","1")                                                                                                                                                                                                           
2D21331470NRO INSC SACADOPADL(ALLTRIM(SA2->A2_CGC),15,"0")                                                                                                                                                                                                          
2D21481870NOME DO SACADOPADR(ALLTRIM(SA2->A2_NOME),40,"")                                                                                                                                                                                                          
2D21882400USO EXCL CNAB                           SPACE(53)                                                                                                                                                                                                                                  
2H
130COD BANCO                               33                                                                                                    
2H
470LOTE SERVICO                            1                                                                                                    
2H
880TIPO REGISTRO                           1                                                                                                    
2H
990TIPO OPERACAO                           C                                                                                                                                                                                                                                        
2H
10110TIPO SERVICO                            20                                                                                                    
2H
12130FORMA LANCAM                                                                                                                                                                                                                                                                       
2H
14160NUM VERS LOTE                           30                                                                                                    
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
33360BANCO CONVENIO33                                                                                                    
2H
37400AGENC CONTRATOPADL(ALLTRIM(SEA->EA_AGEDEP),4,"0")                                                                                                                                                                                                         
2H
41520NRO CONVENIO                            PADL(ALLTRIM(SEE->EE_CODEMP),12,"0")                                                                                                                                                                                                       
2H
53570NRO AGENCIA                             PADL(ALLTRIM(SEA->EA_AGEDEP),5,"0")                                                                                                                                                                                                        
2H
58580DV AGENCIA                              CNABDVAG()                                                                                                                                                                                                                                 
2H
59700NRO CTA CORRENTPADL(ALLTRIM(SEA->EA_NUMCON),12,"0")                                                                                                    
2H
71720DV CONTA                                CNABG069()                                                                                                                                                                                                                                 
2H
731020NOME EMPRESAPADR(ALLTRIM(SM0->M0_NOMECOM),30,"")                                                                                                    
2H
1031420MENSAGEM 1                              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(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
2212220UNID FEDERATIVA                         PADR(IIF(EMPTY(SM0->M0_ESTENT),SM0->M0_ESTCOB,SM0->M0_ESTENT),2,"")                                                                                                    
2H
2232300USO EXCL CNAB                           SPACE(8)                                                                                                                                                                                                                                   
2H
2312400OCORRENCIA                              SPACE(10)                                                                                                                                                                                                                                  
2T
130COD BANCO                               33                                                                                                    
2T
470LOTE SERV                               1                                                                                                    
2T
880TP DE REG                               5                                                                                                    
2T
9170USO EXCL CNAB                           SPACE(9)                                                                                                                                                                                                                                   
2T
18230QUANT DE REG                            IIF(SEA->EA_MODELO $ "01/03/05",PADL((NTOTCNAB2*2)+2,6,"0"),PADL((NTOTCNAB2+2),6,"0"))                                                                                                    
2T
24410SOMAT VLR                               PADL(SOMAVALOR(),18,"0")                                                                                                                                                                                                                   
2T
42590SOMAT QTD MOEDREPLICATE("0",18)                                                                                                                                                                                                                          
2T
60650NRO AVISO DEBTOREPLICATE("0",6)                                                                                                                                                                                                                           
2T
662300USO EXCL CNAB                           SPACE(165)                                                                                                                                                                                                                                 
2T
2312400OCORRENCIAS                             SPACE(10)                                                                                                                                                                                                                                  
1T
130COD BANCO                               33                                                                                                    
1T
470LOTE SERV                               1                                                                                                    
1T
880TP DE REG                               5                                                                                                    
1T
9170USO EXCL CNAB                           SPACE(9)                                                                                                                                                                                                                                   
1T
18230QUANT DE REGIIF(SEA->EA_MODELO $ "01/03/41/43",PADL((NTOTCNAB2*2)+2,6,"0"),PADL((NTOTCNAB2+2),6,"0"))                                                                                                    
1T
24410SOMAT VLR                               PADL(SOMAVALOR(),18,"0")                                                                                                                                                                                                                   
1T
42590SOMAT QTD MOEDREPLICATE("0",18)                                                                                                                                                                                                                          
1T
60650NRO AVISO DEBTOREPLICATE("0",6)                                                                                                                                                                                                                           
1T
662300USO EXCL CNAB                           SPACE(165)                                                                                                                                                                                                                                 
1T
2312400OCORRENCIAS                             SPACE(10)                                                                                                                                                                                                                                  
1D1130COD BANCO                               33                                                                                                    
1D1470LOTE SERVICO                            1                                                                                                    
1D1880TIPO REGISTRO                           3                                                                                                    
1D19130NUM SEQ REG                             PADL(INT(INCREMENTA()-1),5,"0")                                                                                                                                                                                                            
1D114140COD SEG REG                             A                                                                                                                                                                                                                                        
1D115150TP DE MOV                               0                                                                                                    
1D116170COD INST MOVIM                          0                                                                                                    
1D118200COD CAM. COMP                                                                                                                                                                                                                                                                      
1D121230COD BANCO FV                            PADL(ALLTRIM(SA2->A2_BANCO),3,"0")                                                                                                    
1D124280AGENCIA FAVORECPADL(ALLTRIM(SA2->A2_AGENCIA),5,"0")                                                                                                    
1D129290DV AGENCIA                              SA2->A2_DVAGE                                                                                                                                                                                                                              
1D130410CONTA FAVOR                             PADL(ALLTRIM(SA2->A2_NUMCON),12,"0")                                                                                                    
1D142430DV CONTA                                SA2->A2_DVCTA                                                                                                                                                                                                                              
1D144730NOME FAVOR                              PADR(ALLTRIM(SA2->A2_NOME),30,""){"
  • A2_NREDUZ
","
  • A2_
NOME"}                                                                             
  • NOME                                                                             
1D174930NUMDOC                                  PADR(ALLTRIM(SE2->E2_IDCNAB),20,"")                                                                                                    
1D1941010DATA PAGAMENTOGRAVADATA(SE2->E2_VENCREA,.F.,5){"
  • E2_VENCTO
","
  • E2_EMISSAO
","
  • E2_
VENCREA"}                                                             
  • VENCREA                                                            
1D11021040TIPO MOEDA                              BRL                                                                                                                                                                                                                                      
1D11051195QUANT MOEDA                             REPLICATE("0",15)                                                                                                                                                                                                                          
1D11201342VLR PAG                                 PADL(SE2->(E2_SALDO+E2_SDACRESC-E2_SDDECRESC)*100,15,"0")                                                                                                    
1D11351540NRO DOC ATR BCOPADR(ALLTRIM(SE2->E2_IDCNAB),20,"")                                                                                                    
1D11551620DT REAL PGTO                            REPLICATE("0",8)                                                                                                                                                                                                                           
1D11631772VLR REAL PGTO                           PADL(SE2->(E2_SALDO+E2_SDACRESC-E2_SDDECRESC)*100,15,"0")                                                                                                    
1D11782170INFORMACAO 2                            SPACE(40)                                                                                                                                                                                                                                  
1D12182190FINALID DOC                             SPACE(2)                                                                                                                                                                                                                                   
1D12202240FINALID TED                             SPACE(5)                                                                                                                                                                                                                                   
1D12252260COMPL FIN PAGTOSPACE(2)                                                                                                                                                                                                                                   
1D12272290USO EXCL CNAB                           REPLICATE("0",3)                                                                                                                                                                                                                           
1D12302300AVISO FAVOR                             0                                                                                                    
1D12312400OCORRENCIAS                             SPACE(10)                                                                                                                                                                                                                                  
0T
130COD BANCO                               33                                                                                                    
0T
470LOTE SERVICO                            9999                                                                                                    
0T
880TIPO REGISTRO                           9                                                                                                    
0T
9170USO EXCL CNAB                           SPACE(9)                                                                                                                                                                                                                                   
0T
18230QUANT LOT ARQ                                                                                                                                                                                                                                                                      
0T
24290QUANT REG ARQ                                                                                                                                                                                                                                                                      
0T
302400USO EXCL CNAB                           SPACE(211)                                                                                                                                                                                                                                 
1H
130COD BANCO                               33                                                                                                    
1H
470LOTE SERVICO                            1                                                                                                    
1H
880TIPO REGISTRO                           1                                                                                                    
1H
990TIPO OPERACAO                           C                                                                                                                                                                                                                                        
1H
10110TIPO SERVICO                            20                                                                                                    
1H
12130FORMA LANCAM                                                                                                                                                                                                                                                                       
1H
14160NUM VERS LOTE                           31                                                                                                    
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
33360BANCO CONVENIO33                                                                                                    
1H
37400AGENC CONTRATOPADL(ALLTRIM(SEA->EA_AGEDEP),4,"0")                                                                                                    
1H
41520NRO CONVENIO                            PADL(ALLTRIM(SEE->EE_CODEMP),12,"0")                                                                                                    
1H
53570NRO AGENCIA                             PADL(ALLTRIM(SEA->EA_AGEDEP),5,"0")                                                                                                    
1H
58580DV AGENCIA                              CNABDVAG()                                                                                                                                                                                                                                 
1H
59700NRO CTA CORRENTPADL(ALLTRIM(SEA->EA_NUMCON),12,"0")                                                                                                    
1H
71720DV CONTA                                CNABG069()                                                                                                                                                                                                                                 
1H
731020NOME EMPRESAPADR(ALLTRIM(SM0->M0_NOMECOM),30,"")                                                                                                    
1H
1031420MENSAGEM 1                              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(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
2212220UNID FEDERATIVA                         PADR(IIF(EMPTY(SM0->M0_ESTENT),SM0->M0_ESTCOB,SM0->M0_ESTENT),2,"")                                                                                                    
1H
2232300USO EXCL CNAB                           SPACE(8)                                                                                                                                                                                                                                   
1H
2312400OCORRENCIA                              SPACE(10)                                                                                                                                                                                                                                  
0H
130COD DO BANCO                            33                                                                                                    
0H
470LOTE DE SERV                            0                                                                                                    
0H
880TP SERVICO                              0                                                                                                    
0H
9170USO EXCL CNAB                           SPACE(9)                                                                                                                                                                                                                                   
0H
18180TP INSC EMPRESAIIF(SM0->M0_TPINSC== 3,"1","2")                                                                                                                                                                                                            
0H
19320NUM INSC EMP                            PADL(ALLTRIM(SM0->M0_CGC),14,"0")                                                                                                    
0H
33360BANCO CONVENIO33                                                                                                    
0H
37400AGENC CONTRATOPADL(ALLTRIM(SEA->EA_AGEDEP),4,"0")                                                                                                    
0H
41520NRO CONVENIO                            PADL(ALLTRIM(SEE->EE_CODEMP),12,"0")                                                                                                    
0H
53570AG MANT CONTA                           PADL(ALLTRIM(SEA->EA_AGEDEP),5,"0")                                                                                                    
0H
58580DV AGENCIA                              CNABDVAG()                                                                                                                                                                                                                                 
0H
59700CONTA CORRENTEPADL(ALLTRIM(SEA->EA_NUMCON),12,"0")                                                                                                    
0H
71720DV CONTA                                CNABG069()                                                                                                                                                                                                                                 
0H
731020NOME DA EMPRESAPADR(ALLTRIM(SM0->M0_NOMECOM),30,"")                                                                                                    
0H
1031320NOME BANCO                              PADR("BANCO SANTANDER",30,"")                                                                                                    
0H
1331420USO EXCL CNAB                           SPACE(10)                                                                                                                                                                                                                                  
0H
1431430COD REMESSA                             1                                                                                                    
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                          60                                                                                                    
0H
1671710DENSID GRV ARQ                          REPLICATE("0",5)                                                                                                                                                                                                                           
0H
1721910RESERVADO BCOSPACE(20)                                                                                                                                                                                                                                  
0H
1922110USO RESERV EMPRSPACE(20)                                                                                                                                                                                                                                  
0H
2122300USO EXCL CNAB                           SPACE(19)                                                                                                                                                                                                                                  
0H
2312400OCORRENCIAS                             SPACE(10)                                                                                                                                                                                                                                  


\\10.171.66.229\espelho-portal\Protheus12\Binario