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) with Itaú format.

Overview

The section below will describe all the fields needed for the records of collections remittance (Cobrança remessa) file: Header, Details,Trailler.

 

Header Record

Field NameStructureLengthTypeSource Description
Codigo do reg.J_1BDMEYH1-H010NC1"0"Hard-coded
Codigo de rem.J_1BDMEYH1-H021NC1"1"Hard-coded
Literal remessaJ_1BDMEYH1-H032C7"REMESSA"Hard-coded
Codigo do serviJ_1BDMEYH1-H049NC2"01"Hard-coded
Literal servicioJ_1BDMEYH1-H0511C15"COBRANCA"Hard-coded
Codigo da emp.J_1BDMEYH1-H0626NC12reguh-ubnkl/agency, "000", Id at house bank
    reguh-ubknt, reguh-ubkon 
 J_1BDMEYH1-H0738C8  
Nome da empr.J_1BDMEYH1-H0846C30hlp_sadr-name1Brach name
Codigo do bancoJ_1BDMEYH1-H0976NC3"341"Hard-coded
Nome do bancoJ_1BDMEYH1-H1079C15"BANCO ITAU SA"Hard-coded
Data da gravacaoJ_1BDMEYH1-H1194C6sy-datum 
 J_1BDMEYH1-H12100C294  
Num. sequencialJ_1BDMEYH1-H13394NC6"000001"Hard-coded
 J_1BDMEYH1-J_1BCRLF400HEX2"0D0A" CR+LF

Detail Record

Codigo de reg.J_1BDMEYA-A010NC1"1"Hard-coded
Codigo da insc.J_1BDMEYA-A021NC2"02"CGC code ("02" for CGC)
Numero da insc.J_1BDMEYA-A033NC14j_1bwfield-cgc_numberCGC number
Codigo da emp.J_1BDMEYA-A0417NC12J_1BDMEYH1-H06House bank data
 J_1BDMEYA-A0529C8  
Uso da emp.J_1BDMEYA-A0637C25regup-kunnr, regup-gjahrCustomer identification
Nosso numeroJ_1BDMEYA-A0762NC8regup-xref3 or "00000000"Id at house bank
Quant. de monedJ_1BDMEYA-A0870NC13regup-dmbe3 or SPACEamount in Index currency Ufir
Num. da carteiraJ_1BDMEYA-A0983NC3carteiraCarteira (group number for boletos)
Uso do bancoJ_1BDMEYA-A1086C21  
CarteiraJ_1BDMEYA-A11107C1carteira(1) or SPACECarteira code (if present)
Cod. de ocorren.J_1BDMEYA-A12108NC2t015w-dtws1Instruction code 1
Seu numeroJ_1BDMEYA-A13110C10regup-xblnr, regup-buzeiduplicata number (nota fiscal plus line item)
VencimentoJ_1BDMEYA-A14120C6regup-zfbdt, regup-zbdt+F84/hlp_duedateDue date (DDMMYY)
Valor do tituloJ_1BDMEYA-A15126NC13regup-dmbtrNominal amount
Codigo do bancoJ_1BDMEYA-A16139NC3"341"Hard-coded
AgenciaJ_1BDMEYA-A17142NC5regup-xref2 
EspecieJ_1BDMEYA-A18147NC2"01"Hard-coded
AceiteJ_1BDMEYA-A19149C1"N"Hard-coded
Data de emissaoJ_1BDMEYA-A20150C6regup-bldatPosting date (DDMMYY)
Instrucao 1J_1BDMEYA-A21156NC2t015w-dtws2Instruction code 2
Instrucao 2J_1BDMEYA-A22158NC2t015w-dtws3Instruction code 3
Juros de dia 1J_1BDMEYA-A23160NC13hlp_interestInterests per day to be paid 
Desconto ateJ_1BDMEYA-A24173C6regup-zfbdt + regup-zbdt1Skonto line
Valor de descontoJ_1BDMEYA-A25179NC13reguh-rskonTotal Skonto
Valor do I.O.FJ_1BDMEYA-A26192NC13Zeros 
AbatimentoJ_1BDMEYA-A27205NC13regup-dmbtr - reguh-rbetr - reguh-rskonAbatimento amount
Codigo de inscr.J_1BDMEYA-A28218NC2hlp_stkznCGC-Code business partner
Numero de inscr.J_1BDMEYA-A29220NC14hlp_taxcodeCGC-Number business partner
NomeJ_1BDMEYA-A30234C30kna1-name1Name busines partner 
 J_1BDMEYA-A31264C10  
LogradouroJ_1BDMEYA-A32274C40reguh-zstraAdress business partner
BairroJ_1BDMEYA-A33314C12reguh-zort2Quarter business partner
CepJ_1BDMEYA-A34326NC8reguh-zpstl(5), reguh-zpstl+6(3)Zip code
CidadeJ_1BDMEYA-A35334C15reguh-zort1City business partner
EstadoJ_1BDMEYA-A36349C2reguh-zregiRegion business partner
SacadorJ_1BDMEYA-A37351C30  
 J_1BDMEYA-A38381C4  
Data de moraJ_1BDMEYA-A39385C6hlp_duedateDue date (DDMMYY)
PrazoJ_1BDMEYA-A40391NC2  
 J_1BDMEYA-A41393C1  
Numero sequen.J_1BDMEYA-A42394NC6cnt_records Record counter
 J_1BDMEXA-J_1BCRLF400HEX2"0D0A"CR+LF

Trailler Record

Codigo de registroJ_1BDMEYT-T010NC1"9"Hard-coded
 J_1BDMEYT-T021C393  
Numero sequen.J_1BDMEYT-T03394NC6cnt_records 
 j_1BDMEXT2-J_1BCRLF400HEX2"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