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 collections remittance  (Cobrança remessa).

Overview

The section below will describe all the fields needed for the records of collections remittance (Cobrança remessa) file: File Header, Lot Header, Segment P, Segment Q, Lot Trailler, and File Trailler.

Hard-coded

Header Record

Field NameStructureLengthTypeSource Description
BancoJ_1BDMEXH1-H1010C3reguh-ubnkl(3)Bank Code 
LoteJ_1BDMEXH1-H1023NC4"0000"Lot Counter
RegistroJ_1BDMEXH1-H1037C1"0"Hard-coded
CNABJ_1BDMEXH1-H1048C9SPACEHard-coded
TipoJ_1BDMEXH1-H10517C1"2"Inscription type (CGC)
No de inscricaoJ_1BDMEXH1-H10618NC14j_1bwfield-cgc_numberCGC number
Cod. de convenioJ_1BDMEXH1-H10732C20t045t-dtaidIdentification number at bank
Codigo agenciaJ_1BDMEXH1-H10852NC5reguh-ubnkl+4/agencyIdentification number at bank
DV agenciaJ_1BDMEXH1-H10957C1reguh-ubkntcontrol digit for account number
Numero contaJ_1BDMEXH1-H11058NC12reguh-ubknt/regud-obkntaccount number without control digits
DV contaJ_1BDMEXH1-H11170C1reguh-ubkntcontrol digit for account number
DV contaJ_1BDMEXH1-H11271C1reguh-ubkntcontrol digit for account number
Nome da empresaJ_1BDMEXH1-H11372C30hlp_sadr-name1Brach name
Nome do bancoJ_1BDMEXH1-H114102C30regud-ubnkaName of house bank
CNABJ_1BDMEXH1-H115132C10SPACE 
Codigo arquivoJ_1BDMEXH1-H116142C1"1"Hard-coded
Data de geracaoJ_1BDMEXH1-H117143C8sy-datumactual date (DDMMYYYY)
Hora de geracaoJ_1BDMEXH1-H118151C6sy-uzeitactual time
sequencia/layoutJ_1BDMEXH1-H119157NC9hlp_resultat+2(6)"030"Febraban: File number and version
densidadeJ_1BDMEXH1-H120166NC5ZEROS 
reserv. /servicioJ_1BDMEXH1-H121171C69SPACE(20)hlp_resutatinternal TemSe file number 
 J_1BDMEXH1-J_1BCRLF240HEX2"0D0A" CR+LF

Lot Header

BancoJ_1BDMEXH3-H3010C3reguh-ubnkl(3)Bank Code ("341" for ITAU)
LoteJ_1BDMEXH3-H3023NC4"1"Lot counter (sequential)
RegistroJ_1BDMEXH3-H3037C1"1"Hard-coded
OperacaoJ_1BDMEXH3-H3048C1"R"Hard-coded
ServicoJ_1BDMEXH3-H3059NC2"1"Hard-coded
Forma lanctoJ_1BDMEXH3-H30611NC2"00"payment form (01,02,03,10,30,31)
Layout J_1BDMEXH3-H30713C3"020 "layout version number
CNABJ_1BDMEXH3-H30816C1SPACEHard-coded
Tipo insc. da empJ_1BDMEXH3-H30917C1"2"Inscription type (CGC)
NumeroJ_1BDMEXH3-H31018NC15j_1bwfield-cgc_numberCGC number
ConvenioJ_1BDMEXH3-H31133C20J_1BDMEXH1-H107Identification number at bank
Codigo agenciaJ_1BDMEXH3-H31253NC5J_1BDMEXH1-H108Identification number at bank
DV J_1BDMEXH3-H31358C1J_1BDMEXH1-H109control digit for account number
Numero da contaJ_1BDMEXH3-H31459NC12J_1BDMEXH1-H110account number without control digits
DV numeroJ_1BDMEXH3-H31571C1J_1BDMEXH1-H111control digit for account number
DV contaJ_1BDMEXH3-H31672C1J_1BDMEXH1-H112control digit for account number
Nome da emp.J_1BDMEXH3-H31773C30J_1BDMEXH1-H113Brach name
Informacao1J_1BDMEXH3-H318103C40SPACE 
Informacao 2J_1BDMEXH3-H319143C40SPACE 
No rem/retJ_1BDMEXH3-H320183NC8SPACE 
Dta gravacaoJ_1BDMEXH3-H321191C8sy-datumactual date (DDMMYYYY)
Data do creditoJ_1BDMEXH3-H322199NC8SPACE 
CnabJ_1BDMEXH3-H322197C33SPACE 
 J_1BDMEXH3-J_1BCRLF330HEX2SPACE 

Segment P

BancoJ_1BDMEXP-P010NC3reguh-ubnkl(3)Bank code
LoteJ_1BDMEXP-P023NC4"1"Lot counter (sequential)
RegistroJ_1BDMEXP-P037NC1"3"Hard-coded
No do registr.J_1BDMEXP-P048NC5cnt_postenrecord counter per lot (sequential)
segmentoJ_1BDMEXP-P0513C1"P" 
CnabJ_1BDMEXP-P0614C1  
Codigo de mov.J_1BDMEXP-P0715NC2t015w-dtws1Instruction
Codigo agenciaJ_1BDMEXP-P0817NC5reguh-ubnkl+4/agencyIdentification number at bank
DV agenciaJ_1BDMEXP-P0922C1reguh-ubkntcontrol digit for account number
Numero contaJ_1BDMEXP-P1023NC12reguh-ubknt/regud-obkntaccount number without control digits
DV contaJ_1BDMEXP-P1135C1reguh-ubkntcontrol digit for account number
DV contaJ_1BDMEXP-P1236C1reguh-ubkntcontrol digit for account number
Nosso numeroJ_1BDMEXP-P1337C20regup-xref3 or SpaceBoleto number (if present)
CarteiraJ_1BDMEXP-P1457C1carteira(1)Boleto group
CadastramentoJ_1BDMEXP-P1558C1carteira+1(1)Boleto group
DocumentoJ_1BDMEXP-P1659C1"2" 
EmissaoJ_1BDMEXP-P1760C1carteira+2(1)Boleto group
Distrib bloquetoJ_1BDMEXP-P1861C1carteira+3(1)Boleto group
No do docum.J_1BDMEXP-P1962C15regup-xblnr(6), regup-buzeiDocument line for clearing
VencimentoJ_1BDMEXP-P2077C8regup-zfbdt/hlp_duedateDue date (DDMMYYYY)
Valor do tituloJ_1BDMEXP-P2185NC15regud-dmbtrNominal amount
Ag. cobradoraJ_1BDMEXP-P22100NC5regup-xref2 
DVJ_1BDMEXP-P23105C1regup-xref2+5(1) 
Especie tituloJ_1BDMEXP-P24106NC2"02" 
AceiteJ_1BDMEXP-P25108C1"N" 
Data emissao J_1BDMEXP-P26109C8regup-bldatEmission date (DDMMYYYY)
Cod. juros moraJ_1BDMEXP-P27117NC1"3" (no interests) or "1" (interests)Flag for interests
Data jurosJ_1BDMEXP-P28118C8hlp_duedate; SpaceDate for Interests (only if -P27 = "1")
Juros moraJ_1BDMEXP-P29126NC15hlp_interest; SpaceAmount of interests per day (only if -P27 = "1")
Cod. des 1J_1BDMEXP-P30141NC1"0" (no skonto); "1" (skonto)Skonto flag
Data des. 1J_1BDMEXP-P31142C8regup-zfbdt + regup-zfbd1; SpaceSkonto line (only if -P30 = "1")
Desconto 1J_1BDMEXP-P32150NC15reguh-rskonSkonto amount (only if -P30 = "1")
Vlr IOFJ_1BDMEXP-P33165NC15  
Vlr abatimentoJ_1BDMEXP-P34180NC15regup-dmbtr - reguh-rbetr - reguh-rskonAbatimento
Uso empresaJ_1BDMEXP-P35195C25regup-kunnr, regup-belnr, regup-gjahrAdd. Data for clearing
Codigo protestoJ_1BDMEXP-P36220C1"3"; "1"("3" no protest, "1" portest)
Prazo protestoJ_1BDMEXP-P37221NC2Zero; t015w-dtws2Instruction for protest
Codigo baixaJ_1BDMEXP-P38223C1"2"; "1"("1" if -P07 = 2); else "2"
Prazo baixaJ_1BDMEXP-P39224NC3ZEROS 
Codiga da moedaJ_1BDMEXP-P40227NC2"09"Currency code (Real)
No da contratoJ_1BDMEXP-P41229NC10ZEROS 
CnabJ_1BDMEXP-P42239C1ZEROS 
 J_1BDMEXP-J_1BCRLF240HEX2"0D0A"CR+LF

Segment Q

BancoJ_1BDMEXQ-Q010C3reguh-ubnkl(3)Bank Code 
LoteJ_1BDMEXQ-Q023NC4"0001"Lot counter 
RegistroJ_1BDMEXQ-Q037C1"3"Register type
No do registroJ_1BDMEXQ-Q048NC5cnt_postendetail counter
SegmentoJ_1BDMEXQ-Q0513C1"Q"segement name
CnabJ_1BDMEXQ-Q0614C1  
Cod. MovJ_1BDMEXQ-Q0715NC2J_1BDMEXP-P07Instruction
Tipo insc.J_1BDMEXQ-Q0817NC1hlp_stkznCGC code (1: natural person, 2 company)
Numero insc.J_1BDMEXQ-Q0918NC15hlp-taxcodeCGC number
NomeJ_1BDMEXQ-Q1033C40kna1-name1Name of business partner
EndereceoJ_1BDMEXQ-Q1173C40reguh-zstraAdress data business partner
BairroJ_1BDMEXQ-Q12113C15reguh-zort2Quarter business partner
CepJ_1BDMEXQ-Q13128NC5reguh-zpstl(5)Zip code
Sufixo do cepJ_1BDMEXQ-Q14133NC3reguh-zpstl+6(3)Zip code suffix
CidadeJ_1BDMEXQ-Q15136C15reguh-zort1City business partner
UfJ_1BDMEXQ-Q16151C2reguh-zregiState business partner
Tipo insc.J_1BDMEXQ-Q17153NC1ZERO 
numero insc.J_1BDMEXQ-Q18154NC15ZEROS 
Nome insc.J_1BDMEXQ-Q19169C40SPACE 
Banco corresp.J_1BDMEXQ-Q20209NC3ZEROS 
N. num. bco. cor.J_1BDMEXQ-Q21212C20J_1BDMEXP-P13Boleto number (if present)
CNABJ_1BDMEXQ-Q22232C8SPACE 
 J_1BDMEXQ-Q_1BCRLF240HEX2"0D0A"CR+LF

Lot Trailler

BancoJ_1BDMEXT3-T3010C3reguh-ubnkl(3)Bank Code
LoteJ_1BDMEXT3-T3023NC4"0001" 
RegistroJ_1BDMEXT3-T3037C1"5" 
CnabJ_1BDMEXT3-T3048C9  
Qtde de registrosJ_1BDMEXT3-T30517NC6cnt_posten  + 2 Records in this lot: cnt_rec_perlot plus header and trailer
Tot. Da cobr. Sim.J_1BDMEXT3-T30623NC6ZEROS 
 J_1BDMEXT3-T30729NC17ZEROS 
Tot. Da cobr. Vinc.J_1BDMEXT3-T30846NC6ZEROS 
 J_1BDMEXT3-T30952NC17ZEROS 
Tot. Da cobr. Cau.J_1BDMEXT3-T31069NC6ZEROS 
 J_1BDMEXT3-T31175NC17ZEROS 
Tot. Da cobr. Des.J_1BDMEXT3-T31292NC6ZEROS 
 J_1BDMEXT3-T31398NC17ZEROS 
No do avisoJ_1BDMEXT3-T314115C8SPACE 
CNABJ_1BDMEXT3-T315123C117SPACE 
 j_1BDMEXT2-J_1BCRLF240HEX2"0D0A"CR+LF

File Trailler

BancoJ_1BDMEXT1-T1010C3reguh-ubnkl(3)Bank Code ("341" for ITAU)
LoteJ_1BDMEXT1-T1023NC4"9999" 
RegistroJ_1BDMEXT1-T1037C1"9" 
CNABJ_1BDMEXT1-T1048C9SPACE 
Qtde de lotesJ_1BDMEXT1-T10517NC6"000001" 
Qtde de registrosJ_1BDMEXT1-T10623NC6cnt_records, "000000" 
Qwtde contas con.J_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

1 Comment

  1. Thank you very much for the updates Renan!

    Is there any plan to make it available the segment R where we can indicate to the banks the "Fee" (the fields are in the segment R of the FEBRABAN manual, version 8.7, page 57, fields 14.3R, 15.3R and 16.3R)?

    Regards,

    Daniel Carvalho