Page tree
Skip to end of metadata
Go to start of metadata

Purpose

This wiki article is intended to present the detailed layout of the bank statement (Extrato) with Itau format.

Overview

The section below will describe all the fields needed for the records of the Itau Statement (Extrato) file: File Header,  Lot Header, Segment E, Lot Trailler, and File Trailler.
 

File Header

Field NameStructureLengthTypeSourceDescription
Controle bancoJ_1BDMEXH1-H1010C3febko-absnd(3)/febvw-bankl(3)Bank code
Controle loteJ_1BDMEXH1-H1023NC4"0000"Lot Counter
Controle registroJ_1BDMEXH1-H1037C1"0"Flag for file header
Brancos/LayoutJ_1BDMEXH1-H1048C9SPACE 
Empresa inscriçãoJ_1BDMEXH1-H10517C1"2"Inscription type (CGC)
Empresa númeroJ_1BDMEXH1-H10618NC14febko-ktoihCGC number: Statement accont holder
Empresa convênioJ_1BDMEXH1-H10732C20 Identification number at bank
Conta correnteJ_1BDMEXH1-H10852NC5Agency/febko-absnd+3(5)/Agency (bank key)
    febvw-bank+3(5) 
Conta DVJ_1BDMEXH1-H10957C1 Control digit for agency
Conta númeroJ_1BDMEXH1-H11058NC12febko-ktonr/febko-absnd+15Account number without control digits
Conta número DVJ_1BDMEXH1-H11170C1add to febko-ktonr (if filled)Control digit for account number
DVJ_1BDMEXH1-H11271C1add to febko-ktonr (if filled)Control digit for agency/account
Nome da empresaJ_1BDMEXH1-H11372C30 Brach name
Nome do bancoJ_1BDMEXH1-H114102C30 Name of house bank
 J_1BDMEXH1-H115132C10SPACE 
Arquivo códigoJ_1BDMEXH1-H116142C1"2"Means RETORNO (return file)
Data de geraçãoJ_1BDMEXH1-H117143C8febko-azdat/febko-azidt(8)Creation date (DDMMYYYY): statement date
Hora de geraçãoJ_1BDMEXH1-H118151C6febko-azidt+8(6)Creation time: statement date
SequenciaJ_1BDMEXH1-H119157NC9febko-aznum (no extrato)File number and version used for statement 
    /febko-emkey(6)(always)+ "030"Key
DensidadeJ_1BDMEXH1-H120166NC5  
Reservado BancoJ_1BDMEXH1-H121171C20  
Reservado empresaJ_1BDMEXH1-H121191C20  
CNABJ_1BDMEXH1-H121211C17Space 
ServiçoJ_1BDMEXH1-H121228C2  
OcorrênciasJ_1BDMEXH1-H121230C10  
 J_1BDMEXH1-J_1BCRLF240HEX2"0D0A" CR+LF

Lot Header

Código do bancoJ_1BDMEXH2-H2010C3 Bank Code 
Código do loteJ_1BDMEXH2-H2023NC4febko-ktosb+6(4)Lot counter (sequential): spec.. account name
Tipo de registroJ_1BDMEXH2-H2037C1"1"Flag for lot header
Tipo de operaçãoJ_1BDMEXH2-H2048C1"E"Extrato
Tipo de serviçoJ_1BDMEXH2-H2059NC2"04"/ febko-ktosb+14Indentifier: Extrato: account spec name
Forma de lançamentoJ_1BDMEXH2-H20611NC2febko-ktosb+11Account spec name
Layout do loteJ_1BDMEXH2-H20713C3"020 "Layout version number
Empresa inscriçãoJ_1BDMEXH2-H20816C1  
Tipo da empresJ_1BDMEXH2-H20917C1"2" or "1"CGC (2)  or CPF(1)
Núm. da empresaJ_1BDMEXH2-H21018NC15  
Cód. con. bancoJ_1BDMEXH2-H21133C20 Identification number at bank
Cod. AgênciaJ_1BDMEXH2-H21253NC5 Agency (bank key)
DVJ_1BDMEXH2-H21358C1 Ceck digit for agency
Conta númeroJ_1BDMEXH2-H21459NC12 Account number at bank
DVJ_1BDMEXH2-H21571C1 Contol digit for account number
DVJ_1BDMEXH2-H21672C1 Control digit for agency/account number
Nome da empresaJ_1BDMEXH2-H21773C30 Brach name
Inf. 1J_1BDMEXH2-H218103C40 Information 1
Data do saldo iniciallot_header_e-datum_ini143C8 Date for initial balance
Valor do saldo iniciallot_header_e-valor_ini151NC18febko-ssbtrInitial balance: Start saldo
Situação do saldolot_header_e-dcind_ini169C1"D" or "C"/febko-ssvoz ("S" or "H")Initial deb/cred ind.: Satement debit/credit
Statuslot_header_e-stats_ini170C1 Initial status
Tipo de moedalot_header_e-currency171C3 Currency
Sequência lot_header_e-extra_nr174C5febko-aznum/febko-emkey+6sequ. Number: statement number+G45
CNABlot_header_e-filler62179C62SPACEFiller

Segment E

Código do bancoitems_e-e010C3 Bank Code 
Código do loteitems_e-e023NC4 Lot counter (sequential)
Tipo de registroitems_e-e037C1"3"Flag for standard record
Número do registroitems_e-e048NC5 record counter per lot (sequential)
Código do segmentoitems_e-e0513C1"E"seg+G249ment name
Brancositems_e-e0614C1  
Brancositems_e-e0715C2 ("01" for CPF, "02" for CGC)
Número de inscriçãoitems_e-e0817C1 tax number of company
Convênioitems_e-e0918NC14  
Cód. conta correnteitems_e-e1032C20 Bank code 
DVitems_e-e1152NC5 control digit for account number
Bairroitems_e-e1257C1 District of business partner
Cidadeitems_e-e1358NC12 City of business partner
CEPitems_e-e1470C1 Zip code business partner
Complemento CEPitems_e-e1571C1 Complement zip code
Estadoitems_e-e1672C30 Region business partner
CNABitems_e-e17102C30SPACE 
CNABitems_e-e18132C10SPACE 
Data do lançamentoitems_e-post_dat142C8febep-budat (if filled)/febep-valut 
Valor do lançamentoitems_e-amount150NC18febep-kwbtr (add to febep-sumso Item amount
    or febep-sumha) 
Tipo lançamentoitems_e-dcind168C1"D" or "C"/febep-epvoz ("S" or "H")Debit/credit indicator
categoriaitems_e-category169C3febep-vgextReturn code: Extranal trans code
Cód banco lançamentoitems_e-tcode_ba172C4  
Históricoitems_e-history176C25  
Número do documentoitems_e-xblnr201C20febep-chect/febep-xblnr/febre-vwezwReference doc number
CNABitems_e-filler22119  

Lot Trailler

Cod. Do bancoJ_1BDMEXT2-T2010C3 Bank code
Codigo do loteJ_1BDMEXT2-T2023NC4 Lot counter (sequential)
Tipo de registroJ_1BDMEXT2-T2037C1"5"Flag for lot trailer
CnabJ_1BDMEXT2-T2048C9SPACE 
 J_1BDMEXT2-T20517NC6  
 J_1BDMEXT2-T20623NC18  
 J_1BDMEXT2-T20741NC18  
 J_1BDMEXT2-T20859 up to pos. 102 
CnabLot_trailer_e-filler4102C4SPACE 
Limite da contaLot_trailer_e-ac_limit106NC18 Account limit
Valor bloqueadoLot_trailer_e-bal_blck124NC18 Amount blocked
Data do sal. fin.Lot_trailer_e-datum_end142C8 Date of final saldo
Valor do sal. finLot_trailer_e-valor_end150NC18febko-esbtrFinal saldo: Final saldo
SituacaoLot_trailer_e-dcind_end168C1"D" or "C"/febko-esvoz ("S" or "H")Situation (debit/credit): Satement debit/credit 
StatusLot_trailer_e-stats_end169C1 Status 
Quant. de registrLot_trailer_e-nr_record170NC6 Number of records
Valor debitosLot_trailer_e-totdebit176NC18 Total amount debit
Valor creditosLot_trailer_e-totcredit194NC18 Total amount credit
CnabLot_trailer_e-filler28212C28SPACE 

File Trailler

Controle bancoJ_1BDMEXT1-T1010C3 Bank code
Controle loteJ_1BDMEXT1-T1023NC4"9999" 
Controle registroJ_1BDMEXT1-T1037C1"9"Flag for file trailer
CnabJ_1BDMEXT1-T1048C9SPACE 
Quant. de lotesJ_1BDMEXT1-T10517NC6 Lot counter
Quant. de registr.J_1BDMEXT1-T10623NC6 Record conter per file
Quant. contas conJ_1BDMEXT1-T10729C211"000000" 
 j_1BDMEXT2-J_1BCRLF240HEX2"0D0A"CR+LF

Related Content

Related Documents

Brazilian payment files - Febraban, Itaú and Bradesco

SAP Help Portal - Collection Brazil

Related SAP Notes/KBAs

SAP KBA 1633808 - Brazilian file does not have the correct number of characters per register 

 

  • No labels