Árvore de páginas

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.
Comentário: Inserted the Pivot Table macro

...

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.

Pivot Table
id1545997240475_-477767089
Controle LinhasControle DetalhesControle SequencialPosição
Inicial
Posição
Final
DecimalInformaçãoConteúdoOpções de edição
0H
      
Header de Arquivo
                                                                                                    
0T
      
TRAILER ARQUIVO
                                                                                                    
1D1      
DETALHE SEGMENTO TT                                                                                                    
1D2      
DETALHE SEGMENTO UU                                                                                                    
1H
      
HEADER DE LOTE 
                                                                                                    
1T
      
TRAILER LOTE
                                                                                                    
0H
130CODIGO BANCO                                                                                                                                                                                                                                           
0H
470LOTE SERVICO                                                                                                                                                                                                                                           
0H
880REGISTRO ARQUIV                                                                                                                                                                                                                                           
0H
9170COMPLEM REGISTR                                                                                                                                                                                                                                           
0H
18180TIPO INSC REGIS                                                                                                                                                                                                                                           
0H
19320NRO INSC EMPRES                                                                                                                                                                                                                                           
0H
33520COMPLEM REGISTR                                                                                                                                                                                                                                           
0H
431430COD REM RETORNO                                                                                                                                                                                                                                           
0H
53530COMPLEM REGISTR                                                                                                                                                                                                                                           
0H
54570AGENCIA MANTENE                                                                                                                                                                                                                                           
0H
58580COMPLEM REGISTR                                                                                                                                                                                                                                           
0H
59700NRO CTA CORRENT                                                                                                                                                                                                                                           
0H
71710COMPLEM REGISTR                                                                                                                                                                                                                                           
0H
72720DV AGENCIA                                                                                                                                                                                                                                           
0H
731020NOME EMPRESA                                                                                                                                                                                                                                           
0H
1031320NOME BANCO                                                                                                                                                                                                                                           
0H
1331420COMPLEM REGISTR                                                                                                                                                                                                                                           
0H
1441510DT GER ARQUIVO                                                                                                                                                                                                                                           
0H
1521570HR GER ARQUIVO                                                                                                                                                                                                                                           
0H
1581630NRO SEQ ARQ RET                                                                                                                                                                                                                                           
0H
1641660NRO VER ARQUIVO                                                                                                                                                                                                                                           
0H
1671710COMPLEM REGISTR                                                                                                                                                                                                                                           
0H
1722250COMPLEM REGISTR                                                                                                                                                                                                                                           
0H
2262280COMPLEM REGISTR                                                                                                                                                                                                                                           
0H
2292400COMPLEM REGISTR                                                                                                                                                                                                                                           
0T
130COD BANCO                                                                                                                                                                                                                                           
0T
470LOTE SERVICO                                                                                                                                                                                                                                           
0T
880REG TRAILER ARQ                                                                                                                                                                                                                                           
0T
9170COMP REGISTRO                                                                                                                                                                                                                                           
0T
18230QTD LOTES ARQUI                                                                                                                                                                                                                                           
0T
24290QTD REG ARQUIVO                                                                                                                                                                                                                                           
0T
30350COMP REGISTRO                                                                                                                                                                                                                                           
0T
362400COMP REGISTRO                                                                                                                                                                                                                                           
1H
130CODIGO BANCO                                                                                                                                                                                                                                           
1H
470LOTE SERVICO                                                                                                                                                                                                                                           
1H
880REGISTRO LOTE                                                                                                                                                                                                                                           
1H
990TIPO OPERACAO                                                                                                                                                                                                                                           
1H
10110ID TIPO SERVICO                                                                                                                                                                                                                                           
1H
12130COMPL REGISTRO                                                                                                                                                                                                                                           
1H
14160NRO VER LOTE                                                                                                                                                                                                                                           
1H
17170COMPL REGISTRO                                                                                                                                                                                                                                           
1H
18180TIPO INSC EMPRE                                                                                                                                                                                                                                           
1H
19330NRO INSC EMPRES                                                                                                                                                                                                                                           
1H
34530COMPL REGISTRO                                                                                                                                                                                                                                           
1H
54580AG MANT CONTA                                                                                                                                                                                                                                           
1H
59590COMPL REGISTRO                                                                                                                                                                                                                                           
1H
60710NRO CONTA                                                                                                                                                                                                                                           
1H
72720COMPL REGISTRO                                                                                                                                                                                                                                           
1H
73730DV AG CON                                                                                                                                                                                                                                                                          
1H
741030BOME EMPRESA                                                                                                                                                                                                                                           
1H
1041430MENSAGEM 1                                                                                                                                                                                                                                           
1H
1441830MENSAGEM 2                                                                                                                                                                                                                                            
1H
1841910NRO SEQ RETORNO                                                                                                                                                                                                                                           
1H
1921990DT GRAV ARQUIVO                                                                                                                                                                                                                                           
1H
2002070DT CREDITO                                                                                                                                                                                                                                           
1H
2082400COMPL REGISTRO                                                                                                                                                                                                                                           
1T
130COD BANCO                                                                                                                                                                                                                                           
1T
470LOTE SERVICO                                                                                                                                                                                                                                           
1T
880REGISTRO LOTE                                                                                                                                                                                                                                           
1T
9170COMP REGISTRO                                                                                                                                                                                                                                           
1T
18230QTD REGIS LOTE                                                                                                                                                                                                                                           
1T
24290QTD TITULO SIMP                                                                                                                                                                                                                                           
1T
30462VLR TOTAL SIMPL                                                                                                                                                                                                                                           
1T
47520QTD TITULO VINC                                                                                                                                                                                                                                           
1T
53692VLT TOTAL VINCU                                                                                                                                                                                                                                           
1T
70750QTDE TIT COBRAN                                                                                                                                                                                                                                           
1T
76922QTDE TIT CARTEI                                                                                                                                                                                                                                           
1T
93980QTDE TIT COBRAN                                                                                                                                                                                                                                           
1T
991152VLR TTL TIT CAR                                                                                                                                                                                                                                           
1T
1161230REF AVISO BANCA                                                                                                                                                                                                                                           
1T
1242400COMP REGISTRO                                                                                                                                                                                                                                           
1D1130CODIGO BANCO                                                                                                                                                                                                                                           
1D1470LOTE SERVICO                                                                                                                                                                                                                                           
1D1880REGISTRO DETALH                                                                                                                                                                                                                                           
1D19130NRO SEQ DETALHE                                                                                                                                                                                                                                           
1D114140COD SEG DETALHE                                                                                                                                                                                                                                           
1D115150IND BOLETO DDA                                                                                                                                                                                                                                           
1D116170ID OCORRENCIA                                                                                                                                                                                                                                           
1D118220AG MAN CONTA                                                                                                                                                                                                                                           
1D123230COMP REGISTRO                                                                                                                                                                                                                                           
1D124350NRO CTA CORRENT                                                                                                                                                                                                                                           
1D136360COMP REGISTRO                                                                                                                                                                                                                                           
1D137370COMP REGISTRO                                                                                                                                                                                                                                           
1D138570NRO CART BANCO                                                                                                                                                                                                                                           
1D158580COMP REGISTRO                                                                                                                                                                                                                                           
1D159730NRO DOC COBRAN                                                                                                                                                                                                                                           
1D174810DT VENCTODATA                                                                                                                                   
  • ZERAR POSICAO
  • DATA
  • DATACREDITO                                                              
1D182962VLR NOM TITULOVALOR                                                                                                                                  
  • ZERAR POSICAO
  • VALOR
  • DESPESAS
  • DESCONTO
  • JUROS
  • ABATIMENTO
  • MULTA
  • IOF
  • OUTROSCREDITOS
1D197990COMP REGISTRO                                                                                                                                                                                                                                           
1D11001040AG COB TITULO                                                                                                                                                                                                                                           
1D11051050DV AG COB TITUL                                                                                                                                                                                                                                            
1D11061300ESPECIE TITULOESPECIE                                                                                                                                
  • ZERAR POSICAO
  • TITULO
  • ESPECIE
  • NOSSONUMERO
  • AUTENTICACAO
  • MOTIVO                         
1D11311320COMP REGISTRO                                                                                                                                                                                                                                           
1D11331330TIPO INSC PAGAD                                                                                                                                                                                                                                           
1D11341480NRO INSC PAGADO                                                                                                                                                                                                                                           
1D11491880NOME PAGADOR                                                                                                                                                                                                                                           
1D11891980COMP REGISTRO                                                                                                                                                                                                                                           
1D11992132VLR COB CARTORI                                                                                                                                                                                                                                           
1D12142230ID REG REJEITAD                                                                                                                                                                                                                                           
1D12242400COMP REGISTRO                                                                                                                                                                                                                                           
1D2130COD BANCO                                                                                                                                                                                                                                           
1D2470LOTE SERVICO                                                                                                                                                                                                                                           
1D2880REGISTRO DETALH                                                                                                                                                                                                                                           
1D29130NRO SEQ LOTE                                                                                                                                                                                                                                           
1D214140COD SEG DETALHE                                                                                                                                                                                                                                           
1D215150

COMP REGISTRO

                                                                                                                                                                                                                                           
1D216170ID OCORRENCIA                                                                                                                                                                                                                                           
1D218322JUROS MORA MULTJUROS + MULTA                                                                                                                          
  • ZERAR POSICAO
  • VALOR
  • DESPESAS
  • DESCONTO
  • JUROS
  • ABATIMENTO
  • MULTA
  • IOF
  • OUTROSCREDITOS
1D233472VLR DESC CONCEDDESCONTO                                                                                                                               
  • ZERAR POSICAO
  • VALOR
  • DESPESAS
  • DESCONTO
  • JUROS
  • ABATIMENTO
  • MULTA
  • IOF
  • OUTROSCREDITOS
1D248622VLR ABATIMENTOABATIMENTO                                                                                                                             
  • ZERAR POSICAO
  • VALOR
  • DESPESAS
  • DESCONTO
  • JUROS
  • ABATIMENTO
  • MULTA
  • IOF
  • OUTROSCREDITOS
1D263772VLR IOF RECOLHIIOF                                                                                                                                    
  • ZERAR POSICAO
  • VALOR
  • DESPESAS
  • DESCONTO
  • JUROS
  • ABATIMENTO
  • MULTA
  • IOF
  • OUTROSCREDITOS
1D278922VLR LAN CTA CORVALOR                                                                                                                                  
  • ZERAR POSICAO
  • VALOR
  • DESPESAS
  • DESCONTO
  • JUROS
  • ABATIMENTO
  • MULTA
  • IOF
  • OUTROSCREDITOS
1D2931072VLR LAN CTA CORVALOR                                                                                                                                  
  • ZERAR POSICAO
  • VALOR
  • DESPESAS
  • DESCONTO
  • JUROS
  • ABATIMENTO
  • MULTA
  • IOF
  • OUTROSCREDITOS
1D21081220OUTRAS DESPESAS                                                                                                                                                                                                                                           
1D21231370OUTROS CREDITOSOUTROSCREDITOS                                                                                                                         
  • ZERAR POSICAO
  • VALOR
  • DESPESAS
  • DESCONTO
  • JUROS
  • ABATIMENTO
  • MULTA
  • IOF
  • OUTROSCREDITOS
1D21381450DT GER ARQUIVO                                                                                                                                                                                                                                           
1D21461530DT CREDITODATA                                                                                                                                   
  • ZERAR POSICAO
  • DATA
  • DATACREDITO
1D21541570COD OCOR PAGADO                                                                                                                                                                                                                                           
1D21581650DT OCOR PAGADOR                                                                                                                                                                                                                                           
1D21661802VLR OCOR PAGADO                                                                                                                                                                                                                                           
1D21812100COMP OCORRENCIA                                                                                                                                                                                                                                           
1D22112130COD BCO CORRESP                                                                                                                                                                                                                                           
1D22142330NOSSO NRO BCO                                                                                                                                                                                                                                           
1D22342400USO EXCL CNABOCORRENCIA                                                                                                                             
  • ZERAR POSICAO
  • OCORRENCIA
  • RESERVADO
  • SEGMENTO