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 file payment remittance (pagamento remessa).

Overview

The section below will describe all the fields needed for the records of payment remittance (pagamento remessa) file: File Header, Lot Header, Segment A, Segment B, Segment E Lot Trailler, and File Trailler.

Hard-coded.

 

Header Record

Field NameStructureLengthTypeSource Description
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 insc.J_1BDMEXH1-H10517C1"2"Inscription type (CGC)
Empresa numeroJ_1BDMEXH1-H10618NC14febko-ktoihCGC number: Statement accont holder
empresa convenioJ_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 numeroJ_1BDMEXH1-H11058NC12febko-ktonr/febko-absnd+15account number without control digits
Conta numero 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 codigoJ_1BDMEXH1-H116142C1"2"means RETORNO (return file)
Data de gen.J_1BDMEXH1-H117143C8febko-azdat/febko-azidt(8)creation date (DDMMYYYY): statement date
Hora de gen.J_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 
servicoJ_1BDMEXH1-H121228C2  
ocorrenciasJ_1BDMEXH1-H121230C10  
 J_1BDMEXH1-J_1BCRLF240HEX2"0D0A" CR+LF

Lot Header

Codigo do bancoJ_1BDMEXH2-H2010C3 Bank Code 
Codigo 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 operacaoJ_1BDMEXH2-H2048C1"E"Extrato
Tipo de servicioJ_1BDMEXH2-H2059NC2"04"/ febko-ktosb+14Indentifier: Extrato: account spec name
Forma de lancJ_1BDMEXH2-H20611NC2febko-ktosb+11account spec name
Layout do loteJ_1BDMEXH2-H20713C3"020 "layout version number
Empresa inscricaoJ_1BDMEXH2-H20816C1  
Tipo da empresoJ_1BDMEXH2-H20917C1"2" or "1"CGC (2)  or CPF(1)
      
Num. da empresaJ_1BDMEXH2-H21018NC15  
Cod. con. bancoJ_1BDMEXH2-H21133C20 Identification number at bank
Cod. AgenciaJ_1BDMEXH2-H21253NC5 Agency (bank key)
DVJ_1BDMEXH2-H21358C1 Ceck digit for agency
Conta numeroJ_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 soldo inilot_header_e-datum_ini143C8 Date for initial balance
Valor do saldo inilot_header_e-valor_ini151NC18febko-ssbtrInitial balance: Start saldo
Situacao 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
Sequencia lot_header_e-extra_nr174C5febko-aznum/febko-emkey+6sequ. Number: statement number+G45
cnablot_header_e-filler62179C62SPACEFiller

Segment A

Codigo do bancoJ_1BDMEXA-A010C3 Bank Code
Codigo do loteJ_1BDMEXA-A023NC4 Lot counter (sequential)
Tipo de registroJ_1BDMEXA-A037C1"3"Flag for standard record
Numero do reg.J_1BDMEXA-A048NC5 record counter per lot (sequential)
SegmentoJ_1BDMEXA-A0513C1"A"segment name
Tipo de mov.J_1BDMEXA-A0614C1"0" (standard) or numberStandard transaction 
Codigo mov.J_1BDMEXA-A0715NC2"00"Standard transaction 
CompensacaoJ_1BDMEXA-A0817NC3"000" 
BancoJ_1BDMEXA-A0920NC3febep-pablz(3)Bank group business partner 
Agencia contaJ_1BDMEXA-A1023NC5febep-pablz+3(5)Bank code business partner II (Agency)
DVJ_1BDMEXA-A1128C1 control digit for account number
Numero contaJ_1BDMEXA-A1229NC12febep-paktoBank Account business partner
DVJ_1BDMEXA-A1341C1 control digit for account number
DVJ_1BDMEXA-A1442C1 control digit for agency/account number
Nome do favor.J_1BDMEXA-A1543C30febep-partnName of account holder bank business partner
Seu numeroJ_1BDMEXA-A1673C20febre-vwezw+18/febep-belnrpayment reference (reguh-vblnr)
    febep-pnota 
Data lancamentoJ_1BDMEXA-A1793C8 Valuta date payment (DDMMYYYY)
Tipo da moedaJ_1BDMEXA-A18101C3 Currency code
Quantidade moedJ_1BDMEXA-A19104NC15  
valor lancamentoJ_1BDMEXA-A20119NC15  
Nosso numeroJ_1BDMEXA-A21134C20febep-chectBank duplicata number
Data realJ_1BDMEXA-A22154C8febep-budat (if filled)/febep-valutValuta date: Item valuta date
Valor realJ_1BDMEXA-A23162C15febep-kwbtr (add to febko-sumso or Amount of single item
    febko-sumha(debit or credit)
Informacao2J_1BDMEXA-A24177C20  
Informacao2J_1BDMEXA-A25197C16  
Inf.2 /cnabJ_1BDMEXA-A26213C16lot_header_p-h206/lot_header_p-205Payment form
    add to febre-vwezw 
AvisoJ_1BDMEXA-A27229C1  
OcorenciasJ_1BDMEXA-A28230C10febep-vgextReturn code: Statement external code
 J_1BDMEXA-J_1BCRLF240HEX2"0D0A"CR+LF

Segment B

Codigo do bancoJ_1BDMEXB-B010C3 Bank Code 
Codigo do loteJ_1BDMEXB-B023NC4 Lot counter (sequential)
Tipo de reg.J_1BDMEXB-B037C1"3"Flag for standard record
Numero do regis.J_1BDMEXB-B048NC5 record counter per lot (sequential)
Codigo do segmJ_1BDMEXB-B0513C1"B"segment name
BrancosJ_1BDMEXB-B0614C3SPACE 
Insc. tipo favor.J_1BDMEXB-B0717C1 ("01" for CPF, "02" for CGC)
Numero de inscr.J_1BDMEXB-B0818NC14 Tax number of bus. Partner
EnderecoJ_1BDMEXB-B0932C30 Street and house number of bus. Partner
NumeroJ_1BDMEXB-B1062C5 Bank code business partner II (Agency)
ComplementoJ_1BDMEXB-B1167C15  
BairroJ_1BDMEXB-B1282C15 District of business partner
CidadeJ_1BDMEXB-B1397C20 City of business partner
CepJ_1BDMEXB-B14117NC5 Zip code business partner
Compl. CepJ_1BDMEXB-B15122C3 Complement zip code
EstadoJ_1BDMEXB-B16125C2 Region business partner
 J_1BDMEXB-B17127C113SPACE 
 J_1BDMEXB-J_1BCRLF240HEX2"0D0A"CR+LF
Codigo do bancoitems_e-e010C3 Bank Code 

Segment E

Codigo do loteitems_e-e023NC4 Lot counter (sequential)
Tipo de reg.items_e-e037C1"3"Flag for standard record
Numero do regis.items_e-e048NC5 record counter per lot (sequential)
Codigo do segmitems_e-e0513C1"E"seg+G249ment name
Brancositems_e-e0614C1  
Brancositems_e-e0715C2 ("01" for CPF, "02" for CGC)
Numero de inscr.items_e-e0817C1 tax number of company
Convenioitems_e-e0918NC14  
Cod conta corritems_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
Compl. Cepitems_e-e1571C1 Complement zip code
Estadoitems_e-e1672C30 Region business partner
Cnabitems_e-e17102C30SPACE 
Cnabitems_e-e18132C10SPACE 
Data do lanc.items_e-post_dat142C8febep-budat (if filled)/febep-valut 
Valor do lancitems_e-amount150NC18febep-kwbtr (add to febep-sumso Item amount
    or febep-sumha) 
Tipo lanc.items_e-dcind168C1"D" or "C"/febep-epvoz ("S" or "H")Debit/credit indicator
categoriaitems_e-category169C3febep-vgextReturn code: Extranal trans code
Cod banco lancitems_e-tcode_ba172C4  
Historicoitems_e-history176C25  
No 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