Electronic File Transfer in AR – Brazil – Technical Information

Companies in Brazil use bank services to collect customers. The Brazilian Electronic File Transfer for Receivables (CLL F034) provides the functionality to electronically transfer collection documents to banks using files in the standard CNAB format. The CLL F034 features allows companies to meet Brazilian Bank Transfer requirements by providing customers with the most important bank file formats in Brazil, as each bank has its own format.

Tables:

Setup Tables:

JL_BR_AR_BANK_INSTRUCTIONS à Bank Instruction table

JL_BR_AR_BANK_OCCURENCES à Bank Occurrences table

JL_BR_AR_REC_MET_ACCTS_ExT_ALL à Receipt Method Accounts table

Transaction Tables:

JL_BR_AR_SELECT_CONTROLS_ALL à Bank Transfer Remittance Batches selection criteria table

JL_BR_AR_SELECT_ACCOUNTS_ALL à Bank Account Distributions selection criteria table

JL_BR_AR_BORDEROS_ALL à Header for Remittance and Occurrence batches

JL_BR_AR_REMIT_BORDEROS_ALL à Bordero remittance additional information

JL_BR_AR_COLLECTION_DOCS_ALL à Collection documents associated to remittance borderos

JL_BR_AR_OCCURRENCE_DOCS_ALL à All occurrences related to the collection documents

JL_BR_AR_RET_INTERFACE_ALL à Interface table for Bank returns

JL_BR_AR_RET_INTERFACE_EXT_ALL à Interface table with rejected lines

JL_BR_AR_BANK_RETURNS_ALL à Temporary table to store bank returned occurrences.

Brazil Electronic File Transfer in Receivables

Companies in Brazil use bank services to collect customers. The Brazilian Electronic File Transfer for Receivables (CLL F034) provides the functionality to electronically transfer collection documents to banks using files in the standard CNAB format. The CLL F034 features allows companies to meet Brazilian Bank Transfer requirements by providing customers with the most important bank file formats in Brazil, as each bank has its own format.

Bank Collection Flow

Bank Collection – Setup

1.       Create Bank Accounts: Receivables à Setup à Receipt à Banks à Bank Accounts

2.       Define Format Programs: Receivables à Setup à Receipt à Format Programs

3.       Define Receipt Class: Receivables à Setup à Receipt à Receipt Classes

4.       Define Receipt method Accounts: Brazilian Localizations à Setup à Bank Collections à Receipt Method Accounts

5.       Define bank Instruction Codes: Brazilian Localization à Setup à Bank Collections à Instruction Codes

6.       Define Bank Occurrence Codes: Brazilian Localization à Setup à Bank Collections à Occurrence Codes